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\UserMapper;

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Model\GroupMember;

use LeadersLinked\Mapper\GroupMemberMapper;

use LeadersLinked\Mapper\GroupMapper;

use Laminas\Db\Sql\Expression;

use LeadersLinked\Mapper\UserExperienceMapper;

use LeadersLinked\Model\UserExperience;

use LeadersLinked\Model\Group;

class SimilarGroupsHelper extends AbstractHelper

{

    /**

     *

     * @var AdapterInterface

     */

    private $adapter;

    /**

     *

     * @param AdapterInterface $adapter

     */

    public function __construct($adapter)

    {

        $this->adapter      = $adapter;

    }

    public function __invoke($group_id)

    {

        $groupMapper = GroupMapper::getInstance($this->adapter);

        $group = $groupMapper->fetchOne($group_id);

        $items = [];

        if ($group) {

            $queryMapper = QueryMapper::getInstance($this->adapter);

            $select = $queryMapper->getSql()->select(GroupMapper::_TABLE);

            $select->columns(['id', 'uuid', 'name','image','status','privacy']);

            $select->where->equalTo('privacy', Group::PRIVACY_IS_PUBLIC);

            $select->where->equalTo('status', Group::STATUS_ACTIVE);

            $select->where->equalTo('type_id', $group->type_id);

            $select->where->equalTo('industry_id', $group->industry_id);

            $select->where->notEqualTo('id', $group->id);

            $select->order('name');

            //echo $select->getSqlString($this->adapter->platform); exit;

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

        }

        return $this->getView()->render('helpers/similar-groups.phtml', ['items' => $items]);

    }

}