
    Hh              
           d dl mZmZmZmZ d dlZd dlmZ d dlZej                  j                  d       d dl
mZ dee   deded	eeef   fd
Zd	eeef   fdZy)    )ListOptionalDictAnyN)datetimez/var/www/html/config)get_connectionfechapagina
por_paginareturnc           	         d }d }	 t               }|st        d      | r	 t        j                  | d       t        dt        |            }t        dt        dt        |                  }|dz
  |z  }d}g }| r|dz  }|j                  |        |dz  }|j                  ||g       |j                  d	
      }|j                  ||       |j                         }|D ]4  }	t        |	d   t              r|	d   j                  d      |	d<   |	d   |	d<   6 |j                  d       |j                         d   }
||||
|
|z   dz
  |z  dd|r|j!                          |r|j!                          S S # t        $ r t	        d      w xY w# t        $ r'}t#        j$                  dt'        |               d }~ww xY w# |r|j!                          |r|j!                          w w xY w)N2   No se pudo establecer conexión a la base de datosz%Y-%m-%du*   Formato de fecha inválido. Use YYYY-MM-DD   d   z;SELECT SQL_CALC_FOUND_ROWS * FROM inscripciones_voluntariosz< WHERE DATE(fecha_registro) = STR_TO_DATE(%s, '%%Y-%%m-%%d')z$ ORDER BY id DESC LIMIT %s OFFSET %sT
dictionaryfecha_registro%Y-%m-%d %H:%M:%SidzSELECT FOUND_ROWS()zFOUND_ROWS())pagina_actualr   total_registrostotal_paginas)datos
paginacionzError en obtener_voluntarios: )r   	Exceptionr   strptime
ValueErrormaxintminappendextendcursorexecutefetchall
isinstancestrftimefetchonecloseloggingerrorstr)r	   r
   r   conexionr#   offsetqueryparamsr   
voluntariototales               T/var/www/dev.api.imparables.com.co/api_imparables/landing/voluntarios/voluntarios.pyobtener_voluntariosr5      s   HF@!#PQQ O!!%4
 QF$CS_56
1*
* NSSEMM% 77z6*+ D1uf%!   	0J*%56A/9:J/K/T/TUh/i
+,  *$/Jt	0 	,-!.1 !'(#("'*"4q"8Z!G	
 LLNNN k  O !MNNO\  6s1vh?@
 LLNNN s:   F E/ DF /FF 	F7"F22F77F: :'G!c                     d } d }	 t               } | st        d      d}| j                  d      }|j                  |       |j	                         }|D ]w  }t        |d   t              r|d   j                  d      |d<   |j                  dd      xs d|d<   |j                  d	d      xs d|d	<   |j                  d
d      xs d|d
<   y d|d|r|j                          | r| j                          S S # t        $ ra}t        j                  dt        |              ddt        |       dcY d }~|r|j                          | r| j                          S S d }~ww xY w# |r|j                          | r| j                          w w xY w)Nr   z'SELECT * FROM inscripciones_voluntariosTr   r   r   recomendado como_ayudarpasionr   )successdatazError al obtener voluntarios: r   )r;   message)r   r   r#   r$   r%   r&   r   r'   getr)   r*   r+   r,   )r-   r#   r/   voluntariosr1   r3   s         r4   obtener_todos_voluntariosr@   T   s   HF'!#PQQ :D1uoo' & 	FJ*%56A/9:J/K/T/TUh/i
+, )3}b(I(ORJ}%(2}b(I(ORJ}%#->>(B#?#E2Jx 	F 
 LLNNN   
6s1vh?@7Ax@
 	

 LLNNN 
 LLNNN s0   CC8 8	E"1E2E"3E% E""E% %'F)typingr   r   r   r   r*   r   syspathr!   cnxpdor   r,   r   r5   r@        r4   <module>rG      sr    , ,   
 & ' !Dx} Dc Ds DtTWY\T\~ DR+4S> +rF   