已重命名1个文件
已添加7个文件
已修改19个文件
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetDefaultProductParent () as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Aug-14-2024 (created) |
| | | return '产æå'; |
| | | *] |
| | | } |
| | |
| | | [* |
| | | // çå
°é¸½ Aug-12-2024 (created) |
| | | owner.CCEngineLogisticsCostReport( relflush ); |
| | | produtparent := CCEngineLogisticsCostReport::GetDefaultProductParent(); |
| | | name := CCEngineLogisticsCostReport::GetDefaultName(); |
| | | allunit := CCEngineLogisticsCostReport::GetDefaultAllUnit(); |
| | | ccunit := CCEngineLogisticsCostReport::GetDefaultCCUnit(); |
| | |
| | | traverse( report, FinancialProductionRow, row, row.Unit() = ccunit and exists( row, FinancialProductionCell, cell, cell.Value() <> '0' ) ){//è´¢å¡äº§éæ¥è¡¨éçé¿æ¥äº§é, ä¸ä¸º0 |
| | | ccrow := table.GetRow( row.Name() ); |
| | | product := row.Product_MP(); |
| | | products.Add( product ); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | //æ¥è¯¢å¯¹åºçå卿ºææ¬ |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | | and engine.MLB_MQB() = product.MQBMLB() |
| | | and engine.Factory() = ccunit |
| | | and exists( productparents, Elements, e, e.ID() = engine.Product() ) ); |
| | | if( not isnull( enginecost ) ){ |
| | | product := row.Product_MP(); |
| | | products.Add( product ); |
| | | traverse( row, FinancialProductionCell, cell, cell.Value() <> '0' ){ |
| | | //å
¥åºé/å
è£
容é*å
¥åºåä»·ï¼å
¥åºéçäºé¿æ¥äº§é |
| | | quantity := ceil( [Number]cell.Value() / enginecost.PackagingCapacity() ) * enginecost.WarehousingPrice(); |
| | |
| | | ccrow := table.GetRow( row.Name() ); |
| | | product := row.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | //æ¥è¯¢å¯¹åºçå卿ºææ¬ |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | | and engine.MLB_MQB() = product.MQBMLB() |
| | |
| | | row := table.GetRow( pit.ProductID() ); |
| | | product := pit.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){////æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){////æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | //å¨å卿ºææ¬åæ°è¡¨æ¾å°å¯¹åºçå
è£
容é |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | | and engine.MLB_MQB() = product.MQBMLB() |
| | |
| | | product := pisp.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | row := table.GetRow( pisp.ProductID() ); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){////æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){////æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | //æ¥è¯¢å¯¹åºçå卿ºææ¬ |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | | and engine.MLB_MQB() = product.MQBMLB() |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetDefaultProductParent () as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Aug-14-2024 (created) |
| | | return '产æå'; |
| | | *] |
| | | } |
| | |
| | | [* |
| | | // çå
°é¸½ Aug-12-2024 (created) |
| | | owner.DLEngineLogisticsCostReport( relflush ); |
| | | produtparent := DLEngineLogisticsCostReport::GetDefaultProductParent(); |
| | | name := DLEngineLogisticsCostReport::GetDefaultName(); |
| | | allunit := DLEngineLogisticsCostReport::GetDefaultAllUnit(); |
| | | ccunit := DLEngineLogisticsCostReport::GetDefaultCCUnit(); |
| | |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
| | | |
| | | column := selectobject( table, Column, column, column.Name() = periodname and column.StartDate() = periodtime ); |
| | | traverse( trip, ProductInTrip, pit, pit.Quantity() = 0 and exists( pit.Product_MP().GetAllParent(), Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | traverse( trip, ProductInTrip, pit, pit.Quantity() = 0 and exists( pit.Product_MP().GetAllParent(), Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | quantity := [Number]pit.Quantity(); |
| | | row := table.GetRow( pit.ProductID() ); |
| | | product := pit.Product_MP(); |
| | |
| | | product := row.Product_MP(); |
| | | products.Add( product ); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | //æ¥è¯¢å¯¹åºçå卿ºææ¬ |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | | and engine.MLB_MQB() = product.MQBMLB() |
| | |
| | | ccrow := table.GetRow( row.Name() ); |
| | | product := row.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | products.Add( product ); |
| | | //æ¥è¯¢å¯¹åºçå卿ºææ¬ |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | |
| | | traverse( owner, TransferPlanRow, tprow, tprow.SourceStockpoingPointID() = 'DL' and tprow.TargetStockpoingPointID() = 'CC' ){ |
| | | product := selectobject( owner, Product_MP, product, product.ID() = tprow.ProductID() ); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | //æ¥è¯¢å¯¹åºçå卿ºææ¬ |
| | | enginecost := selectobject( owner, LogisticsCostEngine, engine, engine.Generation() = product.Generation() |
| | | and engine.MLB_MQB() = product.MQBMLB() |
| | |
| | | if( iscc ){ |
| | | product := forecast.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | row := table.GetRow( forecast.ProductID() ); |
| | | products.Add( forecast.Product_MP() ); |
| | | |
| | |
| | | //è·åè¡ |
| | | product := pisp.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | row := table.GetRow( pisp.ProductID() ); |
| | | products.Add( pisp.Product_MP() ); |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear ){ |
| | |
| | | for( rownr := rownr; rownr < modelsnr; rownr ++ ){ |
| | | |
| | | EnginePipelineRow::CraeteCellValueForRow( this, productcolumn, attricolumn, row.Name(), '', rownr, false ); |
| | | rownr := rownr + 1; |
| | | } |
| | | showrowinventory := EnginePipelineRow::CraeteCellValueForRow( this, productcolumn, attricolumn, row.Name(), 'åºå', rownr, false ); |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetDefaultProductParent () as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Aug-14-2024 (created) |
| | | return '产æå'; |
| | | *] |
| | | } |
| | |
| | | owner.EnginePipelineSource( relflush ); |
| | | //ccunit := EnginePipelineReport::GetDefaultCCUnit(); |
| | | //dlunit := EnginePipelineReport::GetDefaultDLUnit(); |
| | | ccalineunit := FinancialProductionReport::GetDefaultCCALineUnit(); |
| | | dlalienunit := FinancialProductionReport::GetDefaultDLALineUnit() |
| | | ccmplineunit := FinancialProductionReport::GetDefaultCCMPLineUnit() |
| | | dlmplineunit := FinancialProductionReport::GetDefaultDLMPLineUnit(); |
| | | productparent := EnginePipelineReport::GetDefaultProductParent(); |
| | | ccalineunit := EnginePipelineReport::GetDefaultCCALineUnit(); |
| | | dlalienunit := EnginePipelineReport::GetDefaultDLALineUnit() |
| | | ccmplineunit := EnginePipelineReport::GetDefaultCCMPLineUnit() |
| | | dlmplineunit := EnginePipelineReport::GetDefaultDLMPLineUnit(); |
| | | //allunit := EnginePipelineReport::GetDefaultAllUnit(); |
| | | source := owner.EnginePipelineSource( relnew, Name := EnginePipelineReport::GetDefaultName() ); |
| | | table := source.Report( relnew, ID := source.Name(), Name := source.Name() ); |
| | |
| | | //æ¯å¦å±äºå¤§è¿å·¥å |
| | | isdl := unit.ID() = dlalienunit or unit.ID() = dlmplineunit or exists( parentunits, Elements, punit, punit.ID() = dlalienunit or punit.ID() = dlmplineunit ); |
| | | |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() and not pisp.IsSystem() ){ |
| | | product := pisp.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() and not pisp.IsSystem() |
| | | and exists( pisp.Product_MP().GetAllParent(), Elements, e, e.ID() = productparent ) |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Day() and ( pispip.NewSupplyQuantity() <> 0 or pispip.PlannedInventoryLevelEnd() <> 0 ) ) ){ |
| | | weekstart := owner.StartOfPlanning().Date(); |
| | | pispips := selectsortedset( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() |
| | | and pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Day(), pispip.Start() ); |
| | |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | //çæéæ±æ°æ® |
| | | traverse( owner, SalesDemand.astype( Forecast ), forecast ){ |
| | | product := forecast.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = 'å卿º' ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | traverse( owner, SalesDemand.astype( Forecast ), forecast, forecast.StartDate() < endperiod.StartDate() and forecast.Quantity() <> 0 |
| | | and exists( forecast.Product_MP().GetAllParent(), Elements, e, e.ID() = productparent ) |
| | | and exists( forecast, PlanningSalesDemandInPeriod, psdip, psdip.Quantity() <> 0 ) ){ |
| | | row := table.GetRow( forecast.ProductID() ); |
| | | weekstart := owner.StartOfPlanning().Date(); |
| | | traverse( forecast, PlanningSalesDemandInPeriod, psdip ){ |
| | | traverse( forecast, PlanningSalesDemandInPeriod, psdip, psdip.Quantity() <> 0 ){ |
| | | //天 |
| | | daycolumn := table.GetColumnByUnit( Translations::MP_GlobalParameters_Day(), psdip.StartDate() ); |
| | | //å¨ |
| | |
| | | } |
| | | if( psdip.StartDate() = ( weekstart + Duration::Days( 6 ) ).Date() or psdip.PeriodStart() = endperiod.StartDate() ){ |
| | | weekstart := ( weekstart + Duration::Days( 7 ) ).Date(); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | //æ¯å¦å±äºå¤§è¿å·¥å |
| | | isdl := unit.ID() = dlalienunit or unit.ID() = dlmplineunit or exists( parentunits, Elements, punit, punit.ID() = dlalienunit or punit.ID() = dlmplineunit ); |
| | | if( iscc or isdl ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear and pispip.NewSupplyQuantity() <> 0 ) ){ |
| | | //è·åå·¥åè¡ |
| | | factoryrow := table.GetRowByUnit( pisp.Product_MP(), ifexpr( iscc, ccunit, dlunit ) ); |
| | | //è·ååè®¡è¡ |
| | | allrow := table.GetRowByUnit( pisp.Product_MP(), allunit ); |
| | | products.Add( pisp.Product_MP() ); |
| | | //å½product planningçæ¥æåºé´å¨éè¦çæ¥æåºé´å
|
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear |
| | | // and ( ( pispip.Period_MP().StartDate().StartOfMonth() = startofplanning.StartOfMonth() and currentperiods.Find( pispip.Period_MP() ) >= 0 ) |
| | | // or ( pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Month() and pispip.Period_MP().StartDate() < startofnextyear ) ) |
| | | ){ |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear and pispip.NewSupplyQuantity() <> 0 ){ |
| | | periodtime := pispip.Start().StartOfMonth().Date(); |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
| | | quantity := [Number]pispip.NewSupplyQuantity();//åèäºå
¥ |
| | |
| | | table.GenerateColumn( owner ); |
| | | |
| | | //é¦å
å¨forecastç颿¥æ¾sales segmentä¸ºé¿æ¥çææéæ±ï¼è¯å«åºMLBçææäº§åï¼æ¯ä¸ªäº§åæææ±æ»éæ±æ°é |
| | | traverse( owner, SalesDemand.astype( Forecast ), forecast, forecast.StartDate() < startofnextyear ){ |
| | | traverse( owner, SalesDemand.astype( Forecast ), forecast, forecast.StartDate() < startofnextyear and forecast.Quantity() <> 0 |
| | | and exists( forecast, PlanningSalesDemandInPeriod, psdip, psdip.Quantity() <> 0 ) ){ |
| | | salessegment := forecast.SalesSegment_MP(); |
| | | parentsalessegments := salessegment.GetAllParent(); |
| | | //æ¯å¦å±äºé¿æ¥ |
| | |
| | | //è·åå·¥åè¡ |
| | | factoryrow := table.GetRow( ifexpr( iscc and forecast.Product_MP().MQBMLB() = 'MLB', ccunit, dlunit ), product ); |
| | | |
| | | if( products.Find( product ) < 0 ){ |
| | | products.Add( product ); |
| | | } |
| | | traverse( forecast, PlanningSalesDemandInPeriod, psdip ){ |
| | | traverse( forecast, PlanningSalesDemandInPeriod, psdip, psdip.Quantity() <> 0 ){ |
| | | periodtime := psdip.StartDate().StartOfMonth(); |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
| | | // info( '-------------------------', periodname, periodtime ); |
| | |
| | | //æ¯å¦å±äºé¿æ¥è£
é
线 |
| | | // iscc := unit.ID() = ccspline or exists( parentunits, Elements, punit, punit.ID() = ccspline ); |
| | | if( table.IsInUnit( stockingpoint, ccspline ) ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() and pisp.Product_MP().MQBMLB() = 'MQB' ){//产å为MQB |
| | | allrow := table.GetRow( allunit, pisp.Product_MP() ); |
| | | ccrow := table.GetRow( ccunit, pisp.Product_MP() ); |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() and pisp.Product_MP().MQBMLB() = 'MQB' |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear and pispip.DependentDemandAndSalesDemandQuantity() <> 0 ) ){//产å为MQB |
| | | product := pisp.Product_MP(); |
| | | allrow := table.GetRow( allunit, product ); |
| | | ccrow := table.GetRow( ccunit, product ); |
| | | products.Add( product ); |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear and pispip.DependentDemandAndSalesDemandQuantity() <> 0 ){ |
| | | periodtime := pispip.Start().StartOfMonth().Date(); |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
| | | column := selectobject( table, FinancialSalesColumn, column, column.Name() = periodname and column.Period() = periodtime ); |
| | |
| | | destisp := selectobject( owner, StockingPoint_MP, sp, sp.ID() = laneleg.DestinationStockingPointID() ); |
| | | isccrent := table.IsInUnit( destisp, ccrent ); |
| | | if( isdlspline and isccrent ){ |
| | | traverse( laneleg, Trip, trip, trip.Arrival() < startofnextyearlead ){ |
| | | traverse( laneleg, Trip, trip, trip.Arrival() < startofnextyearlead and exists( trip, ProductInTrip, pit, pit.Quantity() <> 0 ) ){ |
| | | // periodtime := ( trip.Arrival() - FinancialSalesReport::GetDefaultTripLeadingTime() ).StartOfMonth().Date(); |
| | | periodtime := trip.Departure().StartOfMonth().Date(); |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
| | | |
| | | column := selectobject( table, FinancialSalesColumn, column, column.Name() = periodname and column.Period() = periodtime ); |
| | | if( not isnull( column ) ){ |
| | | traverse( trip, ProductInTrip, pit ){ |
| | | traverse( trip, ProductInTrip, pit, pit.Quantity() <> 0 ){ |
| | | product := pit.Product_MP(); |
| | | products.Add( product ); |
| | | quantity := [Number]pit.Quantity();//åèäºå
¥ |
| | | dlrow := table.GetRow( dlunit, pit.Product_MP() ); |
| | | dlrow.Initialize( column, quantity );//æ±æ»æ°é |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetDefaultProductParent () as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Aug-14-2024 (created) |
| | | return 'æºå ä»¶'; |
| | | *] |
| | | } |
| | |
| | | [* |
| | | // çå
°é¸½ Jun-24-2024 (created) |
| | | owner.FinancialProductionSource( relflush ); |
| | | productparent := MachiningPipelineReport::GetDefaultProductParent(); |
| | | ccunit := MachiningPipelineReport::GetDefaultCCUnit(); |
| | | dlunit := MachiningPipelineReport::GetDefaultDLUnit(); |
| | | //allunit := EnginePipelineReport::GetDefaultAllUnit(); |
| | |
| | | //æ¯å¦å±äºå¤§è¿æºå 产线 |
| | | isdlproduction := unit.ID() = MachiningPipelineReport::GetDefaultDLProductionUnit() or exists( parentunits, Elements, punit, punit.ID() = MachiningPipelineReport::GetDefaultDLProductionUnit() ); |
| | | if( iscc or isdl ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() and not pisp.IsSystem() ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() and not pisp.IsSystem() |
| | | and exists( pisp.Product_MP().GetAllParent(), Elements, e, e.ID() = productparent ) |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Day() and ( pispip.NewSupplyQuantity() <> 0 or pispip.PlannedInventoryLevelEnd() <> 0 ) ) ){ |
| | | product := pisp.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = productparent ) ){//æ¥è¯¢äº§åç±»åæ¯å卿º |
| | | row := table.GetRow( pisp.ProductID() ); |
| | | |
| | | products.Add( pisp.Product_MP() ); |
| | | weekstart := owner.StartOfPlanning().Date(); |
| | | pispips := selectsortedset( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() |
| | | and pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Day(), pispip.Start() ); |
| | | and pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Day() and ( pispip.NewSupplyQuantity() <> 0 or pispip.PlannedInventoryLevelEnd() <> 0 ), pispip.Start() ); |
| | | |
| | | traverse( pispips, Elements, pispip ){ |
| | | //天 |
| | |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | //çæè°æ¨æ°æ® |
| | | traverse( owner, TransferPlanRow, tprow, ( tprow.SourceStockpoingPointID() = 'CC' and tprow.TargetStockpoingPointID() = 'DL' ) or ( tprow.SourceStockpoingPointID() = 'DL' and tprow.TargetStockpoingPointID() = 'CC' ) ){ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeRepresentation CCEngineLogisticsCostCell |
| | | { |
| | | AttributeRepresentation Coefficient |
| | | { |
| | | AttributeKey: '[415136.0.986844757]' |
| | | Synonym: 'ç³»æ°' |
| | | } |
| | | AttributeRepresentation EstimatedTotalCost |
| | | { |
| | | AttributeKey: '[415136.0.986844738]' |
| | | Synonym: 'é¢è®¡æ»è´¹ç¨' |
| | | } |
| | | AttributeRepresentation FactoryToRentTransCost |
| | | { |
| | | AttributeKey: '[415136.0.986844780]' |
| | | Synonym: 'åå
å°å¤ç§åºè¿è¾è´¹ç¨' |
| | | } |
| | | AttributeRepresentation RentEnterCost |
| | | { |
| | | AttributeKey: '[415136.0.986881422]' |
| | | Synonym: 'å¤ç§åºå
¥åºè´¹ç¨' |
| | | } |
| | | AttributeRepresentation RentOutCost |
| | | { |
| | | AttributeKey: '[415136.0.986881432]' |
| | | Synonym: 'å¤ç§åºåºåºè´¹ç¨' |
| | | } |
| | | AttributeRepresentation RentStorageCost |
| | | { |
| | | AttributeKey: '[415136.0.986881445]' |
| | | Synonym: 'å¤ç§åºä»å¨è´¹ç¨' |
| | | } |
| | | AttributeRepresentation TotalCost |
| | | { |
| | | AttributeKey: '[415136.0.986844770]' |
| | | Synonym: 'æ»è´¹ç¨' |
| | | } |
| | | RelationRepresentation Column { RelationKey: '[415136.0.986881392]' Visibility: 'Normal' } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeRepresentation DLEngineLogisticsCostCell |
| | | { |
| | | AttributeRepresentation CCLongTransCoat |
| | | { |
| | | AttributeKey: '[415136.0.992900331]' |
| | | Synonym: 'é¿æ¥é¿éè¿è¾è´¹ç¨' |
| | | } |
| | | AttributeRepresentation CCRentEnterCost |
| | | { |
| | | AttributeKey: '[415136.0.992900044]' |
| | | Synonym: 'é¿æ¥å¤ç§åºå
¥åºè´¹ç¨' |
| | | } |
| | | AttributeRepresentation CCRentOutCost |
| | | { |
| | | AttributeKey: '[415136.0.992900047]' |
| | | Synonym: 'é¿æ¥å¤ç§åºåºåºè´¹ç¨' |
| | | } |
| | | AttributeRepresentation CCRentStorageCost |
| | | { |
| | | AttributeKey: '[415136.0.992900050]' |
| | | Synonym: 'é¿æ¥å¤ç§åºä»å¨è´¹ç¨' |
| | | } |
| | | AttributeRepresentation CCShortTransCost |
| | | { |
| | | AttributeKey: '[415136.0.992900341]' |
| | | Synonym: 'é¿æ¥çéè¿è¾è´¹ç¨' |
| | | } |
| | | AttributeRepresentation Coefficient |
| | | { |
| | | AttributeKey: '[415136.0.992900035]' |
| | | Synonym: 'ç³»æ°' |
| | | } |
| | | AttributeRepresentation DLRentEnterCost |
| | | { |
| | | AttributeKey: '[415136.0.992900241]' |
| | | Synonym: '大è¿å¤ç§åºå
¥åºè´¹ç¨' |
| | | } |
| | | AttributeRepresentation DLRentOutCost |
| | | { |
| | | AttributeKey: '[415136.0.992900248]' |
| | | Synonym: '大è¿å¤ç§åºåºåºè´¹ç¨' |
| | | } |
| | | AttributeRepresentation DLRentStorageCost |
| | | { |
| | | AttributeKey: '[415136.0.992900261]' |
| | | Synonym: '大è¿å¤ç§åºä»å¨è´¹ç¨' |
| | | } |
| | | AttributeRepresentation EstimatedTotalCost |
| | | { |
| | | AttributeKey: '[415136.0.992900038]' |
| | | Synonym: 'é¢è®¡æ»è´¹ç¨' |
| | | } |
| | | AttributeRepresentation FactoryToDLRentTransCost |
| | | { |
| | | AttributeKey: '[415136.0.992900041]' |
| | | Synonym: 'åå
å°å¤§è¿å¤ç§åºè¿è¾è´¹ç¨' |
| | | } |
| | | AttributeRepresentation TotalCost |
| | | { |
| | | AttributeKey: '[415136.0.992900053]' |
| | | Synonym: 'æ»è´¹ç¨' |
| | | } |
| | | RelationRepresentation Column { RelationKey: '[415136.0.992900194]' Visibility: 'Normal' } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeRepresentation InventorySummaryCell |
| | | { |
| | | AttributeRepresentation AverageInventory |
| | | { |
| | | AttributeKey: '[415136.0.865305023]' |
| | | Synonym: 'å¹³ååºå' |
| | | } |
| | | AttributeRepresentation EndingInventory |
| | | { |
| | | AttributeKey: '[415136.0.865304923]' |
| | | Synonym: 'ææ«åºå' |
| | | } |
| | | AttributeRepresentation MaximumInventory |
| | | { |
| | | AttributeKey: '[415136.0.865304943]' |
| | | Synonym: 'æå¤§åºå' |
| | | } |
| | | AttributeRepresentation MinimumInventory |
| | | { |
| | | AttributeKey: '[415136.0.865304933]' |
| | | Synonym: 'æå°åºå' |
| | | } |
| | | RelationRepresentation AsFirstCellInColumn { RelationKey: '[415136.0.865304766]' Visibility: 'Normal' } |
| | | } |
| | |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Description: 'Financial production report' |
| | | Image: 'DOCUMENT_REFRESH' |
| | | Label: 'Financial production report' |
| | | Label: 'è´¢å¡äº§éæ¥è¡¨' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Description: 'Financial sales report' |
| | | Image: 'MONEY_COINS2' |
| | | Label: 'Financial sales report' |
| | | Label: 'è´¢å¡ééæ¥è¡¨' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Description: 'Inventory summary report' |
| | | Image: 'DOCUMENT_CHECK_EDIT' |
| | | Label: 'Inventory summary report' |
| | | Label: 'åºåæ±æ»æ¥è¡¨' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Description: 'Financial weekly report' |
| | | Image: 'DOCUMENT_DIRTY' |
| | | Label: 'Financial weekly report' |
| | | Label: 'é¿æ¥å¨æ¥æ¥è¡¨' |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Pipeline report' |
| | | Image: 'DOCUMENT_CONNECTION' |
| | | Label: 'Pipeline report' |
| | | Label: '管线æ¥è¡¨' |
| | | Taborder: 5 |
| | | ] |
| | | } |
| | |
| | | Properties: |
| | | [ |
| | | Image: 'MONEY2' |
| | | Label: 'engine logistics cost report ' |
| | | Label: 'å卿ºç©æµææ¬æ¥è¡¨' |
| | | Taborder: 11 |
| | | ] |
| | | } |
| | |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Description: 'CC engine logistics cost report' |
| | | Image: 'MONEY2' |
| | | Taborder: 0 |
| | | Title: 'CC engine logistics cost report' |
| | | Title: 'é¿æ¥å卿ºç©æµææ¬æ¥è¡¨' |
| | | ] |
| | | } |
| | | Component MenuDLEngineLogisticsCostReport |
| | |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Description: 'DL engine logistics cost report' |
| | | Image: 'MONEY2' |
| | | Taborder: 1 |
| | | Title: 'DL engine logistics cost report' |
| | | Title: '大è¿å卿ºç©æµææ¬æ¥è¡¨' |
| | | ] |
| | | } |
| | | ] |
| | |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Description: 'Engine pipeline report' |
| | | Image: 'DOCUMENT_CONNECTION' |
| | | Taborder: 0 |
| | | Title: 'Engine pipeline report' |
| | | Title: 'å卿ºç®¡çº¿æ¥è¡¨' |
| | | ] |
| | | } |
| | | Component MenuMachiningPipelineReport |
| | |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Description: 'Machining pipeline report' |
| | | Image: 'DOCUMENT_CONNECTION' |
| | | Taborder: 1 |
| | | Title: 'Machining pipeline report' |
| | | Title: 'æºå 件管线æ¥è¡¨' |
| | | ] |
| | | } |
| | | ] |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'CC engine logistics cost report' |
| | | Image: 'MONEY2' |
| | | Title: 'CC engine logistics cost report' |
| | | Title: 'é¿æ¥å卿ºç©æµææ¬æ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: MatrixEditorTable |
| | | Response OnUpdateValue ( |
| | | CCEngineLogisticsCostRow row, |
| | | CCEngineLogisticsCostColumn column, |
| | | CCEngineLogisticsCostCell cell, |
| | | DLEngineLogisticsCostRow row, |
| | | DLEngineLogisticsCostColumn column, |
| | | DLEngineLogisticsCostCell cell, |
| | | Number value, |
| | | Number oldvalue |
| | | ) id:Response_MatrixEditorTable_OnUpdateValue |
| | |
| | | { |
| | | Body: |
| | | [* |
| | | table := selectobject( MacroPlan, CCEngineLogisticsCostReport, report, not report.IsShow() ); |
| | | cell.Coefficient( value ); |
| | | traverse( table, Row, trow, trow.Name() = row.Name() ){ |
| | | traverse( trow, Cell, tcel, tcel.Column().Name() = column.Name() ){ |
| | | tcel.RentEnterCost( cell.RentEnterCost() ); |
| | | tcel.RentOutCost( cell.RentOutCost() ); |
| | | tcel.FactoryToRentTransCost( cell.FactoryToRentTransCost() ); |
| | | tcel.RentStorageCost( cell.RentStorageCost() ); |
| | | tcel.Coefficient( cell.Coefficient() ); |
| | | } |
| | | } |
| | | table := selectobject( MacroPlan, DLEngineLogisticsCostReport, report, not report.IsShow() ); |
| | | info( focusedattribute ); |
| | | //cell.Coefficient( value ); |
| | | //traverse( table, Row, trow, trow.Name() = row.Name() ){ |
| | | // traverse( trow, Cell, tcel, tcel.Column().Name() = column.Name() ){ |
| | | // tcel.RentEnterCost( cell.RentEnterCost() ); |
| | | // tcel.RentOutCost( cell.RentOutCost() ); |
| | | // tcel.FactoryToRentTransCost( cell.FactoryToRentTransCost() ); |
| | | // tcel.RentStorageCost( cell.RentStorageCost() ); |
| | | // tcel.Coefficient( cell.Coefficient() ); |
| | | // } |
| | | //} |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormDLEngineLogisticsCostReport/Response_OnClose.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Response OnClose () id:Response_FormDLEngineLogisticsCostReport_OnClose |
| | | Response OnCreated () id:Response_FormDLEngineLogisticsCostReport_OnCreated |
| | | { |
| | | #keys: '[415136.0.992750704]' |
| | | #keys: '[415136.0.997148779]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebForm_OnClose' |
| | | DefinitionID: 'Responsedef_WebComponent_OnCreated' |
| | | QuillAction |
| | | { |
| | | Body: |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'DL engine logistics cost report' |
| | | Image: 'MONEY2' |
| | | Title: 'DL engine logistics cost report' |
| | | Title: '大è¿å卿ºç©æµææ¬æ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Engine pipeline report' |
| | | Image: 'DOCUMENT_CONNECTION' |
| | | Title: 'Engine pipeline report' |
| | | Title: 'å卿ºç®¡çº¿æ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Financial production report' |
| | | Image: 'DOCUMENT_REFRESH' |
| | | Title: 'Financial production report' |
| | | Title: 'è´¢å¡äº§éæ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Financial sales report' |
| | | Image: 'MONEY_COINS2' |
| | | Title: 'Financial sales report' |
| | | Title: 'è´¢å¡ééæ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Financial weekly report' |
| | | Image: 'DOCUMENT_DIRTY' |
| | | Title: 'Financial weekly report' |
| | | Title: 'é¿æ¥å¨æ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Inventory summary report' |
| | | Image: 'DOCUMENT_CHECK_EDIT' |
| | | Title: 'Inventory summary report' |
| | | Title: 'åºåæ±æ»æ¥è¡¨' |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Description: 'Machining pipeline report' |
| | | Image: 'DOCUMENT_CONNECTION' |
| | | Title: 'Machining pipeline report' |
| | | Title: 'æºå 件管线æ¥è¡¨' |
| | | ] |
| | | } |