<?php /* OrderSys Version: 1.7.2 Date: 12 September 2014 Copyright: Santosh Patnaik, MD, PhD License: GPL 3+ URL: www.bioinformatics.org/phplabware */ // IF START---------------- $total_pages >1---new row after the data rows if($num_sat > 0 and $total_pages > 1) { echo '<tr valign="top" style="background-color:#ffffcc;"><td colspan="5" style="align:middle;"><span style="color:grey;">Page ', $page, ' of ', $total_pages, '<br />'; // for 'previous' if($page > 1) { $prev = ($page - 1); echo "<a href=\"", htmlspecialchars($_SERVER['PHP_SELF']), "?&smenu_1=", rawurlencode($smenu_1), "&sterm_1=", rawurlencode($sterm_1), "&smenu_2=", rawurlencode($smenu_2), "&sterm_2=", rawurlencode($sterm_2), "&order_1=", rawurlencode($order_1), "&order_2=", rawurlencode($order_2), "&sort_1=", rawurlencode($sort_1), "&sort_2=", rawurlencode($sort_2), "&sbool=", rawurlencode($sbool), "&page=", $prev, "\">«Previous</a> "; } // for rest of pages for($i = 1;$i <= $total_pages;$i++) { if($i == $page) { echo $i, " "; } else { if(abs($i - $page) < 10) { echo "<a href=\"", htmlspecialchars($_SERVER['PHP_SELF']), "?&smenu_1=", rawurlencode($smenu_1), "&sterm_1=", rawurlencode($sterm_1), "&smenu_2=", rawurlencode($smenu_2), "&sterm_2=", rawurlencode($sterm_2), "&order_1=", rawurlencode($order_1), "&order_2=", rawurlencode($order_2), "&sort_1=", rawurlencode($sort_1), "&sort_2=", rawurlencode($sort_2), "&sbool=", rawurlencode($sbool), "&page=", $i, "\">", $i, "</a> "; } } } // for 'next' if($page < $total_pages) { $next = ($page + 1); echo "<a href=\"", $_SERVER['PHP_SELF'], "?&smenu_1=", rawurlencode($smenu_1), "&sterm_1=", rawurlencode($sterm_1), "&smenu_2=", rawurlencode($smenu_2), "&sterm_2=", rawurlencode($sterm_2), "&order_1=", rawurlencode($order_1), "&order_2=", rawurlencode($order_2), "&sort_1=", rawurlencode($sort_1), "&sort_2=", rawurlencode($sort_2), "&sbool=", rawurlencode($sbool), "&page=", $next, "\">Next»</a></span>"; } echo('</td></tr>'); } // IF END ---------------- $total_pages >1 and $ num_sat >0 echo('</table>'); ///////////////////////////////////////////////////////////// TABLE for the cart if(isset($since_order)) { echo $since_order; } echo '<table width="750" summary="none" style="background-color:#efefef; border:0;" cellpadding="5" cellspacing="1"><colgroup> <col valign="top" align="left" style="width:75px; background-color:#ffccff;"></col> <col valign="top" align="left"></col> </colgroup>'; $no_items = count($_SESSION['checked']); if($no_items > 0) { // end MAIN form - cart not empty echo '<tr><td valign="top" style="width:75px; background-color:#ffccff;"><input type="submit" value="Update" /></td><td style="background-color:#f8d777;" valign="top"><a name="order"></a>', $no_items, ' item(s) in your order:<br />'; $vendor_array = array(); foreach($_SESSION['checked'] as $key=>$value) { $sql3 = execute_db("SELECT `ID`, `Name`, `Vendor` FROM `item` WHERE `ID`=" . add_slashes($value), $conn, 'ordersys/bottom_part.php'); $row3 = database_fetch_array($sql3); echo '<input type = "radio" name="unchecked[', htmlspecialchars($row3["ID"]), ']" id="unchecked[', htmlspecialchars($row3["ID"]), ']" value="', htmlspecialchars($row3["ID"]), '" />', htmlspecialchars($row3["Name"]), '<span style="color:grey;"> from ', htmlspecialchars($row3["Vendor"]), '</span><br />'; $vendor_array[] = $row3["Vendor"]; } echo '<br /><input type="submit" name="empty" id="empty" value="Clear all" /></form><span style="color:grey;"> Select and click \'Update\' to remove or \'Clear all\'</span><form method="post" action="finalize.php"><input type="submit" value="Finalize" '; $vendor_array = array_unique($vendor_array); $vendor_array_no = count($vendor_array); if($vendor_array_no > 1) { echo 'disabled="disabled" /><span style="color:grey;"> The items are from different vendors! You should do separate ordering. Select and click \'Update\' to remove or \'Clear all\'</span></form>'; } else { echo ' /></form>'; } } else { // end MAIN form - empty cart echo '<tr><td valign="top" style="width:75px; background-color:#ffccff;"><input type="submit" value="Update" /></form></td><td valign="top" style="background-color:#f8d777;"><a name="order"></a><span style="color: grey;">Browse by searching, etc., to add/remove items, clicking the \'Update\' button on left each time.</span>'; } echo '</td></tr></table>'; /////////////// end TABLE for the cart /////////////// build LOWER table - export + browse options echo '<table width="750" summary="export" style="background-color:#efefef; border:0;" cellpadding="5" cellspacing="1"><tr><td>'; if($num_tot != 0) { // Excel export options - ordering maintained echo '<form action="export.php" method="post"><p> <select single="single" name="parameter" id="parameter"> <option value="Excel">Export the ', $num_sat, ' entries in Excel format, or...</option> <option value="CSV">the ', $num_sat, ' entries in CVS format</option>'; echo '</select>'; // hidden values to pass the mysql query and table name echo '<input type="hidden" name="order_1" value="', htmlspecialchars($order_1), '" /><input type="hidden" name="order_2" value="', htmlspecialchars($order_2), '" /><input type="hidden" name="sort_1" value="', htmlspecialchars($sort_1), '" /><input type="hidden" name="sort_2" value="', htmlspecialchars($sort_2), '" /><input type="hidden" name="sterm_1" value="', htmlspecialchars($sterm_1), '" /><input type="hidden" name="sterm_2" value="', htmlspecialchars($sterm_2), '" /><input type="hidden" name="smenu_1" value="', htmlspecialchars($smenu_1), '" /><input type="hidden" name="smenu_2" value="', htmlspecialchars($smenu_2), '" /><input type="hidden" name="sbool" value="', htmlspecialchars($sbool), '" /><input type="hidden" name="table" id="table" value="', htmlspecialchars($table), '" /> <input type="submit" name="export" id="export" value="Export" /><a href="../help/help.htm#export" onclick="return popitup(\'../help/help.htm#export\')">?</a> </p></form>'; // end export options } // get options for vendor and category menu $queryvendor = "SELECT DISTINCT `Name` FROM `vendor` ORDER BY `Name`"; $resultvendor = execute_db($queryvendor, $conn, 'ordersys/bottom_part.php'); $Vendor_options = ""; while($row = database_fetch_array($resultvendor)) { $Vendor_name = $row["Name"]; $Vendor_options .= "<option value=\"" . htmlspecialchars($Vendor_name) . "\">" . htmlspecialchars($Vendor_name) . '</option>'; } $querycategory = "SELECT DISTINCT `Category` FROM `item` ORDER BY `Category`"; $resultcategory = execute_db($querycategory, $conn, 'ordersys/bottom_part.php'); $Category_options = ""; while($row = database_fetch_array($resultcategory)) { $Category_options .= "<option value=\"" . htmlspecialchars($row['Category']) . "\">" . htmlspecialchars($row['Category']) . '</option>'; } ?> <form action="items.php" method="get"><p> <select name="sterm_1" id="sterm_1"> <?php if(isset($Vendor_options)) { echo $Vendor_options; } ?> </select> <input type="submit" value="Browse by vendor" /> <input type="hidden" name="smenu_1" id="smenu_1" value="Vendor" /> </p></form> <form action="items.php" method="get"><p> <select name="sterm_1" id="sterm_1"> <?php if(isset($Category_options)) { echo $Category_options; } ?> </select> <input type="submit" value="Browse by category" /> <input type="hidden" name="smenu_1" id="smenu_1" value="Category" /> </p></form> <form action="items.php" method="get"><p> <input type="text" name="sterm_1" id="sterm_1" maxlength="20" value="" /> <input type="submit" value="Search by item name" /> <input type="hidden" name="smenu_1" id="smenu_1" value="Name" /> </p></form> <?php ////////////// end lower table echo('</td></tr></table>');