chamilo / chamilo-lms

     * @param string $order

     * @return array

     */

    public function getUserAgreementList($courseId, $sessionId, $order = null)

    {

        $courseId = intval($courseId);

        $sessionId = intval($sessionId);

        $table = Database::get_main_table('session_rel_course_rel_user_legal');

        $userTable = Database::get_main_table(TABLE_MAIN_USER);

        $sql = "SELECT *

                FROM $table s INNER JOIN $userTable u

                ON u.user_id = s.user_id

                WHERE c_id = $courseId AND session_id = $sessionId ";

        if (!empty($order)) {

            $sql .= $order;

        }

        $result = Database::query($sql);

        $data = array();

        if (Database::num_rows($result) > 0) {

            $data = Database::store_result($result, 'ASSOC');

        }

        return $data;

    }

    /**

     * @param int $courseId

     * @param string $name

     * @return array

     */

    public static function getGroupListFilterByName($name, $categoryId, $courseId)

    {

        $name = trim($name);

        if (empty($name)) {

            return array();

        }

        $name = Database::escape_string($name);

        $courseId = intval($courseId);

        $table_group = Database::get_course_table(TABLE_GROUP);

        $sql = "SELECT * FROM $table_group

                WHERE c_id = $courseId AND name LIKE '%$name%'";

        if (!empty($categoryId)) {

            $categoryId = intval($categoryId);

            $sql .= " AND category_id = $categoryId";

        }

        $sql .= " ORDER BY name";

        $result = Database::query($sql);

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * Set group properties