autoFormDb-add.vm 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  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"></link>
  14. <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/icons.css"></link>
  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. <link rel="stylesheet" href="plug-in/Validform/css/metrole/style.css" type="text/css" />
  29. <link rel="stylesheet" href="plug-in/Validform/css/metrole/tablefrom.css" type="text/css" />
  30. <script type="text/javascript" src="plug-in/Validform/js/Validform_v5.3.1_min_zh-cn.js"></script>
  31. <script type="text/javascript" src="plug-in/Validform/js/Validform_Datatype_zh-cn.js"></script>
  32. <script type="text/javascript" src="plug-in/Validform/js/datatype_zh-cn.js"></script>
  33. <SCRIPT type="text/javascript" src="plug-in/Validform/plugin/passwordStrength/passwordStrength-min.js"></SCRIPT>
  34. <script type="text/javascript" src = "content/autoform/autoFormDb.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(".tabs-wrap").css('width', '100%');
  43. });
  44. jQuery(function() {
  45. jQuery("#autoFormDbField").load("autoFormDbController.do?autoFormDbFieldList_vm&id=${autoFormDbPage.id}");
  46. jQuery("#autoFormParam").load("autoFormDbController.do?autoFormParamList_vm&id=${autoFormDbPage.id}");
  47. jQuery("#autoFormDbFieldForTable").load("autoFormDbController.do?autoFormDbFieldForTableList_vm&id=${autoFormDbPage.id}");
  48. });
  49. jQuery(function() {
  50. hideDataSourceAndDataTable();
  51. jQuery("input[name='dbType']").change(function() {
  52. jQuery(".formdbdiv").hide();
  53. jQuery("#" + jQuery(this).val() + "_div").show();
  54. hideDataSourceAndDataTable();
  55. });
  56. });
  57. function hideDataSourceAndDataTable() {
  58. var checkedVal = jQuery("input[name='dbType']:checked").val();
  59. if (checkedVal == 'table') {
  60. jQuery("#dataSourceTr").hide();
  61. } else {
  62. jQuery("#dataSourceTr").show();
  63. }
  64. }
  65. function setDataSourceVal() {
  66. var checkedVal = jQuery("input[name='dbType']:checked").val();
  67. if (checkedVal == 'table') {
  68. jQuery("#tbDbKey").val(jQuery("#dbKey").find("option:selected").val());
  69. jQuery("#tbDbTableName").val(jQuery("#dbTableName").find("option:selected").val());
  70. }
  71. }
  72. jQuery(function() {
  73. jQuery("#formobj").Validform({
  74. tiptype: 3,
  75. btnSubmit: "#btn_sub",
  76. btnReset: "#btn_reset",
  77. ajaxPost: true,
  78. usePlugin: {
  79. passwordstrength: {
  80. minLen: 6,
  81. maxLen: 18,
  82. trigger: function(obj, error) {
  83. if (error) {
  84. obj.parent().next().find(".Validform_checktip").show();
  85. obj.find(".passwordStrength").hide();
  86. } else {
  87. jQuery(".passwordStrength").show();
  88. obj.parent().next().find(".Validform_checktip").hide();
  89. }
  90. }
  91. }
  92. },
  93. callback: function(data) {
  94. var win = frameElement.api.opener;
  95. if (data.success == true) {
  96. frameElement.api.close();
  97. win.tip(data.msg);
  98. } else {
  99. if (data.responseText == '' || data.responseText == undefined) {
  100. jQuery.messager.alert('错误', data.msg);
  101. jQuery.Hidemsg();
  102. } else {
  103. try {
  104. var emsg = data.responseText.substring(data.responseText.indexOf('错误描述'), data.responseText.indexOf('错误信息'));
  105. jQuery.messager.alert('错误', emsg);
  106. jQuery.Hidemsg();
  107. } catch(ex) {
  108. jQuery.messager.alert('错误', data.responseText + "");
  109. jQuery.Hidemsg();
  110. }
  111. }
  112. return false;
  113. }
  114. win.reloadTable();
  115. }
  116. });
  117. });
  118. </script>
  119. </head>
  120. <body style="overflow-x: hidden;">
  121. <form id="formobj" action="autoFormDbController.do?doAdd" name="formobj" method="post">
  122. <input type="hidden" id="btn_sub" class="btn_sub" />
  123. <input id="id" name="id" type="hidden" value="$!{autoFormDbPage.id}" />
  124. <input id="createName" name="createName" type="hidden" value="$!{autoFormDbPage.createName}" />
  125. <input id="createBy" name="createBy" type="hidden" value="$!{autoFormDbPage.createBy}" />
  126. <input id="updateName" name="updateName" type="hidden" value="$!{autoFormDbPage.updateName}" />
  127. <input id="updateBy" name="updateBy" type="hidden" value="$!{autoFormDbPage.updateBy}" />
  128. <input id="sysOrgCode" name="sysOrgCode" type="hidden" value="$!{autoFormDbPage.sysOrgCode}" />
  129. <input id="sysCompanyCode" name="sysCompanyCode" type="hidden" value="$!{autoFormDbPage.sysCompanyCode}" />
  130. <input id="createDate" name="createDate" type="hidden" value="$!{autoFormDbPage.createDate}" />
  131. <input id="updateDate" name="updateDate" type="hidden" value="$!{autoFormDbPage.updateDate}" />
  132. <input id="autoFormId" name="autoFormId" type="hidden" value="$!{autoFormDbPage.autoFormId}" />
  133. <table cellpadding="0" cellspacing="1" class="formtable">
  134. <tr>
  135. <td align="center" width="100px">
  136. <label class="Validform_label">数据源编码:</label></td>
  137. <td class="value">
  138. <input id="dbName" name="dbName" type="text" style="width: 150px" ajaxurl="autoFormDbController.do?checkDbName" class="inputxt" errorMsg="不能为中文" nullmsg="数据源编码不能为空!" datatype="/^[A-Za-z\d-._]+$/" />
  139. <span class="Validform_checktip"></span>
  140. </td>
  141. <td align="center" width="100px">
  142. <label class="Validform_label">数据源名称:</label></td>
  143. <td class="value" colspan="2">
  144. <input id="dbChName" name="dbChName" type="text" style="width: 150px" class="inputxt" datatype="*" nullmsg="数据源名称不能为空!" />
  145. <span class="Validform_checktip"></span>
  146. </td>
  147. </tr>
  148. <tr>
  149. <td align="center" width="100px">
  150. <label class="Validform_label">数据源类型:</label></td>
  151. <td class="value">
  152. <input type="radio" name="dbType" value="table" />数据库表
  153. <input type="radio" name="dbType" checked="checked" value="sql" />动态SQL
  154. <input type="radio" name="dbType" value="clazz" />java类
  155. <span class="Validform_checktip"></span></td>
  156. <td align="center" width="100px">
  157. <label class="Validform_label">
  158. <b>动态数据源:</b>
  159. </label>
  160. </td>
  161. <td class="value">
  162. <select id="dbKey" name="dbKey">
  163. <option value="" selected="selected">--动态数据源--</option>
  164. #if($!{dynamicDataSourceEntitys})
  165. #foreach($!{info} in $!{dynamicDataSourceEntitys})
  166. <option value="${info.dbKey}">${info.dbKey}</option>
  167. #end
  168. #end
  169. </select>
  170. <span class="Validform_checktip"></span>
  171. </td>
  172. </tr>
  173. <tr id="dataSourceTr">
  174. <td align="center">
  175. <label class="Validform_label">填报数据源:</label></td>
  176. <td class="value">
  177. <select id="tbDbKey" name="tbDbKey">
  178. <option value="" selected="selected">--平台数据源--</option>
  179. #if($!{dynamicDataSourceEntitys})
  180. #foreach($!{info} in $!{dynamicDataSourceEntitys})
  181. <option value="${info.dbKey}">${info.dbKey}</option>
  182. #end
  183. #end
  184. </select>
  185. <span class="Validform_checktip"></span>
  186. </td>
  187. <td align="center">
  188. <label class="Validform_label">填报数据库表:</label></td>
  189. <td class="value">
  190. <select id="tbDbTableName" name="tbDbTableName">
  191. <option value="">--请选择--</option>
  192. #if($!{tableNames})
  193. #foreach($!{info} in $!{tableNames})
  194. <option value="${info}">${info}</option>
  195. #end
  196. #end
  197. </select>
  198. <span class="Validform_checktip"></span>
  199. </td>
  200. <td class="value"></td>
  201. </tr>
  202. </table>
  203. <div style="margin-top: 20px;border: 1px solid #E6E6E6;display: none" id="table_div" class="formdbdiv">
  204. <table cellpadding="0" cellspacing="1" class="formtable">
  205. <tr>
  206. <td align="right">
  207. <label class="Validform_label">数据源:</label></td>
  208. <td class="value">
  209. <select id="dbKey" name="dbKey">
  210. <option value="">平台数据源</option>
  211. #if($!{dynamicDataSourceEntitys})
  212. #foreach($!{info} in $!{dynamicDataSourceEntitys})
  213. <option value="${info.dbKey}">${info.dbKey}</option>
  214. #end
  215. #end
  216. </select>
  217. <span class="Validform_checktip"></span>
  218. </td>
  219. <td align="right">
  220. <label class="Validform_label">数据库表名:</label></td>
  221. <td class="value">
  222. <select id="dbTableName" name="dbTableName">
  223. #if($!{tableNames})
  224. #foreach($!{info} in $!{tableNames})
  225. <option value="${info}">${info}</option>
  226. #end
  227. #end
  228. </select>
  229. <span class="Validform_checktip"></span>
  230. </td>
  231. <td class="value"></td>
  232. </tr>
  233. <tr>
  234. <td class="value" colspan="5">
  235. <div style="width:100%;height:100%" title="表单数据表" id="autoFormDbFieldForTable"></div>
  236. </td>
  237. </tr>
  238. </table>
  239. </div>
  240. <div style="margin-top: 5px;border: 1px solid #E6E6E6" id="sql_div" class="formdbdiv">
  241. <table cellpadding="0" cellspacing="1" style="width: 100%">
  242. <tr>
  243. <td align="right" width="95px">
  244. <label class="Validform_label">动态查询SQ:</label>
  245. </td>
  246. <td class="value" colspan="3" align="center">
  247. <span id="dbDynSqlButton"></span>
  248. </td>
  249. </tr>
  250. <tr>
  251. <td class="value" colspan="4">
  252. <div style="width:100%;border: 1px solid #E6E6E6">
  253. <textarea id="dbDynSql" style="width:99%;border-style: inset;" class="inputxt" rows="10" name="dbDynSql"></textarea>
  254. <p>
  255. &nbsp;&nbsp;&nbsp;&nbsp;您可以键入“”作为一个参数,这里abc是参数的名称。例如:<br/>
  256. &nbsp;&nbsp;&nbsp;&nbsp;select * from table where id = ${abc}。<br/>
  257. &nbsp;&nbsp;&nbsp;&nbsp;select * from table where id = '${abc}'(如果id字段为字符串类型)
  258. </p>
  259. </div>
  260. </td>
  261. </tr>
  262. <tr>
  263. <td class="value" colspan="4">
  264. <fieldset style="border: 1px solid #E6E6E6;">
  265. <legend>查询参数</legend>
  266. <div style="width:100%;height:100%" title="form.db.query.param" id="autoFormParam"></div>
  267. </fieldset>
  268. </td>
  269. </tr>
  270. <tr>
  271. <td class="value" colspan="4">
  272. <fieldset style="border: 1px solid #E6E6E6;">
  273. <legend>查询数据列</legend>
  274. <div style="width:100%;height:100%" title="form.db.query.data.column" id="autoFormDbField"></div>
  275. </fieldset>
  276. </td>
  277. </tr>
  278. </table>
  279. </div>
  280. <div style="margin-top: 5px;border: 1px solid #E6E6E6;display: none" id="clazz_div" class="formdbdiv">JAVA类配置</div>
  281. </form>
  282. <!-- 添加 附表明细 模版 -->
  283. <table style="display:none">
  284. <tbody id="add_autoFormDbField_table_template">
  285. <tr>
  286. <td align="center">
  287. <div style="width: 40px;" name="xh"></div>
  288. </td>
  289. <td align="center">
  290. <input style="width:20px;" type="checkbox" name="ck" />
  291. </td>
  292. <td align="left">
  293. <input name="autoFormDbFieldList[#index#].fieldName" maxlength="32" type="text" class="inputxt" style="width:120px;">
  294. </td>
  295. <td align="left">
  296. <input name="autoFormDbFieldList[#index#].fieldText" maxlength="50" type="text" class="inputxt" style="width:120px;">
  297. </td>
  298. <td align="center">
  299. <div style="width: 50px;" align="center">[
  300. <a name="delAutoFormDbFieldOneBtn" href="javascript:void(0)" onclick="deleteOne(this)">删除</a>]
  301. </div>
  302. </td>
  303. </tr>
  304. </tbody>
  305. <tbody id="add_autoFormParam_table_template">
  306. <tr>
  307. <td align="center">
  308. <div style="width: 40px;" name="xh"></div>
  309. </td>
  310. <td align="center">
  311. <input style="width:20px;" type="checkbox" name="ck" />
  312. </td>
  313. <td align="left">
  314. <input name="autoFormParamList[#index#].paramName" maxlength="32" type="text" class="inputxt" style="width:120px;" datatype="*">
  315. <label class="Validform_label" style="display: none;">参数</label>
  316. </td>
  317. <td align="left">
  318. <input name="autoFormParamList[#index#].paramDesc" maxlength="32" type="text" class="inputxt" style="width:120px;">
  319. <label class="Validform_label" style="display: none;">参数文本</label>
  320. </td>
  321. <td align="left">
  322. <input name="autoFormParamList[#index#].paramValue" maxlength="32" type="text" class="inputxt" style="width:120px;">
  323. <label class="Validform_label" style="display: none;">默认值</label>
  324. </td>
  325. <td align="left">
  326. <input name="autoFormParamList[#index#].seq" maxlength="32" type="text" class="inputxt" style="width:120px;">
  327. <label class="Validform_label" style="display: none;">排序</label>
  328. </td>
  329. <td align="center">
  330. <div style="width: 50px;" align="center">[
  331. <a class="delAutoFormParamOneBtn" href="javascript:void(0)" onclick="deleteOne(this)">删除</a>]
  332. </div>
  333. </td>
  334. </tr>
  335. </tbody>
  336. <tbody id="add_autoFormDbFieldForTable_table_template">
  337. <tr>
  338. <td align="center">
  339. <div style="width: 40px;" name="xh"></div>
  340. </td>
  341. <td align="center">
  342. <input style="width:20px;" type="checkbox" name="ck" />
  343. </td>
  344. <td align="left">
  345. <input name="autoFormDbFieldList[#index#].fieldName" maxlength="32" type="text" class="inputxt" style="width:120px;">
  346. </td>
  347. <td align="left">
  348. <input name="autoFormDbFieldList[#index#].fieldText" maxlength="50" type="text" class="inputxt" style="width:120px;">
  349. </td>
  350. <td align="center">
  351. <div style="width: 50px;" align="center">[
  352. <a name="delAutoFormDbFieldForTableOneBtn" href="javascript:void(0)" onclick="deleteOne(this)">删除</a>]
  353. </div>
  354. </td>
  355. </tr>
  356. </tbody>
  357. </table>
  358. </body>
  359. </html>