<%@ page isThreadSafe="false" %><%@ include file="globalPaths.jsp" %><%@ include file="globalDefinitions.jsp" %><%
// 	This code prevents caching for malicious cnt parameter specified by user
	
	int artworksPerPage = 60;
	int count = -1;
	try
	{
		if (request.getParameter("cnt") != null)
		{
			count=Integer.parseInt(request.getParameter("cnt"));
		}
	}
	catch (Exception e)
	{
		count = -1;
	}
	int cnt = count - count % artworksPerPage;
	if (cnt < 0) cnt = 0;
	String newurl = "os.jsp";
	String queryString = "?";
	if (request.getParameter("type") != null)
	{
		queryString = queryString + "type=" + request.getParameter("type") + "&";
	}
	if (request.getParameter("cat") != null)
	{
		queryString = queryString + "cat=" + request.getParameter("cat") + "&";
	}
	newurl=newurl + queryString;
	if (cnt != count)
	{
		sendRedirect(newurl + "cnt=" + cnt);
		return;
	}
%><%@ include file="cacheBegin.jsp" %><%
	Cookie[] cookies;
	cookies = request.getCookies();
	String cookieArtist = "";
	for (int icook = 0; cookies!=null && icook < cookies.length; icook++)
	{
		Cookie cookie = cookies[icook];
		if ((cookie.getName()).equals("galleryArtistID"))
		{
			cookieArtist = cookie.getValue(); 
		}
	}
	String remoteIP = "UndefinedIP";
	if (request.getRemoteAddr() != null)
	{
		remoteIP = request.getRemoteAddr();
	}
%><%
	Connection connection = null;
	Statement statement = null;
	ResultSet resultSet = null;
	String query = "";
%><%
	Vector artworkIDs = new Vector();
	Vector names = new Vector();
	Vector artistNames = new Vector();
	Vector artists = new Vector();
	Vector smallshots = new Vector();
	Vector imageHeights = new Vector();
	Vector imageWidths = new Vector();
	Vector osNames = new Vector();
	boolean needCaching = true;
%><%
	try
	{
		connection = openConnection();
		statement = connection.createStatement();
		query = "SELECT W.*, A.id, A.firstName, A.lastName, A.activeflag, OS.name "
			+ "FROM galleryArtwork W LEFT JOIN galleryArtist A ON W.artist=A.id LEFT JOIN"
			+ " galleryOpenStudioArtist OSA ON OSA.artist = A.id LEFT JOIN galleryOpenStudio OS"
			+ " ON OS.id = OSA.openStudioId WHERE"
			+ " A.package!=0 AND A.unwelcome=0 AND (W.activeflag='Y' OR W.activeflag='L')"
			+ " AND OS.name IS NOT NULL AND (A.activeflag='Y' OR A.id=" 
			+ quoteString(cookieArtist) 
			+ " OR A.ipLastLoggedFrom=" + quoteString(remoteIP) + " OR 'admin'=" 
			+ quoteString((String)session.getValue("logged")) + ")"
			+ " ORDER BY A.lastName, A.firstName, W.activeflag, W.id, OS.name";
		resultSet = statement.executeQuery(query);
		String lastId = null;
		while (resultSet.next()) 
		{
			String id = resultSet.getString("A.id");
			if (!id.equals(lastId))
			{
				String af = resultSet.getString("A.activeflag");
				if (!"Y".equals(af))
				{
					needCaching = false;
				}
				artworkIDs.addElement(resultSet.getString("W.id"));
				names.addElement(resultSet.getString("W.name"));
				osNames.addElement(resultSet.getString("OS.name"));
				String fln;
				String fn = resultSet.getString("A.firstName");
				String ln = resultSet.getString("A.lastName");
				if (fn.equals("")) 
					fln = ln; 
				else 
					fln = fn + " " + ln;
				
				artistNames.addElement(fln);
				artists.addElement(resultSet.getString("A.id"));
				if (resultSet.getString("smallshot") == null 
					|| "".equals(resultSet.getString("smallshot")))
				{
					smallshots.addElement("ima/e1.gif");
				}
				else
				{
					smallshots.addElement(resultSet.getString("smallshot"));
				}
				if (resultSet.getString("W.heightImage") == null 
					|| "".equals(resultSet.getString("W.heightImage")))
				{
					imageHeights.addElement("1");
				}
				else
				{
					imageHeights.addElement(resultSet.getString("W.heightImage"));
				}
				if (resultSet.getString("W.widthImage") == null 
					|| "".equals(resultSet.getString("W.widthImage")))
				{
					imageWidths.addElement("1");
				}
				else
				{
					imageWidths.addElement(resultSet.getString("W.widthImage"));
				}
				lastId = id;
			}
		}
		resultSet.close();
		connection.close();
	}
	catch (Exception e)
	{
		errorLog(e, query);
		sendRedirect(globalErrorPage + "?errorDescription="
			+ URLEncoder.encode(e.getMessage() + "."));
		return;
	}
	finally
	{
		if (resultSet != null) resultSet.close();
		if (connection != null && !connection.isClosed()) connection.close();
	}
