zjh 本地 2024/02/28 -1

zjh

2024-02-28 22c17adc3ec2a25e6656cd69961f49a888d433b3

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java

@@ -1,11 +1,13 @@
package com.ltkj.hosp.mapper;

import java.util.Date;
import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjFlowingWater;
import com.ltkj.hosp.domain.TjOrderDetail;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
@@ -81,4 +83,14 @@

    @Select("SELECT GROUP_CONCAT(a.pro_name ) proname FROM tj_charging_standard a WHERE a.tj_num=#{orderId}")
    String getproNameByOrderId(String orderId);


    @Select("\n" +
            "SELECT a.tj_serial_number FROM tj_flowing_water a " +
            "WHERE a.deleted=0 " +
            "AND a.toll_collector_id=#{userId}" +
            "AND ISNULL(a.is_checkout)" +
            "AND a.pay_stasus !=0 " +
            "AND a.update_time BETWEEN #{beginTime} AND #{endTime}")
    List<Long> getFlowingWaterIdList(@Param("userId") String userId,@Param("beginTime") Date beginTime,@Param("endTime") Date endTime);
}