/**
* getAgentByIncome 通过用户购买查询用户列表(包括累积购买和红包)
* @karl
* @DateTime 2016-08-01T13:23:44+0800
* @param array $where 查询条件
* @param integer $page_num 一页多少数据
* @param integer $url 分页url参数,为空是不带参数分页
* @return array 返回值
*/
static public function getUserByPay($where,$page_num,$url=[])
{
return $list = Db::table('pay_order')->alias('a')->join('user_weixin u','a.pay_uid = u.uid','left')->join('user s','s.uid = u.uid')->field('s.*,a.agent_uid,a.pay_uid,a.pay_time,a.agent_income,a.pay_money,a.red_packet,a.income_time,sum(a.pay_money) as sum_money,sum(a.red_packet) as sum_red_packet,u.nickname')->where($where)->group('a.pay_uid')->order('sum(a.pay_money) desc')->paginate($page_num, false , array('query'=>$url));
}
* getAgentByIncome 通过用户购买查询用户列表(包括累积购买和红包)
* @karl
* @DateTime 2016-08-01T13:23:44+0800
* @param array $where 查询条件
* @param integer $page_num 一页多少数据
* @param integer $url 分页url参数,为空是不带参数分页
* @return array 返回值
*/
static public function getUserByPay($where,$page_num,$url=[])
{
return $list = Db::table('pay_order')->alias('a')->join('user_weixin u','a.pay_uid = u.uid','left')->join('user s','s.uid = u.uid')->field('s.*,a.agent_uid,a.pay_uid,a.pay_time,a.agent_income,a.pay_money,a.red_packet,a.income_time,sum(a.pay_money) as sum_money,sum(a.red_packet) as sum_red_packet,u.nickname')->where($where)->group('a.pay_uid')->order('sum(a.pay_money) desc')->paginate($page_num, false , array('query'=>$url));
}