development/coursemanagement-bundle/src/Utils/OperationCM.php line 59

Open in your IDE?
  1. <?php
  3. namespace CityMountain\CourseManagementBundle\Utils;
  5. use CityMountain\ToolBundle\Utils\OperationTool;
  6. use Contao\Versions;
  7. use Contao\Email;
  8. use Contao\BackendUser;
  9. use CityMountain\CourseManagementBundle\Utils\hookReplaceInsertTags;
  11. class OperationCM
  12. {    
  13.     public static function getDefaultUnitFromUserToEdit()
  14.     {
  15.         $objRights = OperationTool::getUserRights(BackendUser::getInstance()->id,1,array("AND fkModuleAction='MOD09EDITUNIT'"));
  16.         //dump($objRights);
  17.         //if (array_key_exists('mod09',$objRights['module']) && array_key_exists('MOD09EDITUNIT',$objRights['module']['mod09']) && count($objRights['module']['mod09']['MOD09EDITUNIT'])>0)
  18.         if (count($objRights['entry'])>0)
  19.         {
  20.             return current($objRights['entry'])['fkUnit'];
  21.         }else{
  22.             return 0;
  23.         }
  24.     }    
  25.     
  26.     public static function setIndexCalendar($idEve,
  27.                                      $fkUnit,$fkUnitRightEvent,
  28.                                      $fkEventSector1,$fkEventSector2)
  29.     {
  30.         \Database::getInstance()->prepare("DELETE FROM tl_zEventIndex WHERE pid=?")->execute($idEve);
  31.         if($fkUnit)
  32.         {
  33.             \Database::getInstance()->prepare("INSERT INTO tl_zEventIndex SET pid=?,fkUnit=?,tstamp=?")
  34.                                ->execute($idEve,$fkUnit,time());
  35.         }
  36.         
  37.         foreach(deserialize($fkUnitRightEvent) as $arrRight){
  38.             if($arrRight['f1'])\Database::getInstance()->prepare("INSERT INTO tl_zEventIndex SET pid=?,fkUnit=?,tstamp=?")->execute($idEve,$arrRight['f1'],time());
  39.         }
  40.         
  41.         if($fkEventSector1){
  42.             foreach(deserialize($fkEventSector1) as $sector){
  43.                 if($sector<>'')\Database::getInstance()->prepare("INSERT INTO tl_zEventIndex SET pid=?,fkEventSector1=?,tstamp=?")
  44.                     ->execute($idEve,$sector,time());
  45.             }
  46.         }
  47.         
  48.         if($fkEventSector2){
  49.             foreach(deserialize($fkEventSector2) as $sector){
  50.                 if($sector<>'')\Database::getInstance()->prepare("INSERT INTO tl_zEventIndex SET pid=?,fkEventSector2=?,tstamp=?")
  51.                     ->execute($idEve,$sector,time());
  52.             }
  53.         }
  54.     }
  55.     
  56.     public static function replaceInsertTags($insertTag,$useCache=true)
  57.     {            
  58.         $objInsertTags = new ReplaceInsertTagsListener();
  59.         return $objInsertTags->hookReplaceInsertTags($insertTag,$useCache,'',array(),array(),array(),0,0);
  60.         //$insertTag,$useCache=true,$cachedValue = '',$flags=array(),$tags=array(),$cache=array(),$_rit=0,$_cnt=0
  61.     }
  62.     
  63.     public static function getEvent($idSelect,$getObject=false)
  64.     {
  65.         return OperationTool::getGenericEntry($idSelect,'tl_calendar_events',$getObject);
  66.     }
  67.     
  68.     public static function getUnitName($idUnit,$getWithLink=false)
  69.     {
  70.         $objUnit = \Database::getInstance()->prepare("SELECT uName,uUrl FROM tl_zUnit WHERE id = ?")->limit(1)->execute($idUnit);
  71.         if($getWithLink)return '<a href="'.$objUnit->uUrl.'" target="_NEW">'.$objUnit->uName.'</a>';
  72.         return $objUnit->uName;
  73.     }
  74.     
  75.     public static function getBookings($idEvent=0,$getData=true)
  76.     {
  77.         $arrRes = array();
  78.         
  79.         if($idEvent=='')$idEvent=0;
  80.         
  81.         $objBooking = \Database::getInstance()->prepare("SELECT * 
  82.                                                            FROM tl_zEventBooking 
  83.                                                           WHERE pid=?
  84.                                                        ORDER BY insertTstamp")->execute($idEvent);
  85.         while($objBooking->next())
  86.         {
  87.             if($getData){
  88.                 $arrRes[] = $objBooking->row();
  89.             }else{
  90.                 $arrRes[$objBooking->id] = $objBooking->lastname.' '.$objBooking->firstname;
  91.             }
  92.             
  93.         }
  94.         return $arrRes;
  95.     }
  96.     
  97.     public static function getBookingAccessTime()
  98.     {
  99.         if(BackendUser::getInstance()->isAdmin){
  100.             return \Config::get('eventBookingAccessTimeAdmin');
  101.         }else{
  102.             return \Config::get('eventBookingAccessTime');
  103.         }
  104.     }
  105.     
  106.     public static function checkEventContact($idEvent)
  107.     {
  108.         $objResult = \Database::getInstance()->prepare("SELECT cmContact FROM tl_calendar_events WHERE id=? ")->limit(1)->execute($idEvent);
  109.         $contact = deserialize($objResult->cmContact);
  110.         if($contact[0]['cmName'])return true;
  111.         return false;
  112.     }
  113.     
  114.     public static function importBookingViaDC($dc)
  115.     {
  116.         return static::importBooking($dc->id);
  117.     }
  118.     
  119.     public static function importBooking($idBooking)
  120.     {    
  121.         \System::loadLanguageFile('tl_zEventBooking');
  122.         
  123.         if (\Input::post('FORM_SUBMIT') == 'importBooking')
  124.         {
  125.             if($_FILES['source']['tmp_name']<>'' 
  126.                     && ($_FILES['source']['type']=='application/vnd.ms-excel' || $_FILES['source']['type']=='text/csv')
  127.                        ){
  128.                 // Create temporary file
  129.                 $tmpName = 'system/tmp/importBooking_' . date('Y-m-d_Hi') . '.csv';
  130.                 $objFiles = \Files::getInstance();
  131.                 $objFiles->move_uploaded_file($_FILES['source']['tmp_name'],$tmpName);
  132.                 //$this->objFile = new \File($tmpName);
  133.                 
  134.                 static::doImportBooking($idBooking,$tmpName);
  135.                 
  136.             }else{
  137.                 \Contao\Message::addError('Fehler - keine Datei oder kein CSV Format');
  138.             }            
  139.         }    
  140.         
  141.         
  142.         //Formular
  143.         $objTemplate = new \BackendTemplate('be_modOperationtImportBooking');        
  144.         $objTemplate->buttonBack = \Contao\Environment::get('base').'contao?do=calendar&table=tl_calendar_events&id=2';
  145.         $objTemplate->title = $GLOBALS['TL_LANG']['tl_zEventBooking']['importBookingValue'][0];
  146.         $objTemplate->action = \Environment::get('request');
  147.         
  148.         return $objTemplate->parse();
  149.     }
  150.     
  151.     public static function doImportBooking($idBooking,$fileName)
  152.     {
  153.         $objFile = new \File($fileName);
  154.         if($objFile->path=='')return;
  155.         
  156.         
  157.         $neededFields = array('gender','lastname','firstname','street','postal','city','reachedBy','mobile','email','comment','dateOfBirth','homeTown','ahvNr');
  158.         
  159.         $fieldDispatch = array();
  160.         $row = 1;
  161.         if(($handle = $objFile->handle) !== FALSE) {
  162.             
  163.             $dataFault = false;
  164.             $importArray = array();
  165.             while(($data = fgetcsv($handle, 10000, ";")) !== FALSE) {
  166.                 //dump($data);
  167.                 if($row == 1){
  168.                     for($i=0;$i<count($data);$i++) 
  169.                     {
  170.                         $data[$i] = $data[$i];
  171.                     }
  172.                     $missingField = false;
  173.                     for($i=0;$i<count($neededFields);$i++) {
  174.                         if(!in_array($neededFields[$i], $data)){
  175.                             $missingField = true;
  176.                             $missingFieldArr[]=    $neededFields[$i];
  177.                         }
  178.                         for($p=0;$p<count($data);$p++) {
  179.                             if($neededFields[$i] == $data[$p]) $fieldDispatch[$neededFields[$i]] = $p;
  180.                         }
  181.                     }
  182.                     
  183.                     if($missingField == true)
  184.                     {
  185.                         \Contao\Message::addError("Es sind nicht alle Felder vorhanden. ".implode(",",$missingFieldArr));
  186.                         return;
  187.                     }
  188.                 }
  189.                 else{
  190.                     $executionsAry = array();
  191.                     for($i=0;$i<count($neededFields);$i++) {
  192.                         
  193.                         if($neededFields[$i] == "gender"){
  194.                             $executionsAry["gender"] = utf8_encode($data[$fieldDispatch[$neededFields[$i]]]);
  195.                             if($executionsAry["gender"]=='male'||$executionsAry["gender"]=='female'||$executionsAry["gender"]=='other'){
  196.                                 
  197.                             }else{
  198.                                 \Contao\Message::addError('Geschlecht in Zeile '.$row.' ist falsch');
  199.                                 $dataFault = true;
  200.                                 break;
  201.                             }
  202.                         }elseif($neededFields[$i] == "reachedBy"){
  203.                             $executionsAry["reachedBy"] = utf8_encode($data[$fieldDispatch[$neededFields[$i]]]);
  204.                             if($executionsAry["reachedBy"]=='email'||$executionsAry["reachedBy"]=='mobile'){
  205.                                 
  206.                             }else{
  207.                                 \Contao\Message::addError('Erreichbar per in Zeile '.$row.' ist falsch');
  208.                                 $dataFault = true;
  209.                                 break;
  210.                             }
  211.                         }/*elseif($neededFields[$i] == "persnr"){
  212.                             $executionsAry["zPersonalNummer"] = utf8_encode($data[$fieldDispatch[$neededFields[$i]]]);
  213.                             $executionsAry["username"] = utf8_encode($data[$fieldDispatch[$neededFields[$i]]]);
  214.                             $executionsAry["password"] = 'K;Wgk2FArCp!';
  215.                         }*/elseif($neededFields[$i] == "dateOfBirth" && $data[$fieldDispatch[$neededFields[$i]]]<>''){
  216.                             $arrTmp = explode('.',$data[$fieldDispatch[$neededFields[$i]]]);                            
  217.                             $executionsAry["dateOfBirth"] = mktime(0,0,0,$arrTmp[1],$arrTmp[0],$arrTmp[2]);
  218.                         }else
  219.                         {
  220.                             $executionsAry[$neededFields[$i]] = utf8_encode($data[$fieldDispatch[$neededFields[$i]]]);
  221.                         }
  222.                     }
  223.                     
  224.                     
  225.                     $executionsAry["pid"] = $idBooking;
  226.                     $executionsAry["insertTstamp"] = time();
  227.                     $executionsAry["tstamp"] = time();
  228.                     
  229.                     $importArray[] = $executionsAry;
  230.                 }
  231.                 $row++;
  232.             }
  233.             fclose($handle);
  234.             
  235.             //Wenn Fehler kein Import
  236.             if($dataFault){
  237.                 \Contao\Message::addError('Daten Fehler - kein Import');
  238.             }else{
  239.                 
  240.                 $insertCount = 0;
  241.                 foreach($importArray as $arrImport){
  242.                     $executionsAryKeys     = array_keys($arrImport);
  243.                     $sets = implode(" = ?, ", $executionsAryKeys)." = ?";
  244.                     //dump($sets);
  245.                     //dump($arrImport);
  246.                     //Import
  247.                     \Database::getInstance()->prepare("INSERT INTO tl_zEventBooking SET ".$sets)->execute($arrImport);                    
  248.                     $insertCount++;
  249.                 }
  250.                 
  251.                 \Contao\Message::addInfo($insertCount . " Einträge importiert");    
  252.             } 
  253.             
  254.                     
  255.         }
  256.         
  257.     }
  258.     
  259. }