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 }