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
}
<?php
require dirname(__FILE__) . '/../config.php';
if (!class_exists('FannieAPI')) {
include $FANNIE_ROOT . 'classlib2.0/FannieAPI.php';
}
if (basename(__FILE__) != basename($_SERVER['PHP_SELF'])) {
return;
}
if (isset($_REQUEST['action'])) {
switch ($_REQUEST['action']) {
case 'margin':
MarginFS($_REQUEST['upc'], $_REQUEST['cost'], $_REQUEST['dept']);
break;
case 'likecode':
GetLikeCodeItems($_REQUEST['lc']);
break;
}
}
function GetLikecodeItems($lc)
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$ret = "<table border=0 bgcolor=\"#FFFFCC\">";
if (is_numeric($lc)) {
$prep = $dbc->prepare_statement("SELECT p.upc,p.description FROM\n products AS p INNER JOIN upcLike AS u ON\n p.upc=u.upc WHERE u.likeCode=?\n ORDER BY p.upc");
$res = $dbc->exec_statement($prep, array($lc));
while ($row = $dbc->fetch_row($res)) {
$ret .= sprintf("<tr><td><a href=itemMaint.php?upc=%s>%s</a></td>\n <td>%s</td></tr>", $row[0], $row[0], $row[1]);
}
}