
    g                         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 Z	 d Zd Zd Z	 d Zd Zd Zd Zd Zd Z	 d Zd Zd Z dS )    N)datetime)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://anaseguros.com.mx/anaweb/index.htmlc                 @  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          i |ddd           d {V  t          d
|d
         i           d {V  |D ]n}t!                                           |d                   }t#          |          r||d<    |||           d {V  Pt          |d
         d d           d {V  o|dz   | d<   d| d<   || d<   || d<   || d<   t%          |            d {V  n8t          |d
         d!d           d {V  |durt'          ||           d {V  t          |          dk    rWt          |	          dk    rFt          |d
         d!d           d {V  t)          |d
         |d         d"           d {V  d S d S d S )#NdataFconexionprimeraEjecucionpbrowserpagereconteo   id_tarea	err_bucle)r   statusid_conexionsessioncredenciales)r   r   	subtareaszSUBTAREAS TOTALES    r   funcionverificaLoginSesion../sessions/.jsonsiT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ejecutarProcesosAna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/ana.pyr:   r:      se      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$ ^T^3JW\^^^_________$
D4D&FHHHHHHHHH" f f		d9o..g	'		 fZgdD!!!!!!!!!! /d:>NZa0b0beeeeeeeeee&.lJz%*J!"%&JsO%,Jy%)Jv
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 {V  |                    d           d {V  t          d|d         i           d {V  |                    dd                                           d {V }|dk    r|d	         }t
          j                            d
| d          rt          j        d
| d           |                     t                     d {V  t          j        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 {V  nd}|S )NFTnetworkidler   divzwarningServicio temporalmentehas_textr   r   r   r      () => window.location.hrefzINICIANDO SESION...r   r"   	conectador'   )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_   v   s     . 			#  ///////// JZ0@"BDDDDDDDDD ||E4S|TTZZ\\\\\\\\,A-(G	w~~3W33344 /i-w---...
))H


-

)$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IIcNN	rE   c                   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 {V  | 	                    d
          
                                 d {V  | 	                    d                              d           d {V  |                     d          
                                 d {V  |                     d                              |           d {V  |                     d          
                                 d {V  |                     d                              |           d {V  |                     d          
                                 d {V  	 t          j        d           d {V  |                    t                    d	k    rSt#          i |ddd           d {V  t          j        d           d {V  t#          i |ddd           d {V  nD| j                            d| d           d {V  t#          i |dddd           d {V  d}|S )NFr   r   campo1campo2z./r   rL   rM   z#Iniciarz#CmbUsuario1USUARIOu   CONTRASEÑAENTRAR   zERROR DE INICIO DE SESION.r   rN    r   )r0   r   T)r"   rO   saveSession)r/   r0   r1   r2   rX   rY   rT   rP   pauserR   clickselect_optionget_by_placeholderfillget_by_textrU   rV   r7   contextstorage_state)r   r   r[   r   usuariopasswordr^   s          rD   rW   rW      s     .&''1''1( W^^''''(( !I   ]]#?@@@@@@@@*__X"$$
))H



Z  &&(((((((((]##11#666666666	**00222222222	**//888888888..44666666666..33H=========""((********* 	a__X##
a4a1N]^aaa
b
bbbbbbbb
-


F4F!FFF
G
GGGGGGGGG
,
$
$*G*G*G*G
$
H
HHHHHHHH
Z4Z!TXZZZ
[
[[[[[[[[N	rE   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   mensaje8https://server.anaseguros.com.mx/ananet/pages/Index.htmlr   r'   u   ¡Sesión validada con éxito!r$   _idr&   rw   r   zDatos incorrectos)r7   r_   r<   actualizarStatusSubtarea)r   r   r\   s      rD   r   r      s       D  DT-EX  fB  D  D  D  	E  	E  E  E  E  E  E  E  E12lnrtxyyyyyyyy `
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[$]$]
_
__________rE   c                 h  K   t          |d         d         dd           d {V  t          rt          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                              d                              dd                                           d {V  	 |                     d          4 d {V }|j         d {V }d|d           d!}|                    |           d {V  t-          ||           d {V  d"ad d d           d {V  d S # 1 d {V swxY w Y   d S # t0          $ rz t.          dz   at.          d#k    r6t          |d         d         d$d           d {V  t3          d%           Y d S t3          d&t.                     t5          | |           d {V  Y d S w xY wd S )'Nr$   rw   iniciadorx      %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 Planoname 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)ry   r\   obtenerFechasEnRangorR   filterrecompilerj   rl   rm   rU   rV   rn   frame_locatorrk   splitget_by_rolenthcheckexpect_downloadvaluesave_asleerExcelPorPagarloopReintentosCobranzar   r-   exportarReportePorPagarr   r   fecha_proximafecha_anteriorhoydownload_infodownloadrutaArchivos           rD   r   r      s      	!4
+;E+Bj"Z"Z\\\\\\\\\ &2)=a)L)L&M>3
,,u


$
$bj.E.E
$
F
F
L
L
N
NNNNNNNN

!
!"5
6
6
;
;I
F
FFFFFFFF
-




>
*
*
0
0
2
22222222


D
E
E
K
K
M
MMMMMMMM -




2
3
3
A
ABj
k
k
w
w  yC  D  D  J  J  L  L  L  L  L  L  L  L  L
-




2
3
3
A
ABj
k
k
w
w  yO  P  P  V  V  X  X  X  X  X  X  X  X  X
-




2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `n  `t  `t  ux  `y  `y  z{  `|  }  }  }  }  }  }  }  }  }


2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `n  `t  `t  ux  `y  `y  z{  `|  }  }  }  }  }  }  }  }  }


2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `m  `s  `s  tw  `x  `x  yz  `{  |  |  |  |  |  |  |  |  |


2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `m  `s  `s  tw  `x  `x  yz  `{  |  |  |  |  |  |  |  |  |


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  f  f  f  f  f  f  f  f  f2%%f%55 # # # # # # #&,,,,,,,]abk]l{+++++++++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2?&2 &2s>   T+ 8ATT+ 
T""T+ %T"&T+ +AV/ +V/.V/c                   K   t          j        |          }|                    t                    }g }|                                D ]2\  }}|                                                                s	d|j        v r ni 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#         }|	                    |           4t          d$| d$         i           d {V  t          | d%         d&|id'           d {V }t          | d(         d)         d*d+           d {V  t          j        |           d S ),Nrg   companiagnpclave_agenter   clienter   polizar   planrK   vencimiento_recibor   status_recibor|   fecha_pago_reciborf   inicio_vigencia   fin_vigencia   year_poliza   prima_anual	   prima_fraccionada
   moneda   conducto   f_pago   	asegurado   r   r   arrGnpPorPagarr   reportesr$   rw   r&   rx   pandas
read_excelastypestriterrowsisnullanyvaluesilocappendr*   registrarRecibosry   r/   r2   r   r   dfdatos_rowregistrorespuestaReciboss           rD   r   r   	  sh     %%" 
yy~~" %  fa
zz|| R3:--e%d>*>: chqk chqk	
 chqk chqk chqk chqk chqk chqk chqk chqk chrl chrl chrl  chrl!" chrl#H& 
LL 	!JZ0@"BDDDDDDDDD+d=>Qaqsx_z-|-|~~~~~~~~ 4
+;E+Bk"["[]]]]]]]]])KrE   c                   K   t          |d         d         dd           d {V  t          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 {V  	 |                     d           4 d {V }|j         d {V }t*           |d!          d"}|                    |           d {V  t/          ||           d {V  dad d d           d {V  d S # 1 d {V swxY w Y   d S # t2          $ rz t0          d
z   at0          d#k    r6t          |d         d         d$d           d {V  t5          d%           Y d S t5          d&t0                     t7          | |           d {V  Y d S w xY wd S )'Nr$   rw   r{   rx   r|   r}   rH   r~   rI   r   r   r   r   r   r   r   r   r   r   r   r   rK   r   r   r   r   r   r   r   r   r   r   r   _cartera_pagadar   r   r   r   )ry   r\   r   rR   r   r   r   rj   rU   rV   rl   rm   rn   r   rk   r   r   r   r   r   r   RUTA_FOLDERr   leerExcelPagadasr   r   r-   exportarReportePagadasr   s           rD   r   r   ;  s	      	!4
+;E+Bj"Z"Z\\\\\\\\\ *1)=a)L)L&M>3
,,u


