I have a report that has a datetime picker at the top. Here it is :

<form method="post">
    <?php
    DateTimePicker::create(array(
        "name" => "datePicker",
        "maxDate" => "@endDatePicker",
        "format" => "YYYYMM",
        "themeBase" => "bs4",
    ));
    ?>
    <button type="submit">Submit</button>
</form>

Instead of using a textbox to allow the user to enter a date (in the YYYYMM format) I'd like to use an array of allowed dates already in the proper format. I guess a pull down would work. I have a function called getTaxyear (in a model) that populates an array call $TY. How would suggest switching this over?

Using "trial and error" I added this:

BSelect::create(array(
'name'=>"my_select",
"placeholder"=>"Select Report",
"data"=>$this->MyModel->getTaxyear()
)
);

getTaxyear() returns an array of the possible taxyears. When I run this in my report I get this notice

Message: Undefined property: MyReport::$MyModel Filename: assets/MyReport.view.php Line Number: 72

and then this error: Message: Call to a member function getTaxyear() on null Filename: /app/assets/MyReport.view.php Line Number: 72

Can I call a function within a BSelect:: ??

Then I tried:

protected function defaultParamValues()
{

    return array(
        "datePicker" => $this->dataStore("campaigns23")->get(0,"taxyear"),
        "BSelect" => $this->MyModel->getTaxyear()
    );
}

But still no luck.

I am not sure what you are getting at? Your code above is missing a ) on the first line. This is what I get: A PHP Error was encountered Severity: Notice

Message: Undefined property: MyReport::$MyModel

Filename: assets/MyReport.php

Line Number: 322

Backtrace:

File: /app/assets/MyReport.php Line: 322 Function: _error_handler

I created a session variable in my php controller called TY and in setup for the report I use

function settings()
{
    return array(
        "dataSources"=>array(
            "substantiator" => array(
                "connectionString" => "mysql:host=mysql;dbname=substantiator",
                "username" => "admin",
                "password" => "sadffg",
                "charset" => "utf8"
                                    ),
        ),
        "data"=>array(
            "class"=>'\koolreport\datasources\ArrayDataSource',
            "data"=>$_SESSION['TY'],
            "dataFormat"=>"table",
        )
    );
}

in the view I am trying to get a pulldown (this function is failing)

BSelect::create(array(
'name'=>"my_select",
"placeholder"=>"Select Report",
"data"=>"data"
)

This is getting silly. The only reason I paid for this package is that I thought that there was support. I guess not.

OK. Right now I have these two functions in the report

   protected function defaultParamValues()
    {
        $CI = & get_instance();
        $CI->load->model('MyModel')->library('session');

        return array(
            "datePicker" => $this->dataStore("campaigns23")->get(0,"taxyear"),
            "BSelect" => $_SESSION['TY']
        );
    }

    protected function bindParamsToInputs()
    {
        return array(
            "datePicker",
        );
    }

and then for the control itself I have the following in the view:
    BSelect::create(array(
    'name'=>"my_select",
    "placeholder"=>"Select Report Tax Year",
    "data"=>""
    )
    );

$_SESSION['TY'] is an array of strings. Where would i place $_SESSION['TY']?

>>I feel you are trying to hit & miss in the code. If possible, please spend time to read our documentation

EXACTLY! The trial and error method is killing me. There needs to be some documentation. I surely have better things to do than waste my vaulable time asking basic questions up here. Under methods you only show this:

No example. No explanation. Nothing. Perhaps there is a manual that I didn't get?

Under EXAMPLE you show this:

You show this same page under all of these. Are you aware of that?

So to answer your question as to "if I read the documentation?". My answer is "did you"? I am thinking that you need to look at it before accusing paying customers of not looking at it. The same insufficient page appears under all four of the anchors. I can't find an example of the use of "load()" anywhere on your site.

Please show an example of the use of load() as in the "documentation".

Sorry I got excited but I have limited time to solve this. Since load() is the only method shown. I need an example of how to use the only method shown. I already have an array. It is in a session variable call TY. Can I assume that this would work? I will move the following code to setup()

 $this->src("array_example_datasource")
                ->load(array(
                        $_session['TY'], 'associate' ),
                 ))

And then for the BSelect which will appear right after the above datasource

BSelect::create(array(
    'name'=>"my_select",
    "placeholder"=>"Select TY",
    "data"=>' array_example_datasource'
    )

));

