wheres-the-water.php is body which can be viewed or used at http://canoescotland.org/where-go/wheres-water
sidebar.php is drupal is body of side block http://canoescotland.org/admin/structure/block/manage/block/18/ old-html/wheres-water-drupal-content.html is drupal body of old site
The old version was written many years ago. It had a Java backend which ran on cron to download SEPA data from private database connection and put it into SCA website Drupal database. Mixing the WtW data into multiple tables in the Drupal database is unnecessary and complicates things. The Java source code has been lost so the site needs to be rewritten. These days SEPA provides public CSV files which list the gauges and ones for each river with current readings, so we just use these.
./phpunit GrabSepaGaugesTest.php ./phpunit GrabSepaRiversTest.php ./phpunit GrabSepaRiverTest.php ./phpunit ScratchTest.php ./phpunit RiverSectionsTest.php (note this needs a database connection)
database connection: only used for data import from old drupal/java system which stored the river data in Drupal's mysql database config/database.php: <?php $servername = "localhost"; $username = "scauser"; $password = "xxx"; $dbname = "scadb";
lib/Scratch.php class to play around and test with lib/GrabSepaGauges class to download SEPA gauge data and return it as array, sepaData() is the main method to use lib/RiverSections.php Class to deal with the river sections data, edit the data and export it as Javascript (most of the action happens here) lib/GrabSepaRivers class to provide and save/load json with current river readings, when it needs to update data it uses below class lib/GrabSepaRiver class to download current reading data for a river
admin/river-section.php admin UI to set, add and delete river sections
We have to use PHP as it integrates with Drupal.
SCA server uses PHP 5, this may cause problems.
json_decode($data, true) <-- use true here else it'll import hashes as objects not as associative arrays
config.php should have the root file location set: <?php define("ROOT", "/var/www/canoescotland.org/wheres-the-water");
Edit config.php to have the correct server path eg. "/var/www/wheres-the-water"
Make sure your webserver has permission to write to the data folder Debian: sudo chown -R www-data.www-data data/
Run the admin/download-river-readings.php script once 'Unable to open file' will be displayed if the above steps have not been performed correctly
Run cron-update-sepa-gauges-and-backup.rb every minute in cron to update river gauge readings and backup section file
Run check-rivers-up-to-date.py ever few minutes to check that the river gauge readings have updated
Locally make a file config.ini in the top repo directory (this is ignored with .gitignore and can not be committed)
[Cron] AdminWebLogin=myuser:mypass TelegramToken=botid:botid TelegramChatId=123123123