define(['jquery', 'bootstrap', 'backend', 'table', 'form'], function ($, undefined, Backend, Table, Form) { var Controller = { index: function () { // 初始化表格参数配置 Table.api.init({ extend: { index_url: 'user/user/index', add_url: 'user/user/add', edit_url: 'user/user/edit', del_url: 'user/user/del', multi_url: 'user/user/multi', table: 'user', } }); var table = $("#table"); //当表格数据加载完成时 table.on('load-success.bs.table', function (e, data) { //这里可以获取从服务端获取的JSON数据 console.log(data); //这里我们手动设置底部的值 $("#total").text(data.total); }); // 初始化表格 table.bootstrapTable({ url: $.fn.bootstrapTable.defaults.extend.index_url, pk: 'id', sortName: 'user.id', exportTypes: ['excel'], exportOptions: { // type: 'excel', mso:{ // fileFormat: 'xlsx', //修复导出数字不显示为科学计数法 onMsoNumberFormat: function (cell, row, col) { return !isNaN($(cell).text())?'\\@':''; } } }, columns: [ [ {checkbox: true}, {field: 'id', title: __('Id'), sortable: true}, // {field: 'group.name', title: __('Group')}, {field: 'username', title: __('用户名'), operate:false}, {field: 'nickname', title: __('真实姓名'), operate:'LIKE'}, {field: 'password', title: __('密码'), operate:false}, {field: 'card', title: __('身份证'), operate:false}, {field: 'phone', title: __('手机号'), operate:false}, {field: 'sex', title: __('性别'), searchList: {"1":"男","0":'女'},formatter: Table.api.formatter.flag}, {field: 'work_address', title: __('工作地点'),operate:'LIKE'}, {field: 'image', title: __('头像'), operate:false, events: Table.api.events.image, formatter: Table.api.formatter.image}, // {field: 'avatar', title: __('Avatar'), events: Table.api.events.image, formatter: Table.api.formatter.image, operate: false}, // {field: 'level', title: __('Level'), operate: 'BETWEEN', sortable: true}, // {field: 'gender', title: __('Gender'), visible: false, searchList: {1: __('Male'), 0: __('Female')}}, // {field: 'score', title: __('Score'), operate: 'BETWEEN', sortable: true}, // {field: 'successions', title: __('Successions'), visible: false, operate: 'BETWEEN', sortable: true}, // {field: 'maxsuccessions', title: __('Maxsuccessions'), visible: false, operate: 'BETWEEN', sortable: true}, // {field: 'logintime', title: __('Logintime'), formatter: Table.api.formatter.datetime, operate: 'RANGE', addclass: 'datetimerange', sortable: true}, // {field: 'loginip', title: __('Loginip'), formatter: Table.api.formatter.search}, // {field: 'jointime', title: __('Jointime'), formatter: Table.api.formatter.datetime, operate: 'RANGE', addclass: 'datetimerange', sortable: true}, // {field: 'joinip', title: __('Joinip'), formatter: Table.api.formatter.search}, {field: 'id', title: __('按钮组'), table: table, events: Table.api.events.operate, buttons: [ { text: '报考科目', title: '报考科目', icon: 'fa fa-list', classname: 'btn btn-xs btn-primary btn-dialog', url: 'hobby/index1', extend: 'data-area=\'["80%","80%"]\'' }, ], operate:false, formatter: Table.api.formatter.buttons }, {field: 'studynum', title: __('学号'), operate:false}, {field: 'expirationtime', title: __('有效期'), operate:'RANGE', addclass:'datetimerange', formatter: Table.api.formatter.datetime}, {field: 'status', title: __('Status'), formatter: Table.api.formatter.status, searchList: {normal: __('Normal'), hidden: __('Hidden')}}, {field: 'mobile', title: __('注册手机号')}, {field: 'group_id', title: __('角色'), searchList: {"0":"普通用户","1":"公司用户"},formatter: Table.api.formatter.flag}, {field: 'createtime', title: __('注册时间'), formatter: Table.api.formatter.datetime, operate: 'RANGE', addclass: 'datetimerange', sortable: true}, {field: 'operate', title: __('Operate'), table: table, events: Table.api.events.operate, formatter: Table.api.formatter.operate} ] ] }); // 为表格绑定事件 Table.api.bindevent(table); }, add: function () { Controller.api.bindevent(); }, edit: function () { Controller.api.bindevent(); }, api: { bindevent: function () { Form.api.bindevent($("form[role=form]")); } } }; return Controller; });