[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_223":224,"_225":226},"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",69,"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","views.tsx","latestPath","fileId","f1184d80-805a-11f1-b93f-1607ee4eb77e","name","fileType","script","content","/** @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","/** @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

{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}

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 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.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 Edit / line items / PDF\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

Categories & Sub-categories

\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 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","createdAt",["D",1784139671562],"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":218,"_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":219,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":220,"_84":221,"_86":222,"_88":25},"tree",[193,194,195,196,197,198],"files",[193,194,195,196,197,198],"counts",{"_182":63,"_183":184,"_185":63,"_186":187,"_188":189},"contents",[130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":174,"_32":175,"_30":176,"_137":-5,"_41":42,"_40":177,"_138":25,"_38":178,"_13":179,"_33":34,"_35":180,"_24":25,"_141":-5,"_27":181},{"_43":166,"_32":167,"_30":168,"_137":-5,"_41":42,"_40":169,"_138":25,"_38":170,"_13":171,"_33":34,"_35":172,"_24":25,"_141":-5,"_27":173},{"_43":158,"_32":159,"_30":57,"_137":-5,"_41":42,"_40":160,"_138":25,"_38":161,"_13":162,"_33":163,"_35":164,"_24":25,"_141":-5,"_27":165},{"_43":151,"_32":152,"_30":153,"_137":-5,"_41":42,"_40":154,"_138":25,"_38":155,"_13":63,"_33":34,"_35":156,"_24":25,"_141":-5,"_27":157},{"_43":143,"_32":144,"_30":145,"_137":-5,"_41":42,"_40":146,"_138":25,"_38":147,"_13":148,"_33":34,"_35":149,"_24":25,"_141":-5,"_27":150},{"_43":136,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_138":25,"_38":139,"_13":140,"_33":34,"_35":37,"_24":25,"_141":-5,"_27":142},"3aae2092-c9be-49ae-9e3e-1a7d71ce589c","parentId","latest",["D",1784139671562],25,"label",[28],"8a1e912e-d401-4dbf-8a60-84d6e95d19d0","schema.ts","c42d980c-805a-11f1-8847-1607ee4eb77e",62,["D",1784139412314],4,"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",[144],"e6961d72-e44f-4ff2-9f1b-09ffa2f639f4","pdf.ts","e279c67c-8079-11f1-8f05-1607ee4eb77e",68,["D",1784139640415],"import { PDFDocument, rgb, StandardFonts } from \"npm:pdf-lib@1.17.1\";\nimport type { PDFFont } from \"npm:pdf-lib@1.17.1\";\nimport { SSI_LETTERHEAD } from \"./constants.ts\";\nimport type { POFull } from \"./db.ts\";\n\nconst PAGE_W = 595.28;\nconst PAGE_H = 841.89;\nconst MARGIN = 36;\nconst CONTENT_W = PAGE_W - MARGIN * 2;\nconst BLUE = rgb(0.11, 0.25, 0.53);\nconst GRAY = rgb(0.4, 0.4, 0.4);\nconst LIGHT_GRAY = rgb(0.93, 0.93, 0.93);\nconst BLACK = rgb(0.05, 0.05, 0.05);\nconst LINE = rgb(0.6, 0.6, 0.6);\n\nfunction fmtMoney(n: number | null | undefined): string {\n return (n ?? 0).toLocaleString(\"en-IN\", { minimumFractionDigits: 2, maximumFractionDigits: 2 });\n}\n\nfunction wrapText(text: string, font: PDFFont, size: number, maxWidth: number): string[] {\n const paragraphs = (text ?? \"\").split(\"\\n\");\n const lines: string[] = [];\n for (const para of paragraphs) {\n if (para.trim() === \"\") {\n lines.push(\"\");\n continue;\n }\n const words = para.split(/\\s+/);\n let current = \"\";\n for (const word of words) {\n const candidate = current ? `${current} ${word}` : word;\n if (font.widthOfTextAtSize(candidate, size) > maxWidth && current) {\n lines.push(current);\n current = word;\n } else {\n current = candidate;\n }\n }\n if (current) lines.push(current);\n }\n return lines;\n}\n\nexport async function generatePOPdf(full: POFull): Promise {\n const { po, lineItems, vendor, supplier, pkg } = full;\n const pdfDoc = await PDFDocument.create();\n const font = await pdfDoc.embedFont(StandardFonts.Helvetica);\n const bold = await pdfDoc.embedFont(StandardFonts.HelveticaBold);\n const italic = await pdfDoc.embedFont(StandardFonts.HelveticaOblique);\n\n let page = pdfDoc.addPage([PAGE_W, PAGE_H]);\n let y = PAGE_H - MARGIN;\n\n function newPage() {\n page = pdfDoc.addPage([PAGE_W, PAGE_H]);\n y = PAGE_H - MARGIN;\n }\n\n function ensureRoom(h: number) {\n if (y - h < MARGIN + 20) newPage();\n }\n\n function text(str: string, x: number, size: number, f: PDFFont = font, color = BLACK) {\n page.drawText(str || \"\", { x, y, size, font: f, color });\n }\n\n function textRightAligned(str: string, rightX: number, size: number, f: PDFFont = font, color = BLACK) {\n const w = f.widthOfTextAtSize(str, size);\n page.drawText(str || \"\", { x: rightX - w, y, size, font: f, color });\n }\n\n function hr(color = LINE, thickness = 0.75) {\n page.drawLine({ start: { x: MARGIN, y }, end: { x: PAGE_W - MARGIN, y }, thickness, color });\n }\n\n // ---- Letterhead ----\n text(SSI_LETTERHEAD.name, MARGIN, 17, bold, BLUE);\n textRightAligned(`Purchase Order ${po.po_number}`, PAGE_W - MARGIN, 13, bold, BLUE);\n y -= 13;\n text(SSI_LETTERHEAD.tagline, MARGIN, 8, italic, GRAY);\n y -= 11;\n text(SSI_LETTERHEAD.address, MARGIN, 7.5, font, GRAY);\n y -= 10;\n text(`${SSI_LETTERHEAD.tel} | ${SSI_LETTERHEAD.gst}`, MARGIN, 7.5, font, GRAY);\n y -= 10;\n hr(BLUE, 1.25);\n y -= 16;\n\n // ---- Meta grid (2 columns x 4 rows) ----\n const metaRows: [string, string, string, string][] = [\n [\"SSI Contact Person\", po.ssi_contact_person ?? \"—\", \"SSI Contact #\", po.ssi_contact_phone ?? \"—\"],\n [\"Date of Inquiry\", po.date_of_inquiry ?? \"—\", \"Validity\", po.validity ?? \"—\"],\n [\"Date of Purchase Order\", po.po_date ?? \"—\", \"Inquiry Reference\", po.inquiry_reference ?? \"—\"],\n [\"Incoterms\", po.incoterms ?? \"—\", \"Payment Terms\", po.payment_terms ?? \"—\"],\n ];\n const metaRowH = 16;\n ensureRoom(metaRowH * metaRows.length + 8);\n const colMidX = MARGIN + CONTENT_W / 2;\n page.drawRectangle({\n x: MARGIN,\n y: y - metaRowH * metaRows.length,\n width: CONTENT_W,\n height: metaRowH * metaRows.length,\n borderColor: LINE,\n borderWidth: 0.75,\n });\n for (let i = 0; i < metaRows.length; i++) {\n const rowY = y - i * metaRowH;\n if (i > 0) {\n page.drawLine({ start: { x: MARGIN, y: rowY }, end: { x: PAGE_W - MARGIN, y: rowY }, thickness: 0.5, color: LINE });\n }\n const cellY = rowY - 11;\n const [l1, v1, l2, v2] = metaRows[i];\n page.drawText(l1, { x: MARGIN + 5, y: cellY, size: 7.5, font: bold, color: BLACK });\n page.drawText(v1, { x: MARGIN + 130, y: cellY, size: 8, font, color: BLACK });\n page.drawLine({ start: { x: colMidX, y: rowY }, end: { x: colMidX, y: rowY - metaRowH }, thickness: 0.5, color: LINE });\n page.drawText(l2, { x: colMidX + 5, y: cellY, size: 7.5, font: bold, color: BLACK });\n page.drawText(v2, { x: colMidX + 110, y: cellY, size: 8, font, color: BLACK });\n }\n y -= metaRowH * metaRows.length + 14;\n\n // ---- Supplier / Customer blocks ----\n function twoColBlock(\n leftLabel: string,\n leftText: string,\n rightLabel: string,\n rightText: string,\n footnote?: string | null,\n ) {\n const colW = CONTENT_W / 2 - 6;\n const leftLines = wrapText(leftText, font, 8, colW - 10);\n const rightLines = wrapText(rightText, font, 8, colW - 10);\n const bodyLines = Math.max(leftLines.length, rightLines.length, 1);\n const blockH = 16 + bodyLines * 10 + 6;\n ensureRoom(blockH + 20);\n const top = y;\n page.drawRectangle({ x: MARGIN, y: top - blockH, width: CONTENT_W, height: blockH, borderColor: LINE, borderWidth: 0.75 });\n page.drawLine({ start: { x: colMidX, y: top }, end: { x: colMidX, y: top - blockH }, thickness: 0.5, color: LINE });\n page.drawLine({ start: { x: MARGIN, y: top - 15 }, end: { x: PAGE_W - MARGIN, y: top - 15 }, thickness: 0.5, color: LINE });\n page.drawRectangle({ x: MARGIN, y: top - 15, width: CONTENT_W, height: 15, color: LIGHT_GRAY });\n page.drawText(leftLabel, { x: MARGIN + 5, y: top - 11, size: 8, font: bold });\n page.drawText(rightLabel, { x: colMidX + 5, y: top - 11, size: 8, font: bold });\n leftLines.forEach((line, i) => {\n page.drawText(line, { x: MARGIN + 5, y: top - 15 - 10 - i * 10, size: 8, font });\n });\n rightLines.forEach((line, i) => {\n page.drawText(line, { x: colMidX + 5, y: top - 15 - 10 - i * 10, size: 8, font });\n });\n y = top - blockH - 8;\n if (footnote) {\n const noteLines = wrapText(footnote, italic, 7.5, CONTENT_W);\n ensureRoom(noteLines.length * 10 + 4);\n noteLines.forEach((line) => {\n text(line, MARGIN, 7.5, italic, GRAY);\n y -= 10;\n });\n y -= 4;\n }\n }\n\n const supplierName = supplier?.name ?? vendor?.name ?? \"—\";\n const supplierBillFrom = po.supplier_bill_from || [vendor?.contact_person, supplierName, supplier?.address].filter(Boolean).join(\"\\n\");\n const supplierShipFrom = po.supplier_ship_from || supplierBillFrom;\n twoColBlock(\"Supplier - Bill from :\", supplierBillFrom, \"Supplier - Ship from :\", supplierShipFrom);\n twoColBlock(\n \"Customer - Bill to :\",\n po.customer_bill_to ?? \"—\",\n \"Customer - Ship to :\",\n po.customer_ship_to ?? \"—\",\n po.customer_note,\n );\n\n // ---- Line items table ----\n const cols = [\n { key: \"sr\", label: \"Sr.\\nNo.\", w: 22 },\n { key: \"desc\", label: \"Description\", w: 148 },\n { key: \"lead\", label: \"Lead Time\", w: 58 },\n { key: \"uom\", label: \"UOM\", w: 32 },\n { key: \"qty\", label: \"Qty\", w: 28 },\n { key: \"unit\", label: \"Unit Price\\n(INR)\", w: 68 },\n { key: \"total\", label: \"Total Price\\n(INR)\", w: 68 },\n { key: \"remarks\", label: \"Remarks\", w: 0 },\n ];\n cols[cols.length - 1].w = CONTENT_W - cols.slice(0, -1).reduce((s, c) => s + c.w, 0);\n const colX: number[] = [];\n {\n let x = MARGIN;\n for (const c of cols) {\n colX.push(x);\n x += c.w;\n }\n }\n\n function drawTableHeader() {\n ensureRoom(24);\n const top = y;\n page.drawRectangle({ x: MARGIN, y: top - 20, width: CONTENT_W, height: 20, color: LIGHT_GRAY });\n cols.forEach((c, i) => {\n const lines = c.label.split(\"\\n\");\n lines.forEach((line, li) => {\n page.drawText(line, { x: colX[i] + 3, y: top - 9 - li * 9, size: 7, font: bold });\n });\n });\n page.drawRectangle({ x: MARGIN, y: top - 20, width: CONTENT_W, height: 20, borderColor: LINE, borderWidth: 0.75 });\n colX.slice(1).forEach((cx) => {\n page.drawLine({ start: { x: cx, y: top }, end: { x: cx, y: top - 20 }, thickness: 0.5, color: LINE });\n });\n y = top - 20;\n }\n\n drawTableHeader();\n\n let grandTotal = 0;\n lineItems.forEach((item, idx) => {\n const total = item.qty * item.unit_price;\n grandTotal += total;\n const descLines = [item.description, item.hsn_code ? `HSN: ${item.hsn_code}` : \"\"].filter(Boolean);\n const wrappedDesc = descLines.flatMap((l) => wrapText(l, font, 7.5, cols[1].w - 6));\n const wrappedRemarks = wrapText(item.remarks ?? \"\", font, 7, cols[7].w - 6);\n const rowLines = Math.max(wrappedDesc.length, wrappedRemarks.length, 1);\n const rowH = rowLines * 9 + 8;\n ensureRoom(rowH + 4);\n if (y === PAGE_H - MARGIN) drawTableHeader();\n const top = y;\n const cellY = top - 10;\n page.drawText(String(idx + 1), { x: colX[0] + 3, y: cellY, size: 7.5, font });\n wrappedDesc.forEach((line, li) => page.drawText(line, { x: colX[1] + 3, y: cellY - li * 9, size: 7.5, font }));\n const cell = (str: string, x: number) => page.drawText(str, { x: x + 3, y: cellY, size: 7.5, font });\n cell(item.lead_time ?? \"\", colX[2]);\n cell(item.uom ?? \"\", colX[3]);\n cell(String(item.qty), colX[4]);\n cell(fmtMoney(item.unit_price), colX[5]);\n cell(fmtMoney(total), colX[6]);\n wrappedRemarks.forEach((line, li) => page.drawText(line, { x: colX[7] + 3, y: cellY - li * 9, size: 7, font }));\n page.drawRectangle({ x: MARGIN, y: top - rowH, width: CONTENT_W, height: rowH, borderColor: LINE, borderWidth: 0.5 });\n colX.slice(1).forEach((cx) => {\n page.drawLine({ start: { x: cx, y: top }, end: { x: cx, y: top - rowH }, thickness: 0.5, color: LINE });\n });\n y = top - rowH;\n });\n\n if (lineItems.length === 0) {\n ensureRoom(20);\n page.drawRectangle({ x: MARGIN, y: y - 18, width: CONTENT_W, height: 18, borderColor: LINE, borderWidth: 0.5 });\n page.drawText(\"No line items added yet.\", { x: MARGIN + 4, y: y - 12, size: 7.5, font, color: GRAY });\n y -= 18;\n }\n\n ensureRoom(22);\n page.drawRectangle({ x: MARGIN, y: y - 18, width: CONTENT_W, height: 18, color: LIGHT_GRAY, borderColor: LINE, borderWidth: 0.75 });\n page.drawText(\"TOTAL (INR)\", { x: MARGIN + 5, y: y - 12, size: 8, font: bold });\n const totalStr = fmtMoney(grandTotal);\n page.drawText(totalStr, {\n x: colX[6] + cols[6].w - bold.widthOfTextAtSize(totalStr, 8) - 5,\n y: y - 12,\n size: 8,\n font: bold,\n });\n y -= 26;\n\n // ---- Terms sections ----\n function sectionBlock(title: string, body: string | null) {\n ensureRoom(24);\n text(title, MARGIN, 9.5, bold, BLUE);\n y -= 6;\n hr(LINE, 0.5);\n y -= 12;\n const lines = wrapText(body || \"—\", font, 8, CONTENT_W);\n for (const line of lines) {\n ensureRoom(11);\n text(line, MARGIN, 8, font);\n y -= 11;\n }\n y -= 10;\n }\n\n sectionBlock(\"Commercial Terms and Conditions\", po.terms_text);\n sectionBlock(\"Technical Specifications\", po.tech_specs_text);\n sectionBlock(\"Annexures\", po.annexures_text);\n\n if (pkg) {\n ensureRoom(14);\n text(`Package: ${pkg.category}${pkg.sub_category ? \" / \" + pkg.sub_category : \"\"} — ${pkg.item}`, MARGIN, 7, italic, GRAY);\n y -= 14;\n }\n\n ensureRoom(14);\n text(\"This is a Computer Generated Purchase Order.\", MARGIN, 7.5, italic, GRAY);\n\n return pdfDoc.save();\n}\n",[152],"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",[159],"76cb7d01-5408-4e88-9049-a2cc9c6759d7","db.ts","d25420ae-805a-11f1-8f16-1607ee4eb77e",67,["D",1784139520203],14,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport {\n DEFAULT_CUSTOMER_BILL_TO,\n DEFAULT_CUSTOMER_NOTE,\n DEFAULT_CUSTOMER_SHIP_TO,\n DEFAULT_PO_ANNEXURES,\n DEFAULT_PO_TECH_SPECS,\n DEFAULT_PO_TERMS,\n DEFAULT_SSI_CONTACT_PERSON,\n DEFAULT_SSI_CONTACT_PHONE,\n} from \"./constants.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 ssi_contact_person: string | null;\n ssi_contact_phone: string | null;\n date_of_inquiry: string | null;\n validity: string | null;\n inquiry_reference: string | null;\n incoterms: string | null;\n payment_terms: string | null;\n supplier_bill_from: string | null;\n supplier_ship_from: string | null;\n customer_bill_to: string | null;\n customer_ship_to: string | null;\n customer_note: string | null;\n terms_text: string | null;\n tech_specs_text: string | null;\n annexures_text: string | null;\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 interface POLineItem {\n id: number;\n po_id: number;\n sort_order: number;\n description: string;\n hsn_code: string | null;\n lead_time: string | null;\n uom: string | null;\n qty: number;\n unit_price: number;\n remarks: string | null;\n created_at: 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\n// Atomically claims the next number in a purely-numeric document series\n// (e.g. \"PO\" -> 101001, 101002, ...). Each series is configured once in the\n// doc_sequences table; future series (RFQ, invoices, etc.) can be added there\n// the same way.\nexport async function nextDocNumber(series: string): Promise {\n const r = await sqlite.execute({\n sql: \"UPDATE doc_sequences SET next_value = next_value + 1 WHERE series = ? RETURNING next_value - 1 as issued\",\n args: [series],\n });\n if (r.rows.length === 0) throw new Error(`No document series configured for \"${series}\"`);\n return String((r.rows[0] as any).issued);\n}\n\nexport async function addPO(\n vendorId: number,\n po: {\n po_date?: string;\n amount?: number;\n expected_delivery_date?: string;\n status?: string;\n notes?: string;\n created_by?: string;\n },\n): Promise {\n const poNumber = await nextDocNumber(\"PO\");\n const vendor = await getVendor(vendorId);\n const supplier = vendor?.supplier_id ? await getSupplier(vendor.supplier_id) : null;\n const supplierBlock = supplier\n ? [supplier.name, supplier.address].filter(Boolean).join(\"\\n\")\n : vendor?.name ?? null;\n const r = await sqlite.execute({\n sql: `INSERT INTO purchase_orders (\n vendor_id, po_number, po_date, amount, expected_delivery_date, status, notes, created_by,\n ssi_contact_person, ssi_contact_phone, customer_bill_to, customer_ship_to, customer_note,\n supplier_bill_from, supplier_ship_from, terms_text, tech_specs_text, annexures_text\n )\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n vendorId,\n poNumber,\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 DEFAULT_SSI_CONTACT_PERSON,\n DEFAULT_SSI_CONTACT_PHONE,\n DEFAULT_CUSTOMER_BILL_TO,\n DEFAULT_CUSTOMER_SHIP_TO,\n DEFAULT_CUSTOMER_NOTE,\n supplierBlock,\n supplierBlock,\n DEFAULT_PO_TERMS,\n DEFAULT_PO_TECH_SPECS,\n DEFAULT_PO_ANNEXURES,\n ],\n });\n return Number(r.lastInsertRowid);\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\nexport async function getLineItemsForPO(poId: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM po_line_items WHERE po_id = ? ORDER BY sort_order, id\",\n args: [poId],\n });\n return r.rows as unknown as POLineItem[];\n}\n\nexport async function addPOLineItem(\n poId: number,\n item: {\n description: string;\n hsn_code?: string;\n lead_time?: string;\n uom?: string;\n qty?: number;\n unit_price?: number;\n remarks?: string;\n },\n): Promise {\n const existing = await sqlite.execute({\n sql: \"SELECT COALESCE(MAX(sort_order), 0) as m FROM po_line_items WHERE po_id = ?\",\n args: [poId],\n });\n const nextSort = Number((existing.rows[0] as any).m) + 1;\n const r = await sqlite.execute({\n sql: `INSERT INTO po_line_items (po_id, sort_order, description, hsn_code, lead_time, uom, qty, unit_price, remarks)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n poId,\n nextSort,\n item.description,\n item.hsn_code ?? null,\n item.lead_time ?? null,\n item.uom ?? null,\n item.qty ?? 1,\n item.unit_price ?? 0,\n item.remarks ?? null,\n ],\n });\n await syncPOAmountFromLineItems(poId);\n return Number(r.lastInsertRowid);\n}\n\nexport async function updatePOLineItem(id: number, fields: Partial) {\n const keys = Object.keys(fields).filter((k) => (fields as any)[k] !== undefined && k !== \"id\" && k !== \"po_id\");\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({ sql: `UPDATE po_line_items SET ${sets} WHERE id = ?`, args });\n const row = await sqlite.execute({ sql: \"SELECT po_id FROM po_line_items WHERE id = ?\", args: [id] });\n if (row.rows[0]) await syncPOAmountFromLineItems(Number((row.rows[0] as any).po_id));\n}\n\nexport async function deletePOLineItem(id: number) {\n const row = await sqlite.execute({ sql: \"SELECT po_id FROM po_line_items WHERE id = ?\", args: [id] });\n await sqlite.execute({ sql: \"DELETE FROM po_line_items WHERE id = ?\", args: [id] });\n if (row.rows[0]) await syncPOAmountFromLineItems(Number((row.rows[0] as any).po_id));\n}\n\n// Keeps purchase_orders.amount as the sum of its line items, so the PO list/\n// dashboard totals stay correct without anyone having to edit amount by hand.\nasync function syncPOAmountFromLineItems(poId: number) {\n const r = await sqlite.execute({\n sql: \"SELECT COALESCE(SUM(qty * unit_price), 0) as total FROM po_line_items WHERE po_id = ?\",\n args: [poId],\n });\n const total = Number((r.rows[0] as any).total);\n await sqlite.execute({ sql: \"UPDATE purchase_orders SET amount = ? WHERE id = ?\", args: [total, poId] });\n}\n\nexport interface POFull {\n po: PurchaseOrder;\n lineItems: POLineItem[];\n vendor: Vendor | null;\n supplier: Supplier | null;\n pkg: Package | null;\n}\n\nexport async function getPOFull(id: number): Promise {\n const po = await getPO(id);\n if (!po) return null;\n const [lineItems, vendor] = await Promise.all([getLineItemsForPO(id), getVendor(po.vendor_id)]);\n const supplier = vendor?.supplier_id ? await getSupplier(vendor.supplier_id) : null;\n const pkg = vendor ? await getPackage(vendor.package_id) : null;\n return { po, lineItems, vendor, supplier, pkg };\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",[167],"86428382-b0b9-4b50-b11c-b26d4e9e081b","constants.ts","bbb98582-805a-11f1-8010-1607ee4eb77e",63,["D",1784139470338],5,"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// ---- PO defaults (prefilled when a new PO is created; all editable per-PO) ----\n\nexport const SSI_LETTERHEAD = {\n name: \"Survival Systems India\",\n tagline: \"(a Division of Littlesilver Software (I) Pvt. Ltd.)\",\n address: \"4th Floor, Sterling Centre, Dr. Annie Besant Road, Worli, Mumbai, Maharashtra, 400018\",\n tel: \"+91 22 2497 6868 / 69\",\n gst: \"GST Maharashtra - 27AAACL5309G1ZP\",\n};\n\nexport const DEFAULT_SSI_CONTACT_PERSON = \"Gaurang Shah\";\nexport const DEFAULT_SSI_CONTACT_PHONE = \"+91 98200 56538\";\n\nexport const DEFAULT_CUSTOMER_BILL_TO =\n \"Survival Systems India (a Division of Littlesilver Software (I) Pvt. Ltd.)\\n\" +\n \"4th Floor, Sterling Centre, Dr. Annie Besant Road, Worli, Mumbai, Maharashtra, 400018\\n\" +\n \"GST Maharashtra - 27AAACL5309G1ZP\";\n\nexport const DEFAULT_CUSTOMER_SHIP_TO = \"AESARTS Goa — HUET and Sea Survival Training Facility\";\n\nexport const DEFAULT_CUSTOMER_NOTE =\n \"Note: Since delivery is in Goa, Customer's Goa address and GST details will be provided at the time of raising the tax invoice.\";\n\nexport const DEFAULT_PO_TERMS = [\n \"All taxes, surcharges, duties etc. except for GST are included\",\n \"All payments to be released within 15 days of bill presentation\",\n \"Warranty period - 9 months post commissioning or 12 months post delivery, whichever is earlier\",\n \"Committed date of delivery is subject to release of the advance payment upon receipt of proforma invoice\",\n \"Time is of the essence and the delivery period is of utmost importance. If there are any delays in the completion of the above mentioned services, each week of delay shall attract a 0.5% Liquidated Damages on the contract value up to a maximum of 5% of the contract value\",\n \"Installation, commissioning and load test are in Supplier's scope unless otherwise mentioned. A subsequent PO will be issued if required\",\n \"Limitation of the supplier's liability: the supplier's liability shall not begin prior to the first actual on-site service visit regarding the equipment. The supplier shall be liable for direct property damages and personal injuries provided that such damage or injury is directly due to the negligence of the supplier. The supplier's aggregate liability for any damages relating to the services and/or main agreement shall be limited to the maximum amount of the contract value in all instances for any one incident or series of incidents, whether arising in contract, tort, product liability, or otherwise. The supplier shall have no liability to the customer and/or to any third party with respect to the services and/or to the main agreement for indirect damages (including but not limited to loss of profits, loss of revenue, and loss of production) or for special, consequential, punitive, exemplary or incidental damages of any kind whether arising in contract, tort, product liability or otherwise, even if the supplier was advised of the possibility of such damages\",\n \"The terms and conditions contained herein constitute the entire agreement between the Supplier and Customer as to the subject matter hereof and supersede all prior oral and written agreements between the Supplier and Customer with respect to the subject matter hereof\",\n].map((t, i) => `${i + 1}. ${t}`).join(\"\\n\");\n\nexport const DEFAULT_PO_TECH_SPECS =\n \"1. Detailed technical specifications as per Supplier's quotation/offer referenced above.\";\n\nexport const DEFAULT_PO_ANNEXURES =\n \"1. Supplier's Offer / Quotation\\n2. Drawing(s)\\n3. Technical Write-up\";\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",[175],"pulls","branches",1,"forks","envVars",{"_190":63,"_192":63},"connections",{"_190":63,"_191":63},"count","unfilledCount","emptyCount",{"_43":174,"_32":175,"_30":176,"_137":-5,"_41":42,"_40":177,"_138":25,"_38":215,"_13":179,"_33":34,"_35":180,"_24":25,"_141":-5,"_200":216,"_27":217},{"_43":166,"_32":167,"_30":168,"_137":-5,"_41":42,"_40":169,"_138":25,"_38":212,"_13":171,"_33":34,"_35":172,"_24":25,"_141":-5,"_200":213,"_27":214},{"_43":158,"_32":159,"_30":57,"_137":-5,"_41":42,"_40":160,"_138":25,"_38":209,"_13":162,"_33":163,"_35":164,"_24":25,"_141":-5,"_200":210,"_27":211},{"_43":151,"_32":152,"_30":153,"_137":-5,"_41":42,"_40":154,"_138":25,"_38":206,"_13":63,"_33":34,"_35":156,"_24":25,"_141":-5,"_200":207,"_27":208},{"_43":143,"_32":144,"_30":145,"_137":-5,"_41":42,"_40":146,"_138":25,"_38":203,"_13":148,"_33":34,"_35":149,"_24":25,"_141":-5,"_200":204,"_27":205},{"_43":136,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_138":25,"_38":199,"_13":140,"_33":34,"_35":37,"_24":25,"_141":-5,"_200":201,"_27":202},["D",1784139671562],"children",[],[28],["D",1784139412314],[],[144],["D",1784139640415],[],[152],["D",1784139155111],[],[159],["D",1784139520203],[],[167],["D",1784139470338],[],[175],["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":256,"_257":258,"_259":260,"_261":25,"_262":25,"_263":25,"_264":59,"_265":-5,"_266":-7,"_267":-7,"_268":63,"_269":25,"_270":25,"_271":-5,"_272":25,"_273":25,"_274":25,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":90,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"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 · v69