have the ability for someone to request an educational video - example "I'd like a video on how to take an issue from github, code the solution and submit a PR"

[A1L13N]

see if we can use our existing educational video model or any other existing code

[A1L13N]

@coderabbitai code

[coderabbitai]

Tip

For best results, initiate chat on the files or code changes.

🧩 Analysis chain

🏁 Script executed:

#!/bin/bash
# First, let's check the project structure to understand the codebase organization
ls -la

Length of output: 1898

---

🏁 Script executed:

#!/bin/bash
# Examine the structure of the web directory
ls -la web/

Length of output: 2518

---

🏁 Script executed:

#!/bin/bash
# Search for "video" or "educational" related code in models.py
echo "=== Models with 'video' ==="
grep -n "video" web/models.py | head -20
echo -e "\n=== Models with 'educational' ==="
grep -n "educational" web/models.py | head -20

echo -e "\n=== Forms with 'video' ==="
grep -n "video" web/forms.py | head -20

# Check for educational video templates
echo -e "\n=== Templates related to videos ==="
find web/templates -type f -name "*video*" -o -name "*educational*"

Length of output: 2040

---

🏁 Script executed:

#!/bin/bash
# Let's look at the educational video model more closely
echo "=== Educational Video Model ===" 
grep -A 15 "educational videos shared by users" web/models.py

# Check for views related to educational videos
echo -e "\n=== Views related to educational videos ==="
grep -n "EducationalVideo" web/views.py | head -20

# Check URL patterns for educational videos
echo -e "\n=== URL patterns for educational videos ==="
grep -n "video" web/urls.py | head -20

# Let's also check for existing request forms or models
echo -e "\n=== Request models or forms ==="
grep -n -i "request" web/models.py | head -20

Length of output: 2185

---

🏁 Script executed:

#!/bin/bash
# Let's look at the WebRequest model
echo "=== WebRequest Model ===" 
grep -A 20 "class WebRequest" web/models.py

# Let's look at the educational video views
echo -e "\n=== Educational Video Views ==="
grep -n -A 20 "def educational_videos_list" web/views.py
grep -n -A 20 "def upload_educational_video" web/views.py

# Let's look at the EducationalVideoForm
echo -e "\n=== Educational Video Form ==="
grep -A 30 "EducationalVideoForm" web/forms.py

# Check if there are any request forms
echo -e "\n=== Request Forms ==="
grep -n -i "request" web/forms.py | head -20

Length of output: 5494

---

@A1L13N Based on my exploration of the codebase, I can see you already have an EducationalVideo model, but need a way for users to request videos. Here's a complete implementation:

1. VideoRequest Model

class VideoRequest(models.Model):
    """Model for users to request educational videos on specific topics."""
    
    title = models.CharField(max_length=200, help_text="Short title describing the requested video")
    description = models.TextField(help_text="Detailed description of what you'd like to learn from this video")
    category = models.ForeignKey(Subject, on_delete=models.PROTECT, related_name="video_requests")
    requester = models.ForeignKey(User, on_delete=models.CASCADE, related_name="video_requests")
    created_at = models.DateTimeField(auto_now_add=True)
    status = models.CharField(
        max_length=20,
        choices=[
            ('pending', 'Pending'),
            ('approved', 'Approved'),
            ('fulfilled', 'Fulfilled'),
            ('rejected', 'Rejected')
        ],
        default='pending'
    )
    fulfilled_by = models.ForeignKey(
        EducationalVideo, 
        on_delete=models.SET_NULL, 
        related_name="fulfilling_requests",
        null=True,
        blank=True
    )
    
    class Meta:
        verbose_name = "Video Request"
        verbose_name_plural = "Video Requests"
        ordering = ["-created_at"]
        
    def __str__(self):
        return self.title

2. Form for Video Requests

class VideoRequestForm(forms.ModelForm):
    """Form for users to request educational videos on specific topics."""
    
    class Meta:
        model = VideoRequest
        fields = ["title", "description", "category"]
        widgets = {
            "title": TailwindInput(attrs={"placeholder": "Title of the video you're requesting"}),
            "description": TailwindTextarea(
                attrs={
                    "rows": 4,
                    "placeholder": "Describe what you'd like to learn from this video (e.g., 'I'd like a video on how to take an issue from GitHub, code the solution, and submit a PR')",
                }
            ),
            "category": TailwindSelect(
                attrs={
                    "class": (
                        "w-full px-4 py-2 border border-gray-300 dark:border-gray-600"
                        " rounded-lg focus:ring-2 focus:ring-blue-500"
                    )
                }
            ),
        }
        
    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        # Order subjects by name
        self.fields["category"].queryset = Subject.objects.all().order_by("name")

