File indexing completed on 2025-02-09 07:14:33

0001 <?php
0002 /**
0003  *  ocs-webserver
0004  *
0005  *  Copyright 2016 by pling GmbH.
0006  *
0007  *    This file is part of ocs-webserver.
0008  *
0009  *    This program is free software: you can redistribute it and/or modify
0010  *    it under the terms of the GNU Affero General Public License as
0011  *    published by the Free Software Foundation, either version 3 of the
0012  *    License, or (at your option) any later version.
0013  *
0014  *    This program is distributed in the hope that it will be useful,
0015  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
0016  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
0017  *    GNU Affero General Public License for more details.
0018  *
0019  *    You should have received a copy of the GNU Affero General Public License
0020  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
0021  **/
0022 class Default_Model_DbTable_MemberFollower extends Zend_Db_Table_Abstract
0023 {
0024 
0025     protected $_name = "member_follower";
0026 
0027     public function countFollowedMembers($memberId)
0028     {
0029         $select = $this->_db->select()
0030             ->from('member_follower')
0031             ->joinUsing('member', 'member_id')
0032             ->where('member.is_deleted = ?', 0)
0033             ->where('member_follower.follower_id = ?', $memberId);
0034         return count($select->query()->fetchAll());
0035     }
0036 
0037 }