development/coursemanagement-bundle/src/Resources/contao/dca/tl_calendar_events.php line 125

Open in your IDE?
  1. <?php
  3. use CityMountain\ToolBundle\Utils\OperationTool;
  4. use CityMountain\CourseManagementBundle\Utils\OperationCM;
  5. use CityMountain\CourseManagementBundle\Utils\ReplaceInsertTagsListener;
  7. //$this->import('BackendUser', 'User');
  9. /**
  10.  * add config
  11.  */
  12. $GLOBALS['TL_DCA']['tl_calendar_events']['config']['switchToEdit'] = false;
  14. $GLOBALS['TL_DCA']['tl_calendar_events']['config']['onsubmit_callback'][] = array('tl_calendar_eventsCM', 'generateIndex');
  15. $GLOBALS['TL_DCA']['tl_calendar_events']['config']['onload_callback'][] = array('tl_calendar_eventsCM', 'permissionEdit');
  18. /**
  19.  * add list
  20.  */
  21. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['sorting']['child_record_callback'] = array('tl_calendar_eventsCM', 'listEvents');
  23. //FILTER!!
  26. /**
  27.  * add operations
  28.  */
  29. $GLOBALS['TL_DCA']['tl_calendar_events']['edit']['buttons_callback'] = array(array('tl_calendar_eventsCM', 'editButtonAtEdit'));
  31. unset($GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['edit']);
  32. unset($GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['cut']);
  33. unset($GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['feature']);
  35. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['global_operations']['all']['button_callback'] = array('tl_calendar_eventsCM', 'buttonGlobal');
  36. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['editheader']['icon'] = 'edit.svg';
  37. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['delete']['button_callback'] = array('tl_calendar_eventsCM', 'buttonDelete');
  40. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['cmActEveBookingImport'] = array(
  41.     'label'               => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmActEveBookingImport'],
  42.     'href'                => 'key=importBooking',
  43.     'icon'                => 'bundles/citymountaincoursemanagement/icons/iconUpload.svg',
  44.     //'button_callback'     => array('tl_calendar_eventsCM', 'buttonBooking')
  45. );
  46. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['cmActEveBooking'] = array(
  47.     'label'               => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmActEveBooking'],
  48.     'href'                => 'table=tl_zEventBooking',
  49.     'icon'                => 'bundles/citymountaincoursemanagement/icons/booking.png',
  50.     'button_callback'     => array('tl_calendar_eventsCM', 'buttonBooking')
  51. );
  52. $GLOBALS['TL_DCA']['tl_calendar_events']['list']['operations']['cmActEveExport'] = array(
  53.     'label'               => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmActEveExport'],
  54.     'href'                   => 'act=show&key=eventExport',
  55.     'icon'                => 'bundles/citymountaincoursemanagement/icons/exportEve.png',
  56. );
  58. /**
  59.  * add palettes
  60.  */
  62. $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['__selector__'][] = 'cmMoreDate';
  63. $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['__selector__'][] = 'cmRegistrationVariant';
  64. $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['__selector__'][] = 'cmEventHybrid';
  66. $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = '
  67.         {title_legend},fkUnit,fkEventType,fkEventSector1,fkEventSector2,title,author;
  68.         {date_legend},startDate,addTime,cmMoreDate;
  69.         
  70.         {legendCMGeneral},cmLocation,cmCost,cmClosingDate,cmMaxTn,cmEventHybrid,cmCoursLeader,fkUnitConfirmationMail,cmContact,cmRegistrationVariant;
  71.         {legendCMSpecialSetting:hide},fkUnitRightEvent,cmEventCanceled,cmMoreConfirmationMail,cmEventRequestType,cmTarget;
  72.         
  73.         {details_legend},cmTeaserShort,teaser;
  75.         {enclosure_legend:hide},addEnclosure;
  76.         
  77.         {publish_legend},published,start,stop';
  80. /**
  81.  * add subpalettes
  82.  */
  83. array_insert($GLOBALS['TL_DCA']['tl_calendar_events']['subpalettes'], 2, array
  84.     (
  85.          'cmRegistrationVariant_url' => 'urlExtern',
  86.          'cmMoreDate'                 => 'cmMoreDateTime',
  87.          'cmEventHybrid'             => 'cmEventHybridTool',
  88.     )
  89. );
  90. $GLOBALS['TL_DCA']['tl_calendar_events']['subpalettes']['addTime'] =  'startTime,endTime';
  92. /**
  93.  * Standartfelder beeinflussen
  94.  */
  96. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['author']['filter']            = false;
  97. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['featured']['filter']        = false;
  98. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['recurring']['filter']        = false;
  99. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['address']['search']            = false;
  100. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['alt']['search']                = false;
  101. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['author']['search']            = false;
  102. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['imageUrl']['search']        = false;
  103. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['imageTitle']['search']        = false;
  104. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['caption']['search']            = false;
  105. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['alias']['search']            = false;
  106. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['url']['search']                = false;
  107. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['location']['search']        = false;
  108. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['robots']['search']            = false;
  109. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['pageTitle']['search']        = false;
  110. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['description']['search']        = false;
  111. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['author']['sorting']            = false;
  113. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['title']['eval']['maxlength']= 82;
  114. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['featured']['eval']['tl_class']= 'clr w50 m12';
  115. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['addTime']['eval']['tl_class']= 'clr w50 m12';
  117. if(isset($GLOBALS['TL_LANG']['tl_calendar_events']['cmTeaser']))$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['teaser']['label'] = $GLOBALS['TL_LANG']['tl_calendar_events']['cmTeaser'];
  119. /**
  120.  * add fields
  121.  */
  123. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['fkUnit'] = array
  124. (
  125.     'default'                  => OperationCM::getDefaultUnitFromUserToEdit(),
  126.     'filter'                  => true,
  127.     'sorting'                  => true,
  128.     'search'                  => true,
  129.     'inputType'               => 'select',
  130.     'reference'               => OperationTool::getUnits(0,1), 
  131.     'options_callback'          => array('tl_calendar_eventsCM', 'getUnits'),
  132.     'eval'                    => array('mandatory'=>true,'chosen'=>true, 'includeBlankOption'=>true,'tl_class'=>'w50'),
  133.     'sql'                     => "int(10) unsigned NOT NULL default '0'"
  134. );
  136. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['fkEventType'] = array
  137. (
  138.     'filter'                  => true,
  139.     'inputType'               => 'select',
  140.     'reference'               => OperationTool::getMasterdataValues(0,"eventType",1), 
  141.     'options_callback'          => array('tl_calendar_eventsCM', 'getEventType'),
  142.     'eval'                    => array('mandatory'=>true,'chosen'=>true,'includeBlankOption'=>true, 'tl_class'=>'w50', 'doNotSaveEmpty' => true),
  143.     'sql'                     => "int(10) unsigned NOT NULL default '0'",
  144. );
  146. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['fkEventSector1'] = array
  147. (
  148.     'filter'                  => true,
  149.     'inputType'               => 'select',
  150.     'options_callback'          => array('tl_calendar_eventsCM', 'getEventSector1'),
  151.     'eval'                    => array('chosen'=>true,'multiple'=>true, 'tl_class'=>'w50'),
  152.     'save_callback'              => array(array('tl_calendar_eventsCM', 'saveCheckEventSector')),
  153.     'sql'                     => "blob NULL"
  154. );
  155. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['fkEventSector2'] = array
  156. (
  157.     'filter'                  => true,
  158.     'inputType'               => 'select',
  159.     'options_callback'          => array('tl_calendar_eventsCM', 'getEventSector2'),
  160.     'eval'                    => array('chosen'=>true,'multiple'=>true, 'tl_class'=>'w50'),
  161.     'save_callback'              => array(array('tl_calendar_eventsCM', 'saveCheckEventSector')),
  162.     'sql'                     => "blob NULL"
  163. );
  164. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmMoreDate'] = array
  165. (
  166.     'inputType'               => 'checkbox',
  167.     'eval'                    => array('tl_class'=>'clr w50 m12','submitOnChange'=>true),
  168.     'sql'                     => "char(1) NOT NULL default ''"
  169. );
  170. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmMoreDateTime'] = array
  171. (
  172.     'inputType'         => 'multiColumnWizard',
  173.     'eval'              => array('tl_class'=>'cmWizard',
  174.                                  'columnFields'=>array(
  175.                                      'cmMoreStartDate' => array(
  176.                                          'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['startDate'],
  177.                                          'inputType' => 'text',
  178.                                          'eval'      => array('mandatory'=>false, 'rgxp'=>'date', 'datepicker'=>true, 'submitOnChange'=>false, 'doNotCopy'=>true, 'style'=>'width:100px', 'tl_class'=>'wizard')
  179.                                      ),
  180.                                      'cmMoreStartTime' => array
  181.                                      (
  182.                                          'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['startTime'],
  183.                                          'inputType' => 'text',
  184.                                          'eval'      => array('rgxp'=>'time', 'datepicker'=>true, 'submitOnChange'=>false, 'doNotCopy'=>true, 'style'=>'width:100px')
  185.                                      ),
  186.                                      'cmMoreEndTime' => array
  187.                                      (
  188.                                          'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['endTime'],
  189.                                          'inputType' => 'text',
  190.                                          'eval'      => array('rgxp'=>'time', 'datepicker'=>true, 'submitOnChange'=>false, 'doNotCopy'=>true, 'style'=>'width:100px;')
  191.                                      )
  192.                                  )
  193.                                 ),
  194.     'sql'               => "blob NULL"
  195. );
  196. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmLocation'] = array
  197. (
  198.     'search'                  => true,
  199.     'inputType'               => 'text',
  200.     'eval'                    => array('mandatory'=>true,'maxlength'=>35,'tl_class'=>'w50'),
  201.     'sql'                     => "varchar(255) NOT NULL default ''"
  202. );
  203. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmCost'] = array
  204. (
  205.     'inputType'               => 'text',
  206.     'eval'                    => array('mandatory'=>true,'maxlength'=>255,'tl_class'=>'w50'),
  207.     'sql'                     => "varchar(255) NOT NULL default ''"
  208. );
  209. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmClosingDate'] = array
  210. (
  211.     'filter'                  => true,
  212.     'flag'                    => 6,
  213.     'inputType'               => 'text',
  214.     'eval'                    => array('mandatory'=>false,'rgxp'=>'date','datepicker'=>true,'maxlength'=>255,'tl_class'=>'w50 wizard'),
  215.     'sql'                     => "varchar(10) NOT NULL default ''"
  216. );
  217. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmMaxTn'] = array
  218. (
  219.     'inputType'               => 'text',
  220.     'eval'                    => array('maxlength'=>255,'tl_class'=>'w50','rgxp'=>'natural'),
  221.     'sql'                     => "varchar(255) NOT NULL default ''"
  222. );
  224. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmCoursLeader'] = array
  225. (
  226.     'sorting'                  => true,
  227.     'inputType'               => 'text',
  228.     'eval'                    => array('maxlength'=>255,'tl_class'=>'clr w50'),
  229.     'sql'                     => "varchar(255) NOT NULL default ''"
  230. );
  231. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['fkUnitConfirmationMail'] = array
  232. (
  233.     'filter'                  => true,
  234.     'inputType'               => 'select',
  235.     'options_callback'          => array('tl_calendar_eventsCM', 'getUnitsMembers'),
  236.     'eval'                    => array('mandatory'=>true,'chosen'=>true,
  237.                                        'includeBlankOption'=>true,'multiple'=>false, 'tl_class'=>'w50'),
  238.     'sql'                     => "blob NULL"
  239. );
  240. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmContact'] = array
  241. (
  242.     'inputType'         => 'multiColumnWizard',
  243.     'eval'                => array
  244.     (
  245.         'buttons'           => array('up' => false, 'down' => false),
  246.         'tl_class'          => 'clr long cmWizard',
  247.         'mandatory'            => true,
  248.         'columnFields'        =>array(
  249.                                 'cmName' => array(
  250.                                     'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmName'],
  251.                                     'inputType' => 'text',
  252.                                     //'mandatory' => true,
  253.                                     'eval'      => array('doNotCopy'=>true, 'style'=>'width:130px')
  254.                                 ),
  255.                                 'cmPhone' => array
  256.                                 (
  257.                                     'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmPhone'],
  258.                                     'inputType' => 'text',
  259.                                     'eval'      => array('doNotCopy'=>true, 'style'=>'width:80px')
  260.                                 ),
  261.                                 'cmMail' => array
  262.                                 (
  263.                                     'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmMail'],
  264.                                     'inputType' => 'text',
  265.                                     'eval'      => array('doNotCopy'=>true, 'style'=>'width:200px')
  266.                                 ),
  267.                                 'cmComment' => array
  268.                                 (
  269.                                     'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmComment'],
  270.                                     'inputType' => 'text',
  271.                                     'eval'      => array('doNotCopy'=>true, 'style'=>'width:180px')
  272.                                 )
  273.                             )
  274.     ),
  275.     'save_callback'            => array(array('tl_calendar_eventsCM', 'saveCmContact')),
  276.     'sql'                   => "blob NULL"
  277. );
  278. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmRegistrationVariant'] = array
  279. (
  280.     'default'                 => 'plattform',
  281.     'filter'                  => true,
  282.     'inputType'               => 'radio',
  283.     'options'                  => array('plattform', 'url', 'noreg'),
  284.     'reference'               => &$GLOBALS['TL_LANG']['tl_calendar_events'],
  285.     'eval'                    => array('submitOnChange'=>true,'helpwizard'=>true,'tl_class'=>'clr w50'),
  286.     'sql'                     => "varchar(32) NOT NULL default ''"
  287. );
  288. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['urlExtern'] = array
  289. (
  290.     'inputType'               => 'text',
  291.     'eval'                    => array('mandatory'=>true, 'decodeEntities'=>true, 'maxlength'=>255, 'tl_class'=>'w50'),
  292.     'sql'                     => "varchar(255) NOT NULL default ''"
  293. );
  294. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['fkUnitRightEvent'] = array
  295. (
  296.     'inputType'         => 'multiColumnWizard',
  297.     'eval'                => array
  298.     (
  299.         'columnsCallback'   => array('tl_calendar_eventsCM', 'getUnitRightEvent'),
  300.         'buttons'           => array('up' => false, 'down' => false),
  301.         'tl_class'          => 'clr w50 cmWizard',
  302.     ),
  303.     'sql'               => "blob NULL"
  304. );
  305. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmMoreConfirmationMail'] = array
  306. (
  307.     'sorting'                  => true,
  308.     'inputType'               => 'text',
  309.     'eval'                    => array('tl_class'=>'clr long'),
  310.     'sql'                     => "text NULL"
  311. );
  312. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmEventRequestType'] = array
  313. (
  314.     'exclude'                 => true,
  315.     'filter'                  => true,
  316.     'inputType'               => 'select',
  317.     'options'                 => array('modul','eve-zertifikat'),
  318.     'reference'               => &$GLOBALS['TL_LANG']['cmglobal']['cmEventRequestType'],
  319.     'eval'                    => array('includeBlankOption'=>true, 'tl_class'=>'w50'),
  320.     'sql'                     => "varchar(32) NOT NULL default ''", 
  321. );
  322. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmTarget'] = array
  323. (
  324.     'inputType'         => 'multiColumnWizard',
  325.     'eval'                => array
  326.     (
  327.         'columnFields'   => array(
  328.                                       'f1' => array
  329.                                       (
  330.                                         'label'            => &$GLOBALS['TL_LANG']['tl_calendar_events']['cmTargetF1'],
  331.                                         'inputType'        => 'text',
  332.                                         'eval'            => array('style' => 'width:300px')
  333.                                         ),
  334.                                   ),
  335.         'buttons'           => array(),
  336.         'tl_class'          => 'w50 cmWizard',
  337.     ),
  338.     'sql'               => "blob NULL"
  339. );
  340. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmTeaserShort'] = array
  341. (
  342.     'inputType'               => 'text',
  343.     'eval'                    => array('mandatory'=>true,'decodeEntities'=>true, 'maxlength'=>234, 'tl_class'=>'long'),    
  344.     //'save_callback'            => array(array('tl_calendar_eventsCM', 'saveCmTeaserShort')),
  345.     'sql'                     => "varchar(234) NOT NULL default ''"
  346. );
  348. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmEventCanceled'] = array
  349. (
  350.     'inputType'               => 'checkbox',
  351.     'eval'                    => array('tl_class'=>'w50 m12','submitOnChange'=>true),
  352.     'sql'                     => "char(1) NOT NULL default ''"
  353. );
  355. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmEventHybrid'] = array
  356. (
  357.     'inputType'               => 'checkbox',
  358.     'eval'                    => array('tl_class'=>'w50 m12','submitOnChange'=>true),
  359.     'sql'                     => "char(1) NOT NULL default ''"
  360. );
  361. $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['cmEventHybridTool'] = array
  362. (
  363.     'inputType'               => 'text',
  364.     'eval'                    => array('mandatory'=>true,'decodeEntities'=>true, 'maxlength'=>255, 'tl_class'=>'w50'),
  365.     'sql'                     => "varchar(255) NOT NULL default ''"
  366. );
  371. class tl_calendar_eventsCM extends tl_calendar_events
  372. {
  373.     public function permissionEdit(DataContainer $dc = null)
  374.     {
  375.         
  376.         $arrUnits = array();
  377.         $objRights = OperationTool::getUserRights(\BackendUser::getInstance()->id,1,array("AND fkModuleAction IN ('MOD09SHOWUNIT','MOD09EDITUNIT')"));
  378.         
  379.         //Laden der Veranstaltungen, die man sehen darf
  380.         if(!$this->User->isAdmin){
  381.             
  382.             if (count($objRights['entryUnitList'])>0)
  383.             {
  384.                 $arrUnits = OperationTool::getUnitsHierarchy($objRights['entryUnitList']);
  385.             }
  386.             
  387.             $objRes = \Database::getInstance()->prepare("SELECT DISTINCT pid FROM tl_zEventIndex WHERE fkUnit IN (".implode(',',array_keys($arrUnits)).")")->execute();
  388.             
  389.             $arrUnitFilter = array();
  390.             if(!$objRes->numRows)$arrUnitFilter = array(0);
  391.             while($objRes->next())
  392.             {    
  393.                 $arrUnitFilter[] = $objRes->pid;
  394.             }            
  395.             $GLOBALS['TL_DCA']['tl_calendar_events']['list']['sorting']['filter'][] = array('id IN ('.implode(',', $arrUnitFilter).') AND pid<>?','');
  396.         }
  397.         
  398.         //direkt Zugriff auf User
  399.         if(!$this->User->isAdmin && \Input::get('act')=='edit'){
  400.             
  401.             $objEvent = $this->Database->prepare("SELECT fkUnit,tstamp FROM tl_calendar_events WHERE id = ?")->execute(\Input::get('id'));
  402.             //keinen tstamp vorhanden, dann ist er erst neu erstellt.            
  403.             if($objEvent->tstamp==0)return;
  404.             
  405.             if (count($objRights['entryUnitList'])>0)
  406.             {
  407.                 $arrUnits = OperationTool::getUnitsHierarchy($objRights['entryUnitList']);
  408.             }
  409.             
  410.             $objRes = \Database::getInstance()->prepare("SELECT DISTINCT pid FROM tl_zEventIndex 
  411.                                     WHERE pid=?
  412.                                       AND fkUnit IN (".implode(',',array_keys($arrUnits)).")")->execute(\Input::get('id'));
  413.             //unset();
  414.             if($objRes->numRows==0)
  415.             {                
  416.                 \System::log('Zugriffs Versuch von "'.$this->User->username.'" beim Event '.\Input::get('id').' verweigert.', __METHOD__, "CM_ACCESS_BACKEND"); 
  417.                 $this->redirect('contao?do=calendar&act=error');
  418.             }            
  419.         }
  420.     }
  421.         
  422.     public function generateIndex(DataContainer $dc)
  423.     {    
  424.         OperationCM::setIndexCalendar($dc->activeRecord->id,$dc->activeRecord->fkUnit,$dc->activeRecord->fkUnitRightEvent,
  425.                                      $dc->activeRecord->fkEventSector1,$dc->activeRecord->fkEventSector2);
  426.     }
  427.     
  428.     public function listEvents($arrRow)
  429.     {        
  430.         $span = Calendar::calculateSpan($arrRow['startTime'], $arrRow['endTime']);
  432.         if ($span > 0)
  433.         {
  434.             $date = Date::parse(Config::get(($arrRow['addTime'] ? 'datimFormat' : 'dateFormat')), $arrRow['startTime']) . $GLOBALS['TL_LANG']['MSC']['cal_timeSeparator'] . Date::parse(Config::get(($arrRow['addTime'] ? 'datimFormat' : 'dateFormat')), $arrRow['endTime']);
  435.         }
  436.         elseif ($arrRow['startTime'] == $arrRow['endTime'])
  437.         {
  438.             $date = Date::parse(Config::get('dateFormat'), $arrRow['startTime']) . ($arrRow['addTime'] ? ' ' . Date::parse(Config::get('timeFormat'), $arrRow['startTime']) : '');
  439.         }
  440.         else
  441.         {
  442.             $date = Date::parse(Config::get('dateFormat'), $arrRow['startTime']) . ($arrRow['addTime'] ? ' ' . Date::parse(Config::get('timeFormat'), $arrRow['startTime']) . $GLOBALS['TL_LANG']['MSC']['cal_timeSeparator'] . Date::parse(Config::get('timeFormat'), $arrRow['endTime']) : '');
  443.         }
  444.         
  446.         $pastEve = "";
  447.         if($arrRow['startDate'] < time())
  448.         {
  449.             $pastEve = 'background-color:#d7d7d7;font-style:italic;';
  450.         }
  451.         $fullyBookedStyle = "";
  452.         $fullyBookedText  = "";
  453.         $checkBookable = OperationCM::replaceInsertTags('CMEvent::bookableArray::'.$arrRow['id']);
  454.         
  455.         if($checkBookable['fullyBooked']==true)
  456.         {
  457.             $fullyBookedStyle = 'border: 1px solid red;';    
  458.             $fullyBookedText  = '<span style="color:red;padding-left:3px">ausgebucht</span>';
  459.         }
  460.         if($arrRow['cmEventCanceled']==true)
  461.         {
  462.             $fullyBookedText  .= '<span style="color:red;padding-left:3px">abgesagt</span>';
  463.         }
  465.         return '<div class="tl_content_left" style="'.$pastEve.$fullyBookedStyle.'">' 
  466.                 . $arrRow['title']
  467.                 . ' <span style="color:#b3b3b3;padding-left:3px">[' . $date . ']</span>'
  468.                 . ' <span style="color:blue;padding-left:3px">'.OperationTool::getUnit($arrRow['fkUnit'],true)->uName.'</span>'
  469.                 . $fullyBookedText
  470.                 . '</div>';
  471.     }
  472.     
  473.     public function buttonGlobal($href, $label, $title, $icon, $attributes)
  474.     {
  475.         if($this->User->isAdmin || $this->User->hasAccess('eveGlobalEdit', 'coursManagementRight'))return '<a href="'.$this->addToUrl($href).'" class="'.$icon.'" title="'.specialchars($title).'"'.$attributes.'>'.$label.'</a> ';
  476.         return '';
  477.     }
  478.     
  479.     public function buttonDelete($row, $href, $label, $title, $icon, $attributes)
  480.     {
  481.         if ( (\Controller::replaceInsertTags('{{CMEvent::countRegistration::'.$row['id'].'}}')==0 && $row['startDate'] > time()) || $this->User->isAdmin){ 
  482.             
  483.             return '<a href="' . $this->addToUrl($href . '&amp;id=' . $row['id']) . '" title="' . StringUtil::specialchars($title) . '"' . $attributes . '>' . Image::getHtml($icon, $label) . '</a> ';
  484.         } else {
  485.             return "";
  486.         }
  487.     }
  488.     
  489.     public function buttonBooking($row, $href, $label, $title, $icon, $attributes)
  490.     {        
  491.         $objEvent = $this->Database->prepare("SELECT id FROM tl_zEventBooking WHERE pid = ?")->execute($row['id']);
  492.         if ($objEvent->numRows){ 
  493.             return '<a href="' . $this->addToUrl($href . '&amp;id=' . $row['id']) . '" title="' . StringUtil::specialchars($title) . '"' . $attributes . '>' . Image::getHtml($icon, $label) . '</a> ';
  494.         } else {
  495.             return '<a href="' . $this->addToUrl($href . '&amp;id=' . $row['id']) . '" title="' . StringUtil::specialchars($title) . '"' . $attributes . '>' . Image::getHtml(preg_replace('/\.png$/i', '_.png', $icon), $label) . '</a> ';
  496.         }
  497.     }
  498.     
  499.     public function editButtonAtEdit($arrButtons)
  500.     {
  501.         //dump($arrButtons);
  502.         unset($arrButtons['saveNback']);
  504.         
  505.         if(!$this->User->isAdmin && \Input::get('act')=='edit'){
  506.             
  507.             $objEvent = OperationCM::getEvent(\Input::get('id'),true);
  508.             
  509.             //Wenn neu erstellt wird, sind die Daten noch nicht gefüllt
  510.             if($objEvent->fkEventType==0||$objEvent->startDate==0)return $arrButtons;
  511.             
  512.             $arrUnits = array();
  513.             $objRights = OperationTool::getUserRights(\BackendUser::getInstance()->id,1,array("AND fkModuleAction IN ('MOD09EDITUNIT')"));
  514.             
  515.             if (count($objRights['entryUnitList'])>0)
  516.             {
  517.                 $arrUnits = OperationTool::getUnitsHierarchy($objRights['entryUnitList']);
  518.             }
  519.             
  520.             $objRes = \Database::getInstance()->prepare("SELECT DISTINCT pid FROM tl_zEventIndex 
  521.                                     WHERE pid=?
  522.                                       AND fkUnit IN (".implode(',',array_keys($arrUnits)).")")->execute(\Input::get('id'));
  523.             if($objRes->numRows==0)
  524.             {                
  525.                 $arrButtons = array();
  526.             }    
  527.         }
  528.         
  529.         return $arrButtons;
  530.     }
  531.     
  532.     
  533.     
  534.     public function getUnits($dc)
  535.     {    
  536.         return OperationTool::getUnitsFromRights($dc->activeRecord->{$dc->field},'user',array('MOD09EDITUNIT'));
  537.     }
  538.     
  539.     public function getEventType(Contao\DataContainer $dc)
  540.     {
  541.         return OperationTool::getMasterdataValues($dc->activeRecord->{$dc->field},"eventType");
  542.     }
  543.     
  544.     public function getEventSector1(Contao\DataContainer $dc)
  545.     {
  546.         return OperationTool::getMasterdataValues(($dc->activeRecord?deserialize($dc->activeRecord->{$dc->field}):0),"eventSectorSub",0,array("AND fkEventSector=".\Config::get('eventSector1')));
  547.     }
  548.     
  549.     public function getEventSector2(Contao\DataContainer $dc)
  550.     {
  551.         return OperationTool::getMasterdataValues(($dc->activeRecord?deserialize($dc->activeRecord->{$dc->field}):0),"eventSectorSub",0,array("AND fkEventSector=".\Config::get('eventSector2')));
  552.     }
  553.     public function saveCheckEventSector($varValue, DataContainer $dc)
  554.     {
  555.         if($varValue && count(deserialize($varValue))>2)throw new Exception(sprintf($GLOBALS['TL_LANG']['ERR']['addtoomuch'], 2));
  556.         return $varValue;
  557.     }
  558.     
  559.     public function getUnitsMembers($dc)
  560.     {
  561.         $res = array();
  562.         
  563.         $arrUnits = array();
  564.         $objRights = OperationTool::getUserRights(\BackendUser::getInstance()->id,1,array("AND fkModule = 'mod09'"));
  565.         if (count($objRights['entry'])>0)
  566.         {
  567.             $arrIDs = array();
  568.             foreach($objRights['entry'] as $arrRight){
  569.                 $arrIDs[$arrRight['fkUnit']] = '';
  570.             }
  571.             $arrUnits = OperationTool::getUnitsHierarchy($arrIDs);
  572.         }
  573.         
  574.         $idUser=0;
  575.         if($dc->activeRecord)$idUser = $dc->activeRecord->{$dc->field};
  576.         $objUsers = \Database::getInstance()->prepare("
  577.                                 SELECT DISTINCT tl_user.id, tl_user.name
  578.                                   FROM tl_zLinkUserRight,tl_user 
  579.                                  WHERE tl_user.id = tl_zLinkUserRight.pid
  580.                                    AND fkUnit IN (".implode(',',array_keys($arrUnits)).") 
  581.                                    OR tl_user.id IN (".($idUser?$idUser:0).")
  582.                               ORDER BY name")->execute();
  583.         
  584.         while($objUsers->next())
  585.         {
  586.             $res[$objUsers->id] = $objUsers->name;
  587.         }
  588.         
  589.         //Prüfen ob User exisitert
  590.         if($idUser<>0 && !array_key_exists($idUser,$res)){//
  591.             \Message::addError('Empfänger vom Bestätitungsmail muss korrigiert werden');
  592.         }
  593.         
  594.         return $res;
  595.     }
  597.     public function saveCmContact($varValue, DataContainer $dc)
  598.     {
  599.         $arrVarValue = deserialize($varValue);
  600.         //$arrVarValue = var_dump($arrVarValue[0]['cmName']);
  601.         $varExcept = array();
  602.         
  603.         foreach($arrVarValue as $arrValue){
  604.             if($arrValue['cmName']=='')$varExcept[] = sprintf($GLOBALS['TL_LANG']['ERR']['valueMissingCmName'], '');
  605.             if($arrValue['cmMail']=='')$varExcept[] = sprintf($GLOBALS['TL_LANG']['ERR']['valueMissingCmMail'], '');    
  606.         }
  607.         
  608.         if($varExcept)throw new Exception(implode('; ',$varExcept));
  609.         
  610.         return $varValue;
  611.     }
  613.     /*public function saveCmTeaserShort($varValue, DataContainer $dc)
  614.     {dump($varValue);
  615.         if ($varValue && mb_strlen($varValue) > 234)
  616.         {
  617.             throw new Exception(sprintf($GLOBALS['TL_LANG']['ERR']['maxlength'], $GLOBALS['TL_LANG']['tl_calendar_events']['cmTeaserShort'][0], 234));
  618.         }
  619.         
  620.         return $varValue;
  621.     }*/
  622.     
  623.     public function getUnitRightEvent($var1)
  624.     {
  625.         $columnFields = null;
  626.         
  627.         $arrAnbieter = OperationTool::getUnitsHierarchy(OperationTool::getUnitsTop());
  629.         $columnFields = array
  630.         (
  631.             'f1' => array
  632.             (
  633.                 'label'     => &$GLOBALS['TL_LANG']['tl_calendar_events']['fkUnitRightEventF1'],
  634.                 'inputType' => 'select',
  635.                 'options'    => $arrAnbieter,
  636.                 'eval'      => array('doNotCopy'=>true,'chosen'=>true, 'includeBlankOption'=>true, 'style'=>'width:350px')
  637.             )
  638.         );
  640.         return $columnFields;
  641.     }
  642.     
  643. }
  645. ?>