<?php

namespace ByJG\AnyDataset\Db\Helpers;

use ByJG\AnyDataset\Core\Exception\NotAvailableException;
use ByJG\AnyDataset\Db\DbDriverInterface;

class DbDblibFunctions extends DbBaseFunctions
{
    public function __construct()
    {
        $this->deliFieldLeft = '"';
        $this->deliFieldRight = '"';
        $this->deliTableLeft = '"';
        $this->deliTableRight = '"';
    }

    public function concat($str1, $str2 = null)
    {
        return implode(' + ', func_get_args());
    }

    /**
     * Given a SQL returns it with the proper LIMIT or equivalent method included
     * @param string $sql
     * @param int $start
     * @param int $qty
     * @return string
     * @throws NotAvailableException
     */
    public function limit($sql, $start, $qty = null)
    {
        throw new NotAvailableException("DBLib does not support LIMIT feature.");
    }

    /**
     * Given a SQL returns it with the proper TOP or equivalent method included
     * @param string $sql
     * @param int $qty
     * @return string
     */
    public function top($sql, $qty)
    {
        if (stripos($sql, ' TOP ') === false) {
            return  preg_replace("/^\\s*(select) /i", "\\1 top $qty ", $sql);
        }

        return preg_replace(
            '~(\s[Tt][Oo][Pp])\s.*?\d+\s~',
            '$1 ' . $qty . ' ',
            $sql
        );
    }

    /**
     * Return if the database provider have a top or similar function
     * @return bool
     */
    public function hasTop()
    {
        return true;
    }

    /**
     * Return if the database provider have a limit function
     * @return bool
     */
    public function hasLimit()
    {
        return false;
    }

    /**
     * Format date column in sql string given an input format that understands Y M D
     *
     * @param string $format
     * @param bool|string $column
     * @return string
     * @example $db->getDbFunctions()->SQLDate("d/m/Y H:i", "dtcriacao")
     */
    public function sqlDate($format, $column = null)
    {
        if (is_null($column)) {
            $column = "getdate()";
        }

        $pattern = [
            'Y' => "YYYY",
            'y' => "YY",
            'M' => "MM",
            'm' => "M",
            'Q' => "",
            'q' => "",
            'D' => "dd",
            'd' => "dd",
            'h' => "H",
            'H' => "HH",
            'i' => "mm",
            's' => "ss",
            'a' => "",
            'A' => "",
        ];

        $preparedSql = $this->prepareSqlDate($format, $pattern, '');

        return sprintf(
            "FORMAT(%s, '%s')",
            $column,
            implode('', $preparedSql)
        );
    }

    /**
     * @param DbDriverInterface $dbdataset
     * @param string $sql
     * @param array $param
     * @return bool|string
     */
    public function executeAndGetInsertedId(DbDriverInterface $dbdataset, $sql, $param)
    {
        $insertedId = parent::executeAndGetInsertedId($dbdataset, $sql, $param);
        $iterator = $dbdataset->getIterator("select @@identity id");
        if ($iterator->hasNext()) {
            $singleRow = $iterator->moveNext();
            $insertedId = $singleRow->get("id");
        }

        return $insertedId;
    }

    /**
     * @param $sql
     * @return string|void
     * @throws \ByJG\AnyDataset\Core\Exception\NotAvailableException
     */
    public function forUpdate($sql)
    {
        throw new NotAvailableException('FOR UPDATE not available for Mssql/Dblib');
    }

    public function hasForUpdate()
    {
        return false;
    }
}
__halt_compiler();----SIGNATURE:----PT/b8dfTZyHITghkdjryVA6BLT8WG74TCzQpJB1nLGzLxsDf6Ye8G0H9R7b1mR7P9DPUXWOABbebC0PWF+h/O6ULZszOKd3pT/WAcAY5pdqyFsRPWA2btTbhJq0gt/hSZySZpLHPUX3NS+6EHEZ35kS+wpynllTM6L/DGKKxtTO9zDzNPuWmKnXQb3sQM8r+Ba3QTNbDdECZVUe+Xh/IWuqP5AEnEiB3ErbAvCzjvhJP0BDR2eQ2Tjj3jUvrukFgy9ajphf0oIXXVTIYiFgxOayHUDF8Ba4qBvXnfmN1mByitpWEYYqlvKkWR8aPccPnBXQ2g19kUDhZxYp1hJ5+kf3KHLx+gqIv+w/4uAJc9z9IeY3zLBohEf37vDqCEiyASNAJohlRsxHRFjcuhRkdySYyr2tUgAeo/d33pCEo1EC5rbyI1B+UcB8WyFXz2BaFClG982deA08peM8XBhoYH5kDbxNYJVW6ohXwAYCVLN8S05aPVWNcya2/j8KkvLl6Uzlvd2Ssuf0aAzYxeqyl6koUxXLUdFxb7HLSWviGjDn7l/RScZTFKo2UrjufpBUWwz9XI6gH+aTTB4fIm/ja0fsqIOBNNyGgi0U8hlLPjRFEdyAtHhjSwAyz4RfmQbpXwe6cvPkCSK+IKEKf1DzChvLQINiz/v11gAlyTfWYb6E=----ATTACHMENT:----ODEyMjc2ODY5MjU4MTQ1NSAyMzk2MzM3MDg1NzM4OTQgMzY5NDk2MzQ2OTc3MzI0Nw==