Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 700 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 700 Rev 1039
Line 220... Line 220...
220 
	}
 220 
	}
Line 221... Line 221...
221
221
222 
	public function recupererIdInf() {
 222 
	public function recupererIdInf() {
223 
		//SELECT num_nom FROM bfdtx_v2_00 WHERE num_tax_sup = (SELECT num_nom FROM bdtfx_v2_00 WHERE num_nom = X);
 223 
		//SELECT num_nom FROM bfdtx_v2_00 WHERE num_tax_sup = (SELECT num_nom FROM bdtfx_v2_00 WHERE num_nom = X);
224 
		$req_relation = 'SELECT num_nom FROM '.$this->table
 224 
		$req_relation = 'SELECT num_nom FROM '.$this->table
225 
							.' WHERE num_tax_sup = (SELECT num_nom FROM '
 225 
							.' WHERE num_nom = num_nom_retenu AND num_tax_sup = (SELECT num_nom FROM '
226 
							.$this->table
 226 
							.$this->table
227 
							.' WHERE '.implode(' AND ', $this->requete_condition).')';
 227 
							.' WHERE '.implode(' AND ', $this->requete_condition).')';
228 
		$res_relation = $this->getBdd()->recupererTous($req_relation);
 228 
		$res_relation = $this->getBdd()->recupererTous($req_relation);
229 
		return $res_relation;
 229 
		return $res_relation;
Line 230... Line 230...
230 
	}
 230 
	}
231
231
- 
 
 232
232
233 
	public function recupererIdSup() {
233 
	public function recupererIdSup() {
 234 
		//SELECT num_nom FROM bfdtx_v2_00 WHERE num_nom = (SELECT num_tax_sup FROM bdtfx_v2_00 WHERE num_nom = X);
234 
		//SELECT num_nom FROM bfdtx_v2_00 WHERE num_nom = (SELECT num_tax_sup FROM bdtfx_v2_00 WHERE num_nom = X);
 235 
		$this->requete_condition[] = "num_nom = num_nom_retenu" ;
235 
		$req_relation = 'SELECT num_tax_sup as num_nom FROM '.$this->table
 236 
		$req_relation = 'SELECT num_tax_sup as num_nom FROM '.$this->table
236 
							.' WHERE '.implode(' AND ', $this->requete_condition);
 237 
							.' WHERE '.implode(' AND ', $this->requete_condition);