Exemplo n.º 1
0
 @Override
 public String save(
     HttpServletRequest request,
     @ModelAttribute("modelObject") Invoice entity,
     BindingResult bindingResult,
     ModelMap model) {
   // TODO Auto-generated method stub
   if (entity.getTransferStation() == null) {
     bindingResult.rejectValue("transferStation", "error.select.option", null, null);
   }
   if (entity.getLandfill() == null) {
     bindingResult.rejectValue("landfill", "error.select.option", null, null);
   }
   // validate entity
   try {
     getValidator().validate(entity, bindingResult);
   } catch (ValidationException e) {
     e.printStackTrace();
     log.warn("Error in validation :" + e);
   }
   // return to form if we had errors
   if (bindingResult.hasErrors()) {
     setupCreate(model, request);
     return urlContext + "/form";
   }
   String path = Configuration.getProperty("storage.folder.repository") + "/" + "invoice";
   CommonsMultipartFile file = entity.getInvoiceFile();
   String invoicefileName = file.getOriginalFilename();
   File folderpath = new File(path);
   try {
     if (!folderpath.exists()) {
       folderpath.mkdirs();
     }
     String fullpath = path + "/" + invoicefileName;
     System.out.println(fullpath);
     File invoicefile = new File(fullpath);
     if (!invoicefile.exists()) {
       invoicefile.createNewFile();
     }
     file.transferTo(invoicefile);
     entity.setFilePath(fullpath);
     beforeSave(request, entity, model);
     // merge into datasource
     genericDAO.saveOrUpdate(entity);
     cleanUp(request);
   } catch (IOException e) {
     e.printStackTrace();
   }
   return "redirect:list.do";
 }
