<?php
class commissiontx_m extends Model
{
	function __construct()
	{
		parent::Model();
	}

	function commissiontx_m()
	{
		$this->__construct();
	}

	function get_list($uid,$offset=0,$psize=30)
	{
		$sql = "SELECT * FROM ".$this->db->prefix."commissiontx WHERE uid='".$uid."' ORDER BY postdate DESC,id DESC LIMIT ".$offset.",".$psize;
		return $this->db->get_all($sql);
	}
	function get_count($uid)
	{
		$sql = "SELECT count(id) total FROM ".$this->db->prefix."commissiontx WHERE uid='".$uid."' ";
		return $this->db->count($sql);
	}
	function get_count_cur($uid,$status=0)
	{
		$sql = "SELECT sum(money) total FROM ".$this->db->prefix."commissiontx WHERE uid='".$uid."' and status='".$status."' ";
		return $this->db->count($sql);
	}
	function savetx($data)
	{
		if(!$data || !is_array($data))
		{
			return false;
		}
		return $this->db->insert_array($data,"commissiontx");
	}
}
?>