<%@page language="java" %> <%@page import="geysers.utils.GeysersSiteConstants" %> <%@page import="geysers.utils.GeysersSiteUtilities" %> <%@page import="geysers.utils.GeysersSiteProperties" %> <%@page import="geysers.beans.om.StaffEntryInfo" %> <%@include file="staffsecurity.jsp" %> <%@page import="java.util.Hashtable"%> <%@page import="geysers.beans.om.PracticeInfo" %> <%@page import="geysers.beans.om.PracticeManagerJBean" %> <%@page import="java.util.Calendar" %> <%@page import="java.util.GregorianCalendar" %> <%@page import="geysers.ejb.patient.PatientAppointmentInfo" %> <%@page import="geysers.ejb.patient.PhysicianAppointmentInfo" %> <%@page import="geysers.ejb.om.ClaimInfo" %> <%@page import="geysers.beans.om.LocationInfo" %> <%@page import="geysers.ejb.om.ClaimServiceInfo" %> <%@page import="geysers.ejb.patient.*" %> <%@page import="java.sql.*"%> <%@page import="java.util.*"%> <%@page import="geysers.utils.CP" %> <% Connection conn=null; try{ conn=GeysersSiteUtilities.getConnection(); String REFERING_PROVIDER = ""; String SUPERVISING_PROVIDER = ""; String ORDERING_PROVIDER = ""; int pdoid=0; //added by Gopi on 6-4-2005 String online=""; String offline=""; String wtype=""; String feetype=""; String noproc=""; String trinsnm=""; String claimstatusinsession = request.getParameter("status"); session.setAttribute("claimstatusinsession",claimstatusinsession); %> <% if(session.getAttribute("ClaimForDayInput")!=null && request.getParameter("saved")!=null) { response.sendRedirect("SearchClaimsForTheDay.jsp"); return; } else if(request.getParameter("claimsfortheday")==null) { if(session.getAttribute("ClaimForDayInput")!=null){ session.setAttribute("ClaimForDayInput",null); } } //added by Gopi on 4-12-2004 int pracii = ((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID; java.util.Vector data1=new java.util.Vector(); data1=staffmanagerJBean.getProvider(pracii); StringBuffer stBuff1 = new StringBuffer(); String arr1[] = new String[2]; int data1size=data1.size(); for(int j=0;j"+arr1[1]+""); } data1.clear(); //added by Gopi on 18-6-2004 String claimattach="false"; session.setAttribute("claimattach",claimattach); //added by Gopi on 17-9-2004 session.removeAttribute("claimtransport"); session.removeAttribute("claimdmehash"); session.removeAttribute("homeoxygen"); session.removeAttribute("PatientDemoDetail"); session.removeAttribute("patientattachdetail"); session.removeAttribute("DmeInsurance"); session.removeAttribute("TertiaryDetails"); session.removeAttribute("PatientDemoModifyDetail"); session.removeAttribute("nonDisplayFormat"); session.removeAttribute("TertiaryDetails"); session.removeAttribute("patientattachdetail"); session.removeAttribute("DmeInsuranceModify"); session.removeAttribute("DMECert"); session.removeAttribute("DMEQuest"); int claimId = 0; //String isRefreshed = request.getParameter("isRefreshed"); //if( isRefreshed != null ){ %> <% if(request.getParameter("new") != null && request.getParameter("new").equalsIgnoreCase("Y")){ REFERING_PROVIDER = ""; SUPERVISING_PROVIDER = ""; ORDERING_PROVIDER = ""; //added by Gopi on 18-6-2004 session.removeAttribute("claimattachdetail"); }else{ REFERING_PROVIDER = (String)session.getAttribute("reffphysician"); SUPERVISING_PROVIDER = (String)session.getAttribute("supervisingphysician"); ORDERING_PROVIDER = (String)session.getAttribute("ordphysician"); } String fileref=""; String patelig=""; int trinsno=0; %> <% String claimidfrommodify = request.getParameter("claimId"); if(claimidfrommodify != null){ if(claimidfrommodify.length() > 1){ ResultSet objRS = null; Statement objStatement = null; //Connection objConnection=null; try { objStatement = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); conn.setAutoCommit(false); String strQuery = "select e.REFERING_PROVIDER,e.SUPERVISING_PROVIDER,e.ORDERING_PROVIDER,c.fileref1,c.nproc from claim_extension e,claim c" + " where c.claimid=e.claimid and c.claimid = " + claimidfrommodify; objRS = objStatement.executeQuery(strQuery); if(objRS.next()){ //superbillID = objRS.getString(1); REFERING_PROVIDER = objRS.getString(1); SUPERVISING_PROVIDER = objRS.getString(2); ORDERING_PROVIDER = objRS.getString(3); if(objRS.getString(4)!=null){ fileref=objRS.getString(4); } if(objRS.getString(5)!=null){ noproc=objRS.getString(5); } } }catch(Exception e){e.printStackTrace();} finally { try { if (objRS != null){ objRS.close();objRS=null;} if(objStatement != null) {objStatement.close();objStatement=null;} } catch(SQLException se){ se.printStackTrace(); } } } } %> <% String pid=""; String patient_nm=""; String phyName=""; String doid=""; String locid=""; int prid=0; String prName=""; int prInsId=0; String prInsNm=""; int secInsId=0; String secInsNm=""; String physicianName=""; String rccode=""; String ccode=""; //DMENeed added by satheesh 0n 30/01/2007 String DMENeed="NA"; //NA --> NOt Applicable & A --> Applicable %> <% // from direct search patient if(request.getParameter("pid") != null){ pid=request.getParameter("pid"); //patient_nm=request.getParameter("patientName"); patient_nm=patientmanagerjbean.getPatientName(Integer.parseInt(pid)); //Added by satheesh for DMENeed Check on 30/01/2007 Connection conDME=null; Statement stDME=null; ResultSet rsDME=null; String dmeChk=""; try { conDME=GeysersSiteUtilities.getConnection(); stDME = conDME.createStatement(); String qry="select distinct c.clearinghouse as CLRHOUSE,nvl(a.patelig,'Y') as patelig from com_pdet a,ins_prac c where a.pinsno1=C.INSNO AND a.pid="+Integer.parseInt(pid); rsDME=stDME.executeQuery(qry); while(rsDME.next()) { if(rsDME.getString("CLRHOUSE")!=null && (rsDME.getString("CLRHOUSE").equals("DMERC"))){ DMENeed="A"; } if(rsDME.getString("patelig")!=null){ patelig=rsDME.getString("patelig"); } } }catch(Exception e) { System.out.println("error : "+e); }finally{ try{ if(rsDME != null) rsDME.close(); if(stDME != null) stDME.close(); if(conDME!=null)conDME.close(); }catch(Exception f){} } //displayPatientId } %> <% String dosCFD = request.getParameter("dos"); String isClaimsFortheDayCFD = request.getParameter("claimsfortheday"); if(isClaimsFortheDayCFD!=null && isClaimsFortheDayCFD.equals("true")){ fileref="Electronic SB"; } System.out.println("patelig**"+patelig); %> <% Hashtable hashTable =null; String modify=request.getParameter("status"); session.setAttribute("claimstatus",modify); if(request.getParameter("new") != null && request.getParameter("new").equalsIgnoreCase("Y")){ hashTable = null; session.setAttribute("newclaim","Y"); //by Ramesh for additional claim info page. //if(request.getParameter("pid") != null) //commented by Gopi on 2-7-2004 /*if(session.getAttribute("patientIdInSession") != null){ pid=(String)session.getAttribute("patientIdInSession"); patient_nm=patientmanagerjbean.getPatientName(Integer.parseInt(pid)); } */ session.removeAttribute("claimData"); session.setAttribute("claimData",null); //added by Gopi on 18-6-2004 session.removeAttribute("claimattach"); session.removeAttribute("modifyclaimId"); } else{ //session.setAttribute("newclaim","N"); //by Ramesh for additional claim info page. hashTable = (Hashtable)session.getAttribute("claimData"); if ( hashTable != null){ rccode = (String)hashTable.get("rccode"); ccode = (String)hashTable.get("ccode"); if(hashTable.get("pdoid")!=null) { pdoid=Integer.parseInt((String)hashTable.get("pdoid")); } } } if (hashTable == null){ hashTable = new Hashtable(); } ClaimInfo claiminfo =null; if(modify!=null && modify.equalsIgnoreCase(GeysersSiteConstants.STATUS_MODIFY)){ //added by Gopi on 18-6-2004 claimattach="true"; session.setAttribute("claimattach",claimattach); session.setAttribute("newclaim","N"); //by Ramesh for additional claim info page. //int claimId = 0; //if(request.getParameter("claimId") != null){ claimId=Integer.parseInt(request.getParameter("claimId")); //} session.setAttribute("modifyclaimId",claimId+""); if(claimId!=0){ claiminfo =billingmanagerjbean.getClaimInfo(claimId); if ( claiminfo.CCODE != null){ ccode = claiminfo.CCODE ; } if ( claiminfo.RCCODE != null){ rccode = claiminfo.RCCODE ; } //if (claiminfo.pdoId != null){ pdoid = claiminfo.pdoId; // } //added by Gopi on 15-7-2004 if(claiminfo.diag5==null){} //doid=(new Integer(claiminfo.doId)).toString(); //locid=(new Integer(claiminfo.locId)).toString(); if(claiminfo== null){ response.sendRedirect("error.jsp?loginstatus="+GeysersSiteConstants.AFTER_LOGIN+"&usertype="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UTYPE+"&message="+GeysersSiteConstants.ERROR_MESSAGE_CLAIM_DOES_NOT_EXIST+"&menutype="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UTYPE+"&username="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UNME); return; } //added by Gopi on 6-4-2005 if ( claiminfo.OFFLINEMESS != null){ offline = claiminfo.OFFLINEMESS ; } if ( claiminfo.ONLINEMESS != null){ online = claiminfo.ONLINEMESS ; } Vector claimServices = billingmanagerjbean.getClaimServices(claimId); int cnt=1; for(cnt=1;cnt<=claimServices.size();cnt++){ ClaimServiceInfo serviceInfo = (ClaimServiceInfo)claimServices.elementAt(cnt-1); hashTable.put("ClaimServiceInfo"+cnt,serviceInfo); } int remaning = GeysersSiteConstants.TOTAL_NO_OF_CLAIM_DETAIL_ROWS-claimServices.size(); if(remaning !=0){ for(int i=0;i <%@ include file="billing/modifyclaimservicedetailsvars.jsp" %> <% }//if(claimId!=0) } String nextPage = request.getParameter("nextPage"); if(nextPage==null||nextPage.equals("")){ nextPage = "confirmclaimservicedetails.jsp"; } if(request.getParameter("claimsfortheday") != null){ if(request.getParameter("claimsfortheday").length() > 1){ hashTable = null; } } if(hashTable != null){ if((String)hashTable.get("pid") != null){ pid=(String)hashTable.get("pid"); } if((String)hashTable.get("patient_nm") != null){ patient_nm=(String)hashTable.get("patient_nm"); } if((String)hashTable.get("phyName") != null){ phyName=(String)hashTable.get("phyName"); } if((String)hashTable.get("doid") != null){ doid=(String)hashTable.get("doid"); } if((String)hashTable.get("locid") != null){ locid=(String)hashTable.get("locid"); } prid=((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID; } prid=((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID; String pUserType=GeysersSiteConstants.USER_TYPE_OM; //added for modify %> <% String menupage ="staffmenu.jsp?menutype="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UTYPE; %> <% if(!(locid.equals("")) && !(locid.equals("0"))){ Statement wstmt=null; ResultSet wrs=null; try{ wstmt=conn.createStatement(); wrs=wstmt.executeQuery("select wtype,feetype from com_linf where oid="+Integer.parseInt(locid)); while(wrs.next()){ if(wrs.getString("wtype")!=null){ wtype=wrs.getString("wtype"); } if(wrs.getString("feetype")!=null){ feetype=wrs.getString("feetype"); } } }catch(Exception ff){} finally{ try{ if(wstmt!=null)wstmt.close(); if(wrs!=null)wrs.close(); }catch(Exception f){} } } %> <% String headerpage ="staffheader.jsp?usertype="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UTYPE; %>

<% String linkspage ="staffleftlinks.jsp?loginstatus="+GeysersSiteConstants.AFTER_LOGIN; %> <%if(pid!=null && !pid.equals("")) {%> <%}%> <% if(request.getParameter("saved") !=null ){ String newclaimid=request.getParameter("newclaimid"); %> <% } %>   Demographics    Payment    Transactions    Questionnaire      <% if(claimattach.equals("true")) { String cid=(String)request.getParameter("claimId"); session.setAttribute("claimidat",cid); %> Attachment    <% } %>    Your Information has been saved. Claimid - <%=newclaimid%>   <% // get error messages from confirmcreatepractice.jsp java.util.Vector errors=(java.util.Vector)pageContext.getAttribute("errors", PageContext.REQUEST_SCOPE); if(errors!=null) { out.println(" "); for(int i=0;i" + errors.elementAt(i)); } out.println(" "); } %>   <% if((modify!=null) &&modify.equalsIgnoreCase(GeysersSiteConstants.STATUS_MODIFY) ){ %> <%}else{ %> <%}%>     <%= GeysersSiteConstants.MANDATORY_STRING %> Practice Name:   <%= practicemanagerjbean.getPracticeName(((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID)%> Patient Name*:   Patient ID*:   <% if(pid.equalsIgnoreCase("0")){ pid=""; }%> Rendering Physician/Provider Name:*:   Select One<%=GeysersSiteUtilities.getSpaces(40)%> Rendering Physician/Provider Id:*:   <% if(doid.equalsIgnoreCase("0")){ doid=""; }%> Location:*:   Select One<%=GeysersSiteUtilities.getSpaces(40)%> Primary Insurance:   <% if(prInsNm == null){ prInsNm=""; } %> <%=prInsNm%> Secondary Insurance:   <% if(secInsNm== null){ secInsNm=""; } %> <%=secInsNm%> Teritary Insurance:   <% if(trinsnm == null){ trinsnm=""; } %> <%=trinsnm%> Country Code:   <% if(ccode != null){ if(ccode.trim().equals("null") || ccode == "null") ccode = ""; } else ccode = ""; %> File Ref No :   <% if(fileref != null){ if(fileref.trim().equals("null") || fileref == "null") fileref = ""; } else fileref = ""; %> Production Physician/Provider*:   Select One<%=GeysersSiteUtilities.getSpaces(40)%> Referring Physician/Provider:   Select One<%=GeysersSiteUtilities.getSpaces(40)%> <%= stBuff1.toString()%> Ordering Physician/Provider:   Select One<%=GeysersSiteUtilities.getSpaces(40)%> Supervising Physician/Provider:   Select One<%=GeysersSiteUtilities.getSpaces(40)%>     '"> > > > <% String loginSt = "footer.jsp?loginstatus="+GeysersSiteConstants.AFTER_LOGIN;%>

<% //}//end of if isRefreshed //else{ // response.sendRedirect("createclaim.jsp?new=Y"); //} /* 10/31,10/17,10/3,9/19,9/5,8/22,8/8 */ }catch(Exception gg){} finally{ try{ if(conn!=null)conn.close(); }catch(Exception fG){} } %>