public function all()
{
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$company = Company::where('id', $department->company_id)->first();
$messages = CannedMessages::where('company_id', $company->id)->where('department_id', $department->id)->orderBy('id', 'desc')->get();
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_admin = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_admin->department_id)->first();
$company = Company::where('id', $department->company_id)->first();
$messages = CannedMessages::where('company_id', $company->id)->where('department_id', $department->id)->where('operator_id', Auth::user()->id)->orderBy('id', 'desc')->get();
} else {
$messages = CannedMessages::orderBy('id', 'desc')->get();
}
foreach ($messages as $message) {
$operator = User::find($message->operator_id);
$department = Department::find($message->department_id);
$company = Company::find($message->company_id);
$message->operator = $operator;
$message->department = $department;
$message->company = $company;
}
$this->data['messages'] = $messages;
return View::make('canned_messages.all', $this->data);
}
public function delete($company_id)
{
$departments = Department::where('company_id', $company_id)->get();
if (Config::get('site-config.is_demo') && $company_id == 1) {
Session::flash('error_msg', 'Demo : Feature is disabled');
return Redirect::to('/dashboard');
}
foreach ($departments as $department) {
if (!empty($department)) {
$tickets = Tickets::where('department_id', $department->id)->get();
//Delete tickets
foreach ($tickets as $ticket) {
TicketAttachments::where('thread_id', $ticket->id)->delete();
MessageThread::where('id', $ticket->thread_id)->delete();
ThreadMessages::where('thread_id', $ticket->thread_id)->delete();
}
Tickets::where('department_id', $department->id)->delete();
//Delete Chat and Conversations
$online_users = OnlineUsers::where('department_id', $department->id)->get();
foreach ($online_users as $online_user) {
MessageThread::where('id', $online_user->thread_id)->delete();
ThreadMessages::where('thread_id', $online_user->thread_id)->delete();
}
OnlineUsers::where('department_id', $department->id)->delete();
$closed_conversations = ClosedConversations::where('department_id', $department->id)->get();
foreach ($closed_conversations as $closed_conversation) {
MessageThread::where('id', $closed_conversation->thread_id)->delete();
ThreadMessages::where('thread_id', $closed_conversation->thread_id)->delete();
}
ClosedConversations::where('department_id', $department->id)->delete();
$operators = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operators) > 0) {
User::whereIn('id', $operators)->delete();
UsersGroups::whereIn('user_id', $operators)->delete();
}
OperatorsDepartment::where('department_id', $department->id)->delete();
$department_admin = DepartmentAdmins::where('department_id', $department->id)->first();
if (!empty($department_admin)) {
UsersGroups::where('user_id', $department_admin->user_id)->delete();
User::where("id", $department_admin->user_id)->delete();
CompanyDepartmentAdmins::where("user_id", $department_admin->user_id)->delete();
CannedMessages::where('operator_id', $operators)->delete();
}
}
DepartmentAdmins::where('department_id', $department->id)->delete();
Department::where('id', $department->id)->delete();
}
$company = Company::where('id', $company_id)->first();
RecentActivities::createActivity("Company <a href='/companies/all'>" . $company->name . "</a> deleted by User Name " . Auth::user()->name . " User ID " . Auth::user()->id);
Company::where('id', $company_id)->delete();
Session::flash('success_msg', trans('msgs.company_deleted_success'));
return Redirect::to('/companies/all');
}
public function read($thread_id)
{
if (Utils::isOperator(Auth::user()->id)) {
$canned_messages = CannedMessages::where('operator_id', Auth::user()->id)->get();
} elseif (Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$operator_ids = OperatorsDepartment::where('department_id', $department_admin->department_id)->lists("user_id");
if (sizeof($operator_ids) > 0) {
$canned_messages = CannedMessages::whereIn('operator_id', $operator_ids)->get();
} else {
$canned_messages = [];
}
} else {
$canned_messages = CannedMessages::all();
}
$this->data['canned_messages'] = $canned_messages;
$ticket = Tickets::where('thread_id', $thread_id)->first();
$thread = MessageThread::find($thread_id);
if ($ticket->customer_id > 0) {
$ticket->customer = User::find($ticket->customer_id);
}
$messages = MessageThread::getTicketMessages($thread_id, 0);
$geo_info = ThreadGeoInfo::where('thread_id', $thread_id)->first();
$this->data['geo'] = $geo_info;
$this->data['message_str'] = $messages["messages_str"];
$this->data['last_message_id'] = $messages["last_message_id"];
$this->data['thread'] = $thread;
$this->data['ticket'] = $ticket;
return View::make('tickets.customers_read', $this->data);
}
public function read($thread_id)
{
if (Utils::isOperator(Auth::user()->id)) {
$canned_messages = CannedMessages::where('operator_id', Auth::user()->id);
} else {
$canned_messages = CannedMessages::all();
}
$this->data['canned_messages'] = $canned_messages;
$thread = MessageThread::where('id', $thread_id)->first();
$messages = MessageThread::getServerMessages($thread_id, 0);
$geo_info = ThreadGeoInfo::where('thread_id', $thread_id)->first();
$this->data['geo'] = $geo_info;
$this->data['geo_pages'] = json_decode($geo_info->all_pages);
$this->data['message_str'] = $messages["messages_str"];
$this->data['last_message_id'] = $messages["last_message_id"];
$this->data['thread'] = $thread;
$this->data['closed_conversation'] = 1;
return View::make('conversations.messages', $this->data);
}
public function delete($user_id)
{
$operators_department = OperatorsDepartment::where("user_id", $user_id)->first();
if (!empty($operators_department)) {
$department_admin = DepartmentAdmins::where('department_id', $operators_department->department_id)->first();
if (!empty($department_admin)) {
//Change all conversations , tickets , threads , thread_messages operator_id
OnlineUsers::where('operator_id', $user_id)->update(['operator_id' => $department_admin->user_id]);
ClosedConversations::where('operator_id', $user_id)->update(['operator_id' => $department_admin->user_id]);
MessageThread::where('operator_id', $user_id)->update(['operator_id' => $department_admin->user_id]);
Tickets::where('operator_id', $user_id)->update(['operator_id' => $department_admin->user_id]);
ThreadMessages::where('sender_id', $user_id)->update(['sender_id' => $department_admin->user_id]);
}
}
RecentActivities::createActivity("User " . User::where('id', $user_id)->pluck('name') . " deleted by User ID:" . Auth::user()->id . " User Name:" . Auth::user()->name);
User::find($user_id)->delete();
OperatorsDepartment::where("user_id", $user_id)->delete();
CannedMessages::where('operator_id', $user_id)->delete();
UsersGroups::where('user_id', $user_id)->delete();
Session::flash('success_msg', trans('msgs.operator_deleted_success'));
return Redirect::to('/operators/all');
}
