Loading Shipping Operations Dashboard...

\n \n \n\n",[],[230,240],"5cc7d3f2-3f84-11f0-861e-76b3cceeab13","favicon.svg","5cc7d49c-3f84-11f0-861e-76b3cceeab13",13,["D",1748849817324],"",[],[230,248],"be3b8598-3f84-11f0-8ec6-76b3cceeab13","ShipmentForm.tsx","be3b8638-3f84-11f0-8ec6-76b3cceeab13","9b8ba031-f95a-4420-9b20-e72918323dc0",["D",1748849980823],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { CreateShipmentRequest, Carrier, ShippingRate } from \"../../shared/types.ts\";\nimport { isValidEmail, isValidPhone, isValidZipCode } from \"../../shared/utils.ts\";\n\ninterface ShipmentFormProps {\n onShipmentCreated: () => void;\n}\n\nexport default function ShipmentForm({ onShipmentCreated }: ShipmentFormProps) {\n const [formData, setFormData] = useState({\n origin: {\n street: '',\n city: '',\n state: '',\n zipCode: '',\n country: 'US'\n },\n destination: {\n street: '',\n city: '',\n state: '',\n zipCode: '',\n country: 'US'\n },\n sender: {\n name: '',\n phone: '',\n email: ''\n },\n recipient: {\n name: '',\n phone: '',\n email: ''\n },\n packages: [{\n weight: 1,\n dimensions: {\n length: 12,\n width: 12,\n height: 6\n },\n value: 100,\n description: '',\n fragile: false,\n hazardous: false\n }],\n serviceType: 'standard',\n carrier: 'ups',\n notes: ''\n });\n\n const [carriers, setCarriers] = useState([]);\n const [rates, setRates] = useState([]);\n const [loading, setLoading] = useState(false);\n const [errors, setErrors] = useState>({});\n const [step, setStep] = useState(1);\n\n useEffect(() => {\n loadCarriers();\n }, []);\n\n const loadCarriers = async () => {\n try {\n const response = await fetch('/api/routes/carriers');\n const result = await response.json();\n if (result.success) {\n setCarriers(result.data);\n }\n } catch (error) {\n console.error('Failed to load carriers:', error);\n }\n };\n\n const calculateRates = async () => {\n if (!formData.origin.zipCode || !formData.destination.zipCode || !formData.packages.length) {\n return;\n }\n\n try {\n const response = await fetch('/api/routes/rates', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n origin: formData.origin,\n destination: formData.destination,\n packages: formData.packages\n })\n });\n \n const result = await response.json();\n if (result.success) {\n setRates(result.data);\n }\n } catch (error) {\n console.error('Failed to calculate rates:', error);\n }\n };\n\n const validateForm = () => {\n const newErrors: Record = {};\n\n // Origin validation\n if (!formData.origin.street) newErrors['origin.street'] = 'Street address is required';\n if (!formData.origin.city) newErrors['origin.city'] = 'City is required';\n if (!formData.origin.state) newErrors['origin.state'] = 'State is required';\n if (!formData.origin.zipCode) newErrors['origin.zipCode'] = 'ZIP code is required';\n else if (!isValidZipCode(formData.origin.zipCode)) newErrors['origin.zipCode'] = 'Invalid ZIP code';\n\n // Destination validation\n if (!formData.destination.street) newErrors['destination.street'] = 'Street address is required';\n if (!formData.destination.city) newErrors['destination.city'] = 'City is required';\n if (!formData.destination.state) newErrors['destination.state'] = 'State is required';\n if (!formData.destination.zipCode) newErrors['destination.zipCode'] = 'ZIP code is required';\n else if (!isValidZipCode(formData.destination.zipCode)) newErrors['destination.zipCode'] = 'Invalid ZIP code';\n\n // Sender validation\n if (!formData.sender.name) newErrors['sender.name'] = 'Sender name is required';\n if (!formData.sender.phone) newErrors['sender.phone'] = 'Sender phone is required';\n else if (!isValidPhone(formData.sender.phone)) newErrors['sender.phone'] = 'Invalid phone number';\n if (!formData.sender.email) newErrors['sender.email'] = 'Sender email is required';\n else if (!isValidEmail(formData.sender.email)) newErrors['sender.email'] = 'Invalid email address';\n\n // Recipient validation\n if (!formData.recipient.name) newErrors['recipient.name'] = 'Recipient name is required';\n if (!formData.recipient.phone) newErrors['recipient.phone'] = 'Recipient phone is required';\n else if (!isValidPhone(formData.recipient.phone)) newErrors['recipient.phone'] = 'Invalid phone number';\n if (!formData.recipient.email) newErrors['recipient.email'] = 'Recipient email is required';\n else if (!isValidEmail(formData.recipient.email)) newErrors['recipient.email'] = 'Invalid email address';\n\n // Package validation\n formData.packages.forEach((pkg, index) => {\n if (!pkg.description) newErrors[`packages.${index}.description`] = 'Package description is required';\n if (pkg.weight <= 0) newErrors[`packages.${index}.weight`] = 'Weight must be greater than 0';\n if (pkg.value <= 0) newErrors[`packages.${index}.value`] = 'Value must be greater than 0';\n if (pkg.dimensions.length <= 0) newErrors[`packages.${index}.length`] = 'Length must be greater than 0';\n if (pkg.dimensions.width <= 0) newErrors[`packages.${index}.width`] = 'Width must be greater than 0';\n if (pkg.dimensions.height <= 0) newErrors[`packages.${index}.height`] = 'Height must be greater than 0';\n });\n\n setErrors(newErrors);\n return Object.keys(newErrors).length === 0;\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!validateForm()) {\n return;\n }\n\n setLoading(true);\n try {\n const response = await fetch('/api/shipments', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(formData)\n });\n\n const result = await response.json();\n if (result.success) {\n alert(`Shipment created successfully! Tracking number: ${result.data.trackingNumber}`);\n onShipmentCreated();\n } else {\n alert(`Error: ${result.error}`);\n }\n } catch (error) {\n alert('Failed to create shipment. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n const updateFormData = (path: string, value: any) => {\n setFormData(prev => {\n const newData = { ...prev };\n const keys = path.split('.');\n let current: any = newData;\n \n for (let i = 0; i < keys.length - 1; i++) {\n if (current[keys[i]] === undefined) {\n current[keys[i]] = {};\n }\n current = current[keys[i]];\n }\n \n current[keys[keys.length - 1]] = value;\n return newData;\n });\n };\n\n const addPackage = () => {\n setFormData(prev => ({\n ...prev,\n packages: [...prev.packages, {\n weight: 1,\n dimensions: { length: 12, width: 12, height: 6 },\n value: 100,\n description: '',\n fragile: false,\n hazardous: false\n }]\n }));\n };\n\n const removePackage = (index: number) => {\n setFormData(prev => ({\n ...prev,\n packages: prev.packages.filter((_, i) => i !== index)\n }));\n };\n\n const InputField = ({ \n label, \n path, \n type = 'text', \n required = false,\n placeholder = ''\n }: {\n label: string;\n path: string;\n type?: string;\n required?: boolean;\n placeholder?: string;\n }) => {\n const getValue = (obj: any, path: string) => {\n return path.split('.').reduce((o, p) => o?.[p], obj) || '';\n };\n\n return (\n

