foreach ($routinedepart as $block) {
echo "<br> <h3>Department: " . $block . " </h3> <br><br>";
$batchschedule = Time_table::join('course_details', 'time_tables.course_code', '=', 'course_details.id')->where('time_tables.department_code', $block)->where('course_details.offered_to', $batch)->select('time_tables.*')->orderby('time_tables.stime', 'ASC')->get();
showbatchschedule($batchschedule, $batch, $department);
?>
</table>
<br>
<table border='1'>
<tr>
<td><span style='font-weight:bold'>Course Code</span></td>
<td><span style='font-weight:bold'>Course Title</span></td>
<td><span style='font-weight:bold'>Course Instructor</span></td>
</tr>
<?php
$batchschedule = Time_table::join('course_details', 'time_tables.course_code', '=', 'course_details.id')->where('time_tables.department_code', $block)->where('course_details.offered_to', $batch)->select('time_tables.*')->orderby('time_tables.stime', 'ASC')->get();
foreach ($batchschedule as $routine) {
$course_code = Course_detail::where('id', $routine->course_code)->first()->course_code;
$course_title = Course::where('course_code', $course_code)->first()->course_title;
$offered_by = Course_detail::where('id', $routine->course_code)->first()->offered_by;
$id = User::where('username', $offered_by)->first()->id;
$userdetails = User_detail::where('id', $id)->first();
$fullname = $userdetails->first_name . " " . $userdetails->middle_name . " " . $userdetails->last_name;
if (str_replace(" ", "", $fullname) == null) {
$fullname = $offered_by;
}
echo "<tr>";
echo "<td>" . $course_code . "</td>";
echo "<td>" . $course_title . "</td>";
echo "<td>" . $fullname . "</td>";
echo "</tr>";
$id = User::where('username', $scheduleuser)->first()->id;
$userdetails = User_detail::where('id', $id)->first();
$fullname = $userdetails->first_name . " " . $userdetails->middle_name . " " . $userdetails->last_name;
?>
<h2>{{'Department: '.$userdetails->department}}</h2>
<?php
if (str_replace(" ", "", $fullname) == null) {
$fullname = $scheduleuser;
}
$i = 1;
while ($i <= 6) {
${no2day($i)} = array();
$i++;
}
//$teacherroutines = Time_table::where('course_code', Course_detail::where('offered_by', $username)->get())->orderby('stime', 'ASC')->get();
$teacherroutines = Time_table::join('course_details', 'time_tables.course_code', '=', 'course_details.id')->where('course_details.offered_by', $scheduleuser)->select('time_tables.*')->orderby('time_tables.stime', 'ASC')->get();
foreach ($teacherroutines as $routine) {
$stime = $routine->stime;
$etime = $routine->etime;
$room = $routine->room;
$course_code = $routine->course_code;
switch ($routine->day) {
case "Sunday":
array_push($Sunday, array($course_code, $stime, $etime, $room));
break;
case "Monday":
array_push($Monday, array($course_code, $stime, $etime, $room));
break;
case "Tuesday":
array_push($Tuesday, array($course_code, $stime, $etime, $room));
break;
use App\Course_detail;
use App\Course;
use App\User;
use App\User_detail;
use App\Group;
?>
<h2>{{'Department: '.$department}}</h2>
<h3>{{'Instructor: '.$scheduleuser}}</h3>
<?php
$i = 1;
while ($i <= 6) {
${no2day($i)} = array();
$i++;
}
echo "<br> The schedule for the <strong>Subject: " . $subject . " </strong>is as follows: <br><br>";
$subjectschedule = Time_table::join('course_details', 'time_tables.course_code', '=', 'course_details.id')->where('course_details.offered_by', $scheduleuser)->where('course_details.course_code', $subject)->where('time_tables.department_code', $department)->select('time_tables.*')->orderby('time_tables.stime', 'ASC')->get();
foreach ($subjectschedule as $routine) {
$stime = $routine->stime;
$etime = $routine->etime;
$room = $routine->room;
$course_code = $routine->course_code;
switch ($routine->day) {
case "Sunday":
array_push($Sunday, array($course_code, $stime, $etime, $room));
break;
case "Monday":
array_push($Monday, array($course_code, $stime, $etime, $room));
break;
case "Tuesday":
array_push($Tuesday, array($course_code, $stime, $etime, $room));
break;
}
echo "</tr>";
}
?>
</table>
<br>
<table border='1'>
<tr>
<td><span style='font-weight:bold'>Course Code</span></td>
<td><span style='font-weight:bold'>Course Title</span></td>
<td><span style='font-weight:bold'>Course Instructor</span></td>
</tr>
<?php
$roomschedule = Time_table::join('course_details', 'time_tables.course_code', '=', 'course_details.id')->where('time_tables.department_code', $department)->where('time_tables.room', $room)->select('time_tables.*')->groupby('course_details.course_code')->orderby('time_tables.course_code')->get();
foreach ($roomschedule as $routine) {
$course_code = Course_detail::where('id', $routine->course_code)->first()->course_code;
$course_title = Course::where('course_code', $course_code)->first()->course_title;
$offered_by = Course_detail::where('id', $routine->course_code)->first()->offered_by;
$id = User::where('username', $offered_by)->first()->id;
$userdetails = User_detail::where('id', $id)->first();
$fullname = $userdetails->first_name . " " . $userdetails->middle_name . " " . $userdetails->last_name;
if (str_replace(" ", "", $fullname) == null) {
$fullname = $offered_by;
}
echo "<tr>";
echo "<td>" . $course_code . "</td>";
echo "<td>" . $course_title . "</td>";
echo "<td>" . $fullname . "</td>";
echo "</tr>";
