File indexing completed on 2025-05-04 05: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 class Default_Model_ProjectUpdates extends Default_Model_DbTable_ProjectUpdates 0024 { 0025 0026 /** 0027 * @param $project_id 0028 * 0029 * @return array 0030 */ 0031 public function fetchProjectUpdates($project_id) 0032 { 0033 $sql = ' 0034 SELECT * 0035 FROM project_updates 0036 WHERE project_id = :project_id 0037 AND public = 1 0038 ORDER BY created_at DESC 0039 '; 0040 0041 $rowset = $this->_db->fetchAll($sql, array('project_id' => $project_id)); 0042 0043 return $rowset; 0044 } 0045 0046 }