/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $user = Auth::user(); $criteria = array('report_date_id' => $id, 'institution_id' => $user->institution->id); $assessments = Assessment::where($criteria)->paginate(10); $report_date = ReportDate::findOrFail($id); return view('tviadmin.assessments.index2', array('assessments' => $assessments, 'report_date' => $report_date)); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $user = JWTAuth::parseToken()->authenticate(); $assessment = Assessment::where('user_id', $user->id)->orderBy('date_start', 'desc')->paginate(10); if (Gate::denies('index-assessment', $assessment)) { abort(403); } return response()->json($assessment); }
public function reportsview() { $input = Input::all(); if (empty($input)) { abort(404); } $assessment = Assessment::where('status', 1); if (!empty($input['user'])) { $this->data['user'] = User::findOrFail($input['user']); $assessment = $assessment->with('user')->where('user_id', $input['user']); } if (!empty($input['key'])) { $assessment = $assessment->whereHas('user', function ($qq) use($input) { return $qq->where('fullname', 'LIKE', '%' . trim($input['key']) . '%'); }); } if (!empty($input['type'])) { $assessment = $assessment->whereHas('exam', function ($qq) use($input) { return $qq->where('type', strtolower($input['type'])); }); } if (!empty($input['from']) && !empty($input['to'])) { $assessment = $assessment->whereBetween('created_at', [Carbon::createFromFormat('Y-m-d', $input['from'])->subDays(1)->toDateTimeString(), Carbon::createFromFormat('Y-m-d', $input['to'])->addDays(1)->toDateTimeString()]); } $this->data['assessment'] = $assessment->get(); $this->data['input'] = $input; if (!empty($input['download']) && $input['download'] == 'pdf') { unset($this->data['input']['download']); $pdf = \App::make('dompdf.wrapper'); return $pdf->loadView('home.reportsprint', $this->data)->download(str_slug('exam ' . $input['type'] . ' report export ' . date('Y-m-d')) . '.pdf'); } return view('home.reportsview', $this->data); }