query($sqlquery);
if (DB::isError($result)) die ("$PHP_SELF: " . $result->getMessage());
$tableRows = "";
while ($row = $result->fetch_assoc()):
$srvArr = array();
$srv = $row["crvh_service"];
if (((int)$srv & 1) == 1) :
$srvArr[] = "Lieferung";
endif;
if (((int)$srv & 6) == 6) :
$srvArr[] = "Kran";
endif;
$srvTxt = implode(",", $srvArr);
$tableRows .= "\n";
$tableRows .= "| " . $row["cmp_comp"] . " | \n";
$tableRows .= "" . $row["cmp_comp2"] . " | \n";
$tableRows .= "" . $row["cmp_comp4"] . " | \n";
$tableRows .= "" . $row["cs_eid"] . " | \n";
$tableRows .= "" . $row["crvh_sid"] . " | \n";
$tableRows .= "" . $srvTxt . " | \n";
$tableRows .= "
\n";
endwhile;
$result->free();
$triggerOut .= "\n";
$triggerOut .= "\n";
$triggerOut .= "| " . getLngt("ÜBERSICHT KUNDEN-FAHRZEUG-BEZIEHUNGEN") . " | ";
$triggerOut .= "
\n";
$triggerOut .= "
\n";
$triggerOut .= "
";
$triggerOut .= "\n";
$triggerOut .= "\n";
$triggerOut .= "| " . getLngt("Systemkunde") . " | \n";
$triggerOut .= "" . "" . " | \n";
$triggerOut .= "" . "" . " | \n";
$triggerOut .= "" . getLngt("EID") . " | \n";
$triggerOut .= "" . getLngt("SID") . " | \n";
$triggerOut .= "" . getLngt("Service") . " | \n";
$triggerOut .= "
\n";
$triggerOut .= $tableRows;
$triggerOut .= "
\n";
endif;
?>