def listeTaxonCommune_pdf(insee):
session = utils.loadSession()
connection = utils.engine.connect()
listTaxons = vmTaxonsRepository.getListeTaxonsCommunes(connection, insee)
#infosCommune = vmCommunesRepository.infosCommune(connection, insee)
#epciCommune = vmCommunesRepository.epciCommune(connection, insee)
commune = vmCommunesRepository.getCommuneFromInsee(connection, insee)
#statsorgacomm = vmStatsOrgaCommRepository.getStatsOrgaCommChilds(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()
html = render_template(
'static/custom/templates/listeTaxonCommune_pdf.html',
insee=insee,
now = (datetime.now()).strftime("%d-%m-%Y"),
listTaxons=listTaxons,
#infosCommune=infosCommune,
#epciCommune=epciCommune,
referenciel=commune,
#statsorgacomm=statsorgacomm,
#statsgroup2inpncomm=statsgroup2inpncomm,
#statstaxongroup2inpncomm=statstaxongroup2inpncomm,
#communesSearch=communesSearch,
#epciSearch=epciSearch,
#departementSearch=departementSearch,
#observations=observations,
#orgas=orgas,
#observers=observers,
configuration=configuration
) # Make a PDF straight from HTML in a string.
return render_pdf(HTML(string=html))
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 = 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 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
)