add.html 4.9 KB

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