public function getIndex() { if ($this->access['is_view'] == 0) { return Redirect::to('')->with('message', SiteHelpers::alert('error', Lang::get('core.note_restric'))); } // Filter sort and order for query $sort = !is_null(Input::get('sort')) ? Input::get('sort') : 'slideshow_id'; $order = !is_null(Input::get('order')) ? Input::get('order') : 'asc'; // End Filter sort and order for query // Filter Search for query $filter = !is_null(Input::get('search')) ? $this->buildSearch() : ''; $filter .= " AND lang = '{$this->lang}'"; // End Filter Search for query // Take param master detail if any $master = $this->buildMasterDetail(); // append to current $filter $filter .= $master['masterFilter']; $page = Input::get('page', 1); $params = array('page' => $page, 'limit' => !is_null(Input::get('rows')) ? filter_var(Input::get('rows'), FILTER_VALIDATE_INT) : static::$per_page, 'sort' => $sort, 'order' => $order, 'params' => $filter, 'global' => isset($this->access['is_global']) ? $this->access['is_global'] : 0); // Get Query $results = $this->model->getRows($params); // Build pagination setting $page = $page >= 1 && filter_var($page, FILTER_VALIDATE_INT) !== false ? $page : 1; $pagination = Paginator::make($results['rows'], $results['total'], $params['limit']); $test = $this->model->columnTable(); $arr_search = SiteHelpers::arraySearch(Input::get('search')); foreach ($arr_search as $key => $val) { if ($key != "sort" && $key != "order" && $key != "rows") { $test[$key]['value'] = $val; } } $this->data['test'] = $test; $this->data['rowData'] = $results['rows']; // Build Pagination $this->data['pagination'] = $pagination; // Build pager number and append current param GET $this->data['pager'] = $this->injectPaginate(); // Row grid Number $this->data['i'] = $page * $params['limit'] - $params['limit']; // Grid Configuration $this->data['tableGrid'] = $this->info['config']['grid']; $this->data['tableForm'] = $this->info['config']['forms']; $this->data['colspan'] = SiteHelpers::viewColSpan($this->info['config']['grid']); // Group users permission $this->data['access'] = $this->access; // Detail from master if any $this->data['masterdetail'] = $this->masterDetailParam(); $this->data['details'] = $master['masterView']; // Master detail link if any $this->data['subgrid'] = isset($this->info['config']['subgrid']) ? $this->info['config']['subgrid'] : array(); // Render into template $this->layout->nest('content', 'Slideshow.index', $this->data)->with('menus', SiteHelpers::menus()); }
public function getIndex(Request $request) { if ($this->access['is_view'] == 0) { return Redirect::to('dashboard')->with('messagetext', \Lang::get('core.note_restric'))->with('msgstatus', 'error'); } $sort = !is_null($request->input('sort')) ? $request->input('sort') : 'news_id'; $order = !is_null($request->input('order')) ? $request->input('order') : 'asc'; // End Filter sort and order for query // Filter Search for query $filter = !is_null($request->input('search')) ? $this->buildSearch() : ''; $filter .= " AND lang = '{$this->lang}'"; $page = $request->input('page', 1); $params = array('page' => $page, 'limit' => !is_null($request->input('rows')) ? filter_var($request->input('rows'), FILTER_VALIDATE_INT) : static::$per_page, 'sort' => $sort, 'order' => $order, 'params' => $filter, 'global' => isset($this->access['is_global']) ? $this->access['is_global'] : 0); // Get Query $results = $this->model->getRows($params); // Build pagination setting $page = $page >= 1 && filter_var($page, FILTER_VALIDATE_INT) !== false ? $page : 1; $pagination = new Paginator($results['rows'], $results['total'], $params['limit']); $pagination->setPath('news'); $test = $this->model->columnTable(); $arr_search = \SiteHelpers::arraySearch(Input::get('search')); foreach ($arr_search as $key => $val) { if ($key != "sort" && $key != "order" && $key != "rows") { $test[$key]['value'] = $val; } } $this->data['test'] = $test; $this->data['rowData'] = $results['rows']; // Build Pagination $this->data['pagination'] = $pagination; // Build pager number and append current param GET $this->data['pager'] = $this->injectPaginate(); // Row grid Number $this->data['i'] = $page * $params['limit'] - $params['limit']; // Grid Configuration $this->data['tableGrid'] = $this->info['config']['grid']; $this->data['tableForm'] = $this->info['config']['forms']; $this->data['colspan'] = \SiteHelpers::viewColSpan($this->info['config']['grid']); // Group users permission $this->data['access'] = $this->access; // Detail from master if any // Master detail link if any $this->data['subgrid'] = isset($this->info['config']['subgrid']) ? $this->info['config']['subgrid'] : array(); // Render into template return view('news.index', $this->data); }
public function getIndex() { if ($this->access['is_view'] == 0) { return Redirect::to('')->with('message', SiteHelpers::alert('error', Lang::get('core.note_restric'))); } // Filter sort and order for query $sort = !is_null(Input::get('sort')) ? Input::get('sort') : 'id'; $order = !is_null(Input::get('order')) ? Input::get('order') : 'asc'; // End Filter sort and order for query // Filter Search for query $filter = !is_null(Input::get('search')) ? $this->buildSearch() : ''; // End Filter Search for query $filter .= " AND id !='1' "; $page = Input::get('page', 1); $params = array('page' => $page, 'limit' => !is_null(Input::get('rows')) ? filter_var(Input::get('rows'), FILTER_VALIDATE_INT) : static::$per_page, 'sort' => $sort, 'order' => $order, 'params' => $filter); // Get Query $results = $this->model->getRows($params); $page = $page >= 1 && filter_var($page, FILTER_VALIDATE_INT) !== false ? $page : 1; $pagination = Paginator::make($results['rows'], $results['total'], $params['limit']); $test = $this->model->columnTable(); $arr_search = SiteHelpers::arraySearch(Input::get('search')); foreach ($arr_search as $key => $val) { if ($key != "sort" && $key != "order" && $key != "rows") { $test[$key]['value'] = $val; } } $this->data['test'] = $test; $this->data['rowData'] = $results['rows']; $this->data['pagination'] = $pagination; $this->data['pager'] = $this->injectPaginate(); $this->data['i'] = $page * $params['limit'] - $params['limit']; $this->data['tableGrid'] = $this->info['config']['grid']; $this->data['tableForm'] = $this->info['config']['forms']; $this->data['colspan'] = SiteHelpers::viewColSpan($this->info['config']['grid']); $this->data['access'] = $this->access; $this->layout->nest('content', 'users.index', $this->data)->with('menus', SiteHelpers::menus()); }