Proyectos de Subversion LeadersLinked - Antes de SPA

<?php

declare(strict_types=1);

namespace LeadersLinked\Helper;

use Laminas\View\Helper\AbstractHelper;
use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Log\LoggerInterface;
use Laminas\Authentication\AuthenticationService;
use LeadersLinked\Mapper\UserMapper;
use LeadersLinked\Library\Functions;
use LeadersLinked\Plugin\CurrentUserPlugin;
use Laminas\Paginator\Adapter\DbSelect;
use LeadersLinked\Mapper\QueryMapper;
use LeadersLinked\Mapper\ProfileVisitMapper;
use LeadersLinked\Mapper\CompanyFollowerMapper;
use LeadersLinked\Model\User;

class  CompanyFollowerHelper extends AbstractHelper
{
    
    /**
     *
     * @var AdapterInterface
     */
    private $adapter;
    
    
    /**
     *
     * @param AdapterInterface $adapter
     */
    public function __construct($adapter)
    {
        $this->adapter      = $adapter;
    }
    
    public function __invoke($company_id)
    {   
        $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
        $records = $companyFollowerMapper->fetchAllByCompanyId($company_id);
        
        $ids = [];
        foreach($records as $record) 
        {
            if(!in_array($record->follower_id, $ids)) {
                array_push($ids, $record->follower_id);
            }
        }
        
        $items = [];
        if($ids) {
        
            $mapper = QueryMapper::getInstance($this->adapter);
            $select = $mapper->getSql()->select(UserMapper::_TABLE);
            $select->columns(['uuid','first_name', 'last_name', 'image']);
            $select->where->in('id',$ids);
            $select->where->equalTo('status',User::STATUS_ACTIVE);
            $select->order(['last_name','first_name']);
            
            //echo $select->getSqlString($this->adapter->platform); 
            
            $items = $mapper->fetchAll($select);
        }
        return $this->getView()->render('helpers/company-followers.phtml', ['items' => $items]);
    }
}