SELECT bsb.*, us.real_name as channel_name FROM bcx_settle_bill bsb LEFT JOIN eb_user us ON us.id = bsb.belong_id order by bsb.id desc SELECT bsb.*, bd.`name` as department_name FROM bcx_settle_bill bsb LEFT JOIN bcx_department bd ON bd.id = bsb.belong_id order by bsb.id desc SELECT bsb.*, bdm.`name` as department_member_name, bd.`name` as department_name FROM bcx_settle_bill bsb LEFT JOIN bcx_department_member bdm ON bdm.id = bsb.belong_id LEFT JOIN bcx_department bd ON bd.id = bdm.department_id order by bsb.id desc SELECT bsb.*, fxs.real_name as brokerage_user_real_name, fxs.real_name as brokerage_user_org FROM bcx_settle_bill bsb LEFT JOIN eb_user fxs ON fxs.id = bsb.belong_id order by bsb.id desc SELECT bsb.*, fxy.real_name as brokerage_user_real_name, fxs.real_name as brokerage_user_org FROM bcx_settle_bill bsb LEFT JOIN eb_user fxy ON fxy.id = bsb.belong_id LEFT JOIN eb_user fxs ON fxy.spread_uid = fxs.id order by bsb.id desc SELECT bsb.*, us.real_name as brokerage_user_real_name FROM bcx_settle_bill bsb LEFT JOIN eb_user us ON us.id = bsb.belong_id order by bsb.id desc SELECT COUNT(*) as total_count, SUM(bsb.order_count) as total_order_count, SUM(bsb.order_total_price) as total_pay_price, SUM(bsb.brokerage_total_price) as total_brokerage_price FROM bcx_settle_bill bsb LEFT JOIN eb_user us ON us.id = bsb.belong_id order by bsb.id desc SELECT COUNT(*) as total_count, SUM(bsb.order_count) as total_order_count, SUM(bsb.order_total_price) as total_pay_price, SUM(bsb.brokerage_total_price) as total_brokerage_price FROM bcx_settle_bill bsb LEFT JOIN bcx_department bd ON bd.id = bsb.belong_id order by bsb.id desc SELECT COUNT(*) as total_count, SUM(bsb.order_count) as total_order_count, SUM(bsb.order_total_price) as total_pay_price, SUM(bsb.brokerage_total_price) as total_brokerage_price FROM bcx_settle_bill bsb LEFT JOIN bcx_department_member bdm ON bdm.id = bsb.belong_id LEFT JOIN bcx_department bd ON bd.id = bdm.department_id order by bsb.id desc SELECT COUNT(*) as total_count, SUM(bsb.order_count) as total_order_count, SUM(bsb.order_total_price) as total_pay_price, SUM(bsb.brokerage_total_price) as total_brokerage_price FROM bcx_settle_bill bsb LEFT JOIN eb_user fxs ON fxs.id = bsb.belong_id order by bsb.id desc SELECT COUNT(*) as total_count, SUM(bsb.order_count) as total_order_count, SUM(bsb.order_total_price) as total_pay_price, SUM(bsb.brokerage_total_price) as total_brokerage_price FROM bcx_settle_bill bsb LEFT JOIN eb_user fxy ON fxy.id = bsb.belong_id LEFT JOIN eb_user fxs ON fxy.spread_uid = fxs.id order by bsb.id desc SELECT COUNT(*) as total_count, SUM(bsb.order_count) as total_order_count, SUM(bsb.order_total_price) as total_pay_price, SUM(bsb.brokerage_total_price) as total_brokerage_price FROM bcx_settle_bill bsb LEFT JOIN eb_user us ON us.id = bsb.belong_id order by bsb.id desc and bsb.belong_type = 1 and us.real_name like CONCAT('%', #{name}, '%') and bsb.belong_id = #{userId} and bsb.settle_status = #{settleStatus} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bsb.belong_type = 2 and bd.`name` like CONCAT('%', #{name}, '%') and bsb.belong_id = #{departmentId} and bsb.settle_status = #{settleStatus} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bsb.belong_type = 3 and bdm.`name` like CONCAT('%', #{name}, '%') and bdm.department_id = #{departmentId} and bsb.belong_id = #{departmentMemberId} and bsb.settle_status = #{settleStatus} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bsb.belong_type = 4 and fxs.real_name like CONCAT('%', #{name}, '%') and bsb.belong_id = #{userId} and bsb.settle_status = #{settleStatus} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bsb.belong_type = 5 and fxy.real_name like CONCAT('%', #{name}, '%') and bsb.belong_id = #{userId} and fxy.spread_uid = #{spreadUid} and bsb.settle_status = #{settleStatus} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]> and bsb.belong_type in (1, 4, 5) and us.real_name like CONCAT('%', #{name}, '%') and bsb.belong_id = #{userId} and bsb.settle_status = #{settleStatus} = #{billPeriodStart,jdbcType=TIMESTAMP} ]]>