📄 adser_apply.php
字号:
<?
include_once("../adser/top.php");
if(!empty($_REQUEST["delid"])){
$sqlp="select * from payed where username='$_SESSION[adser_username]' and admin_stat='1' and pay_type='2' and id='$_REQUEST[delid]'";
$rsp=mysql_query($sqlp);
$num=mysql_num_rows($rsp);
if($num>0){
$rowp=mysql_fetch_array($rsp);
$del="delete from payed where id='$rowp[id]'";
$rsd=mysql_query($del);
if($rsd){
$update="update advertizer set balance=balance+$rowp[ought_money] where username='$_SESSION[adser_username]'";
$rsup=mysql_query($update);
echo "删除申请余额支付记录成功！你的取消申请金额已经加入你的帐户！";
fun_alert("删除申请余额支付记录成功！你的取消申请金额已经加入你的帐户！");
fun_goto("adser_apply.php");
exit();
}else{
echo "删除申请余额支付记录失败！请联系管理员！";
fun_alert("删除申请余额支付记录失败！请联系管理员！");
fun_back();
exit();
}
}else{
echo "非法删除！";
fun_alert("非法删除！");
fun_back();
exit();
}
}
if($_POST["Submit"]=="确认提交" && $_POST["sub_money"]>0){
if($_POST["sub_money"]>$_POST["balance"]){
fun_alert("申请金额不能大于您的帐户余额！");
fun_back();
exit();
}
$sql="INSERT INTO `payed` ( `username` , `pay_type` , `ought_money` , `pay_date` , `admin_stat` )
VALUES ('$_SESSION[adser_username]', '2', '$_POST[sub_money]', '$date', '1')";
$rs=mysql_query($sql);
$sql="update advertizer set balance=balance-$_POST[sub_money] where username='$_SESSION[adser_username]'";
$rs=mysql_query($sql);
if($rs){
fun_alert("您的帐户余额支付申请已经提交！请等待管理员结算！");
fun_goto("adser_apply.php");
}else{
fun_alert("帐户余额支付申请失败！请重新提交！");
fun_back();
}
exit();
}
/* 取得账户余额 */
$rowu=mysql_fetch_array(mysql_query("select balance from advertizer where username='$_SESSION[adser_username]'"));
$balance=$rowu["balance"];
/* 取得申请支付列表 */
$outdisp="";
$sum_subnum=0;
$sum_realnum=0;
$sql="select * from payed where username='$_SESSION[adser_username]' and pay_type='2' order by pay_date desc";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs)){
$state=$row["admin_stat"];
$sum_subnum=$sum_subnum+$row["ought_money"];
$sum_realnum=$sum_realnum+$row["real_money"];
if($state=="1"){
$str_manage="<input name=delete type=button id=delete class=subbt2 value='删除' onClick=\"delads_sub($row[id])\">";
}else{
$str_manage="<input name=delete type=button id=delete class=subbt2 value='删除' disabled>";
}
$outdisp.="
<tr align=center class=\"listbody\">
<td>$row[pay_date]</td>
<td>$row[ought_money]</td>
<td>$row[admin_time]</td>
<td>$cfg_applystat[$state]</td>
<td>$str_manage</td>
</tr>";
}
?>
<script>
<!--
function check_sub(){
if(check_number("申请金额",document.form1.sub_money)){return false;}
var sub_money=document.form1.sub_money.value*1;
var balance=document.form1.balance.value*1;
if(sub_money>balance){
alert("申请金额不能大于您的帐户余额！");
return false;
}
return true;
}
function delads_sub(delid){
var psub=confirm("确认删除吗？");
if(psub){
this.location='adser_apply.php?delid='+delid;
}else{
return false;
}
}
//-->
</script>
<table width="1001" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#f7f7f7">
<tr>
<td width="200" height="323" valign="top" bgcolor="#E8EEF4">
<?
include("menu.php");
?></td>
<td align="center" valign="top" class="bgconn">
<table width="98%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td height="40" class="orange_text">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="left" valign="middle"><img src="../image/shenqin.gif" width="150" height="20"></td>
</tr>
<tr>
<td align="center" valign="middle">
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" align="left" valign="middle"> 如果确认不再投放广告，可以向管理员申请支付您帐户中的余额。</td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" align="left" valign="middle">
<table width="50%" border="0" cellpadding="0" cellspacing="0">
<tr align="center" valign="middle">
<td width="5%"><img src="../image/bot14.gif" width="16" height="16"></td>
<td width="52%" align="left"><a href="message_add.php?tit=申请支付余额"><span class="bluetext">关于本问题给我们留言</span></a></td>
<td width="6%"><img src="../image/bot13.gif" width="16" height="16"></td>
<td width="37%" align="left">电话：
<?=$cfg_phone?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="4" bgcolor="#556D85" ></td>
</tr>
<tr>
<td height="3"></td>
</tr>
</table>
<table width="98%" border="0" cellspacing="1" cellpadding="6" class="listtable">
<form name="form1" method="post" action="" onsubmit="return check_sub()">
<tr align="center" class="listbody">
<td colspan="2" class="listtbhd"><div align="center" >申请支付余额</div></td>
</tr>
<tr class="listbody">
<td width="50%"> <div align="right">当前账户余额:</div></td>
<td width="50%"><input name="balance" type="text" class="text" id="balance" size="8" value="<? echo (empty($balance))?"0":$balance;?>" readonly="true">
元 </td>
</tr>
<tr class="listbody">
<td><div align="right">申 请 金 额 : </div></td>
<td><input name="sub_money" type="text" class="text" id="sub_money" size="8">
元</td>
</tr>
<tr class="listbody">
<td colspan="2"><div align="center">
<input name="Submit" type="submit" value="确认提交" class="subbt">
<input name="Submit2" type="reset" value="清空重置" class="subbt">
</div></td>
</tr></form>
</table>
<br>
<center><hr size="1" width="98%"></center>
<table width="98%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td height="30" align="center"><strong>申请支付余额记录</strong></td>
</tr>
</table>
<table width="98%" border="0" cellspacing="1" cellpadding="3" class="listtable">
<tr class="listbody">
<td class="listtbhd" height="28"><div align="center">申请时间</div></td>
<td class="listtbhd"><div align="center">申请金额(元)</div></td>
<td class="listtbhd"><div align="center">结算时间</div></td>
<td class="listtbhd"><div align="center">状态</div></td>
<td class="listtbhd"><div align="center">管理</div></td>
</tr>
<?=$outdisp?>
<tr class="listbody" height="26">
<td class="listtbhd"><div align="center">合计</div></td>
<td><?=$sum_subnum?></td>
<td colspan="3"> </td>
</tr>
</table>
<p> <br>
<br>
<br>
</p></td>
</tr>
</table>
<?
include("../adser/foot.php");
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -