wenda-php/protected/model/ExamineDao.php

<?php
Doo::loadCore ( 'db/DooModel' );
class ExamineDao extends DooModel {
	public $id;
	public $cid;
	public $cid1;
	public $cid2;
	public $cid3;
	public $price;
	public $author;
	public $authorid;
	public $title;
	public $description;
	public $supply;
	public $url;
	public $time;
	public $endtime;
	public $phone;
	public $hidden;
	public $answers;
	public $views;
	public $goods;
	public $status;
	public $ip;
	public $search_words;
	public $delete;
	public $_table = 'zhask_examine';
	public $_primarykey = "id";
	public $_fields = array (
			'id',
			'cid',
			'cid1',
			'cid2',
			'cid3',
			'price',
			'author',
			'authorid',
			'title',
			'description',
			'supply',
			'url',
			'time',
			'endtime',
			'hidden',
			'answers',
			'views',
			'goods',
			'status',
			'ip',
			'search_words',
			'isdelete' 
	);
	
	/**
	 * 获取问题数据
	 * @param unknown_type $param
	 * @param unknown_type $limit
	 */
	function get_examine_list() {
		$list = $this->find ( array (
				'where' => 'isdelete=0',
				'desc' => 'id',
				'asArray' => TRUE 
		) );
		
		return $list;
	}
	
	function get_examine($id = "") {
	
		if (empty($id))
			return array();
		
		$list = $this->getOne ( array (
				'where' => " id=" . $id.' and isdelete=0' ,
				'asArray' => TRUE
		) );
		
		return $list;
	}
	
	/**
	 * 清空审批列表
	 */
	function examine_clear() {
		$sql = "delete from " . t_examine;
		
		Doo::db ()->query ( $sql );
	}
	
	function examine_delete($idKey){

		$this->id = $idKey;
		$this->isdelete = 1;
			
		$lid = $this->update ();
		
		return $lid;
	}
	
}

?>