/bdd/migre.php
PHP | 1394 lines | 1112 code | 133 blank | 149 comment | 83 complexity | 1948bc906aa01b1f1e6fa8068a8a46b2 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception
Large files files are truncated, but you can click here to view the full file
- <?php
- //connexion ? l'ancienne base
- $ldb = mysql_connect("localhost", "root", "")
- or die("Impossible de se connecter : " . mysql_error());
- mysql_select_db('gevu_solus');
-
- $pdo = new PDO("mysql:host=localhost;port='3306';dbname=gevu_solus", 'root', '');
-
- updLieuxHierarchie(1, 10, 0, 1, 0);
-
- $dbN = "gevu_solus";
-
- //DeleteLieu(500);
-
- $dbO = "gevu_alceane";
- //migreBase($dbN, $dbO);
- //ajusteBase(1);
-
- $dbO = "gevu_pc1";
- //migreBase($dbN, $dbO);
-
-
- $dbO = "gevu_pc2";
- //migreBase($dbN, $dbO);
-
- $dbO = "gevu_trouville";
- $idInstant = 4;
- //migreBase($dbN, $dbO);
- //ajusteBase(1);
-
- $dbO = "gevutrouville";
- $idInstant = 5;
- //migreBase($dbN, $dbO, $idInstant);
-
- $dbO = "gevutrouville1";
- $idInstant = 6;
- //migreBase($dbN, $dbO, $idInstant);
-
- $dbO = "gevutrouville2";
- $idInstant = 7;
- //migreBase($dbN, $dbO, $idInstant);
-
- $dbO = "gevutrouvillevoirie";
- $idInstant = 8;
- //migreBase($dbN, $dbO, $idInstant);
-
- /*
- $dbO = "mundimuzgevu1";
- $idInstant = 9;
- migreBase($dbN, $dbO, $idInstant);
-
- $dbO = "mundimuzgevu2";
- $idInstant = 10;
- migreBase($dbN, $dbO, $idInstant);
-
- $dbO = "mundimuzgevu3";
- $idInstant = 11;
- migreBase($dbN, $dbO, $idInstant);
-
- $dbO = "mundimuzgevu4";
- $idInstant = 12;
- migreBase($dbN, $dbO, $idInstant);
- */
-
- function ModifBranche($r1, $oR, $idInstant){
-
- echo "ModifBranche: ".str_repeat("- ", $r1['niv'])." : ".$r1['lib']."<br/>";
-
- //on ajoute ? la référence
- //les éléments lié au lieu ayant le m?me nom que la référence
- if($r1['nbLieux']>0){
- //récup?ration des éléments liés
- $sql="SELECT CONCAT(e.ids, eR.ids) ids
- FROM (SELECT GROUP_CONCAT(e.id_lieu) ids
- FROM gevu_lieux e
- WHERE e.id_instant = ".$r1['id_instant']." AND e.lft > ".$r1['lft']." AND e.rgt < ".$r1['rgt'].") e
- , (SELECT GROUP_CONCAT(e.id_lieu) ids
- FROM gevu_lieux e
- WHERE e.id_instant = ".$idInstant." AND e.lft > ".$oR['lft']." AND e.rgt < ".$oR['rgt'].") eR";
- //on récup?re les enfants de reférence et ceux ? comparer pour le niveau suivant
- $rs2 = mysql_query($sql);
- $r2=mysql_fetch_array($rs2);
- if($r2["ids"]=="")$ids=-1;else $ids = $r2["ids"];
- if(substr($r2["ids"],-1)==",")$ids=$r2["ids"]."-1";
- CompareBranche($ids.",-2", $idInstant, $oR['id_lieu']);
-
- }
- //si seulement l'identifiant de lieu est différent
- //on met ? jour les éléments liés
- //et on supprime le lieu
- if($r1['id_lieu']!= $oR['id_lieu']){
- if($r1['nbBat']>0){
- $sql="UPDATE gevu_batiments SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbDiag']>0){
- $sql="UPDATE gevu_diagnostics SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbDiagVoi']>0){
- $sql="UPDATE gevu_diagnosticsxvoirie SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbDoc']>0){
- $sql="UPDATE gevu_docsxlieux SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbEsp']>0){
- $sql="UPDATE gevu_espaces SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbEspEx']>0){
- $sql="UPDATE gevu_espacesxexterieurs SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbEspIn']>0){
- $sql="UPDATE gevu_espacesxinterieurs SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbEtab']>0){
- $sql="UPDATE gevu_etablissements SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbGeoR']>0){
- $sql="UPDATE gevu_georss SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbGeo']>0){
- $sql="UPDATE gevu_geos SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbNiv']>0){
- $sql="UPDATE gevu_niveaux SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbObjExt']>0){
- $sql="UPDATE gevu_objetsxexterieurs SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbObjInt']>0){
- $sql="UPDATE gevu_objetsxinterieurs SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbObjVoi']>0){
- $sql="UPDATE gevu_objetsxvoiries SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbObs']>0){
- $sql="UPDATE gevu_observations SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbPar']>0){
- $sql="UPDATE gevu_parcelles SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- if($r1['nbPro']>0){
- $sql="UPDATE gevu_problemes SET id_lieu=".$oR['id_lieu']." WHERE id_lieu = ".$r1['id_lieu'];
- mysql_query($sql);
- }
-
- //on supprime le lieu
- DeleteLieu($r1['id_lieu'], $r1['lft'], $r1['rgt'], $r1['id_instant']);
- }
- }
-
- function ChangeBranche($id_lieuSrc, $lftDst, $idInstantDst, $niv=0){
- //http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
- global $pdo;
-
- $stmt = $pdo->prepare("CALL MoveNode(p1,p2,p3)");
- $stmt->bindParam('p1', $id_lieuSrc, PDO::PARAM_INT);
- $stmt->bindParam('p2', $lftDst, PDO::PARAM_INT);
- $stmt->bindParam('p3', $idInstantDst, PDO::PARAM_INT);
- $stmt->execute();
-
- /*
- $sql="UPDATE gevu_lieux SET rgt = rgt + 2 WHERE rgt > ".$lftDst." AND id_instant=".$idInstantDst;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- //echo "ChangeBranche rgt = rgt + 2: ".$id_lieuSrc." ".mysql_affected_rows()."<br/>";
-
- $sql="UPDATE gevu_lieux SET lft = lft + 2 WHERE lft > ".$lftDst." AND id_instant=".$idInstantDst;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- //echo "ChangeBranche lft = lft + 2 : ".$id_lieuSrc." ".mysql_affected_rows()."<br/>";
-
- $sql="UPDATE gevu_lieux SET lft = ".($lftDst+1).", rgt = ".($lftDst+2).", id_instant=".$idInstantDst." WHERE id_lieu = ".$id_lieuSrc."";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- //echo "ChangeBranche: ".str_repeat("- ", $niv)." < ".$id_lieuSrc." < : ".mysql_affected_rows()."<br/>";
- */
-
- //Met ? jour les enfants du lieu ? ajouter
- $sql="SELECT e.id_lieu, e.niv
- FROM gevu_lieux e
- WHERE e.lieu_parent = $id_lieuSrc";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- //echo "ChangeBranche: ".str_repeat("- ", $niv)." > ".$id_lieuSrc." > : ".mysql_affected_rows()."<br/>";
- while($r=mysql_fetch_array($result)){
- //on ajoute la branche ? la référence
- ChangeBranche($r['id_lieu'], $lftDst+1, $idInstantDst, $r['niv']);
- }
-
-
- }
-
- function DeleteLieu($id_lieu, $lft=-1, $rgt=-1, $idInstant=-1){
-
- $sql="DELETE FROM gevu_batiments WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_diagnostics WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_diagnosticsxvoirie WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_docsxlieux WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_espaces WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_espacesxexterieurs WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_espacesxinterieurs WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_etablissements WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_georss WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_geos WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_niveaux WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_objetsxexterieurs WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_objetsxinterieurs WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_objetsxvoiries WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_observations WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_parcelles WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- $sql="DELETE FROM gevu_problemes WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- if($idInstant==-1){
- $sql="SELECT lft, rgt, id_instant FROM gevu_lieux WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- $r=mysql_fetch_array($result);
- $lft = $r['lft'];
- $rgt = $r['rgt'];
- $idInstant = $r['id_instant'];
- }
-
- /*
- global $pdo;
- $p1 ='PROMOTE';
- $stmt = $pdo->prepare("CALL DeleteNestedSetNode(p1,p2)");
- $stmt->bindParam('p1', $p1, PDO::PARAM_STR);
- $stmt->bindParam('p2', $id_lieu, PDO::PARAM_INT);
- $stmt->execute();
- */
-
- $sql="DELETE FROM gevu_lieux WHERE id_lieu = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "DeleteLieu: ".$id_lieu." ".mysql_affected_rows()."<br/>";
-
- //mise ? jour de la hiérarchie
- $sql="UPDATE gevu_lieux SET rgt = rgt - 1, lft = lft - 1 WHERE id_instant = $idInstant AND lft BETWEEN $lft AND ".$rgt;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
-
- $sql="UPDATE gevu_lieux SET rgt = rgt - 2 WHERE id_instant = $idInstant AND rgt > ".$rgt;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
-
- $sql="UPDATE gevu_lieux SET lft = lft - 2 WHERE id_instant = $idInstant AND lft > ".$rgt;
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
-
- //supprime tous les enfants
- $sql="SELECT id_lieu, lft, rgt, id_instant FROM gevu_lieux WHERE lieu_parent = ".$id_lieu;
- $result = mysql_query($sql);
- if (!$result)echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- while($r=mysql_fetch_array($result)){
- DeleteLieu($r['id_lieu'], $r['lft'], $r['rgt'], $idInstant);
- }
-
- }
-
- function migreBase($dbN, $dbO){
-
- //création d'un instant
- $sql = "INSERT INTO $dbN.gevu_instants (`maintenant`, `ici`, `id_exi`, `nom`) VALUES
- (now(), '-1', 1, 'Migre_GEVU $dbO')";
- $result = mysql_query($sql);
- if (!$result) die('Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>');
- $idInstant = mysql_insert_id();
- echo "$dbO Instant : ".mysql_affected_rows()."<br/>";
-
- //mise ? jour de l'instant de l'univers
- //récup?re les lieux
- $sql = "UPDATE gevu_lieux SET id_instant=".$idInstant." WHERE id_lieu = 1";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
-
- //récup?re les propriété de l'univers
- $sql = "SELECT id_lieu, lft, rgt FROM $dbN.gevu_lieux WHERE id_lieu = 1";
- $result = mysql_query($sql);
- if (!$result) die('Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>');
- $r=mysql_fetch_array($result);
- echo "$dbO univers : ".$r['lft']." - ".$r['rgt']."<br/>";
-
- //LIEUX
- setLieuxHierarchie($r['id_lieu'], $dbN, $dbO, $idInstant, 5479, $r['lft'], $r['rgt']);
- /*pour vérifier
- SELECT CONCAT( REPEAT(' ', COUNT(pl.lib) - 1), l.lib) AS name
- FROM gevu_lieux AS l,
- gevu_lieux AS pl
- WHERE l.lft BETWEEN pl.lft AND pl.rgt
- GROUP BY l.lib
- ORDER BY l.lft
- */
-
- //on met ? jour le droite de l'univers
- $sql = "SELECT MAX(rgt)+1 m FROM gevu_lieux";
- $result = mysql_query($sql);
- $r=mysql_fetch_array($result);
- $sql = "UPDATE gevu_lieux SET rgt=".$r['m']." WHERE id_lieu = 1";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
-
- //DIAGNOSTICS
- //on ne conserve que les réponses 'non' et 'sous réserve'
- // pour les questions qui ne sont pas interméfiaire
- $sql = "INSERT INTO $dbN.gevu_diagnostics
- (id_critere, id_reponse, id_instant, id_lieu, id_donnee, maj)
- SELECT c.id_critere, fdc1.valeur, $idInstant, l.id_lieu, fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'mot_1'
- INNER JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_1'
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fda.id_donnee = fd.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbN.gevu_criteres c ON c.ref = fdc2.valeur
- WHERE fd.id_form =59
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO DIAGNOSTICS : ".mysql_affected_rows()."<br/>";
-
-
- //PROBLEMES
- //on ne conserve que le champ photo
- //les champs 'fichier' et 'doc' devront ?tre ajouter ? la table gevu_doc
- $sql = "INSERT INTO $dbN.gevu_problemes
- (id_lieu, id_critere, num_marker, mesure, observations, fichier, doc, id_instant, id_donnee, maj)
- SELECT l.id_lieu
- , c.id_critere
- , fdc1.valeur
- , fdc11.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc6.valeur
- , $idInstant
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc11 ON fdc11.id_donnee = fd.id_donnee
- AND fdc11.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc ON fdc.id_donnee = fd.id_donnee
- AND fdc.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'texte_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'mot_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'fichier_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'ligne_5'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc6 ON fdc6.id_donnee = fd.id_donnee
- AND fdc6.champ = 'ligne_4'
- LEFT JOIN $dbN.gevu_criteres c ON c.ref = fdc.valeur
- WHERE fd.id_form =60
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO PROBLEMES : ".mysql_affected_rows()."<br/>";
-
-
- //GEOGRAPHIE
- $sql = "INSERT INTO $dbN.gevu_geos
- (id_lieu, id_instant, lat, lng, zoom_min, zoom_max, adresse, id_type_carte, kml, id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc5.valeur
- , fdc6.valeur
- , fdc7.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'ligne_4'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'ligne_7'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc6 ON fdc6.id_donnee = fd.id_donnee
- AND fdc6.champ = 'mot_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc7 ON fdc7.id_donnee = fd.id_donnee
- AND fdc7.champ = 'texte_1'
- WHERE fd.id_form = 1
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO GEOGRAPHIE : ".mysql_affected_rows()."<br/>";
-
- //GEORSS
- $sql = "INSERT INTO $dbN.gevu_georss
- (id_lieu, id_instant, url, id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'url_1'
- WHERE fd.id_form = 81
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO GEORSS : ".mysql_affected_rows()."<br/>";
-
- //NIVEAU
- $sql = "INSERT INTO $dbN.gevu_niveaux
- (id_lieu, id_instant, nom, ref, id_reponse_1, id_reponse_2, id_reponse_3, id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc5.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'mot_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'mot_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'mot_3'
- WHERE fd.id_form = 35
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO NIVEAU : ".mysql_affected_rows()."<br/>";
-
- //BATIMENT
- //les contacts devront ?tre retraités
- //(53, 'ligne_10', 12, 'Coordonnées du gardien'
- //les horaires devront ?tre retraité
- $sql = "INSERT INTO $dbN.gevu_batiments
- (id_lieu, id_instant, nom, ref, adresse, commune, pays, code_postal
- , contact_proprietaire, contact_delegataire, contact_gardien
- , horaires_gardien, horaires_batiment
- , superficie_parcelle, superficie_batiment
- , date_achevement, date_depot_permis, date_reha
- , reponse_1
- , reponse_2
- , reponse_3
- , reponse_4
- , reponse_5
- , reponse_6
- , reponse_7
- , reponse_8
- , reponse_9
- , reponse_10
- , reponse_11
- , reponse_12
- , reponse_13
- , reponse_14
- , reponse_15
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc5.valeur
- , fdc6.valeur
- , fdc7.valeur
- , fdc8.valeur
- , fdc9.valeur
- , fdc10.valeur
- , fdc11.valeur
- , fdc12.valeur
- , fdc13.valeur
- , fdc14.valeur
- , fdc15.valeur
- , fdc16.valeur
- , fdc17.valeur
- , fdc18.valeur
- , fdc19.valeur
- , fdc20.valeur
- , fdc21.valeur
- , fdc22.valeur
- , fdc23.valeur
- , fdc24.valeur
- , fdc25.valeur
- , fdc26.valeur
- , fdc27.valeur
- , fdc28.valeur
- , fdc29.valeur
- , fdc30.valeur
- , fdc31.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'ligne_4'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'ligne_5'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc6 ON fdc6.id_donnee = fd.id_donnee
- AND fdc6.champ = 'code_postal_1'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc7 ON fdc7.id_donnee = fd.id_donnee
- AND fdc7.champ = 'ligne_6'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc8 ON fdc8.id_donnee = fd.id_donnee
- AND fdc8.champ = 'ligne_7'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc9 ON fdc9.id_donnee = fd.id_donnee
- AND fdc9.champ = 'ligne_10'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc10 ON fdc10.id_donnee = fd.id_donnee
- AND fdc10.champ = 'ligne_9'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc11 ON fdc11.id_donnee = fd.id_donnee
- AND fdc11.champ = 'ligne_11'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc12 ON fdc12.id_donnee = fd.id_donnee
- AND fdc12.champ = 'ligne_13'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc13 ON fdc13.id_donnee = fd.id_donnee
- AND fdc13.champ = 'ligne_12'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc14 ON fdc14.id_donnee = fd.id_donnee
- AND fdc14.champ = 'ligne_14'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc15 ON fdc15.id_donnee = fd.id_donnee
- AND fdc15.champ = 'ligne_15'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc16 ON fdc16.id_donnee = fd.id_donnee
- AND fdc16.champ = 'ligne_16'
-
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc17 ON fdc17.id_donnee = fd.id_donnee
- AND fdc17.champ = 'mot_4'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc18 ON fdc18.id_donnee = fd.id_donnee
- AND fdc18.champ = 'mot_5'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc19 ON fdc19.id_donnee = fd.id_donnee
- AND fdc19.champ = 'mot_6'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc20 ON fdc20.id_donnee = fd.id_donnee
- AND fdc20.champ = 'mot_7'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc21 ON fdc21.id_donnee = fd.id_donnee
- AND fdc21.champ = 'mot_9'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc22 ON fdc22.id_donnee = fd.id_donnee
- AND fdc22.champ = 'mot_10'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc23 ON fdc23.id_donnee = fd.id_donnee
- AND fdc23.champ = 'mot_12'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc24 ON fdc24.id_donnee = fd.id_donnee
- AND fdc24.champ = 'mot_13'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc25 ON fdc25.id_donnee = fd.id_donnee
- AND fdc25.champ = 'mot_14'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc26 ON fdc26.id_donnee = fd.id_donnee
- AND fdc26.champ = 'mot_15'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc27 ON fdc27.id_donnee = fd.id_donnee
- AND fdc27.champ = 'mot_16'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc28 ON fdc28.id_donnee = fd.id_donnee
- AND fdc28.champ = 'mot_17'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc29 ON fdc29.id_donnee = fd.id_donnee
- AND fdc29.champ = 'mot_25'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc30 ON fdc30.id_donnee = fd.id_donnee
- AND fdc30.champ = 'mot_27'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc31 ON fdc31.id_donnee = fd.id_donnee
- AND fdc31.champ = 'mot_28'
- WHERE fd.id_form = 53
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO BATIMENT : ".mysql_affected_rows()."<br/>";
-
- //ETABLISSEMENT
- $sql = "INSERT INTO $dbN.gevu_etablissements
- (id_lieu, id_instant, nom, ref, adresse, commune, pays, code_postal
- , contact_proprietaire, contact_delegataire
- , reponse_1
- , reponse_2
- , reponse_3
- , reponse_4
- , reponse_5
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc5.valeur
- , fdc6.valeur
- , fdc7.valeur
- , fdc8.valeur
- , fdc17.valeur
- , fdc18.valeur
- , fdc19.valeur
- , fdc20.valeur
- , fdc21.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'ligne_4'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'ligne_5'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc6 ON fdc6.id_donnee = fd.id_donnee
- AND fdc6.champ = 'code_postal_1'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc7 ON fdc7.id_donnee = fd.id_donnee
- AND fdc7.champ = 'ligne_6'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc8 ON fdc8.id_donnee = fd.id_donnee
- AND fdc8.champ = 'ligne_7'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc17 ON fdc17.id_donnee = fd.id_donnee
- AND fdc17.champ = 'mot_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc18 ON fdc18.id_donnee = fd.id_donnee
- AND fdc18.champ = 'mot_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc19 ON fdc19.id_donnee = fd.id_donnee
- AND fdc19.champ = 'mot_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc20 ON fdc20.id_donnee = fd.id_donnee
- AND fdc20.champ = 'select_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc21 ON fdc21.id_donnee = fd.id_donnee
- AND fdc21.champ = 'select_2'
-
- WHERE fd.id_form = 55
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO ETABLISSEMENT : ".mysql_affected_rows()."<br/>";
-
- //ESPACES
- $sql = "INSERT INTO $dbN.gevu_espaces
- (id_lieu, id_instant, ref
- , id_type_espace
- , reponse_1
- , reponse_2
- , id_type_specifique_int
- , id_type_specifique_ext
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc2.valeur
- , fdc17.valeur
- , fdc18.valeur
- , fdc19.valeur
- , fdc20.valeur
- , fdc21.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc17 ON fdc17.id_donnee = fd.id_donnee
- AND fdc17.champ = 'mot_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc18 ON fdc18.id_donnee = fd.id_donnee
- AND fdc18.champ = 'mot_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc19 ON fdc19.id_donnee = fd.id_donnee
- AND fdc19.champ = 'mot_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc20 ON fdc20.id_donnee = fd.id_donnee
- AND fdc20.champ = 'mot_4'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc21 ON fdc21.id_donnee = fd.id_donnee
- AND fdc21.champ = 'mot_5'
- WHERE fd.id_form = 56
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO ESPACES : ".mysql_affected_rows()."<br/>";
-
- //ESPACES INTERIEURS
- $sql = "INSERT INTO $dbN.gevu_espacesxinterieurs
- (id_lieu, id_instant, nom, ref
- , fonction
- , id_type_specifique_int
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'select_2'
- WHERE fd.id_form = 57
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO ESPACES INTERIEURS : ".mysql_affected_rows()."<br/>";
-
- //PARCELLES
- $sql = "INSERT INTO $dbN.gevu_parcelles
- (id_lieu, id_instant, nom, ref, adresse, commune, pays, code_postal
- , contact_proprietaire
- , reponse_1
- , reponse_2
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc5.valeur
- , ''
- , fdc6.valeur
- , fdc7.valeur
- , fdc17.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'ligne_4'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'ligne_5'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc6 ON fdc6.id_donnee = fd.id_donnee
- AND fdc6.champ = 'code_postal_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc7 ON fdc7.id_donnee = fd.id_donnee
- AND fdc7.champ = 'ligne_6'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc8 ON fdc8.id_donnee = fd.id_donnee
- AND fdc8.champ = 'ligne_7'
-
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc17 ON fdc17.id_donnee = fd.id_donnee
- AND fdc17.champ = 'mot_1'
-
- WHERE fd.id_form = 58
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO PARCELLES : ".mysql_affected_rows()."<br/>";
-
- //ESPACES EXTERIEURS
- $sql = "INSERT INTO $dbN.gevu_espacesxexterieurs
- (id_lieu, id_instant, nom, ref
- , fonction
- , id_type_espace
- , id_type_specifique_ext
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc4.valeur
- , fdc4.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc4 ON fdc4.id_donnee = fd.id_donnee
- AND fdc4.champ = 'select_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc5 ON fdc5.id_donnee = fd.id_donnee
- AND fdc5.champ = 'select_2'
- WHERE fd.id_form = 61
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO ESPACES EXTERIEURS : ".mysql_affected_rows()."<br/>";
-
- //DIAGNOSTICS VOIRIE
- $sql = "INSERT INTO $dbN.gevu_diagnosticsxvoirie
- (id_lieu, id_instant, nom, ref, id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc3.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- WHERE fd.id_form = 62
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO DIAGNOSTICS VOIRIE : ".mysql_affected_rows()."<br/>";
-
- //OBJETS INTERIEURS
- $sql = "INSERT INTO $dbN.gevu_objetsxinterieurs
- (id_lieu, id_instant, nom, ref
- , fonctions
- , reponse_1
- , reponse_2
- , id_type_objet
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc17.valeur
- , fdc18.valeur
- , fdc19.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc17 ON fdc17.id_donnee = fd.id_donnee
- AND fdc17.champ = 'mot_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc18 ON fdc18.id_donnee = fd.id_donnee
- AND fdc18.champ = 'mot_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc19 ON fdc19.id_donnee = fd.id_donnee
- AND fdc19.champ = 'mot_3'
- WHERE fd.id_form = 63
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO OBJETS INTERIEURS : ".mysql_affected_rows()."<br/>";
-
- //OBJETS EXTERIEURS
- $sql = "INSERT INTO $dbN.gevu_objetsxexterieurs
- (id_lieu, id_instant, nom, ref
- , fonctions
- , id_type_objet
- , id_type_objet_ext
- , id_donnee, maj)
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc3.valeur
- , fdc17.valeur
- , fdc18.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_article = fda.id_article
- INNER JOIN $dbN.gevu_lieux l ON l.id_rubrique = a.id_rubrique AND l.id_instant = $idInstant
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc1 ON fdc1.id_donnee = fd.id_donnee
- AND fdc1.champ = 'ligne_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc2 ON fdc2.id_donnee = fd.id_donnee
- AND fdc2.champ = 'ligne_2'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc3 ON fdc3.id_donnee = fd.id_donnee
- AND fdc3.champ = 'ligne_3'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc17 ON fdc17.id_donnee = fd.id_donnee
- AND fdc17.champ = 'select_1'
- LEFT JOIN $dbO.spip_forms_donnees_champs fdc18 ON fdc18.id_donnee = fd.id_donnee
- AND fdc18.champ = 'select_2'
- WHERE fd.id_form = 64
- GROUP BY fd.id_donnee";
- $result = mysql_query($sql);
- if (!$result) echo 'Requ?te invalide : ' . mysql_error().'<br/>'.$sql.'<br/>';
- echo "$dbO OBJETS EXTERIEURS : ".mysql_affected_rows()."<br/>";
-
- //ELEMENTS VOIRIE
- $sql = "INSERT INTO $dbN.gevu_objetsxvoiries
- (id_lieu, id_instant, nom, ref
- , id_type_objet_voirie, id_donnee, maj
- )
- SELECT l.id_lieu
- , $idInstant
- , fdc1.valeur
- , fdc2.valeur
- , fdc18.valeur
- , fd.id_donnee, fd.date
- FROM $dbO.spip_forms_donnees fd
- INNER JOIN $dbO.spip_forms_donnees_articles fda ON fd.id_donnee = fda.id_donnee
- INNER JOIN $dbO.spip_articles a ON a.id_a…
Large files files are truncated, but you can click here to view the full file