{"param1":"SELECT
	DATE_FORMAT(pfd.create_time,#formatStr#) createTime,
	pfc.config_id configId,
	pfc.fee_name feeName,
	SUM(pfd.receivable_amount) receivableAmounts,
	SUM(pfd.received_amount) receivedAmounts
FROM
	pay_fee pf,
	pay_fee_detail pfd,
	pay_fee_config pfc
WHERE
	pf.config_id = pfc.config_id
AND pf.fee_id = pfd.fee_id
and pf.community_id = #communityId#
AND pf.status_cd = '0'
AND pfc.status_cd = '0'
AND pfd.status_cd = '0'
GROUP BY
	DATE_FORMAT(pfd.create_time,#formatStr#),
	pfc.config_id,
	pfc.fee_name
ORDER BY
	DATE_FORMAT(pfd.create_time,#formatStr#) DESC
limit #page#,#row#",
"param2":"SELECT count(1) total from
  (SELECT
	DATE_FORMAT(pfd.create_time,#formatStr#) createTime,
	pfc.config_id configId,
	pfc.fee_name feeName,
	SUM(pfd.receivable_amount) receivableAmounts,
	SUM(pfd.received_amount) receivedAmounts
FROM
	pay_fee pf,
	pay_fee_detail pfd,
	pay_fee_config pfc
WHERE
	pf.config_id = pfc.config_id
AND pf.fee_id = pfd.fee_id
AND pf.status_cd = '0'
AND pfc.status_cd = '0'
AND pfd.status_cd = '0'
and pf.community_id = #communityId#
GROUP BY
	DATE_FORMAT(pfd.create_time,#formatStr#),
	pfc.config_id,
	pfc.fee_name) t"
}