public function SaveFormData($upc) { $local = $this->db(); $upc = BarcodeLib::padUPC($upc); $pu = new ProductUserModel($local); $pu->upc($upc); $pu->enableOnline(FormLib::get('u_online') == 1 ? 1 : 0); $pu->soldOut(FormLib::get('u_soldout') == 1 ? 1 : 0); $pu->save(); include dirname(__FILE__) . '/../../src/Credentials/OutsideDB.tunneled.php'; $remote = $dbc; $pu->load(); if ($pu->enableOnline() && $remote->isConnected()) { $pu->setConnection($remote); $pu->save(); $prod = new ProductsModel($local); $prod->upc($upc); $prod->load(); $prod->setConnection($remote); $prod->save(); } elseif (FormLib::get('u_already_online') && $remote->isConnected()) { $prod = new ProductsModel($remote); $prod->upc($upc); $prod->delete(); } if ($local->tableExists('productExpires')) { $e = new ProductExpiresModel($local); $e->upc($upc); $e->expires(FormLib::getDate('u_expires', date('Y-m-d'))); $e->save(); if ($e->expires() && $remote->isConnected()) { $e->setConnection($remote); $e->save(); } } }
} 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) { $updateLikeQ = $sql->prepare("delete from upcLike where upc=?");