+ i(0^RIHtHt^RIHt^RItRtR#))jsonifyrequest)get_connectionERPNc:VPRR.R7R4pR#)z /api/get_bomGET)methodscza a \PPR4pV'g\RR/4R3#\ RV 24\ 4o S f\ R4\RR/4R3#S P 4pVPRV34VP4pV'g9\ R V 24\RR /4R 3S P4\ R 4#Vwr4rVrxV'dTM\PP4p R RRTRRRTRTRV'd \V4MRRV'd \V4MRR\V4RRRRRRRRRRRRR./p R!V V 3R llo S !VRV 4V R&\V .4S P4\ R 4# S P4\ R 4i;i)"job_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 cerradaNodo1JobNumSeqPartNum Descripcion QtyRequerida QtyEmitida CompletadoTLAMaterialCost TLALaborCost TLABurdenCostTLASubcontractCost TLAMtlBurCostTipouEnsamblaje raízchildrenc<.pS)P4pVPRV34VP4p\V^R7EFwrV w rrrpppV RV 2pRTRRRV e \ V 4MRRT RT R V 'd \ V 4MR V,R V'd \ V4MR V,R \ V4R R RR RR RR RR RRR./pVR8XEd_S)P4pVPRVVV 34VP4pV'EdCV^,pRVR&S)P4pVPRV34VP4pV'dV^,'d V^,M\PP4pVVR&S)P4pVPRV34VP4pV'dtVwpppp p!VPR \ V4V,R\ V4V,R\ V4V,R\ V 4V,R\ V!4V,/4S*!VVVW44VR&EMS)P4p"V"PRV VV34V"P4p#V#'EdV#^,pRVR&S)P4pVPRV34VP4p$V$'dV$wp%p&p'M^p%V%'d\ V 4\ V%4, p(MR p(S)P4pVPRV34VP4pV'dVwpppp p!VPR \ V4V,V(,R\ V4V,V(,R\ V4V,V(,R\ V 4V,V(,R\ V!4V,V(,/4X&'d X''dT'M\PP4pVVR&S*!VVVVV(,V(4VR&MRVR&RVR&MRVR&RVR&.VR&VPV4EK V#)aSELECT 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 rrrrrrrrrrrrrrrrMzySELECT JobNum FROM Erp.JobProd WHERE Company = 'IGSA' AND TargetJobNum = ? AND TargetAssemblySeq = ? AND TargetMtlSeq = ?zManufacturado cruzadozUSELECT JobComplete, ClosedDate FROM Erp.JobHead WHERE JobNum = ? AND Company = 'IGSA'zSELECT TLAMaterialCost, TLALaborCost, TLABurdenCost, TLASubcontractCost, TLAMtlBurCost FROM Erp.JobAsmbl WHERE JobNum = ? AND AssemblySeq = 0 AND Company = 'IGSA'zSELECT 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.pyrWNfunciones_GetBomGenset..obtener_arbol_bom..obtener_componentes7s #**,B J "??, )(! < ;45M#07#(KP$HE5%$-$4$4(95<+;UXh;h(6e {8RUe8e(7u 9SVf9f(X[k>k(7x;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,r8y8hmeM2d<0!3$c*BI$@ #@ #D%8 c8$TIj !I;'     8 9     8 9s&0:F+F#AF$F9AFF:N)route)apprjs& rXfunciones_GetBomGensetrn s%YY~wY/s:0s:rZ)flaskrrConsultas_SQL.conexionrr+rnrZrXrrs #4u:rZ