<?php

class User{

    private $db;

    public $Power;
    public $Username;

    public $Users;

    public $Created;

    public function User(){

        $this->db = new db_conn;

    }

    public function checkLogin(){

        if(!empty($_COOKIE['GUID'])){

            $query = array(
                'columns' => '`Username`',
                'table' => 'users',
                'where' => 'PIN = ?',
                'params' => array($_COOKIE['GUID'])
                );

            $this->db->selectOne($query);

            if($this->db->rowCount() == 0){
                return  false;
            } else {
                return true;
            }

        } else {

            return false;

        }

    }

    public function Login($inp){

        $inp = (object) $inp;

        $query = array(
            'columns' => '`Username`,`PIN`,`Password`',
            'table' => 'users',
            'where' => '`Username` = ?',
            'params' => array($inp->Username)
            );

        $this->db = new db_conn;
        $details = $this->db->selectOne($query);

        if($this->db->rowCount() == 1){

            if($details['Password'] == hash('sha512',$inp->Password)){

                if($inp->Remember == 'true'){
                    $Time = time() + 31556926;
                } else {
                    $Time = 60 * 60 * 24 + time();
                }

                setcookie('GUID', $details['PIN'], $Time , "/");

                return true;

            } else {
                return false;
            }

        } else {
            return false;
        }

    }

    public function getInfo($ID){

        $query = array(
            'columns' => '`Username`',
            'table' => 'users',
            'where' => 'ID = ?',
            'params' => array($ID)
            );

        return $this->db->selectOne($query);

    }

    public function Add($data){

        $data = (object) $data;

        $query = array(
            'table' => 'users',
            'columns' => 'Username, Password, PIN',
            'values' => '?,?,?',
            'params' => array($data->Username, hash('sha512', $data->Password), makePin(50))
                );

        $this->db->Insert($query);

    }

    public function Update($data){

        $data = (object) $data;

        $query = array(
            'table' => 'users',
            'values' => 'Username = ?, Password = ?',
            'where' => 'ID = ?',
            'params' => array($data->Username, hash('sha512', $data->Password), $data->id)
                );

        $this->db->Update($query);

    }

    public function checkExistance($Username){

        $query = array(
            'table' => 'users',
            'columns' => 'ID',
            'where' => 'Username = ?',
            'params' => array($Username)
            );

        $this->db->selectOne($query);

        return $this->db->rowCount();
    }

    public function getAll(){
        $query = array(
            'columns' => '`Username`,`ID`',
            'table' => 'users'
            );

        $this->Users = $this->db->selectAll($query);
    }

}


?>