\n \n {label} {required && *}\n \n updateFormData(path, e.target.value)}\n placeholder={placeholder}\n className={`w-full px-3 py-2 border rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent form-input ${\n errors[path] ? 'border-red-500' : 'border-gray-300'\n }`}\n />\n {errors[path] &&

{errors[path]}

}\n

\n );\n };\n\n const SelectField = ({ \n label, \n path, \n options, \n required = false \n }: {\n label: string;\n path: string;\n options: { value: string; label: string }[];\n required?: boolean;\n }) => {\n const getValue = (obj: any, path: string) => {\n return path.split('.').reduce((o, p) => o?.[p], obj) || '';\n };\n\n return (\n

\n \n {label} {required && *}\n \n updateFormData(path, e.target.value)}\n className={`w-full px-3 py-2 border rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent ${\n errors[path] ? 'border-red-500' : 'border-gray-300'\n }`}\n >\n {options.map(option => (\n \n ))}\n \n {errors[path] &&

{errors[path]}

}\n

\n );\n };\n\n const states = [\n 'AL', 'AK', 'AZ', 'AR', 'CA', 'CO', 'CT', 'DE', 'FL', 'GA',\n 'HI', 'ID', 'IL', 'IN', 'IA', 'KS', 'KY', 'LA', 'ME', 'MD',\n 'MA', 'MI', 'MN', 'MS', 'MO', 'MT', 'NE', 'NV', 'NH', 'NJ',\n 'NM', 'NY', 'NC', 'ND', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC',\n 'SD', 'TN', 'TX', 'UT', 'VT', 'VA', 'WA', 'WV', 'WI', 'WY'\n ].map(state => ({ value: state, label: state }));\n\n const serviceTypes = [\n { value: 'standard', label: 'Standard (5-7 days)' },\n { value: 'expedited', label: 'Expedited (2-3 days)' },\n { value: 'two_day', label: 'Two Day' },\n { value: 'overnight', label: 'Overnight' },\n { value: 'ground', label: 'Ground (7-10 days)' }\n ];\n\n return (\n

Create New Shipment

Fill in the details to create a new shipment

\n\n

\n {/* Step 1: Addresses */}\n

\n {/* Origin Address */}\n

\n 📍\n Origin Address\n

\n \n

\n \n \n

\n \n

\n\n {/* Destination Address */}\n

\n 🎯\n Destination Address\n

\n \n

\n \n \n

\n \n

\n\n {/* Step 2: Contacts */}\n

\n {/* Sender */}\n

\n 👤\n Sender Information\n

\n \n \n \n

\n\n {/* Recipient */}\n

\n 👥\n Recipient Information\n

\n \n \n \n

\n\n {/* Step 3: Packages */}\n

\n 📦\n Package Details\n

\n \n + Add Package\n \n

\n\n {formData.packages.map((pkg, index) => (\n

Package {index + 1}

\n {formData.packages.length > 1 && (\n removePackage(index)}\n className=\"text-red-600 hover:text-red-700 text-sm\"\n >\n Remove\n \n )}\n

\n\n

\n \n \n \n \n

\n\n

\n \n \n

\n\n

\n \n updateFormData(`packages.${index}.fragile`, e.target.checked)}\n className=\"rounded border-gray-300 text-blue-600 focus:ring-blue-500\"\n />\n Fragile\n \n \n updateFormData(`packages.${index}.hazardous`, e.target.checked)}\n className=\"rounded border-gray-300 text-blue-600 focus:ring-blue-500\"\n />\n Hazardous\n \n

\n ))}\n

\n\n {/* Step 4: Shipping Options */}\n

\n 🚚\n Shipping Options\n

\n\n

\n ({ value: c.id, label: c.name }))}\n required \n />\n \n

\n\n

\n \n Special Instructions\n \n updateFormData('notes', e.target.value)}\n rows={3}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n placeholder=\"Any special delivery instructions...\"\n />\n

\n\n {/* Rate Calculator */}\n

Shipping Rates

\n \n Calculate Rates\n \n

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

\n {rates.slice(0, 5).map((rate, index) => (\n

\n \n {rate.carrier.toUpperCase()} {rate.serviceType} ({rate.estimatedDays} days)\n \n ${rate.cost}\n

\n ))}\n

\n )}\n

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

\n window.history.back()}\n className=\"px-6 py-2 border border-gray-300 rounded-lg text-gray-700 hover:bg-gray-50 transition-colors\"\n >\n Cancel\n \n \n {loading ? 'Creating...' : 'Create Shipment'}\n \n

