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 LeadersLinked\Mapper\ConnectionMapper;
use LeadersLinked\Mapper\QueryMapper;
use LeadersLinked\Mapper\UserMapper;
use LeadersLinked\Model\User;
use Laminas\Db\Sql\Expression;

class PeopleYouMayKnowHelper extends AbstractHelper
{
    
    /**
     *
     * @var AdapterInterface
     */
    private $adapter;
    
    
    /**
     *
     * @param AdapterInterface $adapter
     */
    public function __construct($adapter)
    {
        $this->adapter      = $adapter;
    }

    public function __invoke($user_id)
    {
        $connectionMapper = ConnectionMapper::getInstance($this->adapter);
        $first_degree_connections_ids = $connectionMapper->fetchAllConnectionsByUserReturnIds($user_id);
        $first_degree_connections_ids = $first_degree_connections_ids ? $first_degree_connections_ids : [0];
        
        $second_degree_connections_ids = $connectionMapper->fetchAllSecondDegreeConnectionsForUserIdReturnIds($user_id);
        $second_degree_connections_ids = $second_degree_connections_ids ? $second_degree_connections_ids : [0];
        
        
        $items = [];
        if($first_degree_connections_ids && $second_degree_connections_ids) {
            $queryMapper = QueryMapper::getInstance($this->adapter);
            $select = $queryMapper->getSql()->select();
            $select->columns(['id', 'uuid', 'first_name','last_name', 'image']);
            $select->from(['u' => UserMapper::_TABLE]);
            $select->where->in('u.id', $second_degree_connections_ids);
            $select->where->notIn('u.id', $first_degree_connections_ids);
            $select->where->notEqualTo('u.id', $user_id);
            $select->where->equalTo('u.status', User::STATUS_ACTIVE);
            $select->group('u.id');
           
            $select->order(['last_name','first_name']);

            $items = $queryMapper->fetchAll($select);
        }

        return $this->getView()->render('helpers/people-you-may-know.phtml', ['items' => $items]);
    }
}