wenda-php/protected/model/EmailconfigDao.php

<?php

class EmailconfigDao {
	
	public $eid;
	
	public $uid;
	
	public $action_id;
	
	public $action_name;
	
	public $_table = t_emailconfig;
	
	public $_primarykey = "aid";
	
	public $_fields = array ('aid', 'title', 'content', 'time' );
	
	/**
	 * 获取莫用户的email配置
	 * @param unknown_type $uid
	 */
	function get_emailconfig_by_uid($uid = 0) {
		$sql = "select action_id from " . $this->_table . " where uid=" . $uid;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}
	
	/**
	 * 删除配置
	 * @param unknown_type $uid
	 */
	function delete_emailconfig_by_uid($uid = 0) {
		$sql = "delete from " . $this->_table . " where uid = " . $uid;
		
		Doo::db ()->query ( $sql );
	}
	
	/**
	 * 添加配置Email
	 * @param unknown_type $normal
	 */
	function add_emailconfig($var = "") {
		if(empty($var))
			return ;
			
		$sql = "insert " . $this->_table . " (uid,action_id) values " . $var;
		
		Doo::db ()->query ( $sql );
	}
}

?>