{children}

;\n}\n\nexport function StatCard({ title, value, icon, color = \"blue\" }: { title: string; value: any; icon: string; color?: string }) {\n const colorMap: Record = {\n blue: \"bg-blue-50 text-blue-600\",\n green: \"bg-green-50 text-green-600\",\n red: \"bg-red-50 text-red-600\",\n yellow: \"bg-yellow-50 text-yellow-600\",\n purple: \"bg-purple-50 text-purple-600\",\n orange: \"bg-orange-50 text-orange-600\",\n gray: \"bg-gray-50 text-gray-600\",\n };\n return (\n \n

{title}

{value ?? 0}

{icon}

\n \n );\n}\n\n// ─── Button ───\nexport function Button({ children, onClick, variant = \"primary\", size = \"md\", disabled, type = \"button\", className = \"\" }: any) {\n const variants: Record = {\n primary: \"bg-blue-600 hover:bg-blue-700 text-white\",\n secondary: \"bg-slate-200 hover:bg-slate-300 text-slate-700\",\n danger: \"bg-red-600 hover:bg-red-700 text-white\",\n success: \"bg-green-600 hover:bg-green-700 text-white\",\n outline: \"border border-slate-300 hover:bg-slate-50 text-slate-700\",\n ghost: \"hover:bg-slate-100 text-slate-600\",\n };\n const sizes: Record = {\n sm: \"px-3 py-1.5 text-xs\",\n md: \"px-4 py-2 text-sm\",\n lg: \"px-6 py-3 text-base\",\n };\n return (\n \n );\n}\n\n// ─── Input ───\nexport function Input({ label, type = \"text\", value, onChange, placeholder, required, className = \"\" }: any) {\n return (\n

\n {label && {label}{required && *}}\n \n

\n );\n}\n\nexport function Select({ label, value, onChange, options, required, className = \"\" }: any) {\n return (\n

\n {label && {label}{required && *}}\n \n

\n );\n}\n\nexport function Textarea({ label, value, onChange, placeholder, required, rows = 3, className = \"\" }: any) {\n return (\n

\n {label && {label}{required && *}}\n

\n    </div>\n  );\n}\n\n// ─── Modal ───\nexport function Modal({ open, onClose, title, children, size = \"md\" }: any) {\n  if (!open) return null;\n  const sizes: Record<string, string> = { sm: \"max-w-md\", md: \"max-w-lg\", lg: \"max-w-2xl\", xl: \"max-w-4xl\" };\n  return (\n    <div class=\"fixed inset-0 z-50 flex items-center justify-center p-4 bg-black/50\" onClick={onClose}>\n      <div class={`bg-white rounded-xl shadow-xl w-full ${sizes[size]} max-h-[90vh] overflow-y-auto`} onClick={e => e.stopPropagation()}>\n        <div class=\"flex items-center justify-between p-4 border-b border-slate-200 sticky top-0 bg-white z-10\">\n          <h3 class=\"text-lg font-semibold text-slate-800\">{title}</h3>\n          <button onClick={onClose} class=\"text-slate-400 hover:text-slate-600 text-2xl leading-none\">×</button>\n        </div>\n        <div class=\"p-4\">{children}</div>\n      </div>\n    </div>\n  );\n}\n\n// ─── Table ───\nexport function Table({ headers, children }: { headers: string[]; children: ReactNode }) {\n  return (\n    <div class=\"overflow-x-auto\">\n      <table class=\"w-full text-sm\">\n        <thead>\n          <tr class=\"border-b-2 border-slate-200\">\n            {headers.map(h => <th class=\"text-left py-2 px-3 font-semibold text-slate-600 whitespace-nowrap\">{h}</th>)}\n          </tr>\n        </thead>\n        <tbody>{children}</tbody>\n      </table>\n    </div>\n  );\n}\n\nexport function Tr({ children, onClick }: any) {\n  return <tr class=\"border-b border-slate-100 hover:bg-slate-50 cursor-default\" onClick={onClick}>{children}</tr>;\n}\n\nexport function Td({ children, className = \"\" }: any) {\n  return <td class={`py-2 px-3 text-slate-700 ${className}`}>{children}</td>;\n}\n\n// ─── Loading ───\nexport function Loading() {\n  return (\n    <div class=\"flex items-center justify-center py-12\">\n      <div class=\"w-8 h-8 border-3 border-blue-200 border-t-blue-600 rounded-full animate-spin\"></div>\n    </div>\n  );\n}\n\n// ─── Empty State ───\nexport function EmptyState({ message, icon = \"📋\" }: { message: string; icon?: string }) {\n  return (\n    <div class=\"text-center py-12 text-slate-400\">\n      <div class=\"text-4xl mb-3\">{icon}</div>\n      <p class=\"text-sm\">{message}</p>\n    </div>\n  );\n}\n\n// ─── Search Bar ───\nexport function SearchBar({ value, onChange, placeholder = \"Search...\" }: any) {\n  return (\n    <div class=\"relative\">\n      <input type=\"text\" value={value} onChange={onChange} placeholder={placeholder}\n        class=\"w-full pl-9 pr-3 py-2 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500\" />\n      <svg class=\"absolute left-3 top-2.5 w-4 h-4 text-slate-400\" fill=\"none\" stroke=\"currentColor\" viewBox=\"0 0 24 24\">\n        <path stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2\" d=\"M21 21l-4.35-4.35M17 11a6 6 0 11-12 0 6 6 0 0112 0z\" />\n      </svg>\n    </div>\n  );\n}\n\n// ─── Toast ───\nexport function useToast() {\n  const [toast, setToast] = useState<{ msg: string; type: string } | null>(null);\n  const showToast = (msg: string, type: string = \"info\") => {\n    setToast({ msg, type });\n    setTimeout(() => setToast(null), 3000);\n  };\n  const toastEl = toast && (\n    <div class=\"fixed bottom-4 right-4 z-50 px-4 py-3 rounded-lg shadow-lg text-sm font-medium text-white\"\n      style={{ background: toast.type === \"error\" ? \"#dc2626\" : toast.type === \"success\" ? \"#16a34a\" : \"#2563eb\" }}>\n      {toast.msg}\n    </div>\n  );\n  return { showToast, toastEl };\n}\n\n// ─── Date Input ───\nexport function DateInput({ label, value, onChange, className = \"\" }: any) {\n  return (\n    <div class={className}>\n      {label && <label class=\"block text-sm font-medium text-slate-600 mb-1\">{label}</label>}\n      <input type=\"date\" value={value} onChange={onChange}\n        class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500\" />\n    </div>\n  );\n}\n",[329,226,119],"d4b8b2f9-0599-424f-acf3-71e5a28ff13b",["D",1784059391558],"// API Client - handles all HTTP requests with auth\nconst BASE = \"\";\n\nfunction getToken(): string | null {\n  return localStorage.getItem(\"beml_token\");\n}\n\nexport function setToken(token: string) {\n  localStorage.setItem(\"beml_token\", token);\n}\n\nexport function clearToken() {\n  localStorage.removeItem(\"beml_token\");\n}\n\nexport function getStoredUser(): any | null {\n  const u = localStorage.getItem(\"beml_user\");\n  return u ? JSON.parse(u) : null;\n}\n\nexport function setStoredUser(user: any) {\n  localStorage.setItem(\"beml_user\", JSON.stringify(user));\n}\n\nexport function clearStoredUser() {\n  localStorage.removeItem(\"beml_user\");\n}\n\nasync function apiFetch(path: string, options: RequestInit = {}): Promise<any> {\n  const token = getToken();\n  const headers: Record<string, string> = {\n    \"Content-Type\": \"application/json\",\n    ...(options.headers as Record<string, string> || {}),\n  };\n  if (token) headers[\"Authorization\"] = `Bearer ${token}`;\n  const res = await fetch(path, { ...options, headers });\n  if (res.status === 401) {\n    clearToken();\n    clearStoredUser();\n    window.location.hash = \"#/login\";\n    throw new Error(\"Session expired\");\n  }\n  const data = await res.json();\n  if (!res.ok) throw new Error(data.error || \"Request failed\");\n  return data;\n}\n\n// Auth API\nexport const auth = {\n  login: (email: string, password: string) =>\n    apiFetch(\"/api/auth/login\", { method: \"POST\", body: JSON.stringify({ email, password }) }),\n  logout: () => apiFetch(\"/api/auth/logout\", { method: \"POST\" }),\n  me: () => apiFetch(\"/api/auth/me\"),\n};\n\n// Dashboard API\nexport const dashboard = {\n  get: () => apiFetch(\"/api/dashboard\"),\n};\n\n// Inventory API\nexport const inventory = {\n  list: (filters: Record<string, string> = {}) => {\n    const q = new URLSearchParams(filters).toString();\n    return apiFetch(`/api/inventory?${q}`);\n  },\n  stats: () => apiFetch(\"/api/inventory/stats\"),\n  sync: () => apiFetch(\"/api/inventory/sync\", { method: \"POST\" }),\n  export: () => `${BASE}/api/inventory/export?token=${getToken()}`,\n  sheetTabs: () => apiFetch(\"/api/inventory/sheets/tabs\"),\n};\n\n// Requests API\nexport const requests = {\n  list: (filters: Record<string, string> = {}) => {\n    const q = new URLSearchParams(filters).toString();\n    return apiFetch(`/api/requests?${q}`);\n  },\n  create: (data: any) => apiFetch(\"/api/requests\", { method: \"POST\", body: JSON.stringify(data) }),\n  update: (id: number, data: any) => apiFetch(`/api/requests/${id}`, { method: \"PATCH\", body: JSON.stringify(data) }),\n  export: () => `/api/requests/export`,\n};\n\n// Issues API\nexport const issues = {\n  list: (filters: Record<string, string> = {}) => {\n    const q = new URLSearchParams(filters).toString();\n    return apiFetch(`/api/issues?${q}`);\n  },\n  create: (data: any) => apiFetch(\"/api/issues\", { method: \"POST\", body: JSON.stringify(data) }),\n  export: () => `/api/issues/export`,\n  print: (id: number) => `/api/issues/${id}/print`,\n};\n\n// Gate Pass API\nexport const gatepass = {\n  list: (filters: Record<string, string> = {}) => {\n    const q = new URLSearchParams(filters).toString();\n    return apiFetch(`/api/gatepass?${q}`);\n  },\n  create: (data: any) => apiFetch(\"/api/gatepass\", { method: \"POST\", body: JSON.stringify(data) }),\n  export: () => `/api/gatepass/export`,\n  print: (id: number) => `/api/gatepass/${id}/print`,\n};\n\n// Repairs API\nexport const repairs = {\n  list: (filters: Record<string, string> = {}) => {\n    const q = new URLSearchParams(filters).toString();\n    return apiFetch(`/api/repairs?${q}`);\n  },\n  create: (data: any) => apiFetch(\"/api/repairs\", { method: \"POST\", body: JSON.stringify(data) }),\n  update: (id: number, data: any) => apiFetch(`/api/repairs/${id}`, { method: \"PATCH\", body: JSON.stringify(data) }),\n};\n\n// Settings API\nexport const settings = {\n  get: () => apiFetch(\"/api/settings\"),\n  update: (data: any) => apiFetch(\"/api/settings\", { method: \"POST\", body: JSON.stringify(data) }),\n  testConnection: () => apiFetch(\"/api/settings/test-connection\", { method: \"POST\" }),\n};\n\n// Users API\nexport const users = {\n  list: () => apiFetch(\"/api/users\"),\n  create: (data: any) => apiFetch(\"/api/users\", { method: \"POST\", body: JSON.stringify(data) }),\n  update: (id: number, data: any) => apiFetch(`/api/users/${id}`, { method: \"PATCH\", body: JSON.stringify(data) }),\n  delete: (id: number) => apiFetch(`/api/users/${id}`, { method: \"DELETE\" }),\n};\n\n// Audit API\nexport const audit = {\n  list: (filters: Record<string, string> = {}) => {\n    const q = new URLSearchParams(filters).toString();\n    return apiFetch(`/api/audit?${q}`);\n  },\n};\n\n// Sheets Info API\nexport const sheetsInfo = {\n  get: () => apiFetch(\"/api/sheets/info\"),\n};\n\n// Download CSV export helper\nexport function downloadCSV(url: string, filename: string) {\n  const token = getToken();\n  fetch(url, { headers: { Authorization: `Bearer ${token}` } })\n    .then(r => r.text())\n    .then(text => {\n      const blob = new Blob([text], { type: \"text/csv\" });\n      const a = document.createElement(\"a\");\n      a.href = URL.createObjectURL(blob);\n      a.download = filename;\n      a.click();\n      URL.revokeObjectURL(a.href);\n    });\n}\n\n// Open print page helper\nexport function openPrintPage(url: string) {\n  const token = getToken();\n  fetch(url, { headers: { Authorization: `Bearer ${token}` } })\n    .then(r => r.text())\n    .then(html => {\n      const w = window.open(\"\", \"_blank\");\n      if (w) {\n        w.document.write(html);\n        w.document.close();\n      }\n    });\n}\n",[329,226,110],"ddaad00a-482b-4e68-9bd6-ba8906bf382f",["D",1784059861343],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { users } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, Button, Modal, Input, Select, useToast } from \"./ui.tsx\";\n\nexport function UsersPage({ user }: { user: any }) {\n  const [items, setItems] = useState<any[]>([]);\n  const [loading, setLoading] = useState(true);\n  const [showModal, setShowModal] = useState(false);\n  const [editUser, setEditUser] = useState<any>(null);\n  const [form, setForm] = useState({ name: \"\", email: \"\", password: \"\", role: \"officer\", department: \"\", mobile: \"\" });\n  const { showToast, toastEl } = useToast();\n\n  const load = () => {\n    setLoading(true);\n    users.list().then(data => setItems(data.users || [])).catch(e => showToast(e.message, \"error\")).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { load(); }, []);\n\n  const handleCreate = () => {\n    if (!form.name || !form.email || !form.password) { showToast(\"Name, email and password required\", \"error\"); return; }\n    users.create(form).then(() => { setShowModal(false); showToast(\"User created successfully\", \"success\"); setForm({ name: \"\", email: \"\", password: \"\", role: \"officer\", department: \"\", mobile: \"\" }); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  const handleUpdate = () => {\n    if (!editUser) return;\n    const data: any = { name: editUser.name, email: editUser.email, role: editUser.role, department: editUser.department, mobile: editUser.mobile, status: editUser.status };\n    if (editUser.password) data.password = editUser.password;\n    users.update(editUser.id, data).then(() => { setEditUser(null); showToast(\"User updated successfully\", \"success\"); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  const handleDelete = (id: number, name: string) => {\n    if (confirm(`Are you sure you want to delete user \"${name}\"?`)) {\n      users.delete(id).then(() => { showToast(\"User deleted\", \"info\"); load(); }).catch(e => showToast(e.message, \"error\"));\n    }\n  };\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n      <div class=\"flex items-center justify-between\">\n        <h3 class=\"text-lg font-semibold text-slate-800\">User Management</h3>\n        <Button size=\"sm\" onClick={() => { setForm({ name: \"\", email: \"\", password: \"\", role: \"officer\", department: \"\", mobile: \"\" }); setShowModal(true); }}>➕ Add User</Button>\n      </div>\n\n      <Card class=\"p-0\">\n        {loading ? <Loading /> : items.length === 0 ? <EmptyState message=\"No users found\" icon=\"👥\" /> : (\n          <Table headers={[\"Name\", \"Email\", \"Role\", \"Department\", \"Mobile\", \"Status\", \"Created\", \"Actions\"]}>\n            {items.map((u: any) => (\n              <Tr key={u.id}>\n                <Td class=\"font-medium\">{u.name}</Td>\n                <Td class=\"text-xs\">{u.email}</Td>\n                <Td><span class=\"capitalize\">{u.role}</span></Td>\n                <Td>{u.department || \"-\"}</Td>\n                <Td class=\"text-xs\">{u.mobile || \"-\"}</Td>\n                <Td><Badge status={u.status} /></Td>\n                <Td class=\"text-xs\">{new Date(u.created_at).toLocaleDateString(\"en-IN\")}</Td>\n                <Td>\n                  <div class=\"flex gap-2\">\n                    <button onClick={() => setEditUser({ ...u, password: \"\" })} class=\"text-blue-600 text-xs font-medium hover:text-blue-700\">Edit</button>\n                    {u.id !== user.id && <button onClick={() => handleDelete(u.id, u.name)} class=\"text-red-600 text-xs font-medium hover:text-red-700\">Delete</button>}\n                  </div>\n                </Td>\n              </Tr>\n            ))}\n          </Table>\n        )}\n      </Card>\n\n      {/* Create User Modal */}\n      <Modal open={showModal} onClose={() => setShowModal(false)} title=\"Add New User\" size=\"md\">\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <Input label=\"Full Name\" value={form.name} onChange={(e: any) => setForm({ ...form, name: e.target.value })} required />\n          <Input label=\"Email\" type=\"email\" value={form.email} onChange={(e: any) => setForm({ ...form, email: e.target.value })} required />\n          <Input label=\"Password\" type=\"password\" value={form.password} onChange={(e: any) => setForm({ ...form, password: e.target.value })} required />\n          <div>\n            <label class=\"block text-sm font-medium text-slate-600 mb-1\">Role</label>\n            <select value={form.role} onChange={(e: any) => setForm({ ...form, role: e.target.value })} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n              <option value=\"admin\">Admin</option>\n              <option value=\"store\">Store Person</option>\n              <option value=\"officer\">Officer</option>\n              <option value=\"viewer\">Viewer</option>\n            </select>\n          </div>\n          <Input label=\"Department\" value={form.department} onChange={(e: any) => setForm({ ...form, department: e.target.value })} />\n          <Input label=\"Mobile\" value={form.mobile} onChange={(e: any) => setForm({ ...form, mobile: e.target.value })} />\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setShowModal(false)}>Cancel</Button>\n          <Button onClick={handleCreate}>Create User</Button>\n        </div>\n      </Modal>\n\n      {/* Edit User Modal */}\n      <Modal open={!!editUser} onClose={() => setEditUser(null)} title=\"Edit User\" size=\"md\">\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <Input label=\"Full Name\" value={editUser?.name || \"\"} onChange={(e: any) => setEditUser({ ...editUser, name: e.target.value })} />\n          <Input label=\"Email\" type=\"email\" value={editUser?.email || \"\"} onChange={(e: any) => setEditUser({ ...editUser, email: e.target.value })} />\n          <Input label=\"New Password (leave blank to keep)\" type=\"password\" value={editUser?.password || \"\"} onChange={(e: any) => setEditUser({ ...editUser, password: e.target.value })} />\n          <div>\n            <label class=\"block text-sm font-medium text-slate-600 mb-1\">Role</label>\n            <select value={editUser?.role || \"\"} onChange={(e: any) => setEditUser({ ...editUser, role: e.target.value })} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n              <option value=\"admin\">Admin</option>\n              <option value=\"store\">Store Person</option>\n              <option value=\"officer\">Officer</option>\n              <option value=\"viewer\">Viewer</option>\n            </select>\n          </div>\n          <Input label=\"Department\" value={editUser?.department || \"\"} onChange={(e: any) => setEditUser({ ...editUser, department: e.target.value })} />\n          <Input label=\"Mobile\" value={editUser?.mobile || \"\"} onChange={(e: any) => setEditUser({ ...editUser, mobile: e.target.value })} />\n          <div>\n            <label class=\"block text-sm font-medium text-slate-600 mb-1\">Status</label>\n            <select value={editUser?.status || \"\"} onChange={(e: any) => setEditUser({ ...editUser, status: e.target.value })} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n              <option value=\"active\">Active</option>\n              <option value=\"inactive\">Inactive</option>\n            </select>\n          </div>\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setEditUser(null)}>Cancel</Button>\n          <Button onClick={handleUpdate}>Update User</Button>\n        </div>\n      </Modal>\n    </div>\n  );\n}\n",[329,226,207],"7b880d5b-38ba-4c71-b13d-46fc53f9081d",["D",1784059861347],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { settings, sheetsInfo, inventory } from \"./api.ts\";\nimport { Card, Button, Input, Loading, useToast } from \"./ui.tsx\";\n\nexport function SettingsPage({ user }: { user: any }) {\n  const [s, setS] = useState<any>(null);\n  const [sheetInfo, setSheetInfo] = useState<any>(null);\n  const [loading, setLoading] = useState(true);\n  const [testing, setTesting] = useState(false);\n  const [syncing, setSyncing] = useState(false);\n  const [testResult, setTestResult] = useState<any>(null);\n  const { showToast, toastEl } = useToast();\n\n  useEffect(() => {\n    settings.get().then(data => setS(data.settings)).catch(() => {});\n    sheetsInfo.get().then(data => setSheetInfo(data)).catch(() => {}).finally(() => setLoading(false));\n  }, []);\n\n  const handleSave = () => {\n    settings.update({\n      google_sheet_id: s.google_sheet_id,\n      google_drive_folder: s.google_drive_folder,\n      company_name: s.company_name,\n      company_division: s.company_division,\n      company_address: s.company_address,\n      sync_interval: s.sync_interval,\n    }).then(() => showToast(\"Settings saved successfully\", \"success\")).catch(e => showToast(e.message, \"error\"));\n  };\n\n  const handleTest = () => {\n    setTesting(true);\n    setTestResult(null);\n    settings.update({ google_sheet_id: s.google_sheet_id }).then(() => {\n      settings.testConnection().then(r => { setTestResult(r); showToast(r.message, r.success ? \"success\" : \"error\"); }).catch(e => { setTestResult({ success: false, message: e.message }); showToast(e.message, \"error\"); }).finally(() => setTesting(false));\n    }).catch(e => { showToast(e.message, \"error\"); setTesting(false); });\n  };\n\n  const handleSync = () => {\n    setSyncing(true);\n    inventory.sync().then(r => { showToast(r.message, r.success ? \"success\" : \"error\"); }).catch(e => showToast(e.message, \"error\")).finally(() => setSyncing(false));\n  };\n\n  if (loading) return <Loading />;\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n\n      {/* Google Sheets Configuration */}\n      <Card class=\"p-5\">\n        <h3 class=\"font-semibold text-slate-800 mb-4\">📊 Google Sheets Configuration</h3>\n        <div class=\"space-y-3\">\n          <Input label=\"Google Spreadsheet ID\" value={s?.google_sheet_id || \"\"} onChange={(e: any) => setS({ ...s, google_sheet_id: e.target.value })} placeholder=\"Enter the spreadsheet ID from Google Sheets URL\" />\n          <Input label=\"Google Drive Folder ID (for document storage)\" value={s?.google_drive_folder || \"\"} onChange={(e: any) => setS({ ...s, google_drive_folder: e.target.value })} placeholder=\"Enter Google Drive folder ID\" />\n          <div class=\"flex flex-wrap gap-2\">\n            <Button size=\"sm\" variant=\"outline\" onClick={handleTest} disabled={testing}>{testing ? \"Testing...\" : \"🔌 Test Connection\"}</Button>\n            <Button size=\"sm\" onClick={handleSync} disabled={syncing || !s?.google_sheet_id}>{syncing ? \"Syncing...\" : \"🔄 Sync Now\"}</Button>\n          </div>\n          {testResult && (\n            <div class={`text-sm px-3 py-2 rounded-lg ${testResult.success ? \"bg-green-50 text-green-700 border border-green-200\" : \"bg-red-50 text-red-700 border border-red-200\"}`}>\n              {testResult.message}\n              {testResult.tabs && testResult.tabs.length > 0 && (\n                <div class=\"mt-2\"><span class=\"font-medium\">Found sheets:</span> {testResult.tabs.join(\", \")}</div>\n              )}\n            </div>\n          )}\n          <div class=\"bg-amber-50 border border-amber-200 text-amber-700 text-xs px-3 py-2 rounded-lg\">\n            ⚠️ You must set the <code class=\"bg-amber-100 px-1 rounded\">google_service_account</code> environment variable with your Google Cloud service account JSON key.\n          </div>\n        </div>\n      </Card>\n\n      {/* Expected Sheet Structure */}\n      {sheetInfo && (\n        <Card class=\"p-5\">\n          <h3 class=\"font-semibold text-slate-800 mb-4\">📋 Expected Google Sheet Structure</h3>\n          <p class=\"text-sm text-slate-500 mb-3\">Your spreadsheet should contain sheets with these exact names and columns:</p>\n          <div class=\"space-y-3\">\n            {Object.entries(sheetInfo.sheetNames || {}).map(([key, name]: any) => (\n              <div key={key} class=\"border border-slate-200 rounded-lg p-3\">\n                <p class=\"font-medium text-sm text-slate-700\">📄 Sheet: \"{name}\"</p>\n                {key === \"INVENTORY\" && (\n                  <div class=\"mt-2 flex flex-wrap gap-1\">\n                    {sheetInfo.inventoryColumns?.map((c: string) => <span class=\"text-xs bg-blue-50 text-blue-600 px-2 py-1 rounded\">{c}</span>)}\n                  </div>\n                )}\n                {key === \"VENDORS\" && (\n                  <div class=\"mt-2 flex flex-wrap gap-1\">\n                    {sheetInfo.vendorColumns?.map((c: string) => <span class=\"text-xs bg-purple-50 text-purple-600 px-2 py-1 rounded\">{c}</span>)}\n                  </div>\n                )}\n                {key === \"TRAINSETS\" && (\n                  <div class=\"mt-2 flex flex-wrap gap-1\">\n                    {sheetInfo.trainsetColumns?.map((c: string) => <span class=\"text-xs bg-green-50 text-green-600 px-2 py-1 rounded\">{c}</span>)}\n                  </div>\n                )}\n                {key === \"REQUESTS\" && <p class=\"text-xs text-slate-400 mt-1\">System-managed sheet for request records</p>}\n                {key === \"ISSUES\" && <p class=\"text-xs text-slate-400 mt-1\">System-managed sheet for issue records</p>}\n                {key === \"GATEPASSES\" && <p class=\"text-xs text-slate-400 mt-1\">System-managed sheet for gate pass records</p>}\n                {key === \"REPAIRS\" && <p class=\"text-xs text-slate-400 mt-1\">System-managed sheet for repair records</p>}\n              </div>\n            ))}\n          </div>\n        </Card>\n      )}\n\n      {/* Company Details */}\n      <Card class=\"p-5\">\n        <h3 class=\"font-semibold text-slate-800 mb-4\">🏢 Company Details (for BEML Letterhead)</h3>\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <Input label=\"Company Name\" value={s?.company_name || \"\"} onChange={(e: any) => setS({ ...s, company_name: e.target.value })} />\n          <Input label=\"Division\" value={s?.company_division || \"\"} onChange={(e: any) => setS({ ...s, company_division: e.target.value })} />\n          <Input label=\"Company Address\" value={s?.company_address || \"\"} onChange={(e: any) => setS({ ...s, company_address: e.target.value })} className=\"md:col-span-2\" />\n          <Input label=\"Sync Interval (minutes)\" type=\"number\" value={s?.sync_interval || \"5\"} onChange={(e: any) => setS({ ...s, sync_interval: e.target.value })} />\n        </div>\n      </Card>\n\n      <div class=\"flex justify-end\">\n        <Button onClick={handleSave}>💾 Save All Settings</Button>\n      </div>\n    </div>\n  );\n}\n",[329,226,216],"0cbb235c-cc05-4ba2-b54a-d53aa195f705",["D",1784059689111],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { requests, downloadCSV } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, SearchBar, Select, Button, Modal, Input, Textarea, DateInput, useToast } from \"./ui.tsx\";\n\nexport function RequestsPage({ user }: { user: any }) {\n  const [items, setItems] = useState<any[]>([]);\n  const [loading, setLoading] = useState(true);\n  const [search, setSearch] = useState(\"\");\n  const [statusFilter, setStatusFilter] = useState(\"\");\n  const [trainsetFilter, setTrainsetFilter] = useState(\"\");\n  const [dateFrom, setDateFrom] = useState(\"\");\n  const [dateTo, setDateTo] = useState(\"\");\n  const [showModal, setShowModal] = useState(false);\n  const [rejectModal, setRejectModal] = useState<any>(null);\n  const [form, setForm] = useState({ material_name: \"\", part_number: \"\", qty: 1, trainset: \"\", car: \"\", ncr: \"\", jobcard: \"\", reason: \"\", priority: \"normal\", maintenance_type: \"\", location: \"\", engineer_name: \"\" });\n  const { showToast, toastEl } = useToast();\n  const canApprove = user.role === \"admin\" || user.role === \"store\";\n\n  const load = () => {\n    setLoading(true);\n    const filters: Record<string, string> = {};\n    if (search) filters.search = search;\n    if (statusFilter) filters.status = statusFilter;\n    if (trainsetFilter) filters.trainset = trainsetFilter;\n    if (dateFrom) filters.dateFrom = dateFrom;\n    if (dateTo) filters.dateTo = dateTo;\n    requests.list(filters).then(data => setItems(data.items || [])).catch(() => {}).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { const t = setTimeout(load, 300); return () => clearTimeout(t); }, [search, statusFilter, trainsetFilter, dateFrom, dateTo]);\n\n  const handleSubmit = () => {\n    if (!form.material_name) { showToast(\"Material name is required\", \"error\"); return; }\n    requests.create(form).then(() => { setShowModal(false); showToast(\"Request created successfully\", \"success\"); setForm({ material_name: \"\", part_number: \"\", qty: 1, trainset: \"\", car: \"\", ncr: \"\", jobcard: \"\", reason: \"\", priority: \"normal\", maintenance_type: \"\", location: \"\", engineer_name: \"\" }); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  const handleApprove = (id: number) => { requests.update(id, { status: \"approved\" }).then(() => { showToast(\"Request approved\", \"success\"); load(); }).catch(e => showToast(e.message, \"error\")); };\n  const handleReject = () => { if (rejectModal) { requests.update(rejectModal.id, { status: \"rejected\", rejected_reason: rejectModal.reason || \"\" }).then(() => { showToast(\"Request rejected\", \"info\"); setRejectModal(null); load(); }).catch(e => showToast(e.message, \"error\")); } };\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n      <div class=\"flex flex-wrap items-center justify-between gap-3\">\n        <h3 class=\"text-lg font-semibold text-slate-800\">Material Requests</h3>\n        <div class=\"flex gap-2\">\n          <Button size=\"sm\" variant=\"outline\" onClick={() => downloadCSV(\"/api/requests/export\", \"requests_export.csv\")}>📥 Export</Button>\n          <Button size=\"sm\" onClick={() => setShowModal(true)}>➕ New Request</Button>\n        </div>\n      </div>\n\n      <Card class=\"p-4\">\n        <div class=\"grid grid-cols-1 md:grid-cols-3 lg:grid-cols-5 gap-3\">\n          <SearchBar value={search} onChange={(e: any) => setSearch(e.target.value)} placeholder=\"Search request no, material...\" />\n          <Select label=\"\" value={statusFilter} onChange={(e: any) => setStatusFilter(e.target.value)} options={[\"pending\", \"approved\", \"rejected\", \"issued\"]} />\n          <input type=\"text\" value={trainsetFilter} onChange={(e: any) => setTrainsetFilter(e.target.value)} placeholder=\"Trainset No\" class=\"px-3 py-2 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500\" />\n          <DateInput label=\"\" value={dateFrom} onChange={(e: any) => setDateFrom(e.target.value)} />\n          <DateInput label=\"\" value={dateTo} onChange={(e: any) => setDateTo(e.target.value)} />\n        </div>\n      </Card>\n\n      <Card class=\"p-0\">\n        {loading ? <Loading /> : items.length === 0 ? <EmptyState message=\"No material requests found\" icon=\"📝\" /> : (\n          <Table headers={[\"Request No\", \"Officer\", \"Material\", \"Part No\", \"Qty\", \"Trainset\", \"Car\", \"NCR\", \"Job Card\", \"Status\", \"Date\", \"Actions\"]}>\n            {items.map((r: any) => (\n              <Tr key={r.id}>\n                <Td class=\"font-mono text-xs\">{r.request_no}</Td>\n                <Td>{r.officer_name}</Td>\n                <Td class=\"font-medium\">{r.material_name}</Td>\n                <Td class=\"font-mono text-xs\">{r.part_number}</Td>\n                <Td>{r.qty}</Td>\n                <Td>{r.trainset || \"-\"}</Td>\n                <Td>{r.car || \"-\"}</Td>\n                <Td class=\"text-xs\">{r.ncr || \"-\"}</Td>\n                <Td class=\"text-xs\">{r.jobcard || \"-\"}</Td>\n                <Td><Badge status={r.status} /></Td>\n                <Td class=\"text-xs\">{new Date(r.created_at).toLocaleDateString(\"en-IN\")}</Td>\n                <Td>\n                  {canApprove && r.status === \"pending\" && (\n                    <div class=\"flex gap-1\">\n                      <button onClick={() => handleApprove(r.id)} class=\"text-green-600 hover:text-green-700 text-xs font-medium\">Approve</button>\n                      <span class=\"text-slate-300\">|</span>\n                      <button onClick={() => setRejectModal({ id: r.id, reason: \"\" })} class=\"text-red-600 hover:text-red-700 text-xs font-medium\">Reject</button>\n                    </div>\n                  )}\n                  {r.status === \"rejected\" && r.rejected_reason && <span class=\"text-xs text-red-500\" title={r.rejected_reason}>Rejected</span>}\n                </Td>\n              </Tr>\n            ))}\n          </Table>\n        )}\n      </Card>\n\n      {/* New Request Modal */}\n      <Modal open={showModal} onClose={() => setShowModal(false)} title=\"New Material Request\" size=\"lg\">\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <Input label=\"Material Name\" value={form.material_name} onChange={(e: any) => setForm({ ...form, material_name: e.target.value })} required />\n          <Input label=\"Part Number\" value={form.part_number} onChange={(e: any) => setForm({ ...form, part_number: e.target.value })} />\n          <Input label=\"Quantity\" type=\"number\" value={form.qty} onChange={(e: any) => setForm({ ...form, qty: parseInt(e.target.value) || 1 })} />\n          <Input label=\"Trainset Number\" value={form.trainset} onChange={(e: any) => setForm({ ...form, trainset: e.target.value })} />\n          <Input label=\"Car Number\" value={form.car} onChange={(e: any) => setForm({ ...form, car: e.target.value })} />\n          <Input label=\"NCR Number\" value={form.ncr} onChange={(e: any) => setForm({ ...form, ncr: e.target.value })} />\n          <Input label=\"Job Card Number\" value={form.jobcard} onChange={(e: any) => setForm({ ...form, jobcard: e.target.value })} />\n          <Input label=\"Priority\" value={form.priority} onChange={(e: any) => setForm({ ...form, priority: e.target.value })} />\n          <Input label=\"Maintenance Type\" value={form.maintenance_type} onChange={(e: any) => setForm({ ...form, maintenance_type: e.target.value })} />\n          <Input label=\"Engineer Name\" value={form.engineer_name} onChange={(e: any) => setForm({ ...form, engineer_name: e.target.value })} />\n          <Input label=\"Location\" value={form.location} onChange={(e: any) => setForm({ ...form, location: e.target.value })} className=\"md:col-span-2\" />\n          <Textarea label=\"Reason\" value={form.reason} onChange={(e: any) => setForm({ ...form, reason: e.target.value })} className=\"md:col-span-2\" />\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setShowModal(false)}>Cancel</Button>\n          <Button onClick={handleSubmit}>Submit Request</Button>\n        </div>\n      </Modal>\n\n      {/* Reject Modal */}\n      <Modal open={!!rejectModal} onClose={() => setRejectModal(null)} title=\"Reject Request\" size=\"sm\">\n        <Textarea label=\"Reason for rejection\" value={rejectModal?.reason || \"\"} onChange={(e: any) => setRejectModal({ ...rejectModal, reason: e.target.value })} rows={3} />\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setRejectModal(null)}>Cancel</Button>\n          <Button variant=\"danger\" onClick={handleReject}>Reject</Button>\n        </div>\n      </Modal>\n    </div>\n  );\n}\n",[329,226,162],"9578e047-4081-4e9b-b535-da92b4ebd1aa",["D",1784059823435],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { audit, downloadCSV } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, SearchBar, Select, Button, DateInput } from \"./ui.tsx\";\n\nexport function ReportsPage({ user }: { user: any }) {\n  const [tab, setTab] = useState(\"exports\");\n  const [logs, setLogs] = useState<any[]>([]);\n  const [loading, setLoading] = useState(false);\n  const [logSearch, setLogSearch] = useState(\"\");\n  const [logModule, setLogModule] = useState(\"\");\n  const isAdmin = user.role === \"admin\";\n\n  const loadLogs = () => {\n    setLoading(true);\n    const filters: Record<string, string> = {};\n    if (logSearch) filters.user = logSearch;\n    if (logModule) filters.module = logModule;\n    audit.list(filters).then(data => setLogs(data.logs || [])).catch(() => {}).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { if (tab === \"audit\" && isAdmin) loadLogs(); }, [tab, logSearch, logModule]);\n\n  return (\n    <div class=\"space-y-4\">\n      {/* Tabs */}\n      <div class=\"flex gap-2 border-b border-slate-200\">\n        <button onClick={() => setTab(\"exports\")} class={`px-4 py-2 text-sm font-medium ${tab === \"exports\" ? \"text-blue-600 border-b-2 border-blue-600\" : \"text-slate-500\"}`}>Export Reports</button>\n        {isAdmin && <button onClick={() => setTab(\"audit\")} class={`px-4 py-2 text-sm font-medium ${tab === \"audit\" ? \"text-blue-600 border-b-2 border-blue-600\" : \"text-slate-500\"}`}>Audit Log</button>}\n      </div>\n\n      {tab === \"exports\" && (\n        <div class=\"space-y-4\">\n          <p class=\"text-sm text-slate-500\">Export data from any module in CSV format (opens in Excel).</p>\n          <div class=\"grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-4\">\n            <Card class=\"p-5 text-center\">\n              <div class=\"text-3xl mb-2\">📦</div>\n              <h4 class=\"font-semibold text-slate-700\">Inventory Report</h4>\n              <p class=\"text-xs text-slate-500 mt-1\">Complete DLP inventory with quantities and status</p>\n              <Button size=\"sm\" variant=\"outline\" className=\"mt-3 w-full\" onClick={() => downloadCSV(\"/api/inventory/export\", \"inventory_export.csv\")}>📥 Export CSV</Button>\n            </Card>\n            <Card class=\"p-5 text-center\">\n              <div class=\"text-3xl mb-2\">📝</div>\n              <h4 class=\"font-semibold text-slate-700\">Material Requests</h4>\n              <p class=\"text-xs text-slate-500 mt-1\">All material requests with status and details</p>\n              <Button size=\"sm\" variant=\"outline\" className=\"mt-3 w-full\" onClick={() => downloadCSV(\"/api/requests/export\", \"requests_export.csv\")}>📥 Export CSV</Button>\n            </Card>\n            <Card class=\"p-5 text-center\">\n              <div class=\"text-3xl mb-2\">📤</div>\n              <h4 class=\"font-semibold text-slate-700\">Material Issues</h4>\n              <p class=\"text-xs text-slate-500 mt-1\">Issued materials with trainset and NCR details</p>\n              <Button size=\"sm\" variant=\"outline\" className=\"mt-3 w-full\" onClick={() => downloadCSV(\"/api/issues/export\", \"issues_export.csv\")}>📥 Export CSV</Button>\n            </Card>\n            <Card class=\"p-5 text-center\">\n              <div class=\"text-3xl mb-2\">🚪</div>\n              <h4 class=\"font-semibold text-slate-700\">Gate Pass Report</h4>\n              <p class=\"text-xs text-slate-500 mt-1\">All gate passes with vendor and return status</p>\n              <Button size=\"sm\" variant=\"outline\" className=\"mt-3 w-full\" onClick={() => downloadCSV(\"/api/gatepass/export\", \"gatepass_export.csv\")}>📥 Export CSV</Button>\n            </Card>\n          </div>\n        </div>\n      )}\n\n      {tab === \"audit\" && isAdmin && (\n        <div class=\"space-y-4\">\n          <Card class=\"p-4\">\n            <div class=\"grid grid-cols-1 md:grid-cols-3 gap-3\">\n              <SearchBar value={logSearch} onChange={(e: any) => setLogSearch(e.target.value)} placeholder=\"Search by user...\" />\n              <Select label=\"\" value={logModule} onChange={(e: any) => setLogModule(e.target.value)} options={[\"auth\", \"inventory\", \"requests\", \"issues\", \"gatepass\", \"repairs\", \"settings\", \"users\"]} />\n            </div>\n          </Card>\n          <Card class=\"p-0\">\n            {loading ? <Loading /> : logs.length === 0 ? <EmptyState message=\"No audit logs found\" icon=\"📜\" /> : (\n              <Table headers={[\"User\", \"Action\", \"Module\", \"New Value\", \"Date\", \"IP\"]}>\n                {logs.map((l: any) => (\n                  <Tr key={l.id}>\n                    <Td class=\"font-medium\">{l.user_name}</Td>\n                    <Td><span class=\"font-mono text-xs bg-slate-100 px-2 py-0.5 rounded\">{l.action}</span></Td>\n                    <Td>{l.module}</Td>\n                    <Td class=\"text-xs max-w-xs truncate\">{l.new_value || \"-\"}</Td>\n                    <Td class=\"text-xs\">{new Date(l.date).toLocaleString(\"en-IN\")}</Td>\n                    <Td class=\"text-xs\">{l.ip || \"-\"}</Td>\n                  </Tr>\n                ))}\n              </Table>\n            )}\n          </Card>\n        </div>\n      )}\n    </div>\n  );\n}\n",[329,226,189],"7210a34b-63ad-4909-9d94-45e1d94678a4",["D",1784059823488],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { repairs } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, SearchBar, Select, Button, Modal, Input, Textarea, DateInput, useToast } from \"./ui.tsx\";\n\nexport function RepairsPage({ user }: { user: any }) {\n  const [items, setItems] = useState<any[]>([]);\n  const [loading, setLoading] = useState(true);\n  const [search, setSearch] = useState(\"\");\n  const [statusFilter, setStatusFilter] = useState(\"\");\n  const [showModal, setShowModal] = useState(false);\n  const [editModal, setEditModal] = useState<any>(null);\n  const [form, setForm] = useState({ part_number: \"\", material_name: \"\", vendor: \"\", expected_date: \"\", remarks: \"\" });\n  const { showToast, toastEl } = useToast();\n  const canEdit = user.role === \"admin\" || user.role === \"store\";\n\n  const load = () => {\n    setLoading(true);\n    const filters: Record<string, string> = {};\n    if (search) filters.search = search;\n    if (statusFilter) filters.status = statusFilter;\n    repairs.list(filters).then(data => setItems(data.items || [])).catch(() => {}).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { const t = setTimeout(load, 300); return () => clearTimeout(t); }, [search, statusFilter]);\n\n  const handleCreate = () => {\n    if (!form.part_number && !form.material_name) { showToast(\"Part number or material name required\", \"error\"); return; }\n    repairs.create(form).then(() => { setShowModal(false); showToast(\"Repair record created\", \"success\"); setForm({ part_number: \"\", material_name: \"\", vendor: \"\", expected_date: \"\", remarks: \"\" }); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  const handleUpdate = () => {\n    if (!editModal) return;\n    repairs.update(editModal.id, { repair_status: editModal.repair_status, received_date: editModal.received_date, inspection_result: editModal.inspection_result, remarks: editModal.remarks }).then(() => { setEditModal(null); showToast(\"Repair updated successfully! Inventory adjusted if received & accepted.\", \"success\"); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n      <div class=\"flex flex-wrap items-center justify-between gap-3\">\n        <h3 class=\"text-lg font-semibold text-slate-800\">Repair Tracking</h3>\n        {canEdit && <Button size=\"sm\" onClick={() => setShowModal(true)}>➕ New Repair Record</Button>}\n      </div>\n\n      <Card class=\"p-4\">\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <SearchBar value={search} onChange={(e: any) => setSearch(e.target.value)} placeholder=\"Search part no, material, vendor...\" />\n          <Select label=\"\" value={statusFilter} onChange={(e: any) => setStatusFilter(e.target.value)} options={[\"sent\", \"received\"]} />\n        </div>\n      </Card>\n\n      <Card class=\"p-0\">\n        {loading ? <Loading /> : items.length === 0 ? <EmptyState message=\"No repair records found\" icon=\"🔧\" /> : (\n          <Table headers={[\"Part No\", \"Material\", \"Vendor\", \"Status\", \"Expected Date\", \"Received Date\", \"Inspection\", \"Remarks\", \"Actions\"]}>\n            {items.map((r: any) => (\n              <Tr key={r.id}>\n                <Td class=\"font-mono text-xs\">{r.part_number}</Td>\n                <Td>{r.material_name}</Td>\n                <Td>{r.vendor}</Td>\n                <Td><Badge status={r.repair_status} /></Td>\n                <Td class=\"text-xs\">{r.expected_date ? new Date(r.expected_date).toLocaleDateString(\"en-IN\") : \"-\"}</Td>\n                <Td class=\"text-xs\">{r.received_date ? new Date(r.received_date).toLocaleDateString(\"en-IN\") : \"-\"}</Td>\n                <Td>{r.inspection_result ? <Badge status={r.inspection_result === \"accepted\" ? \"approved\" : \"rejected\"} /> : \"-\"}</Td>\n                <Td class=\"text-xs max-w-xs truncate\">{r.remarks || \"-\"}</Td>\n                <Td>{canEdit && <button onClick={() => setEditModal({ id: r.id, repair_status: r.repair_status, received_date: r.received_date || \"\", inspection_result: r.inspection_result || \"\", remarks: r.remarks || \"\" })} class=\"text-blue-600 text-xs font-medium hover:text-blue-700\">Update</button>}</Td>\n              </Tr>\n            ))}\n          </Table>\n        )}\n      </Card>\n\n      {/* Create Modal */}\n      <Modal open={showModal} onClose={() => setShowModal(false)} title=\"New Repair Record\" size=\"md\">\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <Input label=\"Part Number\" value={form.part_number} onChange={(e: any) => setForm({ ...form, part_number: e.target.value })} />\n          <Input label=\"Material Name\" value={form.material_name} onChange={(e: any) => setForm({ ...form, material_name: e.target.value })} />\n          <Input label=\"Vendor\" value={form.vendor} onChange={(e: any) => setForm({ ...form, vendor: e.target.value })} />\n          <DateInput label=\"Expected Return Date\" value={form.expected_date} onChange={(e: any) => setForm({ ...form, expected_date: e.target.value })} />\n          <Textarea label=\"Remarks\" value={form.remarks} onChange={(e: any) => setForm({ ...form, remarks: e.target.value })} className=\"md:col-span-2\" />\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setShowModal(false)}>Cancel</Button>\n          <Button onClick={handleCreate}>Create</Button>\n        </div>\n      </Modal>\n\n      {/* Edit Modal */}\n      <Modal open={!!editModal} onClose={() => setEditModal(null)} title=\"Update Repair Status\" size=\"md\">\n        <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n          <div>\n            <label class=\"block text-sm font-medium text-slate-600 mb-1\">Repair Status</label>\n            <select value={editModal?.repair_status} onChange={(e: any) => setEditModal({ ...editModal, repair_status: e.target.value })} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n              <option value=\"sent\">Sent for Repair</option>\n              <option value=\"received\">Received from Repair</option>\n            </select>\n          </div>\n          <div>\n            <label class=\"block text-sm font-medium text-slate-600 mb-1\">Inspection Result</label>\n            <select value={editModal?.inspection_result} onChange={(e: any) => setEditModal({ ...editModal, inspection_result: e.target.value })} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n              <option value=\"\">Pending Inspection</option>\n              <option value=\"accepted\">Accepted (Return to Inventory)</option>\n              <option value=\"rejected\">Rejected (Send for Replacement)</option>\n            </select>\n          </div>\n          <DateInput label=\"Received Date\" value={editModal?.received_date} onChange={(e: any) => setEditModal({ ...editModal, received_date: e.target.value })} className=\"md:col-span-2\" />\n          <Textarea label=\"Remarks\" value={editModal?.remarks} onChange={(e: any) => setEditModal({ ...editModal, remarks: e.target.value })} className=\"md:col-span-2\" />\n        </div>\n        <div class=\"bg-blue-50 border border-blue-200 text-blue-700 text-xs px-3 py-2 rounded-lg mt-3\">\n          ℹ️ When status is \"Received\" and inspection is \"Accepted\", the item will be automatically added back to inventory.\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setEditModal(null)}>Cancel</Button>\n          <Button onClick={handleUpdate}>Update</Button>\n        </div>\n      </Modal>\n    </div>\n  );\n}\n",[329,226,198],"6e9d73a1-f0a9-417f-80f9-b219dd362568",["D",1784059467360],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { auth, setToken, setStoredUser } from \"./api.ts\";\nimport { Button, Input } from \"./ui.tsx\";\n\nexport function Login({ onLogin }: { onLogin: () => void }) {\n  const [email, setEmail] = useState(\"\");\n  const [password, setPassword] = useState(\"\");\n  const [error, setError] = useState(\"\");\n  const [loading, setLoading] = useState(false);\n  const [showPwd, setShowPwd] = useState(false);\n\n  const handleSubmit = async (e: any) => {\n    e.preventDefault();\n    setError(\"\");\n    setLoading(true);\n    try {\n      const result = await auth.login(email, password);\n      setToken(result.token);\n      setStoredUser(result.user);\n      onLogin();\n    } catch (err: any) {\n      setError(err.message || \"Login failed\");\n    } finally {\n      setLoading(false);\n    }\n  };\n\n  return (\n    <div class=\"min-h-screen flex items-center justify-center bg-gradient-to-br from-slate-900 via-blue-900 to-slate-800 p-4\">\n      <div class=\"absolute inset-0 overflow-hidden\">\n        <div class=\"absolute -top-40 -right-40 w-96 h-96 bg-blue-500/10 rounded-full blur-3xl\"></div>\n        <div class=\"absolute -bottom-40 -left-40 w-96 h-96 bg-indigo-500/10 rounded-full blur-3xl\"></div>\n      </div>\n\n      <div class=\"relative w-full max-w-md\">\n        <div class=\"bg-white rounded-2xl shadow-2xl overflow-hidden\">\n          {/* Header with BEML branding */}\n          <div class=\"bg-gradient-to-r from-blue-700 to-blue-900 p-8 text-center\">\n            <div class=\"inline-flex items-center justify-center w-16 h-16 bg-white/10 rounded-xl backdrop-blur-sm mb-4\">\n              <span class=\"text-white font-bold text-2xl\">BEML</span>\n            </div>\n            <h1 class=\"text-white text-xl font-bold\">BEML LIMITED</h1>\n            <p class=\"text-blue-200 text-sm mt-1\">KMRCL - Kolkata Metro Rail Corporation</p>\n            <div class=\"mt-4 pt-4 border-t border-white/20\">\n              <h2 class=\"text-white text-lg font-semibold\">DLP Store Inventory</h2>\n              <p class=\"text-blue-200 text-xs\">Management System</p>\n            </div>\n          </div>\n\n          {/* Login Form */}\n          <form onSubmit={handleSubmit} class=\"p-8 space-y-5\">\n            <div>\n              <label class=\"block text-sm font-medium text-slate-600 mb-1\">Email Address <span class=\"text-red-500\">*</span></label>\n              <input type=\"email\" value={email} onChange={e => setEmail(e.target.value)} required\n                placeholder=\"Enter your email\" autofocus\n                class=\"w-full px-4 py-3 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\" />\n            </div>\n\n            <div>\n              <label class=\"block text-sm font-medium text-slate-600 mb-1\">Password <span class=\"text-red-500\">*</span></label>\n              <div class=\"relative\">\n                <input type={showPwd ? \"text\" : \"password\"} value={password} onChange={e => setPassword(e.target.value)} required\n                  placeholder=\"Enter your password\"\n                  class=\"w-full px-4 py-3 pr-10 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\" />\n                <button type=\"button\" onClick={() => setShowPwd(!showPwd)}\n                  class=\"absolute right-3 top-3 text-slate-400 hover:text-slate-600\">\n                  {showPwd ? \"👁️\" : \"👁️‍🗨️\"}\n                </button>\n              </div>\n            </div>\n\n            {error && (\n              <div class=\"bg-red-50 border border-red-200 text-red-600 text-sm px-4 py-3 rounded-lg\">\n                {error}\n              </div>\n            )}\n\n            <Button type=\"submit\" disabled={loading} size=\"lg\" className=\"w-full\">\n              {loading ? \"Signing in...\" : \"Sign In\"}\n            </Button>\n\n            {/* Demo credentials */}\n            <div class=\"bg-slate-50 rounded-lg p-4 border border-slate-200\">\n              <p class=\"text-xs font-semibold text-slate-500 mb-2\">Demo Login Credentials:</p>\n              <div class=\"space-y-1 text-xs text-slate-500\">\n                <p>👤 Admin: <span class=\"font-mono text-blue-600\">admin@beml.in / admin123</span></p>\n                <p>🏪 Store: <span class=\"font-mono text-blue-600\">store@beml.in / store123</span></p>\n                <p>🔧 Officer: <span class=\"font-mono text-blue-600\">officer@beml.in / officer123</span></p>\n              </div>\n            </div>\n          </form>\n        </div>\n\n        <p class=\"text-center text-blue-200 text-xs mt-6\">\n          © {new Date().getFullYear()} BEML Limited. All rights reserved.\n        </p>\n      </div>\n    </div>\n  );\n}\n",[329,226,128],"040e97da-8c3f-4871-afc0-4b6e7ee7e1b9",["D",1784059771799],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { issues, requests, inventory, downloadCSV, openPrintPage } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, SearchBar, Select, Button, Modal, Input, Textarea, DateInput, useToast } from \"./ui.tsx\";\n\nexport function IssuesPage({ user }: { user: any }) {\n  const [items, setItems] = useState<any[]>([]);\n  const [loading, setLoading] = useState(true);\n  const [search, setSearch] = useState(\"\");\n  const [statusFilter, setStatusFilter] = useState(\"\");\n  const [trainsetFilter, setTrainsetFilter] = useState(\"\");\n  const [dateFrom, setDateFrom] = useState(\"\");\n  const [dateTo, setDateTo] = useState(\"\");\n  const [showModal, setShowModal] = useState(false);\n  const [approvedReqs, setApprovedReqs] = useState<any[]>([]);\n  const [invItems, setInvItems] = useState<any[]>([]);\n  const [form, setForm] = useState({ request_id: \"\", officer_name: \"\", material_name: \"\", part_number: \"\", healthy_part: \"\", faulty_part: \"\", qty: 1, trainset: \"\", car: \"\", ncr: \"\", jobcard: \"\", reason: \"\", inventory_item_id: \"\", issued_to: \"\" });\n  const { showToast, toastEl } = useToast();\n  const canIssue = user.role === \"admin\" || user.role === \"store\";\n\n  const load = () => {\n    setLoading(true);\n    const filters: Record<string, string> = {};\n    if (search) filters.search = search;\n    if (statusFilter) filters.status = statusFilter;\n    if (trainsetFilter) filters.trainset = trainsetFilter;\n    if (dateFrom) filters.dateFrom = dateFrom;\n    if (dateTo) filters.dateTo = dateTo;\n    issues.list(filters).then(data => setItems(data.items || [])).catch(() => {}).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { const t = setTimeout(load, 300); return () => clearTimeout(t); }, [search, statusFilter, trainsetFilter, dateFrom, dateTo]);\n\n  const openIssueModal = () => {\n    requests.list({ status: \"approved\" }).then(data => { setApprovedReqs(data.items || []); return inventory.list(); }).then(data => setInvItems(data.items || []));\n    setForm({ request_id: \"\", officer_name: \"\", material_name: \"\", part_number: \"\", healthy_part: \"\", faulty_part: \"\", qty: 1, trainset: \"\", car: \"\", ncr: \"\", jobcard: \"\", reason: \"\", inventory_item_id: \"\", issued_to: \"\" });\n    setShowModal(true);\n  };\n\n  const selectRequest = (reqId: string) => {\n    const req = approvedReqs.find(r => r.id == reqId);\n    if (req) setForm({ ...form, request_id: reqId, officer_name: req.officer_name, material_name: req.material_name, part_number: req.part_number, qty: req.qty, trainset: req.trainset, car: req.car, ncr: req.ncr, jobcard: req.jobcard, reason: req.reason });\n  };\n\n  const selectInventory = (invId: string) => {\n    const inv = invItems.find(i => i.id == invId);\n    if (inv) setForm({ ...form, inventory_item_id: invId, material_name: inv.material_name, part_number: inv.part_number });\n  };\n\n  const handleSubmit = () => {\n    if (!form.material_name) { showToast(\"Material name required\", \"error\"); return; }\n    issues.create(form).then(() => { setShowModal(false); showToast(\"Material issued successfully! Inventory updated.\", \"success\"); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n      <div class=\"flex flex-wrap items-center justify-between gap-3\">\n        <h3 class=\"text-lg font-semibold text-slate-800\">Material Issues</h3>\n        <div class=\"flex gap-2\">\n          <Button size=\"sm\" variant=\"outline\" onClick={() => downloadCSV(\"/api/issues/export\", \"issues_export.csv\")}>📥 Export</Button>\n          {canIssue && <Button size=\"sm\" onClick={openIssueModal}>➕ Issue Material</Button>}\n        </div>\n      </div>\n\n      <Card class=\"p-4\">\n        <div class=\"grid grid-cols-1 md:grid-cols-3 lg:grid-cols-5 gap-3\">\n          <SearchBar value={search} onChange={(e: any) => setSearch(e.target.value)} placeholder=\"Search issue no, material...\" />\n          <Select label=\"\" value={statusFilter} onChange={(e: any) => setStatusFilter(e.target.value)} options={[\"issued\", \"returned\", \"closed\"]} />\n          <input type=\"text\" value={trainsetFilter} onChange={(e: any) => setTrainsetFilter(e.target.value)} placeholder=\"Trainset No\" class=\"px-3 py-2 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500\" />\n          <DateInput label=\"\" value={dateFrom} onChange={(e: any) => setDateFrom(e.target.value)} />\n          <DateInput label=\"\" value={dateTo} onChange={(e: any) => setDateTo(e.target.value)} />\n        </div>\n      </Card>\n\n      <Card class=\"p-0\">\n        {loading ? <Loading /> : items.length === 0 ? <EmptyState message=\"No material issues found\" icon=\"📤\" /> : (\n          <Table headers={[\"Issue No\", \"Officer\", \"Material\", \"Part No\", \"Healthy\", \"Faulty\", \"Qty\", \"Trainset\", \"NCR\", \"Issued By\", \"Date\", \"Print\"]}>\n            {items.map((i: any) => (\n              <Tr key={i.id}>\n                <Td class=\"font-mono text-xs\">{i.issue_no}</Td>\n                <Td>{i.officer_name}</Td>\n                <Td class=\"font-medium\">{i.material_name}</Td>\n                <Td class=\"font-mono text-xs\">{i.part_number}</Td>\n                <Td class=\"text-xs\">{i.healthy_part || \"-\"}</Td>\n                <Td class=\"text-xs\">{i.faulty_part || \"-\"}</Td>\n                <Td>{i.qty}</Td>\n                <Td>{i.trainset || \"-\"}</Td>\n                <Td class=\"text-xs\">{i.ncr || \"-\"}</Td>\n                <Td class=\"text-xs\">{i.issued_by}</Td>\n                <Td class=\"text-xs\">{new Date(i.issue_date).toLocaleDateString(\"en-IN\")}</Td>\n                <Td><button onClick={() => openPrintPage(`/api/issues/${i.id}/print`)} class=\"text-blue-600 hover:text-blue-700 text-xs font-medium\">📄 Print</button></Td>\n              </Tr>\n            ))}\n          </Table>\n        )}\n      </Card>\n\n      <Modal open={showModal} onClose={() => setShowModal(false)} title=\"Issue Material\" size=\"lg\">\n        <div class=\"space-y-3\">\n          {approvedReqs.length > 0 && (\n            <div>\n              <label class=\"block text-sm font-medium text-slate-600 mb-1\">Select Approved Request (optional)</label>\n              <select value={form.request_id} onChange={(e: any) => selectRequest(e.target.value)} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n                <option value=\"\">-- Select Request --</option>\n                {approvedReqs.map((r: any) => <option value={r.id}>{r.request_no} - {r.material_name} ({r.officer_name})</option>)}\n              </select>\n            </div>\n          )}\n          {invItems.length > 0 && (\n            <div>\n              <label class=\"block text-sm font-medium text-slate-600 mb-1\">Select from Inventory (optional)</label>\n              <select value={form.inventory_item_id} onChange={(e: any) => selectInventory(e.target.value)} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n                <option value=\"\">-- Select Inventory Item --</option>\n                {invItems.filter((i: any) => i.available_qty > 0).map((i: any) => <option value={i.id}>{i.material_name} - {i.part_number} (Avail: {i.available_qty})</option>)}\n              </select>\n            </div>\n          )}\n          <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n            <Input label=\"Officer Name\" value={form.officer_name} onChange={(e: any) => setForm({ ...form, officer_name: e.target.value })} required />\n            <Input label=\"Material Name\" value={form.material_name} onChange={(e: any) => setForm({ ...form, material_name: e.target.value })} required />\n            <Input label=\"Part Number\" value={form.part_number} onChange={(e: any) => setForm({ ...form, part_number: e.target.value })} />\n            <Input label=\"Quantity\" type=\"number\" value={form.qty} onChange={(e: any) => setForm({ ...form, qty: parseInt(e.target.value) || 1 })} />\n            <Input label=\"Healthy Part Number\" value={form.healthy_part} onChange={(e: any) => setForm({ ...form, healthy_part: e.target.value })} />\n            <Input label=\"Faulty Part Number\" value={form.faulty_part} onChange={(e: any) => setForm({ ...form, faulty_part: e.target.value })} />\n            <Input label=\"Trainset Number\" value={form.trainset} onChange={(e: any) => setForm({ ...form, trainset: e.target.value })} />\n            <Input label=\"Car Number\" value={form.car} onChange={(e: any) => setForm({ ...form, car: e.target.value })} />\n            <Input label=\"NCR Number\" value={form.ncr} onChange={(e: any) => setForm({ ...form, ncr: e.target.value })} />\n            <Input label=\"Job Card Number\" value={form.jobcard} onChange={(e: any) => setForm({ ...form, jobcard: e.target.value })} />\n            <Input label=\"Issued To\" value={form.issued_to} onChange={(e: any) => setForm({ ...form, issued_to: e.target.value })} />\n            <Textarea label=\"Reason\" value={form.reason} onChange={(e: any) => setForm({ ...form, reason: e.target.value })} className=\"md:col-span-2\" />\n          </div>\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setShowModal(false)}>Cancel</Button>\n          <Button variant=\"success\" onClick={handleSubmit}>Issue Material</Button>\n        </div>\n      </Modal>\n    </div>\n  );\n}\n",[329,226,171],"931c0898-28d6-402a-9dcf-e83945899a37",["D",1784059689109],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { inventory, downloadCSV } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, SearchBar, Select, Button, useToast } from \"./ui.tsx\";\n\nexport function InventoryPage({ user }: { user: any }) {\n  const [items, setItems] = useState<any[]>([]);\n  const [loading, setLoading] = useState(true);\n  const [search, setSearch] = useState(\"\");\n  const [statusFilter, setStatusFilter] = useState(\"\");\n  const [oemFilter, setOemFilter] = useState(\"\");\n  const [trainsetFilter, setTrainsetFilter] = useState(\"\");\n  const [syncing, setSyncing] = useState(false);\n  const { showToast, toastEl } = useToast();\n  const canSync = user.role === \"admin\" || user.role === \"store\";\n\n  const loadItems = () => {\n    setLoading(true);\n    const filters: Record<string, string> = {};\n    if (search) filters.search = search;\n    if (statusFilter) filters.status = statusFilter;\n    if (oemFilter) filters.oem = oemFilter;\n    if (trainsetFilter) filters.trainset = trainsetFilter;\n    inventory.list(filters).then(data => setItems(data.items || [])).catch(() => showToast(\"Failed to load inventory\", \"error\")).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { const t = setTimeout(loadItems, 300); return () => clearTimeout(t); }, [search, statusFilter, oemFilter, trainsetFilter]);\n\n  const handleSync = () => {\n    setSyncing(true);\n    inventory.sync().then(r => { showToast(r.message, r.success ? \"success\" : \"error\"); if (r.success) loadItems(); }).catch(e => showToast(e.message, \"error\")).finally(() => setSyncing(false));\n  };\n\n  const oems = [...new Set(items.map(i => i.oem).filter(Boolean))];\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n      <div class=\"flex flex-wrap items-center justify-between gap-3\">\n        <h3 class=\"text-lg font-semibold text-slate-800\">DLP Store Inventory</h3>\n        <div class=\"flex gap-2\">\n          <Button size=\"sm\" variant=\"outline\" onClick={() => downloadCSV(\"/api/inventory/export\", \"inventory_export.csv\")}>📥 Export CSV</Button>\n          {canSync && <Button size=\"sm\" onClick={handleSync} disabled={syncing}>{syncing ? \"Syncing...\" : \"🔄 Sync from Sheets\"}</Button>}\n        </div>\n      </div>\n\n      <Card class=\"p-4\">\n        <div class=\"grid grid-cols-1 md:grid-cols-4 gap-3\">\n          <SearchBar value={search} onChange={(e: any) => setSearch(e.target.value)} placeholder=\"Search material, part no, OEM...\" />\n          <Select label=\"\" value={statusFilter} onChange={(e: any) => setStatusFilter(e.target.value)} options={[\"available\", \"issued\", \"repair\", \"replacement\"]} />\n          <Select label=\"\" value={oemFilter} onChange={(e: any) => setOemFilter(e.target.value)} options={oems.map(o => ({ value: o, label: o }))} />\n          <input type=\"text\" value={trainsetFilter} onChange={(e: any) => setTrainsetFilter(e.target.value)} placeholder=\"Filter by Trainset\" class=\"px-3 py-2 border border-slate-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-blue-500\" />\n        </div>\n      </Card>\n\n      <Card class=\"p-0\">\n        {loading ? <Loading /> : items.length === 0 ? <EmptyState message=\"No inventory items found. Sync from Google Sheets to load data.\" icon=\"📦\" /> : (\n          <Table headers={[\"Item ID\", \"OEM\", \"System\", \"Material\", \"Part No\", \"Qty\", \"Avail\", \"Repair\", \"Status\", \"Vendor\"]}>\n            {items.map((item: any) => (\n              <Tr key={item.id}>\n                <Td class=\"font-mono text-xs\">{item.item_id}</Td>\n                <Td>{item.oem}</Td>\n                <Td>{item.system}</Td>\n                <Td class=\"font-medium\">{item.material_name}</Td>\n                <Td class=\"font-mono text-xs\">{item.part_number}</Td>\n                <Td>{item.qty}</Td>\n                <Td><span class={item.available_qty > 0 ? \"text-green-600 font-medium\" : \"text-red-600\"}>{item.available_qty}</span></Td>\n                <Td>{item.repair_qty || 0}</Td>\n                <Td><Badge status={item.status} /></Td>\n                <Td class=\"text-xs\">{item.vendor}</Td>\n              </Tr>\n            ))}\n          </Table>\n        )}\n      </Card>\n      {items.length > 0 && <p class=\"text-sm text-slate-500 text-center\">Showing {items.length} items</p>}\n    </div>\n  );\n}\n",[329,226,153],"41421a05-c9b4-4bff-9299-6604b6a08604",["D",1784059771800],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { gatepass, issues, downloadCSV, openPrintPage } from \"./api.ts\";\nimport { Card, Table, Tr, Td, Badge, Loading, EmptyState, SearchBar, Select, Button, Modal, Input, Textarea, DateInput, useToast } from \"./ui.tsx\";\n\nexport function GatePassPage({ user }: { user: any }) {\n  const [items, setItems] = useState<any[]>([]);\n  const [loading, setLoading] = useState(true);\n  const [search, setSearch] = useState(\"\");\n  const [statusFilter, setStatusFilter] = useState(\"\");\n  const [dateFrom, setDateFrom] = useState(\"\");\n  const [dateTo, setDateTo] = useState(\"\");\n  const [showModal, setShowModal] = useState(false);\n  const [issuedItems, setIssuedItems] = useState<any[]>([]);\n  const [form, setForm] = useState({ issue_id: \"\", vendor_name: \"\", vendor_address: \"\", vehicle_no: \"\", driver_name: \"\", material_details: \"\", expected_return_date: \"\" });\n  const { showToast, toastEl } = useToast();\n  const canGenerate = user.role === \"admin\" || user.role === \"store\";\n\n  const load = () => {\n    setLoading(true);\n    const filters: Record<string, string> = {};\n    if (search) filters.search = search;\n    if (statusFilter) filters.status = statusFilter;\n    if (dateFrom) filters.dateFrom = dateFrom;\n    if (dateTo) filters.dateTo = dateTo;\n    gatepass.list(filters).then(data => setItems(data.items || [])).catch(() => {}).finally(() => setLoading(false));\n  };\n\n  useEffect(() => { const t = setTimeout(load, 300); return () => clearTimeout(t); }, [search, statusFilter, dateFrom, dateTo]);\n\n  const openModal = () => {\n    issues.list().then(data => setIssuedItems(data.items || []));\n    setForm({ issue_id: \"\", vendor_name: \"\", vendor_address: \"\", vehicle_no: \"\", driver_name: \"\", material_details: \"\", expected_return_date: \"\" });\n    setShowModal(true);\n  };\n\n  const selectIssue = (issueId: string) => {\n    const iss = issuedItems.find(i => i.id == issueId);\n    if (iss) {\n      const details = JSON.stringify([{ material_name: iss.material_name, part_number: iss.part_number, qty: iss.qty, condition: \"Faulty\" }]);\n      setForm({ ...form, issue_id: issueId, material_details: details });\n    }\n  };\n\n  const handleSubmit = () => {\n    if (!form.vendor_name) { showToast(\"Vendor name required\", \"error\"); return; }\n    gatepass.create(form).then(() => { setShowModal(false); showToast(\"Gate Pass generated successfully!\", \"success\"); load(); }).catch(e => showToast(e.message, \"error\"));\n  };\n\n  return (\n    <div class=\"space-y-4\">\n      {toastEl}\n      <div class=\"flex flex-wrap items-center justify-between gap-3\">\n        <h3 class=\"text-lg font-semibold text-slate-800\">Gate Pass</h3>\n        <div class=\"flex gap-2\">\n          <Button size=\"sm\" variant=\"outline\" onClick={() => downloadCSV(\"/api/gatepass/export\", \"gatepass_export.csv\")}>📥 Export</Button>\n          {canGenerate && <Button size=\"sm\" onClick={openModal}>➕ Generate Gate Pass</Button>}\n        </div>\n      </div>\n\n      {!canGenerate && <div class=\"bg-blue-50 border border-blue-200 text-blue-700 text-sm px-4 py-3 rounded-lg\">ℹ️ Only Store Person and Admin can generate Gate Pass.</div>}\n\n      <Card class=\"p-4\">\n        <div class=\"grid grid-cols-1 md:grid-cols-3 lg:grid-cols-4 gap-3\">\n          <SearchBar value={search} onChange={(e: any) => setSearch(e.target.value)} placeholder=\"Search gate pass no, vendor...\" />\n          <Select label=\"\" value={statusFilter} onChange={(e: any) => setStatusFilter(e.target.value)} options={[\"open\", \"closed\"]} />\n          <DateInput label=\"\" value={dateFrom} onChange={(e: any) => setDateFrom(e.target.value)} />\n          <DateInput label=\"\" value={dateTo} onChange={(e: any) => setDateTo(e.target.value)} />\n        </div>\n      </Card>\n\n      <Card class=\"p-0\">\n        {loading ? <Loading /> : items.length === 0 ? <EmptyState message=\"No gate passes found\" icon=\"🚪\" /> : (\n          <Table headers={[\"Gate Pass No\", \"Vendor\", \"Vehicle\", \"Driver\", \"Issue Date\", \"Expected Return\", \"Status\", \"Generated By\", \"Print\"]}>\n            {items.map((g: any) => (\n              <Tr key={g.id}>\n                <Td class=\"font-mono text-xs\">{g.gatepass_no}</Td>\n                <Td>{g.vendor_name}</Td>\n                <Td>{g.vehicle_no || \"-\"}</Td>\n                <Td>{g.driver_name || \"-\"}</Td>\n                <Td class=\"text-xs\">{new Date(g.issue_date).toLocaleDateString(\"en-IN\")}</Td>\n                <Td class=\"text-xs\">{g.expected_return_date ? new Date(g.expected_return_date).toLocaleDateString(\"en-IN\") : \"-\"}</Td>\n                <Td><Badge status={g.status} /></Td>\n                <Td class=\"text-xs\">{g.generated_by}</Td>\n                <Td><button onClick={() => openPrintPage(`/api/gatepass/${g.id}/print`)} class=\"text-blue-600 hover:text-blue-700 text-xs font-medium\">📄 Print</button></Td>\n              </Tr>\n            ))}\n          </Table>\n        )}\n      </Card>\n\n      <Modal open={showModal} onClose={() => setShowModal(false)} title=\"Generate Gate Pass\" size=\"lg\">\n        <div class=\"space-y-3\">\n          {issuedItems.length > 0 && (\n            <div>\n              <label class=\"block text-sm font-medium text-slate-600 mb-1\">Select Issue (optional)</label>\n              <select value={form.issue_id} onChange={(e: any) => selectIssue(e.target.value)} class=\"w-full px-3 py-2 border border-slate-300 rounded-lg text-sm bg-white\">\n                <option value=\"\">-- Select Issue --</option>\n                {issuedItems.map((i: any) => <option value={i.id}>{i.issue_no} - {i.material_name} ({i.officer_name})</option>)}\n              </select>\n            </div>\n          )}\n          <div class=\"grid grid-cols-1 md:grid-cols-2 gap-3\">\n            <Input label=\"Vendor Name\" value={form.vendor_name} onChange={(e: any) => setForm({ ...form, vendor_name: e.target.value })} required />\n            <Input label=\"Vehicle Number\" value={form.vehicle_no} onChange={(e: any) => setForm({ ...form, vehicle_no: e.target.value })} />\n            <Input label=\"Driver Name\" value={form.driver_name} onChange={(e: any) => setForm({ ...form, driver_name: e.target.value })} />\n            <DateInput label=\"Expected Return Date\" value={form.expected_return_date} onChange={(e: any) => setForm({ ...form, expected_return_date: e.target.value })} />\n            <Textarea label=\"Vendor Address\" value={form.vendor_address} onChange={(e: any) => setForm({ ...form, vendor_address: e.target.value })} className=\"md:col-span-2\" />\n            <Textarea label=\"Material Details (JSON format)\" value={form.material_details} onChange={(e: any) => setForm({ ...form, material_details: e.target.value })} className=\"md:col-span-2\" rows={3} />\n          </div>\n        </div>\n        <div class=\"flex justify-end gap-2 mt-4\">\n          <Button variant=\"secondary\" onClick={() => setShowModal(false)}>Cancel</Button>\n          <Button onClick={handleSubmit}>Generate Gate Pass</Button>\n        </div>\n      </Modal>\n    </div>\n  );\n}\n",[329,226,180],"512a3d70-1256-4423-813e-74614f9929d6",["D",1784059612713],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, ReactNode } from \"https://esm.sh/react@18.2.0\";\nimport { dashboard as dashboardApi } from \"./api.ts\";\nimport { Card, StatCard, Loading, Badge, Button } from \"./ui.tsx\";\nimport { InventoryPage } from \"./InventoryPage.tsx\";\nimport { RequestsPage } from \"./RequestsPage.tsx\";\nimport { IssuesPage } from \"./IssuesPage.tsx\";\nimport { GatePassPage } from \"./GatePassPage.tsx\";\nimport { RepairsPage } from \"./RepairsPage.tsx\";\nimport { ReportsPage } from \"./ReportsPage.tsx\";\nimport { UsersPage } from \"./UsersPage.tsx\";\nimport { SettingsPage } from \"./SettingsPage.tsx\";\n\nconst navItems = [\n  { hash: \"#/dashboard\", label: \"Dashboard\", icon: \"📊\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/inventory\", label: \"Inventory\", icon: \"📦\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/requests\", label: \"Material Requests\", icon: \"📝\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/issues\", label: \"Material Issues\", icon: \"📤\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/gatepass\", label: \"Gate Pass\", icon: \"🚪\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/repairs\", label: \"Repair Tracking\", icon: \"🔧\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/reports\", label: \"Reports & Export\", icon: \"📈\", roles: [\"admin\", \"store\", \"officer\", \"viewer\"] },\n  { hash: \"#/users\", label: \"User Management\", icon: \"👥\", roles: [\"admin\"] },\n  { hash: \"#/settings\", label: \"Settings\", icon: \"⚙️\", roles: [\"admin\"] },\n];\n\nfunction getRoute(): string {\n  return window.location.hash || \"#/dashboard\";\n}\n\nexport function Dashboard({ user, onLogout }: { user: any; onLogout: () => void }) {\n  const [route, setRoute] = useState(getRoute());\n  const [sidebarOpen, setSidebarOpen] = useState(false);\n\n  useEffect(() => {\n    const onHash = () => { setRoute(getRoute()); setSidebarOpen(false); };\n    window.addEventListener(\"hashchange\", onHash);\n    if (!window.location.hash) window.location.hash = \"#/dashboard\";\n    return () => window.removeEventListener(\"hashchange\", onHash);\n  }, []);\n\n  const visibleNav = navItems.filter(n => n.roles.includes(user.role));\n  const currentNav = visibleNav.find(n => n.hash === route) || visibleNav[0];\n\n  const renderPage = (): ReactNode => {\n    switch (route) {\n      case \"#/inventory\": return <InventoryPage user={user} />;\n      case \"#/requests\": return <RequestsPage user={user} />;\n      case \"#/issues\": return <IssuesPage user={user} />;\n      case \"#/gatepass\": return <GatePassPage user={user} />;\n      case \"#/repairs\": return <RepairsPage user={user} />;\n      case \"#/reports\": return <ReportsPage user={user} />;\n      case \"#/users\": return <UsersPage user={user} />;\n      case \"#/settings\": return <SettingsPage user={user} />;\n      default: return <DashboardHome user={user} />;\n    }\n  };\n\n  return (\n    <div class=\"min-h-screen bg-slate-50 flex\">\n      {sidebarOpen && <div class=\"fixed inset-0 bg-black/50 z-30 lg:hidden\" onClick={() => setSidebarOpen(false)} />}\n      <aside class={`fixed lg:sticky top-0 left-0 h-screen w-64 bg-slate-900 text-white z-40 transform transition-transform duration-200 ${sidebarOpen ? \"translate-x-0\" : \"-translate-x-full lg:translate-x-0\"} flex flex-col`}>\n        <div class=\"p-5 border-b border-slate-700 flex items-center gap-3\">\n          <div class=\"w-10 h-10 bg-blue-600 rounded-lg flex items-center justify-center font-bold text-sm\">BEML</div>\n          <div><h1 class=\"font-bold text-sm\">BEML LIMITED</h1><p class=\"text-xs text-slate-400\">KMRCL DLP System</p></div>\n        </div>\n        <nav class=\"flex-1 overflow-y-auto py-4 px-3 space-y-1\">\n          {visibleNav.map(item => (\n            <a key={item.hash} href={item.hash}\n              class={`flex items-center gap-3 px-3 py-2.5 rounded-lg text-sm font-medium transition-colors ${route === item.hash ? \"bg-blue-600 text-white\" : \"text-slate-300 hover:bg-slate-800 hover:text-white\"}`}>\n              <span class=\"text-lg\">{item.icon}</span><span>{item.label}</span>\n            </a>\n          ))}\n        </nav>\n        <div class=\"p-3 border-t border-slate-700\">\n          <div class=\"flex items-center gap-3 px-3 py-2\">\n            <div class=\"w-8 h-8 bg-slate-700 rounded-full flex items-center justify-center text-xs font-bold\">{user.name?.charAt(0)?.toUpperCase()}</div>\n            <div class=\"flex-1 min-w-0\"><p class=\"text-sm font-medium truncate\">{user.name}</p><p class=\"text-xs text-slate-400 capitalize\">{user.role}</p></div>\n          </div>\n          <button onClick={onLogout} class=\"w-full mt-2 px-3 py-2 rounded-lg text-sm text-slate-300 hover:bg-red-600 hover:text-white transition-colors text-left flex items-center gap-2\"><span>🚪</span> Logout</button>\n        </div>\n      </aside>\n      <div class=\"flex-1 flex flex-col min-w-0\">\n        <header class=\"bg-white border-b border-slate-200 sticky top-0 z-20\">\n          <div class=\"flex items-center justify-between px-4 lg:px-6 py-3\">\n            <div class=\"flex items-center gap-3\">\n              <button onClick={() => setSidebarOpen(true)} class=\"lg:hidden text-slate-600 text-xl\">☰</button>\n              <h2 class=\"text-lg font-semibold text-slate-800\">{currentNav?.label || \"Dashboard\"}</h2>\n            </div>\n            <div class=\"flex items-center gap-3\">\n              <a href=\"/source\" class=\"text-xs text-slate-400 hover:text-slate-600 hidden sm:inline\">View Source</a>\n              <span class=\"text-sm font-medium text-slate-700 hidden sm:inline\">{user.name}</span>\n              <div class=\"w-8 h-8 bg-blue-600 rounded-full flex items-center justify-center text-white text-xs font-bold\">{user.name?.charAt(0)?.toUpperCase()}</div>\n            </div>\n          </div>\n        </header>\n        <main class=\"flex-1 p-4 lg:p-6 overflow-x-hidden\">{renderPage()}</main>\n      </div>\n    </div>\n  );\n}\n\nfunction DashboardHome({ user }: { user: any }) {\n  const [stats, setStats] = useState<any>(null);\n  const [settings, setSettings] = useState<any>(null);\n  const [loading, setLoading] = useState(true);\n\n  useEffect(() => {\n    dashboardApi.get().then(data => { setStats(data.stats); setSettings(data.settings); }).catch(() => {}).finally(() => setLoading(false));\n  }, []);\n\n  if (loading) return <Loading />;\n  const s: any = stats || {};\n  const role = user.role;\n\n  return (\n    <div class=\"space-y-6\">\n      <div class=\"bg-gradient-to-r from-blue-600 to-blue-800 rounded-xl p-6 text-white\">\n        <h1 class=\"text-xl font-bold\">Welcome, {user.name}!</h1>\n        <p class=\"text-blue-200 text-sm mt-1\">BEML-KMRCL DLP Store Inventory Management System</p>\n        <p class=\"text-blue-200 text-xs mt-2\">{settings?.company_division || \"KMRCL\"}</p>\n      </div>\n      <div class=\"grid grid-cols-2 md:grid-cols-3 lg:grid-cols-4 gap-4\">\n        <StatCard title=\"Total Items\" value={s.total} icon=\"📦\" color=\"blue\" />\n        <StatCard title=\"Available\" value={s.available} icon=\"✅\" color=\"green\" />\n        <StatCard title=\"Issued\" value={s.issued} icon=\"📤\" color=\"red\" />\n        <StatCard title=\"In Repair\" value={s.repair} icon=\"🔧\" color=\"yellow\" />\n        <StatCard title=\"Open Requests\" value={s.open_requests} icon=\"📝\" color=\"orange\" />\n        <StatCard title=\"Pending Repairs\" value={s.pending_repair} icon=\"⚙️\" color=\"purple\" />\n        <StatCard title=\"Open Gate Pass\" value={s.open_gatepass} icon=\"🚪\" color=\"orange\" />\n        <StatCard title=\"Today's Issues\" value={s.today_issues} icon=\"📅\" color=\"blue\" />\n      </div>\n      <div class=\"grid grid-cols-2 md:grid-cols-4 gap-3\">\n        <a href=\"#/inventory\" class=\"bg-white rounded-xl p-4 border border-slate-200 hover:shadow-md transition-shadow text-center\"><div class=\"text-2xl mb-2\">📦</div><p class=\"text-sm font-medium text-slate-700\">View Inventory</p></a>\n        <a href=\"#/requests\" class=\"bg-white rounded-xl p-4 border border-slate-200 hover:shadow-md transition-shadow text-center\"><div class=\"text-2xl mb-2\">📝</div><p class=\"text-sm font-medium text-slate-700\">Material Request</p></a>\n        {(role === \"admin\" || role === \"store\") && <a href=\"#/issues\" class=\"bg-white rounded-xl p-4 border border-slate-200 hover:shadow-md transition-shadow text-center\"><div class=\"text-2xl mb-2\">📤</div><p class=\"text-sm font-medium text-slate-700\">Issue Material</p></a>}\n        {(role === \"admin\" || role === \"store\") && <a href=\"#/gatepass\" class=\"bg-white rounded-xl p-4 border border-slate-200 hover:shadow-md transition-shadow text-center\"><div class=\"text-2xl mb-2\">🚪</div><p class=\"text-sm font-medium text-slate-700\">Gate Pass</p></a>}\n        <a href=\"#/reports\" class=\"bg-white rounded-xl p-4 border border-slate-200 hover:shadow-md transition-shadow text-center\"><div class=\"text-2xl mb-2\">📈</div><p class=\"text-sm font-medium text-slate-700\">Reports</p></a>\n      </div>\n      {settings && (\n        <Card class=\"p-4\">\n          <div class=\"flex items-center justify-between flex-wrap gap-3\">\n            <div>\n              <p class=\"text-sm font-medium text-slate-700\">Google Sheets Sync Status</p>\n              <p class=\"text-xs text-slate-500 mt-1\">{settings.google_sheet_id ? <>Last Sync: {settings.last_sync ? new Date(settings.last_sync).toLocaleString(\"en-IN\") : \"Never synced\"}</> : \"Not configured - Admin needs to set Google Sheet ID in Settings\"}</p>\n            </div>\n            {(role === \"admin\" || role === \"store\") && settings.google_sheet_id && (\n              <Button size=\"sm\" variant=\"outline\" onClick={() => { import(\"./api.ts\").then(m => { m.inventory.sync().then((r: any) => { alert(r.message); window.location.reload(); }).catch((e: any) => alert(e.message)); }); }}>🔄 Sync Now</Button>\n            )}\n          </div>\n        </Card>\n      )}\n      <div class=\"grid grid-cols-1 lg:grid-cols-2 gap-4\">\n        <Card class=\"p-4\">\n          <h3 class=\"font-semibold text-slate-700 mb-3\">Request Summary</h3>\n          <div class=\"space-y-2\">\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Pending</span><span class=\"font-medium text-yellow-600\">{s.open_requests || 0}</span></div>\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Approved</span><span class=\"font-medium text-green-600\">{s.approved_requests || 0}</span></div>\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Rejected</span><span class=\"font-medium text-red-600\">{s.rejected_requests || 0}</span></div>\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Issued</span><span class=\"font-medium text-blue-600\">{s.issued_requests || 0}</span></div>\n            <div class=\"flex justify-between text-sm border-t pt-2\"><span class=\"font-medium\">Total</span><span class=\"font-bold\">{s.total_requests || 0}</span></div>\n          </div>\n        </Card>\n        <Card class=\"p-4\">\n          <h3 class=\"font-semibold text-slate-700 mb-3\">Inventory Summary</h3>\n          <div class=\"space-y-2\">\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Available Qty</span><span class=\"font-medium text-green-600\">{s.total_available_qty || 0}</span></div>\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Issued Qty</span><span class=\"font-medium text-red-600\">{s.total_issued_qty || 0}</span></div>\n            <div class=\"flex justify-between text-sm\"><span class=\"text-slate-500\">Repair Qty</span><span class=\"font-medium text-blue-600\">{s.total_repair_qty || 0}</span></div>\n            <div class=\"flex justify-between text-sm border-t pt-2\"><span class=\"font-medium\">Replacement</span><span class=\"font-bold text-purple-600\">{s.replacement || 0}</span></div>\n          </div>\n        </Card>\n      </div>\n    </div>\n  );\n}\n",[329,226,144],"49c68055-3716-4ac7-8792-27b1adf94db1",["D",1784059479029],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Login } from \"./Login.tsx\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { getStoredUser, clearToken, clearStoredUser, auth } from \"./api.ts\";\n\nexport function App() {\n  const [user, setUser] = useState<any>(getStoredUser());\n  const [checking, setChecking] = useState(true);\n\n  useEffect(() => {\n    // Validate stored token on mount\n    const token = localStorage.getItem(\"beml_token\");\n    if (token && user) {\n      auth.me()\n        .then(res => {\n          if (res.user) {\n            setUser(res.user);\n            localStorage.setItem(\"beml_user\", JSON.stringify(res.user));\n          } else {\n            handleLogout();\n          }\n        })\n        .catch(() => handleLogout())\n        .finally(() => setChecking(false));\n    } else {\n      setChecking(false);\n    }\n  }, []);\n\n  const handleLogin = () => {\n    setUser(getStoredUser());\n    window.location.hash = \"#/dashboard\";\n  };\n\n  const handleLogout = async () => {\n    try { await auth.logout(); } catch { /* ignore */ }\n    clearToken();\n    clearStoredUser();\n    setUser(null);\n    window.location.hash = \"#/login\";\n  };\n\n  if (checking) {\n    return (\n      <div class=\"min-h-screen flex items-center justify-center bg-slate-50\">\n        <div class=\"w-10 h-10 border-4 border-blue-200 border-t-blue-600 rounded-full animate-spin\"></div>\n      </div>\n    );\n  }\n\n  if (!user) {\n    return <Login onLogin={handleLogin} />;\n  }\n\n  return <Dashboard user={user} onLogout={handleLogout} />;\n}\n",[329,226,88],"pulls","branches","forks","envVars",{"_95":26,"_403":26},"connections",{"_95":54,"_402":26},"unfilledCount","emptyCount",{"_47":537,"_13":329,"_86":322,"_57":-5,"_49":50,"_323":54,"_324":24,"_51":538,"_53":26,"_89":227,"_326":-5,"_91":30,"_327":-5,"_434":539,"_17":540},{"_47":321,"_13":226,"_86":225,"_57":322,"_49":50,"_323":54,"_324":24,"_51":534,"_53":26,"_89":227,"_326":-5,"_91":30,"_327":-5,"_434":535,"_17":536},{"_47":391,"_13":88,"_86":87,"_57":225,"_49":50,"_323":131,"_324":24,"_51":531,"_53":54,"_89":90,"_326":393,"_91":30,"_327":-5,"_434":532,"_17":533},{"_47":387,"_13":144,"_86":143,"_57":225,"_49":50,"_323":138,"_324":24,"_51":528,"_53":26,"_89":90,"_326":389,"_91":30,"_327":-5,"_434":529,"_17":530},{"_47":383,"_13":180,"_86":179,"_57":225,"_49":50,"_323":174,"_324":24,"_51":525,"_53":26,"_89":90,"_326":385,"_91":30,"_327":-5,"_434":526,"_17":527},{"_47":379,"_13":153,"_86":152,"_57":225,"_49":50,"_323":147,"_324":24,"_51":522,"_53":26,"_89":90,"_326":381,"_91":30,"_327":-5,"_434":523,"_17":524},{"_47":375,"_13":171,"_86":170,"_57":225,"_49":50,"_323":165,"_324":24,"_51":519,"_53":26,"_89":90,"_326":377,"_91":30,"_327":-5,"_434":520,"_17":521},{"_47":371,"_13":128,"_86":127,"_57":225,"_49":50,"_323":122,"_324":24,"_51":516,"_53":26,"_89":90,"_326":373,"_91":30,"_327":-5,"_434":517,"_17":518},{"_47":367,"_13":198,"_86":197,"_57":225,"_49":50,"_323":192,"_324":24,"_51":513,"_53":26,"_89":90,"_326":369,"_91":30,"_327":-5,"_434":514,"_17":515},{"_47":363,"_13":189,"_86":188,"_57":225,"_49":50,"_323":183,"_324":24,"_51":510,"_53":26,"_89":90,"_326":365,"_91":30,"_327":-5,"_434":511,"_17":512},{"_47":359,"_13":162,"_86":161,"_57":225,"_49":50,"_323":156,"_324":24,"_51":507,"_53":26,"_89":90,"_326":361,"_91":30,"_327":-5,"_434":508,"_17":509},{"_47":355,"_13":216,"_86":215,"_57":225,"_49":50,"_323":210,"_324":24,"_51":504,"_53":26,"_89":90,"_326":357,"_91":30,"_327":-5,"_434":505,"_17":506},{"_47":351,"_13":207,"_86":206,"_57":225,"_49":50,"_323":201,"_324":24,"_51":501,"_53":26,"_89":90,"_326":353,"_91":30,"_327":-5,"_434":502,"_17":503},{"_47":347,"_13":110,"_86":109,"_57":225,"_49":50,"_323":102,"_324":24,"_51":498,"_53":26,"_89":90,"_326":349,"_91":30,"_327":-5,"_434":499,"_17":500},{"_47":343,"_13":119,"_86":118,"_57":225,"_49":50,"_323":113,"_324":24,"_51":495,"_53":26,"_89":90,"_326":345,"_91":30,"_327":-5,"_434":496,"_17":497},{"_47":488,"_13":489,"_86":490,"_57":322,"_49":50,"_323":54,"_324":24,"_51":491,"_53":26,"_89":21,"_326":492,"_91":30,"_327":-5,"_434":493,"_17":494},{"_47":480,"_13":481,"_86":482,"_57":322,"_49":50,"_323":483,"_324":24,"_51":484,"_53":54,"_89":21,"_326":485,"_91":30,"_327":-5,"_434":486,"_17":487},{"_47":473,"_13":474,"_86":475,"_57":322,"_49":50,"_323":54,"_324":24,"_51":476,"_53":26,"_89":90,"_326":477,"_91":30,"_327":-5,"_434":478,"_17":479},{"_47":469,"_13":453,"_86":447,"_57":-5,"_49":50,"_323":96,"_324":24,"_51":470,"_53":26,"_89":227,"_326":-5,"_91":30,"_327":-5,"_434":471,"_17":472},{"_47":462,"_13":463,"_86":464,"_57":447,"_49":50,"_323":96,"_324":24,"_51":465,"_53":26,"_89":90,"_326":466,"_91":30,"_327":-5,"_434":467,"_17":468},{"_47":454,"_13":455,"_86":456,"_57":447,"_49":50,"_323":457,"_324":24,"_51":458,"_53":54,"_89":90,"_326":459,"_91":30,"_327":-5,"_434":460,"_17":461},{"_47":444,"_13":445,"_86":446,"_57":447,"_49":50,"_323":448,"_324":24,"_51":449,"_53":26,"_89":90,"_326":450,"_91":30,"_327":-5,"_434":451,"_17":452},{"_47":437,"_13":438,"_86":439,"_57":-5,"_49":50,"_323":267,"_324":24,"_51":440,"_53":54,"_89":21,"_326":441,"_91":30,"_327":-5,"_434":442,"_17":443},{"_47":428,"_13":429,"_86":240,"_57":-5,"_49":50,"_323":430,"_324":24,"_51":431,"_53":54,"_89":432,"_326":433,"_91":30,"_327":-5,"_434":435,"_17":436},"de85c552-ed1b-4eda-be97-03a0287565c7","index.ts",5,["D",1784059345491],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport * as db from \"./lib/db.ts\";\nimport * as sheets from \"./lib/sheets.ts\";\nimport * as docs from \"./lib/documents.ts\";\n\nconst app = new Hono();\nlet dbInitialized = false;\n\nasync function ensureDB() {\n  if (!dbInitialized) {\n    await db.initDB();\n    dbInitialized = true;\n  }\n}\n\n// Auth middleware - extracts user from Authorization header\nasync function getUser(c: any) {\n  const auth = c.req.header(\"Authorization\");\n  if (!auth?.startsWith(\"Bearer \")) return null;\n  const token = auth.slice(7);\n  return await db.validateToken(token);\n}\n\nfunction requireAuth(c: any) {\n  // Will be checked in route handlers\n}\n\nfunction requireRole(user: any, roles: string[]) {\n  return user && roles.includes(user.role);\n}\n\n// ─── Serve Frontend ───\napp.get(\"/\", async () => {\n  await ensureDB();\n  return serveFile(\"/frontend/index.html\");\n});\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ─── Auth Routes ───\napp.post(\"/api/auth/login\", async (c) => {\n  await ensureDB();\n  const body = await c.req.json();\n  const result = await db.login(body.email, body.password);\n  if (!result) return c.json({ error: \"Invalid email or password\" }, 401);\n  await db.logAudit(result.user.name, \"LOGIN\", \"auth\", \"\", \"\", c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json(result);\n});\n\napp.post(\"/api/auth/logout\", async (c) => {\n  await ensureDB();\n  const auth = c.req.header(\"Authorization\");\n  if (auth?.startsWith(\"Bearer \")) {\n    await db.logout(auth.slice(7));\n  }\n  return c.json({ success: true });\n});\n\napp.get(\"/api/auth/me\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n  return c.json({ user });\n});\n\n// ─── Dashboard Stats ───\napp.get(\"/api/dashboard\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const stats = await db.getDashboardStats();\n  const settings = await db.getAllSettings();\n  return c.json({ stats, settings, user });\n});\n\n// ─── Inventory Routes ───\napp.get(\"/api/inventory\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const filters: Record<string, any> = {};\n  const q = c.req.query();\n  for (const key of [\"search\", \"oem\", \"system\", \"status\", \"trainset\", \"limit\"]) {\n    if (q[key]) filters[key] = q[key];\n  }\n  const items = await db.getInventory(filters);\n  return c.json({ items });\n});\n\napp.get(\"/api/inventory/stats\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const stats = await db.getInventoryStats();\n  return c.json({ stats });\n});\n\napp.get(\"/api/inventory/export\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const items = await db.getInventory({});\n  const csv = docs.exportInventoryCSV(items);\n  return new Response(csv, { headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": \"attachment; filename=inventory_export.csv\" } });\n});\n\napp.post(\"/api/inventory/sync\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\", \"store\"])) return c.json({ error: \"Only admin/store can sync\" }, 403);\n  const result = await sheets.syncInventory();\n  await db.logAudit(user.name, \"SYNC_INVENTORY\", \"inventory\", \"\", result.message, c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json(result);\n});\n\napp.get(\"/api/inventory/sheets/tabs\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const result = await sheets.testConnection();\n  return c.json(result);\n});\n\n// ─── Material Request Routes ───\napp.get(\"/api/requests\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const filters: Record<string, any> = {};\n  const q = c.req.query();\n  for (const key of [\"status\", \"officer\", \"trainset\", \"search\", \"dateFrom\", \"dateTo\"]) {\n    if (q[key]) filters[key] = q[key];\n  }\n  const items = await db.getRequests(filters);\n  return c.json({ items });\n});\n\napp.post(\"/api/requests\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const body = await c.req.json();\n  body.officer_name = body.officer_name || user.name;\n  body.officer_id = user.id;\n  const req = await db.createRequest(body);\n  await db.logAudit(user.name, \"CREATE_REQUEST\", \"requests\", \"\", req.request_no, c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ request: req });\n});\n\napp.patch(\"/api/requests/:id\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const id = parseInt(c.req.param(\"id\"));\n  const body = await c.req.json();\n  if (body.status === \"approved\" || body.status === \"rejected\") {\n    if (!requireRole(user, [\"admin\", \"store\"])) return c.json({ error: \"Only admin/store can approve/reject\" }, 403);\n    await db.updateRequestStatus(id, body.status, user.name, body.rejected_reason);\n    await db.logAudit(user.name, body.status === \"approved\" ? \"APPROVE_REQUEST\" : \"REJECT_REQUEST\", \"requests\", String(id), body.status, c.req.header(\"x-forwarded-for\") || \"\");\n  }\n  return c.json({ success: true });\n});\n\napp.get(\"/api/requests/export\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const items = await db.getRequests({});\n  const csv = docs.exportRequestsCSV(items);\n  return new Response(csv, { headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": \"attachment; filename=requests_export.csv\" } });\n});\n\n// ─── Material Issue Routes ───\napp.get(\"/api/issues\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const filters: Record<string, any> = {};\n  const q = c.req.query();\n  for (const key of [\"status\", \"trainset\", \"search\", \"dateFrom\", \"dateTo\"]) {\n    if (q[key]) filters[key] = q[key];\n  }\n  const items = await db.getIssues(filters);\n  return c.json({ items });\n});\n\napp.post(\"/api/issues\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\", \"store\"])) return c.json({ error: \"Only admin/store can issue materials\" }, 403);\n  const body = await c.req.json();\n  body.issued_by = user.name;\n  const issue = await db.createIssue(body);\n  await db.logAudit(user.name, \"ISSUE_MATERIAL\", \"issues\", \"\", issue.issue_no, c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ issue });\n});\n\napp.get(\"/api/issues/export\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const items = await db.getIssues({});\n  const csv = docs.exportIssuesCSV(items);\n  return new Response(csv, { headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": \"attachment; filename=issues_export.csv\" } });\n});\n\napp.get(\"/api/issues/:id/print\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const id = parseInt(c.req.param(\"id\"));\n  const issues = await db.getIssues({});\n  const issue = issues.find((i: any) => i.id === id);\n  if (!issue) return c.json({ error: \"Not found\" }, 404);\n  const settings = await db.getAllSettings();\n  const html = await docs.generateIssueSlipHTML(issue as any, settings);\n  return c.html(html);\n});\n\n// ─── Gate Pass Routes ───\napp.get(\"/api/gatepass\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const filters: Record<string, any> = {};\n  const q = c.req.query();\n  for (const key of [\"status\", \"search\", \"dateFrom\", \"dateTo\"]) {\n    if (q[key]) filters[key] = q[key];\n  }\n  const items = await db.getGatePasses(filters);\n  return c.json({ items });\n});\n\napp.post(\"/api/gatepass\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\", \"store\"])) return c.json({ error: \"Only store person can generate gate pass\" }, 403);\n  const body = await c.req.json();\n  body.generated_by = user.name;\n  const gp = await db.createGatePass(body);\n  await db.logAudit(user.name, \"GENERATE_GATEPASS\", \"gatepass\", \"\", gp.gatepass_no, c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ gatepass: gp });\n});\n\napp.get(\"/api/gatepass/export\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const items = await db.getGatePasses({});\n  const csv = docs.exportGatePassesCSV(items);\n  return new Response(csv, { headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": \"attachment; filename=gatepass_export.csv\" } });\n});\n\napp.get(\"/api/gatepass/:id/print\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const id = parseInt(c.req.param(\"id\"));\n  const passes = await db.getGatePasses({});\n  const gp = passes.find((g: any) => g.id === id);\n  if (!gp) return c.json({ error: \"Not found\" }, 404);\n  const settings = await db.getAllSettings();\n  const html = await docs.generateGatePassHTML(gp as any, settings);\n  return c.html(html);\n});\n\n// ─── Repair Routes ───\napp.get(\"/api/repairs\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const filters: Record<string, any> = {};\n  const q = c.req.query();\n  for (const key of [\"status\", \"search\"]) {\n    if (q[key]) filters[key] = q[key];\n  }\n  const items = await db.getRepairs(filters);\n  return c.json({ items });\n});\n\napp.post(\"/api/repairs\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\", \"store\"])) return c.json({ error: \"Only admin/store can create repair records\" }, 403);\n  const body = await c.req.json();\n  const repair = await db.createRepair(body);\n  await db.logAudit(user.name, \"CREATE_REPAIR\", \"repairs\", \"\", String(repair.id), c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ repair });\n});\n\napp.patch(\"/api/repairs/:id\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\", \"store\"])) return c.json({ error: \"Only admin/store can update repairs\" }, 403);\n  const id = parseInt(c.req.param(\"id\"));\n  const body = await c.req.json();\n  await db.updateRepair(id, body);\n  await db.logAudit(user.name, \"UPDATE_REPAIR\", \"repairs\", String(id), JSON.stringify(body), c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ success: true });\n});\n\n// ─── Settings Routes (Admin only) ───\napp.get(\"/api/settings\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  const settings = await db.getAllSettings();\n  return c.json({ settings });\n});\n\napp.post(\"/api/settings\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can update settings\" }, 403);\n  const body = await c.req.json();\n  for (const [key, value] of Object.entries(body)) {\n    await db.setSetting(key, value as string);\n  }\n  await db.logAudit(user.name, \"UPDATE_SETTINGS\", \"settings\", \"\", JSON.stringify(Object.keys(body)), c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ success: true });\n});\n\napp.post(\"/api/settings/test-connection\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can test connection\" }, 403);\n  const result = await sheets.testConnection();\n  return c.json(result);\n});\n\n// ─── User Management Routes (Admin only) ───\napp.get(\"/api/users\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can manage users\" }, 403);\n  const users = await db.getUsers();\n  return c.json({ users });\n});\n\napp.post(\"/api/users\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can create users\" }, 403);\n  const body = await c.req.json();\n  try {\n    await db.createUser(body.name, body.email, body.password, body.role, body.department, body.mobile);\n    await db.logAudit(user.name, \"CREATE_USER\", \"users\", \"\", body.email, c.req.header(\"x-forwarded-for\") || \"\");\n    return c.json({ success: true });\n  } catch (e) {\n    return c.json({ error: e.message }, 400);\n  }\n});\n\napp.patch(\"/api/users/:id\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can update users\" }, 403);\n  const id = parseInt(c.req.param(\"id\"));\n  const body = await c.req.json();\n  await db.updateUser(id, body);\n  await db.logAudit(user.name, \"UPDATE_USER\", \"users\", String(id), JSON.stringify(Object.keys(body)), c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ success: true });\n});\n\napp.delete(\"/api/users/:id\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can delete users\" }, 403);\n  const id = parseInt(c.req.param(\"id\"));\n  if (id === user.id) return c.json({ error: \"Cannot delete yourself\" }, 400);\n  await db.deleteUser(id);\n  await db.logAudit(user.name, \"DELETE_USER\", \"users\", String(id), \"\", c.req.header(\"x-forwarded-for\") || \"\");\n  return c.json({ success: true });\n});\n\n// ─── Audit Log Routes ───\napp.get(\"/api/audit\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  if (!requireRole(user, [\"admin\"])) return c.json({ error: \"Only admin can view audit logs\" }, 403);\n  const filters: Record<string, any> = {};\n  const q = c.req.query();\n  for (const key of [\"user\", \"module\", \"dateFrom\", \"dateTo\"]) {\n    if (q[key]) filters[key] = q[key];\n  }\n  const logs = await db.getAuditLogs(filters);\n  return c.json({ logs });\n});\n\n// ─── Sheet Info (for admin settings) ───\napp.get(\"/api/sheets/info\", async (c) => {\n  await ensureDB();\n  const user = await getUser(c);\n  if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n  return c.json({\n    sheetNames: sheets.SHEET_NAMES,\n    inventoryColumns: sheets.INVENTORY_COLUMNS,\n    vendorColumns: sheets.VENDOR_COLUMNS,\n    trainsetColumns: sheets.TRAINSET_COLUMNS,\n  });\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","children",[],[429],"0b61330b-3eb6-4ec4-9051-2ba1a07adaf4","README.md","019f6235-6cdf-725a-9a82-c885f648d26a",["D",1784059939649],"# BEML-KMRCL Smart DLP Store Inventory Management System (SDSIMS)\n\nEnterprise-grade inventory management system for BEML/KMRCL to manage DLP (Defect Liability Period) materials through their complete lifecycle.\n\n## 🚀 Live Application\n\n[Open the App](https://shashimishra--019f62356cdf725a9a82cc8601ead39d.web.val.run)\n\n## 🔐 Demo Login Credentials\n\n| Role | Email | Password |\n|------|-------|----------|\n| Admin | admin@beml.in | admin123 |\n| Store Person | store@beml.in | store123 |\n| Officer | officer@beml.in | officer123 |\n\n## ✨ Features\n\n- **Role-Based Access Control** — Admin, Store Person, Officer, Viewer\n- **Google Sheets Integration** — Sync inventory master data from Google Sheets\n- **Material Request Workflow** — Officer requests → Store approves/rejects → Issue material\n- **Automatic Inventory Updates** — Stock reduces on issue, restores on repair return\n- **Gate Pass Generation** — BEML letterhead format with print/PDF support\n- **Repair Tracking** — Full repair lifecycle with auto-inventory restoration\n- **Search & Filters** — Every module supports search, status, trainset, and date filters\n- **CSV Export** — Export inventory, requests, issues, and gate passes\n- **Audit Trail** — Complete action logging for all operations\n- **Responsive Design** — Works on mobile, tablet, and desktop\n\n## 📊 Google Sheet Structure\n\nCreate a Google Spreadsheet with these sheet tabs:\n\n### Sheet: \"Inventory\" (required)\nColumns: Item ID | OEM | System | Subsystem | Material Name | Part Number | Description | Qty | Available Qty | Repair Qty | Issued Qty | Returned Qty | Location | Rack | Shelf | Vendor | Warranty | DLP Expiry | Status | Updated Date | Updated By\n\n### Sheet: \"Vendors\" (optional)\nColumns: Vendor Name | Address | Contact Person | Phone | Email | GST | Remarks\n\n### Sheet: \"Trainsets\" (optional)\nColumns: Trainset Number | Car Number | System | OEM | Commissioning Date | Status\n\n## ⚙️ Environment Variables\n\n👉 Add `google_service_account` here: https://www.val.town/x/shashimishra/beml-dlp-inventory/environment-variables?key=google_service_account\n\nSet this to the full JSON contents of your Google Cloud service account key file. See the [Google Sheets guide](https://docs.val.town/guides/google-sheets/) for setup instructions.\n\n## 🏗️ Architecture\n\n```mermaid\ngraph TD\n    A[Login Page] --> B[Dashboard]\n    B --> C[Inventory Module]\n    B --> D[Material Requests]\n    B --> E[Material Issues]\n    B --> F[Gate Pass]\n    B --> G[Repair Tracking]\n    B --> H[Reports & Export]\n    B --> I[User Management - Admin]\n    B --> J[Settings - Admin]\n    C --> K[Google Sheets Sync]\n    E --> L[Auto Stock Deduction]\n    F --> M[BEML Letterhead PDF]\n    G --> N[Auto Stock Restoration]\n```\n\n## 📁 File Structure\n\n```\nindex.ts                          ← Hono server (API routes + serves frontend)\nlib/\n  db.ts                           ← SQLite schema, auth, all CRUD operations\n  sheets.ts                       ← Google Sheets API integration\n  documents.ts                    ← PDF/HTML & CSV generation with BEML letterhead\nfrontend/\n  index.html                      ← HTML shell (Twind + React)\n  index.tsx                       ← React entry point\n  components/\n    App.tsx                       ← Root component (auth state + routing)\n    Login.tsx                     ← BEML-branded login page\n    Dashboard.tsx                 ← Sidebar layout + dashboard home\n    InventoryPage.tsx             ← DLP inventory with filters & sync\n    RequestsPage.tsx              ← Material request workflow\n    IssuesPage.tsx                ← Material issue with auto stock update\n    GatePassPage.tsx              ← Gate pass generation (store only)\n    RepairsPage.tsx               ← Repair tracking with auto restoration\n    ReportsPage.tsx               ← CSV exports + audit log\n    UsersPage.tsx                 ← User management (admin only)\n    SettingsPage.tsx              ← Google Sheets config + company settings\n    api.ts                        ← API client with auth\n    ui.tsx                        ← Shared UI components\n```\n\n## 🔄 DLP Material Lifecycle\n\n1. **Inventory Sync** — Admin configures Google Sheet ID, system syncs inventory\n2. **Material Request** — Officer creates request with trainset, car, NCR, job card details\n3. **Approval** — Store Person approves or rejects the request\n4. **Issue Material** — Store issues material with healthy/faulty part numbers; stock auto-reduces\n5. **Gate Pass** — Store generates gate pass with vendor details (BEML letterhead format)\n6. **Repair/Replace** — Material sent to vendor for repair\n7. **Return** — Material received, inspected; if accepted, stock auto-restores\n8. **Reports** — Export all data in CSV format; audit trail for compliance\n",[],[438],"71dd32fe-571d-4e6e-bdeb-6ca776065deb","sheets.ts","de2e4f86-7fbe-11f1-98ab-1607ee4eb77e","89143b16-fdce-4e19-8f45-7943320f1a05",3,["D",1784059317316],"// Google Sheets Integration using gsheet_call wrapper\n// Requires env var: google_service_account (JSON key from Google Cloud Service Account)\nimport { gsheet_call } from \"https://esm.town/v/mattx/gsheet_call\";\nimport { getSetting, setSetting, syncInventoryFromSheet } from \"./db.ts\";\n\n// Expected sheet names in the Google Spreadsheet\nexport const SHEET_NAMES = {\n  INVENTORY: \"Inventory\",\n  VENDORS: \"Vendors\",\n  TRAINSETS: \"Trainsets\",\n  REQUESTS: \"Requests\",\n  ISSUES: \"Issues\",\n  GATEPASSES: \"GatePasses\",\n  REPAIRS: \"Repairs\",\n};\n\n// Expected column headers for Inventory sheet (row 1)\nexport const INVENTORY_COLUMNS = [\n  \"Item ID\", \"OEM\", \"System\", \"Subsystem\", \"Material Name\", \"Part Number\",\n  \"Description\", \"Qty\", \"Available Qty\", \"Repair Qty\", \"Issued Qty\", \"Returned Qty\",\n  \"Location\", \"Rack\", \"Shelf\", \"Vendor\", \"Warranty\", \"DLP Expiry\", \"Status\",\n  \"Updated Date\", \"Updated By\",\n];\n\nexport const VENDOR_COLUMNS = [\"Vendor Name\", \"Address\", \"Contact Person\", \"Phone\", \"Email\", \"GST\", \"Remarks\"];\nexport const TRAINSET_COLUMNS = [\"Trainset Number\", \"Car Number\", \"System\", \"OEM\", \"Commissioning Date\", \"Status\"];\n\nasync function getSheetCreds() {\n  const sa = Deno.env.get(\"google_service_account\");\n  if (!sa) throw new Error(\"Google service account not configured. Set 'google_service_account' env var.\");\n  const sheetId = await getSetting(\"google_sheet_id\");\n  if (!sheetId) throw new Error(\"Google Sheet ID not configured. Admin must set it in Settings.\");\n  return { sa, sheetId };\n}\n\n// Read a sheet's values (all rows including header)\nexport async function readSheet(sheetName: string): Promise<any[][]> {\n  const { sa, sheetId } = await getSheetCreds();\n  const range = `${sheetName}!A:Z`;\n  const data = await gsheet_call(sa, sheetId, \"GET\", `values/${encodeURIComponent(range)}?majorDimension=ROWS`, {});\n  return data.values || [];\n}\n\n// Convert raw sheet rows (header + data) to array of objects\nexport function parseSheetRows(rows: any[][]): Record<string, any>[] {\n  if (rows.length < 2) return [];\n  const headers = rows[0].map((h: string) => h?.toString().trim() || \"\");\n  const items: Record<string, any>[] = [];\n  for (let i = 1; i < rows.length; i++) {\n    if (!rows[i] || rows[i].every((c: any) => !c)) continue;\n    const obj: Record<string, any> = { sheet_row_num: i + 1 };\n    for (let j = 0; j < headers.length; j++) {\n      const key = headers[j].toLowerCase().replace(/\\s+/g, \"_\").replace(/[^a-z0-9_]/g, \"\");\n      obj[key] = rows[i][j] || \"\";\n    }\n    items.push(obj);\n  }\n  return items;\n}\n\n// Sync inventory from Google Sheets\nexport async function syncInventory(): Promise<{ success: boolean; count: number; message: string }> {\n  try {\n    const rows = await readSheet(SHEET_NAMES.INVENTORY);\n    const items = parseSheetRows(rows).map((item, idx) => ({\n      item_id: item.item_id || `INV-${idx + 1}`,\n      oem: item.oem || \"\",\n      system: item.system || \"\",\n      subsystem: item.subsystem || \"\",\n      material_name: item.material_name || item.materialname || \"\",\n      part_number: item.part_number || item.partnumber || \"\",\n      description: item.description || \"\",\n      qty: parseInt(item.qty) || 0,\n      available_qty: parseInt(item.available_qty || item.availableqty) || parseInt(item.qty) || 0,\n      repair_qty: parseInt(item.repair_qty || item.repairqty) || 0,\n      issued_qty: parseInt(item.issued_qty || item.issuedqty) || 0,\n      returned_qty: parseInt(item.returned_qty || item.returnedqty) || 0,\n      location: item.location || \"\",\n      rack: item.rack || \"\",\n      shelf: item.shelf || \"\",\n      vendor: item.vendor || \"\",\n      warranty: item.warranty || \"\",\n      dlp_expiry: item.dlp_expiry || item.dlpexpiry || \"\",\n      status: item.status || \"available\",\n      sheet_row_num: item.sheet_row_num,\n    }));\n    await syncInventoryFromSheet(items);\n    await setSetting(\"last_sync\", new Date().toISOString());\n    return { success: true, count: items.length, message: `Synced ${items.length} items from Google Sheets` };\n  } catch (e) {\n    return { success: false, count: 0, message: e.message };\n  }\n}\n\n// Write data to a sheet (append)\nexport async function appendToSheet(sheetName: string, values: any[][]): Promise<void> {\n  const { sa, sheetId } = await getSheetCreds();\n  const range = `${sheetName}!A1:Z1`;\n  await gsheet_call(sa, sheetId, \"POST\", `values/${encodeURIComponent(range)}:append?valueInputOption=RAW`, { values });\n}\n\n// Update a specific row in a sheet\nexport async function updateSheetRow(sheetName: string, rowNum: number, values: any[]): Promise<void> {\n  const { sa, sheetId } = await getSheetCreds();\n  const range = `${sheetName}!A${rowNum}:Z${rowNum}`;\n  await gsheet_call(sa, sheetId, \"PUT\", `values/${encodeURIComponent(range)}?valueInputOption=RAW`, { values });\n}\n\n// Get list of sheet tabs in the spreadsheet\nexport async function getSheetTabs(): Promise<string[]> {\n  const { sa, sheetId } = await getSheetCreds();\n  const data = await gsheet_call(sa, sheetId, \"GET\", \"?fields=sheets(properties.title)\", {});\n  return data.sheets?.map((s: any) => s.properties?.title).filter(Boolean) || [];\n}\n\n// Test connection to Google Sheets\nexport async function testConnection(): Promise<{ success: boolean; tabs: string[]; message: string }> {\n  try {\n    const tabs = await getSheetTabs();\n    return { success: true, tabs, message: `Connected. Found ${tabs.length} sheets: ${tabs.join(\", \")}` };\n  } catch (e) {\n    return { success: false, tabs: [], message: e.message };\n  }\n}\n\n// Fetch vendor data from sheet\nexport async function fetchVendors(): Promise<Record<string, any>[]> {\n  try {\n    const rows = await readSheet(SHEET_NAMES.VENDORS);\n    return parseSheetRows(rows);\n  } catch {\n    return [];\n  }\n}\n\n// Fetch trainset data from sheet\nexport async function fetchTrainsets(): Promise<Record<string, any>[]> {\n  try {\n    const rows = await readSheet(SHEET_NAMES.TRAINSETS);\n    return parseSheetRows(rows);\n  } catch {\n    return [];\n  }\n}\n",[],[453,445],"lib","2aad17a9-4c01-497b-b938-dc3058889236","documents.ts","de3b7800-7fbe-11f1-a8cc-1607ee4eb77e",20,["D",1784059875766],"// Document Generation: Gate Pass, Reports, Excel/CSV Export with BEML Letterhead\nimport { getAllSettings } from \"./db.ts\";\n\n// Generate CSV from data\nexport function generateCSV(headers: string[], rows: any[][]): string {\n  const escape = (val: any) => {\n    const s = String(val ?? \"\");\n    if (s.includes(\",\") || s.includes('\"') || s.includes(\"\\n\")) {\n      return `\"${s.replace(/\"/g, '\"\"')}\"`;\n    }\n    return s;\n  };\n  const lines = [headers.map(escape).join(\",\")];\n  for (const row of rows) {\n    lines.push(row.map(escape).join(\",\"));\n  }\n  return lines.join(\"\\n\");\n}\n\n// Generate HTML page for printing (Gate Pass with BEML Letterhead)\nexport async function generateGatePassHTML(gp: Record<string, any>, settings: Record<string, string>): string {\n  const companyName = settings.company_name || \"BEML LIMITED\";\n  const division = settings.company_division || \"KMRCL\";\n  const address = settings.company_address || \"Bengaluru, Karnataka, India\";\n  let materials: any[] = [];\n  try { materials = JSON.parse(gp.material_details || \"[]\"); } catch { /* empty */ }\n\n  return `<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"UTF-8\">\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n<title>Gate Pass - ${gp.gatepass_no}</title>\n<style>\n  * { margin: 0; padding: 0; box-sizing: border-box; }\n  body { font-family: 'Arial', sans-serif; color: #1a1a1a; padding: 20px; max-width: 800px; margin: 0 auto; }\n  .letterhead { border-bottom: 3px solid #1e40af; padding-bottom: 15px; margin-bottom: 20px; display: flex; align-items: center; gap: 15px; }\n  .logo-box { width: 70px; height: 70px; background: #1e40af; border-radius: 8px; display: flex; align-items: center; justify-content: center; color: white; font-weight: bold; font-size: 24px; flex-shrink: 0; }\n  .company-info h1 { font-size: 22px; color: #1e40af; margin: 0; }\n  .company-info h2 { font-size: 14px; color: #475569; margin: 2px 0; }\n  .company-info p { font-size: 11px; color: #64748b; margin: 2px 0; }\n  .doc-title { text-align: center; font-size: 18px; font-weight: bold; color: #1e40af; margin: 15px 0; text-transform: uppercase; letter-spacing: 2px; }\n  .gp-no { text-align: right; font-size: 13px; margin-bottom: 15px; }\n  .gp-no span { font-weight: bold; color: #1e40af; }\n  table { width: 100%; border-collapse: collapse; margin: 10px 0; }\n  table.info td { padding: 6px 12px; border: 1px solid #cbd5e1; font-size: 13px; }\n  table.info td:first-child { background: #f1f5f9; font-weight: 600; width: 25%; }\n  table.materials { margin: 15px 0; }\n  table.materials th { background: #1e40af; color: white; padding: 8px; font-size: 12px; text-align: left; border: 1px solid #1e40af; }\n  table.materials td { padding: 6px 8px; border: 1px solid #cbd5e1; font-size: 12px; }\n  table.materials tr:nth-child(even) td { background: #f8fafc; }\n  .sign-section { display: flex; justify-content: space-between; margin-top: 40px; }\n  .sign-box { text-align: center; width: 30%; }\n  .sign-line { border-top: 1px solid #333; margin-top: 40px; padding-top: 5px; font-size: 12px; font-weight: 600; }\n  .footer { margin-top: 30px; text-align: center; font-size: 10px; color: #94a3b8; border-top: 1px solid #e2e8f0; padding-top: 10px; }\n  .qr-placeholder { width: 80px; height: 80px; border: 1px dashed #94a3b8; display: flex; align-items: center; justify-content: center; font-size: 9px; color: #94a3b8; position: absolute; right: 20px; top: 100px; }\n  @media print { body { padding: 10px; } .no-print { display: none; } }\n</style>\n</head>\n<body>\n  <div class=\"letterhead\">\n    <div class=\"logo-box\">BEML</div>\n    <div class=\"company-info\">\n      <h1>${companyName}</h1>\n      <h2>${division}</h2>\n      <p>${address}</p>\n    </div>\n  </div>\n  <div class=\"doc-title\">MATERIAL GATE PASS</div>\n  <div class=\"gp-no\">Gate Pass No: <span>${gp.gatepass_no}</span></div>\n  <table class=\"info\">\n    <tr><td>Date of Issue</td><td>${new Date(gp.issue_date).toLocaleDateString(\"en-IN\")}</td><td>Status</td><td>${gp.status?.toUpperCase()}</td></tr>\n    <tr><td>Vendor Name</td><td>${gp.vendor_name}</td><td>Vehicle No</td><td>${gp.vehicle_no}</td></tr>\n    <tr><td>Vendor Address</td><td colspan=\"3\">${gp.vendor_address}</td></tr>\n    <tr><td>Driver Name</td><td>${gp.driver_name}</td><td>Generated By</td><td>${gp.generated_by}</td></tr>\n    <tr><td>Expected Return</td><td>${gp.expected_return_date ? new Date(gp.expected_return_date).toLocaleDateString(\"en-IN\") : \"N/A\"}</td><td>Actual Return</td><td>${gp.actual_return_date ? new Date(gp.actual_return_date).toLocaleDateString(\"en-IN\") : \"Pending\"}</td></tr>\n  </table>\n  <table class=\"materials\">\n    <thead><tr><th>Sl</th><th>Material Name</th><th>Part Number</th><th>Qty</th><th>Condition</th></tr></thead>\n    <tbody>\n      ${materials.length > 0 ? materials.map((m: any, i: number) => \n        `<tr><td>${i + 1}</td><td>${m.material_name || \"\"}</td><td>${m.part_number || \"\"}</td><td>${m.qty || \"\"}</td><td>${m.condition || \"Faulty\"}</td></tr>`\n      ).join(\"\") : '<tr><td colspan=\"5\" style=\"text-align:center\">No materials listed</td></tr>'}\n    </tbody>\n  </table>\n  <div class=\"sign-section\">\n    <div class=\"sign-box\"><div class=\"sign-line\">Prepared By</div></div>\n    <div class=\"sign-box\"><div class=\"sign-line\">Store In-Charge</div></div>\n    <div class=\"sign-box\"><div class=\"sign-line\">Security Officer</div></div>\n  </div>\n  <div class=\"footer\">\n    This is a system-generated gate pass from BEML-KMRCL DLP Inventory Management System.<br>\n    Generated on ${new Date().toLocaleString(\"en-IN\")}\n  </div>\n  <div class=\"no-print\" style=\"text-align:center;margin-top:20px;\">\n    <button onclick=\"window.print()\" style=\"background:#1e40af;color:white;padding:10px 24px;border:none;border-radius:6px;cursor:pointer;font-size:14px;\">Print / Save as PDF</button>\n  </div>\n</body>\n</html>`;\n}\n\n// Generate Material Issue Slip HTML\nexport async function generateIssueSlipHTML(issue: Record<string, any>, settings: Record<string, string>): Promise<string> {\n  const companyName = settings.company_name || \"BEML LIMITED\";\n  const division = settings.company_division || \"KMRCL\";\n  const address = settings.company_address || \"Bengaluru, Karnataka, India\";\n\n  return `<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"UTF-8\"><meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n<title>Material Issue Slip - ${issue.issue_no}</title>\n<style>\n  *{margin:0;padding:0;box-sizing:border-box}body{font-family:Arial,sans-serif;padding:20px;max-width:800px;margin:0 auto}\n  .letterhead{border-bottom:3px solid #1e40af;padding-bottom:15px;margin-bottom:20px;display:flex;align-items:center;gap:15px}\n  .logo-box{width:70px;height:70px;background:#1e40af;border-radius:8px;display:flex;align-items:center;justify-content:center;color:white;font-weight:bold;font-size:24px}\n  .company-info h1{font-size:22px;color:#1e40af}.company-info h2{font-size:14px;color:#475569}.company-info p{font-size:11px;color:#64748b}\n  .doc-title{text-align:center;font-size:18px;font-weight:bold;color:#1e40af;margin:15px 0;text-transform:uppercase;letter-spacing:2px}\n  table{width:100%;border-collapse:collapse;margin:10px 0}\n  table.info td{padding:6px 12px;border:1px solid #cbd5e1;font-size:13px}\n  table.info td:first-child{background:#f1f5f9;font-weight:600;width:25%}\n  .sign-section{display:flex;justify-content:space-between;margin-top:40px}\n  .sign-box{text-align:center;width:30%}.sign-line{border-top:1px solid #333;margin-top:40px;padding-top:5px;font-size:12px;font-weight:600}\n  .footer{margin-top:30px;text-align:center;font-size:10px;color:#94a3b8;border-top:1px solid #e2e8f0;padding-top:10px}\n  @media print{.no-print{display:none}}\n</style>\n</head>\n<body>\n  <div class=\"letterhead\"><div class=\"logo-box\">BEML</div>\n    <div class=\"company-info\"><h1>${companyName}</h1><h2>${division}</h2><p>${address}</p></div>\n  </div>\n  <div class=\"doc-title\">MATERIAL ISSUE SLIP</div>\n  <div style=\"text-align:right;font-size:13px;margin-bottom:10px\">Issue No: <b style=\"color:#1e40af\">${issue.issue_no}</b></div>\n  <table class=\"info\">\n    <tr><td>Date</td><td>${new Date(issue.issue_date).toLocaleDateString(\"en-IN\")}</td><td>Status</td><td>${issue.status?.toUpperCase()}</td></tr>\n    <tr><td>Officer</td><td>${issue.officer_name}</td><td>Issued By</td><td>${issue.issued_by}</td></tr>\n    <tr><td>Material</td><td>${issue.material_name}</td><td>Part Number</td><td>${issue.part_number}</td></tr>\n    <tr><td>Healthy Part</td><td>${issue.healthy_part || \"N/A\"}</td><td>Faulty Part</td><td>${issue.faulty_part || \"N/A\"}</td></tr>\n    <tr><td>Quantity</td><td>${issue.qty}</td><td>Trainset</td><td>${issue.trainset || \"N/A\"}</td></tr>\n    <tr><td>Car Number</td><td>${issue.car || \"N/A\"}</td><td>NCR No</td><td>${issue.ncr || \"N/A\"}</td></tr>\n    <tr><td>Job Card</td><td>${issue.jobcard || \"N/A\"}</td><td>Issued To</td><td>${issue.issued_to || \"N/A\"}</td></tr>\n    <tr><td>Reason</td><td colspan=\"3\">${issue.reason || \"N/A\"}</td></tr>\n  </table>\n  <div class=\"sign-section\">\n    <div class=\"sign-box\"><div class=\"sign-line\">Issued By (Store)</div></div>\n    <div class=\"sign-box\"><div class=\"sign-line\">Received By (Officer)</div></div>\n    <div class=\"sign-box\"><div class=\"sign-line\">Authorized By</div></div>\n  </div>\n  <div class=\"footer\">System-generated from BEML-KMRCL DLP Inventory Management System | ${new Date().toLocaleString(\"en-IN\")}</div>\n  <div class=\"no-print\" style=\"text-align:center;margin-top:20px\">\n    <button onclick=\"window.print()\" style=\"background:#1e40af;color:white;padding:10px 24px;border:none;border-radius:6px;cursor:pointer\">Print / Save as PDF</button>\n  </div>\n</body>\n</html>`;\n}\n\n// Inventory CSV export\nexport function exportInventoryCSV(items: any[]): string {\n  const headers = [\"Item ID\", \"OEM\", \"System\", \"Subsystem\", \"Material Name\", \"Part Number\", \"Description\", \"Qty\", \"Available\", \"Repair\", \"Issued\", \"Returned\", \"Location\", \"Rack\", \"Shelf\", \"Vendor\", \"Warranty\", \"DLP Expiry\", \"Status\", \"Updated Date\"];\n  const rows = items.map((i: any) => [i.item_id, i.oem, i.system, i.subsystem, i.material_name, i.part_number, i.description, i.qty, i.available_qty, i.repair_qty, i.issued_qty, i.returned_qty, i.location, i.rack, i.shelf, i.vendor, i.warranty, i.dlp_expiry, i.status, i.updated_date]);\n  return generateCSV(headers, rows);\n}\n\n// Requests CSV export\nexport function exportRequestsCSV(items: any[]): string {\n  const headers = [\"Request No\", \"Officer\", \"Material\", \"Part Number\", \"Qty\", \"Trainset\", \"Car\", \"NCR\", \"Job Card\", \"Reason\", \"Priority\", \"Status\", \"Created At\", \"Approved By\"];\n  const rows = items.map((i: any) => [i.request_no, i.officer_name, i.material_name, i.part_number, i.qty, i.trainset, i.car, i.ncr, i.jobcard, i.reason, i.priority, i.status, i.created_at, i.approved_by]);\n  return generateCSV(headers, rows);\n}\n\n// Issues CSV export\nexport function exportIssuesCSV(items: any[]): string {\n  const headers = [\"Issue No\", \"Officer\", \"Material\", \"Part Number\", \"Healthy Part\", \"Faulty Part\", \"Qty\", \"Trainset\", \"Car\", \"NCR\", \"Job Card\", \"Issued By\", \"Issue Date\", \"Status\"];\n  const rows = items.map((i: any) => [i.issue_no, i.officer_name, i.material_name, i.part_number, i.healthy_part, i.faulty_part, i.qty, i.trainset, i.car, i.ncr, i.jobcard, i.issued_by, i.issue_date, i.status]);\n  return generateCSV(headers, rows);\n}\n\n// Gate Passes CSV export\nexport function exportGatePassesCSV(items: any[]): string {\n  const headers = [\"Gate Pass No\", \"Vendor\", \"Vehicle No\", \"Driver\", \"Issue Date\", \"Expected Return\", \"Actual Return\", \"Status\", \"Generated By\"];\n  const rows = items.map((i: any) => [i.gatepass_no, i.vendor_name, i.vehicle_no, i.driver_name, i.issue_date, i.expected_return_date, i.actual_return_date, i.status, i.generated_by]);\n  return generateCSV(headers, rows);\n}\n",[],[453,455],"e948fff5-0e3e-4b82-9f33-6143be697c86","db.ts","b3eb2ae6-7fbe-11f1-8121-1607ee4eb77e",["D",1784059246410],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createHash, randomBytes } from \"node:crypto\";\n\n// ─── Password Hashing ───\nconst SALT = \"beml_kmrcl_2024_salt\";\nexport function hashPassword(password: string): string {\n  return createHash(\"sha256\").update(password + SALT).digest(\"hex\");\n}\nexport function generateToken(): string {\n  return randomBytes(32).toString(\"hex\");\n}\n\n// ─── Schema Initialization ───\nexport async function initDB() {\n  await sqlite.batch([\n    { sql: `CREATE TABLE IF NOT EXISTS users (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      name TEXT NOT NULL,\n      email TEXT UNIQUE NOT NULL,\n      password_hash TEXT NOT NULL,\n      role TEXT NOT NULL DEFAULT 'officer',\n      department TEXT DEFAULT '',\n      mobile TEXT DEFAULT '',\n      status TEXT DEFAULT 'active',\n      created_at TEXT DEFAULT (datetime('now'))\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS sessions (\n      token TEXT PRIMARY KEY,\n      user_id INTEGER NOT NULL,\n      expires_at TEXT NOT NULL,\n      created_at TEXT DEFAULT (datetime('now')),\n      FOREIGN KEY (user_id) REFERENCES users(id)\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS inventory (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      item_id TEXT,\n      oem TEXT DEFAULT '',\n      system TEXT DEFAULT '',\n      subsystem TEXT DEFAULT '',\n      material_name TEXT NOT NULL,\n      part_number TEXT DEFAULT '',\n      description TEXT DEFAULT '',\n      qty INTEGER DEFAULT 0,\n      available_qty INTEGER DEFAULT 0,\n      repair_qty INTEGER DEFAULT 0,\n      issued_qty INTEGER DEFAULT 0,\n      returned_qty INTEGER DEFAULT 0,\n      location TEXT DEFAULT '',\n      rack TEXT DEFAULT '',\n      shelf TEXT DEFAULT '',\n      vendor TEXT DEFAULT '',\n      warranty TEXT DEFAULT '',\n      dlp_expiry TEXT DEFAULT '',\n      status TEXT DEFAULT 'available',\n      updated_date TEXT DEFAULT (datetime('now')),\n      updated_by TEXT DEFAULT 'system',\n      sheet_row_num INTEGER\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS material_requests (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      request_no TEXT UNIQUE NOT NULL,\n      officer_id INTEGER,\n      officer_name TEXT NOT NULL,\n      material_name TEXT NOT NULL,\n      part_number TEXT DEFAULT '',\n      qty INTEGER DEFAULT 1,\n      trainset TEXT DEFAULT '',\n      car TEXT DEFAULT '',\n      ncr TEXT DEFAULT '',\n      jobcard TEXT DEFAULT '',\n      reason TEXT DEFAULT '',\n      priority TEXT DEFAULT 'normal',\n      maintenance_type TEXT DEFAULT '',\n      location TEXT DEFAULT '',\n      engineer_name TEXT DEFAULT '',\n      status TEXT DEFAULT 'pending',\n      approved_by TEXT DEFAULT '',\n      approved_at TEXT,\n      rejected_reason TEXT DEFAULT '',\n      created_at TEXT DEFAULT (datetime('now')),\n      updated_at TEXT DEFAULT (datetime('now'))\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS material_issues (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      issue_no TEXT UNIQUE NOT NULL,\n      request_id INTEGER,\n      officer_name TEXT NOT NULL,\n      material_name TEXT NOT NULL,\n      part_number TEXT DEFAULT '',\n      healthy_part TEXT DEFAULT '',\n      faulty_part TEXT DEFAULT '',\n      qty INTEGER DEFAULT 1,\n      trainset TEXT DEFAULT '',\n      car TEXT DEFAULT '',\n      ncr TEXT DEFAULT '',\n      jobcard TEXT DEFAULT '',\n      reason TEXT DEFAULT '',\n      issued_by TEXT NOT NULL,\n      issued_to TEXT DEFAULT '',\n      issue_date TEXT DEFAULT (datetime('now')),\n      status TEXT DEFAULT 'issued',\n      inventory_item_id INTEGER\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS gate_passes (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      gatepass_no TEXT UNIQUE NOT NULL,\n      issue_id INTEGER,\n      vendor_name TEXT DEFAULT '',\n      vendor_address TEXT DEFAULT '',\n      vehicle_no TEXT DEFAULT '',\n      driver_name TEXT DEFAULT '',\n      material_details TEXT DEFAULT '',\n      issue_date TEXT DEFAULT (datetime('now')),\n      expected_return_date TEXT,\n      actual_return_date TEXT,\n      status TEXT DEFAULT 'open',\n      generated_by TEXT NOT NULL,\n      created_at TEXT DEFAULT (datetime('now'))\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS repairs (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      gatepass_id INTEGER,\n      issue_id INTEGER,\n      part_number TEXT DEFAULT '',\n      material_name TEXT DEFAULT '',\n      vendor TEXT DEFAULT '',\n      repair_status TEXT DEFAULT 'sent',\n      expected_date TEXT,\n      received_date TEXT,\n      inspection_result TEXT DEFAULT '',\n      remarks TEXT DEFAULT '',\n      created_at TEXT DEFAULT (datetime('now')),\n      updated_at TEXT DEFAULT (datetime('now'))\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS settings (\n      key TEXT PRIMARY KEY,\n      value TEXT\n    )` },\n    { sql: `CREATE TABLE IF NOT EXISTS audit_log (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      user_name TEXT,\n      action TEXT,\n      module TEXT,\n      old_value TEXT DEFAULT '',\n      new_value TEXT DEFAULT '',\n      date TEXT DEFAULT (datetime('now')),\n      ip TEXT DEFAULT '',\n      device TEXT DEFAULT ''\n    )` },\n  ]);\n\n  // Seed default users if none exist\n  const userCount = await sqlite.execute(\"SELECT COUNT(*) as cnt FROM users\");\n  if (userCount.rows[0].cnt === 0) {\n    await sqlite.batch([\n      { sql: `INSERT INTO users (name, email, password_hash, role, department, mobile) VALUES (?, ?, ?, 'admin', 'IT', '9999999999')`,\n        args: [\"System Admin\", \"admin@beml.in\", hashPassword(\"admin123\")] },\n      { sql: `INSERT INTO users (name, email, password_hash, role, department, mobile) VALUES (?, ?, ?, 'store', 'Stores', '8888888888')`,\n        args: [\"Store Manager\", \"store@beml.in\", hashPassword(\"store123\")] },\n      { sql: `INSERT INTO users (name, email, password_hash, role, department, mobile) VALUES (?, ?, ?, 'officer', 'Maintenance', '7777777777')`,\n        args: [\"Maintenance Officer\", \"officer@beml.in\", hashPassword(\"officer123\")] },\n    ]);\n  }\n\n  // Seed default settings\n  const settingsCount = await sqlite.execute(\"SELECT COUNT(*) as cnt FROM settings\");\n  if (settingsCount.rows[0].cnt === 0) {\n    await sqlite.batch([\n      { sql: `INSERT INTO settings (key, value) VALUES ('company_name', 'BEML LIMITED')` },\n      { sql: `INSERT INTO settings (key, value) VALUES ('company_division', 'KMRCL - Kolkata Metro Rail Corporation Limited')` },\n      { sql: `INSERT INTO settings (key, value) VALUES ('company_address', 'BEML Limited, Bengaluru - 560013, Karnataka, India')` },\n      { sql: `INSERT INTO settings (key, value) VALUES ('google_sheet_id', '')` },\n      { sql: `INSERT INTO settings (key, value) VALUES ('google_drive_folder', '')` },\n      { sql: `INSERT INTO settings (key, value) VALUES ('sync_interval', '5')` },\n      { sql: `INSERT INTO settings (key, value) VALUES ('last_sync', '')` },\n    ]);\n  }\n}\n\n// ─── Auth Functions ───\nexport async function login(email: string, password: string): Promise<{ token: string; user: any } | null> {\n  const hash = hashPassword(password);\n  const result = await sqlite.execute({\n    sql: \"SELECT * FROM users WHERE email = ? AND password_hash = ? AND status = 'active'\",\n    args: [email, hash],\n  });\n  if (result.rows.length === 0) return null;\n  const user = result.rows[0];\n  const token = generateToken();\n  const expires = new Date(Date.now() + 7 * 24 * 60 * 60 * 1000).toISOString();\n  await sqlite.execute({\n    sql: \"INSERT INTO sessions (token, user_id, expires_at) VALUES (?, ?, ?)\",\n    args: [token, user.id, expires],\n  });\n  return { token, user: { id: user.id, name: user.name, email: user.email, role: user.role, department: user.department, mobile: user.mobile } };\n}\n\nexport async function validateToken(token: string): Promise<any | null> {\n  if (!token) return null;\n  const result = await sqlite.execute({\n    sql: `SELECT u.* FROM sessions s JOIN users u ON s.user_id = u.id \n          WHERE s.token = ? AND s.expires_at > datetime('now') AND u.status = 'active'`,\n    args: [token],\n  });\n  if (result.rows.length === 0) return null;\n  const u = result.rows[0];\n  return { id: u.id, name: u.name, email: u.email, role: u.role, department: u.department, mobile: u.mobile };\n}\n\nexport async function logout(token: string): Promise<void> {\n  await sqlite.execute({ sql: \"DELETE FROM sessions WHERE token = ?\", args: [token] });\n}\n\n// ─── User CRUD ───\nexport async function getUsers() {\n  const r = await sqlite.execute(\"SELECT id, name, email, role, department, mobile, status, created_at FROM users ORDER BY id\");\n  return r.rows;\n}\n\nexport async function createUser(name: string, email: string, password: string, role: string, department: string, mobile: string) {\n  await sqlite.execute({\n    sql: \"INSERT INTO users (name, email, password_hash, role, department, mobile) VALUES (?, ?, ?, ?, ?, ?)\",\n    args: [name, email, hashPassword(password), role, department, mobile],\n  });\n}\n\nexport async function updateUser(id: number, data: Record<string, any>) {\n  const fields: string[] = [];\n  const values: any[] = [];\n  for (const [k, v] of Object.entries(data)) {\n    if (k === \"password\") {\n      fields.push(\"password_hash = ?\");\n      values.push(hashPassword(v));\n    } else if ([\"name\", \"email\", \"role\", \"department\", \"mobile\", \"status\"].includes(k)) {\n      fields.push(`${k} = ?`);\n      values.push(v);\n    }\n  }\n  if (fields.length === 0) return;\n  values.push(id);\n  await sqlite.execute({ sql: `UPDATE users SET ${fields.join(\", \")} WHERE id = ?`, args: values });\n}\n\nexport async function deleteUser(id: number) {\n  await sqlite.execute({ sql: \"DELETE FROM users WHERE id = ?\", args: [id] });\n}\n\n// ─── Inventory CRUD ───\nexport async function getInventory(filters?: Record<string, any>) {\n  let sql = \"SELECT * FROM inventory WHERE 1=1\";\n  const args: any[] = [];\n  if (filters?.search) {\n    sql += ` AND (material_name LIKE ? OR part_number LIKE ? OR oem LIKE ? OR system LIKE ? OR vendor LIKE ?)`;\n    const s = `%${filters.search}%`;\n    args.push(s, s, s, s, s);\n  }\n  if (filters?.oem) { sql += ` AND oem = ?`; args.push(filters.oem); }\n  if (filters?.system) { sql += ` AND system = ?`; args.push(filters.system); }\n  if (filters?.status) { sql += ` AND status = ?`; args.push(filters.status); }\n  if (filters?.trainset) { sql += ` AND id IN (SELECT inventory_item_id FROM material_issues WHERE trainset = ?)`; args.push(filters.trainset); }\n  sql += \" ORDER BY id DESC\";\n  if (filters?.limit) { sql += ` LIMIT ${parseInt(filters.limit)}`; }\n  const r = await sqlite.execute({ sql, args });\n  return r.rows;\n}\n\nexport async function getInventoryItem(id: number) {\n  const r = await sqlite.execute({ sql: \"SELECT * FROM inventory WHERE id = ?\", args: [id] });\n  return r.rows[0] || null;\n}\n\nexport async function getInventoryStats() {\n  const r = await sqlite.execute(`\n    SELECT \n      COUNT(*) as total,\n      SUM(CASE WHEN status = 'available' THEN 1 ELSE 0 END) as available,\n      SUM(CASE WHEN status = 'issued' THEN 1 ELSE 0 END) as issued,\n      SUM(CASE WHEN status = 'repair' THEN 1 ELSE 0 END) as repair,\n      SUM(CASE WHEN status = 'replacement' THEN 1 ELSE 0 END) as replacement,\n      SUM(available_qty) as total_available_qty,\n      SUM(repair_qty) as total_repair_qty,\n      SUM(issued_qty) as total_issued_qty\n    FROM inventory\n  `);\n  return r.rows[0];\n}\n\nexport async function syncInventoryFromSheet(items: Record<string, any>[]) {\n  await sqlite.execute(\"DELETE FROM inventory\");\n  for (const item of items) {\n    await sqlite.execute({\n      sql: `INSERT INTO inventory (item_id, oem, system, subsystem, material_name, part_number, description, qty, available_qty, repair_qty, issued_qty, returned_qty, location, rack, shelf, vendor, warranty, dlp_expiry, status, updated_date, updated_by, sheet_row_num)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\n        item.item_id || \"\", item.oem || \"\", item.system || \"\", item.subsystem || \"\",\n        item.material_name || \"\", item.part_number || \"\", item.description || \"\",\n        item.qty || 0, item.available_qty || 0, item.repair_qty || 0,\n        item.issued_qty || 0, item.returned_qty || 0,\n        item.location || \"\", item.rack || \"\", item.shelf || \"\",\n        item.vendor || \"\", item.warranty || \"\", item.dlp_expiry || \"\",\n        item.status || \"available\", new Date().toISOString(), \"system\", item.sheet_row_num || null,\n      ],\n    });\n  }\n}\n\n// ─── Material Request CRUD ───\nfunction genRequestNo() {\n  return `MR-${new Date().getFullYear()}-${String(Date.now()).slice(-6)}`;\n}\n\nexport async function getRequests(filters?: Record<string, any>) {\n  let sql = \"SELECT * FROM material_requests WHERE 1=1\";\n  const args: any[] = [];\n  if (filters?.status) { sql += ` AND status = ?`; args.push(filters.status); }\n  if (filters?.officer) { sql += ` AND officer_name LIKE ?`; args.push(`%${filters.officer}%`); }\n  if (filters?.trainset) { sql += ` AND trainset = ?`; args.push(filters.trainset); }\n  if (filters?.search) {\n    sql += ` AND (material_name LIKE ? OR part_number LIKE ? OR request_no LIKE ? OR ncr LIKE ? OR jobcard LIKE ?)`;\n    const s = `%${filters.search}%`;\n    args.push(s, s, s, s, s);\n  }\n  if (filters?.dateFrom) { sql += ` AND created_at >= ?`; args.push(filters.dateFrom); }\n  if (filters?.dateTo) { sql += ` AND created_at <= ?`; args.push(filters.dateTo); }\n  sql += \" ORDER BY id DESC\";\n  const r = await sqlite.execute({ sql, args });\n  return r.rows;\n}\n\nexport async function createRequest(data: Record<string, any>) {\n  const requestNo = genRequestNo();\n  await sqlite.execute({\n    sql: `INSERT INTO material_requests (request_no, officer_id, officer_name, material_name, part_number, qty, trainset, car, ncr, jobcard, reason, priority, maintenance_type, location, engineer_name, status)\n          VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending')`,\n    args: [requestNo, data.officer_id || null, data.officer_name, data.material_name,\n           data.part_number || \"\", data.qty || 1, data.trainset || \"\", data.car || \"\",\n           data.ncr || \"\", data.jobcard || \"\", data.reason || \"\", data.priority || \"normal\",\n           data.maintenance_type || \"\", data.location || \"\", data.engineer_name || \"\"],\n  });\n  const r = await sqlite.execute({ sql: \"SELECT * FROM material_requests WHERE request_no = ?\", args: [requestNo] });\n  return r.rows[0];\n}\n\nexport async function updateRequestStatus(id: number, status: string, approvedBy: string, reason?: string) {\n  if (status === \"approved\") {\n    await sqlite.execute({\n      sql: `UPDATE material_requests SET status = 'approved', approved_by = ?, approved_at = datetime('now'), updated_at = datetime('now') WHERE id = ?`,\n      args: [approvedBy, id],\n    });\n  } else if (status === \"rejected\") {\n    await sqlite.execute({\n      sql: `UPDATE material_requests SET status = 'rejected', rejected_reason = ?, updated_at = datetime('now') WHERE id = ?`,\n      args: [reason || \"\", id],\n    });\n  } else {\n    await sqlite.execute({\n      sql: `UPDATE material_requests SET status = ?, updated_at = datetime('now') WHERE id = ?`,\n      args: [status, id],\n    });\n  }\n}\n\n// ─── Material Issue CRUD ───\nfunction genIssueNo() {\n  return `ISS-${new Date().getFullYear()}-${String(Date.now()).slice(-6)}`;\n}\n\nexport async function getIssues(filters?: Record<string, any>) {\n  let sql = \"SELECT * FROM material_issues WHERE 1=1\";\n  const args: any[] = [];\n  if (filters?.status) { sql += ` AND status = ?`; args.push(filters.status); }\n  if (filters?.trainset) { sql += ` AND trainset = ?`; args.push(filters.trainset); }\n  if (filters?.search) {\n    sql += ` AND (material_name LIKE ? OR part_number LIKE ? OR issue_no LIKE ? OR ncr LIKE ? OR jobcard LIKE ?)`;\n    const s = `%${filters.search}%`;\n    args.push(s, s, s, s, s);\n  }\n  if (filters?.dateFrom) { sql += ` AND issue_date >= ?`; args.push(filters.dateFrom); }\n  if (filters?.dateTo) { sql += ` AND issue_date <= ?`; args.push(filters.dateTo); }\n  sql += \" ORDER BY id DESC\";\n  const r = await sqlite.execute({ sql, args });\n  return r.rows;\n}\n\nexport async function createIssue(data: Record<string, any>) {\n  const issueNo = genIssueNo();\n  await sqlite.execute({\n    sql: `INSERT INTO material_issues (issue_no, request_id, officer_name, material_name, part_number, healthy_part, faulty_part, qty, trainset, car, ncr, jobcard, reason, issued_by, issued_to, status, inventory_item_id)\n          VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'issued', ?)`,\n    args: [issueNo, data.request_id || null, data.officer_name, data.material_name,\n           data.part_number || \"\", data.healthy_part || \"\", data.faulty_part || \"\",\n           data.qty || 1, data.trainset || \"\", data.car || \"\", data.ncr || \"\",\n           data.jobcard || \"\", data.reason || \"\", data.issued_by, data.issued_to || \"\",\n           data.inventory_item_id || null],\n  });\n  // Reduce inventory available_qty\n  if (data.inventory_item_id) {\n    await sqlite.execute({\n      sql: `UPDATE inventory SET available_qty = available_qty - ?, issued_qty = issued_qty + ?, status = CASE WHEN available_qty - ? <= 0 THEN 'issued' ELSE status END, updated_date = datetime('now') WHERE id = ?`,\n      args: [data.qty || 1, data.qty || 1, data.qty || 1, data.inventory_item_id],\n    });\n  }\n  // Update request status\n  if (data.request_id) {\n    await updateRequestStatus(data.request_id, \"issued\", data.issued_by);\n  }\n  const r = await sqlite.execute({ sql: \"SELECT * FROM material_issues WHERE issue_no = ?\", args: [issueNo] });\n  return r.rows[0];\n}\n\n// ─── Gate Pass CRUD ───\nfunction genGatePassNo() {\n  return `GP-${new Date().getFullYear()}-${String(Date.now()).slice(-6)}`;\n}\n\nexport async function getGatePasses(filters?: Record<string, any>) {\n  let sql = \"SELECT * FROM gate_passes WHERE 1=1\";\n  const args: any[] = [];\n  if (filters?.status) { sql += ` AND status = ?`; args.push(filters.status); }\n  if (filters?.search) {\n    sql += ` AND (gatepass_no LIKE ? OR vendor_name LIKE ? OR vehicle_no LIKE ?)`;\n    const s = `%${filters.search}%`;\n    args.push(s, s, s);\n  }\n  if (filters?.dateFrom) { sql += ` AND issue_date >= ?`; args.push(filters.dateFrom); }\n  if (filters?.dateTo) { sql += ` AND issue_date <= ?`; args.push(filters.dateTo); }\n  sql += \" ORDER BY id DESC\";\n  const r = await sqlite.execute({ sql, args });\n  return r.rows;\n}\n\nexport async function createGatePass(data: Record<string, any>) {\n  const gatepassNo = genGatePassNo();\n  await sqlite.execute({\n    sql: `INSERT INTO gate_passes (gatepass_no, issue_id, vendor_name, vendor_address, vehicle_no, driver_name, material_details, issue_date, expected_return_date, status, generated_by)\n          VALUES (?, ?, ?, ?, ?, ?, ?, datetime('now'), ?, 'open', ?)`,\n    args: [gatepassNo, data.issue_id || null, data.vendor_name || \"\", data.vendor_address || \"\",\n           data.vehicle_no || \"\", data.driver_name || \"\", data.material_details || \"\",\n           data.expected_return_date || \"\", data.generated_by],\n  });\n  const r = await sqlite.execute({ sql: \"SELECT * FROM gate_passes WHERE gatepass_no = ?\", args: [gatepassNo] });\n  return r.rows[0];\n}\n\nexport async function updateGatePassStatus(id: number, status: string, returnDate?: string) {\n  if (status === \"closed\" && returnDate) {\n    await sqlite.execute({ sql: `UPDATE gate_passes SET status = 'closed', actual_return_date = ? WHERE id = ?`, args: [returnDate, id] });\n  } else {\n    await sqlite.execute({ sql: `UPDATE gate_passes SET status = ? WHERE id = ?`, args: [status, id] });\n  }\n}\n\n// ─── Repair CRUD ───\nexport async function getRepairs(filters?: Record<string, any>) {\n  let sql = \"SELECT * FROM repairs WHERE 1=1\";\n  const args: any[] = [];\n  if (filters?.status) { sql += ` AND repair_status = ?`; args.push(filters.status); }\n  if (filters?.search) {\n    sql += ` AND (part_number LIKE ? OR material_name LIKE ? OR vendor LIKE ?)`;\n    const s = `%${filters.search}%`;\n    args.push(s, s, s);\n  }\n  sql += \" ORDER BY id DESC\";\n  const r = await sqlite.execute({ sql, args });\n  return r.rows;\n}\n\nexport async function createRepair(data: Record<string, any>) {\n  await sqlite.execute({\n    sql: `INSERT INTO repairs (gatepass_id, issue_id, part_number, material_name, vendor, repair_status, expected_date, remarks)\n          VALUES (?, ?, ?, ?, ?, 'sent', ?, ?)`,\n    args: [data.gatepass_id || null, data.issue_id || null, data.part_number || \"\",\n           data.material_name || \"\", data.vendor || \"\", data.expected_date || \"\", data.remarks || \"\"],\n  });\n  const r = await sqlite.execute(\"SELECT * FROM repairs ORDER BY id DESC LIMIT 1\");\n  return r.rows[0];\n}\n\nexport async function updateRepair(id: number, data: Record<string, any>) {\n  const fields: string[] = [];\n  const values: any[] = [];\n  for (const [k, v] of Object.entries(data)) {\n    if ([\"repair_status\", \"expected_date\", \"received_date\", \"inspection_result\", \"remarks\", \"vendor\"].includes(k)) {\n      fields.push(`${k} = ?`);\n      values.push(v);\n    }\n  }\n  fields.push(\"updated_at = datetime('now')\");\n  if (fields.length === 0) return;\n  values.push(id);\n  await sqlite.execute({ sql: `UPDATE repairs SET ${fields.join(\", \")} WHERE id = ?`, args: values });\n\n  // If repair complete and received, update inventory\n  if (data.repair_status === \"received\" && data.inspection_result === \"accepted\") {\n    const repair = await sqlite.execute({ sql: \"SELECT * FROM repairs WHERE id = ?\", args: [id] });\n    if (repair.rows[0]) {\n      const r = repair.rows[0] as any;\n      if (r.issue_id) {\n        const issue = await sqlite.execute({ sql: \"SELECT * FROM material_issues WHERE id = ?\", args: [r.issue_id] });\n        if (issue.rows[0]) {\n          const iss = issue.rows[0] as any;\n          if (iss.inventory_item_id) {\n            await sqlite.execute({\n              sql: `UPDATE inventory SET available_qty = available_qty + ?, repair_qty = repair_qty - ?, status = 'available', updated_date = datetime('now') WHERE id = ?`,\n              args: [iss.qty || 1, iss.qty || 1, iss.inventory_item_id],\n            });\n          }\n        }\n      }\n    }\n  }\n}\n\n// ─── Settings ───\nexport async function getSetting(key: string): Promise<string> {\n  const r = await sqlite.execute({ sql: \"SELECT value FROM settings WHERE key = ?\", args: [key] });\n  return r.rows[0]?.value as string || \"\";\n}\n\nexport async function setSetting(key: string, value: string) {\n  await sqlite.execute({ sql: `INSERT INTO settings (key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value = ?`, args: [key, value, value] });\n}\n\nexport async function getAllSettings() {\n  const r = await sqlite.execute(\"SELECT key, value FROM settings\");\n  const settings: Record<string, string> = {};\n  for (const row of r.rows) {\n    settings[row.key as string] = row.value as string;\n  }\n  return settings;\n}\n\n// ─── Audit Log ───\nexport async function logAudit(userName: string, action: string, module: string, oldValue: string, newValue: string, ip: string) {\n  await sqlite.execute({\n    sql: \"INSERT INTO audit_log (user_name, action, module, old_value, new_value, ip) VALUES (?, ?, ?, ?, ?, ?)\",\n    args: [userName, action, module, oldValue, newValue, ip],\n  });\n}\n\nexport async function getAuditLogs(filters?: Record<string, any>) {\n  let sql = \"SELECT * FROM audit_log WHERE 1=1\";\n  const args: any[] = [];\n  if (filters?.user) { sql += ` AND user_name LIKE ?`; args.push(`%${filters.user}%`); }\n  if (filters?.module) { sql += ` AND module = ?`; args.push(filters.module); }\n  if (filters?.dateFrom) { sql += ` AND date >= ?`; args.push(filters.dateFrom); }\n  if (filters?.dateTo) { sql += ` AND date <= ?`; args.push(filters.dateTo); }\n  sql += \" ORDER BY id DESC LIMIT 200\";\n  const r = await sqlite.execute({ sql, args });\n  return r.rows;\n}\n\n// ─── Dashboard Stats ───\nexport async function getDashboardStats() {\n  const invStats = await getInventoryStats();\n  const reqStats = await sqlite.execute(`\n    SELECT \n      SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as open_requests,\n      SUM(CASE WHEN status = 'approved' THEN 1 ELSE 0 END) as approved_requests,\n      SUM(CASE WHEN status = 'rejected' THEN 1 ELSE 0 END) as rejected_requests,\n      SUM(CASE WHEN status = 'issued' THEN 1 ELSE 0 END) as issued_requests,\n      COUNT(*) as total_requests\n    FROM material_requests\n  `);\n  const issueStats = await sqlite.execute(`\n    SELECT \n      COUNT(*) as total_issues,\n      SUM(CASE WHEN date(issue_date) = date('now') THEN 1 ELSE 0 END) as today_issues\n    FROM material_issues\n  `);\n  const gpStats = await sqlite.execute(`\n    SELECT \n      SUM(CASE WHEN status = 'open' THEN 1 ELSE 0 END) as open_gatepass,\n      SUM(CASE WHEN status = 'closed' THEN 1 ELSE 0 END) as closed_gatepass\n    FROM gate_passes\n  `);\n  const repairStats = await sqlite.execute(`\n    SELECT \n      SUM(CASE WHEN repair_status = 'sent' THEN 1 ELSE 0 END) as pending_repair,\n      SUM(CASE WHEN repair_status = 'received' THEN 1 ELSE 0 END) as received_repair\n    FROM repairs\n  `);\n  return {\n    ...invStats,\n    ...reqStats.rows[0],\n    ...issueStats.rows[0],\n    ...gpStats.rows[0],\n    ...repairStats.rows[0],\n  };\n}\n",[],[453,463],"d5d9867d-0e44-4d97-8426-56d8cf1b356a",["D",1784059246410],[423,424,425],[453],"f3a773ec-9565-432d-b22a-96e5632a6027","index.tsx","019f6235-6cdf-725a-9a82-c3958d50db54",["D",1784059096199],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n  throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render(<App />);",[],[329,474],"3f234ccd-c6c2-41e7-a72e-286ae3d793cf","index.html","019f6235-6cdf-725a-9a82-bf50b8f9f1b4",6,["D",1784059391295],"<!DOCTYPE html>\n<html lang=\"en\">\n  <head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0, maximum-scale=5.0\">\n    <meta name=\"description\" content=\"BEML-KMRCL Smart DLP Store Inventory Management System\">\n    <title>BEML DLP Inventory Management System</title>\n    <script src=\"https://cdn.twind.style\" crossorigin></script>\n    <link rel=\"icon\" href=\"/frontend/favicon.svg\" type=\"image/svg+xml\">\n  </head>\n  <body class=\"font-sans bg-slate-50 text-gray-800 antialiased\">\n    <div id=\"root\"></div>\n    <script src=\"https://esm.town/v/std/catch\"></script>\n    <script src=\"/frontend/index.tsx\" type=\"module\"></script>\n  </body>\n</html>",[],[329,481],"1ec485d4-1cb5-4bc2-ad98-551609edcc2e","favicon.svg","019f6235-6cdf-725a-9a82-b8e09d7be142",["D",1784059096199],"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<svg width=\"32\" height=\"32\" viewBox=\"0 0 32 32\" xmlns=\"http://www.w3.org/2000/svg\">\n  <rect x=\"4\" y=\"4\" width=\"24\" height=\"24\" rx=\"6\" fill=\"#4a90e2\" />\n  <circle cx=\"16\" cy=\"16\" r=\"8\" fill=\"#ffffff\" opacity=\"0.3\" />\n</svg>",[],[329,489],["D",1784059467354],[],[329,226,119],["D",1784059391558],[],[329,226,110],["D",1784059861343],[],[329,226,207],["D",1784059861347],[],[329,226,216],["D",1784059689111],[],[329,226,162],["D",1784059823435],[],[329,226,189],["D",1784059823488],[],[329,226,198],["D",1784059467360],[],[329,226,128],["D",1784059771799],[],[329,226,171],["D",1784059689109],[],[329,226,153],["D",1784059771800],[],[329,226,180],["D",1784059612713],[],[329,226,144],["D",1784059479029],[],[329,226,88],["D",1784059096199],[406,407,408,409,410,411,412,413,414,415,416,417,418],[329,226],"d899d053-fc25-4016-bca9-8d914ba817a6",["D",1784059096199],[405,419,420,421],[329],["D",1784059096199],["D",1789560070146],{"_11":12,"_284":94},{"_11":12,"_279":280,"_93":94,"_31":92,"_281":282,"_283":30},{"_53":267,"_13":16,"_47":50,"_268":229,"_269":83,"_270":271,"_272":233,"_273":274,"_275":276,"_277":14,"_278":12},"ctx",{"_66":-5,"_305":579,"_580":581,"_582":583,"_584":30,"_585":30,"_586":30,"_587":24,"_588":-5,"_589":-7,"_590":-7,"_591":26,"_592":30,"_593":30,"_594":-5,"_595":30,"_596":30,"_597":30,"_598":-5},"ENV",{"_550":551,"_552":553,"_554":16,"_555":556,"_557":558,"_559":560,"_561":562,"_563":564,"_565":566,"_567":568,"_569":570,"_571":572,"_573":574,"_575":576,"_577":578},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]
</article></body></html>

History · components