%><%
	int numpages = (int)Math.ceil((double)artworkIDs.size() / (double)artworksPerPage);
	int[] pageindex = new int[numpages];
	for (int i = 0; i < numpages; i ++)
	{
		pageindex[i] = i * artworksPerPage;
	}
	if (cnt > artworkIDs.size() - 1) 
	{
		if (numpages > 0)
		{
			cnt = pageindex[numpages-1];
		}
		else
		{
			cnt = 0;
		}
	}
	if (cnt != count) {
		sendRedirect(newurl + "cnt=" + cnt);
		return;
	}
	int fromindex = cnt;
	int toindex = cnt + artworksPerPage - 1;
	if (toindex > artworkIDs.size() - 1) toindex = artworkIDs.size() - 1;
	int previndex = fromindex - artworksPerPage;
	if (previndex < 0) previndex = 0;
%><%
	if (needCaching)
	{
%><%@ include file="cacheLaunch.jsp" %><%
	}
%>
<head>
<title>Open Studio Website</title>
<meta name="classification" content="virtual gallery">
<meta name="keywords" http-equiv="keywords" content="Open Studio Artists">
<meta name="description" http-equiv="description" content="Open Studio Artists">
<%@ include file="inc/head.txt" %>
<!-- Open Studio Artists -->
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" bgcolor="#F8FDEF">
<%@ include file="inc/top.txt" %>
<script language="JavaScript">onloadHandler();</script>
<table cellpadding="0" cellspacing="0" border="0" width="775" bgcolor="#FFFFFF"><tr>
								<td valign=top align=center><br><font id="dkSmall8b"><a href="portfolios"><font id="dkSmall8b">Portfolios</font></a> | <a href="autoPS.jsp"><font id="dkSmall8b">Artist Studios</font></a> |  <a href="ps.jsp"><font id="dkSmall8b">Artist Galleries</font></a> | <font id="dkSmall8g"><b>Open Studios</b></font> | <a href="lobby.jsp"><font id="dkSmall8b">Lobby</font></a>
</font></td>
							</tr>
							<tr>
								<td height=2><font id="dkSmall2">&nbsp;</font></td>
							</tr>
							<tr>
								<td valign=top align=center><br><a href="openstudiosMarin.jsp"><font id="dkSmall7g">Marin Arts Council OS</font></a> | <a href="ebos.jsp"><font id="dkSmall7g">Pro Arts - EBOS</font></a> | <a href="openstudios_SFSpring.jsp"><font id="dkSmall7g">San Francisco Spring OS</font></a> | <a href="openstudios_SanFrancisco.jsp"><font id="dkSmall7g">San Francisco Fall OS</font></a> | <a href="svopenstudios.jsp"><font id="dkSmall7g">Silicon Valley OS</font></a> | <a href="osBenicia.jsp"><font id="dkSmall7g">Benicia OS</font></a><!-- | <a href="taolb.jsp"><font id="dkSmall7g">TAOLB</font>--></a> <br>
<br>
</td>
							</tr>
							<tr>
								<td valign=top>

								<!-- mainbody begin -->

