/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$ticket = Models\Ticket::find($id);
$status_lists = Models\Status::lists('name', 'id');
$priority_lists = Models\Priority::lists('name', 'id');
$category_lists = Models\Category::lists('name', 'id');
$agent_lists = ['auto' => 'Auto Select'] + Models\Agent::agentsLists($ticket->category_id);
$comments = $ticket->comments()->paginate(config('ticketit.paginate_items'));
return view('ticketit::tickets.show', compact('ticket', 'status_lists', 'priority_lists', 'category_lists', 'agent_lists', 'comments'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$ticket = $this->tickets->find($id);
$status_lists = Models\Status::lists('name', 'id');
$priority_lists = Models\Priority::lists('name', 'id');
$category_lists = Models\Category::lists('name', 'id');
$close_perm = $this->permToClose($id);
$reopen_perm = $this->permToReopen($id);
$cat_agents = Models\Category::find($ticket->category_id)->agents()->agentsLists();
if (is_array($cat_agents)) {
$agent_lists = ['auto' => 'Auto Select'] + $cat_agents;
} else {
$agent_lists = ['auto' => 'Auto Select'];
}
$comments = $ticket->comments()->paginate(Setting::grab('paginate_items'));
return view('ticketit::tickets.show', compact('ticket', 'status_lists', 'priority_lists', 'category_lists', 'agent_lists', 'comments', 'close_perm', 'reopen_perm'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$status = Status::findOrFail($id);
$name = $status->name;
$status->delete();
Session::flash('status', trans('ticketit::lang.status-name-has-been-deleted', ['name' => $name]));
return redirect()->action('\\Kordy\\Ticketit\\Controllers\\StatusesController@index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$status = Status::findOrFail($id);
$name = $status->name;
$status->delete();
Session::flash('status', "The status {$name} has been modified!");
return redirect()->action('\\Kordy\\Ticketit\\Controllers\\StatusesController@index');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
$faker = \Faker\Factory::create();
// create agents
$agents_counter = 1;
for ($a = 1; $a <= $this->agents_qty; $a++) {
$agent_info = new \App\User();
$agent_info->name = $faker->name;
$agent_info->email = 'agent' . $agents_counter . $this->email_domain;
$agent_info->ticketit_agent = 1;
$agent_info->password = Hash::make($this->default_agent_password);
$agent_info->save();
$agents[$agent_info->id] = $agent_info;
$agents_counter++;
}
// create tickets statuses
foreach ($this->statuses as $name => $color) {
$status = \Kordy\Ticketit\Models\Status::create(['name' => $name, 'color' => $color]);
}
$counter = 0;
// create tickets statuses
foreach ($this->categories as $name => $color) {
$category = \Kordy\Ticketit\Models\Category::create(['name' => $name, 'color' => $color]);
$agent = array_rand($agents, $this->agents_per_category);
$category->agents()->attach($agent);
$counter++;
}
// create tickets statuses
foreach ($this->priorities as $name => $color) {
$priority = \Kordy\Ticketit\Models\Priority::create(['name' => $name, 'color' => $color]);
}
$categories_qty = \Kordy\Ticketit\Models\Category::count();
$priorities_qty = \Kordy\Ticketit\Models\Priority::count();
$statuses_qty = \Kordy\Ticketit\Models\Status::count();
// create users
$users_counter = 1;
for ($u = 1; $u <= $this->users_qty; $u++) {
$user_info = new \App\User();
$user_info->name = $faker->name;
$user_info->email = 'user' . $users_counter . $this->email_domain;
$user_info->ticketit_agent = 0;
$user_info->password = Hash::make($this->default_user_password);
$user_info->save();
$users_counter++;
$tickets_qty = rand($this->tickets_per_user_min, $this->tickets_per_user_max);
for ($t = 1; $t <= $tickets_qty; $t++) {
$rand_category = rand(1, $categories_qty);
$priority_id = rand(1, $priorities_qty);
do {
$rand_status = rand(1, $statuses_qty);
} while ($rand_status == $this->default_closed_status_id);
$category = \Kordy\Ticketit\Models\Category::find($rand_category);
$agents = $category->agents()->lists('name', 'id')->toArray();
$agent_id = array_rand($agents);
$random_create = rand(1, $this->tickets_date_period);
$random_complete = rand($this->tickets_min_close_period, $this->tickets_max_close_period);
$ticket = new \Kordy\Ticketit\Models\Ticket();
$ticket->subject = $faker->text(50);
$ticket->content = $faker->paragraph($nbSentences = 10);
$ticket->status_id = $rand_status;
$ticket->priority_id = $priority_id;
$ticket->user_id = $user_info->id;
$ticket->agent_id = $agent_id;
$ticket->category_id = $rand_category;
$ticket->created_at = \Carbon\Carbon::now()->subDays($random_create);
$ticket->updated_at = \Carbon\Carbon::now()->subDays($random_create);
$completed_at = new Carbon($ticket->created_at);
if (!$completed_at->addDays($random_complete)->gt(\Carbon\Carbon::now())) {
$ticket->completed_at = $completed_at;
$ticket->updated_at = $completed_at;
$ticket->status_id = $this->default_closed_status_id;
}
$ticket->save();
$comments_qty = rand($this->comments_per_ticket_min, $this->comments_per_ticket_max);
for ($c = 1; $c <= $comments_qty; $c++) {
if (is_null($ticket->completed_at)) {
$random_comment_date = $faker->dateTimeBetween('-' . $random_create . ' days', 'now');
} else {
$random_comment_date = $faker->dateTimeBetween('-' . $random_create . ' days', '-' . ($random_create - $random_complete) . ' days');
}
$comment = new \Kordy\Ticketit\Models\Comment();
$comment->ticket_id = $ticket->id;
$comment->content = $faker->paragraph($nbSentences = 10);
if ($c % 2 == 0) {
$comment->user_id = $ticket->user_id;
} else {
$comment->user_id = $ticket->agent_id;
}
$comment->created_at = $random_comment_date;
$comment->updated_at = $random_comment_date;
$comment->save();
}
$last_comment = $ticket->Comments->sortByDesc('created_at')->first();
$ticket->updated_at = $last_comment['created_at'];
$ticket->save();
}
}
}