"http://maps.google.com/maps?q=@lat@,+@long@&iwloc=A&hl=en", "Google Earth" => "@wwwroot@/mod/data/field/latlong/kml.php?d=@dataid@&fieldid=@fieldid@&rid=@recordid@", "Geabios" => "http://www.geabios.com/html/services/maps/PublicMap.htm?lat=@lat@&lon=@long@&fov=0.3&title=Moodle%20data%20item", "OpenStreetMap" => "http://www.openstreetmap.org/index.html?lat=@lat@&lon=@long@&zoom=11", "Multimap" => "http://www.multimap.com/map/browse.cgi?scale=200000&lon=@long@&lat=@lat@&icon=x" ); // Other map sources listed at http://kvaleberg.com/extensions/mapsources/index.php?params=51_30.4167_N_0_7.65_W_region:earth function data_field_latlong($field=0, $data=0) { parent::data_field_base($field, $data); } function display_add_field($recordid=0) { global $CFG; $lat = ''; $long = ''; if ($recordid) { if ($content = get_record('data_content', 'fieldid', $this->field->id, 'recordid', $recordid)) { $lat = $content->content; $long = $content->content1; } } $str = '

'; $str .= '

'.$this->field->name.''; $str .= ''; $str .= ''; $str .= '

'; $str .= '' . get_string('latitude', 'data') . '	°N
' . get_string('longitude', 'data') . '	°E

'; $str .= '

'; return $str; } function display_search_field($value = '') { global $CFG; $lats = get_records_sql_menu('SELECT id, content from '.$CFG->prefix.'data_content WHERE fieldid='.$this->field->id.' GROUP BY content ORDER BY content'); $longs = get_records_sql_menu('SELECT id, content1 from '.$CFG->prefix.'data_content WHERE fieldid='.$this->field->id.' GROUP BY content ORDER BY content'); $options = array(); if(!empty($lats) && !empty($longs)) { $options[''] = ''; // Make first index blank. foreach($lats as $key => $temp) { $options[$temp.','.$longs[$key]] = $temp.','.$longs[$key]; } } return choose_from_menu($options, 'f_'.$this->field->id, $value, 'choose', '', 0, true); } function parse_search_field() { return optional_param('f_'.$this->field->id, '', PARAM_NOTAGS); } function generate_sql($tablealias, $value) { $latlong[0] = ''; $latlong[1] = ''; $latlong = explode (',', $value, 2); return " ({$tablealias}.fieldid = {$this->field->id} AND {$tablealias}.content = '$latlong[0]' AND {$tablealias}.content1 = '$latlong[1]') "; } function display_browse_field($recordid, $template) { global $CFG; if ($content = get_record('data_content', 'fieldid', $this->field->id, 'recordid', $recordid)) { $lat = $content->content; if (strlen($lat) < 1) { return false; } $long = $content->content1; if (strlen($long) < 1) { return false; } if($lat < 0) { $compasslat = sprintf('%01.4f', -$lat) . '°S'; } else { $compasslat = sprintf('%01.4f', $lat) . '°N'; } if($long < 0) { $compasslong = sprintf('%01.4f', -$long) . '°W'; } else { $compasslong = sprintf('%01.4f', $long) . '°E'; } $str = '

'; // Now let's create the jump-to-services link $servicesshown = explode(',', $this->field->param1); // These are the different things that can be magically inserted into URL schemes $urlreplacements = array( '@lat@'=> $lat, '@long@'=> $long, '@wwwroot@'=> $CFG->wwwroot, '@contentid@'=> $content->id, '@dataid@'=> $this->data->id, '@courseid@'=> $this->data->course, '@fieldid@'=> $content->fieldid, '@recordid@'=> $content->recordid, ); if(sizeof($servicesshown)==1 && $servicesshown[0]) { $str .= " $compasslat, $compasslong"; } elseif (sizeof($servicesshown)>1) { $str .= "$compasslat, $compasslong\n"; } else { $str.= "$compasslat, $compasslong"; } $str.= '

'; return $str; } return false; } function update_content($recordid, $value, $name='') { $content = new object; $content->fieldid = $this->field->id; $content->recordid = $recordid; $value = trim($value); if (strlen($value) > 0) { $value = floatval($value); } else { $value = null; } $names = explode('_', $name); switch ($names[2]) { case 0: // update lat $content->content = $value; break; case 1: // update long $content->content1 = $value; break; default: break; } if ($oldcontent = get_record('data_content','fieldid', $this->field->id, 'recordid', $recordid)) { $content->id = $oldcontent->id; return update_record('data_content', $content); } else { return insert_record('data_content', $content); } } function get_sort_sql($fieldname) { global $CFG; switch ($CFG->dbfamily) { case 'mysql': // string in an arithmetic operation is converted to a floating-point number return '('.$fieldname.'+0.0)'; case 'postgres': //cast is for PG return 'CAST('.$fieldname.' AS REAL)'; default: //Return just the fieldname. TODO: Look behaviour under MSSQL and Oracle return $fieldname; } } function export_text_value($record) { return sprintf('%01.4f', $record->content) . ' ' . sprintf('%01.4f', $record->content1); } } ?>