
    F)fˋ                        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
 d dlmZ d dl 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 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)Create)*)relativedelta)platform)TimeoutErrordarwinD/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                 N  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  rvt        |d
   dd       d {    |dk(  r|d   }|d    }
d|
 d}t        j                  j                  |      rPt        j                         }t        j                  j                  |      }||z
  dkD  rt        j                  |       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 7 7 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ocultarNavegadoriX  u   Conexión establecida)loginMessagerefreshsubtareaerr_f	terminador   r   )getactualizarStatusTareaactualizarConteoUsoTareaobtenerDatosConexionorganizaSubtareasprintlenospathexistsremove actualizarStatusNavegadorAbiertotimegetmtimeinicializarPlaywrightenviarMensajeglobalscallableejecutarProcesosGnpcerrarPlaywrightactualizarFechaLogin)
parametrosr   r   r   r   r   r   r   subtareasNavegadorsubtareasWhatsappr   r!   session_filetiempo_actualmodificacion_session_fileitemr   s                    K/Users/wsoft/Documents/wsoft.com.mx/carteraplus-automatizador/python/gnp.pyr:   r:      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#G9E2l		%		$&GG$4$4\$B!44s: ))L
!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
j
)))
*$z:JVa,b
eee	Q(((	
"s+<'='B
tJ/?;!W
ZZZ
d:.>tTaOb d
fff (C"Y [ E r +Y* _  P `H 	" 	f *e( [fs  BN%M?N%3N40N%$N%N%:N;BN%NBN%1N2N%NN%'N(AN%)N*N%N0N%4N5N%NN%&N'4N%N!N%7N#8N%N%N%N%N%N%N%N%N%N%N%N%N%!N%#N%c                 
  K   d}d}da |j                  |        d {    |j                  d       d {    t        d|d   i       d {    	 |j	                  dd      j                          d {   }|dkD  r|d	   }t        j                  j                  d
| d      rt        j                  d
| d       |j                  t               d {    t        j                  d       d {    t        ||       d {   }|j                  d       d {   }|j                  t              dkD  r|dk(  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 s7 7 7 7 7 7 7 r7 Z7 @7 )w)NFTnetworkidler   divzwarningServicio temporalmentehas_textr   r   r   r      () => window.location.hrefzINICIANDO SESION...r   r"   	conectador'   )estoyEnCobranzagotowait_for_load_stater*   locatorcountr/   r0   r1   r2   urlLoginasynciosleepiniciar_sesionevaluatefindr7   r<   )urlr   r   sesionIniciadacontinuaOperacionelementCountr   
url_actuals           rD   validar_inicio_sesionr_   w   s    ./ 			#  /// JZ0@"BDDD D ||E4S|TZZ\\,A-(G	ww~~WIU34ii,wiu-.
))H

--
)$55N ]]#?@@*__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 
  	} /DF ] 5 A \F5Hhs   HG"HG%HG()H8G+9A"HG.H8G19HG3H%G5&6HG7H4G95HG;	H"G=#H>G??HHH%H(H+H.H1H3H5H7H9H;H=H?HHc                   K   d}|d   }|d   d   }|d   d   }t         j                  j                  d| d      rt        j                  | d       | j	                  d       d {   }|j                  t              d	k(  r| j                  t               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                  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 7 q7 W7 17 7 7 7 7 7 j7 B7 )w)NFr   r   campo1campo2z./r   rK   rL   u   Correo Electrónicou   ContraseñarJ   buttonu   Iniciar sesiónname   rG   u   Procesando información...rH   hidden)statezERROR DE INICIO DE SESION.r   rM    r   )r0   r   T)r"   rN   saveSession)r/   r0   r1   r2   rX   rY   rT   rP   get_by_labelfillrU   rV   get_by_roleclickrR   firstwait_forr7   contextstorage_state)r   r   r[   r   usuariopasswordr^   s          rD   rW   rW      s\    .&''1''1( WW^^b	'(II	 ]]#?@@*__X"$
))H

 	/055g>>>-(--h777 	a(9:@@BBBb 	U%ABHHQQX`Qaaa ]]#?@@*__X#
a4a3M]^a
bbb
--

F4F!F
GGG 
 ,,
$
$L	*G
$
HHH
Z4Z!TXZ
[[[N	A A
 ?7 B b AbG I[s   A'I9)I*4I9I'I9I'I9.I/I9I"(I94I%5I9I(4I9I+I9I- 1I9I/I9.I1/I9I3	)I92I53I9I7	I9I9I9I9"I9%I9(I9+I9-I9/I91I93I95I97I9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   mensaje6https://portalintermediarios.gnp.com.mx/home/dashboardr   r'   u   ¡Sesión validada con éxito!r$   _idr&   ry   r   zDatos incorrectos)r7   r_   r<   actualizarStatusSubtarea)r   r   r\   s      rD   r   r      s6      D  DT-EX  fB  D  	E  E  E12jlprvww
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w 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u rt        d| |       d {   }nd}|rMt        du rt        dd	      \  }}}| j	                  d
      j                  t        j                  d            j                          d {    | j                  d      j                  d       d {    t        j                  d       d {    | j                  d      j                          d {    | j                  d      j                          d {    t        j                  d       d {    | j                  d      j                  d      j                  d      j                          d {    t        j                  d       d {    | j                  d      j                  d      j                  d      j                          d {    t        j                  d       d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j#                  d      j%                  d      j'                          d {    da| j                  d      j                  d      j#                  dd      j                          d {    	 | j)                  d !      4 d {   }|j*                   d {   }d"|d#    d$}|j-                  |       d {    t/        ||       d {    d%ad d d       d {    y y 7 v7 \7 7 7 7 7 o7 U7 7 7 7 7 H7 7 7 I7 7 7 7 7 d7 R7 B# 1 d {  7  sw Y   y xY w# t2        $ rd t0        dz   at0        d&kD  r*t        |d   d   d'd       d {  7   t5        d(       Y y t5        d)t0               t7        | |       d {  7   Y y w xY ww)*Nr$   ry   iniciadorz   Frx   T   %Y-%m-%drG   ^search$rH   Buscar productos,adminisr   searchBuscar'   Administración de Carterachevron_right#inlineFrameExample$iframe[name="AdministracionCartera"]Reportes   Relación de Recibosselect[name="diaDesde"]-rJ   select[name="mesDesde"]select[name="mesHasta"]select[name="diaHasta"]radioimgExportar a Excel Planord    timeoutr
   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{   rO   r_   obtenerFechasEnRangorR   filterrecompilern   get_by_placeholderrl   rU   rV   get_by_textframe_locatorselect_optionsplitrm   nthcheckexpect_downloadvaluesave_asleerExcelPorPagarloopReintentosCobranzar   r-   exportarReportePorPagar	r   r   r\   fecha_proximafecha_anteriorhoydownload_infodownloadrutaArchivos	            rD   r   r     s     	!4
+;E+Bj"Z\\\34lnrtxyy%+?:+N(m^SLL&&

;0G&HNNPPP##$78==iHHHMM!^,22444FGMMOOO MM!45CCDlmyy  {E  F  L  L  N  N  NMM!45CCDlmyy  {Q  R  X  X  Z  Z  ZMM!45CCDlmuu  wR  S  a  a  bp  bv  bv  wz  b{  |}  b~      45CCDlmuu  wR  S  a  a  bp  bv  bv  wz  b{  |}  b~      45CCDlmuu  wR  S  a  a  bo  bu  bu  vy  bz  {|  b}  ~  ~  ~45CCDlmuu  wR  S  a  a  bo  bu  bu  vy  bz  {|  b}  ~  ~  ~45CCDlmyy  {B  C  G  G  HI  J  P  P  R  R  Ro


2
3
A
ABj
k
w
wx}  E]
w  ^  d  d  f  f  f2%%f%5 # #&,,,\]abk]l\mm~{+++k222!"# # #9  ]y QH4O  N Z   ~ ~ R f#,+2	# # # #  2 6 :	!	#&j1A%1HTf(hjjj=>@BXY%dD1112s  URURA(U R!'UR	U%R&&UR&U3R"4UR%AUR(U2R+3AU7R.8UR1AU,R4-AUR7AUR:AU4R=5AUS 	AUSUS# -S.S# 1SS!S#S$S7S
8S>S# 	S
S# UUUUUU"U%U(U+U.U1U4U7U:U=U UUS# SS
SS# S SS S# U S# #2UTU&U(UU
UUUUc                 (  K   t        j                  |      }|j                  t              }g }|j	                         D ]D  \  }}|j                         j                         sd|j                  v r ni 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#   }|j                  |       G t        i | d$d%|d&d$d'       d {    t        d(| d(   i       d {    t        | d)   d%|id*       d {   }t        | d+   d,   d-d.       d {    t        j                  |       y 7 i7 S7 :7  w)/Nri   companiagnpclave_agenter   clienter   polizar   planrJ   vencimiento_recibor   status_recibor~   fecha_pago_recibo   inicio_vigencia   fin_vigencia   year_poliza   prima_anual	   prima_fraccionada
   moneda   conducto   f_pago   	asegurado   TarrGnpPorPagaroptarrmostrar_datosarrayexcelProcesador   r   r   reportesr$   ry   r&   rz   pandas
read_excelastypestriterrowsisnullanyvaluesilocappendr7   r*   registrarRecibosr{   r/   r2   r   r   dfdatos_rowregistrorespuestaReciboss           rD   r   r   7  sx    %" 
yy~" % fa
zz|R3::-%d>*>: chhqk chhqk	
 chhqk chhqk chhqk chhqk chhqk chhqk chhqk chhqk chhrl chhrl chhrl  chhrl!" chhrl#H& 
LL14 	  D  DHXaf?i  ~B  D  	E  E  E JZ0@"BDDD ,d=>Qaqsx_z-|~~ 4
+;E+Bk"[]]]))K ED ]H   FH H
!H8H9HHH/H0HHHHc                 2  K   t        |d   d   dd       d {    t        du rt        d| |       d {   }nd}|rt        du rht        dd	      \  }}}| j	                  d
      j                  t        j                  d            j                          d {    t        j                  d       d {    | j                  d      j                  d       d {    t        j                  d       d {    | j                  d      j                          d {    | j                  d      j                          d {    t        j                  d       d {    | j                  d      j                  d      j                  d      j                          d {    t        j                  d       d {    | j                  d      j                  d      j                  d      j                          d {    t        j                  d       d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    | j                  d      j                  d      j	                  d      j                  |j!                  d      d          d {    t        j                  d       d {    | j                  d      j                  d      j#                  d      j%                  d      j'                          d {    | j                  d      j                  d      j#                  dd !      j                          d {    	 | j)                  d"#      4 d {   }|j*                   d {   }t,         |d$    d%}|j/                  |       d {    t1        ||       d {    dad d d       d {    y y 7 7 7 37 7 7 7 7 7 x7 67 7 7 7 k7 7 7 l7 R7 7 7 7 7 k7 Y7 I# 1 d {  7  sw Y   y xY w# t4        $ rd t2        dz   at2        d&kD  r*t        |d   d   d'd       d {  7   t7        d(       Y y t7        d)t2               t9        | |       d {  7   Y y w xY ww)*Nr$   ry   r}   rz   Frx   Tr~   r   rG   r   rH   r   r   r   r   r   r   r   r   r   r   r   r   rJ   r   r   r   r   r   r   r   rd   r   r   r   _cartera_pagadar   r   r   r   )r{   rO   r_   r   rR   r   r   r   rn   rU   rV   r   rl   r   r   r   r   rm   r   r   r   r   RUTA_FOLDERr   leerExcelPagadasr   r   r-   exportarReportePagadasr   s	            rD   r   r   k  s      	!4
+;E+Bj"Z\\\34lnrtxyy%+?:+N(m^SLL&&

;0G&HNNPPPMM!##$78==iHHHMM!^,22444FGMMOOO
 MM!45CCDlmyy  {E  F  L  L  N  N  NMM!45CCDlmyy  {Q  R  X  X  Z  Z  ZMM!45CCDlmuu  wR  S  a  a  bp  bv  bv  wz  b{  |}  b~      45CCDlmuu  wR  S  a  a  bp  bv  bv  wz  b{  |}  b~      45CCDlmuu  wR  S  a  a  bo  bu  bu  vy  bz  {|  b}  ~  ~  ~45CCDlmuu  wR  S  a  a  bo  bu  bu  vy  bz  {|  b}  ~  ~  ~MM!


2
3
A
ABj
k
w
wx  A  E  E  FG  H  N  N  P  P  P


2
3
A
ABj
k
w
wx}  E]
w  ^  d  d  f  f  f1%%f%5 # #&,,,$d9o%6oF{+++t[111!"# # #=  ]y QH4O
  N Z   ~ ~ P f#,+1	# # # #  1 6 :	!	#&j1A%1HTf(hjjj=>@BXY$T40001s>  VSVSA(V S!V=S>'V%S&VS&V)S*&VS"V-S%.AV2S(3VS+AVS.V1S12AV	S4
AV!S7"AV9S::AVS=V.T /AVTAV	T
VT' %T&T' )T9T
:&T T!T4T5T;T' TT' VVVVVVV"V%V(V+V.V1V4V7V:V=V VVVT' 
TTTT' T$TT$ T' #V$T' '2VUV*V,VVVVVVc                 (  K   t        j                  |      }|j                  t              }g }|j	                         D ]D  \  }}|j                         j                         sd|j                  v r ni 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#   }|j                  |       G t        i | d$d%|d&d$d'       d {    t        d(| d(   i       d {    t        | d)   d%|id*       d {   }t        | d+   d,   d-d.       d {    t        j                  |       y 7 i7 S7 :7  w)/Nri   r   r   r   r   r   r   r   r   r   rJ   r   r   r   r~   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   TarrGnpPagadasr   r   r   r   r   r$   ry   r&   rz   r   r   s           rD   r   r     sr    %" 
yy~" % fa
zz|R3::-%d>*>: chhqk chhqk	
 chhqk chhqk chhqk chhqk chhqk chhqk chhqk chhqk chhrl chhrl chhrl  chhrl!" chhrl#H& 
LL16 	  C  C`e?h  }A  C  	D  D  D JZ0@"BDDD+d=>Qaprw_y-{}} 4
+;E+Bk"[]]]))K	 DD}]r   c                   K   t        |d   d   dd       d {    t        d| |       d {   }|rt        i |ddd       d {    | j                  d	       d {    t	        j
                  d
       d {    | j                  d      j                  d      j                          d {    | j                  dd      j                          d {    | j                  d      j                  d      j                          d {    | j                  d      j                  d      j                          d {    | j                  d      j                  d      j                          d {    t	        j
                  d
       d {    t        j                         }|t        d      z
  }|t        d      z   }|j                  }|j                  }|j                  }|j                  }	|j                  }
