a 0i(@s0ddlmZmZddlmZddlZddZdS))jsonifyrequest)get_connectionERPNcCs|jddgddd}dS)Nz /api/get_bomGET)methodsc s^tjd}|s tddidfStd|tdurTtdtddidfSz}|d |f|}|std |tdd id fW td S|\}}}}}}|r|nt j } d|d|||rt |nd|rt |ndt |ddddddgd} dfdd |d| | d<t| gW td S td 0dS)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ízZNodoJobNumZSeqPartNumZ DescripcionZ QtyRequeridaZ QtyEmitidaZ CompletadoTLAMaterialCost TLALaborCost TLABurdenCostTLASubcontractCost TLAMtlBurCostTipochildren?c)sHg}}|d|f|}t|ddD]\}} | \ } } } } }}}}}|d|}|d| durpt| nd| | | rt| nd||rt|nd|t|ddddddgd}|dkr }|d ||| f|}|r|d }d |d <}|d |f|}|r,|d r,|dntj }||d<}|d|f|}|r|\}}}} }!| t||t||t||t| |t|!|d||||||d<q8}"|"d| ||f|"}#|#r|#d }d|d <}|d|f|}$|$r.|$\}%}&}'nd }%|%rJt| t|%}(nd}(}|d|f|}|r|\}}}} }!| t|||(t|||(t|||(t| ||(t|!||(d|&r|'r|'ntj }||d<|||||(|(|d<nd|d <d|d<nd|d <d|d<g|d<| |q.|S)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 r r MzySELECT 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'r zSELECT 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 trazableZMaterial) cursorexecutefetchall enumerateintfloatboolfetchonedatetimenowupdateappend))rprefixZ referenciaZ cost_factorZ qty_factorZ componentesrZmtl_rowsidxZmtlZmtl_seqZmtl_partZmtl_descZreq_qtyZ issued_qtyZissued_completeZrev_numZasm_seqZ type_codeZnode_idZ nodo_compZ cursor_prodprodZ child_jobZ cursor_jhZ child_infoZ child_refZ cursor_costZc_rowZc_matZc_labZc_burZc_subZc_mtlburZ cursor_ptptZ child_headZ child_prodqtyZchild_completeZ child_closeZproration_factor connectionobtener_componentesV/var/www/html/src/App/SupyCtrol_Module/GerenteSyC/UtilityMaterials/GSYCGetBomGenset.pyr-7s "        zNfunciones_GetBomGenset..obtener_arbol_bom..obtener_componentesr)rr)rargsgetrprintrrrr"closer#r$r r!) Z jobNum_inputrrowZpart_numZ part_descZprod_qtyZ qty_completedZ job_completeZ close_dateref_dateZ root_noder.r+r/obtener_arbol_bom sh  z1funciones_GetBomGenset..obtener_arbol_bom)route)appr6r.r.r/funciones_GetBomGenset sr9)flaskrrConsultas_SQL.conexionrr#r9r.r.r.r/s