<?php

namespace {
$GLOBALS['TL_DCA']['tl_c4g_map_tables'] = ['config' => ['dataContainer' => \Contao\DC_Table::class, 'enableVersioning' => \true, 'markAsCopy' => 'name', 'sql' => ['keys' => ['id' => 'primary']], 'onload_callback' => [['con4gis\\MapsBundle\\Classes\\Contao\\Callbacks\\TlC4gMapSettings', 'addDefaultTables'], ['tl_c4g_map_tables', 'showInfoMessage']]], 'list' => ['sorting' => ['mode' => 1, 'fields' => ['name'], 'flag' => 1, 'icon' => 'bundles/con4giscore/images/be-icons/con4gis_blue.svg'], 'label' => ['fields' => ['icon', 'name', 'tableSource'], 'label_callback' => ['tl_c4g_map_tables', 'addIcon'], 'showColumns' => \true], 'global_operations' => ['all' => ['label' => &$GLOBALS['TL_LANG']['MSC']['all'], 'href' => 'act=select', 'class' => 'header_edit_all', 'attributes' => 'onclick="Backend.getScrollOffset();" accesskey="e"'], 'back' => ['href' => 'key=back', 'class' => 'header_back', 'button_callback' => ['\\con4gis\\CoreBundle\\Classes\\Helper\\DcaHelper', 'back'], 'icon' => 'back.svg', 'label' => &$GLOBALS['TL_LANG']['MSC']['backBT']]], 'operations' => ['edit' => ['label' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['edit'], 'href' => 'act=edit', 'icon' => 'edit.svg'], 'copy' => ['label' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['copy'], 'href' => 'act=copy', 'icon' => 'copy.svg'], 'delete' => ['label' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['delete'], 'href' => 'act=delete', 'icon' => 'delete.svg', 'attributes' => 'onclick="if (!confirm(\'' . ($GLOBALS['TL_LANG']['MSC']['deleteConfirm'] ?? \null) . '\')) return false; Backend.getScrollOffset();"'], 'show' => ['label' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['show'], 'href' => 'act=show', 'icon' => 'show.svg']]], 'palettes' => ['__selector__' => ['popupSwitch', 'dataType'], 'default' => '{defaultLegend},name,customDB,tableSource;{parentLegend},ptable,ptableOptions,ptableBackendField,ptableField,ptableCompareField;{geoLegend},dataType;{projLegend:hide},projName,projCode;{tableInformation},label,locstyle,tooltip,popupSwitch,cutTextAtLength;'], 'subpalettes' => ['popupSwitch_default' => 'popupSelection', 'popupSwitch_expert' => 'popup,openLinksInTab', 'dataType_1' => 'geox,geoy', 'dataType_2' => 'geolocation', 'dataType_3' => 'geolocation', 'dataType_4' => 'geolocation'], 'fields' => ['id' => ['sql' => "int(10) unsigned NOT NULL auto_increment"], 'tstamp' => ['sql' => "int(10) unsigned NOT NULL default '0'"], 'importId' => ['sql' => "bigint(20) unsigned NOT NULL default '0'", 'eval' => ['doNotCopy' => \true]], 'name' => ['exclude' => \true, 'inputType' => 'text', 'default' => '', 'sql' => "text NULL default ''"], 'customDB' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getDatabases'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'chosen' => \true, 'submitOnChange' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'tableSource' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getDatabaseTables'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'chosen' => \true, 'submitOnChange' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'ptable' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getDatabaseTables'], 'save_callback' => ['tl_c4g_map_tables', 'serializeResult'], 'eval' => ['mandatory' => \false, 'multiple' => \true, 'size' => 2, 'chosen' => \true, 'submitOnChange' => \true], 'sql' => "text NULL default ''"], 'ptableOptions' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getParentTablesFields'], 'save_callback' => ['tl_c4g_map_tables', 'serializeResult'], 'eval' => ['mandatory' => \false, 'multiple' => \true, 'size' => 2, 'chosen' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'ptableBlob' => ['default' => '', 'sql' => "text NULL"], 'ptableField' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'save_callback' => ['tl_c4g_map_tables', 'serializeResult'], 'eval' => ['mandatory' => \false, 'chosen' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'ptableCompareField' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getParentTablesFields'], 'save_callback' => ['tl_c4g_map_tables', 'serializeResult'], 'eval' => ['mandatory' => \false, 'multiple' => \true, 'chosen' => \true, 'size' => 2], 'sql' => "text NULL default ''"], 'dataType' => ['exclude' => \true, 'default' => '1', 'inputType' => 'radio', 'options' => [1, 2, 3, 4], 'reference' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['references']['dataType'], 'eval' => ['mandatory' => \true, 'multiple' => \false, 'submitOnChange' => \true], 'sql' => "varchar(1) default 1"], 'geox' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'geoy' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'geolocation' => ['exclude' => \true, 'default' => '', 'inputType' => 'select', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'projName' => ['exclude' => \true, 'inputType' => 'text', 'default' => '', 'eval' => ['mandatory' => \false], 'sql' => "varchar(10) NULL default ''"], 'projCode' => ['exclude' => \true, 'inputType' => 'text', 'default' => '', 'eval' => ['mandatory' => \false, 'decodeEntities' => \true], 'sql' => "text NULL default ''"], 'label' => ['exclude' => \true, 'default' => '', 'inputType' => 'select', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'locstyle' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'chosen' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'tooltip' => ['exclude' => \true, 'inputType' => 'select', 'default' => '', 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'eval' => ['mandatory' => \false, 'multiple' => \false, 'chosen' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'popupSwitch' => ['exclude' => \true, 'inputType' => 'radio', 'default' => 'default', 'options' => ['default' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['popupSwitch_default'], 'expert' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['popupSwitch_expert'], 'off' => &$GLOBALS['TL_LANG']['tl_c4g_map_tables']['popupSwitch_off']], 'eval' => ['submitOnChange' => \true, 'tl_class' => 'clr'], 'sql' => "varchar(10) NOT NULL default 'default'"], 'popupSelection' => ['exclude' => \true, 'inputType' => 'select', 'default' => [], 'options_callback' => ['tl_c4g_map_tables', 'getSourceTableFields'], 'save_callback' => [['tl_c4g_map_tables', 'concatResult']], 'load_callback' => [['tl_c4g_map_tables', 'separateResult']], 'eval' => ['mandatory' => \false, 'multiple' => \true, 'chosen' => \true, 'includeBlankOption' => \true], 'sql' => "text NULL default ''"], 'popup' => ['exclude' => \true, 'inputType' => 'text', 'default' => '', 'eval' => ['mandatory' => \false], 'sql' => "text NULL default ''"], 'openLinksInTab' => ['exclude' => \true, 'default' => \false, 'inputType' => 'checkbox', 'eval' => ['tl_class' => 'clr'], 'sql' => "char(1) NOT NULL default '0'"], 'cutTextAtLength' => ['exclude' => \true, 'default' => '0', 'inputType' => 'text', 'eval' => ['mandatory' => \false], 'sql' => "varchar(10) NULL default '0'"]]];
class tl_c4g_map_tables extends \Contao\Backend
{
    public function getDatabases(\Contao\DC_Table $dc)
    {
        $result = \Contao\Database::getInstance()->prepare("SHOW DATABASES")->execute();
        $arrResult = $result->fetchAllAssoc();
        $options = [];
        foreach ($arrResult as $element) {
            $options[$element['Database']] = $element['Database'];
        }
        return $options;
    }
    public function getDatabaseTables(\Contao\DC_Table $dc)
    {
        if ($dc->activeRecord->customDB) {
            $result = \Contao\Database::getInstance([\dbDatabase => $dc->activeRecord->customDB])->prepare("SHOW TABLES")->execute();
            $arrResult = $result->fetchAllAssoc();
            $options = [];
            foreach ($arrResult as $element) {
                $options[$element['Tables_in_' . $dc->activeRecord->customDB]] = $element['Tables_in_' . $dc->activeRecord->customDB];
            }
        } else {
            $options = $this->Database->listTables();
        }
        return $options;
    }
    public function getSourceTableFields(\Contao\DC_Table $dc)
    {
        $tableName = $dc->activeRecord->tableSource;
        $options = [];
        if ($dc->activeRecord->customDB && $tableName && $tableName !== "") {
            $result = \Contao\Database::getInstance([\dbDatabase => $dc->activeRecord->customDB])->prepare("SHOW COLUMNS FROM " . $tableName)->execute();
            $arrResult = $result->fetchAllAssoc();
            $options = [];
            foreach ($arrResult as $element) {
                $options[$element['Field']] = $element['Field'];
            }
        } else {
            if ($tableName && $tableName !== "") {
                $options = $this->Database->listFields($tableName);
                $arrReturn = [];
                foreach ($options as $option) {
                    $arrReturn[$option['name']] = $option['name'];
                }
            }
        }
        return $arrReturn;
    }
    public function getParentTablesFields(\Contao\DC_Table $dc)
    {
        $tableNames = \Contao\StringUtil::deserialize($dc->activeRecord->ptable);
        $options = [];
        if (!$tableNames) {
            return $options;
        }
        if ($dc->activeRecord->customDB) {
            foreach ($tableNames as $tableName) {
                $result = \Contao\Database::getInstance([\dbDatabase => $dc->activeRecord->customDB])->prepare("SHOW COLUMNS FROM " . $tableName)->execute();
                $arrResult = $result->fetchAllAssoc();
                foreach ($arrResult as $element) {
                    $options[$tableName . '.' . $element['Field']] = $tableName . '.' . $element['Field'];
                }
            }
        } else {
            foreach ($tableNames as $tableName) {
                if ($tableName) {
                    $tableOptions = $this->Database->listFields($tableName);
                    foreach ($tableOptions as $tableOption) {
                        $options[$tableName . '.' . $tableOption['name']] = $tableName . '.' . $tableOption['name'];
                    }
                }
            }
        }
        return $options;
    }
    public function serializeResult($varValue, \Contao\DC_Table $dc)
    {
        return \serialize($varValue);
    }
    public function concatResult($varValue)
    {
        $varValue = \implode(",", \Contao\StringUtil::deserialize($varValue));
        return $varValue;
    }
    public function separateResult($varValue)
    {
        return \explode(",", $varValue);
    }
    /**
     * Add an image to each record
     *
     * @param array                $row
     * @param string               $label
     * @param DC_TABLE $dc
     * @param array                $args
     *
     * @return array
     */
    public function addIcon($row, $label, \Contao\DC_Table $dc, $args)
    {
        $image = 'bundles/con4gismaps/images/be-icons/sourcetables.svg';
        $args[0] = '<div class="list_icon_new" style="background-image:url(' . $image . ')" data-icon="' . $image . '">&nbsp;</div>';
        return $args;
    }
    /**
     * @param DC_TABLE $dc
     */
    public function showInfoMessage(\Contao\DC_Table $dc)
    {
        \Contao\Message::addInfo($GLOBALS['TL_LANG']['tl_c4g_map_tables']['infotext']);
    }
}
}