public function delete($thread_id) { Tickets::where('thread_id', $thread_id)->delete(); TicketAttachments::where('thread_id', $thread_id)->delete(); MessageThread::where('id', $thread_id)->delete(); ThreadMessages::where('thread_id', $thread_id)->delete(); ThreadGeoInfo::where('thread_id', $thread_id)->delete(); RecentActivities::createActivity("Ticket deleted by User ID:" . Auth::user()->id . " User Name:" . Auth::user()->name); Session::flash('success_msg', trans('msgs.ticket_deleted_success')); return Redirect::to('/tickets/all'); }
public function deleteConversation($thread_id) { ThreadMessages::where('thread_id', $thread_id)->delete(); MessageThread::where('id', $thread_id)->delete(); ThreadGeoInfo::where('thread_id', $thread_id)->delete(); ClosedConversations::where('thread_id', $thread_id)->delete(); RecentActivities::createActivity("Conversation deleted by User ID:" . Auth::user()->id . " User Name:" . Auth::user()->name); Session::flash('success_msg', trans('msgs.conversation_deleted_success')); return Redirect::to('/conversations/closed'); }
public function checkNewMessages() { $v_data = ["user_id" => Input::get('user_id'), "thread_id" => Input::get('thread_id'), "company_id" => Input::get('company_id'), "last_message_id" => Input::get('last_message_id')]; $v_rules = ["user_id" => 'required', "thread_id" => 'required', "company_id" => 'required', "last_message_id" => 'required']; //Check any operators online from company_id //Check if we have any messages from user_id , thread_id $v = Validator::make($v_data, $v_rules); $response['is_online'] = false; if ($v->passes()) { //check any operator online $response['is_online'] = Company::operatorsOnline(Input::get('company_id')); $response['success_msg'] = ""; $company = Company::find(Input::get('company_id')); $response['departments'] = Department::where('company_id', Input::get('company_id'))->get(); foreach ($response['departments'] as $department) { $department_admin = DepartmentAdmins::where('department_id', $department->id)->first(); $status = trans('msgs._offline_'); $admin = User::where('id', $company->user_id)->first(); if (!empty($admin)) { if ($admin->is_online == 1) { $status = trans('msgs._online_'); } } if (!empty($department_admin)) { $user = User::where('id', $department_admin->user_id)->first(); if (!empty($user) && $user->is_online == 1) { $status = trans('msgs._online_'); } } $operators = OperatorsDepartment::where('department_id', $department->id)->get(); foreach ($operators as $operator) { if (sizeof(User::where('id', $operator->user_id)->get()) > 0) { $user = User::find($operator->user_id); if ($user->is_online == 1) { $status = trans('msgs._online_'); } } } $department->name = $department->name . $status; } if (Input::has('token') && sizeof(OnlineUsers::where('token', Input::get('token'))->get()) > 0) { $token = Input::get('token'); $response['token'] = $token; $online_user = OnlineUsers::where('token', $token)->first(); $response['in_conversation'] = 1; $response['conversation_closed'] = 0; $response['thread_id'] = $online_user->thread_id; $thread_geo_info = ThreadGeoInfo::where('thread_id', $online_user->thread_id)->first(); $this->fillPage(Input::get('page'), $thread_geo_info); $response['user_id'] = $online_user->user_id; $response['messages'] = MessageThread::getClientMessages($online_user->thread_id, Input::get('last_message_id')); } else { $response['in_conversation'] = 0; $response['token'] = ""; $response['messages'] = []; $response['conversation_closed'] = 0; //Is conversation already closed if (sizeof(ClosedConversations::where('thread_id', Input::get('thread_id'))->get()) > 0) { $response['success_msg'] = trans('msgs.thanks_for_contacting_support'); $response['token'] = 0; $response['in_conversation'] = 1; $response['conversation_closed'] = 1; $response['thread_id'] = 0; $response['user_id'] = 0; } } } return $this->send($response); }