| 83,8 → 83,16 |
|---|
| // Nous avons une abréviation de valeur, nous récupérons toutes les valeurs correspondantes |
| $requete = (($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '. |
| 'FROM coel_meta_liste_valeur '. |
| "WHERE cmlv_abreviation LIKE {$p['abreviation']} ". |
| (isset($p['ceParent']) ? " AND cmlv_ce_parent = {$p['ceParent']} " : ''). |
| "WHERE "; |
| |
| // spécial outre-mer française |
| if($p['abreviation'] == "'FR%'" && $p['ceParent'] == "'1078'") { |
| $requete .= "cmlv_abreviation REGEXP '^(FR|RE|YT|GP|MQ|GF|NC)...$' "; |
| } else { |
| $requete .= "cmlv_abreviation LIKE {$p['abreviation']} "; |
| } |
| |
| $requete .= isset($p['ceParent']) ? " AND cmlv_ce_parent = {$p['ceParent']} " : ''. |
| " AND cmlv_id_valeur LIKE {$p['idValeur']}". |
| ' ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cmlv_id_valeur ASC').' '; |
| $requete_compte = $requete; |