From 8a1890b2cd8a863e80df16962a6d6352fe9a0213 Mon Sep 17 00:00:00 2001
From: "vincent@cubedesigners.com"
 <vincent@cubedesigners.com@f5622870-0f3c-0410-866d-9cb505b7a8ef>
Date: Fri, 3 Jan 2020 14:00:46 +0000
Subject: [PATCH] fix #3299 @0.5

---
 .../views/helpers/CaseStudiesGrid.php         | 28 +++++++++++--------
 1 file changed, 17 insertions(+), 11 deletions(-)

diff --git a/framework/application/views/helpers/CaseStudiesGrid.php b/framework/application/views/helpers/CaseStudiesGrid.php
index 04d818f..3ccf1df 100644
--- a/framework/application/views/helpers/CaseStudiesGrid.php
+++ b/framework/application/views/helpers/CaseStudiesGrid.php
@@ -1,12 +1,14 @@
 <?php
 
-class Cubedesigners_View_Helper_CaseStudiesGrid extends CubeIT_View_Helper_Abstract {
+class Cubedesigners_View_Helper_CaseStudiesGrid extends CubeIT_View_Helper_Abstract
+{
 
     protected $_tags;
     protected $_page_data;
     protected $_counter = 0;
 
-    public function caseStudiesGrid($limit = 3, $exclude_ID = null) {
+    public function caseStudiesGrid($limit = 3, $exclude_ID = null)
+    {
 
         $this->addScriptAndStyle('casestudies_grid');
 
@@ -15,7 +17,10 @@ class Cubedesigners_View_Helper_CaseStudiesGrid extends CubeIT_View_Helper_Abstr
 
         $db = Zend_Db_Table::getDefaultAdapter();
         $select = $db->select()->from('casestudies')
-                               ->order('RAND()');
+            ->order('RAND()');
+        if (!Bootstrap::getInstance()->isAllowed("edition")) {
+            $select->where('online = ?', 1);
+        }
 
         if ($exclude_ID) {
             $select->where('id != ?', $exclude_ID);
@@ -37,7 +42,8 @@ class Cubedesigners_View_Helper_CaseStudiesGrid extends CubeIT_View_Helper_Abstr
         return $res;
     }
 
-    protected function _study($study) {
+    protected function _study($study)
+    {
 
         // Max display size is 512 but we over-sample the size by 20% because there is a CSS scale effect on hover
         $image = $this->view->imageProcess($study->visuel, $study->titre, 615, 615, ['class' => 'responsive casestudies-grid-item-image']);
@@ -50,15 +56,14 @@ class Cubedesigners_View_Helper_CaseStudiesGrid extends CubeIT_View_Helper_Abstr
         }
         */
 
-        $hover_style = empty($study->hover_color) ? '' : 'background-color:'. CubeIT_Util_Cms::hexToRGBA($study->hover_color, 0.75) .';';
+        $hover_style = empty($study->hover_color) ? '' : 'background-color:' . CubeIT_Util_Cms::hexToRGBA($study->hover_color, 0.75) . ';';
 
         $c = $image;
-        $c.= '<div class="casestudies-grid-item-label" style="'. $hover_style .'">';
-        $c.= '<h2 class="casestudies-grid-item-title">' . $study->titre . '</h2>';
+        $c .= '<div class="casestudies-grid-item-label" style="' . $hover_style . '">';
+        $c .= '<h2 class="casestudies-grid-item-title">' . $study->titre . '</h2>';
         //$c.= '<h3 class="casestudies-grid-item-tags">' . implode(' / ', $tag_names) . '</h3>';
-        $c.= '<h3 class="casestudies-grid-item-tags">' . $study->legende . '</h3>';
-        $c.= '</div>'; // .casestudies-grid-item-label
-
+        $c .= '<h3 class="casestudies-grid-item-tags">' . $study->legende . '</h3>';
+        $c .= '</div>'; // .casestudies-grid-item-label
 
 
         // Create a staggered delay for each row (3 items per row)
@@ -75,7 +80,8 @@ class Cubedesigners_View_Helper_CaseStudiesGrid extends CubeIT_View_Helper_Abstr
 
 
     // Get secondary category names
-    protected function _getTagName($catID) {
+    protected function _getTagName($catID)
+    {
 
         // Cache the query data if it's not already done
         if (!$this->_tags) {
-- 
2.39.5