function makeSelectInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if ($name == 'TYPE') {
$options = array('Add' => _('Add'), 'Drop' => _('Drop'));
}
return SelectInput($value, 'values[' . $id . '][' . $name . ']', '', $options);
}
function makeGradeInput($value, $name)
{
global $THIS_RET, $grades;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if (!$grades) {
$grades_RET = DBGet(DBQuery("SELECT ID,TITLE FROM SCHOOL_GRADELEVELS WHERE SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
if (count($grades_RET)) {
foreach ($grades_RET as $grade) {
$grades[$grade['ID']] = $grade['TITLE'];
}
}
}
return SelectInput($value, 'values[' . $id . '][' . $name . ']', '', $grades, 'N/A');
}
}
echo '</TD></TR>';
echo '<TR><TD width=100% valign=top>';
$items_RET = DBGet(DBQuery("SELECT fsi.SHORT_NAME,fsi.DESCRIPTION,fsi.PRICE_STAFF,fsi.ICON FROM FOOD_SERVICE_ITEMS fsi,FOOD_SERVICE_MENU_ITEMS fsmi WHERE fsmi.MENU_ID='" . $_REQUEST['menu_id'] . "' AND fsi.ITEM_ID=fsmi.ITEM_ID AND fsmi.CATEGORY_ID IS NOT NULL AND fsi.SCHOOL_ID='" . UserSchool() . "' ORDER BY fsi.SORT_ORDER"), array('ICON' => 'makeIcon'), array('SHORT_NAME'));
$items = array();
foreach ($items_RET as $sn => $item) {
$items += array($sn => $item[1]['DESCRIPTION']);
}
$LO_ret = array(array());
foreach ($_SESSION['FSA_sale'] as $id => $item_sn) {
$price = $items_RET[$item_sn][1]['PRICE_STAFF'];
$LO_ret[] = array('SALE_ID' => $id, 'PRICE' => $price, 'DESCRIPTION' => $items_RET[$item_sn][1]['DESCRIPTION'], 'ICON' => $items_RET[$item_sn][1]['ICON']);
}
unset($LO_ret[0]);
$link['remove'] = array('link' => "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&menu_id={$_REQUEST['menu_id']}", 'variables' => array('id' => 'SALE_ID'));
$link['add']['html'] = array('DESCRIPTION' => '<TABLE border=0 cellpadding=0 cellspacing=0><TR><TD>' . SelectInput('', 'item_sn', '', $items) . '</TD></TR></TABLE>', 'ICON' => '<TABLE border=0 cellpadding=0 cellspacing=0><TR><TD><INPUT type=submit value=' . _('Add') . '></TD></TR></TABLE>', 'remove' => button('add'));
$columns = array('DESCRIPTION' => _('Item'), 'ICON' => _('Icon'), 'PRICE' => _('Price'));
$tabs = array();
foreach ($menus_RET as $id => $menu) {
$tabs[] = array('title' => $menu[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&menu_id={$id}");
}
$extra = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&menu_id={$_REQUEST['menu_id']}"));
echo '<BR>';
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=add&menu_id={$_REQUEST['menu_id']} method=POST>";
ListOutput($LO_ret, $columns, _('Item'), _('Items'), $link, array(), $extra);
echo '</FORM>';
echo '</TD></TR></TABLE>';
} else {
ErrorMessage(array(_('This user does not have a Food Service Account.')), 'fatal');
}
}
function _makeCodePulldown($value, $title)
{
global $THIS_RET, $codes_RET, $current_RET, $current_schedule_RET, $date;
if (!is_array($current_schedule_RET[$THIS_RET['STUDENT_ID']])) {
$current_schedule_RET[$THIS_RET['STUDENT_ID']] = DBGet(DBQuery('SELECT cp.PERIOD_ID,cp.COURSE_PERIOD_ID FROM schedule s,course_periods cp WHERE s.STUDENT_ID=\'' . $THIS_RET['STUDENT_ID'] . '\' AND s.SYEAR=\'' . UserSyear() . '\' AND s.SCHOOL_ID=\'' . UserSchool() . '\' AND cp.COURSE_PERIOD_ID = s.COURSE_PERIOD_ID AND cp.DOES_ATTENDANCE=\'Y\' AND s.MARKING_PERIOD_ID IN (' . GetAllMP('QTR', GetCurrentMP('QTR', $date)) . ') AND (\'' . $date . '\' BETWEEN s.START_DATE AND s.END_DATE OR s.END_DATE IS NULL)'), array(), array('PERIOD_ID'));
if (!$current_schedule_RET[$THIS_RET['STUDENT_ID']]) {
$current_schedule_RET[$THIS_RET['STUDENT_ID']] = array();
}
}
if ($THIS_RET['COURSE']) {
$period = $THIS_RET['COURSE_PERIOD_ID'];
$period_id = $THIS_RET['PERIOD_ID'];
foreach ($codes_RET as $code) {
$options[$code['ID']] = $code['TITLE'];
}
} else {
$period_id = substr($title, 7);
$period = $current_schedule_RET[$THIS_RET['STUDENT_ID']][$period_id][1]['COURSE_PERIOD_ID'];
foreach ($codes_RET as $code) {
$options[$code['ID']] = $code['SHORT_NAME'];
}
}
$val = $current_RET[$THIS_RET['STUDENT_ID']][$period][1]['ATTENDANCE_CODE'];
if ($current_schedule_RET[$THIS_RET['STUDENT_ID']][$period_id]) {
return SelectInput($val, 'attendance[' . $THIS_RET['STUDENT_ID'] . '][' . $period . '][ATTENDANCE_CODE]', '', $options);
} else {
return false;
}
}
function _makeGradeForStandard($value, $column)
{
global $THIS_RET, $report_card_grades;
#echo '<pre>';print_r($THIS_RET);echo'</pre>';
return SelectInput($THIS_RET['GRADE_ID'], "student_standards[{$THIS_RET['ID']}][GRADE_ID]", '', $report_card_grades, 'N/A', '') . " <br/>";
}
echo '<table><TR><TD><input type="radio" id="noaccs" name="values[SCHOOL][OPENSIS_ACCESS]" value="N" onClick="hidediv();"> No Access <input type="radio" id="r4" name="values[SCHOOL][OPENSIS_ACCESS]" value="Y" onClick="showdiv();" checked> Access</TD></TR></TABLE>';
echo '<div id="hideShow">';
} elseif ($this_school_mod['USERNAME'] && $this_school_mod['PASSWORD'] && $this_school['OPENSIS_ACCESS']) {
if ($this_school['OPENSIS_ACCESS'] == 'N') {
echo '<table><TR><TD><input type="radio" id="noaccs" name="values[SCHOOL][OPENSIS_ACCESS]" value="N" checked> No Access <input type="radio" id="r4" name="values[SCHOOL][OPENSIS_ACCESS]" value="Y" > Access</TD></TR></TABLE>';
} elseif ($this_school['OPENSIS_ACCESS'] == 'Y') {
echo '<table><TR><TD><input type="radio" id="noaccs" name="values[SCHOOL][OPENSIS_ACCESS]" value="N"> No Access <input type="radio" id="r4" name="values[SCHOOL][OPENSIS_ACCESS]" value="Y" checked> Access</TD></TR></TABLE>';
}
echo '<div id="hideShow">';
} elseif (!$this_school_mod['USERNAME'] || $this_school['OPENSIS_ACCESS'] == 'N') {
echo '<table><TR><TD><input type="radio" id="noaccs" name="values[SCHOOL][OPENSIS_ACCESS]" value="N" onClick="hidediv();" checked> No Access <input type="radio" id="r4" name="values[SCHOOL][OPENSIS_ACCESS]" value="Y" onClick="showdiv();"> Access</TD></TR></TABLE>';
echo '<div id="hideShow" style="display:none">';
}
echo '<TABLE>';
$staff_profile = DBGet(DBQuery("SELECT PROFILE_ID FROM staff WHERE STAFF_ID='" . UserStaffID() . "'"));
echo '<TR><td>Profile</td><td>:</td><TD>' . SelectInput($this_school['OPENSIS_PROFILE'], 'values[SCHOOL][OPENSIS_PROFILE]', '', $option, false, 'id=values[SCHOOL][OPENSIS_PROFILE]') . '</TD><tr>';
echo '<TR><td>Username<span class=red>*</span></td><td>:</td><TD>';
if (!$this_school_mod['USERNAME']) {
echo TextInput('', 'USERNAME', '', 'size=20 maxlength=50 class=cell_floating onblur="usercheck_init_staff(this)"');
echo '<span id="ajax_output_st"></span><input type=hidden id=usr_err_check value=0>';
} else {
echo NoInput($this_school_mod['USERNAME'], '', '', 'class=cell_medium onkeyup="usercheck_init(this)"') . '<div id="ajax_output"></div>' . '</TD></tr>';
}
echo '<TR><td>Password<span class=red>*</span></td><td>:</td><TD>';
if (!$this_school_mod['PASSWORD']) {
echo TextInput('', 'PASSWORD', '', 'size=20 maxlength=100 class=cell_floating AUTOCOMPLETE = off onblur=passwordStrength(this.value);validate_password_staff(this.value);');
echo '<span id="ajax_output_st"></span>';
} else {
echo TextInput(array($this_school_mod['PASSWORD'], str_repeat('*', strlen($this_school_mod['PASSWORD']))), 'staff_school[PASSWORD]', '', 'size=20 maxlength=100 class=cell_floating AUTOCOMPLETE = off onkeyup=passwordStrength(this.value);validate_password(this.value);');
}
echo "<td><span id='passwordStrength'></span></td>";
// You can't change a student field type after it has been created
// mab - allow changing between select and autos and edits and text and exports
if ($_REQUEST['id'] != 'new') {
if ($RET['TYPE'] != 'select' && $RET['TYPE'] != 'autos' && $RET['TYPE'] != 'edits' && $RET['TYPE'] != 'text' && $RET['TYPE'] != 'exports') {
$allow_edit = $_ROSARIO['allow_edit'];
$AllowEdit = $_ROSARIO['AllowEdit'][$modname];
$_ROSARIO['allow_edit'] = false;
$_ROSARIO['AllowEdit'][$modname] = array();
$type_options = array('select' => _('Pull-Down'), 'autos' => _('Auto Pull-Down'), 'edits' => _('Edit Pull-Down'), 'text' => _('Text'), 'radio' => _('Checkbox'), 'codeds' => _('Coded Pull-Down'), 'exports' => _('Export Pull-Down'), 'numeric' => _('Number'), 'multiple' => _('Select Multiple from Options'), 'date' => _('Date'), 'textarea' => _('Long Text'));
} else {
$type_options = array('select' => _('Pull-Down'), 'autos' => _('Auto Pull-Down'), 'edits' => _('Edit Pull-Down'), 'exports' => _('Export Pull-Down'), 'text' => _('Text'));
}
} else {
$type_options = array('select' => _('Pull-Down'), 'autos' => _('Auto Pull-Down'), 'edits' => _('Edit Pull-Down'), 'text' => _('Text'), 'radio' => _('Checkbox'), 'codeds' => _('Coded Pull-Down'), 'exports' => _('Export Pull-Down'), 'numeric' => _('Number'), 'multiple' => _('Select Multiple from Options'), 'date' => _('Date'), 'textarea' => _('Long Text'));
}
$header .= '<TD>' . SelectInput($RET['TYPE'], 'tables[' . $_REQUEST['id'] . '][TYPE]', _('Data Type'), $type_options, false) . '</TD>';
if ($_REQUEST['id'] != 'new' && $RET['TYPE'] != 'select' && $RET['TYPE'] != 'autos' && $RET['TYPE'] != 'edits' && $RET['TYPE'] != 'text' && $RET['TYPE'] != 'exports') {
$_ROSARIO['allow_edit'] = $allow_edit;
$_ROSARIO['AllowEdit'][$modname] = $AllowEdit;
}
foreach ($categories_RET as $type) {
$categories_options[$type['ID']] = ParseMLField($type['TITLE']);
}
$header .= '<TD>' . MLSelectInput($RET['CATEGORY_ID'] ? $RET['CATEGORY_ID'] : $_REQUEST['category_id'], 'tables[' . $_REQUEST['id'] . '][CATEGORY_ID]', _('Student Field Category'), $categories_options, false) . '</TD>';
$header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['id'] . '][SORT_ORDER]', _('Sort Order'), 'size=5') . '</TD>';
$header .= '</TR><TR>';
$colspan = 2;
if ($RET['TYPE'] == 'autos' || $RET['TYPE'] == 'edits' || $RET['TYPE'] == 'select' || $RET['TYPE'] == 'codeds' || $RET['TYPE'] == 'multiple' || $RET['TYPE'] == 'exports' || $_REQUEST['id'] == 'new') {
$header .= '<TD colspan="2">' . TextAreaInput($RET['SELECT_OPTIONS'], 'tables[' . $_REQUEST['id'] . '][SELECT_OPTIONS]', _('Pull-Down') . '/' . _('Auto Pull-Down') . '/' . _('Coded Pull-Down') . '/' . _('Select Multiple from Options') . '<BR />' . _('* one per line'), 'rows=7 cols=40') . '</TD>';
$colspan = 1;
}
function makeGradesInput($value, $name)
{
global $THIS_RET, $grade_scale_select, $teacher_id, $config_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if ($name == 'GRADE_SCALE_ID') {
return SelectInput($value, "values[{$id}][{$name}]", '', $grade_scale_select, false);
} elseif ($name == 'COMMENT') {
$extra = 'size=15 maxlength=100';
} elseif ($name == 'GPA_VALUE') {
$extra = 'size=5 maxlength=5';
} elseif ($name == 'SORT_ORDER') {
$extra = 'size=5 maxlength=5';
} elseif ($name == 'BREAK_OFF' && $teacher_id && $config_RET[UserCoursePeriod() . '-' . $THIS_RET['ID']][1]['VALUE'] != '') {
return '<FONT color=blue>' . $config_RET[UserCoursePeriod() . '-' . $THIS_RET['ID']][1]['VALUE'] . '</FONT>';
} else {
$extra = 'size=5 maxlength=5';
}
return TextInput($value, "values[{$id}][{$name}]", '', $extra);
}
function _makeMPSelect($mp_id, $name = '')
{
global $_openSIS, $THIS_RET, $fy_id;
if ($mp_id != '') {
if (!$_openSIS['_makeMPSelect']) {
$semesters_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,NULL AS SEMESTER_ID FROM school_semesters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'));
$quarters_RET = DBGet(DBQuery('SELECT MARKING_PERIOD_ID,TITLE,SEMESTER_ID FROM school_quarters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'));
$_openSIS['_makeMPSelect'][$fy_id][1] = array('MARKING_PERIOD_ID' => "{$fy_id}", 'TITLE' => 'Full Year', 'SEMESTER_ID' => '');
foreach ($semesters_RET as $sem) {
$_openSIS['_makeMPSelect'][$fy_id][] = $sem;
}
foreach ($quarters_RET as $qtr) {
$_openSIS['_makeMPSelect'][$fy_id][] = $qtr;
}
$quarters_QI = DBQuery('SELECT MARKING_PERIOD_ID,TITLE,SEMESTER_ID FROM school_quarters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER');
$quarters_indexed_RET = DBGet($quarters_QI, array(), array('SEMESTER_ID'));
foreach ($semesters_RET as $sem) {
$_openSIS['_makeMPSelect'][$sem['MARKING_PERIOD_ID']][1] = $sem;
foreach ($quarters_indexed_RET[$sem['MARKING_PERIOD_ID']] as $qtr) {
$_openSIS['_makeMPSelect'][$sem['MARKING_PERIOD_ID']][] = $qtr;
}
}
foreach ($quarters_RET as $qtr) {
$_openSIS['_makeMPSelect'][$qtr['MARKING_PERIOD_ID']][] = $qtr;
}
}
foreach ($_openSIS['_makeMPSelect'][$mp_id] as $value) {
$mps[$value['MARKING_PERIOD_ID']] = $value['TITLE'];
}
if ($THIS_RET['MARKING_PERIOD_ID'] != $mp_id) {
$mps[$THIS_RET['MARKING_PERIOD_ID']] = '* ' . $mps[$THIS_RET['MARKING_PERIOD_ID']];
}
return SelectInput($THIS_RET['MARKING_PERIOD_ID'], "schedule[{$THIS_RET['COURSE_PERIOD_ID']}][{$THIS_RET['START_DATE']}][MARKING_PERIOD_ID]", '', $mps, false);
} else {
$check_custom = DBGet(DBQuery('SELECT BEGIN_DATE,END_DATE FROM course_periods WHERE COURSE_PERIOD_ID=' . $THIS_RET['COURSE_PERIOD_ID'] . ' AND BEGIN_DATE IS NOT NULL AND END_DATE IS NOT NULL AND BEGIN_DATE!=\'0000-00-00\' AND END_DATE!=\'0000-00-00\' '));
if (count($check_custom) > 0) {
return '<div style="white-space: nowrap;">' . ProperDateAY($check_custom[1]['BEGIN_DATE']) . ' to ' . ProperDateAY($check_custom[1]['END_DATE']) . '</div>';
}
}
}
echo '<TABLE border=0 cellpadding=6 width=100%>';
echo '<TR>';
echo '<TD>';
// warn if account non-existent (balance query failed)
if ($student['BALANCE'] == '') {
echo TextInput(array($student['ACCOUNT_ID'], '<FONT color=red>' . $student['ACCOUNT_ID'] . '</FONT>'), 'food_service[ACCOUNT_ID]', _('Account ID'), 'size=12 maxlength=10');
$warning = 'Non-existent account!';
echo button('warning', '', '# onMouseOver=\'stm(["Warning","' . $warning . '"],["white","#006699","","","",,"black","#e8e8ff","","","",,,,2,"#006699",2,,,,,"",,,,]);\' onMouseOut=\'htm()\'');
} else {
echo TextInput($student['ACCOUNT_ID'], 'food_service[ACCOUNT_ID]', 'Account ID', 'size=12 maxlength=10');
}
// warn if other students associated with the same account
if (count($xstudents)) {
$warning = Localize('colon', _('Other students associated with the same account')) . '<BR>';
foreach ($xstudents as $xstudent) {
$warning .= ' ' . str_replace('\'', ''', $xstudent['FULL_NAME']) . '<BR>';
}
echo button('warning', '', '# onMouseOver=\'stm(["Warning","' . $warning . '"],["white","#006699","","","",,"black","#e8e8ff","","","",,,,2,"#006699",2,,,,,"",,,,]);\' onMouseOut=\'htm()\'');
}
echo '</TD>';
$options = array('Inactive' => _('Inactive'), 'Disabled' => _('Disabled'), 'Closed' => _('Closed'));
echo '<TD>' . SelectInput($student['STATUS'], 'food_service[STATUS]', _('Status'), $options, _('Active')) . '</TD>';
echo '</TR><TR>';
$options = array('Reduced' => 'Reduced', 'Free' => 'Free');
echo '<TD>' . SelectInput($student['DISCOUNT'], 'food_service[DISCOUNT]', _('Discount'), $options, _('Full')) . '</TD>';
echo '<TD>' . TextInput($student['BARCODE'], 'food_service[BARCODE]', _('Barcode'), 'size=12 maxlength=25') . '</TD>';
echo '</TR>';
echo '</TABLE>';
echo '</TD></TR>';
echo '</TABLE>';
}
function _makeTimeInputEnd($value, $name)
{
global $THIS_RET;
if ($THIS_RET['PERIOD_ID']) {
$id = $THIS_RET['PERIOD_ID'];
} else {
$id = 'new';
}
$hour = substr($value, 0, strpos($value, ':'));
$m = substr($value, 0, strpos($value, ''));
for ($i = 1; $i <= 12; $i++) {
$hour_options[$i] = $i;
}
#$hour_options['0'] = '12';
for ($i = 0; $i <= 9; $i++) {
$minute_options[$i] = '0' . $i;
}
for ($i = 10; $i <= 59; $i++) {
$minute_options[$i] = $i;
}
#$m_options = array('AM'=>'AM','PM'=>'PM');
$sql_ampm = 'select end_time from school_periods where period_id=' . $id;
$res_ampm = mysql_query($sql_ampm);
$row_ampm = mysql_fetch_array($res_ampm);
$ampm = $row_ampm['end_time'];
$f_ampm = substr($ampm, -2);
$min = $row_ampm['end_time'];
$f_min = explode(":", $min);
$fn_min = substr($f_min[1], 0, 2);
if (!is_numeric($fn_min)) {
$fn_min = substr($f_min[1], 0, 1);
}
/*
if($id!='new' && $value)
return '<DIV id=etime'.$id.'><div onclick=\'addHTML("<TABLE><TR><TD>'.str_replace('"','\"',SelectInput($hour,'values['.$id.'][END_HOUR]','',$hour_options,false,'',false)).'</TD><TD>'.str_replace('"','\"',SelectInput($fn_min,'values['.$id.'][END_MINUTE]','',$minute_options,false,'',false)).'</TD><TD>'.str_replace('"','\"',SelectInput($f_ampm,'values['.$id.'][END_M]','',array('AM'=>'AM','PM'=>'PM'),false,'',false)).'</TD></TR></TABLE>","etime'.$id.'",true);\'>'.$value.'</div></DIV>';
else
return '<TABLE cellspacing=0 cellpadding=0><TR><TD>'.SelectInput($hour,'values['.$id.'][END_HOUR]','',$hour_options,false,'',false).'</TD><TD>'.SelectInput($fn_min,'values['.$id.'][END_MINUTE]','',$minute_options,false,'',false).'</TD><TD>'.SelectInput($f_ampm,'values['.$id.'][END_M]','',array('AM'=>'AM','PM'=>'PM'),false,'',false).'</TD></TR></TABLE>';
*/
if ($id != 'new' && $value) {
return '<DIV id=etime' . $id . '><div onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', SelectInput($hour, 'values[' . $id . '][END_HOUR]', '', $hour_options, false, '', false)) . '</TD><TD>' . str_replace('"', '\\"', SelectInput($fn_min, 'values[' . $id . '][END_MINUTE]', '', $minute_options, false, '', false)) . '</TD><TD>' . str_replace('"', '\\"', SelectInput($f_ampm, 'values[' . $id . '][END_M]', '', array('AM' => 'AM', 'PM' => 'PM'), false, '', false)) . '</TD></TR></TABLE>","etime' . $id . '",true);\'>' . $value . '</div></DIV>';
} else {
return '<TABLE cellspacing=0 cellpadding=0><TR><TD>' . SelectInput($hour, 'values[' . $id . '][END_HOUR]', '', $hour_options, 'N/A', '', false) . '</TD><TD>' . SelectInput($fn_min, 'values[' . $id . '][END_MINUTE]', '', $minute_options, 'N/A', '', false) . '</TD><TD>' . SelectInput($f_ampm, 'values[' . $id . '][END_M]', '', array('AM' => 'AM', 'PM' => 'PM'), 'N/A', '', false) . '</TD></TR></TABLE>';
}
}
function _makeSelectInput($column, $options)
{
return SelectInput('', 'values[' . $column . ']', '', $options, _('N/A'), "style='max-width:250;'");
}
$date = date('d-M-y', $day_time);
echo "<TD width=100 class=" . ($calendar_RET[$date][1]['MINUTES'] ? $calendar_RET[$date][1]['MINUTES'] == '999' ? 'calendar_active' : 'calendar_extra' : 'calendar_holiday') . " valign=top><table width=100><tr><td width=5 valign=top>{$i}</td><td width=95 align=right>";
if (AllowEdit()) {
if ($calendar_RET[$date][1]['MINUTES'] == '999') {
echo '<TABLE cellpadding=0 cellspacing=0 ><TR><TD>' . CheckboxInput($calendar_RET[$date], "all_day[{$date}]", '', '', false, '<IMG SRC=assets/check.gif> ') . '</TD></TR></TABLE>';
} else {
echo "<TABLE cellpadding=0 cellspacing=0 ><TR><TD><INPUT type=checkbox name=all_day[{$date}] value=Y></TD>";
echo '<TD>' . TextInput($calendar_RET[$date][1]['MINUTES'], "minutes[{$date}]", '', 'size=3 class=cell_small onkeydown="return numberOnly(event);"') . '</TD></TR></TABLE>';
}
}
if (count($blocks_RET) > 0) {
unset($options);
foreach ($blocks_RET as $block) {
$options[$block['BLOCK']] = $block['BLOCK'];
}
echo SelectInput($calendar_RET[$date][1]['BLOCK'], "blocks[{$date}]", '', $options);
}
echo "</td></tr><tr><TD colspan=2 height=50 valign=top>";
if (count($events_RET[$date])) {
echo '<TABLE cellpadding=2 cellspacing=2 border=0>';
foreach ($events_RET[$date] as $event) {
echo "<TR><TD>" . button('dot', '0000FF', '', '6') . "</TD><TD> <A HREF=# onclick='javascript:window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=detail&event_id={$event['ID']}&year={$_REQUEST['year']}&month=" . MonthNWSwitch($_REQUEST['month'], 'tochar') . "\",\"blank\",\"width=500,height=300\"); return false;'><b>" . ($event['TITLE'] ? $event['TITLE'] : '***') . "</b></A></TD></TR>";
}
if (count($assignments_RET[$date])) {
foreach ($assignments_RET[$date] as $event) {
echo "<TR><TD>" . button('dot', $event['ASSIGNED'] == 'Y' ? '00FF00' : 'FF0000', '', 6) . "</TD><TD><A HREF=# onclick='javascript:window.open(\"for_window.php?modname={$_REQUEST['modname']}&modfunc=detail&assignment_id={$event['ID']}&year={$_REQUEST['year']}&month=" . MonthNWSwitch($_REQUEST['month'], 'tochar') . "\",\"blank\",\"width=500,height=300\"); return false;'>" . $event['TITLE'] . "</A></TD></TR>";
}
}
echo '</TABLE>';
} elseif (count($assignments_RET[$date])) {
echo '<TABLE cellpadding=0 cellspacing=0 border=0>';
echo '<TD bgcolor=' . $color . '><INPUT type=radio name=values[Preferences][HIGHLIGHT] value=' . $color . (Preferences('HIGHLIGHT') == $color ? ' CHECKED' : '') . '></TD>';
}
echo '</TR></TABLE></TD></TR><TR><td class=break></td></tr>';
echo '<TR><TD><b>Currency</b></TD></tr><tr><TD>';
# echo '<TR><TD><b>Currency</b></TD></tr><tr><TD><SELECT name=values[Preferences][CURRENCY]>';
$values = DBGet(DBQuery("SELECT VALUE AS ID,TITLE FROM PROGRAM_CONFIG WHERE PROGRAM='Currency' "));
# $values = array('USD' => 'US Dollar','GBP' => 'British Pound','EUR' => 'Euro','CAD' => 'Canadian Dollar','AUD' => 'Australian Dollar','JPY' => 'Japanese Yen','BRL' => 'Brazillian Real');
##foreach($values as $symbol => $name)
#echo '<OPTION value='.$symbol.((Preferences('CURRENCY')==$symbol)?' SELECTED':'').'>'.$name.'</OPTION>';
#echo '</SELECT></TD></TR>';
$current_RET = DBGet(DBQuery("SELECT TITLE,VALUE,PROGRAM FROM PROGRAM_USER_CONFIG WHERE USER_ID='1' AND TITLE='CURRENCY' AND PROGRAM IN ('Preferences') "));
$val = $current_RET[1]['VALUE'];
foreach ($values as $symbol) {
$symbols[$symbol['ID']] = $symbol['TITLE'];
}
echo SelectInput($val, 'values[Preferences][CURRENCY]', '', $symbols, 'N/A');
echo '</TD></TR>';
echo '<TR><TD><b>Date Format</b></TD></tr><tr><TD><SELECT name=values[Preferences][MONTH]>';
$values = array('F', 'M', 'm', 'n');
foreach ($values as $value) {
echo '<OPTION value=' . $value . (Preferences('MONTH') == $value ? ' SELECTED' : '') . '>' . date($value) . '</OPTION>';
}
echo '</SELECT> ';
echo '<SELECT name=values[Preferences][DAY]>';
$values = array('d', 'j', 'jS');
foreach ($values as $value) {
echo '<OPTION value=' . $value . (Preferences('DAY') == $value ? ' SELECTED' : '') . '>' . date($value == 'd' ? '[0]j' : $value) . '</OPTION>';
}
echo '</SELECT> ';
echo '<SELECT name=values[Preferences][YEAR]>';
$values = array('Y', 'y', '');
function _makeType($value, $name)
{
global $THIS_RET;
if ($THIS_RET['USAGE_ID']) {
$id = $THIS_RET['USAGE_ID'];
} else {
$id = 'new';
}
$new_options = array('checkbox' => _('Checkbox'), 'text' => _('Text'), 'multiple_checkbox' => _('Select Multiple from Options'), 'multiple_radio' => _('Select One from Options'), 'select' => _('Pull-Down'), 'date' => _('Date'), 'numeric' => _('Number'), 'textarea' => _('Long Text'));
if ($THIS_RET['ID']) {
return $new_options[$value];
} else {
return SelectInput($value, 'values[new][' . $name . ']', '', $new_options, false);
}
}
}
}
if ($_REQUEST['student_id'] != 'new' && $student['SCHOOL_ID'] != UserSchool()) {
$allow_edit = $_openSIS['allow_edit'];
$AllowEdit = $_openSIS['AllowEdit'][$_REQUEST['modname']];
$_openSIS['AllowEdit'][$_REQUEST['modname']] = $_openSIS['allow_edit'] = false;
}
if ($_REQUEST['student_id'] == 'new') {
$student_id = 'new';
} else {
$student_id = UserStudentID();
}
if ($student_id == 'new' && !VerifyDate($_REQUEST['day_values']['student_enrollment']['new']['START_DATE'] . '-' . $_REQUEST['month_values']['student_enrollment']['new']['START_DATE'] . '-' . $_REQUEST['year_values']['student_enrollment']['new']['START_DATE'])) {
unset($student['GRADE_ID']);
}
echo SelectInput($student['GRADE_ID'], 'values[student_enrollment][' . $student_id . '][GRADE_ID]', (!$student['GRADE_ID'] ? '<FONT color=red>' : '') . '' . (!$student['GRADE_ID'] ? '</FONT>' : ''), $options, '', '');
echo '</td></tr>';
echo '</table>';
echo '</td></TR>';
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Access Information</b></td></tr><tr><td colspan="2">';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px>Username</td><td>:</td><td>';
echo TextInput($student['USERNAME'], 'students[USERNAME]', '', 'class=cell_medium onkeyup="usercheck_init_student(this)"');
echo '<span id="ajax_output_st"></span>';
echo '</td></tr>';
echo '<tr><td>Password</td><td>:</td><td>';
echo TextInput(array($student['PASSWORD'], str_repeat('*', strlen($student['PASSWORD']))), 'students[PASSWORD]', '', 'class=cell_medium onkeyup=passwordStrength(this.value)', 'AUTOCOMPLETE = off');
echo '<div id="passwordStrength" style=display:none></div>';
echo '</td></tr>';
if ($_REQUEST['student_id'] != 'new') {
echo '<tr><td>Last Login</td><td>:</td><td>';
$rowcolor = 'even';
$header .= '<TR class="' . $rowcolor . '"><TD align="center">' . button('add') . '</TD>';
$header .= '<TD>' . SelectInput($RET['DAYS'], 'course_period_variable[' . $course_period_id . '][DAYS]', '', $days, 'N/A', 'id=days') . '</TD>';
$header .= '<TD>' . SelectInput($RET['PERIOD_ID'], 'course_period_variable[' . $course_period_id . '][PERIOD_ID]', '', $periods, 'N/A', 'id=' . $day . '_period class=cell_floating ' . $disable . ' onchange=show_period_time(this.value,"' . $day . '","' . $course_period_id . '","n");') . '</TD>';
$header .= '<TD><div id=' . $day . '_period_time></div></TD>';
$header .= '<TD>' . SelectInput($RET['ROOM'], 'course_period_variable[' . $course_period_id . '][ROOM_ID]', '', $rooms, 'N/A', 'id=' . $day . '_room ' . $disable) . '</TD>';
$header .= '<TD align="center">' . CheckboxInput($RET['DOES_ATTENDANCE'], 'course_period_variable[' . $course_period_id . '][DOES_ATTENDANCE]', '', '', false, 'Yes', 'No', false, ' id=' . $day . '_does_attendance onclick="formcheck_periods_attendance_F2(' . ($day != '' ? 2 : 1) . ',this);"' . $disable) . '<br><div id="ajax_output"></div></TD></TR>';
$header .= '</TR></TABLE>';
echo '<input type="hidden" name="fixed_day" id="fixed_day" value="' . $day . '" />';
} elseif ($_REQUEST['sch_type'] == 'fixed') {
$header = '<input type=hidden name=tables[course_periods][' . $course_period_id . '][SCHEDULE_TYPE] value=FIXED />';
echo '<input type="hidden" name="get_status" id="get_status" value="" />';
echo '<input type="hidden" name="cp_id" id="' . $day . '_id" value="' . $course_period_id . '"/>';
$header .= '<TABLE width=100%><TR>';
$header .= '<TD>' . SelectInput($RET['ROOM'], 'tables[course_period_var][' . $course_period_id . '][ROOM_ID]', 'Class Room', $rooms, 'N/A', 'id=' . $day . '_room ' . $disable) . '</TD>';
$header .= '<TD>' . SelectInput($RET['PERIOD_ID'], 'tables[course_period_var][' . $course_period_id . '][PERIOD_ID]', 'Period', $periods, 'N/A', 'id=' . $day . '_period class=cell_floating onchange="formcheck_periods_F2(\'' . $day . '\');"' . $disable) . '</TD>';
$header .= '<TD>';
$header .= '<TABLE><TR>';
foreach ($days as $day => $short_day) {
if (strpos($RET['DAYS'], $day) !== false || $new && $day != 'S' && $day != 'U') {
$value = 'Y';
} else {
$value = '';
}
$header .= '<TD>' . str_replace('"', '\\"', CheckboxInput($value, 'tables[course_period_var][' . $course_period_id . '][DAYS][' . $day . ']', $day == 'U' ? 'S' : $day, $checked, false, '', '', false)) . '</TD>';
}
$header .= '</TR></TABLE>';
$header .= '</TD>';
$header .= '<TD valign=top align="center">' . CheckboxInput($RET['DOES_ATTENDANCE'], 'tables[course_period_var][' . $course_period_id . '][DOES_ATTENDANCE]', 'Takes attendance', $checked, $new, '<IMG SRC=assets/check.gif height=15 vspace=0 hspace=0 border=0>', '<IMG SRC=assets/x.gif height=15 vspace=0 hspace=0 border=0>', true, ' id=' . $day . '_does_attendance onclick="formcheck_periods_attendance_F2(' . ($day != '' ? 2 : 1) . ',this);"') . '<br><div id="ajax_output"></div></TD>';
$header .= '</TR></TABLE>';
echo '<input type="hidden" name="fixed_day" id="fixed_day" value="' . $day . '" />';
function _makeAutoSelectInputX($value, $column, $table, $title, $select, $id = '', $div = true)
{
if ($column == 'CITY' || $column == 'MAIL_CITY') {
$options = 'maxlength=60';
}
if ($column == 'STATE' || $column == 'MAIL_STATE') {
$options = 'size=3 maxlength=10';
} elseif ($column == 'ZIPCODE' || $column == 'MAIL_ZIPCODE') {
$options = 'maxlength=10';
} else {
$options = 'maxlength=100';
}
if ($value != '---' && count($select) > 1) {
return SelectInput($value, "values[{$table}]" . ($id ? "[{$id}]" : '') . "[{$column}]", $title, $select, 'N/A', '', $div);
} else {
return TextInput($value == '---' ? array('---', '<FONT color=red>---</FONT>') : $value, "values[{$table}]" . ($id ? "[{$id}]" : '') . "[{$column}]", $title, $options, $div);
}
}
// mab - allow changing between select and autos and edits and text
if ($_REQUEST['id'] != 'new') {
// if($RET['TYPE']!='select' && $RET['TYPE']!='autos' && $RET['TYPE']!='edits' && $RET['TYPE']!='text')
// {
// $allow_edit = $_openSIS['allow_edit'];
// $AllowEdit = $_openSIS['AllowEdit'][$modname];
// $_openSIS['allow_edit'] = false;
// $_openSIS['AllowEdit'][$modname] = array();
// $type_options = array('select'=>'Pull-Down','autos'=>'Auto Pull-Down','edits'=>'Edit Pull-Down','text'=>'Text','radio'=>'Checkbox','codeds'=>'Coded Pull-Down','numeric'=>'Number','multiple'=>'Select Multiple from Options','date'=>'Date','textarea'=>'Long Text');
// }
// else
$type_options = array('select' => 'Pull-Down', 'autos' => 'Auto Pull-down', 'edits' => 'Edit Pull-Down', 'text' => 'Text', 'radio' => 'Checkbox', 'codeds' => 'Coded Pull-Down', 'numeric' => 'Number', 'multiple' => 'Select Multiple from Options', 'date' => 'Date', 'textarea' => 'Long Text');
} else {
$type_options = array('select' => 'Pull-Down', 'autos' => 'Auto Pull-down', 'edits' => 'Edit Pull-Down', 'text' => 'Text', 'radio' => 'Checkbox', 'codeds' => 'Coded Pull-Down', 'numeric' => 'Number', 'multiple' => 'Select Multiple from Options', 'date' => 'Date', 'textarea' => 'Long Text');
}
$header .= '<TD>' . SelectInput($RET['TYPE'], 'tables[' . $_REQUEST['id'] . '][TYPE]', 'Data Type', $type_options, false, 'id=type onchange="formcheck_student_studentField_F1_defalut();"') . '</TD>';
if ($_REQUEST['id'] != 'new' && $RET['TYPE'] != 'select' && $RET['TYPE'] != 'autos' && $RET['TYPE'] != 'edits' && $RET['TYPE'] != 'text') {
$_openSIS['allow_edit'] = $allow_edit;
$_openSIS['AllowEdit'][$modname] = $AllowEdit;
}
foreach ($categories_RET as $type) {
$categories_options[$type['ID']] = $type['TITLE'];
}
if ($_REQUEST['id'] == 'new') {
$header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['id'] . '][SORT_ORDER]', 'Sort Order', 'onkeydown="return numberOnly(event);"') . '</TD>';
} else {
$header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['id'] . '][SORT_ORDER]', 'Sort Order', 'onkeydown=\\"return numberOnly(event);\\"') . '</TD>';
}
$header .= '</TR><TR>';
$colspan = 2;
if ($RET['TYPE'] == 'autos' || $RET['TYPE'] == 'edits' || $RET['TYPE'] == 'select' || $RET['TYPE'] == 'codeds' || $RET['TYPE'] == 'multiple' || $_REQUEST['id'] == 'new') {
function _makeStartInputCodeenrl($value, $column)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
$add_codes = array();
$options_RET = DBGet(DBQuery('SELECT ID,TITLE AS TITLE FROM student_enrollment_codes WHERE SYEAR=\'' . ($THIS_RET['SYEAR'] != '' ? $THIS_RET['SYEAR'] : UserSyear()) . '\' AND (TYPE=\'Add\' OR TYPE=\'Roll\' OR TYPE=\'TrnE\')'));
if ($options_RET) {
foreach ($options_RET as $option) {
$add_codes[$option['ID']] = $option['TITLE'];
}
}
$option_output = DBGet(DBQuery('SELECT ID,TITLE AS TITLE FROM student_enrollment_codes WHERE SYEAR=\'' . ($THIS_RET['SYEAR'] != '' ? $THIS_RET['SYEAR'] : UserSyear()) . '\' AND (TYPE=\'Add\' OR TYPE=\'Roll\' OR TYPE=\'TrnE\') AND ID=\'' . $value . '\''));
if ($THIS_RET['SYEAR'] == UserSyear()) {
return '<TABLE class=LO_field><TR><TD>' . SelectInput($THIS_RET['ENROLLMENT_CODE'], 'values[student_enrollment][' . $id . '][ENROLLMENT_CODE]', '', $add_codes, 'N/A', 'style="max-width:150;"') . '</TD></TR></TABLE>';
} else {
if ($value == '') {
return "N/A";
} else {
return $option_output[1]['TITLE'];
}
}
}
$calendar = $RET[count($RET)]['CALENDAR_ID'];
}
$div = true;
} else {
$id = 'new';
$next_school = UserSchool();
$calendar = $calendars_RET[1]['CALENDAR_ID'];
$div = false;
}
################################################################################
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Enrollment Information</b></td></tr><tr><td colspan="2">';
echo '</TD></TR>';
echo '<tr><td colspan="2"><table>';
echo '<input type=hidden id=cal_stu_id value=' . $id . ' />';
echo '<tr><td>Calendar<font color=red>*</font></td><td>:</td><td>' . SelectInput($calendar, "values[student_enrollment][{$id}][CALENDAR_ID]", (!$calendar || !$div ? '' : '') . '' . (!$calendar || !$div ? '' : ''), $calendar_options, false, '', $div) . '</td></tr>';
echo '<tr><td>Rolling/Retention Options</td><td>:</td><td>' . SelectInput($next_school, "values[student_enrollment][{$id}][NEXT_SCHOOL]", (!$next_school || !$div ? '' : '') . '' . (!$next_school || !$div ? '' : ''), $next_school_options, false, '', $div) . '</td></tr>';
echo '</table></td></tr>';
echo '<tr><td colspan="2">';
if ($_REQUEST['student_id'] && $_REQUEST['student_id'] != 'new') {
$sql_enroll_id = DBGet(DBQuery('SELECT MAX(ID) AS M_ID FROM student_enrollment WHERE STUDENT_ID=\'' . $_REQUEST['student_id'] . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
$enroll_id = $sql_enroll_id[1]['M_ID'];
$end_date = DBGet(DBQuery('SELECT END_DATE FROM student_enrollment WHERE STUDENT_ID=\'' . $_REQUEST['student_id'] . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND ID=\'' . $enroll_id . '\''));
if ($end_date[1]['END_DATE']) {
$end_date = $end_date[1]['END_DATE'];
DBQuery('UPDATE schedule SET END_DATE=\'' . $end_date . '\' WHERE STUDENT_ID=\'' . $_REQUEST['student_id'] . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND (END_DATE IS NULL OR \'' . $end_date . '\' < END_DATE )');
DBQuery('CALL SEAT_COUNT()');
}
}
if ($_REQUEST['student_id'] != 'new') {
if (count($RET)) {
$id = $RET[count($RET)]['ID'];
$option[$options['ID']] = $options['TITLE'];
$i++;
}
echo SelectInput($staff['PROFILE_ID'], 'staff[PROFILE]', (!$staff['PROFILE'] ? '<FONT color=red>' : '') . '' . (!$staff['PROFILE'] ? '</FONT>' : ''), $option, '', 'id=profile');
echo '</TD></tr><tr><td style=width:100px>' . _('Permissions') . '</td><td>:</td><td><TD>';
unset($profiles);
if (clean_param($_REQUEST['staff_id'], PARAM_ALPHANUM) != 'new') {
$profiles_RET = DBGet(DBQuery('SELECT ID,TITLE FROM user_profiles WHERE TITLE=\'' . $staff[PROFILE] . '\' AND ID <>0 ORDER BY ID'));
foreach ($profiles_RET as $profile) {
$profiles[$profile['ID']] = '' . _('Default') . '';
}
$na = '' . _('Custom') . '';
} else {
$na = '' . _('Default') . '';
}
echo SelectInput($staff['PROFILE_ID'], 'staff[Permissions]', '', $profiles, $na);
echo '</TD></TR></TABLE>';
echo '</TD>';
echo '<TD>';
$schools_RET = DBGet(DBQuery('SELECT s.ID,s.TITLE FROM schools s,staff st INNER JOIN staff_school_relationship ssr USING(staff_id) WHERE s.id=ssr.school_id AND ssr.syear=' . UserSyear() . ' AND st.staff_id=' . User('STAFF_ID')));
unset($options);
if (count($schools_RET) && User('PROFILE') == 'admin') {
$i = 0;
$_SESSION[staff_school_chkbox_id] = 0;
//echo '<TABLE><TR>';
if ($staff['STAFF_ID']) {
$schools = GetUserSchools($staff['STAFF_ID']);
}
//print_r($schools);
//print_r($schools_RET_);
#echo $staff['STAFF_ID'];
function _makeSelectInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if ($name == 'TYPE') {
$options = array('teacher' => _('Teacher & Office'), 'official' => _('Office Only'));
} elseif ($name = 'STATE_CODE') {
$options = array('P' => _('Present'), 'A' => _('Absent'), 'H' => _('Half'));
}
return SelectInput($value, 'values[' . $id . '][' . $name . ']', '', $options);
}
$type_options = array('select' => 'Pull-Down', 'autos' => 'Auto Pull-Down', 'edits' => 'Edit Pull-Down', 'text' => 'Text', 'radio' => 'Checkbox', 'codeds' => 'Coded Pull-Down', 'numeric' => 'Number', 'multiple' => 'Select Multiple from Options', 'date' => 'Date', 'textarea' => 'Long Text');
} else {
$type_options = array('select' => 'Pull-Down', 'autos' => 'Auto Pull-down', 'edits' => 'Edit Pull-Down', 'text' => 'Text');
}
} else {
$type_options = array('select' => 'Pull-Down', 'autos' => 'Auto Pull-down', 'edits' => 'Edit Pull-Down', 'text' => 'Text', 'radio' => 'Checkbox', 'codeds' => 'Coded Pull-Down', 'numeric' => 'Number', 'multiple' => 'Select Multiple from Options', 'date' => 'Date', 'textarea' => 'Long Text');
}
$header .= '<TD>' . SelectInput($RET['TYPE'], 'tables[' . $_REQUEST['id'] . '][TYPE]', 'Data Type', $type_options, false) . '</TD>';
if ($_REQUEST['id'] != 'new' && $RET['TYPE'] != 'select' && $RET['TYPE'] != 'autos' && $RET['TYPE'] != 'edits' && $RET['TYPE'] != 'text') {
$_CENTRE['allow_edit'] = $allow_edit;
$_CENTRE['AllowEdit'][$modname] = $AllowEdit;
}
foreach ($categories_RET as $type) {
$categories_options[$type['ID']] = $type['TITLE'];
}
$header .= '<TD>' . SelectInput($RET['CATEGORY_ID'] ? $RET['CATEGORY_ID'] : $_REQUEST['category_id'], 'tables[' . $_REQUEST['id'] . '][CATEGORY_ID]', 'Address Field Category', $categories_options, false) . '</TD>';
$header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['id'] . '][SORT_ORDER]', 'Sort Order') . '</TD>';
$header .= '</TR><TR>';
$colspan = 2;
if ($RET['TYPE'] == 'autos' || $RET['TYPE'] == 'edits' || $RET['TYPE'] == 'select' || $RET['TYPE'] == 'codeds' || $RET['TYPE'] == 'multiple' || $_REQUEST['id'] == 'new') {
$header .= '<TD colspan=2>' . TextAreaInput($RET['SELECT_OPTIONS'], 'tables[' . $_REQUEST['id'] . '][SELECT_OPTIONS]', 'Pull-Down/Auto Pull-Down/Coded Pull-Down/Select Multiple Choices<BR>* one per line', 'rows=7 cols=40') . '</TD>';
$colspan = 1;
}
$header .= '<TD valign=bottom colspan=' . $colspan . '>' . TextInput($RET['DEFAULT_SELECTION'], 'tables[' . $_REQUEST['id'] . '][DEFAULT_SELECTION]', 'Default') . '<small><BR>* for dates: YYYY-MM-DD,<BR> for checkboxes: Y</small></TD>';
if ($_REQUEST['id'] == 'new') {
$new = true;
}
$header .= '<TD>' . CheckboxInput($RET['REQUIRED'], 'tables[' . $_REQUEST['id'] . '][REQUIRED]', 'Required', '', $new) . '</TD>';
$header .= '</TR>';
$header .= '</TABLE>';
} elseif ($_REQUEST['category_id']) {
$hour_options[$i] = $i;
}
$hour_options['0'] = '12';
for ($i = 0; $i <= 9; $i++) {
$minute_options[$i] = '0' . $i;
}
for ($i = 10; $i <= 59; $i++) {
$minute_options[$i] = $i;
}
$m_options = array('AM' => 'AM', 'PM' => 'PM');
if ($START_HOUR > 12) {
$START_HOUR -= 12;
$START_M = 'PM';
} else {
$START_M = 'AM';
}
if ($END_HOUR > 12) {
$END_HOUR -= 12;
$END_M = 'PM';
} else {
$END_M = 'AM';
}
PopTable('header', _('Allow Eligibility Posting'));
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>";
echo '<TABLE>';
echo '<TR><TD><B>' . _('From') . '</B></TD><TD>' . SelectInput($START_DAY, 'values[START_DAY]', '', $day_options, false, '', false) . '</TD><TD>' . SelectInput($START_HOUR, 'values[START_HOUR]', '', $hour_options, false, '', false) . ':</TD><TD>' . SelectInput($START_MINUTE, 'values[START_MINUTE]', '', $minute_options, false, '', false) . '</TD><TD>' . SelectInput($START_M, 'values[START_M]', '', $m_options, false, '', false) . '</TD></TR>';
echo '<TR><TD><B>' . _('To') . '</B></TD><TD>' . SelectInput($END_DAY, 'values[END_DAY]', '', $day_options, false, '', false) . '</TD><TD>' . SelectInput($END_HOUR, 'values[END_HOUR]', '', $hour_options, false, '', false) . ':</TD><TD>' . SelectInput($END_MINUTE, 'values[END_MINUTE]', '', $minute_options, false, '', false) . '</TD><TD>' . SelectInput($END_M, 'values[END_M]', '', $m_options, false, '', false) . '</TD></TR>';
echo '<TR><TD colspan=4 align=center>' . SubmitButton(_('Save')) . '</TD></TR>';
echo '</TABLE>';
echo '</FORM>';
PopTable('footer');
function _makeAutoSelectInput($column, $name, $request = 'staff')
{
global $value, $field;
if ($_REQUEST['staff_id'] == 'new' && $field['DEFAULT_SELECTION']) {
$value[$column] = $field['DEFAULT_SELECTION'];
$div = false;
$req = $field['REQUIRED'] == 'Y' ? array('<FONT color=red>', '</FONT>') : array('', '');
} else {
$div = true;
$req = $field['REQUIRED'] == 'Y' && ($value[$column] == '' || $value[$column] == '---') ? array('<FONT color=red>', '</FONT>') : array('', '');
}
// build the select list...
// get the standard selects
if ($field['SELECT_OPTIONS']) {
$field['SELECT_OPTIONS'] = str_replace("\n", "\r", str_replace("\r\n", "\r", $field['SELECT_OPTIONS']));
$select_options = explode("\r", $field['SELECT_OPTIONS']);
} else {
$select_options = array();
}
if (count($select_options)) {
foreach ($select_options as $option) {
if ($option != '') {
$options[$option] = $option;
}
}
}
// add the 'new' option, is also the separator
$options['---'] = '---';
if ($field['TYPE'] == 'autos') {
// add values found in current and previous year
$options_RET = DBGet(DBQuery('SELECT DISTINCT s.CUSTOM_' . $field[ID] . ',upper(s.CUSTOM_' . $field[ID] . ') AS KEEY FROM staff s,staff_school_relationship ssr WHERE s.STAFF_ID=ssr.STAFF_ID AND (ssr.SYEAR=\'' . UserSyear() . '\' OR ssr.SYEAR=\'' . (UserSyear() - 1) . '\') AND s.CUSTOM_' . $field[ID] . ' IS NOT NULL ORDER BY KEEY'));
if (count($options_RET)) {
foreach ($options_RET as $option) {
if ($option['CUSTOM_' . $field['ID']] != '' && !$options[$option['CUSTOM_' . $field['ID']]]) {
$options[$option['CUSTOM_' . $field['ID']]] = array($option['CUSTOM_' . $field['ID']], '<FONT color=blue>' . $option['CUSTOM_' . $field['ID']] . '</FONT>');
}
}
}
}
// make sure the current value is in the list
if ($value[$column] != '' && !$options[$value[$column]]) {
$options[$value[$column]] = array($value[$column], '<FONT color=' . ($field['TYPE'] == 'autos' ? 'blue' : 'green') . '>' . $value[$column] . '</FONT>');
}
if ($value[$column] != '---' && count($options) > 1) {
$extra = 'style="max-width:250;"';
return SelectInput($value[$column], $request . '[' . $column . ']', $req[0] . $name . $req[1], $options, 'N/A', $extra, $div);
} else {
return TextInput($value[$column] == '---' ? array('---', '<FONT color=red>---</FONT>') : '' . $value[$column], $request . '[' . $column . ']', $req[0] . $name . $req[1], $size, $div);
}
}
function _make_staff_school($value, $column)
{
global $THIS_RET, $schools_select;
return SelectInput($value, "staff[{$THIS_RET['TRANSACTION_ID']}]", '', $schools_select[$THIS_RET['SYEAR']]);
//function SelectInput($value,$name,$title='',$options,$allow_na='N/A',$extra='',$div=true)
}
function makeCodePulldown($value, $student_id, $date)
{
global $THIS_RET, $attendance_codes, $_openSIS;
$date = substr($date, 1, 4) . '-' . substr($date, 5, 2) . '-' . substr($date, 7);
if (!$_openSIS['code_options']) {
foreach ($attendance_codes as $id => $code) {
$_openSIS['code_options'][$id] = $code[1]['SHORT_NAME'];
}
}
return SelectInput($value, 'attendance[' . $student_id . '][' . $date . '][ATTENDANCE_CODE]', '', $_openSIS['code_options']);
}
$qr .= ' AND \'' . $st_date . '\' BETWEEN ea.start_date AND ea.end_date';
} else {
$st_date = date('Y-m-d');
$qr .= ' AND \'' . $st_date . '\' BETWEEN ea.start_date AND ea.end_date';
}
$qr .= ' AND em.SYEAR=ea.SYEAR AND em.ACTIVITY_ID=ea.ID ORDER BY ea.START_DATE';
$RET = DBGet(DBQuery($qr), array('START_DATE' => 'ProperDate', 'END_DATE' => 'ProperDate'));
$activities_RET = DBGet(DBQuery('SELECT ID,TITLE FROM eligibility_activities WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
if (count($activities_RET)) {
foreach ($activities_RET as $value) {
$activities[$value['ID']] = $value['TITLE'];
}
}
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&start_date={$_REQUEST['start_date']}";
$link['remove']['variables'] = array('activity_id' => 'ACTIVITY_ID');
$link['add']['html']['TITLE'] = '<TABLE border=0 cellpadding=0 cellspacing=0><TR><TD>' . SelectInput('', 'new_activity', '', $activities) . ' </TD><TD> <INPUT type=submit value=Add class=btn_medium onclick=\'formload_ajax("elig_stud");\'></TD></TR></TABLE>';
$link['add']['html']['remove'] = button('add');
echo "<FORM action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=add&start_date=" . strip_tags(trim($_REQUEST[start_date])) . " method=POST>";
$columns = array('TITLE' => 'Activity', 'START_DATE' => 'Starts', 'END_DATE' => 'Ends');
ListOutput($RET, $columns, 'Activity', 'Activities', $link);
echo '</FORM>';
echo '</TD><TD width=50% valign=top>';
$RET = DBGet(DBQuery('SELECT e.ELIGIBILITY_CODE,c.TITLE as COURSE_TITLE FROM eligibility e,courses c,course_periods cp WHERE e.STUDENT_ID=\'' . UserStudentID() . '\' AND e.SYEAR=\'' . UserSyear() . '\' AND e.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cp.COURSE_ID=c.COURSE_ID AND e.SCHOOL_DATE BETWEEN \'' . date('Y-m-d', strtotime($start_date)) . '\' AND \'' . date('Y-m-d', strtotime($end_date)) . '\''), array('ELIGIBILITY_CODE' => '_makeLower'));
$columns = array('COURSE_TITLE' => 'Course', 'ELIGIBILITY_CODE' => 'Grade');
ListOutputNew($RET, $columns, 'Course', 'Courses');
echo '</TD></TR></TABLE>';
}
function _makeLower($word)
{
return ucwords(strtolower($word));
}
$RET = DBGet($QI);
$title = $RET[1]['TITLE'] . ' - New Course';
unset($delete_button);
unset($RET);
}
echo "<FORM name=F3 id=F3 action=for_window.php?modname={$_REQUEST['modname']}&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']} method=POST>";
DrawHeaderHome($title, $delete_button . SubmitButton('' . _('Save') . '', '', 'class=btn_medium onclick="formcheck_scheduling_course_F3();"'));
$header .= '<TABLE cellpadding=3 width=100%>';
$header .= '<TR>';
$header .= '<TD>' . TextInput($RET['TITLE'], 'tables[courses][' . $_REQUEST['course_id'] . '][TITLE]', '' . _('Title') . '', 'class=cell_floating') . '</TD>';
$header .= '<TD>' . TextInput($RET['SHORT_NAME'], 'tables[courses][' . $_REQUEST['course_id'] . '][SHORT_NAME]', '' . _('Short Name') . '', 'class=cell_floating') . '</TD>';
if ($_REQUEST['modfunc'] != 'choose_course') {
foreach ($subjects_RET as $type) {
$options[$type['SUBJECT_ID']] = $type['TITLE'];
}
$header .= '<TD>' . SelectInput($RET['SUBJECT_ID'] ? $RET['SUBJECT_ID'] : $_REQUEST['subject_id'], 'tables[courses][' . $_REQUEST['course_id'] . '][SUBJECT_ID]', '' . _('Subject') . '', $options, false) . '</TD>';
}
$header .= '</TR>';
$header .= '</TABLE>';
DrawHeaderHome($header);
echo '</FORM>';
} elseif ($_REQUEST['subject_id']) {
if ($_REQUEST['subject_id'] != 'new') {
$sql = "SELECT TITLE\n\t\t\t\t\t\tFROM course_subjects\n\t\t\t\t\t\tWHERE SUBJECT_ID='{$_REQUEST['subject_id']}'";
$QI = DBQuery($sql);
$RET = DBGet($QI);
$RET = $RET[1];
$title = $RET['TITLE'];
} else {
$title = '' . _('New Subject') . '';
unset($delete_button);
