budgetTempSheet-measure.jsp 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <!doctype html>
  4. <html>
  5. <head>
  6. <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  7. <meta charset="utf-8" />
  8. <meta name="spreadjs culture" content="zh-cn" />
  9. <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  10. <style>
  11. .sample-spreadsheets {
  12. width: calc(100% - 350px);
  13. height: 100%;
  14. overflow: hidden;
  15. float: left;
  16. }
  17. .options-container{
  18. float: right;
  19. width: 350px;
  20. padding: 12px;
  21. height: 100%;
  22. box-sizing: border-box;
  23. background: #fbfbfb;
  24. overflow: auto;
  25. }
  26. .option-row {
  27. font-size: 14px;
  28. padding: 5px;
  29. margin-top: 10px;
  30. }
  31. </style>
  32. <script>
  33. <c:if test="${periodEntity==null}">
  34. alert('${tempSheet.periodYear}年未设置预算周期,请联系管理员');
  35. history.go(-1);
  36. </c:if>
  37. </script>
  38. </head>
  39. <body style="background:#FFFFFF">
  40. <!-- <form id="form1" runat="server"> -->
  41. <div>
  42. <div id="div2">
  43. <%@include file="budgetTempSheet-buttons.jsp"%>
  44. </div>
  45. <div class="sample-tutorial" style="top: 20px;width:calc(100vw - 80px); height: calc(100vh - 120px);">
  46. <div id="ss" class="sample-spreadsheets" ></div>
  47. <div class="options-container">
  48. <div class="option-row" style="text-align:center">
  49. ${tempSheet.name}
  50. </div>
  51. <div class="option-row" id="rowInfo" style="display:none">
  52. <fieldset style="border:1px solid #666666;padding:5px">
  53. <legend>行维度</legend>
  54. <table>
  55. <tr>
  56. <td>时间维度:</td>
  57. <td>
  58. <input type="text" id="rowTimeInput" style="width: 150px;" readonly="readonly">
  59. </td>
  60. <td>
  61. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-synchronization" id="rowTimeBind" onclick="setTimeRow()">
  62. 绑定
  63. </a>
  64. </td>
  65. </tr>
  66. <tr>
  67. <td>指标维度:</td>
  68. <td><input type="text" id="rowGoalsInput" style="width: 150px;" readonly="readonly"></td>
  69. <td>
  70. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-synchronization" id="rowGoalsBind" onclick="setMeasureRow()">
  71. 绑定
  72. </a>
  73. </td>
  74. </tr>
  75. <tr>
  76. <td>含税维度:</td>
  77. <td>
  78. <input type="radio" name="includeTaxRow" value="1" onclick="setIncludeTaxRow()">含税
  79. <input type="radio" name="includeTaxRow" value="0" onclick="setIncludeTaxRow()">不含税
  80. </td>
  81. </tr>
  82. <tr>
  83. <td>预实维度:</td>
  84. <td>
  85. <input type="radio" name="expectRow" value="1" onclick="setExpectRow()">预算数
  86. <input type="radio" name="expectRow" value="0" onclick="setExpectRow()">实际数
  87. </td>
  88. </tr>
  89. <tr>
  90. <td colspan="3" align="center">
  91. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-remove" onclick="removeRowBind()">
  92. 清空行维度
  93. </a>
  94. </td>
  95. </tr>
  96. </table>
  97. </fieldset>
  98. </div>
  99. <div class="option-row" id="colInfo" style="display:none">
  100. <fieldset style="border:1px solid #666666;padding:5px">
  101. <legend>列维度</legend>
  102. <table>
  103. <tr>
  104. <td>时间维度:</td>
  105. <td>
  106. <input type="text" id="colTimeInput" style="width: 150px;" readonly="readonly">
  107. </td>
  108. <td>
  109. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-synchronization" id="colTimeBind" onclick="setTimeCol()">
  110. 绑定
  111. </a>
  112. </td>
  113. </tr>
  114. <tr>
  115. <td>指标维度:</td>
  116. <td><input type="text" id="colGoalsInput" style="width: 150px;" readonly="readonly"></td>
  117. <td>
  118. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-synchronization" id="colGoalsBind" onclick="setMeasureCol()">
  119. 绑定
  120. </a>
  121. </td>
  122. </tr>
  123. <tr>
  124. <td>含税维度:</td>
  125. <td>
  126. <input type="radio" name="includeTaxCol" value="1" onclick="setIncludeTaxCol()">含税
  127. <input type="radio" name="includeTaxCol" value="0" onclick="setIncludeTaxCol()">不含税
  128. </td>
  129. </tr>
  130. <tr>
  131. <td>预实维度:</td>
  132. <td>
  133. <input type="radio" name="expectCol" value="1" onclick="setExpectCol()">预算数
  134. <input type="radio" name="expectCol" value="0" onclick="setExpectCol()">实际数
  135. </td>
  136. </tr>
  137. <tr>
  138. <td colspan="3" align="center">
  139. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-remove" onclick="removeColBind()">
  140. 清空列维度
  141. </a>
  142. </td>
  143. </tr>
  144. </table>
  145. </fieldset>
  146. </div>
  147. <div class="option-row" id="info2" style="display:none">
  148. <fieldset style="border:1px solid #666666;padding:5px">
  149. <legend>单元格维度</legend>
  150. <table>
  151. <tr>
  152. <td>时间维度:</td>
  153. <td>
  154. <input type="text" id="timeInput" style="width: 150px;" readonly="readonly">
  155. </td>
  156. </tr>
  157. <tr>
  158. <td>指标维度:</td>
  159. <td><input type="text" id="goalsInput" style="width: 150px;" readonly="readonly"></td>
  160. </tr>
  161. <tr>
  162. <td>含税维度:</td>
  163. <td>
  164. <input type="radio" name="includeTax" value="1" disabled="disabled">含税
  165. <input type="radio" name="includeTax" value="0" disabled="disabled">不含税
  166. </td>
  167. </tr>
  168. <tr>
  169. <td>预实维度:</td>
  170. <td>
  171. <input type="radio" name="expect" value="1" disabled="disabled">预算数
  172. <input type="radio" name="expect" value="0" disabled="disabled">实际数
  173. </td>
  174. </tr>
  175. </table>
  176. </fieldset>
  177. </div>
  178. <div class="option-row" id="info3" style="display: none;">
  179. <fieldset style="border:1px solid #666666;padding:5px">
  180. <legend>单元格属性</legend>
  181. <div>只读:<span id="readOnly"></span></div>
  182. <div>数据类型:<span id="goalsDataType"></span></div>
  183. <div style="display: none;" id="controlFlagName">预算控制:<span></span></div>
  184. <div style="display: none;" id="showFuntionTxt">维度公式:<span></span></div>
  185. </fieldset>
  186. </div>
  187. </div>
  188. <!-- <div id="detail" class="options-container"> -->
  189. <!-- <div class="option-row">
  190. 操作<br/>
  191. <div class="option-row">
  192. <input id="addBackgroundColorMenuSelection" type="checkbox" />
  193. <label for="addBackgroundColorMenuSelection">Add background color menu selection</label>
  194. </div>
  195. </div> -->
  196. </div>
  197. </div>
  198. <script>
  199. var periodDetailList = [];
  200. <c:forEach items="${periodDetailList}" var="detail" varStatus="i">
  201. var detail${i.index} = {};
  202. detail${i.index}.id = '${detail.id}';
  203. detail${i.index}.name = '${detail.name}';
  204. periodDetailList.push(detail${i.index});
  205. </c:forEach>
  206. var measureDataTypeList={};
  207. <c:forEach items="${measureDataTypeList}" var="type" varStatus="i">
  208. measureDataTypeList['${type.typecode}'] ='${type.typename}';
  209. </c:forEach>
  210. var spread;
  211. </script>
  212. <script src="webpage/cn/com/lzt/budget/tempsheet/budgetTempSheet-measure.js" type="text/javascript"></script>
  213. </body>
  214. </html>