|j                  }| j!                  d      j!                  d      }|j                  d      j                          d {    |j                  d      j#                  t%        |             d {    |j                  d      j'                  d       d {    |j                  d      j#                  t%        |             d {    |j                  d      j'                  d       d {    |j                  d      j#                  t%        |             d {    |j                  d      j'                  d       d {    |j                  d      j#                  t%        |	             d {    |j                  d      j'                  d       d {    |j                  d      j#                  t%        |
             d {    |j                  d      j'                  d       d {    |j                  d       j#                  t%        |             d {    | j!                  d      j!                  d!      j                  d"      j'                  d       d {    | j!                  d      j!                  d!      j                  d#      j'                  d       d {    | j)                         4 d {   }| j!                  d      j!                  d!      j                  dd$      j'                  d%       d {    	 |j*                   d {   }t,         |d&    d'}|j/                  |       d {    t        i |d(d)i       d {    t	        j
                  d       d {    t        i |d(d*i       d {    t	        j
                  d+       d {    t        i |d,dd       d {    t1        ||       d {    d d d       d {    y y 7 7 7 7 7 7 7 ]7 )7 7 7 7 7 7 7 h7 C7 7 7 7 7 o7 J7 7 7 7 7 ;7 )7 7 7 7 7 7 7 w# t2        $ r3}t5        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$   ry   r}   rz   rx   z<Obteniendo recibos vencidos, por pagar, pagados y canceladosrJ   rM   rF   r   rc   menurH   link   Gestión de Negociosrd   aCobranzaclosemat-cardz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   	_porpagarr"   u   Procesando informaciónzActualizando sistemar   ri   ERRORr%   )r{   r_   r7   rQ   rU   rV   rR   r   rn   rm   r   nowr   daymonthyearr   rl   r   pressr   r   r   r   leerExcelPorPagarAnterior	Exceptionr-   )r   r   r\   fecha_actualfecha_un_mes_atrasfecha_un_mes_adelantefdesdedfdesdemfdesdeafhastadfhastamfhastaaframe1r   r   r   es                    rD   exportarReportePorPagarAnteriorr    sh     4
+;E+Bj"Z\\\12jlprvww
  D4  D3o  @A  D  E  E  E

"
"=
111
--
 ,,x
 
'
'
'
8
>
>
@@@


6(>

?
E
E
GGG
,,s

"
"J
"
7
=
=
???
,,x
 
'
'
'
9
?
?
AAA
,,z
"
)
)3P
)
Q
W
W
YYY
--
 <<>L%Q(??(=+BB $$G &&G %%G#''G#))G#((G 56DDEnoF
..0
1
7
7
999
..0
1
6
6s7|
DDD
..0
1
7
7
>>>
..0
1
6
6s7|
DDD
..0
1
7
7
>>>
..0
1
6
6s7|
DDD
..0
1
7
7
>>>
..0
1
6
6s7|
DDD
..0
1
7
7
>>>
..0
1
6
6s7|
DDD
..0
1
7
7
>>>
..0
1
6
6s7|
DDD


2
3
A
ABm
n
v
v  xQ  R  X  X  Y^  _  _  _


2
3
A
ABm
n
v
v  xS  T  Z  Z  [`  a  a  a##% ` `45CCDop||  ~D  Kb|  c  i  i  jq  r  r  r`&,,,$d9o%6i@{+++RtR^7NRSSSmmAPtP^7KPQQQmmAJtJRaJKKK'k:::` ` `W  ]w E1 AG?AY :D>D>D>D>D>D _ a` r,+SQK: `gq&j1A%1HT[(]___`` ` ` `s  [&X-[&X0[&X3[&%X6&[&X96[&9X<:([&"X?#6[&Y6[&Y6[&Y[&$Y%C [&%Y&0[&Y'[&>Y?0[&/Y0'[&Y0[&Y	'[&0Y 10[&!Y#"'[&	Y&
0[&:Y);'[&"Y,#0[&Y/A[&Y2A[&Y5 [&8Y89[&<A[ Y;[ZY>&Z<Z=ZZZ2Z3ZZZ(Z
)ZZZZZ[&&['[&0[&3[&6[&9[&<[&?[&[&[&[&[&[&[&[&[&[&[& [&#[&&[&)[&,[&/[&2[&5[&8[&;[>ZZZZZ
ZZZ	[#[<Z?=[[[[[&[#[[#[&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 ]  \  }}|j                         j                         sd|j
                  v r nd| d	   d
   |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      |j                  d   j                  dd      d}|j                  |        t!        i | dd|ddd       d {    t#        d| d   i       d {    t%        d| d   d|id       t'        | d   d|id       d {   }	y 7 L7 67 	w) N)headerPolizau(   No se encontró la cabecera con 'Poliza'r   T)dropri   r   r   r   r   nanrJ   r   r~   r   r   r   r   r   r   r   r   )r   r   r   contratantecomprobante_pagor   estadoproductor   importer   fecha_cob_devol	cob_elec_motivo_rech_devolagenter   r   r   r   z

DATA:
r   r   )r   read_csvranger.   r   r   
ValueErrorcolumnsreset_indexr   r   r   r   r   replacer   r7   r*   r-   r   )
r   r   r   
header_rowir   r   r   r   r   s
             rD   r  r    s    {40" *R> a2771:$$$j
 
?
@@ wwz""*	*q./&&D&1" 
yy~" % fa
zz|R3::- >*>:##E2.XXa[((3((1+--eR8!,,UB7##E2.((1+%%eR0((1+%%eR0!$$UB/##E2.!,,UB788B<''r288B<//r:$$UB/H$ 
LL/2 	  D  DHXaf?i  ~B  D  	E  E  E JZ0@"BDDD+m)<L\^cJegh+d=>Qaqsx_z-|~~ ED s=   AK;IK;(K5)K; K7.K;/K90K;7K;9K;c                   K   |j                  d       d {   }| d   d   }|D ]  }|j                  d       d {   }t        |      dkD  s+g }|D ]S  }	|	j                          d {   }
|
j                  d      dkD  r|
j	                  d      d   }
|j                  |
       U |d   |k(  r|d   }|j                  |        |j                  d	      j                          d {   }|dkD  r=|j                  d	      j                          d {    t        | |||       d {   }|S 7 7 7 7 O7 %7 w)
Ntrr$   fecha_reciboztd.renglon_color1r   ;rL   r   z#botonSiguiente)
query_selector_allr.   text_contentrY   r   r   rR   rS   rn   obtenTodosRecibosHistoricos)r   r   arrRecibosHistoricosreciboEncontradoitemsr*  rC   renglon_color1_tdssubArrtdtextoboton_siguientes               rD   r.  r.  V  sX    ''-
-%j!.1, *d#667JKK!#f" "oo''::sr!++c"1%%e	 
l	"!!9!!&)* ,,'89??AA/
,,(
)
/
/
111 9tEY[kll 
9 .
 L ( B1 msn   ED6%ED9EE+D;,BE-D=.+ED?E/E0E9E;E=E?EE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      j                          d {    | j                  d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      j                  dd      j	                  d      j                          d {    | j                  d      j                  d      j                  dd      j	                  d      j                  |d   d           d {    | j                  d      j                  d      j                  ddd      j                          d {    t        j                  d       d {    | j                         4 d {   }| j                  d      j                  d      j                  dd      j                          d {    d d d       d {    j                   d {   }t        ||g d        d {   }|j                          d {    |}||d   d <   | j                         4 d {   }| j                  d      j                  d      j                  d|d   d          j                          d {    d d d       d {    t        j                  d       d {    j                   d {   }|j                         4 d {   }	|j                  dd!      j                          d {    d d d       d {    t        d	|d	   i       d {    	j                   d {   }
|
j!                  d"      j                          d {    |
j!                  d#      j#                  d$       d {    |
j                  dd%      j$                  j#                  d$       d {    |
j                         4 d {   }|
j                  dd&      j$                  j#                  d'       d {    d d d       d {    j                   d {   }|j'                  d(       d {    t        i |d)dd       d {    |j(                  j+                  d*       d {   }|d+    d,|d   d    d-}t,         | }t/        |d.      5 }|j1                  |j3                          d {          t5        t,         | |       d {    d d d        |j                          d {    |
j                         4 d {   }|
j                  d/d0|d   d     d1      j                  d      j$                  j                          d {    d d d       d {    |j                   d {   }|j'                  d(       d {    |j(                  j+                  d*       d {   }|d+    d2|d   d     d-}t,         | }t/        |d.      5 }|j1                  |j3                          d {          t5        t,         | |       d {    d d d        t        i |d3ddd4|d   d5   |d   d   ||d6d7       d {    t        d	|d	   i       d {    t        |d   d   d8d       d {    y y 7 7 7 7 7 K7 %7 7 7 7 67 7 7 |7 f7 "7 # 1 d {  7  sw Y   &xY w7 7 7 7 7 7 z# 1 d {  7  sw Y   xY w7 v7 e7 O7 )7 # 1 d {  7  sw Y   -xY w7 7 7 7 7 7 |7 K7 ># 1 d {  7  sw Y   OxY w7 C7 -7 7 7 7 # 1 sw Y   xY w7 7 k7 "7 # 1 d {  7  sw Y   &xY w7 7 7 7 7 # 1 sw Y   xY w7 Y7 D7 +w)9Nr$   ry   r}   rz   rx   u   Obteniendo póliza y recibosrJ   rM   r   rc   r   rH   r   r   rd   r   u   Consulta de Pólizasr   r   zTodos los ramosr   z"iframe[name="M_AuConsultaPolizas"]cellu   Póliza Referencia Izinput[name="cdnumpol"]numero_polizaBuscarT)re   exactr   zConsulta de comprobantes denumero_recibou   DocumentaciónCondicionesu/   Documentación asociada Documentación asociadaz	Shift+TabzEnviar documentozImprimir documentor   rF   zSubiendo archivos a la nubezFhttps://intermediarios.gnp.com.mx/SMTotalWebSE/sm/polizas/SMImprimeAuxr   _poliza_z.pdfwbr   z REC:  	_recibos_u   ¡Documentos disponibles!ri   type)r   rB  r9  nombre_numero_polizanombre_numero_recibo)r"   rN   r   descargar&   )r{   r_   r7   r*   rR   r   rn   rm   r   rl   rU   rV   expect_popupr   r.  r   r   r  ro   rQ   requestr(   r   openwritebodysubirArchivoAS3)r   r   r\   page33_infopage33recibosHistoricosr<  
page1_infopage1
page2_infopage2
page3_infopage3responsenombrePolizar   fnombreRecibos                     rD   obtenerDocumentoPolizarY  v  s	     4
+;E+Bj"Z\\\12jlprvww
c4c3O_`c
ddd
"j$z2B$D
FFF
,,x
 
'
'
'
8
>
>
@@@


6(>

?
E
E
GGG
,,s

"
",B
"
C
I
I
KKK
,,x
 
'
'
'
9
?
?
AAA
,,z
"
)
)3D
)
E
K
K
MMM 

2
3
A
ABh
i
u
uv|  DZ
u  [  c  c  d~    E  E  G  G  G


2
3
A
ABh
i
u
uv|  DZ
u  [  c  c  d~    D  D  HL  MW  HX  Yh  Hi  Gj  l  l  l


2
3
A
ABh
i
u
uv|  DL  TX
u  Y  _  _  a  a  a
--
  " l lk45CCDjkwwx~  Fcw  d  j  j  l  l  ll l$$$F9$DQQ ,,.%M(5D_%
   " u uj45CCDjkwwx~  IM  NX  IY  Zi  Ij  Hkw  m  s  s  u  u  uu u
--
"""E!!# E Ezf+;<BBDDDE E #j$z2B$D
FFF """E


M
*
0
0
222


M
O
U
UVa
bbb


F);

<
B
B
H
H
UUU!!# V Vzf+?@FFLLWUUUV V"""E

#
#M
222
b4b3N^_b
ccc]]&&'oppH9o&htJ/?/P.QQUVL M,0K	k4	  JAggHMMO#${mL>:LIIIJ ++- !!# { {zeF4
3CO3T2UUV*WXddeklrrxxzzz{ {"""E

#
#M
222]]&&'oppH9o&iZ0@0Q/RRVWL M,0K	k4	  JAggHMMO#${mL>:LIIIJ   t4  t1L[\os  KM  W[  \f  Wg  hn  Wo  BF  GQ  BR  Sb  Bc  }I  co  Br  t  u  u  u
"j$z2B$D
FFF
"T*-=e-DP[$]
___o  ]wdF@GKAM G l al ll l l l$Q u uu u u u"EDE E E E G #2bUVUV V V V"2cp
 $IJ J {z{ { { {"2p
 $IJ J uF_su  d_d_d_ d$_#%6d_&(d_)6d;_,<6d2_/36d)_2*Ad?_5 Ad_8Ad%_;&d_>d`dA`
"`#`
'd2`3d` d`#d4`&5"d`)dA
`2%`,&`2*d5`/6dad&a'd?a d%a(a)a-d8a9da-d$a0%&da3'd3a643d'a9(d a<d0b4a?5b9dbdbd1b2db!"d.b$/+db-9b'
:b-b*b-d9b::db=dAcc c#d.c/dcdc"d>c"?+d*c+	c%

c+)c(*c+.1dc8 d7c;8dc>dd d#d&d)d,d/d2d5d8d;d>dd`
d
```	d#d&d)d,`2/d2a8`;9a 	dddada*a a*%	d0d3d6d9d<d?bdbbb	dd!d$d'b-*b--b72	d=d cdccc	dd"d%c+(c++c50	d;d>dc                 J   K   	 t        |d   d   dd       d{    y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 
  r$   ry   r&   rz   N)r{   )r   r   s     rD   obtenerDatosClienter[    s*     < 	!4
+;E+Bk"[]]]s   #!#)"rU   r/   sysr   requestsr   r4   r   WPP_Whatsappr   utilsdateutil.relativedeltar   lectoresr   playwright.async_apir   r   rT   r   rO   r:   r_   rW   r   r   r   r   r   r  r  r.  rY  r[       rD   <module>re     s    3 3 3 3    0   -xV+H+= YgzEP*Z`22j0h41n-`=`~8z@Z`|,^rd  