/* * Copyright 2018~2023 SYSON, MICHAEL B. * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * @company: USBONG * @author: SYSON, MICHAEL B. * @date created: 20201023 * @last updated: 20230215; from 20210510 * @website address: http://www.usbong.ph * */ //TO-DO: -delete: excess instructions //added by Mike, 20201024 import org.json.JSONObject; import org.json.JSONArray; //added by Mike, 20201023 import java.util.Date; import java.text.DateFormat; import java.text.SimpleDateFormat; //TO-DO: -update: this import java.util.*; import java.io.File; import java.io.FileInputStream; import java.io.PrintWriter; import java.util.regex.Pattern; import java.util.regex.Matcher; import java.text.NumberFormat; import java.text.DecimalFormat; //import java.lang.Integer; //import commons-lang3-3.8.1; //import org.apache.commons.lang3.StringUtils; import org.apache.commons.text.similarity.LevenshteinDistance; import java.util.Map.Entry; //added by Mike, 20190417 import utils.IncidenceNumberComparator; //added by Mike, 20190418 //removed by Mike, 20201023 //import utils.UsbongUtils; //added by Mike, 20190622 //TO-DO:-update: this /* ' Given: ' 1) Encoding for the Month Input Worksheet ' --> Saved/Exported as "Tab delimited" .txt file from Excel ' --> Example: input_201808.txt (where the date format is YYYYMM; based on ISO 8601) ' ' Output: ' 1) Auto-generated Monthly Summary Report ' --> "Tab delimited" .txt file ' --> Regardless of the name of the input file or input files, the output file will be "MonthlySummaryReportOutput.txt", which is located inside an "output" folder that is in the same directory as the add-on software ' ' Notes: ' 1) To execute the add-on software/application simply use the following command: ' java generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles input_201801.txt ' ' where: "input_201801.txt" is the name of the file. ' ' 2) To execute a set of input files, e.g. input201801.txt, input201802.txt, you can use the following command: ' java generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles input* ' ' where: "input*" means any file in the directory that starts with "input". ' ' 3) Make sure to include "Consultation" in the input file name. ' --> This is so that the add-on software would be able to properly identify it as a set of "Consultation" transactions, instead of those of "Treatment". ' --> Example: inputConsultation201801.txt ' ' 4) If you use space in your file name, e.g. "input Consultation 201801.txt", you will have to execute the input files as follows. ' java generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles *"2018"*.txt ' ' where: * means any set of characters ' ' 5) To compile on Windows' Command Prompt the add-on software with the Apache Commons Text .jar file, i.e. org.apache.commons.text, use the following command: ' javac -cp .;org.json.jar;org.apache.commons.text.jar generateMOSCSummaryReportDailyCount.java ' ' Note: ' To compile on Linux Terminal: ' javac -cp .:org.json.jar:org.apache.commons.text.jar generateMOSCSummaryReportDailyCount.java ' ' 6) To execute on Windows' Command Prompt the add-on software with the Apache Commons Text .jar file, i.e. org.apache.commons.text, use the following command: ' java -cp .;org.json.jar;org.apache.commons.text.jar generateMOSCSummaryReportDailyCount ./input/cashier/ ' ' Note: ' To execute on Linux Terminal: ' java -cp .:org.json.jar:org.apache.commons.text.jar generateMOSCSummaryReportDailyCount ./input/cashier/ ' ' 7) The Apache Commons Text binaries with the .jar file can be downloaded here: ' http://commons.apache.org/proper/commons-text/download_text.cgi; last accessed: 20190123 ' ' 8) The documentation for the LevenshteinDistance can be viewed here: ' https://commons.apache.org/proper/commons-text/javadocs/api-release/org/apache/commons/text/similarity/LevenshteinDistance.html; last accessed: 20190123 */ //TO-DO: -delete: excess instructions //TO-DO: -add: do not include NC in count public class generateMOSCSummaryReportDailyCount { private static boolean isInDebugMode = true; //edited by Mike, 20190131 private static boolean isNetPFComputed = false; //added by Mike, 20190131 //added by Mike, 20201023 private static String[] medicalDoctorsList; private static int medicalDoctorsListMaxCount; private static String inputFilename = "input201801"; //without extension; default input file //added by Mike, 20190413; edited by Mike, 20190604 private static String diagnosedCasesListInputFilename = "KnownDiagnosedCasesList"; //without extension; default input file //added by Mike, 20201023 private static String inputOutputTemplateFilenameMOSCSummaryReportDailyCount = "assets\\templates\\generateMOSCSummaryReportDailyCountOutputTemplate";//without extension; default input file //Note that I have to use double backslash, i.e. "\\", to use "\" in the filename //added by Mike, 20190414 private static String inputOutputTemplateFilenameTreatment = "assets\\templates\\generateMonthlySummaryReportOutputTemplateTreatment";//without extension; default input file //Note that I have to use double backslash, i.e. "\\", to use "\" in the filename //added by Mike, 20190422 private static String inputOutputTemplateFilenameConsultation = "assets\\templates\\generateMonthlySummaryReportOutputTemplateConsultation";//without extension; default input file //Note that I have to use double backslash, i.e. "\\", to use "\" in the filename //added by Mike, 20190426 private static String inputOutputTemplateFilenameTreatmentUnclassifiedDiagnosedCases = "assets\\templates\\generateMonthlySummaryReportOutputTemplateTreatmentUnclassifiedDiagnosedCases";//without extension; default input file //Note that I have to use double backslash, i.e. "\\", to use "\" in the filename //added by Mike, 20190503; edited by Mike, 20190504 //Note that I have to use double backslash, i.e. "\\", to use "\" in the filename //without extension; default input file //edited by Mike, 20201024 //Windows Machine // private static String inputOutputTemplateFilenameMonthlyStatistics = "assets\\templates\\generateMonthlySummaryReportOutputTemplateMonthlyStatisticsMOSC"; //added by Mike, 20201024 //Linux Machine private static String inputOutputTemplateFilenameMonthlyStatistics = "./assets/templates/generateMonthlySummaryReportOutputTemplateMonthlyStatisticsMOSC"; //edited by Mike, 20201024 private static String inputDataFilenameTreatmentMonthlyStatistics = "assets\\transactions\\treatmentCountList"; //removed by Mike, 20201024 //Windows Machine //private static String inputDataFilenameConsultationMonthlyStatistics = "assets\\transactions\\consultationCountList"; //added by Mike, 20201024 //Linux Machine private static String inputDataFilenameConsultationMonthlyStatistics = "./assets/transactions/consultationCountList"; private static String inputDataFilenameProcedureMonthlyStatistics = "assets\\transactions\\procedureCountList"; //added by Mike, 20190504 private static final int TREATMENT_FILE_TYPE = 0; private static final int CONSULTATION_FILE_TYPE = 1; private static final int PROCEDURE_FILE_TYPE = 2; private static String startDate = null; private static String endDate = null; //added by Mike, 20190127 private static final int HMO_CONTAINER_TYPE = 0; private static final int NON_HMO_CONTAINER_TYPE = 1; private static final int REFERRING_DOCTOR_CONTAINER_TYPE = 2; private static final int HMO_CLASSIFICATION_CONTAINER_PER_MEDICAL_DOCTOR_CONTAINER_TYPE = 3; private static final int NON_HMO_CLASSIFICATION_CONTAINER_PER_MEDICAL_DOCTOR_CONTAINER_TYPE = 4; //added by Mike, 20190131 private static final int INPUT_NON_MASTER_LIST_OFFSET = 1; //edited by Mike, 20190424 private static final int INPUT_REFERRING_DOCTOR_COLUMN = 15-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NOTES_COLUMN = 0; //This column is not included in the INPUT_NON_MASTER_LIST_OFFSET private static final int INPUT_DATE_COLUMN = 1-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NAME_COLUMN = 3-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_CLASS_COLUMN = 8-INPUT_NON_MASTER_LIST_OFFSET; //HMO and NON-HMO private static final int INPUT_NET_PF_COLUMN = 10-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NEW_OLD_COLUMN = 16-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NEW_OLD_PATIENT_COLUMN = 16-INPUT_NON_MASTER_LIST_OFFSET; //added by Mike, 20190102 private static final int INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN = 16-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_CONSULTATION_CLASS_COLUMN = 9-INPUT_NON_MASTER_LIST_OFFSET; //HMO and NON-HMO private static final int INPUT_CONSULTATION_NET_PF_COLUMN = 11-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_CONSULTATION_NEW_OLD_COLUMN = 17-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_CONSULTATION_NEW_OLD_PATIENT_COLUMN = 17-INPUT_NON_MASTER_LIST_OFFSET; //added by Mike, /* private static final int INPUT_REFERRING_DOCTOR_COLUMN = 15-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NOTES_COLUMN = 0; //This column is not included in the INPUT_NON_MASTER_LIST_OFFSET private static final int INPUT_DATE_COLUMN = 1-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NAME_COLUMN = 3-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_CLASS_COLUMN = 8-INPUT_NON_MASTER_LIST_OFFSET; //HMO and NON-HMO private static final int INPUT_NET_PF_COLUMN = 10-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NEW_OLD_COLUMN = 16-INPUT_NON_MASTER_LIST_OFFSET; private static final int INPUT_NEW_OLD_PATIENT_COLUMN = 16-INPUT_NON_MASTER_LIST_OFFSET; //added by Mike, 20190102 */ //TO-DO: -add: column for Consultation transactions, which have both Chief Complaint and Diagnosis private static final int INPUT_DIAGNOSIS_COLUMN = 6-INPUT_NON_MASTER_LIST_OFFSET; //added by Mike, 20190413 //edited by Mike, 20190425 private static final int INPUT_CONSULTATION_PROCEDURE_COLUMN = 2-INPUT_NON_MASTER_LIST_OFFSET; // private static final int INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN = 16-INPUT_NON_MASTER_LIST_OFFSET; //added by Mike, 20190107 private static final int INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN = 2-INPUT_NON_MASTER_LIST_OFFSET; //The int value is the same as "INPUT_CONSULTATION_PROCEDURE_COLUMN". //added by Mike, 20181218 //CONSULTATION /* private static final int INPUT_CONSULTATION_CLASS_COLUMN = 9; private static final int INPUT_CONSULTATION_NET_PF_COLUMN = 11; private static final int INPUT_CONSULTATION_NEW_OLD_COLUMN = 17; */ //edited by Mike, 20190423 // private static final int INPUT_CONSULTATION_OFFSET = 1; //added by Mike, 20190412 private static final int INPUT_KNOWN_DIAGNOSED_CASES_LIST_CLASSIFICATION_COLUMN = 0; private static final int INPUT_KNOWN_DIAGNOSED_CASES_LIST_SUB_CLASSIFICATION_COLUMN = 1; /* private static HashMap referringDoctorContainer; */ private static HashMap dateContainer; //added by Mike, 201801205 private static HashMap hmoContainer; //added by Mike, 201801217 private static HashMap nonHmoContainer; //added by Mike, 201801217 private static HashMap referringDoctorContainer; //added by Mike, 20181218 private static HashMap medicalDoctorContainer; //added by Mike, 20190202 private static HashMap diagnosedCasesContainer; //added by Mike, 20190412 // private static HashMap knownDiagnosedCasesContainer; //added by Mike, 20190412 private static ArrayList knownDiagnosedCasesContainerArrayList; //edited by Mike, 20190430 private static HashMap classifiedDiagnosedCasesContainer; //added by Mike, 20190412 private static HashMap treatmentMonthlyStatisticsContainer; //added by Mike, 20190503 private static HashMap consultationMonthlyStatisticsContainer; //added by Mike, 20190504 private static HashMap procedureMonthlyStatisticsContainer; //added by Mike, 20190504 //added by Mike, 20201023 private static HashMap moscSummaryReportDailyCountContainer; private static ArrayList yearsContainerArrayList; //added by Mike, 20190503 private static double[] columnValuesArray; private static String[] dateValuesArray; //added by Mike, 20180412 private static int[] dateValuesArrayInt; //added by Mike, 20181206 //private static ArrayList dateValuesArrayInt; //edited by Mike, 20181221 private static String dateValue; //added by Mike, 20190427 private static int dateValueInt; //added by Mike, 20190427 //the date and the referring doctor are not yet included here //this is for both HMO and NON-HMO transactions private static final int OUTPUT_TOTAL_COLUMNS = 25; //edited by Mike, 20190202 //PT TREATMENT private static final int OUTPUT_HMO_COUNT_COLUMN = 0; //transaction count private static final int OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN = 1; private static final int OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN = 2; private static final int OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN = 3; private static final int OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN = 4; private static final int OUTPUT_HMO_OLD_PATIENT_COUNT_COLUMN = 5; //added by Mike, 20190102 private static final int OUTPUT_NON_HMO_COUNT_COLUMN = 6; //transaction count private static final int OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN = 7; private static final int OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN = 8; private static final int OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN = 9; private static final int OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN = 10; private static final int OUTPUT_NON_HMO_OLD_PATIENT_COUNT_COLUMN = 11; //added by Mike, 20190102 private static final int OUTPUT_DATE_ID_COLUMN = 12; //added by Mike, 20181205 //CONSULTATION private static final int OUTPUT_CONSULTATION_HMO_COUNT_COLUMN = 13; //transaction count private static final int OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN = 14; //transaction count private static final int OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN = 15; //transaction count private static final int OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN = 16; //transaction count private static final int OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN = 17; //transaction count; added by Mike, 20190107 private static final int OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN = 18; //transaction count; added by Mike, 20190107 private static final int OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN = 19; //transaction count; added by Mike, 20190107 private static final int OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN = 20; //transaction count; added by Mike, 20190107 private static final int OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN = 21; //added by Mike, 20190202 private static final int OUTPUT_CONSULTATION_NON_HMO_OLD_PATIENT_COUNT_COLUMN = 22; //added by Mike, 20190202 private static final int OUTPUT_CONSULTATION_HMO_FOLLOW_UP_COUNT_COLUMN = 23; //added by Mike, 20190202 private static final int OUTPUT_CONSULTATION_NON_HMO_FOLLOW_UP_COUNT_COLUMN = 24; //added by Mike, 20190202 private static boolean isConsultation; private static DecimalFormat df = new DecimalFormat("0.00"); //added by Mike, 20181105 private static int rowCount; //added by Mike, 20181105 private static int totalCountForAllReferringDoctors; private static double totalNetTreatmentFeeForAllReferringDoctors; private static double totalPaidNetTreatmentFeeForAllReferringDoctors; private static double totalUnpaidNetTreatmentFeeForAllReferringDoctors; private static double totalFivePercentShareOfNetPaidForAllReferringDoctors; //added by Mike, 20181220 private static HashMap> classificationContainerPerMedicalDoctor = new HashMap>(); private static HashMap classificationContainerHashmap = new HashMap(); private static double[] classificationContainerColumnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; private static boolean hasSetClassificationContainerPerMedicalDoctor=false; //added by Mike, 20190126 private static LevenshteinDistance myLevenshteinDistance; //added by Mike, 20190415 private static int totalTreatmentCount = 0; //edited by Mike, 20201027 //This is so that the computer does not write a zero (0) value for the month 1, i.e. January private static int totalConsultationCount = -1; //0; private static int totalProcedureCount = 0; private static int totalMedicalCertificateCount = 0; //added by Mike, 20190416 private static int totalReferringMedicalDoctorTransactionCount = 0; private static int totalMedicalDoctorTransactionCount = 0; //added by Mike, 20190426 private static int totalNewPatientReferralTransactionCount = 0; private static int totalConsultationPerDoctorCount = 0; private static int totalProcedurePerDoctorCount = 0; private static int totalMedicalCertificatePerDoctorCount = 0; private static int totalNewPatientPerDoctorCount = 0; private static int totalFollowUpPerDoctorCount = 0; private static int totalOldPatientPerDoctorCount = 0; private static int totalTreatmentNewCasesCount = 0; //added by Mike, 20190426 //added by Mike, 20190426 private static int totalDiagnosedCaseCount = 0; //added by Mike, 20190416 private static final String classificationWI = "WI"; private static final String classificationWI_MCDO = "WI (C/O MCDO)"; //added by Mike, 20190424 private static final String classificationSLC = "SLC"; private static final String classificationSC = "SC"; private static final String classificationPWD = "PWD"; private static final String classificationNO_CHARGE = "NO CHARGE"; //added by Mike, 20190425 private static final String classificationSLR = "SLR"; //added by Mike, 20190425 //added by Mike, 20190417 private static double totalTreatmentHMOCount = 0; private static double totalConsultationHMOCount = 0; private static double totalProcedureHMOCount = 0; private static double totalMedicalCertificateHMOCount = 0; private static double totalNewPatientTreatmentHMOCount = 0; private static double totalNewPatientConsultationHMOCount = 0; //added by Mike, 20190429 private static double totalTreatmentNonHMOCount = 0; private static double totalConsultationNonHMOCount = 0; private static double totalProcedureNonHMOCount = 0; private static double totalMedicalCertificateNonHMOCount = 0; private static double totalNewPatientTreatmentNonHMOCount = 0; private static double totalNewPatientConsultationNonHMOCount = 0; //added by Mike, 20190429 private static int totalNewPatientTreatment = 0; //added by Mike, 20190425 private static int totalWiValue = 0; private static int noChargeValue = 0; private static int slcValue = 0; private static int slrValue = 0; private static int scValue = 0; private static int pwdValue = 0; //added by Mike, 20190426 private static boolean isConsultationInputFileEmpty=true; private static boolean isTreatmentInputFileEmpty=true; //added by Mike, 20190427 private static double treatmentCount; private static double consultationCount; private static double procedureCount; private static double medicalCertificateCount; //added by Mike, 20190622; removed by Mike, 20201023 //private static UsbongUtils myUsbongUtils; public static void main ( String[] args ) throws Exception { makeFilePath("output"); //"output" is the folder where I've instructed the add-on software/application to store the output file //added by Mike, 20201023; edited by Mike, 20210502 // medicalDoctorsList = new String[7]; //String[1]; medicalDoctorsList = new String[8]; //String[1]; medicalDoctorsList[0] = "SYSON,PEDRO"; medicalDoctorsList[1] = "SYSON,PETER"; medicalDoctorsList[2] = "REJUSO,CHASTITYAMOR"; medicalDoctorsList[3] = "DELAPAZ,RODIL"; medicalDoctorsList[4] = "LASAM,HONESTO"; medicalDoctorsList[5] = "BALCE,GRACIACIELO"; medicalDoctorsList[6] = "ESPINOSA,JHONSEL"; //added by Mike, 20210502 medicalDoctorsList[7] = "REJUSO-MORALES,CHASTITYAMOR"; /* // medicalDoctorsList = new String[7]; //String[1]; medicalDoctorsList = new String[1]; // medicalDoctorsList[0] = "SYSON,PEDRO"; // medicalDoctorsList[0] = "SYSON,PETER"; // medicalDoctorsList[0] = "REJUSO,CHASTITYAMOR"; // medicalDoctorsList[0] = "DELAPAZ,RODIL"; // medicalDoctorsList[0] = "LASAM,HONESTO"; medicalDoctorsList[0] = "BALCE,GRACIACIELO"; // medicalDoctorsList[0] = "ESPINOSA,JHONSEL"; */ medicalDoctorsListMaxCount = medicalDoctorsList.length; //added by Mike, 20201023; edited by Mike, 20201026 // PrintWriter moscSummaryReportDailyCountWriter = new PrintWriter("output/MOSCSummaryReportDailyCountOutput.html", "UTF-8"); PrintWriter consultationCountMonthlyStatisticsWriter = new PrintWriter("output/MOSCSummaryReportDailyCountOutput.html", "UTF-8"); dateContainer = new HashMap(); hmoContainer = new HashMap(); nonHmoContainer = new HashMap(); referringDoctorContainer = new HashMap(); // medicalDoctorContainer = new HashMap(); classificationContainerPerMedicalDoctor = new HashMap>(); medicalDoctorContainer = new HashMap(); //added by Mike, 20190202 diagnosedCasesContainer = new HashMap(); //added by Mike, 20190412 // knownDiagnosedCasesContainer = new HashMap(); //added by Mike, 20190412 knownDiagnosedCasesContainerArrayList = new ArrayList(); //edited by Mike, 20190430 classifiedDiagnosedCasesContainer = new HashMap(); //added by Mike, 20190412 treatmentMonthlyStatisticsContainer = new HashMap(); //added by Mike, 20190503 consultationMonthlyStatisticsContainer = new HashMap(); //added by Mike, 20190504 procedureMonthlyStatisticsContainer = new HashMap(); //added by Mike, 20190504 //added by Mike, 20201023 moscSummaryReportDailyCountContainer = new HashMap(); //added by Mike, 20181116 startDate = null; //properly set the month and year in the output file of each input file //edited by Mike, 20201025 // dateValuesArray = new String[args.length]; //added by Mike, 20180412 dateValuesArray = new String[12]; //edited by Mike, 20201025 // dateValuesArrayInt = new int[args.length]; //added by Mike, 20180412 dateValuesArrayInt = new int[12]; //dateValuesArrayInt = new ArrayList(); //edited by Mike, 20181221 /* //removed by Mike, 20201023 //added by Mike, 20190412 //PART/COMPONENT/MODULE/PHASE 1 processKnownDiagnosedCasesInputFile(args); */ /* //removed by Mike, 20201023 //added by Mike, 20201023 DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); Date myDate = new Date(); System.out.println(dateFormat.format(myDate)); // myDate = addDay(myDate, -1); // System.out.println(dateFormat.format(myDate)); for(int i=0; i>> Compare the Difference between Strings!"); System.out.println(myLevenshteinDistance.apply("1234567890", "1")); //answer: 9 System.out.println(myLevenshteinDistance.apply("123", "123")); //answer: 0 System.out.println(myLevenshteinDistance.apply("123", "132")); //answer: 2 System.out.println(myLevenshteinDistance.apply("132", "1 32")); //answer: 1 */ //added by Mike, 20190415; edited by Mike, 20190426 processAutoCalculate(); /* * -------------------------------------------------------------------- * OUTPUT * -------------------------------------------------------------------- */ // System.out.println("args[0]: " + args[0]); //edited by Mike, 20190131 /*writer.print("Monthly Summary Report\n"); */ //added by Mike, 20201024 processWriteOutputFileMonthlyStatistics(consultationCountMonthlyStatisticsWriter, CONSULTATION_FILE_TYPE); //added by Mike, 20190803 //note that I moved these instructions here, so that if there is an error in the processing that the computer executes before these, the lists will not be blank //removed by Mike, 20210502 // PrintWriter consultationCountListTempWriter = new PrintWriter("assets/transactions/consultationCountListTemp.txt", "UTF-8"); //added by Mike, 20201027 //TO-DO: -add: "MOSC" keyword in temporary file PrintWriter moscConsultationCountListTempWriter = new PrintWriter("assets/transactions/consultationCountListTemp.txt", "UTF-8"); //edited by Mike, 20201027 // processWriteOutputFileAssetsTransactionsCountList(consultationCountListTempWriter, CONSULTATION_FILE_TYPE); processWriteOutputFileAssetsTransactionsCountList(moscConsultationCountListTempWriter, CONSULTATION_FILE_TYPE); /* //removed by Mike, 20201023 //edited by Mike, 20190427 if (!isConsultationInputFileEmpty) { processWriteOutputFileConsultation(consultationWriter); } else { System.out.println("\nThere is no Tab-delimited .txt input file in the \"input\\consultation\" folder.\n"); } */ /* //removed by Mike, 20201023 if (!isTreatmentInputFileEmpty) { processWriteOutputFileTreatment(treatmentWriter); //added by Mike, 20190426 processWriteOutputFileTreatmentUnclassifiedDiagnosedCases(treatmentUnclassifiedDiagnosedCasesWriter); //added by Mike, 20190503; edited by Mike, 20190504 processWriteOutputFileMonthlyStatistics(treatmentCountMonthlyStatisticsWriter, TREATMENT_FILE_TYPE); processWriteOutputFileMonthlyStatistics(consultationCountMonthlyStatisticsWriter, CONSULTATION_FILE_TYPE); processWriteOutputFileMonthlyStatistics(procedureCountMonthlyStatisticsWriter, PROCEDURE_FILE_TYPE); //added by Mike, 20190803 //note that I moved these instructions here, so that if there is an error in the processing that the computer executes before these, the lists will not be blank PrintWriter treatmentCountListTempWriter = new PrintWriter("assets/transactions/treatmentCountListTemp.txt", "UTF-8"); PrintWriter consultationCountListTempWriter = new PrintWriter("assets/transactions/consultationCountListTemp.txt", "UTF-8"); PrintWriter procedureCountListTempWriter = new PrintWriter("assets/transactions/procedureCountListTemp.txt", "UTF-8"); //added by Mike, 20190622 processWriteOutputFileAssetsTransactionsCountList(treatmentCountListTempWriter, TREATMENT_FILE_TYPE); processWriteOutputFileAssetsTransactionsCountList(consultationCountListTempWriter, CONSULTATION_FILE_TYPE); processWriteOutputFileAssetsTransactionsCountList(procedureCountListTempWriter, PROCEDURE_FILE_TYPE); } else { System.out.println("\nThere is no Tab-delimited .txt input file in the \"input\\treatment\" folder.\n"); } */ //edited by Mike, 20201026 /* //removed by Mike, 20201027 //TO-DO: -add: "MOSC" keyword in temporary file PrintWriter moscConsultationCountListTempWriter = new PrintWriter("assets/transactions/consultationCountListTemp.txt", "UTF-8"); processWriteOutputFileAssetsTransactionsCountList(moscConsultationCountListTempWriter, CONSULTATION_FILE_TYPE); */ } //added by Mike, 20201023 //Reference: https://stackoverflow.com/questions/428918/how-can-i-increment-a-date-by-one-day-in-java; //last accessed: 20201023 //answer by: Lisa, 2020120308T0626 //edited by: Community♦, 2020120613T1749 private static Date addDay(Date date, int days) { Calendar cal = Calendar.getInstance(); cal.setTime(date); cal.add(Calendar.DATE, days); //minus number would decrement the days return cal.getTime(); } private static String convertDateToMonthYearInWords(int date) { StringBuffer sb = new StringBuffer(""+date); String year = sb.substring(0,4); //index 4 is not included int month = Integer.parseInt(sb.substring(4,6)); //index 6 is not included switch(month) { case 1: return "January" + " " + year; case 2: return "February" + " " + year; case 3: return "March" + " " + year; case 4: return "April" + " " + year; case 5: return "May" + " " + year; case 6: return "June" + " " + year; case 7: return "July" + " " + year; case 8: return "August" + " " + year; case 9: return "September" + " " + year; case 10: return "October" + " " + year; case 11: return "November" + " " + year; case 12: return "December" + " " + year; } return null;//error } private static String getMonthYear(String date) { StringBuffer sb = new StringBuffer(date); return sb.substring(0,3).concat("-").concat(sb.substring(sb.length()-2,sb.length())); } //input: Jan //output: 1 private static String convertMonthToNumber(String month) { //added by Mike, 20210502 month=month.toLowerCase(); switch(month) { case "jan": return "01"; case "feb": return "02"; case "mar": return "03"; case "apr": return "04"; case "may": return "05"; case "jun": return "06"; case "jul": return "07"; case "aug": return "08"; case "sep": return "09"; case "oct": return "10"; case "nov": return "11"; case "dec": return "12"; } return null; } //added by Mike, 20190504 //input: 1 //output: JAN private static String convertMonthNumberToThreeLetterWord(int month) { switch(month) { case 0: return "JAN"; case 1: return "FEB"; case 2: return "MAR"; case 3: return "APR"; case 4: return "MAY"; case 5: return "JUN"; case 6: return "JUL"; case 7: return "AUG"; case 8: return "SEP"; case 9: return "OCT"; case 10: return "NOV"; case 11: return "DEC"; } return null; } //input: Jan-19 //output: 201901 private static int getYearMonthAsInt(String date) { StringBuffer sb = new StringBuffer(""+date); String month = sb.substring(0,sb.indexOf("-")).toLowerCase(); //index "-" is not included month = ""+convertMonthToNumber(month); String year = sb.substring(sb.indexOf("-")).substring(sb.indexOf("-")+1); // System.out.println("year: "+year); //if the year is only 2 digits, e.g. "19", instead of of "2019" if (year.length() < 4) { year = "20" + year; } // System.out.println("Integer.parseInt(year.concat(month)): "+Integer.parseInt(year.concat(month))); return Integer.parseInt(year.concat(month)); } //input: Jan-19 //output: 2019 private static int getYearOnlyAsInt(String date) { StringBuffer sb = new StringBuffer(""+date); /* //removed by Mike, 20201025 String month = sb.substring(0,sb.indexOf("-")).toLowerCase(); //index "-" is not included month = ""+convertMonthToNumber(month); */ // String year = sb.substring(sb.indexOf("-")).substring(sb.indexOf("-")+1); String year = sb.substring(sb.indexOf("-")+1); //if the year is only 2 digits, e.g. "19", instead of of "2019" if (year.length() < 4) { year = "20" + year; } // System.out.println("Integer.parseInt(year.concat(month)): "+Integer.parseInt(year.concat(month))); // return Integer.parseInt(year.concat(month)); return Integer.parseInt(year); } //added by Mike, 20181030 private static void makeFilePath(String filePath) { File directory = new File(filePath); if (!directory.exists() && !directory.mkdirs()) { System.out.println("File Path to file could not be made."); } } //added by Mike, 20201023 private static boolean processAutoCalculate() { int iDateValuesArrayIntCountMax = dateValuesArrayInt.length; int iYearKey; for (int iDateValuesArrayIntCount=0;iDateValuesArrayIntCount>>>>>>>>>>>DITO: iYearKey: "+iYearKey+"; "+iDateValuesArrayIntCount); */ // iYearKey=2020; /* //removed by Mike, 20201027 if (dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])==null) { //set default value to 0 consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount]=0; System.out.println(">>>>>>>>>>>>DITO: iYearKey: "+iYearKey+"; "+iDateValuesArrayIntCount); //consultationMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]) continue; } */ //from Double type to Integer type // System.out.println(">>iQuantityTotalCount: "+(int)dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]); // int yearKey = yearsContainerArrayList.get(i); // System.out.println(">>>> iDateValuesArrayIntCount: "+iDateValuesArrayIntCount); //TO-DO: -update: this //int i = dateValueInt; //added by Mike, 20190427 /* //added by Mike, 20190207; edited by Mike, 20190427 if (dateValuesArrayInt[i]==0) { //if there is no .txt input file return false; } */ //note: 0:iQuantityTotalCount // totalConsultationCount = (int) dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]; //totalConsultationCount += consultationCount; /* //removed by Mike, 20201025 System.out.println("iDateValuesArrayIntCount: " +iDateValuesArrayIntCount); System.out.println("totalConsultationCount: " +totalConsultationCount); */ // consultationMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]=totalConsultationCount; // consultationMonthlyStatisticsContainer.get(2020)[iDateValuesArrayIntCount]=totalConsultationCount; //added by Mike, 20201027 //TO-DO: -update: this //TO-DO: -update: 2020 /* //removed by Mike, 20201027 consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount]=(int) dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]; */ /* consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount]=consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount]; */ //added by Mike, 20201027 int iMonthYearCount = iDateValuesArrayIntCount; //Integer.parseInt(myDateValuesArrayIntMonth.format(myDate))-1; /* //removed by Mike, 20201027 //note: 0:iQuantityTotalCount dateContainer.get(dateValuesArrayInt[iMonthYearCount])[0]=(int) dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]; */ if (dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])!=null) { /* System.out.println("hallo>>>>>>>> "+(int) dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]); */ //overwrite value inside container //overwrite only those values whose date is the year 2020-05 onwards //edited by Mike, 20210502 // if ((iYearKey>=2020) && (iDateValuesArrayIntCount>=5)) { if (iYearKey>=2020) { if (iYearKey==2020) { if (iDateValuesArrayIntCount>=5) { System.out.println("iYearKey: " + iYearKey + "; iDateValuesArrayIntCount: " + iDateValuesArrayIntCount); consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount]=(int) dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]; } } else { //System.out.println("iYearKey: " + iYearKey + "; iDateValuesArrayIntCount: " + iDateValuesArrayIntCount); consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount]=(int) dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]; } } } // totalConsultationCount=0; } return true; } //added by Mike, 20190415; edited by Mike, 20201023 private static boolean processAutoCalculatePrev() { // System.out.println("dateValuesArrayInt.length: "+dateValuesArrayInt.length); // System.out.println("dateValuesArrayInt.length/2: "+dateValuesArrayInt.length/2); //Note that there should be an even number of input files and at least two (2) input files, one for PT Treatment and another for Consultation /* for(int i=0; i sortedMedicalDoctorTransactionCountKeyset = new TreeSet(medicalDoctorContainer.keySet()); for (String key : sortedMedicalDoctorTransactionCountKeyset) { double count = medicalDoctorContainer.get(key)[OUTPUT_HMO_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_NON_HMO_COUNT_COLUMN]; //edited by Mike, 20190426 /* double newPatientReferralTransactionCount = medicalDoctorContainer.get(key)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN];onsultationMonthlyStatisticsContainer.get(yearKey)[monthRowIndex] */ /* double newPatientReferralTransactionCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; */ //added by Mike, 20181219; edited by Mike, 20190427 consultationCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; //added by Mike, 20181219; edited by Mike, 20190427 procedureCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]; //added by Mike, 20190109; edited by Mike, 20190427 medicalCertificateCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]; //added by Mike, 20190202 double newPatientCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20190202 double followUpCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_FOLLOW_UP_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_FOLLOW_UP_COUNT_COLUMN]; //added by Mike, 20190202 double oldPatientCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_OLD_PATIENT_COUNT_COLUMN]; //edited by Mike, 20190426 // totalReferringMedicalDoctorTransactionCount += count; totalMedicalDoctorTransactionCount += count; /* totalNewPatientReferralTransactionCount += newPatientReferralTransactionCount; */ totalConsultationPerDoctorCount += consultationCount; totalProcedurePerDoctorCount += procedureCount; totalMedicalCertificatePerDoctorCount += procedureCount; totalFollowUpPerDoctorCount += followUpCount; totalNewPatientPerDoctorCount += newPatientCount; totalOldPatientPerDoctorCount += oldPatientCount; } //added by Mike, 20190417 //-------------------------------------------------------------------- SortedSet sortedHMOKeyset = new TreeSet(hmoContainer.keySet()); for (String key : sortedHMOKeyset) { double treatmentCount = hmoContainer.get(key)[OUTPUT_HMO_COUNT_COLUMN]; double consultationCount = hmoContainer.get(key)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]; double procedureCount = hmoContainer.get(key)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]; //added by Mike, 20190105 double medicalCertificateCount = hmoContainer.get(key)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]; //added by Mike, 20190107 double newPatientTreatmentCount = hmoContainer.get(key)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20190102 double newPatientConsultationCount = hmoContainer.get(key)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20190102 // System.out.println("inside sortedHMOKeyset: " + treatmentCount); totalTreatmentHMOCount += treatmentCount; totalConsultationHMOCount += consultationCount; totalProcedureHMOCount += procedureCount; totalMedicalCertificateHMOCount += medicalCertificateCount; totalNewPatientTreatmentHMOCount += newPatientTreatmentCount; totalNewPatientConsultationHMOCount += newPatientConsultationCount; } //added by Mike, 20190429 //-------------------------------------------------------------------- SortedSet sortedNonHMOKeyset = new TreeSet(nonHmoContainer.keySet()); for (String key : sortedNonHMOKeyset) { double treatmentCount = nonHmoContainer.get(key)[OUTPUT_NON_HMO_COUNT_COLUMN]; double consultationCount = nonHmoContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; double procedureCount = nonHmoContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]; //added by Mike, 20190105 double medicalCertificateCount = nonHmoContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]; //added by Mike, 20190107 double newPatientTreatmentCount = nonHmoContainer.get(key)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20190102 double newPatientConsultationCount = nonHmoContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20190102 totalTreatmentNonHMOCount += treatmentCount; totalConsultationNonHMOCount += consultationCount; totalProcedureNonHMOCount += procedureCount; totalMedicalCertificateNonHMOCount += medicalCertificateCount; totalNewPatientTreatmentNonHMOCount += newPatientTreatmentCount; totalNewPatientConsultationNonHMOCount += newPatientConsultationCount; } return true; //added by Mike, 20190426 } //added by Mike, 20201025 //TO-DO: -update: this private static void processMonthlyCountMOSC(HashMap dateContainer, String[] inputColumns, int i, boolean isConsultation) { // if (!referringDoctorContainer.containsKey(inputColumns[INPUT_REFERRING_DOCTOR_COLUMN])) { if (!dateContainer.containsKey(dateValuesArrayInt[i])) { //TO-DO: -update: this columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; //note: 0:iQuantityTotalCount // columnValuesArray[0] dateContainer.put(dateValuesArrayInt[i], columnValuesArray); } else { //edited by Mike, 20181218 if (!isConsultation) { // System.out.println("treatment: inputColumns[INPUT_CLASS_COLUMN]: " + inputColumns[INPUT_CLASS_COLUMN]); //edited by Mike, 20181206 if ((inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CLASS_COLUMN].contains("SLR"))) { // System.out.println("i in dateValuesArrayInt[i]" + i); dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_COUNT_COLUMN]++; /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } */ } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_COUNT_COLUMN]++; /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } */ } } else { if ((inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("SLR"))) { /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; */ //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } /* //added by Mike, 20190105 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } else { /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } /* //added by Mike, 20190105 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } } } } private static void processMonthlyCount(HashMap dateContainer, String[] inputColumns, int i, boolean isConsultation) { // if (!referringDoctorContainer.containsKey(inputColumns[INPUT_REFERRING_DOCTOR_COLUMN])) { if (!dateContainer.containsKey(dateValuesArrayInt[i])) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; //edited by Mike, 20181218 if (!isConsultation) { //edited by Mike, 20181206 if ((inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CLASS_COLUMN].contains("SLR"))) { columnValuesArray[OUTPUT_HMO_COUNT_COLUMN] = 1; /* columnValuesArray[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); */ /* if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } */ } else { columnValuesArray[OUTPUT_NON_HMO_COUNT_COLUMN] = 1; /* columnValuesArray[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); */ /* if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } */ } } else { if ((inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("SLR"))) { //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; } /* //added by Mike, 20190105 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; } */ } else { //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; */ /* //added by Mike, 20190105 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; } */ } } // referringDoctorContainer.put(inputColumns[INPUT_REFERRING_DOCTOR_COLUMN], columnValuesArray); dateContainer.put(dateValuesArrayInt[i], columnValuesArray); } else { //edited by Mike, 20181218 if (!isConsultation) { // System.out.println("treatment: inputColumns[INPUT_CLASS_COLUMN]: " + inputColumns[INPUT_CLASS_COLUMN]); //edited by Mike, 20181206 if ((inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CLASS_COLUMN].contains("SLR"))) { // System.out.println("i in dateValuesArrayInt[i]" + i); dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_COUNT_COLUMN]++; /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } */ } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_COUNT_COLUMN]++; /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } */ } } else { if ((inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("SLR"))) { /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; */ //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } /* //added by Mike, 20190105 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } else { /* dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } /* //added by Mike, 20190105 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { dateContainer.get(dateValuesArrayInt[i])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } } } } //added by Mike, 20181217 private static void processHMOCount(HashMap hmoContainer, String[] inputColumns, boolean isConsultation) { //edited by Mike, 20181219 if (!isConsultation) { //edited by Mike, 20181206 if ((inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CLASS_COLUMN].contains("SLR"))) { String hmoName = inputColumns[INPUT_CLASS_COLUMN].trim().toUpperCase(); if (!hmoContainer.containsKey(hmoName)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; columnValuesArray[OUTPUT_HMO_COUNT_COLUMN] = 1; //added by Mike, 20190102 if (inputColumns[INPUT_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { columnValuesArray[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } if (isNetPFComputed) { columnValuesArray[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } hmoContainer.put(hmoName, columnValuesArray); } else { hmoContainer.get(hmoName)[OUTPUT_HMO_COUNT_COLUMN]++; //added by Mike, 20190102 if (inputColumns[INPUT_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { hmoContainer.get(hmoName)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN]++; } if (isNetPFComputed) { hmoContainer.get(hmoName)[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { hmoContainer.get(hmoName)[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { hmoContainer.get(hmoName)[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } } } } else { if ((inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) || (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("SLR"))) { String hmoName = inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].trim().toUpperCase(); if (!hmoContainer.containsKey(hmoName)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; //added by Mike, 20190102 if (inputColumns[INPUT_CONSULTATION_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //do not include in count; only for NON-HMO/Cash payments /* columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; */ } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; } /* columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; */ hmoContainer.put(hmoName, columnValuesArray); } else { //added by Mike, 20190102 if (inputColumns[INPUT_CONSULTATION_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN]++; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //do not include in count; only for NON-HMO/Cash payments /* columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; */ } else { hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } /* hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; */ } } } } //added by Mike, 20181217 private static void processNonHMOCount(HashMap nonHmoContainer, String[] inputColumns, boolean isConsultation) { //edited by Mike, 20181219 if (!isConsultation) { //edited by Mike, 20181206 if ((!inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) && (!inputColumns[INPUT_CLASS_COLUMN].contains("SLR"))) { String classificationName = inputColumns[INPUT_CLASS_COLUMN].trim().toUpperCase(); if (!nonHmoContainer.containsKey(classificationName)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; columnValuesArray[OUTPUT_NON_HMO_COUNT_COLUMN] = 1; //added by Mike, 20190429 if (inputColumns[INPUT_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { columnValuesArray[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } if (isNetPFComputed) { columnValuesArray[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } nonHmoContainer.put(classificationName, columnValuesArray); } else { nonHmoContainer.get(classificationName)[OUTPUT_NON_HMO_COUNT_COLUMN]++; //added by Mike, 20190429 if (inputColumns[INPUT_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { nonHmoContainer.get(classificationName)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN]++; } if (isNetPFComputed) { nonHmoContainer.get(classificationName)[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { nonHmoContainer.get(classificationName)[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { nonHmoContainer.get(classificationName)[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } } } } else { if ((!inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) && (!inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("SLR"))) { String classificationName = inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].trim().toUpperCase(); /* System.out.println("classificationName: "+classificationName); if (classificationName.contains("MCDO")) { System.out.println("May MCDO"); } */ if (isInDebugMode) { if (classificationName.trim().equals("")) { // System.out.println(">>> "+inputColumns[INPUT_DATE_COLUMN]+"; Name: "+inputColumns[INPUT_NAME_COLUMN]); } } /* if (!nonHmoContainer.containsKey(classificationName)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; nonHmoContainer.put(classificationName, columnValuesArray); } else { nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } */ if (!nonHmoContainer.containsKey(classificationName)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; //added by Mike, 20190429 if (inputColumns[INPUT_CONSULTATION_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } /* columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; */ nonHmoContainer.put(classificationName, columnValuesArray); } else { //added by Mike, 20190429 if (inputColumns[INPUT_CONSULTATION_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]++; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { /* hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; */ nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //include in count; only for NON-HMO/Cash payments nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } else { nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { nonHmoContainer.get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } /* hmoContainer.get(hmoName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; */ } } } } //added by Mike, 20181218 private static void processReferringDoctorTransactionCount(HashMap referringDoctorContainer, String[] inputColumns, Boolean isConsultation) { //added by Mike, 20190125 String inputReferringMedicalDoctor = inputColumns[INPUT_REFERRING_DOCTOR_COLUMN].trim().toUpperCase(); //edited by Mike, 20181219 if (!isConsultation) { if (!referringDoctorContainer.containsKey(inputReferringMedicalDoctor)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; if (inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) { columnValuesArray[OUTPUT_HMO_COUNT_COLUMN] = 1; if (isNetPFComputed) { columnValuesArray[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 columnValuesArray[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_NON_HMO_COUNT_COLUMN] = 1; if (isNetPFComputed) { columnValuesArray[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 columnValuesArray[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } } referringDoctorContainer.put(inputReferringMedicalDoctor, columnValuesArray); } else { if (inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_HMO_COUNT_COLUMN]++; if (isNetPFComputed) { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN]++; } } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_NON_HMO_COUNT_COLUMN]++; if (isNetPFComputed) { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN]++; } } } } else { //added by Mike, 20190125; edited by Mike, 20190424 // inputReferringMedicalDoctor = inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN].trim().toUpperCase(); inputReferringMedicalDoctor = inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN].trim().toUpperCase(); if (!referringDoctorContainer.containsKey(inputReferringMedicalDoctor)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; if (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) { //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //do not include in count; only for NON-HMO/Cash payments /* columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; */ } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; } referringDoctorContainer.put(inputReferringMedicalDoctor, columnValuesArray); } else { //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } } /* if (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } //added by Mike, 20181219 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; } */ referringDoctorContainer.put(inputReferringMedicalDoctor, columnValuesArray); } else { if (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) { //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; */ referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { /* //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; */ } } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ } /* ` referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; //added by Mike, 20181219 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { //edited by Mike, 20181221 //columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } else { //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; */ referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { /* //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; */ } } else { referringDoctorContainer.get(inputReferringMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ } /* referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; //added by Mike, 20181219 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { //edited by Mike, 20181221 //columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } } } } //added by Mike, 20181218 private static void processMedicalDoctorTransactionCount(HashMap medicalDoctorContainer, String[] inputColumns, Boolean isConsultation) { //edited by Mike, 20181219 if (!isConsultation) { //only process follow-up count for Consultation transactions //edited by Mike, 20190424 String inputMedicalDoctor = inputColumns[INPUT_REFERRING_DOCTOR_COLUMN].trim().toUpperCase(); // System.out.println("inputMedicalDoctor: "+inputMedicalDoctor); if (!medicalDoctorContainer.containsKey(inputMedicalDoctor)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; if (inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) { columnValuesArray[OUTPUT_HMO_COUNT_COLUMN] = 1; if (isNetPFComputed) { columnValuesArray[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 columnValuesArray[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_NON_HMO_COUNT_COLUMN] = 1; if (isNetPFComputed) { columnValuesArray[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { columnValuesArray[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { columnValuesArray[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] = Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 columnValuesArray[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } } medicalDoctorContainer.put(inputMedicalDoctor, columnValuesArray); } else { if (inputColumns[INPUT_CLASS_COLUMN].contains("HMO")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_HMO_COUNT_COLUMN]++; if (isNetPFComputed) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN]++; } } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_NON_HMO_COUNT_COLUMN]++; if (isNetPFComputed) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_NON_HMO_TOTAL_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); if (inputColumns[INPUT_NOTES_COLUMN].contains("paid:")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_NON_HMO_PAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_NON_HMO_UNPAID_NET_TREATMENT_FEE_COLUMN] += Double.parseDouble(inputColumns[INPUT_NET_PF_COLUMN]); } } if (inputColumns[INPUT_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN]++; } } } } else { //added by Mike, 20190125; edited by Mike, 20190424 String inputMedicalDoctor = inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN].trim().toUpperCase(); // System.out.println("CONSULTATION inputMedicalDoctor: "+inputMedicalDoctor); if (!medicalDoctorContainer.containsKey(inputMedicalDoctor)) { columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; if (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) { if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 columnValuesArray[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } //added by Mike, 20190202 else if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("old")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN] = 1; } //added by Mike, 20190202 else if ((inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow up")) || (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow-up"))) { columnValuesArray[OUTPUT_CONSULTATION_HMO_FOLLOW_UP_COUNT_COLUMN] = 1; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //do not include in count; only for NON-HMO/Cash payments /* columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; */ } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] = 1; } medicalDoctorContainer.put(inputMedicalDoctor, columnValuesArray); } else { if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("new")) { //added by Mike, 20181218 columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN] = 1; } //added by Mike, 20190202 else if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("old")) { columnValuesArray[OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN] = 1; } //added by Mike, 20190202 else if ((inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow up")) || (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow-up"))) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_FOLLOW_UP_COUNT_COLUMN] = 1; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] = 1; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] = 1; } } else { columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 1; } } medicalDoctorContainer.put(inputMedicalDoctor, columnValuesArray); } else { if (inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].contains("HMO")) { if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("new")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN]++; } //added by Mike, 20190202 else if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("old")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN]++; } //added by Mike, 20190202 else if ((inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow up")) || (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow-up"))) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_FOLLOW_UP_COUNT_COLUMN]++; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; */ medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { /* //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; */ } } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ } /* ` referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; //added by Mike, 20181219 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { //edited by Mike, 20181221 //columnValuesArray[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } else { if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("new")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]++; } //added by Mike, 20190202 else if (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("old")) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_OLD_PATIENT_COUNT_COLUMN]++; } //added by Mike, 20190202 else if ((inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow up")) || (inputColumns[INPUT_CONSULTATION_NEW_OLD_COLUMN].toLowerCase().contains("follow-up"))) { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_FOLLOW_UP_COUNT_COLUMN]++; } //edited by Mike, 20190109 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; */ medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { /* //include in count; only for NON-HMO/Cash payments columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; */ } } else { medicalDoctorContainer.get(inputMedicalDoctor)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; /* columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ } /* referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; //added by Mike, 20181219 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().contains("p")) { //edited by Mike, 20181221 //columnValuesArray[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; referringDoctorContainer.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN])[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } */ } } } } //added by Mike, 20181220 private static void processMedicalDoctorTransactionPerClassificationCount(HashMap> classificationContainerPerMedicalDoctor, String[] inputColumns, Boolean isConsultation) { String medicalDoctorKey = inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN].trim().toUpperCase(); if (isConsultation) { String classificationName = inputColumns[INPUT_CONSULTATION_CLASS_COLUMN].trim().toUpperCase(); //added by Mike, 20181220 // System.out.println(">"+" "+classificationName); // System.out.println(">>> "+inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]); if (!classificationName.contains("HMO")) { // System.out.println(">>>"+inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]+" "+classificationName); /* classificationContainerPerMedicalDoctor.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; */ //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } else { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]++; } // System.out.println(">>> NON-HMO count: "+classificationContainerPerMedicalDoctor.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]).get(classificationName)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]); } else { // System.out.println(">>>>>"+inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]+" "+classificationName); /* classificationContainerPerMedicalDoctor.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]).get(classificationName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; */ //edited by Mike, 20190107 if (inputColumns[INPUT_CONSULTATION_MEDICAL_CERTIFICATE_COLUMN].toLowerCase().trim().contains("mc")) { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]++; } else if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("p")) { //edited by Mike, 20190108 if (inputColumns[INPUT_CONSULTATION_PROCEDURE_COLUMN].toLowerCase().trim().contains("/")) { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } else { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]++; } } else { classificationContainerPerMedicalDoctor.get(medicalDoctorKey).get(classificationName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]++; } // System.out.println(">>>>> HMO count: "+classificationContainerPerMedicalDoctor.get(inputColumns[INPUT_CONSULTATION_MEDICAL_DOCTOR_COLUMN]).get(classificationName)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]); } } } private static void setClassificationContainerPerMedicalDoctor(HashMap> classificationContainerPerMedicalDoctor) { SortedSet sortedHmoContainerKeyset = new TreeSet(hmoContainer.keySet()); SortedSet sortedNonHmoContainerKeyset = new TreeSet(nonHmoContainer.keySet()); SortedSet sortedMedicalDoctorKeyset = new TreeSet(medicalDoctorContainer.keySet()); for (String medicalDoctorKey : sortedMedicalDoctorKeyset) { //TO-DO: resolve issue with OR# (Consultation) also being added into medicalDoctorContainer //System.out.println("medical doctor: "+medicalDoctorKey); classificationContainerHashmap = new HashMap(); for (String key : sortedHmoContainerKeyset) { // System.out.println("hmoKey: "+key); // System.out.println("classificationContainerColumnValuesArray: "+classificationContainerColumnValuesArray[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]); classificationContainerColumnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; classificationContainerHashmap.put(key, classificationContainerColumnValuesArray); } for (String key : sortedNonHmoContainerKeyset) { // System.out.println("nonHmoKey: "+key); // System.out.println("classificationContainerColumnValuesArray: "+classificationContainerColumnValuesArray[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]); classificationContainerColumnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; classificationContainerHashmap.put(key, classificationContainerColumnValuesArray); } classificationContainerPerMedicalDoctor.put(medicalDoctorKey, classificationContainerHashmap); } /* for (String key : sortedMedicalDoctorKeyset) { for (String nonHmoKey : sortedNonHmoContainerKeyset) { System.out.println(classificationContainerPerMedicalDoctor.get(key).get(nonHmoKey)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]); } } */ } //added by Mike, 20190412 private static void processKnownDiagnosedCasesInputFile(String[] args) throws Exception { //edited by Mike, 20181030 for (int i=0; i sortedKnownDiagnosedCasesKeyset = new TreeSet(knownDiagnosedCasesContainer.keySet()); for (String key : sortedKnownDiagnosedCasesKeyset) { System.out.println(key + " : " + knownDiagnosedCasesContainer.get(key)); } */ /* int dateValueInt = Integer.parseInt(args[i].substring(args[i].indexOf("_")+1,args[i].indexOf(".txt"))); if (!dateValuesArrayInt.contains(dateValueInt)){ dateValuesArrayInt.add(dateValueInt); } */ /* //edited by Mike, 20181121 if (startDate==null) { startDate = getMonthYear(inputColumns[INPUT_DATE_COLUMN]); endDate = startDate; } else { //edited by Mike, 20181121 //add this condition in case the input file does not have a date for each transaction; however, ideally, for input files 2018 onwards, each transaction should have a date if (!inputColumns[INPUT_DATE_COLUMN].trim().equals("")) { endDate = getMonthYear(inputColumns[INPUT_DATE_COLUMN]); } } */ if (isInDebugMode) { rowCount++; System.out.println("rowCount: "+rowCount); } /* //added by Mike, 20181121 //skip transactions that have "RehabSupplies" as its "CLASS" value //In Excel logbook/workbook 2018 onwards, such transactions are not included in the Consultation and PT Treatment Excel logbooks/workbooks. if (inputColumns[INPUT_CLASS_COLUMN].contains("RehabSupplies")) { continue; } */ /* if (isPhaseOne) { //TO-DO: -add: handle consultation transactions processDiagnosedCasesCount(diagnosedCasesContainer, inputColumns, isConsultation); //edited by Mike, 20181219 } else { //added by Mike, 20181220 processMedicalDoctorTransactionPerClassificationCount(classificationContainerPerMedicalDoctor, inputColumns, isConsultation); } */ } } } private static void processInputFiles(String[] args, boolean isPhaseOne) throws Exception { //added by Mike, 20201025 int iQuantityTotalCountOfTheYear=0; int iNoChargeQuantityTotalCountOfTheYear=0; int iQuantityTotalCountOfTheMonth=0; int iNoChargeQuantityTotalCountOfTheMonth=0; //added by Mike, 20201025 DateFormat dateYearFormat = new SimpleDateFormat("yyyy"); //added by Mike, 20210502 Date dateNow = new Date(); //TO-DO: -update: set date instructions // Date dateNow = new SimpleDateFormat("yyyy-MM-dd").parse("2020-12-31"); //edited by Mike, 20210502 String sMyDateYear = dateYearFormat.format(dateNow); // String sMyDateYear = "2020"; //added by Mike, 20201023 DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); //edited by Mike, 20201025 // Date myDate = new Date(); Date myDate = dateFormat.parse(sMyDateYear+"-01-01");//dateFormat.parse("2020-01-01"); // System.out.println(dateFormat.format(myDate)); //TO-DO: -add: all days of all months of the year //edited by Mike, 20210502 String sMyDateNow = dateFormat.format(dateNow); // String sMyDateNow = dateFormat.format(myDate); String sMyDate = ""; //edited by Mike, 20210502 String sMyDateNowPlusOne = dateFormat.format(addDay(dateNow, 1)); // String sMyDateNowPlusOne = dateFormat.format(addDay(myDate, 1)); // System.out.println(sMyDateNow); int iMonthYearCount=0; //note: date now included in count do { // System.out.println(dateFormat.format(myDate)); myDate = addDay(myDate, 1); sMyDate = dateFormat.format(myDate); // System.out.println(dateFormat.format(myDate)); //TO-DO: -update: this //edited by Mike, 20201025 DateFormat myDateValuesArrayDateFormat = new SimpleDateFormat("MMM/dd/YY"); //added by Mike, 20201025 DateFormat myDateValuesArrayDateMonth = new SimpleDateFormat("MM"); DateFormat myDateValuesArrayIntYearMonth = new SimpleDateFormat("YYYYMM"); DateFormat myDateValuesArrayIntMonth = new SimpleDateFormat("M"); String sInputMonthYear = getMonthYear(myDateValuesArrayDateFormat.format(myDate)); /* //removed by Mike, 20201025 System.out.println(">>"+sInputMonthYear); */ // if (dateValuesArrayInt[iMonthYearCount]==0) { iMonthYearCount = Integer.parseInt(myDateValuesArrayIntMonth.format(myDate))-1; /* //removed by Mike, 20201025 System.out.println(">>iMonthYearCount: "+iMonthYearCount); */ //input: Jan-19 //output: 201901 //note: getYearMonthAsInt(...) // dateValuesArrayInt[iMonthYearCount] = getYearMonthAsInt(sInputMonthYear); dateValuesArrayInt[iMonthYearCount] = Integer.parseInt(myDateValuesArrayIntYearMonth.format(myDate)); // } if (dateValuesArray[iMonthYearCount]==null) { dateValuesArray[iMonthYearCount] = sInputMonthYear; } if (dateValuesArray[iMonthYearCount]==sInputMonthYear) { } else { dateValuesArray[iMonthYearCount] = sInputMonthYear; } for(int i=0; i>"+inputFilename); //removed by Mike, 20210602 // System.out.println(medicalDoctorsList[i]+dateFormat.format(myDate)+".txt"); //edited by Mike, 20201024 inputFilename=inputFilename+medicalDoctorsList[i]+dateFormat.format(myDate)+".txt"; //System.out.println(">>>>"+inputFilename); File f = new File(inputFilename); if(f.exists() && !f.isDirectory()) { Scanner sc = new Scanner(new FileInputStream(f)); String s; s=sc.nextLine(); //removed by Mike, 20201026 // System.out.println(s); //added by Mike, 20201024 JSONArray nestedJsonArray = new JSONArray(s); //JSONObject myJsonObject = new JSONObject(s); JSONObject jo_inside = nestedJsonArray.getJSONObject(0); //added by Mike, 20201025 //TO-DO: -add: iQuantityTotalCountOfTheYear //TO-DO: -add: iNoChargeQuantityTotalCountOfTheYear //TO-DO: -add: write in output .csv file // System.out.println("iQuantityTotalCount: "+jo_inside.getInt("iQuantityTotalCount")); // System.out.println("iNoChargeQuantityTotalCount: "+jo_inside.getInt("iNoChargeQuantityTotalCount")); //note: processMonthlyCountMOSC(...) if (!dateContainer.containsKey(dateValuesArrayInt[iMonthYearCount])) { //TO-DO: -update: this columnValuesArray = new double[OUTPUT_TOTAL_COLUMNS]; //note: 0:iQuantityTotalCount columnValuesArray[0] = jo_inside.getInt("iQuantityTotalCount"); dateContainer.put(dateValuesArrayInt[iMonthYearCount], columnValuesArray); //added by Mike, 20201026 System.out.println("iQuantityTotalCount: "+jo_inside.getInt("iQuantityTotalCount")); } else { //note: 0:iQuantityTotalCount dateContainer.get(dateValuesArrayInt[iMonthYearCount])[0]+=jo_inside.getInt("iQuantityTotalCount"); System.out.println("iQuantityTotalCount: "+jo_inside.getInt("iQuantityTotalCount")); //note: /* consultationMonthlyStatisticsContainer.get(iYearKey)[iDateValuesArrayIntCount] dateContainer.get(dateValuesArrayInt[iMonthYearCount])[0] */ } //added by Mike, 20210505 //do not include "No Charge" (NC), i.e. gratis columnValuesArray[0] = columnValuesArray[0]-jo_inside.getInt("iNoChargeQuantityTotalCount"); } } } while (!sMyDate.equals(sMyDateNowPlusOne)); // while (!sMyDate.equals("2020-01-10")); /* int iDateValuesArrayIntCountMax = dateValuesArrayInt.length; for (int iDateValuesArrayIntCount=0;iDateValuesArrayIntCount>iQuantityTotalCount: "+(int)dateContainer.get(dateValuesArrayInt[iDateValuesArrayIntCount])[0]); // int yearKey = yearsContainerArrayList.get(i); System.out.println(">>>> sMyDateYear: "+sMyDateYear); System.out.println(">>>> iDateValuesArrayIntCount: "+iDateValuesArrayIntCount); } */ } //added by Mike, 20201025 private static void processInputFilesOK(String[] args, boolean isPhaseOne) throws Exception { //added by Mike, 20201023 DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); Date myDate = new Date(); System.out.println(dateFormat.format(myDate)); //TO-DO: -add: all days of all months of the year // myDate = addDay(myDate, -1); // System.out.println(dateFormat.format(myDate)); //edited by Mike, 20201025 DateFormat myDateValuesArrayDateFormat = new SimpleDateFormat("MMM/dd/YY"); //added by Mike, 20201025 DateFormat myDateValuesArrayDateMonth = new SimpleDateFormat("MM"); int iMonthYearCount=0; String sInputMonthYear = getMonthYear(myDateValuesArrayDateFormat.format(myDate)); System.out.println(">>"+sInputMonthYear); if (dateValuesArray[iMonthYearCount]==null) { dateValuesArray[iMonthYearCount] = sInputMonthYear; } if (dateValuesArray[iMonthYearCount]==sInputMonthYear) { } else { dateValuesArray[iMonthYearCount] = sInputMonthYear; } for(int i=0; i>"+inputFilename); //System.out.println(medicalDoctorsList[i]+dateFormat.format(myDate)+".txt"); //edited by Mike, 20201024 inputFilename=inputFilename+medicalDoctorsList[i]+dateFormat.format(myDate)+".txt"; //System.out.println(">>>>"+inputFilename); File f = new File(inputFilename); if(f.exists() && !f.isDirectory()) { Scanner sc = new Scanner(new FileInputStream(f)); String s; s=sc.nextLine(); System.out.println(s); //added by Mike, 20201024 JSONArray nestedJsonArray = new JSONArray(s); //JSONObject myJsonObject = new JSONObject(s); JSONObject jo_inside = nestedJsonArray.getJSONObject(0); //added by Mike, 20201025 //TO-DO: -add: iQuantityTotalCountOfTheYear //TO-DO: -add: iNoChargeQuantityTotalCountOfTheYear //TO-DO: -add: write in output .csv file System.out.println("iQuantityTotalCount: "+jo_inside.getInt("iQuantityTotalCount")); System.out.println("iNoChargeQuantityTotalCount: "+jo_inside.getInt("iNoChargeQuantityTotalCount")); } } } private static void processInputFilesPrev(String[] args, boolean isPhaseOne) throws Exception { //edited by Mike, 20181030 for (int i=0; i>>>>>> i: "+ i + "; >>>dateValuesArray["+i+"]: "+dateValuesArray[i]); //added by Mike, 20190426 if (inputFilename.toLowerCase().contains("consultation")) { isConsultationInputFileEmpty=false; } else if (inputFilename.toLowerCase().contains("treatment")) { // System.out.println(">>>dateValuesArray[i]: "+dateValuesArray[i]); isTreatmentInputFileEmpty=false; } /* int dateValueInt = Integer.parseInt(args[i].substring(args[i].indexOf("_")+1,args[i].indexOf(".txt"))); if (!dateValuesArrayInt.contains(dateValueInt)){ dateValuesArrayInt.add(dateValueInt); } */ /* //edited by Mike, 20181121 if (startDate==null) { startDate = getMonthYear(inputColumns[INPUT_DATE_COLUMN]); endDate = startDate; } else { //edited by Mike, 20181121 //add this condition in case the input file does not have a date for each transaction; however, ideally, for input files 2018 onwards, each transaction should have a date if (!inputColumns[INPUT_DATE_COLUMN].trim().equals("")) { endDate = getMonthYear(inputColumns[INPUT_DATE_COLUMN]); } } */ if (isInDebugMode) { rowCount++; System.out.println("rowCount: "+rowCount); } /* //added by Mike, 20181121 //skip transactions that have "RehabSupplies" as its "CLASS" value //In Excel logbook/workbook 2018 onwards, such transactions are not included in the Consultation and PT Treatment Excel logbooks/workbooks. if (inputColumns[INPUT_CLASS_COLUMN].contains("RehabSupplies")) { continue; } */ if (isPhaseOne) { // System.out.println("isConsultation: " + isConsultation); //added by Mike, 20181216 // processMonthlyCount(dateContainer, inputColumns, i, false); //edited by Mike, 20190901 // processMonthlyCount(dateContainer, inputColumns, i, isConsultation); //isConsultation = false processMonthlyCount(dateContainer, inputColumns, dateValueInt, isConsultation); //added by Mike, 20181217 processHMOCount(hmoContainer, inputColumns, isConsultation); //edited by Mike, 20181219 //added by Mike, 20181217 processNonHMOCount(nonHmoContainer, inputColumns, isConsultation); //edited by Mike, 20181219 /* //added by Mike, 20181218 processReferringDoctorTransactionCount(referringDoctorContainer, inputColumns, isConsultation); //edited by Mike, 20181219 */ //added by Mike, 20181220 // processMedicalDoctorTransactionPerClassificationCount(classificationContainerPerMedicalDoctor, inputColumns, isConsultation); //edited by Mike, 20190426 if (isConsultation) { //added by Mike, 20190202 processMedicalDoctorTransactionCount(medicalDoctorContainer, inputColumns, isConsultation); } else { processMedicalDoctorTransactionCount(referringDoctorContainer, inputColumns, isConsultation); //added by Mike, 20190413 processDiagnosedCasesCount(diagnosedCasesContainer, inputColumns, isConsultation); } } else { //added by Mike, 20181220 processMedicalDoctorTransactionPerClassificationCount(classificationContainerPerMedicalDoctor, inputColumns, isConsultation); } } /* //added by Mike, 20181205 columnValuesArray[OUTPUT_DATE_ID_COLUMN] = i; */ } } private static void processWriteOutputFileTreatmentUnclassifiedDiagnosedCases(PrintWriter writer) throws Exception { File f = new File(inputOutputTemplateFilenameTreatmentUnclassifiedDiagnosedCases+".html"); // System.out.println("inputOutputTemplateFilenameTreatmentUnclassifiedDiagnosedCases: " + inputOutputTemplateFilenameTreatmentUnclassifiedDiagnosedCases); Scanner sc = new Scanner(new FileInputStream(f), "UTF-8"); String s; // s=sc.nextLine(); //skip the first row, which is the input file's table headers if (isInDebugMode) { rowCount=0; } SortedSet sortedKeyset = new TreeSet(diagnosedCasesContainer.keySet()); // SortedSet sortedClassifiedKeyset = new TreeSet(classifiedDiagnosedCasesContainer.keySet()); //count/compute the number-based values of inputColumns while (sc.hasNextLine()) { s=sc.nextLine(); /* //if the row is blank if (s.trim().equals("")) { continue; } */ if (isInDebugMode) { rowCount++; // System.out.println("rowCount: "+rowCount); } s = s.replace("", "" + dateValue.toUpperCase()); if (s.contains("")) { //added by Mike, 20190426 int diagnosedCaseCount = 0; for (String key : sortedKeyset) { diagnosedCaseCount = diagnosedCasesContainer.get(key); totalDiagnosedCaseCount+=diagnosedCaseCount; s = s.concat("\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + key + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + diagnosedCaseCount + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t "); } } //added by Mike, 20190426 s = s.replace("", "" + (int) totalDiagnosedCaseCount); writer.print(s + "\n"); } writer.close(); } //added by Mike, 20190503; edited by Mike, 20190504 private static void processWriteOutputFileMonthlyStatistics(PrintWriter writer, int fileType) throws Exception { // File inputDataFile = new File(inputDataFilenameTreatmentMonthlyStatistics+".txt"); File f = new File(inputOutputTemplateFilenameMonthlyStatistics+".html"); // System.out.println("inputOutputTemplateFilenameMonthlyStatistics: " + inputOutputTemplateFilenameMonthlyStatistics); Scanner sc = new Scanner(new FileInputStream(f), "UTF-8"); String s; // s=sc.nextLine(); //skip the first row, which is the input file's table headers if (isInDebugMode) { rowCount=0; } SortedSet sortedKeyset = new TreeSet(diagnosedCasesContainer.keySet()); // SortedSet sortedClassifiedKeyset = new TreeSet(classifiedDiagnosedCasesContainer.keySet()); boolean hasWrittenAutoCalculatedValue=false; //count/compute the number-based values of inputColumns while (sc.hasNextLine()) { s=sc.nextLine(); /* //if the row is blank if (s.trim().equals("")) { continue; } */ if (isInDebugMode) { rowCount++; // System.out.println("rowCount: "+rowCount); } // s = s.replace("", "" + dateValue.toUpperCase()); //added by Mike, 20210510 DateFormat dateFormat = new SimpleDateFormat("yyyy"); Date myDate = new Date(); // System.out.println(dateFormat.format(myDate)); s = s.replace("", "" + dateFormat.format(myDate)); //added by Mike, 20190504 if (s.contains("")) { String fileTypeString = ""; switch (fileType) { case TREATMENT_FILE_TYPE: fileTypeString = "TREATMENT"; break; case CONSULTATION_FILE_TYPE: fileTypeString = "CONSULTATION"; break; default:// PROCEDURE_FILE_TYPE: fileTypeString = "PROCEDURE"; break; } s = s.concat("\n"); s = s.concat(fileTypeString+"\n"); } if (s.contains("")) { for(int i=0; i\n"); s = s.concat("\t\t\t\n"); s = s.concat("\t\t\t\t
"+yearKey+"
\n"); s = s.concat("\t\t\t\n"); // System.out.println("yearKey: "+yearKey); // System.out.println(i+": "+inputMonthRowYearColumns[i+1]); } //s = s.concat("\n"); } if (s.contains("")) { for (int monthRowIndex=0; monthRowIndex<12; monthRowIndex++) { //There are 12 months //edited by Mike, 20190504 String monthString = convertMonthNumberToThreeLetterWord(monthRowIndex); s = s.concat("\n"); s = s.concat("\t\t \n"); s = s.concat("\t\t \n"); for(int i=0; i\n"); s = s.concat("\t\t\t\n"); s = s.concat("\t\t\t\n"); //edited by Mike, 20190523 s = s.concat("\t\t\t\t"+monthString+"\n"); //edited by Mike, 20190504 s = s.concat("\t\t\t\n"); //edited by Mike, 20190504 //int treatmentCount = treatmentMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]; int transactionCount = -1; switch (fileType) { case TREATMENT_FILE_TYPE: transactionCount = treatmentMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]; break; case CONSULTATION_FILE_TYPE: transactionCount = consultationMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]; //added by Mike, 20210502 System.out.println("yearKey:" + yearKey + ";monthIndex: "+monthRowIndex+"; transactionCount: "+transactionCount); break; default:// PROCEDURE_FILE_TYPE: transactionCount = procedureMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]; break; } s = s.concat("\t\t\t\n"); //TO-DO: -update: this to resolve the issue in the Consultation output HTML file, where setting the width to 4% does not equal with the length of 3 digit characters //edited by Mike, 20201028 // s = s.concat("\t\t\t\n"); //edited by Mike, 20190523 if (transactionCount!=-1) { s = s.concat("\t\t\t\n"); } else { s = s.concat("\t\t\t\n"); } //edited by Mike, 20190522 String inputMonthString = dateValuesArray[0].split("-")[0].toUpperCase(); //MAR //TO-DO: -update: this to not need to add 20; note that the input file does not use 2019, but 19, as its date format //edited by Mike, 20210502 int inputYear = Integer.parseInt("20"+dateValuesArray[0].split("-")[1]); //e.g. 2019 //removed by Mike, 20200213 //overwrite previous value /* if (transactionCount < 0) { //the value is still blank/empty, e.g. -1 */ //added by Mike, 20201026 //execute computer automation for May 2020 onwards /* //removed by Mike, 20201027 if ((monthRowIndex<5) && (inputYear==2020)) { // if ((monthRowIndex<3) && (inputYear==2020)) { } else { */ // System.out.println("dateValuesArray: "+dateValuesArray[0]); //TO-DO: -update this to store the auto-calculated transaction count value // System.out.println(">>>>>>> dateValue: "+dateValue); //Mar-19 // System.out.println(">>>>>>> dateValueInt: "+dateValueInt); //edited by Mike, 20190522 // if (!hasWrittenAutoCalculatedValue) { //added by Mike, 20210502 //note: verify execute "generateMOSCSummaryReportDailyCount.java" for each month /*System.out.println(">>>>>>> inputMonthString: "+inputMonthString+"; monthString: "+monthString); */ if ((inputMonthString.equals(monthString)) && yearKey == inputYear) { //System.out.println("totalTreatmentCount: "+totalTreatmentCount); switch (fileType) { case TREATMENT_FILE_TYPE: s = s.concat("\t\t\t\t"+totalTreatmentCount+"\n"); //added by Mike, 20190621 transactionCount = totalTreatmentCount; //added by Mike, 20190622 treatmentMonthlyStatisticsContainer.get(yearKey)[monthRowIndex] = transactionCount; break; case CONSULTATION_FILE_TYPE: System.out.println("transactionCount: "+transactionCount); //edited by Mike, 20210502 // s = s.concat("\t\t\t\t"+totalConsultationCount+"\n"); s = s.concat("\t\t\t\t"+transactionCount+"\n"); //added by Mike, 20190621 transactionCount = totalConsultationCount; //added by Mike, 20190622 consultationMonthlyStatisticsContainer.get(yearKey)[monthRowIndex] = transactionCount; break; default:// PROCEDURE_FILE_TYPE: s = s.concat("\t\t\t\t"+totalProcedureCount+"\n"); //added by Mike, 20190621 transactionCount = totalProcedureCount; //added by Mike, 20190622 procedureMonthlyStatisticsContainer.get(yearKey)[monthRowIndex] = transactionCount; break; } hasWrittenAutoCalculatedValue = true; } //added by Mike, 20200213 else { //edited by Mike, 20201028 // String sTransactionCount = NumberFormat.getNumberInstance(Locale.US).format(transactionCount); String sTransactionCount =String.format("%,d", transactionCount); // s = s.concat("\t\t\t\t"+transactionCount+"\n"); s = s.concat("\t\t\t\t"+sTransactionCount+"\n"); } /* //removed by Mike, 20201027 //added by Mike, 20201026 } */ //removed by Mike, 20200213 //overwrite previous value /* else { s = s.concat("\t\t\t\t\n"); } // s = s.concat("\t\t\t\t\n"); } else { s = s.concat("\t\t\t\t"+transactionCount+"\n"); } */ //s = s.concat("\t\t\t\t"+treatmentMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]+"\n"); s = s.concat("\t\t\t\n"); //added by Mike, 20190621 //automatically update the transaction count file in the assets folder } s = s.concat("\t\t \n"); // System.out.println("yearKey: "+yearKey); // System.out.println(i+": "+inputMonthRowYearColumns[i+1]); } // s = s.concat("\n"); } //added by Mike, 20200220 s = s.replace("-1", ""); writer.print(s + "\n"); } writer.close(); } //added by Mike, 20190622 private static void processWriteOutputFileAssetsTransactionsCountList(PrintWriter writer, int fileType) throws Exception { String s = ""; for(int i=0; i sortedClassifiedKeyset = new TreeSet(classifiedDiagnosedCasesContainer.keySet()); //added by Mike, 20190417 Set> classifiedDiagnosedCasesContainerSet = classifiedDiagnosedCasesContainer.entrySet(); List> sortedClassifiedDiagnosedCasesContainerList = new ArrayList>(classifiedDiagnosedCasesContainerSet); //edited by Mike, 20190418 //Removed inner class "Comparator" so that there will be no "generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles$1.class" after compiling the "generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles.java" /*Collections.sort(sortedClassifiedDiagnosedCasesContainerList, new Comparator>() { public int compare(Map.Entry o1, Map.Entry o2) { return o2.getValue().compareTo(o1.getValue()); } });*/ Collections.sort(sortedClassifiedDiagnosedCasesContainerList, new IncidenceNumberComparator()); //count/compute the number-based values of inputColumns while (sc.hasNextLine()) { s=sc.nextLine(); /* //if the row is blank if (s.trim().equals("")) { continue; } */ if (isInDebugMode) { rowCount++; // System.out.println("rowCount: "+rowCount); } //added by Mike, 20190414 //This is to resolve the following character-encoding issue. //This is not anymore necessary due to setting the scanner to use UTF-8 // s = s.replace("Â", ""); // System.out.println("s: "+s); // System.out.println("totalTreatmentCount: "+totalTreatmentCount); //added by Mike, 20190417 s = s.replace("", "" + dateValue.toUpperCase()); //edited by Mike, 20190901 // totalTreatmentCount = (int) (totalTreatmentHMOCount + totalTreatmentNonHMOCount); s = s.replace("", "" + totalTreatmentCount); //added by Mike, 20190416; edited by Mike, 20190429 totalNewPatientTreatment = (int) totalNewPatientTreatmentHMOCount + (int) totalNewPatientTreatmentNonHMOCount; s = s.replace("", "" + totalNewPatientTreatment); //added by Mike, 20190416; edited by Mike, 20190425 totalWiValue = 0; if (nonHmoContainer.containsKey(classificationWI)) { totalWiValue = (int) nonHmoContainer.get(classificationWI)[OUTPUT_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + totalWiValue); //added by Mike, 20190416; edited by Mike, 20190425 slcValue = 0; if (nonHmoContainer.containsKey(classificationSLC)) { slcValue = (int) nonHmoContainer.get(classificationSLC)[OUTPUT_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + slcValue); //edited by Mike, 20190425 pwdValue = 0; if (nonHmoContainer.containsKey(classificationPWD)) { pwdValue = (int) nonHmoContainer.get(classificationPWD)[OUTPUT_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + pwdValue); //edited by Mike, 20190425 scValue = 0; if (nonHmoContainer.containsKey(classificationSC)) { scValue = (int) nonHmoContainer.get(classificationSC)[OUTPUT_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + scValue); //added by Mike, 20190417 s = s.replace("", "" + (int) totalTreatmentHMOCount); //added by Mike, 20190417 if (s.contains("")) { //added by Mike, 20190426 totalTreatmentNewCasesCount = 0; for (String key : sortedClassifiedKeyset) { s = s.concat("\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + key + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + classifiedDiagnosedCasesContainer.get(key) + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t "); //added by Mike, 20190426 totalTreatmentNewCasesCount += classifiedDiagnosedCasesContainer.get(key); } } //added by Mike, 20190426 s = s.replace("", "" + (int) totalTreatmentNewCasesCount); //added by Mike, 20190417 if (s.contains("; ")) { s = s.replace("; ", ""); //Write the names of the top 3 cases, separated by a semicolon and a blank space int rankCount = 0; for (Entry entry : sortedClassifiedDiagnosedCasesContainerList) { if (rankCount < 2) { s = s.concat(entry.getKey()+"; "); rankCount++; } else { s = s.concat(entry.getKey()); break; } } s = s.concat(""); } writer.print(s + "\n"); } writer.close(); } //added by Mike, 20190422 private static void processWriteOutputFileConsultation(PrintWriter writer) throws Exception { File f = new File(inputOutputTemplateFilenameConsultation+".html"); // System.out.println("inputOutputTemplateFilenameConsultation: " + inputOutputTemplateFilenameConsultation); Scanner sc = new Scanner(new FileInputStream(f), "UTF-8"); String s; // s=sc.nextLine(); //skip the first row, which is the input file's table headers if (isInDebugMode) { rowCount=0; } //added by Mike, 20190417 SortedSet sortedClassifiedKeyset = new TreeSet(classifiedDiagnosedCasesContainer.keySet()); //added by Mike, 20190424 SortedSet sortedMedicalDoctorTransactionCountKeyset = new TreeSet(medicalDoctorContainer.keySet()); //added by Mike, 20190417 Set> classifiedDiagnosedCasesContainerSet = classifiedDiagnosedCasesContainer.entrySet(); List> sortedClassifiedDiagnosedCasesContainerList = new ArrayList>(classifiedDiagnosedCasesContainerSet); /* //added by Mike, 20190424 Set> medicalDoctorContainerSet = medicalDoctorContainer.entrySet(); List> sortedMedicalDoctorContainerList = new ArrayList>(medicalDoctorContainerSet); */ //edited by Mike, 20190418 //Removed inner class "Comparator" so that there will be no "generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles$1.class" after compiling the "generateMonthlySummaryReportWithDiagnosedCasesOfAllInputFiles.java" /*Collections.sort(sortedClassifiedDiagnosedCasesContainerList, new Comparator>() { public int compare(Map.Entry o1, Map.Entry o2) { return o2.getValue().compareTo(o1.getValue()); } });*/ Collections.sort(sortedClassifiedDiagnosedCasesContainerList, new IncidenceNumberComparator()); /*Collections.sort(sortedMedicalDoctorContainerList, new IncidenceNumberComparator()); //added by Mike, 20190424 */ //count/compute the number-based values of inputColumns while (sc.hasNextLine()) { s=sc.nextLine(); /* //if the row is blank if (s.trim().equals("")) { continue; } */ if (isInDebugMode) { rowCount++; // System.out.println("rowCount: "+rowCount); } //added by Mike, 20190414 //This is to resolve the following character-encoding issue. //This is not anymore necessary due to setting the scanner to use UTF-8 // s = s.replace("Â", ""); // System.out.println("s: "+s); // System.out.println("totalTreatmentCount: "+totalTreatmentCount); //added by Mike, 20190417 s = s.replace("", "" + dateValue.toUpperCase()); s = s.replace("", "" + totalConsultationCount); //added by Mike, 20190416; edited by Mike, 20190423 s = s.replace("", "" + (int) totalNewPatientPerDoctorCount); //added by Mike, 20190423 s = s.replace("", "" + (int) totalFollowUpPerDoctorCount); //added by Mike, 20190423 s = s.replace("", "" + (int) totalOldPatientPerDoctorCount); //added by Mike, 20190423 s = s.replace("", "" + (int) totalProcedurePerDoctorCount); //added by Mike, 20190416; edited by Mike 20190425 totalWiValue = 0; if (nonHmoContainer.containsKey(classificationWI)) { totalWiValue = (int) nonHmoContainer.get(classificationWI)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; } //added by Mike, 20190424; edited by Mike, 20190425 if (nonHmoContainer.containsKey(classificationWI_MCDO)) { totalWiValue += (int) nonHmoContainer.get(classificationWI_MCDO)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; s = s.replace("", "" + (int) nonHmoContainer.get(classificationWI_MCDO)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]); } else { //added by Mike, 20190427 s = s.replace("", "0"); } s = s.replace("", "" + totalWiValue); //added by Mike, 20190425 noChargeValue = 0; if (nonHmoContainer.containsKey(classificationNO_CHARGE)) { noChargeValue = (int) nonHmoContainer.get(classificationNO_CHARGE)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + noChargeValue); //added by Mike, 20190416; edited by Mike, 20190425 slcValue = 0; if (nonHmoContainer.containsKey(classificationSLC)) { slcValue = (int) nonHmoContainer.get(classificationSLC)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + slcValue); //added by Mike, 20190425 slrValue = 0; if (nonHmoContainer.containsKey(classificationSLR)) { slrValue = (int) nonHmoContainer.get(classificationSLR)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + slrValue); //added by Mike, 20190425 scValue = 0; if (nonHmoContainer.containsKey(classificationSC)) { scValue = (int) nonHmoContainer.get(classificationSC)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + scValue); //added by Mike, 20190425 pwdValue = 0; if (nonHmoContainer.containsKey(classificationPWD)) { pwdValue = (int) nonHmoContainer.get(classificationPWD)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; } s = s.replace("", "" + pwdValue); //added by Mike, 20190417 s = s.replace("", "" + (int) totalConsultationHMOCount); /* //The following set of instructions are my guide. //added by Mike, 20190424 for (String key : sortedMedicalDoctorTransactionCountKeyset) { double count = medicalDoctorContainer.get(key)[OUTPUT_HMO_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_NON_HMO_COUNT_COLUMN]; double newPatientReferralTransactionCount = medicalDoctorContainer.get(key)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20181219 double consultationCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; //added by Mike, 20181219 double procedureCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]; //added by Mike, 20190109 double medicalCertificateCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]; //added by Mike, 20190202 double newPatientCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; //added by Mike, 20190202 double followUpCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_FOLLOW_UP_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_FOLLOW_UP_COUNT_COLUMN]; //added by Mike, 20190202 double oldPatientCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_OLD_PATIENT_COUNT_COLUMN]; */ //added by Mike, 20190417; edited by Mike, 20190424 if (s.contains("")) { double consultationCount = 0; for (String key : sortedMedicalDoctorTransactionCountKeyset) { //edited by Mike, 20190426 consultationCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; if (consultationCount == 0) { continue; } s = s.concat("\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); //This portion is for the Medical Doctor's name s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); //This portion is for the Medical Doctor's total consult count //edited by Mike, 20190426 s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); //This portion is for the Medical Doctor's total count of new patient transactions double newPatientTransactionCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_NEW_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); //This portion is for the Medical Doctor's total count of follow-up patient transactions double followUpCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_FOLLOW_UP_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_FOLLOW_UP_COUNT_COLUMN]; s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); //This portion is for the Medical Doctor's total count of old patient transactions double oldPatientCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_OLD_PATIENT_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_OLD_PATIENT_COUNT_COLUMN]; s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); //This portion is for the Medical Doctor's total count of procedure transactions double procedureCount = medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] + medicalDoctorContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]; s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t " + key + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t CONSULT:\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + (int) consultationCount + "\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t NEW:\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + (int) newPatientTransactionCount + "\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t FOLLOW-UP:\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + (int) followUpCount + "\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t OLD:\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + (int) oldPatientCount + "\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t PROCEDURE/S:\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + (int) procedureCount + "\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
\n"); s = s.concat("\t\t\t\t\t
"); /* s = s.concat("\t\t\t\t\t " + classifiedDiagnosedCasesContainer.get(key) + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t "); */ } } /* //The following set of instructions are my guide. */ /* if (s.contains("")) { for (String key : sortedClassifiedKeyset) { s = s.concat("\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t "); } } //added by Mike, 20190417 if (s.contains("; ")) { s = s.replace("; ", ""); //Write the names of the top 3 cases, separated by a semicolon and a blank space int rankCount = 0; for (Entry entry : sortedClassifiedDiagnosedCasesContainerList) { if (rankCount < 2) { s = s.concat(entry.getKey()+"; "); rankCount++; } else { s = s.concat(entry.getKey()); break; } } s = s.concat(""); } */ writer.print(s + "\n"); } writer.close(); } /* private static void resetNonHMOContainerCount() { //added by Mike, 20181220 SortedSet sortedNonHMOKeyset = new TreeSet(nonHmoContainer.keySet()); for (String key : sortedNonHMOKeyset) { nonHmoContainer.get(key)[OUTPUT_NON_HMO_COUNT_COLUMN] = 0; nonHmoContainer.get(key)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] = 0; } } */ //added by Mike, 20190128 private static void consolidateKeysAndTheirHashMapValuesInContainer(HashMap> container) { SortedSet sortedKeyset = new TreeSet(container.keySet()); SortedSet sortedKeysetTwo = new TreeSet(container.keySet()); int threshold; //added by Mike, 20190127 //At present, the key is the name of the Medical Doctor for (String key : sortedKeyset) { for (String keyTwo : sortedKeysetTwo) { // System.out.println(">>> Compare the Difference between Strings!"); /* System.out.println(myLevenshteinDistance.apply(key, keyTwo)); System.out.println("key: "+key+" : keyTwo: "+keyTwo); */ if (key.equals(keyTwo)) { continue; } threshold = 3; //Similar with the for Referring Medical Doctors, the numerical value should be less than 3. if (myLevenshteinDistance.apply(key, keyTwo) sortedclassificationContainerPerMedicalDoctorTransactionCountKeyset = new TreeSet(container.get(key).keySet()); for (String classificationKey : sortedclassificationContainerPerMedicalDoctorTransactionCountKeyset) { //treatmentCount container.get(key).get(classificationKey)[OUTPUT_HMO_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_HMO_COUNT_COLUMN]; container.get(key).get(classificationKey)[OUTPUT_NON_HMO_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_NON_HMO_COUNT_COLUMN]; //consultationCount container.get(key).get(classificationKey)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_CONSULTATION_HMO_COUNT_COLUMN]; container.get(key).get(classificationKey)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_CONSULTATION_NON_HMO_COUNT_COLUMN]; //procedureCount container.get(key).get(classificationKey)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_CONSULTATION_HMO_PROCEDURE_COUNT_COLUMN]; container.get(key).get(classificationKey)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_CONSULTATION_NON_HMO_PROCEDURE_COUNT_COLUMN]; //medicalCertificateCount container.get(key).get(classificationKey)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_CONSULTATION_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]; container.get(key).get(classificationKey)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_CONSULTATION_NON_HMO_MEDICAL_CERTIFICATE_COUNT_COLUMN]; //newPatientReferralTransactionCount container.get(key).get(classificationKey)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_HMO_NEW_PATIENT_COUNT_COLUMN]; container.get(key).get(classificationKey)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN] += container.get(keyTwo).get(classificationKey)[OUTPUT_NON_HMO_NEW_PATIENT_COUNT_COLUMN]; } container.remove(keyTwo); consolidateKeysAndTheirHashMapValuesInContainer(container); return; } } } } //added by Mike, 20190126 private static void consolidateKeysAndTheirValuesInContainer(HashMap container, int containerType) { SortedSet sortedKeyset = new TreeSet(container.keySet()); SortedSet sortedKeysetTwo = new TreeSet(container.keySet()); int threshold; //added by Mike, 20190127 for (String key : sortedKeyset) { //added by Mike, 20190127 if (containerType==HMO_CLASSIFICATION_CONTAINER_PER_MEDICAL_DOCTOR_CONTAINER_TYPE) { if (!key.contains("HMO")) { /* System.out.println("Not HMO"); System.out.println("key: "+key); */ continue; } } for (String keyTwo : sortedKeysetTwo) { // System.out.println(">>> Compare the Difference between Strings!"); /* System.out.println(myLevenshteinDistance.apply(key, keyTwo)); System.out.println("key: "+key+" : keyTwo: "+keyTwo); */ if (key.equals(keyTwo)) { continue; } //compare the two key strings; if the result is a numerical value that is less than 2, combine the two //Note: We use less than 2, so that "MEDOCARE", with the "MEDO", and MEDICARE, with the "MEDI", are recognized by the add-on software as distinct. threshold = 2; //default value if (containerType==REFERRING_DOCTOR_CONTAINER_TYPE) { //In this case, the numerical value should be less than 3. threshold = 3; } if (myLevenshteinDistance.apply(key, keyTwo) sortedclassificationContainerPerMedicalDoctorTransactionCountKeyset = new TreeSet(classificationContainerPerMedicalDoctor.keySet()); for (String key : sortedclassificationContainerPerMedicalDoctorTransactionCountKeyset) { // System.out.println(">>>> key: "+key); consolidateKeysAndTheirValuesInContainer(classificationContainerPerMedicalDoctor.get(key), HMO_CLASSIFICATION_CONTAINER_PER_MEDICAL_DOCTOR_CONTAINER_TYPE); /* consolidateKeysAndTheirValuesInContainer(classificationContainerPerMedicalDoctor.get(key), NON_HMO_CLASSIFICATION_CONTAINER_PER_MEDICAL_DOCTOR_CONTAINER_TYPE); */ } consolidateKeysAndTheirHashMapValuesInContainer(classificationContainerPerMedicalDoctor); // System.out.println(">>> Compare the Difference between Strings!"); // System.out.println(myLevenshteinDistance.apply("1234567890", "1")); //answer: 9 // hmoContainer = new HashMap(); // nonHmoContainer = new HashMap(); // referringDoctorContainer = new HashMap(); //// medicalDoctorContainer = new HashMap(); // classificationContainerPerMedicalDoctor = new HashMap>(); } //added by Mike, 20190413 private static void processDiagnosedCasesCount(HashMap diagnosedCasesContainer, String[] inputColumns, boolean isConsultation) { String diagnosedCaseName = inputColumns[INPUT_DIAGNOSIS_COLUMN].trim().toUpperCase(); if (!isConsultation) { if (inputColumns[INPUT_NEW_OLD_PATIENT_COLUMN].trim().toLowerCase().contains("new")) { //added by Mike, 20190426 String[] diagnosedCaseNameArray = diagnosedCaseName.split(","); for (int i=0; i< diagnosedCaseNameArray.length; i++) { diagnosedCaseName = diagnosedCaseNameArray[i].replace("\"", "").trim(); if (diagnosedCaseName.equals("")){ System.out.println("STOP!"); } if (!diagnosedCasesContainer.containsKey(diagnosedCaseName)) { diagnosedCasesContainer.put(diagnosedCaseName, 1); } else { int currentValue = diagnosedCasesContainer.get(diagnosedCaseName)+1; /* System.out.println("diagnosedCaseName: " + diagnosedCaseName); System.out.println("currentValue: " + currentValue); */ diagnosedCasesContainer.put(diagnosedCaseName, currentValue);//++); //the existing value of the key is replaced } } /* if (diagnosedCaseName.equals("")){ System.out.println("STOP!"); } if (!diagnosedCasesContainer.containsKey(diagnosedCaseName)) { diagnosedCasesContainer.put(diagnosedCaseName, 1); } else { int currentValue = diagnosedCasesContainer.get(diagnosedCaseName); diagnosedCasesContainer.put(diagnosedCaseName, currentValue++); //the existing value of the key is replaced } */ } } else { //TO-DO: -add: handle Consultation transactions } } //added by Mike, 20190412 private static void processDiagnosisClassification() { SortedSet sortedKeyset = new TreeSet(diagnosedCasesContainer.keySet()); //edited by Mike, 20190430 /* SortedSet sortedKnownDiagnosedCasesKeyset = new TreeSet(knownDiagnosedCasesContainer.keySet()); */ String classificationKey = ""; String subClassification = ""; String classification = ""; boolean hasKnownDiagnosedCaseKeywords=false; for (String inputString : sortedKeyset) { //added by Mike, 20190224 String[] inputStringArray = inputString.replace("-"," ").split(" "); // System.out.println(">>>>>>> inputString: "+inputString); //edited by Mike, 20190430 // for (String knownDiagnosedCasesKey : sortedKnownDiagnosedCasesKeyset) { //the key is the sub-classification for (int h=0; h>>>>>> inputString: "+inputString); } if (subClassification.toLowerCase().contains("trigger")) { System.out.println(">>> subClassification: "+subClassification); System.out.println(">>> classification: "+classification); } */ String[] s = subClassification.split(" "); // System.out.println(">>> subClassification: "+subClassification); for(int i=0; i>>> : "+s[i]); int k; //edited by Mike, 20190430 for(k=0; k=0; k--) { // System.out.println(">> "+inputStringArray[k]); if (inputStringArray[k].trim().toUpperCase().equals(s[i].trim().toUpperCase())) { hasKnownDiagnosedCaseKeywords=true; break; } // else { // System.out.println(">> true: "+inputString +" : "+s[i]); // } } if (k==inputStringArray.length) { hasKnownDiagnosedCaseKeywords=false; break; } } if (hasKnownDiagnosedCaseKeywords) { break; } /* for(int i=0; i> true: "+inputString +" : "+s[i]); } hasKnownDiagnosedCaseKeywords=true; } */ /* classificationKey = inputString; if (hasKnownDiagnosedCaseKeywords) { classificationKey = classification; if (inputString.toLowerCase().contains("trigger")) { System.out.println(">>> inputString: "+inputString); System.out.println(">>> classificationKey: "+classificationKey); } break; } */ // System.out.println(knownDiagnosedCasesKey + " : " + knownDiagnosedCasesContainer.get(key)); } classificationKey = inputString; if (hasKnownDiagnosedCaseKeywords) { classificationKey = classification; /* if (inputString.toLowerCase().contains("fx")) { System.out.println(">>> inputString: "+inputString); System.out.println(">>> classificationKey: "+classificationKey); } */ // break; } if (!classifiedDiagnosedCasesContainer.containsKey(classificationKey)) { /* System.out.println(">>> !classifiedDiagnosedCasesContainer. (classificationKey)"); System.out.println(">>> inputString: "+inputString); System.out.println(">>> classificationKey: "+classificationKey); */ //edited by Mike, 20190429 // classifiedDiagnosedCasesContainer.put(classificationKey,1); classifiedDiagnosedCasesContainer.put(classificationKey, diagnosedCasesContainer.get(inputString)); } else { /* System.out.println(">>> ELSE"); System.out.println(">>> inputString: "+inputString); System.out.println(">>> classificationKey: "+classificationKey); */ //edited by Mike, 20190429 // int currentCount = classifiedDiagnosedCasesContainer.get(classificationKey)+1; int currentCount = classifiedDiagnosedCasesContainer.get(classificationKey)+ diagnosedCasesContainer.get(inputString); /* if (inputString.equals("HNP")) { System.out.println(">>> ELSE"); System.out.println(">>> inputString: "+inputString); System.out.println(">>> classificationKey: "+classificationKey); System.out.println(">>> diagnosedCasesContainer.get(inputString): "+diagnosedCasesContainer.get(inputString)); System.out.println(">>> currentCount: "+currentCount); } */ classifiedDiagnosedCasesContainer.put(classificationKey,currentCount);//+1); } /* double diagnosedCaseCount = diagnosedCasesContainer.get(key); writer.println( key + "\t" + diagnosedCaseCount+"\n" ); */ } // SortedSet sortedClassifiedDiagnosedCasesKeyset = new TreeSet(classifiedDiagnosedCasesContainer.keySet()); // for (String key : sortedClassifiedDiagnosedCasesKeyset) { // int diagnosedCaseCount = classifiedDiagnosedCasesContainer.get(key); // // System.out.print( // key + "\t" + // diagnosedCaseCount+"\n" // ); // } } //TO-DO: -update: this to use existing values //added by Mike, 20190503; edited by Mike, 20190504 //store the existing values from the assets file into Random Access Memory (RAM) private static void processMonthlyStatisticsData(int fileType) throws Exception { File inputDataFile; switch (fileType) { case TREATMENT_FILE_TYPE: inputDataFile = new File(inputDataFilenameTreatmentMonthlyStatistics+".txt"); break; case CONSULTATION_FILE_TYPE: inputDataFile = new File(inputDataFilenameConsultationMonthlyStatistics+".txt"); break; default:// PROCEDURE_FILE_TYPE: inputDataFile = new File(inputDataFilenameProcedureMonthlyStatistics+".txt"); break; } Scanner sc = new Scanner(new FileInputStream(inputDataFile), "UTF-8"); String s; //System.out.println(">>>> fileType: " + fileType); s=sc.nextLine(); //process input file's YEAR row String[] inputYearColumns = s.split("\t"); //edited by Mike, 20190504 SortedSet sortedMonthlyStatisticsContainerKeyset = null; for(int i=0; i(treatmentMonthlyStatisticsContainer.keySet()); break; case CONSULTATION_FILE_TYPE: consultationMonthlyStatisticsContainer.put(Integer.parseInt(inputYearColumns[i].trim()), new Integer[12]); //there are 12 Months sortedMonthlyStatisticsContainerKeyset = new TreeSet(consultationMonthlyStatisticsContainer.keySet()); break; default:// PROCEDURE_FILE_TYPE: procedureMonthlyStatisticsContainer.put(Integer.parseInt(inputYearColumns[i].trim()), new Integer[12]); //there are 12 Months sortedMonthlyStatisticsContainerKeyset = new TreeSet(procedureMonthlyStatisticsContainer.keySet()); break; } // System.out.println("inputYearColumns["+i+"]: "+inputYearColumns[i]); } // SortedSet sortedTreatmentMonthlyStatisticsContainerKeyset = new TreeSet(treatmentMonthlyStatisticsContainer.keySet()); yearsContainerArrayList = new ArrayList(); for (Integer key : sortedMonthlyStatisticsContainerKeyset) { //System.out.println("year key: "+key); yearsContainerArrayList.add(key); } if (isInDebugMode) { rowCount=0; } int monthRowIndex=0; while (sc.hasNextLine()) { s=sc.nextLine(); //if the row is blank if (s.trim().equals("")) { continue; } if (isInDebugMode) { rowCount++; // System.out.println("rowCount: "+rowCount); } //added by Mike, 20190503 String[] inputMonthRowYearColumns = s.split("\t"); for(int i=0; i>>>inputMonthRowYearColumns: "+i+1+"; "+inputMonthRowYearColumns[i+1]); System.out.println(">>>>yearKey: "+yearKey+"; monthRowIndex: "+monthRowIndex); System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"+consultationMonthlyStatisticsContainer.get(yearKey)[monthRowIndex]); */ break; default:// PROCEDURE_FILE_TYPE: procedureMonthlyStatisticsContainer.get(yearKey)[monthRowIndex] = Integer.parseInt(inputMonthRowYearColumns[i+1]); break; } //treatmentMonthlyStatisticsContainer.get(yearKey)[monthRowIndex] = Integer.parseInt(inputMonthRowYearColumns[i+1]); // System.out.println("yearKey: "+yearKey); // System.out.println(i+": "+inputMonthRowYearColumns[i+1]); } } monthRowIndex++; } } }
LAST NAME OF MEDICAL DOCTOR
CONSULT:
NEW:
FOLLOW-UP:
OLD:
PROCEDURE/S:
\n"); s = s.concat("\t\t\t\t\t " + key + "\n"); s = s.concat("\t\t\t\t\t \n"); s = s.concat("\t\t\t\t\t " + classifiedDiagnosedCasesContainer.get(key) + "\n"); s = s.concat("\t\t\t\t\t