PHP MiscLib::nullwrap方法代码示例

 function parse($str)
 {
     $ret = $this->default_json();
     $query = "select upc,description,VolSpecial,quantity,\n            total,discount,memDiscount,discountable,\n            unitPrice,scale,foodstamp,voided,discounttype,\n            trans_type,trans_status,department,regPrice,\n            tax,volume,volDiscType\n            from localtemptrans where \n            trans_id = " . CoreLocal::get("currentid");
     $connection = Database::tDataConnect();
     $result = $connection->query($query);
     $num_rows = $connection->num_rows($result);
     if ($num_rows > 0) {
         $row = $connection->fetch_array($result);
         $strUPC = $row["upc"];
         $strDescription = $row["description"];
         $dblVolSpecial = $row["VolSpecial"];
         $dblquantity = -0.5 * $row["quantity"];
         $dblTotal = MiscLib::truncate2(-1 * 0.5 * $row["total"]);
         // invoked truncate2 rounding function to fix half-penny errors apbw 3/7/05
         $strCardNo = CoreLocal::get("memberID");
         $dblDiscount = $row["discount"];
         $dblmemDiscount = $row["memDiscount"];
         $intDiscountable = $row["discountable"];
         $dblUnitPrice = $row["unitPrice"];
         $intScale = MiscLib::nullwrap($row["scale"]);
         if ($row["foodstamp"] != 0) {
             $intFoodStamp = 1;
         } else {
             $intFoodStamp = 0;
         }
         $intdiscounttype = MiscLib::nullwrap($row["discounttype"]);
         if ($row["voided"] == 20) {
             $ret['output'] = DisplayLib::boxMsg(_("Discount already taken"), '', false, DisplayLib::standardClearButton());
         } elseif ($row["trans_type"] == "T" or $row["trans_status"] == "D" or $row["trans_status"] == "V" or $row["trans_status"] == "C") {
             $ret['output'] = DisplayLib::boxMsg(_("Item cannot be discounted"), '', false, DisplayLib::standardClearButton());
         } elseif (strncasecmp($strDescription, "Club Card", 9) == 0) {
             //----- edited by abpw 2/15/05 -----
             $ret['output'] = DisplayLib::boxMsg(_("Item cannot be discounted"), '', false, DisplayLib::standardClearButton());
         } elseif (CoreLocal::get("tenderTotal") < 0 and $intFoodStamp == 1 and -1 * $dblTotal > CoreLocal::get("fsEligible")) {
             $ret['output'] = DisplayLib::boxMsg(_("Item already paid for"), '', false, DisplayLib::standardClearButton());
         } elseif (CoreLocal::get("tenderTotal") < 0 and -1 * $dblTotal > CoreLocal::get("runningTotal") - CoreLocal::get("taxTotal")) {
             $ret['output'] = DisplayLib::boxMsg(_("Item already paid for"), '', false, DisplayLib::standardClearButton());
         } else {
             // --- added partial item desc to club card description - apbw 2/15/05 ---
             TransRecord::addRecord(array('upc' => $strUPC, 'description' => "Club Card: " . substr($strDescription, 0, 19), 'trans_type' => "I", 'trans_status' => "J", 'department' => $row["department"], 'quantity' => $dblquantity, 'unitPrice' => $dblUnitPrice, 'total' => $dblTotal, 'regPrice' => 0.5 * $row["regPrice"], 'scale' => $intScale, 'tax' => $row["tax"], 'foodstamp' => $intFoodStamp, 'discount' => $dblDiscount, 'memDiscount' => $dblmemDiscount, 'discountable' => $intDiscountable, 'discounttype' => $intdiscounttype, 'ItemQtty' => $dblquantity, 'volDiscType' => $row["volDiscType"], 'volume' => $row["volume"], 'VolSpecial' => $dblVolSpecial));
             $update = "update localtemptrans set voided = 20 where trans_id = " . CoreLocal::get("currentid");
             $connection = Database::tDataConnect();
             $connection->query($update);
             CoreLocal::set("TTLflag", 0);
             CoreLocal::set("TTLRequested", 0);
             $ret['output'] = DisplayLib::lastpage();
         }
     }
     return $ret;
 }

 public function testMiscLib()
 {
     chdir(dirname(__FILE__) . '/../../pos/is4c-nf/gui-modules/');
     $rel = MiscLib::baseURL();
     $this->assertEquals('../', $rel);
     $this->assertEquals(1, MiscLib::nullwrap(1));
     $this->assertEquals(1.5, MiscLib::nullwrap(1.5));
     $this->assertEquals('test', MiscLib::nullwrap('test'));
     $this->assertEquals(0, MiscLib::nullwrap(False));
     $this->assertEquals(1, MiscLib::truncate2(1));
     $this->assertEquals(1.99, MiscLib::truncate2(1.99));
     $this->assertEquals(1.99, MiscLib::truncate2("1.99"));
     $this->assertEquals(1.35, MiscLib::truncate2("1.345"));
     $hostCheck = MiscLib::pingport(CoreLocal::get('localhost'), CoreLocal::get('DBMS'));
     $this->assertInternalType('integer', $hostCheck);
     $hostCheck = MiscLib::win32();
     $this->assertInternalType('integer', $hostCheck);
     $scale = MiscLib::scaleObject();
     if ($scale !== 0) {
         $this->assertInstanceOf('ScaleDriverWrapper', $scale);
     }
 }

 function discountupc($upc, $item_num = -1, $pd = 0)
 {
     $lastpageflag = 1;
     $deliflag = 0;
     $quantity = 0;
     if (strpos($upc, "*") && (strpos($upc, "**") || strpos($upc, "*") == 0 || strpos($upc, "*") == strlen($upc) - 1)) {
         $upc = "stop";
     } elseif (strpos($upc, "*")) {
         $voidupc = explode("*", $upc);
         if (!is_numeric($voidupc[0])) {
             $upc = "stop";
         } else {
             $quantity = $voidupc[0];
             $upc = $voidupc[1];
             $weight = 0;
         }
     } elseif (!is_numeric($upc) && !strpos($upc, "DP")) {
         $upc = "stop";
     } else {
         $quantity = 1;
         $weight = CoreLocal::get("weight");
     }
     $scaleprice = 0;
     if (is_numeric($upc)) {
         $upc = substr("0000000000000" . $upc, -13);
         if (substr($upc, 0, 3) == "002" && substr($upc, -5) != "00000") {
             $scaleprice = substr($upc, 10, 4) / 100;
             $upc = substr($upc, 0, 8) . "0000";
             $deliflag = 1;
         } elseif (substr($upc, 0, 3) == "002" && substr($upc, -5) == "00000") {
             $deliflag = 1;
         }
     }
     if ($upc == "stop") {
         return DisplayLib::inputUnknown();
     }
     $db = Database::tDataConnect();
     $query = "select sum(ItemQtty) as voidable, sum(quantity) as vquantity, max(scale) as scale, " . "max(volDiscType) as volDiscType from localtemptrans where upc = '" . $upc . "' and unitPrice = " . $scaleprice . " and discounttype <> 3 group by upc";
     $result = $db->query($query);
     $num_rows = $db->num_rows($result);
     if ($num_rows == 0) {
         return DisplayLib::boxMsg(_("Item not found: ") . $upc, '', false, DisplayLib::standardClearButton());
     }
     $row = $db->fetch_array($result);
     if ($row["scale"] == 1 && $weight > 0) {
         $quantity = $weight - CoreLocal::get("tare");
         CoreLocal::set("tare", 0);
     }
     $volDiscType = $row["volDiscType"];
     $voidable = MiscLib::nullwrap($row["voidable"]);
     $VolSpecial = 0;
     $volume = 0;
     $scale = MiscLib::nullwrap($row["scale"]);
     //----------------------Void Item------------------
     $query_upc = "select ItemQtty,foodstamp,discounttype,mixMatch,cost,\n            numflag,charflag,unitPrice,discounttype,regPrice,discount,\n            memDiscount,discountable,description,trans_type,trans_subtype,\n            department,tax,VolSpecial\n            from localtemptrans where upc = '" . $upc . "' and unitPrice = " . $scaleprice . " and trans_id={$item_num}";
     $result = $db->query($query_upc);
     $row = $db->fetch_array($result);
     $ItemQtty = $row["ItemQtty"];
     $foodstamp = MiscLib::nullwrap($row["foodstamp"]);
     $discounttype = MiscLib::nullwrap($row["discounttype"]);
     $mixMatch = MiscLib::nullwrap($row["mixMatch"]);
     $cost = isset($row["cost"]) ? -1 * $row["cost"] : 0;
     $numflag = isset($row["numflag"]) ? $row["numflag"] : 0;
     $charflag = isset($row["charflag"]) ? $row["charflag"] : 0;
     $unitPrice = $row["unitPrice"];
     if (CoreLocal::get("isMember") != 1 && $row["discounttype"] == 2 || CoreLocal::get("isStaff") == 0 && $row["discounttype"] == 4) {
         $unitPrice = $row["regPrice"];
     } elseif ((CoreLocal::get("isMember") == 1 && $row["discounttype"] == 2 || CoreLocal::get("isStaff") != 0 && $row["discounttype"] == 4) && $row["unitPrice"] == $row["regPrice"]) {
         $db_p = Database::pDataConnect();
         $query_p = "select special_price from products where upc = '" . $upc . "'";
         $result_p = $db_p->query($query_p);
         $row_p = $db_p->fetch_array($result_p);
         $unitPrice = $row_p["special_price"];
     }
     $discount = -1 * $row["discount"];
     $memDiscount = -1 * $row["memDiscount"];
     $discountable = $row["discountable"];
     $CardNo = CoreLocal::get("memberID");
     $discounttype = MiscLib::nullwrap($row["discounttype"]);
     if ($discounttype == 3) {
         $quantity = -1 * $ItemQtty;
     } elseif ($quantity != 0) {
         TransRecord::addRecord(array('upc' => $upc, 'description' => $row["description"], 'trans_type' => $row["trans_type"], 'trans_subtype' => $row["trans_subtype"], 'trans_status' => "V", 'department' => $row["department"], 'quantity' => $quantity, 'unitPrice' => $unitPrice, 'total' => $total, 'regPrice' => $row["regPrice"], 'scale' => $scale, 'tax' => $row["tax"], 'foodstamp' => $foodstamp, 'discount' => $discount, 'memDiscount' => $memDiscount, 'discountable' => $discountable, 'discounttype' => $discounttype, 'quantity' => $quantity, 'volDiscType' => $volDiscType, 'volume' => $volume, 'VolSpecial' => $VolSpecial, 'mixMatch' => $mixMatch, 'voided' => 1, 'cost' => $cost, 'numflag' => $numflag, 'charflag' => $charflag));
         if ($row["trans_type"] != "T") {
             CoreLocal::set("ttlflag", 0);
         }
         $db = Database::pDataConnect();
         $chk = $db->query("SELECT deposit FROM products WHERE upc='{$upc}'");
         if ($db->num_rows($chk) > 0) {
             $dpt = array_pop($db->fetch_row($chk));
             if ($dpt > 0) {
                 $dupc = (int) $dpt;
                 return $this->voidupc(-1 * $quantity . "*" . $dupc, True);
             }
         }
     }
     return "";
 }

 private function addDeposit($upc)
 {
     $upc = str_pad($upc, 13, '0', STR_PAD_LEFT);
     $db = Database::pDataConnect();
     $query = "select description,scale,tax,foodstamp,discounttype,\n            discount,department,normal_price\n                   from products where upc='" . $upc . "'";
     $result = $db->query($query);
     if ($db->num_rows($result) <= 0) {
         return;
     }
     $row = $db->fetch_array($result);
     $description = $row["description"];
     $description = str_replace("'", "", $description);
     $description = str_replace(",", "", $description);
     $scale = 0;
     if ($row["scale"] != 0) {
         $scale = 1;
     }
     list($tax, $foodstamp, $discountable) = PrehLib::applyToggles($row['tax'], $row['foodstamp'], $row['discount']);
     $discounttype = MiscLib::nullwrap($row["discounttype"]);
     $quantity = 1;
     if (CoreLocal::get("quantity") != 0) {
         $quantity = CoreLocal::get("quantity");
     }
     $save_refund = CoreLocal::get("refund");
     TransRecord::addRecord(array('upc' => $upc, 'description' => $description, 'trans_type' => 'I', 'trans_subtype' => 'AD', 'department' => $row['department'], 'quantity' => $quantity, 'ItemQtty' => $quantity, 'unitPrice' => $row['normal_price'], 'total' => $quantity * $row['normal_price'], 'regPrice' => $row['normal_price'], 'scale' => $scale, 'tax' => $tax, 'foodstamp' => $foodstamp, 'discountable' => $discountable, 'discounttype' => $discounttype));
     CoreLocal::set("refund", $save_refund);
 }

 function preprocess()
 {
     $this->upc = "";
     $this->found = false;
     $this->pricing = array('sale' => false, 'actual_price' => '', 'memPrice' => '', 'description', 'department', 'regular_price');
     if (isset($_REQUEST['reginput']) && strtoupper($_REQUEST['reginput']) == "CL") {
         // cancel
         $this->change_page($this->page_url . "gui-modules/pos2.php");
         return false;
     } else {
         if (isset($_REQUEST['reginput']) || isset($_REQUEST['upc'])) {
             // use reginput as UPC unless it's empty
             $this->upc = isset($_REQUEST['reginput']) ? $_REQUEST['reginput'] : '';
             if ($this->upc == '' && isset($_REQUEST['upc'])) {
                 $this->upc = $_REQUEST['upc'];
             }
             $this->upc = str_pad($this->upc, 13, '0', STR_PAD_LEFT);
             $db = Database::pDataConnect();
             $query = "select inUse,upc,description,normal_price,scale,deposit,\n                qttyEnforced,department,local,cost,tax,foodstamp,discount,\n                discounttype,specialpricemethod,special_price,groupprice,\n                pricemethod,quantity,specialgroupprice,specialquantity,\n                mixmatchcode,idEnforced,tareweight,d.dept_name\n                from products, departments d where department = d.dept_no\n                AND upc = ?";
             $prep = $db->prepare($query);
             $result = $db->execute($prep, array($this->upc));
             $num_rows = $db->num_rows($result);
             // lookup item info
             if ($num_rows > 0) {
                 $this->found = true;
                 $row = $db->fetch_row($result);
                 $discounttype = MiscLib::nullwrap($row["discounttype"]);
                 $DiscountObject = null;
                 // see UPC parser for explanation
                 $DTClasses = CoreLocal::get("DiscountTypeClasses");
                 if ($row['discounttype'] < 64 && isset(DiscountType::$MAP[$row['discounttype']])) {
                     $class = DiscountType::$MAP[$row['discounttype']];
                     $DiscountObject = new $class();
                 } else {
                     if ($row['discounttype'] > 64 && isset($DTClasses[$row['discounttype'] - 64])) {
                         $class = $DTClasses[$row['discounttype'] - 64];
                         $DiscountObject = new $class();
                     } else {
                         // If the requested discounttype isn't available,
                         // fallback to normal pricing. Debatable whether
                         // this should be a hard error.
                         $DiscountObject = new NormalPricing();
                     }
                 }
                 if ($DiscountObject->isSale()) {
                     $this->pricing['sale'] = true;
                 }
                 $info = $DiscountObject->priceInfo($row, 1);
                 $this->pricing['actual_price'] = sprintf('$%.2f%s', $info['unitPrice'], $row['scale'] > 0 ? ' /lb' : '');
                 $this->pricing['regular_price'] = sprintf('$%.2f%s', $info['regPrice'], $row['scale'] > 0 ? ' /lb' : '');
                 if ($info['memDiscount'] > 0) {
                     $this->pricing['memPrice'] = sprintf('$%.2f%s', $info['unitPrice'] - $info['memDiscount'], $row['scale'] > 0 ? ' /lb' : '');
                 }
                 $this->pricing['description'] = $row['description'];
                 $this->pricing['department'] = $row['dept_name'];
                 MiscLib::goodBeep();
             }
             // user hit enter and there is a valid UPC present
             if (isset($_REQUEST['reginput']) && $_REQUEST['reginput'] == '' && $this->found) {
                 CoreLocal::set("msgrepeat", 1);
                 CoreLocal::set("strRemembered", $this->upc);
                 $this->change_page($this->page_url . "gui-modules/pos2.php");
                 return false;
             }
         }
     }
     return true;
 }

 /**
   Void the given UPC
   @param $upc [string] upc to void. Optionally including quantity and asterisk
   @param $item_num [int] trans_id of record to void. Optional.
   @param $json parser return value structure
 */
 public function voidupc($upc, $json, $item_num = -1)
 {
     $lastpageflag = 1;
     $deliflag = false;
     $quantity = 0;
     /**
       If UPC contains an asterisk, extract quantity
       and validate input. Otherwise use quantity 1.
     */
     if (strstr($upc, '*')) {
         list($quantity, $upc) = explode('*', $upc, 2);
         if ($quantity === '' || $upc === '' || !is_numeric($quantity) || !is_numeric($upc)) {
             $json['output'] = DisplayLib::inputUnknown();
             return $json;
         } else {
             $weight = 0;
         }
     } else {
         $quantity = 1;
         $weight = CoreLocal::get("weight");
     }
     $scaleprice = 0;
     if (is_numeric($upc)) {
         $upc = substr("0000000000000" . $upc, -13);
         if (substr($upc, 0, 3) == "002" && substr($upc, -5) != "00000") {
             $scaleprice = substr($upc, 10, 4) / 100;
             $upc = substr($upc, 0, 8) . "0000";
             $deliflag = true;
         } else {
             if (substr($upc, 0, 3) == "002" && substr($upc, -5) == "00000") {
                 $scaleprice = $this->scaleprice;
                 $deliflag = true;
             }
         }
     }
     $db = Database::tDataConnect();
     $query = "SELECT SUM(ItemQtty) AS voidable, \n                    SUM(quantity) AS vquantity,\n                    MAX(scale) AS scale,\n                    MAX(volDiscType) AS volDiscType \n                  FROM localtemptrans \n                  WHERE upc = '" . $upc . "'";
     if ($deliflag) {
         $query .= ' AND unitPrice = ' . $scaleprice;
     }
     $query .= ' GROUP BY upc';
     $result = $db->query($query);
     $num_rows = $db->num_rows($result);
     if ($num_rows == 0) {
         $json['output'] = DisplayLib::boxMsg(_("Item not found: ") . $upc, '', false, DisplayLib::standardClearButton());
         return $json;
     }
     $row = $db->fetch_array($result);
     if ($row["scale"] == 1 && $weight > 0) {
         $quantity = $weight - CoreLocal::get("tare");
         CoreLocal::set("tare", 0);
     }
     $volDiscType = $row["volDiscType"];
     $voidable = MiscLib::nullwrap($row["voidable"]);
     $VolSpecial = 0;
     $volume = 0;
     $scale = MiscLib::nullwrap($row["scale"]);
     if ($voidable == 0 && $quantity == 1) {
         $json['output'] = DisplayLib::boxMsg(_("Item already voided"), '', false, DisplayLib::standardClearButton());
         return $json;
     } elseif ($voidable == 0 && $quantity > 1) {
         $json['output'] = DisplayLib::boxMsg(_("Items already voided"), '', false, DisplayLib::standardClearButton());
         return $json;
     } elseif ($scale == 1 && $quantity < 0) {
         $json['output'] = DisplayLib::boxMsg(_("tare weight cannot be greater than item weight"), '', false, DisplayLib::standardClearButton());
         return $json;
     } elseif ($voidable < $quantity && $row["scale"] == 1) {
         $message = _("Void request exceeds") . "<br />" . _("weight of item rung in") . "<p><b>" . sprintf(_("You can void up to %.2f lb"), $row['voidable']) . "</b>";
         $json['output'] = DisplayLib::boxMsg($message, '', false, DisplayLib::standardClearButton());
         return $json;
     } elseif ($voidable < $quantity) {
         $message = _("Void request exceeds") . "<br />" . _("number of items rung in") . "<p><b>" . sprintf(_("You can void up to %d"), $row['voidable']) . "</b>";
         $json['output'] = DisplayLib::boxMsg($message, '', false, DisplayLib::standardClearButton());
         return $json;
     }
     //----------------------Void Item------------------
     $query_upc = "SELECT \n                        ItemQtty,\n                        foodstamp,\n                        discounttype,\n                        mixMatch,\n                        cost,\n                        numflag,\n                        charflag,\n                        unitPrice,\n                        total,\n                        discounttype,\n                        regPrice,\n                        discount,\n                        memDiscount,\n                        discountable,\n                        description,\n                        trans_type,\n                        trans_subtype,\n                        department,\n                        tax,\n                        VolSpecial,\n                        matched,\n                        scale,\n                        trans_id\n                      FROM localtemptrans \n                      WHERE upc = '" . $upc . "'";
     if ($deliflag) {
         $query_upc .= ' AND unitPrice = ' . $scaleprice;
     }
     if ($item_num != -1) {
         $query_upc .= ' AND trans_id = ' . $item_num;
     } else {
         $query_upc .= ' AND voided=0 ORDER BY total';
     }
     $result = $db->query($query_upc);
     $row = $db->fetch_array($result);
     $foodstamp = MiscLib::nullwrap($row["foodstamp"]);
     $discounttype = MiscLib::nullwrap($row["discounttype"]);
     $mixMatch = MiscLib::nullwrap($row["mixMatch"]);
     $matched = -1 * $row['matched'];
     $item_num = $row['trans_id'];
     $cost = $row['cost'];
     $numflag = $row['numflag'];
//.........这里部分代码省略.........

 /**
   Add an item to localtemptrans.
   Parameters correspond to columns in localtemptrans. See that table
   for valid types.
   @param $strupc localtemptrans.upc
   @param $strdescription localtemptrans.description
   @param $strtransType localtemptrans.trans_type
   @param $strtranssubType localtemptrans.trans_subtype
   @param $strtransstatuts localtemptrans.trans_status
   @param $dblquantity localtemptrans.quantity
   @param $dblunitPrice localtemptrans.unitPrice
   @param $dbltotal localtemptrans.total
   @param $dblregPrice localtemptrans.regPrice
   @param $intscale localtemptrans.scale
   @param $inttax localtemptrans.tax
   @param $intfoodstamp localtemptrans.foodstamp
   @param $dbldiscount localtemptrans.discount
   @param $dblmemDiscount localtemptrans.memDiscount
   @param $intdiscountable localtemptrans.discounttable
   @param $intdiscounttype localtemptrans.discounttype
   @param $dblItemQtty localtemptrans.ItemQtty
   @param $intvolDiscType localtemptrans.volDiscType
   @param $intvolume localtemptrans.volume
   @param $dblVolSpecial localtemptrans.VolSpecial
   @param $intmixMatch localtemptrans.mixMatch
   @param $intmatched localtemptrans.matched
   @param $intvoided localtemptrans.voided
   @param $cost localtemptrans.cost
   @param $numflag localtemptrans.numflag
   @param $charflag localtemptrans.charflag
 
   In many cases there is a simpler function that takes far
   fewer arguments and adds a specific type of record.
   All such functions should be in this file.
 */
 public static 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, $cost = 0, $numflag = 0, $charflag = '')
 {
     //$dbltotal = MiscLib::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, '.', '');
     // do not clear refund flag when adding an informational log record
     if ($strtransType != 'L' && CoreLocal::get("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
         }
         CoreLocal::set("refund", 0);
         CoreLocal::set("refundComment", "");
         CoreLocal::set("autoReprint", 1);
         if (CoreLocal::get("refundDiscountable") == 0) {
             $intdiscountable = 0;
         }
     }
     $intregisterno = CoreLocal::get("laneno");
     $intempno = CoreLocal::get("CashierNo");
     $inttransno = CoreLocal::get("transno");
     $strCardNo = CoreLocal::get("memberID");
     $memType = CoreLocal::get("memType");
     $staff = CoreLocal::get("isStaff");
     $percentDiscount = CoreLocal::get("percentDiscount");
     $db = Database::tDataConnect();
     $datetimestamp = "";
     if (CoreLocal::get("DBMS") == "mssql") {
         $datetimestamp = strftime("%m/%d/%y %H:%M:%S %p", time());
     } else {
         $datetimestamp = strftime("%Y-%m-%d %H:%M:%S", time());
     }
     CoreLocal::set("LastID", CoreLocal::get("LastID") + 1);
     $trans_id = CoreLocal::get("LastID");
     if (strlen($strdescription) > 30) {
         $strdescription = substr($strdescription, 0, 30);
     }
     $values = array('datetime' => $datetimestamp, 'register_no' => $intregisterno, 'emp_no' => $intempno, 'trans_no' => MiscLib::nullwrap($inttransno), 'upc' => MiscLib::nullwrap($strupc), 'description' => $strdescription, 'trans_type' => MiscLib::nullwrap($strtransType), 'trans_subtype' => MiscLib::nullwrap($strtranssubType, true), 'trans_status' => MiscLib::nullwrap($strtransstatus, true), 'department' => MiscLib::nullwrap($intdepartment), 'quantity' => MiscLib::nullwrap($dblquantity), 'cost' => MiscLib::nullwrap($cost), 'unitPrice' => MiscLib::nullwrap($dblunitPrice), 'total' => MiscLib::nullwrap($dbltotal), 'regPrice' => MiscLib::nullwrap($dblregPrice), 'scale' => MiscLib::nullwrap($intscale), 'tax' => MiscLib::nullwrap($inttax), 'foodstamp' => MiscLib::nullwrap($intfoodstamp), 'discount' => MiscLib::nullwrap($dbldiscount), 'memDiscount' => MiscLib::nullwrap($dblmemDiscount), 'discountable' => MiscLib::nullwrap($intdiscountable), 'discounttype' => MiscLib::nullwrap($intdiscounttype), 'ItemQtty' => MiscLib::nullwrap($dblItemQtty), 'volDiscType' => MiscLib::nullwrap($intvolDiscType), 'volume' => MiscLib::nullwrap($intvolume), 'VolSpecial' => MiscLib::nullwrap($dblVolSpecial), 'mixMatch' => MiscLib::nullwrap($intmixMatch), 'matched' => MiscLib::nullwrap($intmatched), 'voided' => MiscLib::nullwrap($intvoided), 'memType' => MiscLib::nullwrap($memType), 'staff' => MiscLib::nullwrap($staff), 'percentDiscount' => MiscLib::nullwrap($percentDiscount), 'numflag' => MiscLib::nullwrap($numflag), 'charflag' => $charflag, 'card_no' => (string) $strCardNo);
     if (CoreLocal::get("DBMS") == "mssql" && CoreLocal::get("store") == "wfc") {
         unset($values["staff"]);
         $values["isStaff"] = MiscLib::nullwrap($staff);
     }
     $db->smart_insert("localtemptrans", $values);
     if ($strtransType == "I" || $strtransType == "D") {
         CoreLocal::set("repeatable", 1);
     }
     CoreLocal::set("toggletax", 0);
     CoreLocal::set("togglefoodstamp", 0);
     CoreLocal::set("SNR", 0);
     if ($intscale == 1) {
         CoreLocal::set("lastWeight", $dblquantity);
     }
 }