/** * 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; } }