+<?php\r
+ header('Content-Type: text/html; charset=UTF-8');\r
+ echo '<?xml version="1.0" encoding="UTF-8" ?>';\r
+ \r
+ require ('constantes.php');\r
+\r
+ $dbconn = pg_connect("host=localhost port=5432 dbname=".$BD." user=appart password=soleil") or die('Connexion impossible : ' . pg_last_error());\r
+ pg_query("SET datestyle = 'SQL, DMY';"); \r
+ \r
+ $inputs;\r
+ $erreur;\r
+ $action;\r
+ require ('traitement_inputs.php');\r
+\r
+?>\r
+\r
+<html>\r
+ <head>\r
+ <title>Appart</title>\r
+ <link rel="stylesheet" href="style.css" type="text/css" />\r
+ <script type="text/javascript" src="script.js" ></script>\r
+ <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>\r
+ <meta http-equiv="content-type" content="text/html; charset=utf-8"/>\r
+ <title>Google Maps JavaScript API Example</title>\r
+ <script src="http://maps.google.com/maps?file=api&v=2.82&key=ABQIAAAAQLBohykzX4xiepOOUu21GhS2JkdUHwPLqAOasxCB2_i_UFsNUhRbVpRM0k1S9wDSYhOD8Hj8bGnqag" type="text/javascript"></script>\r
+ </head>\r
+ <body onload="rafraichirFormulaire(); loadGMap()" onunload="GUnload()">\r
+<?php\r
+ if (isset($erreur) && $erreur != '')\r
+ {\r
+ echo '<div id="erreur" >' . utf8_encode($erreur) . '</div>';\r
+ }\r
+?>\r
+ \r
+ <div id="menus">\r
+ <div class="menu" id="appartements" > \r
+ <h1><a href="?">Appartements</a></h1>\r
+ <a href="index.php">detail</a> <a href="list.php">liste</a>\r
+\r
+ <form method="post" >\r
+ <input type="hidden" name="action" value="ajouter" />\r
+ <input type="submit" value="Nouveau" />\r
+ </form>\r
+<?php\r
+ foreach ($statuts as $statut_num => $statut_nom)\r
+ {\r
+ echo "<h2>$statut_nom</h2>";\r
+\r
+ $result = pg_query("SELECT id, rue, date_visite FROM appart WHERE statut = $statut_num ORDER by statut, " . ($statut_num == '1'? 'date_visite' : 'id'));\r
+ while ($line = pg_fetch_array($result, null, PGSQL_ASSOC))\r
+ {\r
+ echo '<a '.($id == $line['id'] ? 'class="courant"' : '').' href="?action=voir&id='.$line['id'].'">' . $line['id'] . '. ' . $line['rue'] .\r
+ ($statut_num == '1' ? '<p>' .$line['date_visite'] . '</p>' : '' ).\r
+ '</a>';\r
+ }\r
+ pg_free_result($result);\r
+ }\r
+?>\r
+ </div>\r
+ \r
+ <div class="menu">\r
+ <h1>Liens</h1>\r
+<?php\r
+ foreach ($sites as $nom_site => $url)\r
+ {\r
+ echo '<a href="'.$url.'" >'.$nom_site.'</a>';\r
+ }\r
+?>\r
+ </div>\r
+ </div>\r
+ \r
+ <div id="appartement" >\r
+<?php\r
+ $appartData;\r
+ if ($action == "ajouter")\r
+ {\r
+ foreach($champs as $champ => $type)\r
+ $appartData[$champ] = $inputs[$champ];\r
+ }\r
+ else\r
+ {\r
+ $result = pg_query("SELECT * FROM appart WHERE id = $id");\r
+ $appartData = pg_fetch_array($result, null, PGSQL_ASSOC);\r
+ }\r
+?>\r
+ <form method="post" action="index.php?id=<?= $id ?>" >\r
+ <input id="modeFormulaire" type="hidden" name="mode" value="<?= $action == 'ajouter' ? 'enEdition' : 'enConsultation' ?>" />\r
+ <h1>Appartement N°<?= $id ?></h1>\r
+ <button type="button" id="boutonEditer" onclick="editer();" >éditer</button>\r
+ <div id="boutonsEdition" style="display:none">\r
+ <input type="submit" name="action" value="Supprimer" onclick="return supprimer('<?= $appartData['id'] ?>', '<?= $appartData['rue'] ?>')" />\r
+ <input type="submit" name="action" value="Annuler" />\r
+ <input type="submit" name="action" value="Mémoriser" />\r
+ </div>\r
+ <table id="tableauFormulaire">\r
+ <tr><th class="header1Label"></th><th class="headerInput"></th><th class="header2Label"></th><th class="headerInput"></th></tr>\r
+ <tr>\r
+ <td >\r
+ Statut\r
+ </td>\r
+ <td>\r
+ <select id="editionStatut" size="1" name="statut" style="display: none">\r
+<?php\r
+ foreach ($statuts as $num => $statut)\r
+ echo '<option '. ($appartData['statut'] == $num ? 'selected' : '') . ' value="' . $num .'">' . $statuts[$num] . '</option>';\r
+?>\r
+ </select>\r
+ <p id="consultationStatut" style="display: none"><?= $statuts[$appartData['statut']] ?></p>\r
+ </td>\r
+ <td >Lien internet</td>\r
+ <td><input id="urlEdition" style="display:none" type="text" name="url" value="<?= $appartData['url'] ?>" /><a style="display:none" id="urlConsultation" href="<?= $appartData['url'] ?>">GO!</a></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Prix + charges</td>\r
+ <td><input type="text" class="short" name="prix" value="<?= $appartData['prix'] ?>" /> + <input type="text" class="short" name="prixcharges" value="<?= $appartData['prixcharges'] ?>" /> = <bold><?= $appartData['prix'] + $appartData['prixcharges'] ?></bold></td>\r
+ <td rowspan="3" >Contact</td>\r
+ <td rowspan="3"><textarea name="contact" rows="4"><?= $appartData['contact'] ?></textarea></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Libre à partir du <span class="exemple" >(ex: "1/08/2007")</span></td>\r
+ <td><input type="text" name="date_libre" value="<?= $appartData['date_libre'] ?>" /></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Rue</td>\r
+ <td><input id="inputRue" type="text" name="rue" value="<?= $appartData['rue'] ?>" /></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Localité</td>\r
+ <td><input id="inputLocalite" type="text" name="localite" value="<?= $appartData['localite'] ?>" /></td>\r
+ <td rowspan="5" >Description</td>\r
+ <td rowspan="5"><textarea rows="8" name="description"><?= $appartData['description'] ?></textarea></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Nombre de pièce</td>\r
+ <td><input type="text" name="nbpiece" value="<?= $appartData['nbpiece'] ?>" /></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Surface</td>\r
+ <td><input type="text" name="surface" value="<?= $appartData['surface'] ?>" /></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Étage</td>\r
+ <td><input type="text" name="etage" value="<?= $appartData['etage'] ?>" /></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Dernière rénovation (année)</td>\r
+ <td><input type="text" name="annee_construction" value="<?= $appartData['annee_construction'] ?>" /></td>\r
+ </tr> \r
+ <tr>\r
+ <td colspan="2" >Points Positifs</td>\r
+ <td colspan="2" >Points négatifs</td>\r
+ </tr>\r
+ <tr>\r
+ <td colspan="2"><textarea rows="5" name="points_positifs"><?= $appartData['points_positifs'] ?></textarea></td>\r
+ <td colspan="2"><textarea rows="5" name="points_negatifs"><?= $appartData['points_negatifs'] ?></textarea></td>\r
+ </tr>\r
+ <tr>\r
+ <td colspan="4">\r
+ <h2>Visite</h2>\r
+ </td>\r
+ </tr>\r
+ <tr>\r
+ <td >Date et heure de la visite <span class="exemple" >(ex: "23/07/2007 14:23")</span></td>\r
+ <td colspan="3"><input type="text" name="date_visite" value="<?= $appartData['date_visite'] ?>" /></td>\r
+ </tr>\r
+ <tr>\r
+ <td >Indications</td>\r
+ <td colspan="3"><textarea rows="3" name="visite_indications"><?= $appartData['visite_indications'] ?></textarea></td>\r
+ </tr>\r
+ <tr>\r
+ <td colspan="4">\r
+ <h2>Map</h2>\r
+ </td>\r
+ </tr>\r
+ <!-- tr>\r
+ <td>\r
+ Url google map\r
+ </td>\r
+ <td colspan="3"><input id="urlmapEdition" style="display:none" type="text" name="url_map" value="<?= $appartData['url_map'] ?>" /><a style="display:none" id="urlmapConsultation" href="<?= $appartData['url_map'] ?>">GO!</a></td>\r
+ </tr -->\r
+ <tr>\r
+ <td colspan="4" >\r
+ <div id="map"></div>\r
+ <div id="map2"></div>\r
+ </td>\r
+ </tr>\r
+ </table>\r
+ </form>\r
+<?php\r
+ pg_free_result($result);\r
+?>\r
+ </div>\r
+ \r
+ </body>\r
+</html>\r
+\r
+<?php\r
+ pg_close($dbconn);\r
+?>\r