public function Tags($categories = "All") { $tags = []; if ($categories == NewsCategories::All || $categories == NewsCategories::Comany) { foreach ($this->company()->get() as $item) { $tags[] = (object) ["target" => $this->target[0], "id" => $item->id_Company, "description" => $item->Company_Full_Name]; } } if ($categories == NewsCategories::All || $categories == NewsCategories::Products) { foreach ($this->product()->get() as $item) { $tags[] = (object) ["target" => $this->target[3], "id" => $item->id_Product, "description" => $item->Product_Title]; } } if ($categories == NewsCategories::All || $categories == NewsCategories::People) { foreach ($this->employee()->get() as $item) { $people = People::where("id_People", "=", $item->id_People)->first(); $tags[] = (object) ["target" => $this->target[1], "id" => $item->id_People, "description" => $people->First_Name]; } } return $tags; }
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; // }); } }); }); }