优化上海接口-性质转变加入计划明细单号

CZT

2024-01-09 f646df3f4fa190bb2fac0d9c752880b16c636dd3

优化上海接口-性质转变加入计划明细单号

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

@@ -44,4 +44,12 @@

    @Query("from Api1202 where rkjsdh=:rkjsdh ")
    List<Api1202> getDataByRkjsdh(@Param("rkjsdh") String rkjsdh);

    /**
     * 根据货位代码和业务日期，倒序查询
     * @param hwdm
     * @return
     */
    @Query("from Api1202 where hwdm=:hwdm and ywrq <=:keyTime order by ywrq desc")
    List<Api1202> getDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("keyTime") Date keyTime);
}

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

@@ -42,4 +42,12 @@
     */
    @Query("from Api1205 where ckjsdh =:ckjsdh")
    List<Api1205> getDataByCkjsdh(@Param("ckjsdh") String ckjsdh);

    /**
     * 根据货位代码和业务日期，正序查询
     * @param hwdm
     * @return
     */
    @Query("from Api1205 where hwdm=:hwdm and ywrq >=:keyTime order by ywrq asc ")
    List<Api1205> getDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("keyTime") Date keyTime);
}

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

@@ -659,6 +659,22 @@
                api1210.setPch(apiData.getHwdm() + api1208List.get(0).getShnd());
            }

            //设置计划明细号，根据划转性质查询出入库信息获取计划号
            if("200".equals(api1210.getHzqlsxzdm())){
                //若划转前性质为商品粮，则查询入库信息获取计划明细号
                List<Api1202> api1202List = api1202Rep.getDataByHwdmAndTime(api1210.getHwdm(), api1210.getHzrq());
                if (null != api1202List && api1202List.size() > 0) {
                    api1210.setJhmxdh(api1202List.get(0).getJhmxh());
                }
            }
            if("200".equals(api1210.getHzhlsxzdm())){
                //若划转后性质为商品粮，则查询出库信息获取计划明细号
                List<Api1205> api1205List = api1205Rep.getDataByHwdmAndTime(api1210.getHwdm(), api1210.getHzrq());
                if (null != api1205List && api1205List.size() > 0) {
                    api1210.setJhmxdh(api1205List.get(0).getJhmxh());
                }
            }

            //设置空属性为默认值
            changeObject(api1210);
            return api1210;