
    
Sh                     .   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 d dlm	Z	 d dl
T d dlmZ 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adada	 d Z	 d Zd Zd Z	 d Zd ZddZ d Z!d Z"ddZ#d Z$d Z%	 d Z&d Z'ddZ(d Z)dS )     N)datetime)Create)*)relativedelta)platform)TimeoutErrordarwinzD/Users/wsoft/Documents/wsoft.com.mx/carteraplus-automatizador/files/z6/var/www/wsoft.com.mx/carteraplus-automatizador/files/z.https://portalintermediarios.gnp.com.mx/sesionFc                   K   |                      dd          }|                      dd          }|                      dd          }|                      dd          }|                      dd          }|                      dd          }|                      dd          }|d	k    r t          |d
         dd           d {V  dS t          d
|d
         i           d {V  |d         |d<   |d         |d<   |dk    r$t          |d         |d
         d           d {V }t	          |d                    d {V \  }}		 t          dt          |                      t          |          dk    rV|d         d         dk    rD|d          }
t          j        	                    d|
 d          rt          j
        d|
 d           t          |          dk    rt          |d
         dd           d {V  |dk    r|d         }|d          }
d|
 d}t          j        	                    |          rOt          j                    }t          j                            |          }||z
  dk    rt          j
        |           t          ||
           d {V \  }}}t          d
