编辑页面

`; break; case 'workshop': modalTitle.textContent = '新增车间'; content = ` `; break; case 'production': modalTitle.textContent = '新增生产单'; content = ` `; break; case 'wage': modalTitle.textContent = '新增工资记录'; content = ` `; break; case 'energyPrice': modalTitle.textContent = '编辑能源单价参数'; content = ` `; break; case 'stdWorkHours': modalTitle.textContent = '编辑标准工时参数'; content = ` `; break; case 'user': modalTitle.textContent = '新增用户'; content = ` `; break; case 'backup': modalTitle.textContent = '创建数据备份'; content = ` `; break; case 'energy': modalTitle.textContent = '新增能耗记录'; content = ` `; break; case 'deviceLog': modalTitle.textContent = '新增设备运行日志'; content = ` `; break; case 'cost': modalTitle.textContent = '新增成本记录'; content = ` `; break; case 'person': modalTitle.textContent = '新增人员档案'; content = ` `; break; case 'product': modalTitle.textContent = '新增产品档案'; content = ` `; break; case 'process': modalTitle.textContent = '新增工序档案'; content = ` `; break; case 'equipment': modalTitle.textContent = '新增设备档案'; content = ` `; break; case 'energyType': modalTitle.textContent = '新增能源类型'; content = ` `; break; case 'importProduction': modalTitle.textContent = '📥 批量导入生产数据'; content = ` `; break; case 'importEnergy': modalTitle.textContent = '📥 批量导入能耗数据'; content = ` `; break; case 'importWage': modalTitle.textContent = '📥 批量导入工资数据'; content = ` `; break; case 'importCost': modalTitle.textContent = '📥 批量导入成本数据'; content = ` `; break; case 'importDevice': modalTitle.textContent = '📥 批量导入设备运行数据'; content = ` `; break; case 'exportShipment': modalTitle.textContent = '📥 导出成品发货趋势及生产计划'; content = ` `; break; case 'exportEnergy': modalTitle.textContent = '📥 导出能源消耗报表'; content = ` `; break; case 'exportCost': modalTitle.textContent = '📥 导出成本分析报表'; content = ` `; break; case 'exportOEE': modalTitle.textContent = '📥 导出设备OEE分析报表'; content = ` `; break; case 'exportViz': modalTitle.textContent = '📥 导出统计可视化报表'; content = ` `; break; case 'exportWageReport': modalTitle.textContent = '📥 导出工资报表'; content = ` `; break; case 'exportLog': modalTitle.textContent = '📥 导出系统日志'; content = ` `; break; case 'exportWage': modalTitle.textContent = '📥 导出工资汇总报表'; content = ` `; break; case 'exportWageDetail': modalTitle.textContent = '📥 导出工资明细数据'; content = ` `; break; case 'exportWorkshopWage': modalTitle.textContent = '📥 导出车间工资汇总'; content = ` `; break; case 'exportPieceWage': modalTitle.textContent = '📥 导出计件工资明细'; content = ` `; break; case 'exportPieceWageAnalysis': modalTitle.textContent = '📥 导出计件工资分析'; content = ` `; break; case 'exportCompletedHours': modalTitle.textContent = '📥 导出工时完成统计'; content = ` `; break; case 'exportOutput': modalTitle.textContent = '📥 导出产值工资分析报表'; content = ` `; break; case 'exportVerify': modalTitle.textContent = '📥 导出工资核对报表'; content = ` `; break; case 'importWorkshopWage': modalTitle.textContent = '📤 导入车间工资数据'; content = ` `; break; case 'importPieceWage': modalTitle.textContent = '📤 导入计件工资数据'; content = ` `; break; case 'importPieceWageAnalysis': modalTitle.textContent = '📤 导入计件工资分析数据'; content = ` `; break; case 'importCompletedHours': modalTitle.textContent = '📤 导入工时完成数据'; content = ` `; break; case 'schedule': modalTitle.textContent = '新增生产调度单'; content = ` `; break; } content += ''; modalBody.innerHTML = content; modal.classList.add('show'); } function closeModal() { document.getElementById('modal').classList.remove('show'); } function saveData() { const type = currentModalType; const modal = document.getElementById('modal'); modal.classList.remove('show'); // 根据类型处理数据 switch(type) { case 'workshop': addWorkshopRow(); break; case 'production': addProductionRow(); break; case 'productionLedger': addProductionLedgerRow(); break; case 'wage': addWageRow(); break; case 'energy': addEnergyRow(); break; case 'schedule': addScheduleRow(); break; case 'exportProduction': showToast('📥 生产台账导出中，请稍候...'); setTimeout(() => showToast('✅ 导出成功！文件已保存'), 2000); break; case 'exportYearlySales': showToast('📥 品种历年销售统计导出中，请稍候...'); setTimeout(() => showToast('✅ 导出成功！文件已保存'), 2000); break; case 'exportEnergy': showToast('📥 能源消耗报表导出中...'); break; case 'exportCost': showToast('📥 成本分析报表导出中...'); break; case 'exportOEE': showToast('📥 设备OEE分析报表导出中...'); break; case 'exportViz': showToast('📥 统计可视化报表导出中...'); break; case 'exportWageReport': showToast('📥 工资报表导出中，请稍候...'); setTimeout(() => showToast('✅ 工资报表导出成功！'), 2000); break; case 'exportShipment': showToast('📥 成品发货趋势报表导出中，请稍候...'); setTimeout(() => showToast('✅ 导出成功！文件已保存'), 2000); break; case 'exportLog': showToast('📥 系统日志导出中...'); break; default: break; } showToast('✅ 操作成功！'); } // 新增车间数据 function addWorkshopRow() { const table = document.querySelector('#workshop-tab .data-table tbody'); const nameInput = document.querySelector('#modalBody input[placeholder="请输入车间名称"]'); const leaderInput = document.querySelector('#modalBody input[placeholder="请输入负责人"]'); const name = nameInput?.value || '新车间'; const id = 'WS' + String(Math.floor(Math.random() * 900) + 100); const row = `${id}${name}${leaderInput?.value || '待定'}生技部● 启用${new Date().toISOString().slice(0,10)}编辑`; table.insertAdjacentHTML('beforeend', row); } // 新增生产单数据 function addProductionRow() { const table = document.querySelector('#production-tab .data-table tbody'); const productSelect = document.querySelector('#modalBody select:nth-of-type(1)'); const qtyInput = document.querySelector('#modalBody input[type="number"]'); const id = 'PS' + new Date().getFullYear() + String(Math.floor(Math.random() * 9000) + 1000); const row = `${id}${productSelect?.value || '新产品'}${qtyInput?.value || '0'}待定待定${new Date().toISOString().slice(0,10)}-待计算编辑`; table.insertAdjacentHTML('beforeend', row); } // 新增生产台账记录 function addProductionLedgerRow() { const table = document.querySelector('#production-tab .data-table tbody'); const batchNo = document.getElementById('ledgerBatchNo')?.value || new Date().getTime().toString().slice(-6); const product = document.getElementById('ledgerProduct')?.value || ''; const qty = document.getElementById('ledgerQty')?.value || '0'; const convertedQty = document.getElementById('ledgerConvertedQty')?.value || qty; const workshop = document.getElementById('ledgerWorkshop')?.value || ''; const team = document.getElementById('ledgerTeam')?.value || ''; const startTime = document.getElementById('ledgerStartTime')?.value || ''; const endTime = document.getElementById('ledgerEndTime')?.value || ''; const outputValue = document.getElementById('ledgerOutputValue')?.value || '0'; const formatDate = (datetime) => { if (!datetime) return '-'; return datetime.replace('T', ' '); }; const row = ` ${batchNo} ${product} ${parseInt(qty).toLocaleString()} ${parseInt(convertedQty).toLocaleString()}盒 ${workshop} ${team} ${formatDate(startTime)} ${formatDate(endTime)} ${parseInt(outputValue).toLocaleString()} 编辑 `; table.insertAdjacentHTML('beforeend', row); } // 新增工资记录 function addWageRow() { const table = document.querySelector('#wageEntry-tab .data-table tbody'); const nameInput = document.querySelector('#modalBody input[placeholder="请输入姓名"]'); const qtyInput = document.querySelector('#modalBody input[type="number"]'); const id = 'W' + String(Math.floor(Math.random() * 9000) + 1000); const qty = qtyInput?.value || '0'; const row = `${id}${nameInput?.value || '新员工'}待定待定${qty}待计算● 已录入编辑`; table.insertAdjacentHTML('beforeend', row); } // 新增能耗记录 function addEnergyRow() { const table = document.querySelector('#energyEntry-tab .data-table tbody'); const row = `待定待定---待定-编辑`; table.insertAdjacentHTML('beforeend', row); } // 新增调度单记录 function addScheduleRow() { const table = document.querySelector('#schedule-tab .data-table tbody'); const productSelect = document.querySelector('#scheduleProduct'); const qtyInput = document.querySelector('#scheduleQty'); const startInput = document.querySelector('#scheduleStartDate'); const endInput = document.querySelector('#scheduleEndDate'); const id = 'SC' + new Date().getFullYear() + String(Math.floor(Math.random() * 90000) + 10000); const qty = qtyInput?.value || '0'; const start = startInput?.value || new Date().toISOString().slice(0,10); const end = endInput?.value || new Date().toISOString().slice(0,10); const row = `${id}${productSelect?.value || '待定'}${qty}00%${start}${end}● 待排产详情`; table.insertAdjacentHTML('beforeend', row); } // 下载导入模板 function downloadTemplate(type) { const templates = { production: '生产数据导入模板：批次号,产品名称,生产数量,生产车间,生产班组,开工时间,完工时间', energy: '能耗数据导入模板：车间,能源类型,期初读数,期末读数,单价', wage: '工资数据导入模板：工号,姓名,车间,班组,计件数量,计件单价', cost: '成本数据导入模板：产品名称,直接材料,直接人工,能耗成本,制造费用,产量', device: '设备运行数据导入模板：设备名称,车间,工作时间,故障时间,合格品数' }; const content = templates[type] || '模板内容'; showToast('📥 ' + content.substring(0, 10) + '...模板下载功能开发中'); } function showToast(message) { const toast = document.getElementById('toast'); toast.textContent = message; toast.classList.add('show'); setTimeout(() => toast.classList.remove('show'), 3000); } // 加载车间数据 function loadWorkshopData() { const tbody = document.getElementById('workshopTableBody'); const data = [ {id: 'WS001', name: '前处理车间', leader: '待定', dept: '生技部', status: '启用', date: '2024-01-01'}, {id: 'WS002', name: '一车间', leader: '待定', dept: '生技部', status: '启用', date: '2024-01-01'}, {id: 'WS003', name: '二车间', leader: '待定', dept: '生技部', status: '启用', date: '2024-01-01'}, {id: 'WS004', name: '三车间', leader: '待定', dept: '生技部', status: '启用', date: '2024-01-01'}, {id: 'WS005', name: '公用工程', leader: '待定', dept: '生技部', status: '启用', date: '2024-01-01'} ]; tbody.innerHTML = data.map(item => ` ${item.id} ${item.name} ${item.leader} ${item.dept} ● ${item.status} ${item.date} 编辑 `).join(''); } function editItem(type, id) { currentModalType = type; const modal = document.getElementById('modal'); const modalTitle = document.getElementById('modalTitle'); const modalBody = document.getElementById('modalBody'); let content = ''; switch(type) { case 'editWorkshop': modalTitle.textContent = '📝 编辑车间信息'; content = ` `; break; case 'editTeam': modalTitle.textContent = '📝 编辑班组信息'; content = ` `; break; case 'editProduct': modalTitle.textContent = '📝 编辑产品信息'; content = ` `; break; case 'editProcess': modalTitle.textContent = '📝 编辑工序信息'; content = ` `; break; case 'editEquipment': modalTitle.textContent = '📝 编辑设备信息'; content = ` `; break; case 'editEnergyType': modalTitle.textContent = '📝 编辑能源类型'; content = ` `; break; case 'editProduction': modalTitle.textContent = '📝 编辑生产单'; content = ` `; break; case 'editWage': modalTitle.textContent = '📝 编辑工资记录'; content = ` `; break; case 'editEnergy': modalTitle.textContent = '📝 编辑能源消耗记录'; content = ` `; break; case 'editDevice': modalTitle.textContent = '📝 编辑设备运行记录'; content = ` `; break; case 'editCost': modalTitle.textContent = '📝 编辑成本记录'; content = ` `; break; case 'editUser': modalTitle.textContent = '📝 编辑用户信息'; content = ` `; break; case 'editStdWorkHours': modalTitle.textContent = '📝 编辑标准工时'; content = ` `; break; case 'editPerson': modalTitle.textContent = '📝 编辑人员信息'; content = ` `; break; case 'editSchedule': modalTitle.textContent = '📝 编辑生产调度'; content = ` `; break; case 'viewDeviceDetail': modalTitle.textContent = '🔧 设备运行详情'; content = ` `; break; default: showAddModal(type); return; } modalBody.innerHTML = content; modal.classList.add('show'); } // 图表初始化 let chartsInitialized = false; function initCharts() { if (chartsInitialized) return; chartsInitialized = true; // 产值趋势图 new Chart(document.getElementById('productionTrendChart'), { type: 'line', data: { labels: ['1月', '2月', '3月', '4月', '5月'], datasets: [{ label: '产值（万元）', data: [12480, 12450, 13000, 12600, 13000], borderColor: '#667eea', backgroundColor: 'rgba(102, 126, 234, 0.1)', fill: true, tension: 0.4 }] }, options: { responsive: true, plugins: { legend: { display: false } } } }); // 车间产值饼图 new Chart(document.getElementById('workshopPieChart'), { type: 'doughnut', data: { labels: ['前处理', '一车间', '二车间', '三车间'], datasets: [{ data: [19.3, 25.2, 22.4, 33.1], backgroundColor: ['#667eea', '#764ba2', '#f093fb', '#4facfe'] }] }, options: { responsive: true } }); // 计件工资统计图 new Chart(document.getElementById('wageWorkshopChart'), { type: 'bar', data: { labels: ['前处理', '一车间', '二车间', '三车间', '公用工程'], datasets: [{ label: '工资总额（元）', data: [159860, 256789, 256520, 325632, 200012], backgroundColor: '#667eea' }] }, options: { responsive: true } }); // 能耗饼图 new Chart(document.getElementById('energyPieChart'), { type: 'pie', data: { labels: ['水', '电', '蒸汽', '天然气'], datasets: [{ data: [0.01, 87.8, 11.5, 0.7], backgroundColor: ['#4facfe', '#f093fb', '#667eea', '#764ba2'] }] }, options: { responsive: true } }); // 能耗趋势 new Chart(document.getElementById('energyTrendChart'), { type: 'line', data: { labels: ['1月', '2月', '3月', '4月', '5月'], datasets: [{ label: '能耗费用（元）', data: [445012, 0, 0, 0, 0], borderColor: '#667eea', backgroundColor: 'rgba(102, 126, 234, 0.1)', fill: true }] }, options: { responsive: true } }); // OEE趋势 new Chart(document.getElementById('oeeTrendChart'), { type: 'line', data: { labels: ['1月', '2月', '3月'], datasets: [{ label: 'OEE', data: [82.8, 80.7, 85.3], borderColor: '#667eea', fill: false }] }, options: { responsive: true } }); // M07统计可视化图表初始化 // 产值与成本趋势 if (document.getElementById('costTrendChart')) { new Chart(document.getElementById('costTrendChart'), { type: 'bar', data: { labels: ['1月', '2月', '3月', '4月', '5月'], datasets: [{ label: '产值（万元）', data: [12480, 12450, 13000, 12600, 13000], backgroundColor: '#667eea' }, { label: '成本（万元）', data: [13120, 13050, 13650, 13280, 13520], backgroundColor: '#f093fb' }] }, options: { responsive: true, plugins: { legend: { position: 'top' }, tooltip: { callbacks: { label: (ctx) => ctx.dataset.label + ': ' + ctx.raw.toLocaleString() + '万元' } } }, scales: { y: { beginAtZero: false } } } }); } // 工资与产量关联 if (document.getElementById('wageOutputChart')) { new Chart(document.getElementById('wageOutputChart'), { type: 'line', data: { labels: ['1月', '2月', '3月', '4月', '5月'], datasets: [{ label: '产量（吨）', data: [850, 840, 870, 860, 865], borderColor: '#667eea', backgroundColor: 'rgba(102, 126, 234, 0.1)', fill: true, yAxisID: 'y' }, { label: '工资总额（万元）', data: [119.88, 118.56, 122.05, 119.85, 121.00], borderColor: '#f093fb', backgroundColor: 'rgba(240, 147, 251, 0.1)', fill: true, yAxisID: 'y1' }] }, options: { responsive: true, plugins: { legend: { position: 'top' } }, scales: { y: { type: 'linear', position: 'left', title: { display: true, text: '产量（吨）' } }, y1: { type: 'linear', position: 'right', title: { display: true, text: '工资（万元）' }, grid: { drawOnChartArea: false } } } } }); } // 能耗效率分析 if (document.getElementById('energyEfficiencyChart')) { new Chart(document.getElementById('energyEfficiencyChart'), { type: 'bar', data: { labels: ['前处理', '一车间', '二车间', '三车间'], datasets: [{ label: '万元产值能耗（元）', data: [118, 125, 132, 121], backgroundColor: ['#667eea', '#764ba2', '#f093fb', '#4facfe'] }] }, options: { responsive: true, plugins: { legend: { display: false } }, scales: { y: { beginAtZero: true, title: { display: true, text: '元/万元产值' } } } } }); } // 设备OEE趋势 if (document.getElementById('deviceOeeChart')) { new Chart(document.getElementById('deviceOeeChart'), { type: 'line', data: { labels: ['1月', '2月', '3月', '4月', '5月'], datasets: [{ label: '时间开动率', data: [95.2, 93.9, 96.0, 94.5, 95.5], borderColor: '#667eea', fill: false }, { label: '性能开动率', data: [88.8, 87.6, 90.7, 89.2, 90.5], borderColor: '#f093fb', fill: false }, { label: '合格品率', data: [98, 98, 98, 98, 98], borderColor: '#4facfe', fill: false }, { label: 'OEE综合', data: [82.8, 80.7, 85.3, 83.5, 84.2], borderColor: '#43e97b', borderWidth: 3, fill: false }] }, options: { responsive: true, plugins: { legend: { position: 'top' } }, scales: { y: { min: 70, max: 100, title: { display: true, text: '百分比（%）' } } } } }); } // 产值月度趋势图 if (document.getElementById('outputTrendChart')) { new Chart(document.getElementById('outputTrendChart'), { type: 'line', data: { labels: ['1月', '2月', '3月', '4月', '5月'], datasets: [{ label: '产值（万元）', data: [12480, 12450, 13000, 12600, 13000], borderColor: '#667eea', backgroundColor: 'rgba(102, 126, 234, 0.1)', fill: true, tension: 0.4 }] }, options: { responsive: true, plugins: { legend: { display: false } }, scales: { y: { beginAtZero: false, title: { display: true, text: '产值（万元）' } } } } }); } // 各车间产值占比 if (document.getElementById('outputWorkshopChart')) { new Chart(document.getElementById('outputWorkshopChart'), { type: 'doughnut', data: { labels: ['前处理车间', '一车间', '二车间', '三车间'], datasets: [{ data: [2380, 3200, 2800, 4100], backgroundColor: ['#667eea', '#764ba2', '#f093fb', '#4facfe'] }] }, options: { responsive: true, plugins: { legend: { position: 'right' }, tooltip: { callbacks: { label: (ctx) => ctx.label + ': ' + ctx.raw.toLocaleString() + '万元' } } } } }); } // 成本构成分析图 if (document.getElementById('costBreakdownChart')) { new Chart(document.getElementById('costBreakdownChart'), { type: 'pie', data: { labels: ['直接材料', '直接人工', '能耗成本', '制造费用'], datasets: [{ data: [13, 14, 13.18, 0], backgroundColor: ['#667eea', '#f093fb', '#4facfe', '#43e97b'] }] }, options: { responsive: true, plugins: { legend: { position: 'right' }, tooltip: { callbacks: { label: (ctx) => ctx.label + ': ' + ctx.raw + '万元' } } } } }); } } // M07刷新图表 function refreshVizCharts() { const year = document.getElementById('vizYear')?.value || '2026'; const month = document.getElementById('vizMonth')?.value || 'all'; const workshop = document.getElementById('vizWorkshop')?.value || ''; showToast('📊 已刷新 ' + year + '年数据'); chartsInitialized = false; initCharts(); } // M07导出数据 function exportVizData() { showToast('📥 正在导出综合分析报表...'); } // 设备目录动态台账 const deviceCatalogColumns = [ { key: 'name', label: '设备名称', required: true }, { key: 'model', label: '规格型号' }, { key: 'code', label: '设备编号', required: true }, { key: 'manufacturer', label: '制造厂家' }, { key: 'location', label: '安装位置' }, { key: 'category', label: '设备分类' }, { key: 'purchaseDate', label: '购入日期' }, { key: 'status', label: '使用状态' }, { key: 'remark', label: '备注' } ]; let deviceCatalogRows = [ { id: 1, name: '炒药机', model: 'CYJ-800', code: 'QC-001', manufacturer: '浙江制药设备厂', location: '前处理', category: '前处理设备', purchaseDate: '2020-03', status: '正常', remark: '-' }, { id: 2, name: '粉碎机', model: 'FS-500', code: 'QC-002', manufacturer: '江苏机械厂', location: '前处理', category: '前处理设备', purchaseDate: '2020-05', status: '正常', remark: '-' }, { id: 3, name: '润药机', model: 'RY-300', code: 'QC-003', manufacturer: '山东设备公司', location: '前处理', category: '前处理设备', purchaseDate: '2021-01', status: '正常', remark: '-' }, { id: 4, name: '压片机1#', model: 'ZP-35', code: 'ZZ-001', manufacturer: '上海制药机械', location: '三车间', category: '制剂设备', purchaseDate: '2019-08', status: '正常', remark: '-' }, { id: 5, name: '压片机2#', model: 'ZP-35', code: 'ZZ-002', manufacturer: '上海制药机械', location: '三车间', category: '制剂设备', purchaseDate: '2019-08', status: '正常', remark: '-' }, { id: 6, name: '臭氧发生器', model: 'CF-G-5', code: 'GY-001', manufacturer: '环保设备厂', location: '公用工程', category: '公用工程设备', purchaseDate: '2018-12', status: '正常', remark: '-' } ]; const deviceCatalogReportFieldLabels = { category: '设备分类', model: '规格型号', location: '安装位置', manufacturer: '制造厂家', status: '使用状态', purchaseYear: '购入年份' }; let deviceCatalogEditingId = null; let deviceCatalogChart = null; let deviceCatalogChartType = 'bar'; function escapeHtml(value) { return String(value ?? '').replace(/[&<>"']/g, (match) => ({ '&': '&', '<': '<', '>': '>', '"': '"', "'": ''' }[match])); } function getUniqueDeviceValues(key) { return [...new Set(deviceCatalogRows.map(row => row[key]).filter(Boolean))].sort(); } function getFilteredDeviceCatalogRows() { const category = document.getElementById('deviceCatalogType')?.value || ''; const location = document.getElementById('deviceCatalogLocation')?.value || ''; const keyword = (document.getElementById('deviceCatalogKeyword')?.value || '').trim().toLowerCase(); return deviceCatalogRows.filter(row => { const text = [row.name, row.model, row.code, row.manufacturer, row.remark].join(' ').toLowerCase(); return (!category || row.category === category) && (!location || row.location === location) && (!keyword || text.includes(keyword)); }); } function renderDeviceCatalogModule() { const host = document.getElementById('deviceCatalog-tab'); if (!host) return; host.innerHTML = ` `; renderDeviceCatalogFilters(); renderDeviceCatalogChartFieldOptions(['category', 'model', 'location', 'status', 'manufacturer', 'purchaseYear'], 'category'); renderDeviceCatalogStats(); renderDeviceCatalogTable(); renderDeviceCatalogChart(); } function renderDeviceCatalogFilters() { const categorySelect = document.getElementById('deviceCatalogType'); const locationSelect = document.getElementById('deviceCatalogLocation'); if (!categorySelect || !locationSelect) return; categorySelect.innerHTML = '全部分类' + getUniqueDeviceValues('category').map(value => `${escapeHtml(value)}`).join(''); locationSelect.innerHTML = '全部位置' + getUniqueDeviceValues('location').map(value => `${escapeHtml(value)}`).join(''); } function renderDeviceCatalogChartFieldOptions(fields, selectedField) { const chartField = document.getElementById('deviceCatalogChartField'); if (!chartField) return; const normalizedFields = (fields && fields.length ? fields : ['category']) .filter((field, index, list) => list.indexOf(field) === index); chartField.innerHTML = normalizedFields .map(field => `${escapeHtml(deviceCatalogReportFieldLabels[field] || field)}`) .join(''); chartField.value = selectedField && normalizedFields.includes(selectedField) ? selectedField : normalizedFields[0]; } function renderDeviceCatalogStats() { const stats = document.getElementById('deviceCatalogStats'); if (!stats) return; const total = deviceCatalogRows.length; const categories = getUniqueDeviceValues('category').length; const locations = getUniqueDeviceValues('location').length; const normalRate = total ? Math.round(deviceCatalogRows.filter(row => row.status === '正常').length / total * 100) : 0; stats.innerHTML = ` `; } function renderDeviceCatalogTable() { const body = document.getElementById('deviceCatalogTableBody'); if (!body) return; const rows = getFilteredDeviceCatalogRows(); if (!rows.length) { body.innerHTML = ``; return; } body.innerHTML = rows.map((row, index) => deviceCatalogEditingId === row.id ? renderDeviceCatalogEditRow(row, index) : renderDeviceCatalogDisplayRow(row, index) ).join(''); } function renderDeviceCatalogDisplayRow(row, index) { return ` ${index + 1} ${deviceCatalogColumns.map(col => `${col.key === 'status' ? renderDeviceCatalogStatus(row[col.key]) : escapeHtml(row[col.key] || '-')}`).join('')} `; } function renderDeviceCatalogEditRow(row, index) { return ` ${index + 1} ${deviceCatalogColumns.map(col => ` ${col.key === 'status' ? `正常维修中停用` : `` } `).join('')} `; } function renderDeviceCatalogStatus(status) { const normalized = status || '正常'; const cls = normalized === '正常' ? 'normal' : normalized === '维修中' ? 'repair' : 'stop'; return `● ${escapeHtml(normalized)}`; } function startDeviceCatalogEdit(id) { deviceCatalogEditingId = id; renderDeviceCatalogTable(); } function cancelDeviceCatalogEdit() { deviceCatalogEditingId = null; renderDeviceCatalogTable(); } function saveDeviceCatalogInlineEdit(id) { const row = deviceCatalogRows.find(item => item.id === id); const tr = [...document.querySelectorAll('#deviceCatalogTableBody tr')].find(item => item.querySelector(`[onclick="saveDeviceCatalogInlineEdit(${id})"]`)); if (!row || !tr) return; tr.querySelectorAll('[data-field]').forEach(input => { row[input.dataset.field] = input.value.trim() || '-'; }); if (!row.name || row.name === '-' || !row.code || row.code === '-') { showToast('请填写设备名称和设备编号'); return; } deviceCatalogEditingId = null; renderDeviceCatalogFilters(); renderDeviceCatalogStats(); renderDeviceCatalogTable(); renderDeviceCatalogChart(); showToast('设备信息已更新'); } function deleteDeviceCatalogRow(id) { if (!confirm('确认删除这条设备记录？')) return; deviceCatalogRows = deviceCatalogRows.filter(row => row.id !== id); deviceCatalogEditingId = null; renderDeviceCatalogFilters(); renderDeviceCatalogStats(); renderDeviceCatalogTable(); renderDeviceCatalogChart(); showToast('设备记录已删除'); } function openDeviceCatalogCreateModal() { const modal = document.getElementById('modal'); const modalTitle = document.getElementById('modalTitle'); const modalBody = document.getElementById('modalBody'); if (!modal || !modalTitle || !modalBody) return; modalTitle.textContent = '新增设备'; modalBody.innerHTML = ` ${deviceCatalogColumns.map(col => ` `).join('')} `; modal.classList.add('show'); } function createDeviceCatalogRow(event) { event.preventDefault(); const form = event.target; const nextId = Math.max(0, ...deviceCatalogRows.map(row => row.id)) + 1; const row = { id: nextId }; deviceCatalogColumns.forEach(col => row[col.key] = (form.elements[col.key]?.value || '-').trim() || '-'); deviceCatalogRows.unshift(row); closeModal(); renderDeviceCatalogFilters(); renderDeviceCatalogStats(); renderDeviceCatalogTable(); renderDeviceCatalogChart(); showToast('设备已新增'); } function openDeviceCatalogReportModal() { const modal = document.getElementById('modal'); const modalTitle = document.getElementById('modalTitle'); const modalBody = document.getElementById('modalBody'); if (!modal || !modalTitle || !modalBody) return; modalTitle.textContent = '自定义统计报表'; modalBody.innerHTML = ` `; modal.classList.add('show'); } function selectDeviceReportChartType(type, element) { const input = document.getElementById('deviceReportChartType'); if (input) input.value = type; document.querySelectorAll('.report-type-card').forEach(card => card.classList.remove('active')); element.classList.add('active'); } function generateDeviceCatalogReport() { const checkedFields = [...document.querySelectorAll('input[name="deviceReportField"]:checked')].map(item => item.value); const selectedField = checkedFields[0] || 'category'; const chartType = document.getElementById('deviceReportChartType')?.value || 'bar'; const category = document.getElementById('deviceReportCategory')?.value || ''; const categoryFilter = document.getElementById('deviceCatalogType'); renderDeviceCatalogChartFieldOptions(checkedFields.length ? checkedFields : ['category'], selectedField); if (categoryFilter) categoryFilter.value = category; deviceCatalogChartType = chartType; renderDeviceCatalogSelectedFields(checkedFields.length ? checkedFields : ['category']); renderDeviceCatalogTable(); renderDeviceCatalogChart(); closeModal(); showToast('统计报表已生成'); } function renderDeviceCatalogSelectedFields(fields) { const host = document.getElementById('deviceCatalogReportFields'); if (!host) return; host.classList.add('show'); host.innerHTML = ` 已选择字段 ${fields.map(field => `${escapeHtml(deviceCatalogReportFieldLabels[field] || field)}`).join('')} `; } function getDeviceCatalogReportFields() { const chips = [...document.querySelectorAll('#deviceCatalogReportFields .report-field-chip')].map(chip => chip.dataset.field).filter(Boolean); const chartField = document.getElementById('deviceCatalogChartField')?.value || 'category'; return chips.length ? chips : [chartField]; } function getDeviceCatalogChartTypeLabel() { return { bar: '分组柱状图', line: '月度折线图', doughnut: '环形饼图' }[deviceCatalogChartType] || '分组柱状图'; } function exportDeviceCatalogReport() { const canvas = document.getElementById('deviceCatalogBarChart'); if (!canvas || !deviceCatalogChart) { showToast('请先生成统计报表'); return; } const chartImage = canvas.toDataURL('image/png'); const html = ` `; const blob = new Blob([html], { type: 'text/html;charset=utf-8' }); const link = document.createElement('a'); link.href = URL.createObjectURL(blob); link.download = `设备目录统计报表_${new Date().toISOString().slice(0, 10)}.html`; link.click(); URL.revokeObjectURL(link.href); showToast('统计报表已导出'); } function showDeviceCatalogDetail(id) { const row = deviceCatalogRows.find(item => item.id === id); const modal = document.getElementById('modal'); const modalTitle = document.getElementById('modalTitle'); const modalBody = document.getElementById('modalBody'); if (!row || !modal || !modalTitle || !modalBody) return; modalTitle.textContent = '设备详情'; modalBody.innerHTML = ` `; modal.classList.add('show'); } function resetDeviceCatalogFilters() { const category = document.getElementById('deviceCatalogType'); const location = document.getElementById('deviceCatalogLocation'); const keyword = document.getElementById('deviceCatalogKeyword'); if (category) category.value = ''; if (location) location.value = ''; if (keyword) keyword.value = ''; renderDeviceCatalogTable(); renderDeviceCatalogChart(); } function getChartFieldValue(row, field) { if (field === 'purchaseYear') return String(row.purchaseDate || '').slice(0, 4) || '未填写'; return row[field] || '未填写'; } function renderDeviceCatalogChart() { const canvas = document.getElementById('deviceCatalogBarChart'); if (!canvas || !window.Chart) return; const field = document.getElementById('deviceCatalogChartField')?.value || 'category'; const counts = getFilteredDeviceCatalogRows().reduce((acc, row) => { const key = getChartFieldValue(row, field); acc[key] = (acc[key] || 0) + 1; return acc; }, {}); const labels = Object.keys(counts); const values = labels.map(label => counts[label]); if (deviceCatalogChart) deviceCatalogChart.destroy(); const chartType = deviceCatalogChartType || 'bar'; deviceCatalogChart = new Chart(canvas, { type: chartType, data: { labels, datasets: [{ label: '设备数量', data: values, borderColor: '#1677ff', borderWidth: chartType === 'line' ? 2 : 0, tension: 0.35, fill: chartType === 'line', backgroundColor: chartType === 'line' ? 'rgba(22, 119, 255, 0.14)' : ['#667eea', '#43e97b', '#f093fb', '#4facfe', '#764ba2', '#faad14', '#dc3545'] }] }, options: { responsive: true, plugins: { legend: { display: chartType === 'doughnut' } }, scales: chartType === 'doughnut' ? {} : { y: { beginAtZero: true, ticks: { precision: 0 } } } } }); } function mapDeviceCatalogImportRow(row, index) { const aliases = { name: ['设备名称', '名称', '设备/设施名称'], model: ['规格型号', '型号'], code: ['设备编号', '编号', '资产编号'], manufacturer: ['制造厂家', '厂家', '生产厂家'], location: ['安装位置', '位置', '使用车间', '车间'], category: ['设备分类', '分类', '类别'], purchaseDate: ['购入日期', '购买日期', '启用日期'], status: ['使用状态', '状态'], remark: ['备注', '说明'] }; const mapped = { id: Date.now() + index }; deviceCatalogColumns.forEach(col => { const foundKey = aliases[col.key].find(name => Object.prototype.hasOwnProperty.call(row, name)); mapped[col.key] = foundKey ? String(row[foundKey] ?? '').trim() : ''; }); mapped.name ||= `导入设备${index + 1}`; mapped.code ||= `IMPORT-${String(index + 1).padStart(3, '0')}`; mapped.status ||= '正常'; mapped.remark ||= '-'; return mapped; } function importDeviceCatalogExcel(event) { const file = event.target.files?.[0]; if (!file) return; const reader = new FileReader(); reader.onload = (loadEvent) => { try { const workbook = XLSX.read(loadEvent.target.result, { type: 'array' }); const sheet = workbook.Sheets[workbook.SheetNames[0]]; const rows = XLSX.utils.sheet_to_json(sheet, { defval: '' }); if (!rows.length) { showToast('Excel中没有可导入的数据'); return; } const importedRows = rows.map((row, index) => mapDeviceCatalogImportRow(row, deviceCatalogRows.length + index)); deviceCatalogRows = [...deviceCatalogRows, ...importedRows]; deviceCatalogEditingId = null; renderDeviceCatalogFilters(); renderDeviceCatalogStats(); renderDeviceCatalogTable(); renderDeviceCatalogChart(); showToast(`已追加导入 ${importedRows.length} 条设备记录，当前共 ${deviceCatalogRows.length} 条`); } catch (error) { showToast('导入失败，请检查Excel格式'); } finally { event.target.value = ''; } }; reader.readAsArrayBuffer(file); } function exportDeviceCatalogExcel() { if (!window.XLSX) { showToast('Excel组件加载失败，请检查网络'); return; } const rows = deviceCatalogRows.map((row, index) => ({ 序号: index + 1, 设备名称: row.name, 规格型号: row.model, 设备编号: row.code, 制造厂家: row.manufacturer, 安装位置: row.location, 设备分类: row.category, 购入日期: row.purchaseDate, 使用状态: row.status, 备注: row.remark })); const worksheet = XLSX.utils.json_to_sheet(rows); const workbook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(workbook, worksheet, '设备目录'); XLSX.writeFile(workbook, `设备目录_${new Date().toISOString().slice(0, 10)}.xlsx`); showToast('已按最新数据导出Excel'); } // 页面加载时初始化 document.addEventListener('DOMContentLoaded', function() { renderDeviceCatalogModule(); try { loadWorkshopData(); } catch (error) { console.warn('车间数据初始化失败，不影响设备目录模块：', error); } try { initCharts(); } catch (error) { console.warn('图表初始化失败，不影响设备目录模块：', error); } });