+
    ia6                         ^ RI Ht R tR# )    )get_connectionTEST101c                    Rp  \        4       pV'       g   \        R4      hVP                  4       pVP                  V 4       VP	                  4       pV Uu. uEF  p/ RV^ ,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bR	V^,          bR
V^,          bRV^,          bRV^	,          bRV^
,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          b/ RV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bRV^,          bR V^,          bR!V^,          bR"V^,          bR#V^ ,          bR$V^!,          bC/ R%V^",          bR&V^#,          bR'V^$,          bR(V^%,          bR)V^&,          bR*V^',          bR+V^(,          bR,V^),          bR-V^*,          bR.V^+,          bR/V^,,          bR0V^-,          bR1V^.,          bR2V^/,          bR3V^0,          bR4V^1,          bR5V^2,          bC/ R6V^3,          bR7V^4,          bR8V^5,          bR9V^6,          bR:V^7,          bR;V^8,          bR<V^9,          bR=V^:,          bR>V^;,          bR?V^<,          bR@V^=,          bRAV^>,          bRBV^?,          bRCV^@,          bRDV^A,          bREV^B,          bRFV^C,          bC/ RGV^D,          bRHV^E,          bRIV^F,          bRJV^G,          bRKV^H,          bRLV^I,          bRMV^J,          bRNV^K,          bROV^L,          bRPV^M,          bRQV^N,          bRRV^O,          bRSV^P,          bRTV^Q,          bRUV^R,          bRVV^S,          bRWV^T,          bC/ RXV^U,          bRYV^V,          bRZV^W,          bR[V^X,          bR\V^Y,          bR]V^Z,          bR^V^[,          bR_V^\,          bR`V^],          bRaV^^,          bRbV^_,          bRcV^`,          bRdV^a,          bReV^b,          bRfV^c,          bRgV^d,          bRhV^e,          bC/ RiV^f,          bRjV^g,          bRkV^h,          bRlV^i,          bRmV^j,          bRnV^k,          bRoV^l,          bRpV^m,          bRqV^n,          bRrV^o,          bRsV^p,          bRtV^q,          bRuV^r,          bRvV^s,          bRwV^t,          bRxV^u,          bRyV^v,          bCRzV^w,          R{V^x,          R|V^y,          R}V^z,          R~V^{,          /CNEK  	  upV'       d   VP                  4        # # u upi   \         d4   p\        RT 24       . u Rp?X'       d   TP                  4        # # Rp?ii ; i  X'       d   TP                  4        i i ; i)z,Obtiene los Breakers desde la base de datos.u0  
     SELECT
        isnull (ScoreV2temp.OrderNum, '')as OrderNum,
        isnull (ScoreV2temp.Departamento, '')as Departamento,
        isnull (ScoreV2temp.Vendedor, '')as Vendedor,
        isnull (ScoreV2temp.Name, '')as Name,
        isnull (ScoreV2temp.TotalLines, '')as TotalLines,
        isnull (ScoreV2temp.OrderLine, '')as OrderLine,
        isnull (ScoreV2temp.PartNum, '')as PartNum,
        isnull (ScoreV2temp.LineDesc, '')as LineDesc,
        isnull (ScoreV2temp.Capacidad, '')as Capacidad,
        isnull (ScoreV2temp.Voltaje, '')as Voltaje,
        isnull (ScoreV2temp.Tipo, '')as Tipo,
        isnull (ScoreV2temp.RevisionNum, '')as RevisionNum,
        isnull (ScoreV2temp.ProdCode, '')as ProdCode,
        isnull (ScoreV2temp.DecriptionProd, '')as DecriptionProd,
        isnull (ScoreV2temp.Caseta, '')as Caseta,
        isnull (ScoreV2temp.Tanque, '')as Tanque,
        isnull (ScoreV2temp.OrderDate, '')as OrderDate,
        isnull (ScoreV2temp.NeedByDate, '')as NeedByDate,
        isnull (ScoreV2temp.LiberacionCXP, '')as LiberacionCXP,
        isnull (ScoreV2temp.[OrderNum&Line], '')as [OrderNum&Line],
        isnull (ScoreV2temp.ProjectID, '')as ProjectID,
        isnull (ScoreV2temp.JobNum2, '')as JobNum2,
        isnull (ScoreV2temp.Revision_OV, '')as Revision_OV,
        isnull (ScoreV2temp.Revision_Project, '')as Revision_Project,
        isnull (ScoreV2temp.Revision_Job, '')as Revision_Job,
        isnull (ScoreV2temp.FechaVentas, '')as FechaVentas,
        isnull (ScoreV2temp.ComentarioSyC, '')as ComentarioSyC,
        isnull (ScoreV2temp.Chk, '')as Chk,
        isnull (ScoreV2temp.FechaSyC, '')as FechaSyC,
        isnull (ScoreV2temp.FechaSimulaciones, '')as FechaSimulaciones,
        isnull (ScoreV2temp.ConsideradaPreasignacion, '')as ConsideradaPreasignacion,
        isnull (ScoreV2temp.ConsideradaMateriales, '')as ConsideradaMateriales,
        isnull (ScoreV2temp.FechaProducción, '')as FechaProducción,
        isnull (ScoreV2temp.ComentarioProducción, '')as ComentarioProducción,
        isnull (ScoreV2temp.AvanceProducción, '')as AvanceProducción,
        isnull (ScoreV2temp.FechaPlaneación, '')as FechaPlaneación,
        isnull (ScoreV2temp.EstadoFecha, '')as EstadoFecha,
        isnull (ScoreV2temp.ComentarioPlaneación, '')as ComentarioPlaneación,
        isnull (ScoreV2temp.FechaMG, '')as FechaMG,
        isnull (ScoreV2temp.FechaMat, '')as FechaMat,
        isnull (ScoreV2temp.AvanceDeSurtimiento, '')as AvanceDeSurtimiento,
        isnull (ScoreV2temp.MaterialSinSurtir, '')as MaterialSinSurtir,
        isnull (ScoreV2temp.AvisoDeTerminacion, '')as AvisoDeTerminacion,
        isnull (ScoreV2temp.TerminadoConFaltante, '')as TerminadoConFaltante,
        isnull (ScoreV2temp.FechaActualización, '')as FechaActualización,
        isnull (ScoreV2temp.MaterialFaltante, '')as MaterialFaltante,
        isnull (ScoreV2temp.ValidaciónFisica, '')as ValidaciónFisica,
        isnull (ScoreV2temp.ResultadoValidación, '')as ResultadoValidación,
        isnull (ScoreV2temp.FechaDeCierre, '')as FechaDeCierre,
        isnull (ScoreV2temp.ComentarioCalidad, '')as ComentarioCalidad,
        isnull (ScoreV2temp.InsumosDemandados, '')as InsumosDemandados,
        isnull (ScoreV2temp.InsumosEmitidos, '')as InsumosEmitidos,
        isnull (ScoreV2temp.AvaceDeEmisiones, '')as AvaceDeEmisiones,
        isnull (ScoreV2temp.FechaDeTermino, '')as FechaDeTermino,
        isnull (ScoreV2temp.AvanceManufacturaSyC, '')as AvanceManufacturaSyC,
        isnull (ScoreV2temp.AvanceEnsambleSyC, '')as AvanceEnsambleSyC,
        isnull (ScoreV2temp.ComentarioSupervisión, '')as ComentarioSupervisión,
        isnull (ScoreV2temp.EnFilaPruebasSyC, '')as EnFilaPruebasSyC,
        isnull (ScoreV2temp.PendientesCalidSyC, '')as PendientesCalidSyC,
        isnull (ScoreV2temp.PartNum_M, '')as PartNum_M,
        isnull (ScoreV2temp.Description_M, '')as Description_M,
        isnull (ScoreV2temp.PartClass_M, '')as PartClass_M,
        isnull (ScoreV2temp.RefCategory_M, '')as RefCategory_M,
        isnull (ScoreV2temp.QtyPer_M, '')as QtyPer_M,
        isnull (ScoreV2temp.IssuedQty_M, '')as IssuedQty_M,
        isnull (ScoreV2temp.Demandado_M, '')as Demandado_M,
        isnull (ScoreV2temp.OnhandQty_M, '')as OnhandQty_M,
        isnull (ScoreV2temp.Preasignado_M, '')as Preasignado_M,
        isnull (ScoreV2temp.NoSerie_M, '')as NoSerie_M,
        isnull (ScoreV2temp.Faltante_M, '')as Faltante_M,
        isnull (ScoreV2temp.En_PO_M, '')as En_PO_M,
        isnull (ScoreV2temp.NoPO_M, '')as NoPO_M,
        isnull (ScoreV2temp.EnRequisicion_M, '')as EnRequisicion_M,
        isnull (ScoreV2temp.NoRequisicion_M, '')as NoRequisicion_M,
        isnull (ScoreV2temp.Alternativa_M, '')as Alternativa_M,
        isnull (ScoreV2temp.En_PO_Altern_M, '')as En_PO_Altern_M,
        isnull (ScoreV2temp.NoPO_Alern_M, '')as NoPO_Alern_M,
        isnull (ScoreV2temp.Req_M, '')as Req_M,
        isnull (ScoreV2temp.Comment_M, '')as Comment_M,
        isnull (ScoreV2temp.FechaReq_M, '')as FechaReq_M,
        isnull (ScoreV2temp.PO_M, '')as PO_M,
        isnull (ScoreV2temp.Cantidad_Pedida_M, '')as Cantidad_Pedida_M,
        isnull (ScoreV2temp.Estatus_M, '')as Estatus_M,
        isnull (ScoreV2temp.Fecha_Llegada_M, '')as Fecha_Llegada_M,
        isnull (ScoreV2temp.PartNum_G, '')as PartNum_G,
        isnull (ScoreV2temp.Description_G, '')as Description_G,
        isnull (ScoreV2temp.PartClass_G, '')as PartClass_G,
        isnull (ScoreV2temp.RefCategory_G, '')as RefCategory_G,
        isnull (ScoreV2temp.QtyPer_G, '')as QtyPer_G,
        isnull (ScoreV2temp.IssuedQty_G, '')as IssuedQty_G,
        isnull (ScoreV2temp.Demandado_G, '')as Demandado_G,
        isnull (ScoreV2temp.OnhandQty_G, '')as OnhandQty_G,
        isnull (ScoreV2temp.Preasignado_G, '')as Preasignado_G,
        isnull (ScoreV2temp.NoSerie_G, '')as NoSerie_G,
        isnull (ScoreV2temp.Faltante_G, '')as Faltante_G,
        isnull (ScoreV2temp.En_PO_G, '')as En_PO_G,
        isnull (ScoreV2temp.NoPO_G, '')as NoPO_G,
        isnull (ScoreV2temp.EnRequisicion_G, '')as EnRequisicion_G,
        isnull (ScoreV2temp.NoRequisicion_G, '')as NoRequisicion_G,
        isnull (ScoreV2temp.Alternativa_G, '')as Alternativa_G,
        isnull (ScoreV2temp.En_PO_Altern_G, '')as En_PO_Altern_G,
        isnull (ScoreV2temp.NoPO_Alern_G, '')as NoPO_Alern_G,
        isnull (ScoreV2temp.Req_G, '')as Req_G,
        isnull (ScoreV2temp.Comment_G, '')as Comment_G,
        isnull (ScoreV2temp.FechaReq_G, '')as FechaReq_G,
        isnull (ScoreV2temp.PO_G, '')as PO_G,
        isnull (ScoreV2temp.Cantidad_Pedida_G, '')as Cantidad_Pedida_G,
        isnull (ScoreV2temp.Estatus_G, '')as Estatus_G,
        isnull (ScoreV2temp.Fecha_Llegada_G, '')as Fecha_Llegada_G,
        isnull (ScoreV2temp.PartNum_T, '')as PartNum_T,
        isnull (ScoreV2temp.Description_T, '')as Description_T,
        isnull (ScoreV2temp.PartClass_T, '')as PartClass_T,
        isnull (ScoreV2temp.RefCategory_T, '')as RefCategory_T,
        isnull (ScoreV2temp.QtyPer_T, '')as QtyPer_T,
        isnull (ScoreV2temp.IssuedQty_T, '')as IssuedQty_T,
        isnull (ScoreV2temp.OnhandQty_T, '')as OnhandQty_T,
        isnull (ScoreV2temp.PartNum_R, '')as PartNum_R,
        isnull (ScoreV2temp.Description_R, '')as Description_R,
        isnull (ScoreV2temp.PartClass_R, '')as PartClass_R,
        isnull (ScoreV2temp.RefCategory_R, '')as RefCategory_R,
        isnull (ScoreV2temp.QtyPer_R, '')as QtyPer_R,
        isnull (ScoreV2temp.IssuedQty_R, '')as IssuedQty_R,
        isnull (ScoreV2temp.OnhandQty_R, '')as OnhandQty_R,
        isnull (ScoreV2temp.ComentarioLINE, '')as ComentarioLINE
		
    FROM
        ScoreV2temp
    u4   No se pudo establecer conexión con la base de datosOrderNumDepartamentoVendedorName
