function addItem($row, $quantity, $priceObj)
{
if ($quantity == 0) {
return false;
}
$pricing = $priceObj->priceInfo($row, $quantity);
$department = $row['department'];
// enforce limit on discounting sale items
$dsi = CoreLocal::get('DiscountableSaleItems');
if ($dsi == 0 && $dsi !== '' && $priceObj->isSale()) {
$row['discount'] = 0;
}
$mixMatch = $row['mixmatchcode'];
/* group definition: number of items
that make up a group, price for a
full set. Use "special" rows if the
item is on sale */
$groupQty = $row['quantity'];
$groupPrice = $row['groupprice'];
if ($priceObj->isSale()) {
$groupQty = $row['specialquantity'];
$groupPrice = $row['specialgroupprice'];
}
/* not straight-up interchangable
* ex: buy item A, get $1 off item B
* need strict pairs AB
*
* type 3 tries to split the discount amount
* across A & B's departments; type 4
* does not
*/
$qualMM = abs($mixMatch);
$discMM = -1 * abs($mixMatch);
$dbt = Database::tDataConnect();
// lookup existing qualifiers (i.e., item As)
// by-weight items are rounded down here
$q1 = "SELECT floor(sum(ItemQtty)),max(department) \n FROM localtemptrans WHERE mixMatch='{$qualMM}' \n and trans_status <> 'R'";
$r1 = $dbt->query($q1);
$quals = 0;
$dept1 = 0;
if ($dbt->num_rows($r1) > 0) {
$rowq = $dbt->fetch_row($r1);
$quals = round($rowq[0]);
$dept1 = $rowq[1];
}
// lookup existing discounters (i.e., item Bs)
// by-weight items are counted per-line here
//
// extra checks to make sure the maximum
// discount on scale items is "free"
$q2 = "SELECT sum(CASE WHEN scale=0 THEN ItemQtty ELSE 1 END),\n max(department),max(scale),max(total) FROM localtemptrans \n WHERE mixMatch='{$discMM}' \n and trans_status <> 'R'";
$r2 = $dbt->query($q2);
$dept2 = 0;
$discs = 0;
$discountIsScale = false;
$scaleDiscMax = 0;
if ($dbt->num_rows($r2) > 0) {
$rowd = $dbt->fetch_row($r2);
$discs = round($rowd[0]);
$dept2 = $rowd[1];
if ($rowd[2] == 1) {
$discountIsScale = true;
}
$scaleDiscMax = $rowd[3];
}
if ($quantity != (int) $quantity && $mixMatch < 0) {
$discountIsScale = true;
$scaleDiscMax = $quantity * $unitPrice;
}
// items that have already been used in an AB set
$q3 = "SELECT sum(matched) FROM localtemptrans WHERE\n mixmatch IN ('{$qualMM}','{$discMM}')";
$r3 = $dbt->query($q3);
$matches = 0;
if ($r3 && $dbt->num_rows($r3) > 0) {
$w3 = $dbt->fetch_row($r3);
$matches = $w3[0];
}
// reduce totals by existing matches
// implicit: quantity required for B = 1
// i.e., buy X item A save on 1 item B
$matches = $matches / $groupQty;
$quals -= $matches * ($groupQty - 1);
$discs -= $matches;
// where does the currently scanned item go?
if ($mixMatch > 0) {
$quals = $quals > 0 ? $quals + floor($quantity) : floor($quantity);
$dept1 = $department;
} else {
// again, scaled items count once per line
if ($quantity != (int) $quantity) {
$discs = $discs > 0 ? $discs + 1 : 1;
} else {
$discs = $discs > 0 ? $discs + $quantity : $quantity;
}
$dept2 = $department;
}
// count up complete sets
$sets = 0;
while ($discs > 0 && $quals >= $groupQty - 1) {
$discs -= 1;
$quals -= $groupQty - 1;
$sets++;
}
if ($sets > 0) {
$maxDiscount = $sets * $groupPrice;
if ($scaleDiscMax != 0 && $maxDiscount > $scaleDiscMax) {
$maxDiscount = $scaleDiscMax;
}
// if the current item is by-weight, quantity
// decrement has to be corrected, but matches
// should still be an integer
$ttlMatches = $sets;
if ($quantity != (int) $quantity) {
$sets = $quantity;
}
$quantity = $quantity - $sets;
TransRecord::addRecord(array('upc' => $row['upc'], 'description' => $row['description'], 'trans_type' => 'I', 'trans_subtype' => isset($row['trans_subtype']) ? $row['trans_subtype'] : '', 'department' => $row['department'], 'quantity' => $sets, 'unitPrice' => $pricing['unitPrice'], 'total' => MiscLib::truncate2($sets * $pricing['unitPrice']), 'regPrice' => $pricing['regPrice'], 'scale' => $row['scale'], 'tax' => $row['tax'], 'foodstamp' => $row['foodstamp'], 'memDiscount' => $priceObj->isMemberSale() || $priceObj->isStaffSale() ? MiscLib::truncate2($maxDiscount) : 0, 'discountable' => $row['discount'], 'discounttype' => $row['discounttype'], 'ItemQtty' => $sets, 'volDiscType' => $priceObj->isSale() ? $row['specialpricemethod'] : $row['pricemethod'], 'volume' => $priceObj->isSale() ? $row['specialquantity'] : $row['quantity'], 'VolSpecial' => $priceObj->isSale() ? $row['specialgroupprice'] : $row['groupprice'], 'mixMatch' => $row['mixmatchcode'], 'matched' => $ttlMatches * $groupQty, 'cost' => isset($row['cost']) ? $row['cost'] * $sets * $groupQty : 0.0, 'numflag' => isset($row['numflag']) ? $row['numflag'] : 0, 'charflag' => isset($row['charflag']) ? $row['charflag'] : ''));
if (!$priceObj->isMemberSale() && !$priceObj->isStaffSale()) {
TransRecord::additemdiscount($dept1, MiscLib::truncate2($maxDiscount / 2.0));
TransRecord::additemdiscount($dept2, MiscLib::truncate2($maxDiscount / 2.0));
}
}
/* any remaining quantity added without
grouping discount */
if ($quantity > 0) {
TransRecord::addRecord(array('upc' => $row['upc'], 'description' => $row['description'], 'trans_type' => 'I', 'trans_subtype' => isset($row['trans_subtype']) ? $row['trans_subtype'] : '', 'department' => $row['department'], 'quantity' => $quantity, 'unitPrice' => $pricing['unitPrice'], 'total' => MiscLib::truncate2($pricing['unitPrice'] * $quantity), 'regPrice' => $pricing['regPrice'], 'scale' => $row['scale'], 'tax' => $row['tax'], 'foodstamp' => $row['foodstamp'], 'discountable' => $row['discount'], 'discounttype' => $row['discounttype'], 'ItemQtty' => $quantity, 'volDiscType' => $priceObj->isSale() ? $row['specialpricemethod'] : $row['pricemethod'], 'volume' => $priceObj->isSale() ? $row['specialquantity'] : $row['quantity'], 'VolSpecial' => $priceObj->isSale() ? $row['specialgroupprice'] : $row['groupprice'], 'mixMatch' => $row['mixmatchcode'], 'cost' => isset($row['cost']) ? $row['cost'] * $quantity : 0.0, 'numflag' => isset($row['numflag']) ? $row['numflag'] : 0, 'charflag' => isset($row['charflag']) ? $row['charflag'] : ''));
}
return True;
}
public function testTransRecord()
{
if (!class_exists('lttLib')) {
include 'lttLib.php';
}
lttLib::clear();
CoreLocal::set('infoRecordQueue', array());
TransRecord::addQueued('1234567890123', 'UNIT TEST', 1, 'UT', 1.99);
$queue = CoreLocal::get('infoRecordQueue');
$this->assertInternalType('array', $queue);
$this->assertEquals(1, count($queue));
$this->assertArrayHasKey(0, $queue);
$this->assertInternalType('array', $queue[0]);
$this->assertArrayHasKey('upc', $queue[0]);
$this->assertEquals('1234567890123', $queue[0]['upc']);
$this->assertArrayHasKey('description', $queue[0]);
$this->assertEquals('UNIT TEST', $queue[0]['description']);
$this->assertArrayHasKey('numflag', $queue[0]);
$this->assertEquals(1, $queue[0]['numflag']);
$this->assertArrayHasKey('charflag', $queue[0]);
$this->assertEquals('UT', $queue[0]['charflag']);
$this->assertArrayHasKey('regPrice', $queue[0]);
$this->assertEquals(1.99, $queue[0]['regPrice']);
TransRecord::emptyQueue();
$queue = CoreLocal::get('infoRecordQueue');
$this->assertInternalType('array', $queue);
$this->assertEquals(0, count($queue));
$record = lttLib::genericRecord();
$record['upc'] = '1234567890123';
$record['description'] = 'UNIT TEST';
$record['numflag'] = 1;
$record['charflag'] = 'UT';
$record['regPrice'] = 1.99;
$record['trans_type'] = 'C';
$record['trans_status'] = 'D';
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
CoreLocal::set('taxTotal', 1.23);
TransRecord::addtax();
$record = lttLib::genericRecord();
$record['upc'] = 'TAX';
$record['description'] = 'Tax';
$record['trans_type'] = 'A';
$record['total'] = 1.23;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addtender('UT TENDER', 'UT', 2.34);
$record = lttLib::genericRecord();
$record['description'] = 'UT TENDER';
$record['trans_type'] = 'T';
$record['trans_subtype'] = 'UT';
$record['total'] = 2.34;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addcomment('UNIT TEST COMMENT');
$record = lttLib::genericRecord();
$record['description'] = 'UNIT TEST COMMENT';
$record['trans_type'] = 'C';
$record['trans_subtype'] = 'CM';
$record['trans_status'] = 'D';
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addchange(3.14, 'UT');
$record = lttLib::genericRecord();
$record['description'] = 'Change';
$record['trans_type'] = 'T';
$record['trans_subtype'] = 'UT';
$record['total'] = 3.14;
$record['voided'] = 8;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addfsones(3);
$record = lttLib::genericRecord();
$record['description'] = 'FS Change';
$record['trans_type'] = 'T';
$record['trans_subtype'] = 'FS';
$record['total'] = 3;
$record['voided'] = 8;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::adddiscount(5.45, 25);
$record = lttLib::genericRecord();
$record['description'] = '** YOU SAVED $5.45 **';
$record['trans_type'] = 'I';
$record['trans_status'] = 'D';
$record['department'] = 25;
$record['voided'] = 2;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addfsTaxExempt();
$record = lttLib::genericRecord();
$record['upc'] = 'FS Tax Exempt';
$record['description'] = ' Fs Tax Exempt ';
$record['trans_type'] = 'C';
$record['trans_status'] = 'D';
$record['voided'] = 17;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::discountnotify(5);
$record = lttLib::genericRecord();
$record['description'] = '** 5% Discount Applied **';
$record['trans_status'] = 'D';
$record['voided'] = 4;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addTaxExempt();
$record = lttLib::genericRecord();
$record['description'] = '** Order is Tax Exempt **';
$record['trans_status'] = 'D';
$record['voided'] = 10;
$record['tax'] = 9;
lttLib::verifyRecord(1, $record, $this);
$this->assertEquals(1, CoreLocal::get('TaxExempt'));
lttLib::clear();
TransRecord::reverseTaxExempt();
$record = lttLib::genericRecord();
$record['description'] = '** Tax Exemption Reversed **';
$record['trans_status'] = 'D';
$record['voided'] = 10;
$record['tax'] = 9;
lttLib::verifyRecord(1, $record, $this);
$this->assertEquals(0, CoreLocal::get('TaxExempt'));
lttLib::clear();
CoreLocal::set('casediscount', 7);
TransRecord::addcdnotify();
$record = lttLib::genericRecord();
$record['description'] = '** 7% Case Discount Applied';
$record['trans_status'] = 'D';
$record['voided'] = 6;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addCoupon('0051234512345', 123, -1.23, 1);
$record = lttLib::genericRecord();
$record['upc'] = '0051234512345';
$record['description'] = ' * Manufacturers Coupon';
$record['trans_type'] = 'I';
$record['trans_subtype'] = 'CP';
$record['trans_status'] = 'C';
$record['department'] = 123;
$record['unitPrice'] = -1.23;
$record['total'] = -1.23;
$record['regPrice'] = -1.23;
$record['foodstamp'] = 1;
$record['quantity'] = 1;
$record['ItemQtty'] = 1;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addhousecoupon('0049999912345', 122, -1.22);
$record = lttLib::genericRecord();
$record['upc'] = '0049999912345';
$record['description'] = ' * Store Coupon';
$record['trans_type'] = 'I';
$record['trans_subtype'] = 'IC';
$record['trans_status'] = 'C';
$record['department'] = 122;
$record['unitPrice'] = -1.22;
$record['total'] = -1.22;
$record['regPrice'] = -1.22;
$record['quantity'] = 1;
$record['ItemQtty'] = 1;
$record['discountable'] = 1;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::additemdiscount(345, 3.45);
$record = lttLib::genericRecord();
$record['upc'] = 'ITEMDISCOUNT';
$record['description'] = ' * Item Discount';
$record['trans_type'] = 'I';
$record['department'] = 345;
$record['unitPrice'] = -3.45;
$record['total'] = -3.45;
$record['regPrice'] = -3.45;
$record['quantity'] = 1;
$record['ItemQtty'] = 1;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addtare(5);
$record = lttLib::genericRecord();
$record['description'] = '** Tare Weight 0.05 **';
$record['trans_status'] = 'D';
$record['voided'] = 6;
lttLib::verifyRecord(1, $record, $this);
$this->assertEquals(0.05, CoreLocal::get('tare'));
lttLib::clear();
CoreLocal::set('transDiscount', 3.24);
TransRecord::addTransDiscount();
$record = lttLib::genericRecord();
$record['upc'] = 'DISCOUNT';
$record['description'] = 'Discount';
$record['trans_type'] = 'S';
$record['quantity'] = 1;
$record['ItemQtty'] = 1;
$record['unitPrice'] = -3.24;
$record['total'] = -3.24;
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
TransRecord::addCashDrop('90.78');
$record = lttLib::genericRecord();
$record['upc'] = 'DROP';
$record['description'] = 'Cash Drop';
$record['trans_type'] = 'I';
$record['trans_status'] = 'X';
$record['quantity'] = 1;
$record['ItemQtty'] = 1;
$record['unitPrice'] = -90.78;
$record['total'] = -90.78;
$record['charflag'] = 'CD';
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
$record = lttLib::genericRecord();
$record['upc'] = 'UNITTEST';
$record['description'] = 'Unit Test';
$record['department'] = 5;
$record['numflag'] = 4;
$record['charflag'] = 'UT';
$record['amount1'] = 1.23;
$record['total'] = 1.23;
$record['amount2'] = 1.24;
$record['regPrice'] = 1.24;
TransRecord::add_log_record($record);
unset($record['amount1']);
// not real column
unset($record['amount2']);
// not real column
$record['trans_type'] = 'L';
$record['trans_subtype'] = 'OG';
$record['trans_status'] = 'D';
lttLib::verifyRecord(1, $record, $this);
lttLib::clear();
}
