গল্প

[ABC Buyer: Order] → [Nahid: OrderStyle ABC-NAVY-TSHIRT-2025] → [Asif: GoodsIssue IS-2025-0001 from Factory B] → [Rubel: LinePlanning Line 1 & Line 2] → [Mizan: MachineAllocation & OperatorAssignment] → [Tania: TargetVsAchievement & Production Report] → [Asif: New GoodsIssue IS-2025-0002]

from django.db import models
from django.contrib.auth.models import User
from order_management.models import OrderStyle

class LinePlanning(models.Model):
    STATUS_CHOICES = (
        ('planned', 'Planned'),
        ('active', 'Active'),
        ('completed', 'Completed'),
    )

    style = models.ForeignKey(OrderStyle, on_delete=models.CASCADE, verbose_name="Style")
    line_name = models.CharField(max_length=100, verbose_name="Line Name")
    target_quantity = models.IntegerField(verbose_name="Target Quantity")
    daily_target = models.IntegerField(verbose_name="Daily Target")
    start_date = models.DateField(verbose_name="Start Date")
    end_date = models.DateField(verbose_name="End Date")
    status = models.CharField(max_length=20, choices=STATUS_CHOICES, default='planned', verbose_name="Status")
    created_by = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, verbose_name="Created By")

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

    def __str__(self):
        return f"{self.line_name} - {self.style.style_name}"

class MachineAllocation(models.Model):
    MACHINE_TYPE_CHOICES = (
        ('sewing', 'Sewing'),
        ('cutting', 'Cutting'),
        ('finishing', 'Finishing'),
    )

    line_planning = models.ForeignKey(LinePlanning, on_delete=models.CASCADE, verbose_name="Line Planning")
    machine_type = models.CharField(max_length=20, choices=MACHINE_TYPE_CHOICES, verbose_name="Machine Type")
    quantity = models.IntegerField(verbose_name="Quantity")
    allocation_date = models.DateField(verbose_name="Allocation Date")
    remarks = models.TextField(blank=True, verbose_name="Remarks")

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

    def __str__(self):
        return f"{self.machine_type} - {self.line_planning.line_name}"

class OperatorAssignment(models.Model):
    ROLE_CHOICES = (
        ('sewing', 'Sewing'),
        ('cutting', 'Cutting'),
        ('finishing', 'Finishing'),
    )

    line_planning = models.ForeignKey(LinePlanning, on_delete=models.CASCADE, verbose_name="Line Planning")
    operator_name = models.CharField(max_length=100, verbose_name="Operator Name")
    role = models.CharField(max_length=20, choices=ROLE_CHOICES, verbose_name="Role")
    assignment_date = models.DateField(verbose_name="Assignment Date")
    remarks = models.TextField(blank=True, verbose_name="Remarks")

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

    def __str__(self):
        return f"{self.operator_name} - {self.line_planning.line_name}"

class TargetVsAchievement(models.Model):
    line_planning = models.ForeignKey(LinePlanning, on_delete=models.CASCADE, verbose_name="Line Planning")
    date = models.DateField(verbose_name="Date")
    target_quantity = models.IntegerField(verbose_name="Target Quantity")
    achieved_quantity = models.IntegerField(verbose_name="Achieved Quantity")
    remarks = models.TextField(blank=True, verbose_name="Remarks")
    reported_by = models.ForeignKey(User, on_delete=models.SET_NULL, null=True, verbose_name="Reported By")

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

    def __str__(self):
        return f"{self.line_planning.line_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_name', 'style', 'target_quantity', 'daily_target', 'start_date', 'end_date', 'status', 'created_by')
    search_fields = ('line_name', 'style__style_name')
    list_filter = ('status', 'start_date', 'end_date')
    ordering = ('-start_date',)

@admin.register(MachineAllocation)
class MachineAllocationAdmin(ModelAdmin):
    list_display = ('line_planning', 'machine_type', 'quantity', 'allocation_date', 'remarks')
    search_fields = ('line_planning__line_name', 'machine_type')
    list_filter = ('machine_type', 'allocation_date')
    ordering = ('-allocation_date',)

@admin.register(OperatorAssignment)
class OperatorAssignmentAdmin(ModelAdmin):
    list_display = ('line_planning', 'operator_name', 'role', 'assignment_date', 'remarks')
    search_fields = ('operator_name', 'line_planning__line_name')
    list_filter = ('role', 'assignment_date')
    ordering = ('-assignment_date',)

@admin.register(TargetVsAchievement)
class TargetVsAchievementAdmin(ModelAdmin):
    list_display = ('line_planning', 'date', 'target_quantity', 'achieved_quantity', 'reported_by', 'remarks')
    search_fields = ('line_planning__line_name', 'reported_by__username')
    list_filter = ('date', 'line_planning')
    ordering = ('-date',)

"""
Django settings for config project.

Generated by 'django-admin startproject' using Django 5.2.4.

For more information on this file, see
https://docs.djangoproject.com/en/5.2/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/5.2/ref/settings/
"""

