Proyectos de Subversion Moodle

Rev

Rev 1 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1 Rev 1441
Línea 215... Línea 215...
215 
        $field = self::get_fullname_field($firstnamefirst);
 215 
        $field = self::get_fullname_field($firstnamefirst);
216 
        $this->filter_by_non_letter($field);
 216 
        $this->filter_by_non_letter($field);
217 
    }
 217 
    }
Línea 218... Línea 218...
218 
 
 218 
 
219 
    /**
 - 
 
220 
     * Filter the concept by letter.
 - 
 
221 
     *
 - 
 
222 
     * @param string  $letter         The letter.
 - 
 
223 
     */
 - 
 
224 
    public function filter_by_concept_letter($letter) {
 - 
 
225 
        $this->filter_by_letter($letter, self::resolve_field('concept', 'entries'));
 - 
 
226 
    }
 - 
 
227 
 
 - 
 
228 
    /**
 - 
 
229 
     * Filter the concept by special characters.
 - 
 
230 
     *
 - 
 
231 
     * @return void
 - 
 
232 
     */
 - 
 
233 
    public function filter_by_concept_non_letter() {
 - 
 
234 
        $this->filter_by_non_letter(self::resolve_field('concept', 'entries'));
 - 
 
235 
    }
 - 
 
236 
 
 - 
 
237 
    /**
 219 
    /**
238 
     * Filter non approved entries.
 220 
     * Filter non approved entries.
239 
     *
 221 
     *
240 
     * @param string $constant One of the NON_APPROVED_* constants.
 222 
     * @param string $constant One of the NON_APPROVED_* constants.
241 
     * @param int    $userid   The user ID when relevant, otherwise current user.
 223 
     * @param int    $userid   The user ID when relevant, otherwise current user.
Línea 271... Línea 253...
271 
     * This requires the alias table to be joined in the query. See {@link self::join_alias()}.
 253 
     * This requires the alias table to be joined in the query. See {@link self::join_alias()}.
272 
     *
 254 
     *
273 
     * @param string $term What the concept or aliases should be.
 255 
     * @param string $term What the concept or aliases should be.
274 
     */
 256 
     */
275 
    public function filter_by_term($term) {
 257 
    public function filter_by_term($term) {
276 
        $this->where[] = sprintf("(%s = :filterterma OR %s = :filtertermb)",
 258 
        $this->where[] = sprintf("(%s LIKE :filterterma OR %s LIKE :filtertermb)",
277 
            self::resolve_field('concept', 'entries'),
 259 
            self::resolve_field('concept', 'entries'),
278 
            self::resolve_field('alias', 'alias'));
 260 
            self::resolve_field('alias', 'alias'));
279 
        $this->params['filterterma'] = $term;
 261 
        $this->params['filterterma'] = "%" . $term . "%";
280 
        $this->params['filtertermb'] = $term;
 262 
        $this->params['filtertermb'] = "%" . $term . "%";
281 
    }
 263 
    }
Línea 282... Línea 264...
282 
 
 264 
 
283 
    /**
 265 
    /**
284 
     * Convenience method to get get the SQL statement for the full name.
 266 
     * Convenience method to get get the SQL statement for the full name.