$
$bj.E.E
$
F
F
L
L
N
NNNNNNNN
-



!
!"5
6
6
;
;I
F
FFFFFFFF
-




>
*
*
0
0
2
22222222


D
E
E
K
K
M
MMMMMMMM
 -




2
3
3
A
ABj
k
k
w
w  yC  D  D  J  J  L  L  L  L  L  L  L  L  L
-




2
3
3
A
ABj
k
k
w
w  yO  P  P  V  V  X  X  X  X  X  X  X  X  X
-




2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `n  `t  `t  ux  `y  `y  z{  `|  }  }  }  }  }  }  }  }  }


2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `n  `t  `t  ux  `y  `y  z{  `|  }  }  }  }  }  }  }  }  }


2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `m  `s  `s  tw  `x  `x  yz  `{  |  |  |  |  |  |  |  |  |


2
3
3
A
ABj
k
k
s
s  uP  Q  Q  _  _  `m  `s  `s  tw  `x  `x  yz  `{  |  |  |  |  |  |  |  |  |
-




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  f  f  f  f  f  f  f  f  f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1G*1 *1s>   U% ,AU?U% 
UU% U U% %AW):+W)(W)c                   K   t          j        |          }|                    t                    }g }|                                D ]2\  }}|                                                                s	d|j        v r ni 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#         }|	                    |           4t          d$| d$         i           d {V  t          | d%         d&|id'           d {V }t          | d(         d)         d*d+           d {V  t          j        |           d S ),Nrg   r   r   r   r   r   r   r   r   r   rK   r   r   r   r|   r   rf   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   arrGnpPagadasr   r$   rw   r&   rx   r   r   s           rD   r   r   m  sh     %%" 
yy~~" %  fa
zz|| R3:--e%d>*>: chqk chqk	
 chqk chqk chqk chqk chqk chqk chqk chqk chrl chrl chrl  chrl!" chrl#H& 
