ringo667 2 Posted September 14, 2015 Hello, i search for a contrib that sort Products by a List an not by a Dropdown an i find this: http://addons.oscommerce.com/info/8592 Can someone help to make this fitting for 2.3.3.4 BS? Share this post Link to post Share on other sites
ringo667 2 Posted September 14, 2015 <?php // optional Product List Filter if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { ?> <div class="panel-body text-center"> <? if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo '<div class="panel panel-default" style="width:100%"><div class="panel-heading gradient"><center><h1>' . $catname. '</h1></center></div><br> <div class="">';} else { echo '<div class="panel panel-default" style="width:100%"><div class="panel-heading gradient"><center><h1>' . $catname . '</h1></center></div> <br><div class="">';} if (isset($HTTP_GET_VARS['manufacturers_id'])) { ?> <a class="btn btn-default" href="<?=tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'])?>"><?=TEXT_ALL_CATEGORIES?></a> <? } else { ?> <a class="btn btn-default" href="<?=tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cPath)?>"><?=TEXT_ALL_MANUFACTURERS?></a> <? } while ($filterlist = tep_db_fetch_array($filterlist_query)) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filter_keys = 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id']; } else { $filter_keys = 'cPath=' . $cPath; } $filter_keys .= '&sort=' . $HTTP_GET_VARS['sort']; $filter_keys .= '&filter_id=' . $filterlist['id']; ?> <a class="btn btn-<? if(isset($_GET['filter_id']) && $_GET['filter_id'] == $filterlist['id']) {echo 'gradient';} else { echo 'default';} ?>" href="<?=tep_href_link(FILENAME_DEFAULT, $filter_keys)?>"><span class="filter_name"><?=$filterlist['name']?></span></a> <? } ?> <br> <br> </div></div></div> <?php } ?> So it works for me in the index.php with Buttons... Maybe someone can use this. Share this post Link to post Share on other sites