编辑文件 - FixDailyAttendance.php

✏️ 正在编辑: FixDailyAttendance.php

路径: /home/eblama1/sms.karnplayinland.com/modules/Attendance/FixDailyAttendance.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php
//FJ move Attendance.php from functions/ to modules/Attendance/includes
require_once 'modules/Attendance/includes/UpdateAttendanceDaily.fnc.php';

DrawHeader( ProgramTitle() );

//FJ add translation
$message = '<table><tr><td colspan="7" class="center">' . _( 'From' ) . ' ' .
	DateInput( DBDate(), 'min', '', false, false ) . ' ' . _( 'to' ) . ' ' .
	DateInput( DBDate(), 'max', '', false, false ) . '</td></tr></table>';

if ( Prompt( _( 'Confirm' ), _( 'When do you want to recalculate the daily attendance?' ), $message ) )
{
	//FJ display notice while calculating daily attendance
	echo '<br />';
	PopTable( 'header', _( 'Recalculate Daily Attendance' ) );
	echo '<div id="messageDIV" class="center"><span class="loading"></span> ' . _( 'Calculating ...' ) . ' </div>';
	PopTable( 'footer' );
	ob_flush();
	flush();
	set_time_limit( 300 );

$current_RET = DBGet( "SELECT DISTINCT SCHOOL_DATE
		FROM attendance_calendar
		WHERE SCHOOL_ID='" . UserSchool() . "'
		AND SYEAR='" . UserSyear() . "'", [], [ 'SCHOOL_DATE' ] );

$students_RET = GetStuList();

$begin = mktime( 0, 0, 0, (int) $_REQUEST['month_min'], (int) $_REQUEST['day_min'], (int) $_REQUEST['year_min'] ) + 43200;
	$end = mktime( 0, 0, 0, (int) $_REQUEST['month_max'], (int) $_REQUEST['day_max'], (int) $_REQUEST['year_max'] ) + 43200;

for ( $i = $begin; $i <= $end; $i += 86400 )
	{
		foreach ( (array) $students_RET as $student )
		{
			// @since 7.5 Delete any attendance for this day & student prior to update.
			// Fix case where calendar has changed and day is no longer a school day.
			// Else, the daily attendance will be re-inserted below using UpdateAttendanceDaily().
			DBQuery( "DELETE FROM attendance_day
				WHERE STUDENT_ID='" . (int) $student['STUDENT_ID'] . "'
				AND SYEAR='" . UserSyear() . "'
				AND SCHOOL_DATE='" . date( 'Y-m-d', $i ) . "'" );

if ( isset( $current_RET[date( 'Y-m-d', $i )] ) )
			{
				UpdateAttendanceDaily( $student['STUDENT_ID'], date( 'Y-m-d', $i ) );
			}
		}
	}

$_REQUEST['modfunc'] = false;

//FJ display notice while calculating daily attendance
	echo '<script>var msg_done=' . json_encode( ErrorMessage( [ _( 'The Daily Attendance for that timeframe has been recalculated.' ) ], 'note' ) ) . '; document.getElementById("messageDIV").innerHTML = msg_done;</script>';
}

← 返回文件管理器