//library.php
<?php

require __DIR__ . '/database_connection.php';

/**
 * Class Task
 */
class Task
{

    /**
     * @var mysqli|PDO|string
     */
    protected $db;

    /**
     * Task constructor.
     */
    public function __construct()
    {
        $this->db = DB();
    }

	public function login($username,$password){
		$query = $this->db->prepare("SELECT username from users where username=:username and password=:password");
        $query->bindParam("username", $username, PDO::PARAM_STR);
        $query->bindParam("password", $password, PDO::PARAM_STR);
        $query->execute();

        //$data = array();
        if ($row = $query->fetch(PDO::FETCH_ASSOC)){
            //$data[] = $row;
            return json_encode(array( "status" => "true", "task" => $row) );
        }else{
            return json_encode(array( "status" => "false") );
        }
	}

    /**
     * Add new Task
     *
     * @param $name
     * @param $description
     *
     * @return string
     */
    public function Create($username, $password, $fullname)
    {
        $query = $this->db->prepare("INSERT INTO users(username, password, fullname) VALUES (:username,:password,:fullname)");
        $query->bindParam("username", $username, PDO::PARAM_STR);
        $query->bindParam("password", $password, PDO::PARAM_STR);
		$query->bindParam("fullname", $fullname, PDO::PARAM_STR);
        $query->execute();

        return json_encode(['task' => [
            'userid'          => $this->db->lastInsertId(),
            'username'        => $username,
            'password' 		  => $password,
			'fullname'		  => $fullname
        ]]);
    }

    /**
     * List Tasks
     *
     * @return string
     */
    public function Read()
    {
        $query = $this->db->prepare("SELECT * FROM users");
        $query->execute();
        $data = array();
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
            $data[] = $row;
        }

        return json_encode(['tasks' => $data]);
    }


    /**
     * Update Task
     *
     * @param $name
     * @param $description
     * @param $task_id
     */
    public function Update($username, $password, $fullname, $userid)
    {
        $query = $this->db->prepare("UPDATE users SET username = :username, password = :password, fullname = :fullname WHERE userid = :userid");
        $query->bindParam("username", $username, PDO::PARAM_STR);
        $query->bindParam("password", $password, PDO::PARAM_STR);
		$query->bindParam("fullname", $fullname, PDO::PARAM_STR);
        $query->bindParam("userid", $userid, PDO::PARAM_STR);
        $query->execute();
    }

    /**
     * Delete Task
     *
     * @param $task_id
     */
    public function Delete($userid)
    {
        $query = $this->db->prepare("DELETE FROM users WHERE userid = :userid");
        $query->bindParam("userid", $userid, PDO::PARAM_STR);
        $query->execute();
    }
}