public static function showAdminDashboard() { $ctr = 0; $all_records = Record::with(['user' => function ($query) { $query->where('type', '=', 'agent'); }]); if (!empty(request('gender'))) { $all_records = $all_records->where('gender', request('gender')); } if (!empty(request('age_from'))) { $all_records = $all_records->where('age', '>=', request('age_from')); } if (!empty(request('age_to'))) { $all_records = $all_records->where('age', '<=', request('age_to')); } $all_records = $all_records->orderBy('updated_at')->orderBy('gender')->orderBy('age', 'DESC')->paginate(20); $all_records->setPath("?gender=" . request('gender') . "&age_from=" . request('age_from') . "&age_to=" . request('age_to')); $callbacks = Callback::where('schedule', '>', date('Y-m-d', strtotime('-2 day', time())))->get(); return view('auth.dashboard', compact('ctr', 'all_records', 'callbacks')); }
public static function showList2() { // Update user status to IDLE Auth::user()->addStatus('IDLE'); $records = Record::with(['demographic_2nd'])->whereUserId(Auth::user()->id)->whereListId(2); if (!empty(request('gender'))) { $records = $records->where('gender', request('gender')); } if (!empty(request('age_from'))) { $records = $records->where('age', '>=', request('age_from')); } if (!empty(request('age_to'))) { $records = $records->where('age', '<=', request('age_to')); } $ctr = 0; $records = $records->orderBy('updated_at')->orderBy('gender')->orderBy('age', 'DESC')->paginate(20); $records->setPath("?gender=" . request('gender') . "&age_from=" . request('age_from') . "&age_to=" . request('age_to')); // get callbacks with filters $callbacks = Auth::user()->callbacks()->where('schedule', '>', date('Y-m-d', strtotime('-2 day', time())))->get(); return view('medical_record_number.record_2nd_list', compact('records', 'ctr', 'callbacks')); }
/** * Shows the view to edit a Record * * @param $id the id of the Record to view */ public function edit($id) { $record = Record::with('itemtype')->with('fields')->findOrFail($id); $itemtype = Itemtype::with(array('marcfields' => function ($query) { $query->with('marcsubfields')->get(); }))->find($record->itemtype()->first()->id); return view('admin.records.edit', ['record' => $record, 'itemtype' => $itemtype, 'biblio_id' => $record->biblio]); }