function itemParse($upc) { if (is_numeric($upc)) { $upc = str_pad($upc, 13, 0, STR_PAD_LEFT); $queryItem = "SELECT * FROM " . PRODUCTS_TBL . " WHERE upc = '{$upc}'"; } else { $queryItem = "SELECT * FROM " . PRODUCTS_TBL . " WHERE description LIKE '%{$upc}%' ORDER BY description"; } $resultItem = mysql_query($queryItem); if (!$resultItem) { die("Query: {$queryItem}<br />Error:" . mysql_error()); } // $num = mysql_fetch_row($resultItem); $num = mysql_num_rows($resultItem); if ($num == 0 || !$num) { $new = 1; // noItem(); itemMaintenance($new, $upc); } elseif ($num > 1) { moreItems($upc); for ($i = 0; $i < $num; $i++) { $rowItem = mysql_fetch_array($resultItem); $upc = $rowItem['upc']; echo "<a href='../item/itemMaint.php?upc={$upc}'>" . $upc . " </a>- " . $rowItem['description']; if ($rowItem['discounttype'] == 0) { echo "-- \$" . $rowItem['normal_price'] . "<br>"; } else { echo "-- <font color=green>\$" . $rowItem['special_price'] . " onsale</font><br>"; } } } else { $new = 0; // oneItem($upc); // $rowItem = mysql_fetch_array($resultItem); itemMaintenance($new, $upc); } return $num; }
function itemParse($upc) { global $FANNIE_OP_DB, $FANNIE_URL; global $FANNIE_STORE_ID; global $FANNIE_COOP_ID; global $FANNIE_COMPOSE_PRODUCT_DESCRIPTION; global $FANNIE_COMPOSE_LONG_PRODUCT_DESCRIPTION; $dbc = FannieDB::get($FANNIE_OP_DB); //global $FANNIE_ITEM_MODULES; // This is both whether-or-not and sequence-on-page //"ThreeForDollar", $Fannie_Item_Modules = array("Operations", "ItemFlags", "ExtraInfo", "ThreeForDollar", "Cost", "Sale", "Margin", "LikeCode", "LaneStatus"); $logged_in = checkLogin(); // 1. Lookup on the request argument. $queryItem = ""; $numType = isset($_REQUEST['ntype']) ? $_REQUEST['ntype'] : 'UPC'; // 8Mar13 EL || SKU if (is_numeric($upc) || $numType == 'SKU') { switch ($numType) { case 'UPC': $upc = str_pad($upc, 13, 0, STR_PAD_LEFT); $savedUPC = $upc; $queryItem = "SELECT p.*,x.distributor,x.manufacturer\n ,v.sku,v.vendorDept\n FROM products AS p LEFT JOIN\n prodExtra AS x ON p.upc=x.upc\n LEFT JOIN vendorItems AS v ON v.upc=p.upc\n WHERE (p.upc = '{$upc}' or x.upc = '{$upc}')\n AND p.store_id=0"; break; case 'SKU': $queryItem = "SELECT p.*,x.distributor,x.manufacturer\n ,v.sku,v.vendorDept\n FROM products AS p INNER JOIN\n vendorItems AS v ON p.upc=v.upc\n LEFT JOIN prodExtra AS x on p.upc=x.upc\n WHERE v.sku='{$upc}'\n AND p.store_id=0"; break; case 'Brand Prefix': $queryItem = "SELECT p.*,x.distributor,x.manufacturer\n ,v.sku,v.vendorDept\n FROM products AS p LEFT JOIN\n prodExtra AS x ON p.upc=x.upc\n LEFT JOIN vendorItems AS v ON v.upc=p.upc\n WHERE p.upc like '%{$upc}%'\n AND p.store_id=0\n ORDER BY p.upc"; break; } } else { /* note: only search by HQ records (store_id=0) to avoid duplicates */ $queryItem = "SELECT p.*,x.distributor,x.manufacturer\n FROM products AS p LEFT JOIN\n prodExtra AS x ON p.upc=x.upc\n WHERE description LIKE '%{$upc}%'\n AND p.store_id=0\n ORDER BY description"; } $resultItem = $dbc->query($queryItem); $num = $dbc->num_rows($resultItem); $likeCodeQ = "SELECT u.*,l.likeCodeDesc FROM upcLike as u, likeCodes as l\n WHERE u.likeCode = l.likeCode and u.upc = '{$upc}'"; $likeCodeR = $dbc->query($likeCodeQ); $likeCodeRow = $dbc->fetch_row($likeCodeR); $likeCodeNum = $dbc->num_rows($likeCodeR); $likecode = $likeCodeNum > 0 ? $likeCodeRow[1] : ''; // 2. Compose code in the HEAD of the HTML page. echo "<script type=\"text/javascript\">"; echo "function shelftag(u){"; echo "testwindow= window.open (\"addShelfTag.php?upc=\"+u, \"New Shelftag\",\"location=0,status=1,scrollbars=1,width=300,height=220\");"; echo "testwindow.moveTo(50,50);"; echo "}"; echo "</script>"; echo "<script type='text/javascript'>\n \$(document).ready(function(){\n \$('#start_date').datepicker(); \n \$('#end_date').datepicker(); \n });\n </script>"; // 3. No match. Compose form for creation of a new item. if ($num == 0 || !$num) { $data = array(); if (is_numeric($upc) || $numType == 'SKU') { $searchField = $numType == 'SKU' ? 'sku' : 'upc'; $dataQ = "SELECT description,brand,cost/units as cost,vendorName,margin,i.vendorID,\n i.size,i.units,i.cost as case_cost,i.sku,i.upc\n FROM vendorItems AS i LEFT JOIN vendors AS v ON i.vendorID=v.vendorID\n LEFT JOIN vendorDepartments AS d ON i.vendorDept=d.deptID\n WHERE {$searchField} = '{$upc}'"; // When would this be set? if (isset($_REQUEST['vid'])) { $dataQ .= " AND i.vendorID=" . (int) $_REQUEST['vid']; } $dataR = $dbc->query($dataQ); if ($dbc->num_rows($dataR) > 0) { $data = $dbc->fetch_row($dataR); // ->EL vendorItems.cost is case_cost but data[cost] is unit_cost. if (is_numeric($data['cost']) && is_numeric($data['margin'])) { $data['srp'] = getSRP($data['cost'], $data['margin']); } if (preg_match("/(\\d+) *([a-z]+)/", $data['size'], $matches)) { $numeric_size = $matches[1]; $unitofmeasure = $matches[2]; } } } $char_count_class = "char_count"; if (isset($FANNIE_COMPOSE_PRODUCT_DESCRIPTION) && $FANNIE_COMPOSE_PRODUCT_DESCRIPTION == "1") { $char_count_class = "char_count_pkg"; } // Is <head> ever closed for Create? echo "<BODY onLoad='putFocus(0,1);'>"; noItem(); if (count($data) > 0) { echo "<br /><i>This product is in the " . $data['vendorName'] . " catalog. Values have\n been filled in where possible</i><br />"; while ($vendorW = $dbc->fetch_row($dataR)) { printf('This product is also in <a href="?upc=%s&vid=%d">%s</a><br />', $upc, $vendorW['vendorID'], $vendorW['vendorName']); } } echo "<form name=pickSubDepartment action=insertItem_WEFC_Toronto.php method=post>"; // 3a. Create - First Block echo "<div id='createBlock'><table style=\"margin-bottom:5px;\" width=\"100%\" border=1 cellpadding=5 cellspacing=0>"; // 8Mar13 Use looked-up upc if there was one. echo "<tr><td align=right><b>UPC</b></td><td><font color='red'></font><input type=text value='"; echo empty($data['upc']) ? $upc : $data['upc']; echo "' name=upc></td><td colspan=2> </td>"; echo "</tr><tr><td><b>Description</b></td><td><input type=text size=30 name='descript' id='descript' class='{$char_count_class}' "; echo isset($data['description']) ? "value=\"{$data['description']}\"" : ""; echo " />"; echo '<div id="descript_count" style="width:1.5em; height:1.4em; text-align:center; padding-top: 0.1em; float:right; margin:0em 3em 0em 0em; border:1px solid #666666;">Char ct</div>'; echo "</td>"; echo "<td align=right><b>Price</b> \$</td>"; echo "<td><input type=text id=price name=price size=6 value='" . showAsMoney($data, "srp") . "' /></td></tr>"; //New{ echo "<tr><td align=right><b>Package Size</b></td><td colspan=1><input type=text name=size id=size size=4 value=\"" . (isset($numeric_size) ? $numeric_size : "") . "\" /> <span title='g oz qt l ml ct'><b>Unit of measure</b></span> <input type=text name=unitofmeasure id=unitofmeasure size=4 value=\"" . (isset($unitofmeasure) ? $unitofmeasure : "") . "\" /></td>"; echo "<td align=right><b>Vendor SKU</b></td><td colspan=1><input type=text name=sku size=8 "; printf("value=\"%s\"", isset($data['sku']) ? $data['sku'] : ''); echo "></td></tr>"; echo "<tr><td align=right><b>Long Desc.</b></td><td colspan=2><input type=text name=puser_description size=60 "; echo isset($data['description']) ? "value=\"{$data['description']}\"" : ""; echo " /></td>"; echo "<td colspan=1> </td></tr>"; //new} echo "<tr><td><b>Manufacturer</b></td><td><input type=text name=manufacturer size=30 "; echo isset($data['brand']) ? "value=\"{$data['brand']}\"" : ""; echo "/></td>\n <td><b>Distributor</b></td><td><input type=text size=8 name=distributor "; echo isset($data['vendorName']) ? "value=\"{$data['vendorName']}\"" : ""; echo "/></td></tr>"; echo "</table>"; // 3b. Create - Second Block echo "<table style=\"margin-bottom:5px;\" width='100%' border=1 cellpadding=5 cellspacing=0><tr>"; echo "<th>Department - Sub-Depts</th><th>Tax</th><th>FS</th><th>Scale</th><th>QtyFrc</th><th>NoDisc</th>"; echo "</tr>"; echo "<tr align=top>"; echo "<td align=left width=5px>"; /** ** BEGIN CHAINEDSELECTOR CLASS **/ require '../src/chainedSelectors.php'; //prepare names $selectorNames = array(CS_FORM => "pickSubDepartment", CS_FIRST_SELECTOR => "department", CS_SECOND_SELECTOR => "subdepartment"); // $department = $rowItem[12] ['department']; // $subdepartment = $rowItem[27] ['subdept']; //query database, assemble data for selectors $Query = "SELECT d.dept_no AS dept_no, d.dept_name AS dept_name,\n CASE WHEN s.subdept_no IS NULL THEN 0 ELSE s.subdept_no END as subdept_no,\n CASE WHEN s.subdept_name IS NULL THEN 'None' ELSE s.subdept_name END AS subdept_name\n FROM departments AS d LEFT JOIN\n subdepts AS s ON d.dept_no=s.dept_ID\n ORDER BY d.dept_no,s.subdept_no"; if (!($DatabaseResult = $dbc->query($Query))) { print "The chained-selector query failed!<br>\n"; return; } while ($row = $dbc->fetch_object($DatabaseResult)) { $selectorData[] = array(CS_SOURCE_ID => $row->dept_no, CS_SOURCE_LABEL => $row->dept_name, CS_TARGET_ID => $row->subdept_no, CS_TARGET_LABEL => $row->subdept_name); } //instantiate class $subdept = new chainedSelectors($selectorNames, $selectorData); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html40/loose.dtd"> <html> <head> <script type="text/javascript" language="JavaScript"> <?php $subdept->printUpdateFunction($row); //rowItem ?> </script> </head> <body> <!-- <form name="pickSubDepartment" action="insertItem.php"> --> <?php $subdept->printSelectors($row); //rowItem ?> <script type="text/javascript" language="JavaScript"> <?php $subdept->initialize(); ?> </script> </body> </html> <?php /** ** CHAINEDSELECTOR CLASS ENDS . . . . . . . NOW **/ echo "</td><td align=left>"; $taxQ = "SELECT id,description FROM taxrates ORDER BY id"; $taxR = $dbc->query($taxQ); $rates = array(); while ($taxW = $dbc->fetch_row($taxR)) { array_push($rates, array($taxW[0], $taxW[1])); } array_push($rates, array("0", "NoTax")); echo "<select name=tax>"; foreach ($rates as $r) { echo "<option value={$r['0']}"; if ($r[0] == "0") { echo " selected"; } echo ">{$r['1']}</option>"; } echo "</select></td>"; echo "<td align=center><input type=checkbox value=1 name=FS"; echo "></td><td align=center><input type=checkbox value=1 name=Scale"; echo "></td><td align=center><input type=checkbox value=1 name=QtyFrc"; echo "></td><td align=center><input type=checkbox value=1 name=NoDisc"; echo "></td>"; echo "</tr></table><!-- /div #createBlock?-->"; echo "<div style='margin: 1.0em 0.0em 0.5em 0.0em;'>"; echo "<input type=submit value=\"Create Item\" />\n \n <a href='../item/itemMaint_WEFC_Toronto.php'><span style='font-size:1.1em;'>Back</span></a>"; echo " \n <span style='color:darkmagenta;'>Last modified: " . date('r') . "</span>"; echo "</div>"; echo "</div><!-- /#createBlock --> "; // 's Create - Deli scale item if (substr($upc, 0, 3) == "002") { // 3c. Create - Deli-Scale Fieldset echo "<br /><div align=center><fieldset><legend>Scale</legend>"; echo "<input type=hidden value=\"{$upc}\" name=s_plu />"; echo "<table style=\"background:#ffffcc;\" cellpadding=5 cellspacing=0 border=1>"; echo "<tr><th colspan=2>Longer description</th><td colspan=4><input size=35 type=text name=s_longdesc maxlength=100"; echo " /></td></tr>"; echo "<tr><td colspan=6 style=\"font-size:1px;\"> </td></tr>"; echo "<tr><th>Weight</th><th>By Count</th><th>Tare</th><th>Shelf Life</th>"; echo "<th>Label</th><th>Safehandling</th></tr>"; echo "<tr>"; echo "<td>"; echo "<input type=radio name=s_type value=\"Random Weight\" checked /> Random<br />"; echo "<input type=radio name=s_type value=\"Fixed Weight\" /> Fixed<br />"; echo "</td>"; echo "<td align=center><input type=checkbox name=s_bycount "; echo "/></td>"; echo "<td align=center><input type=text size=5 name=s_tare "; echo "value=0 /></td>"; echo "<td align=center><input type=text size=5 name=s_shelflife "; echo "value=0 /></td>"; echo "<td><select name=s_label size=2>"; echo "<option value=horizontal selected>Horizontal</option>"; echo "<option value=vertical>Vertical</option>"; echo "</td>"; echo "<td align=center><input type=checkbox name=s_graphics "; echo "/></td>"; echo "</tr>"; echo "<tr><td colspan=6 style=\"font-size:1px;\"> </td></tr>"; echo "<tr><td colspan=6>"; echo "<b>Expanded text:<br /><textarea name=s_text rows=4 cols=50>"; echo "</textarea></td></tr>"; echo "</table></fieldset></div>"; // Create - Deli-Scale } $fieldsetWidth = 13; // 3d. Create - Operations Fieldset echo "<div id='Operations' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Operations', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Operations</legend>"; echo "<div style=\"float:left;\"><ul style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<li style='margin-left:-2.0em;'><input type=checkbox name=newshelftag /> New Shelf Tag</a></li>"; echo "<li style='margin-left:-2.0em;'>Recent Sales<br />History</li>"; echo "<li style='margin-left:-2.0em;'>Price History</li>"; echo "</ul></div>"; echo "</fieldset>"; echo "</div><!-- /#Operations -->"; //'c 3ea. Create - Item Flags Fieldset echo "<div id='Flags' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('ItemFlags', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Item Flags</legend>"; echo "<table>"; $q = "SELECT f.description,\n f.bit_number,\n (1<<(f.bit_number-1)) & p.numflag AS flagIsSet\n FROM products AS p, prodFlags AS f\n WHERE p.upc={$upc}"; $r = $dbc->query($q); // item does not exist. Just get the flag names. if ($dbc->num_rows($r) == 0) { $q = 'SELECT f.description,f.bit_number,0 AS flagIsSet FROM prodFlags AS f'; $r = $dbc->query($q); } $ret = ''; $i = 0; while ($w = $dbc->fetch_row($r)) { if ($i == 0) { $ret .= '<tr>'; } // n-column table if ($i != 0 && $i % 2 == 0) { $ret .= '</tr><tr>'; } $ret .= sprintf('<td><input type="checkbox" name="flags[]" value="%d" %s /></td> <td>%s</td>', $w['bit_number'], $w['flagIsSet'] == 0 ? '' : 'checked', $w['description']); $i++; } if (strlen($ret) > 0) { $ret .= "</tr>"; } echo "{$ret}"; echo "</table>"; echo "</fieldset>"; echo "</div><!-- /#ItemFlags -->"; // 3eb. Create - Extra Info Fieldset echo "<div id='ExtraInfo' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('ExtraInfo', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Extra Info</legend>"; echo "<table><th align=right>Deposit</th>"; echo "<td> <input type='text'"; echo "name='deposit' size='5' value=0></td>"; echo "</tr><th align-right>Location</th>"; echo "<td><input type=text size=5 value=\"\" name=location /></td>"; echo "</tr><th align=right>Local</th>"; echo "<td><input type=checkbox name=local /></td>"; echo "</tr><th align=right>InUse</th>"; echo "<td><input type=checkbox name=inUse checked /></td>"; echo "</tr></table>"; echo "</fieldset>"; echo "</div><!-- /#ExtraInfo -->"; // 3f. Create - Multiples Fieldset // There will never be existing values. echo "<div id='ThreeForDollar' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('ThreeForDollar', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo '<fieldset><legend>"Three for a dollar"</legend>'; echo "<div id='ThreeForDollarRegIn' style='display:block;'>"; echo "<table style='margin:0.0em 0.0em 0.8em 0.0em;'>"; echo "<tr><th align-right>#items</th>"; echo "<td> <input type='text' name='quantity' size='5' value='0'></td>"; echo "</tr><tr><th align=right>For <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text name='groupprice' size=5 value='0.00'></td>"; // ?pricemethod must default to 0. echo "</tr><th align-right>Method</th>"; echo "<td><input type='text' name='pricemethod' size='5' value='0'></td>"; echo "</tr><th align-right>MixMatch</th>"; echo "<td><input type='text' name='mixmatchcode' size='5' value='0'></td>"; echo "</tr></table>"; echo "</div><!-- /#ThreeForDollarRegIn -->"; echo "</fieldset>"; echo "</div><!-- /#ThreeForDollar -->"; // 3g. Create - Cost Fieldset echo "<div id='Cost' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Cost', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Cost</legend>"; echo "<!-- div style=\"float:left;margin-left:20px;\" -->"; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<tr><th align=right>Single <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text size=5 value='" . showAsMoney($data, 'cost') . "' id=cost name=cost onchange='cscallback();' /></td>"; echo "</tr><tr><th align=right>Case <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text name='case_cost' size=5 value='" . showAsMoney($data, 'case_cost') . "' /></td>"; echo "</tr><tr><th align=right>Items/case</th>"; printf("<td><input type=text name='case_quantity' size=5 value=\"%s\" /></td>", isset($data['units']) && is_numeric($data['units']) ? $data['units'] : ''); echo "</tr></table>"; echo "<!-- /div -->"; echo "</fieldset>"; echo "</div><!-- /#Cost -->"; // 3h. Create - Sale Fieldset echo "<div id='Sale' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Sale', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo '<fieldset><legend>Sale</legend>'; echo "<!-- div style=\"float:left;margin-left:20px;\" -->"; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<tr><th align-right>Start Date</th>"; echo "<td><input type=text size=6 value='" . date('Y-m-d') . "' name=start_date id=start_date /></td>"; echo "</tr><tr><th align-right>End Date</th>"; echo "<td><input type=text size=6 value='" . date('Y-m-d') . "' name=end_date id=end_date /></td>"; echo "</tr><tr><th align-right>Sale for</th>"; // This should really be in the db and be per-coop-configurable. $discounttypes = array(0 => "None", 1 => "All", 2 => "Mem."); echo "<td><select name=discounttype>"; $data['discounttype'] = 0; for ($n = 0; $n < 3; $n++) { echo "<option value='{$n}'"; if ($n == $data['discounttype']) { echo " SELECTED"; } echo ">{$discounttypes[$n]}</option>"; } echo "</select></td>"; echo "</tr><tr><th align=right>Price <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text size=5 value='0.00' id=special_price name=special_price /></td>"; echo "</tr></table>"; echo '<fieldset><legend>"Three for a dollar"</legend>'; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; // quantity must default to 0. echo "<tr><th align-right>#Items</th>"; echo "<td> <input type='text' name='specialquantity' size='5' value='0'></td>"; echo "</tr><tr><th align=right>For <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text name='specialgroupprice' size=5 value='0.00'></td>"; // ?pricemethod must default to 0. echo "</tr><th align-right>Method</th>"; echo "<td><input type='text' name='specialpricemethod' size='5' value='0'></td>"; echo "</tr></table>"; echo '</fieldset><!-- 3/$1 -->'; echo "<!-- /div -->"; echo '</fieldset><!-- /#sale -->'; echo "</div><!-- /#Sale -->"; // 3i. Create - Margin Fieldset echo "<div id='Margin' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Margin', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset id=marginfs>"; echo "<legend>Margin</legend>"; echo "</fieldset>"; echo "<script type=\"text/javascript\">cscallback();</script>"; echo "</div><!-- /#Margin -->"; // 3j. Create - Likecode Fieldset echo "<div id='LikeCode' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('LikeCode', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo '<fieldset><legend>Likecode</legend>'; echo "<table border=0><tr><td><b>Like code</b> "; $lcWidth = $fieldsetWidth - 4; // Was 175px echo "<tr><td><select name=likeCode style=\"width: {$lcWidth}em;\"\n onchange=\"updateLC(this.value);\">"; echo "<option value=-1>(none)</option>"; $likelistQ = "select * from likeCodes order by likecode"; $likelistR = $dbc->query($likelistQ); while ($llRow = $dbc->fetch_array($likelistR)) { echo "<option value={$llRow[0]}"; echo ">{$llRow[0]} {$llRow[1]}</option>"; } echo "</select></td></tr>"; echo "<tr><td><input type=checkbox name=update value='no'>Check to not update like code items</td></tr>"; echo "<tr id=lchidden style=\"display:none;\""; echo "><td><b>Like Code Linked Items</b><div id=lctable>"; echo '</div></td><td valign=top><a href="../reports/RecentSales/?likecode=' . $likeCodeRow[1] . '" target="_recentlike">'; echo 'Likecode Sales History</td>'; echo '</tr></table></fieldset>'; echo "</div><!-- /#LikeCode -->"; // Form for Create. } elseif ($num > 1) { moreItems($upc); for ($i = 0; $i < $num; $i++) { $rowItem = $dbc->fetch_array($resultItem); $upc = $rowItem['upc']; echo "<a href='../item/itemMaint_WEFC_Toronto.php?upc={$upc}'>" . $upc . " </a>- " . $rowItem['description']; if ($rowItem['discounttype'] == 0) { echo "-- \$" . $rowItem['normal_price'] . "<br>"; } else { echo "-- <font color=green>\$" . $rowItem['special_price'] . " onsale</font><br>"; } } } else { if ($FANNIE_STORE_ID != 0) { /* if this isn't HQ, revise the lookup query to search for HQ records AND store records ordering by store_id descending means we'll get the store record if there is one and the HQ record if there isn't */ $clause = sprintf("p.store_id IN (0,%d)", $FANNIE_STORE_ID); $queryItem = str_replace("p.store_id=0", $clause, $queryItem); if (strstr($queryItem, "ORDER BY")) { $queryItem = array_shift(explode("ORDER BY", $queryItem)); } $queryItem .= " ORDER BY p.store_id DESC"; $resultItem = $dbc->query($queryItem); } // products.* and prodExtra .manufacturer and .distributor $rowItem = $dbc->fetch_array($resultItem); // All of prodExtra $upc = $rowItem['upc']; $xtraQ = "SELECT * FROM prodExtra WHERE upc='{$upc}'"; $xtraR = $dbc->query($xtraQ); $xtraRow = $dbc->fetch_row($xtraR); //EL+ All of productUser $userQ = "SELECT * FROM productUser WHERE upc='{$upc}'"; $userR = $dbc->query($userQ); $userRow = $dbc->fetch_row($userR); /* For WEFC_Toronto only * Raw versions of products.description and productUser.descriptio * are in products_WEFC_Toronto */ if (isset($FANNIE_COOP_ID) && $FANNIE_COOP_ID == "WEFC_Toronto") { $coopQ = "SELECT * FROM products_{$FANNIE_COOP_ID} WHERE upc='{$upc}'"; $coopR = $dbc->query($coopQ); $coopRow = $dbc->fetch_row($coopR); if (!empty($coopRow['description'])) { $rowItem['description'] = $coopRow['description']; } if (!empty($coopRow['search_description'])) { $userRow['description'] = $coopRow['search_description']; } } $char_count_class = "char_count"; if (isset($FANNIE_COMPOSE_PRODUCT_DESCRIPTION) && $FANNIE_COMPOSE_PRODUCT_DESCRIPTION == "1") { $char_count_class = "char_count_pkg"; } // Get the previous and next upc from the same department. $pnQ = "SELECT upc FROM products WHERE department=" . $rowItem['department'] . " ORDER BY upc"; $prevUPC = False; $nextUPC = False; $passed_it = False; $pnR = $dbc->query($pnQ); while ($pnW = $dbc->fetch_row($pnR)) { if (!$passed_it && $upc != $pnW[0]) { $prevUPC = $pnW[0]; } else { if (!$passed_it && $upc == $pnW[0]) { $passed_it = True; } else { if ($passed_it) { $nextUPC = $pnW[0]; break; } } } } echo "<head><title>Update Item</title>"; echo "</head>"; echo "<body onload='putFocus(0,3);'>"; oneItem($upc); echo "<form name=pickSubDepartment action='updateItems_WEFC_Toronto.php' method=post>"; // 5a. Update - First Block echo "<div id='updateBlock' style=''><table border=1 cellpadding=5 cellspacing=0>"; echo "<tr><td align=right><b>UPC</b></td><td><font color='red'>" . $rowItem['upc'] . "</font><input type=hidden value='{$rowItem['upc']}' id=upc name=upc>"; if ($prevUPC) { echo " <a style=\"font-size:85%;\" href=itemMaint_WEFC_Toronto.php?upc={$prevUPC}>Previous</a>"; } if ($nextUPC) { echo " <a style=\"font-size:85%;\" href=itemMaint_WEFC_Toronto.php?upc={$nextUPC}>Next</a>"; } echo '</td>'; echo '<td colspan=2>'; echo '<input type="hidden" name="store_id" value="' . $rowItem['store_id'] . '" />'; echo ($rowItem['store_id'] == 0 ? 'Master' : 'Store') . ' record'; echo '</td></tr><tr><td align=right><b>Description</b></td><td>'; echo '<input type=text size=30 value="' . $rowItem['description'] . '" name="descript" id="descript" ' . "class='{$char_count_class}' />"; echo '<div id="descript_count" style="width:1.5em; height:1.4em; text-align:center; padding-top: 0.1em; float:right; margin:0em 3em 0em 0em; border:1px solid #666666;">Char ct</div>'; echo '</td>'; // If the ThreeForDollar (Multiples) fieldset/module is enabled support only normal_price editing here. if (array_search('ThreeForDollar', $Fannie_Item_Modules) !== False) { echo "<td align=right><b>Price</b></td>"; echo '<td><span id=price1 style="display:' . (True ? 'inline' : 'none') . ';">$ <input id=price type=text value="' . showAsMoney($rowItem, 'normal_price') . '" name=price size=6></span></td></tr>'; } else { echo "<td><select onchange=\"if(this.value=='Price'){\n document.getElementById('price2').style.display='none';\n document.getElementById('price1').style.display='inline';\n }else{\n document.getElementById('price1').style.display='none';\n document.getElementById('price2').style.display='inline';\n }\">\n <option" . ($rowItem['groupprice'] == 0 ? ' SELECTED' : '') . ">Price</option>\n <option" . ($rowItem['groupprice'] != 0 ? ' SELECTED' : '') . ">Volume Price</option></select></td>"; echo '<td><span id=price1 style="display:' . ($rowItem['groupprice'] == 0 ? 'inline' : 'none') . ';">$ <input id=price type=text value="' . showAsMoney($rowItem, 'normal_price') . '" name=price size=6></span>'; echo '<span id=price2 style="display:' . ($rowItem['groupprice'] == 0 ? 'none' : 'inline') . ';"><input type=text size=4 name=vol_qtty value="' . ($rowItem['quantity'] != 0 ? $rowItem['quantity'] : '') . '" />'; echo " for \$<input type=text size=4 name=vol_price value=" . ($rowItem['groupprice'] != 0 ? $rowItem['groupprice'] : "\"\"") . " />"; echo '<input type=checkbox name=doVolume ' . ($rowItem['groupprice'] != 0 ? 'checked' : '') . ' /></span>'; echo '<input type=hidden name=vol_pricemethod value=' . $rowItem['pricemethod'] . ' />'; echo '</td></tr>'; } echo "<tr><td align=right><b>Package Size</b></td><td colspan=1><input type=text name=size id=size size=4 value=\"" . (isset($rowItem['size']) ? $rowItem['size'] : "") . "\" /> <span title='g oz qt l ml ct'><b>Unit of measure</b></span> <input type=text name=unitofmeasure id=unitofmeasure size=4 value=\"" . (isset($rowItem['unitofmeasure']) ? $rowItem['unitofmeasure'] : "") . "\" /></td>"; echo "<td align=right><b>Vendor SKU</b></td><td colspan=1><input type=text name=sku size=8 value=\"" . (isset($rowItem['sku']) ? $rowItem['sku'] : "") . "\" /></td></tr>"; echo "<tr><td align=right><b>Long Desc.</b></td><td colspan=2><input type=text name=puser_description size=60 value=\"" . (isset($userRow['description']) ? $userRow['description'] : "") . "\" /></td>"; echo "<td colspan=1> </td></tr>"; echo "<tr><td align=right><b>Manufacturer</b></td><td><input type=text name=manufacturer size=30 value=\"" . (isset($xtraRow['manufacturer']) ? $xtraRow['manufacturer'] : "") . "\" /></td>"; echo "<td align=right><b>Distributor</b></td><td><input type=text name=distributor size=8 value=\"" . (isset($xtraRow['distributor']) ? $xtraRow['distributor'] : "") . "\" /></td></tr>"; // If the item is on sale. if ($rowItem['special_price'] != 0) { $batchQ = "SELECT b.batchName FROM batches AS b\n LEFT JOIN batchList as l ON b.batchID=l.batchID\n WHERE '" . date('Y-m-d') . "' BETWEEN b.startDate\n AND b.endDate AND (l.upc='{$upc}' OR l.upc='LC{$likecode}')"; $batchR = $dbc->query($batchQ); $batch = "Unknown"; if ($dbc->num_rows($batchR) > 0) { $batch = array_pop($dbc->fetch_row($batchR)); } echo "<tr><td><font color=green><b>Sale Price:</b></font></td>" . "<td><font color=green>{$rowItem['special_price']}</font> (<em>Batch: {$batch}</em>)</td>"; echo "<td><font color=green>End Date:</td><td><font color=green>{$rowItem['end_date']}</font></td><tr>"; } echo "</table>"; // 5b. Update - Second Block echo "<table style=\"margin-top:5px;margin-bottom:5px;\" border=1 cellpadding=5 cellspacing=0 width='100%'><tr>"; echo "<th>Deparment - Sub-Depts</th><th>Tax</th><th>FS</th><th>Scale</th><th>QtyFrc</th><th>NoDisc</th>"; echo "</tr>"; echo "<tr align=top>"; echo "<td align=left>"; /** ** BEGIN CHAINEDSELECTOR CLASS **/ $selectorNames = array(CS_FORM => "pickSubDepartment", CS_FIRST_SELECTOR => "department", CS_SECOND_SELECTOR => "subdepartment"); $Query = "SELECT d.dept_no AS dept_no, d.dept_name AS dept_name,\n CASE WHEN s.subdept_no IS NULL THEN 0 ELSE s.subdept_no END as subdept_no,\n CASE WHEN s.subdept_name IS NULL THEN 'None' ELSE s.subdept_name END AS subdept_name\n FROM departments AS d LEFT JOIN\n subdepts AS s ON d.dept_no=s.dept_ID\n ORDER BY d.dept_no,s.subdept_no"; $DatabaseResult = False; if (!($DatabaseResult = $dbc->query($Query))) { print "The query failed!<br>\n"; return; } while ($row = $dbc->fetch_object($DatabaseResult)) { $selectorData[] = array(CS_SOURCE_ID => $row->dept_no, CS_SOURCE_LABEL => $row->dept_no . " - " . $row->dept_name, CS_TARGET_ID => $row->subdept_no, CS_TARGET_LABEL => $row->subdept_name); } $subdept = new chainedSelectors($selectorNames, $selectorData); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html40/loose.dtd"> <html> <head> <script type="text/javascript" language="JavaScript"> <?php $subdept->printUpdateFunction($rowItem); ?> </script> </head> <body> <!-- <form name="pickSubDepartment" action="updateItems.php"> --> <?php $subdept->printSelectors($rowItem); ?> <script type="text/javascript" language="JavaScript"> <?php $subdept->initialize(); ?> </script> </body> </html> <?php /** ** CHAINEDSELECTOR CLASS ENDS . . . . . . . NOW **/ // echo " </td>"; echo "</td><td align=left>"; $taxQ = "SELECT id,description FROM taxrates ORDER BY id"; $taxR = $dbc->query($taxQ); $rates = array(); while ($taxW = $dbc->fetch_row($taxR)) { array_push($rates, array($taxW[0], $taxW[1])); } array_push($rates, array("0", "NoTax")); echo "<select name=tax>"; foreach ($rates as $r) { echo "<option value={$r['0']}"; if ($rowItem['tax'] == $r[0]) { echo " selected"; } echo ">{$r['1']}</option>"; } echo "</select>"; echo "</td><td align=center><input type=checkbox value=1 name=FS"; if ($rowItem["foodstamp"] == 1) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=1 name=Scale"; if ($rowItem['scale'] == 1) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=1 name=QtyFrc"; if ($rowItem["qttyEnforced"] == 1) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=0 name=NoDisc"; if ($rowItem["discount"] == 0) { echo " checked"; } echo "></td>"; echo "</tr><tr></table>"; echo "<div style='margin: 1.0em 0.0em 0.5em 0.0em;'>"; echo "<input type='submit' name='submit' value='Update Item'>\n \n <a href='../item/itemMaint_WEFC_Toronto.php'><span style='font-size:1.1em;'>Back</span></a>"; echo " \n <span style='color:darkmagenta;'>Last modified: {$rowItem['modified']}</span>"; echo " \n <a href=\"deleteItem_WEFC_Toronto.php?upc={$upc}&submit=submit\">Delete this item</a>"; echo "</div> "; echo "</div><!-- /#updateBlock --> "; if (substr($upc, 0, 3) == "002") { // 5c. Update - Deli-Scale Fieldset // Might be better to do top whitespace with margin. echo "<br /><div align=center><fieldset><legend>Scale</legend>"; echo "<input type=hidden value=\"{$upc}\" name=s_plu />"; $scaleR = $dbc->query("SELECT * FROM scaleItems WHERE plu='{$upc}'"); $scale = array(); if ($dbc->num_rows($scaleR) > 0) { $scale = $dbc->fetch_row($scaleR); } echo "<table style=\"background:#ffffcc;\" cellpadding=5 cellspacing=0 border=1>"; echo "<tr><th colspan=2>Longer description</th><td colspan=4><input size=35 type=text name=s_longdesc maxlength=100"; if (isset($scale['itemdesc']) && $scale['itemdesc'] != $rowItem['description']) { echo " value=\"" . $scale['itemdesc'] . "\""; } echo " /></td></tr>"; echo "<tr><td colspan=6 style=\"font-size:1px;\"> </td></tr>"; echo "<tr><th>Weight</th><th>By Count</th><th>Tare</th><th>Shelf Life</th>"; echo "<th>Label</th><th>Safehandling</th></tr>"; echo "<tr>"; echo "<td>"; if (!isset($scale['weight']) || $scale['weight'] == 0) { echo "<input type=radio name=s_type value=\"Random Weight\" checked /> Random<br />"; echo "<input type=radio name=s_type value=\"Fixed Weight\" /> Fixed<br />"; } else { echo "<input type=radio name=s_type value=\"Random Weight\" /> Random<br />"; echo "<input type=radio name=s_type value=\"Fixed Weight\" checked /> Fixed<br />"; } echo "</td>"; echo "<td align=center><input type=checkbox name=s_bycount "; if (isset($scale['bycount']) && $scale['bycount'] == 1) { echo "checked "; } echo "/></td>"; echo "<td align=center><input type=text size=5 name=s_tare "; echo "value=" . (isset($scale['tare']) ? $scale['tare'] : '0'); echo " /></td>"; echo "<td align=center><input type=text size=5 name=s_shelflife "; echo "value=" . (isset($scale['shelflife']) ? $scale['shelflife'] : '0'); echo " /></td>"; echo "<td><select name=s_label size=2>"; if (isset($scale['label']) && ($scale['label'] == 133 || $scale['label'] == 63)) { echo "<option value=horizontal selected>Horizontal</option>"; echo "<option value=vertical>Vertical</option>"; } else { if (!isset($scale['label'])) { echo "<option value=horizontal selected>Horizontal</option>"; echo "<option value=vertical>Vertical</option>"; } else { echo "<option value=horizontal>Horizontal</option>"; echo "<option value=vertical selected>Vertical</option>"; } } echo "</td>"; echo "<td align=center><input type=checkbox name=s_graphics "; if (isset($scale['graphics']) && $scale['graphics'] == 1) { echo "checked "; } echo "/></td>"; echo "</tr>"; echo "<tr><td colspan=6 style=\"font-size:1px;\"> </td></tr>"; echo "<tr><td colspan=6>"; echo "<b>Expanded text:<br /><textarea name=s_text rows=4 cols=50>"; echo isset($scale['text']) ? $scale['text'] : ''; echo "</textarea></td></tr>"; echo "</table></fieldset></div>"; // Update - Deli-Scale } // 5d. Update - Operations Fieldset $fieldsetWidth = 13; echo "<div id='Operations' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Operations', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Operations</legend>"; echo "<div style=\"float:left;\"><ul style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<li style='margin-left:-2.0em;'><a href=\"javascript:shelftag('{$upc}');\" title='Using the un-edited data.' >Current Shelf Tag</a></li>"; echo "<li style='margin-left:-2.0em;'><input type=checkbox name=newshelftag title='Using the edited data, after you click Update.' /> <span title='Using the edited data, after you click Update.'>New Shelf Tag</span></li>"; echo "<li style='margin-left:-2.0em;'><a href=\"../reports/RecentSales/?upc={$upc}\" target='_recentsales'>"; echo "Recent Sales<br /> History</a></li>"; //echo "</ul></div>"; //echo "<div style=\"float:left;\"><ul style='margin-top:0.0em;'>"; echo "<li style='margin-left:-2.0em;'><a href=\"../reports/PriceHistory/?upc={$upc}\" target=\"_price_history\">Price History</a></li>"; echo "</ul></div>"; echo "</fieldset>"; echo "</div>"; echo "</div><!-- /#Operations -->"; //'u 5ea. Update - Item Flags Fieldset echo "<div id='Flags' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('ItemFlags', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Item Flags</legend>"; echo "<table>"; $q = "SELECT f.description,\n f.bit_number,\n (1<<(f.bit_number-1)) & p.numflag AS flagIsSet\n FROM products AS p, prodFlags AS f\n WHERE p.upc={$upc}\n ORDER BY f.bit_number"; $r = $dbc->query($q); // item does not exist. Just get the flag names. if ($dbc->num_rows($r) == 0) { $q = 'SELECT f.description,f.bit_number,0 AS flagIsSet FROM prodFlags AS f'; $r = $dbc->query($q); } $ret = ''; $i = 0; while ($w = $dbc->fetch_row($r)) { if ($i == 0) { $ret .= '<tr>'; } // n-column table if ($i != 0 && $i % 2 == 0) { $ret .= '</tr><tr>'; } $ret .= sprintf('<td><input type="checkbox" name="flags[]" value="%d" %s /></td> <td>%s</td>', $w['bit_number'], $w['flagIsSet'] == 0 ? '' : 'checked', $w['description']); $i++; } if (strlen($ret) > 0) { $ret .= "</tr>"; } echo "{$ret}"; echo "</table>"; echo "</fieldset>"; echo "</div><!-- /#ItemFlags -->"; // 5e. Update - Extra Info Fieldset // ->EL Why does the top of this fieldset align below the top of Operations here but even with it in Create? echo "<div id='ExtraInfo' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('ExtraInfo', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Extra Info</legend>"; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<tr><th align=right>Deposit</th>"; echo "<td> <input type='text' name='deposit' "; if (!isset($rowItem['deposit']) || $rowItem['deposit'] == 0) { echo "value='0'"; } else { echo "value='{$rowItem['deposit']}'"; } echo " size='5'></td>"; echo "</tr><th align-right>Location</th>"; echo "<td><input type=text name=location size=5 value=\"{$xtraRow['location']}\" /></td>"; echo "</tr><th align=right>Local</th>"; echo "<td><input type=checkbox name=local " . ($rowItem['local'] == 1 ? 'checked' : '') . " /></td>"; echo "</tr><th align=right>InUse</th>"; echo "<td><input type=checkbox name=inUse " . ($rowItem['inUse'] == 1 ? 'checked' : '') . " /></td>"; echo "</tr></table>"; echo "</fieldset>"; echo "</div><!-- /#ExtraInfo -->"; // 5f. Update - Multiples Fieldset echo "<div id='ThreeForDollar' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('ThreeForDollar', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo '<fieldset><legend>"Three for a dollar"</legend>'; echo "<div id='ThreeForDollarRegIn' style='display:block;'>"; echo "<table style='margin:0.0em 0.0em 0.8em 0.0em;'>"; echo "<tr><th align-right>#items</th>"; echo "<td> <input type='text'"; if (!isset($rowItem['quantity']) || $rowItem['quantity'] == 0) { echo "value='0'"; } else { echo "value='{$rowItem['quantity']}'"; } echo "name='quantity' size='5'></td>"; echo "</tr><tr><th align=right>For <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text size=5 value='" . showAsMoney($rowItem, "groupprice") . "' id=groupprice name=groupprice /></td>"; // ?pricemethod must default to 0. echo "</tr><th align-right>Method</th>"; echo "<td> <input type='text'"; if (!isset($rowItem['pricemethod']) || $rowItem['pricemethod'] == 0) { echo "value='0'"; } else { echo "value='{$rowItem['pricemethod']}'"; } echo "id='pricemethod' name='pricemethod' size='5'></td>"; echo "</tr><th align-right>MixMatch</th>"; echo "<td><input type=text size=5 value=\"{$rowItem['mixmatchcode']}\" name=mixmatchcode /></td>"; echo "</tr></table>"; echo "</div><!-- /#ThreeForDollarRegIn -->"; echo "</fieldset>"; echo "</div><!-- /#ThreeForDollar -->"; // 5g. Update - Cost Fieldset echo "<div id='Cost' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Cost', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Cost</legend>"; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<tr><th align=right>Single <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text size=5 value='" . showAsMoney($rowItem, 'cost') . "' id=cost name=cost onchange='cscallback();' /></td>"; echo "</tr><tr><th align=right>Case <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text name='case_cost' size=5 value='" . showAsMoney($xtraRow, 'case_cost') . "' /></td>"; echo "</tr><tr><th align=right>Items/case</th>"; printf("<td><input type=text name='case_quantity' size=5 value=\"%s\" /></td>", isset($xtraRow['case_quantity']) && is_numeric($xtraRow['case_quantity']) ? $xtraRow['case_quantity'] : ''); echo "</tr></table>"; echo "</fieldset>"; echo "</div><!-- /#Cost -->"; // 5h. Update - Sale Fieldset echo "<div id='Sale' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Sale', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo '<fieldset><legend>Sale</legend>'; echo "<!-- div style=\"float:left;margin-left:20px;\" -->"; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; echo "<tr><th align-right>Start Date</th>"; echo "<td><input type=text name=start_date size=6 value=\"{$rowItem['start_date']}\" id=start_date /></td>"; echo "</tr><tr><th align-right>End Date</th>"; echo "<td><input type=text name=end_date size=6 value=\"{$rowItem['end_date']}\" id=end_date /></td>"; echo "</tr><tr><th align-right>Sale for</th>"; // This should really be in the db and be per-coop-configurable. $discounttypes = array(0 => "None", 1 => "All", 2 => "Mem."); echo "<td><select name=discounttype>"; if ($rowItem['discounttype'] == "") { $rowItem['discounttype'] = 0; } for ($n = 0; $n < 3; $n++) { echo "<option value='{$n}'"; if ($n == $rowItem['discounttype']) { echo " SELECTED"; } echo ">{$discounttypes[$n]}</option>"; } echo "</select></td>"; echo "</tr><tr><th align=right>Price <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text size=5 value='" . showAsMoney($rowItem, "special_price") . "' id=special_price name=special_price /></td>"; echo "</tr></table>"; echo '<fieldset><legend>"Three for a dollar"</legend>'; echo "<table style='margin:0.0em 0.0em 0.0em 0.0em;'>"; // quantity must default to 0. echo "<tr><th align-right>#Items</th>"; echo "<td> <input type='text'"; if (!isset($rowItem['specialquantity']) || $rowItem['specialquantity'] == 0) { echo "value='0'"; } else { echo "value='{$rowItem['specialquantity']}'"; } echo "name='specialquantity' size='5'></td>"; echo "</tr><tr><th align=right>For <span style='font-weight:400;'>\$</span></th>"; echo "<td><input type=text size=5 value='" . showAsMoney($rowItem, "specialgroupprice") . "' id=specialgroupprice name=specialgroupprice /></td>"; // ?pricemethod must default to 0. echo "</tr><th align-right>Method</th>"; echo "<td> <input type='text'"; if (!isset($rowItem['specialpricemethod']) || $rowItem['specialpricemethod'] == 0) { echo "value='0'"; } else { echo "value='{$rowItem['specialpricemethod']}'"; } echo "name='specialpricemethod' size='5'></td>"; echo "</tr></table>"; echo '</fieldset><!-- 3/$1 -->'; echo "<!-- /div -->"; echo '</fieldset><!-- /#sale -->'; echo "</div><!-- /#Sale -->"; // 5i. Update - Margin Fieldset echo "<div id='Margin' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('Margin', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset id=marginfs>"; echo "<legend>Margin</legend>"; MarginFS($rowItem['upc'], $rowItem['cost'], $rowItem['department']); echo "</fieldset>"; echo '</div>'; //of what? echo "</div><!-- /#Margin -->"; // 5j. Update - Likecode Fieldset echo "<div id='LikeCode' style='float:left; margin-left:10px; width:{$fieldsetWidth}em; " . "display:" . (array_search('LikeCode', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo "<fieldset><legend>Likecode</legend>"; echo "<table border=0>"; echo "<tr><td><b>Like code</b></td></tr>"; $lcWidth = $fieldsetWidth - 4; // Was 175px echo "<tr><td><select name=likeCode style=\"width: {$lcWidth}em;\"\n onchange=\"updateLC(this.value);\">"; echo "<option value=-1>(none)</option>"; $likelistQ = "select * from likeCodes order by likecode"; $likelistR = $dbc->query($likelistQ); while ($llRow = $dbc->fetch_array($likelistR)) { echo "<option value={$llRow[0]}"; if ($llRow[0] == $likecode) { echo " selected"; } echo ">{$llRow[0]} {$llRow[1]}</option>"; } echo "</select></td></tr>"; echo "<tr><td><input type=checkbox name=update value='no'>Check to not update like code items</td></tr>"; echo "<tr id=lchidden"; if ($likeCodeNum <= 0) { echo ' style="display:none;"'; } echo "><td><b>Like Code Linked Items</b><div id=lctable>"; GetLikecodeItems($likecode); echo '</div></td></tr>'; echo '<tr><td valign=top><a href="../reports/RecentSales/?likecode=' . $likeCodeRow[1] . '" target="_recentlike">'; echo 'Likecode Sales History</td>'; echo '</tr>'; echo '</table></fieldset>'; echo '</div>'; echo "</div><!-- /#LikeCode -->"; echo "<br style='clear:both;' /><br />"; // 5k. Update - Lane Status Fieldset echo "<div id='LaneStatus' style='display:" . (array_search('LaneStatus', $Fannie_Item_Modules) !== False ? 'block' : 'none') . ";'>"; echo '<fieldset id="lanefs">'; echo '<legend>Lane Status</legend>'; include 'prodAllLanes_WEFC_Toronto.php'; echo allLanes($upc); echo '</fieldset>'; echo "</div><!-- /#LaneStatus -->"; } return $num; // itemParse }
function itemParse($upc, $dupe = 'no', $description = '', $prefix = false) { global $sql; /* why am I only checking for being logged in here * instead of a specific permission? * * The enter and update item pages do that check * For new items, permission could be dependent on * which subdepartment is selected. For changing an item, * changing subdepartment introduces odd scenarios, * switching in and out of valid permission. Easier to just * check the final changes. */ $logged_in = checkLogin(); $p_columns = ' p.upc, p.description, p.normal_price, p.pricemethod, p.quantity, p.groupprice, p.special_price, p.end_date, p.department, p.tax, p.foodstamp, p.scale, p.qttyEnforced, p.discount, p.modified, p.local '; // last comma omitted on purpose $savedUPC = ""; $queryItem = ""; $args = array(); $numType = isset($_REQUEST['ntype']) ? $_REQUEST['ntype'] : 'UPC'; if (is_numeric($upc)) { switch ($numType) { case 'UPC': $upc = str_pad($upc, 13, 0, STR_PAD_LEFT); $savedUPC = $upc; $queryItem = "SELECT {$p_columns},x.distributor,x.manufacturer,\n u.brand,u.description as udesc,u.sizing,u.photo,\n u.long_text,u.enableOnline,e.expires\n FROM products as p left join \n prodExtra as x on p.upc=x.upc \n LEFT JOIN productUser as u\n ON p.upc=u.upc LEFT JOIN productExpires\n AS e ON p.upc=e.upc\n WHERE p.upc = ? or x.upc = ?"; $args = array($upc, $upc); break; case 'SKU': $queryItem = "SELECT {$p_columns},x.distributor,x.manufacturer,\n u.brand,u.description as udesc,u.sizing,u.photo,\n u.long_text,u.enableOnline,e.expires\n FROM products as p inner join \n vendorItems as v ON p.upc=v.upc \n left join prodExtra as x on p.upc=x.upc \n LEFT JOIN productUser as u\n ON p.upc=u.upc LEFT JOIN productExpires\n AS e ON p.upc=e.upc\n WHERE v.sku=?"; $args = array($upc); break; case 'Brand Prefix': $queryItem = "SELECT {$p_columns},x.distributor,x.manufacturer,\n u.brand,u.description as udesc,u.sizing,u.photo,\n u.long_text,u.enableOnline,e.expires\n FROM products as p \n left join prodExtra as x on p.upc=x.upc \n LEFT JOIN productUser as u\n ON p.upc=u.upc LEFT JOIN productExpires\n AS e ON p.upc=e.upc\n WHERE p.upc like ? order by p.upc"; $args = array('%' . $upc . '%'); break; } } else { $queryItem = "SELECT {$p_columns},x.distributor,x.manufacturer,\n u.brand,u.description as udesc,u.sizing,u.photo,\n u.long_text,u.enableOnline,e.expires\n FROM products as p left join \n prodExtra as x on p.upc=x.upc \n LEFT JOIN productUser as u\n ON p.upc=u.upc LEFT JOIN productExpires\n AS e ON p.upc=e.upc\n WHERE p.description LIKE ? OR \n u.description LIKE ? ORDER BY p.description"; $args = array('%' . $upc . '%', '%' . $upc . '%'); } //echo $queryItem; echo "<script type=\"text/javascript\">"; echo "function shelftag(u){"; echo "testwindow= window.open (\"../../item/addShelfTag.php?upc=\"+u, \"New Shelftag\",\"location=0,status=1,scrollbars=1,width=300,height=220\");"; echo "testwindow.moveTo(50,50);"; echo "}"; echo "</script>"; $barcodeUPC = ltrim($upc, "0"); echo "<script language=JavaScript>"; echo "function popup(){"; echo "testwindow= window.open (\"addLikeCode.php\", \"Add Like Code\",\"location=0,status=1,scrollbars=1,width=200,height=200\");"; echo "testwindow.moveTo(50,50);"; echo "}"; echo "</script>"; echo "<script language=JavaScript>"; echo "function newTagCheck(){"; echo "if (document.getElementById('newTag').checked)"; //echo "shelftag();"; echo "}"; echo "</script>"; $num = 0; $prepItem = $sql->prepare($queryItem); $resultItem = $sql->execute($prepItem, $args); $num = $sql->num_rows($resultItem); $likeCodeQ = $sql->prepare("SELECT u.*,l.likeCodeDesc FROM upcLike as u, likeCodes as l \n WHERE u.likeCode = l.likeCode and u.upc = ?"); $likeCodeR = $sql->execute($likeCodeQ, array($upc)); $likeCodeRow = $sql->fetch_row($likeCodeR); $likeCodeNum = $sql->num_rows($likeCodeR); $listCodeQ = "SELECT * from likeCodes"; $listCodeR = $sql->query($listCodeQ); $listCodeRow = $sql->fetch_row($likeCodeR); if ($num == 0) { noItem(); echo "<head><title>Enter New Item</title></head>"; echo "<BODY onLoad='putFocus(0,1);'>"; printMods($savedUPC); echo "Item not found, would you like to enter it?"; echo "<form action=enterTestItem.php method=post onsubmit=\"newTagCheck();\">"; echo "<table>"; echo "<tr><td align=right><b>UPC</b></td><td><font color='red'></font>\n <input type=text value={$upc} name=upc maxlength=13></td>"; echo "</tr><tr><td><b>Description</b></td><td>\n <input type=text size=35 name=descript maxlength=30></td>"; echo "<td><b>Price</b></td><td>\$<input type=text name=price></td></tr>"; echo "<tr><td><b>Manufacturer</b></td><td><input type=text size=35 value=\"\" name=manufacturer /></td>"; echo "<td><b>Distributor</b></td><td> <input type=text value=\"\" name=distributor /></td></tr>"; echo "</table>"; echo "<table border=0><tr>"; echo "<th>Dept<th>Tax<th>FS<th>Scale<th>QtyFrc<th>NoDisc<th>Local<th>Like Code<th>Shelf Tag</b>"; echo "</tr>"; echo "<tr>"; $query2 = "SELECT * FROM departments as d,\n MasterSuperDepts AS s WHERE s.dept_ID=d.dept_no AND dept_no NOT IN (60,225)\n ORDER BY superID, dept_no"; echo "<td>"; $upc_split = substr($upc, 0, 7); $guessQ = $sql->prepare("select department from products where upc like ?\n group by department\n order by count(*) desc"); $guessR = $sql->execute($guessQ, array($upc_split . '%')); $guess = 60; if ($sql->num_rows($guessR) > 0) { $guessW = $sql->fetch_array($guessR); } $guess = $guessW['department']; echo '<select name="dept">'; $result2 = $sql->query($query2); while ($row2 = $sql->fetch_row($result2)) { printf('<option %s value="%d">%d %s</option>', $row2['dept_no'] == $guess ? 'selected' : '', $row2['dept_no'], $row2['dept_no'], $row2['dept_name']); } echo '</select>'; echo " </td>"; echo "<td align=right>Reg"; echo "<input type=radio name=tax value=1><br>"; echo "Deli<input type=radio name=tax value=2><br>"; echo "No Tax<input type=radio name=tax value=0"; echo "></td><td align=center><input type=checkbox value=1 name=FS"; echo "></td><td align=center><input type=checkbox value=1 name=Scale"; echo "></td><td align=center><input type=checkbox value=1 name=ForcQty"; echo "></td><td align=center><input type=checkbox value=1 name=NoDisc"; echo "></td><td align=center><select name=local><option value=0>No</option>\n <option value=1>SC</option><option value=2>300mi</option></select>"; echo "<input type=hidden value=1 name=inUse"; echo "><td align=center>"; //echo "<input type=text align=right size=4 name=likeCode>"; echo "<select name=likeCode style=\"{width: 175px;}\">"; echo "<option value=\"\">(none)</option>"; $likelistQ = "select * from likeCodes order by likecode"; $likelistR = $sql->query($likelistQ); while ($llRow = $sql->fetch_array($likelistR)) { echo "<option value={$llRow[0]}"; if (isset($likecode) && $llRow[0] == $likecode) { echo " selected"; } echo ">{$llRow[0]} {$llRow[1]}</option>"; } echo "</select>"; echo "</td><td align=center><input type=checkbox value=1 id=newTag name=shelftag></td></tr>"; if ($logged_in) { echo "<tr><td><input type='submit' name='submit' value='submit'>"; } else { echo "<tr><td>Please <a href=/auth/ui/loginform.php?redirect=/queries/productTest.php?upc={$upc}>"; echo "login</a> to add items"; } echo "</td></tr> "; echo "</tr></table>"; } elseif ($num > 1) { moreItems($upc); $upcs = array(); $descriptions = array(); for ($i = 0; $i < $num; $i++) { $rowItem = $sql->fetch_array($resultItem); $upcs[$i] = $rowItem['upc']; $descriptions[$i] = $rowItem['description']; $modified[$i] = $rowItem['modified']; //echo "<a href='productTest.php?upc=$upc'>" . $upc . " </a>- " . $rowItem['description'] . "<br>"; } for ($i = 0; $i < $num; $i++) { $dupe = false; for ($j = 0; $j < $num; $j++) { if ($i != $j and $upcs[$i] == $upcs[$j]) { $enc = base64_encode($descriptions[$i]); echo "<a href=productTest.php?upc={$upcs[$i]}&duplicate=yes&description={$enc}>{$upcs[$i]}</a>-{$descriptions[$i]} - <b>DUPLICATE</b> - "; echo "<a href=javascript:delete_popup(\"{$upcs[$i]}\",\"{$enc}\")><img src=trash.png border=0/></a><br />"; $j = $num; $dupe = true; } } if (!$dupe) { echo "<a href=productTest.php?upc={$upcs[$i]}>{$upcs[$i]}</a>-{$descriptions[$i]}<br />"; } } } else { oneItem($upc); $rowItem = $sql->fetch_array($resultItem); $upc = $rowItem['upc']; $currentDepartment = $rowItem['department']; $prev = $next = 0; $modified = $rowItem['modified']; deptPrevNext($currentDepartment, $upc, $prev, $next); $modDate = $modified; $likecode = ''; if (!empty($likeCodeRow[1])) { $likecode = $likeCodeRow[1]; } echo "<head><title>Update Item</title></head>"; echo "<BODY onLoad='putFocus(0,2);'>"; printMods($savedUPC); echo "<form action=updateItemTest.php method=post>"; echo "<table>"; echo "<tr><td align=right><b>UPC</b></td><td><font color='red'>" . $rowItem['upc'] . "</font><input type=hidden value='{$rowItem['upc']}' name=upc>"; if ($prev != -1) { echo " <a href=productTest.php?upc={$prev}>Previous</a>"; } if ($next != -1) { echo " <a href=productTest.php?upc={$next}>Next</a>"; } echo "</td>"; echo "</tr><tr><td><b>Description</b></td><td><input type=text size=35 maxlength=30 value=\"{$rowItem['description']}\" name=descript></td>"; echo "<td><b>Price</b></td><td>\$<input type=text value='{$rowItem['normal_price']}' name=price></td></tr>"; echo "<tr><td colspan=2 align=right><b>Enable Volume Price</b> <input type=checkbox name=doVolume "; echo ($rowItem['pricemethod'] != 0 ? "checked" : "") . " /></td><td colspan=2>"; echo "<input type=hidden name=pricemethod value=\"{$rowItem['pricemethod']}\">"; echo "<input type=text size=4 name=vol_qtty value=" . ($rowItem['quantity'] != 0 ? $rowItem['quantity'] : "\"\"") . " />"; echo " for \$<input type=text size=4 name=vol_price value=" . ($rowItem['groupprice'] != 0 ? $rowItem['groupprice'] : "\"\"") . " /></td></tr>"; echo "<tr><td><b>Manufacturer</b></td><td><input type=text size=35 value=\"{$rowItem['manufacturer']}\" name=manufacturer /></td>"; echo "<td><b>Distributor</b></td><td> <input type=text value=\"{$rowItem['distributor']}\" name=distributor /></td></tr>"; echo "<a href=/git/fannie/reports/PriceHistory/?upc={$rowItem['upc']} target=blank>Click for Price History</a>"; if ($rowItem['special_price'] != 0) { echo "<tr><td><font size=+1 color=green><b>Sale Price:</b></font></td><td><font size=+1 color=green>{$rowItem['special_price']}</font>"; echo "<td colspan=2><font size=+1 color=green>End Date: {$rowItem['end_date']}</font></td><tr>"; $findBatchQ = $sql->prepare("select batchName from batches as b, batchList as l\n where b.batchID = l.batchID and l.upc like ?\n and " . $sql->curdate() . " BETWEEN b.startDate AND b.endDate"); $findBatchR = $sql->execute($findBatchQ, array($upc)); $batchName = $sql->num_rows($findBatchR) == 0 ? "Unknown" : array_pop($sql->fetch_array($findBatchR)); if ($batchName == "Unknown" && $likecode != "") { $findBatchQ = $sql->prepare("select batchName from batches as b, batchList as l\n where b.batchID=l.batchID and l.upc = ?\n and " . $sql->curdate() . " BETWEEN b.startDate AND b.endDate"); $findBatchR = $sql->execute($findBatchQ, array('LC' . $likecode)); $batchName = $sql->num_rows($findBatchR) == 0 ? "Unknown" : array_pop($sql->fetch_array($findBatchR)); } echo "<tr><td colspan=4><b>Batch: {$batchName}</b> "; if (validateUserQuiet('pricechange') || substr($upc, 0, 3) == "002") { echo "(<a href=unsale.php?upc={$upc}><font color=red>Take this item off sale now</font></a>)</td>"; } } echo "</table>"; echo "<table border=0><tr>"; echo "<th>Dept<th>Tax<th>FS<th>Scale<th>QtyFrc<th>NoDisc<th>Local<th>Like Code<th> </b>"; echo "</tr>"; echo "<tr align=top>"; //$dept=$row1[3]; $query2 = "SELECT * FROM departments as d,\n MasterSuperDepts AS s WHERE s.dept_ID=d.dept_no AND dept_no NOT IN (60,225)\n ORDER BY superID, dept_no"; echo "<td>"; $query3 = $sql->prepare("SELECT dept_no,superID FROM departments as d\n LEFT JOIN MasterSuperDepts AS s ON d.dept_no=s.dept_ID\n WHERE dept_no = ?"); $result3 = $sql->execute($query3, $rowItem['department']); $row3 = $sql->fetch_array($result3); echo '<select name="dept">'; $result2 = $sql->query($query2); while ($row2 = $sql->fetch_row($result2)) { printf('<option %s value="%d">%d %s</option>', $row2['dept_no'] == $rowItem['department'] ? 'selected' : '', $row2['dept_no'], $row2['dept_no'], $row2['dept_name']); } echo '</select>'; echo " </td>"; echo "<td align=right>Reg "; echo "<input type=radio name=tax value=1"; if ($rowItem['tax'] == 1) { echo " checked"; } echo "><br>Deli <input type=radio name=tax value=2"; if ($rowItem['tax'] == 2) { echo " checked"; } echo "><br>NoTax <input type=radio name=tax value=0"; if ($rowItem['tax'] == 0) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=1 name=FS"; if ($rowItem['foodstamp'] == 1) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=1 name=Scale"; if ($rowItem['scale'] == 1) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=1 name=QtyFrc"; if ($rowItem['qttyEnforced'] == 1) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=0 name=NoDisc"; if ($rowItem['discount'] == 0) { echo " checked"; } echo ">" . "</td><input type=hidden value=1 name=inUse"; echo "></td><td align=center><select name=local>"; printf("<option value=0 %s>No</option>", $rowItem['local'] == 0 ? 'selected' : ''); printf("<option value=1 %s>SC</option>", $rowItem['local'] == 1 ? 'selected' : ''); printf("<option value=2 %s>300mi</option>", $rowItem['local'] == 2 ? 'selected' : ''); echo "</select><td align=center>"; //echo "<input type=text align=right size=4 value='$likecode' name=likeCode>"; echo "<select name=likeCode style=\"{width: 175px;}\">"; echo "<option value=-1>(none)</option>"; $likelistQ = "select * from likeCodes order by likecode"; $likelistR = $sql->query($likelistQ); while ($llRow = $sql->fetch_array($likelistR)) { echo "<option value={$llRow[0]}"; if ($llRow[0] == $likecode) { echo " selected"; } echo ">{$llRow[0]} {$llRow[1]}</option>"; } echo "</select>"; echo "</td><td>"; echo "<a href=javascript:popup()>Add like code</a>"; echo "</td>"; echo "<a href=javascript:shelftag('{$upc}')>New Shelf Tag</a>"; echo "</tr>"; echo "</tr>"; echo "<tr><td align=right><font size=-1 color=purple><i><b>Last Modified: </b></i></font></td>"; echo "<td colspan=3><font size=-1 color=purple><i>{$modDate}</i></td>"; echo "<td colspan=5><a href=/git/fannie/reports/RecentSales/index.php?upc={$upc} target=blank>Click for History</a></td></tr>"; echo "<tr><td colspan=4>"; // kick out a scale input for upcs starting with 002 // pass variables with prefix s_ if (preg_match("/^002/", $rowItem['upc']) && $row3[1] == 3) { $scaleQuery = $sql->prepare("select * from scaleItems where plu=?"); $scaleRes = $sql->execute($scaleQuery, array($upc)); $scaleRow = $sql->fetch_row($scaleRes); echo "<table border=1 cellspacing=0 cellpadding=7><tr>"; echo "<td bgcolor=\"#FFFFCC\">"; echo "Scale Information:<br />"; echo "UPC: <font color=red>{$rowItem['upc']}</font><p />"; echo "<input type=hidden name=s_plu value={$rowItem['upc']}>"; // update: some items might need a longer description echo "Longer description:"; // only show a longer description if the description differs echo " <input type=text name=s_longdesc size=40 maxlength=100"; if ($rowItem['description'] != $scaleRow[2]) { echo " value='{$scaleRow[2]}'"; } echo ">"; echo "<p />"; // EXCEPTION PRICE? // Unnecessary to users but expected by csv package echo "<input type=hidden name=s_exception value=0.00>"; echo "<table border=1 cellspacing=0 cellpadding=7><tr>"; echo "<th>Weight</th><th>By Count</th><th>Tare</th><th>Shelf Life</th><th>Net Wt (oz)</th><th>Label</th><th>Safehandling</th>"; echo "</tr><tr><td>"; echo "<input type=radio name=s_type value=\"Random Weight\""; if ($scaleRow[4] == 0) { echo " checked> Random<br />"; } else { echo "> Random<br />"; } echo "<input type=radio name=s_type value=\"Fixed Weight\""; if ($scaleRow[4] == 1) { echo " checked> Fixed<br />"; } else { echo "> Fixed<br />"; } echo "</td><td align=center>"; echo "<input type=checkbox name=s_bycount"; if ($scaleRow['bycount'] == 1) { echo " checked>"; } else { echo ">"; } echo "</td><td>"; echo "<input type=text name=s_tare size=5 value={$scaleRow['tare']}>"; echo "</td><td>"; echo "<input type=text name=s_shelflife size=5 value={$scaleRow['shelflife']}>"; echo "</td><td>"; echo "<input type=text name=s_netwt size=5 value={$scaleRow['netWeight']}>"; echo "</td><td>"; echo "<select name=s_label size=2>"; if ($scaleRow['label'] == 133 || $scaleRow['label'] == 63) { echo "<option value=horizontal selected>Horizontal</option>"; } else { echo "<option value=horizontal>Horizontal</option>"; } if ($scaleRow['label'] == 103 || $scaleRow['label'] == 53 || $scaleRow['label'] == 23) { echo "<option value=vertical selected>Vertical</option>"; } else { echo "<option value=vertical>Vertical</option>"; } echo "</select>"; echo "</td><td align=center>"; if ($scaleRow['graphics'] == 0) { echo "<input type=checkbox name=s_graphics />"; } else { echo "<input type=checkbox name=s_graphics checked />"; } echo "</td>"; echo "</td></tr></table><br />"; echo "<p />Expanded text:<br /><textarea name=s_text rows=4\n cols=40>{$scaleRow['text']}</textarea>"; echo "<p /></td></tr></table>"; } echo "<br /></td></tr><tr><td>"; echo "Like Code Linked Items</td><td> </td><td><input type=checkbox name=update value='no'></td><td colspan=4>Check to not update like code items</td></tr><tr><td>"; if ($likeCodeNum > 0) { $selLikeQ = "SELECT p.upc,p.description,p.normal_price FROM products as p, upcLike as u WHERE u.upc = p.upc and u.likeCode = ?"; likedtotable($selLikeQ, $likeCodeRow[0], 0, 'FFFFCC'); echo "<td valign=top colspan=3><a href=/git/fannie/reports/PriceHistory/?likecode={$likeCodeRow['1']} target=lc_hist>Click for Like Code History</a></td>"; } if ($logged_in || preg_match("/^002/", $rowItem['upc']) && $row3[1] == 3) { echo "</td></tr><tr><td colspan=4><input type='submit' name='submit' value='submit'> "; echo " <a href=../../item/DeleteItemPage.php?id={$upc}>Delete this item</a> | "; } else { echo "</td></tr><tr><td colspan=4>Please <a href=/auth/ui/loginform.php?redirect=/queries/productTest.php?upc={$upc}>"; echo "login</a> to change prices"; } echo " <a href=javascript:back()>Back</a></td></tr> "; echo "<tr><td colspan=5>"; echo '<a href="" onclick="$(\'#topSecret\').toggle();return false;">Extra</a>'; echo "<div id=\"topSecret\" style=\"display:none;\">"; echo "<div style=\"float:left;width:500px;\">"; echo "<b>Sane Brand & Description</b>: "; printf("<input name=\"u_brand\" value=\"%s\" /> \n <input name=\"u_desc\" value=\"%s\" /><br />", $rowItem["brand"], $rowItem["udesc"]); printf("<b>Size</b>: <input name=\"u_size\" value=\"%s\" />", $rowItem["sizing"]); printf(' <input type="checkbox" name="u_enableOnline" %s />Sell online<br />', $rowItem['enableOnline'] == 1 ? 'checked' : ''); printf("<b>Expires</b>: <input name=\"u_expires\" value=\"%s\" />", $rowItem["expires"]); printf('<p><b>Page Text</b><br /><textarea rows=15 cols=80 name=u_long_text>%s</textarea></p>', str_replace("<br />", "\n", $rowItem['long_text'])); echo "</div>"; if (!empty($rowItem["photo"])) { echo "<div style=\"float:left;\">"; printf("<a href=\"/git/fannie/item/images/done/%s\"><img src=\"/git/fannie/item/images/done/%s\" /></a>", $rowItem["photo"], str_replace("png", "thumb.png", $rowItem["photo"])); echo "</div>"; } echo "<div style=\"clear:left;\"></div>"; echo "</div>"; echo "</tr>"; echo "<tr><td height=5> </td></tr><tr><td bgcolor=#ddffdd colspan=3>"; allLanes($upc); echo "</td></tr>"; } return $num; }