[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_206":207,"_208":209},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","e1081e5c-39f7-11f0-91a2-9e149126039e","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Customer, Bill, Payment, BillItem } from \"../../shared/types.ts\";\n\n// User queries\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\"SELECT * FROM users WHERE email = ?\", [email]);\n return result[0] as User || null;\n}\n\nexport async function createUser(userData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO users (email, password, name, phone, role)\n VALUES (?, ?, ?, ?, ?)\n `, [userData.email, userData.password, userData.name, userData.phone || null, userData.role]);\n return result.lastInsertRowId;\n}\n\n// Customer queries\nexport async function getAllCustomers(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM customers ORDER BY name\");\n return result as Customer[];\n}\n\nexport async function getCustomerById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM customers WHERE id = ?\", [id]);\n return result[0] as Customer || null;\n}\n\nexport async function createCustomer(customerData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO customers (name, email, phone, address)\n VALUES (?, ?, ?, ?)\n `, [customerData.name, customerData.email, customerData.phone, customerData.address]);\n return result.lastInsertRowId;\n}\n\nexport async function updateCustomer(id: number, customerData: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (customerData.name) {\n fields.push(\"name = ?\");\n values.push(customerData.name);\n }\n if (customerData.email) {\n fields.push(\"email = ?\");\n values.push(customerData.email);\n }\n if (customerData.phone) {\n fields.push(\"phone = ?\");\n values.push(customerData.phone);\n }\n if (customerData.address) {\n fields.push(\"address = ?\");\n values.push(customerData.address);\n }\n \n if (fields.length > 0) {\n values.push(id);\n await sqlite.execute(`UPDATE customers SET ${fields.join(\", \")} WHERE id = ?`, values);\n }\n}\n\n// Bill queries\nexport async function getAllBills(): Promise {\n const result = await sqlite.execute(`\n SELECT b.*, c.name as customer_name, c.phone as customer_phone, c.email as customer_email\n FROM bills b\n JOIN customers c ON b.customer_id = c.id\n ORDER BY b.created_at DESC\n `);\n \n return result.map(row => ({\n ...row,\n items: JSON.parse(row.items as string)\n })) as Bill[];\n}\n\nexport async function getBillsByCustomerId(customerId: number): Promise {\n const result = await sqlite.execute(`\n SELECT b.*, c.name as customer_name, c.phone as customer_phone, c.email as customer_email\n FROM bills b\n JOIN customers c ON b.customer_id = c.id\n WHERE b.customer_id = ?\n ORDER BY b.created_at DESC\n `, [customerId]);\n \n return result.map(row => ({\n ...row,\n items: JSON.parse(row.items as string)\n })) as Bill[];\n}\n\nexport async function getBillById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT b.*, c.name as customer_name, c.phone as customer_phone, c.email as customer_email\n FROM bills b\n JOIN customers c ON b.customer_id = c.id\n WHERE b.id = ?\n `, [id]);\n \n if (result[0]) {\n return {\n ...result[0],\n items: JSON.parse(result[0].items as string)\n } as Bill;\n }\n return null;\n}\n\nexport async function createBill(billData: {\n customer_id: number;\n bill_number: string;\n description: string;\n items: BillItem[];\n subtotal: number;\n tax_rate: number;\n tax_amount: number;\n total_amount: number;\n remaining_amount: number;\n due_date: string;\n}): Promise {\n const result = await sqlite.execute(`\n INSERT INTO bills (\n customer_id, bill_number, description, items, subtotal, \n tax_rate, tax_amount, total_amount, remaining_amount, due_date\n )\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n billData.customer_id,\n billData.bill_number,\n billData.description,\n JSON.stringify(billData.items),\n billData.subtotal,\n billData.tax_rate,\n billData.tax_amount,\n billData.total_amount,\n billData.remaining_amount,\n billData.due_date\n ]);\n return result.lastInsertRowId;\n}\n\nexport async function updateBill(id: number, billData: Partial): Promise {\n const fields = [];\n const values = [];\n \n if (billData.description) {\n fields.push(\"description = ?\");\n values.push(billData.description);\n }\n if (billData.items) {\n fields.push(\"items = ?\");\n values.push(JSON.stringify(billData.items));\n }\n if (billData.subtotal !== undefined) {\n fields.push(\"subtotal = ?\");\n values.push(billData.subtotal);\n }\n if (billData.tax_rate !== undefined) {\n fields.push(\"tax_rate = ?\");\n values.push(billData.tax_rate);\n }\n if (billData.tax_amount !== undefined) {\n fields.push(\"tax_amount = ?\");\n values.push(billData.tax_amount);\n }\n if (billData.total_amount !== undefined) {\n fields.push(\"total_amount = ?\");\n values.push(billData.total_amount);\n }\n if (billData.paid_amount !== undefined) {\n fields.push(\"paid_amount = ?\");\n values.push(billData.paid_amount);\n }\n if (billData.remaining_amount !== undefined) {\n fields.push(\"remaining_amount = ?\");\n values.push(billData.remaining_amount);\n }\n if (billData.status) {\n fields.push(\"status = ?\");\n values.push(billData.status);\n }\n if (billData.due_date) {\n fields.push(\"due_date = ?\");\n values.push(billData.due_date);\n }\n \n if (fields.length > 0) {\n fields.push(\"updated_at = CURRENT_TIMESTAMP\");\n values.push(id);\n await sqlite.execute(`UPDATE bills SET ${fields.join(\", \")} WHERE id = ?`, values);\n }\n}\n\nexport async function deleteBill(id: number): Promise {\n await sqlite.execute(\"DELETE FROM payments WHERE bill_id = ?\", [id]);\n await sqlite.execute(\"DELETE FROM bills WHERE id = ?\", [id]);\n}\n\n// Payment queries\nexport async function getPaymentsByBillId(billId: number): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM payments WHERE bill_id = ? ORDER BY payment_date DESC\",\n [billId]\n );\n return result as Payment[];\n}\n\nexport async function createPayment(paymentData: {\n bill_id: number;\n amount: number;\n payment_method: string;\n payment_date: string;\n notes?: string;\n}): Promise {\n const result = await sqlite.execute(`\n INSERT INTO payments (bill_id, amount, payment_method, payment_date, notes)\n VALUES (?, ?, ?, ?, ?)\n `, [\n paymentData.bill_id,\n paymentData.amount,\n paymentData.payment_method,\n paymentData.payment_date,\n paymentData.notes || null\n ]);\n return result.lastInsertRowId;\n}\n\nexport async function generateBillNumber(): Promise {\n const result = await sqlite.execute(\"SELECT COUNT(*) as count FROM bills\");\n const count = result[0].count as number;\n const year = new Date().getFullYear();\n return `FAB-${year}-${String(count + 1).padStart(4, '0')}`;\n}","createdAt",["D",1748239724356],"branchVersion","branchId","ac95e5c8-39f7-11f0-a690-9e149126039e","id","ac9550e0-39f7-11f0-a690-9e149126039e","c",["D",1748239636364],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","3f5c0310-f74a-11ef-9322-0fd6f1c36e70","pinnedFileId","178fe428-39f8-11f0-9849-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","95c157c5-cbbd-4bec-b106-f6310388ea7e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Sujal5","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0a3VPOU1hdnpnVlJNc2lRUEd6bHJWTzE4ZyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":202,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":203,"_79":204,"_81":205,"_83":24},"tree",[161,165,167],"files",[161,162,163,164,165,166,167],"counts",{"_151":61,"_152":132,"_153":61,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":149,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":142,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":24,"_37":134,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"c3305e26-39f7-11f0-b1ee-9e149126039e","README.md","c3305ee4-39f7-11f0-b1ee-9e149126039e","parentId",1,"latest",["D",1748239674287],"# Fabrication Bill Generator\n\nA comprehensive bill management system for fabrication businesses with admin and customer portals.\n\n## Features\n\n### Admin Features\n- Generate and edit bills\n- Manage customers\n- Track payments\n- View payment history\n- Download bills as PDF\n\n### Customer Features\n- View assigned bills\n- Make payments\n- Track payment history\n- Download bills as PDF\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── auth.ts # Authentication routes\n│ │ ├── bills.ts # Bill management\n│ │ ├── payments.ts # Payment processing\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main server entry\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application\n│ │ ├── Login.tsx # Login component\n│ │ ├── AdminDashboard.tsx\n│ │ ├── CustomerDashboard.tsx\n│ │ ├── BillForm.tsx # Bill creation/editing\n│ │ ├── BillList.tsx # Bill listing\n│ │ ├── PaymentModal.tsx\n│ │ └── BillPDF.tsx # PDF generation\n│ ├── index.html\n│ ├── index.tsx\n│ └── style.css\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Technology Stack\n\n- **Backend**: Hono (TypeScript)\n- **Frontend**: React with TypeScript\n- **Database**: SQLite\n- **Styling**: TailwindCSS\n- **PDF Generation**: jsPDF\n- **Authentication**: JWT tokens\n\n## Getting Started\n\n1. The application will automatically set up the database on first run\n2. Default admin credentials: admin@fabrication.com / admin123\n3. Access the application via the HTTP endpoint","label",[129],"c93d8c8a-39f7-11f0-a1e5-9e149126039e","shared","100b8c84-c6ee-4491-ace3-8888f8899b60",2,["D",1748239684437],"directory",[139],"cf931d70-39f7-11f0-9975-9e149126039e","backend","74e14fa3-c7d3-47e9-8c48-ec7cd767e1a2",3,["D",1748239695066],[146],"pulls","branches","forks","envVars",{"_158":61,"_160":61},"connections",{"_158":61,"_159":61},"count","unfilledCount","emptyCount",{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":199,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_169":200,"_26":201},{"_42":195,"_31":187,"_29":183,"_131":147,"_40":41,"_39":148,"_133":57,"_37":196,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_169":197,"_26":198},{"_42":188,"_31":189,"_29":190,"_131":183,"_40":41,"_39":148,"_133":24,"_37":191,"_13":61,"_33":34,"_35":192,"_23":24,"_136":-5,"_169":193,"_26":194},{"_42":182,"_31":32,"_29":30,"_131":183,"_40":41,"_39":14,"_133":24,"_37":184,"_13":61,"_33":34,"_35":36,"_23":24,"_136":-5,"_169":185,"_26":186},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":179,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_169":180,"_26":181},{"_42":172,"_31":173,"_29":174,"_131":140,"_40":41,"_39":141,"_133":57,"_37":175,"_13":61,"_33":34,"_35":176,"_23":24,"_136":-5,"_169":177,"_26":178},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":24,"_37":168,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_169":170,"_26":171},["D",1748239674287],"children",[],[129],"c93d6cdc-39f7-11f0-a1e5-9e149126039e","types.ts","c93d6d9a-39f7-11f0-a1e5-9e149126039e",["D",1748239684437],"// Shared types for the fabrication bill generator\n\nexport interface User {\n id: number;\n email: string;\n password: string;\n name: string;\n phone?: string;\n role: 'admin' | 'customer';\n created_at: string;\n}\n\nexport interface Customer {\n id: number;\n name: string;\n email: string;\n phone: string;\n address: string;\n created_at: string;\n}\n\nexport interface Bill {\n id: number;\n customer_id: number;\n customer_name?: string;\n customer_phone?: string;\n customer_email?: string;\n bill_number: string;\n description: string;\n items: BillItem[];\n subtotal: number;\n tax_rate: number;\n tax_amount: number;\n total_amount: number;\n paid_amount: number;\n remaining_amount: number;\n status: 'pending' | 'partial' | 'paid';\n due_date: string;\n created_at: string;\n updated_at: string;\n}\n\nexport interface BillItem {\n id?: number;\n description: string;\n quantity: number;\n unit_price: number;\n total: number;\n}\n\nexport interface Payment {\n id: number;\n bill_id: number;\n amount: number;\n payment_method: string;\n payment_date: string;\n notes?: string;\n created_at: string;\n}\n\nexport interface AuthResponse {\n success: boolean;\n token?: string;\n user?: Omit;\n message?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n message?: string;\n}\n\nexport interface BillFormData {\n customer_id: number;\n description: string;\n items: BillItem[];\n tax_rate: number;\n due_date: string;\n}\n\nexport interface PaymentFormData {\n amount: number;\n payment_method: string;\n notes?: string;\n}",[],[139,173],["D",1748239684437],[166],[139],"e1081d94-39f7-11f0-91a2-9e149126039e","6bb09401-7e6c-48f1-b709-163b1f793f95",["D",1748239724356],[],[146,187,32],"database","cf93141a-39f7-11f0-9975-9e149126039e","migrations.ts","cf9314ba-39f7-11f0-9975-9e149126039e",["D",1748239695066],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n name TEXT NOT NULL,\n phone TEXT,\n role TEXT NOT NULL DEFAULT 'customer',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Customers table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS customers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n phone TEXT NOT NULL,\n address TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Bills table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bills (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n customer_id INTEGER NOT NULL,\n bill_number TEXT UNIQUE NOT NULL,\n description TEXT NOT NULL,\n items TEXT NOT NULL, -- JSON string of bill items\n subtotal REAL NOT NULL,\n tax_rate REAL NOT NULL DEFAULT 0,\n tax_amount REAL NOT NULL DEFAULT 0,\n total_amount REAL NOT NULL,\n paid_amount REAL NOT NULL DEFAULT 0,\n remaining_amount REAL NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n due_date DATE NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (customer_id) REFERENCES customers (id)\n )\n `);\n\n // Payments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS payments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n bill_id INTEGER NOT NULL,\n amount REAL NOT NULL,\n payment_method TEXT NOT NULL,\n payment_date DATE NOT NULL,\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (bill_id) REFERENCES bills (id)\n )\n `);\n\n // Create default admin user\n const adminExists = await sqlite.execute(\n \"SELECT id FROM users WHERE email = ?\",\n [\"admin@fabrication.com\"]\n );\n\n if (adminExists.length === 0) {\n await sqlite.execute(`\n INSERT INTO users (email, password, name, role)\n VALUES (?, ?, ?, ?)\n `, [\"admin@fabrication.com\", \"admin123\", \"Administrator\", \"admin\"]);\n }\n\n console.log(\"Database migrations completed successfully\");\n}",[],[146,187,189],"cf931f14-39f7-11f0-9975-9e149126039e",["D",1748239695066],[163,164],[146,187],["D",1748239695066],[162],[146],["D",1748239636364],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":239,"_240":241,"_242":243,"_244":24,"_245":24,"_246":24,"_247":57,"_248":-5,"_249":-7,"_250":-7,"_251":61,"_252":24,"_253":24,"_254":-5,"_255":24,"_256":24,"_257":24,"_258":-5},"ENV",{"_210":211,"_212":213,"_214":85,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v4