Loading Fabrication Bill Generator...

\n \n \n\n",[],[270,272],"dca0eb36-39f8-11f0-957c-9e149126039e","PaymentModal.tsx","dca0ebd6-39f8-11f0-957c-9e149126039e","36d38fd4-7efb-4a3f-8ff1-55cb43b71be3",18,["D",1748240146460],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Bill } from \"../../shared/types.ts\";\n\ninterface PaymentModalProps {\n bill: Bill;\n token: string;\n onClose: () => void;\n onPaymentSuccess: () => void;\n}\n\nexport default function PaymentModal({ bill, token, onClose, onPaymentSuccess }: PaymentModalProps) {\n const [paymentData, setPaymentData] = useState({\n amount: bill.remaining_amount,\n payment_method: 'cash',\n notes: ''\n });\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState('');\n\n const paymentMethods = [\n { value: 'cash', label: '💵 Cash', color: 'green' },\n { value: 'card', label: '💳 Credit/Debit Card', color: 'blue' },\n { value: 'bank_transfer', label: '🏦 Bank Transfer', color: 'purple' },\n { value: 'check', label: '📝 Check', color: 'orange' }\n ];\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n if (paymentData.amount <= 0) {\n setError('Payment amount must be greater than zero');\n setLoading(false);\n return;\n }\n\n if (paymentData.amount > bill.remaining_amount) {\n setError(`Payment amount cannot exceed remaining balance of $${bill.remaining_amount.toFixed(2)}`);\n setLoading(false);\n return;\n }\n\n try {\n const response = await fetch(`/api/payments/bill/${bill.id}`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify(paymentData)\n });\n\n const data = await response.json();\n\n if (response.ok) {\n onPaymentSuccess();\n } else {\n setError(data.message || 'Failed to process payment');\n }\n } catch (error) {\n setError('Network error. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n const handleAmountChange = (e: React.ChangeEvent) => {\n const value = parseFloat(e.target.value) || 0;\n setPaymentData(prev => ({ ...prev, amount: value }));\n };\n\n const setFullAmount = () => {\n setPaymentData(prev => ({ ...prev, amount: bill.remaining_amount }));\n };\n\n const setPartialAmount = (percentage: number) => {\n const amount = bill.remaining_amount * (percentage / 100);\n setPaymentData(prev => ({ ...prev, amount: Math.round(amount * 100) / 100 }));\n };\n\n return (\n

Make Payment

\n \n ✕\n \n

\n\n

\n {/* Bill Summary */}\n

Bill Summary

\n Bill Number:\n {bill.bill_number}\n

\n Total Amount:\n ${bill.total_amount.toFixed(2)}\n

\n Paid Amount:\n ${bill.paid_amount.toFixed(2)}\n

\n Remaining Balance:\n ${bill.remaining_amount.toFixed(2)}\n

\n\n

\n {error && (\n

\n {error}\n

\n )}\n\n {/* Payment Amount */}\n

\n \n Payment Amount ($)\n \n \n \n {/* Quick Amount Buttons */}\n

\n \n Full Amount (${bill.remaining_amount.toFixed(2)})\n \n setPartialAmount(50)}\n className=\"bg-blue-100 text-blue-800 px-3 py-1 rounded-md hover:bg-blue-200 transition-colors text-sm\"\n >\n 50% (${(bill.remaining_amount * 0.5).toFixed(2)})\n \n setPartialAmount(25)}\n className=\"bg-yellow-100 text-yellow-800 px-3 py-1 rounded-md hover:bg-yellow-200 transition-colors text-sm\"\n >\n 25% (${(bill.remaining_amount * 0.25).toFixed(2)})\n \n

\n\n {/* Payment Method */}\n

\n \n Payment Method\n \n

