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]);
}
