echo '</TD></TR>'; break; case 'numeric': echo '<TR><TD>'; echo _makeTextInput('CUSTOM_' . $field['ID'], $field['TITLE'], 'size=5 maxlength=10', $request); echo '</TD></TR>'; break; case 'date': echo '<TR><TD>'; echo _makeDateInput('CUSTOM_' . $field['ID'], $field['TITLE'], $request); echo '</TD></TR>'; break; case 'codeds': case 'select': echo '<TR><TD>'; echo _makeSelectInput('CUSTOM_' . $field['ID'], $field['TITLE'], $request); echo '</TD></TR>'; break; case 'multiple': echo '<TR><TD>'; echo _makeMultipleInput('CUSTOM_' . $field['ID'], $field['TITLE'], $request); echo '</TD></TR>'; break; case 'radio': echo '<TR><TD>'; echo _makeCheckboxInput('CUSTOM_' . $field['ID'], $field['TITLE'], $request); echo '</TD></TR>'; break; case 'textarea': echo '<TR><TD>'; echo _makeTextareaInput('CUSTOM_' . $field['ID'], $field['TITLE'], $request);
echo _makeTextInput('CUSTOM_' . $field['ID'], '', 'size=5 maxlength=10 class=cell_medium'); echo '</TD>'; echo '</TR>'; break; case 'date': echo '<TR>'; echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>'; echo _makeDateInput_mod('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'codeds': case 'select': echo '<TR>'; echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>'; echo _makeSelectInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'multiple': echo '<TR>'; echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>'; echo _makeMultipleInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'radio': echo '<TR>'; echo '<td width="121px">' . $req . $field['TITLE'] . '</td><td>:</td><td>'; echo _makeCheckboxInput('CUSTOM_' . $field['ID'], ''); echo '</TD>';
$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"); } $LO_ret = DBGet(DBQuery($sql), $functions); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&table={$_REQUEST['table']} method=POST>";
$options[$school['ID']] = $school['TITLE']; } } echo _makeSelectInput('NEXT_SCHOOL', $options); echo '</TD>'; echo '</TR>'; echo '<TR><TD align=right valign=top><small><b>' . _('Calendar') . '</b></small></TD>'; echo '<TD>'; $calendars_RET = DBGet(DBQuery("SELECT CALENDAR_ID,DEFAULT_CALENDAR,TITLE FROM ATTENDANCE_CALENDARS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY DEFAULT_CALENDAR ASC")); $options = array(); if (count($calendars_RET)) { foreach ($calendars_RET as $calendar) { $options[$calendar['CALENDAR_ID']] = $calendar['TITLE']; } } echo _makeSelectInput('CALENDAR_ID', $options); echo '</TD>'; echo '</TR>'; } echo '</TABLE>'; echo '<BR>'; $radio_count = count($fields_RET['radio']); if ($radio_count) { echo '<TABLE cellpadding=5>'; echo '<TR>'; for ($i = 1; $i <= $radio_count; $i++) { echo '<TD>' . _makeCheckboxInput('CUSTOM_' . $fields_RET['radio'][$i]['ID'], '<b>' . ParseMLField($fields_RET['radio'][$i]['TITLE']) . '</b>') . '</TD>'; if ($i % 5 == 0 && $i != $radio_count) { echo '</TR><TR>'; } }
echo '</TD>'; echo '</TR>'; break; case 'date': echo '<TR>'; echo '<TD style="width:120px">'; echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . DateInputAY($value['CUSTOM_' . $field['ID']], 'CUSTOM_' . $field['ID'], $field['ID']); echo '<input type=hidden name=custom_date_id[] value="' . $field['ID'] . '" />'; echo '</TD>'; echo '</TR>'; break; case 'codeds': case 'select': echo '<TR>'; echo '<TD style="width:120px">'; echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeSelectInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'multiple': echo '<TR>'; echo '<TD style="width:120px">'; echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeMultipleInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'radio': echo '<TR>'; echo '<TD style="width:120px">'; echo $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeCheckboxInput('CUSTOM_' . $field['ID'], ''); echo '</TD>';
echo '</TD>'; if ($i % $per_row == 0) { echo '</TR>'; } else { echo '<TD style="width:50px;"></TD>'; } $i++; break; case 'exports': case 'codeds': case 'select': if (($i - 1) % $per_row == 0) { echo '<TR>'; } echo '<TD>'; echo _makeSelectInput('CUSTOM_' . $field['ID'], $field['TITLE'], 'staff'); echo '</TD>'; if ($i % $per_row == 0) { echo '</TR>'; } else { echo '<TD style="width:50px;"></TD>'; } $i++; break; case 'multiple': if (($i - 1) % $per_row == 0) { echo '<TR>'; } echo '<TD>'; echo _makeMultipleInput('CUSTOM_' . $field['ID'], $field['TITLE'], 'staff'); echo '</TD>';
} } if ($_REQUEST['modfunc'] != 'remove') { 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"; //$tabl=optional_param('table','',PARAM_ALPHANUM); $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); $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') . ''); /* if($_REQUEST['table']!='0') unset($columns['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'), '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={$_REQUEST['modname']}&modfunc=update&table={$_REQUEST['table']} method=POST>"; #DrawHeader('',SubmitButton('Save')); $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') { $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"); } if ($_REQUEST['table'] !== 'new') {
$a = DeletePromptStaffCert('Certificate'); } if ($_REQUEST['delete_ok'] == '1') { DBQuery("DELETE FROM staff_certification WHERE STAFF_CERTIFICATION_ID=" . $_REQUEST['certification_id']); unset($_REQUEST['modfunc']); } if (!$_REQUEST['modfunc']) { if ($_REQUEST['certification_id'] != '' && $_REQUEST['certification_id'] != 'new') { $this_certification_RET = DBGet(DBQuery("SELECT * FROM staff_certification\r\n WHERE STAFF_ID=" . UserStaffID())); $this_certification = $this_certification_RET[1]; } $sql = "SELECT STAFF_CERTIFICATION_ID AS ID,STAFF_ID,STAFF_CERTIFICATION_DATE,STAFF_CERTIFICATION_EXPIRY_DATE,\r\n STAFF_CERTIFICATION_CODE,STAFF_CERTIFICATION_SHORT_NAME,STAFF_CERTIFICATION_NAME,\r\n STAFF_PRIMARY_CERTIFICATION_INDICATOR,STAFF_CERTIFICATION_DESCRIPTION FROM staff_certification\r\n WHERE STAFF_ID=" . UserStaffID(); $QI = DBQuery($sql); $cert_RET = DBGet($QI, array('STAFF_CERTIFICATION_NAME' => '_makeTextInput', 'STAFF_CERTIFICATION_CODE' => '_makeTextInput', 'STAFF_CERTIFICATION_DATE' => '_makeDateInput', 'STAFF_CERTIFICATION_SHORT_NAME' => '_makeTextInput', 'STAFF_PRIMARY_CERTIFICATION_INDICATOR' => '_makeSelectInput', 'STAFF_CERTIFICATION_EXPIRY_DATE' => '_makeDateInput', 'STAFF_CERTIFICATION_DESCRIPTION' => '_makeContentInput')); $columns = array('STAFF_CERTIFICATION_NAME' => 'Certification Name', 'STAFF_CERTIFICATION_CODE' => 'Certification Code', 'STAFF_CERTIFICATION_DATE' => 'Certification Date', 'STAFF_CERTIFICATION_SHORT_NAME' => 'Certification Short Name', 'STAFF_PRIMARY_CERTIFICATION_INDICATOR' => 'Primary Certification Indicator', 'STAFF_CERTIFICATION_EXPIRY_DATE' => 'Certification Expiry Date', 'STAFF_CERTIFICATION_DESCRIPTION' => 'Certification Description'); $link['add']['html'] = array('STAFF_CERTIFICATION_NAME' => _makeTextInput('', 'STAFF_CERTIFICATION_NAME'), 'STAFF_CERTIFICATION_CODE' => _makeTextInput('', 'STAFF_CERTIFICATION_CODE'), 'STAFF_CERTIFICATION_DATE' => _makeDateInput('', 'STAFF_CERTIFICATION_DATE'), 'STAFF_CERTIFICATION_SHORT_NAME' => _makeTextInput('', 'STAFF_CERTIFICATION_SHORT_NAME'), 'STAFF_PRIMARY_CERTIFICATION_INDICATOR' => _makeSelectInput('', 'STAFF_PRIMARY_CERTIFICATION_INDICATOR'), 'STAFF_CERTIFICATION_EXPIRY_DATE' => _makeDateInput('', 'STAFF_CERTIFICATION_EXPIRY_DATE'), 'STAFF_CERTIFICATION_DESCRIPTION' => _makeContentInput('', 'STAFF_CERTIFICATION_DESCRIPTION')); // $link['remove']['link'] = "Modules.php?modname=$_REQUEST[modname]&include=$_REQUEST[include]&category_id=$_REQUEST[category_id]&staff_id=".UserStaffID()."&modfunc=remove"; $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&category_id={$_REQUEST['category_id']}&modfunc=remove"; $link['remove']['variables'] = array('id' => 'ID'); ListOutputStaffCert($cert_RET, $columns, 'Certificate', 'Certificates', $link); //echo '<pre>';print_r($_REQUEST);echo '</pre>'; } function _makeTextInput($value, $name) { global $THIS_RET; if ($THIS_RET['ID']) { $id = $THIS_RET['ID']; } else { $id = 'new'; } if ($name != 'TITLE') {
} } 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"));
echo ($field['REQUIRED'] == 'Y' ? '<span class=red>*</span>' : '') . $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeTextInput('CUSTOM_' . $field['ID'], '', 'size=5 maxlength=10 class=cell_floating'); echo '</TD>'; echo '</TR>'; break; case 'date': echo '<TR>'; echo '<TD style="width:100px">'; echo ($field['REQUIRED'] == 'Y' ? '<span class=red>*</span>' : '') . $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeDateInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'codeds': case 'select': echo '<TR>'; echo '<TD style="width:100px">'; echo ($field['REQUIRED'] == 'Y' ? '<span class=red>*</span>' : '') . $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeSelectInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'multiple': echo '<TR>'; echo '<TD style="width:100px">'; echo ($field['REQUIRED'] == 'Y' ? '<span class=red>*</span>' : '') . $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeMultipleInput('CUSTOM_' . $field['ID'], ''); echo '</TD>'; echo '</TR>'; break; case 'radio': echo '<TR>'; echo '<TD style="width:100px">'; echo ($field['REQUIRED'] == 'Y' ? '<span class=red>*</span>' : '') . $field['TITLE'] . '</TD><TD>:</TD><TD>' . _makeCheckboxInput('CUSTOM_' . $field['ID'], ''); echo '</TD>';