Subversion Repositories eFlore/Projets.eflore-projets

<?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();

			$numPolygon = 1;

			while(count($this->chemins) > 0) {

				reset($this->chemins);

				$idChemin = key($this->chemins);

				echo "--------------POLY : $numPolygon : $idChemin\n";

				$this->ordonnerCheminsRelation($numPolygon, $idChemin);

				$this->mettreAJourRelationAChemin();

				$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 rc.ordre ASC, cn.ordre ASC ".

			' -- '.__FILE__.' : '.__LINE__;

		$infos = $this->bdd->recupererTous($requete);

		$noeuds = array();

		foreach ($infos as $info) {

			$noeuds[$info['id_noeud']][$info['id_chemin']] = $info['ordre'];

			if (! isset($this->chemins[$info['id_chemin']]) ) {

				$this->chemins[$info['id_chemin']]['max'] == info['ordre'];

				if ($info['ordre'] == 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->noeuds[$info['id_noeud']][$dernierChemin] = $premierChemin;

			}

		}

		//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->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 = 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])) {

			$idCheminSuivant = next($this->infosNoeuds[$this->idNoeud]);

			//echo $this->idChemin.'-'.$idCheminSuivant."\n".print_r($this->infosNoeuds[$this->idNoeud]); exit();

		} 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 = current($this->infosRel[$this->idChemin]);

		}

		return $idNoeud;

	}

}