ei*|ddlmZmZddlZddlmZddlZddlZddlZddlZ ddl m Z ddl ZddlZddlZddlmZddlmZddlZddlZddlZddlZddlZddlZddlZddlZddlZddlZddlZddl Z ddl!Z!ddl Z ddl"Z"ddl#Z#ddl$Z$ddl%Z%ddl&Z&ddl'Z'ddl&m(Z(m)Z)m*Z*ddl%m+Z+ddl,m-Z-ddlm.Z.ddlm/Z/dd l0m1Z1dd l2m3Z3dd l4m5Z5dd l6m7Z7dd l8m9Z9ddlm:Z:ddl;mZ>ddl?m@Z@ddlAmBZBddlCmDZDddlEZEddlFZFddlGZGddlHmIZIddlJddlKddlLddlMddlNGddeOZPdZQdZRdZSdZTdZUdZVdZWdZXd ZYd!ZZd"Z[d#Z\d$Z]d%Z^d&Z_d'Z`d(Zay)))HTMLCSSN)datetime)SMTP_SSLSMTPSMTPAuthenticationError)create_default_context) EmailMessage)date) randrange)encoders)MIMEBase) MIMEMultipart)MIMEText)MIMEApplication) urlretrieve)default_backend)hashes) PBKDF2HMAC)Fernet) relativedelta)Image)*c eZdZy) NoPumpsErrorN)__name__ __module__ __qualname__1/var/www/reporter.gc-track.com/app/lib/htmlgen.pyrr=sr rc t|d}y)Ndetectora!
id
"+str(data["id"])+"
detectorstate_id
"+str(data["detectorstate_id"])+"
label_title
"+str(data["label_title"])+"
label_subtitle
"+str(data["label_subtitle"])+"
tag
"+str(data["tag"])+"
type
"+str(data["type"])+"
serial_number
"+str(data["serial_number"])+"
technician
"+str(data["technician"])+"
installation_date
"+str(data["installation_date"])+"
is_online
"+str(data["is_online"])+"
is_active
"+str(data["is_active"])+"
using_battery
"+str(data["using_battery"])+"
baudrate
"+str(data["baudrate"])+"
model
"+str(data["model"])+"
brand
"+str(data["brand"])+"
maker
"+str(data["maker"])+"
tz
"+str(data["tz"])+"
last_transmission
"+str(data["last_transmission"])+"
sw_maintenance
"+str(data["sw_maintenance"])+"
has_securitycontact
"+str(data["has_securitycontact"])+"
is_battery_enabled
"+str(data["is_battery_enabled"])+"
is_reset_enabled
"+str(data["is_reset_enabled"])+"
is_sd_enabled
"+str(data["is_sd_enabled"])+"
is_sd_healthy
"+str(data["is_sd_healthy"])+"
flag_version
"+str(data["flag_version"])+"
slave_id
"+str(data["slave_id"])+"
has_panelmap
"+str(data["has_panelmap"])+"
is_protocol_disconnected
"+str(data["is_protocol_disconnected"])+"
connection_mode
"+str(data["connection_mode"])+"
count_bad_transmissions
"+str(data["count_bad_transmissions"])+"
vendor_id
"+str(data["vendor_id"])+"
buyer
"+str(data["buyer"])+"
carrier
"+str(data["carrier"])+"
icc
"+str(data["icc"])+"
sim_phonenumber
"+str(data["sim_phonenumber"])+"
)getDetectorInfo)facilitydatas r!getDetectorInfoHtmlr'@s 8 $Z 0DL r c  |d}|d}d}d}d}d}t|dt|dz}|dz }|d|ddz }|d|ddz }|d|dz }t|dt|dz}|d z }|d|ddz }|d|ddz }|d|dz }t|d t|d z} |d z }|d|d dz }|d|d dz }|d| dz }|rd |d |d|d|d } | Sd} | S#ttf$rYywxYw)Nconteo_arranques_bombasconteo_arranques_bombas_mantdiesel_activations Bomba Diesel electric_activations Bomba Electrica jockey_activations Bomba Jockey z\9(+
Arranques de motor
En mantenimiento
Fuera de mantenimiento
Total
KeyError TypeErrorint stateRecordsr&dataMant pumpNames mant_runs normal_runs total_runsbd_totalbe_totalbj_totalcontents r!getNewPumpRunCountrGs56 >? IIKJ4,-.X>R5S1TTH **I 4!567u==IT$345U;;KD %((J4./03x@V7W3XXH --I 4!789??IT$567u==KD %((J4,-.X>R5S1TTH **I 4!567u==IT$345U;;KD %((J([)./8[944?=A##-,/  N N[ i  C44DDc  |d}|d}d}d}d}d}t|dt|dz}|dz }|d|ddz }|d|ddz }|d|dz }t|dt|dz}|d z }|d|ddz }|d|ddz }|d|dz }t|d t|d z} |d z }|d|d dz }|d|d dz }|d| dz }|rd |d |d|d|d } | Sd} | S#ttf$rYywxYw)Nconteo_alertas_generalesconteo_alertas_generales_mantr+r,r-r.r/r0r1r2r3z~r4r5r6r7r8r<s r!getNewAlertCountrLs67 ?@ IIKJ4,-.X>R5S1TTH **I 4!567u==IT$345U;;KD %((J4./03x@V7W3XXH --I 4!789??IT$567u==KD %((J4,-.X>R5S1TTH **I 4!567u==IT$345U;;KD %((J([)./8[944?=A##-,/  N N[ i rHcHt||dd}|jdg}|jdg}d}d}d}d}|D][} |dz| dzdz}|dzt| d zdz}|dzt| d zdz}|dzt| d | d zzdz}]|D]L} |d z}|dzt| d zdz}|dzt| d zdz}|dzt| dzdz}N|dk7r+|dk7r&|dk7r!|dk7rd|zdz|zdz|zdz|zdz} | Sd} | S)N facility_datarpump_running_alerts_countjockey_pump_activations_countr+r. pump_namer/current_month_count_maintenancecurrent_month_countzlast30days_maintenancemonth_activationstotala<
Alertas generales
Bomba Jockey
Arranques de motor
En mantenimiento
Fuera de mantenimiento
Total
)getMonthActivationsgetstr) facilityIdmonth facility_infopumpRun jockeyRunr?r@rArBpumpnjockeyrFs r!getPumpRunCountre6s' 59/J1MM ;R@G!!"A2FIIIKJ|&u['99'A &s51R+S'TTU\\ !F*3u5J/K+LLWT &(U3T-UV[\qVr-r)sst{{ | F 88 &s62J+K'LLWT !F*3v6I/J+KKGS &(VG_)==gE F B9?{b/@ZSUEU. /8 8 9. ./8 89../::;..&/9'9&:*'*4 N Nr c@|d}d}d}d}d}d}|D][}|dz|dzdz}|dzt|dzdz}|dzt|dzdz}|dzt|d|dzzdz}]|dk7r)|dk7r$|dk7r|dk7rd|zd z|zd z|zd z|zd z}|S) Npump_trouble_alerts_countr+r.rQr/rRrSa; rWrXrYrZ)r]) reportDatarar?r@rArBrFrcs r!getPumpAlertCountriis645GIIKJG|&u['99'A &s51R+S'TTU\\ !F*3u5J/K+LLWT &(U3H-I%PqJr-r)sst{{ | B9?{b/@ZSUEU. /8 8 9. ./8 89../::;..&/9'9&:*'*. Nr cL|d}|d} |d}|d}||z}dt|dzdzt|dzdzt|d zdzt|zd zt|dzdzt|dzdzt|d zdzt|zd zt|d|dzzdzt|d|dzzdzt|d |d zzdzt|zd z}|d k7r|Std#t$r d}d}d}YwxYw)Nalarm_panel_events_counteralarm_panel_events_mant_counter SEGURIDADru
Alertas generales
Alertas de panel de alarmas
Alarmas de Fuego Alarmas de Falla Alarmas de Supervisión Alarmas de Seguridad
En Mantenimiento NORMALz5 ALARMA SUPERVISORIOz
Fuera de Mantenimiento z
Total z
r++A descriptive message about the type error.)r:r])rhr# detectorMansegsegmsegtotalrFs r!getDetectorCountrvs67H>?K{#;'8 2 36k(6K2L!M N2!2"36k(6K2L#M"N2#2$36k.6Q2R%S$T2%2&36d)'<&=2'2.36hx6H2I/J.K2/2036hx6H2I1J0K212236h~6N2O3P2Q232436c(5;4<252<36hx6HU]I^6^2_=`<a2=2>36hx6HU]I^6^2_?`>a2? 2@36h~6N{[iOj6j2kA l@m2A!2B36h-C!@BA*C$*GJ"}EFF[ sDD#"D#ct|d}d}d}|D]*}|dz}|D]}|dzt||zdz}|dz},||zdzS) Ncomponent_lista T
Notificaciones del panel de alarmas
Descripción Fecha
)listDetectorMessageByDateformatDateAlertsr^ startDateendDater&rrtables r!generateAlarmTableByDateHtmlrs $Z ' BCY ZDI&v% v%d?&;;GC v%&6tL7I&JJ7R v% & %&/ /0* *E Lr ctjt|d}t|j}t|j }t||d}t||dzd} t ||jd|jdd}d}|D]1} |dz}|dz| dzd z}|dzt| d zd z}|dz}3d |zd z} | S#tjj$rYywxYw) Nz%Y-%mz%Y-%m-%drr+ryrzrr{rrr) rstrptimer]r;yearr_rstrftimerjsondecoderJSONDecodeError) r^r selectedDaterr_rrr&rrrs r!generateAlarmTableByMonthHtmlr s0$$SYw7L |  !D  "" #EeA&ItE!GA&G(I4F4Fz4RSZScScdnSoprHI  *D!6)I!6)$*??GI!6)*:4 ;M*NNwVI!6)I  * %&/ /0* *" L << ' 's(A.CC87C8ct|d}d}|D]a}|dz}|d}|ddurd}|dz|zdz}|dzt|d zdz}|dzt|d zdz}|dz|d zdz}|dz}cd |zd z}|S)Nredboxmessage_listr+ryru ActivaciónArranque de Motor de Bombarzr{ start_timeend_time active_timeQ r)listAlertHistoryr)r^r&rrsubjectrs r!generateAlertHistoryHtmlr/s J '(< =DI&v% '  M 12Gv%g-g5 v%&6tL7I&JJ7R v%&6tJ7G&HHP v%d=&99'A v% &" %&/ /0* *E" Lr c d}d}|d}t|dkrd}|S|D]}|jdd}|jdd}|jdd}|jd d}|jd d} |d |d |d t|d t|d | d z }|r |d|dz }|dk7r|Std)Nr+activaciones_generalesrzM output_nameN/Acomponent_typerrruV
Alertas fuera del mantenimiento -d
Descripción Inicio Restablecimiento Duración
(hh:mm:ss)
No se encontraron Alertas generales fuera de mantenimiento
&
Alertas generales fuera de mantenimiento
Descripción Equipo Inicio Restablecimiento Duración
(hh:mm:ss)
rqlenr\rr: r=rF tabledatadetailspumpruneventdevicestartenddurations r!generateAlertHistorybyMonthHtmlrXs&GI34G 7|aaX M51-u5 L%0kk*e,;;}e4xwixyAQRWAX@YYbcstwcxbyzCDLCMMWX X X   ""}EFFr c d}d}|d}t|dkrd}|S|D]}|jdd}|jdd}|jdd}|jd d}|jd d} |d |d |d t|d t|d | d z }|r |d|dz }|dk7r|Std)Nr+activaciones_generales_mantrzGNo se encontraron alertas generales en mantenimientorrrrrrrrruP rrqrrs r!#generateAlertHistorybyMonthHtmlMantrs$GI89G 7|a[X M51-u5 L%0kk*e,;;}e4xwixyAQRWAX@YYbcstwcxbyzCDLCMMWX X X   ""}EFFr c t|||d}d}|D]V}|dz}|dz|dzdz}|dzt|dzdz}|dzt|dzdz}|dz|d zdz}|dz}Xd |zd z}|S#t$rYywxYw) Nrr+ryrzrr{rrrrr)listAlertHistoryByDater Exceptionrs r!generateAlertHistoryByDateHtmlrs #Jy ABV Wdi($')'_(==gE)'(8l9K(LLWT)'(8j9I(JJ7R)'](;;GC)') ( %&/ /0**e& L sA5A99 BBc<t||}|dk7rytd)Nr+u

