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