$columns = array('DOCTORS_NOTE_DATE' => '' . _('Date') . '', 'DOCTORS_NOTE_COMMENTS' => '' . _('Doctor\'s Note') . '');
$link['add']['html'] = array('DOCTORS_NOTE_DATE' => _makeDate('', 'DOCTORS_NOTE_DATE'), 'DOCTORS_NOTE_COMMENTS' => _makeAlertComments('', 'DOCTORS_NOTE_COMMENTS'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&table=student_medical_notes&title=" . urlencode('Medical Note');
$link['remove']['variables'] = array('id' => 'ID');
ListOutput($med_RET, $columns, '' . _('Medical Note') . '', '' . _('Medical Notes') . '', $link, array(), array('search' => false));
echo '<div class=clear></div>';
#############################################CUSTOM FIELDS###############################
// include('modules/Students/includes/Other_Info.inc.php');
#############################################CUSTOM FIELDS###############################
echo '</TD></TR><TR><TD valign=top>';
echo '<TABLE width=100%><TR><TD valign=top>';
$table = 'student_medical';
$functions = array('TYPE' => '_makeType', 'MEDICAL_DATE' => '_makeDate', 'COMMENTS' => '_makeAlertComments');
$med_RET = DBGet(DBQuery('SELECT ID,TYPE,MEDICAL_DATE,COMMENTS FROM student_medical WHERE STUDENT_ID=\'' . UserStudentID() . '\' ORDER BY MEDICAL_DATE,TYPE'), $functions);
$columns = array('TYPE' => '' . _('Type') . '', 'MEDICAL_DATE' => '' . _('Date') . '', 'COMMENTS' => '' . _('Comments') . '');
$link['add']['html'] = array('TYPE' => _makeType('', ''), 'MEDICAL_DATE' => _makeDate('', 'MEDICAL_DATE'), 'COMMENTS' => _makeAlertComments('', 'COMMENTS'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&table=student_medical&title=" . urlencode('immunization or physical');
$link['remove']['variables'] = array('id' => 'ID');
if (count($med_RET) == 0) {
$plural = '' . _('Immunizations or Physicals') . '';
} else {
$plural = '' . _('Immunizations and Physicals') . '';
}
echo '<div class=hseparator><b>' . _('Immunization/Physical Record') . '</b></div>';
ListOutput($med_RET, $columns, '' . _('Immunization or Physical') . '', $plural, $link, array(), array('search' => false));
echo '</TD></tr><TD valign=top>';
$table = 'student_medical_alerts';
$functions = array('ALERT_DATE' => '_makeDate', 'TITLE' => '_makeAlertComments');
$med_RET = DBGet(DBQuery('SELECT ID,TITLE,ALERT_DATE FROM student_medical_alerts WHERE STUDENT_ID=\'' . UserStudentID() . '\' ORDER BY ID'), $functions);
$columns = array('ALERT_DATE' => '' . _('Alert') . '' . _(' Date') . '', 'TITLE' => '' . _('Medical Alert') . '');
$link['add']['html'] = array('ALERT_DATE' => _makeDate('', 'ALERT_DATE'), 'TITLE' => _makeAlertComments('', 'TITLE'));
if (empty($_REQUEST['modfunc'])) {
$sql = "SELECT NULL AS REMOVE,du.ID AS USAGE_ID,df.ID,COALESCE(du.TITLE,df.TITLE) AS TITLE,du.SORT_ORDER,df.DATA_TYPE,du.SELECT_OPTIONS FROM DISCIPLINE_FIELDS df LEFT OUTER JOIN DISCIPLINE_FIELD_USAGE du ON (du.DISCIPLINE_FIELD_ID=df.ID AND du.SYEAR='" . UserSyear() . "' AND du.SCHOOL_ID='" . UserSchool() . "') ORDER BY du.ID,du.SORT_ORDER";
$QI = DBQuery($sql);
$referrals_RET = DBGet($QI, array('REMOVE' => '_makeRemove', 'TITLE' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput', 'DATA_TYPE' => '_makeType', 'SELECT_OPTIONS' => '_makeTextAreaInput'));
foreach ($referrals_RET as $key => $item) {
if (!$item['USAGE_ID']) {
$referrals_RET[$key]['row_color'] = 'CCCCCC';
}
}
if (count($referrals_RET)) {
$columns = array('REMOVE' => '');
} else {
$columns = array();
}
$columns += array('TITLE' => _('Title'), 'SORT_ORDER' => _('Sort Order'), 'DATA_TYPE' => _('Data Type'), 'SELECT_OPTIONS' => _('Pull-Down') . '/' . _('Select Multiple from Options') . '/' . _('Select One from Options'));
$link['add']['html'] = array('REMOVE' => button('add'), 'TITLE' => _makeTextInput('', 'TITLE'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'), 'SELECT_OPTIONS' => _makeTextAreaInput('', 'SELECT_OPTIONS'), 'DATA_TYPE' => _makeType('', 'DATA_TYPE'));
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '" method="POST">';
DrawHeader('', SubmitButton(_('Save')));
//modif Francois: fix SQL bug invalid sort order
if (isset($error)) {
echo $error;
}
ListOutput($referrals_RET, $columns, 'Referral Form Category', 'Referral Form Categories', $link);
echo '<span class="center">' . SubmitButton(_('Save')) . '</span>';
echo '</FORM>';
}
function _makeType($value, $name)
{
global $THIS_RET;
if ($THIS_RET['USAGE_ID']) {
$id = $THIS_RET['USAGE_ID'];
}
if ($_REQUEST['modfunc'] == 'delete' && AllowEdit()) {
if (DeletePrompt(_('Category'))) {
$id = $_REQUEST['id'];
DBQuery("DELETE FROM DISCIPLINE_CATEGORIES WHERE ID='{$id}'");
DBQuery("ALTER TABLE DISCIPLINE_REFERRALS DROP COLUMN CATEGORY_{$id}");
unset($_REQUEST['modfunc']);
unset($_REQUEST['id']);
}
}
if (empty($_REQUEST['modfunc'])) {
$sql = "SELECT ID,TITLE,SORT_ORDER,TYPE,OPTIONS FROM DISCIPLINE_CATEGORIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER";
$QI = DBQuery($sql);
$referrals_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInput', 'TYPE' => '_makeType', 'OPTIONS' => '_makeTextAreaInput'));
$columns = array('TITLE' => _('Title'), 'SORT_ORDER' => _('Sort Order'), 'TYPE' => _('Data Type'), 'OPTIONS' => _('Options'));
$link['add']['html'] = array('TITLE' => _makeTextInput('', 'TITLE'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'), 'OPTIONS' => _makeTextAreaInput('', 'OPTIONS'), 'TYPE' => _makeType('', 'TYPE'));
if (AllowEdit()) {
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=delete";
$link['remove']['variables'] = array('id' => 'ID');
}
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '" method="POST">';
DrawHeader('', SubmitButton(_('Save')));
ListOutput($referrals_RET, $columns, 'Referral Form Category', 'Referral Form Categories', $link);
echo '<span class="center">' . SubmitButton(_('Save')) . '</span>';
echo '</FORM>';
}
function _makeType($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
