xinyb
2024-03-27 f87909326c2ff2c58da027163f64d9d8f9424b17
提交 | 用户 | age
a6a76f 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
F 2     pageEncoding="UTF-8"%>
3 <%@page import="com.yc.factory.FactoryBean"%>
4 <%@page import="com.yc.service.commons.GfieldIfc"%>
5 <%@page import="java.util.List"%>
6 <%@page import="java.util.Map"%>
7 <%@page import="com.google.gson.Gson"%>
8 <%@page import="com.google.gson.reflect.TypeToken"%>  
9 <%@page import="com.yc.service.build.top.BuildTopIfc"%>
10 <%@page import="org.springframework.web.context.WebApplicationContext"%>
11 <%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
12 <% 
13    //跟据功能号查询,查询DIV页面须要的字段
14    GfieldIfc gfieldIfc = (GfieldIfc)FactoryBean.getBean("GfieldImpl");
15    StringBuilder sb = new StringBuilder();
16    List<Map<String,Object>> list =null;
17    try{
18         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
19         list=gfieldIfc.getAllowQueryFields(formId);
20    }catch(Exception e){
21         throw e;
22       //out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"')</script>");
23       //return;
24    }finally{
25         com.yc.multiData.SpObserver.setDBtoInstance();
26    }    
27    Gson gson = new Gson();
28    String t = gson.toJson(list,new TypeToken<List<Map<String,Object>>>(){}.getType());
29    sb.append(t);
30    sb.insert(0,"{rows:");
31    sb.append("}");
32    StringBuilder printLink = new StringBuilder();//打印下来按钮
33    StringBuilder printButton = new StringBuilder();//打印button按钮
34    StringBuilder funcLink = new StringBuilder();//链接下拉按钮
35    StringBuilder funcLinkButton = new StringBuilder();//链接button按钮
36    String _1 = "1".intern(); //标识1
37    boolean printHasExpression = [?printHasExpression];//是否有表达式
38    //boolean linkHasExpression = [?linkHasExpression];//是否有表达式
39    if(printHasExpression){//有表达式拼装sql
40          String reportSql = "[?getReportSQL]";
41          reportSql = com.yc.utils.RequestParameterUtils.replaceRequestExpression(reportSql,request,session);
42            List<Map<String,Object>> reportInfo =null;
43            try{
44                 com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
45                 reportInfo=sqlQueryIfc.queryForList(reportSql,null);//打印链接信息
46                 com.yc.service.build.top.PrintLinkSpellUtils.spellPrintLink(reportInfo,formId,formType,printLink,printButton);
47            }catch(Exception e){
48                 throw new Exception(e.getMessage().replace("'","\\'")+"-打印设置表达式有错误!");
49             //out.println("<script>$.messager.alert('操作提示','"+e.getMessage().replace("'","\\'")+"-打印设置表达式有错误!','warning')</script>");
50            // return;
51          }finally{
52               com.yc.multiData.SpObserver.setDBtoInstance();
53          }
54    }
55    String notExpressionFuncLink="[?notExpressionFuncLink]";
56    String notExpressionFuncLinkButton="[?notExpressionFuncLinkButton]";
57    WebApplicationContext wac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
58    BuildTopIfc buildTopIfc = (BuildTopIfc)wac.getBean("BuildTopImpl");
59    Map<String,Object> map =null;
60    try{
61         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
62         map=buildTopIfc.buildFuncLinkExpression(formId,formType,doccode,request,session,notExpressionFuncLink,notExpressionFuncLinkButton);
63    }catch(Exception e){
64         throw new Exception(e.getMessage().replace("'","\\'")+"-功能链接设置表达式有错误!");
65      // out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"-功能链接设置表达式有错误!')</script>");
66      // return;
67    }finally{
68         com.yc.multiData.SpObserver.setDBtoInstance();
69    }
70 %>
71 <script type="text/javascript">
72 var data = <%=sb.toString() %>;
73 var reportprompts="[?reportprompts]";
74 </script>
75 <div id="func" style="width:170px;">
76     <%if(map.size()>0){ %>
77     <%=map.get("funcLink").toString() %>
78     <%} %>
79 </div>
80 <div id="print" style="width:170px;">
81     <%if(printHasExpression){ %>
82         <%=printLink %>
83       <%}else{ %>
84         [?printLink]
85     <%}if(_1==isSuperUser){%>
86     <div id="otherFormats">其他格式</div>
87     <%} %>
88     
89 </div>
90 [?TopBigTitle]
91 <div id="tool">
92         <%if((profile&FormOpUtil.openQuery)>0){%>
93         <a id="selectinfo" onmousedown="select();" class="easyui-linkbutton"
94     plain="true" iconCls="icon-search">搜索</a>
95         <%}%>
96         <img height="29px" src="/images/space.jpg" align="top"/>
97         <% if((profile&FormOpUtil.saveRecord)>0){%>
98         <a href="javascript:void(0);" class="easyui-linkbutton" plain="true" iconCls="icon-save" onclick="save();">保存</a>
99         <%}%>        
100         <a id="tpselect"  class="easyui-linkbutton"  plain="true" iconCls="icon-select">选择</a>
101         <a class="easyui-linkbutton" id="showRestmenuDiv"  onclick="moreSelect();"  iconCls="icon-down" onblur="restmenuclose();" 
102     plain="true">更多</a> 
103     
104     <a id="bhelp" href="javascript:openHelpPage('[?title]');"  class="easyui-linkbutton"  plain="true" iconCls="icon-help">帮助</a>
105     
106
107         <%
108         ////打印链接
109         if(printHasExpression){ %>
110             <%=printButton %>
111           <%}else{ %>
112             [?printButton]
113         <%}
114         ////////功能链接
115         %>
116             <%if(map.get("funcLinkButton").toString().length()>0){ %>
117           <%=map.get("funcLinkButton") %>
118           <%} %>
07beec 119     <%
9481ea 120         if((profile&FormOpUtil.saveRecord)>0 && formId==110503){
07beec 121     %>
X 122     <a href="javascript:void(0);" onclick="Batchupload();" class="easyui-linkbutton" title='批量上传' iconCls="icon-top">批量上传主图片</a>
123     <%
124         }
125     %>
a6a76f 126            <div id="tpUpDownDoc">
f87909 127                <a href="javascript:editCustomControl();" class="easyui-linkbutton first" plain="true" title='自定义控件布局' iconCls="icon-scok">布局</a>
34fadb 128          <a href="javascript:void(0);" onclick="refresh();" class="easyui-linkbutton" plain="true" title='刷新(Alt+R)' iconCls="icon-reload">刷新</a>
a6a76f 129          </div>
F 130 </div>
131 <div id="selectDiv" style="width:520px;height:490px;left: 1px;top:30px;" class="easyui-window" collapsible="false" minimizable="false" maximizable="false" title="搜索" closed="true">
132     <div class="easyui-tabs" border="true" style="width:500px;height:450px;">
133         <div id="generalQuery" title="简单查询" fit="true" border="true" style="padding:0px;">
134         <div style="margin-left:20px;width: 450px;height: 150px;float: left;">
135                         <div>&nbsp;</div>
136                         输入查询内容:<input id="queryValue" type="text" style="border: 1px solid #cccccc;width: 300px;"/><br><br><br><br>
137                         <div align="center"><a iconCls="icon-ok" class="easyui-linkbutton" onclick="selectSimpConfirm();">确 定</a>&nbsp;
138                         <a iconCls="icon-cancel" class="easyui-linkbutton" onclick="windowClose();">关 闭</a></div>
139                     </div>
140                     <div style="margin-left:20px;margin-top:10px;width:450px;font-weight: bold;color: #666666;float: left;">
141                         可查询字段:<br></br>
142                         <%
143                         Map<String,Object> temp = null;
144                         for(int i=0;i<list.size();i++){ 
145                             temp = list.get(i);
146                         %>
147                             <div class="queryField" field="<%=temp.get("fieldid") %>"><%=temp.get("fieldname") %></div>
148                         <%} %>
149                     </div>
150                                         
151         </div>
152         <div id="advancedQuery" title="高级查询" style="padding:0px;">
153              <div id="query">
154                 <table id="tt" style="width:495px;height:380px;border-bottom: 1px solid;" border="false" singleSelect="true" >
155                     <thead>
156                         <tr>
157                             <th field="fieldid" width="80" hidde="true">ID</th>
158                             <th field="cont" width="60" formatter="contFormatter" align=center editor="{type:'combobox',options:{valueField:'contid',textField:'text',data:cont,editable:false}}" >连接符</th>
159                             <th field="fieldname" width="100" >字段名</th>
160                             <th field="opt" formatter="opttFormatter"  editor="{type:'combobox',options:{valueField:'opid',textField:'text',data:opts,editable:false,onChange:optSelect}}" width="80" >比较符</th>
161                             <th field="opt2" formatter="opt2Formatter" width="10" align="center" ></th>
162                             <th field="fieldvalue1"  width="95" editor="{type:'text'}">字段值</th>
163                             <th field="fieldvalue2" width="95" editor="{type:'text'}">字段值2</th>                            
164                         </tr>
165                    </thead>
166                </table>
167                <div    style="100%;margin-left:20px;">
168                        <br /><label for="more">更多选项</label><input id="more" type="checkbox" />
169                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a iconCls="icon-ok" class="easyui-linkbutton" onclick="selectSimpConfirm2();">确 定</a>&nbsp;
170                     <a iconCls="icon-cancel" class="easyui-linkbutton" onclick="windowClose();">关 闭</a>
171                </div>
172             </div>
173         </div>
174     </div>
175 </div>
176 <div class="easyui-window" style="width:auto;height:auto;background-color:#DEEDF7;" id="restmenuDiv"
177 collapsible="false" draggable="false" minimizable="false" maximizable="false" title="更多" closed="true" >
178 <table width="520px">
179 <%if(map.get("funcLink").toString().length()>0){  %>
180 <tr >
181     <td width="80px;" style="font-size: 13px;"><strong>功能链接:</strong></td>
182     <td style="font-size: 13px;">
183     <%=map.get("funcLink") %>
184     </td>
185     
186 </tr>
187 <%} %>
188
189 <% if(((profile&FormOpUtil.printButton)>0&&[?printLinkLength]>0)||printLink.length()>0||_1==isSuperUser){%>
190 <tr>
191     <td width="80px" style="font-size: 13px;"><strong>打印格式:</strong></td>
192     <td style="font-size: 13px;">
193         <%if(printHasExpression){ %>
194                 <%=printLink %>
195           <%}else{ %>
196             [?printLink]
197         <%}if(_1==isSuperUser){%>
198             <div style="width:80px;display:inline;cursor:pointer" id="otherFormat">其他格式</div>
199             
200         <%}%>
201     </td>
202 </tr>
203 <%}
204   List<Map<String, Object>> exportList =null;
205   StringBuilder sb1 = new StringBuilder();
206   try{
207         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
208         exportList=gfieldIfc.getExportInfo(formId);        
209         com.yc.service.build.top.ExportSpellUtils.spellLink(exportList, sb1,profile);
210   }catch(Exception e){
211         throw e;
212   }finally{
213         com.yc.multiData.SpObserver.setDBtoInstance();
214   }        
215   if(sb1.length()>0){ %>
216 <tr>
c81e3f 217     <td width="80px" style="font-size: 13px;"><strong>导入导出:<strong></td>
a6a76f 218     <td><%out.print(sb1.toString());%></td>
F 219 </tr>
220 <%} %>
221 </table>
222 </div>
223 <%_1 = null;printLink=null;printButton=null;funcLink=null;funcLinkButton=null;%>
224
225