Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
  • Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
  • PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.
<?php

// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle 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.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

// A lot of this initial stuff is copied from mod/data/view.php

require_once('../../../../config.php');
require_once('../../lib.php');

// Optional params: row id "rid" - if set then export just one, otherwise export all

$d       = required_param('d', PARAM_INT);   // database id
$fieldid = required_param('fieldid', PARAM_INT);   // field id
$rid     = optional_param('rid', 0, PARAM_INT);    //record id

$url = new moodle_url('/mod/data/field/latlong/kml.php', array('d'=>$d, 'fieldid'=>$fieldid));
if ($rid !== 0) {
    $url->param('rid', $rid);
}
$PAGE->set_url($url);

if ($rid) {
    if (! $record = $DB->get_record('data_records', array('id'=>$rid))) {
< print_error('invalidrecord', 'data');
> throw new \moodle_exception('invalidrecord', 'data');
} if (! $data = $DB->get_record('data', array('id'=>$record->dataid))) {
< print_error('invalidid', 'data');
> throw new \moodle_exception('invalidid', 'data');
} if (! $course = $DB->get_record('course', array('id'=>$data->course))) {
< print_error('coursemisconf');
> throw new \moodle_exception('coursemisconf');
} if (! $cm = get_coursemodule_from_instance('data', $data->id, $course->id)) {
< print_error('invalidcoursemodule');
> throw new \moodle_exception('invalidcoursemodule');
} if (! $field = $DB->get_record('data_fields', array('id'=>$fieldid))) {
< print_error('invalidfieldid', 'data');
> throw new \moodle_exception('invalidfieldid', 'data');
} if (! $field->type == 'latlong') { // Make sure we're looking at a latlong data type!
< print_error('invalidfieldtype', 'data');
> throw new \moodle_exception('invalidfieldtype', 'data');
} if (! $content = $DB->get_record('data_content', array('fieldid'=>$fieldid, 'recordid'=>$rid))) {
< print_error('nofieldcontent', 'data');
> throw new \moodle_exception('nofieldcontent', 'data');
} } else { // We must have $d if (! $data = $DB->get_record('data', array('id'=>$d))) {
< print_error('invalidid', 'data');
> throw new \moodle_exception('invalidid', 'data');
} if (! $course = $DB->get_record('course', array('id'=>$data->course))) {
< print_error('coursemisconf');
> throw new \moodle_exception('coursemisconf');
} if (! $cm = get_coursemodule_from_instance('data', $data->id, $course->id)) {
< print_error('invalidcoursemodule');
> throw new \moodle_exception('invalidcoursemodule');
} if (! $field = $DB->get_record('data_fields', array('id'=>$fieldid))) {
< print_error('invalidfieldid', 'data');
> throw new \moodle_exception('invalidfieldid', 'data');
} if (! $field->type == 'latlong') { // Make sure we're looking at a latlong data type!
< print_error('invalidfieldtype', 'data');
> throw new \moodle_exception('invalidfieldtype', 'data');
} $record = NULL; } require_course_login($course, true, $cm); $context = context_module::instance($cm->id);
< < /// If it's hidden then it's don't show anything. :) < if (empty($cm->visible) and !has_capability('moodle/course:viewhiddenactivities', $context)) { < $PAGE->set_title($data->name); < echo $OUTPUT->header(); < notice(get_string("activityiscurrentlyhidden")); < } < < /// If we have an empty Database then redirect because this page is useless without data
> // If we have an empty Database then redirect because this page is useless without data.
if (has_capability('mod/data:managetemplates', $context)) { if (!$DB->record_exists('data_fields', array('dataid'=>$data->id))) { // Brand new database! redirect($CFG->wwwroot.'/mod/data/field.php?d='.$data->id); // Redirect to field entry } } //header('Content-type: text/plain'); // This is handy for debug purposes to look at the KML in the browser header('Content-type: application/vnd.google-earth.kml+xml kml'); header('Content-Disposition: attachment; filename="moodleearth-'.$d.'-'.$rid.'-'.$fieldid.'.kml"'); echo data_latlong_kml_top(); if($rid) { // List one single item $pm = new stdClass(); $pm->name = data_latlong_kml_get_item_name($content, $field); $pm->description = "&lt;a href='$CFG->wwwroot/mod/data/view.php?d=$d&amp;rid=$rid'&gt;Item #$rid&lt;/a&gt; in Moodle data activity"; $pm->long = $content->content1; $pm->lat = $content->content; echo data_latlong_kml_placemark($pm); } else { // List all items in turn $contents = $DB->get_records('data_content', array('fieldid'=>$fieldid)); echo '<Document>'; foreach($contents as $content) { $pm->name = data_latlong_kml_get_item_name($content, $field); $pm->description = "&lt;a href='$CFG->wwwroot/mod/data/view.php?d=$d&amp;rid=$content->recordid'&gt;Item #$content->recordid&lt;/a&gt; in Moodle data activity"; $pm->long = $content->content1; $pm->lat = $content->content; echo data_latlong_kml_placemark($pm); } echo '</Document>'; } echo data_latlong_kml_bottom(); function data_latlong_kml_top() { return '<?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://earth.google.com/kml/2.0"> '; } function data_latlong_kml_placemark($pm) { return '<Placemark> <description>'.$pm->description.'</description> <name>'.$pm->name.'</name> <LookAt> <longitude>'.$pm->long.'</longitude> <latitude>'.$pm->lat.'</latitude> <range>30500.8880792294568</range> <tilt>46.72425699662645</tilt> <heading>0.0</heading> </LookAt> <visibility>0</visibility> <Point> <extrude>1</extrude> <altitudeMode>relativeToGround</altitudeMode> <coordinates>'.$pm->long.','.$pm->lat.',50</coordinates> </Point> </Placemark> '; } function data_latlong_kml_bottom() { return '</kml>'; } function data_latlong_kml_get_item_name($content, $field) { global $DB; // $field->param2 contains the user-specified labelling method $name = ''; if($field->param2 > 0) {
< $name = htmlspecialchars($DB->get_field('data_content', 'content', array('fieldid'=>$field->param2, 'recordid'=>$content->recordid)));
> $name = htmlspecialchars($DB->get_field('data_content', 'content', array('fieldid'=>$field->param2, 'recordid'=>$content->recordid)), ENT_COMPAT);
}elseif($field->param2 == -2) { $name = $content->content . ', ' . $content->content1; } if($name=='') { // Done this way so that "item #" is the default that catches any problems $name = get_string('entry', 'data') . " #$content->recordid"; } return $name; }