<?php
session_start();
include_once('connection.php');
ini_set("display_errors", 1);
error_reporting(E_ALL);
class User{


   /* const ERROR_USERNAME_TAKEN= 1;
    const ERROR_GENERAL= 2;
    const ERROR_OK= 0;*/

    private $db;
    public $username;
    public $password;
    private $book_id;

    private $isAuthenticated;
    private $signUp;
    private $deleteBooks;
   // private $validationError;

    public function __construct()
    {
        $this->db = (new connection())->dbConnect();

    }

    public function setUserName($username)
    {
        $this->username= $username;
    }

    public function setPassword($password)
    {
        $this->password= $password;
    }

    public function setBookId($book_id)
    {
        $this->book_id= $book_id;
    }

    public function getUserName()
    {
        return $this->username;
    }
    public function getPassword()
    {
        return $this->password;
    }

    public function getBookId()
    {
        return $this->book_id;
    }
   /* public function getErrorInfo()
    {

        $errorDescription= "";

        switch($this->validationError){
            case self::ERROR_USERNAME_TAKEN:
                $errorDescription= "YOur username is already taken";

                break;

            default:
                $errorDescription= "UNKNOWN ERROR";
            break;
        }

        return $info= array("code" => $this->validationError, "message" => $errorDescription );
    }*/
   //-------------------------------------------------------------------
   public function isAuthenticated()
   {
       $query = "SELECT 1 FROM loginUser WHERE username = :username AND password = :password";

       $statment = $this->db->prepare($query);

       $statment->execute(
           array(
               ':username' => $this->username,
               ':password' => $this->password
           ));

       $result = $statment->fetchColumn();

       $this->isAuthenticated= ($result == "1");
       return $this->isAuthenticated;

   }

   //-------------------------------------------------------------------

   public function getBooks($start = 0, $limit = 2, $order = "ASC")
   {
       $sql_start = $start * $limit;
       $sql_limit = $limit;
       $sql_order_by = $order;

       $query = "SELECT Library.nameOfBook, userBook.book_id, userBook.user_id FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username=:username ORDER BY Library.nameOfBook $sql_order_by LIMIT $sql_start, $sql_limit";
       $statment = $this->db->prepare($query);
       $statment->execute([
           ':username' => $this->username
       ]);
       $result = $statment->fetchAll();

      echo "<table id='myTable' border='1'>

     <tr>
      <th><a id='sorter' href='#'>Books</a></th>
      <th>Action</th>
      </tr>";
       foreach($result as $row){
           echo "<tr>";
           echo "<td>" . $row['nameOfBook'] . "</td>";
           echo "<td>" ."<input type='submit' id='delete".$row['book_id']."-".$row['user_id']."' onclick='deleteBook(this)' name='delete' value='Delete'>" . "</td>";
           echo "</tr>";
       }

       echo "</table>";
       echo "";
       return count($result);

   }

   //-------------------------------------------------------------------
      public function getBooksCount($start = 0, $limit = 2, $order = "ASC")
    {
       $sql_start = $start * $limit;
       $sql_limit = $limit;
       $sql_order_by = $order;

       $query = "SELECT Library.nameOfBook, userBook.book_id, userBook.user_id FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username=:username ORDER BY Library.nameOfBook $sql_order_by LIMIT $sql_start, $sql_limit";
       $statment = $this->db->prepare($query);
       $statment->execute([
           ':username' => $this->username
       ]);
       $result = $statment->fetchAll();
       return count($result);

   }
      //-------------------------------------------------------------------
   public function getIdByUsername($username){
            $stmt = $this->db->prepare("SELECT loginUser.id FROM loginUser WHERE loginUser.username=:username");
            $stmt->bindValue(":username", $username);

            if($stmt->execute()){
                $row = $stmt->fetch(PDO::FETCH_ASSOC);
            }

            return (isset($row['id'])?$row['id']:0);
        }
         //-------------------------------------------------------------------

   function get_books_count($user_id){
        $stmt = $this->db->prepare("SELECT COUNT(ub.book_id) as total FROM userBooks ub
        INNER JOIN Library l ON l.id = ub.book_id
        WHERE ub.user_id = :user_id");
        $stmt->bindValue(":user_id", $user_id);
        $stmt->execute();
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        return isset($row['total']) ? $row['total'] : 0;
    }



     //-------------------------------------------------------------------
     public function deleteBook($book_id, $user_id)
     {
         //echo "book_id is " . $book_id . ", user_id is " . $user_id;
         $stmt = $this->db->prepare("DELETE FROM userBook WHERE book_id = :book_id AND user_id = :user_id");
         if(!$stmt) echo $this->db->errorInfo();
         $stmt->bindValue(":book_id", $book_id);
         $stmt->bindValue(":user_id", $user_id);
         return $stmt->execute();
     }



    //-------------------------------------------------------------------


    public function signUp(&$errorInfo)
    {

            $statment = $this->db->prepare("SELECT COUNT(*) AS count FROM `loginUser` WHERE username=:username");
            $statment->execute(array(':username' => $this->username));

            if ($row = $statment->fetch(PDO::FETCH_ASSOC)) {
                $username_count = $row["count"];
            }

            if ($username_count > 0) {
             /* $this->validationError= self::ERROR_USERNAME_TAKEN;
                return false;*/

                echo "This user already taken";
            }
             else{ $statment = $this->db->prepare("INSERT INTO loginUser (username, password) VALUES(:username, :password)");

            $statment->bindParam(':username',$this->username);
            $statment->bindParam(':password',$this->password);


            $statment->execute();
            $result = $statment->rowCount();
            $this->signUp= ($result == "1");
            return $this->signUp;
             }
    }

}



?>