📄 main_list_feedback.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/convertDate.asp"-->
<%
var rsF = Server.CreateObject("ADODB.Recordset");
var strSQL;
var today = new Date();
var maxYear = today.getYear();
var fDay = String(Request('day'));
if(fDay == "undefined"){fDay='';};
var fMonth = String(Request('month'));
if(fMonth == "undefined"){fMonth='';};
var fYear = String(Request('year'));
if(fYear == "undefined"){fYear='';};
strSQL = "Select FID, FName, FEmail, FContent, FDate From vwFeedBack ";
if((fDay!="")&&(fMonth=="")&&(fYear==""))
{
strSQL+= " Where Day(FDate)='" + fDay + "'";
}
if((fDay=="")&&(fMonth!="")&&(fYear==""))
{
strSQL+= " Where Month(FDate)='" + fMonth + "'";
}
if((fDay=="")&&(fMonth=="")&&(fYear!=""))
{
strSQL+= " Where Year(FDate)='" + fYear + "'";
}
if((fDay!="")&&(fMonth!="")&&(fYear==""))
{
strSQL+= " Where Day(FDate)='" + fDay + "' AND Month(FDate)='" + fMonth + "'";
}
if((fDay!="")&&(fMonth=="")&&(fYear!=""))
{
strSQL+= " Where Day(FDate)='" + fDay + "' AND Year(FDate)='" + fYear + "'";
}
if((fDay=="")&&(fMonth!="")&&(fYear!=""))
{
strSQL+= " Where Month(FDate)='" + fMonth + "' AND Year(FDate)='" + fYear + "'";
}
if((fDay!="")&&(fMonth!="")&&(fYear!=""))
{
strSQL+= " Where Day(FDate)='" + fDay + "' AND Month(FDate)='" + fMonth + "' AND Year(FDate)='" + fYear + "'";
}
strSQL+= " Order By FDate Desc, FID Desc"
rsF.Open(strSQL,oConn,3,1);
rsF.PageSize=10;
var totalPage=rsF.PageCount;
var totalRecord = rsF.RecordCount;
%>
<%
if(Request.Form("delSome")=="Xóa ý kiến")
{
var fCode = Request.Form("chkProID");
var strSQL;
var hdPage = parseInt(Request.Form('hdPage'));
if(hdPage == totalPage)
{
hdPage = hdPage-1;
}
strSQL="Delete From tblFeedBack Where FID IN (" + fCode + ")";
oConn.Execute(strSQL);
Response.Redirect("admin_done.asp?mess=Ý kiến đã được xóa!!!&gourl=main_List_Feedback.asp?fDay=" + fDay + "|fMonth=" + fMonth + "|fYear=" + fYear + "|page=" + hdPage);
}
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>List FeedBack</title>
<script src="lib/checkAll.js"></script>
<body topmargin="0" rightmargin="0" leftmargin="0" bottommargin="0">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="images/menu_left_bg.gif">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="160" background="images/menu_left_bg.gif" style="background-repeat:repeat "><!--#include file="lib/inc_menuleft.asp"--></td>
<td align="left" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="frmlist" action="main_List_Feedback.asp" method="post">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top" bgcolor="#004182" style="padding-top:5px; padding-bottom:10px; ">
<strong><font color="#FFFFFF" face="arial, tahoma, verdana"; size="5">DANH SÁCH Ý KIẾN PHẢN HỒI</font></strong>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%" height="24" align="right" valign="bottom"><font face="arial, tahoma, verdana">
<strong><font face="arial, tahoma, verdana" size="2">..:: Thống kê theo ngày</font></strong>
</font></td>
<td style="padding-left:10px; " valign="middle"><select name="day" size="1" class="textbox">
<option value="">DAY</option>
<%
var iDay;
for(iDay=1;iDay<=31;iDay++)
{
%>
<option value="<%=iDay%>" <%if(parseInt(fDay)==iDay){%> selected <%}%>><%if(iDay>=10){Response.Write(iDay);}else{Response.Write('0'+iDay);}%></option>
<%}%>
</select>
<strong> <font face="arial, tahoma, verdana" size="2">tháng</font></strong>
<select name="month" size="1" class="textbox">
<option value="">MONTH</option>
<%
var iMonth;
for(iMonth=1;iMonth<=12;iMonth++)
{
%>
<option value="<%=iMonth%>" <%if(parseInt(fMonth)==iMonth){%> selected <%}%>><%if(iMonth>=10){Response.Write(iMonth);}else{Response.Write('0'+iMonth);}%></option>
<%}%>
</select>
<strong> <font face="arial, tahoma, verdana" size="2">năm</font></strong>
<select name="year" class="textbox">
<option value="">YEAR</option>
<%
var iYear;
for(iYear=2005;iYear<=maxYear;iYear++)
{
%>
<option value="<%=iYear%>" <%if(parseInt(fYear)==iYear){%> selected <%}%>><%=iYear%></option>
<%}%>
</select>
<input type="submit" name="btnView" value="XEM">
<input type="hidden" name="hdPage" value="<%=Request.QueryString('page')%>">
<input type="hidden" name="hdList" value="<%=Request.QueryString('list')%>">
<input type="hidden" name="hiddenField">
</td>
</tr>
</table></td>
</tr>
<tr>
<td align="right" valign="top" style="padding-right:5px; " class="list">>>Tổng số <strong><%=totalRecord%></strong> ý kiến phản hồi</td>
</tr>
<%
var intCurrentPage;
var i;
if(isNaN(Request.QueryString("page")))
{
intCurrentPage = 1;
}
else
{
intCurrentPage = parseInt(Request.QueryString("page"));
}
if (totalPage > 0)
{
rsF.AbsolutePage = parseInt(intCurrentPage);
}
else
{
intCurrentPage = 0;
}
i=1;
var n=1;
if(totalRecord==0)
{
%>
<tr>
<td align="center" valign="middle" style="padding-top:5px; " class="list">
<%
Response.Write("<font size=3><strong>Không có ý kiến nào trong ngày hôm nay!</strong></font>");
%>
</td>
</tr>
<%}
else
{
%>
<tr>
<td align="left" valign="top" style="padding-left:5px; padding-right:5px; ">
<table style=" border:1px solid; border-collapse:collapse" width="100%" border="1" bordercolor="#0066CC" cellspacing="0" cellpadding="4">
<tr align="center" valign="top" bgcolor="#FCFCFC">
<td width="12%" align="center" valign="middle"><strong><font face="arial, tahoma, verdana" size="2">Ngày</font></strong></td>
<td width="17%"><strong><font face="arial, tahoma, verdana" size="2">Tên khách hàng</font></strong></td>
<td width="24%"><strong><font face="arial, tahoma, verdana" size="2">Email</font></strong></td>
<td width="42%"><strong><font face="arial, tahoma, verdana" size="2">Nội dung</font></strong></td>
<td width="5%"><input name="chkAll" type="checkbox" id="chkAll" value="checkbox" <%if((rsF.BOF)&&(rsF.EOF)){%> disabled <%}%> onClick="checkall();"></td>
</tr>
<%
while((!rsF.BOF)&&(!rsF.EOF))
{
if((n%2)==0)
{
%>
<tr>
<td align="left" valign="middle" class="list"><%=convertDate(rsF.Fields('FDate'))%></td>
<td align="left" class="list"><strong><%=rsF.Fields('FName')%></strong></td>
<td align="left" class="list"><%=rsF.Fields('FEmail')%></td>
<td align="left" class="list"><%=rsF.Fields('FContent')%></td>
<td align="center" class="list"><input name="chkProID" type="checkbox" value="<%=rsF.Fields("FID")%>" onClick="docheckone();"></td>
</tr>
<%
} else {
%>
<tr bgcolor="#FFEFBF">
<td align="left" valign="middle" class="list"><%=convertDate(rsF.Fields('FDate'))%></td>
<td align="left" class="list"><strong><%=rsF.Fields('FName')%></strong></td>
<td align="left" class="list"><%=rsF.Fields('FEmail')%></td>
<td align="left" class="list"><%=rsF.Fields('FContent')%></td>
<td align="center" class="list"><input name="chkProID" type="checkbox" value="<%=rsF.Fields("FID")%>" onClick="docheckone();"></td>
</tr>
<%
}
if(i==rsF.PageSize)
{
break;
}
i++;
n++;
rsF.MoveNext();
}
}
%>
</table></td>
</tr>
<tr>
<td align="right" valign="bottom" style="padding-right:3px; padding-bottom:5px; padding-top:5px; ">
<input title="Xóa ý kiến" name="delSome" type="submit" value="Xóa ý kiến" <%if ((rsF.EOF)&&(rsF.BOF)){%> disabled <%}%> onClick="return checkInput(this);"></td>
</tr>
<%
if (rsF.PageCount > 1){
%>
<tr>
<td align="center" valign="bottom">
<%
var intCount;
if(intCurrentPage>1)
Response.Write("<a href=?page=" + (intCurrentPage-1) + "&day=" + String(Request('day')) + "&month=" + String(Request('month')) + "&year=" + String(Request('year')) + ">Trước</a>" + " |");
else
Response.Write("<font color='#999999' size='2'>Trước</font> |");
for(intCount = 1;intCount<=rsF.PageCount;intCount++)
{
if (intCount == intCurrentPage)
Response.Write("<font color='#DD0000' size='2'>" + " " + intCount + "</font>" + " | ");
else{
Response.Write("<a href=?page=" + intCount + "&day=" + String(Request('day')) + "&month=" + String(Request('month')) + "&year=" + String(Request('year')) + ">" + " " + intCount + "</a> " + " | ");
}
}
if(intCurrentPage!=rsF.PageCount)
Response.Write("<a href=?page=" + (intCurrentPage+1) + "&day=" + String(Request('day')) + "&month=" + String(Request('month')) + "&year=" + String(Request('year')) + ">Sau</a>");
else
Response.Write(" <font color='#999999' size='2'>Sau</font>");
%>
</td>
</tr>
<tr>
<td align="center" valign="top">
<font color="darkblue" face="arial, tahoma, verdana" size="2">Trang <%=intCurrentPage%> / <%=rsF.PageCount%></font>
</td>
</tr>
<%
}
rsF.Close();
oConn.Close();
%>
</table></td>
</tr>
</form>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -