//customer_order_all.js
layui.use(['table', 'laydate', 'element', 'form'], function () {
var $ = layui.jquery;
var element = layui.element;
var table = layui.table;
var laydate = layui.laydate;
var form = layui.form;
//点击Tab刷新表格
var currentTableID = "customerAll";
var currentTableTab = $(".layui-tab").find("[lay-id='" + currentTableID + "']");
currentTableTab.on('click', function () {
reloadPage()
localStorage.setItem(TAB, currentTableID);
layer.load(2, {
time: 500});
renderCustomerOrder();
});
//仅访问当前Tab才刷新表格
var storageTab = localStorage.getItem(TAB);
var isCurrent = $('.layui-this[lay-id="' + currentTableID + '"]').length;
if (currentTableID === storageTab || isCurrent) {
renderCustomerOrder();
}
//进入页面初始化
function renderCustomerOrder() {
table.render({
elem: '#customerAll',
url: '/order/customer/list/all',
cellMinWidth: 90,
cols: [[
{
checkbox: true},
{
field: 'id',
title: '客户订单序号',
width: 90,
align: 'center',
templet: '<d><a href="/order/customer-detail/{
{ d.id }}">{
{ FormatId(d.id) }}</a></d>'
},
{
field: 'clientId', title: '订单来源', width: 80, align: 'center', templet: function (d) {
var res = '';
if (d.clientId != "") {
res = "<span style='color: green'>外部订单</span>";
} else {
res = "<span style='color: red'>平台订单</span>";
}
return res;
}
},
{
field: 'erpPO', title: 'ERP PO', width: 80, align: 'center'},
{
field: 'status',
title: '订单状态',
width: 80,
align: 'center',
templet: '<d>{
{ formatCustomerStatus(d.status) }}</d>'
},
{
field: 'memberName', title: '下单人', width: 80, align: 'center'},
{
field: 'actualOrder', title: '实际下单人', width: 80, align: 'center'},
{
field: 'orgName', title: '下单组织', width: 100, align: 'center'},
{
field: 'pretaxTotal',
title: '未税商品合计',
width: 90,
align: 'right',
templet: '<d>{
{ FormatCurrency(d.pretaxTotal) }}</d>'
},
{
field: 'total',
title: '含税商品合计',
客户订单导出
最新推荐文章于 2022-03-07 18:41:08 发布
本文介绍如何利用jQuery和JavaScript处理客户订单数据,并实现数据导出为CSV格式的功能。通过遍历订单列表,转换为逗号分隔值,最终提供下载链接让用户可以方便地保存和分析订单信息。
摘要由CSDN通过智能技术生成