src/Rhyme/WMassArtsHub/Resources/contao/dca/tl_artshub_submission_space.php line 330

Open in your IDE?
  1. <?php
  3. /**
  4.  * Copyright (c) 2020 Rhyme Digital LLC (https://rhyme.digital)
  5.  *
  6.  * @license LGPL-3.0-or-later
  7.  */
  9. namespace {
  11.     use Rhyme\WMassArtsHub\Backend\SubmissionSpace\Callbacks;
  12.     use Contao\System;
  14.     System::loadLanguageFile('default');
  16.     /**
  17.      * Table tl_artshub_submission_space
  18.      */
  19.     $GLOBALS['TL_DCA']['tl_artshub_submission_space'] = array
  20.     (
  22.         // Config
  23.         'config' => array
  24.         (
  25.             'dataContainer'               => 'Table',
  26.             'enableVersioning'            => true,
  27.             'sql' => array
  28.             (
  29.                 'keys' => array
  30.                 (
  31.                     'id' => 'primary',
  32.                 )
  33.             )
  34.         ),
  36.         // List
  37.         'list' => array
  38.         (
  39.             'sorting' => array
  40.             (
  41.                 'mode'                    => 2,
  42.                 'flag'                    => 8,
  43.                 'fields'                  => ['space_available_date'],
  44.                 'panelLayout'             => 'sort,filter;search,limit'
  45.             ),
  46.             'label' => array
  47.             (
  48.                 'fields'                  => array('title'),
  49.                 'format'                  => '%s'
  50.             ),
  51.             'global_operations' => array
  52.             (
  53.                 'all' => array
  54.                 (
  55.                     'label'               => &$GLOBALS['TL_LANG']['MSC']['all'],
  56.                     'href'                => 'act=select',
  57.                     'class'               => 'header_edit_all',
  58.                     'attributes'          => 'onclick="Backend.getScrollOffset()" accesskey="e"'
  59.                 )
  60.             ),
  61.             'operations' => array
  62.             (
  63.                 'edit' => array
  64.                 (
  65.                     'label'               => &$GLOBALS['TL_LANG']['tl_artshub_submission_space']['edit'],
  66.                     'href'                => 'act=edit',
  67.                     'icon'                => 'edit.gif'
  68.                 ),
  69.                 'copy' => array
  70.                 (
  71.                     'label'               => &$GLOBALS['TL_LANG']['tl_artshub_submission_space']['copy'],
  72.                     'href'                => 'act=copy',
  73.                     'icon'                => 'copy.gif',
  74.                 ),
  75.                 'cut' => array
  76.                 (
  77.                     'label'               => &$GLOBALS['TL_LANG']['tl_page']['cut'],
  78.                     'href'                => 'act=paste&amp;mode=cut',
  79.                     'icon'                => 'cut.svg',
  80.                     'attributes'          => 'onclick="Backend.getScrollOffset()"',
  81.                 ),
  82.                 'delete' => array
  83.                 (
  84.                     'label'               => &$GLOBALS['TL_LANG']['tl_artshub_submission_space']['delete'],
  85.                     'href'                => 'act=delete',
  86.                     'icon'                => 'delete.gif',
  87.                     'attributes'          => 'onclick="if(!confirm(\'' . $GLOBALS['TL_LANG']['MSC']['deleteConfirm'] . '\'))return false;Backend.getScrollOffset()"',
  88.                 ),
  89.                 'toggle' => array
  90.                 (
  91.                     'label'               => &$GLOBALS['TL_LANG']['tl_artshub_submission_space']['toggle'],
  92.                     'icon'                => 'visible.svg',
  93.                     'attributes'          => 'onclick="Backend.getScrollOffset();return AjaxRequest.toggleVisibility(this,%s)"',
  94.                     'button_callback'     => array(Callbacks::class, 'toggleIcon')
  95.                 ),
  96.                 'show' => array
  97.                 (
  98.                     'label'               => &$GLOBALS['TL_LANG']['tl_artshub_submission_space']['show'],
  99.                     'href'                => 'act=show',
  100.                     'icon'                => 'show.gif'
  101.                 )
  102.             )
  103.         ),
  105.         // Palettes
  106.         'palettes' => array
  107.         (
  108.             'default'                     => '{general_legend},title,alias,submissionDate,space_type,submitted_by,status;{details_legend},description,space_price,space_size,space_available_date,profiles;{contact_legend},contact_name,contact_phone,contact_email,contact_url;{location_legend},street,street_2,city,state,postal,latitude,longitude;{images_legend},images;{publishing_legend},published,start,stop;'
  109.         ),
  111.         // Subpalettes
  112.         'subpalettes' => array
  113.         (
  114.         ),
  116.         // Fields
  117.         'fields' => array
  118.         (
  119.             'id' => array
  120.             (
  121.                 'sql'                     => "int(10) unsigned NOT NULL auto_increment"
  122.             ),
  123.             'tstamp' => array
  124.             (
  125.                 'sql'                     => "int(10) unsigned NOT NULL default '0'"
  126.             ),
  127.             'lead_id' => array
  128.             (
  129.                 'sql'                     => "int(10) unsigned NOT NULL default '0'"
  130.             ),
  131.             'submissionDate' => array
  132.             (
  133.                 'exclude'                 => true,
  134.                 'inputType'               => 'text',
  135.                 'eval'                    => array('rgxp'=>'date', 'mandatory'=>true, 'doNotCopy'=>true, 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
  136.                 'sql'                     => "int(10) unsigned NULL"
  137.             ),
  138.             'title' => array
  139.             (
  140.                 'exclude'                 => true,
  141.                 'search'                  => true,
  142.                 'inputType'               => 'text',
  143.                 'eval'                    => array('mandatory'=>true, 'maxlength'=>255, 'tl_class'=>'w50'),
  144.                 'sql'                     => "varchar(255) NOT NULL default ''"
  145.             ),
  146.             'alias' => array
  147.             (
  148.                 'exclude'                 => true,
  149.                 'inputType'               => 'text',
  150.                 'eval'                    => array('rgxp'=>'alias', 'doNotCopy'=>true, 'maxlength'=>128, 'tl_class'=>'w50'),
  151.                 'save_callback' => array
  152.                 (
  153.                     array(Callbacks::class, 'generateAlias')
  154.                 ),
  155.                 'sql'                     => "varchar(128) BINARY NOT NULL default ''"
  156.             ),
  157.             'space_type' => array
  158.             (
  159.                 'exclude' => true,
  160.                 'default' => '',
  161.                 'filter' => true,
  162.                 'inputType' => 'select',
  163.                 'options' => array('space_needed', 'space_available'),
  164.                 'reference' => $GLOBALS['TL_LANG']['tl_artshub_submission_space'],
  165.                 'eval' => array('tl_class' => 'w50 clr'),
  166.                 'sql' => "varchar(32) NOT NULL default ''"
  167.             ),
  168.             'submitted_by' => array
  169.             (
  170.                 'exclude' => true,
  171.                 'search' => true,
  172.                 'inputType' => 'text',
  173.                 'eval' => array('doNotCopy' => true, 'tl_class' => 'w50 clr'),
  174.                 'sql' => "varchar(255) NOT NULL default ''",
  175.             ),
  176.             'status' => array
  177.             (
  178.                 'exclude' => true,
  179.                 'default' => '',
  180.                 'filter' => true,
  181.                 'inputType' => 'select',
  182.                 'options' => array('', 'approved', 'rejected'),
  183.                 'reference' => $GLOBALS['TL_LANG']['MSC']['status_options'],
  184.                 'eval' => array('tl_class' => 'w50', 'readonly' => true, 'disabled' => true),
  185.                 'sql' => "varchar(32) NOT NULL default ''"
  186.             ),
  187.             'profiles' => array
  188.             (
  189.                 'exclude' => true,
  190.                 'search' => true,
  191.                 'filter' => true,
  192.                 'inputType' => 'artshubProfileItemSelector',
  193.                 'foreignKey' => 'tl_artshub_profile_item.name',
  194.                 'eval' => array('multiple' => true, 'chosen' => true, 'includeBlankOption' => true, 'tl_class' => 'w50'),
  195.                 'sql' => "blob NULL",
  196.                 'relation' => array('type' => 'hasMany', 'load' => 'lazy'),
  197.             ),
  198.             'contact_name' => array
  199.             (
  200.                 'exclude' => true,
  201.                 'search' => true,
  202.                 'inputType' => 'text',
  203.                 'eval' => array('maxlength' => 255, 'tl_class' => 'w50'),
  204.                 'sql' => "varchar(128) NOT NULL default ''"
  205.             ),
  206.             'contact_phone' => array
  207.             (
  208.                 'exclude' => true,
  209.                 'search' => true,
  210.                 'inputType' => 'text',
  211.                 'eval' => array('maxlength' => 255, 'tl_class' => 'w50'),
  212.                 'sql' => "varchar(32) NOT NULL default ''"
  213.             ),
  214.             'contact_email' => array
  215.             (
  216.                 'exclude' => true,
  217.                 'search' => true,
  218.                 'inputType' => 'text',
  219.                 'eval' => array('maxlength' => 255, 'tl_class' => 'w50'),
  220.                 'sql' => "varchar(255) NOT NULL default ''"
  221.             ),
  222.             'contact_url' => array
  223.             (
  224.                 'exclude' => true,
  225.                 'search' => true,
  226.                 'inputType' => 'text',
  227.                 'eval' => array('maxlength' => 255, 'tl_class' => 'w50'),
  228.                 'sql' => "varchar(255) NOT NULL default ''"
  229.             ),
  230.             'space_price' => array
  231.             (
  232.                 'exclude' => true,
  233.                 'search' => true,
  234.                 'inputType' => 'text',
  235.                 'eval' => array('maxlength' => 255, 'tl_class' => 'w50'),
  236.                 'sql' => "varchar(32) NOT NULL default ''"
  237.             ),
  238.             'space_size' => array
  239.             (
  240.                 'exclude' => true,
  241.                 'search' => true,
  242.                 'inputType' => 'text',
  243.                 'eval' => array('maxlength' => 255, 'tl_class' => 'w50'),
  244.                 'sql' => "varchar(32) NOT NULL default ''"
  245.             ),
  246.             'space_available_date' => array
  247.             (
  248.                 'exclude'                 => true,
  249.                 'inputType'               => 'text',
  250.                 'eval'                    => array('rgxp'=>'date', 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
  251.                 'sql'                     => "int(10) unsigned NULL"
  252.             ),
  253.             'description' => array
  254.             (
  255.                 'exclude'                 => true,
  256.                 'search'                  => true,
  257.                 'inputType'               => 'textarea',
  258.                 'eval'                    => array('mandatory'=>true, 'rte'=>'tinyMCE', 'helpwizard'=>true),
  259.                 'attributes'              => array('fe_search'=>true),
  260.                 'explanation'             => 'insertTags',
  261.                 'sql'                     => "mediumtext NULL"
  262.             ),
  263.             'street' => array
  264.             (
  265.                 'exclude'                 => true,
  266.                 'search'                  => true,
  267.                 'inputType'               => 'text',
  268.                 'eval'                    => array('maxlength'=>255, 'tl_class'=>'w50'),
  269.                 'sql'                     => "varchar(255) NOT NULL default ''"
  270.             ),
  271.             'postal' => array
  272.             (
  273.                 'exclude'                 => true,
  274.                 'search'                  => true,
  275.                 'inputType'               => 'text',
  276.                 'eval'                    => array('maxlength'=>32,  'tl_class'=>'w50'),
  277.                 'sql'                     => "varchar(32) NOT NULL default ''"
  278.             ),
  279.             'city' => array
  280.             (
  281.                 'exclude'                 => true,
  282.                 'filter'                  => true,
  283.                 'search'                  => true,
  284.                 'sorting'                 => true,
  285.                 'inputType'               => 'text',
  286.                 'default'                 => '',
  287.                 'eval'                    => array('maxlength'=>255, 'tl_class'=>'w50'),
  288.                 'sql'                     => "varchar(255) NOT NULL default ''"
  289.             ),
  290.             'county' => array
  291.             (
  292.                 'exclude'                 => true,
  293.                 'filter'                  => true,
  294.                 'search'                  => true,
  295.                 'sorting'                 => true,
  296.                 'inputType'               => 'text',
  297.                 'default'                 => '',
  298.                 'eval'                    => array('maxlength'=>255, 'tl_class'=>'w50'),
  299.                 'sql'                     => "varchar(255) NOT NULL default ''"
  300.             ),
  301.             'state' => array
  302.             (
  303.                 'exclude'                 => true,
  304.                 'sorting'                 => true,
  305.                 'inputType'               => 'text',
  306.                 'default'                 => 'MA',
  307.                 'eval'                    => array('maxlength'=>2, 'tl_class'=>'w50'),
  308.                 'sql'                     => "varchar(2) NOT NULL default ''"
  309.             ),
  310.             'latitude' => array
  311.             (
  312.                 'exclude'                 => true,
  313.                 'search'                  => true,
  314.                 'inputType'               => 'text',
  315.                 'eval'                    => array('maxlength'=>255, 'tl_class'=>'w50' ),
  316.                 'sql'                     => "varchar(255) NOT NULL default ''"
  317.             ),
  318.             'longitude' => array
  319.             (
  320.                 'exclude'                 => true,
  321.                 'search'                  => true,
  322.                 'inputType'               => 'text',
  323.                 'eval'                    => array('maxlength'=>255, 'tl_class'=>'w50' ),
  324.                 'sql'                     => "varchar(255) NOT NULL default ''"
  325.             ),
  326.             'images' => array
  327.             (
  328.                 'exclude'                 => true,
  329.                 'inputType'               => 'fileTree',
  330.                 'eval'                    => array('multiple'=>true, 'fieldType'=>'checkbox', 'orderField'=>'orderImages', 'files'=>true, 'isGallery'=>true, 'extensions'=>\Contao\Config::get('validImageTypes'), 'tl_class'=>'clr', 'path'=>\Contao\Config::get('uploadPath').'/media'),
  331.                 'sql'                     => "blob NULL",
  332.             ),
  333.             'orderImages' => array
  334.             (
  335.                 'label'                   => &$GLOBALS['TL_LANG']['MSC']['sortOrder'],
  336.                 'sql'                     => "blob NULL"
  337.             ),
  338.             'published' => array
  339.             (
  340.                 'exclude'                 => true,
  341.                 'filter'                  => true,
  342.                 'inputType'               => 'checkbox',
  343.                 'eval'                    => array('tl_class'=>'w50 m12'),
  344.                 'sql'                     => "char(1) NOT NULL default ''"
  345.             ),
  346.             'start' => array
  347.             (
  348.                 'exclude'                 => true,
  349.                 'inputType'               => 'text',
  350.                 'eval'                    => array('rgxp'=>'datim', 'datepicker'=>true, 'tl_class'=>'clr w50 wizard'),
  351.                 'sql'                     => "varchar(10) NOT NULL default ''"
  352.             ),
  353.             'stop' => array
  354.             (
  355.                 'exclude'                 => true,
  356.                 'inputType'               => 'text',
  357.                 'eval'                    => array('rgxp'=>'datim', 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
  358.                 'sql'                     => "varchar(10) NOT NULL default ''"
  359.             ),
  360.         )
  361.     );
  363. }