Merge branch 'dev' of http://47.101.211.7:10101/r/VWED into dev
已重命名18个文件
已复制1个文件
已修改38个文件
已添加81个文件
已删除30个文件
| | |
| | | Relation NewOfflinePlanTable_NewOfflinePlanColumn_NewOfflinePlanColumn_NewOfflinePlanTable |
| | | { |
| | | #keys: '1[413988.0.1603460118]' |
| | | DefaultRelationStrategy |
| | | DeclarativeSequenceRelationStrategy |
| | | { |
| | | #keys: '13[0.0.0][413988.0.1648701086][413988.0.1648701080][413988.0.1648701087][413988.0.1648701081][413988.0.1648701088][413988.0.1648701082][413988.0.1648701089][413988.0.1648701083][413988.0.1648701090][413988.0.1648701084][413988.0.1648701091][413988.0.1648701085]' |
| | | SequenceElementSuffix: 'NOPColumn' |
| | | SequenceSuffix: 'NOPColumn' |
| | | SortAttributes: |
| | | [ |
| | | DeclarativeSequenceRelationSortAttribute |
| | | { |
| | | #keys: '1[413988.0.1648701093]' |
| | | Attribute: 'StartDate' |
| | | } |
| | | ] |
| | | } |
| | | RelationSide.LeftSide NewOfflinePlanColumn |
| | | { |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute IsUpdate |
| | | { |
| | | #keys: '3[415136.0.1191950107][415136.0.1191950106][415136.0.1191950108]' |
| | | Description: 'æ¯å¦è¢«å¯¼å
¥æ´æ°' |
| | | ValueType: Boolean |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute IsUpdate |
| | | { |
| | | #keys: '3[415136.0.1191950111][415136.0.1191950110][415136.0.1191950112]' |
| | | Description: 'æ¯å¦è¢«å¯¼å
¥æ´æ°' |
| | | ValueType: Boolean |
| | | } |
| | |
| | | sumcell := sumrow.Initialize( column ); |
| | | } |
| | | //æ¾ç¤ºæåå
æ ¼ |
| | | showcell := showrow.Cell( relnew, RentInCost := cell.RentInCost(), RentOutOfCost := cell.RentOutOfCost(), WerkToRentTransCost := cell.WerkToRentTransCost(), RentStorCost := cell.RentStorCost() ); |
| | | showcell := showrow.Cell( relnew, RentInCost := cell.RentInCost(), RentOutOfCost := cell.RentOutOfCost(), WerkToRentTransCost := cell.WerkToRentTransCost(), RentStorCost := cell.RentStorCost(), CoefficientValue := cell.CoefficientValue() ); |
| | | column.Cell( relinsert, showcell ); |
| | | //æ¾ç¤ºå¹´åå
æ ¼ |
| | | yearcell.RentInCost( cell.RentInCost() + yearcell.RentInCost() ); |
| | |
| | | , DLRentInCost := cell.DLRentInCost() |
| | | , DLRentOutOfCost := cell.DLRentOutOfCost() |
| | | , WerkToDLRentTransCost := cell.WerkToDLRentTransCost() |
| | | , DLRentStorCost := cell.DLRentStorCost() ); |
| | | , DLRentStorCost := cell.DLRentStorCost() |
| | | , CoefficientValue := cell.CoefficientValue() ); |
| | | column.Cell( relinsert, showcell ); |
| | | //æ¾ç¤ºå¹´åå
æ ¼ |
| | | yearcell.CCRentInCost( cell.CCRentInCost() + yearcell.CCRentInCost() ); |
| | |
| | | [* |
| | | // çå
°é¸½ Jun-5-2024 (created) |
| | | feedback := ''; |
| | | if( [Number]number < 0 ){ |
| | | if( [Real]number < 0 ){ |
| | | feedback := Translations::MP_ChangeLossSettingExcel_Import_PositiveInteger(); |
| | | } |
| | | if( isnull( unit ) or isnull( product1 ) or isnull( product2 ) or [Number]number = 0 ){ |
| | | if( isnull( unit ) or isnull( product1 ) or isnull( product2 ) or [Real]number = 0 ){ |
| | | feedback := Translations::MP_ChangeLossSetting_CheckNull(); |
| | | } |
| | | if( product1 = product2 ){ |
| | |
| | | |
| | | traverse( cell, Demand, demand, exists( models, Elements, model, model = demand.Model() ) ){ |
| | | demandrow := selectobject( this, Row, r, r.Product() = row.Name() and r.Demand() = demand.Model() ); |
| | | sumdemandrow := selectobject( this, Row, r, r.Name() = sumname and r.Demand() = demand.Model() ); |
| | | sumdemandrow := selectobject( this, Row, r, r.Product() = sumname and r.Demand() = demand.Model() ); |
| | | |
| | | if( not isnull( demandrow ) ){ |
| | | demandcell := column.CellValue( relnew, Value := [String]demand.Quantity() ); |
| | |
| | | #parent: #root |
| | | Method Generate ( |
| | | FinancialProductionSearch search, |
| | | Product_MPs products |
| | | Factorys factorys, |
| | | Strings productids |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Jun-25-2024 (created) |
| | | table := selectobject( this, FinancialProductionSource.FinancialProductionReport, report, not report.IsShow() ); |
| | | allunit := '<All>'; |
| | | table := selectobject( this, FinancialProductionSource.FinancialProductionReport, report, not report.IsShow() ); |
| | | //æ¸
空ä¹ååå¨çæ¾ç¤ºæ°æ® |
| | | this.Clear(); |
| | | //å¹´æ±æ» |
| | | yearcolumn := this.FinancialProductionColumn( relnew, Name := 'æ±æ»', Period := search.MacroPlan().StartOfPlanning().StartOfNextYear().Date() ); |
| | | //è¿æ»¤åç产åid |
| | | productids := selectuniquevalues( products, Elements, product, ( search.Generation() = allunit or product.Generation() = search.Generation() ) |
| | | and ( search.MqbMlb() = allunit or product.MQBMLB() = search.MqbMlb() ) |
| | | and ( search.Power() = allunit or product.Power() = search.Power() ), product.ID() ); |
| | | sumrow := this.FinancialProductionRow( relnew, Name := 'SUM', Unit := search.Unit(), RowNr := table.FinancialProductionRow( relsize ) ); |
| | | sumyearcell := yearcolumn.FinancialProductionCell( relnew, Quantity := 0 ); |
| | | sumrow.FinancialProductionCell( relinsert, sumyearcell ); |
| | | traverse( table, FinancialProductionRow, row, row.Unit() = search.Unit() ){ |
| | | productid := construct( Strings ); |
| | | productid.Add( row.Name() ); |
| | | |
| | | if( productids.ContainsAll( productid ) ){ |
| | | showrow := this.FinancialProductionRow( relnew, Name := row.Name(), Unit := row.Unit(), RowNr := row.RowNr() ); |
| | | yearcell := yearcolumn.FinancialProductionCell( relnew, Quantity := 0 ); |
| | | showrow.FinancialProductionCell( relinsert, yearcell ); |
| | | |
| | | traverse( row, FinancialProductionCell, cell, not cell.FinancialProductionColumn().IsDay() ){ |
| | | column := selectobject( this, FinancialProductionColumn, column, column.Name() = cell.FinancialProductionColumn().Name() and not column.IsDay() ); |
| | | |
| | | sumcell := selectobject( column, FinancialProductionCell, c, c.FinancialProductionRow() = sumrow ); |
| | | if( isnull( sumcell ) ){ |
| | | sumcell := column.FinancialProductionCell( relnew, Quantity := 0 ); |
| | | sumrow.FinancialProductionCell( relinsert, sumcell ); |
| | | } |
| | | |
| | | showcell := column.FinancialProductionCell( relnew, Quantity := cell.Quantity() ); |
| | | showrow.FinancialProductionCell( relinsert, showcell ); |
| | | yearcell.Quantity( yearcell.Quantity() + cell.Quantity() ); |
| | | sumyearcell.Quantity( sumyearcell.Quantity() + cell.Quantity() ); |
| | | // value := [Real]cell.Value() + [Real]sumcell.Value(); |
| | | sumcell.Quantity( sumcell.Quantity() + cell.Quantity() ); |
| | | } |
| | | } |
| | | traverse( factorys, Elements, factory ){ |
| | | this.GenerateShow( table, productids, factory.ID() ); |
| | | } |
| | | |
| | | traverse( this, FinancialProductionRow, row ){ |
| | | traverse( row, FinancialProductionCell, cell ){ |
| | | rows := selectsortedset( this, FinancialProductionRow, row, row.Name() ); |
| | | i := 0; |
| | | traverse( rows, Elements, e ){ |
| | | e.RowNr( i ); |
| | | traverse( e, FinancialProductionCell, cell ){ |
| | | cell.Value( [String]([Number]cell.Quantity()) ); |
| | | } |
| | | i := i + 1; |
| | | } |
| | | *] |
| | | } |
| | |
| | | startofyear := startofplanning.StartOfYear(); |
| | | startofnextyear := startofplanning.StartOfNextYear(); |
| | | |
| | | //for( start := startofyear; start < startofnextyear; start := start.StartOfNextMonth() ){ |
| | | // periodtime := start.Date(); |
| | | // periodname := periodtime.Format( "M2/D2/Y" ); |
| | | // this.FinancialProductionColumn( relnew, Name := periodname, Period := periodtime ); |
| | | //} |
| | | for( start := startofyear; start < startofnextyear; start := start + Duration::Days( 1 ) ){ |
| | | periodtime := start.Date(); |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method GenerateShow ( |
| | | FinancialProductionReport table, |
| | | Strings productids, |
| | | String factory |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Oct-12-2024 (created) |
| | | //å¹´æ±æ» |
| | | yearcolumn := this.FinancialProductionColumn( relnew, Name := 'æ±æ»', Period := this.FinancialProductionSource().MacroPlan().StartOfPlanning().StartOfNextYear().Date() ); |
| | | sumrow := this.FinancialProductionRow( relnew, Name := factory.Format( 'S(Len(10))' ).Concat( 'SUM' ), Unit := factory ); |
| | | sumyearcell := yearcolumn.FinancialProductionCell( relnew, Quantity := 0 ); |
| | | sumrow.FinancialProductionCell( relinsert, sumyearcell ); |
| | | traverse( table, FinancialProductionRow, row, row.Unit() = factory ){ |
| | | productid := construct( Strings ); |
| | | productid.Add( row.Name() ); |
| | | |
| | | if( productids.ContainsAll( productid ) ){ |
| | | showrow := this.FinancialProductionRow( relnew, Name := factory.Format( 'S(Len(10))' ).Concat( row.Name() ), Unit := row.Unit() ); |
| | | yearcell := yearcolumn.FinancialProductionCell( relnew, Quantity := 0 ); |
| | | showrow.FinancialProductionCell( relinsert, yearcell ); |
| | | traverse( row, FinancialProductionCell, cell, not cell.FinancialProductionColumn().IsDay() ){ |
| | | column := selectobject( this, FinancialProductionColumn, column, column.Name() = cell.FinancialProductionColumn().Name() and not column.IsDay() ); |
| | | |
| | | sumcell := selectobject( column, FinancialProductionCell, c, c.FinancialProductionRow() = sumrow ); |
| | | if( isnull( sumcell ) ){ |
| | | sumcell := column.FinancialProductionCell( relnew, Quantity := 0 ); |
| | | sumrow.FinancialProductionCell( relinsert, sumcell ); |
| | | } |
| | | |
| | | showcell := column.FinancialProductionCell( relnew, Quantity := cell.Quantity() ); |
| | | showrow.FinancialProductionCell( relinsert, showcell ); |
| | | yearcell.Quantity( yearcell.Quantity() + cell.Quantity() ); |
| | | sumyearcell.Quantity( sumyearcell.Quantity() + cell.Quantity() ); |
| | | sumcell.Quantity( sumcell.Quantity() + cell.Quantity() ); |
| | | } |
| | | } |
| | | } |
| | | *] |
| | | } |
| | |
| | | allunit := FinancialProductionReport::GetDefaultAllUnit(); |
| | | //æ¥è¯¢éè¦å¯¼å
¥çæ¥è¡¨ |
| | | table := selectobject( this.MacroPlan(), FinancialProductionSource.FinancialProductionReport, table, not table.IsImport() and not table.IsShow() ); |
| | | yearday := this.MacroPlan().StartOfPlanning().StartOfYear(); |
| | | beforeyearday := ( yearday - Duration::Days( 1 ) ).Date(); |
| | | cnv2 := StringToDate::StandardConverter(); |
| | | cnv2.SetCustomConversion(); |
| | | cnv2.CustomFormatString( "M2/D2/Y" ); |
| | |
| | | |
| | | //è¯»åæ¯ä¸è¡çåå
æ ¼ |
| | | traverse( row, FinancialProductionCell, cell, cell.FinancialProductionColumn() <> productcolumn and cell.FinancialProductionColumn() <> unitcolumn ){ |
| | | //è·å被导å
¥æ¥è¡¨çæ¥æå |
| | | tablecolumn := selectobject( table, FinancialProductionColumn, column, not column.IsDay() and column.Name() = cell.FinancialProductionColumn().Name() ); |
| | | if( isnull( tablecolumn ) ){ |
| | | tablecolumn := table.FinancialProductionColumn( relnew, Name := cell.FinancialProductionColumn().Name(), Period := cnv2.Convert( cell.FinancialProductionColumn().Name() ) ); |
| | | period := cnv2.Convert( cell.FinancialProductionColumn().Name() ) |
| | | tablecolumn := construct( FinancialProductionColumn ); |
| | | if( period = beforeyearday ){ |
| | | periodname := yearday.Format( "M2/D2/Y" ); |
| | | //è·å被导å
¥æ¥è¡¨çæ¥æå |
| | | tablecolumn := selectobject( table, FinancialProductionColumn, column, not column.IsDay() and column.Name() = periodname ); |
| | | if( isnull( tablecolumn ) ){ |
| | | tablecolumn := table.FinancialProductionColumn( relnew, Name := periodname, Period := yearday.Date() ); |
| | | } |
| | | }else{ |
| | | tablecolumn := selectobject( table, FinancialProductionColumn, column, not column.IsDay() and column.Name() = cell.FinancialProductionColumn().Name() ); |
| | | if( isnull( tablecolumn ) ){ |
| | | tablecolumn := table.FinancialProductionColumn( relnew, Name := cell.FinancialProductionColumn().Name(), Period := cnv2.Convert( cell.FinancialProductionColumn().Name() ) ); |
| | | } |
| | | } |
| | | //è·å被导å
¥æ¥è¡¨çåå
æ ¼ |
| | | unitcell := selectobject( unitrow, FinancialProductionCell, unitcell, unitcell.FinancialProductionColumn() = tablecolumn ); |
| | | if( isnull( unitcell ) ){ |
| | | unitcell := tablecolumn.FinancialProductionCell( relnew, IsUpdate := true, Quantity := [Real]cell.Value(), Value := cell.Value() ); |
| | | unitcell := tablecolumn.FinancialProductionCell( relnew, Quantity := [Real]cell.Value(), Value := cell.Value() ); |
| | | unitrow.FinancialProductionCell( relinsert, unitcell ); |
| | | }else{ |
| | | if( unitcell.Quantity() <> [Real]cell.Value() ){ |
| | |
| | | table := source.FinancialProductionReport( relnew, ID := source.Name(), Name := source.Name(), IsImport := false ); |
| | | showtable := source.FinancialProductionReport( relnew, ID := source.Name() + 'Show', Name := source.Name(), IsImport := false, IsShow := true ); |
| | | startofplanning := owner.StartOfPlanning().Date(); |
| | | startofyear := ( startofplanning.StartOfYear() - Duration::Days( 1 ) ).Date(); |
| | | startofnextyear := ( startofplanning.StartOfNextYear() - Duration::Days( 1 ) ).Date(); |
| | | //startofyear := startofplanning.StartOfYear(); |
| | | startofnextyear := startofplanning.StartOfNextYear(); |
| | | |
| | | search := owner.FinancialProductionSearch( relnew, Unit := allunit, Generation := allunit, MqbMlb := allunit, Power := allunit ); |
| | | |
| | | products := construct( Product_MPs ); |
| | | productids := construct( Strings ); |
| | | table.GenerateColumn( owner ); |
| | | //åå½åçæ¬çproduct planningénew supplyåæ®µï¼å大è¿åé¿æ¥å·¥åç产线ï¼è¿è¡å æ» |
| | | traverse( owner, StockingPoint_MP, stockingpoint, stockingpoint.ID().EndsWith( 'åå
åº' ) or stockingpoint.ID() = '大è¿å¤ç§åº' ){ |
| | |
| | | |
| | | if( iscc or isdl ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, pispip.Period_MP().StartDate() >= startofyear and pispip.Period_MP().StartDate() < startofnextyear and pispip.NewSupplyQuantity() <> 0 ) ){ |
| | | 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() ); |
| | | productids.Add( pisp.ProductID() ); |
| | | //å½product planningçæ¥æåºé´å¨éè¦çæ¥æåºé´å
|
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, pispip.Period_MP().StartDate() >= startofyear and pispip.Period_MP().StartDate() < startofnextyear and pispip.NewSupplyQuantity() <> 0 ){ |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear and pispip.NewSupplyQuantity() <> 0 ){ |
| | | dayperiodtime := ( pispip.Start() + Duration::Days( 1 ) ).Date(); |
| | | dayperiodname := dayperiodtime.Format( "M2/D2/Y" ); |
| | | periodtime := dayperiodtime.StartOfMonth(); |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | rows := selectsortedset( table, FinancialProductionRow, row, row.Name() ); |
| | | i := 0; |
| | | traverse( rows, Elements, e ){ |
| | | e.RowNr( i ); |
| | | i := i + 1; |
| | | } |
| | | showtable.Generate( search, products ); |
| | | factorys := selectset( owner, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | showtable.Generate( search, factorys, productids ); |
| | | *] |
| | | } |
| | |
| | | } |
| | | table := selectobject( owner, FinancialProductionSource.FinancialProductionReport, table, table.IsShow() ); |
| | | if( not isnull( table ) ){ |
| | | products := selectset( owner, Product_MP, product, true ); |
| | | table.Generate( search, products ); |
| | | factorys := selectset( owner, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | productids := selectuniquevalues( owner, FinancialProductionSource.FinancialProductionReport.FinancialProductionRow, row, not row.FinancialProductionReport().IsShow(), row.Name() ); |
| | | table.Generate( search, factorys, productids); |
| | | } |
| | | return table; |
| | | *] |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute IsUpdate |
| | | { |
| | | #keys: '3[415136.0.1191964789][415136.0.1191964788][415136.0.1191964790]' |
| | | Description: 'æ¯å¦è¢«æ´æ°' |
| | | ValueType: Boolean |
| | | } |
| | |
| | | #parent: #root |
| | | Method Generate ( |
| | | FinancialSalesSearch search, |
| | | Product_MPs products |
| | | Factorys factorys, |
| | | Strings productids |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Jun-25-2024 (created) |
| | | table := selectobject( this, FinancialSalesSource.FinancialSalesReport, report, not report.IsShow() ); |
| | | allunit := '<All>'; |
| | | //æ¸
空ä¹ååå¨çæ¾ç¤ºæ°æ® |
| | | this.Clear(); |
| | | //å¹´æ±æ» |
| | | yearcolumn := this.FinancialSalesColumn( relnew, Name := 'æ±æ»', Period := search.MacroPlan().StartOfPlanning().StartOfNextYear().Date() ); |
| | | //è¿æ»¤åç产åid |
| | | productids := selectuniquevalues( products, Elements, product, ( search.Generation() = allunit or product.Generation() = search.Generation() ) |
| | | and ( search.MqbMlb() = allunit or product.MQBMLB() = search.MqbMlb() ) |
| | | and ( search.Power() = allunit or product.Power() = search.Power() ), product.ID() ); |
| | | sumrow := this.FinancialSalesRow( relnew, Name := 'SUM', Unit := search.Unit(), RowNr := table.FinancialSalesRow( relsize ) ); |
| | | sumyearcell := yearcolumn.FinancialSalesCell( relnew, Value := '0' ); |
| | | sumrow.FinancialSalesCell( relinsert, sumyearcell ); |
| | | traverse( table, FinancialSalesRow, row, row.Unit() = search.Unit() ){ |
| | | productid := construct( Strings ); |
| | | productid.Add( row.Name() ); |
| | | |
| | | if( productids.ContainsAll( productid ) ){ |
| | | showrow := this.FinancialSalesRow( relnew, Name := row.Name(), Unit := row.Unit(), RowNr := row.RowNr() ); |
| | | yearcell := yearcolumn.FinancialSalesCell( relnew, Value := '0' ); |
| | | showrow.FinancialSalesCell( relinsert, yearcell ); |
| | | |
| | | traverse( row, FinancialSalesCell, cell, not cell.FinancialSalesColumn().IsDay() ){ |
| | | column := selectobject( this, FinancialSalesColumn, column, column.Name() = cell.FinancialSalesColumn().Name() and not column.IsDay()); |
| | | |
| | | sumcell := selectobject( column, FinancialSalesCell, c, c.FinancialSalesRow() = sumrow ); |
| | | if( isnull( sumcell ) ){ |
| | | sumcell := column.FinancialSalesCell( relnew, Value := '0' ); |
| | | sumrow.FinancialSalesCell( relinsert, sumcell ); |
| | | } |
| | | |
| | | showcell := column.FinancialSalesCell( relnew, Value := cell.Value() ); |
| | | showrow.FinancialSalesCell( relinsert, showcell ); |
| | | yearcell.Value( [String]( [Real]yearcell.Value() + [Real]cell.Value() ) ); |
| | | sumyearcell.Value( [String]( [Real]sumyearcell.Value() + [Real]cell.Value() ) ); |
| | | value := [Real]cell.Value() + [Real]sumcell.Value(); |
| | | sumcell.Value( [String]value ); |
| | | } |
| | | } |
| | | traverse( factorys, Elements, factory ){ |
| | | this.GenerateShow( table, productids, factory.ID() ); |
| | | } |
| | | rows := selectsortedset( this, FinancialSalesRow, row, row.Name() ); |
| | | i := 0; |
| | | traverse( rows, Elements, e ){ |
| | | e.RowNr( i ); |
| | | i := i + 1; |
| | | } |
| | | *] |
| | | } |
| | |
| | | startofyear := startofplanning.StartOfYear(); |
| | | startofnextyear := startofplanning.StartOfNextYear(); |
| | | |
| | | //for( start := startofyear; start < startofnextyear; start := start.StartOfNextMonth() ){ |
| | | // periodtime := start.Date(); |
| | | // periodname := periodtime.Format( "M2/D2/Y" ); |
| | | // this.FinancialSalesColumn( relnew, Name := periodname, Period := periodtime ); |
| | | //} |
| | | for( start := startofyear; start < startofnextyear; start := start + Duration::Days( 1 ) ){ |
| | | periodtime := start.Date(); |
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method GenerateShow ( |
| | | FinancialSalesReport table, |
| | | Strings productids, |
| | | String factory |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Oct-12-2024 (created) |
| | | //å¹´æ±æ» |
| | | yearcolumn := this.FinancialSalesColumn( relnew, Name := 'æ±æ»', Period := this.FinancialSalesSource().MacroPlan().StartOfPlanning().StartOfNextYear().Date() ); |
| | | sumrow := this.FinancialSalesRow( relnew, Name := factory.Format( 'S(Len(10))' ).Concat( 'SUM' ), Unit := factory, RowNr := table.FinancialSalesRow( relsize ) ); |
| | | sumyearcell := yearcolumn.FinancialSalesCell( relnew, Value := '0' ); |
| | | sumrow.FinancialSalesCell( relinsert, sumyearcell ); |
| | | traverse( table, FinancialSalesRow, row, row.Unit() = factory ){ |
| | | productid := construct( Strings ); |
| | | productid.Add( row.Name() ); |
| | | |
| | | if( productids.ContainsAll( productid ) ){ |
| | | showrow := this.FinancialSalesRow( relnew, Name := factory.Format( 'S(Len(10))' ).Concat( row.Name() ), Unit := row.Unit(), RowNr := row.RowNr() ); |
| | | yearcell := yearcolumn.FinancialSalesCell( relnew, Value := '0' ); |
| | | showrow.FinancialSalesCell( relinsert, yearcell ); |
| | | |
| | | traverse( row, FinancialSalesCell, cell, not cell.FinancialSalesColumn().IsDay() ){ |
| | | column := selectobject( this, FinancialSalesColumn, column, column.Name() = cell.FinancialSalesColumn().Name() and not column.IsDay()); |
| | | |
| | | sumcell := selectobject( column, FinancialSalesCell, c, c.FinancialSalesRow() = sumrow ); |
| | | if( isnull( sumcell ) ){ |
| | | sumcell := column.FinancialSalesCell( relnew, Value := '0' ); |
| | | sumrow.FinancialSalesCell( relinsert, sumcell ); |
| | | } |
| | | |
| | | showcell := column.FinancialSalesCell( relnew, Value := cell.Value() ); |
| | | showrow.FinancialSalesCell( relinsert, showcell ); |
| | | yearcell.Value( [String]( [Real]yearcell.Value() + [Real]cell.Value() ) ); |
| | | sumyearcell.Value( [String]( [Real]sumyearcell.Value() + [Real]cell.Value() ) ); |
| | | value := [Real]cell.Value() + [Real]sumcell.Value(); |
| | | sumcell.Value( [String]value ); |
| | | } |
| | | } |
| | | } |
| | | *] |
| | | } |
| | |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Jun-24-2024 (created) |
| | | allunit := FinancialProductionReport::GetDefaultAllUnit(); |
| | | table := selectobject( this.MacroPlan(), FinancialSalesSource.FinancialSalesReport, table, not table.IsImport() and not table.IsShow() ); |
| | | //info( '--------------------------', table.Name() ); |
| | | allunit := FinancialProductionReport::GetDefaultAllUnit(); |
| | | table := selectobject( this.MacroPlan(), FinancialSalesSource.FinancialSalesReport, table, not table.IsImport() and not table.IsShow() ); |
| | | yearday := this.MacroPlan().StartOfPlanning().StartOfYear(); |
| | | beforeyearday := ( yearday - Duration::Days( 1 ) ).Date(); |
| | | cnv2 := StringToDate::StandardConverter(); |
| | | cnv2.SetCustomConversion(); |
| | | cnv2.CustomFormatString( "M2/D2/Y" ); |
| | | traverse( this, FinancialSalesReport, report ){ |
| | | productcolumn := selectobject( report, FinancialSalesColumn, column, column.Name() = 'Product' ); |
| | | unitcolumn := selectobject( report, FinancialSalesColumn, column, column.Name() = 'Unit' ); |
| | | // info( '----------------------1-----------------', productcolumn.Name(), unitcolumn.Name() ); |
| | | productcolumn := selectobject( report, FinancialSalesColumn, column, column.Name() = 'Product' ); |
| | | unitcolumn := selectobject( report, FinancialSalesColumn, column, column.Name() = 'Unit' ); |
| | | |
| | | traverse( report, FinancialSalesRow, row ){ |
| | | product := selectobject( row, FinancialSalesCell, cell, cell.FinancialSalesColumn() = productcolumn ); |
| | | unit := selectobject( row, FinancialSalesCell, cell, cell.FinancialSalesColumn() = unitcolumn ); |
| | | // info( '----------------------2-----------------', product.Value(), unit.Value() ); |
| | | product := selectobject( row, FinancialSalesCell, cell, cell.FinancialSalesColumn() = productcolumn ); |
| | | unit := selectobject( row, FinancialSalesCell, cell, cell.FinancialSalesColumn() = unitcolumn ); |
| | | |
| | | unitrow := selectobject( table, FinancialSalesRow, unitrow, unitrow.Name() = product.Value() and unitrow.Unit() = unit.Value() ); |
| | | unitrow := selectobject( table, FinancialSalesRow, unitrow, unitrow.Name() = product.Value() and unitrow.Unit() = unit.Value() ); |
| | | if( isnull( unitrow ) ){ |
| | | unitrow := table.FinancialSalesRow( relnew, Name := product.Value(), Unit := unit.Value() ); |
| | | } |
| | | allrow := selectobject( table, FinancialSalesRow, allrow, allrow.Name() = product.Value() and allrow.Unit() = allunit ); |
| | | // info( '----------------------3-----------------', unitrow.Name(), unitrow.Unit() ); |
| | | // and product.Value() = '120 kW Rotor' and unit.Value() = 'Assembly Plant (Spain)' |
| | | if( isnull( unitrow ) ){ |
| | | allrow := table.FinancialSalesRow( relnew, Name := product.Value(), Unit := allunit ); |
| | | } |
| | | |
| | | traverse( row, FinancialSalesCell, cell, cell.FinancialSalesColumn() <> productcolumn and cell.FinancialSalesColumn() <> unitcolumn ){ |
| | | column := cell.FinancialSalesColumn(); |
| | | unitcell := selectobject( unitrow, FinancialSalesCell, unitcell, unitcell.FinancialSalesColumn().Name() = column.Name() ); |
| | | allcell := selectobject( allrow, FinancialSalesCell, allcell, allcell.FinancialSalesColumn().Name() = column.Name() ); |
| | | // info( isnull( unitcell ), isnull( allcell ), cell.Value(), unitcell.Value(), allcell.Value() ); |
| | | if( not isnull( unitcell ) ){ |
| | | unitcell.Value( cell.Value() ); |
| | | column := cell.FinancialSalesColumn(); |
| | | period := cnv2.Convert( column.Name() ) |
| | | |
| | | tablecolumn := construct( FinancialSalesColumn ); |
| | | if( period = beforeyearday ){ |
| | | periodname := yearday.Format( "M2/D2/Y" ); |
| | | //è·å被导å
¥æ¥è¡¨çæ¥æå |
| | | tablecolumn := selectobject( table, FinancialSalesColumn, fscolumn, not fscolumn.IsDay() and fscolumn.Name() = periodname ); |
| | | if( isnull( tablecolumn ) ){ |
| | | tablecolumn := table.FinancialSalesColumn( relnew, Name := periodname, Period := yearday.Date() ); |
| | | } |
| | | }else{ |
| | | tablecolumn := selectobject( table, FinancialSalesColumn, fscolumn, not fscolumn.IsDay() and fscolumn.Name() = column.Name() ); |
| | | if( isnull( tablecolumn ) ){ |
| | | tablecolumn := table.FinancialSalesColumn( relnew, Name := column.Name(), Period := cnv2.Convert( column.Name() ) ); |
| | | } |
| | | } |
| | | if( not isnull( allcell ) ){ |
| | | value := [Real]cell.Value() + [Real]allcell.Value(); |
| | | allcell.Value( [String]value ); |
| | | unitcell := selectobject( unitrow, FinancialSalesCell, unitcell, unitcell.FinancialSalesColumn().Name() = column.Name() ); |
| | | if( isnull( unitcell ) ){ |
| | | unitcell := tablecolumn.FinancialSalesCell( relnew, Value := cell.Value() ); |
| | | unitrow.FinancialSalesCell( relinsert, unitcell ); |
| | | }else{ |
| | | if( unitcell.Value() <> cell.Value() ){ |
| | | unitcell.Value( cell.Value() ); |
| | | unitcell.IsUpdate( true ); |
| | | } |
| | | } |
| | | allcell := selectobject( allrow, FinancialSalesCell, allcell, allcell.FinancialSalesColumn().Name() = column.Name() ); |
| | | if( isnull( unitcell ) ){ |
| | | allcell := tablecolumn.FinancialSalesCell( relnew, Value := cell.Value() ); |
| | | allrow.FinancialSalesCell( relinsert, allcell ); |
| | | }else{ |
| | | if( allcell.Value() <> cell.Value() ){ |
| | | allcell.Value( cell.Value() ); |
| | | allcell.IsUpdate( true ); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | // çå
°é¸½ Jun-24-2024 (created) |
| | | owner.FinancialSalesSource( relflush ); |
| | | owner.FSImportData( relflush ); |
| | | products := construct( Product_MPs ); |
| | | productids := construct( Strings ); |
| | | allunit := FinancialSalesReport::GetDefaultAllUnit(); |
| | | ccunit := FinancialSalesReport::GetDefaultCCUnit(); |
| | | dlunit := FinancialSalesReport::GetDefaultDLUnit(); |
| | | ccsalessegment := FinancialSalesReport::GetSalesSegmentCC(); |
| | | tjsalessegment := FinancialSalesReport::GetSalesSegmentTJ(); |
| | | fssalessegment := FinancialSalesReport::GetSalesSegmentFS(); |
| | | //ccspline := FinancialSalesReport::GetStockingPointCCLine(); |
| | | //dlspline := FinancialSalesReport::GetStockingPointDLLine(); |
| | | //ccrent := FinancialSalesReport::GetStockingPointCCRent(); |
| | | |
| | | source := owner.FinancialSalesSource( relnew, IsImport := false, Name := FinancialSalesReport::GetDefaultName() ); |
| | | table := source.FinancialSalesReport( relnew, ID := source.Name(), Name := source.Name(), IsImport := false ); |
| | | showtable := source.FinancialSalesReport( relnew, ID := source.Name() + 'Show', Name := source.Name(), IsImport := false, IsShow := true ); |
| | | startofplanning := owner.StartOfPlanning().Date(); |
| | | startofyear := ( startofplanning.StartOfYear() - Duration::Days( 1 ) ).Date(); |
| | | startofnextyear := ( startofplanning.StartOfNextYear() - Duration::Days( 1 ) ).Date(); |
| | | //startofyear := startofplanning.StartOfYear(); |
| | | startofnextyear := startofplanning.StartOfNextYear(); |
| | | |
| | | search := owner.FinancialSalesSearch( relnew, Unit := allunit, Generation := allunit, MqbMlb := allunit, Power := allunit ); |
| | | |
| | |
| | | //è·åå·¥åè¡ |
| | | factoryrow := table.GetRow( ifexpr( isdl, dlunit, ccunit ), product ); |
| | | |
| | | products.Add( product ); |
| | | productids.Add( forecast.ProductID() ); |
| | | traverse( forecast, PlanningSalesDemandInPeriod, psdip, psdip.Quantity() <> 0 ){ |
| | | dayperiodtime := psdip.StartDate(); |
| | | dayperiodname := dayperiodtime.Format( "M2/D2/Y" ); |
| | |
| | | //ä»Product planningæ¥æ¾åºåç¹ä¸ºå¤§è¿å卿ºçé¿æ¥å¤ç§åºï¼åNew supplyåæ®µæææ±æ»éæ±æ°é |
| | | traverse( owner, StockingPoint_MP, stockingpoint, stockingpoint.ID() = '大è¿å卿ºçé¿æ¥å¤ç§åº' ){ |
| | | traverse( stockingpoint, ProductInStockingPoint_MP, pisp, pisp.Product_MP().IsLeaf() |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, pispip.Period_MP().StartDate() >= startofyear and pispip.Period_MP().StartDate() < startofnextyear |
| | | and exists( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear |
| | | and ( pispip.DependentDemandAndSalesDemandQuantity() <> 0 or pispip.NewSupplyQuantity() <> 0 ) ) ){//产å为MQB |
| | | product := pisp.Product_MP(); |
| | | allrow := table.GetRow( allunit, product ); |
| | | factoryrow := table.GetRow( dlunit, product ); |
| | | products.Add( product ); |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, pispip.Period_MP().StartDate() >= startofyear |
| | | productids.Add( pisp.ProductID() ); |
| | | traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() |
| | | and pispip.Period_MP().StartDate() < startofnextyear |
| | | and ( pispip.DependentDemandAndSalesDemandQuantity() <> 0 or pispip.NewSupplyQuantity() <> 0 ) ){ |
| | | dayperiodtime := ( pispip.Start() + Duration::Days( 1 ) ).Date(); |
| | |
| | | // } |
| | | // } |
| | | //} |
| | | |
| | | rows := selectsortedset( table, FinancialSalesRow, row, row.Name() ); |
| | | i := 0; |
| | | traverse( rows, Elements, e ){ |
| | | e.RowNr( i ); |
| | | i := i + 1; |
| | | } |
| | | showtable.Generate( search, products ); |
| | | factorys := selectset( owner, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | showtable.Generate( search, factorys, productids ); |
| | | *] |
| | | } |
| | |
| | | } |
| | | table := selectobject( owner, FinancialSalesSource.FinancialSalesReport, table, table.IsShow() ); |
| | | if( not isnull( table ) ){ |
| | | products := selectset( owner, Product_MP, product, true ); |
| | | table.Generate( search, products ); |
| | | factorys := selectset( owner, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | productids := selectuniquevalues( owner, FinancialSalesSource.FinancialSalesReport.FinancialSalesRow, row, not row.FinancialSalesReport().IsShow(), row.Name() ); |
| | | table.Generate( search, factorys, productids ); |
| | | } |
| | | return table; |
| | | *] |
| | |
| | | ccsvaluesum := ccsvaluesum + ccsvalue; |
| | | } |
| | | sumcolumn := table.FinancialWeeklyColumn( relnew, Name := 'SUM' ); |
| | | cumulantcolumn := table.FinancialWeeklyColumn( relnew, Name := '累计é' ); |
| | | //cumulantcolumn := table.FinancialWeeklyColumn( relnew, Name := '累计é' ); |
| | | proportioncolumn := table.FinancialWeeklyColumn( relnew, Name := 'å æ¯' ); |
| | | //SUM |
| | | totalpcellsum := sumcolumn.FinancialWeeklyCell( relnew, Value := [String]( [Number]totalpvaluesum ) ); |
| | |
| | | ccscellsum := sumcolumn.FinancialWeeklyCell( relnew, Value := [String]ccsvaluesum ); |
| | | ccsales.FinancialWeeklyCell( relinsert, ccscellsum ); |
| | | //累计é |
| | | totalpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalpvaluecumulant ); |
| | | totalproduction.FinancialWeeklyCell( relinsert, totalpcellcumulant ); |
| | | dlpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlpvaluecumulant ); |
| | | dlproduction.FinancialWeeklyCell( relinsert, dlpcellcumulant ); |
| | | ccpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccpvaluecumulant ); |
| | | ccproduction.FinancialWeeklyCell( relinsert, ccpcellcumulant ); |
| | | totalscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalsvaluecumulant ); |
| | | totalsales.FinancialWeeklyCell( relinsert, totalscellcumulant ); |
| | | dlscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlsvaluecumulant ); |
| | | dlsales.FinancialWeeklyCell( relinsert, dlscellcumulant ); |
| | | ccscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccsvaluecumulant ); |
| | | ccsales.FinancialWeeklyCell( relinsert, ccscellcumulant ); |
| | | //totalpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalpvaluecumulant ); |
| | | //totalproduction.FinancialWeeklyCell( relinsert, totalpcellcumulant ); |
| | | //dlpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlpvaluecumulant ); |
| | | //dlproduction.FinancialWeeklyCell( relinsert, dlpcellcumulant ); |
| | | //ccpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccpvaluecumulant ); |
| | | //ccproduction.FinancialWeeklyCell( relinsert, ccpcellcumulant ); |
| | | //totalscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalsvaluecumulant ); |
| | | //totalsales.FinancialWeeklyCell( relinsert, totalscellcumulant ); |
| | | //dlscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlsvaluecumulant ); |
| | | //dlsales.FinancialWeeklyCell( relinsert, dlscellcumulant ); |
| | | //ccscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccsvaluecumulant ); |
| | | //ccsales.FinancialWeeklyCell( relinsert, ccscellcumulant ); |
| | | //å æ¯ |
| | | totalpvalueproportion := guard( ( totalpvaluecumulant / totalpvaluesum ).Format( 'N(Dec(2))' ), '0.00' ); |
| | | totalpcellproportion := proportioncolumn.FinancialWeeklyCell( relnew, Value := totalpvalueproportion ); |
| | |
| | | ccscellproportion := proportioncolumn.FinancialWeeklyCell( relnew, Value := ccsvalueproportion ); |
| | | ccsales.FinancialWeeklyCell( relinsert, ccscellproportion ); |
| | | |
| | | info( sumcolumn.FinancialWeeklyCell( relsize ), cumulantcolumn.FinancialWeeklyCell( relsize ), proportioncolumn.FinancialWeeklyCell( relsize ) ); |
| | | info( sumcolumn.FinancialWeeklyCell( relsize ), proportioncolumn.FinancialWeeklyCell( relsize ) ); |
| | | *] |
| | | } |
| | |
| | | //å卿ºæååºå |
| | | traverse( loginfo, FinishedEngineInventory, inventory ){ |
| | | product := select( macroPlan, Product_MP, product, product.Notes() = inventory.FourCode() ); |
| | | InventoryInterfaceData::Generate( interfaceDataset, inventory.DDay(), product.ID(), inventory.BIPlace(), [Number]inventory.Total() ); |
| | | if( not isnull( product ) ){ |
| | | InventoryInterfaceData::Generate( interfaceDataset, inventory.DDay(), product.ID(), inventory.BIPlace(), [Number]inventory.Total() ); |
| | | } |
| | | } |
| | | } |
| | | *] |
| | |
| | | table := selectobject( owner, InventorySummarySource.InventorySummaryReport, table, table.IsShow() ); |
| | | if( not isnull( table ) ){ |
| | | factorys := selectset( owner, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | productids := selectuniquevalues( table, InventroySummaryRow, row, row.Name() ); |
| | | productids := selectuniquevalues( owner, InventorySummarySource.InventorySummaryReport.InventroySummaryRow, row, not row.InventorySummaryReport().IsShow(), row.Name() ); |
| | | table.Generate( search, factorys, productids ); |
| | | } |
| | | return table; |
| | |
| | | TextBody: |
| | | [* |
| | | // çå
°é¸½ Jul-17-2024 (created) |
| | | material_no := guard( item.Get( "material_no").GetString(),""); |
| | | material_no := guard( item.Get( "matnr").GetString(),""); |
| | | material_name := guard( item.Get( "material_name").GetString(),""); |
| | | fac_name := guard( item.Get( "fac_name").GetString(),""); |
| | | fac := guard( item.Get( "fac").GetString(),""); |
| | | total := guard( item.Get( "total").GetReal(), 0 ); |
| | | total := guard( item.Get( "qty").GetReal(), 0 ); |
| | | all_total := guard( item.Get( "all_total").GetReal(), 0 ); |
| | | dday := guard( item.Get( "dday").GetString(),""); |
| | | line_type := guard( item.Get( "fac").GetString(),""); |
| | | line_type := guard( item.Get( "line_type").GetString(),""); |
| | | lgort := guard( item.Get( "lgort").GetString(),""); |
| | | |
| | | msdata := owner.MachineStockData( relnew, MaterialNo := material_no |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method FindProductionLineAndType ( |
| | | String productionLine, |
| | | String type |
| | | ) as Boolean |
| | | { |
| | | TextBody: 'return this.NewOfflinePlanRow().ProductionLine() = productionLine and this.NewOfflinePlanRow().Type() = type and this.Quantity() > 0.0;' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod CreateOldOfflinePlanData ( |
| | | MacroPlan macroPlan |
| | | ) as OfflinePlanTable |
| | | { |
| | | TextBody: |
| | | [* |
| | | nopt := maxselect( macroPlan, NewOfflinePlanTable, tempNOPT, true, tempNOPT.SaveDateTime() ); |
| | | |
| | | macroPlan.OfflinePlanTable( relflush ); |
| | | |
| | | opt := macroPlan.OfflinePlanTable( relnew, SaveDateTime := nopt.SaveDateTime() ); |
| | | |
| | | // å建å |
| | | firstColumn := opt.OfflinePlanColumn( relnew, ColumnDate := macroPlan.StartOfPlanning().Date() - 2 ); |
| | | secondColumn := opt.OfflinePlanColumn( relnew, ColumnDate := macroPlan.StartOfPlanning().Date() - 1 ); |
| | | traverse ( nopt, NewOfflinePlanColumn, nopc ) { |
| | | opt.OfflinePlanColumn( relnew, ColumnDate := nopc.StartDate() ); |
| | | } |
| | | |
| | | pls := selectuniquevalues( nopt, NewOfflinePlanRow, tempNOPR, true, tempNOPR.ProductionLine() ); |
| | | |
| | | traverse ( pls, Elements, pl ) { |
| | | // å建æç»è¡ |
| | | detailNOPRs := selectsortedset( nopt, NewOfflinePlanRow, tempNOPR, tempNOPR.ProductionLine() = pl and tempNOPR.Type() = "1", tempNOPR.ProductionLine(), tempNOPR.ProductID() ); |
| | | traverse ( detailNOPRs, Elements, nopr ) { |
| | | quantityOPR := opt.OfflinePlanRow( relnew, ProductionLine := nopr.ProductionLine(), ProductID := nopr.ProductID(), Type := "1" ); |
| | | orderOPR := opt.OfflinePlanRow( relnew, ProductionLine := nopr.ProductionLine(), ProductID := nopr.ProductID(), Type := "2" ); |
| | | |
| | | // 第ä¸å |
| | | quantityOPR.OfflinePlanCell( relnew, OfflinePlanColumn := firstColumn, Value := nopr.Name() ); |
| | | orderOPR.OfflinePlanCell( relnew, OfflinePlanColumn := firstColumn, Value := "" ); |
| | | |
| | | // 第äºå |
| | | quantityOPR.OfflinePlanCell( relnew, OfflinePlanColumn := secondColumn, Value := "Quantity" ); |
| | | orderOPR.OfflinePlanCell( relnew, OfflinePlanColumn := secondColumn, Value := "Order" ); |
| | | |
| | | // æ¶é´å |
| | | traverse ( nopr, NewOfflinePlanCell, nopcell ) { |
| | | opc := select( opt, OfflinePlanColumn, tempOPC, tempOPC.ColumnDate() = nopcell.StartDate() ); |
| | | quantityOPR.OfflinePlanCell( relnew, OfflinePlanColumn := opc, Value := [String]nopcell.Quantity() ); |
| | | orderOPR.OfflinePlanCell( relnew, OfflinePlanColumn := opc, Value := nopcell.Order() ); |
| | | } |
| | | } |
| | | |
| | | // å建åè®¡è¡ |
| | | totalNOPR := select( nopt, NewOfflinePlanRow, tempNOPR, tempNOPR.ProductionLine() = pl and tempNOPR.Type() = "2" ); |
| | | |
| | | totalOPR := opt.OfflinePlanRow( relnew, ProductionLine := totalNOPR.ProductionLine(), ProductID := "Z", Type := "3" ); |
| | | shiftPatternNameOPR := opt.OfflinePlanRow( relnew, ProductionLine := totalNOPR.ProductionLine(), ProductID := "Z", Type := "4" ); |
| | | shiftPatternStartOPR := opt.OfflinePlanRow( relnew, ProductionLine := totalNOPR.ProductionLine(), ProductID := "Z", Type := "5" ); |
| | | shiftPatternEndOPR := opt.OfflinePlanRow( relnew, ProductionLine := totalNOPR.ProductionLine(), ProductID := "Z", Type := "6" ); |
| | | |
| | | // 第ä¸å |
| | | totalOPR.OfflinePlanCell( relnew, OfflinePlanColumn := firstColumn, Value := "å计" ); |
| | | shiftPatternNameOPR.OfflinePlanCell( relnew, OfflinePlanColumn := firstColumn, Value := "" ); |
| | | shiftPatternStartOPR.OfflinePlanCell( relnew, OfflinePlanColumn := firstColumn, Value := "" ); |
| | | shiftPatternEndOPR.OfflinePlanCell( relnew, OfflinePlanColumn := firstColumn, Value := "" ); |
| | | |
| | | // 第äºå |
| | | totalOPR.OfflinePlanCell( relnew, OfflinePlanColumn := secondColumn, Value := "æ»é" ); |
| | | shiftPatternNameOPR.OfflinePlanCell( relnew, OfflinePlanColumn := secondColumn, Value := "çæ¬¡" ); |
| | | shiftPatternStartOPR.OfflinePlanCell( relnew, OfflinePlanColumn := secondColumn, Value := "çæ¬¡å¼å§æ¶é´" ); |
| | | shiftPatternEndOPR.OfflinePlanCell( relnew, OfflinePlanColumn := secondColumn, Value := "çæ¬¡ç»ææ¶é´" ); |
| | | |
| | | // æ¶é´å |
| | | traverse ( totalNOPR, NewOfflinePlanCell, nopcell ) { |
| | | opc := select( opt, OfflinePlanColumn, tempOPC, tempOPC.ColumnDate() = nopcell.StartDate() ); |
| | | totalOPR.OfflinePlanCell( relnew, OfflinePlanColumn := opc, Value := [String]nopcell.TotalQuantity() ); |
| | | shiftPatternNameOPR.OfflinePlanCell( relnew, OfflinePlanColumn := opc, Value := nopcell.ShiftPatternName() ); |
| | | shiftPatternStartOPR.OfflinePlanCell( relnew, OfflinePlanColumn := opc, Value := nopcell.ShiftPatternStart() ); |
| | | shiftPatternEndOPR.OfflinePlanCell( relnew, OfflinePlanColumn := opc, Value := nopcell.ShiftPatternEnd() ); |
| | | } |
| | | } |
| | | |
| | | return opt; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Download ( |
| | | MacroPlan macroPlan, |
| | | NewOfflinePlanRows selectedNOPRs |
| | | ) as BinaryValue |
| | | { |
| | | TextBody: |
| | | [* |
| | | opt := NewOfflinePlanCell::CreateOldOfflinePlanData( macroPlan ); |
| | | |
| | | oprs := selectset( opt, OfflinePlanRow, tempOPR, exists( selectedNOPRs, Elements, tempNOPR, tempNOPR.ProductionLine() = tempOPR.ProductionLine() ) ); |
| | | |
| | | return NewOfflinePlanCell::OldDownload( macroPlan, oprs ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Import ( |
| | | NewOfflinePlanTable nopt, |
| | | GeneralExcelImportAndExportDataTable table |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | cnv2 := StringToDate::StandardConverter(); |
| | | cnv2.SetCustomConversion(); |
| | | cnv2.CustomFormatString( 'yyyy/MM/dd' ); |
| | | |
| | | productionLine := ""; |
| | | productID := ""; |
| | | isUpdateQuantity := false; |
| | | isUpdateOrder := false; |
| | | |
| | | traverse ( table, GeneralExcelImportAndExportDataRow, row ) { |
| | | traverse ( table, GeneralExcelImportAndExportDataColumn, column ) { |
| | | // åå
æ ¼å¼ |
| | | cell := select( row, GeneralExcelImportAndExportDataCell, tempGEIAEDCell, tempGEIAEDCell.GeneralExcelImportAndExportDataColumn() = column ); |
| | | |
| | | // 第ä¸å夿 |
| | | if ( cell.Value().Tokenize( "_" ).Size() = 2 and column.ColumnIndex() = 0 ) { |
| | | productionLine := cell.Value().Tokenize( "_" ).Element( 0 ); |
| | | productID := cell.Value().Tokenize( "_" ).Element( 1 ); |
| | | } |
| | | |
| | | // 第äºå夿 |
| | | if ( cell.Value() = "Quantity" and column.ColumnIndex() = 1 ) { |
| | | isUpdateQuantity := true; |
| | | isUpdateOrder := false; |
| | | } else if ( cell.Value() = "Order" and column.ColumnIndex() = 1 ) { |
| | | isUpdateQuantity := false; |
| | | isUpdateOrder := true; |
| | | } else if ( cell.Value() <> "Quantity" and cell.Value() <> "Order" and column.ColumnIndex() = 1 ) { |
| | | isUpdateQuantity := false; |
| | | isUpdateOrder := false; |
| | | } |
| | | |
| | | // æ¶é´åæ´æ° |
| | | if ( isUpdateQuantity and cnv2.CanConvert( column.Name() ) and column.ColumnIndex() > 1 ) { |
| | | noopcell := select( nopt, NewOfflinePlanRow.NewOfflinePlanCell, tempNOPCell, |
| | | tempNOPCell.NewOfflinePlanRow().ProductionLine() = productionLine and |
| | | tempNOPCell.NewOfflinePlanRow().ProductID() = productID and |
| | | tempNOPCell.NewOfflinePlanRow().Type() = "1" and |
| | | tempNOPCell.NewOfflinePlanColumn().StartDate() = cnv2.Convert( column.Name() ) ); |
| | | noopcell.Quantity( [Number]cell.Value() ); |
| | | } else if ( isUpdateOrder and cnv2.CanConvert( column.Name() ) and column.ColumnIndex() > 1 ) { |
| | | noopcell := select( nopt, NewOfflinePlanRow.NewOfflinePlanCell, tempNOPCell, |
| | | tempNOPCell.NewOfflinePlanRow().ProductionLine() = productionLine and |
| | | tempNOPCell.NewOfflinePlanRow().ProductID() = productID and |
| | | tempNOPCell.NewOfflinePlanRow().Type() = "1" and |
| | | tempNOPCell.NewOfflinePlanColumn().StartDate() = cnv2.Convert( column.Name() ) ); |
| | | noopcell.Order( cell.Value() ); |
| | | } |
| | | } |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod InterfaceArchive ( |
| | | MacroPlan macroPlan, |
| | | InterfaceDataset interfaceDataset |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | nopt := maxselect( macroPlan, NewOfflinePlanTable, tempNOPT, true, tempNOPT.SaveDateTime() ); |
| | | |
| | | // éæ©æå®çæ¬ä¸çº¿è®¡åæ¥å£æ°æ® |
| | | inopv := select( interfaceDataset, InterfaceNewOfflinePlanVersion, tempINOPV, tempINOPV.ScenarioName() = macroPlan.ScenarioName() ); |
| | | if ( isnull( inopv ) ) { |
| | | inopv := interfaceDataset.InterfaceNewOfflinePlanVersion( relnew, ScenarioName := macroPlan.ScenarioName() ); |
| | | } else { |
| | | inopv.Delete(); |
| | | inopv := interfaceDataset.InterfaceNewOfflinePlanVersion( relnew, ScenarioName := macroPlan.ScenarioName() ); |
| | | } |
| | | |
| | | // å建ä¸çº¿è®¡åæ¥å£æ°æ® |
| | | traverse ( nopt, NewOfflinePlanRow.NewOfflinePlanCell, nopcell, nopcell.NewOfflinePlanRow().Type() = "1" ) { |
| | | inopv.InterfaceNewOfflinePlanDetailData( relnew, |
| | | Order := nopcell.Order(), |
| | | OrderNr := nopcell.OrderNr(), |
| | | ProductID := nopcell.NewOfflinePlanRow().ProductID(), |
| | | ProductionLine := nopcell.NewOfflinePlanRow().ProductionLine(), |
| | | Quantity := nopcell.Quantity(), |
| | | ShiftPatternEnd := nopcell.ShiftPatternEnd(), |
| | | ShiftPatternName := nopcell.ShiftPatternName(), |
| | | ShiftPatternStart := nopcell.ShiftPatternStart(), |
| | | StartDate := nopcell.StartDate() |
| | | ); |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod OldDownload ( |
| | | MacroPlan macroPlan, |
| | | OfflinePlanRows selectedOPRs |
| | | ) as BinaryValue |
| | | { |
| | | TextBody: |
| | | [* |
| | | xmlDOMI := XMLDOMImplementation::Create(); |
| | | xmlDOM := xmlDOMI.CreateDocumentFromString( '<?xml version="1.0" encoding="UTF-16"?><table><name>Sheet1</name></table>' ); |
| | | |
| | | tableElement := xmlDOM.GetElementByTagName( "table", 0 ); |
| | | |
| | | opt := maxselect( macroPlan, OfflinePlanTable, tempOPT, true, tempOPT.SaveDateTime() ); |
| | | opcs := selectsortedset( opt, OfflinePlanColumn, tempOPC, true, tempOPC.ColumnDate() ); |
| | | oprs := selectsortedset( selectedOPRs, Elements, tempOPR, true, tempOPR.ProductionLine(), tempOPR.ProductID(), tempOPR.Type() ); |
| | | traverse ( opcs, Elements, opc ) { |
| | | column := xmlDOM.CreateElement( "column" ); |
| | | name := xmlDOM.CreateElement( "name" ); |
| | | type := xmlDOM.CreateElement( "type" ); |
| | | name.TextContent( ifexpr( opc.ColumnDate() < macroPlan.StartOfPlanning().Date(), "*", opc.ColumnDate().Format( "Y/M2/D2" ) ) ); |
| | | type.TextContent( "String" ); |
| | | column.AppendChild( name ); |
| | | column.AppendChild( type ); |
| | | |
| | | traverse ( oprs, Elements, opr ) { |
| | | c := select( opc, OfflinePlanCell, tempOPC, tempOPC.OfflinePlanRow() = opr ); |
| | | cell := xmlDOM.CreateElement( "cell" ); |
| | | cell.SetAttribute( "value", guard( c.Value(), "" ) ); |
| | | column.AppendChild( cell ); |
| | | } |
| | | |
| | | tableElement.AppendChild( column ); |
| | | } |
| | | |
| | | xmlString := xmlDOMI.CreateSerializer().WriteToString( xmlDOM ) |
| | | |
| | | //info( xmlString ); |
| | | |
| | | tableGroupHandle := TableGroupHandle::Create( "Sheet1" ); |
| | | tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlString ) ); |
| | | tableGroupHandle.Add( tableHandle ); |
| | | |
| | | binaryData := XLS::SaveTableGroupToBinaryData( tableGroupHandle, true ); |
| | | |
| | | return binaryData.AsBinaryValue(); |
| | | *] |
| | | } |
| | |
| | | [* |
| | | macroPlan.NewOfflinePlanTable( relflush ); |
| | | |
| | | nopt := macroPlan.NewOfflinePlanTable( relnew, SaveDateTime := DateTime::ActualTime() ); |
| | | nopt := macroPlan.NewOfflinePlanTable( relnew, SaveDateTime := DateTime::ActualTime() ); |
| | | |
| | | // 计åå¼å§æ¶é´ |
| | | planningDate := macroPlan.StartOfPlanning().Date() |
| | | |
| | | // åå§åä¸çº¿è®¡åå |
| | | traverse ( macroPlan, Period_MP, pmp, pmp.IsPlanning() and not pmp.IsHistorical() ) { |
| | | nopt.NewOfflinePlanColumn( relnew, StartDate := pmp.StartDate(), EndDate := pmp.EndDate() ); |
| | | } |
| | | |
| | | // çæä¸çº¿è®¡å表ã䏿¡äº§çº¿å¨åä¸å¤©ä¸ä¼äº§ç两次ç¸å产åç卿任å¡ã |
| | | traverse ( macroPlan, Unit, u, u.HasCapacityTypeTime() |
| | |
| | | detaileNOPCell := detailedNOPR.NewOfflinePlanCell( relnew, |
| | | Quantity := ns.Quantity().Round( 0 ), |
| | | InventoryWeight := pispippl.InventoryLevelEnd() - pispippl.MinInventoryLevel(), |
| | | ShiftPatternName := guard( sdt.Name(), "" ), |
| | | ShiftPatternName := guard( sp.Name(), "" ), |
| | | ShiftPatternStart := guard( sdt.StartDateTime().Format( "H:m" ), "" ), |
| | | ShiftPatternEnd := guard( sdt.EndDateTIme().Format( "H:m" ), "" ) ); |
| | | detaileNOPCell.NewOfflinePlanColumn( relset, nopc ); |
| | | } |
| | | } |
| | | } |
| | | |
| | | // 设置ç产顺åºã对ä¸çº¿è®¡åæç»çæã |
| | | |
| | | |
| | | // ãçæå计ä¸çº¿è®¡åã |
| | | totalNOPR := nopt.NewOfflinePlanRow( relnew, ProductID := "All", ProductionLine := u.ID(), Type := "2" ); |
| | | detailNOPRs := selectset( nopt, NewOfflinePlanRow, tempNOPR, tempNOPR.ProductionLine() = u.ID() and tempNOPR.Type() = "1" ); |
| | | traverse ( detailNOPRs, Elements, detailNOPR ) { |
| | | traverse ( detailNOPR, NewOfflinePlanCell, detailNOPCell ) { |
| | | // ç产ä¸çº¿è®¡åã产线å计ãåå
æ ¼ |
| | | totalNOPRCell := select( totalNOPR, NewOfflinePlanCell, tempNOPCell, tempNOPCell.NewOfflinePlanColumn() = detailNOPCell.NewOfflinePlanColumn() ); |
| | | if ( isnull( totalNOPRCell ) ) { |
| | | totalNOPRCell := totalNOPR.NewOfflinePlanCell( relnew ); |
| | | totalNOPRCell.NewOfflinePlanColumn( relset, detailNOPCell.NewOfflinePlanColumn() ); // 设置å |
| | | // å°æç»åå
æ ¼å
³èå°å计åå
æ ¼ |
| | | totalNOPRCell.Detailed( relinsert, detailNOPCell ); |
| | | } else { |
| | | // å°æç»åå
æ ¼å
³èå°å计åå
æ ¼ |
| | | totalNOPRCell.Detailed( relinsert, detailNOPCell ); |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | // ãçæå计ä¸çº¿è®¡åã |
| | | totalNOPR := nopt.NewOfflinePlanRow( relnew, ProductID := "All", ProductionLine := u.ID(), Type := "2" ); |
| | | detailNOPRs := selectset( nopt, NewOfflinePlanRow, tempNOPR, tempNOPR.ProductionLine() = u.ID() and tempNOPR.Type() = "1" ); |
| | | traverse ( detailNOPRs, Elements, detailNOPR ) { |
| | | shiftPatternNOPCell := select( detailNOPR, NewOfflinePlanCell, tempNOPCell, tempNOPCell.ShiftPatternName() <> "" ); |
| | | traverse ( detailNOPR, NewOfflinePlanCell, detailNOPCell ) { |
| | | // ç产ä¸çº¿è®¡åã产线å计ãåå
æ ¼ |
| | | totalNOPRCell := select( totalNOPR, NewOfflinePlanCell, tempNOPCell, tempNOPCell.NewOfflinePlanColumn() = detailNOPCell.NewOfflinePlanColumn() ); |
| | | if ( isnull( totalNOPRCell ) ) { |
| | | totalNOPRCell := totalNOPR.NewOfflinePlanCell( relnew, |
| | | ShiftPatternName := shiftPatternNOPCell.ShiftPatternName(), |
| | | ShiftPatternStart := shiftPatternNOPCell.ShiftPatternStart(), |
| | | ShiftPatternEnd := shiftPatternNOPCell.ShiftPatternEnd() ); |
| | | totalNOPRCell.NewOfflinePlanColumn( relset, detailNOPCell.NewOfflinePlanColumn() ); // 设置å |
| | | // å°æç»åå
æ ¼å
³èå°å计åå
æ ¼ |
| | | totalNOPRCell.Detailed( relinsert, detailNOPCell ); |
| | | } else { |
| | | // å°æç»åå
æ ¼å
³èå°å计åå
æ ¼ |
| | | totalNOPRCell.Detailed( relinsert, detailNOPCell ); |
| | | } |
| | | } |
| | | } |
| | | |
| | | // 设置ç产顺åºã对ä¸çº¿è®¡åæç»çæã |
| | | indexColumn := select( nopt, NewOfflinePlanColumn, tempNOPC, tempNOPC.StartDate() = planningDate ); |
| | | previousColumn := indexColumn.PreviousNOPColumn(); |
| | | nextColumn := indexColumn.NextNOPColumn(); |
| | | while ( not isnull( indexColumn.NextNOPColumn() ) |
| | | // and indexColumn.ColumnDate() <= Date::Construct( 2020, 4, 1 ) // æµè¯å®é
åºæ¯æ¶å¯ä»¥è¿æ»¤ |
| | | ) |
| | | { |
| | | orderNr := 1; |
| | | nopcells := selectsortedset( indexColumn, NewOfflinePlanCell, tempNOPCell, tempNOPCell.FindProductionLineAndType( u.ID(), "1" ), tempNOPCell.InventoryWeight() ); |
| | | initialSize := nopcells.Size(); |
| | | // info( "计åå¼å§æ¶é´ï¼", planningDate.Format( "Y-M2-D2" ), " ç´¢å¼æ¶é´ï¼", indexColumn.StartDate().Format( "Y-M2-D2" ), " 个æ°ï¼", nopcells.Size() ); |
| | | |
| | | if ( nopcells.Size() > 0 ) { |
| | | |
| | | // å¤å®1 |
| | | previousOPCell := maxselect( previousColumn, NewOfflinePlanCell, tempNOPCell, tempNOPCell.FindProductionLineAndType( u.ID(), "1" ), tempNOPCell.OrderNr() ); |
| | | if ( isnull( previousOPCell ) or indexColumn.StartDate() = planningDate ) { |
| | | nopcell := nopcells.Element( 0 ); |
| | | nopcell.Order( "#" + orderNr.Format( "N(LPad0(2))" ) ); |
| | | nopcell.OrderNr( orderNr ); |
| | | orderNr++; |
| | | nopcells.Remove( nopcell ); |
| | | } else { |
| | | nopcell := select( nopcells, Elements, tempNOPCell, tempNOPCell.NewOfflinePlanRow().ProductID() = previousOPCell.NewOfflinePlanRow().ProductID() ); |
| | | if ( not isnull( nopcell ) ) { |
| | | nopcell.Order( "#" + orderNr.Format( "N(LPad0(2))" ) ); |
| | | nopcell.OrderNr( orderNr ); |
| | | orderNr++; |
| | | nopcells.Remove( nopcell ); |
| | | } |
| | | } |
| | | |
| | | // å¤å®2 |
| | | nextNOPCells := selectset( nopcells, Elements, tempOPC, |
| | | exists( nextColumn, NewOfflinePlanCell, nextOPCell, nextOPCell.FindProductionLineAndType( u.ID(), "1" ) and |
| | | nextOPCell.NewOfflinePlanRow().ProductID() = tempOPC.NewOfflinePlanRow().ProductID() ) ); // æ¾ä¸ä¸åæ¯å¦æå½ååç产ç产å |
| | | if ( nextNOPCells.Size() = 1 ) { |
| | | nopcell := nextNOPCells.Element( 0 ); |
| | | nopcell.Order( "#" + initialSize.Format( "N(LPad0(2))" ) ); |
| | | nopcell.OrderNr( initialSize ); |
| | | nopcells.Remove( nopcell ); |
| | | } |
| | | |
| | | // å¤å®3 |
| | | traverse ( nopcells, Elements, opcell ) { |
| | | opcell.Order( "#" + orderNr.Format( "N(LPad0(2))" ) ); |
| | | opcell.OrderNr( orderNr ); |
| | | orderNr++; |
| | | nopcells.Remove( opcell ); |
| | | } |
| | | } |
| | | |
| | | indexColumn := indexColumn.NextNOPColumn(); |
| | | previousColumn := indexColumn.PreviousNOPColumn(); |
| | | nextColumn := indexColumn.NextNOPColumn(); |
| | | } |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SaveAsDraft ( |
| | | MacroPlan macroPlan, |
| | | NewOfflinePlanTable nopt |
| | | ) as NewOfflinePlanTable |
| | | { |
| | | TextBody: |
| | | [* |
| | | newTable := nopt.DeepCopy().astype( NewOfflinePlanTable ); |
| | | newNOPT := macroPlan.NewOfflinePlanTable( relinsert, &newTable ); |
| | | newNOPT.SaveDateTime( DateTime::ActualTime() ); |
| | | |
| | | return newNOPT; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Factory |
| | | { |
| | | #keys: '3[413988.0.1657777327][413988.0.1657777326][413988.0.1657777328]' |
| | | Description: '大è¿å·¥å/é¿æ¥å·¥å' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute FactoryAbbreviation |
| | | { |
| | | #keys: '3[413988.0.1657777340][413988.0.1657777339][413988.0.1657777341]' |
| | | Description: 'å·¥åç®å' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcFactoryAbbreviation |
| | | { |
| | | TextBody: |
| | | [* |
| | | // lihongji Oct-14-2024 (created) |
| | | |
| | | value := ifexpr( this.Factory() = "大è¿å·¥å", "DL", "CC" ); |
| | | |
| | | this.FactoryAbbreviation( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeRepresentation FinancialSalesCell |
| | | { |
| | | AttributeRepresentation Value |
| | | { |
| | | AttributeKey: '[415136.0.857450649]' |
| | | Conditional: |
| | | [ |
| | | DataRepresentation.Conditional |
| | | { |
| | | BackgroundColor: '$FF6666' |
| | | ConditionBody: 'object.IsUpdate()' |
| | | ConversionBody: '' |
| | | DefaultBackgroundColor: false |
| | | InheritConversion: false |
| | | } |
| | | ] |
| | | } |
| | | RelationRepresentation AsFirstCellInColumn { RelationKey: '[415136.0.857450670]' Visibility: 'Normal' } |
| | | } |
| | |
| | | #parent: #root |
| | | TypeRepresentation NewOfflinePlanCell |
| | | { |
| | | AttributeRepresentation Order |
| | | { |
| | | Alignment: 'Right' |
| | | AttributeKey: '[413988.0.1603460356]' |
| | | } |
| | | AttributeRepresentation Quantity |
| | | { |
| | | AttributeKey: '[413988.0.1603460346]' |
| | | Conditional: |
| | | [ |
| | | DataRepresentation.Conditional |
| | | { |
| | | BackgroundColor: '$FF3399' |
| | | ConversionBody: '' |
| | | DefaultBackgroundColor: false |
| | | InheritConversion: false |
| | | } |
| | | ] |
| | | } |
| | | AttributeRepresentation ShiftPatternEnd |
| | | { |
| | | Alignment: 'Right' |
| | | AttributeKey: '[413988.0.1603460414]' |
| | | Synonym: 'çæ¬¡ç»ææ¶é´' |
| | | } |
| | | AttributeRepresentation ShiftPatternName |
| | | { |
| | | Alignment: 'Right' |
| | | AttributeKey: '[413988.0.1603460388]' |
| | | Synonym: 'çæ¬¡' |
| | | } |
| | | AttributeRepresentation ShiftPatternStart |
| | | { |
| | | Alignment: 'Right' |
| | | AttributeKey: '[413988.0.1603460401]' |
| | | Synonym: 'çæ¬¡å¼å§æ¶é´' |
| | | } |
| | |
| | | [ |
| | | DataBinding: 'DataHolderDialogData.Data.ProductID' |
| | | Label: 'Product ID' |
| | | Taborder: 0 |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component npQuantity |
| | |
| | | [ |
| | | DataBinding: 'DataHolderDialogData.Data.Quantity' |
| | | Label: 'Quantity' |
| | | Taborder: 1 |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component ddslFactory |
| | | { |
| | | #keys: '[413988.0.1660241136]' |
| | | BaseType: 'WebDropDownStringList' |
| | | Properties: |
| | | [ |
| | | DataBinding: 'DataHolderDialogData.Data.Factory' |
| | | Label: 'Factory' |
| | | Strings: '大è¿å·¥å;é¿æ¥å·¥å' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Factory","title":"Factory","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Factory"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}}]' |
| | | ContextMenu: 'cmContent' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | EnterButton: 'btnOk' |
| | | EscapeButton: 'btnCancel' |
| | | ExcludeFromActiveComponent: true |
| | | MinimumColumns: 50 |
| | | MinimumColumns: 80 |
| | | MinimumRows: 30 |
| | | Padding: 'false' |
| | | ] |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListFactory id:ListFactory_891 |
| | | { |
| | | #keys: '[415136.0.1194549290]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorFactory |
| | | { |
| | | #keys: '[415136.0.1194549291]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'Factory' |
| | | ] |
| | | } |
| | | #child: listActionBarPageFactory_1 |
| | | Component DataSetLevelFactory |
| | | { |
| | | #keys: '[415136.0.1194549293]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuFactory_1 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Name","title":"Name","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Name"}}]' |
| | | ContextMenu: 'listContextMenuFactory' |
| | | SortCriteria: 'ID' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListGeneration id:ListGeneration_273 |
| | | { |
| | | #keys: '[415136.0.1194549297]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorGeneration |
| | | { |
| | | #keys: '[415136.0.1194549298]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'ProductGeneration' |
| | | ] |
| | | } |
| | | #child: listActionBarPageGeneration_1 |
| | | Component DataSetLevelGeneration |
| | | { |
| | | #keys: '[415136.0.1194549300]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuGeneration_1 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Generation","title":"Generation","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Generation"}}]' |
| | | ContextMenu: 'listContextMenuGeneration' |
| | | SortCriteria: 'Generation' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListMQBMLB id:ListMQBMLB_791 |
| | | { |
| | | #keys: '[415136.0.1194549304]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorMQBMLB |
| | | { |
| | | #keys: '[415136.0.1194549305]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'external[MacroPlan]' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'ProductMLBMQB' |
| | | ] |
| | | } |
| | | #child: listActionBarPageMQBMLB_1 |
| | | Component DataSetLevelMQBMLB |
| | | { |
| | | #keys: '[415136.0.1194549307]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuMQBMLB_1 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MLBMQB","title":"MLBMQB","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MLBMQB"}}]' |
| | | ContextMenu: 'listContextMenuMQBMLB' |
| | | SortCriteria: 'MLBMQB' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListPower id:ListPower_480 |
| | | { |
| | | #keys: '[415136.0.1194549311]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorPower |
| | | { |
| | | #keys: '[415136.0.1194549312]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'external[MacroPlan]' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'ProductPower' |
| | | ] |
| | | } |
| | | #child: listActionBarPagePower_1 |
| | | Component DataSetLevelPower |
| | | { |
| | | #keys: '[415136.0.1194549314]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuPower_1 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Power","title":"Power","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Power"}}]' |
| | | ContextMenu: 'listContextMenuPower' |
| | | SortCriteria: 'Power' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_MatrixEditorTable.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component MatrixEditorTable |
| | | Component MatrixEditorTable id:MatrixEditorTable_97 |
| | | { |
| | | #keys: '[415136.0.844701426]' |
| | | #keys: '[415136.0.1194549840]' |
| | | BaseType: 'WebMatrixEditor' |
| | | Children: |
| | | [ |
| | | Component MatrixEditorCellTable |
| | | { |
| | | #keys: '[415136.0.844701427]' |
| | | #keys: '[415136.0.1194549841]' |
| | | BaseType: 'WebMatrixEditorCell' |
| | | Children: |
| | | [ |
| | | Component DataExtractorCell |
| | | { |
| | | #keys: '[415136.0.844701428]' |
| | | #keys: '[415136.0.1194549842]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component MatrixEditorRowsTable |
| | | { |
| | | #keys: '[415136.0.844701431]' |
| | | #keys: '[415136.0.1194549843]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorRow |
| | | { |
| | | #keys: '[415136.0.844701432]' |
| | | #keys: '[415136.0.1194549844]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component MatrixEditorColumnsTable |
| | | { |
| | | #keys: '[415136.0.844701435]' |
| | | #keys: '[415136.0.1194549845]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorColumn |
| | | { |
| | | #keys: '[415136.0.844701436]' |
| | | #keys: '[415136.0.1194549846]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | #child: matrixEditorActionBarPageTable |
| | | #child: matrixeditorContextMenuTable |
| | | #child: matrixEditorActionBarPageTable_1 |
| | | #child: matrixeditorContextMenuTable_1 |
| | | ] |
| | | Properties: |
| | | [ |
copy from _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_PanelExport.def
copy to "_Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_PanelExport\043369.def"
Îļþ´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_PanelExport.def ¸´ÖÆ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelExport |
| | | Component PanelExport id:PanelExport_369 |
| | | { |
| | | #keys: '[415136.0.834352718]' |
| | | #keys: '[415136.0.1194549632]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component ButtonExport |
| | | Component ButtonExport696 |
| | | { |
| | | #keys: '[415136.0.834352737]' |
| | | #keys: '[415136.0.1194549633]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component ButtonSearch |
| | | { |
| | | #keys: '[415136.0.972170614]' |
| | | #keys: '[415136.0.1194549634]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bRefresh id:bRefresh_859 |
| | | Component bRefresh |
| | | { |
| | | #keys: '[415136.0.1153802738]' |
| | | #keys: '[415136.0.1194549635]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 4 |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelFactory id:PanelFactory_298 |
| | | { |
| | | #keys: '[415136.0.1194549289]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: ListFactory_891 |
| | | Component dhFactorys |
| | | { |
| | | #keys: '[415136.0.1194549295]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[Factory]*' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | Title: 'Unit' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelFinancialProductionReport |
| | | { |
| | | #keys: '[415136.0.1193311792]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: Panelleft |
| | | #child: PanelRight |
| | | ] |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelGeneration |
| | | { |
| | | #keys: '[415136.0.834352628]' |
| | | #keys: '[415136.0.1194549296]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component ddslGeneration |
| | | #child: ListGeneration_273 |
| | | Component dhGenerations |
| | | { |
| | | #keys: '[415136.0.834850709]' |
| | | BaseType: 'WebDropDownStringList' |
| | | #keys: '[415136.0.1194549302]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[ProductGeneration]*' |
| | | Properties: |
| | | [ |
| | | Label: 'Generation' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 1 |
| | | Title: 'Generation' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelHeader |
| | | { |
| | | #keys: '[415136.0.1194549582]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelExport_369 |
| | | #child: PanelOperation |
| | | ] |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelMQBMLB |
| | | { |
| | | #keys: '[415136.0.834352657]' |
| | | #keys: '[415136.0.1194549303]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component ddslMQBMLB |
| | | #child: ListMQBMLB_791 |
| | | Component dhMQBMLBs |
| | | { |
| | | #keys: '[415136.0.834850906]' |
| | | BaseType: 'WebDropDownStringList' |
| | | #keys: '[415136.0.1194549309]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[ProductMLBMQB]*' |
| | | Properties: |
| | | [ |
| | | Label: 'MQB/MLB' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 2 |
| | | Title: 'MLB/MQB' |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_PanelFinancialProductionReportOperation.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelFinancialProductionReportOperation |
| | | Component PanelOperation |
| | | { |
| | | #keys: '[415136.0.834352420]' |
| | | #keys: '[415136.0.1194549737]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component LabelFinancialProductionReportOperation |
| | | Component LabelOperation |
| | | { |
| | | #keys: '[415136.0.834352468]' |
| | | #keys: '[415136.0.1194549738]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | |
| | | Text: 'Production import' |
| | | ] |
| | | } |
| | | Component ButtonProductionImport |
| | | Component ButtonProductionImport660 |
| | | { |
| | | #keys: '[415136.0.834352491]' |
| | | #keys: '[415136.0.1194549739]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component ButtonProductionExport |
| | | Component ButtonProductionExport854 |
| | | { |
| | | #keys: '[415136.0.834352534]' |
| | | #keys: '[415136.0.1194549740]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelPower |
| | | { |
| | | #keys: '[415136.0.834352679]' |
| | | #keys: '[415136.0.1194549310]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component ddslPower |
| | | #child: ListPower_480 |
| | | Component dhPowers |
| | | { |
| | | #keys: '[415136.0.834851149]' |
| | | BaseType: 'WebDropDownStringList' |
| | | #keys: '[415136.0.1194549316]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[ProductPower]*' |
| | | Properties: |
| | | [ |
| | | Label: 'Power' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 3 |
| | | Title: 'Power' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelRight |
| | | { |
| | | #keys: '[415136.0.1194549553]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelHeader |
| | | #child: PanelTable_673 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelTable id:PanelTable_673 |
| | | { |
| | | #keys: '[415136.0.1194549839]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: MatrixEditorTable_97 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component Panelleft |
| | | { |
| | | #keys: '[415136.0.1194549288]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelFactory_298 |
| | | #child: PanelPower |
| | | #child: PanelMQBMLB |
| | | #child: PanelGeneration |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | MinimumColumns: 20 |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageFactory id:listActionBarPageFactory_1 |
| | | { |
| | | #keys: '[415136.0.1194549292]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageGeneration id:listActionBarPageGeneration_1 |
| | | { |
| | | #keys: '[415136.0.1194549299]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageMQBMLB id:listActionBarPageMQBMLB_1 |
| | | { |
| | | #keys: '[415136.0.1194549306]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPagePower id:listActionBarPagePower_1 |
| | | { |
| | | #keys: '[415136.0.1194549313]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuFactory id:listContextMenuFactory_1 |
| | | { |
| | | #keys: '[415136.0.1194549294]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuGeneration id:listContextMenuGeneration_1 |
| | | { |
| | | #keys: '[415136.0.1194549301]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuMQBMLB id:listContextMenuMQBMLB_1 |
| | | { |
| | | #keys: '[415136.0.1194549308]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuPower id:listContextMenuPower_1 |
| | | { |
| | | #keys: '[415136.0.1194549315]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Component_matrixEditorActionBarPageTable#1.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixEditorActionBarPageTable id:matrixEditorActionBarPageTable_1 |
| | | { |
| | | #keys: '[415136.0.858621874]' |
| | | #keys: '[415136.0.1194549847]' |
| | | BaseType: 'matrixEditorActionBarPage' |
| | | Properties: |
| | | [ |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Component_matrixeditorContextMenuTable#1.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixeditorContextMenuTable id:matrixeditorContextMenuTable_1 |
| | | { |
| | | #keys: '[415136.0.858621875]' |
| | | #keys: '[415136.0.1194549848]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListFactory_891 |
| | | Response OnCheckedChanged () id:Response_ListFactory_891_OnCheckedChanged_57 |
| | | { |
| | | #keys: '[415136.0.1194549281]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | dhFactorys.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListFactory_891 |
| | | Response OnCheckedChanged ( |
| | | structured[Factory] checkeditems |
| | | ) id:Response_ListFactory_891_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1194549282]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhFactorys.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListGeneration_273 |
| | | Response OnCheckedChanged () id:Response_ListGeneration_273_OnCheckedChanged_384 |
| | | { |
| | | #keys: '[415136.0.1194549278]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, ProductGeneration, generation, true ); |
| | | dhGenerations.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListGeneration_273 |
| | | Response OnCheckedChanged ( |
| | | structured[ProductGeneration] checkeditems |
| | | ) id:Response_ListGeneration_273_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1194549279]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhGenerations.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListMQBMLB_791 |
| | | Response OnCheckedChanged () id:Response_ListMQBMLB_791_OnCheckedChanged_812 |
| | | { |
| | | #keys: '[415136.0.1194549275]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, ProductMLBMQB, generation, true ); |
| | | dhMQBMLBs.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListMQBMLB_791 |
| | | Response OnCheckedChanged ( |
| | | structured[ProductMLBMQB] checkeditems |
| | | ) id:Response_ListMQBMLB_791_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1194549276]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhMQBMLBs.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListPower_480 |
| | | Response OnCheckedChanged () id:Response_ListPower_480_OnCheckedChanged_568 |
| | | { |
| | | #keys: '[415136.0.1194549272]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, ProductPower, generation, true ); |
| | | dhPowers.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListPower_480 |
| | | Response OnCheckedChanged ( |
| | | structured[ProductPower] checkeditems |
| | | ) id:Response_ListPower_480_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1194549273]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhPowers.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | [* |
| | | //åå§å |
| | | table := FinancialProductionSource::InitiateSearch( MacroPlan ); |
| | | //table := selectobject( MacroPlan, FinancialProductionSource.FinancialProductionReport, table, not table.IsImport() and table.IsShow() ); |
| | | //info( '------------------2----------------', table.IsImport(), table.IsShow() ); |
| | | Factory::Initilize( MacroPlan ); |
| | | ProductGeneration::Initilize( MacroPlan ); |
| | | ProductPower::Initilize( MacroPlan ); |
| | | ProductMLBMQB::Initilize( MacroPlan ); |
| | | DataHolderTable.Data( table ); |
| | | |
| | | //dhSearch.Data( MacroPlan.FinancialProductionSearch() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Response_PanelExport_ButtonExport_OnClick.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelExport/ButtonExport |
| | | Response OnClick () id:Response_PanelExport_ButtonExport_OnClick |
| | | #parent: PanelExport_369/ButtonExport696 |
| | | Response OnClick () id:Response_PanelExport_369_ButtonExport696_OnClick |
| | | { |
| | | #keys: '[415136.0.834850599]' |
| | | #keys: '[415136.0.1194549631]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelExport_369/ButtonSearch |
| | | Response OnClick () id:Response_PanelExport_369_ButtonSearch_OnClick |
| | | { |
| | | #keys: '[415136.0.1194549630]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | |
| | | if( not isnull( DataHolderTable.Data() ) ){ |
| | | productids := selectuniquevalues( DataHolderProduct.Data(), Elements, product, exists( dhGenerations.Data(), Elements, e, e.Generation() = product.Generation() ) |
| | | and exists( dhMQBMLBs.Data(), Elements, e, e.MLBMQB() = product.MQBMLB() ) |
| | | and exists( dhPowers.Data(), Elements, e, e.Power() = product.Power() ), product.ID() ); |
| | | |
| | | DataHolderTable.Data().Generate( dhSearch.Data(), dhFactorys.Data(), productids ); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Response_PanelExport_bRefresh_OnClick.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelExport/bRefresh_859 |
| | | Response OnClick () id:Response_PanelExport_670_bRefresh_OnClick |
| | | #parent: PanelExport_369/bRefresh |
| | | Response OnClick () id:Response_PanelExport_369_bRefresh_OnClick |
| | | { |
| | | #keys: '[415136.0.1153802737]' |
| | | #keys: '[415136.0.1194549629]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Response_PanelFinancialProductionReportOperation_ButtonProductionExport_OnCl.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelFinancialProductionReportOperation/ButtonProductionExport |
| | | Response OnClick () id:Response_PanelFinancialProductionReportOperation_ButtonProductionExport_OnClick |
| | | #parent: PanelOperation/ButtonProductionExport854 |
| | | Response OnClick () id:Response_PanelOperation_ButtonProductionExport854_OnClick |
| | | { |
| | | #keys: '[415136.0.834850519]' |
| | | #keys: '[415136.0.1194549735]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Response_PanelFinancialProductionReportOperation_ButtonProductionImport_OnCl.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelFinancialProductionReportOperation/ButtonProductionImport |
| | | Response OnClick () id:Response_PanelFinancialProductionReportOperation_ButtonProductionImport_OnClick |
| | | #parent: PanelOperation/ButtonProductionImport660 |
| | | Response OnClick () id:Response_PanelOperation_ButtonProductionImport660_OnClick |
| | | { |
| | | #keys: '[415136.0.836011369]' |
| | | #keys: '[415136.0.1194549736]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | |
| | | if( not source.IsExistFutureMonthData() or |
| | | ( source.IsExistFutureMonthData() and WebMessageBox::Question( this, Translations::MP_FinancialProductionReport_Question(), 'Yes|No' ) = 0 ) ){ |
| | | source.AfterImport(); |
| | | DataHolderTable.Data().Generate( dhSearch.Data(), DataHolderProduct.Data() ); |
| | | FinancialProductionSource::InitiateSearch( MacroPlan ); |
| | | } |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | #child: PanelFinancialProductionReportHeader |
| | | #child: PanelTable |
| | | Component DataHolderTable |
| | | { |
| | | #keys: '[415136.0.840720309]' |
| | |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | #child: PanelFinancialProductionReport |
| | | ] |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListFactory |
| | | { |
| | | #keys: '[415136.0.1193321775]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorFactory |
| | | { |
| | | #keys: '[415136.0.1193321776]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'Factory' |
| | | ] |
| | | } |
| | | #child: listActionBarPageFactory |
| | | Component DataSetLevelFactory |
| | | { |
| | | #keys: '[415136.0.1193321778]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuFactory |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Name","title":"Name","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Name"}}]' |
| | | ContextMenu: 'listContextMenuFactory' |
| | | SortCriteria: 'ID' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListGeneration |
| | | { |
| | | #keys: '[415136.0.1193321812]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorGeneration |
| | | { |
| | | #keys: '[415136.0.1193321813]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'ProductGeneration' |
| | | ] |
| | | } |
| | | #child: listActionBarPageGeneration |
| | | Component DataSetLevelGeneration |
| | | { |
| | | #keys: '[415136.0.1193321815]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuGeneration |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Generation","title":"Generation","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Generation"}}]' |
| | | ContextMenu: 'listContextMenuGeneration' |
| | | SortCriteria: 'Generation' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListMQBMLB |
| | | { |
| | | #keys: '[415136.0.1193321849]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorMQBMLB |
| | | { |
| | | #keys: '[415136.0.1193321850]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'external[MacroPlan]' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'ProductMLBMQB' |
| | | ] |
| | | } |
| | | #child: listActionBarPageMQBMLB |
| | | Component DataSetLevelMQBMLB |
| | | { |
| | | #keys: '[415136.0.1193321852]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuMQBMLB |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MLBMQB","title":"MLBMQB","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MLBMQB"}}]' |
| | | ContextMenu: 'listContextMenuMQBMLB' |
| | | SortCriteria: 'MLBMQB' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListPower |
| | | { |
| | | #keys: '[415136.0.1193321886]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorPower |
| | | { |
| | | #keys: '[415136.0.1193321887]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'external[MacroPlan]' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'ProductPower' |
| | | ] |
| | | } |
| | | #child: listActionBarPagePower |
| | | Component DataSetLevelPower |
| | | { |
| | | #keys: '[415136.0.1193321889]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenuPower |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Power","title":"Power","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Power"}}]' |
| | | ContextMenu: 'listContextMenuPower' |
| | | SortCriteria: 'Power' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | SelectionCheckboxes: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Component_MatrixEditorTable#623.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component MatrixEditorTable id:MatrixEditorTable_623 |
| | | Component MatrixEditorTable |
| | | { |
| | | #keys: '[415136.0.858621867]' |
| | | #keys: '[415136.0.1193322115]' |
| | | BaseType: 'WebMatrixEditor' |
| | | Children: |
| | | [ |
| | | Component MatrixEditorCellTable |
| | | { |
| | | #keys: '[415136.0.858621868]' |
| | | #keys: '[415136.0.1193322116]' |
| | | BaseType: 'WebMatrixEditorCell' |
| | | Children: |
| | | [ |
| | | Component DataExtractorCell |
| | | { |
| | | #keys: '[415136.0.858621869]' |
| | | #keys: '[415136.0.1193322117]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component MatrixEditorRowsTable |
| | | { |
| | | #keys: '[415136.0.858621870]' |
| | | #keys: '[415136.0.1193322118]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorRow |
| | | { |
| | | #keys: '[415136.0.858621871]' |
| | | #keys: '[415136.0.1193322119]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component MatrixEditorColumnsTable |
| | | { |
| | | #keys: '[415136.0.858621872]' |
| | | #keys: '[415136.0.1193322120]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorColumn |
| | | { |
| | | #keys: '[415136.0.858621873]' |
| | | #keys: '[415136.0.1193322121]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | #child: matrixEditorActionBarPageTable_1 |
| | | #child: matrixeditorContextMenuTable_1 |
| | | #child: matrixEditorActionBarPageTable |
| | | #child: matrixeditorContextMenuTable |
| | | ] |
| | | Properties: |
| | | [ |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_PanelExport.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelExport |
| | | { |
| | | #keys: '[415136.0.834352718]' |
| | | #keys: '[415136.0.1193321967]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component ButtonExport |
| | | Component ButtonExport570 |
| | | { |
| | | #keys: '[415136.0.834352737]' |
| | | #keys: '[415136.0.1193321968]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component ButtonSearch |
| | | { |
| | | #keys: '[415136.0.972170614]' |
| | | #keys: '[415136.0.1193321969]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bRefresh id:bRefresh_859 |
| | | Component bRefresh |
| | | { |
| | | #keys: '[415136.0.1153802738]' |
| | | #keys: '[415136.0.1193321970]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 4 |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelFactory |
| | | { |
| | | #keys: '[415136.0.1193321774]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component dhFactorys |
| | | { |
| | | #keys: '[415136.0.1193321780]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[Factory]*' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | #child: ListFactory |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | Title: 'Unit' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelFinancialSalesReport |
| | | { |
| | | #keys: '[415136.0.1193321676]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelLeft |
| | | #child: PanelRight |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelGeneration id:PanelGeneration_653 |
| | | { |
| | | #keys: '[415136.0.1193321811]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component dhGenerations |
| | | { |
| | | #keys: '[415136.0.1193321817]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[ProductGeneration]*' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | #child: ListGeneration |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | Title: 'Generation' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelHeader |
| | | { |
| | | #keys: '[415136.0.1193321921]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelExport |
| | | #child: PanelOperation |
| | | ] |
| | | Properties: |
| | | [ |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelLeft |
| | | { |
| | | #keys: '[415136.0.1193321690]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelFactory |
| | | #child: PanelGeneration_653 |
| | | #child: PanelMQBMLB_466 |
| | | #child: PanelPower_510 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelMQBMLB id:PanelMQBMLB_466 |
| | | { |
| | | #keys: '[415136.0.1193321848]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component dhMQBMLBs |
| | | { |
| | | #keys: '[415136.0.1193321854]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[ProductMLBMQB]*' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | #child: ListMQBMLB |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | Title: 'MLB/MQB' |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Component_PanelFinancialSalesReportOperation.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelFinancialSalesReportOperation |
| | | Component PanelOperation |
| | | { |
| | | #keys: '[415136.0.858621786]' |
| | | #keys: '[415136.0.1193322031]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component LabelFinancialSalesReportOperation |
| | | { |
| | | #keys: '[415136.0.858621787]' |
| | | #keys: '[415136.0.1193322032]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component ButtonSalesImport |
| | | { |
| | | #keys: '[415136.0.858621788]' |
| | | #keys: '[415136.0.1193322033]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | |
| | | } |
| | | Component ButtonSalesExport |
| | | { |
| | | #keys: '[415136.0.858621789]' |
| | | #keys: '[415136.0.1193322034]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelPower id:PanelPower_510 |
| | | { |
| | | #keys: '[415136.0.1193321885]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component dhPowers |
| | | { |
| | | #keys: '[415136.0.1193321891]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[ProductPower]*' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | #child: ListPower |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | Title: 'Power' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelRight |
| | | { |
| | | #keys: '[415136.0.1193321903]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelHeader |
| | | #child: PanelTable |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_PanelTable.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelTable |
| | | { |
| | | #keys: '[415136.0.834352365]' |
| | | #keys: '[415136.0.1193322114]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageFactory |
| | | { |
| | | #keys: '[415136.0.1193321777]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageGeneration |
| | | { |
| | | #keys: '[415136.0.1193321814]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageMQBMLB |
| | | { |
| | | #keys: '[415136.0.1193321851]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPagePower |
| | | { |
| | | #keys: '[415136.0.1193321888]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuFactory |
| | | { |
| | | #keys: '[415136.0.1193321779]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuGeneration |
| | | { |
| | | #keys: '[415136.0.1193321816]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuMQBMLB |
| | | { |
| | | #keys: '[415136.0.1193321853]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuPower |
| | | { |
| | | #keys: '[415136.0.1193321890]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_matrixEditorActionBarPageTable.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixEditorActionBarPageTable |
| | | { |
| | | #keys: '[415136.0.844701439]' |
| | | #keys: '[415136.0.1193322122]' |
| | | BaseType: 'matrixEditorActionBarPage' |
| | | Properties: |
| | | [ |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialProductionReport/Component_matrixeditorContextMenuTable.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixeditorContextMenuTable |
| | | { |
| | | #keys: '[415136.0.844701442]' |
| | | #keys: '[415136.0.1193322123]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListFactory |
| | | Response OnCheckedChanged () id:Response_ListFactory_OnCheckedChanged_150 |
| | | { |
| | | #keys: '[415136.0.1193321770]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, Factory, factory, factory.ID() = FinancialProductionReport::GetDefaultAllUnit() ); |
| | | dhFactorys.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListFactory |
| | | Response OnCheckedChanged ( |
| | | structured[Factory] checkeditems |
| | | ) id:Response_ListFactory_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1193321771]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhFactorys.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListGeneration |
| | | Response OnCheckedChanged () id:Response_ListGeneration_OnCheckedChanged_670 |
| | | { |
| | | #keys: '[415136.0.1193321807]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, ProductGeneration, generation, true ); |
| | | dhGenerations.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListGeneration |
| | | Response OnCheckedChanged ( |
| | | structured[ProductGeneration] checkeditems |
| | | ) id:Response_ListGeneration_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1193321808]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhGenerations.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListMQBMLB |
| | | Response OnCheckedChanged () id:Response_ListMQBMLB_OnCheckedChanged_475 |
| | | { |
| | | #keys: '[415136.0.1193321844]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, ProductMLBMQB, generation, true ); |
| | | dhMQBMLBs.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListMQBMLB |
| | | Response OnCheckedChanged ( |
| | | structured[ProductMLBMQB] checkeditems |
| | | ) id:Response_ListMQBMLB_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1193321845]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhMQBMLBs.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListPower |
| | | Response OnCheckedChanged () id:Response_ListPower_OnCheckedChanged_976 |
| | | { |
| | | #keys: '[415136.0.1193321881]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := selectset( MacroPlan, ProductPower, generation, true ); |
| | | dhPowers.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ListPower |
| | | Response OnCheckedChanged ( |
| | | structured[ProductPower] checkeditems |
| | | ) id:Response_ListPower_OnCheckedChanged |
| | | { |
| | | #keys: '[415136.0.1193321882]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnCheckedChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | selections := checkeditems.Copy(); |
| | | dhPowers.Data( &selections ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | Body: |
| | | [* |
| | | table := FinancialSalesSource::InitiateSearch( MacroPlan ); |
| | | //table := selectobject( MacroPlan, FinancialSalesSource.FinancialSalesReport, table, not table.IsImport() and table.IsShow() ); |
| | | //info( '------------------2----------------', table.IsImport(), table.IsShow() ); |
| | | Factory::Initilize( MacroPlan ); |
| | | ProductGeneration::Initilize( MacroPlan ); |
| | | ProductPower::Initilize( MacroPlan ); |
| | | ProductMLBMQB::Initilize( MacroPlan ); |
| | | DataHolderTable.Data( table ); |
| | | |
| | | //dhSearch.Data( MacroPlan.FinancialSalesSearch() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Response_PanelExport_545_ButtonExport_OnClick.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelExport_545/ButtonExport |
| | | Response OnClick () id:Response_PanelExport_545_ButtonExport_OnClick |
| | | #parent: PanelExport/ButtonExport570 |
| | | Response OnClick () id:Response_PanelExport_ButtonExport570_OnClick |
| | | { |
| | | #keys: '[415136.0.858621765]' |
| | | #keys: '[415136.0.1193321966]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelExport/ButtonSearch |
| | | Response OnClick () id:Response_PanelExport_ButtonSearch_OnClick |
| | | { |
| | | #keys: '[415136.0.1193321965]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | if( not isnull( DataHolderTable.Data() ) ){ |
| | | productids := selectuniquevalues( DataHolderProduct.Data(), Elements, product, exists( dhGenerations.Data(), Elements, e, e.Generation() = product.Generation() ) |
| | | and exists( dhMQBMLBs.Data(), Elements, e, e.MLBMQB() = product.MQBMLB() ) |
| | | and exists( dhPowers.Data(), Elements, e, e.Power() = product.Power() ), product.ID() ); |
| | | |
| | | DataHolderTable.Data().Generate( dhSearch.Data(), dhFactorys.Data(), productids ); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Response_PanelExport_545_bRefresh_OnClick.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelExport_545/bRefresh |
| | | #parent: PanelExport/bRefresh |
| | | Response OnClick () id:Response_PanelExport_bRefresh_OnClick |
| | | { |
| | | #keys: '[415136.0.1153802933]' |
| | | #keys: '[415136.0.1193321964]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Response_PanelFinancialSalesReportOperation_ButtonSalesExport_OnClick.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelFinancialSalesReportOperation/ButtonSalesExport |
| | | Response OnClick () id:Response_PanelFinancialSalesReportOperation_ButtonSalesExport_OnClick |
| | | #parent: PanelOperation/ButtonSalesExport |
| | | Response OnClick () id:Response_PanelOperation_ButtonSalesExport_OnClick |
| | | { |
| | | #keys: '[415136.0.858621763]' |
| | | #keys: '[415136.0.1193322029]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
ÎļþÃû´Ó _Main/UI/MacroPlannerWebApp/Component_FormFinancialSalesReport/Response_PanelFinancialSalesReportOperation_ButtonSalesImport_OnClick.def ÐÞ¸Ä |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelFinancialSalesReportOperation/ButtonSalesImport |
| | | Response OnClick () id:Response_PanelFinancialSalesReportOperation_ButtonSalesImport_OnClick |
| | | #parent: PanelOperation/ButtonSalesImport |
| | | Response OnClick () id:Response_PanelOperation_ButtonSalesImport_OnClick |
| | | { |
| | | #keys: '[415136.0.858621764]' |
| | | #keys: '[415136.0.1193322030]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | |
| | | if( not source.IsExistFutureMonthData() or |
| | | ( source.IsExistFutureMonthData() and WebMessageBox::Question( this, Translations::MP_FinancialProductionReport_Question(), 'Yes|No' ) = 0 ) ){ |
| | | source.AfterImport(); |
| | | DataHolderTable.Data().Generate( dhSearch.Data(), DataHolderProduct.Data() ); |
| | | FinancialSalesSource::InitiateSearch( MacroPlan ); |
| | | } |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | #child: PanelTable_424 |
| | | #child: PanelFinancialSalesReportHeader |
| | | #child: PanelFinancialSalesReport |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | ProductGeneration::Initilize( MacroPlan ); |
| | | ProductPower::Initilize( MacroPlan ); |
| | | ProductMLBMQB::Initilize( MacroPlan ); |
| | | //table := selectobject( MacroPlan, InventorySummarySource.InventorySummaryReport, table, table.IsShow() ); |
| | | //info( '------------------2----------------', table.IsShow() ); |
| | | DataHolderTable.Data( table ); |
| | | |
| | | //dhSearch.Data( table.InventorySummarySource().InventorySummarySearch() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | |
| | | { |
| | | Body: |
| | | [* |
| | | c := 'VWED CC'; |
| | | info( c.Format( 'S(Len(10),AlignRight)' ), c.Format( 'S(Len(10))' ) ); |
| | | a := 'All'; |
| | | info( a.Format( 'S(Len(10),AlignRight)' ), a.Format( 'S(Len(10))' ) ); |
| | | if( not isnull( DataHolderTable.Data() ) ){ |
| | | productids := selectuniquevalues( DataHolderProduct.Data(), Elements, product, exists( dhGenerations.Data(), Elements, e, e.Generation() = product.Generation() ) |
| | | and exists( dhMQBMLBs.Data(), Elements, e, e.MLBMQB() = product.MQBMLB() ) |
| | |
| | | AllowMultipleAttributes: true |
| | | Columns: 'MatrixEditorColumns473' |
| | | ContextMenu: 'matrixeditorContextMenu267' |
| | | Editable: false |
| | | Rows: 'MatrixEditorRows569' |
| | | Taborder: 0 |
| | | ] |
| | |
| | | { |
| | | #keys: '[413988.0.1607432887]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Children: |
| | | [ |
| | | Component mSeparator |
| | | { |
| | | #keys: '[413988.0.1651491148]' |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Separator: true |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component mShowOrHide |
| | | { |
| | | #keys: '[413988.0.1651491174]' |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Image: 'POWER' |
| | | Taborder: 3 |
| | | Title: 'Show/Hide total' |
| | | ] |
| | | } |
| | | Component mResetArchive |
| | | { |
| | | #keys: '[413988.0.1657458774]' |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Image: 'UNDO' |
| | | Taborder: 4 |
| | | Title: 'éç½®åæ¡£ï¼æµè¯ä¸ç¨ï¼' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 4 |
| | |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bDownload id:bDownload_141 |
| | | { |
| | | #keys: '[413988.0.1652609611]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Download' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component bImport id:bImport_217 |
| | | { |
| | | #keys: '[413988.0.1654241348]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Import' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component bDeductChangeoverLoss id:bDeductChangeoverLoss_737 |
| | | { |
| | | #keys: '[413988.0.1652941817]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Deduct changeover loss' |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | | Component bRestore id:bRestore_778 |
| | | { |
| | | #keys: '[413988.0.1654260514]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Restore' |
| | | Taborder: 4 |
| | | ] |
| | | } |
| | | Component bSaveAsDraft id:bSaveAsDraft_870 |
| | | { |
| | | #keys: '[413988.0.1654260654]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Save as draft' |
| | | Taborder: 5 |
| | | ] |
| | | } |
| | | Component bConfirm id:bConfirm_978 |
| | | { |
| | | #keys: '[413988.0.1654260807]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Confirm' |
| | | Taborder: 6 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: matrixeditorContextMenu229/mResetArchive |
| | | Response OnClick () id:Response_matrixeditorContextMenu229_mResetArchive_OnClick |
| | | { |
| | | #keys: '[413988.0.1657340921]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebMenu_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | MacroPlan.A_PreviousScenaioName( "" ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: matrixeditorContextMenu229/mShowOrHide |
| | | Response OnClick () id:Response_matrixeditorContextMenu229_mShowOrHide_OnClick |
| | | { |
| | | #keys: '[413988.0.1651491239]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebMenu_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | pTotal.Visible( not pTotal.Visible() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bConfirm_978 |
| | | Response OnClick () id:Response_pHeader_bConfirm_OnClick |
| | | { |
| | | #keys: '[413988.0.1657320536]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ) and not isnull( InterfaceDataset ) and MacroPlan.A_PreviousScenaioName() <> MacroPlan.ScenarioName() |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | // åæ¡£ |
| | | NewOfflinePlanCell::InterfaceArchive( MacroPlan, InterfaceDataset ); |
| | | |
| | | // 设置æé®ï¼é¤ä¸è½½ï¼ä¸å¯ç¨ |
| | | MacroPlan.A_PreviousScenaioName( MacroPlan.ScenarioName() ); |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bDeductChangeoverLoss_737 |
| | | Response OnClick () id:Response_pHeader_bDeductChangeoverLoss_OnClick |
| | | { |
| | | #keys: '[413988.0.1657320426]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ) and MacroPlan.A_PreviousScenaioName() <> MacroPlan.ScenarioName(); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bDownload_141 |
| | | Response OnClick () id:Response_pHeader1_799_bDownload_OnClick_870 |
| | | { |
| | | #keys: '[413988.0.1652609610]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | binaryValue := NewOfflinePlanCell::Download( MacroPlan, dhSelectedDetailNewOfflinePlanRow.Data() ); |
| | | |
| | | Application.Download( "Output plan.xlsx", binaryValue.AsBinaryData() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bImport_217 |
| | | Response OnClick () id:Response_pHeader1_799_bImport_OnClick_568 |
| | | { |
| | | #keys: '[413988.0.1654241347]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ) and MacroPlan.A_PreviousScenaioName() <> MacroPlan.ScenarioName(); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | try { |
| | | uploadJsonString := Application.GetFile(); |
| | | if ( uploadJsonString <> "" ) { |
| | | uploadJson := JSON::Parse( uploadJsonString ); |
| | | Archive::VerifyTheFileName( uploadJson ); |
| | | |
| | | fileName := uploadJson.Get( "name" ).GetString(); |
| | | base64String := uploadJson.Get( "data" ).GetString(); |
| | | |
| | | webFileBinaryData := BinaryData::FromBase64EncodedString( base64String ).AsBinaryValue(); |
| | | |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( RecycleBin, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource.ReadStructure(); |
| | | |
| | | selection := select( generalExcelImportAndExportDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, tempGEIAEDT.Name() = "Sheet1" ); |
| | | |
| | | NewOfflinePlanCell::Import( dhNewOfflinePlanTable.Data(), selection ); |
| | | |
| | | // åç»å é¤ |
| | | generalExcelImportAndExportDataSource.Delete(); |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | } |
| | | } onerror { |
| | | WebMessageBox::Error( e.GeneralInformation() ); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ); |
| | | return not isnull( MacroPlan ) and MacroPlan.A_PreviousScenaioName() <> MacroPlan.ScenarioName(); |
| | | *] |
| | | QuillAction |
| | | { |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bRestore_778 |
| | | Response OnClick () id:Response_pHeader1_799_bRestore_OnClick_141 |
| | | { |
| | | #keys: '[413988.0.1654260513]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ) and MacroPlan.A_PreviousScenaioName() <> MacroPlan.ScenarioName(); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | currentNOPT := dhNewOfflinePlanTable.Data(); |
| | | targetNOPT := maxselect( MacroPlan, NewOfflinePlanTable, tempNOPT, tempNOPT <> currentNOPT, tempNOPT.SaveDateTime() ); |
| | | if ( not isnull( targetNOPT ) ) { |
| | | currentNOPT.Delete(); |
| | | dhNewOfflinePlanTable.Data( targetNOPT ); |
| | | } |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bSaveAsDraft_870 |
| | | Response OnClick () id:Response_pHeader1_799_bSaveAsDraft_OnClick_870 |
| | | { |
| | | #keys: '[413988.0.1654260653]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ) and MacroPlan.A_PreviousScenaioName() <> MacroPlan.ScenarioName(); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | nopt := NewOfflinePlanCell::SaveAsDraft( MacroPlan, dhNewOfflinePlanTable.Data() ); |
| | | dhNewOfflinePlanTable.Data( nopt ); |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | { |
| | | #keys: '[413988.0.1296803057]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Children: |
| | | [ |
| | | Component mCreateData |
| | | { |
| | | #keys: '[413988.0.1652900385]' |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Image: 'DATA' |
| | | Taborder: 3 |
| | | Title: 'ææ°åå»ºæ°æ®æ¹æ³' |
| | | ] |
| | | } |
| | | Component mSparator |
| | | { |
| | | #keys: '[413988.0.1652900411]' |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Separator: true |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 4 |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: matrixeditorContextMenu204/mCreateData |
| | | Response OnClick () id:Response_matrixeditorContextMenu204_mCreateData_OnClick |
| | | { |
| | | #keys: '[413988.0.1652970833]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebMenu_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | NewOfflinePlanCell::CreateOldOfflinePlanData( MacroPlan ); |
| | | |
| | | opt := maxselect( MacroPlan, OfflinePlanTable, tempOPT, true, tempOPT.SaveDateTime() ); |
| | | dhOfflinePlanTable.Data( opt ); |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |