Hello, I'm making a list of potential customers, in about two months, we will have a business plan ready and we will issue a digital token (ICO) based on our product in the company. Would you be interested in learning more ...?
Dne so 5. čvn 2021 19:09 uživatel Lalit Suthar <[email protected]> napsal: > just replied to your mail > > On Sat, 5 Jun 2021 at 11:48, Eugene TUYIZERE <[email protected]> > wrote: > >> Dear Suthar, >> >> Can I have your private contact? >> >> regards, >> >> On Fri, 4 Jun 2021 at 06:25, Lalit Suthar <[email protected]> >> wrote: >> >>> my pleasure :) >>> >>> On Thu, 3 Jun 2021 at 20:28, Eugene TUYIZERE <[email protected]> >>> wrote: >>> >>>> Dear Suthar, >>>> >>>> Thank you very much. It works well. >>>> >>>> >>>> On Thu, 3 Jun 2021 at 16:48, Lalit Suthar <[email protected]> >>>> wrote: >>>> >>>>> not sure but maybe this can work inside views replace >>>>> chart = { >>>>> 'chart': {'type': 'column'}, >>>>> 'title': {'text': 'Previous statistics'}, >>>>> 'xAxis': {'replist': replist}, >>>>> 'series': [arriva_days] >>>>> } >>>>> with >>>>> chart = { >>>>> 'chart': {'type': 'column'}, >>>>> 'title': {'text': 'Previous statistics'}, >>>>> 'xAxis': {'categories': replist}, >>>>> 'series': [arriva_days] >>>>> } >>>>> >>>>> On Thu, 3 Jun 2021 at 18:00, Eugene TUYIZERE <[email protected]> >>>>> wrote: >>>>> >>>>>> This what I have in summarizedchart.html: >>>>>> >>>>>> {% extends "layouts/base.html" %} >>>>>> {% load static %} >>>>>> {% block title %} Repport {% endblock %} >>>>>> >>>>>> <!-- Specific CSS goes HERE --> >>>>>> {% block stylesheets %}{% endblock stylesheets %} >>>>>> >>>>>> {% block content %} >>>>>> >>>>>> <div class="pcoded-main-container"> >>>>>> <div class="pcoded-content"> >>>>>> <div class="col-lg-12"> >>>>>> <div class="card table-card"> >>>>>> <div class="card-header"> >>>>>> <h5>Report</h5> >>>>>> >>>>>> <hr> >>>>>> >>>>>> <script src="{% static 'assets/js/chart.js' %}"></script> >>>>>> >>>>>> <div id="container"></div> >>>>>> <script> >>>>>> Highcharts.chart('container', {{ chart|safe }}); >>>>>> </script> >>>>>> </div> >>>>>> </div> >>>>>> </div> >>>>>> </div> >>>>>> </div> >>>>>> {% endblock content %} >>>>>> {% block custom_js %} >>>>>> >>>>>> {% endblock custom_js %} >>>>>> >>>>>> On Thu, 3 Jun 2021 at 14:22, Lalit Suthar <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> so the view is not giving error right now but maybe we are passing >>>>>>> the data in different format then the chart is expecting. >>>>>>> What are you using for drawing the chart? can I see the code inside >>>>>>> "summarizedchart.html" >>>>>>> >>>>>>> On Thu, 3 Jun 2021 at 17:43, Eugene TUYIZERE < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Dear Suthar, >>>>>>>> >>>>>>>> You saved my day. Once more, the chart is displayed but the date is >>>>>>>> not displayed on Xaxis. This how it is: >>>>>>>> >>>>>>>> [image: image.png] >>>>>>>> >>>>>>>> Th codes are: >>>>>>>> def reqChart(request): >>>>>>>> current_date = date.today() >>>>>>>> days_before = date.today()-timedelta(days=30) >>>>>>>> datelist = Customer_Requests.objects.values("arrival_date"). >>>>>>>> annotate(num_req=Count("request_name")).order_by('-arrival_date')[: >>>>>>>> 20:-1] >>>>>>>> replist = list() >>>>>>>> sumdata = list() >>>>>>>> for listd in datelist: >>>>>>>> replist.append(listd['arrival_date']) >>>>>>>> sumdata.append(listd['num_req']) >>>>>>>> arriva_days = { >>>>>>>> 'name': 'Datess', >>>>>>>> 'data': sumdata, >>>>>>>> 'color': 'green' >>>>>>>> } >>>>>>>> chart = { >>>>>>>> 'chart': {'type': 'column'}, >>>>>>>> 'title': {'text': 'Previous statistics'}, >>>>>>>> 'xAxis': {'replist': replist}, >>>>>>>> 'series': [arriva_days] >>>>>>>> } >>>>>>>> dump = json.dumps(chart,cls=DjangoJSONEncoder) >>>>>>>> return render(request,'summarizedchart.html',{'chart': dump}) >>>>>>>> >>>>>>>> >>>>>>>> On Thu, 3 Jun 2021 at 13:27, lalit suthar <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Hi there! >>>>>>>>> make these couple of changes >>>>>>>>> >>>>>>>>> 1) from django.core.serializers.json import DjangoJSONEncoder >>>>>>>>> 2) dump3 = json.dumps(chart3, cls=DjangoJSONEncoder) >>>>>>>>> On Thursday, 3 June 2021 at 16:18:15 UTC+5:30 [email protected] >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Dear Suthar, >>>>>>>>>> >>>>>>>>>> Your idea works well , but I want now to display the result on >>>>>>>>>> chart. Below is the code I am trying to use: >>>>>>>>>> but Am getting the error message: >>>>>>>>>> >>>>>>>>>> Exception Value: >>>>>>>>>> >>>>>>>>>> Object of type date is not JSON serializable >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> def reqChart(request): >>>>>>>>>> aa = Customer_Requests.objects.values("arrival_date").annotate( >>>>>>>>>> num_req=Count("request_name")).order_by('-arrival_date')[:20:-1] >>>>>>>>>> print(aa) >>>>>>>>>> datesb = list() >>>>>>>>>> sumdata = list() >>>>>>>>>> for dd in aa: >>>>>>>>>> datesb.append(dd['arrival_date']) >>>>>>>>>> sumdata.append(dd['num_req']) >>>>>>>>>> arriva_days = { >>>>>>>>>> 'name': 'Datess', >>>>>>>>>> 'data': sumdata, >>>>>>>>>> 'color': 'green' >>>>>>>>>> } >>>>>>>>>> chart3 = { >>>>>>>>>> 'chart': {'type': 'column'}, >>>>>>>>>> 'title': {'text': 'Previous statistics'}, >>>>>>>>>> 'xAxis': {'datesb': datesb}, >>>>>>>>>> 'series': [arriva_days] >>>>>>>>>> } >>>>>>>>>> dump3 = json.dumps(chart3) >>>>>>>>>> return render(request,'summarizedchart.html',{'chart3': dump3}) >>>>>>>>>> >>>>>>>>>> Please once again >>>>>>>>>> >>>>>>>>>> regards, >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Thu, 3 Jun 2021 at 09:00, lalit suthar <[email protected]> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> this will do >>>>>>>>>>> >>>>>>>>>>> Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name")).order_by("-id")[:30:-1] >>>>>>>>>>> >>>>>>>>>>> On Thursday, 3 June 2021 at 11:37:26 UTC+5:30 >>>>>>>>>>> [email protected] wrote: >>>>>>>>>>> >>>>>>>>>>>> to display last 30 records you can write your code like this: >>>>>>>>>>>> Customer_Requests.objects.all()[-30] >>>>>>>>>>>> >>>>>>>>>>>> On Thu, Jun 3, 2021 at 10:51 AM Eugene TUYIZERE < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Dear Latit, >>>>>>>>>>>>> >>>>>>>>>>>>> Thank you very much. Now how can I display 30 last records? >>>>>>>>>>>>> Regardless of how many records I may have ! Just the last 30 >>>>>>>>>>>>> records! >>>>>>>>>>>>> >>>>>>>>>>>>> Thank you >>>>>>>>>>>>> >>>>>>>>>>>>> On Thu, 3 Jun 2021 at 06:51, Lalit Suthar < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> > in brief, I want to transform this query in django query >>>>>>>>>>>>>> this will be equivalent to this query in django >>>>>>>>>>>>>> >>>>>>>>>>>>>> Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name")) >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Thu, 3 Jun 2021 at 02:02, Eugene TUYIZERE < >>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> in brief, I want to transform this query in django query >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> [image: image.png] >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Wed, 2 Jun 2021 at 21:56, Eugene TUYIZERE < >>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Dear Sebatian, >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> This is what I get: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-03 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-04 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-05 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-06 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-07 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-08 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-09 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-10 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-11 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-12 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-13 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-14 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-15 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-16 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-17 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-18 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-19 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-20 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-21 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-22 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-23 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-24 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-25 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-26 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-27 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-28 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-29 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-30 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-05-31 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-06-01 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> SELECT `crms_customer_requests`.`arrival_date`, >>>>>>>>>>>>>>>> COUNT(`crms_customer_requests`.`request_name`) AS `count` FROM >>>>>>>>>>>>>>>> `crms_customer_requests` WHERE >>>>>>>>>>>>>>>> `crms_customer_requests`.`arrival_date` >= >>>>>>>>>>>>>>>> 2021-06-02 GROUP BY `crms_customer_requests`.`arrival_date` >>>>>>>>>>>>>>>> ORDER BY NULL >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Wed, 2 Jun 2021 at 21:53, Sebastian Jung < >>>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Hi Eugene, >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Please make Print(report.query) then you get SQL querys >>>>>>>>>>>>>>>>> and Most of time i get an Idea what's wrong >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Regards >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Eugene TUYIZERE <[email protected]> schrieb am Mi., 2. >>>>>>>>>>>>>>>>> Juni 2021, 21:41: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Dear Team, >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> I need help. I am working on a project where one of the >>>>>>>>>>>>>>>>>> tables is about requests. I want to have a report of the >>>>>>>>>>>>>>>>>> number of requests >>>>>>>>>>>>>>>>>> on each day in the last 30 days, something like this: >>>>>>>>>>>>>>>>>> [image: image.png]I I used the code below just before >>>>>>>>>>>>>>>>>> displaying on the chart but the code gives me wrong >>>>>>>>>>>>>>>>>> information >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> def reqChart(request): >>>>>>>>>>>>>>>>>> current_date = date.today() >>>>>>>>>>>>>>>>>> days_before = date.today()-timedelta(days=30) >>>>>>>>>>>>>>>>>> for dt in daterange(days_before,current_date): >>>>>>>>>>>>>>>>>> reports = Customer_Requests.objects.filter( >>>>>>>>>>>>>>>>>> arrival_date__gte=dt).\ >>>>>>>>>>>>>>>>>> extra({'day':"date(arrival_date)"}).\ >>>>>>>>>>>>>>>>>> values('arrival_date').annotate(count=Count( >>>>>>>>>>>>>>>>>> 'request_name')) >>>>>>>>>>>>>>>>>> print(reports) >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> And I need help >>>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>>>>> [email protected]. >>>>>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHstWyfMVKQhJb%3DxGKff3p3V%2BFQ_w3DkYVpOe-pEW2ySKg%40mail.gmail.com >>>>>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHstWyfMVKQhJb%3DxGKff3p3V%2BFQ_w3DkYVpOe-pEW2ySKg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>> 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 [email protected] >>>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CAKGT9myp4HU6%2BZo6d-JqeaTPsevFBMi_DzU_xuwo3LUja%3DxzRw%40mail.gmail.com >>>>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CAKGT9myp4HU6%2BZo6d-JqeaTPsevFBMi_DzU_xuwo3LUja%3DxzRw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> 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 [email protected]. >>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHtJhxd3-B%3DpzsAhqg_kR68zTvbJKd%2BgeBUqRjGMP%2BxgxQ%40mail.gmail.com >>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHtJhxd3-B%3DpzsAhqg_kR68zTvbJKd%2BgeBUqRjGMP%2BxgxQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>> . >>>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> 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 [email protected]. >>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CAGp2JVGM87kRnp%2BZY_J8fKb2d_mU5Vvxv033oQSZ-ChHAeiFCA%40mail.gmail.com >>>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CAGp2JVGM87kRnp%2BZY_J8fKb2d_mU5Vvxv033oQSZ-ChHAeiFCA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>> . >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>>>>> >>>>>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>>>>> >>>>>>>>>>>>> Bsc in Computer Science >>>>>>>>>>>>> >>>>>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>>>>> >>>>>>>>>>>>> Email: [email protected] >>>>>>>>>>>>> [email protected] >>>>>>>>>>>>> >>>>>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> 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 [email protected]. >>>>>>>>>>>>> >>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com >>>>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHviuVHHqyod0f5miLA1Z2n73P%2B3xXWOs-7XLmi2epD-7w%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>> . >>>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>> 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 [email protected]. >>>>>>>>>>> >>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>> https://groups.google.com/d/msgid/django-users/85a1d671-d5c9-4f97-9f34-b6f1e1b36bcfn%40googlegroups.com >>>>>>>>>>> <https://groups.google.com/d/msgid/django-users/85a1d671-d5c9-4f97-9f34-b6f1e1b36bcfn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>> . >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> *TUYIZERE Eugene* >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>>>> >>>>>>>>>> *African Institute for Mathematical Sciences (AIMS >>>>>>>>>> Cameroon)Crystal Garden-Lime, Cameroon* >>>>>>>>>> >>>>>>>>>> Bsc in Computer Science >>>>>>>>>> >>>>>>>>>> *UR-Nyagatare Campus* >>>>>>>>>> >>>>>>>>>> Email: [email protected] >>>>>>>>>> [email protected] >>>>>>>>>> >>>>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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 [email protected]. >>>>>>>>> To view this discussion on the web visit >>>>>>>>> https://groups.google.com/d/msgid/django-users/63a82f60-e533-41f5-b1e9-0159b37b58b0n%40googlegroups.com >>>>>>>>> <https://groups.google.com/d/msgid/django-users/63a82f60-e533-41f5-b1e9-0159b37b58b0n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> *TUYIZERE Eugene* >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> *Msc Degree in Mathematical Science* >>>>>>>> >>>>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >>>>>>>> Garden-Lime, Cameroon* >>>>>>>> >>>>>>>> Bsc in Computer Science >>>>>>>> >>>>>>>> *UR-Nyagatare Campus* >>>>>>>> >>>>>>>> Email: [email protected] >>>>>>>> [email protected] >>>>>>>> >>>>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>>>> >>>>>>>> -- >>>>>>>> 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 [email protected]. >>>>>>>> To view this discussion on the web visit >>>>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHsJVbdpwEwpp-_kM3PN6xZ59reCvbJbzMgE_2pSxMeiRA%40mail.gmail.com >>>>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHsJVbdpwEwpp-_kM3PN6xZ59reCvbJbzMgE_2pSxMeiRA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>> . >>>>>>>> >>>>>>> -- >>>>>>> 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 [email protected]. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/django-users/CAGp2JVHmjfN3_KFB9eMk%2BzMtii9QeDy4dL1qFKMT%2BRVjQOFrFA%40mail.gmail.com >>>>>>> <https://groups.google.com/d/msgid/django-users/CAGp2JVHmjfN3_KFB9eMk%2BzMtii9QeDy4dL1qFKMT%2BRVjQOFrFA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *TUYIZERE Eugene* >>>>>> >>>>>> >>>>>> >>>>>> *Msc Degree in Mathematical Science* >>>>>> >>>>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >>>>>> Garden-Lime, Cameroon* >>>>>> >>>>>> Bsc in Computer Science >>>>>> >>>>>> *UR-Nyagatare Campus* >>>>>> >>>>>> Email: [email protected] >>>>>> [email protected] >>>>>> >>>>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>>>> >>>>>> -- >>>>>> 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 [email protected]. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/django-users/CABxpZHuvFye2tB2rSS_uWB4g2DXAjLTG2i0zvzO1rDpdqJtvNQ%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/django-users/CABxpZHuvFye2tB2rSS_uWB4g2DXAjLTG2i0zvzO1rDpdqJtvNQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- >>>>> 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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/django-users/CAGp2JVGh3zGsJ%2BtwRqKYxdoUEo3-Pr72uHC7B8LZRPbQm%3DHwQQ%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/django-users/CAGp2JVGh3zGsJ%2BtwRqKYxdoUEo3-Pr72uHC7B8LZRPbQm%3DHwQQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> >>>> >>>> -- >>>> *TUYIZERE Eugene* >>>> >>>> >>>> >>>> *Msc Degree in Mathematical Science* >>>> >>>> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >>>> Garden-Lime, Cameroon* >>>> >>>> Bsc in Computer Science >>>> >>>> *UR-Nyagatare Campus* >>>> >>>> Email: [email protected] >>>> [email protected] >>>> >>>> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >>>> >>>> -- >>>> 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 [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/CABxpZHsFtuHWY0rJuxfPOteAUZuPG%2BJ3G-av%3DSeP8DiWYAs6kw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/django-users/CABxpZHsFtuHWY0rJuxfPOteAUZuPG%2BJ3G-av%3DSeP8DiWYAs6kw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/CAGp2JVHSq%3DC2wyp%3D8arnm1xn1BkuU53nb6J2YyW%2BFwYBnB9UNA%40mail.gmail.com >>> <https://groups.google.com/d/msgid/django-users/CAGp2JVHSq%3DC2wyp%3D8arnm1xn1BkuU53nb6J2YyW%2BFwYBnB9UNA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> -- >> *TUYIZERE Eugene* >> >> >> >> *Msc Degree in Mathematical Science* >> >> *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal >> Garden-Lime, Cameroon* >> >> Bsc in Computer Science >> >> *UR-Nyagatare Campus* >> >> Email: [email protected] >> [email protected] >> >> Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 >> >> -- >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CABxpZHtM-tgH77BN%3DHa5zyHgkR8APBU5%3DVHu4TFKYe6_PRSeRQ%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CABxpZHtM-tgH77BN%3DHa5zyHgkR8APBU5%3DVHu4TFKYe6_PRSeRQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAGp2JVHuZ%2BxF9nQMBCC4g8XqN74n7ZAWNWK4%3D5XDMcXKS6m%2BFQ%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAGp2JVHuZ%2BxF9nQMBCC4g8XqN74n7ZAWNWK4%3D5XDMcXKS6m%2BFQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2BCuM3CFG5NiGsvMjSf9CmVOpsRtBF8TW83y8c1A1zkcqMA-wA%40mail.gmail.com.
