
    Rhǐ                         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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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/a  https://chubbnetlogin.chubblatinamerica.com/Acceso/Login.aspx?ReturnUrl=%2facceso%2f%3fwa%3dwsignin1.0%26wtrealm%3dhttps%253a%252f%252fwww.chubbnet.com%26wctx%3drm%253d0%2526id%253dpassive%2526ru%253d%25252f%26wct%3d2025-02-25T17%253a24%253a55Z%26whr%3d53&wa=wsignin1.0&wtrealm=https%3a%2f%2fwww.chubbnet.com&wctx=rm%3d0%26id%3dpassive%26ru%3d%252f&wct=2025-02-25T17%3a24%3a55Z&whr=535https://www9.abaseguros.com/ChubbReportes/?color=bluezhttps://www.chubbnet.com/zA/var/www/wsoft.com.mx/carteraplus-automatizador/json_migraciones/c                   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    r|d         }|d          }
d|
 d}t          j        	                    |          rOt          j                    }t          j                            |          }||z
  dk    rt          j
        |           t          ||
           d {V \  }}}t          d
|d
         i           d {V  |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t%          ||           d {V  t          |          dk    rWt          |	          dk    rFt          |d
         dd           d {V  t'          |d
         |d         d            d {V  d S d S d S )!N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ocultarNavegadoriX  subtareaerr_f	terminador   r   )getactualizarStatusTareaactualizarConteoUsoTareaobtenerDatosConexionorganizaSubtareasprintlenospathexistsremove actualizarStatusNavegadorAbiertotimegetmtimeinicializarPlaywrightglobalscallableejecutarProcesosChubbcerrarPlaywrightactualizarFechaLogin)
parametrosr   r   r   r   r   r   r   subtareasNavegadorsubtareasWhatsappr   r!   session_filetiempo_actualmodificacion_session_fileitemr   s                    ?/var/www/wsoft.com.mx/carteraplus-automatizador/python/chubb.pyr7   r7      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2G222l		%	% "	$&G$4$4\$B$B!44s:: )L
!
!
!45EwOOOOOOOOa$ %
D4D&FHHHHHHHHH" f f		d9o..g	'		 fZgdD!!!!!!!!!!.d:>NZa0b0beeeeeeeeee&.lJz%*J!"%&JsO%,Jy%)Jv


