[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_210":211,"_212":213},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",62,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","schema.ts","latestPath","fileId","c42d980c-805a-11f1-8847-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function ensureSchema() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS packages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category TEXT NOT NULL,\n sub_category TEXT,\n item TEXT NOT NULL,\n scope_notes TEXT,\n source TEXT,\n status TEXT NOT NULL DEFAULT 'Not Started',\n criticality TEXT,\n lead_time_weeks INTEGER,\n budget_inr REAL,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS vendors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n package_id INTEGER NOT NULL REFERENCES packages(id) ON DELETE CASCADE,\n name TEXT NOT NULL,\n contact_person TEXT,\n phone TEXT,\n email TEXT,\n address TEXT,\n quote_amount REAL,\n lead_time_weeks INTEGER,\n status TEXT DEFAULT 'In Discussion',\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS vendor_documents (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n vendor_id INTEGER NOT NULL REFERENCES vendors(id) ON DELETE CASCADE,\n doc_type TEXT NOT NULL DEFAULT 'Other',\n label TEXT,\n drive_link TEXT NOT NULL,\n added_by TEXT,\n added_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n sort_order INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS sub_categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category_id INTEGER NOT NULL REFERENCES categories(id) ON DELETE CASCADE,\n name TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(category_id, name)\n )`,\n },\n { sql: `CREATE INDEX IF NOT EXISTS idx_subcat_category ON sub_categories(category_id)` },\n {\n sql: `CREATE TABLE IF NOT EXISTS purchase_orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n vendor_id INTEGER NOT NULL REFERENCES vendors(id) ON DELETE CASCADE,\n po_number TEXT NOT NULL,\n po_date TEXT,\n amount REAL,\n expected_delivery_date TEXT,\n status TEXT NOT NULL DEFAULT 'Issued',\n notes TEXT,\n created_by TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS suppliers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE COLLATE NOCASE,\n contact_person TEXT,\n phone TEXT,\n email TEXT,\n address TEXT,\n gst_number TEXT,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n { sql: `CREATE INDEX IF NOT EXISTS idx_suppliers_name ON suppliers(name)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_vendors_package ON vendors(package_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_docs_vendor ON vendor_documents(vendor_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_packages_category ON packages(category)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_packages_status ON packages(status)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_po_vendor ON purchase_orders(vendor_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_po_status ON purchase_orders(status)` },\n ]);\n\n // vendors.supplier_id is a later addition — ALTER TABLE ADD COLUMN isn't idempotent,\n // so check for it first before adding.\n const cols = await sqlite.execute(`PRAGMA table_info(vendors)`);\n const hasSupplierId = (cols.rows as any[]).some((r) => r.name === \"supplier_id\");\n if (!hasSupplierId) {\n await sqlite.execute(`ALTER TABLE vendors ADD COLUMN supplier_id INTEGER REFERENCES suppliers(id)`);\n }\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_vendors_supplier ON vendors(supplier_id)`);\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function ensureSchema() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS packages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category TEXT NOT NULL,\n sub_category TEXT,\n item TEXT NOT NULL,\n scope_notes TEXT,\n source TEXT,\n status TEXT NOT NULL DEFAULT 'Not Started',\n criticality TEXT,\n lead_time_weeks INTEGER,\n budget_inr REAL,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS vendors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n package_id INTEGER NOT NULL REFERENCES packages(id) ON DELETE CASCADE,\n name TEXT NOT NULL,\n contact_person TEXT,\n phone TEXT,\n email TEXT,\n address TEXT,\n quote_amount REAL,\n lead_time_weeks INTEGER,\n status TEXT DEFAULT 'In Discussion',\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS vendor_documents (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n vendor_id INTEGER NOT NULL REFERENCES vendors(id) ON DELETE CASCADE,\n doc_type TEXT NOT NULL DEFAULT 'Other',\n label TEXT,\n drive_link TEXT NOT NULL,\n added_by TEXT,\n added_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n sort_order INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS sub_categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category_id INTEGER NOT NULL REFERENCES categories(id) ON DELETE CASCADE,\n name TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(category_id, name)\n )`,\n },\n { sql: `CREATE INDEX IF NOT EXISTS idx_subcat_category ON sub_categories(category_id)` },\n {\n sql: `CREATE TABLE IF NOT EXISTS purchase_orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n vendor_id INTEGER NOT NULL REFERENCES vendors(id) ON DELETE CASCADE,\n po_number TEXT NOT NULL,\n po_date TEXT,\n amount REAL,\n expected_delivery_date TEXT,\n status TEXT NOT NULL DEFAULT 'Issued',\n notes TEXT,\n created_by TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS suppliers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE COLLATE NOCASE,\n contact_person TEXT,\n phone TEXT,\n email TEXT,\n address TEXT,\n gst_number TEXT,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n { sql: `CREATE INDEX IF NOT EXISTS idx_suppliers_name ON suppliers(name)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_vendors_package ON vendors(package_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_docs_vendor ON vendor_documents(vendor_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_packages_category ON packages(category)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_packages_status ON packages(status)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_po_vendor ON purchase_orders(vendor_id)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_po_status ON purchase_orders(status)` },\n {\n sql: `CREATE TABLE IF NOT EXISTS doc_sequences (\n series TEXT PRIMARY KEY,\n next_value INTEGER NOT NULL\n )`,\n },\n { sql: `INSERT OR IGNORE INTO doc_sequences (series, next_value) VALUES ('PO', 101001)` },\n {\n sql: `CREATE TABLE IF NOT EXISTS po_line_items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n po_id INTEGER NOT NULL REFERENCES purchase_orders(id) ON DELETE CASCADE,\n sort_order INTEGER DEFAULT 0,\n description TEXT NOT NULL,\n hsn_code TEXT,\n lead_time TEXT,\n uom TEXT,\n qty REAL DEFAULT 1,\n unit_price REAL DEFAULT 0,\n remarks TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n { sql: `CREATE INDEX IF NOT EXISTS idx_po_line_items_po ON po_line_items(po_id)` },\n ]);\n\n // purchase_orders header/terms fields — later additions, ALTER TABLE ADD COLUMN isn't idempotent.\n const poCols = await sqlite.execute(`PRAGMA table_info(purchase_orders)`);\n const poColNames = new Set((poCols.rows as any[]).map((r) => r.name));\n const newPoColumns: [string, string][] = [\n [\"ssi_contact_person\", \"TEXT\"],\n [\"ssi_contact_phone\", \"TEXT\"],\n [\"date_of_inquiry\", \"TEXT\"],\n [\"validity\", \"TEXT\"],\n [\"inquiry_reference\", \"TEXT\"],\n [\"incoterms\", \"TEXT\"],\n [\"payment_terms\", \"TEXT\"],\n [\"supplier_bill_from\", \"TEXT\"],\n [\"supplier_ship_from\", \"TEXT\"],\n [\"customer_bill_to\", \"TEXT\"],\n [\"customer_ship_to\", \"TEXT\"],\n [\"customer_note\", \"TEXT\"],\n [\"terms_text\", \"TEXT\"],\n [\"tech_specs_text\", \"TEXT\"],\n [\"annexures_text\", \"TEXT\"],\n ];\n for (const [col, type] of newPoColumns) {\n if (!poColNames.has(col)) {\n await sqlite.execute(`ALTER TABLE purchase_orders ADD COLUMN ${col} ${type}`);\n }\n }\n\n // vendors.supplier_id is a later addition — ALTER TABLE ADD COLUMN isn't idempotent,\n // so check for it first before adding.\n const cols = await sqlite.execute(`PRAGMA table_info(vendors)`);\n const hasSupplierId = (cols.rows as any[]).some((r) => r.name === \"supplier_id\");\n if (!hasSupplierId) {\n await sqlite.execute(`ALTER TABLE vendors ADD COLUMN supplier_id INTEGER REFERENCES suppliers(id)`);\n }\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_vendors_supplier ON vendors(supplier_id)`);\n}\n","createdAt",["D",1784139412314],"branchVersion","branchId","686b5dce-cd23-4f3b-b657-739819207c9f","id","8ef53ee4-b514-4717-943b-03def6406f18","goa-procurement",["D",1784125734204],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Goa facility procurement system of record","imageUrl","5b49fcdc-60d6-48e4-a18c-3cca7b140a73","pinnedFileId","81bfec96-8059-11f1-9eab-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f5aa4-1957-733f-98bc-78eddca76558","tursoName","8ef53ee4b5144717943b03def6406f18","tursoHostname","8ef53ee4b5144717943b03def6406f18-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789559472742],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",125,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","gaurangshah","handle","displayName","avatar","https://lh3.googleusercontent.com/a/ACg8ocKuN0CbJHs1ZVPzsULMED0KNVRUugDMjw9Fso7eUQXioPaaKmf1-g=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":205,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":206,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":207,"_84":208,"_86":209,"_88":25},"tree",[184,185,186,187,188],"files",[184,185,186,187,188],"counts",{"_173":63,"_174":175,"_176":63,"_177":178,"_179":180},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":166,"_32":167,"_30":168,"_138":-5,"_41":42,"_40":169,"_140":25,"_38":170,"_13":148,"_33":34,"_35":171,"_24":25,"_144":-5,"_27":172},{"_43":158,"_32":159,"_30":160,"_138":-5,"_41":42,"_40":161,"_140":25,"_38":162,"_13":163,"_33":34,"_35":164,"_24":25,"_144":-5,"_27":165},{"_43":150,"_32":151,"_30":57,"_138":-5,"_41":42,"_40":152,"_140":25,"_38":153,"_13":154,"_33":155,"_35":156,"_24":25,"_144":-5,"_27":157},{"_43":146,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":147,"_13":148,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":149},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":141,"_13":142,"_33":34,"_35":143,"_24":25,"_144":-5,"_27":145},"47f672a0-bbe8-4be8-9d47-aabafed00be9","views.tsx","f1184d80-805a-11f1-b93f-1607ee4eb77e","parentId",58,"latest",["D",1784139123145],24,"/** @jsxImportSource npm:hono@4/jsx */\nimport type { FC } from \"npm:hono@4/jsx\";\nimport type {\n Package,\n Vendor,\n VendorDoc,\n DashboardStats,\n PurchaseOrder,\n PurchaseOrderWithContext,\n Category,\n SubCategoryWithCategory,\n Supplier,\n SupplierWithStats,\n} from \"./db.ts\";\nimport { PACKAGE_STATUSES, VENDOR_STATUSES, DOC_TYPES, PO_STATUSES, statusColor } from \"./constants.ts\";\n\nexport const Layout: FC<{ title: string; user?: { email: string; username: string | null } | null; children?: any }> = (\n { title, user, children },\n) => {\n return (\n \n \n \n \n {title} — Goa Procurement\n \n \n \n \n

\n \n Goa Procurement\n \n \n

\n {user ? (\n <>\n {user.username ?? user.email}\n \n \n ) : null}\n view source\n

{children}

\n \n \n );\n};\n\nexport const ForbiddenView: FC<{ email: string | null | undefined }> = ({ email }) => (\n

Not authorized

\n {email ? `${email} is` : \"Your account is\"} not on the access list for this project. Ask\n Gaurang to add you.\n

\n \n

\n);\n\nexport const LoginView: FC = () => (\n

Goa Procurement

\n \n Log in with Val Town\n \n

\n);\n\nconst StatusBadge: FC<{ status: string | null }> = ({ status }) => (\n \n {status ?? \"—\"}\n \n);\n\nexport const DashboardView: FC<{ stats: DashboardStats }> = ({ stats }) => {\n const maxCount = Math.max(1, ...stats.byStatus.map((s) => s.count));\n return (\n

{stats.totalPackages}

Total packages

{stats.totalVendors}

Vendors on file

\n {stats.byStatus.find((s) => s.status === \"Completed\")?.count ?? 0}\n

Completed

\n {stats.byStatus.find((s) => s.status === \"Not Started\")?.count ?? 0}\n

Not started

\n\n

{stats.totalPOs}

POs issued

₹{stats.totalPOValue.toLocaleString(\"en-IN\")}

Total PO value

\n {stats.poByStatus.find((s) => s.status === \"Delivered\")?.count ?? 0}\n

POs delivered

\n\n

Packages by status

\n {stats.byStatus.map((s) => (\n

{s.count}

\n ))}\n

\n\n

By category

\n \n \n \n \n \n \n \n \n \n \n \n {stats.byCategory.map((c) => (\n \n \n \n \n \n \n \n ))}\n \n

Category	Total	Completed	Order Placed	Not Started
\n \n {c.category}\n \n	{c.total}	{c.completed}	{c.order_placed}	{c.not_started}

\n \n );\n};\n\nexport const PackagesView: FC<{\n packages: Package[];\n categories: Category[];\n subCategories: SubCategoryWithCategory[];\n categoryFilter: string;\n statusFilter: string;\n}> = ({ packages, categories, subCategories, categoryFilter, statusFilter }) => (\n

Packages ({packages.length})

\n\n \n\n

\n \n \n \n \n \n \n \n \n \n \n {packages.map((p) => (\n \n \n \n \n \n \n ))}\n \n

Category	Item	Status	Source
\n {p.category}\n {p.sub_category ? {p.sub_category} : null}\n	\n {p.item}\n		{p.source}

\n\n

Add a new package

\n Need a new category or sub-category first? Manage categories.\n

\n \n \n

\n);\n\nexport const PackageDetailView: FC<{\n pkg: Package;\n vendors: Vendor[];\n docsByVendor: Record;\n posByVendor: Record;\n categories: Category[];\n subCategories: SubCategoryWithCategory[];\n suppliers: SupplierWithStats[];\n userEmail: string;\n}> = ({ pkg, vendors, docsByVendor, posByVendor, categories, subCategories, suppliers, userEmail }) => (\n

\n Packages / {pkg.category}\n {pkg.sub_category ? ` / ${pkg.sub_category}` : \"\"}\n

{pkg.item}

\n\n

Vendors ({vendors.length})

\n {vendors.length === 0 ?

No vendors added yet.

: null}\n

\n {vendors.map((v) => (\n

\n {v.name}\n {v.supplier_id\n ? (\n \n supplier profile\n \n )\n : null}\n

\n \n

\n {v.contact_person ?

Contact: {v.contact_person}

: null}\n {v.phone ?

Phone: {v.phone}

: null}\n {v.email ?

Email: {v.email}

: null}\n {v.quote_amount ?

Quote: ₹{v.quote_amount.toLocaleString(\"en-IN\")}

: null}\n {v.lead_time_weeks ?

Lead time: {v.lead_time_weeks} wk

: null}\n

\n {v.notes ?

{v.notes}

: null}\n\n \n\n

Documents

\n \n [{d.doc_type}] {d.label || d.drive_link}\n \n
None linked yet.

\n \n

\n\n

Purchase Orders

\n {(posByVendor[v.id] ?? []).map((po) => (\n

\n {po.po_number}\n \n

\n {po.po_date ? <>Dated {po.po_date} · : null}\n {po.amount ? <>₹{po.amount.toLocaleString(\"en-IN\")} · : null}\n {po.expected_delivery_date ? <>ETA {po.expected_delivery_date} : null}\n

\n \n

\n ))}\n {(posByVendor[v.id] ?? []).length === 0 ?

No POs issued yet.

: null}\n

\n \n

\n ))}\n

\n\n

Add a vendor

\n Typing an existing supplier's name links this to their record automatically — no duplicates.{\" \"}\n Manage suppliers.\n

\n \n

\n\n

Package details

\n Item name\n \n

\n Category\n \n

\n Sub-category\n \n

\n Status\n \n

\n Criticality\n \n

\n Lead time (weeks)\n \n

\n Budget (₹)\n \n

\n Scope notes\n \n

\n Notes\n \n

\n \n

\n Source: {pkg.source ?? \"—\"}
\n Last updated: {pkg.updated_at}\n

\n \n \n \n

\n);\n\nexport const CategoriesView: FC<{\n categories: Category[];\n subCategories: SubCategoryWithCategory[];\n packages: Package[];\n}> = ({ categories, subCategories, packages }) => {\n const countForCategory = (name: string) => packages.filter((p) => p.category === name).length;\n const countForSubCategory = (categoryName: string, name: string) =>\n packages.filter((p) => p.category === categoryName && p.sub_category === name).length;\n\n return (\n

Categories & Sub-categories

\n This is the master list used everywhere in the app. Rename a category here and every package using it\n updates automatically. A category or sub-category can't be deleted while packages still use it.\n

\n\n

Categories ({categories.length})

\n \n \n \n \n \n \n \n \n \n \n {categories.map((c) => (\n \n \n \n \n \n \n ))}\n \n

Name	Packages	Rename	Delete
{c.name}	{countForCategory(c.name)}	\n \n \n \n \n	\n \n \n \n

\n \n

\n\n

Sub-categories ({subCategories.length})

\n \n \n \n \n \n \n \n \n \n \n \n {subCategories.map((sc) => (\n \n \n \n \n \n \n \n ))}\n \n

Category	Name	Packages	Rename	Delete
{sc.category_name}	{sc.name}	{countForSubCategory(sc.category_name, sc.name)}	\n \n \n \n \n	\n \n \n \n

\n \n

\n );\n};\n\nexport const SuppliersListView: FC<{ suppliers: SupplierWithStats[] }> = ({ suppliers }) => (\n

Suppliers ({suppliers.length})

\n This is the master supplier list. Adding a vendor from a package page with a name that matches one here links\n to it automatically — suppliers are never duplicated.\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n {suppliers.map((s) => (\n \n \n \n \n \n \n \n ))}\n {suppliers.length === 0 ? (\n \n ) : null}\n \n

Name	Contact	Phone	Email	Packages
\n {s.name}\n	{s.contact_person ?? \"—\"}	{s.phone ?? \"—\"}	{s.email ?? \"—\"}	{s.package_count}
No suppliers yet.

\n\n

Add a new supplier

\n \n

\n);\n\nexport const SupplierDetailView: FC<{\n supplier: Supplier;\n packages: { vendor_id: number; package_id: number; package_item: string; package_category: string; status: string | null }[];\n allPackages: Package[];\n}> = ({ supplier, packages, allPackages }) => {\n const assignedIds = new Set(packages.map((p) => p.package_id));\n const assignablePackages = allPackages.filter((p) => !assignedIds.has(p.id));\n return (\n

\n Suppliers\n

{supplier.name}

\n\n

Package assignments ({packages.length})

\n {packages.length === 0 ?

Not assigned to any packages yet.

: null}\n

\n {packages.map((p) => (\n

\n {p.package_item}\n

{p.package_category}

\n \n

\n ))}\n

\n {assignablePackages.length > 0 ? (\n \n ) : null}\n

\n\n

Supplier details

\n \n

\n \n \n \n

\n );\n};\n\nexport const POsListView: FC<{\n pos: PurchaseOrderWithContext[];\n statusFilter: string;\n totalValue: number;\n}> = ({ pos, statusFilter, totalValue }) => (\n

Purchase Orders ({pos.length})

Total value: ₹{totalValue.toLocaleString(\"en-IN\")}

\n\n \n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {pos.map((po) => (\n \n \n \n \n \n \n \n \n \n ))}\n {pos.length === 0 ? (\n \n ) : null}\n \n

PO Number	Package	Vendor	Amount	PO Date	Expected Delivery	Status
{po.po_number}	\n {po.package_item}\n {po.package_category} \n	{po.vendor_name}	{po.amount ? `₹${po.amount.toLocaleString(\"en-IN\")}` : \"—\"}	{po.po_date ?? \"—\"}	{po.expected_delivery_date ?? \"—\"}
No purchase orders yet.

\n);\n","label",[136],"8a1e912e-d401-4dbf-8a60-84d6e95d19d0",["D",1784139412314],4,[28],"e9a909eb-5fbd-426e-b5ce-c25d1c1e986a","main.tsx",61,["D",1784139155111],15,"http","/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono } from \"npm:hono@4\";\nimport type { Context } from \"npm:hono@4\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { ensureSchema } from \"./schema.ts\";\nimport {\n addCategory,\n addDocument,\n addPackage,\n addPO,\n addSubCategory,\n addSupplier,\n addVendor,\n assignSupplierToPackage,\n dashboardStats,\n deleteCategory,\n deletePackage,\n deleteSubCategory,\n deleteSupplier,\n getAllCategories,\n getAllPackages,\n getAllPOs,\n getAllSubCategories,\n getAllSuppliers,\n getDocumentsForVendor,\n getPackage,\n getPackagesForSupplier,\n getPO,\n getPOsForVendor,\n getSupplier,\n getVendor,\n getVendorsForPackage,\n renameCategory,\n renameSubCategory,\n updatePackageFields,\n updatePOFields,\n updateSupplierFields,\n updateVendorFields,\n} from \"./db.ts\";\nimport { isAllowed } from \"./constants.ts\";\nimport {\n CategoriesView,\n DashboardView,\n ForbiddenView,\n Layout,\n LoginView,\n PackageDetailView,\n PackagesView,\n POsListView,\n SupplierDetailView,\n SuppliersListView,\n} from \"./views.tsx\";\n\nawait ensureSchema();\n\nconst app = new Hono();\napp.onError((err) => {\n console.error(err);\n return Promise.reject(err);\n});\n\ntype Access = { email: string; username: string | null };\n\nasync function requireAccess(c: Context): Promise {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login\");\n const email = session.user.email;\n if (!isAllowed(email)) {\n return c.html(, 403);\n }\n return { email: email!, username: session.user.username };\n}\n\napp.get(\"/\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.html();\n return c.redirect(\"/dashboard\");\n});\n\napp.get(\"/dashboard\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const stats = await dashboardStats();\n return c.html();\n});\n\napp.get(\"/packages\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const categoryFilter = c.req.query(\"category\") ?? \"\";\n const statusFilter = c.req.query(\"status\") ?? \"\";\n const all = await getAllPackages();\n const categories = await getAllCategories();\n const subCategories = await getAllSubCategories();\n const filtered = all.filter(\n (p) =>\n (!categoryFilter || p.category === categoryFilter) &&\n (!statusFilter || p.status === statusFilter),\n );\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/packages\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const body = await c.req.parseBody();\n const id = await addPackage({\n category: String(body.category ?? \"\").trim(),\n sub_category: body.sub_category ? String(body.sub_category).trim() : undefined,\n item: String(body.item ?? \"\").trim(),\n scope_notes: body.scope_notes ? String(body.scope_notes).trim() : undefined,\n status: body.status ? String(body.status) : undefined,\n notes: body.notes ? String(body.notes).trim() : undefined,\n source: \"Manual\",\n });\n return c.redirect(`/packages/${id}`);\n});\n\napp.get(\"/packages/:id\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const pkg = await getPackage(id);\n if (!pkg) return c.text(\"Package not found\", 404);\n const vendors = await getVendorsForPackage(id);\n const docsByVendor: Record>> = {};\n const posByVendor: Record>> = {};\n for (const v of vendors) {\n docsByVendor[v.id] = await getDocumentsForVendor(v.id);\n posByVendor[v.id] = await getPOsForVendor(v.id);\n }\n const categories = await getAllCategories();\n const subCategories = await getAllSubCategories();\n const suppliers = await getAllSuppliers();\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/packages/:id/update\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n await updatePackageFields(id, {\n item: body.item ? String(body.item).trim() : undefined,\n category: body.category ? String(body.category).trim() : undefined,\n sub_category: body.sub_category !== undefined ? (String(body.sub_category).trim() || null) : undefined,\n status: body.status ? String(body.status) : undefined,\n criticality: body.criticality ? String(body.criticality) : undefined,\n lead_time_weeks: body.lead_time_weeks ? Number(body.lead_time_weeks) : undefined,\n budget_inr: body.budget_inr ? Number(body.budget_inr) : undefined,\n scope_notes: body.scope_notes !== undefined ? String(body.scope_notes) : undefined,\n notes: body.notes !== undefined ? String(body.notes) : undefined,\n });\n return c.redirect(`/packages/${id}`);\n});\n\napp.post(\"/packages/:id/delete\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n await deletePackage(id);\n return c.redirect(\"/packages\");\n});\n\napp.post(\"/packages/:id/vendors\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n await addVendor(id, {\n name: String(body.name ?? \"\").trim(),\n contact_person: body.contact_person ? String(body.contact_person).trim() : undefined,\n phone: body.phone ? String(body.phone).trim() : undefined,\n email: body.email ? String(body.email).trim() : undefined,\n quote_amount: body.quote_amount ? Number(body.quote_amount) : undefined,\n status: body.status ? String(body.status) : undefined,\n notes: body.notes ? String(body.notes).trim() : undefined,\n });\n return c.redirect(`/packages/${id}`);\n});\n\napp.post(\"/vendors/:id/status\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n const vendor = await getVendor(id);\n if (!vendor) return c.text(\"Vendor not found\", 404);\n await updateVendorFields(id, { status: String(body.status ?? vendor.status) });\n return c.redirect(`/packages/${vendor.package_id}`);\n});\n\napp.post(\"/vendors/:id/documents\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n const vendor = await getVendor(id);\n if (!vendor) return c.text(\"Vendor not found\", 404);\n await addDocument(id, {\n doc_type: String(body.doc_type ?? \"Other\"),\n label: body.label ? String(body.label).trim() : undefined,\n drive_link: String(body.drive_link ?? \"\").trim(),\n added_by: access.email,\n });\n return c.redirect(`/packages/${vendor.package_id}`);\n});\n\napp.get(\"/pos\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const statusFilter = c.req.query(\"status\") ?? \"\";\n const all = await getAllPOs();\n const filtered = statusFilter ? all.filter((po) => po.status === statusFilter) : all;\n const totalValue = filtered\n .filter((po) => po.status !== \"Cancelled\")\n .reduce((sum, po) => sum + (po.amount ?? 0), 0);\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/vendors/:id/pos\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n await addPO(id, {\n po_number: String(body.po_number ?? \"\").trim(),\n po_date: body.po_date ? String(body.po_date) : undefined,\n amount: body.amount ? Number(body.amount) : undefined,\n expected_delivery_date: body.expected_delivery_date ? String(body.expected_delivery_date) : undefined,\n created_by: access.email,\n });\n const vendor = await getVendor(id);\n return c.redirect(`/packages/${vendor?.package_id ?? \"\"}`);\n});\n\napp.post(\"/pos/:id/status\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n const po = await getPO(id);\n if (!po) return c.text(\"PO not found\", 404);\n await updatePOFields(id, { status: String(body.status ?? po.status) });\n const vendor = await getVendor(po.vendor_id);\n return c.redirect(`/packages/${vendor?.package_id ?? \"\"}`);\n});\n\napp.get(\"/categories\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const categories = await getAllCategories();\n const subCategories = await getAllSubCategories();\n const packages = await getAllPackages();\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/categories\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const body = await c.req.parseBody();\n const name = String(body.name ?? \"\").trim();\n if (name) await addCategory(name);\n return c.redirect(\"/categories\");\n});\n\napp.post(\"/categories/:id/rename\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n const name = String(body.name ?? \"\").trim();\n if (name) await renameCategory(id, name);\n return c.redirect(\"/categories\");\n});\n\napp.post(\"/categories/:id/delete\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n try {\n await deleteCategory(id);\n } catch (err) {\n return c.text(err instanceof Error ? err.message : \"Could not delete category\", 400);\n }\n return c.redirect(\"/categories\");\n});\n\napp.post(\"/subcategories\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const body = await c.req.parseBody();\n const categoryId = Number(body.category_id ?? 0);\n const name = String(body.name ?? \"\").trim();\n if (categoryId && name) await addSubCategory(categoryId, name);\n return c.redirect(\"/categories\");\n});\n\napp.post(\"/subcategories/:id/rename\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n const name = String(body.name ?? \"\").trim();\n if (name) await renameSubCategory(id, name);\n return c.redirect(\"/categories\");\n});\n\napp.post(\"/subcategories/:id/delete\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n try {\n await deleteSubCategory(id);\n } catch (err) {\n return c.text(err instanceof Error ? err.message : \"Could not delete sub-category\", 400);\n }\n return c.redirect(\"/categories\");\n});\n\napp.get(\"/suppliers\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const suppliers = await getAllSuppliers();\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/suppliers\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const body = await c.req.parseBody();\n const name = String(body.name ?? \"\").trim();\n if (name) {\n await addSupplier({\n name,\n contact_person: body.contact_person ? String(body.contact_person).trim() : undefined,\n phone: body.phone ? String(body.phone).trim() : undefined,\n email: body.email ? String(body.email).trim() : undefined,\n address: body.address ? String(body.address).trim() : undefined,\n gst_number: body.gst_number ? String(body.gst_number).trim() : undefined,\n notes: body.notes ? String(body.notes).trim() : undefined,\n });\n }\n return c.redirect(\"/suppliers\");\n});\n\napp.get(\"/suppliers/:id\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const supplier = await getSupplier(id);\n if (!supplier) return c.text(\"Supplier not found\", 404);\n const packages = await getPackagesForSupplier(id);\n const allPackages = await getAllPackages();\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/suppliers/:id/update\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n await updateSupplierFields(id, {\n name: body.name ? String(body.name).trim() : undefined,\n contact_person: body.contact_person !== undefined ? (String(body.contact_person).trim() || null) : undefined,\n phone: body.phone !== undefined ? (String(body.phone).trim() || null) : undefined,\n email: body.email !== undefined ? (String(body.email).trim() || null) : undefined,\n address: body.address !== undefined ? (String(body.address).trim() || null) : undefined,\n gst_number: body.gst_number !== undefined ? (String(body.gst_number).trim() || null) : undefined,\n notes: body.notes !== undefined ? (String(body.notes).trim() || null) : undefined,\n });\n return c.redirect(`/suppliers/${id}`);\n});\n\napp.post(\"/suppliers/:id/delete\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n try {\n await deleteSupplier(id);\n } catch (err) {\n return c.text(err instanceof Error ? err.message : \"Could not delete supplier\", 400);\n }\n return c.redirect(\"/suppliers\");\n});\n\napp.post(\"/suppliers/:id/assign\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.parseBody();\n const packageId = Number(body.package_id ?? 0);\n if (packageId) {\n await assignSupplierToPackage(packageId, id, {\n quote_amount: body.quote_amount ? Number(body.quote_amount) : undefined,\n });\n }\n return c.redirect(`/suppliers/${id}`);\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default oauthMiddleware(app.fetch);\n",[151],"366b375e-3028-41cf-9117-6457d1664de0","db.ts","d25420ae-805a-11f1-8f16-1607ee4eb77e",52,["D",1784139054628],10,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Package {\n id: number;\n category: string;\n sub_category: string | null;\n item: string;\n scope_notes: string | null;\n source: string | null;\n status: string;\n criticality: string | null;\n lead_time_weeks: number | null;\n budget_inr: number | null;\n notes: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface Vendor {\n id: number;\n package_id: number;\n supplier_id: number | null;\n name: string;\n contact_person: string | null;\n phone: string | null;\n email: string | null;\n address: string | null;\n quote_amount: number | null;\n lead_time_weeks: number | null;\n status: string | null;\n notes: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface VendorDoc {\n id: number;\n vendor_id: number;\n doc_type: string;\n label: string | null;\n drive_link: string;\n added_by: string | null;\n added_at: string;\n}\n\nexport interface Category {\n id: number;\n name: string;\n sort_order: number;\n created_at: string;\n}\n\nexport interface SubCategory {\n id: number;\n category_id: number;\n name: string;\n created_at: string;\n}\n\nexport interface SubCategoryWithCategory extends SubCategory {\n category_name: string;\n}\n\nexport interface Supplier {\n id: number;\n name: string;\n contact_person: string | null;\n phone: string | null;\n email: string | null;\n address: string | null;\n gst_number: string | null;\n notes: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface SupplierWithStats extends Supplier {\n package_count: number;\n}\n\nexport interface PurchaseOrder {\n id: number;\n vendor_id: number;\n po_number: string;\n po_date: string | null;\n amount: number | null;\n expected_delivery_date: string | null;\n status: string;\n notes: string | null;\n created_by: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface PurchaseOrderWithContext extends PurchaseOrder {\n vendor_name: string;\n package_id: number;\n package_item: string;\n package_category: string;\n}\n\nexport async function getAllPackages(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM packages ORDER BY category, sub_category, item\",\n );\n return r.rows as unknown as Package[];\n}\n\nexport async function getPackage(id: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM packages WHERE id = ?\",\n args: [id],\n });\n return (r.rows[0] as unknown as Package) ?? null;\n}\n\nexport async function getVendorsForPackage(packageId: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM vendors WHERE package_id = ? ORDER BY status, name\",\n args: [packageId],\n });\n return r.rows as unknown as Vendor[];\n}\n\nexport async function getVendor(id: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM vendors WHERE id = ?\",\n args: [id],\n });\n return (r.rows[0] as unknown as Vendor) ?? null;\n}\n\nexport async function getDocumentsForVendor(vendorId: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM vendor_documents WHERE vendor_id = ? ORDER BY added_at DESC\",\n args: [vendorId],\n });\n return r.rows as unknown as VendorDoc[];\n}\n\nexport interface DashboardStats {\n byStatus: { status: string; count: number }[];\n byCategory: {\n category: string;\n total: number;\n completed: number;\n order_placed: number;\n not_started: number;\n }[];\n totalPackages: number;\n totalVendors: number;\n totalPOs: number;\n totalPOValue: number;\n poByStatus: { status: string; count: number }[];\n}\n\nexport async function dashboardStats(): Promise {\n const byStatus = await sqlite.execute(\n \"SELECT status, COUNT(*) as count FROM packages GROUP BY status ORDER BY count DESC\",\n );\n const byCategory = await sqlite.execute(\n `SELECT category,\n COUNT(*) as total,\n SUM(CASE WHEN status = 'Completed' THEN 1 ELSE 0 END) as completed,\n SUM(CASE WHEN status = 'Order Placed' THEN 1 ELSE 0 END) as order_placed,\n SUM(CASE WHEN status = 'Not Started' THEN 1 ELSE 0 END) as not_started\n FROM packages GROUP BY category ORDER BY category`,\n );\n const total = await sqlite.execute(\"SELECT COUNT(*) as c FROM packages\");\n const vendorTotal = await sqlite.execute(\"SELECT COUNT(*) as c FROM vendors\");\n const poTotal = await sqlite.execute(\n \"SELECT COUNT(*) as c, COALESCE(SUM(amount), 0) as total_value FROM purchase_orders WHERE status != 'Cancelled'\",\n );\n const poByStatus = await sqlite.execute(\n \"SELECT status, COUNT(*) as count FROM purchase_orders GROUP BY status ORDER BY count DESC\",\n );\n return {\n byStatus: byStatus.rows as unknown as { status: string; count: number }[],\n byCategory: byCategory.rows as unknown as DashboardStats[\"byCategory\"],\n totalPackages: Number((total.rows[0] as any).c),\n totalVendors: Number((vendorTotal.rows[0] as any).c),\n totalPOs: Number((poTotal.rows[0] as any).c),\n totalPOValue: Number((poTotal.rows[0] as any).total_value),\n poByStatus: poByStatus.rows as unknown as { status: string; count: number }[],\n };\n}\n\nexport async function updatePackageFields(id: number, fields: Partial) {\n const keys = Object.keys(fields).filter((k) => (fields as any)[k] !== undefined);\n if (keys.length === 0) return;\n const sets = keys.map((k) => `${k} = ?`).join(\", \");\n const args = keys.map((k) => (fields as any)[k]);\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE packages SET ${sets}, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n args,\n });\n}\n\nexport async function addPackage(p: {\n category: string;\n sub_category?: string;\n item: string;\n scope_notes?: string;\n source?: string;\n status?: string;\n criticality?: string;\n lead_time_weeks?: number;\n budget_inr?: number;\n notes?: string;\n}) {\n const r = await sqlite.execute({\n sql: `INSERT INTO packages (category, sub_category, item, scope_notes, source, status, criticality, lead_time_weeks, budget_inr, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n p.category,\n p.sub_category ?? null,\n p.item,\n p.scope_notes ?? null,\n p.source ?? \"Manual\",\n p.status ?? \"Not Started\",\n p.criticality ?? null,\n p.lead_time_weeks ?? null,\n p.budget_inr ?? null,\n p.notes ?? null,\n ],\n });\n return r.lastInsertRowid;\n}\n\nexport async function addVendor(\n packageId: number,\n v: {\n name: string;\n contact_person?: string;\n phone?: string;\n email?: string;\n address?: string;\n quote_amount?: number;\n lead_time_weeks?: number;\n status?: string;\n notes?: string;\n },\n) {\n const supplierId = await findOrCreateSupplier(v.name, {\n contact_person: v.contact_person,\n phone: v.phone,\n email: v.email,\n address: v.address,\n });\n await sqlite.execute({\n sql: `INSERT INTO vendors (package_id, supplier_id, name, contact_person, phone, email, address, quote_amount, lead_time_weeks, status, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n packageId,\n supplierId,\n v.name,\n v.contact_person ?? null,\n v.phone ?? null,\n v.email ?? null,\n v.address ?? null,\n v.quote_amount ?? null,\n v.lead_time_weeks ?? null,\n v.status ?? \"In Discussion\",\n v.notes ?? null,\n ],\n });\n}\n\nexport async function updateVendorFields(id: number, fields: Partial) {\n const keys = Object.keys(fields).filter((k) => (fields as any)[k] !== undefined);\n if (keys.length === 0) return;\n const sets = keys.map((k) => `${k} = ?`).join(\", \");\n const args = keys.map((k) => (fields as any)[k]);\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE vendors SET ${sets}, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n args,\n });\n}\n\nexport async function addDocument(\n vendorId: number,\n doc: { doc_type: string; label?: string; drive_link: string; added_by?: string },\n) {\n await sqlite.execute({\n sql: `INSERT INTO vendor_documents (vendor_id, doc_type, label, drive_link, added_by) VALUES (?, ?, ?, ?, ?)`,\n args: [vendorId, doc.doc_type, doc.label ?? null, doc.drive_link, doc.added_by ?? null],\n });\n}\n\nexport async function getPOsForVendor(vendorId: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM purchase_orders WHERE vendor_id = ? ORDER BY created_at DESC\",\n args: [vendorId],\n });\n return r.rows as unknown as PurchaseOrder[];\n}\n\nexport async function getPO(id: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM purchase_orders WHERE id = ?\",\n args: [id],\n });\n return (r.rows[0] as unknown as PurchaseOrder) ?? null;\n}\n\nexport async function getAllPOs(): Promise {\n const r = await sqlite.execute(\n `SELECT po.*, v.name as vendor_name, v.package_id as package_id,\n p.item as package_item, p.category as package_category\n FROM purchase_orders po\n JOIN vendors v ON v.id = po.vendor_id\n JOIN packages p ON p.id = v.package_id\n ORDER BY po.created_at DESC`,\n );\n return r.rows as unknown as PurchaseOrderWithContext[];\n}\n\nexport async function addPO(\n vendorId: number,\n po: {\n po_number: string;\n po_date?: string;\n amount?: number;\n expected_delivery_date?: string;\n status?: string;\n notes?: string;\n created_by?: string;\n },\n) {\n await sqlite.execute({\n sql: `INSERT INTO purchase_orders (vendor_id, po_number, po_date, amount, expected_delivery_date, status, notes, created_by)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n vendorId,\n po.po_number,\n po.po_date ?? null,\n po.amount ?? null,\n po.expected_delivery_date ?? null,\n po.status ?? \"Issued\",\n po.notes ?? null,\n po.created_by ?? null,\n ],\n });\n}\n\nexport async function updatePOFields(id: number, fields: Partial) {\n const keys = Object.keys(fields).filter((k) => (fields as any)[k] !== undefined);\n if (keys.length === 0) return;\n const sets = keys.map((k) => `${k} = ?`).join(\", \");\n const args = keys.map((k) => (fields as any)[k]);\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE purchase_orders SET ${sets}, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n args,\n });\n}\n\n// ---- Categories / Sub-categories master ----\n\nexport async function getAllCategories(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM categories ORDER BY sort_order, name\");\n return r.rows as unknown as Category[];\n}\n\nexport async function getAllSubCategories(): Promise {\n const r = await sqlite.execute(\n `SELECT sc.*, c.name as category_name FROM sub_categories sc\n JOIN categories c ON c.id = sc.category_id\n ORDER BY c.name, sc.name`,\n );\n return r.rows as unknown as SubCategoryWithCategory[];\n}\n\nexport async function addCategory(name: string): Promise {\n const r = await sqlite.execute({\n sql: \"INSERT INTO categories (name) VALUES (?)\",\n args: [name],\n });\n return Number(r.lastInsertRowid);\n}\n\nexport async function renameCategory(id: number, newName: string) {\n const existing = await sqlite.execute({ sql: \"SELECT name FROM categories WHERE id = ?\", args: [id] });\n const oldName = (existing.rows[0] as any)?.name;\n if (oldName === undefined) throw new Error(\"Category not found\");\n await sqlite.batch([\n { sql: \"UPDATE categories SET name = ? WHERE id = ?\", args: [newName, id] },\n { sql: \"UPDATE packages SET category = ? WHERE category = ?\", args: [newName, oldName] },\n ]);\n}\n\nexport async function deleteCategory(id: number) {\n const cat = await sqlite.execute({ sql: \"SELECT name FROM categories WHERE id = ?\", args: [id] });\n const name = (cat.rows[0] as any)?.name;\n if (name === undefined) throw new Error(\"Category not found\");\n const inUse = await sqlite.execute({ sql: \"SELECT COUNT(*) as c FROM packages WHERE category = ?\", args: [name] });\n if (Number((inUse.rows[0] as any).c) > 0) {\n throw new Error(`Cannot delete \"${name}\" — ${(inUse.rows[0] as any).c} package(s) still use it. Reassign them first.`);\n }\n await sqlite.execute({ sql: \"DELETE FROM categories WHERE id = ?\", args: [id] });\n}\n\nexport async function addSubCategory(categoryId: number, name: string): Promise {\n const r = await sqlite.execute({\n sql: \"INSERT INTO sub_categories (category_id, name) VALUES (?, ?)\",\n args: [categoryId, name],\n });\n return Number(r.lastInsertRowid);\n}\n\nexport async function renameSubCategory(id: number, newName: string) {\n const existing = await sqlite.execute({\n sql: `SELECT sc.name, c.name as category_name FROM sub_categories sc\n JOIN categories c ON c.id = sc.category_id WHERE sc.id = ?`,\n args: [id],\n });\n const row = existing.rows[0] as any;\n if (!row) throw new Error(\"Sub-category not found\");\n await sqlite.batch([\n { sql: \"UPDATE sub_categories SET name = ? WHERE id = ?\", args: [newName, id] },\n {\n sql: \"UPDATE packages SET sub_category = ? WHERE category = ? AND sub_category = ?\",\n args: [newName, row.category_name, row.name],\n },\n ]);\n}\n\nexport async function deleteSubCategory(id: number) {\n const existing = await sqlite.execute({\n sql: `SELECT sc.name, c.name as category_name FROM sub_categories sc\n JOIN categories c ON c.id = sc.category_id WHERE sc.id = ?`,\n args: [id],\n });\n const row = existing.rows[0] as any;\n if (!row) throw new Error(\"Sub-category not found\");\n const inUse = await sqlite.execute({\n sql: \"SELECT COUNT(*) as c FROM packages WHERE category = ? AND sub_category = ?\",\n args: [row.category_name, row.name],\n });\n if (Number((inUse.rows[0] as any).c) > 0) {\n throw new Error(`Cannot delete \"${row.name}\" — ${(inUse.rows[0] as any).c} package(s) still use it. Reassign them first.`);\n }\n await sqlite.execute({ sql: \"DELETE FROM sub_categories WHERE id = ?\", args: [id] });\n}\n\nexport async function deletePackage(id: number) {\n await sqlite.execute({ sql: \"DELETE FROM packages WHERE id = ?\", args: [id] });\n}\n\n// ---- Suppliers master ----\n\nexport async function getAllSuppliers(): Promise {\n const r = await sqlite.execute(\n `SELECT s.*, COUNT(DISTINCT v.package_id) as package_count\n FROM suppliers s\n LEFT JOIN vendors v ON v.supplier_id = s.id\n GROUP BY s.id\n ORDER BY s.name`,\n );\n return r.rows as unknown as SupplierWithStats[];\n}\n\nexport async function getSupplier(id: number): Promise {\n const r = await sqlite.execute({ sql: \"SELECT * FROM suppliers WHERE id = ?\", args: [id] });\n return (r.rows[0] as unknown as Supplier) ?? null;\n}\n\nexport async function getPackagesForSupplier(\n supplierId: number,\n): Promise<{ vendor_id: number; package_id: number; package_item: string; package_category: string; status: string | null }[]> {\n const r = await sqlite.execute({\n sql: `SELECT v.id as vendor_id, p.id as package_id, p.item as package_item, p.category as package_category, v.status\n FROM vendors v JOIN packages p ON p.id = v.package_id\n WHERE v.supplier_id = ? ORDER BY p.category, p.item`,\n args: [supplierId],\n });\n return r.rows as unknown as any[];\n}\n\n// Case-insensitive find-or-create, so adding a vendor with a name that already\n// exists as a supplier reuses it instead of creating a duplicate.\nexport async function findOrCreateSupplier(\n name: string,\n details?: { contact_person?: string; phone?: string; email?: string; address?: string; gst_number?: string; notes?: string },\n): Promise {\n const trimmed = name.trim();\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM suppliers WHERE name = ? COLLATE NOCASE\",\n args: [trimmed],\n });\n if (existing.rows.length > 0) {\n return Number((existing.rows[0] as any).id);\n }\n const r = await sqlite.execute({\n sql: `INSERT INTO suppliers (name, contact_person, phone, email, address, gst_number, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n trimmed,\n details?.contact_person ?? null,\n details?.phone ?? null,\n details?.email ?? null,\n details?.address ?? null,\n details?.gst_number ?? null,\n details?.notes ?? null,\n ],\n });\n return Number(r.lastInsertRowid);\n}\n\nexport async function addSupplier(s: {\n name: string;\n contact_person?: string;\n phone?: string;\n email?: string;\n address?: string;\n gst_number?: string;\n notes?: string;\n}): Promise {\n return findOrCreateSupplier(s.name, s);\n}\n\nexport async function updateSupplierFields(id: number, fields: Partial) {\n const keys = Object.keys(fields).filter((k) => (fields as any)[k] !== undefined);\n if (keys.length === 0) return;\n const sets = keys.map((k) => `${k} = ?`).join(\", \");\n const args = keys.map((k) => (fields as any)[k]);\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE suppliers SET ${sets}, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n args,\n });\n}\n\nexport async function assignSupplierToPackage(\n packageId: number,\n supplierId: number,\n extra?: { quote_amount?: number; lead_time_weeks?: number; status?: string; notes?: string },\n) {\n const supplier = await getSupplier(supplierId);\n if (!supplier) throw new Error(\"Supplier not found\");\n await sqlite.execute({\n sql: `INSERT INTO vendors (package_id, supplier_id, name, contact_person, phone, email, address, quote_amount, lead_time_weeks, status, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n packageId,\n supplierId,\n supplier.name,\n supplier.contact_person,\n supplier.phone,\n supplier.email,\n supplier.address,\n extra?.quote_amount ?? null,\n extra?.lead_time_weeks ?? null,\n extra?.status ?? \"In Discussion\",\n extra?.notes ?? null,\n ],\n });\n}\n\nexport async function deleteSupplier(id: number) {\n const inUse = await sqlite.execute({ sql: \"SELECT COUNT(*) as c FROM vendors WHERE supplier_id = ?\", args: [id] });\n if (Number((inUse.rows[0] as any).c) > 0) {\n throw new Error(`Cannot delete this supplier — it's still assigned to ${(inUse.rows[0] as any).c} package(s). Remove those assignments first.`);\n }\n await sqlite.execute({ sql: \"DELETE FROM suppliers WHERE id = ?\", args: [id] });\n}\n",[159],"3b562dd5-01c1-4c08-92dc-45d1074f972e","constants.ts","bbb98582-805a-11f1-8010-1607ee4eb77e",17,["D",1784130547748],"export const PACKAGE_STATUSES = [\n \"Not Started\",\n \"RFQ Floated / Enquiry Sent\",\n \"In Discussion / Profile Received\",\n \"Quote(s) Received\",\n \"Technical Evaluation Pending\",\n \"Order Placed\",\n \"Completed\",\n \"Internal (BM Team)\",\n];\n\nexport const VENDOR_STATUSES = [\n \"In Discussion\",\n \"Quote Received\",\n \"Technical Evaluation\",\n \"Selected\",\n \"Rejected\",\n \"Order Placed\",\n];\n\nexport const PO_STATUSES = [\n \"Issued\",\n \"Acknowledged\",\n \"In Production\",\n \"Dispatched\",\n \"Delivered\",\n \"Cancelled\",\n];\n\nexport const DOC_TYPES = [\n \"Quote\",\n \"Catalog / Spec Sheet\",\n \"Company Profile / Brochure\",\n \"Drawing\",\n \"Correspondence\",\n \"Other\",\n];\n\n// Team allowed to log in. To add someone, add their exact email below,\n// or add their whole company domain to ALLOWED_DOMAINS.\nexport const ALLOWED_EMAILS = new Set([\n \"gaurangvshah@gmail.com\",\n \"gaurangvshah@littlesilver.in\",\n]);\n\nexport const ALLOWED_DOMAINS = [\"littlesilver.in\", \"bulkmro.com\"];\n\nexport function isAllowed(email: string | null | undefined): boolean {\n if (!email) return false;\n const lower = email.toLowerCase();\n if (ALLOWED_EMAILS.has(lower)) return true;\n const domain = lower.split(\"@\")[1];\n return !!domain && ALLOWED_DOMAINS.includes(domain);\n}\n\nexport function statusColor(status: string): string {\n switch (status) {\n case \"Completed\":\n return \"bg-green-100 text-green-800 border-green-300\";\n case \"Order Placed\":\n return \"bg-emerald-100 text-emerald-800 border-emerald-300\";\n case \"Technical Evaluation Pending\":\n return \"bg-purple-100 text-purple-800 border-purple-300\";\n case \"Quote(s) Received\":\n case \"Quote Received\":\n return \"bg-blue-100 text-blue-800 border-blue-300\";\n case \"In Discussion / Profile Received\":\n case \"In Discussion\":\n return \"bg-amber-100 text-amber-800 border-amber-300\";\n case \"RFQ Floated / Enquiry Sent\":\n return \"bg-orange-100 text-orange-800 border-orange-300\";\n case \"Selected\":\n return \"bg-teal-100 text-teal-800 border-teal-300\";\n case \"Rejected\":\n return \"bg-red-100 text-red-800 border-red-300\";\n case \"Internal (BM Team)\":\n return \"bg-slate-100 text-slate-800 border-slate-300\";\n case \"Issued\":\n return \"bg-cyan-100 text-cyan-800 border-cyan-300\";\n case \"Acknowledged\":\n return \"bg-blue-100 text-blue-800 border-blue-300\";\n case \"In Production\":\n return \"bg-amber-100 text-amber-800 border-amber-300\";\n case \"Dispatched\":\n return \"bg-purple-100 text-purple-800 border-purple-300\";\n case \"Delivered\":\n return \"bg-green-100 text-green-800 border-green-300\";\n case \"Cancelled\":\n return \"bg-red-100 text-red-800 border-red-300\";\n default:\n return \"bg-gray-100 text-gray-700 border-gray-300\";\n }\n}\n",[167],"pulls","branches",1,"forks","envVars",{"_181":63,"_183":63},"connections",{"_181":63,"_182":63},"count","unfilledCount","emptyCount",{"_43":166,"_32":167,"_30":168,"_138":-5,"_41":42,"_40":169,"_140":25,"_38":202,"_13":148,"_33":34,"_35":171,"_24":25,"_144":-5,"_190":203,"_27":204},{"_43":158,"_32":159,"_30":160,"_138":-5,"_41":42,"_40":161,"_140":25,"_38":199,"_13":163,"_33":34,"_35":164,"_24":25,"_144":-5,"_190":200,"_27":201},{"_43":150,"_32":151,"_30":57,"_138":-5,"_41":42,"_40":152,"_140":25,"_38":196,"_13":154,"_33":155,"_35":156,"_24":25,"_144":-5,"_190":197,"_27":198},{"_43":146,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":193,"_13":148,"_33":34,"_35":37,"_24":25,"_144":-5,"_190":194,"_27":195},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":189,"_13":142,"_33":34,"_35":143,"_24":25,"_144":-5,"_190":191,"_27":192},["D",1784139123145],"children",[],[136],["D",1784139412314],[],[28],["D",1784139155111],[],[151],["D",1784139054628],[],[159],["D",1784130547748],[],[167],["D",1784125734204],["D",1789559472742],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_127":243,"_244":245,"_246":247,"_248":25,"_249":25,"_250":25,"_251":59,"_252":-5,"_253":-7,"_254":-7,"_255":63,"_256":25,"_257":25,"_258":-5,"_259":25,"_260":25,"_261":25,"_262":-5},"ENV",{"_214":215,"_216":217,"_218":90,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242},"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"]

Diff · v62