File indexing completed on 2025-02-09 07:14:35

 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  **/
 class Default_Model_DbTable_Section extends Local_Model_Table
 {
 
     const CACHE_STORES_CATEGORIES = 'section_categories_list';
     const CACHE_STORES_CONFIGS = 'section_list';
     const CACHE_STORE_CONFIG = 'section';
     const CACHE_STORES_CONFIGS_BY_ID = 'section_id_list';
 
     protected $_keyColumnsForRow = array('section_id');
     protected $_key = 'section_id';
     protected $_name = "section";
     
 
     /**
      * @param null $id
      *
      * @return array
      * @throws Zend_Db_Select_Exception
      */
     public function fetchNamesForJTable($id = null)
     {
         $select = $this->select()->from($this->_name)->columns('name')->group('name');
 
         $resultRows = $this->fetchAll($select);
 
         $resultForSelect = array();
         foreach ($resultRows as $row) {
             $resultForSelect[] = array('DisplayText' => $row['name'], 'Value' => $row['section_id']);
         }
 
         return $resultForSelect;
     }
 
     /**
      * @return array
      */
     public function fetchAllSectionsAndCategories($clearCache = false)
     {
         /** @var Zend_Cache_Core $cache */
         $cache = Zend_Registry::get('cache');
         $cacheName = self::CACHE_STORES_CATEGORIES;
 
         if ($clearCache) {
             $cache->remove($cacheName);
         }
 
         if (false == ($configArray = $cache->load($cacheName))) {
             $resultSet = $this->queryAllSectionsAndCategories();
             $configArray = $this->createArrayAllSectionsAndCategories($resultSet);
             $cache->save($configArray, $cacheName, array(), 28800);
         }
 
         return $configArray;
     }
 
     /**
      * @return array
      */
     private function queryAllSectionsAndCategories()
     {
         $sql = "
                 SELECT
                     `section`.`name`,
                     `section_category`.`section_id`,
                     `section_category`.`project_category_id`
                 FROM
                     `section`
                 JOIN
                     `section_category` ON `section`.`section_id` = `section_category`.`section_id`
                 JOIN
                     `project_category` ON `project_category`.`project_category_id` = `section_category`.`project_category_id`
                 ORDER BY `section`.`name`,`project_category`.`title`;
         ";
         $resultSet = $this->_db->fetchAll($sql);
 
         return $resultSet;
     }
 
     /**
      * @param array $resultSetConfig
      *
      * @return array
      */
     private function createArrayAllSectionsAndCategories($resultSetConfig)
     {
         $result = array();
         foreach ($resultSetConfig as $element) {
             $result[$element['name']][] = $element['project_category_id'];
         }
         array_walk($result, create_function('&$v', '$v = (count($v) == 1)? array_pop($v): $v;'));
 
         return $result;
     }
 
 
     public function deleteId($dataId)
     {
         $sql = "DELETE FROM `section` WHERE {$this->_key} = ?";
         $this->_db->query($sql, $dataId)->execute();
 //        return $this->delete(array('store_id = ?' => (int)$dataId));
     }
 
     public function delete($where)
     {
         $where = parent::_whereExpr($where);
 
         /**
          * Build the DELETE statement
          */
         $sql = "UPDATE " . parent::getAdapter()->quoteIdentifier($this->_name, true) . " SET is_active = 1, `deleted_at` = NOW() " . (($where) ? " WHERE $where" : '');
 
         /**
          * Execute the statement and return the number of affected rows
          */
         $stmt = parent::getAdapter()->query($sql);
         $result = $stmt->rowCount();
 
         return $result;
     }
 
     /**
      * @param bool $clearCache
      *
      * @return array
      * @throws Zend_Cache_Exception
      * @throws Zend_Exception
      */
     public function fetchAllSectionsArray($clearCache = false)
     {
         if (Zend_Registry::isRegistered('cache')) {
             /** @var Zend_Cache_Core $cache */
             $cache = Zend_Registry::get('cache');
             $cacheName = self::CACHE_STORES_CONFIGS;
 
             if ($clearCache) {
                 $cache->remove($cacheName);
             }
 
             if (false == ($configArray = $cache->load($cacheName))) {
                 $resultSet = $this->querySectionArray();
                 $configArray = $this->createSectionArray($resultSet);
                 $cache->save($configArray, $cacheName, array(), 28800);
             }
         } else {
             $resultSet = $this->querySectionArray();
             $configArray = $this->createSectionArray($resultSet);
         }
 
         return $configArray;
     }
 
     /**
      * @return array
      */
     private function querySectionArray()
     {
         $sql = "SELECT * FROM `section` ORDER BY `name`;";
         $resultSet = $this->_db->fetchAll($sql);
 
         return $resultSet;
     }
 
     /**
      * @param array  $resultSetConfig
      * @param string $key
      *
      * @return array
      */
     private function createSectionArray($resultSetConfig, $key = 'name')
     {
         $result = array();
         foreach ($resultSetConfig as $element) {
             $result[$element[$key]] = $element;
         }
 
         return $result;
     }
 
     /**
      * @param bool $clearCache
      *
      * @return array
      */
     public function fetchAllSectionByIdArray($clearCache = false)
     {
         if (Zend_Registry::isRegistered('cache')) {
             /** @var Zend_Cache_Core $cache */
             $cache = Zend_Registry::get('cache');
             $cacheName = self::CACHE_STORES_CONFIGS_BY_ID;
 
             if ($clearCache) {
                 $cache->remove($cacheName);
             }
 
             if (false == ($configArray = $cache->load($cacheName))) {
                 $resultSet = $this->querySectionArray();
                 $configArray = $this->createSectionArray($resultSet, 'section_id');
                 $cache->save($configArray, $cacheName, array(), 28800);
             }
         } else {
             $resultSet = $this->querySectionArray();
             $configArray = $this->createSectionArray($resultSet, 'section_id');
         }
 
         return $configArray;
     }
     
     
     
 }