<%@page language="java" %> <%@include file="staffsecurity.jsp" %> <%@page import= "java.util.Calendar"%> <%@page import= "java.util.HashMap"%> <%@page import= "java.util.Vector"%> <%@page import="java.sql.Connection"%> <%@page import="java.sql.ResultSet "%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.Driver"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.SQLException"%> <%@page import="geysers.utils.GeysersSiteConstants" %> <%@page import="geysers.utils.GeysersSiteUtilities" %> <%@page import="geysers.utils.GeysersSiteProperties" %> <%@page import="geysers.beans.om.StaffEntryInfo" %> <%@page import="geysers.ejb.om.ClaimServiceInfo" %> <%@page import="geysers.ejb.patient.SearchPatientInfo" %> <% Connection conn=null; try{ conn=GeysersSiteUtilities.getConnection(); String dosStr = "" ; String prinsnm = ""; String secinsnm = ""; //pr String prinsno = ""; //sec String secinsno = ""; %> <% String dos = request.getParameter("dosforfax"); session.setAttribute("dosforfax",dos); %> <%! //method made by kalpesh String formatCurrencyJSP(String cur){ int pos=cur.indexOf("."); String ret=""; if(pos==-1){ cur = cur + ".00"; } else{ cur = cur +"00"; } pos=cur.indexOf("."); ret = cur.substring(0,pos+3); return ret; } /*added by kalpesh as -ve can be rounded also*/ double round2Prec(double val){ if(val>0){ val=val+0.005; }else if(val<0){ val=val-0.005; } return val; } %> <%! boolean isclaimentered = false; %> <% String cid =""; String pid =""; String datefmmm =""; String datefmdd =""; String datefmyy =""; String datetomm =""; String datetodd =""; String datetoyy =""; String activeDIV = "insurancepayment"; String previousBalance = "0.00"; String insurancePayment = ""; String patientPayment =""; String creditAdjustment =""; String newBalance =""; String patient_nm=""; boolean fromSession=false; //String startinghdinsalamt=""; //String startinghdcopay=""; //String startingpamt=""; //String startingadjus=""; HashMap hashMap = (HashMap) session.getAttribute("paymentData"); if(request.getParameter("new") != null && request.getParameter("new").equalsIgnoreCase("Y")){ if(session.getAttribute("patientIdInSession") != null){ pid=(String)session.getAttribute("patientIdInSession"); if(session.getAttribute("claimIdInSession") != null){ cid=(String)session.getAttribute("claimIdInSession"); } if ( pid != null && (!pid.trim().equalsIgnoreCase(""))) { if(!(pid.equals("0"))) patient_nm=patientmanagerjbean.getPatientName(Integer.parseInt(pid)); } fromSession=true; } hashMap =null ; session.setAttribute("claimData",null); session.removeAttribute("claimdate"); } if (request.getParameter("saved") != null) { if(request.getParameter("saved").equalsIgnoreCase("Y")) { pid=(String)session.getAttribute("patientIdInSession"); } } // from direct search patient if(request.getParameter("pid") != null){ pid=request.getParameter("pid"); if ( pid != null && (!pid.trim().equalsIgnoreCase(""))) { if(!(pid.equals("0"))) patient_nm=patientmanagerjbean.getPatientName(Integer.parseInt(pid)); } }//if(request.getParameter("patientId") != null) //added by Gopi on 23-7-2004 if(request.getParameter("searchclaim") != null){ String ccc=request.getParameter("searchclaim"); if(!(ccc.equals(""))) { cid=ccc; int ccid=Integer.parseInt(ccc); try { Statement objStmt2 = null; ResultSet objRS2 = null; try { objStmt2 = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); String getpid = "select pid from claim where claimid = " + ccid+"and prid="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID; objRS2 = objStmt2.executeQuery(getpid); while(objRS2.next()){ pid = objRS2.getString(1); } }catch (SQLException se) { se.printStackTrace(); } finally { try { if (objRS2 != null){ objRS2.close();objRS2=null;} if(objStmt2 != null){ objStmt2.close();objStmt2=null;} } catch(SQLException se){ se.printStackTrace(); } } } catch(Exception ee) {} } if(pid.equals("")){ pid="0"; } } if(hashMap ==null){ hashMap = new HashMap(); hashMap.put("vctClaims",new Vector ()); session.setAttribute("paymentData",hashMap); }else if(pid.equalsIgnoreCase("")){ pid = (String)hashMap.get("pid"); cid = (String)hashMap.get("cid"); if(pid==null){ pid =""; patient_nm=""; } else{ datefmmm = (String)hashMap.get("datefmmm"); datefmdd = (String)hashMap.get("datefmdd"); datefmyy = (String)hashMap.get("datefmyy"); datetomm = (String)hashMap.get("datetomm"); datetodd = (String)hashMap.get("datetodd"); datetoyy = (String)hashMap.get("datetoyy"); activeDIV= (String)hashMap.get("activeDIV"); previousBalance= (String)hashMap.get("previousBalance"); insurancePayment= (String)hashMap.get("insurancePayment"); patientPayment= (String)hashMap.get("patientPayment"); creditAdjustment= (String)hashMap.get("creditAdjustment"); newBalance= (String)hashMap.get("newBalance"); patient_nm= (String)hashMap.get("hdpatient_nm"); } } Vector vctClaims = (Vector)hashMap.get("vctClaims"); Vector vctClaimsNew = new Vector(0); int claimmatchcounter = 0; if (pid != null || pid != "") { int vctsize=vctClaims.size(); for (int cnt=0; cnt <%@include file="payment/paymentlineitemvars_inc.jsp" %> <% if (cid.trim().equalsIgnoreCase(claimid.trim())) { vctClaimsNew.addElement(vctClaims.elementAt(cnt)); claimmatchcounter++; //vctClaims = vctClaimsNew; //isclaimentered = true; } } } if (cid == null || cid.trim().equalsIgnoreCase("")) { isclaimentered = false; }else { isclaimentered = true; } if (isclaimentered) { vctClaims = vctClaimsNew; if (hashMap != null) { hashMap.put("vctClaims",vctClaims); } } if(activeDIV.equals("")){ activeDIV = "insurancepayment"; } %> <% if ( pid != null && (!pid.trim().equalsIgnoreCase(""))) { if(!(pid.equals("0"))) patient_nm = patientmanagerjbean.getPatientName(Integer.parseInt(pid)); } //PatientDemographicInfo pdi = new PatientDemographicInfo(); String BLNINS="1"; if ( pid != null && (!pid.trim().equalsIgnoreCase(""))) { BLNINS =patientmanagerjbean.getPatientBlnins(Integer.parseInt(pid))+""; } if(BLNINS == null || (BLNINS.trim()).equalsIgnoreCase("")){ BLNINS="1"; } if(BLNINS.equals("1")){ activeDIV = "insurancepayment"; }else{ activeDIV = "creditadjustment"; } %> <%= GeysersSiteConstants.TITLE_PAYMENT_FORM%> <% String headerpage ="staffheader.jsp?usertype="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UTYPE; %> <% String menupage ="staffmenu.jsp?menutype="+((StaffEntryInfo)session.getAttribute("staffEntryInfo")).UTYPE;%>
<%if(pid!=null && !pid.equals("")) {%> <%}%> <% if(request.getParameter("saved") !=null ){ %> <% } %>
 
Demographics    <% Vector data=patientmanagerjbean.getPatientSearchResults(((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID,Integer.parseInt(pid),0,"","","","","","",null,"","pfnm"); if(data!=null){ if(data.size()>0){ if(data!=null && ((SearchPatientInfo)(data.elementAt(0))).status.equalsIgnoreCase(GeysersSiteConstants.STATUS_ACTIVE)){%> Claim    Transactions   <%}}}%> Questionnaire
   Your Information has been saved.  
 
<%if (cid != null || !(cid.trim().equalsIgnoreCase(""))) {%> <%} else {%> <% } %> <% //System.outprintln("Patient id befire displaying in text box is %$&^" + pid);%> <% if (!(pid == null || pid.trim().equalsIgnoreCase(""))) { %> <% session.setAttribute("pid2",pid); %> <% Statement objStmt2 = null; ResultSet objRS2 = null; try { objStmt2 = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); String getfaxid = "select pinsno from com_pdet where pid = " + pid; objRS2 = objStmt2.executeQuery(getfaxid); while(objRS2.next()){ prinsno = objRS2.getString(1); } if(prinsno == null || prinsno == "") session.setAttribute("hidesecondary","YES"); else session.setAttribute("hidesecondary","NO"); if(prinsno != null){ if(prinsno.length() > 1){ objRS2 = objStmt2.executeQuery("select insnm from ins_prac where insno = " + prinsno); while(objRS2.next()){ prinsnm = objRS2.getString(1); //if(prinsnm == null) prinsnm = ""; //session.setAttribute("secondary",prinsnm); //System.out.println("patient primary ins. name.." + prinsnm); } if(prinsnm == null) prinsnm = ""; } } ///secondary String getsec = "select pinsno1 from com_pdet where pid = " + pid; objRS2 = objStmt2.executeQuery(getsec); while(objRS2.next()){ secinsno = objRS2.getString(1); } if(secinsno != null){ if(secinsno.length() > 1){ objRS2 = objStmt2.executeQuery("select insnm from ins_prac where insno = " + secinsno); while(objRS2.next()){ secinsnm = objRS2.getString(1); if(secinsnm == null) secinsnm = ""; //System.out.println("patient secondary ins. name.." + secinsnm); } } } /// }catch (SQLException se) { se.printStackTrace(); } finally { try { if (objRS2 != null){ objRS2.close();objRS2=null;} if(objStmt2 != null) {objStmt2.close();objStmt2=null;} } catch(SQLException se){ se.printStackTrace(); } } %> <% if(pid!=null){ if(pid.equals("") || pid.equals("0")){ pid="0"; } } %> <% String ipid=request.getParameter("pid"); if(ipid== null || ipid.equalsIgnoreCase("")){ ipid=(String)session.getAttribute("patientIdInSession"); } if(pid== null || pid.equalsIgnoreCase("")){ pid="0"; } //System.outprintln("payment.jsp : pid%^%^ :"+ipid); double x = billingManagerJBean.getOutstandingCredits(((StaffEntryInfo)session.getAttribute("staffEntryInfo")).PRID,Integer.parseInt(pid)); String credits = formatCurrencyJSP(String.valueOf(round2Prec(x))); session.setAttribute("pidforcredit",pid); //System.out.println("payment.jsp : credit :"+credits); %> > <% if(fromSession || request.getParameter("pid") != null){ %> <% } %>

Patient Name:   Outstanding Claim Amount:  
Claim ID:   Insurance Allowed Amount:  
Patient ID:     <% //System.outprintln("pid iffffff "); } else { %>   <% //System.outprintln("pid elseeeeee "); } %> Insurance Payment:  
Charge Date Range  
From:
  
Patient Payments:  
To:   Credit Adjustments:  
  Balance Due:  
Patient Credit  
Type Of Transaction:   name="trantype" onClick="changeDiv('insurancepayment');setBalDue(this.form);">Insurance Payment
name="trantype" onClick="changeDiv('creditadjustment');setBalDue(this.form);">Credit Adjustment/Patient Payment
name="trantype" onClick="changeDiv('addinformation');setBalDue(this.form);">Add Information
<% if (isclaimentered && claimmatchcounter == 0) { %> <% } else if(vctClaims.size() == 0){ %> <% }else{ %> "> <% int vcsize=vctClaims.size(); for(int cnt=0;cnt <%@include file="payment/paymentlineitemvars_inc.jsp"%> <% if(csi.default1!=00) { //startingdefault1="0.00"; if(creditAdjustment==null || creditAdjustment.equals("")) { creditAdjustment=formatCurrencyJSP(csi.default1+""); } else { creditAdjustment=formatCurrencyJSP((Float.parseFloat(creditAdjustment)+csi.default1)+""); } } %> <% dosStr = trandatemm + "/" + trandatedd + "/" + trandateyy; %> <% }//end of for i
 
Claim No  Line Item No  Date   CPT  Claim Amount  Balance Due  Line Item Status       
 
Specified Claim Id does not exist for the specified Patient <%=GeysersSiteUtilities.getSpaces(150)%>  
Retrieve Line Item Postings <%=GeysersSiteUtilities.getSpaces(150)%>  
                        >      &patientname=<%=patient_nm%>&cptcd=<%=cptcd%>&claimid=<%=claimid%>&claimServiceId=<%=claimServiceId%>&cnt=<%=cnt%>&lstat=<%=lstat%>','Image')">
 
For Claim No and Line Item No Allowed Amount per Contract
Rendering Physician Production Physician
         '"> <% if(prinsnm != null){ if(prinsnm.length() > 1){ %> <% } } %>
<% } catch(Exception exc){ }finally{ try{ if(conn!=null){conn.close();conn=null;} }catch(Exception dd){} } %>