예제 #1
0
  public ArrayList<ProductCatalog> processRequest(String[] keyword, HttpServletRequest request) {
    ArrayList<ProductCatalog> productCatalogImplList = null;
    productCatalogImplList = new ArrayList<ProductCatalog>();
    System.out.println(keyword);
    try {

      String SOAPUrl = "http://api.mouser.com/service/searchapi.asmx";
      String xmlFile2Send = "";
      String SOAPAction = "";

      for (int iterator = 0; iterator < keyword.length; iterator++) {
        System.out.println("Inside IF line 83 ---> " + keyword[iterator]);
        xmlFile2Send =
            "<?xml version=\"1.0\" encoding=\"utf-8\"?>"
                + "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">"
                + "<soap:Header>"
                + "<MouserHeader xmlns=\"http://api.mouser.com/service\">"
                + "<AccountInfo>"
                + "<PartnerID>97d569b4-1f3c-46fd-a1a7-7a86a2221d6a</PartnerID>"
                + "</AccountInfo>"
                + "</MouserHeader>"
                + "</soap:Header>"
                + "<soap:Body>"
                + "<SearchByKeyword xmlns=\"http://api.mouser.com/service\">"
                + "<keyword>"
                + keyword[iterator]
                + "</keyword>"
                + "<records>1000</records>"
                + "<startingRecord>1</startingRecord>"
                + "<searchOptions>"
                + "RohsAndInStock"
                + "</searchOptions>"
                + "</SearchByKeyword>"
                + "</soap:Body>"
                + "</soap:Envelope>";
        SOAPAction = "http://api.mouser.com/service/SearchByKeyword";

        SOAPAction = "http://api.mouser.com/service/SearchByKeyword";

        // Create the connection where we're going to send the file.
        URL url = new URL(SOAPUrl);
        URLConnection connection = url.openConnection();
        HttpURLConnection httpConn = (HttpURLConnection) connection;

        SOAPMessage message;
        message = new MouserApiServiceImpl().getSoapMessageFromString(xmlFile2Send);
        URLEncoder.encode(xmlFile2Send, "UTF-8");
        ByteArrayOutputStream bout = new ByteArrayOutputStream();
        message.writeTo(bout);

        byte[] b = bout.toByteArray();

        // Set the appropriate HTTP parameters.
        httpConn.setRequestProperty("Content-Length", String.valueOf(b.length));
        httpConn.setRequestProperty("Content-Type", "text/xml; charset=utf-8");
        httpConn.setRequestProperty("SOAPAction", SOAPAction);
        httpConn.setRequestMethod("POST");
        httpConn.setDoOutput(true);
        httpConn.setDoInput(true);

        // Everything's set up; send the XML that was read in to b.
        OutputStream out = httpConn.getOutputStream();
        out.write(b);
        out.close();

        // Read the response and write it to standard out.
        InputStreamReader isr = new InputStreamReader(httpConn.getInputStream());
        BufferedReader in = new BufferedReader(isr);

        String inputLine = null;
        DocumentBuilder builder = null;
        try {
          builder = DocumentBuilderFactory.newInstance().newDocumentBuilder();
        } catch (ParserConfigurationException e1) {
          e1.printStackTrace();
        }
        InputSource src = new InputSource();

        while ((inputLine = in.readLine()) != null) {
          // System.out.println(inputLine);
          src.setCharacterStream(new StringReader(inputLine));
        }

        Document doc = null;
        try {
          doc = builder.parse(src);
        } catch (SAXException e1) {
          e1.printStackTrace();
        }

        String numberOfResult = doc.getElementsByTagName("NumberOfResult").item(0).getTextContent();

        // Currency API for $ to Rs.
        String currency = null;

        try {
          Document cur =
              loadTestDocument(
                  "http://www.webservicex.net/CurrencyConvertor.asmx/ConversionRate?FromCurrency=USD&ToCurrency=INR"); //
          System.out.println(cur.getElementsByTagName("double").item(0).getTextContent());
          currency = cur.getElementsByTagName("double").item(0).getTextContent();
          System.out.println("currency" + currency); //
          if (!currency.equals("-1")) {
            mouserApiDao.updateCurrency(currency);
          }
        } catch (Exception e) {
          e.printStackTrace();
        }

        double currencyINR = mouserApiDao.getCurrency();
        // System.out.println(" Present INR for $1 USD is "+currencyINR+" ====== "+cur);

        int i = Integer.parseInt(numberOfResult);
        System.out.println("i value is " + i);
        System.out.println("currencyINR " + currencyINR);

        String FILE_PATH = "http://citsacademy.com/img/std01.jpg";
        ProductCatalog productCatalogImpl = null;
        SupplierCatalog supplierCatalogueImpl = null;
        try {

          for (int j = 0; j < i; j++) {
            productCatalogImpl = new ProductCatalog();
            supplierCatalogueImpl = new SupplierCatalog();
            if (doc.getElementsByTagName("ImagePath").item(j) == null) {
              productCatalogImpl.setImageUrl(FILE_PATH);
            } else {
              FILE_PATH = doc.getElementsByTagName("ImagePath").item(j).getTextContent();
              productCatalogImpl.setImageUrl(FILE_PATH);
              // try{
              // URL mousreImgeUrl = new URL(FILE_PATH);
              System.out.print("FILE_PATH" + FILE_PATH);
              /*
               * String pathData = request.getRealPath("");
               * System.out.println(" request.getRealPath 12 " +
               * pathData); File dir = new File(pathData +
               * File.separator +
               * DatabaseConstants.PRODUCT_IMAGE_PATH); if
               * (!dir.exists()) dir.mkdirs();
               *
               * // Create the file on server String imageName =
               * doc .getElementsByTagName(
               * "ManufacturerPartNumber").item(j)
               * .getTextContent() + ".jpg"; File serverFile = new
               * File(dir.getAbsolutePath() + File.separator +
               * imageName);
               *
               * String imageUrl = CoreConstants.IMAGE_URL +
               * DatabaseConstants.PRODUCT_IMAGE_PATH + imageName;
               *
               * InputStream is = mousreImgeUrl.openStream();
               * OutputStream os = new
               * FileOutputStream(serverFile);
               * System.out.print("available" + is.available());
               * byte[] bytesData = new byte[2048]; int length =
               * 0;
               *
               * while ((length = is.read(bytesData)) != -1) {
               * System.out.print("length" + length);
               * os.write(bytesData, 0, length); }
               *
               * is.close(); os.close();
               *
               * productCatalogImpl.setImageUrl(imageUrl);
               * }catch(Exception e){ e.printStackTrace(); }
               */
            }
            String[] stock =
                doc.getElementsByTagName("Availability").item(j).getTextContent().split(" ");
            if (StringUtils.isNotBlank(stock[0])) {
              if (!stock[0].equals("None")) {
                supplierCatalogueImpl.setStock(Integer.parseInt(stock[0]));
              }
            }
            productCatalogImpl.setDataSheet(
                doc.getElementsByTagName("DataSheetUrl").item(j).getTextContent());
            productCatalogImpl.setDescription(
                doc.getElementsByTagName("Description").item(j).getTextContent());
            productCatalogImpl.setCategoryName(
                doc.getElementsByTagName("Category").item(j).getTextContent());
            String[] leadTime =
                doc.getElementsByTagName("LeadTime").item(j).getTextContent().split(" ");
            if (leadTime != null) {
              supplierCatalogueImpl.setLeadTime(Integer.parseInt(leadTime[0]));
            }

            String lf = doc.getElementsByTagName("LifecycleStatus").item(j).getTextContent();
            String purl = doc.getElementsByTagName("ProductDetailUrl").item(j).getTextContent();
            String reeling = doc.getElementsByTagName("Reeling").item(j).getTextContent();

            System.out.println("LifelCycleStatus" + lf);
            System.out.println("ProductDetailUrl" + purl);
            System.out.println("reeling" + reeling);

            productCatalogImpl.setManufacturerName(
                doc.getElementsByTagName("Manufacturer").item(j).getTextContent());
            productCatalogImpl.setManufacturerPart(
                doc.getElementsByTagName("ManufacturerPartNumber").item(j).getTextContent());
            supplierCatalogueImpl.setMinu(
                Integer.parseInt(doc.getElementsByTagName("Min").item(j).getTextContent()));
            supplierCatalogueImpl.setMult(
                Integer.parseInt(doc.getElementsByTagName("Mult").item(j).getTextContent()));
            productCatalogImpl.setSemikartPart(
                doc.getElementsByTagName("MouserPartNumber").item(j).getTextContent());
            productCatalogImpl.setPriceBreaks(
                doc.getElementsByTagName("PriceBreaks").item(j).getTextContent());
            System.out.println("PriceBreakssssssssss" + productCatalogImpl.getPriceBreaks());

            productCatalogImpl.setRohs(
                doc.getElementsByTagName("ROHSStatus").item(j).getTextContent());
            /*
             * mou.setSuggestedReplacement(doc
             * .getElementsByTagName("SuggestedReplacement")
             * .item(j).getTextContent()); mou.setMultiSimBlue(doc
             * .getElementsByTagName("MultiSimBlue").item(j)
             * .getTextContent());
             */

            productCatalogImpl.setIsNewProduct("N");
            productCatalogImpl.setIsFeaturedProduct("N");
            productCatalogImpl.setApiName("Mouser");

            /*
             * try { // Contacting the URL URL mousreDataSheetUrl =
             * new URL( productCatalogImpl.getDataSheet()); String
             * pathData1 = request.getRealPath("");
             * System.out.println(" request.getRealPath 12 " +
             * pathData1); File dir = new File(pathData1 +
             * File.separator +
             * DatabaseConstants.PRODUCT_DATASHEET_PATH); if
             * (!dir.exists()) dir.mkdirs();
             *
             * // Create the file on server String dataSheetName =
             * doc .getElementsByTagName(
             * "ManufacturerPartNumber").item(j) .getTextContent() +
             * ".pdf"; File serverFile = new
             * File(dir.getAbsolutePath() + File.separator +
             * dataSheetName);
             *
             * String dataSheetUrl = CoreConstants.IMAGE_URL +
             * DatabaseConstants.PRODUCT_DATASHEET_PATH +
             * dataSheetName; InputStream isDataSheet =
             * mousreDataSheetUrl .openStream(); OutputStream os =
             * new FileOutputStream(serverFile);
             *
             * byte[] bytesData = new byte[2048]; int length = 0;
             *
             * while ((length = isDataSheet.read(bytesData)) != -1)
             * {
             *
             * os.write(bytesData, 0, length); }
             *
             * isDataSheet.close(); os.close();
             * productCatalogImpl.setDataSheet(dataSheetUrl); }
             * catch (Exception npe) {
             * System.out.println("FAILED.\n[" + npe.getMessage() +
             * "]\n"); }
             */

            long manuFacturerId =
                mouserApiDao.getManufacturerId(productCatalogImpl.getManufacturerName());
            if (manuFacturerId == 0) {
              ManufacturerConfig manufacturersImpl = new ManufacturerConfig();
              manufacturersImpl.setManuFacturerName(productCatalogImpl.getManufacturerName());
              manuFacturerId = mouserApiDao.saveManufacturer(manufacturersImpl);
            }
            productCatalogImpl.setManufacturerId(manuFacturerId);

            List<SubcategoryImpl> subcategoryImplList =
                mouserApiDao.findVatDetailsOnSubCategoryName(productCatalogImpl.getCategoryName());

            String mainCategoryName = null;
            String mainSubCategory = null;
            System.out.println("Size" + subcategoryImplList.size());
            if (subcategoryImplList.size() != 0) {
              mainCategoryName = subcategoryImplList.get(0).getCategory();
              mainSubCategory = subcategoryImplList.get(0).getMainSubCategory();
              // category =
              // subcategoryImplList.get(0) .getSubCategory();

            } else {
              mainCategoryName = "Unknown";
              mainSubCategory = "Unknown";
            }

            long categoryId = mouserApiDao.getCategoryId(productCatalogImpl.getCategoryName());
            System.out.println(
                "Category Name"
                    + productCatalogImpl.getCategoryName()
                    + "Category Id"
                    + categoryId);

            /*
             * if (maincategoryId == 0) { MainCatagory mainCatagory
             * = new MainCatagory();
             * mainCatagory.setMaincatagoryName(mainCategoryName);
             * maincategoryId = mouserApiDao
             * .saveMaincategory(mainCatagory); }
             */

            /*
             * if (mainSubcategoryId == 0) { MainSubCatagory
             * mainSubCatagory = new MainSubCatagory();
             * mainSubCatagory
             * .setMainSubCatagoryName(mainSubCategory);
             * mainSubCatagory.setMainCatagoryId(maincategoryId);
             * mainSubcategoryId = mouserApiDao
             * .saveMainSubcategory(mainSubCatagory); }
             */

            if (categoryId == 0) {
              Category categoryObj = new Category();
              categoryObj.setCatagoryName(productCatalogImpl.getCategoryName());
              /*
               * categoryObj.setVat(subcategoryImplList.get(0)
               * .getVat());
               * categoryObj.setHfi(subcategoryImplList.get(0)
               * .getHfi());
               * categoryObj.setCurrencyMarkup(subcategoryImplList
               * .get(0).getCurrencyMarkup());
               * categoryObj.setDuty(subcategoryImplList.get(0)
               * .getDuty());
               */
              categoryObj.setMainSubcatagoryId(260);
              categoryId = mouserApiDao.saveCategory(categoryObj);
            } else {
              long maincategoryId = mouserApiDao.getMainCategoryId(mainCategoryName);
              long mainSubcategoryId = mouserApiDao.getMainSubCategoryId(mainSubCategory);
              mouserApiDao.updateMainSubCategory(maincategoryId, mainSubcategoryId);
              mouserApiDao.updateCategory(mainSubcategoryId, categoryId);
            }
            productCatalogImpl.setCategoryId(categoryId);
            productCatalogImpl.setStatus("LOCKED");
            long productCatalogId =
                mouserApiDao.getProductCatalogId(productCatalogImpl.getManufacturerPart());
            // Inserting into product catatalog Table
            if (productCatalogId == 0) {
              productCatalogId = mouserApiDao.saveProductCataLog(productCatalogImpl);
            } /*
               * else { productCatalogImpl
               * .setProductCatalogId(productCatalogId); mouserApiDao
               * .updateProductCataLog(productCatalogImpl); }
               */

            long supplierId = mouserApiDao.getSupplierId("Aqtronics");
            String sku = productCatalogImpl.getManufacturerPart() + String.valueOf(supplierId);
            if (supplierId == 0) {
              SupplierConfig supplierConfig = new SupplierConfig();
              supplierConfig.setSupplierName("Aqtronics");
              supplierId = mouserApiDao.insertSupplier(supplierConfig);
            }

            long supplierCatalogId =
                mouserApiDao.getSupplierCatalogId(supplierId, productCatalogId);

            supplierCatalogueImpl.setProductCatalogId(productCatalogId);
            supplierCatalogueImpl.setSku(sku);
            supplierCatalogueImpl.setSupplierId(supplierId);
            if (supplierCatalogId == 0) {
              supplierCatalogId = mouserApiDao.insertSupplierCatalog(supplierCatalogueImpl);
            }
            Category category = mouserApiDao.getCategoryDetailsBasedOn(categoryId);
            try {
              if (category.getVat() != 0) {
                calculatePrice(
                    category,
                    productCatalogImpl.getPriceBreaks(),
                    currencyINR,
                    productCatalogImpl.getManufacturerPart(),
                    productCatalogId,
                    supplierId,
                    sku);
              }
            } catch (Exception e) {
              e.printStackTrace();
            }
            productCatalogImpl.setSupplierCatalog(supplierCatalogueImpl);

            productCatalogImplList.add(productCatalogImpl);
          } // end of For loop

        } catch (Exception e) {
          e.printStackTrace();
        }
      }
    } catch (Exception e) {
      e.printStackTrace();
    }

    return productCatalogImplList;
  }
