private void printPageHtml(
HttpServletRequest request,
HttpServletResponse response,
VariablesSecureApp vars,
String strComparative,
String strDateFrom,
String strDateTo,
String strPartnerGroup,
String strcBpartnerId,
String strProductCategory,
String strmProductId,
String strNotShown,
String strShown,
String strDateFromRef,
String strDateToRef,
String strOrg,
String strsalesrepId,
String strmWarehouseId,
String strOrder,
String strMayor,
String strMenor,
String strRatioMayor,
String strRatioMenor,
String strCurrencyId)
throws IOException, ServletException {
if (log4j.isDebugEnabled()) log4j.debug("Output: print html");
XmlDocument xmlDocument = null;
String strOrderby = "";
String[] discard = {"", "", "", "", "", "", ""};
String[] discard1 = {
"selEliminarBody1",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard",
"discard"
};
if (strOrg.equals("")) strOrg = vars.getOrg();
if (strComparative.equals("Y")) discard1[0] = "selEliminarBody2";
String strTitle = "";
strTitle =
Utility.messageBD(this, "From", vars.getLanguage())
+ " "
+ strDateFrom
+ " "
+ Utility.messageBD(this, "To", vars.getLanguage())
+ " "
+ strDateTo;
if (!strPartnerGroup.equals(""))
strTitle =
strTitle
+ ", "
+ Utility.messageBD(this, "ForBPartnerGroup", vars.getLanguage())
+ " "
+ ReportRefundSalesDimensionalAnalysesData.selectBpgroup(this, strPartnerGroup);
if (!strProductCategory.equals(""))
strTitle =
strTitle
+ ", "
+ Utility.messageBD(this, "ProductCategory", vars.getLanguage())
+ " "
+ ReportRefundSalesDimensionalAnalysesData.selectProductCategory(
this, strProductCategory);
if (!strsalesrepId.equals(""))
strTitle =
strTitle
+ ", "
+ Utility.messageBD(this, "TheSalesRep", vars.getLanguage())
+ " "
+ ReportRefundSalesDimensionalAnalysesData.selectSalesrep(this, strsalesrepId);
if (!strmWarehouseId.equals(""))
strTitle =
strTitle
+ " "
+ Utility.messageBD(this, "And", vars.getLanguage())
+ " "
+ Utility.messageBD(this, "TheWarehouse", vars.getLanguage())
+ " "
+ ReportRefundSalesDimensionalAnalysesData.selectMwarehouse(this, strmWarehouseId);
ReportRefundSalesDimensionalAnalysesData[] data = null;
String[] strShownArray = {"", "", "", "", "", "", ""};
if (strShown.startsWith("(")) strShown = strShown.substring(1, strShown.length() - 1);
if (!strShown.equals("")) {
strShown = Replace.replace(strShown, "'", "");
strShown = Replace.replace(strShown, " ", "");
StringTokenizer st = new StringTokenizer(strShown, ",", false);
int intContador = 0;
while (st.hasMoreTokens()) {
strShownArray[intContador] = st.nextToken();
intContador++;
}
}
String[] strTextShow = {"", "", "", "", "", "", ""};
int intDiscard = 0;
int intAuxDiscard = -1;
for (int i = 0; i < 7; i++) {
if (strShownArray[i].equals("1")) {
strTextShow[i] = "C_BP_GROUP.NAME";
intDiscard++;
} else if (strShownArray[i].equals("2")) {
strTextShow[i] =
"AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char('"
+ vars.getLanguage()
+ "'))";
intDiscard++;
} else if (strShownArray[i].equals("3")) {
strTextShow[i] = "M_PRODUCT_CATEGORY.NAME";
intDiscard++;
} else if (strShownArray[i].equals("4")) {
strTextShow[i] =
"AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('"
+ vars.getLanguage()
+ "'))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END";
intAuxDiscard = i;
intDiscard++;
} else if (strShownArray[i].equals("5")) {
strTextShow[i] = "C_ORDER.DOCUMENTNO";
intDiscard++;
} else if (strShownArray[i].equals("6")) {
strTextShow[i] = "AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME";
intDiscard++;
} else if (strShownArray[i].equals("7")) {
strTextShow[i] = "M_WAREHOUSE.NAME";
intDiscard++;
} else {
strTextShow[i] = "''";
discard[i] = "display:none;";
}
}
if (intDiscard != 0 || intAuxDiscard != -1) {
int k = 1;
if (intDiscard == 1) {
strOrderby = " ORDER BY NIVEL" + k + ",";
} else {
strOrderby = " ORDER BY ";
}
while (k < intDiscard) {
strOrderby = strOrderby + "NIVEL" + k + ",";
k++;
}
if (k == 1) {
if (strOrder.equals("Normal")) {
strOrderby = " ORDER BY NIVEL" + k;
} else if (strOrder.equals("Amountasc")) {
strOrderby = " ORDER BY LINENETAMT ASC";
} else if (strOrder.equals("Amountdesc")) {
strOrderby = " ORDER BY LINENETAMT DESC";
} else if (strOrder.equals("Ratioasc")) {
strOrderby = " ORDER BY RATIO ASC";
} else if (strOrder.equals("Ratiodesc")) {
strOrderby = " ORDER BY RATIO DESC";
} else {
strOrderby = "1";
}
} else {
if (strOrder.equals("Normal")) {
strOrderby += "NIVEL" + k;
} else if (strOrder.equals("Amountasc")) {
strOrderby += "LINENETAMT ASC";
} else if (strOrder.equals("Amountdesc")) {
strOrderby += "LINENETAMT DESC";
} else if (strOrder.equals("Ratioasc")) {
strOrderby += "RATIO ASC";
} else if (strOrder.equals("Ratiodesc")) {
strOrderby += "RATIO DESC";
} else {
strOrderby = "1";
}
}
} else {
strOrderby = " ORDER BY 1";
}
String strHaving = "";
if (!strMayor.equals("") && !strMenor.equals("")) {
strHaving = " HAVING SUM(LINENETAMT) > " + strMayor + " AND SUM(LINENETAMT) < " + strMenor;
} else if (!strMayor.equals("") && strMenor.equals("")) {
strHaving = " HAVING SUM(LINENETAMT) > " + strMayor;
} else if (strMayor.equals("") && !strMenor.equals("")) {
strHaving = " HAVING SUM(LINENETAMT) < " + strMenor;
} else {
}
if (strHaving.equals("")) {
if (!strRatioMayor.equals("") && !strRatioMenor.equals("")) {
strHaving =
" HAVING C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 > "
+ strRatioMayor
+ " AND C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 < "
+ strRatioMenor;
} else if (!strRatioMayor.equals("") && strRatioMenor.equals("")) {
strHaving =
" HAVING C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 > "
+ strRatioMayor;
} else if (strRatioMayor.equals("") && !strRatioMenor.equals("")) {
strHaving =
" HAVING C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 < "
+ strRatioMenor;
} else {
}
} else {
if (!strRatioMayor.equals("") && !strRatioMenor.equals("")) {
strHaving +=
" AND C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 > "
+ strRatioMayor
+ " AND C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 < "
+ strRatioMenor;
} else if (!strRatioMayor.equals("") && strRatioMenor.equals("")) {
strHaving +=
" AND C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 > "
+ strRatioMayor;
} else if (strRatioMayor.equals("") && !strRatioMenor.equals("")) {
strHaving +=
" AND C_DIVIDE(SUM(REFUNDAMT), (SUM(LINENETAMT)+SUM(REFUNDAMT)))*100 < "
+ strRatioMenor;
} else {
}
}
strOrderby = strHaving + strOrderby;
// Checks if there is a conversion rate for each of the transactions of
// the report
String strConvRateErrorMsg = "";
OBError myMessage = null;
myMessage = new OBError();
if (strComparative.equals("Y")) {
try {
data =
ReportRefundSalesDimensionalAnalysesData.select(
this,
strCurrencyId,
strTextShow[0],
strTextShow[1],
strTextShow[2],
strTextShow[3],
strTextShow[4],
strTextShow[5],
strTextShow[6],
Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg),
Utility.getContext(
this, vars, "#User_Client", "ReportRefundInvoiceCustomerDimensionalAnalyses"),
strDateFrom,
DateTimeData.nDaysAfter(this, strDateTo, "1"),
strPartnerGroup,
strcBpartnerId,
strProductCategory,
strmProductId,
strsalesrepId,
strmWarehouseId,
strDateFromRef,
DateTimeData.nDaysAfter(this, strDateToRef, "1"),
strOrderby);
} catch (ServletException ex) {
myMessage = Utility.translateError(this, vars, vars.getLanguage(), ex.getMessage());
}
} else {
try {
data =
ReportRefundSalesDimensionalAnalysesData.selectNoComparative(
this,
strCurrencyId,
strTextShow[0],
strTextShow[1],
strTextShow[2],
strTextShow[3],
strTextShow[4],
strTextShow[5],
strTextShow[6],
Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg),
Utility.getContext(
this, vars, "#User_Client", "ReportRefundInvoiceCustomerDimensionalAnalyses"),
strDateFrom,
DateTimeData.nDaysAfter(this, strDateTo, "1"),
strPartnerGroup,
strcBpartnerId,
strProductCategory,
strmProductId,
strsalesrepId,
strmWarehouseId,
strOrderby);
} catch (ServletException ex) {
myMessage = Utility.translateError(this, vars, vars.getLanguage(), ex.getMessage());
}
}
strConvRateErrorMsg = myMessage.getMessage();
// If a conversion rate is missing for a certain transaction, an error
// message window pops-up.
if (!strConvRateErrorMsg.equals("") && strConvRateErrorMsg != null) {
advisePopUp(
request,
response,
"ERROR",
Utility.messageBD(this, "NoConversionRateHeader", vars.getLanguage()),
strConvRateErrorMsg);
} else { // Otherwise, the report is launched
if (data.length == 0 || data == null) {
data = ReportRefundSalesDimensionalAnalysesData.set();
} else {
int contador = intDiscard;
if (intAuxDiscard != -1) contador = intAuxDiscard;
int k = 1;
if (strComparative.equals("Y")) {
for (int j = contador; j > 0; j--) {
discard1[k] = "fieldTotalQtyNivel" + String.valueOf(j);
discard1[k + 12] = "fieldTotalRefundQtyNivel" + String.valueOf(j);
discard1[k + 24] = "fieldUomsymbol" + String.valueOf(j);
discard1[k + 6] = "fieldTotalRefQtyNivel" + String.valueOf(j);
discard1[k + 18] = "fieldTotalRefRefundQtyNivel" + String.valueOf(j);
k++;
}
} else {
for (int j = contador; j > 0; j--) {
discard1[k] = "fieldNoncomparativeTotalQtyNivel" + String.valueOf(j);
discard1[k + 10] = "fieldNoncomparativeTotalRefundQtyNivel" + String.valueOf(j);
discard1[k + 20] = "fieldNoncomparativeUomsymbol" + String.valueOf(j);
k++;
}
}
}
xmlDocument =
xmlEngine
.readXmlTemplate(
"org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEdition",
discard1)
.createXmlDocument();
xmlDocument.setParameter("directory", "var baseDirectory = \"" + strReplaceWith + "/\";\n");
xmlDocument.setParameter("language", "defaultLang=\"" + vars.getLanguage() + "\";");
xmlDocument.setParameter("theme", vars.getTheme());
xmlDocument.setParameter("eliminar2", discard[1]);
xmlDocument.setParameter("eliminar3", discard[2]);
xmlDocument.setParameter("eliminar4", discard[3]);
xmlDocument.setParameter("eliminar5", discard[4]);
xmlDocument.setParameter("eliminar6", discard[5]);
xmlDocument.setParameter("eliminar7", discard[6]);
xmlDocument.setParameter("title", strTitle);
String strCurISOSym = Utility.stringISOSymbol(this, strCurrencyId);
strCurISOSym = strCurISOSym.replace('(', ' ');
strCurISOSym = strCurISOSym.replace(')', ' ');
xmlDocument.setParameter("convisosym", strCurISOSym);
xmlDocument.setParameter("constante", "100");
if (strComparative.equals("Y")) {
xmlDocument.setData("structure1", data);
} else {
xmlDocument.setData("structure2", data);
}
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
out.println(xmlDocument.print());
out.close();
}
}
