File indexing completed on 2024-04-28 05:53:54

 <?php
 
 /**
  *  ocs-apiserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-apiserver.
  *
  *    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 Application_Model_DbTable_Tags extends Local_Model_Table
 {
 
     protected $_name = "tag";
 
     protected $_keyColumnsForRow = array('tag_id');
 
     protected $_key = 'tag_id';
 
     protected $_defaultValues = array(
         'tag_id'   => null,
         'tag_name' => null
     );
 
 
     /**
      * @param string $tags
      *
      * @return array
      */
     public function storeTags($tags)
     {
         $arrayTags = explode(',', $tags);
         $sqlFetchTag = "SELECT `tag_id` FROM tag WHERE tag_name = :name";
         $resultIds = array();
         foreach ($arrayTags as $tag) {
             $resultRow = $this->_db->fetchRow($sqlFetchTag, array('name' => $tag));
             if (empty($resultRow)) {
                 $this->_db->insert($this->_name, array('tag_name' => $tag));
                 $resultIds[] = $this->_db->lastInsertId();
             } else {
                 $resultIds[] = $resultRow['tag_id'];
             }
         }
 
         return $resultIds;
     }
 
 }