public function all()
{
$tickets = Tickets::orderBy('priority', 'desc')->where('customer_id', Auth::user()->id)->get();
foreach ($tickets as $ticket) {
$ticket->customer = User::where('id', $ticket->customer_id)->first();
$ticket->company = Company::where('id', $ticket->company_id)->first();
$ticket->department = Department::where('id', $ticket->department_id)->first();
if ($ticket->operator_id > 0) {
$ticket->operator = User::where('id', $ticket->operator_id)->first();
}
}
$this->data['tickets'] = $tickets;
return View::make('tickets.customers_all', $this->data);
}
public function ticketsRefresh()
{
if (Input::get('company_id', 0) > 0 && Input::get('department_id', 0) > 0) {
$tickets = Tickets::orderBy('priority', 'desc')->where('company_id', Input::get('company_id'))->where('department_id', Input::get('department_id'))->get();
} else {
$tickets = Tickets::orderBy('priority', 'desc')->get();
}
$tickets_arr = [];
foreach ($tickets as $ticket) {
$ticket->customer = User::where('id', $ticket->customer_id)->first();
$ticket->company = Company::where('id', $ticket->company_id)->first();
$ticket->department = Department::where('id', $ticket->department_id)->first();
if ($ticket->operator_id > 0) {
$ticket->operator = User::where('id', $ticket->operator_id)->first();
}
$single_ticket = [];
$single_ticket[] = $ticket->id;
$single_ticket[] = isset($ticket->company) ? $ticket->company->name : trans('msgs.none');
$single_ticket[] = isset($ticket->department) ? $ticket->department->name : trans('msgs.none');
$single_ticket[] = isset($ticket->customer) ? $ticket->customer->name : trans('msgs.none');
$single_ticket[] = isset($ticket->customer) ? $ticket->customer->email : trans('msgs.none');
$single_ticket[] = $ticket->subject;
$single_ticket[] = isset($ticket->operator) ? $ticket->operator->name : trans('msgs.none');
if ($ticket->priority == Tickets::PRIORITY_LOW) {
$single_ticket[] = '<td ><label class="label label-primary" > ' . trans("msgs.low") . ' </label ></td >';
}
if ($ticket->priority == Tickets::PRIORITY_MEDIUM) {
$single_ticket[] = '<td><label class="label label-primary">' . trans("msgs.medium") . '</label></td>';
}
if ($ticket->priority == Tickets::PRIORITY_HIGH) {
$single_ticket[] = '<td><label class="label label-warning">' . trans("msgs.high") . '</label></td>';
}
if ($ticket->priority == Tickets::PRIORITY_URGENT) {
$single_ticket[] = '<td><label class="label label-danger">' . trans("msgs.urgent") . '</label></td>';
}
if ($ticket->status == Tickets::TICKET_NEW) {
$single_ticket[] = '<td><label class="label label-warning">' . trans("msgs.new") . '</label></td>';
}
if ($ticket->status == Tickets::TICKET_PENDING) {
$single_ticket[] = '<td><label class="label label-primary">' . trans("msgs.pending") . '</label></td>';
}
if ($ticket->status == Tickets::TICKET_RESOLVED) {
$single_ticket[] = '<td><label class="label label-success">' . trans("msgs.resolved") . '</label></td>';
}
if (!isset($ticket->operator)) {
$single_ticket[] = '<td><a href="/tickets/read/' . $ticket->thread_id . '" class="btn btn-success btn-sm"> <i class="icon-checkmark4"></i> ' . trans("msgs.accept") . ' </a></td>';
}
if (isset($ticket->operator) && $ticket->operator->id == Auth::user()->id) {
$single_ticket[] = '<td><a href="/tickets/read/' . $ticket->thread_id . '" class="btn btn-success btn-sm"> <i class="icon-checkmark4"></i> ' . trans("msgs.reply") . ' </a></td>';
}
if (isset($ticket->operator) && $ticket->operator->id != Auth::user()->id) {
$single_ticket[] = '<td><a disabled class="btn btn-success btn-sm"> <i class="icon-lock3"></i> ' . trans("msgs.accept") . ' </a></td>';
}
$single_ticket[] = '<td><a href="/tickets/transfer/' . $ticket->id . '" class="btn btn-warning btn-sm"> <i class="icon-share3"></i> ' . trans("msgs.transfer") . ' </a></td>';
$single_ticket[] = '<td><a href="/tickets/delete/' . $ticket->thread_id . '" class="btn btn-danger btn-sm"> <i class="icon-remove3"></i> ' . trans("msgs.delete") . ' </a></td>';
$tickets_arr[] = $single_ticket;
}
return json_encode(['aaData' => $tickets_arr]);
}
