include '../db.php'; $id = isset($_GET['id']) ? $_GET['id'] : 0; if (!isset($_REQUEST['windows']) && !isset($_REQUEST['upc'])) { header("Location: /git/fannie/admin/labels/genLabels.php?layout=WFC%20New&offset={$_REQUEST['offset']}&id=" . $_REQUEST['id']); return; } $rows = array(); if (isset($_REQUEST['upc'])) { $upc = str_pad($_REQUEST['upc'], 13, '0', STR_PAD_LEFT); $data = array(); include '../pricePerOunce.php'; if (isset($_REQUEST['vendorID'])) { $q = $sql->prepare("SELECT p.upc,p.description,p.normal_price,v.brand,\n v.sku,v.size,v.units,n.vendorName as vendor\n FROM products AS p LEFT JOIN vendorItems AS v\n ON p.upc=v.upc LEFT JOIN vendors AS n\n ON v.vendorID=n.vendorID\n WHERE p.upc=? AND v.vendorID=?"); $r = $sql->execute($q, array($upc, $_REQUEST['vendorID'])); $data = $sql->fetch_row($r); $data['pricePerUnit'] = pricePerOunce($data['normal_price'], $data['size']); } else { $q = $sql->prepare("SELECT p.upc,p.description,p.normal_price,x.manufacturer as brand,\n '' as sku,'' as size,1 as units,'DIRECT' as vendor\n FROM products AS p LEFT JOIN prodExtra AS x\n ON p.upc=x.upc\n WHERE p.upc=?"); $r = $sql->execute($q, array($upc)); $data = $sql->fetch_row($r); $data['pricePerUnit'] = ''; } for ($i = 0; $i < 32; $i++) { $rows[] = $data; } } else { $query = $sql->prepare("SELECT * FROM shelftags WHERE id=? order by upc"); $result = $sql->execute($query, array($id)); while ($row = $sql->fetch_row($result)) { $rows[] = $row; }
$upc = $getUNFIPriceW['upc']; $upcl = ltrim($getUNFIPriceW['upc'], 0); $upcl = str_pad($upcl, 10, "0", STR_PAD_LEFT); //$upc = str_pad($upc,11,0,STR_PAD_LEFT); $unfiPrice = $getUNFIPriceW['wfc_srp']; $insBItemR = $sql->execute($insBItemQ, array($upc, $maxID, $unfiPrice)); //echo $insBItemQ; //echo $getTagInfoQ; $getTagInfoR = $sql->execute($getTagInfoQ, array('%' . $upcl . '%')); $getTagInfoW = $sql->fetch_array($getTagInfoR); $desc = $getTagInfoW['item_desc']; $sku = $getTagInfoW['unfi_sku']; $brand = addslashes($getTagInfoW['brand']); $pak = $getTagInfoW['pack']; $size = $getTagInfoW['pack_size']; $ppo = pricePerOunce($unfiPrice, $size); if (empty($pak)) { $pak = 0; } $shelftag->id($buyID); $shelftag->upc($upc); $shelftag->description($desc); $shelftag->normal_price($unfiPrice); $shelftag->brand($brand); $shelftag->sku($sku); $shelftag->units($size); $shelftag->size($pak); $shelftag->pricePerUnit($ppo); $shelftag->vendor('UNFI'); $shelftag->save(); echo "<tr><td>{$upc}</td><td><font color=blue><b>{$desc}</b></font></td><td>{$sku}</td>";