File indexing completed on 2025-02-09 07:14:41
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 }