public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
try {
DetailSaleDocRowVO rowVO = (DetailSaleDocRowVO) inputPar;
VariantDescriptionsVO vo =
(VariantDescriptionsVO)
((JAIOUserSessionParameters) userSessionPars)
.getVariantDescriptionsVO()
.get(rowVO.getCompanyCodeSys01DOC02());
InsertSaleItem bean =
(InsertSaleItem) JAIOBeanFactory.getInstance().getBean(InsertSaleItem.class);
Response answer =
bean.insertSaleItem(
vo.getVariant1Descriptions(),
vo.getVariant2Descriptions(),
vo.getVariant3Descriptions(),
vo.getVariant4Descriptions(),
vo.getVariant5Descriptions(),
rowVO,
((JAIOUserSessionParameters) userSessionPars).getServerLanguageId(),
userSessionPars.getUsername());
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while processing request",
ex);
return new ErrorResponse(ex.getMessage());
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
DetailSaleDocVO docVO = (DetailSaleDocVO) inputPar;
// retrieve internationalization settings (Resources object)...
ServerResourcesFactory factory =
(ServerResourcesFactory) context.getAttribute(Controller.RESOURCES_FACTORY);
Resources resources = factory.getResources(userSessionPars.getLanguageId());
// insert header...
docVO.setDocStateDOC01(ApplicationConsts.HEADER_BLOCKED);
Response res =
insDocBean.insertSaleDoc(
conn, docVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
SaleDocPK refPK =
new SaleDocPK(
docVO.getCompanyCodeSys01Doc01DOC01(),
docVO.getDocTypeDoc01DOC01(),
docVO.getDocYearDoc01DOC01(),
docVO.getDocNumberDoc01DOC01());
// retrieve ref. document item rows...
GridParams gridParams = new GridParams();
gridParams.getOtherGridParams().put(ApplicationConsts.SALE_DOC_PK, refPK);
res =
rowsAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
java.util.List rows = ((VOListResponse) res).getRows();
// create rows..
GridSaleDocRowVO gridRowVO = null;
DetailSaleDocRowVO rowVO = null;
java.util.List discRows = null;
SaleDocRowPK docRowPK = null;
SaleItemDiscountVO itemDiscVO = null;
gridParams = new GridParams();
for (int i = 0; i < rows.size(); i++) {
gridRowVO = (GridSaleDocRowVO) rows.get(i);
// retrieve row detail...
docRowPK =
new SaleDocRowPK(
gridRowVO.getCompanyCodeSys01DOC02(),
gridRowVO.getDocTypeDOC02(),
gridRowVO.getDocYearDOC02(),
gridRowVO.getDocNumberDOC02(),
gridRowVO.getItemCodeItm01DOC02(),
gridRowVO.getVariantTypeItm06DOC02(),
gridRowVO.getVariantCodeItm11DOC02(),
gridRowVO.getVariantTypeItm07DOC02(),
gridRowVO.getVariantCodeItm12DOC02(),
gridRowVO.getVariantTypeItm08DOC02(),
gridRowVO.getVariantCodeItm13DOC02(),
gridRowVO.getVariantTypeItm09DOC02(),
gridRowVO.getVariantCodeItm14DOC02(),
gridRowVO.getVariantTypeItm10DOC02(),
gridRowVO.getVariantCodeItm15DOC02());
res =
rowAction.executeCommand(
docRowPK, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
rowVO = (DetailSaleDocRowVO) ((VOResponse) res).getVo();
rowVO.setDocTypeDOC02(docVO.getDocTypeDOC01());
rowVO.setDocNumberDOC02(docVO.getDocNumberDOC01());
if (rowVO.getInvoiceQtyDOC02().doubleValue() < rowVO.getQtyDOC02().doubleValue()
&& rowVO.getQtyDOC02().doubleValue() == rowVO.getOutQtyDOC02().doubleValue()) {
rowVO.setQtyDOC02(
rowVO
.getQtyDOC02()
.subtract(
rowVO
.getInvoiceQtyDOC02()
.setScale(
rowVO.getDecimalsReg02DOC02().intValue(), BigDecimal.ROUND_HALF_UP)));
rowVO.setTaxableIncomeDOC02(
rowVO
.getQtyDOC02()
.multiply(rowVO.getValueSal02DOC02())
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
rowVO.setTotalDiscountDOC02(new BigDecimal(0));
// calculate row vat...
double vatPerc =
rowVO.getValueReg01DOC02().doubleValue()
* (1d - rowVO.getDeductibleReg01DOC02().doubleValue() / 100d)
/ 100;
rowVO.setVatValueDOC02(
rowVO
.getTaxableIncomeDOC02()
.multiply(new BigDecimal(vatPerc))
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
// calculate row total...
rowVO.setValueDOC02(rowVO.getTaxableIncomeDOC02().add(rowVO.getVatValueDOC02()));
res =
insRowBean.insertSaleItem(
conn, rowVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
// create item discounts...
gridParams.getOtherGridParams().put(ApplicationConsts.SALE_DOC_ROW_PK, docRowPK);
res =
itemDiscAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
discRows = ((VOListResponse) res).getRows();
for (int j = 0; j < discRows.size(); j++) {
itemDiscVO = (SaleItemDiscountVO) discRows.get(j);
itemDiscVO.setDocTypeDOC04(docVO.getDocTypeDOC01());
itemDiscVO.setDocNumberDOC04(docVO.getDocNumberDOC01());
res =
insItemDiscBean.insertSaleDocRowDiscount(
conn, itemDiscVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
}
}
// create charges...
gridParams = new GridParams();
gridParams.getOtherGridParams().put(ApplicationConsts.SALE_DOC_PK, refPK);
res =
chargesAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
SaleDocChargeVO chargeVO = null;
if (res.isError()) {
conn.rollback();
return res;
}
rows = ((VOListResponse) res).getRows();
for (int i = 0; i < rows.size(); i++) {
chargeVO = (SaleDocChargeVO) rows.get(i);
chargeVO.setDocTypeDOC03(docVO.getDocTypeDOC01());
chargeVO.setDocNumberDOC03(docVO.getDocNumberDOC01());
if (chargeVO.getValueDOC03() == null
|| chargeVO.getValueDOC03() != null
&& chargeVO.getInvoicedValueDOC03().doubleValue()
< chargeVO.getValueDOC03().doubleValue()) {
if (chargeVO.getValueDOC03() != null)
chargeVO.setValueDOC03(
chargeVO
.getValueDOC03()
.subtract(chargeVO.getInvoicedValueDOC03())
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
res =
insChargeBean.insertSaleDocCharge(
conn, chargeVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
}
// create activities...
res =
actAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
SaleDocActivityVO actVO = null;
rows = ((VOListResponse) res).getRows();
for (int i = 0; i < rows.size(); i++) {
actVO = (SaleDocActivityVO) rows.get(i);
actVO.setDocTypeDOC13(docVO.getDocTypeDOC01());
actVO.setDocNumberDOC13(docVO.getDocNumberDOC01());
if (actVO.getInvoicedValueDOC13().doubleValue() < actVO.getValueDOC13().doubleValue()) {
actVO.setValueDOC13(
actVO
.getValueDOC13()
.subtract(actVO.getInvoicedValueDOC13())
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
res =
insActBean.insertSaleActivity(
conn, actVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
}
// create header discounts...
res =
discAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
SaleDocDiscountVO discVO = null;
rows = ((VOListResponse) res).getRows();
for (int i = 0; i < rows.size(); i++) {
discVO = (SaleDocDiscountVO) rows.get(i);
discVO.setDocTypeDOC05(docVO.getDocTypeDOC01());
discVO.setDocNumberDOC05(docVO.getDocNumberDOC01());
res =
insDiscBean.insertSaleDocDiscount(
conn, discVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
// recalculate all taxable incomes, vats, totals...
SaleDocPK pk =
new SaleDocPK(
docVO.getCompanyCodeSys01DOC01(),
docVO.getDocTypeDOC01(),
docVO.getDocYearDOC01(),
docVO.getDocNumberDOC01());
res =
totals.updateTaxableIncomes(
conn, pk, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
// reload doc header with updated totals...
Response answer =
docAction.loadSaleDoc(conn, pk, userSessionPars, request, response, userSession, context);
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while creating a sale invoice from a sale document",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}