SELECT bs.*, us.real_name as channel_name FROM bcx_settle bs LEFT JOIN eb_user us ON us.id = bs.belong_id SELECT bs.*, bd.`name` as department_name FROM bcx_settle bs LEFT JOIN bcx_department bd ON bd.id = bs.belong_id SELECT bs.*, bdm.`name` as department_member_name, bd.`name` as department_name FROM bcx_settle bs LEFT JOIN bcx_department_member bdm ON bdm.id = bs.belong_id LEFT JOIN bcx_department bd ON bd.id = bdm.department_id SELECT bs.*, fxs.real_name as brokerage_user_real_name, fxs.real_name as brokerage_user_org FROM bcx_settle bs LEFT JOIN eb_user fxs ON fxs.id = bs.belong_id SELECT bs.*, fxy.real_name as brokerage_user_real_name, fxs.real_name as brokerage_user_org FROM bcx_settle bs LEFT JOIN eb_user fxy ON fxy.id = bs.belong_id LEFT JOIN eb_user fxs ON fxy.spread_uid = fxs.id SELECT COUNT(*) as total_count, SUM(bs.total_price) as total_pay_price, SUM(bs.brokerage_total_price) as total_brokerage_price FROM bcx_settle bs LEFT JOIN eb_user us ON us.id = bs.belong_id SELECT COUNT(*) as total_count, SUM(bs.total_price) as total_pay_price, SUM(bs.brokerage_total_price) as total_brokerage_price FROM bcx_settle bs LEFT JOIN bcx_department bd ON bd.id = bs.belong_id SELECT COUNT(*) as total_count, SUM(bs.total_price) as total_pay_price, SUM(bs.brokerage_total_price) as total_brokerage_price FROM bcx_settle bs LEFT JOIN bcx_department_member bdm ON bdm.id = bs.belong_id LEFT JOIN bcx_department bd ON bd.id = bdm.department_id SELECT COUNT(*) as total_count, SUM(bs.total_price) as total_pay_price, SUM(bs.brokerage_total_price) as total_brokerage_price FROM bcx_settle bs LEFT JOIN eb_user fxs ON fxs.id = bs.belong_id SELECT COUNT(*) as total_count, SUM(bs.total_price) as total_pay_price, SUM(bs.brokerage_total_price) as total_brokerage_price FROM bcx_settle bs LEFT JOIN eb_user fxy ON fxy.id = bs.belong_id LEFT JOIN eb_user fxs ON fxy.spread_uid = fxs.id and bs.belong_type = 1 and us.real_name like CONCAT('%', #{name}, '%') and bs.belong_id = #{userId} and bs.settle_status = #{settleStatus} and bs.upload_attachments = #{uploadAttachments} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bs.settle_no like CONCAT('%', #{settleNo}, '%') = #{settleTimeStart,jdbcType=TIMESTAMP} ]]> and bs.belong_type = 2 and bd.`name` like CONCAT('%', #{name}, '%') and bs.belong_id = #{departmentId} and bs.settle_status = #{settleStatus} and bs.upload_attachments = #{uploadAttachments} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bs.settle_no like CONCAT('%', #{settleNo}, '%') = #{settleTimeStart,jdbcType=TIMESTAMP} ]]> and bs.belong_type = 3 and bdm.`name` like CONCAT('%', #{name}, '%') and bdm.department_id = #{departmentId} and bs.belong_id = #{departmentMemberId} and bs.settle_status = #{settleStatus} and bs.upload_attachments = #{uploadAttachments} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bs.settle_no like CONCAT('%', #{settleNo}, '%') = #{settleTimeStart,jdbcType=TIMESTAMP} ]]> and bs.belong_type = 4 and fxs.real_name like CONCAT('%', #{name}, '%') and bs.belong_id = #{userId} and bs.settle_status = #{settleStatus} and bs.upload_attachments = #{uploadAttachments} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bs.settle_no like CONCAT('%', #{settleNo}, '%') = #{settleTimeStart,jdbcType=TIMESTAMP} ]]> and bs.belong_type = 5 and fxy.real_name like CONCAT('%', #{name}, '%') and bs.belong_id = #{userId} and bs.settle_status = #{settleStatus} and bs.upload_attachments = #{uploadAttachments} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bs.settle_no like CONCAT('%', #{settleNo}, '%') = #{settleTimeStart,jdbcType=TIMESTAMP} ]]>