i(.SSKJrJr SSKJr SSKrSrg))jsonifyrequest)get_connectionERPNc2URSS/S9S5ng)Nz /api/get_bomGET)methodscR^ ^ [RRS5nU(d[SS05S4$[ SU35 [ 5m T c[ S5 [SS05S4$T R 5nURS U45 UR5nU(d8[ S U35 [SS 05S 4T R5 [ S 5 $Uup4pVpxU(aUO[RR5n SUSUUU(a [U5OSU(a [U5OS[U5SSSSSS/S.n SU U 4Sjjm T "USU 5U S'[U /5T R5 [ S 5 $!T R5 [ S 5 f=f)Njob_numerrorzDebe proporcionar un JobNumiu"Obteniendo árbol BOM para JobNum uBError: no se pudo establecer la conexión con la base de datos ERPu!Conexión a base de datos fallidaizSELECT PartNum, PartDescription, ProdQty, QtyCompleted, JobComplete, ClosedDate FROM Erp.JobHead WHERE JobNum = ? AND Company = 'IGSA'u'No se encontró el JobHead para JobNum z?Trabajo no creado, favor de revisarlo en Seguimiento de trabajoiu$Conexión a la base de datos cerrada1uEnsamblaje raízNodoJobNumSeqPartNum Descripcion QtyRequerida QtyEmitida CompletadoTLAMaterialCost TLALaborCost TLABurdenCostTLASubcontractCost TLAMtlBurCostTipochildrenc>/nT)R5nURSU45 UR5n[USS9GHupU u pppnnnUSU3nUSU b [ U 5OSU U U (a [ U 5OSU-U(a [ U5OSU-[ U5SSSSSS/S.nUS:XGaT)R5nURS UUU 45 UR5nU(GaUS nS US 'T)R5nURS U45 UR5nU(aUS (aUSO[RR5nUUS'T)R5nURSU45 UR5nU(a[Uunnnn n!UR[ U5U-[ U5U-[ U5U-[ U 5U-[ U!5U-S.5 T*"UUUX45US'GOT)R5n"U"RSU UU45 U"R5n#U#(GaXU#S nSUS 'T)R5nURSU45 UR5n$U$(aU$un%n&n'OS n%U%(a[ U 5[ U%5- n(OSn(T)R5nURSU45 UR5nU(ajUunnnn n!UR[ U5U-U(-[ U5U-U(-[ U5U-U(-[ U 5U-U(-[ U!5U-U(-S.5 W&(a W'(aU'O[RR5nUUS'T*"UUUUU(-U(5US'OSUS 'SUS'OSUS 'SUS'/US'URU5 GM U$)NaSELECT jm.MtlSeq, jm.PartNum, jm.Description, jm.RequiredQty, jm.IssuedQty, jm.IssuedComplete, jm.RevisionNum, jm.AssemblySeq, p.TypeCode FROM Erp.JobMtl jm INNER JOIN Erp.Part p ON p.PartNum = jm.PartNum AND p.Company = jm.Company WHERE jm.JobNum = ? AND jm.Company = 'IGSA')start.r rrMzySELECT JobNum FROM Erp.JobProd WHERE Company = 'IGSA' AND TargetJobNum = ? AND TargetAssemblySeq = ? AND TargetMtlSeq = ?rzManufacturado cruzadorzUSELECT JobComplete, ClosedDate FROM Erp.JobHead WHERE JobNum = ? AND Company = 'IGSA'rzSELECT TLAMaterialCost, TLALaborCost, TLABurdenCost, TLASubcontractCost, TLAMtlBurCost FROM Erp.JobAsmbl WHERE JobNum = ? AND AssemblySeq = 0 AND Company = 'IGSA')rrrrrrzSELECT TOP 1 JobNum, TranDate FROM Erp.PartTran WHERE Company = 'IGSA' AND PartNum = ? AND RevisionNum = ? AND TranType = 'MFG-STK' AND TranDate <= ? ORDER BY TranDate DESCzManufacturado (sin cruce)z^SELECT ProdQty, JobComplete, ClosedDate FROM Erp.JobHead WHERE JobNum = ? AND Company = 'IGSA'z No trazableMaterial) cursorexecutefetchall enumerateintfloatboolfetchonedatetimenowupdateappend)+r prefix referencia cost_factor qty_factor componentesr%mtl_rowsidxmtlmtl_seqmtl_partmtl_descreq_qty issued_qtyissued_completerev_numasm_seq type_codenode_id nodo_comp cursor_prodprod child_job cursor_jh child_info child_ref cursor_costc_rowc_matc_labc_burc_subc_mtlbur cursor_ptpt child_head child_prodqtychild_complete child_closeproration_factor connectionobtener_componentess+ ڀC:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\App\SupyCtrol_Module\GerenteSyC\UtilityMaterials\GSYCGetBomGenset.pyrYNfunciones_GetBomGenset..obtener_arbol_bom..obtener_componentes7s^ #**,B J "??, )(! ;45M#07#(KP$HE5%$-$4$4;@<+;UXh;h8=e {8RUe8e9>u 9SVf9f>CEl[>X[k>k9>x;9VYi9i 6&%'.obtener_arbol_bom s||'' 2 G%BCDcI I 2<.AB&(   V WG%HIJCO Oh :&&(F NNI  //#C? ~NO)jklnqqz     8 9yVY RH,%1zx7H7H7L7L7NH&#(3;h6CeM2"<0#& #!$&)!$*I$@ #@ #D%8 c8$TIj !I;'     8 9     8 9s.AF B F F&)route)apprls rZfunciones_GetBomGensetrp s%YY~wY/s:0s:r\)flaskrrConsultas_SQL.conexionrr-rpr\rZrts #4u:r\