
    *[hZ                         d dl Z d dlZd dlZe j                  j	                  d       d dlmZ d dlmZ d dlZd Z	d Z
d Zd Zy)	    Nz/var/www/html/config)get_connection)datetimec                  j   t               } | dddS 	 d}| j                  d      }|j                  |       |j                         }|j	                          | j	                          dd|d	S # t
        $ r;}j	                          | j	                          dd
t        |       dcY d }~S d }~ww xY w)Nr      Error de conexiónsuccessmessagez
            SELECT e.*, s.status AS nomstatus, u.idperfil
            FROM empleados e
            LEFT JOIN usuarios u ON e.id = u.idEmpleado
            LEFT JOIN status s ON s.id = e.status
        T)
dictionary   zUsuarios encontradosr   r	   dataError: )	r   cursorexecutefetchallclose	Exceptionstridfetchone)
conexionBDqueryr   userDataeempleados         Z/var/www/dev.api.imparables.com.co/api_imparables/crm_asincrono/administracion/employee.pylistEmpleadosr      s    !J+
 	


 ""d"3u??$ -
 	
  
 Q)
 	

s   AA. .	B270B-'B2-B2c                    t               }|dddS 	 |j                         }d}|j                  || d   | d   | d   | d   | d	   | d
   | d   | d   | d   | d   | d   f       |j                          |j                  }t        t        j                  dd            }t        j                  |j                               j                         }d}|j                  ||| d   |f       |j                          || d<   || d<   |j                          |j                          dd| dS # t        $ r+}|j                          ddt        |       dcY d }~S d }~ww xY w)Nr   r   r   a  
            INSERT INTO empleados (nombres, apellidos, tipo_doc, documento, id_area, id_cargo, correo_corporativo, 
                                   correo_alterno, telefono, direccion, status)
            VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
        nombres	apellidostipo_doc	documentoid_areaid_cargocorreo_corporativocorreo_alternotelefono	direccionstatusi i?B zl
            INSERT INTO usuarios (idEmpleado, idperfil, passtemp) 
            VALUES (%s, %s, %s)
        idperfilpasstempr   r   zEmpleado insertador   r   )r   r   r   commit	lastrowidr   randomrandinthashlibmd5encode	hexdigestr   r   )	r   r   r   r   r   random_coderandomCodeEncryptedquery2r   s	            r   insertarEmpleador7   K   s   !J)=>>+
""$
 	uOT+.Z0@${BSUYZcUdfjkufv%&-=(>Z@PRVWbRceijres
 	 	 &..89%kk+*<*<*>?IIK 	vD$46IJK&ZT
 +
 	
  
 Q)
 	

s   DD) )	E2 EEEc                    t               }|dddS 	 |j                         }|d   }d}|j                  ||d   |d   |d   |d	   |d
   |d   |d   |d   |d   |d   |d   | f       |j                          d}|j                  ||d   | f       |j                          |j	                          |j	                          | |d<   ||d<   dd|dS # t
        $ r+}|j	                          ddt        |       dcY d }~S d }~ww xY w)Nr   r   r   	nomstatusa  
            UPDATE empleados 
            SET nombres = %s, apellidos = %s, tipo_doc = %s, documento = %s, id_cargo = %s, id_area = %s, 
                correo_corporativo = %s, correo_alterno = %s, telefono = %s, direccion = %s, status = %s 
            WHERE id = %s
        r   r    r!   r"   r$   r#   r%   r&   r'   r(   r)   z7UPDATE usuarios SET idperfil = %s WHERE idEmpleado = %sr*   r   r   zEmpleado actualizador   r   )r   r   r   r,   r   r   r   )r   r   r   r   r9   r   r6   r   s           r   actualizarEmpleador:   }   sb   !J)=>>(
""$%	 	uOT+.Z0@${BSUYZdUegklugv%&-=(>Z@PRVWbRceijresuw
 	 	 KvZ 0"56 	T
%[ -
 	
  
 Q)
 	

s   B>C 	D D;DDc                 p   t               }|dddS 	 |j                         }d}|j                  || f       |j                          |j	                          |j	                          |j
                  dkD  rdddS dddS # t        $ r+}|j	                          ddt        |       dcY d }~S d }~ww xY w)	Nr   r   r   z#DELETE FROM empleados WHERE id = %sr   zEmployee deletedzFailed to delete employeer   )r   r   r   r,   r   rowcountr   r   )r   r   r   r   r   s        r   eliminarEmpleador=      s    !J)=>>=""$ 6ure$??Q -?@@ -HII =73q6();<<=s$   A(B <B 	B5
 B0*B50B5)sysosr.   pathappendcnxpdor   r   r0   r   r7   r:   r=        r   <module>rE      sA    
 	  & ' !  :=x0
d-
^=rD   