Пример #1
0
 function SaveFormData($upc)
 {
     /* check if data was submitted */
     if (FormLib::get('s_plu') === '') {
         return False;
     }
     $desc = FormLib::get('descript', '');
     if (is_array($desc)) {
         $desc = array_pop($desc);
     }
     $longdesc = FormLib::get('s_longdesc', '');
     if (trim($longdesc) !== '') {
         $desc = $longdesc;
     }
     $price = FormLib::get('price', 0);
     if (is_array($price)) {
         $price = array_pop($price);
     }
     $tare = FormLib::get('s_tare', 0);
     $shelf = FormLib::get('s_shelflife', 0);
     $bycount = FormLib::get('s_bycount', 0);
     $graphics = FormLib::get('s_graphics', 0);
     $type = FormLib::get('s_type', 'Random Weight');
     $weight = $type == 'Random Weight' ? 0 : 1;
     $text = FormLib::get('s_text', '');
     $align = FormLib::get('s_label', 'horizontal');
     $netWeight = FormLib::get('s_netwt', 0);
     $label = \COREPOS\Fannie\API\item\ServiceScaleLib::attributesToLabel($align, $type == 'Fixed Weight' ? true : false, $graphics != 0 ? true : false);
     $dbc = $this->db();
     // apostrophes might make a mess
     // double quotes definitely will
     // DGW quotes text fields w/o any escaping
     $desc = str_replace("'", "", $desc);
     $text = str_replace("'", "", $text);
     $desc = str_replace("\"", "", $desc);
     $text = str_replace("\"", "", $text);
     /**
       Safety check:
       A fixed-weight item sticked by the each flagged
       as scalable will interact with the register's
       quantity * upc functionality incorrectly
     */
     if ($weight == 1 && $bycount == 1) {
         $p = new ProductsModel($dbc);
         $p->upc($upc);
         $p->store_id(1);
         if ($p->load()) {
             $p->Scale(0);
             $p->save();
         }
     }
     $scaleItem = new ScaleItemsModel($dbc);
     $scaleItem->plu($upc);
     $action = 'ChangeOneItem';
     if (!$scaleItem->load()) {
         // new record
         $action = "WriteOneItem";
     }
     $scaleItem->price($price);
     $scaleItem->itemdesc($desc);
     $scaleItem->weight($type == 'Fixed Weight' ? 1 : 0);
     $scaleItem->bycount($bycount);
     $scaleItem->tare($tare);
     $scaleItem->shelflife($shelf);
     $scaleItem->text($text);
     $scaleItem->label($label);
     $scaleItem->graphics($graphics ? 121 : 0);
     $scaleItem->netWeight($netWeight);
     $scaleItem->save();
     // extract scale PLU
     preg_match("/^002(\\d\\d\\d\\d)0/", $upc, $matches);
     $s_plu = $matches[1];
     if ($s_plu == '0000') {
         preg_match("/^0020(\\d\\d\\d\\d)/", $upc, $matches);
         $s_plu = $matches[1];
     }
     $item_info = array('RecordType' => $action, 'PLU' => $s_plu, 'Description' => $desc, 'Tare' => $tare, 'ShelfLife' => $shelf, 'Price' => $price, 'Label' => $label, 'ExpandedText' => $text, 'ByCount' => $bycount);
     if ($netWeight != 0) {
         $item_info['NetWeight'] = $netWeight;
     }
     if ($graphics) {
         $item_info['Graphics'] = 121;
     }
     // normalize type + bycount; they need to match
     if ($item_info['ByCount'] && $type == 'Random Weight') {
         $item_info['Type'] = 'By Count';
     } else {
         if ($type == 'Fixed Weight') {
             $item_info['Type'] = 'Fixed Weight';
             $item_info['ByCount'] = 1;
         } else {
             $item_info['Type'] = 'Random Weight';
             $item_info['ByCount'] = 0;
         }
     }
     $scales = array();
     $scaleIDs = FormLib::get('scaleID', array());
     $model = new ServiceScalesModel($dbc);
     /**
       Send item to requested scales
     */
     if (count($scaleIDs) > 0) {
         $chkMap = $dbc->prepare('SELECT upc
                                  FROM ServiceScaleItemMap
                                  WHERE serviceScaleID=?
                                     AND upc=?');
         $addMap = $dbc->prepare('INSERT INTO ServiceScaleItemMap
                                     (serviceScaleID, upc)
                                  VALUES
                                     (?, ?)');
         foreach ($scaleIDs as $scaleID) {
             $model->reset();
             $model->serviceScaleID($scaleID);
             if (!$model->load()) {
                 // scale doesn't exist
                 continue;
             }
             $repr = array('host' => $model->host(), 'dept' => $model->scaleDeptName(), 'type' => $model->scaleType(), 'new' => false);
             $exists = $dbc->execute($chkMap, array($scaleID, $upc));
             if ($dbc->num_rows($exists) == 0) {
                 $repr['new'] = true;
                 $dbc->execute($addMap, array($scaleID, $upc));
             }
             $scales[] = $repr;
         }
         HobartDgwLib::writeItemsToScales($item_info, $scales);
         EpScaleLib::writeItemsToScales($item_info, $scales);
     }
     /**
       Delete item from scales if that
       option was unchecked
     */
     $mapP = $dbc->prepare('
         SELECT serviceScaleID
         FROM ServiceScaleItemMap
         WHERE upc=?');
     $mapR = $dbc->execute($mapP, array($upc));
     $delP = $dbc->prepare('
         DELETE
         FROM ServiceScaleItemMap
         WHERE serviceScaleID=?
             AND upc=?');
     if ($mapR && $dbc->numRows($mapR)) {
         $scales = array();
         while ($mapW = $dbc->fetchRow($mapR)) {
             if (in_array($mapW['serviceScaleID'], $scaleIDs)) {
                 // item sent to that scale
                 continue;
             }
             $model->reset();
             $model->serviceScaleID($mapW['serviceScaleID']);
             if (!$model->load()) {
                 // scale doesn't exist
                 continue;
             }
             $repr = array('host' => $model->host(), 'dept' => $model->scaleDeptName(), 'type' => $model->scaleType(), 'new' => false);
             $scales[] = $repr;
             $dbc->execute($delP, array($mapW['serviceScaleID'], $upc));
         }
         if (count($scales) > 0) {
             HobartDgwLib::deleteItemsFromScales($item_info['PLU'], $scales);
         }
     }
 }
Пример #2
0
 function process_file($linedata)
 {
     global $FANNIE_OP_DB;
     $dbc = FannieDB::get($FANNIE_OP_DB);
     $barcode_index = $this->get_column_index('barcode');
     $desc_index = $this->get_column_index('desc');
     $price_index = $this->get_column_index('price');
     $type_index = $this->get_column_index('type');
     $graphics_index = $this->get_column_index('graphics');
     $label_index = $this->get_column_index('label');
     $tare_index = $this->get_column_index('tare');
     $shelf_index = $this->get_column_index('shelf');
     $net_index = $this->get_column_index('net');
     $model = new ScaleItemsModel($dbc);
     $ret = true;
     $this->stats = array('done' => 0, 'error' => array());
     foreach ($linedata as $line) {
         // get info from file and member-type default settings
         // if applicable
         if (!isset($line[$barcode_index])) {
             continue;
         }
         $barcode_segment = $line[$barcode_index];
         if (!is_numeric($barcode_segment)) {
             continue;
         }
         $upc = '002' . str_pad($barcode_segment, 5, '0', STR_PAD_LEFT) . '00000';
         $model->reset();
         $model->plu($upc);
         $model->load();
         $type = $line[$type_index];
         if ($type == 'Random Weight') {
             $model->weight(0);
             $model->bycount(0);
         } elseif ($type == 'Fixed Weight') {
             $model->weight(1);
             $model->bycount(1);
         } else {
             // bad record; no weight given
             continue;
         }
         if ($desc_index !== false && isset($line[$desc_index]) && !empty($line[$desc_index])) {
             $desc = $line[$desc_index];
             $desc = str_replace("'", "", $desc);
             $desc = str_replace("\"", "", $desc);
             $model->itemdesc($desc);
         }
         if ($price_index !== false && isset($line[$price_index])) {
             $model->price($line[$price_index]);
         }
         if ($tare_index !== false && isset($line[$tare_index])) {
             $model->tare($line[$tare_index]);
         }
         if ($shelf_index !== false && isset($line[$shelf_index])) {
             $model->shelflife($line[$shelf_index]);
         }
         if ($net_index !== false && isset($line[$net_index])) {
             $model->netWeight($line[$net_index]);
         }
         if ($label_index !== false && isset($line[$label_index])) {
             $model->label($line[$label_index]);
         }
         if ($graphics_index !== false && isset($line[$graphics_index])) {
             $model->graphics($line[$graphics_index]);
         }
         $try = $model->save();
         if ($try === false) {
             $ret = false;
             $this->stats['error'][] = 'There was an error importing UPC ' . $upc;
         } else {
             $this->stats['done']++;
         }
     }
     return $ret;
 }
Пример #3
0
 $nr = $sql->num_rows($scaleRes);
 /* apostrophe filter */
 $s_itemdesc = str_replace("'", "", $s_itemdesc);
 $s_text = str_replace("'", "", $s_text);
 $s_itemdesc = str_replace("\"", "", $s_itemdesc);
 $s_text = str_replace("\"", "", $s_text);
 $scaleItem = new ScaleItemsModel($dbc);
 $scaleItem->plu($s_plu);
 $scaleItem->price($s_price);
 $scaleItem->itemdesc($s_itemdesc);
 $scaleItem->weight($wt);
 $scaleItem->bycount($bc);
 $scaleItem->tare($tare);
 $scaleItem->shelflife($shelflife);
 $scaleItem->text($s_text);
 $scaleItem->label($s_label);
 $scaleItem->graphics($graphics);
 $scaleItem->netWeight($netWeight);
 $scaleItem->save();
 $datetime = date("m/d/Y h:i:s a");
 $fp = fopen('hobartcsv/query.log', 'a');
 fwrite($fp, "{$datetime}\n{$scaleQuery}\n\n");
 fclose($fp);
 // trim the upc down to size
 // grabbing the 4 or 5 non-zero digits after the 2
 // might just need 4, ask chris
 preg_match("/002(\\d\\d\\d\\d)0/", $s_plu, $matches);
 $s_plu = $matches[1];
 //echo "<br />plu ".$s_plu;
 // hobart csv functionality
 /*