@RequestMapping(value = "/vendorReturnSearch", method = RequestMethod.GET)
  @Scope("request")
  public ModelAndView searchVendorReturn(
      @ModelAttribute("vendorReturnCommand") VendorReturn vendorReturnSearch,
      BindingResult bindingResult,
      HttpServletRequest request,
      HttpServletResponse response) {
    response.setCharacterEncoding("UTF-8");
    List<VendorReturn> vrlist = new ArrayList<VendorReturn>();
    List<Object> list = null;
    List<Object> lob = null;
    try {

      String dbField = vendorReturnSearch.getXmlLabel();
      String operation = vendorReturnSearch.getOperations();
      String basicSearchId = vendorReturnSearch.getBasicSearchId();

      if (operation.equals("_%")) {
        operation = " like ";
        basicSearchId = basicSearchId + "%";

      } else if (operation.equals("%_")) {
        operation = " like ";
        basicSearchId = "%" + basicSearchId;

      } else if (operation.equals("%_%")) {
        operation = " like ";
        basicSearchId = "%" + basicSearchId + "%";
      }
      if (basicSearchId == "") {

        lob = vrService.searchVendorReturn();

        Iterator<Object> iterator = lob.iterator();

        while (iterator.hasNext()) {
          VendorReturn vr = (VendorReturn) iterator.next();
          vr.setVendorReturnId(vr.getVendorReturnId());
          vr.setVendorReturnNo(vr.getVendorReturnNo());
          vr.setVendorReturnDate(
              dateService.dateFormat(dateService.dateParse(vr.getVendorReturnDate(), "se"), "se"));
          vr.setReference(vr.getReference());
          vr.setDescription(vr.getDescription());
          vr.setBatchNo(vr.getBatchNo());

          vrlist.add(vr);
        }

      } else {

        list = vrService.basicSearchVendorReturn(dbField, operation, basicSearchId);
        Iterator<Object> iter = list.iterator();

        while (iter.hasNext()) {
          VendorReturn vr = (VendorReturn) iter.next();
          vr.setVendorReturnId(vr.getVendorReturnId());
          vr.setVendorReturnNo(vr.getVendorReturnNo());
          vr.setVendorReturnDate(
              dateService.dateFormat(dateService.dateParse(vr.getVendorReturnDate(), "se"), "se"));
          vr.setReference(vr.getReference());
          vr.setDescription(vr.getDescription());
          vr.setBatchNo(vr.getBatchNo());
          vrlist.add(vr);
        }
      }

    } catch (Exception e) {
      e.printStackTrace();
    }
    request.setAttribute("vendorReturnSearch", vrlist);
    ModelAndView modelAndView = new ModelAndView();
    modelAndView.setViewName("vendorReturnHome");
    modelAndView.addObject("vendorReturnCommand");

    return modelAndView;
  }