From 14b5b1985565d3b38ab6f55458227f5c1da159df Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 13 Feb 2018 16:53:11 -0500
Subject: [PATCH] Temp for wmta member custom header images.

Pulling usemeta
---
 models/admin/management/import.php            |  4 +
 .../management/import/memberCustomImages.php  | 87 +++++++++++++++++++
 .../management/import/memberCustomImages.html | 27 ++++++
 views/admin/management/memberHeader.html      |  1 +
 4 files changed, 119 insertions(+)
 create mode 100644 models/admin/management/import/memberCustomImages.php
 create mode 100644 views/admin/management/import/memberCustomImages.html

diff --git a/models/admin/management/import.php b/models/admin/management/import.php
index 6ae80063..f8c4b9d1 100644
--- a/models/admin/management/import.php
+++ b/models/admin/management/import.php
@@ -186,6 +186,10 @@ class GlmMembersAdmin_management_import
                 $templateData['thisOption'] = $option;
                 break;
 
+            case 'memberCustomImages':
+                require GLM_MEMBERS_PLUGIN_PATH.'/models/admin/management/import/memberCustomImages.php';
+                break;
+
             default:
                 break;
 
diff --git a/models/admin/management/import/memberCustomImages.php b/models/admin/management/import/memberCustomImages.php
new file mode 100644
index 00000000..779cbb70
--- /dev/null
+++ b/models/admin/management/import/memberCustomImages.php
@@ -0,0 +1,87 @@
+<?php
+/**
+ * Import Member Images
+ */
+
+require_once GLM_MEMBERS_PLUGIN_PATH.'/models/admin/ajax/imageUpload.php';
+$ImageUpload = new GlmMembersAdmin_ajax_imageUpload($this->wpdb, $this->config);
+
+$requestedView = 'import/memberCustomImages.html';
+
+// Get a array of members
+$members = $this->wpdb->get_results(
+    "SELECT id,old_member_id,name
+       FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members
+      WHERE old_member_id IS NOT NULL",
+    ARRAY_A
+);
+
+$domain = get_site_url();
+$home_path = get_home_path();
+// echo '<pre>$members: ' . print_r( $members, true ) . '</pre>';
+foreach ( $members as $member ) {
+    echo '<pre>$member: ' . print_r( $member, true ) . '</pre>';
+    // Need to get the user id for this member
+    $user = get_user_by( 'login', $member['old_member_id'] );
+    // echo '<pre>$user: ' . print_r( $user, true ) . '</pre>';
+    $user_meta = get_user_meta( $user->ID, 'custom_header_image', true );
+    if ( $user_meta ) {
+        echo '<pre>$user_meta: ' . print_r( $user_meta, true ) . '</pre>';
+        $attachment = wp_get_attachment_image_src( $user_meta, 'large' );
+        echo '<pre>$attachment: ' . print_r( $attachment, true ) . '</pre>';
+        // Get relative path
+        $relative_url = str_replace( $domain, '', $attachment[0] );
+        $relative_url = substr( $relative_url, 1 );
+        $old_image_path = $home_path . $relative_url;
+        echo '<pre>$old_image_path: ' . print_r( $old_image_path, true ) . '</pre>';
+
+        $res = $ImageUpload->storeImage( $old_image_path );
+        if ( $res['newFileName'] ) {
+            $image = $res['newFileName'];
+        }
+        var_dump($image);
+        if ( $image ) {
+            // Need the member info id for adding to the images
+            $member_info_id = $this->wpdb->get_var(
+                $this->wpdb->prepare(
+                    "SELECT id
+                       FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX. "member_info
+                      WHERE member = %d",
+                    $member['id']
+                )
+            );
+            echo '<pre>$member_info_id: ' . print_r( $member_info_id, true ) . '</pre>';
+            // If we have good image then add it to the member profile images
+            // and mark it as featured image
+            if ( $member_info_id ) {
+                $this->wpdb->insert(
+                    GLM_MEMBERS_PLUGIN_DB_PREFIX . 'images',
+                    array(
+                        'name'      => $old_image_path,
+                        'status'    => 10,
+                        'featured'  => 1,
+                        'file_name' => $image,
+                        'position'  => 1,
+                        'ref_type'  => 20,
+                        'ref_dest'  => $member_info_id,
+                        'descr'     => '',
+                        'caption'   => ''
+                    ),
+                    array(
+                        '%s',
+                        '%d',
+                        '%s',
+                        '%s',
+                        '%d',
+                        '%d',
+                        '%d',
+                        '%s',
+                        '%s',
+                    )
+                );
+            } else {
+                echo '<pre>No member info id!!</pre>';
+            }
+        }
+    }
+}
diff --git a/views/admin/management/import/memberCustomImages.html b/views/admin/management/import/memberCustomImages.html
new file mode 100644
index 00000000..6dc7faa5
--- /dev/null
+++ b/views/admin/management/import/memberCustomImages.html
@@ -0,0 +1,27 @@
+{include file='admin/management/header.html'}
+    
+    <h2>Data Import - Test Database</h2>
+    <ol>
+        <li>Provide legacy database information and import member data.</li>
+        <li>Import any images.</li>
+        <li class="glm-ol-selected">Review results</li>
+    </ol>
+    
+
+    <h3>Data Import Step 3: Review Results.</h3>
+{if isset($genError)}    
+    <p>
+        <h3 class="glm-error">Oops!</h3>
+        <p class="glm-error">{$genError}</p>
+    </p>
+{/if}    
+
+    <h2>Process Complete</h2>
+    <p>
+        The data and image import process is complete. You should now have all member data and images imported.
+    <p>
+    <p>
+        You should now go to the "Member List" and make sure the data and images have been imported properly.
+    </p>                        
+    
+{include file='admin/footer.html'}
diff --git a/views/admin/management/memberHeader.html b/views/admin/management/memberHeader.html
index 90631b6d..fc51e0e4 100644
--- a/views/admin/management/memberHeader.html
+++ b/views/admin/management/memberHeader.html
@@ -3,5 +3,6 @@
     {if apply_filters( 'glm-members-customfields-active', false )}
         <a href="{$thisUrl}?page={$thisPage}&glm_action=import&option=customfields" class="nav-tab{if $thisOption == 'customfields'} nav-tab-active{/if}">Custom Fields</a>
     {/if}
+    <a href="{$thisUrl}?page={$thisPage}&glm_action=import&option=memberCustomImages" class="nav-tab{if $thisOption == 'memberCustomImages'} nav-tab-active{/if}">Member Custom Images</a>
 </h2>
 
-- 
2.17.1