function selectAppointment()
{
if (!empty($_GET['type']) && !empty($_GET['of'])) {
$type = $_GET['type'];
$of = $_GET['of'];
$do = $type === "confirm" ? 'confirmed' : 'canceled';
$query = " SELECT `id`,`current_user` FROM `appointment` WHERE `id` = '" . $of . "' AND `doctor`= '" . $this->getFirstName() . " " . $this->getLastName() . "'";
$result = $this->getDB()->query($query);
$this->fetchData($this->getSessionUser());
if ($result->num_rows >= 0) {
$row = $result->fetch_assoc();
$user = $row['current_user'];
$tempmem = new Members();
$tempmem->setDB($this->getDB());
$tempmem->fetchData($user);
echo $user;
echo $tempmem->getEmail();
if ($type === 'confirm') {
$query = "UPDATE `appointment` SET `is_approved` = '1' WHERE `id` ='" . $of . "' AND `doctor`='" . $this->getFirstName() . " " . $this->getLastName() . "'";
Members::sendMail($tempmem->getEmail(), "Your appointment has been approvedd");
} else {
$query = "UPDATE `appointment` SET `is_approved` = '0' WHERE `id` ='" . $of . "' AND `doctor`='" . $this->getFirstName() . " " . $this->getLastName() . "'";
Members::sendMail($tempmem->getEmail(), "Your appointment has been canceled");
}
$result = $this->getDB()->query($query);
if ($this->getDB()->affected_rows > 0) {
$msg = "Appointment has been " . $do;
self::setMessage($msg);
} else {
$msg = "You are not allowed to " . $do . " this appointmnet";
self::setMessage($msg);
}
} else {
$msg = "You are not allowed to " . $do . " this appointmnet";
self::setMessage($msg);
}
}
}
foreach ($data as $var => $value) {
if (empty($value)) {
echo $var . " is empty!";
$pass = false;
break;
}
}
if ($pass) {
$dbo = new DBConnection();
$db = $dbo->connect();
$appointment = new Appointment();
$appointment->setDB($db);
$appointment->setPatientUser($data['name']);
$appointment->setDoctor($data['doctor']);
$appointment->setDate($data['date']);
$appointment->setTime($data['time']);
$appointment->setSpeciality($data['speciality']);
$appointment->setAppointmentType($data['appointment']);
$appointment->setHospital($data['hospital']);
$appointment->setMobile($data['phone']);
$appointment->setAge($data['age']);
$appointment->setGender($data['gender']);
$appointment->setCurrentUser($members->getSessionUser());
$appointment->setCurrentAddress($data['address']);
if ($appointment->verification()) {
$appointment->insert();
Members::sendMail($members->getEmail(), "You have booked an appointment , You will be inform soon after Approved by doctor. ThankYou");
echo Appointment::getMessage();
}
}
}
