from django.db import models from userapp.models import ParadiseUser import uuid # Create your models here. class DeviceType(models.Model): """设备类型""" name = models.CharField('类型名称', max_length=100, unique=True) code = models.CharField('类型代码', max_length=10, unique=True) description = models.TextField('类型描述', blank=True, null=True) created_at = models.DateTimeField('创建时间', auto_now_add=True) updated_at = models.DateTimeField('更新时间', auto_now=True) class Meta: verbose_name = '设备类型' verbose_name_plural = '设备类型' ordering = ['name'] def __str__(self): return f"{self.name} ({self.code})" class DeviceBatch(models.Model): """设备批次""" device_type = models.ForeignKey(DeviceType, on_delete=models.CASCADE, verbose_name='设备类型', related_name='batches') batch_number = models.CharField('批次号', max_length=20, unique=True) production_date = models.DateField('生产日期') quantity = models.PositiveIntegerField('数量') description = models.TextField('批次描述', blank=True, null=True) created_at = models.DateTimeField('创建时间', auto_now_add=True) updated_at = models.DateTimeField('更新时间', auto_now=True) class Meta: verbose_name = '设备批次' verbose_name_plural = '设备批次' ordering = ['-production_date'] def __str__(self): return f"{self.device_type.name} - {self.batch_number}" class Device(models.Model): """设备表""" device_type = models.ForeignKey(DeviceType, on_delete=models.CASCADE, verbose_name='设备类型', related_name='devices') batch = models.ForeignKey(DeviceBatch, on_delete=models.CASCADE, verbose_name='设备批次', related_name='devices') serial_number = models.CharField('序列号', max_length=50) device_code = models.CharField('设备码', max_length=100, unique=True) mac_address = models.CharField('MAC地址', max_length=17, unique=True) is_active = models.BooleanField('是否激活', default=False) activated_at = models.DateTimeField('激活时间', null=True, blank=True) # 设备状态信息 STATUS_CHOICES = ( ('connected', '已连接'), ('disconnected', '未连接'), ) status = models.CharField('设备状态', max_length=20, choices=STATUS_CHOICES, default='disconnected') battery_level = models.IntegerField('电量', default=0, help_text='电池电量百分比(0-100)') firmware_version = models.CharField('固件版本号', max_length=50, blank=True, null=True) # WiFi设置 wifi_name = models.CharField('WiFi名称', max_length=100, blank=True, null=True) wifi_password = models.CharField('WiFi密码', max_length=100, blank=True, null=True) # 设备设置 brightness = models.IntegerField('亮度', default=50, help_text='屏幕亮度(0-100)') created_at = models.DateTimeField('创建时间', auto_now_add=True) updated_at = models.DateTimeField('更新时间', auto_now=True) class Meta: verbose_name = '设备' verbose_name_plural = '设备' ordering = ['-created_at'] unique_together = ['device_type', 'batch', 'serial_number'] def __str__(self): return self.device_code def save(self, *args, **kwargs): # 如果没有设备码,自动生成 if not self.device_code: self.device_code = self.generate_device_code() super().save(*args, **kwargs) def generate_device_code(self): """生成唯一设备码""" # 格式: 类型代码-批次号-序列号 return f"{self.device_type.code}-{self.batch.batch_number}-{self.serial_number}" class UserDevice(models.Model): """用户设备关联表""" user = models.ForeignKey(ParadiseUser, on_delete=models.CASCADE, verbose_name='用户', related_name='devices') device = models.ForeignKey(Device, on_delete=models.CASCADE, verbose_name='设备', related_name='users') nickname = models.CharField('设备昵称', max_length=100, blank=True, null=True) bound_at = models.DateTimeField('绑定时间', auto_now_add=True) is_primary = models.BooleanField('是否主要设备', default=False) class Meta: verbose_name = '用户设备' verbose_name_plural = '用户设备' ordering = ['-bound_at'] unique_together = ['user', 'device'] def __str__(self): return f"{self.user.username} - {self.device.device_code}" def save(self, *args, **kwargs): # 如果是该用户的第一个设备,设为主要设备 if not UserDevice.objects.filter(user=self.user).exists(): self.is_primary = True # 如果设置为主要设备,取消其他设备的主要设备标记 if self.is_primary: UserDevice.objects.filter(user=self.user).update(is_primary=False) super().save(*args, **kwargs)