public static function get($table, $columns, $fk = null)
{
$terms = Autocomplete::cleaner();
$query = DB::table($table)->select($columns);
array_shift($columns);
$result = [];
foreach ($terms as $term) {
$query = $query->Where(DB::raw('CONCAT(" ",' . implode(",", $columns) . ')'), 'LIKE', '%' . $term . '%');
}
if ($fk != null) {
$query = $query->WhereRaw($fk);
}
$query = $query->take(5)->get();
foreach ($query as $q) {
$result[] = ['id' => $q->id, 'value' => $q->{$columns}[0]];
}
$data['suggestions'] = $result;
return $data;
}
public static function get($table, $columns, $plus = null)
{
$terms = Autocomplete::cleaner();
$query = DB::table($table)->select($columns);
array_shift($columns);
if ($plus != null) {
array_pop($columns);
}
$result = [];
foreach ($terms as $term) {
$query = $query->Where(DB::raw('CONCAT(" ",' . implode(",", $columns) . ')'), 'LIKE', '%' . $term . '%');
}
$query = $query->take(5)->get();
foreach ($query as $q) {
if ($plus == null) {
$result[] = ['id' => $q->id, 'value' => $q->{$columns}[0] . ' ' . $q->{$columns}[1]];
} else {
$result[] = ['id' => $q->id, 'value' => $q->{$columns}[0] . ' ' . $q->{$columns}[1], 'descripcion' => $q->{$plus}];
}
}
$data['suggestions'] = $result;
return $data;
}