TotalLines	OrderLinePartNumLineDesc	CapacidadVoltajeTipoRevisionNumProdCodeDecriptionProdCasetaTanque	OrderDate
NeedByDateLiberacionCXPOrderNumAndLine	ProjectIDJobNum2Revision_OVRevision_ProjectRevision_JobFechaVentasComentarioSyCChkFechaSyCFechaSimulacionesConsideradaPreasignacionConsideradaMaterialesu   FechaProducciónu   ComentarioProducciónu   AvanceProducciónu   FechaPlaneaciónEstadoFechau   ComentarioPlaneaciónFechaMGFechaMatAvanceDeSurtimientoMaterialSinSurtirAvisoDeTerminacionTerminadoConFaltanteu   FechaActualizaciónMaterialFaltanteu   ValidaciónFisicau   ResultadoValidaciónFechaDeCierreComentarioCalidadInsumosDemandadosInsumosEmitidosAvaceDeEmisionesFechaDeTerminoAvanceManufacturaSyCAvanceEnsambleSyCu   ComentarioSupervisiónEnFilaPruebasSyCPendientesCalidSyC	PartNum_MDescription_MPartClass_MRefCategory_MQtyPer_MIssuedQty_MDemandado_MOnhandQty_MPreasignado_M	NoSerie_M
Faltante_MEn_PO_MNoPO_MEnRequisicion_MNoRequisicion_MAlternativa_MEn_PO_Altern_MNoPO_Alern_MReq_M	Comment_M
FechaReq_MPO_MCantidad_Pedida_M	Estatus_MFecha_Llegada_M	PartNum_GDescription_GPartClass_GRefCategory_GQtyPer_GIssuedQty_GDemandado_GOnhandQty_GPreasignado_G	NoSerie_G
Faltante_GEn_PO_GNoPO_GEnRequisicion_GNoRequisicion_GAlternativa_GEn_PO_Altern_GNoPO_Alern_GReq_G	Comment_G
FechaReq_GPO_GCantidad_Pedida_G	Estatus_GFecha_Llegada_G	PartNum_TDescription_TPartClass_TRefCategory_TQtyPer_TIssuedQty_TOnhandQty_T	PartNum_RDescription_RPartClass_RRefCategory_RQtyPer_RIssuedQty_ROnhandQty_RComentarioLINEz.[Error inesperado] Error obteniendo breakers: N)r   ConnectionErrorcursorexecutefetchallclose	Exceptionprint)queryconnry   resultsrowes         nC:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\SupYCtrol\GerenteSyC\GSYCScoreSQL.pyget_Consultar      s	   AEDN$&!"XYYu//#B !"~ !#}~CF~A~ CF~ A	~
 c!f~ SV~ 3q6~ CF~ SV~ 3q6~ B~ s2w~ CG~ !#b'~ #b'~  #b'!~" SW#~$ c"g%~&  R'~( "3r7)~* SW+~, 3r7-~. s2w/~0 #CG1~2 B3~4 s2w5~6  R7~8 s2w9~: CG;~< $SW=~> +CG?~@ (RA~B #CGC~D (RE~F $SWG~H #CGI~J s2wK~L (RM~N 3r7O~P CGQ~R &s2wS~T $SWU~V %c"gW~X 'BY~Z &s2w[~\ #CG]~^ $SW_~` 'Ba~b  Rc~d $SWe~f $SWg~h "3r7i~j #CGk~l !#b'm~n 'Bo~p $SWq~r )#b's~t #CGu~v %c"gw~x SWy~z  R{~| s2w}~~  R~@ CGA~B s2wC~D s2wE~F s2wG~H  RI~J SWK~L c"gM~N 3r7O~P #b'Q~R "3r7S~T "3r7U~V  RW~X !#b'Y~Z B[~\ R]~^ SW_~` c"ga~b Bc~d $SWe~f SWg~h "3r7i~j SWk~l  Rm~n s2wo~p  Rq~r CGs~t s2wu~v s2ww~x s2wy~z  R{~| SW}~~ c"g~@ 3r7A~B #b'C~D "3r7E~F "3r7G~H  RI~J !#c(K~L CM~N SO~P SXQ~R c#hS~T CU~V $SXW~X SXY~Z "3s8[~\ SX]~^  S_~` s3xa~b  Sc~d CHe~f s3xg~h s3xi~j SXk~l  Sm~n s3xo~p  SCHs3xs3x #c(y~| !"H JJL I"@  >qcBC	JJL 	 JJL sC   AU% S.U U%  U% %V#0V?V# V& V##V& &WN)Consultas_SQL.conexionr   r        r   <module>r      s   
 9Rr   