Participating Churches

<% catMediaDisp.createCatMediaDisp(catalogId, catSecCd, subCatSecCd, subSubCatSecCd, out, conn, "categoryAdText","BODY",sc); %>

<% try{ String sortBy = request.getParameter("sortBy") !=null ? request.getParameter("sortBy") :"statecity"; String distsortBy = request.getParameter("distsortBy") !=null ? request.getParameter("distsortBy") :"statecity"; TreeMap rndzvUsers = (TreeMap)session.getAttribute("rndzvUsers"); TreeMap rndzvUsersByPastor = (TreeMap)session.getAttribute("rndzvUsersByPastor"); TreeMap rndzvDistricts = (TreeMap)session.getAttribute("rndzvDistricts"); TreeMap rndzvDistrictsByDS = (TreeMap)session.getAttribute("rndzvDistrictsByDS"); boolean firstTime = false; if ((sortBy.equals("statecity") && rndzvUsers == null) || (sortBy.equals("pastor") && rndzvUsersByPastor == null)){ firstTime = true; Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs = stmt.executeQuery("select * from live.mlpersonchurchv8t where mlist_cd = 585"); rndzvUsers = new TreeMap(); rndzvUsersByPastor = new TreeMap(); rndzvDistricts = new TreeMap(); rndzvDistrictsByDS = new TreeMap(); while(rs.next()){ String pastorName = rs.getString("pastor_name") != null ? rs.getString("pastor_name").trim() :" "; String pastorNameB = rs.getString("pastor_name") != null ? rs.getString("pastor_name").trim() :" "; String pastorName1 = rs.getString("pastor_name") != null ? rs.getString("pastor_name").trim() :" "; String pastorName2 = ""; String pastorName3 = ""; while(pastorName1.indexOf(" ")>0){ int pos = pastorName1.indexOf(" "); int len = pastorName1.length(); if (pastorName2.compareTo(" ")>0) pastorName2 += " " + pastorName1.substring(0,pos); else pastorName2 += pastorName1.substring(0,pos); pastorName1 = pastorName1.substring(pos,len).trim(); } if(pastorName1.trim().toLowerCase().equals("jr") || pastorName1.trim().toLowerCase().equals("jr.") || pastorName1.trim().toLowerCase().equals("sr") || pastorName1.trim().toLowerCase().equals("sr.") || pastorName1.trim().toLowerCase().equals("ii") || pastorName1.trim().toLowerCase().equals("iii")){ while (pastorName2.indexOf(" ")>0){ int pos2 = pastorName2.indexOf(" "); int len2 = pastorName2.length(); if (pastorName3.compareTo(" ")>0) pastorName3 += " " + pastorName2.substring(0,pos2); else pastorName3 += pastorName2.substring(0,pos2); pastorName2 = pastorName2.substring(pos2,len2).trim(); } pastorName = pastorName2.trim() +", "+ pastorName3.trim() +" "+ pastorName1.trim(); } else if (pastorName.compareTo(" ")>0 ) pastorName = pastorName1.trim() +", "+ pastorName2.trim(); if(rs.getString("church_name").toLowerCase().indexOf(" dist")>0 || rs.getString("church_name").toLowerCase().indexOf(" district")>0){ String churchArray[] = new String[3]; String churchName = rs.getString("church_name")!=null? rs.getString("church_name").trim() :""; String churchName2 = ""; StringTokenizer churchTokens = new StringTokenizer(churchName, " "); boolean firstToken = true; for (int r = 0; churchTokens.hasMoreTokens(); r++) { String sTokens = churchTokens.nextToken(); if (sTokens.trim().toLowerCase().compareTo("dist") != 0 && sTokens.trim().toLowerCase().compareTo("office") != 0 && sTokens.trim().toLowerCase().compareTo("district") != 0){ if (firstToken){ churchName2 += sTokens.trim(); firstToken=false; } else churchName2 += " "+ sTokens.trim(); } } String city = rs.getString("City")!= null? rs.getString("City").trim() :""; String state = rs.getString("State")!= null? rs.getString("State").trim() :""; String subCountry = rs.getString("Sub_country")!= null? rs.getString("Sub_country").trim() :""; String country = rs.getString("Country_name")!= null? rs.getString("Country_name").trim() :""; if(country.compareTo(" ")<=0) country = ""; String CityLine = city + ", " + state; if (state.compareTo(" ")<= 0){ if (subCountry.compareTo(" ")>0 ) CityLine = city+ ", "+subCountry+ " " +country; else if (country.compareTo(" ")> 0) CityLine = city+ ", " +country ; else CityLine = city ; } churchArray[0] = churchName2; churchArray[1] = pastorNameB; churchArray[2] = CityLine; String key = state+city+churchArray[0].trim(); if (state.compareTo("")<=0) key = "zzzzzzzzzzzz"+state+ city +churchArray[0].trim(); rndzvDistricts.put(key,churchArray); String keyDS =pastorName+state+city+churchArray[0]; if(pastorName.compareTo(" ")<=0) keyDS ="zzzzzzzzzzzz"+churchArray[0]; rndzvDistrictsByDS.put(keyDS,churchArray); }else{ String churchArray[] = new String[3]; String city = rs.getString("City")!= null? rs.getString("City").trim() :""; String state = rs.getString("State")!= null? rs.getString("State").trim() :""; String subCountry = rs.getString("Sub_country")!= null? rs.getString("Sub_country").trim() :""; String country = rs.getString("Country_name")!= null? rs.getString("Country_name").trim() :""; if(country.compareTo(" ")<=0) country = ""; String CityLine = city + ", " + state; if (state.compareTo(" ")<= 0){ if (subCountry.compareTo(" ")>0 ) CityLine = city+ ", "+subCountry+ " " +country; else if (country.compareTo(" ")> 0) CityLine = city+ ", " +country ; else CityLine = city ; } churchArray[0] = rs.getString("church_name")!=null? rs.getString("church_name").trim() :""; churchArray[1] = pastorNameB; churchArray[2] = CityLine; String key = state+ city +churchArray[0].trim(); if (state.compareTo("")<=0) key = "zzzzzzzzzzzz"+state+ city +churchArray[0].trim(); rndzvUsers.put(key,churchArray); String keyPastor =pastorName+state+ city+churchArray[0]; if(pastorName.compareTo(" ")<=0) keyPastor ="zzzzzzzzzzzz"+pastorName+state+city+churchArray[0]; rndzvUsersByPastor.put(keyPastor,churchArray); } } rs.close(); stmt.close(); } //Change the keys to be numbers. if (firstTime){ TreeMap rndzvDistricts2 = new TreeMap(); TreeMap rndzvDistrictsByDS2 = new TreeMap(); Set sd = rndzvDistricts.entrySet(); Iterator eDist = sd.iterator(); int count = 0; while (eDist.hasNext()){ Map.Entry me = (Map.Entry)eDist.next(); String key = (String)me.getKey(); String[] distArray = (String[]) rndzvDistricts.get(key); rndzvDistricts2.put(new Integer(count),distArray); count++; } rndzvDistricts = rndzvDistricts2; count=0; Set sds = rndzvDistrictsByDS.entrySet(); Iterator eDistDs = sds.iterator(); while (eDistDs.hasNext()){ Map.Entry me = (Map.Entry)eDistDs.next(); String key = (String)me.getKey(); String[] distArray2 = (String[]) rndzvDistrictsByDS.get(key); rndzvDistrictsByDS2.put(new Integer(count),distArray2); count++; } rndzvDistrictsByDS = rndzvDistrictsByDS2; TreeMap rndzvUsers2 = new TreeMap(); TreeMap rndzvUsersByPastor2 = new TreeMap(); count = 0; Set s = rndzvUsers.entrySet(); Iterator e = s.iterator(); while (e.hasNext()){ Map.Entry me = (Map.Entry)e.next(); String key = (String)me.getKey(); String[] churcharray = (String[]) rndzvUsers.get(key); rndzvUsers2.put(new Integer(count),churcharray); count++; } rndzvUsers = rndzvUsers2; count=0; Set sp = rndzvUsersByPastor.entrySet(); Iterator ee = sp.iterator(); while (ee.hasNext()){ Map.Entry me = (Map.Entry)ee.next(); String key = (String)me.getKey(); String[] pastorArray = (String[]) rndzvUsersByPastor.get(key); rndzvUsersByPastor2.put(new Integer(count),pastorArray); count++; } rndzvUsersByPastor = rndzvUsersByPastor2; } session.setAttribute("rndzvDistricts",rndzvDistricts); session.setAttribute("rndzvDistrictsByDS",rndzvDistrictsByDS); session.setAttribute("rndzvUsers",rndzvUsers); session.setAttribute("rndzvUsersByPastor",rndzvUsersByPastor); TreeMap ds = distsortBy.equals("statecity")?(TreeMap)session.getAttribute("rndzvDistricts"): (TreeMap)session.getAttribute("rndzvDistrictsByDS"); TreeMap rndzv = sortBy.equals("statecity")?(TreeMap)session.getAttribute("rndzvUsers"): (TreeMap)session.getAttribute("rndzvUsersByPastor"); int r_distPageNbr = request.getParameter("distPageNbr")!=null?Integer.parseInt(request.getParameter("distPageNbr")):1; int r_searchPageNbr = request.getParameter("searchPageNbr")!=null?Integer.parseInt(request.getParameter("searchPageNbr")):1; if (ds.size()>0 && (r_distPageNbr > 1 || ( r_distPageNbr==1 && r_searchPageNbr == 1))) { %><% }else if(rndzv.size()>0 && r_searchPageNbr > 1){ %><% }else if (ds.size()==0 && rndzv.size()==0) {%> <% } if (r_searchPageNbr <= 1 && !ds.isEmpty()) { String dsSelect = distsortBy.equals("ds") ? "checked":""; String placeSelect = distsortBy.equals("statecity") ? "checked":""; int p_nextDistPage = r_distPageNbr +1; int p_previousDistPage = r_distPageNbr>1 ? r_distPageNbr-1 : 1; int p_maxDistPages = 10; int maxDistRowsPerPage = 15;%> <% String p_moreResults1 = ""; String p_moreResults2 = ""; int totalRows = ds.size(); int startRow = r_distPageNbr == 1 ? 1: ((r_distPageNbr -1) * maxDistRowsPerPage)+1; if (totalRows > maxDistRowsPerPage){ String p_commonValues = "&distsortBy="+distsortBy+"&sortBy="+sortBy; int p_totalDistPages = totalRows / maxDistRowsPerPage ; if((totalRows % maxDistRowsPerPage) >0 ) p_totalDistPages++; int endRow = (startRow + maxDistRowsPerPage -1); if (endRow > totalRows) endRow = totalRows; p_moreResults1 = startRow + "-" + endRow + " of " + totalRows; p_moreResults2 = "More Results"; if(r_distPageNbr > 1){ p_moreResults2 = p_moreResults2 + "" + "" + ""; p_moreResults2 = p_moreResults2 + "" + ""; } int p_count = 1; for(int p_count2 = ((r_distPageNbr - 1) / p_maxDistPages) * p_maxDistPages + 1; p_count2 <= p_totalDistPages && p_count <= p_maxDistPages; p_count2++){ p_moreResults2 = p_moreResults2 + "" + p_count2 + " "; p_count++; } if(r_distPageNbr < p_totalDistPages){ p_moreResults2 = p_moreResults2 + "" + ""; p_moreResults2 = p_moreResults2 + "" + "" + " "; } %> <% } int count = 0; while(count < maxDistRowsPerPage && (((r_distPageNbr-1)* maxDistRowsPerPage ) +1+ count) <= ds.size() ){ String[] nextChurch = (String[])ds.get(new Integer((r_distPageNbr-1)* maxDistRowsPerPage + count)); String church = nextChurch[0]; String pastor = nextChurch[1]; String CityLine = nextChurch[2]; if (distsortBy.equals("statecity")){%> <% }else{%> <% }%> <% count++; }%> <% } if (r_distPageNbr <= 1 && !rndzv.isEmpty()) { String pastorSelect = sortBy.equals("pastor") ? "checked":""; String statecitySelect = sortBy.equals("statecity") ? "checked":""; int p_nextSearchPage = r_searchPageNbr +1; int p_previousSearchPage = r_searchPageNbr > 1? r_searchPageNbr -1:1; int p_maxPageOfferings = 10; int maxRowsPerPage = 12;%> Click here to see Churches Participating in Rendezvous Click here to see Nazarene Districts Participating in Rendezvous Coming soon... Nazarene Districts Sort by: >State and City >Superintendent <%=p_moreResults1%> <%=p_moreResults2%> <%=church%> <%=CityLine%> <%=pastor%> <%=pastor%> <%=church%> <%=CityLine%> <%=p_moreResults1%> <%=p_moreResults2%> <% String p_moreResults1 = ""; String p_moreResults2 = ""; int totalRows = rndzv.size(); int startRow = r_searchPageNbr == 1 ? 1: ((r_searchPageNbr -1) * maxRowsPerPage)+1; if (totalRows > maxRowsPerPage){ String p_commonValuesChurch = "&distsortBy="+distsortBy+"&sortBy="+sortBy+"#churches"; int p_totalPages = totalRows / maxRowsPerPage ; if((totalRows % maxRowsPerPage) >0 ) p_totalPages++; int endRow = (startRow + maxRowsPerPage -1); if (endRow > totalRows) endRow = totalRows; p_moreResults1 = startRow + "-" + endRow + " of " + totalRows; p_moreResults2 = "More Results"; if(r_searchPageNbr > 1){ p_moreResults2 = p_moreResults2 + "" + "" + ""; p_moreResults2 = p_moreResults2 + "" + ""; } int p_count = 1; for(int p_count2 = ((r_searchPageNbr - 1) / p_maxPageOfferings) * p_maxPageOfferings + 1; p_count2 <= p_totalPages && p_count <= p_maxPageOfferings; p_count2++){ p_moreResults2 = p_moreResults2 + "" + p_count2 + " "; p_count++; } if(r_searchPageNbr < p_totalPages){ p_moreResults2 = p_moreResults2 + "" + ""; p_moreResults2 = p_moreResults2 + "" + "" + " "; } %> <% } int count = 0; while(count < maxRowsPerPage && (((r_searchPageNbr-1)* maxRowsPerPage ) + 1+count) <= rndzv.size() ){ String[] nextChurch = (String[])rndzv.get(new Integer((r_searchPageNbr-1)* maxRowsPerPage +count)); String church = nextChurch[0]; String pastor = nextChurch[1]; String CityLine = nextChurch[2]; if (sortBy.equals("statecity")){%> <%}else{%> <%}%> <% count++; }%> <%} }catch(Exception e){ System.out.println("participants.jsp:"+e); } %> Churches Sort by: >State and City >Pastor <%=p_moreResults1%> <%=p_moreResults2%> <%=church%> <%=CityLine%> <%=pastor%> <%=pastor%> <%=church%> <%=CityLine%> <%=p_moreResults1%> <%=p_moreResults2%>