function actionGetKidsParents() { $mentor = Mentor::findOne(['token' => $this->get["token"]]); $kids = Kids::findOne(['qr' => $this->get["qr"]]); $parents = array(); $r = array(); if (!$mentor) { $r = $this->setError(205); } else { if (!$kids) { $kidRelOrderPeople = RelOrderPeople::findOne(["qr" => $this->get["qr"]]); if ($kidRelOrderPeople) { $type_people = $kidRelOrderPeople->type_people; if ($type_people == 2) { $kids = Kids::findOne(["id" => $kidRelOrderPeople->id_people]); $RelOrderPeople = RelOrderPeople::find()->where("id_people='" . $kids->id . "' AND type_people=2 ")->asArray()->all(); if ($RelOrderPeople) { foreach ($RelOrderPeople as $val) { $mIDOrder = $val["id_order"]; $mRelOrderPeople = RelOrderPeople::find()->where("id_order='" . $mIDOrder . "' AND type_people=1 ")->asArray()->all(); if ($mRelOrderPeople) { $i = 0; foreach ($mRelOrderPeople as $relVal) { $mIDParent = $relVal["id_people"]; $mParent = Parents::findOne(['id' => $mIDParent]); if ($mParent) { $parents[$i]["name"] = $mParent->name; $parents[$i]["surname"] = $mParent->surname; $parents[$i]["father_name"] = $mParent->father_name; $parents[$i]["phone_number"] = $mParent->phone; $parents[$i]["email"] = $mParent->email; } $i++; } } } } if ($parents) { $r["status"] = "ok"; $r["parent_list"] = $parents; } else { $r = $this->setError(205); } } elseif ($type_people == 1) { $r = $this->setError(301); } else { $r = $this->setError(301); } } else { $r = $this->setError(301); } } else { $RelOrderPeople = RelOrderPeople::find()->where("id_people='" . $kids->id . "' AND type_people=2 ")->asArray()->all(); if ($RelOrderPeople) { foreach ($RelOrderPeople as $val) { $mIDOrder = $val["id_order"]; $mRelOrderPeople = RelOrderPeople::find()->where("id_order='" . $mIDOrder . "' AND type_people=1 ")->asArray()->all(); if ($mRelOrderPeople) { $i = 0; foreach ($mRelOrderPeople as $relVal) { $mIDParent = $relVal["id_people"]; $mParent = Parents::findOne(['id' => $mIDParent]); if ($mParent) { $parents[$i]["name"] = $mParent->name; $parents[$i]["surname"] = $mParent->surname; $parents[$i]["father_name"] = $mParent->father_name; $parents[$i]["phone_number"] = $mParent->phone; $parents[$i]["email"] = $mParent->email; } $i++; } } } } if ($parents) { $r["status"] = "ok"; $r["parent_list"] = $parents; } else { $r = $this->setError(205); } } } return json_encode($r); }
public function getMentorsPrint(Request $request) { $applications = Application::where('status', "accepted")->orderBy('name')->get(); $mentors = Mentor::orderBy('name')->get(); return view('print.mentors', compact('applications', 'mentors')); }