sysWordTemplateEditTemplate.jsp 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247
  1. <%--
  2. time:2011-11-16 16:34:16
  3. --%>
  4. <%@page language="java" pageEncoding="UTF-8"%>
  5. <%@include file="/commons/include/html_doctype.html"%>
  6. <html>
  7. <head>
  8. <title>编辑WORD表单模板</title>
  9. <%@include file="/commons/include/customForm.jsp" %>
  10. <f:link href="tree/zTreeStyle.css"></f:link>
  11. <script type="text/javascript" src="${ctx}/js/lg/plugins/ligerLayout.js"></script>
  12. <script type="text/javascript" src="${ctx}/js/tree/jquery.ztree.core.min.js"></script>
  13. <script type="text/javascript" src="${ctx}/js/lg/plugins/ligerWindow.js"></script>
  14. <script type="text/javascript" src="${ctx}/js/hotent/platform/form/OfficePlugin.js"></script>
  15. <script type="text/javascript" src="${ctx}/js/hotent/platform/form/OfficeControl.js"></script>
  16. <style type="text/css">
  17. .panel-body{
  18. overflow:hidden;
  19. }
  20. .l-layout-left{
  21. overflow:auto;
  22. }
  23. </style>
  24. <script type="text/javascript">
  25. var controlObj;
  26. $(window).bind("load",function(){
  27. //Office控件初始化。
  28. OfficePlugin.init();
  29. controlObj = OfficePlugin.officeObjs[0].controlObj;
  30. });
  31. $(function() {
  32. //验证代码
  33. var winHeight = $(window).height()-120;
  34. $("#frmDefLayout").ligerLayout({leftWidth : 200,height:winHeight,onHeightChanged:function(layoutHeight, diffHeight, middleHeight){
  35. }});
  36. $('#frmWorkFlow').ajaxForm({success:showResponse });
  37. initZtree();
  38. });
  39. function showResponse(responseText){
  40. var obj=new com.hotent.form.ResultMessage(responseText);
  41. if(obj.isSuccess()){
  42. $.ligerDialog.confirm("保存成功,是否继续操作", "提示信息", function(rtn) {
  43. if (!rtn) {
  44. window.opener.location.reload();
  45. window.close();
  46. }
  47. });
  48. }else{
  49. $.ligerDialog.err("提示信息","WORD表单模板保存失败!",obj.getMessage());
  50. }
  51. $(".l-dialog-frame").css("z-index","9000");
  52. }
  53. function submitData() {
  54. var uaName=navigator.userAgent.toLowerCase();
  55. OfficePlugin.submit();//火狐和谷歌 的文档提交包括了 业务提交代码部分(完成 OfficePlugin.submit()后面的回调 函数 有 业务提交代码),所以 后面就不用加上业务提交代码
  56. if(uaName.indexOf("firefox")<0 && uaName.indexOf("chrome")<0){ //同步处理
  57. //当提交问题 等于 提交数量的变量 时 表示所有文档 都提交了 然后做 业务相关的提交
  58. if(OfficePlugin.submitNum == OfficePlugin.submitNewNum){
  59. $('#frmWorkFlow').submit();
  60. }else{
  61. $.ligerDialog.error("提交失败,OFFICE控件没能正常使用,请重新安装 !!!","提示");
  62. $(".l-dialog-frame").css("z-index","9000");
  63. }
  64. }
  65. }
  66. function initZtree(){
  67. var json = ${tableMap};
  68. var error = json.error;
  69. if(error) {
  70. $.ligerDialog.error(error,"出错啦!");
  71. json = {mainfields:[], subtables:[]};
  72. }
  73. var treeData = [];
  74. var iconFolder = __ctx + '/styles/tree/';
  75. for(var i=0,c;c=json.mainfields[i++];){
  76. if(c.isHidden == 0){
  77. c.name = c.fieldDesc;
  78. c.pId = 0;
  79. c.icon = iconFolder + c.fieldType + '.png';
  80. treeData.push(c);
  81. }
  82. }
  83. for(var i=0,c;c=json.subtables[i++];){
  84. c.icon = iconFolder + 'table.png';
  85. c.pId = 0;
  86. treeData.push(c);
  87. //添加序号
  88. var rn={pId:c.id,fieldName:"rn",fieldDesc:"序号", name:"序号",icon:iconFolder +"number" + '.png'};
  89. treeData.push(rn);
  90. for(var j = 0,m;m=c.subfields[j++];){
  91. m.pId = c.id;
  92. m.name = m.fieldDesc;
  93. m.icon = iconFolder + m.fieldType + '.png';
  94. treeData.push(m);
  95. }
  96. }
  97. var setting = {
  98. data: {
  99. key : {
  100. name: "name"
  101. },
  102. simpleData: {
  103. enable: true,
  104. idKey: "id",
  105. pIdKey: "pId",
  106. rootPId: 0
  107. }
  108. },
  109. callback : {
  110. beforeClick : beforeClick
  111. }
  112. };
  113. glTypeTree = $.fn.zTree.init($("#colstree"),setting, treeData);
  114. }
  115. var bookMarkIndex;//保存当前文档中书签的总数
  116. function beforeClick(treeId, treeNode, clickFlag){
  117. var fieldName = treeNode.fieldName;
  118. var fieldDesc = treeNode.fieldDesc;
  119. var doc = controlObj.ActiveDocument;
  120. var sel = doc.Application.Selection.Range;
  121. var isChecked = $('#insertDesc').is(':checked');
  122. var isParent = treeNode.isParent;
  123. if(isChecked){
  124. sel.Text = isParent ? treeNode.name : fieldDesc ;
  125. }else if(!isParent){
  126. if(!bookMarkIndex) {
  127. bookMarkIndex = doc.Bookmarks.Count;
  128. }
  129. var parent = treeNode.getParentNode();
  130. if(parent){
  131. sel.Text ="{"+ parent.tablename +'_0_'+ fieldName +"}";
  132. }else {
  133. fieldName = fieldName+'_1_'+bookMarkIndex;
  134. sel.Text = '\${' + fieldDesc + '}';
  135. doc.Bookmarks.Add(fieldName, sel);
  136. bookMarkIndex++;
  137. }
  138. }
  139. return false;
  140. }
  141. function developHelp(){
  142. var obj=$("#help_div");
  143. $.ligerDialog.open({ target:obj , height: 370,width:600, modal :true}).show();
  144. $(".l-dialog-frame").css("z-index","9000");
  145. return false;
  146. }
  147. </script>
  148. </head>
  149. <body style="overflow:hidden">
  150. <div>
  151. <div class="tbar-title">
  152. <span class="tbar-label">word表单模板编辑</span>
  153. </div>
  154. <div class="panel-toolbar">
  155. <div class="toolBar">
  156. <div class="group">
  157. <a class="link save" id="dataFormSave" href="javascript:;" onclick="submitData();"><span></span>保存</a>
  158. </div>
  159. <div class="l-bar-separator"></div>
  160. <div class="group">
  161. <a class="link preview" id="btnPreView" href="javascript:;" onclick="preview();"><span></span>预览</a>
  162. </div>
  163. <div class="l-bar-separator"></div>
  164. <div class="group">
  165. <a class="link back" href="edit.ht?id=${sysWordTemplate.id}"><span></span>上一步</a>
  166. </div>
  167. <div class="group"><a onclick="developHelp()" class="link copyTo"><span></span>帮助</a></div>
  168. </div>
  169. </div>
  170. </div>
  171. <div class="panel-body">
  172. <form id="frmWorkFlow" method="post" action="save.ht">
  173. <input type="hidden" name="tableId" value="${sysWordTemplate.tableId}" />
  174. <input type="hidden" name="id" value="${sysWordTemplate.id}" />
  175. <input type="hidden" name="name" value="${sysWordTemplate.name}" />
  176. <input type="hidden" name="alias" value="${sysWordTemplate.alias}"/>
  177. <input type="hidden" name="type" value="${sysWordTemplate.type}"/>
  178. <input type="hidden" name="dsAlias" value="${sysWordTemplate.dsAlias}">
  179. <textarea name="sql" style="display:none;">${sysWordTemplate.sql}</textarea>
  180. <input type="hidden" name="tableName" value='${sysWordTemplate.tableName}'>
  181. <div id="tab" class="panel-nav">
  182. <div id="frmDefLayout">
  183. <div position="left" title="表字段<input type='checkbox' id='insertDesc'>插入描述">
  184. <ul id="colstree" class="ztree"></ul>
  185. </div>
  186. <div id="wordEditor" position="center" style="height:100%;">
  187. <input type="hidden" name="fileId" controltype="office" value="${sysWordTemplate.fileId}" right="w" menuRight="{}" fileType="wordTemplate"/>
  188. </div>
  189. </div>
  190. </div>
  191. </form>
  192. </div>
  193. <jsp:include page="sysWordTemplateInc.jsp"></jsp:include>
  194. <div id="help_div" class="hidden" style="font-size:13px;">
  195. <table id="callCodeTable" class="table-grid table-list">
  196. <tr>
  197. <th>表格设计说明:</th>
  198. <td style="text-align: left;">
  199. 1、主子表表格各自独立,子表不能包含在主表表格中<br>
  200. 2、子表表格,必须设定第一行为标题栏<br>
  201. </td>
  202. </tr>
  203. <tr>
  204. <th>主表字段:</th>
  205. <td style="text-align: left;">
  206. 插入方式有以下2种:<br>
  207. 1、点击左侧表字段列表中的主表字段<br>
  208. 2、直接使用word书签功能,插入书签名为对应字段名的书签,若需要有多个相同字段的书签,请以_1_加数字进行区分,如:
  209. first_name, first_name_1_0,first_name_1_1等。<br><br>
  210. 分隔符为:_1_
  211. </td>
  212. </tr>
  213. <tr>
  214. <th>子表字段:</th>
  215. <td style="text-align: left;">
  216. 子表数据,需要放在table中,字段插入方式有以下2种:<br>
  217. 1、点击左侧表字段列表中的对应的子表字段,插入到对应表格最后一行<br>
  218. 2、直接在对应表格最后一行中填写,格式为:<br>
  219. 自定义表:表名_0_字段名。<br>
  220. SQL:别名_0_字段名。<br><br>
  221. 分隔符为:_0_
  222. </td>
  223. </tr>
  224. <tr>
  225. <th>复选框作用:</th>
  226. <td style="text-align: left;">
  227. 1、复选框勾选:点击字段时,则只添加节点描述。<br>
  228. 2、取消勾选:点击字段时,则按上述【主表字段】【子表字段】的规则进行添加<br>
  229. </td>
  230. </tr>
  231. </table>
  232. </div>
  233. </body>
  234. </html>