$wms4 = isset($_POST['wms4']) && ($_POST['wms4'] == '0' || $_POST['wms4'] == '1') ? $_POST['wms4'] : (isset($_GET['wms4']) && ($_GET['wms4'] == '0' || $_GET['wms4'] == '1') ? $_GET['wms4'] : $query_view['wms4']);
$wms5 = isset($_POST['wms5']) && ($_POST['wms5'] == '0' || $_POST['wms5'] == '1') ? $_POST['wms5'] : (isset($_GET['wms5']) && ($_GET['wms5'] == '0' || $_GET['wms5'] == '1') ? $_GET['wms5'] : $query_view['wms5']);
$wms6 = isset($_POST['wms6']) && ($_POST['wms6'] == '0' || $_POST['wms6'] == '1') ? $_POST['wms6'] : (isset($_GET['wms6']) && ($_GET['wms6'] == '0' || $_GET['wms6'] == '1') ? $_GET['wms6'] : $query_view['wms6']);
$wms7 = isset($_POST['wms7']) && ($_POST['wms7'] == '0' || $_POST['wms7'] == '1') ? $_POST['wms7'] : (isset($_GET['wms7']) && ($_GET['wms7'] == '0' || $_GET['wms7'] == '1') ? $_GET['wms7'] : $query_view['wms7']);
$wms8 = isset($_POST['wms8']) && ($_POST['wms8'] == '0' || $_POST['wms8'] == '1') ? $_POST['wms8'] : (isset($_GET['wms8']) && ($_GET['wms8'] == '0' || $_GET['wms8'] == '1') ? $_GET['wms8'] : $query_view['wms8']);
$wms9 = isset($_POST['wms9']) && ($_POST['wms9'] == '0' || $_POST['wms9'] == '1') ? $_POST['wms9'] : (isset($_GET['wms9']) && ($_GET['wms9'] == '0' || $_GET['wms9'] == '1') ? $_GET['wms9'] : $query_view['wms9']);
$wms10 = isset($_POST['wms10']) && ($_POST['wms10'] == '0' || $_POST['wms10'] == '1') ? $_POST['wms10'] : (isset($_GET['wms10']) && ($_GET['wms10'] == '0' || $_GET['wms10'] == '1') ? $_GET['wms10'] : $query_view['wms10']);
$listmarkers = isset($_POST['listmarkers']) && ($_POST['listmarkers'] == '0' || $_POST['listmarkers'] == '1') ? $_POST['listmarkers'] : (isset($_GET['listmarkers']) && ($_GET['listmarkers'] == '0' || $_GET['listmarkers'] == '1') ? $_GET['listmarkers'] : $query_view['listmarkers']);
$multi_layer_map = isset($_POST['multi_layer_map']) && ($_POST['multi_layer_map'] == '0' || $_POST['multi_layer_map'] == '1') ? $_POST['multi_layer_map'] : (isset($_GET['multi_layer_map']) && ($_GET['multi_layer_map'] == '0' || $_GET['multi_layer_map'] == '1') ? $_GET['multi_layer_map'] : $query_view['multi_layer_map']);
$multi_layer_map_list = isset($_POST['multi_layer_map_list']) ? $_POST['multi_layer_map_list'] : (isset($_GET['multi_layer_map_list']) ? $_GET['multi_layer_map_list'] : $query_view['multi_layer_map_list']);
$address = isset($_POST['address']) ? $_POST['address'] : (isset($_GET['address']) ? $_GET['address'] : $query_view['address']);
$clustering = isset($_POST['clustering']) && ($_POST['clustering'] == '0' || $_POST['clustering'] == '1') ? $_POST['clustering'] : (isset($_GET['clustering']) && ($_GET['clustering'] == '0' || $_GET['clustering'] == '1') ? $_GET['clustering'] : $query_view['clustering']);
$gpx_url = isset($_POST['gpx_url']) ? $_POST['gpx_url'] : (isset($_GET['gpx_url']) ? $_GET['gpx_url'] : $query_view['gpx_url']);
$gpx_panel = isset($_POST['gpx_panel']) && ($_POST['gpx_panel'] == '0' || $_POST['gpx_panel'] == '1') ? $_POST['gpx_panel'] : (isset($_GET['gpx_panel']) && ($_GET['gpx_panel'] == '0' || $_GET['gpx_panel'] == '1') ? $_GET['gpx_panel'] : $query_view['gpx_panel']);
if ($geocode != NULL) {
$do_geocoding = lmm_getLatLng($geocode);
if ($do_geocoding['success'] == true) {
$layerviewlat = $do_geocoding['lat'];
$layerviewlon = $do_geocoding['lon'];
$address = $do_geocoding['address'];
} else {
if ($format == 'json') {
header('Content-type: application/json; charset=utf-8');
if ($callback != NULL) {
echo $callback . '(';
}
echo '{' . PHP_EOL;
echo '"success":false,' . PHP_EOL;
echo '"message":"' . sprintf(esc_attr__('Geocoding error: %1s', 'lmm'), $do_geocoding['message']) . '",' . PHP_EOL;
echo '"data": { }' . PHP_EOL;
echo '}';
if ($objWorksheet->getCellByColumnAndRow(35, $row) == '0' || $objWorksheet->getCellByColumnAndRow(35, $row) == '1') {
$gpx_panel = $objWorksheet->getCellByColumnAndRow(35, $row);
} else {
echo date('H:i:s') . ' <a name="' . $row . '"></a><span class="warning">' . sprintf(__('Warning: invalid value for %1$s in row %2$s (%3$s) - using current value %4$s instead', 'lmm'), 'gpx_panel', $row, $objWorksheet->getCellByColumnAndRow(35, $row), $existing_layer_data['gpx_panel']) . '</span><br/>';
$stats_warnings[] = $row;
$gpx_panel = $existing_layer_data['gpx_panel'];
}
} else {
echo date('H:i:s') . ' <a name="' . $row . '"></a><span class="warning">' . sprintf(__('Warning: invalid value for %1$s in row %2$s (%3$s) - using current value %4$s instead', 'lmm'), 'gpx_panel', $row, $objWorksheet->getCellByColumnAndRow(35, $row), $existing_layer_data['gpx_panel']) . '</span><br/>';
$stats_warnings[] = $row;
$gpx_panel = $existing_layer_data['gpx_panel'];
}
//info: geocoding address if set
$geocoding_option = $_POST['geocoding-option'];
if ($geocoding_option == 'geocoding-on') {
$do_geocoding = lmm_getLatLng($address);
if ($do_geocoding['success'] == true) {
$layerviewlat = $do_geocoding['lat'];
$layerviewlon = $do_geocoding['lon'];
$address_from_import_file = $address;
$address = $do_geocoding['address'];
echo date('H:i:s') . ' <a name="' . $row . '"></a>' . sprintf(__('Geocoding result for address "%1$s" in row %2$s: "%3$s" (lat: %4$s, lon: %5$s)', 'lmm'), $address_from_import_file, $row, $address, $layerviewlat, $layerviewlon) . '<br/>';
} else {
echo date('H:i:s') . ' <a name="' . $row . '"></a><span class="error">' . sprintf(__('Error: geocoding for address "%1$s" in row %2$s failed (%3$s) - skipping row', 'lmm'), $address, $row, $do_geocoding['message']) . '</span><br/>';
$stats_errors[] = $row;
}
}
//info: only save to database if test mode is off
if ($test_mode == 'test-mode-off') {
if (isset($do_geocoding) && $do_geocoding['success'] == true || $geocoding_option == 'geocoding-off') {
$query_update = $wpdb->prepare("UPDATE `{$table_name_layers}` SET `name` = %s, `basemap` = %s, `layerzoom` = %d, `mapwidth` = %d, `mapwidthunit` = %s, `mapheight` = %d, `panel` = %d, `layerviewlat` = %s, `layerviewlon` = %s, `createdby` = %s, `createdon` = %s, `updatedby` = %s, `updatedon` = %s, `controlbox` = %d, `overlays_custom` = %s, `overlays_custom2` = %s, `overlays_custom3` = %s, `overlays_custom4` = %s, `wms` = %d, `wms2` = %d, `wms3` = %d, `wms4` = %d, `wms5` = %d, `wms6` = %d, `wms7` = %d, `wms8` = %d, `wms9` = %d, `wms10` = %d, `listmarkers` = %d, `multi_layer_map` = %d, `multi_layer_map_list` = %s, `address` = %s, `clustering` = %d, `gpx_url` = %s, `gpx_panel` = %d WHERE `id` = %d", $name, $basemap, $layerzoom, $mapwidth, $mapwidthunit, $mapheight, $panel, str_replace(',', '.', $layerviewlat), str_replace(',', '.', $layerviewlon), $createdby, $createdon, $updatedby, $updatedon, $controlbox, $overlays_custom, $overlays_custom2, $overlays_custom3, $overlays_custom4, $wms, $wms2, $wms3, $wms4, $wms5, $wms6, $wms7, $wms8, $wms9, $wms10, $listmarkers, $multi_layer_map, $multi_layer_map_list, $address, $clustering, $gpx_url, $gpx_panel, $existing_layer_data['id']);
