$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')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&table=student_medical_alerts&title=" . urlencode('medical alert'); $link['remove']['variables'] = array('id' => 'ID'); echo '<div class=clear></div><div class=hseparator><b>' . _('Medical Alert') . '</b></div>'; ListOutput($med_RET, $columns, '' . _('Medical Alert') . '', '' . _('Medical Alerts') . '', $link, array(), array('search' => false)); echo '</TD></TR></TABLE>'; echo '</TD>'; // IMAGE echo '</TR>'; echo '<TR><TD valign=top>'; $table = 'student_medical_visits'; $functions = array('SCHOOL_DATE' => '_makeDate', 'TIME_IN' => '_makeComments', 'TIME_OUT' => '_makeComments', 'REASON' => '_makeComments', 'RESULT' => '_makeComments', 'COMMENTS' => '_makeLongComments'); $med_RET = DBGet(DBQuery('SELECT ID,SCHOOL_DATE,TIME_IN,TIME_OUT,REASON,RESULT,COMMENTS FROM student_medical_visits WHERE STUDENT_ID=\'' . UserStudentID() . '\' ORDER BY SCHOOL_DATE'), $functions); $columns = array('SCHOOL_DATE' => '' . _('Date') . '', 'TIME_IN' => '' . _('Time') . '' . _(' In') . '', 'TIME_OUT' => '' . _('Time') . '' . _(' Out') . '', 'REASON' => '' . _('Reason') . '', 'RESULT' => '' . _('Result') . '', 'COMMENTS' => '' . _('Comments') . ''); $link['add']['html'] = array('SCHOOL_DATE' => _makeDate('', 'SCHOOL_DATE'), 'TIME_IN' => _makeComments('', 'TIME_IN'), 'TIME_OUT' => _makeComments('', 'TIME_OUT'), 'REASON' => _makeComments('', 'REASON'), 'RESULT' => _makeComments('', 'RESULT'), 'COMMENTS' => _makeLongComments('', 'COMMENTS')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&table=student_medical_visits&title=" . urlencode('visit');
} echo '<div class=hseparator><b>Immunization/Physical Record</b></div>'; if (!isset($_REQUEST['dwnl']) || $_REQUEST['dwnl'] == 'immunizations') { ListOutput_Medical($med_RET, $columns, 'Immunization or Physical', $plural, $link, 'immunizations', array(), array('search' => false)); } echo '</TD></tr><TD valign=top>'; $table = 'student_medical_alerts'; $functions = array('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'); foreach ($med_RET as $mi => $md) { $counter_for_date = $counter_for_date + 1; $med_RET[$mi]['ALERT_DATE'] = _makeDate($md['ALERT_DATE'], 'ALERT_DATE', $counter_for_date, array('ID' => $md['ID'], 'TABLE' => 'student_medical_alerts')); } $counter_for_date = $counter_for_date + 1; $link['add']['html'] = array('ALERT_DATE' => _makeDate('', 'ALERT_DATE', $counter_for_date), 'TITLE' => _makeAlertComments('', 'TITLE')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&table=student_medical_alerts&title=" . urlencode('medical alert'); $link['remove']['variables'] = array('id' => 'ID'); echo '<div class=clear></div><div class=hseparator><b>Medical Alert</b></div>'; if (!isset($_REQUEST['dwnl']) || $_REQUEST['dwnl'] == 'medical') { ListOutput_Medical($med_RET, $columns, 'Medical Alert', 'Medical Alerts', $link, 'medical', array(), array('search' => false)); } echo '</TD></TR></TABLE>'; echo '</TD>'; // IMAGE echo '</TR>'; echo '<TR><TD valign=top>'; $table = 'student_medical_visits'; $functions = array('TIME_IN' => '_makeComments', 'TIME_OUT' => '_makeComments', 'REASON' => '_makeComments', 'RESULT' => '_makeComments', 'COMMENTS' => '_makeLongComments'); $med_RET = DBGet(DBQuery('SELECT ID,SCHOOL_DATE,TIME_IN,TIME_OUT,REASON,RESULT,COMMENTS FROM student_medical_visits WHERE STUDENT_ID=\'' . UserStudentID() . '\' ORDER BY SCHOOL_DATE'), $functions); $columns = array('SCHOOL_DATE' => 'Date', 'TIME_IN' => 'Time In', 'TIME_OUT' => 'Time Out', 'REASON' => 'Reason', 'RESULT' => 'Result', 'COMMENTS' => 'Comments');