require-table.js 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416
  1. define(['jquery', 'bootstrap', 'backend', 'toastr', 'moment', 'bootstrap-table', 'bootstrap-table-lang', 'bootstrap-table-mobile', 'bootstrap-table-export', 'bootstrap-table-commonsearch', 'bootstrap-table-template'], function ($, undefined, Backend, Toastr, Moment) {
  2. var Table = {
  3. list: {},
  4. // Bootstrap-table 基础配置
  5. defaults: {
  6. url: '',
  7. sidePagination: 'server',
  8. method: 'get',
  9. toolbar: "#toolbar",
  10. search: true,
  11. cache: false,
  12. commonSearch: true,
  13. searchFormVisible: false,
  14. titleForm: '', //为空则不显示标题,不定义默认显示:普通搜索
  15. idTable: 'commonTable',
  16. showExport: true,
  17. exportDataType: "all",
  18. exportTypes: ['json', 'xml', 'csv', 'txt', 'doc', 'excel'],
  19. pageSize: 10,
  20. pageList: [10, 25, 50, 'All'],
  21. pagination: true,
  22. clickToSelect: true,
  23. showRefresh: false,
  24. locale: 'zh-CN',
  25. showToggle: true,
  26. showColumns: true,
  27. pk: 'id',
  28. sortName: 'id',
  29. sortOrder: 'desc',
  30. paginationFirstText: __("First"),
  31. paginationPreText: __("Previous"),
  32. paginationNextText: __("Next"),
  33. paginationLastText: __("Last"),
  34. mobileResponsive: true,
  35. cardView: true,
  36. checkOnInit: true,
  37. extend: {
  38. index_url: '',
  39. add_url: '',
  40. edit_url: '',
  41. del_url: '',
  42. multi_url: '',
  43. dragsort_url: 'ajax/weigh',
  44. }
  45. },
  46. // Bootstrap-table 列配置
  47. columnDefaults: {
  48. align: 'center',
  49. valign: 'middle',
  50. },
  51. config: {
  52. firsttd: 'tbody tr td:first-child:not(:has(div.card-views))',
  53. toolbar: '.toolbar',
  54. refreshbtn: '.btn-refresh',
  55. addbtn: '.btn-add',
  56. editbtn: '.btn-edit',
  57. delbtn: '.btn-del',
  58. multibtn: '.btn-multi',
  59. disabledbtn: '.btn-disabled',
  60. editonebtn: '.btn-editone',
  61. dragsortfield: 'weigh',
  62. },
  63. api: {
  64. init: function (defaults, columnDefaults, locales) {
  65. defaults = defaults ? defaults : {};
  66. columnDefaults = columnDefaults ? columnDefaults : {};
  67. locales = locales ? locales : {};
  68. // 写入bootstrap-table默认配置
  69. $.extend(true, $.fn.bootstrapTable.defaults, Table.defaults, defaults);
  70. // 写入bootstrap-table column配置
  71. $.extend($.fn.bootstrapTable.columnDefaults, Table.columnDefaults, columnDefaults);
  72. // 写入bootstrap-table locale配置
  73. $.extend($.fn.bootstrapTable.locales[Table.defaults.locale], {
  74. formatCommonSearch: function () {
  75. return __('Common search');
  76. },
  77. formatCommonSubmitButton: function () {
  78. return __('Submit');
  79. },
  80. formatCommonResetButton: function () {
  81. return __('Reset');
  82. },
  83. formatCommonCloseButton: function () {
  84. return __('Close');
  85. },
  86. formatCommonChoose: function () {
  87. return __('Choose');
  88. }
  89. }, locales);
  90. },
  91. // 绑定事件
  92. bindevent: function (table) {
  93. //Bootstrap-table的父元素,包含table,toolbar,pagnation
  94. var parenttable = table.closest('.bootstrap-table');
  95. //Bootstrap-table配置
  96. var options = table.bootstrapTable('getOptions');
  97. //Bootstrap操作区
  98. var toolbar = $(options.toolbar, parenttable);
  99. //当刷新表格时
  100. table.on('load-error.bs.table', function (status, res) {
  101. Toastr.error(__('Unknown data format'));
  102. });
  103. //当刷新表格时
  104. table.on('refresh.bs.table', function (e, settings, data) {
  105. $(Table.config.refreshbtn, toolbar).find(".fa").addClass("fa-spin");
  106. });
  107. //当双击单元格时
  108. table.on('dbl-click-row.bs.table', function (e, row, element, field) {
  109. $(Table.config.editonebtn, element).trigger("click");
  110. });
  111. //当内容渲染完成后
  112. table.on('post-body.bs.table', function (e, settings, json, xhr) {
  113. $(Table.config.refreshbtn, toolbar).find(".fa").removeClass("fa-spin");
  114. $(Table.config.disabledbtn, toolbar).toggleClass('disabled', true);
  115. // 挺拽选择,需要重新绑定事件
  116. require(['drag', 'drop'], function () {
  117. $(Table.config.firsttd, table).drag("start", function (ev, dd) {
  118. return $('<div class="selection" />').css('opacity', .65).appendTo(document.body);
  119. }).drag(function (ev, dd) {
  120. $(dd.proxy).css({
  121. top: Math.min(ev.pageY, dd.startY),
  122. left: Math.min(ev.pageX, dd.startX),
  123. height: Math.abs(ev.pageY - dd.startY),
  124. width: Math.abs(ev.pageX - dd.startX)
  125. });
  126. }).drag("end", function (ev, dd) {
  127. $(dd.proxy).remove();
  128. });
  129. $(Table.config.firsttd, table).drop("start", function () {
  130. Table.api.toggleattr(this);
  131. }).drop(function () {
  132. Table.api.toggleattr(this);
  133. }).drop("end", function () {
  134. Table.api.toggleattr(this);
  135. });
  136. $.drop({
  137. multi: true
  138. });
  139. });
  140. });
  141. // 处理选中筛选框后按钮的状态统一变更
  142. table.on('check.bs.table uncheck.bs.table check-all.bs.table uncheck-all.bs.table fa.event.check', function () {
  143. var ids = Table.api.selectedids(table);
  144. $(Table.config.disabledbtn, toolbar).toggleClass('disabled', !ids.length);
  145. });
  146. // 刷新按钮事件
  147. $(toolbar).on('click', Table.config.refreshbtn, function () {
  148. table.bootstrapTable('refresh');
  149. });
  150. // 添加按钮事件
  151. $(toolbar).on('click', Table.config.addbtn, function () {
  152. var ids = Table.api.selectedids(table);
  153. Backend.api.open(options.extend.add_url + "/ids" + (ids.length > 0 ? '/' : '') + ids.join(","), __('Add'));
  154. });
  155. // 批量编辑按钮事件
  156. $(toolbar).on('click', Table.config.editbtn, function () {
  157. var ids = Table.api.selectedids(table);
  158. //循环弹出多个编辑框
  159. $.each(ids, function (i, j) {
  160. Backend.api.open(options.extend.edit_url + "/ids/" + j, __('Edit'));
  161. });
  162. });
  163. // 批量操作按钮事件
  164. $(toolbar).on('click', Table.config.multibtn, function () {
  165. var ids = Table.api.selectedids(table);
  166. Table.api.multi($(this).data("action"), ids, table, this);
  167. });
  168. // 批量删除按钮事件
  169. $(toolbar).on('click', Table.config.delbtn, function () {
  170. var that = this;
  171. var ids = Table.api.selectedids(table);
  172. var index = Backend.api.layer.confirm(
  173. __('Are you sure you want to delete the %s selected item?', ids.length),
  174. {icon: 3, title: __('Warning'), offset: 0, shadeClose: true},
  175. function () {
  176. Table.api.multi("del", ids, table, that);
  177. Backend.api.layer.close(index);
  178. }
  179. );
  180. });
  181. // 拖拽排序
  182. require(['dragsort'], function () {
  183. //绑定拖动排序
  184. $("tbody", table).dragsort({
  185. itemSelector: 'tr',
  186. dragSelector: "a.btn-dragsort",
  187. dragEnd: function () {
  188. var data = table.bootstrapTable('getData');
  189. var current = data[parseInt($(this).data("index"))];
  190. var options = table.bootstrapTable('getOptions');
  191. //改变的值和改变的ID集合
  192. var ids = $.map($("tbody tr:visible", table), function (tr) {
  193. return data[parseInt($(tr).data("index"))][options.pk];
  194. });
  195. var changeid = current[options.pk];
  196. var pid = typeof current.pid != 'undefined' ? current.pid : '';
  197. var params = {
  198. url: table.bootstrapTable('getOptions').extend.dragsort_url,
  199. data: {
  200. ids: ids.join(','),
  201. changeid: changeid,
  202. pid: pid,
  203. field: Table.config.dragsortfield,
  204. orderway: options.sortOrder,
  205. table: options.extend.table
  206. }
  207. };
  208. Backend.api.ajax(params, function (data) {
  209. Toastr.success(__('Operation completed'));
  210. table.bootstrapTable('refresh');
  211. });
  212. },
  213. placeHolderTemplate: ""
  214. });
  215. });
  216. $(table).on("click", "input[data-id][name='checkbox']", function (e) {
  217. table.trigger('fa.event.check');
  218. });
  219. $(table).on("click", "[data-id].btn-change", function (e) {
  220. e.preventDefault();
  221. Table.api.multi($(this).data("action") ? $(this).data("action") : '', [$(this).data("id")], table, this);
  222. });
  223. $(table).on("click", "[data-id].btn-edit", function (e) {
  224. e.preventDefault();
  225. Backend.api.open(options.extend.edit_url + "/ids/" + $(this).data("id"), __('Edit'));
  226. });
  227. $(table).on("click", "[data-id].btn-del", function (e) {
  228. e.preventDefault();
  229. var id = $(this).data("id");
  230. var that = this;
  231. var index = Backend.api.layer.confirm(
  232. __('Are you sure you want to delete this item?'),
  233. {icon: 3, title: __('Warning'), shadeClose: true},
  234. function () {
  235. Table.api.multi("del", id, table, that);
  236. Backend.api.layer.close(index);
  237. }
  238. );
  239. });
  240. var id = table.attr("id");
  241. Table.list[id] = table;
  242. return table;
  243. },
  244. // 批量操作请求
  245. multi: function (action, ids, table, element) {
  246. var options = table.bootstrapTable('getOptions');
  247. var data = element ? $(element).data() : {};
  248. var url = typeof data.url !== "undefined" ? data.url : (action == "del" ? options.extend.del_url : options.extend.multi_url);
  249. url = url + "/ids/" + ($.isArray(ids) ? ids.join(",") : ids);
  250. var params = typeof data.params !== "undefined" ? (typeof data.params == 'object' ? $.param(data.params) : data.params) : '';
  251. var options = {url: url, data: {action: action, ids: ids, params: params}};
  252. Backend.api.ajax(options, function (data) {
  253. Toastr.success(__('Operation completed'));
  254. table.bootstrapTable('refresh');
  255. });
  256. },
  257. // 单元格元素事件
  258. events: {
  259. operate: {
  260. 'click .btn-editone': function (e, value, row, index) {
  261. e.stopPropagation();
  262. var options = $(this).closest('table').bootstrapTable('getOptions');
  263. Backend.api.open(options.extend.edit_url + "/ids/" + row[options.pk], __('Edit'));
  264. },
  265. 'click .btn-delone': function (e, value, row, index) {
  266. e.stopPropagation();
  267. var that = this;
  268. var top = $(that).offset().top - $(window).scrollTop();
  269. var left = $(that).offset().left - $(window).scrollLeft() - 260;
  270. if (top + 154 > $(window).height()) {
  271. top = top - 154;
  272. }
  273. if ($(window).width() < 480) {
  274. top = left = undefined;
  275. }
  276. var index = Backend.api.layer.confirm(
  277. __('Are you sure you want to delete this item?'),
  278. {icon: 3, title: __('Warning'), offset: [top, left], shadeClose: true},
  279. function () {
  280. var table = $(that).closest('table');
  281. var options = table.bootstrapTable('getOptions');
  282. Table.api.multi("del", row[options.pk], table, that);
  283. Backend.api.layer.close(index);
  284. }
  285. );
  286. }
  287. }
  288. },
  289. // 单元格数据格式化
  290. formatter: {
  291. icon: function (value, row, index) {
  292. if (!value)
  293. return '';
  294. value = value.indexOf(" ") > -1 ? value : "fa fa-" + value;
  295. //渲染fontawesome图标
  296. return '<i class="' + value + '"></i> ' + value;
  297. },
  298. image: function (value, row, index, custom) {
  299. var classname = typeof custom !== 'undefined' ? custom : 'img-rounded img-sm';
  300. return '<img class="' + classname + '" src="' + Backend.api.cdnurl(value) + '" />';
  301. },
  302. images: function (value, row, index, custom) {
  303. var classname = typeof custom !== 'undefined' ? custom : 'img-rounded img-sm';
  304. var arr = value.split(',');
  305. var html = [];
  306. $.each(arr, function (i, value) {
  307. html.push('<img class="' + classname + '" src="' + Backend.api.cdnurl(value) + '" />');
  308. });
  309. return html.join(' ');
  310. },
  311. status: function (value, row, index, custom) {
  312. //颜色状态数组,可使用red/yellow/aqua/blue/navy/teal/olive/lime/fuchsia/purple/maroon
  313. var colorArr = {normal: 'success', hidden: 'grey', deleted: 'danger', locked: 'info'};
  314. //如果有自定义状态,可以按需传入
  315. if (typeof custom !== 'undefined') {
  316. colorArr = $.extend(colorArr, custom);
  317. }
  318. value = value.toString();
  319. var color = value && typeof colorArr[value] !== 'undefined' ? colorArr[value] : 'primary';
  320. value = value.charAt(0).toUpperCase() + value.slice(1);
  321. //渲染状态
  322. var html = '<span class="text-' + color + '"><i class="fa fa-circle"></i> ' + __(value) + '</span>';
  323. return html;
  324. },
  325. url: function (value, row, index) {
  326. return '<div class="input-group input-group-sm" style="width:250px;"><input type="text" class="form-control input-sm" value="' + value + '"><span class="input-group-btn input-group-sm"><a href="' + value + '" target="_blank" class="btn btn-default btn-sm"><i class="fa fa-link"></i></a></span></div>';
  327. },
  328. search: function (value, row, index) {
  329. return '<a href="javascript:;" class="searchit" data-field="' + this.field + '" data-value="' + value + '">' + value + '</a>';
  330. },
  331. addtabs: function (value, row, index, url) {
  332. return '<a href="' + url + '" class="addtabsit" title="' + __("Search %s", value) + '">' + value + '</a>';
  333. },
  334. flag: function (value, row, index, custom) {
  335. var colorArr = {index: 'success', hot: 'warning', recommend: 'danger', 'new': 'info'};
  336. //如果有自定义状态,可以按需传入
  337. if (typeof custom !== 'undefined') {
  338. colorArr = $.extend(colorArr, custom);
  339. }
  340. //渲染Flag
  341. var html = [];
  342. var arr = value.split(',');
  343. $.each(arr, function (i, value) {
  344. value = value.toString();
  345. if (value == '')
  346. return true;
  347. var color = value && typeof colorArr[value] !== 'undefined' ? colorArr[value] : 'primary';
  348. value = value.charAt(0).toUpperCase() + value.slice(1);
  349. html.push('<span class="label label-' + color + '">' + __(value) + '</span>');
  350. });
  351. return html.join(' ');
  352. },
  353. label: function (value, row, index, custom) {
  354. var colorArr = ['success', 'warning', 'danger', 'info'];
  355. //渲染Flag
  356. var html = [];
  357. var arr = value.split(',');
  358. $.each(arr, function (i, value) {
  359. value = value.toString();
  360. var color = colorArr[i % colorArr.length];
  361. html.push('<span class="label label-' + color + '">' + __(value) + '</span>');
  362. });
  363. return html.join(' ');
  364. },
  365. datetime: function (value, row, index) {
  366. return value ? Moment(parseInt(value) * 1000).format("YYYY-MM-DD HH:mm:ss") : __('None');
  367. },
  368. operate: function (value, row, index, table) {
  369. var showweigh = true;
  370. var showedit = true;
  371. var showdel = true;
  372. if (typeof table != 'undefined') {
  373. var options = table.bootstrapTable('getOptions');
  374. if (options.extend.del_url == '')
  375. showdel = false;
  376. if (options.extend.edit_url == '')
  377. showedit = false;
  378. }
  379. showweigh = typeof row[Table.config.dragsortfield] != 'undefined' ? true : false;
  380. //行操作
  381. var html = [];
  382. if (showweigh)
  383. html.push('<a href="javascript:;" class="btn btn-primary btn-dragsort btn-xs"><i class="fa fa-arrows"></i></a>');
  384. if (showedit)
  385. html.push('<a href="javascript:;" class="btn btn-success btn-editone btn-xs"><i class="fa fa-pencil"></i></a>');
  386. if (showdel)
  387. html.push('<a href="javascript:;" class="btn btn-danger btn-delone btn-xs"><i class="fa fa-trash"></i></a>');
  388. return html.join(' ');
  389. }
  390. },
  391. // 获取选中的条目ID集合
  392. selectedids: function (table) {
  393. var options = table.bootstrapTable('getOptions');
  394. if (options.templateView) {
  395. return $.map($("input[data-id][name='checkbox']:checked"), function (dom) {
  396. return $(dom).data("id");
  397. });
  398. } else {
  399. return $.map(table.bootstrapTable('getSelections'), function (row) {
  400. return row[options.pk];
  401. });
  402. }
  403. },
  404. // 切换复选框状态
  405. toggleattr: function (table) {
  406. $("input[type='checkbox']", table).trigger('click');
  407. }
  408. },
  409. };
  410. return Table;
  411. });