public function addFilters($filtrables = array(), $searchable = false)
{
if (isset($this->params['where'])) {
$filtros = explode(',', $this->params['where']);
foreach ($filtros as $filtro) {
$regla = explode('-', $filtro);
if (count($regla) != 3) {
throw new BearableException('Parámetros de filtrado incorrectos.');
}
list($atr, $ope, $val) = $regla;
if (!in_array($atr, $filtrables)) {
throw new BearableException('Filtro inexistente.');
} else {
if (isset($this->operators[$ope])) {
$this->query = $this->query->where($atr, $this->operators[$ope], $val);
} else {
if ($ope == 'in') {
$this->query = $this->query->wherein($atr, explode('.', $val));
} else {
throw new BearableException('Operador inexistente.');
}
}
}
}
}
if (isset($this->params['where_null'])) {
$filtros = explode(',', $this->params['where_null']);
foreach ($filtros as $filtro) {
if (!in_array($filtro, $filtrables)) {
throw new BearableException('Filtro inexistente.');
}
$this->query = $this->query->whereNull($filtro);
}
}
if (isset($this->params['where_not_null'])) {
$filtros = explode(',', $this->params['where_not_null']);
foreach ($filtros as $filtro) {
if (!in_array($filtro, $filtrables)) {
throw new BearableException('Filtro inexistente.');
}
$this->query = $this->query->whereNotNull($filtro);
}
}
if (isset($this->params['q']) && $searchable) {
$filtro = FilterFactory::calcHuella($this->params['q']);
$this->query = $this->query->where('huella', 'LIKE', "%{$filtro}%");
}
if (isset($this->params['tags'])) {
$tags = array_map(FilterFactory::calcHuella(), explode(',', $this->params['tags']));
if (count($tags) > 4) {
throw new BearableException('No puede buscar más de 4 tags a la vez.');
}
$this->query = $this->query->whereHas('tags', function ($q) use($tags) {
$q->whereIn('huella', $tags);
});
}
}
public function setApellidoAttribute($value)
{
$this->attributes['apellido'] = $value;
$nombre = isset($this->attributes['nombre']) ? $this->attributes['nombre'] . ' ' : '';
$this->attributes['huella'] = FilterFactory::calcHuella($nombre . $value);
}
public function setTituloAttribute($value)
{
$this->attributes['titulo'] = $value;
$this->attributes['huella'] = FilterFactory::calcHuella($value);
}
public function setNombreAttribute($value)
{
$this->attributes['nombre'] = $value;
$this->attributes['huella'] = FilterFactory::calcHuella($value);
}
