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