1 2 3 4 5 6 7 8 9 10 11 12 13
| function getListeEACByPorteur($pkLot, $porteur) {
$sqlOld = $this->sqlLoadListe;
$criteres = $porteur->liste_criteres;
$this->sqlLoadListe = sprintf($this->sqlListeEACByPorteur, $pkLot, $criteres[0]['valeur'], $criteres[1]['valeur'], $criteres[2]['valeur'], $criteres[3]['valeur'], $criteres[4]['valeur'],
$criteres[5]['valeur'], $criteres[6]['valeur'], $criteres[7]['valeur'], $criteres[8]['valeur'], $criteres[9]['valeur'], $criteres[10]['valeur'], $criteres[11]['valeur'],
$criteres[12]['valeur'], $criteres[13]['valeur'], $criteres[14]['valeur'], $criteres[15]['valeur'], $criteres[16]['valeur']);
// On remplace tous les " = '' " par des IS NULL
$this->sqlLoadListe = str_replace(" = ''", " IS NULL", $this->sqlLoadListe);
$liste = parent::getListe($monBean);
$this->sqlLoadListe = $sqlOld;
var_dump($liste);
return $liste;
} |
Partager