Файл: contao-3.5.8/system/modules/calendar/dca/tl_calendar_events.php
Строк: 928
<?php
/**
* Contao Open Source CMS
*
* Copyright (c) 2005-2016 Leo Feyer
*
* @license LGPL-3.0+
*/
/**
* Load tl_content language file
*/
System::loadLanguageFile('tl_content');
/**
* Table tl_calendar_events
*/
$GLOBALS['TL_DCA']['tl_calendar_events'] = array
(
// Config
'config' => array
(
'dataContainer' => 'Table',
'ptable' => 'tl_calendar',
'ctable' => array('tl_content'),
'switchToEdit' => true,
'enableVersioning' => true,
'onload_callback' => array
(
array('tl_calendar_events', 'checkPermission'),
array('tl_calendar_events', 'generateFeed')
),
'oncut_callback' => array
(
array('tl_calendar_events', 'scheduleUpdate')
),
'ondelete_callback' => array
(
array('tl_calendar_events', 'scheduleUpdate')
),
'onsubmit_callback' => array
(
array('tl_calendar_events', 'adjustTime'),
array('tl_calendar_events', 'scheduleUpdate')
),
'sql' => array
(
'keys' => array
(
'id' => 'primary',
'alias' => 'index',
'pid,start,stop,published' => 'index'
)
)
),
// List
'list' => array
(
'sorting' => array
(
'mode' => 4,
'fields' => array('startTime DESC'),
'headerFields' => array('title', 'jumpTo', 'tstamp', 'protected', 'allowComments'),
'panelLayout' => 'filter;sort,search,limit',
'child_record_callback' => array('tl_calendar_events', 'listEvents'),
'child_record_class' => 'no_padding'
),
'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_calendar_events']['edit'],
'href' => 'table=tl_content',
'icon' => 'edit.gif'
),
'editheader' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['editmeta'],
'href' => 'act=edit',
'icon' => 'header.gif'
),
'copy' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['copy'],
'href' => 'act=paste&mode=copy',
'icon' => 'copy.gif'
),
'cut' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['cut'],
'href' => 'act=paste&mode=cut',
'icon' => 'cut.gif'
),
'delete' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['delete'],
'href' => 'act=delete',
'icon' => 'delete.gif',
'attributes' => 'onclick="if(!confirm('' . $GLOBALS['TL_LANG']['MSC']['deleteConfirm'] . ''))return false;Backend.getScrollOffset()"'
),
'toggle' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['toggle'],
'icon' => 'visible.gif',
'attributes' => 'onclick="Backend.getScrollOffset();return AjaxRequest.toggleVisibility(this,%s)"',
'button_callback' => array('tl_calendar_events', 'toggleIcon')
),
'show' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['show'],
'href' => 'act=show',
'icon' => 'show.gif'
)
)
),
// Palettes
'palettes' => array
(
'__selector__' => array('addTime', 'addImage', 'recurring', 'addEnclosure', 'source', 'published'),
'default' => '{title_legend},title,alias,author;{date_legend},addTime,startDate,endDate;{details_legend},location,teaser;{image_legend},addImage;{recurring_legend},recurring;{enclosure_legend:hide},addEnclosure;{source_legend:hide},source;{expert_legend:hide},cssClass,noComments;{publish_legend},published'
),
// Subpalettes
'subpalettes' => array
(
'addTime' => 'startTime,endTime',
'addImage' => 'singleSRC,alt,size,imagemargin,imageUrl,fullsize,caption,floating',
'recurring' => 'repeatEach,recurrences',
'addEnclosure' => 'enclosure',
'source_internal' => 'jumpTo',
'source_article' => 'articleId',
'source_external' => 'url,target',
'published' => 'start,stop'
),
// Fields
'fields' => array
(
'id' => array
(
'sql' => "int(10) unsigned NOT NULL auto_increment"
),
'pid' => array
(
'foreignKey' => 'tl_calendar.title',
'sql' => "int(10) unsigned NOT NULL default '0'",
'relation' => array('type'=>'belongsTo', 'load'=>'eager')
),
'tstamp' => array
(
'sql' => "int(10) unsigned NOT NULL default '0'"
),
'title' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['title'],
'exclude' => true,
'search' => true,
'sorting' => true,
'flag' => 1,
'inputType' => 'text',
'eval' => array('mandatory'=>true, 'maxlength'=>255),
'sql' => "varchar(255) NOT NULL default ''"
),
'alias' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['alias'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'alias', 'unique'=>true, 'maxlength'=>128, 'tl_class'=>'w50'),
'save_callback' => array
(
array('tl_calendar_events', 'generateAlias')
),
'sql' => "varchar(128) COLLATE utf8_bin NOT NULL default ''"
),
'author' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['author'],
'default' => BackendUser::getInstance()->id,
'exclude' => true,
'search' => true,
'filter' => true,
'sorting' => true,
'flag' => 11,
'inputType' => 'select',
'foreignKey' => 'tl_user.name',
'eval' => array('doNotCopy'=>true, 'chosen'=>true, 'mandatory'=>true, 'includeBlankOption'=>true, 'tl_class'=>'w50'),
'sql' => "int(10) unsigned NOT NULL default '0'",
'relation' => array('type'=>'hasOne', 'load'=>'eager')
),
'addTime' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['addTime'],
'exclude' => true,
'inputType' => 'checkbox',
'eval' => array('submitOnChange'=>true, 'doNotCopy'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'startTime' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['startTime'],
'default' => time(),
'exclude' => true,
'filter' => true,
'sorting' => true,
'flag' => 8,
'inputType' => 'text',
'eval' => array('rgxp'=>'time', 'mandatory'=>true, 'doNotCopy'=>true, 'tl_class'=>'w50'),
'sql' => "int(10) unsigned NULL"
),
'endTime' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['endTime'],
'default' => time(),
'exclude' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'time', 'doNotCopy'=>true, 'tl_class'=>'w50'),
'save_callback' => array
(
array('tl_calendar_events', 'setEmptyEndTime')
),
'sql' => "int(10) unsigned NULL"
),
'startDate' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['startDate'],
'default' => time(),
'exclude' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'date', 'mandatory'=>true, 'doNotCopy'=>true, 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
'sql' => "int(10) unsigned NULL"
),
'endDate' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['endDate'],
'default' => null,
'exclude' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'date', 'doNotCopy'=>true, 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
'save_callback' => array
(
array('tl_calendar_events', 'setEmptyEndDate')
),
'sql' => "int(10) unsigned NULL"
),
'location' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['location'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('maxlength'=>255, 'tl_class'=>'long'),
'sql' => "varchar(255) NOT NULL default ''"
),
'teaser' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['teaser'],
'exclude' => true,
'search' => true,
'inputType' => 'textarea',
'eval' => array('rte'=>'tinyMCE', 'tl_class'=>'clr'),
'sql' => "text NULL"
),
'addImage' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['addImage'],
'exclude' => true,
'inputType' => 'checkbox',
'eval' => array('submitOnChange'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'singleSRC' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['singleSRC'],
'exclude' => true,
'inputType' => 'fileTree',
'eval' => array('filesOnly'=>true, 'extensions'=>Config::get('validImageTypes'), 'fieldType'=>'radio', 'mandatory'=>true),
'save_callback' => array
(
array('tl_calendar_events', 'storeFileMetaInformation')
),
'sql' => "binary(16) NULL"
),
'alt' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['alt'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('maxlength'=>255, 'tl_class'=>'long'),
'sql' => "varchar(255) NOT NULL default ''"
),
'size' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['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 ''"
),
'imagemargin' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['imagemargin'],
'exclude' => true,
'inputType' => 'trbl',
'options' => $GLOBALS['TL_CSS_UNITS'],
'eval' => array('includeBlankOption'=>true, 'tl_class'=>'w50'),
'sql' => "varchar(128) NOT NULL default ''"
),
'imageUrl' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['imageUrl'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'url', 'decodeEntities'=>true, 'maxlength'=>255, 'fieldType'=>'radio', 'filesOnly'=>true, 'tl_class'=>'w50 wizard'),
'wizard' => array
(
array('tl_calendar_events', 'pagePicker')
),
'sql' => "varchar(255) NOT NULL default ''"
),
'fullsize' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['fullsize'],
'exclude' => true,
'inputType' => 'checkbox',
'eval' => array('tl_class'=>'w50 m12'),
'sql' => "char(1) NOT NULL default ''"
),
'caption' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['caption'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('maxlength'=>255, 'allowHtml'=>true, 'tl_class'=>'w50'),
'sql' => "varchar(255) NOT NULL default ''"
),
'floating' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_content']['floating'],
'default' => 'above',
'exclude' => true,
'inputType' => 'radioTable',
'options' => array('above', 'left', 'right', 'below'),
'eval' => array('cols'=>4, 'tl_class'=>'w50'),
'reference' => &$GLOBALS['TL_LANG']['MSC'],
'sql' => "varchar(32) NOT NULL default ''"
),
'recurring' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['recurring'],
'exclude' => true,
'filter' => true,
'inputType' => 'checkbox',
'eval' => array('submitOnChange'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'repeatEach' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['repeatEach'],
'exclude' => true,
'inputType' => 'timePeriod',
'options' => array('days', 'weeks', 'months', 'years'),
'reference' => &$GLOBALS['TL_LANG']['tl_calendar_events'],
'eval' => array('mandatory'=>true, 'rgxp'=>'natural', 'minval'=>1, 'tl_class'=>'w50'),
'sql' => "varchar(64) NOT NULL default ''"
),
'repeatEnd' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['repeatEnd'],
'sql' => "int(10) unsigned NOT NULL default '0'"
),
'recurrences' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['recurrences'],
'exclude' => true,
'inputType' => 'text',
'eval' => array('mandatory'=>true, 'rgxp'=>'natural', 'tl_class'=>'w50'),
'sql' => "smallint(5) unsigned NOT NULL default '0'"
),
'addEnclosure' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['addEnclosure'],
'exclude' => true,
'inputType' => 'checkbox',
'eval' => array('submitOnChange'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'enclosure' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['enclosure'],
'exclude' => true,
'inputType' => 'fileTree',
'eval' => array('multiple'=>true, 'fieldType'=>'checkbox', 'filesOnly'=>true, 'isDownloads'=>true, 'extensions'=>Config::get('allowedDownload'), 'mandatory'=>true),
'sql' => "blob NULL"
),
'source' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['source'],
'default' => 'default',
'exclude' => true,
'filter' => true,
'inputType' => 'radio',
'options_callback' => array('tl_calendar_events', 'getSourceOptions'),
'reference' => &$GLOBALS['TL_LANG']['tl_calendar_events'],
'eval' => array('submitOnChange'=>true, 'helpwizard'=>true),
'sql' => "varchar(32) NOT NULL default ''"
),
'jumpTo' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['jumpTo'],
'exclude' => true,
'inputType' => 'pageTree',
'foreignKey' => 'tl_page.title',
'eval' => array('mandatory'=>true, 'fieldType'=>'radio'),
'sql' => "int(10) unsigned NOT NULL default '0'",
'relation' => array('type'=>'belongsTo', 'load'=>'lazy')
),
'articleId' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['articleId'],
'exclude' => true,
'inputType' => 'select',
'options_callback' => array('tl_calendar_events', 'getArticleAlias'),
'eval' => array('chosen'=>true, 'mandatory'=>true),
'sql' => "int(10) unsigned NOT NULL default '0'"
),
'url' => array
(
'label' => &$GLOBALS['TL_LANG']['MSC']['url'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('mandatory'=>true, 'decodeEntities'=>true, 'maxlength'=>255, 'tl_class'=>'w50'),
'sql' => "varchar(255) NOT NULL default ''"
),
'target' => array
(
'label' => &$GLOBALS['TL_LANG']['MSC']['target'],
'exclude' => true,
'inputType' => 'checkbox',
'eval' => array('tl_class'=>'w50 m12'),
'sql' => "char(1) NOT NULL default ''"
),
'cssClass' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['cssClass'],
'exclude' => true,
'inputType' => 'text',
'eval' => array('tl_class'=>'w50'),
'sql' => "varchar(255) NOT NULL default ''"
),
'noComments' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['noComments'],
'exclude' => true,
'filter' => true,
'inputType' => 'checkbox',
'eval' => array('tl_class'=>'w50 m12'),
'sql' => "char(1) NOT NULL default ''"
),
'published' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['published'],
'exclude' => true,
'filter' => true,
'flag' => 2,
'inputType' => 'checkbox',
'eval' => array('submitOnChange'=>true, 'doNotCopy'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'start' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['start'],
'exclude' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'datim', 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
'sql' => "varchar(10) NOT NULL default ''"
),
'stop' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_calendar_events']['stop'],
'exclude' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'datim', 'datepicker'=>true, 'tl_class'=>'w50 wizard'),
'sql' => "varchar(10) NOT NULL default ''"
)
)
);
/**
* Provide miscellaneous methods that are used by the data configuration array.
*
* @author Leo Feyer <https://github.com/leofeyer>
*/
class tl_calendar_events extends Backend
{
/**
* Import the back end user object
*/
public function __construct()
{
parent::__construct();
$this->import('BackendUser', 'User');
}
/**
* Check permissions to edit table tl_calendar_events
*/
public function checkPermission()
{
// HOOK: comments extension required
if (!in_array('comments', ModuleLoader::getActive()))
{
$key = array_search('allowComments', $GLOBALS['TL_DCA']['tl_calendar_events']['list']['sorting']['headerFields']);
unset($GLOBALS['TL_DCA']['tl_calendar_events']['list']['sorting']['headerFields'][$key]);
}
if ($this->User->isAdmin)
{
return;
}
// Set root IDs
if (!is_array($this->User->calendars) || empty($this->User->calendars))
{
$root = array(0);
}
else
{
$root = $this->User->calendars;
}
$id = strlen(Input::get('id')) ? Input::get('id') : CURRENT_ID;
// Check current action
switch (Input::get('act'))
{
case 'paste':
// Allow
break;
case 'create':
if (!strlen(Input::get('pid')) || !in_array(Input::get('pid'), $root))
{
$this->log('Not enough permissions to create events in calendar ID "'.Input::get('pid').'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
case 'cut':
case 'copy':
if (!in_array(Input::get('pid'), $root))
{
$this->log('Not enough permissions to '.Input::get('act').' event ID "'.$id.'" to calendar ID "'.Input::get('pid').'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
// NO BREAK STATEMENT HERE
case 'edit':
case 'show':
case 'delete':
case 'toggle':
$objCalendar = $this->Database->prepare("SELECT pid FROM tl_calendar_events WHERE id=?")
->limit(1)
->execute($id);
if ($objCalendar->numRows < 1)
{
$this->log('Invalid event ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
if (!in_array($objCalendar->pid, $root))
{
$this->log('Not enough permissions to '.Input::get('act').' event ID "'.$id.'" of calendar ID "'.$objCalendar->pid.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
case 'select':
case 'editAll':
case 'deleteAll':
case 'overrideAll':
case 'cutAll':
case 'copyAll':
if (!in_array($id, $root))
{
$this->log('Not enough permissions to access calendar ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$objCalendar = $this->Database->prepare("SELECT id FROM tl_calendar_events WHERE pid=?")
->execute($id);
if ($objCalendar->numRows < 1)
{
$this->log('Invalid calendar ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$session = $this->Session->getData();
$session['CURRENT']['IDS'] = array_intersect($session['CURRENT']['IDS'], $objCalendar->fetchEach('id'));
$this->Session->setData($session);
break;
default:
if (strlen(Input::get('act')))
{
$this->log('Invalid command "'.Input::get('act').'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
elseif (!in_array($id, $root))
{
$this->log('Not enough permissions to access calendar ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
}
}
/**
* Auto-generate the event alias if it has not been set yet
*
* @param mixed $varValue
* @param DataContainer $dc
*
* @return mixed
*
* @throws Exception
*/
public function generateAlias($varValue, DataContainer $dc)
{
$autoAlias = false;
// Generate alias if there is none
if ($varValue == '')
{
$autoAlias = true;
$varValue = StringUtil::generateAlias($dc->activeRecord->title);
}
$objAlias = $this->Database->prepare("SELECT id FROM tl_calendar_events WHERE alias=?")
->execute($varValue);
// Check whether the alias exists
if ($objAlias->numRows > 1 && !$autoAlias)
{
throw new Exception(sprintf($GLOBALS['TL_LANG']['ERR']['aliasExists'], $varValue));
}
// Add ID to alias
if ($objAlias->numRows && $autoAlias)
{
$varValue .= '-' . $dc->id;
}
return $varValue;
}
/**
* Automatically set the end time if not set
*
* @param mixed $varValue
* @param DataContainer $dc
*
* @return string
*/
public function setEmptyEndTime($varValue, DataContainer $dc)
{
if ($varValue === '')
{
$varValue = $dc->activeRecord->startTime;
}
return $varValue;
}
/**
* Set the end date to null if empty
*
* @param mixed $varValue
*
* @return mixed
*/
public function setEmptyEndDate($varValue)
{
if ($varValue === '')
{
$varValue = null;
}
return $varValue;
}
/**
* Add the type of input field
*
* @param array $arrRow
*
* @return string
*/
public function listEvents($arrRow)
{
$span = Calendar::calculateSpan($arrRow['startTime'], $arrRow['endTime']);
if ($span > 0)
{
$date = Date::parse(Config::get(($arrRow['addTime'] ? 'datimFormat' : 'dateFormat')), $arrRow['startTime']) . ' – ' . Date::parse(Config::get(($arrRow['addTime'] ? 'datimFormat' : 'dateFormat')), $arrRow['endTime']);
}
elseif ($arrRow['startTime'] == $arrRow['endTime'])
{
$date = Date::parse(Config::get('dateFormat'), $arrRow['startTime']) . ($arrRow['addTime'] ? ' ' . Date::parse(Config::get('timeFormat'), $arrRow['startTime']) : '');
}
else
{
$date = Date::parse(Config::get('dateFormat'), $arrRow['startTime']) . ($arrRow['addTime'] ? ' ' . Date::parse(Config::get('timeFormat'), $arrRow['startTime']) . ' – ' . Date::parse(Config::get('timeFormat'), $arrRow['endTime']) : '');
}
return '<div class="tl_content_left">' . $arrRow['title'] . ' <span style="color:#b3b3b3;padding-left:3px">[' . $date . ']</span></div>';
}
/**
* Get all articles and return them as array
*
* @param DataContainer $dc
*
* @return array
*/
public function getArticleAlias(DataContainer $dc)
{
$arrPids = array();
$arrAlias = array();
if (!$this->User->isAdmin)
{
foreach ($this->User->pagemounts as $id)
{
$arrPids[] = $id;
$arrPids = array_merge($arrPids, $this->Database->getChildRecords($id, 'tl_page'));
}
if (empty($arrPids))
{
return $arrAlias;
}
$objAlias = $this->Database->prepare("SELECT a.id, a.title, a.inColumn, p.title AS parent FROM tl_article a LEFT JOIN tl_page p ON p.id=a.pid WHERE a.pid IN(". implode(',', array_map('intval', array_unique($arrPids))) .") ORDER BY parent, a.sorting")
->execute($dc->id);
}
else
{
$objAlias = $this->Database->prepare("SELECT a.id, a.title, a.inColumn, p.title AS parent FROM tl_article a LEFT JOIN tl_page p ON p.id=a.pid ORDER BY parent, a.sorting")
->execute($dc->id);
}
if ($objAlias->numRows)
{
System::loadLanguageFile('tl_article');
while ($objAlias->next())
{
$arrAlias[$objAlias->parent][$objAlias->id] = $objAlias->title . ' (' . ($GLOBALS['TL_LANG']['COLS'][$objAlias->inColumn] ?: $objAlias->inColumn) . ', ID ' . $objAlias->id . ')';
}
}
return $arrAlias;
}
/**
* Add the source options depending on the allowed fields (see #5498)
*
* @param DataContainer $dc
*
* @return array
*/
public function getSourceOptions(DataContainer $dc)
{
if ($this->User->isAdmin)
{
return array('default', 'internal', 'article', 'external');
}
$arrOptions = array('default');
// Add the "internal" option
if ($this->User->hasAccess('tl_calendar_events::jumpTo', 'alexf'))
{
$arrOptions[] = 'internal';
}
// Add the "article" option
if ($this->User->hasAccess('tl_calendar_events::articleId', 'alexf'))
{
$arrOptions[] = 'article';
}
// Add the "external" option
if ($this->User->hasAccess('tl_calendar_events::url', 'alexf'))
{
$arrOptions[] = 'external';
}
// Add the option currently set
if ($dc->activeRecord && $dc->activeRecord->source != '')
{
$arrOptions[] = $dc->activeRecord->source;
$arrOptions = array_unique($arrOptions);
}
return $arrOptions;
}
/**
* Adjust start end end time of the event based on date, span, startTime and endTime
*
* @param DataContainer $dc
*/
public function adjustTime(DataContainer $dc)
{
// Return if there is no active record (override all)
if (!$dc->activeRecord)
{
return;
}
$arrSet['startTime'] = $dc->activeRecord->startDate;
$arrSet['endTime'] = $dc->activeRecord->startDate;
// Set end date
if (strlen($dc->activeRecord->endDate))
{
if ($dc->activeRecord->endDate > $dc->activeRecord->startDate)
{
$arrSet['endDate'] = $dc->activeRecord->endDate;
$arrSet['endTime'] = $dc->activeRecord->endDate;
}
else
{
$arrSet['endDate'] = $dc->activeRecord->startDate;
$arrSet['endTime'] = $dc->activeRecord->startDate;
}
}
// Add time
if ($dc->activeRecord->addTime)
{
$arrSet['startTime'] = strtotime(date('Y-m-d', $arrSet['startTime']) . ' ' . date('H:i:s', $dc->activeRecord->startTime));
$arrSet['endTime'] = strtotime(date('Y-m-d', $arrSet['endTime']) . ' ' . date('H:i:s', $dc->activeRecord->endTime));
}
// Adjust end time of "all day" events
elseif ((strlen($dc->activeRecord->endDate) && $arrSet['endDate'] == $arrSet['endTime']) || $arrSet['startTime'] == $arrSet['endTime'])
{
$arrSet['endTime'] = (strtotime('+ 1 day', $arrSet['endTime']) - 1);
}
$arrSet['repeatEnd'] = 0;
// Recurring events
if ($dc->activeRecord->recurring)
{
// Unlimited recurrences end on 2038-01-01 00:00:00 (see #4862)
if ($dc->activeRecord->recurrences == 0)
{
$arrSet['repeatEnd'] = 2145913200;
}
else
{
$arrRange = deserialize($dc->activeRecord->repeatEach);
$arg = $arrRange['value'] * $dc->activeRecord->recurrences;
$unit = $arrRange['unit'];
$strtotime = '+ ' . $arg . ' ' . $unit;
$arrSet['repeatEnd'] = strtotime($strtotime, $arrSet['endTime']);
}
}
$this->Database->prepare("UPDATE tl_calendar_events %s WHERE id=?")->set($arrSet)->execute($dc->id);
}
/**
* Check for modified calendar feeds and update the XML files if necessary
*/
public function generateFeed()
{
$session = $this->Session->get('calendar_feed_updater');
if (!is_array($session) || empty($session))
{
return;
}
$this->import('Calendar');
foreach ($session as $id)
{
$this->Calendar->generateFeedsByCalendar($id);
}
$this->import('Automator');
$this->Automator->generateSitemap();
$this->Session->set('calendar_feed_updater', null);
}
/**
* Schedule a calendar feed update
*
* This method is triggered when a single event or multiple events are
* modified (edit/editAll), moved (cut/cutAll) or deleted (delete/deleteAll).
* Since duplicated events are unpublished by default, it is not necessary
* to schedule updates on copyAll as well.
*
* @param DataContainer $dc
*/
public function scheduleUpdate(DataContainer $dc)
{
// Return if there is no ID
if (!$dc->activeRecord || !$dc->activeRecord->pid || Input::get('act') == 'copy')
{
return;
}
// Store the ID in the session
$session = $this->Session->get('calendar_feed_updater');
$session[] = $dc->activeRecord->pid;
$this->Session->set('calendar_feed_updater', array_unique($session));
}
/**
* Return the link picker wizard
*
* @param DataContainer $dc
*
* @return string
*/
public function pagePicker(DataContainer $dc)
{
return ' <a href="' . (($dc->value == '' || strpos($dc->value, '{{link_url::') !== false) ? 'contao/page.php' : 'contao/file.php') . '?do=' . Input::get('do') . '&table=' . $dc->table . '&field=' . $dc->field . '&value=' . rawurlencode(str_replace(array('{{link_url::', '}}'), '', $dc->value)) . '&switch=1' . '" title="' . specialchars($GLOBALS['TL_LANG']['MSC']['pagepicker']) . '" onclick="Backend.getScrollOffset();Backend.openModalSelector({'width':768,'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">' . Image::getHtml('pickpage.gif', $GLOBALS['TL_LANG']['MSC']['pagepicker'], 'style="vertical-align:top;cursor:pointer"') . '</a>';
}
/**
* Pre-fill the "alt" and "caption" fields with the file meta data
*
* @param mixed $varValue
* @param DataContainer $dc
*
* @return mixed
*/
public function storeFileMetaInformation($varValue, DataContainer $dc)
{
if ($dc->activeRecord->singleSRC != $varValue)
{
$this->addFileMetaInformationToRequest($varValue, 'tl_calendar', $dc->activeRecord->pid);
}
return $varValue;
}
/**
* Return the "toggle visibility" button
*
* @param array $row
* @param string $href
* @param string $label
* @param string $title
* @param string $icon
* @param string $attributes
*
* @return string
*/
public function toggleIcon($row, $href, $label, $title, $icon, $attributes)
{
if (strlen(Input::get('tid')))
{
$this->toggleVisibility(Input::get('tid'), (Input::get('state') == 1), (@func_get_arg(12) ?: null));
$this->redirect($this->getReferer());
}
// Check permissions AFTER checking the tid, so hacking attempts are logged
if (!$this->User->hasAccess('tl_calendar_events::published', 'alexf'))
{
return '';
}
$href .= '&tid='.$row['id'].'&state='.($row['published'] ? '' : 1);
if (!$row['published'])
{
$icon = 'invisible.gif';
}
return '<a href="'.$this->addToUrl($href).'" title="'.specialchars($title).'"'.$attributes.'>'.Image::getHtml($icon, $label, 'data-state="' . ($row['published'] ? 1 : 0) . '"').'</a> ';
}
/**
* Disable/enable a user group
*
* @param integer $intId
* @param boolean $blnVisible
* @param DataContainer $dc
*/
public function toggleVisibility($intId, $blnVisible, DataContainer $dc=null)
{
// Set the ID and action
Input::setGet('id', $intId);
Input::setGet('act', 'toggle');
if ($dc)
{
$dc->id = $intId; // see #8043
}
$this->checkPermission();
// Check the field access
if (!$this->User->hasAccess('tl_calendar_events::published', 'alexf'))
{
$this->log('Not enough permissions to publish/unpublish event ID "'.$intId.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$objVersions = new Versions('tl_calendar_events', $intId);
$objVersions->initialize();
// Trigger the save_callback
if (is_array($GLOBALS['TL_DCA']['tl_calendar_events']['fields']['published']['save_callback']))
{
foreach ($GLOBALS['TL_DCA']['tl_calendar_events']['fields']['published']['save_callback'] as $callback)
{
if (is_array($callback))
{
$this->import($callback[0]);
$blnVisible = $this->{$callback[0]}->{$callback[1]}($blnVisible, ($dc ?: $this));
}
elseif (is_callable($callback))
{
$blnVisible = $callback($blnVisible, ($dc ?: $this));
}
}
}
// Update the database
$this->Database->prepare("UPDATE tl_calendar_events SET tstamp=". time() .", published='" . ($blnVisible ? '1' : '') . "' WHERE id=?")
->execute($intId);
$objVersions->create();
$this->log('A new version of record "tl_calendar_events.id='.$intId.'" has been created'.$this->getParentEntries('tl_calendar_events', $intId), __METHOD__, TL_GENERAL);
// Update the RSS feed (for some reason it does not work without sleep(1))
sleep(1);
$this->import('Calendar');
$this->Calendar->generateFeedsByCalendar(CURRENT_ID);
}
}