Dropdown with Month to select Period

Hi,
I wasn't able to understand what are you trying to do.

Provide a more detailed description of your task.

Hi,
I wasn't able to understand what are you trying to do.

Provide a more detailed description of your task.

Hi,

The User must select the period for example January 2007

then the Date must konvert into a Timestamp with my own function and the SQL select musst integrate this Variable
This variable ist dynamic to select from the user after this a report should be shown with this data.

For example:

without any selection before the user has selected->

SQL: Select Menge, Datum, Einheit from Buchungen
User has selected 01/2007->

SQL: Select Menge, Datum, Einheit from Buchungen where Datum between gmt_to_cet('01.01.2007') and gmt_to_cet('31.01.2007').
This Range musst be insert dynamic into the standard SQL.

is there a solution for this problem or doesn´t it work with PHPR?

ist it possible to generate a dynamic date in the where clause of the query?
when it ist posiible how is this to realize?

thanks for answers

Hi,
you can do this using Visual Editor and Before SQL queryevent.

Add this code to the List page with Visual Editor (in HTML mode):

<select onchange="window.location='..._list.php?a=filter&'+this.options[this.selectedIndex].value">

Then put this code to Before SQL query event:

if($_GET["a"]=="filter")

thank you i will try it

Hi,

Hi ,

The above code works great, the list page jumps to the selected month as per the selected value in the combo box. What I cant figure out is how to show the selected month in the combo control after the filter is applied to the list page. The combo always goes back to show Select Month after the filter is applied. Any help would be appreciated. thanks.
I added the following with visual editor:
<select onchange="window.location='SDP_Monthly_Payment_Review_list.php?a=filter&'+this.options[this.selectedIndex].value">

<option value="Please select...">Select Month</option>

<option value="from=2008-3-01&to=2108-04-01">All Months</option>

<option value="from=2008-3-01&to=2008-04-01">March 2008</option>

<option value="from=2008-04-01&to=2008-05-01">April 2008</option>

</select>

Hi,
I recommend you to use custom event (Insert PHP code snippet option on the Visual Editor tab) for this dropdown.

Here is a sample:

$str = "";

Hi,

Hi Jane,
I had tried something similar previously and it did not work. I then tried the exact code you recommended in the custom event along with the BeforeQuestList and htm code and it does not appear to work either. The combo box sets the filter for the list page properly but does not reflect the filter selected, it always goes back to 'Please Select'. Here is the code I am using, perhaps it is something small:
function BeforeQueryList(&$strSQL,&$strWhereClause,&$strOrderBy)

{
if($_GET["a"]=="filter")

$strWhereClause=whereAdd($strWhereClause,"ReportMonth between '".$_GET["from"]."' and '".$_GET["to"]."'");
} // function BeforeQueryList
function SDP_Monthly_Payment_Review_Event1(&$params)

{

// Put your code here.

//echo "Your message";

$str = "";

$str.= "<select onchange=\"window.location='SDP_Monthly_Payment_Review_list.php?a=filter&'+this.options[this.selectedIndex].value\">";

$str.= "<option value=\"Please select...\">Select Month</option>";
if ($_GET["from"]=="2008-3-01" && $_GET["to"]=="2108-04-01")

$str.= "<option selected value=\"from=2008-3-01&to=2108-04-01\">All Months</option>";

else

$str.= "<option value=\"from=2008-3-01&to=2108-04-01\">All Months</option>";
$str.= "<option value=\"from=2008-3-01&to=2008-04-01\">March 2008</option>";

$str.= "<option value=\"from=2008-04-01&to=2008-05-01\">April 2008</option>";

$str.= "</select>";
echo $str;

}
In the _list.htm:
<select onchange="window.location='SDP_Monthly_Payment_Review_list.php?a=filter&'+this.options[this.selectedIndex].value">

<option value="Please select...">Select Month</option>

<option value="from=2008-3-01&to=2108-04-01">All Months</option>

<option value="from=2008-3-01&to=2008-04-01">March 2008</option>

<option value="from=2008-04-01&to=2008-05-01">April 2008</option>

</select>

Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

Hi Jane,
I have the same problem with very similar code:
The combo box sets the filter for the list page properly but does not reflect the filter selected,

it always goes back to 'Please Select'.



Please publish the solution from forerunner mrpeeble into that thread.
Thanks Michael

Here is the general solution:

if ($_REQUEST["from"]=="firstvalue" && $_REQUEST["to"]=="secondvalue")