i1`SSKJr SSKJr SrSrSrSSjrSrSr S r S r S r SS jr g ))logger)get_connectionc$Sn[5nU(d [S5eUR5nURU5 UR 5nUVs/sH:nUSUSUSUSUSUSUS US US US US USUSS. PM< snU(aUR 5 $$s snf![ a2n[SU35 /sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)u/Obtiene las compañías desde la base de datos.ax SELECT UserRequests.RequestID, UserRequests.RequestTypeID, UserRequests.BusinessName, UserRequests.LegalRepresentative, UserRequests.PrimaryContact, UserRequests.ContactEmail, UserRequests.FiscalAddress, UserRequests.PostalCode, UserRequests.State, UserRequests.City, UserRequests.ContactPhone, UserRequests.Comments, FORMAT(UserRequests.CreatedAt, 'dd-MM-yyyy HH:mm') AS CreatedAt FROM UserRequests WHERE (RequestTypeID = 'DISCAN' OR RequestTypeID = 'DISEUA') AND Status = 'PENDIENTE' 4No se pudo establecer conexión con la base de datosr RequestID RequestTypeID BusinessNameLegalRepresentativePrimaryContact ContactEmail FiscalAddress PostalCodeStateCity ContactPhoneComments CreatedAtz:[Error inesperado] Error obteniendo a los distribuidores: NrConnectionErrorcursorexecutefetchallclose Exceptionprintqueryconnr#resultsrowes sC:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Ventas\VentasEUA\AccessDistributorsSQL.pyget_AccessDistributorsr0s* E*!"XY Yu//# c$'q6#&q6#&q6#&q6#&q6#&q6#&q6#&q6#&q6#&q6#&r7#&r7#&r7 *  JJL +"  J1#NO  JJL    JJL sCAB6AB1B61B66 C2C-C2C5-C22C55DcSn[5nU(d [S5eUR5nURU5 UR 5nUVs/sHnUSUSS.PM snU(aUR 5 $$s snf![ a2n[SU35 /sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)z>Obtiene la Lista de Vendedores para asignarle al distribuidor.a: SELECT UserRoles.UserID, Concat (Profiles.FirstName,' ',Profiles.LastName) AS Seller FROM Roles LEFT JOIN UserRoles ON Roles.RoleID = UserRoles.RoleID LEFT JOIN Profiles ON UserRoles.UserID = Profiles.UserID WHERE Roles.RoleID = 'V-P-VEEU' rrr)UserIDSellerz6[Error inesperado] Error obteniendo a los vendedores: Nr!r)s r/get_SellerforDistributorsr4@s E!"XY Yu//# !"!# FQ!"  JJL "  FqcJK  JJL    JJL sBAB B*B B CC#C$C CC C#cXSn[5nU(d [S5eUR5nURX45 UR 5nU(aOUSUSUSUSUSUSUS US US US US USUSS. U(aUR 5 $$SS0U(aUR 5 $$![ a>n[SU35 S[U5S.sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)uHObtiene los comentarios de un distribuidor específico por su RequestID.a. SELECT UserRequests.RequestID, UserRequests.RequestTypeID, UserRequests.BusinessName, UserRequests.LegalRepresentative, UserRequests.PrimaryContact, UserRequests.ContactEmail, UserRequests.FiscalAddress, UserRequests.PostalCode, UserRequests.State, UserRequests.City, UserRequests.ContactPhone, UserRequests.Comments, FORMAT(UserRequests.CreatedAt, 'dd-MM-yyyy HH:mm') AS CreatedAt FROM UserRequests WHERE RequestID = ? rrrrr r r r r rrrrrrrzB[Error inesperado] Error obteniendo comentarios del distribuidor: )rerrorN rr"r#r$fetchoner&r'r(str)distributor_idr*r+r#resultr.s r/get_distributorSelectedinfor=cs6 E(!!"XY Yu/0" '-ay'-ay'-ay'-ay'-ay'-ay'-ay'-ay'-ay'-ay'-bz'-bz'-bz,  JJL  #  JJL  1 RSTRUVWQ00  JJL  1  JJL s6B C(C D D)D *DD  DD)cSn[5nU(d [S5eUR5nURX U45 UR 5 SS0U(aUR 5 $$![ a=n[SU35 S[U50sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)zl Asigna un rol al usuario en la tabla UserRoles. Por defecto, asigna el rol "V-P-DIEU" para distribuidores. zT INSERT INTO UserRoles ( UserID, RoleID ) VALUES (?, ?) rmessagez%Rol asignado correctamente al usuarioz,[Error SQL] Error asignando rol al usuario: r7N rr"r#r$commitr&r'r(r:)user_idrole_idr*r+r#r.s r/insert_user_rolerDs  E !"XY Yu01 BC  JJL  ! 8~&"%&)4 DE  JJL  ".LM  JJL  ! 9!=>Q   JJL  !  JJL s6B C'C D D(D )DD  DD(c Sn[5nU(d [S5eUR5nURX45 UR 5nU(dSSU30U(aUR 5 $$USUSUSS.U(aUR 5 $$![ a=n[S U35 S[U50sS nAW(aUR 5 $$S nAff=f!W(aUR 5 ff=f) zH Obtiene CompanyID, DivisionID y DepartamentID basado en RequestTypeID. z SELECT CompanyID, DivisionID, DepartamentID FROM RequestType WHERE RequestTypeID = ? rr7u4No se encontró información para el RequestTypeID: rrr) CompanyID DivisionID DepartamentIDu@[Error SQL] Error obteniendo información de tipo de solicitud: Nr8)rNr*r+r#r<r.s r/get_request_type_inforVs E!"XY Yu01"STcSdef  JJL   )#AY   JJL  ! PQRPSTUQ   JJL  !  JJL s6AB8B C&)C!C&C)!C&&C))DcSn[5nU(d [S5eUR5nURUXX#UXVXxXXXUU45 UR 5 SS0U(aUR 5 $$![ a=n[SU35 S[U50sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)z: Inserta un nuevo perfil de usuario en la tabla Profiles. aL INSERT INTO Profiles ( UserID, RequestID, RequestTypeID, BusinessName, LegalRepresentative, PrimaryContact, FiscalAddress, PostalCode, State, City, Discount, SellerUserID, Email, ContactPhone, CompanyID, DivisionID, DepartamentID ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) rr?z&Perfil de usuario creado correctamentez-[Error SQL] Error creando perfil de usuario: r7Nr@)rBrJrN business_namelegal_representativeprimary_contactfiscal_address postal_codestatecitydiscountseller_user_idrG contact_phone company_id division_iddepartament_idr*r+r#r.s r/insert_user_profilere?s  E!"XY Yu AU [ =k>  CD  JJL  ! =aSABQ   JJL  !  JJL s0AA88 B?B:B?C:B??CCNcSnX4n[5nU(d [S5eUR5nURX45 UR 5 SS0U(aUR 5 $$![ a=n[SU35 S[U50sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)u Actualiza el estado a RECHAZADO y fecha de revisión en UserRequests. El comentario (motivo del rechazo) no se guarda en la base de datos, solo se usa para el correo electrónico. z| UPDATE UserRequests SET Status = 'RECHAZADO', ReviewDate = ? WHERE RequestID = ? rr?z!Solicitud rechazada correctamentez@[Error SQL] Error actualizando estado de solicitud a RECHAZADO: r7Nr@)rJrK comentarior*paramsr+r#r.s r/update_user_request_rejectedrids  E &F!"XY Yu% >?  JJL  ! PQRPSTUQ   JJL  !  JJL s0AA00 B7:B2B7B:2B77B::C)zV-P-DIEU)N)venvrConsultas_SQL.conexionrr0r4r=rDrHrLrQrVrerir/rnsE 16p!F7r8::%N$L!Jrm