public boolean updateBillingStatus(
ProductLineItem pli,
ProductOrder po,
String oldCodePOStatus,
String newPOStatus,
Session sess) {
BillingItem billingItem = null;
Product product = pli.getProduct();
int idPrice = product.getIdPrice();
// Find the billing item(s) that corresponds to the line item
for (BillingItem bi : (Set<BillingItem>) po.getBillingItemList(sess)) {
if (bi.getIdPrice().equals(idPrice)) {
billingItem = bi;
// Update billing item to complete -- only if it is pending, not already approved
if ((oldCodePOStatus == null || !oldCodePOStatus.equals(ProductOrderStatus.COMPLETED))
&& newPOStatus.equals(ProductOrderStatus.COMPLETED)) {
if (billingItem.getCodeBillingStatus().equals(BillingStatus.PENDING)) {
billingItem.setCodeBillingStatus(BillingStatus.COMPLETED);
billingItem.setCompleteDate(new java.sql.Date(System.currentTimeMillis()));
}
}
// Revert to pending -- only if it is completed but not approved
else if ((oldCodePOStatus != null && oldCodePOStatus.equals(ProductOrderStatus.COMPLETED))
&& !newPOStatus.equals(ProductOrderStatus.COMPLETED)) {
if (billingItem.getCodeBillingStatus().equals(BillingStatus.COMPLETED)) {
billingItem.setCodeBillingStatus(BillingStatus.PENDING);
billingItem.setCompleteDate(null);
}
}
}
}
// No billing item found
if (billingItem == null) {
return false;
}
return true;
}
public Command execute() throws RollBackCommandException {
try {
if (this.isValid()) {
Session sess = this.getSecAdvisor().getHibernateSession(this.getUsername());
if (orderDoc != null) {
for (Iterator i = orderDoc.getRootElement().getChildren().iterator(); i.hasNext(); ) {
Element n = (Element) i.next();
Integer idProductOrder = Integer.valueOf(n.getAttributeValue("idProductOrder"));
ProductOrder po = sess.load(ProductOrder.class, idProductOrder);
for (ProductLineItem li : (Set<ProductLineItem>) po.getProductLineItems()) {
String oldStatus = li.getCodeProductOrderStatus();
if (ProductUtil.updateLedgerOnProductOrderStatusChange(
li, po, oldStatus, codeProductOrderStatus, sess, resultMessage)) {
li.setCodeProductOrderStatus(codeProductOrderStatus);
updateBillingStatus(li, po, oldStatus, codeProductOrderStatus, sess);
sess.save(li);
}
}
sess.refresh(po);
if (codeProductOrderStatus.equals(ProductOrderStatus.COMPLETED)) {
SaveProductOrder.sendConfirmationEmail(
sess, po, ProductOrderStatus.COMPLETED, serverName);
}
}
}
if (lineItemDoc != null) {
for (Iterator i = lineItemDoc.getRootElement().getChildren().iterator(); i.hasNext(); ) {
Element n = (Element) i.next();
Integer idProductLineItem = Integer.valueOf(n.getAttributeValue("idProductLineItem"));
ProductLineItem pli = sess.load(ProductLineItem.class, idProductLineItem);
ProductOrder po = sess.load(ProductOrder.class, pli.getIdProductOrder());
String oldStatus = pli.getCodeProductOrderStatus();
if (ProductUtil.updateLedgerOnProductOrderStatusChange(
pli, po, oldStatus, codeProductOrderStatus, sess, resultMessage)) {
pli.setCodeProductOrderStatus(codeProductOrderStatus);
updateBillingStatus(pli, po, oldStatus, codeProductOrderStatus, sess);
sess.save(pli);
}
sess.refresh(po);
Boolean allItemsComplete = true;
for (Iterator j = po.getProductLineItems().iterator(); j.hasNext(); ) {
ProductLineItem item = (ProductLineItem) j.next();
if (!item.getCodeProductOrderStatus().equals(ProductOrderStatus.COMPLETED)) {
allItemsComplete = false;
break;
}
}
if (allItemsComplete) {
SaveProductOrder.sendConfirmationEmail(
sess, po, ProductOrderStatus.COMPLETED, serverName);
}
}
}
sess.flush();
this.xmlResult = "<SUCCESS message=\"" + resultMessage.toString() + "\"/>";
this.setResponsePage(this.SUCCESS_JSP);
} else {
this.setResponsePage(this.ERROR_JSP);
}
} catch (Exception e) {
LOG.error("An exception has occurred in ChangeProductOrderStatus ", e);
throw new RollBackCommandException(e.getMessage());
}
return this;
}