magnussolution / magnusbilling7

MagnusBilling is a fast, secure, efficient, high availability, VOIP Billing.
https://www.magnusbilling.org
GNU Lesser General Public License v3.0
182 stars 106 forks source link

Option to delete the Reports Sumary #582

Open xceedconnections opened 2 years ago

xceedconnections commented 2 years ago

Hello, it would be great to add options to delete the Summary Reports

Example: just like we delete the cdr failed.. Please add a button to delete the following

Summary per Day Summary day User Summary dayTrunk Summary per month Summary month user Summary month trunk Summary per user Summary per trunk

deleting from mysql can cause Mbilling stopped working if we do something wrong.

Khaled-IamZ commented 2 years ago

@xceedconnections please find the below solution to delete the Summary Reports via ssh mysql -rroot -p mbilling Enter your mbilling mysql Password

Then copy and paste the below truncate table pkg_cdr_summary_day; truncate table pkg_cdr_summary_day_user; truncate table pkg_cdr_summary_day_trunk; truncate table pkg_cdr_summary_month; truncate table pkg_cdr_summary_month_user; truncate table pkg_cdr_summary_month_trunk; truncate table pkg_cdr_summary_user; truncate table pkg_cdr_summary_trunk;

and this is for Summary Day Agent truncate table pkg_cdr_summary_day_agent;