index.html 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434
  1. <!DOCTYPE html>
  2. <html lang="zh-cn">
  3. <head>
  4. <meta charset="utf-8">
  5. <title>浏览页面</title>
  6. <link rel="stylesheet" href="/app/admin/component/pear/css/pear.css" />
  7. <link rel="stylesheet" href="/app/admin/admin/css/reset.css" />
  8. </head>
  9. <body class="pear-container">
  10. <!-- 顶部查询表单 -->
  11. <div class="layui-card">
  12. <div class="layui-card-body">
  13. <form class="layui-form top-search-from">
  14. <div class="layui-form-item">
  15. <label class="layui-form-label">类别</label>
  16. <div class="layui-input-block">
  17. <div name="category" id="category" value="" ></div>
  18. </div>
  19. </div>
  20. <div class="layui-form-item">
  21. <label class="layui-form-label">名字</label>
  22. <div class="layui-input-block">
  23. <input type="text" name="name" value="" class="layui-input">
  24. </div>
  25. </div>
  26. <div class="layui-form-item">
  27. <label class="layui-form-label">扩展名</label>
  28. <div class="layui-input-block">
  29. <input type="text" name="ext" value="" class="layui-input">
  30. </div>
  31. </div>
  32. <div class="layui-form-item">
  33. <label class="layui-form-label">上传时间</label>
  34. <div class="layui-input-block">
  35. <div class="layui-input-block" id="created_at">
  36. <input type="text" autocomplete="off" name="created_at[]" id="created_at-date-start" class="layui-input inline-block" placeholder="开始时间">
  37. -
  38. <input type="text" autocomplete="off" name="created_at[]" id="created_at-date-end" class="layui-input inline-block" placeholder="结束时间">
  39. </div>
  40. </div>
  41. </div>
  42. <div class="layui-form-item layui-inline">
  43. <label class="layui-form-label"></label>
  44. <button class="pear-btn pear-btn-md pear-btn-primary" lay-submit lay-filter="table-query">
  45. <i class="layui-icon layui-icon-search"></i>查询
  46. </button>
  47. <button type="reset" class="pear-btn pear-btn-md" lay-submit lay-filter="table-reset">
  48. <i class="layui-icon layui-icon-refresh"></i>重置
  49. </button>
  50. </div>
  51. <div class="toggle-btn">
  52. <a class="layui-hide">展开<i class="layui-icon layui-icon-down"></i></a>
  53. <a class="layui-hide">收起<i class="layui-icon layui-icon-up"></i></a>
  54. </div>
  55. </form>
  56. </div>
  57. </div>
  58. <!-- 数据表格 -->
  59. <div class="layui-card">
  60. <div class="layui-card-body">
  61. <table id="data-table" lay-filter="data-table"></table>
  62. </div>
  63. </div>
  64. <!-- 表格顶部工具栏 -->
  65. <script type="text/html" id="table-toolbar">
  66. <button class="pear-btn pear-btn-primary pear-btn-md" lay-event="add" permission="app.admin.upload.insert">
  67. <i class="layui-icon layui-icon-add-1"></i>新增
  68. </button>
  69. <button class="pear-btn pear-btn-danger pear-btn-md" lay-event="batchRemove" permission="app.admin.upload.delete">
  70. <i class="layui-icon layui-icon-delete"></i>删除
  71. </button>
  72. </script>
  73. <!-- 表格行工具栏 -->
  74. <script type="text/html" id="table-bar">
  75. <button class="pear-btn pear-btn-xs tool-btn" lay-event="edit" permission="app.admin.upload.update">编辑</button>
  76. <button class="pear-btn pear-btn-xs tool-btn" lay-event="remove" permission="app.admin.upload.delete">删除</button>
  77. </script>
  78. <script src="/app/admin/component/layui/layui.js?v=2.8.12"></script>
  79. <script src="/app/admin/component/pear/pear.js"></script>
  80. <script src="/app/admin/admin/js/permission.js"></script>
  81. <script src="/app/admin/admin/js/common.js"></script>
  82. <script>
  83. // 相关接口
  84. const PRIMARY_KEY = "id";
  85. const SELECT_API = "/app/admin/upload/select";
  86. const UPDATE_API = "/app/admin/upload/update";
  87. const DELETE_API = "/app/admin/upload/delete";
  88. const INSERT_URL = "/app/admin/upload/insert";
  89. const UPDATE_URL = "/app/admin/upload/update";
  90. // 字段 上传时间 created_at
  91. layui.use(["laydate"], function() {
  92. layui.laydate.render({
  93. elem: "#created_at",
  94. range: ["#created_at-date-start", "#created_at-date-end"],
  95. type: "datetime",
  96. });
  97. })
  98. // 字段 类别 category
  99. layui.use(["jquery", "xmSelect", "popup"], function() {
  100. layui.$.ajax({
  101. url: "/app/admin/dict/get/upload",
  102. dataType: "json",
  103. success: function (res) {
  104. let value = layui.$("#category").attr("value");
  105. let initValue = value ? value.split(",") : [];
  106. layui.xmSelect.render({
  107. el: "#category",
  108. name: "category",
  109. initValue: initValue,
  110. data: res.data,
  111. model: {"icon":"hidden","label":{"type":"text"}},
  112. clickClose: true,
  113. radio: true,
  114. });
  115. if (res.code) {
  116. layui.popup.failure(res.msg);
  117. }
  118. }
  119. });
  120. });
  121. // 表格渲染
  122. layui.use(["table", "form", "common", "popup", "util"], function() {
  123. let table = layui.table;
  124. let form = layui.form;
  125. let $ = layui.$;
  126. let common = layui.common;
  127. let util = layui.util;
  128. // 表头参数
  129. let cols = [
  130. {
  131. type: "checkbox"
  132. },{
  133. title: "主键",
  134. field: "id",
  135. width: 80,
  136. sort: true,
  137. },{
  138. title: "名字",
  139. field: "name",
  140. },{
  141. title: "文件",
  142. field: "url",
  143. templet: function (d) {
  144. if (["jpg", "jpeg", "png", "gif", "bmp", "webp", "svg"].indexOf(d.ext.toLowerCase()) !== -1) {
  145. return '<img src="' + encodeURI(d['url']) + '" style="max-width:32px;max-height:32px;" />';
  146. }
  147. return '<a href="' + encodeURI(d['url']) + '" target="_blank">' + util.escape(d['url']) + '</a>';
  148. }
  149. },{
  150. title: "管理员id",
  151. field: "admin_id",
  152. hide: true,
  153. },{
  154. title: "用户id",
  155. field: "user_id",
  156. hide: true,
  157. },{
  158. title: "文件大小",
  159. field: "file_size",
  160. templet: function (d) {
  161. return formatSize(d.file_size);
  162. }
  163. },{
  164. title: "mime类型",
  165. field: "mime_type",
  166. hide: true,
  167. },{
  168. title: "图片宽度",
  169. field: "image_width",
  170. },{
  171. title: "图片高度",
  172. field: "image_height",
  173. },{
  174. title: "扩展名",
  175. field: "ext",
  176. },{
  177. title: "存储位置",
  178. field: "storage",
  179. hide: true,
  180. },{
  181. title: "上传时间",
  182. field: "created_at",
  183. hide: true,
  184. },{
  185. title: "类别",
  186. field: "category",
  187. templet: function (d) {
  188. let field = "category";
  189. if (typeof d[field] == "undefined") return "";
  190. let items = [];
  191. layui.each((d[field] + "").split(","), function (k , v) {
  192. items.push(apiResults[field][v] || v);
  193. });
  194. return util.escape(items.join(","));
  195. }
  196. },{
  197. title: "更新时间",
  198. field: "updated_at",
  199. hide: true,
  200. },{
  201. title: "操作",
  202. toolbar: "#table-bar",
  203. align: "center",
  204. fixed: "right",
  205. width: 130,
  206. }
  207. ];
  208. // 渲染表格
  209. function render()
  210. {
  211. table.render({
  212. elem: "#data-table",
  213. url: SELECT_API,
  214. page: true,
  215. cols: [cols],
  216. skin: "line",
  217. size: "lg",
  218. toolbar: "#table-toolbar",
  219. autoSort: false,
  220. defaultToolbar: [{
  221. title: "刷新",
  222. layEvent: "refresh",
  223. icon: "layui-icon-refresh",
  224. }, "filter", "print", "exports"],
  225. done: function () {
  226. layer.photos({photos: 'div[lay-id="data-table"]', anim: 5});
  227. }
  228. });
  229. }
  230. // 获取表格中下拉或树形组件数据
  231. let apis = [];
  232. apis.push(["category", "/app/admin/dict/get/upload"]);
  233. let apiResults = {};
  234. apiResults["category"] = [];
  235. let count = apis.length;
  236. layui.each(apis, function (k, item) {
  237. let [field, url] = item;
  238. $.ajax({
  239. url: url,
  240. dateType: "json",
  241. success: function (res) {
  242. if (res.code) {
  243. return layui.popup.failure(res.msg);
  244. }
  245. function travel(items) {
  246. for (let k in items) {
  247. let item = items[k];
  248. apiResults[field][item.value] = item.name;
  249. if (item.children) {
  250. travel(item.children);
  251. }
  252. }
  253. }
  254. travel(res.data);
  255. },
  256. complete: function () {
  257. if (--count === 0) {
  258. render();
  259. }
  260. }
  261. });
  262. });
  263. if (!count) {
  264. render();
  265. }
  266. // 编辑删除或选择行事件
  267. table.on("tool(data-table)", function(obj) {
  268. if (obj.event === "remove") {
  269. remove(obj);
  270. } else if (obj.event === "edit") {
  271. edit(obj);
  272. }
  273. });
  274. // 表格顶部工具栏事件
  275. table.on("toolbar(data-table)", function(obj) {
  276. if (obj.event === "add") {
  277. add();
  278. } else if (obj.event === "refresh") {
  279. refreshTable();
  280. } else if (obj.event === "batchRemove") {
  281. batchRemove(obj);
  282. }
  283. });
  284. // 表格顶部搜索事件
  285. form.on("submit(table-query)", function(data) {
  286. table.reload("data-table", {
  287. page: {
  288. curr: 1
  289. },
  290. where: data.field
  291. })
  292. return false;
  293. });
  294. // 表格顶部搜索重置事件
  295. form.on("submit(table-reset)", function(data) {
  296. table.reload("data-table", {
  297. where: []
  298. })
  299. });
  300. // 表格排序事件
  301. table.on("sort(data-table)", function(obj){
  302. table.reload("data-table", {
  303. initSort: obj,
  304. scrollPos: "fixed",
  305. where: {
  306. field: obj.field,
  307. order: obj.type
  308. }
  309. });
  310. });
  311. // 表格新增数据
  312. let add = function() {
  313. layer.open({
  314. type: 2,
  315. title: "新增",
  316. shade: 0.1,
  317. area: [common.isModile()?"100%":"500px", common.isModile()?"100%":"380px"],
  318. content: INSERT_URL
  319. });
  320. }
  321. // 表格编辑数据
  322. let edit = function(obj) {
  323. let value = obj.data[PRIMARY_KEY];
  324. layer.open({
  325. type: 2,
  326. title: "修改",
  327. shade: 0.1,
  328. area: [common.isModile()?"100%":"500px", common.isModile()?"100%":"380px"],
  329. content: UPDATE_URL + "?" + PRIMARY_KEY + "=" + value
  330. });
  331. }
  332. // 删除一行
  333. let remove = function(obj) {
  334. return doRemove(obj.data[PRIMARY_KEY]);
  335. }
  336. // 删除多行
  337. let batchRemove = function(obj) {
  338. let checkIds = common.checkField(obj, PRIMARY_KEY);
  339. if (checkIds === "") {
  340. layui.popup.warning("未选中数据");
  341. return false;
  342. }
  343. doRemove(checkIds.split(","));
  344. }
  345. // 执行删除
  346. let doRemove = function (ids) {
  347. let data = {};
  348. data[PRIMARY_KEY] = ids;
  349. layer.confirm("确定删除?", {
  350. icon: 3,
  351. title: "提示"
  352. }, function(index) {
  353. layer.close(index);
  354. let loading = layer.load();
  355. $.ajax({
  356. url: DELETE_API,
  357. data: data,
  358. dataType: "json",
  359. type: "post",
  360. success: function(res) {
  361. layer.close(loading);
  362. if (res.code) {
  363. return layui.popup.failure(res.msg);
  364. }
  365. return layui.popup.success("操作成功", refreshTable);
  366. }
  367. })
  368. });
  369. }
  370. // 刷新表格数据
  371. window.refreshTable = function() {
  372. table.reloadData("data-table", {
  373. scrollPos: "fixed",
  374. done: function (res, curr) {
  375. if (curr > 1 && res.data && !res.data.length) {
  376. curr = curr - 1;
  377. table.reloadData("data-table", {
  378. page: {
  379. curr: curr
  380. },
  381. })
  382. }
  383. }
  384. });
  385. }
  386. // 格式化文件大小
  387. let formatSize = function(value) {
  388. if(null == value || "" === value){
  389. return "0 Bytes";
  390. }
  391. let unitArr = ["Bytes","KB","MB","GB","TB","PB","EB","ZB","YB"];
  392. let index = 0;
  393. let srcSize = parseFloat(value);
  394. index = Math.floor(Math.log(srcSize) / Math.log(1024));
  395. let size =srcSize / Math.pow(1024, index);
  396. size = size.toFixed(2);
  397. return size + unitArr[index];
  398. }
  399. })
  400. </script>
  401. </body>
  402. </html>