public function pagesetting() { session_start(); $_SESSION['loc'] = "admin"; $pagesetting = new pagesettings(); $_SESSION['tablename'] = $_GET['tablename']; if ($_SESSION['tablename'] == "call_log") { $name = "Call Log"; $locc = "call_log"; } elseif ($_SESSION['tablename'] == "contacts") { $name = "Contacts"; $locc = "contact"; } elseif ($_SESSION['tablename'] == "sales") { $name = "Sales"; $locc = "sales"; } elseif ($_SESSION['tablename'] == "ticket") { $name = "Ticket"; $locc = "ticket"; } else { $name = "Accounts"; $locc = "account"; } $columns_details = $pagesetting->viewcolumns($_SESSION['tablename']); $page_details = $pagesetting->fname($_SESSION['tablename'], '0'); return View::make('pagesetting', compact('columns_details', 'page_details', 'locc', 'name')); }
public function search() { session_start(); unset($_SESSION['contact_report_to']); //create a session for location $_SESSION['loc'] = "ticket"; //creating objects $pagesettings = new functions\pagesettings(); //get selected columns $selected_columns = $pagesettings->fname('ticket', '1'); //get select columns names foreach ($selected_columns as $result) { $column_comment = $pagesettings->viewcolumncomment($result->column_name, 'ticket'); foreach ($column_comment as $result_2) { $table_headings[] = $result_2->column_comment; } } $_SESSION['sort'] = "DESC"; //get data for call log $result = $this->view_tickets_all(1000, 0); //Get current page form url e.g. &page=6 $currentPage = LengthAwarePaginator::resolveCurrentPage(); //pagination starting form 0. e.g. &page=1 mean page=0 if ($currentPage != NULL) { $currentPage = $currentPage - 1; } //Create a new Laravel collection from the array data $collection = new Collection($result); //Define how many items we want to be visible in each page $perPage = 1000000; //Slice the collection to get the items to display in current page $currentPageSearchResults = $collection->slice($currentPage * $perPage, $perPage)->all(); //Create our paginator and pass it to the view $result = new LengthAwarePaginator($currentPageSearchResults, count($collection), $perPage); //return this data to the view return View::make('ticket.ticket', compact('table_headings', 'selected_columns', 'result')); }