WebSVN – eFlore/Projets.eflore-projets – Diff – /trunk/scripts/modules/osm/OrdonneurDeChemins.php

 <?php
 /**
  * Traitement de l'ordre :
+ *
  * Fonction qui rajoute l'ordre et le sens de chaque way d'une relation dans la table `osm_relation_a_chemins`
+ *
  * Exemple de lancement du script :
  * /opt/lampp/bin/php -d memory_limit=8000M cli.php osm -a ordre -m manuel
+ *
  */
 class OrdonneurDeChemins {
 	private $conteneur;
 	private $bdd;
 	private $messages;
 	private $mode;
 	private $premierNoeudPolygon = null;
 	private $infosRel = array();
 	private $infosNoeuds = array();
 	private $idRelation = null;
 	private $idChemin = null;
 	private $idNoeud = null;
 	private $ordre = 0;
 	public function __construct($conteneur) {
 		$this->conteneur = $conteneur;
 		$this->bdd = $this->conteneur->getBdd();
 		$this->messages = $this->conteneur->getMessages();
 		$this->mode = $this->conteneur->getParametre('m');
+	}
 	public function executer() {
 		$relations = $this->getToutesRelationsAChemins();
 		if ($this->mode == 'manuel') {
 			$this->messages->traiterInfo("Nombre de relations : %s", array(count($relations)));
+		}
 		foreach ($relations as $relation) {
 			// Traitement de la relation courante
 			$this->idRelation = $relation['id_relation'];
 			$this->chargerDonneesRelationActuelle();
-			// Selection du premier chemin comme chemin actuel
+			$numPolygon = 1;
-			$this->idChemin = $this->getIdPremierChemin();
+			while(count($this->chemins) > 0) {
-			$this->mettreAJourChemin('directe', __LINE__);
+				reset($this->chemins);
-			// Selection du dernier noeud comme noeud actuel
+				$idChemin = key($this->chemins);
-			$idDernierNoeud = $this->getIdDernierNoeud();
+				echo "--------------POLY : $numPolygon : $idChemin\n";
-			if ($idDernierNoeud) {
+				$this->ordonnerCheminsRelation($numPolygon, $idChemin);
-				$this->idNoeud = $idDernierNoeud;
+				$this->mettreAJourRelationAChemin();
-				$this->ordonnerChemins();
+				$numPolygon++;
+			}
 			// Affichage de l'avancement
 			if ($this->mode == 'manuel') {
 				$this->messages->afficherAvancement("Ordone les chemins de la relation : ", 1);
+			}
+		}
+	}
 	private function getToutesRelationsAChemins() {
 		$requete = 'SELECT DISTINCT id_relation '.
 			'FROM osm_relation_a_chemins '.
+			'WHERE id_relation = 403823 '.
 			' -- '.__FILE__.' : '.__LINE__;
 		$relations = $this->bdd->recupererTous($requete);
 		return $relations;
+	}
 	private function chargerDonneesRelationActuelle() {
 		$requete = 'SELECT cn.id_chemin, cn.id_noeud, cn.ordre '.
 			'FROM osm_relation_a_chemins AS rc '.
 			'	INNER JOIN osm_chemin_a_noeuds AS cn ON (rc.id_chemin = cn.id_chemin) '.
 			"WHERE rc.id_relation = {$this->idRelation} ".
-			"ORDER BY cn.ordre ASC ".
+			"ORDER BY rc.ordre ASC, cn.ordre ASC ".
 			' -- '.__FILE__.' : '.__LINE__;
 		$infos = $this->bdd->recupererTous($requete);
+		$noeuds = array();
 		foreach ($infos as $info) {
-			$this->infosRel[$info['id_chemin']][$info['id_noeud']] = $info['ordre'];
+			$noeuds[$info['id_noeud']][$info['id_chemin']] = $info['ordre'];
-			if (! isset($this->infosNoeuds[$info['id_noeud']][$info['id_chemin']])) {
+			if (! isset($this->chemins[$info['id_chemin']]) ) {
+				$this->chemins[$info['id_chemin']]['max'] == info['ordre'];
+				if ($info['ordre'] == 1) {
-				$this->infosNoeuds[$info['id_noeud']][$info['id_chemin']] = 1;
+					$this->chemins[$info['id_chemin']][0] == $info['id_noeud'];
+				}
 			} else {
+			}
+			if (count($noeuds[$info['id_noeud']]) == 2) {
+				list($premierChemin, $dernierChemin) = array_keys($noeuds[$info['id_noeud']]);
+				$this->chemins[$premierChemin][] = $info['id_noeud'];
+				$this->chemins[$dernierChemin][] = $info['id_noeud'];
+				$this->noeuds[$info['id_noeud']][$premierChemin] = $dernierChemin;
-				$this->infosNoeuds[$info['id_noeud']][$info['id_chemin']]++;
+				$this->noeuds[$info['id_noeud']][$dernierChemin] = $premierChemin;
+			}
+		}
-		//print_r($this->infosNoeuds);exit();
+		//print_r($this->chemins);exit();
+	}
+	private function ordonnerCheminsRelation($numPolygon, $idChemin, $idCheminPrecedent = null, $ordre = 1) {
+		$this->infosRel[$idChemin] = array($ordre, $numPolygon);
+		list($premierNoeud, $dernierNoeud) = $this->chemins[$idChemin];
+		if ($idCheminPrecedent == null) {// Premier chemin à tester
+			$this->premierNoeudPolygon = $premierNoeud;
+			$noeudSuivant = ($dernierNoeud == $premierNoeud) ? $premierNoeud : $dernierNoeud;
+			echo "Chemin $idChemin :: premierNoeud: $premierNoeud, dernierNoeud: $dernierNoeud \n";
+		} else {
+			list($premierNoeudPrec, $dernierNoeudPrec) = $this->chemins[$idCheminPrecedent];
+			unset($this->chemins[$idCheminPrecedent]);
+			$noeudSuivant = ($dernierNoeudPrec == $dernierNoeud || $premierNoeudPrec == $dernierNoeud) ? $premierNoeud : $dernierNoeud;
+			echo "Chemin $idChemin :: premierNoeudPrec: $premierNoeudPrec, dernierNoeudPrec: $dernierNoeudPrec, premierNoeud: $premierNoeud, dernierNoeud: $dernierNoeud \n";
+		}
+		if ($this->premierNoeudPolygon != $noeudSuivant) {
+			if (isset($this->noeuds[$noeudSuivant][$idChemin])) {
+				$idCheminSuivant = $this->noeuds[$noeudSuivant][$idChemin];
+				if (! isset($this->infosRel[$idCheminSuivant])) {
+					$this->ordonnerCheminsRelation($numPolygon, $idCheminSuivant, $idChemin, ++$ordre);
+				} else {
+					$this->messages->traiterAvertissement("Chemins %s déjà pris en comtpe", array($idCheminSuivant));
+				}
+			} else {
+				$this->messages->traiterAvertissement("Relation %s a un polygone incomplet", array($this->idRelation));
+			}
+		} else {
+			unset($this->chemins[$idChemin]);
+		}
+		return null;
+	}
+	private function mettreAJourRelationAChemin() {
+		if (count($this->infosRel) > 0) {
+			foreach ($this->infosRel as $idC => $donnees) {
+				list($ordre, $numPolygon) = $this->bdd->proteger($donnees);
+				$requete = 'UPDATE osm_relation_a_chemins '.
+					"SET sens = $ordre, num_poly = $numPolygon ".
+					"WHERE id_relation = {$this->idRelation} ".
+					"AND id_chemin = $idC ".
+					' -- '.__FILE__.' : '.__LINE__;
+				$this->bdd->requeter($requete);
+			}
-		$this->ordre = 0;
+			$this->infosRel = array();
+		}
+	}
+	private function creerSet($donnees) {
+		$values = array();
+		foreach ($donnees as $infos) {
+			$infosP = $this->bdd->proteger($infos);
+			$values[] = implode(',', $infosP);
+		}
+		$valuesClause = '('.implode('),(', $values).')';
+		return $valuesClause;
+	}
 	private function getIdPremierChemin() {
 		$idChemin = null;
 		if (count($this->infosRel) > 0) {
 			reset($this->infosRel);
 			$idChemin = key($this->infosRel);
+		}
 		return $idChemin;
+	}
 	private function mettreAJourChemin($sens, $ligne, $fichier = __FILE__) {
 		$ordre = $this->ordre++;
 		$requete = 'UPDATE osm_relation_a_chemins '.
 			"SET ordre = '$ordre', sens = '$sens' ".
 			"WHERE id_relation = {$this->idRelation} ".
 			"AND id_chemin = {$this->idChemin} ".
 			" -- $fichier : $ligne";
 		$retour = $this->bdd->requeter($requete);
 		return $retour;
+	}
 	private function getIdDernierNoeud() {
 		$idNoeud = false;
 		if (count($this->infosRel[$this->idChemin]) > 0) {
 			end($this->infosRel[$this->idChemin]);
-			$idNoeud = key($this->infosRel[$this->idChemin]);
+			$idNoeud = current($this->infosRel[$this->idChemin]);
+		}
 		return $idNoeud;
+	}
 	private function ordonnerChemins() {
 		foreach ($this->infosRel as $chemin) {
 			// Selection du chemin qui possède le dernier noeud du précédent chemin et écarter l'actuel
 			$idCheminSuivant = $this->getIdCheminSuivant();
 			if ($idCheminSuivant) {
 				$this->idChemin = $idCheminSuivant;
 				$idPremierNoeud = $this->getIdPremierNoeud();
 				$idDernierNoeud = $this->getIdDernierNoeud();
 				$sens = $this->getSens($idPremierNoeud);
 				$this->mettreAJourChemin($sens, __LINE__);
 				$this->idNoeud =  ($sens == 'directe') ? $idDernierNoeud : $idPremierNoeud;
+			}
+		}
+	}
 	private function getIdCheminSuivant() {
 		$idCheminSuivant = false;
 		if (isset($this->infosNoeuds[$this->idNoeud])) {
-			$cheminsIds = array_keys($this->infosNoeuds[$this->idNoeud]);
+			$idCheminSuivant = next($this->infosNoeuds[$this->idNoeud]);
-			foreach ($cheminsIds as $idChemin) {
-				if ($idChemin != $this->idChemin) {
+			//echo $this->idChemin.'-'.$idCheminSuivant."\n".print_r($this->infosNoeuds[$this->idNoeud]); exit();
-					$idCheminSuivant = $idChemin;
-					break;
-				}
-			}
 		} else {
 			$msg = "Impossible de trouver le chemin suivant pour la relation : %s, le chemin %s et le noeud %s";
 			$this->messages->traiterAvertissement($msg, array($this->idRelation, $this->idChemin, $this->idNoeud));
+		}
 		return $idCheminSuivant;
+	}
 	private function getSens($idPremierNoeud) {
 		$sens = ( strcmp($idPremierNoeud, $this->idNoeud ) == 0 ) ? 'directe' : 'indirecte';
 		return $sens;
+	}
 	private function getIdPremierNoeud() {
 		$idNoeud = false;
 		if (count($this->infosRel[$this->idChemin]) > 0) {
 			reset($this->infosRel[$this->idChemin]);
-			$idNoeud = key($this->infosRel[$this->idChemin]);
+			$idNoeud = current($this->infosRel[$this->idChemin]);
+		}
 		return $idNoeud;
+	}
+}

Subversion Repositories eFlore/Projets.eflore-projets

(root)/trunk/scripts/modules/osm/OrdonneurDeChemins.php @ 1060 – Rev 1047 → 1055