
    	F)fr                        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 d dl 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y)    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                 d  K   | j                  dd      }| j                  dd      }| j                  dd      }| j                  dd      }| j                  dd      }| j                  dd      }| j                  dd      }|d	k\  rt        |d
   dd       d {    yt        d
|d
   i       d {    |d   |d<   |d   |d<   |dk(  rt        |d   |d
   d       d {   }t	        |d          d {   \  }}		 t        dt        |              t        |      dk(  rM|d   d   dk(  rB|d    }
t        j                  j                  d|
 d      rt        j                  d|
 d       t        |      dkD  rt        |d
   dd       d {    |dk(  rU|d   }|d    }
t        ||
       d {   \  }}}t        i |ddd       d {    t        d
|d
   i       d {    |D ]Y  }t               j                  |d         }t        |      r||d<    |||       d {    At        |d
   dd       d {    [ |dz   | d<   d| d<   || d<   || d<   || d<   t!        |        d {    n1t        |d
   d d       d {    |durt#        ||       d {    t        |      dk(  rEt        |	      dk(  r6t        |d
   d d       d {    t%        |d
   |d   d!       d {    y y y 7 p7 Z7 ,7 7 ~7 ]7 B7 -7 7 7 7 7 x7 E7 +w)"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                 N/Users/wsoft/Documents/wsoft.com.mx/carteraplus-automatizador/python/potosi.pyr6   r6      s     nnVU3$ nnZ7( nn%7? nnS%0! nnY6' nnVU3$ nnZ7(!m
tJ/?;!W
ZZZ JZ0@"BDDD'$y/!&)$~ %)D<O]abl]m+oqqH 1B(;BW0X*X'' 
S"46789	
"!Y'+@@&'g	,wiu5	6
		L	/0	
! +$z:JVZ,\
^^^ 	D 01&'g45EwOOa$ ^T^3JW\^___$
D4D&FHHH" f	d9o.g	'	ZdD!!!.d:>NZa0beeef '/lJz%*J!"%&JsO%,Jy%)Jv
 
,,,
*$z:JVa,b
eee	Q(((	
"s+<'='B
tJ/?;!W
ZZZ
d:.>tTaOb d
fff (C"A [ E r +Y( _ P `H 	"e -e( [fs  BL0L
L03L40L0$L%L0:L;BL0L#L0<L=L0LL02L3AL04L"5L0L$0L0?L& L0L(L01L*24L0&L,'L0L.L0L0L0L0L0L0L0L0"L0$L0&L0(L0*L0,L0.L0c                 d  K   d}|j                  |        d {    |j                  d       d {    t        d|d   i       d {    |j                  d       d {   }|j	                  t
              dkD  rt        i |ddd       d {    t        d|d   i       d {    t        ||       d {   }|rOt        d|d   i       d {    t        |d   |d	   d
       d {    |j                  |        d {    |S d}|S 7 7 7 7 7 7 x7 f7 N7 47 w)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_sesionrN   f   sB    		#  /// JZ0@"BDDD ]]#?@@*__X#
Z4Z3FVWZ
[[[
"j$z2B$D
FFF)$55N$
D4D&FHHH Z0@QUVcQd"fhhhIIcN 
  	% /D A \F5Hhs   D0DD0DD0
D D0#D"$1D0D$D0-D&.D0D(D0D*D07D,8D0D.D0D0 D0"D0$D0&D0(D0*D0,D0.D0c                   K   d}|d   }|d   d   }|d   d   }t         j                  j                  d| d      rt        j                  d| d       | j	                  d      j                          d {    | j	                  d      j                  |       d {    | j	                  d	      j                          d {    | j	                  d	      j                  |       d {    | j                          d {    t        j                  d
       d {    | j                  dd      j                          d {    t        j                  d       d {    | j                  d       d {   }|j                  t              dkD  rSt        i |ddd       d {    t        j                  d       d {    t        i |ddd       d {    |S | j                  j!                  d| d       d {    t        i |dd
dd       d {    d}|S 7 7 7 y7 T7 ?7 %7 7 7 7 7 7 i7 A7 (w)NFr   r   campo1campo2r   r   Usuariou   Contraseñar   buttonENTRARnamer   r@   rA   zERROR DE INICIO DE SESION.rB    )r.   T)r    rC   saveSession)r-   r.   r/   r0   get_by_placeholderclickfillpauseasynciosleepget_by_rolerF   rG   rH   r3   contextstorage_state)r   r
   rM   r   usuariopasswordrL   s          r=   rI   rI   }   s5    .&''1''1( WW^^l7)512IIWIU+,	*00222	*//888.44666.33H===

a177999a ]]#?@@*__X#
a4a3M]^a
bbb
--

F4F!F
GGG 
 ,,
$
$L	*G
$
HHH
Z4Z!TXZ
[[[N	/ 386=9 AbG I[s   A6I8H:9'I H=!&II 'I/I0III$I	%(III*I+II1I5I6III,I-)III1I2	I=I III	IIIIIIIIIc                   K   t        i |d|d   dd       d {    t        d| |       d {   }|rWt        |d   |d   d       d {    t        i |d|d   dd       d {    t        |d	   d
   dd       d {    y t        i |d|d   dd       d {    t        |d	   d
   dd       d {    y 7 7 7 ~7 b7 H7 +7 w)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$   rh   r   zDatos incorrectos)r3   rN   r8   actualizarStatusSubtarea)r   r
   rK   s      r=   r   r      s6      D  DT-EX  fB  D  	E  E  E12gimostt
d:.>tTaOb d
fff
  J4  J$tMGZ  hH  J  K  K  K
"T*-=e-DP[$]
___ |4|$tMGZgz|
}}}
"T*-=e-DP[$]
___ Et g K_ ~_sy   CC
CCCCC-C.C	C
C(C)CCCCCCCCCc                   K   t        |d   d   dd       d {    t        d| |       d {   }|rt        i |ddd       d {    | j                  d	d
      j	                          d {    | j                  d      j                  d       d {    | j                  d      j                  d       d {    | j                  d      j                  d       d {    | j                         4 d {   }| j                  dd      j	                          d {    d d d       d {    j                   d {   }|j                         4 d {   }|j                  d      j	                          d {    	 |j                   d {   }t         |d    d}|j                  |       d {    t        ||       d {    d d d       d {    y y 7 7 7 7 7 i7 D7 7 	7 7 # 1 d {  7  sw Y   xY w7 7 7 7 7 c7 Q# t        $ r}t!        d       Y d }~hd }~ww xY w7 d# 1 d {  7  sw Y   y xY ww)Nr"   rh   iniciadori   rg   zObteniendo recibos pagados   rB   linkzReporte de primas cobradasrU   z$#ctl00_MainContent_txtFechaInicialPCz
01/02/2024z"#ctl00_MainContent_txtFechaFinalPCz
29/02/2024TabrS   Ver reporteExportar a Excelr   _pagadasERROR)rj   rN   r3   r_   rZ   locatorr[   pressexpect_popupvalueexpect_downloadget_by_textRUTA_FOLDERsave_asleerExcelPagadas	Exceptionr+   	r   r
   rK   
page1_infopage1download_infodownloadrutaArchivoes	            r=   exportarReportePagadasr      sL     4
+;E+Bj"Z\\\12gimostt
a4a3M]^a
bbb


6(D

E
K
K
MMM
,,=
>
C
CL
QQQ
,,;
<
A
A,
OOO
,,;
<
B
B5
III  " C CjXM:@@BBBC C"""E$$&  -0177999&,,,$d9o%6h?{+++t[111    ]tbMQOICBC C C C"9,+1 g   s  I/G:I/G=I/H (I/5H6'I/H'I/H	'I/-H.I/HI/
%H/H0H4I/?H I/H+I/,H--I/0#IH/IH7(H1)&H7H3H7#H5$H7(I/3I4I/=I/ I/I/I/	I/I/I/HI/H(HH($I/-I//I1H73H75H77	I IIIII/I, I#!I,(I/c                   K   t        j                  |d       }d }t        t        |            D ]!  }d|j                  |   j
                  v s|} n |t        d      |j                  |   |_        ||dz   d  j                  d      }|j                  t              }g }|j                         D ]G  \  }}|j                         j                         sd|j
                  v r n|j                  d   d	k(  rIi 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'   }|j                  |       J t        i | dd(|d)dd*       d {    t!        d+| d+   i       d {    t#        | d,   d(|id-       d {   }	t%        | d.   d/   d0d1       d {    t'        j(                  |       y 7 i7 S7 :7  w)2Nheaderu   Pólizau)   No se encontró la cabecera con 'Póliza'r   TdroprW   r   nancompaniapotosiclave_agenter   polizatipo_polizarm   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"   rh   r$   ri   )pandas
read_excelranger,   ilocvalues
ValueErrorcolumnsreset_indexastypestriterrowsisnullanyappendr3   r(   registrarRecibosrj   r-   r0   
r
   r   df
header_rowidatos_rowregistrorespuestaReciboss
             r=   r|   r|      s    T2" *R> aBGGAJ%%%j
 
@
AA wwz""*	*q./&&D&1" 
yy~" % fa
zz|R3::-
xx{e(d>*>:  SXXa[	
 chhqk chhqk !  ! SXXa[ 388A; CHHRL sxx|  #((2,  388B<!H& 
LL7< 	  F  FHZch?k  @D  F  	G  G  G JZ0@"BDDD+d=>Qasuz_|-~  A  A 4
+;E+Bk"[]]]))K	 GD A]sO   AJ
G	J
JJ
0J1J
JJ
'J(J
J
J
J
c                 T  K   t        |d   d   dd       d {    t        d| |       d {   }|rct        i |ddd       d {    | j                  d	       d {    | j	                  d
d      j                          d {    | j                         4 d {   }| j	                  dd      j                          d {    d d d       d {    j                   d {   }|j                         4 d {   }|j                  d      j                          d {    	 |j                   d {   }t         |d    d}|j                  |       d {    t        ||       d {    d d d       d {    y y 7 7 o7 U7 ?7 7 7 7 # 1 d {  7  sw Y   xY w7 7 7 7 7 ]7 K# t        $ r3}t        d|       t        |d   d   dd       d {  7   Y d }~d }~ww xY w7 |# 1 d {  7  sw Y   y xY ww)Nr"   rh   rl   ri   rg   zObteniendo recibos por pagarrm   rB   r?   rn   zRecibos pendientes de cobrorU   rS   rp   rq   r   	_porpagarrs   r#   )rj   rN   r3   rE   r_   rZ   rv   rw   rx   ry   rz   r{   leerExcelPorPagarr}   r+   r~   s	            r=   exportarReportePorPagarr     s*     4
+;E+Bj"Z\\\12gimostt
c4c3O_`c
ddd

"
"=
111


6(E

F
L
L
NNN  " C CjXM:@@BBBC C"""E$$& 	` 	`-0177999`&,,,$d9o%6i@{+++k222	` 	` 	`  ]td1NCBC C C C"	`9,+2 `gq&j1A%1HT[(]___`	` 	` 	` 	`s{  H(FH(FH(F!H(%F$&(H(F'H('F*(H(+%F1F-F1H( F/!H(4G5H(GH(#H4G
5H:G	G
&G0G1GGG	H(HH(H(!H($H('H(*H(-F1/H(1G7F:8G?H(H(
HGGG	H#H	>H?H	H	HHH(H%HH%!H(c                 d  K   t        j                  |d       }d }t        t        |            D ]!  }d|j                  |   j
                  v s|} n |t        d      |j                  |   |_        ||dz   d  j                  d      }|j                  t              }g }|j                         D ]  \  }}|j                         j                         sd|j
                  v r n|j                  d   d	k(  rGd
| d   d   |j                  d   |j                  d   |j                  d   |j                  d   |j                  d   |j                  d   |j                  d   |j                  d   |j                  d   |j                  d   d}|j                  |        t        i | dd|ddd       d {    t!        d| d   i       d {    t#        | d   d|id       d {   }	t%        j&                  |       t)        | d   d   dd       d {    y 7 i7 S7 :7 w) Nr   Clienteu)   No se encontró la cabecera con 'Cliente'r   Tr   rW   r   r   r   r   r   rm   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"   rh   r$   ri   )r   r   r   r,   r   r   r   r   r   r   r   r   r   r   r   r3   r(   r   r-   r0   rj   r   s
             r=   r   r   ;  sG    T2" *R> aBGGAJ%%%j
 
@
AA wwz""*	*q./&&D&1" 
yy~" % fa
zz|R3::-
xx{e >*>:!((1+!XXa[HHQKHHQK!"H 
LL14 	  G  GH[di?l  AE  G  	H  H  H JZ0@"BDDD+d=>Qatv{_}-  B  B))K 4
+;E+Bk"[]]]	 HD B]sO   AH0E/H0>H(?H0H*H01H,20H0"H.#H0*H0,H0.H0c                   K   |}t        j                   |      }i }|D ]  }t        j                  |d       }d }t        t	        |            D ]!  }d|j
                  |   j                  v s|} n |t        d      |j
                  |   |_        ||dz   d  j                  d      }|j                  t              }g }	|j                         D ]  \  }
}|j                         j                         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}|	j                  |        t!        i | dt"        |	d       d {     y 7 w)Nr   u   Número de pólizau4   No se encontró la cabecera con 'Número de póliza'r   Tr   rW   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   z  s    & YYv( *  7ug			74	0B J3r7^ 	!2!2	2

 MNN $BJ	JNO		(	(d	(	3B 
3B E++- 3				rSZZ/	!	 xx{((1+88A; XXa[((2,((2,hhrlhhrlxx|XXb\""h  ll816 s4s$Lkps
ttto7un us   A+H.FHH	Hc                   K   t        i |ddd       d {    | j                         4 d {   }| j                  dd      }|j                          d {    	 |j                   d {   }t
         |d    d| }|j                  |       d {    t        i |d	d
i       d {    t        j                  d       d {    t        i |ddd       d {    d d d       d {    y 7 7 7 7 7 m7 V7 ;7 ## t        $ r}t        d       Y d }~:d }~ww xY w7 6# 1 d {  7  sw Y   y xY ww)Nz"Procesando y esperando descarga...rm   rB   rn   u   Exportar PólizasrU   r   r   r    u   Procesando informaciónr   zActualizando sistemars   )r3   rx   r_   rZ   rw   rz   r{   r]   r^   r}   r+   )r   r
   typeFiler   enlacer   r   r   s           r=   descargaEsperaReporter     sN    gg1Scdghhh!!#  }f+>?F
,,.
$***h"mDO#4AhZ@k[)))PTP>5LPQQQMM!\T\5IYZ\]]]   i*)Q]  Gnn   s   ED EDE'D3DD3"D1D2(DDD3D
4DDD*D+D/E:D1;EED3DD
DDD	D.D)$D3)D..D31E3E9D<:EEc                 N  K   t        i |ddd       d {    	 | j                  d       d {    | j                  d       d {    | j                  d       d {    | j	                  dd	      j                          d {    t        i |d
dd       d {    | j                  d      j	                  dd	      j                          d {    t        j                  d       d {    t        | |d       d {    | j                  d       d {    | j                  d       d {    | j                  d       d {    | j	                  dd	      j                          d {    t        i |d
dd       d {    | j                  d      j	                  dd	      j                          d {    t        j                  d       d {    | j	                  dd	      j                          d {    t        j                  d       d {    t        | |d       d {    	 t        i | dd       d {    y 7 X7 A7 +7 7 7 7 7 7 w7 a7 K7 57 7 7 7 7 7 d7 Q7 8w)Nu"   Obteniendo pólizas por renovar...rm   rB   4https://distribuidores.axa.com.mx/group/distribucionr?   u   text="Mostrar Pólizas"rn   u   Mostrar PólizasrU   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   rD   rE   wait_for_selectorr_   rZ   rt   r]   r^   r   check)r   r
   ejecutorr   s       r=   exportarReporteRenovacionesr     s    gg1Scdghhh0 			HIII  ///8999&89??AAA 	WW1CSTWXXXRS__`fmt_u{{}}}adD*BCCC 			HIII  ///8999&89??AAA 	WW1CSTWXXXRS__`fmt_u{{}}}a|4::<<<adD*@AAA, 	EEsEFFFc i4 J/9A Y}C J/9A Y}<A2 Gsc  J%I0J%I3J%I6J%$I9%(J%I<J%'I?(7J%J J%<J=J%JJ%*J+J%JJ%J(J%JJ%J 7J%JJ%4J5(J%JJ%:J;J%J!J%*J#+J%3J%6J%9J%<J%?J%J%J%J%J%J%J%J%J%J%J%J%J%!J%#J%c                   K   t        j                  |d       }dddddddd	d
d	}i }|j                         D ]`  }|j                  |g      j	                         }||   j
                  d   }|||   j                  |g         j
                  d   }||f||<   b i }	|j                         D ]F  \  }\  }}|j                  ||j                  j                  |      dz   f   }
||   }|
dk7  r|
nd|	|<   H d }t        t        |            D ]!  }d|j                  |   j                  v s|} n |t        d      |j                  |   |_        ||dz   d  j                  d      }|j                  t               }g }|j#                         D ]  \  }}|j%                         j	                         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 }|j'                  |        t)        i | d|	|d!       d {    y 7 w)"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   rW   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  ,  s    T2" #'
 !',,. ?m-1557 !34::1=Gbk/066q9D04gm,	? ,(A(G(G(I @$m_dGGGD"**,,W599:E"=1K).%RL	@ *R> a"""j
 
=
>> wwz""*	*q./&&D&1" 
yy~" % fa
zz|R3::-
xx{e XXa[hhqk!88A;HHRLHHRLXXb\88B<xx|xx|H  
LL16 	pp,hmpqqqs   D(K+FK;K<Kc                   K   t        |d   d   dd       d {    t        d| |       d {   }|rt        i |ddd       d {    t        d	|d	   i       d {    | j	                  d
      j                  d       d {    | j                  d       d {    | j	                  d      j                  |d   d          d {    | j	                  d      j                          d {    | j                         4 d {   }	 |j                   d {   }|j                  d       d {    t        j                  d       d {    |j                  d       d {   }t        j                  d|      }|r#|j!                  d      }|j"                  j%                  d|        d {   }|d    d|d   d    d}	t&         |	 }
t)        |
d      5 }|j+                  |j-                          d {          t/        t&         |	 |	       d {    t        i |dddd|d   d   |d   d   |	dd       d {    t        d	|d	   i       d {    t        |d   d   dd       d {    |j1                          d {    d d d        d d d       d {    y y 7 7 7 7 o7 J7 47 	7 7 7 7 7 7 w7 *7 7 7 7 7 h7 R# 1 sw Y   QxY w# t2        $ rK}t5        d|       | j	                  d      j7                          d {  7  }|rt5        d        Y d }~d }~ww xY w7 # 1 d {  7  sw Y   y xY ww)!Nr"   rh   rl   ri   r   u   Obteniendo póliza y recibosrm   rB   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wbrW   Ttype)r   r  r  nombre_numero_polizar    rC   r   descargar$   ERz.portlet-msg-erroruF   El elemento con class='portlet-msg-error' está visible en la página.)rj   rN   r3   r(   rt   select_optionrZ   r[   rv   rw   rE   r]   r^   rF   researchgrouprequestr&   rz   openwritebodysubirArchivoAS3closer}   r+   
is_visible)r   r
   rK   r   r   onclick_valuematchrJ   responsenombrePolizar   fr   r,  s                 r=   obtenerDocumentoPolizar2    s     4
+;E+Bj"Z\\\12hjnptuu
c4c3O_`c
ddd
"j$z2B$D
FFF
,,A
B
P
PQg
hhh
**6
777
,,8
9
>
>tJ?OP_?`
aaa
,,:
;
A
A
CCC  " Z ZjZ &&&''666mmA $nn .   		3]C++a.C"]]..1KC5/QRRH"9o.htJ7G7X6YY]^L(M,8Kk4( "AggHMMO+,#{mL>$BL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|  #~      ,
D<L.NPPP,tJ7G7NZe.giiiKKM!!"'Z Z Z  ]udFh7aCZ&6 S ,Q Pi!" "  ZdA<<(<=HHJJJ

X
Y	Z7Z Z Z Zs  M:K
M:KM:KM:$K%'M:KM:%K&-M:K&M::K;M:K"M:M%L(K%)LK(LK+L7K.8ALK1+L3L K4L 2K63,L K8 L 7K:8L K<L +K>,L 0L8M:M#M:M:M:M:M:M:M:M:"M:%L(L+L.L1L4L 6L 8L :L <L >L  L		L	M .MMMM%M  M%#M:%M7+M.,M73M:c                   K   t        |d   d   dd       d {    t        d| |       d {   }|
rt        i |d|d   d    dd	       d {    t        d
|d
   i       d {    | j	                  d       d {    | j                  d      j                          d {    t        j                  d       d {    | j                         4 d {   }| j                  dd      j                          d {    d d d       d {    j                   d {   }|j	                  d       d {    |j                  d      j                          d {    t        j                  d       d {    |j                  d      j                  d       d {    t        j                  d       d {    |j                  dd      j                          d {    t        j                  d       d {    |j                  d       d {    t        j                  d       d {    |j                  d       d {    t        j                  d       d {    |j                  j!                  d       d {    |j                  j#                  |d   d          d {    |j%                  d       d {   }|r|j                  d       d {    t        j                  d       d {    |j                  j!                  d       d {    |j                  j#                  |d   d   dd         d {    |j'                  d      j                          d {    n|j'                  d      j                          d {    t        j                  d       d {    |j                  dd      j'                  d d      j                          d {    |j                  dd      j'                  d d      j                  d!       d {    t        j                  d       d {    |j                  d"d#      j                          d {    t        j                  d       d {    |j                  dd      j'                  d d      j                          d {    |j                  d       d {    t        j                  d       d {    |j                  j!                  d       d {    |j                  j#                  |d   d          d {    |j'                  d      j                          d {    |j                  d$d%      j                          d {    t        j                  d       d {    |j                  dd%      j'                  d%      j                          d {    t        j                  d       d {    |j                  d&d'      j)                          d {   }t+        d(|       |d)k(  rt+        d*       |j                  d       d {    t        j                  d       d {    |j                  d       d {    t        j                  d       d {    |j                  j!                  d       d {    t        j                  d       d {    |j                  j#                  d+       d {    |j                  d,       d {    t        j                  d       d {    |j                  j!                  d       d {    |j                  j#                  |d   d   dd         d {    |j'                  d      j                          d {    |j                  d&d'      j-                          d {    t        j                  d       d {    |j                  d-      j                          d {    |j/                         4 d {   }	 |j'                  d.      j                          d {    t        i |d/dd	       d {    |j                   d {   }|d0    d1|d   d    d2}	t0         |	 }
|j3                  |
       d {    t5        t0         |	 |	       d {    d d d       d {    t        j                  d       d {    |j                  d&d'      j-                          d {    t        j                  d       d {    |j                  d4      j                          d {    |j/                         4 d {   }	 |j'                  d.      j                          d {    |j                   d {   }|d0    d5|d   d    d2}t0         | }
|j3                  |
       d {    t5        t0         | |       d {    d d d       d {    t        i |d6ddd |d   d7   |d   d   	d8d9       d {    t        d
|d
   i       d {    t        |d   d   d:d       d {    y y 7 
7 
7 
7 
t7 
^7 
:7 
 7 

7 	7 	# 1 d {  7  sw Y   	xY w7 	7 	7 	7 	7 	c7 	I7 	#7 		7 7 7 7 7 7 c7 M7 57 7 7 7 7 7 n7 77 7 7 7 7 n7 X7 >7 7 7 7 7 7 _7 E7 7 7 7 7 7 7 h7 H7 27 7 7 7 7 7 k7 G7 17 7 7 7 7 # t6        $ r}t+        d3|       Y d }~d }~ww xY w7 # 1 d {  7  sw Y   xY w7 7 7 l7 H7 27 7 7 7 # t6        $ r}t+        d3|       Y d }~d }~ww xY w7 # 1 d {  7  sw Y   xY w7 7 7 w);Nr"   rh   rl   ri   r   u,   Procesando recibos y facturas de la póliza r  r   rB   r   r?   z#menu_mgestionrn   u   Factura electrónica CFDI 3.3 /rU   z
Filtrar...z	firma axaXT)exactrm   zec-button[title="Filtrar"]u   text="AXA No. Póliza"ro   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mainrW   u   axa número deoptionu   AXA Número de reciborS   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  rs   zCFDI40_CORE/LISTADO_REFERENCIAS	_recibos_zRecibos y facturas disponiblesr  )r   r  r  nombre_facturanombre_numero_recibor  r$   )rj   rN   r3   r(   rE   rt   rZ   r]   r^   rv   r_   rw   rY   r[   ry   keyboardru   r  r,  get_by_labelcountr+   dblclickrx   rz   r{   r*  r}   )r   r
   rK   r   r   elemento_existeelemento_vigenter   r   nombreFacturar   r   nombreRecibos                r=    obtenerDocumentoRecibosYFacturasrL    s?     4
+;E+Bj"Z\\\12hjnptuu
  W4  W3_`deo`p  rA  aB  `C  2D  ST  W  X  X  X
"j$z2B$D
FFF

"
"=
111
,,'
(
.
.
000
--
  " U UjV*KLRRTTTU U"""E

#
#M
222

"
"<
0
6
6
888
--


"
"<
0
5
5k
BBB
--



Ct

,
2
2
444
--

++2
333
--

++.
///
--

..

u
%%%
..

d:.?
@@@!,,-z{{OKK6777MM!NN  '''NNZ 0 A"# FGGGy)//11189??AAAMM!f+DERRSU]aRbhhjjjf+DERRSU]aRbgghxyyyMM!h-DEKKMMMMM!f+DERRSU]aRbhhjjjKK6777MM!NN  '''NNZ 0 ABBBy)//111


H7

3
9
9
;;;
--



F

1
>
>w
G
M
M
OOO --
"..z	.JPPRR	
%'781()KK4555MM!KK6777MM!NN  '''MM!NN$$$KK1222MM!NN  '''NNZ 0 A"# FGGGy)//111


JY

7
@
@
BBB
--



E
F
L
L
NNN$$& 
 
-	  -33555ftf7Rbcfggg&,,,	?+9T*5Eo5V4WW[\$m_5{+++m_=}MMM
 
 --



JY

7
@
@
BBB
--



=
>
D
D
FFF$$& 	 	-  -33555&,,,y/*)D4D_4U3VVZ[$l^4{+++l^<lKKK	 	   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  t  u  u  u
"j$z2B$D
FFF
"T*-=e-DP[$]
___g  ]u XF10UTU U U U"28B43/%@{7'G1AjyMj7'B1;O R
 67'$2'G1BN
5g, 	,M gq
 
 
 
 BF	5, 	,K gq	 	 	 	 uF_ss  qkqk%qkq-k!.qk$&q-k'.q
k*q#k-$q'%k6k0k6qk3q0l1q	l
&q0l1ql'q5l6ql(q;l<ql!q1l$2ql'q'l*(ql-"q'l0((ql3q)l6*ql9q!l<""ql?+q0m1&qm(q mqm9qm:qmq/m0(qmq5m69q/m0qm 	q%m#&"qm&	(q1m)2&qm,(qm/qm27qm5q3m84(qm;5qm>q/n0qn	q%n&"qn
	q%n&"qn	q!n"q>n?"q!n"+qn&q4n5(qn"q:n%;&q!n("q:n+;q>o# "n="n.#n=<n1=n=n43n=n7n= n:!n=%q0o 1qo9(q6o<7qo?&q:p;qpqp:"p;p<pp3pppp p$q/p70-qqq5q6qqqqq!q$q'q*q-q0k63q6l	<k?=l		qqqqqqq!q$q'q*q-q0q3q6q9q<q?qqqqqqqqqqq q#q&q)q,q/q2q5q8q;q>qqqq
qqqqqqqq"q%q(q+q.n=1n=4n=7n=:n==	ooo#oo# q#o6)o,*o61	q<q?qqqpppp	p4p/)p:/p44p:7q:q qq	qqqc                 ^  K   | j                  d       d {    d}t        |ddd      }|j                         }|j                  dk7  rt	        |j                        |d   d	    d
|d   d    d|d   d    d}d|d    }|j                  ||      }	d}
t        j                  |
 |d    d|d   d    d      }|j                          d|d    d|d   d    d}t        |d      5 }|j                  |j                         d d d        |j                  ||dd       t        j                  |       d}
t        j                  |
 |d    d|d   d    d      }|j                          d|d    d|d   d    d}t        |d      5 }|j                  |j                         d d d        |j                  ||dd       t        j                  |       	 |j                          y 7 # 1 sw Y   xY w# 1 sw Y   SxY w# t        $ r}t!        d|       Y d }~y d }~ww xY w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://wsoft0.s3.us-west-1.amazonaws.com/segurocotizas/automatizador/r   rA  r"   r  r  z./r  zRECIBOS.pdfrW   r  z
POLIZA.pdfzERROR CLIENT)rE   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resultrJ   	respuestaruta_destinor   r   s                  r=   notificarAClienteRecibore  G  s      ///,i%[`a'==?& ]]k!gmm$$	*++RS[\bScdlSmRn  oA  BJ  KQ  BR  S\  B]  A^  ^^  _'x
+,-, ??<1& 	Q#llcU4	?"39T*=Mo=^<__cde) d9o&iZ0@0Q/RRVW,L$ %7MM)##$% 	//,mR@))L 	Q#llcU4	?"38D<L_<];^^bcd) d9o&htJ/?/P.QQUV,L$ %7MM)##$% 	//,lB?))L
LLN] 0.% %% % 
 	.!sk   H-G0CH-.G3
BH-G?-1H-H /H-3G<8H-?HH-	H*H% H-%H**H-c                    K   d}t        ||d   d   |d          d{   }t        |       	 t        |d   d   dd       d{    y7 -7 w)	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   Nrh   r$   ri   )leerPotosiVidar+   rj   )r   r
   r   datos_reciboss       r=   obtenerDatosClienteri  }  sk      m+&T*5Eo5VX\]gXhjj-< 	!4
+;E+Bk"[]]]E kD ^s!   AA'AAAA) r]   r-   sysr   rY  r#  r   r   r   WPP_Whatsappr   utilslectoresr   rz   rH   r6   rN   rI   r   r   r|   r   r   r   r   r   r  r2  rL  re  ri       r=   <module>rp     s    3 3 3 3 (    xV+H+=Mg`.!F`(2>B`:4^nBuH$RGhTrx+ZZv`r2l-^ro  