function body_content() { $prefix = CoreLocal::get('houseCouponPrefix'); if ($prefix == '') { $prefix = '00499999'; } $dbc = Database::pDataConnect(); $query = "SELECT h.coupID, h.description\n FROM houseCoupons AS h\n WHERE h.description <> ''\n AND " . $dbc->datediff('endDate', $dbc->now()) . " >= 0\n ORDER BY h.description"; $result = $dbc->query($query); $num_rows = $dbc->num_rows($result); ?> <div class="baseHeight"> <div class="listbox"> <form name="selectform" method="post" id="selectform" action="<?php echo $_SERVER['PHP_SELF']; ?> " > <select name="selectlist" size="15" id="selectlist" style="min-width: 200px;" onblur="$('#selectlist').focus()" > <?php $selected = "selected"; for ($i = 0; $i < $num_rows; $i++) { $row = $dbc->fetch_array($result); printf('<option value="%s" %s>%d. %s</option>', $prefix . str_pad($row['coupID'], 5, '0', STR_PAD_LEFT), $selected, $i + 1, $row['description']); $selected = ""; } ?> </select> </div> <?php if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons('#selectlist') . '</div>'; } ?> <div class="listboxText coloredText centerOffset"> <?php echo _("use arrow keys to navigate"); ?> <br /> <p> <button type="submit" class="pos-button wide-button coloredArea"> Reprint <span class="smaller">[enter]</span> </button> </p> <p> <button type="submit" class="pos-button wide-button errorColoredArea" onclick="$('#selectlist').append($('<option>').val(''));$('#selectlist').val('');"> Cancel <span class="smaller">[clear]</span> </button></p> </div> </form> <div class="clear"></div> </div> <?php }
function body_content() { $result = $this->temp_result; $num_rows = $this->temp_num_rows; if ($num_rows == 0) { $this->productsearchbox(_("no match found") . "<br />" . _("next search or enter upc")); } else { $this->add_onload_command("selectSubmit('#search', '#selectform', '#filter-span')\n"); // originally 390 if (CoreLocal::get('touchscreen')) { $maxSelectWidth = 470; } else { $maxSelectWidth = 530; } echo "<div class=\"baseHeight\">" . "<div class=\"listbox\">" . "<form name=\"selectform\" method=\"post\" action=\"{$_SERVER['PHP_SELF']}\"" . " id=\"selectform\">" . "<select name=\"search\" id=\"search\" " . ' style="min-height: 200px; min-width: 220px;' . " max-width: {$maxSelectWidth}px;\"" . "size=" . $this->boxSize . " onblur=\"\$('#search').focus();\" " . "ondblclick=\"document.forms['selectform'].submit();\">"; $selected = "selected"; foreach ($result as $row) { $price = $row["normal_price"]; if ($row["scale"] != 0) { $Scale = "S"; } else { $Scale = " "; } $price = MiscLib::truncate2($price); echo "<option value='" . $row["upc"] . "' " . $selected . ">" . $row["upc"] . " - " . $row["description"] . " -- [" . $price . "] " . $Scale . "\n"; $selected = ""; } echo "</select>" . '<div id="filter-span"></div>' . "</div>"; if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons() . '</div>'; } echo "<div class=\"listboxText coloredText centerOffset\">" . _("use arrow keys") . '<br />' . _("to navigate") . '<br />' . _("the list") . '<p><button type="submit" class="pos-button wide-button coloredArea"> OK <span class="smaller">[enter]</span> </button></p>' . '<p><button type="submit" class="pos-button wide-button errorColoredArea" onclick="$(\'#search\').append($(\'<option>\').val(\'\'));$(\'#search\').val(\'\');"> Cancel <span class="smaller">[clear]</span> </button></p>' . "</div><!-- /.listboxText coloredText .centerOffset -->" . "</form>" . "<div class=\"clear\"></div>"; echo "</div>"; } $this->add_onload_command("\$('#search').focus();\n"); }
function body_content() { $db = Database::tDataConnect(); $query = "\n SELECT register_no, \n emp_no, \n trans_no, \n SUM(CASE \n WHEN trans_type='T' AND department=0 THEN -1 * total \n ELSE 0 \n END) AS total \n FROM localtranstoday \n WHERE register_no = ?\n AND emp_no = ?\n AND datetime >= " . $db->curdate() . "\n GROUP BY register_no, \n emp_no, \n trans_no \n ORDER BY trans_no DESC"; $args = array(CoreLocal::get('laneno'), CoreLocal::get('CashierNo')); $prep = $db->prepare($query); $result = $db->execute($prep, $args); $num_rows = $db->num_rows($result); ?> <div class="baseHeight"> <div class="listbox"> <form name="selectform" method="post" id="selectform" action="<?php echo $_SERVER['PHP_SELF']; ?> " > <select name="selectlist" size="15" id="selectlist" onblur="$('#selectlist').focus()" > <?php $selected = "selected"; for ($i = 0; $i < $num_rows; $i++) { $row = $db->fetch_array($result); echo "<option value='" . $row["register_no"] . "::" . $row["emp_no"] . "::" . $row["trans_no"] . "'"; echo $selected; echo ">lane " . substr(100 + $row["register_no"], -2) . " Cashier " . substr(100 + $row["emp_no"], -2) . " #" . $row["trans_no"] . " -- \$" . sprintf('%.2f', $row["total"]); $selected = ""; } ?> </select> </div> <?php if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons('#selectlist') . '</div>'; } ?> <div class="listboxText coloredText centerOffset"> <?php echo _("use arrow keys to navigate"); ?> <br /> <p> <button type="submit" class="pos-button wide-button coloredArea"> Reprint <span class="smaller">[enter]</span> </button> </p> <p> <button type="submit" class="pos-button wide-button errorColoredArea" onclick="$('#selectlist').append($('<option>').val(''));$('#selectlist').val('');"> Cancel <span class="smaller">[clear]</span> </button></p> </div> </form> <div class="clear"></div> </div> <?php }
function body_content() { $message = $this->temp_message; echo "<div class=\"baseHeight\">" . "<form id=\"selectform\" method=\"post\" action=\"{$_SERVER['PHP_SELF']}\">"; // First check for a problem found in preprocess. if ($message != "") { echo "\n <div class=\"colored centeredDisplay rounded\">\n <span class=\"larger\">\n {$message} <br />" . _("enter member number or name") . "\n </span>\n <br />\n <input type=\"text\" name=\"search\" size=\"15\"\n onblur=\"\$('#reginput').focus();\" id=\"reginput\" />\n <br />press [enter] to cancel\n </div>"; } else { if (count($this->results) < 1) { /* for no results, just throw up a re-do * otherwise, put results in a select box */ echo "\n <div class=\"colored centeredDisplay rounded\">\n <span class=\"larger\">"; if (!$this->submitted) { echo _("member search") . "<br />" . _("enter member number or name"); } else { echo _("no match found") . "<br />" . _("next search or member number"); } echo "</span>\n <p>\n <input type=\"text\" name=\"search\" size=\"15\"\n onblur=\"\$('#reginput').focus();\" id=\"reginput\" />\n </p>\n <button class=\"pos-button\" type=\"button\"\n onclick=\"\$('#reginput').val('');\$('#selectform').submit();\">\n Cancel [enter]\n </button>\n </div>"; } else { echo "<div class=\"listbox\">" . "<select name=\"search\" size=\"15\" " . ' style="min-height: 200px; min-width: 220px; max-width: 390px;" ' . "onblur=\"\$('#search').focus();\" ondblclick=\"document.forms['selectform'].submit();\" id=\"search\">"; $noticeP = false; $notice_cache = array(); $dbc = Database::pDataConnect(); if ($dbc->tableExists('CustomerNotifications')) { $noticeP = $dbc->prepare(' SELECT message FROM CustomerNotifications WHERE cardNo=? AND type=\'memlist\' ORDER BY message'); } $selectFlag = 0; foreach ($this->results as $optval => $label) { echo '<option value="' . $optval . '"'; if ($selectFlag == 0) { echo ' selected'; $selectFlag = 1; } /** If available, look up notifications designated for this screen. Cache results in case the same account appears more than once in the list. */ if ($noticeP) { list($id, $pn) = explode('::', $optval, 2); if (isset($notice_cache[$id])) { $label .= $notice_cache[$id]; } else { $noticeR = $dbc->execute($noticeP, array($id)); $notice = ''; while ($w = $dbc->fetchRow($noticeR)) { $notice .= ' ' . $w['message']; } $notice_cache[$id] = $notice; $label .= $notice; } } echo '>' . $label . '</option>'; } echo "</select>" . '<div id="filter-div"></div>' . "</div><!-- /.listbox -->"; if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons() . '</div>'; } echo "<div class=\"listboxText coloredText centerOffset\">" . _("use arrow keys to navigate") . '<p><button type="submit" class="pos-button wide-button coloredArea"> OK <span class="smaller">[enter]</span> </button></p>' . '<p><button type="submit" class="pos-button wide-button errorColoredArea" onclick="$(\'#search\').append($(\'<option>\').val(\'\'));$(\'#search\').val(\'\');"> Cancel <span class="smaller">[clear]</span> </button></p>' . "</div><!-- /.listboxText coloredText .centerOffset -->" . "<div class=\"clear\"></div>"; } } echo "</form></div>"; }
/** Build a <select> form that submits back to this script */ function body_content() { $db = Database::pDataConnect(); $q = "SELECT dept_no,dept_name FROM departments ORDER BY dept_name"; $r = $db->query($q); echo "<div class=\"baseHeight\">" . "<div class=\"listbox\">" . "<form name=\"selectform\" method=\"post\" action=\"{$_SERVER['PHP_SELF']}\"" . " id=\"selectform\">" . "<select name=\"search\" id=\"search\" " . ' style="min-height: 200px; min-width: 220px;" ' . "size=\"15\" onblur=\"\$('#search').focus();\">"; $selected = "selected"; while ($row = $db->fetch_row($r)) { echo "<option value='" . $row["dept_no"] . "' " . $selected . ">"; // ­ prevents the cursor from moving out of // step with filter-as-you-type echo '­ ' . $row['dept_name']; echo '</option>'; $selected = ""; } echo "</select>" . '<div id="filter-div"></div>' . "</div>"; if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons() . '</div>'; } echo "<div class=\"listboxText coloredText centerOffset\">" . _("use arrow keys to navigate") . '<p><button type="submit" class="pos-button wide-button coloredArea"> OK <span class="smaller">[enter]</span> </button></p>' . '<p><button type="submit" class="pos-button wide-button errorColoredArea" onclick="$(\'#search\').append($(\'<option>\').val(\'\'));$(\'#search\').val(\'\');"> Cancel <span class="smaller">[clear]</span> </button></p>' . "</div><!-- /.listboxText coloredText .centerOffset -->" . "</form>" . "<div class=\"clear\"></div>"; echo "</div>"; $this->add_onload_command("selectSubmit('#search', '#selectform', '#filter-div')\n"); $this->add_onload_command("\$('#search').focus();\n"); }
function body_content() { $num_rows = $this->temp_num_rows; $result = $this->temp_result; $db = $this->temp_db; echo "<div class=\"baseHeight\">" . "<div class=\"listbox\">" . "<form id=\"selectform\" method=\"post\" action=\"{$_SERVER['PHP_SELF']}\">\n" . "<select name=\"selectlist\" size=\"15\" onblur=\"\$('#selectlist').focus();\"\n id=\"selectlist\">"; $selected = "selected"; for ($i = 0; $i < $num_rows; $i++) { $row = $db->fetch_array($result); echo "<option value='" . $row["register_no"] . "::" . $row["emp_no"] . "::" . $row["trans_no"] . "' " . $selected . "> lane " . substr(100 + $row["register_no"], -2) . " Cashier " . substr(100 + $row["emp_no"], -2) . " #" . $row["trans_no"] . " -- \$" . $row["total"] . "\n"; $selected = ""; } echo "</select>\n</div>\n"; if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons('#selectlist') . '</div>'; } echo "<div class=\"listboxText coloredText centerOffset\">" . _("use arrow keys to navigate") . '<p><button type="submit" class="pos-button wide-button coloredArea"> OK <span class="smaller">[enter]</span> </button></p>' . '<p><button type="submit" class="pos-button wide-button errorColoredArea" onclick="$(\'#selectlist\').append($(\'<option>\').val(\'\'));$(\'#selectlist\').val(\'\');"> Cancel <span class="smaller">[clear]</span> </button></p>' . "</div><!-- /.listboxText coloredText .centerOffset -->" . "</form>" . "<div class=\"clear\"></div>"; echo "</div>"; $this->add_onload_command("\$('#selectlist').focus();"); $this->add_onload_command("selectSubmit('#selectlist', '#selectform')\n"); }
function body_content() { $fes = Authenticate::getPermission(CoreLocal::get('CashierNo')); /* if front end security >= 25, pull all * available receipts; other wise, just * current cashier's receipt */ $result = -1; if ($fes >= 25) { $query = "select emp_no, register_no, trans_no, sum((case when trans_type = 'T' then -1 * total else 0 end)) as total " . "from localtranstoday " . " group by register_no, emp_no, trans_no\n having sum((case when trans_type='T' THEN -1*total ELSE 0 end)) >= 30\n order by register_no,emp_no,trans_no desc"; $db = Database::tDataConnect(); if (CoreLocal::get("standalone") == 0) { $query = str_replace("localtranstoday", "dtransactions", $query); $db = Database::mDataConnect(); } $result = $db->query($query); } else { $db = Database::tDataConnect(); $query = "\n SELECT emp_no, \n register_no, \n trans_no, \n SUM((CASE WHEN trans_type = 'T' THEN -1 * total ELSE 0 END)) AS total \n FROM localtranstoday \n WHERE register_no = ?\n AND emp_no = ?\n AND datetime >= " . $db->curdate() . "\n GROUP BY register_no, \n emp_no, \n trans_no\n HAVING SUM((CASE WHEN trans_type='T' THEN -1*total ELSE 0 END)) >= 30\n ORDER BY trans_no desc"; $args = array(CoreLocal::get('laneno'), CoreLocal::get('CashierNo')); $prep = $db->prepare($query); $result = $db->execute($prep, $args); } $num_rows = $db->num_rows($result); ?> <div class="baseHeight"> <div class="listbox"> <form id="selectform" name="selectform" onsubmit="return submitWrapper();"> <select name="selectlist" size="15" onblur="$('#selectlist').focus()" id="selectlist"> <?php $selected = "selected"; for ($i = 0; $i < $num_rows; $i++) { $row = $db->fetch_array($result); echo "<option value='" . $row["emp_no"] . "-" . $row["register_no"] . "-" . $row["trans_no"] . "'"; echo $selected; echo ">lane " . substr(100 + $row["register_no"], -2) . " Cashier " . $row["emp_no"] . " #" . $row["trans_no"] . " -- \$" . $row["total"]; $selected = ""; } if ($num_rows == 0) { echo "<option selected value=\"\">None found</option>"; } ?> </select> </div> <?php if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons('#selectlist') . '</div>'; } ?> <div class="listboxText coloredText centerOffset"> <?php echo _("use arrow keys to navigate"); ?> <br /> <p> <button type="submit" class="pos-button wide-button coloredArea"> Reprint <span class="smaller">[enter]</span> </button> </p> <p> <button type="submit" class="pos-button wide-button errorColoredArea" onclick="$('#selectlist').append($('<option>').val(''));$('#selectlist').val('');"> Cancel <span class="smaller">[clear]</span> </button></p> </div> </form> <div class="clear"></div> </div> <?php }
/** Build a <select> form that submits back to this script */ function body_content() { $db = Database::pDataConnect(); $q = "SELECT TenderCode,TenderName FROM tenders \n WHERE MaxAmount > 0\n ORDER BY TenderName"; $r = $db->query($q); echo "<div class=\"baseHeight\">" . "<div class=\"listbox\">" . "<form name=\"selectform\" method=\"post\" action=\"{$_SERVER['PHP_SELF']}\"" . " id=\"selectform\">" . "<select name=\"search\" id=\"search\" " . "size=\"15\" onblur=\"\$('#search').focus();\">"; $selected = "selected"; while ($row = $db->fetch_row($r)) { echo "<option value='" . $row["TenderCode"] . "' " . $selected . ">"; echo $row['TenderName']; echo '</option>'; $selected = ""; } echo "</select>" . "</div>"; if (CoreLocal::get('touchscreen')) { echo '<div class="listbox listboxText">' . DisplayLib::touchScreenScrollButtons() . '</div>'; } echo "<div class=\"listboxText coloredText centerOffset\">"; if (CoreLocal::get("tenderTotal") >= 0) { echo _("tendering") . ' $'; } else { echo _("refunding") . ' $'; } printf('%.2f', abs(CoreLocal::get("tenderTotal")) / 100); echo '<br />'; echo _("use arrow keys to navigate") . '<p><button type="submit" class="pos-button wide-button coloredArea"> OK <span class="smaller">[enter]</span> </button></p>' . '<p><button type="submit" class="pos-button wide-button errorColoredArea" onclick="$(\'#search\').append($(\'<option>\').val(\'\'));$(\'#search\').val(\'\');"> Cancel <span class="smaller">[clear]</span> </button></p>' . "</div><!-- /.listboxText coloredText .centerOffset -->" . "</form>" . "<div class=\"clear\"></div>"; echo "</div>"; $this->add_onload_command("selectSubmit('#search', '#selectform')\n"); $this->add_onload_command("\$('#search').focus();\n"); }