from pathlib import Path
from django.templatetags.static import static
from django.urls import reverse_lazy
from django.utils.translation import gettext_lazy as _

# Build paths inside the project like this: BASE_DIR / 'subdir'.
BASE_DIR = Path(__file__).resolve().parent.parent

# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/5.2/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = 'django-insecure-d&5pro-b^j#$qo7amy26x$%5$+@-zim%mg9nl@px68(apvg@c7'

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

ALLOWED_HOSTS = []

# Application definition
INSTALLED_APPS = [
    "unfold",
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'custom_auth',
    'order_management',
    'sampling_merchandising',
    'production_planning',
    'procurement',
    'inventory',
]

MIDDLEWARE = [
    'django.middleware.security.SecurityMiddleware',
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',
    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
]

ROOT_URLCONF = 'config.urls'

TEMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': [],
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.request',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },
]

WSGI_APPLICATION = 'config.wsgi.application'

# Database
# https://docs.djangoproject.com/en/5.2/ref/settings/#databases
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

# Password validation
# https://docs.djangoproject.com/en/5.2/ref/settings/#auth-password-validators
AUTH_PASSWORD_VALIDATORS = [
    {
        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',
    },
]

# Internationalization
# https://docs.djangoproject.com/en/5.2/topics/i18n/
LANGUAGE_CODE = 'en-us'
TIME_ZONE = 'UTC'
USE_I18N = True
USE_TZ = True

# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/5.2/howto/static-files/
STATIC_URL = '/static/'
STATICFILES_DIRS = [BASE_DIR / "static"]
STATIC_ROOT = BASE_DIR / "staticfiles"

# Default primary key field type
# https://docs.djangoproject.com/en/5.2/ref/settings/#default-auto-field
DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField'

