<?php
// +-------------------------------------------------+
// © 2002-2005 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: suggestions_origine.class.php,v 1.14 2015-04-03 11:16:19 jpermanne Exp $

if (stristr($_SERVER['REQUEST_URI'], ".class.php")) die("no access");

class suggestions_origine{
	
	
	var $origine = 0;						//Auteur de la suggestion (email ou identifiant utilisateur ou identifiant abonné) 
	var $num_suggestion = 0;				//Numéro de la suggestion
	var $type_origine = 0;					//Identifie le type de l'auteur (0 = utilisateur, 1 = abonné, 2 = visiteur, ..)
	var $date_suggestion = NULL;			//Date et heure de la suggestion	

	 
	//Constructeur.	 
	function suggestions_origine($origine= 0, $num_suggestion= 0,$type=0) {
		
		global $dbh;
	
		$this->origine = $origine;
		$this->num_suggestion = $num_suggestion;
		$this->type_origine = $type;
		$q = "select count(1) from suggestions_origine where origine = '".$this->origine."' and num_suggestion = '".$this->num_suggestion."' and type_origine='".$this->type_origine."'";
		$r = pmb_mysql_query($q, $dbh);
		if (pmb_mysql_result($r, 0, 0) != 0) {
			$this->load();
		}

	}	


	static function exists($origine= 0, $num_suggestion= 0,$type=0) {
		global $dbh;
		$q = "select count(1) from suggestions_origine where origine = '".$origine."' and num_suggestion = '".$num_suggestion."' and type_origine='".$type."'";
		$r = pmb_mysql_query($q, $dbh);
		return pmb_mysql_result($r, 0, 0) != 0;
	}
	
	// charge un auteur et une de ses suggestions à partir de la base.
	function load(){
	
		global $dbh;
		
		$q = "select * from suggestions_origine where origine = '".$this->origine."' and num_suggestion = '".$this->num_suggestion."' and type_origine='".$this->type_origine."'";
		$r = pmb_mysql_query($q, $dbh);
		$obj = pmb_mysql_fetch_object($r);
		$this->type_origine = $obj->type_origine;
		$this->date_suggestion = $obj->date_suggestion;

	}

	
	// enregistre un auteur et une de ses suggestions en base.
	function save(){
		
		global $dbh;
		
		if (!$this->origine && !$this->num_suggestion) die("Erreur de création suggestions_origine");
		
		$q = "select count(1) from suggestions_origine where origine = '".$this->origine."' and num_suggestion = '".$this->num_suggestion."' and type_origine='".$this->type_origine."'";	
		$r = pmb_mysql_query($q, $dbh);
		if (pmb_mysql_result($r, 0, 0) != 0) {
		
			$q = "update suggestions_origine set type_origine = '".$this->type_origine."' ";
			$q.= "where origine = '".$this->origine."' and num_suggestion = '".$this->num_suggestion."' ";
			$r = pmb_mysql_query($q, $dbh);
			
		} else {
				
			$q = "insert into suggestions_origine set origine = '".$this->origine."', num_suggestion = '".$this->num_suggestion."', ";
			$q.= "type_origine =  '".$this->type_origine."', date_suggestion = now() ";
			$r = pmb_mysql_query($q, $dbh);
			
		}
	}


	//supprime la suggestion d'un auteur de la base
	function delete($num_suggestion, $origine=0,$type=0 ) {
		
		global $dbh;

		$q = "delete from suggestions_origine where num_suggestion = '".$num_suggestion."' ";
		if($origine) $q.= "and origine = '".$origine."' ";
		 if($type) $q.= "and type_origine = '".$type."' ";
		$r = pmb_mysql_query($q, $dbh);
				
	}

	
	//optimization de la table suggestions_origine
	function optimize() {
		
		global $dbh;
		
		$opt = pmb_mysql_query('OPTIMIZE TABLE suggestions_origine', $dbh);
		return $opt;
				
	}
	
	//recherche les occurences d'une suggestion triées par date
	static function listOccurences($num_suggestion, $limit=0){
		
		global $dbh;
		
		$q = "Select origine, type_origine, date_suggestion from suggestions_origine where num_suggestion = '".$num_suggestion."' order by date_suggestion asc ";
		if ($limit) $q.= "limit ".$limit;
		return $q;
	}

	//fusion des suggestions
	function fusionne($origine, $from_sug, $to_sug){
		
		global $dbh;
		
		//On commence par supprimer les suggestions pour lesquelles l'origine est identique à celle de destination
		$q = "Delete from suggestions_origine where origine = '".$origine."' and num_suggestion = '".$from_sug."' ";
		$r = pmb_mysql_query($q, $dbh);
		
		//On met à jour les suggestions à fusionner
		$q = "Update suggestions_origine set num_suggestion = '".$to_sug."' where num_suggestion = '".$from_sug."' ";
		$r = pmb_mysql_query($q, $dbh);
	}


}
?>