1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
| Quintiq file version 2.0
| #parent: #root
| Method GenerateCell (
| InventoryPointSelections selections,
| Strings ccstockingpointids,
| Strings dlstockingpointids,
| InventorySummaryReport table,
| Date start,
| Date end,
| String productid,
| String allunit,
| String ccunit,
| String dlunit
| )
| {
| TextBody:
| [*
| // 甄兰鸽 Jul-3-2024 (created)
| //All
| alldetails := selectset( selections, Elements.InventoryInterfaceDataDetail, detail, detail.PartNumber() = productid and detail.Date() >= start and detail.Date() <= end );
| if( alldetails.Size() > 0 ){
| allrow := table.GetRow( allunit, productid );
| allvalue := sum( alldetails, Elements, e, [Number]e.Quantity() );
| allrow.SetCellValue( this, allvalue );
| //长春
| ccdetails := selectset( alldetails, Elements, detail, ccstockingpointids.Find( detail.InventoryPointSelection().StockpoingPoint() ) >= 0 );
| if( ccdetails.Size() > 0 ){
| ccrow := table.GetRow( ccunit, productid );
| value := sum( ccdetails, Elements, e, [Number]e.Quantity() );
| ccrow.SetCellValue( this, value );
| }
| //大连
| dldetails := selectset( alldetails, Elements, detail, dlstockingpointids.Find( detail.InventoryPointSelection().StockpoingPoint() ) >= 0 );
| if( dldetails.Size() > 0 ){
| dlrow := table.GetRow( dlunit, productid );
| value := sum( dldetails, Elements, e, [Number]e.Quantity() );
| dlrow.SetCellValue( this, value );
| }
| }
| *]
| }
|
|
