<template>
|
<div class="v_students-container">
|
<el-card shadow="hover" :body-style="{ paddingBottom: '0' }">
|
<el-form :model="queryParams" ref="queryForm" labelWidth="90">
|
<el-row>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10">
|
<el-form-item label="关键字">
|
<el-input v-model="queryParams.searchKey" clearable="" placeholder="请输入模糊查询关键字"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="主键Id">
|
<el-input v-model="queryParams.id" clearable="" placeholder="请输入主键Id"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="老师ID">
|
<el-input v-model="queryParams.testTeacherId" clearable="" placeholder="请输入老师ID"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="学生姓名">
|
<el-input v-model="queryParams.name" clearable="" placeholder="请输入学生姓名"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="别名(可空)">
|
<el-input v-model="queryParams.aliName" clearable="" placeholder="请输入别名(可空)"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="学生年龄">
|
<el-input-number v-model="queryParams.age" clearable="" placeholder="请输入学生年龄"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="年纪(可空)">
|
<el-input-number v-model="queryParams.nianJi" clearable="" placeholder="请输入年纪(可空)"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="老师ID">
|
<el-input v-model="queryParams.teacherId" clearable="" placeholder="请输入老师ID"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="校长ID(可空)">
|
<el-input v-model="queryParams.rectorId" clearable="" placeholder="请输入校长ID(可空)"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="零花钱">
|
<el-input v-model="queryParams.hasMoney" clearable="" placeholder="请输入零花钱"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="身价(可空)">
|
<el-input v-model="queryParams.shenJia" clearable="" placeholder="请输入身价(可空)"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="是否在校">
|
<el-select clearable="" v-model="queryParams.isInSchool" placeholder="请选择是否在校">
|
<el-option v-for="(item,index) in getEnumIsInSchoolData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
|
|
</el-select>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="是否外地人(可空)">
|
<el-select clearable="" v-model="queryParams.isWDR" placeholder="请选择是否外地人(可空)">
|
<el-option v-for="(item,index) in getEnumIsWDRData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
|
|
</el-select>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="性别">
|
<el-select clearable="" v-model="queryParams.gender" placeholder="请选择性别">
|
<el-option v-for="(item,index) in getEnumGenderData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
|
|
</el-select>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="其他性别(可空)">
|
<el-select clearable="" v-model="queryParams.otherGender" placeholder="请选择其他性别(可空)">
|
<el-option v-for="(item,index) in getEnumOtherGenderData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
|
|
</el-select>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="出生日期">
|
<el-date-picker placeholder="请选择出生日期" value-format="YYYY/MM/DD" type="daterange" v-model="queryParams.brithDateRange" />
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="入学日期(可空)">
|
<el-date-picker placeholder="请选择入学日期(可空)" value-format="YYYY/MM/DD" type="daterange" v-model="queryParams.inSchoolDateRange" />
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
|
<el-form-item label="老师名字">
|
<el-input v-model="queryParams.teacherName" clearable="" placeholder="请输入老师名字"/>
|
|
</el-form-item>
|
</el-col>
|
<el-col :xs="24" :sm="12" :md="12" :lg="6" :xl="6" class="mb10">
|
<el-form-item>
|
<el-button-group style="display: flex; align-items: center;">
|
<el-button type="primary" icon="ele-Search" @click="handleQuery" v-auth="'v_students:page'"> 查询 </el-button>
|
<el-button icon="ele-Refresh" @click="() => queryParams = {}"> 重置 </el-button>
|
<el-button icon="ele-ZoomIn" @click="changeAdvanceQueryUI" v-if="!showAdvanceQueryUI" style="margin-left:5px;"> 高级查询 </el-button>
|
<el-button icon="ele-ZoomOut" @click="changeAdvanceQueryUI" v-if="showAdvanceQueryUI" style="margin-left:5px;"> 隐藏 </el-button>
|
<el-button type="primary" style="margin-left:5px;" icon="ele-Plus" @click="openAddv_students" v-auth="'v_students:add'"> 新增 </el-button>
|
|
</el-button-group>
|
</el-form-item>
|
|
</el-col>
|
</el-row>
|
</el-form>
|
</el-card>
|
<el-card class="full-table" shadow="hover" style="margin-top: 5px">
|
<el-table
|
:data="tableData"
|
style="width: 100%"
|
v-loading="loading"
|
tooltip-effect="light"
|
@sort-change="sortChange"
|
border="">
|
<el-table-column type="index" label="序号" width="55" align="center"/>
|
<el-table-column prop="id" label="主键Id" show-overflow-tooltip="" />
|
<el-table-column prop="testTeacherId" label="老师ID" show-overflow-tooltip="" />
|
<el-table-column prop="name" label="学生姓名" show-overflow-tooltip="" />
|
<el-table-column prop="aliName" label="别名(可空)" show-overflow-tooltip="" />
|
<el-table-column prop="age" label="学生年龄" show-overflow-tooltip="" />
|
<el-table-column prop="nianJi" label="年纪(可空)" show-overflow-tooltip="" />
|
<el-table-column prop="teacherId" label="老师ID" show-overflow-tooltip="" />
|
<el-table-column prop="rectorId" label="校长ID(可空)" show-overflow-tooltip="" />
|
<el-table-column prop="hasMoney" label="零花钱" show-overflow-tooltip="" />
|
<el-table-column prop="shenJia" label="身价(可空)" show-overflow-tooltip="" />
|
<el-table-column prop="isInSchool" label="是否在校" show-overflow-tooltip="">
|
<template #default="scope">
|
<el-tag v-if="scope.row.isInSchool"> 是 </el-tag>
|
<el-tag type="danger" v-else> 否 </el-tag>
|
|
</template>
|
|
</el-table-column>
|
<el-table-column prop="isWDR" label="是否外地人(可空)" show-overflow-tooltip="">
|
<template #default="scope">
|
<el-tag v-if="scope.row.isWDR"> 是 </el-tag>
|
<el-tag type="danger" v-else> 否 </el-tag>
|
|
</template>
|
|
</el-table-column>
|
<el-table-column prop="gender" label="性别" show-overflow-tooltip="" >
|
<template #default="scope">
|
<el-tag>{{ getEnumDesc(scope.row.gender, getEnumGenderData_Index)}}</el-tag>
|
</template>
|
</el-table-column>
|
<el-table-column prop="otherGender" label="其他性别(可空)" show-overflow-tooltip="" >
|
<template #default="scope">
|
<el-tag>{{ getEnumDesc(scope.row.otherGender, getEnumOtherGenderData_Index)}}</el-tag>
|
</template>
|
</el-table-column>
|
<el-table-column prop="brithDate" label="出生日期" width="80" :formatter="formatDate_T_Date" show-overflow-tooltip="" />
|
<el-table-column prop="inSchoolDate" label="入学日期(可空)" width="80" :formatter="formatDate_T_Date" show-overflow-tooltip="" />
|
<el-table-column prop="createTime" label="创建时间" width="130" :formatter="formatDate_T_Time" show-overflow-tooltip="" />
|
<el-table-column prop="updateTime" label="修改时间" width="130" :formatter="formatDate_T_Time" show-overflow-tooltip="" />
|
<el-table-column prop="createUserName" label="创建人" show-overflow-tooltip="" />
|
<el-table-column prop="updateUserName" label="修改人" show-overflow-tooltip="" />
|
<el-table-column prop="teacherName" label="老师名字" show-overflow-tooltip="" />
|
<el-table-column label="操作" width="140" align="center" fixed="right" show-overflow-tooltip="" v-if="auth('v_students:update') || auth('v_students:delete')">
|
<template #default="scope">
|
<el-button icon="ele-Edit" size="small" text="" type="primary" @click="openEditv_students(scope.row)" v-auth="'v_students:update'"> 编辑 </el-button>
|
<el-button icon="ele-Delete" size="small" text="" type="primary" @click="delv_students(scope.row)" v-auth="'v_students:delete'"> 删除 </el-button>
|
</template>
|
</el-table-column>
|
</el-table>
|
<el-pagination
|
v-model:currentPage="tableParams.page"
|
v-model:page-size="tableParams.pageSize"
|
:total="tableParams.total"
|
:page-sizes="[10, 20, 50, 100, 200, 500]"
|
small=""
|
background=""
|
@size-change="handleSizeChange"
|
@current-change="handleCurrentChange"
|
layout="total, sizes, prev, pager, next, jumper"
|
/>
|
<printDialog
|
ref="printDialogRef"
|
:title="printv_studentsTitle"
|
@reloadTable="handleQuery" />
|
<editDialog
|
ref="editDialogRef"
|
:title="editv_studentsTitle"
|
@reloadTable="handleQuery"
|
/>
|
</el-card>
|
</div>
|
</template>
|
|
<script lang="ts" setup="" name="v_students">
|
import { ref } from "vue";
|
import { ElMessageBox, ElMessage } from "element-plus";
|
import { auth } from '/@/utils/authFunction';
|
import { getDictDataItem as di, getDictDataList as dl } from '/@/utils/dict-utils';
|
import { formatDate,formatDate_T_Date,formatDate_T_Time,defaultTimeRange } from '/@/utils/formatTime';
|
|
|
import printDialog from '/@/views/system/print/component/hiprint/preview.vue'
|
import { pagev_students, deletev_students } from '/@/api/main/TestDemo/v_students';
|
import { getAPI } from '/@/utils/axios-utils';
|
import { SysEnumApi } from '/@/api-services/api';
|
import commonFunction from '/@/utils/commonFunction';
|
|
const getEnumIsInSchoolData_Index = ref<any>([]);
|
const getEnumIsWDRData_Index = ref<any>([]);
|
const getEnumGenderData_Index = ref<any>([]);
|
const getEnumOtherGenderData_Index = ref<any>([]);
|
|
const { getEnumDesc } = commonFunction();
|
const showAdvanceQueryUI = ref(false);
|
const printDialogRef = ref();
|
const editDialogRef = ref();
|
const loading = ref(false);
|
const tableData = ref<any>([]);
|
const queryParams = ref<any>({});
|
const tableParams = ref({
|
page: 1,
|
pageSize: 10,
|
total: 0,
|
});
|
|
const printv_studentsTitle = ref("");
|
const editv_studentsTitle = ref("");
|
|
// 改变高级查询的控件显示状态
|
const changeAdvanceQueryUI = () => {
|
showAdvanceQueryUI.value = !showAdvanceQueryUI.value;
|
}
|
|
|
// 查询操作
|
const handleQuery = async () => {
|
loading.value = true;
|
var res = await pagev_students(Object.assign(queryParams.value, tableParams.value));
|
tableData.value = res.data.result?.items ?? [];
|
tableParams.value.total = res.data.result?.total;
|
loading.value = false;
|
getEnumIsInSchoolData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('TrueFalseEnum')).data.result ?? [];
|
getEnumIsWDRData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('TrueFalseEnum')).data.result ?? [];
|
getEnumGenderData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('GenderEnum')).data.result ?? [];
|
getEnumOtherGenderData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('GenderEnum')).data.result ?? [];
|
};
|
|
// 列排序
|
const sortChange = async (column: any) => {
|
queryParams.value.field = column.prop;
|
queryParams.value.order = column.order;
|
await handleQuery();
|
};
|
|
// 打开新增页面
|
const openAddv_students = () => {
|
editv_studentsTitle.value = '添加测试学生视图';
|
editDialogRef.value.openDialog({});
|
};
|
|
// 打开打印页面
|
const openPrintv_students = async (row: any) => {
|
printv_studentsTitle.value = '打印测试学生视图';
|
}
|
|
// 打开编辑页面
|
const openEditv_students = (row: any) => {
|
editv_studentsTitle.value = '编辑测试学生视图';
|
editDialogRef.value.openDialog(row);
|
};
|
|
// 删除
|
const delv_students = (row: any) => {
|
ElMessageBox.confirm(`确定要删除吗?`, "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(async () => {
|
await deletev_students(row);
|
handleQuery();
|
ElMessage.success("删除成功");
|
})
|
.catch(() => {});
|
};
|
|
// 改变页面容量
|
const handleSizeChange = (val: number) => {
|
tableParams.value.pageSize = val;
|
handleQuery();
|
};
|
|
// 改变页码序号
|
const handleCurrentChange = (val: number) => {
|
tableParams.value.page = val;
|
handleQuery();
|
};
|
|
handleQuery();
|
</script>
|
<style scoped>
|
:deep(.el-input),
|
:deep(.el-select),
|
:deep(.el-input-number) {
|
width: 100%;
|
}
|
</style>
|
