📄 cxzwbbb.php
字号:
<?
include "../check.php"
?>
<?
include "../sql.php"
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<?
//标记被冲销记录
$sql="update charge set del='del' where op_serialno='$op_serialno'";
mysql_query($sql);
//echo mysql_error();
$nowdate=date("Y-m-d H:i:s",time());
$init_fee=-$init_fee;
$months=-$months;
$service_fee=-$service_fee;
$total_days=-$total_days;//负
//获得操作员
$sess=session_name();
$sql ="select * from admin where operator='$sess'";
$reslust=mysql_query($sql);
while ($row=mysql_fetch_row($reslust))
{$opname=$row[2];
}
$sql="insert into charge (user_serialno,datetime,init_fee,month_fee,months,service_fee,freeo_days,freex_days,
total_days,sales_name,origin_serialno,origin_operator,origin_op_date,del,operator) values
('$user_serialno','$nowdate','$init_fee','$month_fee','$months','$service_fee','$freeo_days','$freex_days',
'$total_days','$sales_name','$op_serialno','$operator','$datetime','del','$opname')";
//var_dump($sql);
mysql_query($sql);
//echo mysql_error();
//以下对用户的状态ST OK PS和有效日期等操作
//$user_serialno 用户流水
$total_days=-$total_days;//正
$sql="select * from user where user_serialno=$user_serialno";
$result = mysql_query($sql);
//echo mysql_error();
while ($row=mysql_fetch_row($result))
{
$status=$row[11];//状态
$valid_date=$row[12];//有效日期
$pausend_date=$row[13];//暂停恢复日期
$name=$row[1];
}
//当用户为停止服务状态
if($status=='st')
{
$valid_date=strtotime($valid_date)-$total_days*24*60*60;
$valid_date=date("Y-m-d H:i:s",$valid_date);
$sql="update user set valid_date='$valid_date' where user_serialno='$user_serialno'";
//var_dump($sql);
//echo var_dump($sql);
mysql_query($sql);
//echo mysql_error();
echo '<p> </p>
<p align="center">帐务冲销成功</p>';
}
if($status=='ok')
{
$t=strtotime($valid_date)-$total_days*24*60*60;
//判断有效日期是否小于了当前日期 ;
$nowdate=strtotime($nowdate);
//$$valid_date=strtotime($valid_date);
if($t<$nowdate)
{
$valid_date=date("Y-m-d H:i:s",$t);
$sql="update user set valid_date='$valid_date',status='st' where user_serialno='$user_serialno'";
//var_dump($sql);
mysql_query($sql);
//echo mysql_error();
//更新radius库
include ("../rsql.php");
$sql="delete from radcheck where UserName='$name'";
//var_dump($sql);
mysql_query($sql);
//echo mysql_error();
echo '<p> </p>
<p align="center">帐务冲销成功</p>';
}
else
{
$valid_date=date("Y-m-d H:i:s",$t);
$sql="update user set valid_date='$valid_date' where user_serialno='$user_serialno'";
// var_dump($sql);
mysql_query($sql);
//echo mysql_error();
echo '<p> </p>
<p align="center">帐务冲销成功</p>';
}
}
if($status=='pa')
{ /*如果有效服务－差时<暂停恢复期；状态->st;
新有效服务日期＝当前日期-（暂停恢复日期-(有效服务日期-差时))
否则新有效日期＝有效服务日期- 差时*/
$t=strtotime($valid_date)-$total_days*24*60*60;
$pausend_date=strtotime($pausend_date);
if($t<$pausend_date)
{
$nowdate=strtotime($nowdate);
$valid_date=$nowdate-$pausend_date+$t;
$valid_date=date("Y-m-d H:i:s",$valid_date);
$sql="update user set valid_date='$valid_date',status='st',pausend_date='' where user_serialno='$user_serialno'";
var_dump($sql);
mysql_query($sql);
echo mysql_error();
include ("../rsql.php");
$sql="delete from radcheck where UserName='$name'";
var_dump($sql);
mysql_query($sql);
echo mysql_error();
echo '<p> </p>
<p align="center">帐务冲销成功</p>';
}
else
{
$valid_date=date("Y-m-d H:i:s",$t);
$sql="update user set valid_date='$valid_date' where user_serialno='$user_serialno'";
var_dump($sql);//echo var_dump($sql);
mysql_query($sql);
echo mysql_error();
echo '<p> </p>
<p align="center">帐务冲销成功</p>';
}
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -