children

SELECT * FROM config

SELECT sum(money+guanli) FROM `donation` where money>0

SELECT * FROM `save_num`

SELECT id,program,name FROM `children_children` where name='一个希望 月捐'

select   (case when money>0 then 'income' when money<0 then 'expenses' end )  budget, concat( '', ( CASE d.way WHEN 'alipay' THEN ( CASE WHEN d.money > 0 THEN  '支付宝捐入' WHEN d.money < 0 THEN '支付宝支出' ELSE NULL END ) WHEN 'postal'  THEN ( CASE WHEN d.money > 0 THEN '邮局汇捐入' WHEN d.money < 0 THEN  '邮局汇支出' ELSE NULL END ) WHEN 'cash' THEN ( CASE WHEN d.money > 0 THEN  '现金捐入' WHEN d.money < 0 THEN '现金支出' ELSE NULL END ) WHEN 'bank' THEN (  CASE WHEN d.money > 0 THEN '银行汇捐入' WHEN d.money < 0 THEN '银行汇支出'  ELSE NULL END ) WHEN 'ebank' THEN ( CASE WHEN d.money > 0 THEN '网银捐入' WHEN  d.money < 0 THEN '网银支出' ELSE NULL END ) WHEN 'wxpay' THEN ( CASE WHEN  d.money > 0 THEN '微信捐入' WHEN d.money < 0 THEN '微信支出' ELSE NULL END )  ELSE '其他' END ) )   as 'channel', count(d.way) as 'allCount', (case when round(sum(d.money),2) >=0  then concat('',round(sum(d.money),2)) else concat('',-round(sum(d.money),2)) end ) as 'allDesc', (case when round(sum(d.money),2) >=0  then round(sum(d.money*0.0001),2)  else -round(sum(d.money*0.0001),2) end)as 'allSum' from donation d WHERE  DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(FROM_UNIXTIME(d.recordeddate, '%Y%m%d%H%i%S')) and money!= 0  GROUP BY d.way, budget ORDER BY d.way DESC, budget asc 

SELECT t.donator_sex donator_sex, count(t.donator_sex) donator_sex_count, sum(d.money) donator_sex_sum FROM donation d LEFT JOIN wxpay_trade_record t ON d.donors = t.donator  AND d.recipient = t.child_name  and t.donator_sex in (1,2) 
	WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(FROM_UNIXTIME(d.recordeddate, '%Y%m%d%H%i%S'))   AND d.money > 0 and d.way='wxpay' GROUP BY t.donator_sex

select    (case when money>0 then 'income' when money<0 then 'expenses' end )  budget, concat( '', ( CASE d.way WHEN 'alipay' THEN ( CASE WHEN d.money > 0 THEN  '支付宝捐入' WHEN d.money < 0 THEN '支付宝支出' ELSE NULL END ) WHEN 'postal'  THEN ( CASE WHEN d.money > 0 THEN '邮局汇捐入' WHEN d.money < 0 THEN  '邮局汇支出' ELSE NULL END ) WHEN 'cash' THEN ( CASE WHEN d.money > 0 THEN  '现金捐入' WHEN d.money < 0 THEN '现金支出' ELSE NULL END ) WHEN 'bank' THEN (  CASE WHEN d.money > 0 THEN '银行汇捐入' WHEN d.money < 0 THEN '银行汇支出'  ELSE NULL END ) WHEN 'ebank' THEN ( CASE WHEN d.money > 0 THEN '网银捐入' WHEN  d.money < 0 THEN '网银支出' ELSE NULL END ) WHEN 'wxpay' THEN ( CASE WHEN  d.money > 0 THEN '微信捐入' WHEN d.money < 0 THEN '微信支出' ELSE NULL END )  ELSE '其他' END ) )   as 'channel', count(d.way) as 'allCount', (case when round(sum(d.money),2) >=0  then concat('',round(sum(d.money),2)) else concat('',-round(sum(d.money),2)) end ) as 'allDesc', (case when round(sum(d.money),2) >=0  then round(sum(d.money*0.0001),2)  else -round(sum(d.money*0.0001),2) end)as 'allSum' from donation d WHERE   DATE_SUB(date_add(NOW(), interval -1 month), INTERVAL 30 DAY) <= date(FROM_UNIXTIME(d.recordeddate, '%Y%m%d%H%i%S')) and date_add(NOW(), interval -1 month) > date(		FROM_UNIXTIME(			d.recordeddate,			'%Y%m%d%H%i%S'		)	) and money!= 0 GROUP BY d.way, budget ORDER BY d.way DESC, budget asc