Hi,

When I am trying to export excel of a table that is generated based on the year selected, I don't see any values in the excel sheet.

When i manually enter the year and generate the datastore, I am able to see the values in the exported excel.

Am I missing something? Please help.

Hi, The query returns data. I can confirm this because I am using the same datastore in both view and excel.view, the data is displayed in view. Anyway the number of rows is around 12.

in main reportfile

 use \koolreport\export\Exportable;
    use \koolreport\excel\ExcelExportable;
    use \koolreport\inputs\Bindable;
    use \koolreport\inputs\POSTBinding;  

protected function defaultParamValues()
    {
        return array(
            "years"=> date("Y",strtotime("-1 year"))
        );
    }
    protected function bindParamsToInputs()
    {
        return array(
            "years",
        );
    }

protected function setup(){
$this->src('quickbrand')
        ->query("
        SELECT monthname(OrderTS)  as month,count(Order) as 'order'   
        from orders					  
        where YEAR(OrderTS) = :years and website=:siteid
        group by MONTH(OrderTS)
        ")
        ->params(array(
            ":years"=>$this->params["years"],
            ":siteid"=>$this->params["siteId"]
        ))
        ->pipe($this->dataStore("orderspermonth"));

$this->src('quickbrand')
        ->query("
        SELECT year(OrderTS) as years  
        from orders					  
        where  website=:siteid 
        group by year(OrderTS)
        ")
        ->params(array(
            ":siteid"=>$this->params["siteId"]
        ))
        ->pipe($this->dataStore("years"));

in excel.view

<div sheet-name="Order Report">
    <div>
        <?php 
        \koolreport\excel\Table::create(array(
            "dataSource"=>$this->dataStore("orderspermonth"),            
        ))
        ?>
        </div>
</div>

in view

<form class="d-print-none">
        <button type="submit" class="btn btn-primary" formaction="/export.php">Download Excel</button>
    </form>

<form method="post"> 
<?php Select::create(array(
            "name"=>"years",
            "dataStore"=>$this->dataStore("years"),    
            "dataBind"=>"years",
            "attributes"=>array(
                "class"=>"form-control",
                )
            ));
        ?>

  <div class="form-group text-center m-2">
            <button class="btn btn-success"><i class="glyphicon glyphicon-refresh"></i> Load </button>
        </div>
 </form>

    <?php 
        Table::create(array(
            "dataSource"=>$this->dataStore("orderspermonth"),            
            "cssClass"=>array(
                "table"=>"table-bordered table-striped table-hover"
            ),
            "columns"=>array(
                "month"=>array(
                    "label"=>"Month"
                ),
                "order"=>array(
                    "label"=>"Order",
                    "type"=>"number",                
                )
            )
        ))
    ?>

I hope this makes sense, please let me know if you need more info. Thanks

export.php

<?php

include "OrderPerMonth.php";
$report = new OrderPerMonth;

// //excel generator
$report->run();
$report->exportToExcel('OrderPerMonthExcel')->toBrowser("MyOrdersReport.xlsx");

Thanks for looking into it.

Hi David, Thanks for the advise. Duly noted and made changes.

Do you guys ever run into an issue like this where using params while generating excel report shows no data? I haven't found any of your examples generating excel output with params, so i am actually curious to know how to make it work.

Hi Guys,

Any update?

Thanks.

I did that.

That doesn't solve the issue. The excel generated still has no data inside it.

Hi Team,

Any solution for this? It would be greatly appreciated.

Hi Guys,

Just checking in to know if you guys had any update on this issue.

Thanks.

The export.php is in the same folder as index.php. The other thing I noticed was when I removed the params and placed direct values and then generated the excel sheet, the values are generated in the excel sheet but once I go back to the params, the values are not generated in excel(they show up in the view though). I had placed the download excel inside the same <form> tag as suggested earlier, Apart from that my code has not changed.

Hi,

Thanks for pointing out that values were not being posted to export.php

here is the index.php

<?php

require_once "OrderPerMonth.php";

$report= new OrderPerMonth(array(
    "siteId"=>$_SESSION["QB_SITEID"]
));

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

here is the export.php

<?php
include "OrderPerMonth.php";
$report = new OrderPerMonth;

// //excel generator
$report->run();
$report->exportToExcel('OrderPerMonthExcel')->toBrowser("MyOrdersReport.xlsx");

here is the OrderPerMonthExcel.view.php

<div sheet-name="Order Report">
    <div>
        <?php 
        \koolreport\excel\Table::create(array(
            "dataSource"=>$this->dataStore("orderspermonth"),            
        ))
        ?>
        </div>
</div>

view.php

<form method="post"> 
    
        <?php Select::create(array(           
            "name"=>"years",
            "dataStore"=>$this->dataStore("years"),    
            "dataBind"=>"years",            
            "attributes"=>array(
                "class"=>"form-control",
                )
            ));
        ?>
        <div class="form-group text-center m-2">
            <button class="btn btn-success"><i class="glyphicon glyphicon-refresh"></i> Load </button>
            <button type="submit" class="btn btn-primary" formaction="/export.php">Download Excel</button>
        </div>
</form>
    <?php 
        Table::create(array(
            "dataSource"=>$this->dataStore("orderspermonth"),            
            "cssClass"=>array(
                "table"=>"table-bordered table-striped table-hover"
            ),
            "columns"=>array(
                "month"=>array(
                    "label"=>"Month"
                ),
                "order"=>array(
                    "label"=>"Order",
                    "type"=>"number",                
                )
            )
        ))
    ?>

main.php

use \koolreport\export\Exportable;
    use \koolreport\excel\ExcelExportable;
    use \koolreport\inputs\Bindable;
    use \koolreport\inputs\POSTBinding;  
protected function defaultParamValues()
    {
        return array(
            "years"=> date("Y",strtotime("-1 year"))
        );
    }
    protected function bindParamsToInputs()
    {
        return array(
            "years",
        );
    }

protected function setup(){
$this->src('quickbrand')
        ->query("
        SELECT monthname(OrderTS)  as month,count(Order) as 'order'   
        from orders					  
        where YEAR(OrderTS) = :years and website=:siteid
        group by MONTH(OrderTS)
        ")
        ->params(array(
            ":years"=>$this->params["years"],
            ":siteid"=>$this->params["siteId"]
        ))
        ->pipe($this->dataStore("orderspermonth"));

$this->src('quickbrand')
        ->query("
        SELECT year(OrderTS) as years  
        from orders					  
        where  website=:siteid 
        group by year(OrderTS)
        ")
        ->params(array(
            ":siteid"=>$this->params["siteId"]
        ))
        ->pipe($this->dataStore("years"));

I checked the headers that was being sent to export.php and realized that siteid parameter is not being sent. How can that be done?

Does it works when you use the Load button to post back form to index.php? Yes.

Hi,

I can confirm this is the issue because when I manually enter siteid, it generates values in the excel sheet.

Any idea as to how we can solve this?

Thanks.

Hi,

Thanks for helping me out. I realized adding this to export.php fixed the issue for me.

$report= new OrderPerMonth(array(
    "siteId"=>$_SESSION["QB_SITEID"]
));

Thanks for all the help again. Cheers.