?? 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 "刪除申請余額支付記錄成功！你的取消申請金額已經(jīng)加入你的帳戶！";
fun_alert("刪除申請余額支付記錄成功！你的取消申請金額已經(jīng)加入你的帳戶！");
fun_goto("adser_apply.php");
exit();
}else{
echo "刪除申請余額支付記錄失??！請聯(lián)系管理員！";
fun_alert("刪除申請余額支付記錄失敗！請聯(lián)系管理員！");
fun_back();
exit();
}
}else{
echo "非法刪除！";
fun_alert("非法刪除！");
fun_back();
exit();
}
}
if($_POST["Submit"]=="確認(rèn)提交" && $_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("您的帳戶余額支付申請已經(jīng)提交！請等待管理員結(jié)算！");
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("確認(rèn)刪除嗎？");
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"> 如果確認(rèn)不再投放廣告，可以向管理員申請支付您帳戶中的余額。</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">關(guān)于本問題給我們留言</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">當(dāng)前賬戶余額:</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="確認(rèn)提交" 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">結(jié)算時間</div></td>
<td class="listtbhd"><div align="center">狀態(tài)</div></td>
<td class="listtbhd"><div align="center">管理</div></td>
</tr>
<?=$outdisp?>
<tr class="listbody" height="26">
<td class="listtbhd"><div align="center">合計(jì)</div></td>
<td><?=$sum_subnum?></td>
<td colspan="3"> </td>
</tr>
</table>
<p> <br>
<br>
<br>
</p></td>
</tr>
</table>
<?
include("../adser/foot.php");
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -