<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

DEBUG - 2023-10-26 00:03:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 00:03:58 --> No URI present. Default controller set.
DEBUG - 2023-10-26 00:03:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 00:03:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 00:03:58 --> Total execution time: 0.0561
DEBUG - 2023-10-26 01:04:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 01:04:07 --> No URI present. Default controller set.
DEBUG - 2023-10-26 01:04:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 01:04:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 01:04:07 --> Total execution time: 0.0516
DEBUG - 2023-10-26 01:15:03 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 01:15:03 --> No URI present. Default controller set.
DEBUG - 2023-10-26 01:15:03 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 01:15:03 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 01:15:03 --> Total execution time: 0.0485
DEBUG - 2023-10-26 01:15:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 01:15:04 --> No URI present. Default controller set.
DEBUG - 2023-10-26 01:15:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 01:15:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 01:15:04 --> Total execution time: 0.0067
DEBUG - 2023-10-26 02:03:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 02:03:43 --> No URI present. Default controller set.
DEBUG - 2023-10-26 02:03:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 02:03:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 02:03:43 --> Total execution time: 0.0548
DEBUG - 2023-10-26 03:04:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 03:04:47 --> No URI present. Default controller set.
DEBUG - 2023-10-26 03:04:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 03:04:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 03:04:47 --> Total execution time: 0.0437
DEBUG - 2023-10-26 04:03:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:03:57 --> No URI present. Default controller set.
DEBUG - 2023-10-26 04:03:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:03:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:03:57 --> Total execution time: 0.0495
DEBUG - 2023-10-26 04:13:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:13:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:13:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:13:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:13:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:13:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:13:14 --> Total execution time: 0.0061
DEBUG - 2023-10-26 04:13:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:13:14 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 04:13:14 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 04:17:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:17:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:17:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:17:21 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 04:17:21 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 04:17:22 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:17:22 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:17:22 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:17:22 --> start date: none
DEBUG - 2023-10-26 04:17:22 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 04:17:22 --> start date: none
DEBUG - 2023-10-26 04:17:22 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 04:17:22 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 04:17:22 --> Total execution time: 0.3402
DEBUG - 2023-10-26 04:17:25 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:17:25 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:17:25 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:17:25 --> start date: 
DEBUG - 2023-10-26 04:17:25 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND DATE(admission_date) BETWEEN '2023-10-26' AND '2023-10-26'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 04:17:25 --> Total execution time: 0.0124
DEBUG - 2023-10-26 04:17:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:17:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:17:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:17:35 --> start date: 2023-10-24
DEBUG - 2023-10-26 04:17:35 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND DATE(admission_date) BETWEEN '2023-10-24' AND '2023-10-25'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 04:17:35 --> Total execution time: 0.0100
DEBUG - 2023-10-26 04:17:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:17:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:17:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:17:52 --> start date: 
DEBUG - 2023-10-26 04:17:52 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) BETWEEN '2023-10-26' AND '2023-10-26'
DEBUG - 2023-10-26 04:17:52 --> Total execution time: 0.0093
DEBUG - 2023-10-26 04:17:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:17:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:17:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:17:59 --> start date: 2023-10-25
DEBUG - 2023-10-26 04:17:59 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) BETWEEN '2023-10-25' AND '2023-10-25'
DEBUG - 2023-10-26 04:17:59 --> Total execution time: 0.0060
DEBUG - 2023-10-26 04:18:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 04:18:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 04:18:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 04:18:04 --> start date: 2023-10-26
DEBUG - 2023-10-26 04:18:04 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) BETWEEN '2023-10-26' AND '2023-10-26'
GROUP BY `cr`.`form_id`
DEBUG - 2023-10-26 04:18:04 --> Total execution time: 0.0080
DEBUG - 2023-10-26 05:04:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 05:04:53 --> No URI present. Default controller set.
DEBUG - 2023-10-26 05:04:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 05:04:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 05:04:53 --> Total execution time: 0.0787
DEBUG - 2023-10-26 05:43:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 05:43:36 --> No URI present. Default controller set.
DEBUG - 2023-10-26 05:43:36 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 05:43:36 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 05:43:36 --> Total execution time: 0.0658
DEBUG - 2023-10-26 06:05:10 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:05:10 --> No URI present. Default controller set.
DEBUG - 2023-10-26 06:05:10 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 06:05:10 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 06:05:10 --> Total execution time: 0.0766
DEBUG - 2023-10-26 06:45:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:50 --> No URI present. Default controller set.
DEBUG - 2023-10-26 06:45:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 06:45:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 06:45:50 --> Total execution time: 0.0556
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: V2/api-docs
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Api/v3
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: V3/api-docs
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Api-docs/index
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: V1/api-docs
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Api/v1
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Api-docsyaml/index
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swaggerjson/index
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Api/v2
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Openapiyaml/index
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swaggeryaml/index
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swagger-ui/index
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: V1/swagger.json
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swagger/v1
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swagger/api
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swagger/v3
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Docs/swagger.json
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: V2/swagger.json
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Swagger/v2
DEBUG - 2023-10-26 06:45:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 06:45:51 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 06:45:51 --> 404 Page Not Found: Openapijson/index
DEBUG - 2023-10-26 07:06:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:06:11 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:06:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:06:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:06:11 --> Total execution time: 0.0536
DEBUG - 2023-10-26 07:09:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:09:44 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:09:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:09:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:09:44 --> Total execution time: 0.0488
DEBUG - 2023-10-26 07:09:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:09:45 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 07:09:45 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 07:09:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:09:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:09:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:09:47 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 07:09:47 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 07:09:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:09:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:09:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:09:47 --> start date: none
DEBUG - 2023-10-26 07:09:47 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:09:47 --> start date: none
DEBUG - 2023-10-26 07:09:47 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:09:47 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 07:09:47 --> Total execution time: 0.1530
DEBUG - 2023-10-26 07:09:54 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:09:54 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:09:54 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:09:54 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:09:54 --> Total execution time: 0.0202
DEBUG - 2023-10-26 07:10:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:10:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:10:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:10:11 --> check_Mr_Number
DEBUG - 2023-10-26 07:10:11 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '11617879'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:10:11 --> Total execution time: 0.0131
DEBUG - 2023-10-26 07:10:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:10:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:10:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:10:47 --> get_ward_list ::
DEBUG - 2023-10-26 07:10:47 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:10:47 --> Total execution time: 0.0077
DEBUG - 2023-10-26 07:12:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:12:43 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:12:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:12:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:12:44 --> Total execution time: 0.0545
DEBUG - 2023-10-26 07:12:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:12:47 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:12:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:12:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:12:47 --> Total execution time: 0.0079
DEBUG - 2023-10-26 07:12:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:12:47 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 07:12:47 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 07:12:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:12:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:12:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:12:49 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 07:12:49 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 07:12:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:12:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:12:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:12:49 --> start date: none
DEBUG - 2023-10-26 07:12:49 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:12:49 --> start date: none
DEBUG - 2023-10-26 07:12:49 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:12:49 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 07:12:49 --> Total execution time: 0.2527
DEBUG - 2023-10-26 07:12:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:12:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:12:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:12:52 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:12:52 --> Total execution time: 0.3146
DEBUG - 2023-10-26 07:13:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:13:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:13:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:13:04 --> check_Mr_Number
DEBUG - 2023-10-26 07:13:04 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116309000'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:13:04 --> Total execution time: 0.0127
DEBUG - 2023-10-26 07:13:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:13:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:13:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:13:04 --> get_ward_list ::
DEBUG - 2023-10-26 07:13:04 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:13:04 --> Total execution time: 0.0082
DEBUG - 2023-10-26 07:13:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:13:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:13:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:13:08 --> Infection Form ::
DEBUG - 2023-10-26 07:13:08 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('11617879', 'mohd umer', '11', '202', 'copd', 'tuberculosis', '2023-10-25', '', '', '', '98', 'yes', '140', 'no', '99/55', 'no', 'high', '90', '', '6', '2023-10-26', '2023-10-26 07:13:08')
DEBUG - 2023-10-26 07:13:08 --> no
DEBUG - 2023-10-26 07:13:08 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:13:08 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (322, 'Phlebitis', 'yes', '2023-10-26', 'rt arm', '', 'no', '11617879', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:13:08 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:13:08 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (322, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-25', 'No', '11617879', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:13:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:13:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:13:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:13:08 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:13:08 --> Total execution time: 0.0157
DEBUG - 2023-10-26 07:13:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:13:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:13:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:13:21 --> check_Mr_Number
DEBUG - 2023-10-26 07:13:21 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116269128'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:13:21 --> Total execution time: 0.0096
DEBUG - 2023-10-26 07:13:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:13:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:13:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:13:21 --> get_ward_list ::
DEBUG - 2023-10-26 07:13:21 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:13:21 --> Total execution time: 0.0067
DEBUG - 2023-10-26 07:14:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:30 --> Infection Form ::
DEBUG - 2023-10-26 07:14:30 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116309000', 'abdul nabi', '10', '101', 'cap,ards', '0', '2023-10-22', '', '', '', '98', 'no', '68', 'no', '119/72', 'no', 'medium', '81', '', '6', '2023-10-26', '2023-10-26 07:14:30')
DEBUG - 2023-10-26 07:14:30 --> no
DEBUG - 2023-10-26 07:14:30 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:14:30 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (323, 'Phlebitis', 'yes', '2023-10-26', 'left arm', '', 'no', '116309000', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:14:30 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:14:30 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (323, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-23', 'No', '116309000', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:14:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:30 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:14:30 --> Total execution time: 0.0139
DEBUG - 2023-10-26 07:14:41 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:41 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:41 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:41 --> check_Mr_Number
DEBUG - 2023-10-26 07:14:41 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116305202'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:14:41 --> Total execution time: 0.0079
DEBUG - 2023-10-26 07:14:41 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:41 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:41 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:41 --> get_ward_list ::
DEBUG - 2023-10-26 07:14:41 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:14:41 --> Total execution time: 0.0086
DEBUG - 2023-10-26 07:14:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:46 --> Infection Form ::
DEBUG - 2023-10-26 07:14:46 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116269128', 'lakhomal', '11', '203', 'ckd', 'tuberculosis', '1970-01-01', '', '', '', '98', 'yes', '122', 'yes', '88/63', 'no', 'high', '76', '', '6', '2023-10-26', '2023-10-26 07:14:46')
DEBUG - 2023-10-26 07:14:46 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:14:46 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (324, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-19', 'CVP', 'No', '116269128', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:14:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:46 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:14:46 --> Total execution time: 0.0329
DEBUG - 2023-10-26 07:14:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:57 --> check_Mr_Number
DEBUG - 2023-10-26 07:14:57 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116312287'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:14:57 --> Total execution time: 0.0076
DEBUG - 2023-10-26 07:14:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:14:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:14:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:14:57 --> get_ward_list ::
DEBUG - 2023-10-26 07:14:57 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:14:57 --> Total execution time: 0.0083
DEBUG - 2023-10-26 07:15:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:15:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:15:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:15:57 --> Infection Form ::
DEBUG - 2023-10-26 07:15:57 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116305202', 'zeeshan', '10', '102', 'ckd', '0', '2023-10-22', '', '', '', '98', 'no', '96', 'no', '110/72', 'no', 'high', '88', '', '6', '2023-10-26', '2023-10-26 07:15:57')
DEBUG - 2023-10-26 07:15:57 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:15:57 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (325, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-21', 'No', '116305202', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:15:57 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:15:57 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (325, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-24', 'CVP', 'No', '116305202', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:15:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:15:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:15:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:15:57 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:15:57 --> Total execution time: 0.0128
DEBUG - 2023-10-26 07:16:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:08 --> check_Mr_Number
DEBUG - 2023-10-26 07:16:08 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116310820'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:16:08 --> Total execution time: 0.0095
DEBUG - 2023-10-26 07:16:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:09 --> get_ward_list ::
DEBUG - 2023-10-26 07:16:09 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:16:09 --> Total execution time: 0.0075
DEBUG - 2023-10-26 07:16:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:27 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:16:27 --> Total execution time: 0.0116
DEBUG - 2023-10-26 07:16:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:36 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:36 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:36 --> check_Mr_Number
DEBUG - 2023-10-26 07:16:36 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116305202'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:16:36 --> Total execution time: 0.0070
DEBUG - 2023-10-26 07:16:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:36 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:36 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:36 --> get_ward_list ::
DEBUG - 2023-10-26 07:16:36 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:16:36 --> Total execution time: 0.0065
DEBUG - 2023-10-26 07:16:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:40 --> Infection Form ::
DEBUG - 2023-10-26 07:16:40 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116312287', 'akhter al barani', '11', '204', 'suspected tuberclosis', 'tuberculosis', '1970-01-01', '', '', '', '98', 'yes', '102', 'yes', '76/32', 'no', 'high', '93', '', '6', '2023-10-26', '2023-10-26 07:16:40')
DEBUG - 2023-10-26 07:16:40 --> no
DEBUG - 2023-10-26 07:16:40 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:16:40 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (326, 'Phlebitis', 'yes', '2023-10-24', 'rt hand', '', 'no', '116312287', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:16:40 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:16:40 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (326, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-23', 'No', '116312287', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:16:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:40 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:16:40 --> Total execution time: 0.0135
DEBUG - 2023-10-26 07:16:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:53 --> check_Mr_Number
DEBUG - 2023-10-26 07:16:53 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116304981'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:16:53 --> Total execution time: 0.0087
DEBUG - 2023-10-26 07:16:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:16:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:16:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:16:53 --> get_ward_list ::
DEBUG - 2023-10-26 07:16:53 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:16:53 --> Total execution time: 0.0066
DEBUG - 2023-10-26 07:18:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:26 --> Infection Form ::
DEBUG - 2023-10-26 07:18:26 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116304981', 'maqsood', '11', '205', 'ae/cap', 'tuberculosis', '1970-01-01', '', '', '', '98', 'yes', '118', 'no', '114/71', 'no', 'high', '94', '', '6', '2023-10-26', '2023-10-26 07:18:26')
DEBUG - 2023-10-26 07:18:26 --> no
DEBUG - 2023-10-26 07:18:26 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:18:26 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (327, 'Phlebitis', 'yes', '2023-10-25', 'rt arm', '', 'no', '116304981', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:18:26 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:18:26 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (327, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-21', 'No', '116304981', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:18:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:26 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:18:26 --> Total execution time: 0.0161
DEBUG - 2023-10-26 07:18:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:32 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:18:32 --> Total execution time: 0.0133
DEBUG - 2023-10-26 07:18:39 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:39 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:39 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:39 --> check_Mr_Number
DEBUG - 2023-10-26 07:18:39 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116320825'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:18:39 --> Total execution time: 0.0080
DEBUG - 2023-10-26 07:18:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:44 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:18:44 --> Total execution time: 0.0153
DEBUG - 2023-10-26 07:18:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:46 --> SELECT MAX(form_id) AS form_id, MAX(ward_no) AS ward_no, MAX(bed_no) AS bed_no, MAX(primary_diagnosis) AS primary_diagnosis, MAX(final_diagnosis) AS final_diagnosis, MAX(discharge_date) AS discharge_date, MAX(admission_date) AS admission_date, MAX(discharge_condition) AS discharge_condition, `mr_no`, `pateint_name`
FROM `ic_surveillance_form`
WHERE `form_status` = 1
GROUP BY `mr_no`
DEBUG - 2023-10-26 07:18:46 --> Total execution time: 0.0104
DEBUG - 2023-10-26 07:18:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:18:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:18:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:18:52 --> get_ward_list ::
DEBUG - 2023-10-26 07:18:52 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:18:52 --> Total execution time: 0.0080
DEBUG - 2023-10-26 07:19:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:01 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:19:01 --> Total execution time: 0.0107
DEBUG - 2023-10-26 07:19:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:01 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:19:01 --> Total execution time: 0.0172
DEBUG - 2023-10-26 07:19:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:01 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:19:01 --> Total execution time: 0.0448
DEBUG - 2023-10-26 07:19:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:01 --> start date: none
DEBUG - 2023-10-26 07:19:01 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:19:01 --> start date: none
DEBUG - 2023-10-26 07:19:01 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:19:02 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 07:19:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:02 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:19:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:02 --> Total execution time: 0.2208
DEBUG - 2023-10-26 07:19:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:02 --> start date: none
DEBUG - 2023-10-26 07:19:02 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:19:02 --> start date: none
DEBUG - 2023-10-26 07:19:02 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:19:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:09 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:19:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:09 --> start date: none
DEBUG - 2023-10-26 07:19:09 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:19:09 --> start date: none
DEBUG - 2023-10-26 07:19:09 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:19:09 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 07:19:09 --> Total execution time: 0.1258
DEBUG - 2023-10-26 07:19:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:11 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:19:11 --> Total execution time: 0.0117
DEBUG - 2023-10-26 07:19:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:38 --> check_Mr_Number
DEBUG - 2023-10-26 07:19:38 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116310820'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:19:38 --> Total execution time: 0.0089
DEBUG - 2023-10-26 07:19:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:19:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:19:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:19:38 --> get_ward_list ::
DEBUG - 2023-10-26 07:19:38 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:19:38 --> Total execution time: 0.0076
DEBUG - 2023-10-26 07:21:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:21 --> Infection Form ::
DEBUG - 2023-10-26 07:21:21 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116310820', 'syed hasan', '10', '103', 'cap, urosepsis', '', '1970-01-01', '', '', '', '98', 'no', '86', 'no', '108/52', 'no', 'medium', '82', '', '6', '2023-10-26', '2023-10-26 07:21:21')
DEBUG - 2023-10-26 07:21:21 --> no
DEBUG - 2023-10-26 07:21:21 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:21:21 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (328, 'Phlebitis', 'yes', '2023-10-23', 'rt hand', '', 'no', '116310820', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:21:21 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:21:21 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (328, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-23', 'No', '116310820', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:21:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:21 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:21:21 --> Total execution time: 0.0161
DEBUG - 2023-10-26 07:21:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:28 --> Infection Form ::
DEBUG - 2023-10-26 07:21:28 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116320825', 'qadir bux', '11', '207', 'type 2 rf', 'tuberculosis', '2023-10-25', '', '', '', '98', 'no', '98', 'no', '108/66', 'no', 'high', '94', '', '6', '2023-10-26', '2023-10-26 07:21:28')
DEBUG - 2023-10-26 07:21:28 --> no
DEBUG - 2023-10-26 07:21:28 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:21:28 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (329, 'Phlebitis', 'yes', '2023-10-25', 'lt arm', '', 'no', '116320825', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:21:28 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:21:28 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (329, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-25', 'No', '116320825', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:21:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:28 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:21:28 --> Total execution time: 0.0143
DEBUG - 2023-10-26 07:21:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:33 --> check_Mr_Number
DEBUG - 2023-10-26 07:21:33 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116299211'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:21:33 --> Total execution time: 0.0096
DEBUG - 2023-10-26 07:21:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:33 --> get_ward_list ::
DEBUG - 2023-10-26 07:21:33 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:21:33 --> Total execution time: 0.0079
DEBUG - 2023-10-26 07:21:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:45 --> check_Mr_Number
DEBUG - 2023-10-26 07:21:45 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116302475'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:21:45 --> Total execution time: 0.0143
DEBUG - 2023-10-26 07:21:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:21:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:21:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:21:45 --> get_ward_list ::
DEBUG - 2023-10-26 07:21:45 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:21:45 --> Total execution time: 0.0149
DEBUG - 2023-10-26 07:22:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:22:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:22:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:22:50 --> Infection Form ::
DEBUG - 2023-10-26 07:22:50 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116299211', 'mrs amanullah', '10', '104', 'asthma ', '0', '1970-01-01', '', '', '', '98', 'yes', '108', 'no', '116/69', 'no', 'high', '86', '', '6', '2023-10-26', '2023-10-26 07:22:50')
DEBUG - 2023-10-26 07:22:50 --> no
DEBUG - 2023-10-26 07:22:50 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:22:50 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (330, 'Phlebitis', 'yes', '2023-10-25', 'rt hand', '', 'no', '116299211', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:22:50 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:22:50 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (330, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-19', 'No', '116299211', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:22:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:22:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:22:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:22:50 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:22:50 --> Total execution time: 0.0114
DEBUG - 2023-10-26 07:23:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:02 --> check_Mr_Number
DEBUG - 2023-10-26 07:23:02 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116309865'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:23:02 --> Total execution time: 0.0129
DEBUG - 2023-10-26 07:23:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:02 --> get_ward_list ::
DEBUG - 2023-10-26 07:23:02 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:23:02 --> Total execution time: 0.0070
DEBUG - 2023-10-26 07:23:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:17 --> Infection Form ::
DEBUG - 2023-10-26 07:23:17 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116302475', 'arif', '11', '211', 'copd', 'tuberculosis', '2023-10-24', '', '', '', '98', 'no', '92', 'no', '128/65', 'no', 'high', '92', '', '6', '2023-10-26', '2023-10-26 07:23:17')
DEBUG - 2023-10-26 07:23:17 --> no
DEBUG - 2023-10-26 07:23:17 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:23:17 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (331, 'Phlebitis', 'yes', '2023-10-23', 'rt arm', '', 'no', '116302475', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:23:17 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:23:17 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (331, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-23', 'No', '116302475', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:23:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:17 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:23:17 --> Total execution time: 0.0141
DEBUG - 2023-10-26 07:23:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:23 --> Infection Form ::
DEBUG - 2023-10-26 07:23:23 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116302475', 'arif', '11', '211', 'copd', 'tuberculosis', '2023-10-24', '', '', '', '98', 'no', '92', 'no', '128/65', 'no', 'high', '92', '', '6', '2023-10-26', '2023-10-26 07:23:23')
DEBUG - 2023-10-26 07:23:23 --> no
DEBUG - 2023-10-26 07:23:23 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:23:23 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (332, 'Phlebitis', 'yes', '2023-10-23', 'rt arm', '', 'no', '116302475', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:23:23 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:23:23 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (332, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-23', 'No', '116302475', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:23:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:42 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:42 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:42 --> Infection Form ::
DEBUG - 2023-10-26 07:23:42 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116302475', 'arif', '11', '211', 'copd', 'tuberculosis', '2023-10-24', '', '', '', '98', 'no', '92', 'no', '128/65', 'no', 'high', '92', '', '6', '2023-10-26', '2023-10-26 07:23:42')
DEBUG - 2023-10-26 07:23:42 --> no
DEBUG - 2023-10-26 07:23:42 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:23:42 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (333, 'Phlebitis', 'yes', '2023-10-23', 'rt arm', '', 'no', '116302475', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:23:42 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:23:42 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (333, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-23', 'No', '116302475', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:23:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:23:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:23:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:23:44 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:23:44 --> Total execution time: 0.0132
DEBUG - 2023-10-26 07:24:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:24:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:24:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:24:00 --> check_Mr_Number
DEBUG - 2023-10-26 07:24:00 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116284242'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:24:00 --> Total execution time: 0.0743
DEBUG - 2023-10-26 07:24:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:24:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:24:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:24:01 --> get_ward_list ::
DEBUG - 2023-10-26 07:24:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:24:01 --> Total execution time: 0.0067
DEBUG - 2023-10-26 07:24:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:24:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:24:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:24:08 --> Infection Form ::
DEBUG - 2023-10-26 07:24:08 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116309865', 'faizan', '10', '105', 'hiv, aida, hep c +ve', '0', '1970-01-01', '', '', '', '98', 'no', '66', 'no', '100/52', 'no', 'high', '93', '', '6', '2023-10-26', '2023-10-26 07:24:08')
DEBUG - 2023-10-26 07:24:08 --> no
DEBUG - 2023-10-26 07:24:08 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:24:08 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (334, 'Phlebitis', 'yes', '2023-10-26', 'left arm', '', 'no', '116309865', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:24:08 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:24:08 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (334, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-23', 'No', '116309865', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:24:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:24:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:24:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:24:08 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:24:08 --> Total execution time: 0.0122
DEBUG - 2023-10-26 07:24:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:24:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:24:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:24:23 --> check_Mr_Number
DEBUG - 2023-10-26 07:24:23 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '115973099'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:24:23 --> Total execution time: 0.0115
DEBUG - 2023-10-26 07:24:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:24:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:24:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:24:23 --> get_ward_list ::
DEBUG - 2023-10-26 07:24:23 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:24:23 --> Total execution time: 0.0068
DEBUG - 2023-10-26 07:25:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:33 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:25:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:33 --> Total execution time: 0.0109
DEBUG - 2023-10-26 07:25:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:37 --> No URI present. Default controller set.
DEBUG - 2023-10-26 07:25:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:37 --> Total execution time: 0.0067
DEBUG - 2023-10-26 07:25:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:37 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 07:25:37 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 07:25:41 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:41 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:41 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:41 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 07:25:41 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 07:25:41 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:41 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:41 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:41 --> start date: none
DEBUG - 2023-10-26 07:25:41 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:25:41 --> start date: none
DEBUG - 2023-10-26 07:25:41 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:25:41 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 07:25:41 --> Total execution time: 0.1706
DEBUG - 2023-10-26 07:25:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:43 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:25:43 --> Total execution time: 0.0116
DEBUG - 2023-10-26 07:25:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:46 --> Infection Form ::
DEBUG - 2023-10-26 07:25:46 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116284242', 'aijaz', '11', '214', 'bronchopnemonia', 'tuberculosis', '1970-01-01', '', '', '', '101', 'yes', '150', 'yes', '80/57', 'no', 'high', '89', '', '6', '2023-10-26', '2023-10-26 07:25:46')
DEBUG - 2023-10-26 07:25:46 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:25:46 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (335, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-17', 'No', '116284242', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:25:46 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:25:46 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (335, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-23', 'CVP', 'No', '116284242', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:25:46 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:25:46 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_intubation_date`, `deivce_extubation_date`, `check`, `worse_cxr`, `worse_tracheal_secret`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (335, 'Ventilator Associated Pneumonia', 'yes', '2023-10-23', '2023-10-26', 'No', '1', '0', '116284242', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:25:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:46 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:25:46 --> Total execution time: 0.0105
DEBUG - 2023-10-26 07:25:55 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:25:55 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:25:55 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:25:55 --> check_Mr_Number
DEBUG - 2023-10-26 07:25:55 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '11628770'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:25:55 --> Total execution time: 0.0090
DEBUG - 2023-10-26 07:26:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:01 --> Infection Form ::
DEBUG - 2023-10-26 07:26:01 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116284242', 'aijaz', '11', '214', 'bronchopnemonia', 'tuberculosis', '1970-01-01', '', '', '', '101', 'yes', '150', 'yes', '80/57', 'no', 'high', '89', '', '6', '2023-10-26', '2023-10-26 07:26:01')
DEBUG - 2023-10-26 07:26:01 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:26:01 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (336, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-17', 'No', '116284242', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:26:01 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:26:01 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (336, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-23', 'CVP', 'No', '116284242', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:26:01 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:26:01 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_intubation_date`, `deivce_extubation_date`, `check`, `worse_cxr`, `worse_tracheal_secret`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (336, 'Ventilator Associated Pneumonia', 'yes', '2023-10-23', '2023-10-26', 'No', '1', '0', '116284242', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:26:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:05 --> check_Mr_Number
DEBUG - 2023-10-26 07:26:05 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116286770'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:26:05 --> Total execution time: 0.0060
DEBUG - 2023-10-26 07:26:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:05 --> get_ward_list ::
DEBUG - 2023-10-26 07:26:05 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:26:05 --> Total execution time: 0.0074
DEBUG - 2023-10-26 07:26:10 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:10 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:10 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:10 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:26:10 --> Total execution time: 0.0091
DEBUG - 2023-10-26 07:26:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:37 --> Infection Form ::
DEBUG - 2023-10-26 07:26:37 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('115973099', 'munni begum', '10', '106', 'htn.aki,urosepsis', '0', '2023-12-10', '', '', '', '98', 'no', '98', 'no', '99/53', 'no', 'medium', '70', '', '6', '2023-10-26', '2023-10-26 07:26:37')
DEBUG - 2023-10-26 07:26:37 --> no
DEBUG - 2023-10-26 07:26:37 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:26:37 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (337, 'Phlebitis', 'yes', '2023-10-23', 'left hand', '', 'no', '115973099', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:26:37 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:26:37 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (337, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-12', 'No', '115973099', '2023-10-26', '6', '2023-10-26')
ERROR - 2023-10-26 07:26:37 --> Severity: Warning --> count(): Parameter must be an array or an object that implements Countable /home/sidhicportal/public_html/application/controllers/Infection.php 214
DEBUG - 2023-10-26 07:26:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:37 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:26:37 --> Total execution time: 0.0123
DEBUG - 2023-10-26 07:26:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:26:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:26:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:26:56 --> check_Mr_Number
DEBUG - 2023-10-26 07:26:56 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '115930576'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:26:56 --> Total execution time: 0.0120
DEBUG - 2023-10-26 07:27:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:27:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:27:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:27:04 --> get_ward_list ::
DEBUG - 2023-10-26 07:27:04 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:27:04 --> Total execution time: 0.0076
DEBUG - 2023-10-26 07:29:10 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:10 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:10 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:10 --> check_Mr_Number
DEBUG - 2023-10-26 07:29:10 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116286770'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:29:10 --> Total execution time: 0.0629
DEBUG - 2023-10-26 07:29:10 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:10 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:10 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:10 --> get_ward_list ::
DEBUG - 2023-10-26 07:29:10 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:29:10 --> Total execution time: 0.0118
DEBUG - 2023-10-26 07:29:13 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:13 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:13 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:13 --> check_Mr_Number
DEBUG - 2023-10-26 07:29:13 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116286770'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:29:13 --> Total execution time: 0.0071
DEBUG - 2023-10-26 07:29:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:14 --> get_ward_list ::
DEBUG - 2023-10-26 07:29:14 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:29:14 --> Total execution time: 0.0076
DEBUG - 2023-10-26 07:29:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:17 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:29:17 --> Total execution time: 0.0151
DEBUG - 2023-10-26 07:29:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:20 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:29:20 --> Total execution time: 0.0101
DEBUG - 2023-10-26 07:29:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:44 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:29:44 --> Total execution time: 0.0132
DEBUG - 2023-10-26 07:29:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:29:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:29:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:29:56 --> check_Mr_Number
DEBUG - 2023-10-26 07:29:56 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '115930576'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:29:56 --> Total execution time: 0.0110
DEBUG - 2023-10-26 07:30:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:30:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:30:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:30:07 --> Infection Form ::
DEBUG - 2023-10-26 07:30:07 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116286770', 'saima', '9', '335', 'mengoencephlitis', '0', '2023-10-17', '', '', '', '98', 'yes', '136', 'yes', '81/36', 'no', 'high', '80', '', '6', '2023-10-26', '2023-10-26 07:30:07')
DEBUG - 2023-10-26 07:30:07 --> yes
DEBUG - 2023-10-26 07:30:07 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:30:07 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (338, 'Phlebitis', 'yes', '2023-10-22', 'left arm', '', 'no', '116286770', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:30:07 --> phlebitis_antibiotic
DEBUG - 2023-10-26 07:30:07 --> Array
(
    [phlebitis_date] => Array
        (
            [0] => 10/18/2023
        )

    [phlebitis_source] => Array
        (
            [0] => Blood
        )

    [phlebitis_result] => Array
        (
            [0] => Positive
        )

    [phlebitis_organism] => Array
        (
            [0] => 
        )

    [phlebitis_mdr_name] => Array
        (
            [0] => 
        )

)

DEBUG - 2023-10-26 07:30:07 --> InfectionFormCulture ::
DEBUG - 2023-10-26 07:30:07 --> INSERT INTO `ic_culture_report` (`form_id`, `device_id`, `culture_insertion_date`, `culture_source`, `culture_result`, `culture_organism`, `culture_antibio`, `MDR`, `culture_creation`, `created_by`) VALUES (338, 506, '2023-10-18', 'Blood', 'Positive', '', NULL, '', '2023-10-26', '6')
DEBUG - 2023-10-26 07:30:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:30:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:30:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:30:07 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:30:07 --> Total execution time: 0.0351
DEBUG - 2023-10-26 07:30:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:30:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:30:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:30:09 --> get_ward_list ::
DEBUG - 2023-10-26 07:30:09 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:30:09 --> Total execution time: 0.0125
DEBUG - 2023-10-26 07:30:19 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:30:19 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:30:19 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:30:19 --> check_Mr_Number
DEBUG - 2023-10-26 07:30:19 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116315222'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:30:19 --> Total execution time: 0.0073
DEBUG - 2023-10-26 07:30:19 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:30:19 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:30:19 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:30:19 --> get_ward_list ::
DEBUG - 2023-10-26 07:30:19 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:30:19 --> Total execution time: 0.0067
DEBUG - 2023-10-26 07:32:03 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:03 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:03 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:03 --> Infection Form ::
DEBUG - 2023-10-26 07:32:03 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116315222', 'aliyan', '9', '336', 'post measles', '0', '2023-10-24', '', '', '', '98', 'yes', '186', 'yes', '87/44', 'no', 'high', '78', '', '6', '2023-10-26', '2023-10-26 07:32:03')
DEBUG - 2023-10-26 07:32:03 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:32:03 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (339, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-25', 'No', '116315222', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:32:03 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:32:03 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (339, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-24', 'CVP', 'No', '116315222', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:32:03 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:32:03 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_intubation_date`, `deivce_extubation_date`, `check`, `worse_cxr`, `worse_tracheal_secret`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (339, 'Ventilator Associated Pneumonia', 'yes', '2023-10-22', '2023-10-26', 'No', '0', '0', '116315222', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:32:03 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:03 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:03 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:03 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:32:03 --> Total execution time: 0.0365
DEBUG - 2023-10-26 07:32:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:14 --> check_Mr_Number
DEBUG - 2023-10-26 07:32:14 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116276689'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:32:14 --> Total execution time: 0.0066
DEBUG - 2023-10-26 07:32:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:14 --> get_ward_list ::
DEBUG - 2023-10-26 07:32:14 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:32:14 --> Total execution time: 0.0058
DEBUG - 2023-10-26 07:32:29 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:29 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:29 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:29 --> Infection Form ::
DEBUG - 2023-10-26 07:32:29 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('115930576', 'shabina', '10', '107', 'a.e ild', '0', '2023-10-07', '', '', '', '98', 'yes', '140', 'no', '100/53', 'no', 'high', '96', '', '6', '2023-10-26', '2023-10-26 07:32:29')
ERROR - 2023-10-26 07:32:29 --> Severity: Warning --> count(): Parameter must be an array or an object that implements Countable /home/sidhicportal/public_html/application/controllers/Infection.php 163
DEBUG - 2023-10-26 07:32:29 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:32:29 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (340, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-07', 'No', '115930576', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:32:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:30 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:32:30 --> Total execution time: 0.0118
DEBUG - 2023-10-26 07:32:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:43 --> check_Mr_Number
DEBUG - 2023-10-26 07:32:43 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116322092'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:32:43 --> Total execution time: 0.0140
DEBUG - 2023-10-26 07:32:54 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:32:54 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:32:54 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:32:54 --> get_ward_list ::
DEBUG - 2023-10-26 07:32:54 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:32:54 --> Total execution time: 0.0063
DEBUG - 2023-10-26 07:33:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:33:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:33:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:33:01 --> Infection Form ::
DEBUG - 2023-10-26 07:33:01 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116276689', 'muhammad ahmer', '9', '337', 'viral meningitis', '0', '2023-10-23', '', '', '', '98', 'yes', '101', 'no', '98/45', 'no', 'high', '66', '', '6', '2023-10-26', '2023-10-26 07:33:01')
DEBUG - 2023-10-26 07:33:01 --> no
DEBUG - 2023-10-26 07:33:01 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:33:01 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (341, 'Phlebitis', 'yes', '2023-10-26', 'left arm', '', 'no', '116276689', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:33:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:33:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:33:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:33:01 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:33:01 --> Total execution time: 0.0136
DEBUG - 2023-10-26 07:33:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:33:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:33:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:33:11 --> check_Mr_Number
DEBUG - 2023-10-26 07:33:11 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116315055'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:33:11 --> Total execution time: 0.0075
DEBUG - 2023-10-26 07:33:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:33:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:33:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:33:11 --> get_ward_list ::
DEBUG - 2023-10-26 07:33:11 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:33:11 --> Total execution time: 0.0072
DEBUG - 2023-10-26 07:34:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:21 --> Infection Form ::
DEBUG - 2023-10-26 07:34:21 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116315055', 'muntaha', '9', '338', 'fever', '', '2023-10-24', '', '', '', '98', 'yes', '163', 'yes', '88/45', 'no', 'medium', '71', '', '6', '2023-10-26', '2023-10-26 07:34:21')
DEBUG - 2023-10-26 07:34:21 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:34:21 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (342, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-25', 'No', '116315055', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:34:21 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:34:21 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (342, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-25', 'CVP', 'No', '116315055', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:34:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:21 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:34:21 --> Total execution time: 0.0113
DEBUG - 2023-10-26 07:34:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:33 --> check_Mr_Number
DEBUG - 2023-10-26 07:34:33 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307535'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:34:33 --> Total execution time: 0.0087
DEBUG - 2023-10-26 07:34:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:33 --> get_ward_list ::
DEBUG - 2023-10-26 07:34:33 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:34:33 --> Total execution time: 0.0061
DEBUG - 2023-10-26 07:34:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:44 --> Infection Form ::
DEBUG - 2023-10-26 07:34:44 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116322092', 'shamshad', '10', '108', 'complicated malaria', '0', '2023-10-26', '', '', '', '98', 'yes', '109', 'no', '100/53', 'no', 'medium', '88', '', '6', '2023-10-26', '2023-10-26 07:34:44')
DEBUG - 2023-10-26 07:34:44 --> no
DEBUG - 2023-10-26 07:34:44 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:34:44 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (343, 'Phlebitis', 'yes', '2023-10-26', 'rt arm', '', 'no', '116322092', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:34:44 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:34:44 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (343, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-26', 'No', '116322092', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:34:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:44 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:34:44 --> Total execution time: 0.0097
DEBUG - 2023-10-26 07:34:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:34:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:34:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:34:56 --> check_Mr_Number
DEBUG - 2023-10-26 07:34:56 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116179484'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:34:56 --> Total execution time: 0.0102
DEBUG - 2023-10-26 07:35:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:07 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:07 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:35:07 --> Total execution time: 0.0096
DEBUG - 2023-10-26 07:35:25 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:25 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:25 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:25 --> Infection Form ::
DEBUG - 2023-10-26 07:35:25 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116307535', 'nabi sarwar', '9', '336', 'malaria and dengue', '0', '2023-10-23', '', '', '', '98', 'yes', '134', 'no', '98/56', 'no', 'medium', '27', '', '6', '2023-10-26', '2023-10-26 07:35:25')
DEBUG - 2023-10-26 07:35:25 --> no
DEBUG - 2023-10-26 07:35:25 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:35:25 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (344, 'Phlebitis', 'yes', '2023-10-26', 'right arm', '', 'no', '116307535', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:35:25 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:25 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:25 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:25 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:35:25 --> Total execution time: 0.0101
DEBUG - 2023-10-26 07:35:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:38 --> check_Mr_Number
DEBUG - 2023-10-26 07:35:38 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116299973'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:35:38 --> Total execution time: 0.0100
DEBUG - 2023-10-26 07:35:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:43 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:43 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '7'
DEBUG - 2023-10-26 07:35:43 --> Total execution time: 0.0064
DEBUG - 2023-10-26 07:35:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:43 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:43 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '3'
DEBUG - 2023-10-26 07:35:43 --> Total execution time: 0.0065
DEBUG - 2023-10-26 07:35:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:44 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '8'
DEBUG - 2023-10-26 07:35:44 --> Total execution time: 0.0059
DEBUG - 2023-10-26 07:35:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:44 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:35:44 --> Total execution time: 0.0053
DEBUG - 2023-10-26 07:35:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:44 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:35:44 --> Total execution time: 0.0053
DEBUG - 2023-10-26 07:35:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:44 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:35:44 --> Total execution time: 0.0055
DEBUG - 2023-10-26 07:35:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:45 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:45 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-26 07:35:45 --> Total execution time: 0.0069
DEBUG - 2023-10-26 07:35:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:45 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:45 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '13'
DEBUG - 2023-10-26 07:35:45 --> Total execution time: 0.0082
DEBUG - 2023-10-26 07:35:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:47 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:47 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-26 07:35:47 --> Total execution time: 0.0056
DEBUG - 2023-10-26 07:35:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:48 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:48 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '13'
DEBUG - 2023-10-26 07:35:48 --> Total execution time: 0.0074
DEBUG - 2023-10-26 07:35:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:49 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:49 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-26 07:35:49 --> Total execution time: 0.0100
DEBUG - 2023-10-26 07:35:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:49 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:49 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:35:49 --> Total execution time: 0.0069
DEBUG - 2023-10-26 07:35:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:49 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:49 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:35:49 --> Total execution time: 0.0085
DEBUG - 2023-10-26 07:35:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:50 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:50 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:35:50 --> Total execution time: 0.0084
DEBUG - 2023-10-26 07:35:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:50 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:50 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:35:50 --> Total execution time: 0.0052
DEBUG - 2023-10-26 07:35:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:51 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:51 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:35:51 --> Total execution time: 0.0066
DEBUG - 2023-10-26 07:35:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:51 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:51 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-26 07:35:51 --> Total execution time: 0.0073
DEBUG - 2023-10-26 07:35:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:52 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:52 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:35:52 --> Total execution time: 0.0184
DEBUG - 2023-10-26 07:35:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:53 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:53 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-26 07:35:53 --> Total execution time: 0.0070
DEBUG - 2023-10-26 07:35:54 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:35:54 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:35:54 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:35:54 --> get_ward_list ::
DEBUG - 2023-10-26 07:35:54 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '13'
DEBUG - 2023-10-26 07:35:54 --> Total execution time: 0.0057
DEBUG - 2023-10-26 07:36:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:36:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:36:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:36:05 --> get_ward_list ::
DEBUG - 2023-10-26 07:36:05 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:36:05 --> Total execution time: 0.0169
DEBUG - 2023-10-26 07:37:16 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:16 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:16 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:16 --> Infection Form ::
DEBUG - 2023-10-26 07:37:16 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116179484', 'roshan zeba', '10', '109', 'aki,cks,hypoxic injury', '0', '2023-09-21', '', '', '', '98', 'yes', '119', 'no', '112/75', 'no', 'high', '76', '', '6', '2023-10-26', '2023-10-26 07:37:16')
DEBUG - 2023-10-26 07:37:16 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:37:16 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (345, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-21', 'No', '116179484', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:37:16 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:37:16 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (345, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-13', 'CVP', 'No', '116179484', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:37:16 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:16 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:16 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:16 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:37:16 --> Total execution time: 0.0252
DEBUG - 2023-10-26 07:37:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:26 --> Infection Form ::
DEBUG - 2023-10-26 07:37:26 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116299973', 'raeed', '9', '340', 'dengue fever', '0', '2023-10-21', '', '', '', '98', 'no', '86', 'no', '91/49', 'no', 'medium', '84', '', '6', '2023-10-26', '2023-10-26 07:37:26')
DEBUG - 2023-10-26 07:37:26 --> no
DEBUG - 2023-10-26 07:37:26 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:37:26 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (346, 'Phlebitis', 'yes', '2023-10-25', 'left arm', '', 'no', '116299973', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:37:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:26 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:37:26 --> Total execution time: 0.0281
DEBUG - 2023-10-26 07:37:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:30 --> check_Mr_Number
DEBUG - 2023-10-26 07:37:30 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116318528'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:37:30 --> Total execution time: 0.0088
DEBUG - 2023-10-26 07:37:39 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:39 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:39 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:39 --> get_ward_list ::
DEBUG - 2023-10-26 07:37:39 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:37:39 --> Total execution time: 0.0064
DEBUG - 2023-10-26 07:37:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:44 --> check_Mr_Number
DEBUG - 2023-10-26 07:37:44 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116290057'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:37:44 --> Total execution time: 0.0089
DEBUG - 2023-10-26 07:37:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:37:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:37:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:37:44 --> get_ward_list ::
DEBUG - 2023-10-26 07:37:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:37:44 --> Total execution time: 0.0076
DEBUG - 2023-10-26 07:38:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:38:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:38:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:38:50 --> Infection Form ::
DEBUG - 2023-10-26 07:38:50 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116290057', 'hania', '9', '341', 'mengoencephlitis', '0', '2023-10-18', '', '', '', '98', 'no', '76', 'no', '100/73', 'no', 'high', '73', '', '6', '2023-10-26', '2023-10-26 07:38:50')
DEBUG - 2023-10-26 07:38:50 --> no
DEBUG - 2023-10-26 07:38:50 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:38:50 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (347, 'Phlebitis', 'yes', '2023-10-25', 'right arm', '', 'no', '116290057', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:38:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:38:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:38:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:38:50 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:38:50 --> Total execution time: 0.0148
DEBUG - 2023-10-26 07:39:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:08 --> check_Mr_Number
DEBUG - 2023-10-26 07:39:08 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116320693'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:39:08 --> Total execution time: 0.0134
DEBUG - 2023-10-26 07:39:22 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:22 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:22 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:22 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:22 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '7'
DEBUG - 2023-10-26 07:39:22 --> Total execution time: 0.0086
DEBUG - 2023-10-26 07:39:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:23 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:23 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '3'
DEBUG - 2023-10-26 07:39:23 --> Total execution time: 0.0097
DEBUG - 2023-10-26 07:39:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:23 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:23 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '8'
DEBUG - 2023-10-26 07:39:23 --> Total execution time: 0.0068
DEBUG - 2023-10-26 07:39:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:23 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:23 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:39:23 --> Total execution time: 0.0099
DEBUG - 2023-10-26 07:39:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:27 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:27 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-26 07:39:27 --> Total execution time: 0.0192
DEBUG - 2023-10-26 07:39:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:27 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:27 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:39:27 --> Total execution time: 0.0063
DEBUG - 2023-10-26 07:39:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:27 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:27 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-26 07:39:27 --> Total execution time: 0.0073
DEBUG - 2023-10-26 07:39:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:28 --> get_ward_list ::
DEBUG - 2023-10-26 07:39:28 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-26 07:39:28 --> Total execution time: 0.0065
DEBUG - 2023-10-26 07:39:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:38 --> Infection Form ::
DEBUG - 2023-10-26 07:39:38 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116318528', 'adil', '10', '112', 'esrd,htn,dm', '0', '2023-10-25', '', '', '', '98', 'yes', '103', 'no', '99/50', 'no', 'medium', '77', '', '6', '2023-10-26', '2023-10-26 07:39:38')
DEBUG - 2023-10-26 07:39:38 --> no
DEBUG - 2023-10-26 07:39:38 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:39:38 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (348, 'Phlebitis', 'yes', '2023-10-25', 'rt arm', '', 'no', '116318528', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:39:38 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:39:38 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (348, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-25', 'No', '116318528', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:39:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:39:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:39:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:39:38 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:39:38 --> Total execution time: 0.0133
DEBUG - 2023-10-26 07:40:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:40:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:40:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:40:08 --> check_Mr_Number
DEBUG - 2023-10-26 07:40:08 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116312378'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:40:08 --> Total execution time: 0.0150
DEBUG - 2023-10-26 07:40:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:40:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:40:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:40:32 --> get_ward_list ::
DEBUG - 2023-10-26 07:40:32 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:40:32 --> Total execution time: 0.0094
DEBUG - 2023-10-26 07:41:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:41:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:41:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:41:05 --> Infection Form ::
DEBUG - 2023-10-26 07:41:05 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116320693', 'elishah', '9', '342', 'post measles', '0', '2023-10-25', '', '', '', '98', 'no', '100', 'yes', '84/45', 'no', 'medium', '56', '', '6', '2023-10-26', '2023-10-26 07:41:05')
DEBUG - 2023-10-26 07:41:05 --> no
DEBUG - 2023-10-26 07:41:05 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:41:05 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (349, 'Phlebitis', 'yes', '2023-10-25', 'left arm', '', 'no', '116320693', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:41:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:41:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:41:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:41:05 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:41:05 --> Total execution time: 0.0120
DEBUG - 2023-10-26 07:41:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:41:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:41:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:41:20 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:41:20 --> Total execution time: 0.0124
DEBUG - 2023-10-26 07:41:22 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:41:22 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:41:22 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:41:22 --> SELECT MAX(form_id) AS form_id, MAX(ward_no) AS ward_no, MAX(bed_no) AS bed_no, MAX(primary_diagnosis) AS primary_diagnosis, MAX(final_diagnosis) AS final_diagnosis, MAX(discharge_date) AS discharge_date, MAX(admission_date) AS admission_date, MAX(discharge_condition) AS discharge_condition, `mr_no`, `pateint_name`
FROM `ic_surveillance_form`
WHERE `form_status` = 1
GROUP BY `mr_no`
DEBUG - 2023-10-26 07:41:22 --> Total execution time: 0.0102
DEBUG - 2023-10-26 07:41:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:41:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:41:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:41:49 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:41:49 --> Total execution time: 0.0141
DEBUG - 2023-10-26 07:42:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:42:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:42:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:42:26 --> Infection Form ::
DEBUG - 2023-10-26 07:42:26 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116312378', 'muhammad yameen', '10', '113', 'copd', '0', '2023-10-24', '', '', '', '98', 'no', '95', 'no', '100/53', 'no', 'high', '73', '', '6', '2023-10-26', '2023-10-26 07:42:26')
DEBUG - 2023-10-26 07:42:26 --> no
DEBUG - 2023-10-26 07:42:26 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:42:26 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (350, 'Phlebitis', 'yes', '2023-10-26', 'left arm', '', 'no', '116312378', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:42:26 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:42:26 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (350, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-24', 'No', '116312378', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:42:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:42:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:42:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:42:27 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:42:27 --> Total execution time: 0.0123
DEBUG - 2023-10-26 07:42:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:42:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:42:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:42:49 --> check_Mr_Number
DEBUG - 2023-10-26 07:42:49 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116312080'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:42:49 --> Total execution time: 0.0140
DEBUG - 2023-10-26 07:43:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:43:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:43:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:43:04 --> get_ward_list ::
DEBUG - 2023-10-26 07:43:04 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:43:04 --> Total execution time: 0.0113
DEBUG - 2023-10-26 07:44:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:44:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:44:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:44:32 --> Infection Form ::
DEBUG - 2023-10-26 07:44:32 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116312080', 'miraj ul nisa', '10', '114', '', '0', '2023-10-23', '', '', '', '98', 'no', '76', 'no', '100/59', 'no', 'high', '98', '', '6', '2023-10-26', '2023-10-26 07:44:32')
DEBUG - 2023-10-26 07:44:32 --> no
DEBUG - 2023-10-26 07:44:32 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:44:32 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (351, 'Phlebitis', 'yes', '2023-10-23', 'rt arm', '', 'no', '116312080', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:44:32 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:44:32 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (351, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-23', 'No', '116312080', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:44:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:44:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:44:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:44:32 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:44:32 --> Total execution time: 0.0174
DEBUG - 2023-10-26 07:44:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:44:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:44:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:44:46 --> check_Mr_Number
DEBUG - 2023-10-26 07:44:46 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116292928'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:44:46 --> Total execution time: 0.0112
DEBUG - 2023-10-26 07:44:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:44:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:44:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:44:58 --> get_ward_list ::
DEBUG - 2023-10-26 07:44:58 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:44:58 --> Total execution time: 0.0088
DEBUG - 2023-10-26 07:47:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:47:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:47:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:47:05 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:47:05 --> Total execution time: 0.0545
DEBUG - 2023-10-26 07:47:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:47:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:47:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:47:09 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:47:09 --> Total execution time: 0.0098
DEBUG - 2023-10-26 07:47:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:47:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:47:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:47:15 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:47:15 --> Total execution time: 0.0114
DEBUG - 2023-10-26 07:47:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:47:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:47:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:47:50 --> Infection Form ::
DEBUG - 2023-10-26 07:47:50 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116292928', 'shamim', '10', '115', 'ckd,dm,htn,cva', '0', '2023-10-19', '', '', '', '98', 'yes', '123', 'no', '100/52', 'no', 'high', '85', '', '6', '2023-10-26', '2023-10-26 07:47:50')
DEBUG - 2023-10-26 07:47:50 --> no
DEBUG - 2023-10-26 07:47:50 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:47:50 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `site`, `phlebitis`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (352, 'Phlebitis', 'yes', '2023-10-26', 'left arm', '', 'no', '116292928', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:47:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:47:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:47:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:47:50 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:47:50 --> Total execution time: 0.0122
DEBUG - 2023-10-26 07:48:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:48:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:48:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:48:02 --> check_Mr_Number
DEBUG - 2023-10-26 07:48:02 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307045'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:48:02 --> Total execution time: 0.0409
DEBUG - 2023-10-26 07:48:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:48:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:48:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:48:30 --> get_ward_list ::
DEBUG - 2023-10-26 07:48:30 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:48:30 --> Total execution time: 0.0242
DEBUG - 2023-10-26 07:50:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:50:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:50:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:50:05 --> Infection Form ::
DEBUG - 2023-10-26 07:50:05 --> INSERT INTO `ic_surveillance_form` (`mr_no`, `pateint_name`, `ward_no`, `bed_no`, `primary_diagnosis`, `final_diagnosis`, `admission_date`, `discharge_date`, `discharge_condition`, `fever`, `temp`, `tachy`, `pulse`, `hypo`, `bp`, `chills`, `wbc`, `neutro`, `lymp`, `created_by`, `created_at`, `form_creation`) VALUES ('116307045', 'memmona sarwr', '10', '116', 'age,aki,p.e', '0', '2023-10-22', '', '', '', '98', 'no', '80', 'no', '111/53', 'no', 'high', '74', '', '6', '2023-10-26', '2023-10-26 07:50:05')
DEBUG - 2023-10-26 07:50:05 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:50:05 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `type`, `deivce_insertion_date`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (353, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-20', 'No', '116307045', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:50:05 --> InfectionFormDevice ::
DEBUG - 2023-10-26 07:50:05 --> INSERT INTO `ic_infection_devices` (`form_id`, `device_name`, `device_status`, `deivce_insertion_date`, `type`, `check`, `mr_no`, `device_creation`, `created_by`, `created_at`) VALUES (353, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-20', 'CVP', 'No', '116307045', '2023-10-26', '6', '2023-10-26')
DEBUG - 2023-10-26 07:50:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:50:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:50:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:50:05 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:50:05 --> Total execution time: 0.0156
DEBUG - 2023-10-26 07:50:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:50:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:50:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:50:07 --> SELECT MAX(form_id) AS form_id, MAX(ward_no) AS ward_no, MAX(bed_no) AS bed_no, MAX(primary_diagnosis) AS primary_diagnosis, MAX(final_diagnosis) AS final_diagnosis, MAX(discharge_date) AS discharge_date, MAX(admission_date) AS admission_date, MAX(discharge_condition) AS discharge_condition, `mr_no`, `pateint_name`
FROM `ic_surveillance_form`
WHERE `form_status` = 1
GROUP BY `mr_no`
DEBUG - 2023-10-26 07:50:07 --> Total execution time: 0.0111
DEBUG - 2023-10-26 07:50:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:50:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:50:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:50:48 --> SELECT MAX(form_id) AS form_id, MAX(ward_no) AS ward_no, MAX(bed_no) AS bed_no, MAX(primary_diagnosis) AS primary_diagnosis, MAX(final_diagnosis) AS final_diagnosis, MAX(discharge_date) AS discharge_date, MAX(admission_date) AS admission_date, MAX(discharge_condition) AS discharge_condition, `mr_no`, `pateint_name`
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND DATE(form_creation) = '2023-10-26'
GROUP BY `mr_no`
DEBUG - 2023-10-26 07:50:48 --> Total execution time: 0.0160
DEBUG - 2023-10-26 07:54:55 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:54:55 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:54:55 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:54:55 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 07:54:55 --> Total execution time: 0.0694
DEBUG - 2023-10-26 07:54:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:54:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:54:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:54:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:54:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:54:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:54:59 --> Total execution time: 0.0071
DEBUG - 2023-10-26 07:54:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:54:59 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 07:54:59 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 07:55:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:55:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:55:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:55:01 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 07:55:01 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 07:55:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:55:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:55:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:55:01 --> start date: none
DEBUG - 2023-10-26 07:55:01 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:55:01 --> start date: none
DEBUG - 2023-10-26 07:55:01 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 07:55:01 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 07:55:01 --> Total execution time: 0.2639
DEBUG - 2023-10-26 07:55:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:55:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:55:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:55:05 --> start date: 
DEBUG - 2023-10-26 07:55:05 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND DATE(admission_date) BETWEEN '2023-10-26' AND '2023-10-26'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 07:55:05 --> Total execution time: 0.0277
DEBUG - 2023-10-26 07:55:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:55:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:55:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:55:40 --> check_Mr_Number
DEBUG - 2023-10-26 07:55:40 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116305202'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-26 07:55:40 --> Total execution time: 0.0087
DEBUG - 2023-10-26 07:55:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 07:55:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 07:55:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 07:55:40 --> get_ward_list ::
DEBUG - 2023-10-26 07:55:40 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-26 07:55:40 --> Total execution time: 0.0061
DEBUG - 2023-10-26 08:05:06 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:05:06 --> No URI present. Default controller set.
DEBUG - 2023-10-26 08:05:06 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 08:05:06 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 08:05:06 --> Total execution time: 0.0822
DEBUG - 2023-10-26 08:52:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:52:43 --> No URI present. Default controller set.
DEBUG - 2023-10-26 08:52:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 08:52:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 08:52:43 --> Total execution time: 0.0393
DEBUG - 2023-10-26 08:52:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:52:44 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 08:52:44 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 08:52:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:52:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 08:52:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 08:52:47 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 08:52:47 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 08:52:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:52:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 08:52:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 08:52:47 --> start date: none
DEBUG - 2023-10-26 08:52:47 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 08:52:47 --> start date: none
DEBUG - 2023-10-26 08:52:47 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 08:52:48 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 08:52:48 --> Total execution time: 0.2163
DEBUG - 2023-10-26 08:52:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:52:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 08:52:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 08:52:52 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 08:52:52 --> Total execution time: 0.0179
DEBUG - 2023-10-26 08:52:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 08:52:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 08:52:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 08:52:56 --> SELECT MAX(form_id) AS form_id, MAX(ward_no) AS ward_no, MAX(bed_no) AS bed_no, MAX(primary_diagnosis) AS primary_diagnosis, MAX(final_diagnosis) AS final_diagnosis, MAX(discharge_date) AS discharge_date, MAX(admission_date) AS admission_date, MAX(discharge_condition) AS discharge_condition, `mr_no`, `pateint_name`
FROM `ic_surveillance_form`
WHERE `form_status` = 1
GROUP BY `mr_no`
DEBUG - 2023-10-26 08:52:56 --> Total execution time: 0.0088
DEBUG - 2023-10-26 09:05:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 09:05:15 --> No URI present. Default controller set.
DEBUG - 2023-10-26 09:05:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 09:05:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 09:05:15 --> Total execution time: 0.0508
DEBUG - 2023-10-26 09:28:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 09:28:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 09:28:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 09:28:32 --> start date: none
DEBUG - 2023-10-26 09:28:32 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 09:28:32 --> start date: none
DEBUG - 2023-10-26 09:28:32 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 09:28:32 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 09:28:32 --> Total execution time: 0.2340
DEBUG - 2023-10-26 09:42:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 09:42:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 09:42:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 09:42:21 --> start date: none
DEBUG - 2023-10-26 09:42:21 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 09:42:21 --> start date: none
DEBUG - 2023-10-26 09:42:21 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 09:42:21 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 09:42:21 --> Total execution time: 0.1982
DEBUG - 2023-10-26 10:05:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 10:05:17 --> No URI present. Default controller set.
DEBUG - 2023-10-26 10:05:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 10:05:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 10:05:17 --> Total execution time: 0.0854
DEBUG - 2023-10-26 10:56:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 10:56:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 10:56:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 10:56:07 --> start date: none
DEBUG - 2023-10-26 10:56:07 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 10:56:07 --> start date: none
DEBUG - 2023-10-26 10:56:07 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 10:56:08 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 10:56:08 --> Total execution time: 0.3007
DEBUG - 2023-10-26 11:04:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 11:04:48 --> No URI present. Default controller set.
DEBUG - 2023-10-26 11:04:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 11:04:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 11:04:49 --> Total execution time: 0.0554
DEBUG - 2023-10-26 11:11:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 11:11:21 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 11:11:21 --> 404 Page Not Found: Humanstxt/index
DEBUG - 2023-10-26 11:11:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 11:11:21 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 11:11:21 --> 404 Page Not Found: Adstxt/index
DEBUG - 2023-10-26 11:11:22 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 11:11:22 --> No URI present. Default controller set.
DEBUG - 2023-10-26 11:11:22 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 11:11:22 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 11:11:22 --> Total execution time: 0.0361
DEBUG - 2023-10-26 11:31:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 11:31:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 11:31:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 11:31:58 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_ward`.`ward_no`, `ic_ward`.`ward_depart`
FROM `ic_bed`
INNER JOIN `ic_ward` ON `ic_ward`.`ward_id`=`ic_bed`.`ward_no`
WHERE `bed_status` = 1
DEBUG - 2023-10-26 11:31:58 --> Total execution time: 0.0660
DEBUG - 2023-10-26 12:04:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 12:04:42 --> No URI present. Default controller set.
DEBUG - 2023-10-26 12:04:42 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 12:04:42 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 12:04:42 --> Total execution time: 0.0509
DEBUG - 2023-10-26 13:05:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 13:05:20 --> No URI present. Default controller set.
DEBUG - 2023-10-26 13:05:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 13:05:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 13:05:20 --> Total execution time: 0.0884
DEBUG - 2023-10-26 13:05:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 13:05:42 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 13:05:42 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 13:05:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 13:05:42 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 13:05:42 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 13:05:42 --> Total execution time: 0.0071
DEBUG - 2023-10-26 13:05:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 13:05:42 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 13:05:42 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 13:05:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 13:05:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 13:05:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 13:05:45 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 13:05:45 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 13:05:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 13:05:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 13:05:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 13:05:45 --> start date: none
DEBUG - 2023-10-26 13:05:45 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 13:05:45 --> start date: none
DEBUG - 2023-10-26 13:05:45 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 13:05:46 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 13:05:46 --> Total execution time: 0.1869
DEBUG - 2023-10-26 14:04:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 14:04:59 --> No URI present. Default controller set.
DEBUG - 2023-10-26 14:04:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 14:04:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 14:04:59 --> Total execution time: 0.0547
DEBUG - 2023-10-26 14:29:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 14:29:52 --> No URI present. Default controller set.
DEBUG - 2023-10-26 14:29:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 14:29:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 14:29:52 --> Total execution time: 0.0411
DEBUG - 2023-10-26 15:04:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:04:28 --> No URI present. Default controller set.
DEBUG - 2023-10-26 15:04:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:04:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:04:28 --> Total execution time: 0.0472
DEBUG - 2023-10-26 15:49:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:36 --> No URI present. Default controller set.
DEBUG - 2023-10-26 15:49:36 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:36 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:36 --> Total execution time: 0.0418
DEBUG - 2023-10-26 15:49:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:36 --> No URI present. Default controller set.
DEBUG - 2023-10-26 15:49:36 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:36 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:36 --> Total execution time: 0.0058
DEBUG - 2023-10-26 15:49:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:36 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-26 15:49:36 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-26 15:49:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:37 --> SELECT *
FROM `ic_users`
INNER JOIN `ic_roles` ON `ic_users`.`user_role_id`=`ic_roles`.`role_code`
WHERE `user_name` = 'ICADMIN'
AND `user_password` = '4124bc0a9335c27f086f24ba207a4912'
AND `user_status` = '1'
DEBUG - 2023-10-26 15:49:37 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-26 15:49:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:37 --> start date: none
DEBUG - 2023-10-26 15:49:37 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 15:49:37 --> start date: none
DEBUG - 2023-10-26 15:49:37 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-26 15:49:37 --> get_mdro_graphSELECT `w`.`ward_depart`, COALESCE(COUNT(cr.`culture_id`), 0) AS mdro_count
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
RIGHT JOIN `ic_ward` `w` ON w.`ward_id` = sf.`ward_no`
GROUP BY `w`.`ward_depart`
DEBUG - 2023-10-26 15:49:37 --> Total execution time: 0.2010
DEBUG - 2023-10-26 15:49:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:43 --> Total execution time: 0.0081
DEBUG - 2023-10-26 15:49:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:50 --> SELECT MAX(form_id) AS form_id, MAX(ward_no) AS ward_no, MAX(bed_no) AS bed_no, MAX(primary_diagnosis) AS primary_diagnosis, MAX(final_diagnosis) AS final_diagnosis, MAX(discharge_date) AS discharge_date, MAX(admission_date) AS admission_date, MAX(discharge_condition) AS discharge_condition, `mr_no`, `pateint_name`
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND DATE(form_creation) = '2023-10-24'
GROUP BY `mr_no`
DEBUG - 2023-10-26 15:49:50 --> Total execution time: 0.0068
DEBUG - 2023-10-26 15:49:55 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:49:55 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:49:55 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:49:55 --> start date: 
DEBUG - 2023-10-26 15:49:55 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND DATE(admission_date) BETWEEN '2023-10-26' AND '2023-10-26'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 15:49:55 --> Total execution time: 0.0071
DEBUG - 2023-10-26 15:50:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:50:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:50:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:50:02 --> start date: 2023-10-24
DEBUG - 2023-10-26 15:50:02 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND DATE(admission_date) BETWEEN '2023-10-24' AND '2023-10-25'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 15:50:02 --> Total execution time: 0.0401
DEBUG - 2023-10-26 15:50:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 15:50:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 15:50:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 15:50:23 --> start date: 2023-10-24
DEBUG - 2023-10-26 15:50:23 --> SELECT *
FROM `ic_surveillance_form` `sf`
LEFT JOIN `ic_infection_devices` `id` ON `id`.`form_id` = `sf`.`form_id`
LEFT JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
WHERE DATE(admission_date) <= DATE(DATE_SUB(NOW(), INTERVAL 48 HOUR))
AND DATE(admission_date) BETWEEN '2023-10-24' AND '2023-10-25'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-26 15:50:23 --> Total execution time: 0.0095
DEBUG - 2023-10-26 16:04:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-26 16:04:40 --> No URI present. Default controller set.
DEBUG - 2023-10-26 16:04:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-26 16:04:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-26 16:04:40 --> Total execution time: 0.0527
