table-basic.html 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8"/>
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  6. <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  7. <title>数据表格</title>
  8. <link rel="stylesheet" href="../../../assets/libs/layui/css/layui.css"/>
  9. <link rel="stylesheet" href="../../../assets/module/admin.css?v=315" media="all"/>
  10. <!--[if lt IE 9]>
  11. <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  12. <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  13. <![endif]-->
  14. </head>
  15. <body>
  16. <!-- 加载动画 -->
  17. <div class="page-loading">
  18. <div class="ball-loader">
  19. <span></span><span></span><span></span><span></span>
  20. </div>
  21. </div>
  22. <!-- 正文开始 -->
  23. <div class="layui-fluid">
  24. <div class="layui-card">
  25. <div class="layui-card-body">
  26. <div class="layui-form toolbar">
  27. <div class="layui-form-item">
  28. <div class="layui-inline">
  29. <label class="layui-form-label w-auto">搜索:</label>
  30. <div class="layui-input-inline mr0">
  31. <input name="keyword" class="layui-input" type="text" placeholder="输入关键字"/>
  32. </div>
  33. </div>
  34. <div class="layui-inline">
  35. <button class="layui-btn icon-btn" lay-filter="formSubSearchTbBas" lay-submit>
  36. <i class="layui-icon">&#xe615;</i>搜索
  37. </button>
  38. <button id="btnExportTbBas" class="layui-btn icon-btn">
  39. <i class="layui-icon">&#xe67d;</i>导出
  40. </button>
  41. <!-- 下拉按钮 -->
  42. <div class="dropdown-menu dropdown-hover">
  43. <button class="layui-btn icon-btn">
  44. &nbsp;更多 <i class="layui-icon layui-icon-drop"></i></button>
  45. <ul class="dropdown-menu-nav">
  46. <li><a><i class="layui-icon layui-icon-edit"></i>修改用户</a></li>
  47. <li><a><i class="layui-icon layui-icon-delete"></i>删除用户</a></li>
  48. <li><a><i class="layui-icon layui-icon-print"></i>打印用户</a></li>
  49. </ul>
  50. </div>
  51. </div>
  52. </div>
  53. </div>
  54. <table class="layui-table" id="tableTbBas" lay-filter="tableTbBas"></table>
  55. </div>
  56. </div>
  57. </div>
  58. <!-- 表格操作列 -->
  59. <script type="text/html" id="tableBarTbBas">
  60. <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="edit">修改</a>
  61. <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
  62. <a class="layui-btn layui-btn-xs" data-dropdown="#dropUser{{d.LAY_INDEX}}" no-shade="true">
  63. 更多<i class="layui-icon layui-icon-drop" style="font-size: 12px;margin-right: 0;"></i></a>
  64. <!-- 下拉菜单 -->
  65. <ul class="dropdown-menu-nav dropdown-bottom-right layui-hide" id="dropUser{{d.LAY_INDEX}}">
  66. <div class="dropdown-anchor"></div>
  67. <li><a lay-event="edit2"><i class="layui-icon layui-icon-edit"></i>修改用户</a></li>
  68. <li><a lay-event="del2"><i class="layui-icon layui-icon-delete"></i>删除用户</a></li>
  69. <li><a lay-event="print2"><i class="layui-icon layui-icon-print"></i>打印用户</a></li>
  70. </ul>
  71. </script>
  72. <!-- js部分 -->
  73. <script type="text/javascript" src="../../../assets/libs/layui/layui.js"></script>
  74. <script type="text/javascript" src="../../../assets/js/common.js?v=315"></script>
  75. <script>
  76. layui.use(['layer', 'form', 'table', 'util', 'dropdown'], function () {
  77. var $ = layui.jquery;
  78. var layer = layui.layer;
  79. var form = layui.form;
  80. var table = layui.table;
  81. var util = layui.util;
  82. var dropdown = layui.dropdown;
  83. // 渲染表格
  84. var insTb = table.render({
  85. elem: '#tableTbBas',
  86. url: '../../../json/user.json',
  87. page: true,
  88. cellMinWidth: 100,
  89. cols: [[
  90. {type: 'checkbox'},
  91. {field: 'username', align: 'center', sort: true, title: '账号'},
  92. {field: 'nickName', align: 'center', sort: true, title: '用户名'},
  93. {field: 'phone', align: 'center', sort: true, title: '手机号'},
  94. {field: 'sex', align: 'center', sort: true, title: '性别'},
  95. {
  96. field: 'createTime', sort: true, align: 'center', templet: function (d) {
  97. return util.toDateString(d.createTime);
  98. }, title: '创建时间'
  99. },
  100. {
  101. field: 'state', align: 'center', sort: true, templet: function (d) {
  102. var strs = [
  103. '<span class="text-success">正常</span>',
  104. '<span class="text-danger">锁定</span>'
  105. ];
  106. return strs[d.state];
  107. }, title: '状态'
  108. },
  109. {align: 'center', toolbar: '#tableBarTbBas', title: '操作', minWidth: 200}
  110. ]]
  111. });
  112. //监听工具条
  113. table.on('tool(tableTbBas)', function (obj) {
  114. var data = obj.data; //获得当前行数据
  115. var layEvent = obj.event; //获得 lay-event 对应的值
  116. if (layEvent === 'edit') { // 查看
  117. layer.msg('点击了修改');
  118. } else if (layEvent === 'del') { // 删除
  119. layer.msg('点击了删除');
  120. } else if (layEvent === 'edit2') { // 修改2
  121. layer.msg('点击了下拉菜单修改');
  122. } else if (layEvent === 'del2') { // 删除2
  123. layer.msg('点击了下拉菜单删除');
  124. } else if (layEvent === 'print2') { // 打印2
  125. layer.msg('点击了下拉菜单打印');
  126. }
  127. dropdown.hideAll();
  128. });
  129. // 导出excel
  130. $('#btnExportTbBas').click(function () {
  131. var checkRows = table.checkStatus('tableTbBas');
  132. if (checkRows.data.length == 0) {
  133. layer.msg('请选择要导出的数据', {icon: 2});
  134. } else {
  135. table.exportFile(insTb.config.id, checkRows.data, 'xls');
  136. }
  137. });
  138. // 搜索按钮点击事件
  139. form.on('submit(formSubSearchTbBas)', function (data) {
  140. insTb.reload({where: data.field}, 'data');
  141. });
  142. });
  143. </script>
  144. </body>
  145. </html>