记录:解决layui table.render渲染关联数据时,若未关联到数据显示undefined
js代码,
define(["jquery", "easy-admin"], function ($, ea) {
var init = {
table_elem: '#currentTable',
table_render_id: 'currentTableRenderId',
index_url: 'peisong.zpd/index',
// export_url: 'peisong.psd/export',
show_url: 'peisong.zpd/show',
setCar_url: 'peisong.zpd/setCar',
confirmPs_url: 'peisong.zpd/confirmPs',
};
var Controller = {
index: function () {
ea.table.render({
init: init,
toolbar:['refresh',
// 'export',
[{
title: '设置司机/车辆',
text: '设置司机/车辆',
url: init.setCar_url,
method:'open',
auth: 'setCar',
class: 'layui-btn layui-bg-blue layui-btn-sm create_apple',
icon: 'fa fa-edit',
extend: 'data-full="true"',
checkbox:true,
}],
[{
title: '确认对选中行数据执行发车确认?',
text: '发车确认',
url: init.confirmPs_url,
method:'request',
auth: 'confirmPs',
class: 'layui-btn layui-btn-success layui-btn-sm create_apple',
icon: 'fa fa-caret-square-o-right',
extend: 'data-full="false"',
checkbox:true,
}],
],
cols: [[
{fixed: 'left',type: "checkbox"},
{field: 'id', width: 60, title: 'ID', hide:false,search: false},
{field: 'zp_order', minWidth: 210, title: '载配单号'},
{field: 'order_number', minWidth: 120, title: '配送单个数', search: false},
{field: 'goods_number', minWidth: 80, title: '品种数', search: false},
{field: 'goods_account', minWidth: 80, title: '总数量', search: false},
{field: 'status', title: '状态', minWidth: 120, search: 'select', selectList: {1: '待发车',2: '已发车'}},
{field: 'supplier.name', minWidth: 200, title: '承运商', templet: function (d,value) {
if(d.supplier){
return d.supplier.name;
}else{
return '';
}
}},
{field: 'driver.realname', minWidth: 100, title: '司机', templet: function (d,value) {
if(d.driver){
return d.driver.realname;
}else{
return '';
}
}},
{field: 'systemCar.brand_model', minWidth: 130, title: '车辆', templet: function (d,value) {
if(d.systemCar){
return d.systemCar.brand_model;
}else{
return '';
}
}},
{field: 'freight_price', minWidth: 150, title: '运费(平台应付)', search: false},
{field: 'other_price', minWidth: 100, title: '其他费用', search: false},
{field: 'start_time', minWidth: 180, title: '开始配送时间', search: 'range'},
// {field: 'end_time', minWidth: 180, title: '预计到达时间', search: 'range'},
{field: 'create_type', title: '创建类型', minWidth: 100, search: 'select', selectList: {0: '手动', 1: '接口'}},
{field: 'create_people', minWidth: 80, title: '创建人', search: false},
{field: 'create_time', minWidth: 160, title: '创建时间', search: 'range'},
{field: 'update_people', minWidth: 100, title: '最后修改人', search: false},
{field: 'update_time', minWidth: 160, title: '最后修改时间', search: false},
{field: 'remark', minWidth: 80, title: '备注', search: false},
{
fixed: 'right',
width: 80,
title: '操作',
templet: ea.table.tool,
operat: [
[{
text: '查看',
url: init.show_url,
method: 'open',
auth: 'show',
class: 'layui-btn layui-btn-normal layui-btn-xs',
extend: 'data-full="true"',
}],
]
}
]],
text: {none: '无数据'}
});
ea.listen();
},
show: function () {
ea.listen();
},
setCar:function() {
ea.listen();
},
};
return Controller;
});
以上supplier.name、driver.realname、systemCar.brand_model三列为关联数据渲染。