From ce0fcdaf2629e5b6ebef0f206b16ecad103e5c1e Mon Sep 17 00:00:00 2001
From: lty <876263681@qq.com>
Date: 星期一, 05 五月 2025 14:39:06 +0800
Subject: [PATCH] #盘点上报
---
src/main/java/com/zy/asrs/service/impl/CheckDetlServiceImpl.java | 26 ++++++------
src/main/webapp/views/locDetlStatis/check.html | 5 ++
src/main/resources/mapper/LocDetlMapper.xml | 13 +++++-
src/main/webapp/static/js/locDetlStatis/check.js | 3 +
src/main/java/com/zy/asrs/task/kingdee/handler/LoginAuthenticationHandler.java | 6 +-
src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java | 3 +
src/main/resources/mapper/CheckDetlMapper.xml | 1
src/main/resources/application.yml | 21 ++++++++--
src/main/java/com/zy/asrs/entity/CheckDetl.java | 4 ++
9 files changed, 57 insertions(+), 25 deletions(-)
diff --git a/src/main/java/com/zy/asrs/entity/CheckDetl.java b/src/main/java/com/zy/asrs/entity/CheckDetl.java
index 369bad0..2b1fdb1 100644
--- a/src/main/java/com/zy/asrs/entity/CheckDetl.java
+++ b/src/main/java/com/zy/asrs/entity/CheckDetl.java
@@ -30,6 +30,10 @@
@ExcelProperty("鏁伴噺")
private Double anfme;
+ @ApiModelProperty(value= "鐩樼偣鏁伴噺")
+ @ExcelProperty("鐩樼偣鏁伴噺")
+ private Double number;
+
@ApiModelProperty(value= "鍟嗗搧缂栧彿")
@ExcelProperty("鍟嗗搧缂栧彿")
private String matnr;
diff --git a/src/main/java/com/zy/asrs/service/impl/CheckDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/CheckDetlServiceImpl.java
index 74680a8..b2e31d1 100644
--- a/src/main/java/com/zy/asrs/service/impl/CheckDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/CheckDetlServiceImpl.java
@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.asrs.entity.CheckDetl;
+import com.zy.asrs.entity.OrderDetl;
import com.zy.asrs.mapper.CheckDetlMapper;
import com.zy.asrs.service.ApiLogService;
import com.zy.asrs.service.CheckDetlService;
@@ -27,12 +28,11 @@
@Service
@Slf4j
public class CheckDetlServiceImpl extends ServiceImpl<CheckDetlMapper, CheckDetl> implements CheckDetlService {
- @Value("${erp.address.URL}")
+ @Value("${erp.newaddress.UPLOADURL}")
//绔彛
private String URL;
- @Value("${erp.address.outaddressSubmit}")
- //涓婃姤鍑哄叆搴撳湴鍧�
- private String outaddressSubmit;
+ @Value("${erp.newaddress.uploadaddressSubmit}")
+ private String uploadAddress;
@Autowired
private CheckDetlService checkDetlService;
@Autowired
@@ -47,18 +47,23 @@
public void upload(List<CheckDetl> list) {
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+
+
// 鏋勫缓涓诲崟 JSON 鏁版嵁
JSONObject requestBody = new JSONObject();
- requestBody.put("createTime", sdf.format(now));
+ if (!list.isEmpty()) {
+ CheckDetl first = list.get(0);
+ requestBody.put("orderNo", first.getOrderNo());
+ }
// 鏋勫缓鐗╂枡鍒楄〃
JSONArray matList = new JSONArray();
for(CheckDetl checkDetl : list) {
JSONObject mat = new JSONObject();
mat.put("detailId", checkDetl.getDetailId());
- mat.put("orderNo", checkDetl.getOrderNo());
mat.put("matnr", checkDetl.getMatnr());
mat.put("anfme", checkDetl.getAnfme());
+ mat.put("number", checkDetl.getNumber());
matList.add(mat);
}
requestBody.put("data", matList);
@@ -66,14 +71,9 @@
String response = "";
boolean success = false;
try {
- HashMap<String, Object> headers = new HashMap<>();
- // cookie
- headers.put("Cookie", loginAuthenticationHandler.start().getContent());
-
response = new HttpHandler.Builder()
- .setHeaders(headers)
.setUri(URL)
- .setPath(outaddressSubmit) // 璁剧疆浣犵殑鎺ュ彛璺緞
+ .setPath(uploadAddress) // 璁剧疆浣犵殑鎺ュ彛璺緞
.setJson(requestBody.toJSONString())
.build()
.doPost();
@@ -91,7 +91,7 @@
try {
apiLogService.save(
"鐩樼偣涓婃姤",
- URL + outaddressSubmit,
+ URL + uploadAddress,
null,
"127.0.0.1",
requestBody.toJSONString(),
diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
index 5cb108a..d0bba2e 100644
--- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
@@ -635,7 +635,8 @@
if (diff != 0) {
CheckDetl checkDetl = new CheckDetl();
checkDetl.setOrderNo(param.getOrderNo());
- checkDetl.setAnfme(diff); //杩欓噷璁板綍宸��
+ checkDetl.setAnfme(matParam.getAnfme()); //璐﹂潰鏁伴噺
+ checkDetl.setNumber(LKAnfme);
checkDetl.setMatnr(matParam.getMatnr());
checkDetl.setMaktx(matParam.getMaktx());
checkDetl.setSpecs(matParam.getSpecs());
diff --git a/src/main/java/com/zy/asrs/task/kingdee/handler/LoginAuthenticationHandler.java b/src/main/java/com/zy/asrs/task/kingdee/handler/LoginAuthenticationHandler.java
index 3530b48..e6bf092 100644
--- a/src/main/java/com/zy/asrs/task/kingdee/handler/LoginAuthenticationHandler.java
+++ b/src/main/java/com/zy/asrs/task/kingdee/handler/LoginAuthenticationHandler.java
@@ -33,15 +33,15 @@
//鐧诲綍鍦板潃
private String loginaddress;
- @Value("${erp.login.acctID}")
+ @Value("${erp.login.sAcctID}")
//璐﹀彿ID
private String acctID;
- @Value("${erp.login.username}")
+ @Value("${erp.login.sUserId}")
//璐﹀彿
private String username;
- @Value("${erp.login.password}")
+ @Value("${erp.login.sPassword}")
//瀵嗙爜
private String password;
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index e23b1b9..c2ed14c 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -94,9 +94,22 @@
outaddressSubmit: K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit.common.kdsvc
#缁撴灉涓婃姤锛堝鏍革級鍗曞湴鍧�
outaddressAudit: K3CLOUD/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit.common.kdsvc
+ # 鍦板潃
+ newaddress:
+ #鍗曟嵁涓婃姤鍦板潃
+ URL: http://10.10.0.59:33117
+ #鍗曟嵁鎻愪氦
+ orderaddressSubmit: api/U8Voucher
+ #鐩樼偣涓婃姤鍦板潃
+ UPLOADURL: http://10.10.0.10:2501
+ # 鐩樼偣鍦板潃
+ uploadaddressSubmit: api/CheckVouch/pypk
+
+
# 鐧诲綍璐﹀彿绠$悊
login :
- acctID: "647e849ab6fa0f"
- username: "llw"
- password: "666666"
- lcid: 2052
\ No newline at end of file
+ sAcctID: "999"
+ sUserId: "demo"
+ sPassword: "DEMO"
+ sServer: "10.1.9.20"
+ lcid: 1234
diff --git a/src/main/resources/mapper/CheckDetlMapper.xml b/src/main/resources/mapper/CheckDetlMapper.xml
index 2ba470f..e96d878 100644
--- a/src/main/resources/mapper/CheckDetlMapper.xml
+++ b/src/main/resources/mapper/CheckDetlMapper.xml
@@ -8,6 +8,7 @@
<!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
<resultMap id="BaseResultMap" type="com.zy.asrs.entity.CheckDetl">
<result column="anfme" property="anfme"/>
+ <result column="number" property="number"/>
<result column="matnr" property="matnr"/>
<result column="maktx" property="maktx"/>
<result column="specs" property="specs"/>
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 3db9eab..0856ec3 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -48,12 +48,14 @@
<resultMap id="CheckResultMap" type="com.zy.asrs.entity.CheckDetl">
<result column="anfme" property="anfme" />
+ <result column="number" property="number"/>
<result column="matnr" property="matnr" />
<result column="maktx" property="maktx" />
<result column="specs" property="specs" />
<result column="batch" property="batch" />
<result column="create_time" property="createTime"/>
<result column="order_no" property="orderNo"/>
+ <result column="detail_id" property="detailId"/>
</resultMap>
<sql id="batchSeq">
@@ -119,8 +121,11 @@
<if test="specs!=null and specs!='' ">
and a.specs like '%' + #{specs} + '%'
</if>
- <if test="order_no!=null and order_no!='' ">
- and a.order_no like '%' + #{order_no} + '%'
+ <if test="orderNo!=null and orderNo!='' ">
+ and a.order_no like '%' + #{orderNo} + '%'
+ </if>
+ <if test="detail_id!=null and detail_id!='' ">
+ and a.detail_id like '%' + #{detail_id} + '%'
</if>
</sql>
@@ -188,7 +193,9 @@
a.specs,
a.batch,
a.create_time,
- a.order_no
+ a.order_no,
+ a.detail_id,
+ a.number
from asr_check_detl a
where 1=1
<include refid="stockOutCondition" />
diff --git a/src/main/webapp/static/js/locDetlStatis/check.js b/src/main/webapp/static/js/locDetlStatis/check.js
index db84427..21c4b8d 100644
--- a/src/main/webapp/static/js/locDetlStatis/check.js
+++ b/src/main/webapp/static/js/locDetlStatis/check.js
@@ -21,7 +21,8 @@
cols: [[
{type: 'checkbox'},
{field: 'orderNo', align: 'center',title: '鐩樼偣鍗曠紪鍙�', style: 'font-weight: bold'},
- {field: 'anfme', align: 'center',title: '鐩樼偣鐩堜簭', style: 'font-weight: bold'},
+ {field: 'anfme', align: 'center',title: '璐﹂潰鏁伴噺', style: 'font-weight: bold'},
+ {field: 'number', align: 'center',title: '鐩樼偣鏁伴噺', style: 'font-weight: bold'},
{field: 'createTime$', align: 'center',title: '鍒涘缓鏃堕棿', style: 'font-weight: bold'},
{field: 'matnr', align: 'center',title: '鍟嗗搧缂栧彿', style: 'font-weight: bold'},
{field: 'maktx', align: 'center',title: '鍟嗗搧鍚嶇О', style: 'font-weight: bold'},
diff --git a/src/main/webapp/views/locDetlStatis/check.html b/src/main/webapp/views/locDetlStatis/check.html
index 0739a1f..c483aeb 100644
--- a/src/main/webapp/views/locDetlStatis/check.html
+++ b/src/main/webapp/views/locDetlStatis/check.html
@@ -19,6 +19,11 @@
<input class="layui-input" type="text" name="matnr" placeholder="鍟嗗搧缂栧彿" autocomplete="off">
</div>
</div>
+ <div class="layui-inline">
+ <div class="layui-input-inline">
+ <input class="layui-input" type="text" name="orderNo" placeholder="鐩樼偣缂栧彿" autocomplete="off">
+ </div>
+ </div>
<!-- 寰呮坊鍔� -->
<div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block">
<button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">鎼滅储
--
Gitblit v1.9.1