
    .\h                     <   d dl Z d dlZd dlZd dlZd dlZd dlZd dlZd dlZd dlmZm	Z	 d dl
mZ d dlT d dlT d dlmZ d dlZd dlZedk    rdZndZd	Z	 d
 Z	 d Zd Zd Z	 d Zd Z	 d Zd Z	 d Zd Zd Z	 d Z	 d Z d Z!d Z"	 d Z#	 d Z$d Z%d dZ&	 d Z'd Z(dS )!    N)datetime	timedelta)Create)*)platformdarwinzD/Users/wsoft/Documents/wsoft.com.mx/carteraplus-automatizador/files/z6/var/www/wsoft.com.mx/carteraplus-automatizador/files/zNhttps://distribuidores.axa.com.mx/siteminderagent/forms/axa/dist/login_Liferayc                 h
  K   |                      dd          }|                      dd          }|                      dd          }|                      dd          }|                      dd          }|                      dd          }|                      dd          }|d	k    r t          |d
         dd           d {V  dS t          d
|d
         i           d {V  |d         |d<   |d         |d<   |dk    r$t          |d         |d
         d           d {V }t	          |d                    d {V \  }}		 t          dt          |                      t          |          dk    rV|d         d         dk    rD|d          }
t          j        	                    d|
 d          rt          j
        d|
 d           t          |          dk    rt          |d
         dd           d {V  |dk    rH|d         }|d          }
t          ||
           d {V \  }}}t          d
