
    Ah                     V   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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mZ edk    rdZnd	Zd
Zdadad ada	 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&d Z)	 d! Z*	 d" Z+d# Z,d$ Z-dS )'    N)datetime	timedelta)Create)*)platform)TimeoutErrordarwinzD/Users/wsoft/Documents/wsoft.com.mx/carteraplus-automatizador/files/z6/var/www/wsoft.com.mx/carteraplus-automatizador/files/z1https://www.afirmeseguros.com/cercania360/#/login Tc                   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    r+t          |d
         dd           d {V  |dk    rd|d         }|d          }
t          ||
           d {V \  }}}t          i |ddd           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    rtt          |	          dk    rct          d
|d
         i           d {V  t          |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ocultarNavegadoru   Conexión establecida)loginMessagerefreshsubtareaerr_f_principal	terminador   r   )getactualizarStatusTareaactualizarConteoUsoTareaobtenerDatosConexionorganizaSubtareasprintlenospathexistsremove actualizarStatusNavegadorAbiertoinicializarPlaywrightenviarMensajeglobalscallableejecutarProcesosAfirmecerrarPlaywrightactualizarFechaLogin)
parametrosr   r   r   r   r   r   r   subtareasNavegadorsubtareasWhatsappr   r"   itemr   s                 @/var/www/wsoft.com.mx/carteraplus-automatizador/python/afirme.pyr9   r9      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$ ^T^3JW\^^^_________$
D4D&FHHHHHHHHH" p p		d9o..g	'		 pZgdD!!!!!!!!!!.d:>NZk0l0loooooooooo&.lJz%*J!"%&JsO%,Jy%)Jv
 
