全部开发者教程

企业级在线办公系统

上个小节我们用Swagger测试了后端返回的分页数据,这节课咱们应该把分页数据显示到前端页面。违纪罚款页面以表格为主,所以排版布局较为传统,跟用户管理、部门管理页面类似。

图片描述

一、熟悉前端页面

打开amect.vue文件,还是老规矩,看视图层标签之前,咱们先来看看模型层都定义了哪些变量。

data: function() {
    return {
        dataForm: {
            name: null,
            deptId: null,
            typeId: null,
            status: null,
            date: null
        },
        deptList: [],
        amectTypeList: [],
        dataList: [],
        pageIndex: 1,
        pageSize: 10,
        totalCount: 0,
        dataListLoading: false,
        dataListSelections: [],
        dataRule: {
            name: [{ required: false, pattern: '^[\u4e00-\u9fa5]{1,10}$', message: '姓名格式错误' }]
        },
        addOrUpdateVisible: false,
        payVisible: false
    };
},

视图层里面的查询条件较多,部门列表、违纪类型列表的数据,都是要通过Ajax查询出来的,所以建议大家可以看看loadDeptList()loadAmectTypeList()函数。

<el-form :inline="true" :model="dataForm" :rules="dataRule" ref="dataForm">
    <el-form-item prop="name">
        <el-input
            v-model="dataForm.name"
            placeholder="姓名"
            size="medium"
            class="input"
            clearable="clearable"
        />
    </el-form-item>
    <el-form-item>
        <el-select
            v-model="dataForm.deptId"
            class="input"
            placeholder="部门"
            size="medium"
            clearable="clearable"
        >
            <el-option v-for="one in deptList" :label="one.deptName" :value="one.id" />
        </el-select>
    </el-form-item>
    <el-form-item>
        <el-select
            v-model="dataForm.typeId"
            class="input"
            placeholder="罚款类型"
            size="medium"
            clearable="clearable"
        >
            <el-option v-for="one in amectTypeList" :label="one.type" :value="one.id" />
        </el-select>
    </el-form-item>
    <el-form-item>
        <el-date-picker
            v-model="dataForm.date"
            type="daterange"
            range-separator="~"
            start-placeholder="开始日期"
            end-placeholder="结束日期"
            size="medium"
        ></el-date-picker>
    </el-form-item>
    <el-form-item>
        <el-select
            v-model="dataForm.status"
            class="input"
            placeholder="状态"
            size="medium"
            clearable="clearable"
        >
            <el-option label="未缴纳" value="1" />
            <el-option label="已缴纳" value="2" />
        </el-select>
    </el-form-item>
    <el-form-item>
        <el-button size="medium" type="primary" @click="searchHandle()">查询</el-button>
        <el-button
            size="medium"
            type="primary"
            :disabled="!isAuth(['ROOT', 'AMECT:INSERT'])"
            @click="addHandle()"
        >
            新增
        </el-button>
        <el-button
            size="medium"
            type="danger"
            :disabled="!isAuth(['ROOT', 'AMECT:DELETE'])"
            @click="deleteHandle()"
        >
            批量删除
        </el-button>
        <el-button
            size="medium"
            type="warning"
            :disabled="!isAuth(['ROOT', 'AMECT:SELECT'])"
            @click="reportHandle()"
        >
            查看报告
        </el-button>
    </el-form-item>
</el-form>

页面表格内容也不复杂,而且折叠面板的内容,我们直接把tb_amect数据表中的reason字段值写上去就可以了,不需要展开的时候发送Ajax请求。

<el-table
    :data="dataList"
    border
    v-loading="dataListLoading"
    @selection-change="selectionChangeHandle"
    cell-style="padding: 4px 0"
    style="width: 100%;"
    size="medium"
