q=hXddlmZmZmZmZmZmZddlmZm Z m Z m Z m Z m Z mZddlmZmZmZmZddlmZmZmZmZmZddlmZedeZeeZde_dZej9d d Zej9d d Zej9d dZej9ddZ ej9ddZ!ej9ddZ"ej9ddZ#ej9ddZ$ej9ddZ%ej9ddZ&ej9ddZ'ejQdd Z)ejTd!Z+ej9d"d#g$d%Z,ej9d&d#g$d'Z-ej9d(d#g$d)Z.ej9d*d+g$ed,Z/dd-lm Z m Z dd.lmZmZej9d/d#g$ed0Z0ej9d/d+g$ed1Z1ej9d/d2g$ed3Z2ej9d4d+g$ed5Z3ej9d6d7Z4ej9d8d9Z5ej9d:d+g$d;Z6ej9dd?Z8y@)A) LoginManager UserMixin login_userlogin_required logout_user current_user) Blueprintrender_template_stringrequestjsonifyflashredirecturl_for)rrrr)UserCityDistrictget_db_connectionbcrypt)geodesicroutesloginu\ Map Immobilier

Immo

Filtres {% if current_user.is_authenticated %} {{ current_user.first_name or 'Mon Compte' }} {% else %} Connexion {% endif %}

Filtres

Transports en commun

Qualité de vie

Sécurité

Prix au m² (max)

10 000 €/m²

Informations

