ডাটাবেজ ডিজাইন

python manage.py startapp production_planning

from django.db import models
from order_management.models import Order  # Order মডেল ইম্পোর্ট

# লাইন প্ল্যানিং মডেল
class LinePlanning(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE, verbose_name="Order")
    line_no = models.CharField(max_length=50, verbose_name="Line Number")
    start_date = models.DateField(verbose_name="Start Date")
    end_date = models.DateField(verbose_name="End Date")
    planned_quantity = models.PositiveIntegerField(verbose_name="Planned Quantity")

    class Meta:
        verbose_name = "Line Planning"
        verbose_name_plural = "Line Plannings"

    def __str__(self):
        return f"{self.line_no} ({self.order.style_name})"

# মেশিন বরাদ্দ মডেল
class MachineAllocation(models.Model):
    line_no = models.CharField(max_length=50, verbose_name="Line Number")
    machine_type = models.CharField(max_length=100, verbose_name="Machine Type")
    quantity = models.PositiveIntegerField(verbose_name="Quantity")

    class Meta:
        verbose_name = "Machine Allocation"
        verbose_name_plural = "Machine Allocations"

    def __str__(self):
        return f"{self.machine_type} ({self.line_no})"

# অপারেটর নিয়োগ মডেল
class OperatorAssignment(models.Model):
    SHIFT_CHOICES = (
        ('A', 'Shift A'),
        ('B', 'Shift B'),
        ('C', 'Shift C'),
    )

    name = models.CharField(max_length=100, verbose_name="Name")
    skill = models.CharField(max_length=100, verbose_name="Skill")
    assigned_line = models.CharField(max_length=50, verbose_name="Assigned Line")
    shift = models.CharField(max_length=10, choices=SHIFT_CHOICES, verbose_name="Shift")

    class Meta:
        verbose_name = "Operator Assignment"
        verbose_name_plural = "Operator Assignments"

    def __str__(self):
        return f"{self.name} ({self.assigned_line})"

# টার্গেট বনাম অর্জন মডেল
class TargetVsAchievement(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE, verbose_name="Order")
    date = models.DateField(verbose_name="Date")
    target_qty = models.PositiveIntegerField(verbose_name="Target Quantity")
    actual_qty = models.PositiveIntegerField(verbose_name="Actual Quantity")
    remarks = models.TextField(blank=True, verbose_name="Remarks")

    class Meta:
        verbose_name = "Target vs Achievement"
        verbose_name_plural = "Target vs Achievements"

    def __str__(self):
        return f"{self.order.style_name} - {self.date}"

from django.contrib import admin
from unfold.admin import ModelAdmin
from .models import LinePlanning, MachineAllocation, OperatorAssignment, TargetVsAchievement

# লাইন প্ল্যানিং মডেল রেজিস্টার
@admin.register(LinePlanning)
class LinePlanningAdmin(ModelAdmin):
    list_display = ('line_no', 'order', 'start_date', 'end_date', 'planned_quantity')
    search_fields = ('line_no', 'order__style_name')
    list_filter = ('start_date', 'end_date')
    ordering = ('-start_date',)

# মেশিন বরাদ্দ মডেল রেজিস্টার
@admin.register(MachineAllocation)
class MachineAllocationAdmin(ModelAdmin):
    list_display = ('line_no', 'machine_type', 'quantity')
    search_fields = ('line_no', 'machine_type')
    list_filter = ('machine_type',)
    ordering = ('line_no',)

# অপারেটর নিয়োগ মডেল রেজিস্টার
@admin.register(OperatorAssignment)
class OperatorAssignmentAdmin(ModelAdmin):
    list_display = ('name', 'skill', 'assigned_line', 'shift')
    search_fields = ('name', 'skill', 'assigned_line')
    list_filter = ('shift', 'skill')
    ordering = ('name',)

# টার্গেট বনাম অর্জন মডেল রেজিস্টার
@admin.register(TargetVsAchievement)
class TargetVsAchievementAdmin(ModelAdmin):
    list_display = ('order', 'date', 'target_qty', 'actual_qty', 'remarks')
    search_fields = ('order__style_name', 'remarks')
    list_filter = ('date',)
    ordering = ('-date',)

from django.templatetags.static import static
from django.urls import reverse_lazy

INSTALLED_APPS = [
    'unfold',
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'order_management',
    'sampling_merchandising',
    'production_planning',  # নতুন অ্যাপ যুক্ত
]

MEDIA_URL = '/media/'
MEDIA_ROOT = 'media'

STATIC_URL = '/static/'
STATICFILES_DIRS = ['static']