\n {paymentMethods.map((method) => (\n \n setPaymentData(prev => ({ ...prev, payment_method: e.target.value }))}\n className=\"sr-only\"\n />\n {method.label.split(' ')[0]}\n {method.label.substring(2)}\n {paymentData.payment_method === method.value && (\n ✓\n )}\n \n ))}\n

\n\n {/* Payment Notes */}\n

\n \n Notes (Optional)\n \n setPaymentData(prev => ({ ...prev, notes: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"Add any notes about this payment...\"\n />\n

\n\n {/* Payment Summary */}\n

Payment Summary

\n Payment Amount:\n ${paymentData.amount.toFixed(2)}\n

\n Remaining After Payment:\n \n ${Math.max(0, bill.remaining_amount - paymentData.amount).toFixed(2)}\n \n

\n Payment Method:\n \n {paymentMethods.find(m => m.value === paymentData.payment_method)?.label.substring(2)}\n \n

\n\n {/* Submit Buttons */}\n

\n \n Cancel\n \n \n {loading ? (\n

\n Processing...\n

\n ) : (\n `Process Payment ($${paymentData.amount.toFixed(2)})`\n )}\n \n

\n );\n}",[],[270,288,280],"components","43089244-39f8-11f0-9975-9e149126039e","Login.tsx","43089302-39f8-11f0-9975-9e149126039e",13,["D",1748239888774],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { User, AuthResponse } from \"../../shared/types.ts\";\n\ninterface LoginProps {\n onLogin: (user: User, token: string) => void;\n}\n\nexport default function Login({ onLogin }: LoginProps) {\n const [isLogin, setIsLogin] = useState(true);\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(\"\");\n const [formData, setFormData] = useState({\n email: \"\",\n password: \"\",\n name: \"\",\n phone: \"\"\n });\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(\"\");\n\n try {\n const endpoint = isLogin ? \"/api/auth/login\" : \"/api/auth/register\";\n const body = isLogin \n ? { email: formData.email, password: formData.password }\n : formData;\n\n const response = await fetch(endpoint, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\"\n },\n body: JSON.stringify(body)\n });\n\n const data: AuthResponse = await response.json();\n\n if (data.success && data.token && data.user) {\n onLogin(data.user as User, data.token);\n } else {\n setError(data.message || \"Authentication failed\");\n }\n } catch (error) {\n setError(\"Network error. Please try again.\");\n } finally {\n setLoading(false);\n }\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n setFormData(prev => ({\n ...prev,\n [e.target.name]: e.target.value\n }));\n };\n\n return (\n

🏭

\n Fabrication Bill Generator\n

\n {isLogin ? \"Sign in to your account\" : \"Create a new account\"}\n

\n\n

\n {error && (\n

\n {error}\n

\n )}\n\n {!isLogin && (\n <>\n

\n \n Full Name\n \n \n

\n\n

\n \n Phone Number\n \n \n

\n \n )}\n\n

\n \n Email Address\n \n \n

\n\n

\n \n Password\n \n \n

\n\n

\n \n {loading ? (\n

\n ) : (\n isLogin ? \"Sign In\" : \"Create Account\"\n )}\n \n

\n\n

\n {\n setIsLogin(!isLogin);\n setError(\"\");\n setFormData({ email: \"\", password: \"\", name: \"\", phone: \"\" });\n }}\n className=\"text-sm text-blue-600 hover:text-blue-500 transition-colors\"\n >\n {isLogin \n ? \"Don't have an account? Sign up\" \n : \"Already have an account? Sign in\"\n }\n \n

\n\n {isLogin && (\n

Demo Credentials:

\n Admin: admin@fabrication.com / admin123\n

\n )}\n

\n );\n}",[],[270,288,290],"76a27a7a-39f8-11f0-9505-9e149126039e","CustomerDashboard.tsx","76a27b2e-39f8-11f0-9505-9e149126039e",15,["D",1748239975348],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport BillList from \"./BillList.tsx\";\nimport type { Bill, User } from \"../../shared/types.ts\";\n\ninterface CustomerDashboardProps {\n token: string;\n user: User;\n}\n\nexport default function CustomerDashboard({ token, user }: CustomerDashboardProps) {\n const [bills, setBills] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n loadBills();\n }, []);\n\n const loadBills = async () => {\n setLoading(true);\n try {\n const response = await fetch(\"/api/bills\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n if (response.ok) {\n const data = await response.json();\n setBills(data.data || []);\n }\n } catch (error) {\n console.error(\"Error loading bills:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const stats = {\n totalBills: bills.length,\n pendingBills: bills.filter(b => b.status === 'pending').length,\n partialBills: bills.filter(b => b.status === 'partial').length,\n paidBills: bills.filter(b => b.status === 'paid').length,\n totalAmount: bills.reduce((sum, b) => sum + b.total_amount, 0),\n outstandingAmount: bills.reduce((sum, b) => sum + b.remaining_amount, 0)\n };\n\n if (loading) {\n return (\n

Loading your bills...

\n );\n }\n\n return (\n

\n {/* Welcome Section */}\n

\n Welcome back, {user.name}! 👋\n

\n Here's an overview of your fabrication bills and payment status.\n

\n\n {/* Stats Overview */}\n

{stats.totalBills}

Total Bills

{stats.pendingBills}

Pending

{stats.partialBills}

Partial

{stats.paidBills}

Paid

${stats.totalAmount.toFixed(2)}

Total Amount

${stats.outstandingAmount.toFixed(2)}

Outstanding

\n\n {/* Bills Section */}\n

Your Bills

\n View and manage your fabrication bills and payments\n

\n {bills.length === 0 ? (\n

📋

No bills yet

\n You don't have any bills assigned to you at the moment.\n

\n ) : (\n \n )}\n

\n\n {/* Quick Actions */}\n {stats.outstandingAmount > 0 && (\n

⚠️

\n Outstanding Balance: ${stats.outstandingAmount.toFixed(2)}\n

\n You have {stats.pendingBills + stats.partialBills} bill(s) with outstanding payments. \n Click on any bill to make a payment.\n

\n )}\n

\n );\n}",[],[270,288,298],"f3f7f086-39f8-11f0-8627-9e149126039e","BillPDF.tsx","f3f7f126-39f8-11f0-8627-9e149126039e",19,["D",1748240185623],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Bill } from \"../../shared/types.ts\";\n\ninterface BillPDFProps {\n bill: Bill;\n}\n\nexport default function BillPDF({ bill }: BillPDFProps) {\n const generatePDF = async () => {\n try {\n // Dynamic import of jsPDF\n const { jsPDF } = await import(\"https://esm.sh/jspdf@2.5.1\");\n \n const doc = new jsPDF();\n const pageWidth = doc.internal.pageSize.width;\n const margin = 20;\n let yPosition = margin;\n\n // Helper function to add text with automatic line wrapping\n const addText = (text: string, x: number, y: number, options: any = {}) => {\n const maxWidth = options.maxWidth || pageWidth - 2 * margin;\n const lines = doc.splitTextToSize(text, maxWidth);\n doc.text(lines, x, y, options);\n return y + (lines.length * (options.lineHeight || 6));\n };\n\n // Header\n doc.setFontSize(24);\n doc.setFont(undefined, 'bold');\n yPosition = addText('FABRICATION BILL', margin, yPosition);\n \n yPosition += 10;\n \n // Company info (you can customize this)\n doc.setFontSize(12);\n doc.setFont(undefined, 'normal');\n yPosition = addText('Fabrication Company', margin, yPosition);\n yPosition = addText('123 Industrial Street', margin, yPosition);\n yPosition = addText('Manufacturing City, MC 12345', margin, yPosition);\n yPosition = addText('Phone: (555) 123-4567', margin, yPosition);\n \n yPosition += 15;\n\n // Bill details\n doc.setFontSize(14);\n doc.setFont(undefined, 'bold');\n yPosition = addText('BILL DETAILS', margin, yPosition);\n \n yPosition += 5;\n doc.setFontSize(11);\n doc.setFont(undefined, 'normal');\n \n // Two column layout for bill info\n const leftCol = margin;\n const rightCol = pageWidth / 2 + 10;\n \n // Left column\n let leftY = yPosition;\n doc.setFont(undefined, 'bold');\n doc.text('Bill Number:', leftCol, leftY);\n doc.setFont(undefined, 'normal');\n doc.text(bill.bill_number, leftCol + 30, leftY);\n \n leftY += 7;\n doc.setFont(undefined, 'bold');\n doc.text('Date Created:', leftCol, leftY);\n doc.setFont(undefined, 'normal');\n doc.text(new Date(bill.created_at).toLocaleDateString(), leftCol + 30, leftY);\n \n leftY += 7;\n doc.setFont(undefined, 'bold');\n doc.text('Due Date:', leftCol, leftY);\n doc.setFont(undefined, 'normal');\n doc.text(new Date(bill.due_date).toLocaleDateString(), leftCol + 30, leftY);\n \n leftY += 7;\n doc.setFont(undefined, 'bold');\n doc.text('Status:', leftCol, leftY);\n doc.setFont(undefined, 'normal');\n doc.text(bill.status.toUpperCase(), leftCol + 30, leftY);\n\n // Right column - Customer info\n let rightY = yPosition;\n doc.setFont(undefined, 'bold');\n doc.text('BILL TO:', rightCol, rightY);\n \n rightY += 7;\n doc.setFont(undefined, 'normal');\n doc.text(bill.customer_name || '', rightCol, rightY);\n \n if (bill.customer_email) {\n rightY += 7;\n doc.text(bill.customer_email, rightCol, rightY);\n }\n \n if (bill.customer_phone) {\n rightY += 7;\n doc.text(bill.customer_phone, rightCol, rightY);\n }\n\n yPosition = Math.max(leftY, rightY) + 15;\n\n // Description\n doc.setFont(undefined, 'bold');\n yPosition = addText('DESCRIPTION:', margin, yPosition);\n yPosition += 3;\n doc.setFont(undefined, 'normal');\n yPosition = addText(bill.description, margin, yPosition, { maxWidth: pageWidth - 2 * margin });\n \n yPosition += 15;\n\n // Items table\n doc.setFont(undefined, 'bold');\n yPosition = addText('ITEMS:', margin, yPosition);\n yPosition += 5;\n\n // Table headers\n const tableStartY = yPosition;\n const colWidths = [80, 25, 35, 35]; // Description, Qty, Unit Price, Total\n const colPositions = [margin, margin + colWidths[0], margin + colWidths[0] + colWidths[1], margin + colWidths[0] + colWidths[1] + colWidths[2]];\n\n // Draw table border\n doc.rect(margin, tableStartY, pageWidth - 2 * margin, 10);\n \n // Headers\n doc.setFontSize(10);\n doc.setFont(undefined, 'bold');\n doc.text('Description', colPositions[0] + 2, tableStartY + 7);\n doc.text('Qty', colPositions[1] + 2, tableStartY + 7);\n doc.text('Unit Price', colPositions[2] + 2, tableStartY + 7);\n doc.text('Total', colPositions[3] + 2, tableStartY + 7);\n\n yPosition = tableStartY + 10;\n\n // Table rows\n doc.setFont(undefined, 'normal');\n bill.items.forEach((item, index) => {\n const rowHeight = 8;\n \n // Draw row border\n doc.rect(margin, yPosition, pageWidth - 2 * margin, rowHeight);\n \n // Draw vertical lines\n colPositions.slice(1).forEach(pos => {\n doc.line(pos, tableStartY, pos, yPosition + rowHeight);\n });\n\n // Add item data\n const descLines = doc.splitTextToSize(item.description, colWidths[0] - 4);\n doc.text(descLines[0], colPositions[0] + 2, yPosition + 5);\n doc.text(item.quantity.toString(), colPositions[1] + 2, yPosition + 5);\n doc.text(`$${item.unit_price.toFixed(2)}`, colPositions[2] + 2, yPosition + 5);\n doc.text(`$${item.total.toFixed(2)}`, colPositions[3] + 2, yPosition + 5);\n\n yPosition += rowHeight;\n });\n\n yPosition += 10;\n\n // Totals\n const totalsX = pageWidth - 80;\n doc.setFont(undefined, 'normal');\n doc.text('Subtotal:', totalsX - 30, yPosition);\n doc.text(`$${bill.subtotal.toFixed(2)}`, totalsX, yPosition);\n \n yPosition += 7;\n doc.text(`Tax (${bill.tax_rate}%):`, totalsX - 30, yPosition);\n doc.text(`$${bill.tax_amount.toFixed(2)}`, totalsX, yPosition);\n \n yPosition += 7;\n doc.setFont(undefined, 'bold');\n doc.text('Total:', totalsX - 30, yPosition);\n doc.text(`$${bill.total_amount.toFixed(2)}`, totalsX, yPosition);\n \n yPosition += 7;\n doc.setFont(undefined, 'normal');\n doc.setTextColor(0, 150, 0); // Green\n doc.text('Paid:', totalsX - 30, yPosition);\n doc.text(`$${bill.paid_amount.toFixed(2)}`, totalsX, yPosition);\n \n yPosition += 7;\n doc.setTextColor(200, 0, 0); // Red\n doc.text('Remaining:', totalsX - 30, yPosition);\n doc.text(`$${bill.remaining_amount.toFixed(2)}`, totalsX, yPosition);\n\n // Reset text color\n doc.setTextColor(0, 0, 0);\n\n // Footer\n yPosition = doc.internal.pageSize.height - 30;\n doc.setFontSize(9);\n doc.setFont(undefined, 'italic');\n yPosition = addText('Thank you for your business!', margin, yPosition);\n yPosition = addText('Please remit payment by the due date to avoid late fees.', margin, yPosition);\n\n // Save the PDF\n doc.save(`${bill.bill_number}.pdf`);\n } catch (error) {\n console.error('Error generating PDF:', error);\n alert('Failed to generate PDF. Please try again.');\n }\n };\n\n return (\n \n 📄 Download PDF\n \n );\n}",[],[270,288,306],"c1df5b2a-39f8-11f0-86ca-9e149126039e","BillList.tsx","c1df5c1a-39f8-11f0-86ca-9e149126039e",17,["D",1748240101573],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport PaymentModal from \"./PaymentModal.tsx\";\nimport BillPDF from \"./BillPDF.tsx\";\nimport type { Bill, Payment } from \"../../shared/types.ts\";\n\ninterface BillListProps {\n bills: Bill[];\n token: string;\n onBillUpdated: () => void;\n onEditBill?: (bill: Bill) => void;\n isAdmin: boolean;\n}\n\nexport default function BillList({ bills, token, onBillUpdated, onEditBill, isAdmin }: BillListProps) {\n const [selectedBill, setSelectedBill] = useState(null);\n const [showPaymentModal, setShowPaymentModal] = useState(false);\n const [showBillDetails, setShowBillDetails] = useState(null);\n const [payments, setPayments] = useState([]);\n const [loadingPayments, setLoadingPayments] = useState(false);\n\n const handleViewBill = async (bill: Bill) => {\n setShowBillDetails(bill);\n setLoadingPayments(true);\n \n try {\n const response = await fetch(`/api/payments/bill/${bill.id}`, {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n if (response.ok) {\n const data = await response.json();\n setPayments(data.data || []);\n }\n } catch (error) {\n console.error(\"Error loading payments:\", error);\n } finally {\n setLoadingPayments(false);\n }\n };\n\n const handlePayBill = (bill: Bill) => {\n setSelectedBill(bill);\n setShowPaymentModal(true);\n };\n\n const handlePaymentSuccess = () => {\n setShowPaymentModal(false);\n setSelectedBill(null);\n onBillUpdated();\n if (showBillDetails) {\n handleViewBill(showBillDetails);\n }\n };\n\n const handleDeleteBill = async (bill: Bill) => {\n if (!confirm(`Are you sure you want to delete bill ${bill.bill_number}? This action cannot be undone.`)) {\n return;\n }\n\n try {\n const response = await fetch(`/api/bills/${bill.id}`, {\n method: 'DELETE',\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n\n if (response.ok) {\n onBillUpdated();\n if (showBillDetails?.id === bill.id) {\n setShowBillDetails(null);\n }\n } else {\n const data = await response.json();\n alert(data.message || 'Failed to delete bill');\n }\n } catch (error) {\n console.error(\"Error deleting bill:\", error);\n alert('Failed to delete bill');\n }\n };\n\n const getStatusBadge = (status: string) => {\n const baseClasses = \"px-2 py-1 text-xs font-medium rounded-full\";\n switch (status) {\n case 'paid':\n return `${baseClasses} bg-green-100 text-green-800`;\n case 'partial':\n return `${baseClasses} bg-blue-100 text-blue-800`;\n default:\n return `${baseClasses} bg-yellow-100 text-yellow-800`;\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString();\n };\n\n if (bills.length === 0) {\n return (\n

📋

No bills found

\n {isAdmin ? \"Create your first bill to get started.\" : \"No bills have been assigned to you yet.\"}\n

\n );\n }\n\n return (\n <>\n

\n {bills.map((bill) => (\n

\n {bill.bill_number}\n

\n \n {bill.status.charAt(0).toUpperCase() + bill.status.slice(1)}\n \n

\n \n

\n Customer:\n

{bill.customer_name}

\n {bill.customer_phone &&

📞 {bill.customer_phone}

}\n

\n Total Amount:\n

${bill.total_amount.toFixed(2)}

\n Paid:\n

${bill.paid_amount.toFixed(2)}

\n Remaining:\n

${bill.remaining_amount.toFixed(2)}

\n \n

Due Date: {formatDate(bill.due_date)}

{bill.description}

\n\n

\n handleViewBill(bill)}\n className=\"bg-blue-600 text-white px-3 py-2 rounded-md hover:bg-blue-700 transition-colors text-sm\"\n >\n 📄 View Details\n \n \n {bill.remaining_amount > 0 && (\n handlePayBill(bill)}\n className=\"bg-green-600 text-white px-3 py-2 rounded-md hover:bg-green-700 transition-colors text-sm\"\n >\n 💳 Pay Bill\n \n )}\n \n {isAdmin && onEditBill && (\n onEditBill(bill)}\n className=\"bg-yellow-600 text-white px-3 py-2 rounded-md hover:bg-yellow-700 transition-colors text-sm\"\n >\n ✏️ Edit\n \n )}\n \n {isAdmin && bill.remaining_amount === 0 && (\n handleDeleteBill(bill)}\n className=\"bg-red-600 text-white px-3 py-2 rounded-md hover:bg-red-700 transition-colors text-sm\"\n >\n 🗑️ Delete\n \n )}\n

\n ))}\n

\n\n {/* Bill Details Modal */}\n {showBillDetails && (\n

Bill Details - {showBillDetails.bill_number}

\n setShowBillDetails(null)}\n className=\"text-gray-400 hover:text-gray-600 transition-colors\"\n >\n ✕\n \n

\n\n

\n {/* Bill Information */}\n

Customer Information

Name: {showBillDetails.customer_name}

Email: {showBillDetails.customer_email}

Phone: {showBillDetails.customer_phone}

\n \n

Bill Information

Status: \n \n {showBillDetails.status.charAt(0).toUpperCase() + showBillDetails.status.slice(1)}\n \n

Created: {formatDate(showBillDetails.created_at)}

Due Date: {formatDate(showBillDetails.due_date)}

\n\n {/* Description */}\n

Description

{showBillDetails.description}

\n\n {/* Items */}\n

Items

\n \n \n \n \n \n \n \n \n \n \n {showBillDetails.items.map((item, index) => (\n \n \n \n \n \n \n ))}\n \n

Description	Quantity	Unit Price	Total
{item.description}	{item.quantity}	${item.unit_price.toFixed(2)}	${item.total.toFixed(2)}

\n\n {/* Totals */}\n

\n Subtotal:\n ${showBillDetails.subtotal.toFixed(2)}\n

\n Tax ({showBillDetails.tax_rate}%):\n ${showBillDetails.tax_amount.toFixed(2)}\n

\n Total:\n ${showBillDetails.total_amount.toFixed(2)}\n

\n Paid:\n ${showBillDetails.paid_amount.toFixed(2)}\n

\n Remaining:\n ${showBillDetails.remaining_amount.toFixed(2)}\n

\n\n {/* Payment History */}\n

Payment History

\n {loadingPayments ? (\n

Loading payments...

\n ) : payments.length === 0 ? (\n

No payments recorded yet.

\n ) : (\n

\n {payments.map((payment) => (\n

${payment.amount.toFixed(2)}

\n {payment.payment_method} • {formatDate(payment.payment_date)}\n

\n {payment.notes && (\n

{payment.notes}

\n )}\n

\n ))}\n

\n )}\n

\n\n {/* Actions */}\n

\n \n \n {showBillDetails.remaining_amount > 0 && (\n {\n setSelectedBill(showBillDetails);\n setShowPaymentModal(true);\n }}\n className=\"bg-green-600 text-white px-4 py-2 rounded-md hover:bg-green-700 transition-colors\"\n >\n 💳 Make Payment\n \n )}\n \n {isAdmin && onEditBill && (\n {\n onEditBill(showBillDetails);\n setShowBillDetails(null);\n }}\n className=\"bg-yellow-600 text-white px-4 py-2 rounded-md hover:bg-yellow-700 transition-colors\"\n >\n ✏️ Edit Bill\n \n )}\n

\n )}\n\n {/* Payment Modal */}\n {showPaymentModal && selectedBill && (\n setShowPaymentModal(false)}\n onPaymentSuccess={handlePaymentSuccess}\n />\n )}\n \n );\n}",[],[270,288,314],"9a91609a-39f8-11f0-9def-9e149126039e","BillForm.tsx","9a91613a-39f8-11f0-9def-9e149126039e",16,["D",1748240035634],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Customer, BillItem, Bill } from \"../../shared/types.ts\";\n\ninterface BillFormProps {\n token: string;\n customers: Customer[];\n onBillCreated: () => void;\n onCustomerCreated: () => void;\n editingBill?: Bill | null;\n onCancelEdit?: () => void;\n}\n\nexport default function BillForm({ \n token, \n customers, \n onBillCreated, \n onCustomerCreated,\n editingBill,\n onCancelEdit\n}: BillFormProps) {\n const [showCustomerForm, setShowCustomerForm] = useState(false);\n const [loading, setLoading] = useState(false);\n const [customerFormData, setCustomerFormData] = useState({\n name: '',\n email: '',\n phone: '',\n address: ''\n });\n\n const [billFormData, setBillFormData] = useState({\n customer_id: 0,\n description: '',\n tax_rate: 10,\n due_date: ''\n });\n\n const [items, setItems] = useState([\n { description: '', quantity: 1, unit_price: 0, total: 0 }\n ]);\n\n // Initialize form when editing\n useEffect(() => {\n if (editingBill) {\n setBillFormData({\n customer_id: editingBill.customer_id,\n description: editingBill.description,\n tax_rate: editingBill.tax_rate,\n due_date: editingBill.due_date\n });\n setItems(editingBill.items);\n } else {\n // Reset form for new bill\n setBillFormData({\n customer_id: 0,\n description: '',\n tax_rate: 10,\n due_date: ''\n });\n setItems([{ description: '', quantity: 1, unit_price: 0, total: 0 }]);\n }\n }, [editingBill]);\n\n const handleCustomerSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n\n try {\n const response = await fetch('/api/bills/customers', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify(customerFormData)\n });\n\n if (response.ok) {\n onCustomerCreated();\n setShowCustomerForm(false);\n setCustomerFormData({ name: '', email: '', phone: '', address: '' });\n }\n } catch (error) {\n console.error('Error creating customer:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleItemChange = (index: number, field: keyof BillItem, value: string | number) => {\n const newItems = [...items];\n newItems[index] = { ...newItems[index], [field]: value };\n \n // Recalculate total for this item\n if (field === 'quantity' || field === 'unit_price') {\n newItems[index].total = newItems[index].quantity * newItems[index].unit_price;\n }\n \n setItems(newItems);\n };\n\n const addItem = () => {\n setItems([...items, { description: '', quantity: 1, unit_price: 0, total: 0 }]);\n };\n\n const removeItem = (index: number) => {\n if (items.length > 1) {\n setItems(items.filter((_, i) => i !== index));\n }\n };\n\n const calculateSubtotal = () => {\n return items.reduce((sum, item) => sum + item.total, 0);\n };\n\n const calculateTax = () => {\n return calculateSubtotal() * (billFormData.tax_rate / 100);\n };\n\n const calculateTotal = () => {\n return calculateSubtotal() + calculateTax();\n };\n\n const handleBillSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n\n try {\n const url = editingBill ? `/api/bills/${editingBill.id}` : '/api/bills';\n const method = editingBill ? 'PUT' : 'POST';\n\n const response = await fetch(url, {\n method,\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify({\n ...billFormData,\n items: items.filter(item => item.description.trim() !== '')\n })\n });\n\n if (response.ok) {\n onBillCreated();\n }\n } catch (error) {\n console.error('Error saving bill:', error);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n {editingBill ? 'Edit Bill' : 'Create New Bill'}\n