|d
         i           d {V  t          |          dk    r|d         d         dk    s|d         d         dk    rkt          d|d         |d         d          |d         d!         d"           d {V }|d#         d$k    r|d%         d$k    rt          i |d&ddd$|d         d'         |d         d          |d#         |d%         d(d)           d {V  t          d
|d
         i           d {V  t          |d         d*         d+d,           d {V  t          |d         d*         d+d,           d {V  d$S t!          ||
           d {V }|d         }|}||d-<   |d         }|}||d-<   t#          j        t'          ||          t)          ||                     d {V  nq|D ]n}t+                                           |d                   }t-          |          r||d-<    |||           d {V  Pt          |d
         d.d           d {V  o|dz   | d<   d| d<   || d<   || d<   || d<   t/          |            d {V  n8t          |d
         d+d           d {V  |durt1          ||           d {V  t          |          dk    rWt          |	          dk    rFt          |d
         d+d           d {V  t3          |d
         |d         d/           d {V  d S d S d S )0NdataFconexionprimeraEjecucionpbrowserpagereconteo   id_tarea	err_bucler   statusid_conexionsessioncredenciales)r   r   	subtareaszSUBTAREAS TOTALES    r   funcionverificaLoginSesion../sessions/.jsonsiTocultarNavegador   obtenerDocumentoPoliza obtenerDocumentoRecibosYFacturastodonumero_polizanumero_recibooptr   r%   r&   
url_poliza 
url_recibo   ¡Documentos disponibles!typer(   r-   r%   nombre_numero_polizanombre_numero_recibologinMessage	conectadomostrar_datosdescarga_id	terminador6   r   subtareaerr_fr   r   )getactualizarStatusTareaactualizarConteoUsoTareaobtenerDatosConexionorganizaSubtareasprintlenospathexistsremove actualizarStatusNavegadorAbiertoinicializarPlaywrightobtenerPolizaGuardadaenviarMensajeactualizarStatusSubtareaabrirPestanaPlaywrightasynciogatherr"   r#   globalscallableejecutarProcesosAxacerrarPlaywrightactualizarFechaLogin)
parametrosr
   r   r   r   r   r   r   subtareasNavegadorsubtareasWhatsappr   r    infoPolizaServerpage2item1data1item2data2itemr   s                       =/var/www/wsoft.com.mx/carteraplus-automatizador/python/axa.pyrQ   rQ      s      nnVU33$ nnZ77( nn%7?? nnS%00! nnY66' nnVU33$ nnZ77(!mm
tJ/?;!W!W
Z
ZZZZZZZZ5 JZ0@"BDDDDDDDDD'$y/!&)$~ %)D<O]abl]m+o+oqqqqqqqqH 1B(;BW0X0X*X*X*X*X*X*X'' 8S"46688999	
""!Y'+@@@&(g	5w555	6	6 1
	////000	
!! +$z:JVZ,\,\
^
^^^^^^^^ 	D  01&(g45EwOOOOOOOOa$ %
D4D&FHHHHHHHHH		 	 A	%	%+=a+@+KOg+g+gk}~  lA  BK  lL  Pr  lr  lr4fUYZgUh  |N  OP  |Q  Ra  |b  uG  HI  uJ  KZ  u[  6]  6]   ^   ^  ^  ^  ^  ^  ^  ^	,	'2	-	-2B<2PTV2V2V  ft  f5P_`sw  OQ  [m  no  [p  qw  [x  K]  ^_  K`  ap  Kq  K[  \h  Ki  CS  T`  Ca  Fd  Fd  f  f  f  g  g  	g  	g  	g  	g  	g  	g  	g&*d:6F(HJJJJJJJJJ&1CA1Fu1MYd(f(fhhhhhhhhh&1CA1Fu1MYd(f(fhhhhhhhhhr,Wg>>>>>>>>"1%!j"1%!jn
 u
-
-
*5%
8
8
 
 	
 	
 	
 	
 	
 	
 	
 	

 % h h$))--Y00G 	h!$z
d##
#
#
#
#
#
#
#
#0Z@P\c2d2dgg
g
g
g
g
g
g
g
g&.lJz%*J!"%&JsO%,Jy%)Jv
j
)
)))))))))
*$z:JVa,b,b
e
eeeeeeee	Q(((((((((	
""s+<'='='B'B
tJ/?;!W!W
Z
ZZZZZZZZ
d:.>tTaOb d d
f
ffffffffff #"'B'B    c                   K   d}|                     | d           d {V  |                    d           d {V  t          d|d         i           d {V  t          j        d           d {V  |                    d           d {V }|                    t                    dk    rt          d|d         i           d {V  t          ||           d {V }t          d	|           |r_t          d|d         i           d {V  t          |d         |d
         d           d {V  |                     | d           d {V  nd}|S )NT逩 timeoutnetworkidler   r!   () => window.location.hrefsesioniniciadar   r;   F)gotowait_for_load_stater>   rM   sleepevaluatefindurlLogininiciar_sesionrA   rS   )urlr   r
   continuaOperacion
url_actualsesionIniciadas         r^   validar_inicio_sesionrs      s     		#v	&&&&&&&&&  ///////// JZ0@"BDDDDDDDDDa ]]#?@@@@@@@@*__X## #j$z2B$D
F
FFFFFFFF)$55555555N	
>***  $
D4D&FHHHHHHHHH Z0@QUVcQd"f"fhhhhhhhhhIIc6I**********	r_   c                   	K   d}|d         }|d         d         }|d         d         }t           j                            d| d          rt          j        d| d           d		fd}|                     d	|           |                     d
                                           d {V  t          j        d           d {V  |                     d
          	                    |           d {V  t          j        d           d {V  |                     d                                           d {V  |                     d          	                    |           d {V  t          j        d           d {V  | 
                    dd                                           d {V  |                     d           d {V  t          j        d           d {V  	du rt          |d         d         |d         |d         d         |d         d         |d         d         d           d {V }t          |d         d         dd           d {V  t          |d         dd           d {V  t          j        d           d S |                     d           d {V }|                    t&                    d k    rSt)          i |d!d"d#           d {V  t          j        d"           d {V  t)          i |d$d"d#           d {V  nD| j                            d| d%           d {V  t)          i |d$ddd&           d {V  d}|S )'NFr   r   campo1campo2r   r   c                 V   K   d| j         v rd|                                  d {V  d S )Nz<El usuario y/o password son incorrectos, favor de verificar.T)messagedismiss)dialogerrorSesions    r^   handle_dialogz%iniciar_sesion.<locals>.handle_dialog   sA      EWWk
..

r_   rz   zIngresa tu usuarior   u   Ingresa tú contraseñabuttonINGRESARnamerd      T	id_accesor   clave_agenteidentificadorsublicencia)r   r   r   r   r   r9   r6   err_sessionr8   r   r   re   rf   zERROR DE INICIO DE SESION.r   r2   r3   r*   )rD   )r2   r3   saveSession)rC   rD   rE   rF   onget_by_placeholderclickrM   rj   fillget_by_roleri   notificarErrorSesionrK   r=   sysexitrk   rl   rm   rJ   contextstorage_state)
r   r
   rr   r   usuariopasswordr|   notificacionrq   r{   s
            @r^   rn   rn      s     .&''1''1( W^^1711122 -I+W+++,,, +     ''(M""" 	 455;;=========a 455::7CCCCCCCCCa 9::@@BBBBBBBBB 9::??IIIIIIIIIa
3399;;;;;;;;;  /////////a D-T.=QR]=^lpq{l|  OS  Tb  Oc  dr  Os  FJ  KY  FZ  [j  Fk  |@  AO  |P  Q^  |_  /b  /b  c  c  c  c  c  c  c  cL
"T*-=e-DP]$_$_
a
aaaaaaaa
tJ/?=!Y!Y
[
[[[[[[[[HQKKKKK }}%ABBBBBBBBJx  2%%cTc3P_`cccdddddddddM!HTH2AHHHIIIIIIIIII L&&,I7,I,I,I&JJJJJJJJJ\T\2AVZ\\\]]]]]]]]]nr_   c                   K   t          i |d|d         dd           d {V  t          d| |           d {V }|rmt          |d         |d         d           d {V  t          i |d|d         dd           d {V  t          |d	         d
         dd           d {V  d S t          i |d|d         dd           d {V  t          |d	         d
         dd           d {V  d S )NTr   u   Intentando iniciar sesión)login_intentor   mensaje?https://distribuidores.axa.com.mx/group/distribucion/disclaimerr   r;   u   ¡Sesión validada con éxito!r9   r6   r7   r8   zDatos incorrectos)rJ   rs   rS   rK   )r   r
   rp   s      r^   r   r      s       D  DT-EX  fB  D  D  D  	E  	E  E  E  E  E  E  E  E12suy{  A  A  A  A  A  A  A  A `
d:.>tTaOb d d
f
ffffffff
  J4  J$tMGZ  hH  J  J  J  K  K  K  K  K  K  K  K  K
"T*-=e-DP[$]$]
_
__________ |4|$tMGZgz|||
}
}}}}}}}}
"T*-=e-DP[$]$]
_
__________r_   c                 
  K   t          |d         d         dd           d {V  t          d| |           d {V }|rt          d           t          i |ddd	           d {V  	 |                     d
                              d           d {V r/|                     dd                                           d {V  n&# t          $ r}t          d           Y d }~nd }~ww xY w| 	                    dd           d {V  | 
                    d           d {V  t          j        d           d {V  |                     d                              d           d {V r-|                     d                                           d {V  t          j        d           d {V  t          t          t          j                    j                             |                     d           d {V  t          j        d           d {V  |                     d                              t          t          j                    j                             d {V  t          j        d           d {V  |                     d           d {V  t          j        d           d {V  t'                      }t          |           d}|                     d                              |           d {V  t          j        d           d {V  |                     dd                              d           d {V  t          j        d           d {V  |                     dd                              d           d {V  |                                 4 d {V }|                     dd           }|                                 d {V  	 |j         d {V }t,           |d!          d"}	|                    |	           d {V  t          d#|	           t          i |d$d%i           d {V  t          j        d           d {V  t          i |d$d&i           d {V  t          i |d'dd	           d {V  t1          ||	           d {V  n&# t          $ r}t          d(           Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S ))Nr9   r6   iniciador8   r   pagadasObteniendo recibos pagadosr!   r   #modalmodalAlert  rb   r}   Cerrarr      No salió el modalzIhttps://cloud.distribuidores.axa.com.mx/group/distribucion/mis-comisionesra   rd   r   z#close-modal-   z{[id="_DLFR228_Estado_De_Cuenta_Comisiones_WAR_axamxdistribuidoresedocuentacomisiones_\:formSelectorAgtPrm\:selectorFechas"]r   zy[id="_DLFR228_Estado_De_Cuenta_Comisiones_WAR_axamxdistribuidoresedocuentacomisiones_\:formSelectorAgtPrmMes\:mesSelect"]Abril	Consultari`  linkDetallei`[ 	Descargarr   _pagadasGuardado enr2      Procesando informaciónActualizando sistemar*   ERROR)rK   rs   rA   rJ   locator
is_visibler   r   	Exceptionrh   ri   rM   rj   strr   nowyearwait_for_selectorselect_optionmeses_hasta_diciembreexpect_downloadvalueRUTA_FOLDERsave_asleerExcelPagadas)
r   r
   rp   e	mesActualmesdownload_infoenlacedownloadrutaArchivos
             r^   exportarReportePagadasr      s      4
+;E+Bj"Z"Z\\\\\\\\\ 22suy{  A  A  A  A  A  A  A  A 9	)
a4a1N]^aaa
b
bbbbbbbb"||.//::4:HH	H	H	H	H	H	H ?xX66<<>>>>>>>>> " " " !!!!!!!!" ))_io)
p
pppppppp

"
"=
1
11111111
-

\\/**55d5CCCCCCCC 2LL))//111111111
-

 
#hlnn!
"
"###

 
   "c  d  d  d  d  d  d  d  d  d
-


,,  Y  Z  Z  h  h  il  mu  my  m{  m{  m@  iA  iA  B  B  B  B  B  B  B  B  B
-



 
   "a  b  b  b  b  b  b  b  b  b
-

%''I	)
C
,,  W  X  X  f  f  gj  k  k  k  k  k  k  k  k  k
-




8+

6
6
<
<U
<
K
KKKKKKKK
-




6	

2
2
8
8
8
H
HHHHHHHH##%%       [99fLLNN&,,,,,,,$?d9o???{+++++++++m[)))RtR^5ORRSSSSSSSSSmAPtP^5LPPQQQQQQQQQJtJRaJJJKKKKKKKKK t[1111111111   g!                             Q9 9sV   -AC 
C/C**C/>2S71CR>=S7>
S!SS7S!!S77
TTc                   K   t          j        |d           }d }t          t          |                    D ]}d|j        |         j        v r|} n|t          d          |j        |         |_        ||dz   d                              d          }|	                    t                    }g }|                                D ]\  }}|                                                                s	d|j        v r nN|j        d         d	k    rJi d
dd| d         d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d |j        d!         d"|j        d#         d$|j        d%         d&|j        d'         d(|j        d)         |j        d*         |j        d+         |j        d,         |j        d-         |j        d.         d/}|                    |           t          t          |                     t!          i | dd0|d1dd2           d {V  t#          d3| d3         i           d {V  t%          | d4         d0|id5           d {V }	t'          | d6         d7         d8d9           d {V  d S ):NheaderMonedau(   No se encontró la cabecera con 'Moneda'r   Tdropr*   r   nancompaniaaxar   r   monedar   ramoasegurado_conceptor!   poliza_descripcionrecibo_ano_vigorr   diar   contable_comprobante   caja_comprobante   
neta_prima   total_prima	   s_prima_comision
   derechos_comision   recargos_comision   total_comision   importe                  )iva_acreditadoiva_retenidoimpuesto_cedularisr
total_pagoarrAxaPagadasr(   arrr4   arrayexcelProcesador   r   r   reportesr9   r6   r7   r8   )pandas
read_excelrangerB   ilocvalues
ValueErrorcolumnsreset_indexastyper   iterrowsisnullanyappendrA   rJ   r>   registrarRecibosrK   )
r
   r   df
header_rowidatos_rowregistrorespuestaReciboss
             r^   r   r   *  s     T222" *R>>  a271:$$$je % 
?
@
@@ wz""*	*q.//&&D&11" 
yy~~" % ! !fa
zz|| R3:--e
x{e%d>*>:  chqk	
 CHQK CHQK #(1+ SXa[ chqk #(1+ CHQK SXa[ #(2, 38B< 38B<  !" "#$ hrl(2,Xb\HRL-  H2 
LLE

 	  C  C`e?h?h  }A  C  C  C  	D  	D  D  D  D  D  D  D  D JZ0@"BDDDDDDDDD+d=>Qaprw_y-{-{}}}}}}}} 4
+;E+Bk"["[]]]]]]]]]]]r_   c                 	  K   t          |d         d         dd           d {V  t          d| |           d {V }t          j        d           d {V  |r$t	          d           t          i |dd	d
           d {V  t          j        d           d {V  |                     d                              d           d {V r/|                     dd          	                                 d {V  t          j        d           d {V  | 
                    d           d {V  |                     dd           d {V  | 
                    d           d {V  t          j        d           d {V  |                     dd          	                                 d {V  t          j        d           d {V  t                      }|                     d                              |                                           d {V  |                     d                              |                                           d {V  |                                 4 d {V }|                     dd          	                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|	                    d           d {V  |                                4 d {V }|                    dd          	                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                                4 d {V }|                    dd          	                                 d {V  	 |j         d {V }	t$           |d          d}
|	                    |
           d {V  t	          d|
           t          i |d dd
           d {V  t)          ||
           d {V  n&# t*          $ r}t	          d!           Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S )"Nr9   r6   r   r8   r   r   	pagadasv2r   r!   r   r   0u  rb   r}   r   r   rd   zChttps://portal-cloud.axa.com.mx/PrimaPagadaAxa/logon.do?action=Homera   r   r   zTodos los Ramoszselect[name="mesdesde"]zselect[name="meshasta"]r   z$tr.renglon_claro_cto td:nth-child(4)r   Exportarr   
_pagadasv2r   r*   r   )rK   rs   rM   rj   rA   rJ   r   r   r   r   ri   rh   r   r   upperexpect_popupr   r   r   r   leerExcelPagadasV2r   )r   r
   rp   r   
page2_inforX   
page3_infopage3r   r   r   r   s               r^   exportarReportePagadasV2r  {  s      4
+;E+Bj"Z"Z\\\\\\\\\ 22suy{  A  A  A  A  A  A  A  Aa +	+
a4a1N]^aaa
b
bbbbbbbb
-

\\,--888GGGGGGGG =X844::<<<<<<<<<
-



"
"=
1
11111111
))Yci)
j
jjjjjjjj

"
"=
1
11111111
-




6(9

:
:
@
@
B
BBBBBBBB
-

%''I
,,2
3
3
A
A)//BSBS
T
TTTTTTTT
,,2
3
3
A
A)//BSBS
T
TTTTTTTT  "" A A A A A A AjXK88>>@@@@@@@@@A A A A A A A A A A A A A A A A A A A A A A A A A A A"""""""E
++<
=
========!!## > > > > > > >zf955;;=========> > > > > > > > > > > > > > > > > > > > > > > > > > > """""""E$$&&       -hZ88>>@@@@@@@@@
&,,,,,,,$Ad9oAAA{+++++++++m[)))JtJRaJJJKKKKKKKKK !{3333333333   g                             ?+ +sa   60J88
KK0M
MM0Q,6A<P32Q,3
Q=QQ,QQ,,
Q69Q6c                   K   t          j        |d           d         }g }|                                D ]\  }}t                              |                    dd                    s|                    dd          dk    rOi ddddd	| d
         d	         d|                    dd          d|                    dd          d|                    dd          d|                    dd          d|                    dd          d|                    dd          d|                    dd          d|                    dd          ddd|                    dd          d|                    dd          d|                    d d          d!|                    d"d          d#|                    d$d          |                    d%d          |                    dd          d&}|                    |           t          t          |                     t          d'| d'         i           d {V  t          | d(         d)|id*           d {V }t          |           t          j        t          j        d+k    rd,nd-           t          | d.         d/         d0d1           d {V  d S )2Nr   r   r   r*   r   r   version2r   r   r   r   r   r!   r   r   r   endosor   r   r   fecha_vencimientor   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )r   r   r   r   r   r   ntclsclearr9   r6   r7   r8   )r   	read_htmlr   pdisnar<   r  rA   rB   r>   r  rC   systemr   rK   )r
   r   r  r  r  r	  r
  r  s           r^   r  r    s     D111!4" %   fa	wwswwq"~~ #''!R..B"6"6% d>*>: 2	
 cggann CGGArNN CGGArNN 2 #''!R.. 3771b>> cggann " CGGBOO SWWR__ #''"b//  3772r??!" 3772r??#$ GGBOOR'  H. 
LLE

 JZ0@"BDDDDDDDDD+d=>Qaprw_y-{-{}}}}}}}})RW__EE'222 4
+;E+Bk"["[]]]]]]]]]]]r_   c                 ~  K   t          |d         d         dd           d {V  t          d| |           d {V }|rt          d           t          i |ddd	           d {V  |                     d
           d {V  t          j        d           d {V  	 |                     d                              d           d {V r/| 	                    dd          
                                 d {V  n&# t          $ r}t          d           Y d }~nd }~ww xY w| 	                    dd          
                                 d {V  | 	                    dd          
                                 d {V  t          j        d           d {V  |                                 4 d {V }| 	                    dd                              d          
                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                    d          4 d {V }|	                    dd          
                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                                4 d {V }|	                    dd          }	|	
                                 d {V  	 |j         d {V }
t            |d          d}|
                    |           d {V  t          i |ddi           d {V  t          j        d            d {V  t          i |dd!i           d {V  t          j        d"           d {V  t          i |d#d d	           d {V  t%          ||           d {V  nK# t          $ r>}t          d$|           t          |d         d         d%d           d {V  Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S )&Nr9   r6   r   r8   r   z	por pagarzObteniendo recibos por pagarr!   r   rd   r   r   rb   r}   r   r   r      GestiónmenuitemMi cobranza $r   r   u   Pagos en línea (MIT)r   i@  	ENTENDIDOxlsr   	_porpagarr2   r   r   r   r   r*   r   r:   )rK   rs   rA   rJ   ri   rM   rj   r   r   r   r   r   r  nthr   r   r   r   leerExcelPorPagar)r   r
   rp   r   
page1_infopage1r  rX   r   r   r   r   s               r^   exportarReportePorPagarr/    s      4
+;E+Bj"Z"Z\\\\\\\\\12suy{  A  A  A  A  A  A  A  A '`	+
c4c1P_`ccc
d
dddddddd

"
"=
1
11111111
-

"||.//::4:HH	H	H	H	H	H	H ?xX66<<>>>>>>>>> " " " !!!!!!!!" 

8*

5
5
;
;
=
========


:O

<
<
B
B
D
DDDDDDDD
-

  "" R R R R R R RjV*ABBFFqIIOOQQQQQQQQQR R R R R R R R R R R R R R R R R R R R R R R R R R R"""""""E!!%!00 @ @ @ @ @ @ @Jf;77==?????????@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @"""""""E$$&& ` ` ` ` ` ` `-  e 44fLLNN`&,,,,,,,$@d9o@@@{+++++++++RtR^5ORRSSSSSSSSSmAPtP^5LPPQQQQQQQQQmAJtJRaJJJKKKKKKKKK  k2222222222 ` ` `gq&j1A%1HT[(](]______________`!` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `+'` '`s{   "AD 
D$DD$9AH
HH0J


JJ2P*5COP*
P4P
P*PP**
P47P4c                 *    |                                  S )N)strip)keys    r^   	clean_keyr3    s    	r_   c                    K   t          j        |d           }d }t          t          |                    D ]}d|j        |         j        v r|} n|t          d          |j        |         |_        ||dz   d                              d          }|	                    t                    }g }d}|                                D ]'\  }}|                                                                s	d|j        v r n|j        d	         d
k    rJt          d          d                                t          d          | d         d                                         t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d	                             dd                              dd                              dd                                          t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d                             dd                              dd                              dd                                          t          d          |j        d                              dd                              dd                              dd                                          t          d!          |j        d"                             dd                              dd                              dd                                          t          d#          |j        d$                             dd                              dd                              dd                                          i}	|                    |	           )t%          t          |                     t'          i | dd%|d&dd'           d {V  t)          d(| d(         i           d {V  t+          | d)         d%|id*           d {V }
t-          | d+         d,         d-d.           d {V  d S )/Nr   RAMOu&   No se encontró la cabecera con 'RAMO'r   Tr   r   r*   r   r   r   r   r   r   r   	
'clientepolizar!   r  recibor   tipor   fecha_inicior   	fecha_finr   prima_originalr   tipo_cambior   prima_totalr   arrAxaPorPagarr   r   r   r   r   r9   r6   r7   r8   )r   read_csvr   rB   r   r   r   r   r   r   r   r   r   r  r3  r1  replacer  rA   rJ   r>   r  rK   )r
   r   r  r  r  r  counterr  r	  r
  r  s              r^   r,  r,  "  s     {4000" *R>>  a"""je # 
=
>
>> wz""*	*q.//&&D&11" 
yy~~" %'  fa
zz|| R3:--e
x{e 
U[[]]n!5n!E!K!K!M!M!,,T266>>tRHHPPQTVXYY__aa	CHQK//b99AA$KKSSTWY[\\bbdd38A;..tR88@@rJJRRSVXZ[[aacc38A;..tR88@@rJJRRSVXZ[[aacc38A;..tR88@@rJJRRSVXZ[[aacc!,,T266>>tRHHPPQTVXYY__aa!!4!4T2!>!>!F!FtR!P!P!X!XY\^`!a!a!g!g!i!ichqk11$;;CCD"MMUUVY[]^^ddff !!38A;#6#6tR#@#@#H#Hr#R#R#Z#Z[^`b#c#c#i#i#k#k 3 3D" = = E EdB O O W WX[]_ ` ` f f h h 4 4T2 > > F FtR P P X XY\^` a a g g i iH  
LLE

  D  DHXaf?i?i  ~B  D  D  D  	E  	E  E  E  E  E  E  E  E JZ0@"BDDDDDDDDD+d=>Qaqsx_z-|-|~~~~~~~~ 4
+;E+Bk"["[]]]]]]]]]]]r_   c                   K   |}t          j         |          }i }|D ]}t          j        |d           }d }t          t	          |                    D ]}d|j        |         j        v r|} n|t          d          |j        |         |_        ||dz   d          	                    d          }|
                    t                    }g }	|                                D ]\  }
}|                                                                s	d|j        v r n|j        d         d	k    rH|j        d         |j        d         |j        d
         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         d}|	                    |           t!          i | dt"          |	d           d {V  d S )Nr   u   Número de pólizau4   No se encontró la cabecera con 'Número de póliza'r   Tr   r*   r   r   r   r   r   r   r   r   r   r            r   r   r:  endoso_originalendoso_modificador   u   fecha_emisión
