/branches/v5.12-baouque/services/modules/0.1/nva/NomsVernaculaires.php |
---|
111,6 → 111,8 |
case 'retour.champs' : |
$this->champs_supp = explode(',',$valeur); |
break; |
case 'retour.tri' : |
break; |
case 'recherche' : |
break; |
case 'version.projet' : |
/branches/v5.12-baouque/scripts/modules/bdtfx/Bdtfx.php |
---|
36,6 → 36,7 |
$this->genererChpFamille(); |
$this->genererDonneesTestMultiVersion(); |
$this->genererChpHierarchie(); |
$this->genererBDTFXReduit(); |
break; |
case 'chargerStructureSql' : |
$this->chargerStructureSql(); |
55,6 → 56,9 |
case 'genererDonneesTestMultiVersion' : |
$this->genererDonneesTestMultiVersion(); |
break; |
case 'genererBDTFXR' : |
$this->genererBDTFXReduit(); |
break; |
case 'supprimerDonneesTestMultiVersion' : |
$this->supprimerDonneesTestMultiVersion(); |
break; |
208,12 → 212,12 |
} |
foreach ($introuvablesSyno as $id => $nom) { |
$nn = $nom['num_nom']; |
$nn = $nom['num_nom']; |
$nnr = $nom['num_nom_retenu']; |
if (isset($noms[$nnr])) { |
$noms[$nn] = $noms[$nnr]; |
} else { |
$introuvables[] = $nn; |
if (isset($noms[$nnr])) { |
$noms[$nn] = $noms[$nnr]; |
} else { |
$introuvables[] = $nn; |
} |
unset($introuvablesSyno[$id]); |
$this->afficherAvancement("Attribution de leur famille aux synonymes en cours"); |
326,6 → 330,24 |
$requete = "DROP TABLE IF EXISTS $tableTest"; |
$this->getBdd()->requeter($requete); |
} |
private function genererBDTFXReduit() { |
$table = Config::get('tables.bdtfx'); |
$version = Config::get('version'); |
$requete = "create table bdtfxr_v".$version." as (SELECT * |
FROM ".$table." |
WHERE |
(`presence` = 'P' AND num_nom = num_nom_retenu) |
OR |
(`flore_bonnier_num` != '' OR `flore_cnrs_num` != '' OR `flore_coste_num` != '' |
OR `flore_fournier_num` != '' OR `flore_fg_num` != ''))"; |
$table = $this->getBdd()->requeter($requete); |
$requete_meta = "INSERT INTO `bdtfxr_meta`(`guid`, `langue_meta`, `code`, `version`, `titre`, `description`, `mots_cles`, `citation`, `url_tech`, `url_projet`, `source`, `createurs`, `editeur`, `contributeurs`, `droits`, `url_droits`, `langue`, `date_creation`, `date_validite`, `couverture_spatiale`, `couverture_temporelle`, `web_services`) ". |
" SELECT * FROM `bdtfx_meta` WHERE `version` = '".str_replace('_', '.', $version)."'"; |
$meta = $this->getBdd()->requeter($requete_meta); |
} |
private function supprimerTous() { |
$requete = "DROP TABLE IF EXISTS bdtfx_meta, bdtfx_v1_01, bdtfx_v1_02"; |
/branches/v5.12-baouque/scripts/modules/bdtfx/bdtfx.ini |
---|
1,5 → 1,5 |
version="3_02" |
dossierTsv = "{ref:dossierDonneesEflore}bdtfx/3.02/" |
version="5_00" |
dossierTsv = "{ref:dossierDonneesEflore}bdtfx/5.00/" |
dossierSql = "{ref:dossierTsv}" |
[tables] |
/branches/v5.12-baouque/scripts/modules/chorodep/chorodep.ini |
---|
1,6 → 1,6 |
; Ajouter les nouvelles version à la suite dans versions et versionsDonnees. |
versions = "2015_08" |
versionsDonnees="2015-08-30" |
versions = "2018_04" |
versionsDonnees="2018-04-24" |
dossierTsv = "{ref:dossierDonneesEflore}chorodep/{ref:versionDonnees}/" |
dossierTsvTpl = "{ref:dossierDonneesEflore}chorodep/%s/" |
dossierSql = "{ref:dossierDonneesEflore}chorodep/" |
13,6 → 13,8 |
chorodepChamps2015_02 = "rang, catminat,indication_phytosocio_caracteristique, num_tax, num_nom, nom_sci, chorologie, `01`, `02`, `03`, `04`, `06`, `07`, `08`, `09`, `10`, `11`, `12`, `67`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `79`, `24`, `25`, `26`, `91`, `27`, `28`, `29`, `30`, `32`, `33`, `31`, `43`, `52`, `05`, `70`, `74`, `65`, `87`, `68`, `92`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `42`, `44`, `45`, `41`, `46`, `47`, `48`, `49`, `50`, `51`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `75`, `62`, `63`, `66`, `64`, `69`, `71`, `72`, `73`, `77`, `76`, `93`, `80`, `81`, `82`, `90`, `94`, `95`, `83`, `84`, `85`, `86`, `88`, `89`, `78`, freq_abs, freq_rel, rare_nat"; |
chorodepChamps2015_05 = "rang, catminat,indication_phytosocio_caracteristique, num_tax, num_nom, nom_sci, chorologie, `01`, `02`, `03`, `04`, `06`, `07`, `08`, `09`, `10`, `11`, `12`, `67`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `79`, `24`, `25`, `26`, `91`, `27`, `28`, `29`, `30`, `32`, `33`, `31`, `43`, `52`, `05`, `70`, `74`, `65`, `87`, `68`, `92`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `42`, `44`, `45`, `41`, `46`, `47`, `48`, `49`, `50`, `51`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `75`, `62`, `63`, `66`, `64`, `69`, `71`, `72`, `73`, `77`, `76`, `93`, `80`, `81`, `82`, `90`, `94`, `95`, `83`, `84`, `85`, `86`, `88`, `89`, `78`, freq_abs, freq_rel, rare_nat"; |
chorodepChamps2015_05 = "rang, catminat,indication_phytosocio_caracteristique, num_tax, num_nom, nom_sci, chorologie, `01`, `02`, `03`, `04`, `06`, `07`, `08`, `09`, `10`, `11`, `12`, `67`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `79`, `24`, `25`, `26`, `91`, `27`, `28`, `29`, `30`, `32`, `33`, `31`, `43`, `52`, `05`, `70`, `74`, `65`, `87`, `68`, `92`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `42`, `44`, `45`, `41`, `46`, `47`, `48`, `49`, `50`, `51`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `75`, `62`, `63`, `66`, `64`, `69`, `71`, `72`, `73`, `77`, `76`, `93`, `80`, `81`, `82`, `90`, `94`, `95`, `83`, `84`, `85`, `86`, `88`, `89`, `78`, freq_abs, freq_rel, rare_nat"; |
chorodepChamps2016_11 = "rang, num_tax, num_nom, nom_sci, `01`, `02`, `03`, `04`, `06`, `07`, `08`, `09`, `10`, `11`, `12`, `67`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `79`, `24`, `25`, `26`, `91`, `27`, `28`, `29`, `30`, `32`, `33`, `31`, `43`, `52`, `05`, `70`, `74`, `65`, `87`, `68`, `92`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `42`, `44`, `45`, `41`, `46`, `47`, `48`, `49`, `50`, `51`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `75`, `62`, `63`, `66`, `64`, `69`, `71`, `72`, `73`, `77`, `76`, `93`, `80`, `81`, `82`, `90`, `94`, `95`, `83`, `84`, `85`, `86`, `88`, `89`, `78`, freq_abs, freq_rel, rare_nat"; |
chorodepChamps2018_04 = "rang, num_tax, num_nom, nom_sci, `01`, `02`, `03`, `04`, `06`, `07`, `08`, `09`, `10`, `11`, `12`, `67`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `79`, `24`, `25`, `26`, `91`, `27`, `28`, `29`, `30`, `32`, `33`, `31`, `43`, `52`, `05`, `70`, `74`, `65`, `87`, `68`, `92`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `42`, `44`, `45`, `41`, `46`, `47`, `48`, `49`, `50`, `51`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `75`, `62`, `63`, `66`, `64`, `69`, `71`, `72`, `73`, `77`, `76`, `93`, `80`, `81`, `82`, `90`, `94`, `95`, `83`, `84`, `85`, `86`, `88`, `89`, `78`, freq_abs, freq_rel, rare_nat"; |
[tables] |
51,7 → 53,7 |
structureNVSP = "{ref:dossierSql}{ref:fichiers.structureNVSP}" |
[services] |
;base_url_service_eflore = "http://api.tela-botanica.org/service:eflore:0.1/"; |
;base_url_service_eflore = "https://api.tela-botanica.org/service:eflore:0.1/"; |
base_url_service_eflore = "http://localhost/service:eflore:0.1/"; |
url_nvjfl = "{ref:base_url_service_eflore}nvjfl/noms-vernaculaires?masque.lg=fra&retour.champs=num_taxon&retour.tri=num_taxon&navigation.depart=%s&navigation.limite=%s" |
url_sptb = "{ref:base_url_service_eflore}sptb/statuts?masque.nn=%s&retour.format=zone_geo" |
/branches/v5.12-baouque/scripts/modules/baseveg/BasevegVerif.php |
---|
23,7 → 23,7 |
public function initialiserParametresVerif() { |
$this->niveaux = array('CLA','ALL','ORD','ASS','GRPT','SUBORD','SUBASS','BC','SUBCLA','DC','SUBALL'); |
$this->synonymes = array('incl','=','?','illeg','pp','pmaxp','pminp','compl','ambig','non','inval','nn','ined'); |
$this->synonymes = array('incl','=','?','illeg','pp','pmaxp','pminp','compl','ambig','non','inval','nn','ined','fantom','correxit'); |
$this->motifs= $this->inverserTableau(array('/^[0-9]+$/' => 1, |
'/(?:[0-9]{2}\/$|[0-9]{2}\/[0-9]\.$|[0-9]{2}\/(?:[0-9]\.){1,5}[0-9]$|[0-9]{2}\/(?:[0-9]\.){4,5}[0-9]\/[0-9]+(?:bis|ter|quater){0,1}$)|incertae sedis/' => 2)); |
//présence de '=' , '= ?' et ',' dans les valeurs des paramètres. ne pas utiliser getParametresTableau. |
/branches/v5.12-baouque/scripts/modules/baseveg/Baseveg.php |
---|
23,8 → 23,8 |
case 'chargerMetadonnees' : |
$this->chargerMetadonnees(); |
break; |
case 'chargerDonnees' : |
$this->chargerDonnees(); |
case 'chargerBaseveg' : |
$this->chargerBaseveg(); |
break; |
case 'verifierFichier' : |
//cette étape met en avant les valeurs qui vont poser des problèmes (ontologies..) |
40,7 → 40,7 |
//$this->supprimerTous(); |
$this->chargerStructureSql(); |
$this->chargerMetadonnees(); |
$this->chargerDonnees(); |
$this->chargerBaseveg(); |
$this->chargerOntologies(); |
break; |
default : |
85,7 → 85,7 |
$this->getBdd()->requeter($requete); |
} |
protected function chargerDonnees() { |
protected function chargerBaseveg() { |
$table = Config::get('tables.donnees'); |
$requete = "LOAD DATA INFILE '".Config::get('chemins.donnees')."' ". |
"REPLACE INTO TABLE $table ". |
/branches/v5.12-baouque/scripts/modules/baseveg/baseveg.ini |
---|
1,5 → 1,5 |
version="2015_02_16" |
dossierTsv = "{ref:dossierDonneesEflore}baseveg/2015-02-16/" |
version="2018_04_24" |
dossierTsv = "{ref:dossierDonneesEflore}baseveg/2018-04-24/" |
dossierSql = "{ref:dossierTsv}" |
[tables] |