/**
* Check if components required by specified products are available.
*
* @param products list of ProdOrderProductVO objects
* @params compAltComps collection of <component item code,HashSet of alternative component item
* codes>; filled by this method (and given back by reference)
* @return VOListResponse of ProdOrderComponentVO objects
*/
public final Response checkComponentsAvailability(
Connection conn,
Hashtable compAltComps,
ArrayList products,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
try {
// retrieve internationalization settings (Resources object)...
ServerResourcesFactory factory =
(ServerResourcesFactory) context.getAttribute(Controller.RESOURCES_FACTORY);
Resources resources = factory.getResources(userSessionPars.getLanguageId());
if (products.size() == 0) {
return new VOListResponse(new ArrayList(), false, 0);
}
// fill in comps hashtable with the collection of required components...
ItemPK pk = null;
ProdOrderProductVO prodVO = null;
ArrayList components = null;
MaterialVO compVO = null;
Response res = null;
ProdOrderComponentVO componentVO = null;
Hashtable comps =
new Hashtable(); // collection of <component item code,ProdOrderComponentVO object>
for (int i = 0; i < products.size(); i++) {
// retrieve bill of materials for each product...
prodVO = (ProdOrderProductVO) products.get(i);
pk = new ItemPK(prodVO.getCompanyCodeSys01DOC23(), prodVO.getItemCodeItm01DOC23());
res =
bean.getBillOfMaterials(
conn, pk, userSessionPars, request, response, userSession, context);
if (res.isError()) {
return res;
}
// extract components only (leaf nodes)...
components =
getComponents(
(DefaultMutableTreeNode) ((TreeModel) ((VOResponse) res).getVo()).getRoot());
for (int j = 0; j < components.size(); j++) {
compVO = (MaterialVO) components.get(j);
componentVO = (ProdOrderComponentVO) comps.get(compVO.getItemCodeItm01ITM03());
if (componentVO == null) {
componentVO = new ProdOrderComponentVO();
comps.put(compVO.getItemCodeItm01ITM03(), componentVO);
componentVO.setAvailableQty(new BigDecimal(0));
componentVO.setCompanyCodeSys01DOC24(compVO.getCompanyCodeSys01ITM03());
componentVO.setDescriptionSYS10(compVO.getDescriptionSYS10());
componentVO.setDocNumberDOC24(prodVO.getDocNumberDOC23());
componentVO.setDocYearDOC24(prodVO.getDocYearDOC23());
componentVO.setItemCodeItm01DOC24(compVO.getItemCodeItm01ITM03());
componentVO.setMinSellingQtyUmCodeReg02ITM01(compVO.getMinSellingQtyUmCodeReg02ITM01());
componentVO.setQtyDOC24(new BigDecimal(0));
}
componentVO.setQtyDOC24(
componentVO.getQtyDOC24().add(compVO.getQtyITM03().multiply(prodVO.getQtyDOC23())));
}
}
// check components availability in the specified warehouse...
Enumeration en = comps.keys();
GridParams gridParams = new GridParams();
gridParams
.getOtherGridParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, prodVO.getCompanyCodeSys01DOC23());
gridParams
.getOtherGridParams()
.put(ApplicationConsts.WAREHOUSE_CODE, prodVO.getWarehouseCodeWar01DOC22());
gridParams.getOtherGridParams().put(ApplicationConsts.LOAD_ALL, Boolean.TRUE);
ItemAvailabilityVO availVO = null;
BigDecimal availability, altAvailability, delta;
String itemCode = null;
ArrayList list, availList;
AltComponentVO altVO = null;
ArrayList alternativeComps = new ArrayList();
ArrayList compsToRemove = new ArrayList();
ProdOrderComponentVO altComponentVO = null;
HashSet altCodes = null; // list of alternative component item codes...
BigDecimal altQty = null;
while (en.hasMoreElements()) {
itemCode = en.nextElement().toString();
componentVO = (ProdOrderComponentVO) comps.get(itemCode);
gridParams
.getOtherGridParams()
.put(
ApplicationConsts.ITEM_PK, new ItemPK(prodVO.getCompanyCodeSys01DOC23(), itemCode));
res =
avail.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) return res;
availList = ((VOListResponse) res).getRows();
componentVO.setAvailabilities(availList);
availability = new BigDecimal(0);
for (int i = 0; i < availList.size(); i++) {
availVO = (ItemAvailabilityVO) availList.get(i);
availability = availability.add(availVO.getAvailableQtyWAR03());
}
componentVO.setAvailableQty(availability);
if (componentVO.getQtyDOC24().doubleValue() > componentVO.getAvailableQty().doubleValue()) {
// check if there exist some alternative component...
res =
altComps.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) return res;
list = ((VOListResponse) res).getRows();
for (int i = 0; i < list.size(); i++) {
altVO = (AltComponentVO) list.get(i);
gridParams
.getOtherGridParams()
.put(
ApplicationConsts.ITEM_PK,
new ItemPK(prodVO.getCompanyCodeSys01DOC23(), altVO.getItemCodeItm01ITM04()));
res =
avail.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) return res;
availList = ((VOListResponse) res).getRows();
altAvailability = new BigDecimal(0);
for (int j = 0; j < availList.size(); j++) {
availVO = (ItemAvailabilityVO) availList.get(j);
altAvailability = altAvailability.add(availVO.getAvailableQtyWAR03());
}
if (altAvailability.doubleValue() > 0) {
altComponentVO = new ProdOrderComponentVO();
altComponentVO.setAvailabilities(availList);
altComponentVO.setAvailableQty(altAvailability);
altComponentVO.setCompanyCodeSys01DOC24(altVO.getCompanyCodeSys01ITM04());
altComponentVO.setDescriptionSYS10(altVO.getDescriptionSYS10());
altComponentVO.setDocNumberDOC24(prodVO.getDocNumberDOC23());
altComponentVO.setDocYearDOC24(prodVO.getDocYearDOC23());
altComponentVO.setItemCodeItm01DOC24(altVO.getItemCodeItm01ITM04());
altComponentVO.setMinSellingQtyUmCodeReg02ITM01(
altVO.getMinSellingQtyUmCodeReg02ITM01());
altQty =
conv.convertQty(
altVO.getMinSellingQtyUmCodeReg02ITM01(),
componentVO.getMinSellingQtyUmCodeReg02ITM01(),
altAvailability,
userSessionPars,
request,
response,
userSession,
context);
if (componentVO.getQtyDOC24().subtract(availability).doubleValue()
> altQty.doubleValue()) {
delta = altQty;
altComponentVO.setQtyDOC24(altAvailability);
} else {
delta = componentVO.getQtyDOC24();
altComponentVO.setQtyDOC24(
conv.convertQty(
componentVO.getMinSellingQtyUmCodeReg02ITM01(),
altVO.getMinSellingQtyUmCodeReg02ITM01(),
delta,
userSessionPars,
request,
response,
userSession,
context));
}
componentVO.setQtyDOC24(componentVO.getQtyDOC24().subtract(delta));
alternativeComps.add(altComponentVO);
altCodes = (HashSet) compAltComps.get(itemCode);
if (altCodes == null) {
altCodes = new HashSet();
compAltComps.put(itemCode, altCodes);
}
altCodes.add(altVO.getItemCodeItm01ITM04());
if (componentVO.getQtyDOC24().doubleValue() == 0) {
compsToRemove.add(componentVO);
break;
}
if (componentVO.getQtyDOC24().subtract(availability).doubleValue() == 0) break;
}
}
}
}
list = new ArrayList(comps.values());
list.addAll(alternativeComps);
list.removeAll(compsToRemove);
return new VOListResponse(list, false, list.size());
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"checkComponentsAvailability",
"Error while retrieving components availability for the specified production order",
ex);
return new ErrorResponse(ex.getMessage());
}
}
/** Business logic to execute. */
public static VOResponse loadItemImplosion(
Connection conn, ItemPK pk, String langId, String username) throws Throwable {
PreparedStatement pstmt = null;
PreparedStatement pstmt2 = null;
try {
String sql1 =
"select ITM01_ITEMS.COMPANY_CODE_SYS01,ITM01_ITEMS.ITEM_CODE,ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02,"
+ "ITM03_COMPONENTS.ITEM_CODE_ITM01,ITM03_COMPONENTS.QTY,SYS10_COMPANY_TRANSLATIONS.DESCRIPTION "
+ "from ITM03_COMPONENTS,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS "
+ "where "
+ "ITM03_COMPONENTS.COMPANY_CODE_SYS01 = ITM01_ITEMS.COMPANY_CODE_SYS01 and "
+ "ITM03_COMPONENTS.PARENT_ITEM_CODE_ITM01 = ITM01_ITEMS.ITEM_CODE and "
+ "ITM01_ITEMS.COMPANY_CODE_SYS01 = SYS10_COMPANY_TRANSLATIONS.COMPANY_CODE_SYS01 and "
+ "ITM01_ITEMS.PROGRESSIVE_SYS10 = SYS10_COMPANY_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_COMPANY_TRANSLATIONS.LANGUAGE_CODE=? and ITM03_COMPONENTS.ENABLED='Y' and "
+ "ITM03_COMPONENTS.COMPANY_CODE_SYS01=? and "
+ "ITM03_COMPONENTS.ITEM_CODE_ITM01 in (";
String sql3 = ") ";
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01ITM03", "ITM01_ITEMS.COMPANY_CODE_SYS01");
attribute2dbField.put("itemCodeItm01ITM03", "ITM03_COMPONENTS.ITEM_CODE_ITM01");
attribute2dbField.put("parentItemCodeItm01ITM03", "ITM01_ITEMS.ITEM_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("qtyITM03", "ITM03_COMPONENTS.QTY");
attribute2dbField.put(
"minSellingQtyUmCodeReg02ITM01", "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02");
ArrayList values = new ArrayList();
values.add(langId);
values.add(pk.getCompanyCodeSys01ITM01());
// retrieve the whole tree...
MaterialVO rootVO = new MaterialVO();
rootVO.setCompanyCodeSys01ITM03(pk.getCompanyCodeSys01ITM01());
rootVO.setDescriptionSYS10("");
rootVO.setParentItemCodeItm01ITM03("");
rootVO.setItemCodeItm01ITM03("");
DefaultMutableTreeNode root = new OpenSwingTreeNode(rootVO);
DefaultTreeModel model = new DefaultTreeModel(root);
String sql2 = "'" + pk.getItemCodeITM01() + "'";
// read from ITM03 table...
Response res = null;
java.util.List rows = null;
DefaultMutableTreeNode auxnode, auxnode2;
MaterialVO auxVO = null;
Hashtable nodes = new Hashtable(); // collections of <item component code,related node>
Hashtable auxnodes = new Hashtable(); // collections of <item component code,related node>
Enumeration en = null;
do {
res =
QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql1 + sql2 + sql3,
values,
attribute2dbField,
MaterialVO.class,
"Y",
"N",
null,
new GridParams(),
true);
if (!res.isError()) {
rows = ((VOListResponse) res).getRows();
sql2 = "";
for (int i = 0; i < rows.size(); i++) {
auxVO = (MaterialVO) rows.get(i);
sql2 += "'" + auxVO.getParentItemCodeItm01ITM03() + "',";
auxnode = new OpenSwingTreeNode(auxVO);
auxnode2 = (DefaultMutableTreeNode) nodes.get(auxVO.getItemCodeItm01ITM03());
if (auxnode2 != null) auxnode.add(auxnode2);
nodes.remove(auxVO.getItemCodeItm01ITM03());
auxnodes.put(auxVO.getParentItemCodeItm01ITM03(), auxnode);
}
en = nodes.keys();
while (en.hasMoreElements()) {
root.add((DefaultMutableTreeNode) nodes.get(en.nextElement()));
}
nodes = auxnodes;
if (sql2.length() > 0) sql2 = sql2.substring(0, sql2.length() - 1);
}
} while (!res.isError() && rows.size() > 0);
if (res.isError()) throw new Exception(res.getErrorMessage());
return new VOResponse(model);
} catch (Exception ex1) {
Logger.error(
username,
BillOfMaterialsUtil.class.getName(),
"executeCommand",
"Error while fetching products that use the specified component",
ex1);
throw new Exception(ex1.getMessage());
}
}
/**
* Retrieve a DefaultTreeModel object that contains the bill of materials (MaterialVO objects) of
* the specified product.
*/
public static VOResponse getBillOfMaterials(
Connection conn,
CurrenciesBean compCurr,
ItemPK pk,
String langId,
String username,
ArrayList customizedFields)
throws Throwable {
PreparedStatement pstmt = null;
PreparedStatement pstmt2 = null;
try {
String sql1 =
"select ITM03_COMPONENTS.COMPANY_CODE_SYS01,ITM03_COMPONENTS.ITEM_CODE_ITM01,ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02,"
+ "ITM03_COMPONENTS.PARENT_ITEM_CODE_ITM01,ITM03_COMPONENTS.QTY,SYS10_COMPANY_TRANSLATIONS.DESCRIPTION "
+ "from ITM03_COMPONENTS,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS "
+ "where "
+ "ITM03_COMPONENTS.COMPANY_CODE_SYS01 = ITM01_ITEMS.COMPANY_CODE_SYS01 and "
+ "ITM03_COMPONENTS.ITEM_CODE_ITM01 = ITM01_ITEMS.ITEM_CODE and "
+ "ITM01_ITEMS.COMPANY_CODE_SYS01 = SYS10_COMPANY_TRANSLATIONS.COMPANY_CODE_SYS01 and "
+ "ITM01_ITEMS.PROGRESSIVE_SYS10 = SYS10_COMPANY_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_COMPANY_TRANSLATIONS.LANGUAGE_CODE=? and ITM03_COMPONENTS.ENABLED='Y' and "
+ "ITM03_COMPONENTS.COMPANY_CODE_SYS01=? and "
+ "ITM03_COMPONENTS.PARENT_ITEM_CODE_ITM01 in (";
String sql3 = ") order by ITM03_COMPONENTS.PARENT_ITEM_CODE_ITM01,ITM03_COMPONENTS.SEQUENCE";
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01ITM03", "ITM03_COMPONENTS.COMPANY_CODE_SYS01");
attribute2dbField.put("itemCodeItm01ITM03", "ITM03_COMPONENTS.ITEM_CODE_ITM01");
attribute2dbField.put("parentItemCodeItm01ITM03", "ITM03_COMPONENTS.PARENT_ITEM_CODE_ITM01");
attribute2dbField.put("descriptionSYS10", "SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("qtyITM03", "ITM03_COMPONENTS.QTY");
attribute2dbField.put(
"minSellingQtyUmCodeReg02ITM01", "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02");
ArrayList values = new ArrayList();
values.add(langId);
values.add(pk.getCompanyCodeSys01ITM01());
// retrieve the whole tree...
MaterialVO compVO = new MaterialVO();
compVO.setCompanyCodeSys01ITM03(pk.getCompanyCodeSys01ITM01());
compVO.setDescriptionSYS10("");
compVO.setItemCodeItm01ITM03(pk.getItemCodeITM01());
compVO.setQtyITM03(new BigDecimal(1));
DefaultMutableTreeNode node = new OpenSwingTreeNode(compVO);
DefaultTreeModel model = new DefaultTreeModel(node);
String sql2 = "'" + pk.getItemCodeITM01() + "'";
ArrayList nodes = new ArrayList();
ArrayList nodes2 = new ArrayList(); // current nodes...
Hashtable auxnodes = new Hashtable();
nodes.add(node);
// read from ITM03 table...
Response res = null;
java.util.List rows = null;
java.util.List auxlist = null;
DefaultMutableTreeNode auxnode, auxnode2 = null;
String currentItemCode = null;
do {
res =
QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql1 + sql2 + sql3,
values,
attribute2dbField,
MaterialVO.class,
"Y",
"N",
null,
new GridParams(),
true);
if (!res.isError()) {
rows = ((VOListResponse) res).getRows();
auxnodes.clear();
nodes2 = new ArrayList();
sql2 = "";
// group items per item code parent...
for (int i = 0; i < rows.size(); i++) {
compVO = (MaterialVO) rows.get(i);
sql2 += "'" + compVO.getItemCodeItm01ITM03() + "',";
auxnode = new OpenSwingTreeNode(compVO);
auxlist = (ArrayList) auxnodes.get(compVO.getParentItemCodeItm01ITM03());
if (auxlist == null) {
auxlist = new ArrayList();
auxnodes.put(compVO.getParentItemCodeItm01ITM03(), auxlist);
}
auxlist.add(auxnode);
nodes2.add(auxnode);
}
if (sql2.length() > 0) sql2 = sql2.substring(0, sql2.length() - 1);
// add items to the corresponding parent...
for (int i = 0; i < nodes.size(); i++) {
auxnode = (DefaultMutableTreeNode) nodes.get(i);
compVO = (MaterialVO) auxnode.getUserObject();
auxlist = (ArrayList) auxnodes.get(compVO.getItemCodeItm01ITM03());
if (auxlist != null)
for (int j = 0; j < auxlist.size(); j++) {
auxnode.add((DefaultMutableTreeNode) auxlist.get(j));
((MaterialVO) ((DefaultMutableTreeNode) auxlist.get(j)).getUserObject())
.setQtyITM03(
((MaterialVO) ((DefaultMutableTreeNode) auxlist.get(j)).getUserObject())
.getQtyITM03()
.multiply(((MaterialVO) auxnode.getUserObject()).getQtyITM03())
.setScale(5, BigDecimal.ROUND_HALF_UP));
}
}
nodes = nodes2;
}
} while (!res.isError() && rows.size() > 0);
if (res.isError()) throw new Exception(res.getErrorMessage());
res =
compCurr.loadCompanyCurrency(
pk.getCompanyCodeSys01ITM01(), langId, username, customizedFields);
if (res.isError()) throw new Exception(res.getErrorMessage());
CurrencyVO currVO = (CurrencyVO) ((VOResponse) res).getVo();
// navigate through the tree and fetch item prices...
pstmt =
conn.prepareStatement(
"select sum(PUR04_SUPPLIER_PRICES.VALUE),count(PUR04_SUPPLIER_PRICES.VALUE),PUR03_SUPPLIER_PRICELISTS.CURRENCY_CODE_REG03 "
+ "from PUR04_SUPPLIER_PRICES,PUR03_SUPPLIER_PRICELISTS "
+ "where "
+ "PUR04_SUPPLIER_PRICES.COMPANY_CODE_SYS01=PUR03_SUPPLIER_PRICELISTS.COMPANY_CODE_SYS01 and "
+ "PUR04_SUPPLIER_PRICES.PROGRESSIVE_REG04=PUR03_SUPPLIER_PRICELISTS.PROGRESSIVE_REG04 and "
+ "PUR04_SUPPLIER_PRICES.PRICELIST_CODE_PUR03=PUR03_SUPPLIER_PRICELISTS.PRICELIST_CODE and "
+ "PUR04_SUPPLIER_PRICES.COMPANY_CODE_SYS01=? and "
+ "PUR04_SUPPLIER_PRICES.ITEM_CODE_ITM01=? and "
+ "PUR04_SUPPLIER_PRICES.START_DATE<=? and "
+ "PUR04_SUPPLIER_PRICES.END_DATE>=? "
+ "group by PUR03_SUPPLIER_PRICELISTS.CURRENCY_CODE_REG03");
pstmt2 =
conn.prepareStatement(
"select sum(PRO02_MANUFACTURE_PHASES.VALUE) "
+ "from PRO02_MANUFACTURE_PHASES,ITM01_ITEMS "
+ "where "
+ "PRO02_MANUFACTURE_PHASES.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 and "
+ "PRO02_MANUFACTURE_PHASES.MANUFACTURE_CODE_PRO01=ITM01_ITEMS.MANUFACTURE_CODE_PRO01 and "
+ "ITM01_ITEMS.COMPANY_CODE_SYS01=? and "
+ "ITM01_ITEMS.ITEM_CODE=?");
res = expandNode(conn, currVO, pstmt, pstmt2, (DefaultMutableTreeNode) model.getRoot());
if (res.isError()) throw new Exception(res.getErrorMessage());
return new VOResponse(model);
} catch (Exception ex1) {
Logger.error(
username, "", "getBillOfMaterials", "Error while fetching bill of materials", ex1);
throw new Exception(ex1.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex) {
}
try {
pstmt2.close();
} catch (Exception ex) {
}
}
}
/**
* Navigate tree and fetch item purchase price and production costs.
*
* @param node current analyzed node
*/
private static Response expandNode(
Connection conn,
CurrencyVO currVO,
PreparedStatement pstmt,
PreparedStatement pstmt2,
DefaultMutableTreeNode node)
throws Exception {
ResultSet rset = null;
try {
MaterialVO vo = (MaterialVO) node.getUserObject();
if (node.getChildCount() == 0) {
// the current node is a leaf, so it cannot be constructed: it will be purchased...
pstmt.setString(1, vo.getCompanyCodeSys01ITM03());
pstmt.setString(2, vo.getItemCodeItm01ITM03());
pstmt.setDate(3, new java.sql.Date(System.currentTimeMillis()));
pstmt.setDate(4, new java.sql.Date(System.currentTimeMillis() + 86400 * 1000 - 1));
rset = pstmt.executeQuery();
BigDecimal totPrice = new BigDecimal(0);
BigDecimal totNum = new BigDecimal(0);
BigDecimal price = null;
BigDecimal num = null;
String currencyCode = null;
while (rset.next()) {
price = rset.getBigDecimal(1);
num = rset.getBigDecimal(2);
currencyCode = rset.getString(3);
price =
CurrencyConversionUtils.convertCurrencyToCurrency(
new java.sql.Date(System.currentTimeMillis()),
price,
currencyCode,
currVO.getCurrencyCodeREG03(),
conn);
if (price != null && num != null) {
totPrice = totPrice.add(price);
totNum = totNum.add(num);
}
}
rset.close();
if (totPrice.doubleValue() > 0) {
vo.setValuePUR04(
vo.getQtyITM03()
.multiply(totPrice)
.divide(num, BigDecimal.ROUND_HALF_UP)
.setScale(5, BigDecimal.ROUND_HALF_UP));
vo.setTotalPrices(vo.getValuePUR04());
}
} else {
// the current node is not a leaf, so it will be constructed: now it will be calculated
// production costs...
pstmt2.setString(1, vo.getCompanyCodeSys01ITM03());
pstmt2.setString(2, vo.getItemCodeItm01ITM03());
rset = pstmt2.executeQuery();
BigDecimal cost = null;
if (rset.next()) {
cost = rset.getBigDecimal(1);
}
rset.close();
if (cost != null && cost.doubleValue() > 0) {
vo.setValuePRO02(vo.getQtyITM03().multiply(cost).setScale(5, BigDecimal.ROUND_HALF_UP));
}
// navigate through children nodes...
Response res = null;
for (int i = 0; i < node.getChildCount(); i++) {
res =
expandNode(conn, currVO, pstmt, pstmt2, (DefaultMutableTreeNode) node.getChildAt(i));
if (res.isError()) return res;
}
if (res.isError()) return res;
// calculate total costs + total prices...
MaterialVO childVO = null;
BigDecimal totalPrices = new BigDecimal(0);
BigDecimal totalCosts = vo.getValuePRO02();
for (int i = 0; i < node.getChildCount(); i++) {
childVO = (MaterialVO) ((DefaultMutableTreeNode) node.getChildAt(i)).getUserObject();
if (childVO.getTotalPrices() != null && totalPrices != null)
// totalPrices =
// totalPrices.add(childVO.getTotalPrices().multiply(childVO.getQtyITM03()));
totalPrices = totalPrices.add(childVO.getTotalPrices());
else totalPrices = null;
if (childVO.getTotalCosts() != null && totalCosts != null)
// totalCosts =
// totalCosts.add(childVO.getTotalCosts().multiply(childVO.getQtyITM03()));
totalCosts = totalCosts.add(childVO.getTotalCosts());
}
if (totalCosts != null) vo.setTotalCosts(totalCosts.setScale(5, BigDecimal.ROUND_HALF_UP));
if (totalPrices != null && totalPrices != null)
vo.setTotalPrices(totalPrices.setScale(5, BigDecimal.ROUND_HALF_UP));
}
return new VOResponse(Boolean.TRUE);
} catch (Exception ex) {
ex.printStackTrace();
throw new Exception(ex.getMessage());
} finally {
try {
if (rset != null) rset.close();
} catch (Exception ex1) {
}
}
}
