public function enquiries() { $search = \Input::get('q'); $locale = $this->lang; // AGENT if ($this->admin->role_id == 3) { if ($search) { $enquiries = \App\Inquiry::whereHas('property', function ($q) use($search, $locale) { $q->where('user_id', $this->admin->id)->whereHas('propertyLanguages', function ($q) use($search, $locale) { $q->where('locale', $locale)->where('title', 'like', $search . '%'); }); })->orderBy('created_at', 'desc')->paginate($this->limit); } else { $enquiries = \App\Inquiry::whereHas('property', function ($q) { $q->where('user_id', $this->admin->id); })->orderBy('created_at', 'desc')->paginate($this->limit); } } else { if ($search) { $enquiries = \App\Inquiry::whereHas('property', function ($q) use($search, $locale) { $q->whereHas('propertyLanguages', function ($q) use($search, $locale) { $q->where('locale', $locale)->where('title', 'like', $search . '%'); }); })->orderBy('created_at', 'desc')->paginate($this->limit); } else { $enquiries = \App\Inquiry::orderBy('created_at', 'desc')->paginate($this->limit); } } return view('admin.pages.enquiries', compact('enquiries')); }
public function index() { $inquiries = Inquiry::orderBy('created_at', 'desc')->get(); return view('contacts.inquiries_index', ['title' => 'Inquiries', 'inquiries' => $inquiries]); }