Proyectos de Subversion LeadersLinked - Antes de SPA

use LeadersLinked\Model\HighPerformanceTeamsGroups;

use LeadersLinked\Model\HighPerformanceTeamsGroupsMembers;

        $adapter = new DbSelect($select, $this->sql, $resultset);

        $paginator = new Paginator($adapter);

        $paginator->setItemCountPerPage($records_per_page);

        $paginator->setCurrentPageNumber($page);

        return $paginator;

    }

    public function fetchAllDataTableInnerJoin($search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC', $user_id)

    {

        $prototype = new HighPerformanceTeamsGroups();

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

        $select->from(['g' => self::_TABLE]);

        $select->join(['gm' => HighPerformanceTeamsGroupsMembersMapper::_TABLE], 'gm.group_id = g.id', []);

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

        $select->where->notEqualTo('gm.status', HighPerformanceTeamsGroupsMembers::STATUS_DELETE);

        if($search) {

            $select->where->like('title', '%' . $search . '%');

        }

        $select->order($order_field . ' ' . $order_direction);

        $hydrator   = new ObjectPropertyHydrator();

        $resultset  = new HydratingResultSet($hydrator, $prototype);