Ignore:
Timestamp:
10/11/17 13:10:47 (6 years ago)
Author:
frank.jaeger
Message:

ALKIS Buchauskunft überarbeitet: Bodenschätzung im FS-Nachweis. Filter auf "endet IS NULL".

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/info/info/alkisn/alkisbestnw.php

    r387 r389  
    1010        2017-06-01 Function "eigentuemer" ohne Parameter $con 
    1111        2017-06-08 Validierung Eingabeparameter, Farbwechsel der Tabelle je GrundstÃŒck, Feinschliff und HTML-Profilierung 
     12        2017-10-09 SchlÃŒssel der Blattart bei berechtigten BlÀttern, sauber filtern auf endet IS NULL 
    1213*/ 
    1314session_start(); 
     
    5354LEFT JOIN alkis_wertearten wb ON cast(g.blattart AS character varying)=wb.k AND wb.element='ax_buchungsblatt' AND wb.bezeichnung='blattart' 
    5455LEFT JOIN alkis_wertearten wd ON cast(d.stellenart AS character varying)=wd.k AND wd.element='ax_dienststelle' AND wd.bezeichnung='stellenart' 
    55 WHERE g.gml_id= $1 AND g.endet IS NULL AND d.endet IS NULL;"; 
     56WHERE g.gml_id= $1 AND g.endet IS NULL AND b.endet IS NULL AND d.endet IS NULL;"; 
    5657// .. AND d.stellenart=1000  
    5758 
     
    198199                //  ax_buchungsstelle >an> ax_buchungsstelle (anderes Blatt, z.B Erbbaurecht an) 
    199200 
    200 /* alte Version  
    201                 $sql="SELECT sd.gml_id, sd.buchungsart, sd.laufendenummer AS lfd, sd.beschreibungdesumfangsderbuchung AS udb, sd.nummerimaufteilungsplan AS nrap, sd.beschreibungdessondereigentums AS sond, wb.v AS bart " 
    202                 ."FROM ax_buchungsstelle sh JOIN ax_buchungsstelle sd ON (sd.gml_id=ANY(sh.an) OR sd.gml_id=ANY(sh.zu)) " 
    203                 ."LEFT JOIN alkis_wertearten wb ON cast(sd.buchungsart AS character varying)=wb.k AND wb.element='ax_buchungsstelle' AND wb.bezeichnung='buchungsart' " 
    204                 ."WHERE sh.gml_id= $1 AND sh.endet IS NULL AND sd.endet IS NULL ORDER BY sd.laufendenummer;"; */ 
    205  
    206201                // Mit "UNION" um die FÀlle mit JOIN ÃŒber die Arrays "an" und "zu" unterscheiden zu können 
    207202                $sql="SELECT uni.*, wb.v AS bart FROM " 
     
    239234                        ."LEFT JOIN ax_buchungsblattbezirk z ON b.land=z.land AND b.bezirk=z.bezirk " 
    240235                        ."LEFT JOIN alkis_wertearten wb ON cast(b.blattart AS character varying)=wb.k AND wb.element='ax_buchungsblatt' AND wb.bezeichnung='blattart' " 
    241                         ."WHERE s.gml_id= $1 AND b.endet IS NULL ORDER BY b.land, b.bezirk, b.buchungsblattnummermitbuchstabenerweiterung;"; 
     236                        ."WHERE s.gml_id= $1 AND b.endet IS NULL AND s.endet IS NULL AND z.endet IS NULL ORDER BY b.land, b.bezirk, b.buchungsblattnummermitbuchstabenerweiterung;"; 
    242237                        $v=array($gml_bsan); 
    243238                        $fbres=pg_prepare("", $sql); 
     
    360355LEFT JOIN alkis_wertearten wb ON cast(sb.buchungsart AS character varying)=wb.k AND wb.element='ax_buchungsstelle' AND wb.bezeichnung='buchungsart' 
    361356LEFT JOIN alkis_wertearten wd ON cast(d.stellenart AS character varying)=wd.k AND wd.element='ax_dienststelle' AND wd.bezeichnung='stellenart' 
    362 WHERE sf.istbestandteilvon = $1 AND sf.endet IS NULL AND sb.endet IS NULL AND bb.endet IS NULL  
     357WHERE sf.istbestandteilvon = $1 AND sf.endet IS NULL AND sb.endet IS NULL AND bb.endet IS NULL AND bz.endet IS NULL AND d.endet IS NULL  
    363358ORDER BY cast(sf.laufendenummer AS integer), bz.bezeichnung, bb.buchungsblattnummermitbuchstabenerweiterung, cast(sb.laufendenummer AS integer);"; 
    364359 
     
    387382        } 
    388383 
    389         $anlfdnr=$rowb["anlfdnr"]; // an BVNR 
     384        $anlfdnr=$rowb["anlfdnr"];      // an BVNR 
    390385        $anlfdnr0=str_pad($anlfdnr, 4, "0", STR_PAD_LEFT); // mit fÃŒhr.0 
    391         $gml_b=$rowb["gml_id"]; // id des ber. Blattes 
    392         $gml_s=$rowb["gml_s"]; // id der ber. B-Stelle 
     386        $gml_b=$rowb["gml_id"];         // id des ber. Blattes 
     387        $gml_s=$rowb["gml_s"];          // id der ber. B-Stelle 
    393388        $blart=$rowb["blattart"]; 
    394389 
    395         $buch=$rowb["buchungsart"]; // Buchungsart Stelle berechtigt 
    396         $bart=$rowb["bart"]; // BA entschl. 
    397         $lfdnr=$rowb["lfdnr"]; // BVNR ber. 
     390        $buch=$rowb["buchungsart"];     // Buchungsart Stelle berechtigt 
     391        $bart=$rowb["bart"];            // BA entschl. 
     392        $lfdnr=$rowb["lfdnr"];          // BVNR ber. 
    398393        $bvnr=str_pad($lfdnr, 4, "0", STR_PAD_LEFT); 
    399394 
     
    420415                ."\n\t<td>" 
    421416                        ."\n\t\t<p class='nwlink noprint'>"; 
    422 // +++ SchlÃŒssel der Blatt-Art wenn showkey +++ 
     417                        if ($showkey) {echo "<span class='key'>".$blart."</span> ";} // NEU! 
    423418                        echo "\n\t\t\t<a href='alkisbestnw.php?gkz=".$gkz."&amp;gmlid=".$gml_b; 
    424419                                if ($showkey) {echo "&amp;showkey=j";} 
Note: See TracChangeset for help on using the changeset viewer.