From a6a1939fe799cddab37d2c18f339fbe2e11dae1f Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Mon, 13 May 2019 09:23:11 -0400
Subject: [PATCH] Updates for lat lon stuff

for verify lat lon
---
 models/admin/ajax/verifyLatLon.php            | 28 +++++++++----------
 .../management/import/checkLatLonData.php     | 18 ++++++++++--
 .../management/import/checkLatLonData.html    |  2 +-
 3 files changed, 31 insertions(+), 17 deletions(-)

diff --git a/models/admin/ajax/verifyLatLon.php b/models/admin/ajax/verifyLatLon.php
index e6eec6b8..3c5494e0 100644
--- a/models/admin/ajax/verifyLatLon.php
+++ b/models/admin/ajax/verifyLatLon.php
@@ -178,13 +178,13 @@ class GlmMembersAdmin_ajax_verifyLatLon
                             ),
                         );
                         // update the member info lat lon
-                        $this->wpdb->update(
-                            GLM_MEMBERS_PLUGIN_DB_PREFIX . 'member_info',
-                            array( 'lat' => $oldLat[$member['old_member_id']], 'lon' => $oldLon[$member['old_member_id']]),
-                            array( 'id' => $member['id'] ),
-                            array( '%f', '%f' ),
-                            array( '%d' )
-                        );
+                        // $this->wpdb->update(
+                        //     GLM_MEMBERS_PLUGIN_DB_PREFIX . 'member_info',
+                        //     array( 'lat' => $oldLat[$member['old_member_id']], 'lon' => $oldLon[$member['old_member_id']]),
+                        //     array( 'id' => $member['id'] ),
+                        //     array( '%f', '%f' ),
+                        //     array( '%d' )
+                        // );
                     }
                 }
 
@@ -193,13 +193,13 @@ class GlmMembersAdmin_ajax_verifyLatLon
                     $goodLon = true;
                 } else {
                     // update the member info lat lon
-                    $this->wpdb->update(
-                        GLM_MEMBERS_PLUGIN_DB_PREFIX . 'member_info',
-                        array( 'lat' => $oldLat[$member['old_member_id']], 'lon' => $oldLon[$member['old_member_id']]),
-                        array( 'id' => $member['id'] ),
-                        array( '%f', '%f' ),
-                        array( '%d' )
-                    );
+                    // $this->wpdb->update(
+                    //     GLM_MEMBERS_PLUGIN_DB_PREFIX . 'member_info',
+                    //     array( 'lat' => $oldLat[$member['old_member_id']], 'lon' => $oldLon[$member['old_member_id']]),
+                    //     array( 'id' => $member['id'] ),
+                    //     array( '%f', '%f' ),
+                    //     array( '%d' )
+                    // );
                 }
 
                 if ( $goodLat && $goodLon ) {
diff --git a/models/admin/management/import/checkLatLonData.php b/models/admin/management/import/checkLatLonData.php
index e6393dc7..ebb204d5 100644
--- a/models/admin/management/import/checkLatLonData.php
+++ b/models/admin/management/import/checkLatLonData.php
@@ -5,6 +5,9 @@ require_once GLM_MEMBERS_PLUGIN_CLASS_PATH . '/data/dataMemberInfo.php';
 // Set view file
 $requestedView = 'import/checkLatLonData.html';
 
+$start = 1;
+$limit = 10;
+
 // Create parts for the where clause
 $whereParts = array();
 $whereParts[] = 'T.lat IS NOT NULL';
@@ -27,8 +30,19 @@ $whereParts[] = " (
 // Setup where variable
 $where      = implode( ' AND ', $whereParts );
 $MemberData = new GlmDataMemberInfo( $this->wpdb, $this->config );
-$members    = $MemberData->getList( $where );
+$members    = $MemberData->getList(
+    $where,         // where
+    'member_name',  // order
+    true,           // fieldVals
+    'id',           // idField
+    $start,         // start
+    $limit          // limit
+);
+
+$stats = $MemberData->getStats( str_replace( 'T.', '', $where ) );
+echo '<pre>$stats: ' . print_r( $stats, true ) . '</pre>';
 
 // echo '<pre>$members: ' . print_r( $members, true ) . '</pre>';
 
-$templateData['members'] = $members;
+$templateData['members'] = $members['list'];
+$templateData['stats']   = $stats;
diff --git a/views/admin/management/import/checkLatLonData.html b/views/admin/management/import/checkLatLonData.html
index 594c973d..475a38da 100644
--- a/views/admin/management/import/checkLatLonData.html
+++ b/views/admin/management/import/checkLatLonData.html
@@ -49,7 +49,7 @@
     <script>
     jQuery(document).ready(function($) {
         var mapUrl = 'https://maps.googleapis.com/maps/api/geocode/json?address={$member.addr1|regex_replace:'[ ]':'+'},+{$member.city|regex_replace:'[ ]':'+'},+{$member.state.value}&key=AIzaSyBSZw7bDiqZLmMcha4jUiqQmrUPvUPCzLs';
-        //fetchLatLonData( mapUrl, {$member.id});
+        // fetchLatLonData( mapUrl, {$member.id});
     });
     </script>
 {/foreach}
-- 
2.17.1