■ Très cher (> 5 000 €/m²)
■ Cher (3 000–5 000 €/m²)
■ Moyen (2 000–3 000 €/m²)
■ Abordable (< 2 000 €/m²)
/c ttSNr html_content/var/www/html/routes.pyhomer s !, //rz/searchchtjjddj}|s t gSt }|j d}|jdd|dd|df|j}|jdd|df|j}|jdd|dd|df|j}|jd d|df|j}|j|j||z|z|z}t |S) NqT dictionarya SELECT cities.insee_code, cities.city_name as name, 'city' as type, cities.insee_code as id, cities.longitude as lng, cities.latitude as lat, cities.postal_code, cities.department_code, departments.department_name, cities.region_code, regions.region_name, p.avg_price_per_sqm_apartment, p.avg_price_per_sqm_house, p.number_of_transactions, (SELECT COUNT(*) FROM districts WHERE districts.insee_code = cities.insee_code) as district_count FROM cities LEFT JOIN departments ON cities.department_code = departments.department_code LEFT JOIN regions ON cities.region_code = regions.region_code LEFT JOIN prices p ON cities.insee_code = p.insee_code AND p.data_year = 2024 WHERE LOWER(CONVERT(cities.city_name USING utf8mb4)) LIKE LOWER(CONVERT(%s USING utf8mb4)) OR cities.postal_code LIKE %s LIMIT 5 %a/ SELECT region_name as name, 'region' as type, region_code as id, longitude as lng, latitude as lat FROM regions WHERE LOWER(CONVERT(region_name USING utf8mb4)) LIKE LOWER(CONVERT(%s USING utf8mb4)) LIMIT 5 ai SELECT department_name as name, 'department' as type, department_code as id, longitude as lng, latitude as lat FROM departments WHERE LOWER(CONVERT(department_name USING utf8mb4)) LIKE LOWER(CONVERT(%s USING utf8mb4)) OR department_code LIKE %s LIMIT 5 aP SELECT district_name as name, 'district' as type, CONCAT(insee_code, '-', district_id) as id, longitude as lng, latitude as lat FROM districts WHERE LOWER(CONVERT(district_name USING utf8mb4)) LIKE LOWER(CONVERT(%s USING utf8mb4)) LIMIT 5 ) r argsgetstripr rcursorexecutefetchallclose)query connectionr*citiesregions departments districtsresultss rsearchr5sU LL  S" % + + -E r{"$J   $  /F NN0 eWA,!E7! %1'4__ F NN  eWA, ooG NN  eWA,!E7! % '//#K NN  eWA, !I LLNw,y8G 7 rz/api/countriesct}|jd}|jd|j}|j |j t |S)NTr$zw SELECT country_code as id, country_name as name, latitude as lat, longitude as lng FROM countries rr*r+r,r-r )connr* countriess r get_countriesr:xsV  D [[D[ )F NN !I LLNJJL 9 rz/regionsct}|jd}d}|j||j}|j |j t |S)NTr$zmSELECT region_code as region_code, region_name as region_name, longitude as lng, latitude as lat FROM regionsr7)r/r*r.r1s r get_regionsr<sZ"$J   $  /F {E NN5ooG LLN 7 rz /departmentsctjjd}tjjd}t}|j d}|rd}|j ||fn#|rd}|j ||fn t gS|j}|j|jt |S)Ndepartment_code region_codeTr$z SELECT department_code, department_name, latitude as lat, longitude as lng FROM departments WHERE department_code = %s z SELECT department_code, department_name, latitude as lat, longitude as lng FROM departments WHERE region_code = %s r r'r(rr*r+r r,r-)r>r?r/r*r.r2s rget_departmentsrAsll&&'89O,,""=1K"$J   $  /F  u01   u{n-r{//#K LLN ; rz/citiesc6tjjd}tjjd}t}|j d}|rd}|j ||fn#|rd}|j ||fn t gS|j}|D]E}|jdd|d<|jdd|d<|jd Ad |d <G|j|jt |S) N insee_coder>Tr$a SELECT cities.insee_code, cities.city_name as name, cities.latitude as lat, cities.longitude as lng, cities.department_code, departments.department_name, cities.region_code, regions.region_name, p.avg_price_per_sqm_apartment, p.avg_price_per_sqm_house, p.number_of_transactions, (SELECT COUNT(*) FROM districts WHERE districts.insee_code = cities.insee_code) as district_count FROM cities LEFT JOIN departments ON cities.department_code = departments.department_code LEFT JOIN regions ON cities.region_code = regions.region_code LEFT JOIN prices p ON cities.insee_code = p.insee_code AND p.data_year = 2024 WHERE cities.insee_code = %s a SELECT cities.insee_code, cities.city_name as name, cities.latitude as lat, cities.longitude as lng, cities.department_code, departments.department_name, cities.region_code, regions.region_name, p.avg_price_per_sqm_apartment, p.avg_price_per_sqm_house, p.number_of_transactions, (SELECT COUNT(*) FROM districts WHERE districts.insee_code = cities.insee_code) as district_count FROM cities LEFT JOIN departments ON cities.department_code = departments.department_code LEFT JOIN regions ON cities.region_code = regions.region_code LEFT JOIN prices p ON cities.insee_code = p.insee_code AND p.data_year = 2024 WHERE cities.department_code = %s avg_price_per_sqm_apartmentavg_price_per_sqm_housenumber_of_transactionsrr@)rCr>r/r*r.r0citys r get_citiesrHs!!,/Jll&&'89O"$J   $  /F ( uzm,  ( u01r{ __ F/ 881 2 :26D. / 88- . 6.2D* + 88, - 5-.D) * / LLN 6?rz /districtscFtjjdd}t}|j d}|rd}|j ||fnd}|j ||j }|j|jt|S)NrCTr$z SELECT insee_code, district_name as name, longitude as lng, latitude as lat FROM districts WHERE insee_code = %s z| SELECT insee_code, district_name as name, longitude as lng, latitude as lat FROM districts ) r r'r(rr*r+r,r-r )rCr/r*r.r3s r get_districtsrJs!!,5J"$J   $  /F  uzm,  u!I LLN 9 rz/region/c ttSrr)r?s r show_regionrL  ", //rz/department/c ttSrr)r>s rshow_departmentrOrMrz/city/-c ttSrr) city_namerCs r show_cityrRrMrz/district/c ttSrr) district_ids r show_districtrUrMrctddfS)Nz404.htmlrV)render_template)es rpage_not_foundrZ!s : & ++rct}|jd}|jd|f|j}|j |j |r t di|Sy)NTr$z&SELECT * FROM users WHERE user_id = %sr)rr*r+fetchoner-r)user_idr/r* user_datas r load_userr_%se#$J   $  /F NN;gZH!I LLN i  rz/loginPOST)methodsc tjjd}tjjd}tjjddk(}|r|stddddfSt }|j d }|j d |f|j}|j|j|rwtj|d |r^td|d |d|d |dd|jDcic] \}}|dvs ||c}}}t||td ddStddddfScc}}w)Nemailpassword remember_meonFz(Email et mot de passe sont obligatoires.successmessageTr$z$SELECT * FROM users WHERE email = %s password_hashr] account_type)r]rcrkrl)rememberuConnexion réussie !z Email ou mot de passe incorrect.ir)r formr(r rr*r+r\r-rcheck_password_hashritemsr) rcrdrer/r*r^kvusers rrr2sX LL  W %E|| +H,,""=1T9K 55_`acfff"$J   $  /F NN9E8D!I LLNV// /0JHU i(G$#O4">2  !* 1t1Q>s5sq!tt   4+.44JKLL55WXY[^^^ us  E'Ez /registerc 4tjjd}tjjd}tjjd}tjjd}tjjd}tjjd}tjjddk(}|r |r|r|r|r|std d d d fS||k7rtd d d d fSt j |j d}t}|j} | jd||||||f|jtddd | j|jS#t$rF} td dt| d dfcYd} ~ | j|jSd} ~ wwxYw#| j|jwxYw)Nrcrdconfirm_passwordrl first_name last_namenewsletter_subscriptionrfFz"Tous les champs sont obligatoires.rgrjz'Les mots de passe ne correspondent pas.zutf-8z INSERT INTO users (email, password_hash, account_type, first_name, last_name, newsletter_subscription) VALUES (%s, %s, %s, %s, %s, %s) TuInscription réussie !zErreur lors de l'inscription : )r rnr(r rgenerate_password_hashdecoderr*r+commitr- Exceptionstr) rcrdrurlrvrwrxrkr/r*rYs rregisterrPs LL  W %E|| +H||''(:;<<##N3L!!,/J   -I%ll../HITQ (8 T^fo55YZ[]```##55^_`beee11(;BB7KM#$J    F  ]L*iI` a  c 44LMN   g57VWZ[\W]V^5_`acfff  g  s0 5F## G2,G-G2G5-G22G55"Hz/logoutc2ttdddS)NTuDéconnexion réussie.rg)rr rrrlogoutrvsM t0HI JJrz /api/accountGETctdtjtjtjtj dS)NT) logged_inrcrlrvrw)r rrcrlrvrwrrr api_accountr{s= ##$11"--!++  r)r r )rrz/api/favoritesctj}|jd}|jd}|jd}t}|j d}|j dt jf|j}|r|dnd}|j d t jf|jd }|s|d k\rtdd d dfS|r|dk\rtddd dfS|j dt j|||f|j|j|jtddd S)N favorite_type favorite_code favorite_nameTr$zZ SELECT is_premium FROM user_subscriptions WHERE user_id = %s is_premiumFzX SELECT COUNT(*) AS count FROM favorites WHERE user_id = %s countzMLimite de 5 favoris atteinte. Passez en version premium pour en ajouter plus.rgi2zLimite de 50 favoris atteinte.zz INSERT INTO favorites (user_id, favorite_type, favorite_code, favorite_name) VALUES (%s, %s, %s, %s) uFavori ajouté avec succès !) r get_jsonr(rr*r+ridr\r r|r-) datarrrr/r* subscriptionrfavorite_counts r add_favoritersu    DHH_-MHH_-MHH_-M#$J   $  /F NN //   ??$L/;l+J NN //   __&w/N .A-56EFGILL L ",55UVWY\\\ NN //=- GI LLN t0OP QQrct}|jd}|jdtjf|j }|j |j td|dS)NTr$z@ SELECT * FROM favorites WHERE user_id = %s )rh favorites)rr*r+rrr,r-r )r/r*rs r get_favoritesrso#$J   $  /F NN // !I LLN t)< ==rDELETEcdtj}|jd}|jd}t}|j }|j dt j||f|j|j|jtdddS)Nrrzl DELETE FROM favorites WHERE user_id = %s AND favorite_type = %s AND favorite_code = %s TuFavori supprimé avec succès !rg) r rr(rr*r+rrr|r-r )rrrr/r*s rdelete_favoriters    DHH_-MHH_-M"$J    F NN //=- 8: LLN t0QR SSrz/api/favorites/checkcztjjd}tjjd}t}|j d}|j dt j||f|jdu}|j|jtd|iS)NtypecodeTr$zn SELECT 1 FROM favorites WHERE user_id = %s AND favorite_type = %s AND favorite_code = %s is_favorite) r r'r(rr*r+rrr\r-r )rrr/r*rs rcheck_favoritersLL$$V,MLL$$V,M"$J   $  /F NN //=- 8://#4/K LLN M;/ 00rz/api/similar_citiesc tjjd}|s tgSd} t }|j dd}|j d|f|j}|r |d|dAtg|r|j|r"|jr|jSSS|d|df}|j d|f|j}g}|D]k}|d|df}t||j} | dks)|d xs|d } |j|d | t| ndt| d |d|dd m|j!dt|dd|r|j|r"|jr|jSSS#t"$rY} t%d| tgcYd} ~ r|j|r"|jr|jSSSd} ~ wwxYw#r|j|r"|jr|jwwwxYw)NrCTr%buffereda/ SELECT c.city_name, c.latitude as lat, c.longitude as lng, p.avg_price_per_sqm_apartment, p.avg_price_per_sqm_house FROM cities c LEFT JOIN prices p ON c.insee_code = p.insee_code AND p.data_year = 2024 WHERE c.insee_code = %s latlnga SELECT c.city_name, c.latitude as lat, c.longitude as lng, p.avg_price_per_sqm_apartment, p.avg_price_per_sqm_house FROM cities c LEFT JOIN prices p ON c.insee_code = p.insee_code AND p.data_year = 2024 WHERE c.insee_code != %s AND c.latitude IS NOT NULL AND c.longitude IS NOT NULL rDrErQ)namepricedistancerrc |dS)Nrr)xs rz$get_similar_cities..s !J-r)keyrz([DEBUG] Erreur dans get_similar_cities: )r r'r(r rr*r+r\r- is_connectedr,r kilometersappendfloatroundsortr}print) rCr/r* current_citycurrent_coords all_citiessimilar_citiesrG city_coordsrrrYs rget_similar_citiesrsl!!,/J r{J1&( ""dT"B ]  ( |E2:l5>Q>Y2;B  LLN *113    4:E'u-|E/BC ] __&  D;U 4K <GGH"}:;^tD]?^%% --2->U5\D %h 2;; '   78~bq)*  LLN *113    4:  8<=r{  LLN *113    4:   LLN *113    4:s>AF3=AF3A%F33 H<HHHHH8Iz/api/prices/c t}|jdd}|jd|f|j}g}|D]`}t |d}t |dd}|dt |dn t |d}|j|j|dbt|gd |j|jS#t$rB} td t| id fcYd} ~ jjSd} ~ wwxYw#jjwxYw) NTrz SELECT data_year AS year, avg_price_per_sqm_apartment, avg_price_per_sqm_house FROM prices WHERE insee_code = %s ORDER BY data_year yearrrDrE)dater) pastPrices futurePriceserrorry) rr*r+r,intrrr isoformatr r-r}r~) rCr/r*r4 past_pricesrowrdate_objrrYs r get_pricesr"sL&( ""dT"B ] //#  OCs6{#DD!Q'HADEbAcAoE#;<=uz{~@Y|Zv[E   (:(:(F!!,/J ,,  5u  -C ,,  5u  -C \\  h%  @F ]     3V $ &!89:C??ooG LLN 7 rN)9 flask_loginrrrrrrflaskr r r r r rrclassesrrrrrgeopy.distancer__name__bp login_manager login_viewrrouter r5r:r<rArHrJrLrOrRrU errorhandlerrZ user_loaderr_rrrrrrrrrrrrrrrrrsff___MMCC#x"R " K Z#00)UUt   *.  >)BBH,. !"0#0 )*0+0 *+0,0 #$0%0,,  (VH%_&_:+x(#)#J)fX&K'K.5'*+#4 VH-(R.(RT UG, >- > XJ/T0T" 5'2131   6!6p $%&: UG,Y-Y< "UG4C5C$#.$$r