Files

36 lines
779 B
PHP

<?php
namespace HermannTelser\Gutachten\Downloads\Nutzflaeche;
use HermannTelser\Gutachten\DB\DbFunction;
class ObjectAufGeschossen
{
public static function load()
{
// DbFunction::$debug = 1;
$_arr = DbFunction::select(
'tx_gutachten_raume_all',
['tt_raume_basis_id', 'geschoss'],
[
'AND' => ['pid' => DbFunction::$projektid, 'tt_raumart_id[!]' => 4],
'GROUP' => ['tt_raume_basis_id', 'geschoss'],
]
);
$_objekte_geschosse = [];
foreach ($_arr as $key => $value) {
$basisid = $value['tt_raume_basis_id'];
$geschoss = $value['geschoss'];
$_objekte_geschosse[$basisid][] = $geschoss;
}
foreach ($_objekte_geschosse as $key => $value) {
$_objekte_geschosse[$key] = implode(',', $value);
}
return $_objekte_geschosse;
}
}