manyi/script/transaction/calc_income.py

# -*- coding: utf-8 -*-
# !/usr/bin/env python
import datetime
import os
import sys

from bson import ObjectId



PROJECT_ROOT = os.path.join(os.path.abspath(os.path.split(os.path.realpath(__file__))[0] + "/.."), '..')
sys.path.insert(0, PROJECT_ROOT)

from script.base import init_env

os.environ["DJANGO_SETTINGS_MODULE"] = "configs.production"

init_env(False)

from apps.web.dealer.proxy import DealerIncomeProxy
from apps.web.core.db import copy_document_classes
from apilib.monetary import RMB

begin = datetime.datetime(2017, 1, 1, 0, 0, 0)
end = datetime.datetime(2089, 1, 1, 0, 0, 0)
check_date = datetime.datetime(2022, 6, 1, 0, 0, 0)

if __name__ == '__main__':
    his_model_cls = copy_document_classes(DealerIncomeProxy, '{}_his'.format(DealerIncomeProxy.__name__),
                                          'report_his')

    first = his_model_cls.objects(ref_id=ObjectId('60386f0e6f2925250246ce61')).first()

    his_5df6e433003048ece7d3a970 = his_model_cls.sum_by_dealer(dealerId = '5df6e433003048ece7d3a970',
                                                               **{'dateTimeAdded__gte': begin,
                                                                  'dateTimeAdded__lt': first.dateTimeAdded})

    print his_5df6e433003048ece7d3a970