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.service.build.top.BuildTopIfc"%>
4 <%@page import="org.springframework.web.context.WebApplicationContext"%>
5 <%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
6 <% 
7 StringBuilder printLink = new StringBuilder();//打印下来按钮
8 StringBuilder printButton = new StringBuilder();//打印button按钮
9 StringBuilder funcLink = new StringBuilder();//链接下拉按钮
10 StringBuilder funcLinkButton = new StringBuilder();//链接button按钮
11 String _1 = "1".intern(); //标识1
12 boolean printHasExpression = [?printHasExpression];//是否有表达式
13 //boolean linkHasExpression = [?linkHasExpression];//是否有表达式
14 if(printHasExpression){//有表达式拼装sql
15     String reportSql = "[?getReportSQL]";
16     reportSql = com.yc.utils.RequestParameterUtils.replaceRequestExpression(reportSql,request,session);
17         List<Map<String,Object>> reportInfo =null;
18       try{
19           com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
20         reportInfo=sqlQueryIfc.queryForList(reportSql,null);//打印链接信息
21         com.yc.service.build.top.PrintLinkSpellUtils.spellPrintLink(reportInfo,formId,formType,printLink,printButton);
22        }catch(Exception e){
23           throw new Exception(e.getMessage().replace("'","\\'")+"-打印设置表达式有错误!");
24           //out.println("<script>$.messager.alert('操作提示','"+e.getMessage().replace("'","\\'")+"-打印设置表达式有错误!','warning')</script>");
25        // return;
26          }finally{
27              com.yc.multiData.SpObserver.setDBtoInstance();
28          }
29       }
30
31 String notExpressionFuncLink="[?notExpressionFuncLink]";
32 String notExpressionFuncLinkButton="[?notExpressionFuncLinkButton]";
33 WebApplicationContext wac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
34 BuildTopIfc buildTopIfc = (BuildTopIfc)wac.getBean("BuildTopImpl");
35 Map<String,Object> map =null;
36 try{
37         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
38 map=buildTopIfc.buildFuncLinkExpression(formId,formType,doccode,request,session,notExpressionFuncLink,notExpressionFuncLinkButton);
39
40 }catch(Exception e){
41     throw new Exception(e.getMessage().replace("'","\\'")+"-功能链接设置表达式有错误!");
42     // out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"-功能链接设置表达式有错误!')</script>");
43     // return;
44  }finally{
45      com.yc.multiData.SpObserver.setDBtoInstance();
46  }
47
48 %>
49 <script type="text/javascript">
50 var reportprompts="[?reportprompts]";
51 </script>
52 <div id="func" style="width:170px;">
53     <%if(map.size()>0){ %>
54     <%=map.get("funcLink").toString() %>
55     <%} %>
56 </div>
57 <div id="print" style="width:170px;">
58     <%if(printHasExpression){ %>
59         <%=printLink %>
60       <%}else{ %>
61         [?printLink]
62     <%}if(_1==isSuperUser){%>
63     <div id="otherFormats">其他格式</div>
64     <%} %>
65 </div>
66 [?TopBigTitle]
67 <div id="tool">
68         <%if((profile&FormOpUtil.openQuery)>0){%>
69         <a href="javascript:void(0);" class="easyui-linkbutton" plain="true" onclick="commit38();"  iconCls="icon-search">打开</a>
70         <%}%>
71         <a id="tpselect"  class="easyui-linkbutton"  plain="true" iconCls="icon-select">选择</a>
72         <img height="29px" src="/images/space.jpg" align="top"/>
73
74             <a class="easyui-linkbutton" id="showRestmenuDiv"  onclick="showrestmenu();"  iconCls="icon-down" onblur="restmenuclose();" 
75     plain="true">更多</a>
76     
77     <a id="bhelp" href="javascript:openHelpPage('[?title]');"  class="easyui-linkbutton"  plain="true" iconCls="icon-help">帮助</a>
78     
79         <%
80         ////打印链接
81         if(printHasExpression){ %>
82             <%=printButton %>
83           <%}else{ %>
84             [?printButton]
85         <%}
86         ////////功能链接
87         %>
88             <%if(map.get("funcLinkButton").toString().length()>0){ %>
89           <%=map.get("funcLinkButton") %>
90           <%} %>
91        <input type="checkbox" id="char_pb" name="checkName" onclick="is_38open=false;commit38();">显示图表<input type="hidden" id="char_pbvulue" name="char_pbvulue" value="char_pb">
92        <div id="tpUpDownDoc">
f87909 93            <a href="javascript:editCustomControl();" class="easyui-linkbutton first" plain="true" title='自定义控件布局' iconCls="icon-scok">布局</a>
34fadb 94          <a href="javascript:void(0);" onclick="refresh();" class="easyui-linkbutton" plain="true" title='刷新(Alt+R)' iconCls="icon-reload">刷新</a>
a6a76f 95          </div>
F 96 </div>
97 <div id="selectDiv" class="selectDiv">
98     <div class="easyui-tabs" border="true" style="width:497px;height:365px;">
99         <div id="generalQuery" title="简单查询" fit="true" border="true" style="padding:0px;">
100         <div style="margin-left:20px;width: 450px;height: 150px;float: left;">
101                         <div>&nbsp;</div>
102                         输入查询内容:<input id="queryValue" type="text" style="border: 1px solid #cccccc;width: 300px;"/><br><br><br><br>
103                         <div align="center"><a iconCls="icon-ok" class="easyui-linkbutton" onclick="tw.simpConfirm();">确 定</a>&nbsp;
104                         <a iconCls="icon-cancel" class="easyui-linkbutton" onclick="winClose();">关 闭</a></div>
105                     </div>
106                     <div style="margin-left:20px;margin-top:10px;width:450px;font-weight: bold;color: #666666;float: left;">
107                         可查询字段:<br></br>
108                         <%
109                         Map<String,Object> temp = null;
110                         for(int i=0;i<list.size();i++){ 
111                             temp = list.get(i);
112                         %>
113                             <div class="queryField" field="<%=temp.get("fieldid") %>"><%=temp.get("fieldname") %></div>
114                         <%} %>
115                     </div>                    
116         </div>
117         <div id="advancedQuery" title="高级查询" style="padding:0px;">
118              <div id="query">
119                 <table id="tt" style="width:495px;height:290px;border-bottom: 1px solid;" border="false" singleSelect="true" >
120                     <thead>
121                         <tr>
122                             <th field="fieldid" width="80" hidde="true">ID</th>
123                             <th field="cont" width="60" formatter="contFormatter" align=center editor="{type:'combobox',options:{valueField:'contid',textField:'text',data:cont,editable:false}}" >连接符</th>
124                             <th field="fieldname" width="100" >字段名</th>
125                             <th field="opt" formatter="opttFormatter"  editor="{type:'combobox',options:{valueField:'opid',textField:'text',data:opts,editable:false,onChange:optSelect}}" width="80" >比较符</th>
126                             <th field="opt2" formatter="opt2Formatter" width="10" align="center" ></th>
127                             <th field="fieldvalue1"  width="95" editor="{type:'text'}">字段值</th>
128                             <th field="fieldvalue2" width="95" editor="{type:'text'}">字段值2</th>
129                         </tr>
130                    </thead>
131                </table>
132                <div    style="100%;margin-left:20px;">
133                        <br /><label for="more">更多选项</label><span style="position:fixed;margin-top:3px;"><input id="more" type="checkbox" /></span>
134                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a iconCls="icon-ok" class="easyui-linkbutton" onclick="tw.confirm2();">确 定</a>&nbsp;
135                     <a iconCls="icon-cancel" class="easyui-linkbutton" onclick="winClose();">关 闭</a>
136                </div>
137             </div>
138         </div>
139     </div>
140 </div>
141 <div class="restmenuDiv" id="restmenuDiv"
142     onmouseover="showrestmenu();" onmouseout="restmenuclose();">
143 <table width="520px">
144 <%if(map.get("funcLink").toString().length()>0){ %>
145 <tr >
146     <td width="80px;"><strong>功能链接:</strong></td>
147     <td>
148     <%=map.get("funcLink") %>
149     </td>
150     
151 </tr>
152 <%} %>
153
154 <% if(((profile&FormOpUtil.printButton)>0&&[?printLinkLength]>0)||printLink.length()>0||_1==isSuperUser){%>
155 <tr>
156     <td width="80px"><strong>打印格式:</strong></td>
157     <td>
158         <%if(printHasExpression){ %>
159                 <%=printLink %>
160           <%}else{ %>
161             [?printLink]
162         <%}if(_1==isSuperUser){%>
163             <div style="width:80px;display:inline;cursor:pointer" id="otherFormat">其他格式</div>
164         <%} %>
165     </td>
166 </tr>
167 <%} %>
168
169 <%
170 com.yc.service.commons.GfieldIfc gfieldIfc = (com.yc.service.commons.GfieldIfc)com.yc.factory.FactoryBean.getBean("GfieldImpl");
171         List<Map<String, Object>> exportList =null;
172         StringBuilder sb1 = new StringBuilder();
173 try{
174         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
175         exportList=gfieldIfc.getExportInfo(formId);        
176         com.yc.service.build.top.ExportSpellUtils.spellLink(exportList, sb1,profile);
177 }catch(Exception e){
178     throw e;
179     //out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"')</script>");
180  }finally{
181      com.yc.multiData.SpObserver.setDBtoInstance();
182  }        
183 if(sb1.length()>0){ %>
184 <tr>
185     <td width="80px"><strong>导入导出:<strong></td>
186     <td><%out.print(sb1.toString());%></td>
187 </tr>
188 <%} %>
189 </table>
190 </div>
191 <%_1 = null;printLink=null;printButton=null;funcLink=null;funcLinkButton=null;%>