File indexing completed on 2024-05-12 05:58:47

0001 <?php
0002 
0003 /**
0004  *  ocs-webserver
0005  *
0006  *  Copyright 2016 by pling GmbH.
0007  *
0008  *    This file is part of ocs-webserver.
0009  *
0010  *    This program is free software: you can redistribute it and/or modify
0011  *    it under the terms of the GNU Affero General Public License as
0012  *    published by the Free Software Foundation, either version 3 of the
0013  *    License, or (at your option) any later version.
0014  *
0015  *    This program is distributed in the hope that it will be useful,
0016  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
0017  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
0018  *    GNU Affero General Public License for more details.
0019  *
0020  *    You should have received a copy of the GNU Affero General Public License
0021  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
0022  **/
0023 class Default_Model_SubCategory extends Default_Model_DbTable_ProjectSubCategory
0024 {
0025 
0026     const ORDERED_TITLE = 'title';
0027     const ORDERED_ID = 'project_category_id';
0028     const ORDERED_HIERARCHIC = 'lft';
0029 
0030     /**
0031      * @param int    $category_id
0032      * @param string $orderBy
0033      *
0034      * @return array
0035      */
0036     public function fetchAllSubCategories($category_id, $orderBy = self::ORDERED_HIERARCHIC)
0037     {
0038         $tableCategories = new Default_Model_DbTable_ProjectCategory();
0039 
0040         $resultSet = $tableCategories->fetchImmediateChildren($category_id, $orderBy);
0041 
0042         $rows = array();
0043         if (count($resultSet > 0)) {
0044             foreach ($resultSet as $row) {
0045                 $rows[$row['project_category_id']] = $row['title'];
0046             }
0047         }
0048 
0049         return $rows;
0050     }
0051 
0052 }