history.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");
}
$db= new DB($hostname,$username,$password,$database);
$action=$_GET["act"];
if ($action=="delete"){
	$tidArray=$_POST["tid"];
	foreach ($tidArray as $tid){
		$sql="delete from {$prefix}track where tid=$tid limit 1";
		$db->update($sql);
	}
	ExeSuccess($langAdminArray["bank_succ"],"./admin.php?mod=cash/bank&f=history&c=3");
}
elseif ($action=="unable"){
	$tidArray=$_POST["tid"];
	foreach ($tidArray as $tid){
		$sql="update {$prefix}track set state=0 where tid=$tid limit 1";
		$db->update($sql);
		$sql="select pcardid from {$prefix}track where tid=$tid limit 0,1";
		$db->query($sql,true);
		$rs=$db->fetch_array();
		$pcardid=$rs["pcardid"];
		$sql="select * from {$prefix}paycard where pcardid=$pcardid limit 0,1";
		$db->query($sql,true);
		$rs=$db->fetch_array();
		if($rs["date"]>0){
			$mony=0;
			$date=$rs["date"]*3600*24;
		}
		else{
			$mony=$rs["mony"];
			$date=0;
		}
		$bid=$rs["bid"];
		if($rs["state"]==0){
			$sql="update {$prefix}paycard set status=0 where pcardid=$pcardid limit 1";
			$db->update($sql);
		}
		else{
			$sql="update {$prefix}paycard set status=0 where pcardid=$pcardid limit 1";
			$db->update($sql);
			$sql="update {$prefix}bankcard set mony=mony-{$mony},`date`=`date`-{$date} where bankid ={$bid} limit 1";
			$db->update($sql);
		}
	}
	ExeSuccess($langAdminArray["bank_succ"],"./admin.php?mod=cash/bank&f=history&c=3");
}
else{
	$p=new Template("./template/cash/bank");
	$sql="select count(*) as num from {$prefix}track where state=1";
	$_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 t.*,b.name,p.count as pcount from {$prefix}track as t,{$prefix}bank as b,{$prefix}paycard as p where t.state=1 and t.bid=b.bid and t.pcardid=p.pcardid order by t.start_time desc limit $lower_item,30",true);
	$p->set_file("handle_list","bank_row.html");
	while ($rs=$db->fetch_array()){
		$rs["state"]=$langAdminArray["bank_fini"];
		$rs["start_time"]=date("Y-m-d H:i:s",$rs["start_time"]);
		$p->set_var($rs);
		$p->parse("link","handle_list",true);
	}
	$p->set_file("handle","his_list.html");
	$split_page=show_split_page($whichpage,$allPage,"./admin.php?mod=cash/bank&f=history&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");
}
?>