Examples of SaleDocActivityVO

org.jallinone.sales.documents.activities.java.SaleDocActivityVO

Title: JAllInOne ERP/CRM application

Description: Value object used to store a sale doc activity in a sale document.

Copyright: Copyright (C) 2006 Mauro Carniel

This file is part of JAllInOne ERP/CRM application. This application is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This application is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it
@author Mauro Carniel @version 1.0

Examples of org.jallinone.sales.documents.activities.java.SaleDocActivityVO

        );
        if (res.isError())
          throw new Exception(res.getErrorMessage());


        java.util.List list = ((VOListResponse)res).getRows();
        SaleDocActivityVO vo = null;
        sql =
           "select SCH06_SCHEDULED_ACTIVITIES.DESCRIPTION "+
           "from SCH06_SCHEDULED_ACTIVITIES,REG01_VATS where "+
           "SCH06_SCHEDULED_ACTIVITIES.COMPANY_CODE_SYS01=? and "+
           "SCH06_SCHEDULED_ACTIVITIES.PROGRESSIVE=?";
        pstmt = conn.prepareStatement(sql);
        ResultSet rset = null;
        for(int i=0;i<list.size();i++) {
          vo = (SaleDocActivityVO)list.get(i);
          if (vo.getProgressiveSch06DOC13()!=null) {
            // retrieve scheduled activity description from SCH06...
            pstmt.setString(1,vo.getCompanyCodeSys01DOC13());
            pstmt.setBigDecimal(2,vo.getProgressiveSch06DOC13());
            rset = pstmt.executeQuery();
            if (rset.next()) {
              vo.setDescriptionSCH06(rset.getString(1));
            }
            rset.close();
          }
        }

View Full Code Here

Examples of org.jallinone.sales.documents.activities.java.SaleDocActivityVO

        if (res.isError()) {
          throw new Exception(res.getErrorMessage());
        }


        BigDecimal valueDOC13,invoicedValueDOC13 = new BigDecimal(0);
        SaleDocActivityVO actVO = null;
        rows = new ArrayList(((VOListResponse)res).getRows());
        for(int i=0;i<rows.size();i++) {
          actVO = (SaleDocActivityVO)rows.get(i);
          pstmt = conn.prepareStatement(
            "select VALUE,INVOICED_VALUE from DOC13_SELLING_ACTIVITIES where COMPANY_CODE_SYS01=? and DOC_TYPE=? and DOC_YEAR=? and DOC_NUMBER=? and ACTIVITY_CODE_SAL09=?"
          );
          pstmt.setString(1,refPK.getCompanyCodeSys01DOC01());
          pstmt.setString(2,refPK.getDocTypeDOC01());
          pstmt.setBigDecimal(3,refPK.getDocYearDOC01());
          pstmt.setBigDecimal(4,refPK.getDocNumberDOC01());
          pstmt.setString(5,actVO.getActivityCodeSal09DOC13());
          rset = pstmt.executeQuery();
          if (rset.next()) {
            valueDOC13 = rset.getBigDecimal(1);
            invoicedValueDOC13 = rset.getBigDecimal(2);


            invoicedValueDOC13 = invoicedValueDOC03.add(actVO.getValueDOC13()).setScale(docVO.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP);
            if (invoicedValueDOC13.doubleValue()>valueDOC13.doubleValue())
              invoicedValueDOC13 = valueDOC13;


          }
          rset.next();
          pstmt.close();


          pstmt = conn.prepareStatement(
            "update DOC13_SELLING_ACTIVITIES set INVOICED_VALUE=?,LAST_UPDATE_USER=?,LAST_UPDATE_DATE=?  where COMPANY_CODE_SYS01=? and DOC_TYPE=? and DOC_YEAR=? and DOC_NUMBER=? and ACTIVITY_CODE_SAL09=?"
          );
          pstmt.setBigDecimal(1,invoicedValueDOC13);
          pstmt.setString(2,username);
          pstmt.setTimestamp(3,new java.sql.Timestamp(System.currentTimeMillis()));
          pstmt.setString(4,refPK.getCompanyCodeSys01DOC01());
          pstmt.setString(5,refPK.getDocTypeDOC01());
          pstmt.setBigDecimal(6,refPK.getDocYearDOC01());
          pstmt.setBigDecimal(7,refPK.getDocNumberDOC01());
          pstmt.setString(8,actVO.getActivityCodeSal09DOC13());
          pstmt.execute();
          pstmt.close();
        } // end for (used to update invoice qtys in referred docs...)


        // check if linked document can be closed...

