#**************************************************************************
if (!$_REQUEST['month']) {
$_REQUEST['month'] = date("n");
} else {
$_REQUEST['month'] = MonthNWSwitch($_REQUEST['month'], 'tonum') * 1;
}
if (!$_REQUEST['year']) {
$_REQUEST['year'] = date("Y");
}
$time = mktime(0, 0, 0, $_REQUEST['month'], 1, $_REQUEST['year']);
DrawBC("School Setup >> " . ProgramTitle());
if ($_REQUEST['modfunc'] == 'create') {
$fy_RET = DBGet(DBQuery("SELECT START_DATE,END_DATE FROM SCHOOL_YEARS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"));
$fy_RET = $fy_RET[1];
$message = '<TABLE cellspacing=0 cellpadding=0 border=0 ><TR><TD colspan=7 align=center>Title <INPUT type=text name=title class=cell_floating id=title> <INPUT type=checkbox name=default value=Y> Default Calendar for this School<BR><BR></TD></TR><TR><TD colspan=7 align=center>From ' . PrepareDate($fy_RET['START_DATE'], '_min') . ' To ' . PrepareDate($fy_RET['END_DATE'], '_max') . '</TD></TR><tr><td class=clear></td></tr><TR><TD><INPUT type=checkbox value=Y name=weekdays[0]>Sunday</TD><TD><INPUT type=checkbox value=Y name=weekdays[1] CHECKED>Monday</TD><TD><INPUT type=checkbox value=Y name=weekdays[2] CHECKED>Tuesday</TD><TD><INPUT type=checkbox value=Y name=weekdays[3] CHECKED>Wednesday</TD><TD><INPUT type=checkbox value=Y name=weekdays[4] CHECKED>Thursday</TD><TD><INPUT type=checkbox value=Y name=weekdays[5] CHECKED>Friday</TD><TD><INPUT type=checkbox value=Y name=weekdays[6]>Saturday</TD></TR></TABLE>';
if (Prompt_Calender('Create a new calendar', '', $message)) {
$begin = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_min'], 'to_num'), $_REQUEST['day_min'] * 1, $_REQUEST['year_min']) + 43200;
$end = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_max'], 'to_num'), $_REQUEST['day_max'] * 1, $_REQUEST['year_max']) + 43200;
$weekday = date('w', $begin);
$calendar_id = DBGet(DBQuery("SELECT " . db_seq_nextval('CALENDARS_SEQ') . " AS CALENDAR_ID " . FROM_DUAL));
$calendar_id = $calendar_id[1]['CALENDAR_ID'];
for ($i = $begin; $i <= $end; $i += 86400) {
if ($_REQUEST['weekdays'][$weekday] == 'Y') {
DBQuery("INSERT INTO ATTENDANCE_CALENDAR (SYEAR,SCHOOL_ID,SCHOOL_DATE,MINUTES,CALENDAR_ID) values('" . UserSyear() . "','" . UserSchool() . "','" . date('Y-m-d', $i) . "','999','" . $calendar_id . "')");
}
$weekday++;
if ($weekday == 7) {
$weekday = 0;
}
}
DBQuery("INSERT INTO ATTENDANCE_CALENDARS (CALENDAR_ID,SYEAR,SCHOOL_ID,TITLE,DEFAULT_CALENDAR) values('" . $calendar_id . "','" . UserSyear() . "','" . UserSchool() . "','" . $_REQUEST['title'] . "','" . $_REQUEST['default'] . "')");
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'edit_calendar') {
$colmn = Calender_Id;
$cal_id = paramlib_validation($colmn, $_REQUEST['calendar_id']);
$acs_RET = DBGet(DBQuery('SELECT TITLE, DEFAULT_CALENDAR FROM school_calendars WHERE CALENDAR_ID=\'' . $cal_id . '\''));
$acs_RET = $acs_RET[1];
$ac_RET = DBGet(DBQuery('SELECT MIN(SCHOOL_DATE) AS START_DATE,MAX(SCHOOL_DATE) AS END_DATE FROM attendance_calendar WHERE CALENDAR_ID=\'' . $cal_id . '\''));
$ac_RET = $ac_RET[1];
$day_RET = DBGet(DBQuery('SELECT DAYNAME(SCHOOL_DATE) AS DAY_NAME FROM attendance_calendar WHERE CALENDAR_ID=\'' . $cal_id . '\' ORDER BY SCHOOL_DATE LIMIT 0, 7'));
$i = 0;
foreach ($day_RET as $day) {
$weekdays[$i] = $day['DAY_NAME'];
$i++;
}
$message = '<TABLE cellspacing=0 cellpadding=0 border=0 ><TR><TD colspan=7 align=center>Title <INPUT type=text name=title class=cell_floating id=title value="' . $acs_RET['TITLE'] . '"> <INPUT type=checkbox name=default value=Y ' . ($acs_RET['DEFAULT_CALENDAR'] == 'Y' ? 'checked' : '') . '> Default Calendar for this School<BR><BR></TD></TR><TR><TD colspan=7 align=center>From</TD></TR><TR><TD colspan=7 align=center> ' . PrepareDate($ac_RET['START_DATE'], '_min', true, array('disabled' => true), 'N') . '</TD></TR><TR><TD colspan=7 align=center> To </TD></TR><TR><TD colspan=7 align=center >' . PrepareDate($ac_RET['END_DATE'], '_max', true, array('disabled' => true), 'N') . '</TD></TR><TR><TD class=clear></TD></TR><TR><TD><INPUT type=checkbox value=Y name=weekdays[0] ' . (in_array('Sunday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Sunday</TD><TD><INPUT type=checkbox value=Y name=weekdays[1] ' . (in_array('Monday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Monday</TD><TD><INPUT type=checkbox value=Y name=weekdays[2] ' . (in_array('Tuesday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Tuesday</TD><TD><INPUT type=checkbox value=Y name=weekdays[3] ' . (in_array('Wednesday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Wednesday</TD><TD><INPUT type=checkbox value=Y name=weekdays[4] ' . (in_array('Thursday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Thursday</TD><TD><INPUT type=checkbox value=Y name=weekdays[5] ' . (in_array('Friday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Friday</TD><TD><INPUT type=checkbox value=Y name=weekdays[6] ' . (in_array('Saturday', $weekdays) == true ? 'CHECKED' : '') . ' DISABLED>Saturday</TD></TR></TABLE>';
$message .= calendarEventsVisibility();
if (Prompt_Calender('Edit this calendar', '', $message)) {
$col = Calender_Title;
$cal_title = str_replace("'", "''", paramlib_validation($col, $_REQUEST['title']));
if (isset($_REQUEST['default'])) {
DBQuery('UPDATE school_calendars SET DEFAULT_CALENDAR = NULL WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\'');
}
DBQuery('UPDATE school_calendars SET TITLE = \'' . $cal_title . '\', DEFAULT_CALENDAR = \'' . $_REQUEST['default'] . '\' WHERE CALENDAR_ID=\'' . $cal_id . '\'');
DBQuery('DELETE FROM calendar_events_visibility WHERE calendar_id=\'' . $cal_id . '\'');
if (count($_REQUEST['profiles'])) {
$profile_sql = 'INSERT INTO calendar_events_visibility(calendar_id,profile_id,profile) VALUES';
foreach ($_REQUEST['profiles'] as $key => $profile) {
if (is_numeric($key)) {
$profile_sql .= '(\'' . $cal_id . '\',\'' . $key . '\',NULL),';
} else {
$profile_sql .= '(\'' . $cal_id . '\',NULL,\'' . $key . '\'),';
}
