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

use LeadersLinked\Mapper\CompanyMapper;

use LeadersLinked\Mapper\CompanyLocationMapper;

use LeadersLinked\Mapper\LocationMapper;

use LeadersLinked\Model\Company;

class CompanySuggestionHelper extends AbstractHelper

{

    /**

     *

     * @var AdapterInterface

     */

    private $adapter;

    /**

     *

     * @param AdapterInterface $adapter

     */

    public function __construct($adapter)

    {

        $this->adapter      = $adapter;

    }

    public function __invoke($company_id)

    {

        $companyMapper = CompanyMapper::getInstance($this->adapter);

        $company = $companyMapper->fetchOne($company_id);

        $items = [];

        if($company) {

            $location = null;

            $companyLocationMapper = CompanyLocationMapper::getInstance($this->adapter);

            $companyLocation = $companyLocationMapper->fetchOneMainLocationByCompanyId($company->id);

            if($companyLocation) {

                $locationMapper = LocationMapper::getInstance($this->adapter);

                $location = $locationMapper->fetchOne($companyLocation->location_id);

            }

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

            $select = $mapper->getSql()->select();

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

            $select->from(['c' => CompanyMapper::_TABLE]);

            $select->join(['cl' => CompanyLocationMapper::_TABLE], 'cl.company_id  = c.id', []);

            $select->join(['l' => LocationMapper::_TABLE], 'l.id  = cl.location_id', ['state','country']);

            $select->where->equalTo('company_size_id', $company->company_size_id);

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

            $select->where->equalTo('state', $location ? $location->state : '');

            $select->where->equalTo('country', $location ? $location->country : '');

            $select->where->equalTo('c.status', Company::STATUS_ACTIVE);

            $select->where->notEqualTo('c.id', $company->id);

            $select->limit(20);

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

        }

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

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

    }

}