cld/protected/model/department.php

<?php
Doo::loadCore ( 'db/DooModel' );
class department extends DooModel {
	public $did;
	public $cid;
	public $departmentName;
	public $_table = 'CLD_department';
	public $_primarykey = 'did';
	public $_fields = array (
			'cid',
			'departmentName',
			'did' 
	);
	public function getDepartmentBycid($cid = 0) {
		return $this->find ( array (
				'where' => "cid= '" . $cid . "' ",
				'asArray' => TRUE 
		) );
	}
	public function getDepartmentByDid($did = 0) {
		return $this->getOne ( array (
				'where' => "did= '" . $did . "' ",
				'asArray' => TRUE 
		) );
	}
}
?>