<?php
require_once 'DB.php';

class Auth {
	protected $pdo;

	public function __construct() {
		$db = new DB();
		$db->baseConfig();
		$this->pdo = $db->pdo;
	}

	public function login($login, $password) {

		$stmt = $this->pdo->prepare('SELECT * FROM users WHERE login = :login and password = :password');
		$stmt->execute(array('login' => $login, 'password' => md5($password)));

		$user = $stmt->fetch(PDO::FETCH_ASSOC);

		if($user) {

			$this->updateAuthTime($user['id']);
		}

		return $user;
	}

	public function updateAuthTime($user_id) {

		$stmt = $this->pdo->prepare('UPDATE users SET lastVisit = :lastVisit WHERE id=:id');
		$result	= $stmt->execute(array('id' => $user_id, 'lastVisit' => date('Y-m-d H:i:s')));

		return $result;
	}

	public function fileGetContent() {
		$text = file_get_contents('./file.txt');
		$user =  json_decode($text);

		return $user;
	}

	public function userAdd($login, $password) {

		$stmt = $this->pdo->prepare('INSERT INTO users SET login = :login, password = :password');
		$result = $stmt->execute(array('login' => $login, 'password' => md5($password)));
		return $result;
	}
}