Comportamiento de presión de sistema

rq)generatePressureGraphr: componentIdr_paths r!generatePressureGraphHtmlrs' U 3D rzVEFFr c<t||}|dk7rytd)Nr+z

Conteo de arranques de bomba jockey

rq)generateJockeyGraphr:rs r!generateJockeyGraphHtmlrs' {5 1D rzREFFr c pd}d}|d}t|dkr td|D]s}d}|jdd}|jdd}|jd d}|jd d} |d |d |d t|d t|d | d z }u|r |d|dz }|dk7r|St d)Nr+arranques_bombasrrqrrrrrrrrruN
Alertas generales en mantenimiento
Descripción Equipo Inicio Restablecimiento Duración
(hh:mm:ss)
r)rrr\rr:rs r!generatePumpDetailsrsGI-.G 7|aHIIX,-u5 L%0kk*e,;;}e4xwixyAQRWAX@YYbcstwcxbyzCDLCMMWX X X   ""}EFFr c bd}d}|d}t|dkrd}|S|D]s}d}|jdd}|jdd}|jd d}|jd d} |d |d |d t|d t|d | d z }u|r |d|dz }|dk7r|Std)Nr+arranques_bombas_mantrz?rrrrrrrrruH
Arranques fuera de mantenimiento
Descripción Equipo Inicio Restablecimiento Duración
(hh:mm:ss)
No se encontraron arranques en mantenimiento
rrqrrs r!generatePumpDetailsMantrsGI23G 7|aSX,-u5 L%0kk*e,;;}e4xwixyAQRWAX@YYbcstwcxbyzCDLCMMWX X X   ""}EFFr )b weasyprintrrtimer subprocessosrpandaspdmatplotlib.patchespatchesmpatchesnumpynppylabpltrequestsmatplotlib.pyplotpyplotmatplotlib.datesdatesmdate matplotlibmplrandomstringsysreurllib.requesturllib unicodedatalocalepdfkitargparseshutilfnmatchsslsmtplibgcrrrr email.messager r r emailr email.mime.baseremail.mime.multipartremail.mime.textremail.mime.applicationrrcryptography.hazmat.backendsrcryptography.hazmat.primitivesr)cryptography.hazmat.primitives.kdf.pbkdf2rcryptography.fernetrdateutil.relativedeltarcairosvg traceback dateparserPILr lib.apicalls lib.utils lib.htmlgen lib.graphsgenlib.langstringsrrr'rGrLrerirvrrrrrrrrrrrrr r!rs,  %        ;;&&$.$2&81@&0 9 N`1f1f1f'R5Gn$,L6#J'R'GR&GP!FGG%GN&Gr
Arranques en mantenimiento
Descripción Equipo Inicio Restablecimiento Duración
(hh:mm:ss)