<?php

class UserDAM extends DAM {

    // Database connection is inherited from the parent.
    function __construct() {
        parent::__construct();
    }

    public function CreateAccount($user) {
        if(hasPresence($user->email) && hasPresence($user->username) && hasPresence($user->password)) {
            // Check to see if the username AND email is already in the database.
            $query = 'SELECT email FROM users
                WHERE email = \''. $user->email . '\'';
            $query_username = 'SELECT username FROM users
                WHERE username = \''. $user->username .'\'';
            $statement = $this->db->prepare($query);
            $statement_username = $this->db->prepare($query_username);
            $statement->execute();
            $statement_username->execute();
            $userDB = $statement->fetch();
            $userDB_username = $statement_username->fetch();
            $statement->closeCursor();
            $statement_username->closeCursor();
            if ($userDB == null && $userDB_username == null)
            {
                $password = $user->password;
                $hashed_password = password_hash($password, PASSWORD_BCRYPT);
                // Add a new product to the database
                $query = 'INSERT INTO users (email, username, password)
                  VALUES
                    (\'' . $user->email . '\', \'' .
                        $user->username . '\', \'' .
                        $hashed_password . '\')';
                $statement = $this->db->prepare($query);
                $statement->execute();
                $statement->closeCursor();
            }
            else
            {
                //tell the user name already exists
                $message = "Username or Email already exists";
                echo "<script type='text/javascript'>alert('$message');</script>";
            }
        }
        else
        {
            //username, password, or email are blank return empty form
        }
    }
}