Exemplo n.º 1
0
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;
    }
Exemplo n.º 2
0
 $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>";