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']) !!}