require-table.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335
  1. define(['jquery', 'bootstrap', 'backend', 'config', 'toastr', 'moment', 'bootstrap-table', 'bootstrap-table-lang', 'bootstrap-table-mobile', 'bootstrap-table-export', 'bootstrap-table-advancedsearch'], function ($, undefined, Backend, Config, 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. advancedSearch: true,
  12. idTable: 'advancedTable',
  13. showExport: true,
  14. pagination: true,
  15. clickToSelect: true,
  16. showRefresh: false,
  17. locale: Config.language.replace('_', '-'),
  18. showToggle: true,
  19. showColumns: true,
  20. sortName: 'id',
  21. sortOrder: 'desc',
  22. paginationFirstText: __("First"),
  23. paginationPreText: __("Previous"),
  24. paginationNextText: __("Next"),
  25. paginationLastText: __("Last"),
  26. mobileResponsive: true,
  27. cardView: true,
  28. checkOnInit: true,
  29. extend: {
  30. index_url: '',
  31. add_url: '',
  32. edit_url: '',
  33. del_url: '',
  34. multi_url: '',
  35. dragsort_url: 'ajax/weigh',
  36. }
  37. },
  38. // Bootstrap-table 列配置
  39. columnDefaults: {
  40. align: 'center',
  41. valign: 'middle',
  42. },
  43. config: {
  44. firsttd: 'tbody tr td:first-child:not(:has(div.card-views))',
  45. toolbar: '.toolbar',
  46. refreshbtn: '.btn-refresh',
  47. addbtn: '.btn-add',
  48. editbtn: '.btn-edit',
  49. delbtn: '.btn-del',
  50. multibtn: '.btn-multi',
  51. disabledbtn: '.btn-disabled',
  52. editonebtn: '.btn-editone',
  53. dragsortfield: 'weigh',
  54. },
  55. api: {
  56. init: function (defaults, columnDefaults, locales) {
  57. defaults = defaults ? defaults : {};
  58. columnDefaults = columnDefaults ? columnDefaults : {};
  59. locales = locales ? locales : {};
  60. // 写入bootstrap-table默认配置
  61. $.extend(true, $.fn.bootstrapTable.defaults, Table.defaults, defaults);
  62. // 写入bootstrap-table column配置
  63. $.extend($.fn.bootstrapTable.columnDefaults, Table.columnDefaults, columnDefaults);
  64. // 写入bootstrap-table locale配置
  65. $.extend($.fn.bootstrapTable.locales[Table.defaults.locale], {
  66. formatAdvancedSearch: function () {
  67. return __('Advanced search');
  68. },
  69. formatAdvancedSubmitButton: function () {
  70. return __("Submit");
  71. },
  72. formatAdvancedResetButton: function () {
  73. return __("Reset");
  74. },
  75. formatAdvancedCloseButton: function () {
  76. return __("Close");
  77. }
  78. }, locales);
  79. },
  80. // 绑定事件
  81. bindevent: function (table) {
  82. //Bootstrap-table的父元素,包含table,toolbar,pagnation
  83. var parenttable = table.closest('.bootstrap-table');
  84. //Bootstrap-table配置
  85. var options = table.bootstrapTable('getOptions');
  86. //Bootstrap操作区
  87. var toolbar = $(options.toolbar, parenttable);
  88. //当刷新表格时
  89. table.on('load-error.bs.table', function (status, res) {
  90. Toastr.error(__('Unknown data format'));
  91. });
  92. //当刷新表格时
  93. table.on('refresh.bs.table', function (e, settings, data) {
  94. $(Table.config.refreshbtn, toolbar).find(".fa").addClass("fa-spin");
  95. });
  96. //当双击单元格时
  97. table.on('dbl-click-row.bs.table', function (e, row, element, field) {
  98. $(Table.config.editonebtn, element).trigger("click");
  99. });
  100. //当内容渲染完成后
  101. table.on('post-body.bs.table', function (e, settings, json, xhr) {
  102. $(Table.config.refreshbtn, toolbar).find(".fa").removeClass("fa-spin");
  103. // 挺拽选择,需要重新绑定事件
  104. require(['drag', 'drop'], function () {
  105. $(Table.config.firsttd, table).drag("start", function (ev, dd) {
  106. return $('<div class="selection" />').css('opacity', .65).appendTo(document.body);
  107. }).drag(function (ev, dd) {
  108. $(dd.proxy).css({
  109. top: Math.min(ev.pageY, dd.startY),
  110. left: Math.min(ev.pageX, dd.startX),
  111. height: Math.abs(ev.pageY - dd.startY),
  112. width: Math.abs(ev.pageX - dd.startX)
  113. });
  114. }).drag("end", function (ev, dd) {
  115. $(dd.proxy).remove();
  116. });
  117. $(Table.config.firsttd, table).drop("start", function () {
  118. Table.api.toggleattr(this);
  119. }).drop(function () {
  120. Table.api.toggleattr(this);
  121. }).drop("end", function () {
  122. Table.api.toggleattr(this);
  123. });
  124. $.drop({
  125. multi: true
  126. });
  127. });
  128. });
  129. // 处理选中筛选框后按钮的状态统一变更
  130. table.on('check.bs.table uncheck.bs.table check-all.bs.table uncheck-all.bs.table', function () {
  131. $(Table.config.disabledbtn, toolbar).toggleClass('disabled', !table.bootstrapTable('getSelections').length);
  132. });
  133. // 刷新按钮事件
  134. $(toolbar).on('click', Table.config.refreshbtn, function () {
  135. table.bootstrapTable('refresh');
  136. });
  137. // 添加按钮事件
  138. $(toolbar).on('click', Table.config.addbtn, function () {
  139. var ids = Table.api.selectedids(table);
  140. Backend.api.open(options.extend.add_url + "/ids/" + ids.join(","), __('Add'));
  141. });
  142. // 编辑按钮事件
  143. $(toolbar).on('click', Table.config.editbtn, function () {
  144. var ids = Table.api.selectedids(table);
  145. //循环弹出多个编辑框
  146. $.each(ids, function (i, j) {
  147. Backend.api.open(options.extend.edit_url + "/ids/" + j, __('Edit'));
  148. });
  149. });
  150. // 批量操作按钮事件
  151. $(toolbar).on('click', Table.config.multibtn, function () {
  152. var ids = Table.api.selectedids(table);
  153. Table.api.multi($(this).data("action"), ids, table, this);
  154. });
  155. // 批量删除按钮事件
  156. $(toolbar).on('click', Table.config.delbtn, function () {
  157. var that = this;
  158. var ids = Table.api.selectedids(table);
  159. var index = Backend.api.layer.confirm(
  160. __('Are you sure you want to delete the %s selected item?', ids.length),
  161. {icon: 3, title: __('Warning'), offset: 0, shadeClose: true},
  162. function () {
  163. Table.api.multi("del", ids, table, that);
  164. Backend.api.layer.close(index);
  165. }
  166. );
  167. });
  168. // 拖拽排序
  169. require(['dragsort'], function () {
  170. //绑定拖动排序
  171. $("tbody", table).dragsort({
  172. itemSelector: 'tr',
  173. dragSelector: "a.btn-dragsort",
  174. dragEnd: function () {
  175. var data = table.bootstrapTable('getData');
  176. var current = data[parseInt($(this).data("index"))];
  177. //改变的值和改变的ID集合
  178. var ids = $.map($("tbody tr:visible", table), function (tr) {
  179. return data[parseInt($(tr).data("index"))].id;
  180. });
  181. var changeid = current.id;
  182. var pid = typeof current.pid != 'undefined' ? current.pid : '';
  183. var options = {
  184. url: table.bootstrapTable('getOptions').extend.dragsort_url,
  185. data: {
  186. ids: ids.join(','),
  187. changeid: changeid,
  188. pid: pid,
  189. field: Table.config.dragsortfield,
  190. orderway: table.bootstrapTable('getOptions').sortOrder,
  191. table: table.bootstrapTable('getOptions').extend.table
  192. }
  193. };
  194. Backend.api.ajax(options, function (content) {
  195. Toastr.success(__('Operation completed'));
  196. table.bootstrapTable('refresh');
  197. });
  198. },
  199. placeHolderTemplate: ""
  200. });
  201. });
  202. var id = table.attr("id");
  203. Table.list[id] = table;
  204. return table;
  205. },
  206. // 批量操作请求
  207. multi: function (action, ids, table, element) {
  208. var options = table.bootstrapTable('getOptions');
  209. var url = action == "del" ? options.extend.del_url : options.extend.multi_url;
  210. url = url + "/ids/" + ($.isArray(ids) ? ids.join(",") : ids);
  211. var options = {url: url, data: {action: action, ids: ids, params: element ? $(element).data("params") : ''}};
  212. Backend.api.ajax(options, function (content) {
  213. Toastr.success(__('Operation completed'));
  214. table.bootstrapTable('refresh');
  215. });
  216. },
  217. // 单元格元素事件
  218. events: {
  219. operate: {
  220. 'click .btn-editone': function (e, value, row, index) {
  221. var options = $(this).closest('table').bootstrapTable('getOptions');
  222. Backend.api.open(options.extend.edit_url + "/ids/" + row.id, __('Edit'));
  223. },
  224. 'click .btn-delone': function (e, value, row, index) {
  225. var that = this;
  226. var top = $(that).offset().top - $(window).scrollTop();
  227. var left = $(that).offset().left - $(window).scrollLeft() - 260;
  228. if (top + 154 > $(window).height()) {
  229. top = top - 154;
  230. }
  231. if ($(window).width() < 480) {
  232. top = left = undefined;
  233. }
  234. var index = Backend.api.layer.confirm(
  235. __('Are you sure you want to delete this item?'),
  236. {icon: 3, title: __('Warning'), offset: [top, left], shadeClose: true},
  237. function () {
  238. var table = $(that).closest('table');
  239. Table.api.multi("del", row.id, table, that);
  240. Backend.api.layer.close(index);
  241. }
  242. );
  243. }
  244. }
  245. },
  246. // 单元格数据格式化
  247. formatter: {
  248. icon: function (value, row, index) {
  249. if (!value)
  250. return '';
  251. value = value.indexOf(" ") > -1 ? value : "fa fa-" + value;
  252. //渲染fontawesome图标
  253. return '<i class="' + value + '"></i> ' + value;
  254. },
  255. image: function (value, row, index) {
  256. return '<img class="img-rounded img-sm" src="' + (value.indexOf("http") === 0 ? '' : Config.upload.cdnurl) + value + '" />';
  257. },
  258. status: function (value, row, index, custom) {
  259. //颜色状态数组,可使用red/yellow/aqua/blue/navy/teal/olive/lime/fuchsia/purple/maroon
  260. var colorArr = {normal: 'success', hidden: 'grey', deleted: 'danger', locked: 'info'};
  261. //如果有自定义状态,可以按需传入
  262. if (typeof custom !== 'undefined') {
  263. colorArr = $.extend(colorArr, custom);
  264. }
  265. var color = value && typeof colorArr[value] !== 'undefined' ? colorArr[value] : 'primary';
  266. value = value[0].toUpperCase() + value.substr(1);
  267. //渲染状态
  268. var html = '<span class="text-' + color + '"><i class="fa fa-circle"></i> ' + __(value) + '</span>';
  269. return html;
  270. },
  271. url: function (value, row, index) {
  272. return '<a href="' + value + '" target="_blank" class="label bg-green">' + value + '</a>';
  273. },
  274. flag: function (value, row, index) {
  275. var flagstext = __('Flags');
  276. var flagscolor = {t: 'red', i: 'blue', r: 'green', h: 'yellow'};
  277. if (!value)
  278. return value;
  279. //渲染Flag
  280. var html = [];
  281. var arr = value.split(',');
  282. arr.forEach(function (value) {
  283. html.push('<span class="label bg-' + (typeof flagscolor[value] != 'undefined' ? flagscolor[value] : 'primary') + '">' + (typeof flagstext[value] !== 'undefined' ? flagstext[value] : '') + '</span>');
  284. });
  285. return html.join(' ');
  286. },
  287. datetime: function (value, row, index) {
  288. return value ? Moment(parseInt(value) * 1000).format("YYYY-MM-DD HH:mm:ss") : __('None');
  289. },
  290. operate: function (value, row, index, table) {
  291. var showweigh = true;
  292. var showedit = true;
  293. var showdel = true;
  294. if (typeof table != 'undefined') {
  295. var options = table.bootstrapTable('getOptions');
  296. if (options.extend.del_url == '')
  297. showdel = false;
  298. if (options.extend.edit_url == '')
  299. showedit = false;
  300. }
  301. showweigh = typeof row[Table.config.dragsortfield] != 'undefined' ? true : false;
  302. //行操作
  303. var html = [];
  304. if (showweigh)
  305. html.push('<a href="javascript:;" class="btn btn-primary btn-dragsort btn-xs"><i class="fa fa-arrows"></i></a>');
  306. if (showedit)
  307. html.push('<a href="javascript:;" class="btn btn-success btn-editone btn-xs"><i class="fa fa-pencil"></i></a>');
  308. if (showdel)
  309. html.push('<a href="javascript:;" class="btn btn-danger btn-delone btn-xs"><i class="fa fa-trash"></i></a>');
  310. return html.join(' ');
  311. }
  312. },
  313. // 获取选中的条目ID集合
  314. selectedids: function (table) {
  315. return $.map(table.bootstrapTable('getSelections'), function (row) {
  316. return row.id
  317. });
  318. },
  319. // 切换复选框状态
  320. toggleattr: function (table) {
  321. $("input[type='checkbox']", table).trigger('click');
  322. }
  323. },
  324. };
  325. return Table;
  326. });