Sort Product by minimum_bid

[auctions4you]

Was wondering want is the best way to sort the products in the product_public_list.html,
Would like the products to be sorted by minimum_bid instead of by Product_id, anyone can help.
Thanks
http://www.auctions4you.co.uk/catalogue/index.php?-action=list&-table=products

here our current product_public_list.html



{foreach from=$products item=product name=product}
getURL('-action=view')}">

{$product->display('product_name')}

display('product_image')}" width="75"/>

{$product->preview('product_description')}

Lot# {$product->display('product_lot')}

Minimum Bid

{$product->display('minimum_bid')}

Current Bid

{$product->display('current_high_bid')}

{/foreach}

{result_controller}

[shannah]

Hi Phil,

In the tables/products/products.php file, find the method:
functionÊblock__result_list(){
ÊÊÊÊÊÊÊÊifÊ(ÊisAdmin()Ê)ÊreturnÊPEAR::raiseError("JustÊshowÊtheÊdefaultÊlist");
ÊÊÊÊÊÊÊÊ$appÊ=&ÊDataface_Application::getInstance();
ÊÊÊÊÊÊÊÊ$queryÊ=&Ê$app->getQuery();
ÊÊÊÊÊÊÊÊ$productsÊ=Êdf_get_records_array('products',Ê$query);
ÊÊÊÊÊÊÊÊdf_display(array('products'=>&$products),Ê'public_product_list.html');
ÊÊÊÊ}
Then add the following line:
$query['-sort'] = 'minimum_bid asc';
so that it becomes:
functionÊblock__result_list(){
ÊÊÊÊÊÊÊÊifÊ(ÊisAdmin()Ê)ÊreturnÊPEAR::raiseError("JustÊshowÊtheÊdefaultÊlist");
ÊÊÊÊÊÊÊÊ$appÊ=&ÊDataface_Application::getInstance();
ÊÊÊÊÊÊÊÊ$queryÊ=&Ê$app->getQuery();
ÊÊÊÊÊÊÊ $query['-sort'] = 'minimum_bid asc';
ÊÊÊÊÊÊÊÊ$productsÊ=Êdf_get_records_array('products',Ê$query);
ÊÊÊÊÊÊÊÊdf_display(array('products'=>&$products),Ê'public_product_list.html');
ÊÊÊÊ}

[auctions4you]

Steve,
Thanks again,works great
any news on the reserve mod?

[jnewman67]

i found a "default action" solution, and one-time edit to make it stick.

i wanted all listings to be sorted by product_name - the default is to sort them by product_id.

you can change the default action in conf/ApplicationDelegate.php:

Code: Select all

        function getPreferences(){
                $app =& Dataface_Application::getInstance();
                $query =& $app->getQuery();
                if ( $query['-table'] == 'products' and !isset($query['-sort']) ){
                        $query['-sort'] = 'product_id asc';
                }


to

Code: Select all

        function getPreferences(){
                $app =& Dataface_Application::getInstance();
                $query =& $app->getQuery();
                if ( $query['-table'] == 'products' and !isset($query['-sort']) ){
                        $query['-sort'] = 'product_name asc';
                }


simple interpreted: if no sort argument is passed in, then set the default sort order to "ORDER BY product_name ASC".

change it for your needs as required.