jasperRunner.groovy

+ jdbcJasperRunner.PHP

<?php
  if (isset($_REQUEST['__jrxml'])){
    $unit= $_REQUEST['__jrxml']; unset($_REQUEST["__jrxml"]);
  } else $unit= "JDBCinvalid";
  if (isset($_REQUEST['__output'])){
    $output= $_REQUEST['__output']; unset($_REQUEST["__output"]);
  } else $output= "html";
 
  $jrxml= file_get_contents("/var/www/jrxml/$unit.jrxml");
 
  require_once("http://207.150.180.95:80/JavaBridge/java/Java.inc");
  //require_once("http://formula.sytes.net:8080/JavaBridge/java/Java.inc");
  $compileManager= new Java("net.sf.jasperreports.engine.JasperCompileManager");
  $fillManager = new Java("net.sf.jasperreports.engine.JasperFillManager");
 
  $report= $compileManager->compileReport(new Java("java.io.ByteArrayInputStream", $jrxml));
 
  $class = new Java("java.lang.Class");
  $class->forName("com.mysql.jdbc.Driver");
  $driverManager = new JavaClass("java.sql.DriverManager");
  $conn = $driverManager->getConnection("jdbc:mysql://172.16.36.1/airs", "userairs", "userairs");
  //$conn = $driverManager->getConnection("jdbc:mysql://advanta.sytes.net/airs", "userairs", "userairs");
 
  $params = new Java("java.util.HashMap");
  foreach (array_keys($_REQUEST) as $RQ)
    $params->put($RQ,$_REQUEST[$RQ]);
  $print = $fillManager->fillReport($report, $params, $conn);
 
  switch ($output) {
  case "html":
    header("Content-type: text/html");
    $exporter = new Java("net.sf.jasperreports.engine.export.JRHtmlExporter");
    $ExporterParameter = new Java("net.sf.jasperreports.engine.export.JRHtmlExporterParameter");
    $exporter->setParameter($ExporterParameter->IS_USING_IMAGES_TO_ALIGN, false);
    break;
  case "xls":
    header("Content-type: application/vnd.ms-excel");
    $exporter = new Java("net.sf.jasperreports.engine.export.JExcelApiExporter");
    $ExporterParameter = new Java("net.sf.jasperreports.engine.export.JRXlsExporterParameter");
    $exporter->setParameter($ExporterParameter->IS_DETECT_CELL_TYPE, true);
    $exporter->setParameter($ExporterParameter->IS_WHITE_PAGE_BACKGROUND, false);
    $exporter->setParameter($ExporterParameter->IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, true);
    break;
  case "rtf":
    header("Content-type: application/msword");
    $exporter=  new Java("net.sf.jasperreports.engine.export.JRRtfExporter");
    $ExporterParameter = new Java("net.sf.jasperreports.engine.JRExporterParameter");
    break;
  default:
    $output= "pdf";
    header("Content-type: application/pdf");
    $exporter = new Java("net.sf.jasperreports.engine.export.JRPdfExporter");
    $ExporterParameter= new Java("net.sf.jasperreports.engine.export.JRPdfExporterParameter");
    break;
  }
 
  header("Content-Disposition:inline; filename=$unit.$output");
 
  $exporter->setParameter($ExporterParameter->JASPER_PRINT,$print);
  $out = new Java("java.io.ByteArrayOutputStream");
  $exporter->setParameter($ExporterParameter->OUTPUT_STREAM, $out);
  $exporter->exportReport();
 
  echo java_values($out->toByteArray());
 
?>

Студия Дениса Волкова: UploadServer

---

Действующие образцы:

+ http-запросы к минисерверу

http-запросы к минисерверу на хосте amazon:

Запрос журнала недостоверных значений(sql: JDBC)
Запрос журнала недостоверных значений(xpath2: remote XML)

Запрос регламентной сводки(xpath2: remote XML)
Запрос регламентной сводки(xPath: groovy script XML)

Запрос журнала дискретных значений(sql: JDBC)

+ Исходный код минисервера (эскиз)

+ crontab -e

[root@ve120 ~]# export EDITOR=mcedit
[root@ve120 ~]# crontab  -e

PATH=/sbin:/bin:/usr/bin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/root/bin:/root/.gvm/groovy/current/bin
LANG=ru_RU.UTF-8

0 */10 * * * /root/src/logcleaner >/dev/null 2>&1
#0 */1 * * * groovy -cp /root/src/mysql-connector-java-5.1.6-bin.jar /root/src/httpServer.groovy >>/root/1.log 2>>/root/2.log &
0 */1 * * * java -cp /root/grovy-all.jar /root/src/xmlServer/xmlServer.jar xmlServer >>/root/1.log 2>>/root/2.log &
0 */1 * * * groovy -cp /root/src/jasperlib.jar  /root/src/jsperRunner.groovy >>/root/21.log 2>>/root/22.log &
0 */1 * * * java -cp /root/src/. UploaderServer 8880 >>/root/31.log 2>>/root/32.log &

/root/src/logcleaner

#!/bin/bash
echo>/root/1.log
echo>/root/2.log
echo>/root/21.log
echo>/root/22.log
echo>/root/31.log
echo>/root/32.log

---

Groovy Script as a Datasource for JasperReports