Number of days without rain - possible webtag

Hillbilly · Post by **Hillbilly** » Tue 16 Mar 2010 9:18 am

The Cumulus display can show me number of days with rain on the summaries. Would it be possible/useful to have a webtag that outputs either that, or my preference, number of days without rain, in current month and/or year to date?

Post by **steve** » Tue 16 Mar 2010 10:00 am

It would be possible, yes. At the moment that would require trawling through dayfile.txt each time the tag was encountered, which isn't the most efficient way to do it. What it really needs is for Cumulus to keep track of the two values so they're readily available during tag processing.

I think I might reinstate the bug/enhancement reporting/tracking site, but just use it for enhancements this time. I can't really do anything other than simple changes at the moment, due to working on the "next version", so things that I don't do immediately will get forgotten - by me anyway!

Hillbilly · Post by **Hillbilly** » Tue 16 Mar 2010 11:02 am

Hi Steve,

it's a good idea to reinstate the enhancement request process because it would be mad to expect you to keep track of ideas. I had trawled the forum and seen something similar had been discussed last year, so was raising to 'add to the list'.

Of course the next version is priority, very happy that that is the case.

mcrossley · Post by **mcrossley** » Tue 16 Mar 2010 8:18 pm

Spookily I was thinking of this feature just yesterday. maybe something do with the dry spell we are having

Maybe I'll add a view to the SQL db on my web server...

Hillbilly · Post by **Hillbilly** » Thu 01 Apr 2010 8:04 pm

Thanks for raising the enhancement request Mark. I had a think about doing something in the mean time and came up with the idea of writing a query to run on the SQL database and display the result on my Record page. I went for 'No of days without rain 'nn' in the last month' and use a rolling month to calculate.

I can't speak for the quality of my SQL query as I know little about SQL, but it seems to reconcile! I renamed my Record.htm page to Record.php and added that to the list for Cumulus to process.

The query is:

raindaysquery.txt

This is in the <body> after my header banner.

In the rainfall table, I have added the following:
<tr class="td_rainfall_data">
<td class="labels">Days Without Rain </td>
<?php print "<td>$raindays</td>\n"; ?>
<td>in the last month</td>
</tr>

If anyone has any comments on the code, always looking to improve.

mcrossley · Post by **mcrossley** » Fri 02 Apr 2010 10:13 am

Thanks for that Helen, I've been looking into to, but I want to show the number of consecutive days without rain. The SQL for that is proving much trickier, and I'm having to self join the table and perform sub-queries. I think it will be simpler to combine a simple SQL query with some PHP code to check for the consecutive day count.

Hillbilly · Post by **Hillbilly** » Fri 02 Apr 2010 10:21 am

Yes I can see that would be tricky. I'd be interested to have an update on how you go on.

Post by **daj** » Mon 05 Apr 2010 6:36 pm

I've had an attempt to work out the number of consecutive days without rain. The possible solution below assumes your dayfile is contained within an SQL data table on your web server. Here is the SQL code....

Code: Select all

SET @count = 0;
 
SELECT LogDate,Count FROM (
    SELECT *, @count:=(CASE WHEN TotRainFall=0 THEN @count+1 ELSE 0 END) AS `count`
    FROM dayfile
) temp
ORDER BY `count` DESC
LIMIT 1

This will return a date and a number, so in my case....

2010-01-12, 26

This tells me that 12 January 2010 was the last day of a run of 26 days with no rain and it was the longest running since my records began

I would be interested in others testing this if you have your data in SQL

Hillbilly · Post by **Hillbilly** » Tue 06 Apr 2010 7:37 pm

I would be interested in others testing this if you have your data in SQL

David, just tested the query and my result was 18th March 2010 for 17 days, which is correct.

Hillbilly · Post by **Hillbilly** » Thu 22 Apr 2010 8:21 pm

I've finally got round to trying to add this to my records page. The query works fine when run as a SQL query directly on my database table. However, I am struggling to work out how to assign the resulting date and count to two separate variables which can then be displayed. (I can do one!). I have not managed to find a good reference to running MYSQL in PHP, which doesn't help.

Can anyone help?

GrahamBuxton · Post by **GrahamBuxton** » Fri 23 Apr 2010 1:34 am

The query works fine when run as a SQL query directly on my database table. However, I am struggling to work out how to assign the resulting date and count to two separate variables which can then be displayed. (I can do one!). I have not managed to find a good reference to running MYSQL in PHP, which doesn't help.

Check out Example #2 at this page:
http://www.php.net/manual/en/function.mysql-query.php

Hillbilly · Post by **Hillbilly** » Sat 24 Apr 2010 7:22 am

Thanks Graham. There are certainly a good few examples there. Will have a good look when I get a chance.

Cumulus Support

Number of days without rain - possible webtag

Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag

Re: Number of days without rain - possible webtag