<!--#include file="../checkLogin.asp"-->
<!--#include file="../SQLconn.asp"-->
<!doctype html>
<html>
<head><title></title><meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../images/<%=request.cookies("imgdir")%>/css/style.css" media="all"/>
<script src="../laydate/laydate.js"></script>
<script Language=JavaScript>
<!--
window.setTimeout('this.location.reload();',480000);

//-->
</script>
<style type="text/css">
<!--
.STYLE3 {color: #990033}
-->
</style>
<body>

<table width="100%" height="495" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="27">
	<div class="header">
	<div class="nav">
        <ul>
          
            <li><a href="shenqing.asp" target="_self">申请印刷资料</a></li>
			 <li class="on">印刷资料审批</li>
            <li><a href="jiketongji.asp?qdtype=未处理" target="_self">印刷资料统计</a></li>
        </ul>
    </div>	
	</td>
  </tr>

 
  <tr>
   <td height="470" valign="top"   class="NemuMainBox">
	 <br>
	
      <div align="center">
  
<%

 strdate1=request("date1")
 strdate2=request("date2")
 strGrade=request("grade")
 strsubject=request("subject")
 teacher=request("teacher")
 if strdate1="" then 
   strdate1=date()-150
 end if
 if strdate2="" then 
   strdate2=date()+1  
 end if



   
%>
<form id="form1" name="form1" method="post" action="main.asp">
 
 
<table width="95%" height="33" border="1" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8" style="border-collapse:collapse"  class="mtablehui">
  <tr style="background-color:#D6E4FF"  class="TableHeader">
    <td height="31" colspan="3" align="center" nowrap class="NemuNot">

	<table width="777" border="0" align="center" cellspacing="0">
      <tr>
        <td width="39" class="STYLE1"><div align="right"><span class="STYLE1 STYLE2">开始&nbsp;</span></div></td>
        <td width="91" class="STYLE1"><b><b>
         <input name=date1  placeholder="请输入日期"  style="width:90px"  value=<%=strdate1%> class="laydate-icon" onClick="laydate()">
        </b></b></td>
        <td width="56" class="STYLE1"><div align="right"><span class="STYLE2">结束&nbsp;</span></div></td>
        <td width="84" class="STYLE1"><b><b>
          <input name=date2  placeholder="请输入日期"  style="width:90px"  value=<%=strdate2%> class="laydate-icon" onClick="laydate()">
        </b></b></td>
        <td width="53" class="STYLE1"><div align="right"><span class="STYLE1 STYLE2">年 级&nbsp;</span></div></td>
        <td width="57" class="STYLE1"><span class="STYLE2">
          <select name="grade" id="grade">
          <option selected value=<%=strGrade%>><%=strGrade%></option>
          <% Set RSsel = Conn.Execute("select vname from  varset where name='beikeji'")
                   While NOT RSsel.EOF %>
          <option value=<%=RSsel( "Vname" )%>><%=RSsel( "vname" )%></option>
          <% RSsel.MoveNext
                  Wend
                  RSsel.Close%>
				  <option value=行政>行政</option>  
      </select>	
        </span></td>
		<td width="52" height="33" class="STYLE1"><div align="right">科 组&nbsp;</div></td>
      <td width="61" class="STYLE1"><select name="subject" id="subject">
        <option selected value=<%=strsubject%>><%=strsubject%></option>
        <% Set RSsel = Conn.Execute("select vname from  varset where name='beikezu'")
                   While NOT RSsel.EOF %>
        <option value=<%=RSsel( "Vname" )%>><%=RSsel( "vname" )%></option>
        <% RSsel.MoveNext
                  Wend
                  RSsel.Close%>
				   <option value=其他>其他</option>
      </select></td>
        <td width="71" class="STYLE1"><div align="right"><span class="STYLE2">教 师&nbsp;</span></div></td>
        <td width="123" class="STYLE1"><span class="STYLE2">
          <input name="teacher" type="text" id="teacher" size="15" value=<%=teacher%>>
        </span></td>
        <td width="68" class="STYLE1 STYLE2"><input name="Submit" type="submit" class="topanniu" value="搜索" /></td>
      </tr>
    </table>
	
	</td>
  </tr>
</table>
<br>
 <%
 
   tname=request.cookies("tname")
   Set Rsbaoxiu=Server.CreateObject("Adodb.Recordset")
   sqlbaoxiu="Select * from yinshua  where   (datetime BETWEEN '"&strdate1&"'  AND   '"&strdate2&"') AND (grade like  '%"&strGrade&"%')  AND (subject like  '%"&strsubject&"%') and     (teacher like '%"&teacher&"%')  order  by  datetime desc "  
 '  wenyinshi ,jiaodaochu,beikezuzhang,
  %>   

<table width="95%" align="center" border="1" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">  

     <tr style="background-color:#D6E4FF"  class="TableHeader">
       <td height="30" align="center" nowrap class="STYLE1"><span class="STYLE1 STYLE1">表单内容</span></td>
       <td align="center" nowrap class="STYLE1"><span class="STYLE1 STYLE1">时间</span></td>
       <td align="center" nowrap class="STYLE1">申请人</td>
       <td align="center" nowrap class="STYLE1"><span class="STYLE1">备课组长签名</span></td>
       <td width="107" align="center" nowrap class="STYLE1"><span class="STYLE1">行政签名</span></td>
       <td width="182" align="center" nowrap class="STYLE1">文印室完成签名</td>
    
	 </tr>
	 


<%	 
	    Rsbaoxiu.open sqlbaoxiu,conn,1,1
   Rsbaoxiu.pagesize=12 '每页记录条数
   curpage=Request.QueryString("curpage") '将URL参数curpage传给curpage变量
   Rsbaoxiu.absolutepage=curpage '将本页设为curpage设置的页数
   if curpage=0 then
      curpage=1
   end if 


   for i= 1 to Rsbaoxiu.pagesize
      if Rsbaoxiu.eof then
         exit for
      end if
%>
    <tr  onmouseout="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
      <td  height="32" align="center" nowrap class="STYLE1"><span class="STYLE5"><a href="view.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>"><%=Rsbaoxiu("grade")%><%=Rsbaoxiu("subject")%>   规格：<%=Rsbaoxiu("guige")%><%=Rsbaoxiu("danshuangmian")%>；版纸数:<%=Rsbaoxiu("banzhishu")%>；印刷数：<%=Rsbaoxiu("yinjuanshu")%></a>
	    <a href="newFile.asp?id=<%=Rsbaoxiu("id")%>"  target="_blank">&nbsp;&nbsp;&nbsp;&nbsp;【附件】</a>
	  </span></td>
      <td width="73" align="center" nowrap class="STYLE1"><span class="STYLE5 STYLE1"><span class="STYLE10"><%=Rsbaoxiu("datetime")%></span></span></td>
      <td width="80" align="center" nowrap class="STYLE1">
	  
	  <span class="STYLE10"> <%=Rsbaoxiu("teacher")%></span>
	  <%if  Rsbaoxiu("jiaodaochu")<>"不同意印刷" then  %>
			  <%if  Rsbaoxiu("beikezuzhang")=""  and  Rsbaoxiu("teacher")=request.cookies("tname")   then  %>
				   <a href="delete.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>"> 删除</a>
			  <%end if %>	
			  
	  <%else %>
	         <%if    Rsbaoxiu("teacher")=request.cookies("tname")   then  %>
				   <a href="delete.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>"> 删除</a>
			  <%end if %>	
	  <%end if %>
	   
	  
	  
	  
	   </td>
      <td width="92" align="center" nowrap class="STYLE1"><span class="STYLE5">
	  
	  
	 
	  <%if  Rsbaoxiu("beikezuzhang")<>"" then  %>
	    <%=Rsbaoxiu("beikezuzhang")%>
	
		<%if  Rsbaoxiu("jiaodaochu")=""  and  Rsbaoxiu("beikezuzhang")=request.cookies("tname")   then  %>
	        <a href="deleteBKZ.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>"> 撤销</a>
	    <%end if %>
		
		
	  <%else%>
	     <a href="BKZqianming.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>">签名</a>
	  <%end if %>
	  
	  
	  </span></td>
      <td align="center" nowrap class="STYLE1"><span class="STYLE5">
	  
	  <%if  Rsbaoxiu("jiaodaochu")<>"" then  %>
	    
	    <%=Rsbaoxiu("jiaodaochu")%>
		
	  <%else%>
	     <a href="JDCqianming.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>">同意</a>&nbsp;&nbsp;
		 
		 <a href="JDCJuQian.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>">不同意</a>		 
		 
		 
	  <%end if %>
	 
	 
	 
	 </span></td>
      <td align="center" nowrap class="STYLE1"><span class="STYLE5">
        
		<%if  Rsbaoxiu("jiaodaochu")<>"不同意印刷" then  %>
		
		<%if  Rsbaoxiu("wenyinshi")<>"" then  %>
        <%=Rsbaoxiu("wenyinshi")%>
        <%else%>
        <a href="WYSqianming.asp?curpage=<%=curpage%>&ID=<%=Rsbaoxiu("id")%>">签名</a>
        <%end if %>
		
		<%else%>
		       <%=Rsbaoxiu("wenyinshi")%>		
		<%end if %>
		
		
		
      </span></td>
	</tr>
<%  Rsbaoxiu.movenext
    next%>
</table></FORM>
  <br>

<div align="center" class="STYLE1">
<%if curpage=1 then%>
首页
<%else%>
<a href="?curpage=1&Grade=<%=strGrade%>&subject=<%=strsubject%>&teacher=<%=teacher%>&date1=<%=strdate1%>&date2=<%=strdate2%>">首页</a>
<%end if%>

<%if curpage=1 then%>
上一页
<%else%>
<a href="?curpage=<%=curpage-1%>&Grade=<%=strGrade%>&subject=<%=strsubject%>&teacher=<%=teacher%>&date1=<%=strdate1%>&date2=<%=strdate2%>">上一页</a>
<%end if%>

<%if Rsbaoxiu.pagecount<curpage+1 then%>
下一页
<%else%>
<a href="?curpage=<%=curpage+1%>&Grade=<%=strGrade%>&subject=<%=strsubject%>&teacher=<%=teacher%>&date1=<%=strdate1%>&date2=<%=strdate2%>">下一页</a>
<%end if%>

<%if Rsbaoxiu.pagecount<curpage+1 then%>
尾页
<%else%>
<a href="?curpage=<%=Rsbaoxiu.pagecount%>&Grade=<%=strGrade%>&subject=<%=strsubject%>&teacher=<%=teacher%>&date1=<%=strdate1%>&date2=<%=strdate2%>">尾页</a>
<%end if%>
(当前第<%=curpage%>页，共有<%=Rsbaoxiu.pagecount%>页，共有：<%=Rsbaoxiu.recordcount%>条记录)</div>

<p></p>
</div>	  </td>
  </tr>
</table>
</body>

</html>
