[ASTPPCOM-1343] Error showing CDR after 9PM in America/Sao_Paulo time zone (GMT -03:00) Created: 10/Dec/22  Updated: 03/Jan/23

Status: Reopened
Project: ASTPP Community
Component/s: None
Affects Version/s: v6.0
Fix Version/s: None

Type: Bug Priority: Medium
Reporter: Danilo Borges Assignee: Harsh Patel
Resolution: Unresolved Votes: 0
Labels: bug_confirmed
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File admin.png     File astpp cdr.webm     PNG File astpp Todays Calls admin.png     PNG File astpp Todays Calls.png     File chrome_Q2qh3KkE4S.mp4     File chrome_r1yasoMLdH.mp4     PNG File customer.png    
Issue Links:
Relates
relates to ASTPPCOM-891 Different timezone CDR recording Reopened
relates to ASTPPCOM-893 Dashboard Stats | Wrong Values Closed
Reproducibility: always
Category: UI
Edition: Community

 Description   

Error showing CDR after 9PM, I believe it is some error with time zone, time zone in ASTPP America/Sao_Paulo (GMT -03:00).
After 9PM, calls made before that time are not shown in the report, but I just filter by day they appear. On the main screen of ASTPP, in the red box where the calls of the day are shown, the calls are also shown only after 9PM, during the day there are several calls, but it only shows 1 call. but explaining this to the customer is difficult, see the problem in the attached video.

On the admin side we also have the same problem, please see in the attachment that it shows in two fields 1 called where it should show 0.

Thanks and regards.



 Comments   
Comment by Prashant Kumar [ 22/Dec/22 ]

Verified in latest source community v6.0 and confirmed as per verification :- 

I found below error :- 

1. In sao paulo timezone, In cdrs grid before 9:00 PM cdrs not displayed automatically into grid. it only displayed recent call record which are make after 9:00 PM.

2. In Todays or Todays Total call option under dashboard page, total Todays call count didin't considered which calls are already make before 9:00 PM at same day.

See Latest attached videos :- 

 

Comment by Ashish Gohil [ 02/Jan/23 ]

This issue is resolved in ASTPPCOM-891

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:25:17 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.