cld/protected/model/district.php

<?php

Doo::loadCore('db/DooModel');

class district extends DooModel {

    public $id;
    public $name;
    public $level;
   	public $usetype;
    public $upid;
    public $displayorder;
    public $area;
    
    public $_table = 'CLD_district';
    public $_primarykey = 'id';
    public $_fields = array('id', 'name', 'level', 'usetype', 'upid', 'displayorder', 'area');


	public function get_all() {
        $archive_list = $this->find(array( 'asc' => 'id',  'asArray' => true));
        return $archive_list;
    }
    
	public function getbyid($id) {
        $archive_list = $this->find(array('select' => 'id,name,level,upid,area', 'where' => 'id=' . $id, 'asArray' => true));
        
        return $archive_list;
    }
    
	public function getbyidlist($id) {
        $archive_list = $this->find(array('select' => 'id,name,level,upid,area', 'where' => 'id in ( ' . $id.' )', 'asArray' => true));
        
        return $archive_list;
    }
    
    public function get_lvByStaffid($lv,$sid){
    	$sql = "select * from CLD_district_staff as a left join " . $this->_table . " as b on (a.did=b.id and a.sid=".$sid.")  where level= ".$lv ." group by b.id" ;
		
    	$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
    }
    
	public function districtByStaffid($did,$sid){
    	$sql = "select * from CLD_district_staff as a left join " . $this->_table . " as b on (a.did=b.id and a.sid=".$sid.")  where upid= ".$did  ;
		
    	$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
    }
    
	public function get_lv($lv) {
        $archive_list = $this->find(array( 'asc' => 'id','where'=>'level='.$lv,  'asArray' => true));
        return $archive_list;
    }
    
	public function get_lvByid($lv,$id) {
        $archive_list = $this->find(array( 'asc' => 'id','where'=>' upid='.$id,  'asArray' => true));
        return $archive_list;
    }
    
}

?>