8月 02

对账sql 

SELECT  DATE_FORMAT(AddDate,'%Y-%m-%d') ,SUM(Amount) FROM  tb_order WHERE IsConfirm=1 AND  IsPay=1 GROUP BY   DATE_FORMAT(AddDate,'%Y-%m-%d')

提现sql

SELECT  DATE_FORMAT(AddDate,'%Y-%m-%d') ,SUM(totalamount) FROM  tb_bill    GROUP BY   DATE_FORMAT(AddDate,'%Y-%m-%d');

安装

vc2012 + ImageMagick-7.0.3-1-Q8-x64-dll + GraphicsMagick-1.3.24-Q8-win64-dll

written by ocean \\ tags: