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 $idRelation = null;

	private $idChemin = null;

	private $idNoeud = null;

	private $chemins = array();

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

			// Selection du premier chemin comme chemin actuel

			$this->idChemin = $this->getIdPremierChemin();

			$this->mettreAJourChemin('directe', __LINE__);

			// Selection du dernier noeud comme noeud actuel

			$idDernierNoeud = $this->getIdDernierNoeud();

			if ($idDernierNoeud) {

				$this->idNoeud = $idDernierNoeud;

				$this->ordonnerChemins();

			}

			// 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 '.

			' -- '.__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 '.

			'	LEFT JOIN osm_chemin_a_noeuds AS cn ON (rc.id_chemin = cn.id_chemin) '.

			"WHERE rc.id_relation = {$this->idRelation} ".

			"ODER BY cn.ordre ASC ".

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

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

		foreach ($infos as $info) {

			$this->infosRel[$this->idRelation][$info['id_chemin']]['noeuds'][$info['id_noeud']] = $info['ordre'];

		}

		$this->chemins = ($chemins) ? $chemins : array();

		$this->ordre = 0;

	}

	private function chargerCheminsRelationActuelle() {

		$requete = 'SELECT id_chemin '.

			'FROM osm_relation_a_chemins '.

			"WHERE id_relation = {$this->idRelation} ".

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

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

		$this->chemins = ($chemins) ? $chemins : array();

		$this->ordre = 0;

	}

	private function getIdPremierChemin() {

		return isset($this->chemins[0]) ? $this->chemins[0]['id_chemin'] : null;

	}

	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() {

		$requete = 'SELECT id_noeud '.

			'FROM osm_chemin_a_noeuds '.

			"WHERE id_chemin = {$this->idChemin} ".

			'ORDER BY ordre DESC '.

			'LIMIT 0,1 '.

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

		$noeud = $this->bdd->recuperer($requete);

		$idDernierNoeud = ($noeud) ? $noeud['id_noeud'] : false;

		return $idDernierNoeud;

	}

	private function ordonnerChemins() {

		foreach ($this->chemins 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;

				$this->comparerNoeuds();

			} else {

				$msg = "Impossible de trouver le chemin suivant pour la relation : %s";

				$this->messages->traiterAvertissement($msg, array($this->idRelation));

			}

		}

	}

	private function getIdCheminSuivant() {

		$requete = 'SELECT wn.id_chemin '.

			'FROM osm_relation_a_chemins AS rw '.

			'	LEFT JOIN osm_chemin_a_noeuds AS wn ON (rw.id_chemin = wn.id_chemin) '.

			"WHERE wn.id_noeud = {$this->idNoeud} ".

			"	AND wn.id_chemin != {$this->idChemin} ".

			"	AND rw.id_relation = {$this->idRelation} ".

			" LIMIT 0,1 ".

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

		$chemins = $this->bdd->recuperer($requete);

		$idCheminSuivant = ($chemins && isset($chemins['id_chemin'])) ? $chemins['id_chemin'] : false;

		return $idCheminSuivant;

	}

	private function comparerNoeuds() {

		$idPremierNoeud = $this->getIdPremierNoeud();

		$idDernierNoeud = $this->getIdDernierNoeud();

		if ( strcmp($idPremierNoeud, $this->idNoeud ) == 0 ) {

			$this->mettreAJourChemin('directe', __LINE__);

			$this->idNoeud = $idDernierNoeud;

		} else {

			$this->mettreAJourChemin('indirecte', __LINE__);

			$this->idNoeud = $idPremierNoeud;

		}

	}

	private function getIdPremierNoeud() {

		$requete = 'SELECT id_noeud '.

			'FROM osm_chemin_a_noeuds '.

			"WHERE id_chemin = {$this->idChemin} ".

			'ORDER BY ordre ASC '.

			'LIMIT 0,1 '.

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

		$noeud = $this->bdd->recuperer($requete);

		$idPremierNoeud = ($noeud) ? $noeud['id_noeud'] : false;

		return $idPremierNoeud;

	}

}