<!--#include file="admin_start.asp" -->

<%
set rs_t=conn.execute("select sort_name from jins_review_sort where sort_id="&request("sort_id")&" ")
if not rs_t.eof then
sort_name=rs_t("sort_name")
end if
set rs_t=nothing

select case sort_name
case "goods"
	sort_name="goods_name"
	sort_table="goods"
	sort_description="商品名称"
	sort_url="admin_goods_list.asp?s_n=3,goods_id,0&goods_id="

case "news"
	sort_name="news_title"
	sort_table="news"
	sort_description="新闻标题"
	sort_url="admin_info_news_list.asp?s_n=3,news_id,0&news_id="
	
case else
	sort_name=""
	sort_table=""
	sort_description=""
	sort_url=""

end select
%>
<body topmargin="30" marginwidth="10" marginheight="10">
<div id=search_open style='display:none'>
<table cellspacing=3 cellpadding=3 width=98% bgcolor='#f7f7f7' align=center style='border:1px dashed #b7b7b7 '>
<form name=search_review method=get action='admin_info_review_list.asp'>	
<tr>
	<td valign='middle' align=right width=10% >评论标题:</td>
	<td valign='middle' align=left width=40% >
	<input size=45 name=review_title value='<%=request("review_title")%>' >
	</td>
	<td valign='middle' align=right width=10% >作者:</td>
	<td  valign='middle' align=left width=40% >
	<input size=45 name=review_writer value='<%=request("review_writer")%>' >
	</td>
</tr>
<tr>
	<td valign='middle' align=right width=10% >所属分类:</td>
	<td  valign='middle' align=left width=40% >
	<select name=sort_id >
	<%
	dim s
	set s=MySys.temp.search
	if request("sort_id")="" then
	s.list_Sort "", "jins_review_sort",0,"根目录|0"
	else
	s.list_Sort "", "jins_review_sort",0,"根目录|"&request("sort_id")
	end if
	response.write s.sort_list
	set s=nothing
	%>
	</select>
	</td>
	<td  valign='middle' align=right width=10% >加入时间:</td>
	<td  valign='middle' align=left width=40% >
	 从 
	<input size=18 name=review_addtime_s value='<%=request("review_addtime_s")%>' > 
	 到 
	<input size=18 name=review_addtime_e value='<%if request("review_addtime_e")<>"" then response.write request("review_addtime_e") else response.write now() %>' > 
	 </td>
</tr>
<tr>
	<td  valign='middle' align=right width=10% >是否审核:</td>
	<td  valign='middle' align=left width=15% >
	<select name=review_verify >
	<option value='' <%if request("review_verify")="" then response.write "selected"%>>随便</option>
	<option value=1 <%if request("review_verify")="1" then response.write "selected"%>>通过</option>
	<option value=0 <%if request("review_verify")="0" then response.write "selected"%>>等待</option>
	</select>
	</td>
	<td  valign='middle' align=right width=10% >浏览量:</td>
	<td  valign='middle' align=left width=40% >
	 从 
	<input size=18 name=review_clicknum_s value='<%=request("review_clicknum_s")%>' > 
	 到 
	<input size=18 name=review_clicknum_e value='<%=request("review_clicknum_e")%>' > 
	 </td>
</tr>
<tr>
	<td  valign='middle' align=right width=10% >回复日期:</td>
	<td  valign='middle' align=left width=15% >
	 从 
	<input size=18 name=review_reply_addtime_s value='<%=request("review_reply_addtime_s")%>' > 
	 到 
	<input size=18 name=review_reply_addtime_e value='<%if request("review_reply_addtime_e")<>"" then response.write request("review_reply_addtime_e") else response.write now() %>' > 
	</td>
	<td  valign='middle' align=right width=10% ><%=sort_description%>:</td>
	<td  valign='middle' align=left width=40% >
	<input size=18 name=name_id value='<%=request("name_id")%>' > 
	 </td>
</tr>
<tr>
<td height='1' width='100%' colspan='10' background='images/dot03.gif'></td>
</tr>
<tr>
<td height='1' width='100%' colspan='10' background='images/dot03.gif'></td>
</tr>
<tr>
	<td  valign='middle' colspan=10 align=center width=100% >
	<input type=hidden  name=s_n value="0,review_title,1|5,review_reply_addtime|5,review_addtime|1,review_verify,0|6,sort_id,0" >
	<input type=image align=absmiddle border=0 src='Images/search.jpg'  alt='开始搜索！！'  hspace='3' ></td>
</tr>
</form>
</table>
<br>
</div>
<%

c_order="评论标题$review_title|加入日期$review_addtime|回复日期$review_reply_addtime|作者$review_writer|"&sort_description&"$id|是否审核$review_open|是否回复$review_reply,升序$|降序$desc"

c_h="<form name=jins_review_list action='admin_info_review_list_handle.asp' method=post>"
c_h=c_h+"<table cellspacing=0 cellpadding=0 align=center width=98% bgcolor=#F7F7F7 style='border-top: 1px solid #EBEBEB; '>"
c_h=c_h+"<tr>"
c_h=c_h+"<td height=30 width='5%' align=center>选择</td>"
c_h=c_h+"<td height=30 width='24%' align=left>评论标题</td>"
c_h=c_h+"<td height=30 width='10%' align=left>作者</td>"
if sort_description<>"" then c_h=c_h+"<td height=30 width='10%' align=left>"&sort_description&"</td>"
c_h=c_h+"<td height=30 width='17%' align=center>加入日期</td>"
c_h=c_h+"<td height=30 width='17%' align=center>回复日期</td>"
c_h=c_h+"<td height=30 width='7%' align=center>审核</td>"
c_h=c_h+"<td height=30 width='5%' align=center>回复</td>"
c_h=c_h+"<td height=30 width='5%' align=center>删除</td>"
c_h=c_h+"</tr>"
c_h=c_h+"<tr>"
c_h=c_h+"<td height='1' width='100%' colspan='10' background='images/dot03.gif'></td>"
c_h=c_h+"</tr>"
c_h=c_h+"</table>"

c="<table cellspacing=0 cellpadding=0 width=98% align=center >"
c=c+"<tr onmouseover=""this.style.background='#ebebeb';"" onmouseout=""this.style.background='#ffffff';"">"
c=c+"<td height=30  width='5%' align=center>"
c=c+"<input type=checkbox name=ids value='$$review_id$$'> "
c=c+"</td>"

c=c+"<td height=30  width='24%' align=left >"
c=c+"<font title='[$$review_title$$]' style='fontsize:10pt'>$$review_title,20$$</font>"
c=c+"</td>"

c=c+"<td height=30  width='10%' align=left >"
c=c+"<a title='[$$review_writer$$] > 点击察看此用户资料！' href='admin_user_customer_list.asp?s_n=3,customer_reg_name,1&customer_reg_name=$$customer_name$$'>"
c=c+"$$review_writer$$"
c=c+"</a>"
c=c+"</td>"

c=c+"<td height=30  width='10%' align=left>"
if sort_table<>"" then
c=c+"<%"
c=c+"set rs_ttt=conn.execute(""select "&sort_name&" from jins_"&sort_table&"_list where "&sort_table&"_id=$$id$$ "")"&vbcrlf
c=c+"if not rs_ttt.eof  then response.write ""<a title='[""&rs_ttt("""&sort_name&""")&""]点击查看详情' href='"&sort_url&"$$id$$' >""&left(rs_ttt("""&sort_name&"""),10)&""</a>"""&vbcrlf
c=c+"set rs_ttt=nothing"&vbcrlf
c=c+"%\>"&vbcrlf
end if
c=c+"</td>"

c=c+"<td height=30  width='17%' align=center>"
c=c+"$$review_addtime$$"
c=c+"</td>"

c=c+"<td height=30  width='17%' align=center><font color=blue>"
c=c+"$$review_reply_addtime$$"
c=c+"</font></td>"


c=c+"<td height=30  width='7%' align=center>"
c=c+"<select name=review_verify_$$review_id$$ >"
c=c+"<option value=1 <%if $$review_verify$$=1 then response.write ""selected""%\> >通过</option>"
c=c+"<option value=0 <%if $$review_verify$$=0 then response.write ""selected""%\> >等待</option>"
c=c+"</select>"
c=c+"</td>"

c=c+"<td height=30  width='5%' align=center>"
c=c+"<a title='点击回复此评论！* 表示此评论尚未回复' href='admin_info_review_edit.asp?id=$$review_id$$'><img hspace=3 border='0' src='Images/icon07_o.gif' align='bottom' alt='评论详细设置！'></a>"
c=c+"<% if ""$$review_reply$$""="""" then response.write ""<font color=red>*</font>"" %\>"
c=c+"</td>"
		
c=c+"<td height=30 width='5%' align=center>"
c=c+"<a title='点击删除此项！' href='admin_info_review_edit_handle.asp?action=delete&ids=$$review_id$$'>"
c=c+"<img border='0' src='Images/delete.gif' align='bottom' alt='点击删除此项！'></a>"
c=c+"</td></tr>"
c=c+"<tr>"
c=c+"<td height='1' width='100%' colspan='20' background='images/dot03.gif'></td>"
c=c+"</tr>"
c=c+"</table>"



dim ins(2)
dim sql

sql=MySys.search(trim(request("s_n")))

if sql<>"" then sql=" where 1=1 "&sql

if request("name_id")<>"" and sort_table<>"" then
	set rs_t=conn.execute("select "&sort_table&"_id from jins_"&sort_table&"_list where "&sort_name&"='"&request("name_id")&"' ")
	if not rs_t.eof then
	sql=sql+" and id="&rs_t(sort_table&"_id")&" "
	else
	sql=sql+"and 1=2"
	end if
end if
'response.write sql
'response.end
MySys.ListThings c_order,c_h,c,sql,"jins_review_list","review_id",ins
%>
<!--#include file="admin_end.asp" -->