Exemplo n.º 1
0
  @SuppressWarnings({"rawtypes"})
  public static synchronized void gerarRelatorio(
      List<? extends Entidade> lista, String formato, String caminhoImagem)
      throws JRException, IOException {
    if (lista != null && !lista.isEmpty()) {
      DynamicReport relatorio = criaRelatorioDinamico(lista, caminhoImagem);
      FacesContext context = FacesContext.getCurrentInstance();
      HttpServletResponse response =
          (HttpServletResponse) context.getExternalContext().getResponse();

      JasperPrint jasperPrint =
          DynamicJasperHelper.generateJasperPrint(relatorio, new ClassicLayoutManager(), lista);

      JRExporter jrExporter = null;
      String contentType = null;

      if ("PDF".equalsIgnoreCase(formato)) {
        jrExporter = new JRPdfExporter();
        contentType = "application/pdf";
      }

      if ("XLS".equalsIgnoreCase(formato)) {
        jrExporter = new JRXlsExporter();
        contentType = "application/vnd.ms-excel";
        jrExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
        jrExporter.setParameter(
            JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
        jrExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
      }

      response.setContentType(contentType);
      response.setHeader(
          "Content-Disposition",
          "attachment; filename=" + relatorio.getReportName() + "." + formato.toLowerCase());

      ServletOutputStream outputStream = response.getOutputStream();

      jrExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
      jrExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
      jrExporter.exportReport();
      outputStream.flush();
      outputStream.close();
      context.renderResponse();
      context.responseComplete();
    }
  }
  @FXML
  private void eventReporteVentas(ActionEvent event) throws JRException, ParseException {

    Style titleStyle = new Style();
    titleStyle.setFont(new Font(18, Font._FONT_VERDANA, true));
    titleStyle.setHorizontalAlign(HorizontalAlign.CENTER);
    Style amountStyle = new Style();
    amountStyle.setHorizontalAlign(HorizontalAlign.RIGHT);
    Style oddRowStyle = new Style();
    oddRowStyle.setBorder(Border.NO_BORDER());
    // Color veryLightGrey = new Color(230,230,230);
    // oddRowStyle.setBackgroundColor(veryLightGrey);
    oddRowStyle.setTextColor(new Color(112, 112, 112));
    oddRowStyle.setFont(new Font(12, Font._FONT_ARIAL, true));
    oddRowStyle.setTransparency(ar.com.fdvs.dj.domain.constants.Transparency.OPAQUE);
    oddRowStyle.setPaddingTop(2);
    oddRowStyle.setPaddingBottom(2);
    // Style HeaderStyle = new Style();
    // HeaderStyle.setFont(new Font(12,Font._FONT_ARIAL,true));

    int cont = 0;
    int cont3 = 0;
    String selecCampo = "";
    for (int i = 0; i < cb.length; i++) {
      if (cb[i].isSelected()) {
        cont++;
      }
    }
    for (int i = 0; i < group.length; i++) {
      if (group[i].isSelected()) {
        cont3++;
      }
    }

    int ancho = 580 / (cont + 1);
    ArrayList<AbstractColumn> colum = new ArrayList<>();
    AbstractColumn nombres[];
    int pun = 0;

    String fecha1 = checkInDatePicker.getValue().toString();
    String fecha2 = checkInDatePicker2.getValue().toString();

    SimpleDateFormat formateador = new SimpleDateFormat("yyyy-MM-dd");
    Date fechaDate1 = formateador.parse(fecha1);
    Date fechaDate2 = formateador.parse(fecha2);
    System.out.println("fecha1: " + fecha1);
    System.out.println("Fecha2: " + fecha2);

    if (cont != 0) {
      if (fechaDate1.before(fechaDate2) || fechaDate1.equals(fechaDate2)) {
        nombres = new AbstractColumn[cont];

        for (int i = 0; i < cb.length; i++) {
          if (cb[i].isSelected()) {
            if (i == 4 || i == 6) {
              nombres[pun] =
                  ColumnBuilder.getNew()
                      .setColumnProperty(cb[i].getId(), Integer.class.getName())
                      .setTitle(cb[i].getText())
                      .setWidth(ancho)
                      .setPattern("$ 0.00") // defines a pattern to apply to the values swhown (uses
                      // TextFormat)
                      // .setStyle(amountStyle)		//special style for this column (align right)
                      .setHeaderStyle(oddRowStyle)
                      .build();
              pun++;

            } else {
              nombres[pun] =
                  ColumnBuilder.getNew()
                      .setColumnProperty(cb[i].getId(), String.class.getName())
                      .setTitle(cb[i].getText())
                      .setWidth(ancho)
                      .setHeaderStyle(oddRowStyle)
                      .build();
              pun++;
            }
            if (cont3 != 0 && i == 6) {
              if (selecCampo.equals("")) {
                selecCampo = " sum(ventas.`total`) AS 'ventas.total' ";
              } else {
                selecCampo += " , sum(ventas.`total`) AS 'ventas.total' ";
              }
            } else {

              if (selecCampo.equals("")) {
                selecCampo = camposQuery[i];
              } else {
                selecCampo += "," + camposQuery[i];
              }
            }
          }
        }
        DynamicReportBuilder drb = new DynamicReportBuilder();
        DynamicReport dr = null;
        for (int i = 0; i < pun; i++) {
          drb.addColumn(nombres[i]);
        }
        Calendar c = Calendar.getInstance();
        String dia = Integer.toString(c.get(Calendar.DATE)) + "/";
        dia += Integer.toString(c.get(Calendar.MONTH) + 1) + "/";
        dia += Integer.toString(c.get(Calendar.YEAR));
        drb
            // .addGroups(2)
            .addImageBanner("./img/umaiSystem.png", 70, 70, ImageBanner.ALIGN_RIGHT)
            .setTitle("Reporte de ventas ")
            .setTitleStyle(titleStyle)
            .setSubtitle("Fecha de creacion: " + dia)
            .setDetailHeight(15)
            .setMargins(30, 20, 30, 15)
            .setPrintBackgroundOnOddRows(false)
            .setUseFullPageWidth(true)
            .setColumnsPerPage(1);

        String grupos = "";
        int cont2 = 0;
        for (int i = 0; i < group.length; i++) {
          if (group[i].isSelected()) {
            if (grupos.equals("")) {
              grupos = group[i].getId();
            } else {
              grupos += "," + group[i].getId();
            }

            cont2++;
          }
        }
        String Rango = " where ventas.fechaVenta Between '" + fecha1 + "' and '" + fecha2 + "'  ";

        String sql;
        if (cont2 != 0) {
          sql =
              " SELECT "
                  + selecCampo
                  + " FROM\n"
                  + "  `ventas` ventas  INNER JOIN `clientes` ON clientes.`idCli` = ventas.`idCli`\n"
                  + "     INNER JOIN `usuarios` usuarios ON ventas.`idUsu` = usuarios.`idUsu` "
                  + Rango
                  + " GROUP BY "
                  + grupos
                  + " ORDER BY ventas.idVenta ";
        } else {
          sql =
              " SELECT "
                  + selecCampo
                  + " FROM\n"
                  + "  `ventas` ventas  INNER JOIN `clientes` ON clientes.`idCli` = ventas.`idCli`\n"
                  + "  INNER JOIN `usuarios` usuarios ON ventas.`idUsu` = usuarios.`idUsu` "
                  + Rango
                  + " ORDER BY ventas.idVenta ";
        }
        System.out.println("sql: " + sql);

        Connection conexion = null;
        // conexion=Helpers.db.db.conn;
        conexion = Helpers.db.getDbCon().conn;

        drb.setQuery(sql, DJConstants.QUERY_LANGUAGE_SQL);
        dr = drb.build(); // Finally build the report!
        //       JasperPrint jp=DynamicJasperHelper.generateJasperPrint(dr,new
        // ClassicLayoutManager(),ds);
        JasperPrint jp =
            DynamicJasperHelper.generateJasperPrint(dr, new ClassicLayoutManager(), conexion, null);

        JasperViewer.viewReport(jp, false); // finally display the report report
        System.out.println(sql);
      } else {
        AlertBox.display("Error", "Rango de fechas no valido");
      }
    } else {
      AlertBox.display("Error", "Debe seleccionar minimo 1 campo");
    }
  }