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 registerAction()
{
$model = new \modules\users\models\Users('register');
$user_phone = new \modules\users\models\User_phones(false);
$user_address = new \modules\users\models\User_addresses(false);
$model->set('usergroup_id', 1);
$model->set('fullname', $this->input->post('fullname'));
$model->set('usergroup_id', $this->input->post('usergroup_id'));
$model->set('email', $this->input->post('email'));
$model->set('gender', $this->input->post('gender'));
$model->set('password', md5($this->input->post('password')));
$model->set('status', 'active');
if ($r = $model->save()) {
foreach ($this->input->post('phone') as $phone) {
$user_phone->set('phone', $phone);
$user_phone->set('user_id', $r);
$user_phone->save();
}
foreach ($this->input->post('address') as $address) {
$user_address->set('address', $address);
$user_address->set('user_id', $r);
$user_address->set('type', 'shipping');
$user_address->save();
}
Uri_helper::redirect("users/thankyou");
} else {
return $this->render('users/register', ['menu' => ['male' => 'Male', 'female' => 'Female']]);
}
}
public function deleteAddressAction($id = null)
{
$this->permission('deleteAddress');
$phone = new \modules\users\models\User_addresses();
$phone->user_address_id = $id;
if ($phone->delete()) {
return TRUE;
} else {
return FALSE;
}
}
