vendor/con4gis/maps/Resources/contao/dca/tl_c4g_maps.php line 23

Open in your IDE?
  1. <?php if (!defined('TL_ROOT')) die('You cannot access this file directly!');
  3. /**
  4.  * con4gis - the gis-kit
  5.  *
  6.  * @version   php 7
  7.  * @package   con4gis
  8.  * @author    con4gis contributors (see "authors.txt")
  9.  * @license   GNU/LGPL http://opensource.org/licenses/lgpl-3.0.html
  10.  * @copyright Küstenschmiede GmbH Software & Design 2011 - 2018
  11.  * @link      https://www.kuestenschmiede.de
  12.  */
  14. /**
  15.  * Table tl_c4g_maps
  16.  */
  17. $GLOBALS['TL_DCA']['tl_c4g_maps'] = array
  18. (
  20.     // Config
  21.     'config' => array
  22.     (
  23.         'label'                       => $GLOBALS['TL_LANG']['MOD']['c4g_maps'][0],
  24.         'dataContainer'               => 'Table',
  25.         'enableVersioning'            => true,
  26.         'onload_callback'             => array(
  27.             array('tl_c4g_maps', 'updateDCA')),
  28.         'onsubmit_callback'             => array(
  29.             array('\con4gis\CoreBundle\Resources\contao\classes\C4GAutomator', 'purgeApiCache')
  30.         ),
  31.         'sql'                         => array
  32.         (
  33.             'keys' => array
  34.             (
  35.                 'id' => 'primary',
  36.                 'pid' => 'index'
  37.             )
  38.         )
  39.     ),
  41.     // List
  42.     'list' => array
  43.     (
  44.         'sorting' => array
  45.         (
  46.             'mode'                    => 5,
  47.             'icon'                    => 'bundels/con4gisMapsBundle/images/core.png',
  48.             'fields'                  => array('name'),
  49.             'flag'                    => 1
  50.         ),
  51.         'label' => array
  52.         (
  53.             'fields'                  => array('name'),
  54.             'format'                  => '%s',
  55.             'label_callback'          => array('tl_c4g_maps','generateLabel')
  56.         ),
  57.         'global_operations' => array
  58.         (
  59. //            'update_db' => array
  60. //            (
  61. //                'label'               => &$GLOBALS['TL_LANG']['c4g_maps']['update_db'],
  62. //                'href'                => 'key=update_db',
  63. //                'class'               => 'navigation',
  64. //                'attributes'          => 'onclick="Backend.getScrollOffset();" accesskey="i"'
  65. //            ),
  66.             'all' => array
  67.             (
  68.                 'label'               => &$GLOBALS['TL_LANG']['MSC']['all'],
  69.                 'href'                => 'act=select',
  70.                 'class'               => 'header_edit_all',
  71.                 'attributes'          => 'onclick="Backend.getScrollOffset();" accesskey="e"'
  72.             )
  73.         ),
  74.         'operations' => array
  75.         (
  76.             'edit' => array
  77.             (
  78.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['edit'],
  79.                 'href'                => 'act=edit',
  80.                 'icon'                => 'edit.gif'
  81.             ),
  82.             'copy' => array
  83.             (
  84.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['copy'],
  85.                 'href'                => 'act=copy',
  86.                 'icon'                => 'copy.gif'
  87.             ),
  88.             'copyChilds' => array
  89.             (
  90.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['copyChilds'],
  91.                 'href'                => 'act=paste&amp;mode=copy&amp;childs=1',
  92.                 'icon'                => 'copychilds.gif',
  93.                 'attributes'          => 'onclick="Backend.getScrollOffset();"',
  94.                 'button_callback'     => array('tl_c4g_maps', 'copyPageWithSubpages')
  95.             ),
  96.             'cut' => array
  97.             (
  98.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cut'],
  99.                 'href'                => 'act=paste&amp;mode=cut',
  100.                 'icon'                => 'cut.gif',
  101.                 'attributes'          => 'onclick="Backend.getScrollOffset();"'
  102.             ),
  103.             'delete' => array
  104.             (
  105.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['delete'],
  106.                 'href'                => 'act=delete',
  107.                 'icon'                => 'delete.gif',
  108.                 'attributes'          => 'onclick="if (!confirm(\'' . $GLOBALS['TL_LANG']['MSC']['deleteConfirm'] . '\')) return false; Backend.getScrollOffset();"'
  109.             ),
  110.             'toggle' => array
  111.             (
  112.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['toggle'],
  113.                 'icon'                => 'visible.gif',
  114.                 'attributes'          => 'onclick="Backend.getScrollOffset(); return AjaxRequest.toggleVisibility(this, %s);"',
  115.                 'button_callback'     => array('tl_c4g_maps', 'toggleIcon')
  116.             ),
  117.             'show' => array
  118.             (
  119.                 'label'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['show'],
  120.                 'href'                => 'act=show',
  121.                 'icon'                => 'show.gif'
  122.             )
  123.         )
  124.     ),
  126.     // Palettes
  127.     'palettes' => array
  128.     (
  129.         '__selector__'                => array( 'is_map', 'profile','location_type', 'tab_source', 'show_locations', 'popup_extend', 'protect_element', 'use_specialprofile', 'cluster_locations'),
  130.         'default'                     => '{general_legend},name,profile,profile_mobile,published;'.
  131.                                          '{map_legend},is_map;'.
  132.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,cssClass,zoom_locations, hover_location,loc_minzoom,loc_maxzoom;'.
  133.                                          '{protection_legend:hide},protect_element;'.
  134.                                          '{expert_legend:hide},use_specialprofile;'.
  135.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  136.         'single'                      => '{general_legend},name,profile,profile_mobile,published;'.
  137.                                          '{map_legend},is_map;'.
  138.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,loc_geox,loc_geoy,locstyle,loc_only_in_parent,loc_label,tooltip, tooltip_length,enablePopup,showPopupOnActive,popup_info,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  139.                                          '{protection_legend:hide},protect_element;'.
  140.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  141.         'table'                      =>  '{general_legend},name,profile,profile_mobile,published;'.
  142.                                          '{map_legend},is_map;'.
  143.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,tab_source,tab_pid,tab_pid1,tab_labeldisplay,tab_tooltipdisplay,tab_directlink,tab_force_target_blank,tab_whereclause,tab_orderby,tab_filter_alias,locstyle,routing_to,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,cluster_locations,async_content,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  144.                                          '{protection_legend:hide},protect_element;'.
  145.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  146.         'gpx'                        =>  '{general_legend},name,profile,profile_mobile,published;'.
  147.                                          '{map_legend},is_map;'.
  148.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,data_file,data_url,locstyle,loc_label,tooltip, tooltip_length,enablePopup,popup_info,popup_async,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  149.                                          '{protection_legend:hide},protect_element;'.
  150.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  151.         'kml'                        =>  '{general_legend},name,profile,profile_mobile,published;'.
  152.                                          '{map_legend},is_map;'.
  153.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,data_file,data_url,loc_label,tooltip, tooltip_length,enablePopup,popup_info,popup_async,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  154.                                          '{protection_legend:hide},protect_element;'.
  155.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  156.         'geojson'                    =>  '{general_legend},name,profile,profile_mobile,published;'.
  157.                                          '{map_legend},is_map;'.
  158.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,data_file,data_url,data_content,data_projection,locstyle,loc_label,tooltip, tooltip_length,enablePopup,popup_info,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  159.                                          '{protection_legend:hide},protect_element;'.
  160.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  161.         'osm'                        =>  '{general_legend},name,profile,profile_mobile,published;'.
  162.                                          '{map_legend},is_map;'.
  163.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,data_file,data_url,data_forcenodes,locstyle,loc_label,tooltip, tooltip_length,enablePopup,popupType,popup_info,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,cluster_locations,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  164.                                          '{protection_legend:hide},protect_element;'.
  165.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  166.         'overpass'                   =>  '{general_legend},name,profile,profile_mobile,published;'.
  167.                                          '{map_legend},is_map;'.
  168.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,ovp_request,ovp_bbox_limited,data_forcenodes,data_additionalgeometries,locstyle,loc_label,tooltip, tooltip_length,enablePopup,popupType,popup_info,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,cluster_locations,zoom_locations, hover_location,hide_when_in_tab,cssClass;'.
  169.                                          '{protection_legend:hide},protect_element;'.
  170.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  171.         'link'                       =>  '{general_legend},name,profile,profile_mobile,published;'.
  172.                                          '{map_legend},is_map;'.
  173.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,link_id,hide_when_in_tab,cssClass;'.
  174.                                          '{protection_legend:hide},protect_element;'.
  175.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  176.         'c4gForum'                   =>  '{general_legend},name,profile,profile_mobile,published;'.
  177.                                          '{map_legend},is_map;'.
  178.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,forums,forum_jumpto,forum_reassign_layer,loc_label,tooltip, tooltip_length,enablePopup,popup_info,routing_to,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,hide_when_in_tab,cssClass;'.
  179.                                          '{protection_legend:hide},protect_element;'.
  180.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  181.         'startab'                    =>  '{general_legend},name,profile,profile_mobile,published;' .
  182.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,awesomeicon;'.
  183.                                          '{protection_legend:hide},protect_element;'.
  184.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  185.         'folder'                     =>  '{general_legend},name,profile,profile_mobile,published;'.
  186.                                          '{map_legend},is_map;'.
  187.                                          '{location_legend},location_type,data_layername,hide_child,data_hidelayer,data_folder,locstyle,loc_label,tooltip, tooltip_length,enablePopup,popup_info,routing_to,loc_linkurl,loc_onclick_zoomto,loc_minzoom,loc_maxzoom,hide_when_in_tab,cssClass;'.
  188.                                          '{protection_legend:hide},protect_element;'.
  189.                                          '{backend_legend:hide},be_optimize_checkboxes_limit;',
  190.     ),
  192.     // Subpalettes
  193.     'subpalettes' => array
  194.     (
  195.         'use_specialprofile'          => 'specialprofile, specialprofile_mobile, specialprofile_groups',
  196.         //'enablePopup'                 => 'popup_info,routing_to',
  197.         'protect_element'             => 'permitted_groups',
  198.         'popup_extend'                => 'forums',
  199.         'is_map'                      => '',  // is set in updateDCA
  200.         'cluster_locations'           => 'cluster_distance, cluster_fillcolor, cluster_fontcolor, cluster_zoom,cluster_popup'
  201.     ),
  203.     // Fields
  204.     'fields' => array
  205.     (
  206.         'id' => array
  207.         (
  208.             'sql'                     => "int(10) unsigned NOT NULL auto_increment"
  209.         ),
  210.         'pid' => array
  211.         (
  212.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  213.         ),
  214.         'sorting' => array
  215.         (
  216.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  217.         ),
  218.         'tstamp' => array
  219.         (
  220.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  221.         ),
  222.         'name' => array
  223.         (
  224.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['name'],
  225.             'exclude'                 => true,
  226.             'inputType'               => 'c4g_text',
  227.             'eval'                    => array('mandatory'=>true, 'maxlength'=>255 ),
  228.             'sql'                     => "varchar(100) NOT NULL default ''"
  229.         ),
  230.         'profile' => array
  231.         (
  232.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['profile'],
  233.             'exclude'                 => true,
  234.             'inputType'               => 'select',
  235.             'foreignKey'              => 'tl_c4g_map_profiles.name',
  236.             'eval'                    => array('tl_class'=>'w50',
  237.                                                'includeBlankOption'=>true, 'blankOptionLabel'=>&$GLOBALS['TL_LANG']['tl_c4g_maps']['default_profile'],
  238.                                                'submitOnChange' => true, 'alwaysSave' => true ),
  239.             'load_callback'           => array(array('tl_c4g_maps','getDefaultProfile')),
  240.             'relation'                => array('type'=>'belongsTo', 'load'=>'eager'),
  241.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  243.         ),
  244.         'profile_mobile' => array
  245.         (
  246.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['profile_mobile'],
  247.             'exclude'                 => true,
  248.             'inputType'               => 'select',
  249.             'foreignKey'              => 'tl_c4g_map_profiles.name',
  250.             'eval'                    => array('tl_class'=>'w50',
  251.                                                'includeBlankOption'=>true
  252.                                               ),
  253.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  254.         ),
  255.         'published' => array
  256.         (
  257.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['published'],
  258.             'exclude'                 => true,
  259.             'default'                 => true,
  260.             'inputType'               => 'checkbox',
  261.             'eval'                    => array('tl_class'=>'clr'),
  262.             'sql'                     => "char(1) NOT NULL default '1'"
  263.         ),
  264.         'is_map' => array
  265.         (
  266.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['is_map'],
  267.             'exclude'                 => true,
  268.             'default'                 => '',
  269.             'inputType'               => 'checkbox',
  270.             'eval'                    => array('submitOnChange' => true),
  271.             'sql'                     => "char(1) NOT NULL default ''"
  272.         ),
  273.         'width' => array
  274.         (
  275.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['width'],
  276.             'exclude'                 => true,
  277.             'inputType'               => 'inputUnit',
  278.             'options'                 => array('px', '%', 'em', 'vh', 'vw', 'vmin', 'vmax', 'pt', 'pc', 'in', 'cm', 'mm'),
  279.             'eval'                    => array(
  280.                                             'rgxp'=>'digit_auto_inherit',
  281.                                             'tl_class'=>'long',
  282.                                             'includeBlankOption'=>true
  283.                                         ),
  284.             'sql'                     => "varchar(64) NOT NULL default ''"
  285.         ),
  286.         'height' => array
  287.         (
  288.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['height'],
  289.             'exclude'                 => true,
  290.             'inputType'               => 'inputUnit',
  291.             'options'                 => array('px', '%', 'em', 'vh', 'vw', 'vmin', 'vmax', 'pt', 'pc', 'in', 'cm', 'mm'),
  292.             'eval'                    => array(
  293.                                             'rgxp'=>'digit_auto_inherit',
  294.                                             'tl_class'=>'long',
  295.                                             'includeBlankOption'=>true
  296.                                         ),
  297.             'sql'                     => "varchar(64) NOT NULL default ''"
  298.         ),
  299.         'margin' => array
  300.         (
  301.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['margin'],
  302.             'exclude'                 => true,
  303.             'inputType'               => 'trbl',
  304.             'options'                 => array('px', '%', 'em', 'vh', 'vw', 'vmin', 'vmax', 'pt', 'pc', 'in', 'cm', 'mm'),
  305.             'eval'                    => array(
  306.                                             'rgxp'=>'digit_auto_inherit',
  307.                                             'includeBlankOption'=>true
  308.                                         ),
  309.             'sql'                     => "varchar(128) NOT NULL default ''"
  310.         ),
  311.         // 'auto_width' => array
  312.         // (
  313.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_width'],
  314.         //  'exclude'                 => true,
  315.         //  'default'                 => '',
  316.         //  'inputType'               => 'checkbox',
  317.         //  'eval'                    => array('submitOnChange' => true, 'tl_class'=>'w50' )
  318.         // ),
  319.         // 'auto_width_min' => array
  320.         // (
  321.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_width_min'],
  322.         //  'exclude'                 => true,
  323.         //  'inputType'               => 'c4g_text',
  324.         //     'default'                 => '0',
  325.         //  'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'w50')
  326.         // ),
  327.         // 'auto_width_max' => array
  328.         // (
  329.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_width_max'],
  330.         //  'exclude'                 => true,
  331.         //  'inputType'               => 'c4g_text',
  332.         //     'default'                 => '0',
  333.         //  'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'w50')
  334.         // ),
  335.         // 'auto_width_gap' => array
  336.         // (
  337.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_width_gap'],
  338.         //  'exclude'                 => true,
  339.         //  'inputType'               => 'c4g_text',
  340.         //     'default'                 => '0',
  341.         //  'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'w50')
  342.         // ),
  343.         // 'auto_height' => array
  344.         // (
  345.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_height'],
  346.         //  'exclude'                 => true,
  347.         //  'default'                 => '',
  348.         //  'inputType'               => 'checkbox',
  349.         //  'eval'                    => array('submitOnChange' => true, 'tl_class'=>'w50' )
  350.         // ),
  351.         // 'auto_height_min' => array
  352.         // (
  353.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_height_min'],
  354.         //  'exclude'                 => true,
  355.         //  'inputType'               => 'c4g_text',
  356.         //     'default'                 => '0',
  357.         //  'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'w50')
  358.         // ),
  359.         // 'auto_height_max' => array
  360.         // (
  361.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_height_max'],
  362.         //  'exclude'                 => true,
  363.         //  'inputType'               => 'c4g_text',
  364.         //     'default'                 => '0',
  365.         //  'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'w50')
  366.         // ),
  367.         // 'auto_height_gap' => array
  368.         // (
  369.         //  'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['auto_height_gap'],
  370.         //  'exclude'                 => true,
  371.         //  'inputType'               => 'c4g_text',
  372.         //     'default'                 => '0',
  373.         //  'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'w50')
  374.         // ),
  375.         'calc_extent' => array
  376.         (
  377.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['calc_extent'],
  378.             'exclude'                 => true,
  379.             'inputType'               => 'select',
  380.             'options'                 => array('LOCATIONS','CENTERZOOM'),
  381.             #'default'                 => 'LOCATIONS',
  382.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references'],
  383.             #'eval'                    => array('submitOnChange'=>true,'tl_class'=>'clr'),
  384.             'load_callback'           => array(array('tl_c4g_maps','setOldValue')),
  385.             'sql'                     => "varchar(10) NOT NULL default ''"
  386.         ),
  387.         'show_locations' => array
  388.         (
  389.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['show_locations'],
  390.             'exclude'                 => true,
  391.             'inputType'               => 'checkbox',
  392.             'default'                 => '0',
  393.             'eval'                    => array('submitOnChange'=>true,'tl_class'=>'clr'),
  394.             'load_callback'           => array(array('tl_c4g_maps','getOldValue')),
  396.             'sql'                     => "char(1) NOT NULL default '2'"
  397.         ),
  398.         'min_gap' => array
  399.         (
  400.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['min_gap'],
  401.             'exclude'                 => true,
  402.             'inputType'               => 'c4g_text',
  403.             'default'                 => '0',
  404.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  405.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  406.         ),
  407.         'awesomeicon' => array
  408.         (
  409.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['awesomeicon'],
  410.             'exclude'                 => true,
  411.             'inputType'               => 'c4g_text',
  412.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'clr'),
  413.             'sql'                     => "varchar(20) NOT NULL default ''"
  414.         ),
  415.         'center_geox' => array
  416.         (
  417.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['center_geox'],
  418.             'exclude'                 => true,
  419.             'inputType'               => 'c4g_text',
  420.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'w50 wizard', 'require_input'=>true ),
  421.             'save_callback'           => array(array('tl_c4g_maps','setCenterLon')),
  422.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  423.             'sql'                     => "varchar(20) NOT NULL default ''"
  424.         ),
  425.         'center_geoy' => array
  426.         (
  427.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['center_geoy'],
  428.             'exclude'                 => true,
  429.             'inputType'               => 'c4g_text',
  430.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'w50 wizard', 'require_input'=>true),
  431.             'save_callback'           => array(array('tl_c4g_maps','setCenterLat')),
  432.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  433.             'sql'                     => "varchar(20) NOT NULL default ''"
  434.         ),
  435.         'zoom' => array
  436.         (
  437.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['zoom'],
  438.             'exclude'                 => true,
  439.             'inputType'               => 'c4g_text',
  440.             'default'                 => '10',
  441.             'eval'                    => array('tl_class'=>'clr'),
  442.             'sql'                     => "varchar(20) NOT NULL default '10'"
  443.         ),
  444.         'geolocation' => array
  445.         (
  446.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['geolocation'],
  447.             'exclude'                 => true,
  448.             'default'                 => false,
  449.             'inputType'               => 'checkbox',
  450.             'eval'                    => array('submitOnChange' => true),
  451.             'sql'                     => "char(1) NOT NULL default ''"
  452.         ),
  453.         'geolocation_zoom' => array
  454.         (
  455.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['geolocation_zoom'],
  456.             'exclude'                 => true,
  457.             'inputType'               => 'c4g_text',
  458.             'default'                 => '16',
  459.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  460.             'sql'                     => "int(10) unsigned NOT NULL default '16'"
  461.         ),
  462.         'hide_when_in_tab' => array
  463.         (
  464.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['hide_when_in_tab'],
  465.             'exclude'                 => true,
  466.             'default'                 => false,
  467.             'inputType'               => 'checkbox',
  468.             'sql'                     => "char(1) NOT NULL default ''"
  469.         ),
  470.         'restrict_area' => array
  471.         (
  472.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['restrict_area'],
  473.             'exclude'                 => true,
  474.             'default'                 => false,
  475.             'inputType'               => 'checkbox',
  476.             'eval'                    => array('submitOnChange' => true),
  477.             'sql'                     => "char(1) NOT NULL default ''"
  478.         ),
  479.         'restr_bottomleft_geox' => array
  480.         (
  481.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['restr_bottomleft_geox'],
  482.             'exclude'                 => true,
  483.             'inputType'               => 'c4g_text',
  484.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'w50 wizard', 'require_input'=>true ),
  485.             'save_callback'           => array(array('tl_c4g_maps','setRestrLon')),
  486.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  487.             'sql'                     => "varchar(20) NOT NULL default ''"
  488.         ),
  489.         'restr_bottomleft_geoy' => array
  490.         (
  491.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['restr_bottomleft_geoy'],
  492.             'exclude'                 => true,
  493.             'inputType'               => 'c4g_text',
  494.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'w50 wizard', 'require_input'=>true ),
  495.             'save_callback'           => array(array('tl_c4g_maps','setRestrLat')),
  496.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  497.             'sql'                     => "varchar(20) NOT NULL default ''"
  498.         ),
  499.         'restr_topright_geox' => array
  500.         (
  501.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['restr_topright_geox'],
  502.             'exclude'                 => true,
  503.             'inputType'               => 'c4g_text',
  504.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'w50 wizard', 'require_input'=>true ),
  505.             'save_callback'           => array(array('tl_c4g_maps','setRestrLon')),
  506.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  507.             'sql'                     => "varchar(20) NOT NULL default ''"
  508.         ),
  509.         'restr_topright_geoy' => array
  510.         (
  511.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['restr_topright_geoy'],
  512.             'exclude'                 => true,
  513.             'inputType'               => 'c4g_text',
  514.             'eval'                    => array('maxlength'=>20, 'tl_class'=>'w50 wizard', 'require_input'=>true ),
  515.             'save_callback'           => array(array('tl_c4g_maps','setRestrLat')),
  516.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  517.             'sql'                     => "varchar(20) NOT NULL default ''"
  518.         ),
  519.         'include_sublocations' => array
  520.         (
  521.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['include_sublocations'],
  522.             'exclude'                 => true,
  523.             'default'                 => true,
  524.             'inputType'               => 'checkbox',
  525.             'sql'                     => "char(1) NOT NULL default '1'"
  526.         ),
  527.         'location_type' => array
  528.         (
  529.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['location_type'],
  530.             'exclude'                 => true,
  531.             'default'                 => 'none',
  532.             'inputType'               => 'radio',
  533.             'options_callback'        => array('tl_c4g_maps','getLocationTypes'),
  534.             'eval'                    => array('submitOnChange' => true),
  535.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references'],
  536.             'sql'                     => "char(10) NOT NULL default ''"
  537.         ),
  538.         'loc_geox' => array
  539.         (
  540.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_geox'],
  541.             'exclude'                 => true,
  542.             'inputType'               => 'c4g_text',
  543.             'eval'                    => array('mandatory'=>true, 'maxlength'=>20, 'tl_class'=>'w50 wizard' ),
  544.             'save_callback'           => array(array('tl_c4g_maps','setLocLon')),
  545.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  546.             'sql'                     => "varchar(20) NOT NULL default ''"
  547.         ),
  549.         'loc_geoy' => array
  550.         (
  551.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_geoy'],
  552.             'exclude'                 => true,
  553.             'inputType'               => 'c4g_text',
  554.             'eval'                    => array('mandatory'=>true, 'maxlength'=>20, 'tl_class'=>'w50 wizard'),
  555.             'save_callback'           => array(array('tl_c4g_maps','setLocLat')),
  556.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoPicker', 'getPickerLink')),
  557.             'sql'                     => "varchar(20) NOT NULL default ''"
  558.         ),
  559.         'locstyle' => array
  560.         (
  561.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['locstyle'],
  562.             'exclude'                 => true,
  563.             'inputType'               => 'select',
  564.             'options_callback'        => array('tl_c4g_maps','getLocStyles'),
  565.             'eval'                    => array('tl_class'=>'clr'),
  566.             'wizard' => array
  567.             (
  568.                 array('tl_c4g_maps', 'editLocationStyle')
  569.             ),
  570.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  571.         ),
  572.         'loc_only_in_parent' => array
  573.         (
  574.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_only_in_parent'],
  575.             'exclude'                 => true,
  576.             'default'                 => false,
  577.             'inputType'               => 'checkbox',
  578.             'sql'                     => "char(1) NOT NULL default ''"
  579.         ),
  580.         'loc_label' => array
  581.         (
  582.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_label'],
  583.             'exclude'                 => true,
  584.             'inputType'               => 'c4g_text',
  585.             'sql'                     => "varchar(100) NOT NULL default ''"
  586.         ),
  587.         'tooltip' => array
  588.         (
  589.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tooltip'],
  590.             'exclude'                 => true,
  591.             'inputType'               => 'c4g_text',
  592.             'eval'                    => array('tl_class'=>'long'),
  593.             'sql'                     => "varchar(100) NOT NULL default ''"
  594.         ),
  595.         'tooltip_length' => array
  596.         (
  597.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tooltip_length'],
  598.             'inputType'               => 'c4g_text',
  599.             'default'                 => '30',
  600.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  601.             'sql'                     => "int(100) NOT NULL default '30'"
  602.         ),
  603.         'enablePopup' => array
  604.         (
  605.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['enablePopup'],
  606.             'exclude'                 => true,
  607.             'default'                 => true,
  608.             'inputType'               => 'checkbox',
  609.             'eval'                    => array('submitOnChange' => true),
  610.             'sql'                     => "char(1) NOT NULL default '1'"
  611.         ),
  612.         'popupType' => array
  613.         (
  614.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['popupType'],
  615.             'exclude'                 => true,
  616.             'default'                 => 'text',
  617.             'inputType'               => 'radio',
  618.             'options'                 => array('text','template','popup_info'),
  619.             'eval'                    => array('mandatory'=>true, 'submitOnChange' => true),
  620.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references']['popupType'],
  621.             'sql'                     => "char(10) NOT NULL default 'text'"
  622.         ),
  623.         'popupTemplate' => array
  624.         (
  625.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['popupTemplate'],
  626.             'exclude'                 => true,
  627.             'default'                 => 'popup_default',
  628.             'inputType'               => 'select',
  629.             'options_callback'        => array('tl_c4g_maps', 'getPopupTemplates'),
  630.             'eval'                    => array('mandatore'=>true, 'chosen'=>true),
  631.             'sql'                     => "varchar(64) NOT NULL default ''"
  632.         ),
  633.         'popup_info' => array
  634.         (
  635.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['popup_info'],
  636.             'exclude'                 => true,
  637.             'inputType'               => 'textarea',
  638.             'eval'                    => array('rte'=>'tinyMCE'),
  639.             'sql'                     => "text NULL"
  640.         ),
  641.         'popup_async' => array
  642.         (
  643.             //@Todo Asynchrone Abfrage (GPX,KML) reparieren und einblenden
  644.             #'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['popup_async'],
  645.             #'exclude'                 => true,
  646.             'default'                 => false,
  647.             #'inputType'               => 'checkbox',
  648.             'sql'                     => "char(1) NOT NULL default ''"
  649.         ),
  650.         'popup_extend' => array
  651.         (
  652.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['popup_extend'],
  653.             'exclude'                 => true,
  654.             'default'                 => false,
  655.             'inputType'               => 'checkbox',
  656.             'eval'                    => array('submitOnChange' => true),
  657.             'sql'                     => "char(1) NOT NULL default '0'"
  658.         ),
  659.         'routing_to' => array
  660.         (
  661.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['routing_to'],
  662.             'exclude'                 => true,
  663.             'default'                 => '',
  664.             'inputType'               => 'checkbox',
  665.             'sql'                     => "char(1) NOT NULL default ''"
  666.         ),
  667.         'loc_linkurl' => array
  668.         (
  669.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_linkurl'],
  670.             'exclude'                 => true,
  671.             'inputType'               => 'text',
  672.             'eval'                    => array('rgxp'=>'url', 'decodeEntities'=>true, 'maxlength'=>255, 'tl_class'=>'wizard'),
  673.             'wizard'                  => array(array('tl_c4g_maps', 'pickUrl')),
  674.             'sql'                     => "varchar(255) NOT NULL default ''"
  675.         ),
  676.         'loc_onclick_zoomto' => array
  677.         (
  678.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_onclick_zoomto'],
  679.             'exclude'                 => true,
  680.             'inputType'               => 'c4g_text',
  681.             'default'                 => '0',
  682.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  683.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  684.         ),
  685.         'loc_minzoom' => array
  686.         (
  687.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_minzoom'],
  688.             'exclude'                 => true,
  689.             'inputType'               => 'c4g_text',
  690.             'default'                 => '0',
  691.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  692.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  693.         ),
  694.         'loc_maxzoom' => array
  695.         (
  696.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['loc_maxzoom'],
  697.             'exclude'                 => true,
  698.             'inputType'               => 'c4g_text',
  699.             'default'                 => '0',
  700.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  701.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  702.         ),
  703.         'tab_source' => array
  704.         (
  705.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_source'],
  706.             'exclude'                 => true,
  707.             'inputType'               => 'select',
  708.             'options_callback'        => array('tl_c4g_maps','getTabSources'),
  709.             'eval'                    => array('submitOnChange' => true),
  710.             'sql'                     => "varchar(100) NOT NULL default ''"
  711.         ),
  712.         'async_content' => array
  713.         (
  714.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['async_content'],
  715.             'exclude'                 => true,
  716.             'default'                 => false,
  717.             'inputType'               => 'checkbox',
  718.             'sql'                     => "char(1) NOT NULL default ''"
  719.         ),
  720.         'tab_pid' => array
  721.         (
  722.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_pid'],
  723.             'exclude'                 => true,
  724.             'inputType'               => 'select',
  725.             'options_callback'        => array('tl_c4g_maps','getTabParentList'),
  726.             'sql'                     => "int(10) unsigned NOT NULL default '0'",
  727.             'eval'                    =>  array('tl_class'=>'clr', 'chosen'=>true, 'includeBlankOption' => true)
  728.         ),
  729.         'tab_pid1' => array
  730.         (
  731.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_pid1'],
  732.             'exclude'                 => true,
  733.             'inputType'               => 'select',
  734.             'options_callback'        => array('tl_c4g_maps','getTabParentList1'),
  735.             'sql'                     => "int(10) unsigned NOT NULL default '0'",
  736.             'eval'                    => array('tl_class'=>'clr', 'chosen'=>true, 'includeBlankOption' => true)
  737.         ),
  738. //        'tab_tag' => array
  739. //        (
  740. //            'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_tag'],
  741. //            'exclude'                 => true,
  742. //            'inputType'               => 'select',
  743. //            'options_callback'        => array('tl_c4g_maps','getTabTag'),
  744. //            'sql'                     => "char(10) unsigned NOT NULL default ''",
  745. //            'eval'                    => array('tl_class'=>'clr', 'chosen'=>true, 'includeBlankOption' => true)
  746. //        ),
  747.         'tab_labeldisplay' => array
  748.         (
  749.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_labeldisplay'],
  750.             'exclude'                 => true,
  751.             'inputType'               => 'select',
  752.             'options'                 => array('OFF','1ST','1ST_MORE','1ST_COUNT','ALL'),
  753.             'default'                 => '1ST_MORE',
  754.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references'],
  755.             'sql'                     => "char(10) NOT NULL default '1ST_MORE'"
  756.         ),
  757.         'tab_tooltipdisplay' => array
  758.         (
  759.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_tooltipdisplay'],
  760.             'exclude'                 => true,
  761.             'inputType'               => 'select',
  762.             'options'                 => array('OFF','1ST','1ST_MORE','1ST_COUNT','ALL'),
  763.             'default'                 => '1ST_MORE',
  764.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references'],
  765.             'sql'                     => "char(10) NOT NULL default '1ST_MORE'"
  766.         ),
  767.         'tab_directlink' => array
  768.         (
  769.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_directlink'],
  770.             'exclude'                 => true,
  771.             'default'                 => '',
  772.             'inputType'               => 'checkbox',
  773.             'sql'                     => "char(1) NOT NULL default ''"
  774.         ),
  775.         'tab_force_target_blank' => array
  776.         (
  777.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_force_target_blank'],
  778.             'exclude'                 => true,
  779.             'default'                 => '',
  780.             'inputType'               => 'checkbox',
  781.             'sql'                     => "char(1) NOT NULL default ''"
  782.         ),
  783.         'tab_whereclause' => array
  784.         (
  785.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_whereclause'],
  786.             'exclude'                 => true,
  787.             'inputType'               => 'textarea',
  788.             'eval'                    => array('decodeEntities'=>true), // -> hier werden die HTML Entities deaktiviert
  789.             'sql'                     => "text NULL"
  790.         ),
  791.         'tab_orderby' => array
  792.         (
  793.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_orderby'],
  794.             'exclude'                 => true,
  795.             'inputType'               => 'text',
  796.             'eval'                    => array('maxlength'=>128),
  797.             'sql'                     => "varchar(128) NOT NULL default ''"
  798.         ),
  799.         'tab_filter_alias' => array
  800.         (
  801.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['tab_filter_alias'],
  802.             'exclude'                 => true,
  803.             'default'                 => '',
  804.             'inputType'               => 'checkbox',
  805.             'sql'                     => "char(1) NOT NULL default ''"
  806.         ),
  807.         'data_file' => array
  808.         (
  809.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_file'],
  810.             'exclude'                 => true,
  811.             'inputType'               => 'fileTree',
  812.             'eval'                    => array( 'trailingSlash' => false, 'files' => true, 'fieldType' => 'radio' ),
  813.             'sql'                     => "binary(16) NULL"
  814.         ),
  815.         'data_folder' => array
  816.         (
  817.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_folder'],
  818.             'exclude'                 => true,
  819.             'inputType'               => 'fileTree',
  820.             'eval'                    => array( 'trailingSlash' => false, 'files' => false, 'fieldType' => 'radio' ),
  821.             'sql'                     => "binary(16) NULL"
  822.         ),
  823.         'data_url' => array
  824.         (
  825.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_url'],
  826.             'exclude'                 => true,
  827.             'inputType'               => 'text',
  828.             'eval'                    => array('rgxp'=>'url', 'decodeEntities'=>true, 'maxlength'=>255, 'tl_class'=>'wizard'),
  829.             'wizard'                  => array(array('tl_c4g_maps', 'pickUrl')),
  830.             'sql'                     => "varchar(255) NOT NULL default ''"
  831.         ),
  832.         'data_content' => array
  833.         (
  834.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_content'],
  835.             'exclude'                 => true,
  836.             'inputType'               => 'textarea',
  837.             'eval'                    => array('tl_class'=>'wizard', 'preserve_tags'=>true),
  838.             // 'save_callback'           => array(array('tl_c4g_maps','setLocData')),
  839.             'wizard'                  => array(array('con4gis\MapsBundle\Resources\contao\classes\GeoEditor', 'getEditorLink')),
  840.             'sql'                     => "text NULL"
  841.         ),
  842.         'data_projection' => array
  843.         (
  844.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_projection'],
  845.             'exclude'                 => true,
  846.             'inputType'               => 'select',
  847.             'options'                 => array('MERC','WGS84'),
  848.             'default'                 => 'MERC',
  849.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references'],
  850.             'sql'                     => "char(5) NOT NULL default ''"
  851.         ),
  852.         'data_forcenodes' => array
  853.         (
  854.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_forcenodes'],
  855.             'exclude'                 => true,
  856.             'default'                 => true,
  857.             'inputType'               => 'checkbox',
  858.             'sql'                     => "char(1) NOT NULL default '1'"
  859.         ),
  860.         'data_additionalgeometries' => array
  861.         (
  862.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_additionalgeometries'],
  863.             'exclude'                 => true,
  864.             'default'                 => false,
  865.             'inputType'               => 'checkbox',
  866.             'sql'                     => "char(1) NOT NULL default ''"
  867.         ),
  868.         'data_layername' => array
  869.         (
  870.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_layername'],
  871.             'exclude'                 => true,
  872.             'inputType'               => 'text',
  873.             'eval'                    => array('maxlength'=>254),
  874.             'sql'                     => "varchar(254) NOT NULL default ''"
  875.         ),
  876.         'data_hidelayer' => array
  877.         (
  878.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['data_hidelayer'],
  879.             'exclude'                 => true,
  880.             'default'                 => false,
  881.             'inputType'               => 'checkbox',
  882.             'sql'                     => "char(1) NOT NULL default ''"
  883.         ),
  884.         'hide_child' => array
  885.         (
  886.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['hide_child'],
  887.             'exclude'                 => true,
  888.             'default'                 => false,
  889.             'inputType'               => 'checkbox',
  890.             'sql'                     => "char(1) NOT NULL default ''"
  891.         ),
  892.         'showPopupOnActive' => array
  893.         (
  894.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['showPopupOnActive'],
  895.             'exclude'                 => true,
  896.             'default'                 => false,
  897.             'inputType'               => 'checkbox',
  898.             'sql'                     => "char(1) NOT NULL default ''"
  899.         ),
  900.         'forums' => array
  901.         (
  902.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['forums'],
  903.             'exclude'                 => true,
  904.             'inputType'               => 'checkbox',
  905.             'options_callback'        => array('tl_c4g_maps','getMapForums'),
  906.             'eval'                    => array('mandatory'=>false, 'multiple'=>true),
  907.             'sql'                     => "blob NULL"
  908.         ),
  909.         'forum_jumpto' => array
  910.         (
  911.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['forum_jumpto'],
  912.             'exclude'                 => true,
  913.             'inputType'               => 'pageTree',
  914.             'eval'                    => array('fieldType'=>'radio'),
  915.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  916.         ),
  917.         'forum_reassign_layer' => array
  918.         (
  919.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['forum_reassign_layer'],
  920.             'exclude'                 => true,
  921.             'inputType'               => 'select',
  922.             'options'                 => array('NO','THREAD'),
  923.             'default'                 => 'NO',
  924.             'reference'               => &$GLOBALS['TL_LANG']['tl_c4g_maps']['references'],
  925.             'sql'                     => "char(10) NOT NULL default 'NO'"
  926.         ),
  927.         'ovp_request' => array
  928.         (
  929.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['ovp_request'],
  930.             'exclude'                 => true,
  931.             'inputType'               => 'textarea',
  932.             'eval'                    => array('allowHtml'=>true, 'preserveTags'=>true),
  933.             'sql'                     => "text NULL"
  934.         ),
  935.         'ovp_bbox_limited' => array
  936.         (
  937.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['ovp_bbox_limited'],
  938.             'exclude'                 => true,
  939.             'default'                 => true,
  940.             'inputType'               => 'checkbox',
  941.             'sql'                     => "char(1) NOT NULL default '1'"
  942.         ),
  943.         'link_id' => array
  944.         (
  945.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['link_id'],
  946.             'exclude'                 => true,
  947.             'inputType'               => 'select',
  948.             'options_callback'        => array('tl_c4g_maps', 'get_link_items'),
  949.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  950.         ),
  951.         'protect_element' => array
  952.         (
  953.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['protect_element'],
  954.             'exclude'                 => true,
  955.             'default'                 => false,
  956.             'inputType'               => 'checkbox',
  957.             'eval'                    => array('submitOnChange' => true),
  958.             'sql'                     => "char(1) NOT NULL default ''"
  959.         ),
  960.         'permitted_groups' => array
  961.         (
  962.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['permitted_groups'],
  963.             'exclude'                 => true,
  964.             'inputType'               => 'checkbox',
  965.             'foreignKey'              => 'tl_member_group.name',
  966.             'eval'                    => array('mandatory'=>false, 'multiple'=>true),
  967.             'sql'                     => "blob NULL"
  968.         ),
  969.         'use_specialprofile' => array
  970.         (
  971.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['use_specialprofile'],
  972.             'exclude'                 => true,
  973.             'default'                 => false,
  974.             'inputType'               => 'checkbox',
  975.             'eval'                    => array('submitOnChange' => true),
  976.             'sql'                     => "char(1) NOT NULL default ''"
  977.         ),
  978.         'specialprofile' => array
  979.         (
  980.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['specialprofile'],
  981.             'exclude'                 => true,
  982.             'inputType'               => 'select',
  983.             'foreignKey'              => 'tl_c4g_map_profiles.name',
  984.             'eval'                    => array('tl_class'=>'w50', 'submitOnChange' => true, 'alwaysSave' => true ),
  985.             'load_callback'           => array(array('tl_c4g_maps','getDefaultProfile')),
  986.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  987.         ),
  988.         'specialprofile_mobile' => array
  989.         (
  990.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['specialprofile_mobile'],
  991.             'exclude'                 => true,
  992.             'inputType'               => 'select',
  993.             'foreignKey'              => 'tl_c4g_map_profiles.name',
  994.             'eval'                    => array('tl_class'=>'w50',
  995.                                                'includeBlankOption'=>true),
  996.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  997.         ),
  998.         'specialprofile_groups' => array
  999.         (
  1000.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['specialprofile_groups'],
  1001.             'exclude'                 => true,
  1002.             'inputType'               => 'checkbox',
  1003.             'foreignKey'              => 'tl_member_group.name',
  1004.             'eval'                    => array('tl_class'=>'clr', 'mandatory'=>false, 'multiple'=>true),
  1005.             'sql'                     => "blob NULL"
  1006.         ),
  1007.         'cluster_locations' => array
  1008.         (
  1009.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cluster_locations'],
  1010.             'exclude'                 => true,
  1011.             'default'                 => false,
  1012.             'inputType'               => 'checkbox',
  1013.             'eval'                    => array('submitOnChange' => true),
  1014.             'sql'                     => "char(1) NOT NULL default ''"
  1015.         ),
  1016.         'cluster_distance' => array
  1017.         (
  1018.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cluster_distance'],
  1019.             'exclude'                 => true,
  1020.             'inputType'               => 'text',
  1021.             'eval'                    => array('maxlength'=>100),
  1022.             'sql'                     => "varchar(100) NOT NULL default ''"
  1023.         ),
  1024.         'cluster_fillcolor' => array
  1025.         (
  1026.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cluster_fillcolor'],
  1027.             'inputType'               => 'text',
  1028.             'default'                 => '4975A8',
  1029.             'eval'                    => array('maxlength'=>6, 'isHexColor'=>true, 'colorpicker'=>true, 'decodeEntities'=>true, 'tl_class'=>'w50 wizard', 'mandatory'=>true),
  1030.             'sql'                     => "varchar(6) NOT NULL default '4975A8'"
  1031.         ),
  1032.         'cluster_fontcolor' => array
  1033.         (
  1034.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cluster_fontcolor'],
  1035.             'default'                 => 'ffffff',
  1036.             'inputType'               => 'text',
  1037.             'eval'                    => array('maxlength'=>6, 'isHexColor'=>true, 'colorpicker'=>true, 'decodeEntities'=>true, 'tl_class'=>'w50 wizard'),
  1038.             'sql'                     => "varchar(6) NOT NULL default 'ffffff'"
  1039.         ),'cluster_zoom' => array
  1040.         (
  1041.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cluster_zoom'],
  1042.             'default'                 => '17',
  1043.             'exclude'                 => true,
  1044.             'inputType'               => 'c4g_text',
  1045.             'eval'                    => array('rgxp'=>'digit', 'tl_class'=>'clr'),
  1046.             'sql'                     => "int(10) unsigned NOT NULL default '17'"
  1047.         ),'cluster_popup' => array
  1048.         (
  1049.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cluster_popup'],
  1050.             'exclude'                 => true,
  1051.             'default'                 => false,
  1052.             'inputType'               => 'checkbox',
  1053.             'sql'                     => "char(1) NOT NULL default ''"
  1054.         ),
  1056.         'zoom_locations' => array
  1057.         (
  1058.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['zoom_locations'],
  1059.             'exclude'                 => true,
  1060.             'default'                 => false,
  1061.             'inputType'               => 'checkbox',
  1062.             'sql'                     => "char(1) NOT NULL default ''"
  1063.         ),
  1064.         'hover_location' => array
  1065.         (
  1066.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['hover_location'],
  1067.             'exclude'                 => true,
  1068.             'default'                 => false,
  1069.             'eval'                    => array('submitOnChange' => true),
  1070.             'inputType'               => 'checkbox',
  1071.             'sql'                     => "char(1) NOT NULL default ''"
  1072.         ),
  1073.         'hover_style' => array
  1074.         (
  1075.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['hover_style'],
  1076.             'exclude'                 => true,
  1077.             'inputType'               => 'select',
  1078.             'options_callback'        => array('tl_c4g_maps','getLocStyles'),
  1079.             'eval'                    => array('tl_class'=>'clr'),
  1080.             'wizard' => array
  1081.             (
  1082.                 array('tl_c4g_maps', 'editLocationStyle')
  1083.             ),
  1084.             'sql'                     => "int(10) unsigned NOT NULL default '0'"
  1085.         ),
  1086.         'be_optimize_checkboxes_limit' => array
  1087.         (
  1088.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['be_optimize_checkboxes_limit'],
  1089.             'exclude'                 => true,
  1090.             'inputType'               => 'text',
  1091.             'default'                 => '10',
  1092.             'eval'                    => array('rgxp'=>'digit', 'submitOnChange' => true),
  1093.             'sql'                     => "int(10) unsigned NOT NULL default '10'"
  1094.         ),
  1095.         'cssClass' => array
  1096.         (
  1097.             'label'                   => &$GLOBALS['TL_LANG']['tl_c4g_maps']['cssClass'],
  1098.             'exclude'                 => true,
  1099.             'inputType'               => 'text',
  1100.             'eval'                    => array('tl_class'=>'w50 clr'),
  1101.             'sql'                     => "varchar(255) NOT NULL default ''"
  1102.         ),
  1103.     )
  1104. );
  1106. /**
  1107.  * Class tl_c4g_maps
  1108.  */
  1109. class tl_c4g_maps extends Backend
  1110. {
  1112.     /**
  1113.      * value of first source table
  1114.      */
  1115.     protected $firstTabSource = null;
  1117.     /**
  1118.      * Import BackendUser object
  1119.      */
  1120.     public function __construct()
  1121.     {
  1122.         parent::__construct();
  1124.         $this->import('BackendUser', 'User');
  1125.     }
  1127.     /**
  1128.      * Return the copy page with subpages button
  1129.      * @param array
  1130.      * @param string
  1131.      * @param string
  1132.      * @param string
  1133.      * @param string
  1134.      * @param string
  1135.      * @param string
  1136.      * @return string
  1137.      */
  1138.     public function copyPageWithSubpages($row, $href, $label, $title, $icon, $attributes, $table)
  1139.     {
  1141.         $objSubpages = $this->Database->prepare("SELECT id FROM tl_c4g_maps WHERE pid=?")
  1142.                                       ->limit(1)
  1143.                                       ->execute($row['id']);
  1145.         if ($objSubpages->numRows > 0) {
  1146.             return '<a href="'.$this->addToUrl($href.'&amp;id='.$row['id']).'" title="'.specialchars($title).'"'.$attributes.'>'.$this->generateImage($icon, $label).'</a> ';
  1147.         } else {
  1148.             return $this->generateImage(preg_replace('/\.gif$/i', '_.gif', $icon)).' ';
  1149.         }
  1150.     }
  1152.     /**
  1153.      * Return all Location Styles for current Maps Profile as array
  1154.      * @param object
  1155.      * @return array
  1156.      */
  1157.     public function getLocStyles(DataContainer $dc)
  1158.     {
  1159.         $profile = $this->Database->prepare("SELECT locstyles FROM tl_c4g_map_profiles WHERE id=?")->execute($dc->activeRecord->profile);
  1160.         $ids = deserialize($profile->locstyles,true);
  1161.         if (count($ids)>0) {
  1162.             $locStyles = $this->Database->prepare("SELECT id,name FROM tl_c4g_map_locstyles WHERE id IN (".implode(',',$ids).") ORDER BY name")->execute();
  1163.         } else {
  1164.             $locStyles = $this->Database->prepare("SELECT id,name FROM tl_c4g_map_locstyles ORDER BY name")->execute();
  1165.         }
  1166.         while ($locStyles->next()) {
  1167.             $return[$locStyles->id] = $locStyles->name;
  1168.         }
  1169.         return $return;
  1170.     }
  1172.     /**
  1173.      * Return all available Sources for Maps
  1174.      * @param object
  1175.      * @return array
  1176.      */
  1177.     public function getTabSources(DataContainer $dc)
  1178.     {
  1179.         $return = array();
  1180.         foreach ($GLOBALS['con4gis']['maps']['sourcetable'] as $key=>$sourcetable) {
  1181.             if (!isset($this->firstTabSource)) {
  1182.                 $this->firstTabSource = $key;
  1183.             }
  1184.             if (!$GLOBALS['TL_LANG']['c4g_maps']['sourcetable'][$key]['name'] && !$GLOBALS['con4gis']['maps']['sourcetable'][$key]['name']) {
  1185.                 $return[$key] = $key;
  1186.             } else {
  1187.                 if ($GLOBALS['con4gis']['maps']['sourcetable'][$key]['name']) {
  1188.                     $return[$key] = $GLOBALS['con4gis']['maps']['sourcetable'][$key]['name'];
  1189.                 } else {
  1190.                     $return[$key] = $GLOBALS['TL_LANG']['c4g_maps']['sourcetable'][$key]['name'];
  1191.                 }
  1193.             }
  1194.         }
  1195.         return $return;
  1196.     }
  1198.     /**
  1199.      * Return all available locations types
  1200.      * @param object
  1201.      * @return array
  1202.      */
  1203.     public function getLocationTypes(DataContainer $dc)
  1204.     {
  1205.         $return = array('none','single','table','gpx','kml','geojson','osm','folder','overpass','link', 'startab');
  1206.         if ($GLOBALS['con4gis']['forum']['installed']) {
  1207.             $return[] = 'c4gForum';
  1208.         }
  1209.         if (isset($GLOBALS['c4g_locationtypes']) && is_array($GLOBALS['c4g_locationtypes']))
  1210.         {
  1211.             $return = array_merge($return, $GLOBALS['c4g_locationtypes']);
  1212.         }
  1213.         return $return;
  1214.     }
  1217.     /**
  1218.      * Return all available map enabled forums
  1219.      * @param object
  1220.      * @return array
  1221.      */
  1222.     public function getMapForums(DataContainer $dc)
  1223.     {
  1224.         $forumHelper = new \con4gis\ForumBundle\Resources\contao\classes\C4GForumHelper($this->Database);
  1225.         $forums = $forumHelper->getMapForums();
  1226.         foreach ($forums AS $forum) {
  1227.             $return[$forum['id']] = $forum['name'];
  1228.         }
  1229.         return $return;
  1230.     }
  1232.     /**
  1233.      * Return all entries in the parent table for the selection
  1234.      * @param object
  1235.      * @return array
  1236.      */
  1237.     public function getTabParentList(DataContainer $dc)
  1238.     {
  1239.         if ($dc->activeRecord->tab_source<>'') {
  1240.             $tabsource = $dc->activeRecord->tab_source;
  1241.         } else {
  1242.             $tabsource = $this->firstTabSource;
  1243.         }
  1245.         $source = $GLOBALS['con4gis']['maps']['sourcetable'][$tabsource];
  1246.         $ptable = explode(',', $source['ptable']);
  1247.         $ptable_option = explode(',', $source['ptable_option']);
  1248.         if (is_array($source) && $ptable && $ptable_option) {
  1249.             if (($ptable[0]) && ($ptable_option[0])) {
  1250.                 $obj = $this->Database->prepare(
  1251.                     "SELECT id, ".$ptable_option[0]." FROM ".$ptable[0])->execute();
  1252.                 while ($obj->next()) {
  1253.                     $name = $ptable_option[0];
  1254.                     $return[$obj->id] = $obj->$name;
  1255.                 }
  1256.                 return $return;
  1257.             }
  1258.         }
  1259.     }
  1261.     /**
  1262.      * Return all entries in the parent table for the selection
  1263.      * @param object
  1264.      * @return array
  1265.      */
  1266.     public function getTabParentList1(DataContainer $dc)
  1267.     {
  1268.         if ($dc->activeRecord->tab_source<>'') {
  1269.             $tabsource = $dc->activeRecord->tab_source;
  1270.         } else {
  1271.             $tabsource = $this->firstTabSource;
  1272.         }
  1274.         $source = $GLOBALS['con4gis']['maps']['sourcetable'][$tabsource];
  1275.         if($GLOBALS['BE_FFL']['tag'])
  1276.         {
  1277.             $source = $GLOBALS['con4gis']['maps']['sourcetable'][$tabsource.'_with_tags'];
  1278.         }
  1279.         $ptable = explode(',', $source['ptable']);
  1280.         $ctable = explode(',', $source['ctable']);
  1281.         $ctable_option = explode(',', $source['ctable_option']);
  1282.         $ptable_option = explode(',', $source['ptable_option']);
  1283.         $ptype = $source['ptype'];
  1284.         $sqlwhere = $source['ctable_where'];
  1285.         if (is_array($source) && $ptable && $ptable_option) {
  1286.             if (($ptable[1]) && ($ptable_option[1])) {
  1287.                 if($ptype == 'tag')
  1288.                 {
  1289.                     $obj = $this->Database->prepare(
  1290.                         "SELECT id, ".$ptable_option[1]." FROM ".$ptable[1]." WHERE ".$sqlwhere[1])->execute();
  1291.                 }
  1292.                 else
  1293.                 {
  1294.                     $obj = $this->Database->prepare(
  1295.                         "SELECT id, ".$ptable_option[1]." FROM ".$ptable[1])->execute();
  1296.                 }
  1297.                 while ($obj->next()) {
  1298.                     $name = $ptable_option[1];
  1299.                     $return[$obj->id] = $obj->$name;
  1301.                 }
  1302.                 $return = array_unique($return);
  1303.                 return $return;
  1304.             }
  1305.             else if (($ctable[0]) && ($ctable_option[0])) {
  1306.                 if($ptype == 'tag')
  1307.                 {
  1308.                     $obj = $this->Database->prepare(
  1309.                         "SELECT id, ".$ctable_option[0]." FROM ".$ctable[0]." WHERE ".$sqlwhere)->execute();
  1310.                 }
  1311.                 else
  1312.                 {
  1313.                     $obj = $this->Database->prepare(
  1314.                         "SELECT id, ".$ctable_option[0]." FROM ".$ctable[0])->execute();
  1315.                 }
  1316.                 while ($obj->next()) {
  1317.                     $name = $ctable_option[0];
  1318.                     $return[$obj->id] = $obj->$name;
  1320.                 }
  1321.                 $return = array_unique($return);
  1322.                 return $return;
  1323.             }
  1324.         }
  1327.     }
  1329. //    public function getTabTag(DataContainer $dc)
  1330. //    {
  1331. //        if ($dc->activeRecord->tab_source<>'') {
  1332. //            $tabsource = $dc->activeRecord->tab_source;
  1333. //        } else {
  1334. //            $tabsource = $this->firstTabSource;
  1335. //        }
  1336. //        $id = $dc->activeRecord->tab_pid;
  1337. //        $objEvent = $this->Database->prepare("SELECT * FROM tl_calendar_events WHERE pid = ?")->execute($id);
  1338. //        $stringSQL = "SELECT DISTINCT tag FROM tl_tag WHERE from_table = ?";
  1339. //        while($objEvent->next())
  1340. //        {
  1341. //            if(substr($stringSQL,-1)=='?')
  1342. //            {
  1343. //                $stringSQL .= " AND tid = ".$objEvent->id;
  1344. //            }
  1345. //            else
  1346. //            {
  1347. //                $stringSQL .= " OR tid = ".$objEvent->id;
  1348. //            }
  1349. //
  1350. //        }
  1351. //
  1352. //        $obj = $this->Database->prepare($stringSQL)->execute($tabsource,$dc->activeRecord->id);
  1353. //        while ($obj->next()) {
  1354. //
  1355. //            $return[$obj->tag] = $obj->tag;
  1356. //        }
  1357. //        return $return;
  1358. //
  1359. //    }
  1362.     /**
  1363.      * Recursively step through map item tree
  1364.      */
  1365.     private function getMapItemTree($tree, $return, $pid,$level)
  1366.     {
  1367.         if (array_key_exists($pid, $tree)) {
  1368.             foreach ($tree[$pid] AS $key=>$item) {
  1369.                 $return[$key] = str_repeat('+',$level).$item;
  1370.                 if (array_key_exists($key, $tree)) {
  1371.                     $return = $this->getMapItemTree($tree, $return, $key, $level+1);
  1372.                 }
  1373.             }
  1374.         }
  1375.         return $return;
  1376.     }
  1378.     /**
  1379.      * Return all map items ready to be linked
  1380.      * @param object
  1381.      * @return array
  1382.      */
  1383.     public function get_link_items(DataContainer $dc)
  1384.     {
  1386.         $maps = $this->Database->prepare ( "SELECT id,pid,name FROM tl_c4g_maps WHERE published=1 AND location_type<>'link' ORDER BY pid,sorting" )->execute ();
  1387.         if ($maps->numRows > 0) {
  1388.             while ( $maps->next () ) {
  1389.                 $tree [$maps->pid][$maps->id] = $maps->name;
  1390.             }
  1391.         }
  1392.         return $this->getMapItemTree($tree,array(),0,0);
  1393.     }
  1395.     /**
  1396.      * Generate the icons to be used
  1397.      */
  1398.     public function generateLabel($row, $label, $dc_table, $folderAttribute)
  1399.     {
  1400.         $image = 'bundles/con4gismaps/images/be-icons/';
  1401.         if ($row['is_map']) {
  1402.             if ($row['location_type']<>'none') {
  1403.                 $image .= 'map_location';
  1404.             } else {
  1405.                 $image .= 'map';
  1406.             }
  1407.         } elseif ($row['location_type']=='link') {
  1408.             $image .= 'link';
  1409.         } elseif ($row['location_type']<>'none') {
  1410.             $image .= 'location';
  1411.         } else {
  1412.             $image .= 'mapfolder';
  1413.         }
  1414.         if (!$row['published']) {
  1415.             $image .= '_1';
  1416.         }
  1417.         $image .= '.png';
  1418.         return $this->generateImage($image, '', $folderAttribute) . ' ' . $label;
  1419.     }
  1421.     /**
  1422.      * Update the palette information that depend on other values
  1423.      */
  1424.     public function updateDCA(DataContainer $dc)
  1425.     {
  1426.         if (!$dc->id) return;
  1428.         $objMap = $this->Database->prepare("SELECT is_map, show_locations, hover_location, restrict_area, geolocation, be_optimize_checkboxes_limit, popupType FROM tl_c4g_maps WHERE id=?")
  1429.             ->limit(1)
  1430.             ->execute($dc->id);
  1431.         if ($objMap->numRows > 0) {
  1432.             if($objMap->show_locations == '1') {
  1433.                 $calcExtentFields = 'min_gap,';
  1434.             }
  1435.             if($objMap->hover_location == '1') {
  1436.                 $hover_style = 'hover_style';
  1437.                 foreach ($GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'] as $paletteKey=>$paletteString)
  1438.                 {
  1439.                     if (!is_array($paletteString) && strpos($paletteString, "hover_location")!==false)
  1440.                     {
  1441.                         $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'][$paletteKey] = str_replace("hover_location", "hover_location,hover_style", $paletteString);
  1443.                     }
  1444.                 }
  1445.             }
  1446.             if ($objMap->geolocation) {
  1447.                 $geolocationFields = 'geolocation_zoom,';
  1448.             } else {
  1449.                 $geolocationFields = '';
  1450.             }
  1451.             if ($objMap->restrict_area) {
  1452.                 $restrictAreaFields = 'restr_bottomleft_geox,restr_bottomleft_geoy,restr_topright_geox,restr_topright_geoy,';
  1453.             } else {
  1454.                 $restrictAreaFields = '';
  1455.             }
  1456.             if ($objMap->popupType == "template")
  1457.             {
  1458.                 // we have to use this, because of current table naming with underscores
  1459.                 foreach ($GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'] as $paletteKey=>$paletteString)
  1460.                 {
  1461.                     if (!is_array($paletteString) && strpos($paletteString, "popup_info")!==false)
  1462.                     {
  1463.                         $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'][$paletteKey] = str_replace("popup_info", "popupTemplate", $paletteString);
  1464.                     }
  1465.                 }
  1466.             }
  1467.             if ($objMap->popupType == "popup_info")
  1468.             {
  1469.                 // we have to use this, because of current table naming with underscores
  1470.                 foreach ($GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'] as $paletteKey=>$paletteString)
  1471.                 {
  1472.                     if (!is_array($paletteString) && strpos($paletteString, "popup_info")!==false)
  1473.                     {
  1474.                         $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'][$paletteKey] = str_replace("popup_info", "", $paletteString);
  1475.                        # $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes'][$paletteKey] = str_replace("hover_location", "hover_location,hover_style", $paletteString);
  1477.                     }
  1478.                 }
  1479.             }
  1481.             $GLOBALS['TL_DCA']['tl_c4g_maps']['subpalettes']['is_map'] =
  1482.                 'width,height,margin,show_locations,'.$calcExtentFields.'center_geox,center_geoy,zoom,geolocation,'.$geolocationFields.'restrict_area,'.$restrictAreaFields.',include_sublocations';
  1484.             if ($GLOBALS['con4gis']['forum']['installed']) {
  1485.                 $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes']['overpass'] = str_replace('popup_info,routing_to', 'popup_info,popup_extend,routing_to', $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes']['overpass']);
  1486.                 $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes']['osm'] = str_replace('popup_info,routing_to', 'popup_info,popup_extend,routing_to', $GLOBALS['TL_DCA']['tl_c4g_maps']['palettes']['osm']);
  1487.             }
  1489.             // convert checkboxes to chosenfields, if there are to many locationstyles
  1490.             if (intval($objMap->be_optimize_checkboxes_limit) > 0) {
  1491.                 // subforums-options
  1492.                 if ($GLOBALS['con4gis']['forum']['installed']) {
  1493.                     $objForumCount = $this->Database->prepare("SELECT COUNT(id) AS entry_count FROM tl_c4g_forum WHERE enable_maps = 1")->execute();
  1494.                     if ($objForumCount->numRows > 0) {
  1495.                         if (intval($objForumCount->entry_count) > intval($objMap->be_optimize_checkboxes_limit)) {
  1496.                             $GLOBALS['TL_DCA']['tl_c4g_maps']['fields']['forums']['inputType'] = 'select';
  1497.                             $GLOBALS['TL_DCA']['tl_c4g_maps']['fields']['forums']['eval']['chosen'] = true;
  1498.                         }
  1499.                     }
  1500.                 }
  1501.             }
  1502.         }
  1504.     }
  1506.     /**
  1507.      * determine the default profile
  1508.      */
  1509.     public function getDefaultProfile($varValue, DataContainer $dc)
  1510.     {
  1511.         if (!$varValue) {
  1512.             if ($dc->activeRecord->pid) {
  1513.                 // take default profile from parent entry
  1514.                 $objParent = $this->Database->prepare("SELECT profile FROM tl_c4g_maps WHERE id=?")
  1515.                     ->limit(1)->execute($dc->activeRecord->pid);
  1516.                 if ($objParent->numRows > 0) {
  1517.                     $varValue = $objParent->profile;
  1518.                 }
  1519.             }
  1520.             if (!$varValue) {
  1521.                 // get default profile
  1522.                 $objProfile = $this->Database->prepare("SELECT id FROM tl_c4g_map_profiles WHERE is_default=1")
  1523.                     ->limit(1)->execute();
  1524.                 if ($objProfile->numRows > 0) {
  1525.                     $varValue = $objProfile->id;
  1526.                 }
  1527.             }
  1528.         }
  1529.         return $varValue;
  1530.     }
  1531.     public function getOldValue($varValue, DataContainer $dc)
  1532.     {
  1533.         if($varValue == '2'){
  1534.             if ($dc->activeRecord->calc_extent == "LOCATIONS") {
  1535.                 $varValue = 1;
  1536.             } else {
  1537.                 $varValue = 0;
  1538.             }
  1539.         }
  1540.         return $varValue;
  1542.     }
  1543.     public function setOldValue($varValue, DataContainer $dc)
  1544.     {
  1545.         if($dc->activeRecord->show_locations == '1'){
  1546.             $varValue = "LOCATIONS";
  1547.             $dc->activeRecord->calc_extent = "LOCATIONS";
  1548.         }
  1549.         else if($dc->activeRecord->show_locations == ''){
  1550.             $varValue = "CENTERZOOM";
  1551.             $dc->activeRecord->calc_extent = "CENTERZOOM";
  1552.         }
  1553.         return $varValue;
  1554.     }
  1557.     /**
  1558.      * Validate Center Lon
  1559.      */
  1560.     public function setCenterLon($varValue, DataContainer $dc)
  1561.     {
  1562.         if ($dc->activeRecord->calc_extent == 'CENTERZOOM') {
  1563.             if (!\con4gis\MapsBundle\Resources\contao\classes\Utils::validateLon($varValue)) {
  1564.                 throw new Exception($GLOBALS['TL_LANG']['c4g_maps']['geox_invalid']);
  1565.             }
  1566.         }
  1567.         return $varValue;
  1568.     }
  1570.     /**
  1571.      * Validate Center Lat
  1572.      */
  1573.     public function setCenterLat($varValue, DataContainer $dc)
  1574.     {
  1575.         if ($dc->activeRecord->calc_extent == 'CENTERZOOM') {
  1576.             if (!\con4gis\MapsBundle\Resources\contao\classes\Utils::validateLat($varValue)) {
  1577.                 throw new Exception($GLOBALS['TL_LANG']['c4g_maps']['geoy_invalid']);
  1578.             }
  1579.         }
  1580.         return $varValue;
  1581.     }
  1584.     /**
  1585.      * Validate restricted Lon
  1586.      */
  1587.     public function setRestrLon($varValue, DataContainer $dc)
  1588.     {
  1589.         if ($dc->activeRecord->restrict_area) {
  1590.             if (!\con4gis\MapsBundle\Resources\contao\classes\Utils::validateLon($varValue)) {
  1591.                 throw new Exception($GLOBALS['TL_LANG']['c4g_maps']['geox_invalid']);
  1592.             }
  1593.         }
  1594.         return $varValue;
  1595.     }
  1597.     /**
  1598.      * Validate restricted Lat
  1599.      */
  1600.     public function setRestrLat($varValue, DataContainer $dc)
  1601.     {
  1602.         if ($dc->activeRecord->restrict_area) {
  1603.             if (!\con4gis\MapsBundle\Resources\contao\classes\Utils::validateLat($varValue)) {
  1604.                 throw new Exception($GLOBALS['TL_LANG']['c4g_maps']['geoy_invalid']);
  1605.             }
  1606.         }
  1607.         return $varValue;
  1608.     }
  1610.     /**
  1611.      * Validate Location Lon
  1612.      */
  1613.     public function setLocLon($varValue, DataContainer $dc)
  1614.     {
  1615.         if (!\con4gis\MapsBundle\Resources\contao\classes\Utils::validateLon($varValue)) {
  1616.             throw new Exception($GLOBALS['TL_LANG']['c4g_maps']['geox_invalid']);
  1617.         }
  1618.         return $varValue;
  1619.     }
  1621.     /**
  1622.      * Validate Location Lat
  1623.      */
  1624.     public function setLocLat($varValue, DataContainer $dc)
  1625.     {
  1626.         if (!\con4gis\MapsBundle\Resources\contao\classes\Utils::validateLat($varValue)) {
  1627.             throw new Exception($GLOBALS['TL_LANG']['c4g_maps']['geoy_invalid']);
  1628.         }
  1629.         return $varValue;
  1630.     }
  1631.     
  1632.     /**
  1633.      * Return the "toggle visibility" button
  1634.      */
  1635.     public function toggleIcon($row, $href, $label, $title, $icon, $attributes)
  1636.     {
  1637.         if (strlen($this->Input->get('tid'))) {
  1638.             $this->toggleVisibility($this->Input->get('tid'), ($this->Input->get('state') == 1));
  1639.             $this->redirect($this->getReferer());
  1640.         }
  1642.         // Check permissions AFTER checking the tid, so hacking attempts are logged
  1643.         if (!$this->User->isAdmin && !$this->User->hasAccess('tl_c4g_maps::published', 'alexf')) {
  1644.             return '';
  1645.         }
  1647.         $href .= '&amp;tid='.$row['id'].'&amp;state='.($row['published'] ? '' : 1);
  1649.         if (!$row['published']) {
  1650.             $icon = 'invisible.gif';
  1651.         }
  1653.         \con4gis\CoreBundle\Resources\contao\classes\C4GAutomator::purgeApiCache();
  1655.         return '<a href="'.$this->addToUrl($href).'" title="'.specialchars($title).'"'.$attributes.'>'.\Image::getHtml($icon, $label).'</a> ';
  1656.     }
  1659.     /**
  1660.      * Disable/enable an element
  1661.      * @param integer
  1662.      * @param boolean
  1663.      */
  1664.     public function toggleVisibility($intId, $blnVisible)
  1665.     {
  1666.         // Check permissions to publish
  1667.         if (!$this->User->isAdmin && !$this->User->hasAccess('tl_c4g_maps::published', 'alexf')) {
  1669.             //ToDo loggerService
  1670.             $this->log('Not enough permissions to publish/unpublish con4gis\MapsBundle\Resources\contao\classes\Utils ID "'.$intId.'"', 'tl_c4g_maps toggleVisibility', TL_ERROR);
  1671.             $this->redirect('contao/main.php?act=error');
  1672.         }
  1673.         $this->createInitialVersion('tl_c4g_maps', $intId);
  1674.         #$this->Versions->initialize('tl_c4g_maps', $intId);
  1676.         $objVersions = new Versions('tl_c4g_maps', $intId);
  1677.         $objVersions->initialize();
  1679.         // Trigger the save_callback
  1680.         if (is_array($GLOBALS['TL_DCA']['tl_c4g_maps']['fields']['published']['save_callback'])) {
  1681.             foreach ($GLOBALS['TL_DCA']['tl_c4g_maps']['fields']['published']['save_callback'] as $callback) {
  1682.                 $str_class = $callback[0];
  1683.                 $str_function = $callback[1];
  1685.                 if ($str_class && $str_function) {
  1686.                     $this->import($str_class);
  1687.                     $blnVisible = $this->$str_class->$str_function($blnVisible, $this);
  1688.                 }
  1689.             }
  1690.         }
  1693.         // Update the database
  1694.         $this->Database->prepare("UPDATE tl_c4g_maps SET tstamp=". time() .", published='" . ($blnVisible ? 1 : '') . "' WHERE id=?")
  1695.                        ->execute($intId);
  1697.         $this->createNewVersion('tl_c4g_maps', $intId);
  1698.         #x$this->Versions->create('tl_c4g_maps', $intId);
  1699.     }
  1701.     /**
  1702.      * Return the page pick wizard for the linkUrl
  1703.      * @param DataContainer $dc
  1704.      */
  1705.     public function pickUrl(DataContainer $dc)
  1706.     {
  1707.         return ' <a href="contao/page.php?do='.Input::get('do').'&amp;table='.$dc->table.'&amp;field='.$dc->field.'&amp;value='.str_replace(array('{{link_url::', '}}'), '', $dc->value).'" title="'.specialchars($GLOBALS['TL_LANG']['MSC']['pagepicker']).'" onclick="Backend.getScrollOffset();Backend.openModalSelector({\'width\':765,\'title\':\''.specialchars(str_replace("'", "\\'", $GLOBALS['TL_LANG']['MOD']['page'][0])).'\',\'url\':this.href,\'id\':\''.$dc->field.'\',\'tag\':\'ctrl_'.$dc->field . ((Input::get('act') == 'editAll') ? '_' . $dc->id : '').'\',\'self\':this});return false">' . $this->generateImage('pickpage.gif', $GLOBALS['TL_LANG']['MSC']['pagepicker'], 'style="vertical-align:top;cursor:pointer"') . '</a>';
  1708.     }
  1710.     //editLocationType
  1711.     /**
  1712.         * Return the edit location style wizard
  1713.         * @param \DataContainer
  1714.         * @return string
  1715.         */
  1716.        public function editLocationStyle(DataContainer $dc)
  1717.        {
  1718.            return ($dc->value < 1) ? '' : ' <a href="contao/main.php?do=c4g_map_locstyles&amp;act=edit&amp;id=' . $dc->value . '&amp;popup=1&amp;nb=1&amp;rt=' . REQUEST_TOKEN . '" title="' . sprintf(specialchars($GLOBALS['TL_LANG']['tl_c4g_maps']['editalias'][1]), $dc->value) . '" style="padding-left:3px" onclick="Backend.openModalIframe({\'width\':768,\'title\':\'' . specialchars(str_replace("'", "\\'", sprintf($GLOBALS['TL_LANG']['tl_c4g_maps']['editalias'][1], $dc->value))) . '\',\'url\':this.href});return false">' . Image::getHtml('alias.gif', $GLOBALS['TL_LANG']['tl_c4g_maps']['editalias'][0], 'style="vertical-align:top"') . '</a>';
  1719.        }
  1721.     /**
  1722.      * Return all navigation templates as array
  1723.      *
  1724.      * @return array
  1725.      */
  1726.     public function getPopupTemplates()
  1727.     {
  1728.         return $this->getTemplateGroup('popup_');
  1729.     }
  1730. }