+ i ^RIHt^RItRtR#))get_connectionNc RpRp\4pV'g'\R4.V'dVP4##VP4pVP V4VP Uu.uF q3^,NK ppVP 4Uu.uFp\\WE44NK ppTV'dVP4##uupiuupi \Pd4p\RT 24.uRp?T'dTP4##Rp?i\d4p\RT 24.uRp?T'dTP4##Rp?ii;i T'dTP4ii;i)u Obtiene la lista completa de tareas de cotización desde la BD. Esta función es llamada por el endpoint en CotizFormQueryIng.py u SELECT -- 🟦 Identificadores principales Q_SpQ_QuotationTasks.TaskID AS [NroTarea], Q_SpQ_QuotationTasks.Status AS [Estatus], Q_OpportunityCRM.CRM_OpportunityNumber AS [Oportunidad], Q_QuotationType.FrontES AS [TipoFormulario], -- 🟩 Fechas clave (Con FORMATO) Q_SpQ_FormsHead.FormID AS [NroFormulario], FORMAT(Q_SpQ_FormsHead.CreatedAt, 'dd-MM-yyyy HH:mm') AS [FechaCreacion], -- 🟨 Información del cliente (CRM) Q_OpportunityCRM.CRM_ContactName AS [Contacto], -- 🟧 Información del vendedor (desde Profiles) Profiles.FirstName + ' ' + ISNULL(Profiles.MiddleName, '') + ' ' + Profiles.LastName + ' ' + ISNULL(Profiles.SecondLastName, '') AS [Vendedor], Profiles.Email AS [CorreoVendedor], Profiles.ContactPhone AS [TelefonoVendedor], -- 🟥 Información de costeo (puede estar vacía si no se ha generado) Q_CostingHead.CostingNum AS [NroCosteo], Q_CostingHead.CaseCost AS [CasoCosteo], Q_CostingHead.DirectCost AS [CostoDirecto], Q_CostingHead.IndirectPercent AS [PctIndirecto], Q_CostingHead.IndirectAmount AS [MontoIndirecto], Q_CostingHead.FinancePercent AS [PctFinanciamiento], Q_CostingHead.FinanceAmount AS [MontoFinanciamiento], Q_CostingHead.UtilityPercent AS [PctUtilidad], Q_CostingHead.UtilityAmount AS [MontoUtilidad], Q_CostingHead.OperationPercent AS [PctGtosOp], Q_CostingHead.OperationAmount AS [MontoGtosOp], Q_CostingHead.OvercostFactor AS [FactorSobrecosto], Q_CostingHead.SalePriceMin AS [PrecioVentaMin], Q_CostingHead.DiscountMaxPercent AS [PctDescMax], Q_CostingHead.DiscountMaxAmount AS [MontoDescuento], Q_CostingHead.SalePriceList AS [PrecioLista], -- 🟪 Tiempo de ejecución formateado LTRIM(RTRIM(CONCAT( ISNULL(CAST(Q_CostingHead.RunTimeNumber AS NVARCHAR(10)), ''), ' ', ISNULL(Q_CostingHead.RunTimeType, '') ))) AS [TiempoEjecucion] FROM Q_SpQ_QuotationTasks INNER JOIN Q_SpQ_FormsHead ON Q_SpQ_QuotationTasks.FormID = Q_SpQ_FormsHead.FormID INNER JOIN Q_QuotationType ON Q_SpQ_FormsHead.QuotationTypeID = Q_QuotationType.QuotationTypeID INNER JOIN Q_OpportunityCRM ON Q_SpQ_QuotationTasks.CRM_OpportunityID = Q_OpportunityCRM.CRM_OpportunityID LEFT JOIN Q_CostingHead ON Q_SpQ_QuotationTasks.CostingID = Q_CostingHead.CostingID LEFT JOIN Profiles ON Q_SpQ_QuotationTasks.SellerUserID = Profiles.UserID WHERE Q_SpQ_QuotationTasks.Active = 1 ORDER BY Q_SpQ_QuotationTasks.Status, Q_SpQ_FormsHead.CreatedAt DESC; Nu@Error SQL: No se pudo establecer conexión con la base de datos.z8[Error SQL pyodbc] Error obteniendo la lista de tareas: z,[Error inesperado] Error en get_tasks_list: ) rprintclosecursorexecute descriptionfetchalldictzippyodbcError Exception)queryconnrcolumncolumnsrowresultses ~C:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Operaciones\Ingenieria\Cotiz\CotizFormQueryIngSQL.pyget_tasks_listr sI@ ED D T U.  JJL +u,2+=+=>+=!99+=>7=oo6GH6Gs4G)*6GH  JJL !?I << HLM  JJL   CC/C CE+D:E;E E&E'E6E7EEEE8)Consultas_SQL.conexionrr rrrs2 fr