function itemMaintenance($new, $input)
{
if ($new != 1) {
$upc = str_pad($input, 13, 0, STR_PAD_LEFT);
$queryItem = "SELECT p.*, d.* FROM " . PRODUCTS_TBL . " p, product_details d WHERE p.upc = d.upc AND p.upc = '{$upc}'";
$resultItem = mysql_query($queryItem);
if (!$resultItem) {
die("Query: {$queryItem}<br />Error:" . mysql_error());
}
$rowItem = mysql_fetch_assoc($resultItem);
}
$upc = $new != 1 ? $rowItem['upc'] : $input;
$upch = $new != 1 ? "<input type=hidden value='" . $rowItem['upc'] . "' name=upc>" : "";
$cost = $new != 1 ? "value='" . $rowItem['cost'] . "'" : "";
$desc = $new != 1 ? "value='" . $rowItem['description'] . "'" : "";
$pric = $new != 1 ? "value='" . $rowItem['normal_price'] . "'" : "";
$vend = $new != 1 ? "value='" . $rowItem['brand'] . "'" : "";
// $acti = ($new != 1) ? "action='updateItems.php'" : "action='insertItem.php'";
$acti = "action='updateItems.php/?new={$new}&upc={$upc}'";
$csel = $new != 1 ? $rowItem : $row;
echo "<head><title>Fannie - Item Maintenance</title>";
echo "</head>";
echo "<BODY onLoad='putFocus(0,1);'>";
// print_r($rowItem);
echo "<form name=itemMaint {$acti} method=post>\n";
echo "<h3 class=\"acc_head\">Basic Item Information</h3>\n<div class=\"acc_content\">\n";
echo "<div class='acc_box'>\n<table border=0 cellpadding=5 cellspacing=0>\n";
echo "<tr><td align=right><b>UPC</b></td>\n\n\t\t<td><font color='red'>{$upc}</font>{$upch}</td>\n<input type='hidden' name='upc' value='{$upc}' />\n\t\t<td> </td>\n\t\t<td> </td></tr>\n";
echo "<tr><td><b>Description</b></td>\n\n\t\t<td><input type=text size=30 {$desc} name=descript></td>\n\n\t\t<td align='right'><b>Price \$</b></td>\n\n\t\t<td><input type=text {$pric} name=price size=6></td></tr>";
if ($new != 1 && $rowItem['special_price'] != 0) {
echo "<tr><td><font color=green><b>Sale Price:</b></font></td>\n<td><font color=green>{$rowItem['6']}</font></td>\n<td>";
echo "<font color=green>End Date:</td>\n<td><font color=green>{$rowItem['11']}</font></td><tr>\n";
}
echo "<tr><td align=right><b>Vendor</b></td>\n\t\t<td><input type=text size=30 {$vend} name=vendor></td>\n\t\t<td align=right><b>Cost \$</b></td>\n\n\t\t<td><input type=text {$cost} name=cost size=6></td></tr>\n";
echo "</table>\n";
echo "<hr>\n";
echo "<table border=0 cellpadding=5 cellspacing=0 width='100%'>\n<tr>";
echo "<th>Dept & SubDept</th><th>FS</th><th>Scale</th><th>QtyFrc</th><th>NoDisc</th><th>Active</th>";
echo "</tr>\n";
echo "<tr valign=top>";
echo "<td align=left>";
$dresult = mysql_query("SELECT * FROM departments");
echo "<select id=\"dept_list\" name=\"department\">\n";
echo "<option value=\"\">----------------</option>\n";
while ($drow = mysql_fetch_array($dresult)) {
echo "<option value=" . $drow['dept_no'];
if ($new != 1) {
if ($drow['dept_no'] == $rowItem['department']) {
echo " selected=\"selected\"";
}
}
echo ">" . $drow['dept_name'] . "</option>\n";
}
echo "</select>\n\n";
$sresult = mysql_query("SELECT * FROM subdepts");
echo "<select id=\"subdept_list\" name=\"subdepartment\">\n";
echo "<option value=\"\">----------------</option>\n";
while ($srow = mysql_fetch_array($sresult)) {
echo "<option value=" . $srow['subdept_no'] . " class=" . $srow['dept_ID'];
if ($new != 1) {
if ($srow['subdept_no'] == $rowItem['subdept']) {
echo " selected=\"selected\"";
}
}
echo ">" . $srow['subdept_name'] . "</option>\n";
}
echo "</select>\n\n";
echo "</td>\n<td align=center><input type=checkbox value=1 name=FS";
if ($new != 1 && $rowItem["foodstamp"] == 1) {
echo " checked";
}
echo "></td>\n<td align=center><input type=checkbox value=1 name=Scale";
if ($new != 1 && $rowItem["scale"] == 1) {
echo " checked";
}
echo "></td>\n<td align=center><input type=checkbox value=1 name=QtyFrc";
if ($new != 1 && $rowItem["qttyEnforced"] == 1) {
echo " checked";
}
echo "></td>\n<td align=center><input type=checkbox value=0 name=NoDisc";
if ($new != 1 && $rowItem["discount"] == 0) {
echo " checked";
}
echo "></td>\n<td align=center><input type=checkbox value=1 name=inUse";
if ($new != 1 && $rowItem["inUse"] == 1) {
echo " checked";
} elseif ($new == 1) {
echo " checked";
}
echo "></td></tr>\n<tr><td> </td>\n<td colspan='2' align='right'>\$<input type='text'";
if (!isset($rowItem['deposit']) || $rowItem['deposit'] == 0) {
echo "value='0'";
} else {
echo "value='" . $rowItem['deposit'] . "'";
}
echo "name='deposit' size='5'></td>";
echo "<td colspan='3' align='left'>Bottle deposit</td></tr></table>";
echo "</div>\n</div>\n";
// close first accordian
echo "<h3 class=\"acc_head\">Item Details</h3>\n<div class=\"acc_content\">\n";
echo "<div class='acc_box'>\n";
echo "<table border=0 cellspacing=2 cellpadding=2>\n";
$dictR = mysql_query("SELECT * FROM item_properties");
if (!$dictR) {
die("Query: {$queryItem}<br />Error:" . mysql_error());
}
if ($new != 1) {
$p = $rowItem['props'];
$b = bindecValues($p);
$prop_arr = explode("|", $b);
}
while ($dict = mysql_fetch_assoc($dictR)) {
$value = $dict['bit'];
echo "<tr><td><input type=checkbox name=prop[] value=" . $value . " id=chkbox-" . $value;
if ($new != 1) {
if (in_array($value, $prop_arr)) {
echo " CHECKED";
}
}
echo "></input></td>\n<td><p><b><label for=chkbox-" . $value . ">" . ucwords(strtolower($dict['name'])) . "</label></b></p></td>\n\t\t\t<td><a class='itemtag' href='#' title='" . $dict['name'] . "'>" . acronymize($dict['name']) . "</a></td>\n\t\t\t<td>" . $dict['notes'] . "</td></tr>\n";
}
echo "</table>\n";
echo "</div>\n</div>\n";
// close 2nd accordion
echo "<br /><br />\n<table border=0><tr><td><input type='submit' name='submit' value='submit'> <a href='../item/itemMaint.php'><font size='-1'>cancel</font></a>";
echo "</td><td colspan=5> </td></tr>\n</table>\n";
echo "<script src=\"" . SRCROOT . "/js/jquery.chained.js\" type=\"text/javascript\"></script>\n";
?>
<script type="text/javascript">
$(function(){
$("#subdept_list").chained("#dept_list");
});
</script>
<?php
}
$prop_arr = explode("|", $b);
echo '<tr>
<td align=right><a class="opener" href="../item/itemMaint.php?upc=' . $row["UPC"] . '">' . $row["UPC"] . '</a></td>
<td>' . $row["description"] . '</td>
<td align=right>' . money_format('%n', $row["price"]) . '</td>
<td>' . substr($row["dept"], 0, 10) . '</td>
<td>' . substr($row["subdept"], 0, 20) . '</td>
<td>';
if (!$row["props"] || $row["props"] == 0) {
echo "";
} else {
// print_r($prop_arr);
foreach ($prop_arr as $i) {
$tagR = mysql_query("SELECT * FROM item_properties WHERE bit = {$i}");
$tag = mysql_fetch_assoc($tagR);
echo "<span class='proptoggle'><a class='itemtag' href='#' title='" . $tag['name'] . "'>" . acronymize($tag['name']) . "</a></span>";
}
}
echo '</td>
<td>';
if ($row["fs"] == 1) {
echo 'FS';
} else {
echo "X";
}
echo '</td><td align=center>';
if ($row["scale"] == 1) {
echo '#';
} else {
echo 'ea.';
}