forma_pago
prima_netarA  	aseguradocausaobservaciones)r4   cabeceraarrItemsCancelaciones)globr   r   r   rB   r   r   r   r   r   r   r   r   r   r  r  rJ   datos_agente)r
   r   patronarchivos
contenidosarchivor  r  r  r  r  r	  r
  s                r^   leerExcelCancelacionesrZ  e  s0     & Yv( *  7u 7ug		74	0	0	0B J3r77^^  	!2	2	2
 
3 MNNN $BJ	JNOO		(	(d	(	3	3B 
3B E++--  3					 rSZ//	!		 x{(1+8A; Xa[(2,(2,hrlhrlx|Xb\"" h  ll8 s4s$Lkpsss
t
ttttttttto7u 7ur_   c                   K   t          i |ddd           d {V  |                                 4 d {V }|                     dd          }|                                 d {V  	 |j         d {V }t
           |d          d| }|                    |           d {V  t          i |d	d
i           d {V  t          j        d           d {V  t          i |ddd           d {V  n&# t          $ r}t          d           Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S )Nz"Procesando y esperando descarga...r!   r   r   u   Exportar Pólizasr   r   r  r2   r   r   r   r   )rJ   r   r   r   r   r   r   rM   rj   r   rA   )r   r
   typeFiler   r   r   r   r   s           r^   descargaEsperaReporter]    sc     gg/Tcdggghhhhhhhhh!!##       }f+>??F
,,..
$*******h"@DO@@h@@k[)))))))))PTP>3MPPQQQQQQQQQM!\T\3JYZ\\\]]]]]]]]]]    Gnnnnnnnn                             s<   2D3,BC:9D3:
DDD3DD33
D= D=c                   K   t          i |ddd           d {V  	 |                     dd           d {V  |                     d                              d           d {V r/|                     d	d
                                           d {V  |                     d           d {V  |                     d           d {V  |                     dd                                           d {V  t          i |ddd           d {V  |                     d                              dd                                           d {V  t          j	        d           d {V  t          | |d           d {V  |                     dd           d {V  |                     d                              d           d {V r/|                     d	d
                                           d {V  |                     d           d {V  |                     d           d {V  |                     dd                                           d {V  t          i |ddd           d {V  |                     d                              dd                                           d {V  t          j	        d           d {V  |                     dd                                           d {V  t          j	        d           d {V  t          | |d           d {V  	 t          i | dd           d {V  d S )Nu"   Obteniendo pólizas por renovar...r!   r   4https://distribuidores.axa.com.mx/group/distribucionra   rb   r   r   r}   r   r   rd   u   text="Mostrar Pólizas"r   u   Mostrar PólizaszGENERANDO SALUD...z8[id="_LR_AXA_Dashboard_WAR_LR_AXA_Dashboard_\:j_idt909"]Saludr   zrenovaciones_salud.xlsradio
Canceladaszcanceladas_salud.xlsr   )rJ   rh   r   r   r   r   ri   r   rM   rj   r]  check)r   r
   ejecutorr   s       r^   exportarReporteRenovacionesre    s     gg/Tcdggghhhhhhhhh0 			HRX	YYYYYYYYY<<*++66t6DDDDDDDD ;


8

2
2
8
8
:
::::::::  /////////8999999999&899??AAAAAAAAA 	WW/DSTWWWXXXXXXXXXRSS__`fmt_uu{{}}}}}}}}}adD*BCCCCCCCCC 			HRX	YYYYYYYYY<<*++66t6DDDDDDDD ;


8

2
2
8
8
:
::::::::  /////////8999999999&899??AAAAAAAAA 	WW/DSTWWWXXXXXXXXXRSS__`fmt_uu{{}}}}}}}}}a|44::<<<<<<<<<adD*@AAAAAAAAA, 	EEsEEEFFFFFFFFFFFr_   c                   K   t          j        |d           }dddddddd	d
d	}i }|                                D ]q}|                    |g                                          }||         j        d         }|||                             |g                   j        d         }||f||<   ri }	|                                D ]G\  }\  }}|j        ||j        	                    |          dz   f         }
||         }|
dk    r|
nd|	|<   Hd }t          t          |                    D ]}d|j        |         j        v r|} n|t          d          |j        |         |_        ||dz   d                              d          }|                    t                     }g }|                                D ]\  }}|                                                                s	d|j        v r n|j        d         dk    rH|j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         d }|                    |           t)          i | d|	|d!           d {V  d S )"Nr   oficinanumero_agenteagentecallecolonia	cp_estadotelefonorfccedula_numero)	zOFICINA:zNUM. AGENTE:zAGENTE:zCALLE:zCOLONIA:zCP; ESTADO:u
   TELÉFONO:zRFC:u   CÉDULA NÚMERO:r   r   r   r*   u   DÍAu&   No se encontró la cabecera con 'DÍA'r   Tr   r   r   r   r   r   r   r   r   rG  rH  rI  rJ  )r4   rR  arrItemsRenovaciones)r   r   keysisinr  indexitemsr   r   get_locr   rB   r   r   r   r   r   r   r   r  rJ   )r
   r   r  keywords_mappingposiciones_palabras_clavepalabra_claveresultado_busquedacolumnafilarU  valornueva_claver  r  r  r  r	  r
  s                     r^   leerExcelRenovacionesr~    s$     T222" #'
 
 !',,.. ? ?m-115577 !34:1=Gbk//06q9D04gm,, ,(A(G(G(I(I @ @$m_dGGD"*,,W5599:E"=1K).%RL *R>>  a"""je # 
