<%@ page contentType="text/html; charset=GB2312" import="java.util.*,cn.wy.Pet.Things,cn.wy.factory.ThingsBuy" %>
<jsp:useBean id="str" scope="page" class="cn.wy.StrFormat"/>
<%
    ThingsBuy tb = new ThingsBuy();
    List lTbAll = new ArrayList();    
    String goPage = "" ;
    String downPage = "" ;
    String keyword = "";
    if (request.getParameter("key") != null)
    {
        keyword = String.valueOf(request.getParameter("key"));
        if (keyword.indexOf("\'") >= 0 | keyword.indexOf("-") >= 0)
        {
            out.print("<script>alert('請不要亂注！');history.go(-1)</script>");
            return ;            
        }
    }
    //總的頁數
    int pageCount = 0;
    String strSql = "select count(*) from Things where stname like '%"+keyword+"%' or sttremark like '%"+keyword+"%'" ;
    int petCount = tb.queryCount(strSql);
    int managerPetPageNo = 12;
    if (petCount % managerPetPageNo > 0)
        pageCount = petCount / managerPetPageNo + 1;
    else
        pageCount = petCount / managerPetPageNo ;

    int pageNo = 1; //顯示分頁的第幾頁
    try{
        pageNo = Integer.valueOf(request.getParameter("pageNo")).intValue();
    }catch(Exception e)
    {pageNo = 1;}
    //如果有這個頁，就把記錄查詢出來

    if (pageNo > 1)
    {
        int pageAdd = pageNo - 1;
        goPage = "<a href=\"ctrladmin?page=thingsManager.jsp?pageNo=" + pageAdd +"\">上頁</a>";
    }else
    {
        goPage = "";
        pageNo = 1 ; 
    }
    if(pageNo < pageCount)
    {
        int pageMinus = pageNo + 1 ;
        downPage ="<a href=\"ctrladmin?page=thingsManager.jsp?pageNo=" + pageMinus + "\">下頁</a>";
    }else
    {
        downPage = "";
        if (pageNo > pageCount)
            pageNo = 1 ; 
    }
    if (pageNo <= pageCount)
    {
        lTbAll = tb.queryThings(pageNo,managerPetPageNo,keyword);
    }
    Iterator iter = lTbAll.iterator();
%> 
<table width="846" height="175" border="1" align="center" cellspacing="0" bordercolor="#000000">
  <tr height="18" >
    <td height="25" colspan="12" align="center" bordercolor="#E3E4EF"><strong><font size="+2">寵物用品列表</font></strong> </td>
  </tr>
  
  <tr>
    <td width="18"  height="21" align="center" bgcolor="#00CC99"><div align="center">編號</div></td>
    <td width="37"  align="center" bgcolor="#00CC99"><div align="center">商品名稱</div></td>
    <td width="58"  align="center" bgcolor="#00CC99"><div align="center">入庫時間</div></td>
    <td width="30"   align="center" bgcolor="#00CC99"><div align="center">購入價￥</div></td>
    <td   align="center" bgcolor="#00CC99"><div align="center">出售價￥</div></td>
    <td width="35"  align="center" bgcolor="#00CC99"><div align="center">操作員</div></td>
    <td width="35"  align="center" bgcolor="#00CC99"><div align="center">瀏覽</div></td>
    <td   align="center" bgcolor="#00CC99"><div align="center">寵物說明信息</div></td>
    <td width="22"  align="center" bgcolor="#00CC99">出售</td>
    <td width="25"  align="center" bgcolor="#00CC99">價格</td>
    <td width="21"   align="center" bgcolor="#00CC99"><div align="center">刪除</div></td>
    <td width="21"  align="center" bgcolor="#00CC99"><div align="center">修改</div></td>
  </tr>
  <%       
      boolean isPet = false;
      while(iter.hasNext())
      {
          Things t = (Things)iter.next();
          String canSpStr = "";
          isPet = true ;
          String isV = "是";
          String isVP = "是";
          if (!t.getIsView())
              isV = "否";
          if (!t.getIsViewPrice())
              isVP = "否";
   %>
  <script language="javascript" type="text/javascript">
function affirm()
{
	if (window.confirm("警告：確定要刪除該寵物的所有信息嗎？刪除以后不可以恢復。"))
            return true;
        else
            return false;
}
</script>
  <tr <%=canSpStr%>>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(t.getStThingsID())%></td>
    <td align="left" valign="center" bordercolor="#009900"><%=str.subStr(t.getSTName(),6).replaceAll(keyword,"<font color=\"red\">"+keyword+"</font>")%></td>
    <td align="left" valign="center" bordercolor="#009900"><a href="#" title="<%=t.getSTTDate()%>"><%=t.getSTTDate().substring(0,t.getSTTDate().indexOf(" "))%></a></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(t.getSTSpPrice())%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(t.getSTSalePrice())%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(t.getUName())%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(t.getCCount())%></td>
    <td align="left" valign="center" bordercolor="#009900"><a href="#" title="<%=t.getSTTRemark()%>"><%=str.subStr(t.getSTTRemark(),11).replaceAll(keyword,"<font color=\"red\"><b>"+keyword+"</b></font>")%></a></td>
    <td align="left" valign="center" bordercolor="#009900"><%=isV%></td>
    <td align="left" valign="center" bordercolor="#009900"><%=isVP%></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?delThingsID=<%=t.getStThingsID() + "&pNo=" + pageNo %>" onclick="return affirm()" >刪除</a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?thingsEditID=<%=t.getStThingsID() + "&pNo=" + pageNo %>" >修改</a></td>
  </tr><font color="FF0000"></font>
  <%       
       }
        if (!isPet){
  %>
  <tr> 
      <td height="43" colspan="11" > 
          <br>還沒有寵物信息! <br>
        <a href="ctrladmin?page=addThings.jsp">點這里添加寵物</a> <br><br>
  <td width="0">  </tr>
  <%
        }
  %>
  
  <tr align="top">
    <td height="10" colspan="11"  align="left" valign="top" bordercolor="#000000"><table width="828" height="27" border="0">
      <tr>
        <td width="516" height="23"><form action="ctrladmin?page=thingsManager.jsp" name="form1" id="form1">
          當前頁:<%=lTbAll.size()%>條&nbsp;&nbsp;共：<%=petCount%>條&nbsp;&nbsp;<%=pageNo%>/<%=pageCount%>&nbsp;&nbsp; <a href="ctrladmin?page=thingsManager.jsp?pageNo=1">第一頁</a>&nbsp; <%=goPage%>&nbsp; <%=downPage%>&nbsp; <a href="ctrladmin?page=thingsManager.jsp?pageNo=<%=pageCount%>">尾頁</a> &nbsp;&nbsp;轉到：
          <select name="page" onchange="document.form1.submit()">
            <%
                  for (int i=1;i<=pageCount; i++){
                  %>
            <option value="<%="thingsManager.jsp?pageNo=" + String.valueOf(i)%>" <%=(pageNo == i)? "selected":""%> >第<%=i%>頁
              <%
                  }
                  %>
              </option>
          </select>
        </form></td>
        <td width="302"><form action="ctrladmin?page=thingsManager.jsp" method="post" name="find" id="find">
            <div align="right">查找商品：
              <input type="text" maxlength="20" value="<%=keyword%>" size="10" name="key" />
                <input type="submit" value="查找" name="butt" />
            </div>
        </form></td>
      </tr>
    </table></td>
  </tr>
</table>