| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521 |
- <template>
- <div class="employee-archive-page" v-loading="loading">
- <section class="metric-grid" aria-label="人员概览">
- <article v-for="item in metrics" :key="item.key" class="metric-card" :class="`tone-${item.tone}`">
- <span class="metric-icon"><i :class="item.icon"></i></span>
- <div class="metric-main"><span>{{ item.label }}</span><strong>{{ item.value }}<small>{{ item.suffix }}</small></strong></div>
- <div class="metric-note"><i :class="metricNoteIcon(item)"></i>{{ item.note }}</div>
- </article>
- </section>
- <section class="filter-panel">
- <div class="filter-grid">
- <el-input
- v-model.trim="filters.keyword"
- clearable
- prefix-icon="el-icon-search"
- placeholder="姓名 / 工号 / 手机号 / 岗位"
- @keyup.enter.native="applyFilters"
- @clear="applyFilters"
- />
- <el-select v-model="filters.status" clearable placeholder="全部状态" @change="applyFilters">
- <el-option v-for="item in statusOptions" :key="item.value" :label="item.label" :value="item.value" />
- </el-select>
- <el-select v-model="filters.gender" clearable placeholder="全部性别" @change="applyFilters">
- <el-option label="男" value="男" />
- <el-option label="女" value="女" />
- </el-select>
- <el-date-picker
- v-model="filters.hireRange"
- type="daterange"
- value-format="yyyy-MM-dd"
- range-separator="至"
- start-placeholder="入职开始日期"
- end-placeholder="入职结束日期"
- class="hire-range"
- @change="applyFilters"
- />
- <el-button type="primary" icon="el-icon-search" @click="applyFilters">查询</el-button>
- <el-button icon="el-icon-refresh-left" @click="resetFilters">重置</el-button>
- </div>
- </section>
- <section class="archive-workspace">
- <aside class="organization-panel" :class="{ collapsed: treeCollapsed }">
- <div class="panel-heading">
- <div><h2>组织架构</h2><span>按公司与部门查看人员</span></div>
- <el-tooltip :content="treeCollapsed ? '展开组织树' : '收起组织树'" placement="top">
- <button type="button" class="icon-button" @click="treeCollapsed = !treeCollapsed">
- <i :class="treeCollapsed ? 'el-icon-arrow-right' : 'el-icon-arrow-left'"></i>
- </button>
- </el-tooltip>
- </div>
- <template v-if="!treeCollapsed">
- <el-input v-model="treeKeyword" clearable prefix-icon="el-icon-search" placeholder="搜索公司或部门" class="tree-search" />
- <div class="all-organization" :class="{ active: !selectedOrganizationId }" @click="selectAllOrganizations">
- <span><i class="el-icon-menu"></i>全部组织</span><em>{{ employees.length }}</em>
- </div>
- <el-tree
- ref="organizationTree"
- :data="organizationTree"
- node-key="id"
- :props="treeProps"
- :filter-node-method="filterTreeNode"
- :expand-on-click-node="false"
- :default-expanded-keys="['group', 'admin', 'technology', 'marketing', 'production', 'supply', 'branch']"
- highlight-current
- class="organization-tree"
- @node-click="selectOrganization"
- >
- <span slot-scope="{ data }" class="tree-node-content">
- <span class="tree-node-label">
- <i :class="data.type === 'company' || data.type === 'group' ? 'el-icon-office-building' : 'el-icon-folder'" />
- <span>{{ data.name }}</span>
- </span>
- <em>{{ data.staffCount }}</em>
- </span>
- </el-tree>
- </template>
- <button v-else type="button" class="collapsed-tree-button" @click="treeCollapsed = false">
- <i class="el-icon-office-building"></i><span>组织</span>
- </button>
- </aside>
- <main class="table-panel">
- <div v-if="activeFilterTags.length" class="active-filters">
- <span>筛选条件</span>
- <el-tag v-for="tag in activeFilterTags" :key="tag.key" size="small" closable @close="clearFilterTag(tag.key)">{{ tag.label }}</el-tag>
- <button type="button" @click="resetFilters">清除全部</button>
- </div>
- <ele-pro-table
- ref="table"
- row-key="id"
- :columns="columns"
- :datasource="filteredEmployees"
- :need-page="true"
- :page-size="12"
- :cache-key="cacheKeyUrl"
- :title="currentOrganizationName"
- :sub-title="`共找到 ${filteredEmployees.length} 名员工`"
- stripe
- class="employee-table"
- @selection-change="selectedRows = $event"
- @row-click="openDetail"
- >
- <template slot="toolbar">
- <div class="table-toolbar-actions">
- <el-upload action="#" accept=".csv" :auto-upload="false" :show-file-list="false" :on-change="importCsv">
- <el-button size="small" icon="el-icon-upload2">导入</el-button>
- </el-upload>
- <el-dropdown trigger="click" @command="handleExport">
- <el-button size="small" icon="el-icon-download">导出<i class="el-icon-arrow-down el-icon--right"></i></el-button>
- <el-dropdown-menu slot="dropdown">
- <el-dropdown-item command="filtered" icon="el-icon-document">导出当前结果</el-dropdown-item>
- <el-dropdown-item command="selected" icon="el-icon-finished" :disabled="!selectedRows.length">导出已选员工</el-dropdown-item>
- </el-dropdown-menu>
- </el-dropdown>
- <el-button size="small" type="primary" icon="el-icon-plus" @click="openCreate">新增员工</el-button>
- <template v-if="selectedRows.length">
- <span class="selected-count">已选 {{ selectedRows.length }} 人</span>
- <el-dropdown trigger="click" @command="batchCommand">
- <el-button size="small">批量操作<i class="el-icon-arrow-down el-icon--right"></i></el-button>
- <el-dropdown-menu slot="dropdown">
- <el-dropdown-item command="enable" icon="el-icon-circle-check">设为在职</el-dropdown-item>
- <el-dropdown-item command="disable" icon="el-icon-circle-close">设为停用</el-dropdown-item>
- </el-dropdown-menu>
- </el-dropdown>
- </template>
- </div>
- </template>
- <template v-slot:name="{ row }">
- <button type="button" class="employee-cell" @click.stop="openDetail(row)">
- <span class="table-avatar" :style="employeeAvatarStyle(row)">
- <img v-if="row.avatar" :src="row.avatar" :alt="row.name" />
- <span v-else>{{ row.name.slice(-1) }}</span>
- </span>
- <span><strong>{{ row.name }}</strong><small>{{ row.employeeNo }}</small></span>
- </button>
- </template>
- <template v-slot:dept="{ row }"><div class="department-cell"><span>{{ row.deptName }}</span><small>{{ row.company }}</small></div></template>
- <template v-slot:position="{ row }"><div class="position-cell"><span>{{ row.position }}</span><el-tag size="mini" type="info">{{ row.level }}</el-tag></div></template>
- <template v-slot:status="{ row }"><span class="employee-status" :class="row.status"><i></i>{{ statusLabel(row.status) }}</span></template>
- <template v-slot:action="{ row }">
- <div class="action-cell">
- <el-tooltip content="查看员工档案" placement="top"><el-button class="action-button is-view" icon="el-icon-view" @click.stop="openDetail(row)" /></el-tooltip>
- <el-tooltip content="编辑员工档案" placement="top"><el-button class="action-button is-edit" icon="el-icon-edit-outline" @click.stop="openEdit(row)" /></el-tooltip>
- <el-dropdown trigger="click" @command="handleRowCommand($event, row)" @click.native.stop>
- <el-button class="action-button is-more" icon="el-icon-more" />
- <el-dropdown-menu slot="dropdown">
- <el-dropdown-item command="copy" icon="el-icon-document-copy">复制档案摘要</el-dropdown-item>
- <el-dropdown-item command="toggle" :icon="row.status === 'inactive' ? 'el-icon-refresh-left' : 'el-icon-switch-button'" divided>{{ row.status === 'inactive' ? '恢复在职' : '办理离职' }}</el-dropdown-item>
- </el-dropdown-menu>
- </el-dropdown>
- </div>
- </template>
- <template slot="empty">
- <div class="empty-state">
- <span><i class="el-icon-search"></i></span>
- <strong>没有匹配的员工</strong>
- <p>调整组织、状态或关键词后再试</p>
- <el-button size="small" @click="resetFilters">清除筛选</el-button>
- </div>
- </template>
- </ele-pro-table>
- </main>
- </section>
- <employee-archive-form
- :visible.sync="formVisible"
- :employee="editingEmployee"
- :organizations="organizationTree"
- :existing-numbers="employees.map(item => item.employeeNo)"
- @save="saveEmployee"
- />
- <employee-archive-detail
- :visible.sync="detailVisible"
- :employee="selectedEmployee"
- @edit="editFromDetail"
- @command="handleRowCommand"
- />
- </div>
- </template>
- <script>
- import EmployeeArchiveForm from './components/EmployeeArchiveForm.vue';
- import EmployeeArchiveDetail from './components/EmployeeArchiveDetail.vue';
- import {
- organizationTree,
- indicatorData,
- employeeData,
- statusOptions,
- collectOrganizationIds,
- flattenOrganizations
- } from './mock';
- const EMPLOYEE_STORAGE_KEY = 'oa-pc-employee-archive-v2';
- const emptyLeaveInfo = () => ({ enabled: false, position: '', department: '', leaveDate: '', leaveType: '', leaveReason: '', serviceYears: '', handoverStatus: '' });
- const normalizeEmployeeRecord = (record) => ({
- ...record,
- bankAccountName: !record.bankAccountName || (record.bankAccountName === '张伟' && record.name !== '张伟') ? record.name : record.bankAccountName,
- attendanceRecords: record.attendanceRecords || [],
- performanceRecords: record.performanceRecords || [],
- trainingRecords: record.trainingRecords || [],
- rewardPunishmentRecords: record.rewardPunishmentRecords || [],
- awards: record.awards || [],
- positionTransfers: record.positionTransfers || [],
- contractChanges: record.contractChanges || [],
- leaveInfo: { ...emptyLeaveInfo(), ...(record.leaveInfo || {}) }
- });
- const loadEmployeeRecords = () => {
- try {
- const cached = JSON.parse(localStorage.getItem(EMPLOYEE_STORAGE_KEY) || 'null');
- const records = Array.isArray(cached) && cached.length ? cached : JSON.parse(JSON.stringify(employeeData));
- return records.map(normalizeEmployeeRecord);
- } catch (error) {
- return JSON.parse(JSON.stringify(employeeData)).map(normalizeEmployeeRecord);
- }
- };
- export default {
- name: 'EmployeeArchive',
- components: { EmployeeArchiveForm, EmployeeArchiveDetail },
- data() {
- return {
- loading: false,
- employees: loadEmployeeRecords(),
- organizationTree: JSON.parse(JSON.stringify(organizationTree)),
- statusOptions,
- treeProps: { children: 'children', label: 'name' },
- treeKeyword: '',
- treeCollapsed: false,
- selectedOrganizationId: '',
- filters: { keyword: '', status: '', gender: '', hireRange: [] },
- appliedFilters: { keyword: '', status: '', gender: '', hireRange: [] },
- cacheKeyUrl: 'oa-pc-employee-archive-v1',
- selectedRows: [],
- formVisible: false,
- editingEmployee: null,
- detailVisible: false,
- selectedEmployee: null
- };
- },
- computed: {
- columns() {
- return [
- { type: 'selection', width: 56, fixed: 'left', align: 'center', headerAlign: 'center' },
- { prop: 'name', label: '员工', minWidth: 190, fixed: 'left', slot: 'name' },
- { prop: 'deptName', label: '所属部门', minWidth: 170, slot: 'dept' },
- { prop: 'position', label: '岗位 / 职级', minWidth: 158, slot: 'position' },
- { prop: 'hireDate', label: '入职日期', width: 118, align: 'center', sortable: true },
- { prop: 'phone', label: '手机号', width: 122, align: 'center' },
- { prop: 'gender', label: '性别', width: 74, align: 'center' },
- { prop: 'age', label: '年龄', width: 74, align: 'center', sortable: true },
- { prop: 'status', label: '状态', width: 100, align: 'center', slot: 'status' },
- { columnKey: 'action', label: '操作', width: 132, fixed: 'right', align: 'center', resizable: false, slot: 'action' }
- ];
- },
- metrics() {
- const statusCount = (status) => this.employees.filter((item) => item.status === status).length;
- const currentMonth = '2026-08';
- return indicatorData.map((item) => {
- if (item.key === 'total') return { ...item, value: this.employees.filter((row) => row.status !== 'inactive').length };
- if (item.key === 'probation') return { ...item, value: statusCount('probation') };
- if (item.key === 'arrival') return { ...item, value: this.employees.filter((row) => row.hireDate.startsWith(currentMonth)).length };
- if (item.key === 'turnover') return { ...item, value: statusCount('inactive') };
- return item;
- });
- },
- currentOrganizationName() {
- if (!this.selectedOrganizationId) return '全部员工';
- return flattenOrganizations(this.organizationTree, []).find((item) => item.id === this.selectedOrganizationId)?.name || '全部员工';
- },
- selectedOrganizationIds() {
- return this.selectedOrganizationId ? collectOrganizationIds(this.organizationTree, this.selectedOrganizationId) : [];
- },
- filteredEmployees() {
- const { keyword, status, gender, hireRange } = this.appliedFilters;
- const normalizedKeyword = keyword.toLowerCase();
- const rows = this.employees.filter((employee) => {
- const matchesOrganization = !this.selectedOrganizationIds.length || this.selectedOrganizationIds.includes(employee.deptId);
- const haystack = [employee.name, employee.employeeNo, employee.phone, employee.position, employee.deptName, employee.email].join(' ').toLowerCase();
- const matchesKeyword = !normalizedKeyword || haystack.includes(normalizedKeyword);
- const matchesStatus = !status || employee.status === status;
- const matchesGender = !gender || employee.gender === gender;
- const matchesDate = !hireRange?.length || (employee.hireDate >= hireRange[0] && employee.hireDate <= hireRange[1]);
- return matchesOrganization && matchesKeyword && matchesStatus && matchesGender && matchesDate;
- });
- return rows;
- },
- activeFilterTags() {
- const tags = [];
- if (this.selectedOrganizationId) tags.push({ key: 'organization', label: this.currentOrganizationName });
- if (this.appliedFilters.keyword) tags.push({ key: 'keyword', label: `关键词:${this.appliedFilters.keyword}` });
- if (this.appliedFilters.status) tags.push({ key: 'status', label: `状态:${this.statusLabel(this.appliedFilters.status)}` });
- if (this.appliedFilters.gender) tags.push({ key: 'gender', label: `性别:${this.appliedFilters.gender}` });
- if (this.appliedFilters.hireRange?.length) tags.push({ key: 'hireRange', label: `入职:${this.appliedFilters.hireRange.join(' 至 ')}` });
- return tags;
- }
- },
- watch: {
- treeKeyword(value) { this.$refs.organizationTree?.filter(value); },
- filteredEmployees() { this.$nextTick(() => this.$refs.table?.reload({ page: 1 })); },
- employees: {
- deep: true,
- handler(value) {
- try { localStorage.setItem(EMPLOYEE_STORAGE_KEY, JSON.stringify(value)); } catch (error) { /* 本地容量不足时仍保留当前会话数据 */ }
- }
- }
- },
- methods: {
- metricNoteIcon(item) { return item.tone === 'red' ? 'el-icon-warning-outline' : 'el-icon-trend-charts'; },
- statusLabel(status) { return statusOptions.find((item) => item.value === status)?.label || '未知'; },
- employeeAvatarStyle(employee) {
- const tones = ['#1768e5', '#13a471', '#8b5cf6', '#d97706', '#dc5064'];
- const code = [...employee.name].reduce((sum, char) => sum + char.charCodeAt(0), 0);
- return { '--avatar-color': tones[code % tones.length] };
- },
- filterTreeNode(value, data) { return !value || data.name.toLowerCase().includes(value.toLowerCase()); },
- selectOrganization(data) {
- this.selectedOrganizationId = data.id;
- },
- selectAllOrganizations() {
- this.selectedOrganizationId = '';
- this.$refs.organizationTree?.setCurrentKey(null);
- },
- applyFilters() {
- this.appliedFilters = { ...this.filters, hireRange: this.filters.hireRange ? [...this.filters.hireRange] : [] };
- },
- resetFilters() {
- this.filters = { keyword: '', status: '', gender: '', hireRange: [] };
- this.appliedFilters = { keyword: '', status: '', gender: '', hireRange: [] };
- this.selectAllOrganizations();
- },
- clearFilterTag(key) {
- if (key === 'organization') this.selectAllOrganizations();
- else {
- this.filters[key] = key === 'hireRange' ? [] : '';
- this.appliedFilters[key] = key === 'hireRange' ? [] : '';
- }
- },
- openCreate() { this.editingEmployee = null; this.formVisible = true; },
- openEdit(employee) { this.editingEmployee = JSON.parse(JSON.stringify(employee)); this.formVisible = true; },
- editFromDetail(employee) { this.detailVisible = false; this.$nextTick(() => this.openEdit(employee)); },
- openDetail(employee) { this.selectedEmployee = employee; this.detailVisible = true; },
- saveEmployee(payload) {
- if (payload.id) {
- const index = this.employees.findIndex((item) => item.id === payload.id);
- if (index > -1) {
- const existing = this.employees[index];
- const workHistory = [...(existing.workHistory || []).filter((item) => item.source !== 'positionTransfer'), ...this.positionTransferHistory(payload)];
- this.$set(this.employees, index, { ...existing, ...payload, workHistory: workHistory.sort((a, b) => String(b.date).localeCompare(String(a.date))) });
- }
- if (this.selectedEmployee?.id === payload.id) this.selectedEmployee = this.employees[index];
- this.$message.success(`已更新 ${payload.name} 的员工档案`);
- } else {
- const id = Math.max(0, ...this.employees.map((item) => Number(item.id))) + 1;
- const employee = {
- ...payload,
- id,
- contract: { number: '', type: '', signType: '', startDate: '', endDate: '', status: '待签署', ...(payload.contract || {}) },
- workHistory: [
- ...this.positionTransferHistory(payload),
- { date: payload.hireDate, title: '办理入职', detail: `入职${payload.deptName},岗位为${payload.position}`, orderNo: `HR-${payload.hireDate.replace(/-/g, '')}-${String(id).padStart(3, '0')}` }
- ].sort((a, b) => String(b.date).localeCompare(String(a.date))),
- awards: payload.awards || [],
- certificates: payload.certificates || [],
- files: payload.files || []
- };
- this.employees.unshift(employee);
- this.resetFilters();
- this.$message.success(`员工 ${payload.name} 已加入档案列表`);
- this.$nextTick(() => this.openDetail(employee));
- }
- },
- positionTransferHistory(employee) {
- return (employee.positionTransfers || []).filter((item) => item.date).map((item) => ({
- date: item.date,
- title: '岗位调动',
- detail: `${item.originalDepartment || '-'} / ${item.originalPosition || '-'} 调整为 ${item.newDepartment || '-'} / ${item.newPosition || '-'}`,
- orderNo: item.orderNo || '未填写审批单号',
- source: 'positionTransfer'
- }));
- },
- handleRowCommand(command, employee) {
- if (command === 'copy') {
- const summary = `${employee.name}(${employee.employeeNo})|${employee.deptName}|${employee.position}|${this.statusLabel(employee.status)}`;
- if (navigator.clipboard?.writeText) navigator.clipboard.writeText(summary);
- else this.$copyText(summary);
- this.$message.success('档案摘要已复制');
- return;
- }
- if (command === 'toggle') this.toggleEmployeeStatus(employee);
- },
- toggleEmployeeStatus(employee) {
- const leaving = employee.status !== 'inactive';
- const action = leaving ? '办理离职' : '恢复在职';
- this.$confirm(`确认要为 ${employee.name} ${action}吗?`, action, { type: leaving ? 'warning' : 'info', confirmButtonText: '确认', cancelButtonText: '取消' })
- .then(() => {
- employee.status = leaving ? 'inactive' : 'active';
- employee.employmentType = leaving ? '离职' : (employee.employmentType === '离职' ? '全职' : employee.employmentType);
- const currentLeaveInfo = employee.leaveInfo || {};
- employee.leaveInfo = {
- ...emptyLeaveInfo(),
- ...currentLeaveInfo,
- enabled: leaving,
- position: currentLeaveInfo.position || employee.position,
- department: currentLeaveInfo.department || employee.deptName,
- leaveDate: leaving ? (currentLeaveInfo.leaveDate || new Date().toISOString().slice(0, 10)) : currentLeaveInfo.leaveDate || ''
- };
- if (this.selectedEmployee?.id === employee.id) this.selectedEmployee = employee;
- this.$message.success(`${action}完成`);
- })
- .catch(() => {});
- },
- batchCommand(command) {
- const status = command === 'enable' ? 'active' : 'disabled';
- const label = command === 'enable' ? '在职' : '停用';
- this.$confirm(`确认将已选 ${this.selectedRows.length} 名员工设为${label}吗?`, '批量更新状态', { type: 'warning' })
- .then(() => {
- const ids = this.selectedRows.map((item) => item.id);
- this.employees.forEach((item) => {
- if (!ids.includes(item.id)) return;
- item.status = status;
- if (status === 'active' && item.leaveInfo?.enabled) item.leaveInfo.enabled = false;
- if (status === 'active' && item.employmentType === '离职') item.employmentType = '全职';
- });
- this.$refs.table?.clearSelection();
- this.$message.success(`已更新 ${ids.length} 名员工的状态`);
- })
- .catch(() => {});
- },
- refreshData() {
- this.loading = true;
- setTimeout(() => { this.loading = false; this.$message.success('模拟数据已刷新'); }, 420);
- },
- escapeCsv(value) {
- const text = String(value == null ? '' : value);
- return /[",\n]/.test(text) ? `"${text.replace(/"/g, '""')}"` : text;
- },
- handleExport(type) {
- const rows = type === 'selected' ? this.selectedRows : this.filteredEmployees;
- if (!rows.length) { this.$message.warning('当前没有可导出的员工数据'); return; }
- const columns = [
- ['员工编号', 'employeeNo'], ['姓名', 'name'], ['性别', 'gender'], ['部门', 'deptName'], ['岗位', 'position'],
- ['职级', 'level'], ['入职日期', 'hireDate'], ['手机号', 'phone'], ['邮箱', 'email'], ['状态', 'status']
- ];
- const lines = [columns.map((item) => item[0]).join(',')];
- rows.forEach((row) => lines.push(columns.map((item) => this.escapeCsv(item[1] === 'status' ? this.statusLabel(row.status) : row[item[1]])).join(',')));
- const blob = new Blob([`\uFEFF${lines.join('\r\n')}`], { type: 'text/csv;charset=utf-8' });
- const url = URL.createObjectURL(blob);
- const link = document.createElement('a');
- link.href = url;
- link.download = `员工档案_${new Date().toISOString().slice(0, 10)}.csv`;
- link.click();
- URL.revokeObjectURL(url);
- this.$message.success(`已导出 ${rows.length} 条员工档案`);
- },
- parseCsvLine(line) {
- const result = [];
- let current = '';
- let quoted = false;
- for (let index = 0; index < line.length; index += 1) {
- const char = line[index];
- if (char === '"' && quoted && line[index + 1] === '"') { current += '"'; index += 1; }
- else if (char === '"') quoted = !quoted;
- else if (char === ',' && !quoted) { result.push(current.trim()); current = ''; }
- else current += char;
- }
- result.push(current.trim());
- return result;
- },
- importCsv(file) {
- const raw = file.raw;
- if (!raw) return;
- if (raw.size > 2 * 1024 * 1024) { this.$message.warning('CSV 文件不能超过 2MB'); return; }
- const reader = new FileReader();
- reader.onload = (event) => {
- try {
- const lines = String(event.target.result).replace(/^\uFEFF/, '').split(/\r?\n/).filter(Boolean);
- if (lines.length < 2) throw new Error('文件中没有员工数据');
- const headers = this.parseCsvLine(lines[0]);
- const required = ['员工编号', '姓名', '部门', '岗位', '入职日期'];
- const missing = required.filter((name) => !headers.includes(name));
- if (missing.length) throw new Error(`缺少必填列:${missing.join('、')}`);
- const orgs = flattenOrganizations(this.organizationTree, []);
- const existing = new Set(this.employees.map((item) => item.employeeNo));
- let skipped = 0;
- const imported = lines.slice(1).map((line) => {
- const values = this.parseCsvLine(line);
- return headers.reduce((record, header, index) => ({ ...record, [header]: values[index] || '' }), {});
- }).filter((record) => {
- if (!record['员工编号'] || existing.has(record['员工编号'])) { skipped += 1; return false; }
- existing.add(record['员工编号']);
- return true;
- }).map((record, index) => {
- const organization = orgs.find((item) => item.name === record['部门']) || { id: '', name: record['部门'] };
- const statusMap = { '在职': 'active', '试用期': 'probation', '已离职': 'inactive', '停用': 'disabled' };
- return {
- id: Math.max(0, ...this.employees.map((item) => Number(item.id))) + index + 1,
- employeeNo: record['员工编号'], name: record['姓名'], gender: record['性别'] || '男', deptId: organization.id,
- deptName: organization.name, company: '中盈产业集团有限公司', position: record['岗位'], level: record['职级'] || 'P1',
- hireDate: record['入职日期'], phone: record['手机号'] || '', email: record['邮箱'] || '', status: statusMap[record['状态']] || 'probation',
- age: null, birthDate: '', idCard: '', education: '', school: '', maritalStatus: '', ethnic: '汉族', manager: '',
- employmentType: '全职', enabled: true, workHistory: [], awards: [], certificates: [], files: [], contract: { status: '待签署' }
- };
- });
- if (!imported.length) throw new Error(skipped ? '文件内员工编号均已存在' : '没有可导入的数据');
- this.employees.unshift(...imported);
- this.resetFilters();
- this.$message.success(`成功导入 ${imported.length} 条${skipped ? `,跳过 ${skipped} 条重复数据` : ''}`);
- } catch (error) {
- this.$message.error(error.message || 'CSV 解析失败');
- }
- };
- reader.readAsText(raw, 'UTF-8');
- }
- }
- };
- </script>
- <style src="../../styles/views/employeeArchive/index.scss" lang="scss" scoped></style>
|