View Full Code Here

Examples of org.jallinone.sales.documents.activities.java.SaleDocActivityVO

      // retrieve all activities rows...
      rowsResponse = rowsBean.loadSaleDocActivities(pars,serverLanguageId,username);
      if (rowsResponse.isError())
        throw new Exception(rowsResponse.getErrorMessage());
      java.util.List actsRows = ((VOListResponse)rowsResponse).getRows();
      SaleDocActivityVO actVO = null;
      for(int i=0;i<actsRows.size();i++) {
        actVO = (SaleDocActivityVO)actsRows.get(i);
        actVO.setTaxableIncomeDOC13(
          actVO.getValueDOC13().setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
        );


        // apply taxable income to total taxable income...
        totalTaxableIncome = totalTaxableIncome.add(actVO.getTaxableIncomeDOC13());
      }


      // retrieve all charges rows...
      rowsResponse = rowsBean.loadSaleDocCharges(pars,serverLanguageId,username);
      if (rowsResponse.isError())
        throw new Exception(rowsResponse.getErrorMessage());
      java.util.List chargesRows = ((VOListResponse)rowsResponse).getRows();
      SaleDocChargeVO chargeVO = null;
      for(int i=0;i<chargesRows.size();i++) {
        chargeVO = (SaleDocChargeVO)chargesRows.get(i);
        if (chargeVO.getValueDOC03()!=null) {
          chargeVO.setTaxableIncomeDOC03(
            chargeVO.getValueDOC03().setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
          );


          // apply taxable income to total taxable income...
          totalTaxableIncome = totalTaxableIncome.add(chargeVO.getTaxableIncomeDOC03());
        }
      }


      // fill in coeff...
      Hashtable coeff = new Hashtable(); // collection of <item/act/valuecharge,taxableincome/totaltaxableincome>
      for(int i=0;i<detailItemRows.size();i++) {
        detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);
        coeff.put(detailItemVO,detailItemVO.getTaxableIncomeDOC02().divide(totalTaxableIncome,BigDecimal.ROUND_HALF_UP));
      }


      for(int i=0;i<actsRows.size();i++) {
        actVO = (SaleDocActivityVO)actsRows.get(i);
        coeff.put(actVO,actVO.getTaxableIncomeDOC13().divide(totalTaxableIncome,BigDecimal.ROUND_HALF_UP));
      }


      for(int i=0;i<chargesRows.size();i++) {
        chargeVO = (SaleDocChargeVO)chargesRows.get(i);
        if (chargeVO.getValueDOC03()!=null) {
          coeff.put(chargeVO,chargeVO.getTaxableIncomeDOC03().divide(totalTaxableIncome,BigDecimal.ROUND_HALF_UP));
        }
      }


      // apply % charges to all taxable incomes...
      SaleDocChargeVO percVO = null;
      for(int k=0;k<chargesRows.size();k++) {
        percVO = (SaleDocChargeVO)chargesRows.get(k);
        if (percVO.getPercDOC03()!=null) {
          for(int i=0;i<detailItemRows.size();i++) {
            detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);
            detailItemVO.setTaxableIncomeDOC02(
              detailItemVO.getTaxableIncomeDOC02().add(detailItemVO.getTaxableIncomeDOC02().multiply(percVO.getPercDOC03().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }


          for(int i=0;i<actsRows.size();i++) {
            actVO = (SaleDocActivityVO)actsRows.get(i);
            actVO.setTaxableIncomeDOC13(
              actVO.getTaxableIncomeDOC13().add(actVO.getTaxableIncomeDOC13().multiply(percVO.getPercDOC03().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }


          for(int i=0;i<chargesRows.size();i++) {
            chargeVO = (SaleDocChargeVO)chargesRows.get(i);
            if (chargeVO.getValueDOC03()!=null) {
              chargeVO.setTaxableIncomeDOC03(
                chargeVO.getTaxableIncomeDOC03().add(chargeVO.getTaxableIncomeDOC03().multiply(percVO.getPercDOC03().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
                setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
              );
            }
          }


        }
      }


      // +MC 7/1/2011 (as in SaleDocTotalsBean.getSaleDocTotals)
      // apply discount (eventually) defined at row level...
      if (vo.getDiscountValueDOC01()!=null) {


        for(int i=0;i<detailItemRows.size();i++) {
          detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);
          detailItemVO.setTaxableIncomeDOC02(
            detailItemVO.getTaxableIncomeDOC02().subtract(vo.getDiscountValueDOC01().multiply((BigDecimal)coeff.get(detailItemVO))).
            setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
          );
        }


        for(int i=0;i<actsRows.size();i++) {
          actVO = (SaleDocActivityVO)actsRows.get(i);
          actVO.setTaxableIncomeDOC13(
            actVO.getTaxableIncomeDOC13().subtract(vo.getDiscountValueDOC01().multiply((BigDecimal)coeff.get(actVO))).
            setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
          );
        }


        for(int i=0;i<chargesRows.size();i++) {
          chargeVO = (SaleDocChargeVO)chargesRows.get(i);
          if (chargeVO.getValueDOC03()!=null) {
            chargeVO.setTaxableIncomeDOC03(
              chargeVO.getTaxableIncomeDOC03().subtract(vo.getDiscountValueDOC01().multiply((BigDecimal)coeff.get(chargeVO))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }
        }


      }
      else if (vo.getDiscountPercDOC01()!=null) {
        for(int i=0;i<detailItemRows.size();i++) {
          detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);
          detailItemVO.setTaxableIncomeDOC02(
            detailItemVO.getTaxableIncomeDOC02().subtract(detailItemVO.getTaxableIncomeDOC02().multiply(vo.getDiscountPercDOC01().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
            setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
          );
        }


        for(int i=0;i<actsRows.size();i++) {
          actVO = (SaleDocActivityVO)actsRows.get(i);
          actVO.setTaxableIncomeDOC13(
            actVO.getTaxableIncomeDOC13().subtract(actVO.getTaxableIncomeDOC13().multiply(vo.getDiscountPercDOC01().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
            setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
          );
        }


        for(int i=0;i<chargesRows.size();i++) {
          chargeVO = (SaleDocChargeVO)chargesRows.get(i);
          if (chargeVO.getValueDOC03()!=null) {
            chargeVO.setTaxableIncomeDOC03(
              chargeVO.getTaxableIncomeDOC03().subtract(chargeVO.getTaxableIncomeDOC03().multiply(vo.getDiscountPercDOC01().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }
        }


      }


      // retrieve header discounts..
      rowsResponse = rowsBean.loadSaleDocDiscounts(pars,serverLanguageId,username);
      if (rowsResponse.isError())
        throw new Exception(rowsResponse.getErrorMessage());
      java.util.List discounts = ((VOListResponse)rowsResponse).getRows();


      // apply header discounts to all taxable incomes...
      SaleDocDiscountVO discVO = null;
      for(int k=0;k<discounts.size();k++) {
        discVO = (SaleDocDiscountVO)discounts.get(k);
        if (discVO.getPercDOC05()!=null) {
          // the current discount is % discount...
          for(int i=0;i<detailItemRows.size();i++) {
            detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);
            detailItemVO.setTaxableIncomeDOC02(
              detailItemVO.getTaxableIncomeDOC02().subtract(detailItemVO.getTaxableIncomeDOC02().multiply(discVO.getPercDOC05().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }


          for(int i=0;i<actsRows.size();i++) {
            actVO = (SaleDocActivityVO)actsRows.get(i);
            actVO.setTaxableIncomeDOC13(
              actVO.getTaxableIncomeDOC13().subtract(actVO.getTaxableIncomeDOC13().multiply(discVO.getPercDOC05().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }


          for(int i=0;i<chargesRows.size();i++) {
            chargeVO = (SaleDocChargeVO)chargesRows.get(i);
            if (chargeVO.getValueDOC03()!=null) {
              chargeVO.setTaxableIncomeDOC03(
                chargeVO.getTaxableIncomeDOC03().subtract(chargeVO.getTaxableIncomeDOC03().multiply(discVO.getPercDOC05().divide(new BigDecimal(100),BigDecimal.ROUND_HALF_UP))).
                setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
              );
            }
          }


        }
        else if (discVO.getValueDOC05()!=null) {
          // the current discount is a value discount...
          for(int i=0;i<detailItemRows.size();i++) {
            detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);
            detailItemVO.setTaxableIncomeDOC02(
              detailItemVO.getTaxableIncomeDOC02().subtract(discVO.getValueDOC05().multiply((BigDecimal)coeff.get(detailItemVO))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }


          for(int i=0;i<actsRows.size();i++) {
            actVO = (SaleDocActivityVO)actsRows.get(i);
            actVO.setTaxableIncomeDOC13(
              actVO.getTaxableIncomeDOC13().subtract(discVO.getValueDOC05().multiply((BigDecimal)coeff.get(actVO))).
              setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
            );
          }


          for(int i=0;i<chargesRows.size();i++) {
            chargeVO = (SaleDocChargeVO)chargesRows.get(i);
            if (chargeVO.getValueDOC03()!=null) {
              chargeVO.setTaxableIncomeDOC03(
                chargeVO.getTaxableIncomeDOC03().subtract(discVO.getValueDOC05().multiply((BigDecimal)coeff.get(chargeVO))).
                setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP)
              );
            }
          }


        }


      }


      // update vat values, item rows and calculate totals...
      Hashtable itemsTaxableIncomeRows = new Hashtable(); // collection of pairs <vatcode,TaxableIncomeVO>
      totalTaxableIncome = new BigDecimal(0);
      BigDecimal totalVat = new BigDecimal(0);
      String vatCode = null;
      String vatDescr = null;
      TaxableIncomeVO tVO = null;
      pstmt = conn.prepareStatement(
        "update DOC02_SELLING_ITEMS set TAXABLE_INCOME=?,VAT_VALUE=?,VALUE=?,TOTAL_DISCOUNT=?,LAST_UPDATE_USER=?,LAST_UPDATE_DATE=?  "+
        "where COMPANY_CODE_SYS01=? and DOC_TYPE=? and DOC_YEAR=? and DOC_NUMBER=? and ITEM_CODE_ITM01=? and "+
        "VARIANT_TYPE_ITM06=? and VARIANT_CODE_ITM11=? and "+
        "VARIANT_TYPE_ITM07=? and VARIANT_CODE_ITM12=? and "+
        "VARIANT_TYPE_ITM08=? and VARIANT_CODE_ITM13=? and "+
        "VARIANT_TYPE_ITM09=? and VARIANT_CODE_ITM14=? and "+
        "VARIANT_TYPE_ITM10=? and VARIANT_CODE_ITM15=? "
      );
      for(int i=0;i<detailItemRows.size();i++) {
        detailItemVO = (DetailSaleDocRowVO)detailItemRows.get(i);


        if (customerVatValue==null) {
          vatCode = detailItemVO.getVatCodeItm01DOC02();
          vatDescr = detailItemVO.getVatDescriptionDOC02();
          vatPerc = detailItemVO.getValueReg01DOC02().doubleValue()*(1d-detailItemVO.getDeductibleReg01DOC02().doubleValue()/100d)/100;
        }
        else {
          vatCode = customerVatCode;
          vatDescr = customerVatDescription;
          vatPerc = customerVatValue.doubleValue()/100d;
        }


        detailItemVO.setVatValueDOC02(detailItemVO.getTaxableIncomeDOC02().multiply(new BigDecimal(vatPerc)).setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP));
        detailItemVO.setValueDOC02(detailItemVO.getTaxableIncomeDOC02().add(detailItemVO.getVatValueDOC02()));


        totalTaxableIncome = totalTaxableIncome.add(detailItemVO.getTaxableIncomeDOC02());
        totalVat = totalVat.add(detailItemVO.getVatValueDOC02());


        tVO = (TaxableIncomeVO)itemsTaxableIncomeRows.get(vatCode);
        if (tVO==null) {
          tVO = new TaxableIncomeVO();
          tVO.setRowType(tVO.ITEM_ROW_TYPE);
          tVO.setVatCode(vatCode);
          tVO.setVatDescription(vatDescr);
          tVO.setVatValue(new BigDecimal(0));
          tVO.setTaxableIncome(new BigDecimal(0));
          itemsTaxableIncomeRows.put(vatCode,tVO);
        }
        tVO.setTaxableIncome(tVO.getTaxableIncome().add(detailItemVO.getTaxableIncomeDOC02()).setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP));
        tVO.setVatValue(tVO.getVatValue().add(detailItemVO.getVatValueDOC02()).setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP));


        pstmt.setBigDecimal(1,detailItemVO.getTaxableIncomeDOC02());
        pstmt.setBigDecimal(2,detailItemVO.getVatValueDOC02());
        pstmt.setBigDecimal(3,detailItemVO.getValueDOC02());
        pstmt.setBigDecimal(4,detailItemVO.getTotalDiscountDOC02());
        pstmt.setString(5,username);
        pstmt.setTimestamp(6,new java.sql.Timestamp(System.currentTimeMillis()));
        pstmt.setString(7,detailItemVO.getCompanyCodeSys01DOC02());
        pstmt.setString(8,detailItemVO.getDocTypeDOC02());
        pstmt.setBigDecimal(9,detailItemVO.getDocYearDOC02());
        pstmt.setBigDecimal(10,detailItemVO.getDocNumberDOC02());
        pstmt.setString(11,detailItemVO.getItemCodeItm01DOC02());


        pstmt.setString(12,detailItemVO.getVariantTypeItm06DOC02());
        pstmt.setString(13,detailItemVO.getVariantCodeItm11DOC02());
        pstmt.setString(14,detailItemVO.getVariantTypeItm07DOC02());
        pstmt.setString(15,detailItemVO.getVariantCodeItm12DOC02());
        pstmt.setString(16,detailItemVO.getVariantTypeItm08DOC02());
        pstmt.setString(17,detailItemVO.getVariantCodeItm13DOC02());
        pstmt.setString(18,detailItemVO.getVariantTypeItm09DOC02());
        pstmt.setString(19,detailItemVO.getVariantCodeItm14DOC02());
        pstmt.setString(20,detailItemVO.getVariantTypeItm10DOC02());
        pstmt.setString(21,detailItemVO.getVariantCodeItm15DOC02());


        pstmt.execute();
      }
      pstmt.close();


      // update vat values, activities rows and calculate totals...
      Hashtable actsTaxableIncomeRows = new Hashtable(); // collection of pairs <vatcode,TaxableIncomeVO>
      pstmt = conn.prepareStatement("update DOC13_SELLING_ACTIVITIES set TAXABLE_INCOME=?,VAT_VALUE=?,LAST_UPDATE_USER=?,LAST_UPDATE_DATE=?  where COMPANY_CODE_SYS01=? and DOC_TYPE=? and DOC_YEAR=? and DOC_NUMBER=? and ACTIVITY_CODE_SAL09=?");
      for(int i=0;i<actsRows.size();i++) {
        actVO = (SaleDocActivityVO)actsRows.get(i);


        if (customerVatValue==null) {
          vatCode = actVO.getVatCodeSal09DOC13();
          vatDescr = actVO.getVatDescriptionDOC13();
          vatPerc = actVO.getValueReg01DOC13().doubleValue()*(1d-actVO.getVatDeductibleDOC13().doubleValue()/100d)/100;
        }
        else {
          vatCode = customerVatCode;
          vatDescr = customerVatDescription;
          vatPerc = customerVatValue.doubleValue()/100d;
        }


        actVO.setVatValueDOC13(actVO.getTaxableIncomeDOC13().multiply(new BigDecimal(vatPerc)).setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP));


        totalTaxableIncome = totalTaxableIncome.add(actVO.getTaxableIncomeDOC13());
        totalVat = totalVat.add(actVO.getVatValueDOC13());


        tVO = (TaxableIncomeVO)actsTaxableIncomeRows.get(vatCode);
        if (tVO==null) {
          tVO = new TaxableIncomeVO();
          tVO.setRowType(tVO.ACTIVITY_ROW_TYPE);
          tVO.setVatCode(vatCode);
          tVO.setVatDescription(vatDescr);
          tVO.setVatValue(new BigDecimal(0));
          tVO.setTaxableIncome(new BigDecimal(0));
          actsTaxableIncomeRows.put(vatCode,tVO);
        }
        tVO.setTaxableIncome(tVO.getTaxableIncome().add(actVO.getTaxableIncomeDOC13()).setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP));
        tVO.setVatValue(tVO.getVatValue().add(actVO.getVatValueDOC13()).setScale(vo.getDecimalsREG03().intValue(),BigDecimal.ROUND_HALF_UP));


        pstmt.setBigDecimal(1,actVO.getTaxableIncomeDOC13());
        pstmt.setBigDecimal(2,actVO.getVatValueDOC13());
        pstmt.setString(3,username);
        pstmt.setTimestamp(4,new java.sql.Timestamp(System.currentTimeMillis()));
        pstmt.setString(5,actVO.getCompanyCodeSys01DOC13());
        pstmt.setString(6,actVO.getDocTypeDOC13());
        pstmt.setBigDecimal(7,actVO.getDocYearDOC13());
        pstmt.setBigDecimal(8,actVO.getDocNumberDOC13());
        pstmt.setString(9,actVO.getActivityCodeSal09DOC13());
        pstmt.execute();
      }
      pstmt.close();


      // update vat values, value charges rows and calculate totals...

View Full Code Here

Examples of org.jallinone.sales.documents.activities.java.SaleDocActivityVO

  /**
   * Callback method invoked when the user has clicked on the insert button
   * @param valueObject empty value object just created: the user can manage it to fill some attribute values
   */
  public void createValueObject(ValueObject valueObject) throws Exception {
    SaleDocActivityVO vo = (SaleDocActivityVO)valueObject;
    vo.setCompanyCodeSys01DOC13(panel.getParentVO().getCompanyCodeSys01DOC01());
    vo.setDocTypeDOC13(panel.getParentVO().getDocTypeDOC01());
    vo.setDocYearDOC13(panel.getParentVO().getDocYearDOC01());
    vo.setDocNumberDOC13(panel.getParentVO().getDocNumberDOC01());
  }

View Full Code Here

Examples of org.jallinone.sales.documents.activities.java.SaleDocActivityVO

   * @param row selected row index
   * @param attributeName attribute name that identifies the selected grid column
   * @return <code>true</code> if the selected cell is editable, <code>false</code> otherwise
   */
  public boolean isCellEditable(GridControl grid,int row,String attributeName) {
    SaleDocActivityVO vo = (SaleDocActivityVO)grid.getVOListTableModel().getObjectForRow(row);
    if (vo.getProgressiveSch06DOC13()!=null && attributeName.equals("durationDOC13")) {
      return false;
    }
    if (vo.getActivityCodeSal09DOC13()==null &&
        (attributeName.equals("descriptionSCH06") || attributeName.equals("durationDOC13"))) {
      vo.setValueDOC13(null);
      vo.setDurationDOC13(null);
      vo.setProgressiveSch06DOC13(null);
      vo.setDescriptionSCH06(null);
      return false;
    }
    return grid.isFieldEditable(row,attributeName);
  }

View Full Code Here

Examples of org.jallinone.sales.documents.activities.java.SaleDocActivityVO

   * @param oldValue old cell value (before cell editing)
   * @param newValue new cell value (just edited)
   * @return <code>true</code> if cell value is valid, <code>false</code> otherwise
   */
  public boolean validateCell(int rowNumber,String attributeName,Object oldValue,Object newValue) {
    SaleDocActivityVO vo = (SaleDocActivityVO)panel.getGrid().getVOListTableModel().getObjectForRow(rowNumber);
    if (vo.getValueSal09DOC13()!=null && attributeName.equals("durationDOC13") && newValue!=null)
       vo.setValueDOC13(vo.getValueSal09DOC13().multiply((BigDecimal)newValue).divide(new BigDecimal(60),BigDecimal.ROUND_HALF_UP));
    else if (attributeName.equals("valueSal09DOC13") && newValue!=null && vo.getDurationDOC13()!=null)
        vo.setValueDOC13(((BigDecimal)newValue).multiply(vo.getDurationDOC13().divide(new BigDecimal(60),BigDecimal.ROUND_HALF_UP)));
    else
       vo.setValueDOC13(null);
    return true;
  }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.