public static function getSearchChannels($query)
{
$query = trim(urldecode($query));
if ($query != '') {
return UserChannel::find_by_sql('SELECT * FROM users_channels
LEFT OUTER JOIN
(SELECT user_channel_id, COUNT(*) AS total_sub FROM subscriptions GROUP BY user_channel_id)
AS total_sub
ON(total_sub.user_channel_id = users_channels.id)
WHERE name LIKE ? OR description LIKE ? ORDER BY total_sub DESC LIMIT 6', ["%{$query}%", "%{$query}%"]);
}
}
public function autocomplete($prefix, $request)
{
if (strlen($prefix) >= 3) {
$channels = UserChannel::find_by_sql("SELECT * FROM users_channels WHERE name LIKE ?", array($prefix . '%'));
$array = array();
foreach ($channels as $chan) {
$array[] = array('user_id' => $chan->owner_id, 'name' => $chan->name, 'avatar' => $chan->avatar);
}
return new JsonResponse($array);
} else {
return new JsonResponse(array());
}
}