fix ： 查询出场接口修改

kongdeqiang

2025-02-24 7ab1fcfdd4facfdafac50dc06804408e4559dba7

fix ： 查询出场接口修改

 src/main/java/com/boying/controller/OutParkController.java

@@ -59,7 +59,7 @@
    public Object findPage(Page page, String  carNo,Long parkId,String  payCode,Integer status,String date) throws ParseException {
        List<OutPark> list = outParkService.getList(page.getCurrent(), page.getSize(), carNo,parkId,payCode,status, date);
        System.out.println(list);
        long count = outParkService.getCount(carNo,parkId,payCode, date);
        long count = outParkService.getCount(carNo,parkId,payCode,status, date);
        for (OutPark record : list) {
            record.setParkName(parkService.getById(record.getParkId()).getName());
            if(record.getEnterTime() != null){

 src/main/java/com/boying/mapper/OutParkMapper.java

@@ -20,7 +20,7 @@

    List<OutPark> getList(@Param("current")long current, @Param("size")long size, @Param("carNo")String carNo, @Param("parkId")Long parkId, @Param("payCode")String payCode,@Param("status")Integer status, @Param("date")String date);

    long getCount(@Param("carNo")String carNo, @Param("parkId")Long parkId, @Param("payCode")String payCode, @Param("date")String date);
    long getCount(@Param("carNo")String carNo, @Param("parkId")Long parkId, @Param("payCode")String payCode,@Param("status")Integer status, @Param("date")String date);

    List<OutParkVo> getVoList(@Param("parkId")Integer parkId,@Param("startDate")String startDate,@Param("endDate")String endDate);


 src/main/java/com/boying/service/OutParkService.java

@@ -20,7 +20,7 @@
public interface OutParkService extends IService<OutPark> {
    List<OutPark> getList(long current, long size, String carNo, Long parkId, String payCode,Integer status, String date);

    long getCount(String carNo, Long parkId, String payCode, String date);
    long getCount(String carNo, Long parkId, String payCode,Integer status, String date);


    int count1();

 src/main/java/com/boying/service/impl/OutParkServiceImpl.java

@@ -278,7 +278,7 @@
    }

    @Override
    public long getCount(String carNo, Long parkId, String payCode, String date) {
        return outParkMapper.getCount(carNo,parkId,payCode,date);
    public long getCount(String carNo, Long parkId, String payCode,Integer status, String date) {
        return outParkMapper.getCount(carNo,parkId,payCode,status,date);
    }
}

 src/main/resources/mapper/OutParkMapper.xml

@@ -39,6 +39,9 @@
                <if test="parkId != null and parkId != ''">
                      and park_id = #{parkId}
                </if>
                <if test="status != null and status != ''">
                      and status = #{status}
                </if>
                <if test="date != null and date != ''">
                      and DATE_FORMAT(create_time,'%Y-%m-%d') &gt;= DATE_FORMAT(#{date},'%Y-%m-%d')
                      and DATE_FORMAT(create_time,'%Y-%m-%d') &lt;= DATE_FORMAT(#{date},'%Y-%m-%d')
@@ -60,6 +63,9 @@
                  <if test="parkId != null and parkId != ''">
                        and park_id = #{parkId}
                  </if>
                  <if test="status != null and status != ''">
                        and status = #{status}
                  </if>
                  <if test="date != null and date != ''">
                        and DATE_FORMAT(create_time,'%Y-%m-%d') &gt;= DATE_FORMAT(#{date},'%Y-%m-%d')
                        and DATE_FORMAT(create_time,'%Y-%m-%d') &lt;= DATE_FORMAT(#{date},'%Y-%m-%d')