Файл: contao-3.5.8/system/modules/newsletter/dca/tl_newsletter.php
Строк: 393
<?php
/**
* Contao Open Source CMS
*
* Copyright (c) 2005-2016 Leo Feyer
*
* @license LGPL-3.0+
*/
/**
* Table tl_newsletter
*/
$GLOBALS['TL_DCA']['tl_newsletter'] = array
(
// Config
'config' => array
(
'dataContainer' => 'Table',
'ptable' => 'tl_newsletter_channel',
'enableVersioning' => true,
'onload_callback' => array
(
array('tl_newsletter', 'checkPermission')
),
'sql' => array
(
'keys' => array
(
'id' => 'primary',
'pid' => 'index'
)
)
),
// List
'list' => array
(
'sorting' => array
(
'mode' => 4,
'fields' => array('sent', 'date DESC', 'tstamp DESC'),
'headerFields' => array('title', 'jumpTo', 'tstamp', 'useSMTP'),
'panelLayout' => 'filter;sort,search,limit',
'child_record_callback' => array('tl_newsletter', 'listNewsletters')
),
'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_newsletter']['edit'],
'href' => 'act=edit',
'icon' => 'edit.gif'
),
'copy' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['copy'],
'href' => 'act=paste&mode=copy',
'icon' => 'copy.gif'
),
'cut' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['cut'],
'href' => 'act=paste&mode=cut',
'icon' => 'cut.gif'
),
'delete' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['delete'],
'href' => 'act=delete',
'icon' => 'delete.gif',
'attributes' => 'onclick="if(!confirm('' . $GLOBALS['TL_LANG']['MSC']['deleteConfirm'] . ''))return false;Backend.getScrollOffset()"'
),
'show' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['show'],
'href' => 'act=show',
'icon' => 'show.gif'
),
'send' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['send'],
'href' => 'key=send',
'icon' => 'system/modules/newsletter/assets/icon.gif'
)
)
),
// Palettes
'palettes' => array
(
'__selector__' => array('addFile'),
'default' => '{title_legend},subject,alias;{html_legend},content;{text_legend:hide},text;{attachment_legend},addFile;{template_legend:hide},template;{expert_legend:hide},sendText,externalImages,senderName,sender'
),
// Subpalettes
'subpalettes' => array
(
'addFile' => 'files'
),
// Fields
'fields' => array
(
'id' => array
(
'sql' => "int(10) unsigned NOT NULL auto_increment"
),
'pid' => array
(
'foreignKey' => 'tl_newsletter_channel.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'"
),
'subject' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['subject'],
'exclude' => true,
'search' => true,
'sorting' => true,
'flag' => 1,
'inputType' => 'text',
'eval' => array('mandatory'=>true, 'decodeEntities'=>true, 'maxlength'=>128, 'tl_class'=>'w50'),
'sql' => "varchar(255) NOT NULL default ''"
),
'alias' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['alias'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'alias', 'unique'=>true, 'maxlength'=>128, 'tl_class'=>'w50'),
'save_callback' => array
(
array('tl_newsletter', 'generateAlias')
),
'sql' => "varchar(128) COLLATE utf8_bin NOT NULL default ''"
),
'content' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['content'],
'exclude' => true,
'search' => true,
'inputType' => 'textarea',
'eval' => array('rte'=>'tinyNews', 'helpwizard'=>true),
'explanation' => 'insertTags',
'load_callback' => array
(
array('tl_newsletter', 'convertAbsoluteLinks')
),
'save_callback' => array
(
array('tl_newsletter', 'convertRelativeLinks')
),
'sql' => "mediumtext NULL"
),
'text' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['text'],
'exclude' => true,
'search' => true,
'inputType' => 'textarea',
'eval' => array('decodeEntities'=>true, 'class'=>'noresize'),
'sql' => "mediumtext NULL"
),
'addFile' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['addFile'],
'exclude' => true,
'filter' => true,
'inputType' => 'checkbox',
'eval' => array('submitOnChange'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'files' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['files'],
'exclude' => true,
'inputType' => 'fileTree',
'eval' => array('multiple'=>true, 'fieldType'=>'checkbox', 'filesOnly'=>true, 'mandatory'=>true),
'sql' => "blob NULL"
),
'template' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['template'],
'default' => 'mail_default',
'exclude' => true,
'inputType' => 'select',
'options_callback' => array('tl_newsletter', 'getMailTemplates'),
'sql' => "varchar(32) NOT NULL default ''"
),
'sendText' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['sendText'],
'exclude' => true,
'filter' => true,
'inputType' => 'checkbox',
'eval' => array('tl_class'=>'w50'),
'sql' => "char(1) NOT NULL default ''"
),
'externalImages' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['externalImages'],
'exclude' => true,
'inputType' => 'checkbox',
'eval' => array('tl_class'=>'w50'),
'sql' => "char(1) NOT NULL default ''"
),
'sender' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['sender'],
'exclude' => true,
'search' => true,
'filter' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'email', 'maxlength'=>128, 'decodeEntities'=>true, 'tl_class'=>'w50'),
'sql' => "varchar(128) NOT NULL default ''"
),
'senderName' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['senderName'],
'exclude' => true,
'search' => true,
'sorting' => true,
'flag' => 11,
'inputType' => 'text',
'eval' => array('decodeEntities'=>true, 'maxlength'=>128, 'tl_class'=>'w50'),
'sql' => "varchar(128) NOT NULL default ''"
),
'sent' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['sent'],
'filter' => true,
'sorting' => true,
'flag' => 11,
'eval' => array('doNotCopy'=>true, 'isBoolean'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'date' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter']['mailingDate'],
'filter' => true,
'sorting' => true,
'flag' => 8,
'eval' => array('rgxp'=>'datim'),
'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_newsletter extends Backend
{
/**
* Import the back end user object
*/
public function __construct()
{
parent::__construct();
$this->import('BackendUser', 'User');
}
/**
* Check permissions to edit table tl_newsletter
*/
public function checkPermission()
{
if ($this->User->isAdmin)
{
return;
}
// Set root IDs
if (!is_array($this->User->newsletters) || empty($this->User->newsletters))
{
$root = array(0);
}
else
{
$root = $this->User->newsletters;
}
$id = strlen(Input::get('id')) ? Input::get('id') : CURRENT_ID;
// Check current action
switch (Input::get('act'))
{
case 'paste':
case 'select':
// Allow
break;
case 'create':
if (!strlen(Input::get('pid')) || !in_array(Input::get('pid'), $root))
{
$this->log('Not enough permissions to create newsletters in channel 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').' newsletter ID "'.$id.'" to channel ID "'.Input::get('pid').'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
// NO BREAK STATEMENT HERE
case 'edit':
case 'show':
case 'delete':
$objChannel = $this->Database->prepare("SELECT pid FROM tl_newsletter WHERE id=?")
->limit(1)
->execute($id);
if ($objChannel->numRows < 1)
{
$this->log('Invalid newsletter ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
if (!in_array($objChannel->pid, $root))
{
$this->log('Not enough permissions to '.Input::get('act').' newsletter ID "'.$id.'" of newsletter channel ID "'.$objChannel->pid.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
case 'editAll':
case 'deleteAll':
case 'overrideAll':
case 'cutAll':
case 'copyAll':
if (!in_array($id, $root))
{
$this->log('Not enough permissions to access newsletter channel ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$objChannel = $this->Database->prepare("SELECT id FROM tl_newsletter WHERE pid=?")
->execute($id);
if ($objChannel->numRows < 1)
{
$this->log('Invalid newsletter channel ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$session = $this->Session->getData();
$session['CURRENT']['IDS'] = array_intersect($session['CURRENT']['IDS'], $objChannel->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');
}
if (Input::get('key') == 'send')
{
$objChannel = $this->Database->prepare("SELECT pid FROM tl_newsletter WHERE id=?")
->limit(1)
->execute($id);
if ($objChannel->numRows < 1)
{
$this->log('Invalid newsletter ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
if (!in_array($objChannel->pid, $root))
{
$this->log('Not enough permissions to send newsletter ID "'.$id.'" of newsletter channel ID "'.$objChannel->pid.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
}
elseif (!in_array($id, $root))
{
$this->log('Not enough permissions to access newsletter channel ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
}
}
/**
* List records
*
* @param array $arrRow
*
* @return string
*/
public function listNewsletters($arrRow)
{
return '
<div class="cte_type ' . (($arrRow['sent'] && $arrRow['date']) ? 'published' : 'unpublished') . '"><strong>' . $arrRow['subject'] . '</strong> - ' . (($arrRow['sent'] && $arrRow['date']) ? sprintf($GLOBALS['TL_LANG']['tl_newsletter']['sentOn'], Date::parse(Config::get('datimFormat'), $arrRow['date'])) : $GLOBALS['TL_LANG']['tl_newsletter']['notSent']) . '</div>
<div class="limit_height' . (!Config::get('doNotCollapse') ? ' h128' : '') . '">' . (!$arrRow['sendText'] ? '
' . StringUtil::insertTagToSrc($arrRow['content']) . '<hr>' : '' ) . '
<pre style="white-space:pre-wrap">' . $arrRow['text'] . '</pre>
</div>' . "n";
}
/**
* Convert absolute URLs from TinyMCE to relative URLs
*
* @param string $strContent
*
* @return string
*/
public function convertAbsoluteLinks($strContent)
{
return str_replace('src="' .Environment::get('base'), 'src="', $strContent);
}
/**
* Convert relative URLs from TinyMCE to absolute URLs
*
* @param string $strContent
*
* @return string
*/
public function convertRelativeLinks($strContent)
{
return $this->convertRelativeUrls($strContent);
}
/**
* Auto-generate the newsletter 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->subject);
}
$objAlias = $this->Database->prepare("SELECT id FROM tl_newsletter WHERE alias=?")
->execute($varValue);
// Check whether the news 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;
}
/**
* Return all mail templates as array
*
* @return array
*/
public function getMailTemplates()
{
return $this->getTemplateGroup('mail_');
}
}