jasperphp Code
Brought to you by:
rctnet
File | Date | Author | Commit |
---|---|---|---|
app.jrxml | 2019-01-22 |
![]() |
[44c9c9] resolve conflicts |
config | 2016-09-28 |
![]() |
[8bb3d3] Inclusão do restante das bibliotecas |
samples | 2019-01-22 |
![]() |
[44c9c9] resolve conflicts |
src | 2020-01-15 |
![]() |
[548fe2] Many updates |
.gitignore | 2018-10-11 |
![]() |
[ecdb71] Update .gitignore |
LICENSE | 2018-05-28 |
![]() |
[2c30d6] UPDATE |
README.md | 2020-01-16 |
![]() |
[705134] Update README.md |
TJasper.class.php | 2020-01-15 |
![]() |
[548fe2] Many updates |
autoloader.php | 2018-05-28 |
![]() |
[2c30d6] UPDATE |
composer.json | 2018-10-29 |
![]() |
[5c6d0a] fix license |
docker-compose.yml | 2018-05-28 |
![]() |
[2c30d6] UPDATE |
log.html | 2020-01-08 |
![]() |
[9c8403] fix load jrxml file |
Project to generate reports created with the JasperSoft Studio application
Pure PHP library, without a java server or Jasper Server
Consider donating funds to support us
See more blog, forum and coming soon report template store in https://jasperphp.com
TAG/component | Status | TAG/component | Status |
Basic elements | |||
Text Field | OK | Static Text | OK |
Image | OK | Break | OK |
Rectangle | OK | Line | OK |
SubReport* | OK | Barcode | OK |
Composite elements | |||
Page Number | OK | Total Pages | OK |
Current Date | OK | Page X of Y | OK |
Bands | |||
Title | OK | Page Header | OK |
Group | OK | Detail | OK |
Column Header | OK | Column Footer | OK |
Page Footer | OK | Sumary | OK |
Background | OK |
<lu>
</lu>
<?php
use JasperPHP\Report;
use JasperPHP\Report2XLS;
use JasperPHP\ado\TTransaction;
use JasperPHP\ado\TLoggerHTML;
//use PHPexcel as PHPexcel;
/**
* classe TJasper
*
* @author Rogerio Muniz de Castro <rogerio@quilhasoft.net>
* @version 2015.03.11
* @access restrict
*
* 2015.03.11 -- create
**/
class TJasper
{
private $report;
private $type;
/**
* method __construct()
*
* @param $jrxml = a source xmlr filename
* @param $param = a array whith params
*/
public function __construct($jrxml,array $param)
{
$xmlFile= $jrxml;
$this->type = (array_key_exists('type',$param))?$param['type']:'pdf';
error_reporting(0);
switch ($this->type)
{
case 'pdf':
$this->report =new JasperPHP\Report($xmlFile,$param);
JasperPHP\Pdf::prepare($this->report);
break;
case 'xls':
JasperPHP\Excel::prepare();
$this->report =new JasperPHP\Report2XLS($xmlFile,$param);
break;
}
}
/**
* method outpage()
*
* @param $type = a type of output. ALERT: xls is experimental
*/
public function outpage($type='pdf'){
$this->report->generate();
$this->report->out();
switch ($this->type)
{
case 'pdf':
$pdf = JasperPHP\Pdf::get();
$pdf->Output('Relatorio.pdf',"I");
break;
case 'xls':
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="01simple.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header ('Pragma: public'); // HTTP/1.0
$objWriter = PHPExcel_IOFactory::createWriter($this->report->wb, 'Excel5');
$objWriter->save('php://output');
break;
}
}
/**
* method setVariable()
* insert variable into report after output
*
* @param $name = name of variable
* @param $value = value of variable
*/
public function setVariable($name,$value){
$this->report->arrayVariable[$name]['initialValue'] = $value ;
}
}
require('autoloader.php') ;
require('../../tecnickcom/tcpdf/tcpdf.php'); // point to tcpdf class previosly instaled ,
// on composer instalation is not necessaty
TTransaction::open('dev');
$jasper = new TJasper('template.jrxml',$_GET);
$jasper->outpage();
?>
Define database conections params into file config\dev.ini
View file src\ado\TConection.php to define database type
Sample URL:
http://localhost/vendor/quilhasoft/JasperPHP/TJasper.class.php?param1=foo¶m2=bar
URL params passed into URL are the params defined into xmlr file.
Add "quilhasoft/jasperphp":"dev-master" into your composer config file and update/install