'.__('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 = 'Visitor Report by Day'; $reportView = false; if (isset($_GET['reportView'])) { $reportView = true; } if (!$reportView) { ?>
query("SELECT SUBSTRING(`checkin_date`, 9, 2) AS `mdate`, COUNT(visitor_id) AS `vtotal` FROM `visitor_count` WHERE `checkin_date` LIKE '$selected_year-$selected_month%' GROUP BY DATE(`checkin_date`)"); while ($_visitor_d = $_visitor_q->fetch_row()) { $date = (integer)preg_replace('@^0+@i', '',$_visitor_d[0]); $visitor_data[$date] = '