🗃️ 🔖 Part 3: Activity Tracking Module Design

এখানে আমরা ActivityLog model তৈরি, Database Migration, এবং Admin Customization করবো। প্রতিটি স্টেপে প্রফেশনাল লেভেল ব্যাখ্যা + Bangla comments থাকবে যেন বাস্তবে apply করতে পারো।

---

✅ ১. Designing ActivityLog model

🎯 Goal:

প্রতিটি কর্মচারীর কম্পিউটার একটিভিটি লগ সংরক্ষণ করা, যেমন:

• Active window
• Website URL
• Keystrokes (optional)
• Screenshot
• App usage data
• Idle time
• Boot time (optional here; separate model recommended)

---

🔨 Step 1.1 – Edit monitoring/models.py

from django.db import models

# 🔗 Employee model import if in same file no need, else:
# from .models import Employee

class ActivityLog(models.Model):
    """
    📝 ActivityLog Model
    প্রতিটি লগ এ কর্মচারীর একটিভিটি data save হবে।
    """

    # কোন কর্মচারীর লগ
    employee = models.ForeignKey('Employee', on_delete=models.CASCADE, related_name='activity_logs')

    # লগ এর সময়
    timestamp = models.DateTimeField(auto_now_add=True)

    # কোন window active ছিল (যেমন 'Google Chrome - YouTube')
    active_window = models.CharField(max_length=255, blank=True, null=True)

    # যদি ওয়েবসাইটে থাকে, তাহলে URL save হবে
    website_url = models.URLField(blank=True, null=True)

    # Keystrokes data (optional, ethical consideration)
    keystrokes = models.TextField(blank=True, null=True)

    # Screenshot image
    screenshot = models.ImageField(upload_to='screenshots/', blank=True, null=True)

    # App usage data as JSON (example: [{"app_name":"Word","duration_min":20}])
    app_usage = models.JSONField(blank=True, null=True)

    # Idle time (minute)
    idle_time_min = models.PositiveIntegerField(default=0)

    class Meta:
        ordering = ['-timestamp']  # সর্বশেষ লগ উপরে থাকবে

    def __str__(self):
        return f"{self.employee.name} | {self.timestamp.strftime('%Y-%m-%d %H:%M:%S')}"

---

🔎 Bangla Explanation:

✅ ForeignKey → প্রতিটি লগ একটি কর্মচারীর সাথে যুক্ত
✅ CharField / URLField / TextField → ডাটা টাইপ অনুযায়ী
✅ ImageField → screenshot save হবে media/screenshots/ ফোল্ডারে
✅ JSONField → multiple app usage data JSON আকারে save হবে
✅ PositiveIntegerField → Idle time negative হতে পারে না
✅ Meta ordering → Admin এ latest log উপরে

---

🔨 Step 1.2 – Install Pillow (ImageField requires it)

pip install Pillow

---

✅ ২. Migration & Database Schema Optimization

🔨 Step 2.1 – Make Migrations

python manage.py makemigrations monitoring

🔨 Step 2.2 – Apply Migrations

python manage.py migrate

🔎 Result: Database এ monitoring_activitylog table create হবে।

---

✅ ৩. Admin Interface for Activity Logs

🔨 Step 3.1 – Register in monitoring/admin.py

from django.contrib import admin
from .models import Employee, ActivityLog

@admin.register(ActivityLog)
class ActivityLogAdmin(admin.ModelAdmin):
    # Admin table এ কোন কোন column দেখাবে
    list_display = ('id', 'employee', 'timestamp', 'active_window', 'website_url', 'idle_time_min')

    # Search field enable করবে
    search_fields = ('employee__name', 'active_window', 'website_url')

    # Filter sidebar
    list_filter = ('employee', 'timestamp')

    # Readonly fields (screenshot preview)
    readonly_fields = ('screenshot_preview',)

    # Custom method to show screenshot preview in admin
    def screenshot_preview(self, obj):
        if obj.screenshot:
            return f'<img src="{obj.screenshot.url}" width="200"/>'
        return 'No Screenshot'

    screenshot_preview.allow_tags = True
    screenshot_preview.short_description = 'Screenshot Preview'

---

🔎 Bangla Explanation:

• list_display → admin table columns
• search_fields → employee নাম, window, url search করতে পারবে
• list_filter → employee এবং timestamp filter
• readonly_fields + screenshot_preview → admin এ screenshot image preview

---

✅ ৪. Media URL serve configuration (for local testing)

🔨 Step 4.1 – Edit employee_monitoring/urls.py

from django.conf import settings
from django.conf.urls.static import static

urlpatterns = [
    # ... your other urls
]

# Local media file serve configuration
if settings.DEBUG:
    urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT)

---

📝 🔖 Summary of Part 3

✔️ ActivityLog Model তৈরি করেছো – professional scalable design
✔️ Migration apply করে database ready
✔️ Admin customization – screenshots সহ logs দেখা যাবে

---

🚀 ➡️ Next Step:

🔖 Part 4: Django REST API Development

1. DRF setup & configuration
2. Serializer design for Employee & ActivityLog
3. API endpoints to create ActivityLog (client data receive)
4. Retrieve logs filtered by employee and date range
5. Permission & token auth setup

👉 বলো “Start Part 4” – তাহলে আমরা API development শুরু করবো, যা Python client থেকে data receive করবে। Step by step full code + Bangla explanation থাকবে।