MixMail/models/ApplicationModel.php

<?php

namespace Models;

use Libs\ModelFactory;
use function React\Async\await;

class ApplicationModel
{
    public function __construct() {}

    public function getByFlag(string $flag): ?array
    {
        $adb = ModelFactory::adb();
        $sql = 'SELECT aplication_id, aplication_name, aplication_flag, aplication_url, aplication_auth_method FROM aplication WHERE aplication_flag = ? LIMIT 1';
        try {
            @error_log('[ApplicationModel] getByFlag SQL=' . $sql . ' param=' . $flag);
            $r = await($adb->query($sql, [$flag]));
        } catch (\Throwable $e) {
            @error_log('[ApplicationModel] getByFlag Exception: ' . $e->getMessage());
            throw $e;
        }
        if (!$r->rows || !isset($r->rows[0]['aplication_id'])) {
            return null;
        }
        return $r->rows[0];
    }

    public function getById(int $id): ?array
    {
        $adb = ModelFactory::adb();
        $sql = 'SELECT aplication_id, aplication_name, aplication_flag, aplication_url, aplication_auth_method FROM aplication WHERE aplication_id = ? LIMIT 1';
        try {
            @error_log('[ApplicationModel] getById SQL=' . $sql . ' param=' . $id);
            $r = await($adb->query($sql, [$id]));
        } catch (\Throwable $e) {
            @error_log('[ApplicationModel] getById Exception: ' . $e->getMessage());
            throw $e;
        }
        if (!$r->rows || !isset($r->rows[0]['aplication_id'])) {
            return null;
        }
        return $r->rows[0];
    }
}