sysWordTemplateGet.jsp 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  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/form.jsp"%>
  10. <script type="text/javascript" src="${ctx}/js/hotent/platform/form/OfficePlugin.js"></script>
  11. <script type="text/javascript" src="${ctx}/js/hotent/platform/form/OfficeControl.js"></script>
  12. <style type="text/css">
  13. .panel-body{
  14. overflow:hidden;
  15. }
  16. </style>
  17. <script type="text/javascript">
  18. var controlObj;
  19. $(window).bind("load",function(){
  20. //Office控件初始化。
  21. OfficePlugin.init();
  22. controlObj = OfficePlugin.officeObjs[0].controlObj;
  23. });
  24. $(function() {
  25. //验证代码
  26. var winHeight = $(window).height()-120;
  27. $("#frmDefLayout").ligerLayout({leftWidth : 200,height:winHeight,onHeightChanged:function(layoutHeight, diffHeight, middleHeight){
  28. }});
  29. initSqlArea();
  30. typeChange();
  31. });
  32. function initSqlArea(){
  33. var sqlJson = '${sysWordTemplate.sql}';
  34. if(!sqlJson) return;
  35. sqlJson = $.parseJSON(sqlJson);
  36. $('#main').append(sqlJson.main);
  37. var subTable = sqlJson.subTable;
  38. for(var key in subTable){
  39. var subSql = $('#subTableTemplate').find('tr').clone();
  40. $('#sqlTable').append(subSql);
  41. subSql.find('.subTableName').append(key);
  42. subSql.find('.subTableSql').append(subTable[key]);
  43. }
  44. }
  45. function typeChange(obj){
  46. var value = $('#type').val();
  47. if(!value || value=='0'){
  48. $('.sqlOption').hide();
  49. $('.formOption').show();
  50. }else {
  51. $('.sqlOption').show();
  52. $('.formOption').hide();
  53. }
  54. }
  55. </script>
  56. </head>
  57. <body style="overflow:hidden">
  58. <div>
  59. <div class="tbar-title">
  60. <span class="tbar-label">在线表单编辑</span>
  61. </div>
  62. <div class="panel-toolbar">
  63. <div class="toolBar">
  64. <div class="group">
  65. <a class="link del" href="javascript:window.onbeforeunload = null;window.close()"><span></span>关闭</a>
  66. </div>
  67. </div>
  68. </div>
  69. </div>
  70. <div class="panel-body">
  71. <form id="frmWorkFlow" method="post" action="save.ht">
  72. <input id="tableId" type="hidden" name="tableId" value="${sysWordTemplate.tableId}" />
  73. <input id="id" type="hidden" name="id" value="${sysWordTemplate.id}" />
  74. <div class="panel-nav">
  75. <table cellpadding="0" cellspacing="0" border="0" class="table-detail">
  76. <tr>
  77. <th width="200px">名称:&nbsp;</th>
  78. <td>${sysWordTemplate.name}</td>
  79. </tr>
  80. <tr>
  81. <th>别名:&nbsp;</th>
  82. <td>${sysWordTemplate.alias}</td>
  83. </tr>
  84. <tr>
  85. <th>类型:&nbsp;</th>
  86. <td>
  87. <input type="hidden" id="type" value="${sysWordTemplate.type}">
  88. <c:choose>
  89. <c:when test="${sysWordTemplate.type == 0}">自定义表</c:when>
  90. <c:otherwise>SQL</c:otherwise>
  91. </c:choose>
  92. </td>
  93. </tr>
  94. <tr class="formOption">
  95. <th>表:&nbsp;</th>
  96. <td>${sysWordTemplate.tableName}</td>
  97. </tr>
  98. <tr class="sqlOption">
  99. <th>数据源别名:&nbsp;</th>
  100. <td>
  101. <c:choose>
  102. <c:when test="${sysWordTemplate.dsAlias == 'LOCAL'}">本地数据源</c:when>
  103. <c:otherwise>
  104. <c:forEach items="${dsList}" var="ds">
  105. <c:if test="${sysWordTemplate.dsAlias eq ds.alias}">${ds.name}</c:if>
  106. </c:forEach>
  107. </c:otherwise>
  108. </c:choose>
  109. </td>
  110. </tr>
  111. <tr class="sqlOption">
  112. <th>SQL:&nbsp;</th>
  113. <td>
  114. <table cellpadding="0" cellspacing="0" border="0" class="table-detail" id="sqlTable">
  115. <tr>
  116. <th style="text-align: left;padding-left: 5px;width:120px;">别名:</th>
  117. <th style="text-align: left;padding-left: 10px;">SQL语句</th>
  118. </tr>
  119. <tr style="line-height: 30px;">
  120. <td>main</td>
  121. <td id="main"></td>
  122. </tr>
  123. </table>
  124. </td>
  125. </tr>
  126. </table>
  127. </div>
  128. <div id="tab" class="panel-nav">
  129. <div id="frmDefLayout">
  130. <div id="wordEditor" position="center" style="overflow:hidden;height:100%;">
  131. <input type="hidden" name="fileId" controltype="office" value="${sysWordTemplate.fileId}" style="height:100%;" right="w"/>
  132. </div>
  133. </div>
  134. </div>
  135. </form>
  136. </div>
  137. <table class="hidden" id="subTableTemplate">
  138. <tr class="subTableSqlTr" style="line-height: 30px;">
  139. <td class="subTableName"></td>
  140. <td class="subTableSql"></td>
  141. </tr>
  142. </table>
  143. </body>
  144. </html>