[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","8abab1f3bacc65052d6313ca736f41d897b49791","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_172":173,"_174":-5},"handle","godinoarts","name","EnuguRent","path","backend/routes/listings.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","262621b6-3df2-11f0-bc6a-76b3cceeab13","createdAt",["D",1748677067986],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","79b7b0aa-3df3-11f0-9a07-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","180d29bb-29b4-41f4-a984-6297ecbf663d","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",21,"26269cf4-3df2-11f0-bc6a-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"5cff08a0-3df3-11f0-93a1-76b3cceeab13","listings.ts","fileId","5cff0954-3df3-11f0-93a1-76b3cceeab13","parentId","c47297f0-e210-40b5-aa47-ff7f724b397b","branchId","branchVersion",8,"latest",["D",1748677589498],"fileType","script","content","// Property listings routes for Enugu Rents\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n PropertyQueries, \n ChatQueries, \n SavedListingsQueries, \n InspectionQueries,\n UserQueries \n} from \"../database/queries.ts\";\nimport { requireAuth } from \"./auth.ts\";\nimport type { \n PropertyForm, \n SearchFilters, \n ApiResponse, \n PaginatedResponse, \n PropertyListing \n} from \"../../shared/types.ts\";\n\nconst listings = new Hono();\n\n// Get all listings with filters and pagination\nlistings.get('/', async (c) => {\n try {\n const query = c.req.query();\n const page = parseInt(query.page || '1');\n const limit = parseInt(query.limit || '12');\n \n // Build filters from query parameters\n const filters: SearchFilters = {};\n \n if (query.location) filters.location = query.location as any;\n if (query.min_price) filters.min_price = parseInt(query.min_price);\n if (query.max_price) filters.max_price = parseInt(query.max_price);\n if (query.bedrooms) filters.bedrooms = parseInt(query.bedrooms);\n if (query.bathrooms) filters.bathrooms = parseInt(query.bathrooms);\n if (query.has_kitchen) filters.has_kitchen = query.has_kitchen === 'true';\n if (query.has_parking) filters.has_parking = query.has_parking === 'true';\n if (query.has_security) filters.has_security = query.has_security === 'true';\n if (query.power_supply) filters.power_supply = query.power_supply as any;\n if (query.furnishing) filters.furnishing = query.furnishing as any;\n \n const result = await PropertyQueries.getListings(filters, page, limit);\n \n return c.json({\n success: true,\n data: result\n } as ApiResponse>);\n \n } catch (error) {\n console.error('Get listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch listings'\n } as ApiResponse, 500);\n }\n});\n\n// Get featured listings\nlistings.get('/featured', async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '6');\n const featuredListings = await PropertyQueries.getFeaturedListings(limit);\n \n return c.json({\n success: true,\n data: featuredListings\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get featured listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch featured listings'\n } as ApiResponse, 500);\n }\n});\n\n// Get single listing by ID\nlistings.get('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n const listing = await PropertyQueries.getListingById(id);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Increment view count\n await PropertyQueries.incrementViews(id);\n \n return c.json({\n success: true,\n data: listing\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch listing'\n } as ApiResponse, 500);\n }\n});\n\n// Create new listing (requires authentication)\nlistings.post('/', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const body: PropertyForm = await c.req.json();\n \n // Validate required fields\n const requiredFields = [\n 'title', 'description', 'price', 'location', \n 'bedrooms', 'bathrooms', 'power_supply', 'furnishing'\n ];\n \n for (const field of requiredFields) {\n if (!body[field] && body[field] !== 0) {\n return c.json({\n success: false,\n message: `${field} is required`\n } as ApiResponse, 400);\n }\n }\n \n // Validate numeric fields\n if (body.price <= 0 || body.bedrooms < 0 || body.bathrooms < 0) {\n return c.json({\n success: false,\n message: 'Price must be positive and bedroom/bathroom counts cannot be negative'\n } as ApiResponse, 400);\n }\n \n // Get user details for agent info\n const user = await UserQueries.getUserById(userId);\n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as ApiResponse, 404);\n }\n \n // Create listing data\n const listingData = {\n ...body,\n agent_id: userId,\n agent_name: user.name,\n agent_phone: user.phone || '',\n agent_email: user.email,\n agent_fee: body.agent_fee || 0,\n legal_fee: body.legal_fee || 0,\n maintenance_fee: body.maintenance_fee || 0,\n images: body.images || []\n };\n \n const listing = await PropertyQueries.createListing(listingData);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Failed to create listing'\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n data: listing,\n message: 'Listing created successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Create listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to create listing'\n } as ApiResponse, 500);\n }\n});\n\n// Update listing (requires authentication and ownership)\nlistings.put('/:id', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const id = parseInt(c.req.param('id'));\n const body = await c.req.json();\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists and user owns it\n const existingListing = await PropertyQueries.getListingById(id);\n if (!existingListing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n if (existingListing.agent_id !== userId) {\n return c.json({\n success: false,\n message: 'You can only update your own listings'\n } as ApiResponse, 403);\n }\n \n // Filter allowed update fields\n const allowedFields = [\n 'title', 'description', 'price', 'location', 'agent_fee', \n 'legal_fee', 'maintenance_fee', 'bedrooms', 'bathrooms', \n 'has_kitchen', 'has_parking', 'has_security', 'power_supply', \n 'furnishing', 'images'\n ];\n \n const updates: any = {};\n for (const field of allowedFields) {\n if (body[field] !== undefined) {\n updates[field] = body[field];\n }\n }\n \n if (Object.keys(updates).length === 0) {\n return c.json({\n success: false,\n message: 'No valid fields to update'\n } as ApiResponse, 400);\n }\n \n const success = await PropertyQueries.updateListing(id, updates);\n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to update listing'\n } as ApiResponse, 500);\n }\n \n const updatedListing = await PropertyQueries.getListingById(id);\n return c.json({\n success: true,\n data: updatedListing,\n message: 'Listing updated successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Update listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to update listing'\n } as ApiResponse, 500);\n }\n});\n\n// Delete listing (requires authentication and ownership)\nlistings.delete('/:id', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const id = parseInt(c.req.param('id'));\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n const success = await PropertyQueries.deleteListing(id, userId);\n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to delete listing or listing not found'\n } as ApiResponse, 404);\n }\n \n return c.json({\n success: true,\n message: 'Listing deleted successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Delete listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to delete listing'\n } as ApiResponse, 500);\n }\n});\n\n// Get user's own listings\nlistings.get('/my/listings', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const userListings = await PropertyQueries.getListingsByAgent(userId);\n \n return c.json({\n success: true,\n data: userListings\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get user listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch your listings'\n } as ApiResponse, 500);\n }\n});\n\n// Save/unsave listing\nlistings.post('/:id/save', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Check if already saved\n const isAlreadySaved = await SavedListingsQueries.isListingSaved(userId, listingId);\n \n let success: boolean;\n let message: string;\n \n if (isAlreadySaved) {\n success = await SavedListingsQueries.unsaveListing(userId, listingId);\n message = success ? 'Listing removed from saved' : 'Failed to remove from saved';\n } else {\n success = await SavedListingsQueries.saveListing(userId, listingId);\n message = success ? 'Listing saved successfully' : 'Failed to save listing';\n }\n \n if (!success) {\n return c.json({\n success: false,\n message\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n message,\n data: { saved: !isAlreadySaved }\n } as ApiResponse);\n \n } catch (error) {\n console.error('Save listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to save/unsave listing'\n } as ApiResponse, 500);\n }\n});\n\n// Get saved listings\nlistings.get('/my/saved', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const savedListings = await SavedListingsQueries.getSavedListings(userId);\n \n return c.json({\n success: true,\n data: savedListings\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get saved listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch saved listings'\n } as ApiResponse, 500);\n }\n});\n\n// Send message to agent\nlistings.post('/:id/chat', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n const body = await c.req.json();\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n if (!body.message || body.message.trim().length === 0) {\n return c.json({\n success: false,\n message: 'Message cannot be empty'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Get user details\n const user = await UserQueries.getUserById(userId);\n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as ApiResponse, 404);\n }\n \n // Create chat message\n const message = await ChatQueries.createMessage({\n listing_id: listingId,\n sender_id: userId,\n sender_name: user.name,\n message: body.message.trim(),\n is_agent: userId === listing.agent_id\n });\n \n if (!message) {\n return c.json({\n success: false,\n message: 'Failed to send message'\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n data: message,\n message: 'Message sent successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Send message error:', error);\n return c.json({\n success: false,\n message: 'Failed to send message'\n } as ApiResponse, 500);\n }\n});\n\n// Get chat messages for a listing\nlistings.get('/:id/chat', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Get messages\n const messages = await ChatQueries.getMessagesByListing(listingId);\n \n // Mark messages as read\n await ChatQueries.markMessagesAsRead(listingId, userId);\n \n return c.json({\n success: true,\n data: messages\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get chat messages error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch messages'\n } as ApiResponse, 500);\n }\n});\n\n// Request inspection\nlistings.post('/:id/inspection', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n const body = await c.req.json();\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Validate required fields\n if (!body.preferred_date || !body.preferred_time) {\n return c.json({\n success: false,\n message: 'Preferred date and time are required'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Get user details\n const user = await UserQueries.getUserById(userId);\n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as ApiResponse, 404);\n }\n \n // Create inspection request\n const success = await InspectionQueries.createRequest({\n listing_id: listingId,\n requester_id: userId,\n requester_name: user.name,\n requester_phone: user.phone || '',\n requester_email: user.email,\n preferred_date: body.preferred_date,\n preferred_time: body.preferred_time,\n message: body.message\n });\n \n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to create inspection request'\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n message: 'Inspection request sent successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Request inspection error:', error);\n return c.json({\n success: false,\n message: 'Failed to request inspection'\n } as ApiResponse, 500);\n }\n});\n\nexport default listings;","deleted","label",[170,171,153],"backend","routes","permalink","https://www.val.town/x/godinoarts/EnuguRent/code/backend/routes/listings.ts","extension","actionData","errors"]