[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_246":247,"_248":249},"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",122,"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 POFull,\n POLineItem,\n Product,\n ProductWithSupplier,\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.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 Or upload a completed PO Excel file:\n \n \n Get blank template\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 ProductsView: FC<{\n products: ProductWithSupplier[];\n suppliers: SupplierWithStats[];\n}> = ({ products, suppliers }) => (\n

Products ({products.length})

\n This is the product catalog used for the PO line-item dropdown — pick a product on a PO and its description,\n part no, UOM and unit price fill in automatically. This is placeholder demo data; replace with your real\n catalog whenever you're ready.\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {products.map((p) => (\n \n \n \n ))}\n {products.length === 0 ? (\n \n ) : null}\n \n

Part No	Description	Category	Supplier	UOM	Unit Price (₹)	Delete
\n \n \n \n \n \n \n \n \n \n Delete\n \n \n
No products yet.

\n\n

Add a new product

\n \n

\n);\n\nexport const PODetailView: FC<{ full: POFull; products: ProductWithSupplier[]; warnings?: string[] }> = (\n { full, products, warnings },\n) => {\n const { po, lineItems, vendor, supplier, pkg } = full;\n const total = lineItems.reduce((sum, li) => sum + li.qty * li.unit_price, 0);\n return (\n

\n {warnings && warnings.length > 0 && (\n

Imported, but double-check a few things:

\n )}\n

\n Purchase Orders\n {pkg ? <> / {pkg.item} : null}\n

PO {po.po_number}

\n \n \n Download PDF\n \n

\n\n

Line items ({lineItems.length})

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

\n {lineItems.map((li) => (\n \n ))}\n {lineItems.length === 0 ?

No line items yet — add one below.

: null}\n

\n \n \n

\n\n

Terms & annexures

\n \n

\n\n

PO header

\n Status\n \n

\n SSI Contact Person\n \n

\n SSI Contact #\n \n

\n Date of Inquiry\n \n

\n Validity\n \n

\n Date of Purchase Order\n \n

\n Expected delivery\n \n

\n Inquiry Reference\n \n

\n Incoterms\n \n

\n Payment Terms\n \n

\n Supplier - Bill from\n \n

\n Supplier - Ship from\n \n

\n Customer - Bill to\n \n

\n Customer - Ship to\n \n

\n Customer note\n \n

\n Internal notes\n \n

\n \n

\n {supplier ? (\n

\n Linked supplier: {supplier.name}\n

\n ) : null}\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
\n {po.po_number}\n	\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 POFull,\n POLineItem,\n Product,\n ProductWithSupplier,\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 Or upload a completed PO Excel file:\n \n \n Get blank template\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 ProductsView: FC<{\n products: ProductWithSupplier[];\n suppliers: SupplierWithStats[];\n}> = ({ products, suppliers }) => (\n

Products ({products.length})

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {products.map((p) => (\n \n \n \n ))}\n {products.length === 0 ? (\n \n ) : null}\n \n

Part No	Description	Category	Supplier	UOM	Unit Price (₹)	Delete
\n \n \n \n \n \n \n \n \n \n Delete\n \n \n
No products yet.

\n\n

Add a new product

\n \n

\n {warnings && warnings.length > 0 && (\n

Imported, but double-check a few things:

\n )}\n

\n Purchase Orders\n {pkg ? <> / {pkg.item} : null}\n

PO {po.po_number}

\n \n \n Download PDF\n \n

\n\n

Line items ({lineItems.length})

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

\n {lineItems.map((li) => (\n \n ))}\n {lineItems.length === 0 ?

No line items yet — add one below.

: null}\n

\n \n \n

\n\n

Terms & annexures

\n \n

\n\n

PO header

\n Status\n \n

\n SSI Contact Person\n \n

\n SSI Contact #\n \n

\n Date of Inquiry\n \n

\n Validity\n \n

\n Date of Purchase Order\n \n

\n Expected delivery\n \n

\n Inquiry Reference\n \n

\n Incoterms\n \n

\n Payment Terms\n \n

\n Supplier - Bill from\n \n

\n Supplier - Ship from\n \n

\n Customer - Bill to\n \n

\n Customer - Ship to\n \n

\n Customer note\n \n

\n Internal notes\n \n

\n \n

\n {supplier ? (\n

\n Linked supplier: {supplier.name}\n

\n ) : null}\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
\n {po.po_number}\n	\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",1784169877194],"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":241,"_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":242,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":243,"_84":244,"_86":245,"_88":25},"tree",[208,209,210,211,212,213,214,215],"files",[208,209,210,211,212,213,214,215],"counts",{"_198":63,"_199":165,"_200":63,"_201":202,"_203":204},"contents",[130,131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":191,"_32":192,"_30":193,"_141":-5,"_41":42,"_40":194,"_143":59,"_38":195,"_13":145,"_33":34,"_35":196,"_24":25,"_147":-5,"_27":197},{"_43":183,"_32":184,"_30":185,"_141":-5,"_41":42,"_40":186,"_143":59,"_38":187,"_13":188,"_33":34,"_35":189,"_24":25,"_147":-5,"_27":190},{"_43":176,"_32":177,"_30":178,"_141":-5,"_41":42,"_40":179,"_143":59,"_38":180,"_13":63,"_33":34,"_35":181,"_24":25,"_147":-5,"_27":182},{"_43":168,"_32":169,"_30":57,"_141":-5,"_41":42,"_40":170,"_143":59,"_38":171,"_13":172,"_33":173,"_35":174,"_24":25,"_147":-5,"_27":175},{"_43":160,"_32":161,"_30":162,"_141":-5,"_41":42,"_40":163,"_143":59,"_38":164,"_13":165,"_33":34,"_35":166,"_24":25,"_147":-5,"_27":167},{"_43":153,"_32":154,"_30":155,"_141":-5,"_41":42,"_40":156,"_143":59,"_38":157,"_13":145,"_33":34,"_35":158,"_24":25,"_147":-5,"_27":159},{"_43":149,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":59,"_38":150,"_13":151,"_33":34,"_35":37,"_24":25,"_147":-5,"_27":152},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":59,"_38":144,"_13":145,"_33":34,"_35":146,"_24":25,"_147":-5,"_27":148},"1dbc7696-c3c7-4786-b5fe-f0d42b083a52","xlsx-import.ts","4959b230-807f-11f1-8ddc-1607ee4eb77e","parentId",110,"latest",["D",1784144832916],6,"import * as XLSX from \"npm:xlsx@0.18.5\";\nimport {\n DEFAULT_CUSTOMER_BILL_TO,\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 SSI_LETTERHEAD,\n} from \"./constants.ts\";\n\nexport interface ParsedPOLineItem {\n description: string;\n hsn_code?: string;\n part_no?: string;\n lead_time?: string;\n uom?: string;\n qty: number;\n unit_price: number;\n remarks?: string;\n}\n\nexport interface ParsedPO {\n ssi_contact_person?: string;\n ssi_contact_phone?: string;\n date_of_inquiry?: string;\n validity?: string;\n po_date?: string;\n inquiry_reference?: string;\n incoterms?: string;\n payment_terms?: string;\n supplier_name?: string;\n supplier_bill_from?: string;\n supplier_ship_from?: string;\n customer_bill_to?: string;\n customer_ship_to?: string;\n customer_note?: string;\n lineItems: ParsedPOLineItem[];\n terms_text?: string;\n tech_specs_text?: string;\n annexures_text?: string;\n warnings: string[];\n}\n\ntype Row = any[];\n\nfunction norm(v: unknown): string {\n if (v === null || v === undefined) return \"\";\n if (v instanceof Date) return v.toISOString().slice(0, 10);\n return String(v).trim();\n}\n\nfunction isBlankRow(row: Row | undefined): boolean {\n if (!row) return true;\n return row.every((c) => norm(c) === \"\");\n}\n\nfunction findRow(rows: Row[], colIdx: number, matcher: (s: string) => boolean, from = 0): number {\n for (let i = from; i < rows.length; i++) {\n if (matcher(norm(rows[i]?.[colIdx]))) return i;\n }\n return -1;\n}\n\n// Pulls the first HSN-looking code out of a description block, e.g.\n// \"(HSN CODE 84314990)\" or \"HSN CODE FOR SUPPLY 84314990\".\nfunction extractHsnCode(description: string): string | undefined {\n const m = description.match(/HSN\\s*CODE(?:\\s*FOR\\s*SUPPLY)?\\s*[:\\-]?\\s*(\\d{4,8})/i);\n return m ? m[1] : undefined;\n}\n\n// Numeric cells come back as formatted strings (e.g. \"5,148,649.00\") because\n// sheet_to_json is called with raw:false so dates format correctly — strip\n// thousands separators and currency symbols before parsing.\nfunction parseNum(v: unknown): number {\n if (v === null || v === undefined) return NaN;\n const stripped = String(v).replace(/[^\\d.\\-]/g, \"\");\n return stripped === \"\" ? NaN : Number(stripped);\n}\n\n/**\n * Parses a PO workbook that follows the \"Customer Quote\" style template\n * (the same layout used for SSI's printed/PDF purchase orders): a header\n * meta grid, supplier/customer address blocks, a line-items table, and\n * numbered Commercial Terms / Technical Specifications / Annexures\n * sections. Section positions are found by label search rather than fixed\n * row numbers, so minor spacing differences between exports don't break it.\n */\nexport function parsePOWorkbook(bytes: Uint8Array): ParsedPO {\n const wb = XLSX.read(bytes, { type: \"array\", cellDates: true });\n const sheetName = wb.SheetNames[0];\n const ws = wb.Sheets[sheetName];\n const rows: Row[] = XLSX.utils.sheet_to_json(ws, { header: 1, defval: null, raw: false, dateNF: \"yyyy-mm-dd\" });\n\n const warnings: string[] = [];\n const result: ParsedPO = { lineItems: [], warnings };\n\n // ---- Header meta grid: 4 rows starting at \"SSI Contact Person\" ----\n const metaStart = findRow(rows, 0, (s) => /ssi contact person/i.test(s));\n if (metaStart === -1) {\n warnings.push('Could not find \"SSI Contact Person\" — header fields were skipped.');\n } else {\n const metaLabels: [number, keyof ParsedPO, keyof ParsedPO][] = [\n [0, \"ssi_contact_person\", \"ssi_contact_phone\"],\n [1, \"date_of_inquiry\", \"validity\"],\n [2, \"po_date\", \"inquiry_reference\"],\n [3, \"incoterms\", \"payment_terms\"],\n ];\n for (const [offset, leftKey, rightKey] of metaLabels) {\n const row = rows[metaStart + offset];\n if (!row) continue;\n const leftVal = norm(row[3]);\n const rightVal = norm(row[8]);\n if (leftVal) (result as any)[leftKey] = leftVal;\n if (rightVal) (result as any)[rightKey] = rightVal;\n }\n }\n\n // ---- Supplier - Bill from / Ship from ----\n const supplierHeaderRow = findRow(rows, 0, (s) => /supplier\\s*-\\s*bill from/i.test(s));\n const customerHeaderRow = findRow(rows, 0, (s) => /customer\\s*-\\s*bill to/i.test(s));\n if (supplierHeaderRow === -1 || customerHeaderRow === -1) {\n warnings.push(\"Could not find supplier/customer address blocks — those fields were skipped.\");\n } else {\n const billLines: string[] = [];\n const shipLines: string[] = [];\n for (let i = supplierHeaderRow + 1; i < customerHeaderRow; i++) {\n const row = rows[i];\n if (!row) continue;\n const left = norm(row[0]);\n const right = norm(row[4]);\n if (left) billLines.push(left);\n if (right) shipLines.push(right);\n }\n result.supplier_bill_from = billLines.join(\"\\n\") || undefined;\n result.supplier_ship_from = (shipLines.join(\"\\n\") || undefined) ?? result.supplier_bill_from;\n result.supplier_name = billLines.find((l) => l.length > 2) ?? billLines[0];\n }\n\n // ---- Customer - Bill to / Ship to (+ any note lines below) ----\n const lineItemsHeaderRow = findRow(rows, 0, (s) => /^sr\\.?\\s*no\\.?$/i.test(s));\n if (customerHeaderRow !== -1 && lineItemsHeaderRow !== -1) {\n const billLines: string[] = [];\n const shipLines: string[] = [];\n const noteLines: string[] = [];\n let pastShipBlock = false;\n for (let i = customerHeaderRow + 1; i < lineItemsHeaderRow; i++) {\n const row = rows[i];\n if (!row || isBlankRow(row)) continue;\n const left = norm(row[0]);\n const right = norm(row[4]);\n if (right) {\n billLines.push(left);\n shipLines.push(right);\n } else if (left) {\n pastShipBlock = true;\n noteLines.push(left);\n }\n }\n result.customer_bill_to = billLines.join(\"\\n\") || undefined;\n result.customer_ship_to = shipLines.join(\"\\n\") || undefined;\n result.customer_note = noteLines.join(\" \").trim() || undefined;\n } else {\n warnings.push(\"Could not find the line-items table header (\\\"Sr. No.\\\") — line items were skipped.\");\n }\n\n // ---- Line items: rows after the header until a \"TOTAL\" row ----\n // Column positions are read from the header row itself (rather than hardcoded\n // indices) so an extra \"Part No\" column — present in the new blank template\n // but not in older exports like the Konecranes one — is picked up automatically.\n if (lineItemsHeaderRow !== -1) {\n const headerRow = rows[lineItemsHeaderRow] ?? [];\n const findCol = (pattern: RegExp, fallback: number) => {\n const idx = headerRow.findIndex((c) => pattern.test(norm(c)));\n return idx === -1 ? fallback : idx;\n };\n const col = {\n description: findCol(/description/i, 1),\n partNo: findCol(/part\\s*no/i, -1),\n leadTime: findCol(/lead\\s*time/i, 3),\n uom: findCol(/^uom$/i, 4),\n qty: findCol(/^qty$/i, 5),\n unitPrice: findCol(/unit\\s*price/i, 6),\n remarks: findCol(/remarks/i, 8),\n };\n\n let i = lineItemsHeaderRow + 1;\n for (; i < rows.length; i++) {\n const row = rows[i];\n if (!row || isBlankRow(row)) continue;\n const descCell = norm(row[col.description]);\n if (/^total\\b/i.test(descCell)) break;\n const qty = parseNum(row[col.qty]);\n const unitPrice = parseNum(row[col.unitPrice]);\n if (!descCell || Number.isNaN(qty) || Number.isNaN(unitPrice)) continue;\n result.lineItems.push({\n description: descCell,\n part_no: col.partNo !== -1 ? (norm(row[col.partNo]) || undefined) : undefined,\n hsn_code: extractHsnCode(descCell),\n lead_time: norm(row[col.leadTime]) || undefined,\n uom: norm(row[col.uom]) || undefined,\n qty,\n unit_price: unitPrice,\n remarks: norm(row[col.remarks]) || undefined,\n });\n }\n if (result.lineItems.length === 0) {\n warnings.push(\"No line items were found between the table header and the TOTAL row.\");\n }\n }\n\n // ---- Numbered text sections ----\n function collectSection(labelPattern: RegExp): string | undefined {\n const start = findRow(rows, 0, (s) => labelPattern.test(s));\n if (start === -1) return undefined;\n const lines: string[] = [];\n let n = 1;\n for (let i = start + 1; i < rows.length; i++) {\n const row = rows[i];\n if (isBlankRow(row)) break;\n const text = norm(row[1]) || norm(row[0]);\n if (!text) break;\n lines.push(`${n}. ${text}`);\n n++;\n }\n return lines.length ? lines.join(\"\\n\") : undefined;\n }\n\n result.terms_text = collectSection(/commercial terms and conditions/i);\n result.tech_specs_text = collectSection(/technical specifications/i);\n result.annexures_text = collectSection(/^annexures$/i);\n\n return result;\n}\n\n/**\n * Builds a blank PO workbook in the same layout parsePOWorkbook() reads,\n * prefilled with SSI's standard defaults so the team is editing, not\n * starting from scratch. PO number is intentionally left off — it's always\n * assigned by the system when the file is uploaded.\n */\nexport function buildBlankPOTemplate(): Uint8Array {\n const termsLines = DEFAULT_PO_TERMS.split(\"\\n\").map((l) => l.replace(/^\\d+\\.\\s*/, \"\"));\n const techLines = DEFAULT_PO_TECH_SPECS.split(\"\\n\").map((l) => l.replace(/^\\d+\\.\\s*/, \"\"));\n const annexLines = DEFAULT_PO_ANNEXURES.split(\"\\n\").map((l) => l.replace(/^\\d+\\.\\s*/, \"\"));\n const custBillLines = DEFAULT_CUSTOMER_BILL_TO.split(\"\\n\");\n\n const rows: any[][] = [];\n const push = (...cells: any[]) => rows.push(cells);\n\n push(\"Fill this in and upload it from the vendor's 'Issue PO' section. PO number is assigned automatically — leave it out.\");\n push();\n push(SSI_LETTERHEAD.name);\n push(SSI_LETTERHEAD.address);\n push(`${SSI_LETTERHEAD.tel} | ${SSI_LETTERHEAD.gst}`);\n push();\n push(\"SSI Contact Person\", null, null, DEFAULT_SSI_CONTACT_PERSON, \"SSI Contact #\", null, null, null, DEFAULT_SSI_CONTACT_PHONE);\n push(\"Date of Inquiry\", null, null, \"\", \"Validity\", null, null, null, \"\");\n push(\"Date of Purchase Order\", null, null, \"\", \"Inquiry Reference\", null, null, null, \"\");\n push(\"Incoterms\", null, null, \"\", \"Payment Terms\", null, null, null, \"\");\n push();\n push(\"Supplier - Bill from :\", null, null, null, \"Supplier - Ship from :\");\n push(\"\", null, null, null, \"\");\n push(\"\", null, null, null, \"\");\n push();\n push(\"Customer - Bill to :\", null, null, null, \"Customer - Ship to :\");\n push(custBillLines[0] ?? \"\", null, null, null, DEFAULT_CUSTOMER_SHIP_TO);\n push(custBillLines[1] ?? \"\");\n push(custBillLines[2] ?? \"\");\n push();\n const lineItemsHeaderRow = rows.length;\n push(\"Sr. No.\", \"Description\", \"Part No\", \"Lead Time\", \"UOM\", \"Qty\", \"Unit Price (INR)\", \"Total Price (INR)\", \"Remarks\");\n for (let i = 1; i <= 5; i++) push(i, \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\");\n push();\n push(null, \"TOTAL (INR)\");\n push();\n push(\"Commercial Terms and Conditions\");\n termsLines.forEach((t, i) => push(i + 1, t));\n push();\n push(\"Technical Specifications\");\n techLines.forEach((t, i) => push(i + 1, t));\n push();\n push(\"Annexures\");\n annexLines.forEach((t, i) => push(i + 1, t));\n push();\n push(\"This is a Computer Generated Purchase Order.\");\n\n const ws = XLSX.utils.aoa_to_sheet(rows);\n ws[\"!cols\"] = [\n { wch: 10 },\n { wch: 40 },\n { wch: 14 },\n { wch: 14 },\n { wch: 8 },\n { wch: 8 },\n { wch: 14 },\n { wch: 14 },\n { wch: 30 },\n ];\n ws[\"!merges\"] = [\n { s: { r: 0, c: 0 }, e: { r: 0, c: 8 } },\n { s: { r: 2, c: 0 }, e: { r: 2, c: 8 } },\n { s: { r: 3, c: 0 }, e: { r: 3, c: 8 } },\n { s: { r: 4, c: 0 }, e: { r: 4, c: 8 } },\n { s: { r: lineItemsHeaderRow - 9, c: 0 }, e: { r: lineItemsHeaderRow - 9, c: 3 } },\n { s: { r: lineItemsHeaderRow - 9, c: 4 }, e: { r: lineItemsHeaderRow - 9, c: 8 } },\n ];\n\n const wb = XLSX.utils.book_new();\n XLSX.utils.book_append_sheet(wb, ws, \"PO Template\");\n return XLSX.write(wb, { bookType: \"xlsx\", type: \"array\" });\n}\n","label",[139],"8950e62d-6416-4c87-932d-1790fffcb0fe",["D",1784169877194],38,[28],"8d2dc0ed-6129-4f68-8767-a97745bd8717","schema.ts","c42d980c-805a-11f1-8847-1607ee4eb77e",117,["D",1784169756958],"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 sql: `CREATE TABLE IF NOT EXISTS products (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n part_no TEXT,\n description TEXT NOT NULL,\n uom TEXT,\n unit_price REAL DEFAULT 0,\n hsn_code TEXT,\n supplier_id INTEGER REFERENCES suppliers(id) ON DELETE SET NULL,\n category 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_products_part_no ON products(part_no)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_products_supplier ON products(supplier_id)` },\n ]);\n\n // po_line_items.part_no / product_id are later additions.\n const liCols = await sqlite.execute(`PRAGMA table_info(po_line_items)`);\n const liColNames = new Set((liCols.rows as any[]).map((r) => r.name));\n if (!liColNames.has(\"part_no\")) {\n await sqlite.execute(`ALTER TABLE po_line_items ADD COLUMN part_no TEXT`);\n }\n if (!liColNames.has(\"product_id\")) {\n await sqlite.execute(`ALTER TABLE po_line_items ADD COLUMN product_id INTEGER REFERENCES products(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 [\"drive_file_id\", \"TEXT\"],\n [\"drive_file_url\", \"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",[154],"cec5d31b-2df0-41bf-bbab-2ff2157690e9","pdf.ts","e279c67c-8079-11f1-8f05-1607ee4eb77e",90,["D",1784141118491],1,"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 = [\n item.description,\n item.part_no ? `Part No: ${item.part_no}` : \"\",\n item.hsn_code ? `HSN: ${item.hsn_code}` : \"\",\n ].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",[161],"9a1054e0-d288-4ab1-9ad9-77fcfc14ec0b","main.tsx",121,["D",1784169838330],28,"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 addPOFromImport,\n addPOLineItem,\n addProduct,\n addSubCategory,\n addSupplier,\n addVendor,\n assignSupplierToPackage,\n dashboardStats,\n deleteCategory,\n deletePackage,\n deletePOLineItem,\n deleteProduct,\n deleteSubCategory,\n deleteSupplier,\n getAllCategories,\n getAllPackages,\n getAllPOs,\n getAllProducts,\n getAllSubCategories,\n getAllSuppliers,\n getDocumentsForVendor,\n getPackage,\n getPackagesForSupplier,\n getPO,\n getPOFull,\n getPOsForVendor,\n getSupplier,\n getVendor,\n getVendorsForPackage,\n renameCategory,\n renameSubCategory,\n updatePackageFields,\n updatePOFields,\n updatePOLineItem,\n updateProductFields,\n updateSupplierFields,\n updateVendorFields,\n} from \"./db.ts\";\nimport { generatePOPdf } from \"./pdf.ts\";\nimport { pushPdfToDrive } from \"./drive.ts\";\nimport { buildBlankPOTemplate, parsePOWorkbook } from \"./xlsx-import.ts\";\nimport { isAllowed } from \"./constants.ts\";\nimport {\n CategoriesView,\n DashboardView,\n ForbiddenView,\n Layout,\n LoginView,\n PackageDetailView,\n PackagesView,\n PODetailView,\n POsListView,\n ProductsView,\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 const poId = await addPO(id, {\n po_date: body.po_date ? String(body.po_date) : undefined,\n expected_delivery_date: body.expected_delivery_date ? String(body.expected_delivery_date) : undefined,\n created_by: access.email,\n });\n return c.redirect(`/pos/${poId}`);\n});\n\napp.post(\"/vendors/:id/pos/import\", 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 vendor = await getVendor(id);\n if (!vendor) return c.text(\"Vendor not found\", 404);\n const body = await c.req.parseBody();\n const file = body.file;\n if (!(file instanceof File)) {\n return c.text(\"No file was uploaded\", 400);\n }\n let parsed;\n try {\n const buf = new Uint8Array(await file.arrayBuffer());\n parsed = parsePOWorkbook(buf);\n } catch (err) {\n return c.text(\n `Could not read that Excel file: ${err instanceof Error ? err.message : String(err)}`,\n 400,\n );\n }\n if (parsed.lineItems.length === 0) {\n return c.text(\n `No line items could be found in that file. ${parsed.warnings.join(\" \")}`.trim(),\n 400,\n );\n }\n const poId = await addPOFromImport(id, parsed, access.email);\n const warnQuery = parsed.warnings.length ? `?warnings=${encodeURIComponent(parsed.warnings.join(\"|\"))}` : \"\";\n return c.redirect(`/pos/${poId}${warnQuery}`);\n});\n\napp.get(\"/po-template.xlsx\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const bytes = buildBlankPOTemplate();\n return new Response(bytes, {\n headers: {\n \"Content-Type\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"Content-Disposition\": `attachment; filename=\"PO Template.xlsx\"`,\n },\n });\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(\"/pos/: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 full = await getPOFull(id);\n if (!full) return c.text(\"PO not found\", 404);\n const products = await getAllProducts();\n const warningsParam = c.req.query(\"warnings\");\n const warnings = warningsParam ? warningsParam.split(\"|\") : undefined;\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/pos/: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 const strOrNull = (v: unknown) => (v !== undefined ? (String(v).trim() || null) : undefined);\n await updatePOFields(id, {\n status: body.status ? String(body.status) : undefined,\n po_date: strOrNull(body.po_date),\n expected_delivery_date: strOrNull(body.expected_delivery_date),\n ssi_contact_person: strOrNull(body.ssi_contact_person),\n ssi_contact_phone: strOrNull(body.ssi_contact_phone),\n date_of_inquiry: strOrNull(body.date_of_inquiry),\n validity: strOrNull(body.validity),\n inquiry_reference: strOrNull(body.inquiry_reference),\n incoterms: strOrNull(body.incoterms),\n payment_terms: strOrNull(body.payment_terms),\n supplier_bill_from: strOrNull(body.supplier_bill_from),\n supplier_ship_from: strOrNull(body.supplier_ship_from),\n customer_bill_to: strOrNull(body.customer_bill_to),\n customer_ship_to: strOrNull(body.customer_ship_to),\n customer_note: strOrNull(body.customer_note),\n terms_text: strOrNull(body.terms_text),\n tech_specs_text: strOrNull(body.tech_specs_text),\n annexures_text: strOrNull(body.annexures_text),\n notes: strOrNull(body.notes),\n });\n return c.redirect(`/pos/${id}`);\n});\n\napp.post(\"/pos/:id/line-items\", 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 description = String(body.description ?? \"\").trim();\n if (description) {\n await addPOLineItem(id, {\n description,\n product_id: body.product_id ? Number(body.product_id) : undefined,\n part_no: body.part_no ? String(body.part_no).trim() : undefined,\n hsn_code: body.hsn_code ? String(body.hsn_code).trim() : undefined,\n lead_time: body.lead_time ? String(body.lead_time).trim() : undefined,\n uom: body.uom ? String(body.uom).trim() : undefined,\n qty: body.qty ? Number(body.qty) : undefined,\n unit_price: body.unit_price ? Number(body.unit_price) : undefined,\n remarks: body.remarks ? String(body.remarks).trim() : undefined,\n });\n }\n return c.redirect(`/pos/${id}`);\n});\n\napp.post(\"/po-line-items/: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 updatePOLineItem(id, {\n description: body.description ? String(body.description).trim() : undefined,\n part_no: body.part_no !== undefined ? (String(body.part_no).trim() || null) : undefined,\n hsn_code: body.hsn_code !== undefined ? (String(body.hsn_code).trim() || null) : undefined,\n lead_time: body.lead_time !== undefined ? (String(body.lead_time).trim() || null) : undefined,\n uom: body.uom !== undefined ? (String(body.uom).trim() || null) : undefined,\n qty: body.qty ? Number(body.qty) : undefined,\n unit_price: body.unit_price !== undefined ? Number(body.unit_price) : undefined,\n remarks: body.remarks !== undefined ? (String(body.remarks).trim() || null) : undefined,\n });\n return c.redirect(c.req.header(\"Referer\") ?? \"/pos\");\n});\n\napp.post(\"/po-line-items/: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 const referer = c.req.header(\"Referer\");\n await deletePOLineItem(id);\n return c.redirect(referer ?? \"/pos\");\n});\n\napp.get(\"/pos/:id/pdf\", 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 full = await getPOFull(id);\n if (!full) return c.text(\"PO not found\", 404);\n const bytes = await generatePOPdf(full);\n return new Response(bytes, {\n headers: {\n \"Content-Type\": \"application/pdf\",\n \"Content-Disposition\": `inline; filename=\"PO-${full.po.po_number}.pdf\"`,\n },\n });\n});\n\napp.post(\"/pos/:id/push-to-drive\", 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 full = await getPOFull(id);\n if (!full) return c.text(\"PO not found\", 404);\n try {\n const bytes = await generatePOPdf(full);\n const result = await pushPdfToDrive(`PO-${full.po.po_number}.pdf`, bytes, full.po.drive_file_id);\n await updatePOFields(id, { drive_file_id: result.fileId, drive_file_url: result.webViewLink });\n } catch (err) {\n const message = err instanceof Error ? err.message : String(err);\n return c.redirect(`/pos/${id}?warnings=${encodeURIComponent(`Drive push failed: ${message}`)}`);\n }\n return c.redirect(`/pos/${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(\"/products\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const [products, suppliers] = await Promise.all([getAllProducts(), getAllSuppliers()]);\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/products\", async (c) => {\n const access = await requireAccess(c);\n if (access instanceof Response) return access;\n const body = await c.req.parseBody();\n const description = String(body.description ?? \"\").trim();\n if (description) {\n await addProduct({\n part_no: body.part_no ? String(body.part_no).trim() : undefined,\n description,\n uom: body.uom ? String(body.uom).trim() : undefined,\n unit_price: body.unit_price ? Number(body.unit_price) : undefined,\n hsn_code: body.hsn_code ? String(body.hsn_code).trim() : undefined,\n supplier_id: body.supplier_id ? Number(body.supplier_id) : undefined,\n category: body.category ? String(body.category).trim() : undefined,\n });\n }\n return c.redirect(\"/products\");\n});\n\napp.post(\"/products/: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 updateProductFields(id, {\n part_no: body.part_no !== undefined ? (String(body.part_no).trim() || null) : undefined,\n description: body.description ? String(body.description).trim() : undefined,\n uom: body.uom !== undefined ? (String(body.uom).trim() || null) : undefined,\n unit_price: body.unit_price ? Number(body.unit_price) : undefined,\n category: body.category !== undefined ? (String(body.category).trim() || null) : undefined,\n supplier_id: body.supplier_id ? Number(body.supplier_id) : null,\n });\n return c.redirect(\"/products\");\n});\n\napp.post(\"/products/: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 deleteProduct(id);\n } catch (err) {\n return c.text(err instanceof Error ? err.message : \"Could not delete product\", 400);\n }\n return c.redirect(\"/products\");\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default oauthMiddleware(app.fetch);\n",[169],"c087c5a5-2935-4525-8cc7-2a8274087eaa","drive.ts","16a52ae0-80c0-11f1-8776-1607ee4eb77e",118,["D",1784169792708],"// Pushes generated PO PDFs to a Google Drive folder using a Google Cloud\n// service account (the same OAuth2 server-to-server pattern Val Town's own\n// Google Sheets guide uses: https://docs.val.town/guides/google-sheets/).\n//\n// One-time setup required from the user (cannot be done from inside the val):\n// 1. Create a Google Cloud project: https://console.cloud.google.com/projectcreate\n// 2. Enable the Drive API for that project: https://console.cloud.google.com/apis/library/drive.googleapis.com\n// 3. Create a service account (APIs & Services > Credentials > Create credentials\n// > Service account), then open it > Keys > Add key > Create new key > JSON.\n// This downloads a JSON key file.\n// 4. In Google Drive, create (or pick) a folder for PO PDFs, click Share, and\n// add the service account's email (looks like\n// xxx@yyy.iam.gserviceaccount.com — found in the JSON key file and in the\n// Cloud Console) as an Editor.\n// 5. Copy that folder's ID from its URL (the string after /folders/).\n// 6. Set two Val Town env vars:\n// GOOGLE_SERVICE_ACCOUNT — paste the full contents of the JSON key file\n// DRIVE_PO_FOLDER_ID — the folder ID from step 5\n//\n// Until both env vars are set, pushToDrive() throws a clear, actionable error\n// instead of a stack trace — the route handler surfaces that message to the user.\n\nconst DRIVE_SCOPE = [\"https://www.googleapis.com/auth/drive.file\"];\n\nfunction requireEnv(name: string): string {\n const v = Deno.env.get(name);\n if (!v) {\n throw new Error(\n `${name} is not set. Google Drive push isn't configured yet — see the setup steps at the top of drive.ts, ` +\n `then add the env var and try again.`,\n );\n }\n return v;\n}\n\nasync function getAccessToken(): Promise {\n const raw = requireEnv(\"GOOGLE_SERVICE_ACCOUNT\");\n let serviceAccount: unknown;\n try {\n serviceAccount = JSON.parse(raw);\n } catch {\n throw new Error(\n \"GOOGLE_SERVICE_ACCOUNT does not contain valid JSON. Paste the full contents of the service account key file you downloaded from Google Cloud.\",\n );\n }\n const { getToken } = await import(\"https://deno.land/x/google_jwt_sa@v0.2.3/mod.ts\");\n const token = await getToken(serviceAccount, { scope: DRIVE_SCOPE });\n return token.access_token;\n}\n\nfunction buildMultipartBody(\n metadata: Record,\n bytes: Uint8Array,\n mimeType: string,\n boundary: string,\n): Uint8Array {\n const encoder = new TextEncoder();\n const metadataPart = encoder.encode(\n `--${boundary}\\r\\nContent-Type: application/json; charset=UTF-8\\r\\n\\r\\n${JSON.stringify(metadata)}\\r\\n`,\n );\n const mediaHeader = encoder.encode(`--${boundary}\\r\\nContent-Type: ${mimeType}\\r\\n\\r\\n`);\n const closeDelim = encoder.encode(`\\r\\n--${boundary}--`);\n const body = new Uint8Array(metadataPart.length + mediaHeader.length + bytes.length + closeDelim.length);\n let offset = 0;\n body.set(metadataPart, offset);\n offset += metadataPart.length;\n body.set(mediaHeader, offset);\n offset += mediaHeader.length;\n body.set(bytes, offset);\n offset += bytes.length;\n body.set(closeDelim, offset);\n return body;\n}\n\nexport interface DrivePushResult {\n fileId: string;\n webViewLink: string;\n}\n\n// Uploads a PDF to the configured Drive folder. If existingFileId is passed\n// (i.e. this PO was already pushed once before), the existing file's content\n// is replaced in place instead of creating a duplicate — so re-pushing after\n// editing a PO keeps a single, stable Drive link.\nexport async function pushPdfToDrive(\n fileName: string,\n bytes: Uint8Array,\n existingFileId?: string | null,\n): Promise {\n const folderId = requireEnv(\"DRIVE_PO_FOLDER_ID\");\n const accessToken = await getAccessToken();\n const boundary = \"goa_po_pdf_\" + crypto.randomUUID().replace(/-/g, \"\");\n\n if (existingFileId) {\n const body = buildMultipartBody({ name: fileName }, bytes, \"application/pdf\", boundary);\n const res = await fetch(\n `https://www.googleapis.com/upload/drive/v3/files/${existingFileId}?uploadType=multipart&fields=id,webViewLink`,\n {\n method: \"PATCH\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": `multipart/related; boundary=${boundary}`,\n },\n body,\n },\n );\n if (res.ok) {\n const json = await res.json();\n return { fileId: json.id, webViewLink: json.webViewLink };\n }\n // If the previously-pushed file was deleted/moved out from under us,\n // fall through and create a fresh one rather than failing the push.\n if (res.status !== 404) {\n throw new Error(`Drive update failed (${res.status}): ${await res.text()}`);\n }\n }\n\n const metadata = { name: fileName, mimeType: \"application/pdf\", parents: [folderId] };\n const body = buildMultipartBody(metadata, bytes, \"application/pdf\", boundary);\n const res = await fetch(\n `https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart&fields=id,webViewLink`,\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${accessToken}`,\n \"Content-Type\": `multipart/related; boundary=${boundary}`,\n },\n body,\n },\n );\n if (!res.ok) {\n throw new Error(`Drive upload failed (${res.status}): ${await res.text()}`);\n }\n const json = await res.json();\n return { fileId: json.id, webViewLink: json.webViewLink };\n}\n",[177],"d9a669fd-dc82-4f64-9a29-546d8c4d352b","db.ts","d25420ae-805a-11f1-8f16-1607ee4eb77e",119,["D",1784169821634],21,"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 drive_file_id: string | null;\n drive_file_url: 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 part_no: string | null;\n product_id: number | 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 interface Product {\n id: number;\n part_no: string | null;\n description: string;\n uom: string | null;\n unit_price: number;\n hsn_code: string | null;\n supplier_id: number | null;\n category: string | null;\n notes: string | null;\n created_at: string;\n updated_at: string;\n}\n\nexport interface ProductWithSupplier extends Product {\n supplier_name: string | null;\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 Number(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): Promise {\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 const r = 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 return Number(r.lastInsertRowid);\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\n// Creates a PO from a parsed uploaded workbook (see xlsx-import.ts). The\n// po_number is always system-assigned via nextDocNumber — any number text\n// found in the sheet is ignored so numbering can never collide or be spoofed.\n// Any field the sheet didn't have falls back to the same defaults addPO uses.\nexport async function addPOFromImport(\n vendorId: number,\n parsed: {\n ssi_contact_person?: string;\n ssi_contact_phone?: string;\n date_of_inquiry?: string;\n validity?: string;\n po_date?: string;\n inquiry_reference?: string;\n incoterms?: string;\n payment_terms?: string;\n supplier_bill_from?: string;\n supplier_ship_from?: string;\n customer_bill_to?: string;\n customer_ship_to?: string;\n customer_note?: string;\n terms_text?: string;\n tech_specs_text?: string;\n annexures_text?: string;\n lineItems: {\n description: string;\n hsn_code?: string;\n part_no?: string;\n lead_time?: string;\n uom?: string;\n qty: number;\n unit_price: number;\n remarks?: string;\n }[];\n },\n createdBy?: string,\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 fallbackSupplierBlock = supplier\n ? [supplier.name, supplier.address].filter(Boolean).join(\"\\n\")\n : vendor?.name ?? null;\n\n const r = await sqlite.execute({\n sql: `INSERT INTO purchase_orders (\n vendor_id, po_number, po_date, status, created_by,\n ssi_contact_person, ssi_contact_phone, date_of_inquiry, validity, inquiry_reference,\n incoterms, payment_terms, 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 parsed.po_date ?? null,\n \"Issued\",\n createdBy ?? null,\n parsed.ssi_contact_person ?? DEFAULT_SSI_CONTACT_PERSON,\n parsed.ssi_contact_phone ?? DEFAULT_SSI_CONTACT_PHONE,\n parsed.date_of_inquiry ?? null,\n parsed.validity ?? null,\n parsed.inquiry_reference ?? null,\n parsed.incoterms ?? null,\n parsed.payment_terms ?? null,\n parsed.customer_bill_to ?? DEFAULT_CUSTOMER_BILL_TO,\n parsed.customer_ship_to ?? DEFAULT_CUSTOMER_SHIP_TO,\n parsed.customer_note ?? DEFAULT_CUSTOMER_NOTE,\n parsed.supplier_bill_from ?? fallbackSupplierBlock,\n parsed.supplier_ship_from ?? parsed.supplier_bill_from ?? fallbackSupplierBlock,\n parsed.terms_text ?? DEFAULT_PO_TERMS,\n parsed.tech_specs_text ?? DEFAULT_PO_TECH_SPECS,\n parsed.annexures_text ?? DEFAULT_PO_ANNEXURES,\n ],\n });\n const poId = Number(r.lastInsertRowid);\n\n for (const item of parsed.lineItems) {\n await addPOLineItem(poId, item);\n }\n\n return poId;\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 part_no?: string;\n product_id?: number;\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, part_no, product_id, 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.part_no ?? null,\n item.product_id ?? 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// ---- Product master ----\n\nexport async function getAllProducts(): Promise {\n const r = await sqlite.execute(\n `SELECT p.*, s.name as supplier_name FROM products p\n LEFT JOIN suppliers s ON s.id = p.supplier_id\n ORDER BY p.description`,\n );\n return r.rows as unknown as ProductWithSupplier[];\n}\n\nexport async function getProduct(id: number): Promise {\n const r = await sqlite.execute({ sql: \"SELECT * FROM products WHERE id = ?\", args: [id] });\n return (r.rows[0] as unknown as Product) ?? null;\n}\n\nexport async function addProduct(p: {\n part_no?: string;\n description: string;\n uom?: string;\n unit_price?: number;\n hsn_code?: string;\n supplier_id?: number;\n category?: string;\n notes?: string;\n}): Promise {\n const r = await sqlite.execute({\n sql: `INSERT INTO products (part_no, description, uom, unit_price, hsn_code, supplier_id, category, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n p.part_no ?? null,\n p.description,\n p.uom ?? null,\n p.unit_price ?? 0,\n p.hsn_code ?? null,\n p.supplier_id ?? null,\n p.category ?? null,\n p.notes ?? null,\n ],\n });\n return Number(r.lastInsertRowid);\n}\n\nexport async function updateProductFields(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({ sql: `UPDATE products SET ${sets}, updated_at = CURRENT_TIMESTAMP WHERE id = ?`, args });\n}\n\nexport async function deleteProduct(id: number) {\n const inUse = await sqlite.execute({ sql: \"SELECT COUNT(*) as c FROM po_line_items WHERE product_id = ?\", args: [id] });\n if (Number((inUse.rows[0] as any).c) > 0) {\n throw new Error(`Cannot delete this product — it's used in ${(inUse.rows[0] as any).c} PO line item(s).`);\n }\n await sqlite.execute({ sql: \"DELETE FROM products WHERE id = ?\", args: [id] });\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",[184],"30ebea84-c5e0-4cee-864f-c1246d6238c7","constants.ts","bbb98582-805a-11f1-8010-1607ee4eb77e",78,["D",1784140889194],"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 = \"SSI Goa\";\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",[192],"pulls","branches","forks","envVars",{"_205":63,"_207":63},"connections",{"_205":63,"_206":63},"count","unfilledCount","emptyCount",{"_43":191,"_32":192,"_30":193,"_141":-5,"_41":42,"_40":194,"_143":59,"_38":238,"_13":145,"_33":34,"_35":196,"_24":25,"_147":-5,"_217":239,"_27":240},{"_43":183,"_32":184,"_30":185,"_141":-5,"_41":42,"_40":186,"_143":59,"_38":235,"_13":188,"_33":34,"_35":189,"_24":25,"_147":-5,"_217":236,"_27":237},{"_43":176,"_32":177,"_30":178,"_141":-5,"_41":42,"_40":179,"_143":59,"_38":232,"_13":63,"_33":34,"_35":181,"_24":25,"_147":-5,"_217":233,"_27":234},{"_43":168,"_32":169,"_30":57,"_141":-5,"_41":42,"_40":170,"_143":59,"_38":229,"_13":172,"_33":173,"_35":174,"_24":25,"_147":-5,"_217":230,"_27":231},{"_43":160,"_32":161,"_30":162,"_141":-5,"_41":42,"_40":163,"_143":59,"_38":226,"_13":165,"_33":34,"_35":166,"_24":25,"_147":-5,"_217":227,"_27":228},{"_43":153,"_32":154,"_30":155,"_141":-5,"_41":42,"_40":156,"_143":59,"_38":223,"_13":145,"_33":34,"_35":158,"_24":25,"_147":-5,"_217":224,"_27":225},{"_43":149,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":59,"_38":220,"_13":151,"_33":34,"_35":37,"_24":25,"_147":-5,"_217":221,"_27":222},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":59,"_38":216,"_13":145,"_33":34,"_35":146,"_24":25,"_147":-5,"_217":218,"_27":219},["D",1784144832916],"children",[],[139],["D",1784169877194],[],[28],["D",1784169756958],[],[154],["D",1784141118491],[],[161],["D",1784169838330],[],[169],["D",1784169792708],[],[177],["D",1784169821634],[],[184],["D",1784140889194],[],[192],["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":279,"_280":281,"_282":283,"_284":25,"_285":25,"_286":25,"_287":59,"_288":-5,"_289":-7,"_290":-7,"_291":63,"_292":25,"_293":25,"_294":-5,"_295":25,"_296":25,"_297":25,"_298":-5},"ENV",{"_250":251,"_252":253,"_254":90,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v122