fannie/reports/Store-Specific/WFC/RebateChecks/index.php
<?php
include('../../../../config.php');
include(__DIR__ . '/../../../../classlib2.0/FannieAPI.php');
$dbc = FannieDB::get($FANNIE_OP_DB);
$q = $dbc->prepare("select year(tdate),month(tdate),day(tdate),count(*) From is4c_trans.dlog_90_view as d
left join custdata as c ON d.card_no=c.CardNo and c.personNum=1
where upc='DISCOUNT' and total <> 0 and c.Discount=0
and tdate > '2012-11-29 00:00:00'
AND c.Type in ('PC','REG')
group by year(tdate),month(tdate),day(tdate)
order by year(tdate),month(tdate),day(tdate)");
$r = $dbc->execute($q);
echo '<h3>Rebate Checks</h3>';
echo '<table cellspacing="0" cellpadding="4" border="1">';
$sum = 0;
while ($w = $dbc->fetch_row($r)){
printf('<tr><td>%d/%d/%d</td><td>%d</td></tr>',
$w[1],$w[2],$w[0],$w[3]);
$sum += $w[3];
}
echo '<tr><th>Total</th><td>'.$sum.'</td></tr>';
echo '</table>';
$q = $dbc->prepare("select year(tdate),month(tdate),day(tdate),sum(quantity) From is4c_trans.dlog_90_view as d
where upc='0049999900021'
and tdate > '2012-11-29 00:00:00'
group by year(tdate),month(tdate),day(tdate)
order by year(tdate),month(tdate),day(tdate)");
$r = $dbc->execute($q);
echo '<h3>Rebate Coupons</h3>';
echo '<table cellspacing="0" cellpadding="4" border="1">';
$sum = 0;
while ($w = $dbc->fetch_row($r)){
printf('<tr><td>%d/%d/%d</td><td>%d</td></tr>',
$w[1],$w[2],$w[0],$w[3]);
$sum += $w[3];
}
echo '<tr><th>Total</th><td>'.$sum.'</td></tr>';
echo '</table>';