/**
   * Getting details on clicking service
   *
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return
   * @throws Exception
   */
  @SuppressWarnings("all")
  public ActionForward getDetails(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {

    new TransactionContext((UserDetails) request.getSession(false).getAttribute("userDetails"));
    AshaLogger.logInfo(logger, this.getClass().getName(), "getDetails", "Executing");
    String status = "";
    String startDate = request.getParameter("startDate");
    String endDate = request.getParameter("endDate");
    String name = request.getParameter("name");
    // logger.info("name is get detais is "+name);
    String sgcode = request.getParameter("sgcode");
    AmountDueDao amountDao = new AmountDueDao();
    if (name.equalsIgnoreCase("advances")) {
      status = amountDao.getAdvanceDetailsForExcel(name, startDate, endDate, sgcode, request);
      request.setAttribute("advance", "advance");
    } else if (name.equalsIgnoreCase("discount(-)")) {
      status = amountDao.getDiscountDetailsForExcel(name, startDate, endDate, sgcode, request);
      request.setAttribute("discount", "discount");
    } else if (name.equalsIgnoreCase("Refund(-)")) {
      status = amountDao.getRefundDetailsForExcel(name, startDate, endDate, sgcode, request);
      request.setAttribute("refund", "refund");
    } else if (name.equalsIgnoreCase("Pharmacy")) {
      status = amountDao.getPharmacyDetailsForExcel(name, startDate, endDate, sgcode, request);
      request.setAttribute("pharmacy", "pharmacy");
    } else if (name.equalsIgnoreCase("Unrealized")) {
      status = amountDao.getUnrealizedDetailsForExcel(name, startDate, endDate, sgcode, request);
      request.setAttribute("unrealized", "unrealized");
    } else {
      status = amountDao.getDetailsForExcel(name, startDate, endDate, sgcode, request);
    }

    request.setAttribute("hidden_startDate", startDate);
    request.setAttribute("hidden_endDate", endDate);

    ActionForward actionForward = mapping.findForward(status);
    return actionForward;
  }