<?php

/**
 * OBG Customizations
 *
 * Copyright (c) 2021 vonRotenberg
 *
 * @license commercial
 */

use Contao\DC_Table;
use Contao\DataContainer;
use Contao\System;

System::loadLanguageFile('default');

$GLOBALS['TL_DCA']['tl_vr_real_estate_assets'] = array
(
    // Config
    'config'      => array
    (
        'dataContainer'    => DC_Table::class,
        'ptable'           => 'tl_vr_real_estate_categories',
        'enableVersioning' => true,
        'switchToEdit'     => true,
        'markAsCopy'       => 'title',
        'sql'              => array
        (
            'keys' => array
            (
                'id'  => 'primary',
                'pid' => 'index',
            )
        )
    ),

    // List
    'list'        => array
    (
        'sorting'           => array
        (
            'mode'                  => DataContainer::MODE_PARENT,
            'fields'                => array('address', 'assetNo', 'title'),
            'flag'                  => DataContainer::SORT_INITIAL_LETTER_ASC,
            'headerFields'          => array('title'),
            'disableGrouping'       => false,
            'child_record_callback' => function ($arrRow) {
                $time = time();
                $isUnpublished = !$arrRow['published'] || ($arrRow['stop'] && $arrRow['stop'] <= time());
                return '<div class="tl_content_left"><div class="estable"><div class="estable_cell estable_w25">' . $arrRow['title'] . ' <div class="esc_grey">[' . $arrRow['assetNo'] . ']</div></div><div class="estable_cell estable_w10" style="text-align:right; padding-right: 10px;">' . number_format($arrRow['livingSpace'], 2, ',', '') . ' m²</div>' . (!$isUnpublished ? '<div class="estable_cell esc_blue">Veröffentlicht<br>ab: ' . ($time < $arrRow['start'] ? \Contao\Date::parse(\Contao\Date::getNumericDatimFormat(), $arrRow['start']) : 'sofort') . '<br>bis: ' . ($time < $arrRow['stop'] ? \Contao\Date::parse(\Contao\Date::getNumericDatimFormat(), $arrRow['stop']) : 'endlos') . '</div>' : '') . '</div></div>';
            },
            'panelLayout'           => 'filter;sort,search,limit'
        ),
        'label'             => array
        (
            'fields' => array('title'),
        ),
        'global_operations' => array
        (
            'all' => array
            (
                'href'       => 'act=select',
                'class'      => 'header_edit_all',
                'attributes' => 'onclick="Backend.getScrollOffset()" accesskey="e"'
            )
        ),
        'operations'        => array
        (
            'edit'   => array
            (
                'href' => 'act=edit',
                'icon' => 'edit.svg'
            ),
            'copy'   => array
            (
                'href' => 'act=paste&amp;mode=copy',
                'icon' => 'copy.svg'
            ),
            'cut'    => array
            (
                'href' => 'act=paste&amp;mode=cut',
                'icon' => 'cut.svg'
            ),
            'delete' => array
            (
                'href'       => 'act=delete',
                'icon'       => 'delete.svg',
                'attributes' => 'onclick="if(!confirm(\'' . ($GLOBALS['TL_LANG']['MSC']['deleteConfirm'] ?? null) . '\'))return false;Backend.getScrollOffset()"'
            ),
            'show'   => array
            (
                'href' => 'act=show',
                'icon' => 'show.svg'
            )
        )
    ),

    // Palettes
    'palettes'    => array
    (
        '__selector__' => array('availability','managedPropertyId'),
        'default'      => '{title_legend},title,assetNo,floor,managedPropertyId;{availability_legend},availability;{misc_legend},description;{basic_data_legend},livingSpace,numberOfRooms,rent,coldRent,advanceOperatingCosts,constructionYear,deposit,entitlementCertificate;{features_legend},features,parking,heatingType,energyPassType,energyConsumption;{images_legend},gallerySRC,floorPlansSRC;{publish_legend},published,start,stop',
    ),

    // Subpalettes
    'subpalettes' => array
    (
        'availability_from' => 'availableFrom',
        'managedPropertyId_0' => 'address,postal,city'
    ),

    // Fields
    'fields'      => array
    (
        'id'                    => array
        (
            'sql' => "int(10) unsigned NOT NULL auto_increment"
        ),
        'pid'                   => array
        (
            'foreignKey' => 'tl_vr_real_estate_categories.title',
            'sql'        => "int(10) unsigned NOT NULL",
            'relation'   => array('type' => 'belongsTo', 'load' => 'lazy')
        ),
        'tstamp'                => array
        (
            'sql' => "int(10) unsigned NOT NULL default 0"
        ),
        'title'                 => array
        (
            'exclude'   => true,
            'flag'      => DataContainer::SORT_INITIAL_LETTER_ASC,
            'default'   => '2 Zimmer Wohnung',
            'inputType' => 'text',
            'eval'      => array('mandatory' => true, 'maxlength' => 255, 'tl_class' => 'w50'),
            'sql'       => "varchar(255) NOT NULL default ''"
        ),
        'postal'                => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => true, 'rgxp' => 'natural', 'maxlength' => 5, 'tl_class' => 'w50'),
            'sql'       => "varchar(5) NOT NULL default ''"
        ),
        'city'                  => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'default'   => 'Kehl',
            'eval'      => array('mandatory' => true, 'maxlength' => 255, 'tl_class' => 'w50'),
            'sql'       => "varchar(255) NOT NULL default ''"
        ),
        'address'               => array
        (
            'exclude'   => true,
            'filter'    => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'maxlength' => 255, 'tl_class' => 'w50'),
            'sql'       => "varchar(255) NOT NULL default ''"
        ),
        'floor'                 => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'maxlength' => 255, 'tl_class' => 'w50'),
            'sql'       => "varchar(255) NOT NULL default ''"
        ),
        'assetNo'               => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => true, 'maxlength' => 8, 'tl_class' => 'w50'),
            'sql'       => "varchar(8) NOT NULL default ''"
        ),
        'managedPropertyId'           => array
        (
            'exclude'   => true,
            'inputType' => 'select',
            'foreignKey' => 'tl_vr_re_managedProperties.address',
            'eval'      => array('mandatory' => false, 'includeBlankOption' => true, 'submitOnChange' => true, 'tl_class' => 'w50', 'chosen' => true),
            'sql'       => "int(10) unsigned NOT NULL default 0",
            'relation'   => array('type' => 'belongsTo', 'load' => 'lazy')
        ),
        'livingSpace'           => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'float', 'maxlength' => 6, 'tl_class' => 'w50'),
            'sql'       => "float(5,2) unsigned NOT NULL default 0.00"
        ),
        'numberOfRooms'         => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'natural', 'maxlength' => 2, 'tl_class' => 'w50'),
            'sql'       => "smallint(2) unsigned NOT NULL default 0"
        ),
        'rent'                  => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'currency', 'maxlength' => 15, 'tl_class' => 'w50'),
            'sql'       => "decimal(12,2) NOT NULL default '0.00'"
        ),
        'coldRent'              => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'currency', 'maxlength' => 15, 'tl_class' => 'w50'),
            'sql'       => "decimal(12,2) NOT NULL default '0.00'"
        ),
        'advanceOperatingCosts' => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'currency', 'maxlength' => 15, 'tl_class' => 'w50'),
            'sql'       => "decimal(12,2) NOT NULL default '0.00'"
        ),
        'heatingCosts'          => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'currency', 'maxlength' => 15, 'tl_class' => 'w50'),
            'sql'       => "decimal(12,2) NOT NULL default '0.00'"
        ),
        'condition'             => array
        (
            'exclude'   => true,
            'inputType' => 'select',
            'options'   => array
            (
                'new',
                'renovated',
                'partially_renovated',
                'maintained',
            ),
            'reference' => &$GLOBALS['TL_LANG']['REF']['re_condition'],
            'eval'      => array('mandatory' => false, 'includeBlankOption' => true, 'tl_class' => 'w50'),
            'sql'       => "varchar(32) NOT NULL default ''"
        ),
        'constructionYear'      => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'digit', 'maxlength' => 4, 'tl_class' => 'w50'),
            'sql'       => "varchar(4) NOT NULL default ''"
        ),
        'cooperativeShares'     => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'natural', 'maxlength' => 2, 'tl_class' => 'w50'),
            'sql'       => "tinyint(2) unsigned NULL"
        ),
        'deposit'     => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'maxlength' => 64, 'tl_class' => 'w50'),
            'sql'       => "varchar(64) unsigned NULL"
        ),
        'entitlementCertificate'             => array
        (
            'exclude'   => true,
            'inputType' => 'checkbox',
            'eval'      => array('mandatory' => false, 'tl_class' => 'm12 w50'),
            'sql'       => "char(1) NOT NULL default ''"
        ),
        'features'              => array
        (
            'exclude'   => true,
            'inputType' => 'checkbox',
            'options'   => array_keys($GLOBALS['TL_LANG']['REF']['re_features']),
            'reference' => &$GLOBALS['TL_LANG']['REF']['re_features'],
            'eval'      => array('mandatory' => false, 'multiple' => true, 'tl_class' => 'w50'),
            'sql'       => "blob NULL"
        ),
        'parking'              => array
        (
            'exclude'   => true,
            'inputType' => 'checkbox',
            'options'   => array_keys($GLOBALS['TL_LANG']['REF']['re_parking']),
            'reference' => &$GLOBALS['TL_LANG']['REF']['re_parking'],
            'eval'      => array('mandatory' => false, 'multiple' => true, 'tl_class' => 'w50'),
            'sql'       => "blob NULL"
        ),
        'heatingType'           => array
        (
            'exclude'   => true,
            'inputType' => 'select',
            'options'   => array
            (
                'geh',
                'fw',
                'zh',
                'gzh',
                'nsp',
                'go',
                'pellets',
                'oil'
            ),
            'reference' => &$GLOBALS['TL_LANG']['REF']['re_heatingType'],
            'eval'      => array('mandatory' => false, 'includeBlankOption' => true, 'tl_class' => 'w50'),
            'sql'       => "varchar(16) NOT NULL default ''"
        ),
        'energyPassType'        => array
        (
            'exclude'   => true,
            'inputType' => 'select',
            'options'   => array
            (
                'eav',
                'eab',
            ),
            'reference' => &$GLOBALS['TL_LANG']['REF']['re_energyPassType'],
            'eval'      => array('mandatory' => false, 'includeBlankOption' => true, 'tl_class' => 'clr w50'),
            'sql'       => "varchar(16) NOT NULL default ''"
        ),
        'energyConsumption'     => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'digit', 'maxlength' => 6, 'tl_class' => 'w50'),
            'sql'       => "float(6,2) NOT NULL default 0.00"
        ),
        'gallerySRC'            => array
        (
            'exclude'   => true,
            'inputType' => 'fileTree',
            'eval'      => array('mandatory' => true, 'filesOnly' => true, 'fieldType' => 'checkbox', 'multiple' => true, 'tl_class' => 'clr', 'orderField' => 'orderSRC', 'files' => true, 'extensions' => \Contao\Config::get('validImageTypes'), 'isGallery' => true),
            'sql'       => "blob NULL"
        ),
        'orderSRC'              => array
        (
            'label' => &$GLOBALS['TL_LANG']['MSC']['sortOrder'],
            'sql'   => "blob NULL"
        ),
        'floorPlansSRC'         => array
        (
            'exclude'   => true,
            'inputType' => 'fileTree',
            'eval'      => array('filesOnly' => true, 'fieldType' => 'checkbox', 'multiple' => true, 'tl_class' => 'clr', 'orderField' => 'floorPlansOrderSRC', 'files' => true, 'extensions' => \Contao\Config::get('validImageTypes'), 'isGallery' => true),
            'sql'       => "blob NULL"
        ),
        'floorPlansOrderSRC'    => array
        (
            'label' => &$GLOBALS['TL_LANG']['MSC']['sortOrder'],
            'sql'   => "blob NULL"
        ),
        'availability'          => array
        (
            'exclude'   => true,
            'inputType' => 'radio',
            'options'   => array
            (
                'immediately',
                'from'
            ),
            'reference' => &$GLOBALS['TL_LANG']['REF']['re_availability'],
            'eval'      => array('mandatory' => false, 'tl_class' => 'w50', 'submitOnChange' => true),
            'sql'       => "varchar(16) NOT NULL default 'immediately'"
        ),
        'availableFrom'         => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('mandatory' => false, 'rgxp' => 'date', 'datepicker' => true, 'tl_class' => 'w50 wizard'),
            'sql'       => "int(10) unsigned NULL"
        ),
        'description'           => array
        (
            'exclude'     => true,
            'inputType'   => 'textarea',
            'eval'        => array('mandatory' => false, 'rte' => 'tinyMCE', 'helpwizard' => true, 'tl_class' => 'clr'),
            'explanation' => 'insertTags',
            'sql'         => "mediumtext NULL"
        ),
        'published'             => array
        (
            'exclude'   => true,
            'filter'    => true,
            'inputType' => 'checkbox',
            'eval'      => array('doNotCopy' => true),
            'sql'       => "char(1) NOT NULL default ''"
        ),
        'start'                 => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('rgxp' => 'datim', 'datepicker' => true, 'tl_class' => 'w50 wizard'),
            'sql'       => "varchar(10) NOT NULL default ''"
        ),
        'stop'                  => array
        (
            'exclude'   => true,
            'inputType' => 'text',
            'eval'      => array('rgxp' => 'datim', 'datepicker' => true, 'tl_class' => 'w50 wizard'),
            'sql'       => "varchar(10) NOT NULL default ''"
        )
    )
);
