From a2ecbf17d6ba1c7b135fe10bb4cdfefa05b75add Mon Sep 17 00:00:00 2001
From: fs-danaus <danaus314@qq.com>
Date: 星期六, 16 三月 2024 17:48:40 +0800
Subject: [PATCH] 在线交流,流程跟踪根据sql表达式设置显示与否
---
WebRoot/public/template/0/5/panel.jsp | 76 ++++++++++++++++++++++---------------
1 files changed, 45 insertions(+), 31 deletions(-)
diff --git a/WebRoot/public/template/0/5/panel.jsp b/WebRoot/public/template/0/5/panel.jsp
index a8c7c1f..23ff409 100644
--- a/WebRoot/public/template/0/5/panel.jsp
+++ b/WebRoot/public/template/0/5/panel.jsp
@@ -13,27 +13,27 @@
String sql = "";
SqlRowSet SRS =null;//3绫诲瀷鎺т欢閬嶅巻涓嬫媺鏁版嵁
String addUrl="";//娣诲姞浼犵粰grid鐨勬潯浠讹紝闇�瑕佸垎绂�
- Map<String,Object> docMap=new HashMap<String,Object>();//鏌ヨ鑾峰彇鍒扮殑鏁版嵁淇℃伅Map闆嗗悎
- List<Map<String, Object>> listInfo=new ArrayList<Map<String, Object>>();//鏌ヨ鑾峰彇鍒扮殑鏁版嵁淇℃伅List闆嗗悎
- if((wherePan!=null&&!wherePan.equals(""))||grid!=null){
- if(wherePan.indexOf("@G@")!=-1){
- int inds=wherePan.indexOf("@G@");
- String temp1=wherePan;
- wherePan=temp1.substring(0,inds);
- addUrl = " and "+temp1.substring(inds+3);
- }
- try{
- sql="select top 1 @selectColAll@ from ";//鍙兘鏌ヤ竴鏉�
- if(sql.contains("&doccode&")){//by danaus 2011-1-25
- if(doccode!=null)
- sql=sql.replaceAll("&doccode&",doccode.replaceAll("'",""));
- }
- SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
- load.setSql(sql);
- load.setSqlWhere(wherePan);
- load.setTableName(tableIs);
- //鍔犺浇闈㈡澘鏁版嵁淇℃伅鎴栧鍗曟椂鍊欏姞杞�
- listInfo=PanelManageBo.getFormLoad(load);
+ Map<String, Object> docMap = new HashMap<String, Object>();//鏌ヨ鑾峰彇鍒扮殑鏁版嵁淇℃伅Map闆嗗悎
+ List<Map<String, Object>> listInfo = new ArrayList<Map<String, Object>>();//鏌ヨ鑾峰彇鍒扮殑鏁版嵁淇℃伅List闆嗗悎
+ if ((wherePan != null && !wherePan.equals("")) || grid != null) {
+ if (wherePan.indexOf("@G@") != -1) {
+ int inds = wherePan.indexOf("@G@");
+ String temp1 = wherePan;
+ wherePan = temp1.substring(0, inds);
+ addUrl = " and " + temp1.substring(inds + 3);
+ }
+ try {
+ sql = "select top 1 @selectColAll@" + online + " from ";//鍙兘鏌ヤ竴鏉�
+ if (sql.contains("&doccode&")) {//by danaus 2011-1-25
+ if (doccode != null)
+ sql = sql.replaceAll("&doccode&", doccode.replaceAll("'", ""));
+ }
+ SpObserver.setDBtoInstance("_" + request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
+ load.setSql(sql);
+ load.setSqlWhere(wherePan);
+ load.setTableName(tableIs);
+ //鍔犺浇闈㈡澘鏁版嵁淇℃伅鎴栧鍗曟椂鍊欏姞杞�
+ listInfo = PanelManageBo.getFormLoad(load);
if(listInfo.size()>0){
docMap.putAll(listInfo.get(0));
docstatePan=DBHelper.getValueInt(docMap,"docstatus");
@@ -180,19 +180,33 @@
panMain[panIndex]=clone(panPar);
@uploadEditStatusMap@
@panInfo@
- @panelScript@
- panMain[panIndex].upDoc='<%=DBHelper.getValue(docMap,"upDoc")%>';
- panMain[panIndex].nextDoc='<%=DBHelper.getValue(docMap,"nextDoc")%>';
- panMain[panIndex].controlUrl="panelControl@formId@.jsp";
- panMain[panIndex].isNew=isNew;//鏄惁鏄柊鍗�
+ @panelScript @
+ panMain
+ [panIndex].upDoc = '<%=DBHelper.getValue(docMap,"upDoc")%>';
+ panMain[panIndex].nextDoc = '<%=DBHelper.getValue(docMap,"nextDoc")%>';
+ panMain[panIndex].controlUrl = "panelControl@formId@.jsp";
+ panMain[panIndex].isNew = isNew;//鏄惁鏄柊鍗�
</script>
-<%@ include file="/public/template/0/showPan.txt"%>
+<%@ include file="/public/template/0/showPan.txt" %>
<div class="panelControlDiv">@panelHtml@</div>
-<div id="tplt-grid"><%@ include file="@formId@_@customGrid@grid.jsp"%></div>
+<div id="tplt-grid"><%@ include file="@formId@_@customGrid@grid.jsp" %></div>
<div class="panelControlDiv">@panelDownHtml@</div>
+ <%
+ if ("1".equals(docMap.get("isshowonlinemsgbtn"))) {
+ request.setAttribute("formId", formId + "");
+ request.setAttribute("docCode", doccode);
+ %>
+ <jsp:include page="/general/onlineMessage.jsp" flush="true"/>
+ <%
+ }
+ if ("1".equals(docMap.get("isshowprocesstrackingbtn"))) {
+ %>
+ <%@ include file="/general/processTrack.jsp" %>
+ <%} %>
<script type="text/javascript">
- @pansetInv@
- panMain[panIndex].loadSet(<%=docstatePan%>);
- panMain[panIndex].keyDown('123','null');
+ @pansetInv @
+ panMain
+ [panIndex].loadSet(<%=docstatePan%>);
+ panMain[panIndex].keyDown('123', 'null');
</script>
</span>
\ No newline at end of file
--
Gitblit v1.8.0