wenda-php/protected/model/GroupDao.php

<?php

class GroupDao {
	
	public $groupid;
	
	public $grouptitle;
	
	public $grouptype;
	
	public $creditslower;
	
	public $creditshigher;
	
	public $regulars;
	
	public $quesionlimits;
	
	public $answerlimits;
	
	public $_table = t_usergroup;
	
	public $_primarykey = "groupid";
	
	public $_fields = array ('groupid', 'grouptitle', 'grouptype', 'creditslower', 'creditshigher', 'regulars', 'quesionlimits', 'answerlimits');
	
	/**
	 * 批量更新用户组
	 */
	function update_group_list($params="",$content="",$wh=""){
		
		$sql = "INSERT INTO " . t_usergroup." (".$params.") VALUES ".$content." ON DUPLICATE KEY UPDATE ".$wh;
	
		$query = Doo::db ()->query ( $sql );
	}
	
	/**
	 * 获取用户组
	 */
	public function get_group() {
		$sql = "SELECT * FROM  " . t_usergroup;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}

	/**
	 * 获取用户组
	 */
	public function get_group_by_id($id=0) {
		$sql = "SELECT * FROM  " . t_usergroup." where groupid=".$id;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetch ();
		
		return $result;
	}

}

?>