Esempio n. 1
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;
 }
Esempio n. 2
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);
         }
     }
 }
Esempio n. 3
0
 function process_file($linedata)
 {
     global $FANNIE_OP_DB;
     $dbc = FannieDB::get($FANNIE_OP_DB);
     $upc_index = $this->get_column_index('upc');
     $desc_index = $this->get_column_index('desc');
     $price_index = $this->get_column_index('price');
     $type_index = $this->get_column_index('type');
     $tare_index = $this->get_column_index('tare');
     $shelf_index = $this->get_column_index('shelf');
     $net_index = $this->get_column_index('net');
     $text_index = $this->get_column_index('text');
     $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
         $upc = $line[$upc_index];
         // upc cleanup
         $upc = str_replace(" ", "", $upc);
         $upc = str_replace("-", "", $upc);
         if (!is_numeric($upc)) {
             continue;
         }
         // skip header(s) or blank rows
         $upc = BarcodeLib::padUPC($upc);
         $model->reset();
         $model->plu($upc);
         $model->load();
         if ($type_index !== false && isset($line[$type_index])) {
             if (strtoupper($line[$type_index]) == 'FIXED' || strtoupper($line[$type_index]) == 'EA') {
                 $model->weight(1);
                 $model->bycount(1);
             } else {
                 if (strtoupper($line[$type_index]) == 'RANDOM' || strtoupper($line[$type_index]) == 'RAND') {
                     $model->weight(0);
                     $model->bycount(0);
                 }
             }
         }
         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 ($text_index !== false && isset($line[$text_index]) && !empty($line[$text_index])) {
             $text = $line[$text_index];
             $text = str_replace("'", "", $text);
             $text = str_replace("\"", "", $text);
             $model->text($line[$text_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;
 }
Esempio n. 4
0
 function post_u_view()
 {
     global $FANNIE_OP_DB, $FANNIE_URL;
     $this->add_script($FANNIE_URL . '/src/javascript/jquery.js');
     $this->add_css_file($FANNIE_URL . '/src/style.css');
     $ret = '';
     $ret .= '<form action="SyncFromSearch.php" method="post">';
     $scales = new ServiceScalesModel(FannieDB::get($FANNIE_OP_DB));
     $ret .= '<div class="panel panel-default">
         <div class="panel-heading">Scales</div>
         <div class="panel-body">';
     foreach ($scales->find('description') as $scale) {
         $ret .= sprintf('<input type="checkbox" class="scaleID" name="scaleID[]" 
                             id="scaleID%d" value="%d" />
                          <label for="scaleID%d">%s</label><br />', $scale->serviceScaleID(), $scale->serviceScaleID(), $scale->serviceScaleID(), $scale->description());
     }
     $ret .= '</div></div>';
     $ret .= '<p><button type="submit" name="sendall" value="1"
                 class="btn btn-default">Sync All Items</button></p>';
     $ret .= '<div id="alert-area"></div>';
     $ret .= '<table class="table">';
     $ret .= '<tr>
             <th>UPC</th>
             <th>Description</th>
             <th>Price</th>
             <th>Last Changed</th>
             <th>Send Now</th>
             </tr>';
     $model = new ScaleItemsModel(FannieDB::get($FANNIE_OP_DB));
     foreach ($this->upcs as $upc) {
         $model->plu($upc);
         if (!$model->load()) {
             continue;
         }
         $ret .= sprintf('<tr id="row%s">
                         <td>%s</td>
                         <td>%s</td>
                         <td>%.2f</td>
                         <td>%s</td>
                         <td><button type="button" class="btn btn-default"
                             onclick="sendOne(\'%s\'); return false;">Sync Item</button></td>
                         <input type="hidden" name="upcs[]" value="%s" />
                         </tr>', $model->plu(), $model->plu(), $model->mergeDescription(), $model->price(), $model->modified(), $model->plu(), $model->plu());
     }
     $ret .= '</table>';
     $ret .= '</form>';
     return $ret;
 }