From b5d2ea3b8b083ff870cea9318cbc0e2d2e741c77 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Wed, 4 Mar 2015 09:01:58 -0500
Subject: [PATCH] Adding the package pages for stay play and golf specials.

Stay play pulls from all in member category 9
Golf special pulls from all in member category 5
---
 Toolkit/Members/PackageList.php           | 21 ++++++++-
 Toolkit/Members/templates/packageList.tpl |  2 +-
 static/15.phtml                           | 57 +++++++++++++++++++++++
 static/8.phtml                            | 57 +++++++++++++++++++++++
 4 files changed, 135 insertions(+), 2 deletions(-)
 create mode 100644 static/15.phtml
 create mode 100644 static/8.phtml

diff --git a/Toolkit/Members/PackageList.php b/Toolkit/Members/PackageList.php
index 1870d19..4019c9a 100644
--- a/Toolkit/Members/PackageList.php
+++ b/Toolkit/Members/PackageList.php
@@ -291,7 +291,7 @@ class Toolkit_Members_PackageList
         return $packages;
     }
 
-    public function setPackageType()
+    public function setPackageType($memberCategory = null)
     {
         $sql = "
         SELECT m.*,c.city_name as city,s.state_abb as state,
@@ -304,6 +304,25 @@ class Toolkit_Members_PackageList
                SELECT member_id
                  FROM member_packages
                 WHERE current_date BETWEEN sdate and edate)";
+        if ($memberCategory) {
+            $catTree = Toolkit_Common::getHierarchicalTreeStructure(
+                Toolkit_Database::getInstance(),
+                'category',
+                'category_id',
+                'parent_id',
+                'pos',
+                $memberCategory
+            );
+            if (!empty($catTree)) {
+                $subCats = "
+                OR category_id IN (".implode(', ', array_keys($catTree)).")";
+            }
+            $sql .= " AND member_id IN (
+                        SELECT member_id
+                        FROM member_category
+                        WHERE category_id = {$memberCategory}
+                            $subCats)";
+        }
         parent::setQuery($sql);
     }
 
diff --git a/Toolkit/Members/templates/packageList.tpl b/Toolkit/Members/templates/packageList.tpl
index 119eb18..1522bc1 100644
--- a/Toolkit/Members/templates/packageList.tpl
+++ b/Toolkit/Members/templates/packageList.tpl
@@ -1,7 +1,7 @@
 
 {if:numberedSet}
 
-<div flexy:foreach="recordSet,k,row" class="search-result-item vcard pItem">
+<div flexy:foreach="recordSet,k,row" class="search-result-item vcard pItem small-12 columns">
     <h2><a href="{row[url]:h}">{row[member_name]:h}</a></h2>
     <div class="memberSR">
     {if:row[logo]}
diff --git a/static/15.phtml b/static/15.phtml
new file mode 100644
index 0000000..123efd4
--- /dev/null
+++ b/static/15.phtml
@@ -0,0 +1,57 @@
+<?php
+$conf = new Config;
+$root =& $conf->parseConfig(
+    BASE . 'Toolkit/Members/config.ini',
+    'IniFile'
+);
+if (isset($_GET['member_id']) && is_numeric($_GET['member_id'])) {
+    $out = '<style type="text/css">
+        #category {display:none;}
+        .listing {display:none;}
+        </style>';
+    try {
+        $profileCreator = new Toolkit_Members_ProfilePage(
+            Toolkit_Database::getInstance(),
+            $this->pageGateway,
+            $_GET['member_id']
+        );
+
+        $tEngine = new HTML_Template_Flexy(
+            Toolkit_Members::getFlexyOptions()
+        );
+
+        $profileWriter = new Toolkit_Members_ProfileWriter(
+            new Cache_Lite(Toolkit_Members::getCacheOptions()),
+            $tEngine
+        );
+
+        $profileWriter->setTemplate('memberDetail.tpl');
+        $profileWriter->attach(
+        new Toolkit_Members_Exposure(
+            $profileCreator->getMemberId(),
+            'detail'
+            )
+        );
+
+        $profileCreator->setCatid($_GET['member_id']);
+        $profileCreator->setConfig($root);
+        $profileCreator->setImagePath(MEMBER_RESIZED);
+
+        $out .= $profileWriter->toHtml($profileCreator);
+        echo $out;
+    } catch (PEAR_Exception $e) {
+        return Toolkit_Common::handleError($e);
+    }
+} else {
+    $packages = new Toolkit_Members_PackageList(
+        Toolkit_Database::getInstance()
+    );
+    $packages->setPackageType(5);
+    $packages->setDefaultSort(array('member_name' => 'ASC'));
+    $rEngine = new Structures_DataGrid_Renderer_Flexy();
+    $tEngine = new HTML_Template_Flexy(
+        Toolkit_Members::getFlexyOptions()
+    );
+    $rEngine->setContainer($tEngine);
+    echo $packages->toHtml($rEngine);
+}
diff --git a/static/8.phtml b/static/8.phtml
new file mode 100644
index 0000000..4a7ae60
--- /dev/null
+++ b/static/8.phtml
@@ -0,0 +1,57 @@
+<?php
+$conf = new Config;
+$root =& $conf->parseConfig(
+    BASE . 'Toolkit/Members/config.ini',
+    'IniFile'
+);
+if (isset($_GET['member_id']) && is_numeric($_GET['member_id'])) {
+    $out = '<style type="text/css">
+        #category {display:none;}
+        .listing {display:none;}
+        </style>';
+    try {
+        $profileCreator = new Toolkit_Members_ProfilePage(
+            Toolkit_Database::getInstance(),
+            $this->pageGateway,
+            $_GET['member_id']
+        );
+
+        $tEngine = new HTML_Template_Flexy(
+            Toolkit_Members::getFlexyOptions()
+        );
+
+        $profileWriter = new Toolkit_Members_ProfileWriter(
+            new Cache_Lite(Toolkit_Members::getCacheOptions()),
+            $tEngine
+        );
+
+        $profileWriter->setTemplate('memberDetail.tpl');
+        $profileWriter->attach(
+        new Toolkit_Members_Exposure(
+            $profileCreator->getMemberId(),
+            'detail'
+            )
+        );
+
+        $profileCreator->setCatid($_GET['member_id']);
+        $profileCreator->setConfig($root);
+        $profileCreator->setImagePath(MEMBER_RESIZED);
+
+        $out .= $profileWriter->toHtml($profileCreator);
+        echo $out;
+    } catch (PEAR_Exception $e) {
+        return Toolkit_Common::handleError($e);
+    }
+} else {
+    $packages = new Toolkit_Members_PackageList(
+        Toolkit_Database::getInstance()
+    );
+    $packages->setPackageType(9);
+    $packages->setDefaultSort(array('member_name' => 'ASC'));
+    $rEngine = new Structures_DataGrid_Renderer_Flexy();
+    $tEngine = new HTML_Template_Flexy(
+        Toolkit_Members::getFlexyOptions()
+    );
+    $rEngine->setContainer($tEngine);
+    echo $packages->toHtml($rEngine);
+}
-- 
2.17.1