/** * renders available signups data in calendar view * * @return void */ public function renderCalendar() { $curyear = curyear(); $query = "SELECT * from `sigreq` WHERE `date` LIKE '" . $curyear . "-%' ORDER BY `date` ASC"; $all = simple_queryall($query); $result = ''; $calendarData = ''; if (!empty($all)) { foreach ($all as $io => $each) { $timestamp = strtotime($each['date']); $date = date("Y, n-1, j", $timestamp); $rawTime = date("H:i:s", $timestamp); if ($each['state'] == 0) { $coloring = "className : 'undone',"; } else { $coloring = ''; } $calendarData .= "\n {\n title: '" . $rawTime . ' ' . $each['street'] . ' ' . $each['build'] . '/' . $each['apt'] . "',\n url: '?module=sigreq&showreq=" . $each['id'] . "',\n start: new Date(" . $date . "),\n end: new Date(" . $date . "),\n " . $coloring . " \n },\n "; } } $result = wf_FullCalendar($calendarData); //check database configuration table if (zb_CheckTableExists('sigreqconf')) { $confControl = wf_Link('?module=sigreq&settings=true', wf_img('skins/settings.png', __('Settings')), false) . ' '; } else { $confControl = ''; } $viewControl = wf_Link('?module=sigreq', wf_img('skins/icon_table.png', __('Grid view')), false, ''); show_window($confControl . __('Available signup requests') . ' ' . $viewControl, $result); }
$tablecells .= wf_TableCell($event); $tablerows .= wf_TableRow($tablecells, 'row3'); } } $result .= wf_TableBody($tablerows, '100%', 0, 'sortable'); return $result; } //page lister if (isset($_GET['onpage'])) { $limit = vf($_GET['onpage'], 3); } else { $limit = 50; } //event search $adminlogin = wf_CheckPost(array('eventadmin')) ? $_POST['eventadmin'] : ''; if (isset($_POST['eventsearch'])) { if (strlen($_POST['eventsearch']) >= 3) { $searchevent = mysql_real_escape_string($_POST['eventsearch']); } else { $searchevent = ''; } } else { $searchevent = ''; } //small stats $current_monthlog = "logs_" . date("m") . "_" . date("Y") . ""; if (zb_CheckTableExists($current_monthlog)) { web_EventsShowStats(); } show_window(__('Last events'), web_EventsLister($limit, $adminlogin, $searchevent)); }
/** * Returns current stargazer DB version * =<2.408 - 0 * >=2.409 - 1+ * * @return int */ function zb_CheckDbSchema() { if (zb_CheckTableExists('info')) { $query = "SELECT `version` from `info`"; $result = simple_query($query); $result = $result['version']; } else { $result = 0; } return $result; }