PHP-Code:
<?php if (!defined('TL_ROOT')) die('You cannot access this file directly!');
$GLOBALS['TL_DCA']['tl_sendeplan'] = array(
// Config
'config' => array(
'dataContainer' => 'Table',
'enableVersioning' => true
),
// List
'list' => array(
'sorting' => array(
'panelLayout' => 'filter;sort,search,limit'
),
'label' => array
(
'fields' => array('headline'),
'format' => '%s'
),
'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_sendeplan']['edit'],
'href' => 'act=edit',
'icon' => 'edit.gif'
),
'copy' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['copy'],
'href' => 'act=paste&mode=copy',
'icon' => 'copy.gif'
),
'cut' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['cut'],
'href' => 'act=paste&mode=cut',
'icon' => 'cut.gif'
),
'delete' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['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_sendeplan']['show'],
'href' => 'act=show',
'icon' => 'show.gif'
)
)
),
// Palettes
'palettes' => array(
#'__selector__' => array('addImage', 'addEnclosure', 'source'),
'default' => '{title_legend},headline,alias,author;{sendeplan_legend},groups,montag_1,montag_2,montag_3;'
),
// Fields
'fields' => array(
'headline' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['headline'],
'exclude' => true,
'search' => true,
'sorting' => true,
'flag' => 1,
'inputType' => 'text',
'eval' => array('mandatory'=>true, 'maxlength'=>255)
),
'alias' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['alias'],
'exclude' => true,
'search' => true,
'inputType' => 'text',
'eval' => array('rgxp'=>'alnum', 'unique'=>true, 'spaceToUnderscore'=>true, 'maxlength'=>128, 'tl_class'=>'w50'),
'save_callback' => array(
array('tl_sendeplan', 'generateAlias')
)
),
'author' => array
(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['author'],
'default' => "3",
'exclude' => true,
'inputType' => 'select',
'foreignKey' => 'tl_user.name',
'eval' => array('doNotCopy'=>true, 'mandatory'=>true, 'includeBlankOption'=>true, 'tl_class'=>'w50')
),
'groups' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['groups'],
'exclude' => true,
'search' => true,
'inputType' => 'checkboxWizard',
'foreignKey' => 'tl_member_group.name',
'eval' => array('multiple'=>true, 'feEditable'=>true, 'submitOnChange'=>true)
),
'montag_1' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['montag_1'],
'default' => 3,
'exclude' => true,
'search' => true,
'inputType' => 'select',
'options_callback' => array('tl_sendeplan', 'getAllDJ'),
'eval' => array('doNotCopy'=>true,'includeBlankOption'=>true)
),
'montag_2' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['montag_2'],
'exclude' => true,
'search' => true,
'inputType' => 'select',
'options_callback' => array('tl_sendeplan', 'getAllDJ'),
'eval' => array('includeBlankOption'=>true)
),
'montag_3' => array(
'label' => &$GLOBALS['TL_LANG']['tl_sendeplan']['montag_3'],
'exclude' => true,
'search' => true,
'inputType' => 'select',
'options_callback' => array('tl_sendeplan', 'getAllDJ'),
'eval' => array('includeBlankOption'=>true)
)
)
);
class tl_sendeplan extends Backend{
public function __construct(){
parent::__construct();
}
public function getAllDJ(DataContainer $dc){
$Sendeplan = $this->Database->prepare("SELECT * FROM tl_sendeplan WHERE id = ?")->execute($dc->activeRecord->id);
$Sendeplan = $Sendeplan->row();
$User = $this->Database->prepare("SELECT * FROM tl_member")->execute();
$goups = deserialize($Sendeplan['groups']);
$user = array();
while($User->next()){
$row = $User->row();
$usergroups = deserialize($row['groups']);
if(is_array($goups))
$diff = array_diff($goups,$usergroups);
else $diff = array();
if(empty($diff)){
$user[$row['id']] = $row['firstname'].' '.$row['lastname'];
};
}
return $user;
}
public function generateAlias($varValue, DataContainer $dc){
$autoAlias = false;
// Generate alias if there is none
if (!strlen($varValue))
{
$autoAlias = true;
$varValue = standardize($dc->activeRecord->headline);
}
$objAlias = $this->Database->prepare("SELECT id FROM tl_sendeplan 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;
}
}
?>
Dazu meine config.php
Code:
CREATE TABLE `tl_sendeplan` (
`id` int(10) unsigned NOT NULL auto_increment,
`tstamp` int(10) unsigned NOT NULL default '0',
`headline` varchar(255) NOT NULL default '',
`alias` varbinary(128) NOT NULL default '',
`author` int(10) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`time` int(10) unsigned NOT NULL default '0',
`subheadline` varchar(255) NOT NULL default '',
`groups` varchar(255) NOT NULL default '',
`week_start` varchar(255) NOT NULL default '',
`week_end` varchar(255) NOT NULL default '',
`Montag_1` int(10) unsigned NOT NULL default '0',
`Montag_2` int(10) NOT NULL default '0',
`Montag_3` int(10) NOT NULL default '0',
`Dienstag_1` int(10) NOT NULL default '0',
`Dienstag_2` int(10) NOT NULL default '0',
`Dienstag_3` int(10) NOT NULL default '0',
`Mittwoch_1` int(10) NOT NULL default '0',
`Mittwoch_2` int(10) NOT NULL default '0',
`Mittwoch_3` int(10) NOT NULL default '0',
`Donnerstag_1` int(10) NOT NULL default '0',
`Donnerstag_2` int(10) NOT NULL default '0',
`Donnerstag_3` int(10) NOT NULL default '0',
`Freitag_1` int(10) NOT NULL default '0',
`Freitag_2` int(10) NOT NULL default '0',
`Freitag_3` int(10) NOT NULL default '0',
`Samstag_1` int(10) NOT NULL default '0',
`Samstag_2` int(10) NOT NULL default '0',
`Samstag_3` int(10) NOT NULL default '0',
`Sonntag_1` int(10) NOT NULL default '0',
`Sonntag_2` int(10) NOT NULL default '0',
`Sonntag_3` int(10) NOT NULL default '0'
PRIMARY KEY (`id`),
KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Grüsse
InputType Select / select="selected"
Zitieren
Lesezeichen