private function passData($id = null) { $jobs = new \App\Models\Jobs(); if (!is_null($id)) { $jobs = Jobs::findOrNew($id); } $companyPreference = $jobs->getCompanyPreference() ? $jobs->getCompanyPreference() : new \App\Models\CompanyPreference(); $address = $jobs->address()->first() ? $jobs->address()->first() : new \App\Models\Addresses(); $commOrBon = CommisionOrBonus::all()->sortBy("Commission_Or_Bonus")->toArray(); $lns = SupportedLanguages::all()->sortBy("Language_Name")->toArray(); if (sizeof($commOrBon) == 0) { $commOrBon = new \App\Models\CommisionOrBonus(); } $tEndUser = TargetEndUser::all()->sortBy("Target_End_User")->toArray(); foreach ($commOrBon as $commisionOrBonusVal) { $commisionOrBonus[$commisionOrBonusVal["id_Commission_Or_Bonus"]] = $commisionOrBonusVal["Commission_Or_Bonus"]; } foreach ($tEndUser as $tgEndUser) { $targetEndUser[$tgEndUser["id_Target_End_User"]] = $tgEndUser["Target_End_User"]; } foreach ($lns as $langs) { $languages[$langs["id_Language"]] = $langs["Language_Name"]; } $companies = Companies::SelectOptionsModel(); $jobType = $jobs->getJobType(); $jobFamilyOptions = JobFamily::getJobsFamilyOptions(); $jobTypesOptions = JobType::getJobsTypesByJobFamilyOptions($jobType->id_Job_Family); $countryModel = $address->getCountry(); $regionsOptions = Region::getRegionsOptions(); $countryOptions = Country::getCountriesOptionsByRegion($countryModel->id_Region); return compact("companies", "commisionOrBonus", "targetEndUser", "jobFamilyOptions", "regionsOptions", "countryOptions", "languages", "jobs", "companyPreference", "address", "jobTypesOptions"); }
public function jobTypeByJobFamily($jobFamily) { return JobType::where("id_Job_Family", "=", $jobFamily)->get()->toJson(); }
public function getJobType() { return JobType::where("id_Job_Type", '=', $this->id_Job_Type)->first(); }
public function edit($id) { if (Auth::user()->can('update-ticket')) { $data['ticket'] = self::API()->find(['id' => $id]); $temp = DB::table("ticket_links")->where("ticket_id", "=", $id)->get(); foreach ($temp as $elem) { $links[] = $elem->linked_ticket_id; } $data['ticket']['linked_tickets_id'] = isset($links) ? implode(",", $links) : ''; $data['companies'] = Company::where('id', '!=', ELETTRIC80_COMPANY_ID)->orderBy('name')->get(); $data['priorities'] = Priority::orderBy('id', 'desc')->get(); $data['divisions'] = Division::orderBy('name')->get(); $data['job_types'] = JobType::orderBy('name')->get(); $data['levels'] = Level::orderBy('name')->get(); $data['assignees'] = CompanyPersonController::API()->all(["where" => ["companies.id|=|" . ELETTRIC80_COMPANY_ID], "order" => ["people.last_name|ASC", "people.first_name|ASC"], "paginate" => "false"]); $data['companies'] = CompaniesController::API()->all(['where' => ['companies.id|!=|' . ELETTRIC80_COMPANY_ID], 'order' => ['companies.name|ASC'], 'paginate' => 'false']); $data['tags'] = ""; foreach ($data['ticket']->tags as $tag) { $data['tags'] .= $tag->name . ","; } $is_draft = $data['ticket']->status_id == TICKET_DRAFT_STATUS_ID ? true : false; $data['title'] = "Edit Ticket #" . $id; return view('tickets/edit', $data); } else { return redirect()->back()->withErrors(['Access denied to tickets edit page']); } }