public static function getContact() { return contact::orderBy('id', 'desc')->get(); }
public function getIndex() { if (!Input::exists('id')) { $sortf = "id"; $sorttype = "desc"; if (Input::exists('s')) { switch (Input::get('s')) { case '2': $sorttype = "asc"; break; case '3': $sortf = "email"; $sorttype = "asc"; break; } } $data = contact::orderBy($sortf, $sorttype); if (Input::exists('f')) { switch (Input::get('f')) { case '1': $mytime = Carbon::now(); $data = $data->where(DB::raw('day(created_at)'), $mytime->day)->where(DB::raw('month(created_at)'), $mytime->month)->where(DB::raw('year(created_at)'), $mytime->year); break; case '2': $mytime = Carbon::now()->subDay(); $data = $data->where(DB::raw('day(created_at)'), $mytime->day)->where(DB::raw('month(created_at)'), $mytime->month)->where(DB::raw('year(created_at)'), $mytime->year); break; case '3': $mytime = Carbon::now(); $data = $data->where(DB::raw('month(created_at)'), $mytime->month)->where(DB::raw('year(created_at)'), $mytime->year); break; } } if (Input::exists('q')) { $query = trim(Input::get('q')); if ($query != "") { $data = $data->where(function ($q) use($query) { $arr = explode('/', $query); if (count($arr) == 3) { $ngay = (int) $arr[0]; $thang = (int) $arr[1]; $nam = (int) $arr[2]; if ($ngay != 0 && $thang != 0 && $nam != 0) { $q->where(DB::raw('day(created_at)'), $ngay); $q->where(DB::raw('month(created_at)'), $thang); $q->where(DB::raw('year(created_at)'), $nam); return; } } if (count($arr) == 2) { $thang = (int) $arr[0]; $nam = (int) $arr[1]; if ($thang != 0 && $nam != 0) { $q->where(DB::raw('month(created_at)'), $thang); $q->where(DB::raw('year(created_at)'), $nam); return; } } $q->where('email', 'like', '%' . $query . '%'); $q->orWhere('subject', 'like', '%' . $query . '%'); $q->orWhere('content', 'like', '%' . $query . '%'); }); } } $data = $data->paginate(15); } else { $data = contact::where('id', Input::get('id'))->paginate(1); } return view("admin.contact.index", array('data' => $data)); }