コード例 #1
0
 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $filter = array_fill_keys($this->proposal->getAllColumnsNames(), "");
     $stop_fields = array('filter', 'user_id');
     $input = Input::all();
     if (isset($input['filter']) && $input['filter'] == 'apply') {
         $filter = array_merge($filter, $input);
         Session::put("PROPOSALS_FILTER", $filter);
     }
     if (isset($input['filter']) && $input['filter'] == 'reset') {
         Session::forget('PROPOSALS_FILTER');
     }
     if (isset($input['sort_value'])) {
         $sort = $input['sort_value'];
         $sort_dir = $input['sort_dir'];
         Session::put("PROPOSALS_SORT", array('value' => $sort, 'dir' => $sort_dir));
     }
     $sort = Session::get('PROPOSALS_SORT');
     if (isset($input['filter']) && $input['filter'] == 'reset') {
         Session::forget('PROPOSALS_FILTER');
     }
     if (Session::has('PROPOSALS_FILTER')) {
         $filter = Session::get('PROPOSALS_FILTER');
         $proposals = $this->proposal->where('id', '>', '0');
         foreach ($filter as $k => $v) {
             if (!in_array($k, $stop_fields) && $v != '') {
                 $proposals = $proposals->where($k, 'like', '%' . $v . '%');
             }
         }
         if ($filter['user_id']) {
             $users = User::where('username', 'like', '%' . $filter['user_id'] . '%')->get();
             $proposals = $proposals->whereIn('user_id', $users->pluck('id')->all());
         }
         if (Session::has('PROPOSALS_SORT') && $sort['value'] != '') {
             $proposals = $proposals->orderBy($sort['value'], $sort['dir'] == '1' ? 'desc' : '');
         }
         $proposals = $proposals->paginate(Settings::getValue('TABLE_ELEMENTS'));
     } else {
         if (Session::has('PROPOSALS_SORT') && $sort['value'] != '') {
             $proposals = $this->proposal->orderBy($sort['value'], $sort['dir'] == '1' ? 'desc' : 'asc');
         } else {
             $proposals = $this->proposal;
         }
         $proposals = $proposals->paginate(Settings::getValue('TABLE_ELEMENTS'));
     }
     $sort_options = Proposal::getSortOptions();
     return View::make('backend.proposals.index', compact("proposals", 'filter', 'sort_options', 'sort'));
 }