3. Views for Video Requests

def video_request_list(request):
    """View for listing video requests with optional category filtering."""
    # Get category filter from query params
    selected_category = request.GET.get("category")
    
    # Base queryset
    requests = VideoRequest.objects.select_related("requester", "category").order_by("-created_at")
    
    # Apply category filter if provided
    if selected_category:
        requests = requests.filter(category__slug=selected_category)
        selected_category_obj = get_object_or_404(Subject, slug=selected_category)
        selected_category_display = selected_category_obj.name
    else:
        selected_category_display = None
    
    # Get category counts for sidebar
    category_counts = dict(
        VideoRequest.objects.values("category__name", "category__slug")
        .annotate(count=Count("id"))
        .values_list("category__slug", "count")
    )
    
    # Context
    context = {
        "requests": requests,
        "categories": Subject.objects.all(),
        "category_counts": category_counts,
        "selected_category": selected_category,
        "selected_category_display": selected_category_display,
    }
    
    return render(request, "videos/request_list.html", context)

@login_required
def submit_video_request(request):
    """View for submitting a new video request."""
    if request.method == "POST":
        form = VideoRequestForm(request.POST)
        if form.is_valid():
            video_request = form.save(commit=False)
            video_request.requester = request.user
            video_request.save()
            
            messages.success(request, "Your video request has been submitted successfully!")
            return redirect("video_request_list")
    else:
        form = VideoRequestForm()
    
    return render(request, "videos/submit_request.html", {"form": form})

4. URLs Configuration

# Add these to web/urls.py
path("videos/requests/", views.video_request_list, name="video_request_list"),
path("videos/requests/submit/", login_required(views.submit_video_request), name="submit_video_request"),

5. Template for Request List (videos/request_list.html)

{% extends "base.html" %}
{% load static %}

{% block title %}Video Requests{% endblock %}

{% block content %}
<div class="container mx-auto px-4 py-8">
    <div class="flex flex-col md:flex-row">
        <!-- Sidebar -->
        <div class="w-full md:w-1/4 pr-0 md:pr-8 mb-8 md:mb-0">
            <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-6">
                <h3 class="text-xl font-semibold mb-4">Categories</h3>
                <ul>
                    <li class="mb-2">
                        <a href="{% url 'video_request_list' %}" 
                           class="block py-2 px-3 rounded {% if not selected_category %}bg-blue-100 dark:bg-blue-900{% else %}hover:bg-gray-100 dark:hover:bg-gray-700{% endif %}">
                            All Categories
                        </a>
                    </li>
                    {% for category in categories %}
                    <li class="mb-2">
                        <a href="{% url 'video_request_list' %}?category={{ category.slug }}" 
                           class="block py-2 px-3 rounded flex justify-between items-center {% if selected_category == category.slug %}bg-blue-100 dark:bg-blue-900{% else %}hover:bg-gray-100 dark:hover:bg-gray-700{% endif %}">
                            <span>{{ category.name }}</span>
                            {% if category.slug in category_counts %}
                            <span class="bg-gray-200 dark:bg-gray-600 rounded-full px-2 py-1 text-xs">
                                {{ category_counts|get:category.slug }}
                            </span>
                            {% endif %}
                        </a>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </div>
        
        <!-- Main Content -->
        <div class="w-full md:w-3/4">
            <div class="flex justify-between items-center mb-6">
                <h1 class="text-3xl font-bold">
                    {% if selected_category_display %}
                        Video Requests: {{ selected_category_display }}
                    {% else %}
                        All Video Requests
                    {% endif %}
                </h1>
                <a href="{% url 'submit_video_request' %}" class="bg-blue-600 hover:bg-blue-700 text-white font-semibold py-2 px-4 rounded">
                    Request a Video
                </a>
            </div>
            
            {% if requests %}
                <div class="grid gap-6">
                    {% for request in requests %}
                    <div class="bg-white dark:bg-gray-800 rounded-lg shadow overflow-hidden">
                        <div class="p-6">
                            <div class="flex justify-between items-start">
                                <div>
                                    <h2 class="text-xl font-semibold mb-2">{{ request.title }}</h2>
                                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-4">
                                        Requested by {{ request.requester.get_full_name|default:request.requester.username }} 
                                        on {{ request.created_at|date:"F j, Y" }}
                                    </p>
                                </div>
                                <span class="px-3 py-1 rounded-full text-sm 
                                    {% if request.status == 'pending' %}bg-yellow-100 text-yellow-800
                                    {% elif request.status == 'approved' %}bg-blue-100 text-blue-800
                                    {% elif request.status == 'fulfilled' %}bg-green-100 text-green-800
                                    {% else %}bg-red-100 text-red-800{% endif %}">
                                    {{ request.get_status_display }}
                                </span>
                            </div>
                            <p class="mb-4">{{ request.description }}</p>
                            <div class="flex items-center">
                                <span class="bg-gray-200 dark:bg-gray-700 rounded-full px-3 py-1 text-sm font-semibold mr-2">
                                    {{ request.category.name }}
                                </span>
                                {% if request.fulfilled_by %}
                                <a href="{% url 'educational_videos_list' %}?video={{ request.fulfilled_by.id }}" 
                                   class="text-blue-600 hover:text-blue-800 dark:text-blue-400 dark:hover:text-blue-300">
                                    View Fulfilling Video
                                </a>
                                {% endif %}
                            </div>
                        </div>
                    </div>
                    {% endfor %}
                </div>
            {% else %}
                <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-8 text-center">
                    <h3 class="text-xl font-semibold mb-4">No video requests found</h3>
                    <p class="mb-6">Be the first to request an educational video on a topic that interests you!</p>
                    <a href="{% url 'submit_video_request' %}" class="bg-blue-600 hover:bg-blue-700 text-white font-semibold py-2 px-4 rounded">
                        Request a Video
                    </a>
                </div>
            {% endif %}
        </div>
    </div>
