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());
}
