Hi,

Is it possible to echo a value from dataSource() in a panel and what class should we extends to achieve this?

Thank you,

We want to display dynamic values on a dashboard which include time format values such as hh:mm:ss. It can also be outside of a panel.

Thank you, is it possible to add a filter in there?

class DateRange extends DateRangePicker
{
    protected function actionChange($request,$response)
    {
        $this->sibling("MyText")->update();
    }
}

// MyText.php
class MyText extends \koolreport\dashboard\widgets\Text
{
    protected function onInit()
    {
        //Get value from the date range picker
        $range = $this->sibling("DateRange")->value();


        $dataStore = AutoMaker::table("select something")->whereBetween("date",$range)->run(); //Run query to get data
        //Now you get a datastore, you can get value from it something like this:
        $value = $dataStore->get(0,"columnName"); //get columnName at first row
        $this->text($value);
    }
}

When the report first render with the default value (defaultValue($this::last30days())) the value is populated in MyText. However when filtering using the DateRangePicker getting below error:

Message: Call to a member function update() on null
Line: 19
File: C:\...\Filters\DateRange.php
 Collapse
#0: C:\...\vendor\koolreport\dashboard\TAction.php Line 35 : actionChange([{},{}])

(path hidden)

Hi! I don't want to hijack this thread, but I'm looking to do the exact same thing, but i'm not sure how to execute your last comment on adding the MyText to the dashboard. Could you please show a complete example? Here's my code. Note that i'm using RAW SQL.

Here's my code :

SalesBoard.php

<?php

use \koolreport\dashboard\Dashboard;
use \koolreport\dashboard\containers\Row;
use \koolreport\dashboard\containers\Panel;
use \koolreport\dashboard\widgets\Text;
use \koolreport\dashboard\containers\Html;

class SalesBoard extends Dashboard
{SalesBoard
    protected function widgets()
    {
        return [
            Row::create()->sub([
                Row::create(),
                SalesDateRange::create()->width(1/3),
            ]),
           Row::create()->sub([
                Panel::create()->sub([
                    SalesSalesMetric::create(),
                ])->width(1/3),
            ]),
            Row::create()->sub([
                Panel::create()->sub([
                    SalesByDate::create(),
                ])->width(1/1),
            ]),
			Row::create([
                Panel::create()->width(1/1)
					->sub([ Html::h2("Daily Sales Details") ])
					->cssClass("trans-row")
                ]),
            SalesTable::create(),
        ];
    }
}

SalesSalesMetric.php

<?php

use \koolreport\dashboard\metrics\Value;
use \koolreport\dashboard\fields\Date;
use \koolreport\dashboard\fields\Text;
use \koolreport\dashboard\fields\Currency;
use \koolreport\dashboard\containers\Panel;

class SalesSalesMetric extends Text
{

    protected function onRendering()
    {
        //Get value from the date range picker
        $range = $this->sibling("SalesDateRange")->value();


        $dataStore = Incognito::rawSQL("
		select *,
		cartDiscount + cartDiscountTax AS orderDiscount,
		orderTotal - orderTax - orderShipping - orderShippingTax - cartDiscount - cartDiscountTax - refundAmount AS orderNet
        FROM viuInvoicesRefundsByDate
        WHERE transactionDateTimestamp between '" . $range[0] . "' and '" . $range[1] . "'	     
		");
        //Now you get a datastore, you can get value from it something like this:
        $value = $dataStore->get(0,"orderNet"); //get columnName at first row
        $this->text($value);
        return true; //<---This is important to allow the text to be rendered
    }
}

OK i'm getting Message: Call to a member function state() on null Line: 20 File: /*path/reports/koolreport/dashboard/TWidgetState.php

Is it because how i select the value in $value = $dataStore->get(0,"orderNet"); ??

And thanks for the tip i'll start a new topic next time.

Sorry i'm not sure to follow your answer? Do you want me to start another topic now? Why the [...] ? Did I ask something stupid?

Nice thank you ! This solved the problem:

When adding MyText to Dashboard, you do this:

return [
    ...
    MyText::create("MyText")
    ...
];
Let see if it works.