Sin Descripción

lottery_admin_views.py 8.0KB

    # -*- 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, })