[ASTPPCOM-893] Dashboard Stats | Wrong Values Created: 16/May/22  Updated: 03/Feb/23  Resolved: 03/Feb/23

Status: Closed
Project: ASTPP Community
Component/s: None
Affects Version/s: v5.0
Fix Version/s: v5.0

Type: Bug Priority: Medium
Reporter: George Dalanai Assignee: Neetu Nogia
Resolution: Done Votes: 0
Labels: new_bug
Remaining Estimate: Not Specified
Time Spent: 13.5h
Original Estimate: Not Specified

Attachments: PNG File admin.png     PNG File customer.png     PNG File image-2022-05-16-18-08-51-915.png     PNG File image-2022-05-16-18-12-21-017.png     PNG File image-2022-06-23-15-55-56-153.png     PNG File image-2022-06-23-15-56-29-484.png     PNG File image-2022-06-23-15-57-30-847.png    
Issue Links:
Relates
relates to ASTPPCOM-891 Different timezone CDR recording Reopened
relates to ASTPPCOM-1343 Error showing CDR after 9PM in Americ... Reopened
Reproducibility: always
Category: UI
Edition: Community

 Description   

Hi everyone,

I have opened this issue on the forum and was instructed to report it as a bug.

https://forum.astppbilling.org/t/dashboard-stats-wrong-values/1213

 

As per my understanding the dashboard displays stats on a weekly base or monthly.

I don't know if I am the only one that faces this issue so please confirm the following.

 

You can see I have 2 trunks. The total amount of the calls that went through both of them is 56 calls. You can see on the red bar that today's calls are displayed as 35.

When I go to Reports -> Call Detail Reports -> Customer

    • I can see that the amount of calls is indeed correct (according to the ones terminated from the trunks)

Since there are calls missing from the dashboard, the debit amount and the profit is also wrong.

Something else that I believe is wrong is the fact that any calls which were not answered, are probably displayed as failed calls.

 

This installation is done in a VM with debian 10 and the v5 community script.

To sum up, please confirm the following:

  • Do you see the same behavior on todays/weekly/monthly calls?
  • Should the calls that were not answered, be displayed as failed calls?

Let me know if you need additional information.



 Comments   
Comment by Neetu Nogia [ 23/May/22 ]

Hello George Dalanai

Good day,

We are working on it, please allow us some time will update you asap.

Thank You

Comment by Neetu Nogia [ 22/Jun/22 ]

Hello George Dalanai

Good day,

We have checked in the local system it is working fine, we can not find any issue in the local system.

SHOW CREATE PROCEDURE get_cdr_records;
---------------------------------------------------
SHOW CREATE PROCEDURE master_pro;
------------------------------------------------
SHOW EVENTS FROM astpp;

I am sharing a few commands please run these commands on the database and check the response.

Thank You 

Comment by George Dalanai [ 23/Jun/22 ]

Hello Neetu,

Here are the results:

Please take into consideration that I have multiple trunks on the configured installation. 

Please keep me updated.

 

Comment by Neetu Nogia [ 30/Jun/22 ]

Hello George Dalanai

Good day,

We are checking your concern with our developer team please allow us some time ill update you asap.

Thank You

Comment by George Dalanai [ 24/Aug/22 ]

Hi,

Do you have any updates on this?

Thanks

Comment by Ashish Gohil [ 02/Jan/23 ]

This issue is resolved in ASTPPCOM-891

Comment by George Dalanai [ 02/Jan/23 ]

Thank you for the update. 

I have reported a bug for version 5. The update on source code is for version 6. Can i use the same files? 

Comment by Ashish Gohil [ 02/Jan/23 ]

Hello George Dalanai, kindly please wait for confirmation, need to check on version 5.

as we fixed it on version 6.

we will share update here.

Thanks

Ashish Gohil

Comment by Danilo Borges [ 03/Jan/23 ]

Hello,
After updating the 8 modified files at https://github.com/iNextrix/ASTPP/pull/681 I got the following analysis:
Test basis: 6 calls were made before 9PM and 2 calls after 9PM.

Admin Area:

  • Regardless of the time, the Dashboard in the graphics part is reset throughout the day, without any movement.
  • In the table on the side where the Daily and Monthly column is shown with the ASR, ACD, MCD, Total Calls, Debit, Cost, Profit data, it can be noted that before 9PM the Today column has all the data with the value 0 , and the This Month column shows inconsistent values.
  • In the box in red Total Calls the top line Today is always 0 regardless of the time and in the total calls it only shows the calls made until 9PM.
  • In the black Refills box, the top line Today is always 0 regardless of the time and in total it only shows refills made after 9PM.
  • In the Trunk Statistics box until 9PM it shows the names of the trunks with all the correct data, but after 9PM it has no data, not even the names of the trunks are shown.
  • In Billing>>Refill Report: it does not show any refills made in the system, not even filtering by other previous and subsequent dates.
  • In Reports>>Call Detail Reports>>Customer: now it shows the 8 calls made throughout the day, congratulations.
  • In Reports>>Call Summary Reports>>Customer Summary and also in Reports>>Call Summary Reports>>Provider: the error continues, it does not show any data, after clicking on the search magnifying glass then yes it shows the data only the 6 calls until 9PM, to show the report with the other two calls made after 9PM we must select until the next day for them to be shown.

Customer Area:

  • In the red box Todays Calls the value is always 0 at any time!
  • In Reports>>CDRs: the problem was solved, now it shows the 8 calls made during the day, congratulations.

Attached are customer.png and admin.png images showing the affected fields.

Generated at Sat Feb 10 07:21:13 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.