📄 main_list_order.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/convertDate.asp"-->
<!--#include file="../script/fixNumber.asp"-->
<!--#include file="../script/trimFunction.asp"-->
<%
var strSearch;
strSearch = trim_str(String(Request("txtSearch")));
var ds;
ds = String(Request("ds"));
var oid = Request.Form("chkProID");
if(String(Request.Form('del')) == 'Xóa hóa đơn')
{
var strSQL_kho = "Delete From tblOrder Where OID IN (" + oid + ")";
oConn.Execute(strSQL_kho);
Response.Redirect("admin_done.asp?mess=Hóa đơn đã được xóa!!!&gourl=main_List_Order.asp?day=|month=|year=|lk=|txtSearch=|ds=");
}
if(String(Request.Form('luu')) == 'Lưu kho')
{
var strSQL_del = "Update tblOrder Set ODelete=0 Where OID In(" + oid + ")";
oConn.Execute(strSQL_del);
Response.Redirect("admin_done.asp?mess=Hóa đơn đã được lưu vào kho!!!&gourl=main_List_Order.asp?day=|month=|year=|lk=|txtSearch=|ds=");
}
var idComplete = Request.Form("chkOrderID");
if(String(Request.Form('update')) == 'Cập nhật thanh toán')
{
var strSQL_Complete = "Update tblOrder Set OStatus=1 Where OID In(" + idComplete + ")";
oConn.Execute(strSQL_Complete);
var rsGetOID = Server.CreateObject("ADODB.Recordset");
var strSQL_1 = "Select Distinct (OID) From tblOrderDetail Where OID In(" + idComplete + ")";
rsGetOID.Open(strSQL_1,oConn,3,1);
while((!rsGetOID.BOF)&&(!rsGetOID.EOF))
{
var rsGetPID = Server.CreateObject("ADODB.Recordset");
var strSQL_2 = "Select PID, OQuantity From tblOrderDetail Where OID=" + parseInt(rsGetOID.Fields("OID"));
rsGetPID.Open(strSQL_2,oConn,3,1);
while((!rsGetPID.BOF)&&(!rsGetPID.EOF))
{
var strSQL_update = "Update tblProduct Set PBestSeller=PBestSeller+" + parseInt(rsGetPID.Fields("OQuantity"));
strSQL_update+= " Where PID='" + String(rsGetPID.Fields("PID")) + "'";
oConn.Execute(strSQL_update);
rsGetPID.MoveNext();
}
rsGetOID.MoveNext();
}
rsGetPID.Close();
rsGetOID.Close();
Response.Redirect("admin_done.asp?mess=Hóa đơn đã được xử lý!!!&gourl=main_List_Order.asp?day=|month=|year=|lk=|txtSearch=|ds=");
}
var rsO = Server.CreateObject("ADODB.Recordset");
var strSQL;
var today = new Date();
var maxYear = today.getYear();
var fDay = String(Request('day'));
var fMonth = String(Request('month'));
var fYear = String(Request('year'));
strLK = String(Request("listCust"));
if((strLK=='undefined')||(strLK=="")||(strLK==null))
{
strLK = 'all';
}
strSQL = "Select Distinct (OID), ODate, CName, CEmail, OStatus, OTotal From vwOrder Where ";
if(strLK=='remove'){strSQL+=" ODelete=0";}else{strSQL+=" ODelete=1";}
if((fDay!="")&&(fMonth=="")&&(fYear==""))
{
strSQL+= " And Day(ODate)='" + fDay + "'";
}
if((fDay=="")&&(fMonth!="")&&(fYear==""))
{
strSQL+= " And Month(ODate)='" + fMonth + "'";
}
if((fDay=="")&&(fMonth=="")&&(fYear!=""))
{
strSQL+= " And Year(ODate)='" + fYear + "'";
}
if((fDay!="")&&(fMonth!="")&&(fYear==""))
{
strSQL+= " And Day(ODate)='" + fDay + "' AND Month(ODate)='" + fMonth + "'";
}
if((fDay!="")&&(fMonth=="")&&(fYear!=""))
{
strSQL+= " And Day(ODate)='" + fDay + "' AND Year(ODate)='" + fYear + "'";
}
if((fDay=="")&&(fMonth!="")&&(fYear!=""))
{
strSQL+= " And Month(ODate)='" + fMonth + "' AND Year(ODate)='" + fYear + "'";
}
if((fDay!="")&&(fMonth!="")&&(fYear!=""))
{
strSQL+= " And Day(ODate)='" + fDay + "' AND Month(ODate)='" + fMonth + "' AND Year(ODate)='" + fYear + "'";
}
if(strLK==1)
{
strSQL+= " And OStatus=1";
}
if(strLK==0)
{
strSQL+= " And OStatus=0 And ODelete=1";
}
if(strSearch != "")
{
if(ds == "code")
{
strSQL+= " And OID =" + parseInt(strSearch);
}
if(ds == "name")
{
strSQL+= " And CName Like N'%" + strSearch + "%' ";
}
}
strSQL+= " Order By ODate Desc,OID Desc";
rsO.Open(strSQL,oConn,3,1);
rsO.PageSize=10;
var totalPage=rsO.PageCount;
var totalRecord = rsO.RecordCount;
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>List Order</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">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<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">LIỆT KÊ HÓA ĐƠN</font></strong>
</td>
</tr>
</table></td>
</tr>
<tr>
<form name="frmlist" action="main_List_Order.asp" method="post">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="middle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"></td>
<td width="67%" height="8"></td>
</tr>
</table></td>
</tr>
<tr>
<td style="padding-left:5px; padding-right:5px; ">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<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>..:: Xem hóa đơn ngày</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> tháng</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> năm</strong>
<select name="year" class="textbox">
<option value="">YEAR</option>
<%
var iYear;
for(iYear=2000;iYear<=maxYear;iYear++)
{
%>
<option value="<%=iYear%>" <%if(parseInt(fYear)==iYear){%> selected <%}%>>
<%=iYear%>
</option>
<%}%>
</select> <input type="submit" name="btnView" value="XEM"></td>
</tr>
</table></td>
</tr>
<script>
function checkSearchOrder()
{
if((isNaN(document.frmlist.txtSearch.value))&&(document.frmlist.ds.value=='code'))
{
alert("Mã hóa đơn phải là 1 số nguyên! Xin hãy nhập lại");
document.frmlist.txtSearch.focus();
return false;
}
else
{
document.frmlist.submit();
return true;
}
}
</script>
<tr>
<td align="left" valign="middle" style="padding-top:15px; " class="list">
<font face="arial, tahoma, verdana" size="2">Liệt
kê hoá đơn </font> <select name="listCust" size="1" onChange="change();">
<option value="all" <%if(String(Request('listCust'))=='all'){%> selected <%}%>>Tất
cả</option>
<option value="1" <%if(String(Request('listCust'))=='1'){%> selected <%}%>>Đã
thanh toán</option>
<option value="0" <%if(String(Request('listCust'))=='0'){%> selected <%}%>>Chưa
thanh toán</option>
<option value="remove" <%if(String(Request('listCust'))=='remove'){%> selected <%}%>>Trong
kho</option>
</select> </td>
</tr>
<tr>
<td align="left" valign="top" style="padding-top:5px; " class="list"> </td>
</tr>
<tr>
<td align="left" valign="top" style="padding-left:5px; " class="list">
<font face="arial, tahoma, verdana" size="2">Từ
khóa tìm kiếm </font> <input type="text" size="18" class="textbox" name="txtSearch" value="<%=strSearch%>">
<font face="arial, tahoma, verdana" size="2">Theo</font>
<select name="ds" size="1" class="textbox">
<option value="name" <%if(ds=='name'){%> selected <%}%>>Tên khách hàng</option>
<option value="code" <%if(ds=='code'){%> selected <%}%>>Mã hóa đơn</option>
</select>
<script language="jscript">
function callReset()
{
document.frmlist.txtSearch.value = "";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -