[09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getConnection(): Resource id #1 [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000444789' [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getPatientReportsDetail() entered [09 Sep 2020 00:16:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:16:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:16:21] (index) p_Stop=N [09 Sep 2020 00:16:21] (index) p_Alert= [09 Sep 2020 00:16:21] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 00:16:21] (index) database connection response [09 Sep 2020 00:16:21] (index) getConnectionClose() called.... [09 Sep 2020 00:16:21] (index) getConnectionClose() called.... [09 Sep 2020 00:16:25] (viewOnlineReports) database connection response [09 Sep 2020 00:16:25] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 00:16:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:16:25] (viewOnlineReports) p_Stop=N [09 Sep 2020 00:16:25] (viewOnlineReports) p_Alert= [09 Sep 2020 00:16:25] (viewOnlineReports) Flag = 1 [09 Sep 2020 00:16:25] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '1', '001000000000085025', 'M0100000444789_M01HEM20012265_1.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 00:16:26] (viewOnlineReports) database connection response [09 Sep 2020 00:16:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 00:16:26] (viewOnlineReports) database connection response [09 Sep 2020 00:16:26] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 00:16:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 00:16:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 00:16:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:16:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599592585M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:16:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599592585M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:16:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 00:16:26] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599592585M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getConnection(): Resource id #1 [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000444789' [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getPatientReportsDetail() entered [09 Sep 2020 00:32:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:32:09] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:32:09] (index) p_Stop=N [09 Sep 2020 00:32:09] (index) p_Alert= [09 Sep 2020 00:32:09] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 00:32:09] (index) database connection response [09 Sep 2020 00:32:09] (index) getConnectionClose() called.... [09 Sep 2020 00:32:09] (index) getConnectionClose() called.... [09 Sep 2020 00:32:13] (viewOnlineReports) database connection response [09 Sep 2020 00:32:13] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 00:32:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:32:13] (viewOnlineReports) p_Stop=N [09 Sep 2020 00:32:13] (viewOnlineReports) p_Alert= [09 Sep 2020 00:32:13] (viewOnlineReports) Flag = 1 [09 Sep 2020 00:32:13] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '1', '001000000000085025', 'M0100000444789_M01HEM20012265_1.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 00:32:13] (viewOnlineReports) database connection response [09 Sep 2020 00:32:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 00:32:13] (viewOnlineReports) database connection response [09 Sep 2020 00:32:13] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 00:32:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 00:32:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 00:32:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:32:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599593533M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:32:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599593533M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:32:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 00:32:13] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599593533M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getConnection(): Resource id #1 [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000444789' [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getPatientReportsDetail() entered [09 Sep 2020 00:55:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:55:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:55:51] (index) p_Stop=N [09 Sep 2020 00:55:51] (index) p_Alert= [09 Sep 2020 00:55:51] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 00:55:51] (index) database connection response [09 Sep 2020 00:55:51] (index) getConnectionClose() called.... [09 Sep 2020 00:55:51] (index) getConnectionClose() called.... [09 Sep 2020 00:55:57] (viewOnlineReports) database connection response [09 Sep 2020 00:55:57] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 00:55:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '2', '001000000000081010', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:55:57] (viewOnlineReports) p_Stop=N [09 Sep 2020 00:55:57] (viewOnlineReports) p_Alert= [09 Sep 2020 00:55:57] (viewOnlineReports) Flag = 1 [09 Sep 2020 00:55:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '2', '001000000000081010', 'M0100000444789_M01RCH20016581_2.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 00:55:57] (viewOnlineReports) database connection response [09 Sep 2020 00:55:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 00:55:57] (viewOnlineReports) database connection response [09 Sep 2020 00:55:57] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 00:55:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 00:55:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 00:55:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:55:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599594957M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:55:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599594957M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:55:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 00:55:57] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599594957M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:56:05] (viewOnlineReports) database connection response [09 Sep 2020 00:56:05] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 00:56:05] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '5', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:56:05] (viewOnlineReports) p_Stop=N [09 Sep 2020 00:56:05] (viewOnlineReports) p_Alert= [09 Sep 2020 00:56:05] (viewOnlineReports) Flag = 1 [09 Sep 2020 00:56:05] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '5', '001000000000084460', 'M0100000444789_M01RCH20016581_3.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 00:56:05] (viewOnlineReports) database connection response [09 Sep 2020 00:56:05] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [09 Sep 2020 00:56:05] (viewOnlineReports) database connection response [09 Sep 2020 00:56:05] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 00:56:05] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 00:56:05] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 00:56:05] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01RCH20016581_3.PDF [09 Sep 2020 00:56:05] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599594965M0100000444789_M01RCH20016581_3.PDF [09 Sep 2020 00:56:05] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599594965M0100000444789_M01RCH20016581_3.PDF [09 Sep 2020 00:56:05] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 00:56:05] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599594965M0100000444789_M01RCH20016581_3.PDF [09 Sep 2020 00:56:11] (viewOnlineReports) database connection response [09 Sep 2020 00:56:11] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 00:56:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '2', '001000000000081010', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:56:11] (viewOnlineReports) p_Stop=N [09 Sep 2020 00:56:11] (viewOnlineReports) p_Alert= [09 Sep 2020 00:56:11] (viewOnlineReports) Flag = 1 [09 Sep 2020 00:56:11] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '2', '001000000000081010', 'M0100000444789_M01RCH20016581_2.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 00:56:11] (viewOnlineReports) database connection response [09 Sep 2020 00:56:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 00:56:11] (viewOnlineReports) database connection response [09 Sep 2020 00:56:11] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 00:56:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 00:56:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 00:56:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:56:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599594971M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:56:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599594971M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:56:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 00:56:11] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599594971M0100000444789_M01RCH20016581_2.PDF [09 Sep 2020 00:56:15] (viewOnlineReports) database connection response [09 Sep 2020 00:56:15] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 00:56:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 00:56:15] (viewOnlineReports) p_Stop=N [09 Sep 2020 00:56:15] (viewOnlineReports) p_Alert= [09 Sep 2020 00:56:15] (viewOnlineReports) Flag = 1 [09 Sep 2020 00:56:15] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '1', '001000000000085025', 'M0100000444789_M01HEM20012265_1.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 00:56:15] (viewOnlineReports) database connection response [09 Sep 2020 00:56:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 00:56:15] (viewOnlineReports) database connection response [09 Sep 2020 00:56:15] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 00:56:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 00:56:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 00:56:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:56:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599594975M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:56:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599594975M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 00:56:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 00:56:15] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599594975M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getConnection(): Resource id #1 [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369947' AND ACCESS_CODE = '07981108' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000444789' [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getPatientReportsDetail() entered [09 Sep 2020 01:46:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 01:46:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369947', 'M0100000444789', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 01:46:58] (index) p_Stop=N [09 Sep 2020 01:46:58] (index) p_Alert= [09 Sep 2020 01:46:58] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 01:46:58] (index) database connection response [09 Sep 2020 01:46:58] (index) getConnectionClose() called.... [09 Sep 2020 01:46:58] (index) getConnectionClose() called.... [09 Sep 2020 01:47:09] (viewOnlineReports) database connection response [09 Sep 2020 01:47:09] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 01:47:09] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000444789', '001', '200382025', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 01:47:09] (viewOnlineReports) p_Stop=N [09 Sep 2020 01:47:09] (viewOnlineReports) p_Alert= [09 Sep 2020 01:47:09] (viewOnlineReports) Flag = 1 [09 Sep 2020 01:47:09] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382025', 'M01', '047', '1', '001000000000085025', 'M0100000444789_M01HEM20012265_1.PDF', 'M0100000444789', SYSDATE) [09 Sep 2020 01:47:09] (viewOnlineReports) database connection response [09 Sep 2020 01:47:09] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382025' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 01:47:09] (viewOnlineReports) database connection response [09 Sep 2020 01:47:09] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 01:47:09] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382025/ [09 Sep 2020 01:47:09] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382025/ [09 Sep 2020 01:47:09] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 01:47:09] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382025/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599598029M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 01:47:09] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382025/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599598029M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 01:47:09] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 01:47:09] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382025/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599598029M0100000444789_M01HEM20012265_1.PDF [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getConnection(): Resource id #1 [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369167' AND ACCESS_CODE = '46801160' [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369167' AND ACCESS_CODE = '46801160' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000632332' [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getPatientReportsDetail() entered [09 Sep 2020 03:46:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369167', 'M0100000632332', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 03:46:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369167', 'M0100000632332', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 03:46:45] (index) p_Stop=N [09 Sep 2020 03:46:45] (index) p_Alert= [09 Sep 2020 03:46:45] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 03:46:45] (index) database connection response [09 Sep 2020 03:46:45] (index) getConnectionClose() called.... [09 Sep 2020 03:46:45] (index) getConnectionClose() called.... [09 Sep 2020 03:47:18] (viewOnlineReports) database connection response [09 Sep 2020 03:47:18] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 03:47:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000632332', '001', '200381708', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 03:47:18] (viewOnlineReports) p_Stop=N [09 Sep 2020 03:47:18] (viewOnlineReports) p_Alert= [09 Sep 2020 03:47:18] (viewOnlineReports) Flag = 1 [09 Sep 2020 03:47:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381708', 'M01', '070', '1', '001000000000087630', 'M0100000632332_M01MOL20007581_1.PDF', 'M0100000632332', SYSDATE) [09 Sep 2020 03:47:18] (viewOnlineReports) database connection response [09 Sep 2020 03:47:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381708' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Sep 2020 03:47:18] (viewOnlineReports) database connection response [09 Sep 2020 03:47:18] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 03:47:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381708/ [09 Sep 2020 03:47:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381708/ [09 Sep 2020 03:47:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381708/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605238M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381708/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605238M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 03:47:18] (viewOnlineReports) Converting PDF to JPG with name as M0100000632332_M01MOL20007581_1.jpg [09 Sep 2020 03:47:18] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200381708/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605238M0100000632332_M01MOL20007581_1.PDF ../../TEMP_PDF/200381708/M0100000632332_M01MOL20007581_1.jpg [09 Sep 2020 03:47:18] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200381708/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605238M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:40] (viewOnlineReports) database connection response [09 Sep 2020 03:47:40] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 03:47:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000632332', '001', '200381708', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 03:47:40] (viewOnlineReports) p_Stop=N [09 Sep 2020 03:47:40] (viewOnlineReports) p_Alert= [09 Sep 2020 03:47:40] (viewOnlineReports) Flag = 1 [09 Sep 2020 03:47:40] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381708', 'M01', '070', '1', '001000000000087630', 'M0100000632332_M01MOL20007581_1.PDF', 'M0100000632332', SYSDATE) [09 Sep 2020 03:47:40] (viewOnlineReports) database connection response [09 Sep 2020 03:47:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381708' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Sep 2020 03:47:40] (viewOnlineReports) database connection response [09 Sep 2020 03:47:40] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 03:47:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381708/ [09 Sep 2020 03:47:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381708/ [09 Sep 2020 03:47:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381708/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599605260M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381708/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599605260M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 03:47:40] (viewOnlineReports) Converting PDF to JPG with name as M0100000632332_M01MOL20007581_1.jpg [09 Sep 2020 03:47:40] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200381708/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599605260M0100000632332_M01MOL20007581_1.PDF ../../TEMP_PDF/200381708/M0100000632332_M01MOL20007581_1.jpg [09 Sep 2020 03:47:40] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200381708/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599605260M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:53] (viewOnlineReports) database connection response [09 Sep 2020 03:47:53] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 03:47:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000632332', '001', '200381708', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 03:47:53] (viewOnlineReports) p_Stop=N [09 Sep 2020 03:47:53] (viewOnlineReports) p_Alert= [09 Sep 2020 03:47:53] (viewOnlineReports) Flag = 1 [09 Sep 2020 03:47:53] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381708', 'M01', '070', '1', '001000000000087630', 'M0100000632332_M01MOL20007581_1.PDF', 'M0100000632332', SYSDATE) [09 Sep 2020 03:47:53] (viewOnlineReports) database connection response [09 Sep 2020 03:47:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381708' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Sep 2020 03:47:53] (viewOnlineReports) database connection response [09 Sep 2020 03:47:53] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 03:47:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381708/ [09 Sep 2020 03:47:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381708/ [09 Sep 2020 03:47:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381708/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605273M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381708/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605273M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 03:47:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 03:47:53] (viewOnlineReports) Downloading file ../../TEMP_PDF/200381708/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599605273M0100000632332_M01MOL20007581_1.PDF [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getConnection(): Resource id #1 [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200368454' AND ACCESS_CODE = '37966820' [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200368454' AND ACCESS_CODE = '37966820' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000066089' [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getPatientReportsDetail() entered [09 Sep 2020 09:03:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200368454', 'M0100000066089', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 09:03:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200368454', 'M0100000066089', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 09:03:10] (index) p_Stop=N [09 Sep 2020 09:03:10] (index) p_Alert= [09 Sep 2020 09:03:10] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 09:03:10] (index) database connection response [09 Sep 2020 09:03:10] (index) getConnectionClose() called.... [09 Sep 2020 09:03:10] (index) getConnectionClose() called.... [09 Sep 2020 09:03:19] (viewOnlineReports) database connection response [09 Sep 2020 09:03:19] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 09:03:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000066089', '001', '200381571', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 09:03:19] (viewOnlineReports) p_Stop=N [09 Sep 2020 09:03:19] (viewOnlineReports) p_Alert= [09 Sep 2020 09:03:19] (viewOnlineReports) Flag = 1 [09 Sep 2020 09:03:19] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381571', 'M01', '047', '2', '001000000000085025', 'M0100000066089_M01HEM20012211_1.PDF', 'M0100000066089', SYSDATE) [09 Sep 2020 09:03:19] (viewOnlineReports) database connection response [09 Sep 2020 09:03:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381571' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 09:03:19] (viewOnlineReports) database connection response [09 Sep 2020 09:03:19] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 09:03:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381571/ [09 Sep 2020 09:03:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381571/ [09 Sep 2020 09:03:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000066089_M01HEM20012211_1.PDF [09 Sep 2020 09:03:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381571/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599624199M0100000066089_M01HEM20012211_1.PDF [09 Sep 2020 09:03:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381571/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599624199M0100000066089_M01HEM20012211_1.PDF [09 Sep 2020 09:03:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 09:03:19] (viewOnlineReports) Converting PDF to JPG with name as M0100000066089_M01HEM20012211_1.jpg [09 Sep 2020 09:03:19] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200381571/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599624199M0100000066089_M01HEM20012211_1.PDF ../../TEMP_PDF/200381571/M0100000066089_M01HEM20012211_1.jpg [09 Sep 2020 09:03:20] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200381571/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599624199M0100000066089_M01HEM20012211_1.PDF [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getConnection(): Resource id #1 [09 Sep 2020 11:52:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000564519' [09 Sep 2020 11:52:57] (index) database connection response [09 Sep 2020 11:52:57] (index) getPatientReportsDetail() entered [09 Sep 2020 11:52:57] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 11:52:58] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 11:52:58] (index) p_Stop=N [09 Sep 2020 11:52:58] (index) p_Alert= [09 Sep 2020 11:52:58] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 11:52:58] (index) database connection response [09 Sep 2020 11:52:58] (index) getConnectionClose() called.... [09 Sep 2020 11:52:58] (index) getConnectionClose() called.... [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getConnection(): Resource id #1 [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365038' AND ACCESS_CODE = '16364161' [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200365038' AND ACCESS_CODE = '16364161' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000632059' [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getPatientReportsDetail() entered [09 Sep 2020 12:49:52] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365038', 'M0100000632059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:49:52] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200365038', 'M0100000632059', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:49:52] (index) p_Stop=N [09 Sep 2020 12:49:52] (index) p_Alert= [09 Sep 2020 12:49:52] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 12:49:52] (index) database connection response [09 Sep 2020 12:49:52] (index) getConnectionClose() called.... [09 Sep 2020 12:49:52] (index) getConnectionClose() called.... [09 Sep 2020 12:50:28] (viewOnlineReports) database connection response [09 Sep 2020 12:50:28] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 12:50:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632059', '001', '200380556', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:50:28] (viewOnlineReports) p_Stop=N [09 Sep 2020 12:50:28] (viewOnlineReports) p_Alert= [09 Sep 2020 12:50:28] (viewOnlineReports) Flag = 1 [09 Sep 2020 12:50:28] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380556', 'M01', '047', '2', '001000000000087086', 'M0100000632059_M01MIC20006499_1.PDF', 'M0100000632059', SYSDATE) [09 Sep 2020 12:50:28] (viewOnlineReports) database connection response [09 Sep 2020 12:50:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380556' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 12:50:28] (viewOnlineReports) database connection response [09 Sep 2020 12:50:28] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 12:50:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380556/ [09 Sep 2020 12:50:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380556/ [09 Sep 2020 12:50:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200907\M01\M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599637828M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599637828M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 12:50:28] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1599637828M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:37] (viewOnlineReports) database connection response [09 Sep 2020 12:50:37] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 12:50:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632059', '001', '200380556', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:50:37] (viewOnlineReports) p_Stop=N [09 Sep 2020 12:50:37] (viewOnlineReports) p_Alert= [09 Sep 2020 12:50:37] (viewOnlineReports) Flag = 1 [09 Sep 2020 12:50:37] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380556', 'M01', '047', '2', '001000000000087086', 'M0100000632059_M01MIC20006499_1.PDF', 'M0100000632059', SYSDATE) [09 Sep 2020 12:50:37] (viewOnlineReports) database connection response [09 Sep 2020 12:50:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380556' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 12:50:37] (viewOnlineReports) database connection response [09 Sep 2020 12:50:37] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 12:50:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380556/ [09 Sep 2020 12:50:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380556/ [09 Sep 2020 12:50:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200907\M01\M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599637837M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599637837M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:50:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Sep 2020 12:50:37] (viewOnlineReports) Converting PDF to JPG with name as M0100000632059_M01MIC20006499_1.jpg [09 Sep 2020 12:50:37] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599637837M0100000632059_M01MIC20006499_1.PDF ../../TEMP_PDF/200380556/M0100000632059_M01MIC20006499_1.jpg [09 Sep 2020 12:50:37] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599637837M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:04] (viewOnlineReports) database connection response [09 Sep 2020 12:51:04] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 12:51:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632059', '001', '200380556', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:51:04] (viewOnlineReports) p_Stop=N [09 Sep 2020 12:51:04] (viewOnlineReports) p_Alert= [09 Sep 2020 12:51:04] (viewOnlineReports) Flag = 1 [09 Sep 2020 12:51:04] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380556', 'M01', '047', '2', '001000000000087086', 'M0100000632059_M01MIC20006499_1.PDF', 'M0100000632059', SYSDATE) [09 Sep 2020 12:51:04] (viewOnlineReports) database connection response [09 Sep 2020 12:51:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380556' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 12:51:04] (viewOnlineReports) database connection response [09 Sep 2020 12:51:04] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 12:51:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380556/ [09 Sep 2020 12:51:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380556/ [09 Sep 2020 12:51:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200907\M01\M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380556/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599637864M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380556/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599637864M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 12:51:04] (viewOnlineReports) Converting PDF to JPG with name as M0100000632059_M01MIC20006499_1.jpg [09 Sep 2020 12:51:04] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380556/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599637864M0100000632059_M01MIC20006499_1.PDF ../../TEMP_PDF/200380556/M0100000632059_M01MIC20006499_1.jpg [09 Sep 2020 12:51:04] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380556/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599637864M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:26] (viewOnlineReports) database connection response [09 Sep 2020 12:51:26] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 12:51:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632059', '001', '200380556', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:51:26] (viewOnlineReports) p_Stop=N [09 Sep 2020 12:51:26] (viewOnlineReports) p_Alert= [09 Sep 2020 12:51:26] (viewOnlineReports) Flag = 1 [09 Sep 2020 12:51:26] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380556', 'M01', '047', '2', '001000000000087086', 'M0100000632059_M01MIC20006499_1.PDF', 'M0100000632059', SYSDATE) [09 Sep 2020 12:51:26] (viewOnlineReports) database connection response [09 Sep 2020 12:51:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380556' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 12:51:26] (viewOnlineReports) database connection response [09 Sep 2020 12:51:26] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 12:51:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380556/ [09 Sep 2020 12:51:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380556/ [09 Sep 2020 12:51:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200907\M01\M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599637886M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599637886M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 12:51:26] (viewOnlineReports) Converting PDF to JPG with name as M0100000632059_M01MIC20006499_1.jpg [09 Sep 2020 12:51:26] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599637886M0100000632059_M01MIC20006499_1.PDF ../../TEMP_PDF/200380556/M0100000632059_M01MIC20006499_1.jpg [09 Sep 2020 12:51:26] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599637886M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:37] (viewOnlineReports) database connection response [09 Sep 2020 12:51:37] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 12:51:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632059', '001', '200380556', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:51:37] (viewOnlineReports) p_Stop=N [09 Sep 2020 12:51:37] (viewOnlineReports) p_Alert= [09 Sep 2020 12:51:37] (viewOnlineReports) Flag = 1 [09 Sep 2020 12:51:37] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380556', 'M01', '047', '2', '001000000000087086', 'M0100000632059_M01MIC20006499_1.PDF', 'M0100000632059', SYSDATE) [09 Sep 2020 12:51:37] (viewOnlineReports) database connection response [09 Sep 2020 12:51:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380556' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 12:51:37] (viewOnlineReports) database connection response [09 Sep 2020 12:51:37] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 12:51:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380556/ [09 Sep 2020 12:51:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380556/ [09 Sep 2020 12:51:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200907\M01\M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599637897M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599637897M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:51:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 12:51:37] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599637897M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:53:22] (viewOnlineReports) database connection response [09 Sep 2020 12:53:22] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 12:53:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000632059', '001', '200380556', '2', '001000000000087086', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 12:53:22] (viewOnlineReports) p_Stop=N [09 Sep 2020 12:53:22] (viewOnlineReports) p_Alert= [09 Sep 2020 12:53:22] (viewOnlineReports) Flag = 1 [09 Sep 2020 12:53:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380556', 'M01', '047', '2', '001000000000087086', 'M0100000632059_M01MIC20006499_1.PDF', 'M0100000632059', SYSDATE) [09 Sep 2020 12:53:22] (viewOnlineReports) database connection response [09 Sep 2020 12:53:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380556' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Sep 2020 12:53:22] (viewOnlineReports) database connection response [09 Sep 2020 12:53:22] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 12:53:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380556/ [09 Sep 2020 12:53:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380556/ [09 Sep 2020 12:53:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200907\M01\M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:53:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599638002M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:53:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599638002M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 12:53:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 12:53:22] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380556/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599638002M0100000632059_M01MIC20006499_1.PDF [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getConnection(): Resource id #1 [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364752' AND ACCESS_CODE = '15253441' [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200364752' AND ACCESS_CODE = '15253441' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000104585' [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getPatientReportsDetail() entered [09 Sep 2020 13:09:33] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364752', 'M0100000104585', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 13:09:33] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200364752', 'M0100000104585', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 13:09:33] (index) p_Stop=N [09 Sep 2020 13:09:33] (index) p_Alert= [09 Sep 2020 13:09:33] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 13:09:33] (index) database connection response [09 Sep 2020 13:09:33] (index) getConnectionClose() called.... [09 Sep 2020 13:09:33] (index) getConnectionClose() called.... [09 Sep 2020 13:09:54] (viewOnlineReports) database connection response [09 Sep 2020 13:09:54] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 13:09:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000104585', '001', '200380435', '1', '001000000000087071', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 13:09:54] (viewOnlineReports) p_Stop=N [09 Sep 2020 13:09:54] (viewOnlineReports) p_Alert= [09 Sep 2020 13:09:54] (viewOnlineReports) Flag = 1 [09 Sep 2020 13:09:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380435', 'M01', '047', '1', '001000000000087071', 'M0100000104585_M01MIC20006490_1.PDF', 'M0100000104585', SYSDATE) [09 Sep 2020 13:09:54] (viewOnlineReports) database connection response [09 Sep 2020 13:09:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380435' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 13:09:54] (viewOnlineReports) database connection response [09 Sep 2020 13:09:54] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 13:09:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380435/ [09 Sep 2020 13:09:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380435/ [09 Sep 2020 13:09:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:09:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380435/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599638994M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:09:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380435/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599638994M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:09:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 13:09:55] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380435/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599638994M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:19] (viewOnlineReports) database connection response [09 Sep 2020 13:10:19] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 13:10:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000104585', '001', '200380435', '1', '001000000000087071', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 13:10:19] (viewOnlineReports) p_Stop=N [09 Sep 2020 13:10:19] (viewOnlineReports) p_Alert= [09 Sep 2020 13:10:19] (viewOnlineReports) Flag = 1 [09 Sep 2020 13:10:19] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380435', 'M01', '047', '1', '001000000000087071', 'M0100000104585_M01MIC20006490_1.PDF', 'M0100000104585', SYSDATE) [09 Sep 2020 13:10:19] (viewOnlineReports) database connection response [09 Sep 2020 13:10:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380435' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 13:10:19] (viewOnlineReports) database connection response [09 Sep 2020 13:10:19] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 13:10:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380435/ [09 Sep 2020 13:10:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380435/ [09 Sep 2020 13:10:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599639019M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599639019M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Sep 2020 13:10:19] (viewOnlineReports) Converting PDF to JPG with name as M0100000104585_M01MIC20006490_1.jpg [09 Sep 2020 13:10:19] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599639019M0100000104585_M01MIC20006490_1.PDF ../../TEMP_PDF/200380435/M0100000104585_M01MIC20006490_1.jpg [09 Sep 2020 13:10:19] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599639019M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:34] (viewOnlineReports) database connection response [09 Sep 2020 13:10:34] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 13:10:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000104585', '001', '200380435', '1', '001000000000087071', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 13:10:34] (viewOnlineReports) p_Stop=N [09 Sep 2020 13:10:34] (viewOnlineReports) p_Alert= [09 Sep 2020 13:10:34] (viewOnlineReports) Flag = 1 [09 Sep 2020 13:10:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380435', 'M01', '047', '1', '001000000000087071', 'M0100000104585_M01MIC20006490_1.PDF', 'M0100000104585', SYSDATE) [09 Sep 2020 13:10:34] (viewOnlineReports) database connection response [09 Sep 2020 13:10:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380435' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 13:10:34] (viewOnlineReports) database connection response [09 Sep 2020 13:10:34] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 13:10:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380435/ [09 Sep 2020 13:10:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380435/ [09 Sep 2020 13:10:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599639034M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599639034M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:10:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 13:10:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200380435/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599639034M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:29:50] (viewOnlineReports) database connection response [09 Sep 2020 13:29:50] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 13:29:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000104585', '001', '200380435', '1', '001000000000087071', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 13:29:50] (viewOnlineReports) p_Stop=N [09 Sep 2020 13:29:50] (viewOnlineReports) p_Alert= [09 Sep 2020 13:29:50] (viewOnlineReports) Flag = 1 [09 Sep 2020 13:29:50] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200380435', 'M01', '047', '1', '001000000000087071', 'M0100000104585_M01MIC20006490_1.PDF', 'M0100000104585', SYSDATE) [09 Sep 2020 13:29:50] (viewOnlineReports) database connection response [09 Sep 2020 13:29:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200380435' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 13:29:50] (viewOnlineReports) database connection response [09 Sep 2020 13:29:50] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 13:29:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200380435/ [09 Sep 2020 13:29:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200380435/ [09 Sep 2020 13:29:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:29:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200380435/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599640190M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:29:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200380435/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599640190M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 13:29:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 13:29:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200380435/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599640190M0100000104585_M01MIC20006490_1.PDF [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getConnection(): Resource id #1 [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200371406' AND ACCESS_CODE = '44297224' [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200371406' AND ACCESS_CODE = '44297224' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000607617' [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getPatientReportsDetail() entered [09 Sep 2020 14:55:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200371406', 'M0100000607617', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:55:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200371406', 'M0100000607617', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:55:14] (index) p_Stop=N [09 Sep 2020 14:55:14] (index) p_Alert= [09 Sep 2020 14:55:14] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 14:55:14] (index) database connection response [09 Sep 2020 14:55:14] (index) getConnectionClose() called.... [09 Sep 2020 14:55:14] (index) getConnectionClose() called.... [09 Sep 2020 14:55:26] (viewOnlineReports) database connection response [09 Sep 2020 14:55:26] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 14:55:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000607617', '001', '200382480', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:55:26] (viewOnlineReports) p_Stop=N [09 Sep 2020 14:55:26] (viewOnlineReports) p_Alert= [09 Sep 2020 14:55:26] (viewOnlineReports) Flag = 1 [09 Sep 2020 14:55:26] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382480', 'M01', '047', '1', '001000000000087100', 'M0100000607617_M01MIC20006650_1.PDF', 'M0100000607617', SYSDATE) [09 Sep 2020 14:55:26] (viewOnlineReports) database connection response [09 Sep 2020 14:55:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382480' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 14:55:26] (viewOnlineReports) database connection response [09 Sep 2020 14:55:26] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 14:55:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382480/ [09 Sep 2020 14:55:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382480/ [09 Sep 2020 14:55:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382480/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599645326M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382480/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599645326M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 14:55:26] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382480/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1599645326M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:35] (viewOnlineReports) database connection response [09 Sep 2020 14:55:35] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 14:55:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000607617', '001', '200382480', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:55:35] (viewOnlineReports) p_Stop=N [09 Sep 2020 14:55:35] (viewOnlineReports) p_Alert= [09 Sep 2020 14:55:35] (viewOnlineReports) Flag = 1 [09 Sep 2020 14:55:35] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382480', 'M01', '047', '1', '001000000000087100', 'M0100000607617_M01MIC20006650_1.PDF', 'M0100000607617', SYSDATE) [09 Sep 2020 14:55:35] (viewOnlineReports) database connection response [09 Sep 2020 14:55:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382480' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 14:55:35] (viewOnlineReports) database connection response [09 Sep 2020 14:55:35] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 14:55:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382480/ [09 Sep 2020 14:55:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382480/ [09 Sep 2020 14:55:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382480/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599645335M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382480/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599645335M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:55:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 14:55:35] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200382480/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599645335M0100000607617_M01MIC20006650_1.PDF [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getConnection(): Resource id #1 [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200371409' AND ACCESS_CODE = '08949257' [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200371409' AND ACCESS_CODE = '08949257' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631646' [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getPatientReportsDetail() entered [09 Sep 2020 14:58:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200371409', 'M0100000631646', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:58:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200371409', 'M0100000631646', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:58:28] (index) p_Stop=N [09 Sep 2020 14:58:28] (index) p_Alert= [09 Sep 2020 14:58:28] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 14:58:28] (index) database connection response [09 Sep 2020 14:58:28] (index) getConnectionClose() called.... [09 Sep 2020 14:58:28] (index) getConnectionClose() called.... [09 Sep 2020 14:58:33] (viewOnlineReports) database connection response [09 Sep 2020 14:58:33] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 14:58:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631646', '001', '200382482', '1', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 14:58:33] (viewOnlineReports) p_Stop=N [09 Sep 2020 14:58:33] (viewOnlineReports) p_Alert= [09 Sep 2020 14:58:33] (viewOnlineReports) Flag = 1 [09 Sep 2020 14:58:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382482', 'M01', '047', '1', '001000000000082047', 'M0100000631646_M01RCH20016637_1.PDF', 'M0100000631646', SYSDATE) [09 Sep 2020 14:58:33] (viewOnlineReports) database connection response [09 Sep 2020 14:58:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382482' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 14:58:33] (viewOnlineReports) database connection response [09 Sep 2020 14:58:33] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 14:58:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382482/ [09 Sep 2020 14:58:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382482/ [09 Sep 2020 14:58:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000631646_M01RCH20016637_1.PDF [09 Sep 2020 14:58:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382482/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599645513M0100000631646_M01RCH20016637_1.PDF [09 Sep 2020 14:58:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382482/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599645513M0100000631646_M01RCH20016637_1.PDF [09 Sep 2020 14:58:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 14:58:33] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382482/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599645513M0100000631646_M01RCH20016637_1.PDF [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getConnection(): Resource id #2 [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200370596' AND ACCESS_CODE = '05358747' [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200370596' AND ACCESS_CODE = '05358747' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631225' [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getPatientReportsDetail() entered [09 Sep 2020 18:41:52] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200370596', 'M0100000631225', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:41:52] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200370596', 'M0100000631225', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:41:52] (index) p_Stop=N [09 Sep 2020 18:41:52] (index) p_Alert= [09 Sep 2020 18:41:52] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 18:41:52] (index) database connection response [09 Sep 2020 18:41:52] (index) getConnectionClose() called.... [09 Sep 2020 18:41:52] (index) getConnectionClose() called.... [09 Sep 2020 18:42:03] (viewOnlineReports) database connection response [09 Sep 2020 18:42:03] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 18:42:03] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000631225', '001', '200382346', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:42:03] (viewOnlineReports) p_Stop=N [09 Sep 2020 18:42:03] (viewOnlineReports) p_Alert= [09 Sep 2020 18:42:03] (viewOnlineReports) Flag = 1 [09 Sep 2020 18:42:03] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382346', 'M01', '027', '1', '001000000000087630', 'M0100000631225_M01MOL20007601_1.PDF', 'M0100000631225', SYSDATE) [09 Sep 2020 18:42:03] (viewOnlineReports) database connection response [09 Sep 2020 18:42:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382346' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Sep 2020 18:42:03] (viewOnlineReports) database connection response [09 Sep 2020 18:42:03] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 18:42:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382346/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599658923M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382346/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599658923M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 18:42:03] (viewOnlineReports) Converting PDF to JPG with name as M0100000631225_M01MOL20007601_1.jpg [09 Sep 2020 18:42:03] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200382346/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599658923M0100000631225_M01MOL20007601_1.PDF ../../TEMP_PDF/200382346/M0100000631225_M01MOL20007601_1.jpg [09 Sep 2020 18:42:03] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200382346/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599658923M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:15] (viewOnlineReports) database connection response [09 Sep 2020 18:42:15] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 18:42:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000631225', '001', '200382346', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:42:15] (viewOnlineReports) p_Stop=N [09 Sep 2020 18:42:15] (viewOnlineReports) p_Alert= [09 Sep 2020 18:42:15] (viewOnlineReports) Flag = 1 [09 Sep 2020 18:42:15] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382346', 'M01', '027', '1', '001000000000087630', 'M0100000631225_M01MOL20007601_1.PDF', 'M0100000631225', SYSDATE) [09 Sep 2020 18:42:15] (viewOnlineReports) database connection response [09 Sep 2020 18:42:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382346' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Sep 2020 18:42:15] (viewOnlineReports) database connection response [09 Sep 2020 18:42:15] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 18:42:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382346/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658935M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382346/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658935M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 18:42:15] (viewOnlineReports) Converting PDF to JPG with name as M0100000631225_M01MOL20007601_1.jpg [09 Sep 2020 18:42:15] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200382346/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658935M0100000631225_M01MOL20007601_1.PDF ../../TEMP_PDF/200382346/M0100000631225_M01MOL20007601_1.jpg [09 Sep 2020 18:42:15] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200382346/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658935M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:21] (viewOnlineReports) database connection response [09 Sep 2020 18:42:21] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 18:42:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000631225', '001', '200382346', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:42:21] (viewOnlineReports) p_Stop=N [09 Sep 2020 18:42:21] (viewOnlineReports) p_Alert= [09 Sep 2020 18:42:21] (viewOnlineReports) Flag = 1 [09 Sep 2020 18:42:21] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382346', 'M01', '027', '1', '001000000000087630', 'M0100000631225_M01MOL20007601_1.PDF', 'M0100000631225', SYSDATE) [09 Sep 2020 18:42:21] (viewOnlineReports) database connection response [09 Sep 2020 18:42:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382346' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Sep 2020 18:42:21] (viewOnlineReports) database connection response [09 Sep 2020 18:42:21] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 18:42:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382346/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1599658941M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382346/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1599658941M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 18:42:21] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200382346/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1599658941M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:33] (viewOnlineReports) database connection response [09 Sep 2020 18:42:33] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 18:42:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000631225', '001', '200382346', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:42:33] (viewOnlineReports) p_Stop=N [09 Sep 2020 18:42:33] (viewOnlineReports) p_Alert= [09 Sep 2020 18:42:33] (viewOnlineReports) Flag = 1 [09 Sep 2020 18:42:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382346', 'M01', '027', '1', '001000000000087630', 'M0100000631225_M01MOL20007601_1.PDF', 'M0100000631225', SYSDATE) [09 Sep 2020 18:42:33] (viewOnlineReports) database connection response [09 Sep 2020 18:42:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382346' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Sep 2020 18:42:33] (viewOnlineReports) database connection response [09 Sep 2020 18:42:33] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 18:42:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382346/ [09 Sep 2020 18:42:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382346/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658953M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382346/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658953M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:42:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Sep 2020 18:42:33] (viewOnlineReports) Converting PDF to JPG with name as M0100000631225_M01MOL20007601_1.jpg [09 Sep 2020 18:42:33] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200382346/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658953M0100000631225_M01MOL20007601_1.PDF ../../TEMP_PDF/200382346/M0100000631225_M01MOL20007601_1.jpg [09 Sep 2020 18:42:34] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200382346/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599658953M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:43:03] (viewOnlineReports) database connection response [09 Sep 2020 18:43:03] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 18:43:03] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000631225', '001', '200382346', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 18:43:03] (viewOnlineReports) p_Stop=N [09 Sep 2020 18:43:03] (viewOnlineReports) p_Alert= [09 Sep 2020 18:43:03] (viewOnlineReports) Flag = 1 [09 Sep 2020 18:43:03] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382346', 'M01', '027', '1', '001000000000087630', 'M0100000631225_M01MOL20007601_1.PDF', 'M0100000631225', SYSDATE) [09 Sep 2020 18:43:03] (viewOnlineReports) database connection response [09 Sep 2020 18:43:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382346' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Sep 2020 18:43:03] (viewOnlineReports) database connection response [09 Sep 2020 18:43:03] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 18:43:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382346/ [09 Sep 2020 18:43:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382346/ [09 Sep 2020 18:43:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:43:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382346/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1599658983M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:43:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382346/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1599658983M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 18:43:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 18:43:03] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382346/0123456789ABCDEFHIJKLMNOPQRSTUVWXYZ1599658983M0100000631225_M01MOL20007601_1.PDF [09 Sep 2020 19:35:32] (index) database connection response [09 Sep 2020 19:35:32] (index) getConnection(): Resource id #1 [09 Sep 2020 19:35:32] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369888' AND ACCESS_CODE = '48196816' [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369888' AND ACCESS_CODE = '48196816' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000539294' [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getPatientReportsDetail() entered [09 Sep 2020 19:35:33] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369888', 'M0100000539294', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 19:35:33] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369888', 'M0100000539294', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 19:35:33] (index) p_Stop=N [09 Sep 2020 19:35:33] (index) p_Alert= [09 Sep 2020 19:35:33] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 19:35:33] (index) database connection response [09 Sep 2020 19:35:33] (index) getConnectionClose() called.... [09 Sep 2020 19:35:33] (index) getConnectionClose() called.... [09 Sep 2020 19:36:04] (viewOnlineReports) database connection response [09 Sep 2020 19:36:04] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 19:36:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200382003', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 19:36:04] (viewOnlineReports) p_Stop=N [09 Sep 2020 19:36:04] (viewOnlineReports) p_Alert= [09 Sep 2020 19:36:04] (viewOnlineReports) Flag = 1 [09 Sep 2020 19:36:04] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382003', 'M01', '001', '1', '001000000000085025', 'M0100000539294_M01HEM20012306_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 19:36:04] (viewOnlineReports) database connection response [09 Sep 2020 19:36:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382003' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [09 Sep 2020 19:36:04] (viewOnlineReports) database connection response [09 Sep 2020 19:36:04] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 19:36:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382003/ [09 Sep 2020 19:36:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382003/ [09 Sep 2020 19:36:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000539294_M01HEM20012306_1.PDF [09 Sep 2020 19:36:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382003/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599662164M0100000539294_M01HEM20012306_1.PDF [09 Sep 2020 19:36:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382003/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599662164M0100000539294_M01HEM20012306_1.PDF [09 Sep 2020 19:36:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 19:36:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382003/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599662164M0100000539294_M01HEM20012306_1.PDF [09 Sep 2020 19:37:16] (viewOnlineReports) database connection response [09 Sep 2020 19:37:16] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 19:37:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200382003', '2', '001000000000080061', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 19:37:16] (viewOnlineReports) p_Stop=N [09 Sep 2020 19:37:16] (viewOnlineReports) p_Alert= [09 Sep 2020 19:37:16] (viewOnlineReports) Flag = 1 [09 Sep 2020 19:37:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200382003', 'M01', '001', '2', '001000000000080061', 'M0100000539294_M01RCH20016634_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 19:37:17] (viewOnlineReports) database connection response [09 Sep 2020 19:37:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200382003' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [09 Sep 2020 19:37:17] (viewOnlineReports) database connection response [09 Sep 2020 19:37:17] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 19:37:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200382003/ [09 Sep 2020 19:37:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200382003/ [09 Sep 2020 19:37:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000539294_M01RCH20016634_1.PDF [09 Sep 2020 19:37:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200382003/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599662236M0100000539294_M01RCH20016634_1.PDF [09 Sep 2020 19:37:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200382003/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599662236M0100000539294_M01RCH20016634_1.PDF [09 Sep 2020 19:37:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 19:37:17] (viewOnlineReports) Downloading file ../../TEMP_PDF/200382003/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599662236M0100000539294_M01RCH20016634_1.PDF [09 Sep 2020 21:33:15] (index) database connection response [09 Sep 2020 21:33:15] (index) getConnection(): Resource id #1 [09 Sep 2020 21:33:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 21:33:15] (index) database connection response [09 Sep 2020 21:33:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 21:33:15] (index) database connection response [09 Sep 2020 21:33:15] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 21:33:15] (index) database connection response [09 Sep 2020 21:33:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369888' AND ACCESS_CODE = '78391359' [09 Sep 2020 21:33:15] (index) database connection response [09 Sep 2020 21:33:15] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369888' AND ACCESS_CODE = '78391359' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 21:33:15] (index) database connection response [09 Sep 2020 21:33:15] (index) getConnectionClose() called.... [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getConnection(): Resource id #1 [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369450' AND ACCESS_CODE = '78391359' [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200369450' AND ACCESS_CODE = '78391359' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000539294' [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getPatientReportsDetail() entered [09 Sep 2020 21:34:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369450', 'M0100000539294', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:34:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200369450', 'M0100000539294', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:34:06] (index) p_Stop=N [09 Sep 2020 21:34:06] (index) p_Alert= [09 Sep 2020 21:34:06] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Sep 2020 21:34:06] (index) database connection response [09 Sep 2020 21:34:06] (index) getConnectionClose() called.... [09 Sep 2020 21:34:06] (index) getConnectionClose() called.... [09 Sep 2020 21:34:16] (viewOnlineReports) database connection response [09 Sep 2020 21:34:16] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:34:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '3', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:34:16] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:34:16] (viewOnlineReports) p_Alert= [09 Sep 2020 21:34:16] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:34:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '3', '001000000000082947', 'M0100000539294_M01RCH20016634_2.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:34:16] (viewOnlineReports) database connection response [09 Sep 2020 21:34:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [09 Sep 2020 21:34:16] (viewOnlineReports) database connection response [09 Sep 2020 21:34:16] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:34:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:34:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:34:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669256M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669256M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 21:34:17] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200381842/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669256M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:33] (viewOnlineReports) database connection response [09 Sep 2020 21:34:33] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:34:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '3', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:34:33] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:34:33] (viewOnlineReports) p_Alert= [09 Sep 2020 21:34:33] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:34:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '3', '001000000000082947', 'M0100000539294_M01RCH20016634_2.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:34:33] (viewOnlineReports) database connection response [09 Sep 2020 21:34:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [09 Sep 2020 21:34:33] (viewOnlineReports) database connection response [09 Sep 2020 21:34:33] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:34:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:34:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:34:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599669273M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599669273M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Sep 2020 21:34:33] (viewOnlineReports) Converting PDF to JPG with name as M0100000539294_M01RCH20016634_2.jpg [09 Sep 2020 21:34:33] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599669273M0100000539294_M01RCH20016634_2.PDF ../../TEMP_PDF/200381842/M0100000539294_M01RCH20016634_2.jpg [09 Sep 2020 21:34:33] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599669273M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:34:47] (viewOnlineReports) database connection response [09 Sep 2020 21:34:47] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:34:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:34:47] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:34:47] (viewOnlineReports) p_Alert= [09 Sep 2020 21:34:47] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:34:47] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '1', '001000000000081028', 'M0100000539294_M01RCH20016557_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:34:47] (viewOnlineReports) database connection response [09 Sep 2020 21:34:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [09 Sep 2020 21:34:47] (viewOnlineReports) database connection response [09 Sep 2020 21:34:47] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:34:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:34:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:34:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:34:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599669287M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:34:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599669287M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:34:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Sep 2020 21:34:48] (viewOnlineReports) Converting PDF to JPG with name as M0100000539294_M01RCH20016557_1.jpg [09 Sep 2020 21:34:48] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599669287M0100000539294_M01RCH20016557_1.PDF ../../TEMP_PDF/200381842/M0100000539294_M01RCH20016557_1.jpg [09 Sep 2020 21:34:48] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599669287M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:07] (viewOnlineReports) database connection response [09 Sep 2020 21:35:07] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:35:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:35:07] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:35:07] (viewOnlineReports) p_Alert= [09 Sep 2020 21:35:07] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:35:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '1', '001000000000081028', 'M0100000539294_M01RCH20016557_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:35:07] (viewOnlineReports) database connection response [09 Sep 2020 21:35:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [09 Sep 2020 21:35:07] (viewOnlineReports) database connection response [09 Sep 2020 21:35:07] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:35:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:35:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:35:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669307M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669307M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Sep 2020 21:35:07] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200381842/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669307M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:36] (viewOnlineReports) database connection response [09 Sep 2020 21:35:36] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:35:36] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:35:36] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:35:36] (viewOnlineReports) p_Alert= [09 Sep 2020 21:35:36] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:35:36] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '1', '001000000000081028', 'M0100000539294_M01RCH20016557_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:35:36] (viewOnlineReports) database connection response [09 Sep 2020 21:35:36] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [09 Sep 2020 21:35:36] (viewOnlineReports) database connection response [09 Sep 2020 21:35:36] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:35:36] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:35:36] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:35:36] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:36] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599669336M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:36] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599669336M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:36] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 21:35:36] (viewOnlineReports) Downloading file ../../TEMP_PDF/200381842/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599669336M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:35:52] (viewOnlineReports) database connection response [09 Sep 2020 21:35:52] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:35:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '2', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:35:52] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:35:52] (viewOnlineReports) p_Alert= [09 Sep 2020 21:35:52] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:35:52] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '2', '001000000000087100', 'M0100000539294_M01MIC20006615_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:35:52] (viewOnlineReports) database connection response [09 Sep 2020 21:35:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '2' [09 Sep 2020 21:35:52] (viewOnlineReports) database connection response [09 Sep 2020 21:35:52] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:35:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:35:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:35:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000539294_M01MIC20006615_1.PDF [09 Sep 2020 21:35:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669351M0100000539294_M01MIC20006615_1.PDF [09 Sep 2020 21:35:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669351M0100000539294_M01MIC20006615_1.PDF [09 Sep 2020 21:35:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 21:35:52] (viewOnlineReports) Downloading file ../../TEMP_PDF/200381842/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669351M0100000539294_M01MIC20006615_1.PDF [09 Sep 2020 21:36:04] (viewOnlineReports) database connection response [09 Sep 2020 21:36:04] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:36:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '3', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:36:04] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:36:04] (viewOnlineReports) p_Alert= [09 Sep 2020 21:36:04] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:36:04] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '3', '001000000000082947', 'M0100000539294_M01RCH20016634_2.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:36:04] (viewOnlineReports) database connection response [09 Sep 2020 21:36:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '3' [09 Sep 2020 21:36:04] (viewOnlineReports) database connection response [09 Sep 2020 21:36:04] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:36:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:36:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:36:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200909\M01\M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:36:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669364M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:36:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669364M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:36:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 21:36:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200381842/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669364M0100000539294_M01RCH20016634_2.PDF [09 Sep 2020 21:36:37] (viewOnlineReports) database connection response [09 Sep 2020 21:36:37] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:36:37] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:36:37] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:36:37] (viewOnlineReports) p_Alert= [09 Sep 2020 21:36:37] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:36:37] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '1', '001000000000081028', 'M0100000539294_M01RCH20016557_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:36:37] (viewOnlineReports) database connection response [09 Sep 2020 21:36:37] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [09 Sep 2020 21:36:37] (viewOnlineReports) database connection response [09 Sep 2020 21:36:37] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:36:37] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:36:37] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:36:37] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:37] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669397M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:37] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669397M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:37] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 21:36:37] (viewOnlineReports) Downloading file ../../TEMP_PDF/200381842/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599669397M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:47] (viewOnlineReports) database connection response [09 Sep 2020 21:36:47] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:36:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', 'M0100000539294', '001', '200381842', '1', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:36:47] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:36:47] (viewOnlineReports) p_Alert= [09 Sep 2020 21:36:47] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:36:47] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200381842', 'M01', '001', '1', '001000000000081028', 'M0100000539294_M01RCH20016557_1.PDF', 'M0100000539294', SYSDATE) [09 Sep 2020 21:36:47] (viewOnlineReports) database connection response [09 Sep 2020 21:36:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200381842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [09 Sep 2020 21:36:47] (viewOnlineReports) database connection response [09 Sep 2020 21:36:47] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:36:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200381842/ [09 Sep 2020 21:36:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200381842/ [09 Sep 2020 21:36:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200908\M01\M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599669407M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599669407M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:36:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 21:36:47] (viewOnlineReports) Downloading file ../../TEMP_PDF/200381842/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599669407M0100000539294_M01RCH20016557_1.PDF [09 Sep 2020 21:39:26] (viewOnlineReports) database connection response [09 Sep 2020 21:39:26] (viewOnlineReports) getConnection(): Resource id #1 [09 Sep 2020 21:39:26] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', '00100000000000', '001', '200372522', '1', '001000000000081220', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Sep 2020 21:39:26] (viewOnlineReports) p_Stop=N [09 Sep 2020 21:39:26] (viewOnlineReports) p_Alert= [09 Sep 2020 21:39:26] (viewOnlineReports) Flag = 1 [09 Sep 2020 21:39:26] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200372522', 'M01', '047', '1', '001000000000081220', 'M0100000630427_M01MIC20005908_1.PDF', '00100000000000', SYSDATE) [09 Sep 2020 21:39:26] (viewOnlineReports) database connection response [09 Sep 2020 21:39:26] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200372522' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Sep 2020 21:39:26] (viewOnlineReports) database connection response [09 Sep 2020 21:39:26] (viewOnlineReports) getConnectionClose() called.... [09 Sep 2020 21:39:26] (viewOnlineReports) creating directory structure../../TEMP_PDF/200372522/ [09 Sep 2020 21:39:26] (viewOnlineReports) directory structure created ../../TEMP_PDF/200372522/ [09 Sep 2020 21:39:26] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200821\M01\M0100000630427_M01MIC20005908_1.PDF [09 Sep 2020 21:39:26] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200372522/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZM0100000630427_M01MIC20005908_1.PDF [09 Sep 2020 21:39:26] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200372522/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZM0100000630427_M01MIC20005908_1.PDF [09 Sep 2020 21:39:26] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Sep 2020 21:39:26] (viewOnlineReports) Downloading file ../../TEMP_PDF/200372522/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZM0100000630427_M01MIC20005908_1.PDF