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(); }