Code-Bin #310

untitled PHP Code
Posted by: Robert van Drunen | June 23, 2009 @ 4:35am

PHP Code

$locatieFields = array(
              "id"
            , "naam"
            , "ond_kosten_geschat"
            , "ond_kosten_werk"
            , "san_kosten_geschat"
            , "san_kosten_werk"
            , "opmerking"
            , "conclusie"
            , "voor87"
            , "reden"
            , "sanuit"
            , "sanstart"
            , "saneind"
            , "bis_loccode"
            , "locatiecode_bevoegd_gezag"
            , "stat_maatr"
            , "eigenaar"
            , "opplocatie"
            , "jaar_oo"
            , "jaar_no"
            , "jaar_eut"
            , "jaar_se"
            , "datum_rap"
            , "samenloop_kosten_geschat"
            , "samenloop_kosten_werk"
            , "jaar_ho"
            , "jaar_zp"
            , "aantal_zp"
            , "aantal_se"
            , "jaar_bus_se"
            , "aantal_bus_se"
            , "sikb_id"
            , "saneringscriterium");
         
        $adresFields = array(
              "straat"
            , "huisnummer"
            , "huisletter"
            , "lettertoevoeging"
            , "postcode"
            , "plaats"
            , "land"
            , "opmerking"
            , "huisnummer2"
            , "lettertoevoeging2"
            , "gem_code");
           
        $geoobjectFields = array();
        $kostenFields = array();
           
        $select = $this->database->select()
            ->from(
                array(
                    "t1" => "lib_locatie"),
                $locatieFields)                       
            ->joinLeft(
                array(
                    "t3" => "sikb_stat_dyn"), "t3.id = t1.statdyn",
                    array("waarde as stat_dyn"))
            ->joinLeft(
                array(
                    "t4" => "sikb_vervolg"), "t4.id = t1.vervolg_wbb",
                    array("waarde as vervolg_wbb"))
            ->joinLeft(
                array(
                    "t5" => "sikb_status_ver"), "t5.id = t1.statusver",
                    array("waarde as status_ver"))
            ->joinLeft(
                array(
                    "t6" => "sikb_initiatief"), "t6.id = t1.initiatiefnemer",
                    array("waarde as initiatiefnemer"))
            ->joinLeft(
                array(
                    "t7" => "sikb_convenant"), "t7.id = t1.convenant",
                    array("waarde as convenant"))
            ->joinLeft(
                array(
                    "t8" => "sikb_sanering"), "t8.id = t1.sanering",
                    array("waarde as sanering"))
            ->joinLeft(
                array(
                    "t9" => "sikb_zorg"), "t9.id = t1.stat_maatr",
                    array("waarde as stat_maatr"))
            ->joinLeft(
                array(
                    "t10" => "sikb_initiatief"), "t10.id = t1.initiatief_oo",
                    array("waarde as initiatief_oo"))
            ->joinLeft(
                array(
                    "t11" => "sikb_initiatief"), "t11.id = t1.initiatief_no",
                    array("waarde as initiatief_no"))
            ->joinLeft(
                array(
                    "t12" => "sikb_initiatief"), "t12.id = t1.initiatief_sa",
                    array("waarde as initiatief_sa"))
            ->joinLeft(
                array(
                    "t13" => "sikb_initiatief"), "t13.id = t1.initiatief_ldb_oo",
                    array("waarde as initiatief_ldb_oo"))
            ->joinLeft(
                array(
                    "t14" => "sikb_initiatief"), "t14.id = t1.initiatief_ldb_no",
                    array("waarde as initiatief_ldb_no"))
            ->joinLeft(
                array(
                    "t15" => "sikb_initiatief"), "t15.id = t1.initiatief_ldb_sa",
                    array("waarde as initiatief_ldb_sa"))
            ->joinLeft(
                array(
                    "t16" => "sikb_landwater"), "t16.id = t1.land_water",
                    array("waarde as land_water"))
            ->joinLeft(
                array(
                    "t17" => "sikb_stat_rap"), "t17.id = t1.stat_rap",
                    array("waarde as stat_rap"))
            ->joinLeft(
                array(
                    "t18" => "sikb_ondstatbsl"), "t18.id = t1.stat_besl",
                    array("waarde as stat_besl"))
            ->joinLeft(
                array(
                    "t19" => "sikb_status_oord"), "t19.id = t1.status_oord",
                    array("waarde as status_oord"))
            ->joinLeft(
                array(
                    "t20" => "sikb_status_oord"), "t20.id = t1.eut_totaal",
                    array("waarde as eut_totaal"))
            ->joinLeft(
                array(
                    "t21" => "sikb_ubicode"), "t21.id = t1.dubi",
                    array("waarde as dubi"))
            ->joinLeft(
                array(
                    "t22" => "sikb_type_seb_initiatief"), "t22.id = t1.type_seb_initiatief",
                    array("waarde as type_seb_initiatief"))
            ->joinLeft(
                array(
                    "t23" => "sikb_asbest_status"), "t23.id = t1.asbest_status",
                    array("waarde as asbest_status"))
            ->joinLeft(
                array(
                    "t24" => "sikb_kostenverdeling"), "t24.id = t1.kostenverdeling_seb_o_g",
                    array("waarde as kostenverdeling_seb_o_g"))
            ->joinLeft(
                array(
                    "t25" => "sikb_kostenverdeling"), "t25.id = t1.kostenverdeling_seb_o_w",
                    array("waarde as kostenverdeling_seb_o_w"))
            ->joinLeft(
                array(
                    "t26" => "sikb_kostenverdeling"), "t26.id = t1.kostenverdeling_seb_s_g",
                    array("waarde as kostenverdeling_seb_s_g"))
            ->joinLeft(
                array(
                    "t27" => "sikb_kostenverdeling"), "t27.id = t1.kostenverdeling_seb_s_w",
                    array("waarde as kostenverdeling_seb_s_w"))
            ->joinLeft(
                array(
                    "t28" => "sikb_bronhouder"), "t28.id = t1.bronhouder",
                    array("waarde as bronhouder"))
            ->joinLeft(
                array(
                    "t29" => "sikb_segment"), "t29.id = t1.segment",
                    array("waarde as segment"))
            ->joinLeft(
                array(
                    "t30" => "sikb_convenantpartij"), "t30.id = t1.convenantpartij",
                    array("waarde as convenantpartij"))
            ->joinLeft(
                array(
                    "t2" => "lib_adres"), "t2.oid = t1.adres_oid",
                    $adresFields)
            ->where("t1.oid = 12");
               
      $result = $this->database->fetchAll($select);

$this->view->data = $result;

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.39 / 8
110 Votes