From 7261ee93908d61a2c714645f19501aee9a7aba7b Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 24 十一月 2023 17:35:51 +0800
Subject: [PATCH] --部门物品分发
---
consum-base/src/main/java/com/consum/base/service/LWhProcureModelUserServiceImpl.java | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhProcureModelUserServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhProcureModelUserServiceImpl.java
index d63a8c1..cb18897 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhProcureModelUserServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhProcureModelUserServiceImpl.java
@@ -1,6 +1,13 @@
package com.consum.base.service;
+import com.consum.base.core.utils.MapUtils;
+import com.consum.base.core.utils.MapperUtil;
+import com.consum.base.pojo.dto.UseRecordDTO;
+import com.google.common.collect.Lists;
import com.walker.jdbc.service.BaseServiceImpl;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
import org.springframework.stereotype.Service;
/**
@@ -12,4 +19,32 @@
@Service
public class LWhProcureModelUserServiceImpl extends BaseServiceImpl {
+ public List<UseRecordDTO> selectUseRecord(Long businessId) {
+ String sql = "SELECT\n"
+ + "\tpmur.ID,\n"
+ + "\tpm.ID procureModelId,\n"
+ + "\tpmur.DEAL_TIME updateTime,\n"
+ + "\tpmur.OPERATOR_NAME updateUserName,\n"
+ + "\tpm.BASE_GOODS_MODELS_ID,\n"
+ + "\tpm.BASE_GOODS_MODELS_NAME,\n"
+ + "\tbgm.UNIT,\n"
+ + "\tpmu.GOODS_NUM num,\n"
+ + "\tpmu.NOW_USER_NAME useName,\n"
+ + "\tpmu.NOW_USER_PHONE phone\n"
+ + "FROM\n"
+ + "\tl_wh_procure_model_user pmu\n"
+ + "\tINNER JOIN l_wh_procure_model_user_record pmur ON pmu.PROCURE_MODEL_USER_RECORD_ID = pmur.id\n"
+ + "\tINNER JOIN l_wh_procure_model pm ON pm.id = pmu.WH_PROCURE_MODEL_ID\n"
+ + "\tINNER JOIN base_goods_models bgm ON pm.BASE_GOODS_MODELS_ID = bgm.id\n"
+ + "\tWHERE pm.BUSINESS_ID =:id order by pmur.DEAL_TIME desc ";
+ Map<String, Object> procureModelId = new HashMap<>();
+ procureModelId.put("id", businessId);
+ List<Map<String, Object>> select = this.select(sql, procureModelId, new MapperUtil());
+ List<UseRecordDTO> useRecordDTOList = Lists.newArrayList();
+ select.forEach(item -> {
+ UseRecordDTO useRecordDto = MapUtils.convertMapToObj(item, UseRecordDTO.class);
+ useRecordDTOList.add(useRecordDto);
+ });
+ return useRecordDTOList;
+ }
}
--
Gitblit v1.9.1