import { useState, useEffect } 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(""); useEffect(() => { const saved = localStorage.getItem("user"); if (saved) setCurrentUser(JSON.parse(saved)); }, []); const handleLogin = () => { const user = users.find(u => u.email === email); if (!user) { alert("Access Denied. Contact Admin."); return; } setCurrentUser(user); localStorage.setItem("user", JSON.stringify(user)); }; const handleLogout = () => { setCurrentUser(null); localStorage.removeItem("user"); }; const addUser = () => { if (currentUser.role !== "admin") { alert("Only admin can add users"); return; } const newEmail = prompt("Enter email"); const role = prompt("Enter role (leader / designer)"); if (!newEmail || !role) return; if (users.some(u => u.email === newEmail)) { alert("User already exists"); return; } setUsers([...users, { email: newEmail, role }]); }; // ---------------- DATA ---------------- const [projects, setProjects] = useState([]); const [projectName, setProjectName] = useState(""); const [projectNo, setProjectNo] = useState(""); const stages = [ "Design", "Manufacturing", "Inspection & Kitting", "Assembly", "Trial", "Sample Validation", "Pilot Run", "Handover" ]; // ---------------- HELPERS ---------------- const getDelayInfo = (plannedEnd, actualEnd) => { if (!plannedEnd) return { delayDays: 0, isDelayed: false }; const today = new Date(); const pEnd = new Date(plannedEnd); if (actualEnd) { const diff = (new Date(actualEnd) - pEnd) / (1000 * 60 * 60 * 24); return { delayDays: diff > 0 ? diff : 0, isDelayed: diff > 0 }; } const diff = (today - pEnd) / (1000 * 60 * 60 * 24); return { delayDays: diff > 0 ? diff : 0, isDelayed: diff > 0 }; }; const getFinancialYear = (date) => { const d = new Date(date); const y = d.getMonth() >= 3 ? d.getFullYear() : d.getFullYear() - 1; return `${y}-${y + 1}`; }; const getProjectStatus = (p) => { return Object.values(p.stages).some(s => s.status === "Delay") ? "Delay" : "On Time"; }; // ---------------- ADD PROJECT ---------------- const addProject = () => { if (currentUser.role !== "admin") { alert("Only admin can create projects"); return; } if (!projectName || !projectNo) return; const stageData = {}; stages.forEach(s => { stageData[s] = { plannedStart: "", plannedEnd: "", actualStart: "", actualEnd: "", delayDays: 0, status: "On Time" }; }); 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 }; if (field === "actualEnd" && !updated.actualStart) { updated.actualStart = updated.plannedStart; } const { delayDays, isDelayed } = getDelayInfo( updated.plannedEnd, updated.actualEnd ); updated.delayDays = delayDays; updated.status = isDelayed ? "Delay" : "On Time"; return { ...p, stages: { ...p.stages, [stage]: updated } }; }) ); }; // ---------------- AUTO DELAY CHECK ---------------- useEffect(() => { const interval = setInterval(() => { setProjects(prev => prev.map(p => { const updatedStages = {}; Object.entries(p.stages).forEach(([stage, s]) => { const { delayDays, isDelayed } = getDelayInfo(s.plannedEnd, s.actualEnd); updatedStages[stage] = { ...s, delayDays, status: isDelayed ? "Delay" : "On Time" }; }); return { ...p, stages: updatedStages }; }) ); }, 60000); return () => clearInterval(interval); }, []); // ---------------- 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]; } }); // ---------------- ROLE FILTER ---------------- const visibleProjects = projects.filter(p => { if (currentUser.role === "admin") return true; if (currentUser.role === "leader") return p.leader === currentUser.email; if (currentUser.role === "designer") return p.designer === currentUser.email; return false; }); const activeProjects = visibleProjects.filter(p => !p.completed); const completedProjects = visibleProjects.filter(p => p.completed); const delayedProjects = visibleProjects.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; }); }); // ---------------- EXCEL EXPORT ---------------- const exportToExcel = () => { const wb = XLSX.utils.book_new(); const data = projects.map(p => ({ Project: p.name, Status: getProjectStatus(p), TotalDelay: Object.values(p.stages).reduce((a, s) => a + s.delayDays, 0) })); const ws = XLSX.utils.json_to_sheet(data); XLSX.utils.book_append_sheet(wb, ws, "Projects"); XLSX.writeFile(wb, "Project_Dashboard.xlsx"); }; // ---------------- LOGIN UI ---------------- if (!currentUser) { return (

Login

Only authorized email IDs can access

setEmail(e.target.value)} />
); } // ---------------- MAIN UI ---------------- return (

{currentUser.email}

Project Dashboard

Total: {visibleProjects.length}

Delayed: {delayedProjects.length}

{currentUser.role === "admin" && ( <>

Add Project

setProjectName(e.target.value)} /> setProjectNo(e.target.value)} /> )} {activeProjects.map(p => { const status = getProjectStatus(p); return (

{p.name} - {status}

{stages.map(stage => { const s = p.stages[stage]; return (
{stage}
PS updateStage(p.id, stage, "plannedStart", e.target.value)} /> PE updateStage(p.id, stage, "plannedEnd", e.target.value)} /> AS updateStage(p.id, stage, "actualStart", e.target.value)} /> AC updateStage(p.id, stage, "actualEnd", e.target.value)} /> Delay: {s.delayDays}
); })}
); })}
); }