charge_admin.php

VIP信息处理系统源码

<?php

  if (!empty ($_POST['hndelid']))
  {
    $sql = '' . 'delete from `charge` where id=\'' . $_POST['hndelid'] . '\'';
    $rs = mysql_query ($sql);
    if ($rs)
    {
      fun_alert ('删除成功！');
    }
    else
    {
      fun_alert ('删除失败！');
    }

    fun_back ();
    exit ();
  }

  if (($_POST['pass'] == '提交' AND !empty ($_POST['hnpassid'])))
  {
    $conn = $_POST['oldconn'] . '
===================
管理员回复：' . $_POST['conn'];
    if (!empty ($_POST['back_num']))
    {
      $sql = '' . 'update charge set admin_stat=\'3\',num=\'' . $_POST['back_num'] . '\',conn=\'' . $conn . '\',admin_time=\'' . $datetime . '\',admin_user=\'' . $_SESSION['admin_username'] . '\' where id=\'' . $_POST['hnpassid'] . '\'';
      $rs = mysql_query ($sql);
      if ($rs)
      {
        $update = '' . 'update daydata set open_num=0,click_num=0,web_money=0 where web_user=\'' . $_POST['web_user'] . '\' and ads_id=\'' . $_POST['adsid'] . '\' and date=\'' . $_POST['viewdate'] . '\'';
        $rsu = mysql_query ($update);
        if ($rsu)
        {
          $update = '' . 'update ads set spare=spare+' . $_POST['back_num'] . ' where id=\'' . $_POST['adsid'] . '\'';
          $rsu = mysql_query ($update);
        }
      }

      if ($rsu)
      {
        fun_alert ('返还广告数据成功！');
      }
      else
      {
        fun_alert ('返还广告数据失败！');
      }
    }
    else
    {
      $sql = '' . 'update charge set conn=\'' . $conn . '\',admin_time=\'' . $datetime . '\',admin_user=\'' . $_SESSION['admin_username'] . '\' where id=\'' . $_POST['hnpassid'] . '\'';
      $rsu = mysql_query ($sql);
      if ($rsu)
      {
        fun_alert ('回复成功！');
      }
      else
      {
        fun_alert ('回复失败！');
      }
    }

    fun_back ();
    exit ();
  }

  if (!empty ($txt_search))
  {
    $andwhere = '' . ' and (adser_user like \'%' . $txt_search . '%\' or web_user like \'%' . $txt_search . '%\' or id = \'' . $txt_search . '\' or time like \'%' . $txt_search . '%\' or viewdate=\'' . $txt_search . '\' or  conn like \'%' . $txt_search . '%\') ';
  }

  $orderby = '';
  if (!empty ($or_adser))
  {
    $orderby = ($or_adser == '1' ? ' adser_user asc,' : ' adser_user desc,');
  }

  if (!empty ($or_web))
  {
    $orderby = ($or_web == '1' ? ' web_user asc,' : ' web_user desc,');
  }

  if (!empty ($or_adsid))
  {
    $orderby = ($or_adsid == '1' ? ' adsid asc,' : ' adsid desc,');
  }

  if (!empty ($or_viewdate))
  {
    $orderby = ($or_viewdate == '1' ? ' viewdate asc,' : ' viewdate desc,');
  }

  if (!empty ($or_time))
  {
    $orderby = ($or_time == '1' ? ' time asc,' : ' time desc,');
  }

  if (!empty ($or_admintime))
  {
    $orderby = ($or_admintime == '1' ? ' admin_time asc,' : ' admin_time desc,');
  }

  $str_disp = '';
  $pagesize = $cfg_adminpagesize;
  $list_count = '' . 'charge where 1 ' . $andwhere;
  $sql = '' . 'select * from charge where 1 ' . $andwhere . ' order by admin_stat, ' . $orderby . ' id desc';
  include '../public/pagehead.php';
  $rs = mysql_query ($sql);
  while (true)
  {
    if ($row = mysql_fetch_array ($rs))
    {
      $state = $row['admin_stat'];
      $back_num = (empty ($row['num']) ? '' . '<input type=text name=back_num id=back_num class=text size=5 value=' . $row['num'] . '>' : $row['num']);
      $str_admin = '' . '<input name=pass type=submit id=pass class=subbt2 value=\'提交\' ' . $passflag . '><input name=delete type=button id=delete class=subbt2 value=\'删除\' onClick="del_sub(' . $row['id'] . ')">';
      $str_disp .= '' . '
			<tr align=center class="listbody_admin"><form name=\'subform\' action=\'\' method=\'post\'>
          	  <td><a href=\'./charge_view.php?op=open&adsid=' . $row['adsid'] . '&webname=' . $row['web_user'] . '&viewday=' . $row['viewdate'] . '&id=' . $row['id'] . '\' target=\'_blank\'>' . $row['id'] . '</a><input name=hnpassid type=hidden id=hnpassid value=\'' . $row['id'] . '\'></td>
          	  <td><a href=\'#\'onClick=show_dlg(\'view_adser.php?adsername=' . $row['adser_user'] . '\',500,380)>' . $row['adser_user'] . '</a><input name=adser_user type=hidden id=adser_user value=\'' . $row['adser_user'] . '\'></td>
          	  <td><a href=\'#\'onClick=show_dlg(\'view_webmaster.php?webname=' . $row['web_user'] . '\',500,380)>' . $row['web_user'] . '</a><input name=web_user type=hidden id=web_user value=\'' . $row['web_user'] . '\'></td>
          	  <td><a href=\'#\'onClick=show_dlg(\'view_ads.php?adsid=' . $row['adsid'] . '\',1020,800)>' . $row['adsid'] . '</a><input name=adsid type=hidden id=adsid value=\'' . $row['adsid'] . '\'></td>
              <td>' . $back_num . '</td>
              <td width=70>' . $row['viewdate'] . '<input name=viewdate type=hidden id=viewdate value=\'' . $row['viewdate'] . '\'></td>
              <td width=70>' . $row['time'] . '</td>
              <td width=70>' . $row['admin_time'] . '</td>
          	  <td><textarea name=conn cols=32 rows=2 class=text onMouseUp="this.select()">' . $row['conn'] . '</textarea><input name=oldconn type=hidden id=oldconn value=\'' . $row['conn'] . '\'></td>
              <td>' . $cfg_checkstat[$state] . '</td>
          	  <td>' . $str_admin . '</td>
            </form></tr>';
    }
  }

  echo '
