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");
}