\n );\n}",[],[230,263,256],"components","928c3e10-3f84-11f0-97aa-76b3cceeab13","Dashboard.tsx","928c3f00-3f84-11f0-97aa-76b3cceeab13",17,["D",1748849907533],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { DashboardStats, Shipment } from \"../../shared/types.ts\";\nimport { formatCurrency } from \"../../shared/utils.ts\";\n\ninterface DashboardProps {\n stats: DashboardStats | null;\n onTrackShipment: (trackingNumber: string) => void;\n onCreateShipment: () => void;\n}\n\nexport default function Dashboard({ stats, onTrackShipment, onCreateShipment }: DashboardProps) {\n const [recentShipments, setRecentShipments] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n loadRecentShipments();\n }, []);\n\n const loadRecentShipments = async () => {\n try {\n const response = await fetch('/api/shipments?limit=5');\n const result = await response.json();\n if (result.success) {\n setRecentShipments(result.data.data);\n }\n } catch (error) {\n console.error('Failed to load recent shipments:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const StatCard = ({ title, value, icon, color, subtitle }: {\n title: string;\n value: string | number;\n icon: string;\n color: string;\n subtitle?: string;\n }) => (\n

\n {icon}\n

{title}

{value}

\n {subtitle &&

{subtitle}

}\n

\n );\n\n const getStatusColor = (status: string) => {\n const colors = {\n pending: 'bg-yellow-100 text-yellow-800',\n picked_up: 'bg-blue-100 text-blue-800',\n in_transit: 'bg-purple-100 text-purple-800',\n out_for_delivery: 'bg-orange-100 text-orange-800',\n delivered: 'bg-green-100 text-green-800',\n exception: 'bg-red-100 text-red-800',\n cancelled: 'bg-gray-100 text-gray-800'\n };\n return colors[status as keyof typeof colors] || 'bg-gray-100 text-gray-800';\n };\n\n const formatStatus = (status: string) => {\n return status.split('_').map(word => \n word.charAt(0).toUpperCase() + word.slice(1)\n ).join(' ');\n };\n\n return (\n

\n {/* Header */}\n

Dashboard

Overview of your shipping operations

\n \n + Create Shipment\n \n

\n\n {/* Stats Grid */}\n {stats && (\n

\n \n \n \n \n

\n )}\n\n {/* Revenue and Performance */}\n {stats && (\n

Revenue

\n {formatCurrency(stats.totalRevenue)}\n

Total revenue from delivered shipments

\n \n

Performance

\n {stats.averageDeliveryTime}h\n

Average delivery time

\n )}\n\n {/* Quick Track */}\n

Quick Track

\n {\n if (e.key === 'Enter') {\n const value = (e.target as HTMLInputElement).value.trim();\n if (value) {\n onTrackShipment(value);\n (e.target as HTMLInputElement).value = '';\n }\n }\n }}\n />\n {\n const input = document.querySelector('input[placeholder=\"Enter tracking number...\"]') as HTMLInputElement;\n const value = input?.value.trim();\n if (value) {\n onTrackShipment(value);\n input.value = '';\n }\n }}\n className=\"bg-blue-600 text-white px-6 py-2 rounded-lg hover:bg-blue-700 transition-colors btn-primary\"\n >\n Track\n \n

\n\n {/* Recent Shipments */}\n

Recent Shipments

