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; }