feat(mall): 优化活动订单列表接口和导出功能

Administrator

1 days ago 03bd93bf72ea24c2134c08bff69a3671202759ff

 src/main/resources/templates/febs/views/modules/votesActivity/orderList.html

@@ -45,6 +45,9 @@
                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" id="reset">
                                    <i class="layui-icon">&#xe79b;</i>
                                </div>
                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" id="export" title="导出">
                                    <i class="layui-icon">&#xe67d;</i>
                                </div>
                            </div>
                        </div>
                    </form>
@@ -103,7 +106,7 @@
    1: {title: '余额', color: 'blue'},
    2: {title: '微信', color: 'green'},
    3: {title: '积分', color: 'orange'},
    4: {title: '免费', color: 'red'},
    0: {title: '免费', color: 'red'},
    }[d.payType];
    }}
    <span class="layui-badge febs-bg-{{payType.color}}">{{ payType.title }}</span>
@@ -125,6 +128,7 @@
            $view = $('#febs-activity-order'),
            $query = $view.find('#query'),
            $reset = $view.find('#reset'),
            $export= $view.find('#export'),
            $searchForm = $view.find('form'),
            sortObject = {field: 'phone', type: null},
            tableIns;
@@ -253,16 +257,19 @@
            tableIns = febs.table.init({
                elem: $view.find('table'),
                id: 'orderActivityTable',
                url: ctx + 'admin/happyActivity/activityOrderList',
                url: ctx + 'admin/happyActivity/activityOrderListV2',
                toolbar:"#orderActivityToolbar",
                defaultToolbar:[],
                cols: [[
                    {type: 'checkbox'},
                    {type: 'numbers', title: '', width: 80},
                    {title: '操作', toolbar: '#orderActivityOption', minWidth: 200, align: 'center'},
                    {field: 'name', title: '名称', minWidth: 100,align:'center'},
                    {field: 'memberName', title: '名称', minWidth: 100,align:'center'},
                    {field: 'orderNo', title: '订单编号', minWidth: 100,align:'center'},
                    {field: 'activityName', title: '活动名称', minWidth: 100,align:'center'},
                    {field: 'connectName', title: '报名人', minWidth: 100,align:'center'},
                    {field: 'connectPhone', title: '报名电话', minWidth: 100,align:'center'},
                    {field: 'connectAddress', title: '报名地址', minWidth: 100,align:'center'},
                    {field: 'price', title: '单价', minWidth: 100,align:'center'},
                    {field: 'numCnt', title: '数量', minWidth: 100,align:'center'},
                    {field: 'amount', title: '总价', minWidth: 100,align:'center'},
@@ -274,6 +281,19 @@
            });
        }

        // 导出功能
        $export.on('click', function () {
            var params = getQueryParams();
            let activityId = $searchForm.find("select[name='activityId']").val();
            //如果活动ID为空，弹出提示请选择活动
            if (activityId == null || activityId == '') {
                febs.alert.warn('请选择活动');
                return;
            }
            var queryString = Object.keys(params).map(key => `${key}=${encodeURIComponent(params[key])}`).join('&');
            window.location.href = ctx + 'admin/happyActivity/exportOrderList?' + queryString;
        });

        // 查询按钮
        $query.on('click', function () {
            var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type});