public function password_recovery() { $email = $_POST['username']; if ($email != NULL) { $password = '******'; $mycount = User::check_user_exist($email); if ($mycount > 0) { $account_details = User::get_user_details($email)->toArray(); $access_level = access_level::get_access_level_name($account_details[0]['usertype_id']); $access_level = $access_level['level']; switch ($account_details[0]['usertype_id']) { case 2: $facility_name = facilities::get_facility_name_($account_details[0]['facility']); $user_delegation = "Facility: {$facility_name['facility_name']}"; $user_level = "Facility Level"; break; case 5: $facility_name = facilities::get_facility_name_($account_details[0]['facility']); $user_delegation = "Facility: {$facility_name['facility_name']}"; $user_level = "Facility Level"; break; case 3: $district_name = districts::get_district_name_($account_details[0]['district']); $user_level = "District Level"; $user_delegation = "District: {$district_name['district']}"; break; default: break; } $subject = "Password reset"; $message = 'Hello ' . $account_details[0]['fname'] . 'you requested for a password reset check you email address for more details (HCMP)'; $message_1 = 'Hello ' . $account_details[0]['fname'] . ', <br> <br> You requested for a password reset on the Health Commodities Management Platform (HCMP). <br> <br> Web link: http://health-cmp.or.ke/ <br> <br> Please find your log in credentials below: <br> <br> ' . $user_delegation . ' <br> User Level: ' . $user_level . ' <br> User Type: ' . $access_level . ' <br> User Name: ' . $email . ' <br> Password: '******' <br> <br>'; //hash then reset password $salt = '#*seCrEt!@-*%'; $value = md5($salt . $password); $updatep = Doctrine_Manager::getInstance()->getCurrentConnection(); $updatep->execute("UPDATE user SET password='******' WHERE username='******' or email='{$email}'; "); //send mail $response = $this->send_email($email, $message_1, $subject); $this->send_sms($account_details[0]['telephone'], $message); $data['email'] = $email; $data['popup'] = "Successpopup"; $this->load->view("login_v", $data); } else { $data['popup'] = "errorpopup"; $this->load->view("forgotpassword_v", $data); } } else { $data['popup'] = "errorpopup"; $this->load->view("forgotpassword_v", $data); } }