chamilo / chamilo-lms

     * @param string $keyword

     * @return mixed

     */

    public function searchByKeyword($keyword)

    {

        $qb = $this->createQueryBuilder('a');

        //Selecting user info

        $qb->select('DISTINCT b');

        $qb->from('Chamilo\CoreBundle\Entity\BranchSync', 'b');

        //Selecting courses for users

        //$qb->innerJoin('u.courses', 'c');

        //@todo check app settings

        $qb->add('orderBy', 'b.branchName ASC');

        $qb->where('b.branchName LIKE :keyword');

        $qb->setParameter('keyword', "%$keyword%");

        $q = $qb->getQuery();

        return $q->execute();

    }

}

     *

    * @return mixed

    */

    public function searchUserByKeyword($keyword)

    {

        $qb = $this->createQueryBuilder('a');

        // Selecting user info

        $qb->select('DISTINCT b');

        $qb->from('Chamilo\UserBundle\Entity\User', 'b');

        // Selecting courses for users

        //$qb->innerJoin('u.courses', 'c');

        //@todo check app settings

        $qb->add('orderBy', 'b.firstname ASC');

        $qb->where('b.firstname LIKE :keyword OR b.lastname LIKE :keyword ');

        $qb->setParameter('keyword', "%$keyword%");

        $query = $qb->getQuery();

        return $query->execute();

    }

    /**

     * Get course user relationship based in the course_rel_user table.