
    ^h                          d dl mZ d dlZddZy)    )get_connectionNc                 2   d }d }d}d}| r | j                   xs d}| j                  xs d}	 t               }|*ddd|r|j                          |r|j                          S S |j	                  d      }d}|j                  |       |j                         }|r|d	   nd
}|dz
  |z  }d}	|j                  |	||f       |j                         }
|d
kD  rt        j                  ||z        nd}dd| d|
r|
ng |||d|r|j                          |r|j                          S S # t        $ r@}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)N      Fu%   Error de conexión a la base de datos)successmessageT)
dictionaryz9SELECT COUNT(*) as total FROM descartados_contactabilidadtotalr   zk
            SELECT *
            FROM descartados_contactabilidad 
            LIMIT %s OFFSET %s
        zSe encontraron z descartados)r   r   datatotalRecords
totalPagescurrentPagezError: )pagepageSizer   closecursorexecutefetchonefetchallmathceil	Exceptionstr)request_dataconexionr   r   	page_sizecount_querytotal_resulttotal_recordsoffsetqueryresulttotal_pageses                M/var/www/dev.api.imparables.com.co/api_imparables/crm/procesos/descartados.pyobtener_descartadosr&      s   HF DI   %A )).Q	0!#$1XYT LLNNN U D1 R{#(1=W-1 (i' 	uy&12" ?La>Odii	 9:UV (|D$F")%
  LLNNN   
 Q)
 	
 LLNNN 
 LLNNN s6   D# "BD# #	E,,E'<E,=E/ 'E,,E/ /'F)N)cnxpdor   r   r&        r%   <module>r*      s    ! =r)   