$dbc->execute($del, array($upc));
} else {
$dbs[] = $dbc;
$del = $dbc->prepare("DELETE FROM products WHERE upc=?");
$dbc->execute($del, array($upc));
$query99 = $dbc->prepare("INSERT INTO products (upc,description,normal_price,pricemethod,groupprice,quantity,special_price,specialpricemethod,\n specialgroupprice,specialquantity,start_date,end_date,department,size,tax,foodstamp,scale,scaleprice,mixmatchcode,\n modified,tareweight,discount,discounttype,unitofmeasure,wicable,qttyEnforced,idEnforced,cost,inUse,numflag,\n subdept,deposit,local)\n VALUES(?,?,?,0,0.00,0,?,0,0.00,0,'','',?,0,?,?,?,0,0,now(),0,?,\n ?,0,0,0,0,0.00,1,\n 0,0,0.00,?)");
$dbc->execute($query99, array($upc, $descript, $price, $w['special_price'], $dept, $tax, $FS, $Scale, $NoDisc, $w['discounttype'], $local));
}
foreach ($dbs as $con) {
$char = strstr($utext, "start");
$pu_model = new ProductUserModel($con);
$pu_model->upc($upc);
$pu_model->brand($ubrand);
$pu_model->description($udesc);
$pu_model->sizing($usize);
$pu_model->long_text($utext);
$pu_model->enableOnline($uonline);
$pu_model->save();
$prep = $con->prepare("SELECT * FROM productExpires WHERE upc=?");
$chk = $con->execute($prep, array($upc));
if ($con->num_rows($chk) == 0) {
$ins = $con->prepare("INSERT INTO productExpires (upc,expires) VALUES (?, ?)");
$con->execute($ins, array($upc, $uexpires));
} else {
$up = $con->prepare("UPDATE productExpires SET expires=? WHERE upc=?");
$con->execute($up, array($uexpires, $upc));
}
}
}
if (!empty($likeCode)) {
if ($likeCode == -1) {
function SaveFormData($upc)
{
$upc = BarcodeLib::padUPC($upc);
$brand = FormLib::get('lf_brand');
$desc = FormLib::get('lf_desc');
$origin = FormLib::get('origin', 0);
$floorID = FormLib::get('floor-id', 0);
$text = FormLib::get('lf_text');
$text = str_replace("\r", '', $text);
$text = str_replace("\n", '<br />', $text);
// strip non-ASCII (word copy/paste artifacts)
$text = preg_replace("/[^-]/", "", $text);
$signs = FormLib::get('sign-count', 1);
if ($signs < 1) {
$signs = 1;
}
$dbc = $this->db();
$loc = new ProdPhysicalLocationModel($dbc);
$loc->upc($upc);
$loc->floorSectionID($floorID);
$loc->save();
$model = new ProductUserModel($dbc);
$model->upc($upc);
$model->brand($brand);
$model->description($desc);
$model->long_text($text);
$model->signCount($signs);
$multiOrigin = FormLib::get('otherOrigin', array());
$originMap = array();
if ($origin != 0) {
$originMap[] = $origin;
}
foreach ($multiOrigin as $originID) {
if ($originID != 0) {
$originMap[] = $originID;
}
}
$mapP = $dbc->prepare('DELETE FROM ProductOriginsMap WHERE upc=?');
$addP = $dbc->prepare('INSERT INTO ProductOriginsMap
(originID, upc, active)
VALUES (?, ?, 1)');
$lcP = $dbc->prepare('SELECT u.upc
FROM upcLike AS u
' . DTrans::joinProducts('u', 'p', 'INNER') . '
WHERE u.likeCode IN (
SELECT l.likeCode
FROM upcLike AS l
WHERE l.upc = ?
)');
$lcR = $dbc->execute($lcP, array($upc));
$items = array($upc);
while ($w = $dbc->fetch_row($lcR)) {
if ($w['upc'] == $upc) {
continue;
}
$items[] = $w['upc'];
}
$prod = new ProductsModel($dbc);
$stores = new StoresModel($dbc);
foreach ($items as $item) {
$prod->upc($item);
$prod->store_id(1);
$prod->current_origin_id($origin);
$prod->save();
$dbc->execute($mapP, array($item));
foreach ($originMap as $originID) {
$dbc->execute($addP, array($originID, $item));
}
}
return $model->save();
}
