public function fetch_report_data() { $dbc = $this->connection; $dbc->selectDB($this->config->get('TRANS_DB')); $prep = $dbc->prepare(' SELECT tdate, description, trans_num, total FROM voidTransHistory WHERE tdate BETWEEN ? AND ? ORDER BY tdate '); $res = $dbc->execute($prep, array($this->form->date1 . ' 00:00:00', $this->form->date2 . ' 23:59:59')); $data = array(); while ($row = $dbc->fetchRow($res)) { $original = substr($row['description'], 20); $data[] = array($row['tdate'], $row['trans_num'], $row['total'], \COREPOS\Fannie\API\lib\FannieUI::receiptLink($row['tdate'], $original)); } return $data; }