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