download_excel.php
<?php $sql_excel="";
if(isset($_SESSION["excel"]))
{
$sql_excel=$_SESSION["excel"];
}
unset($_SESSION["excel"]);
$conn=mysql_connect("localhost","root","admin");
mysql_select_db("sql1");
$result=mysql_query($sql_excel);
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=export_data.xls");
$result=mysql_query($sql_excel);
echo "id"."\t";
echo "收款合同号"."\t";
echo "渠道名称"."\t";
echo "累计渠道代收金额"."\t";
echo "累计渠道成本"."\t";
echo "累计调整渠道成本"."\t";
echo "累计应收账款"."\t";
echo "累计回款"."\t";
echo "累计未回款"."\t";
echo "当月渠道代收金额"."\t";
echo "当月渠道成本"."\t";
echo "当月调整渠道成本(元)"."\t";
echo "当月应收账款"."\t";
echo "当月回款"."\t";
echo "当月未回款"."\t";
echo "\n";
$sum_channel_money=0;
$sum_add_channel_cost=0;
$sum_channel_change_cost=0;
$sum_add_accounts=0;
$sum_add_back_money=0;
$sum_add_noback_money=0;
$sum_month_channel_money=0;
$sum_month_channel_cost=0;
$sum_month_channel_change_cost=0;
$sum_month_accounts=0;
$sum_month_back_money=0;
$sum_month_noback_money=0;
while($out=mysql_fetch_array($result))
{
// foreach ($out as $values)
// echo $values."\t";
// echo "\n";
echo $out["id"]."\t";
echo $out['collection_contract_id']."\t";
echo $out['channel_name']."\t";
echo $out['channel_money']."\t";
$sum_channel_money=$sum_channel_money+$out['channel_money'];
echo $out['add_channel_cost']."\t";
$sum_add_channel_cost=$sum_add_channel_cost+$out['add_channel_cost'];
echo $out['add_channel_change_cost']."\t";
$sum_channel_change_cost=$sum_channel_change_cost+$out['add_channel_change_cost'];
echo $out['add_accounts']."\t";
$sum_add_accounts=$sum_add_accounts+$out['add_accounts'];
echo $out['add_back_money']."\t";
$sum_add_back_money=$sum_add_back_money+$out['add_back_money'];
echo $out['add_noback_money']."\t";
$sum_add_noback_money=$sum_add_noback_money+$out['add_noback_money'];
echo $out['month_channel_money']."\t";
$sum_month_channel_money=$sum_month_channel_money+$out['month_channel_money'];
echo $out['month_channel_cost']."\t";
$sum_month_channel_cost=$sum_month_channel_cost+$out['month_channel_cost'];
echo $out['month_channel_change_cost']."\t";
$sum_month_channel_change_cost=$sum_month_channel_change_cost+$out['month_channel_change_cost'];
echo $out['month_accounts']."\t";
$sum_month_accounts=$sum_month_accounts+$out['month_accounts'];
echo $out['month_back_money']."\t";
$sum_month_back_money=$sum_month_back_money+$out['month_back_money'];
echo $out['month_noback_money']."\t";
$sum_month_noback_money=$sum_month_noback_money+$out['month_noback_money'];
echo "\n";
}
echo "总计"."\t";
echo ""."\t";
echo ""."\t";
echo $sum_channel_money."\t";
echo $sum_add_channel_cost."\t";
echo $sum_channel_change_cost."\t";
echo $sum_add_accounts."\t";
echo $sum_add_back_money."\t";
echo $sum_add_noback_money."\t";
echo $sum_month_channel_money."\t";
echo $sum_month_channel_cost."\t";
echo $sum_month_channel_change_cost."\t";
echo $sum_month_accounts."\t";
echo $sum_month_back_money."\t";
echo $sum_month_noback_money."\t";
?>
index2.html
html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script>
function submit_query()
{
var time2=document.getElementById("time2").value;
var key=document.getElementById("key").value;
// pattern_time2=/^[0-9A-Za-z]+$/;
// if(pattern_time2.test(time2)==false)
// {
// alert("收款合同号不合法!");
// }
// if(key.length==0)
// {
// alert("渠道名称不能为空!");
// }
// if(pattern_time2.test(time2)&&key.length>0)
// {
var form1=document.getElementById("form1");
form1.submit();
// }
}
function excel()
{
window.location.href="download_excel.php";
}
</script><meta><title>无线支付数据报表平台</title><link><link><!-- Theme Start --><link><!-- Theme End --><p>@@##@@</p>
<!-- Top Breadcrumb Start -->
<p>
</p>
- @@##@@
- 当前位置:
- 平台首页 - 渠道应收表
渠道应收表
收款合同号 |
渠道名称 |
累计渠道代收金额 |
累计渠道成本 |
累计调整渠道成本 |
累计应收账款 |
累计回款 |
累计未回款 |
当月渠道代收金额 |
当月渠道成本 |
当月调整渠道成本(元) |
当月应收账款 |
当月回款 |
当月未回款 |
|---|
@@##@@
欢迎您:
使用官方Model Context Protocol PHP SDK将PHP应用程序功能暴露为MCP工具、资源和提示,用于代理工作流。
边乐乐
(点击查看)
新 消 息
-
@@##@@
您的应用:XXXX1被驳回
来自NPP审核组 2011-07-29 12:00:00
-
@@##@@
您的应用:XXXX2审核通过
来自NPP审核组 2011-07-29 12:00:00
-
@@##@@
您的应用:XXXX2审核被驳回
来自NPP审核组 2011-07-29 12:00:00
-
@@##@@
API(J2ME版)已推出新版本
来自NPP开发组 2011-07-29 12:00:00
-
@@##@@
NOKIA支付平台推出新支付方式
来自NPP运营组 2011-07-29 12:00:00
-
@@##@@
NOKIA支付平台新接入新支付渠道
来自NPP运营组 2011-07-29 12:00:00
index2.php
<?php $collection_contract_id="";
$channel_name="";
function check_text($text)
{
if(isset($_REQUEST[$text]))
{
return $_REQUEST[$text];
}
}
include_once 'smarty_inc.php';
$sql="select * from channel_accounts where ";
if(isset($_GET["time2"])&&$_GET["time2"]!="")
{
$collection_contract_id=$_GET["time2"];
if(!preg_match("/^[A-Za-z0-9]+$/", $collection_contract_id))
{
echo "<script>alert('收款合同号输入不合法!');";
$smarty->display("index2.html");
exit();
}
$sql.=" collection_contract_id='".$collection_contract_id."' and ";
}
if(isset($_GET["key"])&&$_GET["key"]!="")
{
$channel_name=$_GET["key"];
if($channel_name=="")
{
echo "<script>alert('渠道名称输入不合法!');</script>";
$smarty->display("index2.html");
exit();
}
$sql.=" channel_name='".$channel_name."' and ";
}
$sql.=" 1=1 ";
//分页
if (isset($_GET['page']) && $_GET['page'] > 0)
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
$eachPages = 10;
$url = $_SERVER['PHP_SELF'];
$sql2 = "SELECT count(*) as total FROM (".$sql.") as a";
$result = mysql_query($sql2);
list($rowNums) = mysql_fetch_row($result);
$pageNums = ceil($rowNums / $eachPages);
$rowFrom = ($page > 1) ? (($page - 1) * $eachPages) : 0;
$sql2 = "".$sql." LIMIT ".$rowFrom.",".$eachPages."";
$result = mysql_query($sql2);
//------分页结束-------
//显示数据
$_SESSION["excel"]=$sql;
$result=mysql_query($sql2);
$outpagelist="";//输出数据的变量
while($out=mysql_fetch_array($result))
{
$outpagelist.="<tr>";
$outpagelist.="<td>".$out['collection_contract_id']."</td>";
$outpagelist.="<td>".$out['channel_name']."</td>";
$outpagelist.="<td>".$out['channel_money']."</td>";
$outpagelist.="<td>".$out['add_channel_cost']."</td>";
$outpagelist.="<td>".$out['add_channel_change_cost']."</td>";
$outpagelist.="<td>".$out['add_accounts']."</td>";
$outpagelist.="<td>".$out['add_back_money']."</td>";
$outpagelist.="<td>".$out['add_noback_money']."</td>";
$outpagelist.="<td>".$out['month_channel_money']."</td>";
$outpagelist.="<td>".$out['month_channel_cost']."</td>";
$outpagelist.="<td>".$out['month_channel_change_cost']."</td>";
$outpagelist.="<td>".$out['month_accounts']."</td>";
$outpagelist.="<td>".$out['month_back_money']."</td>";
$outpagelist.="<td>".$out['month_noback_money']."</td>";
$outpagelist.="</tr>";
}
//记录的总条数
// $sql_total_number="select * from channel_accounts";
$query=mysql_query($sql);
$num=mysql_num_rows($query);
//----------显示Page导航----------
$tablefoot="";
$tablefoot.= "
| 记录共有:'.$num. '条 | '; $tablefoot.= ($page == 1) ? '首页' : ''.'首页'.''; $tablefoot.= ' '; $tablefoot.= ($page == 1) ? '上一页' : ''.'上一页' .''; $tablefoot.= ' '; $tablefoot.= ($page == $pageNums) ? '下一页' : ''.'下一页' .''; $tablefoot.= ' '; $tablefoot.= ($page == $pageNums) ? '尾页' : ''.'尾页' .''; $tablefoot.= ' |
php免费学习视频:立即使用
踏上前端学习之旅,开启通往精通之路!从前端基础到项目实战,循序渐进,一步一个脚印,迈向巅峰!