+
+++++++++
*$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   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   mensajer	   r   r%   u   ¡Sesión validada con éxito!r"   _idr$   rF   r   zDatos incorrectos)enviarMensajevalidar_inicio_sesionr9   actualizarStatusSubtarea)r   r   continuaOperacions      rA   r   r   q   s       D  DT-EX  fB  D  D  D  	E  	E  E  E  E  E  E  E  E12ikoquvvvvvvvv `
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[$]$]
_
__________rB   c                    K   d}|                     | d           d {V  |j        }d|v r4t          ||           d {V }|r|                     |            d {V  nd}|S )NTi timeoutz=https://chubbnetlogin.chubblatinamerica.com/Acceso/Login.aspx)gotourliniciar_sesion)rP   r   r   rK   
url_actualsesion_iniciadas         rA   rI   rI   ~   s      		#f	%%%%%%%%%x*D
RR*466666666O IIcNN	rB   c                   K   d}|d         }|d         d         }|d         d         }t           j                            d| d          rt          j        d| d           	 |}|}|                     d          }|                     d	          }|                     d
d          }	d}
|                                 d {V  |                    |           d {V  |                                 d {V  |                    |           d {V  	 t          j	        d           d {V  |	                                 d {V  | 
                    dd           d {V  d}
n+# t          $ r}t          d|            d}
Y d }~nd }~ww xY w|
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           n|                     d           d {V }|                    t(                    d k    rqt+          |d         d!d           d {V  t-          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}	 | j                            d| d'           d {V  n# t          $ r}d}Y d }~nd }~ww xY w|S ))NFr   r   campo1campo2r   r   z#MainContent_txtCorreoz#MainContent_txtContraseniabuttonAceptarnamer   z##application-messages .alert-dangeri  rM   TzNo sale el modal de error: 	id_accesor   clave_agenteidentificadorsublicencia)r[   r   r\   r]   r^   r"   rF   err_sessionrG   r   r   () => window.location.href	err_loginzERROR DE INICIO DE SESION.r   loginMessage	conectado )rd   statusLogin)r.   )rd   re   saveSession)r-   r.   r/   r0   locatorget_by_roleclickfillasynciosleepwait_for_selector	Exceptionr+   notificarErrorSesionrJ   r'   sysexitevaluatefindurlLoginr1   rH   contextstorage_state)r   r   sesionIniciadar   clavepasswordusuarioinput_usuarioinput_passwordboton_inicioerror_sesionenotificacionrR   errors                  rA   rQ   rQ      s:     .&''1%'1( W^^1711122 -I+W+++,,,0G!H&>??M&CDDN))()CCL L







W
%
%%%%%%%%



 
        


h
'
''''''''M!         ""#HRV"WWWWWWWWWll   -!--...llllll t/tN?ST_?`nrs}n~  QU  Vd  Qe  ft  Qu  HL  M[  H\  ]l  Hm  ~B  CQ  ~R  S`  ~a  1d  1d  e  e  e  e  e  e  e  el$tJ/?/FR_&a&accccccccc!j1A]#[#[]]]]]]]]]	hqkkkk'CDDDDDDDDj		"	"R	'	'.d:>NZe0f0fiiiiiiiiiete5RabeeefffffffffmALtLRLLLMMMMMMMMMM l((.KW.K.K.K(LLLLLLLLL^t^RaX\^^^_________ ,
$
$*G*G*G*G
$
H
HHHHHHHHH	   NNNNNN 
sE   %B1M AE+ *M +
F5F	M FGM 
M-!M((M-c                 J  K   t          |d         d         dd           d {V  |                     dd          }|                     d          }|                     d	d
          }|                     d          }t          t          | |           d {V }|r|                                 d {V  |                     d           d {V  |                    d           d {V  |                                 d {V  |                                 4 d {V }|                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j	         d {V }	 t           |d          d}	|                    |	           d {V  t          ||	           d {V  t          |d         d         dd           d {V  nM# t          $ r@}
t          d|
            t          |d         d         dd           d {V  Y d }
~
nd }
~
ww xY wdS )Nr"   rF   iniciadorG   link
ProduccionrY   z#aniorW   	Consultar#DownloadExcelnetworkidle2025r   z_cartera_pagada.xlsxr$   Error: r#   T)rJ   rj   ri   rI   URL_PROCESOrk   wait_for_load_stateselect_optionexpect_downloadvalueRUTA_FOLDERsave_asleerExcelPagadasrp   r+   )r   r   link_produccionseleccionar_anioboton_consultaboton_descargarrK   download_infodownloadrutaArchivor   s              rA   exportarReportePagadasr      sg      4
+;E+Bj"Z"Z\\\\\\\\\$$V$>>/\\'**##H+#>>.LL!122/1+tTJJJJJJJJ ^



!
!!!!!!!!

"
"=
1
11111111

(
(
0
00000000



 
        ##%% $ $ $ $ $ $ $!!#########$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $"(((((((H^"IDOIIIk[)))))))))T;/////////$tJ/?/FR]&_&_aaaaaaaaaa ^ ^ ^e$tJ/?/FRY&[&[]]]]]]]]]]]]]]^ 
s+   "E
EE.A'G 
H  6HH c                 ~  K   t          d| d         i           d {V  	 t                              |d           }d }|                                D ]"\  }}t	          d |D                       r|} n#|t          d          |j        |         |_        |j        |dz   d                              d          }g }|                                D ]\  }}|	                                
                                r,d|j        d	         |j        d
         | d         d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         d}d |                                D             }|                    |           |st          d          t          | d         d|id           d {V  t          | d         d         dd           d {V  n)# t
          $ r}	t          d|	            Y d }	~	nd }	~	ww xY wdS )Nr   headerc              3      K   | ]C}t          |t                    o)|                                                                d k    V  DdS u   línea de negocioN
