Merge branch 'dev' of http://47.101.211.7:10101/r/TIANMA_JITUAN into dev_lhj
已重命名3个文件
已添加12个文件
已修改62个文件
已删除87个文件
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeChartElement_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeChartElement |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.999194645]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.999194647][414384.0.999194646][414384.0.999194648]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeChartElement |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeChartElement |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.999194650][414384.0.999194649][414384.0.999194651]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeChartRow_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeChartRow |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881297]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881299][414384.0.996881298][414384.0.996881300]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeChartRow |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeChartRow |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881302][414384.0.996881301][414384.0.996881303]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeCompareItemColumn_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeCompareItemColumn |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881443]' |
|---|
| | | ProceduralSequenceRelationStrategy |
|---|
| | | { |
|---|
| | | #keys: '13[0.0.0][414384.0.996881465][414384.0.996881459][414384.0.996881466][414384.0.996881460][414384.0.996881467][414384.0.996881461][414384.0.996881468][414384.0.996881462][414384.0.996881469][414384.0.996881463][414384.0.996881470][414384.0.996881464]' |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881445][414384.0.996881444][414384.0.996881446]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeCompareItemColumn |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeCompareItemColumn |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881448][414384.0.996881447][414384.0.996881449]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeCompareItemRow_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeCompareItemRow |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881317]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881319][414384.0.996881318][414384.0.996881320]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeCompareItemRow |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeCompareItemRow |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881322][414384.0.996881321][414384.0.996881323]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeFilterBusinessType_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeFilterBusinessType |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881340]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881342][414384.0.996881341][414384.0.996881343]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeFilterBusinessType |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeFilterBusinessType |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881345][414384.0.996881344][414384.0.996881346]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeFilterItem_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeFilterItem |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881358]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881360][414384.0.996881359][414384.0.996881361]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeFilterItem |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeFilterItem |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881363][414384.0.996881362][414384.0.996881364]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeFilterMonth_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeFilterMonth |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881381]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881383][414384.0.996881382][414384.0.996881384]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeFilterMonth |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeFilterMonth |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881386][414384.0.996881385][414384.0.996881387]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeFilterPlaceOfProductionOfArray_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeFilterPlaceOfProductionOfArray |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881401]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881403][414384.0.996881402][414384.0.996881404]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeFilterPlaceOfProductionOfArray |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeFilterPlaceOfProductionOfArray |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881406][414384.0.996881405][414384.0.996881407]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation CapacityAndSaleBudgeFilterYear_GlobalOTDSOP_GlobalOTDSOP_CapacityAndSaleBudgeFilterYear |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.996881421]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881423][414384.0.996881422][414384.0.996881424]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: CapacityAndSaleBudgeFilterYear |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide CapacityAndSaleBudgeFilterYear |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.996881426][414384.0.996881425][414384.0.996881427]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Relation PRHistoryData_GlobalOTDSOP_GlobalOTDSOP_PRHistoryData |
|---|
| | | { |
|---|
| | | #keys: '1[414384.0.999194777]' |
|---|
| | | DefaultRelationStrategy |
|---|
| | | { |
|---|
| | | } |
|---|
| | | RelationSide.LeftSide GlobalOTDSOP |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.999194779][414384.0.999194778][414384.0.999194780]' |
|---|
| | | Cardinality: '0to1' |
|---|
| | | ObjectDefinition: PRHistoryData |
|---|
| | | OwningSide: 'Reference' |
|---|
| | | } |
|---|
| | | RelationSide.RightSide PRHistoryData |
|---|
| | | { |
|---|
| | | #keys: '3[414384.0.999194782][414384.0.999194781][414384.0.999194783]' |
|---|
| | | Cardinality: '1toN' |
|---|
| | | ObjectDefinition: GlobalOTDSOP |
|---|
| | | OwningSide: 'Owned' |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod TestData ( |
|---|
| | | GlobalOTDTable parent |
|---|
| | | GlobalOTDSOP parent |
|---|
| | | ) |
|---|
| | | { |
|---|
| | | Description: 'çææµè¯æ°æ®' |
|---|
| | |
|---|
| | | info( "çæ年度产éé¢ç®æ¥è¡¨æµè¯æ°æ®" ) |
|---|
| | | |
|---|
| | | parent.CapacityAndSaleBudgeChartElement( relflush ); |
|---|
| | | |
|---|
| | | for( sc := 0; sc < 4; sc := sc + 1 ) { |
|---|
| | | scenarioName := "SC" + [String]sc; |
|---|
| | | for( i := 0; i < 4; i := i + 1 ) { |
|---|
| | |
|---|
| | | for( j := 1; j <= 12; j := j + 1 ) { |
|---|
| | | monthString := "MONTH" + ifexpr( j < 10, "0" + [String]j, [String]j ); |
|---|
| | | parent.CapacityAndSaleBudgeChartElement( relnew, |
|---|
| | | BusinessTypeOrPlaceOfProductionOfArray := businessTypeString, |
|---|
| | | TimeStringAndScenarioName := monthString + " - " + scenarioName, |
|---|
| | | Quantity := Real::Random( 20.0, 30.0 ) ); |
|---|
| | | BusinessTypeOrPlaceOfProductionOfArray := businessTypeString, |
|---|
| | | TimeStringAndScenarioName := monthString + " - " + scenarioName, |
|---|
| | | Quantity := Real::Random( 20.0, 30.0 ) ); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod CreateIfNotExist ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | GlobalOTDSOP parent, |
|---|
| | | String businessType, |
|---|
| | | String placeOfProductionOfArray |
|---|
| | | ) as CapacityAndSaleBudgeChartRow |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod CreateIfNotExist ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | GlobalOTDSOP parent, |
|---|
| | | String columnName |
|---|
| | | ) as CapacityAndSaleBudgeCompareItemColumn |
|---|
| | | { |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod CreateIfNotExist ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | GlobalOTDSOP parent, |
|---|
| | | String businessType, |
|---|
| | | String placeOfProductionOfArray |
|---|
| | | ) as CapacityAndSaleBudgeCompareItemRow |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod CreateIfNotExist ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | GlobalOTDSOP parent, |
|---|
| | | String value |
|---|
| | | ) |
|---|
| | | { |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod CreateIfNotExist ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | GlobalOTDSOP parent, |
|---|
| | | String itemName |
|---|
| | | ) |
|---|
| | | { |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod Initial ( |
|---|
| | | GlobalOTDTable parent |
|---|
| | | GlobalOTDSOP parent |
|---|
| | | ) |
|---|
| | | { |
|---|
| | | Description: 'åå§å对æ¯é¡¹' |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod Initial ( |
|---|
| | | GlobalOTDTable parent |
|---|
| | | GlobalOTDSOP parent |
|---|
| | | ) |
|---|
| | | { |
|---|
| | | Description: 'åå§å年份' |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod CreateIfNotExist ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | GlobalOTDSOP parent, |
|---|
| | | String value |
|---|
| | | ) |
|---|
| | | { |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod Initial ( |
|---|
| | | GlobalOTDTable parent |
|---|
| | | GlobalOTDSOP parent |
|---|
| | | ) |
|---|
| | | { |
|---|
| | | Description: 'åå§å年份' |
|---|
| ÎļþÃû´Ó _Main/BL/Type_GlobalDTOTable/Method_CapacityAndSaleBudgeCompare.qbl ÐÞ¸Ä |
| | |
|---|
| | | CapacityAndSaleBudgeFilterItems items, |
|---|
| | | CapacityAndSaleBudgeFilterYears years, |
|---|
| | | CapacityAndSaleBudgeFilterMonths months, |
|---|
| | | GlobalOTDTable otdTable |
|---|
| | | const GlobalOTDTable otdTable |
|---|
| | | ) |
|---|
| | | { |
|---|
| | | Description: 'todo : mappingParentæ¹ä¸ºmpSync, randomå äº' |
|---|
| | |
|---|
| | | this.CapacityAndSaleBudgeCompareItemRow( relflush ); |
|---|
| | | this.CapacityAndSaleBudgeCompareItemColumn( relflush ); |
|---|
| | | // ====æ±æ»ææåºç°ç产å==== |
|---|
| | | historyData := selectset( this, Global_MappingAnnualBudgetData, item, true ); |
|---|
| | | historyData := selectset( otdTable, Global_MappingAnnualBudgetData, item, true ); |
|---|
| | | debuginfo( "historyData : " + [String]historyData.Size() ); |
|---|
| | | |
|---|
| | | traverse( historyData, Elements, one ) { |
|---|
| | |
|---|
| | | traverse( months, Elements, month ) { |
|---|
| | | columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "é¢æ¿åé
é-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "æ-年度é¢ç®" ); |
|---|
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
|---|
| | | cellReal := Global_MappingForecast::GetQuantityByMonth( row.GetProductCodes(), this, DateTime::Now().Year(), month.MonthNo() ); |
|---|
| | | cellReal := Global_MappingForecast::GetQuantityByMonth( row.GetProductCodes(), otdTable, DateTime::Now().Year(), month.MonthNo() ); |
|---|
| | | cell := columnMonth.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal ); |
|---|
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "é¢æ¿åé
é-" + [String]year.YearNo() + "å¹´-total-年度é¢ç®" ); |
|---|
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
|---|
| | | cellReal := Global_MappingForecast::GetQuantityByYear( row.GetProductCodes(), this, year.YearNo() ); |
|---|
| | | cellReal := Global_MappingForecast::GetQuantityByYear( row.GetProductCodes(), otdTable, year.YearNo() ); |
|---|
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal ); |
|---|
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
|---|
| | | } |
|---|
| | |
|---|
| | | traverse( months, Elements, month ) { |
|---|
| | | columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对å¤éå®é¢-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "æ-年度é¢ç®" ); |
|---|
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
|---|
| | | cellReal := Global_MappingAnnualBudgetData::GetSaleByMonth( row.GetProductCodes(), this, year.YearNo(), month.MonthNo() ); |
|---|
| | | cellReal := Global_MappingAnnualBudgetData::GetSaleByMonth( row.GetProductCodes(), otdTable, year.YearNo(), month.MonthNo() ); |
|---|
| | | cell := columnMonth.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal ); |
|---|
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对å¤éå®é¢-" + [String]year.YearNo() + "å¹´-年度é¢ç®" ); |
|---|
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
|---|
| | | cellReal := Global_MappingAnnualBudgetData::GetSaleByYear( row.GetProductCodes(), this, year.YearNo() ); |
|---|
| | | cellReal := Global_MappingAnnualBudgetData::GetSaleByYear( row.GetProductCodes(), otdTable, year.YearNo() ); |
|---|
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal ); |
|---|
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod RefreshCapacityAndSaleBudgeFilter ( |
|---|
| | | Boolean deleteBeforeCreate, |
|---|
| | | const GlobalOTDTable otdTable, |
|---|
| | | GlobalOTDSOP otdSop |
|---|
| | | ) |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Oct-17-2023 (created) |
|---|
| | | if( deleteBeforeCreate ) { |
|---|
| | | otdSop.CapacityAndSaleBudgeFilterBusinessType( relflush ); |
|---|
| | | otdSop.CapacityAndSaleBudgeFilterPlaceOfProductionOfArray( relflush ); |
|---|
| | | } |
|---|
| | | // yypsybs Sep-21-2023 (created) |
|---|
| | | debuginfo( "=====RefreshCapacityAndSaleBudgeFilter====" ); |
|---|
| | | businessTypes := selectuniquevalues( otdTable, Global_MappingAnnualBudgetData, item, item.BusinessType() ); |
|---|
| | | debuginfo( [String]businessTypes.Size() ); |
|---|
| | | traverse( businessTypes, Elements, businessType ) { |
|---|
| | | CapacityAndSaleBudgeFilterBusinessType::CreateIfNotExist( otdSop, businessType ); |
|---|
| | | } |
|---|
| | | placeOfProductionOfArrays := selectuniquevalues( otdTable, Global_MappingAnnualBudgetData, item, item.OrgCodeFromBom() ); |
|---|
| | | debuginfo( [String]placeOfProductionOfArrays.Size() ); |
|---|
| | | traverse( placeOfProductionOfArrays, Elements, placeOfProductionOfArray ) { |
|---|
| | | CapacityAndSaleBudgeFilterPlaceOfProductionOfArray::CreateIfNotExist( otdSop, placeOfProductionOfArray ); |
|---|
| | | } |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Method GetCapacityInPCSInYear () as Real |
|---|
| | | Method GetCapacityInPCSInYear () const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | for( i := 1; i <= 12; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlyModCapacity" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | } |
|---|
| | | result := result + [Real]this.MonthlyModCapacity1(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity2(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity3(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity4(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity5(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity6(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity7(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity8(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity9(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity10(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity11(); |
|---|
| | | result := result + [Real]this.MonthlyModCapacity12(); |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | Method GetCapacityInSheetInHalfYear ( |
|---|
| | | Number halfNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | fromMonth := 1 + ( halfNo - 1 ) * 6; |
|---|
| | | toMonth := 6 + ( halfNo - 1 ) * 6; |
|---|
| | | for( i := fromMonth; i <= toMonth; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | if( halfNo = 1 ) { |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity1(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity2(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity3(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity4(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity5(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity6(); |
|---|
| | | } |
|---|
| | | if( halfNo = 2 ) { |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity7(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity8(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity9(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity10(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity11(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity12(); |
|---|
| | | } |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | Method GetCapacityInSheetInSeason ( |
|---|
| | | Number seasonNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | fromMonth := 1 + ( seasonNo - 1 ) * 3; |
|---|
| | | toMonth := 3 + ( seasonNo - 1 ) * 3; |
|---|
| | | for( i := fromMonth; i <= toMonth; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | if( seasonNo = 1 ) { |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity1(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity2(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity3(); |
|---|
| | | } |
|---|
| | | if( seasonNo = 2 ) { |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity4(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity5(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity6(); |
|---|
| | | } |
|---|
| | | if( seasonNo = 3 ) { |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity7(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity8(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity9(); |
|---|
| | | } |
|---|
| | | if( seasonNo = 4 ) { |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity10(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity11(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity12(); |
|---|
| | | } |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Method GetCapacityInSheetInYear () as Real |
|---|
| | | Method GetCapacityInSheetInYear () const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | for( i := 1; i <= 12; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | } |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity1(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity2(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity3(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity4(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity5(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity6(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity7(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity8(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity9(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity10(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity11(); |
|---|
| | | result := result + [Real]this.MonthlySheetCapacity12(); |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | Method GetSaleAmountInHalfYear ( |
|---|
| | | Number halfNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | fromMonth := 1 + ( halfNo - 1 ) * 6; |
|---|
| | | toMonth := 6 + ( halfNo - 1 ) * 6; |
|---|
| | | for( i := fromMonth; i <= toMonth; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | if( halfNo = 1 ) { |
|---|
| | | result := result + [Real]this.MonthlySales1(); |
|---|
| | | result := result + [Real]this.MonthlySales2(); |
|---|
| | | result := result + [Real]this.MonthlySales3(); |
|---|
| | | result := result + [Real]this.MonthlySales4(); |
|---|
| | | result := result + [Real]this.MonthlySales5(); |
|---|
| | | result := result + [Real]this.MonthlySales6(); |
|---|
| | | } |
|---|
| | | if( halfNo = 2 ) { |
|---|
| | | result := result + [Real]this.MonthlySales7(); |
|---|
| | | result := result + [Real]this.MonthlySales8(); |
|---|
| | | result := result + [Real]this.MonthlySales9(); |
|---|
| | | result := result + [Real]this.MonthlySales10(); |
|---|
| | | result := result + [Real]this.MonthlySales11(); |
|---|
| | | result := result + [Real]this.MonthlySales12(); |
|---|
| | | } |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | Method GetSaleAmountInSeason ( |
|---|
| | | Number seasonNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | fromMonth := 1 + ( seasonNo - 1 ) * 3; |
|---|
| | | toMonth := 3 + ( seasonNo - 1 ) * 3; |
|---|
| | | for( i := fromMonth; i <= toMonth; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | if( seasonNo = 1 ) { |
|---|
| | | result := result + [Real]this.MonthlySales1(); |
|---|
| | | result := result + [Real]this.MonthlySales2(); |
|---|
| | | result := result + [Real]this.MonthlySales3(); |
|---|
| | | } |
|---|
| | | if( seasonNo = 2 ) { |
|---|
| | | result := result + [Real]this.MonthlySales4(); |
|---|
| | | result := result + [Real]this.MonthlySales5(); |
|---|
| | | result := result + [Real]this.MonthlySales6(); |
|---|
| | | } |
|---|
| | | if( seasonNo = 3 ) { |
|---|
| | | result := result + [Real]this.MonthlySales7(); |
|---|
| | | result := result + [Real]this.MonthlySales8(); |
|---|
| | | result := result + [Real]this.MonthlySales9(); |
|---|
| | | } |
|---|
| | | if( seasonNo = 4 ) { |
|---|
| | | result := result + [Real]this.MonthlySales10(); |
|---|
| | | result := result + [Real]this.MonthlySales11(); |
|---|
| | | result := result + [Real]this.MonthlySales12(); |
|---|
| | | } |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Method GetSaleAmountInYear () as Real |
|---|
| | | Method GetSaleAmountInYear () const as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | result := 0.0; |
|---|
| | | for( i := 1; i <= 12; i := i + 1 ) { |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]i ); |
|---|
| | | result := result + [Real]field.GetString( this ); |
|---|
| | | } |
|---|
| | | result := result + [Real]this.MonthlySales1(); |
|---|
| | | result := result + [Real]this.MonthlySales2(); |
|---|
| | | result := result + [Real]this.MonthlySales3(); |
|---|
| | | result := result + [Real]this.MonthlySales4(); |
|---|
| | | result := result + [Real]this.MonthlySales5(); |
|---|
| | | result := result + [Real]this.MonthlySales6(); |
|---|
| | | result := result + [Real]this.MonthlySales7(); |
|---|
| | | result := result + [Real]this.MonthlySales8(); |
|---|
| | | result := result + [Real]this.MonthlySales9(); |
|---|
| | | result := result + [Real]this.MonthlySales10(); |
|---|
| | | result := result + [Real]this.MonthlySales11(); |
|---|
| | | result := result + [Real]this.MonthlySales12(); |
|---|
| | | return result; |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number halfNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'äº§è½ - å®æ°å¤§å¼ ' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetSaleByMonth ( |
|---|
| | | Strings productNo, |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | const GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number monthNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'éå®é¢ï¼Wï¼' |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]monthNo ); |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]field.GetString( item ) ); |
|---|
| | | value := 0.0; |
|---|
| | | if( monthNo = 1 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales1() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 2 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales2() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 3 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales3() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 4 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales4() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 5 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales5() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 6 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales6() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 7 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales7() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 8 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales8() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 9 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales9() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 10 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales10() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 11 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales11() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 12 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySales12() ); |
|---|
| | | } |
|---|
| | | return value; |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number seasonNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'äº§è½ - å®æ°å¤§å¼ ' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetSaleByYear ( |
|---|
| | | Strings productNo, |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | const GlobalOTDTable parent, |
|---|
| | | Number yearNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'éå®é¢ï¼Wï¼' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number halfNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'äº§è½ - å®æ°å¤§å¼ ' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number monthNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: '产è½-å®æ°å¤§å¼ ' |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-18-2023 (created) |
|---|
| | | field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]monthNo ); |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]field.GetString( item ) ); |
|---|
| | | value := 0.0; |
|---|
| | | if( monthNo = 1 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity1() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 2 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity2() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 3 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity3() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 4 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity4() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 5 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity5() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 6 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity6() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 7 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity7() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 8 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity8() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 9 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity9() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 10 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity10() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 11 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity11() ); |
|---|
| | | } |
|---|
| | | if( monthNo = 12 ) { |
|---|
| | | value := sum( parent, |
|---|
| | | Global_MappingAnnualBudgetData, |
|---|
| | | item, |
|---|
| | | item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1, |
|---|
| | | [Real]item.MonthlySheetCapacity12() ); |
|---|
| | | } |
|---|
| | | return value; |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number seasonNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'äº§è½ - å®æ°å¤§å¼ ' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | Strings productNo, |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | Number yearNo |
|---|
| | | ) as Real |
|---|
| | | ) const as Real |
|---|
| | | { |
|---|
| | | Description: 'äº§è½ - å®æ°å¤§å¼ ' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetQuantityByMonth ( |
|---|
| | | Strings productCodes, |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | const GlobalOTDTable parent, |
|---|
| | | Number yearNo, |
|---|
| | | Number monthNo |
|---|
| | | ) as Real |
|---|
| | |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetQuantityByYear ( |
|---|
| | | Strings productCodes, |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | const GlobalOTDTable parent, |
|---|
| | | Number yearNo |
|---|
| | | ) as Real |
|---|
| | | { |
|---|
| | | Description: '' |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-19-2023 (created) |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetByProductId ( |
|---|
| | | GlobalOTDTable otdTable, |
|---|
| | | const GlobalOTDTable otdTable, |
|---|
| | | String productId |
|---|
| | | ) as Global_MappingOperation |
|---|
| | | ) as const Global_MappingOperation |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetByProductId ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | const GlobalOTDTable parent, |
|---|
| | | String productId |
|---|
| | | ) as Global_MappingProduct_MP |
|---|
| | | ) as const Global_MappingProduct_MP |
|---|
| | | { |
|---|
| | | Description: 'æ ¹æ®æå·æ¥è®°å½' |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetByProductId ( |
|---|
| | | GlobalOTDTable parent, |
|---|
| | | const GlobalOTDTable parent, |
|---|
| | | String productId |
|---|
| | | ) as Global_MappingProviderCapacity |
|---|
| | | ) as const Global_MappingProviderCapacity |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Oct-10-2023 (created) |
|---|
| | | return select( parent, Global_MappingProviderCapacity, item, item.ProductID() = productId ); |
|---|
| | | value := select( parent, Global_MappingProviderCapacity, item, item.ProductID() = productId ) |
|---|
| | | return value; |
|---|
| | | *] |
|---|
| | | } |
|---|
| ¶Ô±ÈÐÂÎļþ |
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod GetByMatCode ( |
|---|
| | | const GlobalOTDSOP parent, |
|---|
| | | String matCode |
|---|
| | | ) as const MatAttrSettingAndPlanStrategy |
|---|
| | | { |
|---|
| | | Description: 'è·åæ æ³ä¿®æ¹ç' |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Oct-17-2023 (created) |
|---|
| | | value := select( parent, MatAttrSettingAndPlanStrategy, item, true, matCode = item.MatCode() ); |
|---|
| | | return value; |
|---|
| | | *] |
|---|
| | | } |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Method DoCall ( |
|---|
| | | GlobalOTDTable globalData, |
|---|
| | | const GlobalOTDTable globalData, |
|---|
| | | GlobalOTDSOP otdSop, |
|---|
| | | String callBy |
|---|
| | | ) as PRHistoryData |
|---|
| | | { |
|---|
| | |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-11-2023 (created) |
|---|
| | | result := globalData.PRHistoryData( relnew ); |
|---|
| | | result := otdSop.PRHistoryData( relnew ); |
|---|
| | | |
|---|
| | | // ç
§æ¬é¨å |
|---|
| | | result.AuthorizationStatus( this.AuthorizationStatus() ); |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | Method PrintCall ( |
|---|
| | | GlobalOTDTable globalData, |
|---|
| | | const GlobalOTDTable globalData, |
|---|
| | | GlobalOTDSOP otdSop, |
|---|
| | | String callBy |
|---|
| | | ) as String |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-11-2023 (created) |
|---|
| | | result := globalData.PRHistoryData( relnew ); |
|---|
| | | result := otdSop.PRHistoryData( relnew ); |
|---|
| | | |
|---|
| | | // ç
§æ¬é¨å |
|---|
| | | result.AuthorizationStatus( this.AuthorizationStatus() ); |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod DoCall ( |
|---|
| | | GlobalOTDTable globalData, |
|---|
| | | const GlobalOTDTable globalData, |
|---|
| | | GlobalOTDSOP otdSop, |
|---|
| | | PRDatas toCalls, |
|---|
| | | String callBy |
|---|
| | | ) |
|---|
| | |
|---|
| | | nowNo := 1; |
|---|
| | | traverse( toCalls, Elements, toCall, toCall.PRReleaseStatus() = "" ) { |
|---|
| | | info ( "DoCall " + [String]nowNo + "/" + [String]toCalls.Size() + " PR" ); |
|---|
| | | toCall.DoCall( globalData, callBy ); |
|---|
| | | toCall.DoCall( globalData, otdSop, callBy ); |
|---|
| | | nowNo := nowNo + 1; |
|---|
| | | } |
|---|
| | | *] |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod FromSupplyPlanning ( |
|---|
| | | GlobalOTDTable otdTable, |
|---|
| | | const GlobalOTDTable otdTable, |
|---|
| | | const GlobalOTDSOP otdSop, |
|---|
| | | MacroPlan macroPlan, |
|---|
| | | ProductInStockingPointInPeriod pispip, |
|---|
| | | String userId |
|---|
| | |
|---|
| | | mappingOperation := Global_MappingOperation::GetByProductId( otdTable, product.ID() ); |
|---|
| | | // QID15 |
|---|
| | | mappingProviderCapacity := Global_MappingProviderCapacity::GetByProductId( otdTable, product.ID() ); |
|---|
| | | matAttrSetting := null( MatAttrSettingAndPlanStrategy )/*MatAttrSettingAndPlanStrategy::GetExistByMatCode( otdTable, product.ID() )*/; |
|---|
| | | |
|---|
| | | // ç©ææ ç¾å±æ§ |
|---|
| | | matAttrSetting := MatAttrSettingAndPlanStrategy::GetByMatCode( otdSop, product.ID() ) |
|---|
| | | |
|---|
| | | // æ ¹æ®pispip |
|---|
| | | result.MRPCalverNo( ifexpr( pispip.MRPCalverNo() = "", "ææ ", pispip.MRPCalverNo() ) ); |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod FromSupplyPlanning ( |
|---|
| | | GlobalOTDTable otdTable, |
|---|
| | | const GlobalOTDTable otdTable, |
|---|
| | | const GlobalOTDSOP otdSop, |
|---|
| | | MacroPlan macroPlan, |
|---|
| | | String mrpCalverNo, |
|---|
| | | String userId |
|---|
| | |
|---|
| | | if( isnull( oldRecords ) or oldRecords.Size() = 0 ) { |
|---|
| | | pispips := ProductInStockingPointInPeriod::GetByMRPCalverNo( macroPlan, mrpCalverNo ); |
|---|
| | | traverse( pispips, Elements, item, item.NewSupplyQuantity() > 0 ) { |
|---|
| | | PRData::FromSupplyPlanning( otdTable, macroPlan, item, userId ); |
|---|
| | | PRData::FromSupplyPlanning( otdTable, otdSop, macroPlan, item, userId ); |
|---|
| | | nowNo := nowNo + 1; |
|---|
| | | if( nowNo mod 1000 = 0 ) { |
|---|
| | | info( "SupplyPlanning to prData : " + [String]nowNo ); |
|---|
| | |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-20-2023 (created) |
|---|
| | | result := this.GlobalOTDTable().PRHistoryData( relcopy, this ); |
|---|
| | | result := this.GlobalOTDSOP().PRHistoryData( relcopy, this ); |
|---|
| | | |
|---|
| | | // æ´æ°é¨å |
|---|
| | | result.PRDataReleaseDate( Date::Today() ); |
|---|
| | |
|---|
| | | TextBody: |
|---|
| | | [* |
|---|
| | | // yypsybs Sep-11-2023 (created) |
|---|
| | | result := this.GlobalOTDTable().PRHistoryData( relcopy, this ); |
|---|
| | | result := this.GlobalOTDSOP().PRHistoryData( relcopy, this ); |
|---|
| | | |
|---|
| | | // æ´æ°é¨å |
|---|
| | | result.PRDataReleaseDate( Date::Today() ); |
|---|
| | |
|---|
| | | Quintiq file version 2.0 |
|---|
| | | #parent: #root |
|---|
| | | StaticMethod Export ( |
|---|
| | | GlobalOTDTable parent |
|---|
| | | GlobalOTDSOP parent |
|---|
| | | ) as String |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | CustomerOrder customerOrder, |
|---|
| | | String businessType, |
|---|
| | | MacroPlan macroPlan, |
|---|
| | | GlobalOTDTable globalOTDTable |
|---|
| | | const GlobalOTDTable globalOTDTable |
|---|
| | | ) as Real |
|---|
| | | { |
|---|
| | | Description: '计ç®å
¬å¼ä¸æ¬å·å
çæ°æ®' |
|---|
| | |
|---|
| | | String businessType, |
|---|
| | | MacroPlan macroPlan, |
|---|
| | | Real lastScore, |
|---|
| | | GlobalOTDTable globalOTDTable |
|---|
| | | const GlobalOTDTable globalOTDTable |
|---|
| | | ) as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | CustomerOrder customerOrder, |
|---|
| | | String formula, |
|---|
| | | MacroPlan macroPlan, |
|---|
| | | GlobalOTDTable globalOTDTable |
|---|
| | | const GlobalOTDTable globalOTDTable |
|---|
| | | ) as Real |
|---|
| | | { |
|---|
| | | TextBody: |
|---|
| | |
|---|
| | | productIdsOver14Days := PRData::ProductIdOver14Days( selection ); |
|---|
| | | if( productIdsOver14Days <> "" ) { |
|---|
| | | if( WebMessageBox::Question( "该æ¹æ¬¡ä¸çç©æå·" + productIdsOver14Days + "订ååºè¯¥å¨2å¨åéæ¾ï¼è¯·ç¡®è®¤æ¯å¦ç°å¨éæ¾ï¼ï¼å·²éæ¾çå°è¢«è·³è¿ï¼" ) = 0 ) { |
|---|
| | | PRData::DoCall( GlobalOTDTable, selection, ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | PRData::DoCall( GlobalOTDTable, GlobalOTDSOP, selection, ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | } |
|---|
| | | } else if( WebMessageBox::Question( "æ¯å¦åééä¸çæ°æ®ï¼ï¼å·²éæ¾çå°è¢«è·³è¿ï¼" ) = 0 ) { |
|---|
| | | PRData::DoCall( GlobalOTDTable, selection, ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | PRData::DoCall( GlobalOTDTable, GlobalOTDSOP, selection, ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | } |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | |
|---|
| | | { |
|---|
| | | Body: |
|---|
| | | [* |
|---|
| | | info( selection.PrintCall( GlobalOTDTable, ApplicationMacroPlanner.GetUserName() ) ) |
|---|
| | | info( selection.PrintCall( GlobalOTDTable, GlobalOTDSOP, ApplicationMacroPlanner.GetUserName() ) ) |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | | } |
|---|
| | |
|---|
| | | Body: |
|---|
| | | [* |
|---|
| | | MacroPlan.PRData( relflush ); |
|---|
| | | PRData::FromSupplyPlanning( GlobalOTDTable, MacroPlan, "", ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | PRData::FromSupplyPlanning( GlobalOTDTable, GlobalOTDSOP, MacroPlan, "", ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | | } |
|---|
| | |
|---|
| | | productIdsOver14Days := PRData::ProductIdOver14Days( DataHolderChecked.Data() ); |
|---|
| | | if( productIdsOver14Days <> "" ) { |
|---|
| | | if( WebMessageBox::Question( "该æ¹æ¬¡ä¸çç©æå·" + productIdsOver14Days + "订ååºè¯¥å¨2å¨åéæ¾ï¼è¯·ç¡®è®¤æ¯å¦ç°å¨éæ¾ï¼ï¼å·²éæ¾çå°è¢«è·³è¿ï¼" ) = 0 ) { |
|---|
| | | PRData::DoCall( GlobalOTDTable, DataHolderChecked.Data(), ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | PRData::DoCall( GlobalOTDTable, GlobalOTDSOP, DataHolderChecked.Data(), ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | } |
|---|
| | | } else if( WebMessageBox::Question( "æ¯å¦åééä¸çæ°æ®ï¼ï¼å·²éæ¾çå°è¢«è·³è¿ï¼" ) = 0 ) { |
|---|
| | | PRData::DoCall( GlobalOTDTable, DataHolderChecked.Data(), ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | PRData::DoCall( GlobalOTDTable, GlobalOTDSOP, DataHolderChecked.Data(), ApplicationMacroPlanner.GetUserName() ); |
|---|
| | | } |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | |
|---|
| | | ] |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | Taborder: 3 |
|---|
| | | Taborder: 2 |
|---|
| | | ] |
|---|
| | | } |
|---|
| | |
|---|
| | | [* |
|---|
| | | GlobalOTDTable.InitTestDataByYear( MacroPlan, DataHolderCapacityAndSaleBudgeFilterYear.Data() ); |
|---|
| | | Global_MappingAnnualBudgetData::SetOrgCodeFromForecast( GlobalOTDTable ); |
|---|
| | | GlobalOTDTable.RefreshCapacityAndSaleBudgeFilter( true ); |
|---|
| | | CapacityAndSaleBudgeFilterItem::Initial( GlobalOTDTable ); |
|---|
| | | CapacityAndSaleBudgeFilterYear::Initial( GlobalOTDTable ); |
|---|
| | | CapacityAndSaleBudgeFilterMonth::Initial( GlobalOTDTable ); |
|---|
| | | GlobalOTDSOP::RefreshCapacityAndSaleBudgeFilter( true, GlobalOTDTable, GlobalOTDSOP ); |
|---|
| | | CapacityAndSaleBudgeFilterItem::Initial( GlobalOTDSOP ); |
|---|
| | | CapacityAndSaleBudgeFilterYear::Initial( GlobalOTDSOP ); |
|---|
| | | CapacityAndSaleBudgeFilterMonth::Initial( GlobalOTDSOP ); |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | | } |
|---|
| | |
|---|
| | | Taborder: 1 |
|---|
| | | ] |
|---|
| | | } |
|---|
| | | Component ButtonExportTest |
|---|
| | | { |
|---|
| | | #keys: '[414384.0.914711826]' |
|---|
| | | BaseType: 'WebButton' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | Image: 'EXPORT1' |
|---|
| | | Label: '导åºæµè¯' |
|---|
| | | Taborder: 2 |
|---|
| | | Visible: false |
|---|
| | | ] |
|---|
| | | } |
|---|
| | | Component ButtonGenerateTestData |
|---|
| | | { |
|---|
| | | #keys: '[414384.0.971540693]' |
|---|
| | |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | Image: 'IMPORT1' |
|---|
| | | Label: 'æ ¹æ®çéæ份çææµè¯æ°æ®' |
|---|
| | | Label: 'æ ¹æ®çé年份çææµè¯æ°æ®' |
|---|
| | | Taborder: 0 |
|---|
| | | ] |
|---|
| | | } |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeChartElement' |
|---|
| | | ] |
|---|
| | |
|---|
| | | [* |
|---|
| | | //CapacityAndSaleBudgeChartElement::TestData( GlobalOTDTable ); |
|---|
| | | |
|---|
| | | GlobalOTDTable.CapacityAndSaleBudgeChart( DataHolderMacroPlansForScenarioComparison.Data(), |
|---|
| | | DropDownSaleOrCapacity.Text(), |
|---|
| | | DropDownTimeGroup.Text(), |
|---|
| | | DropDownByBusinessTypeOrByOrgCode.Text(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterBusinessType.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterPlaceOfProductionOfArray.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterYear.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterMonth.Data(), |
|---|
| | | GlobalOTDTable ); |
|---|
| | | GlobalOTDSOP.CapacityAndSaleBudgeChart( DataHolderMacroPlansForScenarioComparison.Data(), |
|---|
| | | DropDownSaleOrCapacity.Text(), |
|---|
| | | DropDownTimeGroup.Text(), |
|---|
| | | DropDownByBusinessTypeOrByOrgCode.Text(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterBusinessType.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterPlaceOfProductionOfArray.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterYear.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterMonth.Data(), |
|---|
| | | GlobalOTDTable ); |
|---|
| | | *] |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeCompareItemColumn.CapacityAndSaleBudgeCompareItemCell' |
|---|
| | | ] |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeCompareItemRow' |
|---|
| | | ] |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeCompareItemColumn' |
|---|
| | | ] |
|---|
| | |
|---|
| | | info( DataHolderCapacityAndSaleBudgeFilterItem.Data().Size() ); |
|---|
| | | info( DataHolderCapacityAndSaleBudgeFilterYear.Data().Size() ); |
|---|
| | | info( DataHolderCapacityAndSaleBudgeFilterMonth.Data().Size() ); |
|---|
| | | GlobalOTDTable.CapacityAndSaleBudgeCompare( DataHolderMacroPlansForScenarioComparison.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterItem.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterYear.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterMonth.Data(), |
|---|
| | | GlobalOTDTable ); |
|---|
| | | GlobalOTDSOP.CapacityAndSaleBudgeCompare( DataHolderMacroPlansForScenarioComparison.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterItem.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterYear.Data(), |
|---|
| | | DataHolderCapacityAndSaleBudgeFilterMonth.Data(), |
|---|
| | | GlobalOTDTable ); |
|---|
| | | *] |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | { |
|---|
| | | Body: |
|---|
| | | [* |
|---|
| | | tableBinaryData := GlobalOTDTable.CapacityAndSaleBudgeCompareExport().AsBinaryData(); |
|---|
| | | Application.Download( "年度产éé¢ç®å¯¹æ¯.xlsx", tableBinaryData ); |
|---|
| | | Application.Download( "年度产éé¢ç®å¯¹æ¯.xlsx", GlobalOTDSOP.CapacityAndSaleBudgeCompareExport().AsBinaryData() ); |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | | } |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeFilterBusinessType' |
|---|
| | | ] |
|---|
| | |
|---|
| | | { |
|---|
| | | Body: |
|---|
| | | [* |
|---|
| | | GlobalOTDTable.RefreshCapacityAndSaleBudgeFilter( true ); |
|---|
| | | GlobalOTDSOP::RefreshCapacityAndSaleBudgeFilter( true, GlobalOTDTable, GlobalOTDSOP ); |
|---|
| | | *] |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeFilterItem' |
|---|
| | | ] |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeFilterMonth' |
|---|
| | | ] |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeFilterPlaceOfProductionOfArray' |
|---|
| | | ] |
|---|
| | |
|---|
| | | { |
|---|
| | | Body: |
|---|
| | | [* |
|---|
| | | GlobalOTDTable.RefreshCapacityAndSaleBudgeFilter( true ); |
|---|
| | | GlobalOTDSOP::RefreshCapacityAndSaleBudgeFilter( true, GlobalOTDTable, GlobalOTDSOP ); |
|---|
| | | *] |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'CapacityAndSaleBudgeFilterYear' |
|---|
| | | ] |
|---|
| | |
|---|
| | | BaseType: 'WebDataExtractor' |
|---|
| | | Properties: |
|---|
| | | [ |
|---|
| | | DataType: 'GlobalOTDTable' |
|---|
| | | Source: 'GlobalOTDTable' |
|---|
| | | DataType: 'GlobalOTDSOP' |
|---|
| | | Source: 'GlobalOTDSOP' |
|---|
| | | Taborder: 0 |
|---|
| | | Transformation: 'PRHistoryData' |
|---|
| | | ] |
|---|
| | |
|---|
| | | { |
|---|
| | | Body: |
|---|
| | | [* |
|---|
| | | Application.Download( "PRHistoryData.xlsx", PRHistoryData::Export( GlobalOTDTable ) ); |
|---|
| | | Application.Download( "PRHistoryData.xlsx", PRHistoryData::Export( GlobalOTDSOP ) ); |
|---|
| | | *] |
|---|
| | | GroupServerCalls: false |
|---|
| | | } |
|---|
