public function SaveFormData($upc)
{
$upc = BarcodeLib::padUPC($upc);
$dbc = $this->db();
$model = new ProductsModel($dbc);
$model->upc($upc);
$model->store_id(1);
$method = FormLib::get_form_value('vp_method', 0);
$qty = FormLib::get_form_value('vp_qty', 0);
$price = FormLib::get_form_value('vp_price', 0);
$mixmatch = FormLib::get_form_value('vp_mm', 0);
$model->pricemethod($method);
$model->quantity($qty);
$model->groupprice($price);
$model->mixmatchcode($mixmatch);
$r1 = $model->save();
if ($r1 === false) {
return false;
} else {
return true;
}
}
public function run()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$now = date('Y-m-d 00:00:00');
$sale_upcs = array();
// ensure likecode items are mixmatch-able
if ($dbc->dbms_name() == 'mssql') {
$dbc->query("UPDATE products\n SET mixmatchcode=convert(varchar,u.likecode+500)\n FROM \n products AS p\n INNER JOIN upcLike AS u\n ON p.upc=u.upc");
} else {
$dbc->query("UPDATE products AS p\n INNER JOIN upcLike AS u ON p.upc=u.upc\n SET p.mixmatchcode=convert(u.likeCode+500,char)");
}
$likeP = $dbc->prepare('SELECT u.upc
FROM upcLike AS u
INNER JOIN products AS p ON u.upc=p.upc
WHERE likeCode=?');
$product = new ProductsModel($dbc);
$b_def = $dbc->tableDefinition('batches');
// lookup current batches
$query = 'SELECT l.upc,
l.batchID,
l.pricemethod,
l.salePrice,
l.groupSalePrice,
l.quantity,
b.startDate,
b.endDate,
b.discounttype
' . (isset($b_def['transLimit']) ? ',b.transLimit' : ',0 AS transLimit') . '
FROM batches AS b
INNER JOIN batchList AS l ON b.batchID = l.batchID
WHERE b.discounttype <> 0
AND b.startDate <= ?
AND b.endDate >= ?
ORDER BY l.upc,
l.salePrice DESC';
$t_def = $dbc->tableDefinition('batchList');
if (!isset($t_def['groupSalePrice'])) {
$query = str_replace('l.groupSalePrice', 'NULL AS groupSalePrice', $query);
}
/**
In HQ mode, join on junction table to get UPC+storeID rows
when applying sale pricing
*/
if ($this->config->get('STORE_MODE') === 'HQ') {
$query = str_replace('WHERE', ' LEFT JOIN StoreBatchMap AS s ON b.batchID=s.batchID WHERE ', $query);
$query = str_replace('SELECT', 'SELECT s.storeID,', $query);
}
$prep = $dbc->prepare($query);
$result = $dbc->execute($prep, array($now, $now));
while ($row = $dbc->fetch_row($result)) {
// all items affected by this bathcList record
// could be more than one in the case of likecodes
$item_upcs = array();
// use products column names for readability below
$special_price = $row['salePrice'];
$specialpricemethod = $row['pricemethod'];
if ($row['groupSalePrice'] != null) {
$specialgroupprice = $row['groupSalePrice'];
} else {
$specialgroupprice = abs($row['salePrice']);
}
$specialquantity = $row['quantity'];
$special_limit = $row['transLimit'];
$start_date = $row['startDate'];
$end_date = $row['endDate'];
$discounttype = $row['discounttype'];
$batchID = $row['batchID'];
// pricemethod 3 and 4 (AB pricing, typically)
// has some overly complicated rules
$mixmatch = false;
if ($specialpricemethod == 3 || $specialpricemethod == 4) {
if ($special_price >= 0) {
$mixmatch = $row['batchID'];
} else {
$mixmatch = -1 * $row['batchID'];
}
}
// unpack likecodes, if needed
if (substr($row['upc'], 0, 2) == 'LC') {
$likeCode = substr($row['upc'], 2);
$likeR = $dbc->execute($likeP, array($likeCode));
while ($likeW = $dbc->fetch_row($likeR)) {
$item_upcs[] = $likeW['upc'];
if ($mixmatch !== false) {
$mixmatch = $likeCode + 500;
}
}
} else {
$item_upcs[] = $row['upc'];
}
// check each item to see if it is on
// sale with the correct parameters
foreach ($item_upcs as $upc) {
$product->reset();
$product->upc($upc);
$this->cronMsg('Checking item ' . $upc, FannieLogger::INFO);
/**
Transistion mechanism. A batch that is set to apply to
zero stores really should apply to zero stores. For now
it fails over to using the local store's ID
*/
if ($this->config->get('STORE_MODE') === 'HQ') {
$storeID = $row['storeID'];
if ($storeID == null) {
$storeID = $this->config->get('STORE_ID');
}
$product->store_id($storeID);
}
if (!$product->load()) {
$this->cronMsg("\tError: item does not exist in products", FannieLogger::NOTICE);
continue;
}
// list of UPCs that should be on sale
$sale_upcs[] = $upc;
$changed = false;
if ($product->special_price() != $special_price) {
$changed = true;
$product->special_price($special_price);
}
if ($product->specialpricemethod() != $specialpricemethod) {
$changed = true;
$product->specialpricemethod($specialpricemethod);
}
if ($product->specialgroupprice() != $specialgroupprice) {
$changed = true;
$product->specialgroupprice($specialgroupprice);
}
if ($product->specialquantity() != $specialquantity) {
$changed = true;
$product->specialquantity($specialquantity);
}
if ($product->special_limit() != $special_limit) {
$changed = true;
$product->special_limit($special_limit);
}
if ($product->start_date() != $start_date) {
$changed = true;
$product->start_date($start_date);
}
if ($product->end_date() != $end_date) {
$changed = true;
$product->end_date($end_date);
}
if ($product->discounttype() != $discounttype) {
$changed = true;
$product->discounttype($discounttype);
}
if ($mixmatch !== false && $product->mixmatchcode() != $mixmatch) {
$changed = true;
$product->mixmatchcode($mixmatch);
}
if ($product->batchID() != $batchID) {
$changed = true;
$product->batchID($batchID);
}
if ($changed) {
$product->save();
$this->cronMsg("\tUpdated item", FannieLogger::INFO);
}
}
// end loop on batchList record items
}
// end loop on batchList records
// No sale items; need a filler value for
// the query below
if (count($sale_upcs) == 0) {
$this->cronMsg('Notice: nothing is currently on sale', FannieLogger::WARNING);
$sale_upcs[] = 'notValidUPC';
}
// now look for anything on sale that should not be
// and take those items off sale
$upc_in = '';
foreach ($sale_upcs as $upc) {
$upc_in .= '?,';
}
$upc_in = substr($upc_in, 0, strlen($upc_in) - 1);
$lookupQ = 'SELECT p.upc
FROM products AS p
WHERE upc NOT IN (' . $upc_in . ')
AND (
p.discounttype <> 0
OR p.special_price <> 0
OR p.specialpricemethod <> 0
OR p.specialgroupprice <> 0
OR p.specialquantity <> 0
)';
$lookupP = $dbc->prepare($lookupQ);
$lookupR = $dbc->execute($lookupP, $sale_upcs);
while ($lookupW = $dbc->fetch_row($lookupR)) {
$this->cronMsg('Taking ' . $lookupW['upc'] . ' off sale', FannieLogger::INFO);
$product->reset();
if ($this->config->get('STORE_MODE') === 'HQ') {
$product->store_id($this->config->get('STORE_ID'));
}
$product->upc($lookupW['upc']);
$product->discounttype(0);
$product->special_price(0);
$product->specialgroupprice(0);
$product->specialquantity(0);
$product->start_date('');
$product->end_date('');
$product->batchID(0);
$product->save();
}
}
$model->pricemethod(0);
$model->groupprice(0.0);
$model->quantity(0);
$model->special_price(0.0);
$model->specialpricemethod(0);
$model->specialgroupprice(0.0);
$model->specialquantity(0);
$model->start_date('');
$model->end_date('');
$model->department($dept);
$model->size(0);
$model->tax($tax);
$model->foodstamp($FS);
$model->scale($Scale);
$model->scaleprice(0);
$model->mixmatchcode(0);
$model->modified($stamp);
$model->advertised(0);
$model->tareweight(0);
$model->discount($NoDisc);
$model->discounttype(0);
$model->unitofmeasure(0);
$model->wicable(0);
$model->qttyEnforced(0);
$model->idEnforced(0);
$model->cost(0.0);
$model->inUse(1);
$model->numflag(0);
$model->subdept(0);
$model->deposit(0.0);
$model->local($local);
function SaveFormData($upc)
{
$lc = FormLib::get_form_value('likeCode');
$dbc = $this->db();
$delP = $dbc->prepare_statement('DELETE FROM upcLike WHERE upc=?');
$delR = $dbc->exec_statement($delP, array($upc));
if ($lc == -1) {
return $delR === False ? False : True;
}
$insP = 'INSERT INTO upcLike (upc,likeCode) VALUES (?,?)';
$insR = $dbc->exec_statement($insP, array($upc, $lc));
if (FormLib::get_form_value('LikeCodeNoUpdate') == 'noupdate') {
return $insR === False ? False : True;
}
/* get values for current item */
$valuesP = $dbc->prepare_statement('SELECT normal_price,pricemethod,groupprice,quantity,
department,scale,tax,foodstamp,discount,qttyEnforced,local,wicable
FROM products WHERE upc=?');
$valuesR = $dbc->exec_statement($valuesP, array($upc));
if ($dbc->num_rows($valuesR) == 0) {
return False;
}
$values = $dbc->fetch_row($valuesR);
/* apply current values to other other items
in the like code */
$upcP = $dbc->prepare_statement('SELECT upc FROM upcLike WHERE likeCode=? AND upc<>?');
$upcR = $dbc->exec_statement($upcP, array($lc, $upc));
$isHQ = FannieConfig::config('STORE_MODE') == 'HQ' ? true : false;
$stores = new StoresModel($dbc);
$stores = array_map(array_filter($stores->find(), function ($obj) {
return $obj->hasOwnItems();
}), function ($obj) {
return $obj->storeID();
});
$model = new ProductsModel($dbc);
$model->upc($upc);
$model->mixmatchcode($lc + 500);
if ($isHQ) {
foreach ($stores as $store_id) {
$model->store_id($store_id);
$model->save();
}
} else {
$model->save();
}
while ($upcW = $dbc->fetch_row($upcR)) {
$model->reset();
$model->upc($upcW['upc']);
$model->normal_price($values['normal_price']);
$model->pricemethod($values['pricemethod']);
$model->groupprice($values['groupprice']);
$model->quantity($values['quantity']);
$model->department($values['department']);
$model->scale($values['scale']);
$model->tax($values['tax']);
$model->foodstamp($values['foodstamp']);
$model->discount($values['discount']);
$model->qttyEnforced($values['qttyEnforced']);
$model->local($values['local']);
$model->wicable($values['wicable']);
$model->mixmatchcode($lc + 500);
if ($isHQ) {
foreach ($stores as $store_id) {
$model->store_id($store_id);
$model->save();
}
} else {
$model->save();
}
updateProductAllLanes($upcW['upc']);
}
return true;
}
