10 
+    initial = True
11 
+
12 
+    dependencies = [
13 
+    ]
14 
+
15 
+    operations = [
16 
+        migrations.CreateModel(
17 
+            name='DistributorSaleStatisticInfo',
18 
+            fields=[
19 
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
20 
+                ('status', models.BooleanField(db_index=True, default=True, help_text='Status', verbose_name='status')),
21 
+                ('created_at', models.DateTimeField(auto_now_add=True, help_text='Create Time', verbose_name='created_at')),
22 
+                ('updated_at', models.DateTimeField(auto_now=True, help_text='Update Time', verbose_name='updated_at')),
23 
+                ('distributor_id', models.CharField(db_index=True, help_text='\u7ecf\u9500\u5546\u552f\u4e00\u6807\u8bc6', max_length=32, verbose_name='distributor_id')),
24 
+                ('distributor_name', models.CharField(blank=True, help_text='\u7ecf\u9500\u5546\u540d\u79f0', max_length=255, null=True, verbose_name='distributor_name')),
25 
+                ('ymd', models.CharField(blank=True, db_index=True, help_text='\u5e74\u6708\u65e5', max_length=8, null=True, verbose_name='ymd')),
26 
+                ('num', models.IntegerField(default=0, help_text='\u6570\u91cf', verbose_name='num')),
27 
+            ],
28 
+            options={
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
statistic/migrations/__init__.py
Voir le fichier


+ 89 - 0
statistic/models.py
Voir le fichier 

@@ -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 
+        }

+ 7 - 0
statistic/tests.py
Voir le fichier 

@@ -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.

+ 50 - 0
statistic/views.py
Voir le fichier 

@@ -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 
+    })

+ 5 - 0
utils/error/errno_utils.py
Voir le fichier 

@@ -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'产品不存在')

pai2 - Gogs: Go Git Service
Home Esplora Aiuto
Registrati Accedi
Pai2
/
pai2
Segui 2
Vota 0
Forka 0
Problemi 0 Pull Requests 0 Commit 343 Rilasci 0

拍爱

ZIP TAR.GZ
Brightcells: e440bc76ee Change to use pywe-oauth 9 anni fa
..
migrations 8f43551640 add api wx_jsapi_signature_api 10 anni fa
__init__.py 8f43551640 add api wx_jsapi_signature_api 10 anni fa
admin.py 8f43551640 add api wx_jsapi_signature_api 10 anni fa
models.py 8f43551640 add api wx_jsapi_signature_api 10 anni fa
tests.py 8f43551640 add api wx_jsapi_signature_api 10 anni fa
views.py e440bc76ee Change to use pywe-oauth 9 anni fa