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"));