wenda-php/protected/model/CreditDao.php

<?php

class CreditDao {
	
	public $uid;
	
	public $time;
	
	public $operation;
	
	public $credit1;
	
	public $credit2;
	
	public $credit3;
	
	public $_table = 'zhask_credit';
	
	public $_primarykey = "";
	
	public $_fields = array ('uid', 'time', 'operation', 'credit1', 'credit2', 'credit3' );
	
	/**
	 * 删除用户日常积分记录
	 * @param unknown_type $uid
	 */
	function delete_credit_by_uid($uid = 0) {
		
		$sql = "delete from " . t_credit . " where uid = " . $uid;
		
		Doo::db ()->query ( $sql );
	}
	
	/**
	 * 积分，财富值日常记录功能
	 * @param unknown_type $uid
	 * @param unknown_type $action_type
	 * @param unknown_type $credit1
	 * @param unknown_type $credit2
	 * @param unknown_type $credit3
	 */
	public function set_credit_log($uid = 0, $action_type = "", $credit1 = 0, $credit2 = 0, $credit3 = 0) {
		//记录日常操作
		$sql = "INSERT INTO " . t_credit . "(uid,time,operation,credit1,credit2,credit3) VALUES (" . $uid . "," . get_date () . ",'" . $action_type . "'," . $credit1 . "," . $credit2 . "," . $credit3 . ")";
		
		$query = Doo::db ()->query ( $sql );
	}
	
	/**
	 * 获取某个用户的积分，财富操作信息
	 * @param unknown_type $uid
	 */
	public function get_credit_info_by_uid($uid = 0) {
		
		$sql = "select * from " . t_credit . " where uid = " . $uid;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}

}

?>