2023-05-05 3:22:04 - INFO --> [DailyReport], [Date], StartDate [2023-05-04 00:00:00], EndDate [2023-05-04 23:59:59],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from transactions 
2023-05-05 3:22:04 - INFO --> [DailyReport], [count], [10],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' 
2023-05-05 3:22:04 - INFO --> [DailyReport], [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND status='2' 
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps], [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from subscribers where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59'  
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from churns where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59'  
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='3' AND status='1'  
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='3' AND status='2'  
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='4' AND status='1'  
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:22:04 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='4' AND status='2'  
2023-05-05 3:22:04 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:22:04 - 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-04', '10', '0', '1','0','0','0','0', '0','0','0','', now(), now());
2023-05-05 3:23:15 - INFO --> [DailyReport], [Date], StartDate [2023-05-04 00:00:00], EndDate [2023-05-04 23:59:59],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from transactions 
2023-05-05 3:23:15 - INFO --> [DailyReport], [count], [10],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' 
2023-05-05 3:23:15 - INFO --> [DailyReport], [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND status='2' 
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps], [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from subscribers where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59'  
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from churns where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59'  
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='3' AND status='1'  
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='3' AND status='2'  
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='4' AND status='1'  
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:23:15 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-04 00:00:00' AND '2023-05-04 23:59:59' AND operation='4' AND status='2'  
2023-05-05 3:23:15 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-05 3:23:15 - 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-04', '10', '0', '1','0','0','0','0', '0','0','0', now(), now());
2023-05-05 3:23:15 - INFO --> [DailyReport],Report Created
2023-05-05 7:50:14 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-04-10 23:59:59], Reportname [AAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:50:14 - INFO --> [report Content], [Date], From [2023-04-01 00:00:00], To [2023-04-10 23:59:59] No Report FOUND
2023-05-05 7:51:19 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:51:19 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:51:52 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:51:52 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:51:52 - INFO --> insert into Reports (from_date, to_date, user_id, report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59', '', 'AAAAAAAAAAAAAAAAA','http://sapdemo.thinkstraight.org/backend/reports/AAAAAAAAAAAAAAAAA_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','', now(), now());
2023-05-05 7:54:13 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:54:13 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:54:13 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAAAAAAAAAAAAAAAA','http://sapdemo.thinkstraight.org/backend/reports/AAAAAAAAAAAAAAAAA_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','', now(), now());
2023-05-05 7:54:35 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:54:35 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:54:35 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAAAAAAAAAAAAAAAA','http://sapdemo.thinkstraight.org/backend/reports/AAAAAAAAAAAAAAAAA_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','', now(), now());
2023-05-05 7:54:59 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:54:59 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:54:59 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAAAAAAAAAAAAAAAA','http://sapdemo.thinkstraight.org/backend/reports/AAAAAAAAAAAAAAAAA_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','', now(), now());
2023-05-05 7:55:45 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:55:45 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:55:45 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAAAAAAAAAAAAAAAA','http://sapdemo.thinkstraight.org/backend/reports/AAAAAAAAAAAAAAAAA_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','', now(), now());
2023-05-05 7:56:18 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:56:18 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAAAAAAAAAAAAAAAA], UserId [1] Operation [1] 
2023-05-05 7:56:18 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAAAAAAAAAAAAAAAA','http://sapdemo.thinkstraight.org/backend/reports/AAAAAAAAAAAAAAAAA_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','1', now(), now());
2023-05-05 7:56:18 - INFO --> [report Content], LastId [1]
2023-05-05 7:56:18 - INFO --> select * from apps where id = '7'
2023-05-05 7:56:18 - INFO --> select * from apps where id = '7'
2023-05-05 7:56:18 - INFO --> select * from apps where id = '32'
2023-05-05 7:56:18 - INFO --> select * from apps where id = '32'
2023-05-05 7:56:18 - INFO --> select * from apps where id = '38'
2023-05-05 7:56:18 - INFO --> select * from apps where id = '38'
2023-05-05 7:56:18 - INFO --> select * from apps where id = '7'
2023-05-05 7:56:18 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-30 23:59:59],Datacount,[7]
2023-05-05 7:57:21 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 7:57:21 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 7:57:21 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAfggdgdgdgf','http://sapdemo.thinkstraight.org/backend/reports/AAfggdgdgdgf_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','1', now(), now());
2023-05-05 7:58:59 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 7:58:59 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 7:58:59 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAfggdgdgdgf','http://sapdemo.thinkstraight.org/backend/reports/AAfggdgdgdgf_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','1', now(), now());
2023-05-05 7:58:59 - INFO --> [report Content], LastId [48]
2023-05-05 7:58:59 - INFO --> select * from apps where id = '7'
2023-05-05 7:58:59 - INFO --> select * from apps where id = '7'
2023-05-05 7:58:59 - INFO --> select * from apps where id = '32'
2023-05-05 7:58:59 - INFO --> select * from apps where id = '32'
2023-05-05 7:58:59 - INFO --> select * from apps where id = '38'
2023-05-05 7:58:59 - INFO --> select * from apps where id = '38'
2023-05-05 7:58:59 - INFO --> select * from apps where id = '7'
2023-05-05 7:58:59 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-30 23:59:59],Datacount,[7]
2023-05-05 8:10:32 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 8:10:32 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 8:10:32 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAfggdgdgdgf','http://sapdemo.thinkstraight.org/backend/reports/AAfggdgdgdgf_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','1', now(), now());
2023-05-05 8:10:32 - INFO --> [report Content], LastId [49]
2023-05-05 8:10:32 - INFO --> select * from apps where id = '7'
2023-05-05 8:10:32 - INFO --> select * from apps where id = '7'
2023-05-05 8:10:32 - INFO --> select * from apps where id = '32'
2023-05-05 8:10:32 - INFO --> select * from apps where id = '32'
2023-05-05 8:10:32 - INFO --> select * from apps where id = '38'
2023-05-05 8:10:32 - INFO --> select * from apps where id = '38'
2023-05-05 8:10:32 - INFO --> select * from apps where id = '7'
2023-05-05 8:10:32 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-30 23:59:59],Datacount,[7]
2023-05-05 8:12:04 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 8:12:04 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 8:12:04 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAfggdgdgdgf','http://sapdemo.thinkstraight.org/backend/reports/AAfggdgdgdgf_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','1', now(), now());
2023-05-05 8:12:04 - INFO --> [report Content], LastId [50]
2023-05-05 8:12:04 - INFO --> select * from apps where id = '7'
2023-05-05 8:12:04 - INFO --> select * from apps where id = '7'
2023-05-05 8:12:04 - INFO --> select * from apps where id = '32'
2023-05-05 8:12:04 - INFO --> select * from apps where id = '32'
2023-05-05 8:12:04 - INFO --> select * from apps where id = '38'
2023-05-05 8:12:04 - INFO --> select * from apps where id = '38'
2023-05-05 8:12:04 - INFO --> select * from apps where id = '7'
2023-05-05 8:12:04 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-30 23:59:59],Datacount,[7]
2023-05-05 8:12:47 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 8:12:47 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [AAfggdgdgdgf], UserId [1] Operation [1] 
2023-05-05 8:12:47 - INFO --> insert into Reports (from_date, to_date,  report_name, file_path, operation,status,created_at,updated_at) values('2023-04-01 00:00:00', '2023-05-30 23:59:59',  'AAfggdgdgdgf','http://sapdemo.thinkstraight.org/backend/reports/AAfggdgdgdgf_2023-04-01 00:00:00_ 2023-05-30 23:59:59.csv', '1','1', now(), now());
2023-05-05 8:12:48 - INFO --> [report Content], LastId [51]
2023-05-05 8:12:48 - INFO --> select * from apps where id = '7'
2023-05-05 8:12:48 - INFO --> select * from apps where id = '7'
2023-05-05 8:12:48 - INFO --> select * from apps where id = '32'
2023-05-05 8:12:48 - INFO --> select * from apps where id = '32'
2023-05-05 8:12:48 - INFO --> select * from apps where id = '38'
2023-05-05 8:12:48 - INFO --> select * from apps where id = '38'
2023-05-05 8:12:48 - INFO --> select * from apps where id = '7'
2023-05-05 8:12:48 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-30 23:59:59],Datacount,[7]
2023-05-05 8:12:48 - INFO --> UPDATE Reports set status='2', user_id='81' where id='51' 
