/**
* Run the geocoding process.
*
* @param string Geocoding mode: "missing" or "all"
*
* @return string HTML code with geocoding results
*/
protected function geocode($mode)
{
if ($mode != 'all' && $mode != 'missing') {
//wrong mode
$message = new t3lib_FlashMessage('Invalid geocoding mode', '', t3lib_FlashMessage::ERROR);
return $message->render();
}
if ($mode == 'missing') {
$where = 'tx_odsosm_lon = 0 AND tx_odsosm_lat = 0';
} else {
$where = '1';
}
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'tt_address', $where . ' AND pid = ' . $this->pObj->id);
$count = 0;
$updated = 0;
$html = '';
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
$oldRow = $row;
++$count;
if (!tx_odsosm_div::updateAddress($row)) {
//not updated
continue;
}
$GLOBALS['TYPO3_DB']->exec_UPDATEquery('tt_address', 'uid = ' . intval($row['uid']), array('tx_odsosm_lat' => $row['lat'], 'tx_odsosm_lon' => $row['lon']));
$err = $GLOBALS['TYPO3_DB']->sql_error();
if ($err) {
$message = new t3lib_FlashMessage('SQL error: ' . htmlspecialchars($err), '', t3lib_FlashMessage::ERROR);
$html .= $message->render();
}
++$updated;
}
$message = new t3lib_FlashMessage('Updated ' . $updated . ' of ' . $count . ' address records', '', $updated == $count ? t3lib_FlashMessage::OK : t3lib_FlashMessage::WARNING);
$html .= $message->render();
return $html . '<br/><br/>';
}
function processDatamap_postProcessFieldArray($status, $table, $id, &$fieldArray, $obj)
{
switch ($table) {
case 'fe_users':
case 'tt_address':
$config = tx_odsosm_div::getConfig(array('autocomplete'));
// Search coordinates
if ($config['autocomplete'] && ($fieldArray['zip'] || $fieldArray['city'] || $fieldArray['address'])) {
$address = $obj->datamap[$table][$id];
if ($config['autocomplete'] == 2 || floatval($address['tx_odsosm_lon']) == 0) {
$ll = tx_odsosm_div::updateAddress($address);
if ($ll) {
$fieldArray['tx_odsosm_lon'] = sprintf('%01.6f', $address['lon']);
$fieldArray['tx_odsosm_lat'] = sprintf('%01.6f', $address['lat']);
if ($address['street']) {
$fieldArray['address'] = $address['street'];
if ($address['housenumber']) {
$fieldArray['address'] .= ' ' . $address['housenumber'];
}
}
if ($address['zip']) {
$fieldArray['zip'] = $address['zip'];
}
if ($address['city']) {
$fieldArray['city'] = $address['city'];
}
if ($address['state'] && $table == 'tt_address') {
$fieldArray['region'] = $address['state'];
}
if ($address['country']) {
$fieldArray['country'] = $address['country'];
}
}
}
}
break;
case 'tx_odsosm_track':
$filename = PATH_site . 'uploads/tx_odsosm/' . $fieldArray['file'];
if ($fieldArray['file'] && file_exists($filename)) {
require_once t3lib_extMgm::extPath('ods_osm', 'res/geoPHP/geoPHP.inc');
$polygon = geoPHP::load(file_get_contents($filename), pathinfo($filename, PATHINFO_EXTENSION));
$box = $polygon->getBBox();
$fieldArray['min_lon'] = sprintf('%01.6f', $box['minx']);
$fieldArray['min_lat'] = sprintf('%01.6f', $box['miny']);
$fieldArray['max_lon'] = sprintf('%01.6f', $box['maxx']);
$fieldArray['max_lat'] = sprintf('%01.6f', $box['maxy']);
}
break;
case 'tx_odsosm_marker':
if ($fieldArray['icon'] && file_exists(PATH_site . 'uploads/tx_odsosm/' . $fieldArray['icon'])) {
$size = getimagesize(PATH_site . 'uploads/tx_odsosm/' . $fieldArray['icon']);
$fieldArray['size_x'] = $size[0];
$fieldArray['size_y'] = $size[1];
$fieldArray['offset_x'] = -round($size[0] / 2);
$fieldArray['offset_y'] = -$size[1];
}
break;
case 'tx_odsosm_vector':
if ($fieldArray['data']) {
$this->lon = array();
$this->lat = array();
$vector = json_decode($fieldArray['data']);
foreach ($vector->geometry->coordinates[0] as $coordinates) {
$this->lon[] = $coordinates[0];
$this->lat[] = $coordinates[1];
}
}
$fieldArray['min_lon'] = sprintf('%01.6f', min($this->lon));
$fieldArray['min_lat'] = sprintf('%01.6f', min($this->lat));
$fieldArray['max_lon'] = sprintf('%01.6f', max($this->lon));
$fieldArray['max_lat'] = sprintf('%01.6f', max($this->lat));
break;
}
}
