1. $locatieFields = array(
  2.               "id"
  3.             , "naam"
  4.             , "ond_kosten_geschat"
  5.             , "ond_kosten_werk"
  6.             , "san_kosten_geschat"
  7.             , "san_kosten_werk"
  8.             , "opmerking"
  9.             , "conclusie"
  10.             , "voor87"
  11.             , "reden"
  12.             , "sanuit"
  13.             , "sanstart"
  14.             , "saneind"
  15.             , "bis_loccode"
  16.             , "locatiecode_bevoegd_gezag"
  17.             , "stat_maatr"
  18.             , "eigenaar"
  19.             , "opplocatie"
  20.             , "jaar_oo"
  21.             , "jaar_no"
  22.             , "jaar_eut"
  23.             , "jaar_se"
  24.             , "datum_rap"
  25.             , "samenloop_kosten_geschat"
  26.             , "samenloop_kosten_werk"
  27.             , "jaar_ho"
  28.             , "jaar_zp"
  29.             , "aantal_zp"
  30.             , "aantal_se"
  31.             , "jaar_bus_se"
  32.             , "aantal_bus_se"
  33.             , "sikb_id"
  34.             , "saneringscriterium");
  35.  
  36.         $adresFields = array(
  37.               "straat"
  38.             , "huisnummer"
  39.             , "huisletter"
  40.             , "lettertoevoeging"
  41.             , "postcode"
  42.             , "plaats"
  43.             , "land"
  44.             , "opmerking"
  45.             , "huisnummer2"
  46.             , "lettertoevoeging2"
  47.             , "gem_code");
  48.  
  49.         $geoobjectFields = array();
  50.         $kostenFields = array();
  51.  
  52.         $select = $this->database->select()
  53.             ->from(
  54.                 array(
  55.                     "t1" => "lib_locatie"),
  56.                 $locatieFields)                       
  57.             ->joinLeft(
  58.                 array(
  59.                     "t3" => "sikb_stat_dyn"), "t3.id = t1.statdyn",
  60.                     array("waarde as stat_dyn"))
  61.             ->joinLeft(
  62.                 array(
  63.                     "t4" => "sikb_vervolg"), "t4.id = t1.vervolg_wbb",
  64.                     array("waarde as vervolg_wbb"))
  65.             ->joinLeft(
  66.                 array(
  67.                     "t5" => "sikb_status_ver"), "t5.id = t1.statusver",
  68.                     array("waarde as status_ver"))
  69.             ->joinLeft(
  70.                 array(
  71.                     "t6" => "sikb_initiatief"), "t6.id = t1.initiatiefnemer",
  72.                     array("waarde as initiatiefnemer"))
  73.             ->joinLeft(
  74.                 array(
  75.                     "t7" => "sikb_convenant"), "t7.id = t1.convenant",
  76.                     array("waarde as convenant"))
  77.             ->joinLeft(
  78.                 array(
  79.                     "t8" => "sikb_sanering"), "t8.id = t1.sanering",
  80.                     array("waarde as sanering"))
  81.             ->joinLeft(
  82.                 array(
  83.                     "t9" => "sikb_zorg"), "t9.id = t1.stat_maatr",
  84.                     array("waarde as stat_maatr"))
  85.             ->joinLeft(
  86.                 array(
  87.                     "t10" => "sikb_initiatief"), "t10.id = t1.initiatief_oo",
  88.                     array("waarde as initiatief_oo"))
  89.             ->joinLeft(
  90.                 array(
  91.                     "t11" => "sikb_initiatief"), "t11.id = t1.initiatief_no",
  92.                     array("waarde as initiatief_no"))
  93.             ->joinLeft(
  94.                 array(
  95.                     "t12" => "sikb_initiatief"), "t12.id = t1.initiatief_sa",
  96.                     array("waarde as initiatief_sa"))
  97.             ->joinLeft(
  98.                 array(
  99.                     "t13" => "sikb_initiatief"), "t13.id = t1.initiatief_ldb_oo",
  100.                     array("waarde as initiatief_ldb_oo"))
  101.             ->joinLeft(
  102.                 array(
  103.                     "t14" => "sikb_initiatief"), "t14.id = t1.initiatief_ldb_no",
  104.                     array("waarde as initiatief_ldb_no"))
  105.             ->joinLeft(
  106.                 array(
  107.                     "t15" => "sikb_initiatief"), "t15.id = t1.initiatief_ldb_sa",
  108.                     array("waarde as initiatief_ldb_sa"))
  109.             ->joinLeft(
  110.                 array(
  111.                     "t16" => "sikb_landwater"), "t16.id = t1.land_water",
  112.                     array("waarde as land_water"))
  113.             ->joinLeft(
  114.                 array(
  115.                     "t17" => "sikb_stat_rap"), "t17.id = t1.stat_rap",
  116.                     array("waarde as stat_rap"))
  117.             ->joinLeft(
  118.                 array(
  119.                     "t18" => "sikb_ondstatbsl"), "t18.id = t1.stat_besl",
  120.                     array("waarde as stat_besl"))
  121.             ->joinLeft(
  122.                 array(
  123.                     "t19" => "sikb_status_oord"), "t19.id = t1.status_oord",
  124.                     array("waarde as status_oord"))
  125.             ->joinLeft(
  126.                 array(
  127.                     "t20" => "sikb_status_oord"), "t20.id = t1.eut_totaal",
  128.                     array("waarde as eut_totaal"))
  129.             ->joinLeft(
  130.                 array(
  131.                     "t21" => "sikb_ubicode"), "t21.id = t1.dubi",
  132.                     array("waarde as dubi"))
  133.             ->joinLeft(
  134.                 array(
  135.                     "t22" => "sikb_type_seb_initiatief"), "t22.id = t1.type_seb_initiatief",
  136.                     array("waarde as type_seb_initiatief"))
  137.             ->joinLeft(
  138.                 array(
  139.                     "t23" => "sikb_asbest_status"), "t23.id = t1.asbest_status",
  140.                     array("waarde as asbest_status"))
  141.             ->joinLeft(
  142.                 array(
  143.                     "t24" => "sikb_kostenverdeling"), "t24.id = t1.kostenverdeling_seb_o_g",
  144.                     array("waarde as kostenverdeling_seb_o_g"))
  145.             ->joinLeft(
  146.                 array(
  147.                     "t25" => "sikb_kostenverdeling"), "t25.id = t1.kostenverdeling_seb_o_w",
  148.                     array("waarde as kostenverdeling_seb_o_w"))
  149.             ->joinLeft(
  150.                 array(
  151.                     "t26" => "sikb_kostenverdeling"), "t26.id = t1.kostenverdeling_seb_s_g",
  152.                     array("waarde as kostenverdeling_seb_s_g"))
  153.             ->joinLeft(
  154.                 array(
  155.                     "t27" => "sikb_kostenverdeling"), "t27.id = t1.kostenverdeling_seb_s_w",
  156.                     array("waarde as kostenverdeling_seb_s_w"))
  157.             ->joinLeft(
  158.                 array(
  159.                     "t28" => "sikb_bronhouder"), "t28.id = t1.bronhouder",
  160.                     array("waarde as bronhouder"))
  161.             ->joinLeft(
  162.                 array(
  163.                     "t29" => "sikb_segment"), "t29.id = t1.segment",
  164.                     array("waarde as segment"))
  165.             ->joinLeft(
  166.                 array(
  167.                     "t30" => "sikb_convenantpartij"), "t30.id = t1.convenantpartij",
  168.                     array("waarde as convenantpartij"))
  169.             ->joinLeft(
  170.                 array(
  171.                     "t2" => "lib_adres"), "t2.oid = t1.adres_oid",
  172.                     $adresFields)
  173.             ->where("t1.oid = 12");
  174.  
  175.       $result = $this->database->fetchAll($select);
  176.  
  177.       $this->view->data = $result;
  178.  
  179.  
  180.