Няма описание

models.py 19KB

    # -*- 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-%d') def to_local_datetime_string(dt): """aware datetime → '2026-10-29 00:00:00'(北京时间,后台表单回填用)""" if not dt: return '' return tc.local_string(utc_dt=dt, format='%Y-%m-%d %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'参与型号列表') winner_count = models.IntegerField(_(u'winner_count'), default=1, help_text=u'中奖名额数') claim_days = models.IntegerField(_(u'claim_days'), default=14, help_text=u'开奖后联系期限(工作日)') rule_sections = JSONField(_(u'rule_sections'), blank=True, null=True, help_text=u'活动规则段落:[{title, items: []}]') 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, 'claim_days': self.claim_days, 'rule_sections': self.rule_sections or [], } @property def admindata(self): """后台列表 / 表单回填""" return { 'campaign_id': self.campaign_id, 'title': self.title, 'prize_text': self.prize_text or '', 'winner_count': self.winner_count, 'claim_days': self.claim_days, 'start_at': to_local_datetime_string(self.start_at), 'end_at': to_local_datetime_string(self.end_at), 'draw_at': to_local_datetime_string(self.draw_at), 'model_ids': self.model_ids or [], 'rule_sections': self.rule_sections or [], 'status': self.status, 'created_at': to_local_datetime_string(self.created_at), } 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(), 'claim_days': self.claim_days, 'rule_sections': self.rule_sections or [], }) 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, } @property def admindata(self): """后台名单列表""" return { 'entry_id': self.entry_id, 'campaign_id': self.campaign_id, 'campaign_title': self.campaign_title or '', 'user_id': self.user_id or '', 'name': self.name or '', 'phone': self.phone or '', 'serial_no': self.serial_no, 'model_id': self.model_id or '', 'model_name': self.model_name or '', 'result': self.result or self.PENDING, 'created_at': to_local_datetime_string(self.created_at), } 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 '', } @property def admindata(self): """后台收货信息列表""" return { 'campaign_id': self.campaign_id, 'user_id': self.user_id or '', 'receiver': self.receiver or '', 'phone': self.phone or '', 'region': self.region or '', 'detail': self.detail or '', 'created_at': to_local_datetime_string(self.created_at), }