[09 Aug 2020 00:00:32] (viewOnlineReports) database connection response [09 Aug 2020 00:00:32] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 00:00:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000629606', '001', '200368731', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 00:00:32] (viewOnlineReports) p_Stop=N [09 Aug 2020 00:00:32] (viewOnlineReports) p_Alert= [09 Aug 2020 00:00:32] (viewOnlineReports) Flag = 1 [09 Aug 2020 00:00:32] (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', '200368731', 'M01', '070', '1', '001000000000087630', 'M0100000629606_M01MOL20006972_1.PDF', 'M0100000629606', SYSDATE) [09 Aug 2020 00:00:32] (viewOnlineReports) database connection response [09 Aug 2020 00:00:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368731' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 00:00:32] (viewOnlineReports) database connection response [09 Aug 2020 00:00:32] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 00:00:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368731/ [09 Aug 2020 00:00:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368731/ [09 Aug 2020 00:00:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000629606_M01MOL20006972_1.PDF [09 Aug 2020 00:00:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368731/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596913232M0100000629606_M01MOL20006972_1.PDF [09 Aug 2020 00:00:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368731/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596913232M0100000629606_M01MOL20006972_1.PDF [09 Aug 2020 00:00:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 00:00:32] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368731/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596913232M0100000629606_M01MOL20006972_1.PDF [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getConnection(): Resource id #1 [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200320817' AND ACCESS_CODE = '95313657' [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200320817' AND ACCESS_CODE = '95313657' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629603' [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getPatientReportsDetail() entered [09 Aug 2020 07:17:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200320817', 'M0100000629603', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 07:17:50] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200320817', 'M0100000629603', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 07:17:50] (index) p_Stop=N [09 Aug 2020 07:17:50] (index) p_Alert= [09 Aug 2020 07:17:50] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Aug 2020 07:17:50] (index) database connection response [09 Aug 2020 07:17:50] (index) getConnectionClose() called.... [09 Aug 2020 07:17:50] (index) getConnectionClose() called.... [09 Aug 2020 07:18:27] (viewOnlineReports) database connection response [09 Aug 2020 07:18:27] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 07:18:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000629603', '001', '200368719', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 07:18:27] (viewOnlineReports) p_Stop=N [09 Aug 2020 07:18:27] (viewOnlineReports) p_Alert= [09 Aug 2020 07:18:27] (viewOnlineReports) Flag = 1 [09 Aug 2020 07:18:27] (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', '200368719', 'M01', '070', '1', '001000000000087630', 'M0100000629603_M01MOL20006961_1.PDF', 'M0100000629603', SYSDATE) [09 Aug 2020 07:18:27] (viewOnlineReports) database connection response [09 Aug 2020 07:18:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368719' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 07:18:27] (viewOnlineReports) database connection response [09 Aug 2020 07:18:27] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 07:18:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368719/ [09 Aug 2020 07:18:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368719/ [09 Aug 2020 07:18:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368719/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1596939507M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368719/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1596939507M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Aug 2020 07:18:27] (viewOnlineReports) Converting PDF to JPG with name as M0100000629603_M01MOL20006961_1.jpg [09 Aug 2020 07:18:27] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368719/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1596939507M0100000629603_M01MOL20006961_1.PDF ../../TEMP_PDF/200368719/M0100000629603_M01MOL20006961_1.jpg [09 Aug 2020 07:18:27] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368719/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1596939507M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:58] (viewOnlineReports) database connection response [09 Aug 2020 07:18:58] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 07:18:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000629603', '001', '200368719', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 07:18:58] (viewOnlineReports) p_Stop=N [09 Aug 2020 07:18:58] (viewOnlineReports) p_Alert= [09 Aug 2020 07:18:58] (viewOnlineReports) Flag = 1 [09 Aug 2020 07:18: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', '200368719', 'M01', '070', '1', '001000000000087630', 'M0100000629603_M01MOL20006961_1.PDF', 'M0100000629603', SYSDATE) [09 Aug 2020 07:18:58] (viewOnlineReports) database connection response [09 Aug 2020 07:18:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368719' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 07:18:58] (viewOnlineReports) database connection response [09 Aug 2020 07:18:58] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 07:18:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368719/ [09 Aug 2020 07:18:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368719/ [09 Aug 2020 07:18:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596939538M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596939538M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:18:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 07:18:58] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596939538M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:19:27] (viewOnlineReports) database connection response [09 Aug 2020 07:19:27] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 07:19:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000629603', '001', '200368719', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 07:19:27] (viewOnlineReports) p_Stop=N [09 Aug 2020 07:19:27] (viewOnlineReports) p_Alert= [09 Aug 2020 07:19:27] (viewOnlineReports) Flag = 1 [09 Aug 2020 07:19:27] (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', '200368719', 'M01', '070', '1', '001000000000087630', 'M0100000629603_M01MOL20006961_1.PDF', 'M0100000629603', SYSDATE) [09 Aug 2020 07:19:27] (viewOnlineReports) database connection response [09 Aug 2020 07:19:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368719' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 07:19:27] (viewOnlineReports) database connection response [09 Aug 2020 07:19:27] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 07:19:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368719/ [09 Aug 2020 07:19:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368719/ [09 Aug 2020 07:19:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:19:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596939567M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:19:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596939567M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:19:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 07:19:27] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596939567M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:21:34] (viewOnlineReports) database connection response [09 Aug 2020 07:21:34] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 07:21:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000629603', '001', '200368719', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 07:21:34] (viewOnlineReports) p_Stop=N [09 Aug 2020 07:21:34] (viewOnlineReports) p_Alert= [09 Aug 2020 07:21:34] (viewOnlineReports) Flag = 1 [09 Aug 2020 07:21:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200368719', 'M01', '070', '1', '001000000000087630', 'M0100000629603_M01MOL20006961_1.PDF', 'M0100000629603', SYSDATE) [09 Aug 2020 07:21:34] (viewOnlineReports) database connection response [09 Aug 2020 07:21:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368719' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 07:21:34] (viewOnlineReports) database connection response [09 Aug 2020 07:21:34] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 07:21:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368719/ [09 Aug 2020 07:21:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368719/ [09 Aug 2020 07:21:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:21:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368719/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1596939694M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:21:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1596939694M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 07:21:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 07:21:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1596939694M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getConnection(): Resource id #1 [09 Aug 2020 11:39:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '83' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200320241' AND ACCESS_CODE = '43413602' [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200320241' AND ACCESS_CODE = '43413602' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000600705' [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getPatientReportsDetail() entered [09 Aug 2020 11:39:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200320241', 'M0100000600705', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 11:39:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200320241', 'M0100000600705', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 11:39:35] (index) p_Stop=N [09 Aug 2020 11:39:35] (index) p_Alert= [09 Aug 2020 11:39: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 [09 Aug 2020 11:39:35] (index) database connection response [09 Aug 2020 11:39:35] (index) getConnectionClose() called.... [09 Aug 2020 11:39:35] (index) getConnectionClose() called.... [09 Aug 2020 11:40:04] (viewOnlineReports) database connection response [09 Aug 2020 11:40:04] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 11:40:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000600705', '001', '200368511', '1', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 11:40:04] (viewOnlineReports) p_Stop=N [09 Aug 2020 11:40:04] (viewOnlineReports) p_Alert= [09 Aug 2020 11:40:04] (viewOnlineReports) Flag = 1 [09 Aug 2020 11:40: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', '200368511', 'M01', '047', '1', '001000000000082306', 'M0100000600705_M01SCH20007931_1.PDF', 'M0100000600705', SYSDATE) [09 Aug 2020 11:40:04] (viewOnlineReports) database connection response [09 Aug 2020 11:40:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368511' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [09 Aug 2020 11:40:04] (viewOnlineReports) database connection response [09 Aug 2020 11:40:04] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 11:40:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368511/ [09 Aug 2020 11:40:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368511/ [09 Aug 2020 11:40:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000600705_M01SCH20007931_1.PDF [09 Aug 2020 11:40:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368511/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1596955204M0100000600705_M01SCH20007931_1.PDF [09 Aug 2020 11:40:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368511/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1596955204M0100000600705_M01SCH20007931_1.PDF [09 Aug 2020 11:40:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 11:40:04] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368511/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1596955204M0100000600705_M01SCH20007931_1.PDF [09 Aug 2020 11:40:21] (viewOnlineReports) database connection response [09 Aug 2020 11:40:21] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 11:40:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000600705', '001', '200368511', '2', '001000000000082607', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 11:40:21] (viewOnlineReports) p_Stop=N [09 Aug 2020 11:40:21] (viewOnlineReports) p_Alert= [09 Aug 2020 11:40:21] (viewOnlineReports) Flag = 1 [09 Aug 2020 11:40:21] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200368511', 'M01', '047', '2', '001000000000082607', 'M0100000600705_M01SCH20007931_2.PDF', 'M0100000600705', SYSDATE) [09 Aug 2020 11:40:21] (viewOnlineReports) database connection response [09 Aug 2020 11:40:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368511' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [09 Aug 2020 11:40:21] (viewOnlineReports) database connection response [09 Aug 2020 11:40:21] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 11:40:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368511/ [09 Aug 2020 11:40:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368511/ [09 Aug 2020 11:40:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000600705_M01SCH20007931_2.PDF [09 Aug 2020 11:40:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368511/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1596955221M0100000600705_M01SCH20007931_2.PDF [09 Aug 2020 11:40:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368511/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1596955221M0100000600705_M01SCH20007931_2.PDF [09 Aug 2020 11:40:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 11:40:21] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368511/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1596955221M0100000600705_M01SCH20007931_2.PDF [09 Aug 2020 14:24:07] (index) database connection response [09 Aug 2020 14:24:07] (index) getConnection(): Resource id #1 [09 Aug 2020 14:24:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:24:07] (index) database connection response [09 Aug 2020 14:24:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:24:07] (index) database connection response [09 Aug 2020 14:24:07] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:24:07] (index) database connection response [09 Aug 2020 14:24:07] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200242607' AND ACCESS_CODE = '11199272' [09 Aug 2020 14:24:08] (index) database connection response [09 Aug 2020 14:24:08] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200242607' AND ACCESS_CODE = '11199272' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:24:08] (index) database connection response [09 Aug 2020 14:24:08] (index) getConnectionClose() called.... [09 Aug 2020 14:25:19] (index) database connection response [09 Aug 2020 14:25:19] (index) getConnection(): Resource id #1 [09 Aug 2020 14:25:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:25:19] (index) database connection response [09 Aug 2020 14:25:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:25:19] (index) database connection response [09 Aug 2020 14:25:19] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:25:19] (index) database connection response [09 Aug 2020 14:25:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200M32119' AND ACCESS_CODE = '11199272' [09 Aug 2020 14:25:19] (index) database connection response [09 Aug 2020 14:25:19] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200M32119' AND ACCESS_CODE = '11199272' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:25:19] (index) database connection response [09 Aug 2020 14:25:19] (index) getConnectionClose() called.... [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getConnection(): Resource id #1 [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200321190' AND ACCESS_CODE = '23227419' [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200321190' AND ACCESS_CODE = '23227419' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000491844' [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getPatientReportsDetail() entered [09 Aug 2020 14:25:49] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200321190', 'M0100000491844', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:25:49] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200321190', 'M0100000491844', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:25:49] (index) p_Stop=N [09 Aug 2020 14:25:49] (index) p_Alert= [09 Aug 2020 14:25:49] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Aug 2020 14:25:49] (index) database connection response [09 Aug 2020 14:25:49] (index) getConnectionClose() called.... [09 Aug 2020 14:25:49] (index) getConnectionClose() called.... [09 Aug 2020 14:25:54] (index) database connection response [09 Aug 2020 14:25:54] (index) getConnection(): Resource id #1 [09 Aug 2020 14:25:54] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:25:54] (index) database connection response [09 Aug 2020 14:25:54] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:25:54] (index) database connection response [09 Aug 2020 14:25:54] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:25:54] (index) database connection response [09 Aug 2020 14:25:54] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '01200321191' AND ACCESS_CODE = '11199272' [09 Aug 2020 14:25:54] (index) database connection response [09 Aug 2020 14:25:54] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '01200321191' AND ACCESS_CODE = '11199272' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:25:54] (index) database connection response [09 Aug 2020 14:25:54] (index) getConnectionClose() called.... [09 Aug 2020 14:26:11] (viewOnlineReports) database connection response [09 Aug 2020 14:26:11] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:26:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:26:11] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:26:11] (viewOnlineReports) p_Alert= [09 Aug 2020 14:26:11] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:26: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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:26:11] (viewOnlineReports) database connection response [09 Aug 2020 14:26:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:26:11] (viewOnlineReports) database connection response [09 Aug 2020 14:26:11] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:26:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:26:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:26:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596965171M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596965171M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 14:26:11] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368852/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596965171M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:32] (viewOnlineReports) database connection response [09 Aug 2020 14:26:32] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:26:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:26:32] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:26:32] (viewOnlineReports) p_Alert= [09 Aug 2020 14:26:32] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:26:32] (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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:26:32] (viewOnlineReports) database connection response [09 Aug 2020 14:26:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:26:32] (viewOnlineReports) database connection response [09 Aug 2020 14:26:32] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:26:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:26:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:26:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965192M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965192M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Aug 2020 14:26:32] (viewOnlineReports) Converting PDF to JPG with name as M0100000491844_M01MOL20006995_1.jpg [09 Aug 2020 14:26:32] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368852/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965192M0100000491844_M01MOL20006995_1.PDF ../../TEMP_PDF/200368852/M0100000491844_M01MOL20006995_1.jpg [09 Aug 2020 14:26:32] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368852/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965192M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:44] (viewOnlineReports) database connection response [09 Aug 2020 14:26:44] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:26:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:26:44] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:26:44] (viewOnlineReports) p_Alert= [09 Aug 2020 14:26:44] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:26:44] (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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:26:44] (viewOnlineReports) database connection response [09 Aug 2020 14:26:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:26:44] (viewOnlineReports) database connection response [09 Aug 2020 14:26:44] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:26:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:26:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:26:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596965204M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596965204M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Aug 2020 14:26:44] (viewOnlineReports) Converting PDF to JPG with name as M0100000491844_M01MOL20006995_1.jpg [09 Aug 2020 14:26:44] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596965204M0100000491844_M01MOL20006995_1.PDF ../../TEMP_PDF/200368852/M0100000491844_M01MOL20006995_1.jpg [09 Aug 2020 14:26:44] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1596965204M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getConnection(): Resource id #1 [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200321191' AND ACCESS_CODE = '11199272' [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200321191' AND ACCESS_CODE = '11199272' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629629' [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getPatientReportsDetail() entered [09 Aug 2020 14:26:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200321191', 'M0100000629629', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:26:48] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200321191', 'M0100000629629', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:26:48] (index) p_Stop=N [09 Aug 2020 14:26:48] (index) p_Alert= [09 Aug 2020 14:26:48] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Aug 2020 14:26:48] (index) database connection response [09 Aug 2020 14:26:48] (index) getConnectionClose() called.... [09 Aug 2020 14:26:48] (index) getConnectionClose() called.... [09 Aug 2020 14:27:01] (viewOnlineReports) database connection response [09 Aug 2020 14:27:01] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:27:01] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:27:01] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:27:01] (viewOnlineReports) p_Alert= [09 Aug 2020 14:27:01] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:27:01] (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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:27:01] (viewOnlineReports) database connection response [09 Aug 2020 14:27:01] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:27:01] (viewOnlineReports) database connection response [09 Aug 2020 14:27:01] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:27:01] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:27:01] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:27:01] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:01] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965221M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:01] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965221M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:01] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 14:27:01] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368852/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965221M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:08] (viewOnlineReports) database connection response [09 Aug 2020 14:27:08] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:27:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000629629', '001', '200368853', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:27:08] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:27:08] (viewOnlineReports) p_Alert= [09 Aug 2020 14:27:08] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:27:08] (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', '200368853', 'M01', '027', '1', '001000000000087630', 'M0100000629629_M01MOL20006994_1.PDF', 'M0100000629629', SYSDATE) [09 Aug 2020 14:27:08] (viewOnlineReports) database connection response [09 Aug 2020 14:27:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368853' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:27:08] (viewOnlineReports) database connection response [09 Aug 2020 14:27:08] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:27:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368853/ [09 Aug 2020 14:27:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368853/ [09 Aug 2020 14:27:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368853/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965228M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368853/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965228M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Aug 2020 14:27:08] (viewOnlineReports) Converting PDF to JPG with name as M0100000629629_M01MOL20006994_1.jpg [09 Aug 2020 14:27:08] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368853/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965228M0100000629629_M01MOL20006994_1.PDF ../../TEMP_PDF/200368853/M0100000629629_M01MOL20006994_1.jpg [09 Aug 2020 14:27:08] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368853/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965228M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:18] (viewOnlineReports) database connection response [09 Aug 2020 14:27:18] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:27:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000629629', '001', '200368853', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:27:18] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:27:18] (viewOnlineReports) p_Alert= [09 Aug 2020 14:27:18] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:27:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200368853', 'M01', '027', '1', '001000000000087630', 'M0100000629629_M01MOL20006994_1.PDF', 'M0100000629629', SYSDATE) [09 Aug 2020 14:27:18] (viewOnlineReports) database connection response [09 Aug 2020 14:27:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368853' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:27:18] (viewOnlineReports) database connection response [09 Aug 2020 14:27:18] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:27:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368853/ [09 Aug 2020 14:27:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368853/ [09 Aug 2020 14:27:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368853/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965238M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368853/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965238M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Aug 2020 14:27:18] (viewOnlineReports) Converting PDF to JPG with name as M0100000629629_M01MOL20006994_1.jpg [09 Aug 2020 14:27:18] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368853/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965238M0100000629629_M01MOL20006994_1.PDF ../../TEMP_PDF/200368853/M0100000629629_M01MOL20006994_1.jpg [09 Aug 2020 14:27:18] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368853/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596965238M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:29] (viewOnlineReports) database connection response [09 Aug 2020 14:27:29] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:27:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000629629', '001', '200368853', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:27:29] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:27:29] (viewOnlineReports) p_Alert= [09 Aug 2020 14:27:29] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:27: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', '200368853', 'M01', '027', '1', '001000000000087630', 'M0100000629629_M01MOL20006994_1.PDF', 'M0100000629629', SYSDATE) [09 Aug 2020 14:27:29] (viewOnlineReports) database connection response [09 Aug 2020 14:27:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368853' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:27:29] (viewOnlineReports) database connection response [09 Aug 2020 14:27:29] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:27:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368853/ [09 Aug 2020 14:27:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368853/ [09 Aug 2020 14:27:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368853/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596965249M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:29] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368853/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596965249M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:29] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 14:27:29] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368853/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596965249M0100000629629_M01MOL20006994_1.PDF [09 Aug 2020 14:27:31] (viewOnlineReports) database connection response [09 Aug 2020 14:27:31] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:27:31] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:27:31] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:27:31] (viewOnlineReports) p_Alert= [09 Aug 2020 14:27:31] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:27:31] (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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:27:31] (viewOnlineReports) database connection response [09 Aug 2020 14:27:31] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:27:31] (viewOnlineReports) database connection response [09 Aug 2020 14:27:31] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:27:31] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:27:31] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:27:31] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:31] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1596965251M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:31] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1596965251M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:31] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 14:27:31] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1596965251M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:48] (viewOnlineReports) database connection response [09 Aug 2020 14:27:48] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:27:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:27:48] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:27:48] (viewOnlineReports) p_Alert= [09 Aug 2020 14:27:48] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:27: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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:27:48] (viewOnlineReports) database connection response [09 Aug 2020 14:27:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:27:48] (viewOnlineReports) database connection response [09 Aug 2020 14:27:48] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:27:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:27:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:27:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1596965268M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1596965268M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:27:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 14:27:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368852/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1596965268M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getConnection(): Resource id #1 [09 Aug 2020 14:28:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200321190' AND ACCESS_CODE = '23227419' [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200321190' AND ACCESS_CODE = '23227419' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000491844' [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getPatientReportsDetail() entered [09 Aug 2020 14:28:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200321190', 'M0100000491844', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:28:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200321190', 'M0100000491844', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:28:34] (index) p_Stop=N [09 Aug 2020 14:28:34] (index) p_Alert= [09 Aug 2020 14:28: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 [09 Aug 2020 14:28:34] (index) database connection response [09 Aug 2020 14:28:34] (index) getConnectionClose() called.... [09 Aug 2020 14:28:34] (index) getConnectionClose() called.... [09 Aug 2020 14:28:38] (viewOnlineReports) database connection response [09 Aug 2020 14:28:38] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:28:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000491844', '001', '200368852', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:28:38] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:28:38] (viewOnlineReports) p_Alert= [09 Aug 2020 14:28:38] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:28:38] (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', '200368852', 'M01', '027', '1', '001000000000087630', 'M0100000491844_M01MOL20006995_1.PDF', 'M0100000491844', SYSDATE) [09 Aug 2020 14:28:38] (viewOnlineReports) database connection response [09 Aug 2020 14:28:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368852' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [09 Aug 2020 14:28:38] (viewOnlineReports) database connection response [09 Aug 2020 14:28:38] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:28:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368852/ [09 Aug 2020 14:28:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368852/ [09 Aug 2020 14:28:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200809\M01\M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:28:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1596965318M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:28:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1596965318M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:28:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 14:28:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368852/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1596965318M0100000491844_M01MOL20006995_1.PDF [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getConnection(): Resource id #1 [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200320720' AND ACCESS_CODE = '58276901' [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200320720' AND ACCESS_CODE = '58276901' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000535590' [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getPatientReportsDetail() entered [09 Aug 2020 14:41:26] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200320720', 'M0100000535590', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:41:26] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200320720', 'M0100000535590', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:41:26] (index) p_Stop=N [09 Aug 2020 14:41:26] (index) p_Alert= [09 Aug 2020 14:41:26] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [09 Aug 2020 14:41:26] (index) database connection response [09 Aug 2020 14:41:26] (index) getConnectionClose() called.... [09 Aug 2020 14:41:26] (index) getConnectionClose() called.... [09 Aug 2020 14:42:43] (viewOnlineReports) database connection response [09 Aug 2020 14:42:43] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:42:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000535590', '001', '200368684', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:42:43] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:42:43] (viewOnlineReports) p_Alert= [09 Aug 2020 14:42:43] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:42:43] (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', '200368684', 'M01', '070', '1', '001000000000087630', 'M0100000535590_M01MOL20006964_1.PDF', 'M0100000535590', SYSDATE) [09 Aug 2020 14:42:43] (viewOnlineReports) database connection response [09 Aug 2020 14:42:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368684' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 14:42:43] (viewOnlineReports) database connection response [09 Aug 2020 14:42:43] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:42:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368684/ [09 Aug 2020 14:42:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368684/ [09 Aug 2020 14:42:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:42:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368684/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596966163M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:42:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368684/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596966163M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:42:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Aug 2020 14:42:43] (viewOnlineReports) Converting PDF to JPG with name as M0100000535590_M01MOL20006964_1.jpg [09 Aug 2020 14:42:43] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368684/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596966163M0100000535590_M01MOL20006964_1.PDF ../../TEMP_PDF/200368684/M0100000535590_M01MOL20006964_1.jpg [09 Aug 2020 14:42:43] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368684/0123456789ABCDEFGIJKLMNOPQRSTUVWXYZ1596966163M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:23] (viewOnlineReports) database connection response [09 Aug 2020 14:43:23] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:43:23] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000535590', '001', '200368684', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:43:23] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:43:23] (viewOnlineReports) p_Alert= [09 Aug 2020 14:43:23] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:43:23] (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', '200368684', 'M01', '070', '1', '001000000000087630', 'M0100000535590_M01MOL20006964_1.PDF', 'M0100000535590', SYSDATE) [09 Aug 2020 14:43:23] (viewOnlineReports) database connection response [09 Aug 2020 14:43:23] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368684' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 14:43:23] (viewOnlineReports) database connection response [09 Aug 2020 14:43:23] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:43:23] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368684/ [09 Aug 2020 14:43:23] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368684/ [09 Aug 2020 14:43:23] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:23] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368684/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596966203M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:23] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368684/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596966203M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:23] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 14:43:23] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368684/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1596966203M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:43] (viewOnlineReports) database connection response [09 Aug 2020 14:43:43] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:43:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000535590', '001', '200368684', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:43:43] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:43:43] (viewOnlineReports) p_Alert= [09 Aug 2020 14:43:43] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:43:43] (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', '200368684', 'M01', '070', '1', '001000000000087630', 'M0100000535590_M01MOL20006964_1.PDF', 'M0100000535590', SYSDATE) [09 Aug 2020 14:43:43] (viewOnlineReports) database connection response [09 Aug 2020 14:43:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368684' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 14:43:43] (viewOnlineReports) database connection response [09 Aug 2020 14:43:43] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:43:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368684/ [09 Aug 2020 14:43:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368684/ [09 Aug 2020 14:43:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966223M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966223M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:43:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 14:43:43] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966223M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:28] (viewOnlineReports) database connection response [09 Aug 2020 14:45:28] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:45:28] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000535590', '001', '200368684', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:45:28] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:45:28] (viewOnlineReports) p_Alert= [09 Aug 2020 14:45:28] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:45:28] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200368684', 'M01', '070', '1', '001000000000087630', 'M0100000535590_M01MOL20006964_1.PDF', 'M0100000535590', SYSDATE) [09 Aug 2020 14:45:28] (viewOnlineReports) database connection response [09 Aug 2020 14:45:28] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368684' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 14:45:28] (viewOnlineReports) database connection response [09 Aug 2020 14:45:28] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:45:28] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368684/ [09 Aug 2020 14:45:28] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368684/ [09 Aug 2020 14:45:28] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:28] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368684/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596966328M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:28] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368684/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596966328M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:28] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> INBROWSER [09 Aug 2020 14:45:28] (viewOnlineReports) Converting PDF to JPG with name as M0100000535590_M01MOL20006964_1.jpg [09 Aug 2020 14:45:28] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368684/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596966328M0100000535590_M01MOL20006964_1.PDF ../../TEMP_PDF/200368684/M0100000535590_M01MOL20006964_1.jpg [09 Aug 2020 14:45:28] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368684/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1596966328M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:50] (viewOnlineReports) database connection response [09 Aug 2020 14:45:50] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:45:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000535590', '001', '200368684', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:45:50] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:45:50] (viewOnlineReports) p_Alert= [09 Aug 2020 14:45:50] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:45: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', '200368684', 'M01', '070', '1', '001000000000087630', 'M0100000535590_M01MOL20006964_1.PDF', 'M0100000535590', SYSDATE) [09 Aug 2020 14:45:50] (viewOnlineReports) database connection response [09 Aug 2020 14:45:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368684' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 14:45:50] (viewOnlineReports) database connection response [09 Aug 2020 14:45:50] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:45:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368684/ [09 Aug 2020 14:45:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368684/ [09 Aug 2020 14:45:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596966350M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596966350M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:45:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [09 Aug 2020 14:45:50] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1596966350M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:46:00] (viewOnlineReports) database connection response [09 Aug 2020 14:46:00] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 14:46:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000535590', '001', '200368684', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 14:46:00] (viewOnlineReports) p_Stop=N [09 Aug 2020 14:46:00] (viewOnlineReports) p_Alert= [09 Aug 2020 14:46:00] (viewOnlineReports) Flag = 1 [09 Aug 2020 14:46:00] (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', '200368684', 'M01', '070', '1', '001000000000087630', 'M0100000535590_M01MOL20006964_1.PDF', 'M0100000535590', SYSDATE) [09 Aug 2020 14:46:00] (viewOnlineReports) database connection response [09 Aug 2020 14:46:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368684' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 14:46:00] (viewOnlineReports) database connection response [09 Aug 2020 14:46:00] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 14:46:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368684/ [09 Aug 2020 14:46:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368684/ [09 Aug 2020 14:46:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:46:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966360M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:46:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966360M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 14:46:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [09 Aug 2020 14:46:00] (viewOnlineReports) Converting PDF to JPG with name as M0100000535590_M01MOL20006964_1.jpg [09 Aug 2020 14:46:00] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966360M0100000535590_M01MOL20006964_1.PDF ../../TEMP_PDF/200368684/M0100000535590_M01MOL20006964_1.jpg [09 Aug 2020 14:46:00] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200368684/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596966360M0100000535590_M01MOL20006964_1.PDF [09 Aug 2020 17:44:30] (viewOnlineReports) database connection response [09 Aug 2020 17:44:30] (viewOnlineReports) getConnection(): Resource id #1 [09 Aug 2020 17:44:30] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', '00100000000000', '001', '200368719', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [09 Aug 2020 17:44:30] (viewOnlineReports) p_Stop=N [09 Aug 2020 17:44:30] (viewOnlineReports) p_Alert= [09 Aug 2020 17:44:30] (viewOnlineReports) Flag = 1 [09 Aug 2020 17:44:30] (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', '200368719', 'M01', '070', '1', '001000000000087630', 'M0100000629603_M01MOL20006961_1.PDF', '00100000000000', SYSDATE) [09 Aug 2020 17:44:30] (viewOnlineReports) database connection response [09 Aug 2020 17:44:30] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200368719' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [09 Aug 2020 17:44:30] (viewOnlineReports) database connection response [09 Aug 2020 17:44:30] (viewOnlineReports) getConnectionClose() called.... [09 Aug 2020 17:44:30] (viewOnlineReports) creating directory structure../../TEMP_PDF/200368719/ [09 Aug 2020 17:44:30] (viewOnlineReports) directory structure created ../../TEMP_PDF/200368719/ [09 Aug 2020 17:44:30] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200808\M01\M0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 17:44:30] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZM0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 17:44:30] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZM0100000629603_M01MOL20006961_1.PDF [09 Aug 2020 17:44:30] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [09 Aug 2020 17:44:30] (viewOnlineReports) Downloading file ../../TEMP_PDF/200368719/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZM0100000629603_M01MOL20006961_1.PDF