Examples of GridInDeliveryNoteRowVO

org.jallinone.warehouse.documents.java.GridInDeliveryNoteRowVO

Title: JAllInOne ERP/CRM application

Description: Value object used to store delivery note header info for a detail form.

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.warehouse.documents.java.GridInDeliveryNoteRowVO

      pstmt1 = conn.prepareStatement(sql1);
      pstmt2 = conn.prepareStatement(sql2);




      // for each item row it will be updated the related purchase order row and warehouse available quantities...
      GridInDeliveryNoteRowVO vo = null;
      ResultSet rset1 = null;
      BigDecimal qtyDOC07 = null;
      BigDecimal inQtyDOC07 = null;
      BigDecimal orderQtyDOC07 = null;
      BigDecimal qtyToAdd = null;
      Response innerResponse = null;
      for(int i=0;i<((VOListResponse)res).getRows().size();i++) {
        vo = (GridInDeliveryNoteRowVO)((VOListResponse)res).getRows().get(i);
        pstmt1.setString(1,vo.getCompanyCodeSys01DOC09());
        pstmt1.setString(2,vo.getDocTypeDoc06DOC09());
        pstmt1.setBigDecimal(3,vo.getDocYearDoc06DOC09());
        pstmt1.setBigDecimal(4,vo.getDocNumberDoc06DOC09());
        pstmt1.setString(5,vo.getItemCodeItm01DOC09());


        pstmt1.setString(6,vo.getVariantTypeItm06DOC09());
        pstmt1.setString(7,vo.getVariantCodeItm11DOC09());
        pstmt1.setString(8,vo.getVariantTypeItm07DOC09());
        pstmt1.setString(9,vo.getVariantCodeItm12DOC09());
        pstmt1.setString(10,vo.getVariantTypeItm08DOC09());
        pstmt1.setString(11,vo.getVariantCodeItm13DOC09());
        pstmt1.setString(12,vo.getVariantTypeItm09DOC09());
        pstmt1.setString(13,vo.getVariantCodeItm14DOC09());
        pstmt1.setString(14,vo.getVariantTypeItm10DOC09());
        pstmt1.setString(15,vo.getVariantCodeItm15DOC09());


        rset1 = pstmt1.executeQuery();
        if(rset1.next()) {
          qtyDOC07 = rset1.getBigDecimal(1);
          inQtyDOC07 = rset1.getBigDecimal(2);
          orderQtyDOC07 = rset1.getBigDecimal(3);
          rset1.close();


          // update in qty in the purchase order row...
          if (vo.getSupplierQtyDOC09().doubleValue()<qtyDOC07.subtract(inQtyDOC07).doubleValue())
            qtyToAdd = vo.getSupplierQtyDOC09();
          else
            qtyToAdd = qtyDOC07.subtract(inQtyDOC07);


          // update order qty in the purchase order row...
          orderQtyDOC07 = orderQtyDOC07.subtract(vo.getQtyDOC09()).setScale(vo.getDecimalsREG02().intValue(),BigDecimal.ROUND_HALF_UP);
          if (orderQtyDOC07.doubleValue()<0)
            orderQtyDOC07 = new BigDecimal(0);


          pstmt2.setBigDecimal(1,inQtyDOC07.add(qtyToAdd).setScale(vo.getSupplierQtyDecimalsREG02().intValue(),BigDecimal.ROUND_HALF_UP));
          pstmt2.setBigDecimal(2,orderQtyDOC07);
          pstmt2.setString(3,username);
          pstmt2.setTimestamp(4,new java.sql.Timestamp(System.currentTimeMillis()));
          pstmt2.setString(5,vo.getCompanyCodeSys01DOC09());
          pstmt2.setString(6,vo.getDocTypeDoc06DOC09());
          pstmt2.setBigDecimal(7,vo.getDocYearDoc06DOC09());
          pstmt2.setBigDecimal(8,vo.getDocNumberDoc06DOC09());
          pstmt2.setString(9,vo.getItemCodeItm01DOC09());
          pstmt2.setBigDecimal(10,inQtyDOC07);


          pstmt2.setString(11,vo.getVariantTypeItm06DOC09());
          pstmt2.setString(12,vo.getVariantCodeItm11DOC09());
          pstmt2.setString(13,vo.getVariantTypeItm07DOC09());
          pstmt2.setString(14,vo.getVariantCodeItm12DOC09());
          pstmt2.setString(15,vo.getVariantTypeItm08DOC09());
          pstmt2.setString(16,vo.getVariantCodeItm13DOC09());
          pstmt2.setString(17,vo.getVariantTypeItm09DOC09());
          pstmt2.setString(18,vo.getVariantCodeItm14DOC09());
          pstmt2.setString(19,vo.getVariantTypeItm10DOC09());
          pstmt2.setString(20,vo.getVariantCodeItm15DOC09());


          if (pstmt2.executeUpdate()==0)
             throw new Exception("Updating not performed: the record was previously updated.");
        }
        else
          rset1.close();


        // update warehouse available qty..
        WarehouseMovementVO movVO = new WarehouseMovementVO(
            vo.getProgressiveHie01DOC09(),
            vo.getQtyDOC09(),
            vo.getCompanyCodeSys01DOC09(),
            vo.getWarehouseCodeWar01DOC08(),
            vo.getItemCodeItm01DOC09(),
            ApplicationConsts.WAREHOUSE_MOTIVE_LOAD_BY_ORDER,
            ApplicationConsts.ITEM_GOOD,
            t1+" "+vo.getDocSequenceDoc06DOC09()+"/"+vo.getDocYearDoc06DOC09(),
            vo.getSerialNumbers(),


            vo.getVariantCodeItm11DOC09(),
            vo.getVariantCodeItm12DOC09(),
            vo.getVariantCodeItm13DOC09(),
            vo.getVariantCodeItm14DOC09(),
            vo.getVariantCodeItm15DOC09(),
            vo.getVariantTypeItm06DOC09(),
            vo.getVariantTypeItm07DOC09(),
            vo.getVariantTypeItm08DOC09(),
            vo.getVariantTypeItm09DOC09(),
            vo.getVariantTypeItm10DOC09()
        );
        innerResponse = movBean.addWarehouseMovement(movVO,t2,serverLanguageId,username);


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

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.GridInDeliveryNoteRowVO

    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
      bean.setConn(conn);


      GridInDeliveryNoteRowVO oldVO = null;
      GridInDeliveryNoteRowVO newVO = null;


      Response res = null;
      for(int i=0;i<newRows.size();i++) {
        oldVO = (GridInDeliveryNoteRowVO)oldRows.get(i);
        newVO = (GridInDeliveryNoteRowVO)newRows.get(i);

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.GridInDeliveryNoteRowVO

          Response res = null;
         java.util.List rows = null;
         ArrayList values = new ArrayList();
         boolean itemFound = false;


         GridInDeliveryNoteRowVO vo = new GridInDeliveryNoteRowVO();
         vo.setCompanyCodeSys01DOC09(pk.getCompanyCodeSys01DOC06());
         vo.setDocNumberDoc06DOC09(pk.getDocNumberDOC06());
         vo.setDocNumberDOC09(delivNoteDocNumber);
         vo.setDocTypeDoc06DOC09(pk.getDocTypeDOC06());
         vo.setDocTypeDOC09(ApplicationConsts.IN_DELIVERY_NOTE_DOC_TYPE);
         vo.setDocYearDoc06DOC09(pk.getDocYearDOC06());
         vo.setDocYearDOC09(new BigDecimal(new java.util.Date().getYear() + 1900));
         vo.setSupplierQtyDOC09(new BigDecimal(1));
         vo.setQtyDOC09(new BigDecimal(1));
         vo.setInvoiceQtyDOC09(new BigDecimal(0));
         vo.setSerialNumbers(new ArrayList());
         vo.setWarehouseCodeWar01DOC08(warehouseCode);
         vo.setProgressiveHie01DOC09(progressiveHie01DOC09); // warehouse location
         vo.setDocSequenceDoc06DOC09(docSequenceDOC06);


         if ("B".equals(codeType)) {
           // validate variants barcode...
           String sql =
               "select "+
               "ITM22_VARIANT_BARCODES.COMPANY_CODE_SYS01,ITM22_VARIANT_BARCODES.ITEM_CODE_ITM01,SYS10_COMPANY_TRANSLATIONS.DESCRIPTION,"+
               "ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM06,ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM07,ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM08,ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM09,ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM10,"+
               "ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM11,ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM12,ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM13,ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM14,ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM15,"+
               "ITM22_VARIANT_BARCODES.BAR_CODE,ITM01_ITEMS.SERIAL_NUMBER_REQUIRED,ITM01_ITEMS.PROGRESSIVE_HIE02 "+
               "from ITM22_VARIANT_BARCODES,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS,DOC07_PURCHASE_ITEMS "+
               "where "+
               "ITM22_VARIANT_BARCODES.COMPANY_CODE_SYS01=? AND "+
               "ITM22_VARIANT_BARCODES.BAR_CODE=? AND "+
               "ITM22_VARIANT_BARCODES.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 AND "+
               "ITM22_VARIANT_BARCODES.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE and ITM01_ITEMS.ENABLED='Y' 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 "+
               "DOC07_PURCHASE_ITEMS.COMPANY_CODE_SYS01=ITM22_VARIANT_BARCODES.COMPANY_CODE_SYS01 AND "+
               "DOC07_PURCHASE_ITEMS.DOC_TYPE=? AND "+
               "DOC07_PURCHASE_ITEMS.DOC_YEAR=? AND "+
               "DOC07_PURCHASE_ITEMS.DOC_NUMBER=? AND "+
               "DOC07_PURCHASE_ITEMS.QTY-DOC07_PURCHASE_ITEMS.IN_QTY>0 AND "+
               "DOC07_PURCHASE_ITEMS.ITEM_CODE_ITM01=ITM22_VARIANT_BARCODES.ITEM_CODE_ITM01 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM06=ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM06 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM07=ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM07 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM08=ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM08 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM09=ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM09 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM10=ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM10 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM11=ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM11 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM12=ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM12 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM13=ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM13 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM14=ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM14 AND "+
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM15=ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM15  ";


           Map attribute2dbField = new HashMap();
           attribute2dbField.put("companyCodeSys01ITM22","ITM22_VARIANT_BARCODES.COMPANY_CODE_SYS01");
           attribute2dbField.put("itemCodeItm01ITM22","ITM22_VARIANT_BARCODES.ITEM_CODE_ITM01");
           attribute2dbField.put("descriptionSYS10","SYS10_TRANSLATIONS.DESCRIPTION");
           attribute2dbField.put("barCodeITM22","ITM22_VARIANT_BARCODES.BAR_CODE");
           attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
           attribute2dbField.put("progressiveHie02ITM01","ITM01_ITEMS.PROGRESSIVE_HIE02");
           attribute2dbField.put("variantTypeItm06ITM22","ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM06");
           attribute2dbField.put("variantCodeItm11ITM22","ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM11");
           attribute2dbField.put("variantTypeItm07ITM22","ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM07");
           attribute2dbField.put("variantCodeItm12ITM22","ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM12");
           attribute2dbField.put("variantTypeItm08ITM22","ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM08");
           attribute2dbField.put("variantCodeItm13ITM22","ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM13");
           attribute2dbField.put("variantTypeItm09ITM22","ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM09");
           attribute2dbField.put("variantCodeItm14ITM22","ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM14");
           attribute2dbField.put("variantTypeItm10ITM22","ITM22_VARIANT_BARCODES.VARIANT_TYPE_ITM10");
           attribute2dbField.put("variantCodeItm15ITM22","ITM22_VARIANT_BARCODES.VARIANT_CODE_ITM15");


           values.clear();
           values.add(pk.getCompanyCodeSys01DOC06());
           values.add(code);
           values.add(serverLanguageId);
           values.add(pk.getDocTypeDOC06());
           values.add(pk.getDocYearDOC06());
           values.add(pk.getDocNumberDOC06());


           // read from ITM01 table...
           res = QueryUtil.getQuery(
               conn,
               new UserSessionParameters(username),
               sql,
               values,
               attribute2dbField,
               VariantBarcodeVO.class,
               "Y",
               "N",
               null,
               new GridParams(),
               true
           );
           if (res.isError())
             throw new Exception(res.getErrorMessage());


           rows = ((VOListResponse)res).getRows();
           if (rows.size() == 1) {
             // found variants barcode: pre-fill code and qty in variants matrix...
             VariantBarcodeVO barcodeVO = (VariantBarcodeVO)rows.get(0);


             //vo.setInQtyDOC07();
             //vo.setDecimalsREG02();
             vo.setItemCodeItm01DOC09(barcodeVO.getItemCodeItm01ITM22());
             vo.setDescriptionSYS10(barcodeVO.getDescriptionSYS10());
             vo.setSerialNumberRequiredITM01(new Boolean("Y".equals(barcodeVO.getSerialNumberRequiredITM01())));
             vo.setProgressiveHie02DOC09(barcodeVO.getProgressiveHie02ITM01()); // item's LOB


             //vo.setQtyDOC07();
             //vo.setSupplierItemCodePur02DOC09();
             //vo.setSupplierQtyDecimalsREG02();
             //vo.setUmCodeREG02();
             //vo.setUmCodeReg02PUR02();
             //vo.setValueREG05();
             vo.setVariantCodeItm11DOC09(barcodeVO.getVariantCodeItm11ITM22());
             vo.setVariantCodeItm12DOC09(barcodeVO.getVariantCodeItm12ITM22());
             vo.setVariantCodeItm13DOC09(barcodeVO.getVariantCodeItm13ITM22());
             vo.setVariantCodeItm14DOC09(barcodeVO.getVariantCodeItm14ITM22());
             vo.setVariantCodeItm15DOC09(barcodeVO.getVariantCodeItm15ITM22());
             vo.setVariantTypeItm06DOC09(barcodeVO.getVariantTypeItm06ITM22());
             vo.setVariantTypeItm07DOC09(barcodeVO.getVariantTypeItm07ITM22());
             vo.setVariantTypeItm08DOC09(barcodeVO.getVariantTypeItm08ITM22());
             vo.setVariantTypeItm09DOC09(barcodeVO.getVariantTypeItm09ITM22());
             vo.setVariantTypeItm10DOC09(barcodeVO.getVariantTypeItm10ITM22());


             itemFound = true;
           }


           if (!itemFound) {
             // no barcode found in ITM22 (barcode for item variants)
             // trying to find a barcode at item level...
             sql =
                 "select "+
                 "ITM01_ITEMS.COMPANY_CODE_SYS01,ITM01_ITEMS.ITEM_CODE,SYS10_COMPANY_TRANSLATIONS.DESCRIPTION,"+
                 "ITM01_ITEMS.SERIAL_NUMBER_REQUIRED,ITM01_ITEMS.PROGRESSIVE_HIE02 "+
                 "from ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS,DOC07_PURCHASE_ITEMS where "+
                 "ITM01_ITEMS.COMPANY_CODE_SYS01=? AND "+
                 "ITM01_ITEMS.BAR_CODE=? AND "+
                 "ITM01_ITEMS.ENABLED='Y' 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 "+
                 "DOC07_PURCHASE_ITEMS.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 AND " +
                 "DOC07_PURCHASE_ITEMS.DOC_TYPE=? AND " +
                 "DOC07_PURCHASE_ITEMS.DOC_YEAR=? AND " +
                 "DOC07_PURCHASE_ITEMS.DOC_NUMBER=? AND " +
                 "DOC07_PURCHASE_ITEMS.QTY-DOC07_PURCHASE_ITEMS.IN_QTY>0 AND "+
                 "DOC07_PURCHASE_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM06='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM07='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM08='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM09='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM10='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM11='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM12='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM13='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM14='*' AND " +
                 "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM15='*' ";


             attribute2dbField.clear();
             attribute2dbField.put("companyCodeSys01ITM01","ITM01_ITEMS.COMPANY_CODE_SYS01");
             attribute2dbField.put("itemCodeITM01","ITM01_ITEMS.ITEM_CODE");
             attribute2dbField.put("descriptionSYS10","SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
             attribute2dbField.put("barCodeITM01","ITM01_ITEMS.BAR_CODE");
             attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
             attribute2dbField.put("progressiveHie02ITM01","ITM01_ITEMS.PROGRESSIVE_HIE02");


             values.clear();
             values.add(pk.getCompanyCodeSys01DOC06());
             values.add(code);
             values.add(serverLanguageId);
             values.add(pk.getDocTypeDOC06());
             values.add(pk.getDocYearDOC06());
             values.add(pk.getDocNumberDOC06());


             // read from ITM01 table...
             res = QueryUtil.getQuery(
                 conn,
                 new UserSessionParameters(username),
                 sql,
                 values,
                 attribute2dbField,
                 GridItemVO.class,
                 "Y",
                 "N",
                 null,
                 new GridParams(),
                 true
             );


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


             rows = ( (VOListResponse) res).getRows();
             if (rows.size() == 1) {
               // found variants barcode: pre-fill code and qty in variants matrix...
               GridItemVO itemVO = (GridItemVO)rows.get(0);


               //vo.setInQtyDOC07();
               //vo.setDecimalsREG02();
               vo.setItemCodeItm01DOC09(itemVO.getItemCodeITM01());
               vo.setDescriptionSYS10(itemVO.getDescriptionSYS10());
               vo.setSerialNumberRequiredITM01(new Boolean("Y".equals(itemVO.getSerialNumberRequiredITM01())));
               vo.setProgressiveHie02DOC09(itemVO.getProgressiveHie02ITM01()); // item's LOB


               //vo.setQtyDOC07();
               //vo.setSupplierItemCodePur02DOC09();
               //vo.setSupplierQtyDecimalsREG02();
               //vo.setUmCodeREG02();
               //vo.setUmCodeReg02PUR02();
               //vo.setValueREG05();
               vo.setVariantCodeItm11DOC09(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm12DOC09(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm13DOC09(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm14DOC09(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm15DOC09(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm06DOC09(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm07DOC09(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm08DOC09(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm09DOC09(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm10DOC09(ApplicationConsts.JOLLY);


               itemFound = true;
             }
           }


           if (!itemFound) {
             // no barcode found!
             return null;
           }
         }
         else {
           // check for item code WITHOUT VARIANTS in buying order...
           String sql =
               "select DOC07_PURCHASE_ITEMS.COMPANY_CODE_SYS01,DOC07_PURCHASE_ITEMS.ITEM_CODE_ITM01,"+
               "SYS10_COMPANY_TRANSLATIONS.DESCRIPTION,"+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM06,DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM11,"+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM07,DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM12,"+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM08,DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM13,"+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM09,DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM14,"+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM10,DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM15, "+
               "ITM01_ITEMS.SERIAL_NUMBER_REQUIRED,DOC07_PURCHASE_ITEMS.PROGRESSIVE_HIE02 "+
               "from DOC07_PURCHASE_ITEMS,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS where "+
               "DOC07_PURCHASE_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE and "+
               "DOC07_PURCHASE_ITEMS.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 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 "+
               "DOC07_PURCHASE_ITEMS.COMPANY_CODE_SYS01=? and "+
               "DOC07_PURCHASE_ITEMS.DOC_TYPE=? and "+
               "DOC07_PURCHASE_ITEMS.DOC_YEAR=? and "+
               "DOC07_PURCHASE_ITEMS.DOC_NUMBER=? and "+
               "DOC07_PURCHASE_ITEMS.ITEM_CODE_ITM01=? and "+
               "DOC07_PURCHASE_ITEMS.QTY-DOC07_PURCHASE_ITEMS.IN_QTY>0 and "+
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM06='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM07='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM08='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM09='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM10='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM11='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM12='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM13='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM14='*' AND " +
               "DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM15='*' ";


           Map attribute2dbField = new HashMap();
           attribute2dbField.put("companyCodeSys01DOC07","DOC07_PURCHASE_ITEMS.COMPANY_CODE_SYS01");
           attribute2dbField.put("itemCodeItm01DOC07","DOC07_PURCHASE_ITEMS.ITEM_CODE_ITM01");
           attribute2dbField.put("descriptionSYS10","SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
           attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
           attribute2dbField.put("progressiveHie02DOC07","DOC07_PURCHASE_ITEMS.PROGRESSIVE_HIE02");


           attribute2dbField.put("variantTypeItm06DOC07","DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM06");
           attribute2dbField.put("variantCodeItm11DOC07","DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM11");
           attribute2dbField.put("variantTypeItm07DOC07","DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM07");
           attribute2dbField.put("variantCodeItm12DOC07","DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM12");
           attribute2dbField.put("variantTypeItm08DOC07","DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM08");
           attribute2dbField.put("variantCodeItm13DOC07","DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM13");
           attribute2dbField.put("variantTypeItm09DOC07","DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM09");
           attribute2dbField.put("variantCodeItm14DOC07","DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM14");
           attribute2dbField.put("variantTypeItm10DOC07","DOC07_PURCHASE_ITEMS.VARIANT_TYPE_ITM10");
           attribute2dbField.put("variantCodeItm15DOC07","DOC07_PURCHASE_ITEMS.VARIANT_CODE_ITM15");


           values.clear();
           values.add(serverLanguageId);
           values.add(pk.getCompanyCodeSys01DOC06());
           values.add(pk.getDocTypeDOC06());
           values.add(pk.getDocYearDOC06());
           values.add(pk.getDocNumberDOC06());
           values.add(code);


           // read from DOC07 table...
           res = QueryUtil.getQuery(
               conn,
               new UserSessionParameters(username),
               sql,
               values,
               attribute2dbField,
               GridPurchaseDocRowVO.class,
               "Y",
               "N",
               null,
               new GridParams(),
               true
           );


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


           rows = ( (VOListResponse) res).getRows();
           if (rows.size() == 1) {
              GridPurchaseDocRowVO itemVO = (GridPurchaseDocRowVO)rows.get(0);


              //vo.setInQtyDOC07();
              //vo.setDecimalsREG02();
              vo.setItemCodeItm01DOC09(itemVO.getItemCodeItm01DOC07());
              vo.setDescriptionSYS10(itemVO.getDescriptionSYS10());
              vo.setSerialNumberRequiredITM01(new Boolean("Y".equals(itemVO.getSerialNumberRequiredITM01())));
              vo.setProgressiveHie02DOC09(itemVO.getProgressiveHie02DOC07()); // item's LOB
              //vo.setQtyDOC07();
              //vo.setSupplierItemCodePur02DOC09();
              //vo.setSupplierQtyDecimalsREG02();
              //vo.setUmCodeREG02();
              //vo.setUmCodeReg02PUR02();
              //vo.setValueREG05();
              vo.setVariantCodeItm11DOC09(itemVO.getVariantCodeItm11DOC07());
              vo.setVariantCodeItm12DOC09(itemVO.getVariantCodeItm12DOC07());
              vo.setVariantCodeItm13DOC09(itemVO.getVariantCodeItm13DOC07());
              vo.setVariantCodeItm14DOC09(itemVO.getVariantCodeItm14DOC07());
              vo.setVariantCodeItm15DOC09(itemVO.getVariantCodeItm15DOC07());
              vo.setVariantTypeItm06DOC09(itemVO.getVariantTypeItm06DOC07());
              vo.setVariantTypeItm07DOC09(itemVO.getVariantTypeItm07DOC07());
              vo.setVariantTypeItm08DOC09(itemVO.getVariantTypeItm08DOC07());
              vo.setVariantTypeItm09DOC09(itemVO.getVariantTypeItm09DOC07());
              vo.setVariantTypeItm10DOC09(itemVO.getVariantTypeItm10DOC07());


              itemFound = true;
           }


           if (!itemFound) {
             // no item found!
             return null;
           }
         }


         String descr = vo.getDescriptionSYS10();


         // check supported variants for current item...
         if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm11DOC09())) {
           descr += " "+getVariantCodeAndTypeDesc(
             variant1Descriptions,
             vo,
             vo.getVariantTypeItm06DOC09(),
             vo.getVariantCodeItm11DOC09(),
             serverLanguageId,
             username
           );
         }
         if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm12DOC09())) {
           descr += " "+getVariantCodeAndTypeDesc(
             variant2Descriptions,
             vo,
             vo.getVariantTypeItm07DOC09(),
             vo.getVariantCodeItm12DOC09(),
             serverLanguageId,
             username
           );
         }
         if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm13DOC09())) {
           descr += " "+getVariantCodeAndTypeDesc(
             variant3Descriptions,
             vo,
             vo.getVariantTypeItm08DOC09(),
             vo.getVariantCodeItm13DOC09(),
             serverLanguageId,
             username
           );
         }
         if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm14DOC09())) {
           descr += " "+getVariantCodeAndTypeDesc(
             variant4Descriptions,
             vo,
             vo.getVariantTypeItm09DOC09(),
             vo.getVariantCodeItm14DOC09(),
             serverLanguageId,
             username
           );
         }
         if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm15DOC09())) {
           descr += " "+getVariantCodeAndTypeDesc(
             variant5Descriptions,
             vo,
             vo.getVariantTypeItm10DOC09(),
             vo.getVariantCodeItm15DOC09(),
             serverLanguageId,
             username
           );
         }
         vo.setDescriptionSYS10(descr);




         // retrieve qty conversion and decimals...
         String sql =
                   "select "+
                   " REG02_ALIAS1.DECIMALS,"+ // supplier decs
                   " PUR02_SUPPLIER_ITEMS.UM_CODE_REG02, "+ // supplier m.u.
                   " REG02_ALIAS2.DECIMALS, "+ // sale decs
                   " ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02 "+ // sale m.u.
                   "from PUR02_SUPPLIER_ITEMS,ITM01_ITEMS,REG02_MEASURE_UNITS REG02_ALIAS1,REG02_MEASURE_UNITS REG02_ALIAS2 where "+
                   "PUR02_SUPPLIER_ITEMS.UM_CODE_REG02=REG02_ALIAS1.UM_CODE and "+
                   "PUR02_SUPPLIER_ITEMS.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 and "+
                   "PUR02_SUPPLIER_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE and "+
                   "PUR02_SUPPLIER_ITEMS.COMPANY_CODE_SYS01 = ? and "+
                   "PUR02_SUPPLIER_ITEMS.PROGRESSIVE_REG04=? and "+
                   "PUR02_SUPPLIER_ITEMS.ENABLED='Y' and "+
                   "PUR02_SUPPLIER_ITEMS.ITEM_CODE_ITM01=? and "+
                   "ITM01_ITEMS.MIN_SELlING_QTY_UM_CODE_REG02=REG02_ALIAS2.UM_CODE ";
         pstmt =  conn.prepareStatement(sql);
         pstmt.setString(1,pk.getCompanyCodeSys01DOC06());
         pstmt.setBigDecimal(2,progressiveREG04);
         pstmt.setString(3,vo.getItemCodeItm01DOC09());
         ResultSet rset = pstmt.executeQuery();
         if (rset.next()) {
           vo.setSupplierQtyDecimalsREG02(rset.getBigDecimal(1));
           vo.setDecimalsREG02(rset.getBigDecimal(3));
           vo.setUmCodeReg02PUR02(rset.getString(2));
           vo.setValueREG05(convBean.getConversion(
             rset.getString(4),
             vo.getUmCodeReg02PUR02(),
             serverLanguageId,
             username
           ));
         }
         rset.close();

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.GridInDeliveryNoteRowVO

          pars,
          true
      );


      if (!res.isError()) {
        GridInDeliveryNoteRowVO vo = null;
        String descr = null;
        for(int i=0;i<((VOListResponse)res).getRows().size();i++) {
          vo = (GridInDeliveryNoteRowVO)((VOListResponse)res).getRows().get(i);


          descr = vo.getDescriptionSYS10();


          // check supported variants for current item...
          if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm11DOC09())) {
            descr += " "+getVariantCodeAndTypeDesc(
              variant1Descriptions,
              vo,
              vo.getVariantTypeItm06DOC09(),
              vo.getVariantCodeItm11DOC09(),
              serverLanguageId,
              username
            );
          }
          if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm12DOC09())) {
            descr += " "+getVariantCodeAndTypeDesc(
              variant2Descriptions,
              vo,
              vo.getVariantTypeItm07DOC09(),
              vo.getVariantCodeItm12DOC09(),
              serverLanguageId,
              username
            );
          }
          if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm13DOC09())) {
            descr += " "+getVariantCodeAndTypeDesc(
              variant3Descriptions,
              vo,
              vo.getVariantTypeItm08DOC09(),
              vo.getVariantCodeItm13DOC09(),
              serverLanguageId,
              username
            );
          }
          if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm14DOC09())) {
            descr += " "+getVariantCodeAndTypeDesc(
              variant4Descriptions,
              vo,
              vo.getVariantTypeItm09DOC09(),
              vo.getVariantCodeItm14DOC09(),
              serverLanguageId,
              username
            );
          }
          if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm15DOC09())) {
            descr += " "+getVariantCodeAndTypeDesc(
              variant5Descriptions,
              vo,
              vo.getVariantTypeItm10DOC09(),
              vo.getVariantCodeItm15DOC09(),
              serverLanguageId,
              username
            );
          }
          vo.setDescriptionSYS10(descr);








          vo.setValueREG05(convBean.getConversion(
            vo.getUmCodeREG02(),
            vo.getUmCodeReg02PUR02(),
            serverLanguageId,
            username
          ));
          vo.setSupplierQtyDOC09(vo.getQtyDOC07().subtract(vo.getInQtyDOC07()));
          vo.setQtyDOC09(vo.getSupplierQtyDOC09().divide(vo.getValueREG05(),vo.getDecimalsREG02().intValue(),BigDecimal.ROUND_HALF_UP));
        }
      }


      Response answer = res;
      if (answer.isError()) throw new Exception(answer.getErrorMessage()); else return (VOListResponse)answer;

