import { useState } from "react"; import * as XLSX from "xlsx"; export default function ProjectManagementApp() { // ---------------- AUTH ---------------- const [users, setUsers] = useState([ { email: "admin@company.com", role: "admin" } ]); const [currentUser, setCurrentUser] = useState(null); const [email, setEmail] = useState(""); // ---------------- DATA ---------------- const [projects, setProjects] = useState([]); const [projectName, setProjectName] = useState(""); const [projectNo, setProjectNo] = useState(""); const stages = [ "Design","Manufacturing","Inspection","Trial", "Validation","Pilot","Handover" ]; // ---------------- HELPERS ---------------- const getDelayDays = (plannedEnd, actualEnd) => { if (!plannedEnd || !actualEnd) return 0; const diff = (new Date(actualEnd) - new Date(plannedEnd)) / (1000*60*60*24); return diff > 0 ? diff : 0; }; const getFinancialYear = (date) => { const d = new Date(date); const year = d.getMonth() >= 3 ? d.getFullYear() : d.getFullYear() - 1; return `${year}-${year+1}`; }; // ---------------- LOGIN ---------------- const handleLogin = () => { const user = users.find(u => u.email === email); if (user) setCurrentUser(user); else alert("Access Denied"); }; // ---------------- ADD USER ---------------- const addUser = () => { const newEmail = prompt("Enter email"); if (newEmail) setUsers([...users, { email: newEmail, role: "user" }]); }; // ---------------- ADD PROJECT ---------------- const addProject = () => { if (!projectName || !projectNo) return; const stageData = {}; stages.forEach(s => { stageData[s] = { plannedStart: "", plannedEnd: "", actualStart: "", actualEnd: "", status: "On Time", delayDays: 0, issue: "" }; }); setProjects([ ...projects, { id: Date.now(), name: projectName, number: projectNo, designer: "", leader: "", helpers: [], completed: false, completedDate: "", stages: stageData } ]); setProjectName(""); setProjectNo(""); }; // ---------------- UPDATE STAGE ---------------- const updateStage = (id, stage, field, value) => { setProjects(prev => prev.map(p => { if (p.id !== id) return p; const updated = { ...p.stages[stage], [field]: value }; const delay = getDelayDays(updated.plannedEnd, updated.actualEnd); updated.delayDays = delay; updated.status = delay > 0 ? "Delay" : "On Time"; return { ...p, stages: { ...p.stages, [stage]: updated } }; }) ); }; // ---------------- ADD HELPER ---------------- const addHelper = (id, helper) => { if (!helper) return; setProjects(prev => prev.map(p => p.id === id ? { ...p, helpers: [...p.helpers, helper] } : p ) ); }; // ---------------- AUTO COMPLETE ---------------- projects.forEach(p => { const done = Object.values(p.stages).every(s => s.actualEnd); if (done && !p.completed) { p.completed = true; p.completedDate = new Date().toISOString().split("T")[0]; } }); // ---------------- FILTER ---------------- const activeProjects = projects.filter(p => !p.completed); const completedProjects = projects.filter(p => p.completed); const delayedProjects = projects.filter(p => Object.values(p.stages).some(s => s.status === "Delay") ); // ---------------- LOAD ---------------- const designerLoad = {}; const helperLoad = {}; activeProjects.forEach(p => { if (p.designer) { designerLoad[p.designer] = (designerLoad[p.designer] || 0) + 1; } p.helpers.forEach(h => { helperLoad[h] = (helperLoad[h] || 0) + 1; }); }); // ---------------- COMPLETED SUMMARY ---------------- const completedSummary = {}; completedProjects.forEach(p => { const fy = getFinancialYear(p.completedDate); if (!completedSummary[fy]) { completedSummary[fy] = { onTime: 0, delayed: 0, months: {} }; } const delayedStages = Object.values(p.stages).filter(s => s.delayDays > 0); if (delayedStages.length > 0) { completedSummary[fy].delayed++; } else { completedSummary[fy].onTime++; } const month = new Date(p.completedDate).toLocaleString("default",{month:"short"}); completedSummary[fy].months[month] = (completedSummary[fy].months[month] || 0) + 1; }); // ---------------- STAGE DELAY DATA ---------------- const stageDelayData = {}; stages.forEach(s => stageDelayData[s] = 0); projects.forEach(p => { stages.forEach(s => { stageDelayData[s] += p.stages[s].delayDays || 0; }); }); // ---------------- EXPORT TO EXCEL ---------------- const exportToExcel = () => { const activeData = activeProjects.map(p => ({ ProjectName: p.name, ProjectNo: p.number, Designer: p.designer, Leader: p.leader, TotalDelayDays: Object.values(p.stages).reduce((a,s)=>a+s.delayDays,0), DelayedStages: Object.values(p.stages).filter(s=>s.delayDays>0).length })); const stageData = []; projects.forEach(p => { Object.entries(p.stages).forEach(([stage, s]) => { stageData.push({ Project: p.name, Stage: stage, PlannedStart: s.plannedStart, PlannedEnd: s.plannedEnd, ActualStart: s.actualStart, ActualEnd: s.actualEnd, DelayDays: s.delayDays, Status: s.status, Issue: s.issue }); }); }); const completedData = []; Object.entries(completedSummary).forEach(([fy, data]) => { completedData.push({ FinancialYear: fy, OnTimeProjects: data.onTime, DelayedProjects: data.delayed }); Object.entries(data.months).forEach(([month, count]) => { completedData.push({ FinancialYear: fy, Month: month, CompletedProjects: count }); }); }); const stageDelaySheet = Object.entries(stageDelayData).map(([stage, days]) => ({ Stage: stage, TotalDelayDays: days })); const wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, XLSX.utils.json_to_sheet(activeData), "Active Projects"); XLSX.utils.book_append_sheet(wb, XLSX.utils.json_to_sheet(stageData), "Stage Details"); XLSX.utils.book_append_sheet(wb, XLSX.utils.json_to_sheet(completedData), "Completed Summary"); XLSX.utils.book_append_sheet(wb, XLSX.utils.json_to_sheet(stageDelaySheet), "Stage Delay"); XLSX.writeFile(wb, "Project_Dashboard.xlsx"); }; // ---------------- LOGIN UI ---------------- if (!currentUser) { return (