| | |
|---|
| | | unitrow := table.GetRow( unit, product.ID() ); |
|---|
| | | allrow := table.GetRow( allunit, product.ID() ); |
|---|
| | | pispips := selectsortedset( pisp, ProductInStockingPointInPeriod, pispip, pispip.Start() >= startofplanning and pispip.Start() < startofnextyear and pispip.Period_MP().TimeUnit() = Translations::MP_GlobalParameters_Day(), pispip.Start() ); |
|---|
| | | info( '-----------------------------------', isnull( allrow ), pispips.Size() ); |
|---|
| | | traverse( pispips, Elements, pispip ){ |
|---|
| | | info( '-----------------------------------', pispip.Start() ); |
|---|
| | | // info( '-----------------------------------', isnull( allrow ), pispips.Size() ); |
|---|
| | | traverse( pispips, Elements, pispip, pispip.Start() = startofplanning ){ |
|---|
| | | // info( '-----------------------------------', pispip.Start() ); |
|---|
| | | period := pispip.Period_MP(); |
|---|
| | | periodtime := period.Start().Date(); |
|---|
| | | periodname := periodtime.Format( "M2/D2/Y" ); |
|---|
| | | //天，选择日颗粒度时，期末库存，最小库存，最大库存和平均库存的数值保持一致 |
|---|
| | | daycolumn := selectobject( table, InventorySummaryColumn, column, column.Name() = periodname, column.Period() = periodtime, column.TimeUnit() = Translations::MP_GlobalParameters_Day() ); |
|---|
| | | info( daycolumn.Name(), daycolumn.Period(), daycolumn.TimeUnit() ); |
|---|
| | | unitrow.SetCellValue( daycolumn, pispip.PlannedInventoryLevelEnd() ); |
|---|
| | | allrow.SetCellValue( daycolumn, pispip.PlannedInventoryLevelEnd() ); |
|---|
| | | |
|---|
