function printObject($array, $store, $dayname, $department)
{
if ($store != 0) {
foreach ($array as $a) {
$class_code = $a->class_name . $dayname . $store;
$c_code = $a->class_name;
$s_time = $a->start_time;
$e_time = $a->end_time;
$day = $dayname;
$room = $store;
$prevroutines = Time_table::where('course_code', $c_code)->where('day', $day)->delete();
$routine = new Time_table();
$routine->class_id = $class_code;
$routine->course_code = $c_code;
$routine->stime = $s_time;
$routine->etime = $e_time;
$routine->day = $day;
$routine->department_code = $department;
$routine->room = $room;
$routine->save();
}
}
echo "<table border='1'>";
echo "<tr align='center' border=5>";
echo "<td>Course Code</td>";
foreach ($array as $a) {
$coursecode = Course_detail::where('id', $a->class_name)->first()->course_code;
echo "<td>" . $coursecode . "</td>";
}
echo "</tr>";
echo "<tr align='center' border=5>";
echo "<td>Instructor</td>";
foreach ($array as $a) {
$offered_by = Course_detail::where('id', $a->class_name)->first()->offered_by;
echo "<td>" . $offered_by . "</td>";
}
echo "</tr>";
echo "<tr align='center' border=5>";
echo "<td>Offered_to</td>";
foreach ($array as $a) {
$offered_to = Course_detail::where('id', $a->class_name)->first()->offered_to;
echo "<td>" . $offered_to . "</td>";
}
echo "</tr>";
echo "<tr align='center' border=5>";
echo "<td bgcolor='green'>Start Time</td>";
foreach ($array as $a) {
echo "<td>" . $a->start_time . "</td>";
}
echo "</tr>";
echo "<tr align='center' border=5>";
echo "<td bgcolor='red'>End Time</td>";
foreach ($array as $a) {
echo "<td>" . $a->end_time . "</td>";
}
echo "</tr>";
echo "</table>";
echo "<br>";
}
public function removeuser()
{
$username = Input::get('selected_username');
$id = User::where('username', $username)->first()->id;
$usercourses = Course_detail::where('offered_by', $username)->get();
foreach ($usercourses as $usercourse) {
Schedule::where('course_code', $usercourse->id)->delete();
Time_table::where('course_code', $usercourse->id)->delete();
}
Course_detail::where('offered_by', $username)->delete();
user_detail::where('id', $id)->delete();
User::where('username', $username)->delete();
return redirect('/home');
}
public function removecourse()
{
$course = Input::get('selectcoursecode');
$courseclasses = Course_detail::where('course_code', $course)->get();
foreach ($courseclasses as $courseclass) {
//delete schedules data
Schedule::where('course_code', $courseclass->id)->delete();
Time_table::where('course_code', $courseclass->id)->delete();
}
//delete class data
Course_detail::where('course_code', $course)->delete();
//delete own data
Course::where('course_code', $course)->delete();
return view('layouts.removecourse')->with('deletemsg', 'Course Deleted');
}
public function removegroup()
{
$groupname = Input::get('selectgroup_name');
$groups = Group::where('group_name', $groupname)->get();
foreach ($groups as $group) {
$offered_to = $group->group_code;
$batchcourses = Course_detail::where('offered_to', $offered_to)->get();
foreach ($batchcourses as $batchcourse) {
//delete schedules data
Schedule::where('course_code', $batchcourse->id)->delete();
Time_table::where('course_code', $batchcourse->id)->delete();
}
// delete class data
Course_detail::where('offered_to', $offered_to)->delete();
}
//delete the group
Group::where('group_name', $groupname)->delete();
return view('layouts.removegroup')->with('deletemsg', 'group Deleted');
}
?>
</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>";
}
?>
</table>
$slot++;
}
?>
</tr>
<?php
$i = 1;
foreach ($completeSchedule as $b) {
echo "<tr>";
echo "<td align='center' width='10%'><span style='font-weight:bold'>" . no2day($i) . "</span></td>";
$i++;
$old_stime = 7;
$old_etime = 7;
foreach ($b as $a) {
$course = $a[0];
$course_code = Course_detail::where('id', $course)->first()->course_code;
$batch = Course_detail::where('id', $course)->first()->offered_to . '( ' . Course_detail::where('id', $course)->first()->department_code . ' )';
$stime = $a[1];
$etime = $a[2];
$room = $a[3];
if ($stime == 7) {
$fillslot = $etime - $stime;
echo "<th colspan='" . $fillslot . "'>" . $batch . "<br> Room: " . $room . "</th>";
} else {
if ($stime > 7 && $old_etime == 7) {
$fillslot = $stime - $old_etime;
while ($fillslot != 0) {
echo "<td></td>";
$fillslot--;
}
$fillslot = $etime - $stime;
echo "<th colspan='" . $fillslot . "'>" . $batch . "<br> Room: " . $room . "</th>";
@include('layouts.include.adminsidebar')
@endsection
@section('bodycontent')
<div class = "span9">
{!! Form::open(array('action'=>'AdminScheduleController@viewsubjectschedule', 'method'=>'post')) !!}
<?php
use App\Department;
use App\User;
use App\User_detail;
use App\Group;
use App\Course;
use App\Course_detail;
$id = User::where('username', $scheduleuser)->first()->id;
$department = User_detail::where('id', $id)->first()->department;
$subjects = Course_detail::where('offered_by', $scheduleuser)->groupby('course_code')->lists('course_code', 'course_code');
?>
<fieldset>
<legend>Department: {{ $department }}</legend>
<div class="control-group">
{!! Form::label('subjectcode', 'Select Subject:', array('class' => 'control-label')) !!}
<div class="controls">
{!! Form::select('selectsubject', $subjects) !!}
</div>
<div class="controls">
{!! Form::hidden('teacherdepart', $department) !!}
{!! Form::hidden('teachername', $scheduleuser) !!}
</div>
</div>
<div class="control-group">
<div class="controls">
@include('layouts.include.nav_teachers')
@endsection
@section('sidebar')
@include('layouts.include.sidebar')
@endsection
@include('layouts.include.functions')
@section('bodycontent')
<div class = "span9">
<?php
use App\Course_detail;
use App\Course;
use App\Schedule;
$course = $courseid;
$coursedetails = Course_detail::where('id', $course)->first();
$title = Course::where('course_code', $coursedetails->course_code)->first()->course_title;
?>
<h1>{{ $coursedetails->course_code }}</h1>
<p>Please enter the timings for the enrollment <strong>{{ $title }}</strong></p>
<p>Batch: <strong>{{ $coursedetails->offered_to }}</strong></p>
<p>Department: <strong>{{ $coursedetails->department_code }}</strong></p>
{!! Form::open(array('action'=>'CourseDetailController@offerclasstime', 'method'=>'post')) !!}
@if ($errors->has())
<div class="alert alert-danger">
@foreach($errors->all() as $error)
{{ $error }}<br>
@endforeach
</div>
@endif
<table class="table table-hover">
<thead>
<tr>
<th>SN</th>
<th>Course Code</th>
<th>Course Title</th>
<th>Credit</th>
<th>Offered To</th>
</tr>
</thead>
<tbody>
<?php
use App\Course_detail;
use App\Course;
$offered_by = $username;
$offeredcourses = Course_detail::where('offered_by', $offered_by)->orderby('course_code')->get();
$c = 1;
?>
@foreach($offeredcourses as $offeredcourse)
<?php
$coursedetail = Course::where('course_code', $offeredcourse->course_code)->first();
?>
<tr>
<td>{{ $c }} </td>
<td><a href="viewclass?courseselected=<?php
echo $offeredcourse->id;
?>
">{{ $offeredcourse->course_code }}</a></td>
<td>{{ $coursedetail->course_title }}</td>
<td>{{ $coursedetail->credit }}</td>
<td>{{ $offeredcourse->offered_to }} ( {{ $offeredcourse->department_code }} )</td>
public function removedepartment()
{
$departcode = Input::get('selectdepartmentcode');
//delete schedules data
$departcourses = Course_detail::where('department_code', $departcode)->get();
foreach ($departcourses as $departcourse) {
Schedule::where('course_code', $departcourse->id)->delete();
Time_table::where('course_code', $departcourse->id)->delete();
}
//Delete course details data
Course_detail::where('department_code', $departcode)->delete();
//Delete groups data
Group::where('department', $departcode)->delete();
//Delete user data
$departusers = User_detail::where('department', $departcode)->get();
foreach ($departusers as $departuser) {
if (User::where('id', $departuser->id)->first()->utype == 0) {
User_detail::where('id', $departuser->id)->delete();
User::where('id', $departuser->id)->delete();
}
}
Department::where('code', $departcode)->delete();
return view('layouts.removedepartment')->with('deletemsg', 'Department Deleted');
}
function showbatchschedule($batchschedule)
{
$i = 1;
while ($i <= 6) {
${no2day($i)} = array();
$i++;
}
foreach ($batchschedule 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;
case "Wednesday":
array_push($Wednesday, array($course_code, $stime, $etime, $room));
break;
case "Thursday":
array_push($Thursday, array($course_code, $stime, $etime, $room));
break;
case "Friday":
array_push($Friday, array($course_code, $stime, $etime, $room));
break;
}
}
$completeSchedule = array(${no2day(1)}, ${no2day(2)}, ${no2day(3)}, ${no2day(4)}, ${no2day(5)}, ${no2day(6)});
$day = 1;
//To get the day SUnday,Monday by using thhe function
?>
<table style='width:95%' border='1'>
<tr>
<td align='center'><span style='font-weight:bold'>{{ "Batch: ".$batch."( ".$department." )"}}</span></td>
<?php
$slot = 0;
$time = 7;
$step = 1;
//TO make it flexible for half hour slot and hour slot
$total_classes = 9;
while ($slot < $total_classes / $step) {
$slot_period = (string) $time . " - " . ((string) $time + $step);
echo "<td align='center' width='7%'><span style='font-weight:bold'>" . $slot_period . "</span></td>";
$time = $time + $step;
$slot++;
}
?>
</tr>
<?php
$i = 1;
foreach ($completeSchedule as $b) {
echo "<tr>";
echo "<td align='center' width='10%'><span style='font-weight:bold'>" . no2day($i) . "</span></td>";
$i++;
$old_stime = 7;
$old_etime = 7;
foreach ($b as $a) {
$course = $a[0];
$course_code = Course_detail::where('id', $course)->first()->course_code;
$batch = Course_detail::where('id', $course)->first()->offered_to . '( ' . Course_detail::where('id', $course)->first()->department_code . ' )';
$stime = $a[1];
$etime = $a[2];
$room = $a[3];
if ($stime == 7) {
$fillslot = $etime - $stime;
echo "<th colspan='" . $fillslot . "'>" . $course_code . "<br> Room: " . $room . "</th>";
} else {
if ($stime > 7 && $old_etime == 7) {
$fillslot = $stime - $old_etime;
while ($fillslot != 0) {
echo "<td></td>";
$fillslot--;
}
$fillslot = $etime - $stime;
echo "<th colspan='" . $fillslot . "'>" . $course_code . "<br> Room: " . $room . "</th>";
} else {
//Second class of the day
if ($stime == $old_etime) {
$fillslot = $etime - $stime;
echo "<th colspan='" . $fillslot . "'>" . $course_code . "<br> Room: " . $room . "</th>";
} else {
if ($stime > $old_etime) {
$fillslot = $stime - $old_etime;
while ($fillslot != 0) {
echo "<td></td>";
$fillslot--;
}
$fillslot = $etime - $stime;
echo "<th colspan='" . $fillslot . "'>" . $course_code . "<br> Room: " . $room . "</th>";
}
}
}
}
$old_stime = $stime;
$old_etime = $etime;
}
if ($old_etime != 16) {
$fillslot = 16 - $old_etime;
while ($fillslot != 0) {
echo "<td></td>";
$fillslot--;
}
}
echo "</tr>";
}
}
public function offerclasstime()
{
if (Input::get('code') != null && isset($_POST['offer_classtime']) && isset($_POST['set'])) {
$errorarray = array();
foreach ($_POST['set'] as $set) {
$starttime = Input::get('starttime' . $set);
$endtime = Input::get('endtime' . $set);
$classcode = Input::get('code');
if ($starttime == null || $endtime == null) {
$errorarray[count($errorarray)] = "You cannot leave time values empty (" . $set . ")";
} else {
if ($starttime >= $endtime) {
$errorarray[count($errorarray)] = "Start time must be less than End time (" . $set . ")";
} else {
//Checking for Batch time conflict
$offered_to = Course_detail::where('id', $classcode)->first()->offered_to;
$batchclasses = Course_detail::where('offered_to', $offered_to)->get();
foreach ($batchclasses as $batchclass) {
$batchschedule = Schedule::where('class_id', $batchclass->id . $set)->first();
$scheludeclasscode = $batchschedule['class_id'];
if ($scheludeclasscode != $classcode . $set) {
$stime = $batchschedule['stime'];
$etime = $batchschedule['etime'];
$flag = 0;
$case1 = 0;
if ($starttime <= $stime && $endtime > $stime) {
$flag = 1;
$case1 = 1;
} else {
if ($starttime >= $stime && $endtime < $etime) {
$flag = 1;
} else {
if ($starttime >= $stime && $starttime < $etime && $case1 != 1) {
$flag = 1;
}
}
}
if ($flag == 1) {
$errorarray[count($errorarray)] = "Time slot: " . $starttime . "-" . $endtime . " (" . $set . ") for batch " . $offered_to . " is occupied by another subject " . $batchclass->course_code;
}
}
}
//Checking for instructor time conflict
$offered_by = Course_detail::where('id', $classcode)->first()->offered_by;
$instructorclasses = Course_detail::where('offered_by', $offered_by)->get();
foreach ($instructorclasses as $instructorclass) {
$instructorschedule = Schedule::where('class_id', $instructorclass->id . $set)->first();
$scheludeclasscode = $instructorschedule['class_id'];
if ($scheludeclasscode != $classcode . $set) {
$stime = $instructorschedule['stime'];
$etime = $instructorschedule['etime'];
$flag = 0;
$case1 = 0;
if ($starttime <= $stime && $endtime > $stime) {
$flag = 1;
$case1 = 1;
} else {
if ($starttime >= $stime && $endtime < $etime) {
$flag = 1;
} else {
if ($starttime >= $stime && $starttime < $etime && $case1 != 1) {
$flag = 1;
}
}
}
if ($flag == 1) {
$errorarray[count($errorarray)] = "You have another class " . $instructorclass->course_code . " in Time slot: " . $starttime . "-" . $endtime . " (" . $set . ") for batch " . $instructorclass->offered_to;
}
}
}
//Checking time conflict for day
//Teacher ko department line ho ki students ko department choose accordingly
//for now lets use teacher's department
$offered_by = Course_detail::where('id', $classcode)->first()->offered_by;
$departcode = User_detail::where('id', User::where('username', $offered_by)->first()->id)->first()->department;
$departmentmaxrooms = Department::where('code', $departcode)->first()['total_rooms'];
$counter = 0;
$dayschedules = Schedule::where('day', $set)->where('department_code', $departcode)->get();
foreach ($dayschedules as $dayschedule) {
$stime = $dayschedule->stime;
$etime = $dayschedule->etime;
$case1 = 0;
if ($starttime <= $stime && $endtime > $stime) {
$counter++;
$case1 = 1;
} else {
if ($starttime >= $stime && $endtime < $etime) {
$counter++;
} else {
if ($starttime >= $stime && $starttime < $etime && $case1 != 1) {
$counter++;
}
}
}
}
if ($counter >= $departmentmaxrooms) {
$errorarray[count($errorarray)] = "Sorry the room management is not possible for your time slots for " . $set;
}
}
}
}
if (count($errorarray) > 0) {
return Redirect::Back()->withInput()->withErrors($errorarray);
} else {
foreach ($_POST['set'] as $set) {
$starttime = Input::get('starttime' . $set);
$endtime = Input::get('endtime' . $set);
$classcode = Input::get('code');
Schedule::where('course_code', $classcode)->where('day', $set)->delete();
Time_table::where('course_code', $classcode)->where('day', $set)->delete();
//Teacher ko department line ho ki students ko department choose accordingly
//for now lets use teacher's department
$offered_by = Course_detail::where('id', $classcode)->first()->offered_by;
$departcode = User_detail::where('id', User::where('username', $offered_by)->first()->id)->first()->department;
$newschedule = new Schedule();
$newschedule->class_id = $classcode . $set;
$newschedule->course_code = $classcode;
$newschedule->stime = $starttime;
$newschedule->etime = $endtime;
$newschedule->day = $set;
$newschedule->department_code = $departcode;
$newschedule->save();
}
return Redirect::back();
}
} else {
if (isset($_POST['remove_classtime']) && isset($_POST['set'])) {
foreach ($_POST['set'] as $set) {
$classcode = Input::get('code');
Time_table::where('course_code', $classcode)->where('day', $set)->delete();
Schedule::where('course_code', $classcode)->where('day', $set)->delete();
return Redirect::back();
}
} else {
return Redirect::back();
}
}
}
@include('layouts.include.sidebar')
@endsection
@section('bodycontent')
<div class = "span9">
{!! Form::open(array('action'=>'RoutineDisplayController@viewsubjectschedule', 'method'=>'post')) !!}
<?php
use App\Department;
use App\User;
use App\User_detail;
use App\Group;
use App\Course;
use App\Course_detail;
$id = User::where('username', $username)->first()->id;
$department = User_detail::where('id', $id)->first()->department;
$subjects = Course_detail::where('offered_by', $username)->groupby('course_code')->lists('course_code', 'course_code');
?>
<fieldset>
<legend>Department: {{ $department }}</legend>
<div class="control-group">
{!! Form::label('subjectcode', 'Select Subject:', array('class' => 'control-label')) !!}
<div class="controls">
{!! Form::select('selectsubject', $subjects) !!}
</div>
<div class="controls">
{!! Form::hidden('teacherdepart', $department) !!}
</div>
</div>
<div class="control-group">
<div class="controls">
{!! Form::submit('Check Routine', ['class'=>'btn btn-primary','value'=>'showsubjectschedule', 'name'=>'showsubjectschedule']) !!}
