[{"_1":2,"_173":-5,"_174":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4665abaede64d7a40f12c22a2a13ecb98867c1ee","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_170":171,"_172":-5},"handle","Dhanu","name","ddd","path","backend/controllers/propertyController.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","7cf1d8e8-321a-11f0-ac20-569c3dd06744","createdAt",["D",1747374979522],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","02238e10-e353-11ef-b673-418b1ccb9969","pinnedFileId","pinPreview","screenshotVersion","likeCount","ceb3f831-e4be-46b5-9ad7-26ab762b1fc7","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzYjhwWEhQbzNITFJzSE1OZkI0dUhxZFowYiIsImluaXRpYWxzIjoiRFIifQ","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",26,"7cf24cc4-321a-11f0-ac20-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"9bce9614-321c-11f0-805f-569c3dd06744","propertyController.ts","fileId","3c1fbd60-321c-11f0-9a48-569c3dd06744","parentId","4f913d82-eff3-4f03-ae9c-8dab1b21a916","branchId","branchVersion",24,"latest",true,["D",1747375890287],1,"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { \n Property, \n Address, \n PropertyType, \n PropertyStatus, \n PropertyFilter,\n PaginatedResponse,\n User\n} from \"../../shared/types.ts\";\nimport { PROPERTIES_TABLE, USERS_TABLE } from \"../database/schema.ts\";\n\n// Helper function to build property object from database row\nexport function buildPropertyFromRow(row: any): Property {\n return {\n id: row.id,\n title: row.title,\n description: row.description,\n price: row.price,\n address: {\n street: row.street,\n city: row.city,\n state: row.state,\n zipCode: row.zipCode,\n country: row.country,\n latitude: row.latitude,\n longitude: row.longitude\n },\n type: row.type as PropertyType,\n status: row.status as PropertyStatus,\n bedrooms: row.bedrooms,\n bathrooms: row.bathrooms,\n area: row.area,\n yearBuilt: row.yearBuilt,\n features: JSON.parse(row.features),\n amenities: JSON.parse(row.amenities),\n images: JSON.parse(row.images),\n agentId: row.agentId,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt\n };\n}\n\n// Get all properties with pagination and filtering\nexport async function getProperties(\n page: number = 1, \n limit: number = 10,\n filter?: PropertyFilter\n): Promise> {\n try {\n let query = `SELECT p.*, u.name as agentName, u.email as agentEmail, u.phone as agentPhone, u.avatar as agentAvatar\n FROM ${PROPERTIES_TABLE} p\n LEFT JOIN ${USERS_TABLE} u ON p.agentId = u.id`;\n \n const queryParams: any[] = [];\n const whereConditions: string[] = [];\n \n // Apply filters if provided\n if (filter) {\n if (filter.search) {\n whereConditions.push(`(p.title LIKE ? OR p.description LIKE ? OR p.city LIKE ? OR p.state LIKE ?)`);\n const searchTerm = `%${filter.search}%`;\n queryParams.push(searchTerm, searchTerm, searchTerm, searchTerm);\n }\n \n if (filter.minPrice !== undefined) {\n whereConditions.push(`p.price >= ?`);\n queryParams.push(filter.minPrice);\n }\n \n if (filter.maxPrice !== undefined) {\n whereConditions.push(`p.price <= ?`);\n queryParams.push(filter.maxPrice);\n }\n \n if (filter.type) {\n whereConditions.push(`p.type = ?`);\n queryParams.push(filter.type);\n }\n \n if (filter.status) {\n whereConditions.push(`p.status = ?`);\n queryParams.push(filter.status);\n }\n \n if (filter.bedrooms !== undefined) {\n whereConditions.push(`p.bedrooms >= ?`);\n queryParams.push(filter.bedrooms);\n }\n \n if (filter.bathrooms !== undefined) {\n whereConditions.push(`p.bathrooms >= ?`);\n queryParams.push(filter.bathrooms);\n }\n \n if (filter.minArea !== undefined) {\n whereConditions.push(`p.area >= ?`);\n queryParams.push(filter.minArea);\n }\n \n if (filter.maxArea !== undefined) {\n whereConditions.push(`p.area <= ?`);\n queryParams.push(filter.maxArea);\n }\n \n if (filter.city) {\n whereConditions.push(`p.city LIKE ?`);\n queryParams.push(`%${filter.city}%`);\n }\n \n if (filter.state) {\n whereConditions.push(`p.state LIKE ?`);\n queryParams.push(`%${filter.state}%`);\n }\n }\n \n // Add WHERE clause if there are conditions\n if (whereConditions.length > 0) {\n query += ` WHERE ${whereConditions.join(\" AND \")}`;\n }\n \n // Count total matching properties\n const countQuery = `SELECT COUNT(*) as total FROM (${query})`;\n const countResult = await sqlite.execute(countQuery, queryParams);\n const total = countResult.rows[0].total;\n \n // Add pagination\n query += ` ORDER BY p.createdAt DESC LIMIT ? OFFSET ?`;\n queryParams.push(limit, (page - 1) * limit);\n \n // Execute query\n const result = await sqlite.execute(query, queryParams);\n \n // Build property objects with agent info\n const properties = result.rows.map(row => {\n const property = buildPropertyFromRow(row);\n \n // Add agent info if available\n if (row.agentName) {\n property.agent = {\n id: row.agentId,\n name: row.agentName,\n email: row.agentEmail,\n role: \"agent\",\n phone: row.agentPhone,\n avatar: row.agentAvatar,\n createdAt: \"\"\n };\n }\n \n return property;\n });\n \n return {\n items: properties,\n total,\n page,\n limit,\n totalPages: Math.ceil(total / limit)\n };\n } catch (error) {\n console.error(\"Error getting properties:\", error);\n throw error;\n }\n}\n\n// Get property by ID\nexport async function getPropertyById(id: number): Promise {\n try {\n const query = `\n SELECT p.*, u.name as agentName, u.email as agentEmail, u.phone as agentPhone, u.avatar as agentAvatar\n FROM ${PROPERTIES_TABLE} p\n LEFT JOIN ${USERS_TABLE} u ON p.agentId = u.id\n WHERE p.id = ?\n `;\n \n const result = await sqlite.execute(query, [id]);\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n const property = buildPropertyFromRow(row);\n \n // Add agent info if available\n if (row.agentName) {\n property.agent = {\n id: row.agentId,\n name: row.agentName,\n email: row.agentEmail,\n role: \"agent\",\n phone: row.agentPhone,\n avatar: row.agentAvatar,\n createdAt: \"\"\n };\n }\n \n return property;\n } catch (error) {\n console.error(`Error getting property ${id}:`, error);\n return null;\n }\n}\n\n// Create new property\nexport async function createProperty(propertyData: Omit, userId: number): Promise {\n try {\n const now = new Date().toISOString();\n \n const result = await sqlite.execute(\n `INSERT INTO ${PROPERTIES_TABLE} (\n title, description, price, street, city, state, zipCode, country, \n latitude, longitude, type, status, bedrooms, bathrooms, area, \n yearBuilt, features, amenities, images, agentId, createdAt, updatedAt\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [\n propertyData.title,\n propertyData.description,\n propertyData.price,\n propertyData.address.street,\n propertyData.address.city,\n propertyData.address.state,\n propertyData.address.zipCode,\n propertyData.address.country,\n propertyData.address.latitude || null,\n propertyData.address.longitude || null,\n propertyData.type,\n propertyData.status,\n propertyData.bedrooms,\n propertyData.bathrooms,\n propertyData.area,\n propertyData.yearBuilt || null,\n JSON.stringify(propertyData.features),\n JSON.stringify(propertyData.amenities),\n JSON.stringify(propertyData.images),\n userId, // Use the authenticated user's ID as the agent\n now,\n now\n ]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return buildPropertyFromRow(result.rows[0]);\n } catch (error) {\n console.error(\"Error creating property:\", error);\n return null;\n }\n}\n\n// Update property\nexport async function updateProperty(\n id: number, \n propertyData: Partial,\n userId: number,\n isAdmin: boolean\n): Promise {\n try {\n // Check if property exists and belongs to the user (unless admin)\n const existingProperty = await getPropertyById(id);\n \n if (!existingProperty) {\n return null;\n }\n \n // Only allow update if user is the agent or an admin\n if (!isAdmin && existingProperty.agentId !== userId) {\n return null;\n }\n \n const updates: string[] = [];\n const values: any[] = [];\n \n // Build update query dynamically based on provided fields\n if (propertyData.title !== undefined) {\n updates.push(\"title = ?\");\n values.push(propertyData.title);\n }\n \n if (propertyData.description !== undefined) {\n updates.push(\"description = ?\");\n values.push(propertyData.description);\n }\n \n if (propertyData.price !== undefined) {\n updates.push(\"price = ?\");\n values.push(propertyData.price);\n }\n \n if (propertyData.address) {\n if (propertyData.address.street !== undefined) {\n updates.push(\"street = ?\");\n values.push(propertyData.address.street);\n }\n \n if (propertyData.address.city !== undefined) {\n updates.push(\"city = ?\");\n values.push(propertyData.address.city);\n }\n \n if (propertyData.address.state !== undefined) {\n updates.push(\"state = ?\");\n values.push(propertyData.address.state);\n }\n \n if (propertyData.address.zipCode !== undefined) {\n updates.push(\"zipCode = ?\");\n values.push(propertyData.address.zipCode);\n }\n \n if (propertyData.address.country !== undefined) {\n updates.push(\"country = ?\");\n values.push(propertyData.address.country);\n }\n \n if (propertyData.address.latitude !== undefined) {\n updates.push(\"latitude = ?\");\n values.push(propertyData.address.latitude);\n }\n \n if (propertyData.address.longitude !== undefined) {\n updates.push(\"longitude = ?\");\n values.push(propertyData.address.longitude);\n }\n }\n \n if (propertyData.type !== undefined) {\n updates.push(\"type = ?\");\n values.push(propertyData.type);\n }\n \n if (propertyData.status !== undefined) {\n updates.push(\"status = ?\");\n values.push(propertyData.status);\n }\n \n if (propertyData.bedrooms !== undefined) {\n updates.push(\"bedrooms = ?\");\n values.push(propertyData.bedrooms);\n }\n \n if (propertyData.bathrooms !== undefined) {\n updates.push(\"bathrooms = ?\");\n values.push(propertyData.bathrooms);\n }\n \n if (propertyData.area !== undefined) {\n updates.push(\"area = ?\");\n values.push(propertyData.area);\n }\n \n if (propertyData.yearBuilt !== undefined) {\n updates.push(\"yearBuilt = ?\");\n values.push(propertyData.yearBuilt);\n }\n \n if (propertyData.features !== undefined) {\n updates.push(\"features = ?\");\n values.push(JSON.stringify(propertyData.features));\n }\n \n if (propertyData.amenities !== undefined) {\n updates.push(\"amenities = ?\");\n values.push(JSON.stringify(propertyData.amenities));\n }\n \n if (propertyData.images !== undefined) {\n updates.push(\"images = ?\");\n values.push(JSON.stringify(propertyData.images));\n }\n \n // Always update the updatedAt timestamp\n updates.push(\"updatedAt = ?\");\n values.push(new Date().toISOString());\n \n // If no fields to update, return the existing property\n if (updates.length === 0) {\n return existingProperty;\n }\n \n // Add property ID to values\n values.push(id);\n \n const result = await sqlite.execute(\n `UPDATE ${PROPERTIES_TABLE} SET ${updates.join(\", \")} WHERE id = ? RETURNING *`,\n values\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return buildPropertyFromRow(result.rows[0]);\n } catch (error) {\n console.error(`Error updating property ${id}:`, error);\n return null;\n }\n}\n\n// Delete property\nexport async function deleteProperty(\n id: number,\n userId: number,\n isAdmin: boolean\n): Promise {\n try {\n // Check if property exists and belongs to the user (unless admin)\n const existingProperty = await getPropertyById(id);\n \n if (!existingProperty) {\n return false;\n }\n \n // Only allow deletion if user is the agent or an admin\n if (!isAdmin && existingProperty.agentId !== userId) {\n return false;\n }\n \n await sqlite.execute(\n `DELETE FROM ${PROPERTIES_TABLE} WHERE id = ?`,\n [id]\n );\n \n return true;\n } catch (error) {\n console.error(`Error deleting property ${id}:`, error);\n return false;\n }\n}\n\n// Get featured properties (for homepage)\nexport async function getFeaturedProperties(limit: number = 6): Promise {\n try {\n const query = `\n SELECT p.*, u.name as agentName, u.email as agentEmail, u.phone as agentPhone, u.avatar as agentAvatar\n FROM ${PROPERTIES_TABLE} p\n LEFT JOIN ${USERS_TABLE} u ON p.agentId = u.id\n WHERE p.status IN (?, ?)\n ORDER BY p.createdAt DESC\n LIMIT ?\n `;\n \n const result = await sqlite.execute(query, [\n PropertyStatus.FOR_SALE,\n PropertyStatus.FOR_RENT,\n limit\n ]);\n \n return result.rows.map(row => {\n const property = buildPropertyFromRow(row);\n \n // Add agent info if available\n if (row.agentName) {\n property.agent = {\n id: row.agentId,\n name: row.agentName,\n email: row.agentEmail,\n role: \"agent\",\n phone: row.agentPhone,\n avatar: row.agentAvatar,\n createdAt: \"\"\n };\n }\n \n return property;\n });\n } catch (error) {\n console.error(\"Error getting featured properties:\", error);\n return [];\n }\n}\n\n// Get properties by agent\nexport async function getPropertiesByAgent(agentId: number): Promise {\n try {\n const query = `\n SELECT * FROM ${PROPERTIES_TABLE}\n WHERE agentId = ?\n ORDER BY createdAt DESC\n `;\n \n const result = await sqlite.execute(query, [agentId]);\n \n return result.rows.map(row => buildPropertyFromRow(row));\n } catch (error) {\n console.error(`Error getting properties for agent ${agentId}:`, error);\n return [];\n }\n}","deleted","label",[168,169,149],"backend","controllers","permalink","https://www.val.town/x/Dhanu/ddd/code/backend/controllers/propertyController.ts","extension","actionData","errors"]