<?php

/*
  This file is free software: you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation, either version 3 of the License, or
  (at your option) any later version.

  This file is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with This file.  If not, see <http://www.gnu.org/licenses/>.

  tsuyu

 */

require_once("http://127.0.0.1:9000/JavaBridge/java/Java.inc");

$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$params = new Java("java.util.HashMap");
$params->put("title", "Customer");

$class = new JavaClass("java.lang.Class");
$class->forName("org.postgresql.Driver");
$driverManager = new JavaClass("java.sql.DriverManager");

//db username and password
$conn = $driverManager->getConnection("jdbc:postgresql://192.168.11.80:5432/bhumie", "bhumie", "bhumie");
$jasperPrint = $fillManager->fillReport(realpath(".") . "\\" . "report2.jasper", $params, $conn);

$exporter = new java("net.sf.jasperreports.engine.JRExporter");


$outputPath = realpath(".") . "\\" . "output.txt";

try {
    $exporter = new java("net.sf.jasperreports.engine.export.JRTextExporter");
    $exporter->setParameter(java("net.sf.jasperreports.engine.export.JRTextExporterParameter")->PAGE_WIDTH, 120);
    $exporter->setParameter(java("net.sf.jasperreports.engine.export.JRTextExporterParameter")->PAGE_HEIGHT, 60);
    $exporter->setParameter(java("net.sf.jasperreports.engine.JRExporterParameter")->JASPER_PRINT, $jasperPrint);
    $exporter->setParameter(java("net.sf.jasperreports.engine.JRExporterParameter")->OUTPUT_FILE_NAME, $outputPath);
} catch (JavaException $ex) {
    echo $ex;
}

header("Content-type: text/plain");

$exporter->exportReport();
        
readfile($outputPath);
unlink($outputPath);
?>