VWED.git - Gitblit

			@@ -9,11 +9,14 @@
			macroPlan.CC_EngineRackRow( relflush );
			macroPlan.CC_EngineRackColumn( relflush );

			// åå»ºè¡EVO5 MLB, EVO5 MQB, GEN3 MLB, GEN3 MQB
			macroPlan.CC_EngineRackRow( relnew, Generation := "EVO5", MLB_MQB := "MLB" );
			macroPlan.CC_EngineRackRow( relnew, Generation := "EVO5", MLB_MQB := "MQB" );
			macroPlan.CC_EngineRackRow( relnew, Generation := "GEN3", MLB_MQB := "MLB" );
			macroPlan.CC_EngineRackRow( relnew, Generation := "GEN3", MLB_MQB := "MQB" );
			// åå»ºè¡
			genrations := selectuniquevalues( macroPlan, Product_MP, tempPMP, tempPMP.Generation().TrimBoth() <> "", tempPMP.Generation() );
			mqbmlbs := selectuniquevalues( macroPlan, Product_MP, tempPMP, tempPMP.MQBMLB().TrimBoth() <> "", tempPMP.MQBMLB() );
			traverse ( genrations, Elements, g, g.ToUpper() = "EVO5" or g.ToUpper() = "GEN3" ) {
			traverse ( mqbmlbs, Elements, m, m.ToUpper() = "MLB" or m.ToUpper() = "MQB" ) {
			macroPlan.CC_EngineRackRow( relnew, Generation := g, MLB_MQB := m );
			}
			}

			// åå»ºå
			indexDate := macroPlan.StartOfPlanning().Date().StartOfMonth();
			@@ -24,12 +27,54 @@

			// åå»ºååæ ¼
			traverse ( macroPlan, CC_EngineRackRow, ccerr ) {

			// åå¨æºææ¬åæ°
			lce := select( macroPlan, LogisticsCostEngine, tempLCE, tempLCE.Generation() = ccerr.Generation() and tempLCE.MLB_MQB() = ccerr.MLB_MQB() and tempLCE.Factory() = "é¿æ¥å·¥å" );

			// ææ¶ææ¬åæ°
			lcmr := select( macroPlan, LogisticsCostMaterialRack, tempLCMR, tempLCMR.Factory() = "é¿æ¥å·¥å" );

			traverse ( macroPlan, CC_EngineRackColumn, ccerc ) {
			cell := ccerr.CC_EngineRackCell( relnew );

			// ç©ºææ¶æ°éï¼é¿æ¥åè¯¥äº§åçææ¶æ»æ°é - åå¨æºåºå / åè£å®¹é ï¼
			lastDayOfThisMonth := ccerc.StartDate().StartOfNextMonth() - 1;
			plannedInventory := sum( macroPlan, Product_MP.ProductInStockingPoint_MP.ProductInStockingPointInPeriod, tempPISPIP,
			tempPISPIP.ProductInStockingPoint_MP().Product_MP().IsLeaf() and
			tempPISPIP.ProductInStockingPoint_MP().Product_MP().ParentID() = "äº§æå" and
			tempPISPIP.ProductInStockingPoint_MP().StockingPointID() = "é¿æ¥å¤ç§åº" and
			tempPISPIP.ProductInStockingPoint_MP().Product_MP().Generation() = ccerr.Generation() and
			tempPISPIP.ProductInStockingPoint_MP().Product_MP().MQBMLB() = ccerr.MLB_MQB() and
			tempPISPIP.Start().Date() = lastDayOfThisMonth,
			tempPISPIP.PlannedInventoryLevelEnd() );
			cell.PackagingCapacity( guard( lce.PackagingCapacity(), 0 ) );
			cell.PlannedInventory( plannedInventory );

			// å¤ç§åºå¥åºè´¹ç¨ï¼åå¨æºéé / åè£å®¹é[åä¸åæ´] * ææ¶å¥åºåä»·ï¼
			engineSales := sum( macroPlan, FSImportData, tempFSID,
			tempFSID.Unit() = "é¿æ¥å·¥å" and
			tempFSID.Generation() = ccerr.Generation() and
			tempFSID.MqbMlb() = ccerr.MLB_MQB() and
			tempFSID.StartDate().Year() = ccerc.StartDate().Year() and
			tempFSID.StartDate().Month() = ccerc.StartDate().Month(),
			tempFSID.Quantity() );
			cell.StorageFeesForRentedWarehouses( guard( [Number] ( engineSales / guard( lce.PackagingCapacity(), 0 ) ) * guard( lcmr.WarehousingPrice(), 0 ), 0 ) );

			// å¤ç§åºåºåºè´¹ç¨ï¼åå¨æºäº§é / åè£å®¹é[åä¸åæ´] * ææ¶åºåºåä»·ï¼
			engineProductions := sum( macroPlan, FPImportData, tempFPID,
			tempFPID.Unit() = "é¿æ¥å·¥å" and
			tempFPID.Generation() = ccerr.Generation() and
			tempFPID.MqbMlb() = ccerr.MLB_MQB() and
			tempFPID.StartDate().Year() = ccerc.StartDate().Year() and
			tempFPID.StartDate().Month() = ccerc.StartDate().Month(),
			tempFPID.Quantity() );
			cell.OutboundExpensesForRentedWarehouses( guard( [Number] ( engineProductions / guard( lce.PackagingCapacity(), 0 ) ) * guard( lcmr.OutboundPrice(), 0 ), 0 ) );

			// å¤ç§åºè¿è¾è´¹ç¨ï¼åå¨æºè¿è¾é/åè£å®¹é/è£è½½å®¹éï¼åä¸åæ´ï¼*ææ¶è¿è¾åä»·
			// å¤ç§åºä»å¨è´¹ç¨ï¼ææ¶æ»æ°é-åå¨æºåºå/åè£å®¹éï¼åä¸åæ´ï¼ï¼åä¹ä»¥ç©ºææ¶ä»å¨åä»·å¾å°ç©ºææ¶ä»å¨è´¹ç¨ãåå¨æºåºååActual inventorieséåå°é¿æ¥å¤ç§åºè¯¥åå¨æºçä»å¨éï¼ææ¶æ»æ°ééè¦æå¨ç»´æ¤ã
			// æ¸æ´è´¹ç¨ï¼åå¨æºå¥åºé/åè£å®¹é*ææ¶æ¸æ´åä»·ãåå¨æºå¥åºéååå¨æºééï¼åè£å®¹éåèªåå¨æºææ¬è¡¨ãææ¶æ¸æ´åä»·åææ¶ææ¬è¡¨ã

			cell.CC_EngineRackColumn( relset, ccerc );
			}
			}
			*]

	_Main/BL/Type_CC_EngineRackCell/Attribute_PackagingCapacity.qbl	8 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	_Main/BL/Type_CC_EngineRackCell/Attribute_PlannedInventory.qbl	7 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	_Main/BL/Type_CC_EngineRackCell/Function_CalcNumberOfEmptyShelves.qbl	13 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	_Main/BL/Type_CC_EngineRackCell/StaticMethod_CreateData.qbl	55 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	_Main/UI/MacroPlannerWebApp/Component_FormCC_EngineRackReport/Response_pHeader_bRefresh_OnClick.def	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	_Main/UI/MacroPlannerWebApp/Views/CCEngineRackReport.vw	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,8 @@
			Quintiq file version 2.0
			#parent: #root
			Attribute PackagingCapacity
			{
			#keys: '3[415754.0.111003142][415754.0.111003141][415754.0.111003143]'
			Description: 'åè£å®¹é'
			ValueType: Number
			}

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,7 @@
			Quintiq file version 2.0
			#parent: #root
			Attribute PlannedInventory
			{
			#keys: '3[415754.0.111003178][415754.0.111003177][415754.0.111003179]'
			ValueType: Real
			}

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,13 @@
			Quintiq file version 2.0
			#parent: #root
			Function CalcNumberOfEmptyShelves
			{
			TextBody:
			[*
			// vwedadmin Aug-20-2024 (created)

			value := guard( [Number] ( this.TotalQuantityOfMaterialRacks() - ( this.PlannedInventory() / this.PackagingCapacity() ) ), 0 );

			this.NumberOfEmptyShelves( value );
			*]
			}

			@@ -14,6 +14,8 @@
			Body:
			[*
			CC_EngineRackCell::CreateData( MacroPlan );

			WebMessageBox::Success( Translations::A_VWED_Success() );
			*]
			GroupServerCalls: false
			}

			@@ -30,7 +30,7 @@
			FormCC_EngineRackReport_MatrixEditor531
			{
			gridColor: '#c4c4c4'
			totalHeaderWidth: 200
			totalHeaderWidth: 500
			attributeHeaderWidthRatio: 0.6
			nameHeaderWidthRatio: 0.4
			columnWidth: 100