大连料架优化

admin

2024-10-23 531bf2d5dc98162aa050d03cba99a71c7ffb47d5

大连料架优化

 _Main/BL/Type_DL_EngineRackCell/Attribute_CCCleaningCost.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute CCCleaningCost
{
  #keys: '3[415754.0.513823110][415754.0.513823109][415754.0.513823111]'
  Description: '长春外租库清洗费用'
  ValueType: Real
}

 _Main/BL/Type_DL_EngineRackCell/Attribute_CleaningCost.qbl

@@ -3,6 +3,6 @@
Attribute CleaningCost
{
  #keys: '3[413988.0.1488160070][413988.0.1488160069][413988.0.1488160071]'
  Description: '清洗费用'
  Description: '大连外租库清洗费用'
  ValueType: Real
}

 _Main/BL/Type_DL_EngineRackCell/Attribute_IsCCCleaningCost.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute IsCCCleaningCost
{
  #keys: '3[415754.0.513823146][415754.0.513823145][415754.0.513823147]'
  Description: '长春外租库清洗费用更新值'
  ValueType: Boolean
}

 _Main/BL/Type_DL_EngineRackCell/StaticMethod_CreateData.qbl

@@ -34,7 +34,7 @@
                        and tempLCE.StartDate() <= dlerc.StartDate() and tempLCE.EndDate() >= dlerc.StartDate().StartOfNextMonth() );
                        
        // æ–™æž¶æˆæœ¬å‚æ•°
        lcmr := select( macroPlan, LogisticsCostMaterialRack, tempLCMR, tempLCMR.Factory() = "大连工厂" 
        lcmr := select( macroPlan, LogisticsCostMaterialRack, tempLCMR, tempLCMR.Factory() = "长春工厂" 
                        and tempLCMR.StartDate() <= dlerc.StartDate() and tempLCMR.EndDate() >= dlerc.StartDate().StartOfNextMonth() );
                        
        // è¿è¾“成本参数
@@ -95,11 +95,11 @@
        
        // DL外租库入库费用：发动机入库量 / åŒ…装容量（向上取整）* æ–™æž¶å…¥åº“单价
        inventoryQuantity := sum( macroPlan, SalesDemand.astype( Forecast ), tempF, 
                                  tempF.Product_MP().Generation() =  dlerr.Generation()       and
                                  tempF.Product_MP().MQBMLB()     =  dlerr.MLB_MQB()          and
                                  tempF.StockingPointID()         =  "大连外租库"             and
                                  tempF.StartDate().Year()        = dlerc.StartDate().Year()  and
                                  tempF.StartDate().Month()       = dlerc.StartDate().Month(),
                                  tempF.Product_MP().Generation()         =  dlerr.Generation()       and
                                  tempF.Product_MP().MQBMLB()             =  dlerr.MLB_MQB()          and
                                  tempF.StockingPointID()                 =  "大连外租库"             and
                                  ( tempF.StartDate() - 2 ).Year()        = dlerc.StartDate().Year()  and
                                  ( tempF.StartDate() - 2 ).Month()       = dlerc.StartDate().Month(),
                                  tempF.FulfilledQuantity() );
    //                   info( "时间：", dlerc.StartDate().Format( "Y-M2-D2" ), "    å…¥åº“数量：", inventoryQuantity, "    åŒ…装容量：", guard( lce.PackagingCapacity(), 0 ),
    //                         "    è£…载容量：", guard( lct1.LoadingCapacity(), 0 ) ); // æµ‹è¯•è¾“出
@@ -109,7 +109,7 @@
        outboundQuantity := sum( macroPlan, Product_MP.ProductInStockingPoint_MP.ProductInStockingPointInPeriodPlanning.astype( ProductInStockingPointInPeriodPlanningLeaf ), tempPISPIPPL,
                                 tempPISPIPPL.ProductInStockingPoint_MP().Product_MP().Generation() = dlerr.Generation()  and
                                 tempPISPIPPL.ProductInStockingPoint_MP().Product_MP().MQBMLB()     = dlerr.MLB_MQB()     and
                                 tempPISPIPPL.ProductInStockingPoint_MP().StockingPointID()         = "大连外租库"        and
                                 tempPISPIPPL.ProductInStockingPoint_MP().StockingPointID()         = "大连场内库"        and
                                 tempPISPIPPL.Start().Date()                                        >= dlerc.StartDate()  and
                                 tempPISPIPPL.End().Date()                                          <= lastDayOfThisMonth,
                                 tempPISPIPPL.NewSupplyQuantity() );
@@ -130,14 +130,22 @@
                                  tempPISPIP.PlannedInventoryLevelEnd() );
        cell.DLRentalWarehouseStorageFees( [Number] ( guard( ( cell.TotalQuantityOfMaterialRacks() - plannedInventory1 ) / lce.PackagingCapacity(), 0 ) * guard( lcmr.StoragePrice(), 1 ) ) );
        
        //清洗费用：发动机入库量 / åŒ…装容量 * æ–™æž¶æ¸…洗单价。发动机入库量取发动机销量，包装容量取自发动机成本表。料架清洗单价取料架成本表。
        cell.CleaningCost( [Number] ( guard( inventoryQuantity / lce.PackagingCapacity(), 0 ) * guard( lcmr.CleanPrice(), 1 ) ) );
        // DL外租库清洗费用：发动机入库量 / åŒ…装容量 * æ–™æž¶æ¸…洗单价。发动机入库量取发动机销量，包装容量取自发动机成本表。料架清洗单价取料架成本表。
        cell.CleaningCost( [Number] ( guard( outboundQuantity / lce.PackagingCapacity(), 0 ) * guard( lcmr.CleanPrice(), 1 ) ) );
        
        // é¢„计总费用
        cell.EstimatedTotalCost( cell.CCStorageFeesForRentedWarehouses() + cell.CCOutboundExpensesForRentedWarehouses() + cell.CCRentalWarehouseStorageFees() + cell.CCLineHaulCost() + 
                                 cell.CCShortDistanceTransportationCosts() + cell.DLStorageFeesForRentedWarehouses() + cell.DLOutboundExpensesForRentedWarehouses() +
                                 cell.DLExternalRentalWarehouseTransportationCosts() + cell.DLRentalWarehouseStorageFees() + cell.CleaningCost() );
        
        // å¤§è¿žå¤–租库料架费用
        cell.DLRentalWarehouseMaterialRackCost( cell.DLStorageFeesForRentedWarehouses() + cell.DLOutboundExpensesForRentedWarehouses() +
                                                cell.DLExternalRentalWarehouseTransportationCosts() );
        
        // CC外租库DL料架费用
        cell.CCExternalRentalWarehouseDLMaterialRackCost( cell.CCStorageFeesForRentedWarehouses() + cell.CCOutboundExpensesForRentedWarehouses() +
                                                          cell.CCRentalWarehouseStorageFees() + cell.CCShortDistanceTransportationCosts() );
        
        // ç³»æ•°
        cell.Coefficient( 1.05 );
        

 _Main/Sys/Repr/Global/DL_EngineRackCell.qrp

