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

class SupplyChainData(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    
    input_kode = models.CharField(max_length=50, null=True, blank=True)
    product_name = models.CharField(max_length=255)
    category_name = models.CharField(max_length=100, null=True, blank=True)
    
    # Kolom untuk Data K-Means & Operasional
    sales = models.FloatField(default=0)
    quantity = models.IntegerField(default=0)
    
    stok_awal = models.IntegerField(default=0)
    pembelian = models.IntegerField(default=0)
    penjualan = models.IntegerField(default=0)
    stok_akhir = models.IntegerField(default=0)
    
    order_status = models.CharField(max_length=50, default='Completed')
    upload_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return f"{self.product_name} - {self.user.username}"