/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { $origin = $this->getOrigin($request); config(['global.origin.current' => $origin]); config(['global.ip.current' => $request->ip()]); if ($request->company_token) { $data = Cache::tags(['companies', 'company' . $request->company_token])->remember('token', 60 * 24 * 7, function () use($request) { $_company = Companies::where('token', $request->company_token); if ($_company->count() > 0) { $_company = $_company->first(); return ['id' => $_company->id, 'name' => $_company->name, 'uri' => $_company->uri, 'active' => $_company->active, 'domains' => $_company->domains()->lists('domain')->toArray(), 'managers' => $_company->managers()->get(['id', 'name', 'email', 'active', 'role'])->toArray()]; } else { return false; } }); if (!empty($data)) { config(['global.companies.current' => $data]); } else { Cache::tags(['companies', 'company' . $request->company_token])->forget('origin'); } } return $next($request); }
private function passData($id = null) { $HQAddresses = new \App\Models\Addresses(); $HQPhones = new \App\Models\Phones(); $company = new \App\Models\Companies(); $ultimateParentCompany = new \App\Models\Companies(); if (!is_null($id)) { $company = Companies::findOrNew($id); $mediaContacts = $company->mediaContacts()->get(); $attachments = $company->attachments()->get(); $ultimateParentCompany = $company->ultimateParent()->get(); } else { if (!Session::has('MediaContacts')) { Session::set('MediaContacts', $company->mediaContacts()->get()); } if (!Session::has('CompanyAttachments')) { Session::set('CompanyAttachments', $company->attachments()->get()); } $mediaContacts = Session::get('MediaContacts'); $attachments = Session::get("CompanyAttachments"); } $eSize = EmployeeSize::all()->toArray(); $gProfile = GrowthProfile::where('id_Growth_Profile', '>', 1)->get()->toArray(); $oship = Ownership::all()->toArray(); $rStage = RevenueStage::where('id_Revenue_Stage', '>', 1)->get()->toArray(); $cType = CompanyType::all()->toArray(); $csType = CompanySubType::all()->toArray(); $uParent = Companies::where("Deleted", "=", NULL)->get()->sortBy('Company_Full_Name')->toArray(); $products = $company->products()->whereNull("Deleted"); foreach ($products->get() as $product) { $productFocusTypeList[$product->id_Product] = []; $productTypeList = []; foreach ($product->focusSubType()->get() as $productSubType) { $productTypeList[0] = $productSubType->Product_Focus_Sub_Type; $productTypeListValues = ProductFocusType::where('id_Product_Focus_Type', '=', $productSubType->id_Product_Focus_Type)->get()->first(); $productTypeList[1] = $productTypeListValues->Product_Focus_Type; $productFocusTypeList[$product->id_Product][] = $productTypeList; } } if ($company->headquaters()->get()->count()) { $HQAddresses = Addresses::findOrNew($company->headquaters()->get()->first()->AddressId); } if ($company->headquaters()->get()->count() && $company->headquaters()->get()->first()->PhoneId) { $HQPhones = Phones::findOrNew($company->headquaters()->get()->first()->PhoneId); } foreach ($eSize as $emSize) { $employeeSize[$emSize["id_Employee_Size"]] = $emSize["Employee_Size"]; } foreach ($gProfile as $gwProfile) { $growthProfile[$gwProfile["id_Growth_Profile"]] = $gwProfile["Growth_Profile"]; } foreach ($oship as $owship) { $ownership[$owship["id_Ownership"]] = $owship["Ownership"]; } foreach ($rStage as $revStage) { $revenueStage[$revStage["id_Revenue_Stage"]] = $revStage["Revenue_Stage"]; } foreach ($cType as $coType) { $companyType[$coType["id_Company_Type"]] = $coType["Company_Type"]; } foreach ($csType as $coSuType) { $companySubType[$coSuType["id_Company_Sub_Type"]] = $coSuType["Company_Sub_Type_Name"]; } foreach ($uParent as $ulParent) { $ultimateParent[$ulParent["id_Company"]] = $ulParent["Company_Full_Name"]; } $country = Country::getListCountries(); return compact("employeeSize", "growthProfile", "productFocusTypeList", "ownership", "revenueStage", "companyType", "companySubType", "company", "ultimateParent", "mediaContacts", "country", "HQAddresses", "HQPhones", "products", "attachments", "ultimateParentCompany"); }
public function convertScript() { $data = 'data'; Excel::load('/storage/app/Medium1.xlsx', function ($reader) use($data) { $existsData = []; $reader->each(function ($sheet) use($existsData) { $company = $sheet->getTitle(); $companyModel = Companies::where("Company_Full_Name", "like", "%{$company}%")->first(); $rowData = $sheet->toArray(); foreach ($rowData as $row) { if (isset($row) && count($row)) { $name = isset($row['name']) ? trim($row['name']) : ""; if (!strlen($name) && in_array(strtolower($name), $existsData)) { continue; } $title = isset($row['title']) ? trim($row['title']) : ""; $description = isset($row['description']) ? trim($row['description']) : ""; // $employeeType = EmployeeType::all(["Type_Name"])->toArray(); // // $present = []; // foreach ($employeeType as $aType) { // if (!in_array($aType["Type_Name"], $present)) $present[] = strtolower($aType["Type_Name"]); // } //// echo "<pre>"; //// print_r($present); //// echo "</pre>"; // $Employee_types = []; // // $ptitle = explode(",", $title); // // foreach ($ptitle as $part) { // $title_part = trim(strtolower($part)); // if (strlen($title_part) == 0) { // continue; // } // $created = false; // foreach ($present as $item) { // $sameLatters = similar_text(strtolower($item), $title_part, $per); // if ($per < 80 && !in_array($title_part, $present)) { // $created = true; // $present[] = $title_part; // $Employee_types[] = EmployeeType::create(["Type_Name" => ucwords($title_part)]); // } // } // if (!$created) { // $Employee_types[] = EmployeeType::where("Type_Name", 'like', "%" . ucwords($title_part) . "%")->get()->first(); // } // // } // $flname = explode(" ", $name); $peopleFields = []; $addressFields = []; $employeeFields = []; $peopleFields['First_Name'] = is_array($flname) && isset($flname[0]) && strlen($flname[0]) ? $flname[0] : ""; $peopleFields['Surname'] = is_array($flname) && isset($flname[1]) && strlen($flname[1]) ? $flname[1] : ""; if (count($flname) == 3 && $description != "") { $peopleModel = People::where("Career_Description", "like", "%{$description}%")->get(); if ($peopleModel->count()) { foreach ($peopleModel as $pModel) { $peopleFields['Surname'] = is_array($flname) && isset($flname[2]) && strlen($flname[2]) ? $flname[2] : ""; $peopleFields['Middle_Name'] = is_array($flname) && isset($flname[1]) && strlen($flname[1]) ? $flname[1] : ""; echo $peopleFields['First_Name'] . " : " . $peopleFields['Middle_Name'] . " : " . $peopleFields['Surname']; $pModel->fill($peopleFields)->save(); } } } // // if ($peopleFields['First_Name'] && $peopleFields['First_Name'] || ($peopleFields['First_Name'])) { // $addressModel = Addresses::create($addressFields); // $peopleFields['Career_Description'] = $description; // $peopleFields['Date_Created'] = Carbon::now(); // $peopleFields['AddressId'] = $addressModel->AddressId; // $peopleModel = People::create($peopleFields); // if ($companyModel) { // $peopleModel->careerHistory()->save(new \App\Models\CareerHistory([ // "Position_Name" => $title, "Company_Name" => $companyModel->Company_Full_Name, // "Current_Position_Status" => 1 // ])); // } // $employeeModel = $peopleModel->employee()->create($employeeFields); // foreach ($Employee_types as $EmployeeType) { // $employeeModel->employeeType()->save($EmployeeType); // } // // } // $existsData[] = strtolower($name); } // // // Loop through all rows // $sheet->each(function($row) { // echo $row; // }); } }); }); }