Fabrication Bill Generator

Loading Fabrication Bill Generator...

\n \n \n\n",[],[147,203],["D",1748239835415],[179,180],[147],"178fe374-39f8-11f0-9849-9e149126039e","index.ts",9,["D",1748239815842],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport auth from \"./routes/auth.ts\";\nimport bills from \"./routes/bills.ts\";\nimport payments from \"./routes/payments.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait runMigrations();\n\n// API routes\napp.route(\"/api/auth\", auth);\napp.route(\"/api/bills\", bills);\napp.route(\"/api/payments\", payments);\n\n// Static file serving and main page\napp.route(\"/\", staticRoutes);\n\n// Health check\napp.get(\"/health\", (c) => {\n return c.json({ \n status: \"healthy\", \n timestamp: new Date().toISOString(),\n service: \"Fabrication Bill Generator\"\n });\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({ \n success: false, \n message: \"Endpoint not found\" \n }, 404);\n});\n\nexport default app;",[],[153,213],"11579524-39f8-11f0-8941-9e149126039e","static.ts","115795e2-39f8-11f0-8941-9e149126039e","59c647c6-7642-4a9d-b1d3-4d13daf81e80",8,["D",1748239805407],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\nstaticRoutes.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data injection\nstaticRoutes.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // You can inject initial data here if needed\n const initialData = {\n timestamp: new Date().toISOString()\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\nexport default staticRoutes;",[],[153,228,220],"routes","0c417b90-39f8-11f0-b17b-9e149126039e","payments.ts","0c417c58-39f8-11f0-b17b-9e149126039e",7,["D",1748239796873],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { authMiddleware } from \"./auth.ts\";\nimport {\n getPaymentsByBillId,\n createPayment,\n getBillById,\n updateBill\n} from \"../database/queries.ts\";\nimport type { ApiResponse, Payment, PaymentFormData } from \"../../shared/types.ts\";\n\nconst payments = new Hono();\n\n// Get payments for a specific bill\npayments.get(\"/bill/:billId\", authMiddleware, async (c) => {\n try {\n const billId = parseInt(c.req.param(\"billId\"));\n const user = c.get(\"user\");\n \n // Check if user can access this bill\n const bill = await getBillById(billId);\n if (!bill) {\n return c.json({\n success: false,\n message: \"Bill not found\"\n }, 404);\n }\n\n if (user.role === \"customer\" && bill.customer_id !== user.userId) {\n return c.json({\n success: false,\n message: \"Access denied\"\n }, 403);\n }\n\n const paymentsData = await getPaymentsByBillId(billId);\n \n return c.json>({\n success: true,\n data: paymentsData\n });\n } catch (error) {\n console.error(\"Error fetching payments:\", error);\n return c.json({\n success: false,\n message: \"Failed to fetch payments\"\n }, 500);\n }\n});\n\n// Create payment\npayments.post(\"/bill/:billId\", authMiddleware, async (c) => {\n try {\n const billId = parseInt(c.req.param(\"billId\"));\n const user = c.get(\"user\");\n const paymentData: PaymentFormData = await c.req.json();\n \n if (!paymentData.amount || paymentData.amount <= 0) {\n return c.json({\n success: false,\n message: \"Valid payment amount is required\"\n }, 400);\n }\n\n if (!paymentData.payment_method) {\n return c.json({\n success: false,\n message: \"Payment method is required\"\n }, 400);\n }\n\n // Get the bill\n const bill = await getBillById(billId);\n if (!bill) {\n return c.json({\n success: false,\n message: \"Bill not found\"\n }, 404);\n }\n\n // Check if user can make payment for this bill\n if (user.role === \"customer\" && bill.customer_id !== user.userId) {\n return c.json({\n success: false,\n message: \"Access denied\"\n }, 403);\n }\n\n // Check if payment amount doesn't exceed remaining amount\n if (paymentData.amount > bill.remaining_amount) {\n return c.json({\n success: false,\n message: `Payment amount cannot exceed remaining balance of $${bill.remaining_amount.toFixed(2)}`\n }, 400);\n }\n\n // Create payment record\n const paymentId = await createPayment({\n bill_id: billId,\n amount: paymentData.amount,\n payment_method: paymentData.payment_method,\n payment_date: new Date().toISOString().split('T')[0],\n notes: paymentData.notes\n });\n\n // Update bill amounts and status\n const newPaidAmount = bill.paid_amount + paymentData.amount;\n const newRemainingAmount = bill.total_amount - newPaidAmount;\n \n let newStatus: 'pending' | 'partial' | 'paid' = 'pending';\n if (newRemainingAmount <= 0) {\n newStatus = 'paid';\n } else if (newPaidAmount > 0) {\n newStatus = 'partial';\n }\n\n await updateBill(billId, {\n paid_amount: newPaidAmount,\n remaining_amount: Math.max(0, newRemainingAmount),\n status: newStatus\n });\n\n return c.json({\n success: true,\n data: { \n id: paymentId,\n remaining_amount: Math.max(0, newRemainingAmount),\n status: newStatus\n },\n message: \"Payment recorded successfully\"\n });\n } catch (error) {\n console.error(\"Error creating payment:\", error);\n return c.json({\n success: false,\n message: \"Failed to process payment\"\n }, 500);\n }\n});\n\nexport default payments;",[],[153,228,230],"ff4ad7f6-39f7-11f0-97d3-9e149126039e","bills.ts","ff4ad88c-39f7-11f0-97d3-9e149126039e",6,["D",1748239775125],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { authMiddleware, adminMiddleware } from \"./auth.ts\";\nimport {\n getAllBills,\n getBillsByCustomerId,\n getBillById,\n createBill,\n updateBill,\n deleteBill,\n generateBillNumber,\n getAllCustomers,\n createCustomer,\n updateCustomer\n} from \"../database/queries.ts\";\nimport type { ApiResponse, Bill, BillFormData, Customer } from \"../../shared/types.ts\";\n\nconst bills = new Hono();\n\n// Get all customers (admin only)\nbills.get(\"/customers\", authMiddleware, adminMiddleware, async (c) => {\n try {\n const customers = await getAllCustomers();\n return c.json>({\n success: true,\n data: customers\n });\n } catch (error) {\n console.error(\"Error fetching customers:\", error);\n return c.json({\n success: false,\n message: \"Failed to fetch customers\"\n }, 500);\n }\n});\n\n// Create customer (admin only)\nbills.post(\"/customers\", authMiddleware, adminMiddleware, async (c) => {\n try {\n const customerData = await c.req.json();\n \n if (!customerData.name || !customerData.email || !customerData.phone || !customerData.address) {\n return c.json({\n success: false,\n message: \"All customer fields are required\"\n }, 400);\n }\n\n const customerId = await createCustomer(customerData);\n return c.json({\n success: true,\n data: { id: customerId }\n });\n } catch (error) {\n console.error(\"Error creating customer:\", error);\n return c.json({\n success: false,\n message: \"Failed to create customer\"\n }, 500);\n }\n});\n\n// Update customer (admin only)\nbills.put(\"/customers/:id\", authMiddleware, adminMiddleware, async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const customerData = await c.req.json();\n \n await updateCustomer(id, customerData);\n return c.json({\n success: true,\n message: \"Customer updated successfully\"\n });\n } catch (error) {\n console.error(\"Error updating customer:\", error);\n return c.json({\n success: false,\n message: \"Failed to update customer\"\n }, 500);\n }\n});\n\n// Get all bills (admin) or customer's bills (customer)\nbills.get(\"/\", authMiddleware, async (c) => {\n try {\n const user = c.get(\"user\");\n let billsData: Bill[];\n\n if (user.role === \"admin\") {\n billsData = await getAllBills();\n } else {\n // For customers, we need to find their customer_id first\n // This is a simplified approach - in production, you might want to link users to customers differently\n billsData = await getBillsByCustomerId(user.userId);\n }\n\n return c.json>({\n success: true,\n data: billsData\n });\n } catch (error) {\n console.error(\"Error fetching bills:\", error);\n return c.json({\n success: false,\n message: \"Failed to fetch bills\"\n }, 500);\n }\n});\n\n// Get specific bill\nbills.get(\"/:id\", authMiddleware, async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const user = c.get(\"user\");\n \n const bill = await getBillById(id);\n if (!bill) {\n return c.json({\n success: false,\n message: \"Bill not found\"\n }, 404);\n }\n\n // Check if customer can access this bill\n if (user.role === \"customer\" && bill.customer_id !== user.userId) {\n return c.json({\n success: false,\n message: \"Access denied\"\n }, 403);\n }\n\n return c.json>({\n success: true,\n data: bill\n });\n } catch (error) {\n console.error(\"Error fetching bill:\", error);\n return c.json({\n success: false,\n message: \"Failed to fetch bill\"\n }, 500);\n }\n});\n\n// Create bill (admin only)\nbills.post(\"/\", authMiddleware, adminMiddleware, async (c) => {\n try {\n const billData: BillFormData = await c.req.json();\n \n if (!billData.customer_id || !billData.description || !billData.items || billData.items.length === 0) {\n return c.json({\n success: false,\n message: \"Customer, description, and items are required\"\n }, 400);\n }\n\n // Calculate totals\n const subtotal = billData.items.reduce((sum, item) => sum + item.total, 0);\n const tax_amount = subtotal * (billData.tax_rate / 100);\n const total_amount = subtotal + tax_amount;\n\n const bill_number = await generateBillNumber();\n\n const billId = await createBill({\n customer_id: billData.customer_id,\n bill_number,\n description: billData.description,\n items: billData.items,\n subtotal,\n tax_rate: billData.tax_rate,\n tax_amount,\n total_amount,\n remaining_amount: total_amount,\n due_date: billData.due_date\n });\n\n return c.json({\n success: true,\n data: { id: billId, bill_number }\n });\n } catch (error) {\n console.error(\"Error creating bill:\", error);\n return c.json({\n success: false,\n message: \"Failed to create bill\"\n }, 500);\n }\n});\n\n// Update bill (admin only)\nbills.put(\"/:id\", authMiddleware, adminMiddleware, async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const billData: Partial = await c.req.json();\n \n const updateData: Partial = {};\n \n if (billData.description) {\n updateData.description = billData.description;\n }\n \n if (billData.items) {\n updateData.items = billData.items;\n // Recalculate totals\n const subtotal = billData.items.reduce((sum, item) => sum + item.total, 0);\n const tax_rate = billData.tax_rate || 0;\n const tax_amount = subtotal * (tax_rate / 100);\n const total_amount = subtotal + tax_amount;\n \n updateData.subtotal = subtotal;\n updateData.tax_rate = tax_rate;\n updateData.tax_amount = tax_amount;\n updateData.total_amount = total_amount;\n \n // Get current bill to calculate remaining amount\n const currentBill = await getBillById(id);\n if (currentBill) {\n updateData.remaining_amount = total_amount - currentBill.paid_amount;\n updateData.status = updateData.remaining_amount <= 0 ? 'paid' : \n currentBill.paid_amount > 0 ? 'partial' : 'pending';\n }\n }\n \n if (billData.due_date) {\n updateData.due_date = billData.due_date;\n }\n\n await updateBill(id, updateData);\n \n return c.json({\n success: true,\n message: \"Bill updated successfully\"\n });\n } catch (error) {\n console.error(\"Error updating bill:\", error);\n return c.json({\n success: false,\n message: \"Failed to update bill\"\n }, 500);\n }\n});\n\n// Delete bill (admin only)\nbills.delete(\"/:id\", authMiddleware, adminMiddleware, async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n \n const bill = await getBillById(id);\n if (!bill) {\n return c.json({\n success: false,\n message: \"Bill not found\"\n }, 404);\n }\n\n // Only allow deletion if bill is fully paid\n if (bill.remaining_amount > 0) {\n return c.json({\n success: false,\n message: \"Cannot delete bill with outstanding balance\"\n }, 400);\n }\n\n await deleteBill(id);\n \n return c.json({\n success: true,\n message: \"Bill deleted successfully\"\n });\n } catch (error) {\n console.error(\"Error deleting bill:\", error);\n return c.json({\n success: false,\n message: \"Failed to delete bill\"\n }, 500);\n }\n});\n\nexport default bills;",[],[153,228,238],"ebc6a584-39f7-11f0-9975-9e149126039e","auth.ts","ebc6a6ec-39f7-11f0-9975-9e149126039e",5,["D",1748239742375],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sign, verify } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { getUserByEmail, createUser, getCustomerById } from \"../database/queries.ts\";\nimport type { AuthResponse } from \"../../shared/types.ts\";\n\nconst auth = new Hono();\n\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"your-secret-key-change-in-production\";\n\n// Login endpoint\nauth.post(\"/login\", async (c) => {\n try {\n const { email, password } = await c.req.json();\n\n if (!email || !password) {\n return c.json({\n success: false,\n message: \"Email and password are required\"\n }, 400);\n }\n\n const user = await getUserByEmail(email);\n if (!user || user.password !== password) {\n return c.json({\n success: false,\n message: \"Invalid credentials\"\n }, 401);\n }\n\n const token = await sign(\n { \n userId: user.id, \n email: user.email, \n role: user.role,\n exp: Math.floor(Date.now() / 1000) + (24 * 60 * 60) // 24 hours\n },\n JWT_SECRET\n );\n\n const { password: _, ...userWithoutPassword } = user;\n\n return c.json({\n success: true,\n token,\n user: userWithoutPassword\n });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({\n success: false,\n message: \"Internal server error\"\n }, 500);\n }\n});\n\n// Register customer endpoint\nauth.post(\"/register\", async (c) => {\n try {\n const { email, password, name, phone } = await c.req.json();\n\n if (!email || !password || !name) {\n return c.json({\n success: false,\n message: \"Email, password, and name are required\"\n }, 400);\n }\n\n // Check if user already exists\n const existingUser = await getUserByEmail(email);\n if (existingUser) {\n return c.json({\n success: false,\n message: \"User already exists\"\n }, 409);\n }\n\n const userId = await createUser({\n email,\n password,\n name,\n phone,\n role: \"customer\"\n });\n\n const token = await sign(\n { \n userId, \n email, \n role: \"customer\",\n exp: Math.floor(Date.now() / 1000) + (24 * 60 * 60) // 24 hours\n },\n JWT_SECRET\n );\n\n return c.json({\n success: true,\n token,\n user: { id: userId, email, name, phone, role: \"customer\", created_at: new Date().toISOString() }\n });\n } catch (error) {\n console.error(\"Registration error:\", error);\n return c.json({\n success: false,\n message: \"Internal server error\"\n }, 500);\n }\n});\n\n// Verify token middleware\nexport async function authMiddleware(c: any, next: any) {\n const authHeader = c.req.header(\"Authorization\");\n \n if (!authHeader || !authHeader.startsWith(\"Bearer \")) {\n return c.json({ success: false, message: \"No token provided\" }, 401);\n }\n\n const token = authHeader.substring(7);\n\n try {\n const payload = await verify(token, JWT_SECRET);\n c.set(\"user\", payload);\n await next();\n } catch (error) {\n return c.json({ success: false, message: \"Invalid token\" }, 401);\n }\n}\n\n// Admin middleware\nexport async function adminMiddleware(c: any, next: any) {\n const user = c.get(\"user\");\n \n if (!user || user.role !== \"admin\") {\n return c.json({ success: false, message: \"Admin access required\" }, 403);\n }\n\n await next();\n}\n\n// Get current user\nauth.get(\"/me\", authMiddleware, async (c) => {\n const user = c.get(\"user\");\n return c.json({\n success: true,\n user: {\n id: user.userId,\n email: user.email,\n role: user.role\n }\n });\n});\n\nexport default auth;",[],[153,228,246],"ebc6c942-39f7-11f0-9975-9e149126039e",["D",1748239742375],[173,174,175,176],[153,228],"e1081d94-39f7-11f0-91a2-9e149126039e","queries.ts","e1081e5c-39f7-11f0-91a2-9e149126039e","6bb09401-7e6c-48f1-b709-163b1f793f95",4,["D",1748239724356],"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}",[],[153,266,258],"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}",[],[153,266,268],"cf931f14-39f7-11f0-9975-9e149126039e",["D",1748239695066],[170,171],[153,266],["D",1748239695066],[169,172,177],[153],["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":318,"_319":320,"_321":322,"_323":24,"_324":24,"_325":24,"_326":57,"_327":-5,"_328":-7,"_329":-7,"_330":61,"_331":24,"_332":24,"_333":-5,"_334":24,"_335":24,"_336":24,"_337":-5},"ENV",{"_289":290,"_291":292,"_293":85,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v11