File indexing completed on 2024-10-13 13:29:13

0001 <?php
0002 
0003 /**
0004  *  ocs-apiserver
0005  *
0006  *  Copyright 2016 by pling GmbH.
0007  *
0008  *    This file is part of ocs-apiserver.
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 Application_Model_Project extends Application_Model_DbTable_Project
0024 {
0025 
0026     const FILTER_NAME_PROJECT_ID_NOT_IN = 'project_id_not_in';
0027     const FILTER_NAME_RANKING = 'ranking';
0028     const FILTER_NAME_CATEGORY = 'category';
0029     const FILTER_NAME_PACKAGETYPE = 'package_type';
0030     const FILTER_NAME_MEMBER = 'member';
0031     const FILTER_NAME_ORDER = 'order';
0032     const FILTER_NAME_LOCATION = 'location';
0033 
0034     const ITEM_TYPE_DUMMY = 0;
0035     const ITEM_TYPE_PRODUCT = 1;
0036     const ITEM_TYPE_UPDATE = 2;
0037 
0038     protected function _getCatIds($catids)
0039     {
0040         $sqlwhereCat = "";
0041         $sqlwhereSubCat = "";
0042 
0043         $idCategory = explode(',', $catids);
0044         if (false === is_array($idCategory)) {
0045             $idCategory = array($idCategory);
0046         }
0047 
0048         $sqlwhereCat .= implode(',', $idCategory);
0049 
0050         $modelCategory = new Application_Model_DbTable_ProjectCategory();
0051         $subCategories = $modelCategory->fetchChildElements($idCategory);
0052 
0053         if (count($subCategories) > 0) {
0054             foreach ($subCategories as $element) {
0055                 $sqlwhereSubCat .= "{$element['project_category_id']},";
0056             }
0057         }
0058 
0059         return $sqlwhereSubCat . $sqlwhereCat;
0060     }
0061 
0062     /**
0063      * @param array $data
0064      *
0065      * @return Zend_Db_Table_Rowset_Abstract
0066      */
0067     protected function generateRowSet($data)
0068     {
0069         $classRowSet = $this->getRowsetClass();
0070 
0071         return new $classRowSet(array(
0072             'table'    => $this,
0073             'rowClass' => $this->getRowClass(),
0074             'stored'   => true,
0075             'data'     => $data
0076         ));
0077     }
0078 
0079 
0080 
0081     /**
0082      * @param $projectId
0083      *
0084      * @return array
0085      */
0086     public function getGalleryPictureSources($projectId)
0087     {
0088         $galleryPictureTable = new Application_Model_DbTable_ProjectGalleryPicture();
0089         $stmt = $galleryPictureTable->select()->where('project_id = ?', $projectId)->order(array('sequence'));
0090 
0091         $pics = array();
0092         foreach ($galleryPictureTable->fetchAll($stmt) as $pictureRow) {
0093             $pics[] = $pictureRow['picture_src'];
0094         }
0095 
0096         return $pics;
0097     }
0098 
0099     
0100 
0101     
0102     
0103     
0104 }