require-table.js 16 KB

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