public function findPosts(Request $request){
$category_id = $request->input('cat_id');
$date = $request->input('date');
$user_id = $request->input('user_id');
$status = $request->input('status');
$posts = Post::when($category_id, function ($query,$category_id) {
return $query->whereRaw('FIND_IN_SET("'.$category_id.'",cats)');
})
->when($date, function ($query,$date) {
$getData = explode('-',$date);
$month = $getData[0];
$year = $getData[1];
return $query->whereMonth('created_at', $month)->whereYear('created_at', $year);
})
->when($user_id, function ($query,$user_id) {
return $query->where('creator', $user_id);
})
->when($status, function ($query,$status) {
if($status == 4){
return $query->where('status', 0);
}
else{
return $query->where('status', $status);
}
})
->orderBy('id','desc')->paginate(5);
$pageName='Post';
$urlName='posts';
$categories = Category::where('status',1)->select('name','id')->get();
$lastDate = Post::orderBy('id','asc')->select('created_at')->first();
$firstDate = Post::orderBy('id','desc')->select('created_at')->first();
return view('backend.post.index')
->with('pageName', $pageName)
->with('urlName', $urlName)
->with('data', $posts)
->with('categories',$categories)
->with('firstDate',$firstDate)
->with('lastDate',$lastDate);
}