classes.php

<?php
include "connection.php";
class Admin
{
    private $customers = array();

    public function __construct()
    {
        // $this->customers = array();
        $query = "SELECT * FROM customer";
        $result = QueryHandler::query($query);

        if (mysqli_num_rows($result) > 0) {
            while ($row = mysqli_fetch_array($result)) {
                $customer = Customer::getInstance($row['customer_id']);
                array_push( ($this->customers) , ($customer));
            }
        }
   

    }

    public function attach(Customer $customer_object)
    {
        array_push( $customers , $customer_object);
        // array_push($customers, $customerNewDetails);
    }

    public function detach(Customer $customerNewDetails)
    {
        // $this->customers->detach($customerNewDetails);
    }

    public function notify($service_name, $newservice_id)
    {
        foreach ($this->customers as $customer) {
            $customer->AddNewServiceNotification($service_name,($customer->getCustomer_id()), $newservice_id);
            // $customer->sendOffer($this);
        }
    }

    public function sendNotificationALL($service_name , $newservice_id)
    {
        $this->notify($service_name, $newservice_id);
    }

    // public function addNewService($customer_id, $notificationString, $notificationType)
    // {
    //     $conn = (new Connection())->createConnection();
    //     $query = " INSERT INTO notification(notification, receiver_id,sender_id ,notification_type ) VALUES ('$notificationString', '$customer_id',0 , '$notificationType')";
    //     mysqli_query($conn, $query);
    // }
}

class Customer
{
    private $customer_id;
    private $username;
    private $firstname;
    private $lastname;
    private $email;
    private $phone_no;
    private $address;
    private $latitude;
    private $longitude;
    private $password;
    private $is_worker;
    private $img;
    private $total_hirings_count;
    private $total_payment;
    private $registered_date;
    private $tmp_image;
    private static $customers = array();

    private function __construct(){

    }
    
    public function AddNewServiceNotification($service_name,$customer_id, $newservice_id)
    {
        // $conn = (new Connection())->createConnection();
       
        $notificationString= "Admin add new service : " . $service_name;
        $query = " INSERT INTO notification(notification, receiver_id,sender_id ,notification_type, service_id ) VALUES ('$notificationString', '$customer_id',0 , 'addnewservice', '$newservice_id')";
        QueryHandler::query($query);
    }

    public static function getInstance($customer_id):Customer|null
    {
        if (!array_key_exists($customer_id, self::$customers)) {
            $sql = "SELECT `customer_id` FROM `Customer` WHERE customer_id = $customer_id";
            if (QueryHandler::query($sql)->num_rows == 0) {
                return null;
            } else {
                self::$customers[$customer_id] = new Customer();
                self::$customers[$customer_id]->read($customer_id);
            }
        }
        return self::$customers[$customer_id];
    }


    //read from database
    public function read($customer_id)
    {
        //$conn = (new Connection())->createConnection();
        $result = QueryHandler::query("SELECT * from customer WHERE customer_id='$customer_id'");
        $data = mysqli_fetch_assoc($result);
        $this->customer_id= $customer_id;
        $this->username = $data['username'];
        $this->firstname = $data['firstname'];
        $this->lastname = $data['lastname'];
        $this->email = $data['email'];
        $this->phone_no = $data['phone_no'];
        $this->address = $data['address'];
        $this->latitude = $data['latitude'];
        $this->longitude = $data['longitude'];
        $this->password = Password::decrypt($data['password']);
        $this->is_worker = $data['is_worker'];
        $this->img = $data['img'];
        $this->total_hirings_count = $data['total_hirings_count'];
        $this->total_payment = $data['total_payment'];
        $this->registered_date = $data['registered_date'];
    }


    public function sendOffer(Customer $customer){
       $customer_id = $customer->getCustomer_id();

    }
   /**
     * Get the value of customer_id
     */ 
    public function getCustomer_id()
    {
        return $this->customer_id;
    }

    /**
     * Get the value of username
     */ 
    public function getUsername()
    {
        return $this->username;
    }

    /**
     * Set the value of username
     */ 
    public function setUsername($username)
    {
        $this->username = $username;

    }

        /**
     * Get the value of firstname
     */ 
    public function getFirstname()
    {
        return $this->firstname;
    }

