require-table.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331
  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 top = $(that).offset().top - $(window).scrollTop();
  226. var left = $(that).offset().left - $(window).scrollLeft() - 260;
  227. if(top + 154 > $(window).height()){
  228. top = top - 154;
  229. }
  230. if($(window).width()<480){
  231. top = left = undefined;
  232. }
  233. var index = Backend.api.layer.confirm(
  234. __('Are you sure you want to delete this item?'),
  235. {icon: 3, title: __('Warning'), offset: [top, left], shadeClose: true},
  236. function () {
  237. var table = $(that).closest('table');
  238. Table.api.multi("del", row.id, table, that);
  239. Backend.api.layer.close(index);
  240. }
  241. );
  242. }
  243. }
  244. },
  245. // 单元格数据格式化
  246. formatter: {
  247. icon: function (value, row, index) {
  248. value = value.indexOf(" ") > -1 ? value : "fa fa-" + value;
  249. //渲染fontawesome图标
  250. return '<i class="' + value + '"></i> ' + value;
  251. },
  252. image: function (value, row, index) {
  253. return '<img class="img-rounded img-sm" src="' + (value.indexOf("http") === 0 ? '' : Config.upload.cdnurl) + value + '" />';
  254. },
  255. status: function (value, row, index, custom) {
  256. //颜色状态数组,可使用red/yellow/aqua/blue/navy/teal/olive/lime/fuchsia/purple/maroon
  257. var colorArr = {normal: 'success', hidden: 'grey', deleted: 'danger', locked: 'info'};
  258. //如果有自定义状态,可以按需传入
  259. if (typeof custom !== 'undefined') {
  260. colorArr = $.extend(colorArr, custom);
  261. }
  262. var color = value && typeof colorArr[value] !== 'undefined' ? colorArr[value] : 'primary';
  263. value = value[0].toUpperCase() + value.substr(1);
  264. //渲染状态
  265. var html = '<span class="text-' + color + '"><i class="fa fa-circle"></i> ' + __(value) + '</span>';
  266. return html;
  267. },
  268. url: function (value, row, index) {
  269. return '<a href="' + value + '" target="_blank" class="label bg-green">' + value + '</a>';
  270. },
  271. flag: function (value, row, index) {
  272. var flagstext = __('Flags');
  273. var flagscolor = {t: 'red', i: 'blue', r: 'green', h: 'yellow'};
  274. if (!value)
  275. return value;
  276. //渲染Flag
  277. var html = [];
  278. var arr = value.split(',');
  279. arr.forEach(function (value) {
  280. html.push('<span class="label bg-' + (typeof flagscolor[value] != 'undefined' ? flagscolor[value] : 'primary') + '">' + (typeof flagstext[value] !== 'undefined' ? flagstext[value] : '') + '</span>');
  281. });
  282. return html.join(' ');
  283. },
  284. datetime: function (value, row, index) {
  285. return value ? Moment(parseInt(value) * 1000).format("YYYY-MM-DD HH:mm:ss") : __('None');
  286. },
  287. operate: function (value, row, index, table) {
  288. var showweigh = true;
  289. var showedit = true;
  290. var showdel = true;
  291. if (typeof table != 'undefined') {
  292. var options = table.bootstrapTable('getOptions');
  293. if (options.extend.del_url == '')
  294. showdel = false;
  295. if (options.extend.edit_url == '')
  296. showedit = false;
  297. }
  298. showweigh = typeof row[Table.config.dragsortfield] != 'undefined' ? true : false;
  299. //行操作
  300. var html = [];
  301. if (showweigh)
  302. html.push('<a href="javascript:;" class="btn btn-primary btn-dragsort btn-xs"><i class="fa fa-arrows"></i></a>');
  303. if (showedit)
  304. html.push('<a href="javascript:;" class="btn btn-success btn-editone btn-xs"><i class="fa fa-pencil"></i></a>');
  305. if (showdel)
  306. html.push('<a href="javascript:;" class="btn btn-danger btn-delone btn-xs"><i class="fa fa-trash"></i></a>');
  307. return html.join(' ');
  308. }
  309. },
  310. // 获取选中的条目ID集合
  311. selectedids: function (table) {
  312. return $.map(table.bootstrapTable('getSelections'), function (row) {
  313. return row.id
  314. });
  315. },
  316. // 切换复选框状态
  317. toggleattr: function (table) {
  318. $("input[type='checkbox']", table).trigger('click');
  319. }
  320. },
  321. };
  322. return Table;
  323. });