def get_servidores(post_id=None): x = 'SELECT s.*,s.Id as codigo,s.name_servidor as valor FROM kpi.ws_servidores s;' rv = metodos.set_list(x,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB']) if rv != None : return rv return jsonify({"type":"error","status":401,"data":None})
def lista_report_detail(post_id=None): x = 'call kpi.sp_reports(2,'+str(post_id)+')' rv = metodos.set_list(x,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB']) if rv != None : return rv return jsonify({"type":"error","status":401,"data":None})
def lista_report_init(): x = 'call kpi.sp_reports(1,0)' rv = metodos.set_list(x,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB']) if rv != None : return rv return jsonify({"type":"error","status":401,"data":None})
def lista_report(post_id=None): x = 'call kpi.sp_reports(1,'+str(post_id)+')' rv = metodos.set_list(x,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB']) if rv != None : content = rv.json today = date.today() ruta_plantilla = content['data'][0]['ruta_plantilla'] correos = content['data'][0]['correos'].split(",") if content['data'][0]['correos'] != None else [] html = content['data'][0]['plantilla'].replace("@NOMBRE_CLIENTE",content['data'][0]['Razon']) html = html.replace("@DIA_REPORTE",str(today)) html = html.replace("@NOMBRE_REPORTE",content['data'][0]['reporte']) html = html.replace("@CORREO_CLIENTE",content['data'][0]['correos']) plantilla = ''+html.encode('utf-8') if content['data'][0]['plantilla'] != None else '' sql='call sp_reports(2,'+str(content['data'][0]['Id'])+')' metodos.modificar_Excel(sql,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB'],ruta_plantilla) send_email(ruta_plantilla,correos,plantilla) return rv return jsonify({"type":"error","status":401,"data":None})
def get_correos(post_id=None): x = 'SELECT c.*,c.Id as codigo,c.name_correo as valor FROM kpi.kpi_correos c' rv = metodos.set_list(x,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB']) if rv != None : return rv return jsonify({"type":"error","status":401,"data":None})
def get_plantillas(post_id=None): x = 'SELECT Id as codigo,name_plantilla as valor FROM kpi.kpi_plantillas' rv = metodos.set_list(x,app.config['HOST'] ,app.config['USER'] ,app.config['PASSWORD'],app.config['DB']) if rv != None : return rv return jsonify({"type":"error","status":401,"data":None})