1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687:
<?php
class WPGMapsImportExport{
public function __construct(){
}
public function export_map( $mapid = false ){
if( $mapid ){
global $wpdb;
$query = "SELECT * FROM `{$wpdb->prefix}wpgmza_maps` WHERE `id` = '$mapid'";
$results = $wpdb->get_row( $query, ARRAY_A );
$map_data = array();
foreach( $results as $key => $val ){
if( $key == 'other_settings' )
continue;
$map_data[$key] = $val;
}
$other_results = maybe_unserialize( $results['other_settings'] );
foreach( $other_results as $key => $val ){
$map_data['other_'.$key] = $val;
}
$fileName = $wpdb->prefix.'export_map_'.$mapid.'.csv';
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header('Content-Description: File Transfer');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename={$fileName}");
header("Expires: 0");
header("Pragma: public");
$fh = @fopen( 'php://output', 'w' );
fputcsv($fh, array_keys($map_data), ",", '"');
fputcsv($fh, $map_data, ",", '"');
fclose($fh);
exit();
} else {
global $wpdb;
$query = "SELECT * FROM `{$wpdb->prefix}wpgmza_maps`";
$results = $wpdb->get_results( $query, ARRAY_A );
$map_data = array();
$headerDisplayed = false;
foreach( $results as $key => $val ){
$map_data[$key] = $val;
}
$fileName = $wpdb->prefix.'export_maps.csv';
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header('Content-Description: File Transfer');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename={$fileName}");
header("Expires: 0");
header("Pragma: public");
$fh = @fopen( 'php://output', 'w' );
foreach( $map_data as $map ){
if( !$headerDisplayed ){
fputcsv($fh, array_keys($map), ",", '"');
$headerDisplayed = true;
}
fputcsv($fh, $map, ",", '"');
}
fclose($fh);
exit();
}
}
public function export_markers(){
global $wpdb;
global $wpgmza;
$fileName = $wpdb->prefix.'wpgmza.csv';
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header('Content-Description: File Transfer');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename={$fileName}");
header("Expires: 0");
header("Pragma: public");
$fh = @fopen( 'php://output', 'w' );
$query = "SELECT *, {$wpgmza->spatialFunctionPrefix}X(latlng) AS lat, {$wpgmza->spatialFunctionPrefix}Y(latlng) AS lng FROM `{$wpdb->prefix}wpgmza`";
$results = $wpdb->get_results( $query, ARRAY_A );
$headerDisplayed = false;
foreach ( $results as $data ) {
if ( !$headerDisplayed ) {
$keys = array_keys($data);
array_splice($keys, array_search('latlng', $keys), 1);
fputcsv($fh, $keys, ",", '"');
$headerDisplayed = true;
}
unset($data['latlng']);
fputcsv($fh, $data, ",", '"');
}
fclose($fh);
exit;
}
public function export_polygons(){
global $wpdb;
$query = "SELECT * FROM `{$wpdb->prefix}wpgmza_polygon`";
$results = $wpdb->get_results( $query, ARRAY_A );
$headerDisplayed = false;
$fileName = $wpdb->prefix.'wpgmza_polygons.csv';
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header('Content-Description: File Transfer');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename={$fileName}");
header("Expires: 0");
header("Pragma: public");
$fh = @fopen( 'php://output', 'w' );
foreach ( $results as $data ) {
if ( !$headerDisplayed ) {
fputcsv($fh, array_keys($data), ",", '"');
$headerDisplayed = true;
}
fputcsv($fh, $data, ",", '"');
}
fclose($fh);
exit;
}
public function export_polylines(){
global $wpdb;
$query = "SELECT * FROM `{$wpdb->prefix}wpgmza_polylines`";
$results = $wpdb->get_results( $query, ARRAY_A );
$headerDisplayed = false;
$fileName = $wpdb->prefix.'wpgmza_polylines.csv';
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header('Content-Description: File Transfer');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename={$fileName}");
header("Expires: 0");
header("Pragma: public");
$fh = @fopen( 'php://output', 'w' );
foreach ( $results as $data ) {
if ( !$headerDisplayed ) {
fputcsv($fh, array_keys($data), ",", '"');
$headerDisplayed = true;
}
fputcsv($fh, $data, ",", '"');
}
fclose($fh);
exit;
}
public function import_markers(){
set_time_limit(1200);
if (is_uploaded_file($_FILES['wpgmza_csvfile']['tmp_name'])) {
ini_set("auto_detect_line_endings", true);
global $wpdb;
global $wpgmza_tblname;
$handle = fopen($_FILES['wpgmza_csvfile']['tmp_name'], "r");
$header = fgetcsv($handle);
unset ($wpgmza_errormsg);
if ($header[0] != "id") { $wpgmza_errormsg = __("Header 1 should be 'id', not","wp-google-maps")." '$header[0]'<br />"; }
if ($header[1] != "map_id") { $wpgmza_errormsg .= __("Header 2 should be 'map_id', not","wp-google-maps")." '$header[1]'<br />"; }
if ($header[2] != "address") { $wpgmza_errormsg .= __("Header 3 should be 'address', not","wp-google-maps")." '$header[2]'<br />"; }
if ($header[3] != "description") { $wpgmza_errormsg .= __("Header 4 should be 'description', not","wp-google-maps")." '$header[3]'<br />"; }
if ($header[4] != "pic") { $wpgmza_errormsg .= __("Header 5 should be 'pic', not","wp-google-maps")." '$header[4]'<br />"; }
if ($header[5] != "link") { $wpgmza_errormsg .= __("Header 6 should be 'link', not","wp-google-maps")." '$header[5]'<br />"; }
if ($header[6] != "icon") { $wpgmza_errormsg .= __("Header 7 should be 'icon', not","wp-google-maps")." '$header[6]'<br />"; }
if ($header[7] != "lat") { $wpgmza_errormsg .= __("Header 8 should be 'lat', not","wp-google-maps")." '$header[7]'<br />"; }
if ($header[8] != "lng") { $wpgmza_errormsg .= __("Header 9 should be 'lng', not","wp-google-maps")." '$header[8]'<br />"; }
if ($header[9] != "anim") { $wpgmza_errormsg .= __("Header 10 should be 'anim', not","wp-google-maps")." '$header[9]'<br />"; }
if ($header[10] != "title") { $wpgmza_errormsg .= __("Header 11 should be 'title', not","wp-google-maps")." '$header[10]'<br />"; }
if ($header[11] != "infoopen") { $wpgmza_errormsg .= __("Header 12 should be 'infoopen', not","wp-google-maps")." '$header[11]'<br />"; }
if ($header[12] != "category") { $wpgmza_errormsg .= __("Header 13 should be 'category', not","wp-google-maps")." '$header[12]'<br />"; }
if ($header[13] != "approved") { $wpgmza_errormsg .= __("Header 14 should be 'approved', not","wp-google-maps")." '$header[13]'<br />"; }
if ($header[14] != "retina") { $wpgmza_errormsg .= __("Header 15 should be 'retina', not","wp-google-maps")." '$header[14]'<br />"; }
if (isset($wpgmza_errormsg)) {
echo "<div class='error below-h2'>".__("CSV import failed","wp-google-maps")."!<br /><br />$wpgmza_errormsg</div>";
}
else {
if (isset($_POST['wpgmza_geocode']) && $_POST['wpgmza_geocode'] == "Yes" && !$_POST['wpgmza_api_key']) {
echo '<div class="error below-h1">Please enter a Google Maps Geocoding API key</div>';
return;
} else {
update_option("wpgmza_geocode_api_key",$_POST['wpgmza_api_key']);
$lline = 0;
while(! feof($handle)){
if (isset($_POST['wpgmza_csvreplace']) && $_POST['wpgmza_csvreplace'] == "Yes") { $wpdb->query("TRUNCATE TABLE $wpgmza_tblname"); }
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$lline++;
if ( empty($data[7]) || empty($data[8]) ){
if (isset($_POST['wpgmza_geocode']) && $_POST['wpgmza_geocode'] == "Yes") {
if ( function_exists('curl_version') ) {
$googlekey = $_POST['wpgmza_api_key'];
if (!$googlekey) {
echo '<div class="error below-h1">Please enter a Google Maps Geocoding API key</div>';
return;
} else {
$address = utf8_encode( urlencode( $data[2] ) );
$url = "https://maps.googleapis.com/maps/api/geocode/json?sensor=true&key=". $googlekey ."&address=" . $address;
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($curl, CURLOPT_REFERER, $_SERVER['HTTP_HOST']);
curl_setopt($curl, CURLOPT_USERAGENT,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13');
$output = curl_exec($curl);
curl_close($curl);
if (empty($output)){
echo "No data from lookup: $url<br>";
continue;
} else {
}
$decoded = json_decode($output);
if ($decoded->status != "OK") { echo "Unable to get location data for <a href='$url'>" . $address . "</a> <br>"; var_dump($decoded); continue; }
$lat = $decoded->results[0]->geometry->location->lat;
$lng = $decoded->results[0]->geometry->location->lng;
echo "Lookup on address: " . $address . " decoded to: $lat, $lng<br>";
$data[7] = ! empty( $lat ) ? $lat : "";
$data[8] = ! empty( $lng ) ? $lng : "";
usleep(12000);
}
} else {
echo '<div class="error below-h2">curl is not installed; unable to lookup Google coordinates.</div>';
return;
}
} else {
echo "<div class=\"notice notice-error\">".sprintf(__("Cannot import line %d as the LAT and/or LNG is not defined.","wp-google-maps"),$lline)."</div>";
}
}
if ( ! empty($data[5]) && strpos($data[5], "http://")) $data[5] = "http://" . $data[5];
$ra = $wpdb->insert( $wpgmza_tblname, array(
$header[1] => $data[1],
$header[2] => $data[2],
$header[3] => $data[3],
$header[4] => $data[4],
$header[5] => $data[5],
$header[6] => $data[6],
$header[7] => $data[7],
$header[8] => $data[8],
$header[9] => $data[9],
$header[10] => $data[10],
$header[11] => $data[11],
$header[12] => $data[12],
$header[13] => $data[13],
$header[14] => $data[14]
)
);
}
}
fclose($handle);
}
$wpdb->query("UPDATE $wpgmza_tblname SET latlng=PointFromText(
CONCAT('POINT(', lat, ' ', lng, ')')
)");
echo "<div class='updated'>".__("Your CSV file has been successfully imported","wp-google-maps")."</div>";
}
}
}
public function import_maps(){
global $wpdb;
if (is_uploaded_file($_FILES['wpgmza_csv_map_import']['tmp_name'])) {
ini_set("auto_detect_line_endings", true);
$handle = fopen($_FILES['wpgmza_csv_map_import']['tmp_name'], "r");
$header = fgetcsv($handle);
$array_data = array();
$values = array();
$the_array = array();
$joint = array();
$other_settings_array = array();
$modified_other_settings = array();
$header_array = array();
while(! feof( $handle ) ){
while ( ( $data = fgetcsv( $handle, 1000, "," ) ) !== FALSE ){
$array_data[] = $data;
}
}
foreach( $header as $head => $er ){
$header_array[$er] = '';
}
$cnt = 0;
foreach( $array_data as $map_data ){
foreach( $map_data as $key => $val ){
$values[] = $val;
}
foreach( $header_array as $head_key => $head_value ){
$the_array[$head_key] = $values[$cnt];
$cnt++;
}
$joint[] = $the_array;
}
$array_size = count( $the_array );
$replace_current_map_data = false;
if (isset($_POST['wpgmza_csvreplace_map']) && $_POST['wpgmza_csvreplace_map'] == "Yes" ) {
$replace_current_map_data = true;
}
if( $replace_current_map_data ){
$wpdb->query("TRUNCATE TABLE `".$wpdb->prefix."wpgmza_maps`");
}
foreach( $joint as $join ){
$sql = "";
$sql .= "INSERT INTO `".$wpdb->prefix."wpgmza_maps` SET ";
$tmp_cnt = 0;
foreach( $join as $key => $val ){
if( !$replace_current_map_data ){
if( $key == 'id' ){
$sql .= "";
} else {
$tmp_cnt++;
if ($tmp_cnt == 1) {
$sql .= "`$key` = '$val' ";
} else {
$sql .= ",`$key` = '$val' ";
}
}
} else {
$tmp_cnt++;
if ($tmp_cnt == 1) {
$sql .= "`$key` = '$val' ";
} else {
$sql .= ",`$key` = '$val' ";
}
}
}
echo $sql;
$wpdb->Query($sql);
}
}
echo "<div class='updated'>".__("Your CSV file has been successfully imported","wp-google-maps")."</div>";
}
public function import_polylines(){
global $wpdb;
if (is_uploaded_file($_FILES['wpgmza_csv_polylines_import']['tmp_name'])) {
ini_set("auto_detect_line_endings", true);
$handle = fopen($_FILES['wpgmza_csv_polylines_import']['tmp_name'], "r");
$header = fgetcsv($handle);
$array_data = array();
$values = array();
$the_array = array();
$joint = array();
$header_array = array();
while(! feof( $handle ) ){
while ( ( $data = fgetcsv( $handle, 1000, "," ) ) !== FALSE ){
$array_data[] = $data;
}
}
foreach( $header as $head => $er ){
$header_array[$er] = '';
}
$cnt = 0;
foreach( $array_data as $map_data ){
foreach( $map_data as $key => $val ){
$values[] = $val;
}
foreach( $header_array as $head_key => $head_value ){
$the_array[$head_key] = $values[$cnt];
$cnt++;
}
$joint[] = $the_array;
}
$replace_current_map_data = false;
if (isset($_POST['wpgmza_csvreplace_polyline']) && $_POST['wpgmza_csvreplace_polyline'] == "Yes" ) { $replace_current_map_data = true; }
if( $replace_current_map_data ){ $wpdb->query("TRUNCATE TABLE `".$wpdb->prefix."wpgmza_polylines`"); }
$array_size_count = 1;
foreach( $joint as $join ){
$sql = "";
$sql .= "INSERT INTO `".$wpdb->prefix."wpgmza_polylines` SET ";
$array_size = count( $join );
foreach( $join as $key => $val ){
if( $key == 'id' ){
$sql .= "";
} else {
if( $array_size_count == $array_size ){
$sql .= "`$key` = '$val' ";
} else {
$sql .= "`$key` = '$val', ";
}
}
$array_size_count++;
}
$wpdb->Query($sql);
$array_size_count = 1;
}
}
echo "<div class='updated'>".__("Your CSV file has been successfully imported","wp-google-maps")."</div>";
}
public function import_polygons(){
global $wpdb;
if (is_uploaded_file($_FILES['wpgmza_csv_polygons_import']['tmp_name'])) {
ini_set("auto_detect_line_endings", true);
$handle = fopen($_FILES['wpgmza_csv_polygons_import']['tmp_name'], "r");
$header = fgetcsv($handle);
$array_data = array();
$values = array();
$the_array = array();
$joint = array();
$header_array = array();
while(! feof( $handle ) ){
while ( ( $data = fgetcsv( $handle, 1000, "," ) ) !== FALSE ){
$array_data[] = $data;
}
}
foreach( $header as $head => $er ){
$header_array[$er] = '';
}
$cnt = 0;
foreach( $array_data as $map_data ){
foreach( $map_data as $key => $val ){
$values[] = $val;
}
foreach( $header_array as $head_key => $head_value ){
$the_array[$head_key] = $values[$cnt];
$cnt++;
}
$joint[] = $the_array;
}
$replace_current_map_data = false;
if (isset($_POST['wpgmza_csvreplace_polygon']) && $_POST['wpgmza_csvreplace_polygon'] == "Yes" ) { $replace_current_map_data = true; }
if( $replace_current_map_data ){ $wpdb->query("TRUNCATE TABLE `".$wpdb->prefix."wpgmza_polygon`"); }
$array_size_count = 1;
foreach( $joint as $join ){
$sql = "";
$sql .= "INSERT INTO `".$wpdb->prefix."wpgmza_polygon` SET ";
$array_size = count( $join );
foreach( $join as $key => $val ){
if( $key == 'id' ){
$sql .= "";
} else {
if( $array_size_count == $array_size ){
$sql .= "`$key` = '$val' ";
} else {
$sql .= "`$key` = '$val', ";
}
}
$array_size_count++;
}
$wpdb->Query($sql);
$array_size_count = 1;
}
}
echo "<div class='updated'>".__("Your CSV file has been successfully imported","wp-google-maps")."</div>";
}
}