&h;ddlZddlZddlmZejj dddlmZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZy)N)datetimez/var/www/html/config)get_connectionct}|dddS |jd}d}|j||j}t |dkDr&dd|d |j |j Sdd gd |j |j S#t $r;}dd t|dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFError de conexiónsuccessmessageT dictionaryz SELECT ep.*, s.status AS nomstatus FROM empleados_perfiles ep INNER JOIN status s ON ep.status = s.id rzPerfiles encontradosrr datazNo se encontraron perfilesError: rcursorexecutefetchalllenclose Exceptionstr conexionBDrqueryresultes Q/var/www/dev.api.imparables.com.co/api_imparables/crm/administracion/profiling.pyconsultarPerfilr s!J -ABB""d"3  u" v;?1&   7     Q)      s6AB"<B"" C&+C!;C&<C)!C&&C))"D ct}|dddS |jd}|jd}|jd}|jd}d }|j||||f|j |j }d }|j||f|j }|r|d|d <||d <|j|jdd |d|j|jS#t$r;} ddt| dcYd} ~ j|jSd} ~ wwxYw#j|jwxYw)NFrrperfiles descripcionstatusTr zRINSERT INTO empleados_perfiles (perfiles, descripcion, status) VALUES (%s, %s, %s)"SELECT * FROM status WHERE id = %s nomstatusidzPerfil insertador r rgetrrcommit lastrowidfetchonerrr) r rrr r!rr id_insertador#rs rinsertarPerfilr+4se!J+  %88J'hh}- (#""d"3duxf=>'' 4uvi(OO%  )( 3D !T  )      Q)      s0CD E EE E E  E "E.ct}|dddS |jd}|jd}|jd}|jd}d }|j|||||f|j d }|j||f|j }|r|d|d <|j |j ||d <dd |d|j |j S#t$r;} ddt| dcYd} ~ j |j Sd} ~ wwxYw#j |j wxYw)NFrrrr r!Tr zXUPDATE empleados_perfiles SET perfiles = %s, descripcion = %s, status = %s WHERE id = %sr"r#r$zPerfil actualizador r rr&rrr'r)rrr) r$r rrr r!rrr#rs ractualizarPerfilr.esR!J -ABB88J'hh}- (#""d"3juxfbAB4uvi(OO%  )( 3D  T ,@$O   A ws1vh-?@@   A  s0CC:: D>D9D>E9D>>E"E#ct}|dddS |j}d}|j||f|jd}|dkDr%ddd|j |j Sd}|j||f|j |j |j dd d|j |j S#t $r;}dd t|dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrz1SELECT COUNT(*) FROM usuarios WHERE idperfil = %srz>No se puede eliminar el perfil porque tiene usuarios asociadosz,DELETE FROM empleados_perfiles WHERE id = %sTzPerfil eliminado correctamenter)rrrr)rr'rr)r$rrrcountrs reliminarPerfilr1s0!J -ABB""$Dure$!!$ 19$1qr  ?ure$ ,LM   A ws1vh-?@@   A  s7AC5A C D#(D8D#9D&D##D&&"Ec2t}|dddS |jd}d}|j|t|f|j }t |dkDr&dd|d |j |j Sdd gd |j |j S#t$r;}dd t|dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrTr a# SELECT p.*, m.modulo, mv.nombre_vista AS vista FROM permisos p INNER JOIN modulos m ON p.id_modulo = m.id INNER JOIN modulos_vistas mv ON p.id_vista = mv.id WHERE p.id_perfil = %s AND p.id_elemento IS NULL rPermisos encontradosr z5No se encontraron permisos de vistas para este perfilr) rrrintrrrrr id_perfilrrrrrs rconsultarPermisosVistasr7s!J+  """d"3  us9~/0" v;?1&   R     Q)      s6AB-B-- C16C,C1C4,C11C44"Dc t}|dddS |jd}d}|j||f|j}t |dkDr&dd|d |j |j Sdd gd |j |j S#t $r;}dd t|dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrTr aP SELECT p.*, m.modulo, mv.nombre_vista AS vista, pe.elemento FROM permisos p INNER JOIN modulos m ON p.id_modulo = m.id INNER JOIN modulos_vistas mv ON p.id_vista = mv.id LEFT JOIN permisos_elementos pe ON pe.id = p.id_elemento WHERE p.id_perfil = %s rr3r +No se encontraron permisos para este perfilrrr5s rconsultarPermisosr: !J -ABB"""d"3  uyl+" v;?1&   H     Q)      6A B$>B$$ C(-C#=C(>C+#C((C++"D c t}|dddS |jd}d}|j||f|j}t |dkDr&dd|d |j |j Sdd gd |j |j S#t $r;}dd t|dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrTr a] SELECT p.*, m.modulo, mv.nombre_vista AS vista, pe.elemento AS elemento FROM permisos p INNER JOIN modulos m ON p.id_modulo = m.id INNER JOIN modulos_vistas mv ON p.id_vista = mv.id INNER JOIN permisos_elementos pe ON p.id_elemento = pe.id WHERE p.id_perfil = %s rr3r r9rrr5s rconsultarPermisosElementosr>r;r<ct}|dddS |jd}d}|j||j}|r&dd|d|j |j Sdd d|j |j S#t $r;}dd t |dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrTr zSELECT * FROM modulosuMódulos encontradosr uError al buscar los módulosrrrrrrrrrs rconsultarModulosrA0s!J -ABB""d"3'u" 1   %1OP     Q)      s5ct}|dddS |jd}d}|j||f|j}|r&dd|d|j |j Sdd d|j |j S#t $r;}dd t |dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrTr z1SELECT * FROM modulos_vistas WHERE id_modulo = %szVistas encontradasr zError al buscar las vistasrr@) id_modulorrrrrs rconsultarVistasrDQs!J -ABB""d"3Cuyl+" /   %1MN     Q)      5>B2B C C0C1CCC"Dct}|dddS |jd}d}|j||f|j}|r&dd|d|j |j Sdd d|j |j S#t $r;}dd t |dcYd}~j |j Sd}~wwxYw#j |j wxYw) NFrrTr z1SELECT * FROM permisos_elementos WHERE vista = %szElementos encontradosr zError al buscar los elementosrr@)id_vistarrrrrs rconsultarElementosrHqs!J -ABB""d"3Cuxk*" 2   %1PQ     Q)      rEc t}|dddS |jd}|jd}|jd}|jd}|jd}|jd }d }|j||||||f|j |j } d }|j|| f|j } |j|jd d | d|j|jS#t$r;} ddt| dcYd} ~ j|jSd} ~ wwxYw#j|jwxYw)NFrrr6rCrG id_elementopermisoTr zgINSERT INTO permisos (id_perfil, id_modulo, id_vista, id_elemento, permiso) VALUES (%s, %s, %s, %s, %s)I SELECT p.*, m.modulo, mv.nombre_vista AS vista, pe.elemento FROM permisos p INNER JOIN modulos m ON p.id_modulo = m.id INNER JOIN modulos_vistas mv ON p.id_vista = mv.id LEFT JOIN permisos_elementos pe ON pe.id = p.id_elemento WHERE p.id = %s zPermiso insertador rr%) r rr6rCrGrJrKrr id_permisopermiso_insertadors rinsertarPermisorOsf!J -ABB"HH[) HH[) 88J'hh}- ((9%""d"3yuy)X{GTU%%   uzm,"OO- ,?IZ[   A ws1vh-?@@   A  s0C&D E#E3E4E!EE!!"Fc t}|dddS |jd}|jd}|jd}|jd}|jd}|jd }d } |j| ||||||f|j d } |j| |f|j } |j |j d d | d|j |j S#t$r;} ddt| dcYd} ~ j |j Sd} ~ wwxYw#j |j wxYw)NFrrr6rCrGrJrKTr z UPDATE permisos SET id_perfil = %s, id_modulo = %s, id_vista = %s, id_elemento = %s, permiso = %s WHERE id = %s rLzPermiso actualizador rr-) rMr rr6rCrGrJrKrrpermiso_actualizadors ractualizarPermisorRsb!J -ABB$HH[) HH[) 88J'hh}- ((9%""d"3  uy)X{GU_`a  uzm,$oo/ ,AK^_   A ws1vh-?@@   A  s0CD EE(E)EEE"E8ct}|dddS |j}d}|j||f|j|j |j ddd|j |j S#t $r;}ddt |dcYd}~j |j Sd}~wwxYw#j |j wxYw)NFrrz"DELETE FROM permisos WHERE id = %sTzPermiso eliminado correctamenter)rrrr'rrr)rMrrrrs reliminarPermisorTs!J -ABB""$4uzm, ,MN   A ws1vh-?@@   A  s0AB CC &C'C CC"C6)jsonsysrpathappendcnxpdorrr+r.r1r7r:r>rArDrHrOrRrTrr\sv &'!$P-b HD7*\'V'VB@@'V)Zr[