+        if len(ymd) == 8:

+            # 月型号销量统计

+            mssi, _ = ConsumeModelSaleStatisticInfo.objects.select_for_update().get_or_create(

+                brand_id=o.brand_id,

+                model_id=o.model_id,

+                ymd=ymd[6],

+            )

+            mssi.model_name = o.model_name

+            mssi.num += 1

+            mssi.save()

+            # 年型号销量统计

+            mssi, _ = ConsumeModelSaleStatisticInfo.objects.select_for_update().get_or_create(

+                brand_id=o.brand_id,

+                model_id=o.model_id,

+                ymd=ymd[4],

+            )

+            mssi.model_name = o.model_name

+            mssi.num += 1

+            mssi.save()

+

+    for o in SaleStatisticInfo.objects.all():

+        ymd = str(o.ymd)

+        if len(ymd) == 8:

+            # 月销量统计

+            ssi, _ = SaleStatisticInfo.objects.select_for_update().get_or_create(

+                brand_id=o.brand_id,

+                ymd=ymd[6],

+            )

+            ssi.num += 1

+            ssi.save()

+            # 年销量统计

+            ssi, _ = SaleStatisticInfo.objects.select_for_update().get_or_create(

+                brand_id=o.brand_id,

+                ymd=ymd[4],

+            )

+            ssi.num += 1

+            ssi.save()

@@ -1,4 +1,4 @@

-Django==1.11.15

+Django==1.11.16

 django-admin==1.3.2

 django-cors-headers==2.4.0

 django-curtail-uuid==1.0.4

@@ -205,7 +205,7 @@ def __tj_generate(ymd=None):

 def ymdtj(brand_id, ymd, lastymd):

-    # 周期内扫描用户人数

+    # [消费者维度] 周期内扫描用户人数

     try:

         scan_user_count = ConsumeSaleStatisticInfo.objects.get(brand_id=brand_id, ymd=ymd).num

     except ConsumeSaleStatisticInfo.DoesNotExist:

@@ -219,7 +219,7 @@ def ymdtj(brand_id, ymd, lastymd):

     # 与上个统计周期数据的用户人数比例

     user_count_increase_pct = '%.2f' % (scan_user_count * 100.0 / last_scan_user_count) if last_scan_user_count != 0 else 0

-    # 周期内镜头销售支数

+    # [经销商维度] 周期内镜头销售支数

     try:

         sell_volume_count = SaleStatisticInfo.objects.get(brand_id=brand_id, ymd=ymd).num

     except SaleStatisticInfo.DoesNotExist:

@@ -233,15 +233,15 @@ def ymdtj(brand_id, ymd, lastymd):

     # 与上个统计周期数据的销售支数比例

     volume_count_increase_pct = '%.2f' % (sell_volume_count * 100.0 / last_sell_volume_count) if last_sell_volume_count != 0 else 0

-    # 统计周期内型号扫描排行数据，请按顺序返回

+    # [消费者维度] 统计周期内型号扫描排行数据，请按顺序返回

     models = ConsumeModelSaleStatisticInfo.objects.filter(brand_id=brand_id, ymd=ymd, status=True).order_by('-num')[:20]

     models = [m.data for m in models]

-    # 统计周期内销售员排行数据，请按顺序返回

+    # [经销商维度] 统计周期内销售员排行数据，请按顺序返回

     salesmen = SaleclerkSaleStatisticInfo.objects.filter(brand_id=brand_id, ymd=ymd, status=True).order_by('-num')[:20]

     salesmen = [s.data for s in salesmen]

-    # 统计周期内省份销量排行数据，请按顺序返回

+    # [经销商维度] 统计周期内省份销量排行数据，请按顺序返回

     provinces = ProvinceSaleStatisticInfo.objects.filter(brand_id=brand_id, ymd=ymd, status=True)

     provinces = [p.data for p in provinces]

ホーム エスクプローラ ヘルプ

登録 サインイン

Kodo

/

kodo

Watch 2

Star 0

Fork 0

課題 0 プルリクエスト 0 コミット 958 リリース 0

1 コミット (0ccf5ce96b345022620dfd9c513bfbebab9e88f6)

作者	SHA1	メッセージ	日付
Brightcells	a078341431	Preauth page	7 年 前