2023-05-04 9:36:30 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-04-30 23:59:59], Reportname [NEWReport], UserId [1] Operation [1] 
2023-05-04 9:36:30 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-04-30 23:59:59], Reportname [NEWReport], UserId [1] Operation [1] 
2023-05-04 9:36:30 - INFO --> select * from apps where id = '7'
2023-05-04 9:36:30 - INFO --> select * from apps where id = '7'
2023-05-04 9:36:30 - INFO --> select * from apps where id = '32'
2023-05-04 9:36:30 - INFO --> select * from apps where id = '32'
2023-05-04 9:36:30 - INFO --> select * from apps where id = '38'
2023-05-04 9:36:30 - INFO --> select * from apps where id = '38'
2023-05-04 9:36:30 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-04-30 23:59:59],Datacount,[6]
2023-05-04 9:36:30 - 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-04-30 23:59:59', '1', 'NEWReport','http://20.231.6.224/PROJECTS/TxtGhana/SAP/backend/public/reports/NEWReport_2023-04-01 00:00:00_ 2023-04-30 23:59:59.csv', '1','2', now(), now());
2023-05-04 9:59:32 - INFO --> [report Content], [Date], StartDate [2023-04-13 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [sdi], UserId [1] Operation [3] 
2023-05-04 9:59:32 - INFO --> [report Content], [Date], StartDate [2023-04-13 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [sdi], UserId [1] Operation [3] 
2023-05-04 9:59:32 - INFO --> select * from apps where id = '32'
2023-05-04 9:59:32 - INFO --> [CRDreport Content], [Date], From [2023-04-13 00:00:00], To [2023-05-31 23:59:59],Datacount,[1]
2023-05-04 9:59:32 - INFO --> insert into Reports (from_date, to_date, user_id, report_name, file_path, operation,status,created_at,updated_at) values('2023-04-13 00:00:00', '2023-05-31 23:59:59', '1', 'sdi','http://sapdemo.thinkstraight.org/PROJECTS/TxtGhana/SAP/backend/public/reports/sdi_2023-04-13 00:00:00_ 2023-05-31 23:59:59.csv', '3','2', now(), now());
2023-05-04 10:00:45 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-04-30 23:59:59], Reportname [CV], UserId [1] Operation [1] 
2023-05-04 10:00:45 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-04-30 23:59:59], Reportname [CV], UserId [1] Operation [1] 
2023-05-04 10:00:45 - INFO --> select * from apps where id = '7'
2023-05-04 10:00:45 - INFO --> select * from apps where id = '7'
2023-05-04 10:00:45 - INFO --> select * from apps where id = '32'
2023-05-04 10:00:45 - INFO --> select * from apps where id = '32'
2023-05-04 10:00:45 - INFO --> select * from apps where id = '38'
2023-05-04 10:00:45 - INFO --> select * from apps where id = '38'
2023-05-04 10:00:45 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-04-30 23:59:59],Datacount,[6]
2023-05-04 10:00:45 - 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-04-30 23:59:59', '1', 'CV','http://sapdemo.thinkstraight.org/PROJECTS/TxtGhana/SAP/backend/public/reports/CV_2023-04-01 00:00:00_ 2023-04-30 23:59:59.csv', '1','2', now(), now());
2023-05-04 10:05:22 - INFO --> [report Content], [Date], StartDate [2023-04-05 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [sdi], UserId [1] Operation [3] 
2023-05-04 10:05:22 - INFO --> [report Content], [Date], StartDate [2023-04-05 00:00:00], EndDate [2023-05-30 23:59:59], Reportname [sdi], UserId [1] Operation [3] 
2023-05-04 10:05:22 - INFO --> select * from apps where id = '32'
2023-05-04 10:05:22 - INFO --> [CRDreport Content], [Date], From [2023-04-05 00:00:00], To [2023-05-30 23:59:59],Datacount,[1]
2023-05-04 10:05:22 - INFO --> insert into Reports (from_date, to_date, user_id, report_name, file_path, operation,status,created_at,updated_at) values('2023-04-05 00:00:00', '2023-05-30 23:59:59', '1', 'sdi','http://sapdemo.thinkstraight.org/PROJECTS/TxtGhana/SAP/backend/public/reports/sdi_2023-04-05 00:00:00_ 2023-05-30 23:59:59.csv', '3','2', now(), now());
2023-05-04 10:39:28 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [EEEEEEEEEEEEE], UserId [1] Operation [1] 
2023-05-04 10:39:28 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [EEEEEEEEEEEEE], UserId [1] Operation [1] 
2023-05-04 10:39:29 - INFO --> select * from apps where id = '7'
2023-05-04 10:39:29 - INFO --> select * from apps where id = '7'
2023-05-04 10:39:29 - INFO --> select * from apps where id = '32'
2023-05-04 10:39:29 - INFO --> select * from apps where id = '32'
2023-05-04 10:39:29 - INFO --> select * from apps where id = '38'
2023-05-04 10:39:29 - INFO --> select * from apps where id = '38'
2023-05-04 10:39:29 - INFO --> select * from apps where id = '7'
2023-05-04 10:39:29 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-31 23:59:59],Datacount,[7]
2023-05-04 10:39:29 - 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-31 23:59:59', '1', 'EEEEEEEEEEEEE','http://sapdemo.thinkstraight.org/PROJECTS/TxtGhana/SAP/backend/public/reports/EEEEEEEEEEEEE_2023-04-01 00:00:00_ 2023-05-31 23:59:59.csv', '1','2', now(), now());
2023-05-04 11:25:26 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [WWWWW], UserId [1] Operation [1] 
2023-05-04 11:25:26 - INFO --> [report Content], [Date], StartDate [2023-04-01 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [WWWWW], UserId [1] Operation [1] 
2023-05-04 11:25:26 - INFO --> select * from apps where id = '7'
2023-05-04 11:25:26 - INFO --> select * from apps where id = '7'
2023-05-04 11:25:26 - INFO --> select * from apps where id = '32'
2023-05-04 11:25:26 - INFO --> select * from apps where id = '32'
2023-05-04 11:25:26 - INFO --> select * from apps where id = '38'
2023-05-04 11:25:26 - INFO --> select * from apps where id = '38'
2023-05-04 11:25:26 - INFO --> select * from apps where id = '7'
2023-05-04 11:25:26 - INFO --> [CRDreport Content], [Date], From [2023-04-01 00:00:00], To [2023-05-31 23:59:59],Datacount,[7]
2023-05-04 11:25:26 - 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-31 23:59:59', '1', 'WWWWW','http://sapdemo.thinkstraight.org/backend/reports/WWWWW_2023-04-01 00:00:00_ 2023-05-31 23:59:59.csv', '1','2', now(), now());
2023-05-04 11:44:25 - INFO --> [report Content], [Date], StartDate [2023-04-05 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [dfg], UserId [81] Operation [1] 
2023-05-04 11:44:25 - INFO --> [report Content], [Date], StartDate [2023-04-05 00:00:00], EndDate [2023-05-31 23:59:59], Reportname [dfg], UserId [81] Operation [1] 
2023-05-04 11:44:25 - INFO --> select * from apps where id = '7'
2023-05-04 11:44:25 - INFO --> select * from apps where id = '7'
2023-05-04 11:44:25 - INFO --> select * from apps where id = '32'
2023-05-04 11:44:25 - INFO --> select * from apps where id = '32'
2023-05-04 11:44:25 - INFO --> select * from apps where id = '38'
2023-05-04 11:44:25 - INFO --> select * from apps where id = '38'
2023-05-04 11:44:25 - INFO --> select * from apps where id = '7'
2023-05-04 11:44:25 - INFO --> [CRDreport Content], [Date], From [2023-04-05 00:00:00], To [2023-05-31 23:59:59],Datacount,[7]
2023-05-04 11:44:25 - INFO --> insert into Reports (from_date, to_date, user_id, report_name, file_path, operation,status,created_at,updated_at) values('2023-04-05 00:00:00', '2023-05-31 23:59:59', '81', 'dfg','http://sapdemo.thinkstraight.org/backend/reports/dfg_2023-04-05 00:00:00_ 2023-05-31 23:59:59.csv', '1','2', now(), now());
2023-05-04 12:47:06 - INFO --> [report Content], [Date], StartDate [], EndDate [], Reportname [], UserId [] Operation [] 
2023-05-04 12:47:31 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:47:31 - INFO --> select COUNT(*) from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:47:31 - INFO --> [DailyReport], [count], Data[Array],
2023-05-04 12:47:31 - INFO --> insert into Reports (from_date, to_date, user_id, report_name, file_path, operation,status,created_at,updated_at) values('2023-05-03 00:00:00', '2023-05-03 23:59:59', '', '','', '','', now(), now());
2023-05-04 12:47:47 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:47:47 - INFO --> select COUNT(*) from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:47:47 - INFO --> [DailyReport], [count], Data[Array],
2023-05-04 12:48:55 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:48:55 - INFO --> select COUNT(*) from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:48:55 - INFO --> [DailyReport], [count], Data[[{"COUNT(*)":"1"}]],
2023-05-04 12:50:19 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:50:19 - INFO --> select COUNT(*) from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:50:19 - INFO --> [DailyReport], [count], Data[{"COUNT(*)":"1"}],
2023-05-04 12:56:33 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:56:33 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:56:33 - INFO --> [DailyReport], [count], Data[[{"count":"1"}]],
2023-05-04 12:57:20 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:57:20 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:57:20 - INFO --> [DailyReport], [count], Data[],
2023-05-04 12:58:08 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:58:08 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:58:08 - INFO --> [DailyReport], [count], Data[],
2023-05-04 12:58:44 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 12:58:44 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 12:58:44 - INFO --> [DailyReport], [count], Data[1],
2023-05-04 13:12:54 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:14:25 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:14:58 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:14:58 - INFO --> select COUNT(*) as count from transactions 
2023-05-04 13:14:58 - INFO --> [DailyReport], [count], [10],
2023-05-04 13:14:58 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 13:14:58 - INFO --> [DailyReport], [count], [1],
2023-05-04 13:14:58 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-04 13:14:58 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-04 13:14:58 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND status='2' 
2023-05-04 13:14:58 - INFO --> [DailyReport],[Live_apps], [count], [1],
2023-05-04 13:16:11 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:16:11 - INFO --> select COUNT(*) as count from transactions 
2023-05-04 13:16:11 - INFO --> [DailyReport], [count], [10],
2023-05-04 13:16:11 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 13:16:11 - INFO --> [DailyReport], [count], [1],
2023-05-04 13:16:11 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-04 13:16:11 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-04 13:16:11 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND status='2' 
2023-05-04 13:16:11 - INFO --> [DailyReport],[Live_apps], [count], [1],
2023-05-04 13:16:35 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:16:35 - INFO --> select COUNT(*) as count from transactions 
2023-05-04 13:16:35 - INFO --> [DailyReport], [count], [10],
2023-05-04 13:16:35 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 13:16:35 - INFO --> [DailyReport], [count], [1],
2023-05-04 13:16:35 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-04 13:16:35 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-04 13:16:35 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND status='2' 
2023-05-04 13:16:35 - INFO --> [DailyReport],[Live_apps], [count], [1],
2023-05-04 13:25:59 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:25:59 - INFO --> select COUNT(*) as count from transactions 
2023-05-04 13:25:59 - INFO --> [DailyReport], [count], [10],
2023-05-04 13:25:59 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 13:25:59 - INFO --> [DailyReport], [count], [1],
2023-05-04 13:25:59 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-04 13:25:59 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-04 13:25:59 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND status='2' 
2023-05-04 13:25:59 - INFO --> [DailyReport],[Live_apps], [count], [1],
2023-05-04 13:25:59 - INFO --> select COUNT(*) as count from subscribers where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59'  
2023-05-04 13:25:59 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-04 13:25:59 - INFO --> select COUNT(*) as count from churns where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59'  
2023-05-04 13:25:59 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-04 13:38:05 - INFO --> [DailyReport], [Date], StartDate [2023-05-03 00:00:00], EndDate [2023-05-03 23:59:59],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from transactions 
2023-05-04 13:38:05 - INFO --> [DailyReport], [count], [10],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' 
2023-05-04 13:38:05 - INFO --> [DailyReport], [count], [1],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from apps where status='2' 
2023-05-04 13:38:05 - INFO --> [DailyReport],[Live_apps] [count], [10],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from apps where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND status='2' 
2023-05-04 13:38:05 - INFO --> [DailyReport],[Live_apps], [count], [1],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from subscribers where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59'  
2023-05-04 13:38:05 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from churns where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59'  
2023-05-04 13:38:05 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND operation='3' AND status='1'  
2023-05-04 13:38:05 - INFO --> [DailyReport],[Live_apps] [count], [0],
2023-05-04 13:38:05 - INFO --> select COUNT(*) as count from transactions where created_at between '2023-05-03 00:00:00' AND '2023-05-03 23:59:59' AND operation='3' AND status='2'  
2023-05-04 13:38:05 - INFO --> [DailyReport],[Live_apps] [count], [0],