from django.db import models
from django.db.models.deletion import CASCADE, PROTECT
from simple_history.models import HistoricalRecords
from django.utils.html import mark_safe
from django.core.validators import MinValueValidator
from import_export import resources


class SapItem(models.Model):
    sap_id = models.IntegerField(default=None, blank=True, null=True)
    name = models.CharField(max_length=60, default=None, blank=True, null=True)
    description = models.CharField(max_length=60, default=None, blank=True, null=True)
    inventory_id = models.IntegerField(default=None, blank=True, null=True)
    serial_nbr = models.CharField(max_length=30, default=None, blank=True, null=True)
    owner = models.CharField(max_length=60, default=None, blank=True, null=True)

    history = HistoricalRecords()

    class Meta:
        unique_together = (
            "id",
            "sap_id",
        )

    def __str__(self):
        return self.name


class SapItemResource(resources.ModelResource):
    class Meta:
        fields = (
            "id",
            "sap_id",
            "name",
            "description",
            "inventory_id",
            "serial_nbr",
            "owner",
        )
        model = SapItem