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>';