Exemplo n.º 2
0
  @RequestMapping(value = "/downloadinvoice.do")
  public String downlodinvoice(
      HttpServletRequest request, Model model, HttpServletResponse response) {
    String invoiceId = request.getParameter("id");
    String type = request.getParameter("type");
    Invoice invoice = genericDAO.getById(Invoice.class, Long.valueOf(invoiceId));

    try {

      String rateQuery1 = null;
      rateQuery1 =
          "select obj from BillingRate obj where obj.transferStation="
              + invoice.getTransferStation().getId()
              + " and obj.landfill="
              + invoice.getLandfill().getId();

      List<BillingRate> fs = genericDAO.executeSimpleQuery(rateQuery1);

      BillingRate billingRate = null;
      if (fs != null && fs.size() > 0) {
        billingRate = fs.get(0);
      }

      Map params = new HashMap();
      List<Billing> datas = null;
      params.put("invoiceNo", invoice.getInvoiceNumber());
      params.put("origin", invoice.getTransferStation().getName());
      params.put("destination", invoice.getLandfill().getName());

      if (invoice.getLandfill().getName().equalsIgnoreCase("Grows/Tullytown")) {
        Location grows = null;
        Location tullyTown = null;

        Map criterias = new HashMap();
        criterias.put("name", "Grows");
        criterias.put("type", 2);
        grows = genericDAO.getByCriteria(Location.class, criterias);
        criterias.clear();
        criterias.put("name", "Tullytown");
        criterias.put("type", 2);
        tullyTown = genericDAO.getByCriteria(Location.class, criterias);
        StringBuffer query =
            new StringBuffer(
                " select obj from Billing obj where obj.invoiceNo='"
                    + invoice.getInvoiceNumber()
                    + "' and obj.origin='"
                    + invoice.getTransferStation().getName()
                    + "' and obj.destination in ('"
                    + grows.getName()
                    + "','"
                    + tullyTown.getName()
                    + "')");
        if (billingRate != null) {
          int sortBy = (billingRate.getSortBy() == null) ? 1 : billingRate.getSortBy();
          if (sortBy == 1) {
            query.append(" order by obj.originTicket");
          } else {
            query.append(" order by obj.destinationTicket");
          }
        } else {
          query.append(" order by obj.originTicket");
        }

        datas = genericDAO.executeSimpleQuery(query.toString());
      } else {
        params.put("invoiceNo", invoice.getInvoiceNumber());
        params.put("origin", invoice.getTransferStation().getName());
        params.put("destination", invoice.getLandfill().getName());
        if (billingRate != null) {
          int sortBy = (billingRate.getSortBy() == null) ? 1 : billingRate.getSortBy();
          if (sortBy == 1) {
            datas =
                genericDAO.executeSimpleQuery(
                    "select obj from Billing obj where obj.invoiceNo='"
                        + invoice.getInvoiceNumber()
                        + "' and origin='"
                        + invoice.getTransferStation().getName()
                        + "' and destination='"
                        + invoice.getLandfill().getName()
                        + "' order by originTicket asc");
            // datas = genericDAO.findByCriteria(Billing.class, params,"originTicket",false);
          } else {
            datas =
                genericDAO.executeSimpleQuery(
                    "select obj from Billing obj where obj.invoiceNo='"
                        + invoice.getInvoiceNumber()
                        + "' and origin='"
                        + invoice.getTransferStation().getName()
                        + "' and destination='"
                        + invoice.getLandfill().getName()
                        + "' order by destinationTicket asc");
            // datas = genericDAO.findByCriteria(Billing.class, params,"destinationTicket",false);
          }
        } else {
          datas =
              genericDAO.executeSimpleQuery(
                  "select obj from Billing obj where obj.invoiceNo='"
                      + invoice.getInvoiceNumber()
                      + "' and origin='"
                      + invoice.getTransferStation().getName()
                      + "' and destination='"
                      + invoice.getLandfill().getName()
                      + "' order by originTicket asc");
          // datas = genericDAO.findByCriteria(Billing.class, params,"originTicket",false);
        }
      }
      if (datas != null && datas.size() > 0) {
        params.clear();
        // Location origin =
        // genericDAO.getById(Location.class,Long.parseLong(datas.get(0).getOrigin()));
        params.put("origin", datas.get(0).getOrigin());
        // Location destination =
        // genericDAO.getById(Location.class,Long.parseLong(datas.get(0).getDestination()));
        params.put("destination", invoice.getLandfill().getName());
        // params.put("destination", destination.getName());

        params.put("date", new SimpleDateFormat("MM-dd-yyyy").format(invoice.getInvoiceDate()));
        params.put("invoiceNo", datas.get(0).getInvoiceNo());
        params.put("sumBillableTon", invoice.getSumBillableTon());
        params.put("sumOriginTon", invoice.getSumOriginTon());
        params.put("sumDestinationTon", invoice.getSumDestinationTon());
        params.put("sumTonnage", invoice.getSumTonnage());
        params.put("sumTotal", invoice.getSumTotal());
        params.put("sumDemurrage", invoice.getSumDemmurage());
        params.put("sumNet", invoice.getSumNet());
        params.put("sumAmount", invoice.getSumAmount());
        params.put("sumFuelSurcharge", invoice.getSumFuelSurcharge());

        if (invoice.getSumGallon() == null) {
          double sumgallon = 0.0;
          for (Billing billing : datas) {
            sumgallon += billing.getGallon();
          }
          sumgallon = MathUtil.roundUp(sumgallon, 2);
          System.out.println("****** the value is " + sumgallon);
          params.put("sumGallon", sumgallon);

          Map criterias = new HashMap();
          criterias.clear();
          criterias.put("name", datas.get(0).getOrigin());
          Location origin = genericDAO.getByCriteria(Location.class, criterias);
          criterias.clear();
          criterias.put("name", datas.get(0).getDestination());
          Location destination = genericDAO.getByCriteria(Location.class, criterias);
          String queryInvoice =
              "select obj from Invoice obj where obj.invoiceNumber='"
                  + datas.get(0).getInvoiceNo()
                  + "' and obj.transferStation='"
                  + origin.getId()
                  + "' and obj.landfill='"
                  + destination.getId()
                  + "'";

          List<Invoice> actlInv = genericDAO.executeSimpleQuery(queryInvoice);

          if (!actlInv.isEmpty() && actlInv.size() > 0) {
            for (Invoice invobj : actlInv) {
              if (invobj.getSumGallon() == null) {

                invobj.setSumGallon(sumgallon);
                genericDAO.saveOrUpdate(invobj);
              }
            }
          }
        } else {
          params.put("sumGallon", invoice.getSumGallon());
        }
        ByteArrayOutputStream out = new ByteArrayOutputStream();

        // for 7 invoice format
        // String rateQuery1=null;
        BillingRate billingRate1 = null;
        /*rateQuery1 = "select obj from BillingRate obj where obj.transferStation="
                            + invoice.getTransferStation().getId() + " and obj.landfill=" + invoice.getLandfill().getId();
        System.out.println("***** the query is "+rateQuery1.toString());
            List<BillingRate> fs = genericDAO.executeSimpleQuery(rateQuery1);*/
        // System.out.println("\nrateSize===>"+fs.size()+"\n");
        if (fs != null && fs.size() > 0) {
          billingRate1 = fs.get(0);
          for (int i = 0; i < fs.size(); i++) {
            // System.out.println("\nrateSize===>"+i+"==>"+fs.get(i).getId()+"\n");
            if (i == fs.size() - 1) {
              billingRate1 = fs.get(i);
            }
          }
        }

        try {
          boolean b = false;
          try {
            if (billingRate1.getBilledby() != null) {}
          } catch (Exception e) {
            b = true;
          }
          if (!StringUtils.isEmpty(billingRate1.getBilledby()) && b != true) {
            /*if((billingRate1.getBilledby()).length()!=0 && (billingRate1.getBilledby()!=null))
            {*/
            if (billingRate1.getBilledby().equals("bydestination")) {
              if (type.equals("pdf")) {
                System.out.println("bydestinationbillingpdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "bydestinationbillingpdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "bydestinationbilling", datas, params, type, request);
              }
            }
            if (billingRate1.getBilledby().equals("byorigin")) {
              if (type.equals("pdf")) {
                System.out.println("byoriginbillingpdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "byoriginbillingpdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "byoriginbilling", datas, params, type, request);
              }
            }
            if (billingRate1.getBilledby().equals("bygallon")) {
              if (type.equals("pdf")) {
                System.out.println("bygallonbillingpdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "bygallonbillingpdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "bygallonbilling", datas, params, type, request);
              }
            }
            if (billingRate1.getBilledby().equals("bydestinationWeight")) {
              if (type.equals("pdf")) {
                System.out.println("bydestinationWeightpdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "bydestinationWeightpdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "bydestinationWeight", datas, params, type, request);
              }
            }
            if (billingRate1.getBilledby().equals("byoriginWeight")) {
              if (type.equals("pdf")) {
                System.out.println("byoriginWeightpdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "byoriginWeightpdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "byoriginWeight", datas, params, type, request);
              }
            }
            if (billingRate1.getBilledby().equals("bynoFuelSurchage")) {
              if (type.equals("pdf")) {
                System.out.println("bynoFuelSurchagepdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "bynoFuelSurchagepdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "bynoFuelSurchage", datas, params, type, request);
              }
            }
            if (billingRate1.getBilledby().equals("bynoTonnage")) {
              if (type.equals("pdf")) {
                System.out.println("bynoTonnagepdf");
                out =
                    dynamicReportService.generateStaticReport(
                        "bynoTonnagepdf", datas, params, type, request);
              } else {
                out =
                    dynamicReportService.generateStaticReport(
                        "bynoTonnage", datas, params, type, request);
              }
            }
          } else {
            System.out.println("\nbilledBy is empti\n");
            System.out.println("\nbilledBy  else===>" + billingRate1.getBilledby() + "\n");
            if (type.equals("pdf")) {
              out =
                  dynamicReportService.generateStaticReport(
                      "billingpdf", datas, params, type, request);
            } else {
              out =
                  dynamicReportService.generateStaticReport(
                      "billing", datas, params, type, request);
            }
          }
          response.setHeader(
              "Content-Disposition",
              "attachment;filename=inv" + invoice.getInvoiceNumber() + "." + type);
          out.writeTo(response.getOutputStream());
          out.close();
          return null;

        } catch (Exception e) {
          e.printStackTrace();
          request.getSession().setAttribute("errors", e.getMessage());
          return "error";
        }

        // for 7 invoice format

        /*if (type.equals("pdf")){
        out = dynamicReportService.generateStaticReport("billingpdf",
        	datas, params, type, request);
        }
        else{
        	out = dynamicReportService.generateStaticReport("billing",
        			datas, params, type, request);
        }
        response.setHeader("Content-Disposition",
        	"attachment;filename=inv" + invoice.getInvoiceNumber() + "."+type);
        out.writeTo(response.getOutputStream());
        out.close();
        return null;*/
      } else {
        request
            .getSession()
            .setAttribute("errors", "Unable to download invoice. Plesae try again later");
        return "error";
      }
    } catch (Exception ex) {
      ex.printStackTrace();
      request
          .getSession()
          .setAttribute("errors", "Unable to download invoice. Plesae try again later");
      return "error";
    }
  }