// } $query = "SELECT p.upc AS UPC, \n\tp.description AS description,\n\tp.normal_price AS price, \n\td.dept_name AS dept, \n\ts.subdept_name AS subdept, \n\tp.props AS props,\n\tp.foodstamp AS fs, \n\tp.scale AS scale, \n\tp.inuse AS inuse, \n\tp.special_price AS sale\n FROM " . PRODUCTS_TBL . " AS p \n\t\tINNER JOIN subdepts AS s ON s.subdept_no = p.subdept \n\t\tINNER JOIN departments as d ON d.dept_no = p.department\n WHERE p.department IN ({$deptArray})\n {$inuse_filter}"; // echo $query; $result = mysql_query($query); $num = mysql_num_rows($result); $dictR = mysql_query("SELECT * FROM item_properties"); echo "<center><h1>Product List</h1></center>"; // echo "<div id='filterbox'>"; // while ($filter = mysql_fetch_assoc($dictR)) { // echo "<input type='checkbox' name='property[]' value='".$filter['bit']."' onchange='filterTable(this.value);'>".ucwords(strtolower($filter['name'])); // } // echo "<button>show/hide item properties</button>"; // echo "</div>"; echo "<table id='output' cellpadding=0 cellspacing=0 border=0 class=\"sortable-onload-1 rowstyle-alt colstyle-alt\">\n\n <caption>Department range: " . $arrayName . ". Search yielded (" . $num . ") results. Generated on " . date('n/j/y \\a\\t h:i A') . " — <a id='clearfilters' href='#'>Clear Filters</a></caption>\n\n <thead>\n\n <tr>\n\n <th class=\"sortable-numeric\">UPC</th>\n\n <th class=\"sortable-text\">Description</th>\n\n <th class=\"sortable-currency\">Price</th>\n\n <th filter-type='ddl' class=\"sortable-text\">Dept.</th>\n\n <th filter-type='ddl' class=\"sortable-text\">Subdept.</th>\n\n <th class=\"sortable-text\">Item Properties</th>\n\n <th filter-type='ddl' class=\"sortable-text\">FS</th>\n\n <th filter-type='ddl' class=\"sortable-text\">wgh.</th>\n\n <th class=\"sortable-text\">Sale</th>\n\t\t\n </tr>\n\n </thead>\n\n <tbody>\n"; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $b = bindecValues($row["props"]); // echo $b . "<br />"; $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}");
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 }
if ($row["discount"] == 0) { echo " checked"; } echo "></td><td align=center><input type=checkbox value=1 name=inUse"; if ($row["inUse"] == 1) { echo " checked"; } echo "></td><td align=center><input type=text value='" . $row["deposit"] . "' name=deposit size='5'"; echo "></td></tr>"; //echo "<tr><td>" . $row[4] . "</td><td>" . $row[5]. "</td><td>" . $row[6] ."</td><td>" . $row[7] . "</td><td>" . $row[8] . "</td></tr>"; //echo "<tr><td>" . $row[9] . "</td><td>" . $row[10] . "</td><td>" . $row[11] . "</td><td>" . $row[12] . "</td>"; echo "<tr><td colspan='8'>"; $dictR = mysql_query("SELECT * FROM item_properties"); $p = $row[29]; // echo "\$props = " . $p . "<br />"; $b = bindecValues($p); // echo $b . "<br />"; $prop_arr = explode("|", $b); // print_r($prop_arr); echo "<b>Item Properties: </b>"; while ($dict = mysql_fetch_assoc($dictR)) { $value = $dict['bit']; if (in_array($value, $prop_arr)) { echo "<span class='itemtag'>" . $dict['name'] . "</span>"; } } echo "</td></tr>"; echo "</table>"; echo "<hr>"; echo "<form action='" . DOCROOT . "/item/itemMaint.php' method=post>"; echo "<input name=upc type=text id=upc> Enter UPC/PLU here<br>";