[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_268":269,"_270":271},"routes/_app.x.$handle.$name",{"_96":95,"_32":46,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","979257ec-3f7e-11f0-8c34-76b3cceeab13","name","index.ts","fileType","script","content","// 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;","http","createdAt",["D",1748847344593],"branchVersion","branchId","0f925e00-3f7e-11f0-93ae-76b3cceeab13","id","0f920658-3f7e-11f0-93ae-76b3cceeab13","Shippingrevolution",["D",1748847110812],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c66a6a10-3f7d-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","12230700-6a44-48a8-ac0c-c49257130cf6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Shsragab","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d1I0bzBOOEs3T2xJVTZ3ZUJNZE9kU2kzYyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":264,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":265,"_80":266,"_82":267,"_84":25},"tree",[162,172,175],"files",[162,163,164,165,166,167,168,169,170,171,172,173,174,175],"counts",{"_152":62,"_153":133,"_154":62,"_155":156,"_157":158},"contents",[126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":146,"_32":147,"_30":148,"_132":-5,"_42":43,"_41":149,"_134":58,"_39":150,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_27":151},{"_44":139,"_32":140,"_30":141,"_132":-5,"_42":43,"_41":142,"_134":58,"_39":143,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_27":145},{"_44":129,"_32":130,"_30":131,"_132":-5,"_42":43,"_41":133,"_134":58,"_39":135,"_13":62,"_34":20,"_36":136,"_24":25,"_137":-5,"_27":138},"269bc0b4-3f7e-11f0-aa5b-76b3cceeab13","README.md","269bc172-3f7e-11f0-aa5b-76b3cceeab13","parentId",1,"latest",["D",1748847149456],"# Shipping Operation Coder\n\nA comprehensive shipping operations management system built on Val Town.\n\n## Features\n\n- **Shipment Management**: Create, track, and manage shipments\n- **Route Optimization**: Calculate optimal delivery routes\n- **Tracking System**: Real-time shipment tracking with status updates\n- **Carrier Integration**: Support for multiple shipping carriers\n- **Cost Calculator**: Shipping cost estimation based on weight, distance, and service type\n- **Dashboard**: Operations dashboard for monitoring all shipments\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── shipments.ts # Shipment CRUD operations\n│ │ ├── tracking.ts # Tracking endpoints\n│ │ ├── routes.ts # Route optimization\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── Dashboard.tsx # Operations dashboard\n│ │ ├── ShipmentForm.tsx # Create/edit shipments\n│ │ ├── TrackingView.tsx # Shipment tracking interface\n│ │ └── RouteMap.tsx # Route visualization\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n└── shared/\n ├── types.ts # Shared TypeScript interfaces\n └── utils.ts # Shared utility functions\n```\n\n## API Endpoints\n\n- `GET /api/shipments` - List all shipments\n- `POST /api/shipments` - Create new shipment\n- `GET /api/shipments/:id` - Get shipment details\n- `PUT /api/shipments/:id` - Update shipment\n- `DELETE /api/shipments/:id` - Delete shipment\n- `GET /api/tracking/:trackingNumber` - Track shipment\n- `POST /api/routes/optimize` - Calculate optimal route\n- `GET /api/carriers` - List available carriers\n\n## Getting Started\n\n1. The system automatically sets up the database on first run\n2. Access the dashboard at the root URL\n3. Create shipments using the form interface\n4. Track shipments using tracking numbers\n5. View optimized routes for deliveries\n\n## Technologies Used\n\n- **Backend**: Hono.js, SQLite\n- **Frontend**: React, TypeScript, TailwindCSS\n- **Mapping**: OpenStreetMap integration\n- **Styling**: TailwindCSS via Twind","label",[130],"315cd2ae-3f7e-11f0-88aa-76b3cceeab13","shared","6de60aef-890f-4595-adec-15171bec4210",2,["D",1748847167495],"directory",[140],"4cee0d44-3f7e-11f0-95cc-76b3cceeab13","backend","682d1f81-a4bf-4bc5-9799-86f62d206cc6",4,["D",1748847213749],[147],"pulls","branches","forks","envVars",{"_159":62,"_161":62},"connections",{"_159":62,"_160":62},"count","unfilledCount","emptyCount",{"_44":146,"_32":147,"_30":148,"_132":-5,"_42":43,"_41":149,"_134":58,"_39":261,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_177":262,"_27":263},{"_44":257,"_32":249,"_30":243,"_132":148,"_42":43,"_41":149,"_134":58,"_39":258,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_177":259,"_27":260},{"_44":250,"_32":251,"_30":252,"_132":243,"_42":43,"_41":149,"_134":58,"_39":253,"_13":62,"_34":35,"_36":254,"_24":25,"_137":-5,"_177":255,"_27":256},{"_44":240,"_32":241,"_30":242,"_132":243,"_42":43,"_41":244,"_134":58,"_39":245,"_13":62,"_34":35,"_36":246,"_24":25,"_137":-5,"_177":247,"_27":248},{"_44":236,"_32":211,"_30":205,"_132":148,"_42":43,"_41":223,"_134":58,"_39":237,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_177":238,"_27":239},{"_44":228,"_32":229,"_30":230,"_132":205,"_42":43,"_41":231,"_134":58,"_39":232,"_13":62,"_34":35,"_36":233,"_24":25,"_137":-5,"_177":234,"_27":235},{"_44":220,"_32":221,"_30":222,"_132":205,"_42":43,"_41":223,"_134":58,"_39":224,"_13":62,"_34":35,"_36":225,"_24":25,"_137":-5,"_177":226,"_27":227},{"_44":212,"_32":213,"_30":214,"_132":205,"_42":43,"_41":215,"_134":58,"_39":216,"_13":62,"_34":35,"_36":217,"_24":25,"_137":-5,"_177":218,"_27":219},{"_44":202,"_32":203,"_30":204,"_132":205,"_42":43,"_41":206,"_134":58,"_39":207,"_13":62,"_34":35,"_36":208,"_24":25,"_137":-5,"_177":209,"_27":210},{"_44":198,"_32":33,"_30":31,"_132":148,"_42":43,"_41":14,"_134":58,"_39":199,"_13":133,"_34":38,"_36":37,"_24":25,"_137":-5,"_177":200,"_27":201},{"_44":139,"_32":140,"_30":141,"_132":-5,"_42":43,"_41":142,"_134":58,"_39":195,"_13":62,"_34":144,"_36":-5,"_24":25,"_137":-5,"_177":196,"_27":197},{"_44":188,"_32":189,"_30":190,"_132":141,"_42":43,"_41":142,"_134":58,"_39":191,"_13":62,"_34":35,"_36":192,"_24":25,"_137":-5,"_177":193,"_27":194},{"_44":180,"_32":181,"_30":182,"_132":141,"_42":43,"_41":183,"_134":58,"_39":184,"_13":62,"_34":35,"_36":185,"_24":25,"_137":-5,"_177":186,"_27":187},{"_44":129,"_32":130,"_30":131,"_132":-5,"_42":43,"_41":133,"_134":58,"_39":176,"_13":62,"_34":20,"_36":136,"_24":25,"_137":-5,"_177":178,"_27":179},["D",1748847149456],"children",[],[130],"41105c66-3f7e-11f0-a9cc-76b3cceeab13","utils.ts","41105d38-3f7e-11f0-a9cc-76b3cceeab13",3,["D",1748847193843],"// Shared utility functions for the shipping operation system\n\nimport type { Address, Package, ShipmentStatus } from './types.ts';\n\n/**\n * Generate a unique tracking number\n */\nexport function generateTrackingNumber(carrier: string): string {\n const prefix = carrier.toUpperCase().substring(0, 3);\n const timestamp = Date.now().toString().slice(-8);\n const random = Math.random().toString(36).substring(2, 6).toUpperCase();\n return `${prefix}${timestamp}${random}`;\n}\n\n/**\n * Generate a unique ID\n */\nexport function generateId(): string {\n return Math.random().toString(36).substring(2) + Date.now().toString(36);\n}\n\n/**\n * Calculate distance between two addresses using Haversine formula\n */\nexport function calculateDistance(addr1: Address, addr2: Address): number {\n if (!addr1.latitude || !addr1.longitude || !addr2.latitude || !addr2.longitude) {\n return 0;\n }\n\n const R = 3959; // Earth's radius in miles\n const dLat = toRadians(addr2.latitude - addr1.latitude);\n const dLon = toRadians(addr2.longitude - addr1.longitude);\n \n const a = \n Math.sin(dLat / 2) * Math.sin(dLat / 2) +\n Math.cos(toRadians(addr1.latitude)) * Math.cos(toRadians(addr2.latitude)) *\n Math.sin(dLon / 2) * Math.sin(dLon / 2);\n \n const c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));\n return R * c;\n}\n\nfunction toRadians(degrees: number): number {\n return degrees * (Math.PI / 180);\n}\n\n/**\n * Calculate package volume in cubic inches\n */\nexport function calculateVolume(pkg: Package): number {\n return pkg.dimensions.length * pkg.dimensions.width * pkg.dimensions.height;\n}\n\n/**\n * Calculate total weight of packages\n */\nexport function calculateTotalWeight(packages: Package[]): number {\n return packages.reduce((total, pkg) => total + pkg.weight, 0);\n}\n\n/**\n * Calculate total value of packages\n */\nexport function calculateTotalValue(packages: Package[]): number {\n return packages.reduce((total, pkg) => total + pkg.value, 0);\n}\n\n/**\n * Estimate shipping cost based on weight, distance, and service type\n */\nexport function estimateShippingCost(\n weight: number,\n distance: number,\n serviceType: string\n): number {\n const baseRate = 5.99;\n const weightRate = weight * 0.75;\n const distanceRate = distance * 0.15;\n \n const serviceMultiplier = {\n standard: 1.0,\n expedited: 1.5,\n two_day: 2.0,\n overnight: 3.0,\n ground: 0.8\n }[serviceType] || 1.0;\n \n return Math.round((baseRate + weightRate + distanceRate) * serviceMultiplier * 100) / 100;\n}\n\n/**\n * Estimate delivery time based on distance and service type\n */\nexport function estimateDeliveryTime(distance: number, serviceType: string): 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\n/**\n * Format address as a single string\n */\nexport function formatAddress(address: Address): string {\n return `${address.street}, ${address.city}, ${address.state} ${address.zipCode}, ${address.country}`;\n}\n\n/**\n * Get status color for UI display\n */\nexport function getStatusColor(status: ShipmentStatus): string {\n const colors = {\n pending: 'text-yellow-600 bg-yellow-100',\n picked_up: 'text-blue-600 bg-blue-100',\n in_transit: 'text-purple-600 bg-purple-100',\n out_for_delivery: 'text-orange-600 bg-orange-100',\n delivered: 'text-green-600 bg-green-100',\n exception: 'text-red-600 bg-red-100',\n cancelled: 'text-gray-600 bg-gray-100'\n };\n \n return colors[status] || 'text-gray-600 bg-gray-100';\n}\n\n/**\n * Get human-readable status text\n */\nexport function getStatusText(status: ShipmentStatus): string {\n const statusTexts = {\n pending: 'Pending Pickup',\n picked_up: 'Picked Up',\n in_transit: 'In Transit',\n out_for_delivery: 'Out for Delivery',\n delivered: 'Delivered',\n exception: 'Exception',\n cancelled: 'Cancelled'\n };\n \n return statusTexts[status] || status;\n}\n\n/**\n * Validate email address\n */\nexport function isValidEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\n/**\n * Validate phone number (basic US format)\n */\nexport function isValidPhone(phone: string): boolean {\n const phoneRegex = /^\$?([0-9]{3})\$?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$/;\n return phoneRegex.test(phone);\n}\n\n/**\n * Validate ZIP code (US format)\n */\nexport function isValidZipCode(zipCode: string): boolean {\n const zipRegex = /^\\d{5}(-\\d{4})?$/;\n return zipRegex.test(zipCode);\n}\n\n/**\n * Format date for display\n */\nexport function formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n}\n\n/**\n * Format currency\n */\nexport function formatCurrency(amount: number): string {\n return new Intl.NumberFormat('en-US', {\n style: 'currency',\n currency: 'USD'\n }).format(amount);\n}\n\n/**\n * Debounce function for search inputs\n */\nexport function debounce any>(\n func: T,\n wait: number\n): (...args: Parameters) => void {\n let timeout: number;\n return (...args: Parameters) => {\n clearTimeout(timeout);\n timeout = setTimeout(() => func(...args), wait);\n };\n}",[],[140,181],"315cbe5e-3f7e-11f0-88aa-76b3cceeab13","types.ts","315cbf58-3f7e-11f0-88aa-76b3cceeab13",["D",1748847167495],"// Shared TypeScript interfaces for the shipping operation system\n\nexport interface Address {\n street: string;\n city: string;\n state: string;\n zipCode: string;\n country: string;\n latitude?: number;\n longitude?: number;\n}\n\nexport interface Contact {\n name: string;\n phone: string;\n email: string;\n}\n\nexport interface Package {\n id: string;\n weight: number; // in pounds\n dimensions: {\n length: number; // in inches\n width: number;\n height: number;\n };\n value: number; // in USD\n description: string;\n fragile: boolean;\n hazardous: boolean;\n}\n\nexport type ShipmentStatus = \n | 'pending'\n | 'picked_up'\n | 'in_transit'\n | 'out_for_delivery'\n | 'delivered'\n | 'exception'\n | 'cancelled';\n\nexport type ServiceType = \n | 'standard'\n | 'expedited'\n | 'overnight'\n | 'two_day'\n | 'ground';\n\nexport type CarrierType = \n | 'ups'\n | 'fedex'\n | 'usps'\n | 'dhl'\n | 'local';\n\nexport interface Shipment {\n id: string;\n trackingNumber: string;\n carrier: CarrierType;\n serviceType: ServiceType;\n status: ShipmentStatus;\n \n // Addresses\n origin: Address;\n destination: Address;\n \n // Contacts\n sender: Contact;\n recipient: Contact;\n \n // Package details\n packages: Package[];\n \n // Shipping details\n estimatedDelivery: string; // ISO date string\n actualDelivery?: string; // ISO date string\n cost: number;\n \n // Timestamps\n createdAt: string; // ISO date string\n updatedAt: string; // ISO date string\n \n // Optional fields\n notes?: string;\n signature?: string;\n proofOfDelivery?: string;\n}\n\nexport interface TrackingEvent {\n id: string;\n shipmentId: string;\n status: ShipmentStatus;\n location: string;\n timestamp: string; // ISO date string\n description: string;\n scanType?: string;\n}\n\nexport interface Route {\n id: string;\n driverId?: string;\n shipmentIds: string[];\n stops: Address[];\n estimatedDistance: number; // in miles\n estimatedDuration: number; // in minutes\n optimized: boolean;\n createdAt: string;\n}\n\nexport interface Carrier {\n id: CarrierType;\n name: string;\n services: ServiceType[];\n trackingUrlTemplate: string; // e.g., \"https://www.ups.com/track?tracknum={trackingNumber}\"\n apiEndpoint?: string;\n}\n\nexport interface ShippingRate {\n carrier: CarrierType;\n serviceType: ServiceType;\n cost: number;\n estimatedDays: number;\n guaranteed: boolean;\n}\n\nexport interface DashboardStats {\n totalShipments: number;\n pendingShipments: number;\n inTransitShipments: number;\n deliveredToday: number;\n totalRevenue: number;\n averageDeliveryTime: number; // in hours\n}\n\n// API Response types\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n message?: string;\n}\n\nexport interface PaginatedResponse {\n data: T[];\n total: number;\n page: number;\n limit: number;\n hasMore: boolean;\n}\n\n// Form types\nexport interface CreateShipmentRequest {\n origin: Address;\n destination: Address;\n sender: Contact;\n recipient: Contact;\n packages: Omit[];\n serviceType: ServiceType;\n carrier: CarrierType;\n notes?: string;\n}\n\nexport interface UpdateShipmentRequest {\n status?: ShipmentStatus;\n estimatedDelivery?: string;\n actualDelivery?: string;\n notes?: string;\n signature?: string;\n proofOfDelivery?: string;\n}\n\nexport interface RouteOptimizationRequest {\n shipmentIds: string[];\n startLocation?: Address;\n maxStops?: number;\n vehicleCapacity?: number;\n}",[],[140,189],["D",1748847167495],[173,174],[140],"9aeb3ecc-3f7e-11f0-a4ca-76b3cceeab13",["D",1748847344593],[],[147,33],"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;",[],[147,211,203],"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;",[],[147,211,213],"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;",[],[147,211,221],"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;",[],[147,211,229],"6fdbaabe-3f7e-11f0-9c46-76b3cceeab13",["D",1748847272347],[167,168,169,170],[147,211],"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}",[],[147,249,241],"database","4cee0312-3f7e-11f0-95cc-76b3cceeab13","migrations.ts","4cee03d0-3f7e-11f0-95cc-76b3cceeab13",["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}",[],[147,249,251],"4cee0ea2-3f7e-11f0-95cc-76b3cceeab13",["D",1748847213749],[164,165],[147,249],["D",1748847213749],[163,166,171],[147],["D",1748847110812],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":85,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"ctx",{"_78":-5,"_123":301,"_302":303,"_304":305,"_306":25,"_307":25,"_308":25,"_309":58,"_310":-5,"_311":-7,"_312":-7,"_313":62,"_314":25,"_315":25,"_316":-5,"_317":25,"_318":25,"_319":25,"_320":-5},"ENV",{"_272":273,"_274":275,"_276":86,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11