| | |
| | | yearcell.AllCost( yearcell.EstimateTotalCost() * [Real]yearcell.CoefficientValue() ); |
| | | } |
| | | } |
| | | Transaction::Transaction().Propagate( attribute( CCEngineLogisticsCostCell, EstimateTotalCost ) ); |
| | | traverse( yearcolumn, Cell, cell ){ |
| | | cell.AllCost( cell.EstimateTotalCost() * [Real]cell.CoefficientValue() ); |
| | | } |
| | | traverse( sumrow, Cell, cell ){ |
| | | cell.AllCost( cell.EstimateTotalCost() * [Real]cell.CoefficientValue() ); |
| | | if( exists( cell.Column(), Cell, acell, acell.IsUpdate() ) ){ |
| | |
| | | yearcell.AllCost( yearcell.EstimateTotalCost() * [Real]yearcell.CoefficientValue() ); |
| | | } |
| | | } |
| | | |
| | | Transaction::Transaction().Propagate( attribute( DLEngineLogisticsCostCell, EstimateTotalCost ) ); |
| | | traverse( yearcolumn, Cell, cell ){ |
| | | cell.AllCost( cell.EstimateTotalCost() * [Real]cell.CoefficientValue() ); |
| | | } |
| | | traverse( sumrow, Cell, cell ){ |
| | | cell.AllCost( cell.EstimateTotalCost() * [Real]cell.CoefficientValue() ); |
| | | if( exists( cell.Column(), Cell, acell, acell.IsUpdate() ) ){ |
| | |
| | | } |
| | | } |
| | | if( timeunit = 'All' or timeunit = Translations::MP_GlobalParameters_Week() ){ |
| | | weekstartstr := ' KW'; |
| | | for( start := startdate; start <= enddate; start := start.StartOfNextWeek() ){ |
| | | weekend := ( start.StartOfNextWeek() - Duration::Days( 1 ) ).Date(); |
| | | weekend := ( start.StartOfNextWeek() - Duration::Days( 1 ) ).Date();//Name := weekend.Format( "M2/D2/Y" ) |
| | | |
| | | this.Column( relnew, Name := weekend.Format( "M2/D2/Y" ), StartDate := start, EndDate := weekend, TimeUnit := Translations::MP_GlobalParameters_Week() ); |
| | | this.Column( relnew, Name := weekstartstr.Concat( weekend.Week().Format( 'N(LPad0(2))' ) ), StartDate := start, EndDate := weekend, TimeUnit := Translations::MP_GlobalParameters_Week() ); |
| | | } |
| | | } |
| | | } |
| | |
| | | }else if( timeunit = Translations::MP_GlobalParameters_Week() ){ |
| | | weekstartstr := ' KW'; |
| | | for( start := starttime; start <= endtime; start := start.StartOfNextWeek() ){ |
| | | weekend := ( start.StartOfNextWeek() - Duration::Days( 1 ) ).Date(); |
| | | weekend := ( start.StartOfNextWeek() - Duration::Days( 1 ) ).Date();//weekend.Format( "M2/D2/Y" ).Concat( weekstartstr.Concat( weekend.Week().Format( 'N(LPad0(2))' ) ) ) |
| | | |
| | | this.InventorySummaryColumn( relnew, Name := weekend.Format( "M2/D2/Y" ).Concat( weekstartstr.Concat( weekend.Week().Format( 'N(LPad0(2))' ) ) ), StartDate := start.Date(), EndaDate := weekend, TimeUnit := Translations::MP_GlobalParameters_Week() ); |
| | | this.InventorySummaryColumn( relnew, Name := weekstartstr.Concat( weekend.Week().Format( 'N(LPad0(2))' ) ), StartDate := start.Date(), EndaDate := weekend, TimeUnit := Translations::MP_GlobalParameters_Week() ); |
| | | } |
| | | }else if( timeunit = Translations::MP_GlobalParameters_Month() ){ |
| | | for( start := starttime; start <= endtime; start := start.StartOfNextMonth() ){ |
| | | monthend := ( start.StartOfNextMonth() - Duration::Days( 1 ) ).Date(); |
| | | monthend := ( start.StartOfNextMonth() - Duration::Days( 1 ) ).Date();//monthend.Format( "M2/D2/Y" ).Concat( ' ' ).Concat( monthend.Format( "MM", us_locale ).Concat( '/').Concat( [String]monthend.Month() ).Concat( '月' ) ) |
| | | us_locale := Locale::Construct( 'en_us' ); |
| | | this.InventorySummaryColumn( relnew, Name := monthend.Format( "M2/D2/Y" ).Concat( ' ' ).Concat( monthend.Format( "MM", us_locale ).Concat( '/').Concat( [String]monthend.Month() ).Concat( '月' ) ), StartDate := start.Date(), EndaDate := monthend, TimeUnit := Translations::MP_GlobalParameters_Month() ); |
| | | this.InventorySummaryColumn( relnew, Name := monthend.Format( "MM", us_locale ).Concat( '/').Concat( [String]monthend.Month() ).Concat( '月' ), StartDate := start.Date(), EndaDate := monthend, TimeUnit := Translations::MP_GlobalParameters_Month() ); |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | } |
| | | if( timeunit = 'All' or timeunit = Translations::MP_GlobalParameters_Week() ){ |
| | | weekstartstr := ' KW'; |
| | | for( start := startdate; start <= enddate; start := start.StartOfNextWeek() ){ |
| | | weekend := ( start.StartOfNextWeek() - Duration::Days( 1 ) ).Date(); |
| | | weekend := ( start.StartOfNextWeek() - Duration::Days( 1 ) ).Date();// weekend.Format( "M2/D2/Y" ) |
| | | |
| | | this.Column( relnew, Name := weekend.Format( "M2/D2/Y" ), StartDate := start, EndDate := weekend, TimeUnit := Translations::MP_GlobalParameters_Week() ); |
| | | this.Column( relnew, Name := weekstartstr.Concat( weekend.Week().Format( 'N(LPad0(2))' ) ), StartDate := start, EndDate := weekend, TimeUnit := Translations::MP_GlobalParameters_Week() ); |
| | | } |
| | | } |
| | | } |
| | |
| | | tcel.WerkToRentTransCost( cell.WerkToRentTransCost() ); |
| | | tcel.RentStorCost( cell.RentStorCost() ); |
| | | tcel.CoefficientValue( cell.CoefficientValue() ); |
| | | estimatetotalcost := tcel.RentInCost() + tcel.RentOutOfCost() + tcel.WerkToRentTransCost() + tcel.RentStorCost(); |
| | | tcel.AllCost( estimatetotalcost * [Real]tcel.CoefficientValue() ); |
| | | } |
| | | } |
| | | *] |
| | |
| | | tcel.DLRentStorCost( cell.DLRentStorCost() ); |
| | | tcel.WerkToDLRentTransCost( cell.WerkToDLRentTransCost() ); |
| | | tcel.CoefficientValue( cell.CoefficientValue() ); |
| | | estimatetotalcost := tcel.CCRentInCost() + tcel.CCRentOutOfCost() + tcel.CCLongTransCost() + tcel.CCRentStorCost() + tcel.CCShorTransCost() + tcel.DLRentInCost() + tcel.DLRentOutOfCost() + tcel.DLRentOtherCost() + tcel.DLRentStorCost() + tcel.WerkToDLRentTransCost(); |
| | | tcel.AllCost( estimatetotalcost * [Real]tcel.CoefficientValue() ); |
| | | } |
| | | } |
| | | *] |