| 97,6 → 97,7 |
|---|
| const bdtfx = 'bdtfx_v2_00'; |
| const bdtxa = 'bdtxa_v1_01'; |
| const isfan = 'isfan_v2013'; |
| const bdtao = 'bdtao_v1_00'; |
| |
| // get from num_nom(_sel) |
| static function NN($db, $id, $ref) { |
| 130,6 → 131,12 |
|---|
| " FROM %s.%s o". |
| " LEFT JOIN %s.%s ret ON o.num_nom_retenu != 0 AND o.num_nom_retenu = ret.num_nom". |
| " WHERE o.num_nom = %d -- %s:%d", self::db, self::isfan, self::db, self::isfan, intval($id), __FILE__, __LINE__))->fetch(PDO::FETCH_ASSOC); |
| case "bdtao": |
| return $db->query(sprintf("SELECT o.num_nom_retenu AS nom_ret_nn, o.num_taxonomique AS nt, CONCAT(o.nom_sci, ' ', o.auteur) AS nom_sel". |
| " , o.famille, CONCAT(ret.nom_sci, ' ', ret.auteur) AS nom_ret". |
| " FROM %s.%s o". |
| " LEFT JOIN %s.%s ret ON o.num_nom_retenu != 0 AND o.num_nom_retenu = ret.num_nom". |
| " WHERE o.num_nom = %d -- %s:%d", self::db, self::bdtao, self::db, self::bdtao, intval($id), __FILE__, __LINE__))->fetch(PDO::FETCH_ASSOC); |
| } |
| return FALSE; |
| } |