<?php

class User {
	public $id = null;
	public $username = null;
	public $password = null;
	public $email = null;
	public $birth_date = null;
	public $join_date = null;
	public $gender = null;
	public $role = null;
	public $data = null;
	public $avatar = 0;
	public $bio = '';
	public $xp = 0;
	public $rank = '-';
	public $level = 1;

	public function __construct($data = array())
	{
		if (isset($data['id'])) $this->id = (int)$data['id'];
		if (isset($data['username'])) $this->username = $data['username'];
		if (isset($data['password'])) $this->password = $data['password'];
		if (isset($data['email'])) $this->email = $data['email'];
		if (isset($data['birth_date'])) $this->birth_date = $data['birth_date'];
		if (isset($data['join_date'])) $this->join_date = $data['join_date'];
		if (isset($data['gender'])) $this->gender = $data['gender'];
		if (isset($data['data'])) $this->data = json_decode($data['data'], true);
		if (isset($data['avatar'])) $this->avatar = $data['avatar'];
		if (isset($data['role'])) $this->role = $data['role'];
		if (isset($data['bio'])) $this->bio = $data['bio'];
		if (isset($data['xp'])) $this->xp = $data['xp'];
		if(is_null($this->xp)){
			$this->xp = 0;
		}
		if(is_null($this->birth_date)){
			$this->birth_date = date('Y-m-d');
		}

		if(!$this->data){
			$this->data = array();
			$this->data['likes'] = [];
		}

		if(file_exists(ABSPATH.'includes/rank.json')){
			$rank = json_decode(file_get_contents(ABSPATH.'includes/rank.json'), true);
			if($rank){
				$index = 0;
				foreach ($rank as $name => $value) {
					if($this->xp >= $value){
						$index++;
						$this->level = $index;
						$this->rank = $name;
					}
				}
			}
		}
	}

	public function storeFormValues($params)
	{
		$this->__construct($params);
		if(is_null($this->join_date)){
			$this->join_date = date('Y-m-d');
		}
	}

	public static function getById($id)
	{
		$conn = open_connection();
		$sql = "SELECT * FROM users WHERE id = :id";
		$st = $conn->prepare($sql);
		$st->bindValue(":id", $id, PDO::PARAM_INT);
		$st->execute();
		$row = $st->fetch();
		if ($row) return new User($row); //$row
	}

	public static function getByUsername($username)
	{
		$conn = open_connection();
		$sql = "SELECT * FROM users WHERE username = :username LIMIT 1";
		$st = $conn->prepare($sql);
		$st->bindValue(":username", $username, PDO::PARAM_STR);
		$st->execute();
		$row = $st->fetch();
		if ($row) return new User($row); //$row
	}

	public static function getList(int $amount = 30, $sort = 'desc', int $offset = 0)
	{
		$conn = open_connection();
		$sql = "SELECT * FROM users
			ORDER BY id $sort LIMIT $amount OFFSET $offset";
		$st = $conn->prepare($sql);
		$st->execute();
		$list = array();

		while ($row = $st->fetch())
		{
			$user = new User($row);
			$list[] = $user;
		}
		$totalRows = $conn->query('SELECT count(*) FROM users')->fetchColumn();
		$totalPages = 0;
		if (count($list))
		{
			$totalPages = ceil($totalRows / $amount);
		}
		return (array(
			"results" => $list,
			"totalRows" => $totalRows,
			"totalPages" => $totalPages
		));
	}

	public static function getByEmail($email)
	{
		$conn = open_connection();
		$sql = "SELECT * FROM users WHERE email = :email LIMIT 1";
		$st = $conn->prepare($sql);
		$st->bindValue(":email", $email, PDO::PARAM_STR);
		$st->execute();
		$row = $st->fetch();
		if ($row) return new User($row); //$row
	}

	public function array_id_exist($id)
	{
		if(!is_null($this->id)){
			if(!is_null($this->data) && isset($this->data['likes'])){
				$index = 1;
				foreach ($this->data['likes'] as $val) {
					if($val == $id){
						return $index;
					}
					$index++;
				}
				return false;
			}
		}
	}

	public function favoriteGames()
	{
		if(!is_null($this->id)){
			$conn = open_connection();
			$sql = "SELECT * FROM favorites WHERE user_id = :user_id ORDER BY id DESC";
			$st = $conn->prepare($sql);
			$st->bindValue(":user_id", $this->id, PDO::PARAM_INT);
			$st->execute();
			$row = $st->fetchAll();
			return $row;
		}
		return null;
	}

	public static function getTotalUsers(){
		// Get total users
		$conn = open_connection();
		$sql = "SELECT COUNT(*) FROM users";

		$st = $conn->prepare($sql);
		$st->execute();
		return $st->fetchColumn();
	}

	public function like($id)
	{
		if(!is_null($this->id)){
			if(is_null($this->data) || $this->data == ''){
				$this->data = array();
				$this->data['likes'] = array();
			}
			if(!isset($this->data['likes'])){
				$this->data['likes'] = array();
			}
			if(!$this->array_id_exist($id)){
				array_push($this->data['likes'], $id);
			}
			$this->xp += 10;
			$this->update_data();
			$this->update_xp();
		} else {
			echo "User is null";
		}
	}

