class Meal(models.Model):
    name = models.CharField(max_length=50)
    price = models.IntegerField()
    category_id = models.ForeignKey(to=MealCategories, on_delete=models.SET_NULL, null=True)
    description = models.CharField(max_length=50)

    class Meta:
        verbose_name = 'Meal'
        verbose_name_plural = 'Meals'

    def __str__(self):
        return self.name


class Order(models.Model):
    TABLE_STATUS = (
        (1, 'Свободен'),
        (2, 'Занят'),
    )
    id = models.IntegerField(primary_key=True)
    waiter = models.ForeignKey(Role, on_delete=models.SET_NULL, null=True)
    table = models.ForeignKey(Table, on_delete=models.SET_NULL, null=True)
    is_open = models.PositiveSmallIntegerField(choices=TABLE_STATUS, blank=True, null=True)
    date = models.DateField(blank=True, null=True)
    meals = models.ManyToManyField(Meal, through='MealToOrder')
    now = "Текущий заказ"

    class Meta:
        verbose_name = 'Order'
        verbose_name_plural = 'Orders'

    def __str__(self):
        return self.now


class Check(models.Model):
    order = models.ForeignKey(Order, on_delete=models.SET_NULL, null=True)
    date = models.DateTimeField(blank=True, null=True)
    service_fee = models.ForeignKey(ServicePercentage, on_delete=models.SET_NULL, null=True)
    meals = models.ManyToManyField(Meal, through='MealToOrder')
    total_sum = models.FloatField(null=True)

    class Meta:
        verbose_name = 'Check'
        verbose_name_plural = 'Checks'

    def __str__(self):
        return self.date.strftime('%H : %M') + ' Заказ закрыт'


class MealToOrder(models.Model):
    uniqueid = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    meal_to_order = models.ForeignKey(Meal, on_delete=models.CASCADE, null=True)
    order_to_meal = models.ForeignKey(Order, on_delete=models.CASCADE, null=True)
    check_to_order = models.ForeignKey(Check, on_delete=models.CASCADE, null=True)
    count = models.IntegerField(default=1)
    name = "Итого"

    class Meta:
        verbose_name = 'MealToOrder'
        verbose_name_plural = 'MealToOrders'

    def __str__(self):
        return self.name