🔧 System Utility

[16:35:41] Action: book_tests [16:35:41] bookTests input: {"prescription_id":"1","tests":["MP","Dengue NS1"],"date":"2026-01-09","time":"11:30","phone":"919831101730"} [16:35:41] bookTests - ID: 1, Tests: ["MP","Dengue NS1"], Date: 2026-01-09, Time: 11:30, Phone: 919831101730 [16:35:41] bookTests - DB Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'booking_id' in 'INSERT INTO' [16:35:52] Action: send_completion [16:35:52] sendCompletion input: {"phone":"919831101730","prescription_id":"1"} [16:35:52] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919831101730 [16:35:53] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"68a190020a5c45e6b733e5272e0f6293","message":"Your request is in process, please check delivery report for status"},"errors":null}} [16:44:25] Action: get_stats [16:44:25] Action: get_prescriptions [16:44:31] Action: get_prescriptions [16:44:34] Action: get_bookings [16:44:37] Action: get_prescriptions [16:44:43] Action: get_prescriptions [16:44:55] Action: get_prescriptions [16:44:56] Action: get_bookings [16:44:59] Action: get_prescriptions [16:44:59] Action: get_stats [16:48:38] Action: get_stats [16:48:38] Action: get_prescriptions [16:54:09] Action: get_stats [16:54:09] Action: get_prescriptions [16:54:11] Action: get_prescriptions [16:54:31] Action: get_prescriptions [16:54:31] Action: get_stats [16:54:32] Action: get_prescriptions [17:01:32] Action: get_prescriptions [17:01:33] Action: get_bookings [17:01:39] Action: get_stats [17:01:39] Action: get_prescriptions [17:01:41] Action: get_prescriptions [17:01:43] Action: get_bookings [17:04:12] Action: get_stats [17:04:12] Action: get_prescriptions [17:04:13] Action: get_prescriptions [17:04:15] Action: get_bookings [17:13:20] Action: get_stats [17:13:20] Action: get_prescriptions [17:13:23] Action: get_stats [17:13:23] Action: get_prescriptions [17:13:24] Action: get_prescriptions [17:13:28] Action: get_prescriptions [17:13:28] Action: get_stats [17:17:17] Action: get_prescriptions [17:17:17] Action: get_stats [17:17:21] Action: get_prescriptions [17:17:21] Action: get_stats [17:18:18] Action: get_stats [17:18:18] Action: get_prescriptions [17:18:19] Action: get_prescriptions [17:18:26] Action: get_prescriptions [17:18:26] Action: get_stats [17:18:27] Action: get_prescriptions [17:18:28] Action: get_prescriptions [17:18:28] Action: get_bookings [17:22:11] Action: get_prescriptions [17:22:11] Action: get_stats [19:14:26] Action: book_tests [19:14:26] bookTests input: {"prescription_id":"2","tests":["MP","Widal Test"],"date":"2026-01-09","time":"11:30","phone":"919831101730"} [19:14:26] bookTests - ID: 2, Tests: ["MP","Widal Test"], Date: 2026-01-09, Time: 11:30, Phone: 919831101730 [19:14:26] bookTests - Inserted booking: BK260107008 [19:14:26] bookTests - WhatsApp sent to 919831101730 [19:15:41] Action: get_prescriptions [19:15:41] Action: get_stats [19:15:48] Action: get_prescription [19:15:53] Action: get_files [19:15:56] Action: get_prescriptions [19:15:58] Action: get_bookings [19:18:37] Action: get_prescriptions [19:19:18] Action: get_bookings [19:19:20] Action: get_bookings [19:19:22] Action: get_stats [19:19:22] Action: get_prescriptions [19:19:24] Action: get_bookings [19:19:43] Action: get_prescriptions [19:19:43] Action: get_stats [19:19:44] Action: get_bookings [19:21:13] Action: book_tests [19:21:13] bookTests input: {"prescription_id":"3","tests":["CBC"],"date":"2026-01-12","time":"13:15","phone":"919831101730"} [19:21:13] bookTests - ID: 3, Tests: ["CBC"], Date: 2026-01-12, Time: 13:15, Phone: 919831101730 [19:21:13] bookTests - Inserted booking: BK260107009 [19:21:13] bookTests - WhatsApp sent to 919831101730 [19:21:22] Action: get_bookings [19:21:48] Action: update_booking [19:21:52] Action: update_booking [19:24:43] Action: book_tests [19:24:43] bookTests input: {"prescription_id":"4","tests":["CBC","MP","Widal Test","Dengue NS1"],"date":"2026-01-10","time":"16:30","phone":"919831101730"} [19:24:43] bookTests - ID: 4, Tests: ["CBC","MP","Widal Test","Dengue NS1"], Date: 2026-01-10, Time: 16:30, Phone: 919831101730 [19:24:43] bookTests - Inserted booking: BK260107010 [19:24:44] bookTests - WhatsApp sent to 919831101730 [19:24:50] Action: get_stats [19:24:50] Action: get_prescriptions [19:24:52] Action: get_bookings [19:27:08] Action: send_completion [19:27:08] sendCompletion input: {"phone":"919830946010","prescription_id":"5"} [19:27:08] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919830946010 [19:27:08] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"57b30391567f41fdb2f330407b9329d7","message":"Your request is in process, please check delivery report for status"},"errors":null}} [19:28:13] Action: send_completion [19:28:13] sendCompletion input: {"phone":"919830946010","prescription_id":"6"} [19:28:13] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919830946010 [19:28:14] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"0b5b2c203bed44b98f7ca2bbbb5b1c7d","message":"Your request is in process, please check delivery report for status"},"errors":null}} [19:29:02] Action: send_completion [19:29:02] sendCompletion input: {"phone":"919830946010","prescription_id":"7"} [19:29:02] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919830946010 [19:29:02] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"90dc5df74afd46f5abc0436ae409f038","message":"Your request is in process, please check delivery report for status"},"errors":null}} [19:31:53] Action: book_tests [19:31:53] bookTests input: {"prescription_id":"8","tests":["MP","Widal Test"],"date":"2026-01-10","time":"08:30","phone":"919830946010"} [19:31:53] bookTests - ID: 8, Tests: ["MP","Widal Test"], Date: 2026-01-10, Time: 08:30, Phone: 919830946010 [19:31:53] bookTests - Inserted booking: BK260107011 [19:31:53] bookTests - WhatsApp sent to 919830946010 [19:31:57] Action: send_completion [19:31:57] sendCompletion input: {"phone":"919830946010","prescription_id":"8"} [19:31:57] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919830946010 [19:31:57] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"5b40dcfbebfe42aba6b26d96e312cfc6","message":"Your request is in process, please check delivery report for status"},"errors":null}} [19:32:48] Action: get_bookings [19:32:57] Action: update_booking [19:49:42] Action: get_bookings [19:49:44] Action: get_bookings [19:49:45] Action: get_bookings [19:49:47] Action: get_prescriptions [19:49:49] Action: get_bookings [19:50:10] Action: get_prescriptions [19:50:10] Action: get_stats [19:50:12] Action: get_bookings [19:53:54] Action: get_bookings [19:55:21] Action: book_tests [19:55:21] bookTests input: {"prescription_id":"9","tests":["Dengue NS1"],"date":"2026-01-08","time":"10:00","phone":"919831101730"} [19:55:21] bookTests - ID: 9, Tests: ["Dengue NS1"], Date: 2026-01-08, Time: 10:00, Phone: 919831101730 [19:55:21] bookTests - Inserted booking: BK260107012 [19:55:21] bookTests - WhatsApp sent to 919831101730 [19:55:32] Action: get_bookings [19:56:06] Action: get_bookings [19:56:27] Action: update_booking [19:56:38] Action: get_prescriptions [19:59:22] Action: get_bookings [20:02:39] Action: get_bookings [20:02:46] Action: update_booking [20:02:52] Action: update_booking [20:05:29] Action: update_booking [20:22:48] Action: get_bookings [20:22:59] Action: update_booking [20:23:00] Action: get_bookings [20:24:55] Action: get_stats [20:24:55] Action: get_prescriptions [20:24:59] Action: get_bookings [21:25:33] Action: book_tests [21:25:33] bookTests input: {"prescription_id":"10","tests":["NS1 Antigen Test"],"date":"2026-01-15","time":"15:30","phone":"919831101730"} [21:25:33] bookTests - ID: 10, Tests: ["NS1 Antigen Test"], Date: 2026-01-15, Time: 15:30, Phone: 919831101730 [21:25:33] bookTests - Inserted booking: BK260107013 [21:25:34] bookTests - WhatsApp sent to 919831101730 [21:25:39] Action: send_completion [21:25:39] sendCompletion input: {"phone":"919831101730","prescription_id":"10"} [21:25:39] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919831101730 [21:25:39] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"e6dee5ebe7bc45959803e2511b8b378a","message":"Your request is in process, please check delivery report for status"},"errors":null}} [21:26:00] Action: get_prescriptions [21:26:00] Action: get_stats [21:26:05] Action: get_stats [21:26:05] Action: get_prescriptions [21:26:10] Action: get_bookings [21:26:36] Action: update_booking [21:26:36] Action: get_bookings [21:58:08] Action: book_tests [21:58:08] bookTests input: {"prescription_id":"11","tests":["CBC","MP","Widal Test"],"date":"2026-01-12","time":"09:00","phone":"919830946010"} [21:58:08] bookTests - ID: 11, Tests: ["CBC","MP","Widal Test"], Date: 2026-01-12, Time: 09:00, Phone: 919830946010 [21:58:08] bookTests - Inserted booking: BK260107014 [21:58:08] bookTests - WhatsApp sent to 919830946010 [21:58:16] Action: send_completion [21:58:16] sendCompletion input: {"phone":"919830946010","prescription_id":"11"} [21:58:16] sendCompletion - Dashboard URL: https://wf1.feliz.health/my-prescriptions.php?phone=919830946010 [21:58:16] sendCompletion - Message sent, result: {"success":true,"http_code":200,"response":{"status":"success","hasError":false,"data":{"message_uuid":"9c1bb7a3c6424b5399413e823e1bea1d","message":"Your request is in process, please check delivery report for status"},"errors":null}} [22:16:13] Action: get_prescriptions [22:16:13] Action: get_stats