
    CUhi                        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 edk    rdZndZd	Z	 d
 Z	 d Zd Zd Z	 d Zd Z	 d Zd Z	 d Z	 d Zd Zd Z	 d Z	 d Z	 d Zd Zd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/z0https://portal.elpotosi.com.mx/potosi/login.aspxc                 X  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    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ocultarNavegadoru   Conexión establecida)loginMessagerefreshsubtareaerr_f	terminador   r   )getactualizarStatusTareaactualizarConteoUsoTareaobtenerDatosConexionorganizaSubtareasprintlenospathexistsremove actualizarStatusNavegadorAbiertoinicializarPlaywrightenviarMensajeglobalscallableejecutarProcesosPotosicerrarPlaywrightactualizarFechaLogin)
parametrosr
   r   r   r   r   r   r   subtareasNavegadorsubtareasWhatsappr   r   itemr   s                 @/var/www/wsoft.com.mx/carteraplus-automatizador/python/potosi.pyr6   r6      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" 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   d}|                     |            d {V  |                    d           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 )NTnetworkidler   () => window.location.hrefzINICIANDO SESION...r   r    	conectador   r%   F)	gotowait_for_load_stater(   evaluatefindurlLoginr3   iniciar_sesionr8   )urlr   r
   continuaOperacion
url_actualsesionIniciadas         r=   validar_inicio_sesionrO   f   s     		#  ///////// 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	r>   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 {V  t          j	        d
           t          j        d           d {V  |                     dd                                           d {V  t          j        d           d {V  |                     d           d {V }|                    t                    dk    rSt!          i |ddd           d {V  t          j        d           d {V  t!          i |ddd           d {V  nD| j                            d| d           d {V  t!          i |dddd           d {V  d}|S )NFr   r   campo1campo2r   r   Usuariou   Contraseñar   r   buttonENTRARnamer   rA   rB   zERROR DE INICIO DE SESION.rC    )r.   T)r    rD   saveSession)r-   r.   r/   r0   get_by_placeholderclickfillpausesysexitasynciosleepget_by_rolerG   rH   rI   r3   contextstorage_state)r   r
   rN   r   usuariopasswordrM   s          r=   rJ   rJ   }   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+++a1177999999999a ]]#?@@@@@@@@*__X##
a4a1N]^aaa
b
bbbbbbbb
-


