<%@ page import="java.sql.*" %>
<%!
	public String toParamStr(String oldStr, String newStr) {
		try {
			if (oldStr == null || oldStr.equals("")) {
				return newStr;
			} else {
				return oldStr.trim();
			}
		} catch (Exception e) {
			return oldStr;
		}
	}

	public String toEucKr(String s) {
		try {
			return new String(s.getBytes("iso-8859-1"), "EUC-KR");
		} catch (Exception e) {
			return s;
		}
	}
%>

<%
	String menuId = request.getParameter("menuId");
	if(menuId == null || menuId.equals("")) menuId = "61";	
%>

<%@ page contentType="text/html;charset=euc-kr" %>
<%
	String spage = request.getParameter("spage");

	if (spage == null)
		spage = "1";
	
	int iPage = Integer.parseInt(spage);	
	PreparedStatement ps = null;
	ResultSet rs = null;
	ResultSet rsList = null;

	String searchPage = toParamStr(request.getParameter("searchPage"), "1");
	String searchType = toParamStr(request.getParameter("searchType"), "01");
	String searchWord = toEucKr(toParamStr(request.getParameter("searchWord"), ""));	
	String searchLine = toParamStr(request.getParameter("searchLine"), "10");	//한페이지에 보여줄 글의 최대 갯수

	String galtype = toParamStr(request.getParameter("galtype"), "3");
	String galseason = toParamStr(request.getParameter("galseason"), "0");

	int totalCnt = 0;								//글의 총 갯수
	int totalPage;									//총 페이지 갯수
	int blockSize = 10;								//한 화면에 보여줄 최대 페이지 갯수
	int blockPage;									//한 화면에 보여지는 페이지 중 첫번째 페이지 번호
	
	int start_no	= (Integer.parseInt(searchPage)-1)*Integer.parseInt(searchLine) + 1;	//해당 페이지의 첫번째 row number
	int end_no		= Integer.parseInt(searchPage)*Integer.parseInt(searchLine);			//해당 페이지의 마지막 row number(최대값)
	int i = 0 ;

	String 	sql = "";
	String 	pt_src = "";
	
	Connection conn = null;

		try { // 클래스 로드
			Class.forName("org.postgresql.Driver");
			conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", "");
		} catch(Exception e) {
	}

	sql = " select count(*) as cnt from gallery where type = ? and season = ? ";
	
	try {
	
		ps = conn.prepareStatement(sql);
		ps.setString(1, galtype);
		ps.setString(2, galseason);
		
		rs = ps.executeQuery ();
		
			
		if ( rs.next() ) {
			totalCnt = rs.getInt ("cnt");
		}
	} catch (Exception e) {
		System.out.println("tqna_List Error : " + e.toString());
	}  finally {
		try {
			if (rs != null) rs.close();
			if (ps != null) ps.close();
		} catch (Exception e) {
			System.out.println("Close Error : " + e.toString());
		}
	}
	
	totalPage = ( (int) (totalCnt - 1)/Integer.parseInt(searchLine) ) + 1;
	blockPage = ( (int) (Integer.parseInt(searchPage) -1)/blockSize ) * blockSize + 1;

	try {

		sql = " select  no, type, title, photo1, photo2, photo3, article, writer, wdate, ip, passwd, hitcnt, state, rpl_no, season ";
		sql += " from gallery where type = ? and state = '1' and season = ? order by no desc ";

		ps = conn.prepareStatement(sql);
		ps.setString(1, galtype);
		ps.setString(2, galseason);
		rsList = ps.executeQuery ();
	} catch (Exception e) {
		
		if ( rs != null ) rs.close();
		if ( ps != null ) ps.close();
		if ( conn != null ) conn.close();
	}

%>
<jsp:include page="/hanmaum/top.jsp" flush="false"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="ko" xml:lang="ko"> 
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<link rel="stylesheet" href="/hanmaum/Common/hstyle.css" type="text/css">
<title>무제 문서</title>

<script type="text/javascript">
<!--

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function bbsDetail(spage, pid, galtype, galseason) {
	location.href="./gallery_detail.jsp?spage=" + spage + "&no=" + pid + "&galtype=" + galtype + "&galseason=" + galseason;
	return;
}
//-->
</script>
</head>

