[06 Aug 2020 09:05:25] (index) database connection response [06 Aug 2020 09:05:25] (index) getConnection(): Resource id #1 [06 Aug 2020 09:05:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 09:05:25] (index) database connection response [06 Aug 2020 09:05:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 09:05:25] (index) database connection response [06 Aug 2020 09:05:25] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 09:05:25] (index) database connection response [06 Aug 2020 09:05:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200232987' AND ACCESS_CODE = '85303390' [06 Aug 2020 09:05:25] (index) database connection response [06 Aug 2020 09:05:25] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200232987' AND ACCESS_CODE = '85303390' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 09:05:25] (index) database connection response [06 Aug 2020 09:05:25] (index) getConnectionClose() called.... [06 Aug 2020 09:06:37] (index) database connection response [06 Aug 2020 09:06:37] (index) getConnection(): Resource id #1 [06 Aug 2020 09:06:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 09:06:37] (index) database connection response [06 Aug 2020 09:06:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 09:06:37] (index) database connection response [06 Aug 2020 09:06:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 09:06:37] (index) database connection response [06 Aug 2020 09:06:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200308638' AND ACCESS_CODE = '85303390' [06 Aug 2020 09:06:38] (index) database connection response [06 Aug 2020 09:06:38] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200308638' AND ACCESS_CODE = '85303390' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 09:06:38] (index) database connection response [06 Aug 2020 09:06:38] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000548897' [06 Aug 2020 09:06:38] (index) database connection response [06 Aug 2020 09:06:38] (index) getPatientReportsDetail() entered [06 Aug 2020 09:06:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200308638', 'M0100000548897', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 09:06:38] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200308638', 'M0100000548897', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 09:06:38] (index) p_Stop=N [06 Aug 2020 09:06:38] (index) p_Alert= [06 Aug 2020 09:06:38] (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 [06 Aug 2020 09:06:38] (index) database connection response [06 Aug 2020 09:06:38] (index) getConnectionClose() called.... [06 Aug 2020 09:06:38] (index) getConnectionClose() called.... [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getConnection(): Resource id #1 [06 Aug 2020 11:07:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200302861' AND ACCESS_CODE = '95164029' [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200302861' AND ACCESS_CODE = '95164029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000558438' [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getPatientReportsDetail() entered [06 Aug 2020 11:07:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200302861', 'M0100000558438', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:07:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200302861', 'M0100000558438', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:07:51] (index) p_Stop=N [06 Aug 2020 11:07:51] (index) p_Alert= [06 Aug 2020 11:07: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 [06 Aug 2020 11:07:51] (index) database connection response [06 Aug 2020 11:07:51] (index) getConnectionClose() called.... [06 Aug 2020 11:07:51] (index) getConnectionClose() called.... [06 Aug 2020 11:09:52] (viewOnlineReports) database connection response [06 Aug 2020 11:09:52] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:09:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:09:52] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:09:52] (viewOnlineReports) p_Alert= [06 Aug 2020 11:09:52] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:09: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', '200364168', 'M01', '047', '2', '001000000000084949', 'M0100000558438_M01RCH20013481_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:09:52] (viewOnlineReports) database connection response [06 Aug 2020 11:09:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Aug 2020 11:09:52] (viewOnlineReports) database connection response [06 Aug 2020 11:09:52] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:09:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:09:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:09:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:09:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596694192M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:09:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596694192M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:09:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:09:52] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596694192M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:10:07] (viewOnlineReports) database connection response [06 Aug 2020 11:10:07] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:10:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:10:07] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:10:07] (viewOnlineReports) p_Alert= [06 Aug 2020 11:10:07] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:10: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', '200364168', 'M01', '047', '2', '001000000000084949', 'M0100000558438_M01RCH20013481_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:10:07] (viewOnlineReports) database connection response [06 Aug 2020 11:10:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Aug 2020 11:10:07] (viewOnlineReports) database connection response [06 Aug 2020 11:10:07] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:10:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:10:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:10:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:10:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596694207M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:10:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596694207M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:10:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:10:07] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596694207M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:10:47] (viewOnlineReports) database connection response [06 Aug 2020 11:10:47] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:10:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:10:47] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:10:47] (viewOnlineReports) p_Alert= [06 Aug 2020 11:10:47] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:10: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', '200364168', 'M01', '047', '3', '001000000000087100', 'M0100000558438_M01MIC20005340_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:10:47] (viewOnlineReports) database connection response [06 Aug 2020 11:10:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Aug 2020 11:10:47] (viewOnlineReports) database connection response [06 Aug 2020 11:10:47] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:10:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:10:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:10:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:10:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1596694247M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:10:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1596694247M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:10:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:10:47] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1596694247M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:11:15] (viewOnlineReports) database connection response [06 Aug 2020 11:11:15] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:11:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '4', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:11:15] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:11:15] (viewOnlineReports) p_Alert= [06 Aug 2020 11:11:15] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:11: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', '200364168', 'M01', '047', '4', '001000000000086900', 'M0100000558438_M01BBK20001717_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:11:15] (viewOnlineReports) database connection response [06 Aug 2020 11:11:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [06 Aug 2020 11:11:15] (viewOnlineReports) database connection response [06 Aug 2020 11:11:15] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:11:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:11:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:11:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01BBK20001717_1.PDF [06 Aug 2020 11:11:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596694275M0100000558438_M01BBK20001717_1.PDF [06 Aug 2020 11:11:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596694275M0100000558438_M01BBK20001717_1.PDF [06 Aug 2020 11:11:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:11:15] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596694275M0100000558438_M01BBK20001717_1.PDF [06 Aug 2020 11:11:35] (viewOnlineReports) database connection response [06 Aug 2020 11:11:35] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:11:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '5', '001000000000082728', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:11:35] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:11:35] (viewOnlineReports) p_Alert= [06 Aug 2020 11:11:35] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:11: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', '200364168', 'M01', '047', '5', '001000000000082728', 'M0100000558438_M01SCH20007502_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:11:35] (viewOnlineReports) database connection response [06 Aug 2020 11:11:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Aug 2020 11:11:35] (viewOnlineReports) database connection response [06 Aug 2020 11:11:35] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:11:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:11:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:11:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:11:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596694295M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:11:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596694295M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:11:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:11:35] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596694295M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getConnection(): Resource id #1 [06 Aug 2020 11:24:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200302861' AND ACCESS_CODE = '95164029' [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200302861' AND ACCESS_CODE = '95164029' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000558438' [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getPatientReportsDetail() entered [06 Aug 2020 11:24:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200302861', 'M0100000558438', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:24:31] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200302861', 'M0100000558438', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:24:31] (index) p_Stop=N [06 Aug 2020 11:24:31] (index) p_Alert= [06 Aug 2020 11:24:31] (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 [06 Aug 2020 11:24:31] (index) database connection response [06 Aug 2020 11:24:31] (index) getConnectionClose() called.... [06 Aug 2020 11:24:31] (index) getConnectionClose() called.... [06 Aug 2020 11:25:02] (viewOnlineReports) database connection response [06 Aug 2020 11:25:02] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:25:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:25:02] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:25:02] (viewOnlineReports) p_Alert= [06 Aug 2020 11:25:02] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:25:02] (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', '200364168', 'M01', '047', '2', '001000000000084949', 'M0100000558438_M01RCH20013481_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:25:02] (viewOnlineReports) database connection response [06 Aug 2020 11:25:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Aug 2020 11:25:02] (viewOnlineReports) database connection response [06 Aug 2020 11:25:02] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:25:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:25:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:25:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:25:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596695102M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:25:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596695102M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:25:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Aug 2020 11:25:03] (viewOnlineReports) Downloading file ../../TEMP_PDF/200364168/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596695102M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:40:20] (viewOnlineReports) database connection response [06 Aug 2020 11:40:20] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:40:20] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:40:20] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:40:20] (viewOnlineReports) p_Alert= [06 Aug 2020 11:40:20] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:40:20] (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', '200364168', 'M01', '047', '3', '001000000000087100', 'M0100000558438_M01MIC20005340_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:40:20] (viewOnlineReports) database connection response [06 Aug 2020 11:40:20] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Aug 2020 11:40:20] (viewOnlineReports) database connection response [06 Aug 2020 11:40:20] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:40:20] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:40:20] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:40:20] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:20] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596696020M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:20] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596696020M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:20] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Aug 2020 11:40:20] (viewOnlineReports) Downloading file ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596696020M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:40] (viewOnlineReports) database connection response [06 Aug 2020 11:40:40] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:40:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '3', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:40:40] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:40:40] (viewOnlineReports) p_Alert= [06 Aug 2020 11:40:40] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:40: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', '200364168', 'M01', '047', '3', '001000000000087100', 'M0100000558438_M01MIC20005340_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:40:40] (viewOnlineReports) database connection response [06 Aug 2020 11:40:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [06 Aug 2020 11:40:40] (viewOnlineReports) database connection response [06 Aug 2020 11:40:40] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:40:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:40:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:40:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596696040M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596696040M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:40:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:40:40] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596696040M0100000558438_M01MIC20005340_1.PDF [06 Aug 2020 11:42:04] (viewOnlineReports) database connection response [06 Aug 2020 11:42:04] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:42:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:42:04] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:42:04] (viewOnlineReports) p_Alert= [06 Aug 2020 11:42:04] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:42: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', '200364168', 'M01', '047', '2', '001000000000084949', 'M0100000558438_M01RCH20013481_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:42:04] (viewOnlineReports) database connection response [06 Aug 2020 11:42:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Aug 2020 11:42:04] (viewOnlineReports) database connection response [06 Aug 2020 11:42:04] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:42:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:42:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:42:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596696124M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596696124M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 11:42:04] (viewOnlineReports) Converting PDF to JPG with name as M0100000558438_M01RCH20013481_1.jpg [06 Aug 2020 11:42:04] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200364168/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596696124M0100000558438_M01RCH20013481_1.PDF ../../TEMP_PDF/200364168/M0100000558438_M01RCH20013481_1.jpg [06 Aug 2020 11:42:04] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200364168/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596696124M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:25] (viewOnlineReports) database connection response [06 Aug 2020 11:42:25] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:42:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '2', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:42:25] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:42:25] (viewOnlineReports) p_Alert= [06 Aug 2020 11:42:25] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:42: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', '200364168', 'M01', '047', '2', '001000000000084949', 'M0100000558438_M01RCH20013481_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:42:25] (viewOnlineReports) database connection response [06 Aug 2020 11:42:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [06 Aug 2020 11:42:25] (viewOnlineReports) database connection response [06 Aug 2020 11:42:25] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:42:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:42:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:42:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596696145M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596696145M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:42:25] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596696145M0100000558438_M01RCH20013481_1.PDF [06 Aug 2020 11:42:49] (viewOnlineReports) database connection response [06 Aug 2020 11:42:49] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:42:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '5', '001000000000082728', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:42:49] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:42:49] (viewOnlineReports) p_Alert= [06 Aug 2020 11:42:49] (viewOnlineReports) Flag = 1 [06 Aug 2020 11:42:49] (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', '200364168', 'M01', '047', '5', '001000000000082728', 'M0100000558438_M01SCH20007502_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:42:49] (viewOnlineReports) database connection response [06 Aug 2020 11:42:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Aug 2020 11:42:49] (viewOnlineReports) database connection response [06 Aug 2020 11:42:49] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:42:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:42:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:42:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:42:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596696169M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:42:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596696169M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:42:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:42:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596696169M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:43:03] (viewOnlineReports) database connection response [06 Aug 2020 11:43:03] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 11:43:03] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000558438', '001', '200364168', '5', '001000000000082728', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 11:43:03] (viewOnlineReports) p_Stop=N [06 Aug 2020 11:43:03] (viewOnlineReports) p_Alert= [06 Aug 2020 11:43:03] (viewOnlineReports) Flag = 1 [06 Aug 2020 11: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', '200364168', 'M01', '047', '5', '001000000000082728', 'M0100000558438_M01SCH20007502_1.PDF', 'M0100000558438', SYSDATE) [06 Aug 2020 11:43:03] (viewOnlineReports) database connection response [06 Aug 2020 11:43:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200364168' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [06 Aug 2020 11:43:03] (viewOnlineReports) database connection response [06 Aug 2020 11:43:03] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 11:43:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200364168/ [06 Aug 2020 11:43:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200364168/ [06 Aug 2020 11:43:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200725\M01\M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:43:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1596696183M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:43:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1596696183M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 11:43:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 11:43:03] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200364168/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1596696183M0100000558438_M01SCH20007502_1.PDF [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getConnection(): Resource id #1 [06 Aug 2020 12:16:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316762' AND ACCESS_CODE = '34196020' [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316762' AND ACCESS_CODE = '34196020' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629330' [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getPatientReportsDetail() entered [06 Aug 2020 12:16:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316762', 'M0100000629330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 12:16:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316762', 'M0100000629330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 12:16:04] (index) p_Stop=N [06 Aug 2020 12:16:04] (index) p_Alert= [06 Aug 2020 12:16:04] (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 [06 Aug 2020 12:16:04] (index) database connection response [06 Aug 2020 12:16:04] (index) getConnectionClose() called.... [06 Aug 2020 12:16:05] (index) getConnectionClose() called.... [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getConnection(): Resource id #1 [06 Aug 2020 12:54:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '77' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '77' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '77' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000018289' [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getPatientReportsDetail() entered [06 Aug 2020 12:54:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 12:54:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 12:54:21] (index) p_Stop=N [06 Aug 2020 12:54:21] (index) p_Alert= [06 Aug 2020 12:54: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 [06 Aug 2020 12:54:21] (index) database connection response [06 Aug 2020 12:54:21] (index) getConnectionClose() called.... [06 Aug 2020 12:54:21] (index) getConnectionClose() called.... [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getConnection(): Resource id #1 [06 Aug 2020 14:24:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '46' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '46' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '46' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316292' AND ACCESS_CODE = '07046364' [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316292' AND ACCESS_CODE = '07046364' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000036898' [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getPatientReportsDetail() entered [06 Aug 2020 14:24:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316292', 'M0100000036898', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:24:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316292', 'M0100000036898', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:24:27] (index) p_Stop=N [06 Aug 2020 14:24:27] (index) p_Alert= [06 Aug 2020 14:24:27] (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 [06 Aug 2020 14:24:27] (index) database connection response [06 Aug 2020 14:24:27] (index) getConnectionClose() called.... [06 Aug 2020 14:24:27] (index) getConnectionClose() called.... [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getConnection(): Resource id #1 [06 Aug 2020 14:35:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '77' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '77' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '77' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000018289' [06 Aug 2020 14:35:34] (index) database connection response [06 Aug 2020 14:35:34] (index) getPatientReportsDetail() entered [06 Aug 2020 14:35:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:35:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:35:35] (index) p_Stop=N [06 Aug 2020 14:35:35] (index) p_Alert= [06 Aug 2020 14:35:35] (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 [06 Aug 2020 14:35:35] (index) database connection response [06 Aug 2020 14:35:35] (index) getConnectionClose() called.... [06 Aug 2020 14:35:35] (index) getConnectionClose() called.... [06 Aug 2020 14:35:45] (viewOnlineReports) database connection response [06 Aug 2020 14:35:45] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:35:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:35:45] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:35:45] (viewOnlineReports) p_Alert= [06 Aug 2020 14:35:45] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:35:45] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:35:45] (viewOnlineReports) database connection response [06 Aug 2020 14:35:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:35:45] (viewOnlineReports) database connection response [06 Aug 2020 14:35:45] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:35:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:35:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:35:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:35:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596706545M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:35:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596706545M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:35:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Aug 2020 14:35:45] (viewOnlineReports) Downloading file ../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596706545M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:16] (viewOnlineReports) database connection response [06 Aug 2020 14:37:16] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:37:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:37:16] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:37:16] (viewOnlineReports) p_Alert= [06 Aug 2020 14:37:16] (viewOnlineReports) Flag = 1 [06 Aug 2020 14: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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:37:16] (viewOnlineReports) database connection response [06 Aug 2020 14:37:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:37:16] (viewOnlineReports) database connection response [06 Aug 2020 14:37:16] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:37:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:37:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:37:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596706636M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596706636M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 14:37:16] (viewOnlineReports) Converting PDF to JPG with name as M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:37:16] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367549/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596706636M0100000018289_M01RCH20014109_1.PDF ../../TEMP_PDF/200367549/M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:37:17] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367549/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596706636M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:50] (viewOnlineReports) database connection response [06 Aug 2020 14:37:50] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:37:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:37:50] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:37:50] (viewOnlineReports) p_Alert= [06 Aug 2020 14:37:50] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:37: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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:37:50] (viewOnlineReports) database connection response [06 Aug 2020 14:37:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:37:50] (viewOnlineReports) database connection response [06 Aug 2020 14:37:50] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:37:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:37:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:37:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596706670M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596706670M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:37:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 14:37:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596706670M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getConnection(): Resource id #1 [06 Aug 2020 14:39:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000018289' [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getPatientReportsDetail() entered [06 Aug 2020 14:39:39] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:39:39] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:39:39] (index) p_Stop=N [06 Aug 2020 14:39:39] (index) p_Alert= [06 Aug 2020 14:39:39] (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 [06 Aug 2020 14:39:39] (index) database connection response [06 Aug 2020 14:39:39] (index) getConnectionClose() called.... [06 Aug 2020 14:39:39] (index) getConnectionClose() called.... [06 Aug 2020 14:39:49] (viewOnlineReports) database connection response [06 Aug 2020 14:39:49] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:39:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:39:49] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:39:49] (viewOnlineReports) p_Alert= [06 Aug 2020 14:39:49] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:39:49] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:39:49] (viewOnlineReports) database connection response [06 Aug 2020 14:39:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:39:49] (viewOnlineReports) database connection response [06 Aug 2020 14:39:49] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:39:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:39:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:39:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:39:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1596706789M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:39:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1596706789M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:39:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 14:39:50] (viewOnlineReports) Converting PDF to JPG with name as M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:39:50] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1596706789M0100000018289_M01RCH20014109_1.PDF ../../TEMP_PDF/200367549/M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:39:50] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1596706789M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:40:54] (viewOnlineReports) database connection response [06 Aug 2020 14:40:54] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:40:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:40:54] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:40:54] (viewOnlineReports) p_Alert= [06 Aug 2020 14:40:54] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:40: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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:40:54] (viewOnlineReports) database connection response [06 Aug 2020 14:40:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:40:54] (viewOnlineReports) database connection response [06 Aug 2020 14:40:54] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:40:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:40:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:40:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:40:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596706854M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:40:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596706854M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:40:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 14:40:54] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596706854M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:48:49] (viewOnlineReports) database connection response [06 Aug 2020 14:48:49] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:48:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:48:49] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:48:49] (viewOnlineReports) p_Alert= [06 Aug 2020 14:48:49] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:48:49] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:48:49] (viewOnlineReports) database connection response [06 Aug 2020 14:48:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:48:49] (viewOnlineReports) database connection response [06 Aug 2020 14:48:49] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:48:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:48:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:48:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:48:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707329M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:48:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707329M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:48:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Aug 2020 14:48:49] (viewOnlineReports) Downloading file ../../TEMP_PDF/200367549/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707329M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:52:06] (viewOnlineReports) database connection response [06 Aug 2020 14:52:06] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:52:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:52:06] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:52:06] (viewOnlineReports) p_Alert= [06 Aug 2020 14:52:06] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:52:06] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:52:06] (viewOnlineReports) database connection response [06 Aug 2020 14:52:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:52:06] (viewOnlineReports) database connection response [06 Aug 2020 14:52:06] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:52:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:52:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:52:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:52:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1596707526M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:52:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1596707526M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:52:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 14:52:06] (viewOnlineReports) Converting PDF to JPG with name as M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:52:06] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1596707526M0100000018289_M01RCH20014109_1.PDF ../../TEMP_PDF/200367549/M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:52:06] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1596707526M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:53:11] (viewOnlineReports) database connection response [06 Aug 2020 14:53:11] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 14:53:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 14:53:11] (viewOnlineReports) p_Stop=N [06 Aug 2020 14:53:11] (viewOnlineReports) p_Alert= [06 Aug 2020 14:53:11] (viewOnlineReports) Flag = 1 [06 Aug 2020 14:53: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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 14:53:11] (viewOnlineReports) database connection response [06 Aug 2020 14:53:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 14:53:11] (viewOnlineReports) database connection response [06 Aug 2020 14:53:11] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 14:53:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 14:53:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 14:53:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:53:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707591M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:53:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707591M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 14:53:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 14:53:11] (viewOnlineReports) Converting PDF to JPG with name as M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:53:11] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707591M0100000018289_M01RCH20014109_1.PDF ../../TEMP_PDF/200367549/M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 14:53:11] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367549/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596707591M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getConnection(): Resource id #1 [06 Aug 2020 15:21:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316938' AND ACCESS_CODE = '28234091' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000018289' [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getPatientReportsDetail() entered [06 Aug 2020 15:21:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 15:21:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316938', 'M0100000018289', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 15:21:22] (index) p_Stop=N [06 Aug 2020 15:21:22] (index) p_Alert= [06 Aug 2020 15:21:22] (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 [06 Aug 2020 15:21:22] (index) database connection response [06 Aug 2020 15:21:22] (index) getConnectionClose() called.... [06 Aug 2020 15:21:22] (index) getConnectionClose() called.... [06 Aug 2020 15:21:29] (viewOnlineReports) database connection response [06 Aug 2020 15:21:29] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 15:21:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 15:21:29] (viewOnlineReports) p_Stop=N [06 Aug 2020 15:21:29] (viewOnlineReports) p_Alert= [06 Aug 2020 15:21:29] (viewOnlineReports) Flag = 1 [06 Aug 2020 15:21:29] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 15:21:29] (viewOnlineReports) database connection response [06 Aug 2020 15:21:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 15:21:29] (viewOnlineReports) database connection response [06 Aug 2020 15:21:29] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 15:21:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 15:21:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 15:21:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596709289M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:29] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596709289M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:29] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 15:21:29] (viewOnlineReports) Converting PDF to JPG with name as M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 15:21:29] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367549/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596709289M0100000018289_M01RCH20014109_1.PDF ../../TEMP_PDF/200367549/M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 15:21:29] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367549/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596709289M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:58] (viewOnlineReports) database connection response [06 Aug 2020 15:21:58] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 15:21:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 15:21:58] (viewOnlineReports) p_Stop=N [06 Aug 2020 15:21:58] (viewOnlineReports) p_Alert= [06 Aug 2020 15:21:58] (viewOnlineReports) Flag = 1 [06 Aug 2020 15:21:58] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 15:21:58] (viewOnlineReports) database connection response [06 Aug 2020 15:21:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 15:21:58] (viewOnlineReports) database connection response [06 Aug 2020 15:21:58] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 15:21:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 15:21:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 15:21:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1596709318M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1596709318M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:21:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [06 Aug 2020 15:21:58] (viewOnlineReports) Converting PDF to JPG with name as M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 15:21:58] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1596709318M0100000018289_M01RCH20014109_1.PDF ../../TEMP_PDF/200367549/M0100000018289_M01RCH20014109_1.jpg [06 Aug 2020 15:21:58] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367549/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1596709318M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:26:12] (viewOnlineReports) database connection response [06 Aug 2020 15:26:12] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 15:26:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000018289', '001', '200367549', '1', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 15:26:12] (viewOnlineReports) p_Stop=N [06 Aug 2020 15:26:12] (viewOnlineReports) p_Alert= [06 Aug 2020 15:26:12] (viewOnlineReports) Flag = 1 [06 Aug 2020 15:26:12] (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', '200367549', 'M01', '047', '1', '001000000000082947', 'M0100000018289_M01RCH20014109_1.PDF', 'M0100000018289', SYSDATE) [06 Aug 2020 15:26:12] (viewOnlineReports) database connection response [06 Aug 2020 15:26:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367549' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 15:26:12] (viewOnlineReports) database connection response [06 Aug 2020 15:26:12] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 15:26:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367549/ [06 Aug 2020 15:26:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367549/ [06 Aug 2020 15:26:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:26:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367549/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596709572M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:26:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367549/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596709572M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 15:26:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Aug 2020 15:26:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200367549/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596709572M0100000018289_M01RCH20014109_1.PDF [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getConnection(): Resource id #1 [06 Aug 2020 16:24:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '46' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '46' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '46' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316292' AND ACCESS_CODE = '07046364' [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316292' AND ACCESS_CODE = '07046364' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000036898' [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getPatientReportsDetail() entered [06 Aug 2020 16:24:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316292', 'M0100000036898', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 16:24:16] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316292', 'M0100000036898', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 16:24:16] (index) p_Stop=N [06 Aug 2020 16:24:16] (index) p_Alert= [06 Aug 2020 16:24:16] (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 [06 Aug 2020 16:24:16] (index) database connection response [06 Aug 2020 16:24:16] (index) getConnectionClose() called.... [06 Aug 2020 16:24:16] (index) getConnectionClose() called.... [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getConnection(): Resource id #1 [06 Aug 2020 18:40:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200317545' AND ACCESS_CODE = '83110112' [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200317545' AND ACCESS_CODE = '83110112' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629386' [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getPatientReportsDetail() entered [06 Aug 2020 18:40:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200317545', 'M0100000629386', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 18:40:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200317545', 'M0100000629386', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 18:40:55] (index) p_Stop=N [06 Aug 2020 18:40:55] (index) p_Alert= [06 Aug 2020 18:40:55] (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 [06 Aug 2020 18:40:55] (index) database connection response [06 Aug 2020 18:40:55] (index) getConnectionClose() called.... [06 Aug 2020 18:40:55] (index) getConnectionClose() called.... [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getConnection(): Resource id #1 [06 Aug 2020 20:18:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200317545' AND ACCESS_CODE = '83110112' [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200317545' AND ACCESS_CODE = '83110112' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629386' [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getPatientReportsDetail() entered [06 Aug 2020 20:18:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200317545', 'M0100000629386', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 20:18:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200317545', 'M0100000629386', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 20:18:22] (index) p_Stop=N [06 Aug 2020 20:18:22] (index) p_Alert= [06 Aug 2020 20:18:22] (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 [06 Aug 2020 20:18:22] (index) database connection response [06 Aug 2020 20:18:22] (index) getConnectionClose() called.... [06 Aug 2020 20:18:22] (index) getConnectionClose() called.... [06 Aug 2020 20:20:53] (viewOnlineReports) database connection response [06 Aug 2020 20:20:53] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 20:20:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000629386', '001', '200367784', '1', '001000000000086337', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 20:20:53] (viewOnlineReports) p_Stop=N [06 Aug 2020 20:20:53] (viewOnlineReports) p_Alert= [06 Aug 2020 20:20:53] (viewOnlineReports) Flag = 1 [06 Aug 2020 20:20: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', '200367784', 'M01', '047', '1', '001000000000086337', 'M0100000629386_M01SCH20007866_1.PDF', 'M0100000629386', SYSDATE) [06 Aug 2020 20:20:53] (viewOnlineReports) database connection response [06 Aug 2020 20:20:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367784' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 20:20:53] (viewOnlineReports) database connection response [06 Aug 2020 20:20:53] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 20:20:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367784/ [06 Aug 2020 20:20:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367784/ [06 Aug 2020 20:20:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000629386_M01SCH20007866_1.PDF [06 Aug 2020 20:20:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367784/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596727253M0100000629386_M01SCH20007866_1.PDF [06 Aug 2020 20:20:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367784/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596727253M0100000629386_M01SCH20007866_1.PDF [06 Aug 2020 20:20:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 20:20:53] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200367784/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596727253M0100000629386_M01SCH20007866_1.PDF [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getConnection(): Resource id #1 [06 Aug 2020 21:15:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200317606' AND ACCESS_CODE = '70665689' [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200317606' AND ACCESS_CODE = '70665689' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000006139' [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getPatientReportsDetail() entered [06 Aug 2020 21:15:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200317606', 'M0100000006139', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:15:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200317606', 'M0100000006139', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:15:17] (index) p_Stop=N [06 Aug 2020 21:15:17] (index) p_Alert= [06 Aug 2020 21:15:17] (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 [06 Aug 2020 21:15:17] (index) database connection response [06 Aug 2020 21:15:17] (index) getConnectionClose() called.... [06 Aug 2020 21:15:17] (index) getConnectionClose() called.... [06 Aug 2020 21:15:25] (viewOnlineReports) database connection response [06 Aug 2020 21:15:25] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 21:15:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000006139', '001', '200367804', '1', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:15:25] (viewOnlineReports) p_Stop=N [06 Aug 2020 21:15:25] (viewOnlineReports) p_Alert= [06 Aug 2020 21:15:25] (viewOnlineReports) Flag = 1 [06 Aug 2020 21:15: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', '200367804', 'M01', '047', '1', '001000000000080092', 'M0100000006139_M01SCH20007870_1.PDF', 'M0100000006139', SYSDATE) [06 Aug 2020 21:15:25] (viewOnlineReports) database connection response [06 Aug 2020 21:15:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367804' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 21:15:25] (viewOnlineReports) database connection response [06 Aug 2020 21:15:25] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 21:15:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367804/ [06 Aug 2020 21:15:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367804/ [06 Aug 2020 21:15:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367804/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596730525M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367804/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596730525M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [06 Aug 2020 21:15:25] (viewOnlineReports) Converting PDF to JPG with name as M0100000006139_M01SCH20007870_1.jpg [06 Aug 2020 21:15:25] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200367804/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596730525M0100000006139_M01SCH20007870_1.PDF ../../TEMP_PDF/200367804/M0100000006139_M01SCH20007870_1.jpg [06 Aug 2020 21:15:25] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200367804/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596730525M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:39] (viewOnlineReports) database connection response [06 Aug 2020 21:15:39] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 21:15:39] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000006139', '001', '200367804', '1', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:15:39] (viewOnlineReports) p_Stop=N [06 Aug 2020 21:15:39] (viewOnlineReports) p_Alert= [06 Aug 2020 21:15:39] (viewOnlineReports) Flag = 1 [06 Aug 2020 21:15:39] (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', '200367804', 'M01', '047', '1', '001000000000080092', 'M0100000006139_M01SCH20007870_1.PDF', 'M0100000006139', SYSDATE) [06 Aug 2020 21:15:39] (viewOnlineReports) database connection response [06 Aug 2020 21:15:39] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367804' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 21:15:39] (viewOnlineReports) database connection response [06 Aug 2020 21:15:39] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 21:15:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367804/ [06 Aug 2020 21:15:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367804/ [06 Aug 2020 21:15:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367804/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1596730539M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367804/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1596730539M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:15:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [06 Aug 2020 21:15:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200367804/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1596730539M0100000006139_M01SCH20007870_1.PDF [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getConnection(): Resource id #1 [06 Aug 2020 21:33:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316762' AND ACCESS_CODE = '34196020' [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200316762' AND ACCESS_CODE = '34196020' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629330' [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getPatientReportsDetail() entered [06 Aug 2020 21:33:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316762', 'M0100000629330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:33:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200316762', 'M0100000629330', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:33:34] (index) p_Stop=N [06 Aug 2020 21:33:34] (index) p_Alert= [06 Aug 2020 21:33:34] (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 [06 Aug 2020 21:33:34] (index) database connection response [06 Aug 2020 21:33:34] (index) getConnectionClose() called.... [06 Aug 2020 21:33:34] (index) getConnectionClose() called.... [06 Aug 2020 21:34:48] (viewOnlineReports) database connection response [06 Aug 2020 21:34:48] (viewOnlineReports) getConnection(): Resource id #1 [06 Aug 2020 21:34:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000629330', '001', '200367497', '1', '001000000000085611', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [06 Aug 2020 21:34:48] (viewOnlineReports) p_Stop=N [06 Aug 2020 21:34:48] (viewOnlineReports) p_Alert= [06 Aug 2020 21:34:48] (viewOnlineReports) Flag = 1 [06 Aug 2020 21:34:48] (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', '200367497', 'M01', '047', '1', '001000000000085611', 'M0100000629330_M01SCH20007850_1.PDF', 'M0100000629330', SYSDATE) [06 Aug 2020 21:34:48] (viewOnlineReports) database connection response [06 Aug 2020 21:34:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200367497' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [06 Aug 2020 21:34:48] (viewOnlineReports) database connection response [06 Aug 2020 21:34:48] (viewOnlineReports) getConnectionClose() called.... [06 Aug 2020 21:34:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200367497/ [06 Aug 2020 21:34:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200367497/ [06 Aug 2020 21:34:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200806\M01\M0100000629330_M01SCH20007850_1.PDF [06 Aug 2020 21:34:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200367497/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596731688M0100000629330_M01SCH20007850_1.PDF [06 Aug 2020 21:34:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200367497/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596731688M0100000629330_M01SCH20007850_1.PDF [06 Aug 2020 21:34:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [06 Aug 2020 21:34:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200367497/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596731688M0100000629330_M01SCH20007850_1.PDF