"A.LANGUAGE_CODE=? and SAL02_ITEM_PRICES.COMPANY_CODE_SYS01=? and ITM01_ITEMS.ENABLED='Y' and "+
"SAL02_ITEM_PRICES.PRICELIST_CODE_SAL01='"+vo.getPricelistCodeSAL01()+"' AND "+
"REG03_CURRENCIES.CURRENCY_CODE=SAL01_PRICELISTS.CURRENCY_CODE_REG03";
}
else {
DetailItemVO vo = (DetailItemVO)gridParams.getOtherGridParams().get(ApplicationConsts.ITEM);
companyCodeSYS01 = vo.getCompanyCodeSys01ITM01();
sql =
"select SAL02_ITEM_PRICES.COMPANY_CODE_SYS01,SAL02_ITEM_PRICES.PRICELIST_CODE_SAL01,SAL02_ITEM_PRICES.ITEM_CODE_ITM01,SAL02_ITEM_PRICES.VALUE,SAL02_ITEM_PRICES.START_DATE,SAL02_ITEM_PRICES.END_DATE,B.DESCRIPTION,"+
"ITM01_ITEMS.USE_VARIANT_1,ITM01_ITEMS.USE_VARIANT_2,ITM01_ITEMS.USE_VARIANT_3,ITM01_ITEMS.USE_VARIANT_4,ITM01_ITEMS.USE_VARIANT_5, "+
"REG03_CURRENCIES.CURRENCY_SYMBOL,REG03_CURRENCIES.DECIMALS "+
" from SAL02_ITEM_PRICES,SYS10_COMPANY_TRANSLATIONS B,SAL01_PRICELISTS,ITM01_ITEMS,REG03_CURRENCIES where "+
"SAL02_ITEM_PRICES.COMPANY_CODE_SYS01=SAL01_PRICELISTS.COMPANY_CODE_SYS01 and "+
"SAL02_ITEM_PRICES.PRICELIST_CODE_SAL01=SAL01_PRICELISTS.PRICELIST_CODE and "+
"SAL01_PRICELISTS.COMPANY_CODE_SYS01=B.COMPANY_CODE_SYS01 and "+
"SAL01_PRICELISTS.PROGRESSIVE_SYS10=B.PROGRESSIVE and "+
"B.LANGUAGE_CODE=? and SAL02_ITEM_PRICES.COMPANY_CODE_SYS01=? and "+
"SAL02_ITEM_PRICES.ITEM_CODE_ITM01='"+vo.getItemCodeITM01()+"' and "+
"SAL02_ITEM_PRICES.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 and "+
"SAL02_ITEM_PRICES.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE AND "+
"REG03_CURRENCIES.CURRENCY_CODE=SAL01_PRICELISTS.CURRENCY_CODE_REG03";
}
java.sql.Date filterDate = null;
if (gridParams.getOtherGridParams().get(ApplicationConsts.DATE_FILTER)!=null) {
filterDate = new java.sql.Date( ((java.util.Date)gridParams.getOtherGridParams().get(ApplicationConsts.DATE_FILTER)).getTime() );
sql +=
" and SAL02_ITEM_PRICES.START_DATE<=? and "+
" (SAL02_ITEM_PRICES.END_DATE>? or SAL02_ITEM_PRICES.END_DATE is null) ";
}
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01SAL02","SAL02_ITEM_PRICES.COMPANY_CODE_SYS01");
attribute2dbField.put("pricelistCodeSal01SAL02","SAL02_ITEM_PRICES.PRICELIST_CODE_SAL01");
attribute2dbField.put("itemCodeItm01SAL02","SAL02_ITEM_PRICES.ITEM_CODE_ITM01");
attribute2dbField.put("valueSAL02","SAL02_ITEM_PRICES.VALUE");
attribute2dbField.put("startDateSAL02","SAL02_ITEM_PRICES.START_DATE");
attribute2dbField.put("endDateSAL02","SAL02_ITEM_PRICES.END_DATE");
attribute2dbField.put("itemDescriptionSYS10","A.DESCRIPTION");
attribute2dbField.put("pricelistDescriptionSYS10","B.DESCRIPTION");
attribute2dbField.put("progressiveHie02ITM01","ITM01_ITEMS.PROGRESSIVE_HIE02");
attribute2dbField.put("useVariant1ITM01","ITM01_ITEMS.USE_VARIANT_1");
attribute2dbField.put("useVariant2ITM01","ITM01_ITEMS.USE_VARIANT_2");
attribute2dbField.put("useVariant3ITM01","ITM01_ITEMS.USE_VARIANT_3");
attribute2dbField.put("useVariant4ITM01","ITM01_ITEMS.USE_VARIANT_4");
attribute2dbField.put("useVariant5ITM01","ITM01_ITEMS.USE_VARIANT_5");
attribute2dbField.put("currencySymbolREG03","REG03_CURRENCIES.CURRENCY_SYMBOL");
attribute2dbField.put("decimalsREG03","REG03_CURRENCIES.DECIMALS");
ArrayList values = new ArrayList();
values.add(serverLanguageId);
values.add(companyCodeSYS01);
if (filterDate!=null) {
values.add(filterDate);
values.add(filterDate);
}
// read from SAL02 table...
Response res = QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql,
values,
attribute2dbField,
PriceVO.class,
"Y",
"N",
null,
gridParams,
50,
true
);
if (!res.isError()) {
java.util.List rows = ((VOListResponse)res).getRows();
PriceVO vo = null;
for(int i=0;i<rows.size();i++) {
vo = (PriceVO)rows.get(i);
if (gridParams.getOtherGridParams().get(ApplicationConsts.PRICELIST)!=null) {
PricelistVO parentVO = (PricelistVO)gridParams.getOtherGridParams().get(ApplicationConsts.PRICELIST);
vo.setPricelistDescriptionSYS10(parentVO.getDescriptionSYS10());
}
else {
DetailItemVO parentVO = (DetailItemVO)gridParams.getOtherGridParams().get(ApplicationConsts.ITEM);
vo.setItemDescriptionSYS10(parentVO.getDescriptionSYS10());
vo.setProgressiveHie02ITM01(parentVO.getProgressiveHie02ITM01());
}
}
}