	public function dislike($id)
	{
		if(!is_null($this->id)){
			if(is_null($this->data) || $this->data == ''){
				$this->data = array();
				$this->data['likes'] = array();
			}
			if(!isset($this->data['likes'])){
				$this->data['likes'] = array();
			}
			$arr = $this->array_id_exist($id);
			if($arr){
				array_splice($this->data['likes'], $arr-1, 1);
				$this->update_data();
			}
		} else {
			echo "User is null";
		}
	}

	public function insert()
	{
		if (!is_null($this->id)) trigger_error("User::insert(): Attempt to insert an User object that already has its ID property set (to $this->id).", E_USER_ERROR);

		if(!$this->avatar){
			$this->avatar = rand(1,20);
		}

		$conn = open_connection();
		$sql = 'INSERT INTO users ( username, password, email, birth_date, join_date, gender, data, role, avatar ) 
				  VALUES ( :username, :password, :email, :birth_date, :join_date, :gender, :data, :role, :avatar )';
		$st = $conn->prepare($sql);
		$st->bindValue(":username", $this->username, PDO::PARAM_STR);
		$st->bindValue(":password", $this->password, PDO::PARAM_STR);
		$st->bindValue(":email", $this->email, PDO::PARAM_STR);
		$st->bindValue(":birth_date", $this->birth_date, PDO::PARAM_STR);
		$st->bindValue(":join_date", $this->join_date, PDO::PARAM_STR);
		$st->bindValue(":gender", $this->gender, PDO::PARAM_STR);
		$st->bindValue(":data", json_encode($this->data), PDO::PARAM_STR);
		$st->bindValue(":role", 'user', PDO::PARAM_STR);
		$st->bindValue(":avatar", $this->avatar, PDO::PARAM_INT);
		$st->execute();
		$this->id = $conn->lastInsertId();
	}

	public function update_data()
	{
		if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
		//
		$conn = open_connection();
		$sql = "UPDATE users SET data=:data WHERE id = :id";

		$st = $conn->prepare($sql);
		$st->bindValue(":id", $this->id, PDO::PARAM_INT);
		$st->bindValue(":data", json_encode($this->data), PDO::PARAM_STR);
		$st->execute();
	}

	public function update_xp()
	{
		if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
		//
		$conn = open_connection();
		$sql = "UPDATE users SET xp=:xp WHERE id = :id";

		$st = $conn->prepare($sql);
		$st->bindValue(":id", $this->id, PDO::PARAM_INT);
		$st->bindValue(":xp", $this->xp, PDO::PARAM_INT);
		$st->execute();
	}

	public function add_xp($val)
	{
		if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
		//
		$this->xp += (int)$val;
		
		$conn = open_connection();
		$sql = "UPDATE users SET xp=:xp WHERE id = :id";

		$st = $conn->prepare($sql);
		$st->bindValue(":id", $this->id, PDO::PARAM_INT);
		$st->bindValue(":xp", $this->xp, PDO::PARAM_INT);
		$st->execute();
	}

	public function update()
	{
		if (is_null($this->id)) trigger_error("User::update(): Attempt to update an User object that does not have its ID property set.", E_USER_ERROR);
		//
		$conn = open_connection();
		$sql = "UPDATE users SET username=:username, password=:password, email=:email, birth_date=:birth_date, gender=:gender, bio=:bio, avatar=:avatar WHERE id = :id";

		$st = $conn->prepare($sql);
		$st->bindValue(":id", $this->id, PDO::PARAM_INT);
		$st->bindValue(":username", $this->username, PDO::PARAM_STR);
		$st->bindValue(":password", $this->password, PDO::PARAM_STR);
		$st->bindValue(":email", $this->email, PDO::PARAM_STR);
		$st->bindValue(":birth_date", $this->birth_date, PDO::PARAM_STR);
		$st->bindValue(":gender", $this->gender, PDO::PARAM_STR);
		$st->bindValue(":bio", $this->bio, PDO::PARAM_STR);
		$st->bindValue(":avatar", $this->avatar, PDO::PARAM_INT);
		$st->execute();

	}

	public function delete( $pass = null )
	{
		if (is_null($this->id)) trigger_error("User::delete(): Attempt to delete an User object that does not have its ID property set.", E_USER_ERROR);

		if(password_verify($pass, $this->password) || USER_ADMIN){
			$conn = open_connection();
			$st = $conn->prepare("DELETE FROM users WHERE id = :id LIMIT 1");
			$st->bindValue(":id", $this->id, PDO::PARAM_INT);
			$st->execute();
			//Delete its avatar if exist
			if(file_exists( ABSPATH.'images/avatar/'.$this->username.'.png' )){
				unlink( ABSPATH.'images/avatar/'.$this->username.'.png' );
			}

			//Remove all comments from this user
			$st = $conn->prepare("DELETE FROM comments WHERE sender_id = :id");
			$st->bindValue(":id", $this->id, PDO::PARAM_INT);
			$st->execute();

			//Remove all scores from this user
			$st = $conn->prepare("DELETE FROM scores WHERE user_id = :id");
			$st->bindValue(":id", $this->id, PDO::PARAM_INT);
			$st->execute();
		}
	}
}

?>
