<?php
/**
* Transcripts functions
*/
if ( ! function_exists( 'TranscriptsIncludeForm' ) )
{
/**
* Get Include on Transcript form
*
* @todo Use Inputs.php functions.
*
* @example $return = TranscriptsIncludeForm();
*
* @since 4.0 Define your custom function in your addon module or plugin.
* @since 5.0 Add GPA or Total row.
*
* @global $extra Get $extra['search'] for Mailing Labels Widget
*
* @uses _getOtherAttendanceCodes()
*
* @param string $include_on_title Form title (optional). Defaults to 'Include on Transcript'.
* @param boolean $mailing_labels Include Mailing Labels widget (optional). Defaults to true.
* @return string Include on Transcript form
*/
function TranscriptsIncludeForm( $include_on_title = 'Include on Transcript', $mailing_labels = true )
{
global $extra,
$_ROSARIO;
$return = '<table class="width-100p">';
$include_on_title = ( $include_on_title === 'Include on Transcript' ?
_( 'Include on Transcript' ) :
$include_on_title );
$return .= '<tr><td colspan="2"><b>' . $include_on_title .
'</b><input type="hidden" name="SCHOOL_ID" value="' . AttrEscape( UserSchool() ) . '" /><br /></td></tr>';
$return .= '<tr class="st"><td class="valign-top">';
// Add Show Grades option.
$return .= '<label><input type="checkbox" name="showgrades" value="1" checked /> ' .
_( 'Grades' ) . '</label>';
$return .= '<br /><br /><label><input type="checkbox" name="showstudentpic" value="1"> ' .
_( 'Student Photo' ) . '</label>';
// Add Show Comments option.
$return .= '<br /><br /><label><input type="checkbox" name="showmpcomments" value="1"> ' .
_( 'Comments' ) . '</label>';
// Add Show Credits option.
$return .= '<br /><br /><label><input type="checkbox" name="showcredits" value="1" checked /> ' .
_( 'Credits' ) . '</label>';
// Add Show Credit Hours option.
$return .= '<br /><br /><label><input type="checkbox" name="showcredithours" value="1"> ' .
_( 'Credit Hours' ) . '</label>';
// Add GPA or Total row.
$gpa_or_total_options = [
'gpa' => _( 'GPA' ),
'total' => _( 'Total' ),
];
if ( User( 'PROFILE' ) !== 'admin' )
{
$_ROSARIO['allow_edit'] = true;
}
$return .= '<br /><br />' . RadioInput( '', 'showgpa_or_total', _( 'Last row' ), $gpa_or_total_options );
// Limit Cetificate to admin.
if ( User( 'PROFILE' ) === 'admin' )
{
// Add Show Studies Certificate option.
$return .= '<br /><br /><label><input type="checkbox" name="showcertificate" autocomplete="off" value="1" onclick=\'javascript: document.getElementById("divcertificatetext").style.display="block"; document.getElementById("inputcertificatetext").focus();\'> ' . _( 'Studies Certificate' ) . '</label>';
$return .= '<div id="divcertificatetext" style="display:none">';
$return .= TinyMCEInput(
GetTemplate(),
'inputcertificatetext',
_( 'Studies Certificate Text' )
);
$substitutions = [
'__FULL_NAME__' => _( 'Display Name' ),
'__LAST_NAME__' => _( 'Last Name' ),
'__FIRST_NAME__' => _( 'First Name' ),
'__MIDDLE_NAME__' => _( 'Middle Name' ),
'__GRADE_ID__' => _( 'Grade Level' ),
'__NEXT_GRADE_ID__' => _( 'Next Grade' ),
'__SCHOOL_ID__' => _( 'School' ),
'__YEAR__' => _( 'School Year' ),
'__BLOCK2__' => _( 'Text Block 2' ),
];
$substitutions += SubstitutionsCustomFields( 'student' );
$return .= '<table><tr class="st"><td class="valign-top">' .
SubstitutionsInput( $substitutions ) .
'</td></tr>';
$return .= '</table></div>';
}
$return .= '<hr></td></tr>';
// History grades & previous school years in Transripts.
if ( User( 'PROFILE' ) === 'admin' )
{
$syear_history_RET = DBGet( "SELECT DISTINCT SYEAR
FROM history_marking_periods
WHERE SYEAR<>'" . UserSyear() . "'
AND SCHOOL_ID='" . UserSchool() . "'
UNION SELECT DISTINCT SYEAR
FROM school_marking_periods
WHERE SYEAR<>'" . UserSyear() . "'
AND SCHOOL_ID='" . UserSchool() . "'
ORDER BY SYEAR DESC" );
// If History School Years or previous school years.
if ( $syear_history_RET )
{
$return .= '<tr class="st"><td>';
$syoptions[UserSyear()] = FormatSyear( UserSyear(), Config( 'SCHOOL_SYEAR_OVER_2_YEARS' ) );
// Chosen Multiple select input.
$syextra = 'multiple';
foreach ( (array) $syear_history_RET as $syear_history )
{
$syoptions[$syear_history['SYEAR']] = FormatSyear(
$syear_history['SYEAR'],
Config( 'SCHOOL_SYEAR_OVER_2_YEARS' )
);
}
ksort( $syoptions );
$return .= Select2Input(
UserSyear(),
'syear_arr[]',
_( 'School Years' ),
$syoptions,
false,
$syextra,
false
);
$return .= '<hr></td></tr>';
}
}
$mp_types = DBGet( "SELECT DISTINCT MP_TYPE
FROM marking_periods
WHERE NOT MP_TYPE IS NULL
AND SCHOOL_ID='" . UserSchool() . "'", [], [] );
$return .= '<tr class="st"><td class="valign-top">';
$marking_periods_locale = [
'Year' => _( 'Year' ),
'Semester' => _( 'Semester' ),
'Quarter' => _( 'Quarter' ),
];
foreach ( (array) $mp_types as $mp_type )
{
// Add <label> on checkbox.
$return .= '<label><input type="checkbox" name="mp_type_arr[]" value="' . AttrEscape( $mp_type['MP_TYPE'] ) . '"> ' . $marking_periods_locale[ucwords( $mp_type['MP_TYPE'] )] . '</label> ';
}
$return .= FormatInputTitle( _( 'Marking Periods' ) ) . '</td></tr></table>';
return $return;
}
}
if ( ! function_exists( 'TranscriptsGenerate' ) )
{
/**
* Transcripts generation
*
* @todo Divide in smaller functions
*
* @example $transcripts = TranscriptsGenerate( $_REQUEST['st_arr'], $_REQUEST['mp_type_arr'], $_REQUEST['syear_arr'] );
*
* @since 4.8 Define your custom function in your addon module or plugin.
* @since 4.8 Add Transcripts PDF header action hook.
* @since 5.0 Add GPA or Total row.
* @since 11.5.1 Fix Calculate GPA for all Marking Periods when Year not checked
*
* @param array $student_array Students IDs.
* @param array $mp_type_array Marking Periods types.
* @param array $syear_array School Years.
* @return boolean|array False if No Students or Transcripts associative array (key = student_id.syear)
*/
function TranscriptsGenerate( $student_array, $mp_type_array, $syear_array )
{
require_once 'modules/Grades/includes/Grades.fnc.php';
if ( empty( $student_array )
|| empty( $mp_type_array ) )
{
return false;
}
// Limit School & Year to current ones if not admin.
$syear_list = ( User( 'PROFILE' ) === 'admin' && $syear_array ?
implode( ',', array_map( 'intval', $syear_array ) ) :
"'" . UserSyear() . "'" );
$school_id = ( User( 'PROFILE' ) === 'admin' && $_REQUEST['SCHOOL_ID'] ? $_REQUEST['SCHOOL_ID'] : UserSchool() );
$mp_type_list = "'" . implode( "','", $mp_type_array ) . "'";
$st_list = implode( ',', array_map( 'intval', $student_array ) );
$RET = 1;
if ( User( 'PROFILE' ) !== 'admin' )
{
// FJ prevent student ID hacking.
$extra['WHERE'] = " AND s.STUDENT_ID IN (" . $st_list . ")";
// Parent: associated students.
$extra['ASSOCIATED'] = User( 'STAFF_ID' );
$RET = GetStuList( $extra );
}
$t_grades = DBGet( "SELECT *
FROM transcript_grades
WHERE student_id IN (" . $st_list . ")
AND mp_type in (" . $mp_type_list . ")
AND school_id='" . (int) $school_id . "'
AND syear in (" . $syear_list . ")
ORDER BY mp_type, end_date", [], [ 'STUDENT_ID', 'SYEAR', 'MARKING_PERIOD_ID' ] );
if ( empty( $t_grades ) || empty( $RET ) )
{
return [];
}
$syear = ( User( 'PROFILE' ) === 'admin' && $syear_array ?
$syear_array[0] :
UserSyear() );
$show = [
'studentpic' => ! empty( $_REQUEST['showstudentpic'] ),
'sat' => ! empty( $_REQUEST['showsat'] ),
'grades' => ! empty( $_REQUEST['showgrades'] ),
'mpcomments' => ! empty( $_REQUEST['showmpcomments'] ),
'credits' => ! empty( $_REQUEST['showcredits'] ),
'credithours' => ! empty( $_REQUEST['showcredithours'] ),
'certificate' => ( User( 'PROFILE' ) === 'admin' && ! empty( $_REQUEST['showcertificate'] ) ),
'gpa_or_total' => $_REQUEST['showgpa_or_total'],
];
if ( $show['certificate'] )
{
$certificate_template = GetTemplate();
$block2 = '__BLOCK2__';
if ( mb_strpos( $certificate_template, '<p>__BLOCK2__</p>' ) !== false )
{
$block2 = '<p>__BLOCK2__</p>';
}
$certificate_texts = explode( $block2, $certificate_template );
}
$students_data = _getTranscriptsStudents( $st_list, $syear );
$school_info = DBGet( "SELECT * FROM schools
WHERE SYEAR='" . UserSyear() . "'
AND ID='" . (int) $school_id . "'" );
$school_info = $school_info[1];
// Transcripts array.
$transcripts = [];
foreach ( (array) $t_grades as $student_id => $t_sgrades )
{
$student = $students_data[$student_id][1];
$student['ID'] = $student_id;
$grades_total = [];
foreach ( (array) $t_sgrades as $syear => $mps )
{
// Start buffer.
ob_start();
$certificate_block1 = $certificate_block2 = '';
if ( empty( $student['GRADE_LEVEL'] )
&& $mps[key( $mps )][1]['GRADE_LEVEL_SHORT'] )
{
// History grades in Transripts.
$student['GRADE_LEVEL'] = $mps[key( $mps )][1]['GRADE_LEVEL_SHORT'];
}
if ( $show['certificate'] )
{
$substitutions = [
'__SSECURITY__' => $student['SSECURITY'],
'__FULL_NAME__' => $student['FULL_NAME'],
'__LAST_NAME__' => $student['LAST_NAME'],
'__FIRST_NAME__' => $student['FIRST_NAME'],
'__MIDDLE_NAME__' => $student['MIDDLE_NAME'],
'__GRADE_ID__' => $student['GRADE_LEVEL'],
'__NEXT_GRADE_ID__' => $student['NEXT_GRADE_LEVEL'],
'__SCHOOL_ID__' => $school_info['TITLE'],
'__YEAR__' => FormatSyear( $syear, Config( 'SCHOOL_SYEAR_OVER_2_YEARS' ) ),
];
$substitutions += SubstitutionsCustomFieldsValues( 'STUDENT', $student );
$certificate_block1 = SubstitutionsTextMake( $substitutions, $certificate_texts[0] );
if ( ! empty( $certificate_texts[1] ) )
{
$certificate_block2 = SubstitutionsTextMake( $substitutions, $certificate_texts[1] );
}
}
$student['SYEAR'] = $syear;
TranscriptPDFHeader( $student, $school_info, $certificate_block1 );
// Generate ListOutput friendly array.
$grades_RET = [];
$last_mp = array_keys( $mps );
$last_mp = end( $last_mp );
$total_credit_earned = 0;
$total_credit_attempted = 0;
$total_gpa = 0;
$columns = [ 'COURSE_TITLE' => _( 'Course' ) ];
foreach ( (array) $mps as $mp_id => $grades )
{
$columns[$mp_id] = $grades[1]['SHORT_NAME'];
foreach ( (array) $grades as $grade )
{
// Use Course Title as key for grades array to keep 1 line per course.
$i = $grade['COURSE_TITLE'];
$grades_RET[$i]['COURSE_TITLE'] = $grade['COURSE_TITLE'];
if ( $show['grades'] )
{
if ( ProgramConfig( 'grades', 'GRADES_DOES_LETTER_PERCENT' ) > 0 )
{
$grades_RET[$i][$mp_id] = $grade['GRADE_PERCENT'] . '%';
}
elseif ( ProgramConfig( 'grades', 'GRADES_DOES_LETTER_PERCENT' ) < 0 )
{
$grades_RET[$i][$mp_id] = '<b>' . $grade['GRADE_LETTER'] . '</b>';
}
else
{
$grades_RET[$i][$mp_id] = '<b>' . $grade['GRADE_LETTER'] . '</b>' .
' ' . $grade['GRADE_PERCENT'] . '%';
}
}
// @since 5.0 Add GPA or Total row.
if ( ! isset( $grades_total[$mp_id] ) )
{
$grades_total[$mp_id] = 0;
}
$grades_total[$mp_id] += $grade['WEIGHTED_GP'];
if ( ( strpos( $mp_type_list, 'year' ) !== false
&& $grade['MP_TYPE'] != 'quarter'
&& $grade['MP_TYPE'] != 'semester' )
|| ( strpos( $mp_type_list, 'semester' ) !== false
&& $grade['MP_TYPE'] != 'quarter' )
|| ( strpos( $mp_type_list, 'year' ) === false
&& strpos( $mp_type_list, 'semester' ) === false
&& $grade['MP_TYPE'] == 'quarter' ) )
{
if ( ! isset( $grades_RET[$i]['CREDIT_EARNED'] ) )
{
$grades_RET[$i]['CREDIT_EARNED'] = 0;
}
$grades_RET[$i]['CREDIT_EARNED'] += (float) $grade['CREDIT_EARNED'];
if ( $mp_id === $last_mp
&& mb_strlen( $grades_RET[$i]['CREDIT_EARNED'] ) > 7 )
{
// Format Credit Earned, display 0.33 instead of 0.333333333333333
$grades_RET[$i]['CREDIT_EARNED'] = number_format( $grades_RET[$i]['CREDIT_EARNED'], 2, '.' );
}
$total_credit_earned += $grade['CREDIT_EARNED'];
$total_credit_attempted += $grade['CREDIT_ATTEMPTED'];
$total_gpa += $grade['WEIGHTED_GP'] * $grade['CREDIT_ATTEMPTED'];
}
if ( $show['credithours']
&& ! isset( $grades_RET[$i]['CREDIT_HOURS'] ) )
{
$grades_RET[$i]['CREDIT_HOURS'] = (int) $grade['CREDIT_HOURS'] == $grade['CREDIT_HOURS'] ?
(int) $grade['CREDIT_HOURS'] :
$grade['CREDIT_HOURS'];
}
if ( $show['mpcomments'] )
{
$grades_RET[$i]['COMMENT'] = $grade['COMMENT'];
}
}
}
// Switch back to numeric index for grades array.
$grades_RET = array_values( $grades_RET );
array_unshift( $grades_RET, 'start_array_to_1' );
unset( $grades_RET[0] );
if ( $show['credits'] )
{
$columns['CREDIT_EARNED'] = _( 'Credit' );
}
if ( $show['credithours'] )
{
$columns['CREDIT_HOURS'] = _( 'C.H.' );
}
if ( $show['mpcomments'] )
{
$columns['COMMENT'] = _( 'Comment' );
}
if ( $show['grades'] && $show['gpa_or_total'] )
{
// @since 5.0 Add GPA or Total row.
$grades_RET[] = GetGpaOrTotalRow(
$student_id,
$grades_total,
0, // @since 11.4 Deprecate $courses_number param
$show['gpa_or_total']
);
}
//var_dump($grades_RET);exit;
ListOutput( $grades_RET, $columns, '.', '.', [], [], [ 'count' => false ] );
$last_grade = $show['grades'] ? $grade : [];
if ( strpos( $mp_type_list, 'year' ) === false
&& count( $mps ) > 1 )
{
/**
* Fix Calculate GPA for all Marking Periods when Year not checked
*
* Year Marking Period is not on Transcript & we have more than 1 Quarter/Semester.
* Last grade's CUM_WEIGHTED_GPA would only reflect the GPA of the last Marking Period.
*
* @since 11.5.1
*/
$last_grade['CUM_WEIGHTED_GPA'] = $total_credit_attempted ?
$total_gpa / $total_credit_attempted : 0;
if ( is_null( $last_grade['SCHOOL_SCALE'] ) )
{
// No school scale recorded for Historical Grades.
$last_grade['SCHOOL_SCALE'] = $school_info['REPORTING_GP_SCALE'];
}
}
if ( $show['credits'] )
{
$last_grade['total_credit_earned'] = $total_credit_earned;
$last_grade['total_credit_attempted'] = $total_credit_attempted;
}
TranscriptPDFFooter( $student, $last_grade, $certificate_block2 );
// Add buffer to Transcripts array.
$transcripts[$student_id . '-' . $syear] = ob_get_clean();
}
}
return $transcripts;
}
}
if ( ! function_exists( 'TranscriptPDFHeader' ) )
{
/**
* Transcripts PDF Header HTML
* Contains Student info & pic on the left,
* School info and logo on the right.
* And certificate block 1.
*
* @since 4.8 Add Transcript PDF header action hook.
* @since 7.5 Echo your custom text before or append it to $header_html to display it after.
*
* @param array $student Student data.
* @param array $school_info School Info.
* @param string $certificate_text Certificate text, block 1 only (optional).
*/
function TranscriptPDFHeader( $student, $school_info, $certificate_text = '' )
{
global $StudentPicturesPath;
static $custom_fields_RET = null;
if ( ! $student
|| ! $school_info )
{
return '';
}
ob_start();
if ( is_null( $custom_fields_RET ) )
{
$custom_fields_RET = DBGet( "SELECT ID,TITLE,TYPE
FROM custom_fields
WHERE ID IN (200000000, 200000003, 200000004)", [], [ 'ID' ] );
}
echo '<table class="width-100p"><tr class="valign-top"><td>';
if ( ! empty( $_REQUEST['showstudentpic'] ) )
{
// Student Photo.
// @since 9.0 Fix Improper Access Control security issue: add random string to photo file name.
$picture_path = (array) glob( $StudentPicturesPath . '*/' . $student['ID'] . '.*jpg' );
$picture_path = end( $picture_path );
$picwidth = 120;
if ( $picture_path )
{
echo '<img src="' . URLEscape( $picture_path ) . '" width="' . AttrEscape( $picwidth ) . '" />';
}
else
{
echo ' ';
}
}
// Student Info.
echo '</td><td><span style="font-size:x-large;">' . $student['FULL_NAME'] . '<br /></span>';
// Translate "No Address".
echo '<span>' . ( $student['ADDRESS'] === 'No Address' ?
_( 'No Address' ) : $student['ADDRESS'] ) . '<br /></span>';
echo '<span>' . $student['CITY'] .
( ! empty( $student['STATE'] ) ? ', ' . $student['STATE'] : '' ) .
( ! empty( $student['ZIPCODE'] ) ? ' ' . $student['ZIPCODE'] : '' ) . '</span>';
echo '<table class="cellspacing-0 cellpadding-5" style="margin-top:10px;"><tr>';
if ( isset( $student['BIRTHDATE'] ) )
{
echo '<td style="border:solid black; border-width:1px 0 1px 1px;">' .
ParseMLField( $custom_fields_RET['200000004'][1]['TITLE'] ) . '</td>';
}
if ( isset( $student['GENDER'] ) )
{
echo '<td style="border:solid black; border-width:1px 0 1px 1px;">' .
ParseMLField( $custom_fields_RET['200000000'][1]['TITLE'] ) . '</td>';
}
echo '<td style="border:solid black; border-width:1px;">' .
_( 'Grade Level' ) . '</td></tr><tr>';
if ( isset( $student['BIRTHDATE'] ) )
{
echo '<td class="center">' . ProperDate( $student['BIRTHDATE'] ) . '</td>';
}
if ( isset( $student['GENDER'] ) )
{
echo '<td class="center">' . $student['GENDER'] . '</td>';
}
echo '<td class="center">' . $student['GRADE_LEVEL'] . '</td></tr></table></td>';
// School logo.
$logo_pic = 'assets/school_logo_' . UserSchool() . '.jpg';
$picwidth = 120;
echo '<td style="width:' . $picwidth . 'px;">';
if ( file_exists( $logo_pic ) )
{
echo '<img src="' . URLEscape( $logo_pic ) . '" width="' . AttrEscape( $picwidth ) . '" />';
}
// School Info.
echo '</td><td>';
echo '<span style="font-size:x-large;">' . $school_info['TITLE'] . '<br /></span>';
echo '<span>' . $school_info['ADDRESS'] . '<br /></span>';
echo '<span>' . $school_info['CITY'] .
( ! empty( $school_info['STATE'] ) ? ', ' . $school_info['STATE'] : '' ) .
( ! empty( $school_info['ZIPCODE'] ) ? ' ' . $school_info['ZIPCODE'] : '' ) . '<br /></span>';
if ( $school_info['PHONE'] )
{
echo '<span>' . _( 'Phone' ) . ': ' . $school_info['PHONE'] . '<br /></span>';
}
if ( $school_info['WWW_ADDRESS'] )
{
echo '<span>' . _( 'Website' ) . ': ' . $school_info['WWW_ADDRESS'] . '<br /></span>';
}
if ( $school_info['SCHOOL_NUMBER'] )
{
echo '<span>' . _( 'School Number' ) . ': ' . $school_info['SCHOOL_NUMBER'] .
'<br /><br /></span>';
}
echo '<span>' . $school_info['PRINCIPAL'] . '<br /></span></td></tr></table>';
if ( $certificate_text )
{
// Certificate Text block 1.
echo '<br /><div class="transcript-certificate-block1">' . $certificate_text . '</div>';
}
$header_html = ob_get_clean();
// @since 4.8 Add Transcripts PDF header action hook.
// @since 7.5 Echo your custom text before or append it to $header_html to display it after.
do_action( 'Grades/includes/Transcripts.fnc.php|pdf_header', [ $student['ID'], &$header_html ] );
echo $header_html;
}
}
if ( ! function_exists( 'TranscriptPDFFooter' ) )
{
/**
* Transcripts PDF Footer HTML
* Contains School Year, GPA, Class Rank, Total Credit
* Certificate block 2 below.
*
* @since 4.8 Add Transcript PDF footer action hook.
* @since 7.5 Echo your custom text before or append it to $footer_html to display it after.
*
* @param array $student Student data.
* @param array $school_info School Info.
* @param string $certificate_text Certificate text, block 2 only (optional).
*/
function TranscriptPDFFooter( $student, $last_grade, $certificate_text = '' )
{
ob_start();
// School Year.
echo '<table class="width-100p"><tr><td><span><br />' .
_( 'School Year' ) . ': ' .
FormatSyear( $student['SYEAR'], Config( 'SCHOOL_SYEAR_OVER_2_YEARS' ) ) . '</span></td></tr>';
if ( $last_grade
// && $last_grade['MP_TYPE'] !== 'quarter'
&& ( ! empty( $last_grade['CUM_WEIGHTED_GPA'] ) || ! empty( $last_grade['CUM_RANK'] ) ) )
{
// GPA and/or Class Rank.
echo '<tr><td><span>';
if ( ! empty( $last_grade['CUM_WEIGHTED_GPA'] ) )
{
echo sprintf(
_( 'GPA' ) . ': %01.2f / %01.0f',
$last_grade['CUM_WEIGHTED_GPA'],
$last_grade['SCHOOL_SCALE'] );
if ( ! empty( $last_grade['CUM_RANK'] ) )
{
echo ' – ';
}
}
if ( ! empty( $last_grade['CUM_RANK'] ) )
{
echo _( 'Class Rank' ) . ': ' . $last_grade['CUM_RANK'] .
' / ' . $last_grade['CLASS_SIZE'] . '</span>';
}
echo '</span></td></tr>';
}
if ( $last_grade
&& ! empty( $last_grade['total_credit_attempted'] ) )
{
// Total Credits.
echo '<tr><td><span>' . _( 'Total' ) . ' ' . _( 'Credit' ) . ': ' .
_( 'Credit Attempted' ) . ': ' . (float) $last_grade['total_credit_attempted'] .
' – ' . _( 'Credit Earned' ) . ': ' . (float) $last_grade['total_credit_earned'] .
'</span></td></tr>';
}
echo '</table>';
if ( ! empty( $certificate_text ) )
{
// Certificate Text block 2.
echo '<br /><div class="transcript-certificate-block2">' . $certificate_text . '</div>';
}
$footer_html = ob_get_clean();
// @since 4.8 Add Transcripts PDF footer action hook.
// @since 7.5 Echo your custom text before or append it to $footer_html to display it after.
do_action( 'Grades/includes/Transcripts.fnc.php|pdf_footer', [ $student['ID'], $last_grade, &$footer_html ] );
echo $footer_html;
}
}
/**
* Get Transcripts Students data from DB
*
* @since 4.8
* @since 5.5 SELECT s.* Custom Fields for Substitutions (SELECT s.*).
*
* @param string $st_list Student IDs list.
* @param string $syear School Year.
* @return array Students data.
*/
function _getTranscriptsStudents( $st_list, $syear )
{
$students_dataquery = "SELECT s.*," . DisplayNameSQL( 's' ) . " AS FULL_NAME";
$custom_fields_RET = DBGet( "SELECT ID,TITLE,TYPE
FROM custom_fields
WHERE ID IN (200000000,200000003,200000004)", [], [ 'ID' ] );
if ( ! empty( $custom_fields_RET['200000000'] )
&& $custom_fields_RET['200000000'][1]['TYPE'] == 'select' )
{
$students_dataquery .= ",s.custom_200000000 as gender";
}
if ( ! empty( $custom_fields_RET['200000003'] ) )
{
$students_dataquery .= ",s.custom_200000003 as ssecurity";
}
if ( ! empty( $custom_fields_RET['200000004'] )
&& $custom_fields_RET['200000004'][1]['TYPE'] == 'date' )
{
$students_dataquery .= ",s.custom_200000004 as birthdate";
}
//, s.custom_200000012 as estgraddate
$students_dataquery .= ",a.address
,a.city
,a.state
,a.zipcode
,a.phone
,a.mail_address
,a.mail_city
,a.mail_state
,a.mail_zipcode
,(SELECT start_date FROM student_enrollment
WHERE student_id=s.student_id
ORDER BY syear, start_date
LIMIT 1) as init_enroll
,(SELECT sgl.title
FROM school_gradelevels sgl JOIN student_enrollment se ON (sgl.id=se.grade_id)
WHERE se.syear='" . $syear . "'
AND se.student_id=s.student_id
AND (se.end_date is null OR se.start_date < se.end_date)
ORDER BY se.start_date desc
LIMIT 1) as grade_level
,(SELECT sgl2.title
FROM school_gradelevels sgl2, school_gradelevels sgl JOIN student_enrollment se ON (sgl.id=se.grade_id)
WHERE se.syear='" . $syear . "'
AND se.student_id=s.student_id
AND (se.end_date is null OR se.start_date < se.end_date)
AND sgl2.id=sgl.next_grade_id
ORDER BY se.start_date desc
LIMIT 1) as next_grade_level
FROM students s
LEFT OUTER JOIN students_join_address sja ON (sja.student_id=s.student_id)
LEFT OUTER JOIN address a ON (a.address_id=sja.address_id) ";
$students_RET = DBGet( $students_dataquery .
' WHERE s.student_id IN (' . $st_list . ')
ORDER BY FULL_NAME', [], [ 'STUDENT_ID' ] );
return $students_RET;
}