PK       ! !�T	  T	    User.phpnu �[���        <?php

namespace App\Models;

//Tips for impelementing codes

use App\Core\Model;
use App\Core\Database;

class User extends Model
{

    public function getUser($array_data)
    {
        $query = "SELECT * FROM `users` WHERE 1 AND `id` = ?";
        $paramType = "i";
        $response = Database::connect()->runQuery($query, $paramType, $array_data);
        return count($response) > 0 ? $response[0] : $response;
    }

    public function getUserByEmail($array_data)
    {
        $query = "SELECT * FROM `users` WHERE 1 AND `email` = ?";
        $paramType = "s";
        $response = Database::connect()->runQuery($query, $paramType, $array_data);
        return count($response) > 0 ? $response[0] : $response;
    }
    public function getUserByUsername($array_data)
    {
        $query = "SELECT * FROM `users` WHERE 1 AND `username` = ?";
        $paramType = "s";
        $response = Database::connect()->runQuery($query, $paramType, $array_data);
        return count($response) > 0 ? $response[0] : $response;
    }

    public function getUserStatus($array_data)
    {
        $query = "SELECT * FROM `users` WHERE 1 AND `id` = ? AND status = 1 AND active = 1";
        $paramType = "i";
        $response =  Database::connect()->runQuery($query, $paramType, $array_data);
        return count($response) > 0 ? $response[0] : $response;
    }

    public function createLoginToken($array_data)
    {
        $query = "INSERT INTO `users_login_session_token`(`user_id`, `token`, `updated_at`,`status`) VALUES (?,?,NOW(),1) ON DUPLICATE KEY UPDATE    
							token  = VALUES (token),
                            updated_at = VALUES(updated_at),
                            status = VALUES(status)
                            ";
        $paramType = "is";
        $insertId =  Database::connect()->insert($query, $paramType, $array_data);
        return $insertId;
    }


    public function createLastLoginDate($array_data)
    {
        $query = "UPDATE users SET last_login = NOW() WHERE id = ?";
        $paramType = "i";
        Database::connect()->update($query, $paramType, $array_data);
    }

    public function getUserIdBySessionToken($array_data)
    {
        $query = "SELECT user_id FROM users_login_session_token WHERE token = ? AND status = 1";
        $paramType = "s";
        return Database::connect()->select($query, $paramType, $array_data);
    }
}
PK       ! gwR�      Api.phpnu �[���        <?php

namespace App\Models;

//Tips for impelementing codes

use App\Core\Model;
use App\Core\Database;

class Api extends Model
{
    public function getApi($array_data)
    {
        $query = "SELECT * FROM api_keys WHERE 1 AND status = 1 AND api_key = ?";
        $paramType = "s";
        $response = Database::connect()->runQuery($query, $paramType, $array_data);
        return count($response) > 0 ? $response[0] : $response;
    }

    public function getApiAccessUri($array_data)
    {
        $query = "SELECT * FROM api_key_access_uris WHERE 1 AND status = 1 AND api_key_id = ? AND uri = ?";
        $paramType = "is";
        $response = Database::connect()->runQuery($query, $paramType, $array_data);
        return count($response) > 0 ? $response[0] : $response;
    }

    public function createApiLog($array_data)
    {
        $query = "INSERT INTO `api_logs` VALUES (null,?,?,?,?,NOW())";
        $paramType = "isss";
        $response = Database::connect()->insert($query, $paramType, $array_data);
        return $response;
    }
}
PK         ! !�T	  T	                  User.phpnu �[���        PK         ! gwR�                �	  Api.phpnu �[���        PK      �   �    