edit.html 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>添加数据表</title>
  6. </head>
  7. <body>
  8. <script type="text/html" id="form">
  9. <input type="hidden" name="id" value="{{ d.id }}" />
  10. <div class="mainBox">
  11. <div class="main-container">
  12. <div class="main-container">
  13. <div class="layui-form-item">
  14. <label class="layui-form-label">
  15. 表名 <text style="color:red;">*</text></label>
  16. <div class="layui-input-block">
  17. <input type="text" name="table" value="{{d.table}}" placeholder="请输入完整表名,带上表前缀" class="layui-input" lay-verify="required"
  18. autocomplete="off">
  19. </div>
  20. </div>
  21. <div class="layui-form-item">
  22. <label class="layui-form-label">
  23. 表注释 <text style="color:red;">*</text></label>
  24. <div class="layui-input-block">
  25. <input type="text" name="comment" value="{{d.comment}}" placeholder="请输入表注释" class="layui-input" lay-verify="required"
  26. autocomplete="off">
  27. </div>
  28. </div>
  29. <div class="layui-form-item">
  30. <label class="layui-form-label">
  31. 存储引擎 <text style="color:red;">*</text></label>
  32. <div class="layui-input-block">
  33. <input type="text" name="engine" value="{{d.engine}}" placeholder="请输入存储引擎,例:InnoDB,MySIAM" class="layui-input"
  34. lay-verify="required" value="InnoDB">
  35. </div>
  36. </div>
  37. <div class="layui-form-item">
  38. <label class="layui-form-label" title="字符集(排序规则)">
  39. 字符集(排序规则)<text style="color:red;">*</text></label>
  40. <div class="layui-input-block">
  41. <input type="text" name="collation" value="{{d.collation}}" placeholder="请输入字符集(排序规则),例:utf8mb4_general_ci" class="layui-input"
  42. lay-verify="required" value="utf8mb4_general_ci">
  43. </div>
  44. </div>
  45. <div class="layui-form-item">
  46. <label class="layui-form-label" title="其他设置">
  47. 其他设置</label>
  48. <div class="layui-input-block">
  49. <input type="hidden" name="is_hide_pk" value="2" />
  50. <input type="checkbox" name="is_hide_pk" id="is_hide_pk" value="1" {{# if(d.is_hide_pk==1){}}checked="checked"{{# } }}
  51. title="隐藏主键列"/>
  52. <input type="hidden" name="is_create_number" value="2" />
  53. <input type="checkbox" name="is_create_number" id="is_create_number" value="1" {{# if(d.is_create_number==1){}}checked="checked"{{# } }}
  54. title="生成序号列"/>
  55. </div>
  56. </div>
  57. </div>
  58. </div>
  59. </div>
  60. <div class="bottom">
  61. <div class="button-container">
  62. <button type="submit" class="laytp-btn laytp-btn-primary laytp-btn-sm" lay-submit="" lay-filter="laytp-form">
  63. <i class="layui-icon layui-icon-ok"></i>
  64. 提交
  65. </button>
  66. <button type="reset" class="laytp-btn laytp-btn-sm">
  67. <i class="layui-icon layui-icon-refresh"></i>
  68. 重置
  69. </button>
  70. </div>
  71. </div>
  72. </script>
  73. <form class="layui-form" lay-filter="layui-form"></form>
  74. <script>
  75. if(localStorage.getItem("staticDomain")){
  76. document.write("<link rel='stylesheet' href='" + localStorage.getItem("staticDomain") + "/component/layui/css/layui.css?v=" + localStorage.getItem("version") + "'>");
  77. document.write("<script src='" + localStorage.getItem("staticDomain") + "/component/layui/layui.js?v="+localStorage.getItem("version")+"'><\/script>");
  78. document.write("<script src='" + localStorage.getItem("staticDomain") + "/component/laytp/layuiConfig.js?v="+localStorage.getItem("version")+"'><\/script>");
  79. }else{
  80. document.write("<link rel='stylesheet' href='/static/component/layui/css/layui.css?v=" + localStorage.getItem("version") + "'>");
  81. document.write("<script src='/static/component/layui/layui.js?v="+localStorage.getItem("version")+"'><\/script>");
  82. document.write("<script src='/static/component/laytp/layuiConfig.js?v="+localStorage.getItem("version")+"'><\/script>");
  83. }
  84. </script>
  85. <script>
  86. layui.use(['laytp'],function(){
  87. let form = layui.form;
  88. let $ = layui.jquery;
  89. //获取参数ID
  90. var id = facade.getUrlParam('id');
  91. if(!id){
  92. facade.error('参数ID不能为空');
  93. return false;
  94. }
  95. //获取数据,渲染到对应的节点上
  96. facade.ajax({
  97. route: "/plugin/curd/curd.table/info",
  98. data: {id: id},
  99. successAlert: false,
  100. showLoading: true
  101. }).done(function(res){
  102. if(res.code === 0){
  103. layui.laytpl($("#form").html()).render(res.data,function(string){
  104. $("form").html(string);
  105. layui.laytpForm.render();
  106. form.render();
  107. });
  108. }
  109. });
  110. form.on('submit(laytp-form)', function(data){
  111. facade.ajax({
  112. route:'/plugin/curd/curd.table/edit',
  113. data:data.field
  114. }).done(function(res){
  115. if(res.code === 0){
  116. parent.layui.layer.close(parent.layui.layer.getFrameIndex(window.name));//关闭当前页
  117. parent.layui.table.reload("database-table");
  118. }
  119. });
  120. return false;
  121. });
  122. })
  123. </script>
  124. </body>
  125. </html>