cgreportConfigHead-add.vm 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>动态报表配置抬头</title>
  5. <script type="text/javascript" src="plug-in/mutiLang/zh-cn.js"></script>
  6. <script type="text/javascript" src="plug-in/jquery/jquery-1.9.0.js"></script>
  7. <script type="text/javascript" src="plug-in/jquery/jquery.cookie.js"></script>
  8. <script type="text/javascript" src="plug-in/jquery-plugs/storage/jquery.storageapi.min.js"></script>
  9. <script type="text/javascript" src="plug-in/tools/dataformat.js"></script>
  10. <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/easyui.css" type="text/css"></link>
  11. <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/main.css" type="text/css"></link>
  12. <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/icon.css" type="text/css"></link>
  13. <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/accordion.css">
  14. <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/icons.css">
  15. <script type="text/javascript" src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
  16. <script type="text/javascript" src="plug-in/easyui/locale/zh-cn.js"></script>
  17. <script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
  18. <script type="text/javascript" src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
  19. <script type="text/javascript" src="plug-in/My97DatePicker/WdatePicker.js"></script>
  20. <link rel="stylesheet" href="plug-in/tools/css/metrole/common.css" type="text/css"></link>
  21. <link rel="stylesheet" href="plug-in/ace/css/font-awesome.css" type="text/css"></link>
  22. <script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
  23. <script type="text/javascript" src="plug-in/ace/js/bootstrap-tab.js"></script>
  24. <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
  25. <script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
  26. <script type="text/javascript" src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
  27. <script type="text/javascript" src="plug-in/tools/json2.js"></script>
  28. <script type="text/javascript" src="plug-in/Validform/js/Validform_v5.3.1_min_zh-cn.js"></script>
  29. <script type="text/javascript" src="plug-in/Validform/js/Validform_Datatype_zh-cn.js"></script>
  30. <script type="text/javascript" src="plug-in/Validform/js/datatype_zh-cn.js"></script>
  31. <script type="text/javascript" src="plug-in/Validform/plugin/passwordStrength/passwordStrength-min.js"></script>
  32. <link rel="stylesheet" href="plug-in/Validform/css/metrole/style.css" type="text/css" />
  33. <link rel="stylesheet" href="plug-in/Validform/css/metrole/tablefrom.css" type="text/css" />
  34. <script src="content/cgreport/cgreportConfigHead.js"></script>
  35. <script type="text/javascript">
  36. jQuery(document).ready(function() {
  37. jQuery('#tt').tabs({
  38. onSelect: function(title) {
  39. jQuery('#tt .panel-body').css('width', 'auto');
  40. }
  41. });
  42. jQuery('#tts').tabs({
  43. onSelect: function(title) {
  44. jQuery('#tts .panel-body').css('width', 'auto');
  45. }
  46. });
  47. });
  48. //初始化下标
  49. function resetTrNum(tableId) {
  50. jQuerytbody = jQuery("#" + tableId + "");
  51. jQuerytbody.find('>tr').each(function(i) {
  52. jQuery(':input, select,button,a', this).each(function() {
  53. var jQuerythis = jQuery(this),
  54. name = jQuerythis.attr('name'),
  55. id = jQuerythis.attr('id'),
  56. onclick_str = jQuerythis.attr('onclick'),
  57. val = jQuerythis.val();
  58. if (name != null) {
  59. if (name.indexOf("#index#") >= 0) {
  60. jQuerythis.attr("name", name.replace('#index#', i));
  61. } else {
  62. var s = name.indexOf("[");
  63. var e = name.indexOf("]");
  64. var new_name = name.substring(s + 1, e);
  65. jQuerythis.attr("name", name.replace(new_name, i));
  66. }
  67. }
  68. if (id != null) {
  69. if (id.indexOf("#index#") >= 0) {
  70. jQuerythis.attr("id", id.replace('#index#', i));
  71. } else {
  72. var s = id.indexOf("[");
  73. var e = id.indexOf("]");
  74. var new_id = id.substring(s + 1, e);
  75. jQuerythis.attr("id", id.replace(new_id, i));
  76. }
  77. }
  78. if (onclick_str != null) {
  79. if (onclick_str.indexOf("#index#") >= 0) {
  80. jQuerythis.attr("onclick", onclick_str.replace(/#index#/g, i));
  81. } else {}
  82. }
  83. });
  84. });
  85. }
  86. function decode(value, id) { //value传入值,id接受值
  87. var last = value.lastIndexOf("/");
  88. var filename = value.substring(last + 1, value.length);
  89. jQuery("#" + id).text(decodeURIComponent(filename));
  90. }
  91. </script>
  92. <script type="text/javascript">
  93. jQuery(function() {
  94. jQuery("#formobj").Validform({
  95. tiptype: 1,
  96. btnSubmit: "#btn_sub",
  97. btnReset: "#btn_reset",
  98. ajaxPost: true,
  99. usePlugin: {
  100. passwordstrength: {
  101. minLen: 6,
  102. maxLen: 18,
  103. trigger: function(obj, error) {
  104. if (error) {
  105. obj.parent().next().find(".Validform_checktip").show();
  106. obj.find(".passwordStrength").hide();
  107. } else {
  108. jQuery(".passwordStrength").show();
  109. obj.parent().next().find(".Validform_checktip").hide();
  110. }
  111. }
  112. }
  113. },
  114. callback: function(data) {
  115. var win = frameElement.api.opener;
  116. if (data.success == true) {
  117. frameElement.api.close();
  118. win.tip(data.msg);
  119. } else {
  120. if (data.responseText == '' || data.responseText == undefined) {
  121. jQuery.messager.alert('错误', data.msg);
  122. jQuery.Hidemsg();
  123. } else {
  124. try {
  125. var emsg = data.responseText.substring(data.responseText.indexOf('错误描述'), data.responseText.indexOf('错误信息'));
  126. jQuery.messager.alert('错误', emsg);
  127. jQuery.Hidemsg();
  128. } catch(ex) {
  129. jQuery.messager.alert('错误', data.responseText + "");
  130. jQuery.Hidemsg();
  131. }
  132. }
  133. return false;
  134. }
  135. win.reloadTable();
  136. }
  137. });
  138. });
  139. </script>
  140. </head>
  141. <body style="overflow-x: hidden;">
  142. <form id="formobj" action="cgreportConfigHeadController.do?doAdd" name="formobj" method="post">
  143. <input type="hidden" id="btn_sub" class="btn_sub" />
  144. <input id="id" name="id" type="hidden" value="" />
  145. <table cellpadding="0" cellspacing="1" class="formtable">
  146. <tr>
  147. <td align="right">
  148. <label class="Validform_label">编码:</label></td>
  149. <td class="value">
  150. <input id="code" name="code" type="text" style="width: 150px" class="inputxt" datatype="w1">
  151. <span class="Validform_checktip"></span>
  152. </td>
  153. <td align="right">
  154. <label class="Validform_label">名称 :</label></td>
  155. <td class="value">
  156. <input id="name" name="name" type="text" style="width: 150px" class="inputxt" datatype="*">
  157. <span class="Validform_checktip"></span>
  158. </td>
  159. <td align="right">
  160. <label class="Validform_label">数据源 :</label></td>
  161. <td class="value">
  162. #selectTableTag("db_key","db_name","t_s_data_source","dbSource","")
  163. </td>
  164. </tr>
  165. <tr>
  166. <td align="right">
  167. <label class="Validform_label">查询sql:</label></td>
  168. <td class="value" colspan="5">
  169. <textarea rows="5" cols="150" id="cgrSql" name="cgrSql" datatype="*"></textarea>
  170. <span class="Validform_checktip"></span>
  171. <p>&nbsp;&nbsp;&nbsp;&nbsp;您可以键入“”作为一个参数,这里abc是参数的名称。例如:
  172. <br/>&nbsp;&nbsp;&nbsp;&nbsp;select * from table where id = ${abc}。
  173. <br/>&nbsp;&nbsp;&nbsp;&nbsp;select * from table where id = '${abc}'(如果id字段为字符串类型)
  174. <br/>&nbsp;&nbsp;&nbsp;&nbsp;
  175. <font color="red">注:参数只支持动态报表,popup暂不支持</font>
  176. <p/>
  177. </td>
  178. </tr>
  179. <tr>
  180. <td align="right">
  181. <label class="Validform_label">描述:</label></td>
  182. <td class="value" colspan="5">
  183. <textarea rows="3" cols="150" id="content" name="content" datatype="*"></textarea>
  184. <span class="Validform_checktip"></span>
  185. </td>
  186. </tr>
  187. <tr>
  188. <td align="right">
  189. <label class="Validform_label">返回值字段:</label></td>
  190. <td class="value">
  191. <input id="returnValField" name="returnValField" type="text" style="width: 150px" class="inputxt">
  192. <span class="Validform_checktip"></span>
  193. </td>
  194. <td align="right">
  195. <label class="Validform_label">返回文本字段:</label></td>
  196. <td class="value">
  197. <input id="returnTxtField" name="returnTxtField" type="text" style="width: 150px" class="inputxt">
  198. <span class="Validform_checktip"></span>
  199. </td>
  200. <td align="right">
  201. <label class="Validform_label">返回类型:</label></td>
  202. <td class="value" colspan="2">
  203. #selectDictTag("pop_retype","popRetype","")
  204. </td>
  205. </tr>
  206. </table>
  207. <!-- update-begin--Author:xuelin Date:20170620 for:TASK #2132 【浏览器兼容问题】IE8(兼容模式)下自定义报表,列出不来-------------------- -->
  208. <div style="width: auto; ">
  209. <!-- update-end--Author:xuelin Date:20170620 for:TASK #2132 【浏览器兼容问题】IE8(兼容模式)下自定义报表,列出不来---------------------- -->
  210. <div style="width: 800px; height: 1px;"></div>
  211. <div id="ttp" tabPosition="top" border=flase style="margin:0px;padding:0px;overflow:hidden;width:auto;" class="easyui-tabs" fit="false">
  212. <div title="报表参数" href="cgreportConfigHeadController.do?cgreportConfigParamList_vm&id=" style="margin:0px;padding:0px;overflow:hidden;"></div>
  213. </div>
  214. <div id="tt" tabPosition="top" border=flase style="margin:0px;padding:0px;overflow:hidden;width:auto;" class="easyui-tabs" fit="false">
  215. <div title="动态报表配置明细" href="cgreportConfigHeadController.do?cgreportConfigItemList_vm&id=" style="margin:0px;padding:0px;overflow:hidden;"></div>
  216. </div>
  217. </div>
  218. </form>
  219. <!-- 添加 附表明细 模版 -->
  220. <table style="display: none">
  221. <tbody id="add_cgreportConfigItem_table_template">
  222. <tr>
  223. <td align="center">
  224. <input style="width: 20px;" type="checkbox" name="ck" /></td>
  225. <td align="left">
  226. <input name="cgreportConfigItemList[#index#].fieldName" maxlength="36" type="text" class="inputxt" style="width: 120px;"></td>
  227. <td align="left">
  228. <input name="cgreportConfigItemList[#index#].orderNum" maxlength="10" type="text" class="inputxt" style="width: 30px;"></td>
  229. <td align="left">
  230. <input name="cgreportConfigItemList[#index#].fieldTxt" maxlength="1000" type="text" class="inputxt" style="width: 120px;"></td>
  231. <td align="left">
  232. #selectDictTag("fieldtype","cgreportConfigItemList[#index#].fieldType","")
  233. </td>
  234. <td align="left">
  235. <select id="isShow" name="cgreportConfigItemList[#index#].isShow" style="width: 60px;">
  236. <option value="Y">显示</option>
  237. <option value="N">隐藏</option></select>
  238. </td>
  239. <td align="left">
  240. <input name="cgreportConfigItemList[#index#].fieldHref" maxlength="1000" type="text" class="inputxt" style="width: 120px;" /></td>
  241. <td align="left">
  242. #selectDictTag("searchmode","cgreportConfigItemList[#index#].SMode","")
  243. </td>
  244. <td align="left">
  245. <input name="cgreportConfigItemList[#index#].replaceVa" maxlength="36" type="text" class="inputxt" style="width: 120px;"></td>
  246. <td align="left">
  247. <input name="cgreportConfigItemList[#index#].dictCode" maxlength="36" type="text" class="inputxt" style="width: 120px;"></td>
  248. <td align="left">
  249. #selectDictTag("yesorno","cgreportConfigItemList[#index#].SFlag","")
  250. </td>
  251. </tr>
  252. </tbody>
  253. </table>
  254. <table style="display: none">
  255. <tbody id="add_cgreportConfigParam_table_template">
  256. <tr>
  257. <td align="center">
  258. <input style="width:20px;" type="checkbox" name="ck" /></td>
  259. <td align="left">
  260. <input name="cgreportConfigParamList[#index#].paramName" maxlength="32" type="text" class="inputxt" style="width:120px;" datatype="*"></td>
  261. <td align="left">
  262. <input name="cgreportConfigParamList[#index#].paramDesc" maxlength="32" type="text" class="inputxt" style="width:120px;"></td>
  263. <td align="left">
  264. <input name="cgreportConfigParamList[#index#].paramValue" maxlength="32" type="text" class="inputxt" style="width:120px;"></td>
  265. <td align="left">
  266. <input name="cgreportConfigParamList[#index#].seq" maxlength="32" type="text" class="inputxt" style="width:120px;"></td>
  267. </tr>
  268. </tbody>
  269. </table>
  270. </body>
  271. </html>