F4F!FFF
G
GGGGGGGGG ,
$
$*G*G*G*G
$
H
HHHHHHHH
Z4Z!TXZZZ
[
[[[[[[[[N	r>   c                   K   t          i |d|d         dd           d {V  t          d| |           d {V }|rmt          |d         |d         d           d {V  t          i |d|d         dd           d {V  t          |d	         d
         dd           d {V  d S t          i |d|d         dd           d {V  t          |d	         d
         dd           d {V  d S )NTr   u   Intentando iniciar sesión)login_intentor   mensaje3https://portal.elpotosi.com.mx/agentes/Default.aspxr   r%   u   ¡Sesión validada con éxito!r"   _idr$   rk   r   zDatos incorrectos)r3   rO   r8   actualizarStatusSubtarea)r   r
   rL   s      r=   r   r      s       D  DT-EX  fB  D  D  D  	E  	E  E  E  E  E  E  E  E12gimostttttttt `
d:.>tTaOb d d
f
ffffffff
  J4  J$tMGZ  hH  J  J  J  K  K  K  K  K  K  K  K  K
"T*-=e-DP[$]$]
_
__________ |4|$tMGZgz|||
}
}}}}}}}}
"T*-=e-DP[$]$]
_
__________r>   c                   K   t          |d         d         dd           d {V  t          d| |           d {V }|r5t          i |ddd           d {V  |                     d	d
                                           d {V  |                     d                              d           d {V  |                     d                              d           d {V  |                     d                              d           d {V  |                                 4 d {V }|                     dd                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j	         d {V }|
                                4 d {V }|                    d                                           d {V  	 |j	         d {V }t           |d          d}|                    |           d {V  t          ||           d {V  n&# t          $ r}t!          d           Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S )Nr"   rk   iniciadorl   rj   zObteniendo recibos pagados   rC   linkzReporte de primas cobradasrV   z$#ctl00_MainContent_txtFechaInicialPCz
01/02/2024z"#ctl00_MainContent_txtFechaFinalPCz
29/02/2024TabrT   Ver reporteExportar a Excelr   _pagadasERROR)rm   rO   r3   rb   r[   locatorr\   pressexpect_popupvalueexpect_downloadget_by_textRUTA_FOLDERsave_asleerExcelPagadas	Exceptionr+   	r   r
   rL   
page1_infopage1download_infodownloadrutaArchivoes	            r=   exportarReportePagadasr      s]      4
+;E+Bj"Z"Z\\\\\\\\\12gimostttttttt 
a4a1N]^aaa
b
bbbbbbbb


6(D

E
E
K
K
M
MMMMMMMM
,,=
>
>
C
CL
Q
QQQQQQQQ
,,;
<
<
A
A,
O
OOOOOOOO
,,;
<
<
B
B5
I
IIIIIIII  "" C C C C C C CjXM::@@BBBBBBBBB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"""""""E$$&&       -01177999999999&,,,,,,,$?d9o???{+++++++++t[1111111111   g                              sO   00E22
E<?E<*.I#AH*)I#*
I4II#II##
I-0I-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 ]7\  }}|                                                                s	d|j        v r n|j        d         d	k    rJi d
dd| d         d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d |j        d!         d"|j        d#         d$|j        d%         d&|j        d'         }|                    |           9t          i | dd(|d)dd*           d {V  t!          d+| d+         i           d {V  t#          | d,         d(|id-           d {V }	t%          | d.         d/         d0d1           d {V  t'          j        |           d S )2Nheaderu   Pólizau)   No se encontró la cabecera con 'Póliza'r   TdroprX   r   nancompaniapotosiclave_agenter   polizatipo_polizarp   certparc   cliente   moneda   oficina   vig_inicial   	vig_final	   
prima_neta
   recargo_fracc   comision_prima   relacion_ingreso   	fecha_apl   arrPotosiPagadasoptarrmostrar_datosarrayexcelProcesador   r   r   reportesr"   rk   r$   rl   )pandas
read_excelranger,   ilocvalues
ValueErrorcolumnsreset_indexastypestriterrowsisnullanyappendr3   r(   registrarRecibosrm   r-   r0   
r
   r   df
header_rowidatos_rowregistrorespuestaReciboss
             r=   r   r      s     T222" *R>>  aBGAJ%%%je & 
@
A
AA wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e(d>*>:  SXa[	
 chqk chqk !  ! SXa[ 38A; CHRL sx|  #(2,  38B<!H& 
LL 	  F  FHZch?k?k  @D  F  F  F  	G  	G  G  G  G  G  G  G  G JZ0@"BDDDDDDDDD+d=>Qasuz_|-~-~  A  A  A  A  A  A  A  A 4
+;E+Bk"["[]]]]]]]]])Kr>   c                 \  K   t          |d         d         dd           d {V  t          d| |           d {V }|rt          i |ddd           d {V  |                     d	           d {V  |                     d
d                                           d {V  |                                 4 d {V }|                     dd                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                                4 d {V }|	                    d                                           d {V  	 |j         d {V }t           |d          d}|                    |           d {V  t          ||           d {V  nK# t          $ r>}t          d|           t          |d         d         dd           d {V  Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S )Nr"   rk   ro   rl   rj   zObteniendo recibos por pagarrp   rC   r@   rq   zRecibos pendientes de cobrorV   rT   rs   rt   r   	_porpagarrv   r#   )rm   rO   r3   rF   rb   r[   ry   rz   r{   r|   r}   r~   leerExcelPorPagarr   r+   r   s	            r=   exportarReportePorPagarr   )  sT      4
+;E+Bj"Z"Z\\\\\\\\\12gimostttttttt `
c4c1P_`ccc
d
dddddddd

"
"=
1
11111111


6(E

F
F
L
L
N
NNNNNNNN  "" C C C C C C CjXM::@@BBBBBBBBB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"""""""E$$&& 	` 	` 	` 	` 	` 	` 	`-01177999999999`&,,,,,,,$@d9o@@@{+++++++++k2222222222 ` ` `gq&j1A%1HT[(](]______________`	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	` 	`` `sO   0D
DD;.H*AF;:H;
H4G>9H>HH
H#&H#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         d}|                    |           t          i | dd|ddd           d {V  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   Clienteu)   No se encontró la cabecera con 'Cliente'r   Tr   rX   r   r   r   r   r   rp   r   r   r   r   r   r   r   )r   r   r   r   vigenciano_certparcialidad
no_factura
fecha_vencfecha_prorrogafecha_prob_cancimportearrPotosiPorPagarr   r   r   r   r   r"   rk   r$   rl   )r   r   r   r,   r   r   r   r   r   r   r   r   r   r   r   r3   r(   r   r-   r0   rm   r   s
             r=   r   r   F  s     T222" *R>>  aBGAJ%%%je & 
@
A
AA wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e >*>:!(1+!Xa[HQKHQK!" H 
LL  G  GH[di?l?l  AE  G  G  G  	H  	H  H  H  H  H  H  H  H 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"["[]]]]]]]]]]]r>   c                   K   |}t          j         |          }i }|D ]}t          j        |d           }d }t          t	          |                    D ]}d|j        |         j        v r|} n|t          d          |j        |         |_        ||dz   d          	                    d          }|
                    t                    }g }	|                                D ]\  }
}|                                                                s	d|j        v r n|j        d         d	k    rH|j        d         |j        d         |j        d
         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         d}|	                    |           t!          i | dt"          |	d           d {V  d S )Nr   u   Número de pólizau4   No se encontró la cabecera con 'Número de póliza'r   Tr   rX   r   r   r   r   r   r      r                  diaramor   endoso_originalendoso_modificador   u   fecha_emisión
forma_pagor   prima_total	aseguradocausaobservaciones)r   cabeceraarrItemsCancelaciones)globr   r   r   r,   r   r   r   r   r   r   r   r   r   r   r   r3   datos_agente)r
   r   patronarchivos
contenidosarchivor   r   r   r   r   r   r   s                r=   leerExcelCancelacionesr     s0     & Yv( *  7u 7ug		74	0	0	0B J3r77^^  	!2	2	2
 
3 MNNN $BJ	JNOO		(	(d	(	3	3B 
3B E++--  3					 rSZ//	!		 x{(1+8A; Xa[(2,(2,hrlhrlx|Xb\"" h  ll8 s4s$Lkpsss
t
ttttttttto7u 7ur>   c                   K   t          i |ddd           d {V  |                                 4 d {V }|                     dd          }|                                 d {V  	 |j         d {V }t
           |d          d| }|                    |           d {V  t          i |d	d
i           d {V  t          j        d           d {V  t          i |ddd           d {V  n&# t          $ r}t          d           Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S )Nz"Procesando y esperando descarga...rp   rC   rq   u   Exportar PólizasrV   r   r   r    u   Procesando informaciónr   zActualizando sistemarv   )r3   r{   rb   r[   rz   r}   r~   r`   ra   r   r+   )r   r
   typeFiler   enlacer   r   r   s           r=   descargaEsperaReporter     sc     gg/Tcdggghhhhhhhhh!!##       }f+>??F
,,..
$*******h"@DO@@h@@k[)))))))))PTP>3MPPQQQQQQQQQM!\T\3JYZ\\\]]]]]]]]]]    Gnnnnnnnn                             s<   2D3,BC:9D3:
DDD3DD33
D= D=c                 L  K   t          i |ddd           d {V  	 |                     d           d {V  |                     d           d {V  |                     d           d {V  |                     dd	                                           d {V  t          i |d
dd           d {V  |                     d                              dd	                                           d {V  t          j        d           d {V  t          | |d           d {V  |                     d           d {V  |                     d           d {V  |                     d           d {V  |                     dd	                                           d {V  t          i |d
dd           d {V  |                     d                              dd	                                           d {V  t          j        d           d {V  |                     dd	          
                                 d {V  t          j        d           d {V  t          | |d           d {V  	 t          i | dd           d {V  d S )Nu"   Obteniendo pólizas por renovar...rp   rC   4https://distribuidores.axa.com.mx/group/distribucionr@   u   text="Mostrar Pólizas"rq   u   Mostrar PólizasrV   zGENERANDO SALUD...z8[id="_LR_AXA_Dashboard_WAR_LR_AXA_Dashboard_\:j_idt909"]Saludr   zrenovaciones_salud.xlsradio
Canceladaszcanceladas_salud.xlsr   )r3   rE   rF   wait_for_selectorrb   r[   rw   r`   ra   r   check)r   r
   ejecutorr   s       r=   exportarReporteRenovacionesr    s     gg/Tcdggghhhhhhhhh0 			HIIIIIIIII  /////////8999999999&899??AAAAAAAAA 	WW/DSTWWWXXXXXXXXXRSS__`fmt_uu{{}}}}}}}}}adD*BCCCCCCCCC 			HIIIIIIIII  /////////8999999999&899??AAAAAAAAA 	WW/DSTWWWXXXXXXXXXRSS__`fmt_uu{{}}}}}}}}}a|44::<<<<<<<<<adD*@AAAAAAAAA, 	EEsEEEFFFFFFFFFFFr>   c                   K   t          j        |d           }dddddddd	d
d	}i }|                                D ]q}|                    |g                                          }||         j        d         }|||                             |g                   j        d         }||f||<   ri }	|                                D ]G\  }\  }}|j        ||j        	                    |          dz   f         }
||         }|
dk    r|
nd|	|<   Hd }t          t          |                    D ]}d|j        |         j        v r|} n|t          d          |j        |         |_        ||dz   d                              d          }|                    t                     }g }|                                D ]\  }}|                                                                s	d|j        v r n|j        d         dk    rH|j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         |j        d         d }|                    |           t)          i | d|	|d!           d {V  d S )"Nr   r   numero_agenteagentecallecolonia	cp_estadotelefonorfccedula_numero)	zOFICINA:zNUM. AGENTE:zAGENTE:zCALLE:zCOLONIA:zCP; ESTADO:u
   TELÉFONO:zRFC:u   CÉDULA NÚMERO:r   r   r   rX   u   DÍAu&   No se encontró la cabecera con 'DÍA'r   Tr   r   r   r   r   r   r   r   r   r   r   r   r   )r   r   arrItemsRenovaciones)r   r   keysisinr   indexitemsr   r   get_locr   r,   r   r   r   r   r   r   r   r   r3   )r
   r   r   keywords_mappingposiciones_palabras_clavepalabra_claveresultado_busquedacolumnafilar   valornueva_claver   r   r   r   r   r   s                     r=   leerExcelRenovacionesr  7  s$     T222" #'
 
 !',,.. ? ?m-115577 !34:1=Gbk//06q9D04gm,, ,(A(G(G(I(I @ @$m_dGGD"*,,W5599:E"=1K).%RL *R>>  a"""je # 
