protected function portalUpdateTimesheet() { $authUserId = \Auth::id(); $authEmployee = Employee::where('userId','=',$authUserId)->first(); $empId = $authEmployee->id; $timesheet = Timesheet::where('empId','=',$empId)->first(); $sun = Input::get('sunday'); $mon = Input::get('monday'); $tues = Input::get('tuesday'); $wed = Input::get('wednesday'); $thurs = Input::get('thursday'); $fri = Input::get('friday'); $sat = Input::get('saturday'); $total = $sun + $mon + $tues + $wed + $thurs + $fri + $sat; $timesheet->sunday = $sun; $timesheet->monday = $mon; $timesheet->tuesday = $tues; $timesheet->wednesday = $wed; $timesheet->thursday = $thurs; $timesheet->friday = $fri; $timesheet->saturday = $sat; $timesheet->total = $total; $timesheet->updated_at = gmdate("Y-m-d H:i:s"); $timesheet->save(); return Redirect::to('/portal-timesheet'); }
<?php $matiere = \App\Matter::where('id', $plan->matter_id)->first(); foreach ($matiere->lesteachers->unique() as $item) { echo $item->nom_teacher; } ?> </td> <td> {{ $plan->dayname }} </td> <td>{{ substr(\Carbon\Carbon::parse($plan->time)->toTimeString(),0,-3) }}</td> <td> <?php $salle = \App\Timesheet::where('classroom_id', $plan->classroom_id)->where('time', $plan->time)->where('user_id', \Auth::user()->id)->where('color', '#525252')->where('dayname', $plan->dayname)->first(); if ($salle) { echo \Auth::user()->rooms()->where('id', $salle->room_id)->first()->nom_salle; } ?> </td> <td> <?php $classroom = \App\Classroom::where('id', $plan->classroom_id)->first(); foreach ($classroom->lesNiveaux as $niveau) { echo $niveau->niveau; } foreach ($classroom->levels as $niveau) {
public function trierparsalle() { if (\Request::ajax()) { $room_id = \Input::get('room_id'); $plans = Timesheet::where('user_id', \Auth::user()->id)->CurrentYear()->where('matter_id', '!=', 0)->get(); foreach ($plans as $plan) { $salle = Timesheet::where("classroom_id", $plan->classroom_id)->where("time", $plan->time)->where("user_id", \Auth::user()->id)->where("color", "#525252")->where("dayname", $plan->dayname)->CurrentYear()->first(); if ($salle && $salle->room_id == $room_id) { echo '<tr>'; echo ' <td> ' . Classroom::where('id', $plan->classroom_id)->CurrentYear()->first()->nom_classe . '</td>'; echo ' <td> ' . Matter::where('id', $plan->matter_id)->first()->nom_matiere . ' </td>'; echo ' <td>'; foreach (Matter::where('id', $plan->matter_id)->first()->lesteachers->unique() as $item) { echo $item->nom_teacher; } echo '</td>'; echo '<td>'; echo $plan->dayname; echo '</td>'; echo '<td>'; echo substr(Carbon::parse($plan->time)->toTimeString(), 0, -3); echo '</td>'; echo '<td>'; $salle = Timesheet::where("classroom_id", $plan->classroom_id)->where("time", $plan->time)->where("user_id", \Auth::user()->id)->where("color", "#525252")->CurrentYear()->where("dayname", $plan->dayname)->first(); if ($salle) { echo \Auth::user()->rooms()->where('id', $salle->room_id)->first()->nom_salle; } echo '</td>'; echo '<td>'; $classroom = Classroom::where('id', $plan->classroom_id)->CurrentYear()->first(); foreach ($classroom->lesNiveaux as $niveau) { echo $niveau->niveau; } foreach ($classroom->levels as $niveau) { echo $niveau->niveau; } echo '</td>'; echo '<td>'; $classroom = Classroom::where('id', $plan->classroom_id)->CurrentYear()->first(); if ($classroom->branches->isEmpty()) { echo '--'; } else { foreach ($classroom->branches as $br) { echo $br->nom_branche; } } echo '</td>'; echo ' </tr>'; } } } }
public function del() { if (\Request::ajax()) { $id = \Input::get('id'); $ok = Timesheet::where('user_id', \Auth::user()->id)->where('id', $id)->first(); $ok->delete(); } }
public function showef($id) { $ts = Timesheet::where('classroom_id', $id)->first(); return view('classrooms.showef', compact('ts')); }
protected function portalResetTimesheet($id) { if ( \Auth::user() ) { $userTypeID = \Auth::user()->userTypeId; if ( $userTypeID == 1 ) { $authUserId = \Auth::id(); $authEmployee = Employee::where('userId','=',$authUserId)->first(); $empId = $id; $timesheet = Timesheet::where('empId','=',$empId)->first(); $timesheet->sunday = 0; $timesheet->monday = 0; $timesheet->tuesday = 0; $timesheet->wednesday = 0; $timesheet->thursday = 0; $timesheet->friday = 0; $timesheet->saturday = 0; $timesheet->total = 0; $timesheet->save(); return Redirect::to('/portal-emp-timesheets/' . $empId); } else if ( $userTypeID == 2 ) { return Redirect::to('/portal-settings'); } else { return Redirect::to('/account'); } } else { return Redirect::to('/'); } }