if (AllowEdit() && $use_contact) {
echo '<TR>';
echo '</TR>';
}
}
echo '</TABLE>';
echo '</TD></TR>';
echo '</TABLE>';
#echo '</FIELDSET>';
echo '</TD></TR>';
echo '</TABLE>';
// close 3e
} else {
echo '<TABLE border=0><TR><TD colspan=3><table><tr><td>' . CheckboxInput($this_contact['EMERGENCY'], 'values[students_join_people][EMERGENCY]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '</TD><TD>' . _('This is an Emergency Contact') . '</TD></TR></table></TD></TR><tr><td colspan=3 class=break></td></tr>';
echo '<TR><td style="width:120px" style=white-space:nowrap><span class=red>*</span>' . _('Relationship to Student') . '</td><td>:</td><TD>' . SelectInput($this_contact['STUDENT_RELATION'], 'values[students_join_people][STUDENT_RELATION]', '', $relation_options, 'N/A') . '</TD></TR>';
echo '<TR><TD><span class=red>*</span>' . _('First Name') . '</td><td>:</td><TD>' . str_replace('"', '\\"', _makePeopleInput('', 'FIRST_NAME', '', 'class=cell_medium')) . '</TD></tr><tr><td ><span class=red>' . _('*') . '</span>' . _('Last Name') . '</td><td>:</td><TD>' . str_replace('"', '\\"', _makePeopleInput($this_contact['LAST_NAME'], 'LAST_NAME', '', 'class=cell_medium')) . '</TD></TR>';
echo '<tr><TD>' . _('Home Phone') . '</td><td>:</td><td> ' . TextInput($this_contact['ADDN_HOME_PHONE'], 'values[students_join_people][ADDN_HOME_PHONE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<tr><TD>' . _('Work Phone') . '</td><td>:</td><td>' . TextInput($this_contact['ADDN_WORK_PHONE'], 'values[students_join_people][ADDN_WORK_PHONE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<tr><TD>' . _('Mobile Phone') . '</td><td>:</td><td> ' . TextInput($this_contact['ADDN_MOBILE_PHONE'], 'values[students_join_people][ADDN_MOBILE_PHONE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<tr><TD>' . _('Email') . ' </td><td>:</td><td>' . TextInput($this_contact['ADDN_EMAIL'], 'values[students_join_people][ADDN_EMAIL]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><TD>' . _('Custody of Student') . '</td><td>:</td><TD>' . CheckboxInput($this_contact['CUSTODY'], 'values[students_join_people][CUSTODY]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '<small><FONT color=' . Preferences('TITLES') . '></FONT></small></TD></TR>';
echo '<TR><TD colspan=3><table><TR><TD style=white-space:nowrap><span class=red>' . _('*') . '</span><input type="radio" id="r7" name="r7" value="Y" onClick="addn_hidediv();" checked> ' . _('Same as Student\'s Home Address') . ' <input type="radio" id="r7" name="r7" value="N" onClick="addn_showdiv();"> ' . _('Add New Address') . '</TD></TR></TABLE></TD></TR>';
echo '<TR><TD colspan=3><div id="addn_hideShow" style="display:none">';
echo '<div class=break></div>';
echo '<table><TR><td style=width:120px>' . _('Address Line 1') . '</td><td>:</td><TD>' . TextInput($this_address['ADDN_ADDRESS'], 'values[students_join_people][ADDN_ADDRESS]', '', 'class=cell_medium') . '</TD></td>';
#echo '<table><TR><td style=width:120px>Address Line 1</td><td>:</td><TD><table cellspacing=0 cellpadding=0><tr><td>'.TextInput($this_address['SEC_ADDRESS'],'values[address][SEC_ADDRESS]','','class=cell_medium').'</TD><td>';
echo '<TR><td>' . _('Address Line 2') . '</td><td>:</td><TD>' . TextInput($this_contact['ADDN_STREET'], 'values[students_join_people][ADDN_STREET]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>' . _('City') . '</td><td>:</td><TD>' . TextInput($this_contact['ADDN_CITY'], 'values[students_join_people][ADDN_CITY]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>' . _('State') . '</td><td>:</td><TD>' . TextInput($this_contact['ADDN_STATE'], 'values[students_join_people][ADDN_STATE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>' . _('Zip/Postal Code') . '</td><td>:</td><TD>' . TextInput($this_contact['ADDN_ZIPCODE'], 'values[students_join_people][ADDN_ZIPCODE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><TD>' . _('School Bus Pick-up') . '</TD><td>:</td><TD>' . CheckboxInput($this_contact['ADDN_BUS_PICKUP'], 'values[students_join_people][ADDN_BUS_PICKUP]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '</TD></tr>';
if ($categories_RET) {
$value = DBGet(DBQuery("SELECT * FROM PEOPLE WHERE PERSON_ID='{$_REQUEST['person_id']}'"));
$value = $value[1];
$request = 'values[PEOPLE]';
foreach ($categories_RET as $fields_RET) {
if (!$fields_RET['CUSTODY'] && !$fields_RET['EMERGENCY'] || $fields_RET['CUSTODY'] == 'Y' && $this_contact['CUSTODY'] == 'Y' || $fields_RET['EMERGENCY'] == 'Y' && $this_contact['EMERGENCY'] == 'Y') {
echo '<TR><TD>';
echo '<FIELDSET><LEGEND><FONT color=gray>' . ParseMLField($fields_RET[1]['CATEGORY_TITLE']) . '</FONT></LEGEND>';
include 'modules/Students/includes/Other_Fields.inc.php';
echo '</FIELDSET>';
echo '</TD></TR>';
}
}
}
} else {
echo '<TR><TD><TABLE><TR><TD>' . str_replace('"', '\\"', _makePeopleInput('', 'FIRST_NAME', '<FONT color=red>' . _('First') . '</FONT>')) . '</TD><TD>' . str_replace('"', '\\"', _makePeopleInput($this_contact['MIDDLE_NAME'], 'MIDDLE_NAME', _('Middle'))) . '</TD><TD>' . str_replace('"', '\\"', _makePeopleInput($this_contact['LAST_NAME'], 'LAST_NAME', '<FONT color=red>' . _('Last') . '</FONT>')) . '</TD></TR></TABLE></TD></TR>';
echo '<TR><TD>' . SelectInput($this_contact['STUDENT_RELATION'], 'values[STUDENTS_JOIN_PEOPLE][STUDENT_RELATION]', _('Relation'), $relation_options, 'N/A') . '</TD></TR>';
echo '<TR><TD><TABLE><TR><TD><IMG SRC=assets/gavel_button.gif></TD><TD><INPUT type=checkbox name=values[STUDENTS_JOIN_PEOPLE][CUSTODY] value=Y><BR><small><FONT color=' . Preferences('TITLES') . '>' . _('Custody') . '</FONT></small></TD><TD><IMG SRC=assets/emergency_button.gif></TD><TD><INPUT type=checkbox name=values[STUDENTS_JOIN_PEOPLE][EMERGENCY] value=Y><BR><small><FONT color=' . Preferences('TITLES') . '>' . _('Emergency') . '</FONT></small></TD></TR></TABLE></TD></TR>';
echo '</TABLE>';
echo '</FIELDSET>';
echo '</TD></TR>';
}
echo '</TABLE>';
} elseif ($_REQUEST['person_id'] == 'old') {
$people_RET = DBGet(DBQuery("SELECT DISTINCT p.PERSON_ID,p.FIRST_NAME,p.LAST_NAME FROM PEOPLE p,STUDENTS_JOIN_PEOPLE sjp WHERE sjp.PERSON_ID=p.PERSON_ID AND sjp.ADDRESS_ID" . ($_REQUEST['address_id'] != '0' ? '!=' : '=') . "'0' AND p.PERSON_ID NOT IN (SELECT PERSON_ID FROM STUDENTS_JOIN_PEOPLE WHERE STUDENT_ID='" . UserStudentID() . "') ORDER BY LAST_NAME,FIRST_NAME"));
foreach ($people_RET as $people) {
$people_select[$people['PERSON_ID']] = $people['LAST_NAME'] . ', ' . $people['FIRST_NAME'];
}
echo SelectInput('', 'values[EXISTING][person_id]', _('Select Person'), $people_select);
}
} elseif ($_REQUEST['address_id'] != '0' && $_REQUEST['address_id'] != 'new' && $_REQUEST['address_id'] != 'old') {
echo '<TR><td>Address Line 2</td><td>:</td><TD>' . TextInput($o_addr[1]['STREET'], 'values[student_address][OTHER][STREET_ADDRESS_2]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>City</td><td>:</td><TD>' . TextInput($o_addr[1]['CITY'], 'values[student_address][OTHER][CITY]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>State</td><td>:</td><TD>' . TextInput($o_addr[1]['STATE'], 'values[student_address][OTHER][STATE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><td>Zip/Postal Code</td><td>:</td><TD>' . TextInput($o_addr[1]['ZIPCODE'], 'values[student_address][OTHER][ZIPCODE]', '', 'class=cell_medium') . '</TD></tr>';
echo '<TR><TD>School Bus Pick-up</TD><td>:</td><TD>' . CheckboxInputMod($o_addr[1]['BUS_PICKUP'], 'values[student_address][OTHER][BUS_PICKUP]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '</TD></tr>';
echo '<TR><TD>School Bus Drop-off</TD><td>:</td><TD>' . CheckboxInputMod($o_addr[1]['BUS_DROPOFF'], 'values[student_address][OTHER][BUS_DROPOFF]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '</TD></tr>';
echo '<TR><TD>Bus No</td><td>:</td><TD>' . TextInput($o_addr[1]['BUS_NO'], 'values[student_address][OTHER][BUS_NO]', '', 'class=cell_small') . '</TD></tr>';
echo '</table>';
echo '</TABLE>';
} else {
$extra = "id=" . "'values[people][OTHER][RELATIONSHIP]'";
echo '<TABLE border=0><TR><TD colspan=3><table><tr><td><input type=hidden name=values[people][OTHER][IS_EMERGENCY_HIDDEN] id=IS_EMERGENCY_HIDDEN value="Y">' . CheckboxInputMod($o_addr[1]['IS_EMERGENCY'], 'values[people][OTHER][IS_EMERGENCY]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '</TD><TD>This is an Emergency Contact</TD></TR></table></TD></TR><tr><td colspan=3 class=break></td></tr>';
if (User('PROFILE') != 'teacher') {
echo '<TR><td style="width:120px" style=white-space:nowrap><span class=red>*</span>Relationship to Student</td><td>:</td><TD><table><tr><td>' . SelectInput($o_addr[1]['RELATIONSHIP'], 'values[people][OTHER][RELATIONSHIP]', '', $relation_options, 'N/A', $extra) . '</td><td><input type="button" name="lookup" value="Lookup" onclick="javascript:window.open(\'ForWindow.php?modname=' . $_REQUEST['modname'] . '&modfunc=lookup&type=other&ajax=' . $_REQUEST['ajax'] . '&add_id=new&address_id=' . $_REQUEST['address_id'] . '\',\'blank\',\'resizable=yes,scrollbars=yes,width=600,height=400\');return false;"></td></tr></table></TD></TR>';
}
echo '<TR><TD><span class=red>*</span>First Name</td><td>:</td><TD>' . str_replace('"', '\\"', _makePeopleInput($o_addr[1]['FIRST_NAME'], 'people', 'FIRST_NAME', 'OTHER', '', 'id=oth_fname class=cell_medium')) . '</TD></tr><tr><td ><span class=red>*</span>Last Name</td><td>:</td><TD>' . str_replace('"', '\\"', _makePeopleInput($o_addr[1]['LAST_NAME'], 'people', 'LAST_NAME', 'OTHER', '', 'id=oth_lname class=cell_medium')) . '</TD></TR>';
echo '<tr><TD>Home Phone</td><td>:</td><td> ' . TextInput($o_addr[1]['HOME_PHONE'], 'values[people][OTHER][HOME_PHONE]', '', 'id=oth_hphone class=cell_medium') . '</TD></tr>';
echo '<tr><TD>Work Phone</td><td>:</td><td>' . TextInput($o_addr[1]['WORK_PHONE'], 'values[people][OTHER][WORK_PHONE]', '', 'id=oth_wphone class=cell_medium') . '</TD></tr>';
echo '<tr><TD>Mobile Phone</td><td>:</td><td> ' . TextInput($o_addr[1]['CELL_PHONE'], 'values[people][OTHER][CELL_PHONE]', '', 'id=oth_cphone class=cell_medium') . '</TD></tr>';
if ($o_addr[1]['PERSON_ID'] == '') {
echo '<tr><TD><span class=red>*</span>Email </td><td>:</td><td><table><tr><td>' . TextInput($o_addr[1]['EMAIL'], 'values[people][OTHER][EMAIL]', '', 'autocomplete=off id=oth_email class=cell_medium onkeyup=peoplecheck_email(this,2,0); ') . '</td><td><span id="email_2"></span></td></tr></table></TD></tr>';
} else {
echo '<tr><TD><span class=red>*</span>Email </td><td>:</td><td><table><tr><td>' . TextInput($o_addr[1]['EMAIL'], 'values[people][OTHER][EMAIL]', '', 'autocomplete=off id=oth_email class=cell_medium onkeyup=peoplecheck_email(this,2,' . $o_addr[1]['PERSON_ID'] . ') ') . '</td><td><span id="email_2"></span></td></tr></table></TD></tr>';
}
echo '<TR><TD>Custody of Student</td><td>:</td><TD>' . CheckboxInputMod($o_addr[1]['CUSTODY'], 'values[people][OTHER][CUSTODY]', '', 'CHECKED', $new, '<IMG SRC=assets/check.gif width=15>', '<IMG SRC=assets/x.gif width=15>') . '<small><FONT color=' . Preferences('TITLES') . '></FONT></small></TD></TR>';
if ($o_addr[1]['USER_NAME'] == '') {
$portal_check = '';
$style = 'style="display:none"';
} else {
$portal_check = 'checked="checked"';
$style = '';
if ($categories_RET) {
$value = DBGet(DBQuery("SELECT * FROM PEOPLE WHERE PERSON_ID='{$_REQUEST['person_id']}'"));
$value = $value[1];
$request = 'values[PEOPLE]';
foreach ($categories_RET as $fields_RET) {
if (!$fields_RET['CUSTODY'] && !$fields_RET['EMERGENCY'] || $fields_RET['CUSTODY'] == 'Y' && $this_contact['CUSTODY'] == 'Y' || $fields_RET['EMERGENCY'] == 'Y' && $this_contact['EMERGENCY'] == 'Y') {
echo '<TR><TD>';
echo '<FIELDSET><LEGEND><span style="color:gray">' . ParseMLField($fields_RET[1]['CATEGORY_TITLE']) . '</span></LEGEND>';
include 'modules/Students/includes/Other_Fields.inc.php';
echo '</FIELDSET>';
echo '</TD></TR>';
}
}
}
} else {
echo '<TR><TD><TABLE class="cellpadding-0 cellspacing-0"><TR><TD>' . _makePeopleInput('', 'FIRST_NAME', '<span style="color:red">' . _('First Name') . '</span>') . '</TD><TD>' . _makePeopleInput('', 'MIDDLE_NAME', _('Middle Name')) . '</TD><TD>' . _makePeopleInput('', 'LAST_NAME', '<span style="color:red">' . _('Last Name') . '</span>') . '</TD></TR></TABLE></TD></TR>';
echo '<TR><TD>' . SelectInput('', 'values[STUDENTS_JOIN_PEOPLE][STUDENT_RELATION]', _('Relation'), $relation_options, _('N/A')) . '</TD></TR>';
//modif Francois: add <label> on checkbox
echo '<TR><TD><TABLE class="cellpadding-0 cellspacing-0"><TR><TD><IMG SRC="assets/gavel_button.png" width="24"></TD><TD><label><INPUT type="checkbox" name="values[STUDENTS_JOIN_PEOPLE][CUSTODY]" value="Y"><BR /><span class="legend-gray"> ' . _('Custody') . '</span></label></TD><TD><IMG SRC="assets/emergency_button.png" width="24"></TD><TD><label><INPUT type="checkbox" name="values[STUDENTS_JOIN_PEOPLE][EMERGENCY]" value="Y"><BR /><span class="legend-gray"> ' . _('Emergency') . '</span></label></TD></TR></TABLE></TD></TR>';
echo '</TABLE>';
echo '</FIELDSET>';
echo '</TD></TR>';
}
echo '</TABLE>';
} elseif ($_REQUEST['person_id'] == 'old') {
$people_RET = DBGet(DBQuery("SELECT DISTINCT p.PERSON_ID,p.FIRST_NAME,p.LAST_NAME FROM PEOPLE p,STUDENTS_JOIN_PEOPLE sjp WHERE sjp.PERSON_ID=p.PERSON_ID AND sjp.ADDRESS_ID" . ($_REQUEST['address_id'] != '0' ? '!=' : '=') . "'0' AND p.PERSON_ID NOT IN (SELECT PERSON_ID FROM STUDENTS_JOIN_PEOPLE WHERE STUDENT_ID='" . UserStudentID() . "') ORDER BY LAST_NAME,FIRST_NAME"));
foreach ($people_RET as $people) {
$people_select[$people['PERSON_ID']] = $people['LAST_NAME'] . ', ' . $people['FIRST_NAME'];
}
echo SelectInput('', 'values[EXISTING][person_id]', _('Select Person'), $people_select);
}