<body onload="mouseOnEvent('<%= menuId %>');">
<%@ include file="/hanmaum/Intro/01_subimg.jsp" %>

<table width="940" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td width="239" valign="top" id="left">
<!--좌측메뉴-->
			<%@ include file="/hanmaum/gallery/left_menu.jsp" %>
<!--좌측메뉴끝-->
		</td>
		<td width="701" align="center" valign="top">

			<table width="100%" border="0" cellspacing="0" cellpadding="0" class="gatable">				
			  <tr>
					<td height="25" align="right" valign="bottom" id="ma1">
						<img src="/hanmaum/Image/location.gif" width="51" height="13" align="absmiddle"> 홈 &gt; 갤러리 &gt; 실내인테리어
					</td>
				</tr>
				<tr>
					<td><img src="/hanmaum/Image/06_centop01.gif" alt="" width="701" height="56" /></td>
				</tr>	
				<tr>
					<td><img src="/hanmaum/Image/gallery_tbanner03.gif" alt="" width="701" height="110" /></td>
				</tr>
				


				<tr>
					<td height="36">&nbsp;</td>
				</tr>
			</table>

			<table width="100%" border="0" cellspacing="0" cellpadding="0" class="gatable">
              <tr>
                <td bgcolor="#434343" height="2" colspan="5"></td>
              </tr>
              <tr>
                <td height="6" colspan="5"></td>
              </tr>
              <tr>
				<%
				if(rsList != null) {						
					while(rsList.next()) {
						i++;

						if(rsList.getString(4).length()>2){
							pt_src = "./photo/"+rsList.getString(4);
						} else if(rsList.getString(5).length()>2){
							pt_src = "./photo/"+rsList.getString(5);
						} else if(rsList.getString(6).length()>2){
							pt_src = "./photo/"+rsList.getString(6);
						}
				%>
						<td width="20%" align="center"><table width="120" border="0" cellspacing="0" cellpadding="0">
							<tr>
							  <td height="90" colspan="2" class="no"><A HREF="javascript:bbsDetail('<%= spage %>','<%= rsList.getString(1) %>','<%= galtype %>', '<%= galseason %>');"><img src="<%= pt_src %>" width="120" height="80" border="0"/></A></td>
							</tr>
							<tr>
							  <td height="20" colspan="2" align="left" class="no"><font color="#000000"><%= rsList.getString(3) %></font></td>
							</tr>
							<tr>
							  <td width="61" class="no"><%= rsList.getString(9) %></td>
							  <td width="59" align="right" class="no"><%= rsList.getString(12) %></td>
							</tr>
						  </table></td>
				<%
				if (i % 5 == 0) out.println ("</tr><tr><td colspan='5' height='10' class='no'></td></tr><tr><td colspan='5' height='1' bgcolor='#dcdcdc'></td></tr><tr><td colspan='5' height='10' class='no'></td></tr><tr>");
							}
						}
				if (totalCnt > 0) {	
				} else {	
				%>             
						<td height="24" align="center" bgcolor="#FFFFFF" colspan="5">등록된 게시물이 없습니다.</td>
				<%
					}
				%> 
              </tr>
              <tr>
                <td colspan="5" height="10" class="no"></td>
              </tr>
              <tr>
                <td colspan="5" height="1" bgcolor="#dcdcdc"></td>
              </tr>
              <tr>
                <td colspan="5" height="10" class="no"></td>
              </tr>
              <tr>
                <td align="center">&nbsp;</td>
                <td align="center">&nbsp;</td>
                <td align="center">&nbsp;</td>
                <td align="center">&nbsp;</td>
                <td align="center" class="no">&nbsp;</td>
              </tr>
            </table>

            <table width="684" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="50" align="right" valign="bottom">
				<A HREF="./gallery_write.jsp?galtype=<%= galtype %>&galseason=<%= galseason %>">
				<img src="/hanmaum/Image/co_but09.gif" width="68" height="31" border="0"/></A>
				</td>
              </tr>
            </table>

			</td>
        </tr>
      </table>
<!--컨텐츠 끝-->
		</td>
	</tr>
</table>
<%@ include file="/hanmaum/bottom.jsp" %>