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; }