From dfdacc5bf75fed3a5a124d16152f50c997b8b43f Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Tue, 5 Apr 2016 13:32:17 -0400
Subject: [PATCH] Adding settings for pdf

Add pdf_logo
Add footer_text
---
 index.php                                       |  2 +-
 ...e_V0.0.9.sql => create_database_V0.0.10.sql} |  2 +-
 setup/databaseScripts/dbVersions.php            |  1 +
 .../databaseScripts/update_database_V0.0.10.sql | 17 +++++++++++++++++
 views/admin/management/events.html              | 17 +++++++++++++++--
 5 files changed, 35 insertions(+), 4 deletions(-)
 rename setup/databaseScripts/{create_database_V0.0.9.sql => create_database_V0.0.10.sql} (99%)
 create mode 100644 setup/databaseScripts/update_database_V0.0.10.sql

diff --git a/index.php b/index.php
index 187bdf9..a123fa6 100644
--- a/index.php
+++ b/index.php
@@ -39,7 +39,7 @@
  *  version from this plugin.
  */
 define('GLM_MEMBERS_EVENTS_PLUGIN_VERSION', '0.0.1');
-define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.0.9');
+define('GLM_MEMBERS_EVENTS_PLUGIN_DB_VERSION', '0.0.10');
 
 // This is the minimum version of the GLM Members DB plugin require for this plugin.
 define('GLM_MEMBERS_EVENTS_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '1.0.58');
diff --git a/setup/databaseScripts/create_database_V0.0.9.sql b/setup/databaseScripts/create_database_V0.0.10.sql
similarity index 99%
rename from setup/databaseScripts/create_database_V0.0.9.sql
rename to setup/databaseScripts/create_database_V0.0.10.sql
index e653f17..9dde6be 100644
--- a/setup/databaseScripts/create_database_V0.0.9.sql
+++ b/setup/databaseScripts/create_database_V0.0.10.sql
@@ -160,7 +160,7 @@ CREATE TABLE {prefix}management (
   id INT NOT NULL AUTO_INCREMENT,
   canonical_event_page TINYTEXT NULL, -- Canonical page slug for event detail
   pdf_logo TINYTEXT NULL,             -- Image for the Top of the PDF
-  footer_texit TINYTEXT NULL,         -- Image for the Top of the PDF
+  footer_text TINYTEXT NULL,          -- Image for the Top of the PDF
   PRIMARY KEY (id)
 );
 
diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php
index 3a8ef3b..0a9f83d 100644
--- a/setup/databaseScripts/dbVersions.php
+++ b/setup/databaseScripts/dbVersions.php
@@ -23,5 +23,6 @@ $glmMembersEventsDbVersions = array(
     '0.0.7' => array('version' => '0.0.7', 'tables' => 7),
     '0.0.8' => array('version' => '0.0.8', 'tables' => 7),
     '0.0.9' => array('version' => '0.0.9', 'tables' => 7),
+    '0.0.10' => array('version' => '0.0.10', 'tables' => 7),
 );
 
diff --git a/setup/databaseScripts/update_database_V0.0.10.sql b/setup/databaseScripts/update_database_V0.0.10.sql
new file mode 100644
index 0000000..471cb6c
--- /dev/null
+++ b/setup/databaseScripts/update_database_V0.0.10.sql
@@ -0,0 +1,17 @@
+-- Gaslight Media Members Database  - Events Add-On
+-- File Created: 12/09/14 15:27:15
+-- Database Version: 0.0.9
+-- Database Update From Previous Version Script
+-- 
+-- To permit each query below to be executed separately,
+-- all queries must be separated by a line with four dashses
+
+
+-- Add PDF logo
+ALTER TABLE {prefix}management ADD COLUMN pdf_logo TINYTEXT;
+
+----
+
+-- Add Footer Text 
+ALTER TABLE {prefix}management ADD COLUMN footer_text TINYTEXT;
+
diff --git a/views/admin/management/events.html b/views/admin/management/events.html
index 75003ee..65309ab 100644
--- a/views/admin/management/events.html
+++ b/views/admin/management/events.html
@@ -33,14 +33,27 @@
                         <tr>
                             <th {if $eventsSettings.fieldRequired.pdf_logo}class="glm-required"{/if}>Logo for Event PDF:</th>
                             <td {if $eventsSettings.fieldFail.pdf_logo}class="glm-form-bad-input glm-form-bad-input-misc"{/if}>
-                                <input type="file" name="pdf_logo" />
+                                <table>
+                                    {if $eventsSettings.fieldData.pdf_logo}
+                                    <tr>
+                                        <td>
+                                            <img src="{$glmPluginMediaUrl}/images/small/{$eventsSettings.fieldData.pdf_logo}">
+                                        </td>
+                                        <td>
+                                            <input type="checkbox" name="pdf_logo_delete">Delete PDF Logo<br>
+                                            {$eventsSettings.fieldData.pdf_logo}<br>
+                                        </td>
+                                    </tr>
+                                    {/if}
+                                </table>
+                                <input type="file" name="pdf_logo_new" />
                                 {if $eventsSettings.fieldFail.pdf_logo}<p>{$eventsSettings.fieldFail.pdf_logo}</p>{/if}
                             </td>
                         </tr>
                         <tr>
                             <th {if $eventsSettings.fieldRequired.footer_text}class="glm-required"{/if}>Footer text for PDF (no html or the PDF will break)</th>
                             <td {if $eventsSettings.fieldFail.footer_text}class="glm-form-bad-input glm-form-bad-input-misc"{/if}>
-                                <textarea rows="3" cols="90" name="footer_text" value="{$eventsSettings.fieldData.footer_text}"></textarea>
+                                <textarea rows="3" cols="90" name="footer_text">{$eventsSettings.fieldData.footer_text}</textarea>
                                 {if $eventsSettings.fieldFail.footer_text}<p>{$eventsSettings.fieldFail.footer_text}</p>{/if}
                             </td>
                         </tr>
-- 
2.17.1