1
$result = ['total' => count($corp_today_id_new), 'rows' => $corp_today_id_new ,'extraData'=> $sumBySource ];
return json($result);
2 js
// 初始化表格
table.bootstrapTable({
url: $.fn.bootstrapTable.defaults.extend.index_url,
pk: 'id',
sortName: 'id',
fixedColumns: true,
fixedRightNumber: 1,
columns: [
[
{checkbox: true},
{field: 'date', title: '日期', formatter: Table.api.formatter.datetime, operate: 'RANGE', addclass: 'datetimerange', sortable: true},
{field: 'date_range', title: '查询日期范围', searchable:false},
{field: 'corp_name', title: __('Corp_name'), operate: 'LIKE'},
{field: 'cus_source_remark', title: __('cus_source_remark'), operate: 'LIKE'},
{field: 'oppo_api_id', title: '推广广告平台', operate: 'false',formatter: function (value,row,index) {
if(row.oppo_api_id == '1'){
return '<span style="">OPPO</span>';
}
}},
]
],
onLoadSuccess: function(data) {
// // 获取extraData并渲染
if (data.extraData) {
var html = '';
$.each(data.extraData, function(index, item) {
html += '<tr>';
// html += '<td>' + (item.date || '') + '</td>';
html += '<td>' + (index || 0) + '</td>';
html += '<td>' + (item || 0) + '</td>';
html += '</tr>';
});
$('#extraDataTable tbody').html(html);
}
}
});
3
<table id="extraDataTable" class="table">
<thead>
<tr>
<th>列表客户来源</th>
<th>列表转化量</th>
</tr>
</thead>
<tbody>
<!-- 动态内容将由JS填充 -->
</tbody>
</table>