コード例 #1
0
 public function dashboardContact($contact_id)
 {
     $data['contact'] = $contact = CompanyPerson::find($contact_id);
     $data['title'] = Auth::user()->active_contact_id == $contact_id ? "My Dashboard" : $contact->person->name() . " Dashboard";
     $data['user_tickets_status_data'] = ChartsManager::userTicketsStatusData($contact_id);
     $data['user_tickets_involvement_data'] = ChartsManager::userTicketsInvolvementData($contact_id);
     $data['user_tickets_status'] = ChartsManager::userTicketsStatus($contact_id);
     $data['user_tickets_involvement'] = ChartsManager::userTicketsInvolvement($contact_id);
     return view('dashboard/index', $data);
 }
コード例 #2
0
 public function run()
 {
     $person = DB::table('people')->where('first_name', 'James')->where('last_name', 'Sample')->first();
     $company = Company::where('name', 'Sample Company')->first();
     $group_type = GroupType::where('name', 'employee')->first();
     $group = Group::where('name', 'e80-helpdesk')->first();
     if (isset($person)) {
         CompanyPerson::create(['person_id' => $person->id, 'company_id' => $company->id, 'group_type_id' => $group_type->id, 'group_id' => $group->id]);
     }
 }
コード例 #3
0
 private function query($params = array())
 {
     $raw1 = DB::raw("CASE \n                            WHEN company_main_contacts.main_contact_id = company_person.id \n                            THEN 1 \n                            ELSE 0 \n                         END as 'is_main_contact'");
     $contacts = CompanyPerson::select("company_person.*", "people.first_name", "people.last_name", $raw1);
     $contacts->leftJoin('people', 'company_person.person_id', '=', 'people.id');
     $contacts->leftJoin('companies', 'company_person.company_id', '=', 'companies.id');
     $contacts->leftJoin('titles', 'company_person.title_id', '=', 'titles.id');
     $contacts->leftJoin('groups', 'company_person.group_id', '=', 'groups.id');
     $contacts->leftJoin('departments', 'company_person.department_id', '=', 'departments.id');
     $contacts->leftJoin('company_main_contacts', 'company_main_contacts.company_id', '=', 'companies.id');
     if (Auth::check() && !Auth::user()->active_contact->isE80() && (!isset($params['debugger_list']) || $params['debugger_list'] != "true" || Auth::user()->owner->id != ADMIN_PERSON_ID)) {
         $contacts->where("company_person.company_id", "=", Auth::user()->active_contact->company_id);
     }
     return $contacts;
 }
コード例 #4
0
 public function storeInfo(StartRequest $request)
 {
     if (Session::get("start_session")) {
         $user = User::find(Session::get("start_session.user_id"));
         $person = $user->owner;
         if (Input::file('profile_picture') && Input::file('profile_picture')->isValid()) {
             $request['file'] = Input::file('profile_picture');
             $request['target'] = "people";
             $request['target_id'] = $person->id;
             $request['uploader_id'] = $user->active_contact->id;
             $repo = new FilesRepository();
             $result = $repo->upload($request);
             if (!$result['error']) {
                 $old_profile_picture = $person->profile_picture_id;
                 if (!is_null($old_profile_picture)) {
                     $person->profile_picture_id = NULL;
                     $person->save();
                     $repo->destroy($old_profile_picture);
                 }
                 $person->profile_picture_id = $result['id'];
                 $person->save();
             }
         }
         if (Session::get("start_session.safe_enough") == false) {
             $user->password = Hash::make($request->get('password'));
         }
         $user->last_login = Carbon::now();
         $user->save();
         $person->first_name = $request->get('first_name');
         $person->last_name = $request->get('last_name');
         $person->save();
         if ($request->get('use_info_all_contacts') == "true") {
             $new_contact = $request->get('contact');
             foreach ($person->company_person as $contact) {
                 $contact->phone = $new_contact['phone'];
                 $contact->extension = $new_contact['extension'];
                 $contact->cellphone = $new_contact['cellphone'];
                 $contact->email = $new_contact['email'];
                 $contact->department_id = $new_contact['department_id'];
                 $contact->title_id = $new_contact['title_id'];
                 $contact->save();
             }
         } else {
             $contacts = $request->get('contacts');
             foreach ($contacts as $key => $new_contact) {
                 $contact = CompanyPerson::find($key);
                 $contact->phone = $new_contact['phone'];
                 $contact->extension = $new_contact['extension'];
                 $contact->cellphone = $new_contact['cellphone'];
                 $contact->email = $new_contact['email'];
                 $contact->department_id = $new_contact['department_id'];
                 $contact->title_id = $new_contact['title_id'];
                 $contact->save();
             }
         }
         Session::flush();
     }
     return redirect()->route('login.login')->withErrors(['Please, login again']);
 }
コード例 #5
0
 public function edit($id)
 {
     if (Auth::user()->can('update-company')) {
         $data['company'] = Company::find($id);
         $selected_account_manager = CompanyAccountManager::where('company_id', '=', $id)->first();
         $data['company']->account_manager_id = isset($selected_account_manager) ? $selected_account_manager->account_manager_id : null;
         $selected_main_contact = CompanyMainContact::where('company_id', '=', $id)->first();
         $data['company']->main_contact_id = isset($selected_main_contact) ? $selected_main_contact->main_contact_id : null;
         $data['account_managers'] = CompanyPersonController::API()->all(["where" => ["company_person.company_id|=|" . ELETTRIC80_COMPANY_ID, "company_person.title_id|=|" . ACCOUNT_MANAGER_TITLE_ID], "order" => ["people.last_name|ASC", "people.first_name|ASC"], "paginate" => "false"]);
         $data['main_contacts'] = CompanyPerson::where('company_person.company_id', '=', $id)->get();
         $data['support_types'] = SupportType::orderBy("name")->get();
         $data['connection_types'] = ConnectionType::orderBy("name")->get();
         $data['escalation_profiles'] = EscalationProfile::orderBy("name")->get();
         $data['title'] = "Edit " . $data['company']->name;
         return view('companies/edit', $data);
     } else {
         return redirect()->back()->withErrors(['Access denied to companies edit page']);
     }
 }
