2023-05-06 5:56:22 - INFO --> [DailyReport], [Date], StartDate [2023-05-05 00:00:00], EndDate [2023-05-05 23:59:59],
2023-05-06 5:56:22 - INFO --> select COUNT(*) as count from content_providers where status='5' 
2023-05-06 5:56:22 - INFO --> [DailyReport], [count], [5],
2023-05-06 5:59:38 - INFO --> [DailyReport], [Date], StartDate [2023-05-05 00:00:00], EndDate [2023-05-05 23:59:59],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from content_providers where status='5' 
2023-05-06 5:59:38 - INFO --> [DailyReport], [count], [5],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from content_providers where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59' and status='5'  
2023-05-06 5:59:38 - INFO --> [DailyReport], [count], [0],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [5],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59' AND status='2' 
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps], [count], [0],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from subscribers where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59'  
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from churns where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59'  
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59' AND operation='3' AND status='1'  
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59' AND operation='3' AND status='2'  
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59' AND operation='4' AND status='1'  
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [1],
2023-05-06 5:59:38 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-05 00:00:00' AND '2023-05-05 23:59:59' AND operation='4' AND status='2'  
2023-05-06 5:59:38 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-06 5:59:38 - INFO --> insert into daily_reports (report_date, total_partner, new_partners, total_apps_live, new_apps_live, subs,unsubs,billing_sucess,billing_failed,payment_sucess,payment_failed,created_at,updated_at) values('2023-05-05', '5', '0', '1','0','0','0','0', '0','1','0', now(), now());
2023-05-06 5:59:38 - INFO --> [DailyReport],Report Created
