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