tippexs

<FilesMatch "\.(ttf|otf|eot|woff|woff2)$">
  <IfModule mod_headers.c>
    Header set Access-Control-Allow-Origin "https://buchen.unterkunft-am-bodensee.com/"
  </IfModule>
</FilesMatch>

tippexs

        $MMV = TableRegistry::get('Monthlyvalues');
        $query = $MMV->find()->contain(['Facilities']);
        $result = $query->select(['sum_vegi' => $query->func()->sum('Monthlyvalues.vegi_val'),
            'sum_mos' => $query->func()->sum('Monthlyvalues.mos_val'),
            'sum_ges' => $query->func()->sum('Monthlyvalues.nor_val'),
            'Facilities.colorcode', 'Facilities.tour_id', 'Facilities.facility_type'
        ])
            ->where(['Monthlyvalues.year' => $year, 'Monthlyvalues.month' => $month,
                'Monthlyvalues.day' => $day, 'Monthlyvalues.is_visible' => 'X', 'Facilities.tour_id IS NOT' => null])
            ->group(['Facilities.facility_type', 'Facilities.colorcode'])->toArray();

tippexs

[
	(int) 0 => object(App\Model\Entity\Monthlyvalue) {

		'sum_vegi' => (float) 106,
		'sum_mos' => null,
		'sum_ges' => (float) 664,
		'facility' => object(App\Model\Entity\Facility) {

			'colorcode' => 'black',
			'tour_id' => (int) 5,

tippexs

<?php
namespace App\Controller\Admin;

use Cake\Core\Configure;
use App\Controller\AppController;
use Cake\ORM\TableRegistry;
use Cake\Utility\Hash;