外部的表格无法获取数据,检查contentType属性配置问题。
$(function() {
//初始化Table
var oTable = new TableInit();
oTable.Init();
});
var TableInit = function() {
var oTableInit = new Object();
//初始化Table
oTableInit.Init = function() {
$('#table').bootstrapTable({
url : 'list',//请求后台的URL(*)
method : 'post',//请求方式(*)
toolbar : '#toolbar',//工具按钮用哪个容器
striped : true,//是否显示行间隔色
cache : false,//是否使用缓存,默认为true,所以一般情况下需要设置一下这个属性(*)
pagination : true,//是否显示分页(*)
sortable : false,//是否启用排序
sortOrder : "asc",//排序方式
queryParams : oTableInit.queryParams,//传递参数(*)
sidePagination : "server",//分页方式:client客户端分页,server服务端分页(*)
pageNumber : 1,//初始化加载第一页,默认第一页
pageSize : 10,//每页的记录行数(*)
pageList : [ 10, 25, 50, 100 ],//可供选择的每页的行数(*)
search : true,//是否显示表格搜索,此搜索是客户端搜索,不会进服务端,所以,个人感觉意义不大
contentType : "application/x-www-form-urlencoded",
strictSearch : true,
showColumns : true,//是否显示所有的列
showRefresh : true,//是否显示刷新按钮
minimumCountColumns : 2,//最少允许的列数
clickToSelect : true,//是否启用点击选中行
height : 700,//行高,如果没有设置height属性,表格自动根据记录条数觉得表格高度
uniqueId : "id",//每一行的唯一标识,一般为主键列
showToggle : true,//是否显示详细视图和列表视图的切换按钮
cardView : false,//是否显示详细视图
detailView : false,//是否显示父子表
columns : [ {
field : 'id',
title : '编号'
}, {
field : 'name',
title : '名字'
}, {
field : 'price',
title : '价格'
}, {
field : 'operate',
title : '操作',
formatter : operateFormatter
//自定义方法,添加操作按钮
}, ],
rowStyle : function(row, index) {
var classesArr = [ 'white', 'lightblue' ];
var strclass = "";
if (index % 2 === 0) {//偶数行
strclass = classesArr[0];
} else {//奇数行
strclass = classesArr[1];
}
return {
classes : strclass
};
},//隔行变色
});
};
//得到查询的参数
oTableInit.queryParams = function(params) {
var temp = {//这里的键的名字和控制器的变量名必须一直,这边改动,控制器也需要改成一样的
limit : params.limit,//页面大小
//pageNumber: params.pageNumber,//页码
offset : params.offset
};
return temp;
};
return oTableInit;
};
function operateFormatter(value, row, index) {//赋予的参数
return [
'<a href="#" style="color:blue;" οnclick="edit(' + row.id
+ ')">编辑</a>|',
'<a href="#" style="color:red;" οnclick="del(' + row.id
+ ')">删除</a>', ].join('');
}
table-edit.js
(function($){
'use strict';
$.extend($.fn.bootstrapTable.defaults, {
editable: false
});
var BootstrapTable = $.fn.bootstrapTable.Constructor,
_init = BootstrapTable.prototype.init,
_initBody = BootstrapTable.prototype.initBody,
_onSort = BootstrapTable.prototype.onSort,
_append = BootstrapTable.prototype.append,
_initHeader = BootstrapTable.prototype.initHeader ;
//添加编辑表格默认属性,如何edit设置为false时,表示该列不可编辑
$.extend(true,BootstrapTable.COLUMN_DEFAULTS,{
edit:{
type:'text'//目前只支持 文本:text 下拉:select 日期:date
}
});
BootstrapTable.prototype.init = function () {
_init.apply(this, Array.prototype.slice.apply(arguments));
var that = this;
that.prevEditRow = null;//上一次编辑的行
that.columns = {};//列配置信息
that.insertRowVal = {};//新插入行的默认值
that.enableAppend = true;//允许添加新行
if (that.options.editable) {
var columnObj = this['getColumns']();
$.each(columnObj,function(i,obj){
$.each(obj,function(z,col){
if(!isNaN(col.fieldIndex) && col.fieldIndex >= 0){
if(col.checkbox)col.edit = false;
that.columns['column'+col.fieldIndex] = col;
that.insertRowVal[col.field] = '';
}
});
});
//this.initEdit();
}
};
/*BootstrapTable.prototype.initHeader = function(){
_initHeader.apply(this, Array.prototype.slice.apply(arguments));
this.$container.find('.fixed-table-header').addClass('success');
};*/
BootstrapTable.prototype.initBody = function () {
var that = this;
_initBody.apply(this, Array.prototype.slice.apply(arguments));
if (!that.options.editable) return;
this.initEdit();
//如果列是下拉框,则转换值为对应的文本
$.each(that.columns,function(indx,col){
if(col.edit && col.edit.type == 'select'){
col.edit = $.extend({},$.fn.bootstrapSelect.defaults,col.edit);
if(col.edit.data.length > 0){
that.$body.find('>tr').each(function(){
if(that.getData().length < 1)return true;
var rowData = that.data[$(this).data('index')];//当前点击td所在行的数据
var $td = $(this).find('td').eq(col.fieldIndex);
$.each(col.edit.data,function(i,data){
if(data[col.edit.valueField] == rowData[col.field]){
$td.html(data[col.edit.textField]);
}
});
});
}
else if(col.edit.url){
$.ajax({
url:col.edit.url,
type:'post',
data:col.edit.paramsType == 'json' ? JSON.stringify(col.edit.params) : col.edit.params,
dataType:'json',
success: function(jsonLst) {
col.edit.onLoadSuccess.call(this,jsonLst);
that.$body.find('>tr').each(function(){
if(that.getData().length < 1)return true;
var rowData = that.data[$(this).data('index')];//当前点击td所在行的数据
var $td = $(this).find('td').eq(col.fieldIndex);
$.each(jsonLst,function(i,data){
if(data[col.edit.valueField] == rowData[col.field]){
$td.html(data[col.edit.textField]);
}
});
});
col.edit.data = jsonLst;
col.edit.url = null;
},
error: function(xhr, textStatus, errorThrown){
col.edit.onLoadError.call(this);
col.edit.data = [];
col.edit.url = null;
throw col.field+' 列下拉框数据加载失败';
}
});
}
}
});
};
//根据行号删除指定行
BootstrapTable.prototype.removeRow = function (rowNum) {
var that = this;
var len = that.options.data.length;
if (isNaN(rowNum)){
return;
}
if(that.$body.find('.editable-select').data('index') != rowNum){
recover(that);
}
//删除数据
that.options.data.splice(rowNum,1);
if (len === that.options.data.length){
return;
}
var oldClass = {};//保存被标记修改的样式
that.$body.find('>tr').each(function(indx){
if($(this).hasClass('editable-modify')){
if(indx > rowNum){
oldClass[indx-1] = 'editable-modify';
}
else{
oldClass[indx] = 'editable-modify';
}
}
});
//this.prevEditRow = null;
//this.$body.find('>tr').removeClass('editable-select');
that.initBody();
//将标记改变过行的样式从新设置回去
for(var key in oldClass){
that.$body.find('>tr').eq(key).addClass(oldClass[key]);
}
//this.initEdit();
//没有数据时给提示加上样式
if(that.getData().length < 1){
that.$body.find('>tr').addClass('no-records-found');
}
};
BootstrapTable.prototype.append = function (){
var that = this;
//if(!that.enableAppend)return;
var oldClass = {};//保存被标记修改的样式
that.$body.find('>tr').each(function(indx){
if($(this).hasClass('editable-modify') || $(this).hasClass('editable-insert')){
oldClass[indx] = 'editable-modify';
}
});
arguments[0] = $.extend({},that.insertRowVal,arguments[0]);
_append.apply(this,Array.prototype.slice.apply(arguments));
if (that.options.editable){
//that.initEdit();
setTimeout(function (){
//将标记改变过行的样式从新设置回去
for(var key in oldClass){
that.$body.find('>tr').eq(key).addClass(oldClass[key]);
}
that.$body.find('>tr:last').addClass('editable-modify');
that.$body.find('>tr:last').addClass('editable-insert');//双重保险,防止在快速点击添加时,为给新增行设置editable-modify属性
that.$body.find('>tr:last').click();
},60);
}
};
BootstrapTable.prototype.onSort = function () {
_onSort.apply(this, Array.prototype.slice.apply(arguments));
var that = this;
if (that.options.editable) {
this.initEdit();
}
};
BootstrapTable.prototype.getData = function () {
return (this.searchText || this.searchCallback) ? this.data : this.options.data;
};
BootstrapTable.prototype.getColumns = function () {
return this.options.columns;
};
/**
* 获取有被修改过行的值
*/
BootstrapTable.prototype.getModiDatas = function (){
var that = this;
var datas = [];
that.$body.find('.editable-modify').each(function(){
if(that.data[$(this).data('index')]){
datas.push(that.data[$(this).data('index')]);
}
});
return datas;
};
/**
* 获取指定列的和,参数为列下标
*/
BootstrapTable.prototype.getColTotal = function (num){
var retVal = 0;
this.$body.find('>tr').each(function(){
var colNum = 0;
if($(this).hasClass('editable-select')){
colNum = $(this).find('td').eq(num).find('input').val();
}
else{
colNum = $(this).find('td').eq(num).html();
}
if(!isNaN(colNum)){//是数字才做想加
retVal += Number(colNum);
}
});
return retVal;
};
/**
* 创建可编辑表格
*/
BootstrapTable.prototype.initEdit = function(){
var that = this,
data = this.getData();
//this.$body.find('> tr').unbind('click').on('click'
//this.$body.delegate('>tr','click'
this.$body.find('> tr').unbind('click').on('click',function(){
var $tr = $(this);
if($tr.hasClass('editable-select') || data.length < 1 || $tr.hasClass('no-records-found')){
return;
}
$tr.removeClass('no-records-found');
recover(that);
that.prevEditRow = $tr;
$tr.addClass('editable-select');//给当前编辑行添加样式,目前样式为空只做标识使用
that.$body.find('> tr').not(this).removeClass('editable-select');
$tr.find('td').closest('td').siblings().html(function(i,html){
initTrClick(that,this);
});
});
//鼠标点击事件
$(document).bind('mousedown',function(event){
var $target = $(event.target);
if(!($target.parents().andSelf().is(that.$body)) && !($target.parents().andSelf().is($('.datetimepicker')))){
setTimeout(function () {
recover(that);
//that.prevEditRow = null;
//that.$body.find('> tr').removeClass('editable-select');
},10);
};
});
};
$.fn.bootstrapTable.methods.push('getColumns',
'getModiDatas','removeRow','getColTotal');
/**
* 给tr添加点击事件
*/
function initTrClick(that,_this){
that.enableAppend = true;
var $td = $(_this);
var $tr = $td.parent();
var rowData = that.data[$tr.data('index')];//当前点击td所在行的数据
var tdIndex = $tr.children().index($td);//当前点击的td下标
var tdOpt = that.columns['column'+tdIndex];
if(!tdOpt.edit || typeof tdOpt.edit != 'object'){
return ;
}
$td.data('field',tdOpt.field);
if(!$td.data('oldVal')){
$td.data('oldVal',$.trim(rowData[tdOpt.field]));
}
var height = $td.innerHeight() - 3;
var width = $td.innerWidth() - 2;
$td.data('style',$td.attr('style'));//保存原来的样式
$td.attr('style','margin:0px;padding:1px!important;');
var placeholder = '';
if(tdOpt.edit.required == true){
placeholder = '必填项';
}
var value = rowData[tdOpt.field] == null || rowData[tdOpt.field] == ''?'':rowData[tdOpt.field];
$td.html('<div style="margin:0;padding:0;overflow:hidden;border:solid 0px red;height:'+(height)+'px;width:'+(width)+'px;">'
+'<input type="text" placeholder="'+placeholder+'" value="'+value+'" style="margin-left: 0px; margin-right: 0px; padding-top: 1px; padding-bottom: 1px; width:100%;height:100%">'
+'</div>');
$td.width(width);
var $input = $td.find('input');
if(!tdOpt.edit.type || tdOpt.edit.type == 'text'){
if(tdOpt.edit['click'] && typeof tdOpt.edit['click'] === 'function'){
$input.unbind('click').bind('click',function(event){
tdOpt.edit['click'].call(this,event);
});
}
if(tdOpt.edit['focus'] && typeof tdOpt.edit['focus'] === 'function'){
$input.unbind('focus').bind('focus',function(event){
tdOpt.edit['focus'].call(this,event);
});
}
$input.unbind('blur').on('blur',function(event){
if(tdOpt.edit['blur'] && typeof tdOpt.edit['blur'] === 'function'){
tdOpt.edit['blur'].call(this,event);
}
});
}
else if(tdOpt.edit.type == 'select'){
$input.bootstrapSelect(tdOpt.edit);
}
else if(tdOpt.edit.type == 'date'){
$td.html('<div style="margin:0;padding:0;overflow:hidden;border:solid 0px red;height:'+(height)+'px;width:'+(width)+'px;" class="input-group date form_datetime" data-link-field="dtp_editable_input">'
+'<input class="form-control" type="text" value="'+value+'">'
+'<span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>'
+'</div>'
+'<input type="hidden" id="dtp_editable_input" value="'+value+'"/>'
);
that.$body.find('.form_datetime').datetimepicker({
weekStart: 1,
todayBtn: 1,
autoclose: 1,
todayHighlight: 1,
startView: 2,
forceParse: 0,
language:'zh-CN',
format: 'yyyy-mm-dd hh:ii:ss',
pickerPosition: 'bottom-left',
showMeridian: 1
});
}
}
/**
* 恢复tr,使之处于不可编辑状态
*/
function recover(that){
var isModi = false;//判断行值是否变动过
if(that.prevEditRow != null){
that.prevEditRow.find('td').closest('td').siblings().html(function(i,html){
$(this).attr('style',$(this).data('style'));
var textVal = $(this).find('input[type="text"]').val();
var hiddenVal = $(this).find('input[type="hidden"]').val();
if(typeof $(this).find('input[type="text"]').bootstrapSelect('getText') != 'object'){
$(this).find('input[type="text"]').bootstrapSelect('destroy');
}
if(textVal != undefined){
if($(this).data('oldVal') != (hiddenVal?hiddenVal:$.trim(textVal)) && $(this).data('field')) {
that.data[that.prevEditRow.data('index')][$(this).data('field')] = hiddenVal?hiddenVal:$.trim(textVal);
isModi = true;
}
if(that.columns['column'+i].edit.required == true){
if(textVal == null || textVal == ''){
that.enableAppend = false;
return '<span style="color:red;">必填项不能为空</span>';
}
}
return $.trim(textVal);
}
});
//新值跟旧值不匹配证明被改过
if(isModi || that.prevEditRow.hasClass('editable-insert')){
that.prevEditRow.addClass('editable-modify');
}
else{
that.prevEditRow.removeClass('editable-modify');
}
that.prevEditRow = null;
that.$body.find('> tr').removeClass('editable-select');
}
}
})(jQuery);
哪位大神能帮忙解决下