Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090917-1447>
in
/templates/blank_report.gif
fixed layout
ltr
1
productPromoId
string
2
promoName
string
3
totalOrders
integer
4
totalOrdersAmount
float
5
totalShippingAmount
float
6
totalShippingCharge
float
7
totalShippingBalance
float
productPromoId
promoName
totalOrders
totalOrdersAmount
totalShippingAmount
totalShippingCharge
totalShippingBalance
1
productPromoId
string
2
promoName
string
3
totalOrders
integer
4
totalOrdersAmount
float
5
totalShippingAmount
float
6
totalShippingCharge
float
7
totalShippingBalance
float
OFBIZ
0){
productPromoCodeId = productPromoCodes.get(0).getString("productPromoCodeId");
orderProductPromoCodes = delegator.findList("OrderProductPromoCode", EntityCondition.makeCondition("productPromoCodeId", EntityOperator.EQUALS, productPromoCodeId), null, null, null, false);
totalOrders = orderProductPromoCodes.size();
for(i = 0; i < totalOrders; i++){
orderId = orderProductPromoCodes.get(i).getString("orderId");
input.put("userLogin",userLogin);
input.put("orderId",orderId);
//Order Total
orderInfo = dispatcher.runSync("getOrderHeaderInformation", input);
amount = orderInfo.get("grandTotal");
totalOrdersAmount = totalOrdersAmount + amount;
//Shipping Total
cond = FastList.newInstance();
cond.add(EntityCondition.makeCondition("orderId", EntityOperator.EQUALS, orderId));
cond.add(EntityCondition.makeCondition("orderAdjustmentTypeId", EntityOperator.EQUALS, "SHIPPING_CHARGES"));
orderAdjustments = delegator.findList("OrderAdjustment", EntityCondition.makeCondition(cond, EntityOperator.AND), null, null, null, false);
orderAdjustmentSize = orderAdjustments.size();
for(j = 0; j < orderAdjustmentSize; j++){
shippingCharge = 0;
shippingCharge = orderAdjustments.get(j).get("amount");
if(shippingCharge){
shippingCharge = shippingCharge.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
}
totalShippingCharge = totalShippingCharge + shippingCharge;
}
shippingAmount = dispatcher.runSync("getOrderShippingAmount", input);
amount = shippingAmount.get("shippingAmount");
if(amount){
amount = amount.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
}
totalShippingAmount = totalShippingAmount + amount;
}
}
row["productPromoId"] = productPromoId;
row["promoName"] = promoName;
row["totalOrders"] = totalOrders;
row["totalOrdersAmount"] = totalOrdersAmount;
row["totalShippingCharge"] = totalShippingCharge;
row["totalShippingAmount"] = totalShippingAmount;
row["totalShippingBalance"] = totalShippingAmount - totalShippingCharge;
countOfRow ++;
return true;]]>
NewTabularHierarchy
string
productPromoId
string
promoName
dataSetRow["totalOrders"]
integer
dataSetRow["totalOrdersAmount"]
float
dataSetRow["totalShippingCharge"]
float
dataSetRow["totalShippingAmount"]
float
dataSetRow["totalShippingBalance"]
float
CouponSalesReport
landscape
0.25in
0.4777777777777778in
0.4777777777777778in
html
new Date()]]>
|
right
0.2777777777777778in
2.3777777777777778in
1.788888888888889in
0.14444444444444443in
0.4444444444444444in
0.2777777777777778in
page-number
|
plain
|
left
total-page
|
|
16pt
bold
center
auto
totalOrders
Group/promoName
center
totalOrders_Group/promoName
0.3333333333333333in
0.5555555555555556in
#BFBFBF
bold
center
totalOrders
0.23333333333333334in
#BFBFBF
0.3in
Group/promoName
Fixed
Fixed
center
totalOrdersPercent
0.45555555555555555in
#BFBFBF
#BFBFBF
totalOrdersAmount
Group/promoName
Fixed
#,##0.00
right
totalOrdersAmount_Group/promoName
0.7555555555555555in
#BFBFBF
bold
Fixed
#,##0.00
right
totalOrdersAmount
#BFBFBF
Group/promoName
Fixed
Fixed
center
totalOrdersAmountPercent
0.4222222222222222in
#BFBFBF
#BFBFBF
totalShippingCharge
Group/promoName
right
totalShippingCharge_Group/promoName
1.6in
#BFBFBF
bold
right
totalShippingCharge
#BFBFBF
totalShippingAmount
Group/promoName
right
totalShippingAmount_Group/promoName
1.6555555555555554in
#BFBFBF
bold
right
totalShippingAmount
#BFBFBF
totalShippingBalance
Group/promoName
right
totalShippingBalance_Group/promoName
1.1777777777777778in
#BFBFBF
bold
right
totalShippingBalance
#BFBFBF
Group
Group/productPromoId
center
productPromoId
1.3777777777777778in
Group/promoName
promoName
2.3666666666666667in
after
#BFBFBF
CouponSalesReport
productPromoId
dimension["Group"]["productPromoId"]
string
promoName
dimension["Group"]["promoName"]
string
totalOrders_Group/promoName
measure["totalOrders"]
integer
Group/promoName
SUM
totalOrdersAmount_Group/promoName
measure["totalOrdersAmount"]
float
Group/promoName
SUM
totalShippingCharge_Group/promoName
measure["totalShippingCharge"]
float
Group/promoName
SUM
totalShippingAmount_Group/promoName
measure["totalShippingAmount"]
float
Group/promoName
SUM
totalShippingBalance_Group/promoName
measure["totalShippingBalance"]
float
Group/promoName
SUM
totalOrders
measure["totalOrders"]
integer
SUM
totalOrdersAmount
measure["totalOrdersAmount"]
float
SUM
totalShippingCharge
measure["totalShippingCharge"]
float
SUM
totalShippingAmount
measure["totalShippingAmount"]
float
SUM
totalShippingBalance
measure["totalShippingBalance"]
float
SUM
totalOrdersPercent
Finance.percent(data["totalOrders"], measure["totalOrders"])
float
totalOrdersAmountPercent
Finance.percent(data["totalOrdersAmount"], measure["totalOrdersAmount"])
float