Exemplo n.º 1
0
     if (is_null($other)) {
         $other = 0;
     }
     $net = $gross + $hash + $totalDisc + $coupons + $strchg + $RA + $pt_total + $other;
     // sales of inventory departments
     $invtotalsQ = "SELECT d.department,t.dept_name,ROUND(sum(d.total),2) AS total,ROUND((SUM(d.total)/{$gross})*100,2) as pct\n\t\t\tFROM " . DB_LOGNAME . ".{$table} AS d, " . DB_NAME . ".departments AS t\n\t\t\tWHERE d.department = t.dept_no\n\t\t\tAND date(d.datetime) >= '{$date1}' AND date(d.datetime) <= '{$date2}' \n\t\t\tAND d.department <= 15 AND d.department <> 0\n\t\t\tAND d.trans_subtype NOT IN('IC','MC', 'CP')\n\t\t\tAND d.trans_status <> 'X'\n\t\t\tAND d.emp_no <> 9999\n\t\t\tGROUP BY d.department, t.dept_name";
     //		$gross = 0;
     // Sales for non-inventory departments
     $noninvtotalsQ = "SELECT d.department,t.dept_name,ROUND(sum(total),2) as total, count(d.datetime) AS count\n\t\t\tFROM " . DB_LOGNAME . ".{$table} as d join " . DB_NAME . ".departments as t ON d.department = t.dept_no\n\t\t\tWHERE datetime >= '{$date1a}' AND datetime <= '{$date2a}' \n\t\t\tAND d.department > 35 AND d.department <> 0\n\t\t\tAND d.trans_status <> 'X'\n\t\t\tAND d.emp_no <> 9999\n\t\t\tGROUP BY d.department, t.dept_name";
     echo "<h2>Income / Expenses</h2>\n\n\t\t\t<table border=0>\n<tr><td><b>sales (gross) total</b></td><td align=right><b>" . money_format('%n', $gross) . "</b></td></tr>\n\n\t\t\t<tr><td>hash total</td><td align=right>" . money_format('%n', $hash) . "</td></tr>\n\n\t\t\t<tr><td>totalDisc</td><td align=right>" . money_format('%n', $totalDisc) . "</td></tr>\n\n\t\t\t<tr><td>coupon & gift cert. tenders</td><td align=right>" . money_format('%n', $coupons) . "</td></tr>\n\n\t\t\t<tr><td>store charges</td><td align=right>" . money_format('%n', $strchg) . "</td></tr>\n\n\t\t\t<tr><td>patronage refunds</td><td align=right>" . money_format('%n', $pt_total) . "</td></tr>\n\n\t\t\t<tr><td>rcvd/accts</td><td align=right>" . money_format('%n', $RA) . "</td></tr>\n\n\t\t\t<tr><td>mkt EBT & chg pmts</td><td align=right>" . money_format('%n', $other) . "</td></tr>\n\n\t\t\t<tr><td>&nbsp;</td><td align=right>+___________</td></tr>\n\n\t\t\t<tr><b><td><b>net total</b></td><td align=right><b>" . money_format('%n', $net) . "</b></td></b></tr>\n\n\t\t\t</table>\n";
     echo '</b></td></tr></table><h4>Inventory Department Totals</h4>';
     echo '<p>';
     select_to_table($invtotalsQ, 1, 'FFFFFF');
     deptTotals('Grocery', $gross, $table, $date1, $date2, '2,3,6,7,8,9', '');
     deptTotals('Produce', $gross, $table, $date1, $date2, '1,14,15', '');
     deptTotals('Nonfoods', $gross, $table, $date1, $date2, '4,5,10', '');
     echo '</p>';
     echo '<h4>Non-Inventory Department Totals</h4>';
     select_to_table($noninvtotalsQ, 1, 'FFFFFF');
 }
 if (isset($tender)) {
     if ($gross == 0 || !$gross) {
         $gross = 1;
     }
     $tendertotalsQ = "SELECT t.TenderName as tender_type,ROUND(-sum(d.total),2) as total,ROUND((-SUM(d.total)/{$gross})*100,2) as pct\n\t\t\tFROM " . DB_LOGNAME . ".{$table} as d ," . DB_NAME . ".tenders as t \n\t\t\tWHERE d.datetime >= '{$date1a}' AND d.datetime <= '{$date2a}'\n\t\t\tAND d.trans_status <> 'X' \n\t\t\tAND d.emp_no <> 9999\n\t\t\tAND d.trans_subtype = t.TenderCode\n\t\t\tGROUP BY t.TenderName";
     // $gross = 0;
     $transcountQ = "SELECT COUNT(d.total) as transactionCount\n\t\t\tFROM " . DB_LOGNAME . ".{$table} AS d\n\t\t\tWHERE d.datetime >= '{$date1a}' AND d.datetime <= '{$date2a}'\n\t\t\tAND d.upc = 'DISCOUNT'\n\t\t\tAND d.trans_status <> 'X'\n\t\t\tAND d.emp_no <> 9999";
     $transcountR = mysql_query($transcountQ);
     $row = mysql_fetch_row($transcountR);
     $count = $row[0];
     $basketsizeQ = "SELECT ROUND(({$gross}/{$count}),2) AS basket_size";
Exemplo n.º 2
0
include 'net.php';
echo "<table border=0><tr><td><b>sales (gross) total</b></td><td align=right><b>" . money_format('%n', $gross) . "</b></td></tr>";
echo "<tr><td>non-inv total</td><td align=right>" . money_format('%n', $hash) . "</td></tr>";
echo "<tr><td>totalDisc</td><td align=right>" . money_format('%n', $totalDisc) . "</td></tr>";
echo "<tr><td>coupon & gift cert. tenders</td><td align=right>" . money_format('%n', $coupons) . "</td></tr>";
echo "<tr><td>store charges</td><td align=right>" . money_format('%n', $strchg) . "</td></tr>";
echo "<tr><td>rcvd/accts</td><td align=right>" . money_format('%n', $RA) . "</td></tr>";
//echo "<tr><td>mkt EBT & chg pmts</td><td align=right>".money_format('%n',$other)."</td></tr>";
echo "<tr><td>&nbsp;</td><td align=right>+___________</td></tr>";
echo "<tr><b><td>net total</td><td align=right>" . money_format('%n', $net) . "</td></b></tr>";
echo '------------------------------<br>';
echo '<h2>Sales by Inventory Dept.</h2>';
select_to_table($inventoryDeptQ, 0, $bgcolor);
deptTotals('Grocery', $gross, $table, $db_date, $db_date, '2,3,6,7,8,9', $bgcolor);
deptTotals('Produce', $gross, $table, $db_date, $db_date, '1,14,15', $bgcolor);
deptTotals('Nonfoods', $gross, $table, $db_date, $db_date, '4,5,10', $bgcolor);
echo '<br />';
echo '<h2>Sales by Non-Inventory Dept.</h2>';
select_to_table($noninventoryDeptQ, 0, $bgcolor);
echo '------------------------------<br>';
echo '<h2>Tender Report</h2>';
select_to_table($tendersQ, 0, $bgcolor);
// sales by tender type
echo "<h2>Instore Coupon Breakdown</h2>";
select_to_table($instoreQ, 0, $bgcolor);
// instore coupon breakdown
echo "<h2>Customer Services Breakdown</h2>";
select_to_table($custSvcQ, 0, $bgcolor);
// customer svc breakdown
echo "<h2>Store Charge Breakdown</h2>";
select_to_table($storeChargeQ, 0, $bgcolor);