|
# -*- coding: utf-8 -*-
import json
from django.db import transaction
from django.db.models import Count, Q
from django_logit import logit
from django_response import response
from paginator import pagination
from TimeConvert import TimeConvert as tc
from kodo.decorators import check_admin
from sales.models import LotteryAddressInfo, LotteryCampaignInfo, LotteryEntryInfo
from utils.error.errno_utils import LotteryStatusCode, ParamStatusCode
DATETIME_FORMAT = '%Y-%m-%d %H:%M:%S'
RESULT_CHOICES = (LotteryEntryInfo.PENDING, LotteryEntryInfo.WON, LotteryEntryInfo.LOST)
def _parse_datetime(value):
"""'2026-10-29 00:00:00' → aware datetime;空串 → None"""
value = (value or '').strip()
if not value:
return None
return tc.string_to_utc_datetime(value, format=DATETIME_FORMAT)
def _parse_rule_sections(value):
"""规则 JSON 字符串 → [{title, items: []}];结构非法抛 ValueError"""
value = (value or '').strip()
if not value:
return None
sections = json.loads(value)
if not isinstance(sections, list):
raise ValueError('rule_sections must be a list')
cleaned = []
for section in sections:
if not isinstance(section, dict):
raise ValueError('rule section must be an object')
title = (section.get('title') or '').strip()
items = section.get('items') or []
if not isinstance(items, list):
raise ValueError('rule section items must be a list')
items = [str(item).strip() for item in items if str(item).strip()]
if title or items:
cleaned.append({'title': title, 'items': items})
return cleaned
@logit
@check_admin
def lottery_campaign_list_api(request, administrator):
"""后台:抽奖活动列表"""
query = request.POST.get('query', '')
status = request.POST.get('status', '1')
page = request.POST.get('page', 1)
num = request.POST.get('num', 20)
campaigns = LotteryCampaignInfo.objects.all()
if status in ('0', '1'):
campaigns = campaigns.filter(status=status == '1')
if query:
campaigns = campaigns.filter(Q(title__icontains=query) | Q(campaign_id__icontains=query))
count = campaigns.count()
campaigns, left = pagination(campaigns, page, num)
entry_counts = dict(
LotteryEntryInfo.objects.filter(status=True)
.order_by() # 清掉 Meta.ordering,否则 created_at 会进 GROUP BY,计数恒为 1
.values_list('campaign_id')
.annotate(entry_count=Count('id'))
)
data = [
dict(campaign.admindata, entry_count=entry_counts.get(campaign.campaign_id, 0))
for campaign in campaigns
]
return response(200, 'Get Lottery Campaign List Success', u'抽奖活动列表获取成功', data={
'campaigns': data,
'count': count,
'left': left,
})
@logit
@check_admin
@transaction.atomic
def lottery_campaign_save_api(request, administrator):
"""后台:新建 / 编辑抽奖活动"""
campaign_id = request.POST.get('campaign_id', '')
title = (request.POST.get('title') or '').strip()
if not title:
return response(ParamStatusCode.PARAM_INVALID)
try:
rule_sections = _parse_rule_sections(request.POST.get('rule_sections', ''))
start_at = _parse_datetime(request.POST.get('start_at', ''))
end_at = _parse_datetime(request.POST.get('end_at', ''))
draw_at = _parse_datetime(request.POST.get('draw_at', ''))
winner_count = int(request.POST.get('winner_count') or 1)
claim_days = int(request.POST.get('claim_days') or 14)
except (ValueError, TypeError):
return response(ParamStatusCode.PARAM_INVALID)
fields = {
'title': title,
'prize_text': (request.POST.get('prize_text') or '').strip(),
'winner_count': max(winner_count, 0),
'claim_days': max(claim_days, 0),
'start_at': start_at,
'end_at': end_at,
'draw_at': draw_at,
'model_ids': (request.POST.getlist('model_ids[]') or request.POST.getlist('model_ids')) or None,
'rule_sections': rule_sections,
}
if campaign_id:
campaign = LotteryCampaignInfo.objects.filter(campaign_id=campaign_id, status=True).first()
if not campaign:
return response(LotteryStatusCode.CAMPAIGN_NOT_FOUND)
for key, value in fields.items():
setattr(campaign, key, value)
campaign.save()
else:
campaign = LotteryCampaignInfo.objects.create(**fields)
return response(200, 'Save Lottery Campaign Success', u'保存抽奖活动成功', data=campaign.admindata)
@logit
@check_admin
@transaction.atomic
def lottery_campaign_delete_api(request, administrator):
"""后台:停用抽奖活动(软删,名单和收货信息保留)"""
campaign = LotteryCampaignInfo.objects.filter(
campaign_id=request.POST.get('campaign_id', ''),
status=True,
).first()
if not campaign:
return response(LotteryStatusCode.CAMPAIGN_NOT_FOUND)
campaign.status = False
campaign.save()
return response(200, 'Delete Lottery Campaign Success', u'抽奖活动已停用')
@logit
@check_admin
def lottery_entry_list_api(request, administrator):
"""后台:抽奖名单"""
campaign_id = request.POST.get('campaign_id', '')
query = request.POST.get('query', '')
result = request.POST.get('result', '')
page = request.POST.get('page', 1)
num = request.POST.get('num', 20)
entries = LotteryEntryInfo.objects.filter(status=True)
if campaign_id:
entries = entries.filter(campaign_id=campaign_id)
if result:
entries = entries.filter(result=result)
if query:
entries = entries.filter(
Q(serial_no__icontains=query) |
Q(name__icontains=query) |
Q(phone__icontains=query) |
Q(user_id__icontains=query)
)
count = entries.count()
entries, left = pagination(entries, page, num)
return response(200, 'Get Lottery Entry List Success', u'抽奖名单获取成功', data={
'entries': [entry.admindata for entry in entries],
'count': count,
'left': left,
})
@logit
@check_admin
@transaction.atomic
def lottery_entry_result_update_api(request, administrator):
"""后台:批量设置中奖结果(pending / won / lost)"""
result = request.POST.get('result', '')
entry_ids = request.POST.getlist('entry_ids[]') or request.POST.getlist('entry_ids')
if result not in RESULT_CHOICES or not entry_ids:
return response(ParamStatusCode.PARAM_INVALID)
updated = LotteryEntryInfo.objects.filter(status=True, entry_id__in=entry_ids).update(result=result)
return response(200, 'Update Lottery Entry Result Success', u'中奖结果已更新', data={'updated': updated})
@logit
@check_admin
def lottery_address_list_api(request, administrator):
"""后台:中奖收货信息"""
campaign_id = request.POST.get('campaign_id', '')
query = request.POST.get('query', '')
page = request.POST.get('page', 1)
num = request.POST.get('num', 20)
addresses = LotteryAddressInfo.objects.filter(status=True)
if campaign_id:
addresses = addresses.filter(campaign_id=campaign_id)
if query:
addresses = addresses.filter(
Q(receiver__icontains=query) |
Q(phone__icontains=query) |
Q(region__icontains=query) |
Q(detail__icontains=query)
)
count = addresses.count()
addresses, left = pagination(addresses, page, num)
titles = dict(
LotteryCampaignInfo.objects.filter(
campaign_id__in={address.campaign_id for address in addresses}
).values_list('campaign_id', 'title')
)
data = [
dict(address.admindata, campaign_title=titles.get(address.campaign_id, ''))
for address in addresses
]
return response(200, 'Get Lottery Address List Success', u'收货信息获取成功', data={
'addresses': data,
'count': count,
'left': left,
})
|