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(); }