public function get_id_confirm_view() { $dbc = $this->connection; $dbc->selectDB($this->config->get('OP_DB')); $upc = BarcodeLib::padUPC($this->id); $model = new ProductsModel($dbc); $model->upc($upc); foreach ($model->find('store_id') as $obj) { $obj->delete(); } if (substr($upc, 0, 3) == '002') { $scaleQ = $dbc->prepare_statement("DELETE FROM scaleItems WHERE plu=?"); $dbc->exec_statement($scaleQ, array($upc)); $plu = substr($upc, 3, 4); \COREPOS\Fannie\API\item\HobartDgwLib::deleteItemsFromScales($plu); \COREPOS\Fannie\API\item\EpScaleLib::deleteItemsFromScales($plu); } $userP = $dbc->prepare("DELETE FROM productUser WHERE upc=?"); $dbc->execute($userP, array($upc)); if ($dbc->tableExists('prodExtra')) { $extraP = $dbc->prepare("DELETE FROM prodExtra WHERE upc=?"); $dbc->execute($extraP, array($upc)); } return '<div class="alert alert-success">Item deleted</div>'; }
if ($graphics) { $item_info['Graphics'] = $graphics; } // normalize type + bycount; they need to match if ($item_info['ByCount'] && $s_type == 'Random Weight') { $item_info['Type'] = 'By Count'; } else { if ($s_type == 'Fixed Weight') { $item_info['Type'] = 'Fixed Weight'; $item_info['ByCount'] = 1; } else { $item_info['Type'] = 'Random Weight'; $item_info['ByCount'] = 0; } } \COREPOS\Fannie\API\item\HobartDgwLib::writeItemsToScales($item_info); } $udesc = isset($_REQUEST['u_desc']) ? $_REQUEST['u_desc'] : ''; $ubrand = isset($_REQUEST['u_brand']) ? $_REQUEST['u_brand'] : ''; $usize = isset($_REQUEST['u_size']) ? $_REQUEST['u_size'] : ''; $utext = isset($_REQUEST['u_long_text']) ? $_REQUEST['u_long_text'] : ''; $utext = str_replace("\r", "", $utext); $utext = str_replace("\n", "<br />", $utext); $utext = preg_replace("/[^-]/", "", $utext); // strip non-ASCII (word copy/paste artifacts) $uonline = isset($_REQUEST['u_enableOnline']) ? 1 : 0; $uexpires = isset($_REQUEST['u_expires']) ? $_REQUEST['u_expires'] : ''; if (!empty($udesc) || !empty($ubrand) || !empty($usize)) { include $FANNIE_ROOT . 'src/Credentials/OutsideDB.is4c.php'; $dbs = array($sql); $q = $sql->prepare("SELECT special_price,discounttype FROM products WHERE upc=?");
function post_sendupc_handler() { global $FANNIE_OP_DB; $model = new ScaleItemsModel(FannieDB::get($FANNIE_OP_DB)); $model->plu(BarcodeLib::padUPC($this->sendupc)); $dbc = FannieDB::get($FANNIE_OP_DB); $chkMap = $dbc->prepare(' SELECT upc FROM ServiceScaleItemMap WHERE serviceScaleID=? AND upc=? '); $addMap = $dbc->prepare(' INSERT INTO ServiceScaleItemMap (serviceScaleID, upc) VALUES (?, ?) '); $scales = $this->scalesFromIDs(FormLib::get('scaleID', array())); if ($model->load() && is_array($scales)) { $item_info = $this->getItemInfo($model); // go through scales one at a time // check whether item is present on that // scale and do write or change as appropriate foreach ($scales as $scale) { $chk = $dbc->execute($chkMap, array($scale['id'], $this->sendupc)); if ($dbc->num_rows($chk) == 0) { $dbc->execute($addMap, array($scale['id'], $this->sendupc)); $item_info['RecordType'] = 'WriteOneItem'; } else { $item_info['RecordType'] = 'ChangeOneItem'; } \COREPOS\Fannie\API\item\HobartDgwLib::writeItemsToScales($item_info, array($scale)); } echo '{error:0}'; } else { echo '{error:1}'; } return false; }