foreach ($cols as $k) {
$vals[] = $row[$k];
}
$vals[] = $row['num_orders'];
$link = sprintf('%s?%s=%d', $_SERVER['PHP_SELF'], $reqIdKey, $row['id']);
$table->addRow($vals, '', false, $link);
}
}
$pager = new res_pager($offset, $range, $numrows, 0, 26);
$smarty->assign('pager', $pager);
/** create filter form **/
$colmap = $user->get_colmap();
$filt = new filter_form('GET');
$filt->left_td_style = '';
$filt->field_prefix = '';
$filt->add_element('hdr1', array('<b>Filter by::</b>', 'heading'));
if (isset($colmap['perms'])) {
$filt->add_element('hdr1', array('Permissions:', 'heading'));
$filt->add_element('f_perms', array('', 'select', null));
}
$filt->add_element('hdr2', array('email:', 'heading'));
$filt->add_element('f_email', array('', 'text', null, array('size' => 20)));
$filt->add_element('op_filter', array('GO', 'submit'));
if (isset($colmap['perms'])) {
$filt->set_element_opts('f_perms', array('' => '[ANY]') + $colmap['perms'][2]);
}
}
$tab = 'user';
##############################################################################
# output template
##############################################################################
}
$link = vsprintf($link_fmt, $args);
}
foreach (array_keys($header_row) as $k) {
$vals[] = $row[$k];
}
$table->addRow($vals, null, !empty($link), $link);
}
$numrows = $prod->numRows;
$pager = new res_pager($offset, $range, $numrows);
$smarty->assign('pager', $pager);
$produx = array('' => '[ANY]') + $prod->get_product_list('title');
$filt = new filter_form('GET');
$filt->left_td_style = '';
$filt->field_prefix = '';
$filt->add_element('hdr1', array('<b>Filter by::</b> Product:', 'heading'));
$filt->add_element('pid', array('', 'select', $produx));
$filt->add_element('hdr2', array('Category:', 'heading'));
$filt->add_element('cat', array('', 'select', $prod->get_product_category_options(true)));
$filt->add_element('op_filter', array('GO', 'submit'));
##############################################################################
# output template
##############################################################################
$smarty->display('control/header.tpl');
?>
<div style="width: 90%; margin: 2em auto;">
<h2 class="headline">Inventory Report</h2>
<p>
Click on a row to edit inventory values for the product.
</p>
* @todo page result sets
*
* $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']);
}
if (empty($orderinfo['delivery_date'])) {
$fex->elem_vals['delivery_date'] = date('Y-m-d');
}
$smarty->assign('upform', $fex->get_struct());
$pagetitle = 'ORDER DETAIL - ' . $itemid;
/* */
$SHOWFORM = 1;
} else {
/** create filter form **/
$filter_columns = array('order.id' => 'Order ID', 'order.token' => 'Order Number', 'user.email' => 'customer email', 'user.name' => 'customer name');
$filt = new filter_form('GET');
$filt->left_td_style = '';
$filt->right_td_style = '';
$filt->field_prefix = '';
$filt->add_element('hdr1', array('<b>Filter by::</b>', 'heading'));
$filt->add_element('fc', array('', 'select', null));
$filt->add_element('hdr2', array('=', 'heading'));
$filt->add_element('fq', array('', 'text', null, array('size' => 15)));
$filt->add_element('hdr3', array(' Status:', 'heading'));
$filt->add_element('status', array('', 'select', null));
$filt->add_element('op_filter', array('GO', 'submit'));
$filt->set_element_opts('status', array('' => '[ANY]') + $order->get_statuses());
$filt->set_element_opts('fc', $filter_columns);
/** decide on which result page to show **/
$range = 50;
$offset = isset($_GET['page']) ? ($_GET['page'] - 1) * $range : 0;
/** **/
/** decide how to order the results */
$orderable = array('ord.id', 'order_create_date', 'email', 'orders_status', 'amt_quoted', 'perms', 'ship_date');
if (isset($_GET['by']) and in_array($_GET['by'], $orderable)) {