\n {editingBill && onCancelEdit && (\n \n ← Back to Bills\n \n )}\n

\n\n {/* Customer Selection */}\n

Customer Information

\n setShowCustomerForm(!showCustomerForm)}\n className=\"text-blue-600 hover:text-blue-700 text-sm transition-colors\"\n >\n {showCustomerForm ? 'Cancel' : '+ Add New Customer'}\n \n

\n\n {showCustomerForm ? (\n

\n Name\n setCustomerFormData(prev => ({ ...prev, name: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Email\n setCustomerFormData(prev => ({ ...prev, email: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Phone\n setCustomerFormData(prev => ({ ...prev, phone: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Address\n setCustomerFormData(prev => ({ ...prev, address: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n \n {loading ? 'Creating...' : 'Create Customer'}\n \n

\n ) : (\n

\n Select Customer\n setBillFormData(prev => ({ ...prev, customer_id: parseInt(e.target.value) }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n >\n \n {customers.map(customer => (\n \n ))}\n \n

\n )}\n

\n\n {/* Bill Form */}\n

\n {/* Bill Details */}\n

Bill Details

\n Description\n setBillFormData(prev => ({ ...prev, description: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"Describe the fabrication work...\"\n />\n

\n Tax Rate (%)\n setBillFormData(prev => ({ ...prev, tax_rate: parseFloat(e.target.value) || 0 }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Due Date\n setBillFormData(prev => ({ ...prev, due_date: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n\n {/* Items */}\n

Bill Items

\n \n + Add Item\n \n

\n\n

\n {items.map((item, index) => (\n

\n Description\n handleItemChange(index, 'description', e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"Item description...\"\n />\n

\n Quantity\n handleItemChange(index, 'quantity', parseFloat(e.target.value) || 1)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Unit Price ($)\n handleItemChange(index, 'unit_price', parseFloat(e.target.value) || 0)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Total\n

\n ${item.total.toFixed(2)}\n

\n {items.length > 1 && (\n removeItem(index)}\n className=\"ml-2 text-red-600 hover:text-red-700 transition-colors\"\n >\n 🗑️\n \n )}\n

\n ))}\n

\n\n {/* Totals */}\n

\n Subtotal:\n ${calculateSubtotal().toFixed(2)}\n

\n Tax ({billFormData.tax_rate}%):\n ${calculateTax().toFixed(2)}\n

\n Total:\n ${calculateTotal().toFixed(2)}\n

\n\n {/* Submit Button */}\n

\n {editingBill && onCancelEdit && (\n \n Cancel\n \n )}\n \n {loading ? 'Saving...' : editingBill ? 'Update Bill' : 'Create Bill'}\n \n

\n );\n}",[],[270,288,322],"330005b2-39f8-11f0-9109-9e149126039e","App.tsx","33000666-39f8-11f0-9109-9e149126039e",12,["D",1748239861875],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport Login from \"./Login.tsx\";\nimport AdminDashboard from \"./AdminDashboard.tsx\";\nimport CustomerDashboard from \"./CustomerDashboard.tsx\";\nimport type { User } from \"../../shared/types.ts\";\n\ninterface AppState {\n user: User | null;\n loading: boolean;\n token: string | null;\n}\n\nexport default function App() {\n const [state, setState] = useState({\n user: null,\n loading: true,\n token: localStorage.getItem(\"token\")\n });\n\n useEffect(() => {\n checkAuth();\n }, []);\n\n const checkAuth = async () => {\n const token = localStorage.getItem(\"token\");\n if (!token) {\n setState(prev => ({ ...prev, loading: false }));\n return;\n }\n\n try {\n const response = await fetch(\"/api/auth/me\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n\n if (response.ok) {\n const data = await response.json();\n setState({\n user: data.user,\n loading: false,\n token\n });\n } else {\n localStorage.removeItem(\"token\");\n setState({\n user: null,\n loading: false,\n token: null\n });\n }\n } catch (error) {\n console.error(\"Auth check failed:\", error);\n localStorage.removeItem(\"token\");\n setState({\n user: null,\n loading: false,\n token: null\n });\n }\n };\n\n const handleLogin = (user: User, token: string) => {\n localStorage.setItem(\"token\", token);\n setState({\n user,\n loading: false,\n token\n });\n };\n\n const handleLogout = () => {\n localStorage.removeItem(\"token\");\n setState({\n user: null,\n loading: false,\n token: null\n });\n };\n\n if (state.loading) {\n return (\n

\n );\n }\n\n if (!state.user) {\n return ;\n }\n\n return (\n

\n 🏭\n Fabrication Bill Generator\n

\n \n Welcome, {state.user.name}\n \n \n {state.user.role}\n \n \n Logout\n \n

\n\n

\n {state.user.role === 'admin' ? (\n \n ) : (\n \n )}\n

\n );\n}",[],[270,288,330],"6416d8e2-39f8-11f0-8ebe-9e149126039e","AdminDashboard.tsx","6416d9aa-39f8-11f0-8ebe-9e149126039e",14,["D",1748239944233],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport BillForm from \"./BillForm.tsx\";\nimport BillList from \"./BillList.tsx\";\nimport type { Bill, Customer } from \"../../shared/types.ts\";\n\ninterface AdminDashboardProps {\n token: string;\n}\n\ntype ActiveTab = 'bills' | 'create' | 'customers';\n\nexport default function AdminDashboard({ token }: AdminDashboardProps) {\n const [activeTab, setActiveTab] = useState('bills');\n const [bills, setBills] = useState([]);\n const [customers, setCustomers] = useState([]);\n const [loading, setLoading] = useState(true);\n const [editingBill, setEditingBill] = useState(null);\n\n useEffect(() => {\n loadData();\n }, []);\n\n const loadData = async () => {\n setLoading(true);\n try {\n await Promise.all([\n loadBills(),\n loadCustomers()\n ]);\n } catch (error) {\n console.error(\"Error loading data:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const loadBills = async () => {\n try {\n const response = await fetch(\"/api/bills\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n if (response.ok) {\n const data = await response.json();\n setBills(data.data || []);\n }\n } catch (error) {\n console.error(\"Error loading bills:\", error);\n }\n };\n\n const loadCustomers = async () => {\n try {\n const response = await fetch(\"/api/bills/customers\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n if (response.ok) {\n const data = await response.json();\n setCustomers(data.data || []);\n }\n } catch (error) {\n console.error(\"Error loading customers:\", error);\n }\n };\n\n const handleBillCreated = () => {\n loadBills();\n setActiveTab('bills');\n setEditingBill(null);\n };\n\n const handleEditBill = (bill: Bill) => {\n setEditingBill(bill);\n setActiveTab('create');\n };\n\n const handleCancelEdit = () => {\n setEditingBill(null);\n setActiveTab('bills');\n };\n\n const stats = {\n totalBills: bills.length,\n pendingBills: bills.filter(b => b.status === 'pending').length,\n paidBills: bills.filter(b => b.status === 'paid').length,\n totalRevenue: bills.reduce((sum, b) => sum + b.total_amount, 0),\n outstandingAmount: bills.reduce((sum, b) => sum + b.remaining_amount, 0)\n };\n\n if (loading) {\n return (\n

Loading dashboard...

\n );\n }\n\n return (\n

\n {/* Stats Overview */}\n

{stats.totalBills}

Total Bills

{stats.pendingBills}

Pending

{stats.paidBills}

Paid

${stats.totalRevenue.toFixed(2)}

Total Revenue

${stats.outstandingAmount.toFixed(2)}

Outstanding

\n\n {/* Navigation Tabs */}\n

\n setActiveTab('bills')}\n className={`py-2 px-1 border-b-2 font-medium text-sm transition-colors ${\n activeTab === 'bills'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n 📋 Bills ({bills.length})\n \n {\n setActiveTab('create');\n setEditingBill(null);\n }}\n className={`py-2 px-1 border-b-2 font-medium text-sm transition-colors ${\n activeTab === 'create'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n ➕ {editingBill ? 'Edit Bill' : 'Create Bill'}\n \n setActiveTab('customers')}\n className={`py-2 px-1 border-b-2 font-medium text-sm transition-colors ${\n activeTab === 'customers'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n 👥 Customers ({customers.length})\n \n

\n\n {/* Tab Content */}\n

\n {activeTab === 'bills' && (\n \n )}\n \n {activeTab === 'create' && (\n \n )}\n \n {activeTab === 'customers' && (\n \n )}\n

\n );\n}\n\n// Customer List Component\nfunction CustomerList({ customers, token, onCustomerUpdated }: {\n customers: Customer[];\n token: string;\n onCustomerUpdated: () => void;\n}) {\n const [showForm, setShowForm] = useState(false);\n const [editingCustomer, setEditingCustomer] = useState(null);\n const [formData, setFormData] = useState({\n name: '',\n email: '',\n phone: '',\n address: ''\n });\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n try {\n const url = editingCustomer \n ? `/api/bills/customers/${editingCustomer.id}`\n : '/api/bills/customers';\n \n const method = editingCustomer ? 'PUT' : 'POST';\n \n const response = await fetch(url, {\n method,\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify(formData)\n });\n\n if (response.ok) {\n onCustomerUpdated();\n setShowForm(false);\n setEditingCustomer(null);\n setFormData({ name: '', email: '', phone: '', address: '' });\n }\n } catch (error) {\n console.error('Error saving customer:', error);\n }\n };\n\n const handleEdit = (customer: Customer) => {\n setEditingCustomer(customer);\n setFormData({\n name: customer.name,\n email: customer.email,\n phone: customer.phone,\n address: customer.address\n });\n setShowForm(true);\n };\n\n const handleCancel = () => {\n setShowForm(false);\n setEditingCustomer(null);\n setFormData({ name: '', email: '', phone: '', address: '' });\n };\n\n return (\n

Customer Management

\n setShowForm(true)}\n className=\"bg-blue-600 text-white px-4 py-2 rounded-md hover:bg-blue-700 transition-colors\"\n >\n Add Customer\n \n

\n\n {showForm && (\n

\n {editingCustomer ? 'Edit Customer' : 'Add New Customer'}\n

\n Name\n setFormData(prev => ({ ...prev, name: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Email\n setFormData(prev => ({ ...prev, email: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Phone\n setFormData(prev => ({ ...prev, phone: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Address\n setFormData(prev => ({ ...prev, address: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n \n {editingCustomer ? 'Update' : 'Create'} Customer\n \n \n Cancel\n \n

\n )}\n\n

\n \n \n \n \n \n \n \n \n \n \n \n {customers.map((customer) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Name\n	\n Email\n	\n Phone\n	\n Address\n	\n Actions\n
\n {customer.name}\n	\n {customer.email}\n	\n {customer.phone}\n	\n {customer.address}\n	\n handleEdit(customer)}\n className=\"text-blue-600 hover:text-blue-900 transition-colors\"\n >\n Edit\n \n

\n );\n}",[],[270,288,338],"3300265a-39f8-11f0-9109-9e149126039e",["D",1748239861875],[226,227,228,229,230,231,232,233],[270,288],"233ac090-39f8-11f0-addd-9e149126039e",["D",1748239835415],[225,234,235],[270],"daa1206a-3bc6-11f0-8484-9e149126039e","index.ts",28,["D",1748438570596],"http","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.fetch; // This is the entry point for HTTP vals",[],[182,354],["D",1748239805407],[],[182,102,100],["D",1748239796873],[],[182,102,91],["D",1748239775125],[],[182,102,82],["D",1748239742375],[],[182,102,67],["D",1748239742375],[219,220,221,222],[182,102],"cfbb5076-3bc6-11f0-8ef3-9e149126039e","queries.ts","e1081e5c-39f7-11f0-91a2-9e149126039e","6bb09401-7e6c-48f1-b709-163b1f793f95",27,["D",1748438552307],"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.rows[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}",[],[182,385,377],"database","cbf12178-3bc6-11f0-b6d7-9e149126039e","migrations.ts","cf9314ba-39f7-11f0-9975-9e149126039e",26,["D",1748438545954],"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.rows.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}",[],[182,385,387],"cf931f14-39f7-11f0-9975-9e149126039e",3,["D",1748239695066],[216,217],[182,385],"cf931d70-39f7-11f0-9975-9e149126039e",["D",1748239695066],[215,218,223],[182],["D",1748239636364],{"_11":12,"_152":73},{"_11":12,"_148":-5,"_72":73,"_31":71,"_149":150,"_151":30},{"_42":139,"_13":16,"_36":39,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":14,"_147":12},"ctx",{"_55":-5,"_171":440,"_441":442,"_443":444,"_445":30,"_446":30,"_447":30,"_448":24,"_449":-5,"_450":-7,"_451":-7,"_452":26,"_453":30,"_454":30,"_455":-5,"_456":30,"_457":30,"_458":30,"_459":-5},"ENV",{"_411":412,"_413":414,"_415":16,"_416":417,"_418":419,"_420":421,"_422":423,"_424":425,"_426":427,"_428":429,"_430":431,"_432":433,"_434":435,"_436":437,"_438":439},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5a709144666c9e69e88140f015c586412f0fd8d3","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"]

History · routes