" frameborder="0" style="width: 100%; height: 500px;"></iframe> <?php } else { ob_start(); $fines_data = array(); // year $selected_year = date('Y'); if (isset($_GET['year']) and !empty($_GET['year'])) { $selected_year = (int) $_GET['year']; } // month $selected_month = date('m'); if (isset($_GET['month']) and !empty($_GET['month'])) { $selected_month = $_GET['month']; } // query fines data to database // echo "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`"; $_fines_q = $dbs->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 = (int) preg_replace('@^0+@i', '', $_fines_d[0]); $fines_data[$date] = '<div class="data">' . ($_fines_d[1] ? $_fines_d[1] : '0') . '</div>'; } // generate calendar $output = simbio_date::generateCalendar($selected_year, $selected_month, $fines_data); // print out echo '<div class="printPageInfo">Fines Count Report for <strong>' . $months[$selected_month] . ', ' . $selected_year . '</strong> <a class="printReport" onclick="window.print()" href="#">' . __('Print Current Page') . '</a></div>' . "\n"; echo $output; $content = ob_get_clean(); // include the page template require SB . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php'; }
?> " frameborder="0" style="width: 100%; height: 500px;"></iframe> <?php } else { ob_start(); $visitor_data = array(); // year $selected_year = date('Y'); if (isset($_GET['year']) and !empty($_GET['year'])) { $selected_year = (int) $_GET['year']; } // month $selected_month = date('m'); if (isset($_GET['month']) and !empty($_GET['month'])) { $selected_month = $_GET['month']; } // query visitor data to database $_visitor_q = $dbs->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 = (int) preg_replace('@^0+@i', '', $_visitor_d[0]); $visitor_data[$date] = '<div class="data">' . ($_visitor_d[1] ? $_visitor_d[1] : '0') . '</div>'; } // generate calendar $output = simbio_date::generateCalendar($selected_year, $selected_month, $visitor_data); // print out echo '<div class="printPageInfo">Visitor Report for year <strong>' . $selected_year . '</strong> <a class="printReport" onclick="window.print()" href="#">[' . __('Print Current Page') . ']</a></div>' . "\n"; echo $output; $content = ob_get_clean(); // include the page template require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php'; }