UNFOLD = {
    "SITE_TITLE": "GarmrntsErp",
    "SITE_HEADER": "GarmrntsErp Dashboard",
    "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 Styles"),
                        "icon": "style",
                        "link": reverse_lazy("admin:order_management_orderstyle_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": _("Sample Requests"),
                        "icon": "request_quote",
                        "link": reverse_lazy("admin:sampling_merchandising_samplerequest_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Sample Trackings"),
                        "icon": "local_shipping",
                        "link": reverse_lazy("admin:sampling_merchandising_sampletracking_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": _("Costing Sheets"),
                        "icon": "calculate",
                        "link": reverse_lazy("admin:sampling_merchandising_costingsheet_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Consumption Calculations"),
                        "icon": "scale",
                        "link": reverse_lazy("admin:sampling_merchandising_consumptioncalculation_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Follow Up Notes"),
                        "icon": "notes",
                        "link": reverse_lazy("admin:sampling_merchandising_followupnote_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
            {
                "title": _("Procurement & Purchase"),
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": _("Suppliers"),
                        "icon": "business",
                        "link": reverse_lazy("admin:procurement_supplier_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Purchase Requisitions"),
                        "icon": "request_page",
                        "link": reverse_lazy("admin:procurement_purchaserequisition_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Purchase Orders"),
                        "icon": "shopping_bag",
                        "link": reverse_lazy("admin:procurement_purchaseorder_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Goods Receive Notes"),
                        "icon": "inventory",
                        "link": reverse_lazy("admin:procurement_goodsreceivenote_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("PO Tracking"),
                        "icon": "track_changes",
                        "link": reverse_lazy("admin:procurement_potracking_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                ],
            },
            {
                "title": _("Inventory Management"),
                "separator": True,
                "collapsible": True,
                "items": [
                    {
                        "title": _("Warehouses"),
                        "icon": "warehouse",
                        "link": reverse_lazy("admin:inventory_warehouse_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Items"),
                        "icon": "inventory_2",
                        "link": reverse_lazy("admin:inventory_item_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Warehouse Stocks"),
                        "icon": "store",
                        "link": reverse_lazy("admin:inventory_itemwarehousestock_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Transactions"),
                        "icon": "swap_horiz",
                        "link": reverse_lazy("admin:inventory_transaction_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Inventory Transfers"),
                        "icon": "local_shipping",
                        "link": reverse_lazy("admin:inventory_inventorytransfer_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Goods Receipts"),
                        "icon": "archive",
                        "link": reverse_lazy("admin:inventory_goodsreceipt_changelist"),
                        "permission": lambda request: request.user.is_superuser,
                    },
                    {
                        "title": _("Goods Issues"),
                        "icon": "assignment_turned_in",
                        "link": reverse_lazy("admin:inventory_goodsissue_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,
                    },
                ],
            },
        ],
    },
}

[
    {
        "model": "auth.user",
        "pk": 8,
        "fields": {
            "username": "rubel",
            "first_name": "Rubel",
            "last_name": "",
            "email": "rubel@example.com",
            "password": "pbkdf2_sha256$260000$randomsalt$hashedpassword",
            "is_staff": true,
            "is_active": true
        }
    },
    {
        "model": "auth.user",
        "pk": 9,
        "fields": {
            "username": "mizan",
            "first_name": "Mizan",
            "last_name": "",
            "email": "mizan@example.com",
            "password": "pbkdf2_sha256$260000$randomsalt$hashedpassword",
            "is_staff": true,
            "is_active": true
        }
    },
    {
        "model": "auth.user",
        "pk": 10,
        "fields": {
            "username": "tania",
            "first_name": "Tania",
            "last_name": "",
            "email": "tania@example.com",
            "password": "pbkdf2_sha256$260000$randomsalt$hashedpassword",
            "is_staff": true,
            "is_active": true
        }
    },
    {
        "model": "production_planning.lineplanning",
        "pk": 1,
        "fields": {
            "style": 1,
            "line_name": "Line 1",
            "target_quantity": 10000,
            "daily_target": 1000,
            "start_date": "2025-08-18",
            "end_date": "2025-08-28",
            "status": "active",
            "created_by": 8
        }
    },
    {
        "model": "production_planning.lineplanning",
        "pk": 2,
        "fields": {
            "style": 1,
            "line_name": "Line 2",
            "target_quantity": 10000,
            "daily_target": 1000,
            "start_date": "2025-08-18",
            "end_date": "2025-08-28",
            "status": "active",
            "created_by": 8
        }
    },
    {
        "model": "production_planning.machineallocation",
        "pk": 1,
        "fields": {
            "line_planning": 1,
            "machine_type": "sewing",
            "quantity": 10,
            "allocation_date": "2025-08-18",
            "remarks": "For Line 1, ABC-NAVY-TSHIRT-2025"
        }
    },
    {
        "model": "production_planning.machineallocation",
        "pk": 2,
        "fields": {
            "line_planning": 1,
            "machine_type": "cutting",
            "quantity": 2,
            "allocation_date": "2025-08-18",
            "remarks": "For Line 1, ABC-NAVY-TSHIRT-2025"
        }
    },
    {
        "model": "production_planning.machineallocation",
        "pk": 3,
        "fields": {
            "line_planning": 2,
            "machine_type": "sewing",
            "quantity": 8,
            "allocation_date": "2025-08-18",
            "remarks": "For Line 2, ABC-NAVY-TSHIRT-2025"
        }
    },
    {
        "model": "production_planning.machineallocation",
        "pk": 4,
        "fields": {
            "line_planning": 2,
            "machine_type": "cutting",
            "quantity": 2,
            "allocation_date": "2025-08-18",
            "remarks": "For Line 2, ABC-NAVY-TSHIRT-2025"
        }
    },
    {
        "model": "production_planning.operatorassignment",
        "pk": 1,
        "fields": {
            "line_planning": 1,
            "operator_name": "Rahim",
            "role": "sewing",
            "assignment_date": "2025-08-18",
            "remarks": "Assigned to Line 1"
        }
    },
    {
        "model": "production_planning.operatorassignment",
        "pk": 2,
        "fields": {
            "line_planning": 1,
            "operator_name": "Karim",
            "role": "cutting",
            "assignment_date": "2025-08-18",
            "remarks": "Assigned to Line 1"
        }
    },
    {
        "model": "production_planning.operatorassignment",
        "pk": 3,
        "fields": {
            "line_planning": 2,
            "operator_name": "Sumi",
            "role": "sewing",
            "assignment_date": "2025-08-18",
            "remarks": "Assigned to Line 2"
        }
    },
    {
        "model": "production_planning.operatorassignment",
        "pk": 4,
        "fields": {
            "line_planning": 2,
            "operator_name": "Rashed",
            "role": "cutting",
            "assignment_date": "2025-08-18",
            "remarks": "Assigned to Line 2"
        }
    },
    {
        "model": "production_planning.targetvsachievement",
        "pk": 1,
        "fields": {
            "line_planning": 1,
            "date": "2025-08-18",
            "target_quantity": 1000,
            "achieved_quantity": 950,
            "remarks": "Line 1, slightly below target",
            "reported_by": 10
        }
    },
    {
        "model": "production_planning.targetvsachievement",
        "pk": 2,
        "fields": {
            "line_planning": 2,
            "date": "2025-08-18",
            "target_quantity": 1000,
            "achieved_quantity": 900,
            "remarks": "Line 2, needs improvement",
            "reported_by": 10
        }
    },
    {
        "model": "inventory.goodsissue",
        "pk": 2,
        "fields": {
            "issue_id": "IS-2025-0002",
            "item": 1,
            "warehouse": 2,
            "quantity": 1000.00,
            "unit": "meter",
            "issue_date": "2025-08-19",
            "status": "pending",
            "approved_by": 6,
            "style": 1,
            "remarks": "For next production batch"
        }
    }
]

   python manage.py makemigrations
   python manage.py migrate

   python manage.py loaddata fixtures/production_planning_sample_data

   python manage.py runserver