<?php

    class User {

        private $id;
        private $username;
        private $password;
        private $first_name;
        private $last_name;

        public function __construct() {

        }

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

        public function GetUsername() {
            return $this->username;
        }
        public function GetFirstName() {
            return $this->first_name;
        }
        public function GetLastName() {
            return $this->last_name;
        }

        public static function GetAllUsers() {

            $result = Database::Query("SELECT * FROM users");
            return $result->fetchAll(\PDO::FETCH_ASSOC);

        }

        public static function FindUserById($id) {

            $result = Database::Query("SELECT * FROM users
                                       WHERE id = $id
                                       LIMIT 1");

            return $result;

        }

        public static function CreateUserObject($user) {

            $user->setFetchMode(\PDO::FETCH_CLASS, "User");
            $newUser = $user->fetch();

            return $newUser;

        }

        public static function CreateUserObjectById($id) {

            $foundUser = self::FindUserById($id);

            if ($foundUser) {
                return self::CreateUserObject($foundUser);
            }

        }

    }

?>