=
>
>> wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e
x{e Xa[hqk!8A;HRLHRLXb\8B<x|x| H  
LL 	pp,hmpppqqqqqqqqqqqr>   c                 `  K   t          |d         d         dd           d {V  t          d| |           d {V }|rmt          i |ddd           d {V  t          d	|d	         i           d {V  |                     d
                              d           d {V  |                     d           d {V  |                     d                              |d         d                    d {V  |                     d                                           d {V  |                                 4 d {V }	 |j	         d {V }|
                    d           d {V  t          j        d           d {V  |                    d           d {V }t          j        d|          }|rg|                    d          }|j                            d|            d {V }|d          d|d         d          d}	t&           |	 }
t)          |
d          5 }|                    |                                 d {V            t/          t&           |	 |	           d {V  t          i |dddd|d         d         |d         d         |	dd           d {V  t          d	|d	         i           d {V  t          |d         d         dd           d {V  |                                 d {V  d d d            n# 1 swxY w Y   ne# t2          $ rX}t5          d|           |                     d                                           d {V }|rt5          d            Y d }~nd }~ww xY wd d d           d {V  d S # 1 d {V swxY w Y   d S d S )!Nr"   rk   ro   rl   r   u   Obteniendo póliza y recibosrp   rC   r   z(select[id*=":selectTipoDocEcmTabPoliza"]u   Carátula de Pólizazinput[id*=":numeroPolizaWgECM"]numero_polizaz!a[id*=":btnConsultaPolEcmPoliza"]r@   z() => {
            const element = document.querySelector('a[onclick*="window.open"]');
            return element ? element.getAttribute('onclick') : '';
        }zwindow.open\('([^']*)'r   zhttps://portal.axa.com.mx/r   _poliza_.pdfwbrX   Ttype)r   r   r  nombre_numero_polizar    rD   r   descargar$   ERz.portlet-msg-erroruF   El elemento con class='portlet-msg-error' está visible en la página.)rm   rO   r3   r(   rw   select_optionr[   r\   ry   rz   rF   r`   ra   rG   researchgrouprequestr&   r}   openwritebodysubirArchivoAS3closer   r+   
is_visible)r   r
   rL   r   r   onclick_valuematchrK   responsenombrePolizar   fr   r/  s                 r=   obtenerDocumentoPolizar5    s2      4
