<?php

Prado::using('System.Data.SqlMap.TSqlMapGateway');

class Facade {

    protected static $_instances = [];

    protected $_sqlMap;

    protected function __construct() {
    }

    public function __sleep() {
        $this->_sqlMap = NULL;
        return array();
    }

    public static function getInstance() {
        $className = get_called_class();
        if (!isset(static::$_instances[$className])) {
            static::$_instances[$className] = new static();
        }
        return static::$_instances[$className];
    }

    protected function getClient() {
        if (!$this->_sqlMap) {
            $this->_sqlMap = Prado::getApplication()->getModule('sqlmap')->Client;
        }
        return $this->_sqlMap;
    }

    protected function quoteString(string $string) {
        return $this->getClient()->DbConnection->quoteString($string);
    }

    protected function fetch(string $sqlMap, array $params) {
        return $this->getClient()->queryForObject($sqlMap, $params);
    }

    protected function fetchList(string $sqlMap, array $params) {
        return $this->getClient()->queryForList($sqlMap, $params);
    }

    protected function fetchMap(string $sqlMap, array $params, string $key, $value=NULL) {
        return $this->getClient()->queryForMap($sqlMap, $params, $key, $value);
    }

    protected function beginTransaction() {
        return $this->getClient()->DbConnection->beginTransaction();
    }

    protected function raiseEvent(string $event, ...$params) {
        return Prado::getApplication()->getModule('events')->raiseApplicationEvent(
            $event, ...$params
        );
    }

}

?>