Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Top 10 Records Page

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderators: daj, TNETWeather

User avatar
mcrossley
Posts: 4979
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Tue Oct 03, 2017 7:59 am

Fixed, though I see my phone is now in a time warp, it updated this morning to the Oreo 5th October 2017 update! :lol:

MeteoBisignano
Posts: 79
Joined: Mon Mar 09, 2015 10:45 am
Weather Station: wh3080
Operating System: windows
Location: Cosenza

Re: Top 10 Records Page

Postby MeteoBisignano » Sat Oct 07, 2017 9:29 am

Hi guys
after updating my file squil in the import phase I give error 500
I downloaded the latest version of importcumulusfile.php and toptens.php
who helps me solve it?

User avatar
mcrossley
Posts: 4979
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Sat Oct 07, 2017 6:44 pm

You will need to look in your web servers error log for a clue. Failing that you will need to enable full error reporting in the script. I'm away on holiday at the mo, so support from me is going to be patchy/intermittent.

colinpb
Posts: 86
Joined: Thu Nov 10, 2011 8:14 pm
Weather Station: VP2+SHT31+DFars+Solar+AeroCone
Operating System: Windows 10
Location: Hemel Hempstead, Hertfordshire, UK

Re: Top 10 Records Page

Postby colinpb » Sun Oct 08, 2017 10:13 am

Installed Top 10 records, and I have a query regards this years records. I was expecting to see all records broken in 2017 showing in blue, however only one in September for smallest pressure change is showing. Is this how it’s meant to be; if so is there a way to turn on all records broken for 2017?
To see how my records look, go to the the system info page; which I use for testing.

Colin

User avatar
mcrossley
Posts: 4979
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Postby mcrossley » Sun Oct 08, 2017 5:32 pm

The highlight's are for the last 30 days, or this year depending on the record type. You can change the 30 day period somewhere near the top of the source code. I don't have access to that at the mo to check though.

To do "this year" for all records would be more involved as the SQL queries themselves return the highlight flag.

colinpb
Posts: 86
Joined: Thu Nov 10, 2011 8:14 pm
Weather Station: VP2+SHT31+DFars+Solar+AeroCone
Operating System: Windows 10
Location: Hemel Hempstead, Hertfordshire, UK

Re: Top 10 Records Page

Postby colinpb » Sun Oct 08, 2017 7:27 pm

Mark

I thought that's how it was working. My old Access produced top ten records changing for the current year, but on numerous pages. Your work is far superior.

Thank you

Colin

sfws
Posts: 345
Joined: Fri Jul 27, 2012 11:29 am
Weather Station: off-line Fine Offset plus others
Operating System: off-line Vista and W10 PCs
Location: UK

Re: Top 10 Records Page

Postby sfws » Mon Oct 09, 2017 7:59 am

I have not looked up Mark's source, and I recall that I made many changes for my version as discussed with Mark at the time.
I have found I used

Code: Select all

$recentHighlight = $monthNum * 31; // number of days (+1) of recent records to highlight, initialised at approximate equivalent for number of days so far this year

Colin
I suspect $recentHighlight is the variable name that Mark chose, and as you can see from my comment I have approximated it to highlight everything this year by multiplying it by the values shown ($monthNum will be 10 for October). PHP does have ability to report a date in the number of days this year format (it is 'z') so with hindsight that would be better way to define the maximum number of days old that require the highlight.

Code: Select all

$recentHighlight = new DateTime ("now") -> format("z");


As Mark says for many tables recent test is in the SQL, the first two items in the select are what appears in the table and the third is a condition that determines if it is highlighted. Again I modified mine to compare just year by writing

Code: Select all

"DATE_FORMAT(LogDate, '%Y') = DATE_FORMAT('$lastDateOnDB', '%Y') ";
but I suspect Mark uses a different variable name in RH side, and there are a lot of queries to edit (even more in my version).

colinpb
Posts: 86
Joined: Thu Nov 10, 2011 8:14 pm
Weather Station: VP2+SHT31+DFars+Solar+AeroCone
Operating System: Windows 10
Location: Hemel Hempstead, Hertfordshire, UK

Re: Top 10 Records Page

Postby colinpb » Tue Oct 10, 2017 3:54 pm

As it is works on rolling days, If I up the 32 to 366 it’s giving me all the records so far for 2017. However as there’s still October/November and December 2017 to left check, it showing records from 2016. So I’m getting pretty much what I want. A fix would be to change previous years records to black as top 10 moves to current year.

Colin

User avatar
HRVistaWeather
Posts: 164
Joined: Mon Apr 09, 2012 2:38 pm
Weather Station: Davis VP2 Plus - 24hr FARS
Operating System: Windows 7 Ultimate (64bit)
Location: Franklin, Huon Valley, Tasmania
Contact:

Re: Top 10 Records Page

Postby HRVistaWeather » Tue Oct 10, 2017 9:37 pm

When I want to highlight current year I use this, works perfect every time:

Code: Select all

$dayNumber = date("z");        // Day Number of current Year eg. ( 284 ) for today 2017/10/11
$recentHighlight = $dayNumber; // number of days (so far in current year) of recent records to highlight


regards,
Tony
https://southfranklinweather.com
Image
Huon River Vista - South Franklin Weather - Tasmania
Davis Vantage Pro 2 Plus - FARS, Cumulus MX, 2 Soil Temp/Moist Solar/Rad.
Back Online : 2017-11-01


Return to “Web site - General”

Who is online

Users browsing this forum: Bing [Bot] and 5 guests