From 764e657402fe064e374ab2d3e6ad2d7c88c5a508 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Mon, 30 Apr 2018 16:03:16 -0400
Subject: [PATCH] Update renewal dates

Update all accounts with their renewal dates.
---
 models/admin/migcsa/index.php        | 31 ++++++++++++++++++++++++++++
 views/admin/migcsa/index.html        |  2 +-
 views/admin/migcsa/renewalDates.html |  6 ++++++
 3 files changed, 38 insertions(+), 1 deletion(-)
 create mode 100644 views/admin/migcsa/renewalDates.html

diff --git a/models/admin/migcsa/index.php b/models/admin/migcsa/index.php
index 3072665..d6289db 100644
--- a/models/admin/migcsa/index.php
+++ b/models/admin/migcsa/index.php
@@ -156,6 +156,12 @@ class GlmMembersAdmin_migcsa_index
             $view     = 'employees';
             $response = $this->importEmployees();
             break;
+
+        case 'renewalDates':
+            $view     = 'renewalDates';
+            $response = $this->updateRenawalDates();
+            break;
+
         case 'list':
             $view = 'index';
             break;
@@ -184,6 +190,31 @@ class GlmMembersAdmin_migcsa_index
         return $response;
     }
 
+    public function updateRenawalDates()
+    {
+        $sql = "
+        SELECT member_id,renew_date
+          FROM member
+         WHERE renew_date IS NOT NULL
+           AND renew_date >= '01/01/2016'";
+        $stmt    = $this->dbh->query( $sql );
+        $members = $stmt->fetchAll();
+        $this->wpdb->query('START TRANSACTION');
+        foreach ( $members as $m ) {
+            $this->wpdb->query(
+                "UPDATE " . GLM_MEMBERS_BILLING_PLUGIN_DB_PREFIX . "accounts
+                    SET renewal_date = '" . $m['renew_date']  . "'
+                  WHERE ref_dest = (
+                        SELECT id
+                          FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members
+                         WHERE old_member_id = " . $m['member_id'] . " )"
+            );
+        }
+        $this->wpdb->query('COMMIT');
+        return '<pre>$members: ' . print_r( $members, true ) . '</pre>';
+
+    }
+
     public function updateMemberTypes()
     {
         $total_members    = 0;
diff --git a/views/admin/migcsa/index.html b/views/admin/migcsa/index.html
index d33f1a4..27d3bcc 100644
--- a/views/admin/migcsa/index.html
+++ b/views/admin/migcsa/index.html
@@ -3,7 +3,7 @@
 
 <a href="{$thisUrl}?page={$thisPage}&option=import">Import Members</a>
 <br />
-<a href="{$thisUrl}?page={$thisPage}&option=customFields">Import Custom Fields</a>
+<a href="{$thisUrl}?page={$thisPage}&option=renewalDates">Update Renewal Dates</a>
 <br />
 <a href="{$thisUrl}?page={$thisPage}&option=employees">Import Employees</a>
 <br />
diff --git a/views/admin/migcsa/renewalDates.html b/views/admin/migcsa/renewalDates.html
new file mode 100644
index 0000000..d952841
--- /dev/null
+++ b/views/admin/migcsa/renewalDates.html
@@ -0,0 +1,6 @@
+<h2>Update Renewal Dates</h2>
+
+{if $response}
+    {$response}
+{/if}
+
-- 
2.17.1