>
    <el-table-column
        type="selection"
        :selectable="selectable"
        header-align="center"
        align="center"
        width="50"
    />
    <el-table-column width="40px" prop="reason" header-align="center" align="center" type="expand">
        <template #default="scope">
            罚款原因:{{ scope.row.reason }}
        </template>
    </el-table-column>
    <el-table-column type="index" header-align="center" align="center" width="100" label="序号">
        <template #default="scope">
            <span>{{ (pageIndex - 1) * pageSize + scope.$index + 1 }}</span>
        </template>
    </el-table-column>
    <el-table-column prop="type" header-align="center" align="center" label="罚款类型" />
    <el-table-column prop="name" header-align="center" align="center" label="当事人" />
    <el-table-column prop="deptName" header-align="center" align="center" label="所属部门" />
    <el-table-column header-align="center" align="center" label="罚款金额">
        <template #default="scope">
            <span>{{ scope.row.amount }}元</span>
        </template>
    </el-table-column>
    <el-table-column prop="status" header-align="center" align="center" label="状态" />
    <el-table-column prop="createTime" header-align="center" align="center" label="日期时间" />
    <el-table-column fixed="right" header-align="center" align="center" width="150" label="操作">
        <template #default="scope">
            <el-button
                type="text"
                size="medium"
                :disabled="!(isAuth(['ROOT', 'AMECT:UPDATE']) && scope.row.status != '已缴纳')"
                @click="updateHandle(scope.row.id)"
            >
                修改
            </el-button>
            <el-button
                type="text"
                size="medium"
                :disabled="!(isAuth(['ROOT', 'AMECT:DELETE']) && scope.row.status != '已缴纳')"
                @click="deleteHandle(scope.row.id)"
            >
                删除
            </el-button>
            <el-button
                type="text"
                size="medium"
                :disabled="!(scope.row.mine == 'true' && scope.row.status == '未缴纳')"
                @click="payHandle(scope.row.id)"
            >
                交款
            </el-button>
        </template>
    </el-table-column>
</el-table>

二、加载页面数据

大家看好了,这才是你要写的代码,我们在amect.vue页面中,声明加载罚款记录的封装方法。

loadDataList: function() {
    let that = this;
    that.dataListLoading = true;
    let data = {
        name: that.dataForm.name,
        deptId: that.dataForm.deptId,
        typeId: that.dataForm.typeId,
        status: that.dataForm.status,
        page: that.pageIndex,
        length: that.pageSize
    };
    if (that.dataForm.date != null && that.dataForm.date.length == 2) {
        let startDate = that.dataForm.date[0];
        let endDate = that.dataForm.date[1];
        data.startDate = dayjs(startDate).format('YYYY-MM-DD');
        data.endDate = dayjs(endDate).format('YYYY-MM-DD');
    }
    that.$http('amect/searchAmectByPage', 'POST', data, true, function(resp) {
        let page = resp.page;
        for (let one of page.list) {
            if (one.status == 1) {
                one.status = '未缴纳';
            } else if (one.status == 2) {
                one.status = '已缴纳';
            }
        }
        that.dataList = page.list;
        that.totalCount = page.totalCount;
        that.dataListLoading = false;
    });
},

然后在本页面的生命周期函数create()中调用loadDataList(),实现进入页面就在表格中加载无条件查询的第一页会议室记录。

created: function() {
    ……
    this.loadDataList();
}

为分页控件设置翻页和改变显示记录数量的回调函数。

<el-pagination
    @size-change="sizeChangeHandle"
    @current-change="currentChangeHandle"
    :current-page="pageIndex"
    :page-sizes="[10, 20, 50]"
    :page-size="pageSize"
    :total="totalCount"
    layout="total, sizes, prev, pager, next, jumper"
></el-pagination>
sizeChangeHandle: function(val) {
    this.pageSize = val;
    this.pageIndex = 1;
    this.loadDataList();
},
currentChangeHandle: function(val) {
    this.pageIndex = val;
    this.loadDataList();
},

三、有条件查询数据

我们声明查询按钮点击事件对应的回调函数,写完这个函数大家就可以运行前后端项目,测试一下数据的查询和分页效果。

searchHandle: function() {
    this.$refs['dataForm'].validate(valid => {
        if (valid) {
            this.$refs['dataForm'].clearValidate();
            if (this.dataForm.name == '') {
                this.dataForm.name = null;
            }
            if (this.pageIndex != 1) {
                this.pageIndex = 1;
            }
            this.loadDataList();
        } else {
            return false;
        }
    });
},