U âøi6ã@srddlZddlZddlmZdd„Zdd„Zdd„Zd d „Zd d „Zd d„Z dd„Z dd„Z dd„Z ddd„Z dS)éN)Úget_connectionc Csšd}z‚z@tƒ}|stdƒ‚| ¡}| |¡| ¡}dd„|DƒWW¢BStk r‚}ztd|›ƒgWY¢W¢Sd}~XYnXW5|r”| ¡XdS)zCObtiene los empleados pendientes de aprobar desde la base de datos.ah SELECT UserRequests.RequestID, UserRequests.FirstName, UserRequests.LastName, Division.Division, Departament.Departament, UserRequests.Position, UserRequests.DirectSupervisor, UserRequests.PermissionType, FORMAT(UserRequests.CreatedAt, 'dd-MM-yyyy HH:mm') AS CreatedAt FROM UserRequests LEFT JOIN Division ON UserRequests.DivisionID = Division.DivisionID LEFT JOIN Departament ON UserRequests.DepartamentID = Departament.DepartamentID WHERE (RequestTypeID = 'EMPLEADO') AND Status = 'PENDIENTE' õ4No se pudo establecer conexión con la base de datosc SsHg|]@}|d|d|d|d|d|d|d|d|dd œ ‘qS) réééééééé) Ú RequestIDÚ FirstNameÚLastNameÚDivisionÚ DepartamentÚPositionÚDirectSupervisorÚPermissionTypeÚ CreatedAt©©Ú.0ÚrowrrúuC:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\SupYCtrol\DataMaster\DMAccessEmployeeSQL.pyÚ 's ÷÷z'get_AccessEmployees..z:[Error inesperado] Error obteniendo listado de empleados: N©ÚcloserÚConnectionErrorÚcursorÚexecuteÚfetchallÚ ExceptionÚprint©ÚqueryÚconnrÚresultsÚerrrÚget_AccessEmployees s   ö "r(cCsd}zúz®tƒ}|stdƒ‚| ¡}| ||f¡| ¡}|sLddiWW¢¸S|d|d|d|d|d |d |d |d |d |d|d|d|d|d|d|ddœWW¢LStk rü}z&td|›ƒdt|ƒiWY¢W¢Sd}~XYnXW5|r| ¡XdS)uAObtiene la información completa de un empleado por su RequestID.a$ SELECT FORMAT(UserRequests.CreatedAt, 'dd-MM-yyyy HH:mm') AS CreatedAt, FirstName, MiddleName, LastName, SecondLastName, RequestType, Position, DirectSupervisor, PermissionType, CorporateEmail, ContactPhone, EmployeeNumber, Company, Division, Departament, Comments FROM UserRequests LEFT JOIN RequestType ON UserRequests.RequestTypeID = RequestType.RequestTypeID LEFT JOIN Company ON UserRequests.CompanyID = Company.CompanyID LEFT JOIN Division ON UserRequests.DivisionID = Division.DivisionID LEFT JOIN Departament ON UserRequests.DepartamentID = Departament.DepartamentID WHERE RequestID = ? rÚerrorzEmpleado no encontradorrrrrrr r r é é é é é éé)rr Ú MiddleNamerÚSecondLastNameZ RequestTyperrrÚCorporateEmailÚ ContactPhoneÚEmployeeNumberZCompanyrrZCommentsu4[Error] Error obteniendo información del empleado: N) rrrrrÚfetchoner!r"Ústr)Ú request_idr$r%rrr'rrrÚget_info:s@ð *r9c Csšd}z‚z@tƒ}|stdƒ‚| ¡}| |¡| ¡}dd„|DƒWW¢BStk r‚}ztd|›ƒgWY¢W¢Sd}~XYnXW5|r”| ¡XdS)z2Obtiene todos los tipos de formulario disponibles.zy SELECT RequestTypeID, RequestType FROM RequestType ORDER BY RequestType rcSsg|]}|d|ddœ‘qS©rr)ÚidÚnamerrrrrr”sz)get_all_request_types..z.[Error] Error obteniendo tipos de formulario: Nrr#rrrÚget_all_request_types€s  "r=c Cs¢d}zŠzHtƒ}|stdƒ‚| ¡}| ||||f¡| ¡}dd„|DƒWW¢BStk rŠ}ztd|›ƒgWY¢W¢Sd}~XYnXW5|rœ| ¡XdS)uEObtiene los roles filtrados por compañía, división y departamento.z¿ SELECT RoleID, RoleName FROM Roles WHERE CompanyID = ? AND DivisionID = ? AND DepartamentID = ? ORDER BY RoleName rcSsg|]}|d|ddœ‘qSr:rrrrrr´sz(get_roles_by_filters..z*[Error] Error obteniendo roles filtrados: Nr)Ú company_idÚ division_idÚdepartament_idr$r%rr&r'rrrÚget_roles_by_filtersœs "rAc Csšd}z‚z@tƒ}|stdƒ‚| ¡}| |¡| ¡}dd„|DƒWW¢BStk r‚}ztd|›ƒgWY¢W¢Sd}~XYnXW5|r”| ¡XdS)u*Obtiene todas las compañías disponibles.zi SELECT CompanyID, Company FROM Company ORDER BY Company rcSsg|]}|d|ddœ‘qSr:rrrrrrÐsz%get_all_companies..u&[Error] Error obteniendo compañías: Nrr#rrrÚget_all_companies¼s  "rBc Csžd}z†zDtƒ}|stdƒ‚| ¡}| ||f¡| ¡}dd„|DƒWW¢BStk r†}ztd|›ƒgWY¢W¢Sd}~XYnXW5|r˜| ¡XdS)u7Obtiene las divisiones para una compañía específica.z SELECT DivisionID, Division FROM Division WHERE CompanyID = ? ORDER BY Division rcSsg|]}|d|ddœ‘qSr:rrrrrrîsz,get_divisions_by_company..z%[Error] Error obteniendo divisiones: Nr)r>r$r%rr&r'rrrÚget_divisions_by_companyØs "rCc Cs d}zˆzFtƒ}|stdƒ‚| ¡}| |||f¡| ¡}dd„|DƒWW¢BStk rˆ}ztd|›ƒgWY¢W¢Sd}~XYnXW5|rš| ¡XdS)uGObtiene los departamentos para una compañía y división específicas.z´ SELECT DepartamentID, Departament FROM Departament WHERE CompanyID = ? AND DivisionID = ? ORDER BY Departament rcSsg|]}|d|ddœ‘qSr:rrrrrr sz/get_departments_by_division..z([Error] Error obteniendo departamentos: Nr)r>r?r$r%rr&r'rrrÚget_departments_by_divisionös "rDc Csšd}z‚zBtƒ}|stdƒ‚| ¡}| ||f¡| ¡}|ddkWW¢@Stk r‚}ztd|›ƒWY¢W¢dSd}~XYnXW5|r”| ¡XdS)u?Verifica si un correo electrónico ya existe en la tabla Users.zE SELECT COUNT(*) AS count FROM Users WHERE Email = ? rrz/[Error] Error verificando si el correo existe: FN)rrrrrr6r!r")Úemailr$r%rrr'rrrÚcheck_if_email_existss rFc Cs¦zŽzs 1F u