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

DEBUG - 2023-10-25 00:05:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 00:05:38 --> No URI present. Default controller set.
DEBUG - 2023-10-25 00:05:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 00:05:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 00:05:38 --> Total execution time: 0.0505
DEBUG - 2023-10-25 01:04:54 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 01:04:54 --> No URI present. Default controller set.
DEBUG - 2023-10-25 01:04:54 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 01:04:54 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 01:04:54 --> Total execution time: 0.0500
DEBUG - 2023-10-25 02:04:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 02:04:00 --> No URI present. Default controller set.
DEBUG - 2023-10-25 02:04:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 02:04:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 02:04:00 --> Total execution time: 0.0643
DEBUG - 2023-10-25 02:48:06 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 02:48:06 --> No URI present. Default controller set.
DEBUG - 2023-10-25 02:48:06 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 02:48:06 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 02:48:06 --> Total execution time: 0.0493
DEBUG - 2023-10-25 03:04:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 03:04:33 --> No URI present. Default controller set.
DEBUG - 2023-10-25 03:04:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 03:04:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 03:04:33 --> Total execution time: 0.0407
DEBUG - 2023-10-25 04:05:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 04:05:07 --> No URI present. Default controller set.
DEBUG - 2023-10-25 04:05:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 04:05:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 04:05:07 --> Total execution time: 0.0575
DEBUG - 2023-10-25 04:24:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 04:24:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 04:24:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 04:24:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 04:24:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 04:24:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 04:24:35 --> Total execution time: 0.0055
DEBUG - 2023-10-25 04:24:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 04:24:36 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 04:24:36 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 05:05:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:05:09 --> No URI present. Default controller set.
DEBUG - 2023-10-25 05:05:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:05:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:05:09 --> Total execution time: 0.0452
DEBUG - 2023-10-25 05:13:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:13:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:13:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:13: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-25 05:13:49 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-25 05:13:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:13:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:13:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:13:49 --> start date: none
DEBUG - 2023-10-25 05:13: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-25 05:13:49 --> start date: none
DEBUG - 2023-10-25 05:13:49 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 05:13: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-25 05:13:49 --> Total execution time: 0.2661
DEBUG - 2023-10-25 05:14:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:14:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:14:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:14:04 --> start date: 
DEBUG - 2023-10-25 05:14:04 --> 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-25' AND '2023-10-25'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-25 05:14:04 --> Total execution time: 0.0640
DEBUG - 2023-10-25 05:14:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:14:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:14:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:14:09 --> start date: 2023-10-23
DEBUG - 2023-10-25 05:14: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 DATE(admission_date) BETWEEN '2023-10-23' AND '2023-10-25'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-25 05:14:09 --> Total execution time: 0.0089
DEBUG - 2023-10-25 05:14:18 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:14:18 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:14:18 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:14:18 --> start date: 
DEBUG - 2023-10-25 05:14:18 --> 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-25' AND '2023-10-25'
AND `id`.`check` = 'yes'
GROUP BY `admission_date`, `id`.`device_name`
DEBUG - 2023-10-25 05:14:18 --> Total execution time: 0.0078
DEBUG - 2023-10-25 05:25:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 05:25:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 05:25:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 05:25:07 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 05:25:07 --> Total execution time: 0.1128
DEBUG - 2023-10-25 06:05:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 06:05:49 --> No URI present. Default controller set.
DEBUG - 2023-10-25 06:05:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 06:05:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 06:05:49 --> Total execution time: 0.0965
DEBUG - 2023-10-25 07:06:29 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 07:06:29 --> No URI present. Default controller set.
DEBUG - 2023-10-25 07:06:29 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 07:06:29 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 07:06:29 --> Total execution time: 0.0574
DEBUG - 2023-10-25 07:30:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 07:30:09 --> No URI present. Default controller set.
DEBUG - 2023-10-25 07:30:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 07:30:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 07:30:09 --> Total execution time: 0.0622
DEBUG - 2023-10-25 07:30:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 07:30:09 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 07:30:09 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 08:05:33 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 08:05:33 --> No URI present. Default controller set.
DEBUG - 2023-10-25 08:05:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 08:05:33 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 08:05:33 --> Total execution time: 0.0858
DEBUG - 2023-10-25 09:05:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:05:37 --> No URI present. Default controller set.
DEBUG - 2023-10-25 09:05:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:05:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:05:37 --> Total execution time: 0.0432
DEBUG - 2023-10-25 09:22:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:22:52 --> No URI present. Default controller set.
DEBUG - 2023-10-25 09:22:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:22:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:22:52 --> Total execution time: 0.0381
DEBUG - 2023-10-25 09:23:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:02 --> No URI present. Default controller set.
DEBUG - 2023-10-25 09:23:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:23:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:23:02 --> Total execution time: 0.0083
DEBUG - 2023-10-25 09:23:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:02 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 09:23:02 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 09:23:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:23:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:23:04 --> 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-25 09:23:04 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-25 09:23:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:23:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:23:04 --> start date: none
DEBUG - 2023-10-25 09:23:04 --> 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-25 09:23:04 --> start date: none
DEBUG - 2023-10-25 09:23:04 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 09:23:04 --> 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-25 09:23:04 --> Total execution time: 0.1887
DEBUG - 2023-10-25 09:23:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:23:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:23:07 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:23:07 --> Total execution time: 0.0136
DEBUG - 2023-10-25 09:23:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:23:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:23:37 --> check_Mr_Number
DEBUG - 2023-10-25 09:23:37 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116309000'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:23:37 --> Total execution time: 0.0174
DEBUG - 2023-10-25 09:23:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:23:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:23:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:23:48 --> get_ward_list ::
DEBUG - 2023-10-25 09:23:48 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:23:48 --> Total execution time: 0.0067
DEBUG - 2023-10-25 09:26:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:26:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:26:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:26:59 --> Infection Form ::
DEBUG - 2023-10-25 09:26:59 --> 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', 'yes', '115', 'no', '100/53', 'no', 'high', '85', '', '6', '2023-10-25', '2023-10-25 09:26:59')
DEBUG - 2023-10-25 09:26:59 --> no
DEBUG - 2023-10-25 09:26:59 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:26:59 --> 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 (303, 'Phlebitis', 'yes', '2023-10-25', 'rt arm', '', 'no', '116309000', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:26:59 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:26:59 --> 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 (303, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-23', 'No', '116309000', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:26:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:26:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:26:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:26:59 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:26:59 --> Total execution time: 0.0177
DEBUG - 2023-10-25 09:27:22 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:27:22 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:27:22 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:27:22 --> check_Mr_Number
DEBUG - 2023-10-25 09:27:22 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116305202'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:27:22 --> Total execution time: 0.0099
DEBUG - 2023-10-25 09:27:31 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:27:31 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:27:31 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:27:31 --> get_ward_list ::
DEBUG - 2023-10-25 09:27:31 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:27:31 --> Total execution time: 0.0073
DEBUG - 2023-10-25 09:30:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:30:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:30:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:30:35 --> Infection Form ::
DEBUG - 2023-10-25 09:30:35 --> 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', '112/70', 'no', 'high', '80', '', '6', '2023-10-25', '2023-10-25 09:30:35')
DEBUG - 2023-10-25 09:30:35 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:30:35 --> 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 (304, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-25', 'No', '116305202', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:30:35 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:30:35 --> 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 (304, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-24', 'DICFD', 'No', '116305202', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:30:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:30:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:30:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:30:35 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:30:35 --> Total execution time: 0.0164
DEBUG - 2023-10-25 09:31:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:31:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:31:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:31:14 --> check_Mr_Number
DEBUG - 2023-10-25 09:31:14 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116310820'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:31:14 --> Total execution time: 0.0257
DEBUG - 2023-10-25 09:31:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:31:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:31:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:31:15 --> get_ward_list ::
DEBUG - 2023-10-25 09:31:15 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:31:15 --> Total execution time: 0.0142
DEBUG - 2023-10-25 09:33:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:33:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:33:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:33:17 --> Infection Form ::
DEBUG - 2023-10-25 09:33: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 ('116310820', 'syed hasan', '10', '103', 'cap, urosepsis', '', '1970-01-01', '', '', '', '98', 'no', '85', 'no', '106/59', 'no', 'high', '72', '', '6', '2023-10-25', '2023-10-25 09:33:17')
DEBUG - 2023-10-25 09:33:17 --> no
DEBUG - 2023-10-25 09:33:17 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:33: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 (305, 'Phlebitis', 'yes', '2023-10-25', 'rt hand', '', 'no', '116310820', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:33:17 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:33: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 (305, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-23', 'No', '116310820', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:33:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:33:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:33:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:33:17 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:33:17 --> Total execution time: 0.0144
DEBUG - 2023-10-25 09:33:34 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:33:34 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:33:34 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:33:34 --> check_Mr_Number
DEBUG - 2023-10-25 09:33:34 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116299211'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:33:34 --> Total execution time: 0.0128
DEBUG - 2023-10-25 09:33:34 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:33:34 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:33:34 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:33:34 --> get_ward_list ::
DEBUG - 2023-10-25 09:33:34 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:33:34 --> Total execution time: 0.0108
DEBUG - 2023-10-25 09:34:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:34:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:34:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:34:48 --> Infection Form ::
DEBUG - 2023-10-25 09:34:48 --> 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', 'no', '73', 'no', '106/53', 'no', 'high', '81', '', '6', '2023-10-25', '2023-10-25 09:34:48')
DEBUG - 2023-10-25 09:34:48 --> no
DEBUG - 2023-10-25 09:34:48 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:34:48 --> 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 (306, 'Phlebitis', 'yes', '2023-10-25', 'rt hand', '', 'no', '116299211', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:34:48 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:34:48 --> 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 (306, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-14', 'No', '116299211', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:34:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:34:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:34:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:34:48 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:34:48 --> Total execution time: 0.0137
DEBUG - 2023-10-25 09:35:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:35:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:35:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:35:01 --> check_Mr_Number
DEBUG - 2023-10-25 09:35:01 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116309865'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:35:01 --> Total execution time: 0.0207
DEBUG - 2023-10-25 09:35:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:35:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:35:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:35:01 --> get_ward_list ::
DEBUG - 2023-10-25 09:35:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:35:01 --> Total execution time: 0.0594
DEBUG - 2023-10-25 09:36:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:36:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:36:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:36:30 --> Infection Form ::
DEBUG - 2023-10-25 09:36: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 ('116309865', 'faizan', '10', '105', 'hiv, aida, hep c +ve', '0', '1970-01-01', '', '', '', '98', 'no', '96', 'no', '101/52', 'no', 'high', '75', '', '6', '2023-10-25', '2023-10-25 09:36:30')
DEBUG - 2023-10-25 09:36:30 --> no
DEBUG - 2023-10-25 09:36:30 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:36: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 (307, 'Phlebitis', 'yes', '2023-10-24', 'left arm', '', 'no', '116309865', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:36:30 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:36: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 (307, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-23', 'No', '116309865', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:36:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:36:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:36:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:36:30 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:36:30 --> Total execution time: 0.0163
DEBUG - 2023-10-25 09:36:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:36:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:36:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:36:44 --> check_Mr_Number
DEBUG - 2023-10-25 09:36:44 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '115973099'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:36:44 --> Total execution time: 0.0097
DEBUG - 2023-10-25 09:36:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:36:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:36:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:36:44 --> get_ward_list ::
DEBUG - 2023-10-25 09:36:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:36:44 --> Total execution time: 0.0074
DEBUG - 2023-10-25 09:38:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:38:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:38:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:38:02 --> Infection Form ::
DEBUG - 2023-10-25 09:38:02 --> 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', 'yes', '115', 'no', '99/53', 'no', 'medium', '90', '', '6', '2023-10-25', '2023-10-25 09:38:02')
DEBUG - 2023-10-25 09:38:02 --> no
DEBUG - 2023-10-25 09:38:02 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:38:02 --> 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 (308, 'Phlebitis', 'yes', '2023-10-23', 'left hand', '', 'no', '115973099', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:38:02 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:38:02 --> 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 (308, 'Urinary Tract Infection', 'yes', 'Silicon', '2023-10-10', 'No', '115973099', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:38:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:38:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:38:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:38:02 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:38:02 --> Total execution time: 0.0308
DEBUG - 2023-10-25 09:38:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:38:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:38:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:38:14 --> check_Mr_Number
DEBUG - 2023-10-25 09:38:14 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '115930576'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:38:14 --> Total execution time: 0.0083
DEBUG - 2023-10-25 09:38:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:38:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:38:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:38:28 --> get_ward_list ::
DEBUG - 2023-10-25 09:38:28 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 09:38:28 --> Total execution time: 0.0080
DEBUG - 2023-10-25 09:41:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:42 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:42 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:42 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:42 --> Total execution time: 0.0603
DEBUG - 2023-10-25 09:41:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:46 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:46 --> Total execution time: 0.0098
DEBUG - 2023-10-25 09:41:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:46 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:46 --> Total execution time: 0.0116
DEBUG - 2023-10-25 09:41:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:46 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:46 --> Total execution time: 0.0113
DEBUG - 2023-10-25 09:41:47 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:47 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:47 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:47 --> Total execution time: 0.0213
DEBUG - 2023-10-25 09:41:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:48 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:48 --> Total execution time: 0.0128
DEBUG - 2023-10-25 09:41:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:48 --> start date: none
DEBUG - 2023-10-25 09:41:48 --> 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-25 09:41:48 --> start date: none
DEBUG - 2023-10-25 09:41:48 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 09:41: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-25 09:41:48 --> Total execution time: 0.1739
DEBUG - 2023-10-25 09:41:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:49 --> No URI present. Default controller set.
DEBUG - 2023-10-25 09:41:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:49 --> start date: none
DEBUG - 2023-10-25 09:41: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-25 09:41:49 --> start date: none
DEBUG - 2023-10-25 09:41:49 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 09:41: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-25 09:41:49 --> Total execution time: 0.1402
DEBUG - 2023-10-25 09:41:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:49 --> No URI present. Default controller set.
DEBUG - 2023-10-25 09:41:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:51 --> No URI present. Default controller set.
DEBUG - 2023-10-25 09:41:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:51 --> start date: none
DEBUG - 2023-10-25 09:41:51 --> 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-25 09:41:51 --> start date: none
DEBUG - 2023-10-25 09:41:51 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 09:41:51 --> 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-25 09:41:51 --> Total execution time: 0.2736
DEBUG - 2023-10-25 09:41:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:41:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:41:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:41:53 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:41:53 --> Total execution time: 0.0153
DEBUG - 2023-10-25 09:42:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:42:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:42:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:42:53 --> check_Mr_Number
DEBUG - 2023-10-25 09:42:53 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116269128'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:42:53 --> Total execution time: 0.0097
DEBUG - 2023-10-25 09:42:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:42:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:42:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:42:53 --> get_ward_list ::
DEBUG - 2023-10-25 09:42:53 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 09:42:53 --> Total execution time: 0.0069
DEBUG - 2023-10-25 09:44:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:44:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:44:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:44:26 --> Infection Form ::
DEBUG - 2023-10-25 09:44: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 ('116269128', 'lakhomal', '11', '203', 'ckd', 'tuberculosis', '1970-01-01', '', '', '', '98', 'yes', '110', 'no', '94/53', 'no', 'high', '86', '', '6', '2023-10-25', '2023-10-25 09:44:26')
DEBUG - 2023-10-25 09:44:26 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:44: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 (309, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-20', 'No', '116269128', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:44:26 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:44:26 --> 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 (309, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-19', 'CVP', 'No', '116269128', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:44:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:44:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:44:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:44:27 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:44:27 --> Total execution time: 0.1105
DEBUG - 2023-10-25 09:44:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:44:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:44:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:44:44 --> check_Mr_Number
DEBUG - 2023-10-25 09:44:44 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116312287'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:44:44 --> Total execution time: 0.0089
DEBUG - 2023-10-25 09:44:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:44:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:44:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:44:44 --> get_ward_list ::
DEBUG - 2023-10-25 09:44:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 09:44:44 --> Total execution time: 0.0060
DEBUG - 2023-10-25 09:46:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:46:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:46:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:46:09 --> Infection Form ::
DEBUG - 2023-10-25 09:46:09 --> 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', 'no', '98', 'no', '98/62', 'no', 'medium', '82', '', '6', '2023-10-25', '2023-10-25 09:46:09')
DEBUG - 2023-10-25 09:46:09 --> no
DEBUG - 2023-10-25 09:46:09 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:46:09 --> 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 (310, 'Phlebitis', 'yes', '2023-10-24', 'rt hand', '', 'no', '116312287', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:46:09 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:46:09 --> 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 (310, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-24', 'No', '116312287', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:46:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:46:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:46:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:46:09 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:46:09 --> Total execution time: 0.0178
DEBUG - 2023-10-25 09:46:26 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:46:26 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:46:26 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:46:26 --> check_Mr_Number
DEBUG - 2023-10-25 09:46:26 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116304981'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:46:26 --> Total execution time: 0.0086
DEBUG - 2023-10-25 09:46:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:46:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:46:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:46:27 --> get_ward_list ::
DEBUG - 2023-10-25 09:46:27 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 09:46:27 --> Total execution time: 0.0066
DEBUG - 2023-10-25 09:48:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:48:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:48:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:48:02 --> Infection Form ::
DEBUG - 2023-10-25 09:48:02 --> 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', '124', 'no', '134/79', 'no', 'medium', '88', '', '6', '2023-10-25', '2023-10-25 09:48:02')
DEBUG - 2023-10-25 09:48:02 --> no
DEBUG - 2023-10-25 09:48:02 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:48:02 --> 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 (311, 'Phlebitis', 'yes', '2023-10-22', 'rt arm', '', 'no', '116304981', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:48:02 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:48:02 --> 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 (311, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-22', 'No', '116304981', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:48:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:48:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:48:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:48:02 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:48:02 --> Total execution time: 0.0781
DEBUG - 2023-10-25 09:48:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:48:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:48:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:48:14 --> check_Mr_Number
DEBUG - 2023-10-25 09:48:14 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116302475'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:48:14 --> Total execution time: 0.0098
DEBUG - 2023-10-25 09:48:24 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:48:24 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:48:24 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:48:24 --> get_ward_list ::
DEBUG - 2023-10-25 09:48:24 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 09:48:24 --> Total execution time: 0.0082
DEBUG - 2023-10-25 09:50:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:50:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:50:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:50:15 --> Infection Form ::
DEBUG - 2023-10-25 09:50:15 --> 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', 'yes', '106', 'no', '112/68', 'no', 'medium', '86', '', '6', '2023-10-25', '2023-10-25 09:50:15')
DEBUG - 2023-10-25 09:50:15 --> no
DEBUG - 2023-10-25 09:50:15 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:50:15 --> 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 (312, 'Phlebitis', 'yes', '2023-10-24', 'left arm', '', 'no', '116302475', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:50:15 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:50:15 --> 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 (312, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-24', 'No', '116302475', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:50:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:50:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:50:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:50:15 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:50:15 --> Total execution time: 0.0208
DEBUG - 2023-10-25 09:50:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:50:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:50:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:50:30 --> check_Mr_Number
DEBUG - 2023-10-25 09:50:30 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116284242'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 09:50:30 --> Total execution time: 0.0101
DEBUG - 2023-10-25 09:50:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:50:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:50:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:50:30 --> get_ward_list ::
DEBUG - 2023-10-25 09:50:30 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 09:50:30 --> Total execution time: 0.0062
DEBUG - 2023-10-25 09:52:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:52:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:52:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:52:21 --> Infection Form ::
DEBUG - 2023-10-25 09:52: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 ('116284242', 'aijaz', '11', '214', 'bronchopnemonia', 'tuberculosis', '1970-01-01', '', '', '', '98', 'yes', '134', 'no', '96/64', 'no', 'medium', '92', '', '6', '2023-10-25', '2023-10-25 09:52:21')
DEBUG - 2023-10-25 09:52:21 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:52: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 (313, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-17', 'No', '116284242', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:52:21 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:52: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 (313, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-23', 'CVP', 'No', '116284242', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:52:21 --> InfectionFormDevice ::
DEBUG - 2023-10-25 09:52:21 --> 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 (313, 'Ventilator Associated Pneumonia', 'yes', '2023-10-23', '2023-10-25', 'No', '1', '0', '116284242', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 09:52:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:52:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:52:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:52:21 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 09:52:21 --> Total execution time: 0.0142
DEBUG - 2023-10-25 09:52:25 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 09:52:25 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 09:52:25 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 09:52:25 --> 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-25 09:52:25 --> Total execution time: 0.0207
DEBUG - 2023-10-25 10:05:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:05:43 --> No URI present. Default controller set.
DEBUG - 2023-10-25 10:05:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:05:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:05:43 --> Total execution time: 0.0487
DEBUG - 2023-10-25 10:44:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:30 --> No URI present. Default controller set.
DEBUG - 2023-10-25 10:44:30 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:30 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:30 --> Total execution time: 0.0430
DEBUG - 2023-10-25 10:44:30 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:30 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 10:44:30 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 10:44:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:32 --> 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-25 10:44:32 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-25 10:44:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:32 --> start date: none
DEBUG - 2023-10-25 10:44: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-25 10:44:32 --> start date: none
DEBUG - 2023-10-25 10:44:32 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 10:44: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-25 10:44:32 --> Total execution time: 0.1654
DEBUG - 2023-10-25 10:44:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:35 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 10:44:35 --> Total execution time: 0.0174
DEBUG - 2023-10-25 10:44:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:38 --> 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-25 10:44:38 --> Total execution time: 0.0113
DEBUG - 2023-10-25 10:44:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:51 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `mr_no` = '00000001'
DEBUG - 2023-10-25 10:44:51 --> Total execution time: 0.0208
DEBUG - 2023-10-25 10:44:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:44:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:44:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:44:59 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `form_id` = '111'
DEBUG - 2023-10-25 10:44:59 --> SELECT *
FROM `ic_culture_report`
WHERE `form_id` = '111'
DEBUG - 2023-10-25 10:44:59 --> Total execution time: 0.0098
DEBUG - 2023-10-25 10:45:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:45:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:45:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:45:20 --> 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-25 10:45:20 --> Total execution time: 0.0107
DEBUG - 2023-10-25 10:45:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:45:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:45:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:45:40 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `mr_no` = '116286770'
DEBUG - 2023-10-25 10:45:40 --> Total execution time: 0.0113
DEBUG - 2023-10-25 10:45:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:45:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:45:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:45:44 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `form_id` = '294'
DEBUG - 2023-10-25 10:45:44 --> SELECT *
FROM `ic_culture_report`
WHERE `form_id` = '294'
DEBUG - 2023-10-25 10:45:44 --> Total execution time: 0.0090
DEBUG - 2023-10-25 10:46:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:46:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:46:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:46:20 --> start date: 
DEBUG - 2023-10-25 10:46:20 --> 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-25 10:46:20 --> Total execution time: 0.0092
DEBUG - 2023-10-25 10:46:22 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:46:22 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:46:22 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:46:22 --> start date: none
DEBUG - 2023-10-25 10:46: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-25 10:46:22 --> start date: none
DEBUG - 2023-10-25 10:46:22 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 10:46:23 --> 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-25 10:46:23 --> Total execution time: 0.1608
DEBUG - 2023-10-25 10:46:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:46:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:46:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:46:44 --> Total execution time: 0.0093
DEBUG - 2023-10-25 10:46:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:46:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:46:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:46:50 --> Total execution time: 0.0077
DEBUG - 2023-10-25 10:46:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:46:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:46:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:46:56 --> start date: none
DEBUG - 2023-10-25 10:46:56 --> 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-25 10:46:56 --> start date: none
DEBUG - 2023-10-25 10:46:56 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 10:46:56 --> 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-25 10:46:56 --> Total execution time: 0.1329
DEBUG - 2023-10-25 10:53:31 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:53:31 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:53:31 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:53:31 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:53:31 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 10:53:31 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 10:53:31 --> Total execution time: 0.0381
DEBUG - 2023-10-25 10:53:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 10:53:32 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 10:53:32 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 11:05:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 11:05:50 --> No URI present. Default controller set.
DEBUG - 2023-10-25 11:05:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 11:05:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 11:05:50 --> Total execution time: 0.0639
DEBUG - 2023-10-25 12:06:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:06:01 --> No URI present. Default controller set.
DEBUG - 2023-10-25 12:06:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:06:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:06:01 --> Total execution time: 0.0558
DEBUG - 2023-10-25 12:57:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:11 --> No URI present. Default controller set.
DEBUG - 2023-10-25 12:57:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:11 --> Total execution time: 0.0467
DEBUG - 2023-10-25 12:57:12 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:12 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 12:57:12 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 12:57:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:15 --> 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-25 12:57:15 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-25 12:57:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:15 --> start date: none
DEBUG - 2023-10-25 12:57:15 --> 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-25 12:57:15 --> start date: none
DEBUG - 2023-10-25 12:57:15 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 12:57:16 --> 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-25 12:57:16 --> Total execution time: 0.1633
DEBUG - 2023-10-25 12:57:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:20 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 12:57:20 --> Total execution time: 0.0163
DEBUG - 2023-10-25 12:57:34 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:34 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:34 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:34 --> check_Mr_Number
DEBUG - 2023-10-25 12:57:34 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = ''
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 12:57:34 --> Total execution time: 0.0118
DEBUG - 2023-10-25 12:57:34 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:34 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:34 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:34 --> get_ward_list ::
DEBUG - 2023-10-25 12:57:34 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = ''
DEBUG - 2023-10-25 12:57:34 --> Total execution time: 0.0087
DEBUG - 2023-10-25 12:57:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:45 --> check_Mr_Number
DEBUG - 2023-10-25 12:57:45 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116286770'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 12:57:45 --> Total execution time: 0.0110
DEBUG - 2023-10-25 12:57:45 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:57:45 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:57:45 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:57:45 --> get_ward_list ::
DEBUG - 2023-10-25 12:57:45 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 12:57:45 --> Total execution time: 0.0106
DEBUG - 2023-10-25 12:59:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:59:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:59:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:59:00 --> Infection Form ::
DEBUG - 2023-10-25 12:59:00 --> 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', 'no', '102/49', 'no', 'high', '80', '', '6', '2023-10-25', '2023-10-25 12:59:00')
DEBUG - 2023-10-25 12:59:00 --> no
DEBUG - 2023-10-25 12:59:00 --> InfectionFormDevice ::
DEBUG - 2023-10-25 12:59:00 --> 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 (314, 'Phlebitis', 'yes', '2023-10-22', 'left hand', '', 'no', '116286770', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 12:59:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:59:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:59:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:59:00 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 12:59:00 --> Total execution time: 0.0141
DEBUG - 2023-10-25 12:59:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:59:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:59:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:59:09 --> check_Mr_Number
DEBUG - 2023-10-25 12:59:09 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116315222'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 12:59:09 --> Total execution time: 0.0255
DEBUG - 2023-10-25 12:59:19 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 12:59:19 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 12:59:19 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 12:59:19 --> get_ward_list ::
DEBUG - 2023-10-25 12:59:19 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 12:59:19 --> Total execution time: 0.0063
DEBUG - 2023-10-25 13:01:25 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 13:01:25 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 13:01:25 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 13:01:25 --> Infection Form ::
DEBUG - 2023-10-25 13:01: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 ('116315222', 'aliyan', '9', '336', 'post measles', '0', '2023-10-24', '', '', '', '98', 'yes', '174', 'yes', '88/63', 'no', 'high', '78', '', '6', '2023-10-25', '2023-10-25 01:01:25')
DEBUG - 2023-10-25 13:01:25 --> InfectionFormDevice ::
DEBUG - 2023-10-25 13:01:25 --> 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 (315, 'Urinary Tract Infection', 'yes', 'Foleys', '2023-10-22', 'No', '116315222', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 13:01:25 --> InfectionFormDevice ::
DEBUG - 2023-10-25 13:01:25 --> 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 (315, 'Central Line Associated Bloodstream Infection', 'yes', '2023-10-24', 'CVP', 'No', '116315222', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 13:01:25 --> InfectionFormDevice ::
DEBUG - 2023-10-25 13:01:25 --> 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 (315, 'Ventilator Associated Pneumonia', 'yes', '2023-10-22', '2023-10-25', 'No', '0', '0', '116315222', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 13:01:25 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 13:01:25 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 13:01:25 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 13:01:25 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 13:01:25 --> Total execution time: 0.0347
DEBUG - 2023-10-25 13:01:37 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 13:01:37 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 13:01:37 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 13:01:37 --> check_Mr_Number
DEBUG - 2023-10-25 13:01:37 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116276689'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 13:01:37 --> Total execution time: 0.0197
DEBUG - 2023-10-25 13:01:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 13:01:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 13:01:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 13:01:38 --> get_ward_list ::
DEBUG - 2023-10-25 13:01:38 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 13:01:38 --> Total execution time: 0.0410
DEBUG - 2023-10-25 13:05:40 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 13:05:40 --> No URI present. Default controller set.
DEBUG - 2023-10-25 13:05:40 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 13:05:40 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 13:05:40 --> Total execution time: 0.0622
DEBUG - 2023-10-25 14:04:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:04:46 --> No URI present. Default controller set.
DEBUG - 2023-10-25 14:04:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:04:47 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:04:47 --> Total execution time: 0.0581
DEBUG - 2023-10-25 14:07:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:07:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:07:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:07:21 --> Infection Form ::
DEBUG - 2023-10-25 14:07: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 ('116276689', 'muhammad ahmer', '9', '337', 'viral meningitis', '0', '2023-10-23', '', '', '', '98', 'yes', '136', 'no', '91/39', 'no', 'high', '66', '', '6', '2023-10-25', '2023-10-25 02:07:21')
DEBUG - 2023-10-25 14:07:21 --> no
DEBUG - 2023-10-25 14:07:21 --> InfectionFormDevice ::
DEBUG - 2023-10-25 14:07: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 (316, 'Phlebitis', 'yes', '2023-10-25', 'left foot', '', 'no', '116276689', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 14:07:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:07:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:07:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:07:21 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 14:07:21 --> Total execution time: 0.0139
DEBUG - 2023-10-25 14:14:34 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:14:34 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:14:34 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:14:34 --> check_Mr_Number
DEBUG - 2023-10-25 14:14:34 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = ''
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:14:34 --> Total execution time: 0.0763
DEBUG - 2023-10-25 14:14:34 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:14:34 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:14:34 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:14:34 --> get_ward_list ::
DEBUG - 2023-10-25 14:14:34 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = ''
DEBUG - 2023-10-25 14:14:34 --> Total execution time: 0.0059
DEBUG - 2023-10-25 14:14:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:14:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:14:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:14:44 --> check_Mr_Number
DEBUG - 2023-10-25 14:14:44 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116315055'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:14:44 --> Total execution time: 0.0086
DEBUG - 2023-10-25 14:15:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:15:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:15:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:15:09 --> get_ward_list ::
DEBUG - 2023-10-25 14:15:09 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:15:09 --> Total execution time: 0.0091
DEBUG - 2023-10-25 14:18:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:18:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:18:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:18:17 --> check_Mr_Number
DEBUG - 2023-10-25 14:18:17 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116315055'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:18:17 --> Total execution time: 0.0513
DEBUG - 2023-10-25 14:20:39 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:20:39 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:20:39 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:20:39 --> Infection Form ::
DEBUG - 2023-10-25 14:20:39 --> 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', '166', 'no', '106/57', 'no', 'medium', '11', '', '6', '2023-10-25', '2023-10-25 02:20:39')
DEBUG - 2023-10-25 14:20:39 --> no
DEBUG - 2023-10-25 14:20:39 --> InfectionFormDevice ::
DEBUG - 2023-10-25 14:20:39 --> 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 (317, 'Phlebitis', 'yes', '2023-10-24', 'left arm', '', 'no', '116315055', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 14:20:39 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:20:39 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:20:39 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:20:39 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 14:20:39 --> Total execution time: 0.0187
DEBUG - 2023-10-25 14:20:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:20:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:20:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:20:53 --> check_Mr_Number
DEBUG - 2023-10-25 14:20:53 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:20:53 --> Total execution time: 0.0119
DEBUG - 2023-10-25 14:21:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:00 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:00 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '7'
DEBUG - 2023-10-25 14:21:00 --> Total execution time: 0.0083
DEBUG - 2023-10-25 14:21:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:00 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:00 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '3'
DEBUG - 2023-10-25 14:21:00 --> Total execution time: 0.0064
DEBUG - 2023-10-25 14:21:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:01 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '8'
DEBUG - 2023-10-25 14:21:01 --> Total execution time: 0.0069
DEBUG - 2023-10-25 14:21:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:01 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 14:21:01 --> Total execution time: 0.0079
DEBUG - 2023-10-25 14:21:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:01 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 14:21:01 --> Total execution time: 0.0074
DEBUG - 2023-10-25 14:21:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:01 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:21:01 --> Total execution time: 0.0236
DEBUG - 2023-10-25 14:21:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:02 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:02 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '3'
DEBUG - 2023-10-25 14:21:02 --> Total execution time: 0.0212
DEBUG - 2023-10-25 14:21:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:21:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:21:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:21:02 --> get_ward_list ::
DEBUG - 2023-10-25 14:21:02 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:21:02 --> Total execution time: 0.0297
DEBUG - 2023-10-25 14:22:20 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:22:20 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:22:20 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:22:20 --> check_Mr_Number
DEBUG - 2023-10-25 14:22:20 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:22:20 --> Total execution time: 0.0453
DEBUG - 2023-10-25 14:22:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:22:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:22:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:22:35 --> check_Mr_Number
DEBUG - 2023-10-25 14:22:35 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:22:35 --> Total execution time: 0.0104
DEBUG - 2023-10-25 14:22:42 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:22:42 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:22:42 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:22:42 --> check_Mr_Number
DEBUG - 2023-10-25 14:22:42 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:22:42 --> Total execution time: 0.0245
DEBUG - 2023-10-25 14:22:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:22:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:22:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:22:51 --> check_Mr_Number
DEBUG - 2023-10-25 14:22:51 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:22:51 --> Total execution time: 0.0062
DEBUG - 2023-10-25 14:22:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:22:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:22:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:22:56 --> check_Mr_Number
DEBUG - 2023-10-25 14:22:56 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = ''
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:22:56 --> Total execution time: 0.0083
DEBUG - 2023-10-25 14:22:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:22:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:22:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:22:56 --> get_ward_list ::
DEBUG - 2023-10-25 14:22:56 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = ''
DEBUG - 2023-10-25 14:22:56 --> Total execution time: 0.0079
DEBUG - 2023-10-25 14:23:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:23:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:23:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:23:04 --> check_Mr_Number
DEBUG - 2023-10-25 14:23:04 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:23:04 --> Total execution time: 0.0088
DEBUG - 2023-10-25 14:23:09 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:23:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:23:09 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:23:09 --> check_Mr_Number
DEBUG - 2023-10-25 14:23:09 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307335'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:23:09 --> Total execution time: 0.0105
DEBUG - 2023-10-25 14:24:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:24:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:24:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:24:32 --> check_Mr_Number
DEBUG - 2023-10-25 14:24:32 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116307535'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:24:32 --> Total execution time: 0.0676
DEBUG - 2023-10-25 14:24:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:24:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:24:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:24:32 --> get_ward_list ::
DEBUG - 2023-10-25 14:24:32 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:24:32 --> Total execution time: 0.0069
DEBUG - 2023-10-25 14:28:41 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:28:41 --> No URI present. Default controller set.
DEBUG - 2023-10-25 14:28:41 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:28:41 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:28:41 --> Total execution time: 0.0400
DEBUG - 2023-10-25 14:50:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:50:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:50:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:50:08 --> Infection Form ::
DEBUG - 2023-10-25 14:50: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 ('116307535', 'nabi sarwar', '9', '336', 'malaria and dengue', '0', '2023-10-23', '', '', '', '98', 'yes', '126', 'yes', '89/41', 'no', 'medium', '67', '', '6', '2023-10-25', '2023-10-25 02:50:08')
DEBUG - 2023-10-25 14:50:08 --> no
DEBUG - 2023-10-25 14:50:08 --> InfectionFormDevice ::
DEBUG - 2023-10-25 14:50: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 (318, 'Phlebitis', 'yes', '2023-10-24', 'right hand', '', 'no', '116307535', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 14:50:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:50:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:50:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:50:08 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 14:50:08 --> Total execution time: 0.0339
DEBUG - 2023-10-25 14:50:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:50:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:50:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:50:44 --> check_Mr_Number
DEBUG - 2023-10-25 14:50:44 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116268247'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:50:44 --> Total execution time: 0.0084
DEBUG - 2023-10-25 14:50:44 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:50:44 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:50:44 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:50:44 --> get_ward_list ::
DEBUG - 2023-10-25 14:50:44 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:50:44 --> Total execution time: 0.0081
DEBUG - 2023-10-25 14:51:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:51:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:51:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:51:38 --> check_Mr_Number
DEBUG - 2023-10-25 14:51:38 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116268247'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:51:38 --> Total execution time: 0.0115
DEBUG - 2023-10-25 14:51:38 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:51:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:51:38 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:51:38 --> get_ward_list ::
DEBUG - 2023-10-25 14:51:38 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:51:38 --> Total execution time: 0.0299
DEBUG - 2023-10-25 14:52:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:52:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:52:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:52:32 --> check_Mr_Number
DEBUG - 2023-10-25 14:52:32 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116268247'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:52:32 --> Total execution time: 0.0096
DEBUG - 2023-10-25 14:52:32 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:52:32 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:52:32 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:52:32 --> get_ward_list ::
DEBUG - 2023-10-25 14:52:32 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:52:32 --> Total execution time: 0.0067
DEBUG - 2023-10-25 14:52:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:52:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:52:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:52:50 --> Infection Form ::
DEBUG - 2023-10-25 14:52: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 ('116268247', 'samreen', '9', '340', 'measles with dysintry', '0', '2023-10-13', '', 'improved sent home', '', '98', 'yes', '121', 'no', '111/63', 'no', 'medium', '37', '', '6', '2023-10-25', '2023-10-25 02:52:50')
DEBUG - 2023-10-25 14:52:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:52:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:52:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:52:51 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 14:52:51 --> Total execution time: 0.0136
DEBUG - 2023-10-25 14:53:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:00 --> check_Mr_Number
DEBUG - 2023-10-25 14:53:00 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116290057'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:53:00 --> Total execution time: 0.0078
DEBUG - 2023-10-25 14:53:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:00 --> get_ward_list ::
DEBUG - 2023-10-25 14:53:00 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:53:00 --> Total execution time: 0.0062
DEBUG - 2023-10-25 14:53:24 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:24 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:24 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:24 --> check_Mr_Number
DEBUG - 2023-10-25 14:53:24 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116290057'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:53:24 --> Total execution time: 0.0075
DEBUG - 2023-10-25 14:53:24 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:24 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:24 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:24 --> get_ward_list ::
DEBUG - 2023-10-25 14:53:24 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:53:24 --> Total execution time: 0.0058
DEBUG - 2023-10-25 14:53:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:49 --> check_Mr_Number
DEBUG - 2023-10-25 14:53:49 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116290057'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:53:49 --> Total execution time: 0.0074
DEBUG - 2023-10-25 14:53:49 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:49 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:49 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:49 --> get_ward_list ::
DEBUG - 2023-10-25 14:53:49 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:53:49 --> Total execution time: 0.0062
DEBUG - 2023-10-25 14:53:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:51 --> check_Mr_Number
DEBUG - 2023-10-25 14:53:51 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116290057'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:53:51 --> Total execution time: 0.0060
DEBUG - 2023-10-25 14:53:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:53:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:53:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:53:52 --> get_ward_list ::
DEBUG - 2023-10-25 14:53:52 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:53:52 --> Total execution time: 0.0064
DEBUG - 2023-10-25 14:54:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:43 --> Infection Form ::
DEBUG - 2023-10-25 14:54:43 --> 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', 'yes', '136', 'no', '120/85', 'no', 'medium', '67', '', '6', '2023-10-25', '2023-10-25 02:54:43')
DEBUG - 2023-10-25 14:54:43 --> no
DEBUG - 2023-10-25 14:54:43 --> InfectionFormDevice ::
DEBUG - 2023-10-25 14:54:43 --> 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 (320, 'Phlebitis', 'yes', '2023-10-25', 'right arm', '', 'no', '116290057', '2023-10-25', '6', '2023-10-25')
DEBUG - 2023-10-25 14:54:43 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:43 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:43 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:43 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 14:54:43 --> Total execution time: 0.0140
DEBUG - 2023-10-25 14:54:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:51 --> check_Mr_Number
DEBUG - 2023-10-25 14:54:51 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116032000'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:54:51 --> Total execution time: 0.0082
DEBUG - 2023-10-25 14:54:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:56 --> get_ward_list ::
DEBUG - 2023-10-25 14:54:56 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '7'
DEBUG - 2023-10-25 14:54:56 --> Total execution time: 0.0084
DEBUG - 2023-10-25 14:54:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:57 --> get_ward_list ::
DEBUG - 2023-10-25 14:54:57 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '3'
DEBUG - 2023-10-25 14:54:57 --> Total execution time: 0.0120
DEBUG - 2023-10-25 14:54:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:57 --> get_ward_list ::
DEBUG - 2023-10-25 14:54:57 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '8'
DEBUG - 2023-10-25 14:54:57 --> Total execution time: 0.0074
DEBUG - 2023-10-25 14:54:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:57 --> get_ward_list ::
DEBUG - 2023-10-25 14:54:57 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '10'
DEBUG - 2023-10-25 14:54:57 --> Total execution time: 0.0070
DEBUG - 2023-10-25 14:54:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:57 --> get_ward_list ::
DEBUG - 2023-10-25 14:54:57 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '11'
DEBUG - 2023-10-25 14:54:57 --> Total execution time: 0.0065
DEBUG - 2023-10-25 14:54:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:54:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:54:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:54:58 --> get_ward_list ::
DEBUG - 2023-10-25 14:54:58 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 14:54:58 --> Total execution time: 0.0071
DEBUG - 2023-10-25 14:56:59 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:56:59 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:56:59 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:56:59 --> check_Mr_Number
DEBUG - 2023-10-25 14:56:59 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116032000'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:56:59 --> Total execution time: 0.0453
DEBUG - 2023-10-25 14:57:29 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:57:29 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:57:29 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:57:29 --> check_Mr_Number
DEBUG - 2023-10-25 14:57:29 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116032000'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 14:57:29 --> Total execution time: 0.0102
DEBUG - 2023-10-25 14:58:12 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:58:12 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:58:12 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:58:12 --> Infection Form ::
DEBUG - 2023-10-25 14:58:12 --> 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 ('116032000', 'mustafa', '9', '342', 'tbm', '0', '2023-10-24', '2023-10-25', '', '', '98', 'no', '86', 'no', '116/73', 'no', 'high', '34', '', '6', '2023-10-25', '2023-10-25 02:58:12')
DEBUG - 2023-10-25 14:58:12 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:58:12 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:58:12 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:58:12 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 14:58:12 --> Total execution time: 0.0145
DEBUG - 2023-10-25 14:58:27 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 14:58:27 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 14:58:27 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 14:58:27 --> 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-25 14:58:27 --> Total execution time: 0.0129
DEBUG - 2023-10-25 15:00:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:00:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:00:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:00:48 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `mr_no` = '116260674'
DEBUG - 2023-10-25 15:00:48 --> Total execution time: 0.1206
DEBUG - 2023-10-25 15:00:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:00:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:00:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:00:52 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `form_id` = '281'
DEBUG - 2023-10-25 15:00:52 --> SELECT *
FROM `ic_culture_report`
WHERE `form_id` = '281'
DEBUG - 2023-10-25 15:00:52 --> Total execution time: 0.0473
DEBUG - 2023-10-25 15:01:02 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:01:02 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:01:02 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:01:02 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 15:01:02 --> Total execution time: 0.0953
DEBUG - 2023-10-25 15:01:04 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:01:04 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:01:04 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:01:04 --> 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-25 15:01:04 --> Total execution time: 0.0120
DEBUG - 2023-10-25 15:01:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:01:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:01:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:01:57 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `mr_no` = '116260674'
DEBUG - 2023-10-25 15:01:57 --> Total execution time: 0.0118
DEBUG - 2023-10-25 15:02:03 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:02:03 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:02:03 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:02:03 --> SELECT *
FROM `ic_surveillance_form`
WHERE `form_status` = 1
AND `form_id` = '281'
DEBUG - 2023-10-25 15:02:03 --> SELECT *
FROM `ic_culture_report`
WHERE `form_id` = '281'
DEBUG - 2023-10-25 15:02:03 --> Total execution time: 0.0139
DEBUG - 2023-10-25 15:02:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:02:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:02:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:02:11 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 15:02:11 --> Total execution time: 0.0185
DEBUG - 2023-10-25 15:02:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:02:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:02:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:02:15 --> check_Mr_Number
DEBUG - 2023-10-25 15:02:15 --> SELECT *
FROM `ic_surveillance_form`
WHERE `mr_no` = '116260674'
ORDER BY `form_id` DESC
 LIMIT 1
DEBUG - 2023-10-25 15:02:15 --> Total execution time: 0.0073
DEBUG - 2023-10-25 15:02:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:02:15 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:02:15 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:02:15 --> get_ward_list ::
DEBUG - 2023-10-25 15:02:15 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '9'
DEBUG - 2023-10-25 15:02:15 --> Total execution time: 0.0090
DEBUG - 2023-10-25 15:02:35 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:02:35 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:02:35 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:02:35 --> 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-25 15:02:35 --> Total execution time: 0.0223
DEBUG - 2023-10-25 15:03:12 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:03:12 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:03:12 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:03:12 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 15:03:12 --> Total execution time: 0.0304
DEBUG - 2023-10-25 15:03:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:03:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:03:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:03:21 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 15:03:21 --> Total execution time: 0.0128
DEBUG - 2023-10-25 15:05:23 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:05:23 --> No URI present. Default controller set.
DEBUG - 2023-10-25 15:05:23 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:05:23 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:05:23 --> Total execution time: 0.0464
DEBUG - 2023-10-25 15:57:05 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:57:05 --> No URI present. Default controller set.
DEBUG - 2023-10-25 15:57:05 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:57:05 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:57:05 --> Total execution time: 0.0502
DEBUG - 2023-10-25 15:57:07 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 15:57:07 --> No URI present. Default controller set.
DEBUG - 2023-10-25 15:57:07 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 15:57:07 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 15:57:07 --> Total execution time: 0.0058
DEBUG - 2023-10-25 16:04:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 16:04:57 --> No URI present. Default controller set.
DEBUG - 2023-10-25 16:04:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 16:04:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 16:04:57 --> Total execution time: 0.0482
DEBUG - 2023-10-25 16:11:36 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 16:11:36 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 16:11:36 --> 404 Page Not Found: Aws/credentials
DEBUG - 2023-10-25 17:04:08 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 17:04:08 --> No URI present. Default controller set.
DEBUG - 2023-10-25 17:04:08 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 17:04:08 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 17:04:08 --> Total execution time: 0.0519
DEBUG - 2023-10-25 17:40:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 17:40:17 --> No URI present. Default controller set.
DEBUG - 2023-10-25 17:40:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 17:40:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 17:40:17 --> Total execution time: 0.0494
DEBUG - 2023-10-25 18:04:12 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:04:12 --> No URI present. Default controller set.
DEBUG - 2023-10-25 18:04:12 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:04:12 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:04:12 --> Total execution time: 0.0556
DEBUG - 2023-10-25 18:17:54 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:17:54 --> No URI present. Default controller set.
DEBUG - 2023-10-25 18:17:54 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:17:54 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:17:54 --> Total execution time: 0.0452
DEBUG - 2023-10-25 18:27:14 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:27:14 --> No URI present. Default controller set.
DEBUG - 2023-10-25 18:27:14 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:27:14 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:27:14 --> Total execution time: 0.0435
DEBUG - 2023-10-25 18:27:15 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:27:15 --> Global POST, GET and COOKIE data sanitized
ERROR - 2023-10-25 18:27:15 --> 404 Page Not Found: Img/svg
DEBUG - 2023-10-25 18:27:17 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:27:17 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:27:17 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:27:17 --> 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-25 18:27:17 --> SESSION VALUE :: ICADMIN
DEBUG - 2023-10-25 18:27:18 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:27:18 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:27:18 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:27:18 --> start date: none
DEBUG - 2023-10-25 18:27:18 --> 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-25 18:27:18 --> start date: none
DEBUG - 2023-10-25 18:27:18 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 18:27:18 --> 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-25 18:27:18 --> Total execution time: 0.1618
DEBUG - 2023-10-25 18:27:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:27:21 --> No URI present. Default controller set.
DEBUG - 2023-10-25 18:27:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:27:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:27:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:27:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:27:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:27:21 --> start date: none
DEBUG - 2023-10-25 18:27: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-25 18:27:21 --> start date: none
DEBUG - 2023-10-25 18:27:21 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 18:27: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-25 18:27:21 --> Total execution time: 0.1180
DEBUG - 2023-10-25 18:34:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:34:28 --> No URI present. Default controller set.
DEBUG - 2023-10-25 18:34:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:34:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:34:29 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:34:29 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:34:29 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:34:29 --> start date: none
DEBUG - 2023-10-25 18:34:29 --> 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-25 18:34:29 --> start date: none
DEBUG - 2023-10-25 18:34:29 --> SELECT *
FROM `ic_surveillance_form` `sf`
INNER JOIN `ic_culture_report` `cr` ON `cr`.`form_id` = `sf`.`form_id`
DEBUG - 2023-10-25 18:34:29 --> 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-25 18:34:29 --> Total execution time: 0.1387
DEBUG - 2023-10-25 18:36:41 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:36:41 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:36:41 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:36:41 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 18:36:41 --> Total execution time: 0.0561
DEBUG - 2023-10-25 18:36:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:36:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:36:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:36:46 --> get_ward_list ::
DEBUG - 2023-10-25 18:36:46 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '7'
DEBUG - 2023-10-25 18:36:46 --> Total execution time: 0.1272
DEBUG - 2023-10-25 18:36:51 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:36:51 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:36:51 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:36:51 --> get_ward_list ::
DEBUG - 2023-10-25 18:36:51 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '8'
DEBUG - 2023-10-25 18:36:51 --> Total execution time: 0.0570
DEBUG - 2023-10-25 18:36:56 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:36:56 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:36:56 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:36:56 --> get_ward_list ::
DEBUG - 2023-10-25 18:36:56 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '3'
DEBUG - 2023-10-25 18:36:56 --> Total execution time: 0.0584
DEBUG - 2023-10-25 18:37:01 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:37:01 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:37:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:37:01 --> get_ward_list ::
DEBUG - 2023-10-25 18:37:01 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '8'
DEBUG - 2023-10-25 18:37:01 --> Total execution time: 0.0580
DEBUG - 2023-10-25 18:38:57 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:38:57 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:38:57 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:38:57 --> SELECT *
FROM `ic_ward`
INNER JOIN `ic_bed` ON `ic_bed`.`ward_no`=`ic_ward`.`ward_id`
WHERE `ic_bed`.`bed_status` = 1
DEBUG - 2023-10-25 18:38:57 --> Total execution time: 0.0475
DEBUG - 2023-10-25 18:39:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:00 --> SELECT *
FROM `ic_ward`
WHERE `ward_status` = 1
DEBUG - 2023-10-25 18:39:00 --> Total execution time: 0.0060
DEBUG - 2023-10-25 18:39:10 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:10 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:10 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:11 --> INSERT INTO `ic_bed` (`ward_no`, `bed_no`, `bed_creation`, `bed_status`) VALUES ('1', '111', '2023-10-25', 1)
DEBUG - 2023-10-25 18:39:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:11 --> SELECT *
FROM `ic_ward`
INNER JOIN `ic_bed` ON `ic_bed`.`ward_no`=`ic_ward`.`ward_id`
WHERE `ic_bed`.`bed_status` = 1
DEBUG - 2023-10-25 18:39:11 --> Total execution time: 0.0579
DEBUG - 2023-10-25 18:39:18 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:18 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:18 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:18 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 18:39:18 --> Total execution time: 0.0212
DEBUG - 2023-10-25 18:39:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:21 --> get_ward_list ::
DEBUG - 2023-10-25 18:39:21 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '1'
DEBUG - 2023-10-25 18:39:21 --> Total execution time: 0.0062
DEBUG - 2023-10-25 18:39:28 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:28 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:28 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:28 --> SELECT *
FROM `ic_ward`
INNER JOIN `ic_bed` ON `ic_bed`.`ward_no`=`ic_ward`.`ward_id`
WHERE `ic_bed`.`bed_status` = 1
DEBUG - 2023-10-25 18:39:28 --> Total execution time: 0.0093
DEBUG - 2023-10-25 18:39:46 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:46 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:46 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:46 --> SELECT *
FROM `ic_ward`
WHERE `ward_status` = 1
DEBUG - 2023-10-25 18:39:46 --> Total execution time: 0.0627
DEBUG - 2023-10-25 18:39:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:52 --> INSERT INTO `ic_bed` (`ward_no`, `bed_no`, `bed_creation`, `bed_status`) VALUES ('1', '111', '2023-10-25', 1)
DEBUG - 2023-10-25 18:39:53 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:39:53 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:39:53 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:39:53 --> SELECT *
FROM `ic_ward`
INNER JOIN `ic_bed` ON `ic_bed`.`ward_no`=`ic_ward`.`ward_id`
WHERE `ic_bed`.`bed_status` = 1
DEBUG - 2023-10-25 18:39:53 --> Total execution time: 0.0092
DEBUG - 2023-10-25 18:44:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:44:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:44:00 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:44:00 --> SELECT *
FROM `ic_ward`
WHERE `ward_status` = 1
DEBUG - 2023-10-25 18:44:00 --> Total execution time: 0.0605
DEBUG - 2023-10-25 18:44:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:44:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:44:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:44:58 --> INSERT INTO `ic_bed` (`ward_no`, `bed_no`, `bed_creation`, `bed_status`) VALUES ('13', '098', '2023-10-25', 1)
DEBUG - 2023-10-25 18:44:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:44:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:44:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:44:58 --> SELECT *
FROM `ic_ward`
INNER JOIN `ic_bed` ON `ic_bed`.`ward_no`=`ic_ward`.`ward_id`
WHERE `ic_bed`.`bed_status` = 1
DEBUG - 2023-10-25 18:44:58 --> Total execution time: 0.0090
DEBUG - 2023-10-25 18:46:48 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:46:48 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:46:48 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:46:48 --> SELECT DISTINCT `ic_ward`.`ward_id`, `ic_bed`.`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-25 18:46:48 --> Total execution time: 0.0554
DEBUG - 2023-10-25 18:46:58 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:46:58 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:46:58 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:46:58 --> get_ward_list ::
DEBUG - 2023-10-25 18:46:58 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '13'
DEBUG - 2023-10-25 18:46:58 --> Total execution time: 0.0078
DEBUG - 2023-10-25 18:52:00 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 18:52:00 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 18:52:01 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 18:52:01 --> SELECT *
FROM `ic_ward`
INNER JOIN `ic_bed` ON `ic_bed`.`ward_no`=`ic_ward`.`ward_id`
WHERE `ic_bed`.`bed_status` = 1
DEBUG - 2023-10-25 18:52:01 --> Total execution time: 0.0641
DEBUG - 2023-10-25 19:05:19 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 19:05:19 --> No URI present. Default controller set.
DEBUG - 2023-10-25 19:05:19 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 19:05:19 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 19:05:19 --> Total execution time: 0.0990
DEBUG - 2023-10-25 19:29:13 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 19:29:13 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 19:29:13 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 19:29:13 --> SELECT `w`.*, `b`.`bed_id`, `b`.`bed_no`
FROM `ic_ward` AS `w`
INNER JOIN `ic_bed` AS `b` ON `b`.`ward_no`=`w`.`ward_id`
WHERE `b`.`bed_status` = 1
DEBUG - 2023-10-25 19:29:13 --> Total execution time: 0.0827
DEBUG - 2023-10-25 19:29:21 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 19:29:21 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 19:29:21 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 19:29: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-25 19:29:21 --> Total execution time: 0.0210
DEBUG - 2023-10-25 19:29:24 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 19:29:24 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 19:29:24 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 19:29:25 --> get_ward_list ::
DEBUG - 2023-10-25 19:29:25 --> SELECT *
FROM `ic_bed`
WHERE `ward_no` = '13'
DEBUG - 2023-10-25 19:29:25 --> Total execution time: 1.2449
DEBUG - 2023-10-25 19:29:31 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 19:29:31 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 19:29:31 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 19:29:31 --> SELECT `w`.*, `b`.`bed_id`, `b`.`bed_no`
FROM `ic_ward` AS `w`
INNER JOIN `ic_bed` AS `b` ON `b`.`ward_no`=`w`.`ward_id`
WHERE `b`.`bed_status` = 1
DEBUG - 2023-10-25 19:29:31 --> Total execution time: 0.0145
DEBUG - 2023-10-25 20:05:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 20:05:52 --> No URI present. Default controller set.
DEBUG - 2023-10-25 20:05:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 20:05:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 20:05:52 --> Total execution time: 0.0812
DEBUG - 2023-10-25 21:04:50 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 21:04:50 --> No URI present. Default controller set.
DEBUG - 2023-10-25 21:04:50 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 21:04:50 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 21:04:50 --> Total execution time: 0.0409
DEBUG - 2023-10-25 22:04:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 22:04:52 --> No URI present. Default controller set.
DEBUG - 2023-10-25 22:04:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 22:04:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 22:04:52 --> Total execution time: 0.0943
DEBUG - 2023-10-25 23:05:52 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 23:05:52 --> No URI present. Default controller set.
DEBUG - 2023-10-25 23:05:52 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 23:05:52 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 23:05:52 --> Total execution time: 0.0795
DEBUG - 2023-10-25 23:08:11 --> UTF-8 Support Enabled
DEBUG - 2023-10-25 23:08:11 --> No URI present. Default controller set.
DEBUG - 2023-10-25 23:08:11 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2023-10-25 23:08:11 --> Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.
DEBUG - 2023-10-25 23:08:11 --> Total execution time: 0.0484
