function preprocess()
{
global $FANNIE_OP_DB;
$this->title = _("Fannie") . ' : ' . _("Manufacturer Shelf Tags");
$this->header = _("Manufacturer Shelf Tags");
if (FormLib::get_form_value('manufacturer', False) !== false) {
$manu = FormLib::get_form_value('manufacturer');
$pageID = FormLib::get_form_value('sID', 0);
$cond = "";
if (is_numeric($_REQUEST['manufacturer'])) {
$cond = " p.upc LIKE ? ";
} else {
$cond = " p.brand LIKE ? ";
}
$dbc = FannieDB::get($FANNIE_OP_DB);
$prodP = $dbc->prepare_statement("\n SELECT\n p.upc\n FROM\n products AS p\n WHERE {$cond}\n ");
$prodR = $dbc->exec_statement($prodP, array('%' . $manu . '%'));
$tag = new ShelftagsModel($dbc);
$product = new ProductsModel($dbc);
while ($prodW = $dbc->fetch_row($prodR)) {
$product->upc($prodW['upc']);
$info = $product->getTagData();
$tag->id($pageID);
$tag->upc($prodW['upc']);
$tag->setData($info);
$tag->save();
}
$this->msgs = '<em>Created tags for manufacturer</em>
<br /><a href="ShelfTagIndex.php">Home</a>';
}
return true;
}
function preprocess()
{
global $FANNIE_OP_DB;
if (FormLib::get_form_value('deptStart', False) !== false) {
$start = FormLib::get_form_value('deptStart');
$end = FormLib::get_form_value('deptEnd');
$pageID = FormLib::get_form_value('sID', 0);
$dbc = FannieDB::get($FANNIE_OP_DB);
$prodP = $dbc->prepare_statement("\n SELECT p.upc\n FROM products AS p\n WHERE p.department BETWEEN ? AND ?\n ");
$prodR = $dbc->exec_statement($prodP, array($start, $end));
$tag = new ShelftagsModel($dbc);
$product = new ProductsModel($dbc);
while ($row = $dbc->fetch_row($prodR)) {
$product->upc($row['upc']);
$info = $product->getTagData();
$tag->id($pageID);
$tag->upc($row['upc']);
$tag->setData($info);
$tag->save();
}
$this->msgs = sprintf('<em>Created tags for departments #%d through #%d</em>
<br /><a href="ShelfTagIndex.php">Home</a>', $start, $end);
}
return true;
}