@@ -2,10 +2,26 @@
#parent: #root
TypeRepresentation DL_EngineRackCell
{
  AttributeRepresentation CCExternalRentalWarehouseDLMaterialRackCost
  {
    AttributeKey: '[415754.0.481133918]'
    Synonym: 'CC外租库DL料架费用'
    Conditional:
    [
      DataRepresentation.Conditional
      {
        BackgroundColor: '$FF3399'
        ConditionBody: 'object.IsCCExternalRentalWarehouseDLMaterialRackCost()'
        ConversionBody: ''
        DefaultBackgroundColor: false
        InheritConversion: false
      }
    ]
  }
  AttributeRepresentation CCLineHaulCost
  {
    AttributeKey: '[413988.0.1488160126]'
    Synonym: 'CC长途运输费用'
    Synonym: '两厂间料架运输费用'
    Conditional:
    [
      DataRepresentation.Conditional
@@ -85,7 +101,7 @@
  AttributeRepresentation CleaningCost
  {
    AttributeKey: '[413988.0.1488160069]'
    Synonym: '清洗费用'
    Synonym: 'DL外租库清洗费用'
    Conditional:
    [
      DataRepresentation.Conditional
@@ -151,10 +167,26 @@
      }
    ]
  }
  AttributeRepresentation DLRentalWarehouseMaterialRackCost
  {
    AttributeKey: '[415754.0.481133881]'
    Synonym: 'DL外租库料架费用'
    Conditional:
    [
      DataRepresentation.Conditional
      {
        BackgroundColor: '$FF3399'
        ConditionBody: 'object.IsDLRentalWarehouseMaterialRackCost()'
        ConversionBody: ''
        DefaultBackgroundColor: false
        InheritConversion: false
      }
    ]
  }
  AttributeRepresentation DLRentalWarehouseStorageFees
  {
    AttributeKey: '[413988.0.1488160103]'
    Synonym: '外租库仓储费用'
    Synonym: 'DL外租库仓储费用'
    Conditional:
    [
      DataRepresentation.Conditional
@@ -199,6 +231,11 @@
      }
    ]
  }
  AttributeRepresentation IsCleaningCost
  {
    AttributeKey: '[415754.0.459256980]'
    Synonym: 'CC外租库清洗费用'
  }
  AttributeRepresentation NumberOfEmptyShelves
  {
    AttributeKey: '[413988.0.1488160058]'

 _Main/UI/MacroPlannerWebApp/Component_FormDL_EngineRackReport/Component_MatrixEditor392.def

@@ -26,7 +26,7 @@
      ]
      Properties:
      [
        Attributes: 'TotalQuantityOfMaterialRacks;NumberOfEmptyShelves;CCStorageFeesForRentedWarehouses;CCOutboundExpensesForRentedWarehouses;CCRentalWarehouseStorageFees;CCLineHaulCost;CCShortDistanceTransportationCosts;DLStorageFeesForRentedWarehouses;DLOutboundExpensesForRentedWarehouses;DLExternalRentalWarehouseTransportationCosts;DLRentalWarehouseStorageFees;CleaningCost;EstimatedTotalCost;Coefficient;TotalCost'
        Attributes: 'TotalQuantityOfMaterialRacks;NumberOfEmptyShelves;CCStorageFeesForRentedWarehouses;CCOutboundExpensesForRentedWarehouses;CCRentalWarehouseStorageFees;CCShortDistanceTransportationCosts;CCCleaningCost;DLStorageFeesForRentedWarehouses;DLOutboundExpensesForRentedWarehouses;DLExternalRentalWarehouseTransportationCosts;DLRentalWarehouseStorageFees;CleaningCost;DLRentalWarehouseMaterialRackCost;CCExternalRentalWarehouseDLMaterialRackCost;CCLineHaulCost;EstimatedTotalCost;Coefficient;TotalCost'
        Column: 'DL_EngineRackColumn'
        Row: 'DL_EngineRackRow'
        Taborder: 0