+;E+Bj"Z"Z\\\\\\\\\12hjnptuuuuuuuu (Z
c4c1P_`ccc
d
dddddddd
"j$z2B$D
F
FFFFFFFF
,,A
B
B
P
PQg
h
hhhhhhhh
**6
7
77777777
,,8
9
9
>
>tJ?OP_?`
a
aaaaaaaa
,,:
;
;
A
A
C
CCCCCCCC  "" Z Z Z Z Z Z ZjZ &&&&&&&''666666666mA $nn .         	3]CC 	"++a..C"]../QC/Q/QRRRRRRRRH"9o^^tJ7G7X^^^L(8,88Kk4(( "AggHMMOO++++++,,,#{$BL$B$BLQQQQQQQQQ!  #~T  #~2A`d{}  HL  MW  HX  Y_  H`  sw  xB  sC  DS  sT  nz  s|  s|  #~  #~  #~                  ,
D<L.NPPPPPPPPP,tJ7G7NZe.g.giiiiiiiiiKKMM!!!!!!!" " " " " " " " " " " " " " "  Z Z ZdA<<(<==HHJJJJJJJJ
 	Z
X
Y
Y
Y	Z7Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z(Z (Zsc   NC"L#(C#LL#L	L#L	L#"N#
N-AN ;N NN
N%(N%c                 >  K   t          |d         d         dd           d {V  t          d| |           d {V }|rt          i |d|d         d          dd	           d {V  t          d
|d
         i           d {V  |                     d           d {V  |                     d                                           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  |                    d                                           d {V  t          j        d           d {V  |                    d                              d           d {V  t          j        d           d {V  |                    dd                                           d {V  t          j        d           d {V  |                    d           d {V  t          j        d           d {V  |                    d           d {V  t          j        d           d {V  |j                            d           d {V  |j                            |d         d                    d {V  |                    d           d {V }|r|                    d           d {V  t          j        d           d {V  |j                            d           d {V  |j                            |d         d         dd                     d {V  |                    d                                           d {V  n%|                    d                                           d {V  t          j        d           d {V  |
                    dd                              d d                                           d {V  |
                    dd                              d d                              d!           d {V  t          j        d           d {V  |
                    d"d#                                           d {V  t          j        d           d {V  |
                    dd                              d d                                           d {V  |                    d           d {V  t          j        d           d {V  |j                            d           d {V  |j                            |d         d                    d {V  |                    d                                           d {V  |
                    d$d%                                           d {V  t          j        d           d {V  |
                    dd%                              d%                                           d {V  t          j        d           d {V  |
                    d&d'                                           d {V }t+          d(|           |d)k    rt+          d*           |                    d           d {V  t          j        d           d {V  |                    d           d {V  t          j        d           d {V  |j                            d           d {V  t          j        d           d {V  |j                            d+           d {V  |                    d,           d {V  t          j        d           d {V  |j                            d           d {V  |j                            |d         d         dd                     d {V  |                    d                                           d {V  |
                    d&d'                                           d {V  t          j        d           d {V  |                    d-                                           d {V  |                                4 d {V }	 |                    d.                                           d {V  t          i |d/dd	           d {V  |j         d {V }|d0          d1|d         d          d2}	t0           |	 }
|                    |
           d {V  t5          t0           |	 |	           d {V  n'# t6          $ r}t+          d3|           Y d }~nd }~ww xY wd d d           d {V  n# 1 d {V swxY w Y   t          j        d           d {V  |
                    d&d'                                           d {V  t          j        d           d {V  |                    d4                                           d {V  |                                4 d {V }	 |                    d.                                           d {V  |j         d {V }|d0          d5|d         d          d2}t0           | }
|                    |
           d {V  t5          t0           | |           d {V  n'# t6          $ r}t+          d3|           Y d }~nd }~ww xY wd d d           d {V  n# 1 d {V swxY w Y   t          i |d6ddd |d         d7         |d         d         |	|d8d9           d {V  t          d
|d
         i           d {V  t          |d         d         d:d           d {V  d S d S );Nr"   rk   ro   rl   r   u,   Procesando recibos y facturas de la póliza r  r   rC   r   r@   z#menu_mgestionrq   u   Factura electrónica CFDI 3.3 /rV   z
Filtrar...z	firma axaXT)exactrp   zec-button[title="Filtrar"]u   text="AXA No. Póliza"rr   uK   div[ec-form-element="group"][ec-padding=""] >> text="AXA Número de recibo"u   text="AXA Número de recibo"numero_reciboAceptaru   Añadir y quitar camposmainrX   u   axa número deoptionu   AXA Número de reciborT   TodosgridcellVigentezBUSCANDO ELEMENTO VIGENTEr   zNO EXISTE BUSCANDO DE OTRO0u   text="AXA Folio único"z'CFDI40_CORE/LISTADO_XML_COMPROBANTE_4_0	DescargarzSubiendo archivos a la nuber   	_factura_r  rv   zCFDI40_CORE/LISTADO_REFERENCIAS	_recibos_zRecibos y facturas disponiblesr   )r   r   r  nombre_facturanombre_numero_recibor"  r$   )rm   rO   r3   r(   rF   rw   r[   r`   ra   ry   rb   rz   rZ   r\   r|   keyboardrx   r   r/  get_by_labelcountr+   dblclickr{   r}   r~   r-  r   )r   r
   rL   r   r   elemento_existeelemento_vigenter   r   nombreFacturar   r   nombreRecibos                r=    obtenerDocumentoRecibosYFacturasrO    s      4
+;E+Bj"Z"Z\\\\\\\\\12hjnptuuuuuuuu s`
  W4  W  2D`deo`p  rA  aB  2D  2D  ST  W  W  W  X  X  X  X  X  X  X  X  X
"j$z2B$D
F
FFFFFFFF

"
"=
1
11111111
,,'
(
(
.
.
0
00000000
-

  "" U U U U U U UjV*KLLRRTTTTTTTTTU U U U U U U U U U U U U U U U U U U U U U U U U U U"""""""E

#
#M
2
22222222

"
"<
0
0
6
6
8
88888888
-



"
"<
0
0
5
5k
B
BBBBBBBB
-




Ct

,
,
2
2
4
44444444
-


++2
3
33333333
-


++.
/
////////
-


.

u
%
%%%%%%%%
.

d:.?
@
@@@@@@@@!,,-z{{{{{{{{O 2KK6777777777M!N  '''''''''NZ 0 A"## FGGGGGGGGGy))//1111111111899??AAAAAAAAAM!f+DEERRSU]aRbbhhjjjjjjjjjf+DEERRSU]aRbbgghxyyyyyyyyyM!h-DEEKKMMMMMMMMMM!f+DEERRSU]aRbbhhjjjjjjjjjKK6777777777M!N  '''''''''NZ 0 ABBBBBBBBBy))//111111111


H7

3
3
9
9
;
;;;;;;;;
-




F

1
1
>
>w
G
G
M
M
O
OOOOOOOO -

"..z	.JJPPRRRRRRRR	
%'78881()))KK4555555555M!KK6777777777M!N  '''''''''M!N$$$$$$$$$KK1222222222M!N  '''''''''NZ 0 A"## FGGGGGGGGGy))//111111111


JY

7
7
@
@
B
BBBBBBBB
-




E
F
F
L
L
N
NNNNNNNN$$&& 
 
 
 
 
 
 
-	  --33555555555ftf5Sbcfffggggggggg&,,,,,,,	?\\T*5Eo5V\\\$5m55{+++++++++=m==}MMMMMMMMMM   gq
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 -




JY

7
7
@
@
B
BBBBBBBB
-




=
>
>
D
D
F
FFFFFFFF$$&& 	 	 	 	 	 	 	-  --33555555555&,,,,,,,y/[[D4D_4U[[[$4l44{+++++++++<l<<lKKKKKKKKKK   gq	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	   t4  t1Q`atx  PR  \`  ak  \l  ms  \t  GK  LV  GW  Xg  Gh  |I  co  Gr  Gr  t  t  t  u  u  u  u  u  u  u  u  u
"j$z2B$D
F
FFFFFFFF
"T*-=e-DP[$]$]
_
__________gs` s`s   0E
EEg=B5gg=
g(g#g=#g((g==
h
h8n:Bmn
m8m3.n3m88n
nnc                   K   |                      d           d {V  d}t          |ddd          }|                                }|j        dk    rt	          |j                  |d         d	          d
|d         d          d|d         d          d}d|d          }|                    ||          }	d}
t          j        |
 |d          d|d         d          d          }|                                 d|d          d|d         d          d}t          |d          5 }|
                    |j                   d d d            n# 1 swxY w Y   |                    ||dd           t          j        |           d}
t          j        |
 |d          d|d         d          d          }|                                 d|d          d|d         d          d}t          |d          5 }|
                    |j                   d d d            n# 1 swxY w Y   |                    ||dd           t          j        |           	 |                                 d S # t          $ r}t!          d|           Y d }~d S d }~ww xY w)Nr@   testfirefoxFi N  )r   r   headless	autoClose	CONNECTEDr<   r   z', te informamos que tu recibo de pago: recibouR    ya venció, te invitamos a que realices el pago correspondiente por el monto de: r   z@. Si ya pagaste favor de confirmar con el *comprobante de pago.*521whatsappzFhttps://wsoft1.s3.us-east-1.amazonaws.com/segurocotizas/automatizador/r   rD  r"   r  r  z./r  zRECIBOS.pdfrX   r  z
POLIZA.pdfzERROR CLIENT)rF   r   startstater   sendTextrequestsr&   raise_for_statusr*  r+  contentsendFiler-   r0   r.  r+   )r   r
   r  r   your_session_namecreatorclientmessagephone_numberresultrK   	respuestaruta_destinor   r   s                  r=   notificarAClienteReciborh  R  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   d}t          ||d         d         |d                    d{V }t          |           	 t          |d         d         dd           d{V  dS )	ur  
  1) Verificar si existe carátula, si no obtenerla
  2) Verificar si existe recibo de cobro, si no obtenerlo
  3) Verificar si ya simulamos los recibos
    3.1) Si no existen los recibos obtener: [prima neta, fpago, f_recibo] y enviar
  4) Verificar si ya tenemos los datos actualizados del cliente
    4.1) En caso de no tener los datos extraerlos de la carátula 
  zZ/Users/wsoft/Documents/wsoft.com.mx/carteraplus-automatizador/files/recibo_potosi_vida.pdfr"   r  r   Nrk   r$   rl   )leerPotosiVidar+   rm   )r   r
   r   datos_reciboss       r=   obtenerDatosClienterl    s       m+&T*5Eo5VX\]gXhjjjjjjjj-< 	!4
+;E+Bk"["[]]]]]]]]]]]r>   ) r`   r-   r^   r   r\  r&  r   r   r   WPP_Whatsappr   utilslectoresr   r}   rI   r6   rO   rJ   r   r   r   r   r   r   r   r  r  r5  rO  rh  rl   r>   r=   <module>rq     s)   3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 ( ( ( ( ( ( ( (                    xV++H+=Mg Mg Mg`  ., , ,\` ` `(  2> > >B` ` `:4^ 4^ 4^nBu Bu BuH  $RG RG RGhTr Tr Trx+Z +Z +ZZv` v` v`r2 2 2l-^ -^ -^ -^ -^r>   