array(WfcLib::ALIGN_LEFT,WfcLib::ALIGN_RIGHT|WfcLib::TYPE_MONEY,WfcLib::ALIGN_RIGHT),1);
*/
echo '<br /><a href="../../../Paycards/PcDailyReport.php?date=' . $dstr . '">Integrated CC Supplement</a><br />';
$couponQ = "\n SELECT SUM(-d.total) AS ttl,\n COUNT(d.total) AS num,\n CASE WHEN d.upc='PATREBDISC' THEN 'Rebate Check Discount' ELSE d.description END as name\n FROM {$dlog} AS d\n WHERE trans_type='T'\n AND trans_subtype='IC'\n AND d.tdate BETWEEN ? AND ?\n AND " . DTrans::isStoreID($store, 'd') . "\n GROUP BY\n CASE WHEN d.upc='PATREBDISC' THEN 'Rebate Check Discount' ELSE d.description END\n ORDER BY\n CASE WHEN d.upc='PATREBDISC' THEN 'Rebate Check Discount' ELSE d.description END";
$couponP = $dbc->prepare($couponQ);
$couponR = $dbc->execute($couponP, $store_dates);
$coupons = array();
echo '<br /><b>InStore Coupon Supplement</b>';
while ($couponsW = $dbc->fetch_row($couponR)) {
$coupons[$couponsW['name']] = array($couponsW['ttl'], $couponsW['num']);
}
echo WfcLib::tablify($coupons, array(0, 1, 2), array('Name', 'Amount', 'Count'), array(WfcLib::ALIGN_LEFT, WfcLib::ALIGN_RIGHT | WfcLib::TYPE_MONEY, WfcLib::ALIGN_RIGHT), 1);
}
$pCodeQ = $dbc->prepare_statement("SELECT s.salesCode,-1*sum(l.total) as total,min(l.department) \nFROM {$dlog} as l \nINNER JOIN {$OP_DB}departments AS s ON l.department=s.dept_no\nWHERE l.tdate BETWEEN ? AND ?\nAND l.department < 600 AND l.department <> 0\nAND l.trans_type <>'T'\nAND " . DTrans::isStoreID($store, 'l') . "\nGROUP BY s.salesCode\norder by s.salesCode");
$pCodeR = $dbc->exec_statement($pCodeQ, $store_dates);
$pCodes = WfcLib::getPCodes();
while ($row = $dbc->fetch_row($pCodeR)) {
if (isset($pCodes[$row[0]])) {
$pCodes[$row[0]][0] = $row[1];
}
}
echo "<br /><b>Sales</b>";
echo WfcLib::tablify($pCodes, array(0, 1), array("pCode", "Sales"), array(WfcLib::ALIGN_LEFT, WfcLib::ALIGN_RIGHT | WfcLib::TYPE_MONEY), 1);
$saleSumQ = $dbc->prepare_statement("SELECT -1*sum(l.total) as totalSales\nFROM {$dlog} as l\nWHERE l.tdate BETWEEN ? AND ?\nAND l.department < 600 AND l.department <> 0\nAND " . DTrans::isStoreID($store, 'l') . "\nAND l.trans_type <> 'T'");
$saleSumR = $dbc->exec_statement($saleSumQ, $store_dates);
echo "<br /><b><u>Total Sales</u></b><br />";
echo sprintf("%.2f<br />", array_pop($dbc->fetch_row($saleSumR)));
$returnsQ = $dbc->prepare_statement("SELECT s.salesCode,-1*sum(L.total)as returns\nFROM {$dlog} as L,departments as s\nWHERE s.dept_no = L.department\nAND L.tdate BETWEEN ? AND ?\nAND(trans_status = 'R')\nAND " . DTrans::isStoreID($store, 'L') . "\nGROUP BY s.salesCode");
$returnsR = $dbc->exec_statement($returnsQ, $store_dates);
$returns = array();
while ($row = $dbc->fetch_row($returnsR)) {
