📄 ads_admin_modify.php
字号:
<?php
if ($rowdroit['is_admin'] == 1)
{
$sqlfadmin = '';
}
else
{
$sqlowner = '' . 'select username from advertizer where adser_owner=\'' . $_SESSION['admin_username'] . '\'';
$rsowner = mysql_query ($sqlowner);
$sqlfadmin = ' and (';
while ($rowner = mysql_fetch_array ($rsowner))
{
$sqlfadmin .= '' . 'username=\'' . $rowner['username'] . '\' or ';
}
$sqlfadmin = substr ($sqlfadmin, 0, strlen ($sqlfadmin) - 4) . ')';
}
if ((!empty ($_POST['hnpassid']) AND !empty ($_POST['hnpasss_id'])))
{
$sqla = '' . 'select * from ads where id=\'' . $_POST['hnpasss_id'] . '\' ' . $sqlfadmin;
$rsa = mysql_query ($sqla);
$numads = mysql_num_rows ($rsa);
if ($numads < 1)
{
fun_alert ('不能审批，此广告已被删除！');
fun_back ();
exit ();
}
$rowa = mysql_fetch_array ($rsa);
$sql = '' . 'select * from ads_s where id=\'' . $_POST['hnpassid'] . '\' ' . $sqlfadmin;
$rs = mysql_query ($sql);
$row = mysql_fetch_array ($rs);
$now_money = 0;
if ($row['price'] != $row['old_price'])
{
if ($rowa['ads_type'] == 3)
{
$nowspare = $rowa['spare'];
$now_money = round ($nowspare * ($row['price'] - $row['old_price']) / 10) / 100;
}
else
{
$nowspare = $rowa['spare'];
$rate = $rowa['rate'];
$now_money = round ($nowspare * ($row['price'] - $row['old_price']) * ((1 + $rate) * (1 + $rate) + 0.100000000000000005551115) / 1000 * 100) / 100;
}
$rowad = mysql_fetch_array (mysql_query ('' . 'select * from advertizer where username=\'' . $row['username'] . '\''));
$balance = $rowad['balance'];
if ($balance < $now_money)
{
echo '该用户的帐户余额已不足支付提高单价的差额！不能审批！';
fun_alert ('该用户的帐户余额已不足支付提高单价的差额！不能审批！');
fun_back ();
exit ();
}
$update = '' . 'update advertizer set balance=balance-' . $now_money . ' where username=\'' . $row['username'] . '\'';
$rsup = mysql_query ($update);
$str_mess = '此广告的当前剩余量为' . ('' . $nowspare . ' ，实际单价差额为') . ('' . $now_money . ' 元！');
}
else
{
$rsup = 1;
$str_mess = '';
}
if ($rsup)
{
$sql = '' . 'update `ads` set `price` = \'' . $row['price'] . '\',`money` =`money`+' . $now_money . ', `url` =\'' . $row['url'] . '\', `openurl`= \'' . $row['openurl'] . '\', `openurl2` = \'' . $row['openurl2'] . '\', `openurl3`= \'' . $row['openurl3'] . '\' , `openurl4`= \'' . $row['openurl4'] . '\' , `openurl5`=\'' . $row['openurl5'] . '\' ,`link_tit`=\'' . $row['link_tit'] . '\' ,`picname`= \'' . $row['picname'] . '\', `conn`=\'' . $row['conn'] . '\' , `overtime` =\'' . $row['overtime'] . '\',`alert_num`=\'' . $row['alert_num'] . '\',`admin_stat`=2,`admin_time`=\'' . $datetime . '\' where `id`=\'' . $_POST['hnpasss_id'] . '\'';
$rsu = mysql_query ($sql);
$sql = '' . 'update `ads_s` set `admin_time`=\'' . $datetime . '\',`admin_user`=\'' . $_SESSION['admin_username'] . '\',`admin_stat`=\'2\' where `id`=\'' . $_POST['hnpassid'] . '\'';
$rsu = mysql_query ($sql);
if ($rowa['ads_type'] == 3)
{
echo '<img src=make_leads.php width=0 height=0>';
}
else
{
echo '' . '<img src=makeads.php?adsid=' . $_POST['hnpasss_id'] . ' width=0 height=0>';
}
}
if ($rsu)
{
fun_alert ('审批成功！' . ('' . $str_mess));
}
else
{
fun_alert ('审批失败！');
}
fun_back ();
exit ();
}
if (!empty ($_POST['hndelid']))
{
$sql = '' . 'delete from `ads_s` where s_id=\'' . $_POST['hndelid'] . '\' ' . $sqlfadmin;
$rs = mysql_query ($sql);
echo $rs . ' = ' . $sql;
if ($rs)
{
fun_alert ('删除成功！');
}
else
{
fun_alert ('删除失败！');
}
fun_back ();
exit ();
}
$sqla = 'select * from ads_form where 1';
$rsa = mysql_query ($sqla);
while ($rowa = mysql_fetch_array ($rsa))
{
$a_id = $rowa['id'];
$arr_adsform[$a_id] = $rowa['s_name'];
}
if (!empty ($txt_search))
{
$andwhere = '' . ' and (username like \'%' . $txt_search . '%\' or id = \'' . $txt_search . '\' or time like \'%' . $txt_search . '%\' or link_tit like \'%' . $txt_search . '%\') ';
}
$orderby = '';
if (!empty ($or_name))
{
$orderby = ($or_name == '1' ? ' username asc,' : ' username desc,');
}
if (!empty ($or_time))
{
$orderby = ($or_time == '1' ? ' time asc,' : ' time desc,');
}
if (!empty ($or_type))
{
$orderby = ($or_type == '1' ? ' ads_form_id asc,ads_type asc,' : ' ads_form_id desc,ads_type desc,');
}
if (!empty ($or_totpub))
{
$orderby = ($or_totpub == '1' ? ' spare,' : ' spare desc,');
}
if (!empty ($or_spare))
{
$orderby = ($or_spare == '1' ? ' spare,' : ' spare desc,');
}
if (!empty ($or_price))
{
$orderby = ($or_price == '1' ? ' price asc,' : ' price desc,');
}
if (!empty ($or_rate))
{
$orderby = ($or_rate == '1' ? ' rate asc,' : ' rate desc,');
}
$pagesize = $cfg_adminpagesize;
$list_count = '' . 'ads_s where 1 ' . $andwhere . ' ' . $sqlfadmin . ' group by s_id';
$sql = '' . 'select s_id from ads_s where 1 ' . $andwhere . ' ' . $sqlfadmin . ' group by s_id order by ' . $orderby . ' admin_stat,id desc';
include '../public/pagehead.php';
$rsa = mysql_query ($sql);
$str_disp = '';
while (true)
{
if ($rowa = mysql_fetch_array ($rsa))
{
$sql = '' . 'select * from ads_s where s_id=\'' . $rowa['s_id'] . '\' order by id desc';
$rs = mysql_query ($sql);
$row = mysql_fetch_array ($rs);
$atime = substr ($row['time'], 0, 10) . '<br>' . substr ($row['time'], -8);
$ads_stat = $row['ads_stat'];
$admin_stat = $row['admin_stat'];
$ads_type = $row['ads_type'];
$rate = $row['rate'] * 100;
$ads_form_id = $row['ads_form_id'];
if ($ads_type == 1)
{
$spec = '混合-' . $arr_adsform[$ads_form_id];
}
$spec = ;
if ($admin_stat == 1)
{
$str_admin = '' . '<input name=pass type=button id=pass class=subbt2 value=\'审批\' onClick="pass_sub(' . $row['id'] . ',' . $row['s_id'] . ')"><input name=delete type=button id=delete class=subbt2 value=\'删除\' onClick="del_sub(' . $row['s_id'] . ')">';
}
$str_admin = ;
$str_disp .= '' . '
<tr align=center class="listbody_admin">
<td><a href=\'#\' onClick="show_dlg(\'view_ads.php?adsid=' . $row['s_id'] . '&viewtype=modi\',680,520)">' . $row['id'] . '</a></td>
<td><a href=\'#\' onClick="show_dlg(\'view_ads.php?adsid=' . $row['s_id'] . '\',680,520)">' . $row['s_id'] . '</a></td>
<td><a href=\'#\'onClick=show_dlg(\'view_adser.php?adserid=' . $row['adser_id'] . '\',500,380)>' . $row['username'] . '</a></td>
<td align=left>' . $row['link_tit'] . '</td>
<td width=70>' . $atime . '</td>
<td>' . $spec . '</td>
<td>' . $row['spare'] . '</td>
<td>' . $row['price'] . '</td>
<td>' . $rate . ' %</td>
<td>' . $row['money'] . '</td>
<td>' . $cfg_defstat[$admin_stat] . '</td>
<td>' . $str_admin . '</td>
</tr>';
}
}
echo '<s';
echo 'tyle type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
';
echo '<s';
echo 'cript>
<!--
function pass_sub(id,s_id){
var psub=confirm("确认审批吗？");
if(psub){
document.hideform.hnpassid.value=id;
document.hideform.hnpasss_id.value=s_id;
document.hideform.submit();
}else{
return false;
}
}
function del_sub(delid){
var psub=confirm("确认删除吗？");
if(psub){
document.hideform.hndelid.value=delid;
document.hideform.submit();
}else{
retu';
echo 'rn false;
}
}
function order(obj,val){
var temp=eval("document.hideform."+obj);
temp.value=val;
document.hideform.submit();
}
-->
</script>
<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" bgcolor="#CCCCCC" >
<tr bgcolor="F0F0F0">
<td width="100" height="25"><div align="center">
';
echo '修改待审广告</div></td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<form name="hideform" method="post" action="">
<tr>
<td width="40" align=right>搜索:</td>
<td><input name="txt_search" type="text" class="text" id="txt_search" value="';
echo $txt_search;
echo '" size="20" maxlength="20">
<input type="submit" name="Submit" value="提交" class=subbt2>
<input name="hnpassid" type="hidden" id="hnpassid">
<input name="hnpasss_id" type="hidden" id="hnpasss_id">
<input name="hndelid" type="hidden" id="hndelid">
<input name="or_name" type="hidden" id="or_name">
<input name="or_time" type="hidden" id="or_time">
<input n';
echo 'ame="or_type" type="hidden" id="or_type">
<input name="or_totpub" type="hidden" id="or_totpub">
<input name="or_spare" type="hidden" id="or_spare">
<input name="or_price" type="hidden" id="or_price">
<input name="or_rate" type="hidden" id="or_rate">
</td>
</tr></form>
</table>
</td></tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="';
echo '2" class="listtable_admin">
<tr align="center" class="listbody_admin">
<td class="listtbhd_admin">ID</td>
<td class="listtbhd_admin">原ID</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_name\',\'';
echo ($or_name == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">帐号</span></a>';
if (!empty ($or_name))
{
echo ($or_name == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin">项目名称</td>
<td class="listtbhd_admin" width=70><a href="#" onClick="order(\'or_time\',\'';
echo ($or_time == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">时间</span></a>';
if (!empty ($or_time))
{
echo ($or_time == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_type\',\'';
echo ($or_type == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">广告规格</span></a>';
if (!empty ($or_type))
{
echo ($or_type == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_totpub\',\'';
echo ($or_totpub == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">剩余数</span></a>';
if (!empty ($or_totpub))
{
echo ($or_totpub == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_price\',\'';
echo ($or_price == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">单价</span></a>';
if (!empty ($or_price))
{
echo ($or_price == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_rate\',\'';
echo ($or_rate == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">点/弹</span></a>';
if (!empty ($or_rate))
{
echo ($or_rate == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin">单价差额</td>
<td class="listtbhd_admin">审核状态</td>
<td class="listtbhd_admin">管理</td>
</tr>
';
echo $str_disp;
echo ' </table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
';
$pagestr = '' . '&tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm . '&or_name=' . $or_name . '&or_time=' . $or_time . '&or_type=' . $or_type . '&or_totpub=' . $or_totpub . '&or_price=' . $or_price . '&or_rate=' . $or_rate . '&txt_search=' . $txt_search;
include '../public/pagefoot.php';
echo '</td>
</tr>
</table>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -