<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%>
<%@ include file="../../Connections/HOST_causeworks.jsp" %>
<%
String Recordset2__PARAM = "1";
if (request.getParameter("process_id")  !=null) {Recordset2__PARAM = (String)request.getParameter("process_id") ;}
%>
<%
String Recordset2__PARAMSTEP = "1";
if (request.getParameter("step_number")   !=null) {Recordset2__PARAMSTEP = (String)request.getParameter("step_number")  ;}
%>
<%
Driver DriverRecordset2 = (Driver)Class.forName(MM_HOST_causeworks_DRIVER).newInstance();
Connection ConnRecordset2 = DriverManager.getConnection(MM_HOST_causeworks_STRING,MM_HOST_causeworks_USERNAME,MM_HOST_causeworks_PASSWORD);
PreparedStatement StatementRecordset2 = ConnRecordset2.prepareStatement("SELECT *  FROM process,steps_IDX  WHERE process.process_id = steps_IDX.process_id AND process.process_id = " + Recordset2__PARAM + " AND steps_IDX.process_id = " + Recordset2__PARAM + " AND steps_IDX.step_number = " + Recordset2__PARAMSTEP + "");
ResultSet Recordset2 = StatementRecordset2.executeQuery();
boolean Recordset2_isEmpty = !Recordset2.next();
boolean Recordset2_hasData = !Recordset2_isEmpty;
Object Recordset2_data;
int Recordset2_numRows = 0;
%>
<%
Driver DriverRecordset3 = (Driver)Class.forName(MM_HOST_causeworks_DRIVER).newInstance();
Connection ConnRecordset3 = DriverManager.getConnection(MM_HOST_causeworks_STRING,MM_HOST_causeworks_USERNAME,MM_HOST_causeworks_PASSWORD);
PreparedStatement StatementRecordset3 = ConnRecordset3.prepareStatement("SELECT process_id, process_name  FROM process");
ResultSet Recordset3 = StatementRecordset3.executeQuery();
boolean Recordset3_isEmpty = !Recordset3.next();
boolean Recordset3_hasData = !Recordset3_isEmpty;
Object Recordset3_data;
int Recordset3_numRows = 0;
%>
<%
String Recordset4__PARAM = "1";
if (request.getParameter("process_id") !=null) {Recordset4__PARAM = (String)request.getParameter("process_id");}
%>
<%
Driver DriverRecordset4 = (Driver)Class.forName(MM_HOST_causeworks_DRIVER).newInstance();
Connection ConnRecordset4 = DriverManager.getConnection(MM_HOST_causeworks_STRING,MM_HOST_causeworks_USERNAME,MM_HOST_causeworks_PASSWORD);
PreparedStatement StatementRecordset4 = ConnRecordset4.prepareStatement("SELECT artist.artist_name, artist.artist_id, artwork.art_name, medium.medium_name, medium.medium_id, movement.movement_name, movement.movement_id, artwork.process_id, artist.process_id FROM artist, artwork, medium, movement, process  WHERE " + Recordset4__PARAM + " = artwork.process_id AND " + Recordset4__PARAM + " = artist.process_id AND " + Recordset4__PARAM + " = process.process_id AND artwork.artist_id = artist.artist_id AND artwork.movement_id = movement.movement_id AND medium.medium_id = artwork.medium_id");
ResultSet Recordset4 = StatementRecordset4.executeQuery();
boolean Recordset4_isEmpty = !Recordset4.next();
boolean Recordset4_hasData = !Recordset4_isEmpty;
Object Recordset4_data;
int Recordset4_numRows = 0;
%>
<%
String Recordset1__PARAM = "1";
if (request.getParameter("process_id")  !=null) {Recordset1__PARAM = (String)request.getParameter("process_id") ;}
%>
<%
Driver DriverRecordset1 = (Driver)Class.forName(MM_HOST_causeworks_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_HOST_causeworks_STRING,MM_HOST_causeworks_USERNAME,MM_HOST_causeworks_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT *  FROM process,steps_IDX  WHERE process.process_id = steps_IDX.process_id AND process.process_id = " + Recordset1__PARAM + " AND steps_IDX.process_id = " + Recordset1__PARAM + "  ORDER BY step_number");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
Recordset1_numRows += Repeat1__numRows;
%>
<% String MM_paramName = ""; %>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

String MM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone="";
String[] MM_removeList = { "index", MM_paramName };

// create the MM_keepURL string
if (request.getQueryString() != null) {
  MM_keepURL = '&' + request.getQueryString();
  for (int i=0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) {
  int start = MM_keepURL.indexOf(MM_removeList[i]) - 1;
    if (start >= 0 && MM_keepURL.charAt(start) == '&' &&
        MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') {
      int stop = MM_keepURL.indexOf('&', start + 1);
      if (stop == -1) stop = MM_keepURL.length();
      MM_keepURL = MM_keepURL.substring(0,start) + MM_keepURL.substring(stop);
    }
  }
}

// add the Form variables to the MM_keepForm string
if (request.getParameterNames().hasMoreElements()) {
  java.util.Enumeration items = request.getParameterNames();
  while (items.hasMoreElements()) {
    String nextItem = (String)items.nextElement();
    boolean found = false;
    for (int i=0; !found && i < MM_removeList.length; i++) {
      if (MM_removeList[i].equals(nextItem)) found = true;
    }
    if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) {
      MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem));
    }
  }
}

// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length() > 0)  MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<html>
<head>
<!--#include virtual="head.jsp" -->
<table width="800" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td width="1" bgcolor="#FF9900"><img src="images/space.gif" width="1" height="1"></td>
    <td width="798"> 
      <p><img src="images/space.gif" width="798" height="1"></p>
      <table width="760" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#999999">
        <tr valign="top"> 
          <td width="40" rowspan="3" background="images/space_og.gif"><img src="images/create.gif" width="40" height="220"></td>
          <td width="470" rowspan="3"> <br>
            <table width="460" border="0" cellspacing="0" cellpadding="5">
              <tr> 
                <td width="240" valign="top"><img src="<%=(((Recordset2_data = Recordset2.getObject("step_media"))==null || Recordset2.wasNull())?"":Recordset2_data)%>" width="240" height="180"></td>
                <td width="220" valign="top"><b class="title">
                  <%=(((Recordset2_data = Recordset2.getObject("process_name"))==null || Recordset2.wasNull())?"":Recordset2_data)%></b><br><strong><%=(((Recordset2_data = Recordset2.getObject("step_name"))==null || Recordset2.wasNull())?"":Recordset2_data)%></strong><br><img src="<%=(((Recordset2_data = Recordset2.getObject("step_media3"))==null || Recordset2.wasNull())?"":Recordset2_data)%>" alt="Step" border="0"><br>                  </td>
              </tr>
            </table>
            <b> &nbsp;&nbsp;Steps:</b> 
            <table border="0" cellspacing="0" cellpadding="5">
              <tr> 
                <% while ((Recordset1_hasData)&&(Repeat1__numRows-- != 0)) { %>
                <td><a href="process_detail.jsp?<%= MM_keepNone + ((MM_keepNone!="")?"&":"") + "process_id=" + (((Recordset2_data = Recordset2.getObject("process_id"))==null || Recordset2.wasNull())?"":Recordset2_data) + "&step_number=" + (((Recordset1_data = Recordset1.getObject("step_number"))==null || Recordset1.wasNull())?"":Recordset1_data) %>"><img src="<%=(((Recordset1_data = Recordset1.getObject("step_media2"))==null || Recordset1.wasNull())?"":Recordset1_data)%>" border="0"></a>&nbsp;</td>
                <%
  Repeat1__index++;
  Recordset1_hasData = Recordset1.next();
}
%>
              </tr>
            </table>
            <table width="460" border="0" cellspacing="0" cellpadding="5">
              <tr valign="top"> 
                <td colspan="2"><%=(((Recordset2_data = Recordset2.getObject("step_detail"))==null || Recordset2.wasNull())?"":Recordset2_data)%> <br>
                  <br>
                  <%=(((Recordset2_data = Recordset2.getObject("step_detail2"))==null || Recordset2.wasNull())?"":Recordset2_data)%></td>
              </tr>
            </table>
            <br>
            <br>
          </td>
          <td width="10" rowspan="3" bgcolor="#666666"><img src="images/space.gif" width="10" height="1"></td>
          <td width="10" rowspan="3" background="images/space_og.gif"><img src="images/space_og.gif" width="40" height="400"></td>
          <td width="200" rowspan="3"><br>
            <img src="images/archive.gif" width="141" height="22"> <br>
            <script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
            <form name="form1">
              <select name="menu" onChange="MM_jumpMenu('parent',this,0)" class="dropdown">
                <option value="#" selected>Choose a Process</option>
                <%
while (Recordset3_hasData) {
%>
                <option value="process_intro.jsp?process_id=<%=(((Recordset3_data = Recordset3.getObject("process_id"))==null || Recordset3.wasNull())?"":Recordset3_data)%>" ><%=(((Recordset3_data = Recordset3.getObject("process_name"))==null || Recordset3.wasNull())?"":Recordset3_data)%></option>
                <%
  Recordset3_hasData = Recordset3.next();
}
Recordset3.close();
Recordset3 = StatementRecordset3.executeQuery();
Recordset3_hasData = Recordset3.next();
Recordset3_isEmpty = !Recordset3_hasData;
%>
              </select>
            </form>
            <br>
            <img src="images/email.gif" width="141" height="22"> <br>
            <form name="form2" method="post" action="">
              <input type="text" name="name">
              <input type="text" name="email">
              <br>
              <br>
              <img src="images/send.gif" width="40" height="17"> <br>
            </form>
            <b>Learn More About:</b><br> <a href="medium_detail.jsp?medium_id=<%=(((Recordset4_data = Recordset4.getObject("medium_id"))==null || Recordset4.wasNull())?"":Recordset4_data)%>"><%=(((Recordset4_data = Recordset4.getObject("medium_name"))==null || Recordset4.wasNull())?"":Recordset4_data)%></a><br>
		<a href="movement_detail.jsp?movement_id=<%=(((Recordset4_data = Recordset4.getObject("movement_id"))==null || Recordset4.wasNull())?"":Recordset4_data)%>"><%=(((Recordset4_data = Recordset4.getObject("movement_name"))==null || Recordset4.wasNull())?"":Recordset4_data)%></a><br>
		</td>
        </tr>
        <tr valign="top"> </tr>
        <tr valign="top"> </tr>
      </table>
      <br>
    </td>
    <td width="1" bgcolor="#FF9900"><img src="images/space.gif" width="1" height="1"></td>
  </tr>
</table>
<table width="800" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td bgcolor="#FF9900"><img src="images/space.gif" width="1" height="1"></td>
  </tr>
</table>
<!--#include virtual="foot.jsp" -->
</body>
</html>
<%
Recordset2.close();
ConnRecordset2.close();
%>
<%
Recordset3.close();
ConnRecordset3.close();
%>
<%
Recordset1.close();
ConnRecordset1.close();
%>
<%
Recordset4.close();
ConnRecordset4.close();
%>