cld/protected/model/L_category.php

<?php
Doo::loadCore ( 'db/DooModel' );
class L_category extends DooModel {
	public $cid;
	public $title;
	public $defult;
	public $districtid;
	public $_table = 'CLD_L_category';
	public $_primarykey = 'cid';
	public $_fields = array (
			'cid',
			'title',
			'defult',
			'districtid' 
	);
	public function checkUser($uid, $passwork) {
		return $this->find ( array (
				'where' => "uid= '" . $uid . "' and passwork = '" . addslashes ( $passwork ) . "'",
				'asArray' => TRUE 
		) );
	}
	public function getCategoryInCid($cidString = '') {
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		
		if (empty ( $cidString ))
			return array ();
		
		$list= $this->find ( array (
				'where' => "cid in ( " .$cidString . ") ",
				'asArray' => TRUE 
		) );
		foreach ( $list as $key => $value ) {
			$list [$key] ['cidKey'] = $XDeode->encode ( $value ['cid'] );
		}
		return $list;
	}
	public function getCategoryById($cid = 0, $othercid = "") {
		if (! empty ( $othercid ))
			return $this->find ( array (
					'where' => "cid in ( " . $cid . "," . $othercid . ") ",
					'asArray' => TRUE 
			) );
		else
			return $this->find ( array (
					'where' => "cid= '" . $cid . "' ",
					'asArray' => TRUE 
			) );
	}
	public function getCategory() {
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		Doo::loadModel ( 'department' );
		$department = new department ();
		
		$list = $this->find ( array (
				'asc' => 'cid',
				'asArray' => TRUE 
		) );
		
		foreach ( $list as $key => $value ) {
			$list [$key] ['cidKey'] = $XDeode->encode ( $value ['cid'] );
			$list [$key] ['department'] =$department->getDepartmentBycid($value ['cid']);
		}
		
		return $list;
	}
	
	/**
	 * 获得办事处和部门
	 * @return unknown
	 */
	public function getCategoryDepartment(){
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		Doo::loadModel ( 'department' );
		$department = new department ();
		$categorylist2 = $this->find ( array (
				'desc' => 'cid',
				'asArray' => TRUE
		) );
		
		$categorylist3=$categorylist2;
		$bakCategory = array ();
		foreach ( $categorylist3 as $key => $value ) {
			$departList = $department->getDepartmentBycid ( $value ['cid'] );
			if (! empty ( $departList )) {
				array_unshift ( $bakCategory, $value );
				
				unset ( $categorylist2 [$key] );
				foreach ( $departList as $v ) {
					array_unshift ( $bakCategory, array (
							'cid' => $v ['cid'],
							'cidKey'=> $XDeode->encode ( $v ['cid'] ),
							'title' => $value ['title'],
							'did' => $v ['did'],
							'didKey'=>$XDeode->encode ( $v ['did'] ),
							'departmentName' => $v ['departmentName']
					) );
				}
			}
		}
		
		foreach ( $bakCategory as $value ) {
			array_unshift ( $categorylist2, $value );
		}
		
		foreach ($categorylist2 as $key=>$value){
			$categorylist2 [$key]['cidKey']=$XDeode->encode ( $value ['cid'] );
			if(!isset($categorylist2 [$key]['didKey'])||empty($categorylist2 [$key]['didKey']))
				$categorylist2 [$key]['didKey']='';
			
		}
		
		return $categorylist2;
	}
	
	
	public function getUserByIdList($puid) {
		return $this->find ( array (
				'where' => "uid= '" . $puid . "'",
				'asArray' => TRUE 
		) );
	}
	public function getCategoryStaff() {
		$list = $this->find ( array (
				'asArray' => TRUE 
		) );
		Doo::loadModel ( 'staff' );
		$staff = new staff ();
		foreach ( $list as $key => $value ) {
			$list [$key] ['staff'] = $staff->getStaffByCid ( $value ['cid'] );
		}
		return $list;
	}
}

?>