echo '</TEXTAREA>';
echo '<table><tr><td><IMG SRC=assets/comment_button.gif onload="document.getElementById(\'chars_left\').innerHTML=1121-document.getElementById(\'textarea\').value.length";></td><td><small><div id=chars_left>1121</div></small></td><td><small>characters remaining.<small></td></tr></table>';
#echo '</TD>';
//echo '<TR><TD align=center><INPUT type=submit value=Save></TD></TR>';
echo '</TR></TABLE>';
echo "<br><b>*If more than one teacher will be adding comments for this student:</b><br>";
echo "<ul><li>Type your name above the comments you enter.</li>";
echo "<li>Leave space for other teachers to enter their comments.</li></ul>";
*/
echo '</tr><TD valign=top>';
$table = 'student_mp_comments';
$functions = array('COMMENT_DATE' => '_makeDate', 'COMMENT' => '_makeCommentsn');
if (User('PROFILE') == 'admin' || User('PROFILE') == 'teacher' || User('PROFILE') == 'parent') {
$comments_RET = DBGet(DBQuery("SELECT ID,COMMENT_DATE,COMMENT,CONCAT(s.FIRST_NAME,' ',s.LAST_NAME)AS USER_NAME,student_mp_comments.STAFF_ID FROM student_mp_comments,staff s WHERE STUDENT_ID='" . UserStudentID() . "' AND s.STAFF_ID=student_mp_comments.STAFF_ID ORDER BY ID DESC"), $functions);
}
# else
# $comments_RET = DBGet(DBQuery("SELECT ID,COMMENT_DATE,COMMENT,CONCAT(s.FIRST_NAME,' ',s.LAST_NAME)AS USER_NAME FROM student_mp_comments,staff s WHERE STUDENT_ID='".UserStudentID()."' AND student_mp_comments.SYEAR='".UserSyear()."' AND MARKING_PERIOD_ID='".GetParentMP('SEM',UserMP())."' AND s.STAFF_ID=student_mp_comments.STAFF_ID"),$functions);
$columns = array('USER_NAME' => '' . _('Entered By') . '', 'COMMENT_DATE' => '' . _('Date') . '', 'COMMENT' => '' . _('Comments') . '');
$link['add']['html'] = array('COMMENT_DATE' => _makeDate('', 'COMMENT_DATE'), 'COMMENT' => _makeCommentsn('', 'COMMENT'), 'USER_NAME' => '');
if (User('PROFILE') == 'admin') {
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&modfunc=delete&table=student_mp_comments&title=" . urlencode('medical comment');
$link['remove']['variables'] = array('id' => 'ID');
}
$link['USER_NAME']['link'] = "Modules.php?modname=Users/User.php";
$link['USER_NAME']['variables'] = array('staff_id' => 'STAFF_ID');
ListOutput($comments_RET, $columns, '' . _('Comment') . '', '' . _('Comments') . '', $link, array(), array('search' => false));
echo '</TD></TR></TABLE>';
$_REQUEST['category_id'] = '4';
$separator = '<hr>';
#include('modules/Students/includes/Other_Info.inc.php');
}
} 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');
$link['remove']['variables'] = array('id' => 'ID');
echo '<div class=clear></div><div class=hseparator><b>' . _('Nurse Visit Record') . '</b></div>';
ListOutput($med_RET, $columns, '' . _('Nurse Visit') . '', '' . _('Nurse Visits') . '', $link, array(), array('search' => false));
echo '</TD></TR></TABLE>';
}
// ,'STAFF_CERTIFICATION_SHORT_NAME'=>'_makeTextInput'
// ,'STAFF_PRIMARY_CERTIFICATION_INDICATOR'=>'_makeSelectInput'
// ,'STAFF_CERTIFICATION_EXPIRY_DATE'=>'_makeDateInput'
// ,'STAFF_CERTIFICATION_DESCRIPTION'=>'_makeContentInput'));
$cert_RET = DBGet($QI, array('STAFF_CERTIFICATION_NAME' => '_makeTextInput', 'STAFF_CERTIFICATION_CODE' => '_makeTextInput', 'STAFF_CERTIFICATION_SHORT_NAME' => '_makeTextInput', 'STAFF_PRIMARY_CERTIFICATION_INDICATOR' => '_makeSelectInput', 'STAFF_CERTIFICATION_DESCRIPTION' => '_makeContentInput'));
$counter_for_date = 0;
foreach ($cert_RET as $ci => $cd) {
$counter_for_date = $counter_for_date + 1;
$cert_RET[$ci]['STAFF_CERTIFICATION_DATE'] = _makeDate($cd['STAFF_CERTIFICATION_DATE'], 'STAFF_CERTIFICATION_DATE', $counter_for_date, $cd['ID']);
$counter_for_date = $counter_for_date + 1;
$cert_RET[$ci]['STAFF_CERTIFICATION_EXPIRY_DATE'] = _makeDate($cd['STAFF_CERTIFICATION_EXPIRY_DATE'], 'STAFF_CERTIFICATION_EXPIRY_DATE', $counter_for_date, $cd['ID']);
}
echo '<input type=hidden id=no_date_fields value=' . ($counter_for_date == 0 ? $counter_for_date : $counter_for_date - 1) . '>';
echo '<input type=hidden name=error_handler valuue="">';
$columns = array('STAFF_CERTIFICATION_NAME' => 'Certification Name', 'STAFF_CERTIFICATION_CODE' => 'Certification Code', 'STAFF_CERTIFICATION_DATE' => 'Certification Date', 'STAFF_CERTIFICATION_SHORT_NAME' => 'Certification Short Name', 'STAFF_PRIMARY_CERTIFICATION_INDICATOR' => 'Primary Certification Indicator', 'STAFF_CERTIFICATION_EXPIRY_DATE' => 'Certification Expiry Date', 'STAFF_CERTIFICATION_DESCRIPTION' => 'Certification Description');
$link['add']['html'] = array('STAFF_CERTIFICATION_NAME' => _makeTextInput('', 'STAFF_CERTIFICATION_NAME'), 'STAFF_CERTIFICATION_CODE' => _makeTextInput('', 'STAFF_CERTIFICATION_CODE'), 'STAFF_CERTIFICATION_DATE' => _makeDate('', 'STAFF_CERTIFICATION_DATE', $counter_for_date + 1), 'STAFF_CERTIFICATION_SHORT_NAME' => _makeTextInput('', 'STAFF_CERTIFICATION_SHORT_NAME'), 'STAFF_PRIMARY_CERTIFICATION_INDICATOR' => _makeSelectInput('', 'STAFF_PRIMARY_CERTIFICATION_INDICATOR'), 'STAFF_CERTIFICATION_EXPIRY_DATE' => _makeDate('', 'STAFF_CERTIFICATION_EXPIRY_DATE', $counter_for_date + 2), 'STAFF_CERTIFICATION_DESCRIPTION' => _makeContentInput('', 'STAFF_CERTIFICATION_DESCRIPTION'));
// $link['remove']['link'] = "Modules.php?modname=$_REQUEST[modname]&include=$_REQUEST[include]&category_id=$_REQUEST[category_id]&staff_id=".UserStaffID()."&modfunc=remove";
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&include={$_REQUEST['include']}&category_id={$_REQUEST['category_id']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
ListOutputStaffCert($cert_RET, $columns, 'Certificate', 'Certificates', $link);
//echo '<pre>';print_r($_REQUEST);echo '</pre>';
}
function _makeTextInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
}
if ($name != 'TITLE') {
