/**
* Storing new user
* returns user details
*/
public function storePatient($name, $email, $password, $address, $telephone)
{
require_once 'DB_Functions.php';
$dbFunctions = new DB_Functions();
$resultP = mysqli_query($this->mysqli, "INSERT INTO per_all_people_f(name, email, person_type, telephone ) VALUES('{$name}', '{$email}', 'P' , '{$telephone}');");
// check for successful store
if ($resultP) {
// get user details
$personId = mysqli_insert_id($this->mysqli);
// last inserted id
$uuid = uniqid('', true);
$hash = $dbFunctions->hashSSHA($password);
$encrypted_password = $hash["encrypted"];
// encrypted password
$salt = $hash["salt"];
// salt
$resultU = mysqli_query($this->mysqli, "INSERT INTO users(unique_id, name, email, person_id, encrypted_password, salt, created_at) VALUES('{$uuid}', '{$name}', '{$email}', '{$personId}', '{$encrypted_password}', '{$salt}', NOW())");
$resultPatient = mysqli_query($this->mysqli, "INSERT INTO patient(person_id) VALUES('{$personId}')");
$patientId = mysqli_insert_id($this->mysqli);
// last inserted id
$patientIdUpdate = mysqli_query($this->mysqli, "update per_all_people_f set patient_id = {$patientId} where person_id = {$personId}");
$resultAddress = mysqli_query($this->mysqli, "INSERT INTO address(house_no,person_id) VALUES('{$address}','{$personId}')");
$result = mysqli_query($this->mysqli, "SELECT * FROM per_all_people_f WHERE person_id = {$personId}");
if ($resultU && $resultPatient && $resultAddress && $patientIdUpdate) {
return mysqli_fetch_array($result);
} else {
return FALSE;
}
} else {
return false;
}
}
$response["error"] = 2;
$response["error_msg"] = "User does not exist";
echo json_encode($response);
}
} else {
if ($tag == "sync_db") {
$uid = $_POST['uid'];
$points = $db->getPointsByUid($uid);
$response["success"] = 1;
$response["points"] = $points;
echo json_encode($response);
} else {
if ($tag == 'chgpass') {
$email = $_POST['email'];
$newpassword = $_POST['newpas'];
$hash = $db->hashSSHA($newpassword);
$encrypted_password = $hash["encrypted"];
// encrypted password
$salt = $hash["salt"];
$subject = "Change Password Notification";
$message = "Hello Piggy Rewards Customer,\n\nYour Password has been sucessfully changed.\n\nRegards,\\Piggy Rewards Team.";
$from = "*****@*****.**";
$headers = "From: svetvaz@gmail.com";
if ($db->isUserExisted($email)) {
$user = $db->forgotPassword($email, $encrypted_password, $salt);
if ($user) {
$response["success"] = 1;
mail($email, $subject, $message, $headers);
echo json_encode($response);
} else {
$response["error"] = 1;