Welcome Guest, Not a member yet? Register   Sign In
Show jasperreport using Codeigniter
#1

Hi there Im newbie in codeigniter and I start with codeigniter 3.
I'm having trouble with a JASPER report to create one
I'm using this library https://github.com/SIMITGROUP/phpjasperxml
And a follow this tutorial how to include the library https://forum.codeigniter.com/thread-271...#pid170641
here my javascript file


Code:
  $.ajax({
            data: {
                'c_order_id': 101010,
            },
            url: "<?php echo base_url() ?>adempiere/c_order_report",
            type: 'POST',
            dataType: 'json',
            cache: false,
            success: function(response) {
                  window.open('<?php echo base_url() ?>adempiere/c_order_report', '_blank');
            },
          
here my controller function
Code:
public function c_order_report()
{
    $c_order_id = trim($this->input->post('c_order_id', true));
    $this->load->library('PHPJasperXML');
    $ruta = __DIR__ . '/example.jrxml';
    // echo $ruta;
    // $xml =simplexml_load_file($ruta);
    $PHPJasperXML = new PHPJasperXML("en","TCPDF");
    $PHPJasperXML->debugsql=true;
    $PHPJasperXML->arrayParameter = array('para1'=>'1','para2'=>'2');
    $PHPJasperXML->load_xml_file($ruta);
    $dbdriver="psql";

    $PHPJasperXML->transferDBtoArray('localhost','adempiere','adempiere','adempiere',$dbdriver);
    $PHPJasperXML->outpage('I'); 
in the developer option of the browser I get this. https://ibb.co/RhG0mmy

Attached Files Thumbnail(s)
   
Reply




Theme © iAndrew 2016 - Forum software by © MyBB