コード例 #6
0
 public static function workingTimeData($days, $type)
 {
     $result = null;
     if ($type == "division") {
         $grouping = Division::whereIn('id', [LGV_DIVISION_ID, PLC_DIVISION_ID, PC_DIVISION_ID, BEMA_DIVISION_ID, FIELD_DIVISION_ID, SPARE_PARTS_DIVISION_ID, RELIABILITY_DIVISION_ID, OTHERS_DIVISION_ID])->orderBy("name")->get();
     } elseif ($type == "priority") {
         $grouping = Priority::orderBy("name")->get();
     } elseif ($type == "level") {
         $grouping = Level::orderBy("name")->get();
     } elseif ($type == "company") {
         $grouping = Company::orderBy("name")->get();
     } elseif ($type == "assignee") {
         $grouping = CompanyPerson::select("company_person.*", "people.first_name", "people.last_name")->leftJoin('people', 'company_person.person_id', '=', 'people.id')->where('company_person.company_id', '=', ELETTRIC80_COMPANY_ID)->orderBy("last_name")->get();
         foreach ($grouping as $group) {
             $group->name = $group->last_name . " " . $group->first_name;
         }
     }
     if (isset($grouping)) {
         foreach ($grouping as $index => $group) {
             for ($i = 0; $i < 50; $i++) {
                 $query = "SELECT SUM(resolution_time) as sum, COUNT(*) as ticket_count, AVG(resolution_time) as average, DATE_SUB(NOW(), INTERVAL " . $days * ($i + 1) . " day) as date\n                            FROM (\n                            SELECT before.ticket_id, SUM(\n                                TIMESTAMPDIFF(SECOND, \n                                    GREATEST(DATE_SUB(NOW(), INTERVAL " . $days * ($i + 1) . " day), before.created_at), \n                                    LEAST(DATE_SUB(NOW(), INTERVAL " . $days * $i . " day), IFNULL(after.created_at,NOW()))\n                                )\n                            )/3600 as resolution_time\n                            FROM tickets_history as `before`\n                            LEFT JOIN tickets_history as `after` ON before.id = after.previous_id\n                            INNER JOIN tickets ON tickets.id = before.ticket_id \n                            WHERE (\n                                after.status_id IN (" . TICKET_NEW_STATUS_ID . "," . TICKET_IN_PROGRESS_STATUS_ID . ",\n                                " . TICKET_REQUESTING_STATUS_ID . "," . TICKET_SOLVED_STATUS_ID . "," . TICKET_CLOSED_STATUS_ID . ")\n                                OR \n                                (before.status_id IN (" . TICKET_NEW_STATUS_ID . "," . TICKET_IN_PROGRESS_STATUS_ID . ",\n                                " . TICKET_REQUESTING_STATUS_ID . ") AND after.id IS NULL)\n                            )\n                            AND tickets.deleted_at IS NULL\n                            AND tickets." . $type . "_id = {$group->id}\n                            AND TIMESTAMPDIFF(SECOND, \n                                GREATEST(before.created_at,DATE_SUB(NOW(), INTERVAL " . $days * ($i + 1) . " day)), \n                                LEAST(DATE_SUB(NOW(), INTERVAL " . $days * $i . " day), IFNULL(after.created_at,NOW()))) > 0\n                            GROUP BY before.ticket_id\n                            ) as " . $type[0] . "_{$index} ";
                 $temp = DB::select(DB::raw($query));
                 foreach ($temp[0] as $key => $value) {
                     if ($key != "date") {
                         $div_key = str_replace(" ", "_", $group->name);
                         if ($i == 0) {
                             $result[$div_key][$key]['current'] = round($temp[0]->{$key}, 2);
                         }
                         if ($i == 1) {
                             $result[$div_key][$key]['previous'] = round($temp[0]->{$key}, 2);
                         }
                         $result[$div_key][$key]['historical'][$temp[0]->date] = $temp[0]->{$key};
                     }
                 }
             }
         }
     }
     return $result;
 }
コード例 #7
0
 /**
  * Determine if the user is authorized to make this request.
  *
  * @return bool
  */
 public function authorize()
 {
     $company_person = CompanyPerson::find($this->route('company_person_id'));
     return Auth::user()->can('update-contact') || Auth::user()->can('update-own-contact') && Auth::user()->active_contact->id == $this->route('company_person_id') || !$company_person->isE80() && Auth::user()->can('update-customer-contact');
 }
コード例 #8
0
 public function update($id, UpdateCompanyPersonRequest $request)
 {
     $contact = CompanyPerson::find($id);
     $contact->department_id = Input::get('department_id');
     $contact->title_id = Input::get('title_id');
     $contact->phone = Input::get('phone');
     $contact->extension = Input::get('extension');
     $contact->cellphone = Input::get('cellphone');
     $contact->division_ids = Input::get('division_ids') ? implode(",", Input::get('division_ids')) : "";
     $contact->email = Input::get('email');
     $contact->group_id = Auth::user()->can('update-group-contact') ? Input::get('group_id') : $contact->group_id;
     $contact->save();
     return redirect()->route('company_person.show', $id)->with('successes', ['Contact updated successfully']);
 }