public function showTicketsAjaxHandler()
{
$userId = Session::get('ig_supplier')['id'];
$objUserTicket = Ticket::getInstance();
$where = array('rawQuery' => 'user_id=?', 'bindParams' => [$userId]);
$selectedColumns = array('users.*', 'tickets.*');
$ticketDetailsOfUser = $objUserTicket->getUserInfoByUserId($where, $selectedColumns);
// dd($ticketDetailsOfUser);
$tickets = new Collection();
$ticketDetailsOfUser = json_decode(json_encode($ticketDetailsOfUser), true);
foreach ($ticketDetailsOfUser as $tdu) {
$id = $tdu['ticket_id'];
if ($tdu['ticket_status'] == 0) {
$status = 'opened';
} else {
$status = 'closed';
}
$tickets->push(['ticket_id' => $tdu['ticket_id'], 'name' => $tdu['name'] . $tdu['lastname'], 'email' => $tdu['email'], 'subject' => $tdu['subject'], 'descriptions' => $tdu['descriptions'], 'status' => $status, 'created_at' => $tdu['created_at']]);
}
return Datatables::of($tickets)->make(true);
}
