$model = new ProductsModel($sql);
$model->upc($upc);
$model->description($descript);
$model->brand($manufacturer);
$model->normal_price($price);
$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);
/**
Helper: create a vendorItems record for an existing
product if one does not exist
*/
public function createIfMissing($upc, $vendorID)
{
// look for entry directly by UPC or via SKU mapping
$findP = $this->connection->prepare('
SELECT v.upc
FROM vendorItems AS v
LEFT JOIN vendorSKUtoPLU AS m ON v.vendorID=m.vendorID AND v.sku=m.sku
WHERE v.vendorID=?
AND (v.upc=? OR m.upc=?)');
$findR = $this->connection->execute($findP, array($vendorID, $upc, $upc));
if ($this->connection->num_rows($findR) == 0) {
// create item from product
$prod = new ProductsModel($this->connection);
$prod->upc($upc);
$prod->load();
$vend = new VendorItemsModel($this->connection);
$vend->vendorID($vendorID);
$vend->upc($upc);
$vend->sku($upc);
$vend->brand($prod->brand());
$vend->description($prod->description());
$vend->cost($prod->cost());
$vend->saleCost(0);
$vend->vendorDept(0);
$vend->units(1);
$vend->size($prod->size() . $prod->unitofmeasure());
$vend->save();
}
}
function SaveFormData($upc)
{
$FANNIE_PRODUCT_MODULES = FannieConfig::config('PRODUCT_MODULES', array());
$upc = BarcodeLib::padUPC($upc);
$dbc = $this->db();
$model = new ProductsModel($dbc);
$model->upc($upc);
if (!$model->load()) {
// fully init new record
$model->special_price(0);
$model->specialpricemethod(0);
$model->specialquantity(0);
$model->specialgroupprice(0);
$model->advertised(0);
$model->tareweight(0);
$model->start_date('0000-00-00');
$model->end_date('0000-00-00');
$model->discounttype(0);
$model->wicable(0);
$model->scaleprice(0);
$model->inUse(1);
}
$stores = FormLib::get('store_id', array());
for ($i = 0; $i < count($stores); $i++) {
$model->store_id($stores[$i]);
$taxes = FormLib::get('tax');
if (isset($taxes[$i])) {
$model->tax($taxes[$i]);
}
$fs = FormLib::get('FS', array());
if (in_array($stores[$i], $fs)) {
$model->foodstamp(1);
} else {
$model->foodstamp(0);
}
$scale = FormLib::get('Scale', array());
if (in_array($stores[$i], $scale)) {
$model->scale(1);
} else {
$model->scale(0);
}
$qtyFrc = FormLib::get('QtyFrc', array());
if (in_array($stores[$i], $qtyFrc)) {
$model->qttyEnforced(1);
} else {
$model->qttyEnforced(0);
}
$wic = FormLib::get('prod-wicable', array());
if (in_array($stores[$i], $wic)) {
$model->wicable(1);
} else {
$model->wicable(0);
}
$discount_setting = FormLib::get('discount');
if (isset($discount_setting[$i])) {
switch ($discount_setting[$i]) {
case 0:
$model->discount(0);
$model->line_item_discountable(0);
break;
case 1:
$model->discount(1);
$model->line_item_discountable(1);
break;
case 2:
$model->discount(1);
$model->line_item_discountable(0);
break;
case 3:
$model->discount(0);
$model->line_item_discountable(1);
break;
}
}
$price = FormLib::get('price');
if (isset($price[$i])) {
$model->normal_price($price[$i]);
}
$cost = FormLib::get('cost');
if (isset($cost[$i])) {
$model->cost($cost[$i]);
}
$desc = FormLib::get('descript');
if (isset($desc[$i])) {
$model->description(str_replace("'", '', $desc[$i]));
}
$brand = FormLib::get('manufacturer');
if (isset($brand[$i])) {
$model->brand(str_replace("'", '', $brand[$i]));
}
$model->pricemethod(0);
$model->groupprice(0.0);
$model->quantity(0);
$dept = FormLib::get('department');
if (isset($dept[$i])) {
$model->department($dept[$i]);
}
$size = FormLib::get('size');
if (isset($size[$i])) {
$model->size($size[$i]);
}
$model->modified(date('Y-m-d H:i:s'));
$unit = FormLib::get('unitm');
if (isset($unit[$i])) {
$model->unitofmeasure($unit[$i]);
}
$subdept = FormLib::get('subdept');
if (isset($subdept[$i])) {
$model->subdept($subdept[$i]);
}
// lookup vendorID by name
$vendorID = 0;
$v_input = FormLib::get('distributor');
if (isset($v_input[$i])) {
$vendor = new VendorsModel($dbc);
$vendor->vendorName($v_input[$i]);
foreach ($vendor->find('vendorID') as $obj) {
$vendorID = $obj->vendorID();
break;
}
}
$model->default_vendor_id($vendorID);
$inUse = FormLib::get('prod-in-use', array());
if (in_array($stores[$i], $inUse)) {
$model->inUse(1);
} else {
$model->inUse(0);
}
$idEnf = FormLib::get('id-enforced', array());
if (isset($idEnf[$i])) {
$model->idEnforced($idEnf[$i]);
}
$local = FormLib::get('prod-local');
if (isset($local[$i])) {
$model->local($local[$i]);
}
$deposit = FormLib::get('deposit-upc');
if (isset($deposit[$i])) {
if ($deposit[$i] == '') {
$deposit[$i] = 0;
}
$model->deposit($deposit[$i]);
}
/* products.formatted_name is intended to be maintained automatically.
* Get all enabled plugins and standard modules of the base.
* Run plugins first, then standard modules.
*/
$formatters = FannieAPI::ListModules('ProductNameFormatter');
$fmt_name = "";
$fn_params = array('index' => $i);
foreach ($formatters as $formatter_name) {
$formatter = new $formatter_name();
$fmt_name = $formatter->compose($fn_params);
if (isset($formatter->this_mod_only) && $formatter->this_mod_only) {
break;
}
}
$model->formatted_name($fmt_name);
$model->save();
}
/**
If a vendor is selected, intialize
a vendorItems record
*/
if ($vendorID != 0) {
$vitem = new VendorItemsModel($dbc);
$vitem->vendorID($vendorID);
$vitem->upc($upc);
$sku = FormLib::get('vendorSKU');
if (empty($sku)) {
$sku = $upc;
} else {
/**
If a SKU is provided, update any
old record that used the UPC as a
placeholder SKU.
*/
$existsP = $dbc->prepare('
SELECT sku
FROM vendorItems
WHERE sku=?
AND upc=?
AND vendorID=?');
$existsR = $dbc->execute($existsP, array($sku, $upc, $vendorID));
if ($dbc->numRows($existsR) > 0 && $sku != $upc) {
$delP = $dbc->prepare('
DELETE FROM vendorItems
WHERE sku =?
AND upc=?
AND vendorID=?');
$dbc->execute($delP, array($upc, $upc, $vendorID));
} else {
$fixSkuP = $dbc->prepare('
UPDATE vendorItems
SET sku=?
WHERE sku=?
AND vendorID=?');
$dbc->execute($fixSkuP, array($sku, $upc, $vendorID));
}
}
$vitem->sku($sku);
$vitem->size($model->size());
$vitem->description($model->description());
$vitem->brand($model->brand());
$vitem->units(FormLib::get('caseSize', 1));
$vitem->cost($model->cost());
$vitem->save();
}
if ($dbc->table_exists('prodExtra')) {
$extra = new ProdExtraModel($dbc);
$extra->upc($upc);
if (!$extra->load()) {
$extra->variable_pricing(0);
$extra->margin(0);
$extra->case_quantity('');
$extra->case_cost(0.0);
$extra->case_info('');
}
$brand = FormLib::get('manufacturer');
if (isset($brand[0])) {
$extra->manufacturer(str_replace("'", '', $brand[0]));
}
$dist = FormLib::get('distributor');
if (isset($dist[0])) {
$extra->distributor(str_replace("'", '', $dist[0]));
}
$cost = FormLib::get('cost');
if (isset($cost[0])) {
$extra->cost($cost[0]);
}
$extra->save();
}
if (!isset($FANNIE_PRODUCT_MODULES['ProdUserModule'])) {
if ($dbc->table_exists('productUser')) {
$ldesc = FormLib::get_form_value('puser_description');
$model = new ProductUserModel($dbc);
$model->upc($upc);
$model->description($ldesc);
$model->save();
}
}
}
