FOR calendar - Individuelle Konfiguration

// nur im Backend ausführen, nur bei eingeloggtem User und nur wenn der Get Parameter forcal_cat_id übergeben wurde
if (rex::isBackend() && rex_get('forcal_cat_id') && rex::getUser()) {
    if (rex_request::isXmlHttpRequest()) {
        $forcal_cat_id = rex_get('forcal_cat_id','int');
        $res = rex_sql::factory()->getArray('SELECT * FROM rex_forcal_categories WHERE id = :id',['id'=>$forcal_cat_id]);
        echo json_encode($res);
        exit;
    }
}

rex_yform_manager_dataset::setModelClass('rex_forcal_categories', rex_forcal_categories::class);
rex_yform_manager_dataset::setModelClass('rex_forcal_entries', rex_forcal_entries::class);

<?php

// Die Klasse für die Veranstaltungskategorie 

class rex_forcal_categories extends \rex_yform_manager_dataset {
    
    /**
     * Funktion prüft, ob es einen überschriebenen Wert in entries gibt und gibt diesen zurück
     * ansonsten wird der Wert aus category zurückgegeben.
     * 
     * @param type $key
     * @return string
     */
    public function get_val($key): string
    { 
        $entry_key = 'se_'.$key;
        $category_key = $key.'_'.rex_clang::getCurrentId();
        if ($this->{$entry_key}) {
            return $this->{$entry_key};
        } elseif ($this->{$category_key}) {
            return $this->{$category_key};
        }
        return '';
    }
    
    /**
     * Liefert das Sprachbild. Fallback: Bild aus der Sprache 1
     * @return string
     */
    public function get_img(): string
    {
        if ($this->{'lang_image_'.rex_clang::getCurrentId()}) {
            return $this->{'lang_image_'.rex_clang::getCurrentId()};
        }
        if ($this->lang_image_1) {
            return $this->lang_image_1;
        }
        return '';
    }
    
    
    /**
     * Datumsfunktion - nach Belieben und eigenen Bedürfissen anpassen
     * @return string
     */
    public function get_formatted_date_and_time(): string
    {
        $day = explode('-',$this->se_start_date);
        if ($this->get_val('time_text')) {
            $time = $this->get_val('time_text');
        } else {
            $time = str_replace(':00','',$this->se_start_time).'  '.[1=>'Uhr',2=>'h'][rex_clang::getCurrentId()];
        }
        
        return $day[2].'.'.$day[1].', '.$time;
    }    
}

// Klasse für die Einträge

class rex_forcal_entries extends \rex_yform_manager_dataset {
    
}

// 

class my_forcal {
    
    var $where_raw_string;
    
    public function get_entries () {
        $clang = rex_clang::getCurrentId();

        // Datenbankzugriff jeweils auf die Sprachfelder
        // se steht für forcal-Entry, sc für forcal-Category
        
        $data = rex_forcal_categories::query()
            ->alias('sc')
            ->leftJoin('rex_forcal_entries','se','sc.id','se.category')
            ->leftJoin('rex_forcal_event_categories','sec','sc.category_id','sec.id')
            ->select('sec.name_'.$clang, 'sec_name')
            ->select('se.start_date', 'se_start_date')
            ->select('se.start_time', 'se_start_time')
            ->select('se.description_'.$clang, 'se_description')
            ->select('se.info_meetingpoint_'.$clang, 'se_info_meetingpoint')
            ->select('se.info_duration_'.$clang, 'se_info_duration')
            ->select('se.info_price_'.$clang, 'se_info_price')
            ->select('se.info_registration_'.$clang, 'se_info_registration')
            ->select('se.info_contact_'.$clang, 'se_info_contact')
            ->select('se.info_1_label_'.$clang, 'se_info_1_label')
            ->select('se.info_1_value_'.$clang, 'se_info_1_value')
            ->select('se.subtitle_'.$clang, 'se_subtitle')
            ->select('se.subline_'.$clang, 'se_subline')
            ->select('se.time_text_'.$clang, 'se_time_text')
            ->orderBy('se.start_date')
            ->where('se.start_date',date('Y-m-d'),'>=')
            ->where('sc.status', 1);
        
        if ($this->where_raw_string) {
            $data->whereRaw($this->where_raw_string);
        }

        return $data->find();
        
    }
    
}

$my_forcal = new my_forcal();
$res = $my_forcal->get_entries();

$fragment = new rex_fragment();
$fragment->setVar('termine',$res);
echo $fragment->parse('forcal_terminliste.php');

<ul>
<?php foreach ($this->termine as $i=>$item) : ?>
    <li>
        <a href="event-detail.html">
            <div class="event__date"><?= $item->get_formatted_date_and_time() ?></div>
            <div class="event__category"><?= $item->sec_name ?></div>
            <div class="event__title" style="color: <?= $item->color ?>"><?= $item->{'name_'.rex_clang::getCurrentId()} ?></div>
            <div class="event__subtitle"><?= $item->get_val('subtitle') ?></div>
            <div class="event__description"><?= $item->get_val('subline') ?></div>
        </a>
        <?= $item->get_val('description') ?>
        <dl class="uk-description-list ">
           <?php if ($item->get_val('info_meetingpoint')) : ?>
             <dt></dt>
             <dd><?= $item->get_val('info_meetingpoint') ?></dd>
           <?php endif ?>
           <?php if ($item->get_val('info_duration')) : ?>
             <dt></dt>
             <dd><?= $item->get_val('info_duration') ?></dd>
           <?php endif ?>
           <?php if ($item->get_val('info_price')) : ?>
             <dt></dt>
             <dd><?= $item->get_val('info_price') ?></dd>
           <?php endif ?>
           <?php if ($item->get_val('info_registration')) : ?>
             <dt></dt>
             <dd><?= $item->get_val('info_registration') ?></dd>
           <?php endif ?>
           <?php if ($item->get_val('info_contact')) : ?>
             <dt></dt>
             <dd><?= $item->get_val('info_contact') ?></dd>
           <?php endif ?>

           <?php if ($item->get_val('info_1_value')) : ?>
             <dt><?= $item->get_val('info_1_label') ?></dt>
             <dd><?= $item->get_val('info_1_value') ?></dd>
           <?php endif ?>
         </dl>             
         <img src="/images/content/<?= $item->get_img() ?>" alt="">
    </li>
<?php endforeach ?>