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

Administrator

18 hours ago 03bd93bf72ea24c2134c08bff69a3671202759ff

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

@@ -16,12 +16,14 @@
                                    <div class="layui-inline">
                                        <label class="layui-form-label layui-form-label-sm">状态</label>
                                        <div class="layui-input-inline">
                                            <select name="status">
                                            <select name="state">
                                                <option value="">请选择</option>
                                                <option value="1">待支付</option>
                                                <option value="2">待使用</option>
                                                <option value="3">已使用</option>
                                                <option value="4">售后</option>
                                                <option value="5">已评价</option>
                                                <option value="7">已失效</option>
                                            </select>
                                        </div>
                                    </div>
@@ -42,6 +44,9 @@
                                </div>
                                <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>
@@ -101,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>
@@ -123,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;
@@ -218,7 +224,7 @@
                        dataType: 'json',
                        headers: { 'Content-Type': 'application/json;charset=utf-8' },
                        traditional: true,
                        data: JSON.stringify('{ids:'+ids+'}'), // 确保传递的是 JSON 格式
                        data: JSON.stringify(ids), // 确保传递的是 JSON 格式
                        success: function (response) {
                            if (response.code === 200) {
                                successCallback(response);
@@ -251,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'},
@@ -272,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});