/**
* 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);
}