UNFOLD = {
    "SITE_TITLE": "Kreatech ERP",
    "SITE_HEADER": "Kreatech ERP",
    "SITE_LOGO": static("path/to/your/custom-logo.svg"),
    "SITE_URL": "/",
    "SHOW_HISTORY": False,
    "SIDEBAR": {
        "show_search": True,
        "show_all_applications": False,
        "navigation": [
            {
                "title": "Data and Analytics",
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": "Dashboard",
                        "icon": "dashboard",
                        "link": reverse_lazy("admin:index"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
            {
                "title": "Authentication",
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": "Users",
                        "icon": "people",
                        "link": reverse_lazy("admin:auth_user_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Groups",
                        "icon": "group",
                        "link": reverse_lazy("admin:auth_group_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Permissions",
                        "icon": "lock",
                        "link": reverse_lazy("admin:auth_permission_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
            {
                "title": "Order Management",
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": "Buyers",
                        "icon": "business",
                        "link": reverse_lazy("admin:order_management_buyer_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Orders",
                        "icon": "shopping_cart",
                        "link": reverse_lazy("admin:order_management_order_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Order Breakdowns",
                        "icon": "list_alt",
                        "link": reverse_lazy("admin:order_management_orderbreakdown_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Tech Packs",
                        "icon": "description",
                        "link": reverse_lazy("admin:order_management_techpack_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Delivery Schedules",
                        "icon": "local_shipping",
                        "link": reverse_lazy("admin:order_management_deliveryschedule_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
            {
                "title": "Sampling and Merchandising",
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": "Samples",
                        "icon": "request_quote",
                        "link": reverse_lazy("admin:sampling_merchandising_sample_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Fabric Developments",
                        "icon": "texture",
                        "link": reverse_lazy("admin:sampling_merchandising_fabricdevelopment_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Trim Developments",
                        "icon": "category",
                        "link": reverse_lazy("admin:sampling_merchandising_trimdevelopment_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Costings",
                        "icon": "calculate",
                        "link": reverse_lazy("admin:sampling_merchandising_costing_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
            {
                "title": "Production Planning",
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": "Line Planning",
                        "icon": "view_timeline",
                        "link": reverse_lazy("admin:production_planning_lineplanning_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Machine Allocation",
                        "icon": "build",
                        "link": reverse_lazy("admin:production_planning_machineallocation_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Operator Assignment",
                        "icon": "engineering",
                        "link": reverse_lazy("admin:production_planning_operatorassignment_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": "Target vs Achievement",
                        "icon": "trending_up",
                        "link": reverse_lazy("admin:production_planning_targetvsachievement_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
        ],
    },
}

from django.contrib import admin
from django.urls import path
from django.conf import settings
from django.conf.urls.static import static
from django.shortcuts import redirect

def redirect_to_admin(request):
    return redirect('admin:index')

urlpatterns = [
    path('', redirect_to_admin, name='home'),
    path('admin/', admin.site.urls),
] + static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT)

mkdir -p media/techpacks

python manage.py makemigrations
python manage.py migrate

from django.core.management.base import BaseCommand
from order_management.models import Buyer, Order
from production_planning.models import LinePlanning, MachineAllocation, OperatorAssignment, TargetVsAchievement

class Command(BaseCommand):
    help = 'Populates sample data for Production Planning module'

    def handle(self, *args, **kwargs):
        # Create Buyer
        buyer, _ = Buyer.objects.get_or_create(
            name="Zara",
            country="Spain",
            contact_person="Maria Lopez",
            phone="+3467890",
            email="maria@zara.com"
        )

        # Create Order
        order, _ = Order.objects.get_or_create(
            buyer=buyer,
            style_name="ZARA-TSHIRT-RED-2025",
            quantity=10000,
            sizes="S,M,L,XL",
            colors="Red",
            delivery_date="2025-09-30",
            order_date="2025-08-01",
            status="received",
            remarks="Urgent order"
        )

        # Create Line Planning
        LinePlanning.objects.get_or_create(
            order=order,
            line_no="Line 3",
            start_date="2025-09-01",
            end_date="2025-09-20",
            planned_quantity=10000
        )

        # Create Machine Allocation
        MachineAllocation.objects.get_or_create(
            line_no="Line 3",
            machine_type="Single Needle",
            quantity=5
        )
        MachineAllocation.objects.get_or_create(
            line_no="Line 3",
            machine_type="Overlock",
            quantity=2
        )
        MachineAllocation.objects.get_or_create(
            line_no="Line 3",
            machine_type="Flatlock",
            quantity=1
        )

        # Create Operator Assignment
        OperatorAssignment.objects.get_or_create(
            name="Salma",
            skill="Single Needle",
            assigned_line="Line 3",
            shift="A"
        )
        OperatorAssignment.objects.get_or_create(
            name="Raju",
            skill="Overlock",
            assigned_line="Line 3",
            shift="A"
        )
        OperatorAssignment.objects.get_or_create(
            name="Mariam",
            skill="Flatlock",
            assigned_line="Line 3",
            shift="A"
        )
        OperatorAssignment.objects.get_or_create(
            name="Jabbar",
            skill="Helper",
            assigned_line="Line 3",
            shift="A"
        )

        # Create Target vs Achievement
        TargetVsAchievement.objects.get_or_create(
            order=order,
            date="2025-09-01",
            target_qty=1000,
            actual_qty=900,
            remarks="Machine issue"
        )
        TargetVsAchievement.objects.get_or_create(
            order=order,
            date="2025-09-02",
            target_qty=1000,
            actual_qty=1050,
            remarks="Good performance"
        )
        TargetVsAchievement.objects.get_or_create(
            order=order,
            date="2025-09-03",
            target_qty=1000,
            actual_qty=970,
            remarks=""
        )

        self.stdout.write(self.style.SUCCESS('Sample data populated successfully!'))

python manage.py populate_sample_data

   python manage.py runserver