function get_zuweisung_string_kurz($geldkonto_id)
{
$arr = $this->get_zuweisung_arr($geldkonto_id);
// print_r($arr);
if (is_array($arr)) {
$anz = count($arr);
$kos_bez_alle = '';
for ($a = 0; $a < $anz; $a++) {
$kos_typ = $arr[$a]['KOSTENTRAEGER_TYP'];
$kos_id = $arr[$a]['KOSTENTRAEGER_ID'];
if ($kos_typ != 'Eigentuemer') {
$r = new rechnung();
$kos_bez_alle .= $r->kostentraeger_ermitteln($kos_typ, $kos_id) . ', ';
} else {
$weg = new weg();
$weg->get_eigentumer_id_infos4($kos_id);
$kos_bez_alle .= $weg->einheit_kurzname . ', ';
}
if ($a == $anz - 1) {
$kos_bez_alle = substr($kos_bez_alle, 0, -2);
}
}
return $kos_bez_alle;
} else {
return 'Keine Zuweisung';
}
}
function ausgabe_saldo_et15($et_id, $arr)
{
$wegg = new weg();
$wegg->get_eigentumer_id_infos4($et_id);
$wegg->empf_namen;
$mon = count($arr);
echo "<table>";
echo "<tr><th>{$wegg->einheit_kurzname} - {$wegg->empf_namen}</th><th>SOLL</th><th>IST</th><th>SALDO M</th><th>SALDO ET</th><th>SALDO INS</th></tr>";
for ($a = 0; $a < $mon; $a++) {
$monatnr = $a + 1;
$monat = $arr[$a]['MONAT'];
$jahr = $arr[$a]['JAHR'];
$gar = $arr[$a]['GAR_MON'];
$saldo_vm = nummer_punkt2komma_t($arr[$a]['SALDO_VM']);
$m_m_soll = nummer_punkt2komma_t($arr[$a]['MIETER_M_SOLL'] * -1);
$m_erg_sum = nummer_punkt2komma_t($arr[$a]['MIETER_ERG_SUM']);
$m_sum_zb = nummer_punkt2komma_t($arr[$a]['SUM_MIETER_ZB']);
$m_sum_nk = nummer_punkt2komma_t($arr[$a]['SUM_MIETER_NK'] * -1);
$ein_sum_buchungen = nummer_punkt2komma_t($arr[$a]['SUM_EINHEIT_BUCHUNGEN']);
$ein_et_buchungen = nummer_punkt2komma_t($arr[$a]['SUM_ET_BUCHUNGEN']);
$sum_fix = nummer_punkt2komma_t($arr[$a]['FIXKOSTEN'] * -1);
$saldo_et = nummer_punkt2komma_t($arr[$a]['SALDO_MONAT_ET']);
$saldo_et1 = nummer_punkt2komma_t($arr[$a]['SALDO_MONAT_ET1']);
$saldo_ins = nummer_punkt2komma_t($arr[$a]['SALDO_MONAT_INS']);
// $saldo_et_math = nummer_punkt2komma_t($arr[$a]['SALDO_MONAT_MATH']);
if ($gar == 'JA') {
$bgcolor = "#FFB6C1";
} else {
$bgcolor = "#8FBC8F";
}
echo "<tr><td colspan=\"5\" align=\"center\" bgcolor=\"{$bgcolor}\">({$monatnr}. GARANTIE:{$gar}) <b> {$monat}.{$jahr}</b></td></tr>";
echo "<tr><td colspan=\"4\"><b>SALDO VM</b></td><td><b>{$saldo_vm}</b></td></tr>";
// echo "<tr><td >MIETER</td><td>$m_m_soll</td><td>$m_sum_zb</td><td>$m_erg_sum</td><td></td></tr>";
if (isset($arr[$a]['MIETER'])) {
echo "<tr><td><details><summary>MIETER BBBB</summary><ul>";
$anz_bu = count($arr[$a]['MIETER']);
echo "<table>";
echo "<tr><th>MIETER</th><th>KM SOLL</th><th>NK</th><th>WM</th><th>ZB</th><th>ERG</th></tr>";
for ($bu = 0; $bu < $anz_bu; $bu++) {
$mname = $arr[$a]['MIETER'][$bu]['M_NAME'];
$mi_zb = $arr[$a]['MIETER'][$bu]['MI_ZB'];
// if(!empty($mi_zb) && $mi_zb!='0.00'){
$km_soll = $arr[$a]['MIETER'][$bu]['KM_SOLL'];
$nk_soll = $arr[$a]['MIETER'][$bu]['NK_SOLL'];
$wm_soll = $arr[$a]['MIETER'][$bu]['WM_SOLL'];
$mi_erg = $arr[$a]['MIETER'][$bu]['MI_ERG'];
echo "<tr><td>{$mname}</td><td>{$km_soll}</td><td>{$nk_soll}</td><td>{$wm_soll}</td><td>{$mi_zb}</td><td>{$mi_erg}</td></tr>";
// }
}
echo "</table>";
echo "</ul></details>";
} else {
echo "<tr><td>BUCHUNG MIETER";
}
echo "</td><td>{$m_m_soll}</td><td>{$m_sum_zb}</td><td>{$m_erg_sum}</td><td></td></tr>";
echo "<tr><td>NEBENKOSTEN</td><td></td><td>{$m_sum_nk}</td><td></td><td></td></tr>";
echo "<tr><td>FIXKOSTEN</td><td></td><td>{$sum_fix}</td><td></td><td></td></tr>";
// echo "<tr><td>BUCHUNG EINHEIT</td><td></td><td>$ein_sum_buchungen</td><td></td><td></td></tr>";
if (isset($arr[$a]['EINHEIT'])) {
echo "<tr><td><details><summary>BUCHUNG EINHEIT</summary><ul>";
$anz_bu = count($arr[$a]['EINHEIT']);
echo "<table>";
for ($bu = 0; $bu < $anz_bu; $bu++) {
$kto = $arr[$a]['EINHEIT'][$bu]['KTO'];
$datum = $arr[$a]['EINHEIT'][$bu]['DATUM'];
$txt = $arr[$a]['EINHEIT'][$bu]['TXT'];
$b_betrag = $arr[$a]['EINHEIT'][$bu]['BETRAG'];
echo "<tr><td>{$datum}</td><td>{$kto}</td><td>{$txt}</td><td>{$b_betrag}</td></tr>";
}
echo "</table>";
echo "</ul></details>";
} else {
echo "<tr><td>BUCHUNG EINHEIT";
}
echo "</td><td></td><td>{$ein_sum_buchungen}</td><td></td><td></td></tr>";
if (isset($arr[$a]['ET'])) {
echo "<tr><td><details><summary>BUCHUNG ET</summary><ul>";
$anz_bu = count($arr[$a]['ET']);
echo "<table>";
for ($bu = 0; $bu < $anz_bu; $bu++) {
$kto = $arr[$a]['ET'][$bu]['KTO'];
$datum = $arr[$a]['ET'][$bu]['DATUM'];
$txt = $arr[$a]['ET'][$bu]['TXT'];
$b_betrag = $arr[$a]['ET'][$bu]['BETRAG'];
echo "<tr><td>{$datum}</td><td>{$kto}</td><td>{$txt}</td><td>{$b_betrag}</td></tr>";
}
echo "</table>";
echo "</ul></details>";
} else {
echo "<tr><td>BUCHUNG ET";
}
echo "</td><td></td><td>{$ein_et_buchungen}</td><td></td><td></td></tr>";
// echo "<tr><td>SALDEN MIETER</td><td>$m_erg_sum</td><td></td></tr>";
echo "<tr><td><b>SALDO MONAT ET</b></td><td></td><td><b>{$saldo_et1}</b></td><td></td><td><b>{$saldo_et}</b></td></tr>";
echo "<tr><td><b>SALDO MONAT INS</b></td><td></td><td><b></b></td><td></td><td></td><td><b>{$saldo_ins}</b></td></tr>";
echo "<tr><td colspan=\"6\"><hr></td></tr>";
}
echo "</table>";
/*
* echo '
* <details>
* <summary>Übungen zu Kapitel 1</summary>
* <ul>
* <li><a href="/?exercise=A1E1">Grammar: simple past tense</a></li>
* <li><a href="/?exercise=A1E2">Vocabulary: things to eat</a></li>
* <li><a href="/?exercise=A1E3">Fun: watch the apes</a></li>
* </ul>
* </details>
* <details>
* <summary>Übungen zu Kapitel 2</summary>
* <ul>
* <li><a href="/?exercise=A2E1">Story: to be the first one</a></li>
* <li><a href="/?exercise=A2E2">Grammar: would</a></li>
* <li><a href="/?exercise=A2E3">Vocabulary: traffic</a></li>
* </ul>
* </details>';
*/
if (isset($_REQUEST['pdf'])) {
ob_clean();
// ausgabepuffer leeren
$pdf = new Cezpdf('a4', 'portrait');
$bpdf = new b_pdf();
$bpdf->b_header($pdf, 'Partner', $_SESSION['partner_id'], 'portrait', 'Helvetica.afm', 6);
$cols = array('MONAT' => "Monat", 'JAHR' => "Jahr", 'GAR_MON' => "Gar.", 'SUM_MIETER_ZB' => 'ZB', 'SUM_MIETER_NK' => 'NK', 'SUM_ET_BUCHUNGEN' => 'ET', 'SUM_EINHEIT_BUCHUNGEN' => 'FLAT', 'FIXKOSTEN' => 'FIX', 'SALDO_MONAT_ET' => 'SALDOET', 'SALDO_MONAT_ET1' => 'SALDOET1', 'SALDO_MONAT_INS' => 'S_INS');
// $seit_monat = monat2name($drucken_m);
// $pdf->ezTable($arr);
$pdf->ezTable($arr, $cols, "Mietkontenblatt seit {$seit_monat} {$drucken_j}", array('showHeadings' => 1, 'shaded' => 0, 'titleFontSize' => 8, 'fontSize' => 7, 'xPos' => 50, 'xOrientation' => 'right', 'width' => 500, 'rowGap' => 1, 'cols' => array('DATUM' => array('justification' => 'right', 'width' => 50), 'BEMERKUNG' => array('justification' => 'left', 'width' => 300), 'BETRAG' => array('justification' => 'right', 'width' => 75), 'SALDO' => array('justification' => 'right', 'width' => 75))));
ob_clean();
// ausgabepuffer leeren
// $gk_bez = date("Y_m_d").'_Mietkonto_kurz_'.str_replace(' ', '_', $mv->einheit_kurzname);
// $pdf_opt['Content-Disposition'] = $gk_bez;
$pdf->ezStream();
}
}
function pdf_et_liste_alle_kurz($objekt_id)
{
$o = new objekt();
$o->objekt_informationen($objekt_id);
$det1 = new detail();
$objekt_mea = $det1->finde_detail_inhalt('Objekt', $objekt_id, 'Gesamtanteile');
$ein_arr = $this->einheiten_weg_tabelle_arr($objekt_id);
$anz_e = count($ein_arr);
$zeile = 0;
/* schleife Einheiten */
for ($e = 0; $e < $anz_e; $e++) {
$einheit_id = $ein_arr[$e]['EINHEIT_ID'];
$det1 = new detail();
$einheit_mea = $det1->finde_detail_inhalt('Einheit', $einheit_id, 'WEG-Anteile');
$weg = new weg();
$et_arr = $weg->get_eigentuemer_arr($einheit_id);
$anz_et = count($et_arr);
for ($et = 0; $et < $anz_et; $et++) {
$et_id = $et_arr[$et]['ID'];
$et_von = $et_arr[$et]['VON'];
$et_bis = $et_arr[$et]['BIS'];
$weg1 = new weg();
$weg1->get_eigentumer_id_infos4($et_id);
$pdf_tab[$zeile]['P_DETAILS'] = '';
for ($p = 0; $p < $weg1->anz_personen; $p++) {
$det1 = new detail();
$person_id = $weg1->personen_id_arr1[$p]['PERSON_ID'];
$alle_details = $det1->finde_alle_details_arr('Person', $person_id);
$pers = new person();
$pers->get_person_infos($person_id);
$pdf_tab[$zeile]['P_DETAILS'] .= "<b>{$pers->person_vorname} {$pers->person_nachname}</b>\n";
$pdf_tab[$zeile]['P_DETAILS'] .= "<b>Geb. am:</b> {$pers->person_geburtstag}\n";
for ($dd = 0; $dd < count($alle_details); $dd++) {
$pdf_tab[$zeile]['P_DETAILS'] .= "<b>" . rtrim(ltrim(strip_tags($alle_details[$dd]['DETAIL_NAME']))) . ":</b> " . rtrim(ltrim(strip_tags($alle_details[$dd]['DETAIL_INHALT'])));
if ($dd < count($alle_details) - 1) {
$pdf_tab[$zeile]['P_DETAILS'] .= "\n";
}
}
if ($p < $weg1->anz_personen - 1) {
$pdf_tab[$zeile]['P_DETAILS'] .= "\n<b>++++++++++++++++++++++++++++++++++++++++++++++</b>\n";
}
}
unset($alle_details);
$pdf_tab[$zeile]['EINHEIT_KN'] = $weg1->einheit_kurzname;
$pdf_tab[$zeile]['ET_NAME'] = $weg1->empf_namen;
$pdf_tab[$zeile]['VON'] = date_mysql2german($weg1->eigentuemer_von);
$pdf_tab[$zeile]['BIS'] = date_mysql2german($weg1->eigentuemer_bis);
$pdf_tab[$zeile]['EINHEIT_QM'] = $weg1->einheit_qm_weg_d;
$pdf_tab[$zeile]['EINHEIT_L'] = $weg1->einheit_lage;
$pdf_tab[$zeile]['MEA'] = $einheit_mea;
$pdf_tab[$zeile]['HAUS'] = $weg1->haus_strasse;
$pdf_tab[$zeile]['HAUSNR'] = $weg1->haus_nummer;
$pdf_tab[$zeile]['PLZ'] = $weg1->haus_plz;
$pdf_tab[$zeile]['ORT'] = $weg1->haus_stadt;
$zeile++;
}
$einheit_mea = 0;
}
$pdf = new Cezpdf('a4', 'landscape');
$bpdf = new b_pdf();
$bpdf->b_header($pdf, 'Partner', $_SESSION['partner_id'], 'landscape', 'Helvetica.afm', 6);
$pdf->ezSetDy(15);
// abstand
$pdf->ezText("Objektname: {$o->objekt_name}, Gesamtanteile: {$objekt_mea} MEA", 12);
$pdf->ezSetDy(-10);
// abstand
$cols = array('EINHEIT_KN' => "EINHEIT", 'ET_NAME' => "EIGENTÜMER", 'P_DETAILS' => "DETAILS", 'VON' => "VON", 'BIS' => "BIS", 'EINHEIT_QM' => "m²", 'EINHEIT_L' => "LAGE", 'MEA' => "MEA", 'HAUS' => "Straße", 'HAUSNR' => "Hausnr.", 'PLZ' => "PLZ", 'ORT' => "Ort");
$pdf->ezTable($pdf_tab, $cols, "{$o->objekt_name}", array('showHeadings' => 1, 'shaded' => 1, 'titleFontSize' => 8, 'fontSize' => 7, 'xPos' => 40, 'xOrientation' => 'right', 'width' => 760, 'cols' => array('P_DETAILS' => array('justification' => 'left', 'width' => 200))));
ob_clean();
// ausgabepuffer leeren
header("Content-type: application/pdf");
// wird von MSIE ignoriert
$pdf->ezStream();
}
