From 4f27bf5e5e32bd83fcff463f85024a80d96a59f5 Mon Sep 17 00:00:00 2001
From: 秦芳睿 <1425609123@qq.com>
Date: 星期二, 22 四月 2025 17:01:46 +0800
Subject: [PATCH] feat/java_ai: 添加修改工单内容功能
---
JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/javaai/jsonflow/node/SMTJsonFlowNodeScript.java | 3
JAVA/SMTAIServer/src/main/resources/requestmap/java_ai.json | 45 +++++++++++++++
JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java | 126 ++++++++++++++++++++++++++++++++++++++++++
3 files changed, 173 insertions(+), 1 deletions(-)
diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java
index 927fa73..1261234 100644
--- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java
+++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTJavaAIControl.java
@@ -412,6 +412,132 @@
return tranReq.returnJsonState(true, null, null);
}
+ public ModelAndView updateOrder(SMTAIServerRequest tranReq) throws Exception {
+ String title = tranReq.convParamToString("title", true);
+ String orderId = tranReq.convParamToString("orderId", true);
+ String wstypeid = tranReq.convParamToString("wstypeid", false);
+ String wstypename = tranReq.convParamToString("wstypename", false);
+ String urgencylevel = tranReq.convParamToString("urgencylevel", false);
+ String shape = tranReq.convParamToString("shape", false);
+ String deadline = tranReq.convParamToString("deadline", false);
+ String stepstatus = tranReq.convParamToString("stepstatus", false);
+ String originatetypetext = tranReq.convParamToString("originatetypetext", false);
+ String content = tranReq.convParamToString("content", false);
+ String address = tranReq.convParamToString("address", false);
+ String stepid = tranReq.convParamToString("stepid", false);
+ String org = tranReq.convParamToString("org", false);
+ String deptname = tranReq.convParamToString("deptname", false);
+ String dealtime = tranReq.convParamToString("dealtime", false);
+ String username = tranReq.convParamToString("username", false);
+ String contactname = tranReq.convParamToString("contactname", false);
+ String contactphone = tranReq.convParamToString("contactphone", false);
+ String acceptuserid = tranReq.convParamToString("acceptuserid", false);
+ String acceptusername = tranReq.convParamToString("acceptusername", false);
+ String acceptuseraccount = tranReq.convParamToString("acceptuseraccount", false);
+ String dealuserid = tranReq.convParamToString("dealuserid", false);
+ String dealusername = tranReq.convParamToString("dealusername", false);
+ String dealuseraccount = tranReq.convParamToString("dealuseraccount", false);
+ String flowstatus = tranReq.convParamToString("flowstatus", false);
+ String attachment = tranReq.convParamToString("attachment", false);
+ String creator = tranReq.convParamToString("creator", false);
+ String isplan = tranReq.convParamToString("isplan", false);
+ String originateid = tranReq.convParamToString("originateid", false);
+ String appointstarttime = tranReq.convParamToString("appointstarttime", false);
+ String appointendtime = tranReq.convParamToString("appointendtime", false);
+ String parentid = tranReq.convParamToString("parentid", false);
+ String relateids = tranReq.convParamToString("relateids", false);
+ String oname = tranReq.convParamToString("oname", false);
+ String otype = tranReq.convParamToString("otype", false);
+ SMTDatabase db = SMTAIServerApp.getApp().allocDatabase();
+ try {
+
+ db.executeSQL(
+ "UPDATE work_order_list SET "
+ + "title = ?, "
+ + "wstypeid = ?, "
+ + "wstypename = ?, "
+ + "urgencylevel = ?, "
+ + "shape = ?, "
+ + "deadline = ?, "
+ + "stepstatus = ?, "
+ + "originatetypetext = ?, "
+ + "content = ?, "
+ + "address = ?, "
+ + "step_id = ?, "
+ + "org = ?, "
+ + "deptname = ?, "
+ + "dealtime = ?, "
+ + "username = ?, "
+ + "contactname = ?, "
+ + "contactphone = ?, "
+ + "acceptuserid = ?, "
+ + "acceptusername = ?, "
+ + "acceptuseraccount = ?, "
+ + "dealuserid = ?, "
+ + "dealusername = ?, "
+ + "dealuseraccount = ?, "
+ + "flowstatus = ?, "
+ + "attachment = ?, "
+ + "creator = ?, "
+ + "createtime = ?, "
+ + "isplan = ?, "
+ + "originateid = ?, "
+ + "appointstarttime = ?, "
+ + "appointendtime = ?, "
+ + "parentid = ?, "
+ + "relateids = ?, "
+ + "is_notify = ?, "
+ + "oname = ?, "
+ + "otype = ? "
+ + "WHERE order_id = ?",
+ new Object[]{
+ title,
+ wstypeid,
+ wstypename,
+ urgencylevel,
+ shape,
+ deadline,
+ stepstatus,
+ originatetypetext,
+ content,
+ address,
+ stepid,
+ org,
+ deptname,
+ dealtime,
+ username,
+ contactname,
+ contactphone,
+ acceptuserid,
+ acceptusername,
+ acceptuseraccount,
+ dealuserid,
+ dealusername,
+ dealuseraccount,
+ flowstatus,
+ attachment,
+ creator,
+ new Date(),
+ isplan,
+ originateid,
+ appointstarttime,
+ appointendtime,
+ parentid,
+ relateids,
+ "N",
+ oname,
+ otype,
+ orderId
+ });
+
+
+ } finally {
+ db.close();
+ }
+
+ return tranReq.returnJsonState(true, null, null);
+ }
+
public ModelAndView getOrderList(SMTAIServerRequest tranReq) throws Exception {
SMTJsonWriter jsonWr = tranReq.newReturnJsonWriter(true, null, null);
SMTDatabase db = SMTAIServerApp.getApp().allocDatabase();
diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/javaai/jsonflow/node/SMTJsonFlowNodeScript.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/javaai/jsonflow/node/SMTJsonFlowNodeScript.java
index 9a1961e..b4de726 100644
--- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/javaai/jsonflow/node/SMTJsonFlowNodeScript.java
+++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/javaai/jsonflow/node/SMTJsonFlowNodeScript.java
@@ -53,7 +53,8 @@
public Object llmAnswerToJson(String sJson)
{
- return SMTAIServerApp.convJsonToJS(SMTStatic.convLLMAnswerToJson(sJson, false));
+ Object object = SMTAIServerApp.convJsonToJS(SMTStatic.convLLMAnswerToJson(sJson, false));
+ return object;
}
public Object getArg(String key)
diff --git a/JAVA/SMTAIServer/src/main/resources/requestmap/java_ai.json b/JAVA/SMTAIServer/src/main/resources/requestmap/java_ai.json
index 0d0b4bd..fdb40f0 100644
--- a/JAVA/SMTAIServer/src/main/resources/requestmap/java_ai.json
+++ b/JAVA/SMTAIServer/src/main/resources/requestmap/java_ai.json
@@ -461,6 +461,51 @@
]
}
]
+ },
+ "sys/update_order":{
+ "map":{"class":"#SMTJavaAIControl", "method":"updateOrder"}, "no_shrio":false,
+ "swaggers":[
+ {
+ "tags" : ["淇敼宸ュ崟鍐呭"],
+ "title" : "淇敼宸ュ崟鍐呭",
+ "parameters" : [
+ {"name": "title", "title": "鏍囬", "required": false},
+ {"name": "wstypeid", "title": "绫诲瀷缂栧彿", "required": false},
+ {"name": "wstypename", "title": "绫诲瀷鍚嶇О", "required": false},
+ {"name": "urgencylevel", "title": "绱ф�ョ骇鍒�", "required": false},
+ {"name": "shape", "title": "娲惧崟鍧愭爣", "required": false},
+ {"name": "deadline", "title": "澶勭悊鏃堕檺", "required": false},
+ {"name": "stepstatus", "title": "宸ュ崟杩涘害鐘舵��", "required": false},
+ {"name": "originatetypetext", "title": "鏉ユ簮绫诲瀷", "required": false},
+ {"name": "content", "title": "鍐呭", "required": false},
+ {"name": "address", "title": "鍦板潃", "required": false},
+ {"name": "stepid", "title": "宸ュ崟姝ラ", "required": false},
+ {"name": "org", "title": "鎵�灞炲垎鍏徃", "required": false},
+ {"name": "deptname", "title": "宸ュ崟鎵�灞為儴闂ㄥ悕绉�", "required": false},
+ {"name": "dealtime", "title": "澶勭悊鏃堕棿", "required": false},
+ {"name": "username", "title": "鐢ㄦ埛鍚嶇О", "required": false},
+ {"name": "contactname", "title": "鑱旂郴浜�", "required": false},
+ {"name": "contactphone", "title": "鑱旂郴鐢佃瘽", "required": false},
+ {"name": "acceptuserid", "title": "鎺ュ崟浜篿d", "required": false},
+ {"name": "acceptusername", "title": "鎺ュ崟浜哄悕绉�", "required": false},
+ {"name": "acceptuseraccount", "title": "鎺ュ崟浜鸿处鍙�", "required": false},
+ {"name": "dealuserid", "title": "澶勭悊浜篿d", "required": false},
+ {"name": "dealusername", "title": "澶勭悊浜哄悕绉�", "required": false},
+ {"name": "dealuseraccount", "title": "澶勭悊浜鸿处鍙�", "required": false},
+ {"name": "flowstatus", "title": "宸ュ崟鐘舵��", "required": false},
+ {"name": "attachment", "title": "闄勪欢", "required": false},
+ {"name": "creator", "title": "鍒涘缓浜�", "required": false},
+ {"name": "createtime", "title": "鍒涘缓鏃堕棿", "required": false},
+ {"name": "isplan", "title": "鏄惁璁″垝宸ュ崟", "required": false},
+ {"name": "originateid", "title": "鏉ユ簮缂栧彿", "required": false},
+ {"name": "appointstarttime", "title": "棰勭害寮�濮嬫椂闂�", "required": false},
+ {"name": "appointendtime", "title": "棰勭害缁撴潫鏃堕棿", "required": false},
+ {"name": "parentid", "title": "鐖剁骇缂栧彿", "required": false},
+ {"name": "relateids", "title": "鍏宠仈缂栧彿", "required": false},
+ {"name": "orderId", "title": "宸ュ崟id", "required": true}
+ ]
+ }
+ ]
}
--
Gitblit v1.9.3