Car Inventory

{title}

\n \n

\n Make\n setMake(e.target.value)}\n required\n />\n

\n Model\n setModel(e.target.value)}\n required\n />\n

\n Year\n setYear(e.target.value)}\n required\n />\n

\n Image URL\n setImageUrl(e.target.value)}\n />\n

\n Last Oil Change\n setLastOilChange(e.target.value)}\n />\n

\n Insurance Expiry\n setInsuranceExpiry(e.target.value)}\n />\n

\n Inspection Expiry\n setInspectionExpiry(e.target.value)}\n />\n

\n \n \n

\n );\n}\n\nfunction App() {\n const [cars, setCars] = useState([]);\n const [error, setError] = useState(null);\n const [db, setDb] = useState(null);\n const [editingCar, setEditingCar] = useState(null);\n const [addingCar, setAddingCar] = useState(false);\n const [activeTab, setActiveTab] = useState('cars');\n\n useEffect(() => {\n console.log(\"App component mounted\");\n const initDb = async () => {\n try {\n const database = await init({ appId: APP_ID });\n setDb(database);\n console.log(\"InstantDB initialized successfully\");\n } catch (err) {\n console.error(\"Error initializing InstantDB:\", err);\n setError(`Failed to initialize database: ${err.message}`);\n }\n };\n\n initDb();\n }, []);\n\n useEffect(() => {\n if (db) {\n db.subscribeQuery({ cars: {} }, (resp) => {\n if (resp.error) {\n setError(`Error fetching cars: ${resp.error.message}`);\n return;\n }\n if (resp.data) {\n console.log(\"Fetched cars:\", resp.data.cars);\n setCars(resp.data.cars || []);\n }\n });\n }\n }, [db]);\n\n const addCar = async (carData) => {\n if (db) {\n try {\n await db.transact(\n tx.cars[id()].update({\n ...carData,\n createdAt: Date.now(),\n })\n );\n console.log(\"Car added successfully\");\n setAddingCar(false);\n } catch (err) {\n console.error(\"Error adding car:\", err);\n setError(`Failed to add car: ${err.message}`);\n }\n } else {\n setError(\"Database not initialized. Please refresh the page.\");\n }\n };\n\n const updateCar = async (carData) => {\n if (db) {\n try {\n await db.transact(tx.cars[carData.id].update(carData));\n console.log(\"Car updated successfully\");\n setEditingCar(null);\n } catch (err) {\n console.error(\"Error updating car:\", err);\n setError(`Failed to update car: ${err.message}`);\n }\n }\n };\n\n const deleteCar = async (carId) => {\n if (db) {\n try {\n await db.transact(tx.cars[carId].delete());\n console.log(\"Car deleted successfully\");\n } catch (err) {\n console.error(\"Error deleting car:\", err);\n setError(`Failed to delete car: ${err.message}`);\n }\n }\n };\n\n const getActions = () => {\n const now = new Date();\n const actions = [];\n cars.forEach(car => {\n if (car.lastOilChange) {\n const lastOilChangeDate = new Date(car.lastOilChange);\n const daysSinceOilChange = Math.floor((now - lastOilChangeDate) / (1000 * 60 * 60 * 24));\n if (daysSinceOilChange >= 365) {\n const daysOverdue = daysSinceOilChange - 365;\n actions.push({\n car: `${car.year} ${car.make} ${car.model}`,\n action: 'Oil Change',\n dueDate: new Date(lastOilChangeDate.getTime() + 365 * 24 * 60 * 60 * 1000),\n daysLeft: -daysOverdue,\n type: 'oil'\n });\n }\n }\n if (car.insuranceExpiry) {\n const insuranceExpiryDate = new Date(car.insuranceExpiry);\n const daysUntilExpiry = Math.floor((insuranceExpiryDate - now) / (1000 * 60 * 60 * 24));\n if (daysUntilExpiry <= 60) {\n actions.push({\n car: `${car.year} ${car.make} ${car.model}`,\n action: 'Insurance Renewal',\n dueDate: insuranceExpiryDate,\n daysLeft: daysUntilExpiry,\n type: 'insurance'\n });\n }\n }\n if (car.inspectionExpiry) {\n const inspectionExpiryDate = new Date(car.inspectionExpiry);\n const daysUntilExpiry = Math.floor((inspectionExpiryDate - now) / (1000 * 60 * 60 * 24));\n if (daysUntilExpiry <= 60) {\n actions.push({\n car: `${car.year} ${car.make} ${car.model}`,\n action: 'Inspection Renewal',\n dueDate: inspectionExpiryDate,\n daysLeft: daysUntilExpiry,\n type: 'inspection'\n });\n }\n }\n });\n return actions.sort((a, b) => a.daysLeft - b.daysLeft);\n };\n\n const renderActionTable = (actions, title, maxDays) => (\n <>\n

{title}

\n \n \n \n \n \n \n \n \n \n \n {actions.filter(action => action.daysLeft <= maxDays).map((action, index) => (\n \n \n \n \n \n \n ))}\n \n

Car	Action	Due Date	Days Left
{action.car}	{action.action}	{action.dueDate.toLocaleDateString()}	{action.daysLeft}

\n \n );\n\n console.log(\"Rendering App component\");\n\n return (\n

Car Inventory

\n \n \n \n

\n {error &&

{error}

}\n

\n \n \n

\n {activeTab === 'cars' && (\n <>\n

\n \n

\n \n \n \n \n \n \n \n \n \n \n \n {cars.map((car) => (\n \n \n \n \n \n \n \n ))}\n \n

Image	Year	Make	Model	Actions
\n {car.imageUrl && (\n \n )}\n	{car.year}	{car.make}	{car.model}	\n \n \n

\n \n )}\n {activeTab === 'actions' && (\n <>\n {renderActionTable(getActions(), \"Actions Due in 30 Days\", 30)}\n {renderActionTable(getActions(), \"Actions Due in 60 Days\", 60)}\n \n )}\n

\n View Source\n

\n {editingCar && (\n setEditingCar(null)}\n title=\"Edit Car\"\n />\n )}\n {addingCar && (\n setAddingCar(false)}\n title=\"Add Car\"\n />\n )}\n

\n );\n}\n\nfunction client() {\n console.log(\"Client function called\");\n const root = document.getElementById(\"root\");\n if (root) {\n console.log(\"Root element found, rendering App\");\n createRoot(root).render();\n } else {\n console.error(\"Root element not found\");\n }\n}\n\nif (typeof document !== \"undefined\") {\n console.log(\"Document is defined, calling client function\");\n client();\n} else {\n console.log(\"Document is undefined, skipping client-side rendering\");\n}\n\nasync function server(request: Request): Promise {\n console.log(\"Server function called\");\n return new Response(\n `\n \n \n Car Inventory\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n }\n );\n}\n\nexport default server;","deleted","label",[98],"permalink","https://www.val.town/x/konradmoneta/carInventory/code/main.tsx","extension","actionData","errors"]