示例#1
0
 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);
         }
     }
 }
示例#2
0
<?php

include 'src/Members.php';
$members = new Members();
$members->setDB();
$members->redirect();
$members->fetchData($members->getSessionUser());