* * $Id: store.edit.list.php,v 1.10 2008/06/24 19:34:47 sbeam Exp $ */ require_once CONFIG_DIR . 'cshop.config.php'; require_once "fu_HTML_Table.class.php"; require_once "filter_form.class.php"; require_once "res_pager.class.php"; require_once "store.edit.inc.php"; /** **/ $range = 50; $offset = isset($_GET['page']) ? ($_GET['page'] - 1) * $range : 0; $filt = new filter_form('GET'); $filt->left_td_style = ''; $filt->field_prefix = ''; $filt->add_element('hdr1', array('Category:', 'heading')); $filt->add_element('cat', array('', 'select', cshopUtils::get_all_categories($pdb, true))); $filt->add_element('hdr2', array('Manufacturer', 'heading')); $filt->add_element('mfr', array('', 'select', cshopUtils::get_all_manufacturers($pdb, true))); $filt->add_element('hdr3', array('SKU', 'heading')); $filt->add_element('sku', array('', 'text', '', array('size' => 5))); $filt->add_element('op_filter', array('GO', 'submit')); /** if there were things selected in the filter forms then make up some WHERE * clauses to narrow the results */ $where = ''; $getvars = ''; if (isset($_GET['mfr']) or isset($_GET['cat'])) { $where = 'WHERE 1=1 '; if (!empty($_GET['mfr'])) { $where .= ' AND cm_manufacturers_id = ' . $pdb->quoteSmart($_GET['mfr']); $getvars .= '&mfr=' . urlencode($_GET['mfr']); }