development/coursemanagement-bundle/src/Module/Frontend/InterfaceModule.php line 107

Open in your IDE?
  1. <?php
  3. namespace CityMountain\CourseManagementBundle\Module\Frontend;
  5. use CityMountain\CourseManagementBundle\Utils\OperationCM;
  6. use CityMountain\ToolBundle\Utils\OperationTool;
  7. use Contao\Input;
  9. class InterfaceModule extends \Module
  10. {
  11.     protected $strTemplate = 'fe_modInterface';
  12.     
  13.     protected $parmTest        = false;
  14.     
  15.     protected $paramUnitId;
  16.     
  17.     protected $parmId;
  18.     
  19.     protected $parmAct;
  20.     
  21.     protected $paramDayNow;
  22.     
  23.     protected $ActMod;
  24.     protected $ActAct;
  25.     
  26.     protected $paramNoPrinterIcon         = false;
  27.     protected $paramNoHorizontaleLine     = false;
  28.     protected $paramSortOut                = array();
  29.     protected $paramInterfaceConfig        = array();
  30.     protected $paramVLSGroup            = false;
  31.     
  32.     protected $ResMember = array();
  33.     
  34.     protected $tempSaveVLSKursarten = array();
  35.     protected $tempSaveMemPos        = array();
  36.     
  37.     //Datum, Zeit, Thema, Ort, Info, Veranstalter -> Sicht für Verbände
  38.     protected $field_1_1 = Array ( 'eveId'                    =>array('sql'=>1,'noout'=>1,'lang'=>'','sql_spz'=>'tl_calendar_events.id AS eveId')
  39.                                   ,'fkEventType'            =>array('sql'=>1,'noout'=>0,'lang'=>'')
  40.                                   ,'fkUnit'                    =>array('sql'=>1,'noout'=>0,'lang'=>'')
  41.                                   ,'title'                    =>array('sql'=>1,'noout'=>0,'lang'=>'','link'=>1)
  42.                                   ,'cmEventCanceled'        =>array('sql'=>1,'noout'=>1,'lang'=>'')
  43.                                   ,'fkEventSector1'            =>array('sql'=>1,'noout'=>1,'lang'=>'')
  44.                                   ,'fkEventSector2'            =>array('sql'=>1,'noout'=>1,'lang'=>'')
  45.                                   ,'startDate'                =>array('sql'=>1,'noout'=>0,'lang'=>'','css'=>'style="width:55px"')
  46.                                   ,'addTime'                =>array('sql'=>1,'noout'=>1,'lang'=>'')
  47.                                   ,'startTime'                =>array('sql'=>1,'noout'=>0,'lang'=>'')
  48.                                   ,'cmLocation'                =>array('sql'=>1,'noout'=>0,'lang'=>'')
  49.                                   ,'iconInfoBlock'            =>array('sql'=>0,'noout'=>0,'lang'=>'&nbsp;')
  50.                                   ,'cmEventHybrid'            =>array('sql'=>1,'noout'=>1,'lang'=>'')
  51.                                   ,'eveType'                =>array('sql'=>1,'noout'=>1,'lang'=>'','sql_spz'=>'fkEventType AS eveType')
  52.                                  );    
  53.     //Datum, Zeit, Thema, Ort, Info -> Sicht für einzelen Veranstalter
  54.     protected $field_1_2 = Array ( 'eveId'                    =>array('sql'=>1,'noout'=>1,'lang'=>'','sql_spz'=>'tl_calendar_events.id AS eveId')
  55.                                   ,'fkEventType'            =>array('sql'=>1,'noout'=>0,'lang'=>'')
  56.                                   ,'title'                    =>array('sql'=>1,'noout'=>0,'lang'=>'','link'=>1)
  57.                                   ,'cmEventCanceled'        =>array('sql'=>1,'noout'=>1,'lang'=>'')
  58.                                   ,'fkEventSector1'            =>array('sql'=>1,'noout'=>1,'lang'=>'')
  59.                                   ,'fkEventSector2'            =>array('sql'=>1,'noout'=>1,'lang'=>'')
  60.                                   ,'startDate'                =>array('sql'=>1,'noout'=>0,'lang'=>'','css'=>'style="width:55px"')
  61.                                   ,'addTime'                =>array('sql'=>1,'noout'=>1,'lang'=>'')
  62.                                   ,'startTime'                =>array('sql'=>1,'noout'=>0,'lang'=>'')
  63.                                   ,'cmLocation'                =>array('sql'=>1,'noout'=>0,'lang'=>'')
  64.                                   ,'eveType'                =>array('sql'=>1,'noout'=>1,'lang'=>'','sql_spz'=>'fkEventType AS eveType')
  65.                                  );    
  66.     
  67.     
  68.     //Standardfelder für die Selektion des Interface
  69.     protected $fieldK_1 = Array  ( 'eveId'                    =>array('sql'=>1,'noout'=>1,'lang'=>'','sql_spz'=>'tl_calendar_events.id AS eveId')
  70.                                  
  71.                                  );
  73.     
  74.     protected $tab_header = array();
  76.     
  77.     public function generate()
  78.     {
  79.         $request = \System::getContainer()->get('request_stack')->getCurrentRequest();
  81.         if ($request && \System::getContainer()->get('contao.routing.scope_matcher')->isBackendRequest($request))
  82.         {
  83.             $objTemplate = new \BackendTemplate('be_wildcard');
  84.             $objTemplate->wildcard = '### ' . $GLOBALS['TL_LANG']['FMD']['zCMInterface'][0] . ' ###';
  85.             $objTemplate->title = $this->headline;
  86.             $objTemplate->id = $this->id;
  87.             $objTemplate->link = $this->name;
  88.             $objTemplate->href = \StringUtil::specialcharsUrl(\System::getContainer()->get('router')->generate('contao_backend', array('do'=>'themes', 'table'=>'tl_module', 'act'=>'edit', 'id'=>$this->id)));
  90.             return $objTemplate->parse();
  91.         }
  92.         
  93.         return parent::generate();
  94.     }
  95.     
  96.     protected function compile()
  97.     {
  98.         //Parameter setzen
  99.         unset($paramUnitId,$parmId,$parmAct);
  100.         $this->parmTest        = \Input::get('test');
  101.         $this->paramUnitId = \Input::get('organizerId');    
  102.         if($this->paramUnitId==''&&\Input::get('anbieter_id')<>'')$this->paramUnitId = \Input::get('anbieter_id');        
  103.         $this->parmId        = \Input::get('id');
  104.         $this->parmAct          = \Input::get('act');
  105.         $this->paramDayNow  = mktime(0, 0, 0, date("n"), date("j"), date("Y"));
  106.         
  107.         list($this->ActMod, $this->ActAct) = explode('_', $this->parmAct);            
  108.         
  109.         //Daten auslesen
  110.         if($this->paramUnitId) //Standardausgabe für einen Anbieter
  111.         {
  112.             if($this->ActMod==1) //Eventverarbeitung
  113.             {                
  114.                 $eventType = array();
  115.                 $eventSector = array(); //Sparte
  116.                 $eventSectorSub = array(); //Rubrik
  117.                 $isHierarchy = 0;
  118.                 $units = array();
  119.                 
  120.                 switch($this->ActAct)
  121.                 {
  122.                     case 1:
  123.                     case 2:
  124.                         //Kurse alle
  125.                         
  126.                         //Veranstaltungs Art
  127.                         $tmpEventType = \Input::get('eventType');    
  128.                         if($tmpEventType==''&&\Input::get('kurs_art')<>''){
  129.                             $tmpEventType = array_key_first(OperationTool::getMasterdataValues(0,"eventType",0,array("AND mvValueMapping=".\Input::get('kurs_art'))));
  130.                         }
  131.                         if($tmpEventType)
  132.                         {
  133.                             $eventType = explode(',',$tmpEventType);
  134.                         }else
  135.                         {                            
  136.                             $eventType = array_keys(OperationTool::getMasterdataValues(0,"eventType"));
  137.                         }
  138.                         
  139.                         //Spart bzw. Sector
  140.                         $tmpEventSector = \Input::get('eventSector');    
  141.                         if($tmpEventSector==''&&\Input::get('kurs_sparte')<>''){
  142.                             $tmpEventSector = array_key_first(OperationTool::getMasterdataValues(0,"eventSector",0,array("AND mvValueMapping=".\Input::get('kurs_sparte'))));
  143.                         }
  144.                         if($tmpEventSector)
  145.                         {
  146.                             $eventSector = explode(',',$tmpEventSector);
  147.                         }
  148.                         //laden der Rubrik aus dem Sektor, wenn dieser gefüllt wird
  149.                         if(count($eventSector)>0)
  150.                         {    
  151.                             foreach($eventSector as $idSector)
  152.                               {
  153.                                 $tmpEventSectorSub = array_keys(OperationTool::getMasterdataValues(0,"eventSectorSub",0,array("AND fkEventSector=".$idSector)));
  154.                                 $eventSectorSub = array_merge($eventSectorSub,$tmpEventSectorSub);
  155.                             }
  156.                         }
  157.                                                 
  158.                         //Rubrik bzw. SectorSub
  159.                         $tmpEventSectorSub = \Input::get('eventSectorSub');    
  160.                         if($tmpEventSectorSub==''&&\Input::get('kurs_rubrik')<>''){
  161.                             $tmpEventSectorSub = array_key_first(OperationTool::getMasterdataValues(0,"eventSectorSub",0,array("AND mvValueMapping=".\Input::get('kurs_rubrik'))));
  162.                         }
  163.                         if($tmpEventSectorSub)
  164.                         {
  165.                             $eventSectorSub = array_merge($eventSectorSub,explode(',', $tmpEventSectorSub));
  166.                         }else
  167.                         {
  168.                             //Wenn Rubrik leer und keine Sparte, werden alle Rubriken geladen
  169.                             if(count($eventSectorSub)==0)
  170.                             {
  171.                                 $eventSectorSub = array_key_first(OperationTool::getMasterdataValues(0,"eventSectorSub",0));
  172.                             }
  173.                         }                        
  174.                         
  175.                         //Hierarchie prüfen                    
  176.                         $isHierarchy = \Input::get('organizerH');    
  177.                         if(\Input::get('anbieter_h')<>''){
  178.                             $isHierarchy = \Input::get('anbieter_h');
  179.                         }
  180.                         
  181.                         //Units Laden
  182.                         if(strpos($this->paramUnitId,',')){//Mehrere Vereine
  183.                             $units = array($this->paramUnitId);
  184.                             if($isHierarchy)$units = array_keys(OperationTool::getUnitsHierarchy(array_flip(explode(',',$this->paramUnitId))));
  185.                         }else{//ein Verein, nur noch Prüfung
  186.                             $units = array($this->paramUnitId);
  187.                             if($isHierarchy)$units = array_keys(OperationTool::getUnitsHierarchy(array($this->paramUnitId=>$this->paramUnitId)));
  188.                         }
  189.                         
  190.                         
  191.                         if($this->ActAct==1) $locl_field = $this->field_1_1;
  192.                         if($this->ActAct==2) $locl_field = $this->field_1_2;
  193.                         
  194.                         //Selektieren der Veranstaltungen nur wenn es einen Verein hat
  195.                         if(count($units)>0){
  196.                         $objRes = $this->Database->prepare("
  197.                                 SELECT ".$this->gen_select($locl_field)." 
  198.                                  FROM tl_calendar_events
  199.                                 WHERE pid = 2
  200.                                   AND published = 1
  201.                                   AND fkEventType IN (".implode(',',$eventType).")
  202.                                   AND id IN (SELECT pid FROM tl_zEventIndex WHERE fkEventSector1 IN (".implode(',',$eventSectorSub).")
  203.                                                                                OR fkEventSector2 IN (".implode(',',$eventSectorSub).") )
  204.                                   AND fkUnit IN (".implode(',',$units).")
  205.                                   AND startDate >= ?
  206.                                 ORDER BY startDate
  207.                                             ")->execute($this->paramDayNow); 
  208.                             
  209.                         }
  210.                         $this->tab_header = $locl_field;
  211.                         break;
  212.                 }
  213.                 
  214.             
  215.             }elseif($this->ActMod==2) //Nicht ausprogrammiert
  216.             {
  217.                 //nichts
  218.             }
  219.             
  220.         }
  221. //////            
  222.         elseif($this->parmId)  //Konfigurierteausgabe
  223.         {
  224.             //nichts
  225.         }        
  226.         
  227.         
  228.         
  229.         // Prepare table
  230.         $arrTd = array();        
  231.         $start = -1;
  232.         $limit = $objRes->numRows;
  233.         
  234.         // TBODY
  235.         if($limit<>0){
  236.         while ($objRes->next())
  237.         {            
  238.             $class = 'row_' . ++$start . (($start == 0) ? ' row_first' : '') . ((($start + 1) == $limit) ? ' row_last' : '') . ((($start % 2) == 0) ? ' even' : ' odd');
  239.             if($objRes->cmEventCanceled)$class .= ' eventCanceled';
  241.             //Daten automatisch hinzufügen
  242.             foreach ($this->tab_header as $key=>$wert)
  243.             {
  244.                 if(!$wert['noout'])$arrTd[$class][$key] = $objRes->$key;
  245.                 if(!$wert['noout']&&array_key_exists('css',$wert))$arrTd[$class][$key.'_css'] = $wert['css'];
  246.                 //$arrTd[$class][$key] = $objRes->$key;
  247.             }
  248.             
  249.             //Manuelle daten hinzufügen
  250.             if(array_key_exists('startDate',$this->tab_header))$arrTd[$class]['startDate'] = date($GLOBALS['TL_CONFIG']['dateFormat'],$objRes->startDate);
  251.             if(array_key_exists('startTime',$this->tab_header))$arrTd[$class]['startTime'] = date($GLOBALS['TL_CONFIG']['timeFormat'],$objRes->startTime);
  252.             if(array_key_exists('startTime',$this->tab_header))$arrTd[$class]['startTimeStamp'] = $objRes->startTime;
  253.             if(array_key_exists('endTime',$this->tab_header))$arrTd[$class]['endTime'] = date($GLOBALS['TL_CONFIG']['timeFormat'],$objRes->endTime);            
  254.             if(array_key_exists('fkEventType',$this->tab_header)) $arrTd[$class]['fkEventType'] = \Controller::replaceInsertTags('{{CMEvent::eventType::'.$objRes->eveId.'}}');
  255.             if(array_key_exists('fkUnit',$this->tab_header))$arrTd[$class]['fkUnit'] = OperationCM::getUnitName($objRes->fkUnit);
  256.             
  257.             //Bedinungen
  258.             //Keine Zeit, wenn diese nicht ausgewählt ist
  259.             if(array_key_exists('addTime',$this->tab_header)&&!$objRes->addTime)unset($arrTd[$class]['startTime']);
  260.             //Keine Endtzeit, wenn diese gleich Startzeit ist
  261.             if(array_key_exists('endTime',$this->tab_header)&&$objRes->endTime==$objRes->startTime)unset($arrTd[$class]['endTime']);
  262.             
  263.             //storniert einfügen bei Thema
  264.             if($objRes->cmEventCanceled && array_key_exists('title',$this->tab_header))$arrTd[$class]['title'].= ' <font color="red">abgesagt</font>';
  265.             
  266.             //iconInfoBlock
  267.             if(array_key_exists('iconInfoBlock',$this->tab_header)){
  268.                 if($objRes->cmEventHybrid==1)$arrTd[$class]['iconInfoBlock'] = '<img src="bundles/citymountaincoursemanagement/icons/iconHybrid.png" title="Hybrid-Veranstaltung">';
  269.             }
  270.             
  271.             
  272.             //Zentralle verarbeitung am Schluss
  273.             foreach ($this->tab_header as $key=>$wert) // Betrifft ganze Linie
  274.             {
  275.                 $id_iframe = '';
  276.                 //Link setzen für Detailsicht
  277.                 switch ($this->ActMod){
  278.                     case 1:
  279.                         if($this->parmId)$id_iframe= '?id_iframe='.$this->parmId;
  280.                         $linkurl = \Environment::get('url').'/veranstaltungsuebersicht/'.$objRes->eveId.'.html'.$id_iframe;
  281.                         if(!$wert['noout']&&array_key_exists('link',$wert)&&$wert['link']&&$objRes->startDate>=$this->paramDayNow)$arrTd[$class][$key] = '<a href="'.$linkurl.'">'.$arrTd[$class][$key].'</a>';
  282.                         break;
  283.                 }
  284.                 
  285.                 //Sprache laden
  286.                 switch ($this->ActMod){
  287.                     case 1:
  288.                         $this->loadLanguageFile('tl_calendar_events');
  289.                         if(!$this->tab_header[$key]['lang']&& array_key_exists($key,$GLOBALS['TL_LANG']['tl_calendar_events']))$this->tab_header[$key]['lang'] = $GLOBALS['TL_LANG']['tl_calendar_events'][$key][0];                        
  290.                         if(!array_key_exists($key,$GLOBALS['TL_LANG']['tl_calendar_events']) && $this->tab_header[$key]['lang']=="" )$this->tab_header[$key]['lang'] = $key;
  291.                         if($key=='startDate')$this->tab_header[$key]['lang'] = $GLOBALS['TL_LANG']['tl_calendar_events']['zstartDate'][0];
  292.                         if($key=='startTime')$this->tab_header[$key]['lang'] = $GLOBALS['TL_LANG']['tl_calendar_events']['zstartTime'][0];
  293.                         if($key=='endTime')$this->tab_header[$key]['lang'] = $GLOBALS['TL_LANG']['tl_calendar_events']['zendTime'][0];
  294.                         if($key=='title')$this->tab_header[$key]['lang'] = $GLOBALS['TL_LANG']['tl_calendar_events']['ztitle'][0];
  295.                         if($key=='cmLocation')$this->tab_header[$key]['lang'] = $GLOBALS['TL_LANG']['tl_calendar_events']['cmLocationShort'][0];
  297.                         break;
  298.                 }
  299.                 
  300.             }
  302.                 
  303.         }
  304.         }else{//keine Einträge
  305.             $this->Template->no_entry = 1;
  306.             $this->paramNoPrinterIcon = true;
  307.         }
  308.         
  309.         //Sortierung der Ausgabe >> wird nicht genutzt
  310.         /*if(!$this->Template->no_entry)
  311.         {
  312.             unset($arrTd2);
  313.             
  314.             $start = -1;
  315.             foreach ($arrTd as $key => $row) {
  316.                 $class = 'row_' . ++$start . (($start == 0) ? ' row_first' : '') . ((($start + 1) == $limit) ? ' row_last' : '') . ((($start % 2) == 0) ? ' even' : ' odd');
  317.                 $arrTd2[$class] = $arrTd[$key];
  318.             }
  319.             $arrTd = $arrTd2;
  320.         }*/
  321.         
  322.         $url = $this->generate_standard_link();
  323.         
  324.         //Headerverarbeiten
  325.         foreach ($this->tab_header as $key=>$wert)
  326.         {
  327.             if(!$wert['noout'])$tab_header_out[$key] = $wert;
  328.         }
  330.         $this->Template->link_popup = $url.'&pop=1';
  331.         $this->Template->tbody = $arrTd;
  332.         $this->Template->tab_header = $tab_header_out;
  334.         $this->Template->NoPrinterIcon      = $this->paramNoPrinterIcon;
  335.         
  336.         //$this->Template->calendar = $objTemplate->parse();
  337.     }
  339.     
  340.     protected function generate_standard_link()
  341.     {
  342.         //$url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']; $_SERVER['QUERY_STRING']        
  343.         $url = "http://".$_SERVER['HTTP_HOST']."/interface.html?";
  344.         if($this->paramUnitId) $url .= 'organizerId='.$this->paramUnitId;
  345.         if(\Input::get('organizerH')) $url .= '&organizerH='.\Input::get('organizerH');
  346.         if(\Input::get('eventType')) $url .= '&eventType='.\Input::get('eventType');
  347.         if(\Input::get('eventSector')) $url .= '&eventSector='.\Input::get('eventSector');
  348.         if(\Input::get('eventSectorSub')) $url .= '&eventSectorSub='.\Input::get('eventSectorSub');
  349.         if($this->parmId)       $url .= '&id='.$this->parmId;
  350.         $url .= '&act='.$this->parmAct;
  351.         return $url;        
  352.     }
  353.     
  354.     protected function gen_select($in)
  355.     {
  356.         unset($out);
  357.         foreach($in as $key=>$wert){
  358.             if($wert['sql']) //SQL relevant
  359.             {
  360.                 if(array_key_exists('sql_spz',$wert)&&$wert['sql_spz']) //Wenn es zusatz für die SQL abfrage hat
  361.                 {
  362.                     $out[] = $wert['sql_spz'];
  363.                 }else
  364.                 {
  365.                     $out[] = $key;
  366.                 }
  367.             }
  368.         }
  369.         return implode(',', $out);
  370.     }
  371. }
  373. ?>