优化上海接口-轮换计划上报

CZT

2023-10-30 d772a530c931502bdcf9c0fda5a81698ddc07d70

优化上海接口-轮换计划上报

 src/main/java/com/fzzy/api/view/repository/Api1101Rep.java

@@ -40,4 +40,12 @@
     */
    @Query("from Api1101 where kqdm =:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ")
    List<Api1101> getDataByTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end);

    /**
     * 单位信息
     * @param dwdm
     * @return
     */
    @Query("from Api1101 where dwdm =:dwdm ")
    List<Api1101> findDataByDwdm(@Param("dwdm") String dwdm);
}

 src/main/java/com/fzzy/push/sh2023/SH2023ApiRemoteService.java

@@ -43,6 +43,8 @@
    @Autowired
    private ApiLogRep apiLogRep;
    @Autowired
    private Api1101Rep api1101Rep;
    @Autowired
    private Api1102Rep api1102Rep;
    @Autowired
    private Api1104Rep api1104Rep;
@@ -706,8 +708,10 @@
            SH2023Api1403 api1403 = new SH2023Api1403();
            Api1403 apiData = (Api1403) data;
            BeanUtils.copyProperties(apiData, api1403);
            api1403.setJhzxdw(apiData.getJhxddw());
            api1403.setJhzxdwmc(apiData.getJhxddwmc());
            List<Api1101> api1101List = api1101Rep.findDataByDwdm(apiData.getLhjhdh().substring(0, 18));

            api1403.setJhzxdw(api1101List.get(0).getDwdm());
            api1403.setJhzxdwmc(api1101List.get(0).getDwmc());
            api1403.setBjw(ShAreaBjw.getBjw(code));

            //设置空属性为默认值