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

 <?php
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    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 Default_Model_DbTable_ProjectFollower extends Zend_Db_Table_Abstract
 {
 
     protected $_name = "project_follower";    
 
     public function countLikesHeGave($memberId)
     {        
         $sql ="
                 SELECT count(*) AS count 
                 FROM project_follower f  
                 inner join member m on f.member_id = m.member_id and m.is_active=1 AND m.is_deleted=0   
                 inner join project p on p.project_id = f.project_id and p.status = 100 
                 WHERE  f.member_id =:memberId
         ";
         $resultRow = $this->_db->fetchRow($sql, array('memberId' => $memberId));
         return $resultRow['count'];
     }
 
     public function countLikesHeGot($memberId)
     {       
         $sql ="
                 SELECT count(*) AS count 
                 FROM project_follower f  
                 inner join member m on f.member_id = m.member_id and m.is_active=1 AND m.is_deleted=0   
                 inner join project p on p.project_id = f.project_id and p.status = 100 
                 WHERE  p.member_id =:memberId
         ";
         $resultRow = $this->_db->fetchRow($sql, array('memberId' => $memberId));
         return $resultRow['count'];
     }
 
      public function countForProject($project_id)
     {
             $selectArr = $this->_db->fetchRow('SELECT count(*) AS count FROM project_follower f  inner join member m on f.member_id = m.member_id and m.is_active=1 AND m.is_deleted=0   WHERE  project_id = ' . $project_id);
             return $selectArr ['count'];      
     }
 
      public function fetchLikesForMember($memberId)
     {            
              $sql = "   
                         SELECT 
                         f.project_id
                         ,f.member_id
                         ,f.created_at
                         ,p.member_id as project_member_id
                         ,m.username as project_username
                         ,p.project_category_id
                         ,p.status
                         ,p.title
                         ,p.description
                         ,p.image_small
                         ,p.created_at as project_created_at
                         ,p.changed_at as project_changed_at                       
                         ,c.title as cat_title                                               
                         ,pr.likes AS count_likes
                         ,pr.dislikes AS count_dislikes
                         ,IFNULL(pr.score_with_pling, 500) AS laplace_score
                         FROM project_follower f                        
                         INNER JOIN project p ON p.project_id = f.project_id 
                         LEFT join  stat_rating_project AS pr  ON p.project_id = pr.project_id
                         inner join member m on p.member_id = m.member_id and m.is_active=1 AND m.is_deleted=0 
                         inner join project_category c on p.project_category_id = c.project_category_id
                         WHERE (p.status = 100) AND (f.member_id = :member_id) 
                         order by f.created_at desc                      
              ";
 
             $resultSet = $this->_db->fetchAll($sql, array('member_id' => $memberId));
             return new Zend_Paginator(new Zend_Paginator_Adapter_Array($resultSet ));     
     }
 
      public function fetchLikesForProject($project_id)
     {            
             $sql = "
                          SELECT 
                         f.project_id
                         ,f.member_id
                         ,f.created_at
                         ,m.profile_image_url
                         ,m.created_at as member_created_at
                         ,m.username
                         FROM project_follower f
                         inner join member m on f.member_id = m.member_id and m.is_active=1 AND m.is_deleted=0 
                         WHERE  f.project_id = :project_id
                         order by f.created_at desc
              ";
             $resultSet = $this->_db->fetchAll($sql, array('project_id' => $project_id));
             return $resultSet;     
     }
 
 }