File indexing completed on 2024-10-13 13:29:13
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 * Created: 23.01.2019 0024 */ 0025 class Application_Model_ConfigStoreTags 0026 { 0027 0028 /** 0029 * @param int $store_id 0030 * @param bool $onlyActive 0031 * 0032 * @return null|array 0033 */ 0034 public function getTagsAsIdForStore($store_id, $onlyActive = true) 0035 { 0036 $modelConfigStoreTags = new Application_Model_DbTable_ConfigStoreTags(); 0037 0038 $sql = "SELECT `tag_id` FROM `config_store_tag` WHERE `store_id` = :store_id AND `is_active` = :active ORDER BY `tag_id`;"; 0039 0040 $result = $modelConfigStoreTags->getAdapter()->fetchAll($sql, array('store_id' => $store_id, 'active' => ($onlyActive ? 1 : 0)), Zend_Db::FETCH_COLUMN); 0041 0042 if (0 == count($result)) { 0043 return null; 0044 } 0045 0046 return $result; 0047 } 0048 0049 }