__ __ __ __ _____ _ _ _____ _ _ _
| \/ | \ \ / / | __ \ (_) | | / ____| | | | |
| \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | |
| |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | |
| | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | |
|_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
if you need WebShell for Seo everyday contact me on Telegram
Telegram Address : @jackleet
For_More_Tools:
<?php
//FJ multiple school periods for a course period
/*$requests_RET = DBGet( "SELECT r.COURSE_ID AS CRS,
r.COURSE_ID,cp.COURSE_PERIOD_ID,
c.TITLE AS COURSE_TITLE,cp.PERIOD_ID,
(cp.TOTAL_SEATS-cp.FILLED_SEATS) AS OPEN_SEATS,s.STUDENT_ID AS SCHEDULED
FROM schedule_requests r,
courses c,school_periods sp,
course_periods cp LEFT OUTER JOIN schedule s ON
(s.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND s.STUDENT_ID='".UserStudentID()."')
WHERE
r.SYEAR='".UserSyear()."' AND r.SCHOOL_ID='".UserSchool()."'
AND r.COURSE_ID=cp.COURSE_ID AND c.COURSE_ID=cp.COURSE_ID
AND r.STUDENT_ID='".UserStudentID()."'
AND sp.PERIOD_ID=cp.PERIOD_ID
ORDER BY ".db_case(array('s.STUDENT_ID',"''","NULL",'sp.SORT_ORDER'))."
",array(),array('CRS','PERIOD_ID'));*/
$requests_RET = DBGet( "SELECT r.COURSE_ID AS CRS,r.COURSE_ID,cp.COURSE_PERIOD_ID,
c.TITLE AS COURSE_TITLE,cp.PERIOD_ID,
(cp.TOTAL_SEATS-cp.FILLED_SEATS) AS OPEN_SEATS,s.STUDENT_ID AS SCHEDULED
FROM schedule_requests r,courses c,school_periods sp,course_period_school_periods cpsp,course_periods cp
LEFT OUTER JOIN schedule s ON (s.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND s.STUDENT_ID='" . UserStudentID() . "')
WHERE cp.COURSE_PERIOD_ID=cpsp.COURSE_PERIOD_ID
AND r.SYEAR='" . UserSyear() . "'
AND r.SCHOOL_ID='" . UserSchool() . "'
AND r.COURSE_ID=cp.COURSE_ID
AND c.COURSE_ID=cp.COURSE_ID
AND r.STUDENT_ID='" . UserStudentID() . "'
AND sp.PERIOD_ID=cpsp.PERIOD_ID
ORDER BY " . db_case( [ 's.STUDENT_ID', "''", "NULL", 'sp.SORT_ORDER' ] ) . " ", [], [ 'CRS', 'PERIOD_ID' ] );
$periods_RET = DBGet( "SELECT PERIOD_ID,SHORT_NAME FROM school_periods WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER IS NULL,SORT_ORDER" );
echo '<table class="center" style="border: 1px solid;">';
echo '<tr><td></td>';
foreach ( (array) $periods_RET as $period )
{
echo '<td><b>' . $period['SHORT_NAME'] . '</b></td>';
}
foreach ( (array) $requests_RET as $course => $periods )
{
echo '<tr><td><b>' . $periods[key( $periods )][1]['COURSE_TITLE'] . '</b></td>';
foreach ( (array) $periods_RET as $period )
{
if ( $periods[$period['PERIOD_ID']][1]['SCHEDULED'] )
{
$color = '0000FF';
}
elseif ( $periods[$period['PERIOD_ID']] )
{
if ( $periods[$period['PERIOD_ID']][1]['OPEN_SEATS'] == 0 )
{
$color = 'FFFF00';
}
else
{
$color = '00FF00';
}
}
else
{
$color = 'CCCCCC';
}
echo '<td style="height:10px; width:6px; background-color:#' . $color . ';"></td>';
}
echo '</tr>';
}
echo '</table>';