';
  echo '<s';
  echo 'tyle type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
';
  echo '<s';
  echo 'cript>
<!--
function del_sub(delid){
	var psub=confirm("确认删除吗？");
	if(psub){
		document.hideform.hndelid.value=delid;
		document.hideform.submit();
	}else{
		return 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"';
  echo ' bordercolorlight="#CCCCCC" bordercolordark="#ffffff" bgcolor="#CCCCCC" >
	  <tr bgcolor="F0F0F0">
		<td width="100" height="25"><div align="center">数据异常管理</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="t';
  echo 'xt_search" value="';
  echo $txt_search;
  echo '" size="20" maxlength="20">
			    <input type="submit" name="Submit" value="提交" class=subbt2>
			  
				<input name="hndelid" type="hidden" id="hndelid">
				
				<input name="or_adser" type="hidden" id="or_adser">
				<input name="or_web" type="hidden" id="or_web">
				<input name="or_time" type="hidden" id="or_time">
				<input name="or_admintime" type="hidden" id="or_admintime">
				<input name="or';
  echo '_viewdate" type="hidden" id="or_viewdate">
				<input name="or_adsid" type="hidden" id="or_adsid">
			  </td>
		  </tr></form>
		  </table>
      </td></tr>
	  </table>	  
      <table width="100%" border="0" cellspacing="1" cellpadding="2" class="listtable_admin">
        <tr align="center" class="listbody_admin"> 
          <td class="listtbhd_admin">ID</td>
          <td class="listtbhd_admin"><a href="#" on';
  echo 'Click="order(\'or_adser\',\'';
  echo ($or_adser == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">举报人</span></a>';
  if (!empty ($or_adser))
  {
    echo ($or_adser == '1' ? '▲' : '▼');
  }

  echo '</td>
          <td class="listtbhd_admin"><a href="#" onClick="order(\'or_web\',\'';
  echo ($or_web == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">网站主</span></a>';
  if (!empty ($or_web))
  {
    echo ($or_web == '1' ? '▲' : '▼');
  }

  echo '</td>
          <td class="listtbhd_admin"><a href="#" onClick="order(\'or_adsid\',\'';
  echo ($or_adsid == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">广告ID</span></a>';
  if (!empty ($or_adsid))
  {
    echo ($or_adsid == '1' ? '▲' : '▼');
  }

  echo '</td>
          <td class="listtbhd_admin">返还数</td>
          <td class="listtbhd_admin" width="70"><a href="#" onClick="order(\'or_viewdate\',\'';
  echo ($or_viewdate == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">日期</span></a>';
  if (!empty ($or_viewdate))
  {
    echo ($or_viewdate == '1' ? '▲' : '▼');
  }

  echo '</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" width="70"><a href="#" onClick="order(\'or_admintime\',\'';
  echo ($or_admintime == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">审查时间</span></a>';
  if (!empty ($or_admintime))
  {
    echo ($or_admintime == '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_adser=' . $or_adser . '&or_web=' . $or_web . '&or_adsid=' . $or_adsid . '&or_time=' . $or_time . '&or_viewdate=' . $or_viewdate . '&or_admintime=' . $or_admintime . '&txt_search=' . $txt_search;
  include '../public/pagefoot.php';
  echo '</td>
		  </tr>
		</table>
';
?>