|
# -*- coding: utf-8 -*-
from django.conf import settings
from django.db import models
from django.utils.translation import ugettext_lazy as _
from django_models_ext import BaseModelMixin, upload_file_url, upload_path
from shortuuidfield import ShortUUIDField
from jsonfield import JSONField
from TimeConvert import TimeConvert as tc
from datetime import datetime
from django.utils import timezone
def to_local_iso(dt):
"""aware datetime → '2026-10-29T00:00:00+08:00'(北京时间 ISO,小程序直接 new Date 解析)"""
if not dt:
return None
return '%s+08:00' % tc.local_string(utc_dt=dt, format='%Y-%m-%dT%H:%M:%S')
class SalesResponsibilityInfo(BaseModelMixin):
REFUSED = -1
UNVERIFIED = 0
ACTIVATED = 1
DISABLED = 2
DELETED = 3
ASSIGN = 10
USER_STATUS_TUPLE = (
(REFUSED, u'已拒绝'),
(UNVERIFIED, u'未验证'),
(ACTIVATED, u'已激活'),
(DISABLED, u'已禁用'),
(DELETED, u'已删除'),
(ASSIGN, u'已分配'),
)
brand_id = models.CharField(_(u'brand_id'), max_length=32, blank=True, null=True, help_text=u'品牌唯一标识', db_index=True)
brand_name = models.CharField(_(u'brand_name'), max_length=255, blank=True, null=True, help_text=u'品牌名称')
sr_id = ShortUUIDField(_(u'sr_id'), max_length=32, blank=True, null=True, help_text=u'销售担当唯一标识', db_index=True, unique=True)
user_id = models.CharField(_(u'user_id'), max_length=32, blank=True, null=True, help_text=u'用户唯一标识', db_index=True)
unionid = models.CharField(_(u'unionid'), max_length=32, blank=True, null=True, help_text=u'微信 UnionID', db_index=True)
openid = models.CharField(_(u'openid'), max_length=32, blank=True, null=True, help_text=u'微信 OpenID', db_index=True)
name = models.CharField(_(u'name'), max_length=255, blank=True, null=True, help_text=u'销售担当姓名')
phone = models.CharField(_(u'phone'), max_length=11, blank=True, null=True, help_text=u'销售担当联系电话')
avatar = models.CharField(_(u'avatar'), max_length=255, blank=True, null=True, help_text=u'销售担当头像')
user_status = models.IntegerField(_(u'user_status'), choices=USER_STATUS_TUPLE, default=UNVERIFIED, help_text=u'用户状态', db_index=True)
refused_reason = models.TextField(_(u'refused_reason'), blank=True, null=True, help_text=u'审核拒绝原因')
is_auth = models.BooleanField(_(u'is_auth'), default=False, help_text=u'是否已授权')
is_super = models.BooleanField(_(u'is_super'), default=False, help_text=u'是否超级销售担当')
class Meta:
verbose_name = _(u'销售担当信息')
verbose_name_plural = _(u'销售担当信息')
unique_together = (
('unionid', 'brand_id'),
)
def __unicode__(self):
return u'{}-{}'.format(self.name, self.phone)
@property
def final_avatar(self):
return self.avatar and self.avatar.replace(settings.QINIU_FILE_URL_BEFORE, settings.QINIU_FILE_URL_AFTER).replace(settings.QINIU_FILE_URL_BEFORE2, settings.QINIU_FILE_URL_AFTER)
@property
def base_data(self):
return {
'sr_id': self.sr_id,
'is_sr': True,
'is_super': self.is_super,
}
@property
def admindata(self):
return {
'brand_id': self.brand_id,
'brand_name': self.brand_name,
'sr_id': self.sr_id,
'name': self.name,
'phone': self.phone,
'status': self.user_status,
'refused_reason': self.refused_reason,
'is_auth': self.is_auth,
}
data = admindata
class SalesResponsibilityInfoModelsSaleStatisticInfo(BaseModelMixin):
brand_id = models.CharField(_(u'brand_id'), max_length=32, blank=True, null=True, help_text=u'品牌唯一标识', db_index=True)
# 销售担当,供 SuperSalesResponsibilityInfoModelsSaleStatisticInfo 统计使用
sr_id = models.CharField(_(u'sr_id'), max_length=32, blank=True, null=True, help_text=u'销售担当唯一标识', db_index=True)
# 经销商
distributor_id = models.CharField(_(u'distributor_id'), max_length=32, help_text=u'经销商唯一标识', db_index=True)
distributor_name = models.CharField(_(u'distributor_name'), max_length=255, blank=True, null=True, help_text=u'经销商名称')
# 型号
model_id = models.CharField(_(u'model_id'), max_length=32, help_text=u'型号唯一标识', db_index=True)
model_name = models.CharField(_(u'model_name'), max_length=255, blank=True, null=True, help_text=u'型号名称', db_index=True)
is_important = models.BooleanField(_(u'is_important'), default=True, help_text=u'是否重要型号')
ymd = models.IntegerField(_(u'ymd'), default=0, help_text=u'年月日', db_index=True) # 例:20171208, tc.local_string(format='%Y%m%d'), 0 为全部
today_num = models.IntegerField(_(u'today_num'), default=0, help_text=u'支数(今日)')
yesterday_num = models.IntegerField(_(u'yesterday_num'), default=0, help_text=u'支数(昨日)')
current_month = models.IntegerField(_(u'current_month'), default=0, help_text=u'支数(本月)')
last_month = models.IntegerField(_(u'last_month'), default=0, help_text=u'支数(上月)')
position = models.IntegerField(_(u'position'), default=1, help_text=u'排序')
class Meta:
verbose_name = _(u'[销售担当]型号销量统计')
verbose_name_plural = _(u'[销售担当]型号销量统计')
def __unicode__(self):
return '%d' % self.pk
@property
def data(self):
return {
'model_id': self.model_id,
'model_name': self.model_name,
'is_important': self.is_important,
'today_num': self.today_num,
'yesterday_num': self.yesterday_num,
'current_month': self.current_month,
'last_month': self.last_month,
}
class SuperSalesResponsibilityInfoModelsSaleStatisticInfo(BaseModelMixin):
brand_id = models.CharField(_(u'brand_id'), max_length=32, blank=True, null=True, help_text=u'品牌唯一标识', db_index=True)
# 销售担当
sr_id = models.CharField(_(u'sr_id'), max_length=32, blank=True, null=True, help_text=u'销售担当唯一标识', db_index=True)
sr_name = models.CharField(_(u'sr_name'), max_length=255, blank=True, null=True, help_text=u'销售担当名称')
sr_avatar = models.CharField(_(u'sr_avatar'), max_length=255, blank=True, null=True, help_text=u'销售担当头像')
ymd = models.IntegerField(_(u'ymd'), default=0, help_text=u'年月日', db_index=True) # 例:20171208, tc.local_string(format='%Y%m%d'), 0 为全部
today_num = models.IntegerField(_(u'today_num'), default=0, help_text=u'支数(今日)')
yesterday_num = models.IntegerField(_(u'yesterday_num'), default=0, help_text=u'支数(昨日)')
current_month = models.IntegerField(_(u'current_month'), default=0, help_text=u'支数(本月)')
last_month = models.IntegerField(_(u'last_month'), default=0, help_text=u'支数(上月)')
position = models.IntegerField(_(u'position'), default=1, help_text=u'排序')
class Meta:
verbose_name = _(u'[超级销售担当]销售担当销量统计')
verbose_name_plural = _(u'[超级销售担当]销售担当销量统计')
def __unicode__(self):
return '%d' % self.pk
@property
def data(self):
return {
'sr_id': self.sr_id,
'sr_name': self.sr_name,
'sr_avatar': self.sr_avatar,
'today_num': self.today_num,
'yesterday_num': self.yesterday_num,
'current_month': self.current_month,
'last_month': self.last_month,
}
class LotteryCampaignQuerySet(models.QuerySet):
"""抽奖活动查询集"""
def active(self):
"""有效活动:后台停用(status=False)的不算"""
return self.filter(status=True)
class LotteryCampaignInfo(BaseModelMixin):
"""抽奖活动"""
objects = LotteryCampaignQuerySet.as_manager()
campaign_id = ShortUUIDField(_(u'campaign_id'), max_length=32, blank=True, null=True,
help_text=u'活动唯一标识', db_index=True, unique=True)
title = models.CharField(_(u'title'), max_length=255, help_text=u'活动标题')
prize_text = models.CharField(_(u'prize_text'), max_length=255, blank=True, null=True,
help_text=u'奖品文案,如「2,000 元京东卡 × 3 名」')
start_at = models.DateTimeField(_(u'start_at'), blank=True, null=True, help_text=u'参与开始时间')
end_at = models.DateTimeField(_(u'end_at'), blank=True, null=True, help_text=u'参与结束时间')
draw_at = models.DateTimeField(_(u'draw_at'), blank=True, null=True, help_text=u'开奖时间', db_index=True)
model_ids = JSONField(_(u'model_ids'), blank=True, null=True, help_text=u'参与型号列表')
class Meta:
verbose_name = _(u'抽奖活动')
verbose_name_plural = _(u'抽奖活动')
ordering = ('-created_at',)
def __unicode__(self):
return u'{}'.format(self.title or self.campaign_id or '')
def is_active(self):
now = timezone.now() # ← aware,和 DB 值可比
return bool(self.start_at and self.end_at and self.start_at <= now <= self.end_at)
def is_locked(self):
"""已到开奖时间:报名信息锁定,只能改收货信息"""
return bool(self.draw_at and timezone.now() >= self.draw_at)
@property
def data(self):
return {
'campaign_id': self.campaign_id,
'title': self.title,
'prize_text': self.prize_text or '',
'start_at': to_local_iso(self.start_at),
'end_at': to_local_iso(self.end_at),
'draw_at': to_local_iso(self.draw_at),
'model_ids': self.model_ids,
}
def list_data(self, entries):
"""「我的抽奖」列表项:活动维度,不含名额明细"""
return {
'campaign_id': self.campaign_id,
'title': self.title,
'draw_at': to_local_iso(self.draw_at),
'prize_text': self.prize_text or '',
'entry_count': len(entries),
'status': LotteryEntryInfo.summary_status(entries),
}
def detail_data(self, entries, address=None):
"""活动详情:列表项 + 活动期 + 名额明细 + 报名 / 收货信息"""
name, phone = LotteryEntryInfo.latest_profile(entries)
data = self.list_data(entries)
data.update({
'start_at': to_local_iso(self.start_at),
'end_at': to_local_iso(self.end_at),
'entries': [entry.data for entry in entries],
'name': name,
'phone': phone,
'address': address.data if address else None,
'locked': self.is_locked(),
})
return data
class LotteryEntryQuerySet(models.QuerySet):
"""抽奖名额查询集"""
def of_user(self, user_id):
return self.filter(user_id=user_id, status=True)
def of_campaign(self, campaign_id):
return self.filter(campaign_id=campaign_id, status=True)
class LotteryEntryInfo(BaseModelMixin):
"""抽奖名单"""
PENDING = 'pending'
WON = 'won'
LOST = 'lost'
RESULT_TUPLE = (
(PENDING, u'待开奖'),
(WON, u'已中奖'),
(LOST, u'未中奖'),
)
objects = LotteryEntryQuerySet.as_manager()
entry_id = ShortUUIDField(_(u'entry_id'), max_length=32, blank=True, null=True,
help_text=u'名额唯一标识', db_index=True, unique=True)
campaign_id = models.CharField(_(u'campaign_id'), max_length=32,
help_text=u'所属活动唯一标识', db_index=True)
user_id = models.CharField(_(u'user_id'), max_length=32, blank=True, null=True,
help_text=u'用户唯一标识', db_index=True)
campaign_title = models.CharField(_(u'campaign_title'), max_length=255, blank=True, null=True,
help_text=u'活动标题', db_index=True)
name = models.CharField(_(u'name'), max_length=255, blank=True, null=True,
help_text=u'用户姓名', db_index=True)
phone = models.CharField(_(u'phone'), max_length=11, blank=True, null=True, help_text=u'用户手机', db_index=True)
serial_no = models.CharField(_(u'serial_no'), max_length=64, help_text=u'镜头序列号', db_index=True)
model_id = models.CharField(_(u'model_id'), max_length=64, blank=True, null=True,
help_text=u'型号唯一标识', db_index=True)
model_name = models.CharField(_(u'model_name'), max_length=64, blank=True, null=True,
help_text=u'型号名称', db_index=True)
submit_pk = models.CharField(_(u'submit_pk'), max_length=32, blank=True, null=True,
help_text=u'提交记录唯一标识', db_index=True)
result = models.CharField(_(u'result'), max_length=16, choices=RESULT_TUPLE, default=PENDING,
help_text=u'名额结果:待开奖 / 已中奖 / 未中奖', db_index=True)
class Meta:
verbose_name = _(u'抽奖名单')
verbose_name_plural = _(u'抽奖名单')
ordering = ('-created_at',)
unique_together = (
('campaign_id', 'serial_no', 'model_id', 'submit_pk'),
)
def __unicode__(self):
return u'{}-{}'.format(self.campaign_id, self.serial_no)
@classmethod
def summary_status(cls, entries):
"""多个名额汇总成一个活动状态:任一中奖即中奖;否则有未中奖结果即未中奖;否则待开奖"""
if any(entry.result == cls.WON for entry in entries):
return cls.WON
if any(entry.result == cls.LOST for entry in entries):
return cls.LOST
return cls.PENDING
@classmethod
def latest_profile(cls, entries):
"""报名信息:从名额里取最近一条有值的姓名 / 手机(entries 需按 created_at 倒序)"""
name = next((entry.name for entry in entries if entry.name), '')
phone = next((entry.phone for entry in entries if entry.phone), '')
return name, phone
@classmethod
def group_by_campaign(cls, entries):
"""名额按活动分组:{campaign_id: [entry, ...]}"""
grouped = {}
for entry in entries:
grouped.setdefault(entry.campaign_id, []).append(entry)
return grouped
@property
def data(self):
return {
'serial_no': self.serial_no,
'model_name': self.model_name or '',
'joined_at': to_local_iso(self.created_at),
'status': self.result or self.PENDING,
}
class LotteryAddressQuerySet(models.QuerySet):
"""抽奖收货信息查询集"""
def of_user_campaign(self, user_id, campaign_id):
return self.filter(user_id=user_id, campaign_id=campaign_id, status=True)
class LotteryAddressInfo(BaseModelMixin):
"""抽奖收货信息(活动级,一个用户在一个活动下一条)"""
objects = LotteryAddressQuerySet.as_manager()
campaign_id = models.CharField(_(u'campaign_id'), max_length=32,
help_text=u'所属活动唯一标识', db_index=True)
user_id = models.CharField(_(u'user_id'), max_length=32, blank=True, null=True,
help_text=u'用户唯一标识', db_index=True)
receiver = models.CharField(_(u'receiver'), max_length=64, blank=True, null=True, help_text=u'收货人')
phone = models.CharField(_(u'phone'), max_length=11, blank=True, null=True, help_text=u'收货手机')
region = models.CharField(_(u'region'), max_length=128, blank=True, null=True,
help_text=u'省 市 区,如「上海市 上海市 徐汇区」')
detail = models.CharField(_(u'detail'), max_length=255, blank=True, null=True, help_text=u'详细地址')
class Meta:
verbose_name = _(u'抽奖收货信息')
verbose_name_plural = _(u'抽奖收货信息')
ordering = ('-created_at',)
unique_together = (
('campaign_id', 'user_id'),
)
def __unicode__(self):
return u'{}-{}'.format(self.campaign_id, self.receiver or '')
@property
def data(self):
return {
'receiver': self.receiver or '',
'phone': self.phone or '',
'region': self.region or '',
'detail': self.detail or '',
}
|