自己客户的消费记录 以及增加的客户 按月份 排序

这是文件链接 有兴趣的可以下载下来

SELECT DATE_FORMAT(FROM_UNIXTIME(a.inputtime),"%m") mon, DATE_FORMAT(FROM_UNIXTIME(a.inputtime),"%Y-%m") month,COUNT(a.uid) count_uid, ifnull(b.prices,0) sum_price
FROM imt_member_paylog a 
LEFT JOIN ( 
             SELECT d.tuijianren, DATE_FORMAT(FROM_UNIXTIME(c.inputtime),"%m") mon, SUM(c.value) prices
             FROM imt_member_paylog c
             LEFT JOIN imt_member d ON d.uid = c.uid
             WHERE d.tuijianren = 13
             GROUP BY DATE_FORMAT(FROM_UNIXTIME(c.inputtime),"%m")
) b ON b.tuijianren = a.uid AND b.mon = DATE_FORMAT(FROM_UNIXTIME(a.inputtime),"%m")
WHERE a.status = 1 AND a.uid = 13
GROUP BY DATE_FORMAT(FROM_UNIXTIME(a.inputtime),"%m")

这边是当前用户下的客户的消费总金额和客户总数

{php $sql= 'SELECT COUNT(a.uid) count_uid, IFNULL(b.prices,0) sum_price FROM imt_member_paylog a LEFT JOIN (SELECT d.tuijianren, SUM(c.value) prices
          FROM imt_member_paylog c LEFT JOIN imt_member d ON d.uid = c.uid WHERE d.tuijianren = '.$member.uid.') b ON b.tuijianren = a.uid WHERE a.status=1 AND a.uid= '.$member.uid ;$result= $ci->db->query($sql)->row_array();}

下面是 : html 代码

<tr>
					   	<td class="order-num" style="width: 400px;text-align: center;">{$result.count_uid}个客户</td>
						<td class="pay-money" style="width: 400px;text-align: center;">{$result.sum_price}元</td>
					</tr>

本文章只是自己做项目的总结 一些有用的代码 就留了下来 和大家分享 承蒙！