Index: music/urls.py =================================================================== --- music/urls.py (revision 9ed4889a557f196dd21c3f48e3edef203a3a1051) +++ music/urls.py (revision d0b1ea74bdcbf92413abee6cdf506065f9e4a08e) @@ -23,4 +23,5 @@ path('customer/rank-list', views.rank_list_most_active_customers, name='rank_list_most_active_customers'), path('employee/batch-update-reports-to/', views.batch_update_reports_to, name='batch_update_reports_to'), + path('playlists/add-tracks/', views.add_tracks_to_playlist, name='add_tracks_to_playlist'), ] Index: music/views.py =================================================================== --- music/views.py (revision 9ed4889a557f196dd21c3f48e3edef203a3a1051) +++ music/views.py (revision d0b1ea74bdcbf92413abee6cdf506065f9e4a08e) @@ -276,2 +276,29 @@ }) +def add_tracks_to_playlist(request): + playlists = Playlist.objects.all() + tracks = Track.objects.all() + selected_playlist_id = request.POST.get('playlist_id') or request.GET.get('playlist_id') + + if request.method == 'POST': + selected_track_ids = request.POST.getlist('track_ids') + + if selected_playlist_id and selected_track_ids: + json_data = json.dumps([ + {"track_id": int(track_id)} + for track_id in selected_track_ids + ]) + try: + with connection.cursor() as cursor: + cursor.execute("SELECT add_tracks_to_playlist(%s, %s::json);", [selected_playlist_id, json_data]) + messages.success(request, "Tracks successfully added to playlist.") + return redirect('add_tracks_to_playlist') + + except Exception as e: + messages.error(request, f"Error adding tracks: {e}") + + return render(request, 'add_tracks_to_playlist.html', { + 'playlists': playlists, + 'tracks': tracks, + 'selected_playlist_id': selected_playlist_id + }) Index: templates/add_tracks_to_playlist.html =================================================================== --- templates/add_tracks_to_playlist.html (revision d0b1ea74bdcbf92413abee6cdf506065f9e4a08e) +++ templates/add_tracks_to_playlist.html (revision d0b1ea74bdcbf92413abee6cdf506065f9e4a08e) @@ -0,0 +1,70 @@ + + + + + Title + + + + + + + + Add Tracks to Playlist + + + +{% include 'sidebar.html' %} + +
+

Add Tracks to Playlist

+ +
+ {% csrf_token %} + +
+ + +
+ +
+
+
+ +
+ {% for track in tracks %} +
+ + +
+ {% endfor %} + {% if tracks|length == 0 %} +
No tracks available.
+ {% endif %} +
+
+ +
+ +
+
+ +
+
+
+
+
+ + Index: templates/sidebar.html =================================================================== --- templates/sidebar.html (revision 9ed4889a557f196dd21c3f48e3edef203a3a1051) +++ templates/sidebar.html (revision d0b1ea74bdcbf92413abee6cdf506065f9e4a08e) @@ -86,4 +86,10 @@ +
  • + + Add tracks to playlist + +