def get_export(code_com, num_ordre, nro):
num_ordre = "%05d" % int(num_ordre)
code = code_com + '/' + nro + '/PB/' + num_ordre
print('Création de la fiche export pour: ' + code)
objectid_obj = sql("select objectid from ftth_zone_eligibilite where code_com='" + code_com + "' and type_pf='PB' and id_metier_pf='" + code + "'")
objectid_obj = sql_response_as_list(objectid_obj)[0]
if objectid_obj and 'objectid' in objectid_obj:
objectid = objectid_obj['objectid']
else:
objectid_obj = sql("select objectid from ftth_pf where code_com='" + code_com + "' and type_pf='PB' and id_metier_pf='" + code + "'")
objectid_obj = sql_response_as_list(objectid_obj)[0]
if objectid_obj and 'objectid' in objectid_obj:
objectid = objectid_obj['objectid']
else:
return None
filename_exportImbSoe =\
loads(
b64decode(
get("http://geofibre.sso.francetelecom.fr/RestFmkSrvDeploy/orion/applications/clientorion/keepalive?url="
+ quote("http://localhost/RestFmkSrvDeploy/orion/applications/clientorion/arcgis/rest/services/geofibre/short_soe/MapServer/exts/ExportImb/ExportImbZone?objectId="
+ objectid
+ "&layerImbId=5&layerZoneId=20&token=unknow&auteur=djhc1710&nomChampIdMetierZone=id_metier_ze&zone_geo=METROPOLE")
).replace(b'|FT|', b'')
).decode()
)['filename']
export =\
b64decode(
loads(
get("http://geofibre.sso.francetelecom.fr/RestFmkSrvDeploy/orion/applications/clientorion/exportImb?token=unknow&auteur=djhc1710&filename="
+ quote(filename_exportImbSoe)
).decode('utf-8')
)['detail'].replace('\n', ''))
with open(__JOB_PATH__ + sep + code.replace('/', '_') + '.csv', 'wb') as file_:
file_.write(codecs.BOM_UTF8)
file_.write(export)
def sql(sql_cmd, return_cmd=False): geofibre_bdd_url = "http://geofibre.sso.francetelecom.fr/RestFmkSrvDeploy/orion/applications/clientorion/requeteBDD?date=Thu%20Jul%209%2015%3A23%3A38%20GMT%2B0200%202015&token=unknow&REQUETE=" response = loads( b64decode( get( geofibre_bdd_url + sql_cmd ).replace(b'\r\n', b'') ).decode() )['reponse'] if return_cmd: return (sql_cmd, response) else: return response