View Full Code Here

Examples of org.jallinone.warehouse.documents.java.GridInDeliveryNoteRowVO

           true
       );
       if (!res.isError()) {
         ArrayList serialNums = null;
         java.util.List rows = ((VOListResponse)res).getRows();
         GridInDeliveryNoteRowVO vo = null;


         pstmt = conn.prepareStatement(
           "select SERIAL_NUMBER "+
           "from DOC11_IN_SERIAL_NUMBERS "+
           "where "+
           "PROGRESSIVE_DOC09=? "
          );


          String descr = null;
          for(int i=0;i<rows.size();i++) {
            vo = (GridInDeliveryNoteRowVO)rows.get(i);


            descr = vo.getDescriptionSYS10();


            // check supported variants for current item...
            if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm11DOC09())) {
              descr += " "+getVariantCodeAndTypeDesc(
                variant1Descriptions,
                vo,
                vo.getVariantTypeItm06DOC09(),
                vo.getVariantCodeItm11DOC09(),
                serverLanguageId,
                username
              );
            }
            if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm12DOC09())) {
              descr += " "+getVariantCodeAndTypeDesc(
                variant2Descriptions,
                vo,
                vo.getVariantTypeItm07DOC09(),
                vo.getVariantCodeItm12DOC09(),
                serverLanguageId,
                username
              );
            }
            if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm13DOC09())) {
              descr += " "+getVariantCodeAndTypeDesc(
                variant3Descriptions,
                vo,
                vo.getVariantTypeItm08DOC09(),
                vo.getVariantCodeItm13DOC09(),
                serverLanguageId,
                username
              );
            }
            if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm14DOC09())) {
              descr += " "+getVariantCodeAndTypeDesc(
                variant4Descriptions,
                vo,
                vo.getVariantTypeItm09DOC09(),
                vo.getVariantCodeItm14DOC09(),
                serverLanguageId,
                username
              );
            }
            if (!ApplicationConsts.JOLLY.equals(vo.getVariantCodeItm15DOC09())) {
              descr += " "+getVariantCodeAndTypeDesc(
                variant5Descriptions,
                vo,
                vo.getVariantTypeItm10DOC09(),
                vo.getVariantCodeItm15DOC09(),
                serverLanguageId,
                username
              );
            }
            vo.setDescriptionSYS10(descr);








            // retrieve and set m.u. conversion factor...
            vo.setValueREG05(convBean.getConversion(
              vo.getUmCodeREG02(),
              vo.getUmCodeReg02PUR02(),
              serverLanguageId,
              username
            ));


            // retrieve serial numbers...
            serialNums = new ArrayList();
            vo.setSerialNumbers(serialNums);
            pstmt.setBigDecimal(1,vo.getProgressiveDOC09());


            ResultSet rset = null;
            try {
              rset = pstmt.executeQuery();
              while(rset.next()) {

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.