Symfony Profiler

<?php
/**
* Contao Open Source CMS
*
* Copyright (c) 2005-2015 Leo Feyer
*
* @package SgLocations
* @author Sg-Medien GmbH <info@sg-medien.com>
* @license EULA
* @copyright Sg-Medien GmbH 2015
*/
/**
* Table tl_sg_locations
*/
$GLOBALS['TL_DCA']['tl_sg_locations'] = array
(
// config
'config' => array
(
'dataContainer' => 'Table',
'ptable' => 'tl_sg_locations_category',
'enableVersioning' => true,
'ondelete_callback' => array
(
array('tl_sg_locations', 'deleteLocation')
),
'sql' => array
(
'keys' => array
(
'id' => 'primary',
'pid' => 'index'
)
)
),
// list
'list' => array
(
'sorting' => array
(
'mode' => 4,
'fields' => array('sorting'),
'panelLayout' => 'filter;sort,search,limit',
'headerFields' => array('title'),
'child_record_callback' => array('tl_sg_locations', 'listLocations')
),
'global_operations' => array
(
'all' => array
(
'label' => &$GLOBALS['TL_LANG']['MSC']['all'],
'href' => 'act=select',
'class' => 'header_edit_all',
'attributes' => 'onclick="Backend.getScrollOffset()" accesskey="e"'
)
),
'operations' => array
(
'edit' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['edit'],
'href' => 'act=edit',
'icon' => 'edit.gif'
),
'copy' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['copy'],
'href' => 'act=paste&mode=copy',
'icon' => 'copy.gif'
),
'cut' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['cut'],
'href' => 'act=paste&mode=cut',
'icon' => 'cut.gif'
),
'delete' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['delete'],
'href' => 'act=delete',
'icon' => 'delete.gif',
'attributes' => 'onclick="if(!confirm(\'' . ($GLOBALS['TL_LANG']['MSC']['deleteConfirm'] ?? null) . '\'))return false;Backend.getScrollOffset()"'
),
'show' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['show'],
'href' => 'act=show',
'icon' => 'show.gif'
)
)
),
// palettes
'palettes' => array
(
'__selector__' => array('addImage'),
'default' => '{location_legend},company,street,postal,city,state,country,location_type,location_manager;{contact_legend},phone,fax,email;{image_legend},addImage'
),
// subpalettes
'subpalettes' => array
(
'addImage' => 'singleSRC'
),
// fields
'fields' => array
(
'id' => array
(
'sql' => "int(10) unsigned NOT NULL auto_increment"
),
'pid' => array
(
'foreignKey' => 'tl_sg_locations_category.title',
'sql' => "int(10) unsigned NOT NULL default '0'",
'relation' => array
(
'type' => 'belongsTo',
'load' => 'eager'
)
),
'sorting' => array
(
'label' => &$GLOBALS['TL_LANG']['MSC']['sorting'],
'sorting' => true,
'flag' => 11,
'sql' => "int(10) unsigned NOT NULL default '0'"
),
'tstamp' => array
(
'sql' => "int(10) unsigned NOT NULL default '0'"
),
'company' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['company'],
'exclude' => true,
'search' => true,
'sorting' => true,
'flag' => 1,
'inputType' => 'text',
'eval' => array
(
'mandatory' => true,
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'street' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['street'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'postal' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['postal'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(32) NOT NULL default ''"
),
'city' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['city'],
'exclude' => true,
'filter' => true,
'search' => true,
'sorting' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'state' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['state'],
'exclude' => true,
'sorting' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(64) NOT NULL default ''"
),
'country' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['country'],
'default' => 'de',
'exclude' => true,
'filter' => true,
'sorting' => true,
'inputType' => 'select',
'options' => \System::getCountries(),
'eval' => array
(
'chosen' => true,
'maxlength' => 200,
'tl_class' => 'w50'
),
'sql' => "varchar(2) NOT NULL default ''"
),
'location_type' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['location_type'],
'exclude' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'location_manager' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['location_manager'],
'exclude' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'phone' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['phone'],
'exclude' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'rgxp' => 'phone',
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'fax' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['fax'],
'exclude' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'rgxp' => 'phone',
'tl_class' => 'w50'
),
'sql' => "varchar(255) NOT NULL default ''"
),
'email' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['email'],
'exclude' => true,
'inputType' => 'text',
'eval' => array
(
'maxlength' => 255,
'rgxp' => 'email',
'tl_class' => 'w50',
),
'sql' => "varchar(255) NOT NULL default ''"
),
'addImage' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['addImage'],
'exclude' => true,
'filter' => true,
'inputType' => 'checkbox',
'eval' => array
(
'submitOnChange' => true,
'tl_class' => 'clr'
),
'sql' => "char(1) NOT NULL default ''"
),
'singleSRC' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['singleSRC'],
'exclude' => true,
'inputType' => 'fileTree',
'eval' => array
(
'filesOnly' => true,
'extensions' => \Config::get('validImageTypes'),
'fieldType' => 'radio',
'mandatory' => true
),
'sql' => "binary(16) NULL"
),
'size' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sg_locations']['size'],
'exclude' => true,
'inputType' => 'imageSize',
'options' => \System::getImageSizes(),
'reference' => &$GLOBALS['TL_LANG']['MSC'],
'eval' => array
(
'rgxp' => 'natural',
'includeBlankOption' => true,
'nospace' => true,
'helpwizard' => true,
'tl_class' => 'w50'
),
'sql' => "varchar(64) NOT NULL default ''"
)
)
);
/**
* Class tl_sg_locations
*
* Provide miscellaneous methods that are used by the data configuration array.
*
* @package SgLocations
* @author Sg-Medien GmbH <info@sg-medien.com>
* @copyright Sg-Medien GmbH 2017
*/
class tl_sg_locations extends \Backend
{
/**
* List locations
*
* @param array $arrRow The list row.
*
* @return string The final list row.
*/
public function listLocations($arrRow)
{
if (!$arrRow['company']) {
return '-';
}
// return list row
return '<strong>' . $arrRow['company'] . '</strong>' .
($arrRow['street'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['street'][0] . ': ' . $this->replaceInsertTags($arrRow['street'], false) . '</div>' : '') .
($arrRow['postal'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['postal'][0] . ': ' . $this->replaceInsertTags($arrRow['postal'], false) . '</div>' : '') .
($arrRow['city'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['city'][0] . ': ' . $this->replaceInsertTags($arrRow['city'], false) . '</div>' : '') .
($arrRow['state'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['state'][0] . ': ' . $this->replaceInsertTags($arrRow['state'], false) . '</div>' : '') .
($arrRow['country'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['country'][0] . ': ' . (isset($GLOBALS['TL_LANG']['CNT'][$arrRow['country']]) ? $GLOBALS['TL_LANG']['CNT'][$arrRow['country']] : $arrRow['country']) . '</div>' : '') .
($arrRow['phone'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['phone'][0] . ': ' . $this->replaceInsertTags($arrRow['phone'], false) . '</div>' : '') .
($arrRow['fax'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['fax'][0] . ': ' . $this->replaceInsertTags($arrRow['fax'], false) . '</div>' : '') .
($arrRow['email'] ? '<div>' . $GLOBALS['TL_LANG']['tl_sg_locations']['email'][0] . ': ' . $this->replaceInsertTags($arrRow['email'], false) . '</div>' : '');
}
/**
* Callback before delete a location
*
* @param object \DataContainer
*
* @return void
*/
public function deleteLocation(\DataContainer $dc)
{
// lock table
$dc->Database->lockTables(array('tl_content' => 'WRITE'));
// update content elements
$dc->Database->prepare("UPDATE tl_content %s WHERE location=?")->set(array('invisible' => 1, 'location' => 0))->execute($dc->id);
// unlock table
$dc->Database->unlockTables();
}
}

system/modules/sg-locations/dca/tl_sg_locations.php line 216