|
29
|
+ 'verbose_name': '\u7ecf\u9500\u5546\u9500\u91cf\u7edf\u8ba1',
|
|
|
30
|
+ 'verbose_name_plural': '\u7ecf\u9500\u5546\u9500\u91cf\u7edf\u8ba1',
|
|
|
31
|
+ },
|
|
|
32
|
+ ),
|
|
|
33
|
+ migrations.CreateModel(
|
|
|
34
|
+ name='ModelSaleStatisticInfo',
|
|
|
35
|
+ fields=[
|
|
|
36
|
+ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
37
|
+ ('status', models.BooleanField(db_index=True, default=True, help_text='Status', verbose_name='status')),
|
|
|
38
|
+ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
|
|
|
39
|
+ ('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
|
|
40
|
+ ('model_id', models.CharField(db_index=True, help_text='\u578b\u53f7\u552f\u4e00\u6807\u8bc6', max_length=32, verbose_name='model_id')),
|
|
|
41
|
+ ('model_name', models.CharField(blank=True, help_text='\u578b\u53f7\u540d\u79f0', max_length=255, null=True, verbose_name='model_name')),
|
|
|
42
|
+ ('ymd', models.CharField(blank=True, db_index=True, help_text='\u5e74\u6708\u65e5', max_length=8, null=True, verbose_name='ymd')),
|
|
|
43
|
+ ('num', models.IntegerField(default=0, help_text='\u6570\u91cf', verbose_name='num')),
|
|
|
44
|
+ ],
|
|
|
45
|
+ options={
|
|
|
46
|
+ 'verbose_name': '\u578b\u53f7\u9500\u91cf\u7edf\u8ba1',
|
|
|
47
|
+ 'verbose_name_plural': '\u578b\u53f7\u9500\u91cf\u7edf\u8ba1',
|
|
|
48
|
+ },
|
|
|
49
|
+ ),
|
|
|
50
|
+ migrations.CreateModel(
|
|
|
51
|
+ name='RegisterStatisticInfo',
|
|
|
52
|
+ fields=[
|
|
|
53
|
+ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
54
|
+ ('status', models.BooleanField(db_index=True, default=True, help_text='Status', verbose_name='status')),
|
|
|
55
|
+ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
|
|
|
56
|
+ ('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
|
|
57
|
+ ('ymd', models.CharField(blank=True, db_index=True, help_text='\u5e74\u6708\u65e5', max_length=8, null=True, verbose_name='ymd')),
|
|
|
58
|
+ ('num', models.IntegerField(default=0, help_text='\u6570\u91cf', verbose_name='num')),
|
|
|
59
|
+ ],
|
|
|
60
|
+ options={
|
|
|
61
|
+ 'verbose_name': '\u6ce8\u518c\u7528\u6237\u7edf\u8ba1',
|
|
|
62
|
+ 'verbose_name_plural': '\u6ce8\u518c\u7528\u6237\u7edf\u8ba1',
|
|
|
63
|
+ },
|
|
|
64
|
+ ),
|
|
|
65
|
+ migrations.CreateModel(
|
|
|
66
|
+ name='SaleStatisticInfo',
|
|
|
67
|
+ fields=[
|
|
|
68
|
+ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
|
69
|
+ ('status', models.BooleanField(db_index=True, default=True, help_text='Status', verbose_name='status')),
|
|
|
70
|
+ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
|
|
|
71
|
+ ('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
|
|
|
72
|
+ ('ymd', models.CharField(blank=True, db_index=True, help_text='\u5e74\u6708\u65e5', max_length=8, null=True, verbose_name='ymd')),
|
|
|
73
|
+ ('num', models.IntegerField(default=0, help_text='\u6570\u91cf', verbose_name='num')),
|
|
|
74
|
+ ],
|
|
|
75
|
+ options={
|
|
|
76
|
+ 'verbose_name': '\u9500\u91cf\u7edf\u8ba1',
|
|
|
77
|
+ 'verbose_name_plural': '\u9500\u91cf\u7edf\u8ba1',
|
|
|
78
|
+ },
|
|
|
79
|
+ ),
|
|
|
80
|
+ ]
|
|
|
|
@@ -0,0 +1,89 @@
|
|
|
1
|
+# -*- coding: utf-8 -*-
|
|
|
2
|
+
|
|
|
3
|
+from django.db import models
|
|
|
4
|
+from django.utils.translation import ugettext_lazy as _
|
|
|
5
|
+from django_models_ext import BaseModelMixin
|
|
|
6
|
+
|
|
|
7
|
+
|
|
|
8
|
+class RegisterStatisticInfo(BaseModelMixin):
|
|
|
9
|
+ ymd = models.CharField(_(u'ymd'), max_length=8, blank=True, null=True, help_text=u'年月日', db_index=True) # 例：20171208, tc.local_string(format='%Y%m%d')
|
|
|
10
|
+ num = models.IntegerField(_(u'num'), default=0, help_text=u'数量')
|
|
|
11
|
+
|
|
|
12
|
+ class Meta:
|
|
|
13
|
+ verbose_name = _(u'注册用户统计')
|
|
|
14
|
+ verbose_name_plural = _(u'注册用户统计')
|
|
|
15
|
+
|
|
|
16
|
+ def __unicode__(self):
|
|
|
17
|
+ return unicode(self.pk)
|
|
|
18
|
+
|
|
|
19
|
+ @property
|
|
|
20
|
+ def data(self):
|
|
|
21
|
+ return {
|
|
|
22
|
+ 'ymd': self.ymd,
|
|
|
23
|
+ 'num': self.num,
|
|
|
24
|
+ }
|
|
|
25
|
+
|
|
|
26
|
+
|
|
|
27
|
+class SaleStatisticInfo(BaseModelMixin):
|
|
|
28
|
+ ymd = models.CharField(_(u'ymd'), max_length=8, blank=True, null=True, help_text=u'年月日', db_index=True) # 例：20171208, tc.local_string(format='%Y%m%d')
|
|
|
29
|
+ num = models.IntegerField(_(u'num'), default=0, help_text=u'数量')
|
|
|
30
|
+
|
|
|
31
|
+ class Meta:
|
|
|
32
|
+ verbose_name = _(u'销量统计')
|
|
|
33
|
+ verbose_name_plural = _(u'销量统计')
|
|
|
34
|
+
|
|
|
35
|
+ def __unicode__(self):
|
|
|
36
|
+ return unicode(self.pk)
|
|
|
37
|
+
|
|
|
38
|
+ @property
|
|
|
39
|
+ def data(self):
|
|
|
40
|
+ return {
|
|
|
41
|
+ 'ymd': self.ymd,
|
|
|
42
|
+ 'num': self.num,
|
|
|
43
|
+ }
|
|
|
44
|
+
|
|
|
45
|
+
|
|
|
46
|
+class ModelSaleStatisticInfo(BaseModelMixin):
|
|
|
47
|
+ model_id = models.CharField(_(u'model_id'), max_length=32, help_text=u'型号唯一标识', db_index=True)
|
|
|
48
|
+ model_name = models.CharField(_(u'model_name'), max_length=255, blank=True, null=True, help_text=u'型号名称')
|
|
|
49
|
+ ymd = models.CharField(_(u'ymd'), max_length=8, blank=True, null=True, help_text=u'年月日', db_index=True) # 例：20171208, tc.local_string(format='%Y%m%d')
|
|
|
50
|
+ num = models.IntegerField(_(u'num'), default=0, help_text=u'数量')
|
|
|
51
|
+
|
|
|
52
|
+ class Meta:
|
|
|
53
|
+ verbose_name = _(u'型号销量统计')
|
|
|
54
|
+ verbose_name_plural = _(u'型号销量统计')
|
|
|
55
|
+
|
|
|
56
|
+ def __unicode__(self):
|
|
|
57
|
+ return unicode(self.pk)
|
|
|
58
|
+
|
|
|
59
|
+ @property
|
|
|
60
|
+ def data(self):
|
|
|
61
|
+ return {
|
|
|
62
|
+ 'model_id': self.model_id,
|
|
|
63
|
+ 'model_name': self.model_name,
|
|
|
64
|
+ 'ymd': self.ymd,
|
|
|
65
|
+ 'num': self.num,
|
|
|
66
|
+ }
|
|
|
67
|
+
|
|
|
68
|
+
|
|
|
69
|
+class DistributorSaleStatisticInfo(BaseModelMixin):
|
|
|
70
|
+ distributor_id = models.CharField(_(u'distributor_id'), max_length=32, help_text=u'经销商唯一标识', db_index=True)
|
|
|
71
|
+ distributor_name = models.CharField(_(u'distributor_name'), max_length=255, blank=True, null=True, help_text=u'经销商名称')
|
|
|
72
|
+ ymd = models.CharField(_(u'ymd'), max_length=8, blank=True, null=True, help_text=u'年月日', db_index=True) # 例：20171208, tc.local_string(format='%Y%m%d')
|
|
|
73
|
+ num = models.IntegerField(_(u'num'), default=0, help_text=u'数量')
|
|
|
74
|
+
|
|
|
75
|
+ class Meta:
|
|
|
76
|
+ verbose_name = _(u'经销商销量统计')
|
|
|
77
|
+ verbose_name_plural = _(u'经销商销量统计')
|
|
|
78
|
+
|
|
|
79
|
+ def __unicode__(self):
|
|
|
80
|
+ return unicode(self.pk)
|
|
|
81
|
+
|
|
|
82
|
+ @property
|
|
|
83
|
+ def data(self):
|
|
|
84
|
+ return {
|
|
|
85
|
+ 'distributor_id': self.distributor_id,
|
|
|
86
|
+ 'distributor_name': self.distributor_name,
|
|
|
87
|
+ 'ymd': self.ymd,
|
|
|
88
|
+ 'num': self.num,
|
|
|
89
|
+ }
|
|
|
|
@@ -0,0 +1,7 @@
|
|
|
1
|
+# -*- coding: utf-8 -*-
|
|
|
2
|
+from __future__ import unicode_literals
|
|
|
3
|
+
|
|
|
4
|
+from django.test import TestCase
|
|
|
5
|
+
|
|
|
6
|
+
|
|
|
7
|
+# Create your tests here.
|
|
|
|
@@ -0,0 +1,50 @@
|
|
|
1
|
+# -*- coding: utf-8 -*-
|
|
|
2
|
+
|
|
|
3
|
+from django_logit import logit
|
|
|
4
|
+from django_response import response
|
|
|
5
|
+from TimeConvert import TimeConvert as tc
|
|
|
6
|
+
|
|
|
7
|
+from statistic.models import (DistributorSaleStatisticInfo, ModelSaleStatisticInfo, RegisterStatisticInfo,
|
|
|
8
|
+ SaleStatisticInfo)
|
|
|
9
|
+
|
|
|
10
|
+
|
|
|
11
|
+@logit
|
|
|
12
|
+def tj_data(request):
|
|
|
13
|
+ ymd = tc.local_string(format='%Y%m%d')
|
|
|
14
|
+
|
|
|
15
|
+ # 注册用户统计 & 今日注册用户
|
|
|
16
|
+ try:
|
|
|
17
|
+ register_num = RegisterStatisticInfo.objects.get(ymd=ymd).num
|
|
|
18
|
+ except RegisterStatisticInfo.DoesNotExist:
|
|
|
19
|
+ register_num = 0
|
|
|
20
|
+
|
|
|
21
|
+ # 注册用户数趋势
|
|
|
22
|
+ register_trends = RegisterStatisticInfo.objects.filter(status=True).order_by('-pk')[:30]
|
|
|
23
|
+ register_trends = [r.data for r in register_trends]
|
|
|
24
|
+
|
|
|
25
|
+ # 销量统计 & 今日销量
|
|
|
26
|
+ try:
|
|
|
27
|
+ sale_num = SaleStatisticInfo.objects.get(ymd=ymd).num
|
|
|
28
|
+ except RegisterStatisticInfo.DoesNotExist:
|
|
|
29
|
+ sale_num = 0
|
|
|
30
|
+
|
|
|
31
|
+ # 商品销量趋势
|
|
|
32
|
+ sale_trends = SaleStatisticInfo.objects.filter(status=True).order_by('-pk')[:30]
|
|
|
33
|
+ sale_trends = [s.data for s in sale_trends]
|
|
|
34
|
+
|
|
|
35
|
+ # 型号销量统计 & 热销商品榜
|
|
|
36
|
+ model_sales = ModelSaleStatisticInfo.objects.filter(status=True).order_by('-num')[:3]
|
|
|
37
|
+ model_sales = [m.data for m in model_sales]
|
|
|
38
|
+
|
|
|
39
|
+ # 经销商销量统计 & 经销商榜
|
|
|
40
|
+ distributor_sales = DistributorSaleStatisticInfo.objects.filter(status=True).order_by('-num')[:3]
|
|
|
41
|
+ distributor_sales = [d.data for d in distributor_sales]
|
|
|
42
|
+
|
|
|
43
|
+ return response(200, 'Get TJ Data Success', u'获取统计数据成功', {
|
|
|
44
|
+ 'register_num': register_num,
|
|
|
45
|
+ 'register_trends': register_trends,
|
|
|
46
|
+ 'sale_num': sale_num,
|
|
|
47
|
+ 'sale_trends': sale_trends,
|
|
|
48
|
+ 'model_sales': model_sales,
|
|
|
49
|
+ 'distributor_sales': distributor_sales,
|
|
|
50
|
+ })
|
|
|
|
@@ -25,6 +25,11 @@ class ProductModelStatusCode(BaseStatusCode):
|
|
25
|
25
|
MODEL_NOT_FOUND = StatusCodeField(501001, 'Model Not Found', description=u'型号不存在')
|
|
26
|
26
|
|
|
27
|
27
|
|
|
|
28
|
+class ProductDistributorStatusCode(BaseStatusCode):
|
|
|
29
|
+ """ 经销商相关错误码 5011xx """
|
|
|
30
|
+ DISTRIBUTOR_NOT_FOUND = StatusCodeField(501101, 'Distributor Not Found', description=u'经销商不存在')
|
|
|
31
|
+
|
|
|
32
|
+
|
|
28
|
33
|
class ProductStatusCode(BaseStatusCode):
|
|
29
|
34
|
""" 产品相关错误码 5020xx """
|
|
30
|
35
|
PRODUCT_NOT_FOUND = StatusCodeField(502001, 'Product Not Found', description=u'产品不存在')
|