/**
* 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);
$cooperative_trainings = CooperativeTraining::where($criteria)->paginate(10);
$report_date = ReportDate::findOrFail($id);
return view('tviadmin.cooperative_trainings.index2', array('cooperative_trainings' => $cooperative_trainings, 'report_date' => $report_date));
}
public function mls($subsector_id)
{
$result = CooperativeTraining::where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->whereIn('occupation_id', DB::table('occupations')->select('id')->where(array('subsector_id' => $subsector_id))->lists('id'))->sum('ml_training');
return $result;
}