    /**
     * Set the value of firstname
     */ 
    public function setFirstname($firstname)
    {
        QueryHandler::query("UPDATE `customer` SET firstname = '".$firstname."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->firstname = $firstname;
    }

        /**
     * Get the value of lastname
     */ 
    public function getLastname()
    {
        return $this->lastname;
    }

    /**
     * Set the value of lastname
     */ 
    public function setLastname($lastname)
    {
        QueryHandler:: query("UPDATE `customer` SET lastname = '".$lastname."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->lastname = $lastname;
    }


        /**
     * Get the value of email
     */ 
    public function getEmail()
    {
        return $this->email;
    }

    /**
     * Set the value of email
     */ 
    public function setEmail($email)
    {
        $this->email = $email;
    }

        /**
     * Get the value of phone_no
     */ 
    public function getPhone_no()
    {
        return $this->phone_no;
    }

    /**
     * Set the value of phone_no
     */ 
    public function setPhone_no($phone_no)
    {
        QueryHandler::query("UPDATE `customer` SET phone_no = '".$phone_no."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->phone_no = $phone_no;

    }

        /**
     * Get the value of address
     */ 
    public function getAddress()
    {
        return $this->address;
    }

    /**
     * Set the value of address
     */ 
    public function setAddress($address)
    {
        QueryHandler::query("UPDATE `customer` SET address = '".QueryHandler::real_escape_string($address)."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->address = $address;
    }


        /**
     * Get the value of latitude
     */ 
    public function getLatitude()
    {
        return $this->latitude;
    }

    /**
     * Set the value of latitude
     */ 
    public function setLatitude($latitude)
    {
        QueryHandler::query("UPDATE `customer` SET latitude = '".$latitude."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->latitude = $latitude;
    }

    
    /**
     * Get the value of longitude
     */ 
    public function getLongitude()
    {
        return $this->longitude;
    }

    /**
     * Set the value of longitude
     */ 
    public function setLongitude($longitude)
    {
        QueryHandler::query("UPDATE `customer` SET longitude = '".$longitude."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->longitude = $longitude;
    }

    
    /**
     * Get the value of password
     */ 
    public function getPassword()
    {
        return $this->password;
    }

    /**
     * Set the value of password
     */ 
    public function setPassword($password)
    {
        $newpassword = Password::encrypt($password);
        QueryHandler::query("UPDATE `customer` SET password = '$newpassword' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->password = $password;
    }


    /**
     * Get the value of is_worker
     */ 
    public function getIs_worker()
    {
        return $this->is_worker;
    }

    /**
     * Set the value of is_worker
     */ 
    public function setIs_worker($is_worker)
    {
        QueryHandler:: query("UPDATE `customer` SET is_worker = '".QueryHandler::real_escape_string($is_worker)."' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->is_worker = $is_worker;
    }

    

    /**
     * Get the value of img
     */ 
    public function getImg()
    {
        if(isset($this->tmp_image)){
            return $this->tmp_image;
        }
        return $this->img;
    }

    /**
     * Set the value of img
     */ 
    public function setImg($img)
    {
        QueryHandler::query("UPDATE `customer` SET img = '$img' WHERE customer_id = '".$this->customer_id."' LIMIT 1");
        $this->img = $img;
    }

    /**
     * Get the value of total_hirings_count
     */ 
    public function getTotal_hirings_count()
    {
        return $this->total_hirings_count;
    }

    /**
     * Set the value of total_hirings_count
     */ 
    public function setTotal_hirings_count($total_hirings_count)
    {
        $this->total_hirings_count = $total_hirings_count;
    }

    
    /**
     * Get the value of total_payment
     */ 
    public function getTotal_payment()
    {
        return $this->total_payment;
    }

    /**
     * Set the value of total_payment
     */ 
    public function setTotal_payment($total_payment)
    {
        $this->total_payment = $total_payment;
    }

    /**
     * Get the value of registered_date
     */ 
    public function getRegistered_date()
    {
        return $this->registered_date;
    }

    /**
     * Set the value of registered_date
     */ 
    public function setRegistered_date($registered_date)
    {
        $this->registered_date = $registered_date;
    }

    public function editProfile($customerNewDetails)
    {
        $error = "";
        $success = array();
        
        if (array_key_exists("img",$customerNewDetails)) {
            rename($customerNewDetails["img"],$this->getImg());
            $success[]= "Profile Picture";
        }

        if ($customerNewDetails["fname"] != $this->getFirstname()) {
            $this->setFirstname($customerNewDetails["fname"]);
            $success[]= "First Name" ;
        }
        if ($customerNewDetails["lname"] != $this->getLastname()) {
            $this->setLastname($customerNewDetails["lname"]);
            $success[]= "Last Name" ;
        }
        if ($customerNewDetails["address"] != $this->getAddress()) {
            $this->setAddress($customerNewDetails["address"]);
            $this->setLongitude($customerNewDetails["lng"]);
            $this->setLatitude($customerNewDetails["lat"]);
            $success[]= "Address" ;
        }

        if ($customerNewDetails["phoneno"] != $this->getPhone_no()) {
            $this->setPhone_no($customerNewDetails["phoneno"]);
            $success[]= "Phone Number" ;
        }

        if ($customerNewDetails["currentpassword"] != "" && $customerNewDetails["newpassword"] != "") {
            if ($customerNewDetails["confirmpassword"] != "") {
                if ($this->getPassword() == $customerNewDetails["currentpassword"]) {
                    if ($customerNewDetails["newpassword"] == $customerNewDetails["confirmpassword"]) {
                        $this->setPassword($customerNewDetails["newpassword"]);
                        $success[]= "Password" ;
                    } else {
                        $error = "New password didn't match with confirm password";
                    }
                } else {
                    $error = "Current password didn't match";
                }
            } else {
                $error = "Confirmation of new password wasn't provided";
            }
        }
        $status = array();
        $status["success"] = $success;
        $status["error"] = $error;
        return $status;
    }

    public function uploadProfilePic($file){
        $id = $this->getCustomer_id();
        $status = File::upload($file,FileType::IMAGE,"Customer/Assets/customerProfilePic/tmp/$id");
        if($status["errorUploadFile"] == ""){
            $this->tmp_image = $status["fileName"];
        }

        return $status["errorUploadFile"];

    }

    public function getTmp_image()
    {
        return $this->tmp_image;
    }

    

    public function logout($location)
    {
        if ($this->getIs_worker() == 1) {
            $tradesman  = Tradesman::getInstance($this->customer_id);
            $tradesman->setState(new TradesmanAsTradesman());
            $tradesman->setActive_status(new Offline());
        }
        session_unset();
        header("Location: $location");
    }

    public function registerAsTradesman($tradesmanDetails){
        $query = "INSERT INTO `tradesman` (`tradesman_id`,`username`,`yrs_of_experience`,`description`) VALUES ('" .
        $this->customer_id. "','" .
        $this->username. "','" .
        $tradesmanDetails["experience"] . "','" .
        $tradesmanDetails["description"] . "'" .
        ")";
        if (QueryHandler::query($query)) {
            foreach ($tradesmanDetails['works'] as $work) {
               $this->addService($work);
            }
            $this->setIs_worker(1);
            header("Location: tradesmanHome.php"); 
        }
    }

    public function addService($provider_name){
        $service = new Service();
        $service->readByPName($provider_name);
        $query = "INSERT INTO `service_of_tradesman` (`tradesman_id`,`service_id`,`service_name`) VALUES ('" .
        $this->customer_id. "','" .
        $service->getService_id(). "','" .
        $service->getService_name(). "'" .
        ")";
        QueryHandler::query($query);

        $service->setTotal_tradesman(($service->getTotal_tradesman()+1));
        return $service->getService_id();
    }

    public function searchService($enteredService)
    {
      $sql = "SELECT `service_id` FROM `service` WHERE service_name = '$enteredService'";
      $result = QueryHandler::query($sql);
      if ($result->num_rows == 1) {
        $row = $result->fetch_assoc();
        return $row["service_id"];
      }
      else {
        return false;
      }
    }
  
    public function searchTradesman($enteredTradesman)
    {
      $sql = "SELECT `tradesman_id` FROM `tradesman` WHERE username = '$enteredTradesman'";
      $result = QueryHandler::query($sql);
      if ($result->num_rows == 1) {
        $row = $result->fetch_assoc();
        return $row["tradesman_id"];
      }
      else {
        return false;
      }
    }
  
    public function search($enteredST)
    {
      if (($service_id = $this->searchService($enteredST))) {
        Header("Location: service.php?id=$service_id");
      }
      else if (($tradesman_id = $this->searchTradesman($enteredST))) {
        Header("Location: tradesmanProfile.php?id=$tradesman_id");
      }
      return false;
    }

    public function findNearTradesmanHireNow($lat1, $lng1, $service_id){
        $distanceArr = array();
        //$tradesman_lat_lng = "SELECT latitude,longitude,customer_id FROM customer  WHERE customer_id !=' $this->customer_id'";
        //$tradesman_lat_lng2 = "SELECT customer.latitude, customer.longitude, customer.customer_id FROM customer,tradesman,service_of_tradesman WHERE tradesman.tradesman_id !=' $this->customer_id' AND service_of_tradesman.service_id='$service_id' AND tradesman.active_status='online'";
        
        $query_service = "SELECT tradesman_id FROM service_of_tradesman  WHERE service_id =' $service_id'";
        $query_service_result = QueryHandler::query($query_service);
        if (mysqli_num_rows($query_service_result) > 0) {
            while ($row1 = mysqli_fetch_assoc($query_service_result)) {
                $tradesmanID = $row1['tradesman_id'];
                $tradesman_query = "SELECT tradesman_id FROM tradesman  WHERE tradesman_id = '$tradesmanID' AND active_status ='online'";
                $tradesman_result =  QueryHandler::query($tradesman_query) ;
                //echo "<script>console.log($tradesmanID)</script>";
                if (mysqli_num_rows($tradesman_result) > 0) {
                    while ($row2 = mysqli_fetch_assoc($tradesman_result)) {
                        $tradesmanID2 = $row2['tradesman_id'];
                        
                        $tradesman_lat_lng = "SELECT latitude,longitude,customer_id FROM customer  WHERE customer_id ='$tradesmanID2' AND customer_id !=' $this->customer_id'";
                        $lat_lng_result = QueryHandler::query($tradesman_lat_lng );
    
                        if (mysqli_num_rows($lat_lng_result) > 0) {
                            while ($row1 = mysqli_fetch_assoc($lat_lng_result)) {
                                $lat2 = $row1['latitude'];
                                $lng2 = $row1['longitude'];
                                $tradesman_id = $row1['customer_id'];
                                // echo "<script>let x{$tradesman_id};</script>";  
                                // $temp='';
                                // echo "<script>x{$tradesman_id}=(getDistanceFromLatlngInKm($lat1,$lng1,$lat2,$lng2));</script>";             
                                // $temp = "<script>document.writeln(x{$tradesman_id})</script>";
                                // echo "<script>alert({$temp})</script>";
                
                                $delta_lat = $lat2 - $lat1 ;
                                $delta_lon = $lng2 - $lng1;
                      
                                $earth_radius = 6372.795477598;
                      
                                $alpha    = $delta_lat/2;
                                $beta     = $delta_lon/2;
                                $a        = sin(deg2rad($alpha)) * sin(deg2rad($alpha)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * sin(deg2rad($beta)) * sin(deg2rad($beta)) ;
                                $c        = asin(min(1, sqrt($a)));
                                $distance = 2*$earth_radius * $c;
                                $distance = round($distance, 4);
                
                                $distanceArr[$tradesman_id] = $distance;
                
                                
                            }
                        }
                    }
                }
            }
        }
    
    
        $js = json_encode($distanceArr);
        echo "<script>console.log($js)</script>";
        asort($distanceArr);
        //echo "<script>let x = initMap2()</script>";
        return $distanceArr;
    }
    
    
    public function findNearTradesmanHireSchedule($lat1, $lng1, $service_id){
        $distanceArr = array();
        //$tradesman_lat_lng = "SELECT latitude,longitude,customer_id FROM customer  WHERE customer_id !=' $this->customer_id'";
        //$tradesman_lat_lng2 = "SELECT customer.latitude, customer.longitude, customer.customer_id FROM customer,tradesman,service_of_tradesman WHERE tradesman.tradesman_id !=' $this->customer_id' AND service_of_tradesman.service_id='$service_id'";
        
        $query_service = "SELECT tradesman_id FROM service_of_tradesman  WHERE service_id =' $service_id'";
        $query_service_result = QueryHandler::query($query_service);
        if (mysqli_num_rows($query_service_result) > 0) {
            while ($row1 = mysqli_fetch_assoc($query_service_result)) {
                $tradesmanID = $row1['tradesman_id'];
                $tradesman_query = "SELECT tradesman_id FROM tradesman  WHERE tradesman_id = '$tradesmanID' ";
                $tradesman_result = QueryHandler::query($tradesman_query) ;
    
                if (mysqli_num_rows($tradesman_result) > 0) {
                    while ($row2 = mysqli_fetch_assoc($tradesman_result)) {
                        $tradesmanID2 = $row2['tradesman_id'];
                        
                        $tradesman_lat_lng = "SELECT latitude,longitude,customer_id FROM customer  WHERE customer_id ='$tradesmanID2' AND customer_id !=' $this->customer_id'";
                        $lat_lng_result = QueryHandler::query($tradesman_lat_lng );
    
                        if (mysqli_num_rows($lat_lng_result) > 0) {
                            while ($row1 = mysqli_fetch_assoc($lat_lng_result)) {
                                $lat2 = $row1['latitude'];
                                $lng2 = $row1['longitude'];
                                $tradesman_id = $row1['customer_id'];
                
                                $delta_lat = $lat2 - $lat1 ;
                                $delta_lon = $lng2 - $lng1;
                      
                                $earth_radius = 6372.795477598;
                      
                                $alpha    = $delta_lat/2;
                                $beta     = $delta_lon/2;
                                $a        = sin(deg2rad($alpha)) * sin(deg2rad($alpha)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * sin(deg2rad($beta)) * sin(deg2rad($beta)) ;
                                $c        = asin(min(1, sqrt($a)));
                                $distance = 2*$earth_radius * $c;
                                $distance = round($distance, 4);
                
                                $distanceArr[$tradesman_id] = $distance;
                
                                
                            }
                        }
                    }
                }
            }
        }
    
    
        $js = json_encode($distanceArr);
        echo "<script>console.log($js)</script>";
        asort($distanceArr);
        return $distanceArr;
    }
}

class Tradesman extends Customer
{
    private $tradesman_id;
    private $yrs_of_experience;
    private $description;
    private $active_status;
    private $num_of_review;
    private $num_of_ratings;
    private $average_rating;
    private $total_earnings;
    private $num_of_hirings;
    private $reg_date_as_tradesman;
    private $state;
    private $services;
    private static $tradesmans = array();
    private $hiring_list;

    private function __construct(){

    }
    public static function getInstance($tradesman_id):Tradesman|null
    {
        if (!array_key_exists($tradesman_id, self::$tradesmans)) {
            $sql = "SELECT `tradesman_id` FROM `tradesman` WHERE tradesman_id = $tradesman_id";
            if (QueryHandler::query($sql)->num_rows == 0) {
                return null;
            } else {
                self::$tradesmans[$tradesman_id] = new Tradesman();
                self::$tradesmans[$tradesman_id]->read($tradesman_id);
            }
        }
        return self::$tradesmans[$tradesman_id];
    }

    public function read($tradesman_id)
    {
        parent::read($tradesman_id);
        $this->tradesman_id = $tradesman_id;
        $result = QueryHandler::query("SELECT * from tradesman WHERE tradesman_id='$tradesman_id'");
        $row = mysqli_fetch_assoc($result);
        $this->yrs_of_experience =  $row['yrs_of_experience'];
        $this->description = $row['description'];
        $this->num_of_review = $row['num_of_reviews'];
        $this->average_rating = $row['average_rating'];
        $this->num_of_ratings = $row['num_of_ratings'];
        $this->total_earnings = $row['total_earnings'];
        $this->num_of_hirings = $row['num_of_hirings'];
        $this->reg_date_as_tradesman = $row['reg_date_as_tradesman'];

        if($row['state']== "TAT"){
            $this->state = new TradesmanAsTradesman();
        }else{
            $this->state = new TradesmanAsCustomer();
        }

        if($row['active_status']== "ONLINE"){
            $this->active_status = new Online();
        }else{
            $this->active_status = new Offline();
        }

        $query = "SELECT `service_id` FROM `service_of_tradesman` WHERE tradesman_id = $tradesman_id";
        $result = QueryHandler::query($query);
        $rows = $result->fetch_all(MYSQLI_ASSOC);
        foreach ($rows as $row) {
            //$service = new Service();
            //$service->read($row['service_id']);
            $this->services[]=$row['service_id'];
        }
    }

    public function checkHiringTimeCome($tradesman_id)
    {
        
        echo "Tradesman ID is : " . $tradesman_id . " <br>";
        $result = QueryHandler::query("SELECT * from hiring WHERE tradesman_id='$tradesman_id'");
        while ($row = mysqli_fetch_assoc($result)) {
            $html = '';
            if (($row['date'] != NULL) && ($row['date'] == date("Y-m-d"))) {
                $timeNow = date("H:i:s");
                $timeNow = strtotime("+270 minutes", strtotime($timeNow));
                $timeNow = date("H:i:s", ($timeNow));
                echo  $timeNow . "  ";
                $timeHiring = $row['time'];

                $timeHiring = date("H:i:s", strtotime($timeHiring));
                echo  $timeHiring . "  ";
                $hiringNotifyStart = strtotime("-60 minutes", strtotime($timeHiring));
                $hiringNotifyStart = date("H:i:s", ($hiringNotifyStart));
                echo $hiringNotifyStart . "  <br>";

                echo $row['date'];
                echo "<br>";
                echo "today....";
                if (($timeNow < $timeHiring) && ($hiringNotifyStart < $timeNow)) {
                    echo "you have an shedule within some time";
                }
            }
        }
        return $html;
    }

    /**
     * Get the value of tradesman_id
     */ 
    public function getTradesman_id()
    {
        return $this->tradesman_id;
    }



    /**
     * Get the value of yrs_of_experience
     */ 
    public function getYrs_of_experience()
    {
        return $this->yrs_of_experience;
    }

    /**
     * Set the value of yrs_of_experience
     */ 
    public function setYrs_of_experience($yrs_of_experience)
    {
        $this->yrs_of_experience = $yrs_of_experience;
    }

    /**
     * Get the value of description
     */ 
    public function getDescription()
    {
        return $this->description;
    }

    /**
     * Set the value of description
     */ 
    public function setDescription($description)
    {
        QueryHandler::query("UPDATE `tradesman` SET description = '$description' WHERE tradesman_id = '".$this->tradesman_id."' LIMIT 1");
        $this->description = $description;
    }

    /**
     * Get the value of active_status
     */ 
    public function getActive_status()
    {
        return $this->active_status;
    }

    /**
     * Set the value of active_status
     */ 
    public function setActive_status($active_status)
    {
        $stateType = $active_status->getACTIVE_STATUS();
        QueryHandler::query("UPDATE `tradesman` SET active_status = '$stateType' WHERE tradesman_id = '".$this->tradesman_id."' LIMIT 1");
        $this->active_status = $active_status;
    }

    /**
     * Get the value of num_of_review
     */ 
    public function getNum_of_review()
    {
        return $this->num_of_review;
    }

    /**
     * Set the value of num_of_review
     */ 
    public function setNum_of_review($num_of_review)
    {
        $this->num_of_review = $num_of_review;
    }

    /**
     * Get the value of num_of_ratings
     */ 
    public function getNum_of_ratings()
    {
        return $this->num_of_ratings;
    }

    /**
     * Set the value of num_of_ratings
     */ 
    public function setNum_of_ratings($num_of_ratings)
    {
        $this->num_of_ratings = $num_of_ratings;
    }

    /**
     * Get the value of average_rating
     */ 
    public function getAverage_rating()
    {
        return $this->average_rating;
    }

    /**
     * Set the value of average_rating
     */ 
    public function setAverage_rating($average_rating)
    {
        $this->average_rating = $average_rating;
    }

    /**
     * Get the value of total_earnings
     */ 
    public function getTotal_earnings()
    {
        return $this->total_earnings;
    }

    /**
     * Set the value of total_earnings
     */ 
    public function setTotal_earnings($total_earnings)
    {
        $this->total_earnings = $total_earnings;
    }

    /**
     * Get the value of num_of_hirings
     */ 
    public function getNum_of_hirings()
    {
        return $this->num_of_hirings;
    }

    /**
     * Set the value of num_of_hirings
     */ 
    public function setNum_of_hirings($num_of_hirings)
    {
        $this->num_of_hirings = $num_of_hirings;
    }

    /**
     * Get the value of reg_date_as_tradesman
     */ 
    public function getReg_date_as_tradesman()
    {
        return $this->reg_date_as_tradesman;
    }

    public function editProfile($customerNewDetails)
    {
        $status = parent::editProfile($customerNewDetails);
        if ($customerNewDetails["description"] != $this->getDescription()) {
            $this->setDescription($customerNewDetails["description"]);
            $status["success"][]= "Description" ;
        }

        foreach ($customerNewDetails['works'] as $work) {
            $this->addService($work);
        }

        foreach ($this->services as $service_id) {
            $service = new Service();
            $service->read($service_id);
            if (!in_array($service->getProvider_name(),$customerNewDetails['works'])) {
                $this->removeService($service->getProvider_name());
            }
            
        }
        return $status;

    }

    public function addService($provider_name){
        $service = new Service();
        $service->readByPName($provider_name);
        if (!in_array($service->getService_id(),$this->services)) {
            $this->services[]=parent::addService($provider_name);
        }
    }

    public function removeService($provider_name){
        $service = new Service();
        $service->readByPName($provider_name);
        if (in_array($service->getService_id(),$this->services)) {
            $id= $service->getService_id();
            $query = "DELETE FROM `service_of_tradesman` WHERE tradesman_id = $this->tradesman_id AND service_id = $id";
            QueryHandler::query($query);
            unset($this->services[array_search($id,$this->services)]);
            $service->setTotal_tradesman(($service->getTotal_tradesman()-1));
        }
        
    }

    public function switch(){
        $this->state->switch($this);
    }

    public function toggle(){
        $this->active_status->toggle($this);
    }

    public function getState()
    {
        return $this->state;
    }


    
    public function setState($state)
    {
        $stateType = $state->getSTATE();
        QueryHandler::query("UPDATE `tradesman` SET state = '$stateType' WHERE tradesman_id = '".$this->tradesman_id."' LIMIT 1");
        $this->state = $state;
    }    

    public function isOnline(){
        return $this->active_status instanceof Online;
    }

    public function login(){
        $this->setActive_status(new Online());
      
    }

    public function hasService($service_id){
        // foreach ($this->services as $service) {
        //     if ($service->getProvider_name() == $provider_name) {
        //         return true;
        //     }
        // }
        // return false;

        return in_array($service_id,$this->services);

    }

}

abstract class TradesmanState{
    private $STATE;
    public function __construct($STATE)
    {
        $this->STATE = $STATE;
    }
   
    public function getSTATE()
    {
        return $this->STATE;
    }
    
    public abstract function switch($tradesman);
}

class TradesmanAsTradesman extends TradesmanState{

    public function __construct()
    {
        parent::__construct("TAT");
    }
    
    public function switch($tradesman){
        $tradesman->setState(new TradesmanAsCustomer());
    }



}

class TradesmanAsCustomer extends TradesmanState{
    public function __construct()
    {
        parent::__construct("TAC");
    }

    public function switch($tradesman){
        $tradesman->setState(new TradesmanAsTradesman());
    }


}

abstract class ActiveStatus{
    private $ACTIVE_STATUS;
    public function __construct($ACTIVE_STATUS)
    {
        $this->ACTIVE_STATUS = $ACTIVE_STATUS;
    }
   
    public function getACTIVE_STATUS()
    {
        return $this->ACTIVE_STATUS;
    }
    
    public abstract function toggle($tradesman);
}

class Online extends ActiveStatus{

    public function __construct()
    {
        parent::__construct("ONLINE");
    }
    
    public function toggle($tradesman){
        $tradesman->setActive_status(new Offline());
    }



}

class Offline extends ActiveStatus{
    public function __construct()
    {
        parent::__construct("OFFLINE");
    }

    public function toggle($tradesman){
        $tradesman->setActive_status(new Online());
    }


}


class Hiring{
    private $hiring_id;
    private $tradesman_id;
    private $service_id;
    private $customer_id;
    private $registered_dateTime;
    private $completed_cancelled_date;
    private $hiring_amount;
    private $payment_method;
    private $rating;
    private $review;
    private $final_status;
    private $current_status;
    private $latitude;
    private $longitude;
    private $address;
    private $chatlist;  
    private $current;
    private $date;
    private $time; 

    public function __construct()
    {
        
    }
    
    
    public function read($hiring_id){
        $this->chatlist = array();
        $result = QueryHandler::query("SELECT * from hiring WHERE hiring_id='$hiring_id'");
        $data = mysqli_fetch_assoc($result);
       
        $this->hiring_id = $hiring_id;
        $this->tradesman_id = $data['tradesman_id'];
        $this->service_id = $data['service_id'];
        $this->customer_id = $data['customer_id'];
        $this->registered_dateTime = $data['registered_dateTime'];
        $this->completed_cancelled_date = $data['completed_cancelled_date'];
        $this->hiring_amount = $data['hiring_amount'];
        $this->payment_method = $data['payment_method'];
        $this->rating = $data['rating'];
        $this->review = $data['review'];
        $this->final_status = $data['final_status'];
        $this->current_status = $data['current_status'];
        $this->latitude = $data['latitude'];
        $this->longitude = $data['longitude'];
        $this->address = $data['address'];

    }

    
    /**
     * Get the value of time
     */ 
    public function getTime()
    {
        return $this->time;
    }

    
  /**
     * Get the value of date
     */ 
    public function getDate()
    {
        return $this->date;
    }
    public function getChatlist()
    {
        return $this->chatlist;
    }

    /**
     * Set the value of chatlist
     *
     * @return  self
     */ 
    public function setChatlist($chatlist)
    {
        $this->chatlist = $chatlist;

        return $this;
    }
    /**
     * Get the value of hiring_id
     */ 
    public function getHiring_id()
    {
      return $this->hiring_id;
    }
  
    /**
     * Get the value of tradesman_id
     */ 
    public function getTradesman_id()
    {
      return $this->tradesman_id;
    }
  
    /**
     * Get the value of service_id
     */ 
    public function getService_id()
    {
      return $this->service_id;
    }
  
    /**
     * Get the value of customer_id
     */ 
    public function getCustomer_id()
    {
      return $this->customer_id;
    }
  
    /**
     * Get the value of registered_dateTime
     */ 
    public function getRegistered_dateTime()
    {
      return $this->registered_dateTime;
    }
  
    /**
     * Get the value of completed_cancelled_date
     */ 
    public function getCompleted_cancelled_date()
    {
      return $this->completed_cancelled_date;
    }
  
    /**
     * Get the value of hiring_amount
     */ 
    public function getHiring_amount()
    {
      return $this->hiring_amount;
    }
  
    /**
     * Get the value of payment_method
     */ 
    public function getPayment_method()
    {
      return $this->payment_method;
    }
  
    /**
     * Get the value of rating
     */ 
    public function getRating()
    {
      return $this->rating;
    }
  
    /**
     * Get the value of review
     */ 
    public function getReview()
    {
      return $this->review;
    }
  
    /**
     * Get the value of final_status
     */ 
    public function getFinal_status()
    {
      return $this->final_status;
    }
  
    /**
     * Get the value of current_status
     */ 
    public function getCurrent_status()
    {
      return $this->current_status;
    }
  
    /**
     * Get the value of latitude
     */ 
    public function getLatitude()
    {
      return $this->latitude;
    }
  
    /**
     * Get the value of longitude
     */ 
    public function getLongitude()
    {
      return $this->longitude;
    }
  
    /**
     * Get the value of address
     */ 
    public function getAddress()
    {
      return $this->address;
    }

    //----------   get other class details   -------------------

  public function getProvider_name($service_id)
  {
      $sql = "SELECT * FROM service WHERE service_id = '$service_id'";
      $result_service = QueryHandler::query($sql);




      if (mysqli_num_rows($result_service) > 0) {
          $row = mysqli_fetch_assoc($result_service);

          $provider_name = $row["provider_name"];
      }
      return $provider_name;
  }

  public function getService_name($service_id)
  {
      $sql = "SELECT * FROM service WHERE service_id = '$service_id'";
      $result_service = QueryHandler::query($sql);




      if (mysqli_num_rows($result_service) > 0) {
          $row = mysqli_fetch_assoc($result_service);

          $service_name = $row["service_name"];
      }
      return $service_name;
  }

  
  

  


  



  //---------------------    setters    --------------------------
    /**
     * Set the value of completed_cancelled_date
     */ 
    public function setCompleted_cancelled_date($completed_cancelled_date)
    {
      $this->completed_cancelled_date = $completed_cancelled_date;
    }
  
    /**
     * Set the value of hiring_amount
     */ 
    public function setHiring_amount($hiring_amount)
    {
      $this->hiring_amount = $hiring_amount;
    }
  
    /**
     * Set the value of payment_method
     */ 
    public function setPayment_method($payment_method)
    {
      $this->payment_method = $payment_method;
    }
  
    /**
     * Set the value of rating
     */ 
    public function setRating($rating)
    {
      $this->rating = $rating;
    }
  
    /**
     * Set the value of review
     */ 
    public function setReview($review)
    {
      $this->review = $review;
    }
  
    /**
     * Set the value of final_status
     */ 
    public function setFinal_status($final_status)
    {
      $this->final_status = $final_status;
    }
  
    /**
     * Set the value of current_status
     */ 
    public function setCurrent_status()
    {
        if($this->getCurrent_status() == ""){
            $this->current = new On_the_way();
        }
        else if($this->getCurrent_status() == "On the way"){
            $this->current = new On_the_way();
        }
        else if($this->getCurrent_status() == "Reached"){
            $this->current = new Reached();
        }
        else if($this->getCurrent_status() == "On work"){
            $this->current = new On_work();
        }
        else if($this->getCurrent_status() == "Payment added"){
            $this->current = new Payment_added();
        }
        else if($this->getCurrent_status() == "Paid"){
            $this->current = new Paid();
        }

      $this->current_status = $this->current->setState();

    }
    public function setCurrent(State $state)
    {
      $this->current = $state;
      $this->current_status = $this->current->setState();

    }
  
    /**
     * Set the value of latitude
     */ 
    public function setLatitude($latitude)
    {
      $this->latitude = $latitude;
    }
  
    /**
     * Set the value of longitude
     */ 
    public function setLongitude($longitude)
    {
      $this->longitude = $longitude;
    }
  
    /**
     * Set the value of address
     */ 
    public function setAddress($address)
    {
      $this->address = $address;
    }


    //---------------------------------------state---------------------
    public function changeState(){
        $this->current->changeState($this);
    }

    public function cancelHiring(){
        $this->current->cancelHiring($this);
    }
  }



class Service{
    private $service_id;
    private $service_name;
    private $provider_name;
    private $total_tradesman;
    private $total_hirings;
    private $average_rating;
    private $cover_photo;

    
    public function read($service_id)
    {
        
        $result =QueryHandler::query("SELECT * from service WHERE service_id='$service_id'");
        $data = mysqli_fetch_assoc($result);
        $this->service_id = $service_id;
        $this->service_name = $data['service_name'];
        $this->provider_name = $data['provider_name'];
        $this->total_tradesman = $data['total_tradesman'];
        $this->total_hirings = $data['total_hirings'];
        $this->average_rating = $data['average_rating'];
        $this->cover_photo = $data['cover_photo'];
        
    }

    public function readByPName($provider_name)
    {
        $result = QueryHandler::query("SELECT * from service WHERE provider_name='$provider_name'");
        $data = mysqli_fetch_assoc($result);
        $this->provider_name = $provider_name;
        $this->service_id = $data['service_id'];
        $this->service_name = $data['service_name'];
        $this->total_tradesman = $data['total_tradesman'];
        $this->total_hirings = $data['total_hirings'];
        $this->average_rating = $data['average_rating'];
        $this->cover_photo = $data['cover_photo'];
        
    }


    /**
     * Get the value of provider_name
     */ 
    public function getProvider_name()
    {
        return $this->provider_name;
    }

    /**
     * Get the value of service_name
     */ 
    public function getService_name()
    {
        return $this->service_name;
    }

    /**
     * Get the value of service_id
     */ 
    public function getService_id()
    {
        return $this->service_id;
    }

    /**
     * Get the value of total_tradesman
     */ 
    public function getTotal_tradesman()
    {
        return $this->total_tradesman;
    }

    /**
     * Get the value of totoal_hirings
     */ 
    public function getTotal_hirings()
    {
        return $this->total_hirings;
    }

    /**
     * Get the value of average_rating
     */ 
    public function getAverage_rating()
    {
        return $this->average_rating;
    }

    /**
     * Get the value of cover_photo
     */ 
    public function getCover_photo()
    {
        return $this->cover_photo;
    }

    /**
     * Set the value of service_id
     *
     * @return  self
     */ 
    public function setService_id($service_id)
    {
        $this->service_id = $service_id;

        return $this;
    }

    /**
     * Set the value of service_name
     *
     * @return  self
     */ 
    public function setService_name($service_name)
    {
        $this->service_name = $service_name;

        return $this;
    }

    /**
     * Set the value of provider_name
     *
     * @return  self
     */ 
    public function setProvider_name($provider_name)
    {
        $this->provider_name = $provider_name;

        return $this;
    }

    /**
     * Set the value of total_tradesman
     *
     * @return  self
     */ 
    public function setTotal_tradesman($total_tradesman)
    {
        QueryHandler::query("UPDATE `service` SET total_tradesman = '".$total_tradesman."' WHERE service_id = '".$this->service_id."' LIMIT 1");
        $this->total_tradesman = $total_tradesman;

        return $this;
    }

    /**
     * Set the value of totoal_hirings
     *
     * @return  self
     */ 
    public function setTotal_hirings($total_hirings)
    {
        $this->total_hirings = $total_hirings;

        return $this;
    }

    /**
     * Set the value of average_rating
     *
     * @return  self
     */ 
    public function setAverage_rating($average_rating)
    {
        $this->average_rating = $average_rating;

        return $this;
    }

    /**
     * Set the value of cover_photo
     *
     * @return  self
     */ 
    public function setCover_photo($cover_photo)
    {
        $this->cover_photo = $cover_photo;

        return $this;
    }
}


class Chat
{
    private $message;
    private $hiring_id;
    private  $date_time;
    private $sender;
    private $receiver;

    function __construct($message, $hiring_id, $date_time, $sender, $receiver)
    {
        $this->message = $message;
        $this->hiring_id = $hiring_id;
        $this->date_time = $date_time;
        $this->sender = $sender;
        $this->receiver = $receiver;
    }
    public function getMessage()
    {
        return $this->message;
    }
    public function getHiring_id()
    {
        return $this->hiring_id;
    }
    public function getDate_time()
    {
        return $this->date_time;
    }
    public function getSender()
    {
        return $this->sender;
    }
    public function getReceiver()
    {
        return $this->receiver;
    }
}

class Password
  {
      private string $key;
  
      public function getKey(): string
      {
          return $this->key;
      }
  
      public function setKey(string $key)
      {
          $this->key = $key;
      }
  
      public static function encrypt(string $decryptedText): string
      {
          $encryptedText = "";
          $chars = str_split($decryptedText);
          foreach ($chars as $char) {
              $encryptedChar = (ord( $char)+ 5)."$" ;
              $encryptedText.= $encryptedChar;
          }
          return $encryptedText;
      }
  
      public static function decrypt(string $encryptedText): string
      {
          $decryptedText = "";
          $ords = explode("$",trim($encryptedText,'$'));
          foreach ($ords as $ord) {
              $decryptedChar = chr((int)$ord-5);
              $decryptedText.= $decryptedChar;
          }
          return $decryptedText;
      }
  }

  class UserType{
      const CUSTOMER = 0;
      const TRADESMAN = 1;
  }

  class FileType
{
    public const IMAGE = array("jpg", "jpeg", "png");
    public const VIEW_PRINT = array("pdf"); 
}

class File
{
    public static int $allowedMaxSize = 16777216;

    public static function upload(array $file, array $fileType, String $into){
        $statusOfUpload = array();
        $errors = "";
        $newFileName = "";

        $fileExt = strtolower(explode('.',$file['name'])[1]);
        if(count($fileType) !=0 && in_array($fileExt, $fileType)=== false){
            $errors .= "This extension isn't allowed.";
        }
        
        if($file['size'] > self::$allowedMaxSize) {
            $errors .='File size must be less than or equal to '.
            (self::$allowedMaxSize/(1024*1024)).' MB.';
        }
        
        if(empty($errors)==true) {
            $newFileName = "$into.$fileExt";
            move_uploaded_file($file['tmp_name'],$newFileName);
        }
        $statusOfUpload["errorUploadFile"] = $errors;
        $statusOfUpload["fileName"] = $newFileName;
        return $statusOfUpload;
    }
}

class SignUpper{
    private $tmp_image;
    private $default_image;

    public function __construct()
    {
        $this->default_image= "Customer/Assets/customerProfilePic/default.png";
    }

    public function getImg()
    {
        if(isset($this->tmp_image)){
            return $this->tmp_image;
        }
        return $this->default_image;
    }

    public function uploadProfilePic($file){
        $id = (((QueryHandler::query("SELECT MAX(`customer_id`) AS `id` FROM `customer`"))->fetch_assoc())["id"])+ 1;
        $status = File::upload($file,FileType::IMAGE,"Customer/Assets/customerProfilePic/tmp/$id");
        if($status["errorUploadFile"] == ""){
            $this->tmp_image = $status["fileName"];
        }

        return $status["errorUploadFile"];

    }

    public function register($data){
        $error="";
        if ($result = QueryHandler::query("SELECT `customer_id` FROM `customer` WHERE username = '" . $data["username"] . "' OR email = '" . $data["email"] . "'")) {
            if ($result->num_rows == 0) {
                if ($data["password"] == $data["confirmpassword"]) {
                    $query = "INSERT INTO `customer` (`username`,`firstname`,`lastname`,`email`,`phone_no`,`address`,`longitude`,`latitude`,`password`) VALUES ('" .
                        $data["username"] . "','" .
                        $data["fname"] . "','" .
                        $data["lname"] . "','" .
                        $data["email"] . "','" .
                        $data["phoneno"] . "','" .
                        $data["address"] . "','" .
                        $data["lng"] . "','" .
                        $data["lat"] . "','" .
                        Password::encrypt($data["password"]) . "'" .
                        ")";
                    if (QueryHandler::query($query)) {
                        $id = QueryHandler::$insert_id; 
                        $fileExt = strtolower(explode('.',$data["img"])[1]);
                        $newFile = "Customer/Assets/customerProfilePic/$id.$fileExt" ; 
                        if ($data["img"]!= $this->default_image) {
                            rename($data["img"],$newFile);
                        }else{
                            copy($data["img"],$newFile);
                        }
                        QueryHandler::query("UPDATE `customer` SET img = '$newFile' WHERE customer_id = '".$id."' LIMIT 1");
                        $_SESSION["customer_id"]=$id;
                        header("Location: customerHome.php?Home=");
                    }
                } else {
                    $error = "Password doesn't match with confirm password";
                }
            } else {
                $error = "Username or Email already exist";
            }
        } else {
            $error = "Something went wrong.Try again";
        }
        return $error;
    }
}

class Service_of_tradesman{
    private $st_id;
    private $tradesman_id;
    private $service_id;
    private $service_name;
    private $average_rating;
    private $total_hirings;
    private $total_earnings;
    
    public function read($st_id)
    {
        
        $result = QueryHandler::query("SELECT * from service_of_tradesman WHERE st_id='$st_id'");
        $data = mysqli_fetch_assoc($result);
        $this->st_id = $st_id;
        $this->tradesman_id = $data['tradesman_id'];
        $this->service_id = $data['service_id'];
        $this->service_name = $data['service_name'];
        $this->average_rating = $data['average_rating'];
        $this->total_hirings = $data['total_hirings'];
        $this->total_earnings = $data['total_earnings'];
        
    }


    /**
     * Get the value of st_id
     */ 
    public function getSt_id()
    {
        return $this->st_id;
    }

    /**
     * Get the value of tradesman_id
     */ 
    public function getTradesman_id()
    {
        return $this->tradesman_id;
    }

    /**
     * Get the value of service_id
     */ 
    public function getService_id()
    {
        return $this->service_id;
    }

    /**
     * Get the value of service_name
     */ 
    public function getService_name()
    {
        return $this->service_name;
    }

    /**
     * Get the value of average_rating
     */ 
    public function getAverage_rating()
    {
        return $this->average_rating;
    }

    /**
     * Get the value of total_hirings
     */ 
    public function getTotal_hirings()
    {
        return $this->total_hirings;
    }

    /**
     * Get the value of total_earnings
     */ 
    public function getTotal_earnings()
    {
        return $this->total_earnings;
    }

}

//----------------------------------------state----------------------------------------------------------------------------------------------
abstract class State{
    abstract public function changeState(Hiring $hiring);
    abstract public function setState();
    abstract public function cancelHiring(Hiring $hiring);
}
class On_the_way extends State{
    public function setState(){
        return "On the way";
    }
    public function changeState(Hiring $hiring){
        $hiring->setCurrent(new Reached());
    }
    public function cancelHiring(Hiring $hiring){
        $hiring->setCurrent(new Cancelled());

    }
}
class Reached extends State{
    public function setState(){
        return "Reached";
    }
    public function changeState(Hiring $hiring){
        $hiring->setCurrent(new On_work());

    }
    public function cancelHiring(Hiring $hiring){
        $hiring->setCurrent(new Cancelled());

    }
}
class On_work extends State{
    public function setState(){
        return "On work";
    }
    public function changeState(Hiring $hiring){
        $hiring->setCurrent(new Payment_added());

    }
    public function cancelHiring(Hiring $hiring){
        //$hiring->setCurrent(new Cancelled());

    }
}
class Payment_added extends State{
    public function setState(){
        return "Payment added";
    }
    public function changeState(Hiring $hiring){
        $hiring->setCurrent(new Paid());

    }
    public function cancelHiring(Hiring $hiring){
        //$hiring->setCurrent(new Cancelled());

    }
}
class Paid extends State{
    public function setState(){
        return "Paid";
    }
    public function changeState(Hiring $hiring){
        $hiring->setCurrent(new Completed());

    }
    public function cancelHiring(Hiring $hiring){
        //$hiring->setCurrent(new Cancelled());

    }
}
class Completed extends State{
    public function setState(){
        return "Completed";
    }
    public function changeState(Hiring $hiring){
        //$hiring->setCurrent(new Reached());

    }
    public function cancelHiring(Hiring $hiring){
        //$hiring->setCurrent(new Cancelled());

    }
}
class Cancelled extends State{
    public function setState(){
        return "Cancelled";
    }
    public function changeState(Hiring $hiring){
        //$hiring->setCurrent(new Reached());

    }
    public function cancelHiring(Hiring $hiring){
        //$hiring->setCurrent(new Cancelled());

    }
}







//------------------------------------------------Strategy-----------------------------------------------------------------
class Payment
{
    private $paymentStrategy;

    public function __construct()
    {

    }

    public function setStrategy($paymentStrategy)
    {
        $this->paymentStrategy = $paymentStrategy;
    }

    public function pay($amount)
    {
        return $this->paymentStrategy->pay($amount);
    }
}

interface PaymentStrategy
{
	public function pay($amount);
}

class OnlinePaymentStrategy implements PaymentStrategy
{
	private $name;
	private $cardNumber;
	private $cvv;
	private $dateOfExpiry;
	
    public function __construct($name, $cardNumber, $cvv, $dateOfExpiry)
    {
        $this->name = $name;
        $this->cardNumber = $cardNumber;
        $this->cvv = $cvv;
        $this->dateOfExpiry = $dateOfExpiry;
    }
	
	public function pay($amount)
    {
        
	}

}

class DirectCashPaymentStrategy implements PaymentStrategy
{
	
    public function __construct()
    {
       
    }
	
	public function pay($amount)
    {
		
	}


    

}  

class Notification
{
    private $notification_id;
    private $time;
    private $receiver_id;
    private $seen_status;
    private $date;
    private $notification;
    private $sender_id;
    private $service_id;

    public function read($notification_id)
    {
       
        $sql = "SELECT * FROM notification WHERE notification_id='$notification_id';";
        $result =QueryHandler::query($sql);
        $row = mysqli_fetch_array($result);
        if (!$result) {
            die('QUERY FAIL when reading notification Table!');
        } else {
            $this->time = $row['time'];
            $this->date = $row['date'];
            $this->receiver_id = $row['receiver_id'];
            $this->seen_status = $row['seen_status'];
            $this->notification = $row['notification'];
            $this->sender_id = $row['sender_id'];
            $this->service_id = $row['service_id'];
        }
    }

    public function see_Response()
    {
    }
    public function see_Schedule()
    {
    }

    public function decline_schedule($notification_id)
    {
  
        $delete_sql = "DELETE FROM notification WHERE notification_id='$notification_id';";
        $result = QueryHandler::query($delete_sql);
        if (!$result) {
            die('QUERY FAIL in decline notifiacation table row!');
        }
    }


    public function countSchedule($receiver_id)
    {
        $query_1 = "SELECT * FROM notification WHERE notification is not NULL AND seen_status = 0 AND receiver_id='$receiver_id'";
        $result_1 = QueryHandler::query($query_1);
        $count = mysqli_num_rows($result_1);
        if (!$result_1) {
            die('QUERY FAIL!');
        }
        return $count;
    }


    public function countResponse($customer_id)
    {
        $query_1 = "SELECT * FROM notification WHERE notification is not NULL AND seen_status = 0 AND receiver_id='$customer_id'";
        $result_1 = QueryHandler::query($query_1);
        $count = mysqli_num_rows($result_1);
        if (!$result_1) {
            die('QUERY FAIL!');
        }
        return $count;
    }

    public function hireNow($notification, $receiver_id, $sender_id, $notification_type, $service_id,$longitude , $latitude)
    {
        $query = " INSERT INTO notification(notification, receiver_id,sender_id ,notification_type,service_id , longitude,latitude  ) VALUES ('$notification', '$receiver_id','$sender_id' , '$notification_type','$service_id', '$longitude' , '$latitude')";
        QueryHandler::query($query);
    }


    public function create($notification, $receiver_id, $sender_id, $service_id,$notification_type,$time,$date,$longitude , $latitude)
    {
        $query = " INSERT INTO notification(notification, receiver_id,sender_id, service_id,notification_type,date,time, longitude,latitude) VALUES ('$notification', '$receiver_id','$sender_id','$service_id','$notification_type','$date','$time', '$longitude' , '$latitude')";
        QueryHandler::query($query);
    }

    public function schedule($receiver_id, $sender_id, $date, $time, $notification, $service_id ,$longitude , $latitude)
    {
    
        $query = " INSERT INTO notification( receiver_id,sender_id,date,time,notification,notification_type,service_id, longitude,latitude) VALUES ( '$receiver_id','$sender_id','$date' , '$time','$notification','common','$service_id', '$longitude' , '$latitude')";
        QueryHandler::query($query);
    }

    public function remove($notification_id)
    {
        $delete_sql = "DELETE FROM notification WHERE notification_id='$notification_id';";
        $result =QueryHandler::query($delete_sql);
        if (!$result) {
            die('QUERY FAIL in notifiacation table!');
        }
    }
    public function createHiring( $date, $time, $tradesman_id, $customer_id, $service_id,$final_status , $longitude , $latitude)
    {
       
        echo "create hiring page";
    echo $date.' '.$time.' '.$tradesman_id.' '.$customer_id.' '.$service_id;
        $query = " INSERT INTO hiring( customer_id,tradesman_id, service_id,registered_dateTime,time,final_status , longitude , latitude)
                             VALUES ( '$customer_id','$tradesman_id','$service_id','$date','$time','$final_status','$longitude' ,'$latitude');";
        $result_1= QueryHandler::query($query);
        if (!$result_1) {
            die('QUERY FAIL!');
        }
        $query_1 = "SELECT hiring_id FROM hiring WHERE customer_id='$customer_id' AND tradesman_id='$tradesman_id' AND service_id= '$service_id' ORDER BY hiring_id DESC LIMIT 1;";
        $result_1 = QueryHandler::query($query_1);
        $row = mysqli_fetch_assoc($result_1);
        $hiring_id = $row['hiring_id'];
        echo $hiring_id;
        return $hiring_id;
    }

    public function getHiringIDOngoing($tradesman_id, $customer_id, $service_id,$date,$time)
    {
        echo $tradesman_id.' '.$customer_id.' '.$service_id.' '.$time;
        $query_1 = "SELECT hiring_id FROM hiring WHERE customer_id='$customer_id' AND tradesman_id='$tradesman_id' AND service_id= '$service_id' AND time='$time' ORDER BY hiring_id DESC LIMIT 1;";
        $result_1 = QueryHandler::query($query_1);
        if (!$result_1) {
            die('QUERY FAIL in getHiringIDOngoing!');
        }
        $row = mysqli_fetch_assoc($result_1);
        $hiring_id = $row['hiring_id'];
        return $hiring_id;
    }

    /**
     * Get the value of time
     */
    public function getTime()
    {
        return $this->time;
    }

    /**
     * Set the value of time
     *
     * @return  self
     */
    public function setTime($time)
    {
        $this->time = $time;

        return $this;
    }

    /**
     * Get the value of receiver_id
     */
    public function getReceiver_id()
    {
        return $this->receiver_id;
    }

    /**
     * Get the value of sender_id
     */
    public function getSender_id()
    {
        return $this->sender_id;
    }

    /**
     * Get the value of service_id
     */
    public function getService_id()
    {
        return $this->service_id;
    }

    /**
     * Get the value of date
     */ 
    public function getDate()
    {
        return $this->date;
    }

    /**
     * Get the value of notification
     */ 
    public function getNotification()
    {
        return $this->notification;
    }
}