<?php

/**

* make-levees-files.php

*

* A PHP script to take an SQLite table of levee information and turn

* it into GeoJSON, JSON+LD, HTML and iCalendar files.

*

* Requires eluceo — iCal -- install with:

*

* composer require eluceo/ical

*

* This code is released under the MIT license.

*

* Permission is hereby granted, free of charge, to any person obtaining

* a copy of this software and associated documentation files (the "Software"),

* to deal in the Software without restriction, including without

* limitation the rights to use, copy, modify, merge, publish, distribute,

* sublicense, and/or sell copies of the Software, and to permit persons

* to whom the Software is furnished to do so, subject to the following conditions:

*

* The above copyright notice and this permission notice shall be

* included in all copies or substantial portions of the Software.

*

* This program is distributed in the hope that it will be useful, but

* WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

*

* @version 1.5, December 15, 2024

* @link https://github.com/reinvented/levees

* @author Peter Rukavina <peter@rukavina.net>

* @copyright Copyright &copy; 2018, Reinvented Inc.

* @license hhttps://opensource.org/licenses/MIT MIT license

*/

// Required for iCalendar creation; you must install "eluceo — iCal" as above.

require_once 'vendor/autoload.php';

// Set the default time zone.

date_default_timezone_set("America/Halifax");

// Create a new iCalendar object.

$vCalendar = new \Eluceo\iCal\Component\Calendar('ruk.ca/levee-2024');

// We're going to create four files; first we define them.

$file['json+ld'] = "levees.json";

$file['geojson'] = "levees.geojson";

$file['geojson-charlottetown'] = "levees-charlottetown.geojson";

$file['html'] = "levees.html";

$file['ics'] = "levees.ics";

list($fp, $content) = openFiles($file);

// Open the SQLite3 database that stores levee information.

$db = new SQLite3('data/levees.sqlite');

// Initialize a counter that we can use for the GeoJSON marker-symbol property.

$counter = 1;

$charlottetown_counter = 1;

// Retrieve all the levees

$results = $db->query('SELECT * FROM levees where active = 1 order by startDate, endDate, name');

while ($row = $results->fetchArray(SQLITE3_ASSOC)) {

if (!$row['cancelled']) {

// Create JSON+LD for this levee.

$content['json+ld'][] = makeJSONLD($row);

// Create GeoJSON for this levee.

$content['geojson']['features'][] = makeGeoJSON($row, $counter);

// Create GeoJSON for this levee - only if it's in Charlottetown.

if ($row['charlottetownarea']) {

$content['geojson-charlottetown']['features'][] = makeGeoJSON($row, $charlottetown_counter);

$charlottetown_counter++;

}

// Create iCalendar for this levee.

$vCalendar->addComponent(makeICalendar($row));

}

// Create HTML for this levee.

$content['html'] .= makeHTML($row);

// Increment the counter.

$counter++;

}

// Add to the GeoJSON object to make it valid.

$content['geojson']['type'] = "FeatureCollection";

// Add to the GeoJSON object to make it valid.

$content['geojson-charlottetown']['type'] = "FeatureCollection";

// Write the JSON+LD data

fwrite($fp['json+ld'], json_encode($content['json+ld'], JSON_PRETTY_PRINT));

// Write the GeoJSON data

fwrite($fp['geojson'], json_encode($content['geojson'], JSON_PRETTY_PRINT));

// Write the GeoJSON data

fwrite($fp['geojson-charlottetown'], json_encode($content['geojson-charlottetown'], JSON_PRETTY_PRINT));

// Write the HTML data

fwrite($fp['html'], makeHTMLheader());

fwrite($fp['html'], $content['html']);

fwrite($fp['html'], "\t" . '</tbody>' . "\n" . '</table>' . "\n");

// Wrhite the iCalendar data

fwrite($fp['ics'], $vCalendar->render());

closeFiles($file, $fp);

function openFiles($file) {

}

function closeFiles($file, $fp) {

}

function makeJSONLD($row) {

}

function makeGeoJSON($row, $counter) {

}

function makeHTMLheader() {

return "<table class='levees datatable'>\n\t<thead>\n\t\t<tr>\n\t\t\t<th class='levee_name'>Organization</th>\n\t\t\t<th class='levee_address'>Location</th>\n\t\t\t<th class='levee_start'>Starts</th>\n\t\t\t<th class='levee_end'>Ends</th>\n\t\t\t<th class='levee_accessible'>♿<span class='levee_accessible_title'> Accessible</span></th>\n\t\t\t<th class='levee_allages'><span class='levee_allages_title'>All Ages</span></th>\n\t\t</tr></thead><tbody>\n";

}

function makeHTML($row) {

}

function makeICalendar($row) {

}