</div>
{% endblock %}

6. Template for Submitting Requests (videos/submit_request.html)

{% extends "base.html" %}
{% load static %}

{% block title %}Request a Video{% endblock %}

{% block content %}
<div class="container mx-auto px-4 py-8">
    <div class="max-w-3xl mx-auto">
        <div class="mb-8">
            <h1 class="text-3xl font-bold mb-4">Request an Educational Video</h1>
            <p class="text-gray-600 dark:text-gray-400">
                Is there a particular topic you'd like to learn more about? Request a video and we'll consider creating content on that subject.
            </p>
        </div>
        
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-6">
            <form method="post">
                {% csrf_token %}
                
                <div class="mb-6">
                    <label for="{{ form.title.id_for_label }}" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">
                        Title
                    </label>
                    {{ form.title }}
                    {% if form.title.errors %}
                    <p class="mt-2 text-sm text-red-600 dark:text-red-500">
                        {{ form.title.errors.0 }}
                    </p>
                    {% endif %}
                </div>
                
                <div class="mb-6">
                    <label for="{{ form.category.id_for_label }}" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">
                        Category
                    </label>
                    {{ form.category }}
                    {% if form.category.errors %}
                    <p class="mt-2 text-sm text-red-600 dark:text-red-500">
                        {{ form.category.errors.0 }}
                    </p>
                    {% endif %}
                </div>
                
                <div class="mb-6">
                    <label for="{{ form.description.id_for_label }}" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">
                        Description
                    </label>
                    {{ form.description }}
                    <p class="mt-1 text-sm text-gray-500 dark:text-gray-400">
                        Please provide details about what you'd like to learn. Example: "I'd like a video on how to take an issue from GitHub, code the solution, and submit a PR"
                    </p>
                    {% if form.description.errors %}
                    <p class="mt-2 text-sm text-red-600 dark:text-red-500">
                        {{ form.description.errors.0 }}
                    </p>
                    {% endif %}
                </div>
                
                <div class="flex justify-end">
                    <a href="{% url 'video_request_list' %}" class="bg-gray-200 hover:bg-gray-300 dark:bg-gray-700 dark:hover:bg-gray-600 text-gray-800 dark:text-white font-semibold py-2 px-4 rounded mr-4">
                        Cancel
                    </a>
                    <button type="submit" class="bg-blue-600 hover:bg-blue-700 text-white font-semibold py-2 px-4 rounded">
                        Submit Request
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>
{% endblock %}

This implementation leverages your existing educational video models and follows the same design patterns. Users can now request specific video topics while administrators can track and fulfill these requests.

🐰✨

[ishaan-arora-1]

/assign

[github-actions]

You can't take this task yet. You still have uncompleted issues: #239. Please complete them before requesting another.

[Vatsal565]

/assign

[github-actions]

Hey @Vatsal565! You're now assigned to this issue. Please finish your PR within 1 day.

[github-actions]

⏳ @Vatsal565, you have been unassigned due to 24+ hours of inactivity. This task is now available for reassignment.