define('JAVA_INC_URL', 'http://localhost:85/JavaBridge/java/Java.inc');
require_once JAVA_INC_URL;
//require_once("http://127.0.0.1:85/JavaBridge/java/Java.inc");
$system = new Java('java.lang.System');
$class = new JavaClass("java.lang.Class");
$class->forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//$class->forName("com.mysql.jdbc.Driver");
$driverManager = new JavaClass("java.sql.DriverManager");
//$conn = $driverManager->getConnection("jdbc:mysql://localhost/stdb?user=sa&password=Tamakogi2012");
$conn = $driverManager->getConnection("jdbc:sqlserver://127.0.0.1;databaseName=st;user=sa;password=Tamakogi2012");
//compliler
$compileManager = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$viewer = new JavaClass("net.sf.jasperreports.view.JasperViewer");
$report = $compileManager->compileReport("C:/inetpub/wwwroot/inv_01.jrxml");
//fill
$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$params = new Java("java.util.HashMap");
//$params->put("text", "Text");
$params->put("ofYear", 2015.0);
//$params->put("date", convertValue("2007-12-31 0:0:0", "java.sql.Timestamp"));
$emptyDatasource = new JavaClass("net.sf.jasperreports.engine.JREmptyDataSource");
$jasperPrint = $fillManager->fillReport($report, $params, $conn);
$exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$outputPath = realpath(".") . "/" . "output.pdf";
//$exportManager->exportReportToHtml($jasperPrint,$outputPath);
//header("Content-type: application/html");
$exportManager->exportReportToPdfFile($jasperPrint, $outputPath);
header("Content-type: application/pdf");
readfile($outputPath);
unlink($outputPath);
function callReport($nomReport, $arrParam)
{
global $SYS;
require_once "Java.inc";
//java_require(dirname(__FILE__)."/jfreechart-1.0.1.jar");
java_require(dirname(__FILE__) . "/drivers.jar");
//java_require("/usr/share/java/postgresql-jdbc3.jar");
try {
copy("{$SYS["ROOT"]}/JasperReports/phpjasper/Pool/{$nomReport}.jrxml", "/tmp/{$nomReport}.jrxml");
$jcm = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$report = $jcm->compileReport("/tmp/{$nomReport}.jrxml");
$jfm = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$Conn = new Java("org.altic.jasperReports.JdbcConnection");
$Conn->setDriver("org.postgresql.Driver");
$Conn->setConnectString("jdbc:mysql://{$_SERVER["SERVER_NAME"]}:3306/{$SYS["mysql"]["DBNAME"]}");
// Parche tonto
// $Conn->setConnectString("jdbc:postgresql://localhost:5432/{$_SESSION['dbname']}"); //
$Conn->setUser("ascore");
$Conn->setPassword("ascore");
if ($Conn->getConnection()) {
$parameters = new Java("java.util.HashMap");
/* PARAMETROS */
foreach ($arrParam as $n => $v) {
// Tendré que comprobar el tipo, pasar ad_reference_id por parámetro
if (isset($v['type'])) {
if ($v['type'] == "Date") {
$ts1 = text_to_int($v['value']);
$JAVA_PAR = new Java("java.util.Date", date("Y", $ts1) - 1900, date("m", $ts1) - 1, date("d", $ts1));
$parameters->put($n, $JAVA_PAR);
} else {
if ($v['type'] == "Integer") {
$JAVA_PAR = new Java("java.lang.Integer", $v['value']);
//die( "NOMBRE PARAM: $n ; VALOR: {$v['value']} <br />");
$parameters->put($n, $JAVA_PAR);
} else {
if ($v['type'] == "Boolean") {
$JAVA_PAR = new Java("java.lang.Boolean", $v['value']);
$parameters->put($n, $JAVA_PAR);
} else {
if ($v['type'] == "Double") {
$JAVA_PAR = new Java("java.lang.Double", $v['value']);
$parameters->put($n, $JAVA_PAR);
} else {
$parameters->put($n, $v['value']);
}
}
}
}
} else {
$parameters->put($n, $v['value']);
}
}
$parameters->put("REPORT_DIR", "/tmp/tmp/");
$print = $jfm->fillReport($report, $parameters, $Conn->getConnection());
$listaPag = $print->getPages();
$numPag = $listaPag->size();
if ($numPag == '0') {
// Mostramos mensaje, el documento no contiene páginas (Usar div similar al session caducada)
$_SESSION['msgDocInfo'] = "El documento no tiene páginas.";
} else {
$filem = time();
$finalname = "/tmp/{$filem}.pdf";
$jem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$jem->exportReportToPdfFile($print, $finalname);
while (ob_end_clean()) {
}
if (file_exists($finalname)) {
header('Content-type: application/pdf');
header("Content-Disposition: attachment; filename=\"{$finalname}\"");
readfile($finalname);
}
die;
}
} else {
echo "ERRORS";
}
} catch (JavaException $ex) {
/*$trace = new Java("java.io.ByteArrayOutputStream");
$ex->printStackTrace(new Java("java.io.PrintStream", $trace));
print "java stack trace: $trace\n";*/
ob_end_clean();
echo "<pre>ERROR<br>";
echo "Cause: " . $ex->getCause() . "<br>";
echo "Message: " . $ex->getMessage() . "</pre>";
}
}
/**
* @ignore
*/
protected function crear_pdf()
{
//Uno todos los metareportes para generar un solo archivo
$master_print = $this->unir_metareportes();
////Exportamos el informe y lo guardamos como pdf en el directorio donde están los reportes
$export_manager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$export_manager->exportReportToPdfFile($master_print, $this->temp_salida);
}
function fillDB($db, $fileInput, $fileOutput, $fileType, $parameters, $classPath, $save)
{
$params = $this->prepareParameters($parameters);
$params->put('REPORT_LOCALE', new Java("java.util.Locale", 'pt', 'BR'));
$extension = substr($fileInput, strrpos($fileInput, '.'));
try {
$sJfm = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
if ($extension == ".jrxml") {
$s1 = new JavaClass("net.sf.jasperreports.engine.xml.JRXmlLoader");
$jasperDesign = $s1->load($fileInput);
$sJcm = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$report = $sJcm->compileReport($jasperDesign);
} else {
$report = $fileInput;
}
// Create the JDBC Connection
$conn = new Java("org.altic.jasperReports.JdbcConnection");
// Call the driver to be used
$conn->setDriver(\Manager::getConf("db.{$db}.jdbc.driver"));
// Connection URL
$conn->setConnectString(\Manager::getConf("db.{$db}.jdbc.db"));
// Server Connection Username
$conn->setUser(\Manager::getConf("db.{$db}.user"));
// Server Connection Password
$conn->setPassword(\Manager::getConf("db.{$db}.password"));
$print = $sJfm->fillReport($report, $params, $conn->getConnection());
$sJem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$output = \Manager::getDownloadURL('report', basename($this->fileOutput), true);
$sJem->exportReportToPdfFile($print, $fileOutput);
} catch (Exception $e) {
dump_java_exception($e);
}
return $output;
}
public function report_TRN1I060()
{
$get_data = $this->input->get(NULL, TRUE);
if (empty($get_data) === FALSE) {
$this->checkJavaExtension();
$compileManager = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
// $report = $compileManager->compileReport("C:/DPE/apache-tomcat-6.0.32/reports/TRN1I040_Regis_v2.jrxml");
$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
// Add parameters
// p_termId
// p_historyNoStart
// p_historyNoEnd
$params = new Java("java.util.HashMap");
$str_term_id = (string) $get_data['TERM_GEN'];
$params->put("p_termId", $str_term_id);
if ($get_data['HISTORY_NO'] === '1') {
$str_history_no_start = (string) $get_data['HISTORY_NO_START'];
$params->put("p_historyNoStart", $str_history_no_start);
$str_history_no_end = (string) $get_data['HISTORY_NO_END'];
$params->put("p_historyNoEnd", $str_history_no_end);
}
$class = new JavaClass("java.lang.Class");
$class->forName("oracle.jdbc.driver.OracleDriver");
$driverManager = new JavaClass("java.sql.DriverManager");
$conn = $driverManager->getConnection("jdbc:oracle:thin:@192.168.2.13:1521:OSRDDB2", "train", "train");
// $emptyDataSource = new Java("net.sf.jasperreports.engine.JREmptyDataSource");
// $jasperPrint = $fillManager->fillReport($report, $params, $conn);
$report_name = '';
if ($get_data['REPORT_TYPE'] === 'vertical') {
$report_name = 'TRN1I060_Certifys_Vertical.jasper';
} else {
if ($get_data['REPORT_TYPE'] === 'horizontal') {
$report_name = 'TRN1I060_Certifys.jasper';
}
}
$jasperPrint = $fillManager->fillReport("C:/DPE/apache-tomcat-6.0.32/reports/" . $report_name, $params, $conn);
$filename = uniqid('Report_');
$outputPath = "E:/dd/" . "{$filename}.pdf";
$exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$exportManager->exportReportToPdfFile($jasperPrint, $outputPath);
header("Content-type: application/pdf");
readfile($outputPath);
unlink($outputPath);
}
}
//$parameters->put($v["paraname"],$JAVA_PAR);
} else {
if ($v["paratype"] == "Cadena") {
$JAVA_PAR = new Java("java.lang.String", $v["value"]);
$parameters->put($v["paraname"], $JAVA_PAR);
}
}
}
}
$parameters->put("REPORT_DIR", $URLBASE);
$print = $jfm->fillReport($report, $parameters, $Conn->getConnection());
$filem = time();
$rutahastafichero = "/coreg2_cache/{$SYS["ASCACHEDIR"]}/{$filem}.pdf";
$finalname = session_save_path() . $rutahastafichero;
$jem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$jem->exportReportToPdfFile($print, $finalname);
//echo $jem->exportReportToPdf($print);
ob_end_clean();
if (file_exists($finalname)) {
header("Content-Type: application/pdf");
header("Content-Disposition: inline; filename=\"{$informe}.pdf\"");
readfile($finalname);
}
} else {
echo "Errors";
}
} catch (JavaException $ex) {
$trace = new Java("java.io.ByteArrayOutputStream");
$ex->printStackTrace(new Java("java.io.PrintStream", $trace));
debug("java stack trace: {$trace}\n", "red");
ob_end_clean();
public function execute($output, Doctrine_Connection $con = null)
{
require_once sfConfig::get('psdf_report_java_inc');
//Declare the paths where the JRXML Reports are stored)
$reportFileName = sfConfig::get('psdf_report_dir') . DIRECTORY_SEPARATOR . $this->getFileName();
$salidaFileName = tempnam(sys_get_temp_dir(), 'jr') . '.' . $output;
if (!file_exists($reportFileName)) {
throw new sfException(sprintf('Verificar el archivo <strong>%s</strong> del reporte <strong>%s</strong> no existe en <strong>%s</strong>', $this->getFileName(), $this->getName(), sfConfig::get('psdf_reports_dir')));
}
// Corrigo posibles rutas incorrectas en imagenes
$jrxml = new psdfJrXml($reportFileName);
$jrxml->fixPathImages(sfConfig::get('psdf_report_resource_dir'));
$jrxml->file_save();
// Parametros (a que sea dinamico)
/* $params['fecha_desde'] = $this->getRequestParameter('fechadesde');
$params['fecha_hasta'] = $this->getRequestParameter('fechahasta');
$params['unidadorg_origen'] = $this->getRequestParameter('unidadorg');
$params['nombre_unidadorg'] = $this->getRequestParameter('rel_busca_unidad'); */
//Begin the Procedure for the Report
try {
// recupera los datos de conexion a la base de datos
$datos = psdfReportPluginUtil::dataConnection($this->getConnection());
// Create the JDBC Connection
$Conn = new Java("org.altic.jasperReports.JdbcConnection");
// Call the driver to be used
$Conn->setDriver("org.postgresql.Driver");
// Connection URL (since it is in the server, it can be defined as localhost)
$Conn->setConnectString(sprintf("jdbc:postgresql://%s/%s", $datos['host'], $datos['dbname']));
$Conn->setUser($datos['username']);
$Conn->setPassword($datos['password']);
// Compile the JRXML in Jasper
$sJcm = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$report = $sJcm->compileReport($reportFileName);
//Mapping fields (please refer to the note on top)
$map = new Java("java.util.HashMap");
// Parametros
/*foreach ($this->getParametroConsultas() as $param) {
$value = $this->getParam($param->getNombre());
if ($param->getTipo() == 'A') {
$map->put($param->getNombre(), $value);
} else if ($param->getTipo() == 'N') {
$map->put($param->getNombre(), new Java('java.lang.Integer', $value));
} else {// si no es ni A y N es D
// Convierto la fecha a dd/MM/yyyy
//$fecha = substr($value,0,2).'/'.substr($value,3,2).'/'.substr($value,6,4);
$temp = new Java('java.text.SimpleDateFormat', "dd/MM/yyyy");
$date = $temp->parse($value);
//die('fecha '.$date);
$map->put($param->getNombre(), $date);
}
}*/
// What we are using to fill the model
$sJfm = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$print = $sJfm->fillReport($report, $map, $Conn->getConnection());
// Export the final report format to pdf u other
$sJem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
// a pdf
if ($output == PluginPsdfReportTable::TO_PDF) {
$sJem->exportReportToPdfFile($print, $salidaFileName);
psdfReportPluginUtil::download($salidaFileName, $this->getName() . '.' . $output);
}
} catch (JavaException $ex) {
$trace = new Java("java.io.ByteArrayOutputStream");
$ex->printStackTrace(new Java("java.io.PrintStream", $trace));
throw new sfException('java stack trace: ' . $trace);
}
}
function cetak($rpt, $param_data = array(), $type = "pdf", $ignore_html_pg = TRUE)
{
error_reporting(E_ALL);
ini_set('display_errors', 'On');
$checkJavaExt = $this->checkJavaExtension();
if (!$checkJavaExt) {
return $checkJavaExt;
}
// $rpt = 'simple';
// $report = dirname(__FILE__)."//..//modules//".active_module()."//reports//{$rpt}.jasper";
// $reportx = dirname(__FILE__)."//..//modules//".active_module()."//reports//{$rpt}.jrxml";
$outputPath = dirname(__FILE__) . "//..//modules//" . active_module() . "//reports//{$rpt}";
$reportx = dirname(__FILE__) . "//..//modules//" . active_module() . "//reports//{$rpt}.jrxml";
// $outputPath = sys_get_temp_dir()."//{$rpt}"; //buang ke tmp ajah
// die ($reportx);
$compileManager = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$report = $compileManager->compileReport($reportx);
$params = new Java("java.util.HashMap");
foreach ($param_data as $prm => $val) {
$params->put($prm, $val);
}
// if ($type=="html") {
if ($ignore_html_pg == TRUE) {
$params->put("IS_IGNORE_PAGINATION", true);
}
java('java.lang.Class')->forName('org.postgresql.Driver');
$conn = java('java.sql.DriverManager')->getConnection("jdbc:postgresql://localhost:{$this->port}/{$this->db}?user={$this->usr}&password={$this->pwd}");
$emptyDataSource = new Java("net.sf.jasperreports.engine.JREmptyDataSource");
$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$jasperPrint = $fillManager->fillReport($report, $params, $conn);
/* */
// bagus niy cm kayanya bakal tampil diserver.. hmmm nanti dah
// $viewer = new JavaClass("net.sf.jasperreports.view.JasperViewer");
// $viewer->viewReport($jasperPrint, false);
// $conn->close();
// die();
/* */
$exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
if ($type == "html") {
$exportManager->exportReportToHtmlFile($jasperPrint, $outputPath);
header("Content-type: text/html");
} else {
$exportManager->exportReportToPdfFile($jasperPrint, $outputPath);
header("Content-type: application/pdf");
// paksa donlot ?
// header('Content-Disposition: attachment;filename="' . $rpt . '.pdf"');
}
/* */
// oh buat ngeprint...
// $printManager = new JavaClass("net.sf.jasperreports.engine.JasperPrintManager");
// $printManager->printPages($jasperPrint, 0,0, true);
/* */
readfile($outputPath);
@unlink($outputPath);
$conn->close();
}
try {
java_require($java_library_path);
$Conn = new Java("org.altic.jasperReports.JdbcConnection");
// driver
$Conn->setDriver("com.mysql.jdbc.Driver");
// url de connexion
$Conn->setConnectString("jdbc:mysql://localhost/erpmart");
$Conn->setUser("root");
// mot de passe
$Conn->setPassword(null);
$sJcm = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$report = $sJcm->compileReport($reportsPath . $reportFileName . ".jrxml");
$sJfm = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$print = $sJfm->fillReport($report, new Java("java.util.HashMap"), $Conn->getConnection());
$sJem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$sJem->exportReportToPdfFile($print, $reportsPath . $reportFileName . ".pdf");
if (file_exists($reportsPath . $reportFileName . ".pdf")) {
header('Content-disposition: attachment; filename="' . $reportFileName . '.pdf"');
header('Content-Type: application/pdf');
header('Content-Transfer-Encoding: binary');
header('Content-Length: ' . @filesize($reportsPath . $reportFileName . ".pdf"));
header('Pragma: no-cache');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Expires: 0');
set_time_limit(0);
@readfile($reportsPath . $reportFileName . ".pdf") or die("problem occurs.");
}
} catch (JavaException $ex) {
$trace = new Java("java.io.ByteArrayOutputStream");
$ex->printStackTrace(new Java("java.io.PrintStream", $trace));
print "java stack trace: {$trace}\n";
