function ValidateDate($id, $event, $myDate)
{
global $xajax;
$objResponse = new xajaxResponse();
if ($this->ifFormat == "%d/%m/%Y") {
if (text_to_int($myDate) == 3600) {
$objResponse->script("alert('Fecha inválida -{$myDate}-')");
$objResponse->assign($id, "value", int_to_text(time()));
} else {
$objResponse->assign($id, "value", int_to_text(text_to_int($myDate)));
}
} else {
if (date_parse_from_format($this->ifFormat, $myDate)) {
$objResponse->assign($id, "value", $myDate);
} else {
$objResponse->script("alert('Fecha inválida -{$myDate}-')");
$objResponse->assign($id, "value", strftime($this->ifFormat, time()));
}
}
return $objResponse;
}
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>";
}
}
