Proyectos de Subversion LeadersLinked - Antes de SPA

        return $paginator;

    }

    public function fetchAllDataTableHptg($search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC', $company_id, $high_performance_team_group_id)

    {

        $prototype = new PlanningObjectivesAndGoalsObjectives();

        $select = $this->sql->select(self::_TABLE);

        $select->where->equalTo('company_id', $company_id);

        $select->where->equalTo('high_performance_team_group_id', $high_performance_team_group_id);

        $select->where->notEqualTo('status', PlanningObjectivesAndGoalsObjectives::STATUS_DELETE);

        if($search) {

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

        }

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

        $hydrator   = new ObjectPropertyHydrator();

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

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

        $paginator = new Paginator($adapter);

        $paginator->setItemCountPerPage($records_per_page);

        $paginator->setCurrentPageNumber($page);