删除员工
删除单条记录
(1)导入需要的函数
js
import { queryPageApi, addApi, queryInfoApi, deleteApi } from "@/api/emp";
import { ElMessage, ElMessageBox } from "element-plus";(2)为 "删除" 按钮 绑定事件
html
<el-table-column label="操作" fixed="right" align="center">
<template #default="scope">
<el-button size="small" type="primary" @click="handleEdit(scope.row.id)"
>编辑</el-button
>
<el-button size="small" type="danger" @click="deleteById(scope.row.id)"
>删除</el-button
>
</template>
</el-table-column>(3)在 <script> </script> 中定义函数
js
//删除员工
const deleteById = (id) => {
//弹出确认框
ElMessageBox.confirm("您确认删除该员工吗?", "提示", {
confirmButtonText: "确认",
cancelButtonText: "取消",
type: "warning",
})
.then(async () => {
//确认
const result = await deleteApi(id);
if (result.code) {
ElMessage.success("删除成功");
search();
} else {
ElMessage.error(result.msg);
}
})
.catch(() => {
//取消
ElMessage.info("您已取消删除");
});
};批量删除
(1)为复选框绑定事件 @selection-change
html
<!-- 数据展示表格 -->
<div class="container">
<el-table
:data="empList"
border
style="width: 100%"
@selection-change="handleSelectionChange"
>
......
</el-table>
</div>(2)定义 handleSelectionChange 函数
js
//记录勾选的员工的id
const selectedIds = ref([]);
//复选框勾选发生变化时触发 - selection: 当前选中的记录 (数组)
const handleSelectionChange = (selection) => {
selectedIds.value = selection.map((item) => item.id);
};(3)为 "批量删除" 按钮绑定事件
html
<el-button type="primary" @click="addEmp"> + 新增员工</el-button>
<el-button type="danger" @click="deleteByIds"> - 批量删除</el-button>(4)在 <script> </script> 中定义函数
js
//批量删除
const deleteByIds = () => {
//弹出确认框
ElMessageBox.confirm("您确认删除该员工吗?", "提示", {
confirmButtonText: "确认",
cancelButtonText: "取消",
type: "warning",
})
.then(async () => {
//确认
if (selectedIds.value && selectedIds.value.length > 0) {
const result = await deleteApi(selectedIds.value);
if (result.code) {
ElMessage.success("删除成功");
search();
} else {
ElMessage.error(result.msg);
}
} else {
ElMessage.info("您没有选择任何要删除的数据");
}
})
.catch(() => {
//取消
ElMessage.info("您已取消删除");
});
};完整代码
说明
至此,前端中部门管理、员工管理的增删改查功能全部实现
emp / index.vue
点我查看代码
vue
<script setup>
import { ref, watch, onMounted } from "vue";
import { queryPageApi, addApi, queryInfoApi, deleteApi } from "@/api/emp";
import { ElMessage, ElMessageBox } from "element-plus";
import { queryAllApi as queryAllDeptApi } from "@/api/dept";
import { updateApi } from "../../api/emp";
//职位列表数据
const jobs = ref([
{ name: "班主任", value: 1 },
{ name: "讲师", value: 2 },
{ name: "学工主管", value: 3 },
{ name: "教研主管", value: 4 },
{ name: "咨询师", value: 5 },
{ name: "其他", value: 6 },
]);
//性别列表数据
const genders = ref([
{ name: "男", value: 1 },
{ name: "女", value: 2 },
]);
//部门列表数据
const deptList = ref([]);
const searchEmp = ref({
name: "",
gender: "",
date: [],
begin: "",
end: "",
});
//侦听searchEmp中的date属性
watch(
() => searchEmp.value.date,
(newValue, oldValue) => {
if (newValue.length == 2) {
searchEmp.value.begin = newValue[0];
searchEmp.value.end = newValue[1];
} else {
searchEmp.value.begin = "";
searchEmp.value.end = "";
}
}
);
onMounted(async () => {
search();
//加载所有部门数据
const result = await queryAllDeptApi();
if (result.code) {
deptList.value = result.data;
}
});
//查询员工
const search = async () => {
console.log("Search:", searchEmp.value);
const result = await queryPageApi(
searchEmp.value.name,
searchEmp.value.gender,
searchEmp.value.begin,
searchEmp.value.end,
currentPage.value,
pageSize.value
);
if (result.code) {
empList.value = result.data.rows;
total.value = result.data.total;
}
};
const clear = () => {
// 清空表单
searchEmp.value = {
name: "",
gender: "",
date: [],
begin: "",
end: "",
};
search();
};
// 示例数据
const empList = ref([]);
// 分页配置
const currentPage = ref(1);
const pageSize = ref(10);
const total = ref(0);
// 分页处理
const handleSizeChange = (val) => {
search();
};
const handleCurrentChange = (val) => {
search();
};
//新增员工
const addEmp = () => {
dialogVisible.value = true;
dialogTitle.value = "新增员工";
employee.value = {
username: "",
name: "",
gender: "",
phone: "",
job: "",
salary: "",
deptId: "",
entryDate: "",
image: "",
exprList: [],
};
// 重置表单校验规则-提示信息
if (employeeFormRef.value) {
employeeFormRef.value.resetFields();
}
};
//新增/修改表单
const employeeFormRef = ref(null);
const employee = ref({
username: "",
name: "",
gender: "",
phone: "",
job: "",
salary: "",
deptId: "",
entryDate: "",
image: "",
exprList: [],
});
// 控制弹窗
const dialogVisible = ref(false);
const dialogTitle = ref("新增员工");
//文件上传
// 图片上传成功后触发
const handleAvatarSuccess = (response, uploadFile) => {
employee.value.image = response.data;
};
// 文件上传之前触发
const beforeAvatarUpload = (rawFile) => {
if (rawFile.type !== "image/jpeg" && rawFile.type !== "image/png") {
ElMessage.error("只支持上传图片");
return false;
} else if (rawFile.size / 1024 / 1024 > 10) {
ElMessage.error("只能上传10M以内图片");
return false;
}
return true;
};
//工作经历
//动态添加工作经历 .
const addExprItem = () => {
employee.value.exprList.push({
exprDate: [],
begin: "",
end: "",
company: "",
job: "",
});
};
//动态删除工作经历 .
const delExprItem = (index) => {
employee.value.exprList.splice(index, 1);
};
//监听-employee员工对象中的工作经历数据
watch(
() => employee.value.exprList,
(newValue, oldValue) => {
if (employee.value.exprList && employee.value.exprList.length > 0) {
employee.value.exprList.forEach((expr) => {
expr.begin = expr.exprDate[0];
expr.end = expr.exprDate[1];
});
}
},
{ deep: true }
);
const save = async () => {
employeeFormRef.value.validate(async (valid) => {
if (valid) {
let result;
if (employee.value.id) {
result = await updateApi(employee.value);
} else {
result = await addApi(employee.value);
}
if (result.code) {
ElMessage.success("新增员工成功");
dialogVisible.value = false;
search();
} else {
ElMessage.error(result.msg);
}
} else {
ElMessage.error("表单校验不通过");
}
});
};
//表单校验规则
const rules = ref({
username: [
{ required: true, message: "请输入用户名", trigger: "blur" },
{
min: 2,
max: 20,
message: "用户名长度应在2到20个字符之间",
trigger: "blur",
},
],
name: [
{ required: true, message: "请输入姓名", trigger: "blur" },
{
min: 2,
max: 10,
message: "姓名长度应在2到10个字符之间",
trigger: "blur",
},
],
gender: [{ required: true, message: "请选择性别", trigger: "change" }],
phone: [
{ required: true, message: "请输入手机号", trigger: "blur" },
{ pattern: /^1\d{10}$/g, message: "请输入有效的手机号", trigger: "blur" },
],
});
//编辑
const edit = async (id) => {
const result = await queryInfoApi(id);
if (result.code) {
dialogVisible.value = true;
dialogTitle.value = "修改员工";
employee.value = result.data;
//对工作经历进行处理
let exprList = employee.value.exprList;
if (exprList && exprList.length > 0) {
exprList.forEach((expr) => {
expr.exprDate = [expr.begin, expr.end];
});
}
}
};
//删除员工
const deleteById = (id) => {
//弹出确认框
ElMessageBox.confirm("您确认删除该员工吗?", "提示", {
confirmButtonText: "确认",
cancelButtonText: "取消",
type: "warning",
})
.then(async () => {
//确认
const result = await deleteApi(id);
if (result.code) {
ElMessage.success("删除成功");
search();
} else {
ElMessage.error(result.msg);
}
})
.catch(() => {
//取消
ElMessage.info("您已取消删除");
});
};
//记录勾选的员工的id
const selectedIds = ref([]);
//复选框勾选发生变化时触发 - selection: 当前选中的记录 (数组)
const handleSelectionChange = (selection) => {
selectedIds.value = selection.map((item) => item.id);
};
//批量删除
const deleteByIds = () => {
//弹出确认框
ElMessageBox.confirm("您确认删除该员工吗?", "提示", {
confirmButtonText: "确认",
cancelButtonText: "取消",
type: "warning",
})
.then(async () => {
//确认
if (selectedIds.value && selectedIds.value.length > 0) {
const result = await deleteApi(selectedIds.value);
if (result.code) {
ElMessage.success("删除成功");
search();
} else {
ElMessage.error(result.msg);
}
} else {
ElMessage.info("您没有选择任何要删除的数据");
}
})
.catch(() => {
//取消
ElMessage.info("您已取消删除");
});
};
</script>
<template>
<h1>员工管理</h1>
<br />
<el-form :inline="true" :model="searchEmp">
<el-form-item label="姓名">
<el-input
v-model="searchEmp.name"
placeholder="请输入员工姓名"
></el-input>
</el-form-item>
<el-form-item label="性别">
<el-select v-model="searchEmp.gender" placeholder="请选择">
<el-option label="男" value="1"></el-option>
<el-option label="女" value="2"></el-option>
</el-select>
</el-form-item>
<el-form-item label="入职日期">
<el-date-picker
v-model="searchEmp.date"
type="daterange"
range-separator="至"
start-placeholder="开始日期"
end-placeholder="结束日期"
value-format="YYYY-MM-DD"
></el-date-picker>
</el-form-item>
<el-form-item>
<el-button type="primary" @click="search">查询</el-button>
<el-button @click="clear">清空</el-button>
</el-form-item>
</el-form>
<el-button type="primary" @click="addEmp"> + 新增员工</el-button>
<el-button type="danger" @click="deleteByIds"> - 批量删除</el-button>
<br /><br />
<!-- 表格 -->
<el-table
:data="empList"
border
style="width: 100%"
@selection-change="handleSelectionChange"
>
<el-table-column
type="selection"
width="55"
align="center"
></el-table-column>
<el-table-column
prop="name"
label="姓名"
width="120"
align="center"
></el-table-column>
<el-table-column label="性别" width="120" align="center">
<template #default="scope">
{{ scope.row.gender == 1 ? "男" : "女" }}
</template>
</el-table-column>
<el-table-column label="头像" width="120" align="center">
<template #default="scope">
<img :src="scope.row.image" width="40" class="img" align="center" />
</template>
</el-table-column>
<el-table-column
prop="deptName"
label="部门名称"
width="120"
align="center"
></el-table-column>
<el-table-column label="职位" width="120" align="center">
<template #default="scope">
<span v-if="scope.row.job == 1">班主任</span>
<span v-else-if="scope.row.job == 2">讲师</span>
<span v-else-if="scope.row.job == 3">学工主管</span>
<span v-else-if="scope.row.job == 4">教研主管</span>
<span v-else-if="scope.row.job == 5">咨询师</span>
<span v-else>其他</span>
</template>
</el-table-column>
<el-table-column
prop="entryDate"
label="入职日期"
width="180"
align="center"
></el-table-column>
<el-table-column
prop="updateTime"
label="最后操作时间"
width="200"
align="center"
></el-table-column>
<el-table-column label="操作" align="center">
<template #default="scope">
<el-button size="small" type="primary" @click="edit(scope.row.id)"
>编辑</el-button
>
<el-button size="small" type="danger" @click="deleteById(scope.row.id)"
>删除</el-button
>
</template>
</el-table-column>
</el-table>
<br />
<!-- 分页 -->
<el-pagination
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
v-model:current-page="currentPage"
v-model:page-size="pageSize"
:page-sizes="[10, 20, 30, 40]"
layout="total, sizes, prev, pager, next, jumper"
:total="total"
>
</el-pagination>
<!-- 新增/修改员工的对话框 -->
<el-dialog v-model="dialogVisible" :title="dialogTitle">
<el-form
ref="employeeFormRef"
:model="employee"
:rules="rules"
label-width="80px"
>
<!-- 基本信息 -->
<!-- 第一行 -->
<el-row :gutter="20">
<el-col :span="12">
<el-form-item label="用户名" prop="username">
<el-input
v-model="employee.username"
placeholder="请输入员工用户名,2-20个字"
></el-input>
</el-form-item>
</el-col>
<el-col :span="12">
<el-form-item label="姓名" prop="name">
<el-input
v-model="employee.name"
placeholder="请输入员工姓名,2-10个字"
></el-input>
</el-form-item>
</el-col>
</el-row>
<!-- 第二行 -->
<el-row :gutter="20">
<el-col :span="12">
<el-form-item label="性别" prop="gender">
<el-select
v-model="employee.gender"
placeholder="请选择性别"
style="width: 100%"
>
<el-option
v-for="gender in genders"
:key="gender.name"
:label="gender.name"
:value="gender.value"
></el-option>
</el-select>
</el-form-item>
</el-col>
<el-col :span="12">
<el-form-item label="手机号" prop="phone">
<el-input
v-model="employee.phone"
placeholder="请输入员工手机号"
></el-input>
</el-form-item>
</el-col>
</el-row>
<!-- 第三行 -->
<el-row :gutter="20">
<el-col :span="12">
<el-form-item label="职位">
<el-select
v-model="employee.job"
placeholder="请选择职位"
style="width: 100%"
>
<el-option
v-for="job in jobs"
:key="job.name"
:label="job.name"
:value="job.value"
></el-option>
</el-select>
</el-form-item>
</el-col>
<el-col :span="12">
<el-form-item label="薪资">
<el-input
v-model="employee.salary"
placeholder="请输入员工薪资"
></el-input>
</el-form-item>
</el-col>
</el-row>
<!-- 第四行 -->
<el-row :gutter="20">
<el-col :span="12">
<el-form-item label="所属部门">
<el-select
v-model="employee.deptId"
placeholder="请选择部门"
style="width: 100%"
>
<el-option
v-for="dept in deptList"
:key="dept.id"
:label="dept.name"
:value="dept.id"
></el-option>
</el-select>
</el-form-item>
</el-col>
<el-col :span="12">
<el-form-item label="入职日期">
<el-date-picker
v-model="employee.entryDate"
type="date"
style="width: 100%"
placeholder="选择日期"
format="YYYY-MM-DD"
value-format="YYYY-MM-DD"
></el-date-picker>
</el-form-item>
</el-col>
</el-row>
<!-- 第五行 -->
<el-row :gutter="20">
<el-col :span="24">
<el-form-item label="头像">
<el-upload
class="avatar-uploader"
action="/api/upload"
:show-file-list="false"
:on-success="handleAvatarSuccess"
:before-upload="beforeAvatarUpload"
>
<img v-if="employee.image" :src="employee.image" class="avatar" />
<el-icon v-else class="avatar-uploader-icon"><Plus /></el-icon>
</el-upload>
</el-form-item>
</el-col>
</el-row>
<!-- 工作经历 -->
<!-- 第六行 -->
<el-row :gutter="10">
<el-col :span="24">
<el-form-item label="工作经历">
<el-button type="success" size="small" @click="addExprItem"
>+ 添加工作经历</el-button
>
</el-form-item>
</el-col>
</el-row>
<!-- 第七行 ... 工作经历 -->
<el-row :gutter="3" v-for="(expr, index) in employee.exprList">
<el-col :span="10">
<el-form-item size="small" label="时间" label-width="80px">
<el-date-picker
type="daterange"
v-model="expr.exprDate"
range-separator="至"
start-placeholder="开始日期"
end-placeholder="结束日期"
format="YYYY-MM-DD"
value-format="YYYY-MM-DD"
></el-date-picker>
</el-form-item>
</el-col>
<el-col :span="6">
<el-form-item size="small" label="公司" label-width="60px">
<el-input
placeholder="请输入公司名称"
v-model="expr.company"
></el-input>
</el-form-item>
</el-col>
<el-col :span="6">
<el-form-item size="small" label="职位" label-width="60px">
<el-input placeholder="请输入职位" v-model="expr.job"></el-input>
</el-form-item>
</el-col>
<el-col :span="2">
<el-form-item size="small" label-width="0px">
<el-button type="danger" @click="delExprItem(index)"
>- 删除</el-button
>
</el-form-item>
</el-col>
</el-row>
</el-form>
<!-- 底部按钮 -->
<template #footer>
<span class="dialog-footer">
<el-button @click="dialogVisible = false">取消</el-button>
<el-button type="primary" @click="save">保存</el-button>
</span>
</template>
</el-dialog>
</template>
<style scoped>
.avatar {
height: 40px;
}
.avatar-uploader .avatar {
width: 78px;
height: 78px;
display: block;
}
.avatar-uploader .el-upload {
border: 1px dashed var(--el-border-color);
border-radius: 6px;
cursor: pointer;
position: relative;
overflow: hidden;
transition: var(--el-transition-duration-fast);
}
.avatar-uploader .el-upload:hover {
border-color: var(--el-color-primary);
}
.el-icon.avatar-uploader-icon {
font-size: 28px;
color: #8c939d;
width: 78px;
height: 78px;
text-align: center;
/* 添加灰色的虚线边框 */
border: 1px dashed var(--el-border-color);
}
</style>dept / index.vue
点我查看代码
vue
<script setup>
import { ref, onMounted } from "vue";
import { ElMessage, ElMessageBox } from "element-plus";
import {
queryAllApi,
addDeptApi,
queryInfoApi,
updateDeptApi,
deleteDeptApi,
} from "@/api/dept";
// 声明列表展示数据
let deptList = ref([]);
// 动态加载数据 - 查询部门
const queryAll = async () => {
const result = await queryAllApi();
deptList.value = result.data;
};
// 钩子函数
onMounted(() => {
queryAll();
});
const formTitle = ref("");
//新增部门
const add = () => {
formTitle.value = "新增部门";
showDialog.value = true;
deptForm.value = { name: "" };
};
// 编辑部门 - 根据ID查询回显数据
const handleEdit = async (id) => {
console.log(`Edit item with ID ${id}`);
formTitle.value = "修改部门";
showDialog.value = true;
deptForm.value = { name: "" };
const result = await queryInfoApi(id);
if (result.code) {
deptForm.value = result.data;
}
};
// 删除部门 - 根据ID删除部门
const handleDelete = (id) => {
console.log(`Delete item with ID ${id}`);
//删除部门时, 需要弹出一个确认框, 如果是确认, 则删除部门
ElMessageBox.confirm("此操作将永久删除该部门, 是否继续?", "提示", {
confirmButtonText: "确定",
cancelButtonText: "取消",
type: "warning",
}).then(async () => {
// 删除部门
const result = await deleteDeptApi(id);
if (result.code) {
ElMessage.success("删除成功");
queryAll();
}
});
};
// 新增部门对话框的状态
const showDialog = ref(false);
// 表单数据
const deptForm = ref({ name: "" });
// 表单验证规则
const formRules = ref({
name: [
{ required: true, message: "请输入部门名称", trigger: "blur" },
{ min: 2, max: 10, message: "长度在 2 到 10 个字符", trigger: "blur" },
],
});
// 表单引用
const deptFormRef = ref(null);
// 重置表单
const resetForm = () => {
deptFormRef.value.resetFields();
};
// 提交表单
const save = async () => {
await deptFormRef.value.validate(async (valid) => {
if (!valid) return;
// 提交表单
let result = null;
if (deptForm.value.id) {
result = await updateDeptApi(deptForm.value); // 修改
} else {
result = await addDeptApi(deptForm.value); // 新增
}
if (result.code) {
ElMessage.success("操作成功");
// 关闭对话框
showDialog.value = false;
// 重置表单
resetForm();
// 重新加载数据
queryAll();
} else {
ElMessage.error(result.msg);
}
});
};
</script>
<template>
<h1>部门管理</h1>
<!-- 按钮靠页面右侧显示 -->
<el-button type="primary" @click="add()" style="float: right">
+ 新增部门</el-button
>
<br /><br />
<!-- 数据展示表格 -->
<el-table :data="deptList" border style="width: 100%">
<el-table-column type="index" label="序号" width="100" align="center" />
<el-table-column prop="name" label="部门名称" width="300" align="center" />
<el-table-column
prop="updateTime"
label="最后修改时间"
width="300"
align="center"
/>
<el-table-column fixed="right" label="操作" align="center">
<template #default="scope">
<el-button size="small" @click="handleEdit(scope.row.id)"
>修改</el-button
>
<el-button
size="small"
type="danger"
@click="handleDelete(scope.row.id)"
>删除</el-button
>
</template>
</el-table-column>
</el-table>
<!-- 新增部门的对话框 -->
<el-dialog
v-model="showDialog"
:title="formTitle"
width="30%"
@close="resetForm"
>
<el-form :model="deptForm" :rules="formRules" ref="deptFormRef">
<el-form-item label="部门名称" prop="name" label-width="80px">
<el-input v-model="deptForm.name" autocomplete="off"></el-input>
</el-form-item>
</el-form>
<template #footer>
<span class="dialog-footer">
<el-button @click="showDialog = false">取消</el-button>
<el-button type="primary" @click="save">确定</el-button>
</span>
</template>
</el-dialog>
</template>
<style scoped></style>api / dept.js
js
import request from "@/utils/request";
//查询全部部门
export const queryAllApi = () => request.get("/depts");
//添加部门
export const addDeptApi = (data) => request.post("/depts", data);
//根据ID查询
export const queryInfoApi = (id) => request.get(`/depts/${id}`);
// 修改
export const updateDeptApi = (dept) => request.put("/depts", dept);
//删除部门
export const deleteDeptApi = (id) => request.delete(`/depts?id=${id}`);api / emp.js
js
import request from "@/utils/request";
//查询员工列表数据
export const queryPageApi = (name, gender, begin, end, page, pageSize) =>
request.get(
`/emps?name=${name}&gender=${gender}&begin=${begin}&end=${end}&page=${page}&pageSize=${pageSize}`
);
//新增
export const addApi = (emp) => request.post("/emps", emp);
//根据ID查询
export const queryInfoApi = (id) => request.get(`/emps/${id}`);
//修改
export const updateApi = (emp) => request.put("/emps", emp);
//删除
export const deleteApi = (ids) => request.delete(`/emps?ids=${ids}`);router / index.js
js
import { createRouter, createWebHistory } from "vue-router";
import IndexView from "@/views/index/index.vue";
import ClazzView from "@/views/clazz/index.vue";
import DeptView from "@/views/dept/index.vue";
import EmpView from "@/views/emp/index.vue";
import LogView from "@/views/log/index.vue";
import StuView from "@/views/stu/index.vue";
import EmpReportView from "@/views/report/emp/index.vue";
import StuReportView from "@/views/report/stu/index.vue";
import LayoutView from "@/views/layout/index.vue";
import LoginView from "@/views/login/index.vue";
const router = createRouter({
history: createWebHistory(import.meta.env.BASE_URL),
routes: [
{
path: "/",
name: "",
component: LayoutView,
redirect: "/index", //重定向
children: [
{ path: "index", name: "index", component: IndexView },
{ path: "clazz", name: "clazz", component: ClazzView },
{ path: "stu", name: "stu", component: StuView },
{ path: "dept", name: "dept", component: DeptView },
{ path: "emp", name: "emp", component: EmpView },
{ path: "log", name: "log", component: LogView },
{ path: "empReport", name: "empReport", component: EmpReportView },
{ path: "stuReport", name: "stuReport", component: StuReportView },
],
},
{ path: "/login", name: "login", component: LoginView },
],
});
export default router;utils / request.js
js
import axios from "axios";
//创建axios实例对象
const request = axios.create({
baseURL: "/api",
timeout: 600000,
});
//axios的响应 response 拦截器
request.interceptors.response.use(
(response) => {
//成功回调
return response.data;
},
(error) => {
//失败回调
return Promise.reject(error);
}
);
export default request;