<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class UserModel extends BaseModel
{

    public function getUsers(): bool|object
    {
        $query = $this->connect()->query("
            SELECT 
            id_user,
            firstname,
            lastname,
            create_date,
            is_enabled,
            B.role,
            B.level
            FROM
            users A
            JOIN
            user_roles B
            ON A.id_role = B.id_role
            WHERE A.id_role > 0
        ");
        return $query;
    }

    public function getUserById(string $id): bool|object
    {
        $query = $this->connect()->query("
            SELECT 
            id_user,
            firstname,
            lastname,
            username,
            create_date,
            A.id_role,
            A.is_enabled,
            B.role,
            B.level
            FROM
            users A
            JOIN
            user_roles B
            ON A.id_role = B.id_role
            WHERE id_user = " . $id . "

        ");
        return $query;
    }

    public function getRoles(): bool|object
    {
        $query = $this->connect()->query("
            SELECT 
            id_role,
            role
            FROM user_roles
        ");
        return $query;
    }

    public function insertUser($data): bool|object
    {
        $password = $this->encriptPassword($data['password']);
        $query = $this->connect()->query("
            INSERT INTO users SET
            firstname = '" . $data['firstname'] . "',
            lastname = '" . $data['lastname'] . "',
            username = '" . $data['username'] . "',
            id_role = " . $data['id_role'] . ",
            password = '" . $password . "',
            is_enabled = " . $data['is_enabled'] . "

        ");
        return $query;
    }

    public function updateUser($data): bool|object
    {
        $query = $this->connect()->query("
            UPDATE users SET
            firstname = '" . $data['firstname'] . "',
            lastname = '" . $data['lastname'] . "',
            username = '" . $data['username'] . "',
            id_role = " . $data['id_role'] . ",
            is_enabled = " . $data['is_enabled'] . "
            WHERE id_user = " . $data['id_user'] . "
        ");
        return $query;
    }

    public function updatePassword($data): bool|object
    {
        $password = $this->encriptPassword($data['password']);
        $query = $this->connect()->query("
            UPDATE users SET
            password = '" . $password . "'
            WHERE id_user = " . $data['id_user'] . "

        ");
        return $query;
    }
    public function updateStatus(array $data) : void
    {
        $query = $this->connect()->query("
            UPDATE users SET
            is_enabled    = " . $data['status'] . "
            WHERE id_user = " . $data['id_user'] . "
            ");
    }

    public function encriptPassword($password): string
    {
        return password_hash($password, PASSWORD_BCRYPT);
    }
}