Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408>
in
/templates/blank_report.gif
ltr
1
orderId
string
2
orderItemSeqId
string
3
orderStatus
string
4
saleChannel
string
5
quantity
string
6
extGrossAmount
string
7
orderDateDayOfMonth
string
8
orderDateMonthOfYear
string
9
orderDateYearName
string
10
price
string
11
stock
string
12
productId
string
13
internalName
string
orderId
orderItemSeqId
orderStatus
saleChannel
quantity
extGrossAmount
orderDateDayOfMonth
orderDateMonthOfYear
orderDateYearName
price
stock
productId
internalName
1
orderId
string
2
orderItemSeqId
string
3
orderStatus
string
4
saleChannel
string
5
quantity
string
6
extGrossAmount
string
7
orderDateDayOfMonth
string
8
orderDateMonthOfYear
string
9
orderDateYearName
string
10
price
string
11
stock
string
12
productId
string
13
internalName
string
OFBIZ
= totalRow) return false;
salesOrderItemStarSchema = salesOrderItemStarSchemas.get(countOfRow);
input = new HashMap();
input.put("productId", salesOrderItemStarSchema.getString("productProductId"));
input.put("userLogin", userLogin);
QOH = 0;
try {
result = dispatcher.runSync("getInventoryValuationList", input);
inventorys = result.get("inventoryValuationList");
QOH = inventorys.get(0).get("totalQuantityOnHand");
} catch (e) {
Debug.logError(e, module);
}
price = 0;
internalName = "None";
input = new HashMap();
try {
product = delegator.findOne("Product",UtilMisc.toMap("productId", salesOrderItemStarSchema.getString("productProductId")), false);
if(product!=null){
input.put("product", product);
input.put("userLogin", userLogin);
result = dispatcher.runSync("calculateProductPrice", input);
price = result.get("price");
if(product.get("internalName")){
internalName = product.get("internalName");
}
}
} catch (e) {
Debug.logError(e, module);
}
row["orderId"] = salesOrderItemStarSchema.getString("orderId");
row["orderItemSeqId"] = salesOrderItemStarSchema.getString("orderItemSeqId");
row["orderStatus"] = salesOrderItemStarSchema.getString("statusId");
row["saleChannel"] = salesOrderItemStarSchema.getString("salesChannelEnumId");
row["quantity"] = salesOrderItemStarSchema.getString("quantity");
row["extGrossAmount"] = salesOrderItemStarSchema.getString("extGrossAmount");
row["orderDateDayOfMonth"] = salesOrderItemStarSchema.getString("orderDateDayOfMonth");
row["orderDateMonthOfYear"] = salesOrderItemStarSchema.getString("orderDateMonthOfYear");
row["orderDateYearName"] = salesOrderItemStarSchema.getString("orderDateYearName");
row["price"] = price;
row["stock"] = QOH;
row["productId"]= salesOrderItemStarSchema.getString("productProductId");
row["internalName"] = internalName;
countOfRow ++;
return true;]]>
NewTabularHierarchy
string
productId
string
internalName
string
price
string
stock
string
orderDateMonthOfYear
count
dataSetRow["orderItemSeqId"]
integer
sum
dataSetRow["quantity"]
float
sum
dataSetRow["extGrossAmount"]
float
SalesOrderItemStarSchema
html
new Date()]]>
larger
bold
center
auto
DataCube
orderItemSeqId
Group/orderDateMonthOfYear
orderItemSeqId_Group/orderDateMonthOfYear
0.9888888888888889in
Group/productId
orderItemSeqId_Group/productId
orderItemSeqId
0.32222222222222224in
quantity
Group/orderDateMonthOfYear
quantity_Group/orderDateMonthOfYear
0.9888888888888889in
Group/productId
quantity_Group/productId
quantity
extGrossAmount
Group/orderDateMonthOfYear
extGrossAmount_Group/orderDateMonthOfYear
0.9888888888888889in
Group/productId
extGrossAmount_Group/productId
extGrossAmount
Group
Group/productId
productId
0.8777777777777778in
bold
right
productId_TOTAL
Group/internalName
internalName
2.3222222222222224in
Group/price
price
0.5666666666666667in
Group/stock
stock
0.6in
Group/orderDateMonthOfYear
orderDateMonthOfYear
0.5666666666666667in
after
4.844444444444444in
0.8333333333333334in
2.2888888888888888in
0.6in
0.5888888888888889in
0.5444444444444444in
bold
auto
|
bold
auto
|
bold
auto
|
bold
auto
|
bold
auto
|
productId
dimension["Group"]["productId"]
string
internalName
dimension["Group"]["internalName"]
string
price
dimension["Group"]["price"]
string
stock
dimension["Group"]["stock"]
string
orderDateMonthOfYear
dimension["Group"]["orderDateMonthOfYear"]
string
orderItemSeqId_Group/orderDateMonthOfYear
measure["orderItemSeqId"]
integer
Group/orderDateMonthOfYear
SUM
quantity_Group/orderDateMonthOfYear
measure["quantity"]
float
Group/orderDateMonthOfYear
SUM
extGrossAmount_Group/orderDateMonthOfYear
measure["extGrossAmount"]
float
Group/orderDateMonthOfYear
SUM
orderItemSeqId_Group/productId
measure["orderItemSeqId"]
integer
Group/productId
SUM
quantity_Group/productId
measure["quantity"]
float
Group/productId
SUM
extGrossAmount_Group/productId
measure["extGrossAmount"]
float
Group/productId
SUM
productId_TOTAL
dimension["Group"]["productId"]+" TOTAL"
string
orderItemSeqId
measure["orderItemSeqId"]
integer
SUM
quantity
measure["quantity"]
float
SUM
extGrossAmount
measure["extGrossAmount"]
float
SUM