public function getIndex() { if ($this->access['is_view'] == 0) { return Redirect::to('')->with('message', SiteHelpers::alert('error', ' Your are not allowed to access the page ')); } // Filter sort and order for query $sort = !is_null(Input::get('sort')) ? Input::get('sort') : ''; $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 $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']); $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; // Render into template $this->layout->nest('content', 'rinvoices.index', $this->data)->with('menus', SiteHelpers::menus()); }
public function getIndex() { if ($this->access['is_view'] == 0) { return Redirect::to('')->with('message', SiteHelpers::alert('error', ' Your are not allowed to access the page ')); } // 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' AND tb_groups.level >= " . Session::get('gid') . ""; $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']); $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()); }
public function getIndex(Request $request) { $sort = !is_null($request->input('sort')) ? $request->input('sort') : ''; $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')) ? '' : ''; $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('esireport'); $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('esireport.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') : '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(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') : 'fecfac'; $order = !is_null($request->input('order')) ? $request->input('order') : 'desc'; // End Filter sort and order for query // Filter Search for query $filter = !is_null($request->input('search')) ? $this->buildSearch() : ''; $this->createCharts($filter); $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('factura'); $this->data['rowData'] = $results['rows']; foreach ($this->data['rowData'] as &$row) { if (!$row->reducida) { $row->reducida = "Detallada"; } else { $row->reducida = "Reducida"; } } // 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('factura.index', $this->data); }
public function getIndex(Request $request) { $sort = !is_null($request->input('sort')) ? $request->input('sort') : 'created'; $order = !is_null($request->input('order')) ? $request->input('order') : 'desc'; // End Filter sort and order for query // Filter Search for query $filter = !is_null($request->input('search')) ? $this->buildSearch() : ''; if (!is_null($request->input('category'))) { $filter .= " AND tb_blogcategories.alias ='" . $request->input('category') . "' "; } $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); $total = $this->model->totalBlog($filter); // 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'], $total, $params['limit']); $pagination->setPath('blog'); $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(); $this->data['blogcategories'] = Blog::summaryCategory(); $this->data['clouds'] = Blog::clouds(); $this->data['recent'] = Blog::recentPosts(); $this->data['pageMetakey'] = CNF_METAKEY; $this->data['pageMetadesc'] = CNF_METADESC; $this->data['pages'] = 'blog.index'; $page = 'layouts.' . CNF_THEME . '.index'; return view($page, $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()); }
function index() { if ($this->access['is_view'] == 0) { $this->session->set_flashdata('error', SiteHelpers::alert('error', 'Your are not allowed to access the page')); redirect('dashboard', 301); } // Filter sort and order for query $sort = !is_null($this->input->get('sort', true)) ? $this->input->get('sort', true) : 'id'; $order = !is_null($this->input->get('order', true)) ? $this->input->get('order', true) : 'asc'; // End Filter sort and order for query // Filter Search for query $filter = !is_null($this->input->get('search', true)) ? $this->buildSearch() : ''; $filter .= " AND tb_groups.level >= " . $this->session->userdata('gid') . ""; // End Filter Search for query $page = max(1, (int) $this->input->get('page', 1)); $params = array('page' => $page, 'limit' => $this->input->get('rows', true) != '' ? filter_var($this->input->get('rows', true), FILTER_VALIDATE_INT) : $this->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']); $this->data['rowData'] = $results['rows']; // Build Pagination $pagination = $this->paginator(array('total_rows' => $results['total'], 'per_page' => $params['limit'])); $this->data['pagination'] = $pagination; // 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; // Render into template $this->data['content'] = $this->load->view('users/index', $this->data, true); $this->load->view('layouts/main', $this->data); }