<?php
class Business {
    protected $db;
    function __construct ($db,$age,$yelp)
    {
        $this->db       = $db;
        $this->age = $age;
        $this->yelp = $yelp;
    }

    public function getBusinessPhone ($id)
    {
    try {
                $sql = "SELECT phone FROM businesses WHERE id=:id";
        $stmt = $this->db->prepare($sql);
        $stmt->bindValue(':id',$id);
        $stmt->execute();
        $result = $stmt->fetchAll();
        return $result[0]['phone'];
    } catch (PDOException $e) {
            die($e->getMessage());
        }
    }

    public function getBusinessInfo ($phone)
    {
    try {
        $sql = "SELECT * FROM businesses WHERE phone=:phone";
        $stmt = $this->db->prepare($sql);
        $stmt->bindValue(':phone',$phone);
        $stmt->execute();
        $result = $stmt->fetchAll();

        if(count($result) < 1){
            $this->yelp->updateBusiness($phone,"add");
            $sql = "SELECT * FROM businesses WHERE phone=:phone";
            $stmt = $this->db->prepare($sql);
            $stmt->bindValue(':phone',$phone);
            $stmt->execute();
            $result = $stmt->fetchAll();
        }
        if(time()-$result[0]['updated'] > $this->age){
            $this->yelp->updateBusiness($phone,"update");
            $sql = "SELECT * FROM businesses WHERE phone=:phone";
            $stmt = $this->db->prepare($sql);
            $stmt->bindValue(':phone',$phone);
            $stmt->execute();
            $result = $stmt->fetchAll();
        }
        print_r($result[0]);
        return $result[0];
    }
        catch (PDOException $e) {
            die($e->getMessage());
        }
    }

    public function refreshStaleBusinesses ()
    {
    try {
        $sql = "SELECT * FROM businesses WHERE updated<:calc";
        $stmt = $this->db->prepare($sql);
        $stmt->bindValue(':calc',time()-$this->age);
        $stmt->execute();
        $result = $stmt->fetchAll();
        foreach($result as $row) {
            $this->yelp->updateBusiness($row['phone'],"update");
        }
    }
        catch (PDOException $e) {
            die($e->getMessage());
        }
    }


}

?>