<?php
require_once 'modules/Scheduling/includes/calcSeats0.fnc.php';
require_once 'modules/Scheduling/functions.inc.php';
if ( ! $_REQUEST['modfunc']
&& $_REQUEST['search_modfunc'] !== 'list' )
{
$_SESSION['MassSchedule.php'] = [];
}
if ( $_REQUEST['modfunc'] !== 'choose_course' )
{
DrawHeader( ProgramTitle() );
}
if ( $_REQUEST['modfunc'] === 'save'
&& AllowEdit() )
{
if ( ! empty( $_SESSION['MassSchedule.php'] ) )
{
if ( ! empty( $_REQUEST['student'] ) )
{
$start_date = RequestedDate( 'start', '' );
if ( $start_date )
{
foreach ( (array) $_SESSION['MassSchedule.php'] as $cp_id => $course_to_add )
{
$course_period_RET = DBGet( "SELECT MARKING_PERIOD_ID,TOTAL_SEATS,
COURSE_PERIOD_ID,CALENDAR_ID
FROM course_periods
WHERE COURSE_PERIOD_ID='" . (int) $course_to_add['course_period_id'] . "'
AND SYEAR='" . UserSyear() . "'" );
// Fix Marking Period not found in user School Year (multiple tabs case).
$course_mp = empty( $course_period_RET ) ? null : $course_period_RET[1]['MARKING_PERIOD_ID'];
$course_mp_table = GetMP( $course_mp,'MP' );
if ( $course_mp_table === 'FY'
|| $course_mp === $_REQUEST['marking_period_id']
|| mb_strpos( GetChildrenMP( $course_mp_table, $course_mp ), "'" . $_REQUEST['marking_period_id'] . "'" ) !== false )
{
// Check available seats:
if ( $course_period_RET[1]['TOTAL_SEATS'] )
{
$seats = calcSeats0( $course_period_RET[1], $start_date );
if ( ( $seats + count( $_REQUEST['student'] ) ) > $course_period_RET[1]['TOTAL_SEATS'] )
{
$warnings[] = _( 'The number of selected students exceeds the available seats.' );
}
}
// FJ check if Available Seats < selected students.
if ( empty( $warnings )
|| Prompt(
'Confirm',
sprintf( _( 'Are you sure you want to add %s?' ), $course_to_add['course_period_title'] ),
ErrorMessage( $warnings, 'warning' )
) )
{
$mp_table = GetMP( $_REQUEST['marking_period_id'], 'MP' );
$mps = GetAllMP( GetMP( $course_mp, 'MP' ), $course_mp );
// @since 11.3 Refuse to enroll student twice in the same course period
// if marking periods overlap and dates overlap (already scheduled course does not end or ends after $date) then not okay
$current_RET = DBGet( "SELECT STUDENT_ID
FROM schedule
WHERE COURSE_PERIOD_ID='" . (int) $course_to_add['course_period_id'] . "'
AND MARKING_PERIOD_ID IN (" . $mps . ")
AND (END_DATE IS NULL OR '" . $start_date . "'<=END_DATE)", [], [ 'STUDENT_ID' ] );
$insert_count = 0;
foreach ( (array) $_REQUEST['student'] as $student_id )
{
if ( ! empty( $current_RET[ $student_id ] ) )
{
$error_students[] = $student_id;
continue;
}
DBInsert(
'schedule',
[
'SYEAR' => UserSyear(),
'SCHOOL_ID' => UserSchool(),
'STUDENT_ID' => (int) $student_id,
'COURSE_ID' => (int) $course_to_add['course_id'],
'COURSE_PERIOD_ID' => (int) $course_to_add['course_period_id'],
'MP' => $mp_table,
'MARKING_PERIOD_ID' => (int) $_REQUEST['marking_period_id'],
'START_DATE' => $start_date,
]
);
$insert_count++;
// Hook.
do_action( 'Scheduling/MassSchedule.php|schedule_student' );
}
if ( ! empty( $error_students ) )
{
$error[] = sprintf(
_( 'Students %s are already scheduled into the %s course.' ),
implode( ',', $error_students ),
$course_to_add['course_title']
);
}
if ( $insert_count )
{
$note[] = sprintf(
_( 'The %s course has been added to the selected students\' schedules.' ),
$course_to_add['course_title']
);
}
}
else
exit();
}
else
{
$error[] = _( 'You cannot schedule a student into this course during this marking period.' ) .
' ' . sprintf( _( 'The %s course meets on %s.' ), $course_to_add['course_title'], GetMP( $course_mp ) );
}
unset( $_SESSION['MassSchedule.php'][ $cp_id ] );
}
}
else
$error[] = _( 'The date you entered is not valid' );
}
else
$error[] = _( 'You must choose at least one student.' );
}
else
$error[] = _( 'You must choose a course.' );
// Unset modfunc redirect URL.
RedirectURL( 'modfunc' );
$_SESSION['MassSchedule.php'] = [];
}
echo ErrorMessage( $error );
echo ErrorMessage( $note, 'note' );
if ( ! $_REQUEST['modfunc'] )
{
if ( $_REQUEST['search_modfunc'] === 'list' )
{
echo '<form action="' . URLEscape( 'Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=save' ) . '" method="POST">';
DrawHeader( '', SubmitButton( _( 'Add Courses to Selected Students' ) ) );
echo '<br />';
PopTable( 'header', _( 'Courses to Add' ) );
echo '<table><tr><td><div id="course_div">';
foreach ( (array) $_SESSION['MassSchedule.php'] as $course_to_add )
{
echo $course_to_add['course_title'] . '<br />' .
$course_to_add['course_period_title'] . '<br /><br />';
}
$popup_url = URLEscape( 'Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=choose_course' );
echo '</div><a href="#" onclick="' . AttrEscape( 'popups.open(
' . json_encode( $popup_url ) . '
); return false;' ) . '">' . _( 'Choose a Course' ) . '</a></td></tr>';
echo '<tr><td><br />' . DateInput(
DBDate(),
'start',
_( 'Start Date' ),
false,
false
) . '</td></tr>';
// @since 11.1 SQL Use GetFullYearMP() & GetChildrenMP() functions to limit Marking Periods
$fy_and_children_mp = "'" . GetFullYearMP() . "'";
if ( GetChildrenMP( 'FY' ) )
{
$fy_and_children_mp .= "," . GetChildrenMP( 'FY' );
}
$mp_RET = DBGet( "SELECT MARKING_PERIOD_ID,TITLE," .
db_case( [ 'MP', "'FY'", "'0'", "'SEM'", "'1'", "'QTR'", "'2'" ] ) . " AS TBL
FROM school_marking_periods
WHERE (MP='FY' OR MP='SEM' OR MP='QTR')
AND MARKING_PERIOD_ID IN(" . $fy_and_children_mp . ")
AND SCHOOL_ID='" . UserSchool() . "'
AND SYEAR='" . UserSyear() . "'
ORDER BY TBL,SORT_ORDER IS NULL,SORT_ORDER,START_DATE" );
echo '<tr><td><select name="marking_period_id" id="marking_period_id">';
foreach ( (array) $mp_RET as $mp )
{
echo '<option value="' . AttrEscape( $mp['MARKING_PERIOD_ID'] ) . '">' . $mp['TITLE'] . '</option>';
}
echo '</select>';
echo FormatInputTitle( _( 'Marking Period' ), 'marking_period_id' );
echo '</td></tr></table>';
PopTable( 'footer' );
echo '<br />';
}
$extra['link'] = [ 'FULL_NAME' => false ];
$extra['SELECT'] = ",NULL AS CHECKBOX";
$extra['functions'] = [ 'CHECKBOX' => 'MakeChooseCheckbox' ];
$extra['columns_before'] = [ 'CHECKBOX' => MakeChooseCheckbox( 'required', 'STUDENT_ID', 'student' ) ];
$extra['new'] = true;
Widgets( 'course' );
Widgets( 'request' );
// Last year course custom widget.
MyWidgets( 'ly_course' );
// Widgets('activity');
Search( 'student_id', $extra );
if ( $_REQUEST['search_modfunc'] === 'list' )
{
echo '<br /><div class="center">' .
SubmitButton( _( 'Add Courses to Selected Students' ) ) . '</div></form>';
}
}
if ( $_REQUEST['modfunc'] === 'choose_course' )
{
if ( empty( $_REQUEST['course_period_id'] ) )
{
include 'modules/Scheduling/Courses.php';
}
else
{
$course_title = DBGetOne( "SELECT TITLE
FROM courses
WHERE COURSE_ID='" . (int) $_REQUEST['course_id'] . "'" );
$period_title = DBGetOne( "SELECT TITLE
FROM course_periods
WHERE COURSE_PERIOD_ID='" . (int) $_REQUEST['course_period_id'] . "'" );
// Add course period if not already chosen...
if ( ! isset( $_SESSION['MassSchedule.php'][ $_REQUEST['course_period_id'] ] ) )
{
$_SESSION['MassSchedule.php'][ $_REQUEST['course_period_id'] ] = [
'subject_id' => $_REQUEST['subject_id'],
'course_id' => $_REQUEST['course_id'],
'course_title' => $course_title,
'course_period_id' => $_REQUEST['course_period_id'],
'course_period_title' => $period_title,
];
// Update main window.
echo '<script>opener.document.getElementById("course_div").innerHTML += ' .
json_encode( $course_title . '<br />' . $period_title . '<br /><br />' ) . ';</script>';
}
// Close popup.
echo '<script>window.close();</script>';
}
}