<?php
include ("cookie_check.php");
?>
<HTML>
<TITLE> 网上理财：预算计划管理 </TITLE>
<BODY>
<P ALIGN=CENTER><FONT FACE="隶书" SIZE="7" COLOR="#0000FF">
网上理财</FONT><BR>
<P ALIGN=LEFT>
<FONT FACE="宋体" SIZE="3" COLOR="#0000FF"><A HREF="index.php"
STYLE="Text-Decoration:none">首页</A>>><A HREF="budget.php"
STYLE="Text-Decoration:none">预算计划管理</A><BR>
<FORM NAME="report_1" ACTION="budget.php" METHOD="POST">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD BGCOLOR="#FFFFFF" width=700>
<Font Face=宋体 Size=2 Color="#0000FF" >所属月份
<?php
if ($year) $date=$year.$month;
if (!$date)
{$today=getdate();
$date=sprintf ("%04s%02s",$today['year'],$today['mon']);}
?>
<SELECT NAME="year">
<OPTION VALUE="<?php echo substr($date,0,4) ?>"><
?php echo substr($date,0,4) ?>
<?php
for ($i=1950;$i<=2050;$i++)
if ($i!=substr($date,0,4)) echo "<OPTION VALUE='".$i."'>".$i;
?>
</SELECT>年<SELECT NAME="month">
<OPTION VALUE="<?php echo substr($date,4,2) ?>"><
?php echo substr($date,4,2) ?>
<?php
for ($i=1;$i<=12;$i++)
if ($i!=substr($date,4,2)) echo "<OPTION VALUE='"
.sprintf("%02s",$i)."'>".sprintf("%02s",$i);
?></SELECT>月</FONT>
</TD><TD BGCOLOR="#FFFFFF" width=100>
<INPUT TYPE=SUBMIT VALUE= 刷新 >
</TD></TR>
</TABLE>
</FORM>
<TABLE BORDER="1" CELLPADDING="0" CELLSPACING="0" align=center>
<TR>
<TD BGCOLOR="#FFFFFF" ALIGN="center" VALIGN="MIDDLE" width=100><
Font Face=宋体 Size=2 Color="#0000FF" >
收支项目</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=150><
Font Face=宋体 Size=2 Color="#0000FF" >
预算金额</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=50>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=50>
</TD></TR>
<?php
if (!$date)
{$today=getdate();
$date=sprintf ("%04s%02s",$today['year'],$today['mon']);}
$year=substr($date,0,4);
$month=substr($date,4,2);
if (!$limit) $limit=0;
$query = "select in_ex_type.name as name,in_ex_budget.money as
money,in_ex_budget.id as id from in_ex_budget,in_ex_type where
in_ex_budget.in_ex_type=in_ex_type.code and in_ex_budget.user='"
.$cookie_user."' and in_ex_budget.ye_mo='".$year.$month.
"' order by in_ex_type.type DESC limit ".$limit.",15";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
$i=1;
while ($i<=15 and $row)
{$i++;
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF' ALIGN=left>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['name'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['money'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' align=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "<A HREF='budget_edit.php?id=".$row['id']."&date=".$date."'
STYLE='Text-Decoration:none'>编辑</A></FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' align=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "<A HREF='budget_delete.php?id=".$row['id']."&date=".$date."'
STYLE='Text-Decoration:none'>删除</A></FONT>";
echo "</TD></TR>";
$row = mysql_fetch_array($res); }
$query = "select sum(in_ex_budget.money) as money_sum
from in_ex_budget,in_ex_type where
in_ex_budget.in_ex_type=in_ex_type.code and in_ex_budget.user='"
.$cookie_user."' and in_ex_budget.ye_mo='".$year.$month.
"' and in_ex_type.type=0";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF' ALIGN=left>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "收入合计";
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right colspan=3>";
echo "<Font Face=宋体 Size=2 Color='#0000FF'>";
if (!$row['money_sum']) $money_sum_in=0;
else $money_sum_in=$row['money_sum'];
printf("%18.2f",$money_sum_in);
echo "</FONT>";
echo "</TD></TR>";
$query = "select sum(in_ex_budget.money) as money_sum
from in_ex_budget,in_ex_type where
in_ex_budget.in_ex_type=in_ex_type.code and
in_ex_budget.user='".$cookie_user."' and
in_ex_budget.ye_mo='".$year.$month.
"' and in_ex_type.type=1";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF' ALIGN=left>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "支出合计";
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right colspan=3>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
if (!$row['money_sum']) $money_sum_ex=0;
else $money_sum_ex=$row['money_sum'];
printf("%18.2f",$money_sum_ex);
echo "</FONT>";
echo "</TD></TR>";
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF' ALIGN=left>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "差额";
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right colspan=3>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
printf("%18.2f",$money_sum_in-$money_sum_ex);
echo "</FONT>";
echo "</TD></TR>";
echo "</TABLE>";
echo "<P ALIGN=RIGHT>";
$query = "select count(*) as count from in_ex_budget,in_ex_type
where in_ex_budget.in_ex_type=in_ex_type.code and
in_ex_budget.user='".$cookie_user."'
and in_ex_budget.ye_mo='".$year.$month."'";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
$total=floor(($row['count']-1)/15)*15;
$limit_pre=$limit-15;
$limit_next=$limit+15;
echo "<Font Face=宋体 Size=3 Color='#0000FF' >";
echo "第";
echo $limit/15+1;
echo "页 共";
echo $total/15+1;
echo "页 ";
if ($limit!=0)
echo "<A HREF='budget.php?limit=0'
STYLE='Text-Decoration:none'>";
echo "首页 ";
if ($limit!=0)
echo "</A>";
if ($limit!=$total)
echo "<A HREF='budget.php?limit=".$total."'
STYLE='Text-Decoration:none'>";
echo "尾页 ";
if ($limit!=$total)
echo "</A>";
if ($limit_pre>=0)
echo "<A HREF='budget.php?limit=".$limit_pre."'
STYLE='Text-Decoration:none'>";
echo "前页 ";
if ($limit_pre>=0) echo "</A>";
if ($limit_next<=$total)
echo "<A HREF='budget.php?limit=".$limit_next."'
STYLE='Text-Decoration:none'>";
echo "后页 ";
if ($limit_next<=$total)
echo "</A>";
echo "</FONT>";
?>
<FORM NAME="form1" ACTION="budget_insert.php" METHOD="POST">
<P ALIGN=CENTER><INPUT TYPE=SUBMIT VALUE=加入新的预算项目>
<INPUT TYPE=HIDDEN VALUE="<?php echo $date ?>" name=date>
</FORM></BODY>
</HTML>
如果您对本文有任何疑问或者建议，请到讨论区发表您的意见:
>>
论坛入口 <<
上一篇：一个网上理财站点的设计（九）
下一篇：一个网上理财站点的设计（十一）
【文章评论】
【收藏本文】
【推荐好友】
【打印本文】
【我要投稿】 【论坛讨论】
更多相关文章
|
|
