from django.db import models
# Create your models here.
from meiduo_mall.utils.models import BaseModel
class Area(models.Model):
    name=models.CharField(max_length=20,verbose_name="名称")
    parent=models.ForeignKey("self",on_delete=models.SET_NULL,related_name="subs",blank=True,null=True,verbose_name="上级行政区")

    class Meta:
        db_table="tb_areas"
        verbose_name="省市区"
        verbose_name_plural="省市区"

    def __str__(self):
        return self.name

class Address(BaseModel):
    #用户地址
    user=models.ForeignKey("users.User",on_delete=models.CASCADE,related_name="addresses",verbose_name="用户")
    title=models.CharField(max_length=20,verbose_name="地址名称",null=True)
    receiver=models.CharField(max_length=20,verbose_name="收货人")
    province=models.ForeignKey(Area,on_delete=models.PROTECT,related_name="province_addresses",verbose_name="省")
    city=models.ForeignKey(Area,on_delete=models.PROTECT,related_name="city_addresses",verbose_name="市")
    district=models.ForeignKey(Area,on_delete=models.PROTECT,related_name="district_addresses",verbose_name="区")
    place=models.CharField(max_length=50,verbose_name="地址")
    mobile=models.CharField(max_length=11,verbose_name="手机")
    tel=models.CharField(max_length=20,null=True,blank=True,default="",verbose_name="固定电话")
    email=models.CharField(max_length=30,null=True,blank=True,default="",verbose_name="电子邮箱")
    is_delete=models.BooleanField(default=False,verbose_name="逻辑删除")

    class Meta:
        db_table="tb_address"
        verbose_name="用户地址"
        verbose_name_plural=verbose_name
        ordering=["-update_time"]