';
foreach ( (array) $periods_RET as $period )
{
$period_select .= '';
}
$period_select .= '';
echo '';
//FJ multiple school periods for a course period
/*$sql = "SELECT s.LAST_NAME||', '||s.FIRST_NAME AS FULL_NAME,sp.TITLE,cp.PERIOD_ID,s.STAFF_ID
FROM STAFF s,COURSE_PERIODS cp,SCHOOL_PERIODS sp
WHERE
sp.PERIOD_ID = cp.PERIOD_ID
AND cp.TEACHER_ID=s.STAFF_ID AND cp.MARKING_PERIOD_ID IN (".GetAllMP('QTR',UserMP()).")
AND cp.SYEAR='".UserSyear()."' AND cp.SCHOOL_ID='".UserSchool()."' AND s.PROFILE='teacher'
".(($_REQUEST['period'])?" AND cp.PERIOD_ID='".$_REQUEST['period']."'":'')."
AND NOT EXISTS (SELECT '' FROM ELIGIBILITY_COMPLETED ac WHERE ac.STAFF_ID=cp.TEACHER_ID AND ac.PERIOD_ID = sp.PERIOD_ID AND ac.SCHOOL_DATE BETWEEN '".$start_date."' AND '".$end_date."')
";*/
$sql = "SELECT " . DisplayNameSQL( 's' ) . " AS FULL_NAME,sp.TITLE,cpsp.PERIOD_ID,
s.STAFF_ID,cp.TITLE AS CP_TITLE
FROM STAFF s,COURSE_PERIODS cp,SCHOOL_PERIODS sp,COURSE_PERIOD_SCHOOL_PERIODS cpsp
WHERE cp.COURSE_PERIOD_ID=cpsp.COURSE_PERIOD_ID
AND sp.PERIOD_ID=cpsp.PERIOD_ID
AND cp.TEACHER_ID=s.STAFF_ID
AND cp.MARKING_PERIOD_ID IN (" . GetAllMP( 'QTR', GetCurrentMP( 'QTR', $start_date ) ) . ")
AND cp.SYEAR='" . UserSyear() . "'
AND cp.SCHOOL_ID='" . UserSchool() . "'
AND s.PROFILE='teacher'" .
( $_REQUEST['period'] ? " AND cpsp.PERIOD_ID='" . $_REQUEST['period'] . "'" : '' ) .
"AND NOT EXISTS (SELECT ''
FROM ELIGIBILITY_COMPLETED ac
WHERE ac.STAFF_ID=cp.TEACHER_ID
AND ac.PERIOD_ID=sp.PERIOD_ID
AND ac.SCHOOL_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "')";
$RET = DBGet( $sql, array(), array( 'STAFF_ID', 'PERIOD_ID' ) );
$i = 0;
$staff_RET = array();
foreach ( (array) $RET as $staff_id => $periods )
{
$i++;
$staff_RET[$i]['FULL_NAME'] = $periods[key( $periods )][1]['FULL_NAME'];
if ( empty( $_REQUEST['period'] ) )
{
foreach ( (array) $periods as $period_id => $course_periods )
{
if ( isset( $_REQUEST['_ROSARIO_PDF'] ) )
{
$staff_RET[$i][$period_id] = _( 'No' );
continue;
}
$cp_titles = array();
foreach ( (array) $course_periods as $course_period )
{
$cp_titles[] = $course_period['CP_TITLE'];
}
$staff_RET[$i][$period_id] = MakeTipMessage(
implode( '
', $cp_titles ),
_( 'Course Periods' ),
button( 'x' )
);
}
}
}
$columns = array( 'FULL_NAME' => _( 'Teacher' ) );
if ( empty( $_REQUEST['period'] ) )
{
foreach ( (array) $periods_RET as $period )
{
$columns[$period['PERIOD_ID']] = $period['TITLE'];
}
}
ListOutput(
$staff_RET,
$columns,
'Teacher who hasn\'t entered eligibility',
'Teachers who haven\'t entered eligibility'
);