Hi,

I'm trying to export in PDF a table with Bootstrap css format. But it does work. I've check everything concerning this problem : phantomjs, etc... When i check the tmp generate with pdf ( rename in html ) , the koolreport.js is not found because for localtion the localhost is missing in the url. I already add : "serverLocalAddress" => "localhost", But does wrok at all. Can i have some help for this issue ? Regards.

Hi,

Already tested, but not worked.

Regards

Hi,

In the browser network tools i have this error : Uncaught ReferenceError: KoolReport is not defined

Regards

Hi, Yes, it is precisely on the Browser that I have this error ( after rename the tmp file ). Here is the script part:

<script type='text/javascript' src='/myapp/dev/koolreport/core/src/clients/core/KoolReport.js'></script><script type='text/javascript'>KoolReport.load.resources({"js":["\/myapp\/dev\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/myapp\/dev\/koolreport\/bootstrap4\/assets\/core\/js\/bootstrap.bundle.min.js"]],"css":["\/myapp\/dev\/koolreport\/bootstrap4\/assets\/core\/css\/bootstrap.min.css"]});</script>

Regards

Hi, Any news about this issue ?

Best regards

Hi, I do not use framework. This src is relative path for script , so must work as well as for all. I already try with the tmp file to replace with the full url , but same problem !

Hi again. I tested again the tmp file and updated all path with the full url ( host .... + path ) and it works. So now , how can i do to generate my pdf and set correct path ? But i do not understand why the views works well ?

Hi, There is something i do not understand ! the pdf is generated in a tmp folder ( as tmp file ). So all path are bad because tmp folder is a child folder. So all path must be like this ../ + PATH What do you think about ?

In all my development with KoolReport, access to resources is with relative paths. How do I specify an absolute URL?

Has anyone successfully exported a PDF with Bootstrap and Koolreport? I've been trying to solve this problem for 3 weeks!

// 1st Courbe_Prev15j.php

<?php

require_once "CourbePrev15j.php";


$CourbePrev15j = new CourbePrev15j(array(
    "data"=>$data_source,));

$CourbePrev15j->run()->render();



?> 

// 2nd CourbePrev15j.php

<?php

require_once "koolreport/core/autoload.php";
use \koolreport\KoolReport;
use \koolreport\processes\Group;
use \koolreport\processes\Sort;
use \koolreport\processes\Limit;

class CourbePrev15j extends KoolReport
{
	 use \koolreport\export\Exportable;
	 use \koolreport\bootstrap4\Theme;
	 
    public function settings()
    {
    	  
        return array(
            "dataSources"=>array(
                "mydata"=>array(
                    "class"=>'\koolreport\datasources\ArrayDataSource',
                    "data"=>$this->params["data"],
                    "dataFormat"=>"associate",
                )
            )
        );
    }

    public function setup()
    {
        $this->src('mydata')
        ->pipe(new Sort(array("date"=>"asc",))) 
        ->pipe($this->dataStore('courbe_prev15j'));

    }
    
    
}



?> 

// 3rd CourbePrev15j.view.php

<?php 
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\widgets\google\LineChart;
?>

<?php

 
    LineChart::create(array(
    "title"=>"",
    "dataSource"=>$this->dataStore('courbe_prev15j'),
    "options"=>array(
        "curveType"=>"function"
    ),
        "columns"=>array(
            "date"=>array(
            "type"=>"date",
            "xFormat"=>"%Y%m%d",
            "xDisplayFormat"=>"%B %d, %Y"),
            "predic"=>array(
                "label"=>"Prevision",
                "type"=>"number",
                "prefix"=>"W"
            ),
        )
));    
    
   

?>

// 4th export_prev15j.php

<?php

require_once "report/CourbePrev15j.php";
$report = new CourbePrev15j(array(
    "data"=>$data_source,));

    
$report->run()
->export('CourbePrev15jPdf')
->settings([
    "useLocalTempFolder" => true,
    "serverLocalAddress" => "127.0.0.1",
])
->pdf(array(
    "format"=>"A4",
    "orientation"=>"portrait",
    //"zoom"=>2
))
//->toBrowser("courbe_predic.pdf",true);
->saveAs("tmp/courbe_predic.pdf");


?>


// 5th CourbePrev15jPdf.view.php


<?php 
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\widgets\google\LineChart;
    use \koolreport\bootstrap4\Theme;
?>
<html>

<head>

<style>
* {
    -webkit-print-color-adjust: exact !important;
}

@media print {
    * {
        -webkit-print-color-adjust: exact !important;
    }    
}
</style>

</head>
    
    <body style="margin:1in"> 


        <?php
        
        
    LineChart::create(array(
    "title"=>"",
    "dataSource"=>$this->dataStore('courbe_prev15j'),
    "options"=>array(
        "curveType"=>"function"
    ),
        "columns"=>array(
            "date" =>array(
            "type"=>"date",
            "xFormat"=>"%Y%m%d",
            "xDisplayFormat"=>"%B %d, %Y"),
            "predic"=>array(
                "label"=>"Prevision",
                "type"=>"number",
                "prefix"=>"W"
            ),
        )
)); 

        ?>
        
        <hr/>
            <?php
    
    
    Table::create(array(
    "dataStore"=>$this->dataStore("courbe_prev15j"),
    "columns"=>array(
            "date"=>array(
                "label"=>"Date"
            ),
            "predic"=>array(
                "label"=>"Prévision"
            )
        ),
    "cssClass"=>array(
            "table"=>"table",
            "thead"=>"thead-dark"
        )    
    ));
    
    ?>
    
    
    </body>
</html>

Hi, I added this morning a card with bootsrap class, and it's work for the card ! Here :

    Card::create(array(
        "value"=>$this->dataStore("courbe_prev15j")->slice(4,1)->only("predic"),
        "format"=>array(
            "value"=>array(
                "prefix"=>"Wh"
            )
        ),
        "title"=>"Prevision",
        "cssClass"=>array(
            "card"=>"bg-primary",
            "title"=>"text-white",
            "value"=>"text-white"
        )
    ));

So i think tere is something wrong with Table objet ?

Hi, If i copy the tmp in my Report folder ( where the view is ) and rename it in html , it works ( in the browser ) for cards & table. So what's the problem ? And what i need to do ? Regards.

Hi,

Your example work, but it is a simple table, without any color etc.... What i think it is not a good idea to use bootstrap with export package, because grid, colors not work well. I only succed a great table , or layout wtih css embedded in the page. I test now other chart with export package : Google work well , but ApexCharts do not ! I'm a little disappointed. Regards