{"param1":"SELECT uu.`name` userName,uu.`user_id` userId,SUM(bpfd.`receivable_amount`) receivableAmount,SUM(bpfd.`received_amount`) receivedAmount
 FROM c_orders co,c_business cb,pay_fee_detail bpfd,u_user uu,s_store_user su,pay_fee pf
WHERE co.`o_id` = cb.`o_id`
AND cb.`b_id` = bpfd.`b_id`
and bpfd.fee_id = pf.fee_id
and pf.status_cd = '0'
AND co.`user_id` = uu.`user_id`
AND uu.`user_id` = su.`user_id`
<if test=\"storeId !=null and storeId !=''\">
and su.`store_id` = #storeId#
</if>
<if test=\"userCode !=null and userCode !=''\">
and uu.`user_id` = #userCode#
</if>
<if test=\"startTime!=null \">
AND co.`create_time` &gt;= #startTime#
</if>
<if test=\"endTime !=null \">
AND co.`create_time` &lt;= #endTime#
</if>
<if test=\"communityId !=null and communityId !=''\">
and bpfd.`community_id` = #communityId#
</if>
group by uu.`name`,uu.`user_id`
limit #page#,#row#",
"param2":"select count(1) total from (SELECT uu.`name`,uu.`user_id`
 FROM c_orders co,c_business cb,pay_fee_detail bpfd,u_user uu,s_store_user su,pay_fee pf
WHERE co.`o_id` = cb.`o_id`
AND cb.`b_id` = bpfd.`b_id`
and bpfd.fee_id = pf.fee_id
and pf.status_cd = '0'
AND co.`user_id` = uu.`user_id`
AND uu.`user_id` = su.`user_id`
<if test=\"storeId !=null and storeId !=''\">
and su.`store_id` = #storeId#
</if>
<if test=\"userCode !=null and userCode !=''\">
and uu.`user_id` = #userCode#
</if>
<if test=\"startTime!=null \">
AND co.`create_time` &gt;= #startTime#
</if>
<if test=\"endTime !=null \">
AND co.`create_time` &lt;= #endTime#
</if>
<if test=\"communityId !=null and communityId !=''\">
and bpfd.`community_id` = #communityId#
</if>
group by uu.`name`,uu.`user_id`) t"
}