cgreportConfigHead-update.vm 12 KB

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