'.__('You don\'t have enough privileges to access this area!').''); } require SIMBIO.'simbio_GUI/form_maker/simbio_form_element.inc.php'; require SIMBIO.'simbio_UTILS/simbio_date.inc.php'; // months array $months['01'] = __('Jan'); $months['02'] = __('Feb'); $months['03'] = __('Mar'); $months['04'] = __('Apr'); $months['05'] = __('May'); $months['06'] = __('Jun'); $months['07'] = __('Jul'); $months['08'] = __('Aug'); $months['09'] = __('Sep'); $months['10'] = __('Oct'); $months['11'] = __('Nov'); $months['12'] = __('Dec'); $page_title = 'Fines Report'; $reportView = false; if (isset($_GET['reportView'])) { $reportView = true; } if (!$reportView) { ?>
query("SELECT SUBSTRING(`fines_date`, -2) AS `mdate`, SUM(debet) AS `dtotal` FROM `fines` WHERE `fines_date` LIKE '$selected_year-$selected_month%' GROUP BY `fines_date`"); while ($_fines_d = $_fines_q->fetch_row()) { $date = (integer)preg_replace('@^0+@i', '',$_fines_d[0]); $fines_data[$date] = '