LL 	!JZ0@"BDDDDDDDDD+d=>Qaprw_y-{-{}}}}}}}} 4
+;E+Bk"["[]]]]]]]]])KrE   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$   rw   r{   rx   rv   z<Obteniendo recibos vencidos, por pagar, pagados y canceladosrK   rN   rG   r   buttonmenurI   link   Gestión de Negociosr   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 sistemarf   rg   ERRORr%   )ry   r_   r7   rQ   rU   rV   rR   r   rj   r   r   nowr   daymonthyearr   rm   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    s	      4
+;E+Bj"Z"Z\\\\\\\\\12lnrtxyyyyyyyy :`
  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)droprg   r   r   r   r   nanrK   r   r|   rf   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   )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   r7   r*   r-   r   )
r   r   r   
header_rowir   r   r   r   r   s
             rD   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-|-|~~~~~~~~rE   c                   K   |                     d           d {V }| 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trr$   fecha_reciboztd.renglon_color1r   ;rM   r   z#botonSiguiente)
query_selector_allr.   text_contentrY   r   r   rR   rS   rj   obtenTodosRecibosHistoricos)r   r   arrRecibosHistoricosreciboEncontradoitemsr%  rC   renglon_color1_tdssubArrtdtextoboton_siguientes               rD   r)  r)  !  s     ''--
-
-
-
-
-
-%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 9tEY[kllllllll 
rE   c                   K   t          |d         d         dd           d {V  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                                           d {V  t          j        d           d {V  |                                 4 d {V }|                     d                              d                              dd                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }t          ||g d            d {V }|                                 d {V  |}||d         d <   |                                 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 }|                                4 d {V }	|                    dd!                                           d {V  d d d           d {V  n# 1 d {V swxY w Y   t          d	|d	         i           d {V  |	j         d {V }
|
                    d"                                           d {V  |
                    d#                              d$           d {V  |
                    dd%          j                            d$           d {V  |
                                4 d {V }|
                    dd&          j                            d'           d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                    d(           d {V  t          i |d)dd           d {V  |j                            d*           d {V }|d+          d,|d         d          d-}t,           | }t/          |d.          5 }|                    |                                 d {V            t5          t,           | |           d {V  d d d            n# 1 swxY w Y   |                                 d {V  |
                                4 d {V }|
                    d/d0|d         d           d1                              d          j                                         d {V  d d d           d {V  n# 1 d {V swxY w Y   |j         d {V }|                    d(           d {V  |j                            d*           d {V }|d+          d2|d         d           d-}t,           | }t/          |d.          5 }|                    |                                 d {V            t5          t,           | |           d {V  d d d            n# 1 swxY w Y   t          i |d3ddd4|d         d5         |d         d         ||d6d7           d {V  t          d	|d	         i           d {V  t          |d         d         d8d           d {V  d S d S )9Nr$   rw   r{   rx   rv   u   Obteniendo póliza y recibosrK   rN   r   r   r   rI   r   r   r   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)r   exactr   zConsulta de comprobantes denumero_recibou   Documentación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/SMImprimeAuxr   _poliza_z.pdfwbr   z REC:  	_recibos_u   ¡Documentos disponibles!rg   type)r  r=  r4  nombre_numero_polizanombre_numero_recibo)r"   rO   r  descargar&   )ry   r_   r7   r*   rR   r   rj   r   r   rm   rU   rV   expect_popupr   r)  r   rn   r   firstrQ   requestr(   r   openwritebodysubirArchivoAS3)r   r   r\   page33_infopage33recibosHistoricosr7  
page1_infopage1
page2_infopage2
page3_infopage3responsenombrePolizar   fnombreRecibos                     rD   obtenerDocumentoPolizarU  A  s      4
+;E+Bj"Z"Z\\\\\\\\\12lnrtxyyyyyyyy W`
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9$DQQQQQQQQ ,,..%M(5D_%
   "" 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!!## E E E E E E Ezf+;<<BBDDDDDDDDDE E E E E E E E E E E E E E E E E E E E E E E E E E E #j$z2B$D
F
FFFFFFFF """""""E


M
*
*
0
0
2
22222222


N
O
O
U
UVa
b
bbbbbbbb


F);

