AND INSTR(s.source_no,#{sourceNo}) and s.source_type = #{sourceType} AND INSTR(s.writer,#{writer}) AND INSTR(s.product_info,#{productInfo}) and s.category_id = #{categoryId} and s.receiver_id = #{receiverId} and s.source_time >= #{sourceTimeStart} and s.source_time #{sourceTimeEnd} and a.write_time >= #{fapiaoTimeStart} and a.write_time #{fapiaoTimeEnd} and IFNULL(a.fapiao_status,0) = #{fapiaoStatus} AND INSTR(a.apply_no,#{applyNo}) AND INSTR(a.fapiao_no,#{fapiaoNo}) select s.* ,c.name as categoryName,a.fapiao_no,a.fapiao_amount,a.write_time,a.fapiao_status,a.fapiao_type from bcx_fapiao_source s left join bcx_fapiao_apply a on s.apply_no = a.apply_no left join eb_product_category c on c.id = s.category_id 1=1 order by s.source_time desc select count(1) as totalCount, sum(s.amount) as totalPrice from bcx_fapiao_source s left join bcx_fapiao_apply a on s.apply_no = a.apply_no 1=1