diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2006-09-18 03:29:54 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2006-09-18 03:29:54 +0000 |
| commit | 6224281f3c405b0f41c597d504273fe5c237d4ad (patch) | |
| tree | 8b472d247b76abfece39cf6738acf19b697c40f1 /lib | |
| parent | 6f43d4d87802e8d7e74d355060bbf4e4c2f44a2b (diff) | |
| download | ampache-6224281f3c405b0f41c597d504273fe5c237d4ad.tar.gz ampache-6224281f3c405b0f41c597d504273fe5c237d4ad.tar.bz2 ampache-6224281f3c405b0f41c597d504273fe5c237d4ad.zip | |
added ability to search by ratings
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/search.php | 21 |
1 files changed, 18 insertions, 3 deletions
diff --git a/lib/search.php b/lib/search.php index 31ac5b71..3c6c6b42 100644 --- a/lib/search.php +++ b/lib/search.php @@ -101,11 +101,12 @@ function run_search($data) { function search_song($data,$operator,$method,$limit) { /* Generate BASE SQL */ - $base_sql = "SELECT DISTINCT(song.id) FROM song"; $where_sql = ''; $table_sql = ','; $join_sql = ''; + $group_sql = ' GROUP BY'; + $select_sql = ','; if ($limit > 0) { $limit_sql = " LIMIT $limit"; @@ -155,7 +156,7 @@ function search_song($data,$operator,$method,$limit) { break; case 'genre': $where_sql .= " genre.name $value_string $operator"; - $join_qsl .= "song.genre=genre.id AND "; + $join_sql .= "song.genre=genre.id AND "; $table_sql .= "genre,"; break; case 'year': @@ -176,6 +177,14 @@ function search_song($data,$operator,$method,$limit) { $value = intval($value); $where_sql .= " song.bitrate >= ('$value'*1000) $operator"; break; + case 'rating': + $value = intval($value); + $select_sql .= "SUM(ratings.user_rating)/(SELECT COUNT(song.id) FROM song,ratings WHERE ratings.object_id=song.id AND ratings.object_type='song' AND ratings.user_rating >= '$value') AS avgrating,"; + $group_sql .= " ratings.user_rating,"; + $where_sql .= " (ratings.user_rating >= '$value' AND ratings.object_type='song')"; + $table_sql .= "ratings,"; + $join_sql .= "ratings.object_id=song.id AND"; + $limit_sql .= " ORDER BY avgrating DESC"; default: // Notzing! break; @@ -187,8 +196,14 @@ function search_song($data,$operator,$method,$limit) { /* Trim off the extra $method's and ,'s then combine the sucka! */ $table_sql = rtrim($table_sql,','); $where_sql = rtrim($where_sql,$operator); + $group_sql = rtrim($group_sql,','); + $select_sql = rtrim($select_sql,','); + + if ($group_sql == ' GROUP BY') { $group_sql = ''; } + + $base_sql = "SELECT DISTINCT(song.id) $select_sql FROM song"; - $sql = $base_sql . $table_sql . " WHERE " . $join_sql . "(" . $where_sql . ")" . $limit_sql; + $sql = $base_sql . $table_sql . " WHERE " . $join_sql . "(" . $where_sql . ")" . $group_sql . $limit_sql; /** * Because we might need this for Dynamic Playlist Action |