public function createRootPeople($data)
{
$people = new People;
$people->name = $data['name'];
$people->surname = $data['surname'];
$people->age = $data['age'];
$people->gender = $data['gender'];
$people->spouse = empty($data['spouse']) ? null : $data['spouse'];
$root = People::create($people->attributesToArray());
$root->makeRoot()->save();
}
/**
* Get statistic data.
*
* @return Response
*/
public function monthStatistic($month, $year, Request $request)
{
$statistics = new \stdClass();
$StatisticEndDate = Carbon::create($year, $month, 1, 0, 0, 0)->addMonth(1);
$StatisticStartDate = Carbon::create($year, $month, 1, 0, 0, 0);
$statistics->companies = [Companies::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), Companies::whereNull("Deleted")->get()->count()];
$statistics->products = [Products::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), Products::whereNull("Deleted")->get()->count()];
$statistics->news = [News::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), News::whereNull("Deleted")->get()->count()];
$statistics->people = [People::whereNull("Deleted")->where("Date_Created", "<", $StatisticEndDate)->where("Date_Created", ">", $StatisticStartDate)->get()->count(), People::whereNull("Deleted")->get()->count()];
return json_encode($statistics);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = People::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'dept_id' => $this->dept_id, 'job_id' => $this->job_id, 'edu_lvl_id' => $this->edu_lvl_id, 'edu_spec_id' => $this->edu_spec_id, 'listener_id' => $this->listener_id]);
$query->andFilterWhere(['like', 'surname', $this->surname])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'patronymic', $this->patronymic])->andFilterWhere(['like', 'login', $this->login])->andFilterWhere(['like', 'password', $this->password])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'sot', $this->sot])->andFilterWhere(['like', 'published', $this->published])->andFilterWhere(['like', 'postaddress', $this->postaddress])->andFilterWhere(['like', 'cellphone', $this->cellphone])->andFilterWhere(['like', 'homephone', $this->homephone]);
return $dataProvider;
}
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;
}
/**
* Finds the People model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return People the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = People::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function getTagsList($category)
{
switch ($category) {
case 'Companies':
return Companies::whereNull("Deleted")->orderBy('Company_Full_Name', 'asc')->get(['id_Company as id', 'Company_Full_Name as description'])->toJson();
case 'People':
return People::whereNull("Deleted")->orderBy('First_Name', 'asc')->get(['id_People as id', 'First_Name as description'])->toJson();
case 'Vertical':
return Vertical::all(['id_Vertical as id', 'Main_Description as description'])->toJson();
case 'Products':
return Products::whereNull("Deleted")->orderBy('Product_Title', 'asc')->get(['id_Product as id', 'Product_Title as description'])->toArray();
case 'Events':
return Event::all(['id_Event as id', 'Event_Title as description'])->toJson();
}
}
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;
// });
}
});
});
}
private function processDelete()
{
$ids = $this->getRandomsNumbers(50, 50000, 1);
$queryesExecution = array();
$peoples = array();
foreach ($ids as $id) {
Debug::timer();
// SELECT + DELETE DATA
$people = Models\People::find($id);
$peoples[] = $people;
$people->delete();
$queryesExecution[] = number_format(Debug::timer() * 1000, 2);
}
return array($queryesExecution, $peoples);
}
public function circle($id)
{
$circle = Circle::find($id);
$temp = 0;
foreach ($circle->enrollments as $enrollment) {
if ($enrollment->people_id == Auth::user()->id) {
$temp = 1;
break;
}
}
if ($temp == 0) {
return 'You are not enrolled to this course!';
}
$circleList = Circle::all();
$people = People::find(Auth::user()->id);
return view('Pages.circlepage', compact('circle', 'circleList', 'people'));
}
