svn commit: r902719 [4/6] - in /ofbiz/trunk/applications/orde
Locked
svn commit: r902719 [4/6] - in /ofbiz/trunk/applications/orde
 
|
Added: ofbiz/trunk/applications/order/webapp/ordermgr/reports/NetBeforeOverheadReport.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/webapp/ordermgr/reports/NetBeforeOverheadReport.rptdesign?rev=902719&view=auto ============================================================================== --- ofbiz/trunk/applications/order/webapp/ordermgr/reports/NetBeforeOverheadReport.rptdesign (added) +++ ofbiz/trunk/applications/order/webapp/ordermgr/reports/NetBeforeOverheadReport.rptdesign Mon Jan 25 07:23:57 2010 @@ -0,0 +1,5201 @@ +<?xml version="1.0" encoding="UTF-8"?> +<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1"> + <property name="createdBy">Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080226-1155></property> + <property name="units">in</property> + <property name="comments">Copyright (c) 2007 <<Your Company Name here>></property> + <html-property name="description">Creates a blank report with no predefined content.</html-property> + <list-property name="userProperties"> + <structure> + <property name="name">NBO Cube.NBO.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Cube.NBO.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Cube.Account.NewTabularHierarchy1.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Cube.Account.NewTabularHierarchy1.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Cube.NBO.width</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Cube.NBO.height</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Data Cube.NBO.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Data Cube.NBO.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Date Data Cube.NBO.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Date Data Cube.NBO.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Mouthly Data Cube.NBO_Monthly.x</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + <structure> + <property name="name">NBO Mouthly Data Cube.NBO_Monthly.y</property> + <property name="type">integer</property> + <property name="isVisible">false</property> + </structure> + </list-property> + <property name="NBO Cube.NBO.x">261</property> + <property name="NBO Cube.NBO.y">35</property> + <property name="NBO Cube.Account.NewTabularHierarchy1.x">10</property> + <property name="NBO Cube.Account.NewTabularHierarchy1.y">172</property> + <property name="NBO Cube.NBO.width">150</property> + <property name="NBO Cube.NBO.height">200</property> + <property name="NBO Data Cube.NBO.x">135</property> + <property name="NBO Data Cube.NBO.y">80</property> + <property name="NBO Date Data Cube.NBO.x">135</property> + <property name="NBO Date Data Cube.NBO.y">80</property> + <property name="NBO Mouthly Data Cube.NBO_Monthly.x">135</property> + <property name="NBO Mouthly Data Cube.NBO_Monthly.y">80</property> + <text-property name="displayName">Blank Report</text-property> + <property name="iconFile">/templates/blank_report.gif</property> + <parameters> + <scalar-parameter name="productStoreId" id="4755"> + <property name="valueType">static</property> + <property name="dataType">string</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="DateDay" id="226"> + <property name="valueType">static</property> + <property name="dataType">string</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="DateMonth" id="8"> + <property name="valueType">static</property> + <property name="dataType">integer</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="DateYear" id="4754"> + <property name="valueType">static</property> + <property name="dataType">integer</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="NunberDate" id="1122"> + <property name="valueType">static</property> + <property name="dataType">integer</property> + <property name="paramType">simple</property> + <property name="isRequired">false</property> + <property name="controlType">text-box</property> + <property name="distinct">true</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + </parameters> + <data-sources> + <script-data-source name="OFbiz" id="6"/> + </data-sources> + <data-sets> + <script-data-set name="NBO_Month" id="238"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">orderDateDateValue</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">Parcel</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">GS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">GMS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">GMP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">GSP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">GP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">eBay</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">eBay%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">RRC</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">RRC%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">Others</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">GP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">GMP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">NBO</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">18</property> + <property name="name">Monthly Projection</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">19</property> + <property name="name">Monthly Forecast</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">20</property> + <property name="name">Daily</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">21</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">22</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">23</property> + <property name="name">Date</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">24</property> + <property name="name">Month</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">25</property> + <property name="name">MonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">26</property> + <property name="name">Today</property> + <property name="dataType">string</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">SalesChannel</property> + <property name="displayName">SalesChannel</property> + </structure> + <structure> + <property name="columnName">orderDateMonthName</property> + <property name="displayName">orderDateMonthName</property> + </structure> + <structure> + <property name="columnName">orderDateDateValue</property> + <property name="displayName">orderDateDateValue</property> + </structure> + <structure> + <property name="columnName">Parcel</property> + <property name="displayName">Parcel</property> + </structure> + <structure> + <property name="columnName">GS</property> + <property name="displayName">GS</property> + </structure> + <structure> + <property name="columnName">GMS</property> + <property name="displayName">GMS</property> + </structure> + <structure> + <property name="columnName">GMP</property> + <property name="displayName">GMP</property> + </structure> + <structure> + <property name="columnName">GSP</property> + <property name="displayName">GSP</property> + </structure> + <structure> + <property name="columnName">GP</property> + <property name="displayName">GP</property> + </structure> + <structure> + <property name="columnName">eBay</property> + <property name="displayName">eBay</property> + </structure> + <structure> + <property name="columnName">eBay%</property> + <property name="displayName">eBay%</property> + </structure> + <structure> + <property name="columnName">RRC</property> + <property name="displayName">RRC</property> + </structure> + <structure> + <property name="columnName">RRC%</property> + <property name="displayName">RRC%</property> + </structure> + <structure> + <property name="columnName">Others</property> + <property name="displayName">Others</property> + </structure> + <structure> + <property name="columnName">GP%</property> + <property name="displayName">GP%</property> + </structure> + <structure> + <property name="columnName">GMP%</property> + <property name="displayName">GMP%</property> + </structure> + <structure> + <property name="columnName">NBO</property> + <property name="displayName">NBO</property> + </structure> + <structure> + <property name="columnName">Daily</property> + <property name="displayName">Daily</property> + </structure> + <structure> + <property name="columnName">Monthly Projection</property> + <property name="displayName">Monthly Projection</property> + </structure> + <structure> + <property name="columnName">Monthly Forecast</property> + <property name="displayName">Monthly Forecast</property> + </structure> + <structure> + <property name="columnName">Pod</property> + <property name="displayName">Pod</property> + </structure> + <structure> + <property name="columnName">Account</property> + <property name="displayName">Account</property> + </structure> + <structure> + <property name="columnName">Date</property> + <property name="displayName">Date</property> + </structure> + <structure> + <property name="columnName">Month</property> + <property name="displayName">Month</property> + </structure> + <structure> + <property name="columnName">MonthName</property> + <property name="displayName">MonthName</property> + </structure> + <structure> + <property name="columnName">Today</property> + <property name="displayName">Today</property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">orderDateDateValue</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">Parcel</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">GS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">GMS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">GMP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">GSP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">GP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">eBay</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">eBay%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">RRC</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">RRC%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">Others</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">GP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">GMP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">NBO</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">18</property> + <property name="name">Monthly Projection</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">19</property> + <property name="name">Monthly Forecast</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">20</property> + <property name="name">Daily</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">21</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">22</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">23</property> + <property name="name">Date</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">24</property> + <property name="name">Month</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">25</property> + <property name="name">MonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">26</property> + <property name="name">Today</property> + <property name="dataType">string</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFbiz</property> + <method name="open"><![CDATA[importPackage(Packages.org.ofbiz.minilang) +importPackage(Packages.org.ofbiz.minilang.method) +importPackage(Packages.org.ofbiz.base.util) +importPackage(Packages.org.eclipse.birt.report.engine.api) + +appContext = reportContext.getAppContext(); +classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY); +starschemas = null; +try +{ + productStoreId = params["productStoreId"].value; + DateMonth = params["DateMonth"].value; + DateYear = params["DateYear"].value; + methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE); + methodContext.putEnv("productStoreId", productStoreId); + methodContext.putEnv("DateMonth", DateMonth); + methodContext.putEnv("DateYear", DateYear); + SimpleMethod.runSimpleMethod("component://order/script/org/ofbiz/order/reports/NetBeforeOverheadEvent.xml", "getOrder", methodContext); + starschemas = methodContext.getEnv("starschemas"); +} +catch (e) +{ + Debug.logError(e,""); +} + +DateMonth = 12; +currentRow = 0; +totalRows = 0; +pod1 = "English"; +pod2 = "Latin"; +account_B2C_AU = "B2C-AU"; +account_B2C_CA = "B2C-CA"; +account_B2C_IE = "B2C-IE"; +account_B2C_SG = "B2C-SG"; +account_B2C_UK = "B2C-UK"; +account_B2C_US = "B2C-US"; +account_B2C_DE = "B2C-DE"; +account_B2C_ES = "B2C-ES"; +account_B2C_FR = "B2C-FR"; +account_B2C_IT = "B2C-IT"; + +if (starschemas) +{ + totalRows = starschemas.size(); +}]]></method> + <method name="fetch"><![CDATA[if (currentRow >= totalRows) return false; +{ + starschema = starschemas.get(currentRow); + orderDateDateValue = starschema.getString("orderDateDateValue"); + orderDateDayName = starschema.getString("orderDateDayName"); + orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth"); + orderDateMonthName = starschema.getString("orderDateMonthName"); + orderDateYearName = starschema.getString("orderDateYearName"); + orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay"); + orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear"); + orderDateDescription = starschema.getString("orderDateDescription"); + + quantity = starschema.getString("quantity"); + GS = starschema.getString("GrossSales"); + GMS = starschema.getString("GrossMerchandizeSales"); + GMP = starschema.getString("GrossMerchandizeProfit"); + GSP = starschema.getString("GrossShippingProfit"); + GP = starschema.getString("GrossProfit"); + eBay = starschema.getString("eBay"); + RRC = starschema.getString("RRC"); + Others = starschema.getString("OtherFree"); + NBO = starschema.getString("NBO"); + + salesChannelEnumId = starschema.getString("salesChannelEnumId"); + + if (orderDateMonthOfYear == DateMonth) + { + row["Daily"] = 1; + } + else + { + row["Daily"] = 2; + } + + if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_AU; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_CA; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_IE; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_SG; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_UK; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_US; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_DE; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_ES; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_FR; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_IT; + row["Date"] = orderDateYearMonthDay; + row["Month"] = orderDateMonthOfYear; + row["MonthName"] = orderDateMonthName; + row["Today"] = DateDay; + } + + currentRow ++; +} + +return true;]]></method> + </script-data-set> + <script-data-set name="NBO_Date" id="2898"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateDayOfMonth</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">orderDateYearName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">orderDateDateValue</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">Parcel</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">GS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">GMS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">GMP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">GSP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">GP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">eBay</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">eBay%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">RRC</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">RRC%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">Others</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">GP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">18</property> + <property name="name">GMP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">19</property> + <property name="name">NBO</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">20</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">21</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">22</property> + <property name="name">Date</property> + <property name="dataType">string</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">SalesChannel</property> + <property name="displayName">SalesChannel</property> + </structure> + <structure> + <property name="columnName">orderDateDayOfMonth</property> + <property name="displayName">orderDateDayOfMonth</property> + </structure> + <structure> + <property name="columnName">orderDateMonthName</property> + <property name="displayName">orderDateMonthName</property> + </structure> + <structure> + <property name="columnName">orderDateYearName</property> + <property name="displayName">orderDateYearName</property> + </structure> + <structure> + <property name="columnName">orderDateDateValue</property> + <property name="displayName">orderDateDateValue</property> + </structure> + <structure> + <property name="columnName">Parcel</property> + <property name="displayName">Parcel</property> + </structure> + <structure> + <property name="columnName">GS</property> + <property name="displayName">GS</property> + </structure> + <structure> + <property name="columnName">GMS</property> + <property name="displayName">GMS</property> + </structure> + <structure> + <property name="columnName">GMP</property> + <property name="displayName">GMP</property> + </structure> + <structure> + <property name="columnName">GSP</property> + <property name="displayName">GSP</property> + </structure> + <structure> + <property name="columnName">eBay</property> + <property name="displayName">eBay</property> + </structure> + <structure> + <property name="columnName">RRC</property> + <property name="displayName">RRC</property> + </structure> + <structure> + <property name="columnName">Others</property> + <property name="displayName">Others</property> + </structure> + <structure> + <property name="columnName">Pod</property> + <property name="displayName">Pod</property> + </structure> + <structure> + <property name="columnName">Account</property> + <property name="displayName">Account</property> + </structure> + <structure> + <property name="columnName">Date</property> + <property name="displayName">Date</property> + </structure> + <structure> + <property name="columnName">NBO</property> + <property name="displayName">NBO</property> + </structure> + <structure> + <property name="columnName">eBay%</property> + <property name="displayName">eBay%</property> + </structure> + <structure> + <property name="columnName">RRC%</property> + <property name="displayName">RRC%</property> + </structure> + <structure> + <property name="columnName">GP%</property> + <property name="displayName">GP%</property> + </structure> + <structure> + <property name="columnName">GMP%</property> + <property name="displayName">GMP%</property> + </structure> + <structure> + <property name="columnName">GP</property> + <property name="displayName">GP</property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateDayOfMonth</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">orderDateYearName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">orderDateDateValue</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">Parcel</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">GS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">GMS</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">GMP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">GSP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">GP</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">eBay</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">eBay%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">RRC</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">RRC%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">Others</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">GP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">18</property> + <property name="name">GMP%</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">19</property> + <property name="name">NBO</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">20</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">21</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">22</property> + <property name="name">Date</property> + <property name="dataType">string</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFbiz</property> + <method name="open"><![CDATA[importPackage(Packages.org.ofbiz.minilang) +importPackage(Packages.org.ofbiz.minilang.method) +importPackage(Packages.org.ofbiz.base.util) +importPackage(Packages.org.eclipse.birt.report.engine.api) + +appContext = reportContext.getAppContext(); +classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY); +starschemas = null; +try +{ + productStoreId = params["productStoreId"].value; + DateDay = params["DateDay"].value; + methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE); + methodContext.putEnv("productStoreId", productStoreId); + methodContext.putEnv("DateDay", DateDay); + SimpleMethod.runSimpleMethod("component://order/script/org/ofbiz/order/reports/NetBeforeOverheadDateEvent.xml", "getOrder", methodContext); + Date_starschemas = methodContext.getEnv("Date_starschemas"); +} +catch (e) +{ + Debug.logError(e,""); +} + +currentRow = 0; +totalRows = 0; +pod1 = "English"; +pod2 = "Latin"; +account_B2C_AU = "B2C-AU"; +account_B2C_CA = "B2C-CA"; +account_B2C_IE = "B2C-IE"; +account_B2C_SG = "B2C-SG"; +account_B2C_UK = "B2C-UK"; +account_B2C_US = "B2C-US"; +account_B2C_DE = "B2C-DE"; +account_B2C_ES = "B2C-ES"; +account_B2C_FR = "B2C-FR"; +account_B2C_IT = "B2C-IT"; + +if (Date_starschemas) +{ + totalRows = Date_starschemas.size(); +}]]></method> + <method name="fetch"><![CDATA[if (currentRow >= totalRows) return false; +{ + Date_starschema = Date_starschemas.get(currentRow); + orderDateDateValue = Date_starschema.getString("orderDateDateValue"); + orderDateDayName = Date_starschema.getString("orderDateDayName"); + orderDateDayOfMonth = Date_starschema.getString("orderDateDayOfMonth"); + orderDateMonthName = Date_starschema.getString("orderDateMonthName"); + orderDateYearName = Date_starschema.getString("orderDateYearName"); + orderDateYearMonthDay = Date_starschema.getString("orderDateYearMonthDay"); + orderDateMonthOfYear = Date_starschema.getString("orderDateMonthOfYear"); + orderDateDescription = Date_starschema.getString("orderDateDescription"); + + quantity = Date_starschema.getString("quantity"); + GS = Date_starschema.getString("GrossSales"); + GMS = Date_starschema.getString("GrossMerchandizeSales"); + GMP = Date_starschema.getString("GrossMerchandizeProfit"); + GSP = Date_starschema.getString("GrossShippingProfit"); + GP = Date_starschema.getString("GrossProfit"); + eBay = Date_starschema.getString("eBay"); + RRC = Date_starschema.getString("RRC"); + Others = Date_starschema.getString("OtherFree"); + NBO = Date_starschema.getString("NBO"); + + salesChannelEnumId = Date_starschema.getString("salesChannelEnumId"); + + if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_AU; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_CA; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_IE; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_SG; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_UK; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod1; + row["Account"] = account_B2C_US; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_DE; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_ES; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_FR; + row["Date"] = orderDateYearMonthDay; + } + if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateDayOfMonth"] = orderDateDayOfMonth; + row["orderDateMonthName"] = orderDateMonthName; + row["orderDateYearName"] = orderDateYearName; + row["orderDateDateValue"] = orderDateDateValue; + row["Parcel"] = quantity; + row["GS"] = GS; + row["GMS"] = GMS; + row["GMP"] = GMP; + row["GSP"] = GSP; + row["GP"] = GP; + row["eBay"] = eBay; + row["RRC"] = RRC; + row["Others"] = Others; + row["NBO"] = NBO; + row["Pod"] = pod2; + row["Account"] = account_B2C_IT; + row["Date"] = orderDateYearMonthDay; + } + + currentRow ++; +} + +return true;]]></method> + </script-data-set> + <script-data-set name="NBO_Monthly" id="4650"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">NBO</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">CountDate</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">Monthly Forecast</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">SalesChannel</property> + <property name="displayName">SalesChannel</property> + </structure> + <structure> + <property name="columnName">orderDateMonthName</property> + <property name="displayName">orderDateMonthName</property> + </structure> + <structure> + <property name="columnName">Pod</property> + <property name="displayName">Pod</property> + </structure> + <structure> + <property name="columnName">Account</property> + <property name="displayName">Account</property> + </structure> + <structure> + <property name="columnName">NBO</property> + <property name="displayName">NBO</property> + </structure> + <structure> + <property name="columnName">CountDate</property> + <property name="displayName">CountDate</property> + </structure> + <structure> + <property name="columnName">Monthly Forecast</property> + <property name="displayName">Monthly Forecast</property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">SalesChannel</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">Pod</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">Account</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">NBO</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">CountDate</property> + <property name="dataType">integer</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">Monthly Forecast</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFbiz</property> + <method name="open"><![CDATA[importPackage(Packages.org.ofbiz.minilang) +importPackage(Packages.org.ofbiz.minilang.method) +importPackage(Packages.org.ofbiz.base.util) +importPackage(Packages.org.eclipse.birt.report.engine.api) + +appContext = reportContext.getAppContext(); +classLoader = appContext.get(EngineConstants.APPCONTEXT_CLASSLOADER_KEY); +starschemas = null; +try +{ + productStoreId = params["productStoreId"].value; + DateMonth = params["DateMonth"].value; + DateYear = params["DateYear"].value; + methodContext = new MethodContext(appContext, classLoader, MethodContext.SERVICE); + methodContext.putEnv("productStoreId", productStoreId); + methodContext.putEnv("DateMonth", DateMonth); + methodContext.putEnv("DateYear", DateYear); + SimpleMethod.runSimpleMethod("component://order/script/org/ofbiz/order/reports/NetBeforeOverheadMonthlyEvent.xml", "getOrder", methodContext); + starschemas = methodContext.getEnv("starschemas"); +} +catch (e) +{ + Debug.logError(e,""); +} + +currentRow = 0; +totalRows = 0; +pod1 = "English"; +pod2 = "Latin"; +account_B2C_AU = "B2C-AU"; +account_B2C_CA = "B2C-CA"; +account_B2C_IE = "B2C-IE"; +account_B2C_SG = "B2C-SG"; +account_B2C_UK = "B2C-UK"; +account_B2C_US = "B2C-US"; +account_B2C_DE = "B2C-DE"; +account_B2C_ES = "B2C-ES"; +account_B2C_FR = "B2C-FR"; +account_B2C_IT = "B2C-IT"; + +if (starschemas) +{ + totalRows = starschemas.size(); +}]]></method> + <method name="fetch"><![CDATA[if (currentRow >= totalRows) return false; +{ + starschema = starschemas.get(currentRow); + + salesChannelEnumId = starschema.getString("salesChannelEnumId"); + orderDateMonthName = starschema.getString("orderDateMonthName"); + orderDateYearName = starschema.getString("orderDateYearName"); + NBO = starschema.getString("NBO"); + CountDate = starschema.getString("CountDate"); + + if (salesChannelEnumId == "B2C_AU_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod1; + row["Account"] = account_B2C_AU; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_CA_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod1; + row["Account"] = account_B2C_CA; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_IE_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod1; + row["Account"] = account_B2C_IE; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_SG_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod1; + row["Account"] = account_B2C_SG; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_UK_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod1; + row["Account"] = account_B2C_UK; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_US_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod1; + row["Account"] = account_B2C_US; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_DE_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod2; + row["Account"] = account_B2C_DE; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_ES_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod2; + row["Account"] = account_B2C_ES; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_FR_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod2; + row["Account"] = account_B2C_FR; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + if (salesChannelEnumId == "B2C_IT_SALES_CHANNEL") + { + row["SalesChannel"] = salesChannelEnumId; + row["orderDateMonthName"] = orderDateMonthName; + row["Pod"] = pod2; + row["Account"] = account_B2C_IT; + row["NBO"] = NBO; + row["CountDate"] = CountDate; + } + + currentRow ++; +} + +return true;]]></method> + </script-data-set> + </data-sets> + <cubes> + <tabular-cube name="NBO Month Data Cube" id="1263"> + <property name="defaultMeasureGroup">NBO Summary Field</property> + <property name="dimensions"> + <tabular-dimension name="Date" id="1264"> + <property name="isTimeType">false</property> + <property name="defaultHierarchy">NewTabularHierarchy</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy" id="1265"> + <property name="levels"> + <tabular-level name="Today" id="2399"> + <property name="dataType">string</property> + <property name="columnName">Today</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + <tabular-dimension name="Account" id="1267"> + <property name="defaultHierarchy">NewTabularHierarchy1</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy1" id="1268"> + <property name="levels"> + <tabular-level name="Pod" id="1270"> + <property name="dataType">string</property> + <property name="columnName">Pod</property> + </tabular-level> + <tabular-level name="Account" id="1271"> + <property name="dataType">string</property> + <property name="columnName">Account</property> + </tabular-level> + <tabular-level name="Daily" id="1783"> + <property name="dataType">integer</property> + <property name="levelType">dynamic</property> + <list-property name="attributes"> + <structure> + <property name="name">orderDateMonthName</property> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="columnName">Daily</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + </property> + <property name="measureGroups"> + <tabular-measure-group name="NBO Summary Field" id="1733"> + <property name="measures"> + <tabular-measure name="Parcel" id="1734"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["Parcel"]</expression> + <property name="dataType">integer</property> + </tabular-measure> + <tabular-measure name="GS" id="1735"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["GS"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GMP" id="1737"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["GMP"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GSP" id="1738"> + <property name="function">average</property> + <property name="isCalculated">false</property> + <expression name="measureExpression">dataSetRow["GSP"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GP" id="1739"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["GP"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="eBay" id="1953"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["eBay"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="eBay%" id="2218"> + <property name="function">average</property> + <expression name="measureExpression">(dataSetRow["eBay"]/dataSetRow["GP"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="RRC" id="1955"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["RRC"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="RRC%" id="2274"> + <property name="function">average</property> + <property name="isCalculated">false</property> + <expression name="measureExpression">(dataSetRow["RRC"]/dataSetRow["GP"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="Others" id="1957"> + <property name="function">average</property> + <property name="isCalculated">false</property> + <expression name="measureExpression">dataSetRow["Others"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GP%" id="2285"> + <property name="function">average</property> + <expression name="measureExpression">(dataSetRow["GP"]/dataSetRow["GS"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GMP%" id="2286"> + <property name="function">average</property> + <expression name="measureExpression">(dataSetRow["GMP"]/dataSetRow["GMS"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="NBO" id="2287"> + <property name="function">average</property> + <expression name="measureExpression">dataSetRow["NBO"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + </property> + </tabular-measure-group> + </property> + <property name="dataSet">NBO_Month</property> + </tabular-cube> + <tabular-cube name="NBO Date Data Cube" id="3883"> + <property name="defaultMeasureGroup">NBO_Today Summary Field</property> + <property name="dimensions"> + <tabular-dimension name="Date_Today" id="3884"> + <property name="defaultHierarchy">NewTabularHierarchy2</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy2" id="3885"> + <property name="levels"> + <tabular-level name="orderDateDateValue" id="3886"> + <property name="dataType">string</property> + <property name="columnName">orderDateDateValue</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + <tabular-dimension name="Account_Today" id="3887"> + <property name="defaultHierarchy">NewTabularHierarchy3</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy3" id="3888"> + <property name="levels"> + <tabular-level name="Pod" id="3889"> + <property name="dataType">string</property> + <property name="columnName">Pod</property> + </tabular-level> + <tabular-level name="Account" id="3890"> + <property name="dataType">string</property> + <property name="columnName">Account</property> + </tabular-level> + <tabular-level name="Date" id="3891"> + <property name="dataType">string</property> + <property name="columnName">Date</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + </property> + <property name="measureGroups"> + <tabular-measure-group name="NBO_Today Summary Field" id="3892"> + <property name="measures"> + <tabular-measure name="Parcel1" id="3893"> + <expression name="measureExpression">dataSetRow["Parcel"]</expression> + <property name="dataType">integer</property> + </tabular-measure> + <tabular-measure name="GS1" id="3894"> + <expression name="measureExpression">dataSetRow["GS"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GMP1" id="4051"> + <expression name="measureExpression">dataSetRow["GMP"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GSP1" id="4052"> + <expression name="measureExpression">dataSetRow["GSP"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GP1" id="4053"> + <expression name="measureExpression">dataSetRow["GP"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="eBay1" id="4054"> + <expression name="measureExpression">dataSetRow["eBay"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="eBay%1" id="4055"> + <expression name="measureExpression">(dataSetRow["eBay"]/dataSetRow["GP"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="RRC1" id="4056"> + <expression name="measureExpression">dataSetRow["RRC"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="RRC%1" id="4057"> + <expression name="measureExpression">(dataSetRow["RRC"]/dataSetRow["GP"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="Others1" id="4058"> + <expression name="measureExpression">dataSetRow["Others"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GP%1" id="4059"> + <expression name="measureExpression">(dataSetRow["GP"]/dataSetRow["GS"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="GMP%1" id="4060"> + <expression name="measureExpression">(dataSetRow["GMP"]/dataSetRow["GMS"])</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="NBO1" id="4061"> + <expression name="measureExpression">dataSetRow["NBO"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + </property> + </tabular-measure-group> + </property> + <property name="dataSet">NBO_Date</property> + </tabular-cube> + <tabular-cube name="NBO Mouthly Data Cube" id="4651"> + <property name="defaultMeasureGroup">NBO MonthlySummary Field</property> + <property name="dimensions"> + <tabular-dimension name="Monthly" id="4656"> + <property name="defaultHierarchy">NewTabularHierarchy6</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy6" id="4657"> + <property name="levels"> + <tabular-level name="orderDateMonthName" id="4658"> + <property name="dataType">string</property> + <property name="columnName">orderDateMonthName</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + <tabular-dimension name="Accounts" id="4659"> + <property name="defaultHierarchy">NewTabularHierarchy7</property> + <property name="hierarchies"> + <tabular-hierarchy name="NewTabularHierarchy7" id="4660"> + <property name="levels"> + <tabular-level name="Pod" id="4661"> + <property name="dataType">string</property> + <property name="columnName">Pod</property> + </tabular-level> + <tabular-level name="Account" id="4662"> + <property name="dataType">string</property> + <property name="columnName">Account</property> + </tabular-level> + </property> + </tabular-hierarchy> + </property> + </tabular-dimension> + </property> + <property name="measureGroups"> + <tabular-measure-group name="NBO MonthlySummary Field" id="4663"> + <property name="measures"> + <tabular-measure name="NBO Monthly" id="4664"> + <property name="function">sum</property> + <expression name="measureExpression">dataSetRow["NBO"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="Monthly Projection" id="4666"> + <expression name="measureExpression">(dataSetRow["NBO"]/dataSetRow["CountDate"])*params["NunberDate"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + <tabular-measure name="Monthly Forecast" id="4667"> + <expression name="measureExpression">dataSetRow["Monthly Forecast"]</expression> + <property name="dataType">decimal</property> + </tabular-measure> + </property> + </tabular-measure-group> + </property> + <property name="dataSet">NBO_Monthly</property> + </tabular-cube> + </cubes> + <styles> + <style name="crosstab-cell" id="4"> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> [... 3226 lines stripped ...] |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |