<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.catl.swap.service.manager.dao.CarRbcOrderLogDao"><selectid="findByPage"parameterType="com.catl.swap.manager.vo.CarRbcOrderLogVO"resultType="com.catl.swap.manager.vo.CarRbcOrderLogVO">
select l.*,u.username as createUsername from log_car_rbc_order l left join sys_user u on l.create_user_id = u.id
where 1=1
<iftest="crRbcOrderLogVO.batterySn !=null and crRbcOrderLogVO.batterySn !=''">
and l.battery_sn like CONCAT('%', #{crRbcOrderLogVO.batterySn}, '%')
</if><iftest="crRbcOrderLogVO.batteryBin !=null and crRbcOrderLogVO.batteryBin !=''">
and l.battery_bin like CONCAT('%', #{crRbcOrderLogVO.batteryBin}, '%')
</if><iftest="crRbcOrderLogVO.batteryLevel !=null and crRbcOrderLogVO.batteryLevel !=''">
and l.battery_level like CONCAT('%', #{crRbcOrderLogVO.batteryLevel}, '%')
</if><iftest="crRbcOrderLogVO.batterySoc !=null and crRbcOrderLogVO.batterySoc !=''">
and l.battery_soc like CONCAT('%', #{crRbcOrderLogVO.batterySoc}, '%')
</if><iftest="startTime != null and startTime !='' or endTime != null and endTime !=''">
and l.create_time between STR_TO_DATE(#{startTime}, '%Y-%m-%d %H:%i:%s') and STR_TO_DATE(#{endTime}, '%Y-%m-%d %H:%i:%s')
</if></select></mapper>