Your Release requires your action.

INSERT INTO `tbl_smthub_ticket` (`id`, `upc_id`, `Subject`, `from_name`, `from_addr`, `to_name`, `to_addr`, `body`, `status`, `tickets_received`, `action`, `ce_status`, `tag_id`, `asana_ticketid`, `asana_status`, `completed_at`, `uid`, `category`) VALUES ('0', 'NULL', 'Account closures email address update', 'Roger bob ', 'mcldevmcl13@gmail.com', 'dev mcl13', 'mcldevmcl14@gmail.com', 'Please update the Account closures email address on may account to: Email: vipsimessssskne@gufum.com', 'Received', '2024-01-19 12:09:00', 'PayPal email address update1', 0, '1', '1206917531239225', 2, '0000-00-00 00:00:00', 2, 1) insert into `tbl_grouplist` (`userid`, `groupid`, `description`, `me_email`) values ('45465', '3', 'RN Users', 'melmetofye@gufum.com') select ku.mail from comm_grouplist gu JOIN users ku ON gu.me_email = 'mcldevmcl13@gmail.com and gu.userid = ku.uid INSERT INTO `tbl_smthub_ticket`(upc_id,Subject,from_name,from_addr,to_name,to_addr,body,status,tickets_received,uid,action,category) VALUES (NULL,'Unlinks all YT channels','frnt dev ','frntdev99@gmail.com','dev mcl13','mcldevmcl13@gmail.com','Please unlink all my youtube channels that linked to my account.','Received',Now(),'73079','3',0); UPDATE `tbl_smthub_ticket` SET `assigned_to` = NULL function ConfirmDialog(action, ac_name, id) { $.ajax({ // url: "../settingmail.php", // method: "POST", type: "post", url: "{{ route('allmail') }}", headers: { 'X-CSRF-TOKEN': '{{ csrf_token() }}' }, data: { ref: "action_check", values: id, }, success: function(response) { console.log('response', response); if (response == '') { if (confirm('This is an unassigned ticket, if you want assign to yourself') == false) { console.log('cancel'); } else { $.ajax({ // url: "../settingmail.php", // method: "POST", type: "post", url: "{{ route('allmail') }}", headers: { 'X-CSRF-TOKEN': '{{ csrf_token() }}' }, data: { ref: "action_update", values: id, user_id: }, success: function(response) { console.log('response', response); } }) var uid = $("#user_uid").val(); var html = ''; if (action == '4') { html = '

Flag:
Comment:

'; } if (action == '3') { html = '

Comment:

'; } $('

').appendTo('body') .html('

Do you want to ' + ac_name + ' for the user id ' + uid + '

' + html + '

') .dialog({ modal: true, title: 'Action1', zIndex: 10000, autoOpen: true, width: '30%', resizable: false, buttons: { schedule: function() { updateAction(action, uid, ac_name); $(this).dialog("close"); }, Cancel: function() { $(this).dialog("close"); } }, close: function(event, ui) { $(this).remove(); } }); $(".ui-dialog-titlebar").css("background", "-webkit-gradient(linear, left top, left bottom, from(#ced6df), to(#b6c6d7))" ); $(".ui-dialog-buttonpane button:contains('Ok')").css("background", "#179bd7"); $(".ui-dialog-buttonpane button:contains('Cancel')").css("background", "#179bd7"); $(".ui-dialog-buttonpane button:contains('Ok')").css("border", "1px solid #179bd7"); $(".ui-dialog-buttonpane button:contains('Cancel')").css("border", "1px solid #179bd7"); $(".ui-dialog-buttonpane button:contains('Ok')").css("color", "#fff"); $(".ui-dialog-buttonpane button:contains('Cancel')").css("color", "#fff"); } } else { var uid = $("#user_uid").val(); var html = ''; if (action == '4') { html = '

Flag:
Comment:

'; } if (action == '3') { html = '

Comment:

'; } $("#HHVHG_action").html(`

