bill.php

在传统CMS文章内容管理功能基础上

<?php
/*
    [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
	  This is NOT a freeware, use is subject to license terms
*/

error_reporting(0);
if(!function_exists("CheckRequire")){
	exit("Forbidden");
}
$action=$_GET["act"];
$db= new DB($hostname,$username,$password,$database);
if($action=="able"){
	$tidArray=$_POST["billid"];
	foreach ($tidArray as $tid){
		$sql="update {$prefix}bill set state=1 where billid=$tid limit 1";
		$db->update($sql);
		//写短消息通知
		if($systemispm){
			$mSQL="select * from {$prefix}bill where billid=$tid and state=1 limit 0,1";
			$db->query($mSQL,true);
			$rs=$db->fetch_array();
			if($rs){
				$message=$pmcontent."\n<a href=\"count_index.php?act=look\">{$langAdminArray["bill_msg"]}</a>";
				$mSQL="select username from {$prefix}members where uid=".$rs["uid"];
				$db->query($mSQL,true);
				while ($rs=$db->fetch_array()){
					$pmSql = "insert into ".$prefix."pmbox values('','系统','{$rs["username"]}','".time()."','系统消息','$message',0,1)";
					$db->update($pmSql);
				}
			}
		}
	}
	ExeSuccess($langAdminArray["bank_succ"],"./admin.php?mod=cash/bank&f=bill&c=3");
}
elseif ($action=="delete"){
	$tidArray=$_POST["billid"];
	foreach ($tidArray as $tid){
		$sql="select * from {$prefix}bill where billid=$tid limit 0,1";
		$db->query($sql,true);
		$rs=$db->fetch_array();
		$mony=$rs["mony"];
		$bankid=$rs["bankid"];
		$sql="update {$prefix}bankcard set mony=mony+$mony where bankid=$bankid limit 1";
		$db->update($sql);
		$sql="delete from {$prefix}bill where billid=$tid limit 1";
		$db->update($sql);
	}
	ExeSuccess($langAdminArray["bank_succ"],"./admin.php?mod=cash/bank&f=bill&c=3");
}
else{
	$p=new Template("./template/cash/bank");
	$sql="select count(*) as num from {$prefix}bill where state=0";
	$_GET["next"]?$whichpage=$_GET["next"]:$whichpage=1;
	$lower_item=($whichpage-1)*30;
	$result=$db->query($sql,true);
	$rs=$db->fetch_array();
	$allMsg=$rs["num"];
	$allPage=ceil($allMsg/30);
	$db->query("select * from {$prefix}bill where state=0 order by time desc limit $lower_item,30",true);
	$p->set_file("handle","bill.html");
	$p->set_block("handle","link","bil");
	$p->set_file("handle_list","bank_row.html");
	while ($rs=$db->fetch_array()){
		$rs["time"]=date("Y-m-d H:i:s",$rs["time"]);
		$p->set_var($rs);
		$p->parse("bil","link",true);
	}

	$split_page=show_split_page($whichpage,$allPage,"./admin.php?mod=cash/bank&f=bill&c=3");
	$p->set_var("split_page",$split_page);
	$p->set_var("allpage",$allPage);
	$p->set_var("allmsg",$allMsg);
	$p->set_var("whichpage",$whichpage);
	$p->parse("output","handle");
	$p->p("output");
}
?>