public function pagesettingstore()
{
session_start();
$pagesetting = new pagesettings();
$pagesetting->delete($_SESSION['tablename']);
$count = $_POST['checkbox'];
$N = count($count);
for ($i = 0; $i < $N; $i++) {
$pagesetting->addnew($count[$i], $_SESSION['tablename'], '1');
}
$pagesetting->addnew($_POST['rows'], $_SESSION['tablename'], '0');
if ($_SESSION['tablename'] == "contacts") {
return redirect("contact");
} elseif ($_SESSION['tablename'] == "accounts") {
return redirect("account");
} elseif ($_SESSION['tablename'] == "sales") {
return redirect("sale");
}
return redirect($_SESSION['tablename']);
}
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'));
}
