<?php

namespace ByJG\AnyDataset\Db;

use ByJG\AnyDataset\Core\Enum\Relation;
use ByJG\AnyDataset\Core\IteratorFilterFormatter;
use ByJG\AnyDataset\Db\Helpers\SqlHelper;

class IteratorFilterSqlFormatter extends IteratorFilterFormatter
{
    public function format($filters, $tableName = null, &$params = [], $returnFields = "*")
    {
        $params = array();

        $sql = "select @@returnFields from @@tableName ";
        $sqlFilter = $this->getFilter($filters, $params);
        if ($sqlFilter != "") {
            $sql .= " where @@sqlFilter ";
        }

        return SqlHelper::createSafeSQL(
            $sql,
            [
                "@@returnFields" => $returnFields,
                "@@tableName" => $tableName,
                "@@sqlFilter" => $sqlFilter
            ]
        );
    }

    public function getRelation($name, $relation, $value, &$param)
    {
        $paramName = $name;
        $counter = 0;
        while (array_key_exists($paramName, $param)) {
            $paramName = $name . ($counter++);
        }

        $paramStr = function (&$param, $paramName, $value) {
            $param[$paramName] = trim($value);
            $result = "[[$paramName]]";
            if (is_object($value)) {
                unset($param[$paramName]);
                $result = $value->__toString();
            }
            return $result;
        };

        $data = [
            Relation::EQUAL => function (&$param, $name, $paramName, $value) use ($paramStr) {
                return " $name = " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::GREATER_THAN => function (&$param, $name, $paramName, $value) use ($paramStr) {
                return " $name > " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::LESS_THAN => function (&$param, $name, $paramName, $value) use ($paramStr) {
                return " $name < " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::GREATER_OR_EQUAL_THAN => function (&$param, $name, $paramName, $value) use ($paramStr) {
                return " $name >= " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::LESS_OR_EQUAL_THAN => function (&$param, $name, $paramName, $value) use ($paramStr) {
                return " $name <= " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::NOT_EQUAL => function (&$param, $name, $paramName, $value) use ($paramStr) {
                return " $name <> " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::STARTS_WITH => function (&$param, $name, $paramName, $value) use ($paramStr) {
                $value .= "%";
                return " $name  like  " . $paramStr($param, $paramName, $value) . ' ';
            },

            Relation::CONTAINS => function (&$param, $name, $paramName, $value) use ($paramStr) {
                $value = "%" . $value . "%";
                return " $name  like  " . $paramStr($param, $paramName, $value) . ' ';
            }
        ];

        return $data[$relation]($param, $name, $paramName, $value);
    }
}
__halt_compiler();----SIGNATURE:----k55WJIqkeUzsRul/+AinIpV19XfYdJN0VaZ4e/VdBF4b+qiTbmWuaHtImmbtw6tFdWgcEzkQL/7UBKg/AWwg+y3lvD3ewN8dNTYdtzg5KGEUbmKK6EVnSHQRZE5VoU4sovQRG4hBHb1xasqo3vQb8ALMjrhVPHLCc8tmcdoKpQLsJG1R9iIyHDRRk1JtMU6h6XLJVFyAia8Wb8MWABvCOXY6CBkrEPD1CQbJFi/uD6my6XMdv6WhcsC1pqGZYZMYIqYhQcpLwmZfykGDoZeZOl+3BTR9DBoCSKzrO4f/4AZ1hKKkFyGXSXecxm0Imjm9dbSBVmLxdeb9NOpSK64H0Wz7WUZyl9/c80NEOlptRmzAb1l1iZoOpVk5P2ddupeByJQvWTQ2CcE7K4UmnDfiSRS+FTeKsGlD8GHQMAn6kiNB7OzlZozvOBPtguJhIYqK4s6xQb736wBqNSODmAs422fFiJNSLLm1OqAG2kDSoZWxLcHQaLN6VQ6KyzJal5z5M9PUfnppzY3kSOmijDMSiRxOpten4Wqf91WQ6bhUXOU/BBuMypGmEDQ32j4xc3Sov0LAKg/kXCI7WoV8GXIEDiaqYB2q/nllXVk/Lg9yg4gYiIouGtALiGuAgTw6qD3+5zsbHFP78Fpfv+yz8u2Tvj3YXYOfzXqgWxHYDYWA5Yc=----ATTACHMENT:----MzE3NTA3OTkyMjU0Nzc2OSAxNjQ3MzEwNzQ4NDEzNzEgOTg0NDk4MjUzMjMzNzA3MA==