예제 #2
0
  public ArrayList<PriceTag> calculatePrice(
      Category category,
      String priceBreaks,
      double currencyINR,
      String manuFacturerPartNumber,
      long productCatalogId,
      long supplierId,
      String sku) {
    ArrayList<PriceTag> priceTagImplsList = new ArrayList<PriceTag>();
    double cur_markup = category.getCurrencyMarkup();
    double dty = category.getDuty();
    double hfin = category.getHfi();
    double vt = category.getVat();
    hfin = hfin / 100;
    dty = dty / 100;
    vt = vt / 100;

    // Splitting the whole string in to two parts
    String[] temp = priceBreaks.split("USD");
    System.out.println("priceBreaks" + priceBreaks);
    System.out.println("temp.length" + temp.length);
    PriceTag priceTagImpl = null;
    if (temp.length != 1) {
      for (int j1 = 0; j1 < temp.length; j1++) {
        priceTagImpl = new PriceTag();
        int rup = j1;
        String semi = temp[j1];
        try {
          System.out.println("Semi" + semi);

          String[] sem = semi.split(java.util.regex.Pattern.quote("$"));
          String ss = "";
          System.out.println(sem[1]);
          String[] semi1 = sem[1].split(java.util.regex.Pattern.quote(","));
          if (semi1.length < 2) {
            ss = semi1[0];
          } else {
            ss = semi1[0] + semi1[1];
          }
          double dolToRup;
          if (ss != null) { // semi1[1] != null) {
            dolToRup = Double.parseDouble(ss); // semi1[1]);
            dolToRup = dolToRup * currencyINR;
            dolToRup = dolToRup + cur_markup; // adding
            dolToRup = dolToRup + (dolToRup * dty);
            dolToRup = dolToRup + (dolToRup * hfin);
            String temp11 = String.format("%.2f", dolToRup);
            ss = temp11;
            if (rup == 0) {}

            String type;
            Double dd = vt * 100;
            String temp1111 = String.format("%.2f", dd);
            if (dty == 0 && vt == 0) {
              type = "Exclusive of Duty & VAT";
            } else {
              type = "Inclusive of Duty + " + temp1111 + "% VAT as Applicable";
            }

            priceTagImpl.setQuentity(Integer.parseInt(sem[0]));

            priceTagImpl.setSalePrice(Float.parseFloat(ss));
            priceTagImpl.setRetailPrice(Float.parseFloat(ss));
            priceTagImpl.setTax(type);
          }
        } catch (Exception e) {
          e.printStackTrace();
        }
        priceTagImpl.setSku(sku);
        long priceTagId =
            mouserApiDao.getPriceTagId(supplierId, productCatalogId, priceTagImpl.getQuentity());
        priceTagImpl.setSupplierId(supplierId);
        priceTagImpl.setProductCatalogId(productCatalogId);
        if (priceTagId == 0) {
          mouserApiDao.insertPriceTag(priceTagImpl);
        } else {
          priceTagImpl.setPriceTagId(priceTagId);
          mouserApiDao.updatePriceTag(priceTagImpl);
        }
        priceTagImplsList.add(priceTagImpl);
      }
    }
    return priceTagImplsList;
  }