# -*- coding: utf-8 -*- #!/usr/bin/env python from apilib.utils_datetime import to_datetime from apps.web.user.models import ConsumeRecord from apps.web.agent.models import Agent from apps.web.dealer.models import Dealer agentIds =[ str(_.id) for _ in Agent.objects.filter(managerId = '59974b4b8732d6480fb699e5')] dealerIds = [str(_.id) for _ in Dealer.objects.filter(agentId__in = agentIds)] count = ConsumeRecord.objects.filter(dateTimeAdded__gte = to_datetime('2019-06-04 00:00:00'), dateTimeAdded__lte = to_datetime('2019-06-05 00:00:00'), isNormal = True, ownerId__in = dealerIds).count() print count print 'finished'