public function fetch_report_data()
{
$date1 = $this->form->date1;
$date2 = $this->form->date2;
$dlog = DTransactionsModel::selectDlog($date1, $date2);
$dbc = $this->connection;
$dbc->selectDB($this->config->get('OP_DB'));
$m = new MasterSuperDeptsModel($dbc);
$m->superID(0);
$dept_list = '?,';
$args = array(0);
foreach ($m->find() as $obj) {
$dept_list .= '?,';
$args[] = $obj->dept_ID();
}
$dept_list = substr($dept_list, 0, strlen($dept_list) - 1);
$prep = $dbc->prepare('
SELECT SUM(d.total) AS ttl
FROM ' . $dlog . ' AS d
WHERE d.department NOT IN (' . $dept_list . ')
AND d.trans_type IN (\'I\',\'D\')
AND d.tdate BETWEEN ? AND ?');
$start = strtotime($date1);
$end = strtotime($date2);
$data = array();
$i = 0;
while ($start <= $end) {
$d1 = date('Y-m-d 00:00:00', $start);
$d2 = date('Y-m-d 23:59:59', mktime(0, 0, 0, date('n', $start), date('j', $start) + 6, date('Y', $start)));
$record = array(date('Y-m-d', strtotime($d1)) . ' to ' . date('Y-m-d', strtotime($d2)));
$week_args = array_merge($args, array($d1, $d2));
$result = $dbc->execute($prep, $week_args);
$row = $dbc->fetch_row($result);
$record[] = sprintf('%.2f', $row['ttl']);
$data[] = $record;
$start = mktime(0, 0, 0, date('n', $start), date('j', $start) + 7, date('Y', $start));
}
return $data;
}
/**
overriding the basic form since I need several extra fields
*/
protected function basicForm()
{
global $FANNIE_URL;
$batchtypes = $this->get_batch_types();
$dbc = FannieDB::get($this->config->get('OP_DB'));
$owners = new MasterSuperDeptsModel($dbc);
ob_start();
?>
<form enctype="multipart/form-data" action="XlsBatchPage.php" id="FannieUploadForm" method="post">
<div class="row form-group form-horizontal">
<label class="col-sm-2 control-label">Type</label>
<div class="col-sm-4">
<select name="btype" class="form-control">
<?php
foreach ($batchtypes as $k => $v) {
printf("<option value=%d>%s</option>", $k, $v);
}
?>
</select>
</div>
<label class="col-sm-2 control-label">Start Date</label>
<div class="col-sm-4">
<input type="text" name="date1" id="date1" class="form-control date-field" />
</div>
</div>
<div class="row form-group form-horizontal">
<label class="col-sm-2 control-label">Name</label>
<div class="col-sm-4">
<input type="text" name="bname" class="form-control" />
</div>
<label class="col-sm-2 control-label">End Date</label>
<div class="col-sm-4">
<input type="text" name="date2" id="date2" class="form-control date-field" />
</div>
</div>
<div class="row form-group form-horizontal">
<label class="col-sm-2 control-label">File</label>
<div class="col-sm-4">
<input type="hidden" name="MAX_FILE_SIZE" value="2097152" />
<input type="file" id="FannieUploadFile" name="FannieUploadFile" />
</div>
<label class="col-sm-2 control-label">Owner</label>
<div class="col-sm-4">
<select name="bowner" class="form-control">
<option value="">Choose...</option>
<?php
$prev = '';
foreach ($owners->find('super_name') as $obj) {
if ($obj->super_name() == $prev) {
continue;
}
echo '<option>' . $obj->super_name() . '</option>';
$prev = $obj->super_name();
}
?>
</select>
</div>
</div>
<div class="row form-group form-horizontal">
<label class="col-sm-2 control-label">Type</label>
<div class="col-sm-4">
<select name="ftype" class="form-control">
<option>UPCs</option>
<option>Likecodes</option>
</select>
</div>
<div class="col-sm-2">
<button type="submit" class="btn btn-default">Upload File</button>
</div>
</div>
</form>
<?php
return ob_get_clean();
}
