From 2a2aab2e84f7d8f814b15ed209463083a6123142 Mon Sep 17 00:00:00 2001
From: Anthony Talarico <talarico@gaslightmedia.com>
Date: Tue, 28 Nov 2017 09:50:40 -0500
Subject: [PATCH] fixing the member name dropdowns

adding new id to the import script so that the member dropdowns are correctly
populated in the edit view
---
 models/admin/management/itemsImport.php | 9 +++++++--
 setup/shortcodes.php                    | 2 +-
 views/admin/forSale/edit.html           | 2 +-
 3 files changed, 9 insertions(+), 4 deletions(-)

diff --git a/models/admin/management/itemsImport.php b/models/admin/management/itemsImport.php
index e7cdb5c..45e732c 100644
--- a/models/admin/management/itemsImport.php
+++ b/models/admin/management/itemsImport.php
@@ -111,7 +111,10 @@ class GlmMembersAdmin_management_itemsImport
 
             
             case 'importItems':
+                global $wpdb;
                 $table = GLM_MEMBERS_FOR_SALE_PLUGIN_DB_PREFIX . 'items';
+                $members_table  = GLM_MEMBERS_PLUGIN_DB_PREFIX . 'members';
+                
                 require_once GLM_MEMBERS_PLUGIN_PATH.'/models/admin/ajax/imageUpload.php';
                 $ImageUpload = new GlmMembersAdmin_ajax_imageUpload($this->wpdb, $this->config);
 
@@ -137,7 +140,9 @@ class GlmMembersAdmin_management_itemsImport
                     $forsale = $stmt->fetchAll(PDO::FETCH_ASSOC);
                    $count = 0;
                     foreach($forsale as $key=>$value){
-
+                        $sql = "SELECT id FROM $members_table WHERE old_member_id = " . $value['member'];
+                        $new_id = $wpdb->get_var($sql);
+                        
                         $parts = false;
                         $res = false;
                         $image_1 = false;
@@ -193,7 +198,7 @@ class GlmMembersAdmin_management_itemsImport
                                 'terms'             =>$value['terms'],
                                 'post_date'         =>$value['ds'],
                                 'updated'           =>$value['ds'],
-                                'member'            =>$value['member'],
+                                'member'            =>$new_id,
                                 'image_1'           =>$image_1['newFileName'],
                                 'image_2'           =>$image_2['newFileName'],
                                 'image_3'           =>$image_3['newFileName'],
diff --git a/setup/shortcodes.php b/setup/shortcodes.php
index 198c6f4..d923a3f 100644
--- a/setup/shortcodes.php
+++ b/setup/shortcodes.php
@@ -94,7 +94,7 @@
         'table'      => false,
         'attributes' => array(
             'id'         => false,
-            'member_only' => false
+            'member_only' => false,
         )
     ),
     'glm-members-for-sale-detail' => array(
diff --git a/views/admin/forSale/edit.html b/views/admin/forSale/edit.html
index 269b62c..bb18fb3 100644
--- a/views/admin/forSale/edit.html
+++ b/views/admin/forSale/edit.html
@@ -98,7 +98,7 @@
         </div>
         {else}
         <!-- hidden MEMBER ID field here -->
-        <input type="hidden" name="member" value="{$item.fieldData.member.value}">
+        <input type="hidden" name="member" value="{$memberID}">
         {/if}
 
         <!-- COMPANY -->
-- 
2.17.1