<?php

class ADBOrtschaftController extends mfBaseController {
  
  protected function init() {
    $db = $this->db(ADDRESSDB_DBHOST, ADDRESSDB_DBUSER, ADDRESSDB_DBPASS, ADDRESSDB_DBNAME);
  }
  
  public function getOrte() {
    $orte = array();
    
    $res = $this->db()->query("SELECT ortschaft_id AS id FROM view_ort ORDER BY gemeinde_kennziffer,gemeinde,ort");
    if($this->db()->num_rows($res)) {
      while($data = $this->db()->fetch_object($res)) {
        $orte[] = new ADBOrtschaft($data->id);
      }
    }
    
    return $orte;
  }
}