public function getData() { //return 'kfjhje'; return Datatable::collection(Category::All())->searchColumns('name')->orderColumns('name', 'description')->addColumn('name', function ($model) { return $model->name; })->addColumn('Created', function ($model) { $t = $model->created_at; return TicketController::usertimezone($t); })->addColumn('Actions', function ($model) { //return '<a href=category/delete/' . $model->id . ' class="btn btn-danger btn-flat">Delete</a> <a href=category/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=article-list class="btn btn-warning btn-flat">View</a>'; return '<span data-toggle="modal" data-target="#deletecategory' . $model->slug . '"><a href="#" ><button class="btn btn-danger btn-xs"></a>' . \Lang::get("lang.delete") . '</button></span> <a href=category/' . $model->id . '/edit class="btn btn-warning btn-xs">' . \Lang::get("lang.edit") . '</a> <a href=article-list class="btn btn-primary btn-xs">' . \Lang::get("lang.view") . '</a> <div class="modal fade" id="deletecategory' . $model->slug . '"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title">Are You Sure ?</h4> </div> <div class="modal-body"> ' . $model->name . ' </div> <div class="modal-footer"> <button type="button" class="btn btn-default pull-left" data-dismiss="modal" id="dismis2">Close</button> <a href="category/delete/' . $model->id . '"><button class="btn btn-danger">delete</button></a> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div>'; })->make(); }
/** * fetching pages list in chumper datatables * @return type */ public function getData() { /* fetching chumper datatables */ return Datatable::collection(Page::All())->searchColumns('name')->orderColumns('name', 'description', 'created')->addColumn('name', function ($model) { return $model->name; })->addColumn('Created', function ($model) { $t = $model->created_at; return TicketController::usertimezone($t); })->addColumn('Actions', function ($model) { return '<span data-toggle="modal" data-target="#deletepage' . $model->id . '"><a href="#" ><button class="btn btn-danger btn-xs"></a> ' . \Lang::get('lang.delete') . '</button></span> <a href=page/' . $model->slug . '/edit class="btn btn-warning btn-xs">' . \Lang::get('lang.edit') . '</a> <a href=pages/' . $model->slug . ' class="btn btn-primary btn-xs">' . \Lang::get('lang.view') . '</a> <div class="modal fade" id="deletepage' . $model->id . '"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title">Are You Sure ?</h4> </div> <div class="modal-body"> ' . $model->name . ' </div> <div class="modal-footer"> <button type="button" class="btn btn-default pull-left" data-dismiss="modal" id="dismis2">Close</button> <a href="page/delete/' . $model->id . '"><button class="btn btn-danger">delete</button></a> </div> </div> </div> </div>'; })->make(); }
public function get_inbox() { return \Datatable::collection(Tickets::where('status', '=', 1)->orderBy('id', 'DESC')->get())->searchColumns('subject')->orderColumns('ticket_number')->addColumn('checkbox', function ($ticket) { return "<input type='checkbox' class='icheckbox_flat-blue' name='select_all' value=" . $ticket->id . "/>"; })->addColumn('name', function ($ticket) { $title = Ticket_Thread::where('ticket_id', '=', $ticket->id)->first(); $string = strip_tags($title->title); if ($title) { if ($title == null) { } else { $collaborators = Ticket_Collaborator::where('ticket_id', '=', $ticket->id)->get(); $collab = count($collaborators); // check atatchments $attachments = Ticket_attachments::where('thread_id', '=', $title->id)->first(); $attach = count($attachments); if (strlen($string) > 40) { $stringCut = substr($string, 0, 40); $string = substr($stringCut, 0, strrpos($stringCut, ' ')) . ' ...'; } $TicketData = Ticket_Thread::where('ticket_id', '=', $ticket->id)->max('id'); $TicketDatarow = Ticket_Thread::where('id', '=', $TicketData)->first(); $LastResponse = User::where('id', '=', $TicketDatarow->user_id)->first(); if ($LastResponse->role == "user") { $rep = "#F39C12"; $username = $LastResponse->user_name; } else { $rep = "#000"; $username = $LastResponse->first_name . " " . $LastResponse->last_name; if ($LastResponse->first_name == null || $LastResponse->last_name == null) { $username = $LastResponse->user_name; } } $titles = Ticket_Thread::where('ticket_id', '=', $ticket->id)->get(); $count = count($titles); foreach ($titles as $title) { $title = $title; } $assigned_to = User::where('id', '=', $ticket->assigned_to)->first(); if ($assigned_to == null) { $assigned = "Unassigned"; } else { $assigned = $assigned_to->first_name . " " . $assigned_to->last_name; } if ($collab > 0) { $collabs = " <i class='fa fa-users'></i>"; } if ($attach > 0) { $attachs = " <i class='fa fa-paperclip'></i>"; if ($collab > 0) { $collabs = $collabs . $attachs; } else { $collabs = $attachs; } } return "<a href=" . route('ticket.thread', [$ticket->id]) . " title=" . $title->title . ">" . $string . "</a> (" . $count . ") <i class='fa fa-comment'></i>\n " . $collab; } } })->addColumn('Ticket ID', function ($ticket) { $ticket_number = "<a href='" . route('ticket.thread', [$ticket->id]) . "' title=''># " . $ticket->ticket_number . "</a>"; return $ticket_number; })->addColumn('Priority', function ($ticket) { $priority = Ticket_Priority::where('priority_id', '=', $ticket->priority_id)->first(); return "<td class='mailbox-priority'><spam style='color:green;'>" . $priority->priority_desc . "</spam></td>"; // return TicketController::usertimezone($st); })->addColumn('From', function ($ticket) { $from = User::where('id', '=', $ticket->user_id)->first(); if ($from->role == "user") { return $from->user_name; } else { return $from->first_name . " " . $from->last_name; } })->addColumn('Last Replier', function ($ticket) { $TicketData = Ticket_Thread::where('ticket_id', '=', $ticket->id)->max('id'); $TicketDatarow = Ticket_Thread::where('id', '=', $TicketData)->first(); $LastResponse = User::where('id', '=', $TicketDatarow->user_id)->first(); if ($LastResponse->role == "user") { $rep = "#F39C12"; $username = $LastResponse->user_name; } else { $rep = "#000"; $username = $LastResponse->first_name . " " . $LastResponse->last_name; if ($LastResponse->first_name == null || $LastResponse->last_name == null) { $username = $LastResponse->user_name; } } return $username; })->addColumn('Assigned To', function ($ticket) { $assigned_to = User::where('id', '=', $ticket->assigned_to)->first(); if ($assigned_to == null) { $assigned = "Unassigned"; } else { $assigned = $assigned_to->first_name . " " . $assigned_to->last_name; } return $assigned; })->addColumn('Last Activity', function ($ticket) { $assigned_to = User::where('id', '=', $ticket->assigned_to)->first(); if ($assigned_to == null) { $assigned = "Unassigned"; } else { $assigned = $assigned_to->first_name . " " . $assigned_to->last_name; } return $assigned; })->addColumn('Last Activity', function ($ticket) { $titles = Ticket_Thread::where('ticket_id', '=', $ticket->id)->get(); $count = count($titles); foreach ($titles as $title) { $title = $title; } return TicketController::usertimezone($title->created_at); })->make(); }
/** * getdata * @return type */ public function getData() { return \Datatable::collection(Comment::All())->searchColumns('name', 'email', 'comment', 'created')->orderColumns('name')->addColumn('name', function ($model) { return $model->name; })->addColumn('email', function ($model) { return $model->email; })->addColumn('website', function ($model) { return $model->website; })->addColumn('comment', function ($model) { return $model->comment; })->addColumn('status', function ($model) { $status = $model->status; if ($status == 1) { return '<p style="color:blue"">' . \Lang::get('lang.published'); } else { return '<p style="color:red"">' . \Lang::get('lang.not_published'); } })->addColumn('Created', function ($model) { return TicketController::usertimezone(date($model->created_at)); })->addColumn('Actions', function ($model) { return '<a href=comment/delete/' . $model->id . ' class="btn btn-danger btn-xs">' . \Lang::get('lang.delete') . '</a> <a href=published/' . $model->id . ' class="btn btn-warning btn-xs">' . \Lang::get('lang.publish') . '</a>'; })->make(); }
/** * This function is used to display the list of users * @return datatable */ public function user_list() { return \Datatable::collection(User::where('role', '!=', 'admin')->where('role', '!=', 'agent')->get())->searchColumns('user_name')->orderColumns('user_name', 'email')->addColumn('user_name', function ($model) { return $model->user_name; })->addColumn('email', function ($model) { $email = $model->email; return $email; })->addColumn('phone', function ($model) { $phone = ""; if ($model->phone_number) { $phone = $model->ext . ' ' . $model->phone_number; } $mobile = ""; if ($model->mobile) { $mobile = $model->mobile; } $phone = $phone . " " . $mobile; return $phone; })->addColumn('status', function ($model) { $status = $model->active; if ($status == 1) { $stat = '<button class="btn btn-success btn-xs">Active</button>'; } else { $stat = '<button class="btn btn-danger btn-xs">Inactive</button>'; } return $stat; })->addColumn('lastlogin', function ($model) { $t = $model->updated_at; return TicketController::usertimezone($t); })->addColumn('Actions', function ($model) { //return '<a href=article/delete/ ' . $model->id . ' class="btn btn-danger btn-flat" onclick="myFunction()">Delete</a> <a href=article/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=show/' . $model->id . ' class="btn btn-warning btn-flat">View</a>'; //return '<form action="article/delete/ ' . $model->id . '" method="post" onclick="alert()"><button type="sumbit" value="Delete"></button></form><a href=article/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=show/' . $model->id . ' class="btn btn-warning btn-flat">View</a>'; return '<span data-toggle="modal" data-target="#deletearticle' . $model->id . '"><a href="#" ><button class="btn btn-danger btn-xs"></a> ' . \Lang::get('lang.delete') . ' </button></span> <a href="' . route('user.edit', $model->id) . '" class="btn btn-warning btn-xs">' . \Lang::get('lang.edit') . '</a> <a href="' . route('user.show', $model->id) . '" class="btn btn-primary btn-xs">' . \Lang::get('lang.view') . '</a> <div class="modal fade" id="deletearticle' . $model->id . '"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title">Are You Sure ?</h4> </div> <div class="modal-body"> ' . $model->user_name . ' </div> <div class="modal-footer"> <button type="button" class="btn btn-default pull-left" data-dismiss="modal" id="dismis2">Close</button> <a href="' . route('user.delete', $model->id) . '"><button class="btn btn-danger">delete</button></a> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div>'; })->make(); }
/** * This function is used to display the list of users using chumper datatables * @return datatable */ public function user_list() { // displaying list of users with chumper datatables return \Datatable::collection(User::where('role', '!=', 'admin')->where('role', '!=', 'agent')->get())->searchColumns('user_name')->orderColumns('user_name', 'email')->addColumn('user_name', function ($model) { if (strlen($model->user_name) > 20) { $username = substr($model->user_name, 0, 30); $username = substr($username, 0, strrpos($username, ' ')) . ' ...'; } else { $username = $model->user_name; } return $username; })->addColumn('email', function ($model) { $email = $model->email; return $email; })->addColumn('phone', function ($model) { $phone = ""; if ($model->phone_number) { $phone = $model->ext . ' ' . $model->phone_number; } $mobile = ""; if ($model->mobile) { $mobile = $model->mobile; } $phone = $phone . " " . $mobile; return $phone; })->addColumn('status', function ($model) { $status = $model->active; if ($status == 1) { $stat = '<button class="btn btn-success btn-xs">Active</button>'; } else { $stat = '<button class="btn btn-danger btn-xs">Inactive</button>'; } return $stat; })->addColumn('ban', function ($model) { $status = $model->ban; if ($status == 1) { $stat = '<button class="btn btn-danger btn-xs">Banned</button>'; } else { $stat = '<button class="btn btn-success btn-xs">Active</button>'; } return $stat; })->addColumn('lastlogin', function ($model) { $t = $model->updated_at; return TicketController::usertimezone($t); })->addColumn('Actions', function ($model) { return '<a href="' . route('user.edit', $model->id) . '" class="btn btn-warning btn-xs">' . \Lang::get('lang.edit') . '</a> <a href="' . route('user.show', $model->id) . '" class="btn btn-primary btn-xs">' . \Lang::get('lang.view') . '</a>'; })->make(); }