and I modified settings: function settings()

{
    $CI = & get_instance();
    $CI->load->model('MyModel')->library('session');
    return array(
        "dataSources"=>array(
            "substantiator" => array(
                "connectionString" => "mysql:host=mysql;dbname=substantiator",
                "username" => "admin",
                "password" => "sadfsf3fg",
                "charset" => "utf8"
                                    ),
        ),
        "array_example_datasource"=>array(
            "class"=>'\koolreport\datasources\ArrayDataSource',
            "dataFormat"=>"associate",
            "data"=>array($_SESSION['TY'])
        ),
    );
}

Let's forget about the default and bindParamsToInputs. Life is too short for that!

Thanks. I like your suggestion under My suggestion. In fact I sent you that exact code above. See The one that says "trial and error" method? That function, getTaxyear() in the code, returns the array, TY. But now I am now loading that array into the $_session['TY'], before getting to the report itself, now.

So, other than including this directly in the view:

BSelect::create(array(

'name'=>"my_select",
"placeholder"=>"Select TY",
"data"=>$_SESSION['TY'],

));

There is NOTHING ELSE I need to do? Right. Please confirm. Nothing . No settings, no default, no bind? Nothing, right? I need you to confirm this before I waste another week on this BS.

I have another question. I want to centralize my setup() and settings() in my model file. But the way it works they are called by render(). Can I create the datastores external to the report? Any examples?

Ok. I have 3 separate reports I am building per user, with koolreport. One is a dashboard, one is a form, and one is a full report. Each one, when a report is displayed, calls its own settings(). That means that a new handle to mysql is being opened each time a user wants to run a report and this could happen numerous times in a single user session. Each time a user runs a report for a different tax year, the render runs, and this runs settings and thus opens more handles. I'd like to open the handle once in my php app, and store the handle in a session variable, once per user. When any of the 3 reports is run, it will use the "shared" handle, just like in a file server. Once the user logs off I will close the handle. Opening files is very cpu intensive.

I'd also like to build the datastores once per user. The reason is that due to the need to call render, setup is run every time a user wants to run a report for a different tax year. Very time consuming.

So what I would like is to be able open each datastore just one time (per user) and then close the handles when the user logs off. Has anyone had this question before?

Great, I will give that a try. How about the setup()? Is there a way that I can run that once in basereport and then just use the datastores it creates throughout the session?

Back to my original issue. I put this in the view: <form method="post">

<?php
BSelect::create(array(
    'name'=>"my_select",
    "placeholder"=>"Select TY",
    "data"=>$_SESSION['TY'],
));
?>
<button type="submit">Submit</button>

</form>

The pull down appears and the first value in the array appears but does not pull down.

Yes. The array TY is defined as $TY = array('2013', '2014', '2015', '2016', '2017', '2018', '2019', '2020', '2021', '2022', '2023', '2024', '2025', '2026', '2027', '2028', '2029', '2030');

Thus it just has an index and a year. It does not have "text".

I tried it with

\koolreport\inputs\BSelect::create(array(
'name'=>"my_select",
"placeholder"=>"Select TY",
    "data"=>array('2013', '2014', '2015', '2016', '2017', '2018', '2019', '2020', '2021', '2022', '2023', '2024', '2025', '2026', '2027', '2028', '2029', '2030'),
));

It still doesn't open. Is there any parameter that could be randomly set somewhere that is inhibiting it to open? Can I step through it with the debugger?

here is a screenshot of inspect. First I notice that multiselect is chosen. I am trying for a single select. You can see the TY's displayed. In running the debugger I see that the class BSelect was not found. I am not sure of the implications of that.

It must be something else. I copied the exact code from the example below and the pull down will also not work. BSelect::create(array(

'name'=>"my_select",
"placeholder"=>"Select customer",
"data"=>array(
    "John Doe"=>"1",
    "Jane Doe"=>"2",
    "Whatever Doe"=>"3",
)    

));

Are there any other controls that come with the KR package that will allow the user to pick one out of a choice of inputs?

I got it working. I am using this instead: \koolreport\inputs\Select::create(array(

"name"=>"customer",
"data"=>$_SESSION['TY'],

));

I am figuring that the documentation that says to use an array for BSelect is not correct. You meant an "associative array"!! How many wasted hours on "trial and error"?