public function index($indicator_period = 2) { $tickets_count = Ticket::count(); $open_tickets_count = Ticket::whereNull('completed_at')->count(); $closed_tickets_count = Ticket::whereNotNull('completed_at')->count(); // Per Category pagination $categories = Category::paginate(10, ['*'], 'cat_page'); // Total tickets counter per category for google pie chart $categories_all = Category::all(); $categories_share = []; foreach ($categories_all as $cat) { $categories_share[$cat->name] = $cat->tickets()->count(); } // Total tickets counter per agent for google pie chart $agents_all = Agent::agents(); $agents_share = []; foreach ($agents_all as $agent_single) { $agents_share[$agent_single->name] = $agent_single->agentTickets(false)->count() + $agent_single->agentTickets(true)->count(); } // Per Agent $agents = Agent::agents(10); // Per User $users = Agent::users(10); // Per Category performance data $ticketController = new TicketsController(new Ticket(), new Agent()); $monthly_performance = $ticketController->monthlyPerfomance($indicator_period); return view('ticketit::admin.index', compact('open_tickets_count', 'closed_tickets_count', 'tickets_count', 'categories', 'agents', 'users', 'monthly_performance', 'categories_share', 'agents_share')); }
/** * Check if user is the owner for a ticket * @param integer $id ticket id * @return boolean */ public static function isTicketOwner($id) { if (Auth::check()) { if (Auth::user()->id == Ticket::find($id)->user->id) { return true; } } }
/** * Store a newly created resource in storage. * * @param Requests\CommentFormRequest|Request $request * @return Response */ public function store(Request $request) { $comment = new Models\Comment(); $comment->content = $request->get('content'); $comment->ticket_id = $request->get('ticket_id'); $comment->user_id = \Auth::user()->id; $comment->save(); $ticket = Models\Ticket::find($comment->ticket_id); $ticket->updated_at = $comment->created_at; $ticket->save(); return back()->with('status', trans('ticketit::lang.comment-has-been-added-ok')); }
/** * Store a newly created resource in storage. * * @param Requests\CommentFormRequest|Request $request * @return Response */ public function store(Request $request) { $comment = new Models\Comment(); $comment->content = $request->get('content'); $comment->ticket_id = $request->get('ticket_id'); $comment->user_id = \Auth::user()->id; $comment->save(); $ticket = Models\Ticket::find($comment->ticket_id); $ticket->updated_at = $comment->created_at; $ticket->save(); return back()->with('status', 'Comment has been added successfully'); }
/** * Bootstrap the application services. * * @return void */ public function boot() { // Adding HTML5 color picker to form elements Form::macro('custom', function ($type, $name, $value = "#000000", $options = []) { $field = $this->input($type, $name, $value, $options); return $field; }); // Passing to views the master view value from the setting file view()->composer('ticketit::*', function ($view) { $master = config('ticketit.master_template'); $view->with(compact('master')); }); // Send notification when new comment is added Comment::creating(function ($comment) { if (config('ticketit.comment_notification') == 'yes') { $notification = new NotificationsController(); $notification->newComment($comment); } }); // Send notification when ticket status is modified Ticket::updating(function ($modified_ticket) { if (config('ticketit.status_notification') == 'yes') { $original_ticket = Ticket::find($modified_ticket->id); if ($original_ticket->status->id != $modified_ticket->status->id) { $notification = new NotificationsController(); $notification->ticketStatusUpdated($modified_ticket, $original_ticket); } } if (config('ticketit.assigned_notification') == 'yes') { $original_ticket = Ticket::find($modified_ticket->id); if ($original_ticket->agent->id != $modified_ticket->agent->id) { $notification = new NotificationsController(); $notification->ticketAgentUpdated($modified_ticket, $original_ticket); } } return true; }); // Send notification when ticket status is modified Ticket::created(function ($ticket) { if (config('ticketit.assigned_notification') == 'yes') { $notification = new NotificationsController(); $notification->newTicketNotifyAgent($ticket); } return true; }); $this->loadViewsFrom(__DIR__ . '/views', 'ticketit'); $this->publishes([__DIR__ . '/views' => base_path('resources/views/vendor/ticketit')], 'views'); $this->publishes([__DIR__ . '/config/ticketit.php' => config_path('ticketit.php')], 'config'); }
public function agentSelectList($category_id, $ticket_id) { $agents = ['auto' => 'Auto Select'] + Models\Agent::agentsLists($category_id); $selected_Agent = Models\Ticket::find($ticket_id)->agent->id; $select = '<select class="form-control" id="agent_id" name="agent_id">'; foreach ($agents as $id => $name) { $selected = $id == $selected_Agent ? "selected" : ""; $select .= '<option value="' . $id . '" ' . $selected . '>' . $name . '</option>'; } $select .= '</select>'; return $select; }
/** * Calculate the average date length it took to solve tickets within date period * @param $from * @param $to * @return int */ public function intervalPerformance($from, $to, $cat_id = false) { if ($cat_id) { $tickets = Ticket::where('category_id', $cat_id)->whereBetween('completed_at', array($from, $to))->get(); } else { $tickets = Ticket::whereBetween('completed_at', array($from, $to))->get(); } if (empty($tickets->first())) { return false; } $performance_count = 0; $counter = 0; foreach ($tickets as $ticket) { $performance_count += $this->ticketPerformance($ticket); $counter++; } $performance_average = $performance_count / $counter; return $performance_average; }
/** * Bootstrap the application services. * * @return void */ public function boot() { $installer = new InstallController(); // if a migration is missing scape to the installation if (empty($installer->inactiveMigrations()) && DB::table('ticketit_settings')->count() != 0) { // Send the Agent User model to the view under $u view()->composer('*', function ($view) { if (auth()->check()) { $u = Agent::find(auth()->user()->id); $view->with('u', $u); } $setting = new Setting(); $view->with('setting', $setting); }); // Adding HTML5 color picker to form elements CollectiveForm::macro('custom', function ($type, $name, $value = "#000000", $options = []) { $field = $this->input($type, $name, $value, $options); return $field; }); // Passing to views the master view value from the setting file view()->composer('ticketit::*', function ($view) { $tools = new ToolsController(); $master = Setting::grab('master_template'); $email = Setting::grab('email.template'); $view->with(compact('master', 'email', 'tools')); }); // Send notification when new comment is added Comment::creating(function ($comment) { if (Setting::grab('comment_notification')) { $notification = new NotificationsController(); $notification->newComment($comment); } }); // Send notification when ticket status is modified Ticket::updating(function ($modified_ticket) { if (Setting::grab('status_notification')) { $original_ticket = Ticket::find($modified_ticket->id); if ($original_ticket->status_id != $modified_ticket->status_id || $original_ticket->completed_at != $modified_ticket->completed_at) { $notification = new NotificationsController(); $notification->ticketStatusUpdated($modified_ticket, $original_ticket); } } if (Setting::grab('assigned_notification')) { $original_ticket = Ticket::find($modified_ticket->id); if ($original_ticket->agent->id != $modified_ticket->agent->id) { $notification = new NotificationsController(); $notification->ticketAgentUpdated($modified_ticket, $original_ticket); } } return true; }); // Send notification when ticket status is modified Ticket::created(function ($ticket) { if (Setting::grab('assigned_notification')) { $notification = new NotificationsController(); $notification->newTicketNotifyAgent($ticket); } return true; }); $this->loadTranslationsFrom(__DIR__ . '/Translations', 'ticketit'); $this->loadViewsFrom(__DIR__ . '/Views', 'ticketit'); $this->publishes([__DIR__ . '/Views' => base_path('resources/views/vendor/ticketit')], 'views'); $this->publishes([__DIR__ . '/Translations' => base_path('resources/lang/vendor/ticketit')], 'lang'); $this->publishes([__DIR__ . '/Public' => public_path('vendor/ticketit')], 'public'); $this->publishes([__DIR__ . '/Migrations' => base_path('database/migrations')], 'db'); // Check public assets are present, publish them if not // $installer->publicAssets(); $main_route = Setting::grab('main_route'); $admin_route = Setting::grab('admin_route'); include __DIR__ . '/routes.php'; } elseif (Request::path() == 'tickets-install') { $this->loadTranslationsFrom(__DIR__ . '/Translations', 'ticketit'); $this->loadViewsFrom(__DIR__ . '/Views', 'ticketit'); $this->publishes([__DIR__ . '/Migrations' => base_path('database/migrations')], 'db'); Route::get('/tickets-install', ['middleware' => 'auth', 'uses' => 'Kordy\\Ticketit\\Controllers\\InstallController@index']); Route::post('/tickets-install', ['middleware' => 'auth', 'uses' => 'Kordy\\Ticketit\\Controllers\\InstallController@setup']); } }
public function allTickets($complete = false) { if ($complete) { return Ticket::whereNotNull('completed_at'); } else { return Ticket::whereNull('completed_at'); } }