<?php

class users {

    private $id;
    private $email;
    private $name;
    private $hashedPassword;

    public function __construct() {
        $this->id = -1;
        $this->email = "";
        $this->name = "";
        $this->hashedPassword = "";
    }

    public function setEmail($email) {
        $this->email = $email;
    }

    public function setName($name) {
        $this->name = $name;
    }

    public function setHashedPassword($newPassword) {
        $newHashedPassword = password_hash($newPassword, PASSWORD_BCRYPT);
        $this->hashedPassword = $newHashedPassword;
    }

    public function getId() {
        return $this->id;
    }

    public function getEmail() {
        return $this->email;
    }

    public function getName() {
        return $this->name;
    }

    public function getHashedPassword() {
        return $this->hashedPassword;
    }

    public function saveToDB(mysqli $conn) {
        if ($this->id == -1) {
            $sql = 'INSERT INTO `users`(`email`,`name`,`hashedPassword`) VALUES ("' . $this->getEmail() . '","' . $this->getName() . '","' . $this->getHashedPassword() . '")';

            $result = $conn->query($sql);
            if ($result == true) {
                $this->id = $conn->insert_id;
            }
        } else {
            return false;
        }
    }

    static public function loadUserById(mysqli $conn, $id) {
        $sql = 'SELECT * FROM `users` WHERE `id`= ' . $id . ' ';

        $result = $conn->query($sql);

        if ($result == true && $result->num_rows == 1) {
            $row = $result->fetch_assoc();

            $loadedUser = new users();
            $loadedUser->id = $row['id'];
            $loadedUser->name = $row['name'];
            $loadedUser->email = $row['email'];
            $loadedUser->hashedPassword = $row['hashedPassword'];

            return$loadedUser;
        }
        return null;
    }

    static public function loadAllUsers(mysql $conn) {
        $sql = 'SELECT * FROM `users`';
        $ret = [];

        $result = $conn->query($sql);
        if ($result == true && $result->num_rows != 0) {
            foreach ($result as $arr) {
                $loadUser = new users();
                $loadUser->id = $arr['id'];
                $loadUser->name = $arr['name'];
                $loadUser->email = $arr['email'];
                $loadUser->hashedPassword = $arr['hashedPassword'];

                $ret[] = $loadUser;
            }
        }
        return $ret;
    }

}