public function doSearch(PlanSearchRequest $request) { $mrs[] = $request->mrs; $planSearchResult = []; $leaveRequestSearchResult = []; $from = $request->date_from; $to = $request->date_to; $allSearchedPlan = Plan::whereIn('mr_id', $mrs)->where('date', '>=', $from)->where('date', '<=', $to)->approved()->get(); $allSearchLeaveRequest = SMLeaveRequest::whereIn('sm_id', $mrs)->where('date', '>=', $from)->where('date', '<=', $to)->approved()->get(); foreach ($allSearchedPlan as $singleReport) { $planSearchResult[] = $singleReport; } foreach ($allSearchLeaveRequest as $singleLeaveRequest) { $leaveRequestSearchResult[] = $singleLeaveRequest; } $dataView = ['planSearchResult' => $planSearchResult, 'leaveRequestSearchResult' => $leaveRequestSearchResult]; return view('sm.search.plans.result', $dataView); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { list($keys, $values) = array_divide($this->_plan_courses->toArray()); $plans = Plan::whereIn('course_id', $keys)->get(); return view('plans.index', compact('plans')); }