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