It think it only becomes apparent when you add more options.
This is what I did, the extra products options work but the extra category ones not.
The code on both the product and category listings runs through both switch groups rather than one or the other.
Categories.php
Line 614
Change
PHP Code:
if ($zc_skip_products == true) {
// toggle switch for display sort order
$categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_CATEGORIES_SORT_ORDER_PRODUCTS_NAME),
array('id' => '1', 'text' => TEXT_SORT_CATEGORIES_NAME)
);
} else {
// toggle switch for display sort order
$categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME),
array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME),
array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL),
array('id' => '3', 'text'=> TEXT_SORT_PRODUCTS_QUANTITY),
array('id' => '4', 'text'=> TEXT_SORT_PRODUCTS_QUANTITY_DESC),
array('id' => '5', 'text'=> TEXT_SORT_PRODUCTS_PRICE),
array('id' => '6', 'text'=> TEXT_SORT_PRODUCTS_PRICE_DESC)
);
}
To
PHP Code:
if ($zc_skip_products == true) {
// toggle switch for display sort order
$categories_products_sort_order_array = array(
array('id' => '0', 'text' => TEXT_SORT_CATEGORIES_SORT_ORDER_PRODUCTS_NAME),
array('id' => '1', 'text' => TEXT_SORT_CATEGORIES_NAME),
array('id' => '2', 'text' => TEXT_SORT_CATEGORIES_ID),//steve new
array('id' => '3', 'text' => TEXT_SORT_CATEGORIES_ID_DESC)//steve new
);
} else {
// toggle switch for display sort order, steve added more
$categories_products_sort_order_array = array(
array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME),
array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME),
array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL),
array('id' => '3', 'text'=> TEXT_SORT_PRODUCTS_QUANTITY),
array('id' => '4', 'text'=> TEXT_SORT_PRODUCTS_QUANTITY_DESC),
array('id' => '5', 'text'=> TEXT_SORT_PRODUCTS_PRICE),
array('id' => '6', 'text'=> TEXT_SORT_PRODUCTS_PRICE_DESC),
array('id' => '7', 'text'=> TEXT_SORT_PRODUCTS_MODEL_DESC),//steve new
array('id' => '8', 'text'=> TEXT_SORT_PRODUCTS_STATUS),//steve new
array('id' => '9', 'text'=> TEXT_SORT_PRODUCTS_ID),//steve new
array('id' => '10', 'text'=> TEXT_SORT_PRODUCTS_WEIGHT)//steve new
);
}
Category_product_listing.php
Line 81
PHP Code:
<?php
switch ($_SESSION['categories_products_sort_order']) {
case (0):
$order_by = " order by c.sort_order, cd.categories_name";
break;
case (1):
$order_by = " order by cd.categories_name";
case (2);
case (3);
case (4);
case (5);
case (6);
}
To
PHP Code:
<?php echo __LINE__.":switch categories";
switch ($_SESSION['categories_products_sort_order']) {
case (0):
$order_by = " order by c.sort_order, cd.categories_name";
break;
case (1):
$order_by = " order by cd.categories_name";
case (2)://steve added
$order_by = " order by cd.categories_id";
case (3)://steve added
$order_by = " order by cd.categories_id DESC";
case (4);
case (5);
case (6);
}
And
Line 191
PHP Code:
switch ($_SESSION['categories_products_sort_order']) {
case (0):
$order_by = " order by p.products_sort_order, pd.products_name";
break;
case (1):
$order_by = " order by pd.products_name";
break;
case (2);
$order_by = " order by p.products_model";
break;
case (3);
$order_by = " order by p.products_quantity, pd.products_name";
break;
case (4);
$order_by = " order by p.products_quantity DESC, pd.products_name";
break;
case (5);
$order_by = " order by p.products_price_sorter, pd.products_name";
break;
case (6);
$order_by = " order by p.products_price_sorter DESC, pd.products_name";
break;
}
To
PHP Code:
echo __LINE__.":switch products";//steve debug
switch ($_SESSION['categories_products_sort_order']) {
case (0):
$order_by = " order by p.products_sort_order, pd.products_name";
break;
case (1):
$order_by = " order by pd.products_name";
break;
case (2);
$order_by = " order by p.products_model";
break;
case (3);
$order_by = " order by p.products_quantity, pd.products_name";
break;
case (4);
$order_by = " order by p.products_quantity DESC, pd.products_name";
break;
case (5);
$order_by = " order by p.products_price_sorter, pd.products_name";
break;
case (6);
$order_by = " order by p.products_price_sorter DESC, pd.products_name";
break;
case (7);//steve added
$order_by = " order by p.products_model DESC";
break;
case (8);//steve added
$order_by = " order by p.products_status";
break;
case (9);//steve added
$order_by = " order by p.products_id";
break;
case (10);//steve added
$order_by = " order by p.products_weight";
break;
}
You'll see it does not sort the categories by id.
Bookmarks