=
>
>> wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e Xa[hqk!8A;HRLHRLXb\8B<x|x| H  
LL 	pp,hmpppqqqqqqqqqqqr_   c                 @  K   d}d}d}t          |d         d         dd           d {V  t          d| |           d {V }|rWt          d           t          d|d         i           d {V  t	          j        d	           d {V  |                     d           d {V  |                     d
                              d           d {V r/| 	                    dd          
                                 d {V  | 	                    dd          
                                 d {V  | 	                    dd          
                                 d {V  t	          j        d           d {V  |                                 4 d {V }| 	                    dd                              d          
                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                                 d {V  |                    d                              d           d {V  |
                    d           d {V  |                    d                              |d         d                    d {V  |                    d          
                                 d {V  |                                4 d {V }	 |j         d {V }	|	                    d           d {V  t	          j        d           d {V  |	                    d           d {V }
t'          j        d|
          }|r|                    d           }|	j                            d!|            d {V }|d"          d#|d         d          d$}t0           | }t3          |d%          5 }|                    |                                 d {V            t9          t0           |           }t;          t0           | |           d {V }t=          d&|d'         |d         d         ||d(           d {V  t?          i |dd d)d|d         d*         |d         d         |d+d,           d {V  t          d|d         i           d {V  t          |d         d         d-d           d {V  |	                                  d {V  d d d            n# 1 swxY w Y   ne# tB          $ rX}t          d.|           |                     d/                                           d {V }|rt          d0           Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S )1Nr*   r9   r6   r   r8   r_  zObtener polizar   r   r   r  rb   r}   r   r   r%  r&  r'  r   r      Factura electrónica CFDI 3.3 /r   z(select[id*=":selectTipoDocEcmTabPoliza"]u   Carátula de Pólizazinput[id*=":numeroPolizaWgECM"]r%   z!a[id*=":btnConsultaPolEcmPoliza"]rd   r!   z() => {
            const element = document.querySelector('a[onclick*="window.open"]');
            return element ? element.getAttribute('onclick') : '';
        }zwindow.open\('([^']*)'r   zhttps://portal.axa.com.mx/r   _poliza_.pdfwbr:  r   )r(   r   r%   sizero   Tr-   )r(   r-   r%   r/   r1   r7   ERz.portlet-msg-erroruF   El elemento con class='portlet-msg-error' está visible en la página.)"rK   rs   rA   r>   rM   rj   rh   r   r   r   r   r  r+  r   pauser   r   ri   rk   researchgrouprequestr<   r   openwritebodyobtener_peso_archivo_mbsubirArchivoAS3guardarPolizarJ   closer   )r   r
   r   ruta_archivo_s3_polizaruta_archivo_s3_reciborp   r-  r.  r  rX   onclick_valuematchro   responsenombrePolizafpeso_archivo_polizar   r   s                      r^   r"   r"     sQ	     + 4
+;E+Bj"Z"Z\\\\\\\\\12hjnptuuuuuuuu 7Z	

"j$z2B$D
F
FFFFFFFF
-


))J
K
KKKKKKKK\\,--888GGGGGGGG =X844::<<<<<<<<<


8*

5
5
;
;
=
========


:O

<
<
B
B
D
DDDDDDDD
-

  "" \ \ \ \ \ \ \jV*KLLPPQRSSYY[[[[[[[[[\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \"""""""E
++--
--B
C
C
Q
QRh
i
iiiiiiii
++7
8
88888888
--9
:
:
?
?Z@PQ`@a
b
bbbbbbbb
--;
<
<
B
B
D
DDDDDDDD!!## "Z "Z "Z "Z "Z "Z "Zz!Z &&&&&&&''666666666mA $nn .         	3]CC 	"++a..C"]../QC/Q/QRRRRRRRRH"9o^^tJ7G7X^^^L(8,88Kk4(( 	"AggHMMOO++++++,,,$;{<ZL<Z<Z$[$[!-<=[\=[=[]i-j-j'j'j'j'j'j'j$!8DDWjnoyjz  |K  kL  Vi  rH  #J  #J  K  K  K  K  K  K  K  K  K!  #HT  #H2A`d{}  HL  MW  HX  Y_  H`  sw  xB  sC  DS  sT  nD  sF  sF  #H  #H  #H  I  I  I  I  I  I  I  I  I,
D<L.NPPPPPPPPP,tJ7G7NZe.g.giiiiiiiiiKKMM!!!!!!!	" 	" 	" 	" 	" 	" 	" 	" 	" 	" 	" 	" 	" 	" 	"  Z Z ZdA<<(<==HHJJJJJJJJ
 	Z
X
Y
Y
Y	Z="Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z "Z+7Z 7Zsv   AG--
G7:G7/V1C"TD(T;TT	TT	TV
U5AU0+V0U55V
VVc                   K   t          j        d           d {V  |                     d          j                                         d {V  |                                  d {V  |                     dd                                           d {V  |                     d                                           d {V  |                     d                              |           d {V  |                     d                                           d {V  t          j        d           d {V  |                     dd                                           d {V  d}d	}|                     d
d          	                                 d {V }|dk    rd}|                     d
d          	                                 d {V dk    rd}n{|                     d
d          	                                 d {V dk    rd}nD|                     d
d          	                                 d {V dk    rd}n|                     d
d          	                                 d {V dk    rd}n|                     d
d          	                                 d {V dk    rd}n|                     d
d          	                                 d {V dk    rd}nk|                     d
d          	                                 d {V dk    rd}n5|                     d
d          	                                 d {V dk    rd}||fS )Nr!   &#ewc-page-nav-uncollapsed--li-2167 divr}   Filtrarr   z[id="data\[5\]\.input_input"]Aceptar	Cancelador*   gridcellVigenter   u   Dañosdanosu   DAÑOSu   Gastos médicosgmmu   GASTOS MÉDICOSAutosautosAUTOSVidavidaVIDA)
rM   rj   r   firstr   r  r   r   get_by_labelcount)r.  r%   estaVigenter   elemento_vigentes        r^   obtenRamoPorItemYEstatusr    s      	a>??EKKMMMMMMMMM(3399;;;;;;;;;:;;AACCCCCCCCC:;;@@OOOOOOOOO 	9%%++---------a(3399;;;;;;;;;+	$ ,,Zi,HHNNPPPPPPPPKZh77==????????!CCDDz99??AAAAAAAAAEEDDz0ABBHHJJJJJJJJQNNDDz0ABBHHJJJJJJJJQNNDDz88>>@@@@@@@@1DDDDz88>>@@@@@@@@1DDDDz77==????????!CCDDz77==????????!CCD	{	r_   c                 ~  K   |dd          }t          d|           t          j        d           d {V  	 |dk    rt          j        d           n"|dk    rvt          j        d           d {V  |                     d           d {V  | j                            d	           d {V  | j                            |           d {V  n|d d          d
|dd           }t          j        d           d {V  |                     d           d {V  t          j        d           d {V  | j                            d	           d {V  | j                            |           d {V  | 	                    d                                           d {V  t          j        d           d {V  d S )Nz	ULTIMOS 4r   r*   r   r  r!   ztext="AXA Folio Unico"Tab-u   text="AXA Número de recibo"r  )
rA   rM   rj   r   r   r   keyboardpressr-   r  )r.  r   r&   ultimos_cuatros       r^   escribirNumeroReciboPorRamor    sB      %.^$$$a 
RZZHQKKKKu}}
-


++.
/
////////
.

u
%
%%%%%%%%
.

n
-
---------%bqb)@@N122,>@@M
-


++4
5
55555555
-


.

u
%
%%%%%%%%
.

m
,
,,,,,,,, 	9%%++---------ar_   Fc                 j  K   d}d}d}d}t          d|d         |d         d         |d         d         d           d {V }|d         dk    r|d	u rt          i |d
ddd|d         d         |d         d         |d         |d         dd           d {V  t          d|d         i           d {V  t          |d         d         dd           d {V  n>t	          | |d         t
           |d          d|d         d          d           d {V }|S dS |                     d           d {V  |                     d           d {V }	 t          d| |           d {V  d}	|	
rt          d|d         i           d {V  |                     d           d {V  | 	                    d          
                                 d {V }
|                     d          
                                 d {V }|
dk    rM|dk    rG|                     d                                           d {V  t          j        d           d {V  |                     dd                                            d {V  |                     d!d"                                            d {V  t          j        d#           d {V  |                                 4 d {V }|                     d$d%                               d                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                    d&                                           d {V  |                    d&                              d'           d {V  t+          ||d         d                    d {V \  }}d(}t          j        d)           d {V  t          j        d           d {V  |	                    d*          j                                         d {V  |j                            d+           d {V  |j                            |d         d                    d {V  |                    d,           d {V }|d	k    rw|                    d-                                           d {V  t          j        d           d {V  |                    d.d-                               dd/                                           d {V  |                    d.d-                               dd/                              d0           d {V  t          j        d           d {V  |                    d1d2                                            d {V  t          j        d           d {V  |                    d.d-                               dd/                                           d {V  t9          d3|d                    d4|d         v r$t;          |||d         d4                    d {V  n#t;          |||d         d                    d {V  d4|d         v rd5}|d5k    r|                                4 d {V }	 |                    d6|           j                                         d {V  |j         d {V }|d          d|d         d          d}t
           | }|}|                     |           d {V  tC          t
           |           }|d	u r tE          t
           | |           d {V }n tE          t
           | |d	           d {V }tG          d7|d         |d         d         |d         d         ||d8           d {V  n'# tH          $ r}t9          d9|           Y d }~nd }~ww xY wd d d           d {V  n# 1 d {V swxY w Y   n|                    d6|           j                                         d {V  t          j        d           d {V  |                    d:                                           d {V  |                                4 d {V }	 |                    d;                                           d {V  |j         d {V }|d          d|d         d          d}t
           | }|}|                     |           d {V  tC          t
           |           }|d	u r tE          t
           | |           d {V }n tE          t
           | |d	           d {V }tG          d7|d         |d         d         |d         d         ||d8           d {V  n'# tH          $ r}t9          d9|           Y d }~nd }~ww xY wd d d           d {V  n# 1 d {V swxY w Y   |d	u r|                    d6|           j                                         d {V  t          j        d           d {V  |                    d<          j                                         d {V  |                                4 d {V }	 |                    d;                                           d {V  |j         d {V }|d          d=|d         d          d}t
           | }|                     |           d {V  tE          t
           | |           d {V }n'# tH          $ r}t9          d9|           Y d }~nd }~ww xY wd d d           d {V  n# 1 d {V swxY w Y   t          i |d>ddd|d         d         |d         d         ||d?d           d {V  t          d|d         i           d {V  t          |d         d         dd           d {V  |%                                 d {V  |S )@Nr*   r$   r   r9   r%   r&   r'   r+   Fr,   r   Tr-   r)   r.   r1   r   r6   r7   r8   r   	_recibos_r  rd   re   r_  z#confirm-savez[X]r   r}   r%  r   r&  r'  r   r   r  z
Filtrar...z	firma axaAGENTEr!   r  r  uK   div[ec-form-element="group"][ec-padding=""] >> text="AXA Número de recibo"u   Añadir y quitar camposmain)exactu   axa número deoptionu   AXA Número de recibozAVVANZANDO:axa_recibo_cobranzaPAGOSr  r;  )r(   r   r%   r&   r  ro   r   zCFDI40_CORE/LISTADO_REFERENCIASr   CFDI40_CORE	_factura_zRecibos y facturas disponibles)r(   r-   r%   nombre_facturar0   )&rI   rJ   r>   rK   descargarReciboParaWhatsappr   ri   rk   rs   r   r  get_by_textr   rM   rj   r   r  r+  r   r   r   r  r  r  r  r-   r   r  rA   r  r   dblclickr   r  r  r  r   r  )r   r
   enviarPorWhatsappr   r  r  rutaArchivoReciboWhatsapprW   rq   rp   
existModalexistXr-  r.  r   estadotipoDocumentoDescargableelemento_exister   r   nombreRecibopeso_archivo_recibor   nombreFacturaruta_archivo_s3_facturas                            r^   r#   r#   $  s5     + 
 1&QUVcQdw{  }G  xH  IX  xY  lp  q{  l|  }L  lM  2O  2O  P  P  P  P  P  P  P  Pl#r))E!!  ZT  Z3N]^qu  MO  Y]  ^h  Yi  jp  Yq  DH  IS  DT  Ud  De  O  P\  ]  wG  HT  wU  DX  DX  Z  Z  Z  [  [  [  [  [  [  [  [  [$
D4D&FHHHHHHHHH$tJ/?/FR]&_&_aaaaaaaaaa5d<L\<Z_j  ]nlpqzl{  ]n  ]n  GK  LV  GW  Xg  Gh  ]n  ]n  ]n  o  o  o  o  o  o  o  ok2

"
"=
1
11111111}}%ABBBBBBBBJ   VX\^b
c
cccccccc Lf$
D4D&FHHHHHHHHH$$]333333333 o66<<>>>>>>>>j))%006688888888f	aFQJJu%%++---------mA XJ77==?????????Zo>>DDFFFFFFFFFM!""$$ ^ ^ ^ ^ ^ ^ ^
v,MNNRRSTUU[[]]]]]]]]]^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^$$$$$$$e $$\2288:::::::::$$\2277DDDDDDDDD 4E4
;KO;\]]]]]]]]ldF!) M!M!MMBCCIOOQQQQQQQQQN  '''''''''NZ 0 ABBBBBBBBB#../|}}}}}}}}o	E	!	!  !:;;AACCCCCCCCCmA-FGGTTUW_cTddjjlllllllll-FGGTTUW_cTddiijz{{{{{{{{{mA/FGGMMOOOOOOOOOmA-FGGTTUW_cTddjjlllllllllM4
+,,,	$z"2	2	2)%tJ7GH]7^__________)%tJ7G7XYYYYYYYYY 
$z"2	2	2#*  
"W	,	,((** 	 	 	 	 	 	 	m##J5M#NNT]]_________*0000000H"9o__Z8H8Y___L(8,88K(3%"";/////////"9[:X,:X:X"Y"Y E))-<=[\=[=[]i-j-j'j'j'j'j'j'j$$-<=[\=[=[]ikp-q-q'q'q'q'q'q'q$$}BUhlmwhx  zI  iJ  ]a  bl  ]m  n}  ]~  H[  dz  !|  !|  }  }  }  }  }  }  }  }  }  }   '1!	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	& 
1IJJPYY[[[[[[[[[mA ABBHHJJJJJJJJJ((** 	 	 	 	 	 	 	m$$[1177999999999*0000000H"9o__Z8H8Y___L(8,88K(3%"";/////////"9[:X,:X:X"Y"Y E))-<=[\=[=[]i-j-j'j'j'j'j'j'j$$-<=[\=[=[]ikp-q-q'q'q'q'q'q'q$$}BUhlmwhx  zI  iJ  ]a  bl  ]m  n}  ]~  H[  dz  !|  !|  }  }  }  }  }  }  }  }  }  }   '1%	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	* %%!!*3K!LLR[[]]
]
]
]
]
]
]
]a  
 
 
 
 
 
 
 !!-006<<>>
>
>
>
>
>
>
>**,,               &&{3399;;;;;;;;;,2222222h!%ibb4
;KO;\bbbm*;M;;k$$[111111111.=>]m>]>]_l.m.m(m(m(m(m(m(m%       GQ                                                      &   N  N7Wfgz~  VX  bf  gq  br  sy  bz  MQ  R\  M]  ^m  Mn  BY  sI  ML  ML  N  N  N  O  O  O  O  O  O  O  O  O(JZ8H*JLL
L
L
L
L
L
L
L(4
3CE3JVa*c*cee
e
e
e
e
e
e
e 		""s   'AL<<
M	M;`=D_`
_;!_61`6_;;`
``8h:Dgh
g1g,'h,g11h
hh6n8Bmn
m6m1,n1m66n
nnc                   K   |                      d           d {V  d}t          |ddd          }|                                }|j        dk    rt	          |j                  |d         d	          d
|d         d          d|d         d          d}d|d          }|                    ||          }	d}
t          j        |
 |d          d|d         d          d          }|                                 d|d          d|d         d          d}t          |d          5 }|
                    |j                   d d d            n# 1 swxY w Y   |                    ||dd           t          j        |           d}
t          j        |
 |d          d|d         d          d          }|                                 d|d          d|d         d          d}t          |d          5 }|
                    |j                   d d d            n# 1 swxY w Y   |                    ||dd           t          j        |           	 |                                 d S # t          $ r}t!          d|           Y d }~d S d }~ww xY w)Nrd   testfirefoxFi N  )r   r   headless	autoClose	CONNECTEDr]   r9  z', te informamos que tu recibo de pago: r;  uR    ya venció, te invitamos a que realices el pago correspondiente por el monto de: r   z@. Si ya pagaste favor de confirmar con el *comprobante de pago.*521whatsappzFhttps://wsoft1.s3.us-east-1.amazonaws.com/segurocotizas/automatizador/r   r  r9   r%   r  z./r  zRECIBOS.pdfr*   r  z
POLIZA.pdfzERROR CLIENT)ri   r   startstater   sendTextrequestsr<   raise_for_statusr  r  contentsendFilerC   rF   r  rA   )r   r
   rd  r   your_session_namecreatorclientrx   phone_numberresultro   	respuestaruta_destinorY  r   s                  r^   notificarAClienteRecibor    s       /////////,i%[`aaa'==??& ]k!!gm$$$	*  _  _S[\bScdlSm  _  _  BJ  KQ  BR  S\  B]  _  _  _'-x
+--, ??<11& 	Q#lcd4	?ddT*=Mo=^dddee) Xd9oWWZ0@0QWWW,L$ %7MM)#$$$% % % % % % % % % % % % % % % 	//,mR@@@)L 	Q#lcc4	?ccD<L_<]cccdd) Wd9oVVtJ/?/PVVV,L$ %7MM)#$$$% % % % % % % % % % % % % % % 	//,lB???)L
LLNNNNN	   	.!s<   %EEE2HH HI' '
J1JJc                 T   K   	 t          |d         d         dd           d{V  dS )ur  
  1) Verificar si existe carátula, si no obtenerla
  2) Verificar si existe recibo de cobro, si no obtenerlo
  3) Verificar si ya simulamos los recibos
    3.1) Si no existen los recibos obtener: [prima neta, fpago, f_recibo] y enviar
  4) Verificar si ya tenemos los datos actualizados del cliente
    4.1) En caso de no tener los datos extraerlos de la carátula 
  r9   r6   r7   r8   N)rK   )r   r
   s     r^   obtenerDatosClienter    sE      < 	!4
+;E+Bk"["[]]]]]]]]]]]r_   )F))rM   rC   r   rT  r  r  r   jsonr   r   WPP_Whatsappr   utilslectoresr   pyexcelr   magicr   rm   rQ   rs   rn   r   r   r   r  r  r/  r3  r,  rZ  r]  re  r~  r"   r  r  r#   r  r   r_   r^   <module>r     s   9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 ( ( ( ( ( ( ( (                         xV++H+[cg cg cgL  23 3 3j` ` `(> > >BD^ D^ D^R2 2 2j1^ 1^ 1^j+` +` +`d  6^ 6^ 6^vBu Bu BuH  $XG XG XGtTr Tr TrL?Z ?Z ?ZB' ' 'T# # #Lp# p# p# p#f2 2 2l(^ (^ (^ (^ (^r_   