{"param1":"select py.fee_id feeId, 
ci.inout_id inoutId,
ci.car_num carNum,
cb.o_id oId,
pfd.receivable_amount receivableAmount,
pfd.received_amount receivedAmount,
DATE_FORMAT(py.start_time,'%Y-%m-%d %H:%i:%s')  startTime,
DATE_FORMAT(py.end_time,'%Y-%m-%d %H:%i:%s') endTime,
'微信支付' userName,
DATE_FORMAT(cb.create_time,'%Y-%m-%d %H:%i:%s') payTime
from pay_fee py,pay_fee_detail pfd,car_inout ci,c_business cb
where py.payer_obj_id = ci.inout_id
and py.fee_id = pfd.fee_id
and py.fee_flag = '2006012'
and py.state = '2009001'
and py.b_id = cb.b_id
<if test=\"startTime!=null \">
AND pfd.`create_time` &gt;= #startTime#
</if>
<if test=\"endTime !=null \">
AND pfd.`create_time` &lt;= #endTime#
</if>
<if test=\"carNum !=null and carNum != '' \">
AND ci.car_num = #carNum#
</if>
<if test=\"communityId !=null and communityId !=''\">
and pfd.`community_id` = #communityId#
</if>
order by pfd.create_time desc
limit #page#,#row#",
"param2":"SELECT count(1) total
  from pay_fee py,pay_fee_detail pfd,car_inout ci,c_business cb
where py.payer_obj_id = ci.inout_id
and py.fee_id = pfd.fee_id
and py.fee_flag = '2006012'
and py.state = '2009001'
and py.b_id = cb.b_id
<if test=\"startTime!=null \">
AND pfd.`create_time` &gt;= #startTime#
</if>
<if test=\"endTime !=null \">
AND pfd.`create_time` &lt;= #endTime#
</if>
<if test=\"carNum !=null and carNum != '' \">
AND ci.car_num = #carNum#
</if>
<if test=\"communityId !=null and communityId !=''\">
and pfd.`community_id` = #communityId#
</if>"
}