Examples of org.jallinone.items.java.GridItemVO

org.jallinone.items.java.GridItemVO

Title: JAllInOne ERP/CRM application

Description: Value object used to store item info for the grid.

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

    itemController.addLookupListener(new LookupListener() {


      public void codeValidated(boolean validated) {}


      public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
        GridItemVO vo = (GridItemVO)itemController.getLookupVO();
        if (vo==null || vo.getItemCodeITM01()==null) {
          resourcesPanel.setItem(null,null,null);
        }
        else if (vo.getDocDateDOC01()!=null) {
          SimpleDateFormat sdf = new SimpleDateFormat(ClientSettings.getInstance().getResources().getDateMask(Consts.TYPE_DATE));
          controlNote.setText(
            ClientSettings.getInstance().getResources().getResource("item sold on")+" "+
            sdf.format(vo.getDocDateDOC01())
          );
        }
        resourcesPanel.setItem(vo.getProgressiveHie02ITM01(),vo.getCompanyCodeSys01ITM01(),vo.getItemCodeITM01());
      }


      public void beforeLookupAction(ValueObject gridVO) {
        DetailCallOutRequestVO vo = (DetailCallOutRequestVO)calloutPanel.getVOModel().getValueObject();
        Subject subVO = (Subject)getSubjectForm().getVOModel().getValueObject();
        vo.setCompanyCodeSys01SCH03(subVO.getCompanyCodeSys01REG04());
        vo.setProgressiveReg04SCH03(subVO.getProgressiveREG04());
        itemDataLocator.getLookupFrameParams().put(ApplicationConsts.SHOW_ONLY_PURCHASED_ITEMS,new Boolean(controlFilterItems.isSelected()));
        itemDataLocator.getLookupValidationParameters().put(ApplicationConsts.SHOW_ONLY_PURCHASED_ITEMS,new Boolean(controlFilterItems.isSelected()));
        if (vo.getProgressiveReg04SCH03()!=null) {
          itemDataLocator.getLookupFrameParams().put(ApplicationConsts.PROGRESSIVE_REG04,vo.getProgressiveReg04SCH03());
          itemDataLocator.getLookupValidationParameters().put(ApplicationConsts.PROGRESSIVE_REG04,vo.getProgressiveReg04SCH03());
        }
        else {
          itemDataLocator.getLookupFrameParams().remove(ApplicationConsts.PROGRESSIVE_REG04);
          itemDataLocator.getLookupValidationParameters().remove(ApplicationConsts.PROGRESSIVE_REG04);
        }

View Full Code Here

    itemController.addLookupListener(new LookupListener() {


      public void codeValidated(boolean validated) {}


      public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
        GridItemVO vo = (GridItemVO)itemController.getLookupVO();
        if (vo==null) {
          controlItemCode.setValue(null);
          controlDescr.setValue(null);
          gridItemSpareParts.clearData();
          sheets.clearData();
        }
        else {
          controlItemCode.setValue(vo.getItemCodeItm01());
          controlDescr.setValue(vo.getDescriptionSYS10());
          gridItemSpareParts.getOtherGridParams().put(ApplicationConsts.ITEM_PK,new ItemPK(vo.getCompanyCodeSys01(),vo.getItemCodeITM01()));
          gridItemSpareParts.reloadData();
          sheets.clearData();
          tabpanel.setSelectedIndex(0);
          tabpanel.setEnabledAt(1,false);


          String sheetCode = vo.getSheetCodeItm25ITM01();
          if (sheetCode!=null) {
            LookupValidationParams pars = new LookupValidationParams(sheetCode,new HashMap());
            pars.getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,vo.getCompanyCodeSys01());
            Response res = ClientUtils.getData("validateSheetCode",pars);


            if (res.isError()) {
              OptionPane.showMessageDialog(MDIFrame.getInstance(),
                                           res.getErrorMessage(),

View Full Code Here

               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.setInQtyDOC02();
               //vo.setDecimalsREG02();
               vo.setItemCodeItm01DOC10(itemVO.getItemCodeITM01());
               vo.setDescriptionSYS10(itemVO.getDescriptionSYS10());
               vo.setSerialNumberRequiredITM01(new Boolean("Y".equals(itemVO.getSerialNumberRequiredITM01())));
               vo.setProgressiveHie02DOC10(itemVO.getProgressiveHie02ITM01()); // item's LOB


               //vo.setQtyDOC02();
               //vo.setSupplierItemCodePur02DOC10();
               //vo.setSupplierQtyDecimalsREG02();
               //vo.setUmCodeREG02();
               //vo.setUmCodeReg02PUR02();
               //vo.setValueREG05();
               vo.setVariantCodeItm11DOC10(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm12DOC10(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm13DOC10(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm14DOC10(ApplicationConsts.JOLLY);
               vo.setVariantCodeItm15DOC10(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm06DOC10(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm07DOC10(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm08DOC10(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm09DOC10(ApplicationConsts.JOLLY);
               vo.setVariantTypeItm10DOC10(ApplicationConsts.JOLLY);


               itemFound = true;
             }
           }


           if (!itemFound) {
             // no barcode found!
             return null;
           }
         }
/*
         else if ("S".equals(codeType)) {
           // search for a serial number!
           String sql =
               "select WAR05_STORED_SERIAL_NUMBERS.COMPANY_CODE_SYS01,WAR05_STORED_SERIAL_NUMBERS.SERIAL_NUMBER,"+
               "WAR05_STORED_SERIAL_NUMBERS.ITEM_CODE_ITM01,WAR05_STORED_SERIAL_NUMBERS.PROGRESSIVE_HIE01,"+
               "SYS10_COMPANY_TRANSLATIONS.DESCRIPTION,ITM01_ITEMS.SERIAL_NUMBER_REQUIRED,ITM01_ITEMS.PROGRESSIVE_HIE02,"+
               "WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM06,WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM11,"+
               "WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM07,WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM12,"+
               "WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM08,WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM13,"+
               "WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM09,WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM14,"+
               "WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM10,WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM15 "+
               "from WAR05_STORED_SERIAL_NUMBERS,ITM01_ITEMS,SYS10_COMPANY_TRANSLATIONS,DOC02_SELLING_ITEMS "+
               "where "+
               "WAR05_STORED_SERIAL_NUMBERS.COMPANY_CODE_SYS01=? and "+
               "WAR05_STORED_SERIAL_NUMBERS.SERIAL_NUMBER=? and "+
               "ITM01_ITEMS.COMPANY_CODE_SYS01=? AND "+
               "ITM01_ITEMS.ITEM_CODE=WAR05_STORED_SERIAL_NUMBERS.ITEM_CODE_ITM01 AND "+
               "ITM01_ITEMS.ENABLED='Y' AND "+
               "ITM01_ITEMS.PROGRESSIVE_SYS10=SYS10_COMPANY_TRANSLATIONS.PROGRESSIVE AND "+
               "SYS10_COMPANY_TRANSLATIONS.LANGUAGE_CODE=? AND "+
               "DOC02_SELLING_ITEMS.COMPANY_CODE_SYS01=ITM01_ITEMS.COMPANY_CODE_SYS01 AND " +
               "DOC02_SELLING_ITEMS.DOC_TYPE=? AND " +
               "DOC02_SELLING_ITEMS.DOC_YEAR=? AND " +
               "DOC02_SELLING_ITEMS.DOC_NUMBER=? AND " +
               "DOC02_SELLING_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE AND " +
               "DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM06=WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM06 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM07=WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM07 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM08=WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM08 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM09=WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM09 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM10=WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM10 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_CODE_ITM11=WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM11 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_CODE_ITM12=WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM12 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_CODE_ITM13=WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM13 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_CODE_ITM14=WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM14 AND "+
               "DOC02_SELLING_ITEMS.VARIANT_CODE_ITM15=WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM15  ";


            values.clear();
            values.add(pk.getCompanyCodeSys01DOC01());
           values.add(code);
           values.add(pk.getCompanyCodeSys01DOC01());
           values.add(serverLanguageId);
           values.add(pk.getDocTypeDOC01());
           values.add(pk.getDocYearDOC01());
           values.add(pk.getDocNumberDOC01());


           Map attribute2dbField = new HashMap();
           attribute2dbField.put("companyCodeSys01WAR05","WAR05_STORED_SERIAL_NUMBERS.COMPANY_CODE_SYS01");
           attribute2dbField.put("serialNumberWAR05","WAR05_STORED_SERIAL_NUMBERS.SERIAL_NUMBER");
           attribute2dbField.put("itemCodeItm01WAR05","WAR05_STORED_SERIAL_NUMBERS.ITEM_CODE_ITM01");
           attribute2dbField.put("progressiveHie01WAR05","WAR05_STORED_SERIAL_NUMBERS.PROGRESSIVE_HIE01");
           attribute2dbField.put("descriptionSYS10","SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
           attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
           attribute2dbField.put("progressiveHie02ITM01","ITM01_ITEMS.PROGRESSIVE_HIE02");


           attribute2dbField.put("variantTypeItm06WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM06");
           attribute2dbField.put("variantCodeItm11WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM11");
           attribute2dbField.put("variantTypeItm07WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM07");
           attribute2dbField.put("variantCodeItm12WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM12");
           attribute2dbField.put("variantTypeItm08WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM08");
           attribute2dbField.put("variantCodeItm13WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM13");
           attribute2dbField.put("variantTypeItm09WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM09");
           attribute2dbField.put("variantCodeItm14WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM14");
           attribute2dbField.put("variantTypeItm10WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_TYPE_ITM10");
           attribute2dbField.put("variantCodeItm15WAR05","WAR05_STORED_SERIAL_NUMBERS.VARIANT_CODE_ITM15");


           res = QueryUtil.getQuery(
               conn,
               new UserSessionParameters(username),
               sql,
               values,
               attribute2dbField,
               StoredSerialNumberVO.class,
               "Y",
               "N",
               null,
               new GridParams(),
               true
           );


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


           rows = ( (VOListResponse) res).getRows();
           if (rows.size() == 1) {
              StoredSerialNumberVO sVO = (StoredSerialNumberVO)rows.get(0);


              //vo.setInQtyDOC02();
              //vo.setDecimalsREG02();
              vo.setItemCodeItm01DOC10(sVO.getItemCodeItm01WAR05());
              vo.setDescriptionSYS10(sVO.getDescriptionSYS10());
              vo.setSerialNumberRequiredITM01(new Boolean(true));
              vo.setProgressiveHie02DOC10(sVO.getProgressiveHie02ITM01()); // item's LOB


              //vo.setQtyDOC02();
              //vo.setSupplierItemCodePur02DOC10();
              //vo.setSupplierQtyDecimalsREG02();
              //vo.setUmCodeREG02();
              //vo.setUmCodeReg02PUR02();
              //vo.setValueREG05();
              vo.setVariantCodeItm11DOC10(sVO.getVariantCodeItm11WAR05());
              vo.setVariantCodeItm12DOC10(sVO.getVariantCodeItm12WAR05());
              vo.setVariantCodeItm13DOC10(sVO.getVariantCodeItm13WAR05());
              vo.setVariantCodeItm14DOC10(sVO.getVariantCodeItm14WAR05());
              vo.setVariantCodeItm15DOC10(sVO.getVariantCodeItm15WAR05());
              vo.setVariantTypeItm06DOC10(sVO.getVariantTypeItm06WAR05());
              vo.setVariantTypeItm07DOC10(sVO.getVariantTypeItm07WAR05());
              vo.setVariantTypeItm08DOC10(sVO.getVariantTypeItm08WAR05());
              vo.setVariantTypeItm09DOC10(sVO.getVariantTypeItm09WAR05());
              vo.setVariantTypeItm10DOC10(sVO.getVariantTypeItm10WAR05());
              vo.setSerialNumberRequiredITM01(Boolean.TRUE);
              vo.getSerialNumbers().add(code);


              itemFound = true;
           }


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


           Map attribute2dbField = new HashMap();
           attribute2dbField.put("companyCodeSys01DOC02","DOC02_SELLING_ITEMS.COMPANY_CODE_SYS01");
           attribute2dbField.put("itemCodeItm01DOC02","DOC02_SELLING_ITEMS.ITEM_CODE_ITM01");
           attribute2dbField.put("descriptionSYS10","SYS10_COMPANY_TRANSLATIONS.DESCRIPTION");
           attribute2dbField.put("serialNumberRequiredITM01","ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
           attribute2dbField.put("progressiveHie02DOC02","DOC02_SELLING_ITEMS.PROGRESSIVE_HIE02");


           attribute2dbField.put("variantTypeItm06DOC02","DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM06");
           attribute2dbField.put("variantCodeItm11DOC02","DOC02_SELLING_ITEMS.VARIANT_CODE_ITM11");
           attribute2dbField.put("variantTypeItm07DOC02","DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM07");
           attribute2dbField.put("variantCodeItm12DOC02","DOC02_SELLING_ITEMS.VARIANT_CODE_ITM12");
           attribute2dbField.put("variantTypeItm08DOC02","DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM08");
           attribute2dbField.put("variantCodeItm13DOC02","DOC02_SELLING_ITEMS.VARIANT_CODE_ITM13");
           attribute2dbField.put("variantTypeItm09DOC02","DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM09");
           attribute2dbField.put("variantCodeItm14DOC02","DOC02_SELLING_ITEMS.VARIANT_CODE_ITM14");
           attribute2dbField.put("variantTypeItm10DOC02","DOC02_SELLING_ITEMS.VARIANT_TYPE_ITM10");
           attribute2dbField.put("variantCodeItm15DOC02","DOC02_SELLING_ITEMS.VARIANT_CODE_ITM15");


           attribute2dbField.put("noWarehouseMovITM01","ITM01_ITEMS.NO_WAREHOUSE_MOV");


           values.clear();
           values.add(serverLanguageId);
           values.add(pk.getCompanyCodeSys01DOC01());
           values.add(pk.getDocTypeDOC01());
           values.add(pk.getDocYearDOC01());
           values.add(pk.getDocNumberDOC01());
           values.add(code);


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


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


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


              //vo.setInQtyDOC07();
              //vo.setDecimalsREG02();
              vo.setItemCodeItm01DOC10(itemVO.getItemCodeItm01DOC02());
              vo.setDescriptionSYS10(itemVO.getDescriptionSYS10());
              vo.setSerialNumberRequiredITM01(new Boolean("Y".equals(itemVO.getSerialNumberRequiredITM01())));
              vo.setProgressiveHie02DOC10(itemVO.getProgressiveHie02DOC02()); // item's LOB
              //vo.setQtyDOC02();
              //vo.setSupplierItemCodePur02DOC10();
              //vo.setSupplierQtyDecimalsREG02();
              //vo.setUmCodeREG02();
              //vo.setUmCodeReg02PUR02();
              //vo.setValueREG05();
              vo.setVariantCodeItm11DOC10(itemVO.getVariantCodeItm11DOC02());
              vo.setVariantCodeItm12DOC10(itemVO.getVariantCodeItm12DOC02());
              vo.setVariantCodeItm13DOC10(itemVO.getVariantCodeItm13DOC02());
              vo.setVariantCodeItm14DOC10(itemVO.getVariantCodeItm14DOC02());
              vo.setVariantCodeItm15DOC10(itemVO.getVariantCodeItm15DOC02());
              vo.setVariantTypeItm06DOC10(itemVO.getVariantTypeItm06DOC02());
              vo.setVariantTypeItm07DOC10(itemVO.getVariantTypeItm07DOC02());
              vo.setVariantTypeItm08DOC10(itemVO.getVariantTypeItm08DOC02());
              vo.setVariantTypeItm09DOC10(itemVO.getVariantTypeItm09DOC02());
              vo.setVariantTypeItm10DOC10(itemVO.getVariantTypeItm10DOC02());


              itemFound = true;
           }


           if (!itemFound) {

View Full Code Here

      colItemCodeController.addLookupListener(new LookupListener() {


        public void codeValidated(boolean validated) {}


        public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
          GridItemVO vo = (GridItemVO)colItemCodeController.getLookupVO();
          if (vo.getSerialNumberRequiredITM01()!=null && vo.getSerialNumberRequiredITM01().booleanValue()) {
            JOptionPane.showMessageDialog(
              MDIFrame.getInstance(),
              ClientSettings.getInstance().getResources().getResource("the selected item requires serial number definition: this kind of item is not allowed"),
              ClientSettings.getInstance().getResources().getResource("Attention"),
              JOptionPane.WARNING_MESSAGE);
            ComponentVO compVO = (ComponentVO)parentVO;
            compVO.setItemCodeItm01ITM03(null);
            compVO.setDescriptionSYS10(null);
          }
        }


        public void beforeLookupAction(ValueObject parentVO) {
          ComponentVO vo = (ComponentVO)parentVO;
          DetailItemVO itemVO = (DetailItemVO)ProductPanel.this.frame.getFormPanel().getVOModel().getValueObject();
          colItemCodeDataLocator.getLookupFrameParams().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHIE02());
          colItemCodeDataLocator.getLookupValidationParameters().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHIE02());
          colItemCodeDataLocator.getLookupFrameParams().put(ApplicationConsts.COMPANY_CODE_SYS01,itemVO.getCompanyCodeSys01ITM01());
          colItemCodeDataLocator.getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,itemVO.getCompanyCodeSys01ITM01());
          colTreeLevelDataLocator.getTreeNodeParams().put(ApplicationConsts.PROGRESSIVE_HIE02, vo.getProgressiveHIE02());
          colTreeLevelDataLocator.getTreeNodeParams().put(ApplicationConsts.PROGRESSIVE_HIE02, vo.getProgressiveHIE02());
          colItemCodeDataLocator.getLookupFrameParams().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHIE02());
          colItemCodeDataLocator.getLookupValidationParameters().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHIE02());
          colTreeLevelDataLocator.getTreeNodeParams().put(ApplicationConsts.COMPANY_CODE_SYS01, itemVO.getCompanyCodeSys01ITM01());
          colTreeLevelDataLocator.getTreeNodeParams().put(ApplicationConsts.COMPANY_CODE_SYS01, itemVO.getCompanyCodeSys01ITM01());
          colItemCodeDataLocator.getLookupFrameParams().put(ApplicationConsts.COMPANY_CODE_SYS01,itemVO.getCompanyCodeSys01ITM01());
          colItemCodeDataLocator.getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,itemVO.getCompanyCodeSys01ITM01());
        }


        public void forceValidate() {}


      });




      // alternative item code lookup for the alternative components grid...
      colItemCode2DataLocator.setGridMethodName("loadItems");
      colItemCode2DataLocator.setValidationMethodName("validateItemCode");
      colItemCode2DataLocator.getLookupFrameParams().put(ApplicationConsts.COMPONENTS_ONLY,Boolean.TRUE);
      colItemCode2DataLocator.getLookupValidationParameters().put(ApplicationConsts.COMPONENTS_ONLY,Boolean.TRUE);
      colAltItemCode.setLookupController(colItemCode2Controller);
      colItemCode2Controller.setLookupDataLocator(colItemCode2DataLocator);
      colItemCode2Controller.setFrameTitle("components");


      colItemCode2Controller.setCodeSelectionWindow(colItemCodeController.TREE_GRID_FRAME);
      colTreeLevel2DataLocator.setServerMethodName("loadCompanyHierarchy");
      colItemCode2DataLocator.setTreeDataLocator(colTreeLevel2DataLocator);
      colItemCode2DataLocator.setNodeNameAttribute("descriptionSYS10");


      colItemCode2Controller.setLookupValueObjectClassName("org.jallinone.items.java.GridItemVO");
      colItemCode2Controller.addLookup2ParentLink("companyCodeSys01ITM01", "companyCodeSys01ITM04");
      colItemCode2Controller.addLookup2ParentLink("itemCodeITM01", "itemCodeItm01ITM04");
      colItemCode2Controller.addLookup2ParentLink("descriptionSYS10", "descriptionSYS10");


      colItemCode2Controller.setAllColumnVisible(false);
      colItemCode2Controller.setVisibleColumn("companyCodeSys01ITM01", true);
      colItemCode2Controller.setVisibleColumn("itemCodeITM01", true);
      colItemCode2Controller.setVisibleColumn("descriptionSYS10", true);
      colItemCode2Controller.setPreferredWidthColumn("descriptionSYS10", 200);
      colItemCode2Controller.setFramePreferedSize(new Dimension(650,500));
      colItemCode2Controller.addLookupListener(new LookupListener() {


        public void codeValidated(boolean validated) {}


        public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
          GridItemVO vo = (GridItemVO)colItemCode2Controller.getLookupVO();
          DetailItemVO itemVO = (DetailItemVO)ProductPanel.this.frame.getFormPanel().getVOModel().getValueObject();
          if (vo.getItemCodeITM01()!=null && vo.getItemCodeITM01().equals(itemVO.getItemCodeITM01())) {
            JOptionPane.showMessageDialog(
              MDIFrame.getInstance(),
              ClientSettings.getInstance().getResources().getResource("you cannot set the current item as alternative component"),
              ClientSettings.getInstance().getResources().getResource("Attention"),
              JOptionPane.WARNING_MESSAGE);
            AltComponentVO compVO = (AltComponentVO)parentVO;
            compVO.setItemCodeItm01ITM04(null);
            compVO.setDescriptionSYS10(null);
          }
        }


        public void beforeLookupAction(ValueObject parentVO) {
          DetailItemVO vo = (DetailItemVO)ProductPanel.this.frame.getFormPanel().getVOModel().getValueObject();
          colItemCode2DataLocator.getLookupFrameParams().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHie02ITM01());
          colItemCode2DataLocator.getLookupValidationParameters().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHie02ITM01());
          colItemCode2DataLocator.getLookupFrameParams().put(ApplicationConsts.COMPANY_CODE_SYS01,vo.getCompanyCodeSys01ITM01());
          colItemCode2DataLocator.getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,vo.getCompanyCodeSys01ITM01());
          colTreeLevel2DataLocator.getTreeNodeParams().put(ApplicationConsts.PROGRESSIVE_HIE02, vo.getProgressiveHie02ITM01());
          colTreeLevel2DataLocator.getTreeNodeParams().put(ApplicationConsts.PROGRESSIVE_HIE02, vo.getProgressiveHie02ITM01());
          colItemCode2DataLocator.getLookupFrameParams().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHie02ITM01());
          colItemCode2DataLocator.getLookupValidationParameters().put(ApplicationConsts.PROGRESSIVE_HIE02,vo.getProgressiveHie02ITM01());
          colTreeLevel2DataLocator.getTreeNodeParams().put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01ITM01());
          colTreeLevel2DataLocator.getTreeNodeParams().put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01ITM01());
          colItemCode2DataLocator.getLookupFrameParams().put(ApplicationConsts.COMPANY_CODE_SYS01,vo.getCompanyCodeSys01ITM01());
          colItemCode2DataLocator.getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,vo.getCompanyCodeSys01ITM01());
        }


        public void forceValidate() {}


      });




      // set explosion panel...
      explosionPanel.setLoadWhenVisibile(false);
      explosionPanel.setTreeController(new TreeController() {


        public void doubleClick(DefaultMutableTreeNode node) {
          MaterialVO vo = (MaterialVO)node.getUserObject();
          new ItemController(null,new ItemPK(vo.getCompanyCodeSys01ITM03(),vo.getItemCodeItm01ITM03()),false);
        }


        public void leftClick(DefaultMutableTreeNode node) {}


        public boolean rightClick(DefaultMutableTreeNode node) {

View Full Code Here

               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) {

View Full Code Here

        public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
          if (itemController.getLookupVO()==null) {
            controlITemDescr.setText("");
          }
          else {
            GridItemVO vo = (GridItemVO)itemController.getLookupVO();
            controlITemDescr.setText(vo.getDescriptionSYS10());
          }
        }


        public void beforeLookupAction(ValueObject parentVO) {
          itemController.getLookupDataLocator().getLookupFrameParams().put(ApplicationConsts.PROGRESSIVE_HIE02,controlItemType.getValue());
          itemController.getLookupDataLocator().getLookupFrameParams().put(ApplicationConsts.COMPANY_CODE_SYS01,controlComp.getValue());
          itemController.getLookupDataLocator().getLookupValidationParameters().put(ApplicationConsts.PROGRESSIVE_HIE02,controlItemType.getValue());
          itemController.getLookupDataLocator().getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,controlComp.getValue());
        }


        public void forceValidate() {}


      });






      // customer lookup...
      customerDataLocator.setGridMethodName("loadCustomers");
      customerDataLocator.setValidationMethodName("validateCustomerCode");


      controlCust.setLookupController(customerController);
      controlCust.setControllerMethodName("getCustomersList");
      customerController.setForm(filterPanel);
      customerController.setLookupDataLocator(customerDataLocator);
      customerController.setFrameTitle("customers");
      customerController.setLookupValueObjectClassName("org.jallinone.sales.customers.java.GridCustomerVO");
      customerController.addLookup2ParentLink("customerCodeSAL07","customerCode");
      customerController.setAllColumnVisible(false);
      customerController.setVisibleColumn("companyCodeSys01REG04", true);
      customerController.setFilterableColumn("companyCodeSys01REG04", true);
      customerController.setFilterableColumn("customerCodeSAL07", true);
      customerController.setFilterableColumn("name_1REG04", true);
      customerController.setFilterableColumn("name_2REG04", true);
      customerController.setFilterableColumn("cityREG04", true);
      customerController.setFilterableColumn("provinceREG04", true);


      customerController.setSortableColumn("companyCodeSys01REG04", true);
      customerController.setSortableColumn("customerCodeSAL07", true);
      customerController.setSortableColumn("name_1REG04", true);
      customerController.setSortableColumn("name_2REG04", true);
      customerController.setSortableColumn("cityREG04", true);
      customerController.setSortableColumn("provinceREG04", true);


      customerController.setVisibleColumn("customerCodeSAL07", true);
      customerController.setVisibleColumn("name_1REG04", true);
      customerController.setVisibleColumn("name_2REG04", true);
      customerController.setVisibleColumn("cityREG04", true);
      customerController.setVisibleColumn("provinceREG04", true);
      customerController.setVisibleColumn("countryREG04", true);
      customerController.setVisibleColumn("taxCodeREG04", true);
      customerController.setHeaderColumnName("cityREG04", "city");
      customerController.setHeaderColumnName("provinceREG04", "prov");
      customerController.setHeaderColumnName("countryREG04", "country");
      customerController.setHeaderColumnName("taxCodeREG04", "taxCode");
      customerController.setPreferredWidthColumn("name_1REG04", 200);
      customerController.setPreferredWidthColumn("name_2REG04", 150);
      customerController.setFramePreferedSize(new Dimension(750,500));
      customerController.addLookupListener(new LookupListener() {


        public void codeValidated(boolean validated) {}


        public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
          if (customerController.getLookupVO()==null) {
            controlCustName1.setText("");
            controlCustName2.setText("");
          }
          else {
            GridCustomerVO vo = (GridCustomerVO)customerController.getLookupVO();
            controlCustName1.setText(vo.getName_1REG04());
            controlCustName2.setText(vo.getName_2REG04());
          }
        }


        public void beforeLookupAction(ValueObject parentVO) {
          customerDataLocator.getLookupFrameParams().put(ApplicationConsts.COMPANY_CODE_SYS01,controlComp.getValue());
          customerDataLocator.getLookupValidationParameters().put(ApplicationConsts.COMPANY_CODE_SYS01,controlComp.getValue());
        }


        public void forceValidate() {}


      });








      pivotTable.setController(new PivotTableController(){


        public Response getPivotTableModel(PivotTableParameters pars) {
          filterPanel.pull();
          SalesPivotVO vo= (SalesPivotVO)filterPanel.getVOModel().getValueObject();
          vo.setPivotPars(pars);
          pars.setInputFilter(new InputFilter());
          Response res = ClientUtils.getData("salesPivot",vo);
          if (res.isError())
            OptionPane.showMessageDialog(SalesPivotFrame.this,res.getErrorMessage(),"Error while loading data",JOptionPane.ERROR_MESSAGE);
          return res;
        }


      });


      RowField rowFieldItem = new RowField("itemCodeItm01DOC02",100);
      RowField rowFieldCustomer = new RowField("customerCodeSAL07",150);
      RowField rowFieldWarehouse = new RowField("warehouseCodeWar01DOC01",100);


      pivotTable.getAllRowFields().add(rowFieldItem);
      pivotTable.getAllRowFields().add(rowFieldCustomer);
      pivotTable.getAllRowFields().add(rowFieldWarehouse);


      pivotTable.addRowField(rowFieldWarehouse);
//      pivotTable.addRowField(rowFieldItem);


      ColumnField columnFieldYear = new ColumnField("docDateDOC01","year",new YearAggregator());
      ColumnField columnFieldQuarter = new ColumnField("docDateDOC01","quarter",new QuarterAggregator());


      pivotTable.getAllColumnFields().add(columnFieldYear);
      pivotTable.getAllColumnFields().add(columnFieldQuarter);


      pivotTable.addColumnField(columnFieldYear);
      pivotTable.addColumnField(columnFieldQuarter);


      NumberFormat nf = NumberFormat.getCurrencyInstance();
      Currency currency = Currency.getInstance(Locale.getDefault()); // to review...
      nf.setCurrency(currency);
      nf.setMaximumFractionDigits(2);
      nf.setMinimumFractionDigits(2);
      nf.setGroupingUsed(true);


      DataField dataFieldTotal = new DataField("totalDOC01",80,"sellAmount",new SumFunction()); // sum function...
      dataFieldTotal.setFormatter(nf);


      NumberFormat nf2 = NumberFormat.getIntegerInstance();


      DataField dataFieldItemQty = new DataField("qtyDOC02",80,"sellQty",new SumFunction()); // sum function...
      dataFieldItemQty.setFormatter(nf2);


      pivotTable.getAllDataFields().add(dataFieldTotal);
      pivotTable.getAllDataFields().add(dataFieldItemQty);
      pivotTable.addDataField(dataFieldTotal);




      pivotTable.setDataFieldRenderer(new DataFieldRenderer() {


        /**
         * @param currentColor current color to set
         * @param rowPath GenericNodeKey row fields path that identify current row
         * @param colPath GenericNodeKey column fields path that identify current column
         * @param value value to show in the specified cell
         * @param row current row
         * @param col current column
         * @return Color background color to set
         */
        public Color getBackgroundColor(Color currentColor,GenericNodeKey rowPath,GenericNodeKey colPath,Object value,int row,int col) {
          if (rowPath.getPath().length<pivotTable.getPivotTableParameters().getRowFields().size() ||
              colPath.getPath().length<pivotTable.getPivotTableParameters().getColumnFields().size()+1) {
            int c = 200+rowPath.getPath().length*colPath.getPath().length*5;
            return new Color(c,c,c);
          }
          return currentColor;
        }




        /**
         * @param currentColor current color to set
         * @param rowPath GenericNodeKey row fields path that identify current row
         * @param colPath GenericNodeKey column fields path that identify current column
         * @param value value to show in the specified cell
         * @param row current row
         * @param col current column
         * @return Color foreground color to set
         */
        public Color getForegroundColor(Color currentColor,GenericNodeKey rowPath,GenericNodeKey colPath,Object value,int row,int col) {
          return currentColor;
        }




        /**
         * @param currentFont current font to set
         * @param rowPath GenericNodeKey row fields path that identify current row
         * @param colPath GenericNodeKey column fields path that identify current column
         * @param value value to show in the specified cell
         * @param row current row
         * @param col current column
         * @return font to set
         */
        public Font getFont(Font currentFont,GenericNodeKey rowPath,GenericNodeKey colPath,Object value,int row,int col) {
          if (rowPath.getPath().length<pivotTable.getPivotTableParameters().getRowFields().size() ||
              colPath.getPath().length<pivotTable.getPivotTableParameters().getColumnFields().size()+1)
            return new Font(currentFont.getFontName(),Font.BOLD,currentFont.getSize());
          return currentFont;
        }


      });






      controlComp.addItemListener(new ItemListener() {


        public void itemStateChanged(ItemEvent e) {
          Object companyCodeSys01 = controlComp.getValue();
          if (companyCodeSys01==null)
            companyCodeSys01 = controlComp.getDomain().getDomainPairList()[0].getCode();


          SalesPivotVO vo= (SalesPivotVO)filterPanel.getVOModel().getValueObject();
          vo.setCompanyCode((String)companyCodeSys01);
        }


      });


  }

View Full Code Here


        public void codeValidated(boolean validated) {}


        public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
          // fill in the grid v.o., according to the selected item settings...
          GridItemVO vo = (GridItemVO)filterPanel.getVOModel().getValueObject();
          if (vo.getItemCodeITM01()==null || vo.getItemCodeITM01().equals("")) {
            grid.getOtherGridParams().remove(ApplicationConsts.ITEM_PK);
          }
          else {
            grid.getOtherGridParams().put(ApplicationConsts.ITEM_PK,new ItemPK(
                vo.getCompanyCodeSys01ITM01(),
                vo.getItemCodeITM01()
            ));
          }
        }


        public void beforeLookupAction(ValueObject parentVO) { }

View Full Code Here


        public void codeValidated(boolean validated) {}


        public void codeChanged(ValueObject parentVO,Collection parentChangedAttributes) {
          // fill in the grid v.o., according to the selected item settings...
          GridItemVO vo = (GridItemVO)filterPanel.getVOModel().getValueObject();
          if (vo.getItemCodeITM01()==null || vo.getItemCodeITM01().equals("")) {
            grid.getOtherGridParams().remove(ApplicationConsts.ITEM_PK);
            reloadButton.setEnabled(false);
          }
          else {
            grid.getOtherGridParams().put(ApplicationConsts.ITEM_PK,new ItemPK(
                vo.getCompanyCodeSys01ITM01(),
                vo.getItemCodeITM01()
            ));
            reloadButton.setEnabled(true);
          }
        }

View Full Code Here

   // the pk attribute must be recalculated from the grid...
   int row = -1;
   if (parentFrame!=null)
     parentFrame.getGrid().getSelectedRow();
   if (row!=-1) {
     GridItemVO gridVO = (GridItemVO)parentFrame.getGrid().getVOListTableModel().getObjectForRow(row);
     pk = new ItemPK(gridVO.getCompanyCodeSys01ITM01(),gridVO.getItemCodeITM01());
   }


    return ClientUtils.getData("loadItem",pk);
  }

View Full Code Here

   * @param rowNumber selected row index
   * @param persistentObject v.o. related to the selected row
   */
  public void doubleClick(int rowNumber,ValueObject persistentObject) {
    // create item detail frame in READONLY mode...
    GridItemVO vo = (GridItemVO)persistentObject;
    ItemPK pk = new ItemPK(vo.getCompanyCodeSys01ITM01(),vo.getItemCodeITM01());
    new ItemController(frame,pk,productsOnly);
  }

View Full Code Here

0 1

TOP

Related Classes of org.jallinone.items.java.GridItemVO

org.jallinone.items.client.ItemController

org.jallinone.items.client.ItemsController

org.jallinone.items.spareparts.client.SparePartsCatalogueFrame

org.jallinone.production.billsofmaterial.client.ProductPanel

org.jallinone.purchases.suppliers.client.SupplierDetailFrame

org.jallinone.purchases.suppliers.client.SupplierItemsController

org.jallinone.sales.pricelist.client.PricesController

org.jallinone.sales.reports.client.SalesPivotFrame

org.jallinone.scheduler.callouts.client.CallOutRequestFrame

org.jallinone.warehouse.availability.client.BookedItemsPanel

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.