From df1d1b69cd63d04a33c216b381caa8e7bd9bd3ab Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 1 May 2018 16:36:24 -0400
Subject: [PATCH] Add update for member contact access

Update 2017 and 2018 member to display not moderated.
---
 models/admin/migcsa/index.php          | 39 ++++++++++++++++++++++++++
 views/admin/migcsa/index.html          |  2 ++
 views/admin/migcsa/memberContacts.html |  6 ++++
 3 files changed, 47 insertions(+)
 create mode 100644 views/admin/migcsa/memberContacts.html

diff --git a/models/admin/migcsa/index.php b/models/admin/migcsa/index.php
index d6289db..beff5c1 100644
--- a/models/admin/migcsa/index.php
+++ b/models/admin/migcsa/index.php
@@ -144,6 +144,10 @@ class GlmMembersAdmin_migcsa_index
             $view     = 'memberTypes';
             $response = $this->updateMemberTypes();
             break;
+        case 'updateMemberContacts':
+            $view     = 'memberContacts';
+            $response = $this->updateMemberContacts();
+            break;
         case 'customFields':
             $view     = 'customFields';
             $response = $this->importCustomFields();
@@ -183,6 +187,41 @@ class GlmMembersAdmin_migcsa_index
 
     }
 
+    public function updateMemberContacts()
+    {
+         $sql = "
+        SELECT member_id,member_name,process_email
+          FROM member
+         WHERE member_id IN (SELECT member_id
+                               FROM member_category
+                              WHERE category_id IN (40,42))";
+        $stmt    = $this->dbh->query( $sql );
+        $members = $stmt->fetchAll();
+
+        // $this->wpdb->query('START TRANSACTION');
+        foreach ( $members as $m ) {
+            $ref_dest = $this->wpdb->get_var(
+                $this->wpdb->prepare(
+                    "SELECT id
+                       FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX  . "members
+                      WHERE old_member_id = %d",
+                    $m['member_id']
+                )
+            );
+            if ( $ref_dest ) {
+                echo '<pre>$ref_dest: ' . print_r( $ref_dest, true ) . '</pre>';
+                $this->wpdb->update(
+                    GLM_MEMBERS_CONTACTS_PLUGIN_DB_PREFIX . 'contacts',
+                    array( 'access' => 40 ),
+                    array( 'ref_dest' => $ref_dest )
+                );
+            }
+        }
+        // $this->wpdb->query('ROLLBACK');
+        // $this->wpdb->query('COMMIT');
+        return '<pre>$members: ' . print_r( $members, true ) . '</pre>';
+    }
+
     public function importCustomFields()
     {
         $response = '';
diff --git a/views/admin/migcsa/index.html b/views/admin/migcsa/index.html
index 27d3bcc..2f92a6b 100644
--- a/views/admin/migcsa/index.html
+++ b/views/admin/migcsa/index.html
@@ -8,3 +8,5 @@
 <a href="{$thisUrl}?page={$thisPage}&option=employees">Import Employees</a>
 <br />
 <a href="{$thisUrl}?page={$thisPage}&option=updateMemberTypes">Update Member Types</a>
+<br />
+<a href="{$thisUrl}?page={$thisPage}&option=updateMemberContacts">Update Member Contacts</a>
diff --git a/views/admin/migcsa/memberContacts.html b/views/admin/migcsa/memberContacts.html
new file mode 100644
index 0000000..8b1e370
--- /dev/null
+++ b/views/admin/migcsa/memberContacts.html
@@ -0,0 +1,6 @@
+<h2>Update Member Contacts</h2>
+
+{if $response}
+    {$response}
+{/if}
+
-- 
2.17.1