isinstancestrstriplower.0cells     rA   	<genexpr>z#leerExcelPagadas.<locals>.<genexpr>   L      ccW[Zc""Rtzz||'9'9';';?R'RccccccrB   u3   No se encontró la cabecera con 'Línea de Negocio'r   TdropCHUBB   r   r   r\   r               )companianumero_polizamesr\   ramoendosofecha_vigencia
fecha_pagofecha_emisionprima_totalimportenombre_aseguradoc                 l    i | ]1\  }}|t                               |          rt          |          nd 2S rf   pdnotnar   r   rz   valors      rA   
<dictcomp>z$leerExcelPagadas.<locals>.<dictcomp>  7    ddd<5%%rxx>UBdddrB   z$No se encontraron datos para guardarr   arrChubbPagadasr   reportesr"   rF   r$   rG      ❌ Error: )r(   r   
read_exceliterrowsanyrp   iloccolumnsreset_indexisnullallitemsappendregistrarRecibosrJ   r+   )
r   r   df
header_rowirowdatos_registror   s
             rA   r   r      s      JZ0@"BDDDDDDDDD2	{4	0	0BJ++--  3	cc_bccc	c	c 
 KLLL$BJ	a	!	-	-4	-	8	8BE++--  3					  !x{^,^<(1+(1+hqk!x{8A;HQK h  edS[SaSaScScdddhll8 ><=== T--@PachNjll
n
nnnnnnnn
"T*-=e-DP[$]$]
_
_________	   	


 
s   G2H 
H:H55H:c                 D  K   |                      dd          }|                     d          }|                      dd          }|                     d          }t          t          | |           d {V }|r|                                 d {V  |                     d           d {V  |                    |d	         d
          d           d {V  |                                 d {V  |                                 4 d {V }|                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }	 t           |d          d}	|
                    |	           d {V  t          d|	            t          |d         d         dd           d {V  t          ||	           d {V  nM# t          $ r@}
t          d|
            t          |d         d         dd           d {V  Y d }
~
nd }
~
ww xY wdS )Nr   zCobranza VencidarY   #agenterW   r   r   r   r   r\   ,1r   z_cartera_vencidas.xlsxDescargado: r"   rF   r$   rG   r   r#   T)rj   ri   rI   r   rk   r   r   r   r   r   r   r+   rJ   leerExcelVencidasrp   )r   r   link_vencidaseleccionar_agenteboton_consultarr   rK   r   r   r   r   s              rA   exportarReporteVencidosr   1  s`     !!&1C!DD,||I..$$X;$??/LL!122/1+tTJJJJJJJJ ^






"
"=
1
11111111

*
*d>.B>.R+V+V+V
W
WWWWWWWW



!
!!!!!!!!##%% $ $ $ $ $ $ $!!#########$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $"(((((((H^"KDOKKKk[)))))))))(;(()))$tJ/?/FR]&_&_aaaaaaaaadK0000000000 ^ ^ ^e$tJ/?/FRY&[&[]]]]]]]]]]]]]]^ 
s+   D::
EEA9G 
H6HHc                   K   t          |d         d         dd           d {V  |                     dd          }|                     d          }|                     d	          }|                     d
d          }|                     d          }t          t          | |           d {V }|rt          d           |                     d           d {V  t          j        d           d {V  |	                                 d {V  |                     d           d {V  |                     d          
                    |d         d          d           d {V  t          j        d           d {V  |                     d	          
                    d           d {V  t          j        d           d {V  |	                                 d {V  t          j        d           d {V  |	                                 d {V  t          j        d           d {V  |                                 4 d {V }t          d           |	                                 d {V  |j         d {V }	t          d|d         i           d {V  t          d           	 t          d           t           |d          d}
|	                    |
           d {V  t          d|
            t!          ||
           d {V  t#          | |           d {V  nM# 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  n# 1 d {V swxY w Y   n$t          |d         d         dd           d {V  dS ) Nr"   rF   r   rG   r   zCobranza por vencerrY   r   z#diasrW   r   r   zEntra por pagarr   r   r   r\   r   r   30zEsperando descarga...r   zDescarga completadazDescargando archivo...r   z_cartera_porpagar.xlsxr   r   r#   r_   T)rJ   rj   ri   rI   r   r+   r   rm   rn   rk   r   r   r   r(   r   r   leerExcelPorPagarr   rp   )r   r   link_por_vencerr   diasr   r   rK   r   r   r   r   s               rA   exportarReportePorPagarr   N  s|      4
+;E+Bj"Z"Z\\\\\\\\\$$V1F$GG/||I..	g		$$$X;$??/LL!122/1+tTJJJJJJJJ !b	


"
"=
1
11111111
-





!
!!!!!!!!

"
"=
1
11111111
,,y
!
!
/
/43G3W0[0[0[
\
\\\\\\\\
-


,,w


-
-d
3
33333333
-


**,,
-





!
!!!!!!!!
-

##%% ` ` ` ` ` ` `#$$$!!#########$*******h$
D4D&FHHHHHHHHH!"""	`&'''$Md9oMMM{+++++++++*[**+++k222222222%dD1111111111 ` ` `   &j1A%1HT[(](]______________`` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `" #T*-=e-DP]$_$_
a
aaaaaaaa	s>   A#N1A:L,+N,
M666M1,N1M66N
NNc                 ^  K   t          d| d         i           d {V  	 t                              |d           }d }|                                D ]"\  }}t	          d |D                       r|} n#|t          d          |j        |         |_        |j        |dz   d                              d          }g }|                                D ];\  }}|	                                
                                r-i dd	d
|j        d         d| d         d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        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( |                                D             }|                    |           =d)d*|ii}	t          t           d+| d,          d-|	           d {V  t          | d.         d*|id/           d {V  t!          | d0         d1         d2d3           d {V  n)# t
          $ r}
t#          d4|
            Y d }
~
nd }
~
ww xY wdS )5Nr   r   c              3      K   | ]C}t          |t                    o)|                                                                d k    V  DdS r   r   r   s     rA   r   z$leerExcelPorPagar.<locals>.<genexpr>  r   rB   7   ❌ No se encontró la cabecera con 'Línea de Negocio'r   Tr   r   r   r   r   r\   r   linea_negocior   conductoestatus_endosor   r   r   numero_incisor   serie   frecuencia_pagorf   r   r   fecha_limite_pagor   r   	   r      r   moneda   r      c                 l    i | ]1\  }}|t                               |          rt          |          nd 2S r   r   r   s      rA   r   z%leerExcelPorPagar.<locals>.<dictcomp>  r   rB   r   arrChubbPorPagar/r   z_chubb_porpagar.jsonr   r   r"   rF   r$   rG   r   )r(   r   r   r   r   rp   r   r   r   r   r   r   r   guardarReporteSubidaRUTA_FOLDER_JSONr   rJ   r+   r   r   r   r   r   r   r   r   r   _jsonr   s              rA   r   r   }  s      JZ0@"BDDDDDDDDD5	{4	0	0BJ++--  3	cc_bccc	c	c 
 OPPP$BJ	a	!	-	-4	-	8	8BE++--  3					 G! 	^,^< 	!	
 	CHQK 	#(1+ 	#(1+ 	! 	! 	2 	#(1+ 	SXa[ 	! 	sx| 	38B<  	#(2,!" 	CHRL#h* edS[SaSaScScdddhll8.79E
"2ZZT)_ZZZ\a
b
bbbbbbbb
T--@PbdiNkmm
o
oooooooo
"T*-=e-DP[$]$]
_
_________ 
   !	s   I"J 
J*J%%J*c                   K   t          d| d         i           d {V  	 t                              |d           }d }|                                D ]"\  }}t	          d |D                       r|} n#|t          d          |j        |         |_        |j        |dz   d                              d          }g }|                                D ]\  }}|	                                
                                r-dt                              |j        d	                   r|j        d	         nd
| d         d         t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |d                   r|d         nd
d
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
t                              |j        d                   r|j        d         nd
d}d |                                D             }|                    |           dd|ii}	t          t           d| d          d|	           d {V  t!          | d         d|id           d {V  t#          | d         d          d!d"           d {V  n)# t
          $ r}
t%          d#|
            Y d }
~
nd }
~
ww xY wdS )$Nr   r   c              3      K   | ]C}t          |t                    o)|                                                                d k    V  DdS r   r   r   s     rA   r   z$leerExcelVencidas.<locals>.<genexpr>  r   rB   r   r   Tr   r   r   rf   r   r\   r   r   r   r   Serier   r   r   r   )r   r   r\   r   r   r   r   r   r   r   r   r   r   r   r   c                 l    i | ]1\  }}|t                               |          rt          |          nd 2S r   r   r   s      rA   r   z%leerExcelVencidas.<locals>.<dictcomp>  r   rB   r   arrChubbVencidasr   r   z_chubb_vencidas.jsonr   r   r"   rF   r$   rG   r   )r(   r   r   r   r   rp   r   r   r   r   r   r   r   r   r   r  r   rJ   r+   r  s              rA   r   r     s(      JZ0@"BDDDDDDDDD4	{4	0	0BJ++--  3	cc_bccc	c	c 
 OPPP$BJ	a	!	-	-4	-	8	8BE++--  3					  (*!(=(=E!2^,^<(*!(=(=E!2#%88CHQK#8#8@CHQKKb)+#(1+)>)>F#(1++B!##(1+!6!6>#(1++B(*!(=(=E!2!##g,!7!7?WR,.HHSXa[,A,AISXa[[r')xx'='=Esx||2#%88CHRL#9#9A38B<<r"$((38B<"8"8@#(2,,b,.HHSXb\,B,BJCHRLL! h( edS[SaSaScScdddhll8.79E
"2ZZT)_ZZZ\a
b
bbbbbbbb
T--@PbdiNkmm
o
oooooooo
"T*-=e-DP[$]$]
_
_________ 
   ! 
s   O3P 
P;P66P;Fc                 ^  K   t          |d         d         dd           d {V  t          i |ddd           d {V  d}d}d}d}t          |d         d         dd           d {V  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u rt          d| |           d {V }|r|                     d           d {V }	|	rk|                     d           d {V  	 | 	                    d           d {V }
|
r|

                                 d {V  n# t          $ r
}Y d }~nd }~ww xY w| }|                    d          
                                 d {V  |                    d                              |d         d                                                     d {V  |                    d                              d            d {V  	 |                    d!d"|d         d          d#$                              d%          
                    d&'           d {V  |d          d(|d         d          d}|                    d)d&'           d {V  |                    d&'          4 d {V }|                    d)          
                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                    d*d&'           d {V  t-          d+           t/          j        d           d {V  t3          d,          D ]<}|j                            d-           d {V  t/          j        d.           d {V  =|j                            d            d {V  |                                4 d {V }|j         d {V }d d d           d {V  n# 1 d {V swxY w Y   	 |d          d(|d         d          d}t
           | }|                    |           d {V  t;          t
           |           }|du r t=          t
           | |           d {V }n t=          t
           | |d           d {V }t?          d/|d
         |d         d         ||d0           d {V  t-          d1|            t/          j        d           d {V  n'# t          $ r}t-          d2|           Y d }~nd }~ww xY w|                                  d {V  n&# t          $ r}t-          d3           Y d }~nd }~ww xY wt          d4| |           d {V }|                     d           d {V }	|                     d5d6$          }|                     d5d7$          }|                     d5d8$          }|r|	rk|                     d           d {V  	 | 	                    d           d {V }
|
r|

                                 d {V  n# t          $ r
}Y d }~nd }~ww xY w| }|                    d9          !                    d:           d {V  |"                    d;          
                                 d {V  |d         d         #                    d<d          }t-          d=|            |"                    d;                              |            d {V  |                    d>          !                    |d?         d@                    d {V  |                    dAdB$          
                                 d {V  	 |                    dC          $                    dDdEF           d {V  |                    dGdHI          }|%                    dE'           d {V r*|&                                 d {V }t-          |            t          |d         d         dd           d {V  dS # t          $ r}|                    dJdDdKF           d {V  |	                    dJ           d {V }|r|'                                 d {V  nt-          dL           |                    dM'          4 d {V }|                    dAdN$          
                                 d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                    dOdDd&F           d {V  t/          j        d           d {V  |                                4 d {V }t3          d,          D ]<}|j                            d-           d {V  t/          j        d.           d {V  =|j                            d            d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|d          d|d         d          d}t
           | }|                    |           d {V  t-          dP|            t;          t
           |           }|du r t=          t
           | |           d {V }n t=          t
           | |d           d {V }t?          dQ|d
         |d         d         ||dR           d {V  t-          d1|            Y d }~nd }~ww xY wt          i |dddd|d         d         |d         d         ||dd           d {V  t          |d         d         dd           d {V  |S )SNr"   rF   r   rG   u   Obteniendo póliza y recibosr   rc   rf   todor   r   numero_recibo)optr   r   r  
url_reciboFu   ¡Documentos disponibles!r   Ttype
url_poliza)r  r  r   nombre_numero_polizanombre_numero_recibo)rd   re   mostrar_datosdescargar   r$   r   	_recibos_.pdfzWhttps://acenet.acelatinamerica.com/Consulta/Consulta/Consultar?color=blue&TipoEntrada=0z[onclick*='closePopBanner']zcdocument.querySelectorAll('div[class*="overlay"], div[class*="modal"]').forEach(el => el.remove());u   Cotización/Póliza/Endoso/Enterr   u	   Póliza: u    CotizaciórY   za:has(img[src*="acciones.png"])i rM   _poliza_z#botonImprimirloadu   ✅ Page recibido correctamenter   Tabg?poliza)r  r   r   sizerP   zArchivo guardado en: zERROR:z5Sin resultados precargados o basados en su solicitud.zChttps://www3.abaseguros.com/Cobranza.Facturacion.Client/?color=bluer   u   Facturación Facturaciónu   Agrupación avisos/facturacionzConsulta Consultaz#droptipoFactura3u   Póliza u	   póliza: z#Agente_BusquedaFacturar   r\   rW   r   z#msjValidacionRecibosvisiblei'  )staterN   zdiv.cellDiv.celda80zrecibos liquidados)has_textz	#checkAlli N  u-   No se encontró el checkbox con id='checkAll'i_ zVista Previabodyr   recibo)r  r   r  r  rP   )(rJ   rH   obtenerPolizaGuardadar(   descargarReciboParaWhatsappr   rI   query_selector_allrt   query_selectorrk   rp   get_by_placeholderrl   r   pressrj   ri   ro   expect_popupr   r   r+   rm   rn   rangekeyboardr   r   obtener_peso_archivo_mbsubirArchivoAS3guardarPolizacloser   get_by_labelreplacewait_for
is_visible
inner_textcheck)r   r   enviarPorWhatsapprutaArchivoRecibor   ruta_archivo_s3_polizaruta_archivo_s3_reciboinfoPolizaServerrK   boton_cerrar_modalelementr   page1nombrePoliza
page_info_page2r   r   r   peso_archivo_polizaexlink_facturacionlink_agrupacionlink_consultar   mensaje_locatortextocheckbox_all
page2_infonombreRecibopeso_archivo_recibos                                  rA   obtenerDocumentoPolizarL    s>      4
+;E+Bj"Z"Z\\\\\\\\\aa/N]^aaabbbbbbbbb+ 4
+;E+Bj"Z"Z\\\\\\\\\ 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 E!! 5  7P  RV  X\  !]  !]  ]  ]  ]  ]  ]  ]	 >#'#:#:;X#Y#YYYYYYY 	  H  I  I  I  I  I  I  I  I  I //0MNNNNNNNNG $MMOO#######   DDDD &&'DEEKKMMMMMMMMM&&'DEEJJdS]N^_nNoNuNuNwNwKyzzzzzzzzz&&'DEEKKGTTTTTTTTT.	!!%.h$z:J?:[.h.h.h!iiqq  sT  U  U  [  [  dj  [  k  k  k  k  k  k  k  k  k O\\T*5Eo5V\\\,''(8&'II
I
I
I
I
I
I
I'''77 : : : : : : ::-- 01177999999999: : : : : : : : : : : : : : : : : : : : : : : : : : : #(((((((%))&&)AA
A
A
A
A
A
A
A
1
2
2
2a  
 
 
 
 
 
 
 88 % %a.&&u----------$$$$$$$$$$$$W--
-
-
-
-
-
-
-**,, 1 1 1 1 1 1 1*0000000H1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1"9o^^tJ7G7X^^^L(8,88K"";/////////"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  Tg  pF  !H  !H  I  I  I  I  I  I  I  I  I7+77888-""""""""""   (A 







 	 	 	
G
H
H
H
$$$$	 44y{  BF  G  G  G  G  G  G  G  G  $667TUUUUUUUU''5P'QQ&&v3S&TTO$$V2E$FFM  A5	 mm  F  G  G  	G  	G  	G  	G  	G  	G  	G	--.KLLLLLLLL' "--//!!!!!!! 	 	 	
$$$$	 eMM,--;;C@@@@@@@@@ y))//111111111:&7??RHHm'''(((y))..-/ABBBBBBBBB MM344BB4CWXfCghhhhhhhhh h[99??AAAAAAAAA&5mm344==IV[=\\\\\\\\\--(=H\-]] ++E+:::::::: 	'2244444444%
5



&j1A%1HT_(a(accccccccct 5 5 5%%kE%RRRRRRRRR"11+>>>>>>>> 	A""$$
$
$
$
$
$
$
$
$
?
@
@
@%%e%44 	I 	I 	I 	I 	I 	I 	I
!!(!@@FFHH
H
H
H
H
H
H
H	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I &&&&&&&%%fIv%NNNNNNNNNmA((** 	. 	. 	. 	. 	. 	. 	.m88 % %a.&&u----------$$$$$$$$$$$$W--
-
-
-
-
-
-
-		. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	.
 ',,,,,,,y/[[D4D_4U[[[$4l44{+++++++++*[**+++56Tl6T6TUU%%)8K9W9W9WYe)f)f#f#f#f#f#f#f
 
 )8K9W9W9WYegl)m)m#m#m#m#m#m#m
 Xd=>Qdhisdt  vE  eF  Pc  lB  D  D  E  E  	E  	E  	E  	E  	E  	E  	E3k3344444444=5@   H4  H1L[\os  KM  W[  \f  Wg  hn  Wo  BF  GQ  BR  Sb  Bc  }S  mC  BF  BF  H  H  H  I  I  I  I  I  I  I  I  I
"T*-=e-DP[$]$]
_
________	s  7H 
H% H%B'X :.N:(X :
OX OCX $S2X 
SX SX C5W X 
W0W+&X +W00X 
X1X,,X17\ 
\\B1c8 8o
Bo0g4o
g	og	A"o6A-j5#o5
j?	?oj?	C=oo
c                   K   |                      d           d {V  d}t          |dddd          }|                                }|j        dk    rt	          |j                  |d	         d
          d|d	         d          d|d	         d          d}d|d          }|                    ||          }		 |                                 d {V  d S )Nr   testfirefoxFr   i  )r   r   headless	autoClosedeviceSyncTimeout	CONNECTEDr@   clientez', 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whatsapp)r   r   startr  rp   sendTextr/  )
r   r   ejecutorr   your_session_namecreatorclientmessagephone_numberresults
             rA   notificarAClienteRecibor`    s8       /////////,i%[\ptuuu'==??& ]k!!gm$$$	*  _  _S[\bScdlSm  _  _  BJ  KQ  BR  S\  B]  _  _  _'-x
+--, ??<11&: 	rB   c           	      (  K   t          d| |           d {V }t          |d         d         dd           d {V  d}|rO|                     d                                           d {V  t	          j        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         i           d {V  | 	                    d           d {V }g }d}d}d}d}d}	|D ]D}
|

                    d           d {V }|
	                    d           d {V }|g d}|D ]}|	                    d           d {V }t          |          dk    r|d                                          d {V pd}|d                                          d {V pd}|                                r2|                                r|d                             ||d           |dk    r|}|dk    r|}|dk    r|}|dk    r|}|dk    r|}	|d         r|                    |           Ft          |          dk    r7g }t	          j        d           d {V  |                     dd                              d          j                                         d {V  t	          j        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 }|j                            |           d {V }t,           |d#          d$|d         d	          d%}t/          |d&          5 }|                    |                                 d {V            d d d            n# 1 swxY w Y   t	          j        d           d {V  |                                 d {V  t          d|d         i           d {V  t7          ||d         d	         |d                    d {V }t9          j        |           nt=          d'           g }|||||	d(}|d)         |d         d*         |d         d+         |d         d	         |d         d,         |||d-}t?          |           d {V }t          |d         d         dd           d {V  d S d S ).NzBhttps://agentes360.qualitas.com.mx/group/guest/consulta-de-polizasr"   rF   r$   rG   Fz#numberPolicyr   r   r  r   r   z .card-body.border-0.p-0.table-oprf   iddiv)rb  r   r   r   r   r   )padrehijozTelefono celular del aseguradoRFCu
   Direcciónu   Póliza anterioru   Póliza renovadar   zAvisos de Cobro pdfDescargarrY   arW   Todosr`   r   _todos_recibos_r  wbu   NO SE ENCONTRÓ ESTA POLIZA)telefonorfc	direccionpoliza_anteriorpoliza_renovadar   r]   
id_clienter  )r   r]   rp  r   r  
comisionesdatos_principalesdatos_adicionales) rI   rJ   ri   rk   rm   rn   rl   r(  r(   r%  get_attributer,   text_contentr   r   rj   firstr)  r   rt   requestr&   r   openwriter!  r/  leerQualitasAutosr-   r0   r+   registrarDatosAutogenerados)r   r   rK   contenedoresr   clienteTelefono
clienteRFCclienteDireccionpolizaAnteriorpolizaRenovada
contenedorid_contenedor
divs_hijosinfo_contenedorrc  parrafostexto_padre
texto_hijodatos_recibos
popup_infonew_pageurl_pdfresponser   frowPrincipaldatosAutogenerados	respuestas                               rA   obtenerDatosClienter    s4     12vx|  C  D  D  D  D  D  D  D  D 4
+;E+Bk"["[]]]]]]]]] q`
,,
'
'
-
-
/
////////
-


,,
'
'
,
,T*-=o-N
O
OOOOOOOO
-


,,
'
'
-
-g
6
66666666
-


"j$z2B$D
F
FFFFFFFF001STTTTTTTTLEOJNN" #& #&
&44T::::::::m $66u========j,r::o ( (#//44444444x==A&qk6688888888>B+%a[5577777777=2*    XZ%5%5%7%7 XG$++k:,V,VWWW ===(OOu$$#JJ|++)111'NN111'N 
	! &_%%%E

QmM! U)GHHPPQTUU[aacccccccccM!""$$ ? ? ? ? ? ? ?
xg66<<>>>>>>>>>? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? "'''''''h''(DEEEEEEEEg'++G44444444h"kDOkkDDTUdDekkkkT"" 'a	hmmoo%%%%%%&&&' ' ' ' ' ' ' ' ' ' ' ' ' ' ' M!NN %
D4D&FHHHHHHHHH-{D<L_<]_cdn_oqqqqqqqqmi)***m "#'' L M*J'8J'5J'8J'8!' 	 	 23EGGGGGGGGI
"T*-=e-DP[$]$]
_
__________cq` q`s$   0N
N),N)).Q##Q'*Q')F)!rm   r-   rr   zipfilepandasrequestsbase64r   r   WPP_Whatsappr   utilslectoresr   r2   r   rv   r   
URL_INICIOr  r7   r   rI   rQ   r   r   r   r   r   r   rL  r`  r   rB   rA   <module>r     s   : : : : : : : : : : : : : : : : : : : : : : : : : : : : ( ( ( ( ( ( ( (                     xV++H+ QE)
V Vg Vg Vgr` ` `  = = =~  :7 7 7r  :- - -^8 8 8t8 8 8vl l l l\. . .dw` w` w` w` w`rB   