Account /Lead Model
account_name
contact m2m realtion
contact Model
name
phone No
calls Model
caller no # person phone no who is calling
agent no # person who is picking the call (CRM user)
status <inbound,outbound, missed>
timestamp
duration
calls model is populated with some third party software and we are map its
caller no and agent no their is no direct relationship
I want to get the list of accounts in particular date range with:
total no of contact it have ,
how many time its contact have called
how many calls where missed inbound outbound etc
On Thu, Jun 6, 2019 at 4:49 PM Chetan Ganji <ganji.che...@gmail.com> wrote:
> Right now its an open ended question.
>
> If you post code for your models here, someone can help you.
>
> On Thu, Jun 6, 2019, 4:38 PM Devender Kumar <dev1en...@gmail.com> wrote:
>
>> Hi,
>> I am working on CRM project and stuck with REPORTING part.
>>
>> I have Accounts , Lead , contact, Calls ,Concern modules
>> account/Lead can have multiple contacts
>> contacts have multiple calls and concerns
>> calls have different status like Incoming outgoing missed call etc
>>
>> Question
>> I need to create a reporting system
>> In this I have to give a functionality like so
>> list of accounts with counts of :
>> contacts, total calls,incoming, outgoing etc
>>
>> how can list all this count for a given date ranges calls on all
>> accounts
>>
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To post to this group, send email to django-users@googlegroups.com.
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/1cb5c003-7cbc-4d54-ae5b-21403e543b95%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/1cb5c003-7cbc-4d54-ae5b-21403e543b95%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAMKMUjtMaEncd6LF1J%2BmgKxA_NpL1FLFz5_UXi_JMLDD%3Du52Vw%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAMKMUjtMaEncd6LF1J%2BmgKxA_NpL1FLFz5_UXi_JMLDD%3Du52Vw%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CALmCJr7ApqHCCsm73t%3DiuvzOYwE44Vh7pcdpH2bNkb-aH015fw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
