From 6a57009eb41c06ab6f5549c6d92a38978a059645 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Fri, 18 Mar 2016 16:11:21 -0400
Subject: [PATCH] Adding part to grab images

This will need some more work
The entire import needs work there are more than one version of the
events database and discoverkalamazoo is an older setup.
Fields will be different based on what version of events they were
using.
---
 js/front.js                        |  4 +++
 models/admin/management/events.php | 40 ++++++++++++++++++++++++++++--
 views/admin/management/events.html |  1 +
 3 files changed, 43 insertions(+), 2 deletions(-)

diff --git a/js/front.js b/js/front.js
index 48cbd40..4a5dfbf 100644
--- a/js/front.js
+++ b/js/front.js
@@ -15,6 +15,10 @@ var EventFront = {
             jQuery(this).toggleClass('open');
             console.log(jQuery(this).find('.event-content'));
         });
+        jQuery(".glm-read-more").click(function(){
+            this.preventDefault();
+            return false;
+        });
     }
 };
 
diff --git a/models/admin/management/events.php b/models/admin/management/events.php
index c77b1fa..bfa5f42 100644
--- a/models/admin/management/events.php
+++ b/models/admin/management/events.php
@@ -109,6 +109,36 @@ class GlmMembersAdmin_management_events extends GlmDataEventsManagement
 
     }
 
+    public function importEventImages()
+    {
+        require_once(GLM_MEMBERS_PLUGIN_PATH.'/models/admin/ajax/imageUpload.php');
+        $ImageUpload = new GlmMembersAdmin_ajax_imageUpload($this->wpdb, $this->config);
+        // get all events with images
+        $sql = "
+        SELECT id,image,old_event_id
+          FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX. "events
+         WHERE image != '' AND image IS NOT NULL";
+        $results = $this->wpdb->get_results($sql, ARRAY_A);
+        echo '<pre>$results: ' . print_r($results, true) . '</pre>';
+        $imgUrl = 'http://is0.gaslightmedia.com/discoverkalamazoo/CKImage/';
+        foreach ( $results as $event ) {
+            $imageFullUrl = $imgUrl . $event['image'];
+            $res = $ImageUpload->storeImage($imageFullUrl);
+
+            if ( $res['newFileName'] ) {
+                $this->wpdb->update(
+                    GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . 'events',
+                    array(
+                        'image' => $res['newFileName']
+                    ),
+                    array( 'id' => $event['id'] ),
+                    array( '%s' ),
+                    array( '%d' )
+                );
+            }
+        }
+    }
+
     /**
      * modelAction
      *
@@ -153,6 +183,12 @@ class GlmMembersAdmin_management_events extends GlmDataEventsManagement
 
                 break;
 
+            case 'eventImagesImport':
+
+                $this->importEventImages();
+
+                break;
+
             case 'eventimport':
 
                 $import = false;
@@ -581,7 +617,7 @@ class GlmMembersAdmin_management_events extends GlmDataEventsManagement
                             'name'     => $event['header'],
                             'intro'    => $intro,
                             'descr'    => $event['descr'],
-                            'image'    => $event['image'],
+                            'image'    => $event['img'],
                             'cost'     => $event['cost'],
                             'url'      => $event['url'],
                         ),
@@ -612,7 +648,7 @@ class GlmMembersAdmin_management_events extends GlmDataEventsManagement
                             'name'     => $event['header'],
                             'intro'    => $intro,
                             'descr'    => $event['descr'],
-                            'image'    => $event['image'],
+                            'image'    => $event['img'],
                             'cost'     => $event['cost'],
                             'url'      => $event['url'],
                             'old_event_id' => $event['id']
diff --git a/views/admin/management/events.html b/views/admin/management/events.html
index 0114dcf..0b32cb7 100644
--- a/views/admin/management/events.html
+++ b/views/admin/management/events.html
@@ -69,6 +69,7 @@
             </td>
         </tr>
   {else}
+        <tr><td><a href="{$thisUrl}?page={$thisPage}&glm_action=events&option=eventImagesImport">Import Event Images</a></td></tr>
         <tr>
             <td colspan="2">
                 <form action="{$thisUrl}">
-- 
2.17.1