def index(): session = utils.loadSession() connection = utils.engine.connect() if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsMailles( connection, config.NB_DAY_LAST_OBS, config.ATTR_MAIN_PHOTO) else: observations = vmObservationsRepository.lastObservations( connection, config.NB_DAY_LAST_OBS, config.ATTR_MAIN_PHOTO) communesSearch = vmCommunesRepository.getAllCommunes(session) mostViewTaxon = vmTaxonsMostView.mostViewTaxon(connection) stat = vmObservationsRepository.statIndex(connection) customStat = vmObservationsRepository.genericStat(connection, config.RANG_STAT) customStatMedias = vmObservationsRepository.genericStatMedias( connection, config.RANG_STAT) configuration = {'STRUCTURE' : config.STRUCTURE, 'NOM_APPLICATION' : config.NOM_APPLICATION, 'HOMEMAP': True, 'TEXT_LAST_OBS': config.TEXT_LAST_OBS, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, \ 'URL_PHOTO': config.URL_MEDIAS, 'AFFICHAGE_DERNIERES_OBS': config.AFFICHAGE_DERNIERES_OBS, 'AFFICHAGE_EN_CE_MOMENT': config.AFFICHAGE_EN_CE_MOMENT, 'AFFICHAGE_STAT_GLOBALES': config.AFFICHAGE_STAT_GLOBALES, 'AFFICHAGE_RANG_STAT': config.AFFICHAGE_RANG_STAT, 'COLONNES_RANG_STAT': config.COLONNES_RANG_STAT, 'RANG_STAT_FR': config.RANG_STAT_FR, \ 'MAP': config.MAP, 'URL_APPLICATION': config.URL_APPLICATION, 'AFFICHAGE_INTRODUCTION': config.AFFICHAGE_INTRODUCTION, \ 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS} connection.close() session.close() return render_template('templates/index.html', observations=observations, communesSearch=communesSearch, \ mostViewTaxon=mostViewTaxon, stat=stat, customStat = customStat, customStatMedias=customStatMedias, configuration = configuration)
def ficheRangTaxonomie(cd_ref): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsChildsList(connection, cd_ref) referenciel = vmTaxrefRepository.getInfoFromCd_ref(session, cd_ref) communesSearch = vmCommunesRepository.getAllCommunes(session) taxonomyHierarchy = vmTaxrefRepository.getAllTaxonomy(session, cd_ref) observers = vmObservationsRepository.getObservers(connection, cd_ref) connection.close() session.close() configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'MYTYPE': 0, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, }) return render_template( 'templates/ficheRangTaxonomique.html', listTaxons=listTaxons, referenciel=referenciel, communesSearch=communesSearch, taxonomyHierarchy=taxonomyHierarchy, observers=observers, configuration=configuration )
def ficheGroupe(groupe): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getAllINPNgroup(connection) listTaxons = vmTaxonsRepository.getTaxonsGroup(connection, groupe) communesSearch = vmCommunesRepository.getAllCommunes(session) observers = vmObservationsRepository.getGroupeObservers(connection, groupe) session.close() connection.close() configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'MYTYPE': 0, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) return render_template('templates/ficheGroupe.html', listTaxons=listTaxons, communesSearch=communesSearch, referenciel=groupe, groups=groups, observers=observers, configuration=configuration)
def ficheGroupe(groupe): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getAllINPNgroup(connection) listTaxons = vmTaxonsRepository.getTaxonsGroup(connection, groupe) communesSearch = vmCommunesRepository.getAllCommunes(session) observers = vmObservationsRepository.getGroupeObservers(connection, groupe) session.close() connection.close() configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'MYTYPE': 0, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) return render_template( 'templates/ficheGroupe.html', listTaxons=listTaxons, communesSearch=communesSearch, referenciel=groupe, groups=groups, observers=observers, configuration=configuration )
def ficheRangTaxonomie(cd_ref): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsChildsList(connection, cd_ref) referenciel = vmTaxrefRepository.getInfoFromCd_ref(session, cd_ref) communesSearch = vmCommunesRepository.getAllCommunes(session) taxonomyHierarchy = vmTaxrefRepository.getAllTaxonomy(session, cd_ref) observers = vmObservationsRepository.getObservers(connection, cd_ref) connection.close() session.close() configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'MYTYPE': 0, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, }) return render_template('templates/ficheRangTaxonomique.html', listTaxons=listTaxons, referenciel=referenciel, communesSearch=communesSearch, taxonomyHierarchy=taxonomyHierarchy, observers=observers, configuration=configuration)
def index(): session = utils.loadSession() connection = utils.engine.connect() if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsMailles( connection, config.NB_DAY_LAST_OBS, config.ATTR_MAIN_PHOTO) else: observations = vmObservationsRepository.lastObservations( connection, config.NB_DAY_LAST_OBS, config.ATTR_MAIN_PHOTO) communesSearch = vmCommunesRepository.getAllCommunes(session) mostViewTaxon = vmTaxonsMostView.mostViewTaxon(connection) stat = vmObservationsRepository.statIndex(connection) customStat = vmObservationsRepository.genericStat(connection, config.RANG_STAT) customStatMedias = vmObservationsRepository.genericStatMedias( connection, config.RANG_STAT) configuration = base_configuration.copy() configuration.update({ 'HOMEMAP': True, 'TEXT_LAST_OBS': config.TEXT_LAST_OBS, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'AFFICHAGE_DERNIERES_OBS': config.AFFICHAGE_DERNIERES_OBS, 'AFFICHAGE_EN_CE_MOMENT': config.AFFICHAGE_EN_CE_MOMENT, 'AFFICHAGE_STAT_GLOBALES': config.AFFICHAGE_STAT_GLOBALES, 'AFFICHAGE_RANG_STAT': config.AFFICHAGE_RANG_STAT, 'COLONNES_RANG_STAT': config.COLONNES_RANG_STAT, 'RANG_STAT_FR': config.RANG_STAT_FR, 'MAP': config.MAP, 'AFFICHAGE_INTRODUCTION': config.AFFICHAGE_INTRODUCTION }) connection.close() session.close() return render_template('templates/index.html', observations=observations, communesSearch=communesSearch, mostViewTaxon=mostViewTaxon, stat=stat, customStat=customStat, customStatMedias=customStatMedias, configuration=configuration)
def get_staticpages(page): session = utils.loadSession() if (page not in config.STATIC_PAGES): abort(404) static_page = config.STATIC_PAGES[page] communesSearch = vmCommunesRepository.getAllCommunes(session) configuration = base_configuration session.close() return render_template(static_page['template'], communesSearch=communesSearch, configuration=configuration)
def get_staticpages(page): session = utils.loadSession() if (page not in config.STATIC_PAGES): abort(404) static_page = config.STATIC_PAGES[page] communesSearch = vmCommunesRepository.getAllCommunes(session) configuration = base_configuration session.close() return render_template( static_page['template'], communesSearch=communesSearch, configuration=configuration )
def index(): session = utils.loadSession() connection = utils.engine.connect() if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsMailles( connection, config.NB_DAY_LAST_OBS, config.ATTR_MAIN_PHOTO ) else: observations = vmObservationsRepository.lastObservations( connection, config.NB_DAY_LAST_OBS, config.ATTR_MAIN_PHOTO ) communesSearch = vmCommunesRepository.getAllCommunes(session) mostViewTaxon = vmTaxonsMostView.mostViewTaxon(connection) stat = vmObservationsRepository.statIndex(connection) customStat = vmObservationsRepository.genericStat( connection, config.RANG_STAT ) customStatMedias = vmObservationsRepository.genericStatMedias( connection, config.RANG_STAT ) configuration = base_configuration.copy() configuration.update({ 'HOMEMAP': True, 'TEXT_LAST_OBS': config.TEXT_LAST_OBS, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'AFFICHAGE_DERNIERES_OBS': config.AFFICHAGE_DERNIERES_OBS, 'AFFICHAGE_EN_CE_MOMENT': config.AFFICHAGE_EN_CE_MOMENT, 'AFFICHAGE_STAT_GLOBALES': config.AFFICHAGE_STAT_GLOBALES, 'AFFICHAGE_RANG_STAT': config.AFFICHAGE_RANG_STAT, 'COLONNES_RANG_STAT': config.COLONNES_RANG_STAT, 'RANG_STAT_FR': config.RANG_STAT_FR, 'MAP': config.MAP, 'AFFICHAGE_INTRODUCTION': config.AFFICHAGE_INTRODUCTION }) connection.close() session.close() return render_template( 'templates/index.html', observations=observations, communesSearch=communesSearch, mostViewTaxon=mostViewTaxon, stat=stat, customStat=customStat, customStatMedias=customStatMedias, configuration=configuration )
def photos(): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getINPNgroupPhotos(connection) communesSearch = vmCommunesRepository.getAllCommunes(session) configuration = base_configuration session.close() connection.close() return render_template('templates/galeriePhotos.html', communesSearch=communesSearch, groups=groups, configuration=configuration)
def photos(): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getINPNgroupPhotos(connection) communesSearch = vmCommunesRepository.getAllCommunes(session) configuration = base_configuration session.close() connection.close() return render_template( 'templates/galeriePhotos.html', communesSearch=communesSearch, groups=groups, configuration=configuration )
def presentation(): session = utils.loadSession() communesSearch = vmCommunesRepository.getAllCommunes(session) configuration = { 'STRUCTURE': config.STRUCTURE, 'NOM_APPLICATION': config.NOM_APPLICATION, 'URL_APPLICATION': config.URL_APPLICATION, 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS } session.close() return render_template('static/custom/templates/presentation.html', communesSearch=communesSearch, configuration=configuration)
def ficheRangTaxonomie(cd_ref): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsChildsList(connection, cd_ref) referenciel = vmTaxrefRepository.getInfoFromCd_ref(session, cd_ref) communesSearch = vmCommunesRepository.getAllCommunes(session) taxonomyHierarchy = vmTaxrefRepository.getAllTaxonomy(session, cd_ref) observers = vmObservationsRepository.getObservers(connection, cd_ref) connection.close() session.close() configuration = {'STRUCTURE' : config.STRUCTURE, 'NOM_APPLICATION' : config.NOM_APPLICATION, 'LIMIT_FICHE_LISTE_HIERARCHY' : config.LIMIT_FICHE_LISTE_HIERARCHY,\ 'URL_APPLICATION': config.URL_APPLICATION, 'MYTYPE' : 0, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS} return render_template('templates/ficheRangTaxonomique.html', listTaxons = listTaxons, referenciel = referenciel, communesSearch = communesSearch,\ taxonomyHierarchy=taxonomyHierarchy, observers=observers, configuration=configuration)
def ficheCommune(insee): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsCommunes(connection, insee) commune = vmCommunesRepository.getCommuneFromInsee(connection, insee) communesSearch = vmCommunesRepository.getAllCommunes(session) if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsCommuneMaille( connection, config.NB_LAST_OBS, insee ) else: observations = vmObservationsRepository.lastObservationsCommune( connection, config.NB_LAST_OBS, insee ) observers = vmObservationsRepository.getObserversCommunes( connection, insee ) configuration = base_configuration.copy() configuration.update({ 'NB_LAST_OBS': config.NB_LAST_OBS, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'MAP': config.MAP, 'MYTYPE': 1, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) session.close() connection.close() return render_template( 'templates/ficheCommune.html', listTaxons=listTaxons, referenciel=commune, communesSearch=communesSearch, observations=observations, observers=observers, configuration=configuration )
def photos(): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getINPNgroupPhotos(connection) communesSearch = vmCommunesRepository.getAllCommunes(session) configuration = { 'STRUCTURE': config.STRUCTURE, 'NOM_APPLICATION': config.NOM_APPLICATION, 'URL_APPLICATION': config.URL_APPLICATION, 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS } session.close() connection.close() return render_template('templates/galeriePhotos.html', communesSearch=communesSearch, groups=groups, configuration=configuration)
def ficheGroupe(groupe): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getAllINPNgroup(connection) listTaxons = vmTaxonsRepository.getTaxonsGroup(connection, groupe) communesSearch = vmCommunesRepository.getAllCommunes(session) observers = vmObservationsRepository.getGroupeObservers(connection, groupe) session.close() connection.close() configuration = {'STRUCTURE' : config.STRUCTURE, 'NOM_APPLICATION' : config.NOM_APPLICATION, 'LIMIT_FICHE_LISTE_HIERARCHY' : config.LIMIT_FICHE_LISTE_HIERARCHY,\ 'URL_APPLICATION': config.URL_APPLICATION, 'MYTYPE' : 0, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS} return render_template('templates/ficheGroupe.html', listTaxons=listTaxons, communesSearch=communesSearch, referenciel=groupe, groups=groups, observers=observers, configuration=configuration)
def ficheEspece(cd_ref): session = utils.loadSession() connection = utils.engine.connect() cd_ref = int(cd_ref) taxon = vmTaxrefRepository.searchEspece(connection, cd_ref) altitudes = vmAltitudesRepository.getAltitudesChilds(connection, cd_ref) months = vmMoisRepository.getMonthlyObservationsChilds(connection, cd_ref) synonyme = vmTaxrefRepository.getSynonymy(connection, cd_ref) communes = vmCommunesRepository.getCommunesObservationsChilds( connection, cd_ref) communesSearch = vmCommunesRepository.getAllCommunes(session) taxonomyHierarchy = vmTaxrefRepository.getAllTaxonomy(session, cd_ref) firstPhoto = vmMedias.getFirstPhoto(connection, cd_ref, config.ATTR_MAIN_PHOTO) photoCarousel = vmMedias.getPhotoCarousel(connection, cd_ref, config.ATTR_OTHER_PHOTO) videoAudio = vmMedias.getVideo_and_audio( connection, cd_ref, config.ATTR_AUDIO, config.ATTR_VIDEO_HEBERGEE, config.ATTR_YOUTUBE, config.ATTR_DAILYMOTION, config.ATTR_VIMEO) articles = vmMedias.getLinks_and_articles(connection, cd_ref, config.ATTR_LIEN, config.ATTR_PDF) taxonDescription = vmCorTaxonAttribut.getAttributesTaxon( connection, cd_ref, config.ATTR_DESC, config.ATTR_COMMENTAIRE, config.ATTR_MILIEU, config.ATTR_CHOROLOGIE) observers = vmObservationsRepository.getObservers(connection, cd_ref) configuration = {'STRUCTURE' : config.STRUCTURE, 'NOM_APPLICATION' : config.NOM_APPLICATION, 'LIMIT_FICHE_LISTE_HIERARCHY' : config.LIMIT_FICHE_LISTE_HIERARCHY, 'PATRIMONIALITE':config.PATRIMONIALITE, \ 'PROTECTION': config.PROTECTION, 'GLOSSAIRE': config.GLOSSAIRE, 'AFFICHAGE_MAILLE' : config.AFFICHAGE_MAILLE, 'ZOOM_LEVEL_POINT': config.ZOOM_LEVEL_POINT, 'LIMIT_CLUSTER_POINT': config.LIMIT_CLUSTER_POINT, 'FICHE_ESPECE': True, \ 'URL_PHOTO': config.URL_MEDIAS, 'MAP': config.MAP, 'URL_APPLICATION': config.URL_APPLICATION, 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS} connection.close() session.close() return render_template('templates/ficheEspece.html', taxon=taxon, listeTaxonsSearch=[], observations=[],\ cd_ref=cd_ref, altitudes=altitudes, months=months, synonyme=synonyme, communes=communes, communesSearch=communesSearch, taxonomyHierarchy = taxonomyHierarchy,\ firstPhoto= firstPhoto, photoCarousel=photoCarousel, videoAudio=videoAudio, articles=articles, taxonDescription=taxonDescription, observers=observers, \ configuration=configuration)
def ficheGroupe(groupe): session = utils.loadSession() connection = utils.engine.connect() groups = vmTaxonsRepository.getAllINPNgroup(connection) listTaxons = vmTaxonsRepository.getTaxonsGroup(connection, groupe) communesSearch = vmCommunesRepository.getAllCommunes(session) epciSearch = vmEpciRepository.getAllEpci(session) departementSearch = vmDepartementRepository.getAllDepartement(session) orgas = vmObservationsRepository.getGroupeOrgas(connection, groupe) observers = vmObservationsRepository.getGroupeObservers(connection, groupe) session.close() connection.close() configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'AFFICHAGE_ORGAS_OBS_FICHEGROUPE': config.AFFICHAGE_ORGAS_OBS_FICHEGROUPE, 'MYTYPE': 0, 'AFFICHE_PATRIMONIALITE' : config.AFFICHE_PATRIMONIALITE, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) return render_template( 'templates/ficheGroupe.html', listTaxons=listTaxons, communesSearch=communesSearch, epciSearch=epciSearch, departementSearch=departementSearch, referenciel=groupe, groups=groups, orgas=orgas, observers=observers, configuration=configuration )
def ficheCommune(insee): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsCommunes(connection, insee) commune = vmCommunesRepository.getCommuneFromInsee(connection, insee) communesSearch = vmCommunesRepository.getAllCommunes(session) if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsCommuneMaille( connection, config.NB_LAST_OBS, insee) else: observations = vmObservationsRepository.lastObservationsCommune( connection, config.NB_LAST_OBS, insee) observers = vmObservationsRepository.getObserversCommunes( connection, insee) configuration = base_configuration.copy() configuration.update({ 'NB_LAST_OBS': config.NB_LAST_OBS, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'MAP': config.MAP, 'MYTYPE': 1, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) session.close() connection.close() return render_template('templates/ficheCommune.html', listTaxons=listTaxons, referenciel=commune, communesSearch=communesSearch, observations=observations, observers=observers, configuration=configuration)
def ficheCommune(insee): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsCommunes(connection, insee) commune = vmCommunesRepository.getCommuneFromInsee(connection, insee) communesSearch = vmCommunesRepository.getAllCommunes(session) if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsCommuneMaille( connection, config.NB_LAST_OBS, insee) else: observations = vmObservationsRepository.lastObservationsCommune( connection, config.NB_LAST_OBS, insee) observers = vmObservationsRepository.getObserversCommunes( connection, insee) configuration = {'STRUCTURE' : config.STRUCTURE, 'NOM_APPLICATION' : config.NOM_APPLICATION, 'NB_LAST_OBS': config.NB_LAST_OBS, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'MAP': config.MAP, \ 'URL_APPLICATION': config.URL_APPLICATION, 'MYTYPE' : 1, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, 'AFFICHAGE_FOOTER': config.AFFICHAGE_FOOTER, 'ID_GOOGLE_ANALYTICS': config.ID_GOOGLE_ANALYTICS} session.close() connection.close() return render_template('templates/ficheCommune.html', listTaxons = listTaxons, referenciel = commune, communesSearch = communesSearch, observations = observations, \ observers=observers, configuration = configuration)
def ficheEspece(cd_ref): session = utils.loadSession() connection = utils.engine.connect() cd_ref = int(cd_ref) taxon = vmTaxrefRepository.searchEspece(connection, cd_ref) statsorgataxon = vmStatsOrgaTaxonRepository.getStatsOrgaTaxonChilds(connection, cd_ref) months = vmMoisRepository.getMonthlyObservationsChilds(connection, cd_ref) synonyme = vmTaxrefRepository.getSynonymy(connection, cd_ref) communes = vmCommunesRepository.getCommunesObservationsChilds( connection, cd_ref ) communesSearch = vmCommunesRepository.getAllCommunes(session) epciSearch = vmEpciRepository.getAllEpci(session) departementSearch = vmDepartementRepository.getAllDepartement(session) taxonomyHierarchy = vmTaxrefRepository.getAllTaxonomy(session, cd_ref) firstPhoto = vmMedias.getFirstPhoto( connection, cd_ref, config.ATTR_MAIN_PHOTO ) photoCarousel = vmMedias.getPhotoCarousel( connection, cd_ref, config.ATTR_OTHER_PHOTO ) videoAudio = vmMedias.getVideo_and_audio( connection, cd_ref, config.ATTR_AUDIO, config.ATTR_VIDEO_HEBERGEE, config.ATTR_YOUTUBE, config.ATTR_DAILYMOTION, config.ATTR_VIMEO ) articles = vmMedias.getLinks_and_articles( connection, cd_ref, config.ATTR_LIEN, config.ATTR_PDF ) taxonDescription = vmCorTaxonAttribut.getAttributesTaxon( connection, cd_ref, config.ATTR_DESC, config.ATTR_COMMENTAIRE, config.ATTR_MILIEU, config.ATTR_CHOROLOGIE ) orgas = vmObservationsRepository.getOrgasObservations(connection, cd_ref) observers = vmObservationsRepository.getObservers(connection, cd_ref) observationsMaille = vmObservationsMaillesRepository.getObservationsMaillesChilds(connection, cd_ref) configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'AFFICHAGE_ORGAS_OBS_FICHEESP': config.AFFICHAGE_ORGAS_OBS_FICHEESP, 'AFFICHE_PATRIMONIALITE' : config.AFFICHE_PATRIMONIALITE, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, 'GLOSSAIRE': config.GLOSSAIRE, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'AFFICHAGE_SWITCHER': config.AFFICHAGE_SWITCHER, 'AFFICHAGE_ATLAS_MAILLE_COMMUNALE': config.AFFICHAGE_ATLAS_MAILLE_COMMUNALE, 'AFFICHAGE_ATLAS_MAILLE_CARREE': config.AFFICHAGE_ATLAS_MAILLE_CARREE, 'AFFICHAGE_ATLAS_POINT': config.AFFICHAGE_ATLAS_POINT, 'ZOOM_LEVEL_POINT': config.ZOOM_LEVEL_POINT, 'LIMIT_CLUSTER_POINT': config.LIMIT_CLUSTER_POINT, 'FICHE_ESPECE': True, 'MAP': config.MAP }) connection.close() session.close() return render_template( 'templates/ficheEspece.html', taxon=taxon, listeTaxonsSearch=[], observations=[], cd_ref=cd_ref, statsorgataxon=statsorgataxon, months=months, synonyme=synonyme, communes=communes, communesSearch=communesSearch, epciSearch=epciSearch, departementSearch=departementSearch, observationsMaille=observationsMaille, taxonomyHierarchy=taxonomyHierarchy, firstPhoto=firstPhoto, photoCarousel=photoCarousel, videoAudio=videoAudio, articles=articles, taxonDescription=taxonDescription, orgas=orgas, observers=observers, configuration=configuration )
def ficheEpci(nom_epci_simple): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsEpci(connection, nom_epci_simple) listespeces = vmTaxonsRepository.getListeTaxonsEpci(connection, nom_epci_simple) taxonProPatri = vmStatsStatutTaxonEpciRepository.getNbTaxonsProPatriEpci(connection, nom_epci_simple) statsStatutTaxonEpci = vmStatsStatutTaxonEpciRepository.getStatsStatutsTaxonsEpci(connection, nom_epci_simple) infosEpci = vmEpciRepository.infosEpci(connection, nom_epci_simple) communesEpci = vmEpciRepository.communesEpciChilds(connection, nom_epci_simple) epci = vmEpciRepository.getEpciFromNomsimple(connection, nom_epci_simple) epciDpt = vmEpciRepository.getDptFromEpci(connection, nom_epci_simple) statsorgataxonepci = vmStatsOrgaEpciRepository.getStatsOrgaTaxonEpciChilds(connection, nom_epci_simple) statsorgadataepci = vmStatsOrgaEpciRepository.getStatsOrgaDataEpciChilds(connection, nom_epci_simple) statsgroup2inpnepci = vmStatsGroup2inpnEpciRepository.getStatsGroup2inpnEpciChilds(connection, nom_epci_simple) statstaxongroup2inpnepci = vmStatsTaxonGroup2inpnEpciRepository.getStatsTaxonGroup2inpnEpciChilds(connection, nom_epci_simple) communesSearch = vmCommunesRepository.getAllCommunes(session) epciSearch = vmEpciRepository.getAllEpci(session) departementSearch = vmDepartementRepository.getAllDepartement(session) if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsEpciMaille( connection, config.NB_LAST_OBS, nom_epci_simple ) else: observations = vmObservationsRepository.lastObservationsEpci( connection, config.NB_LAST_OBS, nom_epci_simple ) orgas = vmObservationsRepository.getOrgasEpci(connection, nom_epci_simple) observers = vmObservationsRepository.getObserversEpci(connection, nom_epci_simple) configuration = base_configuration.copy() configuration.update({ 'NB_LAST_OBS': config.NB_LAST_OBS, 'AFFICHAGE_ORGAS_OBS_FICHECOMM': config.AFFICHAGE_ORGAS_OBS_FICHECOMM, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'MAP': config.MAP, 'MYTYPE': 0, 'PRESSION_PROSPECTION': config.PRESSION_PROSPECTION, 'AFFICHE_PATRIMONIALITE' : config.AFFICHE_PATRIMONIALITE, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) session.close() connection.close() return render_template( 'templates/ficheEpci.html', nom_epci_simple=nom_epci_simple, listTaxons=listTaxons, listespeces=listespeces, taxonProPatri=taxonProPatri, statsStatutTaxonEpci=statsStatutTaxonEpci, infosEpci=infosEpci, communesEpci=communesEpci, referenciel=epci, epciDpt=epciDpt, statsorgataxonepci=statsorgataxonepci, statsorgadataepci=statsorgadataepci, statsgroup2inpnepci=statsgroup2inpnepci, statstaxongroup2inpnepci=statstaxongroup2inpnepci, communesSearch=communesSearch, epciSearch=epciSearch, departementSearch=departementSearch, observations=observations, orgas=orgas, observers=observers, configuration=configuration )
def ficheEspece(cd_ref): session = utils.loadSession() connection = utils.engine.connect() cd_ref = int(cd_ref) taxon = vmTaxrefRepository.searchEspece(connection, cd_ref) altitudes = vmAltitudesRepository.getAltitudesChilds(connection, cd_ref) months = vmMoisRepository.getMonthlyObservationsChilds(connection, cd_ref) synonyme = vmTaxrefRepository.getSynonymy(connection, cd_ref) communes = vmCommunesRepository.getCommunesObservationsChilds( connection, cd_ref ) communesSearch = vmCommunesRepository.getAllCommunes(session) taxonomyHierarchy = vmTaxrefRepository.getAllTaxonomy(session, cd_ref) firstPhoto = vmMedias.getFirstPhoto( connection, cd_ref, config.ATTR_MAIN_PHOTO ) photoCarousel = vmMedias.getPhotoCarousel( connection, cd_ref, config.ATTR_OTHER_PHOTO ) videoAudio = vmMedias.getVideo_and_audio( connection, cd_ref, config.ATTR_AUDIO, config.ATTR_VIDEO_HEBERGEE, config.ATTR_YOUTUBE, config.ATTR_DAILYMOTION, config.ATTR_VIMEO ) articles = vmMedias.getLinks_and_articles( connection, cd_ref, config.ATTR_LIEN, config.ATTR_PDF ) taxonDescription = vmCorTaxonAttribut.getAttributesTaxon( connection, cd_ref, config.ATTR_DESC, config.ATTR_COMMENTAIRE, config.ATTR_MILIEU, config.ATTR_CHOROLOGIE ) observers = vmObservationsRepository.getObservers(connection, cd_ref) configuration = base_configuration.copy() configuration.update({ 'LIMIT_FICHE_LISTE_HIERARCHY': config.LIMIT_FICHE_LISTE_HIERARCHY, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION, 'GLOSSAIRE': config.GLOSSAIRE, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'ZOOM_LEVEL_POINT': config.ZOOM_LEVEL_POINT, 'LIMIT_CLUSTER_POINT': config.LIMIT_CLUSTER_POINT, 'FICHE_ESPECE': True, 'MAP': config.MAP }) connection.close() session.close() return render_template( 'templates/ficheEspece.html', taxon=taxon, listeTaxonsSearch=[], observations=[], cd_ref=cd_ref, altitudes=altitudes, months=months, synonyme=synonyme, communes=communes, communesSearch=communesSearch, taxonomyHierarchy=taxonomyHierarchy, firstPhoto=firstPhoto, photoCarousel=photoCarousel, videoAudio=videoAudio, articles=articles, taxonDescription=taxonDescription, observers=observers, configuration=configuration )
def ficheDepartement(num_dpt): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsDpt(connection, num_dpt) listespeces = vmTaxonsRepository.getListeTaxonsDpt(connection, num_dpt) taxonProPatri = vmStatsStatutTaxonDptRepository.getNbTaxonsProPatriDpt(connection, num_dpt) statsStatutTaxonDpt = vmStatsStatutTaxonDptRepository.getStatsStatutsTaxonsDpt(connection, num_dpt) infosDpt = vmDepartementRepository.infosDpt(connection, num_dpt) communesDpt = vmDepartementRepository.communesDptChilds(connection, num_dpt) epciDpt = vmDepartementRepository.epciDptChilds(connection, num_dpt) dpt = vmDepartementRepository.getDepartementFromNumdpt(connection, num_dpt) statsorgataxondpt = vmStatsOrgaDptRepository.getStatsOrgaTaxonDptChilds(connection, num_dpt) statsorgadatadpt = vmStatsOrgaDptRepository.getStatsOrgaDataDptChilds(connection, num_dpt) statsgroup2inpndpt = vmStatsGroup2inpnDptRepository.getStatsGroup2inpnDptChilds(connection, num_dpt) statstaxongroup2inpndpt = vmStatsTaxonGroup2inpnDptRepository.getStatsTaxonGroup2inpnDptChilds(connection, num_dpt) communesSearch = vmCommunesRepository.getAllCommunes(session) epciSearch = vmEpciRepository.getAllEpci(session) departementSearch = vmDepartementRepository.getAllDepartement(session) #if config.AFFICHAGE_MAILLE: # if (config.TAILLE_MAILLES_DPT=='10'): # observations = vmObservationsMaillesRepository.lastObservationsDptMaille10( # connection, config.NB_LAST_OBS, num_dpt # ) # else: # observations = vmObservationsMaillesRepository.lastObservationsDptMaille( # connection, config.NB_LAST_OBS, num_dpt # ) #else: # observations = vmObservationsRepository.lastObservationsDpt( # connection, config.NB_LAST_OBS, num_dpt # ) orgas = vmObservationsRepository.getOrgasDpt(connection, num_dpt) observers = vmObservationsRepository.getObserversDpt(connection, num_dpt) configuration = base_configuration.copy() configuration.update({ 'NB_LAST_OBS': config.NB_LAST_OBS, 'AFFICHAGE_ORGAS_OBS_FICHECOMM': config.AFFICHAGE_ORGAS_OBS_FICHECOMM, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'TAILLE_MAILLES_DPT': config.TAILLE_MAILLES_DPT, 'MAP': config.MAP, 'MYTYPE': 0, 'PRESSION_PROSPECTION': config.PRESSION_PROSPECTION, 'AFFICHE_PATRIMONIALITE' : config.AFFICHE_PATRIMONIALITE, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) session.close() connection.close() return render_template( 'templates/ficheDepartement.html', num_dpt=num_dpt, listTaxons=listTaxons, listespeces=listespeces, taxonProPatri=taxonProPatri, statsStatutTaxonDpt=statsStatutTaxonDpt, infosDpt=infosDpt, communesDpt=communesDpt, epciDpt=epciDpt, referenciel=dpt, statsorgataxondpt=statsorgataxondpt, statsorgadatadpt=statsorgadatadpt, statsgroup2inpndpt=statsgroup2inpndpt, statstaxongroup2inpndpt=statstaxongroup2inpndpt, communesSearch=communesSearch, epciSearch=epciSearch, departementSearch=departementSearch, #observations=observations, orgas=orgas, observers=observers, configuration=configuration )
def ficheCommune(insee): session = utils.loadSession() connection = utils.engine.connect() listTaxons = vmTaxonsRepository.getTaxonsCommunes(connection, insee) listespeces = vmTaxonsRepository.getListeTaxonsCommunes(connection, insee) taxonProPatri = vmStatsStatutTaxonCommRepository.getNbTaxonsProPatriCommunes(connection, insee) statsStatutTaxonComm = vmStatsStatutTaxonCommRepository.getStatsStatutsTaxonsCommunes(connection, insee) infosCommune = vmCommunesRepository.infosCommune(connection, insee) epciCommune = vmCommunesRepository.epciCommune(connection, insee) commune = vmCommunesRepository.getCommuneFromInsee(connection, insee) statsorgataxoncomm = vmStatsOrgaCommRepository.getStatsOrgaTaxonCommChilds(connection, insee) statsorgadatacomm = vmStatsOrgaCommRepository.getStatsOrgaDataCommChilds(connection, insee) statsgroup2inpncomm = vmStatsGroup2inpnCommRepository.getStatsGroup2inpnCommChilds(connection, insee) statstaxongroup2inpncomm = vmStatsTaxonGroup2inpnCommRepository.getStatsTaxonGroup2inpnCommChilds(connection, insee) communesSearch = vmCommunesRepository.getAllCommunes(session) epciSearch = vmEpciRepository.getAllEpci(session) departementSearch = vmDepartementRepository.getAllDepartement(session) if config.AFFICHAGE_MAILLE: observations = vmObservationsMaillesRepository.lastObservationsCommuneMaille( connection, config.NB_LAST_OBS, insee ) else: observations = vmObservationsRepository.lastObservationsCommune( connection, config.NB_LAST_OBS, insee ) orgas = vmObservationsRepository.getOrgasCommunes(connection, insee) observers = vmObservationsRepository.getObserversCommunes(connection, insee) configuration = base_configuration.copy() configuration.update({ 'NB_LAST_OBS': config.NB_LAST_OBS, 'AFFICHAGE_ORGAS_OBS_FICHECOMM': config.AFFICHAGE_ORGAS_OBS_FICHECOMM, 'AFFICHAGE_MAILLE': config.AFFICHAGE_MAILLE, 'MAP': config.MAP, 'MYTYPE': 0, 'PRESSION_PROSPECTION': config.PRESSION_PROSPECTION, 'AFFICHE_PATRIMONIALITE' : config.AFFICHE_PATRIMONIALITE, 'PATRIMONIALITE': config.PATRIMONIALITE, 'PROTECTION': config.PROTECTION }) session.close() connection.close() return render_template( 'templates/ficheCommune.html', insee=insee, listTaxons=listTaxons, listespeces=listespeces, taxonProPatri=taxonProPatri, statsStatutTaxonComm=statsStatutTaxonComm, infosCommune=infosCommune, epciCommune=epciCommune, referenciel=commune, statsorgataxoncomm=statsorgataxoncomm, statsorgadatacomm=statsorgadatacomm, statsgroup2inpncomm=statsgroup2inpncomm, statstaxongroup2inpncomm=statstaxongroup2inpncomm, communesSearch=communesSearch, epciSearch=epciSearch, departementSearch=departementSearch, observations=observations, orgas=orgas, observers=observers, configuration=configuration )