public function detailsAction($id = null)
{
$this->permission('index');
if (!$id) {
return Brightery::error404();
}
$this->language->load("clinic_patients");
$patient = $this->Database->query("SELECT users.*, `user_addresses`.`address`, `user_phones`.`phone`" . "FROM `users` " . "LEFT JOIN `user_addresses` ON `user_addresses`.`user_id`=`users`.`user_id`" . "LEFT JOIN `user_phones` ON `user_phones`.`user_id`=`users`.`user_id`" . "WHERE `users`.`user_id`='{$id}'" . "")->row();
if (!$patient) {
Brightery::error404();
}
$phones = new \modules\users\models\User_phones();
$phones->_select = "user_phone_id, phone, user_id , `primary`";
$phones->user_id = $id;
$res = $phones->get();
$user_phone_id = $res[0]->user_phone_id;
$phones->user_phone_id = $user_phone_id;
$address = new modules\users\models\User_addresses();
$address->select = 'user_address_id ,user_id';
$address->user_id = $id;
$add = $address->get();
$info = $this->Database->query("SELECT clinic_patient_diseases.*, `clinic_disease_templates`.`title`" . "FROM `clinic_patient_diseases` " . "JOIN `clinic_disease_templates` ON `clinic_disease_templates`.`clinic_disease_template_id`=`clinic_patient_diseases`.`clinic_disease_template_id`" . "JOIN `users` ON `users`.`user_id`=`clinic_patient_diseases`.`user_id`" . "WHERE `clinic_patient_diseases`.`user_id`='{$id}'" . "")->result();
$notes = $this->Database->query("SELECT clinic_patients_notes.*, (SELECT fullname FROM users WHERE clinic_doctors.user_id = users.user_id ) as doctor_name" . " FROM clinic_patients_notes " . " LEFT JOIN clinic_doctors ON clinic_doctors.clinic_doctor_id = clinic_patients_notes.clinic_doctor_id " . "WHERE clinic_patients_notes.user_id = '{$id}'")->result();
$xrays = $this->Database->query("SELECT clinic_xray_negative.*" . " FROM clinic_xray_negative " . "WHERE clinic_xray_negative.user_id = '{$id}'")->result();
return $this->render('clinic_patients/details', ['patient' => $patient, 'diseases' => $info, 'phones' => $res, 'address' => $add, 'notes' => $notes, 'xrays' => $xrays, 'id' => $id]);
}
public function manageAction($id = null)
{
$this->permission('manage');
if ($_POST) {
$model = new \modules\users\models\Users();
$phones = $this->input->post('phone');
$primary_phone = $this->input->post('primary_phone');
$primary_address = $this->input->post('primary_address');
$model->user_id = $id;
$model->fullname = $this->input->post('fullname');
$model->birthdate = $this->input->post('birthdate');
$model->email = $this->input->post('email');
$model->password = md5($this->input->post('password'));
$model->gender = $this->input->post('gender');
$model->image = $this->input->post('image');
$model->save();
$address = $this->input->post('address');
$user_phone_id = $this->input->post('user_phone_id');
$user_address_id = $this->input->post('user_address_id');
foreach ($phones as $key => $value) {
if (!$value) {
continue;
}
$prPhone = new \modules\users\models\User_phones();
$prPhone->_select = 'user_phone_id';
$prPhone->user_id = $id;
$prPhone->primary = 1;
$res = $prPhone->get();
$userphoneid = $res[0]->user_phone_id;
$phone = new \modules\users\models\User_phones();
$phone->user_id = $id;
$phone->phone = $value;
if ($user_phone_id[$key] == $primary_phone) {
$phone->primary = 1;
$pPhone = new \modules\users\models\User_phones();
$pPhone->user_phone_id = $userphoneid;
$pPhone->primary = 0;
$pPhone->save();
}
if ($user_phone_id[$key]) {
$phone->user_phone_id = $user_phone_id[$key];
}
$phone->save();
}
foreach ($address as $key => $value) {
if (!$value) {
continue;
}
$prAdd = new \modules\users\models\User_addresses();
$prAdd->_select = 'user_address_id';
$prAdd->user_id = $id;
$prAdd->primary = 1;
$res = $prAdd->get();
$useraddressid = $res[0]->user_address_id;
$addres = new \modules\users\models\User_addresses();
$addres->user_id = $id;
$addres->address = $value;
if ($user_address_id[$key] == $primary_address) {
$addres->primary = 1;
$pAddress = new \modules\users\models\User_addresses();
$pAddress->user_address_id = $useraddressid;
$pAddress->primary = 0;
$pAddress->save();
}
if ($user_address_id[$key]) {
$addres->user_address_id = $user_address_id[$key];
}
$addres->save();
}
$model->save();
}
if ($model->save()) {
return json_encode(['sucess' => 1, 'item' => $model, 'phones' => $phone, 'address' => $address]);
} else {
return json_encode(['sucess' => 0, 'errors' => $this->validation->errors()]);
}
}
