📄 invoicecheckprint.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
sysid=1
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "payment","read"
set objcheck=nothing
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
if request.querystring("accountid")<>"" then
strwhere =" and accountid="&request.querystring("accountid")
straccount=request.querystring("accountid")
straccountname=getfieldvalue("account","accountid",request.querystring("accountid"),"account")
end if
if request.Form("account")<>"" then
strwhere =" and accountid="&request.Form("account")
straccount=request.Form("account")
straccountname=getfieldvalue("account","accountid",request.Form("account"),"account")
end if
if request("status")="" then
strwhere=strwhere&" and status='未销'"
elseif request("status")="全部" then
strwhere=strwhere&" and status like '%%'"
else
strwhere=strwhere&" and status='"&request("status")&"'"
end if
if request("fromdate")<>"" then
strwhere=strwhere&" and createdate>='"&request("fromdate")&"' "
end if
if todate<>"" then
strwhere=strwhere&" and createdate<='"&todate&"' "
end if
sql="select * from v_invoicecheck_all where sysaccountid="&sysid&" "&strwhere&" order by createdate"
'response.Write(sql)
rs.Open sql,conn,1,1
%>
<html>
<head>
<!--
<LINK href="../global.css" rel=STYLESHEET type=text/css>
-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>开票对帐单</title>
</head>
<script language=javascript>
function showit(objname,imgn){
if (eval(objname+'.style.display=="block"') == true)
{
eval(objname+'.style.display="none";');
eval('IMG'+objname+'.style.display="block";');
eval('IMG1'+objname+'.style.display="none";');
//alert('IMG'+objname+'.src = "../images/button2.gif";');
//eval('IMG'+objname+'.src = "../images/button2.gif";');
}
else
{
eval(objname+'.style.display="block";');
eval('IMG'+objname+'.style.display="none";');
eval('IMG1'+objname+'.style.display="block";');
//alert('IMG'+objname+'.src = "../images/button1.gif";');
//eval('IMG'+objname+'.src = "../images/button1.gif";');
}
}
</script>
<script language=javascript src="../tools/newcalendar.js"></script>
<body leftmargin="10" rightmargin="0" topmargin="10">
<form name="form1" method="post" action="">
<table width="100%" border="0">
<tr>
<td><div align="center"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=request("accountname")%>
开票对帐单
<%if request("fromdate")<>"" or request("todate")<>"" then response.write "<br>"&request("fromdate")&" - "&request("todate")%>
</font></div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#000000">
<tr bgcolor="efefef">
<td width="12%" height=15 align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">发生日期</font></td>
<td width="12%" height=15 align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">应结日期</font></td>
<td width="10%" height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">凭证编号</font></td>
<td height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">摘要</font></td>
<td width="10%" height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">开票增加</font></td>
<td width="12%" height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">开票减少</font></td>
<td width="10%" height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">开票余额</font></td>
<td width="8%" height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">销账</font></td>
<td width="12%" height="15" align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">销账日期</font></td>
</tr>
<%
sql="select sum(invoiceincrease) as allinvoiceincrease,sum(invoicedecrease) as allinvoicedecrease from v_invoicecheck_all where sysaccountid="&sysid&" and accountid="&request("accountid")&" and createdate<'"&request("fromdate")&"'"
'response.write sql
set rsq=conn.execute(sql)
if isnull(rsq("allinvoiceincrease")) then a=0 else a=csng(rsq("allinvoiceincrease"))
if isnull(rsq("allinvoicedecrease")) then b=0 else b=csng(rsq("allinvoicedecrease"))
x=a-b
'x=csng(rsq("allinvoiceincrease"))-csng(rsq("allinvoicedecrease"))
%>
<tr bgcolor="#FFFFFF">
<td align=center> </td>
<td align=center height=18> </td>
<td align=center> </td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">此前余额</font></td>
<td align=center> </td>
<td align=center> </td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=x%></font></td>
<td align=center> </td>
<td align=center> </td>
</tr>
<%
i=1
do while not rs.EOF
if rs("documenttype")="invoice" then
x=x-csng(rs("invoicedecrease"))
else
x=x+csng(rs("invoiceincrease"))
end if
%>
<tr bgcolor="#FFFFFF">
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("createdate")%></font></td>
<td align=center height=18><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("closedate")%> </font></td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("documentno")%></font></td>
<td align=center> <font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%if rs("type")="应收帐款" then%>
</font> <table width=100% border="0" cellpadding="0" cellspacing="0">
<tr id="IMGtr1<%=i%>" style="display:none">
<td width=90% align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("type")%></font></td>
<td width=10% align=right><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><a href="javascript:showit('tr1<%=i%>',1)" title="显示发货明细"><img src="../images/button1.gif" border=0>
</font>
<td></tr>
<tr id="IMG1tr1<%=i%>" style="display:block">
<td width=90% align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("type")%></font></td>
<td width=10% align=right><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><a href="javascript:showit('tr1<%=i%>',1)" title="隐藏发货明细"><img src="../images/button2.gif" border=0></a></font></td>
</tr>
</table>
<font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%else%>
<%=rs("type")%>
<%end if%>
</font></td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%if rs("invoiceincrease")<>"" then response.write formatnumber(rs("invoiceincrease"),2)%>
</font></td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%if rs("invoicedecrease")<>"" then response.write formatnumber(rs("invoicedecrease"),2)%>
</font></td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=formatnumber(x,2)%></font></td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("status")%></font></td>
<td align=center><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rs("verifdate")%> </font></td>
</tr>
<%if rs("type")="应收帐款" then%>
<tr bgcolor="#FFFFFF" border=0 id='tr1<%=i%>' style=display:block>
<td colspan=10> <font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%
set rsdeliverline=conn.execute("select * from v_MaterialTransaction where (orderpaymentid="&rs("id")&")")
%>
</font> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">
<tr>
<td width="6%" height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">序号</font></td>
<td height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">型号</font></td>
<td width="8%" height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">数量</font></td>
<td width="10%" height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">价格</font></td>
<td width="12%" height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">发货金额</font></td>
<td width="12%" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">开票金额</font></td>
<td width="10%" height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">收款日期</font></td>
<td width="12%" height="15" align=center bgcolor="DEDFDE"><font size="2" face="Geneva, Arial, Helvetica, sans-serif">收款状态</font></td>
</tr>
<%j=1
do while not rsdeliverline.EOF
%>
<tr>
<td height="18" align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=j%></font></td>
<td align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rsdeliverline("model")%></font></td>
<td align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rsdeliverline("qty")%></font></td>
<td align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=formatnumber(rsdeliverline("price"),2)%></font></td>
<td align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=formatnumber(csng(rsdeliverline("qty"))*csng(rsdeliverline("price")),2)%></font></td>
<td align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=formatnumber(rsdeliverline("receiveamount"),2)%></font></td>
<td align=center bgcolor="efefef"><font size="2" face="Geneva, Arial, Helvetica, sans-serif"><%=rsdeliverline("invoiceverifydate")%></font></td>
<td align=center bgcolor="efefef"> <font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%if rsdeliverline("invoicestatus")="已开" then%>
<input type=checkbox name="invoicestatus<%=rs("id")%>" value=<%=rsdeliverline("transactid")%> checked>
<%else%>
<input type=checkbox name="invoicestatus<%=rs("id")%>" value=<%=rsdeliverline("transactid")%>>
<%end if%>
</font></td>
</tr>
<%
j=j+1
rsdeliverline.MoveNext
loop
rsdeliverline.Close
set rsdeliverline=nothing
%>
</table></td>
</tr>
<%end if%>
<%
i=i+1
rs.MoveNext
loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="50">
<td> </td>
</tr>
</table>
<font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<%
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
<input type=hidden name=statusindex>
</font>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -