<%@language=vbscript codepage=936 %>
<%
option explicit
response.buffer=true	
Const PurviewLevel=2
Const CheckChannelID=4
Const PurviewLevel_Photo=1
%>
<!--#include file="inc/conn1.asp"-->
<!--#include file="inc/config.asp"-->
<!--#include file="Admin_ChkPurview.asp"-->
<!--#include file="inc/ubbcode.asp"-->
<!--#include file="inc/function.asp"-->
<!--#include file="inc/admin_code_photo.asp"-->
<%
dim strFileName,FileName
const MaxPerPage=20
dim totalPut,CurrentPage,TotalPages
dim i,j
dim keyword,strField
dim sql,rsPhotoList
dim ClassID
dim strAdmin,arrAdmin
dim tClass,ClassName,RootID,ParentID,Depth,ParentPath,Child,ChildID,tID,tChild,ClassMaster
dim ManageType
ManageType=trim(request("ManageType"))
FileName="Admin_PhotoRecyclebin.asp"
ClassID=Trim(request("ClassID"))
keyword=trim(request("keyword"))
if keyword<>"" then 
	keyword=ReplaceBadChar(keyword)
end if
strField=trim(request("Field"))

if ClassID="" then
	ClassID=0
else
	ClassID=CLng(ClassID)
end if
if ClassID>0 then
	set tClass=conn.execute("select ClassName,RootID,ParentID,Depth,ParentPath,Child,ClassMaster From PhotoClass where ClassID=" & ClassID)
	if tClass.bof and tClass.eof then
		founderr=True
		ErrMsg=ErrMsg & "<br><li>找不到指定的栏目</li>"
		Call WriteErrMsg()
		response.end
	else
		ClassName=tClass(0)
		RootID=tClass(1)
		ParentID=tClass(2)
		Depth=tClass(3)
		ParentPath=tClass(4)
		Child=tClass(5)
	end if
end if
strFileName=FileName & "?ClassID=" & ClassID & "&strField=" & strField & "&keyword=" & keyword
if request("page")<>"" then
    currentPage=cint(request("page"))
else
	currentPage=1
end if

%>
<html>
<head>
<title>回收站管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="MicroPhoto FrontPage 3.0">
<link rel="stylesheet" type="text/css" href="Admin_Style.css">
<script language=javascript src="mouse_up.js"></script>
<LINK href="css/adminstyle.css" type=text/css rel=stylesheet>
</head>
<body leftmargin=0 bottommargin=0 rightmargin=0 topmargin=0>
<BR style="OVERFLOW: hidden; LINE-HEIGHT: 3px">
<table border=0 align=center cellspacing=1 class=TableBorder cellpadding=3>	<tr>		<th>回收站管理</th>	</tr>	<tr>
	<tr>
	<td class="TableRow1">
	<fieldset style="cursor: default"><legend>&nbsp;回收站管理<a name="setting2"></a>[<a href="#top">顶部</a>]</legend><table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="TableBorder2"><br>
<SCRIPT language=javascript>
function unselectall()
{
    if(document.myform.chkAll.checked){
	document.myform.chkAll.checked = document.myform.chkAll.checked&0;
    } 	
}

function CheckAll(form)
  {
  for (var i=0;i<form.elements.length;i++)
    {
    var e = form.elements[i];
    if (e.Name != "chkAll")
       e.checked = form.chkAll.checked;
    }
  }
function ConfirmDel()
{
	if(document.myform.Action.value=="ConfirmDel")
	{
		if(confirm("确定要彻底删除选中的图片吗？一旦删除将不能恢复！"))
			return true;
		else
			return false;
	}
	else if(document.myform.Action.value=="ClearRecyclebin")
	{
		if(confirm("确定要清空回收站？一旦清空将不能恢复！"))
			return true;
		else
			return false;
	}
}
</SCRIPT>
<style type="text/css">
<!--
body {	background-color: #FFFFFF;
	margin-right: 8px;
	margin-bottom: 8px;
	margin-left: 8px;
	margin-top: 0px;
}
-->
</style>
</head>
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="1" bgcolor="#D6D5D9"></td>
    <td height="34" align=left bgcolor="#F8F8F9"><strong>&nbsp;&nbsp;管理导航：</strong><a href="Admin_PhotoRecyclebin.asp">回收站管理首页</a> | <a href="Admin_PhotoDel.asp?Action=ClearRecyclebin" onClick="return confirm('确定要清空回收站吗？一旦清空将无法恢复！');">清空回收站</a> 
      | <a href="Admin_PhotoDel.asp?Action=RestoreAll" onClick="return confirm('确定还原回收站中的所有图片？');">还原回收站中的所有图片</a></td>
    <td width="1" bgcolor="#D6D5D9"></td>
  </tr>
  <tr>
    <td width="1" bgcolor="#F8F8F9"></td>
    <td height="1" bgcolor="#D6D5D9" ></td>
    <td width="1" bgcolor="#F8F8F9"></td>
  </tr>
</table>
<table width="100%" height="8" border="0" cellpadding="0" cellspacing="0">
  <tr>
  </tr>
</table>
<table width="100%" height="40" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="22"><%call Admin_ShowPath("回收站管理")%></td>
    <td width="200" height="22" align="right">
	<select name='JumpClass' id="JumpClass" onChange="if(this.options[this.selectedIndex].value!=''){location='<%=FileName & "?ClassID="%>'+this.options[this.selectedIndex].value;}">
      <option value='' selected>跳转栏目至…</option>
	  <%call Admin_ShowClass_Option(2,0)%>
	</select>
    </td>
  </tr>
</table>
<%
sql="select P.ID,P.ClassID,C.ClassName,P.PhotoName,P.Keyword,P.Author,P.UpdateTime,P.Editor,P.Hits,P.PhotoUrl_Thumb,P.PhotoUrl_Thumbsm,P.PhotoSize,P.OnTop,P.Elite,P.Passed,P.Stars,P.PhotoLevel,P.PhotoPoint from mtv_photo P"
sql=sql & " inner join PhotoClass C on P.ClassID=C.ClassID where P.Deleted=True"
if ClassID>0 then
	if Child>0 then
		ChildID=""
		set tClass=conn.execute("select ClassID from PhotoClass where ParentID=" & ClassID & " or ParentPath like '" & ParentPath & "," & ClassID & ",%'")
		do while not tClass.eof
			if ChildID="" then
				ChildID=tClass(0)
			else
				ChildID=ChildID & "," & tClass(0)
			end if
			tClass.movenext
		loop
		sql=sql & " and P.ClassID in (" & ChildID & ")"
	else
		sql=sql & " and P.ClassID=" & ClassID
	end if
end if

if strField<>"" then
	if keyword<>"" then
		select case strField
		case "PhotoName"
			sql=sql & " and P.PhotoName like '%" & keyword & "%' "
		case "PhotoIntro"
			sql=sql & " and P.PhotoIntro like '%" & keyword & "%' "
		case "Author"
			sql=sql & " and P.Author like '%" & keyword & "%' "
		case "Editor"
			sql=sql & " and P.Editor like '%" & keyword & "%' "
		case else
			sql=sql & " and P.PhotoName like '%" & keyword & "%' "
		end select
	end if
end if
sql=sql & " order by P.ID desc"

Set rsPhotoList= Server.CreateObject("ADODB.Recordset")
rsPhotoList.open sql,conn,1,1
if rsPhotoList.eof and rsPhotoList.bof then
	totalPut=0
	if Child=0 then
		response.write "<p align='center'><br>没有任何被删除的图片！<br></p>"
	else
		response.write "<p align='center'><br>此栏目的下一级子栏目中没有任何被删除的图片！<br></p>"
	end if
else
   	totalPut=rsPhotoList.recordcount
	if currentpage<1 then
   		currentpage=1
   	end if
   	if (currentpage-1)*MaxPerPage>totalput then
   		if (totalPut mod MaxPerPage)=0 then
     		currentpage= totalPut \ MaxPerPage
	  	else
	      	currentpage= totalPut \ MaxPerPage + 1
   		end if
   	end if
    if currentPage=1 then
       	showContent
       	showpage strFileName,totalput,MaxPerPage,true,true,"张图片"
 	else
     	if (currentPage-1)*MaxPerPage<totalPut then
       	   	rsPhotoList.move  (currentPage-1)*MaxPerPage
       		dim bookmark
           	bookmark=rsPhotoList.bookmark
            showContent
            showpage strFileName,totalput,MaxPerPage,true,true,"张图片"
       	else
	        currentPage=1
           	showContent
          	showpage strFileName,totalput,MaxPerPage,true,true,"张图片"
	    end if
	end if
end if
rsPhotoList.close
set rsPhotoList=nothing  


sub showContent
   	dim PhotoNum
    PhotoNum=0
%>
<table width='100%' border="0" cellpadding="0" cellspacing="0"><tr>
    <form name="myform" method="Post" action="Admin_PhotoDel.asp" onSubmit="return ConfirmDel();">
     <td><table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC">
          <tr height="22"> 
            <td width="30" height="30" align="center" bgcolor="f2f2f2"><strong>选中</strong></td>
            <td width="25"  height="30" align="center" bgcolor="f2f2f2"><strong>ID</strong></td>
            <td width="80" height="30" align="center" bgcolor="f2f2f2" ><strong>缩略图</strong></td>
            <td height="30" align="center" bgcolor="f2f2f2" ><strong>图片名称</strong></td>
            <td width="60" height="30" align="center" bgcolor="f2f2f2" ><strong>图片作者</strong></td>
            <td width="60" height="30" align="center" bgcolor="f2f2f2" ><strong>查看次数</strong></td>
            <td width="60" height="30" align="center" bgcolor="f2f2f2" ><strong>图片属性</strong></td>
            <td width="100" height="30" align="center" bgcolor="f2f2f2" ><strong>操作</strong></td>
          </tr>
          <%do while not rsPhotoList.eof%>
          <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#BFDFFF'"> 
            <td width="30" align="center" bgcolor="#FFFFFF"><input name='ID' type='checkbox' onClick="unselectall()" id="ID" value='<%=cstr(rsPhotoList("ID"))%>'></td>
            <td width="25" align="center" bgcolor="#FFFFFF"><%=rsPhotoList("ID")%></td>
            <td width="80" align="center" bgcolor="#FFFFFF">
			  <table  border="0" align="center" cellpadding="0" cellspacing="5" class="4f">
                <tr>
                  <td width="80" height="80" align="center" bgcolor="#000000"><%response.write "<a href='Admin_PhotoShow.asp?ID=" & rsPhotoList("ID") & "'><img src='" & rsPhotoList("PhotoUrl_Thumbsm")&"" & "' border='0' width=80></a>"%></td>
                </tr>
              </table>            </td>
            <td bgcolor="#FFFFFF"> 
              <%
			if rsPhotoList("ClassID")<>ClassID then
				response.write "<a href='" & FileName & "?ClassID=" & rsPhotoList("ClassID") & "'>[" & rsPhotoList("ClassName") & "]</a>&nbsp;"
			end if
			response.write "<a href='Admin_PhotoShow.asp?ID=" & rsPhotoList("ID") & "'"
			response.write " title='图片名称：" & rsPhotoList("PhotoName") & vbcrlf & "图片作者：" & rsPhotoList("Author") & vbcrlf & "更新时间：" & rsPhotoList("UpdateTime") & vbcrlf
			response.write "查看次数：" & rsPhotoList("Hits") & vbcrlf & "关 键 字：" & mid(rsPhotoList("Keyword"),2,len(rsPhotoList("Keyword"))-2) & vbcrlf & "推荐等级："
			if rsPhotoList("Stars")=0 then
				response.write "无"
			else
				response.write string(rsPhotoList("Stars"),"★")
			end if			
			response.write vbcrlf & "下载等级："	
			if rsPhotoList("PhotoLevel")=9999 then
				response.write "游客"
			elseif  rsPhotoList("PhotoLevel")=999 then
				response.write "注册用户"
			elseif  rsPhotoList("PhotoLevel")=99 then
				response.write "收费用户"
			elseif  rsPhotoList("PhotoLevel")=9 then
				response.write "VIP用户"
			elseif  rsPhotoList("PhotoLevel")=5 then
				response.write "管理员"
			end if
			response.write vbcrlf & "查看点数：" & rsPhotoList("PhotoPoint")
			response.write "'>" & rsPhotoList("PhotoName") & "</a>"
			%>            </td>
            <td width="60" align="center" bgcolor="#FFFFFF"><%=rsPhotoList("editor") %></td>
            <td width="60" align="center" bgcolor="#FFFFFF"><%= rsPhotoList("Hits") %></td>
            <td width="60" align="center" bgcolor="#FFFFFF"> <%
			if rsPhotoList("OnTop")=true then
				response.Write "<font color=blue>顶</font> "
			else
				response.write "&nbsp;&nbsp;&nbsp;"
			end if
			if rsPhotoList("Hits")>=HitsOfHot then
				response.write "<font color=red>热</a> "
			else
				response.write "&nbsp;&nbsp;&nbsp;"
			end if
			if rsPhotoList("Elite")=true then
				response.write "<font color=green>荐</a>"
			else
				response.write "&nbsp;&nbsp;"
			end if
			%> </td>
            <td width="100" align="center" bgcolor="#FFFFFF"><a href="Admin_PhotoDel.asp?Action=ConfirmDel&ID=<%=rsPhotoList("ID")%>" onclick='return ConfirmDel();'>彻底删除</a> 
              <a href="Admin_PhotoDel.asp?Action=Restore&ID=<%=rsPhotoList("ID")%>">还原</a></td>
          </tr>
          <%
		PhotoNum=PhotoNum+1
	   	if PhotoNum>=MaxPerPage then exit do
	   	rsPhotoList.movenext
	loop
%>
        </table>
<table width="100%" height="50" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="200"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
            选中本页显示的所有图片 </td>
    <td><input name="Action" type="hidden" id="Action2" value="ConfirmDel">
              <input name="submit1" type='submit' id="submit1" onClick="document.myform.Action.value='ConfirmDel'" value='彻底删除选定的图片'>
              <input type="submit" name="Submit2" value="清空回收站"  onClick="document.myform.Action.value='ClearRecyclebin'">
              &nbsp;&nbsp;&nbsp;&nbsp; 
              <input name="Submit3" type="submit" id="Submit3"  onClick="document.myform.Action.value='Restore'" value="还原选定的图片">
              <input name="Submit4" type="submit" id="Submit4" onClick="document.myform.Action.value='RestoreAll'" value="还原所有图片"></td>
  </tr>
</table>
</td>
</form></tr></table>
<%
end sub

if ClassID>0 and Child>0 then
%>
<br>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class='border'>
  <tr height="20" class='tdbg'>
    <td width='150' align="right">【<%response.write "<a href='" & strFileName & "'>" & ClassName & "</a>"%>】子栏目导航：</td>
	<td><%call Admin_ShowChild()%></td></tr>
</table>
<%
end if
%>
<br>
<table width="100%" height="30" border="0" cellpadding="0" cellspacing="0" class="border">
  <tr>
    <td width="80" align="right"><strong>图片搜索：</strong></td>
    <td>
      <%call Admin_ShowSearchForm(FileName,2)%>
    </td>
  </tr>
</table>
</body>
</html>
<%
call CloseConn()
%>