Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package gosi.business.socialinsurance.occupationalhazards.injury.session;
- import gosi.core.util.ServiceLocator;
- import gosi.core.util.GOSIDebug;
- import javax.ejb.SessionBean;
- import javax.ejb.SessionContext;
- import javax.ejb.EJBException;
- import java.rmi.RemoteException;
- import javax.naming.Context;
- import javax.naming.InitialContext;
- import javax.naming.NamingException;
- import java.sql.Connection;
- import java.sql.Date;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.io.Serializable;
- import gosi.core.util.GOSIInstrumentationLog;
- import gosi.business.socialinsurance.occupationalhazards.injury.beans.SFDABean;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.TreatmentServiceBean;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.InjuryPopDetails;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.TreatmentTypeBean;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.TreatmentPeriodBean;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.TreatmentQueryBean;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.TreatmentHeaderBean;
- import gosi.database.socialinsurance.occupationalhazards.
- injury.entity.TreatmentServiceDetailEntity;
- import gosi.database.socialinsurance.occupationalhazards.
- injury.entity.TreatmentServiceDetailEntityHome;
- import gosi.database.socialinsurance.occupationalhazards.
- injury.entity.TreatmentServiceHeaderEntity;
- import gosi.database.socialinsurance.occupationalhazards.
- injury.entity.TreatmentServiceHeaderEntityHome;
- import gosi.business.socialinsurance.occupationalhazards.injury.
- beans.HospitalListBean;
- import gosi.business.socialinsurance.occupationalhazards.injury.
- beans.OHPopSearchBean;
- import gosi.rules.socialinsurance.occupationalhazards.beans.OHRuleBean;
- import gosi.core.util.GOSIException;
- import gosi.core.util.GOSIUtilities;
- import gosi.core.util.GOSIConstants;
- import gosi.core.util.GOSIErrorMessages;
- import gosi.core.util.GOSIDateUtilities;
- import gosi.core.util.GOSILdapService;
- import gosi.core.util.GOSIApplicationProperties;
- import java.util.ArrayList;
- import java.util.Hashtable;
- import java.sql.Timestamp;
- import gosi.core.util.beans.NavigationBean;
- import gosi.business.socialinsurance.occupationalhazards.common.beans.
- OHUtilities;
- import gosi.business.socialinsurance.occupationalhazards.common.beans.
- OHConstants;
- import gosi.business.socialinsurance.common.beans.SITables;
- import javax.rmi.PortableRemoteObject;
- import gosi.core.util.beans.AuditBean;
- import java.util.HashMap;
- import gosi.core.workflow.beans.WorkflowParamBean;
- import gosi.business.socialinsurance.common.beans.PersonBean;
- import gosi.business.socialinsurance.common.beans.PersonUtilities;
- import gosi.business.socialinsurance.registration.engagement.
- beans.ContributorBean;
- import gosi.business.socialinsurance.registration.engagement.
- beans.ContributorUtilities;
- import gosi.business.socialinsurance.registration.
- establishment.beans.EstablishmentUtility;
- import gosi.business.socialinsurance.registration.
- establishment.beans.EstablishmentBean;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.CompanionBean;
- import gosi.core.dms.beans.DMSRequestHeaderBean;
- import gosi.core.dms.beans.DMSConstants;
- import gosi.core.dms.util.DMSUtilities;
- import gosi.business.socialinsurance.occupationalhazards.
- injury.beans.TreatmentServiceBean;
- import gosi.business.socialinsurance.occupationalhazards.injury.beans.TrtmServiceHeaderBean;
- import gosi.business.socialinsurance.occupationalhazards.injury.beans.TrtmServiceDetailBean;
- import gosi.business.socialinsurance.occupationalhazards.injury.beans.TrtmServiceBean;
- import gosi.business.socialinsurance.occupationalhazards.medicalboard.beans.OHDAssessmentHeaderBean;
- import gosi.database.socialinsurance.occupationalhazards.injury.
- entity.TrtmServiceListEntityHome;
- import gosi.database.socialinsurance.occupationalhazards.injury.
- entity.TrtmServiceListEntity;
- import gosi.database.socialinsurance.occupationalhazards.injury.
- entity.TrtmServiceListHistoryEntityHome;
- import gosi.database.socialinsurance.occupationalhazards.injury.
- entity.TrtmServiceListHistoryEntity;
- import java.io.File;
- import java.io.BufferedInputStream;
- import java.io.DataInputStream;
- import java.io.FileInputStream;
- import java.io.FileNotFoundException;
- import java.io.IOException;
- import jxl.Cell;
- import jxl.CellType;
- import jxl.Sheet;
- import jxl.Workbook;
- import jxl.read.biff.BiffException;
- /**
- *
- * @stereotype SessionBean
- * @homeInterface gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentServiceSessionHome
- * @remoteInterface gosi.business.socialinsurance.occupationalhazards.injury.session.MaintainTreatmentServiceSession
- */
- public class MaintainTreatmentServiceSessionEJB implements
- SessionBean
- {
- private Connection con = null;
- private ResultSet rs = null;
- private PreparedStatement p = null;
- private SessionContext ctx;
- /* This method is used to get the injury details */
- /**
- * @METHOD NAME : searchInjuryList
- * @INFORMATION : This method is to search Injury List
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public ArrayList searchInjuryList
- (InjuryPopDetails searchInjuryBean)
- throws GOSIException
- {
- int injuryListSize = 0;
- long timeCounter = 0;
- long establishmentId = 0;
- Timestamp injuryDate = null;
- StringBuffer sbQuery = new StringBuffer();
- String contributorName = "";
- ArrayList injuryListTemp = new ArrayList();
- ArrayList injuryList = new ArrayList();
- try
- {
- GOSIDebug.debugMessages("inside the Function searchInjury");
- Long socInsNum = searchInjuryBean.getSocialInsuranceNumber();
- String entryFormat = searchInjuryBean.getInjuryDateEntFmt();
- Short fieldOffice = searchInjuryBean.getFieldOffice();
- GOSIDebug.debugMessages("fieldOffice in search &&&" +
- fieldOffice);
- timeCounter = System.currentTimeMillis();
- if(OHConstants.HIJRAH.equals(searchInjuryBean.
- getInjuryDateEntFmt()))
- {
- injuryDate = GOSIUtilities.getTimestamp
- (GOSIDateUtilities.convertToGregorian
- (searchInjuryBean.getInjuryDateStr()));
- }
- else
- {
- injuryDate = GOSIUtilities.getTimestamp(
- searchInjuryBean.getInjuryDateStr());
- }
- searchInjuryBean.setInjuryDate(injuryDate);
- GOSIDebug.debugMessages("SIN:"+socInsNum+"\n InjuryDate:"+
- injuryDate);
- /*
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.INJURYID,A.SOCINSNUMBER, " );
- sbQuery.append(" B.REGISTRATIONNUMBER,A.INJURYDATE, " );
- sbQuery.append(" A.DATECOMPLICATION,A.INJURYNUMBER,A.DESCRIPTION, ");
- sbQuery.append(" D.FIRSTNAME || ' ' || " );
- sbQuery.append(" NVL(D.SECONDNAME,'')|| ' ' || ");
- sbQuery.append(" NVL(D.THIRDNAME,'')||' ' || " );
- sbQuery.append(" NVL(D.SURNAME,'') NAME,D.NAMEENGLISH, " );
- sbQuery.append(" D.NATIONALITYCODE, ");
- sbQuery.append(" A.CONTRIBUTORID, " );
- sbQuery.append(" A.establishmentid FROM ");
- sbQuery.append( SITables.T_INJURY + " A , " );
- sbQuery.append( SITables.T_ESTABLISHMENT + " B, ");
- sbQuery.append( SITables.T_CONTRIBUTOR + " C, ");
- sbQuery.append( SITables.T_PERSON + " D WHERE ");
- sbQuery.append(" A.ESTABLISHMENTID = B.ESTABLISHMENTID " );
- sbQuery.append(" AND A.CONTRIBUTORID = C.CONTRIBUTORID ");
- sbQuery.append(" AND C.PERSONID = D.PERSONID " );
- sbQuery.append(" AND A.INJURYSTATUS NOT IN ( ? , ? ) " );
- sbQuery.append(" AND A.INJURYDATE = ? ");
- sbQuery.append(" AND A.SOCINSNUMBER = ? " );
- */
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.INJURYID,A.SOCINSNUMBER, " );
- sbQuery.append(" A.INJURYDATE, " );
- sbQuery.append(" A.DATECOMPLICATION,A.INJURYNUMBER,A.DESCRIPTION, ");
- sbQuery.append(" A.CONTRIBUTORID, " );
- sbQuery.append(" A.ESTABLISHMENTID FROM ");
- sbQuery.append( SITables.T_INJURY + " A " );
- sbQuery.append(" WHERE ");
- sbQuery.append(" A.INJURYSTATUS != ? " );
- sbQuery.append(" AND A.INJURYDATE = ? ");
- sbQuery.append(" AND A.SOCINSNUMBER = ? " );
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- con = GOSIUtilities.getConnection(GOSIConstants.
- OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- int k =0;
- //p.setShort(1,OHConstants.INJ_STS_REJECTED.shortValue());
- p.setShort(++k,OHConstants.INJ_STS_CANCELLED.shortValue());
- p.setTimestamp(++k,injuryDate);
- p.setLong(++k,socInsNum.longValue());
- rs = p.executeQuery();
- while(rs.next())
- {
- GOSIDebug.debugMessages("SearchInjury Has Records");
- InjuryPopDetails injuryDetails = new InjuryPopDetails();
- injuryDetails.setInjuryID(new Long(rs.getLong("INJURYID")));
- injuryDetails.setSocialInsuranceNumber
- (new Long(rs.getLong("SOCINSNUMBER")));
- injuryDetails.setInjuryDate(rs.getTimestamp("INJURYDATE"));
- injuryDetails.setInjuryDateStr(OHUtilities.getDateStr(
- injuryDetails.getInjuryDate(),entryFormat));
- injuryDetails.setInjuryNumber
- (new Long(rs.getLong("INJURYNUMBER")));
- if(rs.getObject("DATECOMPLICATION")!=null)
- {
- injuryDetails.setComplicationDate
- (rs.getTimestamp("DATECOMPLICATION"));
- injuryDetails.setComplicationDateStr(OHUtilities.getDateStr
- (injuryDetails.getComplicationDate(),entryFormat));
- }
- injuryDetails.setDescription(rs.getString("DESCRIPTION"));
- //injuryDetails.setName(rs.getString("NAME"));
- //injuryDetails.setNationality(new Short
- // (rs.getShort("NATIONALITYCODE")));
- //injuryDetails.setFieldOffice(new Short
- //(rs.getShort("FIELDOFFICECODE")));
- injuryDetails.setFieldOffice
- (fieldOffice);
- injuryDetails.setInjuryDateEntFmt(entryFormat);
- injuryDetails.setContributorId(
- new Long(rs.getLong("CONTRIBUTORID")));
- establishmentId = rs.getLong("ESTABLISHMENTID");
- GOSIDebug.debugMessages("est id *" + establishmentId );
- ContributorBean oContributorBean =
- new ContributorBean();
- oContributorBean = ContributorUtilities.
- displayContributor(injuryDetails.getContributorId());
- GOSIDebug.debugMessages("PersonId::"+oContributorBean.
- getPersonId());
- PersonBean oPersonBean = new PersonBean();
- oPersonBean = PersonUtilities.
- displayPerson(oContributorBean.getPersonId());
- GOSIDebug.debugMessages("first name" +
- oPersonBean.getFirstName());
- GOSIDebug.debugMessages("first name" +
- oPersonBean.getFirstName());
- GOSIDebug.debugMessages("second name" +
- oPersonBean.getSecondName());
- GOSIDebug.debugMessages("third name" +
- oPersonBean.getThirdName());
- GOSIDebug.debugMessages("surname" +
- oPersonBean.getSurName());
- GOSIDebug.debugMessages("name english" +
- oPersonBean.getNameEnglish());
- contributorName = oPersonBean.getFirstName();
- if(oPersonBean.getSecondName() != null)
- {
- contributorName += " " + oPersonBean.getSecondName();
- }
- if(oPersonBean.getThirdName() != null)
- {
- contributorName += " " + oPersonBean.getThirdName();
- }
- if(oPersonBean.getSurName() != null)
- {
- contributorName += " " + oPersonBean.getSurName();
- }
- GOSIDebug.debugMessages("contributor Name ^^^" +
- contributorName);
- injuryDetails.setName(contributorName);
- injuryDetails.setContributorNameEnglish(oPersonBean.getNameEnglish());
- if(oPersonBean.getNationalityCode() != null)
- {
- injuryDetails.setNationality
- (oPersonBean.getNationalityCode());
- }
- GOSIDebug.debugMessages("nationality code ^^^" +
- oPersonBean.getNationalityCode());
- EstablishmentBean oEstablishmentBean =
- new EstablishmentBean();
- EstablishmentUtility oEstablishmentUtility =
- new EstablishmentUtility();
- oEstablishmentBean = oEstablishmentUtility.
- getEstablishmentDetails(establishmentId,
- false,true);
- GOSIDebug.debugMessages("reg no" + oEstablishmentBean.
- getRegistrationNumber());
- if(oEstablishmentBean != null)
- {
- injuryDetails.setRegistrationNumber
- (oEstablishmentBean.
- getRegistrationNumber());
- }
- injuryListTemp.add(injuryDetails);
- }
- GOSIUtilities.cleanUp(rs);
- GOSIDebug.debugMessages("Records in InjuryList:"+
- injuryListTemp.size());
- sbQuery = sbQuery.delete(0,sbQuery.length());
- if(injuryListTemp != null)
- {
- injuryListSize = injuryListTemp.size();
- }
- if(injuryListSize > 1)
- {
- for(int j = 0;j < injuryListSize;j++)
- {
- InjuryPopDetails injuryDetails = null;
- injuryDetails = (InjuryPopDetails)
- injuryListTemp.get(j);
- injuryList.add(injuryDetails);
- }
- }
- if(injuryListSize == 1)
- {
- InjuryPopDetails injuryDetails = null;
- injuryDetails = (InjuryPopDetails)
- injuryListTemp.get(0);
- GOSIDebug.debugMessages("field office in sess" +
- injuryDetails.getFieldOffice());
- if(isSingleHospitalPresent(
- con,injuryDetails.getInjuryID(),
- injuryDetails.getFieldOffice()))
- {
- /*
- sbQuery.append(" SELECT HOSP.HOSPITALCODE, ");
- sbQuery.append(" HOSP.HOSPITALNAME, ");
- sbQuery.append(" TRMT.PATIENTNUMBER FROM ");
- // sbQuery.append(" HOSP.HOSPITALNAMEENG FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT + " HOSP, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.FIELDOFFICECODE " );
- */
- sbQuery.append(" SELECT DISTINCT HOSP.HOSPITALCODE, ");
- sbQuery.append(" HOSP.HOSPITALNAMEARB, ");
- sbQuery.append(" TRMT.PATIENTNUMBER , ");
- sbQuery.append(" HOSP.HOSPITALNAMEENG FROM ");
- sbQuery.append( SITables.T_HOSPITAL + " HOSP, " );
- sbQuery.append( SITables.T_HOSPITALFOASSOCIATION + " HFO, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.HOSPITALCODE = ");
- sbQuery.append(" HFO.HOSPITALCODE ");
- sbQuery.append(" AND HFO.FIELDOFFICECODE " );
- sbQuery.append(" = ? ");
- sbQuery.append(" AND HOSP.HOSPITALTYPE = ? ");
- sbQuery.append(" AND TRMT.TREATMENTSTATUS IN ( ?,? ) ");
- sbQuery.append(" AND TRMT.INJURYID = ? " );
- GOSIDebug.debugMessages("Query: \n"+sbQuery.toString());
- p = con.prepareStatement(sbQuery.toString());
- p.setShort
- (1,injuryDetails.getFieldOffice().shortValue());
- p.setShort
- (2,OHConstants.REG_HOSPITAL.shortValue());
- p.setShort(3,
- OHConstants.TRMT_STS_ENTERED.shortValue());
- p.setShort(4,
- OHConstants.TRMT_STS_APPROVED.shortValue());
- p.setLong(5,injuryDetails.getInjuryID()
- .longValue());
- GOSIDebug.debugMessages("sbQuery" + sbQuery);
- rs = p.executeQuery();
- if(rs.next())
- {
- injuryDetails.setHospitalCode
- (new Long(rs.getLong("HOSPITALCODE")));
- injuryDetails.setPatientNumber
- (rs.getString("PATIENTNUMBER"));
- injuryDetails.setHospitalNameEng(rs.getString("HOSPITALNAMEENG"));
- injuryDetails.setHospitalNameArb(rs.getString("HOSPITALNAMEARB"));
- //injuryDetails.setHospitalNameArb(rs.getString("HOSPITALNAME"));
- }
- GOSIUtilities.cleanUp(rs);
- }
- injuryList.add(injuryDetails);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch (GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("Exception inside PopInjury :"+e);
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "searchInjuryList()",e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "searchInjuryList()",
- (System.currentTimeMillis() - timeCounter));
- return injuryList ;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : getTrtmServicesListByHospital
- * @INFORMATION : This method is to get Treatment Services list
- * @PARAM : class java.util.Long,
- * @RETURN : class java.lang.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public HashMap getTrtmServicesListByHospital(Long hospitalCode)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- HashMap hospitalTreatmentListStock = null;
- TrtmServiceBean objTrtmServiceBean = null;
- Exception ex = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String masterQuery = null;
- String message = "";
- masterQuery = new StringBuffer("Select ").
- append("TRTMSERVICELISTID, ").
- append("HOSPITALCODE, ").
- append("TREATMENTCODE,TREATMENTDESCENG, ").
- append("TREATMENTDESCARB, MEDCATEGORY, ").
- append("PRICE, NEEDSAPPROVAL, ISNONDISCOUNT , ").
- append("CREATEDBY, CREATIONTIMESTAMP, ").
- append("LASTMODIFIEDBY, LASTMODIFIEDTIMESTAMP, ").
- append("STATUS, DOCTORCOMMENTS from ").
- append(SITables.T_TRTMSERVICELIST).
- append(" where HOSPITALCODE = ? ").
- toString();
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(masterQuery);
- ps.setLong(1, hospitalCode);
- rs = ps.executeQuery();
- if(rs.next())
- {
- hospitalTreatmentListStock = new HashMap();
- do
- {
- objTrtmServiceBean = new TrtmServiceBean();
- objTrtmServiceBean.setTrtmServiceListId(
- rs.getLong("TRTMSERVICELISTID"));
- objTrtmServiceBean.setTreatmentCode(
- rs.getString("TREATMENTCODE"));
- objTrtmServiceBean.setHospitalCode(
- rs.getLong("HOSPITALCODE"));
- objTrtmServiceBean.setTreatmentDescEng(
- rs.getString("TREATMENTDESCENG"));
- objTrtmServiceBean.setTreatmentDescArb(
- rs.getString("TREATMENTDESCARB"));
- objTrtmServiceBean.setMedCategory(
- rs.getString("MEDCATEGORY"));
- objTrtmServiceBean.setPrice(
- rs.getDouble("PRICE"));
- objTrtmServiceBean.setNeedsApproval(
- rs.getShort("NEEDSAPPROVAL"));
- objTrtmServiceBean.setIsNonDiscount(
- rs.getByte("ISNONDISCOUNT"));
- objTrtmServiceBean.setCreatedBy(
- rs.getLong("CREATEDBY"));
- objTrtmServiceBean.setCreationTimestamp(
- rs.getTimestamp("CREATIONTIMESTAMP"));
- objTrtmServiceBean.setLastModifiedBy(
- rs.getLong("LASTMODIFIEDBY"));
- objTrtmServiceBean.setLastModifiedTimestamp(
- rs.getTimestamp("LASTMODIFIEDTIMESTAMP"));
- objTrtmServiceBean.setStatus(
- rs.getShort("STATUS"));
- objTrtmServiceBean.setDoctorComments(
- rs.getString("DOCTORCOMMENTS"));
- hospitalTreatmentListStock.put(objTrtmServiceBean.getTreatmentCode().toString(),objTrtmServiceBean);
- }while(rs.next());
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesListByHospital is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesListByHospital is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServicesListByHospital()",
- se,"CMN_ERR_1000" );
- }
- return hospitalTreatmentListStock;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : getTrtmServicesListByHospital
- * @INFORMATION : This method is to get Treatment Services list
- * @PARAM : class java.util.Long,
- * @RETURN : class java.lang.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private HashMap getTrtmServicesDescArbAndEngListByHospital(Long hospitalCode)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- HashMap result = null;
- HashMap hospitalTreatmentDescArb= null;
- HashMap hospitalTreatmentDescEng= null;
- TrtmServiceBean objTrtmServiceBean = null;
- Exception ex = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String masterQuery = null;
- String message = "";
- masterQuery = new StringBuffer("Select ").
- append("TRTMSERVICELISTID, ").
- append("HOSPITALCODE, ").
- append("TREATMENTCODE,TREATMENTDESCENG, ").
- append("TREATMENTDESCARB, MEDCATEGORY, ").
- append("PRICE, NEEDSAPPROVAL, ISNONDISCOUNT , ").
- append("CREATEDBY, CREATIONTIMESTAMP, ").
- append("LASTMODIFIEDBY, LASTMODIFIEDTIMESTAMP, ").
- append("STATUS, DOCTORCOMMENTS from ").
- append(SITables.T_TRTMSERVICELIST).
- append(" where HOSPITALCODE = ? ").
- toString();
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(masterQuery);
- ps.setLong(1, hospitalCode);
- rs = ps.executeQuery();
- if(rs.next())
- {
- result = new HashMap();
- hospitalTreatmentDescArb = new HashMap();
- hospitalTreatmentDescEng = new HashMap();
- do
- {
- objTrtmServiceBean = new TrtmServiceBean();
- objTrtmServiceBean.setTrtmServiceListId(
- rs.getLong("TRTMSERVICELISTID"));
- objTrtmServiceBean.setTreatmentCode(
- rs.getString("TREATMENTCODE"));
- objTrtmServiceBean.setHospitalCode(
- rs.getLong("HOSPITALCODE"));
- objTrtmServiceBean.setTreatmentDescEng(
- rs.getString("TREATMENTDESCENG"));
- objTrtmServiceBean.setTreatmentDescArb(
- rs.getString("TREATMENTDESCARB"));
- objTrtmServiceBean.setMedCategory(
- rs.getString("MEDCATEGORY"));
- objTrtmServiceBean.setPrice(
- rs.getDouble("PRICE"));
- objTrtmServiceBean.setNeedsApproval(
- rs.getShort("NEEDSAPPROVAL"));
- objTrtmServiceBean.setIsNonDiscount(
- rs.getByte("ISNONDISCOUNT"));
- objTrtmServiceBean.setCreatedBy(
- rs.getLong("CREATEDBY"));
- objTrtmServiceBean.setCreationTimestamp(
- rs.getTimestamp("CREATIONTIMESTAMP"));
- objTrtmServiceBean.setLastModifiedBy(
- rs.getLong("LASTMODIFIEDBY"));
- objTrtmServiceBean.setLastModifiedTimestamp(
- rs.getTimestamp("LASTMODIFIEDTIMESTAMP"));
- objTrtmServiceBean.setStatus(
- rs.getShort("STATUS"));
- objTrtmServiceBean.setDoctorComments(
- rs.getString("DOCTORCOMMENTS"));
- hospitalTreatmentDescArb.put(objTrtmServiceBean.getTreatmentDescArb().toString(),objTrtmServiceBean);
- hospitalTreatmentDescEng.put(objTrtmServiceBean.getTreatmentDescEng().toString(),objTrtmServiceBean);
- }while(rs.next());
- result.put("hospitalTreatmentDescArb", hospitalTreatmentDescArb);
- result.put("hospitalTreatmentDescEng", hospitalTreatmentDescEng);
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesListByHospital is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesListByHospital is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServicesListByHospital()",
- se,"CMN_ERR_1000" );
- }
- return result;
- }
- /**
- * @METHOD NAME : getTrtmServiceDetail
- * @INFORMATION : This method is to get Treatment Service Detail
- * @PARAM : class java.lang.Long,
- class java.lang.String
- * @RETURN : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TrtmServiceBean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public TrtmServiceBean getTrtmServiceDetail(Long hospitalCode, String trtmCode)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- TrtmServiceBean objTrtmServiceBean = null;
- Exception ex = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String masterQuery = null;
- String message = "";
- masterQuery = new StringBuffer("Select ").
- append("TRTMSERVICELISTID, ").
- append("HOSPITALCODE, ").
- append("TREATMENTCODE,TREATMENTDESCENG, ").
- append("TREATMENTDESCARB, MEDCATEGORY, ").
- append("PRICE, NEEDSAPPROVAL, ISNONDISCOUNT , ").
- append("CREATEDBY, CREATIONTIMESTAMP, ").
- append("LASTMODIFIEDBY, LASTMODIFIEDTIMESTAMP, ").
- append("STATUS, DOCTORCOMMENTS from ").
- append(SITables.T_TRTMSERVICELIST).
- append(" where HOSPITALCODE = ? AND TREATMENTCODE = ? ").
- toString();
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(masterQuery);
- ps.setLong(1, hospitalCode);
- ps.setString(2, trtmCode);
- rs = ps.executeQuery();
- if(rs.next())
- {
- objTrtmServiceBean = new TrtmServiceBean();
- objTrtmServiceBean.setTrtmServiceListId(
- rs.getLong("TRTMSERVICELISTID"));
- objTrtmServiceBean.setTreatmentCode(
- rs.getString("TREATMENTCODE"));
- objTrtmServiceBean.setHospitalCode(
- rs.getLong("HOSPITALCODE"));
- objTrtmServiceBean.setTreatmentDescEng(
- rs.getString("TREATMENTDESCENG"));
- objTrtmServiceBean.setTreatmentDescArb(
- rs.getString("TREATMENTDESCARB"));
- objTrtmServiceBean.setMedCategory(
- rs.getString("MEDCATEGORY"));
- objTrtmServiceBean.setPrice(
- rs.getDouble("PRICE"));
- objTrtmServiceBean.setNeedsApproval(
- rs.getShort("NEEDSAPPROVAL"));
- objTrtmServiceBean.setIsNonDiscount(
- rs.getByte("ISNONDISCOUNT"));
- objTrtmServiceBean.setCreatedBy(
- rs.getLong("CREATEDBY"));
- objTrtmServiceBean.setCreationTimestamp(
- rs.getTimestamp("CREATIONTIMESTAMP"));
- objTrtmServiceBean.setLastModifiedBy(
- rs.getLong("LASTMODIFIEDBY"));
- objTrtmServiceBean.setLastModifiedTimestamp(
- rs.getTimestamp("LASTMODIFIEDTIMESTAMP"));
- objTrtmServiceBean.setStatus(
- rs.getShort("STATUS"));
- objTrtmServiceBean.setDoctorComments(
- rs.getString("DOCTORCOMMENTS"));
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServiceDetail is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServiceDetail is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServiceDetail()",
- se,"CMN_ERR_1000" );
- }
- return objTrtmServiceBean;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : getPendingTrtmServicesDetailsByHospital
- * @INFORMATION : This method is to get pending Treatment Services details
- * @PARAM : class java.util.Long,
- class java.util.Long,
- * @RETURN : class java.lang.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public HashMap getPendingTrtmServicesDetailsByHospital(Long hospitalCode,Long workflowId)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- HashMap hospitalPendingTreatmentDetails = null;
- HashMap hospitalPendingTreatmentDescArb= null;
- HashMap hospitalPendingTreatmentDescEng= null;
- HashMap result= null;
- TrtmServiceBean objTrtmServiceBean = null;
- Exception ex = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String masterQuery = null;
- String message = "";
- masterQuery = new StringBuffer("Select ").
- append("D.HOSPITALCODE, ").
- append("D.TREATMENTCODE,D.TREATMENTDESCENG, ").
- append("D.TREATMENTDESCARB, D.MEDCATEGORY, ").
- append("D.PRICE, D.NEEDSAPPROVAL, ISNONDISCOUNT , ").
- append("D.STATUS, D.DOCTORCOMMENTS from ").
- append(SITables.T_TRTMSERVICELISTDETAIL).append(" D, ").
- append(SITables.T_TRTMSERVICELISTHEADER).append(" H ").
- append(" where D.HOSPITALCODE = ? AND ").
- append(" D.WORKFLOWID = H.WORKFLOWID AND ").
- append(" H.WORKFLOWSTATUS NOT IN(?,?) AND ").
- append(" H.WORKFLOWID != ? AND ").
- append(" H.TRANSACTIONTYPE in (? , ?) ").
- toString();
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(masterQuery);
- ps.setLong(1, hospitalCode);
- ps.setShort(2, OHConstants.WFS_TRTM_SRVC_LIST_HDR_APPROVED_FO_DIR);
- ps.setShort(3, OHConstants.WFS_TRTM_SRVC_LIST_HDR_CANCELLED);
- ps.setLong(4, workflowId);
- ps.setShort(5, OHConstants.TRTM_TYPE_NEW);
- ps.setShort(6, OHConstants.TRTM_TYPE_MODIFY);
- rs = ps.executeQuery();
- if(rs.next())
- {
- hospitalPendingTreatmentDetails = new HashMap();
- hospitalPendingTreatmentDescArb= new HashMap();
- hospitalPendingTreatmentDescEng= new HashMap();
- result=new HashMap();
- do
- {
- objTrtmServiceBean = new TrtmServiceBean();
- objTrtmServiceBean.setTreatmentCode(
- rs.getString("TREATMENTCODE"));
- objTrtmServiceBean.setHospitalCode(
- rs.getLong("HOSPITALCODE"));
- objTrtmServiceBean.setTreatmentDescEng(
- rs.getString("TREATMENTDESCENG"));
- objTrtmServiceBean.setTreatmentDescArb(
- rs.getString("TREATMENTDESCARB"));
- objTrtmServiceBean.setMedCategory(
- rs.getString("MEDCATEGORY"));
- objTrtmServiceBean.setPrice(
- rs.getDouble("PRICE"));
- objTrtmServiceBean.setNeedsApproval(
- rs.getShort("NEEDSAPPROVAL"));
- objTrtmServiceBean.setIsNonDiscount(
- rs.getByte("ISNONDISCOUNT"));
- objTrtmServiceBean.setStatus(
- rs.getShort("STATUS"));
- objTrtmServiceBean.setDoctorComments(
- rs.getString("DOCTORCOMMENTS"));
- hospitalPendingTreatmentDetails.put(objTrtmServiceBean.getTreatmentCode().toString(),objTrtmServiceBean);
- hospitalPendingTreatmentDescArb.put(objTrtmServiceBean.getTreatmentDescArb().toLowerCase(),objTrtmServiceBean);
- hospitalPendingTreatmentDescEng.put(objTrtmServiceBean.getTreatmentDescEng().toLowerCase(),objTrtmServiceBean);
- }while(rs.next());
- result.put("hospitalPendingTreatmentDetails", hospitalPendingTreatmentDetails);
- result.put("hospitalPendingTreatmentDescArb", hospitalPendingTreatmentDescArb);
- result.put("hospitalPendingTreatmentDescEng", hospitalPendingTreatmentDescEng);
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getPendingTrtmServicesDetailsByHospital is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getPendingTrtmServicesDetailsByHospital is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getPendingTrtmServicesDetailsByHospital()",
- se,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- return result;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : validateTrtmServicesDetails
- * @INFORMATION : This method is to validate Treatment Services details
- * @PARAM : class java.util.Long,
- class java.util.ArrayList,
- class java.util.String,
- class java.util.Long,
- * @RETURN : class java.lang.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public Hashtable validateTrtmServicesDetails(Long hospitalCode,ArrayList hospitalTreatmentList,
- String mode,Long workflowId)
- throws GOSIException
- {
- Hashtable result=new Hashtable();
- ArrayList duplicateRecords = new ArrayList();
- ArrayList duplicateRecordsEnter = new ArrayList();
- ArrayList duplicateRecordsDescArb = new ArrayList();
- ArrayList duplicateRecordsDescEng = new ArrayList();
- ArrayList changedPriceRecords = new ArrayList();
- TrtmServiceBean objTrtmServiceBeanStock=null;
- TrtmServiceBean objTrtmServiceBeanPending=null;
- HashMap hospitalPendingTreatmentDetails = null;
- HashMap hospitalPendingTreatmentDescArb= null;
- HashMap hospitalPendingTreatmentDescEng= null;
- HashMap hospitalTreatmentDescArb = null;
- HashMap hospitalTreatmentDescEng= null;
- try
- {
- HashMap hospitalTreatmentListStock = getTrtmServicesListByHospital(hospitalCode);
- HashMap trtmServicesDescArbAndEngList = getTrtmServicesDescArbAndEngListByHospital(hospitalCode);
- if(trtmServicesDescArbAndEngList!=null){
- hospitalTreatmentDescArb = (HashMap)trtmServicesDescArbAndEngList.get("hospitalTreatmentDescArb");
- hospitalTreatmentDescEng = (HashMap) trtmServicesDescArbAndEngList.get("hospitalTreatmentDescEng");
- }
- HashMap pendingResult = getPendingTrtmServicesDetailsByHospital(hospitalCode,workflowId);
- if( pendingResult!=null && pendingResult.containsKey("hospitalPendingTreatmentDetails")){
- hospitalPendingTreatmentDetails =(HashMap) pendingResult.get("hospitalPendingTreatmentDetails");
- hospitalPendingTreatmentDescArb =(HashMap) pendingResult.get("hospitalPendingTreatmentDescArb");
- hospitalPendingTreatmentDescEng=(HashMap) pendingResult.get("hospitalPendingTreatmentDescEng");
- }
- if(hospitalTreatmentListStock != null)
- {
- for(int j=0;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmCodeUpperCase = objTrtmServiceBean.getTreatmentCode().toUpperCase();
- String trtmCodeLowerCase = objTrtmServiceBean.getTreatmentCode().toLowerCase();
- if(hospitalTreatmentListStock.containsKey(trtmCodeUpperCase)){
- objTrtmServiceBeanStock=(TrtmServiceBean)hospitalTreatmentListStock.get(trtmCodeUpperCase);
- }
- else if(hospitalTreatmentListStock.containsKey(trtmCodeLowerCase)) {
- objTrtmServiceBeanStock=(TrtmServiceBean)hospitalTreatmentListStock.get(trtmCodeLowerCase);
- }
- if(objTrtmServiceBeanStock!=null){
- if((objTrtmServiceBeanStock.getTreatmentCode().equals(
- trtmCodeUpperCase)) ||
- (objTrtmServiceBeanStock.getTreatmentCode().equals(
- trtmCodeLowerCase)))
- {
- if(!objTrtmServiceBeanStock.getTreatmentDescArb().toLowerCase().equals(
- objTrtmServiceBean.getTreatmentDescArb().toLowerCase()) ||
- !objTrtmServiceBeanStock.getTreatmentDescEng().toLowerCase().equals(
- objTrtmServiceBean.getTreatmentDescEng().toLowerCase()) ||
- objTrtmServiceBeanStock.getPrice().equals(
- objTrtmServiceBean.getPrice()))
- {
- boolean addRecord = true;
- for(int k=0;k<duplicateRecords.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecords.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanStock.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecords.add(objTrtmServiceBean);
- }
- }
- }
- if((objTrtmServiceBeanStock.getTreatmentCode().equals(
- trtmCodeUpperCase)) ||
- (objTrtmServiceBeanStock.getTreatmentCode().equals(
- trtmCodeLowerCase)))
- {
- if(!objTrtmServiceBeanStock.getPrice().equals(
- objTrtmServiceBean.getPrice()))
- {
- boolean addRecord = true;
- for(int k=0;k<changedPriceRecords.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) changedPriceRecords.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanStock.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- changedPriceRecords.add(objTrtmServiceBean);
- }
- }
- }
- }
- }
- }
- if(hospitalTreatmentDescArb != null)
- {
- for(int j=0;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmDescArbLowerCase = objTrtmServiceBean.getTreatmentDescArb().toLowerCase();
- String trtmDescArbUpperCase = objTrtmServiceBean.getTreatmentDescArb().toUpperCase();
- if(hospitalTreatmentDescArb.containsKey(trtmDescArbLowerCase)) {
- objTrtmServiceBeanStock=(TrtmServiceBean)hospitalTreatmentDescArb.get(trtmDescArbLowerCase);
- if(!objTrtmServiceBeanStock.getTreatmentCode().equals(objTrtmServiceBean.getTreatmentCode())
- || objTrtmServiceBeanStock.getPrice().equals(objTrtmServiceBean.getPrice())){
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescArb.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescArb.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanStock.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescArb.add(objTrtmServiceBean);
- }
- }
- }
- else if(hospitalTreatmentDescArb.containsKey(trtmDescArbUpperCase)) {
- objTrtmServiceBeanStock=(TrtmServiceBean)hospitalTreatmentDescArb.get(trtmDescArbUpperCase);
- if(!objTrtmServiceBeanStock.getTreatmentCode().equals(objTrtmServiceBean.getTreatmentCode())
- || objTrtmServiceBeanStock.getPrice().equals(objTrtmServiceBean.getPrice())){
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescArb.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescArb.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanStock.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescArb.add(objTrtmServiceBean);
- }
- }
- }
- }
- }
- if(hospitalTreatmentDescEng != null)
- {
- for(int j=0;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmDescEngLowerCase = objTrtmServiceBean.getTreatmentDescEng().toLowerCase();
- String trtmDescEngUpperCase = objTrtmServiceBean.getTreatmentDescEng().toUpperCase();
- if(hospitalTreatmentDescEng.containsKey(trtmDescEngLowerCase)) {
- objTrtmServiceBeanStock=(TrtmServiceBean)hospitalTreatmentDescEng.get(trtmDescEngLowerCase);
- if(!objTrtmServiceBeanStock.getTreatmentCode().equals(objTrtmServiceBean.getTreatmentCode())
- || objTrtmServiceBeanStock.getPrice().equals(objTrtmServiceBean.getPrice())){
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescEng.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescEng.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanStock.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescEng.add(objTrtmServiceBean);
- }
- }
- }
- else if(hospitalTreatmentDescEng.containsKey(trtmDescEngUpperCase)) {
- objTrtmServiceBeanStock=(TrtmServiceBean)hospitalTreatmentDescEng.get(trtmDescEngUpperCase);
- if(!objTrtmServiceBeanStock.getTreatmentCode().equals(objTrtmServiceBean.getTreatmentCode())
- || objTrtmServiceBeanStock.getPrice().equals(objTrtmServiceBean.getPrice())){
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescEng.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescEng.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanStock.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescEng.add(objTrtmServiceBean);
- }
- }
- }
- }
- }
- if(hospitalPendingTreatmentDetails != null)
- {
- for(int j=0;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmCodeUpperCase = objTrtmServiceBean.getTreatmentCode().toUpperCase();
- String trtmCodeLowerCase = objTrtmServiceBean.getTreatmentCode().toLowerCase();
- if(hospitalPendingTreatmentDetails.containsKey(trtmCodeUpperCase)){
- objTrtmServiceBeanPending=(TrtmServiceBean)hospitalPendingTreatmentDetails.get(trtmCodeUpperCase);
- }
- else if(hospitalPendingTreatmentDetails.containsKey(trtmCodeLowerCase)) {
- objTrtmServiceBeanPending=(TrtmServiceBean)hospitalPendingTreatmentDetails.get(trtmCodeLowerCase);
- }
- if(objTrtmServiceBeanPending!=null){
- if((objTrtmServiceBeanPending.getTreatmentCode().equals(
- trtmCodeUpperCase)) ||
- (objTrtmServiceBeanPending.getTreatmentCode().equals(
- trtmCodeLowerCase)))
- {
- boolean addRecord = true;
- for(int k=0;k<duplicateRecords.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecords.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanPending.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecords.add(objTrtmServiceBean);
- }
- }
- }
- }
- }
- if(hospitalPendingTreatmentDescArb != null)
- {
- for(int j=0;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmDescArbLowerCase = objTrtmServiceBean.getTreatmentDescArb().toLowerCase();
- String trtmDescArbUpperCase = objTrtmServiceBean.getTreatmentDescArb().toUpperCase();
- if(hospitalPendingTreatmentDescArb.containsKey(trtmDescArbLowerCase)) {
- objTrtmServiceBeanPending=(TrtmServiceBean)hospitalPendingTreatmentDescArb.get(trtmDescArbLowerCase);
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescArb.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescArb.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanPending.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescArb.add(objTrtmServiceBean);
- }
- }
- else if(hospitalPendingTreatmentDescArb.containsKey(trtmDescArbUpperCase)) {
- objTrtmServiceBeanPending=(TrtmServiceBean)hospitalPendingTreatmentDescArb.get(trtmDescArbUpperCase);
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescArb.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescArb.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanPending.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescArb.add(objTrtmServiceBean);
- }
- }
- }
- }
- if(hospitalPendingTreatmentDescEng != null)
- {
- for(int j=0;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmDescEngLowerCase = objTrtmServiceBean.getTreatmentDescEng().toLowerCase();
- String trtmDescEngUpperCase = objTrtmServiceBean.getTreatmentDescEng().toUpperCase();
- if(hospitalPendingTreatmentDescEng.containsKey(trtmDescEngLowerCase)) {
- objTrtmServiceBeanPending=(TrtmServiceBean)hospitalPendingTreatmentDescEng.get(trtmDescEngLowerCase);
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescEng.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescEng.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanPending.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescEng.add(objTrtmServiceBean);
- }
- }
- else if(hospitalPendingTreatmentDescEng.containsKey(trtmDescEngUpperCase)) {
- objTrtmServiceBeanPending=(TrtmServiceBean)hospitalPendingTreatmentDescEng.get(trtmDescEngLowerCase);
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescEng.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescEng.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanPending.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescEng.add(objTrtmServiceBean);
- }
- }
- }
- }
- if(hospitalTreatmentList != null)
- {
- for(int i=0;i<hospitalTreatmentList.size();i++)
- {
- TrtmServiceBean objTrtmServiceBeanDuplicated =
- (TrtmServiceBean) hospitalTreatmentList.get(i);
- for(int j=i+1;j<hospitalTreatmentList.size();j++)
- {
- TrtmServiceBean objTrtmServiceBean =
- (TrtmServiceBean) hospitalTreatmentList.get(j);
- String trtmCodeUpperCase = objTrtmServiceBean.getTreatmentCode().toUpperCase();
- String trtmCodeLowerCase = objTrtmServiceBean.getTreatmentCode().toLowerCase();
- String trtmDescArbUpperCase = objTrtmServiceBean.getTreatmentDescArb().toUpperCase();
- String trtmDescArbLowerCase = objTrtmServiceBean.getTreatmentDescArb().toLowerCase();
- String trtmDescEngUpperCase = objTrtmServiceBean.getTreatmentDescEng().toUpperCase();
- String trtmDescEngLowerCase = objTrtmServiceBean.getTreatmentDescEng().toLowerCase();
- if((objTrtmServiceBeanDuplicated.getTreatmentCode().equals(
- trtmCodeUpperCase)) ||
- (objTrtmServiceBeanDuplicated.getTreatmentCode().equals(
- trtmCodeLowerCase)))
- {
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsEnter.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsEnter.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanDuplicated.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsEnter.add(objTrtmServiceBean);
- }
- }
- else if((objTrtmServiceBeanDuplicated.getTreatmentDescEng().equals(
- trtmDescEngUpperCase)) ||
- (objTrtmServiceBeanDuplicated.getTreatmentDescEng().equals(
- trtmDescEngLowerCase)))
- {
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescEng.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescEng.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanDuplicated.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescEng.add(objTrtmServiceBean);
- }
- }
- else if((objTrtmServiceBeanDuplicated.getTreatmentDescArb().equals(
- trtmDescArbUpperCase)) ||
- (objTrtmServiceBeanDuplicated.getTreatmentDescArb().equals(
- trtmDescArbLowerCase)))
- {
- boolean addRecord = true;
- for(int k=0;k<duplicateRecordsDescArb.size();k++)
- {
- TrtmServiceBean objTrtmServiceBeanTemp =
- (TrtmServiceBean) duplicateRecordsDescArb.get(k);
- if(objTrtmServiceBeanTemp.getTreatmentCode().equals(
- objTrtmServiceBeanDuplicated.getTreatmentCode()))
- {
- addRecord = false;
- }
- }
- if(addRecord)
- {
- duplicateRecordsDescArb.add(objTrtmServiceBean);
- }
- }
- }
- }
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in validateTrtmServicesDetails is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in validateTrtmServicesDetails is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "validateTrtmServicesDetails()",
- se,"CMN_ERR_1000" );
- }
- result.put("duplicateRecords", duplicateRecords);
- result.put("duplicateRecordsEnter", duplicateRecordsEnter);
- result.put("duplicateRecordsDescArb", duplicateRecordsDescArb);
- result.put("duplicateRecordsDescEng", duplicateRecordsDescEng);
- result.put("changedPriceRecords", changedPriceRecords);
- return result;
- }
- /**
- * @METHOD NAME : getTrtmServicesList
- * @INFORMATION : This method is to get Approved Treatment Services
- * List of hospital in Arraylist
- * @PARAM : Long
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public ArrayList getTrtmServicesList(Long hospitalCode)
- throws GOSIException
- {
- ArrayList hospitalTreatmentList = null;
- TrtmServiceBean objTrtmServiceBean = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String masterQuery = null;
- masterQuery = new StringBuffer("Select ").
- append("TRTMSERVICELISTID, ").
- append("HOSPITALCODE, ").
- append("TREATMENTCODE,TREATMENTDESCENG, ").
- append("TREATMENTDESCARB, MEDCATEGORY, ").
- append("PRICE, NEEDSAPPROVAL, ISNONDISCOUNT , ").
- append("CREATEDBY, CREATIONTIMESTAMP, ").
- append("LASTMODIFIEDBY, LASTMODIFIEDTIMESTAMP, ").
- append("STATUS, DOCTORCOMMENTS from ").
- append(SITables.T_TRTMSERVICELIST).
- append(" where HOSPITALCODE = ? AND STATUS=? ").
- toString();
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(masterQuery);
- ps.setLong(1, hospitalCode);
- ps.setShort(2, OHConstants.TRTM_SRVC_LIST_DET_STATUS_APPROVED);
- rs = ps.executeQuery();
- hospitalTreatmentList = new ArrayList();
- while(rs.next()){
- objTrtmServiceBean = new TrtmServiceBean();
- objTrtmServiceBean.setTrtmServiceListId(
- rs.getLong("TRTMSERVICELISTID"));
- objTrtmServiceBean.setTreatmentCode(
- rs.getString("TREATMENTCODE"));
- objTrtmServiceBean.setHospitalCode(
- rs.getLong("HOSPITALCODE"));
- objTrtmServiceBean.setTreatmentDescEng(
- rs.getString("TREATMENTDESCENG"));
- objTrtmServiceBean.setTreatmentDescArb(
- rs.getString("TREATMENTDESCARB"));
- objTrtmServiceBean.setMedCategory(
- rs.getString("MEDCATEGORY"));
- objTrtmServiceBean.setPrice(
- rs.getDouble("PRICE"));
- objTrtmServiceBean.setNeedsApproval(
- rs.getShort("NEEDSAPPROVAL"));
- objTrtmServiceBean.setIsNonDiscount(
- rs.getByte("ISNONDISCOUNT"));
- objTrtmServiceBean.setCreatedBy(
- rs.getLong("CREATEDBY"));
- objTrtmServiceBean.setCreationTimestamp(
- rs.getTimestamp("CREATIONTIMESTAMP"));
- objTrtmServiceBean.setLastModifiedBy(
- rs.getLong("LASTMODIFIEDBY"));
- objTrtmServiceBean.setLastModifiedTimestamp(
- rs.getTimestamp("LASTMODIFIEDTIMESTAMP"));
- objTrtmServiceBean.setStatus(
- rs.getShort("STATUS"));
- objTrtmServiceBean.setDoctorComments(
- rs.getString("DOCTORCOMMENTS"));
- hospitalTreatmentList.add(objTrtmServiceBean);
- }
- }catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesList is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesList is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServicesList()",
- se,"CMN_ERR_1000" );
- }
- finally{
- GOSIUtilities.cleanUp(con, p, rs);
- return hospitalTreatmentList;
- }
- }
- /**
- * @METHOD NAME : getTrtmServicesListVersion
- * @INFORMATION : This method is to get Treatment Services List Version
- *
- * @PARAM : String
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String getTrtmServicesListVersion(Long hospitalCode)
- throws GOSIException
- {
- String hospitalTreatmentListVersion = "";
- TrtmServiceBean objTrtmServiceBean = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String query = "select max(CREATIONTIMESTAMP) as maxCreation , max (LASTMODIFIEDTIMESTAMP) as maxLastMod from T_TRTMSERVICELIST";
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(query);
- rs = ps.executeQuery();
- if(rs.next()){
- Timestamp maxCreat=rs.getTimestamp("MAXCREATION");
- Timestamp maxModify=rs.getTimestamp("MAXLASTMOD");
- if(maxCreat.after(maxModify)){
- hospitalTreatmentListVersion=(maxCreat.getYear()%100)+""+((maxCreat.getMonth()+1)<10?"0"+(maxCreat.getMonth()+1):(maxCreat.getMonth()+1))+
- ""+(maxCreat.getDate()<10?"0"+ maxCreat.getDate():maxCreat.getDate())+""+maxCreat.getHours()+""+maxCreat.getMinutes()+"";
- }
- else {
- hospitalTreatmentListVersion=(maxModify.getYear()%100)+""+((maxModify.getMonth()+1)<10?"0"+(maxModify.getMonth()+1):(maxModify.getMonth()+1))+
- ""+(maxModify.getDate()<10?"0"+ maxModify.getDate():maxModify.getDate())+""+maxModify.getHours()+""+maxModify.getMinutes()+"";
- }
- }
- }catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesList is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesList is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServicesListVersion()",
- se,"CMN_ERR_1000" );
- }
- finally{
- GOSIUtilities.cleanUp(con, p, rs);
- return hospitalTreatmentListVersion;
- }
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : getTrtmServicesDetails
- * @INFORMATION : This method is to get Treatment Services details
- * @PARAM : class java.util.ArrayList,
- class gosi.core.workflow.beans.WorkflowParamBean,
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public TrtmServiceHeaderBean getTrtmServicesDetails(long primaryKey)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- ArrayList hospitalTreatmentList = null;
- TrtmServiceHeaderBean objTrtmServiceHeaderBean = null;
- Long workflowID = new Long(primaryKey);
- try
- {
- TrtmServiceListHistoryEntityHome home = (TrtmServiceListHistoryEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRTM_SRVC_LIST_HISTORY_ENTITY_JNDI,
- TrtmServiceListHistoryEntityHome.class);
- TrtmServiceListHistoryEntity remote =
- (TrtmServiceListHistoryEntity)home.findByPrimaryKey(workflowID);
- objTrtmServiceHeaderBean = remote.getTrtmServiceHeaderBean();
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesDetails is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServicesDetails is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServicesDetails()",
- se,"CMN_ERR_1000" );
- }
- return objTrtmServiceHeaderBean;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : saveTrtmServicesDetails
- * @INFORMATION : This method is to save Treatment Services details
- * @PARAM : class TrtmServiceHeaderBean,
- class gosi.core.workflow.beans.WorkflowParamBean,
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String saveTrtmServicesDetails(TrtmServiceHeaderBean objTrtmServiceHeaderBean,
- WorkflowParamBean workflowParamBean)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- ArrayList hospitalTreatmentList = null;
- ArrayList trtmServiceDetailList = new ArrayList();
- try
- {
- if(objTrtmServiceHeaderBean != null )
- {
- hospitalTreatmentList = objTrtmServiceHeaderBean.getTrtmServiceDetailList();
- primarykeyHeader = GOSIUtilities.getPrimaryKey("T_TRTMSERVICELISTHEADER",
- objTrtmServiceHeaderBean.getCreatedBy());
- objTrtmServiceHeaderBean.setWorkflowId(primarykeyHeader);
- objTrtmServiceHeaderBean.setCreationTimestamp(new Timestamp(
- System.currentTimeMillis()));
- for(int i = 0;i < hospitalTreatmentList.size();i++)
- {
- TrtmServiceDetailBean objTrtmServiceDetailBean = new TrtmServiceDetailBean();
- objTrtmServiceDetailBean = (TrtmServiceDetailBean)hospitalTreatmentList.get(i);
- Long primarykeyDetail = GOSIUtilities.getPrimaryKey("T_TRTMSERVICELISTDETAIL",
- objTrtmServiceHeaderBean.getCreatedBy());
- objTrtmServiceDetailBean.setTrtmServiceDetailId(primarykeyDetail);
- objTrtmServiceDetailBean.setWorkflowId(objTrtmServiceHeaderBean.getWorkflowId());
- objTrtmServiceDetailBean.setStatus(OHConstants.TRTM_SRVC_LIST_DET_STATUS_ENTERED);
- objTrtmServiceDetailBean.setNeedsApproval(OHConstants.TRTM_NEEDSAPPROVAL_NO_NEED);
- objTrtmServiceDetailBean.setIsNonDiscount(OHConstants.TRTM_ISNONDISCOUNT_NO);
- trtmServiceDetailList.add(objTrtmServiceDetailBean);
- }
- objTrtmServiceHeaderBean.setTrtmServiceDetailList(trtmServiceDetailList);
- TrtmServiceListHistoryEntityHome home = (TrtmServiceListHistoryEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRTM_SRVC_LIST_HISTORY_ENTITY_JNDI,
- TrtmServiceListHistoryEntityHome.class);
- TrtmServiceListHistoryEntity remote =
- (TrtmServiceListHistoryEntity)home.create(objTrtmServiceHeaderBean);
- workflowParamBean.setPrimaryKeyOfTherecord(primarykeyHeader.toString());
- workflowParamBean.setKeyVal1(primarykeyHeader.toString());
- userName = GOSIUtilities.startWorkflow(workflowParamBean);
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in saveTrtmServicesDetails is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in saveTrtmServicesDetails is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "saveTrtmServicesDetails()",
- se,"CMN_ERR_1000" );
- }
- return userName;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : saveMaintainTrtmServicesDetails
- * @INFORMATION : This method is to save Treatment Services details
- * @PARAM : class TrtmServiceHeaderBean,
- class gosi.core.workflow.beans.WorkflowParamBean,
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String saveMaintainTrtmServicesDetails(TrtmServiceHeaderBean objTrtmServiceHeaderBean,
- WorkflowParamBean workflowParamBean)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- ArrayList hospitalTreatmentList = null;
- ArrayList trtmServiceDetailList = new ArrayList();
- try
- {
- if(objTrtmServiceHeaderBean != null )
- {
- hospitalTreatmentList = objTrtmServiceHeaderBean.getTrtmServiceDetailList();
- primarykeyHeader = GOSIUtilities.getPrimaryKey("T_TRTMSERVICELISTHEADER",
- objTrtmServiceHeaderBean.getCreatedBy());
- objTrtmServiceHeaderBean.setWorkflowId(primarykeyHeader);
- objTrtmServiceHeaderBean.setCreationTimestamp(new Timestamp(
- System.currentTimeMillis()));
- for(int i = 0;i < hospitalTreatmentList.size();i++)
- {
- TrtmServiceDetailBean objTrtmServiceDetailBean = new TrtmServiceDetailBean();
- objTrtmServiceDetailBean = (TrtmServiceDetailBean)hospitalTreatmentList.get(i);
- Long primarykeyDetail = GOSIUtilities.getPrimaryKey("T_TRTMSERVICELISTDETAIL",
- objTrtmServiceHeaderBean.getCreatedBy());
- objTrtmServiceDetailBean.setTrtmServiceDetailId(primarykeyDetail);
- objTrtmServiceDetailBean.setWorkflowId(objTrtmServiceHeaderBean.getWorkflowId());
- objTrtmServiceDetailBean.setStatus(OHConstants.TRTM_SRVC_LIST_DET_STATUS_ENTERED);
- objTrtmServiceDetailBean.setMode(AuditBean.NEW_MODE);
- trtmServiceDetailList.add(objTrtmServiceDetailBean);
- }
- objTrtmServiceHeaderBean.setTrtmServiceDetailList(trtmServiceDetailList);
- TrtmServiceListHistoryEntityHome home = (TrtmServiceListHistoryEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRTM_SRVC_LIST_HISTORY_ENTITY_JNDI,
- TrtmServiceListHistoryEntityHome.class);
- TrtmServiceListHistoryEntity remote =
- (TrtmServiceListHistoryEntity)home.create(objTrtmServiceHeaderBean);
- workflowParamBean.setPrimaryKeyOfTherecord(primarykeyHeader.toString());
- workflowParamBean.setKeyVal1(primarykeyHeader.toString());
- userName = GOSIUtilities.startWorkflow(workflowParamBean);
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in saveTrtmServicesDetails is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in saveTrtmServicesDetails is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "saveTrtmServicesDetails()",
- se,"CMN_ERR_1000" );
- }
- return userName;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : saveTrtmServicesDetailsReenter
- * @INFORMATION : This method is to save Treatment Services details
- * @PARAM : class TrtmServiceHeaderBean,
- class gosi.core.workflow.beans.WorkflowParamBean,
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String saveTrtmServicesDetailsReenter(TrtmServiceHeaderBean objTrtmServiceHeaderBean,
- WorkflowParamBean workflowParamBean)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- try
- {
- if(objTrtmServiceHeaderBean != null )
- {
- TrtmServiceListHistoryEntityHome home = getTrtmServiceListHistoryEntityHome();
- TrtmServiceListHistoryEntity remote =
- home.findByPrimaryKey(
- objTrtmServiceHeaderBean.getWorkflowId());
- remote.setTrtmServiceHeaderBean(objTrtmServiceHeaderBean);
- primarykeyHeader = objTrtmServiceHeaderBean.getWorkflowId();
- workflowParamBean.setPrimaryKeyOfTherecord(primarykeyHeader.toString());
- workflowParamBean.setKeyVal1(primarykeyHeader.toString());
- userName = GOSIUtilities.startWorkflow(workflowParamBean);
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in saveTrtmServicesDetailsReenter is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in saveTrtmServicesDetailsReenter is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "saveTrtmServicesDetailsReenter()",
- se,"CMN_ERR_1000" );
- }
- return userName;
- }
- /* This method is used to persist treatment service details in workflow */
- /**
- * @METHOD NAME : persistTrtmServicesDetailsInWorkflow
- * @INFORMATION : This method is to persist Treatment Services details in workflow
- * @PARAM : class TrtmServiceHeaderBean
- * @RETURN : void
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void persistTrtmServicesDetailsInWorkflow(TrtmServiceHeaderBean objTrtmServiceHeaderBean) throws GOSIException
- {
- try
- {
- TrtmServiceListHistoryEntity remote =
- getTrtmServiceListHistoryEntityHome().findByPrimaryKey(objTrtmServiceHeaderBean.getWorkflowId());
- remote.setTrtmServiceHeaderBean(objTrtmServiceHeaderBean);
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in persistTrtmServicesDetailsInWorkflow is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in persistTrtmServicesDetailsInWorkflow is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "persistTrtmServicesDetailsInWorkflow()",
- se,"CMN_ERR_1000" );
- }
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : approveTrtmServicesDetails
- * @INFORMATION : This method is to save Treatment Services details
- * @PARAM : class TrtmServiceHeaderBean,
- class java.util.ArrayList,
- class java.util.ArrayList,
- class gosi.core.workflow.beans.WorkflowParamBean,
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String approveTrtmServicesDetails(TrtmServiceHeaderBean objTrtmServiceHeaderBean,
- ArrayList hospitalTreatmentListSave, ArrayList hospitalTreatmentListReject,
- WorkflowParamBean workflowParamBean)
- throws GOSIException
- {
- String userName=null;
- Long primarykeyHeader =null;
- try
- {
- if(objTrtmServiceHeaderBean != null )
- {
- if(hospitalTreatmentListSave != null )
- {
- for(int i = 0;i < hospitalTreatmentListSave.size();i++)
- {
- TrtmServiceBean objTrtmServiceBean = new TrtmServiceBean();
- objTrtmServiceBean = (TrtmServiceBean)hospitalTreatmentListSave.get(i);
- if(objTrtmServiceBean.getMode() == AuditBean.NEW_MODE)
- {
- Long primarykey = GOSIUtilities.getPrimaryKey("T_TRTMSERVICELIST",
- objTrtmServiceHeaderBean.getCreatedBy());
- objTrtmServiceBean.setTrtmServiceListId(primarykey);
- TrtmServiceListEntityHome home = (TrtmServiceListEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRTM_SRVC_LIST_ENTITY_JNDI,
- TrtmServiceListEntityHome.class);
- TrtmServiceListEntity remote =
- (TrtmServiceListEntity)home.create(objTrtmServiceBean);
- }
- if(objTrtmServiceBean.getMode() == AuditBean.MODIFY_MODE)
- {
- objTrtmServiceBean.setLastModifiedBy( objTrtmServiceBean.getCreatedBy());
- objTrtmServiceBean.setLastModifiedTimestamp( objTrtmServiceBean.getCreationTimestamp());
- TrtmServiceListEntityHome home = (TrtmServiceListEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRTM_SRVC_LIST_ENTITY_JNDI,
- TrtmServiceListEntityHome.class);
- Long primarykey = getTrtmServiceListKey(objTrtmServiceBean.getHospitalCode(),
- objTrtmServiceBean.getTreatmentCode());
- TrtmServiceListEntity remote =
- (TrtmServiceListEntity)home.findByPrimaryKey(primarykey);
- remote.modifyTrtmServiceBean(objTrtmServiceBean);
- }
- }
- }
- TrtmServiceListHistoryEntityHome home = getTrtmServiceListHistoryEntityHome();
- TrtmServiceListHistoryEntity remote =
- home.findByPrimaryKey(
- objTrtmServiceHeaderBean.getWorkflowId());
- remote.setTrtmServiceHeaderBean(objTrtmServiceHeaderBean);
- if(workflowParamBean!=null)
- userName = GOSIUtilities.startWorkflow(workflowParamBean);
- }
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in approveTrtmServicesDetails is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in approveTrtmServicesDetails is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "approveTrtmServicesDetails()",
- se,"CMN_ERR_1000" );
- }
- return userName;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : readTrtmServicesFileXLS
- * @INFORMATION : This method is to read Treatment Services list XLS File
- * @PARAM : class java.util.String,
- : class java.util.String
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public HashMap readTrtmServicesFileXLS(HashMap hashMapInterfaceInput)
- throws GOSIException
- {
- short moduleId = 0;
- String filePath = "";
- String fileName = "";
- ArrayList inputList = null;
- HashMap interfaceOutput = new HashMap();
- String message="";
- if(hashMapInterfaceInput != null)
- {
- inputList = (ArrayList)hashMapInterfaceInput.
- get("interfaceInput");
- moduleId = ((Short)inputList.get(0)).shortValue();
- filePath = (String)inputList.get(1);
- fileName = (String)inputList.get(2);
- }
- GOSIDebug.debugMessages("file filePath: " + filePath);
- GOSIDebug.debugMessages("file fileName: " + fileName);
- String file = filePath +'/'+fileName;
- GOSIDebug.debugMessages("file link: " + file);
- ArrayList hospitalTreatmentList = new ArrayList();
- TrtmServiceBean objTrtmServiceBean = null;
- File inputWorkbook = new File(file);
- Workbook w;
- try {
- w = Workbook.getWorkbook(inputWorkbook);
- // Get the first sheet
- Sheet sheet = w.getSheet(0);
- // Loop over first 10 column and lines
- for (int i = 1; i < sheet.getRows(); i++) {
- objTrtmServiceBean = new TrtmServiceBean();
- for (int j = 0; j < sheet.getColumns(); j++) {
- Cell cell = sheet.getCell(j, i);
- if(j==0)
- {
- objTrtmServiceBean.setTreatmentCode(cell.getContents());
- }
- else if(j==1)
- {
- objTrtmServiceBean.setTreatmentDescArb(cell.getContents());
- }
- else if(j==2)
- {
- objTrtmServiceBean.setTreatmentDescEng(cell.getContents());
- }
- else if(j==3)
- {
- objTrtmServiceBean.setMedCategory(cell.getContents());
- }
- else if(j==4)
- {
- try{
- double servicePrice = Double.parseDouble(cell.getContents());
- objTrtmServiceBean.setPrice(servicePrice);
- }
- catch(Exception g){
- // message=GOSIErrorMessages.getErrorDesc("SOI_ERR_5804")+objTrtmServiceBean.getTreatmentCode();
- // interfaceOutput.put("message", message);
- }
- }
- }// end for2
- if(!objTrtmServiceBean.getTreatmentCode().equals(""))
- hospitalTreatmentList.add(objTrtmServiceBean);
- GOSIDebug.debugMessages(i+" TreatmentCode : "+objTrtmServiceBean.getTreatmentCode()
- +" TreatmentDescArb : "+objTrtmServiceBean.getTreatmentDescArb()
- +" TreatmentDescEng: "+objTrtmServiceBean.getTreatmentDescEng()
- +" Price: "+objTrtmServiceBean.getPrice());
- }// end for1
- }
- catch (BiffException e) {
- e.printStackTrace();
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in readTrtmServicesFileXLS is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "readTrtmServicesFileXLS()",
- se,"SOI_ERR_5804");
- }
- interfaceOutput.put("returnValue",hospitalTreatmentList);
- return interfaceOutput;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : readTrtmServicesFileXML
- * @INFORMATION : This method is to read Treatment Services list XML File
- * @PARAM : class java.util.String,
- : class java.util.String
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public HashMap readTrtmServicesFileXML(HashMap hashMapInterfaceInput)
- throws GOSIException
- {
- short moduleId = 0;
- String filePath = "";
- String fileName = "";
- ArrayList inputList = null;
- HashMap interfaceOutput = new HashMap();
- if(hashMapInterfaceInput != null)
- {
- inputList = (ArrayList)hashMapInterfaceInput.
- get("interfaceInput");
- moduleId = ((Short)inputList.get(0)).shortValue();
- filePath = (String)inputList.get(1);
- fileName = (String)inputList.get(2);
- }
- GOSIDebug.debugMessages("file filePath: " + filePath);
- GOSIDebug.debugMessages("file fileName: " + fileName);
- String file = filePath +'/'+fileName;
- GOSIDebug.debugMessages("file link: " + file);
- FileInputStream fis = null;
- BufferedInputStream bis = null;
- DataInputStream dis = null;
- String dataxml = "";
- ArrayList hospitalTreatmentList = new ArrayList();
- try {
- fis = new FileInputStream(file);
- // Here BufferedInputStream is added for fast reading.
- bis = new BufferedInputStream(fis);
- dis = new DataInputStream(bis);
- // dis.available() returns 0 if the file does not have more lines.
- while (dis.available() != 0) {
- // this statement reads the line from the file and print it to
- // the console.
- dataxml = dataxml + dis.readLine();
- }
- int numAttributes = 5;
- ArrayList parsedTreatmentServices = GOSIUtilities.xmlParser(dataxml,numAttributes);
- TrtmServiceBean objTrtmServiceBean = null;
- GOSIDebug.debugMessages("parsedTreatmentServices size : "+
- parsedTreatmentServices.size());
- for (int k=0;k<(parsedTreatmentServices.size()/numAttributes);k++ )
- {
- objTrtmServiceBean = new TrtmServiceBean();
- int locator = k * numAttributes;
- objTrtmServiceBean.setTreatmentCode(GOSIUtilities.
- changeCharacterSet(parsedTreatmentServices.get(0+locator).toString()));
- objTrtmServiceBean.setTreatmentDescArb(GOSIUtilities.
- changeCharacterSet(parsedTreatmentServices.get(1+locator).toString()));
- objTrtmServiceBean.setTreatmentDescEng(GOSIUtilities.
- changeCharacterSet(parsedTreatmentServices.get(2+locator).toString()));
- objTrtmServiceBean.setMedCategory(GOSIUtilities.
- changeCharacterSet(parsedTreatmentServices.get(3+locator).toString()));
- double servicePrice = Double.parseDouble(
- parsedTreatmentServices.get(4+locator).toString());
- objTrtmServiceBean.setPrice(servicePrice);
- hospitalTreatmentList.add(objTrtmServiceBean);
- }
- // dispose all the resources after using them.
- fis.close();
- bis.close();
- dis.close();
- interfaceOutput.put("returnValue",hospitalTreatmentList);
- return interfaceOutput;
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in readTrtmServicesFileXML is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in readTrtmServicesFileXML is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "readTrtmServicesFileXML()",
- se,"CMN_ERR_1000" );
- }
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : getTrtmServiceListKey
- * @INFORMATION : This method is to get Treatment Services list primaryKey
- * @PARAM : class java.util.Long,
- : class java.util.String
- * @RETURN : class java.lang.Long
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public Long getTrtmServiceListKey(Long hospitalCode, String treatmentCode)
- throws GOSIException
- {
- String userName=null;
- Long primarykey =null;
- Exception ex = null;
- con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- String masterQuery = null;
- String message = "";
- masterQuery = new StringBuffer("Select ").
- append("TRTMSERVICELISTID from ").
- append(SITables.T_TRTMSERVICELIST).
- append(" where HOSPITALCODE = ? AND TREATMENTCODE = ? ").
- toString();
- try
- {
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- // Load from the data base
- ps = con.prepareStatement(masterQuery);
- ps.setLong(1, hospitalCode);
- ps.setString(2, treatmentCode);
- rs = ps.executeQuery();
- if (!rs.next())
- {
- throw new GOSIException(GOSIConstants.SEVERITY_THREE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServiceListKey()",
- null,
- "CMN_ERR_1000"
- );
- }
- primarykey = rs.getLong("TRTMSERVICELISTID");
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in getTrtmServiceListKey is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in getTrtmServiceListKey is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTrtmServiceListKey()",
- se,"CMN_ERR_1000" );
- }
- return primarykey;
- }
- /**
- * @METHOD NAME : getTrtmServiceListHistoryEntityHome
- * @INFORMATION : This method returns the Home reference of
- OvertimeRequestEntity
- * @PARAM : Nil
- * @RETURN : interface gosi.database.socialinsurance.
- occupationalhazards.injury.entity.TrtmServiceListHistoryEntityHome
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private TrtmServiceListHistoryEntityHome getTrtmServiceListHistoryEntityHome()
- throws GOSIException
- {
- TrtmServiceListHistoryEntityHome trtmServiceListHistoryEntityHome =
- (TrtmServiceListHistoryEntityHome) ServiceLocator.getInstance().getRemoteHome
- (OHConstants.TRTM_SRVC_LIST_HISTORY_ENTITY_JNDI, TrtmServiceListHistoryEntityHome.class);
- return trtmServiceListHistoryEntityHome;
- }
- /* This method is used to save treatment service */
- /**
- * @METHOD NAME : saveTreatmentService
- * @INFORMATION : This method is to save Treatment Service
- * @PARAM : class java.util.ArrayList,
- class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails,
- class gosi.core.workflow.beans.WorkflowParamBean,
- class java.util.ArrayList,
- class gosi.core.dms.beans.DMSRequestHeaderBean
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String saveTreatmentService(ArrayList serviceList,
- InjuryPopDetails injuryBean,WorkflowParamBean workflowParamBean,
- ArrayList workflowIds,DMSRequestHeaderBean dmsHeaderBean)
- throws GOSIException
- {
- int listSize = 0;
- int serviceListSize = 0;
- int workFlowListSize = 0;
- long timeCounter = 0;
- String userName=null;
- try
- {
- ArrayList headerList = getHeaderList(serviceList,injuryBean);
- Long injuryId = ((TreatmentHeaderBean)headerList.get(0)).
- getInjuryId();
- GOSIDebug.debugMessages("Injury id______________"+injuryId);
- timeCounter = System.currentTimeMillis();
- if(headerList != null )
- {
- listSize = headerList.size();
- }
- for(int i = 0;i < listSize;i++)
- {
- TreatmentHeaderBean headerBean = new TreatmentHeaderBean();
- headerBean = (TreatmentHeaderBean)headerList.get(i);
- Long headerId =getHeader(headerBean);
- if(headerId == null)
- {
- headerBean.setTrmtServiceHdrId
- (GOSIUtilities.getPrimaryKey("T_TRMTSERVICESHDR",
- headerBean.getCreatedBy()));
- GOSIDebug.debugMessages("_________________::"+
- headerBean.getTrmtServiceHdrId());
- headerBean.setCreationTimestamp(new Timestamp(
- System.currentTimeMillis()));
- ((TreatmentHeaderBean)headerList.get(i)).
- setTrmtServiceHdrId
- (headerBean.getTrmtServiceHdrId());
- // Context cntx = GOSIUtilities.getInitialContext();
- // Object ref = cntx.lookup(OHConstants.
- // TRMT_SRVC_HDR_ENTITY_JNDI);
- // TreatmentServiceHeaderEntityHome home =
- // (TreatmentServiceHeaderEntityHome)PortableRemoteObject.
- // narrow(ref,TreatmentServiceHeaderEntityHome.class);
- TreatmentServiceHeaderEntityHome home = (TreatmentServiceHeaderEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_HDR_ENTITY_JNDI,
- TreatmentServiceHeaderEntityHome.class);
- TreatmentServiceHeaderEntity headerRemote =
- (TreatmentServiceHeaderEntity)home.create(headerBean);
- }
- else
- {
- GOSIDebug.debugMessages("header already present:"+
- headerId);
- ((TreatmentHeaderBean)headerList.get(i)).
- setTrmtServiceHdrId(headerId);
- }
- }
- if(serviceList != null)
- {
- serviceListSize = serviceList.size();
- }
- for(int i = 0;i < serviceListSize;i++)
- {
- TreatmentServiceBean serviceBean = (TreatmentServiceBean)
- serviceList.get(i);
- if(injuryBean.getFileNumber()!=null)
- {
- serviceBean.setFileNumber(injuryBean.getFileNumber());
- serviceBean.setPageNumber(injuryBean.getPageNumber());
- }
- for(int j = 0;j < listSize;j++)
- {
- TreatmentHeaderBean headerBean = (TreatmentHeaderBean)
- headerList.get(j);
- if((serviceBean.getHospitalCode().
- equals(headerBean.getHospitalCode()))
- &&(serviceBean.getPatientNumber().
- equals(headerBean.getPatientNumber())))
- {
- ((TreatmentServiceBean)serviceList.get(i)).
- setTrmtServiceHdrId
- (headerBean.getTrmtServiceHdrId());
- break;
- }
- GOSIDebug.debugMessages("HeaderId Not Found");
- }
- }
- GOSIDebug.debugMessages("\nTreatment header created\n");
- for(int i = 0;i < serviceListSize;i++)
- {
- TreatmentServiceBean trmtServiceBean =
- new TreatmentServiceBean();
- trmtServiceBean =
- (TreatmentServiceBean)serviceList.get(i);
- if((trmtServiceBean.getMedicineDescription() != null)
- &&(!(("").equals(trmtServiceBean.
- getMedicineDescription()))))
- {
- trmtServiceBean.setTrmtDesc
- (trmtServiceBean.getMedicineDescription()
- .replace('\'','\"'));
- trmtServiceBean.setTrmtAmt(
- trmtServiceBean.getMedicineAmount());
- trmtServiceBean.setTrmtCode
- (OHConstants.ICD_MEDICINE_CODE);
- }
- trmtServiceBean.setTrmtServiceDetId
- (GOSIUtilities.getPrimaryKey("T_TRMTSERVICESDET",
- trmtServiceBean.getCreatedBy()));
- GOSIDebug.debugMessages("DTL ID:"+
- trmtServiceBean.getTrmtServiceDetId());
- trmtServiceBean.setCreationTimestamp(
- new Timestamp(System.currentTimeMillis()));
- GOSIDebug.debugMessages("hdr id &&&&&&&" +
- trmtServiceBean.getTrmtServiceHdrId());
- // Context cntx=GOSIUtilities.getInitialContext();
- // Object ref=cntx.lookup
- // (OHConstants.TRMT_SRVC_DET_ENTITY_JNDI);
- // TreatmentServiceDetailEntityHome home =
- // (TreatmentServiceDetailEntityHome)PortableRemoteObject.
- // narrow(ref,TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntityHome home = (TreatmentServiceDetailEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_DET_ENTITY_JNDI,
- TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntity detailRemote =
- (TreatmentServiceDetailEntity)home.create(trmtServiceBean);
- }
- GOSIDebug.debugMessages("Treatment Detail created\n");
- if(workflowIds.size() > 0)
- {
- workFlowListSize = workflowIds.size();
- for(int i = 0;i < workFlowListSize;i++)
- {
- String primarykey = ((Long)workflowIds.get(i)).
- toString();
- workflowParamBean.setPrimaryKeyOfTherecord(primarykey);
- userName = GOSIUtilities.startWorkflow
- (workflowParamBean);
- }
- }
- if(dmsHeaderBean != null)
- {
- dmsHeaderBean.setSourceRecordId
- ("" + injuryBean.getInjuryID());
- dmsHeaderBean.
- setSourceTable(SITables.T_INJURY);
- dmsHeaderBean.setCreatedBy
- (new Long (workflowParamBean.getUserId()));
- dmsHeaderBean.setKeyList(DMSConstants.SI_NUMBER,
- ""+injuryBean.getSocialInsuranceNumber());
- dmsHeaderBean.setKeyList(DMSConstants.INJURY_NUMBER,
- ""+injuryBean.getInjuryNumber());
- dmsHeaderBean.setKeyList(OHConstants.DMS_SERVICE_TYPE,
- ""+OHConstants.SERVICE_TYPE_TRMT);
- DMSUtilities.startDMS(dmsHeaderBean);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "saveTreatmentService()",
- (System.currentTimeMillis() - timeCounter));
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in trmt srvc save is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in trmt srvc save is:"+se);
- ctx.setRollbackOnly();
- se.printStackTrace();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "saveTreatmentService()",
- se,"CMN_ERR_1000" );
- }
- return userName;
- }
- /* This method is used to get the header details */
- /**
- * @METHOD NAME : getHeaderList
- * @INFORMATION : This method is to get Header List
- * @PARAM : class java.util.ArrayList,
- class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION :
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private ArrayList getHeaderList(ArrayList serviceList,
- InjuryPopDetails injuryBean)
- {
- ArrayList headerList = new ArrayList();
- int listSize = 0;
- int serviceListSize = 0;
- long timeCounter = 0;
- timeCounter = System.currentTimeMillis();
- Long injuryId = injuryBean.getInjuryID();
- Long socInsNumber = injuryBean.getSocialInsuranceNumber();
- if(serviceList != null)
- {
- serviceListSize = serviceList.size();
- }
- for (int i = 0;i < serviceListSize;i++)
- {
- TreatmentServiceBean serviceBean =
- new TreatmentServiceBean();
- serviceBean = (TreatmentServiceBean)
- serviceList.get(i);
- boolean flag = true;
- if(headerList.size()!= 0)
- {
- listSize = headerList.size();
- for(int j = 0;j < listSize;j++)
- {
- TreatmentHeaderBean headerBean=new
- TreatmentHeaderBean();
- headerBean=(TreatmentHeaderBean)
- headerList.get(j);
- if((serviceBean.getHospitalCode().
- equals(headerBean.getHospitalCode()))&&
- (serviceBean.getPatientNumber().equals
- (headerBean.getPatientNumber())))
- {
- flag = false;
- break;
- }
- }
- }
- if(flag)
- {
- TreatmentHeaderBean trmtHeaderBean = new
- TreatmentHeaderBean();
- trmtHeaderBean.setInjuryId(injuryId);
- trmtHeaderBean.setSocInsNumber(socInsNumber);
- trmtHeaderBean.setHospitalCode
- (serviceBean.getHospitalCode());
- trmtHeaderBean.setPatientNumber
- (serviceBean.getPatientNumber());
- trmtHeaderBean.setCreatedBy
- (serviceBean.getCreatedBy());
- GOSIDebug.debugMessages("userId:"+
- serviceBean.getCreatedBy());
- headerList.add(trmtHeaderBean);
- }
- }
- for (int i = 0;i < headerList.size();i++)
- {
- TreatmentHeaderBean bTreatmentHeader=
- new TreatmentHeaderBean();
- bTreatmentHeader = (TreatmentHeaderBean)headerList.get(i);
- GOSIDebug.debugMessages("Patient numbers in h are-"+
- bTreatmentHeader.getPatientNumber());
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getHeaderList()",
- (System.currentTimeMillis() - timeCounter));
- return headerList;
- }
- /**
- * @METHOD NAME : MaintainTreatmentServiceSessionEJB
- * @INFORMATION : This method is the constructor$
- * @PARAM : class java.lang.String
- * @RETURN : class java.lang.Class
- * @EXCEPTION :
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public MaintainTreatmentServiceSessionEJB ()
- {
- }
- /**
- * @METHOD NAME : ejbCreate
- * @INFORMATION : This method is to ejb Create
- * @PARAM :
- * @RETURN : void
- * @EXCEPTION :
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void ejbCreate ()
- {
- }
- /**
- * @METHOD NAME : ejbRemove
- * @INFORMATION : This method is to ejb Remove
- * @PARAM :
- * @RETURN : void
- * @EXCEPTION :
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void ejbRemove ()
- {
- }
- /**
- * @METHOD NAME : ejbActivate
- * @INFORMATION : This method is to ejb Activate
- * @PARAM :
- * @RETURN : void
- * @EXCEPTION :
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void ejbActivate ()
- {
- }
- /**
- * @METHOD NAME : ejbPassivate
- * @INFORMATION : This method is to ejb Passivate
- * @PARAM :
- * @RETURN : void
- * @EXCEPTION :
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void ejbPassivate ()
- {
- }
- /**
- * @METHOD NAME : setSessionContext
- * @INFORMATION : This method is to set Session Context
- * @PARAM : interface javax.ejb.SessionContext
- * @RETURN : void
- * @EXCEPTION : class javax.ejb.EJBException,
- class java.rmi.RemoteException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void setSessionContext (SessionContext sessioncontext)
- throws EJBException,RemoteException
- {
- this.ctx = sessioncontext;
- }
- /* This method is used to get the hospital code */
- /**
- * @METHOD NAME : getHospital
- * @INFORMATION : This method is to get Hospital
- * @PARAM : long,
- class java.sql.Date
- * @RETURN : long
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public long getHospital(long injuryId,java.sql.Date treatmentDate)
- throws GOSIException
- {
- long timeCounter = 0;
- long hospitalCode = 0;
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT HOSPITALCODE FROM ");
- sbQuery.append( SITables.T_TREATMENT + " WHERE ");
- sbQuery.append(" STARTDATE <= ? ");
- sbQuery.append(" AND ENDDATE >= ? ");
- sbQuery.append(" AND INJURYID = ? ");
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- p.setDate(1,treatmentDate);
- p.setDate(2,treatmentDate);
- p.setLong(3,injuryId);
- rs = p.executeQuery();
- while(rs.next())
- {
- hospitalCode = rs.getLong(1);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getHospital()",se,"CMN_ERR_1000" );
- }
- finally
- {
- try
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getHospital()",
- se,"CMN_ERR_1000" );
- }
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getHospital()",
- (System.currentTimeMillis() - timeCounter));
- return hospitalCode ;
- }
- /* This method is used to get the header id */
- /**
- * @METHOD NAME : getHeader
- * @INFORMATION : This method is to get Header
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentHeaderBean
- * @RETURN : class java.lang.Long
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private Long getHeader(TreatmentHeaderBean
- oTreatmentHeader)throws GOSIException
- {
- Long headerId = null;
- long timeCounter = 0;
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT trmtservicehdrid FROM ");
- sbQuery.append( SITables.T_TRMTSERVICESHDR + " WHERE ");
- sbQuery.append(" hospitalcode = ? ");
- sbQuery.append(" AND patientnumber = ? AND injuryid = ? ");
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- con = GOSIUtilities.getConnection(GOSIConstants.
- OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,oTreatmentHeader.getHospitalCode().longValue());
- p.setString(2,oTreatmentHeader.getPatientNumber());
- p.setLong(3,oTreatmentHeader.getInjuryId().longValue());
- GOSIDebug.debugMessages("HospitalCode_"+
- oTreatmentHeader.getHospitalCode());
- GOSIDebug.debugMessages("PatientNumber_"+
- oTreatmentHeader.getPatientNumber());
- rs = p.executeQuery();
- while(rs.next())
- {
- if(rs.getLong("trmtServiceHdrId")!=0)
- {
- headerId= new Long(rs.getLong("trmtServiceHdrId"));
- }
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getHeader()",se,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getHeader()",
- (System.currentTimeMillis() - timeCounter));
- GOSIDebug.debugMessages("headerId value:"+headerId);
- return headerId;
- }
- /* This method is used to get the primary key details */
- /**
- * @METHOD NAME : getPrimaryKeyDetails
- * @INFORMATION : This method is to get Primary Key Details
- * @PARAM :
- * @RETURN : class java.lang.Long
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private Long getPrimaryKeyDetails()throws GOSIException
- {
- Long x = null;
- long timeCounter = 0;
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT MAX(TRMTSERVICEDETID) FROM " );
- sbQuery.append( SITables.T_TRMTSERVICESDET);
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- con = GOSIUtilities.getConnection(GOSIConstants.
- OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- rs = p.executeQuery();
- while(rs.next())
- {
- x = new Long(rs.getLong(1)+1);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getPrimaryKeyDetails()",
- se,"CMN_ERR_1000" );
- }
- finally
- {
- try
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getPrimaryKeyDetails()",
- se,"CMN_ERR_1000" );
- }
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getPrimaryKeyDetails()",
- (System.currentTimeMillis() - timeCounter));
- return x;
- }
- /* This method is used to get the primary key header */
- /**
- * @METHOD NAME : getPrimaryKeyHeader
- * @INFORMATION : This method is to get Primary Key Header
- * @PARAM :
- * @RETURN : long
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private long getPrimaryKeyHeader()throws GOSIException
- {
- long x = 0;
- long timeCounter = 0;
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT MAX(TRMTSERVICEHDRID) FROM ");
- sbQuery.append( SITables.T_TRMTSERVICESHDR);
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- rs = p.executeQuery();
- while(rs.next())
- {
- x = (rs.getLong(1)+1);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getPrimaryKeyHeader()",
- se,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getPrimaryKeyHeader()",
- (System.currentTimeMillis() - timeCounter));
- return x;
- }
- /* This method is used to get the header id */
- /**
- * @METHOD NAME : getHeaderId
- * @INFORMATION : This method is to get Header Id
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentServiceBean,
- class java.lang.Long
- * @RETURN : class java.lang.Long
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private Long getHeaderId(TreatmentServiceBean
- oTreatmentService,Long injuryId)throws GOSIException
- {
- Long x = null;
- long timeCounter = 0;
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT trmtservicehdrid FROM ");
- sbQuery.append( SITables.T_TRMTSERVICESHDR + " WHERE ");
- sbQuery.append(" hospitalcode = ? ");
- sbQuery.append(" AND patientnumber = ? AND injuryid = ? " );
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- GOSIDebug.debugMessages
- ("Injury id____"+injuryId+"___HospitalCode____"+
- oTreatmentService.getHospitalCode()+
- "___PatientNumber___"+oTreatmentService.getPatientNumber());
- con =GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,oTreatmentService.getHospitalCode().longValue());
- p.setString(2,oTreatmentService.getPatientNumber());
- p.setLong(3,injuryId.longValue());
- rs = p.executeQuery();
- GOSIDebug.debugMessages("b4 while in get header");
- while(rs.next())
- {
- x = new Long(rs.getLong(1));
- GOSIDebug.debugMessages("headerId___________________X"+x);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch (GOSIException ge)
- {
- GOSIDebug.debugMessages("error in getheaderId:"+ge);
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("error in getheaderId:"+se);
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),"getHeaderId()",
- se,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getHeaderId()",
- (System.currentTimeMillis() - timeCounter));
- return x;
- }
- /* This method is used to get the treatment periods*/
- /**
- * @METHOD NAME : getTreatmentPeriod
- * @INFORMATION : This method is to get Treatment Period
- * @PARAM : long
- * @RETURN : class [Ljava.sql.Date;
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public java.sql.Date[] getTreatmentPeriod(long injuryId)
- throws GOSIException
- {
- long timeCounter = 0;
- java.sql.Date [] aDate = new java.sql.Date [2];
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT TREATMENTSTDATE, ");
- sbQuery.append(" TREATMENTENDDATE FROM ");
- sbQuery.append( SITables.T_INJURY + " WHERE INJURYID = ? ");
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,injuryId);
- rs = p.executeQuery();
- while(rs.next())
- {
- aDate[0] = rs.getDate(1);
- aDate[1] = rs.getDate(2);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("Excep inside Search Treatment Type:"+e);
- }
- finally
- {
- try
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("Exception Inside pop injury " +e);
- }
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getTreatmentPeriod()",
- (System.currentTimeMillis() - timeCounter));
- return aDate;
- }
- /* This method is used to search the treatment details */
- /**
- * @METHOD NAME : searchTreatmentTypeList
- * @INFORMATION : This method is to search Treatment Type List
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentTypeBean
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public ArrayList searchTreatmentTypeList
- (TreatmentTypeBean searchBean) throws GOSIException
- {
- long hospitalCode = 0;
- long timeCounter = 0;
- String trmtCode = "";
- String trmtDate = "";
- ArrayList treatmentTypeList = new ArrayList();
- Connection con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- StringBuffer sbQuery = new StringBuffer();
- Timestamp trmtDateGreg = null;
- try
- {
- timeCounter = System.currentTimeMillis();
- String entFmt = OHUtilities.getDateFormat(searchBean.getTrmtDateStr());
- trmtDateGreg = OHUtilities.getGregDate(searchBean.getTrmtDateStr(),entFmt);
- searchBean.setTrmtDate(trmtDateGreg);
- GOSIDebug.debugMessages("trmt date str " +
- searchBean.getTrmtDateStr() );
- GOSIDebug.debugMessages("trmt format " +
- searchBean.getTrmtDateEntFmt());
- /*
- if(OHConstants.HIJRAH.equals
- (searchBean.getTrmtDateEntFmt()))
- {
- trmtDate=GOSIDateUtilities.convertToGregorian
- (searchBean.getTrmtDateStr());
- searchBean.setTrmtDate
- (GOSIUtilities.getTimestamp(trmtDate));
- }
- else
- {
- trmtDate =GOSIUtilities.getDateFullString(
- GOSIUtilities.getTimestamp(
- searchBean.getTrmtDateStr()));
- searchBean.setTrmtDate
- (GOSIUtilities.getTimestamp(trmtDate));
- }
- */
- String trmtDesc ="";
- GOSIDebug.debugMessages("b4 if");
- if(searchBean.getHospitalCode()!=null)
- {
- GOSIDebug.debugMessages("Hospital code:"+
- searchBean.getHospitalCode());
- hospitalCode = ((Long)searchBean.getHospitalCode()).
- longValue();
- }
- if( searchBean.getTrmtCode()!=null)
- {
- GOSIDebug.debugMessages("1");
- trmtCode=searchBean.getTrmtCode();
- GOSIDebug.debugMessages("2");
- }
- if(searchBean.getTrmtDesc()!=null)
- {
- GOSIDebug.debugMessages("3");
- trmtDesc=searchBean.getTrmtDesc();
- GOSIDebug.debugMessages("4");
- }
- GOSIDebug.debugMessages("b4 firstid");
- long firstID = searchBean.getFirstId();
- long lastID = searchBean.getLastId();
- GOSIDebug.debugMessages("in in SessionBean thes in Modify Mode");
- if(searchBean.getSearchFlag()== NavigationBean.MODIFY_MODE)
- {
- lastID = searchBean.getFirstId();
- firstID = searchBean.getLastId();
- GOSIDebug.debugMessages("in Sess the vals in Mod Mode");
- }
- String criteria = "";
- int queryCase = 0;
- String query = "";
- byte buttonClicked = searchBean.getButtonClicked();
- GOSIDebug.debugMessages("5");
- if (searchBean.getTrmtCode()!=null)
- {
- GOSIDebug.debugMessages("4");
- criteria = criteria+"1";
- }
- else
- {
- criteria = criteria+"0";
- }
- GOSIDebug.debugMessages("6");
- if (searchBean.getTrmtDesc()!=null)
- {
- GOSIDebug.debugMessages("6");
- criteria = criteria+"1";
- }
- else
- {
- criteria = criteria+"0";
- }
- GOSIDebug.debugMessages("the value of criteria is " +criteria);
- queryCase = Integer.parseInt(criteria);
- GOSIDebug.debugMessages("in Ses the value of in Mod Mode");
- con=GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- if (buttonClicked == NavigationBean.BUTTON_SEARCH)
- {
- GOSIDebug.debugMessages("the value of criteria is inside if" );
- switch (queryCase)
- {
- case 10:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append(" B.hospitaldeptcode");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setString(5,trmtCode+"%");
- ps.setString(6,trmtCode.toUpperCase()+"%");
- break;
- case 1:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" ((A.trmtdescarb LIKE ? ) " );
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append("B.hospitaldeptcode");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setString(2,trmtDate);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setString(4,trmtDate);
- ps.setString(5,trmtDesc+"%");
- ps.setString(6,trmtDesc.toUpperCase()+"%");
- break;
- case 11:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" AND ((A.trmtdescarb LIKE ? ) ");
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY " );
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append(" B.hospitaldeptcode ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setString(5,trmtCode+"%");
- ps.setString(6,trmtCode.toUpperCase()+"%");
- ps.setString(7,trmtDesc+"%");
- ps.setString(8,trmtDesc.toUpperCase()+"%");
- break;
- case 00:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append(" B.hospitaldeptcode");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setString(5,"%");
- ps.setString(6,"%");
- break;
- default :
- break;
- }
- }
- else if (buttonClicked == NavigationBean.BUTTON_NEXT)
- {
- GOSIDebug.debugMessages("the value of criteria is inside Forward" );
- switch (queryCase)
- {
- case 10:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid > ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append(" B.hospitaldeptcode");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,lastID);
- ps.setString(6,trmtCode+"%");
- ps.setString(7,trmtCode.toUpperCase()+"%");
- break;
- case 1:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid > ? AND " );
- sbQuery.append(" ((A.trmtdescarb LIKE ? ) " );
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append("B.hospitaldeptcode");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,lastID);
- ps.setString(6,trmtDesc+"%");
- ps.setString(7,trmtDesc.toUpperCase()+"%");
- break;
- case 11:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,?) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid > ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" AND ((A.trmtdescarb LIKE ? ) ");
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY " );
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append(" B.hospitaldeptcode ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,lastID);
- if(trmtCode!=null||!"".equals(trmtCode))
- {
- ps.setString(6,trmtCode+"%");
- ps.setString(7,trmtCode.toUpperCase()+"%");
- }
- else
- {
- ps.setString(6,"%");
- ps.setString(7,"%");
- }
- if(trmtDesc!=null||!"".equals(trmtDesc))
- {
- ps.setString(8,trmtDesc+"%");
- ps.setString(9,trmtDesc.toUpperCase()+"%");
- }
- else
- {
- ps.setString(8,"%");
- ps.setString(9,"%");
- }
- break;
- case 00:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,?) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid > ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" AND ((A.trmtdescarb LIKE ? ) ");
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY " );
- sbQuery.append(" A.hospitaldatarecid, ");
- sbQuery.append(" B.hospitaldeptcode ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,lastID);
- ps.setString(6,"%");
- ps.setString(7,"%");
- ps.setString(8,"%");
- ps.setString(9,"%");
- break;
- default :
- break;
- }
- }
- else if (buttonClicked == NavigationBean.BUTTON_PREVIOUS)
- {
- switch (queryCase)
- {
- case 10:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid < ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid DESC , ");
- sbQuery.append(" B.hospitaldeptcode ASC ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,firstID);
- ps.setString(6,trmtCode+"%");
- ps.setString(7,trmtCode.toUpperCase()+"%");
- break;
- case 1:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,?) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid < ? AND " );
- sbQuery.append(" ((A.trmtdescarb LIKE ? ) " );
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid DESC , ");
- sbQuery.append("B.hospitaldeptcode ASC ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,firstID);
- ps.setString(6,trmtDesc+"%");
- ps.setString(7,trmtDesc.toUpperCase()+"%");
- break;
- case 11:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid < ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" AND ((A.trmtdescarb LIKE ? ) ");
- sbQuery.append(" OR (A.trmtdescarb LIKE ? )) ");
- sbQuery.append(" ORDER BY " );
- sbQuery.append(" A.hospitaldatarecid DESC , ");
- sbQuery.append(" B.hospitaldeptcode ASC ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,firstID);
- ps.setString(6,trmtCode+"%");
- ps.setString(7,trmtCode.toUpperCase()+"%");
- ps.setString(8,trmtDesc+"%");
- ps.setString(9,trmtDesc.toUpperCase()+"%");
- break;
- case 00:
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.icd10trmtcode, ");
- sbQuery.append(" A.trmtdescarb, " );
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode, ");
- sbQuery.append(" B.hospitaldeptdescarb FROM ");
- sbQuery.append( SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE ");
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid ");
- sbQuery.append(" AND B.hospitalcontractid IN ");
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT );
- sbQuery.append(" WHERE hospitalcode = ? ) AND " );
- sbQuery.append(" A.effstdate <= ? " );
- sbQuery.append(" AND NVL(A.effenddate,? ) >= " );
- sbQuery.append(" ? AND ");
- sbQuery.append(" A.hospitaldatarecid < ? AND ");
- sbQuery.append(" ((A.icd10trmtcode LIKE ? ) " );
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid DESC , ");
- sbQuery.append(" B.hospitaldeptcode ASC ");
- ps = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setLong(5,firstID);
- ps.setString(6,"%");
- ps.setString(7,"%");
- break;
- default :
- break;
- }
- }
- GOSIDebug.debugMessages("Before prep stmt:\n" +sbQuery );
- sbQuery = sbQuery.delete(0,sbQuery.length());
- int count = 1;
- GOSIDebug.debugMessages("after prep stmt..."+ps);
- ps.setMaxRows(GOSIApplicationProperties.MAX_PAGE_SIZE+1);
- rs = ps.executeQuery();
- GOSIDebug.debugMessages("after prep statement");
- TreatmentTypeBean treatmentType = null;
- if(rs.next())
- {
- rs.previous();
- while(rs.next())
- {
- treatmentType = new TreatmentTypeBean();
- treatmentType.setTrmtCode(rs.getString("ICD10TRMTCODE"));
- treatmentType.setTrmtDescArb(rs.getString("TRMTDESCARB"));
- treatmentType.setTreatmentId(new Long
- (rs.getString("HOSPITALDATARECID")));
- treatmentType.setUnitPrice(new Double
- (rs.getString("UNITPRICE")));
- treatmentType.setDepartmentCode(new Long
- (rs.getString("HOSPITALDEPTCODE")));
- treatmentType.setDepartmentDesc(
- rs.getString("HOSPITALDEPTDESCARB"));
- treatmentTypeList.add(treatmentType);
- GOSIDebug.debugMessages("after adding to vector ");
- if(buttonClicked == NavigationBean.BUTTON_SEARCH
- || buttonClicked == NavigationBean.BUTTON_NEXT)
- {
- GOSIDebug.debugMessages("inside while in search");
- if (count == 1)
- {
- searchBean.setFirstId(
- treatmentType.getTreatmentId().longValue());
- }
- else if(count < GOSIApplicationProperties.
- MAX_PAGE_SIZE+1)
- {
- searchBean.setLastId(treatmentType.
- getTreatmentId().longValue());
- }
- GOSIDebug.debugMessages("inside while in search after");
- }
- if(buttonClicked == NavigationBean.BUTTON_PREVIOUS)
- {
- GOSIDebug.debugMessages("inside while in back");
- if (count == 1)
- {
- searchBean.setLastId(treatmentType.getTreatmentId()
- .longValue());
- }
- else if(count <
- GOSIApplicationProperties.MAX_PAGE_SIZE+1)
- {
- searchBean.setFirstId(treatmentType.
- getTreatmentId().longValue());
- }
- GOSIDebug.debugMessages("inside while in back after");
- }
- count = count+1;
- }
- treatmentTypeList.add(searchBean);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception se)
- {
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "searchTreatmentTypeList()",
- se,"CMN_ERR_1000");
- }
- finally
- {
- try
- {
- GOSIUtilities.cleanUp(con, ps, rs);
- }
- catch (Exception e)
- {
- GOSIDebug.debugMessages("exception in close :"+e);
- e.printStackTrace();
- }
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "searchTreatmentTypeList()",
- (System.currentTimeMillis() - timeCounter));
- return treatmentTypeList;
- }
- /* This method is used to get the treatment description
- for the treatment code entered by the user */
- /**
- * @METHOD NAME : searchTreatmentDescriptionList
- * @INFORMATION : This method is to search Treatment Description List
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentTypeBean
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public ArrayList searchTreatmentDescriptionList
- (TreatmentTypeBean searchBean) throws GOSIException
- {
- ArrayList treatmentTypeList = new ArrayList();
- Connection con = null;
- PreparedStatement ps = null;
- ResultSet rs = null;
- long hospitalCode = 0;
- long timeCounter = 0;
- String query = "";
- String trmtCode = "";
- String trmtDate = "";
- StringBuffer sbQuery = new StringBuffer();
- Timestamp trmtDateGreg = null;
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- String entFmt = OHUtilities.getDateFormat(searchBean.getTrmtDateStr());
- trmtDateGreg = OHUtilities.getGregDate(searchBean.getTrmtDateStr(),entFmt);
- searchBean.setTrmtDate(trmtDateGreg);
- /*
- if(OHConstants.HIJRAH.equals(searchBean.getTrmtDateEntFmt()))
- {
- trmtDate = GOSIDateUtilities.convertToGregorian
- (searchBean.getTrmtDateStr());
- searchBean.setTrmtDate
- (GOSIUtilities.getTimestamp(trmtDate));
- }
- else
- {
- trmtDate = GOSIUtilities.getDateFullString
- (GOSIUtilities.getTimestamp(
- searchBean.getTrmtDateStr()));
- searchBean.setTrmtDate
- (GOSIUtilities.getTimestamp(trmtDate));
- }
- */
- GOSIDebug.debugMessages("b4 if");
- if(searchBean.getHospitalCode()!= null)
- {
- GOSIDebug.debugMessages("Hospital code:" +
- searchBean.getHospitalCode());
- hospitalCode = ((Long)searchBean.getHospitalCode()).
- longValue();
- }
- if( searchBean.getTrmtCode()!= null) {
- GOSIDebug.debugMessages("1");
- trmtCode=searchBean.getTrmtCode();
- GOSIDebug.debugMessages("2");
- }
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- sbQuery.append(" SELECT A.icd10trmtcode,A.trmtdescarb, ");
- sbQuery.append(" A.hospitaldatarecid,A.unitprice, ");
- sbQuery.append(" B.hospitaldeptcode,B.hospitaldeptdescarb ");
- sbQuery.append(" FROM " + SITables.T_HOSPITALDEPTDATA + " A , ");
- sbQuery.append( SITables.T_HOSPITALDEPT + " B WHERE " );
- sbQuery.append(" A.hospitaldeptid = B.hospitaldeptid " );
- sbQuery.append(" AND B.hospitalcontractid IN " );
- sbQuery.append(" (SELECT hospcontrid FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT + " WHERE ");
- sbQuery.append(" hospitalcode = ? )AND ");
- sbQuery.append(" A.effstdate <= ? ");
- sbQuery.append(" AND NVL(A.effenddate,? ) >= ");
- sbQuery.append(" ? ");
- sbQuery.append(" AND ((A.icd10trmtcode LIKE ? ) ");
- sbQuery.append(" OR (A.icd10trmtcode LIKE ? )) ");
- sbQuery.append(" ORDER BY ");
- sbQuery.append(" A.hospitaldatarecid,B.hospitaldeptcode ");
- GOSIDebug.debugMessages("query" +sbQuery);
- ps = con.prepareStatement(sbQuery.toString());
- ps.setLong(1,hospitalCode);
- ps.setTimestamp(2,trmtDateGreg);
- ps.setTimestamp(3,new Timestamp
- (System.currentTimeMillis()));
- ps.setTimestamp(4,trmtDateGreg);
- ps.setString(5,trmtCode);
- ps.setString(6,trmtCode.toUpperCase());
- rs = ps.executeQuery();
- GOSIDebug.debugMessages("after prep statement");
- TreatmentTypeBean treatmentType = null;
- while(rs.next())
- {
- treatmentType = new TreatmentTypeBean();
- treatmentType.setTrmtCode(rs.getString("ICD10TRMTCODE"));
- treatmentType.setTrmtDescArb(rs.getString("TRMTDESCARB"));
- treatmentType.setTreatmentId(new Long
- (rs.getString("HOSPITALDATARECID")));
- treatmentType.setUnitPrice(new Double
- (rs.getString("UNITPRICE")));
- treatmentType.setDepartmentCode(new Long
- (rs.getString("HOSPITALDEPTCODE")));
- treatmentType.setDepartmentDesc(
- rs.getString("HOSPITALDEPTDESCARB"));
- treatmentTypeList.add(treatmentType);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception se)
- {
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "searchTreatmentDescriptionList()",
- se,"CMN_ERR_1000");
- }
- finally
- {
- try
- {
- GOSIUtilities.cleanUp(con, ps, rs);
- }
- catch (Exception e)
- {
- GOSIDebug.debugMessages("exception in close :"+e);
- e.printStackTrace();
- }
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "searchTreatmentDescriptionList()",
- (System.currentTimeMillis() - timeCounter));
- return treatmentTypeList;
- }
- /* This method is used to validate the treatment service */
- /*
- public TreatmentServiceBean isValidTrmtService
- (TreatmentServiceBean trmtSrvcBean,
- Long injuryId,String mode)throws GOSIException
- {
- StringBuffer sbQuery = new StringBuffer();
- String errorCode = "";
- String patientNumber = "";
- Timestamp trmtStartDate = null;
- Timestamp trmtEndDate = null;
- Long treatmentId = null;
- Long hospitalCode = null;
- Short trmtStatus = null;
- Short workflowStatus = null;
- long timeCounter = 0;
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT TREATMENTID,STARTDATE, ");
- sbQuery.append(" ENDDATE,PATIENTNUMBER,HOSPITALCODE, ");
- sbQuery.append(" TREATMENTSTATUS,WORKFLOWSTATUS FROM " );
- sbQuery.append( SITables.T_TREATMENT + " WHERE ");
- sbQuery.append(" TREATMENTSTATUS IN ( ?,? ) AND ");
- sbQuery.append(" STARTDATE <= ? " );
- sbQuery.append(" AND ENDDATE >= ? " );
- sbQuery.append(" AND INJURYID = ? ");
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- GOSIDebug.debugMessages("query" + sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setShort(1,
- OHConstants.TRMT_STS_ENTERED.shortValue());
- p.setShort(2,
- OHConstants.TRMT_STS_APPROVED.shortValue());
- p.setTimestamp(3,trmtSrvcBean.getTrmtDateGreg());
- p.setTimestamp(4,trmtSrvcBean.getTrmtDateGreg());
- p.setLong(5,injuryId.longValue());
- rs = p.executeQuery();
- while(rs.next())
- {
- treatmentId=new Long(rs.getLong("TREATMENTID"));
- trmtStartDate=rs.getTimestamp("STARTDATE");
- trmtEndDate =rs.getTimestamp("ENDDATE");
- patientNumber=rs.getString("PATIENTNUMBER");
- hospitalCode =new Long(rs.getLong("HOSPITALCODE"));
- trmtStatus =new Short(rs.getShort("TREATMENTSTATUS"));
- workflowStatus=new Short(rs.getShort("WORKFLOWSTATUS"));
- trmtSrvcBean.setTreatmentId(treatmentId);
- trmtSrvcBean.setTrmtStatus(trmtStatus);
- }
- if(trmtStartDate == null)
- {
- errorCode = "SOI_ERR_4012";
- }
- else if(!(hospitalCode.equals(trmtSrvcBean.
- getHospitalCode())))
- {
- errorCode="SOI_ERR_4018";
- }
- else if(!(patientNumber.equals(trmtSrvcBean.
- getPatientNumber())))
- {
- errorCode = "SOI_ERR_4138";
- }
- else if(workflowStatus.equals
- (OHConstants.WFS_TRMT_PENDING_DATA_ENTRY))
- {
- errorCode = "SOI_ERR_4139";
- }
- else if(!OHConstants.TRMT_STS_APPROVED.equals(trmtStatus))
- {
- errorCode = "SOI_ERR_4622";
- }
- else
- {
- errorCode = "";
- }
- Long newDataStartValue = new Long ("1000000000");
- if("SOI_ERR_4012".equals(errorCode)&&
- (injuryId.longValue()< newDataStartValue.longValue()))
- {
- GOSIUtilities.cleanUp(p,rs);
- String sqlQuery = " select INJURYID from "+
- SITables.T_INJURY +" where "+
- " INJURYID = ? and TREATMENTSTDATE <= ? "+
- " and TREATMENTENDDATE >= ? ";
- p = con.prepareStatement(sqlQuery);
- p.setLong(1,injuryId.longValue());
- p.setTimestamp(2,trmtSrvcBean.getTrmtDateGreg());
- p.setTimestamp(3,trmtSrvcBean.getTrmtDateGreg());
- rs = p.executeQuery();
- if(rs.next())
- {
- errorCode = "";
- trmtSrvcBean.setTrmtStatus(OHConstants.TRMT_STS_APPROVED);
- }else
- {
- errorCode = "SOI_ERR_4012";
- }
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- trmtSrvcBean.setErrorCode(errorCode);
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "isValidTrmtService()",
- (System.currentTimeMillis() - timeCounter));
- return trmtSrvcBean;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception se)
- {
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isValidTrmtService()",
- se,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con,p, rs);
- }
- }
- */
- /**
- * @METHOD NAME : isValidTrmtService
- * @INFORMATION : This method is to is Valid Trmt Service
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentServiceBean,
- class java.lang.Long,
- class java.lang.String
- * @RETURN : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentServiceBean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public TreatmentServiceBean isValidTrmtService
- (TreatmentServiceBean trmtSrvcBean,
- Long Id,String mode)throws GOSIException
- {
- StringBuffer sbQuery = new StringBuffer();
- String patientNumber = "";
- Long treatmentId = null;
- Long hospitalCode = null;
- Short trmtStatus = null;
- Short workflowStatus = null;
- long timeCounter = 0;
- Timestamp trmtStartDate = null;
- Timestamp trmtEndDate = null;
- Timestamp injuryDate = null;
- Timestamp assessmentDate = null;
- String sqlQuery = "";
- String errorCode = "";
- try
- {
- timeCounter = System.currentTimeMillis();
- Timestamp currentDate = new Timestamp(System.currentTimeMillis());
- if(mode.equalsIgnoreCase("injuryId"))
- {
- sqlQuery = "select NVL(DATECOMPLICATION,INJURYDATE) INJURYDATE,"
- +" TREATMENTSTDATE , TREATMENTENDDATE ,INJURYSTATUS "
- +" from "+SITables.T_INJURY +" where INJURYID = ? ";
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- Short injuryStatus = null;
- p = con.prepareStatement(sqlQuery);
- p.setLong(1,Id.longValue());
- rs = p.executeQuery();
- if(rs.next())
- {
- trmtStartDate = rs.getTimestamp("TREATMENTSTDATE");
- trmtEndDate = rs.getTimestamp("TREATMENTENDDATE");
- injuryStatus = new Short(rs.getShort("INJURYSTATUS"));
- injuryDate = rs.getTimestamp("INJURYDATE");
- }
- if(trmtSrvcBean.getTrmtDateGreg().after(currentDate))
- {
- errorCode = "SOI_ERR_5198";
- }else
- if (OHConstants.INJ_STS_CURED_WITHOUT_DISABILITY.equals(injuryStatus)||
- OHConstants.INJ_STS_CURED_WITH_DISABILITY.equals(injuryStatus)||
- OHConstants.INJ_STS_RESULTED_IN_DEATH.equals(injuryStatus))
- {
- if(trmtSrvcBean.getTrmtDateGreg().before(trmtStartDate)||
- trmtSrvcBean.getTrmtDateGreg().after(trmtEndDate))
- {
- errorCode = "SOI_ERR_4012";
- }
- }
- else if(OHConstants.INJ_STS_APPROVED.equals(injuryStatus)||
- OHConstants.INJ_STS_REJECTED.equals(injuryStatus)||
- OHConstants.INJ_STS_TRANSFERED_DISEASE.equals(injuryStatus))
- {
- if(trmtSrvcBean.getTrmtDateGreg().before(injuryDate))
- {
- errorCode = "SOI_ERR_4632";
- }
- }
- else
- {
- errorCode = "SOI_ERR_4012";
- }
- }
- else if (mode.equalsIgnoreCase("disabilityAssessmentID"))
- {
- sqlQuery = "SELECT disabilityassessmentid, socialinsurancenumber, assessmentdate FROM "+
- SITables.T_DISBASSMT +" WHERE SCHEDULEID = ? AND assessmentstatus <> ? ";
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sqlQuery);
- p.setLong (1, Id.longValue());
- p.setShort (2, OHConstants.ASSMT_CANCELLED);
- rs = p.executeQuery();
- if(rs.next())
- {
- assessmentDate = rs.getTimestamp("ASSESSMENTDATE");
- }
- if(trmtSrvcBean.getTrmtDateGreg().after(currentDate))
- {
- errorCode = "SOI_ERR_5198";
- }
- else if(trmtSrvcBean.getTrmtDateGreg().before(assessmentDate))
- {
- errorCode = "SOI_ERR_4386";
- }
- }
- trmtSrvcBean.setTrmtStatus(OHConstants.TRMT_STS_APPROVED);
- trmtSrvcBean.setErrorCode(errorCode);
- return trmtSrvcBean;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception se)
- {
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isValidTrmtService()",
- se,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con,p, rs);
- }
- }
- /**
- * @METHOD NAME : isAlreadyEnteredService
- * @INFORMATION : This method is to is Already Entered Service
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentServiceBean,
- class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails
- * @RETURN : boolean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public boolean isAlreadyEnteredService(TreatmentServiceBean trmtSrvcBean,
- InjuryPopDetails injuryDetails) throws GOSIException
- {
- GOSIDebug.debugMessages("--------isAlreadyEnteredService---------");
- PreparedStatement ps = null;
- ResultSet rs = null;
- boolean isAlreadyEntered = false;
- try
- {
- String sqlQuery = " select "+
- " b.TRMTSERVICEDETID, b.TRMTSERVICEHDRID from "+
- SITables.T_TRMTSERVICESHDR +" a , "+
- SITables.T_TRMTSERVICESDET +" b "+
- " where a.INJURYID = ? and a.HOSPITALCODE = ? and "+
- " a.TRMTSERVICEHDRID = b.TRMTSERVICEHDRID and b.TRMTAMT = ? "+
- " and b.TRMTDATE = ? and b.ICD10TRMTDIAGNOSISCODE =? "+
- " and b.TRMTSRVCSTATUS in (?,?)";
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- ps = con.prepareStatement(sqlQuery);
- ps.setLong(1,injuryDetails.getInjuryID().longValue());
- ps.setLong(2,trmtSrvcBean.getHospitalCode().longValue());
- ps.setDouble(3,trmtSrvcBean.getTrmtAmt().doubleValue());
- ps.setTimestamp(4,trmtSrvcBean.getTrmtDateGreg());
- ps.setString(5,trmtSrvcBean.getTrmtCode());
- ps.setShort(6,OHConstants.TRMT_SRVC_STS_APPROVED.shortValue());
- ps.setShort(7,OHConstants.TRMT_SRVC_STS_ENTERED.shortValue());
- rs = ps.executeQuery();
- while(rs.next())
- {
- isAlreadyEntered = true;
- }
- /*
- if(!isAlreadyEntered)
- {
- for(int i=0;i<serviceList.size();i++)
- {
- TreatmentServiceBean serviceBean =
- (TreatmentServiceBean)serviceList.get(i);
- if(serviceBean.getMode()==serviceBean.DELETE_MODE)
- {
- continue;
- }
- if(serviceBean.getTrmtDateGreg().equals(trmtSrvcBean.getTrmtDateGreg())&&
- serviceBean.getTrmtCode().equals(trmtSrvcBean.getTrmtCode())&&
- serviceBean.getTrmtAmt().equals(trmtSrvcBean.getTrmtAmt()))
- {
- isAlreadyEntered = true;
- break;
- }
- }
- }
- */
- return isAlreadyEntered;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isAlreadyEnteredService()",
- e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con,ps,rs);
- }
- }
- /**
- * @METHOD NAME : isAlreadyEnteredTreatmentService
- * @INFORMATION : This method is to is Already Entered Service
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TrtmServiceDetailBean
- * @RETURN : boolean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public boolean isAlreadyEnteredTreatmentService(TrtmServiceDetailBean trmtSrvcBean) throws GOSIException
- {
- GOSIDebug.debugMessages("--------isAlreadyEnteredTreatmentService---------");
- PreparedStatement ps = null;
- ResultSet rs = null;
- boolean isAlreadyEntered = false;
- try
- {
- String sqlQuery = " select TRTMSERVICEDETAILID from "+
- SITables.T_TRTMSERVICELISTDETAIL +
- " where HOSPITALCODE = ? and TREATMENTCODE = ? "+
- " and STATUS in (?,?,?,?,?)";
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- ps = con.prepareStatement(sqlQuery);
- ps.setLong(1,trmtSrvcBean.getHospitalCode().longValue());
- ps.setString(2,trmtSrvcBean.getTreatmentCode());
- ps.setShort(3,OHConstants.TRTM_SRVC_LIST_DET_STATUS_APPROVED1.shortValue());
- ps.setShort(4,OHConstants.TRTM_SRVC_LIST_DET_STATUS_APPROVED2.shortValue());
- ps.setShort(5,OHConstants.TRTM_SRVC_LIST_DET_STATUS_ENTERED.shortValue());
- ps.setShort(6,OHConstants.TRTM_SRVC_LIST_DET_STATUS_REJECTED.shortValue());
- ps.setShort(7,OHConstants.TRTM_SRVC_LIST_DET_STATUS_VERIFIED.shortValue());
- rs = ps.executeQuery();
- if(rs.next())
- {
- isAlreadyEntered = true;
- }
- return isAlreadyEntered;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isAlreadyEnteredTreatmentService()",
- e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con,ps,rs);
- }
- }
- /* This method is used to search and display the
- treatment details during modification */
- /**
- * @METHOD NAME : searchTreatmentServiceModify
- * @INFORMATION : This method is to search Treatment Service Modify
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentPeriodBean
- * @RETURN : class java.util.HashMap
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public HashMap searchTreatmentServiceModify
- (TreatmentPeriodBean srchTrmtPrdBean)
- throws GOSIException
- {
- long timeCounter = 0;
- long establishmentId = 0;
- StringBuffer sbQuery = new StringBuffer();
- String contributorName = "";
- ResultSet rsTreatment = null;
- try
- {
- timeCounter = System.currentTimeMillis();
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT A.injuryid,A.socinsnumber, ");
- sbQuery.append(" A.injurydateentfmt,A.injurydate,A.DATECOMPLICATION, ");
- sbQuery.append(" A.injurynumber,B.registrationnumber, ");
- sbQuery.append(" D.firstname || ' ' || ");
- sbQuery.append(" NVL(D.secondname,'')|| ' ' || " );
- sbQuery.append(" NVL(D.thirdname,'')||' ' || ");
- sbQuery.append(" NVL(D.surname,'') NAME, ");
- sbQuery.append(" D.nationalitycode, " );
- sbQuery.append(" B.fieldofficecode, A.contributorid, ");
- sbQuery.append(" A.establishmentid FROM ");
- sbQuery.append( SITables.T_INJURY + " A ,");
- sbQuery.append( SITables.T_ESTABLISHMENT + " B, ");
- sbQuery.append( SITables.T_CONTRIBUTOR + " C, ");
- sbQuery.append( SITables.T_PERSON + " D where ");
- sbQuery.append(" A.establishmentid = B.establishmentid ");
- sbQuery.append(" AND A.contributorid = C.contributorid " );
- sbQuery.append(" AND C.personid = D.personid AND " );
- sbQuery.append(" A.injurystatus NOT IN ( ? , ? ) " );
- sbQuery.append(" AND A.injuryid = ? " );
- GOSIDebug.debugMessages("sqlQuery" + sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setShort(1,OHConstants.INJ_STS_REJECTED.shortValue());
- p.setShort(2,OHConstants.INJ_STS_CANCELLED.shortValue());
- p.setLong(3,srchTrmtPrdBean.getInjuryId().longValue());
- rs = p.executeQuery();
- InjuryPopDetails injuryDetails = null;
- while(rs.next())
- {
- injuryDetails=new InjuryPopDetails();
- injuryDetails.setInjuryID( new Long
- (rs.getLong("INJURYID")));
- injuryDetails.setSocialInsuranceNumber
- ( new Long(rs.getLong("SOCINSNUMBER")));
- injuryDetails.setInjuryDate(rs.getTimestamp
- ("INJURYDATE"));
- injuryDetails.setInjuryDateEntFmt
- (rs.getString("INJURYDATEENTFMT"));
- if (OHConstants.HIJRAH.equals
- (injuryDetails.getInjuryDateEntFmt()))
- {
- injuryDetails.setInjuryDateStr
- (GOSIDateUtilities.convertToHijra(
- GOSIUtilities.getDateFullString(
- injuryDetails.getInjuryDate())));
- }
- else
- {
- injuryDetails.setInjuryDateStr
- (GOSIUtilities.getDateFullString(
- injuryDetails.getInjuryDate()));
- }
- if(rs.getObject("DATECOMPLICATION")!=null)
- {
- injuryDetails.setComplicationDate
- (rs.getTimestamp("DATECOMPLICATION"));
- injuryDetails.setComplicationDateStr(OHUtilities.getDateStr
- (injuryDetails.getComplicationDate(),injuryDetails.getInjuryDateEntFmt()));
- }
- injuryDetails.setInjuryNumber
- ( new Long(rs.getLong("INJURYNUMBER")));
- injuryDetails.setName(rs.getString("NAME"));
- injuryDetails.setNationality
- (new Short(rs.getShort("NATIONALITYCODE")));
- injuryDetails.setFieldOffice
- (new Short(rs.getShort("FIELDOFFICECODE")));
- injuryDetails.setContributorId(
- new Long(rs.getLong("CONTRIBUTORID")));
- establishmentId = rs.getLong
- ("ESTABLISHMENTID");
- GOSIDebug.debugMessages("est id ***" +
- establishmentId );
- ContributorBean oContributorBean =
- new ContributorBean();
- oContributorBean = ContributorUtilities.
- displayContributor(injuryDetails.getContributorId());
- GOSIDebug.debugMessages("PersonId::"+oContributorBean.
- getPersonId());
- PersonBean oPersonBean = new PersonBean();
- oPersonBean = PersonUtilities.
- displayPerson(oContributorBean.getPersonId());
- GOSIDebug.debugMessages("first name" +
- oPersonBean.getFirstName());
- GOSIDebug.debugMessages("first name" +
- oPersonBean.getFirstName());
- GOSIDebug.debugMessages("second name" +
- oPersonBean.getSecondName());
- GOSIDebug.debugMessages("third name" +
- oPersonBean.getThirdName());
- GOSIDebug.debugMessages("surname" +
- oPersonBean.getSurName());
- contributorName = oPersonBean.getFirstName();
- if(oPersonBean.getSecondName() != null)
- {
- contributorName += " " + oPersonBean.getSecondName();
- }
- if(oPersonBean.getThirdName() != null)
- {
- contributorName += " " + oPersonBean.getThirdName();
- }
- if(oPersonBean.getSurName() != null)
- {
- contributorName += " " + oPersonBean.getSurName();
- }
- GOSIDebug.debugMessages("contributor Name ^^^" +
- contributorName);
- injuryDetails.setName(contributorName);
- if(oPersonBean.getNationalityCode() != null)
- {
- injuryDetails.setNationality
- (oPersonBean.getNationalityCode());
- }
- GOSIDebug.debugMessages("nationality code ^^^" +
- oPersonBean.getNationalityCode());
- EstablishmentBean oEstablishmentBean =
- new EstablishmentBean();
- EstablishmentUtility oEstablishmentUtility =
- new EstablishmentUtility();
- oEstablishmentBean = oEstablishmentUtility.
- getEstablishmentDetails(establishmentId,
- false,true);
- GOSIDebug.debugMessages("reg no" + oEstablishmentBean.
- getRegistrationNumber());
- if(oEstablishmentBean != null)
- {
- injuryDetails.setRegistrationNumber
- (oEstablishmentBean.
- getRegistrationNumber());
- }
- }
- GOSIDebug.debugMessages("injury details fetched:");
- sbQuery = sbQuery.delete(0,sbQuery.length());
- String hospitalName = "";
- sbQuery.append(" SELECT a.TRMTSERVICEDETID, ");
- sbQuery.append(" a.TRMTSERVICEHDRID, ");
- sbQuery.append(" a.TRMTDATE, ");
- sbQuery.append(" a.TRMTDATEENTFMT,");
- sbQuery.append(" a.TRMTTIMEHR, ");
- sbQuery.append(" a.TRMTTIMEMIN,");
- sbQuery.append(" a.TRMTTIMEAMPM, ");
- sbQuery.append(" a.ICD10TRMTDIAGNOSISCODE, ");
- sbQuery.append(" a.TRMTDESC, ");
- sbQuery.append(" a.UNITS, ");
- sbQuery.append(" a.UNITPRICE, ");
- sbQuery.append(" a.TRMTAMT, ");
- sbQuery.append(" a.CREATEDBY, ");
- sbQuery.append(" a.CREATIONTIMESTAMP, ");
- sbQuery.append(" a.LASTMODIFIEDBY, ");
- sbQuery.append(" a.LASTMODIFIEDTIMESTAMP, ");
- sbQuery.append(" a.FILENUMBER , ");
- sbQuery.append(" a.PAGENUMBER , ");
- sbQuery.append(" a.REASONFORDEDUCTION , a.ISNONDISCOUNT");
- sbQuery.append(" b.HOSPITALNAMEARB FROM " );
- sbQuery.append( SITables.T_TRMTSERVICESDET + " a , ");
- sbQuery.append( SITables.T_HOSPITAL+ " b " );
- sbQuery.append(" WHERE a.TRMTSERVICEHDRID = " );
- sbQuery.append(" (SELECT TRMTSERVICEHDRID FROM ");
- sbQuery.append( SITables.T_TRMTSERVICESHDR);
- sbQuery.append(" WHERE PATIENTNUMBER = ? AND ");
- sbQuery.append(" HOSPITALCODE = ? AND ");
- sbQuery.append(" INJURYID = ? )" );
- sbQuery.append(" AND a.TRMTDATE >= ? ");
- sbQuery.append(" AND a.TRMTDATE <= ? " );
- sbQuery.append(" AND b.HOSPITALCODE = ? ");
- sbQuery.append(" AND a.WORKFLOWSTATUS = ? ");
- GOSIDebug.debugMessages("sqlQuery" + sbQuery);
- Long fileNumber = null;
- Long pageNumber = null;
- p = con.prepareStatement(sbQuery.toString());
- p.setString(1,srchTrmtPrdBean.getPatientNumber());
- p.setLong(2,srchTrmtPrdBean.getHospitalCode().longValue());
- p.setLong(3,srchTrmtPrdBean.getInjuryId().longValue());
- p.setTimestamp(4,srchTrmtPrdBean.getStartDateGreg());
- p.setTimestamp(5,srchTrmtPrdBean.getEndDateGreg());
- p.setLong(6,srchTrmtPrdBean.getHospitalCode().longValue());
- p.setShort(7,(OHConstants.WFS_SRVC_PENDING_DATA_ENTRY).
- shortValue());
- rs = p.executeQuery();
- ArrayList serviceList = new ArrayList ();
- while(rs.next())
- {
- TreatmentServiceBean srvcBean= new TreatmentServiceBean();
- srvcBean.setTrmtServiceDetId(new Long
- (rs.getLong("TRMTSERVICEDETID")));
- srvcBean.setTrmtServiceHdrId(new Long
- (rs.getLong("TRMTSERVICEHDRID")));
- //GOSIDebug.debugMessages("hdr id:");
- srvcBean.setTrmtDateGreg(rs.getTimestamp("TRMTDATE"));
- //GOSIDebug.debugMessages("trmtdate:");
- srvcBean.setTrmtDateEntFmt(rs.getString("TRMTDATEENTFMT"));
- if(OHConstants.HIJRAH.equals
- (srvcBean.getTrmtDateEntFmt()))
- {
- srvcBean.setTrmtDateStr
- (GOSIDateUtilities.convertToHijra
- (GOSIUtilities.getDateFullString
- (srvcBean.getTrmtDateGreg())));
- }
- else
- {
- srvcBean.setTrmtDateStr
- (GOSIUtilities.getDateFullString
- (srvcBean.getTrmtDateGreg()));
- }
- srvcBean.setTrmtTimeHr(rs.getString("TRMTTIMEHR"));
- srvcBean.setTrmtTimeMin(rs.getString("TRMTTIMEMIN"));
- if(rs.getObject("TRMTTIMEAMPM")!= null)
- {
- srvcBean.setTrmtTimeAmPm(new Short
- (rs.getShort("TRMTTIMEAMPM")));
- }
- srvcBean.setTrmtCode(rs.getString
- ("ICD10TRMTDIAGNOSISCODE"));
- srvcBean.setTrmtDesc(rs.getString("TRMTDESC"));
- if(rs.getObject("UNITS")!= null)
- {
- srvcBean.setUnits(rs.getFloat("UNITS"));
- }
- if(rs.getObject("UNITPRICE")!= null)
- {
- srvcBean.setUnitPrice(new Double
- (rs.getDouble("UNITPRICE")));
- }
- if(rs.getString("REASONFORDEDUCTION")!=null)
- {
- srvcBean.setReasonForDeduction(rs.getString("REASONFORDEDUCTION"));
- }
- if(rs.getString("ISNONDISCOUNT")!=null)
- {
- srvcBean.setIsNonDiscount(rs.getByte("ISNONDISCOUNT"));
- }
- srvcBean.setTrmtAmt(new Double(rs.getDouble("TRMTAMT")));
- srvcBean.setCreatedBy(new Long(rs.getLong("CREATEDBY")));
- srvcBean.setCreationTimestamp
- (rs.getTimestamp("CREATIONTIMESTAMP"));
- if(rs.getObject("LASTMODIFIEDBY")!= null)
- {
- srvcBean.setLastModifiedBy(new Long
- (rs.getLong("LASTMODIFIEDBY")));
- srvcBean.setLastModifiedTimestamp(
- rs.getTimestamp("LASTMODIFIEDTIMESTAMP"));
- }
- if(rs.getObject("FILENUMBER")!=null)
- {
- srvcBean.setFileNumber(new Long(rs.getLong("FILENUMBER")));
- fileNumber =srvcBean.getFileNumber();
- }
- if(rs.getObject("PAGENUMBER")!=null)
- {
- srvcBean.setPageNumber(new Long(rs.getLong("PAGENUMBER")));
- pageNumber =srvcBean.getPageNumber();
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- if(srvcBean.getTrmtCode().equalsIgnoreCase
- (OHConstants.ICD_MEDICINE_CODE))
- {
- srvcBean.setTrmt(srvcBean.getTrmtDesc());
- srvcBean.setMedicineDescription
- (srvcBean.getTrmtDesc());
- srvcBean.setMedicineAmount(srvcBean.getTrmtAmt());
- srvcBean.setTrmtAmt(null);
- srvcBean.setTrmtCode("");
- srvcBean.setTrmtDesc("");
- }else if(srvcBean.getTrmtCode().equalsIgnoreCase
- (OHConstants.TRMT_SRVC_BULK_ENTRY))
- {
- srvcBean.setTrmt
- (GOSIErrorMessages.getErrorDesc("SOI_ERR_5309"));
- }
- else
- {
- /* This query is used to get the
- treatment description for the
- treatment code passed */
- sbQuery.append(" SELECT icd10treatment FROM ");
- sbQuery.append( SITables.T_ICDTREATMENTDATA);
- sbQuery.append(" WHERE icd10treatmentcode LIKE ? " );
- sbQuery.append(" OR icd10treatmentcode LIKE ? " );
- GOSIDebug.debugMessages("sqlQuery" + sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setString(1,srvcBean.getTrmtCode());
- p.setString(2,srvcBean.getTrmtCode().toUpperCase());
- rsTreatment = p.executeQuery();
- if(rsTreatment.next())
- {
- srvcBean.setTrmt(rsTreatment.
- getString(1));
- }
- GOSIUtilities.cleanUp(rsTreatment);
- }
- srvcBean.setHospitalDesc
- (rs.getString("HOSPITALNAMEARB"));
- hospitalName = srvcBean.getHospitalDesc();
- srvcBean.setHospitalCode
- (srchTrmtPrdBean.getHospitalCode());
- srvcBean.setPatientNumber
- (srchTrmtPrdBean.getPatientNumber());
- srvcBean.setMode(AuditBean.OLD_MODE);
- serviceList.add(srvcBean);
- }
- injuryDetails.setHospitalNameArb
- (srchTrmtPrdBean.getHospitalNameArb());
- injuryDetails.setHospitalCode
- (srchTrmtPrdBean.getHospitalCode());
- injuryDetails.setPatientNumber
- (srchTrmtPrdBean.getPatientNumber());
- injuryDetails.setFileNumber(fileNumber);
- injuryDetails.setPageNumber(pageNumber);
- HashMap details = new HashMap();
- details.put("injuryDetails",injuryDetails);
- details.put("serviceList",serviceList);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "searchTreatmentServiceModify()",
- (System.currentTimeMillis() - timeCounter));
- return details;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("servlet : The exception is " +e);
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,this.getClass().toString(),
- "searchTreatmentServiceModify()",e,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- }
- /* This method is used to search and display the
- treatment details during verification/approval */
- /**
- * @METHOD NAME : searchTreatmentServiceInbox
- * @INFORMATION : This method is to search Treatment Service Inbox
- * @PARAM : class java.lang.Long
- * @RETURN : class java.util.HashMap
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public HashMap searchTreatmentServiceInbox
- (Long primaryKey)throws GOSIException
- {
- long timeCounter = 0;
- long establishmentId = 0;
- String hospitalDesc = "";
- String patientNumber = "";
- String contributorName = "";
- Long hospitalCode = null;
- Long injuryId = null;
- Long disabilityAssessmentId = null;
- Long invoiceDetailsId = null;
- Short appealStatus=null;
- ResultSet rsTreatment = null;
- StringBuffer sbQuery = new StringBuffer();
- Long fileNumber = null;
- Long pageNumber = null;
- HashMap details = new HashMap();
- ResultSet rs2 = null;
- try
- {
- timeCounter = System.currentTimeMillis();
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT a.TRMTSERVICEDETID, " );
- sbQuery.append(" a.TRMTSERVICEHDRID,a.TRMTDATE, " );
- sbQuery.append(" a.TRMTDATEENTFMT,a.TRMTTIMEHR, ");
- sbQuery.append(" a.TRMTTIMEMIN,a.TRMTTIMEAMPM," );
- sbQuery.append(" a.ICD10TRMTDIAGNOSISCODE," );
- sbQuery.append(" a.TRMTDESC,a.UNITS,a.UNITPRICE,");
- sbQuery.append(" a.TRMTAMT,a.CREATEDBY,");
- sbQuery.append(" a.CREATIONTIMESTAMP,");
- sbQuery.append(" a.LASTMODIFIEDBY,");
- sbQuery.append(" a.LASTMODIFIEDTIMESTAMP,");
- sbQuery.append(" a.TRMTSRVCSTATUS,");
- sbQuery.append(" a.WORKFLOWSTATUS," );
- sbQuery.append(" a.TRMTSRVCWRKFLOID,");
- sbQuery.append(" a.APPROVEDUNITS,");
- sbQuery.append(" a.REJECTIONCODE,");
- sbQuery.append(" a.FILENUMBER,");
- sbQuery.append(" a.PAGENUMBER,");
- sbQuery.append(" a.routingflag,");
- sbQuery.append(" a.REASONFORDEDUCTION,");
- sbQuery.append(" a.SFDACODE,");
- sbQuery.append(" a.UOM, a.ISPERIODDEDUCTED , ");
- sbQuery.append(" a.DISCOUNTPERCENTAGE,");
- sbQuery.append(" a.APPROVEDDISCPERCENTAGE,");
- sbQuery.append(" a.IOFLAG,");
- sbQuery.append(" a.REASONOFAPPEALDEDCUTION, a.APPEALDEDCUTIONSTATUS, a.APPEALDEDCUTIONDATE,a.APPEALDEDCUTIONWFID ,");
- sbQuery.append(" a.REJECTEDTRMTAMT, a.ISNONDISCOUNT , ");
- sbQuery.append(" c.invoicedetailsid,c.APPEALSTATUS,");
- sbQuery.append(" c.HOSPITALCODE ,NVL(c.INJURYID,d.INJURYID) AS INJURYID,");
- sbQuery.append(" d.SCHEDULEID , c.PATIENTNUMBER,b.HOSPITALNAMEARB FROM ");
- sbQuery.append( SITables.T_TRMTSERVICESDET + " a , ");
- sbQuery.append( SITables.T_HOSPITAL + " b," );
- sbQuery.append( SITables.T_TRMTSERVICESHDR + " c LEFT JOIN " );
- sbQuery.append( SITables.T_MBAPPOINTMENT + " d ON c.DISASSMTID = d.SCHEDULEID WHERE " );
- sbQuery.append(" a.TRMTSERVICEHDRID = c.TRMTSERVICEHDRID ");
- sbQuery.append(" and c.HOSPITALCODE = b.HOSPITALCODE ");
- sbQuery.append(" AND ( a.TRMTSRVCWRKFLOID = ? OR (a.APPEALDEDCUTIONWFID=? and APPEALDEDCUTIONSTATUS <> ?)) ");
- sbQuery.append(" ORDER BY NVL(A.SFDACODE,A.ICD10TRMTDIAGNOSISCODE) , A.TRMTDATE ASC ");
- GOSIDebug.debugMessages("SqlQuery:\n"+sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,primaryKey.longValue());
- p.setLong(2,primaryKey.longValue());
- p.setShort(3,OHConstants.TRMT_SRVC_APPEAL_STS_CANCELLED);
- rs = p.executeQuery();
- ArrayList serviceList = new ArrayList ();
- while(rs.next())
- {
- TreatmentServiceBean srvcBean = new TreatmentServiceBean();
- srvcBean.setTrmtServiceDetId(new Long
- (rs.getLong("TRMTSERVICEDETID")));
- srvcBean.setTrmtServiceHdrId(new Long
- (rs.getLong("TRMTSERVICEHDRID")));
- //GOSIDebug.debugMessages("hdr id:");
- srvcBean.setTrmtDateGreg(rs.getTimestamp("TRMTDATE"));
- //GOSIDebug.debugMessages("trmtdate:");
- srvcBean.setTrmtDateEntFmt(rs.getString("TRMTDATEENTFMT"));
- if(OHConstants.HIJRAH.equals
- (srvcBean.getTrmtDateEntFmt()))
- {
- srvcBean.setTrmtDateStr
- (GOSIDateUtilities.convertToHijra
- (GOSIUtilities.getDateFullString
- (srvcBean.getTrmtDateGreg())));
- }
- else
- {
- srvcBean.setTrmtDateStr
- (GOSIUtilities.getDateFullString
- (srvcBean.getTrmtDateGreg()));
- }
- srvcBean.setTrmtTimeHr(rs.getString("TRMTTIMEHR"));
- srvcBean.setTrmtTimeMin(rs.getString("TRMTTIMEMIN"));
- if(rs.getObject("TRMTTIMEAMPM")!= null)
- {
- srvcBean.setTrmtTimeAmPm(new Short
- (rs.getShort("TRMTTIMEAMPM")));
- }
- srvcBean.setTrmtCode(rs.getString
- ("ICD10TRMTDIAGNOSISCODE"));
- srvcBean.setTrmtDesc(rs.getString("TRMTDESC"));
- if(rs.getObject("UNITS")!= null)
- {
- srvcBean.setUnits(rs.getFloat("UNITS"));
- }
- if(rs.getObject("UNITPRICE")!= null)
- {
- srvcBean.setUnitPrice(new Double
- (rs.getDouble("UNITPRICE")));
- }
- if(rs.getObject("SFDACODE")!= null)
- {
- srvcBean.setSFDACode(rs.getString("SFDACODE"));
- }
- if(rs.getObject("UOM")!= null)
- {
- srvcBean.setUOM(rs.getString("UOM"));
- }
- if(rs.getObject("DISCOUNTPERCENTAGE")!= null)
- {
- srvcBean.setDiscountPercentage(new Double
- (rs.getDouble("DISCOUNTPERCENTAGE")));
- }
- if(rs.getObject("APPROVEDDISCPERCENTAGE")!= null)
- {
- srvcBean.setApprovedDiscPercentage(new Double
- (rs.getDouble("APPROVEDDISCPERCENTAGE")));
- }
- if(rs.getObject("IOFLAG")!= null)
- {
- srvcBean.setIOFlag(rs.getString("IOFLAG").charAt(0));
- }
- if(rs.getObject("REJECTEDTRMTAMT")!= null)
- {
- srvcBean.setRejectedTrmtAmt(rs.getDouble("REJECTEDTRMTAMT"));
- }
- else
- srvcBean.setRejectedTrmtAmt(new Double("0"));
- if(rs.getObject("ISPERIODDEDUCTED")!= null)
- {
- srvcBean.setIsPeriodDeducted(rs.getByte("ISPERIODDEDUCTED"));
- }
- if(rs.getObject("SCHEDULEID")!= null)
- {
- srvcBean.setDisbAssmtId(rs.getLong("SCHEDULEID"));
- }
- srvcBean.setTrmtAmt(new Double(rs.getDouble("TRMTAMT")));
- srvcBean.setCreatedBy(new Long(rs.getLong("CREATEDBY")));
- srvcBean.setCreationTimestamp
- (rs.getTimestamp("CREATIONTIMESTAMP"));
- if(rs.getObject("LASTMODIFIEDBY")!= null)
- {
- srvcBean.setLastModifiedBy(new Long
- (rs.getLong("LASTMODIFIEDBY")));
- srvcBean.setLastModifiedTimestamp(
- rs.getTimestamp("LASTMODIFIEDTIMESTAMP"));
- }
- srvcBean.setTrmtSrvcStatus
- (new Short(rs.getShort("TRMTSRVCSTATUS")));
- srvcBean.setWorkflowStatus
- (new Short(rs.getShort("WORKFLOWSTATUS")));
- srvcBean.setTrmtSrvcWrkfloId
- (new Long(rs.getLong("TRMTSRVCWRKFLOID")));
- if(rs.getString("routingflag")!=null)
- {
- srvcBean.setRoutingFlag(new Short(
- rs.getShort("routingFlag")));
- }
- if(rs.getString("REASONFORDEDUCTION")!=null)
- {
- srvcBean.setReasonForDeduction(rs.getString("REASONFORDEDUCTION"));
- }
- srvcBean.setTrmtSrvcStatus(
- new Short(rs.getShort("TRMTSRVCSTATUS")));
- if(rs.getObject("INVOICEDETAILSID") != null)
- {
- invoiceDetailsId = rs.getLong("INVOICEDETAILSID");
- }
- if(rs.getObject("APPEALSTATUS") != null)
- {
- appealStatus = rs.getShort("APPEALSTATUS");
- }
- if(rs.getObject("APPROVEDUNITS")!= null)
- {
- srvcBean.setApprovedUnits(rs.getFloat("APPROVEDUNITS"));
- }
- if(rs.getObject("REJECTIONCODE")!= null)
- {
- srvcBean.setRejectionCode
- (new Short(rs.getShort("REJECTIONCODE")));
- }
- if(rs.getObject("FILENUMBER")!=null)
- {
- srvcBean.setFileNumber
- (new Long(rs.getLong("FILENUMBER")));
- fileNumber = srvcBean.getFileNumber();
- }
- if(rs.getObject("PAGENUMBER")!=null)
- {
- srvcBean.setPageNumber
- (new Long(rs.getLong("PAGENUMBER")));
- pageNumber = srvcBean.getPageNumber();
- }
- if(rs.getObject("REASONOFAPPEALDEDCUTION")!=null)
- {
- srvcBean.setReasonOfAppealDedcution(rs.getString("REASONOFAPPEALDEDCUTION"));
- }
- if(rs.getObject("ISNONDISCOUNT")!=null)
- {
- srvcBean.setIsNonDiscount(rs.getByte("ISNONDISCOUNT"));
- }
- if(rs.getObject("APPEALDEDCUTIONSTATUS")!=null)
- {
- srvcBean.setAppealDedcutionStatus(rs.getShort("APPEALDEDCUTIONSTATUS"));
- }
- if(rs.getObject("APPEALDEDCUTIONDATE")!=null)
- {
- srvcBean.setAppealDedcutionDate(rs.getTimestamp("APPEALDEDCUTIONDATE"));
- }
- if(rs.getObject("APPEALDEDCUTIONWFID")!=null)
- {
- srvcBean.setAppealDedcutionWfId(rs.getLong("APPEALDEDCUTIONWFID"));
- }
- srvcBean.setHospitalCode
- (new Long (rs.getLong("HOSPITALCODE")));
- sbQuery = sbQuery.delete(0,sbQuery.length());
- //GOSIDebug.debugMessages("trmt code" + srvcBean.getTrmtCode());
- if(srvcBean.getTrmtCode().trim().
- equalsIgnoreCase(OHConstants.ICD_MEDICINE_CODE))
- {
- srvcBean.setMedicineDescription
- (srvcBean.getTrmtDesc());
- srvcBean.setMedicineAmount(srvcBean.getTrmtAmt());
- if (invoiceDetailsId == null)
- {
- srvcBean.setTrmtAmt(null);
- srvcBean.setTrmtCode("");
- srvcBean.setTrmtDesc("");
- }
- // get SFDA Medicine Details
- sbQuery.append("SELECT ID, REGISTRATIONNUM, GENERICNAME , TRADENAME, STRENGTHVALUE, ");
- sbQuery.append("UNITOFSTRENGTH, DOSAGEFORM , ROUTEOFADMINISTRATION, ATCCODE1, ATCCODE2, VOLUME, ");
- sbQuery.append("UNITOFVOLUME, PACKAGETYPE , PACKAGESIZE , LEGALSTATUS, PRODUCTCONTROL, PUBLICPRICE, ");
- sbQuery.append("SHELFLIFE , STORAGECONDITIONS , MANUFACTURERNAME, COUNTRYOFMANUFACTURER, ");
- sbQuery.append("MARKETINGCOMPANY, NATIONALITY , AGENTNAME , AUTHORIZATIONSTATUS , MARKETINGSTATUS,DRUGTYPE, ");
- sbQuery.append("REMARKS FROM T_SFDA WHERE REGISTRATIONNUM=? ");
- //GOSIDebug.debugMessages("SqlQuery trmt \n"+sbQuery);
- //GOSIDebug.debugMessages("SFDACode trmt \n"+srvcBean.getSFDACode());
- p = con.prepareStatement(sbQuery.toString());
- p.setString(1,srvcBean.getSFDACode());
- rsTreatment = p.executeQuery();
- if(rsTreatment.next())
- {
- SFDABean medicineBean = new SFDABean();
- medicineBean.setId(rsTreatment.getLong("ID"));
- medicineBean.setRegistrationNumber(rsTreatment.getString("REGISTRATIONNUM"));
- medicineBean.setGenericName(rsTreatment.getString("GENERICNAME"));
- medicineBean.setTradeName(rsTreatment.getString("TRADENAME"));
- medicineBean.setStrengthValue(rsTreatment.getString("STRENGTHVALUE"));
- medicineBean.setUnitOfStrength(rsTreatment.getString("UNITOFSTRENGTH"));
- medicineBean.setDosageForm(rsTreatment.getString("DOSAGEFORM"));
- medicineBean.setRouteOfAdministration(rsTreatment.getString("ROUTEOFADMINISTRATION"));
- medicineBean.setAtcCode1(rsTreatment.getString("ATCCODE1"));
- medicineBean.setAtcCode2(rsTreatment.getString("ATCCODE2"));
- medicineBean.setVolume(rsTreatment.getString("VOLUME"));
- medicineBean.setUnitOfVolume(rsTreatment.getString("UNITOFVOLUME"));
- medicineBean.setPackageType(rsTreatment.getString("PACKAGETYPE"));
- medicineBean.setPackageSize(rsTreatment.getInt("PACKAGESIZE"));
- medicineBean.setLegalStatus(rsTreatment.getString("LEGALSTATUS"));
- medicineBean.setProductControl(rsTreatment.getString("PRODUCTCONTROL"));
- medicineBean.setPublicPrice(rsTreatment.getDouble("PUBLICPRICE"));
- medicineBean.setShelfLife(rsTreatment.getInt("SHELFLIFE"));
- medicineBean.setStorageConditions(rsTreatment.getString("STORAGECONDITIONS"));
- medicineBean.setManufacturername(rsTreatment.getString("MANUFACTURERNAME"));
- medicineBean.setCountryOfManufacturer(rsTreatment.getString("COUNTRYOFMANUFACTURER"));
- medicineBean.setMarketingCompany(rsTreatment.getString("MARKETINGCOMPANY"));
- medicineBean.setNationality(rsTreatment.getString("NATIONALITY"));
- medicineBean.setAgentName(rsTreatment.getString("AGENTNAME"));
- medicineBean.setAuthorizationStatus(rsTreatment.getString("AUTHORIZATIONSTATUS"));
- medicineBean.setMarketingStatus(rsTreatment.getString("MARKETINGSTATUS"));
- medicineBean.setDrugType(rsTreatment.getString("DRUGTYPE").charAt(0));
- medicineBean.setRemarks(rsTreatment.getString("REMARKS"));
- details.put ("SFDABean", medicineBean);
- srvcBean.setSFDAMedicinePrice(medicineBean.getPublicPrice());
- srvcBean.setDrugType(medicineBean.getDrugType());
- }
- GOSIUtilities.cleanUp(rsTreatment);
- }
- else if(srvcBean.getTrmtCode().trim().
- equalsIgnoreCase(OHConstants.TRMT_SRVC_BULK_ENTRY))
- {
- srvcBean.setTrmt
- (GOSIErrorMessages.getErrorDesc("SOI_ERR_5309"));
- }
- else if(invoiceDetailsId != null)
- {
- /* This query is used to get the
- treatment description for the
- treatment code passed */
- sbQuery.append(" SELECT NVL (treatmentdescarb, treatmentdesceng) AS TRMT , MEDCATEGORY FROM ");
- sbQuery.append( SITables.T_TRTMSERVICELIST);
- sbQuery.append(" WHERE hospitalcode = ? " );
- sbQuery.append(" AND treatmentcode LIKE ? " );
- sbQuery.append(" AND status = ? " );
- // GOSIDebug.debugMessages("SqlQuery trmt \n"+sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,srvcBean.getHospitalCode());
- p.setString(2,srvcBean.getTrmtCode());
- p.setShort(3,OHConstants.VS_APPROVED);
- rsTreatment = p.executeQuery();
- if(rsTreatment.next())
- {
- srvcBean.setTrmt(rsTreatment.
- getString(1));
- if(rsTreatment.getObject(2)!=null)
- srvcBean.setMedicalCategory(rsTreatment.
- getString(2));
- else
- srvcBean.setMedicalCategory("None");
- }
- GOSIUtilities.cleanUp(rsTreatment);
- }
- else
- {
- /* This query is used to get the
- treatment description for the
- treatment code passed */
- sbQuery.append(" SELECT icd10treatment FROM ");
- sbQuery.append( SITables.T_ICDTREATMENTDATA);
- sbQuery.append(" WHERE icd10treatmentcode LIKE ? " );
- sbQuery.append(" OR icd10treatmentcode LIKE ? " );
- GOSIDebug.debugMessages("SqlQuery trmt \n"+sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setString(1,srvcBean.getTrmtCode());
- p.setString(2,srvcBean.getTrmtCode().toUpperCase());
- rsTreatment = p.executeQuery();
- if(rsTreatment.next())
- {
- srvcBean.setTrmt(rsTreatment.
- getString(1));
- }
- GOSIUtilities.cleanUp(rsTreatment);
- }
- srvcBean.setPatientNumber
- (rs.getString("PATIENTNUMBER"));
- srvcBean.setMode(AuditBean.OLD_MODE);
- injuryId = new Long (rs.getLong("INJURYID"));
- disabilityAssessmentId = new Long (rs.getLong("SCHEDULEID"));
- srvcBean.setHospitalDesc(rs.getString("HOSPITALNAMEARB"));
- hospitalDesc = srvcBean.getHospitalDesc();
- hospitalCode = srvcBean.getHospitalCode();
- patientNumber = srvcBean.getPatientNumber();
- serviceList.add(srvcBean);
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- if(injuryId!=null && (disabilityAssessmentId==null || disabilityAssessmentId<=0))
- {
- GOSIDebug.debugMessages("injuryId "+injuryId);
- sbQuery.append(" SELECT A.injuryid,A.socinsnumber, ");
- sbQuery.append(" A.injurydateentfmt,A.injurydate,A.datecomplication, ");
- sbQuery.append(" A.injurynumber,B.registrationnumber, ");
- sbQuery.append(" D.firstname || ' ' || ");
- sbQuery.append(" NVL(D.secondname,'')|| ' ' || " );
- sbQuery.append(" NVL(D.thirdname,'')||' ' || ");
- sbQuery.append(" NVL(D.surname,'') NAME, ");
- sbQuery.append(" D.nationalitycode, " );
- sbQuery.append(" B.fieldofficecode, A.contributorid, ");
- sbQuery.append(" A.establishmentid FROM ");
- sbQuery.append( SITables.T_INJURY + " A ,");
- sbQuery.append( SITables.T_ESTABLISHMENT + " B, ");
- sbQuery.append( SITables.T_CONTRIBUTOR + " C, ");
- sbQuery.append( SITables.T_PERSON + " D where ");
- sbQuery.append(" A.establishmentid = B.establishmentid ");
- sbQuery.append(" AND A.contributorid = C.contributorid " );
- sbQuery.append(" AND C.personid = D.personid AND " );
- sbQuery.append(" A.injurystatus != ? " );
- sbQuery.append(" AND A.injuryid = ? " );
- GOSIDebug.debugMessages("SqlQuery \n"+sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- //p.setShort(1,OHConstants.INJ_STS_REJECTED.shortValue());
- p.setShort(1,OHConstants.INJ_STS_CANCELLED.shortValue());
- p.setLong(2,injuryId.longValue());
- rs = p.executeQuery();
- InjuryPopDetails injuryDetails = null;
- while(rs.next())
- {
- injuryDetails = new InjuryPopDetails();
- injuryDetails.setInjuryID( new Long
- (rs.getLong("INJURYID")));
- injuryDetails.setSocialInsuranceNumber
- ( new Long(rs.getLong("SOCINSNUMBER")));
- injuryDetails.setInjuryDate(rs.getTimestamp
- ("INJURYDATE"));
- injuryDetails.setInjuryDateEntFmt
- (rs.getString("INJURYDATEENTFMT"));
- if(OHConstants.HIJRAH.equals
- (injuryDetails.getInjuryDateEntFmt()))
- {
- injuryDetails.setInjuryDateStr
- (GOSIDateUtilities.convertToHijra(
- GOSIUtilities.getDateFullString(
- injuryDetails.getInjuryDate())));
- }
- else
- {
- injuryDetails.setInjuryDateStr
- (GOSIUtilities.getDateFullString(
- injuryDetails.getInjuryDate()));
- }
- if(rs.getObject("DATECOMPLICATION")!=null)
- {
- injuryDetails.setComplicationDate
- (rs.getTimestamp("DATECOMPLICATION"));
- injuryDetails.setComplicationDateStr(OHUtilities.getDateStr
- (injuryDetails.getComplicationDate(),injuryDetails.getInjuryDateEntFmt()));
- }
- injuryDetails.setInjuryNumber
- ( new Long(rs.getLong("INJURYNUMBER")));
- injuryDetails.setName(rs.getString("NAME"));
- injuryDetails.setNationality
- (new Short(rs.getShort("NATIONALITYCODE")));
- injuryDetails.setFieldOffice
- (new Short(rs.getShort("FIELDOFFICECODE")));
- injuryDetails.setContributorId(
- new Long(rs.getLong("CONTRIBUTORID")));
- establishmentId = rs.getLong
- ("ESTABLISHMENTID");
- GOSIDebug.debugMessages("est id ***" +
- establishmentId );
- injuryDetails.setHospitalCode(hospitalCode);
- injuryDetails.setHospitalNameArb(hospitalDesc);
- injuryDetails.setPatientNumber(patientNumber);
- injuryDetails.setFileNumber(fileNumber);
- injuryDetails.setPageNumber(pageNumber);
- ContributorBean oContributorBean =
- new ContributorBean();
- oContributorBean = ContributorUtilities.
- displayContributor(injuryDetails.getContributorId());
- GOSIDebug.debugMessages("PersonId::"+oContributorBean.
- getPersonId());
- PersonBean oPersonBean = new PersonBean();
- oPersonBean = PersonUtilities.
- displayPerson(oContributorBean.getPersonId());
- GOSIDebug.debugMessages("first name" +
- oPersonBean.getFirstName());
- GOSIDebug.debugMessages("first name" +
- oPersonBean.getFirstName());
- GOSIDebug.debugMessages("second name" +
- oPersonBean.getSecondName());
- GOSIDebug.debugMessages("third name" +
- oPersonBean.getThirdName());
- GOSIDebug.debugMessages("surname" +
- oPersonBean.getSurName());
- contributorName = oPersonBean.getFirstName();
- if(oPersonBean.getSecondName() != null)
- {
- contributorName += " " + oPersonBean.getSecondName();
- }
- if(oPersonBean.getThirdName() != null)
- {
- contributorName += " " + oPersonBean.getThirdName();
- }
- if(oPersonBean.getSurName() != null)
- {
- contributorName += " " + oPersonBean.getSurName();
- }
- GOSIDebug.debugMessages("contributor Name ^^^" +
- contributorName);
- injuryDetails.setName(contributorName);
- if(oPersonBean.getNationalityCode() != null)
- {
- injuryDetails.setNationality
- (oPersonBean.getNationalityCode());
- }
- GOSIDebug.debugMessages("nationality code ^^^" +
- oPersonBean.getNationalityCode());
- EstablishmentBean oEstablishmentBean =
- new EstablishmentBean();
- EstablishmentUtility oEstablishmentUtility =
- new EstablishmentUtility();
- oEstablishmentBean = oEstablishmentUtility.
- getEstablishmentDetails(establishmentId,
- false,true);
- GOSIDebug.debugMessages("reg no" + oEstablishmentBean.
- getRegistrationNumber());
- if(oEstablishmentBean != null)
- {
- injuryDetails.setRegistrationNumber
- (oEstablishmentBean.
- getRegistrationNumber());
- }
- details.put("injuryDetails",injuryDetails);
- }
- }
- else if (disabilityAssessmentId!=null)
- {
- GOSIDebug.debugMessages("disabilityAssessmentId "+disabilityAssessmentId);
- GOSIUtilities.cleanUp (p, rs);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append("SELECT d.SCHEDULEID,d.SOCINSNUMBER, d.ASSESSMENTTYPE ,d.SESSIONDATE, " );
- sbQuery.append(" d.FIELDOFFICECODE, per.firstname, per.secondname, per.thirdname, per.surname ");
- sbQuery.append(" FROM " + SITables.T_MBAPPOINTMENT + " d " );
- sbQuery.append(" LEFT JOIN " + SITables.T_CONTRIBUTOR + " con ON d.SOCINSNUMBER = con.socialinsurancenumber " );
- sbQuery.append(" LEFT JOIN " + SITables.T_PERSON + " per ON con.personid = per.personid " );
- sbQuery.append(" WHERE d.SCHEDULEID = ? ");
- sbQuery.append(" AND d.APPOINTMENTSTATUS <> ? ");
- p = con.prepareStatement (sbQuery.toString());
- p.setLong (1, disabilityAssessmentId);
- p.setShort (2, OHConstants.ASSMT_CANCELLED);
- rs = p.executeQuery ();
- if (rs.next())
- {
- OHDAssessmentHeaderBean disabilityAssessmentBean = new OHDAssessmentHeaderBean ();
- disabilityAssessmentBean.setDisabilityAssessmentID (new Long(rs.getLong("SCHEDULEID")));
- disabilityAssessmentBean.setSocialInsuranceNumber (new Long(rs.getLong("SOCINSNUMBER")));
- disabilityAssessmentBean.setFieldOfficeCode (rs.getShort("FIELDOFFICECODE"));
- disabilityAssessmentBean.setContributorName (OHUtilities.getFullName(rs.getString("FIRSTNAME"), rs.getString("SECONDNAME"),
- rs.getString("THIRDNAME"), rs.getString("SURNAME")));
- disabilityAssessmentBean.setScheduleID(new Long(rs.getLong("SCHEDULEID")));
- disabilityAssessmentBean.setDisabilityType(new Short (rs.getShort("ASSESSMENTTYPE"))) ;
- disabilityAssessmentBean.setAssessmentDateTmsp((rs.getTimestamp("SESSIONDATE")));
- if(disabilityAssessmentBean.getDisabilityType().equals(OHConstants.HEIRDISB_ASSMT.shortValue()))
- {
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append( "SELECT per.firstname, per.secondname, per.thirdname, per.surname ");
- sbQuery.append(" FROM " + SITables.T_MBAPPOINTMENT + " mba " );
- sbQuery.append(" LEFT JOIN " + SITables.T_PERSON + " per ON mba.heirpersonid = per.personid " );
- sbQuery.append(" WHERE mba.scheduleid = ? " );
- p = con.prepareStatement (sbQuery.toString());
- p.setLong (1, disabilityAssessmentBean.getScheduleID());
- rs2 = p.executeQuery ();
- if (rs2.next())
- {
- disabilityAssessmentBean.setHeirName(OHUtilities.getFullName(rs2.getString("FIRSTNAME"), rs2.getString("SECONDNAME"),
- rs2.getString("THIRDNAME"), rs2.getString("SURNAME")));
- }
- }
- details.put ("disabilityAssessmentBean", disabilityAssessmentBean);
- }
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- GOSIDebug.debugMessages("injury details fetched:");
- details.put("serviceList",serviceList);
- if (invoiceDetailsId != null)
- details.put("invoiceDetailsId", invoiceDetailsId);
- if (appealStatus != null)
- details.put("appealStatus", appealStatus);
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "searchTreatmentServiceInbox()",
- (System.currentTimeMillis() - timeCounter));
- return details;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("servlet : The exception is " +e);
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,this.getClass().toString(),
- "searchTreatmentServiceInbox()",e,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- }
- /* This method is used to store the modified treatment
- details to the database */
- /**
- * @METHOD NAME : modifyTreatmentService
- * @INFORMATION : This method is to modify Treatment Service
- * @PARAM : class java.util.ArrayList,
- class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails,
- class gosi.core.workflow.beans.WorkflowParamBean,
- class gosi.core.dms.beans.DMSRequestHeaderBean
- * @RETURN : class java.lang.String
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String modifyTreatmentService(ArrayList serviceList,
- InjuryPopDetails injuryBean,
- WorkflowParamBean workflowParamBean,DMSRequestHeaderBean dmsHeaderBean)
- throws GOSIException
- {
- GOSIDebug.debugMessages("method modify");
- String userName = "";
- int listSize = 0;
- int serviceListSize = 0;
- long timeCounter = 0;
- try
- {
- timeCounter = System.currentTimeMillis();
- TreatmentServiceDetailEntityHome home = (TreatmentServiceDetailEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_DET_ENTITY_JNDI,
- TreatmentServiceDetailEntityHome.class);
- if(serviceList != null)
- {
- serviceListSize = serviceList.size();
- }
- for(int i = 0;i < serviceListSize;i++)
- {
- TreatmentServiceBean trmtServiceBean = new
- TreatmentServiceBean();
- trmtServiceBean = (TreatmentServiceBean)serviceList.get(i);
- if((trmtServiceBean.getMedicineDescription() != null)
- &&(!(("").equals(trmtServiceBean.
- getMedicineDescription()))))
- {
- trmtServiceBean.setTrmtDesc
- (trmtServiceBean.getMedicineDescription()
- .replace('\'','\"'));
- trmtServiceBean.setTrmtCode
- (OHConstants.ICD_MEDICINE_CODE);
- }
- GOSIDebug.debugMessages("\n\n mode:"+trmtServiceBean.getMode()+"\n\n");
- if(trmtServiceBean.getMode() == AuditBean.MODIFY_MODE)
- {
- GOSIDebug.debugMessages("record id" +
- trmtServiceBean.getTrmtServiceDetId());
- TreatmentServiceDetailEntity detailRemote =
- (TreatmentServiceDetailEntity)home.findByPrimaryKey
- (trmtServiceBean.getTrmtServiceDetId());
- if(trmtServiceBean.getAppealDedcutionStatus()!=null &&
- trmtServiceBean.getAppealDedcutionStatus().equals(OHConstants.TRMT_SRVC_APPEAL_STS_REJECTED))
- {
- detailRemote.modifyAppealDedcution(trmtServiceBean);
- }
- else
- {
- detailRemote.modifyTreatmentServices(trmtServiceBean);
- }
- GOSIDebug.debugMessages("This Record was Modified");
- }
- else if(trmtServiceBean.getMode() == AuditBean.OLD_MODE)
- {
- GOSIDebug.debugMessages("This Record need not be Modified");
- }
- }
- GOSIDebug.debugMessages("Treatment Detail created\n");
- if(workflowParamBean != null)
- {
- userName = GOSIUtilities.startWorkflow(workflowParamBean);
- }
- if(dmsHeaderBean != null)
- {
- if(injuryBean!=null){
- dmsHeaderBean.setSourceRecordId
- ("" + injuryBean.getInjuryID());
- dmsHeaderBean.
- setSourceTable(SITables.T_INJURY);
- dmsHeaderBean.setCreatedBy
- (new Long (workflowParamBean.getUserId()));
- dmsHeaderBean.setKeyList(DMSConstants.SI_NUMBER,
- "" + injuryBean.getSocialInsuranceNumber());
- dmsHeaderBean.setKeyList(DMSConstants.INJURY_NUMBER,
- "" + injuryBean.getInjuryNumber());
- dmsHeaderBean.setKeyList(OHConstants.DMS_SERVICE_TYPE,
- "" + OHConstants.SERVICE_TYPE_TRMT);
- }
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "modifyTreatmentService()",
- (System.currentTimeMillis() - timeCounter));
- return userName;
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("The error in trmt srvc save is:"+ge);
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception se)
- {
- GOSIDebug.debugMessages("The error in trmt srvc save is:"+se);
- se.printStackTrace();
- ctx.setRollbackOnly();
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "modifyTreatmentService()",
- se,"CMN_ERR_1000" );
- }
- }
- /* This method is used to remove the treatment service details*/
- /**
- * @METHOD NAME : removeServiceDetils
- * @INFORMATION : This method is to remove Service Detils
- * @PARAM : class java.util.ArrayList
- * @RETURN : int
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public int removeServiceDetils(ArrayList idList)throws GOSIException
- {
- int deleted = 0;
- long timeCounter = 0;
- try
- {
- timeCounter = System.currentTimeMillis();
- // Context cntx = GOSIUtilities.getInitialContext();
- // Object ref = cntx.lookup
- // (OHConstants.TRMT_SRVC_DET_ENTITY_JNDI);
- // TreatmentServiceDetailEntityHome home =
- // (TreatmentServiceDetailEntityHome)PortableRemoteObject.
- // narrow(ref,TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntityHome home = (TreatmentServiceDetailEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_DET_ENTITY_JNDI,
- TreatmentServiceDetailEntityHome.class);
- for(int i = 0;i < idList.size();i++)
- {
- Long primarykey = (Long)idList.get(i);
- TreatmentServiceDetailEntity detailRemote =
- (TreatmentServiceDetailEntity)home.findByPrimaryKey
- (primarykey);
- detailRemote.remove();
- deleted++;
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "removeServiceDetils()",
- (System.currentTimeMillis() - timeCounter));
- return deleted;
- }
- catch(GOSIException ge)
- {
- ctx.setRollbackOnly();
- throw ge;
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("servlet : The exception is " +e);
- ctx.setRollbackOnly();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,this.getClass().toString(),
- "removeServiceDetils()",e,"CMN_ERR_1000" );
- }
- }
- /* This method is used to get the treatment period details */
- /**
- * @METHOD NAME : getTreatmentPeriodDetails
- * @INFORMATION : This method is to get Treatment Period Details
- * @PARAM : class java.lang.Long
- * @RETURN : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentPeriodBean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public TreatmentPeriodBean getTreatmentPeriodDetails
- (Long treatmentId) throws GOSIException
- {
- long timeCounter = 0;
- StringBuffer sbQuery = new StringBuffer();
- try
- {
- sbQuery = sbQuery.delete(0,sbQuery.length());
- timeCounter = System.currentTimeMillis();
- sbQuery.append(" SELECT a.TREATMENTID, a.PATIENTNUMBER, ");
- sbQuery.append(" a.STARTDATE,a.ENDDATE," );
- sbQuery.append(" a.HOSPITALCODE,b.HOSPITALNAMEARB, ");
- sbQuery.append(" a.TREATMENTSTATUS,a.WORKFLOWSTATUS ");
- sbQuery.append(" FROM "+ SITables.T_TREATMENT + " a , ");
- sbQuery.append( SITables.T_HOSPITAL + " b WHERE ");
- sbQuery.append(" a.HOSPITALCODE = b.HOSPITALCODE ");
- sbQuery.append(" AND a.TREATMENTID = ? " );
- GOSIDebug.debugMessages("sqlQuery " +sbQuery);
- TreatmentPeriodBean trmtPrdBean = new TreatmentPeriodBean();
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,treatmentId.longValue());
- rs = p.executeQuery();
- while(rs.next())
- {
- trmtPrdBean.setTreatmentId
- (new Long(rs.getLong("TREATMENTID")));
- trmtPrdBean.setPatientNumber(rs.getString
- ("PATIENTNUMBER"));
- trmtPrdBean.setStartDateGreg(rs.getTimestamp
- ("STARTDATE"));
- trmtPrdBean.setEndDateGreg(rs.getTimestamp
- ("ENDDATE"));
- trmtPrdBean.setTreatmentStatus
- (new Short(rs.getShort("TREATMENTSTATUS")));
- trmtPrdBean.setWorkflowStatus
- (new Short(rs.getShort("WORKFLOWSTATUS")));
- trmtPrdBean.setHospitalCode(new Long("HOSPITALCODE"));
- trmtPrdBean.setHospitalNameArb(rs.getString
- ("HOSPITALNAMEARB"));
- }
- sbQuery = sbQuery.delete(0,sbQuery.length());
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "getTreatmentPeriodDetails()",
- (System.currentTimeMillis() - timeCounter));
- return trmtPrdBean;
- }
- catch(GOSIException ge)
- {
- throw ge;
- }
- catch(Exception se)
- {
- se.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "getTreatmentPeriodDetails()",se,"CMN_ERR_1000" );
- }
- finally
- {
- GOSIUtilities.cleanUp(con,p,rs);
- }
- }
- /* This method is used to store the injury date*/
- /**
- * @METHOD NAME : storeInjuryDetails
- * @INFORMATION : This method is to store Injury Details
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails
- * @RETURN : class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public InjuryPopDetails storeInjuryDetails
- (InjuryPopDetails injuryDetails)throws GOSIException
- {
- try
- {
- Timestamp injuryDate = null;
- if(injuryDetails.getInjuryDateStr() != null &&
- !("").equals(injuryDetails.getInjuryDateStr()))
- {
- if(OHConstants.HIJRAH.equals(injuryDetails.
- getInjuryDateEntFmt()))
- {
- injuryDate = GOSIUtilities.getTimestamp
- (GOSIDateUtilities.convertToGregorian
- (injuryDetails.getInjuryDateStr()));
- }
- else
- {
- injuryDate = GOSIUtilities.getTimestamp(
- injuryDetails.getInjuryDateStr());
- }
- injuryDetails.setInjuryDate(injuryDate);
- }
- return injuryDetails;
- }
- catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("session:storeInjuryDetails:ge:"+ge);
- throw ge;
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("session:storeInjuryDetails:e:"+e);
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "storeInjuryDetails()",e,"CMN_ERR_1000" );
- }
- }
- /* This method is used to store the treatment date */
- /**
- * @METHOD NAME : storeTreatmentServiceDetails
- * @INFORMATION : This method is to store Treatment Service Details
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentServiceBean
- * @RETURN : class gosi.business.socialinsurance.occupationalhazards.injury.beans.TreatmentServiceBean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public TreatmentServiceBean storeTreatmentServiceDetails
- (TreatmentServiceBean serviceBean)throws GOSIException
- {
- try
- {
- Timestamp trmtDate = null;
- if(serviceBean.getTrmtDateStr() != null &&
- !("").equals(serviceBean.getTrmtDateStr()))
- {
- if(OHConstants.HIJRAH.equals(serviceBean.
- getTrmtDateEntFmt()))
- {
- trmtDate = GOSIUtilities.getTimestamp
- (GOSIDateUtilities.convertToGregorian
- (serviceBean.getTrmtDateStr()));
- }
- else
- {
- trmtDate = GOSIUtilities.getTimestamp(
- serviceBean.getTrmtDateStr());
- }
- serviceBean.setTrmtDateGreg (trmtDate);
- }
- return serviceBean;
- }catch(GOSIException ge)
- {
- GOSIDebug.debugMessages("session:storeInjuryDetails:ge:"+ge);
- throw ge;
- }
- catch(Exception e)
- {
- GOSIDebug.debugMessages("session:storeInjuryDetails:e:"+e);
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "storeTreatmentServiceDetails()",e,"CMN_ERR_1000" );
- }
- }
- /* This method is used to validate the treatment date
- by comparing it with injury date */
- /**
- * @METHOD NAME : isValidTreatmentDate
- * @INFORMATION : This method is to is Valid Treatment Date
- * @PARAM : class java.sql.Timestamp,
- class java.sql.Timestamp
- * @RETURN : boolean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public boolean isValidTreatmentDate(Timestamp injuryDate,
- Timestamp treatmentDate) throws GOSIException
- {
- boolean isValidTreatmentDateFlag = true;
- try
- {
- if(injuryDate.compareTo(treatmentDate) > 0)
- {
- isValidTreatmentDateFlag = false;
- }
- return isValidTreatmentDateFlag;
- }
- catch(Exception e)
- {
- e.printStackTrace();
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isValidTreatmentDate()",
- e,"CMN_ERR_1000" );
- }
- }
- /* This method is used to validate the
- social insurance number entered by the user */
- /**
- * @METHOD NAME : isValidSocInsNumber
- * @INFORMATION : This method is to is Valid Social Insurance Number
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.InjuryPopDetails
- * @RETURN : int
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public int isValidSocInsNumber
- (InjuryPopDetails injuryDetails)
- throws GOSIException
- {
- /* Declaration and initialization of variables */
- Long socInsNumber = null;
- int checkSocInsNumber = 0;
- long timeCounter = 0;
- StringBuffer sbQuery = new StringBuffer();
- /* Declaration of constants */
- final int INVALID_SOCIAL_INS_NO = 1;
- final int SOCIAL_INS_NO_NOT_PRESENT_IN_INJURY_TABLE = 2;
- try
- {
- timeCounter = System.currentTimeMillis();
- /* Get the social insurance number */
- socInsNumber = injuryDetails.getSocialInsuranceNumber();
- /* Get the connection object */
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- /* This query is used to determine if their
- exists a record in contributor table
- for the social insurance number entered by the user */
- sbQuery.append(" SELECT contributorid " );
- sbQuery.append(" FROM " + SITables.T_CONTRIBUTOR);
- sbQuery.append(" WHERE socialinsurancenumber = ? ");
- GOSIDebug.debugMessages("query" + sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- p.setLong(1,socInsNumber.longValue());
- rs = p.executeQuery();
- /* Error message is displayed if
- no record exists in the contributor table
- for the social insurance number entered by user*/
- if(!(rs.next()))
- {
- checkSocInsNumber = INVALID_SOCIAL_INS_NO;
- return checkSocInsNumber;
- }
- GOSIUtilities.cleanUp(rs);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- /* This query is used to determine if their
- exists a record in injury table
- for the social insurance number entered by the user */
- sbQuery.append(" SELECT socinsnumber ");
- sbQuery.append(" FROM " + SITables.T_INJURY );
- sbQuery.append(" WHERE injurystatus != ? ");
- sbQuery.append(" AND socinsnumber = ? ");
- GOSIDebug.debugMessages("query" + sbQuery);
- p = con.prepareStatement(sbQuery.toString());
- //p.setShort(1,OHConstants.INJ_STS_REJECTED.shortValue());
- p.setShort(1,OHConstants.INJ_STS_CANCELLED.shortValue());
- p.setLong(2,socInsNumber.longValue());
- rs = p.executeQuery();
- /* Error message is displayed if
- no record exists in the injury table
- for the social insurance number entered by user*/
- if(!(rs.next()))
- {
- checkSocInsNumber =
- SOCIAL_INS_NO_NOT_PRESENT_IN_INJURY_TABLE;
- return checkSocInsNumber;
- }
- GOSIUtilities.cleanUp(rs);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch (GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isValidSocInsNumber()",
- e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "isValidSocInsNumber()",
- (System.currentTimeMillis() - timeCounter));
- return checkSocInsNumber;
- }
- /* This method is used to get the registered
- hospitals for the passed injury id and
- field office code */
- /**
- * @METHOD NAME : searchRegisteredHospitalList
- * @INFORMATION : This method is to search Registered Hospital List
- * @PARAM : class java.lang.Long,
- class gosi.business.socialinsurance.occupationalhazards.injury.beans.OHPopSearchBean
- * @RETURN : class java.util.ArrayList
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public ArrayList searchRegisteredHospitalList
- (Long injuryId,OHPopSearchBean hospitalSearchBean)
- throws GOSIException
- {
- /* Declaration and initialization of variables*/
- ArrayList hospitalArrayList = new ArrayList();
- StringBuffer sbQuery = new StringBuffer();
- long timeCounter = 0;
- try
- {
- timeCounter = System.currentTimeMillis();
- /* Get the connection object */
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- sbQuery = sbQuery.delete(0,sbQuery.length());
- long firstId = hospitalSearchBean.getFirstId();
- long lastId = hospitalSearchBean.getLastId();
- GOSIDebug.debugMessages("firstId"+firstId);
- GOSIDebug.debugMessages("lastId"+lastId);
- GOSIDebug.debugMessages("field office" +
- hospitalSearchBean.getFieldOffice());
- byte buttonClicked = hospitalSearchBean.
- getButtonClicked();
- GOSIDebug.debugMessages("buttonClicked" + buttonClicked);
- if (buttonClicked == NavigationBean.BUTTON_SEARCH)
- {
- /*
- sbQuery.append(" SELECT DISTINCT HOSP.HOSPITALCODE, ");
- sbQuery.append(" HOSP.HOSPITALNAME, ");
- sbQuery.append(" TRMT.PATIENTNUMBER FROM ");
- //sbQuery.append(" HOSP.HOSPITALNAMEENG FROM ");
- sbQuery.append( SITables.T_HOSPITALCONTRACT + " HOSP, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.FIELDOFFICECODE " );
- */
- sbQuery.append(" SELECT DISTINCT HOSP.HOSPITALCODE, ");
- sbQuery.append(" HOSP.HOSPITALNAMEARB, ");
- sbQuery.append(" TRMT.PATIENTNUMBER , ");
- sbQuery.append(" HOSP.HOSPITALNAMEENG FROM ");
- sbQuery.append( SITables.T_HOSPITAL + " HOSP, " );
- sbQuery.append( SITables.T_HOSPITALFOASSOCIATION + " HFO, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.HOSPITALCODE = ");
- sbQuery.append(" HFO.HOSPITALCODE ");
- sbQuery.append(" AND HFO.FIELDOFFICECODE " );
- sbQuery.append(" = ? ");
- sbQuery.append(" AND HOSP.HOSPITALTYPE = ? ");
- sbQuery.append(" AND TRMT.TREATMENTSTATUS IN ( ?,? ) ");
- sbQuery.append(" AND TRMT.INJURYID = ? " );
- sbQuery.append(" ORDER BY HOSP.HOSPITALCODE ");
- p = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- p.setShort
- (1,hospitalSearchBean.getFieldOffice()
- .shortValue());
- p.setShort
- (2,OHConstants.REG_HOSPITAL.shortValue());
- p.setShort(3,
- OHConstants.TRMT_STS_ENTERED.shortValue());
- p.setShort(4,
- OHConstants.TRMT_STS_APPROVED.shortValue());
- p.setLong(5,injuryId.longValue());
- }
- else if (buttonClicked == NavigationBean.BUTTON_NEXT)
- {
- sbQuery.append(" SELECT DISTINCT HOSP.HOSPITALCODE, ");
- sbQuery.append(" HOSP.HOSPITALNAMEARB, ");
- sbQuery.append(" TRMT.PATIENTNUMBER , ");
- sbQuery.append(" HOSP.HOSPITALNAMEENG FROM ");
- sbQuery.append( SITables.T_HOSPITAL + " HOSP, " );
- sbQuery.append( SITables.T_HOSPITALFOASSOCIATION + " HFO, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.HOSPITALCODE = ");
- sbQuery.append(" HFO.HOSPITALCODE ");
- sbQuery.append(" AND HFO.FIELDOFFICECODE " );
- sbQuery.append(" = ? ");
- sbQuery.append(" AND HOSP.HOSPITALTYPE = ? ");
- sbQuery.append(" AND TRMT.TREATMENTSTATUS IN ( ?,? ) ");
- sbQuery.append(" AND TRMT.INJURYID = ? " );
- sbQuery.append(" AND HOSP.HOSPITALCODE > ? ");
- sbQuery.append(" ORDER BY HOSP.HOSPITALCODE ");
- p = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- p.setShort
- (1,hospitalSearchBean.getFieldOffice()
- .shortValue());
- p.setShort
- (2,OHConstants.REG_HOSPITAL.shortValue());
- p.setShort(3,
- OHConstants.TRMT_STS_ENTERED.shortValue());
- p.setShort(4,
- OHConstants.TRMT_STS_APPROVED.shortValue());
- p.setLong(5,injuryId.longValue());
- p.setLong(6,lastId);
- }
- else if (buttonClicked == NavigationBean.BUTTON_PREVIOUS)
- {
- sbQuery.append(" SELECT DISTINCT HOSP.HOSPITALCODE, ");
- sbQuery.append(" HOSP.HOSPITALNAMEARB, ");
- sbQuery.append(" TRMT.PATIENTNUMBER,");
- sbQuery.append(" HOSP.HOSPITALNAMEENG FROM ");
- sbQuery.append( SITables.T_HOSPITAL + " HOSP, " );
- sbQuery.append( SITables.T_HOSPITALFOASSOCIATION + " HFO, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.HOSPITALCODE = ");
- sbQuery.append(" HFO.HOSPITALCODE ");
- sbQuery.append(" AND HFO.FIELDOFFICECODE " );
- sbQuery.append(" = ? ");
- sbQuery.append(" AND HOSP.HOSPITALTYPE = ? ");
- sbQuery.append(" AND TRMT.TREATMENTSTATUS IN ( ?,? ) ");
- sbQuery.append(" AND TRMT.INJURYID = ? " );
- sbQuery.append(" AND HOSP.HOSPITALCODE < ? ");
- sbQuery.append(" ORDER BY HOSP.HOSPITALCODE DESC ");
- p = con.prepareStatement(sbQuery.toString(),
- ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY);
- p.setShort
- (1,hospitalSearchBean.getFieldOffice()
- .shortValue());
- p.setShort
- (2,OHConstants.REG_HOSPITAL.shortValue());
- p.setShort(3,
- OHConstants.TRMT_STS_ENTERED.shortValue());
- p.setShort(4,
- OHConstants.TRMT_STS_APPROVED.shortValue());
- p.setLong(5,injuryId.longValue());
- p.setLong(6,firstId);
- }
- GOSIDebug.debugMessages("query" + sbQuery);
- int count = 1;
- GOSIDebug.debugMessages("after prep stmt");
- p.setMaxRows(GOSIApplicationProperties.MAX_PAGE_SIZE+1);
- rs = p.executeQuery();
- GOSIDebug.debugMessages("after prep statement");
- if(rs.next())
- {
- rs.previous();
- while(rs.next())
- {
- HospitalListBean hospital = new HospitalListBean();
- hospital.setHospitalCode(new Long(rs.getLong("HOSPITALCODE")));
- hospital.setHospitalNameArb(rs.getString("HOSPITALNAMEARB"));
- hospital.setPatientNumber(rs.getString("PATIENTNUMBER"));
- hospital.setHospitalNameEng(rs.getString("HOSPITALNAMEENG"));
- hospitalArrayList.add(hospital);
- if(buttonClicked == NavigationBean.BUTTON_SEARCH ||
- buttonClicked == NavigationBean.BUTTON_NEXT)
- {
- if (count == 1)
- {
- hospitalSearchBean.
- setFirstId(((Long)hospital.
- getHospitalCode()).longValue());
- }
- else if(count < GOSIApplicationProperties.
- MAX_PAGE_SIZE + 1)
- {
- hospitalSearchBean.
- setLastId(((Long)hospital.
- getHospitalCode()).longValue());
- }
- }
- if(buttonClicked == NavigationBean.BUTTON_PREVIOUS)
- {
- if (count ==1)
- {
- hospitalSearchBean.
- setLastId(((Long)hospital.
- getHospitalCode()).longValue());
- }
- else if(count < GOSIApplicationProperties.
- MAX_PAGE_SIZE + 1)
- {
- hospitalSearchBean.
- setFirstId(((Long)hospital.
- getHospitalCode()).longValue());
- }
- }
- count = count + 1;
- }
- hospitalArrayList.add(hospitalSearchBean);
- }
- GOSIDebug.debugMessages("hospital list size" +
- hospitalArrayList.size());
- sbQuery = sbQuery.delete(0,sbQuery.length());
- }
- catch (GOSIException ge)
- {
- throw ge;
- }
- catch(Exception e)
- {
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "searchRegisteredHospitalList()",
- e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con, p, rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "searchRegisteredHospitalList()",
- (System.currentTimeMillis() - timeCounter));
- return hospitalArrayList;
- }
- /* This method is used to determine if a single hospital
- is present for the selected injury id */
- /**
- * @METHOD NAME : isSingleHospitalPresent
- * @INFORMATION : This method is to is Single Hospital Present
- * @PARAM : interface java.sql.Connection,
- class java.lang.Long,
- class java.lang.Short
- * @RETURN : boolean
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- private boolean isSingleHospitalPresent(
- Connection con,Long injuryId,Short fieldOffice)
- throws GOSIException
- {
- /* Declaration and initialization of variables*/
- StringBuffer sbQuery = new StringBuffer();
- long timeCounter = 0;
- long recordCount = 0;
- boolean isSingleHospitalValue = false;
- try
- {
- timeCounter = System.currentTimeMillis();
- sbQuery = sbQuery.delete(0,sbQuery.length());
- sbQuery.append(" SELECT " );
- sbQuery.append(" COUNT(DISTINCT HOSP.HOSPITALCODE) ");
- sbQuery.append(" FROM ");
- sbQuery.append( SITables.T_HOSPITAL + " HOSP, " );
- sbQuery.append( SITables.T_HOSPITALFOASSOCIATION + " HOSPFO, " );
- sbQuery.append( SITables.T_TREATMENT );
- sbQuery.append(" TRMT WHERE ");
- sbQuery.append(" HOSP.HOSPITALCODE = ");
- sbQuery.append(" TRMT.HOSPITALCODE ");
- sbQuery.append(" AND HOSP.HOSPITALCODE = ");
- sbQuery.append(" HOSPFO.HOSPITALCODE ");
- sbQuery.append(" AND HOSPFO.FIELDOFFICECODE " );
- sbQuery.append(" = ? ");
- sbQuery.append(" AND HOSP.HOSPITALTYPE = ? ");
- sbQuery.append(" AND TRMT.TREATMENTSTATUS IN ( ?,? ) ");
- sbQuery.append(" AND TRMT.INJURYID = ? " );
- p = con.prepareStatement(sbQuery.toString());
- p.setShort
- (1,fieldOffice.shortValue());
- p.setShort
- (2,OHConstants.REG_HOSPITAL.shortValue());
- p.setShort(3,
- OHConstants.TRMT_STS_ENTERED.shortValue());
- p.setShort(4,
- OHConstants.TRMT_STS_APPROVED.shortValue());
- p.setLong(5,injuryId.longValue());
- GOSIDebug.debugMessages("sbQuery" + sbQuery);
- rs = p.executeQuery();
- if(rs.next())
- {
- recordCount = rs.getLong(1);
- }
- GOSIDebug.debugMessages("recordCount" +
- recordCount);
- if(recordCount == 1)
- {
- isSingleHospitalValue = true;
- }
- GOSIDebug.debugMessages("isSingleHospital" +
- isSingleHospitalValue);
- }
- /* catch (GOSIException ge)
- {
- throw ge;
- }
- */
- catch(Exception e)
- {
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "isSingleHospitalPresent()",
- e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(rs);
- }
- GOSIInstrumentationLog.writeInstrumentationToLog(
- this.getClass().toString(),
- "isSingleHospitalPresent()",
- (System.currentTimeMillis() - timeCounter));
- return isSingleHospitalValue;
- }
- /* This method is added for companion */
- /**
- * @METHOD NAME : saveCompanionAsTreatmentService
- * @INFORMATION : This method is to save Companion As Treatment Service
- * @PARAM : class gosi.business.socialinsurance.occupationalhazards.injury.beans.CompanionBean
- * @RETURN : void
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void saveCompanionAsTreatmentService (CompanionBean companionBean)
- throws GOSIException
- {
- PreparedStatement ps = null;
- ResultSet rs= null;
- try
- {
- Long hospitalCode = null;
- String patientNumber = null;
- Long injuryId = companionBean.getInjuryId();
- Long userId = companionBean.getLastModifiedBy();
- con = GOSIUtilities.getConnection(GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- String sqlQuery = " select HOSPITALCODE,PATIENTNUMBER from "+
- SITables.T_TREATMENT +" where INJURYID = ? "+
- " and TREATMENTSTATUS = ? ";
- ps = con.prepareStatement(sqlQuery);
- ps.setLong(1,injuryId.longValue());
- ps.setShort(2,OHConstants.TRMT_STS_APPROVED.shortValue());
- rs = ps.executeQuery();
- while(rs.next())
- {
- hospitalCode = new Long(rs.getLong("HOSPITALCODE"));
- patientNumber = rs.getString("PATIENTNUMBER");
- }
- TreatmentServiceBean serviceBean = new TreatmentServiceBean();
- serviceBean.setHospitalCode(hospitalCode);
- serviceBean.setPatientNumber(patientNumber);
- Long headerId = this.getHeaderId(serviceBean, injuryId);
- if(headerId == null)
- {
- TreatmentHeaderBean headerBean = new TreatmentHeaderBean();
- headerId =GOSIUtilities.getPrimaryKey("T_TRMTSERVICESHDR",userId);
- headerBean.setTrmtServiceHdrId(headerId);
- GOSIDebug.debugMessages("HeaderId:"+headerBean.getTrmtServiceHdrId());
- headerBean.setHospitalCode(hospitalCode);
- headerBean.setPatientNumber(patientNumber);
- headerBean.setInjuryId(injuryId);
- headerBean.setCreatedBy(userId);
- headerBean.setCreationTimestamp(new Timestamp(
- System.currentTimeMillis()));
- //
- // Context cntx = GOSIUtilities.getInitialContext();
- // Object ref = cntx.lookup(OHConstants.TRMT_SRVC_HDR_ENTITY_JNDI);
- // TreatmentServiceHeaderEntityHome home =
- // (TreatmentServiceHeaderEntityHome)PortableRemoteObject.
- // narrow(ref,TreatmentServiceHeaderEntityHome.class);
- TreatmentServiceHeaderEntityHome home = (TreatmentServiceHeaderEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_HDR_ENTITY_JNDI,
- TreatmentServiceHeaderEntityHome.class);
- TreatmentServiceHeaderEntity headerRemote =
- (TreatmentServiceHeaderEntity)home.create(headerBean);
- }
- else
- {
- GOSIDebug.debugMessages("headerId already exists:"+headerId);
- }
- serviceBean.setTrmtServiceDetId(
- GOSIUtilities.getPrimaryKey("T_TRMTSERVICESDET",userId));
- serviceBean.setTrmtServiceHdrId(headerId);
- serviceBean.setTrmtDateGreg(companionBean.getCompStDateGreg());
- serviceBean.setTrmtDateEntFmt(companionBean.getCompStDateEntFmt());
- if(OHConstants.COMPANION_TYPE_DOCTOR.equals
- (companionBean.getTypeOfComp()))
- {
- serviceBean.setTrmtCode(OHConstants.ICD_CODE_DOCTOR);
- int noDays = companionBean.getNumberDays();
- if(noDays > OHRuleBean.getMaxPayableDaysCompanion())
- {
- noDays=OHRuleBean.getMaxPayableDaysCompanion();
- }
- serviceBean.setUnits(new Float(noDays));
- serviceBean.setTrmtAmt(companionBean.getDailyAllowanceComp());
- serviceBean.setUnitPrice(new Double(OHRuleBean.getDailyAllowanceForDoctor()));
- }else
- {
- serviceBean.setTrmtCode(OHConstants.ICD_CODE_NURSE);
- int noDays = companionBean.getNumberDays();
- if(noDays > OHRuleBean.getMaxPayableDaysCompanion())
- {
- noDays=OHRuleBean.getMaxPayableDaysCompanion();
- }
- serviceBean.setUnits(new Float(noDays));
- serviceBean.setTrmtAmt(companionBean.getDailyAllowanceComp());
- serviceBean.setUnitPrice(new Double(OHRuleBean.getDailyAllowanceForNurse()));
- }
- serviceBean.setTrmtSrvcStatus(OHConstants.TRMT_SRVC_STS_APPROVED);
- serviceBean.setTrmtSrvcStatus(OHConstants.WFS_SRVC_APPROVED_OH_HEAD);
- serviceBean.setWorkflowStatus(OHConstants.WFS_SRVC_APPROVED_OH_HEAD);
- serviceBean.setTrmtSrvcWrkfloId
- (GOSIUtilities.getPrimaryKey("TRMTSRVCWRKFLOID",userId));
- serviceBean.setCreatedBy(userId);
- serviceBean.setCreationTimestamp
- (new Timestamp(System.currentTimeMillis()));
- //
- // Context ctx=GOSIUtilities.getInitialContext();
- // Object ref=ctx.lookup(OHConstants.TRMT_SRVC_DET_ENTITY_JNDI);
- // TreatmentServiceDetailEntityHome detailhome=
- // (TreatmentServiceDetailEntityHome)
- // PortableRemoteObject.narrow
- // (ref,TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntityHome detailhome= (TreatmentServiceDetailEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_DET_ENTITY_JNDI,
- TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntity remote = detailhome.create(serviceBean);
- GOSIDebug.debugMessages("---Companion details saved as service----");
- }
- catch (GOSIException ge)
- {
- GOSIDebug.debugMessages("session:saveCompanionAsTreatmentService:ge:"+ge);
- throw ge;
- }
- catch (Exception e)
- {
- GOSIDebug.debugMessages("session:saveCompanionAsTreatmentService:e:"+e);
- throw new GOSIException( GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "saveCompanionAsTreatmentService()",
- e,
- "CMN_ERR_1000"
- );
- }
- finally
- {
- GOSIUtilities.cleanUp(con,ps,rs);
- }
- }
- /* This method is used to get the hospital name in internet
- scenario*/
- /**
- * @METHOD NAME : hospitalDetailsList
- * @INFORMATION : This method is to hospital Details List
- * @PARAM : class java.lang.Long
- * @RETURN : class [Ljava.lang.String;
- * @EXCEPTION : class gosi.core.util.GOSIException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public String[] hospitalDetailsList(Long hospitalCode)
- throws GOSIException
- {
- PreparedStatement ps = null;
- ResultSet rs= null;
- try
- {
- GOSIDebug.debugMessages("inside the Function hospitalDetails"+hospitalCode);
- con = GOSIUtilities.getConnection
- (GOSIConstants.OCCUPATIONAL_HAZARDS_ID);
- String sqlQuery = "";
- sqlQuery = " SELECT HOSPITALNAMEARB, "
- +" HOSPITALNAMEENG FROM "+ SITables.T_HOSPITAL
- +" WHERE HOSPITALCODE = ? ";
- GOSIDebug.debugMessages("sqlQuery " +sqlQuery);
- ps = con.prepareStatement(sqlQuery);
- ps.setLong(1,hospitalCode.longValue());
- rs = ps .executeQuery();
- String hospitalName[] = new String[2];
- while(rs.next())
- {
- hospitalName[0] = rs.getString("HOSPITALNAMEARB");
- hospitalName[1] = rs.getString("HOSPITALNAMEENG");
- }
- return hospitalName;
- }
- catch(Exception e)
- {
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),
- "hospitalDetailsList()",
- e,"CMN_ERR_1000");
- }
- finally
- {
- GOSIUtilities.cleanUp(con,ps,rs);
- }
- }
- /**
- * @METHOD NAME : deleteApprovedTrmtSrvc
- * @INFORMATION : This method is to delete approved treatment services.
- * @PARAM : class java.lang.Long
- * @RETURN : void
- * @EXCEPTION : class gosi.core.util.GOSIException,
- class java.rmi.RemoteException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void deleteApprovedTrmtSrvc(Long recordId ) throws GOSIException
- {
- try
- {
- TreatmentServiceDetailEntityHome home = (TreatmentServiceDetailEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_DET_ENTITY_JNDI,
- TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntity detailRemote =
- (TreatmentServiceDetailEntity)home.findByPrimaryKey
- (recordId);
- detailRemote.remove();
- }
- catch(Exception e)
- {
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),"deleteApprovedTrmtSrvc()",e,"CMN_ERR_1000");
- }
- }
- /**
- * @METHOD NAME : deleteApprovedTrmtSrvc
- * @INFORMATION : This method is to delete approved treatment services.
- * @PARAM : class java.lang.Long
- * @RETURN : void
- * @EXCEPTION : class gosi.core.util.GOSIException,
- class java.rmi.RemoteException
- * @LAST MODIFIED BY :
- * @LAST MODIFIED DATE :
- **/
- public void deleteApprovedTrmtSrvc(Long recordId,Long userId ) throws GOSIException
- {
- try
- {
- TreatmentServiceDetailEntityHome home = (TreatmentServiceDetailEntityHome)
- ServiceLocator.getInstance().getRemoteHome(
- OHConstants.TRMT_SRVC_DET_ENTITY_JNDI,
- TreatmentServiceDetailEntityHome.class);
- TreatmentServiceDetailEntity detailRemote =
- (TreatmentServiceDetailEntity)home.findByPrimaryKey
- (recordId);
- TreatmentServiceBean treatmentServiceBean = detailRemote.getTreatmentService();
- treatmentServiceBean.setTrmtSrvcStatus(OHConstants.TRMT_SRVC_STS_CANCELLED);
- treatmentServiceBean.setPaymentStatus(OHConstants.TRMT_SRVC_PAY_STS_NOT_PAID);
- treatmentServiceBean.setLastModifiedBy(userId);
- detailRemote.modifyTreatmentServices(treatmentServiceBean);
- }
- catch(Exception e)
- {
- throw new GOSIException(GOSIConstants.SEVERITY_ONE,
- GOSIConstants.SOCIAL_INSURANCE,
- this.getClass().toString(),"deleteApprovedTrmtSrvc()",e,"CMN_ERR_1000");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement