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