echo '<center><div id=err_message ></div></center><br/>';
echo '<TABLE>';
echo '<TR><TD>Date</TD><TD>' . DateInput($RET[1]['SCHOOL_DATE'], 'values[SCHOOL_DATE]', '', true) . '</TD></TR>';
echo '<TR><TD>Title</TD><TD>' . TextInput($RET[1]['TITLE'], 'values[TITLE]', '', 'style=width:380px;') . '</TD></TR>';
if ($RET[1]['STAFF_ID']) {
echo '<TR><TD>Teacher</TD><TD>' . TextAreaInput($RET[1]['STAFF_ID'], 'values[STAFF_ID]') . '</TD></TR>';
}
if ($RET[1]['ASSIGNED_DATE']) {
echo '<TR><TD>Assigned Date</TD><TD>' . TextAreaInput($RET[1]['ASSIGNED_DATE'], 'values[ASSIGNED_DATE]') . '</TD></TR>';
}
if ($RET[1]['DUE_DATE']) {
echo '<TR><TD>Due Date </TD><TD>' . TextAreaInput($RET[1]['DUE_DATE'], 'values[DUE_DATE]') . '</TD></TR>';
}
echo '<TR><TD>Notes</TD><TD>' . TextAreaInput($RET[1]['DESCRIPTION'], 'values[DESCRIPTION]', '', 'style=width:380px;height:200px;') . '';
if (AllowEdit()) {
echo '<TR><TD>Show Events System Wide</TD><TD align=center>' . _makeCheckBoxInput($RET[1]['CALENDAR_ID'], $_REQUEST['event_id']) . '</TD></TR>';
echo '<TR><TD colspan=2 align=center><INPUT type=submit class=btn_medium name=button value=Save onclick="formload_ajax(\'popform\');">';
echo ' ';
if ($_REQUEST['event_id'] != 'new') {
echo '<INPUT type=submit name=button class=btn_medium value=Delete onclick="formload_ajax(\'popform\');">';
}
echo '</TD></TR>';
}
echo '</TABLE>';
PopTableWindow('footer');
echo '</FORM>';
unset($_REQUEST['values']);
unset($_SESSION['_REQUEST_vars']['values']);
unset($_REQUEST['button']);
unset($_SESSION['_REQUEST_vars']['button']);
}
$attendance_codes_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'SHORT_NAME' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput', 'TYPE' => '_makeSelectInput', 'STATE_CODE' => '_makeSelectInput', 'DEFAULT_CODE' => '_makeCheckBoxInput'));
}
$tabs = array(array('title' => _('Attendance'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=0"));
$categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM ATTENDANCE_CODE_CATEGORIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
foreach ($categories_RET as $category) {
$tabs[] = array('title' => $category['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=" . $category['ID']);
}
if ($_REQUEST['table'] != 'new') {
$sql = "SELECT ID,TITLE,SHORT_NAME,TYPE,DEFAULT_CODE,STATE_CODE,SORT_ORDER FROM ATTENDANCE_CODES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND TABLE_NAME='" . $_REQUEST['table'] . "' ORDER BY SORT_ORDER,TITLE";
$functions = array('TITLE' => '_makeTextInput', 'SHORT_NAME' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput', 'TYPE' => '_makeSelectInput', 'DEFAULT_CODE' => '_makeCheckBoxInput');
$LO_columns = array('TITLE' => _('Title'), 'SHORT_NAME' => _('Short Name'), 'SORT_ORDER' => _('Sort Order'), 'TYPE' => _('Type'), 'DEFAULT_CODE' => _('Default for Teacher'));
if ($_REQUEST['table'] == '0') {
$functions['STATE_CODE'] = '_makeSelectInput';
$LO_columns['STATE_CODE'] = _('State Code');
}
$link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'SHORT_NAME' => _makeTextInput('', 'SHORT_NAME'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'), 'TYPE' => _makeSelectInput('', 'TYPE'), 'DEFAULT_CODE' => _makeCheckBoxInput('', 'DEFAULT_CODE'));
if ($_REQUEST['table'] == '0') {
$link['add']['html']['STATE_CODE'] = _makeSelectInput('', 'STATE_CODE');
}
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&table={$_REQUEST['table']}";
$link['remove']['variables'] = array('id' => 'ID');
$tabs[] = array('title' => button('add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=new");
} else {
$sql = "SELECT ID,TITLE,SORT_ORDER FROM ATTENDANCE_CODE_CATEGORIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER,TITLE";
$functions = array('TITLE' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput');
$LO_columns = array('TITLE' => 'Title', 'SORT_ORDER' => 'Sort Order');
$link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&table=new";
$link['remove']['variables'] = array('id' => 'ID');
$tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=new");
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
if ($_REQUEST['table'] !== 'new') {
$sql = 'SELECT ID,TITLE,SHORT_NAME,TYPE,DEFAULT_CODE,STATE_CODE,SORT_ORDER,TABLE_NAME FROM attendance_codes WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND TABLE_NAME=\'' . $_REQUEST['table'] . '\' ORDER BY SORT_ORDER,TITLE';
$QI = DBQuery($sql);
$LO = DBGet(DBQuery($sql));
$attandance_id_arr = array();
foreach ($LO as $ti => $td) {
array_push($attandance_id_arr, $td[ID]);
}
$attandance_id = implode(',', $attandance_id_arr);
$attendance_codes_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'SHORT_NAME' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput', 'TYPE' => '_makeSelectInput', 'STATE_CODE' => '_makeSelectInput', 'DEFAULT_CODE' => '_makeCheckBoxInput'));
}
$columns = array('TITLE' => 'Title', 'SHORT_NAME' => 'Short Name', 'SORT_ORDER' => 'Sort Order', 'TYPE' => 'Type', 'DEFAULT_CODE' => 'Default for Teacher', 'STATE_CODE' => 'State Code');
$link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'SHORT_NAME' => _makeTextInput('', 'SHORT_NAME'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER', 'onkeydown=return numberOnlyMod(event,this);'), 'TYPE' => _makeSelectInput('', 'TYPE'), 'DEFAULT_CODE' => _makeCheckBoxInput('', 'DEFAULT_CODE'), 'STATE_CODE' => _makeSelectInput('', 'STATE_CODE'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID', 'table' => 'TABLE_NAME');
echo "<FORM name=F1 id=F1 action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=update&table=" . strip_tags(trim($_REQUEST[table])) . " method=POST>";
echo '<input type="hidden" name="h1" id="h1" value="' . $attandance_id . '">';
$tabs = array(array('title' => 'Attendance', 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=0"));
$categories_RET = DBGet(DBQuery('SELECT ID,TITLE FROM attendance_code_categories WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY TITLE'));
foreach ($categories_RET as $category) {
$tabs[] = array('title' => $category['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=" . $category['ID']);
}
if ($_REQUEST['table'] === 'new') {
$tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=new");
} else {
$tabs[] = array('title' => button('add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&table=new");
}
$max_id = DBGet(DBQuery("select max(ID) maxid from attendance_codes"));
