Mybatis中and和循环or混用操作(or转换成in)

 List selectOrdersByStatesSelective( @Param(value="order")Order order, @Param(value="states")Integer[] states);

  select  from order_list LEFT JOIN product_method ON product_method.`code` = order_list.purchase_method LEFT JOIN product_color ON product_color.`code` = order_list.color LEFT JOIN product_guarantee ON product_guarantee.`code` = order_list.guarantee LEFT JOIN product_info ON order_list.product_id = product_info.id LEFT JOIN product_model ON product_info.model = product_model.`code` LEFT JOIN product_standard ON product_info.standard = product_standard.`code` LEFT JOIN product_state ON product_state.`code` = order_list.order_state LEFT JOIN product_apperance ON product_apperance.`code` = order_list.apperance LEFT JOIN product_brand ON product_brand.`code` = product_info.brand   order_num like "%"#{order.orderNum,jdbcType=VARCHAR}"%"  and operator like "%"#{order.operator,jdbcType=VARCHAR}"%"  and purchase_time = #{order.purchaseTime,jdbcType=DATE}  and order_state = #{order.orderState,jdbcType=VARCHAR}  and serial_num like "%"#{order.serialNum,jdbcType=VARCHAR}"%"   #{state,jdbcType=BIGINT} 

   #{state,jdbcType=BIGINT} 

 SELECT  * FROM somc_operation_plan WHERE ( title LIKE '%测试%' AND ( charge_user = 'xxx' OR execute_user = 'xxx' ) )

 LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.like(StringUtils.isNotEmpty(operationPlan.getTitle()), SomcOperationPlan::getTitle, operationPlan.getTitle()) .and(wrapper -> wrapper.eq(StringUtils.isNotEmpty(operationPlan.getChargeUser()), SomcOperationPlan::getChargeUser, operationPlan.getChargeUser()).or().eq(StringUtils.isNotEmpty(operationPlan.getExecuteUser()), SomcOperationPlan::getExecuteUser, operationPlan.getExecuteUser()));