<%@ page contentType="text/html; charset=GB2312" import="java.util.*,cn.wy.Pet.Client,cn.wy.factory.PetBuy" %>
<jsp:useBean id="str" scope="page" class="cn.wy.StrFormat"/>
<%
    PetBuy pb = new PetBuy();
    List lPetNoteAll = new ArrayList();    
    String goPage = "" ;
    String downPage = "" ;
    //總的頁數
    int pageCount = 0;
    int petCount = pb.QueryPageCount("select count(*) from Client");
    int managerPetPageNo = pb.ManagerPetIndex();
    if (petCount % managerPetPageNo > 0)
        pageCount = petCount / managerPetPageNo + 1;
    else
        pageCount = petCount / managerPetPageNo ;

    int pageNo = 1; //顯示分頁的第幾頁
    
    //檢查是否要刪除寵物出售記錄
    int cid = 0;
    if (request.getParameter("delPetNote") != null)
    {
        try{
            cid = Integer.parseInt(request.getParameter("delPetNote"));
            pb.DelPetNote(cid);
            System.out.println("刪除成功！");
            out.print("寵物出售成功<br>2秒后跳轉到寵物列表");
            response.setHeader("refresh","2;URL=ctrladmin?page=petNote.jsp?pageNo=" + request.getParameter("pageNo"));
            return ;
        }catch(Exception e)
        {}
    }
    
    if (request.getParameter("pageNo") != null)
        try{
            pageNo = Integer.valueOf(request.getParameter("pageNo")).intValue();
            
        }catch(Exception e)
        {pageNo = 1;}
    else
        pageNo = 1;
    //如果有這個頁，就把記錄查詢出來
    if (pageNo > 1)
    {
        int pageAdd = pageNo - 1;
        goPage = "<a href=\"ctrladmin?page=petNote.jsp?pageNo=" + pageAdd +"\">上一頁</a>";
    }else
    {
        goPage = "上一頁";
        pageNo = 1 ; 
    }
    
    if(pageNo < pageCount)
    {
        int pageMinus = pageNo + 1 ;
        downPage ="<a href=\"ctrladmin?page=petNote.jsp?pageNo=" + pageMinus + "\">下一頁</a>";
    }else
    {
        downPage = "下一頁";
        if (pageNo > pageCount)
            pageNo = 1 ; 
    }
    if (pageNo <= pageCount)
    {
        lPetNoteAll = pb.QueryPetNoteAll(pageNo);
    }
    Iterator iter = lPetNoteAll.iterator();
%>

<script language="javascript" type="text/javascript">
function affirm()
{
	if (window.confirm("警告：確定要刪除該寵物的所有信息嗎？刪除以后不可以恢復。"))
            return true;
        else
            return false;
}
</script>  

<table width="811" height="126" border="1" align="center" cellspacing="0" bordercolor="#000000">
  <tr height="18" >
    <td height="25" colspan="11" align="center" bordercolor="#E3E4EF">
	  <strong><font size="+2">寵物出售記錄</font></strong> </td>
  </tr>
  <tr height="18" >
      <td height="36" colspan="11"  align="right" valign="middle" bordercolor="#E3E4EF">
          <!--顯示分頁信息-->
          <form name="form1" action="ctrladmin?page=petNote.jsp"> 
             已出售寵物總數：<%=petCount%>&nbsp;&nbsp;當前第<%=pageNo%>頁，共<%=pageCount%>頁&nbsp;&nbsp;
              <a href="ctrladmin?page=petNote.jsp?pageNo=1">第一頁</a>&nbsp;&nbsp;
              <%=goPage%>&nbsp;&nbsp;
              <%=downPage%>&nbsp;&nbsp;
              <a href="ctrladmin?page=petNote.jsp?pageNo=<%=pageCount%>">最后一頁</a>
              &nbsp;&nbsp;&nbsp;
              轉到：        
              <select name="page" onchange="document.form1.submit()">
                  <%
                  for (int i=1;i<=pageCount; i++){
                  %>
                  <option value=<%="petNote.jsp?pageNo=" + String.valueOf(i)%> <%=(pageNo == i)? "selected":""%> >第<%=i%>頁
                  <%
                  }
                  %>
             </select>
          </form>    
      
      </td>  
  </tr>
  <tr>
    <td width="50" height="21" align="center" bgcolor="#00CC99">流水號</td>
    <td width="53" align="center" bgcolor="#00CC99">寵物編號</td>
    <td width="34" align="center" bgcolor="#00CC99">價格</td>
    <td width="87" align="center" bgcolor="#00CC99">客戶名稱</td>
    <td width="134" align="center" bgcolor="#00CC99">聯系地址</td>
    <td width="62" align="center" bgcolor="#00CC99">電話</td>
    <td width="45" align="center" bgcolor="#00CC99">操作員</td>
    <td width="175" align="center" bgcolor="#00CC99">備注</td>
    <td width="90" align="center" bgcolor="#00CC99">出售時間</td>
    <td width="39" align="center" bgcolor="#00CC99">刪除</td>
  </tr>
  <%       
      String id = "";
      boolean isPet = false;
      
      while(iter.hasNext())
      {
          Client c = (Client)iter.next();
          //SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
          isPet = true ;
          id = String.valueOf(c.getSPetID()); 
          //System.out.println("date:" + c.getSpDate());
          
   %>

  <tr align="left" >
	<td height="22" valign="center" bordercolor="#009900"><%=String.valueOf(c.getCid())%></td>	
	<td valign="center" bordercolor="#009900">&nbsp;<%=id%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=String.valueOf(c.getPrice())%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=String.valueOf(c.getCuname())%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=c.getCuaddress()%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=String.valueOf(c.getCutel())%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=String.valueOf(c.getLoninUser())%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=c.getCuremark()%></td>
        <td valign="center" bordercolor="#009900">&nbsp;<%=c.getSpDate().substring(0,c.getSpDate().indexOf(" "))%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<a href="petNote.jsp?delPetNote=<%=c.getCid() + "&pageNo=" + pageNo %>" onclick="return affirm()" >刪除</a></td>	
  </tr>
  <%       
       }
  %>


</table>