,
,,,,,,,,,
*$z:JVa,b,b
e
eeeeeeee	Q(((((((((	
""s+<'='='B'B
"j$z2B$D
F
FFFFFFFF
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                 L  K   d}t          dd          5 }|                                }d d d            n# 1 swxY w Y   d }|j                            d|           d {V  |                    | d           d {V  |                    |           d {V  t          d	|d	         i           d {V  |                    d
           d {V }|                    t                    dk    rt          i |ddd           d {V  t          d	|d	         i           d {V  t          ||           d {V }|r]t          d	|d	         i           d {V  t          |d	         |d         d           d {V  |                    |            d {V  nd}|S )NTz../python/main_afirme.jsrc                    K   d|j         v r|                                  d {V  d S |                                  d {V  d S )NzFhttps://www.afirmeseguros.com/cercania360/main.4637e55806e1410e30ef.js)urlabort	continue_)routerequests     r@   intercept_routez.validar_inicio_sesion.<locals>.intercept_routeu   sf       PSZS^^^KKMMOOrA   z**/*i  timeout)contentr   () => window.location.hrefzINICIANDO SESION...r   r#   	conectador   r(   F)openreadcontextrH   gotoadd_script_tagr+   evaluatefindurlLoginr6   iniciar_sesionr;   )	rE   r   r   continuaOperacionfilescript_contentrJ   
url_actualsesionIniciadas	            r@   validar_inicio_sesionr`   k   s     
 &,, #yy{{n# # # # # # # # # # # # # # #   	6?333333333 			#v	&&&&&&&&&N333333333 	!JZ0@"BDDDDDDDDD ]]#?@@@@@@@@*__X##
Z4Z1GVWZZZ
[
[[[[[[[[
"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IIcNN	s   6::c                 
  K   d}|d         }|d         d         }|d         d         }t           j                            d| d          rt          j        d| d           |                     d                                           d {V  |                     d                              |           d {V  |                     d	                                           d {V  |                     d	                              |           d {V  |                     d
d                                           d {V  |                     d          j	        
                    d           d {V  d}	 |                     d          }|                                 d {V dk    rd}|                                 d {V  nd}n# t          $ r}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           d S t'          j        d           d {V  |                     d           d {V }
|
                    t.                    d k    rSt1          i |d!dd"           d {V  t'          j        d           d {V  t1          i |d#dd"           d {V  nD| j                            d| d$           d {V  t1          i |d#d%dd&           d {V  d}|S )'NFr   r   campo1campo2r   r    Usuariou   ContraseñabuttonEntrarname#loadingDivhiddenstateu   Usuario o password inválidor   T	id_accesor   clave_agenteidentificadorsublicencia)rm   r   rn   ro   rp   r%   _iderr_sessionrq   r   r   r   rN   rO   zERROR DE INICIO DE SESION.rP   r
   )r1   r   )r#   rQ   saveSession)r0   r1   r2   r3   get_by_placeholderclickfillget_by_rolelocatorfirstwait_forget_by_textcount	ExceptionnotificarErrorSesionactualizarStatusSubtarear*   sysexitasynciosleeprW   rX   rY   r6   rT   storage_state)r   r   r_   r   usuariopassworderrorSesionry   enotificacionr^   s              r@   rZ   rZ      s     .&''1''1( W^^1711122 -I+W+++,,, 		**00222222222	**//888888888..44666666666..33H=========1177999999999]##)222BBBBBBBBB+=>>G]]__q  kMMOOk	   KKKKKK 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s    AG 
G)G$$G)c                   K   t          i |d|d         dd           d {V  t          t          | |           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(   u   ¡Sesión validada con éxito!r%   rq   r'   rs   zDatos incorrectos)r6   r`   rY   r;   r   )r   r   r[   s      r@   r   r      s       D  DT-EX  fB  D  D  D  	E  	E  E  E  E  E  E  E  E1(D$GGGGGGGG `
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[$]$]
_
__________rA   c                 4	  K   t          |d         d         dd           d {V  t          i            d {V }t          d|           d |d         D             }t          j                    t          d	          z
  }|                    d
          }t          j                                        d
          }|                     dd          }|                     dd          }|                     dd          }	|                     dd          }
|                     dd          }|                     dd          }|                     d          }|                     dd          }d}t          || |           d {V }|r| 
                    d           d {V  |                                 d {V  t          j        d           d {V  |                                 d {V  t          |          D ]k\  }}t          d|            |	                                 d {V  |                     |                                           d {V  |
                                 d {V  |
                    |           d {V  |                                 d {V  |                    |           d {V  |                                 d {V  t          j        d           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 }|j        }|                    d          d         }t(           | d| }|                    |           d {V  t-          ||           d {V  |                                 d {V  t          j        d           d {V  |	                                 d {V  | j                            d            d {V  | j                            d!           d {V  t          j        d           d {V  mt          |d         d         d"d           d {V  d#S )$Nr%   rq   iniciadors   	respuestac                 4    g | ]}|d           d|d          S )rn   -nombre_agente ).0agentes     r@   
<listcomp>z0exportarReportesSiniestrosVP.<locals>.<listcomp>   s0    cccv~&BB)@BBcccrA   r      )daysz
%-m/%-d/%Ylink
Siniestrosrg   re   zSeguimiento a siniestroscomboboxzSeleccionar al agentetextboxDesdeHastaBuscarzDescargar ExcelLimpiarz6https://www.afirmeseguros.com/cercania360/#/siniestrosnetworkidler   zPROCESANDO AGENTE: r   r   _   z	Control+ADeleter'   T)r   obtenerClavesAgentesVigentesr.   r   todayr   strftimerx   r|   r`   wait_for_load_staterv   r   r   	enumeraterw   expect_downloadvaluesuggested_filenamesplitRUTA_FOLDERsave_asenviarArchivosSiniestrosVPkeyboardpress)r   r   r   agentesfechaDiasAntesfechaIniciofechaFinlinkSiniestrosbotonSeguimientoseleccionar_agentefecha_desdefecha_hastabotonBuscardescargarExcelboton_limpiarURL_SINIESTROSr[   ir   download_infodownloadnombre_sugeridorn   rutaArchivos                           r@   exportarReportesSiniestrosVPr      sA      4
+;E+Bj"Z"Z\\\\\\\\\044444444)YccQZ[aQbccc'~'')*<*<*<<.%..|<<+~''00>>(''\'BB.''7Q'RR''
9P'QQ''	'@@+''	'@@+''x'@@+''(9::.''y'AA-O.2>4NNNNNNNN !

"
"=
1
11111111



 
        
-



 
 
"
""""""""w''  	6*&**+++$$&&&&&&&&&V$$**,,,,,,,,,[)))))))))X&&&&&&&&&M!%%'' % % % % % % %=""$$$$$$$$$% % % % % % % % % % % % % % % % % % % % % % % % % % % !. 3333333h"5o ,,s++A.l(J,JJJJk[)))))))))&{LAAAAAAAAA!!!!!!!!!M!$$&&&&&&&&&M,,,,,,,,,M)))))))))M! 4
+;E+Bk"["[]]]]]]]]]	s   M
M	M	c                 f  K   d| }	 t          | d          5 }dt          j                            |           |fi}t	          j        ||          }d d d            n# 1 swxY w Y   |j        dk    r^t          d|             	 |                                }t          d|           dS # t          $ r t          d	|j
                   Y n4w xY wt          d
|  d|j         d           t          d|j
                   n-# t          $ r }t          d|  d| d           Y d }~nd }~ww xY wdS )Nz]https://vpsiniestros.wsoft.com.mx/REST/Controller.php?opt=uploadExcelSiniestros&clave_agente=rbr\   )files   u    ✅ Archivo enviado con éxito: u#   🧾 Respuesta del servidor (JSON):Tu$   🧾 Respuesta del servidor (texto):u"   ⚠️ Error al enviar el archivo u   . Código: z. Reintentando...u   💬 Respuesta del servidor:zError al enviar el archivo z: )rR   r0   r1   basenamerequestspoststatus_coder.   json