\n \n {loading ? (\n

Loading shipments...

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

No shipments found

\n \n Create your first shipment\n \n

\n ) : (\n

\n {recentShipments.map((shipment) => (\n

\n \n {shipment.trackingNumber}\n \n \n {formatStatus(shipment.status)}\n \n

\n {shipment.origin.city}, {shipment.origin.state}\n →\n {shipment.destination.city}, {shipment.destination.state}\n

\n {shipment.recipient.name} • {shipment.carrier.toUpperCase()}\n

\n {formatCurrency(shipment.cost)}\n

\n onTrackShipment(shipment.trackingNumber)}\n className=\"mt-1 text-sm text-blue-600 hover:text-blue-700 font-medium\"\n >\n Track →\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[230,263,265],"7d493f58-3f84-11f0-97bb-76b3cceeab13","App.tsx","7d494020-3f84-11f0-97bb-76b3cceeab13",16,["D",1748849871859],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { DashboardStats, Shipment } from \"../../shared/types.ts\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport ShipmentForm from \"./ShipmentForm.tsx\";\nimport TrackingView from \"./TrackingView.tsx\";\nimport ShipmentList from \"./ShipmentList.tsx\";\n\ninterface AppProps {\n initialData: DashboardStats | null;\n}\n\ntype View = 'dashboard' | 'create' | 'track' | 'shipments';\n\nexport default function App({ initialData }: AppProps) {\n const [currentView, setCurrentView] = useState('dashboard');\n const [dashboardStats, setDashboardStats] = useState(initialData);\n const [selectedShipment, setSelectedShipment] = useState(null);\n const [trackingNumber, setTrackingNumber] = useState('');\n\n // Load dashboard stats if not provided initially\n useEffect(() => {\n if (!dashboardStats) {\n loadDashboardStats();\n }\n }, []);\n\n const loadDashboardStats = async () => {\n try {\n const response = await fetch('/api/tracking/dashboard/stats');\n const result = await response.json();\n if (result.success) {\n setDashboardStats(result.data);\n }\n } catch (error) {\n console.error('Failed to load dashboard stats:', error);\n }\n };\n\n const handleShipmentCreated = () => {\n setCurrentView('dashboard');\n loadDashboardStats(); // Refresh stats\n };\n\n const handleTrackShipment = (trackingNum: string) => {\n setTrackingNumber(trackingNum);\n setCurrentView('track');\n };\n\n const handleViewShipment = (shipment: Shipment) => {\n setSelectedShipment(shipment);\n setCurrentView('track');\n };\n\n return (\n

\n {/* Navigation Header */}\n

\n 📦\n Shipping Operations\n

\n setCurrentView('dashboard')}\n className={`px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n currentView === 'dashboard'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n Dashboard\n \n setCurrentView('create')}\n className={`px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n currentView === 'create'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n Create Shipment\n \n setCurrentView('shipments')}\n className={`px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n currentView === 'shipments'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n All Shipments\n \n

\n\n {/* Quick Track Search */}\n

\n {\n if (e.key === 'Enter') {\n const value = (e.target as HTMLInputElement).value.trim();\n if (value) {\n handleTrackShipment(value);\n (e.target as HTMLInputElement).value = '';\n }\n }\n }}\n />\n

\n 🔍\n

\n\n {/* Mobile Navigation */}\n

\n setCurrentView('dashboard')}\n className={`block w-full text-left px-3 py-2 rounded-md text-base font-medium transition-colors ${\n currentView === 'dashboard'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n Dashboard\n \n setCurrentView('create')}\n className={`block w-full text-left px-3 py-2 rounded-md text-base font-medium transition-colors ${\n currentView === 'create'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n Create Shipment\n \n setCurrentView('shipments')}\n className={`block w-full text-left px-3 py-2 rounded-md text-base font-medium transition-colors ${\n currentView === 'shipments'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n All Shipments\n \n

\n\n {/* Main Content */}\n

\n {currentView === 'dashboard' && (\n setCurrentView('create')}\n />\n )}\n \n {currentView === 'create' && (\n \n )}\n \n {currentView === 'track' && (\n setCurrentView('dashboard')}\n />\n )}\n \n {currentView === 'shipments' && (\n \n )}\n

\n );\n}",[],[230,263,273],"7d495b96-3f84-11f0-97bb-76b3cceeab13",["D",1748849871859],[193,194,195],[230,263],"583727f2-3f84-11f0-a07d-76b3cceeab13",["D",1748849809664],[192,196,197,198,199],[230],"9aeb3ecc-3f7e-11f0-a4ca-76b3cceeab13","index.ts","682d1f81-a4bf-4bc5-9799-86f62d206cc6",11,["D",1748847344593],"http","// Main Hono server for shipping operations\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations, createTriggers } from \"./database/migrations.ts\";\nimport shipmentsRoutes from \"./routes/shipments.ts\";\nimport trackingRoutes from \"./routes/tracking.ts\";\nimport routesRoutes from \"./routes/routes.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\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n console.log(\"Initializing database...\");\n await runMigrations();\n await createTriggers();\n dbInitialized = true;\n console.log(\"Database initialized successfully!\");\n }\n}\n\n// Middleware to ensure database is initialized\napp.use(\"*\", async (c, next) => {\n await initializeDatabase();\n await next();\n});\n\n// API routes\napp.route(\"/api/shipments\", shipmentsRoutes);\napp.route(\"/api/tracking\", trackingRoutes);\napp.route(\"/api/routes\", routesRoutes);\n\n// Static file serving and main app\napp.route(\"/\", staticRoutes);\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({\n status: \"healthy\",\n timestamp: new Date().toISOString(),\n service: \"shipping-operations\"\n });\n});\n\n// 404 handler for API routes\napp.notFound((c) => {\n if (c.req.path.startsWith(\"/api/\")) {\n return c.json({\n success: false,\n error: \"Endpoint not found\"\n }, 404);\n }\n \n // For non-API routes, serve the main app (SPA routing)\n return c.redirect(\"/\");\n});\n\nexport default app;",[],[297,289],"backend","77b642e4-3f7e-11f0-ba5b-76b3cceeab13","tracking.ts","77b64384-3f7e-11f0-ba5b-76b3cceeab13","02a7e29c-128e-49a2-9f5e-8a84b1e45a99",7,["D",1748847285475],"// Tracking and monitoring routes\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport {\n getShipmentByTracking,\n getTrackingEvents,\n createTrackingEvent,\n getDashboardStats\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Track shipment by tracking number\napp.get(\"/:trackingNumber\", async (c) => {\n try {\n const trackingNumber = c.req.param(\"trackingNumber\");\n const shipment = await getShipmentByTracking(trackingNumber);\n const events = await getTrackingEvents(shipment.id);\n \n return c.json({\n success: true,\n data: {\n shipment,\n events\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, error.message === \"Shipment not found\" ? 404 : 500);\n }\n});\n\n// Get tracking events for a shipment\napp.get(\"/events/:shipmentId\", async (c) => {\n try {\n const shipmentId = c.req.param(\"shipmentId\");\n const events = await getTrackingEvents(shipmentId);\n \n return c.json({\n success: true,\n data: events\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Add tracking event (for internal use or carrier webhooks)\napp.post(\"/events\", async (c) => {\n try {\n const data = await c.req.json();\n \n if (!data.shipmentId || !data.status || !data.location || !data.description) {\n return c.json({\n success: false,\n error: \"Missing required fields\"\n }, 400);\n }\n \n const event = await createTrackingEvent(data);\n \n return c.json({\n success: true,\n data: event,\n message: \"Tracking event created successfully\"\n }, 201);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get dashboard statistics\napp.get(\"/dashboard/stats\", async (c) => {\n try {\n const stats = await getDashboardStats();\n \n return c.json({\n success: true,\n data: stats\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\nexport default app;",[],[297,307,299],"routes","90ad89ce-3f7e-11f0-8697-76b3cceeab13","static.ts","90ad8a8c-3f7e-11f0-8697-76b3cceeab13",9,["D",1748847327414],"// Static file serving routes\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { getDashboardStats } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve main application with initial data\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial dashboard data to avoid extra round-trips\n const initialData = await getDashboardStats();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(\"Error loading application\", 500);\n }\n});\n\nexport default app;",[],[297,307,309],"6fdba172-3f7e-11f0-9c46-76b3cceeab13","shipments.ts","6fdba21c-3f7e-11f0-9c46-76b3cceeab13",6,["D",1748847272347],"// Shipment management routes\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { CreateShipmentRequest, UpdateShipmentRequest } from \"../../shared/types.ts\";\nimport {\n createShipment,\n getShipments,\n getShipmentById,\n updateShipment,\n deleteShipment\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all shipments with pagination and filtering\napp.get(\"/\", async (c) => {\n try {\n const page = parseInt(c.req.query(\"page\") || \"1\");\n const limit = parseInt(c.req.query(\"limit\") || \"20\");\n const status = c.req.query(\"status\");\n \n const result = await getShipments(page, limit, status);\n \n return c.json({\n success: true,\n data: result\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get shipment by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const shipment = await getShipmentById(id);\n \n return c.json({\n success: true,\n data: shipment\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, error.message === \"Shipment not found\" ? 404 : 500);\n }\n});\n\n// Create new shipment\napp.post(\"/\", async (c) => {\n try {\n const data: CreateShipmentRequest = await c.req.json();\n \n // Basic validation\n if (!data.origin || !data.destination || !data.sender || !data.recipient || !data.packages?.length) {\n return c.json({\n success: false,\n error: \"Missing required fields\"\n }, 400);\n }\n \n const shipment = await createShipment(data);\n \n return c.json({\n success: true,\n data: shipment,\n message: \"Shipment created successfully\"\n }, 201);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Update shipment\napp.put(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const data: UpdateShipmentRequest = await c.req.json();\n \n const shipment = await updateShipment(id, data);\n \n return c.json({\n success: true,\n data: shipment,\n message: \"Shipment updated successfully\"\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, error.message === \"Shipment not found\" ? 404 : 500);\n }\n});\n\n// Delete shipment\napp.delete(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n await deleteShipment(id);\n \n return c.json({\n success: true,\n message: \"Shipment deleted successfully\"\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\nexport default app;",[],[297,307,317],"8a9ea3f6-3f7e-11f0-8b33-76b3cceeab13","routes.ts","8a9ea4aa-3f7e-11f0-8b33-76b3cceeab13",8,["D",1748847317251],"// Route optimization and management\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { RouteOptimizationRequest, Address } from \"../../shared/types.ts\";\nimport { getShipmentById } from \"../database/queries.ts\";\nimport { calculateDistance } from \"../../shared/utils.ts\";\n\nconst app = new Hono();\n\n// Optimize delivery route\napp.post(\"/optimize\", async (c) => {\n try {\n const data: RouteOptimizationRequest = await c.req.json();\n \n if (!data.shipmentIds || data.shipmentIds.length === 0) {\n return c.json({\n success: false,\n error: \"No shipments provided\"\n }, 400);\n }\n \n // Get shipment details\n const shipments = await Promise.all(\n data.shipmentIds.map(id => getShipmentById(id))\n );\n \n // Extract destinations\n const destinations = shipments.map(s => s.destination);\n \n // Simple route optimization using nearest neighbor algorithm\n const optimizedRoute = optimizeRoute(destinations, data.startLocation);\n \n // Calculate total distance and estimated time\n const totalDistance = calculateTotalDistance(optimizedRoute);\n const estimatedDuration = Math.round(totalDistance * 2); // Rough estimate: 2 minutes per mile\n \n return c.json({\n success: true,\n data: {\n route: optimizedRoute,\n shipmentIds: data.shipmentIds,\n totalDistance,\n estimatedDuration,\n optimized: true\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get available carriers and their services\napp.get(\"/carriers\", async (c) => {\n try {\n const carriers = [\n {\n id: \"ups\",\n name: \"UPS\",\n services: [\"standard\", \"expedited\", \"overnight\", \"two_day\", \"ground\"],\n trackingUrlTemplate: \"https://www.ups.com/track?tracknum={trackingNumber}\"\n },\n {\n id: \"fedex\",\n name: \"FedEx\",\n services: [\"standard\", \"expedited\", \"overnight\", \"two_day\", \"ground\"],\n trackingUrlTemplate: \"https://www.fedex.com/apps/fedextrack/?tracknumbers={trackingNumber}\"\n },\n {\n id: \"usps\",\n name: \"USPS\",\n services: [\"standard\", \"expedited\", \"ground\"],\n trackingUrlTemplate: \"https://tools.usps.com/go/TrackConfirmAction?qtc_tLabels1={trackingNumber}\"\n },\n {\n id: \"dhl\",\n name: \"DHL\",\n services: [\"standard\", \"expedited\", \"overnight\"],\n trackingUrlTemplate: \"https://www.dhl.com/en/express/tracking.html?AWB={trackingNumber}\"\n },\n {\n id: \"local\",\n name: \"Local Delivery\",\n services: [\"standard\", \"expedited\"],\n trackingUrlTemplate: \"\"\n }\n ];\n \n return c.json({\n success: true,\n data: carriers\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Calculate shipping rates (mock implementation)\napp.post(\"/rates\", async (c) => {\n try {\n const { origin, destination, packages, serviceTypes } = await c.req.json();\n \n if (!origin || !destination || !packages) {\n return c.json({\n success: false,\n error: \"Missing required fields\"\n }, 400);\n }\n \n // Mock rate calculation\n const distance = calculateDistance(origin, destination);\n const totalWeight = packages.reduce((sum: number, pkg: any) => sum + pkg.weight, 0);\n \n const baseRates = {\n ups: { standard: 15.99, expedited: 25.99, overnight: 45.99, two_day: 35.99, ground: 12.99 },\n fedex: { standard: 16.99, expedited: 26.99, overnight: 47.99, two_day: 36.99, ground: 13.99 },\n usps: { standard: 12.99, expedited: 22.99, ground: 9.99 },\n dhl: { standard: 18.99, expedited: 28.99, overnight: 49.99 },\n local: { standard: 8.99, expedited: 15.99 }\n };\n \n const rates = [];\n \n for (const [carrier, services] of Object.entries(baseRates)) {\n for (const [service, baseRate] of Object.entries(services)) {\n if (!serviceTypes || serviceTypes.includes(service)) {\n const weightMultiplier = 1 + (totalWeight * 0.1);\n const distanceMultiplier = 1 + (distance * 0.001);\n const finalRate = Math.round(baseRate * weightMultiplier * distanceMultiplier * 100) / 100;\n \n rates.push({\n carrier,\n serviceType: service,\n cost: finalRate,\n estimatedDays: getEstimatedDays(service, distance),\n guaranteed: service === \"overnight\" || service === \"two_day\"\n });\n }\n }\n }\n \n return c.json({\n success: true,\n data: rates.sort((a, b) => a.cost - b.cost)\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Helper functions\nfunction optimizeRoute(destinations: Address[], startLocation?: Address): Address[] {\n if (destinations.length <= 1) return destinations;\n \n const unvisited = [...destinations];\n const route: Address[] = [];\n let current = startLocation || destinations[0];\n \n if (startLocation) {\n // Remove the closest destination to start location from unvisited\n let closestIndex = 0;\n let closestDistance = Infinity;\n \n unvisited.forEach((dest, index) => {\n const distance = calculateDistance(current, dest);\n if (distance < closestDistance) {\n closestDistance = distance;\n closestIndex = index;\n }\n });\n \n route.push(unvisited.splice(closestIndex, 1)[0]);\n current = route[0];\n } else {\n route.push(unvisited.shift()!);\n }\n \n // Nearest neighbor algorithm\n while (unvisited.length > 0) {\n let nearestIndex = 0;\n let nearestDistance = Infinity;\n \n unvisited.forEach((dest, index) => {\n const distance = calculateDistance(current, dest);\n if (distance < nearestDistance) {\n nearestDistance = distance;\n nearestIndex = index;\n }\n });\n \n const nearest = unvisited.splice(nearestIndex, 1)[0];\n route.push(nearest);\n current = nearest;\n }\n \n return route;\n}\n\nfunction calculateTotalDistance(route: Address[]): number {\n if (route.length < 2) return 0;\n \n let total = 0;\n for (let i = 0; i < route.length - 1; i++) {\n total += calculateDistance(route[i], route[i + 1]);\n }\n \n return Math.round(total * 100) / 100;\n}\n\nfunction getEstimatedDays(serviceType: string, distance: number): number {\n const baseDays = {\n overnight: 1,\n two_day: 2,\n expedited: 3,\n standard: 5,\n ground: 7\n }[serviceType] || 5;\n \n // Add extra days for long distances\n const extraDays = distance > 1000 ? 2 : distance > 500 ? 1 : 0;\n \n return baseDays + extraDays;\n}\n\nexport default app;",[],[297,307,325],"6fdbaabe-3f7e-11f0-9c46-76b3cceeab13",["D",1748847272347],[186,187,188,189],[297,307],"66cb979a-3f7e-11f0-b6f5-76b3cceeab13","queries.ts","66cb9862-3f7e-11f0-b6f5-76b3cceeab13","cc56f0c5-e260-4415-ae29-9b1f2263e12b",5,["D",1748847257146],"// Database query functions for shipping operations\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n Shipment, \n Package, \n TrackingEvent, \n Route, \n DashboardStats,\n CreateShipmentRequest,\n UpdateShipmentRequest,\n PaginatedResponse\n} from \"../../shared/types.ts\";\nimport { generateId, generateTrackingNumber } from \"../../shared/utils.ts\";\n\n// Shipment queries\nexport async function createShipment(data: CreateShipmentRequest): Promise {\n const shipmentId = generateId();\n const trackingNumber = generateTrackingNumber(data.carrier);\n const now = new Date().toISOString();\n \n // Calculate estimated delivery (simplified)\n const estimatedDelivery = new Date();\n estimatedDelivery.setDate(estimatedDelivery.getDate() + 5);\n \n // Insert shipment\n await sqlite.execute(`\n INSERT INTO shipments (\n id, tracking_number, carrier, service_type, status,\n origin_street, origin_city, origin_state, origin_zip_code, origin_country,\n origin_latitude, origin_longitude,\n dest_street, dest_city, dest_state, dest_zip_code, dest_country,\n dest_latitude, dest_longitude,\n sender_name, sender_phone, sender_email,\n recipient_name, recipient_phone, recipient_email,\n estimated_delivery, cost, notes, created_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n shipmentId, trackingNumber, data.carrier, data.serviceType, 'pending',\n data.origin.street, data.origin.city, data.origin.state, data.origin.zipCode, data.origin.country,\n data.origin.latitude, data.origin.longitude,\n data.destination.street, data.destination.city, data.destination.state, data.destination.zipCode, data.destination.country,\n data.destination.latitude, data.destination.longitude,\n data.sender.name, data.sender.phone, data.sender.email,\n data.recipient.name, data.recipient.phone, data.recipient.email,\n estimatedDelivery.toISOString(), 25.99, data.notes || null, now, now\n ]);\n\n // Insert packages\n for (const pkg of data.packages) {\n const packageId = generateId();\n await sqlite.execute(`\n INSERT INTO packages (\n id, shipment_id, weight, length, width, height, value, description, fragile, hazardous\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n packageId, shipmentId, pkg.weight, pkg.dimensions.length, pkg.dimensions.width, \n pkg.dimensions.height, pkg.value, pkg.description, pkg.fragile ? 1 : 0, pkg.hazardous ? 1 : 0\n ]);\n }\n\n // Create initial tracking event\n await createTrackingEvent({\n shipmentId,\n status: 'pending',\n location: `${data.origin.city}, ${data.origin.state}`,\n description: 'Shipment created and pending pickup',\n scanType: 'created'\n });\n\n return getShipmentById(shipmentId);\n}\n\nexport async function getShipments(page = 1, limit = 20, status?: string): Promise> {\n const offset = (page - 1) * limit;\n let whereClause = '';\n let params: any[] = [];\n \n if (status) {\n whereClause = 'WHERE status = ?';\n params.push(status);\n }\n \n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM shipments ${whereClause}`, params);\n const total = countResult[0]?.count || 0;\n \n const shipmentsResult = await sqlite.execute(`\n SELECT * FROM shipments ${whereClause} \n ORDER BY created_at DESC \n LIMIT ? OFFSET ?\n `, [...params, limit, offset]);\n \n const shipments = await Promise.all(\n shipmentsResult.map(row => buildShipmentFromRow(row))\n );\n \n return {\n data: shipments,\n total,\n page,\n limit,\n hasMore: offset + limit < total\n };\n}\n\nexport async function getShipmentById(id: string): Promise {\n const result = await sqlite.execute('SELECT * FROM shipments WHERE id = ?', [id]);\n if (!result.length) {\n throw new Error('Shipment not found');\n }\n \n return buildShipmentFromRow(result[0]);\n}\n\nexport async function getShipmentByTracking(trackingNumber: string): Promise {\n const result = await sqlite.execute('SELECT * FROM shipments WHERE tracking_number = ?', [trackingNumber]);\n if (!result.length) {\n throw new Error('Shipment not found');\n }\n \n return buildShipmentFromRow(result[0]);\n}\n\nexport async function updateShipment(id: string, data: UpdateShipmentRequest): Promise {\n const updates: string[] = [];\n const params: any[] = [];\n \n if (data.status) {\n updates.push('status = ?');\n params.push(data.status);\n }\n \n if (data.estimatedDelivery) {\n updates.push('estimated_delivery = ?');\n params.push(data.estimatedDelivery);\n }\n \n if (data.actualDelivery) {\n updates.push('actual_delivery = ?');\n params.push(data.actualDelivery);\n }\n \n if (data.notes) {\n updates.push('notes = ?');\n params.push(data.notes);\n }\n \n if (data.signature) {\n updates.push('signature = ?');\n params.push(data.signature);\n }\n \n if (data.proofOfDelivery) {\n updates.push('proof_of_delivery = ?');\n params.push(data.proofOfDelivery);\n }\n \n if (updates.length === 0) {\n return getShipmentById(id);\n }\n \n params.push(id);\n \n await sqlite.execute(`\n UPDATE shipments \n SET ${updates.join(', ')}, updated_at = datetime('now')\n WHERE id = ?\n `, params);\n \n // If status was updated, create tracking event\n if (data.status) {\n const shipment = await getShipmentById(id);\n await createTrackingEvent({\n shipmentId: id,\n status: data.status,\n location: `${shipment.destination.city}, ${shipment.destination.state}`,\n description: `Status updated to ${data.status}`,\n scanType: 'status_update'\n });\n }\n \n return getShipmentById(id);\n}\n\nexport async function deleteShipment(id: string): Promise {\n await sqlite.execute('DELETE FROM shipments WHERE id = ?', [id]);\n}\n\n// Package queries\nexport async function getPackagesByShipment(shipmentId: string): Promise {\n const result = await sqlite.execute('SELECT * FROM packages WHERE shipment_id = ?', [shipmentId]);\n \n return result.map(row => ({\n id: row.id,\n weight: row.weight,\n dimensions: {\n length: row.length,\n width: row.width,\n height: row.height\n },\n value: row.value,\n description: row.description,\n fragile: Boolean(row.fragile),\n hazardous: Boolean(row.hazardous)\n }));\n}\n\n// Tracking event queries\nexport async function createTrackingEvent(data: {\n shipmentId: string;\n status: string;\n location: string;\n description: string;\n scanType?: string;\n}): Promise {\n const id = generateId();\n const timestamp = new Date().toISOString();\n \n await sqlite.execute(`\n INSERT INTO tracking_events (id, shipment_id, status, location, timestamp, description, scan_type)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [id, data.shipmentId, data.status, data.location, timestamp, data.description, data.scanType]);\n \n return {\n id,\n shipmentId: data.shipmentId,\n status: data.status as any,\n location: data.location,\n timestamp,\n description: data.description,\n scanType: data.scanType\n };\n}\n\nexport async function getTrackingEvents(shipmentId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM tracking_events \n WHERE shipment_id = ? \n ORDER BY timestamp DESC\n `, [shipmentId]);\n \n return result.map(row => ({\n id: row.id,\n shipmentId: row.shipment_id,\n status: row.status,\n location: row.location,\n timestamp: row.timestamp,\n description: row.description,\n scanType: row.scan_type\n }));\n}\n\n// Dashboard queries\nexport async function getDashboardStats(): Promise {\n const today = new Date().toISOString().split('T')[0];\n \n const [totalResult, pendingResult, inTransitResult, deliveredTodayResult, revenueResult] = await Promise.all([\n sqlite.execute('SELECT COUNT(*) as count FROM shipments'),\n sqlite.execute('SELECT COUNT(*) as count FROM shipments WHERE status = ?', ['pending']),\n sqlite.execute('SELECT COUNT(*) as count FROM shipments WHERE status = ?', ['in_transit']),\n sqlite.execute('SELECT COUNT(*) as count FROM shipments WHERE DATE(actual_delivery) = ?', [today]),\n sqlite.execute('SELECT SUM(cost) as total FROM shipments WHERE status = ?', ['delivered'])\n ]);\n \n return {\n totalShipments: totalResult[0]?.count || 0,\n pendingShipments: pendingResult[0]?.count || 0,\n inTransitShipments: inTransitResult[0]?.count || 0,\n deliveredToday: deliveredTodayResult[0]?.count || 0,\n totalRevenue: revenueResult[0]?.total || 0,\n averageDeliveryTime: 48 // Placeholder - would need more complex query\n };\n}\n\n// Helper function to build shipment object from database row\nasync function buildShipmentFromRow(row: any): Promise {\n const packages = await getPackagesByShipment(row.id);\n \n return {\n id: row.id,\n trackingNumber: row.tracking_number,\n carrier: row.carrier,\n serviceType: row.service_type,\n status: row.status,\n origin: {\n street: row.origin_street,\n city: row.origin_city,\n state: row.origin_state,\n zipCode: row.origin_zip_code,\n country: row.origin_country,\n latitude: row.origin_latitude,\n longitude: row.origin_longitude\n },\n destination: {\n street: row.dest_street,\n city: row.dest_city,\n state: row.dest_state,\n zipCode: row.dest_zip_code,\n country: row.dest_country,\n latitude: row.dest_latitude,\n longitude: row.dest_longitude\n },\n sender: {\n name: row.sender_name,\n phone: row.sender_phone,\n email: row.sender_email\n },\n recipient: {\n name: row.recipient_name,\n phone: row.recipient_phone,\n email: row.recipient_email\n },\n packages,\n estimatedDelivery: row.estimated_delivery,\n actualDelivery: row.actual_delivery,\n cost: row.cost,\n createdAt: row.created_at,\n updatedAt: row.updated_at,\n notes: row.notes,\n signature: row.signature,\n proofOfDelivery: row.proof_of_delivery\n };\n}",[],[297,345,337],"database","4cee0312-3f7e-11f0-95cc-76b3cceeab13","migrations.ts","4cee03d0-3f7e-11f0-95cc-76b3cceeab13",4,["D",1748847213749],"// Database schema setup for shipping operations\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n\n // Shipments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS shipments (\n id TEXT PRIMARY KEY,\n tracking_number TEXT UNIQUE NOT NULL,\n carrier TEXT NOT NULL,\n service_type TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n \n -- Origin address\n origin_street TEXT NOT NULL,\n origin_city TEXT NOT NULL,\n origin_state TEXT NOT NULL,\n origin_zip_code TEXT NOT NULL,\n origin_country TEXT NOT NULL DEFAULT 'US',\n origin_latitude REAL,\n origin_longitude REAL,\n \n -- Destination address\n dest_street TEXT NOT NULL,\n dest_city TEXT NOT NULL,\n dest_state TEXT NOT NULL,\n dest_zip_code TEXT NOT NULL,\n dest_country TEXT NOT NULL DEFAULT 'US',\n dest_latitude REAL,\n dest_longitude REAL,\n \n -- Sender contact\n sender_name TEXT NOT NULL,\n sender_phone TEXT NOT NULL,\n sender_email TEXT NOT NULL,\n \n -- Recipient contact\n recipient_name TEXT NOT NULL,\n recipient_phone TEXT NOT NULL,\n recipient_email TEXT NOT NULL,\n \n -- Shipping details\n estimated_delivery TEXT NOT NULL,\n actual_delivery TEXT,\n cost REAL NOT NULL,\n \n -- Additional fields\n notes TEXT,\n signature TEXT,\n proof_of_delivery TEXT,\n \n -- Timestamps\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Packages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS packages (\n id TEXT PRIMARY KEY,\n shipment_id TEXT NOT NULL,\n weight REAL NOT NULL,\n length REAL NOT NULL,\n width REAL NOT NULL,\n height REAL NOT NULL,\n value REAL NOT NULL,\n description TEXT NOT NULL,\n fragile INTEGER NOT NULL DEFAULT 0,\n hazardous INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (shipment_id) REFERENCES shipments (id) ON DELETE CASCADE\n )\n `);\n\n // Tracking events table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS tracking_events (\n id TEXT PRIMARY KEY,\n shipment_id TEXT NOT NULL,\n status TEXT NOT NULL,\n location TEXT NOT NULL,\n timestamp TEXT NOT NULL,\n description TEXT NOT NULL,\n scan_type TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (shipment_id) REFERENCES shipments (id) ON DELETE CASCADE\n )\n `);\n\n // Routes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS routes (\n id TEXT PRIMARY KEY,\n driver_id TEXT,\n estimated_distance REAL NOT NULL,\n estimated_duration INTEGER NOT NULL,\n optimized INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Route shipments junction table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS route_shipments (\n route_id TEXT NOT NULL,\n shipment_id TEXT NOT NULL,\n stop_order INTEGER NOT NULL,\n PRIMARY KEY (route_id, shipment_id),\n FOREIGN KEY (route_id) REFERENCES routes (id) ON DELETE CASCADE,\n FOREIGN KEY (shipment_id) REFERENCES shipments (id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_shipments_tracking ON shipments (tracking_number)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_shipments_status ON shipments (status)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_shipments_carrier ON shipments (carrier)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_shipments_created ON shipments (created_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_packages_shipment ON packages (shipment_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_tracking_shipment ON tracking_events (shipment_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_tracking_timestamp ON tracking_events (timestamp)`);\n\n console.log(\"Database migrations completed successfully!\");\n}\n\n// Trigger to update updated_at timestamp\nexport async function createTriggers() {\n await sqlite.execute(`\n CREATE TRIGGER IF NOT EXISTS update_shipments_timestamp \n AFTER UPDATE ON shipments\n BEGIN\n UPDATE shipments SET updated_at = datetime('now') WHERE id = NEW.id;\n END\n `);\n}",[],[297,345,347],"4cee0ea2-3f7e-11f0-95cc-76b3cceeab13",["D",1748847213749],[183,184],[297,345],"4cee0d44-3f7e-11f0-95cc-76b3cceeab13",["D",1748847213749],[182,185,190],[297],["D",1748847110812],{"_11":12,"_131":71},{"_11":12,"_127":-5,"_70":71,"_31":69,"_128":129,"_130":30},{"_40":118,"_13":16,"_34":37,"_119":84,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":-5,"_125":14,"_126":12},"ctx",{"_53":-5,"_150":399,"_400":401,"_402":403,"_404":30,"_405":30,"_406":30,"_407":24,"_408":-5,"_409":-7,"_410":-7,"_411":26,"_412":30,"_413":30,"_414":-5,"_415":30,"_416":30,"_417":30,"_418":-5},"ENV",{"_370":371,"_372":373,"_374":16,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398},"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"]

History · shared