function _makeFeesDateInput($value = '', $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
$name = '[' . $id . '][' . $name . ']';
return DateInput($value, $name);
}
function _makeDateInput($column, $name, $request = 'staff')
{
global $value, $field;
if ($_REQUEST['student_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] == '' ? array('<FONT color=red>', '</FONT>') : array('', '');
}
return DateInput($value[$column], $request . '[' . $column . ']', $req[0] . $name . $req[1], $div);
}
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
//modif Francois: remove LO_field
$return = '<TABLE class="cellpadding-0 cellspacing-0"><TR><TD><b>' . Localize('colon', _('Visible Between')) . '</b></TD><TD style="text-align:right">';
$return .= DateInput($value, "values[{$id}][{$name}]") . '</TD><TD> ' . _('to') . ' </TD><TD>';
$return .= DateInput($THIS_RET['END_DATE'], "values[{$id}][END_DATE]") . '</TD></TR>';
//modif Francois: css WPadmin
$return .= '<TR><TD colspan="4" style="padding:0">';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM USER_PROFILES ORDER BY ID"));
}
$return .= '<TABLE class="width-100p cellspacing-0 cellpadding-0"><TR><TD colspan="4"><b>' . Localize('colon', _('Visible To')) . '</b></TD></TR><TR>';
foreach (array('admin' => _('Administrator w/Custom'), 'teacher' => _('Teacher w/Custom'), 'parent' => _('Parent w/Custom')) as $profile_id => $profile) {
//modif Francois: add <label> on checkbox
$return .= '<TD><label><INPUT type="checkbox" name="profiles[$id][' . $profile_id . ']" value="Y"' . (mb_strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' checked' : '') . '> ' . $profile . '</label></TD>';
}
$i = 3;
foreach ($profiles_RET as $profile) {
$i++;
$return .= '<TD><label><INPUT type="checkbox" name="profiles[' . $id . '][' . $profile['ID'] . ']" value="Y"' . (mb_strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' checked' : '') . "> " . _($profile['TITLE']) . "</label></TD>";
if ($i % 4 == 0 && $i != count($profile)) {
$return .= '</TR><TR>';
}
}
for (; $i % 4 != 0; $i++) {
$return .= '<TD> </TD>';
}
$return .= '</TR>';
//modif Francois: Moodle integrator
if (MOODLE_INTEGRATOR && $id == 'new') {
$return .= '<TR><TD colspan="4"><B>' . _('Publish Note in Moodle?') . '</B> <label><INPUT type="checkbox" name="MOODLE_PUBLISH_NOTE" value="Y" /> ' . _('Yes') . '</label></TD></TR></TABLE>';
} else {
$return .= '</TABLE>';
}
$return .= '</TD></TR></TABLE>';
return $return;
}
$standard_options[$standard_option['ID']] = $standard_option['TITLE'];
}
$header .= '<TD><DIV ID="standards_option" ' . ($RET['USE_STANDARDS'] == 'Y' ? '' : ' style="display:none" ') . ' >' . SelectInput($RET['STANDARD_SCALE_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][STANDARD_SCALE_ID]', 'Standard Grade Scale', $standard_options, 'Select Standard Grade', 'id="cp_standard_scale" ') . '</DIV></TD>';
$header .= '<TD valign=top>' . CheckboxInput($RET['DOES_HONOR_ROLL'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_HONOR_ROLL]', 'Affects Honor Roll', $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>', $div) . '</TD>';
$header .= '<TD valign=top>' . CheckboxInput($RET['HALF_DAY'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][HALF_DAY]', 'Half Day', $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>', $div) . '</TD>';
$header .= '<TD>' . CheckboxInput($RET['DOES_CLASS_RANK'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][DOES_CLASS_RANK]', 'Affects Class Rank', $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>', $div) . '</TD>';
$header .= '</TR>';
unset($options);
$mp_RET = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,SHORT_NAME,'2' AS t,SORT_ORDER FROM school_quarters WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' UNION SELECT MARKING_PERIOD_ID,SHORT_NAME,'1' AS t,SORT_ORDER FROM school_semesters WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' UNION SELECT MARKING_PERIOD_ID,SHORT_NAME,'0' AS t,SORT_ORDER FROM school_years WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY 3,4"));
if (count($mp_RET)) {
foreach ($mp_RET as $mp) {
$options[$mp['MARKING_PERIOD_ID']] = $mp['SHORT_NAME'];
}
}
$header .= '<TR><TD colspan=6><BR /><B>Choose the Duration</B></TD></TR><TR><TD colspan=6><TABLE cellpadding=4 width="100%" style="border:1px dotted #999"><TR><TD colspan=2><TABLE height="60px"><TR><TD><input type=radio name=date_range value=mp id=preset onchange=mp_range_toggle(this); ' . ($RET['MARKING_PERIOD_ID'] ? ' checked' : '') . '></TD><TD><label for=preset id=select_mp style="display:' . ($RET['MARKING_PERIOD_ID'] ? 'none' : 'block') . '">Marking Period</label><DIV id=mp_range style=float:left;display:' . ($RET['MARKING_PERIOD_ID'] ? 'block' : 'none') . '>' . SelectInput($RET['MARKING_PERIOD_ID'], 'tables[course_periods][' . $_REQUEST['course_period_id'] . '][MARKING_PERIOD_ID]', 'Marking Period', $options, 'N/A', 'id=marking_period', $div) . '</DIV></TD></TR></TABLE></TD>';
$header .= '<TD colspan=4 width="550px"><TABLE><TR><TD><input type=radio name=date_range value=dr id=custom onchange=mp_range_toggle(this); ' . ($RET['BEGIN_DATE'] ? ' checked' : '') . '></TD><TD><label for=custom id=select_range style="display:' . ($RET['BEGIN_DATE'] ? 'none' : 'block') . '">Custom Date Range</label><DIV id=date_range style=display:' . ($RET['BEGIN_DATE'] ? 'block' : 'none') . '><TABLE><TR><TD>' . DateInput($RET['BEGIN_DATE'], 'begin', 'Begin Date', $div) . '</TD><TD> </TD><TD> ' . DateInput($RET['END_DATE'], 'end', 'End Date', $div) . '</TD></TR></TABLE> </DIV></TD></TR></TABLE></TD></TR></TABLE></TD></TR>';
// $header .= '<TR><TD colspan=6><BR /><B>Choose Schedule Type</B></TD></TR><TR><TD colspan=6><TABLE cellpadding=4 width="100%" style="border:1px dotted #999"><TR><TD><input type=radio name=schedule_type id=fixed_schedule value=fixed onclick=show_cp_meeting_days(this.value,"'.$_REQUEST[course_period_id].'"); '.($RET['SCHEDULE_TYPE']=='FIXED'?' checked':'').' '.disabled().'><label for=fixed_schedule>Fixed Schedule</label></TD><TD><input type=radio name=schedule_type id=variable_schedule value=variable onclick=show_cp_meeting_days(this.value,"'.$_REQUEST[course_period_id].'"); '.($RET['SCHEDULE_TYPE']=='VARIABLE'?' checked':'').' '.disabled().'><label for=variable_schedule> Variable Schedule</label></TD><TD colspan=3><input type=radio name=schedule_type id=blocked_schedule value=blocked onclick=show_cp_meeting_days(this.value,"'.$_REQUEST[course_period_id].'"); '.($RET['SCHEDULE_TYPE']=='BLOCKED'?' checked':'').' '.disabled().'><label for=blocked_schedule>Blocked Schedule or Enter by Calendar Days</label></TD>';
$header .= '<TR><TD colspan=6><BR /><B>Choose Schedule Type</B></TD></TR><TR><TD colspan=6><TABLE cellpadding=4 width="100%" style="border:1px dotted #999"><TR><TD><input type=radio name=schedule_type id=fixed_schedule value=fixed onclick=show_cp_meeting_days(this.value,"' . $_REQUEST[course_period_id] . '"); ' . ($RET['SCHEDULE_TYPE'] == 'FIXED' ? ' checked' : '') . ' ' . disabled() . '><label for=fixed_schedule>Fixed Schedule</label></TD><TD><input type=radio name=schedule_type id=variable_schedule value=variable onclick=show_cp_meeting_days(this.value,"' . $_REQUEST[course_period_id] . '"); ' . ($RET['SCHEDULE_TYPE'] == 'VARIABLE' ? ' checked' : '') . ' ' . disabled() . '><label for=variable_schedule> Variable Schedule</label></TD><TD colspan=3><input type=radio name=schedule_type id=blocked_schedule value=blocked onclick=show_cp_meeting_days(this.value,"' . $_REQUEST[course_period_id] . '"); ' . ($RET['SCHEDULE_TYPE'] == 'BLOCKED' ? ' checked' : '') . ' ' . disabled() . '><label for=blocked_schedule>Enter by Calendar Days</label></TD>';
$header .= '</TR>';
$header .= '<TR>';
if ($_REQUEST['course_period_id'] != 'new' || $not_pass == true) {
$periods_RET = DBGet(DBQuery("SELECT PERIOD_ID,TITLE FROM school_periods WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY SORT_ORDER"));
if (count($periods_RET)) {
foreach ($periods_RET as $period) {
$periods[$period['PERIOD_ID']] = $period['TITLE'];
}
}
$room_RET = DBGet(DBQuery("SELECT ROOM_ID,TITLE FROM rooms WHERE SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER"));
if (count($room_RET)) {
foreach ($room_RET as $room) {
$rooms[$room['ROOM_ID']] = $room['TITLE'];
function _makeDate($value, $column)
{
global $THIS_RET;
if ($column == 'START_DATE') {
$allow_na = false;
} else {
$allow_na = true;
}
return DateInput($value, "schedule[{$THIS_RET['COURSE_PERIOD_ID']}][{$THIS_RET['START_DATE']}][{$column}]", '', true, $allow_na);
}
function _makeDateInput($column)
{
return DateInput('', 'values[' . $column . ']', '');
}
echo '<TABLE width=100% border=0 cellpadding=3>';
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Demographic Information</b></td></tr>';
echo '<TR><td valign="top">';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px>Name<font color=red>*</font></td><td>:</td><td>';
if ($_REQUEST['student_id'] == 'new') {
echo '<TABLE ><TR><TD >' . TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '<FONT color=red>First</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', 'Middle', 'class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '<FONT color=red>Last</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . SelectInput($student['NAME_SUFFIX'], 'students[NAME_SUFFIX]', 'Suffix', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"') . '</TD></TR></TABLE>';
} else {
echo '<DIV id=student_name><div style="font-size:14px; font-weight:bold;" onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '<FONT color=red>First</FONT>', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', 'Middle', 'size=3 maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '<FONT color=red>Last</FONT>', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', SelectInput($student['NAME_SUFFIX'], 'students[NAME_SUFFIX]', 'Suffix', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"', false)) . '</TD></TR></TABLE>","student_name",true);\'>' . $student['FIRST_NAME'] . ' ' . $student['MIDDLE_NAME'] . ' ' . $student['LAST_NAME'] . ' ' . $student['NAME_SUFFIX'] . '</div></DIV>';
}
echo '</td></tr>';
echo '<tr><td>Estimated Grad. Date </td><td>:</td><td>' . DateInput($student['ESTIMATED_GRAD_DATE'], 'students[ESTIMATED_GRAD_DATE]', '') . '</td></tr>';
echo '<tr><td>Gender</td><td>:</td><td>' . SelectInput($student['GENDER'], 'students[GENDER]', '', array('Male' => 'Male', 'Female' => 'Female'), 'N/A', '') . '</td></tr>';
echo '<tr><td>Ethnicity</td><td>:</td><td>' . SelectInput($student['ETHNICITY'], 'students[ETHNICITY]', '', $ethnic_option, 'N/A', '') . '</td></tr>';
echo '<tr><td>Common Name</td><td>:</td><td>' . TextInput($student['COMMON_NAME'], 'students[COMMON_NAME]', '', 'size=10 class=cell_medium maxlength=10') . '</td></tr>';
echo '<tr><td>Date of Birth</td><td>:</td><td>' . DateInput($student['BIRTHDATE'], 'students[BIRTHDATE]', '') . '</td></tr>';
echo '<tr><td>Primary Language</td><td>:</td><td>' . SelectInput($student['LANGUAGE'], 'students[LANGUAGE]', '', $language_option, 'N/A', '') . '</td></tr>';
if ($_REQUEST['student_id'] == 'new') {
$id_sent = 0;
} else {
$id_sent = UserStudentID();
}
echo '<tr><td>Email</td><td>:</td><td>' . TextInput($student['EMAIL'], 'students[EMAIL]', '', 'size=100 class=cell_medium maxlength=100 id=email_id onkeyup="check_email(this,' . $id_sent . ',3);" onblur="check_email(this,' . $id_sent . ',3);" ') . '<div id=email_error></div></td></tr>';
echo '<tr><td>Phone</td><td>:</td><td>' . TextInput($student['PHONE'], 'students[PHONE]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
#############################################CUSTOM FIELDS###############################
$fields_RET = DBGet(DBQuery('SELECT ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,REQUIRED,HIDE,SORT_ORDER FROM custom_fields WHERE SYSTEM_FIELD=\'N\' AND CATEGORY_ID=\'' . $_REQUEST[category_id] . '\' ORDER BY SORT_ORDER,TITLE'));
if (UserStudentID()) {
$custom_RET = DBGet(DBQuery('SELECT * FROM students WHERE STUDENT_ID=\'' . UserStudentID() . '\''));
$value = $custom_RET[1];
}
if (count($fields_RET)) {
function makeDateInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['MARKING_PERIOD_ID']) {
$id = $THIS_RET['MARKING_PERIOD_ID'];
} else {
$id = 'new';
}
return DateInput($value, "values[{$id}][{$name}]", '');
}
echo _makeInput('values[PEOPLE][7][LAST_NAME]', 'Last Name');
echo _makeInput('values[PEOPLE][7][extra][Relation]', 'Relation to Student', '', 'size=30');
echo _makeInput('values[PEOPLE][7][extra][Cell]', 'Cell Phone', '', 'size=30');
echo '<BR>' . _makeInput('values[PEOPLE][8][FIRST_NAME]', 'First Name');
echo _makeInput('values[PEOPLE][8][LAST_NAME]', 'Last Name');
echo _makeInput('values[PEOPLE][8][extra][Relation]', 'Relation to Student', '', 'size=30');
echo _makeInput('values[PEOPLE][8][extra][Cell]', 'Cell Phone', '', 'size=30');
echo '</TD></TR></TABLE>';
echo '</TD></TR></TABLE>';
echo '<HR>';
$student = DBGet(DBQuery("SELECT FIRST_NAME,LAST_NAME FROM STUDENTS WHERE STUDENT_ID='" . UserStudentID() . "'"));
echo '<B>Information about ' . $student[1]['FIRST_NAME'] . ' ' . $student[1]['LAST_NAME'] . ':</B>';
echo '<TABLE>';
echo '<TR>';
echo '<TD>';
echo DateInput($student['CUSTOM_200000004'], 'birth_date', 'Birthdate');
echo '</TD>';
echo '<TD>';
echo _makeInput('values[STUDENTS][CUSTOM_200000003]', 'SSN');
echo '</TD>';
echo '</TR>';
echo '<TR>';
echo '<TD>';
$ethnic_options = array('White, Non-Hispanic' => 'White, Non-Hispanic', 'Black, Non-Hispanic' => 'Black, Non-Hispanic', 'Amer. Indian or Alaskan Native' => 'Amer. Indian or Alaskan Native', 'Asian or Pacific Islander' => 'Asian or Pacific Islander', 'Hispanic' => 'Hispanic', 'Other' => 'Other');
echo SelectInput($student['CUSTOM_200000001'], 'values[STUDENTS][CUSTOM_200000001]', 'Ethnicity', $ethnic_options);
echo '</TD>';
echo '<TD>';
$language_options = array('English' => 'English', 'Achinese' => 'Achinese', 'Acholi' => 'Acholi', 'Adangme' => 'Adangme', 'Afro-Asiatic (Other)' => 'Afro-Asiatic (Other)', 'Afrihili (Artificial language)' => 'Afrihili (Artificial language)', 'Afrikaans' => 'Afrikaans', 'Aljamia' => 'Aljamia', 'Akkadian' => 'Akkadian', 'Albanian' => 'Albanian', 'Aleut' => 'Aleut', 'Algonquian languages' => 'Algonquian languages', 'Amharic' => 'Amharic', 'English, Old (ca. 450-1100)' => 'English, Old (ca. 450-1100)', 'Apache languages' => 'Apache languages', 'Arabic' => 'Arabic', 'Aramaic' => 'Aramaic', 'Armenian' => 'Armenian', 'Araucanian' => 'Araucanian', 'Arapaho' => 'Arapaho', 'Artificial (Other)' => 'Artificial (Other)', 'Arawak' => 'Arawak', 'American Sign Language' => 'American Sign Language', 'Assamese' => 'Assamese', 'Athabascan languages' => 'Athabascan languages', 'Avaric' => 'Avaric', 'Avestan' => 'Avestan', 'Awadhi' => 'Awadhi', 'Aymara' => 'Aymara', 'Azerbaijani' => 'Azerbaijani', 'Banda' => 'Banda', 'Bamileke languages' => 'Bamileke languages', 'Bashkir' => 'Bashkir', 'Baluchi' => 'Baluchi', 'Bambara' => 'Bambara', 'Balinese' => 'Balinese', 'Basque' => 'Basque', 'Basa' => 'Basa', 'Baltic (Other)' => 'Baltic (Other)', 'Beja' => 'Beja', 'Byelorussian' => 'Byelorussian', 'Bemba' => 'Bemba', 'Bengali' => 'Bengali', 'Berber languages' => 'Berber languages', 'Bhojpuri' => 'Bhojpuri', 'Bikol' => 'Bikol', 'Bini' => 'Bini', 'Siksika' => 'Siksika', 'Braj' => 'Braj', 'Breton' => 'Breton', 'Buginese' => 'Buginese', 'Bulgarian' => 'Bulgarian', 'Burmese' => 'Burmese', 'Caddo' => 'Caddo', 'Central American Indian (Other)' => 'Central American Indian (Other)', 'Khmer' => 'Khmer', 'Carib' => 'Carib', 'Catalan' => 'Catalan', 'Caucasian (Other)' => 'Caucasian (Other)', 'Cebuano' => 'Cebuano', 'Celtic languages' => 'Celtic languages', 'Chamorro' => 'Chamorro', 'Chibcha' => 'Chibcha', 'Chechen' => 'Chechen', 'Chagatai' => 'Chagatai', 'Chinese' => 'Chinese', 'Chinook jargon' => 'Chinook jargon', 'Choctaw' => 'Choctaw', 'Cherokee' => 'Cherokee', 'Church Slavic' => 'Church Slavic', 'Chuvash' => 'Chuvash', 'Cheyenne' => 'Cheyenne', 'Coptic' => 'Coptic', 'Cornish' => 'Cornish', 'Creoles and Pidgins, English-based (Other)' => 'Creoles and Pidgins, English-based (Other)', 'Creoles and Pidgins, French-based (Other)' => 'Creoles and Pidgins, French-based (Other)', 'Creoles and Pidgins, Portugues-Based (Other)' => 'Creoles and Pidgins, Portugues-Based (Other)', 'Cree' => 'Cree', 'Creoles and Pidgins (Other)' => 'Creoles and Pidgins (Other)', 'Cushitic (Other)' => 'Cushitic (Other)', 'Czech' => 'Czech', 'Dakota' => 'Dakota', 'Danish' => 'Danish', 'Delaware' => 'Delaware', 'Dinka' => 'Dinka', 'Dogri' => 'Dogri', 'Dravidian (Other)' => 'Dravidian (Other)', 'Duala' => 'Duala', 'Dutch, Middle (ca. 1050-1350)' => 'Dutch, Middle (ca. 1050-1350)', 'Dutch' => 'Dutch', 'Dyula' => 'Dyula', 'Efik' => 'Efik', 'Egyptian' => 'Egyptian', 'Ekajuk' => 'Ekajuk', 'Elamite' => 'Elamite', 'English' => 'English', 'English, Middle (1100-1500)' => 'English, Middle (1100-1500)', 'Eskimo Languages' => 'Eskimo Languages', 'Esperanto' => 'Esperanto', 'Estonian' => 'Estonian', 'Ethiopic' => 'Ethiopic', 'Ewe' => 'Ewe', 'Ewondo' => 'Ewondo', 'Fang' => 'Fang', 'Faroese' => 'Faroese', 'Fanti' => 'Fanti', 'Fijian' => 'Fijian', 'Finnish' => 'Finnish', 'Finno-Ugrian (Other)' => 'Finno-Ugrian (Other)', 'Fon' => 'Fon', 'French' => 'French', 'Friesian' => 'Friesian', 'French, Middle (ca. 1400-1600)' => 'French, Middle (ca. 1400-1600)', 'French, Old (ca. 842-1400)' => 'French, Old (ca. 842-1400)', 'Fula' => 'Fula', 'G©' => 'G©', 'Gaelic (Scots)' => 'Gaelic (Scots)', 'Gallegan' => 'Gallegan', 'Oromo' => 'Oromo', 'Gayo' => 'Gayo', 'Germanic (Other)' => 'Germanic (Other)', 'Georgian' => 'Georgian', 'German' => 'German', 'Gilbertese' => 'Gilbertese', 'German, Middle High (ca. 1050-1500)' => 'German, Middle High (ca. 1050-1500)', 'German, Old High (ca. 750-1050)' => 'German, Old High (ca. 750-1050)', 'Gondi' => 'Gondi', 'Gothic' => 'Gothic', 'Grebo' => 'Grebo', 'Greek, Ancient (to 1453)' => 'Greek, Ancient (to 1453)', 'Greek, Modern (1453- )' => 'Greek, Modern (1453- )', 'Guarani' => 'Guarani', 'Gujarati' => 'Gujarati', 'Haida' => 'Haida', 'Hausa' => 'Hausa', 'Hawaiian' => 'Hawaiian', 'Hebrew' => 'Hebrew', 'Herero' => 'Herero', 'Hiligaynon' => 'Hiligaynon', 'Himachali' => 'Himachali', 'Hindi' => 'Hindi', 'Hiri Motu' => 'Hiri Motu', 'Hungarian' => 'Hungarian', 'Hupa' => 'Hupa', 'Iban' => 'Iban', 'Igbo' => 'Igbo', 'Icelandic' => 'Icelandic', 'Ijo' => 'Ijo', 'Iloko' => 'Iloko', 'Indic (Other)' => 'Indic (Other)', 'Indonesian' => 'Indonesian', 'Indo-European (Other)' => 'Indo-European (Other)', 'Interlingua (International Auxiliary Language Association' => 'Interlingua (International Auxiliary Language Association', 'Iranian (Other)' => 'Iranian (Other)', 'Irish' => 'Irish', 'Iroquoian languages' => 'Iroquoian languages', 'Italian' => 'Italian', 'Javanese' => 'Javanese', 'Japanese' => 'Japanese', 'Judeo-Persian' => 'Judeo-Persian', 'Judeo-Arabic' => 'Judeo-Arabic', 'Kara-Kalpak' => 'Kara-Kalpak', 'Kabyle' => 'Kabyle', 'Kachin' => 'Kachin', 'Kamba' => 'Kamba', 'Kannada' => 'Kannada', 'Karen' => 'Karen', 'Kashmiri' => 'Kashmiri', 'Kanuri' => 'Kanuri', 'Kawi' => 'Kawi', 'Kazakh' => 'Kazakh', 'Khasi' => 'Khasi', 'Khoisan (Other)' => 'Khoisan (Other)', 'Khotanese' => 'Khotanese', 'Kikuyu' => 'Kikuyu', 'Kinyarwanda' => 'Kinyarwanda', 'Kirghiz' => 'Kirghiz', 'Konkani' => 'Konkani', 'Kongo' => 'Kongo', 'Korean' => 'Korean', 'Kpelle' => 'Kpelle', 'Kru' => 'Kru', 'Kurukh' => 'Kurukh', 'Kuanyama' => 'Kuanyama', 'Kurdish' => 'Kurdish', 'Kusaie' => 'Kusaie', 'Kutenai' => 'Kutenai', 'Ladino' => 'Ladino', 'Lahnd' => 'Lahnd', 'Lamba' => 'Lamba', 'Langue d¡¯oc (post-1500)' => 'Langue d¡¯oc (post-1500)', 'Lao' => 'Lao', 'Lapp' => 'Lapp', 'Latin' => 'Latin', 'Latvian' => 'Latvian', 'Lingala' => 'Lingala', 'Lithuanian' => 'Lithuanian', 'Mongo' => 'Mongo', 'Lozi' => 'Lozi', 'Luba-Katanga' => 'Luba-Katanga', 'Ganda' => 'Ganda', 'Luiseno' => 'Luiseno', 'Lunda' => 'Lunda', 'Luo (Kenya and Tanzania)' => 'Luo (Kenya and Tanzania)', 'Macedonian' => 'Macedonian', 'Madurese' => 'Madurese', 'Magahi' => 'Magahi', 'Marshall' => 'Marshall', 'Maithili' => 'Maithili', 'Makasar' => 'Makasar', 'Malayalam' => 'Malayalam', 'Mandingo' => 'Mandingo', 'Maori' => 'Maori', 'Austronesian (Other)' => 'Austronesian (Other)', 'Marathi' => 'Marathi', 'Masai' => 'Masai', 'Manx' => 'Manx', 'Malay' => 'Malay', 'Mende' => 'Mende', 'Micmac' => 'Micmac', 'Minangkabau' => 'Minangkabau', 'Miscellaneous (Other)' => 'Miscellaneous (Other)', 'Mon-Khmer (Other)' => 'Mon-Khmer (Other)', 'Malagasy' => 'Malagasy', 'Maltese' => 'Maltese', 'Manipuri' => 'Manipuri', 'Manobo languages' => 'Manobo languages', 'Mohawk' => 'Mohawk', 'Moldavian' => 'Moldavian', 'Mongolian' => 'Mongolian', 'Mossi' => 'Mossi', 'Maliseet' => 'Maliseet', 'Multiple languages' => 'Multiple languages', 'Munda (Other)' => 'Munda (Other)', 'Creek' => 'Creek', 'Marwari' => 'Marwari', 'Mayan languages' => 'Mayan languages', 'Aztec' => 'Aztec', 'North American Indian (Other)' => 'North American Indian (Other)', 'Navajo' => 'Navajo', 'Ndebele (Zimbabwe)' => 'Ndebele (Zimbabwe)', 'Ndonga' => 'Ndonga', 'Nepali' => 'Nepali', 'Newari' => 'Newari', 'Niger-Kordofanian (Other)' => 'Niger-Kordofanian (Other)', 'Niuean' => 'Niuean', 'Norwegian' => 'Norwegian', 'Northern Sotho' => 'Northern Sotho', 'Nubian languages' => 'Nubian languages', 'Nyanja' => 'Nyanja', 'Nyamwezi' => 'Nyamwezi', 'Nyankole' => 'Nyankole', 'Nyoro' => 'Nyoro', 'Nzima' => 'Nzima', 'Ojibwa' => 'Ojibwa', 'Oriya' => 'Oriya', 'Osage' => 'Osage', 'Ossetic' => 'Ossetic', 'Turkish, Ottoman' => 'Turkish, Ottoman', 'Otomian languages' => 'Otomian languages', 'Papuan-Australian (Other)' => 'Papuan-Australian (Other)', 'Pangasinan' => 'Pangasinan', 'Pahlavi' => 'Pahlavi', 'Pampanga' => 'Pampanga', 'Panjabi' => 'Panjabi', 'Papiamento' => 'Papiamento', 'Passamaquoddy' => 'Passamaquoddy', 'Palauan' => 'Palauan', 'Old Persian (ca. 600-400 B.C.)' => 'Old Persian (ca. 600-400 B.C.)', 'Persian' => 'Persian', 'Pali' => 'Pali', 'Polish' => 'Polish', 'Ponape' => 'Ponape', 'Portuguese' => 'Portuguese', 'Prakrit languages' => 'Prakrit languages', 'Provencal, Old (to 1500)' => 'Provencal, Old (to 1500)', 'Pushto' => 'Pushto', 'Quechua' => 'Quechua', 'Rajasthani' => 'Rajasthani', 'Rarotongan' => 'Rarotongan', 'Romance (Other)' => 'Romance (Other)', 'Raeto-Romance' => 'Raeto-Romance', 'Romany' => 'Romany', 'Romanian' => 'Romanian', 'Rundi' => 'Rundi', 'Russian' => 'Russian', 'Sandawe' => 'Sandawe', 'Sango' => 'Sango', 'South American Indian (Other)' => 'South American Indian (Other)', 'Salishan languages' => 'Salishan languages', 'Samaritan Aramaic' => 'Samaritan Aramaic', 'Sanskrit' => 'Sanskrit', 'Samoan' => 'Samoan', 'Serbo-Croatian (Cyrillic)' => 'Serbo-Croatian (Cyrillic)', 'Scots' => 'Scots', 'Serbo-Croatian (Roman)' => 'Serbo-Croatian (Roman)', 'Selkup' => 'Selkup', 'Semitic (Other)' => 'Semitic (Other)', 'Shan' => 'Shan', 'Shona' => 'Shona', 'Sidamo' => 'Sidamo', 'Siouan languages' => 'Siouan languages', 'Sino-Tibetan (Other)' => 'Sino-Tibetan (Other)', 'Slavic (Other)' => 'Slavic (Other)', 'Slovak' => 'Slovak', 'Slovenian' => 'Slovenian', 'Sindhi' => 'Sindhi', 'Sinhalese' => 'Sinhalese', 'Somali' => 'Somali', 'Songhai' => 'Songhai', 'Spanish' => 'Spanish', 'Serer' => 'Serer', 'Sotho' => 'Sotho', 'Sukuma' => 'Sukuma', 'Sudanese' => 'Sudanese', 'Susu' => 'Susu', 'Sumerian' => 'Sumerian', 'Swahili' => 'Swahili', 'Swazi' => 'Swazi', 'Syriac' => 'Syriac', 'Tagalog' => 'Tagalog', 'Tahitian' => 'Tahitian', 'Tajik' => 'Tajik', 'Tamil' => 'Tamil', 'Tatar' => 'Tatar', 'Telugu' => 'Telugu', 'Timne' => 'Timne', 'Tereno' => 'Tereno', 'Thai' => 'Thai', 'Tibetan' => 'Tibetan', 'Tigre' => 'Tigre', 'Tigrinya' => 'Tigrinya', 'Tivi' => 'Tivi', 'Tlingit' => 'Tlingit', 'Tonga (Nyasa)' => 'Tonga (Nyasa)', 'Tonga (Tonga Islands)' => 'Tonga (Tonga Islands)', 'Truk' => 'Truk', 'Tsimshian' => 'Tsimshian', 'Tsonga' => 'Tsonga', 'Tswana' => 'Tswana', 'Turkmen' => 'Turkmen', 'Tumbuka' => 'Tumbuka', 'Turkish' => 'Turkish', 'Altaic (Other)' => 'Altaic (Other)', 'Twi' => 'Twi', 'Ugaritic' => 'Ugaritic', 'Uighur' => 'Uighur', 'Ukrainian' => 'Ukrainian', 'Umbundu' => 'Umbundu', 'Undetermined' => 'Undetermined', 'Urdu' => 'Urdu', 'Uzbek' => 'Uzbek', 'Vai' => 'Vai', 'Venda' => 'Venda', 'Vietnamese' => 'Vietnamese', 'Votic' => 'Votic', 'Wakashan languages' => 'Wakashan languages', 'Walamo' => 'Walamo', 'Waray' => 'Waray', 'Washo' => 'Washo', 'Welsh' => 'Welsh', 'Sorbian languages' => 'Sorbian languages', 'Wolof' => 'Wolof', 'Xhosa' => 'Xhosa', 'Yao' => 'Yao', 'Yap' => 'Yap', 'Yiddish' => 'Yiddish', 'Yoruba' => 'Yoruba', 'Zapotec' => 'Zapotec', 'Zenaga' => 'Zenaga', 'Zulu' => 'Zulu', 'Zuni' => 'Zuni');
echo SelectInput($student['CUSTOM_200000005'], 'values[STUDENTS][CUSTOM_200000005]', 'Language', $language_options, 'N/A', 'style="width:200"');
echo '</TD>';
echo '</TR>';
echo '<TABLE width=100% border=0 cellpadding=3>';
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Información demográfica</b></td></tr>';
echo '<TR><td valign="top">';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px>Nombre</td><td>:</td><td>';
if ($_REQUEST['student_id'] == 'new') {
echo '<TABLE ><TR><TD >' . TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '<FONT color=red>Nombre</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', 'Segundo nombre', 'class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '<FONT color=red>Apellido Paterno</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['SECOND_LAST_NAME'], 'students[SECOND_LAST_NAME]', '<FONT color=red>Apellido Materno</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD></TR></TABLE>';
} else {
echo '<DIV id=student_name><div style="font-size:14px; font-weight:bold;" onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', '', 'size=3 maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', SelectInput($student['NAME_SUFFIX'], 'students[NAME_SUFFIX]', '', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"', false)) . '</TD></TR></TABLE>","student_name",true);\'>' . $student['FIRST_NAME'] . ' ' . $student['MIDDLE_NAME'] . ' ' . $student['LAST_NAME'] . ' ' . $student['SECOND_LAST_NAME'] . ' ' . $student['NAME_SUFFIX'] . '</div></DIV>';
}
echo '</td></tr>';
echo '<tr><td>Fecha aproximada en que se gradua </td><td>:</td><td>' . DateInput($student['ESTIMATED_GRAD_DATE'], 'students[ESTIMATED_GRAD_DATE]', '') . '</td></tr>';
echo '<tr><td>Género<font color=red>*</font></td><td>:</td><td>' . SelectInput($student['GENDER'], 'students[GENDER]', '', array('Male' => 'Masculino', 'Female' => 'Femenino'), 'N/A', '') . '</td></tr>';
//echo '<tr><td>Ethnicity<font color=red>*</font></td><td>:</td><td>'.SelectInput($student['ETHNICITY'],'students[ETHNICITY]','',$ethnic_option,'N/A','').'</td></tr>';
//echo '<tr><td>Common Name</td><td>:</td><td>'.TextInput($student['COMMON_NAME'],'students[COMMON_NAME]','','size=10 class=cell_medium maxlength=10').'</td></tr>';
echo '<tr><td>Fecha de nacimiento<font color=red>*</font></td><td>:</td><td>' . DateInput($student['BIRTHDATE'], 'students[BIRTHDATE]', '') . '</td></tr>';
//echo '<tr><td>Primary Language</td><td>:</td><td>'.SelectInput($student['LANGUAGE'],'students[LANGUAGE]','',$language_option,'N/A','').'</td></tr>';
echo '<tr><td>Email</td><td>:</td><td>' . TextInput($student['EMAIL'], 'students[EMAIL]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
echo '<tr><td>Teléfono</td><td>:</td><td>' . TextInput($student['PHONE'], 'students[PHONE]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
#############################################CUSTOM FIELDS###############################
$fields_RET = DBGet(DBQuery("SELECT ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,REQUIRED,HIDE,SORT_ORDER FROM CUSTOM_FIELDS WHERE SYSTEM_FIELD='N' AND CATEGORY_ID='{$_REQUEST['category_id']}' ORDER BY SORT_ORDER,TITLE"));
if (UserStudentID()) {
$custom_RET = DBGet(DBQuery("SELECT * FROM STUDENTS WHERE STUDENT_ID='" . UserStudentID() . "'"));
$value = $custom_RET[1];
}
if (count($fields_RET)) {
echo $separator;
}
$i = 1;
$q = 0;
foreach ($fields_RET as $field) {
echo '<TD class=vbreak> </TD><TD valign=top>';
if (isset($_REQUEST['school_info_id'])) {
echo "<INPUT type=hidden name=school_info_id value={$_REQUEST['school_info_id']}>";
if ($_REQUEST['school_info_id'] != '0' && $_REQUEST['school_info_id'] !== 'old') {
echo '<TABLE width=100%><TR><TD>';
// open 3a
echo '<FIELDSET><LEGEND><FONT color=gray>Official Information</FONT></LEGEND><TABLE width=100%>';
if (User('PROFILE_ID') == 0 && $prof_check[1]['PROFILE_ID'] == 0 && User('STAFF_ID') == UserStaffID()) {
echo '<TR><td><span class=red>*</span>Category</td><td>:</td><TD style=\\"white-space:nowrap\\"><table cellspacing=0 cellpadding=0 cellspacing=0 cellpadding=0 border=0><tr><td>' . SelectInput($this_school['CATEGORY'], 'values[SCHOOL][CATEGORY]', '', array('Super Administrator' => 'Super Administrator', 'Administrator' => 'Administrator', 'Teacher' => 'Teacher', 'Non Teaching Staff' => 'Non Teaching Staff', 'Custodian' => 'Custodian', 'Principal' => 'Principal', 'Clerk' => 'Clerk'), false) . '</td><td>';
} else {
echo '<TR><td><span class=red>*</span>Category</td><td>:</td><TD style=\\"white-space:nowrap\\"><table cellspacing=0 cellpadding=0 cellspacing=0 cellpadding=0 border=0><tr><td>' . SelectInput($this_school['CATEGORY'], 'values[SCHOOL][CATEGORY]', '', array('Administrator' => 'Administrator', 'Teacher' => 'Teacher', 'Non Teaching Staff' => 'Non Teaching Staff', 'Custodian' => 'Custodian', 'Principal' => 'Principal', 'Clerk' => 'Clerk'), false) . '</td><td>';
}
echo '</td></tr></table></TD></tr>';
echo '<TR><td>Job Title</td><td>:</td><TD>' . TextInput($this_school['JOB_TITLE'], 'values[SCHOOL][JOB_TITLE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td><span class=red>*</span>Joining Date</td><td>:</td><TD>' . DateInput($this_school['JOINING_DATE'], 'values[JOINING_DATE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>End Date</td><td>:</td><TD>' . DateInput($this_school['END_DATE'], 'values[ENDING_DATE]', '', 'class=cell_medium') . '</TD></tr>';
# echo '<TR><td>Termination Reason</td><td>:</td><TD style=\"white-space:nowrap\"><table cellspacing=0 cellpadding=0 cellspacing=0 cellpadding=0 border=0><tr><td>'._makETerminationInput($this_school['TERMINATION_REASON'],'','values[SCHOOL][TERMINATION_REASON]').'</td><td>';
# echo '</td></tr></table></TD></tr>';
echo "<INPUT type=hidden name=values[SCHOOL][HOME_SCHOOL] value=" . UserSchool() . ">";
echo '</TABLE></FIELDSET>';
echo '</TD></TR>';
echo '</TABLE>';
echo '</TD></TR>';
echo '</TABLE>';
echo '<TABLE border=0 width=100%><TR><TD>';
echo '<FIELDSET><LEGEND><FONT color=gray>OpenSIS Access Information</FONT></LEGEND>';
if ($this_school_mod['USERNAME'] && !$this_school['OPENSIS_ACCESS'] == 'Y') {
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') {
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
$return = '<TABLE><TR><TD class=LO_field><b>' . Localize('colon', _('Visible Between')) . '</b></TD><TD align=right>';
$return .= DateInput($value, "values[{$id}][{$name}]") . '</TD><TD width=1> ' . _('to') . ' </TD><TD>';
$return .= DateInput($THIS_RET['END_DATE'], "values[{$id}][END_DATE]") . '</TD></TR>';
$return .= '<TR><TD width=100% colspan=4 bgcolor=black height=1></TD></TR><TR><TD colspan=4>';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM USER_PROFILES ORDER BY ID"));
}
$return .= '<TABLE border=0 cellspacing=0 cellpadding=0 class=LO_field><TR><TD colspan=4><b>' . Localize('colon', _('Visible To')) . '</b></TD></TR>';
foreach (array('admin' => _('Administrator w/Custom'), 'teacher' => _('Teacher w/Custom'), 'parent' => _('Parent w/Custom')) as $profile_id => $profile) {
$return .= "<TD><INPUT type=checkbox name=profiles[{$id}][{$profile_id}] value=Y" . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' CHECKED' : '') . "> {$profile}</TD>";
}
$i = 3;
foreach ($profiles_RET as $profile) {
$i++;
$return .= '<TD><INPUT type=checkbox name=profiles[' . $id . '][' . $profile['ID'] . '] value=Y' . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' CHECKED' : '') . ">" . _($profile[TITLE]) . "</TD>";
if ($i % 4 == 0 && $i != count($profile)) {
$return .= '</TR><TR>';
}
}
for (; $i % 4 != 0; $i++) {
$return .= '<TD></TD>';
}
$return .= '</TR>';
//<TR><TD colspan=4><B><A HREF=#>Schools: ...</A></B></TD></TR></TABLE>';
$return .= '</TABLE>';
$return .= '</TD></TR></TABLE>';
return $return;
}
function _makeEndInputDateenrl($value, $column)
{
global $THIS_RET;
$drop_codes = array();
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
}
if (!$THIS_RET['ID']) {
$id = 'new';
}
if ($value['DROP_CODE'] == '') {
$date_field = '<TABLE class=LO_field><TR><TD>' . DateInput($value, 'values[student_enrollment][' . $id . '][' . $column . ']', '', true, true) . '</TD></TR></TABLE>';
}
if ($value['DROP_CODE'] != '') {
$date_field = '<TABLE class=LO_field><TR><TD>' . DateInput($value, 'values[student_enrollment][' . $id . '][' . $column . ']', '', true, false) . '</TD></TR></TABLE>';
}
// student_enrollment select create here
#return '<TABLE class=LO_field><TR><TD>'.DateInput($value,'values[student_enrollment]['.$id.']['.$column.']').'</TD></TR></TABLE>';
if ($THIS_RET['SYEAR'] == UserSyear()) {
return $date_field;
} else {
if ($value == '') {
return "N/A";
} else {
return $value;
}
}
}
$title .= '<br><br> <span align="center">' . _('Teacher Re-Assignment Done') . ' <a href="#" onclick="load_link(\'Modules.php?modname=' . $_REQUEST['modname'] . '&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id'] . '&course_period_id=' . $_REQUEST['course_period_id'] . '&action=undo\')">' . _('Undo') . '</a></span>';
}
echo "<FORM name=F2 id=F2 action=Modules.php?modname={$_REQUEST['modname']}&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}&course_period_id={$_REQUEST['course_period_id']} method=POST>";
DrawHeaderHome($title, SubmitButton(_('Save') . '', '', 'class=btn_medium onclick="formcheck_teacher_reassignment();"'));
$header .= '<TABLE cellpadding=3 width=760 >';
$header .= '<TR>';
$header .= '<TD>' . _('Select New') . _(' ') . _('Teacher') . ' :</TD>';
$teachers_RET = DBGet(DBQuery('SELECT STAFF_ID,LAST_NAME,FIRST_NAME,MIDDLE_NAME FROM staff st INNER JOIN staff_school_relationship ssr USING (staff_id) WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND PROFILE=\'teacher\' AND staff_id <>\'' . $RET['TEACHER_ID'] . '\' AND (IS_DISABLE IS NULL OR IS_DISABLE<>\'Y\') ORDER BY LAST_NAME,FIRST_NAME '));
if (count($teachers_RET)) {
foreach ($teachers_RET as $teacher) {
$teachers[$teacher['STAFF_ID']] = $teacher['LAST_NAME'] . ', ' . $teacher['FIRST_NAME'] . ' ' . $teacher['MIDDLE_NAME'];
}
}
$header .= '<TD>' . SelectInput('', 're_assignment_teacher', '', $teachers) . '</TD>';
$header .= '<TD>' . _('Assign') . _(' ') . _('Date') . ' :</TD>';
$header .= '<TD>' . DateInput('', 're_assignment', '', false) . '</TD>';
$header .= '<TD><TD><input type=hidden name=course_period_id value=' . $_REQUEST['course_period_id'] . '><input type=hidden name=re_assignment_pre_teacher value=' . $RET['TEACHER_ID'] . '></TD>';
$header .= '</TR></TABLE>';
DrawHeaderHome(_($header));
echo '</FORM>';
//--------------------------------------------Re Assignment Record-------------------------------------------------------------
$sql = 'SELECT COURSE_PERIOD_ID,(SELECT CONCAT_WS(\' \',last_name,middle_name,first_name) FROM staff WHERE staff_id=teacher_id) AS TEACHER,ASSIGN_DATE,(SELECT CONCAT_WS(\' \',last_name,middle_name,first_name) FROM staff WHERE staff_id=pre_teacher_id) AS PRE_TEACHER_ID,MODIFIED_DATE,(SELECT CONCAT_WS(\' \',last_name,first_name) FROM staff WHERE staff_id=modified_by) AS MODIFIED_BY FROM teacher_reassignment WHERE course_period_id=\'' . $_REQUEST['course_period_id'] . '\' ORDER BY assign_date DESC';
$QI = DBQuery($sql);
$courses_RET = DBGet($QI, array('ASSIGN_DATE' => 'ProperDAte', 'MODIFIED_DATE' => 'ProperDate'));
echo '<TABLE width=100%><TR><TD valign=top>';
$LO_options = array('save' => false, 'search' => false);
$columns = array('TEACHER' => '' . _('Teacher') . '', 'ASSIGN_DATE' => '' . _('Assign Date') . '', 'PRE_TEACHER_ID' => '' . _('Previous Teacher') . '', 'MODIFIED_DATE' => '' . _('Modified Date') . '', 'MODIFIED_BY' => '' . _('Modified By') . '');
$link = array();
$link['TITLE']['variables'] = array('course_id' => 'COURSE_ID');
ListOutput($courses_RET, $columns, _('Re-Assignment Record'), _('Re-Assignment Records'), $link, array(), $LO_options);
echo '</TD></TR></TABLE>';
if ($_REQUEST['marking_period_id']) {
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&mp_term=' . $_REQUEST['mp_term'] . '&marking_period_id=' . $_REQUEST['marking_period_id'] . '&year_id=' . $_REQUEST['year_id'] . '&semester_id=' . $_REQUEST['semester_id'] . '&quarter_id=' . $_REQUEST['quarter_id'] . '" method="POST">';
DrawHeader($title, AllowEdit() ? $delete_button . SubmitButton(_('Save')) : '');
$header .= '<TABLE class="width-100p cellpadding-3">';
$header .= '<TR>';
$header .= '<TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['marking_period_id'] . '][TITLE]', (!$RET['TITLE'] ? '<span style="color:red">' : '') . _('Title') . (!$RET['TITLE'] ? '</span>' : ''), 'required') . '</TD>';
$header .= '<TD>' . TextInput($RET['SHORT_NAME'], 'tables[' . $_REQUEST['marking_period_id'] . '][SHORT_NAME]', (!$RET['SHORT_NAME'] ? '<span style="color:red">' : '') . _('Short Name') . (!$RET['SHORT_NAME'] ? '</span>' : ''), 'required') . '</TD>';
$header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', _('Sort Order'), 'size=3') . '</TD>';
$header .= '<TD><TABLE class="width-100p cellpadding-0"><TR><TD>' . CheckboxInput($RET['DOES_GRADES'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_GRADES]', _('Graded'), $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC="assets/check.png" height="15">', '<IMG SRC="assets/x.png" height="15">') . '</TD>';
$header .= '<TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', _('Comments'), $checked, $_REQUEST['marking_period_id'] == 'new', '<IMG SRC="assets/check.png" height="15">', '<IMG SRC="assets/x.png" height="15">') . '</TD></TR></TABLE></TD>';
$header .= '</TR>';
$header .= '<TR>';
$header .= '<TD>' . DateInput($RET['START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][START_DATE]', (!$RET['START_DATE'] ? '<span style="color:red">' : '') . _('Begins') . (!$RET['START_DATE'] ? '</span>' : '')) . '</TD>';
$header .= '<TD>' . DateInput($RET['END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][END_DATE]', (!$RET['END_DATE'] ? '<span style="color:red">' : '') . _('Ends') . (!$RET['END_DATE'] ? '</span>' : '')) . '</TD>';
$header .= '<TD>' . DateInput($RET['POST_START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_START_DATE]', ($RET['DOES_GRADES'] && !$RET['POST_START_DATE'] ? '<span style="color:red">' : '') . _('Grade Posting Begins') . ($RET['DOES_GRADES'] && !$RET['POST_START_DATE'] ? '</span>' : '')) . '</TD>';
$header .= '<TD>' . DateInput($RET['POST_END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_END_DATE]', ($RET['DOES_GRADES'] && !$RET['POST_END_DATE'] ? '<span style="color:red">' : '') . _('Grade Posting Ends') . ($RET['DOES_GRADES'] && !$RET['POST_END_DATE'] ? '</span>' : '')) . '</TD>';
$header .= '</TR>';
$header .= '</TABLE>';
DrawHeader($header);
echo '</FORM>';
unset($_SESSION['_REQUEST_vars']['marking_period_id']);
unset($_SESSION['_REQUEST_vars']['mp_term']);
}
// DISPLAY THE MENU
$LO_options = array('save' => false, 'search' => false);
echo '<TABLE><TR>';
// FY
$sql = "SELECT MARKING_PERIOD_ID,TITLE FROM SCHOOL_MARKING_PERIODS WHERE MP='FY' AND SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY SORT_ORDER";
$QI = DBQuery($sql);
$fy_RET = DBGet($QI);
if (count($fy_RET)) {
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
//modif Francois: remove LO_field
$return = '<TABLE class="cellpadding-0 cellspacing-0"><TR><TD><b>' . Localize('colon', _('Visible Between')) . '</b></TD><TD style="text-align:right">';
$return .= DateInput($value, "values[{$id}][{$name}]") . '</TD><TD> ' . _('to') . ' </TD><TD>';
$return .= DateInput($THIS_RET['END_DATE'], "values[{$id}][END_DATE]") . '</TD></TR>';
//modif Francois: css WPadmin
$return .= '<TR><TD colspan="4" style="padding:0">';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM USER_PROFILES ORDER BY ID WHERE"));
}
$return .= '<TABLE class="width-100p cellspacing-0 cellpadding-0"><TR><TD colspan="4"><b>' . Localize('colon', _('Visible To')) . '</b></TD></TR><TR>';
foreach (array('admin' => _('Administrator w/Custom'), 'teacher' => _('Teacher w/Custom'), 'parent' => _('Parent w/Custom')) as $profile_id => $profile) {
//modif Francois: add <label> on checkbox
$return .= '<TD><label><INPUT type="checkbox" name="profiles[$id][' . $profile_id . ']" value="Y"' . (mb_strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' checked' : '') . ' /> ' . $profile . '</label></TD>';
}
//modif Francois: Portal Polls add students teacher
$teachers_RET = DBGet(DBQuery("SELECT STAFF_ID,LAST_NAME,FIRST_NAME,MIDDLE_NAME FROM STAFF WHERE (SCHOOLS IS NULL OR STRPOS(SCHOOLS,'," . UserSchool() . ",')>0) AND SYEAR='" . UserSyear() . "' AND PROFILE='teacher' ORDER BY LAST_NAME,FIRST_NAME"));
if (count($teachers_RET)) {
foreach ($teachers_RET as $teacher) {
$teachers[$teacher['STAFF_ID']] = $teacher['LAST_NAME'] . ', ' . $teacher['FIRST_NAME'];
}
}
$i = 0;
foreach ($profiles_RET as $profile) {
$i++;
if ($profile['ID'] == 0) {
//student
$return .= '</TR><TR>';
}
$return .= '<TD><label><INPUT type="checkbox" name="profiles[' . $id . '][' . $profile['ID'] . ']" value="Y"' . (mb_strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' checked' : '') . ' /> ' . _($profile['TITLE']);
//modif Francois: Portal Polls add students teacher
if ($profile['ID'] == 0) {
$return .= ': </label></TD>';
$return .= '<TD colspan="2">' . SelectInput($THIS_RET['STUDENTS_TEACHER_ID'], 'values[' . $id . '][STUDENTS_TEACHER_ID]', _('Limit to Teacher'), $teachers, true, '', true) . '</TD>';
$i = $i + 2;
} else {
$return .= '</label></TD>';
}
if ($i % 3 == 0 && $i != count($profile)) {
$return .= '</TR><TR>';
}
}
for (; $i % 3 != 0; $i++) {
$return .= '<TD> </TD>';
}
$return .= '</TR>';
$return .= '</TABLE>';
$return .= '</TD></TR></TABLE>';
return $return;
}
//echo '<INPUT type=TEXT name=values[CATEGORY_'.$category['ID'].'] value="'.$RET['CATEGORY_'.$category['ID']].'" maxlength=255>';
break;
case 'numeric':
echo TextInput($RET['CATEGORY_' . $category['ID']], 'values[CATEGORY_' . $category['ID'] . ']', '', 'size=4 maxlength=10');
//echo '<INPUT type=TEXT name=values[CATEGORY_'.$category['ID'].'] value="'.$RET['CATEGORY_'.$category['ID']].'" size=4 maxlength=10>';
break;
case 'textarea':
echo TextAreaInput($RET['CATEGORY_' . $category['ID']], 'values[CATEGORY_' . $category['ID'] . ']', '', !$_REQUEST['_FOCUS_PDF'] ? 'rows=4 cols=30' : 'rows=4 cols=100');
//echo '<TEXTAREA name=values[CATEGORY_'.$category['ID'].'] rows=4 cols=30>'.$RET['CATEGORY_'.$category['ID']].'</TEXTAREA>';
break;
case 'checkbox':
echo CheckboxInput($RET['CATEGORY_' . $category['ID']], 'values[CATEGORY_' . $category['ID'] . ']');
//echo '<INPUT type=CHECKBOX name=values[CATEGORY_'.$category['ID'].'] value=Y'.($RET['CATEGORY_'.$category['ID']]=='Y'?' CHECKED':'').'>';
break;
case 'date':
echo DateInput($RET['CATEGORY_' . $category['ID']], 'values[CATEGORY_' . $category['ID'] . ']');
//echo PrepareDate($RET['CATEGORY_'.$category['ID']],'_values[CATEGORY_'.$category['ID'].']');
break;
case 'multiple_checkbox':
if (AllowEdit() && !$_REQUEST['_FOCUS_PDF']) {
echo "<DIV id='divvalues[CATEGORY_" . $category['ID'] . ']' . "'><div onclick='javascript:addHTML(\"";
$category['SELECT_OPTIONS'] = str_replace("\n", "\r", str_replace("\r\n", "\r", $category['SELECT_OPTIONS']));
$options = explode("\r", $category['SELECT_OPTIONS']);
echo '<TABLE border=0 cellpadding=3><TR>';
$i = 0;
foreach ($options as $option) {
if ($i % 3 == 0) {
echo '</TR><TR>';
}
echo '<TD><INPUT type=checkbox name=values[CATEGORY_' . $category['ID'] . '][] value=\\"' . str_replace('"', '"', str_replace("'", '’', $option)) . '\\"' . (strpos($RET['CATEGORY_' . $category['ID']], str_replace('"', '"', str_replace("'", '’', $option))) !== false ? ' CHECKED' : '') . '><small>' . str_replace("'", '’', $option) . '</small></TD>';
$i++;
//{
echo TextInput($staff['ALTERNATE_ID'], 'staff[ALTERNATE_ID]', '', 'size=12 maxlength=100 class=cell_floating ') . '</td></tr>';
//echo NoInput('Will automatically be assigned','');
// echo '<span id="ajax_output_stid"></span>';
//}
//else
//{
// echo NoInput(str_repeat('*',strlen($staff['ALTERNATE_ID'])),'','','class=cell_medium').'</td></tr>';
////echo NoInput($staff['ALTERNATE_ID'],'','','size=10 class=cell_medium maxlength=10').'</td></tr>';
//}
$options = array('Dr.' => 'Dr.', 'Mr.' => 'Mr.', 'Ms.' => 'Ms.', 'Rev.' => 'Rev.', 'Miss.' => 'Miss.');
echo '<tr><td><span class=red></span>Gender</td><td>:</td><td>' . SelectInput($staff['GENDER'], 'staff[GENDER]', '', array('Male' => 'Male', 'Female' => 'Female'), 'N/A', '') . '</td></tr>';
echo '<tr><td><span class=red></span>Date of Birth</td><td>:</td><td>';
//if($_REQUEST['staff_id']=='new')
//{
echo DateInput($staff['BIRTHDATE'], 'staff[BIRTHDATE]', '') . '</td></tr>';
//}
//else
//{
// echo NoInput(str_repeat('*',strlen($staff['BIRTHDATE'])),'','','class=cell_medium').'</td></tr>';
//}
$ETHNICITY_RET = DBGet(DBQuery("SELECT ETHNICITY_ID,ETHNICITY_NAME FROM ethnicity ORDER BY SORT_ORDER"));
foreach ($ETHNICITY_RET as $ethnicity_array) {
$ethnicity[$ethnicity_array['ETHNICITY_ID']] = $ethnicity_array['ETHNICITY_NAME'];
}
echo '<tr><td><span class=red></span>Ethnicity</td><td>:</td><td>' . SelectInput($staff['ETHNICITY_ID'], 'staff[ETHNICITY_ID]', '', $ethnicity, 'N/A', '') . '</td></tr>';
$LANGUAGE_RET = DBGet(DBQuery("SELECT LANGUAGE_ID,LANGUAGE_NAME FROM language ORDER BY SORT_ORDER"));
foreach ($LANGUAGE_RET as $language_array) {
$language[$language_array['LANGUAGE_ID']] = $language_array['LANGUAGE_NAME'];
}
echo '<tr><td><span class=red></span>Primary Language</td><td>:</td><td>' . SelectInput($staff['PRIMARY_LANGUAGE_ID'], 'staff[PRIMARY_LANGUAGE_ID]', '', $language, 'N/A', '') . '</td></tr>';
function _makeAssnInput($value, $name)
{
global $THIS_RET, $type_options;
if ($THIS_RET['ASSIGNMENT_ID']) {
$id = $THIS_RET['ASSIGNMENT_ID'];
} else {
$id = 'new';
}
if ($name == 'TITLE') {
if ($id != 'new' && !$value) {
$title = '<FONT color=red>' . _('Title') . '</FONT>';
}
$extra = 'size=25 maxlength=100';
} elseif ($name == 'POINTS') {
if ($id != 'new' && $value == '') {
$title = '<FONT color=red>' . _('Points') . '</FONT>';
}
$extra = 'size=5 maxlength=5';
} elseif ($name == 'ASSIGNED_DATE') {
return DateInput($id == 'new' && Preferences('DEFAULT_ASSIGNED', 'Gradebook') == 'Y' ? DBDate() : $value, "values[{$id}][ASSIGNED_DATE]", $THIS_RET['ASSIGNED_ERROR'] == 'Y' ? '<FONT color=red>' . _('Assigned date is after end of quarter!') . '</FONT>' : ($THIS_RET['DATE_ERROR'] == 'Y' ? '<FONT color=red>' . _('Assigned date is after due date!') . '</FONT>' : ''), $id != 'new');
} elseif ($name == 'DUE_DATE') {
return DateInput($id == 'new' && Preferences('DEFAULT_DUE', 'Gradebook') == 'Y' ? DBDate() : $value, "values[{$id}][DUE_DATE]", $THIS_RET['DUE_ERROR'] == 'Y' ? '<FONT color=red>' . _('Due date is after end of quarter!') . '</FONT>' : ($THIS_RET['DATE_ERROR'] == 'Y' ? '<FONT color=red>' . _('Due date is before assigned date!') . '</FONT>' : ''), $id != 'new');
} elseif ($name == 'COURSE_ID') {
return CheckboxInput($value, "values[{$id}][COURSE_ID]", '', '', $id == 'new');
} elseif ($name == 'DESCRIPTION') {
$extra = 'size=25 maxlength=1000';
} elseif ($name == 'ASSIGNMENT_TYPE_ID') {
return SelectInput($value, "values[{$id}][ASSIGNMENT_TYPE_ID]", '', $type_options, false);
}
return TextInput($value, "values[{$id}][{$name}]", $title, $extra);
}
$header .= '<TR>';
$header .= "<TD> </TD><TD align=right><a href='Modules.php?modname=Students/Student.php&include=Goal&category_id=5&action=delete_goal&gid=" . $_REQUEST['goal_id'] . "'>Delete This Goal</a></TD>";
// DateInput is copied from School_Setup/MarkingPeriods.php line 295
$header .= '</TR>';
}
}
# ------------------------------ Delete ---------------------------------------- #
$header .= '<TR>';
$header .= '<TD>Goal Title</TD><TD>' . TextInput($RET['GOAL_TITLE'], 'tables[GOAL][' . $_REQUEST['goal_id'] . '][GOAL_TITLE]', '', 'size=75 maxlength=50') . '</TD>';
$header .= '</TR>';
$header .= '<TR>';
$header .= '<TD>Begin Date</TD><TD>' . DateInput($RET['START_DATE'], 'tables[' . $_REQUEST['goal_id'] . '][START_DATE]', '') . '</TD>';
// DateInput is copied from School_Setup/MarkingPeriods.php line 295
$header .= '</TR>';
$header .= '<TR>';
$header .= '<TD>End Date</TD><TD>' . DateInput($RET['END_DATE'], 'tables[' . $_REQUEST['goal_id'] . '][END_DATE]', '') . '</TD>';
// DateInput is copied from School_Setup/MarkingPeriods.php line 296
$header .= '</TR>';
$header .= '<TR>';
$header .= '<TD valign=top>Goal Description</TD><TD>' . TextAreaInput($RET['GOAL_DESCRIPTION'], 'tables[GOAL][' . $_REQUEST['goal_id'] . '][GOAL_DESCRIPTION]', '', 'rows=10 cols=70', 'true', '200px') . '<input type="hidden" name="tabl" id="tabl" value="goal"></TD>';
$header .= '</TR>';
$header .= '</TABLE>';
DrawHeader($header);
}
}
// DISPLAY THE MENU
$LO_options = array('save' => false, 'search' => false);
if (!$_REQUEST['goal_id'] || $_REQUEST['modfunc'] == 'choose_course') {
DrawHeaderHome('Goals', "<A HREF=for_window.php?modname=Students/Student.php&include=Goal&modfunc={$_REQUEST['modfunc']}&course_modfunc=search>Search</A>");
}
echo '<TABLE><TR>';
$RET = DBGet(DBQuery("SELECT TITLE,DESCRIPTION,DATE_FORMAT(SCHOOL_DATE,'%d-%b-%y') AS SCHOOL_DATE FROM CALENDAR_EVENTS WHERE ID='{$_REQUEST['event_id']}'"));
$title = $RET[1]['TITLE'];
} else {
$title = 'New Event';
$RET[1]['SCHOOL_DATE'] = $_REQUEST['school_date'];
}
echo "<FORM name=popform id=popform action=for_window.php?modname={$_REQUEST['modname']}&dd={$_REQUEST['school_date']}&modfunc=detail&event_id={$_REQUEST['event_id']}&month={$_REQUEST['month']}&year={$_REQUEST['year']} METHOD=POST>";
} else {
$RET = DBGet(DBQuery("SELECT TITLE,STAFF_ID,DATE_FORMAT(DUE_DATE,'%d-%b-%y') AS SCHOOL_DATE,DESCRIPTION FROM GRADEBOOK_ASSIGNMENTS WHERE ASSIGNMENT_ID='{$_REQUEST['assignment_id']}'"));
$title = $RET[1]['TITLE'];
$RET[1]['STAFF_ID'] = GetTeacher($RET[1]['STAFF_ID']);
}
echo '<BR>';
PopTableforWindow('header', $title);
echo '<TABLE>';
echo '<TR><TD>Date</TD><TD>' . DateInput($RET[1]['SCHOOL_DATE'], 'values[SCHOOL_DATE]', '', true) . '</TD></TR>';
echo '<TR><TD>Title</TD><TD>' . TextInput($RET[1]['TITLE'], 'values[TITLE]') . '</TD></TR>';
if ($RET[1]['STAFF_ID']) {
echo '<TR><TD>Teacher</TD><TD>' . TextAreaInput($RET[1]['STAFF_ID'], 'values[STAFF_ID]') . '</TD></TR>';
}
echo '<TR><TD>Notes</TD><TD>' . TextAreaInput($RET[1]['DESCRIPTION'], 'values[DESCRIPTION]') . '</TD></TR>';
if (AllowEdit()) {
echo '<TR><TD colspan=2 align=center><INPUT type=submit class=btn_medium name=button value=Save onclick="formload_ajax(\\"popform\\");">';
echo ' ';
if ($_REQUEST['event_id'] != 'new') {
echo '<INPUT type=submit name=button class=btn_medium value=Delete onclick="formload_ajax(\\"popform\\");">';
}
echo '</TD></TR>';
}
echo '</TABLE>';
PopTableWindow('footer');
function _makeEndInput($value, $column)
{
global $THIS_RET, $drop_codes;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if (!$drop_codes) {
$options_RET = DBGet(DBQuery("SELECT ID,TITLE AS TITLE FROM STUDENT_ENROLLMENT_CODES WHERE SYEAR='" . UserSyear() . "' AND TYPE='Drop'"));
if ($options_RET) {
foreach ($options_RET as $option) {
$drop_codes[$option['ID']] = $option['TITLE'];
}
}
}
return '<TABLE class=LO_field><TR><TD>' . DateInput($value, 'values[STUDENT_ENROLLMENT][' . $id . '][' . $column . ']') . '</TD><TD> - </TD><TD>' . SelectInput($THIS_RET['DROP_CODE'], 'values[STUDENT_ENROLLMENT][' . $id . '][DROP_CODE]', '', $drop_codes, 'N/A', 'style="max-width:150;"') . '</TD></TR></TABLE>';
}
echo "&assignment_id={$_REQUEST['assignment_id']}";
}
echo "&table=gradebook_assignments method=POST>";
DrawHeader($title, $delete_button . '<INPUT type=submit value=' . _('Save') . ' onclick="formcheck_assignments();">');
$header .= '<TABLE cellpadding=3 bgcolor=#F0F0F1 width=100%>';
$header .= '<TR>';
$header .= '<TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['assignment_id'] . '][TITLE]', ($RET['TITLE'] ? '' : '<FONT color=red>') . '' . _('Title') . '' . ($RET['TITLE'] ? '' : '</FONT>'), 'size=36') . '</TD>';
$header .= '<TD>' . TextInput($RET['POINTS'], 'tables[' . $_REQUEST['assignment_id'] . '][POINTS]', ($RET['POINTS'] != '' ? '' : '<FONT color=red>') . '' . _('Points') . '' . ($RET['POINTS'] ? '' : '</FONT>'), ' size=4 maxlength=4') . '</TD>';
$header .= '<TD>' . CheckboxInput($RET['COURSE_ID'], 'tables[' . $_REQUEST['assignment_id'] . '][COURSE_ID]', '' . _('Apply to all Periods for this Course') . '') . '</TD>';
foreach ($types_RET as $type) {
$assignment_type_options[$type['ASSIGNMENT_TYPE_ID']] = $type['TITLE'];
}
$header .= '<TD>' . SelectInput($RET['ASSIGNMENT_TYPE_ID'] ? $RET['ASSIGNMENT_TYPE_ID'] : $_REQUEST['assignment_type_id'], 'tables[' . $_REQUEST['assignment_id'] . '][ASSIGNMENT_TYPE_ID]', '' . _('Assignment Type') . '', $assignment_type_options, false) . '</TD>';
$header .= '</TR><TR>';
$header .= '<TD valign=top>' . DateInput($new && Preferences('DEFAULT_ASSIGNED', 'Gradebook') == 'Y' ? DBDate() : $RET['ASSIGNED_DATE'], 'tables[' . $_REQUEST['assignment_id'] . '][ASSIGNED_DATE]', '' . _('Assigned') . '', !$new) . '</TD>';
$header .= '<TD valign=top>' . DateInput($new && Preferences('DEFAULT_DUE', 'Gradebook') == 'Y' ? DBDate() : $RET['DUE_DATE'], 'tables[' . $_REQUEST['assignment_id'] . '][DUE_DATE]', '' . _('Due') . '', !$new) . '</TD>';
$header .= '<TD rowspan=2 colspan=2>' . TextareaInput($RET['DESCRIPTION'], 'tables[' . $_REQUEST['assignment_id'] . '][DESCRIPTION]', '' . _('Description') . '') . '</TD>';
$header .= '</TR>';
// $header .= '<TR><TD valign=top colspan=2>'.($RET['DATE_ERROR']=='Y'?'<Font color=red>Due date earlier than assigned date!</FONT>':'').'</TD></TR>';
$header .= '</TABLE>';
} elseif ($_REQUEST['assignment_type_id']) {
echo "<FORM name=F3 action=Modules.php?modname={$_REQUEST['modname']}&table=gradebook_assignment_types";
if ($_REQUEST['assignment_type_id'] != 'new') {
echo "&assignment_type_id={$_REQUEST['assignment_type_id']}";
}
echo " method=POST>";
DrawHeader($title, $delete_button . '<INPUT type=submit value=' . _('Save') . ' onclick="formcheck_assignments();">');
$header .= '<TABLE cellpadding=3 bgcolor=#F0F0F1 width=100%>';
$header .= '<TR>';
$header .= '<TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['assignment_type_id'] . '][TITLE]', '' . _('Title') . '', 'size=36') . '</TD>';
if ($programconfig['WEIGHT'] == 'Y') {
function makeDateInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
return DateInput($value, 'values[' . $id . '][' . $name . ']');
}
function _makeEndInputDate($value, $column)
{
global $THIS_RET;
$drop_codes = array();
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
// student_enrollment select create here
$maxyear = DBGet(DBQuery('SELECT max(syear) AS SYEAR FROM student_enrollment WHERE STUDENT_ID=\'' . UserStudentID() . '\''));
if ($THIS_RET['SYEAR'] == $maxyear[1]['SYEAR']) {
return '<TABLE class=LO_field><TR><TD>' . DateInput($value, 'values[student_enrollment][' . $id . '][' . $column . ']') . '</TD></TR></TABLE>';
} else {
if ($value) {
return '<TABLE class=LO_field><TR><TD>' . date('M/d/Y', strtotime($value)) . '</TD></TR></TABLE>';
} else {
return '<TABLE class=LO_field><TR><TD>Na/Na/Na</TD></TR></TABLE>';
}
}
}
function Prompt_rollover($title = 'Confirm', $question = '', $message = '', $pdf = '')
{
$tmp_REQUEST = $_REQUEST;
unset($tmp_REQUEST['delete_ok']);
if ($pdf == true) {
$tmp_REQUEST['_openSIS_PDF'] = true;
}
$PHP_tmp_SELF = PreparePHP_SELF($tmp_REQUEST);
if (!$_REQUEST['delete_ok'] && !$_REQUEST['delete_cancel']) {
PopTable('header', $title);
// echo "<CENTER><h4>$question</h4><FORM name=roll_over id=roll_over action=$PHP_tmp_SELF&delete_ok=1 METHOD=POST>$message<BR><BR><INPUT type=submit class=btn_medium value=OK onclick=\"document.roll_over.submit();\"> <INPUT type=button class=btn_medium name=delete_cancel value=Cancel onclick='javascript:history.go(-1);'></FORM></CENTER>";
echo "<CENTER><h4>{$question}</h4><FORM name=roll_over id=roll_over action={$PHP_tmp_SELF}&delete_ok=1 METHOD=POST>";
echo '<BR><font color=red>Caution : </font>Rollover is an irreversible process. If you are sure you want to proceed, type in the <BR>effective roll over date below. You can use the next school year’s attendance start date.<BR><BR>';
echo '<table><tr><td>Student Enrollment Date:</td><td>';
echo DateInput('', 'roll_start_date', '');
echo '<td></tr>';
echo '<tr><td>';
// echo '<input type=checkbox id=custom_date name=custom_date value=Y onClick="show_date_picker();" >';
echo '<input type=hidden id=custom_date name=custom_date value=Y></td></tr>';
// echo 'Input Custom Start Date And End Date</td></tr>';
echo '</table>';
echo '<input type=hidden id=check_click value=1>';
// echo '<div id=show_date_range style="display:none">';
echo '<hr>';
echo '<b>Enter next school year’s begin and end dates</b>';
echo '<br>';
echo '<table></td></tr><td>School Begin Date :</td>';
echo '<td>' . DateInput('', 'roll_school_start_date', '') . '</td>';
echo '<tr><td>School End Date :</td><td>' . DateInput('', 'roll_school_end_date', '') . '</td></tr></table>';
echo '<hr>';
$prev_st_d = DBGet(DBQuery('SELECT END_DATE FROM school_years WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' '));
echo '<input type=hidden id=prev_start_date value=' . $prev_st_d[1]['END_DATE'] . ' >';
$check_ss = DBGet(DBQuery('SELECT * FROM school_semesters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY MARKING_PERIOD_ID'));
if (count($check_ss) > 0) {
$i = 4;
$j = 4;
$t = 0;
$q = 0;
$p = 0;
$sem = 0;
$qrtr = 0;
$prog = 0;
foreach ($check_ss as $ss_i => $ss_d) {
$sem++;
echo '<table></td></tr><td>' . $ss_d['TITLE'] . ' Begin Date :</td>';
echo '<td>' . DateInput('', 'sem_start_' . $sem, '');
echo '<input type=hidden id=name_' . $j . ' value="' . $ss_d['TITLE'] . ' Begin Date" ></td>';
$j++;
echo '<tr><td>' . $ss_d['TITLE'] . ' End Date :</td><td>' . DateInput('', 'sem_end_' . $sem, '');
echo '<input type=hidden id=name_' . $j . ' value="' . $ss_d['TITLE'] . ' End Date" ></td></tr></table>';
$check_sq = DBGet(DBQuery('SELECT * FROM school_quarters WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND SEMESTER_ID=\'' . $ss_d['MARKING_PERIOD_ID'] . '\' '));
if (count($check_sq) > 0) {
$q = $j + 1;
$q_val = '';
$p_val = '';
foreach ($check_sq as $sq_i => $sq_d) {
$qrtr++;
echo '<table></td></tr><td>' . $sq_d['TITLE'] . ' Begin Date :</td>';
echo '<td>' . DateInput('', 'qrtr_start_' . $qrtr, '');
echo '<input type=hidden id=name_' . $q . ' value="' . $sq_d['TITLE'] . ' Begin Date" ></td>';
$q_val .= $q . '`';
$q++;
$q_val .= $q . '-';
echo '<tr><td>' . $sq_d['TITLE'] . ' End Date :</td><td>' . DateInput('', 'qrtr_end_' . $qrtr, '');
echo '<input type=hidden id=name_' . $q . ' value="' . $sq_d['TITLE'] . ' End Date" ></td></tr></table>';
// echo '<input type=text name=qrt_count id=qrt_count value='.$i.'>';
$check_sp = DBGet(DBQuery('SELECT * FROM school_progress_periods WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND QUARTER_ID=\'' . $sq_d['MARKING_PERIOD_ID'] . '\' '));
if (count($check_sp) > 0) {
$p = $q + 1;
$max = count($check_sp);
foreach ($check_sp as $sp_i => $sp_d) {
$prog++;
echo '<table></td></tr><td>' . $sp_d['TITLE'] . ' Begin Date :</td>';
echo '<td>' . DateInput('', 'prog_start_' . $prog, '');
echo '<input type=hidden id=name_' . $p . ' value="' . $sp_d['TITLE'] . ' Begin Date" ></td>';
$p_val .= $p . '`';
$p++;
if ($sp_i != $max) {
$p_val .= $p . '^';
} else {
$p_val .= $p . '-';
}
echo '<tr><td>' . $sp_d['TITLE'] . ' End Date :</td><td>' . DateInput('', 'prog_end_' . $prog, '');
echo '<input type=hidden id=name_' . $p . ' value="' . $sp_d['TITLE'] . ' End Date" ></td></tr></table>';
$p++;
}
// echo '<input type=text name=prg_count id=prg_count value='.$i.'>';
}
if ($p != 0) {
$q = $p;
} else {
$q++;
}
}
}
$t++;
echo '<input type=hidden id=round_' . $t . ' value=' . $j . '>';
$q_val = substr($q_val, 0, -1);
echo '<input type=hidden id=quarter_' . $t . ' value=' . $q_val . '>';
$p_val = substr($p_val, 0, -1);
echo '<input type=hidden id=progress_' . $t . ' value=' . $p_val . '>';
echo '<hr>';
if ($q != 0) {
$j = $q;
} else {
$j++;
}
echo '<input type=hidden id=roll_' . $t . ' value=' . $j . '>';
}
echo '<input type=hidden name=tot_round id=tot_round value=' . $t . '>';
echo '<input type=hidden name=total_sem value=' . $sem . '>';
echo '<input type=hidden name=total_qrt value=' . $qrtr . '>';
echo '<input type=hidden name=total_prg value=' . $prog . '>';
}
// echo '</div>';
echo '<BR>The following items will be rolled over to the next school year. Uncheck the item(s) <br/>you do not want to be rolled over. Some items are mandatory and cannot be <br/>unchecked.<BR>';
echo $message . '<BR>';
//echo 'hi';
echo "<BR><BR><INPUT type=submit class=btn_medium value=Rollover onclick=\"return formcheck_rollover();\"> <INPUT type=button class=btn_medium name=delete_cancel value=Cancel onclick='load_link(\"Modules.php?modname=Tools/LogDetails.php\");'></FORM></CENTER>";
PopTable('footer');
return false;
} else {
return true;
}
}
function _makePublishing($value, $name)
{
global $THIS_RET, $profiles_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
$return = '<TABLE width=216><TR><TD class=LO_field align="center"><b>Visible Between:</b></TD></tr><tr><TD align="center">';
$return .= DateInput($value, "values[{$id}][{$name}]") . '</TD></tr><tr><TD class=LO_field align="center"><b>&</b></TD></tr><tr><TD align="center">';
$return .= DateInput($THIS_RET['END_DATE'], "values[{$id}][END_DATE]") . '</TD></TR>';
$return .= '<TR><TD colspan=4 class=break></TD></TR><TR><TD colspan=4>';
if (!$profiles_RET) {
$profiles_RET = DBGet(DBQuery("SELECT ID,TITLE FROM user_profiles ORDER BY ID"));
}
$return .= '<TABLE border=0 cellspacing=0 cellpadding=0 width=96% class=LO_field><TR><TD colspan=4><b>Visible To: </b></TD></TR>';
foreach (array('all' => 'All School', 'admin' => 'Administrator w/Custom', 'teacher' => 'Teacher w/Custom', 'parent' => 'Parent w/Custom') as $profile_id => $profile) {
$return .= "<tr><TD colspan=4><INPUT type=checkbox name=profiles[{$id}][{$profile_id}] value=Y" . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile_id},") !== false ? ' CHECKED' : '') . "> {$profile}</TD></tr>";
}
$i = 3;
foreach ($profiles_RET as $profile) {
$i++;
$return .= '<tr><TD colspan=4><INPUT type=checkbox name=profiles[' . $id . '][' . $profile['ID'] . '] value=Y' . (strpos($THIS_RET['PUBLISHED_PROFILES'], ",{$profile['ID']},") !== false ? ' CHECKED' : '') . "> {$profile['TITLE']}</TD></tr>";
if ($i % 4 == 0 && $i != count($profile)) {
$return .= '<TR>';
}
}
for (; $i % 4 != 0; $i++) {
$return .= '<TD></TD>';
}
$return .= '</TR>';
//<TR><TD colspan=4><B><A HREF=#>Schools: ...</A></B></TD></TR></TABLE>';
$return .= '</TABLE>';
$return .= '</TD></TR></TABLE>';
return $return;
}
function _makeDateInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if ($name != 'TITLE') {
$extra = ' class=cell_floating';
} else {
$extra = 'class=cell_floating';
}
return DateInput($value, "values[{$id}][{$name}]", '', $extra);
}
$header .= '<TABLE cellspacing=0 cellpadding=3 border=0>';
$header .= '<TR><td class=lable >Title</td><TD>' . TextInput($RET['TITLE'], 'tables[' . $_REQUEST['marking_period_id'] . '][TITLE]', '', 'class=cell_floating') . '</TD></tr>';
$header .= '<TR><td class=lable>Short Name</td><TD>' . TextInput($RET['SHORT_NAME'], 'tables[' . $_REQUEST['marking_period_id'] . '][SHORT_NAME]', '', 'class=cell_floating') . '</TD></tr>';
if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
$header .= '<TR><td class=lable>Sort Order</td><TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', '', 'class=cell_small onKeyDown="return numberOnly(event);"') . '</TD></tr>';
} else {
$header .= '<TR><td class=lable>Sort Order</td><TD>' . TextInput($RET['SORT_ORDER'], 'tables[' . $_REQUEST['marking_period_id'] . '][SORT_ORDER]', '', 'class=cell_small onKeyDown=\\"return numberOnly(event);\\"') . '</TD></tr>';
}
$header .= '<TR><td class=lable>Graded</td><TD>' . CheckboxInput($RET['DOES_GRADES'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_GRADES]', '', $checked, $_REQUEST['marking_period_id'] == '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>') . '</TD></tr>';
$header .= '<TR><td class=lable>Exam</td><TD>' . CheckboxInput($RET['DOES_EXAM'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_EXAM]', '', $checked, $_REQUEST['marking_period_id'] == '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>') . '</TD></tr>';
$header .= '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == '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>') . '</TD></tr>';
$header .= '<TR><td class=lable>Begins</td><TD>' . DateInput($RET['START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][START_DATE]', '') . '</TD></tr>';
$header .= '<TR><td class=lable>Ends</td><TD>' . DateInput($RET['END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][END_DATE]', '') . '</TD></tr>';
$header .= '<TR><td class=lable>Grade Posting Begins</td><TD>' . DateInput($RET['POST_START_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_START_DATE]', '') . '</TD></tr>';
$str_srch = '<TR><td class=lable>Comments</td><TD>' . CheckboxInput($RET['DOES_COMMENTS'], 'tables[' . $_REQUEST['marking_period_id'] . '][DOES_COMMENTS]', '', $checked, $_REQUEST['marking_period_id'] == '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>') . '</TD></tr>';
$header .= '<TR><td class=lable>Grade Posting Ends</td><TD>' . DateInput($RET['POST_END_DATE'], 'tables[' . $_REQUEST['marking_period_id'] . '][POST_END_DATE]', '') . '</TD></tr>';
$header .= '</TABLE>';
DrawHeader($header);
PopTable('footer');
if (clean_param($_REQUEST['marking_period_id'], PARAM_ALPHANUM) == 'new') {
DrawHeaderHome('', '', AllowEdit() ? '<INPUT type=submit value=Save class="btn_medium" onclick="formcheck_school_setup_marking();">' : '');
} elseif ($_REQUEST['mp_term'] != 'FY') {
DrawHeaderHome('', '', AllowEdit() ? $delete_button . ' <INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">' : '');
} else {
DrawHeaderHome('', '', '<INPUT type=submit name=btn_save id=btn_save value=Save class="btn_medium">');
}
echo '</FORM>';
unset($_SESSION['_REQUEST_vars']['marking_period_id']);
unset($_SESSION['_REQUEST_vars']['mp_term']);
}
// DISPLAY THE MENU
echo '<TABLE width=100% border=0 cellpadding=3>';
echo '<TR><td height="30px" colspan=2 class=hseparator><b>Demographic Information</b></td></tr>';
echo '<TR><td valign="top">';
echo '<TABLE border=0>';
echo '<tr><td style=width:120px>Name</td><td>:</td><td>';
if ($_REQUEST['student_id'] == 'new') {
echo '<TABLE ><TR><TD >' . TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '<FONT color=red>First</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', 'Middle', 'class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '<FONT color=red>Last</FONT>', 'size=12 class=cell_floating maxlength=50 style="font-size:14px; font-weight:bold;"') . '</TD><TD>' . SelectInput($student['NAME_SUFFIX'], 'students[NAME_SUFFIX]', 'Suffix', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"') . '</TD></TR></TABLE>';
} else {
echo '<DIV id=student_name><div style="font-size:14px; font-weight:bold;" onclick=\'addHTML("<TABLE><TR><TD>' . str_replace('"', '\\"', TextInput($student['FIRST_NAME'], 'students[FIRST_NAME]', '', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['MIDDLE_NAME'], 'students[MIDDLE_NAME]', '', 'size=3 maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', TextInput($student['LAST_NAME'], 'students[LAST_NAME]', '', 'maxlength=50 style="font-size:14px; font-weight:bold;"', false)) . '</TD><TD>' . str_replace('"', '\\"', SelectInput($student['NAME_SUFFIX'], 'students[NAME_SUFFIX]', '', array('Jr.' => 'Jr.', 'Sr.' => 'Sr.', 'II' => 'II', 'III' => 'III', 'IV' => 'IV', 'V' => 'V'), '', 'style="font-size:14px; font-weight:bold;"', false)) . '</TD></TR></TABLE>","student_name",true);\'>' . $student['FIRST_NAME'] . ' ' . $student['MIDDLE_NAME'] . ' ' . $student['LAST_NAME'] . ' ' . $student['NAME_SUFFIX'] . '</div></DIV>';
}
echo '</td></tr>';
echo '<tr><td>Estimated Grad. Date </td><td>:</td><td>' . DateInput($student['ESTIMATED_GRAD_DATE'], 'students[ESTIMATED_GRAD_DATE]', '') . '</td></tr>';
echo '<tr><td>Gender<font color=red>*</font></td><td>:</td><td>' . SelectInput($student['GENDER'], 'students[GENDER]', '', array('Male' => 'Male', 'Female' => 'Female'), 'N/A', '') . '</td></tr>';
echo '<tr><td>Ethnicity<font color=red>*</font></td><td>:</td><td>' . SelectInput($student['ETHNICITY'], 'students[ETHNICITY]', '', $ethnic_option, 'N/A', '') . '</td></tr>';
echo '<tr><td>Common Name</td><td>:</td><td>' . TextInput($student['COMMON_NAME'], 'students[COMMON_NAME]', '', 'size=10 class=cell_medium maxlength=10') . '</td></tr>';
echo '<tr><td>Birthdate<font color=red>*</font></td><td>:</td><td>' . DateInput($student['BIRTHDATE'], 'students[BIRTHDATE]', '') . '</td></tr>';
echo '<tr><td>Primary Language</td><td>:</td><td>' . SelectInput($student['LANGUAGE'], 'students[LANGUAGE]', '', $language_option, 'N/A', '') . '</td></tr>';
echo '<tr><td>Email</td><td>:</td><td>' . TextInput($student['EMAIL'], 'students[EMAIL]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
echo '<tr><td>Phone</td><td>:</td><td>' . TextInput($student['PHONE'], 'students[PHONE]', '', 'size=100 class=cell_medium maxlength=100') . '</td></tr>';
#############################################CUSTOM FIELDS###############################
$fields_RET = DBGet(DBQuery("SELECT ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,REQUIRED,HIDE,SORT_ORDER FROM CUSTOM_FIELDS WHERE SYSTEM_FIELD='N' AND CATEGORY_ID='{$_REQUEST['category_id']}' ORDER BY SORT_ORDER,TITLE"));
if (UserStudentID()) {
$custom_RET = DBGet(DBQuery("SELECT * FROM STUDENTS WHERE STUDENT_ID='" . UserStudentID() . "'"));
$value = $custom_RET[1];
}
if (count($fields_RET)) {
echo $separator;
}
$i = 1;
$q = 0;
foreach ($fields_RET as $field) {
