layUI数据表格实现合计 方式一

方式：后台获取合计数据

//渲染表格
        var renderTable = function () {
            table.render({
                elem: '#eatInfoTable',
                url: '请求路径',
                height:'full-170',
                toolbar: '#toolbarDemo',
                where: {},
                cellMinWidth: 100,
                page: true,
                limit:15,
                totalRow: true,
                cols: [[
                    {field: 'sData',  title: '日期',totalRowText: '合计'},
                    {field: 'breakfastPNum',  title: '早餐人数',totalRow: true},
                    {field: 'breakfastAmount',  title: '早餐金额（元）',totalRow: true},
                    {field: 'chineseFoodPNum',  title: '午餐人数',totalRow: true},
                    {field: 'chineseFoodAmount',  title: '午餐金额（元）',totalRow: true},
                    {field: 'dinnerPNum',  title: '晚餐人数',totalRow: true},
                    {field: 'dinnerAmount',  title: '晚餐金额（元）',totalRow: true},
                    {field: 'takeoutPNum',  title: '其它消费人数',totalRow: true},
                    {field: 'takeoutAmount',  title: '其它消费金额（元）',totalRow: true},
                    {fixed: 'right', width: 180, align: 'center', title: '操作' ,totalRow: true, templet:function(d){
                    var html = '<a class="layui-btn layui-btn-sm bg-white hover-blue" lay-event="show">查看明细</a>';

                    return html;
                    }}

                ]],done:function(res){
                    $("#totalNum").html(res.count);
                    //合计
                    let that=this;
                    var userType = $("#userType").val();
                    var queryDate = $("#queryDate").val();
                    $.get("合计数据请求路径",{userType,queryDate},function (data){
                        that.elem.next().find('.layui-table-total td[data-field="breakfastPNum"] .layui-table-cell').text(trunc(data.datas.breakfastPNumCount));
                        that.elem.next().find('.layui-table-total td[data-field="breakfastAmount"] .layui-table-cell').text(trunc(data.datas.breakfastAmountCount));
                        that.elem.next().find('.layui-table-total td[data-field="chineseFoodPNum"] .layui-table-cell').text(trunc(data.datas.chineseFoodPNumCount));
                        that.elem.next().find('.layui-table-total td[data-field="chineseFoodAmount"] .layui-table-cell').text(trunc(data.datas.chineseFoodAmountCount));
                        that.elem.next().find('.layui-table-total td[data-field="dinnerPNum"] .layui-table-cell').text(trunc(data.datas.dinnerPNumCount));
                        that.elem.next().find('.layui-table-total td[data-field="dinnerAmount"] .layui-table-cell').text(trunc(data.datas.dinnerAmountCount));
                        that.elem.next().find('.layui-table-total td[data-field="takeoutPNum"] .layui-table-cell').text(trunc(data.datas.takeoutPNumCount));
                        that.elem.next().find('.layui-table-total td[data-field="takeoutAmount"] .layui-table-cell').text(trunc(data.datas.takeoutAmountCount));
                        that.elem.next().find('.layui-table-total td[data-field="9"] .layui-table-cell').text('总额￥'+trunc(data.datas.totalAmount));
                    })
                }
            });
        }
        renderTable();

/*去除小数点*/
function trunc(val){
    return Math.floor(val);
}