Examples of GridParams

org.openswing.swing.message.send.java.GridParams

Examples of org.openswing.swing.message.send.java.GridParams

      Connection conn = null;
      try {
        conn = ConnectionManager.getConnection(null);
        bean.setConn(conn);


        GridParams gridParams = new GridParams();
        Response answer = bean.loadETLProcesses(gridParams,"",null);
        if (!answer.isError()) {
          java.util.List list = ((VOListResponse)answer).getRows();
          ETLProcessVO vo = null;
          for(int i=0;i<list.size();i++) {

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

    // - add all item types
    Domain dit = new Domain("DATA_IMPORT_TYPE");
    int pos = 0;
    DataImportType ditVO = null;
    java.util.List itemTypesList = null;
    Response res = ClientUtils.getData("loadItemTypes",new GridParams());
    if (!res.isError()) {
      ItemTypeVO vo = null;
      itemTypesList = ((VOListResponse)res).getRows();
      for(int i=0;i<itemTypesList.size();i++) {
        vo = (ItemTypeVO)itemTypesList.get(i);
        ditVO = new DataImportType();
        ditVO.comboItemIndex = pos++;
        ditVO.progressiveHIE02 = vo.getProgressiveHie02ITM02();
        ditVO.subTypeCode = vo.getProgressiveHie02ITM02();
        ditVO.className = ImportItemsDescriptorVO.class.getName();
        ditVO.companyCodeSys01 = vo.getCompanyCodeSys01ITM02();


        dit.addDomainPair(
          ditVO,
          ClientSettings.getInstance().getResources().getResource("import")+" "+vo.getDescriptionSYS10()
        );
      }
    }


    // add to the domain about data import type:
    // - customers
    ClientApplet applet = ( (ApplicationClientFacade) MDIFrame.getInstance().getClientFacade()).getMainClass();
    ButtonCompanyAuthorizations bca = applet.getAuthorizations().getCompanyBa();
    ArrayList companiesList = bca.getCompaniesList("SAL07");
    for(int i=0;i<companiesList.size();i++) {
      if (applet.getAuthorizations().getCompanyBa().isInsertEnabled("SAL07",companiesList.get(i).toString())) {
        ditVO = new DataImportType();
        ditVO.comboItemIndex = pos++;
        ditVO.className = ImportCustomersDescriptorVO.class.getName();
        ditVO.companyCodeSys01 = companiesList.get(i).toString();
        dit.addDomainPair(
          ditVO,
          ClientSettings.getInstance().getResources().getResource("import")+" "+ClientSettings.getInstance().getResources().getResource("customers")+" "+companiesList.get(i).toString()
        );
      }
    }




    // add to the domain about data import type:
    // - sale pricelists
    res = ClientUtils.getData("loadPricelists",new GridParams());
    if (!res.isError()) {
      PricelistVO vo = null;
      java.util.List list = ((VOListResponse)res).getRows();
      for(int i=0;i<list.size();i++) {
        vo = (PricelistVO)list.get(i);
        ditVO = new DataImportType();
        ditVO.comboItemIndex = pos++;
        ditVO.subTypeCode = vo.getPricelistCodeSAL01();
        ditVO.className = ImportSalePricesDescriptorVO.class.getName();
        ditVO.companyCodeSys01 = vo.getCompanyCodeSys01SAL01();


        dit.addDomainPair(
          ditVO,
          ClientSettings.getInstance().getResources().getResource("import sale prices")+" "+
          ClientSettings.getInstance().getResources().getResource("for pricelist")+" "+vo.getDescriptionSYS10()
        );
      }
    }


    // add to the domain about data import type:
    // - supplier items
    res = ClientUtils.getData("loadSuppliers",new GridParams());
    if (!res.isError()) {
      GridSupplierVO vo = null;
      ItemTypeVO itemTypeVO = null;
      java.util.List list = ((VOListResponse)res).getRows();
      for(int i=0;i<list.size();i++) {
        vo = (GridSupplierVO)list.get(i);
        for(int j=0;j<itemTypesList.size();j++) {
          itemTypeVO = (ItemTypeVO)itemTypesList.get(j);
          ditVO = new DataImportType();
          ditVO.comboItemIndex = pos++;
          ditVO.subTypeCode = vo.getProgressiveREG04();
          ditVO.subTypeCode2 = itemTypeVO.getProgressiveHie02ITM02();
          ditVO.progressiveHIE02 = itemTypeVO.getProgressiveHie02ITM02();
          ditVO.className = ImportSupplierItemsDescriptorVO.class.getName();
          ditVO.companyCodeSys01 = vo.getCompanyCodeSys01REG04();


          dit.addDomainPair(
            ditVO,
            ClientSettings.getInstance().getResources().getResource("import")+" "+
            itemTypeVO.getDescriptionSYS10()+" "+
            ClientSettings.getInstance().getResources().getResource("for supplier")+" "+
            vo.getName_1REG04()
          );
        }
      }
    }


    // add to the domain about data import type:
    // - supplier prices
    res = ClientUtils.getData("loadSupplierPricelists",new GridParams());
    if (!res.isError()) {
      SupplierPricelistVO vo = null;
      java.util.List list = ((VOListResponse)res).getRows();
      for(int i=0;i<list.size();i++) {
        vo = (SupplierPricelistVO)list.get(i);

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

      CustomFunctionVO vo = (CustomFunctionVO)((VOResponse)res).getVo();
      setTitle(vo.getDescriptionSYS10());
      controlNote.setValue(vo.getNoteSYS16());


      // retrieve columns info...
      GridParams gridParams = new GridParams();
      gridParams.getOtherGridParams().put(ApplicationConsts.FUNCTION_CODE_SYS06,functionCode);
      res = ClientUtils.getData("loadCustomColumns",gridParams);
      if (res.isError()) {
        JOptionPane.showMessageDialog(
          MDIFrame.getInstance(),
          ClientSettings.getInstance().getResources().getResource(res.getErrorMessage()),

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

      if (this.conn==null) conn = getConn(); else conn = this.conn;
      movBean.setConn(conn);
      bean.setConn(conn);


      // retrieve all out delivery note rows...
      GridParams pars = new GridParams();
      pars.getOtherGridParams().put(ApplicationConsts.DELIVERY_NOTE_PK,pk);
      Response res = bean.loadOutDeliveryNoteRows(variant1Descriptions,variant2Descriptions,variant3Descriptions,variant4Descriptions,variant5Descriptions,pars,serverLanguageId,username);
      if (res.isError())
        throw new Exception(res.getErrorMessage());


      String sql1 =

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

      loadSaleDocBean.setConn(conn);
      movBean.setConn(conn);
      bean.setConn(conn);


      // retrieve all out delivery note rows...
      GridParams pars = new GridParams();
      pars.getOtherGridParams().put(ApplicationConsts.DELIVERY_NOTE_PK,pk);
      Response res = bean.loadOutDeliveryNoteRows(variant1Descriptions,variant2Descriptions,variant3Descriptions,variant4Descriptions,variant5Descriptions,pars,serverLanguageId,username);
      if (res.isError())
        throw new Exception(res.getErrorMessage());


      ArrayList values = new ArrayList();

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

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


             //vo.setQtyDOC02();
             //vo.setSupplierItemCodePur02DOC10();
             //vo.setSupplierQtyDecimalsREG02();
             //vo.setUmCodeREG02();
             //vo.setUmCodeReg02PUR02();
             //vo.setValueREG05();
             vo.setVariantCodeItm11DOC10(barcodeVO.getVariantCodeItm11ITM22());
             vo.setVariantCodeItm12DOC10(barcodeVO.getVariantCodeItm12ITM22());
             vo.setVariantCodeItm13DOC10(barcodeVO.getVariantCodeItm13ITM22());
             vo.setVariantCodeItm14DOC10(barcodeVO.getVariantCodeItm14ITM22());
             vo.setVariantCodeItm15DOC10(barcodeVO.getVariantCodeItm15ITM22());
             vo.setVariantTypeItm06DOC10(barcodeVO.getVariantTypeItm06ITM22());
             vo.setVariantTypeItm07DOC10(barcodeVO.getVariantTypeItm07ITM22());
             vo.setVariantTypeItm08DOC10(barcodeVO.getVariantTypeItm08ITM22());
             vo.setVariantTypeItm09DOC10(barcodeVO.getVariantTypeItm09ITM22());
             vo.setVariantTypeItm10DOC10(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,DOC02_SELLING_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 "+
                 "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.QTY-DOC02_SELLING_ITEMS.OUT_QTY>0 AND "+
                 "DOC02_SELLING_ITEMS.ITEM_CODE_ITM01=ITM01_ITEMS.ITEM_CODE 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='*' ";


             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.getCompanyCodeSys01DOC01());
             values.add(code);
             values.add(serverLanguageId);
             values.add(pk.getDocTypeDOC01());
             values.add(pk.getDocYearDOC01());
             values.add(pk.getDocNumberDOC01());


             // 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.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());

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

    return "loadReferences";
  }




  public final Response executeCommand(Object inputPar,UserSessionParameters userSessionPars,HttpServletRequest request, HttpServletResponse response,HttpSession userSession,ServletContext context) {
    GridParams gridParams = (GridParams)inputPar;
    try {


      Subjects bean = (Subjects)JAIOBeanFactory.getInstance().getBean(Subjects.class);
      Response answer = bean.loadReferences(gridParams,((JAIOUserSessionParameters)userSessionPars).getServerLanguageId(),userSessionPars.getUsername());

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

      attribute2dbField.put("enabledREG09","REG09_CARRIERS.ENABLED");


      ArrayList values = new ArrayList();
      values.add(serverLanguageId);


      GridParams gridParams = new GridParams();


      // read from REG09 table...
      Response answer = CustomizeQueryUtil.getQuery(
          conn,
          new UserSessionParameters(username),

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

      if (validationPars.getLookupValidationParameters().get(ApplicationConsts.CURRENCY_CODE_REG03)!=null) {
        sql += " and SAL09_ACTIVITIES.CURRENCY_CODE_REG03=? ";
        values.add( validationPars.getLookupValidationParameters().get(ApplicationConsts.CURRENCY_CODE_REG03) );
      }


      GridParams gridParams = new GridParams();


      // read from SAL09 table...
      Response answer = CustomizeQueryUtil.getQuery(
          conn,
          new UserSessionParameters(username),

View Full Code Here

Examples of org.openswing.swing.message.send.java.GridParams

//      // retrieve internationalization settings (Resources object)...
//      ServerResourcesFactory factory = (ServerResourcesFactory)context.getAttribute(Controller.RESOURCES_FACTORY);
//      Resources resources = factory.getResources(userSessionPars.getLanguageId());


      // retrieve all in delivery note rows...
      GridParams pars = new GridParams();
      pars.getOtherGridParams().put(ApplicationConsts.DELIVERY_NOTE_PK,pk);
      Response res = bean.loadInDeliveryNoteRows(variant1Descriptions,variant2Descriptions,variant3Descriptions,variant4Descriptions,variant5Descriptions,pars,serverLanguageId,username);
      if (res.isError())
        throw new Exception(res.getErrorMessage());


      ArrayList values = new ArrayList();

View Full Code Here

0 1 2 3 4 5

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.