function upcscanned($entered)
{
$hitareflag = 0;
$entered = str_replace(".", " ", $entered);
if (strlen($entered) == 0 || !$entered) {
lastpage();
} else {
if ($_SESSION["quantity"] == 0 && $_SESSION["multiple"] == 0) {
$quantity = 1;
} else {
$quantity = $_SESSION["quantity"];
}
}
$scaleprice = 0;
if (substr($entered, 0, 1) == 0 && strlen($entered) == 7) {
$p6 = substr($entered, -1);
if ($p6 == 0) {
$entered = substr($entered, 0, 3) . "00000" . substr($entered, 3, 3);
} elseif ($p6 == 1) {
$entered = substr($entered, 0, 3) . "10000" . substr($entered, 3, 3);
} elseif ($p6 == 2) {
$entered = substr($entered, 0, 3) . "20000" . substr($entered, 3, 3);
} elseif ($p6 == 3) {
$entered = substr($entered, 0, 4) . "00000" . substr($entered, 4, 2);
} elseif ($p6 == 4) {
$entered = substr($entered, 0, 5) . "00000" . substr($entered, 5, 1);
} else {
$entered = substr($entered, 0, 6) . "0000" . $p6;
}
}
if (strlen($entered) == 13 && substr($entered, 0, 1) != 0) {
$upc = "0" . substr($entered, 0, 12);
} else {
$upc = substr("0000000000000" . $entered, -13);
}
if (substr($upc, 0, 3) == "002") {
$scaleprice = truncate2(substr($upc, -4) / 100);
$upc = substr($upc, 0, 8) . "00000";
}
$query = "select * from products where upc = '" . $upc . "' AND inUse = 1";
$db = pDataConnect();
$result = sql_query($query, $db);
$num_rows = sql_num_rows($result);
$row = sql_fetch_array($result);
$normal_price = $row["normal_price"];
$special_price = $row["special_price"];
$cost = 0;
$deposit = $row["deposit"];
$dept = $row["department"];
if ($num_rows == 0 && substr($upc, 0, 3) != "005") {
$fconn = tDataconnect();
$datetimestamp = strftime("%Y-%m-%d %H:%M:%S %p", time());
$inserterror = "insert into failedscans select " . $upc . " as upc, " . $_SESSION["laneno"] . " as lane_no, " . $_SESSION["CashierNo"] . " as emp_no, " . $_SESSION["transno"] . " as trans_no, " . "'" . $datetimestamp . "' as fdate";
mysql_query($inserterror, $fconn);
boxMsg($upc . "<br /><b>is not a valid item</b>");
} elseif ($num_rows == 0 && substr($upc, 0, 3) == "005") {
couponcode($upc);
} elseif (($dept == 19 || $dept == 20) && $_SESSION["store"] == "rvm" && $_SESSION["msgrepeat"] == 0 && $_SESSION["carded"] == 0) {
if ($_SESSION["bdaystatus"] == 99) {
$boxMsg = "<b>Enter date of birth from valid ID</b><br />in the form mmddyyyy<p><font size=-1>[Clear] to cancel</font></p>";
}
if ($_SESSION["bdaystatus"] == -1) {
$boxMsg = "<b>Invalid date of birth</b><br />re-enter in the form mmddyyyy<p><font size=-1>[Clear] to cancel</font></p>";
}
if ($_SESSION["bdaystatus"] == 0) {
$boxMsg = "<b>Sales of item declined</b><p><font size=-1>[Clear] to cancel</font></p>";
}
$_SESSION["boxMsg"] = $boxMsg;
bdBoxMsgScreen();
} elseif ($row["scale"] != 0 && $_SESSION["weight"] == 0 && $_SESSION["quantity"] == 0) {
if ($_SESSION["wgtRequested"] == 0) {
$_SESSION["wgtRequested"] = 1;
lastpage();
echo "<script type=\"text/javascript\">\n" . "lockScreen = setTimeout('document.forms[0].elements[0].value = \"" . $_SESSION["strEntered"] . "\"; document.forms[0].submit();', 700)\n" . "</script>";
} else {
$_SESSION["SNR"] = 1;
boxMsg("please put item on scale");
$_SESSION["wgtRequested"] = 0;
}
} elseif ($row["scale"] != 0 && $_SESSION["scale"] == 0) {
$_SESSION["waitforScale"] = 1;
$_SESSION["SNR"] = 1;
lastpage();
} elseif ($row["scale"] == 0 && (int) $_SESSION["quantity"] != $_SESSION["quantity"] && $_SESSION["fractions"] != 1) {
boxMsg("fractional quantity cannot be accepted for this item");
} elseif ($_SESSION["itemDiscount"] < 0 || $_SESSION["itemDiscount"] > 65) {
xboxMsg("item cannot be<br />discounted at " . $_SESSION["itemDiscount"] . "%");
$_SESSION["itemDiscount"] = 0;
} else {
$mixMatch = 0;
$qttyEnforced = $row["qttyEnforced"];
if ($qttyEnforced == 1 && $_SESSION["multiple"] == 0 && $_SESSION["msgrepeat"] == 0) {
qttyscreen();
} else {
$_SESSION["qttyvalid"] = 1;
}
if ($_SESSION["qttyvalid"] != 1) {
sql_close($db);
} else {
$upc = $row["upc"];
$description = $row["description"];
$description = str_replace("'", "", $description);
$description = str_replace(",", "", $description);
$transType = "I";
$transsubType = "CA";
$department = $row["department"];
$unitPrice = $normal_price;
$regPrice = $normal_price;
$CardNo = $_SESSION["memberID"];
if ($row["scale"] != 0) {
$scale = 1;
} else {
$scale = 0;
}
if ($row["tax"] != 0 && $_SESSION["toggletax"] == 0) {
$tax = $row["tax"];
} elseif ($row["tax"] != 0 && $_SESSION["toggletax"] != 0) {
$tax = 0;
$_SESSION["toggletax"] = 0;
} elseif ($row["tax"] == 0 && $_SESSION["toggletax"] != 0) {
$tax = $_SESSION["toggletax"];
$_SESSION["toggletax"] = 0;
} else {
$tax = 0;
}
if ($row["foodstamp"] != 0 && $_SESSION["togglefoodstamp"] == 0) {
$foodstamp = 1;
} elseif ($row["foodstamp"] != 0 && $_SESSION["togglefoodstamp"] == 1) {
$foodstamp = 0;
$_SESSION["togglefoodstamp"] = 0;
} elseif ($row["foodstamp"] == 0 && $_SESSION["togglefoodstamp"] == 1) {
$foodstamp = 1;
$_SESSION["togglefoodstamp"] = 0;
} else {
$foodstamp = 0;
}
if ($scale == 1) {
$hitareflag = 0;
if ($_SESSION["quantity"] != 0) {
$quantity = $_SESSION["quantity"] - $_SESSION["tare"];
} else {
$quantity = $_SESSION["weight"] - $_SESSION["tare"];
}
if ($quantity <= 0) {
$hitareflag = 1;
}
$_SESSION["tare"] = 0;
}
$discounttype = nullwrap($row["discounttype"]);
$discountable = $row["discount"];
$sale_price = $row["special_price"];
if ($_SESSION["itemDiscount"] > 0 && $_SESSION["itemDiscount"] < 65 && $discounttype != 0) {
$discountable = 1;
$special_price = number_format($sale_price * (100 - $_SESSION["itemDiscount"]) / 100, 2);
$_SESSION["itemDiscount"] = 0;
} elseif ($_SESSION["itemDiscount"] > 0 && $_SESSION["itemDiscount"] < 65) {
$discountable = 1;
$discounttype = 1;
$special_price = number_format($normal_price * (100 - $_SESSION["itemDiscount"]) / 100, 2);
$_SESSION["itemDiscount"] = 0;
}
if ($_SESSION["toggleDiscountable"] == 1) {
$_SESSION["toggleDiscountable"] = 0;
if ($discountable != 0) {
$discountable = 0;
} else {
$discountable = 1;
}
}
if ($_SESSION["nd"] == 1 && $discountable == 7) {
$discountable = 3;
$_SESSION["nd"] = 0;
}
if ($discounttype == 2 || $discounttype == 4) {
$memDiscount = truncate2($normal_price * $quantity) - truncate2($special_price * $quantity);
$discount = 0;
$unitPrice = $normal_price;
} elseif ($discounttype == 1) {
$unitPrice = $special_price;
$unitDiscount = $normal_price - $special_price;
$discount = $unitDiscount * $quantity;
$memDiscount = 0;
} else {
$unitPrice = $normal_price;
$discount = 0;
$memDiscount = 0;
}
if ($_SESSION["isMember"] == 1 && $discounttype == 2) {
$unitPrice = nullwrap($special_price);
}
if ($_SESSION["isStaff"] != 0 && $discounttype == 4) {
$unitPrice = nullwrap($special_price);
}
if ($_SESSION["casediscount"] > 0 && $_SESSION["casediscount"] <= 100) {
$casediscount = (100 - $_SESSION["casediscount"]) / 100;
$unitPrice = $casediscount * $unitPrice;
}
//-------------Mix n Match -------------------------------------
$matched = 0;
$VolSpecial = nullwrap($row["groupprice"]);
$volDiscType = nullwrap($row["pricemethod"]);
$volume = nullwrap($row["quantity"]);
if ($row["advertised"] != 0) {
if ($row["discounttype"] == 2 && $_SESSION["isMember"] == 1 || $row["discounttype"] != 2) {
$VolSpecial = nullwrap($row["specialgroupprice"]);
$volDiscType = nullwrap($row["specialpricemethod"]);
$volume = nullwrap($row["specialquantity"]);
}
}
if ($volDiscType && $volDiscType >= 1) {
// If item is on volume discount
if (!$row["mixmatchcode"] || $row["mixmatchcode"] == 0) {
$mixMatch = 0;
$queryt = "select sum(ItemQtty - matched) as mmqtty from localtemptrans where " . "upc = '" . $row["upc"] . "' group by upc";
} else {
$mixMatch = $row["mixmatchcode"];
$queryt = "select sum(ItemQtty - matched) as mmqtty, mixMatch from localtemptrans " . "where mixMatch = '" . $mixMatch . "' group by mixMatch";
}
if ($volDiscType == 1) {
$unitPrice = truncate2($VolSpecial / $volume);
}
$voladj = $VolSpecial - ($volume - 1) * $unitPrice;
// one at special price
$newmm = (int) ($quantity / $volume);
// number of complete sets
$dbt = tDataConnect();
$resultt = sql_query($queryt, $dbt);
$num_rowst = sql_num_rows($resultt);
if ($num_rowst > 0) {
$rowt = sql_fetch_array($resultt);
$mmqtty = $rowt["mmqtty"];
// number not in complete sets in localtemptrans
} else {
$mmqtty = 0;
}
$newmmtotal = $mmqtty + $quantity % $volume;
$na = $newmmtotal % $volume;
$quantity = $quantity % $volume;
if ($newmm >= 1) {
addItem($upc, $description, "I", "", "", $department, $cost, $newmm, truncate2($VolSpecial), truncate2($newmm * $VolSpecial), truncate2($VolSpecial), $scale, $tax, $foodstamp, $discount, $memDiscount, $discountable, $discounttype, $volume * $newmm, $volDiscType, $volume, $VolSpecial, $mixMatch, $volume * $newmm, 0, 0, '');
$newmm = 0;
$_SESSION["qttyvalid"] = 0;
}
if ($newmmtotal >= $volume) {
addItem($upc, $description, "I", "", "", $department, $cost, 1, $voladj, $voladj, $voladj, $scale, $tax, $foodstamp, $discount, $memDiscount, $discountable, $discounttype, 1, $volDiscType, $volume, $VolSpecial, $mixMatch, $volume, 0, 0, '');
$quantity = $quantity - 1;
$newmmtotal = 0;
$_SESSION["qttyvalid"] = 0;
}
sql_close($dbt);
}
$total = $unitPrice * $quantity;
if (substr($upc, 0, 3) == "002" and $discounttype != 2) {
$unitPrice = truncate2($scaleprice);
$regPrice = $total;
$total = $unitPrice * $quantity;
}
$total = truncate2($total);
$unitPrice = truncate2($unitPrice);
if ($upc == "0000000008010" && $_SESSION["msgrepeat"] == 0) {
$_SESSION["endorseType"] = "giftcert";
$_SESSION["tenderamt"] = $total;
$_SESSION["boxMsg"] = "<b>" . $total . " gift certificate</b><br />insert document<br />press [enter] to endorse<p><font size='-1'>[clear] to cancel</font></p>";
boxMsgscreen();
} elseif ($upc == "0000000008006" && $_SESSION["msgrepeat"] == 0) {
$_SESSION["endorseType"] = "stock";
$_SESSION["tenderamt"] = $total;
$_SESSION["boxMsg"] = "<B>" . $total . " stock payment</B><br />insert form<br />press [enter] to endorse<P><FONT size='-1'>[clear] to cancel</FONT>";
boxMsgscreen();
} elseif ($upc == "0000000008011" && $_SESSION["msgrepeat"] == 0) {
$_SESSION["endorseType"] = "classreg";
$_SESSION["tenderamt"] = $total;
$_SESSION["boxMsg"] = "<b>" . $total . " class registration</b><br />insert form<br />press [enter] to endorse<p><font size='-1'>[clear] to cancel</font></p>";
boxMsgscreen();
} elseif ($hitareflag == 1) {
boxMsg("item weight must be greater than tare weight");
} else {
if ($quantity != 0) {
$qtty = $quantity;
if ($scale == 1) {
goodBeep();
}
if ($_SESSION["casediscount"] > 0) {
addcdnotify();
$discounttype = 3;
$_SESSION["casediscount"] = 0;
$quantity = 1;
$unitPrice = $total;
$regPrice = $total;
}
if ($_SESSION["ddNotify"] == 1 && $_SESSION["itemPD"] == 10) {
$_SESSION["itemPD"] = 0;
$discountable = 7;
}
if ($_SESSION["ddNotify"] == 1 && $discountable == 7) {
$intvoided = 22;
} else {
$intvoided = 0;
}
addItem($upc, $description, "I", " ", " ", $department, $cost, $quantity, $unitPrice, $total, $regPrice, $scale, $tax, $foodstamp, $discount, $memDiscount, $discountable, $discounttype, $qtty, $volDiscType, $volume, $VolSpecial, $mixMatch, $matched, $intvoided, 0, '');
$_SESSION["msgrepeat"] = 0;
$_SESSION["qttyvalid"] = 0;
}
}
if ($deposit && $deposit > 0) {
addDeposit($quantity, $deposit, $foodstamp);
}
if ($tax == 1) {
$_SESSION["istaxable"] = 1;
} else {
$_SESSION["istaxable"] = 0;
$_SESSION["voided"] = 0;
}
if ($discounttype == 1) {
$_SESSION["ondiscount"] = 1;
$_SESSION["voided"] = 2;
adddiscount($discount);
} elseif ($discounttype == 2 && $_SESSION["isMember"] == 1) {
$_SESSION["ondiscount"] = 1;
$_SESSION["voided"] = 2;
addmemspecialmsg();
} elseif ($discounttype == 4 && $_SESSION["isStaff"] != 0) {
$_SESSION["ondiscount"] = 1;
$_SESSION["voided"] = 2;
adddiscount($memDiscount);
} else {
$_SESSION["ondiscount"] = 0;
$_SESSION["voided"] = 0;
}
if ($_SESSION["tare"] != 0) {
$_SESSION["tare"] = 0;
}
$_SESSION["alert"] = "";
$_SESSION["ttlflag"] = 0;
$_SESSION["ttlrequested"] = 0;
$_SESSION["fntlflag"] = 0;
$_SESSION["togglefoodstamp"] = 0;
$_SESSION["toggletax"] = 0;
$_SESSION["repeat"] = 1;
setglobalflags(0);
if ($hitareflag != 1) {
lastpage();
}
}
}
$_SESSION["quantity"] = 0;
$_SESSION["itemPD"] = 0;
}
function deptkey($price, $dept)
{
$intvoided = 0;
if ($_SESSION["quantity"] == 0 && $_SESSION["multiple"] == 0) {
$_SESSION["quantity"] = 1;
}
if (is_numeric($dept) && is_numeric($price) && strlen($price) >= 1 && strlen($dept) >= 2) {
$strprice = $price;
$strdept = $dept;
$price = $price / 100;
$dept = $dept / 10;
if ($_SESSION["casediscount"] > 0 && $_SESSION["casediscount"] <= 100) {
$case_discount = (100 - $_SESSION["casediscount"]) / 100;
$price = $case_discount * $price;
}
$total = $price * $_SESSION["quantity"];
$intdept = $dept;
$query = "select * from departments where dept_no = " . $intdept;
$db = pDataConnect();
$result = sql_query($query, $db);
$num_rows = sql_num_rows($result);
if ($num_rows == 0) {
boxMsg("department unknown");
$_SESSION["quantity"] = 1;
} elseif ($_SESSION["mfcoupon"] == 1) {
$row = sql_fetch_array($result);
$_SESSION["mfcoupon"] = 0;
$query2 = "select department, sum(total) as total from localtemptrans where department = " . $dept . " group by department";
$db2 = tDataConnect();
$result2 = sql_query($query2, $db2);
$num_rows2 = sql_num_rows($result2);
if ($num_rows2 == 0) {
boxMsg("no item found in<br />" . $row["dept_name"]);
} else {
$row2 = sql_fetch_array($result2);
if ($price > $row2["total"]) {
boxMsg("coupon amount greater than department total");
} else {
addItem("", $row["dept_name"] . " Coupon", "I", "CP", "C", $dept, 0, 1, -1 * $price, -1 * $price, -1 * $price, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, $intvoided, 0, '');
$_SESSION["ttlflag"] = 0;
$_SESSION["ttlrequested"] = 0;
goodBeep();
lastpage();
}
}
} else {
$row = sql_fetch_array($result);
if (!$row["dept_limit"]) {
$deptmax = 0;
} else {
$deptmax = $row["dept_limit"];
}
if (!$row["dept_minimum"]) {
$deptmin = 0;
} else {
$deptmin = $row["dept_minimum"];
}
$tax = $row["dept_tax"];
if ($row["dept_fs"] != 0) {
$foodstamp = 1;
} else {
$foodstamp = 0;
}
$deptDiscount = $row["dept_discount"];
if ($_SESSION["toggleDiscountable"] == 1) {
$_SESSION["toggleDiscountable"] = 0;
if ($deptDiscount == 0) {
$deptDiscount = 1;
} else {
$deptDiscount = 0;
}
}
if ($_SESSION["togglefoodstamp"] == 1) {
$foodstamp = ($foodstamp + 1) % 2;
$_SESSION["togglefoodstamp"] = 0;
}
// Hard coding starts
if ($dept == 606) {
$price = -1 * $price;
$total = -1 * $total;
}
// Hard coding ends
if ($_SESSION["ddNotify"] != 0 && $_SESSION["itemPD"] == 10) {
$_SESSION["itemPD"] = 0;
$deptDiscount = 7;
$intvoided = 22;
}
//------------- Find EQUITY payments and force member# entry ~joel 2006-12-12
if ($_SESSION["store"] == "acg") {
if ($dept == 45 && $_SESSION["member"] != 0) {
// dp 45 = member equity
maindisplay("memsearch.php");
}
if ($dept == 41) {
// dp 41 = bottle deposit
$price = -1 * $price;
$total = -1 * $total;
}
}
if ($price > $deptmax && $_SESSION["msgrepeat"] == 0) {
$_SESSION["boxMsg"] = "\$" . $price . " is greater than department limit<p>" . "<font size='-1'>[clear] to cancel, [enter] to proceed</font></p>";
boxMsgscreen();
} elseif ($price < $deptmin && $_SESSION["msgrepeat"] == 0) {
$_SESSION["boxMsg"] = "\$" . $price . " is lower than department minimum<p>" . "<font size='-1'>[clear] to cancel, [enter] to proceed</font></p>";
boxMsgscreen();
} else {
if ($_SESSION["casediscount"] > 0) {
addcdnotify();
$_SESSION["casediscount"] = 0;
}
if ($_SESSION["toggletax"] == 1) {
$tax = ($tax + 1) % 2;
$_SESSION["toggletax"] = 0;
}
addItem($price . "DP" . $dept, $row["dept_name"], "D", " ", " ", $dept, 0, $_SESSION["quantity"], $price, $total, $price, 0, $tax, $foodstamp, 0, 0, $deptDiscount, 0, $_SESSION["quantity"], 0, 0, 0, 0, 0, $intvoided, 0, '');
$_SESSION["ttlflag"] = 0;
$_SESSION["ttlrequested"] = 0;
goodBeep();
lastpage();
$_SESSION["msgrepeat"] = 0;
}
}
} else {
inputUnknown();
$_SESSION["quantity"] = 1;
}
$_SESSION["quantity"] = 0;
$_SESSION["itemPD"] = 0;
}
</head>
<body>
<form action='ccTender.php' method='post' name='form1' tabindex='0'>
<input Type='hidden' name='input' size='20'>
</form>
<table border='0' cellspacing='0' cellpadding='0'>
<tr>
<td align='left' valign='top' width='200'></td>
</tr>
</table>
<?
if(!function_exists("boxMsg")) {
include("drawscreen.php");
}
include_once("lib.php");
$_SESSION["boxMsg"] = "<b>approved</b><p><font size=-1>[Enter] to continue</font>";
boxMsg($_SESSION["boxMsg"]);
$_SESSION["boxMsg"] = '';
$_SESSION["msgrepeat"] = 2;
goodBeep();
printfooter();
?>
<script type="text/javascript">
var msgrepeat=2;
</script>
</BODY>
</html>
function addItem($strupc, $strdescription, $strtransType, $strtranssubType, $strtransstatus, $intdepartment, $dblquantity, $dblunitPrice, $dbltotal, $dblregPrice, $intscale, $inttax, $intfoodstamp, $dbldiscount, $dblmemDiscount, $intdiscountable, $intdiscounttype, $dblItemQtty, $intvolDiscType, $intvolume, $dblVolSpecial, $intmixMatch, $intmatched, $intvoided)
{
//$dbltotal = truncate2(str_replace(",", "", $dbltotal)); replaced by apbw 7/27/05 with the next 4 lines -- to fix thousands place errors
$dbltotal = str_replace(",", "", $dbltotal);
$dbltotal = number_format($dbltotal, 2, '.', '');
$dblunitPrice = str_replace(",", "", $dblunitPrice);
$dblunitPrice = number_format($dblunitPrice, 2, '.', '');
if ($_SESSION["refund"] == 1) {
$dblquantity = -1 * $dblquantity;
$dbltotal = -1 * $dbltotal;
$dbldiscount = -1 * $dbldiscount;
$dblmemDiscount = -1 * $dblmemDiscount;
if ($strtransstatus != "V" && $strtransstatus != "D") {
$strtransstatus = "R";
}
// edited by apbw 6/04/05 to correct voiding of refunded items
$_SESSION["refund"] = 0;
} elseif ($_SESSION["void"] == 1) {
$dblquantity = -1 * $dblquantity;
$dbltotal = -1 * $dbltotal;
$strtransstatus = "V";
$_SESSION["void"] = 0;
}
$intregisterno = $_SESSION["laneno"];
$intempno = $_SESSION["CashierNo"];
$inttransno = $_SESSION["transno"];
$strCardNo = $_SESSION["memberID"];
$memType = $_SESSION["memType"];
$staff = $_SESSION["isStaff"];
$db = tDataConnect();
if ($_SESSION["DBMS"] == "mssql") {
$datetimestamp = strftime("%m/%d/%y %H:%M:%S %p", time());
} else {
$datetimestamp = strftime("%Y-%m-%d %H:%M:%S %p", time());
}
$_SESSION["datetimestamp"] = $datetimestamp;
$_SESSION["LastID"] = $_SESSION["LastID"] + 1;
$trans_id = $_SESSION["LastID"];
$strqinsert = "INSERT into localtemptrans (datetime, register_no, emp_no, trans_no, upc, description, trans_type, " . "trans_subtype, trans_status, department, quantity, unitPrice, total, regPrice, scale, tax, " . "foodstamp, discount, memDiscount, discountable, discounttype, ItemQtty, volDiscType, volume, " . "VolSpecial, mixMatch, matched, voided, memType, staff, card_no) " . "values (" . "'" . $datetimestamp . "', " . $intregisterno . ", " . $intempno . ", " . nullwrap($inttransno) . ", " . "'" . nullwrap($strupc) . "', " . "'" . $strdescription . "', " . "'" . nullwrap($strtransType) . "', " . "'" . nullwrap($strtranssubType) . "', " . "'" . nullwrap($strtransstatus) . "', " . nullwrap($intdepartment) . ", " . nullwrap($dblquantity) . ", " . nullwrap($dblunitPrice) . ", " . nullwrap($dbltotal) . ", " . nullwrap($dblregPrice) . ", " . nullwrap($intscale) . ", " . nullwrap($inttax) . ", " . nullwrap($intfoodstamp) . ", " . nullwrap($dbldiscount) . ", " . nullwrap($dblmemDiscount) . ", " . nullwrap($intdiscountable) . ", " . nullwrap($intdiscounttype) . ", " . nullwrap($dblItemQtty) . ", " . nullwrap($intvolDiscType) . ", " . nullwrap($intvolume) . ", " . nullwrap($dblVolSpecial) . ", " . nullwrap($intmixMatch) . ", " . nullwrap($intmatched) . ", " . nullwrap($intvoided) . ", " . nullwrap($memType) . ", " . nullwrap($staff) . ", " . "'" . (string) $strCardNo . "') ";
// .$trans_id.") ";
// echo $strqinsert;
sql_query($strqinsert, $db);
sql_close($db);
if ($strtransType == "I" || $strtransType == "D") {
goodBeep();
if ($intscale == 1) {
$_SESSION["screset"] = "rePoll";
} elseif ($_SESSION["weight"] != 0) {
$_SESSION["screset"] = "rePoll";
}
$_SESSION["repeatable"] = 1;
}
$_SESSION["msgrepeat"] = 0;
$_SESSION["toggletax"] = 0;
$_SESSION["togglefoodstamp"] = 0;
$_SESSION["SNR"] = 0;
$_SESSION["wgtRequested"] = 0;
$_SESSION["nd"] = 0;
$_SESSION["ccAmtEntered"] = 0;
$_SESSION["ccAmt"] = 0;
}
function upcscanned($entered)
{
$hitareflag = 0;
$entered = str_replace(".", " ", $entered);
if (strlen($entered) == 0 || !$entered) {
lastpage();
} else {
if ($_SESSION["quantity"] == 0 && $_SESSION["multiple"] == 0) {
$quantity = 1;
} else {
$quantity = $_SESSION["quantity"];
}
}
$scaleprice = 0;
if (substr($entered, 0, 1) == 0 && strlen($entered) == 7) {
$p6 = substr($entered, -1);
if ($p6 == 0) {
$entered = substr($entered, 0, 3) . "00000" . substr($entered, 3, 3);
} elseif ($p6 == 1) {
$entered = substr($entered, 0, 3) . "10000" . substr($entered, 4, 3);
} elseif ($p6 == 2) {
$entered = substr($entered, 0, 3) . "20000" . substr($entered, 4, 3);
} elseif ($p6 == 3) {
$entered = substr($entered, 0, 4) . "00000" . substr($entered, 4, 2);
} elseif ($p6 == 4) {
$entered = substr($entered, 0, 5) . "00000" . substr($entered, 6, 1);
} else {
$entered = substr($entered, 0, 6) . "0000" . $p6;
}
}
if (strlen($entered) == 13 && substr($entered, 0, 1) != 0) {
$upc = "0" . substr($entered, 0, 12);
} else {
$upc = substr("0000000000000" . $entered, -13);
}
// ccm-rle 10-6-2009 uncommented this line below- this made it show up but it added a 7 to the price.
if (substr($upc, 0, 3) == "002") {
$scaleprice = truncate2(substr($upc, -4) / 100);
$upc = substr($upc, 0, 8) . "00000";
}
$query = "select * from products where upc = '" . $upc . "' AND inUse = 1";
$db = pDataConnect();
$result = sql_query($query, $db);
$num_rows = sql_num_rows($result);
$row = sql_fetch_array($result);
$start_date = $row["start_date"];
$end_date = $row["end_date"];
$normal_price = $row["normal_price"];
$sale_start_date = date("Y-n-d H:i:s", $start_date);
$sale_end_date = date("Y-n-d H:i:s", $end_date);
$special_price = $row["special_price"];
$right_now = date("Y-n-d H:i:s");
$deposit = $row["deposit"];
if ($num_rows == 0 && substr($upc, 0, 3) != "005") {
boxMsg($upc . "<BR><B>is not a valid item</B>");
} elseif ($num_rows == 0 && substr($upc, 0, 3) == "005") {
couponcode($upc);
} elseif ($row["scale"] != 0 && $_SESSION["weight"] == 0 && $_SESSION["quantity"] == 0) {
if ($_SESSION["wgtRequested"] == 0) {
$_SESSION["wgtRequested"] = 1;
lastpage();
echo "<SCRIPT type=\"text/javascript\">\n" . "lockScreen = setTimeout('document.forms[0].elements[0].value = \"" . $_SESSION["strEntered"] . "\"; document.forms[0].submit();', 700)\n" . "</SCRIPT>";
} else {
$_SESSION["SNR"] = 1;
boxMsg("please put item on scale");
$_SESSION["wgtRequested"] = 0;
}
} elseif ($row["scale"] != 0 && $_SESSION["scale"] == 0) {
$_SESSION["waitforScale"] = 1;
$_SESSION["SNR"] = 1;
lastpage();
//boxMsg("wait for scale");
} elseif ($row["scale"] == 0 && (int) $_SESSION["quantity"] != $_SESSION["quantity"] && $_SESSION["fractions"] != 1) {
boxMsg("fractional quantity cannot be accepted for this item");
} elseif ($_SESSION["itemDiscount"] < 0 || $_SESSION["itemDiscount"] > 101) {
xboxMsg("item cannot be<br>discounted at " . $_SESSION["itemDiscount"] . "%");
$_SESSION["itemDiscount"] = 0;
} else {
$mixMatch = 0;
$qttyEnforced = $row["qttyEnforced"];
if ($qttyEnforced == 1 && $_SESSION["multiple"] == 0 && $_SESSION["msgrepeat"] == 0) {
qttyscreen();
} else {
$_SESSION["qttyvalid"] = 1;
}
if ($_SESSION["qttyvalid"] != 1) {
sql_close($db);
} else {
$upc = $row["upc"];
$description = $row["description"];
$description = str_replace("'", "", $description);
$description = str_replace(",", "", $description);
$transType = "I";
$transsubType = "CA";
$department = $row["department"];
$unitPrice = $normal_price;
$regPrice = $normal_price;
$CardNo = $_SESSION["memberID"];
if ($row["scale"] != 0) {
$scale = 1;
} else {
$scale = 0;
}
// ccm-rle 9-23-09 below is probably where I need to modify the code to ensure that tax is turned off if an item is toggled for foodstamps. actually the co-op wants this tax to be recorded somewhere that is queriable but not passed onto to the customer so this needs to be further researched
if ($row["tax"] != 0 && $_SESSION["toggletax"] == 0) {
$tax = $row["tax"];
} elseif ($row["tax"] != 0 && $_SESSION["toggletax"] == 1) {
$tax = 0;
$_SESSION["toggletax"] = 0;
} elseif ($row["tax"] == 0 && $_SESSION["toggletax"] == 1) {
$tax = 1;
$_SESSION["toggletax"] = 0;
} else {
$tax = 0;
}
if ($row["foodstamp"] != 0 && $_SESSION["togglefoodstamp"] == 0) {
$foodstamp = 1;
} elseif ($row["foodstamp"] != 0 && $_SESSION["togglefoodstamp"] == 1) {
$foodstamp = 0;
$_SESSION["togglefoodstamp"] = 0;
} elseif ($row["foodstamp"] == 0 && $_SESSION["togglefoodstamp"] == 1) {
$foodstamp = 1;
$_SESSION["togglefoodstamp"] = 0;
} else {
$foodstamp = 0;
}
if ($scale == 1) {
$hitareflag = 0;
if ($_SESSION["quantity"] != 0) {
$quantity = $_SESSION["quantity"] - $_SESSION["tare"];
} else {
$quantity = $_SESSION["weight"] - $_SESSION["tare"];
}
if ($quantity <= 0) {
$hitareflag = 1;
}
$_SESSION["tare"] = 0;
}
// ccm-rle 9-23-09 - this is where the initial check as to whether an item is discountable happens also seems to have the 65 percent hard limit on a discount set. fannie sets a no discount flag to cause discount to equal 0 if this is checked thus stopping discounts (there was an error in the smarty templates that caused a reversal of the logic. not sure where discounttype comes from or where department discount fields come in yet
//ccm-rle 11-11-09 - if the current date is not between the sale start date & end date turn off the discount
$discounttype = nullwrap($row["discounttype"]);
// if (!($right_now >= $sale_start_date && $right_now <= $sale_end_date)) { $discounttype = 0; }
$discountable = $row["discount"];
$sale_price = $row["special_price"];
if ($_SESSION["itemDiscount"] > 0 && $_SESSION["itemDiscount"] < 101 && $discounttype != 0) {
$discountable = 0;
$special_price = number_format($sale_price * (100 - $_SESSION["itemDiscount"]) / 100, 2);
$_SESSION["itemDiscount"] = 0;
$upc = "D" . substr($upc, 1);
// new by Tak
} elseif ($_SESSION["itemDiscount"] > 0 && $_SESSION["itemDiscount"] < 101 && substr($upc, 0, 3) == "002") {
$discountable = 0;
$discounttype = 1;
$special_price = number_format($scaleprice * (100 - $_SESSION["itemDiscount"]) / 100, 2);
$_SESSION["itemDiscount"] = 0;
$upc = "D" . substr($upc, 1);
} elseif ($_SESSION["itemDiscount"] > 0 && $_SESSION["itemDiscount"] < 101) {
$discountable = 0;
$discounttype = 1;
$special_price = number_format($normal_price * (100 - $_SESSION["itemDiscount"]) / 100, 2);
$_SESSION["itemDiscount"] = 0;
$upc = "D" . substr($upc, 1);
// new by Tak
}
// ccm-rle 9-23-09 this seems to toggle whether an item is discountable but I'm not sure where toggleDiscountable is called or how it is called yet.
if ($_SESSION["toggleDiscountable"] == 1) {
$_SESSION["toggleDiscountable"] = 0;
if ($discountable != 0) {
$discountable = 0;
} else {
$discountable = 1;
}
}
// ccm-rle 9-23-09 - find out where session nd can be set and what sets discountable to 7
if ($_SESSION["nd"] == 1 && $discountable == 7) {
$discountable = 3;
$_SESSION["nd"] = 0;
}
if ($discounttype == 2 || $discounttype == 4) {
$memDiscount = truncate2($normal_price * $quantity) - truncate2($special_price * $quantity);
$discount = 0;
$unitPrice = $normal_price;
} elseif ($discounttype == 1 && substr($upc, 0, 3) == "D02") {
$unitPrice = $special_price;
$unitDiscount = $scaleprice - $special_price;
$discount = $unitDiscount * $quantity;
$memDiscount = 0;
} elseif ($discounttype == 1) {
$unitPrice = $special_price;
$unitDiscount = $normal_price - $special_price;
$discount = $unitDiscount * $quantity;
$memDiscount = 0;
} else {
$unitPrice = $normal_price;
$discount = 0;
$memDiscount = 0;
}
if ($_SESSION["isMember"] == 1 && $discounttype == 2) {
$unitPrice = nullwrap($special_price);
}
if ($_SESSION["isStaff"] != 0 && $discounttype == 4) {
$unitPrice = nullwrap($special_price);
}
if ($_SESSION["casediscount"] > 0 && $_SESSION["casediscount"] <= 100) {
$casediscount = (100 - $_SESSION["casediscount"]) / 100;
$unitPrice = $casediscount * $unitPrice;
}
//-------------Mix n Match -------------------------------------
$matched = 0;
$VolSpecial = nullwrap($row["groupprice"]);
$volDiscType = nullwrap($row["pricemethod"]);
$volume = nullwrap($row["quantity"]);
if ($row["advertised"] != 0) {
if ($row["discounttype"] == 2 && $_SESSION["isMember"] == 1 || $row["discounttype"] != 2) {
$VolSpecial = nullwrap($row["specialgroupprice"]);
$volDiscType = nullwrap($row["specialpricemethod"]);
$volume = nullwrap($row["specialquantity"]);
}
}
if ($volDiscType && $volDiscType >= 1) {
// If item is on volume discount
if (!$row["mixmatchcode"] || $row["mixmatchcode"] == 0) {
$mixMatch = 0;
$queryt = "select sum(ItemQtty - matched) as mmqtty from localtemptrans where " . "upc = '" . $row["upc"] . "' group by upc";
} else {
$mixMatch = $row["mixmatchcode"];
$queryt = "select sum(ItemQtty - matched) as mmqtty, mixMatch from localtemptrans " . "where mixMatch = '" . $mixMatch . "' group by mixMatch";
}
if ($volDiscType == 1) {
$unitPrice = truncate2($VolSpecial / $volume);
}
$voladj = $VolSpecial - ($volume - 1) * $unitPrice;
// one at special price
$newmm = (int) ($quantity / $volume);
// number of complete sets
$dbt = tDataConnect();
$resultt = sql_query($queryt, $dbt);
$num_rowst = sql_num_rows($resultt);
if ($num_rowst > 0) {
$rowt = sql_fetch_array($resultt);
$mmqtty = $rowt["mmqtty"];
// number not in complete sets in localtemptrans
} else {
$mmqtty = 0;
}
$newmmtotal = $mmqtty + $quantity % $volume;
$na = $newmmtotal % $volume;
$quantity = $quantity % $volume;
if ($newmm >= 1) {
addItem($upc, $description, "I", "", "", $department, $newmm, truncate2($VolSpecial), truncate2($newmm * $VolSpecial), truncate2($VolSpecial), $scale, $tax, $foodstamp, $discount, $memDiscount, $discountable, $discounttype, $volume * $newmm, $volDiscType, $volume, $VolSpecial, $mixMatch, $volume * $newmm, 0);
$newmm = 0;
$_SESSION["qttyvalid"] = 0;
}
if ($newmmtotal >= $volume) {
addItem($upc, $description, "I", "", "", $department, 1, $voladj, $voladj, $voladj, $scale, $tax, $foodstamp, $discount, $memDiscount, $discountable, $discounttype, 1, $volDiscType, $volume, $VolSpecial, $mixMatch, $volume, 0);
$quantity = $quantity - 1;
$newmmtotal = 0;
$_SESSION["qttyvalid"] = 0;
}
sql_close($dbt);
}
//--------------------------------------------------------------------------
$total = $unitPrice * $quantity;
// ccm-rle 10-06-2009 tried changing it to 02 instead of 002 below
if (substr($upc, 0, 3) == "002" and $discounttype != 2) {
$unitPrice = truncate2($scaleprice);
$regPrice = $total;
$total = $unitPrice * $quantity;
}
$total = truncate2($total);
$unitPrice = truncate2($unitPrice);
if ($upc == "0000000008010" && $_SESSION["msgrepeat"] == 0) {
$_SESSION["endorseType"] = "giftcert";
$_SESSION["tenderamt"] = $total;
$_SESSION["boxMsg"] = "<B>" . $total . " gift certificate</B><BR>insert document<BR>press [enter] to endorse<P><FONT size='-1'>[clear] to cancel</FONT>";
boxMsgscreen();
} elseif ($upc == "0000000008006" && $_SESSION["msgrepeat"] == 0) {
$_SESSION["endorseType"] = "stock";
$_SESSION["tenderamt"] = $total;
$_SESSION["boxMsg"] = "<B>" . $total . " stock payment</B><BR>insert form<BR>press [enter] to endorse<P><FONT size='-1'>[clear] to cancel</FONT>";
boxMsgscreen();
} elseif ($upc == "0000000008011" && $_SESSION["msgrepeat"] == 0) {
$_SESSION["endorseType"] = "classreg";
$_SESSION["tenderamt"] = $total;
$_SESSION["boxMsg"] = "<B>" . $total . " class registration</B><BR>insert form<BR>press [enter] to endorse<P><FONT size='-1'>[clear] to cancel</FONT>";
boxMsgscreen();
} elseif ($hitareflag == 1) {
boxMsg("item weight must be greater than tare weight");
} else {
if ($quantity != 0) {
$qtty = $quantity;
if ($scale == 1) {
goodBeep();
}
if ($_SESSION["casediscount"] > 0) {
addcdnotify();
$discounttype = 3;
$_SESSION["casediscount"] = 0;
$quantity = 1;
$unitPrice = $total;
$regPrice = $total;
}
if ($_SESSION["ddNotify"] == 1 && $_SESSION["itemPD"] == 10) {
$_SESSION["itemPD"] = 0;
$discountable = 7;
}
if ($_SESSION["ddNotify"] == 1 && $discountable == 7) {
$intvoided = 22;
} else {
$intvoided = 0;
}
addItem($upc, $description, "I", " ", " ", $department, $quantity, $unitPrice, $total, $regPrice, $scale, $tax, $foodstamp, $discount, $memDiscount, $discountable, $discounttype, $qtty, $volDiscType, $volume, $VolSpecial, $mixMatch, $matched, $intvoided);
$_SESSION["msgrepeat"] = 0;
$_SESSION["qttyvalid"] = 0;
}
}
if ($deposit && $deposit > 0) {
addDeposit($quantity, $deposit, $foodstamp);
}
if ($tax == 1) {
$_SESSION["istaxable"] = 1;
} else {
$_SESSION["istaxable"] = 0;
$_SESSION["voided"] = 0;
}
if ($discounttype == 1) {
$_SESSION["ondiscount"] = 1;
$_SESSION["voided"] = 2;
adddiscount($discount);
} elseif ($discounttype == 2 && $_SESSION["isMember"] == 1) {
$_SESSION["ondiscount"] = 1;
$_SESSION["voided"] = 2;
adddiscount($memDiscount);
} elseif ($discounttype == 4 && $_SESSION["isStaff"] != 0) {
$_SESSION["ondiscount"] = 1;
$_SESSION["voided"] = 2;
adddiscount($memDiscount);
} else {
$_SESSION["ondiscount"] = 0;
$_SESSION["voided"] = 0;
}
// sql_close($db);
if ($_SESSION["tare"] != 0) {
$_SESSION["tare"] = 0;
}
$_SESSION["alert"] = "";
$_SESSION["ttlflag"] = 0;
$_SESSION["ttlrequested"] = 0;
$_SESSION["fntlflag"] = 0;
$_SESSION["togglefoodstamp"] = 0;
$_SESSION["toggletax"] = 0;
$_SESSION["repeat"] = 1;
setglobalflags(0);
if ($hitareflag != 1) {
lastpage();
}
}
}
$_SESSION["quantity"] = 0;
$_SESSION["itemPD"] = 0;
}