__ __ __ __ _____ _ _ _____ _ _ _
| \/ | \ \ / / | __ \ (_) | | / ____| | | | |
| \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | |
| |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | |
| | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | |
|_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
if you need WebShell for Seo everyday contact me on Telegram
Telegram Address : @jackleet
For_More_Tools:
<?php
Widgets( 'request' );
Widgets( 'mailing_labels' );
$_REQUEST['mailing_labels'] = issetVal( $_REQUEST['mailing_labels'], '' );
if ( empty( $_REQUEST['search_modfunc'] ) )
{
DrawHeader( ProgramTitle() );
$extra['new'] = true;
$extra['action'] = issetVal( $extra['action'], '' );
$extra['action'] .= "&_ROSARIO_PDF=true";
Search( 'student_id', $extra );
}
else
{
$columns = [
'COURSE_TITLE' => _( 'Course' ),
'WITH_FULL_NAME' => '<span class="a11y-hidden">' . _( 'Request' ) . '</span>',
];
$extra['SELECT'] .= ",c.TITLE AS COURSE_TITLE,srp.PRIORITY,srp.MARKING_PERIOD_ID,srp.WITH_TEACHER_ID,srp.NOT_TEACHER_ID,srp.WITH_PERIOD_ID,srp.NOT_PERIOD_ID,'' AS WITH_FULL_NAME";
$extra['FROM'] .= ',courses c,schedule_requests srp';
$extra['WHERE'] .= ' AND ssm.STUDENT_ID=srp.STUDENT_ID AND ssm.SYEAR=srp.SYEAR AND srp.COURSE_ID = c.COURSE_ID';
//FJ add subject areas
$extra['functions'] += [ 'WITH_FULL_NAME' => '_makeExtra' ];
$extra['group'] = [ 'STUDENT_ID' ];
//FJ add ORDER BY COURSE_TITLE
$extra['ORDER_BY'] = 'COURSE_TITLE';
if ( $_REQUEST['mailing_labels'] == 'Y' )
{
$extra['group'][] = 'ADDRESS_ID';
}
$RET = GetStuList( $extra );
if ( ! empty( $RET ) )
{
$handle = PDFStart();
foreach ( (array) $RET as $student_id => $courses )
{
if ( $_REQUEST['mailing_labels'] == 'Y' )
{
foreach ( (array) $courses as $address )
{
unset( $_ROSARIO['DrawHeader'] );
DrawHeader( _( 'Student Requests' ) );
DrawHeader( $address[1]['FULL_NAME'], $address[1]['STUDENT_ID'] );
DrawHeader( $address[1]['GRADE_ID'] );
DrawHeader( SchoolInfo( 'TITLE' ), ProperDate( DBDate() ) );
// @since 11.6 Add Mailing Label position
echo MailingLabelPositioned( $address[1]['MAILING_LABEL'] );
ListOutput( $address, $columns, 'Request', 'Requests' );
echo '<div style="page-break-after: always;"></div>';
}
}
else
{
unset( $_ROSARIO['DrawHeader'] );
DrawHeader( _( 'Student Requests' ) );
DrawHeader( $courses[1]['FULL_NAME'], $courses[1]['STUDENT_ID'] );
DrawHeader( $courses[1]['GRADE_ID'] );
DrawHeader( SchoolInfo( 'TITLE' ), ProperDate( DBDate() ) );
ListOutput( $courses, $columns, 'Request', 'Requests' );
echo '<div style="page-break-after: always;"></div>';
}
}
PDFStop( $handle );
}
else
{
BackPrompt( _( 'No Students were found.' ) );
}
}
/**
* @param $value
* @param $title
* @return mixed
*/
function _makeExtra( $value, $title = '' )
{
global $THIS_RET;
$return = [];
if ( ! empty( $THIS_RET['WITH_TEACHER_ID'] ) )
{
$return[] = _( 'With' ) . ' ' . GetTeacher( $THIS_RET['WITH_TEACHER_ID'] );
}
if ( ! empty( $THIS_RET['NOT_TEACHER_ID'] ) )
{
$return[] = _( 'Not With' ) . ' ' . GetTeacher( $THIS_RET['NOT_TEACHER_ID'] );
}
if ( ! empty( $THIS_RET['WITH_PERIOD_ID'] ) )
{
$return[] = _( 'On' ) . ' ' . _getPeriod( $THIS_RET['WITH_PERIOD_ID'] );
}
if ( ! empty( $THIS_RET['NOT_PERIOD_ID'] ) )
{
$return[] = _( 'Not on' ) . ' ' . _getPeriod( $THIS_RET['NOT_PERIOD_ID'] );
}
if ( ! empty( $THIS_RET['PRIORITY'] ) )
{
$return[] = _( 'Priority' ) . ' ' . $THIS_RET['PRIORITY'];
}
if ( ! empty( $THIS_RET['MARKING_PERIOD_ID'] ) )
{
$return[] = _( 'Marking Period' ) . ' ' . GetMP( $THIS_RET['MARKING_PERIOD_ID'] );
}
$return = implode( ' — ', $return );
return $return;
}
/**
* @param $period_id
* @return mixed
*/
function _getPeriod( $period_id )
{
static $periods_RET;
if ( empty( $periods_RET ) )
{
$periods_RET = DBGet( "SELECT TITLE,PERIOD_ID
FROM school_periods
WHERE SYEAR='" . UserSyear() . "'", [], [ 'PERIOD_ID' ] );
}
return $periods_RET[$period_id][1]['TITLE'];
}