Файл: contao-3.5.8/system/modules/newsletter/dca/tl_newsletter_recipients.php
Строк: 412
<?php
/**
* Contao Open Source CMS
*
* Copyright (c) 2005-2016 Leo Feyer
*
* @license LGPL-3.0+
*/
/**
* Table tl_newsletter_recipients
*/
$GLOBALS['TL_DCA']['tl_newsletter_recipients'] = array
(
// Config
'config' => array
(
'dataContainer' => 'Table',
'ptable' => 'tl_newsletter_channel',
'enableVersioning' => true,
'onload_callback' => array
(
array('tl_newsletter_recipients', 'checkPermission')
),
'oncut_callback' => array
(
array('tl_newsletter_recipients', 'clearOptInData')
),
'sql' => array
(
'keys' => array
(
'id' => 'primary',
'pid' => 'index',
'email' => 'index'
)
)
),
// List
'list' => array
(
'sorting' => array
(
'mode' => 4,
'fields' => array('email'),
'panelLayout' => 'filter;sort,search,limit',
'headerFields' => array('title', 'jumpTo', 'tstamp', 'useSMTP'),
'child_record_callback' => array('tl_newsletter_recipients', 'listRecipient'),
'child_record_class' => 'no_padding'
),
'global_operations' => array
(
'import' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['import'],
'href' => 'key=import',
'class' => 'header_css_import',
'attributes' => 'onclick="Backend.getScrollOffset()"'
),
'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_recipients']['edit'],
'href' => 'act=edit',
'icon' => 'edit.gif'
),
'copy' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['copy'],
'href' => 'act=paste&mode=copy',
'icon' => 'copy.gif'
),
'cut' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['cut'],
'href' => 'act=paste&mode=cut',
'icon' => 'cut.gif'
),
'delete' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['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_newsletter_recipients']['toggle'],
'icon' => 'visible.gif',
'attributes' => 'onclick="Backend.getScrollOffset();return AjaxRequest.toggleVisibility(this,%s)"',
'button_callback' => array('tl_newsletter_recipients', 'toggleIcon')
),
'show' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['show'],
'href' => 'act=show',
'icon' => 'show.gif'
)
)
),
// Palettes
'palettes' => array
(
'default' => '{email_legend},email,active',
),
// 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'=>'lazy')
),
'tstamp' => array
(
'sql' => "int(10) unsigned NOT NULL default '0'"
),
'email' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['email'],
'exclude' => true,
'search' => true,
'sorting' => true,
'flag' => 1,
'inputType' => 'text',
'eval' => array('mandatory'=>true, 'rgxp'=>'email', 'maxlength'=>128, 'decodeEntities'=>true),
'save_callback' => array
(
array('tl_newsletter_recipients', 'checkUniqueRecipient')
),
'sql' => "varchar(255) NOT NULL default ''"
),
'active' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['active'],
'exclude' => true,
'filter' => true,
'inputType' => 'checkbox',
'eval' => array('doNotCopy'=>true),
'sql' => "char(1) NOT NULL default ''"
),
'source' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['source'],
'eval' => array('fieldType'=>'checkbox', 'filesOnly'=>true, 'extensions'=>'csv', 'class'=>'mandatory')
),
'addedOn' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['addedOn'],
'filter' => true,
'sorting' => true,
'flag' => 8,
'eval' => array('rgxp'=>'datim', 'doNotCopy'=>true),
'sql' => "varchar(10) NOT NULL default ''"
),
'confirmed' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['confirmed'],
'filter' => true,
'sorting' => true,
'flag' => 8,
'eval' => array('rgxp'=>'datim', 'doNotCopy'=>true),
'sql' => "varchar(10) NOT NULL default ''"
),
'ip' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['ip'],
'search' => true,
'sorting' => true,
'flag' => 11,
'eval' => array('doNotCopy'=>true),
'sql' => "varchar(64) NOT NULL default ''"
),
'token' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_newsletter_recipients']['token'],
'eval' => array('doNotCopy'=>true),
'sql' => "varchar(32) NOT NULL default ''"
)
)
);
/**
* Provide miscellaneous methods that are used by the data configuration array.
*
* @author Leo Feyer <https://github.com/leofeyer>
*/
class tl_newsletter_recipients extends Backend
{
/**
* Import the back end user object
*/
public function __construct()
{
parent::__construct();
$this->import('BackendUser', 'User');
}
/**
* Check permissions to edit table tl_newsletter_recipients
*/
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 recipients 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 recipient 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':
case 'toggle':
$objRecipient = $this->Database->prepare("SELECT pid FROM tl_newsletter_recipients WHERE id=?")
->limit(1)
->execute($id);
if ($objRecipient->numRows < 1)
{
$this->log('Invalid newsletter recipient ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
if (!in_array($objRecipient->pid, $root))
{
$this->log('Not enough permissions to '.Input::get('act').' recipient ID "'.$id.'" of newsletter channel ID "'.$objRecipient->pid.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
case 'editAll':
case 'deleteAll':
case 'overrideAll':
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');
}
$objRecipient = $this->Database->prepare("SELECT id FROM tl_newsletter_recipients WHERE pid=?")
->execute($id);
if ($objRecipient->numRows < 1)
{
$this->log('Invalid newsletter recipient ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$session = $this->Session->getData();
$session['CURRENT']['IDS'] = array_intersect($session['CURRENT']['IDS'], $objRecipient->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 newsletter recipient ID "'.$id.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
break;
}
}
/**
* Reset the double opt-in data if a recipient is moved manually
*
* @param DataContainer $dc
*/
public function clearOptInData(DataContainer $dc)
{
$this->Database->prepare("UPDATE tl_newsletter_recipients SET addedOn='', confirmed='', ip='', token='' WHERE id=?")
->execute($dc->id);
}
/**
* Check if recipients are unique per channel
*
* @param mixed $varValue
* @param DataContainer $dc
*
* @return mixed
*
* @throws Exception
*/
public function checkUniqueRecipient($varValue, DataContainer $dc)
{
$objRecipient = $this->Database->prepare("SELECT COUNT(*) AS count FROM tl_newsletter_recipients WHERE email=? AND pid=(SELECT pid FROM tl_newsletter_recipients WHERE id=?) AND id!=?")
->execute($varValue, $dc->id, $dc->id);
if ($objRecipient->count > 0)
{
throw new Exception(sprintf($GLOBALS['TL_LANG']['ERR']['unique'], $GLOBALS['TL_LANG'][$dc->table][$dc->field][0]));
}
return $varValue;
}
/**
* List a recipient
*
* @param array $row
*
* @return string
*/
public function listRecipient($row)
{
$label = $row['email'];
if ($row['addedOn'])
{
$label .= ' <span style="color:#b3b3b3;padding-left:3px">(' . sprintf($GLOBALS['TL_LANG']['tl_newsletter_recipients']['subscribed'], Date::parse(Config::get('datimFormat'), $row['addedOn'])) . ')</span>';
}
else
{
$label .= ' <span style="color:#b3b3b3;padding-left:3px">(' . $GLOBALS['TL_LANG']['tl_newsletter_recipients']['manually'] . ')</span>';
}
return sprintf('<div class="tl_content_left"><div class="list_icon" style="background-image:url('%ssystem/themes/%s/images/%s.gif')" data-icon="member.gif">%s</div></div>', TL_ASSETS_URL, Backend::getTheme(), ($row['active'] ? 'member' : 'member_'), $label) . "n";
}
/**
* 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_newsletter_recipients::active', 'alexf'))
{
return '';
}
$href .= '&tid='.$row['id'].'&state='.($row['active'] ? '' : 1);
if (!$row['active'])
{
$icon = 'invisible.gif';
}
return '<a href="'.$this->addToUrl($href).'" title="'.specialchars($title).'"'.$attributes.'>'.Image::getHtml($icon, $label, 'data-state="' . ($row['active'] ? 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_newsletter_recipients::active', 'alexf'))
{
$this->log('Not enough permissions to publish/unpublish newsletter recipient ID "'.$intId.'"', __METHOD__, TL_ERROR);
$this->redirect('contao/main.php?act=error');
}
$objVersions = new Versions('tl_newsletter_recipients', $intId);
$objVersions->initialize();
// Trigger the save_callback
if (is_array($GLOBALS['TL_DCA']['tl_newsletter_recipients']['fields']['active']['save_callback']))
{
foreach ($GLOBALS['TL_DCA']['tl_newsletter_recipients']['fields']['active']['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_newsletter_recipients SET tstamp=". time() .", active='" . ($blnVisible ? 1 : '') . "' WHERE id=?")
->execute($intId);
$objVersions->create();
$this->log('A new version of record "tl_newsletter_recipients.id='.$intId.'" has been created'.$this->getParentEntries('tl_newsletter_recipients', $intId), __METHOD__, TL_GENERAL);
}
}