`); } }, error: function() {} }); } SQLSTATE[42S22]: Column not found: 1054 Unknown column 'initiated_by' in 'field list' (Connection: mysql, SQL: insert into `tbl_smthub_ticket` (`upc_id`, `subject`, `from_name`, `from_addr`, `to_name`, `to_addr`, `body`, `status`, `tickets_received`, `initiated_by`, `action`) values ('', 'Unlinks all YT channels', 'dev mcl13', 'mcldevmcl13@gmail.com', 'frnt dev ', 'frntdev99@gmail.com', Your Release requires your action.

Dear frnt dev ,

Dear RN user, We have made changes in our side and you should be good now. Can you please confirm the same in your side and let us know if you still have issue ? Thanks 😂

katia McConnell
head of support

https:////www.routenote.com

RouteNote Limited is a limited company registered in England under number 07210563 with it's registered office at Kernow House, Gas Hill, Newham, Truro TR1 2XP.

, 'Send', 2024-04-16 13:58:00, 'Admin', 'composed') SELECT cu.id, ku.roles_name, gu.groupname, GROUP_CONCAT(lu.action_name) AS action_name, cu.allowsupporthun, cu.allshardhub FROM tbl_action_roles AS cu JOIN tbl_roles AS ku ON cu.roles = ku.id JOIN tbl_groupmanagement AS gu ON cu.group = gu.id JOIN tbl_action AS lu ON cu.action IN (1, 3) WHERE cu.show_hide = '0' GROUP BY cu.id, ku.roles_name, gu.groupname, cu.allowsupporthun, cu.allshardhub;

frnt dev

Unlinks all YT channels

No assignee

30-04-24

1 Jan 70

frnt dev

Unlinks all YT channels

No assignee

30-04-24

1 Jan 70

frnt dev

Unlinks all YT channels

No assignee

30-04-24

1 Jan 70

Roger bob

RFS all active releases

Superadmin

28-04-24

4 Apr 24

frnt dev

Unlinks all YT channels

Admin1

09-10-23

4 Apr 24

SELECT SUM(star1)/4 as star1, SUM(star2)/4 as star2, SUM(star3)/4 as star3, SUM(star4)/4 as star4, SUM(star5)/4 as star5 FROM comm_customer WHERE DATE(datetime) >= '2024-04-14' AND DATE(datetime) <= '2024-04-16'; SELECT SUM(star1)/count(*) as star1, SUM(star2)/count(*) as star2, SUM(star3)/count(*) as star3, SUM(star4)/count(*) as star4, SUM(star5)/count(*) as star5, count(*) FROM comm_customer WHERE DATE(datetime) >= '2024-04-14' AND DATE(datetime) <= '2024-04-16'; SELECT SUM(star1)/count(*) as star1, SUM(star2)/count(*) as star2, SUM(star3)/count(*) as star3, SUM(star4)/count(*) as star4, SUM(star5)/count(*) as star5, count(*) FROM comm_customer WHERE DATE(datetime) >= '2024-04-14' AND DATE(datetime) <= '2024-04-14'; INSERT INTO `tbl_custom_users`(`name`, `star`, `message`) VALUES ('Alexander','4','Received a reply within 24 hours. Had no problems with it.'); INSERT INTO `tbl_custom_users`(`name`, `star`, `message`) VALUES ('Emma Willever','5','Thx for everything!'); ⭐️☆ update tbl_autonomous_l2 set date="2024-04-24 04:29:12" where id between 1 and 10; update tbl_autonomous_l2 set date="2024-05-05 04:29:12" where id between 11 and 20; update tbl_autonomous_l2 set date="2024-05-08 04:29:12" where id between 21 and 25; INSERT INTO `tbl_autonomous_l2`(`upc_id`, `mono_track`, `extended_silence`, `30_sec`, `acr_Matching`, `date`) VALUES ('456365',0,0,0,1,NOW()); INSERT INTO `tbl_autonomous_l2`(`upc_id`, `mono_track`, `extended_silence`, `30_sec`, `acr_Matching`, `date`) VALUES ('567465',0,0,1,0,'2024-05-05 04:29:12'); INSERT INTO `tbl_autonomous_l2`(`upc_id`, `mono_track`, `extended_silence`, `30_sec`, `acr_Matching`, `date`) VALUES ('8568568',0,1,0,0,'2024-04-25 04:29:12'); CREATE TABLE `tbl_heatmap` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mon` int(225) DEFAULT 0, `tue` int(255) DEFAULT 0, `wed` int(255) DEFAULT 0, `thu` int(255) DEFAULT 0, `fri` int(255) DEFAULT 0, `time` varchar(255) NOT NULL, `datetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci insert into tbl_heatmap (mon, tue, wed, thu, fri, time) values (98, 80, 61, 87, 126, '8 AM'); insert into tbl_heatmap (mon, tue, wed, thu, fri, time) values (241, 229, 160, 263, 247, '9 AM'); insert into tbl_heatmap (mon, tue, wed, thu, fri, time) values (284, 349, 302, 170, 433, '10 AM'); insert into tbl_heatmap (mon, tue, wed, thu, fri, time) values (308, 354, 260, 346, 332, '11 AM'); insert into tbl_heatmap (mon, tue, wed, thu, fri, time) values (150, 144, 49, 132, 400, '4 PM'); CREATE TABLE `tbl_heatmap` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start` int(225) DEFAULT 0, `end` int(255) DEFAULT 0, `status` varchar(225) DEFAULT NULL, `datetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-07 03:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-07 04:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-07 05:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-07 06:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-07 18:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-08 07:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-08 08:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-08 09:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-08 10:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-09 11:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-09 12:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-09 13:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-09 14:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-06 07:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-06 08:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-06 09:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-06 10:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-05 07:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-05 08:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-05 09:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-05 10:42:41'); update tbl_heatmap set datetime = '2024-05-10 07:42:41' where id = 18; update tbl_heatmap set datetime = '2024-05-10 08:42:41' where id = 19; update tbl_heatmap set datetime = '2024-05-10 09:42:41' where id = 20; update tbl_heatmap set datetime = '2024-05-10 10:42:41' where id = 21; SELECT COUNT(*) AS ThursdayCount, DATE(datetime) AS Date FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 5 GROUP BY DATE(datetime) ORDER BY DATE(datetime); SELECT DATE(datetime) AS Date, DAYNAME(datetime) AS Day, COUNT(*) AS ThursdayCount FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 5 GROUP BY DATE(datetime) ORDER BY DATE(datetime); update tbl_heatmap set datetime='2024-05-07 11:42:41' where id=13; SELECT COUNT(*), DAYNAME(datetime),GROUP_CONCAT(HOUR(datetime)) FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2; SELECT *, DAYNAME(datetime),HOUR(datetime) FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2; SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2; insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-06 07:42:41'); SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 4 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 5 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 6; SELECT *, DAYNAME(datetime) AS day_name, HOUR(datetime) AS hour FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, HOUR(datetime) AS hour FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, HOUR(datetime) AS hour FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 4 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, HOUR(datetime) AS hour FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 5 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, HOUR(datetime) AS hour FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 6; SELECT GROUP_CONCAT(id),status,datetime,day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm; SELECT id, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12,'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12,'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 4 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 5 UNION ALL SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12,'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 6 ) AS subquery GROUP BY hour_am_pm; SELECT GROUP_CONCAT(id), status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm UNION SELECT GROUP_CONCAT(id), status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM ( SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY hour_am_pm; SELECT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm UNION ALL SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY hour_am_pm UNION ALL SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 4 ) AS subquery GROUP BY hour_am_pm UNION ALL SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 5 ) AS subquery GROUP BY hour_am_pm UNION ALL SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 6 ) AS subquery GROUP BY hour_am_pm ) AS combined_result; SELECT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) AS combined_result; SELECT *,hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2) AS subquery GROUP BY hour_am_pm; SELECT WEEK(datetime) AS week_count, COUNT(*) AS week_total_count FROM tbl_heatmap GROUP BY week_count ORDER BY week_count; SELECT CONCAT(YEARWEEK(datetime), ':count') AS week_name, COUNT(*) AS count FROM tbl_heatmap WHERE datetime >= DATE_SUB(CURDATE(), INTERVAL 5 WEEK) GROUP BY YEARWEEK(datetime) ORDER BY YEARWEEK(datetime) DESC; select * from tbl_heatmap where DAYOFWEEK(datetime) = 2; select * from tbl_heatmap where DAYOFWEEK(datetime) = 3; SELECT * FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 UNION SELECT * FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3; SELECT * FROM ( SELECT * FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS MondayData LEFT JOIN ( SELECT * FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3) AS TuesdayData ON MondayData and TuesdayData; select * from tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 and DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 LEFT JOIN SELECT DISTINCT lu.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 UNION SELECT DISTINCT lu.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT ku.*, lu.* FROM (SELECT DISTINCT id FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS ku_id JOIN ( SELECT DISTINCT id FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 ) AS lu_id ON ku_id.id = lu_id.id JOIN tbl_heatmap ku ON ku.id = ku_id.id JOIN tbl_heatmap lu ON lu.id = lu_id.id; SELECT DISTINCT ku.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 LEFT JOIN ( SELECT DISTINCT lu.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3) AS lu_result ON ku.id = lu_result.id; SELECT DISTINCT ku.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT lu.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 UNION ALL SELECT DISTINCT lu.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.*,DISTINCT lu.* FROM tbl_heatmap ku RIGHT JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.*, lu.* FROM tbl_heatmap ku RIGHT JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.*, lu.* FROM tbl_heatmap ku RIGHT JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL; SELECT ku.*, lu.* FROM tbl_heatmap ku RIGHT JOIN ( SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap ) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL; SELECT DISTINCT ku.*, lu.* FROM ( SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap ) ku RIGHT JOIN ( SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap ) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL; SELECT DISTINCT ku.id,ku.status,ku.datetime, lu.id,lu.status,lu.datetime FROM ( SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap ) ku RIGHT JOIN ( SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap ) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL; SELECT DISTINCT ku.id, ku.status, ku.datetime, lu.id, lu.status, lu.datetime FROM (SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap) ku RIGHT JOIN (SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL AND ku.id <> lu.id; SELECT DISTINCT ku.id, ku.status, ku.datetime, lu.id, lu.status, lu.datetime FROM (SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap) ku RIGHT JOIN (SELECT DISTINCT id, start, end, status, datetime FROM tbl_heatmap) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL AND ku.id <> lu.id AND lu.datetime <> lu.datetime; SELECT DISTINCT ku.*, lu.* FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT ku.id, ku.start, ku.end, ku.status, ku.datetime, lu.id AS lu_id, lu.start AS lu_start, lu.end AS lu_end, lu.status AS lu_status, lu.datetime AS lu_datetime FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 SELECT DISTINCT ku.*, lu.* FROM (SELECT DISTINCT * FROM tbl_heatmap) ku JOIN (SELECT DISTINCT * FROM tbl_heatmap) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; select DISTINCT lu.* from (SELECT DISTINCT * FROM tbl_heatmap) ku JOIN (SELECT DISTINCT * FROM tbl_heatmap) lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT DISTINCT * FROM tbl_heatmap SELECT DISTINCT * FROM tbl_heatmap ku RIGHT JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL; SELECT DISTINCT ku.id, ku.start, ku.end, ku.status, ku.datetime, lu.id, lu.start, lu.end, lu.status, lu.datetime FROM tbl_heatmap ku RIGHT JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE ku.id IS NOT NULL; SELECT * FROM tbl_heatmap WHERE DATEPART(WEEK, datetime) = DATEPART(WEEK, GETDATE()) AND DATEPART(YEAR, datetime) = DATEPART(YEAR, GETDATE()) AND DATEPART(WEEKDAY, datetime) = 2; SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2; SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE() + INTERVAL 7 DAY) AND DAYOFWEEK(datetime) = 2; insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-13 10:42:41'); SELECT *,DAYNAME(datetime) FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2; SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3; SELECT * FROM tbl_heatmap LEFT JOIN tbl_heatmap ON table1.datetime = table2.datetime; SELECT *,DAYNAME(datetime) FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 UNION ALL SELECT *,DAYNAME(datetime) FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3; SELECT tbl_heatmap.*, DAYNAME(tbl_heatmap.datetime) FROM (SELECT 2 AS target_day UNION ALL SELECT 3 AS target_day) AS all_days LEFT JOIN tbl_heatmap ON WEEK(tbl_heatmap.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(tbl_heatmap.datetime) = all_days.target_day; SELECT COALESCE(h1.id, h2.id) AS id, COALESCE(h1.start, h2.start) AS start, COALESCE(h1.end, h2.end) AS end, COALESCE(h1.status, h2.status) AS status, COALESCE(h1.datetime, h2.datetime) AS datetime FROM (SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2) AS h1 RIGHT JOIN (SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3) AS h2 ON h1.id = h2.id; SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2; select * from tbl_heatmap ku JOIN tbl_heatmap gu ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 AND WEEK(gu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(gu.datetime) = 3 SELECT * FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2; SELECT * FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)),' ',IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm, COUNT(*) AS row_count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2) AS combined_result; COUNT(*) AS row_count SELECT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) AS combined_result; SELECT DISTINCT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) lu RIGHT JOIN (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY hour_am_pm) ku; SELECT DISTINCT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 6 ) AS subquery GROUP BY hour_am_pm) lu; SELECT hour_am_pm, GROUP_CONCAT(id) AS id_list, status, datetime, day_name, COUNT(*) AS row_count FROM ( SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm, day_name; // --------------------------------- SELECT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT DISTINCT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) lu; SELECT DISTINCT ku.*, lu.* FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) lu JOIN (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY hour_am_pm) ku; SELECT DISTINCT ku.*, FROM tbl_heatmap ku RIGHT JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 WHERE WEEK(ku.datetime) = WEEK(CURDATE()) ku.id IS NOT NULL; SELECT *,DISTINCT ku.* FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT DISTINCT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) lu JOIN (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT DISTINCT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY hour_am_pm) ku; SELECT DISTINCT ku.id, lu.id FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3; SELECT ku.*, lu.* FROM ( SELECT * FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 2 ) AS ku JOIN ( SELECT * FROM tbl_heatmap WHERE DAYOFWEEK(datetime) = 3 ) AS lu; SELECT DISTINCT ku.id, lu.id FROM tbl_heatmap ku JOIN tbl_heatmap lu ON DAYOFWEEK(ku.datetime) = 2 AND DAYOFWEEK(lu.datetime) = 3 GROUP BY lu.id; SELECT ku.*, lu.* FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY hour_am_pm) lu JOIN (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY hour_am_pm) ku GROUP BY ku.id_list, lu.id_list; SELECT ku.*, lu.* FROM ( SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM ( SELECT DISTINCT id, status, datetime, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 ) AS subquery GROUP BY id ) lu JOIN ( SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM ( SELECT DISTINCT id, status, datetime, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 ) AS subquery GROUP BY id ) ku GROUP BY ku.id_list; SELECT * FROM (SELECT GROUP_CONCAT(id) AS id_list, status, datetime, day_name, hour_am_pm, COUNT(*) AS row_count FROM (SELECT DISTINCT *, DAYNAME(datetime) AS day_name, CONCAT(IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM')) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 and status = 'sent') AS subquery GROUP BY hour_am_pm) lu; CREATE TABLE `tbl_heathours` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mon` int(225) DEFAULT 0, `tue` int(255) DEFAULT 0, `wed` int(255) DEFAULT 0, `thu` int(255) DEFAULT 0, `fri` int(255) DEFAULT 0, `time` varchar(255) NOT NULL, `status` varchar(225) DEFAULT NULL, `datetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci INSERT INTO tbl_heathours(time) VALUES ('1 AM'),('2 AM'),('3 AM'),('4 AM'),('5 AM'),('6 AM'),('7 AM'),('8 AM'),('9 AM'),('10 AM'),('11 AM'),('12 AM'); SELECT CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS hour_am_pm FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 2 select CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS hour_am_pm from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 select CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS hour_am_pm from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3 select CONCAT( IF(HOUR(ku.datetime) > 12, HOUR(ku.datetime) - 12, HOUR(ku.datetime)), ' ', IF(HOUR(ku.datetime) >= 12, 'PM', 'AM') ) AS monday, CONCAT( IF(HOUR(lu.datetime) > 12, HOUR(lu.datetime) - 12, HOUR(lu.datetime)), ' ', IF(HOUR(lu.datetime) >= 12, 'PM', 'AM') ) AS Tuesday from tbl_heatmap ku JOIN tbl_heatmap lu ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 3; insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-13 10:42:41'); select CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS Tuesday from tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND DAYOFWEEK(datetime) = 3; select COALESCE(CONCAT( IF(HOUR(ku.datetime) > 12, HOUR(ku.datetime) - 12, HOUR(ku.datetime)), ' ', IF(HOUR(ku.datetime) >= 12, 'PM', 'AM') )),'0' AS monday, COALESCE(CONCAT( IF(HOUR(lu.datetime) > 12, HOUR(lu.datetime) - 12, HOUR(lu.datetime)), ' ', IF(HOUR(lu.datetime) >= 12, 'PM', 'AM') ), '0') AS Tuesday from tbl_heatmap ku JOIN tbl_heatmap lu ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 3; select DISTINCT CONCAT( IF(HOUR(ku.datetime) > 12, HOUR(ku.datetime) - 12, HOUR(ku.datetime)), ' ', IF(HOUR(ku.datetime) >= 12, 'PM', 'AM') ) AS monday, CONCAT( IF(HOUR(lu.datetime) > 12, HOUR(lu.datetime) - 12, HOUR(lu.datetime)), ' ', IF(HOUR(lu.datetime) >= 12, 'PM', 'AM') ) AS Tuesday from tbl_heatmap ku JOIN tbl_heatmap lu ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 3; select DISTINCT CONCAT( IF(HOUR(ku.datetime) > 12, HOUR(ku.datetime) - 12, HOUR(ku.datetime)), ' ', IF(HOUR(ku.datetime) >= 12, 'PM', 'AM') ) AS monday, CONCAT( IF(HOUR(lu.datetime) > 12, HOUR(lu.datetime) - 12, HOUR(lu.datetime)), ' ', IF(HOUR(lu.datetime) >= 12, 'PM', 'AM') ) AS Tuesday from tbl_heatmap ku JOIN tbl_heatmap lu ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 3; Select CONCAT( IF(HOUR(ku.datetime) > 12, HOUR(ku.datetime) - 12, HOUR(ku.datetime)), ' ', IF(HOUR(ku.datetime) >= 12, 'PM', 'AM') ) AS monday,CONCAT( IF(HOUR(lu.datetime) > 12, HOUR(lu.datetime) - 12, HOUR(lu.datetime)), ' ', IF(HOUR(lu.datetime) >= 12, 'PM', 'AM') ) AS Tuesday,CONCAT( IF(HOUR(gu.datetime) > 12, HOUR(gu.datetime) - 12, HOUR(gu.datetime)), ' ', IF(HOUR(gu.datetime) >= 12, 'PM', 'AM') ) AS Wednesday,CONCAT( IF(HOUR(fu.datetime) > 12, HOUR(fu.datetime) - 12, HOUR(fu.datetime)), ' ', IF(HOUR(fu.datetime) >= 12, 'PM', 'AM') ) AS Thursday,CONCAT( IF(HOUR(su.datetime) > 12, HOUR(su.datetime) - 12, HOUR(su.datetime)), ' ', IF(HOUR(su.datetime) >= 12, 'PM', 'AM') ) AS Friday from tbl_heatmap ku JOIN tbl_heatmap lu JOIN tbl_heatmap gu JOIN tbl_heatmap fu JOIN tbl_heatmap su ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 3 and WEEK(gu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(gu.datetime) = 4 and WEEK(fu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 5 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 6; insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-15 10:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-16 10:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-17 10:42:41'); select count(ku.monday), CONCAT( IF(HOUR(ku.datetime) > 12, HOUR(ku.datetime) - 12, HOUR(ku.datetime)), ' ', IF(HOUR(ku.datetime) >= 12, 'PM', 'AM') ) AS monday, CONCAT( IF(HOUR(lu.datetime) > 12, HOUR(lu.datetime) - 12, HOUR(lu.datetime)), ' ', IF(HOUR(lu.datetime) >= 12, 'PM', 'AM') ) AS Tuesday, CONCAT( IF(HOUR(gu.datetime) > 12, HOUR(gu.datetime) - 12, HOUR(gu.datetime)), ' ', IF(HOUR(gu.datetime) >= 12, 'PM', 'AM') ) AS Wednesday, CONCAT( IF(HOUR(fu.datetime) > 12, HOUR(fu.datetime) - 12, HOUR(fu.datetime)), ' ', IF(HOUR(fu.datetime) >= 12, 'PM', 'AM') ) AS Thursday, CONCAT( IF(HOUR(su.datetime) > 12, HOUR(su.datetime) - 12, HOUR(su.datetime)), ' ', IF(HOUR(su.datetime) >= 12, 'PM', 'AM') ) AS Friday from tbl_heatmap ku JOIN tbl_heatmap lu JOIN tbl_heatmap gu JOIN tbl_heatmap fu JOIN tbl_heatmap su ON WEEK(ku.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(ku.datetime) = 2 and WEEK(lu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(lu.datetime) = 3 and WEEK(gu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(gu.datetime) = 4 and WEEK(fu.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(fu.datetime) = 5 and WEEK(su.datetime) = WEEK(CURDATE()) AND DAYOFWEEK(su.datetime) = 6; select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()); select * from (select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS time_count from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE())) AS DATAAA; SELECT CONCAT('Week ', WEEK(datetime)) AS week_name, DATE_FORMAT(datetime, '%l %p') AS hour_am_pm, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) GROUP BY CONCAT('Week ', WEEK(datetime)), DATE_FORMAT(datetime, '%l %p') ORDER BY datetime; SELECT * FROM (SELECT id, status, datetime, day_name, times, COUNT(*) AS row_count FROM (select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE())) AS subquery GROUP BY times) lu; select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times,CASE WHEN RAND() < 0.5 THEN '1' ELSE '1' END AS count from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()); select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times,CASE WHEN RAND() < 0.5 THEN '1' ELSE '1' END AS count from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()) - 1; INSERT INTO tbl_heathours ('time') VALUES ('1 PM'),('2 PM'),('3 PM'),('4 PM'),('5 PM'),('6 PM'),('7 PM'),('8 PM'),('9 PM'),('10 PM'),('11 PM'),('12 PM')); update tbl_heathours set mon=0,tue=0,wed=0,thu=0,fri=0; select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()); SELECT DAYNAME(datetime) AS day_name, DATEPART(dw, datetime) AS week_day, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()); SELECT DATEPART(HOUR, datetime) AS hour_of_day, COUNT(*) AS row_count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) GROUP BY DATEPART(HOUR, datetime); SELECT EXTRACT(HOUR FROM datetime) AS hour_of_day, COUNT(*) AS row_count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) GROUP BY EXTRACT(HOUR FROM datetime); select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS row_count from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()) GROUP BY day_name, times; select *,DAYNAME(datetime) AS day_name,CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS row_count from tbl_heatmap where WEEK(datetime) = WEEK(CURDATE()) - 1 GROUP BY day_name, times; SELECT GROUP_CONCAT(id) as id, GROUP_CONCAT(status) as status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) - 1 GROUP BY day_name, times; SELECT id, status, datetime FROM ( SELECT id, status, datetime, day_name, times, count, ROW_NUMBER() OVER (PARTITION BY day_name, times ORDER BY datetime DESC) AS rn FROM tbl_heatmap ) t WHERE rn = 1 ORDER BY day_name, times; SELECT GROUP_CONCAT(id) as id, SUM(CASE WHEN status = 'received' THEN 1 ELSE 0 END) as received_count, SUM(CASE WHEN status = 'sent' THEN 1 ELSE 0 END) as sent_count, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS total_count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) - 1 GROUP BY day_name, times; SELECT GROUP_CONCAT(id) AS id, GROUP_CONCAT(status) AS status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) - 1 AND status = 'sent' GROUP BY day_name, times; SELECT GROUP_CONCAT(id) AS id, GROUP_CONCAT(status) AS status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) AND status = 'sent' GROUP BY day_name, times, status,datetime; SELECT GROUP_CONCAT(id) AS id, GROUP_CONCAT(status) AS status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) - 1 AND status = 'sent' GROUP BY day_name, times, status, datetime; SELECT GROUP_CONCAT(id) as id, GROUP_CONCAT(status) as status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) - 1 GROUP BY day_name, times, status, datetime; SELECT GROUP_CONCAT(id) as id, GROUP_CONCAT(status) as status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE WEEK(datetime) = WEEK(CURDATE()) - 1 GROUP BY day_name, times; SELECT id, start, end, status, datetime FROM tbl_heatmap WHERE YEAR(datetime) = 2024 AND WEEK(datetime) = 19; SELECT GROUP_CONCAT(id) as id, status, datetime, DAYNAME(datetime) AS day_name, CONCAT( IF(HOUR(datetime) > 12, HOUR(datetime) - 12, HOUR(datetime)), ' ', IF(HOUR(datetime) >= 12, 'PM', 'AM') ) AS times, COUNT(*) AS count FROM tbl_heatmap WHERE YEAR(datetime) = 2024 AND WEEK(datetime) = 19 GROUP BY day_name, times, status, datetime; -- Table structure for table `comm_status` -- CREATE TABLE `tbl_status` ( `id` int(11) NOT NULL, `userid` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 0, `out_offices` int(11) DEFAULT 0, `do_disturb` int(11) DEFAULT 0, `schedule_act` int(11) NOT NULL DEFAULT 0, `schedule` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `comm_status` -- INSERT INTO `tbl_status` (`id`, `userid`, `status`, `out_offices`, `do_disturb`, `schedule_act`, `schedule`) VALUES (1, '8f2ede6f-5041-11ed-b46f-42010a800004', 1, 0, 0, 1, '14:19,14:22'), (7, '14bb43fd-4e3a-11ed-b46f-42010a800004', 1, 0, 0, 1, '10:40,12:40'), (10, '517a348e-5041-11ed-b46f-42010a800004', 0, 0, 0, 1, '10:45,12:45'); ALTER TABLE `tbl_status` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `userid_2` (`userid`), ADD KEY `userid` (`userid`); ALTER TABLE `tbl_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=527; insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-14 12:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-14 12:42:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-14 12:42:41'); [ { "id": 51, "mon": 0, "tue": 0, "wed": 0, "thu": 0, "fri": 0, "time": "8 AM", "status": "received", "datetime": "2024-05-17 17:25:28" }, { "id": 52, "mon": 1, "tue": 1, "wed": 1, "thu": 1, "fri": 1, "time": "9 AM", "status": "received", "datetime": "2024-05-17 17:25:28" }, { "id": 53, "mon": 2, "tue": 2, "wed": 2, "thu": 2, "fri": 2, "time": "10 AM", "status": "received", "datetime": "2024-05-17 17:25:28" }, { "id": 54, "mon": 3, "tue": 3, "wed": 3, "thu": 3, "fri": 3, "time": "11 AM", "status": "received", "datetime": "2024-05-17 17:25:28" }, { "id": 55, "mon": 4, "tue": 4, "wed": 4, "thu": 4, "fri": 4, "time": "12 AM", "status": null, "datetime": "2024-05-14 10:10:49" }, { "id": 56, "mon": 5, "tue": 5, "wed": 5, "thu": 5, "fri": 5, "time": "1 PM", "status": "received", "datetime": "2024-05-17 17:25:28" }, { "id": 57, "mon": 6, "tue": 6, "wed": 6, "thu": 6, "fri": 6, "time": "2 PM", "status": "received", "datetime": "2024-05-17 17:25:28" }, { "id": 58, "mon": 7, "tue": 7, "wed": 7, "thu": 7, "fri": 7, "time": "3 PM", "status": null, "datetime": "2024-05-14 15:10:58" }, { "id": 59, "mon": 8, "tue": 8, "wed": 8, "thu": 8, "fri": 8, "time": "4 PM", "status": null, "datetime": "2024-05-14 15:10:58" }, { "id": 60, "mon": 9, "tue": 9, "wed": 9, "thu": 9, "fri": 9, "time": "5 PM", "status": null, "datetime": "2024-05-14 15:10:58" }, { "id": 61, "mon": 10, "tue": 10, "wed": 10, "thu": 10, "fri": 10, "time": "6 PM", "status": null, "datetime": "2024-05-14 15:10:58" } ] insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 18:00:41'); SELECT * FROM tbl_heathours WHERE TIME_FORMAT(STR_TO_DATE(time, '%l %p'), '%H:%i') BETWEEN '08:00' AND '18:00'; SELECT * FROM tbl_heathours WHERE time BETWEEN '8:00 AM' AND '6:00 PM'; insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 08:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 09:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 10:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 11:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 12:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 13:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 14:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 15:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 16:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 17:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'received', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-20 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-21 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-22 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-23 18:00:41'); insert into tbl_heatmap (start, end, status, datetime) values (1, 1, 'sent', '2024-05-24 18:00:41'); | Disapprove all pending releases | | Delete all unfinished releases | | Adds a note to all RFS releases | | Adds a flag to the account | | RFS all active releases | | Takedown for all stores | | Unlinks all YT channels | | Manual Account Activation | SELECT id, uid, uname, upc_id, subject, from_name, from_addr, to_name, to_addr, action, initiated_by, is_semiauto, req_conformation, req_con_valid, tickets_received, assigned_to, priority, status, ce_status, schedule, tag_id, asana_ticketid, asana_status, completed_at, category FROM tbl_smthub_ticket; select count(*) as Disapprove from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '1'; select count(*) as Delete_ from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '2'; select count(*) as Adds_a_note from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '3'; select count(*) as Adds_a_flag from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '4'; select count(*) as RFS from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '5'; select count(*) as Takedown from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '6'; select count(*) as Unlinks from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '7'; select count(*) as Manual from tbl_smthub_ticket where category = 0 and ce_status != 1 and status = 'Received' and action = '8'; SELECT SUM(CASE WHEN action = '1' THEN 1 ELSE 0 END) AS Disapprove, SUM(CASE WHEN action = '2' THEN 1 ELSE 0 END) AS Delete_, SUM(CASE WHEN action = '3' THEN 1 ELSE 0 END) AS Adds_a_note, SUM(CASE WHEN action = '4' THEN 1 ELSE 0 END) AS Adds_a_flag, SUM(CASE WHEN action = '5' THEN 1 ELSE 0 END) AS RFS, SUM(CASE WHEN action = '6' THEN 1 ELSE 0 END) AS Takedown, SUM(CASE WHEN action = '7' THEN 1 ELSE 0 END) AS Unlinks, SUM(CASE WHEN action = '8' THEN 1 ELSE 0 END) AS Manual FROM tbl_smthub_ticket WHERE category = 0 AND ce_status != 1 AND status = 'Received'; $result = DB::table('tbl_smthub_ticket')->select(DB::raw('SUM(CASE WHEN action = "1" THEN 1 ELSE 0 END) AS Disapprove'),DB::raw('SUM(CASE WHEN action = "2" THEN 1 ELSE 0 END) AS Delete_'),DB::raw('SUM(CASE WHEN action = "3" THEN 1 ELSE 0 END) AS Adds_a_note'),DB::raw('SUM(CASE WHEN action = "4" THEN 1 ELSE 0 END) AS Adds_a_flag'),DB::raw('SUM(CASE WHEN action = "5" THEN 1 ELSE 0 END) AS RFS'),DB::raw('SUM(CASE WHEN action = "6" THEN 1 ELSE 0 END) AS Takedown'),DB::raw('SUM(CASE WHEN action = "7" THEN 1 ELSE 0 END) AS Unlinks'),DB::raw('SUM(CASE WHEN action = "8" THEN 1 ELSE 0 END) AS Manual'))->where('category', 0)->where('ce_status', '!=', 1)->where('status', 'Received')->first(); select count(*) as Disapprove from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '1'; select count(*) as Delete_ from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '2'; select count(*) as Adds_a_note from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '3'; select count(*) as Adds_a_flag from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '4'; select count(*) as RFS from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '5'; select count(*) as Takedown from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '6'; select count(*) as Unlinks from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '7'; select count(*) as Manual from tbl_smthub_ticket where category = 0 AND ce_status = 2 AND status = 'Received' and action = '8'; SELECT SUM(CASE WHEN action = '1' THEN 1 ELSE 0 END) AS Disapprove_1, SUM(CASE WHEN action = '2' THEN 1 ELSE 0 END) AS Disapprove_2, SUM(CASE WHEN action = '3' THEN 1 ELSE 0 END) AS Disapprove_3, SUM(CASE WHEN action = '4' THEN 1 ELSE 0 END) AS Disapprove_4, SUM(CASE WHEN action = '5' THEN 1 ELSE 0 END) AS Disapprove_5, SUM(CASE WHEN action = '6' THEN 1 ELSE 0 END) AS Disapprove_6, SUM(CASE WHEN action = '7' THEN 1 ELSE 0 END) AS Disapprove_7, SUM(CASE WHEN action = '8' THEN 1 ELSE 0 END) AS Disapprove_8 FROM tbl_smthub_ticket WHERE category = 0 AND ce_status = 2 AND status = 'Received'; SELECT SUM(CASE WHEN action = '1' THEN 1 ELSE 0 END) AS Disapprove, SUM(CASE WHEN action = '2' THEN 1 ELSE 0 END) AS Delete_, SUM(CASE WHEN action = '3' THEN 1 ELSE 0 END) AS Adds_a_note, SUM(CASE WHEN action = '4' THEN 1 ELSE 0 END) AS Adds_a_flag, SUM(CASE WHEN action = '5' THEN 1 ELSE 0 END) AS RFS, SUM(CASE WHEN action = '6' THEN 1 ELSE 0 END) AS Takedown, SUM(CASE WHEN action = '7' THEN 1 ELSE 0 END) AS Unlinks, SUM(CASE WHEN action = '8' THEN 1 ELSE 0 END) AS Manual FROM tbl_smthub_ticket WHERE category = 0 AND ce_status = 2 AND status = 'Received'; SELECT SUM(CASE WHEN action = '1' THEN 1 ELSE 0 END) AS Disapprove, SUM(CASE WHEN action = '2' THEN 1 ELSE 0 END) AS Delete_, SUM(CASE WHEN action = '3' THEN 1 ELSE 0 END) AS Adds_a_note, SUM(CASE WHEN action = '4' THEN 1 ELSE 0 END) AS Adds_a_flag, SUM(CASE WHEN action = '5' THEN 1 ELSE 0 END) AS RFS, SUM(CASE WHEN action = '6' THEN 1 ELSE 0 END) AS Takedown, SUM(CASE WHEN action = '7' THEN 1 ELSE 0 END) AS Unlinks, SUM(CASE WHEN action = '8' THEN 1 ELSE 0 END) AS Manual FROM tbl_smthub_ticket WHERE category = 0 AND ce_status = 2 AND status = 'Received'; SELECT IFNULL(SUM(CASE WHEN action = '1' THEN 1 ELSE 0 END), 0) AS Disapprove, IFNULL(SUM(CASE WHEN action = '2' THEN 1 ELSE 0 END), 0) AS Delete_, IFNULL(SUM(CASE WHEN action = '3' THEN 1 ELSE 0 END), 0) AS Adds_a_note, IFNULL(SUM(CASE WHEN action = '4' THEN 1 ELSE 0 END), 0) AS Adds_a_flag, IFNULL(SUM(CASE WHEN action = '5' THEN 1 ELSE 0 END), 0) AS RFS, IFNULL(SUM(CASE WHEN action = '6' THEN 1 ELSE 0 END), 0) AS Takedown, IFNULL(SUM(CASE WHEN action = '7' THEN 1 ELSE 0 END), 0) AS Unlinks, IFNULL(SUM(CASE WHEN action = '8' THEN 1 ELSE 0 END), 0) AS Manual FROM tbl_smthub_ticket WHERE category = 0 AND ce_status = 2 AND status = 'Received'; $result = DB::table('tbl_smthub_ticket')->select(DB::raw('IFNULL(SUM(CASE WHEN action = "1" THEN 1 ELSE 0 END), 0) AS Disapprove'),DB::raw('IFNULL(SUM(CASE WHEN action = "2" THEN 1 ELSE 0 END), 0) AS Delete_'),DB::raw('IFNULL(SUM(CASE WHEN action = "3" THEN 1 ELSE 0 END), 0) AS Adds_a_note'),DB::raw('IFNULL(SUM(CASE WHEN action = "4" THEN 1 ELSE 0 END), 0) AS Adds_a_flag'),DB::raw('IFNULL(SUM(CASE WHEN action = "5" THEN 1 ELSE 0 END), 0) AS RFS'),DB::raw('IFNULL(SUM(CASE WHEN action = "6" THEN 1 ELSE 0 END), 0) AS Takedown'),DB::raw('IFNULL(SUM(CASE WHEN action = "7" THEN 1 ELSE 0 END), 0) AS Unlinks'),DB::raw('IFNULL(SUM(CASE WHEN action = "8" THEN 1 ELSE 0 END), 0) AS Manual'))->where('category', 0)->where('ce_status', 2)->where('status', 'Received')->first(); select assigned_to,ce_status,status,tickets_received from tbl_smthub_ticket where category = 0 AND assigned_to="72567" AND ce_status != 1 AND status = 'Received'; SELECT YEAR(tickets_received) AS year, MONTH(tickets_received) AS month, COUNT(*) AS ticket_count FROM tbl_smthub_ticket WHERE category = 0 AND assigned_to = "72567" AND ce_status != 1 AND status = 'Received' GROUP BY YEAR(tickets_received), MONTH(tickets_received); select assigned_to,ce_status,status,tickets_received,MONTHNAME(tickets_received) AS month from tbl_smthub_ticket where category = 0 AND assigned_to="72567" AND ce_status != 1 AND status = 'Received';