ValueErrortextr~   )r   rn   URL_UPLOAD_VP_SINIESTROarchivoarchivosr   respuesta_jsonr   s           r@   r   r     s      K  }I  K  KM	{4	 	  JG27++K88ABh- 7IIIiJ J J J J J J J J J J J J J J ##<{<<===F"))3^DDDt F F F4inEEEEEF qqqI^qqqrrr*IN;;;	 M M M	
K
K
Kq
K
K
KLLLLLLLLM	sX   D :AD A##D &A#' D $B. .CD C3D 
D.D))D.c                 N  K   t          d           t          dd          \  }}}t          |d         d         dd           d {V  t          d| |           d {V }|rt	          d	|d	         i           d {V  t          i |d
dd           d {V  t          d| d|            |                     d                                           d {V  t          j	        d           d {V  | 
                    d                                           d {V  | 
                    d                              |           d {V  | 
                    d                                           d {V  | 
                    d                              |           d {V  |                     d                              d                                           d {V  |                     d                                           d {V  t          j	        d           d {V  |                     dd                                           d {V  	 |                     ddd           d {V  |                     d                                           d {V }|rt"          dz   at"          dk    r%t          |d         d         dd           d {V  nK|                                  d {V  |                     d            d {V  t)          | |           d {V  	 |                     d!d"#          }|                    d$%           d {V  |                                 d {V }d"|v r5t          |d         d         d&d           d {V  t          d'           d(S n# t.          $ r t          d)           Y nw xY w|                     d                                           d {V }	|	d*k    rE|                                 4 d {V }
|                     dd+                              d,%           d {V  	 |
j         d {V }t6           d-|d.          d/}|                    |           d {V  t          d0           t;          ||           d {V  t          d1           t          |d         d         d&d           d {V  dan;# t.          $ r.}t          |d         d         d2d           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   d S d S t          d3           t          |d         d         d&d           d {V  d S # t<          $ r t"          dz   at"          d4k    r't          |d         d         dd           d {V  Y d S |                                  d {V  |                     d            d {V  t)          | |           d {V  Y d S w xY wd S )5NzINICIANDO POR PAGAR....
   %m/%d/%Yr%   rq   r   rs   3https://www.afirmeseguros.com/cercania360/#/polizasr   Obteniendo recibos por pagarr   rP   zFECHAS: z, Consulta de Recibosr   r   r   Estatusspan	Pendiente   re   r   rg   ri   rj   i rl   rL   1.title-label-modal >> text="Ha ocurrido un error"err_loop_p_pagarr   div.titleNoRecordsNo se encontraron datos parahas_texti0u  rK   r'   $No se encontraron datos para mostrarTSe encontraron datosr   Excel Descargar Exceli afirme_r   	_porpagarz#DOCUMENTO GUARDADO AHORA LEYENDO...zREPORTE TERMINADO, por pagarerr_f_por_pagarzNO SE PODIA DESCARGAR EL EXCELr   )r.   obtenerFechasEnRangor   r`   r+   r6   r|   rv   r   r   ru   rw   get_by_labelry   rx   wait_for_selector
is_visibleloopReintentosCobranzareloadr   exportarReportePorPagarr{   
inner_textr~   r}   r   r   r   r   leerExcelPorPagarr   )r   r   fecha_proximafecha_anteriorhoyr[   tiene_errorr   textoexisteCargandor   r   r   r   s                 r@   r   r   :  s     !""" (<B
'K'K$- 4
+;E+Bj"Z"Z\\\\\\\\\12gimostttttttt U2
"j$z2B$D
F
FFFFFFFF
c4c1P_`ccc
d
dddddddd
 

6^
6
6}
6
6777


0
1
1
7
7
9
99999999
-



!
!'
*
*
0
0
2
22222222

!
!'
*
*
/
/
?
????????

!
!'
*
*
0
0
2
22222222

!
!'
*
*
/
/
>
>>>>>>>>


I
&
&
.
.v
6
6
<
<
>
>>>>>>>>


;
'
'
-
-
/
////////
-




8(

3
3
9
9
;
;;;;;;;;>2""=&"QQQQQQQQQ ,,'Z[[ffhhhhhhhhk	 
4"81"<!A%%(4
3CE3JVh*j*jll
l
l
l
l
l
l
l
l 






((77
7
7
7
7
7
7
7'd33
3
3
3
3
3
3
3	&,,3>\,]]u---------((********)U22(4
3CE3JVa*c*cee
e
e
e
e
e
e
e
6
7
7
7 3  & & &$%%%%%& "\\-88>>@@@@@@@@n 
1		'')) 	n 	n 	n 	n 	n 	n 	n]  0G HHNNW]N^^
^
^
^
^
^
^
^n*0000000H(KKiKKKK"";/////////7888#D+6666666660111*T*5Ee5LXc,e,eggggggggg%&"" n n n*T*5Ee5LXi,k,kmmmmmmmmmmmmmmn	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	n 	.///&j1A%1HT_(a(accccccccccc 	2 	2 	2 6 :	!	#	#&j1A%1HTf(h(hjjjjjjjjjjjj kkmm&&}555555555%dD111111111111	2YU2 U2s   &CV 9BO  ?V  OV OAV -2U BS65U6
T. $T)$U)T..U1V 
UV UV 3V AX"AX"!X"c                 n  K   t          j        |          }|j                                        }d}|D ]W}t	          |d                   | d         d         k    s(t	          |d                   d| d         d          k    r|d         }X|dk    rt          d           t          j        |           d	S )
N	PENDIENTEr   r%   numero_reciboSARr   COBRADOz'COBRADO CAMBIANDO CUERPO DEL MENSAJE...T)pandas
read_excelvaluestoliststrr.   r0   r3   )r   r   
excel_data
data_arrayr   r?   s         r@   leerExcelVerificarReciboCobrador    s       --* ''))*&  d
47||tJ'888CQLLLuRVWaRbcrRsLuLu<u<uBxfy	
3444 )K	rA   c                   K   |                     dd          }t          j        ||           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Hd| d         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%          t          |                     t'          d| d         i           d {V  t)          | d         d|id           d {V }
t+          | d         d         dd            d {V  t%          d!           dS )"N.zip.xlsxheader   Número de Recibo3   No se encontró la cabecera con 'Número de Recibo'r   Tdropr
   r   nanafirmer   rn   r   r      r            	   r   companiarn   r   r   polizareciboclientetelefonofecha_limiteinicio_vigenciafin_vigenciamontor   r   r   arrAfirmePorPagarr   reportesr%   rq   r'   rs   termina)replacer0   renamer  r  ranger/   ilocr  r   columnsreset_indexastyper  iterrowsisnullanyappendr.   r+   registrarRecibosr   r   r   rutaxlsxdf
header_rowr   datosr   rowregistrorespuestaReciboss              r@   r   r     s       00()K!!!$///"*R>>  abgaj///je 0 
J
K
KK wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e % 0@HQKHQKHQKHQKHQKHQKHQKHQKHQKHQKHRL H  
LLE

 	!JZ0@"BDDDDDDDDD+d=>Qatv{_}--  B  B  B  B  B  B  B  B 	!4
+;E+Bk"["[]]]]]]]]]		rA   c                   K   t          d           t          dd          \  }}}|                     d                                           d {V }|dk    rt	          d| |           d {V }n7|                                  d {V  |                     d           d {V  d}|rt          |d	         d
         dd           d {V  t          i |ddd           d {V  | 	                    d          
                                 d {V  t          j        d           d {V  |                     d                              d          
                                 d {V  | 	                    d          
                                 d {V  |                     d          
                                 d {V  |                     d                              |           d {V  |                     d          
                                 d {V  |                     d                              |           d {V  |                     dd          
                                 d {V  	 |                     ddd           d {V  |                     d                                           d {V }|rt&          dz   at&          dk    r%t          |d	         d
         d d           d {V  nK|                                  d {V  |                     d           d {V  t)          | |           d {V  	 |                     d!d"#          }|                    d$%           d {V  |                                 d {V }	d"|	v r5t          |d	         d
         d&d           d {V  t          d'           dS n# t.          $ r t          d(           Y nw xY w|                     d                                           d {V }
|
dk    r]|                                 4 d {V }|                     dd)          
                                 d {V  	 |j         d {V }t4           d*|d+          d,}|                    |           d {V  	 t9          ||           d {V  n'# t.          $ r}t          d-|           Y d }~nd }~ww xY wt          d.           t          |d	         d
         d&d           d {V  dan;# t.          $ r.}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   d S d S t          |d	         d
         d&d           d {V  d S # t:          $ r t&          dz   at&          d0k    r't          |d	         d
         d d           d {V  Y d S |                                  d {V  |                     d           d {V  t)          | |           d {V  t          |d	         d
         d&d           d {V  Y d S w xY wd S )1Nzentra pagadasr   r   app-polizas mat-icon svgr   r   r   Tr%   rq   r   rs   zObteniendo recibos pagadosr   rP   r   r   r   r   Cobrador   r   re   r   rg   ri   rj   i- r   r   r   err_loop_pagadasr   r   r   iP  rK   r'   r   r   r   r   r   _pagadaszError en leerExcelPagadas:zREPORTE TERMINADO, pagadaserr_f_pagadasr   )r.   r   ry   r}   r`   r   r   r   r6   r|   rv   r   r   r   ru   rw   rx   r   r   r   exportarReportePagadasr{   r   r~   r   r   r   r   leerExcelPagadasr   )r   r   r   r   r   existeRegresarr[   r   r   r   r   r   r   r   r   s                  r@   rA  rA    sz	      (<B
'K'K$-&@AAGGIIIIIIII.q34ikoquvvvvvvvv
++--

"
"=
1
11111111  Sd
 #T*-=e-DPZ$\$\
^
^^^^^^^^
a4a1N]^aaa
b
bbbbbbbb


0
1
1
7
7
9
99999999
-




I
&
&
.
.v
6
6
<
<
>
>>>>>>>>


9
%
%
+
+
-
--------

!
!'
*
*
0
0
2
22222222

!
!'
*
*
/
/
?
????????

!
!'
*
*
0
0
2
22222222

!
!'
*
*
/
/
>
>>>>>>>>


8(

3
3
9
9
;
;;;;;;;;@d ""='"RRRRRRRRR ,,'Z[[ffhhhhhhhhk	 
3"81"<!A%%(4
3CE3JVh*j*jll
l
l
l
l
l
l
l
l 






((77
7
7
7
7
7
7
7&tT22
2
2
2
2
2
2
2	&,,3>\,]]u---------((********)U22(4
3CE3JVa*c*cee
e
e
e
e
e
e
e
6
7
7
7 3  & & &$%%%%%& "\\-88>>@@@@@@@@n	1		'')) 	l 	l 	l 	l 	l 	l 	l]  0G HHNNPP
P
P
P
P
P
P
Pl*0000000H(JJiJJJK"";/////////7$T;7777777777 7 7 72A666666667.///*T*5Ee5LXc,e,eggggggggg%&"" l l l*T*5Ee5LXg,i,ikkkkkkkkkkkkkkl	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l 	l& 'j1A%1HT_(a(accccccccccc 
d 
d 
d 6 :	!	#	#&j1A%1HTf(h(hjjjjjjjjjjjj kkmm&&}555555555$T4000000000&j1A%1HT_(a(acccccccccccc
dSSd Sds   CV5 BO V5 O;8V5 :O;;AV5 0U:=;T-9ST-
S4S/*T-/S448T-,U:-
U%7$U U: U%%U:(V5 :
VV5 VV5 $V5 5AY.;A/Y.-Y.c                 "  K   t          d           |                    dd          }t          j        ||           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Hd| d         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          t          |                     t'          d| d         i           d {V  t)          | d         d|id           d {V }
t          d|
           t+          | d         d          d!d"           d {V  t          d#           dS )$NzIMPORTANDO PAGADASr
  r  r  r  r  r   Tr  r
   r   r  r  r   rn   r   r   r  r   r  r  r  r  r   r  r   r   arrAfirmePagadasr$  zRespuesta del servidor:r%   rq   r'   rs   r&  )r.   r'  r0   r(  r  r  r)  r/   r*  r  r   r+  r,  r-  r  r.  r/  r0  r1  r+   r2  r   r3  s              r@   rB  rB  e  s       00()K!!!$///" *R>>  abgaj///je 0 
J
K
KK wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e $ 0@HQKHQKHQKHQKHQKHQKHQKHQKHQKHQKHRL H" 
LL E

 JZ0@"BDDDDDDDDD+d=>Qasuz_|-~-~  A  A  A  A  A  A  A  A!#3444 	!4
+;E+Bk"["[]]]]]]]]]		rA   c                    K   t          |d         d         dd           d {V  t          d| |           d {V }|rMt          i |ddd           d {V  |                     d	           d {V  |                     d
                                           d {V  t          j        d           d {V  |                     d          	                    d                                           d {V  |                     d                                           d {V  | 
                    d                                           d {V  | 
                    d                              t                     d {V  | 
                    d                                           d {V  | 
                    d                              t                     d {V  |                     dd                                           d {V  |                     dd           d {V  | 	                    d                                           d {V }|dk    r|                                 4 d {V }|                     dd                                           d {V  	 |j         d {V }t&           |d          d}|                    |           d {V  t+          ||           d {V  n;# t,          $ r.}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 t          |d         d         dd           d {V  d S d S )Nr%   rq   r   rs   z*https://www.afirmeseguros.com/cercania360/r   r   rP   r   r   r   r   r   	Cancelador   r   re   r   rg   ri   rj   rk   r   r   r   _cancelacioneserr_f_canceerr_report_timeout)r   r`   r6   r   r|   rv   r   r   r   ry   ru   rw   r   r   rx   r   r}   r   r   r   r   leerExcelCancelacionesr~   )r   r   r[   r   r   r   r   r   s           r@   exportarReporteCancelacionesrL    sJ      4
+;E+Bj"Z"Z\\\\\\\\\12^`dfjkkkkkkkk k
c4c1P_`ccc
d
dddddddd

"
"=
1
11111111


0
1
1
7
7
9
99999999
-




I
&
&
.
.v
6
6
<
<
>
>>>>>>>>


;
'
'
-
-
/
////////

!
!'
*
*
0
0
2
22222222

!
!'
*
*
/
/
?
????????

!
!'
*
*
0
0
2
22222222

!
!'
*
*
/
/
>
>>>>>>>>


8(

3
3
9
9
;
;;;;;;;;

 
 h
 
?
????????<<66<<>>>>>>>>N%%'' h h h h h h h=x.EFFLLNNNNNNNNN	h(.......(&GYGGG+  --
-
-
-
-
-
-
-&t[99
9
9
9
9
9
9
9
9 	h 	h 	h(4
3CE3JVc*e*egg
g
g
g
g
g
g
g
g
g
g
g
g	hh h h h h h h h h h h h h h h h h h h h h h h h h h h h h h %tJ/?/FRf&h&hjjjjjjjjjjj;k ks=   0M6ALM
L?$L:5M:L??M
M"M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 n|j        d         d	k    rHd
| d         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          d| d         i           d {V  t!          | d         d|id           d {V }	t#          j        |           t'          | d         d         dd           d {V  d S )Nr  r  r  r   Tr  r
   r   r  r  r   rn   r   r   r  r   r  r  r  r  r   r  r   r   r#  r$  r%   rq   r'   rs   )r  r  r)  r/   r*  r  r   r+  r,  r-  r  r.  r/  r0  r1  r+   r2  r0   r3   r   )
r   r   r5  r6  r   r7  r   r8  r9  r:  s
             r@   rK  rK    sv     T222" *R>>  abgaj///je 0 
J
K
KK wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e % 0@HQKHQKHQKHQKHQKHQKHQKHQKHQKHQKHRL H  
LL 	!JZ0@"BDDDDDDDDD+d=>Qatv{_}--  B  B  B  B  B  B  B  B)K 4
+;E+Bk"["[]]]]]]]]]]]rA   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   rP   r   u   Exportar Pólizasrg   r   r   r#   u   Procesando informaciónr   zActualizando sistemaERROR)r6   r   rx   rv   r   r   r   r   r   r~   r.   )r   r   typeFiler   enlacer   r   r   s           r@   descargaEsperaReporterR    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   	 |                                   d {V }|                    di           }|rdt          j        |          }t           t
           }t          |d          5 }|                    |           d d d            d S # 1 swxY w Y   d S d S # t          $ r}t          d|           Y d }~d S d }~ww xY w)Nr   wbzERR HANDLE R)
r   r)   base64	b64decoder   nombreReciborR   writer~   r.   )responseresponse_json
pdf_base64pdf_datar   pdf_filer   s          r@   handle_response_recibor^  2  s7     "--//))))))M""62..J !!*--h"2L22kT"" !hx   ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !	! ! 
   	.!s<   A&B *B B BB BB 
C&B<<Cc                   K   	 |                                   d {V }t           t           }t          |d          5 }|                    |           d d d            n# 1 swxY w Y   t          t           t           t          t                     d {V  d S # t          $ r}t          d|           Y d }~d S d }~ww xY w)NrT  zERR HANDLE P)	bodyr   nombrePolizarR   rX  subirArchivoAS3eliminarArchivosr~   r.   )rY  bufferr   fr   s        r@   handle_response_polizarf  C  s$     ==??""""""F !0,00K	k4	 	  Aggfooo              
[8,88,HX
Y
YYYYYYYYYY	   	.!s:   :B A B  A$$B 'A$(2B 
C&B<<CFc                 `  K   |rt          |d         d         |d         d         dd           d {V }|rjt          j        |          }|d         d         }t           | }t	          |d          5 }|                    |           d d d            n# 1 swxY w Y   |S |                     d                                           d {V dk    r0|                     d                                           d {V  d	}nL| 	                                 d {V  t          d
| |           d {V }|                     d           d {V  |rd}t          |d         d         dd           d {V  d|d         vrd|d         d<   |d	u rt          | |dd	           d {V }nY|d         d         dk    rt          | |dd	           d {V }n.t          | |d	           d {V }t          | |d	           d {V  |du r$t          |d         d         dd           d {V  |S d S )Nr%   numero_polizaidRecibo0)rh  ri  guardarrT  r<  r   Tr   r   r
   rq   r   rs   r   FobtenerDatosClienter'   )obtenerPolizaAfirmeSWrU  rV  r   rR   rX  ry   r}   rv   r   r`   r   r   descargarRecibodescargarPoliza)	r   r   enviarPorWhatsappr   r\  rW  r   r]  r[   s	            r@   obtenerDocumentoPolizarq  Q  sp      .)T*=Mo=^lpq{l|  ~H  mI  VY  +[  +[  \  \  \  \  \  \  \  \G !!'**h*%j1l"2L22kT"" !hx   ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! \\455;;========AALL344::<<<<<<<<<KKMM 56kmqsw x xxxxxxx$$]333333333 k$tJ/?/FR\&^&^`````````	$z*	*	*&(Z# 
d	"	"+D$tDDDDDDDD
I&*???+D$tDDDDDDDD ,D$========dD$/////////	e	#	#&j1A%1HT_(a(accccccccc+ s   5BBBr   c                 	  K   t          i |ddd           d {V  t          d|d         i           d {V  |                     d                                           d {V  t	          j        d           d {V  |                     d                                           d {V  |                     d                              |d         d	                    d {V  |                     d
d                                           d {V  | 	                    dd           d {V  |                     d          
                                 d {V }|dk    r~t          d|            |dk    rt          d           dS |dz   }|                                  d {V  |                     d           d {V  t          | ||||           d {V  d S |                     |d         d                   
                                 d {V }|dk    r+|                     d|d         d                     d {V  n|                     d|d         d                    
                                 d {V }|dk    r+|                     d|d         d                     d {V  n*|                     d|d         d                     d {V  | j                            d           d {V  | j                            d           d {V  	 da|d          d|d         d          da|                     d t(                     |                                 4 d {V }|                     d
d!                                           d {V  |j         d {V }d d d           d {V  n# 1 d {V swxY w Y   |                     d t(                     |                                 d {V  t2           t$           }	t          d|d         i           d {V  |rMt          i |d"dd#d|d         d$         |d         d	         |d         d         t$          d%d&           d {V  |d'u r/t5          t2           t$           t$          t6                     d {V  |	S )(NzObteniendo recibosr   rP   r   r   r      Pólizar%   rh  re   r   rg   ri   rj   rk   r   r   zREINTENTANDO NUMERO zYA NOS E PUEDE REINTENTARr
   r   r   ztext=r   ztext=SARfecha_reciboz	Shift+TabSpacer   	_recibos_.pdfrY  zDescarga MasivazRecibo disponibleTtype)optrx  rh  r   nombre_numero_recibor#   rQ   mostrar_datosdescargaF)r6   r+   r|   rv   r   r   ru   rw   rx   r   r}   r.   r   r   rn  r   r   ra  rW  onr^  expect_popupr   remove_listenercloser   rb  rc  )
r   r   realTimeNotificaciondescargaLocalintentonoSeEncontraronDatosexistePorNoRecibo
page1_infopage1r   s
             r@   rn  rn    s     WW/DSTWWWXXXXXXXXX JZ0@"BDDDDDDDDD.//55777777777a	**00222222222	**//Z0@0QRRRRRRRRR1177999999999 	}H=========#//0NOOUUWWWWWWWWA	
*
*
*+++{{'(((R1gKKMM$$]333333333D$(<mWUUUUUUUUUUU #..tJ/?/PQQWWYYYYYYYY1JJBtJ/@BBCCCCCCCCCC $ 0 01ZtJ7G7X1Z1Z [ [ a a c ccccccc	Q		jjGD$4_$EGGHHHHHHHHHHjjFD$4^$DFFGGGGGGGGG
-

k
*
********
-

g
&
&&&&&&&&" L9oWWZ0@0QWWWLGGJ.///  "" % % % % % % %jX,=>>DDFFFFFFFFF$$$$$$$e% % % % % % % % % % % % % % % % % % % % % % % % % % % 	%;<<<
++-- !0,00K #j$z2B$D
F
FFFFFFFF |  {T  {3FUVim  EG  QU  V`  Qa  bh  Qi  |@  AK  |L  M\  |]  pt  u  p@  AP  pQ  kw  |y  |y  {  {  {  |  |  |  |  |  |  |  |  |{:L::LJZ[[[[[[[[[s   :=O		
OOc                   K   t          i |ddd           d {V  |                     d                                           d {V dk    r-|                     d                                           d {V  |                     d                                           d {V  t          d|d         i           d {V  t          j        d           d {V  |                     d	d
                                           d {V  |                     d	d
          	                    |d         d                    d {V  | 
                    dd                                           d {V  |                     dd           d {V  |                     d                                           d {V }|dk    r
| 
                    dd          j                                         d {V  |                     d                              d          }|                                 d {V dk    r|                                 d {V  n-|                     d                                           d {V  da|d          d|d         d          da|                     dt"                     |                                 4 d {V }| 
                    dd                                           d {V  |j         d {V }d d d           d {V  n# 1 d {V swxY w Y   |                     dt"                     |                                 d {V  t          d|d         i           d {V  |rDt          i |d dd
d|d         d!         |d         d         t          d"d#           d {V  d S d S d S )$Nu   Obteniendo pólizar   rP   r<  r   Consulta de Polizasr   r   rs  Texactr%   rh  re   r   rg   ri   rj   rk   r   r   liu	   Carátular   u   Póliza covidr
   r   _poliza_rw  rY  	Descargaru   Póliza disponiblerx  )ry  rx  rh  nombre_numero_polizar{  )r6   ry   r}   rv   r|   r+   r   r   ru   rw   rx   r   rz   filterrW  ra  r~  rf  r  r   r  r  )r   r   r  existeRegistrocaratular  r  s          r@   ro  ro    s     WW/DSTWWWXXXXXXXXX<<23399;;;;;;;;a??
,,1
2
2
8
8
:
::::::::.//55777777777 JZ0@"BDDDDDDDDDa	66<<>>>>>>>>>	66;;D<L_<]^^^^^^^^^ 	1177999999999}H=========))*HIIOOQQQQQQQQ.q


8*

5
5
;
A
A
C
CCCCCCCC||D!!((+(>>H^^!!NN_--33555555555 L9oVVtJ/?/PVVVLGGJ.///  "" % % % % % % %jXK88>>@@@@@@@@@$$$$$$$e% % % % % % % % % % % % % % % % % % % % % % % % % % % 	%;<<<
++--
"j$z2B$D
F
FFFFFFFF I  HT  H3GVWjn  FH  RV  Wa  Rb  ci  Rj  }A  BL  }M  N]  }^  xD  }F  }F  H  H  H  I  I  I  I  I  I  I  I  I  I  I1 .I Is    =L//
L9<L9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)Nr   testfirefoxFi N  )r   r   headless	autoClose	CONNECTEDr?   r  z', te informamos que tu recibo de pago: r  uR    ya venció, te invitamos a que realices el pago correspondiente por el monto de: importez@. Si ya pagaste favor de confirmar con el *comprobante de pago.*521whatsappzFhttps://wsoft1.s3.us-east-1.amazonaws.com/segurocotizas/automatizador/r   rv  r%   rh  rw  z./rT  zRECIBOS.pdfr
   r  z
POLIZA.pdfzERROR CLIENT)r   r   startrl   r~   sendTextr   r)   raise_for_statusrR   rX  rM   sendFiler0   r3   r  r.   )r   r   ejecutorr   your_session_namecreatorclientmessagephone_numberresultrE   r   ruta_destinor   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           
      	  K   t          |d         d         dd           d {V  d}	 t          d|d         i           d {V  t          |d         d         |d         |d         d	         |d         d
         d           d {V }d|d         d<   |d         d         du rBt          |d         d         dd           d {V  t          d|d         d	                    nt          d|d         d	         |d         d                    |d         d         du r|d         d         |d         d<   dat          | |           d {V  |                     d                                           d {V dk    r0|                     d                                           d {V  d}nt          d| |           d {V }|r| 
                    d                                           d {V  t          j        d           d {V  |                     dd                                           d {V  |                     dd                              |d         d	                    d {V  |                     dd                                           d {V  |                     dd !           d {V  | 
                    d"                                           d {V }|dk    r|                     d#           d {V }g }|D ]s}|                                 d {V }|d$k    rQ|                    |                    d%d$                              d&d$                              d'd$                     td$}	t+          t-          |                    D ]9}
|d         d(         ||
         v r!|
dz   t-          |          k     r||
dz            }	:d)|	id*d$id+d$ig}d$}d$}d$}d$}d$}|||||d,}g }g }|d         |d         d         |d         d-         |d         d	         |d         d
         d.|||d/	}t/          |           d {V  t          |d         d         d0d           d {V  nIt          |d         d         d1d           d {V  n$t          |d         d         d0d           d {V  t          d|d         i           d {V  d S )2Nr%   rq   r   rs   Fr   ro   r   rh  r   )ro   r   rh  r   Tr   fechaValidano_en_rangozCONTINUANDO: zPROCESANDO:existe_documento_polizafecha_formato_afirmert  r<  r   r   r  r   rs  r  re   r   rg   ri   rj   rk   r   ztable tbody tr:first-child tdr
   	
    rn   versionmodelomarca)r  rfc	direccionpoliza_anteriorpoliza_renovada
id_clienter   )	r   ro   r  rh  r   r  
comisionesdatos_principalesdatos_adicionalesr'   no_existe_poliza)r   r+   obtenerInformacionReciboBDr.   rc  rq  ry   r}   rv   r`   r|   r   r   ru   rw   rx   r   query_selector_alltext_contentr1  r'  r)  r/   registrarDatosAutogenerados)r   r   r[   resultado_recibor  itemsarrDatostd_filterTextovehiculor   datos_polizaclienteTelefono
clienteRFCclienteDireccionpolizaAnteriorpolizaRenovadarowPrincipaldatos_recibosr7  datosAutogeneradoss                        r@   rl  rl  R  s      4
+;E+Bj"Z"Z\\\\\\\\\ 	!JZ0@"BDDDDDDDDD 6$zJZ[jJk  }A  BO  }P  cg  hr  cs  tC  cD  W[  \f  Wg  hw  Wx  8z  8z  |  |  |  |  |  |  |  |,06=)fm,55
"T*-=e-DP]$_$_
a
aaaaaaaa	/4
+O<====	-j)/:<LV<TUn<oppp 9:eCC)9&)ABX)Yd:~& "4.........||677==??	?	?	?	?	?	?!	C	Cll566<<>>>>>>>>> "78mosuy"z"zzzzzzz
 Bm455;;=========mA%%it%<<BBDDDDDDDDD%%it%<<AA$zBRSbBcddddddddd xh77==?????????$$]($CCCCCCCCC#//0NOOUUWWWWWWWWQ//0OPPPPPPPP%( c cb!#!2!2222222Lr!!oo|33D<<DDT"MMUUV\]_``bbb(X'' + +a'78A;FFQX&&#AE? #, !#/ "* "
 ". ".')-- , -%!%m!4!%j!1/!B!%j!1,!?!%j!1/!B!%j!1/!B!"!.!-!-
  
 
 ,-?AA
A
A
A
A
A
A
A(4
3CE3JVa*c*cee
e
e
e
e
e
e
e
e )4
3CE3JVh*j*jll
l
l
l
l
l
l
l$tJ/?/FR]&_&_aaaaaaaaa JZ0@"BDDDDDDDDDDDrA   c                 <    | D ]}|d         |k    r
|d         c S dS )Ntipovalorr
   r   )listatipo_buscador?   s      r@   obtener_valor_por_tipor    s:      dF||##'] $	rA   )F)Fr   ).r   r0   r   globr   rezipfiler  rU  r   r   WPP_Whatsappr   utilslectoresr   playwright.async_apir   r   rY   ra  rW  r   rc  r9   r`   rZ   r   r   r   r   r  r   rA  rB  rL  rK  rR  r^  rf  rq  rn  ro  r  rl  r  r   rA   r@   <module>r     s   C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C C ( ( ( ( ( ( ( (                     - - - - - -xV++H+>  Og Og Ogd, , ,\3 3 3j` ` `7 7 7r  ,a2 a2 a2F  $? ? ?Dhd hd hdVG G GX k  k  kF6^ 6^ 6^~  ,  "  0 0 0 0dT T T Tn*I *I *IX2 2 2hoE oE oEd    rA   