<%
	if (artworkIDs.size() < 1)
	{
%>
			<table border="0" cellspacing="0" cellpadding="0" width="774">
				<tr>
					<td valign="middle" align="center" width="774" height="160"><font id="dkSmall9b">There are no artworks found matching the specified criteria.</font></td>

				</tr>
			</table>	
<% 
	}
	else
	{ 
%>	 
      		<table border="0" cellpadding="0" cellspacing="0">
        		<tr>
					<td width="14" height="1"><img src="ima/e1.gif" width="14" height="1"></td>
					<td width="139" height="1"><img src="ima/e1.gif" width="139" height="1"></td>
					<td width="13" height="1"><img src="ima/e1.gif" width="13" height="1"></td>
					<td width="139" height="1"><img src="ima/e1.gif" width="139" height="1"></td>
					<td width="13" height="1"><img src="ima/e1.gif" width="13" height="1"></td>
					<td width="139" height="1"><img src="ima/e1.gif" width="139" height="1"></td>
					<td width="13" height="1"><img src="ima/e1.gif" width="13" height="1"></td>
					<td width="139" height="1"><img src="ima/e1.gif" width="139" height="1"></td>
					<td width="13" height="1"><img src="ima/e1.gif" width="13" height="1"></td>
					<td width="139" height="1"><img src="ima/e1.gif" width="139" height="1"></td>
					<td width="13" height="1"><img src="ima/e1.gif" width="13" height="1"></td>
					<td width="1" height="1"><img src="ima/e1.gif" width="1" height="15"></td>
				</tr>
<%
		String width, height;
		for (int j = fromindex; j < toindex + 1 && numpages > 0; j += 5)
		{
%>
				<tr>
					<td></td>
<%
			for (int i = j; i < j + 5; i ++)
			{
				if (i < artworkIDs.size())
				{
%>
					<td align="center" valign="bottom"><br><a href="./artworks.jsp?artist=<%= (String)artists.elementAt(i) %>"><img src="<%= (String)smallshots.elementAt(i) %>" alt="<%=(String)artistNames.elementAt(i) + "'s " + (String)names.elementAt(i) %>" border=0 
<%
					width = (String)imageWidths.elementAt(i);
					height = (String)imageHeights.elementAt(i);
					if (Integer.parseInt((String)artworkIDs.elementAt(i)) > 262)
					{
						if ((float)Integer.valueOf(height).intValue() / Integer.valueOf(width).intValue() > 1.15) 
						{
%> height=108 <% 
						} 
						else 
						{
							if ((float)(Integer.valueOf(height).intValue())/(Integer.valueOf(width).intValue()) < 1/1.15) 
							{ 
%> width=108 <% 
							} 
							else 
							{ 
%> width=92 <% 
							} 
						}
					}
%>></a></td>
					<td></td>
<%
				}
				else
				{
%><td colspan="2"></td><%
				}
			}
%>
					
					<td></td>
				</tr>
				<tr>
					<td colspan="12" height="10"><img src="ima/e1.gif" width="1" height="1"></td>
				</tr>
				<tr>
					<td></td>
<%
			for (int i = j; i < j + 5; i ++)
			{
				if (i < artworkIDs.size())
				{
%>
					<td align="center" valign="top">
					<font id="dkSmall6b"><%=artistNames.elementAt(i) %><br></font>
					<font id="dkSmall6buy"><%=osNames.elementAt(i)%></font></font></td>
					<td></td>
<%
				}
				else
				{
%><td colspan="2"></td><%
				}
			}
%>
					<td></td>
				</tr>
<%
		}
%>

					<td></td>
				</tr>
				<!-- E -->
				<tr>
					<td colspan="12" height="20"><img src="ima/e1.gif" border="0" width="1" height="1"></td>
				</tr>
				
				<tr>
					<td colspan="11" align="center">
						<table cellpadding="0" cellspacing="0" border="0">
							<tr>
<% 
		if (numpages > 1)
		{
%>							
								<td align=center colspan=4><br><font id="dkSmall8d">&nbsp;Results <%= fromindex + 1 %>-<%= toindex + 1 %> of <%=artworkIDs.size() %>&nbsp;&nbsp;&nbsp;</font>
<%
			if (fromindex > 0) 
			{ 
%>
								<a href="<%=newurl%>cnt=<%=previndex%>"><font id="dkSmall8d">&nbsp;Previous &nbsp;&nbsp;</font></a>  
<% 
			};
			for (int j = 0; j < numpages; j++)
			{
%>
		<font id=dkSmall8d>&nbsp;<a href="<%=newurl%>cnt=<%=pageindex[j]%>" class="types"><%= (pageindex[j] == fromindex) ? "<b>" : ""%><%=j + 1%><%=(pageindex[j] == fromindex) ? "</b>" : "" %></a>&nbsp;</font>
<%
			}
			if (toindex < artworkIDs.size() - 1)
			{
%>
		<a href="<%=newurl%>cnt=<%=toindex + 1%>"><font id="dkSmall8d">&nbsp;Next&nbsp;</font></a> 
<%
			}
%></td><%
		}
		else
		{
%>
								<td align=center ><br><font id="dkSmall8d">&nbsp;</font></td>
<%
		}
%>
							</tr>
						</table>
					</td>
					<td width="1"><img src="ima/e1.gif" width=1 border=0 alt=""></td>
				</tr>
<%
	}
%>
	      	</table>
								<!-- mainbody end -->
								</td>
							</tr>
						</table>
<%@ include file="inc/bottom.txt" %>
<%
	artworkIDs.removeAllElements();
	names.removeAllElements();
	artistNames.removeAllElements();
	artists.removeAllElements();
	smallshots.removeAllElements();
	imageHeights.removeAllElements();
	imageWidths.removeAllElements();
	osNames.removeAllElements();
%><%
	if (needCaching)
	{
%><%@ include file="cacheEnd.jsp" %><%
	}
%><%@ include file="globalFinally.jsp" %>