<
<
B
H
H
U
UUUUUUUU!!## V V V V V V Vzf+?@@FLLW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"""""""E

#
#M
2
22222222
b4b1O^_bbb
c
cccccccc]&&'oppppppppH9oVVtJ/?/PVVVL 0,00K	k4	 	  JAggHMMOO######$$${:L::LIIIIIIIIIJ J J J J J J J J J J J J J J ++-- !!## { { { { { { {ze*W4
3CO3T*W*W*WXXddekllrxxzzzzzzzzz{ { { { { { { { { { { { { { { { { { { { { { { { { { {"""""""E

#
#M
2
22222222]&&'oppppppppH9oWWZ0@0QWWWL 0,00K	k4	 	  JAggHMMOO######$$${:L::LIIIIIIIIIJ J J J J J J J J J J J J J 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  Br  t  t  t  u  u  u  u  u  u  u  u  u
"j$z2B$D
F
FFFFFFFF
"T*-=e-DP[$]$]
_
__________oW` W`s   AM==
N
N4A#Q))
Q36Q3;0S==
T
T"6X**
X47X4A\--\14\1,A_
_ #_ $Ab==cc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$   rw   r&   rx   N)ry   )r   r   s     rD   obtenerDatosClienterW    sE      < 	!4
+;E+Bk"["[]]]]]]]]]]]rE   )!rU   r/   sysr   requestsr   r4   r   WPP_Whatsappr   utilsdateutil.relativedeltar   lectoresr   playwright.async_apir   r   rT   r   r:   r_   rW   r   r   r   r   r   r  r   r)  rU  rW   rE   rD   <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+: Yg Yg Ygz$ $ $N& & &R` ` `*2 *2 *2Z. . .d/1 /1 /1d- - -`=` =` =`~8 8 8z  @Z` Z` Z`|,^ ,^ ,^ ,^ ,^rE   