public function getEditCompInfo($id)
{
$company = \Company::where('user_id', '=', $id)->first();
if ($company) {
return \View::make('admin/user.company_view')->with('company', $company);
}
}
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 home($id = 0)
{
$param['pageNo'] = 0;
if ($alert = Session::get('alert')) {
$param['alert'] = $alert;
}
$userId = Session::has('user_id') ? Session::get('user_id') : 0;
$prefix = DB::getTablePrefix();
$result = DB::table('store')->join('company', 'store.company_id', '=', 'company.id')->leftJoin(DB::raw('(SELECT * FROM ' . $prefix . 'queue WHERE user_id = ' . $userId . ' AND DATE(created_at) = DATE(NOW()) GROUP BY store_id) AS ' . $prefix . 'queues'), 'store.id', '=', 'queues.store_id')->join('status', 'store.id', '=', 'status.store_id')->leftJoin(DB::raw('(SELECT count(*) as cnt, store_id FROM ' . $prefix . 'agent WHERE is_active = 1 GROUP BY store_id) AS ' . $prefix . 'agt'), 'agt.store_id', '=', 'store.id')->join('company_setting', 'company_setting.company_id', '=', 'company.id')->join('category', 'category.id', '=', 'company.category_id')->join('city', 'city.id', '=', 'company.city_id')->select('store.id', 'store.name as store_name', 'store.address as address', 'company.name as company_name', 'company_setting.waiting_time', 'status.current_queue_no', 'status.last_queue_no', 'agt.cnt', 'queues.queue_no');
if ($id == 0) {
$param['stores'] = $result->paginate(PAGINATION_SIZE);
} else {
$companyIds = array();
$companyIds[] = 0;
$companies = CompanyModel::where('category_id', $id)->get();
foreach ($companies as $company) {
$companyIds[] = $company->id;
}
$param['stores'] = $result->whereIn('store.company_id', $companyIds)->paginate(PAGINATION_SIZE);
}
$param['total'] = StoreModel::count();
$param['category'] = $id;
$param['categories'] = CategoryModel::all();
return View::make('user.store.home')->with($param);
}
function getCompanies(Cluster $cluster)
{
$companies = Company::where('cluster_id', '=', $cluster->id)->get();
// decode company domains
foreach ($companies as $company) {
$company->domains = json_decode($company->domains);
}
return $companies;
}
public function create()
{
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$this->data['department'] = Department::where('id', $department_admin->department_id)->first();
$this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$this->data['department'] = Department::where('id', $department_operator->department_id)->first();
$this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
} else {
$this->data['companies'] = Company::all();
}
$this->data['timezones'] = Config::get("timezones");
$this->data['countries'] = DB::table('countries')->get();
return View::make('customers.create', $this->data);
}
static function getUpdatedFields($is_fake = false, $ticket_id = 0, $msg_id = 0)
{
if (!$is_fake) {
$ticket = Tickets::where('id', $ticket_id)->first();
$thread_message = ThreadMessages::where('id', $msg_id)->first();
$ticket_attachment = TicketAttachments::where('message_id', $msg_id)->first();
$customer = User::where('id', $ticket->customer_id)->first();
$operator = User::where('id', $ticket->operator_id)->first();
$company = Company::where('id', $ticket->company_id)->first();
$department = Department::where('id', $ticket->department_id)->first();
$receiver = Input::get('user_id') == $ticket->operator_id ? $customer : $operator;
$mailer_extra = ['ticket_id' => $ticket->id, 'ticket_subject' => $ticket->subject, 'ticket_description' => $ticket->description, 'ticket_status' => $ticket->status, 'ticket_status_txt' => self::resolveStatus($ticket->status), 'ticket_priority' => $ticket->priority, 'ticket_priority_txt' => self::resolveStatus($ticket->priority), 'company_name' => $company->name, 'company_description' => $company->description, 'company_domain' => $company->domain, 'company_logo' => $company->logo, 'department_name' => $department->name, 'has_attachment' => $ticket_attachment->has_attachment, 'attachment_path' => $ticket_attachment->attachment_path, 'updated_message' => $thread_message->message, 'receiver_name' => $receiver->name, 'receiver_email' => $receiver->email];
} else {
$mailer_extra = ['ticket_id' => 1, 'ticket_subject' => "How can i use contact us form", 'ticket_description' => "Hi , Sir how can i use contact us form", 'ticket_status' => 1, 'ticket_status_txt' => self::resolveStatus(1), 'ticket_priority' => 1, 'ticket_priority_txt' => self::resolveStatus(1), 'company_name' => "KODEINFO", 'company_description' => "We are a small and dedicated team of designers/developers. This is our web design and development focused blog.We focus on pushing the boundaries of standards based web technologies.", 'company_domain' => "http://www.kodeinfo.com", 'company_logo' => "http://kodeinfo.com/img/shortlogo.png", 'department_name' => "General Queries", 'has_attachment' => false, 'attachment_path' => "", 'updated_message' => "This is a updated message from customer/operator", 'receiver_name' => "Imran", 'receiver_email' => "*****@*****.**"];
}
return $mailer_extra;
}
function get_logged_company()
{
if (!$this->is_signed_in()) {
return NULL;
} else {
if ($this->CI->session->userdata('company_id') || $this->CI->session->userdata('institution_id')) {
$c = new Company();
$c->where('id', $this->CI->session->userdata('company_id'))->get();
if ($c->exists()) {
return $c;
} else {
$c = new Institution();
$c->where('id', $this->CI->session->userdata('institution_id'))->get();
if ($c->exists()) {
return $c;
}
}
}
return NULL;
}
}
public function create()
{
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$this->data['department'] = Department::where('id', $department_admin->department_id)->first();
$this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
$permissions_keys = explode(",", $this->data['department']);
$permissions = Permissions::whereIn('key', $permissions_keys)->get();
$this->data['permissions'] = $permissions;
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$this->data['department'] = Department::where('id', $department_operator->department_id)->first();
$this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
$permissions_keys = explode(",", $this->data['department']);
$permissions = Permissions::whereIn('key', $permissions_keys)->get();
$this->data['permissions'] = $permissions;
} else {
$companies = Company::all();
$this->data['companies'] = $companies;
if (sizeof($companies) > 0) {
$department = Department::where("company_id", $companies[0]->id)->first();
if (empty($department)) {
Session::flash('error_msg', trans('msgs.create_department_before_adding_operators'));
return Redirect::back();
}
$permissions_keys = explode(",", $department->permissions);
$permissions = Permissions::whereIn('key', $permissions_keys)->get();
$this->data['permissions'] = $permissions;
$this->data['departments'] = Department::where("company_id", $companies[0]->id)->get();
} else {
$this->data['permissions'] = [];
$this->data['departments'] = [];
}
}
$this->data["countries"] = DB::table("countries")->remember(60)->get();
$this->data['timezones'] = Config::get("timezones");
return View::make('operators.create', $this->data);
}
/**
* Update the specified resource in storage.
* PUT /contact/{id}
*
* @param int $id
* @return Response
*/
public function update($id)
{
Input::merge(array_map('trim', Input::all()));
$input = Input::all();
$validation = Validator::make($input, Contact::$rules);
$gettime = time() - 14400;
$datetime_now = date("H:i:s", $gettime);
if (Input::get('fullname') == 'No record found.') {
return Redirect::route('contact.edit')->withInput()->with('class', 'error')->with('message', 'Input proper fullname.');
}
if ($validation->passes()) {
if (Input::get('category') == '1') {
$street = Input::get('street_hid');
$city = Input::get('city_hid');
$province = Input::get('province_hid');
$country = Input::get('country_hid');
$zip_code = Input::get('zip_code_hid');
$street_2 = Input::get('street_2');
$city_2 = Input::get('city_2');
$province_2 = Input::get('province_2');
$country_2 = Input::get('country_2');
$zip_code_2 = Input::get('zip_code_2');
} else {
$street = Input::get('i_street');
$city = Input::get('i_city');
$province = Input::get('i_province');
$country = Input::get('i_country');
$zip_code = Input::get('i_zip_code');
$street_2 = Input::get('street_2');
$city_2 = Input::get('city_2');
$province_2 = Input::get('province_2');
$country_2 = Input::get('country_2');
$zip_code_2 = Input::get('zip_code_2');
}
if ($street == "" || $city == "" || $country == "") {
return Redirect::route('contact.edit', $id)->withInput()->with('class', 'error')->with('message', 'Make sure to fill-up company address.');
}
$contact = Contact::find($id);
if (is_null($contact)) {
return Redirect::route('contact.edit', $id)->withInput()->withErrors($validation)->with('class', 'warning')->with('message', 'Contact information not exist.');
}
$contact->position = Input::get('profession');
$contact->fullname = strtoupper(Input::get('fullname'));
$contact->gender = strtoupper(Input::get('gender'));
$contact->category = Input::get('category');
$contact->company = Input::get('company');
$contact->in_company_position = Input::get('position');
$contact->street = strtoupper($street);
$contact->city = strtoupper($city);
$contact->province = strtoupper($province);
$contact->country = strtoupper($country);
$contact->zip_code = strtoupper($zip_code);
$contact->street_2 = strtoupper($street_2);
$contact->city_2 = strtoupper($city_2);
$contact->province_2 = strtoupper($province_2);
$contact->country_2 = strtoupper($country_2);
$contact->zip_code_2 = strtoupper($zip_code_2);
$contact->contact_number = Input::get('contact_number');
$contact->contact_number2 = Input::get('2nd_contact_number');
$contact->contact_number3 = Input::get('3rd_contact_number');
$contact->status = 1;
// if(Contact::check_ifcontactinfoExist($contact))
// {
// return Redirect::route('contact.edit', $id)
// ->withInput()
// ->withErrors($validation)
// ->with('class', 'warning')
// ->with('message', 'Record was already added by BDO.');
// }
$contactinformation = DB::table('contacts')->select('contacts.*', 'positions.position as cp_position')->join('positions', 'positions.id', '=', 'contacts.position')->where('contacts.id', $id)->first();
$pos = DB::table('positions')->where('id', Input::get('position'))->first();
if ($contactinformation->company != '0') {
$comp = Company::where('id', $contactinformation->company)->first();
$companyname = $comp->company_name;
$new_comp = Company::where('id', Input::get('company'))->first();
$new_companyname = $new_comp->company_name;
} else {
$companyname = 'N/A';
$new_companyname = 'N/A';
}
if (Contact::where('position', Input::get('position'))->where('id', $id)->count() > 0) {
$position = "";
} else {
$position = "POSITION : " . $contactinformation->cp_position . " INTO " . strtoupper($pos->position) . ", ";
}
if (Contact::where('fullname', strtoupper(Input::get('fullname')))->where('id', $id)->count() > 0) {
$fullname = "";
} else {
$fullname = "FULLNAME : " . $contactinformation->fullname . " INTO " . strtoupper(Input::get('fullname')) . ", ";
}
if (Contact::where('gender', strtoupper(Input::get('gender')))->where('id', $id)->count() > 0) {
$gender = "";
} else {
$gender = "GENDER : " . $contactinformation->gender . " INTO " . strtoupper(Input::get('gender')) . ", ";
}
if (Contact::where('company', Input::get('company'))->where('id', $id)->count() > 0) {
$company = "";
} else {
$company = "COMPANY : " . $companyname . " INTO " . strtoupper($new_companyname) . ", ";
}
if (Input::get('category') == '1') {
if (Contact::where('street', Input::get('street_hid'))->where('city', Input::get('city_hid'))->where('province', Input::get('province_hid'))->where('country', Input::get('country_hid'))->where('zip_code', Input::get('zip_code_hid'))->where('id', $id)->count() > 0) {
$address = "";
} else {
$address = "COMPANY ADDRESS : " . $contactinformation->street . " " . $contactinformation->city . ", " . $contactinformation->country . " " . $contactinformation->zip_code . " INTO " . strtoupper(Input::get('street_hid')) . " " . strtoupper(Input::get('city_hid')) . ", " . strtoupper(Input::get('country_hid')) . " " . strtoupper(Input::get('zip_code_hid')) . ", ";
}
} else {
if (Contact::where('street', Input::get('i_street'))->where('city', Input::get('i_city'))->where('province', Input::get('i_province'))->where('country', Input::get('i_country'))->where('zip_code', Input::get('i_zip_code'))->where('id', $id)->count() > 0) {
$address = "";
} else {
$address = "PERSONAL ADDRESS : " . $contactinformation->street . " " . $contactinformation->city . ", " . $contactinformation->country . " " . $contactinformation->zip_code . " INTO " . strtoupper(Input::get('i_street')) . " " . strtoupper(Input::get('i_city')) . ", " . strtoupper(Input::get('i_country')) . " " . strtoupper(Input::get('i_zip_code')) . ", ";
}
}
if (Contact::where('contact_number', Input::get('contact_number'))->where('id', $id)->count() > 0) {
$contact1 = "";
} else {
$contact1 = "CONTACT NUMBER : " . $contactinformation->contact_number . " INTO " . strtoupper(Input::get('contact_number')) . ", ";
}
if (Contact::where('contact_number2', Input::get('2nd_contact_number'))->where('id', $id)->count() > 0) {
$contact2 = "";
} else {
$contact2 = "2nd CONTACT NUMBER : " . $contactinformation->contact_number2 . " INTO " . strtoupper(Input::get('2nd_contact_number')) . ", ";
}
if (Contact::where('contact_number3', Input::get('3rd_contact_number'))->where('id', $id)->count() > 0) {
$contact3 = "";
} else {
$contact3 = "3rd CONTACT NUMBER : " . $contactinformation->contact_number3 . " INTO " . strtoupper(Input::get('3rd_contact_number')) . ", ";
}
$contact->save();
DB::table('contact_status')->insert(array(['contact_id' => $contact->id, 'user_id' => Auth::id(), 'update' => 'CHANGE ' . $contactinformation->fullname . ' IN CONTACT PERSON RECORD ' . ' | ' . $position . $fullname . $gender . $company . $address . $contact1 . $contact2 . $contact3, 'created_by' => Auth::id(), 'created_at' => date('Y-m-d') . ' ' . $datetime_now, 'access' => 1]));
return Redirect::route('contact.index')->with('class', 'success')->with('message', 'Record successfully updated.');
} else {
return Redirect::route('contact.edit', $id)->withInput()->withErrors($validation)->with('class', 'error')->with('message', 'There were validation errors.');
}
}
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');
}
Route::post('admin/companies/add', function () {
$input = Input::get(array('title', 'slug', 'description'));
$validator = new validator($input);
$validator->check('title')->is_max(3, __('companies.title_missing'));
if ($errors = $validator->errors()) {
Input::flash();
Notify::error($errors);
return Response::redirect('admin/companies/add');
}
if (empty($input['slug'])) {
$input['slug'] = $input['title'];
}
$input['slug'] = slug($input['slug']);
$company = Company::create($input);
Extend::process('company', $company->id);
Notify::success(__('companies.created'));
return Response::redirect('admin/companies');
});
Route::get('admin/companies/delete/(:num)', function ($id) {
$total = Company::count();
if ($total == 1) {
Notify::error(__('companies.delete_error'));
return Response::redirect('admin/companies/edit/' . $id);
}
$company = Company::where('id', '<>', $id)->fetch();
Company::find($id)->delete();
Post::where('company', '=', $id)->update(array('company' => $company->id));
Notify::success(__('companies.deleted'));
return Response::redirect('admin/companies');
});
});
public function all()
{
$online_users = OnlineUsers::all();
foreach ($online_users as $user) {
$user->user = User::find($user->user_id);
if ($user->operator_id > 0) {
$user->operator = User::find($user->operator_id);
}
}
if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
$department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
$this->data['department'] = Department::where('id', $department_admin->department_id)->first();
$this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$this->data['department'] = Department::where('id', $department_operator->department_id)->first();
$this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
}
$this->data['online_users'] = $online_users;
return View::make('conversations.all', $this->data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//transaction strats
\DB::beginTransaction();
//delete user in user table
$userDel = \User::find($id);
if (!$userDel->delete()) {
\DB::rollback();
return \Redirect::back()->with('error', 'Failed to delete');
}
//delete user from friends table
$friendDel = \Friends::where('child_id', '=', $id)->first();
if (!$friendDel->delete()) {
\DB::rollback();
return \Redirect::back()->with('error', 'Failed to delete');
}
//delete clients company
$companyDel = \Company::where('user_id', '=', $id)->first();
if (!$companyDel->delete()) {
\DB::rollback();
return \Redirect::back()->with('error', 'Failed to delete');
} else {
\DB::commit();
return \Redirect::back()->with('success', 'Successfully deleted');
}
}
public function edittask_forcompany($id)
{
$pagetitle = 'Edit Task for Company';
$get_company = Company::where('status', '=', 2)->orderBy('company_name', 'asc')->lists('company_name', 'id');
$get_task = Task::orderBy('task', 'asc')->lists('task', 'id');
$get_taskforcompany = DB::table('mytask_forcompany')->where('id', $id)->first();
$getattached = DB::table('attached_forcompany')->where('forcompany_id', $id)->get();
$my_company = Company::where('id', $get_taskforcompany->company_id)->first();
$my_task = Task::where('id', $get_taskforcompany->task_id)->first();
return View::make('task.edit_taskforcompany', compact('pagetitle', 'get_company', 'get_task', 'get_taskforcompany', 'my_company', 'my_task', 'getattached'));
}
function company_get()
{
$filters = $this->get("filter")["filters"];
$page = $this->get("page");
$limit = $this->get("limit");
$sort = $this->get("sort");
$data["results"] = array();
$data["count"] = 0;
$obj = new Company(null, $this->entity);
//Sort
if (!empty($sort) && isset($sort)) {
foreach ($sort as $value) {
$obj->order_by($value["field"], $value["dir"]);
}
}
//Filter
if (!empty($filters) && isset($filters)) {
foreach ($filters as $value) {
$obj->where($value["field"], $value["value"]);
}
}
if (!empty($limit) && !empty($page)) {
$obj->include_related('currency', array('locale', 'rate'), FALSE);
$obj->get_paged_iterated($page, $limit);
$data["count"] = $obj->paged->total_rows;
}
if ($obj->result_count() > 0) {
foreach ($obj as $value) {
//Results
$data["results"][] = array("id" => $value->id, "name" => $value->name, "abbr" => $value->abbr, "currency_id" => $value->currency_id, "locale" => $value->locale, "rate" => $value->rate);
}
}
//Response Data
$this->response($data, 200);
}
public function all()
{
$tickets = Tickets::orderBy('priority', 'desc')->where('customer_id', Auth::user()->id)->get();
foreach ($tickets as $ticket) {
$ticket->customer = User::where('id', $ticket->customer_id)->first();
$ticket->company = Company::where('id', $ticket->company_id)->first();
$ticket->department = Department::where('id', $ticket->department_id)->first();
if ($ticket->operator_id > 0) {
$ticket->operator = User::where('id', $ticket->operator_id)->first();
}
}
$this->data['tickets'] = $tickets;
return View::make('tickets.customers_all', $this->data);
}
public function ticketsRefresh()
{
if (Input::get('company_id', 0) > 0 && Input::get('department_id', 0) > 0) {
$tickets = Tickets::orderBy('priority', 'desc')->where('company_id', Input::get('company_id'))->where('department_id', Input::get('department_id'))->get();
} else {
$tickets = Tickets::orderBy('priority', 'desc')->get();
}
$tickets_arr = [];
foreach ($tickets as $ticket) {
$ticket->customer = User::where('id', $ticket->customer_id)->first();
$ticket->company = Company::where('id', $ticket->company_id)->first();
$ticket->department = Department::where('id', $ticket->department_id)->first();
if ($ticket->operator_id > 0) {
$ticket->operator = User::where('id', $ticket->operator_id)->first();
}
$single_ticket = [];
$single_ticket[] = $ticket->id;
$single_ticket[] = isset($ticket->company) ? $ticket->company->name : trans('msgs.none');
$single_ticket[] = isset($ticket->department) ? $ticket->department->name : trans('msgs.none');
$single_ticket[] = isset($ticket->customer) ? $ticket->customer->name : trans('msgs.none');
$single_ticket[] = isset($ticket->customer) ? $ticket->customer->email : trans('msgs.none');
$single_ticket[] = $ticket->subject;
$single_ticket[] = isset($ticket->operator) ? $ticket->operator->name : trans('msgs.none');
if ($ticket->priority == Tickets::PRIORITY_LOW) {
$single_ticket[] = '<td ><label class="label label-primary" > ' . trans("msgs.low") . ' </label ></td >';
}
if ($ticket->priority == Tickets::PRIORITY_MEDIUM) {
$single_ticket[] = '<td><label class="label label-primary">' . trans("msgs.medium") . '</label></td>';
}
if ($ticket->priority == Tickets::PRIORITY_HIGH) {
$single_ticket[] = '<td><label class="label label-warning">' . trans("msgs.high") . '</label></td>';
}
if ($ticket->priority == Tickets::PRIORITY_URGENT) {
$single_ticket[] = '<td><label class="label label-danger">' . trans("msgs.urgent") . '</label></td>';
}
if ($ticket->status == Tickets::TICKET_NEW) {
$single_ticket[] = '<td><label class="label label-warning">' . trans("msgs.new") . '</label></td>';
}
if ($ticket->status == Tickets::TICKET_PENDING) {
$single_ticket[] = '<td><label class="label label-primary">' . trans("msgs.pending") . '</label></td>';
}
if ($ticket->status == Tickets::TICKET_RESOLVED) {
$single_ticket[] = '<td><label class="label label-success">' . trans("msgs.resolved") . '</label></td>';
}
if (!isset($ticket->operator)) {
$single_ticket[] = '<td><a href="/tickets/read/' . $ticket->thread_id . '" class="btn btn-success btn-sm"> <i class="icon-checkmark4"></i> ' . trans("msgs.accept") . ' </a></td>';
}
if (isset($ticket->operator) && $ticket->operator->id == Auth::user()->id) {
$single_ticket[] = '<td><a href="/tickets/read/' . $ticket->thread_id . '" class="btn btn-success btn-sm"> <i class="icon-checkmark4"></i> ' . trans("msgs.reply") . ' </a></td>';
}
if (isset($ticket->operator) && $ticket->operator->id != Auth::user()->id) {
$single_ticket[] = '<td><a disabled class="btn btn-success btn-sm"> <i class="icon-lock3"></i> ' . trans("msgs.accept") . ' </a></td>';
}
$single_ticket[] = '<td><a href="/tickets/transfer/' . $ticket->id . '" class="btn btn-warning btn-sm"> <i class="icon-share3"></i> ' . trans("msgs.transfer") . ' </a></td>';
$single_ticket[] = '<td><a href="/tickets/delete/' . $ticket->thread_id . '" class="btn btn-danger btn-sm"> <i class="icon-remove3"></i> ' . trans("msgs.delete") . ' </a></td>';
$tickets_arr[] = $single_ticket;
}
return json_encode(['aaData' => $tickets_arr]);
}
/**
* Update the specified resource in storage.
* PUT /company/{id}
*
* @param int $id
* @return Response
*/
public function update($id)
{
Input::merge(array_map('trim', Input::all()));
$input = Input::all();
$validation = Validator::make($input, Company::$update_rules);
$gettime = time() - 14400;
$datetime_now = date("H:i:s", $gettime);
if ($validation->passes()) {
$company = Company::find($id);
if (is_null($company)) {
return Redirect::route('company.index')->withInput()->withErrors($validation)->with('class', 'warning')->with('message', 'Company information not exist.');
}
$company->company_name = strtoupper(Input::get('company_name'));
$company->type_id = Input::get('client_type');
$company->street = strtoupper(Input::get('street'));
$company->city_id = Input::get('city');
$company->province_id = Input::get('province');
$company->region = Input::get('region');
$company->country = strtoupper(Input::get('country'));
$company->zip_code = Input::get('zip_code');
$company->street2 = strtoupper(Input::get('2nd_street'));
$company->city_id2 = Input::get('2nd_city');
$company->province_id2 = Input::get('2nd_province');
$company->region2 = strtoupper(Input::get('2nd_region'));
$company->country2 = strtoupper(Input::get('2nd_country'));
$company->zip_code2 = strtoupper(Input::get('2nd_zip_code'));
$company->street3 = strtoupper(Input::get('3rd_street'));
$company->city_id3 = Input::get('3rd_city');
$company->province_id3 = Input::get('3rd_province');
$company->region3 = strtoupper(Input::get('3rd_region'));
$company->country3 = strtoupper(Input::get('3rd_country'));
$company->zip_code3 = strtoupper(Input::get('3rd_zip_code'));
$company->telephone_number = Input::get('telephone_number');
$company->fax_number = strtoupper(Input::get('fax_number'));
$company->mobile_number = Input::get('mobile_number');
$company->email = strtoupper(Input::get('email'));
$company->telephone_number2 = Input::get('2nd_telephone_number');
$company->fax_number2 = strtoupper(Input::get('2nd_fax_number'));
$company->mobile_number2 = Input::get('2nd_mobile_number');
$company->email2 = strtoupper(Input::get('2nd_email'));
$company->telephone_number3 = Input::get('3rd_telephone_number');
$company->fax_number3 = strtoupper(Input::get('3rd_fax_number'));
$company->mobile_number3 = Input::get('3rd_mobile_number');
$company->email3 = strtoupper(Input::get('3rd_email'));
$company->status = 1;
// if(Company::selectinfo_forupdate($company))
// {
// return Redirect::route('company.edit', $id)
// ->withInput()
// ->withErrors($validation)
// ->with('class', 'warning')
// ->with('message', 'Record was already added by Business Development Officer.');
// }
$company_information = DB::table('companies')->select('companies.*', 'cities.city', 'provinces.province', 'types.client_type')->join('types', 'types.id', '=', 'companies.type_id')->join('cities', 'cities.id', '=', 'companies.city_id')->join('provinces', 'provinces.id', '=', 'companies.province_id')->where('companies.id', $id)->first();
$clienttype = DB::table('types')->where('id', Input::get('client_type'))->first();
if (Company::where('company_name', Input::get('company_name'))->where('id', $id)->count() > 0) {
$company_name = "";
} else {
$company_name = "COMPANY NAME : " . $company_information->company_name . " INTO " . strtoupper(Input::get('company_name')) . ", ";
}
if (Company::where('type_id', Input::get('client_type'))->where('id', $id)->count() > 0) {
$client_type = "";
} else {
$client_type = "CLIENT TYPE : " . $company_information->client_type . " INTO " . strtoupper($clienttype->client_type) . ", ";
}
if (Company::where('street', Input::get('street'))->where('city_id', Input::get('city'))->where('province_id', Input::get('province'))->where('region', Input::get('region'))->where('country', Input::get('country'))->where('zip_code', Input::get('zip_code'))->where('id', $id)->count() > 0) {
$company_address1 = "";
} else {
$company_address1 = "COMPANY ADDRESS : " . $company_information->street . " " . $company_information->city . ", " . $company_information->country . " " . $company_information->zip_code . " INTO " . strtoupper(Input::get('street')) . " " . strtoupper(Input::get('city')) . ", " . strtoupper(Input::get('country')) . " " . strtoupper(Input::get('zip_code')) . ", ";
}
if (Company::where('street2', Input::get('2nd_street'))->where('city_id2', Input::get('2nd_city'))->where('province_id2', Input::get('2nd_province'))->where('region2', Input::get('2nd_region'))->where('country2', Input::get('2nd_country'))->where('zip_code2', Input::get('2nd_zip_code'))->where('id', $id)->count() > 0) {
$company_address2 = "";
} else {
$company_address2 = "2nd COMPANY ADDRESS : " . $company_information->street2 . " " . $company_information->city2 . ", " . $company_information->country2 . " " . $company_information->zip_code2 . " INTO " . strtoupper(Input::get('2nd_street')) . " " . strtoupper(Input::get('2nd_city')) . ", " . strtoupper(Input::get('2nd_country')) . " " . strtoupper(Input::get('2nd_zip_code')) . ", ";
}
if (Company::where('street3', Input::get('3rd_street'))->where('city_id3', Input::get('3rd_city'))->where('province_id3', Input::get('3rd_province'))->where('region3', Input::get('3rd_region'))->where('country3', Input::get('3rd_country'))->where('zip_code3', Input::get('3rd_zip_code'))->where('id', $id)->count() > 0) {
$company_address3 = "";
} else {
$company_address3 = "3rd COMPANY ADDRESS : " . $company_information->street3 . " " . $company_information->city3 . ", " . $company_information->country3 . " " . $company_information->zip_code3 . " INTO " . strtoupper(Input::get('3rd_street')) . " " . strtoupper(Input::get('3rd_city')) . ", " . strtoupper(Input::get('3rd_country')) . " " . strtoupper(Input::get('3rd_zip_code')) . ", ";
}
if (Company::where('telephone_number', Input::get('telephone_number'))->where('fax_number', Input::get('fax_number'))->where('mobile_number', Input::get('mobile_number'))->where('email', Input::get('email'))->where('id', $id)->count() > 0) {
$contact = "";
} else {
$contact = "CONTACT INFORMATION : " . $company_information->telephone_number . " / " . $company_information->fax_number . " / " . $company_information->mobile_number . " / " . $company_information->email . " INTO " . strtoupper(Input::get('telephone_number')) . " / " . strtoupper(Input::get('fax_number')) . " / " . strtoupper(Input::get('mobile_number')) . " / " . strtoupper(Input::get('email')) . ", ";
}
if (Company::where('telephone_number2', Input::get('2nd_telephone_number'))->where('fax_number2', Input::get('2nd_fax_number'))->where('mobile_number2', Input::get('2nd_mobile_number'))->where('email2', Input::get('2nd_email'))->where('id', $id)->count() > 0) {
$contact2 = "";
} else {
$contact2 = "2nd CONTACT INFORMATION : " . $company_information->telephone_number2 . " / " . $company_information->fax_number2 . " / " . $company_information->mobile_number2 . " / " . $company_information->email2 . " INTO " . strtoupper(Input::get('2nd_telephone_number')) . " / " . strtoupper(Input::get('2nd_fax_number')) . " / " . strtoupper(Input::get('2nd_mobile_number')) . " / " . strtoupper(Input::get('2nd_email')) . ", ";
}
if (Company::where('telephone_number3', Input::get('3rd_telephone_number'))->where('fax_number3', Input::get('3rd_fax_number'))->where('mobile_number3', Input::get('3rd_mobile_number'))->where('email3', Input::get('3rd_email'))->where('id', $id)->count() > 0) {
$contact3 = "";
} else {
$contact3 = "3rd CONTACT INFORMATION : " . $company_information->telephone_number3 . " / " . $company_information->fax_number3 . " / " . $company_information->mobile_number3 . " / " . $company_information->email3 . " INTO " . strtoupper(Input::get('3rd_telephone_number')) . " / " . strtoupper(Input::get('3rd_fax_number')) . " / " . strtoupper(Input::get('3rd_mobile_number')) . " / " . strtoupper(Input::get('3rd_email')) . ", ";
}
$company->save();
DB::table('company_status')->insert(array(['company_id' => $company->id, 'user_id' => Auth::id(), 'update' => 'CHANGE ' . $company_information->company_name . ' IN COMPANY RECORD ' . ' | ' . $company_name . $client_type . $company_address1 . $company_address2 . $company_address3 . $contact . $contact2 . $contact3, 'created_by' => Auth::id(), 'created_at' => date('Y-m-d') . ' ' . $datetime_now, 'access' => 1]));
return Redirect::route('company.index')->with('class', 'success')->with('message', 'Record successfully updated.');
} else {
return Redirect::route('company.edit', $id)->withInput()->withErrors($validation)->with('class', 'error')->with('message', 'There were validation errors.');
}
}
public function delete($admin_id)
{
$department_admin = DepartmentAdmins::where("user_id", $admin_id)->first();
if (Config::get('site-config.is_demo') && $admin_id == 2) {
Session::flash('error_msg', 'Demo : Feature is disabled');
return Redirect::to('/dashboard');
}
if (!empty($department_admin)) {
$department = Department::where('id', $department_admin->department_id)->first();
if (!empty($department)) {
$company = Company::where('id', $department->company_id)->first();
//Change all conversations , tickets , threads , thread_messages operator_id
OnlineUsers::where('operator_id', $admin_id)->update(['operator_id' => $company->user_id]);
ClosedConversations::where('operator_id', $admin_id)->update(['operator_id' => $company->user_id]);
MessageThread::where('operator_id', $admin_id)->update(['operator_id' => $company->user_id]);
Tickets::where('operator_id', $admin_id)->update(['operator_id' => $company->user_id]);
ThreadMessages::where('sender_id', $admin_id)->update(['sender_id' => $company->user_id]);
}
}
CompanyDepartmentAdmins::where("user_id", $admin_id)->delete();
DepartmentAdmins::where('user_id', $admin_id)->delete();
UsersGroups::where('user_id', $admin_id)->delete();
User::where('id', $admin_id)->delete();
RecentActivities::createActivity("Department admin deleted by User ID:" . Auth::user()->id . " User Name:" . Auth::user()->name);
Session::flash('success_msg', trans('msgs.department_admin_deleted_success'));
return Redirect::to('/departments/admins/all');
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$filename = $this->argument('filename');
if (!$this->option('testrun') == 'true') {
$this->comment('======= Importing Assets from ' . $filename . ' =========');
} else {
$this->comment('====== TEST ONLY Asset Import for ' . $filename . ' ====');
$this->comment('============== NO DATA WILL BE WRITTEN ==============');
}
if (!ini_get("auto_detect_line_endings")) {
ini_set("auto_detect_line_endings", '1');
}
$csv = Reader::createFromPath($this->argument('filename'));
$csv->setNewline("\r\n");
$csv->setOffset(1);
$duplicates = '';
// Loop through the records
$nbInsert = $csv->each(function ($row) use($duplicates) {
$status_id = 1;
// Let's just map some of these entries to more user friendly words
// User's name
if (array_key_exists('0', $row)) {
$user_name = trim($row[0]);
} else {
$user_name = '';
}
// User's email
if (array_key_exists('1', $row)) {
$user_email = trim($row[1]);
} else {
$user_email = '';
}
// User's email
if (array_key_exists('2', $row)) {
$user_username = trim($row[2]);
} else {
$user_username = '';
}
// Asset Name
if (array_key_exists('3', $row)) {
$user_asset_asset_name = trim($row[3]);
} else {
$user_asset_asset_name = '';
}
// Asset Category
if (array_key_exists('4', $row)) {
$user_asset_category = trim($row[4]);
} else {
$user_asset_category = '';
}
// Asset Name
if (array_key_exists('5', $row)) {
$user_asset_name = trim($row[5]);
} else {
$user_asset_name = '';
}
// Asset Manufacturer
if (array_key_exists('6', $row)) {
$user_asset_mfgr = trim($row[6]);
} else {
$user_asset_mfgr = '';
}
// Asset model number
if (array_key_exists('7', $row)) {
$user_asset_modelno = trim($row[7]);
} else {
$user_asset_modelno = '';
}
// Asset serial number
if (array_key_exists('8', $row)) {
$user_asset_serial = trim($row[8]);
} else {
$user_asset_serial = '';
}
// Asset tag
if (array_key_exists('9', $row)) {
$user_asset_tag = trim($row[9]);
} else {
$user_asset_tag = '';
}
// Asset location
if (array_key_exists('10', $row)) {
$user_asset_location = trim($row[10]);
} else {
$user_asset_location = '';
}
// Asset notes
if (array_key_exists('11', $row)) {
$user_asset_notes = trim($row[11]);
} else {
$user_asset_notes = '';
}
// Asset purchase date
if (array_key_exists('12', $row)) {
if ($row[12] != '') {
$user_asset_purchase_date = date("Y-m-d 00:00:01", strtotime($row[12]));
} else {
$user_asset_purchase_date = '';
}
} else {
$user_asset_purchase_date = '';
}
// Asset purchase cost
if (array_key_exists('13', $row)) {
if ($row[13] != '') {
$user_asset_purchase_cost = trim($row[13]);
} else {
$user_asset_purchase_cost = '';
}
} else {
$user_asset_purchase_cost = '';
}
// Asset Company Name
if (array_key_exists('14', $row)) {
if ($row[14] != '') {
$user_asset_company_name = trim($row[14]);
} else {
$user_asset_company_name = '';
}
} else {
$user_asset_company_name = '';
}
// A number was given instead of a name
if (is_numeric($user_name)) {
$this->comment('User ' . $user_name . ' is not a name - assume this user already exists');
$user_username = '';
// No name was given
} elseif ($user_name == '') {
$this->comment('No user data provided - skipping user creation, just adding asset');
$first_name = '';
$last_name = '';
//$user_username = '';
} else {
$user_email_array = User::generateFormattedNameFromFullName($this->option('email_format'), $user_name);
$first_name = $user_email_array['first_name'];
$last_name = $user_email_array['last_name'];
if ($user_email == '') {
$user_email = $user_email_array['username'] . '@' . Config::get('app.domain');
}
if ($user_username == '') {
if ($this->option('username_format') == 'email') {
$user_username = $user_email;
} else {
$user_name_array = User::generateFormattedNameFromFullName($this->option('username_format'), $user_name);
$user_username = $user_name_array['username'];
}
}
}
$this->comment('Full Name: ' . $user_name);
$this->comment('First Name: ' . $first_name);
$this->comment('Last Name: ' . $last_name);
$this->comment('Username: '******'Email: ' . $user_email);
$this->comment('Category Name: ' . $user_asset_category);
$this->comment('Item: ' . $user_asset_name);
$this->comment('Manufacturer ID: ' . $user_asset_mfgr);
$this->comment('Model No: ' . $user_asset_modelno);
$this->comment('Serial No: ' . $user_asset_serial);
$this->comment('Asset Tag: ' . $user_asset_tag);
$this->comment('Location: ' . $user_asset_location);
$this->comment('Purchase Date: ' . $user_asset_purchase_date);
$this->comment('Purchase Cost: ' . $user_asset_purchase_cost);
$this->comment('Notes: ' . $user_asset_notes);
$this->comment('Company Name: ' . $user_asset_company_name);
$this->comment('------------- Action Summary ----------------');
if ($user_username != '') {
if ($user = User::MatchEmailOrUsername($user_username, $user_email)->whereNotNull('username')->first()) {
$this->comment('User ' . $user_username . ' already exists');
} else {
// Create the user
$user = Sentry::createUser(array('first_name' => $first_name, 'last_name' => $last_name, 'email' => $user_email, 'username' => $user_username, 'password' => substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 12), 'activated' => true, 'permissions' => array('admin' => 0, 'user' => 1), 'notes' => 'User imported through asset importer'));
// Find the group using the group id
$userGroup = Sentry::findGroupById(3);
// Assign the group to the user
$user->addGroup($userGroup);
$this->comment('User ' . $first_name . ' created');
}
} else {
$user = new User();
}
// Check for the location match and create it if it doesn't exist
if ($location = Location::where('name', e($user_asset_location))->first()) {
$this->comment('Location ' . $user_asset_location . ' already exists');
} else {
$location = new Location();
if ($user_asset_location != '') {
$location->name = e($user_asset_location);
$location->address = '';
$location->city = '';
$location->state = '';
$location->country = '';
$location->user_id = 1;
if (!$this->option('testrun') == 'true') {
if ($location->save()) {
$this->comment('Location ' . $user_asset_location . ' was created');
} else {
$this->comment('Something went wrong! Location ' . $user_asset_location . ' was NOT created');
}
} else {
$this->comment('Location ' . $user_asset_location . ' was (not) created - test run only');
}
} else {
$this->comment('No location given, so none created.');
}
}
if (e($user_asset_category) == '') {
$category_name = 'Unnamed Category';
} else {
$category_name = e($user_asset_category);
}
// Check for the category match and create it if it doesn't exist
if ($category = Category::where('name', e($category_name))->where('category_type', 'asset')->first()) {
$this->comment('Category ' . $category_name . ' already exists');
} else {
$category = new Category();
$category->name = e($category_name);
$category->category_type = 'asset';
$category->user_id = 1;
if ($category->save()) {
$this->comment('Category ' . $user_asset_category . ' was created');
} else {
$this->comment('Something went wrong! Category ' . $user_asset_category . ' was NOT created');
}
}
// Check for the manufacturer match and create it if it doesn't exist
if ($manufacturer = Manufacturer::where('name', e($user_asset_mfgr))->first()) {
$this->comment('Manufacturer ' . $user_asset_mfgr . ' already exists');
} else {
$manufacturer = new Manufacturer();
$manufacturer->name = e($user_asset_mfgr);
$manufacturer->user_id = 1;
if ($manufacturer->save()) {
$this->comment('Manufacturer ' . $user_asset_mfgr . ' was created');
} else {
$this->comment('Something went wrong! Manufacturer ' . $user_asset_mfgr . ' was NOT created');
}
}
// Check for the asset model match and create it if it doesn't exist
if ($asset_model = Model::where('name', e($user_asset_name))->where('modelno', e($user_asset_modelno))->where('category_id', $category->id)->where('manufacturer_id', $manufacturer->id)->first()) {
$this->comment('The Asset Model ' . $user_asset_name . ' with model number ' . $user_asset_modelno . ' already exists');
} else {
$asset_model = new Model();
$asset_model->name = e($user_asset_name);
$asset_model->manufacturer_id = $manufacturer->id;
$asset_model->modelno = e($user_asset_modelno);
$asset_model->category_id = $category->id;
$asset_model->user_id = 1;
if ($asset_model->save()) {
$this->comment('Asset Model ' . $user_asset_name . ' with model number ' . $user_asset_modelno . ' was created');
} else {
$this->comment('Something went wrong! Asset Model ' . $user_asset_name . ' was NOT created');
}
}
// Check for the asset company match and create it if it doesn't exist
if ($user_asset_company_name != '') {
if ($company = Company::where('name', e($user_asset_company_name))->first()) {
$this->comment('Company ' . $user_asset_company_name . ' already exists');
} else {
$company = new Company();
$company->name = e($user_asset_company_name);
if ($company->save()) {
$this->comment('Company ' . $user_asset_company_name . ' was created');
} else {
$this->comment('Something went wrong! Company ' . $user_asset_company_name . ' was NOT created');
}
}
} else {
$company = new Company();
}
// Check for the asset match and create it if it doesn't exist
if ($asset = Asset::where('asset_tag', e($user_asset_tag))->first()) {
$this->comment('The Asset with asset tag ' . $user_asset_tag . ' already exists');
} else {
$asset = new Asset();
$asset->name = e($user_asset_asset_name);
if ($user_asset_purchase_date != '') {
$asset->purchase_date = $user_asset_purchase_date;
} else {
$asset->purchase_date = NULL;
}
if ($user_asset_purchase_cost != '') {
$asset->purchase_cost = ParseFloat(e($user_asset_purchase_cost));
} else {
$asset->purchase_cost = 0.0;
}
$asset->serial = e($user_asset_serial);
$asset->asset_tag = e($user_asset_tag);
$asset->model_id = $asset_model->id;
$asset->assigned_to = $user->id;
$asset->rtd_location_id = $location->id;
$asset->user_id = 1;
$asset->status_id = $status_id;
$asset->company_id = $company->id;
if ($user_asset_purchase_date != '') {
$asset->purchase_date = $user_asset_purchase_date;
} else {
$asset->purchase_date = NULL;
}
$asset->notes = e($user_asset_notes);
if ($asset->save()) {
$this->comment('Asset ' . $user_asset_name . ' with serial number ' . $user_asset_serial . ' was created');
} else {
$this->comment('Something went wrong! Asset ' . $user_asset_name . ' was NOT created');
}
}
$this->comment('=====================================');
return true;
});
}
static function getActivateFields($is_fake = false, $user_id = 0, $company_id = 0)
{
if (!$is_fake) {
$user = User::find($user_id);
$company = Company::where('id', $company_id)->first();
$mailer_extra = ['name' => $user->name, 'email' => $user->email, 'user_id' => $user->id, 'activation_code' => $user->activation_code, 'activation_url' => URL::to('/') . "/activate/" . $user->id . "/" . $user->activation_code, 'company_name' => $company->name, 'company_description' => $company->description, 'company_domain' => $company->domain, 'company_logo' => $company->logo];
} else {
$mailer_extra = ['name' => "Imran", 'email' => "*****@*****.**", 'user_id' => 1, 'activation_code' => "some-fake-activation-code", 'activation_url' => URL::to('/') . "/activate/1/some-fake-activation-code", 'company_name' => "KODEINFO", 'company_description' => "We are a small and dedicated team of designers/developers. This is our web design and development focused blog.We focus on pushing the boundaries of standards based web technologies.", 'company_domain' => "http://www.kodeinfo.com", 'company_logo' => "http://kodeinfo.com/img/shortlogo.png"];
}
return $mailer_extra;
}
public function start()
{
$response = [];
$response['token'] = 0;
if (Input::has('ip')) {
//check ip_address in blocking table
$blocking = Blocking::where('ip_address', Input::get('ip'))->first();
if (!empty($blocking)) {
if ($blocking->should_block_chat || $blocking->should_block_web_access) {
$response['blocked'] = 1;
$response['errors'] = trans('msgs.your_ip_blocked_by_admin_contact_support');
}
}
} else {
$response['blocked'] = 1;
$response['errors'] = trans('msgs.your_ip_blocked_by_admin_contact_support');
}
$response['blocked'] = 0;
$v_data = ["email" => Input::get('email'), "name" => Input::get('name'), "company_id" => Input::get('company_id'), "domain" => Input::get('domain'), "department" => Input::get('department'), "message" => Input::get('message')];
$v_rules = ["email" => 'required|email', "name" => 'required', "company_id" => 'required', "domain" => 'required', "department" => 'required', "message" => 'required'];
$v = Validator::make($v_data, $v_rules);
if ($v->passes()) {
$request_check = Company::where('id', Input::get('company_id'))->where('domain', Input::get('domain'))->get();
if (sizeof($request_check) <= 0) {
return $this->send(['result' => 0, 'errors' => trans('msgs.invalid_request_check_id_and_domain')]);
}
$company_customers = CompanyCustomers::where('company_id', Input::get('company_id'))->lists('customer_id');
$user = null;
if (sizeof($company_customers)) {
$user = User::whereIn('id', $company_customers)->where('email', Input::get('email'))->first();
}
$operator_online = Company::operatorsOnline(Input::get('company_id'));
$success_msg = trans('msgs.thanks_for_contacting_will_get_back');
$response['is_online'] = $operator_online;
$repo = new KodeInfo\Repo\MessageRepo();
if (!empty($user) && !is_null($user)) {
//user exists
$count = OnlineUsers::where('user_id', $user->id)->first();
if (sizeof($count) > 0) {
//user already online
$token = OnlineUsers::getToken();
if ($operator_online > 0) {
$response['token'] = $token;
}
$response['result'] = 1;
$response['user_id'] = $user->id;
$response['thread_id'] = $count->thread_id;
$response['success_msg'] = $success_msg;
return $this->send($response);
} else {
$token = OnlineUsers::getToken();
$thread = $repo->createNewThread($user->id, Input::get("message"), true);
if ($response['is_online']) {
$online_user = new OnlineUsers();
$online_user->user_id = $user->id;
$online_user->thread_id = $thread['thread_id'];
$online_user->operator_id = 0;
$online_user->company_id = Input::get('company_id');
$online_user->department_id = Input::get('department');
$online_user->locked_by_operator = 0;
$online_user->requested_on = \Carbon\Carbon::now();
$online_user->token = $token;
$online_user->save();
}
$country = DB::table('countries')->where('countryCode', Input::get('country'))->first();
$geo_info = new ThreadGeoInfo();
$geo_info->thread_id = $thread['thread_id'];
$geo_info->ip_address = Input::get('ip');
$geo_info->country_code = Input::get('country');
$geo_info->country = !empty($country) ? $country->countryName : "";
$geo_info->provider = Input::get('provider');
$geo_info->current_page = Input::get('page');
$geo_info->all_pages = json_encode(['pages' => [Input::get('page')]]);
$geo_info->save();
if (!$response['is_online']) {
$this->convertToTicket($thread['thread_id'], $thread['msg_id'], $user, "", Input::get('message'), Input::get('department'), Input::get('company_id'));
}
if ($operator_online > 0) {
$response['token'] = $token;
}
$response['result'] = 1;
$response['user_id'] = $user->id;
$response['thread_id'] = $thread['thread_id'];
$response['success_msg'] = $success_msg;
return $this->send($response);
}
} else {
$password = Str::random();
//Is user in users table then get id and put in company-customers table
$user = User::where('email', Input::get('email'))->first();
if (!empty($user)) {
$company_customer = new CompanyCustomers();
$company_customer->company_id = Input::get('company_id');
$company_customer->customer_id = $user->id;
$company_customer->save();
} else {
$user = $this->userManager->createUser(["name" => Input::get('name'), "email" => Input::get('email'), "password" => $password, "password_confirmation" => $password], 'customer', false);
$user->avatar = "/assets/images/default-avatar.jpg";
$user->save();
$user->getActivationCode();
$company_customer = new CompanyCustomers();
$company_customer->company_id = Input::get('company_id');
$company_customer->customer_id = $user->id;
$company_customer->save();
$this->mailer->welcome($user->email, $user->name, User::getWelcomeFields(false, $user->id, $password, $company_customer->company_id));
$this->mailer->activate($user->email, $user->name, User::getActivateFields(false, $user->id, $company_customer->company_id));
}
$token = OnlineUsers::getToken();
$thread = $repo->createNewThread($user->id, Input::get("message"), true);
if ($response['is_online']) {
$online_user = new OnlineUsers();
$online_user->user_id = $user->id;
$online_user->thread_id = $thread['thread_id'];
$online_user->operator_id = 0;
$online_user->company_id = Input::get('company_id');
$online_user->department_id = Input::get('department');
$online_user->locked_by_operator = 0;
$online_user->requested_on = \Carbon\Carbon::now();
$online_user->token = $token;
$online_user->save();
}
$country = DB::table('countries')->where('countryCode', Input::get('country'))->first();
$geo_info = new ThreadGeoInfo();
$geo_info->thread_id = $thread['thread_id'];
$geo_info->ip_address = Input::get('ip');
$geo_info->country_code = Input::get('country');
$geo_info->country = !empty($country) ? $country->countryName : "";
$geo_info->provider = Input::get('provider');
$geo_info->current_page = Input::get('page');
$geo_info->all_pages = json_encode(['pages' => [Input::get('page')]]);
$geo_info->save();
if (!$response['is_online']) {
$this->convertToTicket($thread['thread_id'], $thread['msg_id'], $user, "", Input::get('message'), Input::get('department'), Input::get('company_id'));
}
if ($operator_online > 0) {
$response['token'] = $token;
}
$response['result'] = 1;
$response['user_id'] = $user->id;
$response['thread_id'] = $thread['thread_id'];
$response['success_msg'] = $success_msg;
return $this->send($response);
}
} else {
return $this->send(['result' => 0, 'errors' => Utils::buildMessages($v->messages()->all())]);
}
}
function index()
{
if (\KodeInfo\Utilities\Utils::isCustomer(Auth::user()->id)) {
return Redirect::to('/tickets/customer/all');
}
$past_hr = \Carbon\Carbon::now()->subHour();
$today = \Carbon\Carbon::now()->subDay();
$this_week = \Carbon\Carbon::now()->subWeek();
$this_month = \Carbon\Carbon::now()->subMonth();
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();
$this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
$department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
$department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
$department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
$operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
$department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
} else {
$department->operators_online = 0;
$department->operators_offline = 0;
}
$this->data['department_stats'] = $department;
} elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
$department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
$department = Department::where('id', $department_operator->department_id)->first();
$company = Company::where('id', $department->company_id)->first();
$this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->where('company_id', $company->id)->where('department_id', $department->id)->count();
$this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
$department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
$department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
$department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
$operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
$department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
} else {
$department->operators_online = 0;
$department->operators_offline = 0;
}
$this->data['department_stats'] = $department;
} else {
$this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->count();
$this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->count();
$this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->count();
$this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->count();
$this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
$companies = Company::all();
foreach ($companies as $company) {
$departments = Department::where('company_id', $company->id)->get();
foreach ($departments as $department) {
$department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
$department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
$department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
$operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
if (sizeof($operator_ids) > 0) {
$department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
$department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
} else {
$department->operators_online = 0;
$department->operators_offline = 0;
}
}
$company->departments = $departments;
}
$this->data['department_stats'] = $companies;
}
return View::make('index', $this->data);
}
/**
* Check company if exist in our system
*
* @param string $name
* @return Response
*/
private static function isExist($name)
{
return Company::where('name', '=', $name)->count();
}
