Proyectos de Subversion LeadersLinked - Antes de SPA

       return $paginator;

   }

   /**

    * 

    * @param int $company_id

    * @param int $topic_id

    * @param int $capsule_id

    * @param int $user_id

    * @return void|CompanyMicrolearningCapsuleComment

    */

   public function fetchOneByCompanyIdAndTopicIdAndCapsuleIdAndUserId($company_id, $topic_id, $capsule_id, $user_id)

   {

       $select = $this->sql->select();

       $select->from(self::_TABLE);

       $select->where->equalTo('company_id', $company_id);

       $select->where->equalTo('topic_id', $topic_id);

       $select->where->equalTo('capsule_id', $capsule_id);

       $select->where->equalTo('user_id', $user_id);

       $prototype = new CompanyMicrolearningCapsuleComment();

       return $this->executeFetchOneObject($select, $prototype);

   }

   /**

    * 

    * @param int $company_id

    * @param int $topic_id

    * @param int $capsule_id

    * @return number[]

    */

   public function fetchCountAndRatingAverage($company_id, $topic_id, $capsule_id)

   {

       $select = $this->sql->select();

       $select->columns(['qty' => new Expression('COUNT(*)'), 'rating' ]);

       $select->from(self::_TABLE);

       $select->where->equalTo('company_id', $company_id);

       $select->where->equalTo('topic_id', $topic_id);

       $select->where->equalTo('capsule_id', $capsule_id);

       $total_comments  = 0;

       $total_rating = 0;

       $records = $this->executeFetchAllArray($select);

       foreach($records as $record)

       {

           $total_comments += $record['qty'];

           $total_rating += ($record['qty'] * $record['rating']);

       }

       return  [

           'total_comments' => $total_comments,

           'total_rating'  => $total_comments > 0 ? round($total_rating / $total_comments) : 0,

       ];