|d
         i           d {V  |D ]n}t                                           |d                   }t!          |          r||d<    |||           d {V  Pt          |d
         dd           d {V  o|dz   | d<   d| d<   || d<   || d<   || d<   t#          |            d {V  n8t          |d
         dd           d {V  |durt%          ||           d {V  t          |          dk    rWt          |	          dk    rFt          |d
         dd           d {V  t'          |d
         |d         d            d {V  d S d S d S )!NdataFconexionprimeraEjecucionpbrowserpagereconteo   id_tarea	err_bucler   statusid_conexionsessioncredenciales)r   r   	subtareaszSUBTAREAS TOTALES    r   funcionverificaLoginSesion../sessions/.jsonsiTocultarNavegadoriX  subtareaerr_f	terminador   r   )getactualizarStatusTareaactualizarConteoUsoTareaobtenerDatosConexionorganizaSubtareasprintlenospathexistsremove actualizarStatusNavegadorAbiertotimegetmtimeinicializarPlaywrightglobalscallableejecutarProcesosGnpcerrarPlaywrightactualizarFechaLogin)
parametrosr   r   r   r   r   r   r   subtareasNavegadorsubtareasWhatsappr   r!   session_filetiempo_actualmodificacion_session_fileitemr   s                    =/var/www/wsoft.com.mx/carteraplus-automatizador/python/gnp.pyr7   r7      s0      nnVU33$ nnZ77( nn%7?? nnS%00! nnY66' nnVU33$ nnZ77( !mm
tJ/?;!W!W
Z
ZZZZZZZZ5 JZ0@"BDDDDDDDDD'$y/!&)$~ %)D<O]abl]m+o+oqqqqqqqqH 1B(;BW0X0X*X*X*X*X*X*X'' 8S"46688999	
""!Y'+@@@&(g	5w555	6	6 1
	////000	
!! +$z:JVZ,\,\
^
^^^^^^^^ 	D  01&(g2G222l		%	% "	$&G$4$4\$B$B!44s:: )L
!
!
!45EwOOOOOOOOa$ %
D4D&FHHHHHHHHH" f f		d9o..g	'		 fZgdD!!!!!!!!!! /d:>NZa0b0beeeeeeeeee&.lJz%*J!"%&JsO%,Jy%)Jv
j
)
)))))))))
*$z:JVa,b,b
e
eeeeeeee	Q(((((((((	
""s+<'='='B'B
tJ/?;!W!W
Z
ZZZZZZZZ
d:.>tTaOb d d
f
ffffffffff #"'B'B    c                   K   d}d}da |                    | d           d {V  |                    d           d {V  t          d|d         i           d {V  |                    dd	                                           d {V }|d
k    rCt          d           t          j        d           d {V  |	                    d          
                                 d {V  t          j        d           d {V  |                    d          
                                 d {V  t          j        d           d {V  |                    d          
                                 d {V  t          j        d           d {V  |                    dd          
                                 d {V  t          ||           d {V }|                    d           d {V }|                    t                     dk    r|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           d {V  nd}|S )NFT逩 timeoutnetworkidler   divzwarningServicio temporalmentehas_textr   z)GNP SERVICIO NO DISPONIBLEEEEE!!!!!!!!!!!   closez.perfil-cardu   Cerrar sesiónbuttonname() => window.location.hrefzINICIANDO SESION...r   loginMessage	conectador   r%   )estoyEnCobranzagotowait_for_load_stater(   locatorcountr+   asynciosleepget_by_labelclickget_by_textget_by_roleiniciar_sesionevaluatefindurlLoginenviarMensajer9   )urlr   r   sesionIniciadacontinuaOperacionelementCount
url_actuals          rA   validar_inicio_sesionrj   ~   s     ./ 			#f	%%%%%%%%%  ///////// JZ0@"BDDDDDDDDD||E4S|TTZZ\\\\\\\\,A	
5666
-




G
$
$
*
*
,
,,,,,,,,
-


,,~
&
&
,
,
.
........
-




+
,
,
2
2
4
44444444
-




8*:

;
;
A
A
C
CCCCCCCC)$55555555N ]]#?@@@@@@@@*__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IIc&I))))))))))	rB   c                 X  K   d}|d         }|d         d         }|d         d         }t           j                            d| d          rt          j        | d           |                     d           d {V }|                    t                    d	k    r |                     t                     d {V  |                     d
          	                    |           d {V  |                     d          	                    |           d {V  t          j        d           d {V  |                     dd                                           d {V  d}t          j        d           d {V  	 |                     d                              d                              d          }|                                 d {V dk    rd}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 |                     dd"          j                            d#$           d {V  |                     d           d {V }|                    t                    d	k    rSt5          i |d%dd&           d {V  t          j        d           d {V  t5          i |d'dd&           d {V  nD| j                            d(| d)           d {V  t5          i |d'ddd*           d {V  d}|S )+NFr   r   campo1campo2z./r   rP   rQ   u   Correo Electrónicou   ContraseñarK   rM   u   Iniciar sesiónrN   r   rH   zcloseNo se puede iniciar sesirI   r   r   T	id_accesor   clave_agenteidentificadorsublicencia)rn   r   ro   rp   rq   r"   _iderr_sessionrr   r   r   u   Procesando información...hiddenstatezERROR DE INICIO DE SESION.rR    r   )r.   )rS   rT   saveSession)r-   r.   r/   r0   ra   rb   rc   rV   r\   fillrZ   r[   r_   r]   rX   filternthrY   	ExceptionnotificarErrorSesionactualizarStatusSubtarear'   sysexitfirstwait_forrd   contextstorage_state)r   r   rf   r   usuariopasswordri   errorSesionrX   enotificacions              rA   r`   r`      s     .&''1''1( W^^''''(( !I   ]]#?@@@@@@@@*__X"$$
))H

/0055g>>>>>>>>>-((--h777777777 	a(9::@@BBBBBBBBB+all5!!((2Q(RRVVWXYYG]]__q  kk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 ,,u'C,
D
D
J
S
SZb
S
c
cccccccc}}%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 
G4(G//G4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   mensaje6https://portalintermediarios.gnp.com.mx/home/dashboardr   r%   u   ¡Sesión validada con éxito!r"   rr   r$   rt   zDatos incorrectos)rd   rj   r9   r   )r   r   rg   s      rA   r   r      s       D  DT-EX  fB  D  D  D  	E  	E  E  E  E  E  E  E  E12jlprvwwwwwwww `
d:.>tTaOb d d
f
ffffffff
  J4  J$tMGZ  hH  J  J  J  K  K  K  K  K  K  K  K  K
"T*-=e-DP[$]$]
_
__________ |4|$tMGZgz|||
}
}}}}}}}}
"T*-=e-DP[$]$]
_
__________rB   c                   K   t          |d         d         dd           d {V  t          du rt          d| |           d {V }nd}|rt          du rt          dd	          \  }}}|                     d
                              t          j        d                                                     d {V  | 	                    d          
                    d           d {V  t          j        d           d {V  |                     d                                           d {V  |                     d                                           d {V  t          j        d           d {V  |                     d                              d                              d                                           d {V  t          j        d           d {V  |                     d                              d                              d                                           d {V  t          j        d           d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              d                                           d {V  da	 |                     d                              d                              dd                                            d {V  |                     d!"          4 d {V }|j         d {V }t,           |d#          d$}|                    |           d {V  t1          ||           d {V  d%ad d d           d {V  d S # 1 d {V swxY w Y   d S # t4          $ rz t2          dz   at2          d&k    r6t          |d         d         d'd           d {V  t7          d(           Y d S t7          d)t2                     t9          | |           d {V  Y d S w xY wd S )*Nr"   rr   iniciadort   Fr   T   %Y-%m-%drH   ^search$rI   Buscar productos,adminisr   searchBuscar'   Administración de Carterachevron_right   #inlineFrameExample$iframe[name="AdministracionCartera"]Reportes   Relación de Recibosselect[name="diaDesde"]-rK   select[name="mesDesde"]select[name="mesHasta"]select[name="diaHasta"]radioimgExportar a Excel PlanorN   rD   rE   r   _cartera_porpagarr   r   err_loop_p_pagar-YA NO SE PUEDE HACER NADA, timeout, por pagar0HUBO UN TIMEOUT, SE VUELVE A EJECUTAR. POR PAGAR)r   rU   rj   obtenerFechasEnRangorX   r{   recompiler]   get_by_placeholderrz   rZ   r[   r^   frame_locatorselect_optionsplitr_   r|   checkexpect_downloadvalueRUTA_FOLDERsave_asleerExcelPorPagarloopReintentosCobranzar   r+   exportarReportePorPagar	r   r   rg   fecha_proximafecha_anteriorhoydownload_infodownloadrutaArchivos	            rA   r   r      s	      	!4
+;E+Bj"Z"Z\\\\\\\\\34lnrtxyyyyyyyy )2%+?:+N+N(m^SLL&&
;0G0G&HHNNPPPPPPPPP##$788==iHHHHHHHHHM!^,,22444444444FGGMMOOOOOOOOO M!455CCDlmmyy  {E  F  F  L  L  N  N  N  N  N  N  N  N  NM!455CCDlmmyy  {Q  R  R  X  X  Z  Z  Z  Z  Z  Z  Z  Z  ZM!455CCDlmmuu  wR  S  S  a  a  bp  bv  bv  wz  b{  b{  |}  b~                  455CCDlmmuu  wR  S  S  a  a  bp  bv  bv  wz  b{  b{  |}  b~                  455CCDlmmuu  wR  S  S  a  a  bo  bu  bu  vy  bz  bz  {|  b}  ~  ~  ~  ~  ~  ~  ~  ~  ~455CCDlmmuu  wR  S  S  a  a  bo  bu  bu  vy  bz  bz  {|  b}  ~  ~  ~  ~  ~  ~  ~  ~  ~455CCDlmmyy  {B  C  C  G  G  HI  J  J  P  P  R  R  R  R  R  R  R  R  Ro2455CCDlmmyyz  G_y  `  `  f  f  h  h  h  h  h  h  h  h  h%%f%55 # # # # # # #&,,,,,,,$Hd9oHHH{+++++++++k222222222!"# # # # # # # # # # # # # # # # # # # # # # # # # # # # # #  2 2 2 6 :	!	#	#&j1A%1HTf(h(hjjjjjjjjj=>>>>>>@BXYYY%dD1111111111112E)2 )2s?   1A1U "AU5U 
UU UU AW0+WWc                   K   t          |d         d         dd           d {V  t          du rt          d| |           d {V }nd}|r?t          du rt          dd	          \  }}}|                     d
                              d                                           d {V  |                     d
                              d                                           d {V  |                     d                              d          j                                         d {V  |                     d                              d          j        	                    d           d {V  |                     d                              d          j        	                    d           d {V  t          j        d           d {V  |                     d                              d
                              d          j                                         d {V  |                     d                              dd                                           d {V  |                     d                              d                              d                              d                                           d {V  |                     d                              dd                              | d           d {V  |                     d                              d                              d                               d                                           d {V  |                     d                              d!                              | d           d {V  t          j        d           d {V  |                     d                              dd                                           d {V  da	 |                     d"#          4 d {V }|                     d                              dd$                                           d {V  |j         d {V }t$           |d%          d&}|                    |           d {V  t)          ||d'           d {V  d(ad d d           d {V  d S # 1 d {V swxY w Y   d S # t,          $ rz t*          dz   at*          dk    r6t          |d         d         d)d           d {V  t/          d*           Y d S t/          d+t*                     t1          | |           d {V  Y d S w xY wd S ),Nr"   rr   r   rt   Fr   T   %d-%m-%Yabusiness_centerrI   Cobranzamat-cardConsulta y pago de recibosr   .cdk-overlay-backdropvisiblerv   ru   r   u   Pólizas pendientesrM   FILTRARrN   rH   Desde:r   z
DD-MM-AAAA)exact_Hasta:z DD-MM-AAAArD   rE   XLSr   _cartera_porpagarv2rK   r   r   r   r   )r   rU   rj   r   rX   r{   r]   r   r   r   rZ   r[   r_   r|   r   rz   r   r   r   r   r   r   r   r+   exportarReportePorPagarV2r   s	            rA   r   r   -  s      	!4
+;E+Bj"Z"Z\\\\\\\\\34lnrtxyyyyyyyy '4%+?J+O+O(m^SLL$$.?$@@FFHHHHHHHHHLL$$j$99??AAAAAAAAALL$$++5Q+RRX^^`````````455==>UVV\eeluevvvvvvvvv455==>UVV\eelteuuuuuuuuuM!455==cBBIIShIiiouuwwwwwwwww455AA(QZA[[aaccccccccc455==eDDKKU]K^^bbcdeekkmmmmmmmmm455HH]aHbbggkyh|h|h|}}}}}}}}}455==eDDKKU]K^^bbcdeekkmmmmmmmmm455HHWW\\`m]p]p]pqqqqqqqqqM!455AA(QZA[[aaccccccccco4%%f%55 # # # # # # #  !677CCHSXCYY__aaaaaaaaa&,,,,,,,$Jd9oJJJ{+++++++++k1555555555!"# # # # # # # # # # # # # # # # # # # # # # # # # # # # # #  4 4 4 6 :	!	#	#&j1A%1HTf(h(hjjjjjjjjj=>>>>>>@BXYYY'd3333333333334A'4 '4s>   -T 	BS2T 2
S<<T ?S< T AV	+V	V	r   c                   K   t          j        |          }|                    t                    }g }|                                D ]?\  }}|                                                                s	d|j        v r n	|dk    ri d|ddd| d         d         d|j        d	         d
|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d          d!|j        d"         d#|j        d$         i}n t          |j        d                   \  }}	i d|ddd| d         d         d|j        d         d
|j        d	         d%|j        d         d|j        d         dt          |j        d                   d|j        d         dddt          |j        d                   dt          |j        d                   ddd|d|d|	d|j        d         d&k    rd'nd(d|j        d         d)}|                    |           At          d*| d*         i           d {V  t          | d+         d,|id-           d {V }
t          | d.         d/         d0d1           d {V  d S )2Nrx   r   tipocompaniagnpro   r   clienter   polizaplanrK   vencimiento_recibor   status_recibor   fecha_pago_recibo   inicio_vigencia   fin_vigenciar   year_poliza   prima_anual	   prima_fraccionada
   moneda   conducto   f_pago   	asegurado   numero_reciboIntermediarioBANCOAGENTEr   r   r   r   arrGnpPorPagarr   reportesr"   rr   r$   rt   pandas
read_excelastypestriterrowsisnullanyvaluesilocformateaMontoYMonedaGNPformatearFechaGNPappendr(   registrarRecibosr   r   r   r   dfdatosr   rowregistromontor   respuestaReciboss              rA   r   r   _  s     %%" 
yy~~" % 5 5fa
zz|| R3:--eqyy 	^ 4^ D 		
 	 	 	 	 	 	 	 	 	 	 	  	!" 	#$ 	% hh* .chqk::meV 	^ 4^ D 		
 	 	 	 	 1#(1+ > > 	 	 	 1#(1+ > > 	 1#(1+ > > 	  	!" 	#$ 	%& 	38A;/+I+Ix'( !# #+  h0 
LL
 	!JZ0@"BDDDDDDDDD+d=>Qaqsx_z-|-|~~~~~~~~ 4
+;E+Bk"["[]]]]]]]]]]]rB   c                 0  K   t          |d         d         dd           d {V  t          du rt          d| |           d {V }nd}|rt          du rt          dd	          \  }}}|                     d
                              t          j        d                                                     d {V  t          j
        d           d {V  |                     d                              d           d {V  t          j
        d           d {V  |                     d                                           d {V  |                     d                                           d {V  t          j
        d           d {V  |                     d                              d                              d                                           d {V  t          j
        d           d {V  |                     d                              d                              d                                           d {V  t          j
        d           d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              |                    d          d                    d {V  |                     d                              d                              d                              |                    d          d                    d {V  t          j
        d           d {V  |                     d                              d                              d                              d                                           d {V  |                     d                              d                              dd !                              d"#           d {V  	 |                     d"#          4 d {V }|j         d {V }t,           |d$          d%}|                    |           d {V  t1          ||           d {V  dad d d           d {V  d S # 1 d {V swxY w Y   d S # t4          $ rz t2          dz   at2          d&k    r6t          |d         d         d'd           d {V  t7          d(           Y d S t7          d)t2                     t9          | |           d {V  Y d S w xY wd S )*Nr"   rr   r   rt   Fr   Tr   r   rH   r   rI   r   r   r   r   r   r   r   r   r   r   r   r   rK   r   r   r   r   r   r   r   rN   rD   rE   r   _cartera_pagadar   r   r   r   )r   rU   rj   r   rX   r{   r   r   r]   rZ   r[   r   rz   r^   r   r   r   r_   r|   r   r   r   r   r   leerExcelPagadasr   r   r+   exportarReportePagadasr   s	            rA   r  r    s]	      	!4
+;E+Bj"Z"Z\\\\\\\\\34lnrtxyyyyyyyy ,1%+?:+N+N(m^SLL&&
;0G0G&HHNNPPPPPPPPPM!##$788==iHHHHHHHHHM!^,,22444444444FGGMMOOOOOOOOO
 M!455CCDlmmyy  {E  F  F  L  L  N  N  N  N  N  N  N  N  NM!455CCDlmmyy  {Q  R  R  X  X  Z  Z  Z  Z  Z  Z  Z  Z  ZM!455CCDlmmuu  wR  S  S  a  a  bp  bv  bv  wz  b{  b{  |}  b~                  455CCDlmmuu  wR  S  S  a  a  bp  bv  bv  wz  b{  b{  |}  b~                  455CCDlmmuu  wR  S  S  a  a  bo  bu  bu  vy  bz  bz  {|  b}  ~  ~  ~  ~  ~  ~  ~  ~  ~455CCDlmmuu  wR  S  S  a  a  bo  bu  bu  vy  bz  bz  {|  b}  ~  ~  ~  ~  ~  ~  ~  ~  ~M! 

2
3
3
A
ABj
k
k
w
wx  A  A  E  E  FG  H  H  N  N  P  P  P  P  P  P  P  P  P


2
3
3
A
ABj
k
k
w
wx}  E]
w  ^  ^  d  d  ms  d  t  t  t  t  t  t  t  t  t1%%f%55 # # # # # # #&,,,,,,,$Fd9oFFF{+++++++++t[111111111!"# # # # # # # # # # # # # # # # # # # # # # # # # # # # # #  1 1 1 6 :	!	#	#&j1A%1HTf(h(hjjjjjjjjj=>>>>>>@BXYYY$T40000000000001K,1 ,1s>   :V AU<)V <
VV 	V
V AX$+XXc                 x  K   t          |d         d         dd           d {V  t          du rt          d| |           d {V }nd}t          dd	          \  }}}|rt          du rp|                     d
                              d                                           d {V  |                     d
                              d                                           d {V  |                     d                              d          j                                         d {V  |                     d                              d          j        	                    d           d {V  |                     d                              d          j        	                    d           d {V  t          j        d           d {V  |                     d                              d
                              d                                           d {V  |                     d                              d          	                    d           d {V  |                     d                              d          	                    d           d {V  t          j        d           d {V  t          du rB|                     d                              dd                                           d {V  |                     d                              d                                           d {V  |                     d                              d                              | d           d {V  t          j        d           d {V  |                     d                              dd                                           d {V  t          j        d           d {V  |                     d                              d                                           d {V  |                     d                              d                              | d           d {V  |                     d                              dd                                           d {V  	 |                     d           4 d {V }|                     d                              dd!                                           d {V  |j         d {V }t$           |d"          d#}|                    |           d {V  t)          ||d$           d {V  d%adad d d           d {V  d S # 1 d {V swxY w Y   d S # t,          $ rz t*          dz   at*          d&k    r6t          |d         d         d'd           d {V  t/          d(           Y d S t/          d)t*                     t1          | |           d {V  Y d S w xY wd S )*Nr"   rr   r   rt   Fr   Tr   r   r   r   rI   r   r   r   r   r   r   rv   ru   r   u   Pólizas pagadasrM   r   rN   r   r   cellzFILTRAR XLS CSVr   rD   rE   r   r   _cartera_pagadav2rK   r   r   r   r   r   )r   rU   rj   r   rX   r{   r]   r   r   r   rZ   r[   r_   r^   r\   rz   r   r   r   r   r  r   r   r+   exportarReportePagadasV2r   s	            rA   r  r    s      	!4
+;E+Bj"Z"Z\\\\\\\\\34lnrtxyyyyyyyy';B
'K'K$- 03%LL$$.?$@@FFHHHHHHHHHLL$$j$99??AAAAAAAAALL$$++5Q+RRX^^`````````455==>UVV\eeluevvvvvvvvv455==>UVV\eelteuuuuuuuuuM!


2
3
3
;
;C
@
@
G
GQc
G
d
d
j
j
l
llllllll


2
3
3
;
;<S
T
T
]
]dm
]
n
nnnnnnnn


2
3
3
;
;<S
T
T
]
]dl
]
m
mmmmmmmm
-

 %455AA(QZA[[aaccccccccc


2
3
3
?
?
I
I
O
O
Q
QQQQQQQQ


2
3
3
@
@
J
J
O
OSaPdPdPd
e
eeeeeeee
-




2
3
3
?
?M^
?
_
_
e
e
g
gggggggg
-




2
3
3
?
?
I
I
O
O
Q
QQQQQQQQ


2
3
3
@
@
J
J
O
OS`PcPcPc
d
dddddddd


2
3
3
?
?y
?
Y
Y
_
_
a
aaaaaaaa3%%f%55                !677CCHSXCYY__aaaaaaaaa&,,,,,,,$Hd9oHHH{+++++++++t[!444444444!"                                                             3 3 3 6 :	!	#	#&j1A%1HTf(h(hjjjjjjjjj=>>>>>>@BXYYY&tT2222222222223S03 03s>   V3 5BV V3  
V**V3 -V*.V3 3AX7+X76X7c                   K   t          j        |          }|                    t                    }g }|                                D ]W\  }}|                                                                s	d|j        v r n!|dk    ri d|ddd| d         d         d|j        d	         d
|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d         d|j        d          d!|j        d"         d#|j        d$         i}nt          |j        d                   \  }}	i d|ddd| d         d         d|j        d         d
|j        d	         d%|j        d         d|j        d         dt          |j        d                   d|j        d         dt          |j        d                   dt          |j        d                   dt          |j        d                   ddd|d|d|	d|j        d         d&k    rd'nd(d|j        d         d)}|                    |           Yt          d*| d*         i           d {V  t          | d+         d,|id-           d {V }
t          | d.         d/         d0d1           d {V  d S )2Nrx   r   r   r   r   ro   r   r   r   r   r   rK   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   arrGnpPagadasr   r"   rr   r$   rt   r   r  s              rA   r  r  $  s     %%" 
yy~~" % 4 4fa
zz|| R3:--eqyytu 	^ 4^ D 		
 	 	 	 	 	 	 	 	 	 	 	  	!" 	#$ 	% hh, .chqk::meV 	^ 4^ D 		
 	 	 	 	 1#(1+ > > 	 	 1#(1+ > > 	 1#(1+ > > 	 1#(1+ > > 	 	 	  	!" 	38A;/+I+Ix#$ !# #'  h, 
LL JZ0@"BDDDDDDDDD+d=>Qaprw_y-{-{}}}}}}}} 4
+;E+Bk"["[]]]]]]]]]]]rB   c                   K   t          |d         d         dd           d {V  t          d| |           d {V }|r t          i |ddd           d {V  |                     d	           d {V  t	          j        d
           d {V  |                     d                              d                                           d {V  | 	                    dd                                           d {V  |                     d                              d                                           d {V  |                     d                              d                                           d {V  |                     d                              d                                           d {V  t	          j        d
           d {V  t          j                    }|t          d          z
  }|t          d          z   }|j        }|j        }|j        }|j        }	|j        }
|j        }|                     d                              d          }|                    d                                           d {V  |                    d                              t%          |                     d {V  |                    d                              d           d {V  |                    d                              t%          |                     d {V  |                    d                              d           d {V  |                    d                              t%          |                     d {V  |                    d                              d           d {V  |                    d                              t%          |	                     d {V  |                    d                              d           d {V  |                    d                              t%          |
                     d {V  |                    d                              d           d {V  |                    d                               t%          |                     d {V  |                     d                              d!                              d"                              d           d {V  |                     d                              d!                              d#                              d           d {V  |                                 4 d {V }|                     d                              d!          	                    dd$                              d%           d {V  	 |j         d {V }t,           |d&          d'}|                    |           d {V  t          i |d(d)i           d {V  t	          j        d           d {V  t          i |d(d*i           d {V  t	          j        d+           d {V  t          i |d,dd           d {V  t1          ||           d {V  nK# t2          $ r>}t5          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"   rr   r   rt   r   z<Obteniendo recibos vencidos, por pagar, pagados y canceladosrK   rR   rG   r   rM   menurI   link   Gestión de NegociosrN   r   r   rL   r   zConsulta de Comprobantes der   )monthsr   z'iframe[name='M_AuConsultaComprobantes']zinput[name='fdesded']Tabzinput[name='fdesdem']zinput[name='fdesdea']zinput[name='fhastad']zinput[name='fhastam']zinput[name='fhastaa']z'iframe[name="M_AuConsultaComprobantes"]zinput[name="fhastaa"]zselect[name="tccancob"]zDescargar informacionEnterr   	_porpagarrS   u   Procesando informaciónzActualizando sistemar   rx   ERRORr#   )r   rj   rd   rW   rZ   r[   rX   r{   r]   r_   r   nowr   daymonthyearr   rz   r   pressr   r   r   r   leerExcelPorPagarAnteriorr}   r+   )r   r   rg   fecha_actualfecha_un_mes_atrasfecha_un_mes_adelantefdesdedfdesdemfdesdeafhastadfhastamfhastaaframe1r   r   r   r   s                    rA   exportarReportePorPagarAnteriorr-  o  s	      4
+;E+Bj"Z"Z\\\\\\\\\12jlprvwwwwwwww :`
  D4  D1p  @A  D  D  D  E  E  E  E  E  E  E  E  E

"
"=
1
11111111
-

 ,,x
 
 
'
'
'
8
8
>
>
@
@@@@@@@@


6(>

?
?
E
E
G
GGGGGGGG
,,s


"
"J
"
7
7
=
=
?
????????
,,x
 
 
'
'
'
9
9
?
?
A
AAAAAAAA
,,z
"
"
)
)3P
)
Q
Q
W
W
Y
YYYYYYYY
-

 <>>L%Q(?(?(??(=+B+B+BB $G &G %G#'G#)G#(G 566DDEnooF
..0
1
1
7
7
9
99999999
..0
1
1
6
6s7||
D
DDDDDDDD
..0
1
1
7
7
>
>>>>>>>>
..0
1
1
6
6s7||
D
DDDDDDDD
..0
1
1
7
7
>
>>>>>>>>
..0
1
1
6
6s7||
D
DDDDDDDD
..0
1
1
7
7
>
>>>>>>>>
..0
1
1
6
6s7||
D
DDDDDDDD
..0
1
1
7
7
>
>>>>>>>>
..0
1
1
6
6s7||
D
DDDDDDDD
..0
1
1
7
7
>
>>>>>>>>
..0
1
1
6
6s7||
D
DDDDDDDD


2
3
3
A
ABm
n
n
v
v  xQ  R  R  X  X  Y^  _  _  _  _  _  _  _  _  _


2
3
3
A
ABm
n
n
v
v  xS  T  T  Z  Z  [`  a  a  a  a  a  a  a  a  a##%% ` ` ` ` ` ` `455CCDopp||  ~D  Kb|  c  c  i  i  jq  r  r  r  r  r  r  r  r  r`&,,,,,,,$@d9o@@@{+++++++++RtR^5ORRSSSSSSSSSmAPtP^5LPPQQQQQQQQQmAJtJRaJJJKKKKKKKKK'k:::::::::: ` ` `gq&j1A%1HT[(](]______________`` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `W:` :`s>   !A\.9C[\.
\4\\.\\..
\8;\8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 nd| d	         d
         |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          |j        d                             dd          d}|                    |            t!          i | dd|ddd           d {V  t#          d| d         i           d {V  t%          d| d         d|id           t'          | d         d|id           d {V }	d S ) N)headerPolizau(   No se encontró la cabecera con 'Poliza'r   T)droprx   r   r   ro   r   nanrK   r   r   r   r   r   r   r   r   r   r   )r   ro   r   contratantecomprobante_pagor   estadoproductor   importer   fecha_cob_devol	cob_elec_motivo_rech_devolagenter   )optarr)mostrar_datosarrayexcelProcesador   z

DATA:
r   r   )r   read_csvranger,   r   r   
ValueErrorcolumnsreset_indexr   r   r   r   r   replacer  rd   r(   r+   r  )
r   r   r  
header_rowir  r   r  r  r	  s
             rA   r"  r"    sy     {4000" *R>>  a271:$$$je % 
?
@
@@ wz""*	*q.//&&D&11" 
yy~~" %  fa
zz|| R3:--e >*>:##E2..Xa[((33(1+--eR88!,,UB77##E2..(1+%%eR00(1+%%eR00!$$UB//##E2..!,,UB778B<''r228B<//r::$$UB// H$ 
LL  D  DHXaf?i?i  ~B  D  D  D  	E  	E  E  E  E  E  E  E  E JZ0@"BDDDDDDDDDm)<L\^cJegghhh+d=>Qaqsx_z-|-|~~~~~~~~rB   c                   K   |                     d           d {V }d| d         vrT| d         d                             d          }|d         }|dd           d|d	d          d|d d	          | d         d<   | d         d         }|D ]}|                     d
           d {V }	t          |	          dk    rg }
|	D ]e}|                                 d {V }|                    d          dk    r|                    d          d         }|
                    |           f|
d         |k    r|
d         }|                    |
           |                    d                                           d {V }|dk    rE|                    d                                           d {V  t          | |||           d {V }|S )Ntrfecha_recibor"   r   r   rQ   r   /r   ztd.renglon_color1r   ;r   z#botonSiguiente)
query_selector_allr   r,   text_contentrb   r  rX   rY   r]   obtenTodosRecibosHistoricos)r   r   arrRecibosHistoricosreciboEncontradoitemspartesfecharK  r@   renglon_color1_tdssubArrtdtextoboton_siguientes                 rA   rP  rP    s<     ''--
-
-
-
-
-
-%4
+++*o.44S99F2JE +0)'N'NeAaCj'N'N5!9'N'ND^$j!.1, * *d#667JKKKKKKKK!##f"  "oo''''''''::sr!!++c""1%%e 
l	"	"!!9!!&))),,'899??AAAAAAAA/
,,(
)
)
/
/
1
111111118tEY[kllllllll 
rB   c                    K   t          d           t          t          t          t          t
          fD ]I} | rE	 |                                  d {V   # t          $ r}t          d|            Y d }~Ad }~ww xY wJd ad ad ad ad ad S )NzCERRANDO TODAS LAS PAGINAS.u   Error al cerrar una página: )r+   page1page2page3page4page33rL   r}   )r   r   s     rA   close_pagesra    s      %&&&eUE62 3 3d 33jjll 3 3 31a112222222233 %
%
%
%&&&s   A
A8A33A8c                 0  K   d}d}d}d}t                       d {V  t          |d         d         dd           d {V  t          d|d         |d         d         |d         d	         d
           d {V }t          d|           |d         dk    r,t           |d          d|d         d	          d}t          | |d         |           d {V }t          j                            |          rt          j        	                    |          dk    r|du r|S |d         dk    rt          i |dddd|d         d         |d         d         |d         |d         dd           d {V  t          d|d         i           d {V  t          |d         d         dd           d {V  dS t          d           	 |d         d	         }t          d| |           d {V }|rt          i |ddd           d {V  t          d|d         i           d {V  |                     d                              d !                                           d {V  |                     d"d#$                                           d {V  |                     d%                              d&!                                           d {V  |                     d                              d'!                                           d {V  |                     d(                              d)!                                           d {V  |                     d*                              d+                              d,d-$                              d.                                           d {V  |                     d*                              d+                              d,d-$                              d.                              |d         d                     d {V  |                     d*                              d+                              d"d/d0                                           d {V  t'          j        d           d {V  |                                 4 d {V }	|                     d*                              d+                              d,d1$                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |	j         d {V ad2}
d3|d         d	         v rBt1          |t.          g d            d {V }|}|d         d	         |d         d4<   ||d         d	<   nd}
t          d5|
d6           |                                 4 d {V }|                     d*                              d+                              d"|d         d          $                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   t'          j        d           d {V  |j         d {V ad2}t2                                          4 d {V }t'          j        d           d {V  t2                              d,d7$                                           d {V d8k    r8t2                              d,d7$                                           d {V  d}nt          d9|d         d	         d:           t          |d         d         dd           d {V  t7          |d         |d         d         |d         d	         d;           d {V  |
d2u r[t9          |d         ||d         d	         d<           d {V  t          |d         d         |d         d	         d=           d {V  t2                                           d {V  d}|cd d d           d {V  S 	 d d d           d {V  n# 1 d {V swxY w Y   |du rt          d|d         i           d {V  |j         d {V at'          j        d           d {V  t<                              d,d>$          }t          d?|                                 d {V            |                                 d {V d8k    rt          d@           t<                              dA          j                                          d {V  t<                              dB          !                    dC           d {V  t<                              d"dD$          j         !                    dC           d {V  t<                                          4 d {V }t<                              d"dE$          j         !                    dF           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V a"tD          #                    dG           d {V  t          i |dHdd           d {V  tD          j$        %                    dI           d {V }|d          dJ|d         d          d}t           | }tM          |dK          5 }|'                    |(                                 d {V            tS          t           |           }|d2u r tU          t           | |           d {V }n tU          t           | |d2           d {V }tW          dL|d         |d         d         ||dM           d {V  d d d            n# 1 swxY w Y   tD                                           d {V  t<                                           d {V  t2                                           d {V  nt          dN           t          dO           	 t          dP           |                                 4 d {V }|                     d*                              d+                              d,dQ$          j                                          d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V at2                              dR                              |d         d                   ,                                 d {V }t[          |          }t          dS| dT|d         d          dU           t]          |          D ]}t          dV|           t2                                          4 d {V }t2                              |d         d                   /                    |                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V at<                                          4 d {V }t<                              d"d7$                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V a"tD                              |d         d	                                                    d {V d8k    rt          dW           tD                              dX|d         d	          $                              d"          j         }t          dY|           |                                 d {V d8k    rt7          |d         |d         d         |d         d	         d;           d {V  t          |d         d         dd           d {V  t2                                           d {V  t<                                           d {V  tD                                           d {V  d}nat          dZ           t'          j        d           d {V  tD                                          4 d {V }t          d9|d         d	         d[           |                                 d {V  |j         d {V a0t`          #                    dG           d {V  t`          j$        %                    dI           d {V }|d          d|d         d	          d}t           | }tM          |dK          5 }|'                    |(                                 d {V            tS          t           |           }|d2u r tU          t           | |           d {V }n tU          t           | |d2           d {V }tW          d\|d         |d         d         |d         d	         ||d]           d {V  |
d2u r[t9          |d         ||d         d	         d<           d {V  t          |d         d         |d         d	         d=           d {V  d d d            n# 1 swxY w Y   t2                                           d {V  t<                                           d {V  tD                                           d {V  t`                                           d {V  |d2u r}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 d d           d {V  n# 1 d {V swxY w Y   |c S t          d^           nO# tb          $ rA}t<                              dX|d         d	          $                              d"          j         }t          d_|                                 d {V            |                                 d {V d8k    rnt          d`           t7          |d         |d         d         |d         d	         d;           d {V  t          |d         d         dd           d {V  d}n3t'          j        d           d {V  t<                                          4 d {V }t          d9|d         d	         d[           |                                 d {V  |j         d {V a"tD          #                    dG           d {V  tD          j$        %                    dI           d {V }|d          d|d         d	          d}t           | }tM          |dK          5 }|'                    |(                                 d {V            tS          t           |           }|d2u r tU          t           | |           d {V }n tU          t           | |d2           d {V }tW          d\|d         |d         d         |d         d	         ||d]           d {V  |
d2u r[t9          |d         ||d         d	         d<           d {V  t          |d         d         |d         d	         d=           d {V  d d d            n# 1 swxY w Y   t2                                           d {V  t<                                           d {V  tD                                           d {V  |d2u r}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 d d           d {V  n# 1 d {V swxY w Y   t          da           Y d }~nd }~ww xY wt          |d         d         dd           d {V  |S d S )bNrx   r"   rr   r   rt   todor   numero_polizar   )r<  r   rd  r   zRESPUESTA:::::::
url_recibor   	_recibos_z.pdfi   T
url_polizau   ¡Documentos disponibles!r   type)r<  rh  rd  nombre_numero_polizanombre_numero_recibo)rS   rT   r>  descargar   r$   uB   ⚠️ El archivo del recibo está vacío o corrupto, continuando.r   u   Obteniendo póliza y recibosrK   rR   rM   r  rI   r  r  rN   r   u   Consulta de PólizasrL   r   zTodos los ramosr   z"iframe[name="M_AuConsultaPolizas"]r  u   Póliza Referencia Izinput[name="cdnumpol"]Buscar)rO   r   zConsulta de comprobantes deFr   numero_recibo_anteriorzRECIBO DIRECTO??z ======= NO CERRAREMOS PAGE33u   Documentaciónr   zNUMERO RECIBO:u5   NO ENCONTRADO!! -- CERRANDO PESTAÑAS NO OCUPADAS - 2)r   rd  r   )r   numero_recibo_viejor   )rr   r   zCondiciones Particularesz&EXISTE BOTON CONDICIONES PARTICULARES?u   Entra a buscar pólizaCondicionesu/   Documentación asociada Documentación asociadaz	Shift+TabzEnviar documentozImprimir documentor  rG   zSubiendo archivos a la nubezFhttps://intermediarios.gnp.com.mx/SMTotalWebSE/sm/polizas/SMImprimeAux_poliza_wbr   )r<  r   rd  sizere   zVA DIRECTO POR RECIBOzBUSCANDO Y OBTENIENDO EL RECIBOz	ENTRA TRYu   Listado de históricotableu   🔍 Se encontraron u    pólizas con el número .zPRIMERO:u*   ✅ Recibo encontrado. Proceso finalizado.r  z#EXISTE?
ACCEDIENDOzencontrado.recibo)r<  r   rd  r   rr  re   u   ❌ Recibo no encontrado en esta póliza. Probando con la siguiente.

 [[[[[ SE ENVIARA LA POLIZA PERO EL RECIBO NO SE ENCONTRO ]]]]]z:EXCEPT, PROBANDO METODO CONSULTA DE COMPROBANTES, EXISTE: zDice que no existeuY   ❌ SECCION DE Recibo no encontrado en esta póliza. Probando con la siguiente. 12/MAR/25)2ra  r   obtenerPolizaGuardadar+   r   descargarReciboParaWhatsappr-   r.   r/   getsizerd   r(   rj   rX   r{   r]   r_   r   rz   rZ   r[   expect_popupr   r`  rP  r\  rY   registraReciboSinExistenciaactualizarNoReciboGNPrL   r]  r^   r   r!  r^  rW   requestr&   openwritebodyobtener_peso_archivo_mbsubirArchivoAS3guardarPolizaelement_handlesr,   rB  r|   r_  r}   )r   r   enviarPorWhatsappr   ruta_archivo_s3_polizaruta_archivo_s3_reciborn  infoPolizaServerrg   page33_infoexisteReciboDirectorecibosHistoricosr   
page1_infoexisteDocumentacion
page2_infobtnCondicionesPoliza
page3_inforesponsenombrePolizafpeso_archivo_polizapolicy_rowstotal_policiesrH  btnNumeroRecibo
page4_infonombreRecibopeso_archivo_recibor   s                                 rA   obtenerDocumentoPolizar  *  s )     + 	 	!4
+;E+Bj"Z"Z\\\\\\\\\0&QUVcQdw{  }G  xH  IX  xY  lp  q{  l|  }L  lM  2O  2O  P  P  P  P  P  P  P  P,---l#r)) c$y/ccD<L_<]cccK3D:J<:XZeffffffffK 
w~~k"" 
Rrw{'C'Cd'J'J	d	"	"L)R//  _$  _8Sbcvz  RT  ^b  cm  ^n  ou  ^v  IM  NX  IY  Zi  Ij  DT  Ua  Db  |L  MY  |Z  I]  I]  _  _  _  `  `  `  `  `  `  `  `  `(:tJ7G)IJJ
J
J
J
J
J
J
J($z2B52IU`)b)bcc
c
c
c
c
c
c
crPQQQ Z(912jlprvwwwwwwww o
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
,,x
 
 
'
'
'
8
8
>
>
@
@@@@@@@@


6(>

?
?
E
E
G
GGGGGGGG
,,s


"
",B
"
C
C
I
I
K
KKKKKKKK
,,x
 
 
'
'
'
9
9
?
?
A
AAAAAAAA
,,z
"
"
)
)3D
)
E
E
K
K
M
MMMMMMMM 

2
3
3
A
ABh
i
i
u
uv|  DZ
u  [  [  c  c  d~      E  E  G  G  G  G  G  G  G  G  G


2
3
3
A
ABh
i
i
u
uv|  DZ
u  [  [  c  c  d~      D  D  HL  MW  HX  Yh  Hi  Ek  l  l  l  l  l  l  l  l  l


2
3
3
A
ABh
i
i
u
uv|  DL  TX
u  Y  Y  _  _  a  a  a  a  a  a  a  a  a
-

  "" l l l l l l lk455CCDjkkwwx~  Fcw  d  d  j  j  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 l l l l$$$$$$$F
d:/// ;D&"d S SSSSSSS'm37
3CO3Td:/0*7d:''  

13RSSS  "" u u u u u u uj455CCDjkkwwx~  IM  NX  IY  Zi  Ij  Flw  m  m  s  s  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 u u u u u u u u u
-

"""""""E!!##       zM!  .> ??EEGG	G	G	G	G	G	G!	K	K-=>>DDFFFFFFFFF"Z 0 ACz{{{&j1A%1HT_(a(accccccccc).jAQRaAbuy  {E  vF  GV  vW  Y  Y
 
 	
 	
 	
 	
 	
 	
 	
 %''%tM7Jcv  JN  OY  JZ  [j  Jk  'm  'm  n  n  n  n  n  n  n  n  n(4
3CE3J]abl]mn}]~  +A  +A  C  C  C  C  C  C  C  C  Ckkmm!+             
 	                          . d""$
D4D&FHHHHHHHHH $$$$$$$eM!"..v<V.WW 4<P<V<V<X<X6X6X6X6X6X6XYYY $))++	+	+	+	+	+	+a	/	/&'''..4::<<<<<<<<< RSSYYZefffffffff-?@@FLL[YYYYYYYYY%%'' 	Z 	Z 	Z 	Z 	Z 	Z 	Z:!!&/C!DDJPPQXYY
Y
Y
Y
Y
Y
Y
Y	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z 	Z &&&&&&&''666666666ftf5Sbcfffggggggggg**+stttttttty/ZZ4
3CO3TZZZ$4l44+t$$ 	G
''''''''
(
(
( 7;8V8V8V W W
%''+:k;Y<;Y;Y[g+h+h%h%h%h%h%h%h""+:k;Y<;Y;Y[gin+o+o%o%o%o%o%o%o"x]@Sfjkufv  xG  gH  Re  nD  F  F  G  G  G  G  G  G  G  G  G	G 	G 	G 	G 	G 	G 	G 	G 	G 	G 	G 	G 	G 	G 	G kkmmkkmmkkmm%&&& -...~kk$$&& 	p 	p 	p 	p 	p 	p 	p*""#899GGHnoo{{  }C  Ja{  b  b  h  n  n  p  p  p  p  p  p  p  p  p	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p 	p !&&&&&&&!MM'22>>tJ?OP_?`aaqqssssssss[))r^rrdS]N^_nNorrrsss ~&& D	[ D	[A

A


'')) V V V V V V VZ##D$4_$EFFJJ1MMSSUUUUUUUUUV V V V V V V V V V V V V V V V V V V V V V V V V V V"(((((((%'')) K K K K K K KZ##F1A#BBHHJJJJJJJJJK K K K K K K K K K K K K K K K K K K K K K K K K K K"(((((((% $$T*%5o%FGGMMOOOOOOOORSSS>???#//tJ?OP_?`<b/ccoopvww}O*o...$**,,,,,,,,11/!%m!4tJGWXgGh{  AK  |L  M\  |]  _  _         -tJ7G7NZe.g.giiiiiiiiiKKMM!!!!!!!KKMM!!!!!!!KKMM!!!!!!!'kkL!!!M!$$$$$$$$$++-- "n "n "n "n "n "n "n&Z(8(I=YYY%++---------(.......//>>>>>>>>>!&!2!23{!|!|||||||"&y/ccD<L_<]ccc!,<l<<+t,, M''//////000(?;@^P\@^@^(_(_%&%//3BkCaS_CaCaco3p3p-p-p-p-p-p-p**3BkCaS_CaCacoqv3w3w-w-w-w-w-w-w*%x]H[nrs}n~  @O  oP  cg  hr  cs  tC  cD  Na  j@  'B  'B  C  C  C  C  C  C  C  C  C )E11/mAT  nA  TX  Yc  Td  et  Tu  1w  1w  x  x  x  x  x  x  x  x  x2T*=Me=Tgklvgw  yH  hI  5K  5K  M  M  M  M  M  M  M  M  MM M M M M M M M M M M M M M M kkmm#######kkmm#######kkmm#######kkmm#######$--%  'V  'V?Zij  ~B  Y[  ei  jt  eu  v|  e}  PT  U_  P`  ap  Pq  Ka  {Q  PT  PT  'V  'V  'V  W  W  W  W  W  W  W  W  W0JZ@P2RTTTTTTTTT04
;KE;R^i2k2kmmmmmmmmmE"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J 



  Z  [  [  [  [ -k -k -k++E4
;KO;\8^+__kklrssyJRaRgRgRiRiLiLiLiLiLiLijjj &&((((((((A--
$
%
%
%+d=>Qdhisdt  vE  eF  Y]  ^h  Yi  jy  Yz  .|  .|  ~  ~  ~  ~  ~  ~  ~  ~  ~(4
3CE3JVa*c*cee
e
e
e
e
e
e
e#++a  
 
 
 
 
 
 
 '')) !j !j !j !j !j !j !jZ"D$4_$E}UUU!'')))))))))$*******E++M:::::::::"]../wxxxxxxxxH"9o__Z8H8Y___L(8,88Kk4(( IAggHMMOO++++++,,,$;{<ZL<Z<Z$[$[!"e++/>+?]|?]?]_k/l/l)l)l)l)l)l)l&&/>+?]|?]?]_kmr/s/s)s)s)s)s)s)s&!8DDWjnoyjz  |K  kL  _c  dn  _o  p  _@  J]  f|  #~  #~                   %--+T-=Pi|  PT  U_  P`  ap  Pq  -s  -s  t  t  t  t  t  t  t  t  t.j9I%9Pcghrcs  uD  dE  1G  1G  I  I  I  I  I  I  I  I  II I I I I I I I I I I I I I I ++--++--++-- E))!  #RT  #R;Vefy}  UW  ae  fp  aq  rx  ay  LP  Q[  L\  ]l  Lm  G]  wM  LP  LP  #R  #R  #R  S  S  S  S  S  S  S  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iC!j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !j !jF 	ijjjjjjjj[-k^ #T*-=e-DP[$]$]
_
_________o os  AT))
T36T3A#X==
Y
YFa  
a
a
;h
h&)h&B7nnn)AN Ar1AN 1
r;;AN >r;?CAN Aw6$AN 6
x 	 AN x 	/AN 35y:(AN :
z	AN z	GAN AB?AM%DD#AIH?AM%IAIIAM%IAIID AM%MAN M%
AM/	M/AN M2AM/	M3AN M:AN NA_ND.A_SB?A^-VD#AZ2Z&A^-Z2AZ6Z6A^-Z9AZ6Z:C!A^-^A_^-
A^7	^7A_^:A^7	^;A__A_c                 T   K   	 t          |d         d         dd           d{V  dS )ur  
  1) Verificar si existe carátula, si no obtenerla
  2) Verificar si existe recibo de cobro, si no obtenerlo
  3) Verificar si ya simulamos los recibos
    3.1) Si no existen los recibos obtener: [prima neta, fpago, f_recibo] y enviar
  4) Verificar si ya tenemos los datos actualizados del cliente
    4.1) En caso de no tener los datos extraerlos de la carátula 
  r"   rr   r$   rt   N)r   )r   r   s     rA   obtenerDatosClienter  N  sE      < 	!4
+;E+Bk"["[]]]]]]]]]]]rB   )r   )F)*rZ   r-   r   r   requestsr   r2   r   WPP_Whatsappr   utilsdateutil.relativedeltar   lectoresr   playwright.async_apir   r   rc   r   rU   r\  r]  r^  r_  r`  r7   rj   r`   r   r   r   r   r  r  r  r-  r"  rP  ra  r  r   rB   rA   <module>r     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                 0 0 0 0 0 0           - - - - - -xV++H+= 	[g [g [g~( ( (V6 6 6r` ` `22 22 22j04 04 04dL^ L^ L^ L^b51 51 51n:3 :3 :3zG^ G^ G^ G^V=` =` =`~8 8 8z# # #J  $` ` ` `H	,^ ,^ ,^ ,^ ,^rB   