48b57983c654cfa7912e2318af5cef57L408">408
|
|
- mssi.save()
|
|
409
|
|
-
|
|
410
|
|
- mssi, _ = ModelSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
411
|
|
- brand_id=brand.brand_id,
|
|
412
|
|
- model_name=model.model_uni_name,
|
|
413
|
|
- ymd=ymd[:4],
|
|
414
|
|
- )
|
|
415
|
|
- mssi.saleclerks += [clerk.clerk_id]
|
|
416
|
|
- mssi.num = len(mssi.saleclerks)
|
|
417
|
|
- mssi.save()
|
|
418
|
|
-
|
|
419
|
|
- # 经销商销量统计
|
|
420
|
|
- dssi, _ = DistributorSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
421
|
|
- brand_id=brand.brand_id,
|
|
422
|
|
- distributor_id=distributor.distributor_id,
|
|
423
|
|
- ymd=ymd,
|
|
424
|
|
- )
|
|
425
|
|
- dssi.distributor_name = distributor.distributor_name
|
|
426
|
|
- dssi.num += 1
|
|
427
|
|
- dssi.save()
|
|
428
|
|
-
|
|
429
|
|
- dssi2, _ = DistributorSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
430
|
|
- brand_id=brand.brand_id,
|
|
431
|
|
- distributor_id=distributor.distributor_id,
|
|
432
|
|
- ymd=0,
|
|
433
|
|
- )
|
|
434
|
|
- dssi2.distributor_name = distributor.distributor_name
|
|
435
|
|
- dssi2.num += 1
|
|
436
|
|
- dssi2.save()
|
|
437
|
|
-
|
|
438
|
|
- # 日省份销量统计
|
|
439
|
|
- pssi, _ = ProvinceSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
440
|
|
- brand_id=brand.brand_id,
|
|
441
|
|
- province_code=distributor.distributor_province_code,
|
|
442
|
|
- ymd=ymd,
|
|
443
|
|
- )
|
|
444
|
|
- pssi.province_name = distributor.distributor_province_name
|
|
445
|
|
- pssi.num += 1
|
|
446
|
|
- pssi.save()
|
|
447
|
|
- # 月省份销量统计
|
|
448
|
|
- pssi, _ = ProvinceSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
449
|
|
- brand_id=brand.brand_id,
|
|
450
|
|
- province_code=distributor.distributor_province_code,
|
|
451
|
|
- ymd=ymd[:6],
|
|
452
|
|
- )
|
|
453
|
|
- pssi.province_name = distributor.distributor_province_name
|
|
454
|
|
- pssi.num += 1
|
|
455
|
|
- pssi.save()
|
|
456
|
|
- # 年省份销量统计
|
|
457
|
|
- pssi, _ = ProvinceSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
458
|
|
- brand_id=brand.brand_id,
|
|
459
|
|
- province_code=distributor.distributor_province_code,
|
|
460
|
|
- ymd=ymd[:4],
|
|
461
|
|
- )
|
|
462
|
|
- pssi.province_name = distributor.distributor_province_name
|
|
463
|
|
- pssi.num += 1
|
|
464
|
|
- pssi.save()
|
|
465
|
|
-
|
|
466
|
|
- # 日销售员销量统计
|
|
467
|
|
- sssi, _ = SaleclerkSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
468
|
|
- brand_id=brand.brand_id,
|
|
469
|
|
- clerk_id=clerk.clerk_id,
|
|
470
|
|
- ymd=ymd,
|
|
471
|
|
- )
|
|
472
|
|
- sssi.distributor_id = distributor.distributor_id
|
|
473
|
|
- sssi.distributor_name = distributor.distributor_name
|
|
474
|
|
- sssi.distributor_short_name = distributor.distributor_short_name
|
|
475
|
|
- sssi.clerk_name = clerk.clerk_name
|
|
476
|
|
- sssi.num += 1
|
|
477
|
|
- sssi.save()
|
|
478
|
|
- # 月销售员销量统计
|
|
479
|
|
- sssi, _ = SaleclerkSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
480
|
|
- brand_id=brand.brand_id,
|
|
481
|
|
- clerk_id=clerk.clerk_id,
|
|
482
|
|
- ymd=ymd[:6],
|
|
483
|
|
- )
|
|
484
|
|
- sssi.distributor_id = distributor.distributor_id
|
|
485
|
|
- sssi.distributor_name = distributor.distributor_name
|
|
486
|
|
- sssi.distributor_short_name = distributor.distributor_short_name
|
|
487
|
|
- sssi.clerk_name = clerk.clerk_name
|
|
488
|
|
- sssi.num += 1
|
|
489
|
|
- sssi.save()
|
|
490
|
|
- # 年销售员销量统计
|
|
491
|
|
- sssi, _ = SaleclerkSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
492
|
|
- brand_id=brand.brand_id,
|
|
493
|
|
- clerk_id=clerk.clerk_id,
|
|
494
|
|
- ymd=ymd[:4],
|
|
495
|
|
- )
|
|
496
|
|
- sssi.distributor_id = distributor.distributor_id
|
|
497
|
|
- sssi.distributor_name = distributor.distributor_name
|
|
498
|
|
- sssi.distributor_short_name = distributor.distributor_short_name
|
|
499
|
|
- sssi.clerk_name = clerk.clerk_name
|
|
500
|
|
- sssi.num += 1
|
|
501
|
|
- sssi.save()
|
|
|
368
|
+ with transaction.atomic():
|
|
|
369
|
+ # 日销量统计
|
|
|
370
|
+ ssi, _ = SaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
371
|
+ brand_id=brand.brand_id,
|
|
|
372
|
+ ymd=ymd,
|
|
|
373
|
+ )
|
|
|
374
|
+ ssi.num += 1
|
|
|
375
|
+ ssi.save()
|
|
|
376
|
+ # 月销量统计
|
|
|
377
|
+ ssi, _ = SaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
378
|
+ brand_id=brand.brand_id,
|
|
|
379
|
+ ymd=ymd[:6],
|
|
|
380
|
+ )
|
|
|
381
|
+ ssi.num += 1
|
|
|
382
|
+ ssi.save()
|
|
|
383
|
+ # 年销量统计
|
|
|
384
|
+ ssi, _ = SaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
385
|
+ brand_id=brand.brand_id,
|
|
|
386
|
+ ymd=ymd[:4],
|
|
|
387
|
+ )
|
|
|
388
|
+ ssi.num += 1
|
|
|
389
|
+ ssi.save()
|
|
|
390
|
+
|
|
|
391
|
+ # 型号销量统计
|
|
|
392
|
+ mssi, _ = ModelSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
393
|
+ brand_id=brand.brand_id,
|
|
|
394
|
+ model_name=model.model_uni_name,
|
|
|
395
|
+ ymd=ymd,
|
|
|
396
|
+ )
|
|
|
397
|
+ mssi.saleclerks += [clerk.clerk_id]
|
|
|
398
|
+ mssi.num = len(mssi.saleclerks)
|
|
|
399
|
+ mssi.save()
|
|
|
400
|
+
|
|
|
401
|
+ mssi, _ = ModelSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
402
|
+ brand_id=brand.brand_id,
|
|
|
403
|
+ model_name=model.model_uni_name,
|
|
|
404
|
+ ymd=ymd[:6],
|
|
|
405
|
+ )
|
|
|
406
|
+ mssi.saleclerks += [clerk.clerk_id]
|
|
|
407
|
+ mssi.num = len(mssi.saleclerks)
|
|
|
408
|
+ mssi.save()
|
|
|
409
|
+
|
|
|
410
|
+ mssi, _ = ModelSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
411
|
+ brand_id=brand.brand_id,
|
|
|
412
|
+ model_name=model.model_uni_name,
|
|
|
413
|
+ ymd=ymd[:4],
|
|
|
414
|
+ )
|
|
|
415
|
+ mssi.saleclerks += [clerk.clerk_id]
|
|
|
416
|
+ mssi.num = len(mssi.saleclerks)
|
|
|
417
|
+ mssi.save()
|
|
|
418
|
+
|
|
|
419
|
+ # 经销商销量统计
|
|
|
420
|
+ dssi, _ = DistributorSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
421
|
+ brand_id=brand.brand_id,
|
|
|
422
|
+ distributor_id=distributor.distributor_id,
|
|
|
423
|
+ ymd=ymd,
|
|
|
424
|
+ )
|
|
|
425
|
+ dssi.distributor_name = distributor.distributor_name
|
|
|
426
|
+ dssi.num += 1
|
|
|
427
|
+ dssi.save()
|
|
|
428
|
+
|
|
|
429
|
+ dssi2, _ = DistributorSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
430
|
+ brand_id=brand.brand_id,
|
|
|
431
|
+ distributor_id=distributor.distributor_id,
|
|
|
432
|
+ ymd=0,
|
|
|
433
|
+ )
|
|
|
434
|
+ dssi2.distributor_name = distributor.distributor_name
|
|
|
435
|
+ dssi2.num += 1
|
|
|
436
|
+ dssi2.save()
|
|
|
437
|
+
|
|
|
438
|
+ # 日省份销量统计
|
|
|
439
|
+ pssi, _ = ProvinceSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
440
|
+ brand_id=brand.brand_id,
|
|
|
441
|
+ province_code=distributor.distributor_province_code,
|
|
|
442
|
+ ymd=ymd,
|
|
|
443
|
+ )
|
|
|
444
|
+ pssi.province_name = distributor.distributor_province_name
|
|
|
445
|
+ pssi.num += 1
|
|
|
446
|
+ pssi.save()
|
|
|
447
|
+ # 月省份销量统计
|
|
|
448
|
+ pssi, _ = ProvinceSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
449
|
+ brand_id=brand.brand_id,
|
|
|
450
|
+ province_code=distributor.distributor_province_code,
|
|
|
451
|
+ ymd=ymd[:6],
|
|
|
452
|
+ )
|
|
|
453
|
+ pssi.province_name = distributor.distributor_province_name
|
|
|
454
|
+ pssi.num += 1
|
|
|
455
|
+ pssi.save()
|
|
|
456
|
+ # 年省份销量统计
|
|
|
457
|
+ pssi, _ = ProvinceSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
458
|
+ brand_id=brand.brand_id,
|
|
|
459
|
+ province_code=distributor.distributor_province_code,
|
|
|
460
|
+ ymd=ymd[:4],
|
|
|
461
|
+ )
|
|
|
462
|
+ pssi.province_name = distributor.distributor_province_name
|
|
|
463
|
+ pssi.num += 1
|
|
|
464
|
+ pssi.save()
|
|
|
465
|
+
|
|
|
466
|
+ # 日销售员销量统计
|
|
|
467
|
+ sssi, _ = SaleclerkSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
468
|
+ brand_id=brand.brand_id,
|
|
|
469
|
+ clerk_id=clerk.clerk_id,
|
|
|
470
|
+ ymd=ymd,
|
|
|
471
|
+ )
|
|
|
472
|
+ sssi.distributor_id = distributor.distributor_id
|
|
|
473
|
+ sssi.distributor_name = distributor.distributor_name
|
|
|
474
|
+ sssi.distributor_short_name = distributor.distributor_short_name
|
|
|
475
|
+ sssi.clerk_name = clerk.clerk_name
|
|
|
476
|
+ sssi.num += 1
|
|
|
477
|
+ sssi.save()
|
|
|
478
|
+ # 月销售员销量统计
|
|
|
479
|
+ sssi, _ = SaleclerkSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
480
|
+ brand_id=brand.brand_id,
|
|
|
481
|
+ clerk_id=clerk.clerk_id,
|
|
|
482
|
+ ymd=ymd[:6],
|
|
|
483
|
+ )
|
|
|
484
|
+ sssi.distributor_id = distributor.distributor_id
|
|
|
485
|
+ sssi.distributor_name = distributor.distributor_name
|
|
|
486
|
+ sssi.distributor_short_name = distributor.distributor_short_name
|
|
|
487
|
+ sssi.clerk_name = clerk.clerk_name
|
|
|
488
|
+ sssi.num += 1
|
|
|
489
|
+ sssi.save()
|
|
|
490
|
+ # 年销售员销量统计
|
|
|
491
|
+ sssi, _ = SaleclerkSaleStatisticInfo.objects.select_for_update().get_or_create(
|
|
|
492
|
+ brand_id=brand.brand_id,
|
|
|
493
|
+ clerk_id=clerk.clerk_id,
|
|
|
494
|
+ ymd=ymd[:4],
|
|
|
495
|
+ )
|
|
|
496
|
+ sssi.distributor_id = distributor.distributor_id
|
|
|
497
|
+ sssi.distributor_name = distributor.distributor_name
|
|
|
498
|
+ sssi.distributor_short_name = distributor.distributor_short_name
|
|
|
499
|
+ sssi.clerk_name = clerk.clerk_name
|
|
|
500
|
+ sssi.num += 1
|
|
|
501
|
+ sssi.save()
|