bankorder_admin.php

VIP信息处理系统源码

<?php

  if (!empty ($_POST['hnpassid']))
  {
    $rsde = mysql_query ('' . 'select * from adser_balance where  bankorder_id=\'' . $_POST['hnpassid'] . '\'');
    $numde = mysql_num_rows ($rsde);
    if (0 < $numde)
    {
      $rowde = mysql_fetch_array ($rsde);
      $sqlin = '' . 'update `adser_balance` set `admin_stat`=\'2\' where id=\'' . $rowde['id'] . '\'';
      $rsin = mysql_query ($sqlin);
    }
    else
    {
      $rowse = mysql_fetch_array (mysql_query ('' . 'select * from bankorder where id=\'' . $_POST['hnpassid'] . '\''));
      $sqlin = '' . 'INSERT INTO  `adser_balance`(`username`, `sub_money`, `real_money`,`type`, `time`,`admin_stat`,`bankorder_id`,`admin_user`,`admin_time`)
							VALUES (\'' . $rowse['username'] . '\', \'' . $rowse['money'] . '\',\'' . $rowse['money'] . '\',\'4\', \'' . $rowse['time'] . '\', \'2\', \'' . $rowse['id'] . '\', \'' . $_SESSION['admin_username'] . '\',\'' . $datetime . '\')';
      $rsin = mysql_query ($sqlin);
    }

    if ($rsin)
    {
      $update = '' . 'update advertizer set balance=balance+' . $rowse['money'] . ' where username=\'' . $rowse['username'] . '\'';
      $rse = mysql_query ($update);
    }

    if ($rse)
    {
      $sql_upb = '' . 'update bankorder set state=\'2\' where id=\'' . $_POST['hnpassid'] . '\'';
      $rs_upb = mysql_query ($sql_upb);
      fun_alert ('操作成功！');
    }
    else
    {
      fun_alert ('操作失败！');
    }

    fun_back ();
    exit ();
  }

  if (!empty ($txt_search))
  {
    $andwhere = '' . ' and (username like \'%' . $txt_search . '%\' or id = \'' . $txt_search . '\' or time like \'%' . $txt_search . '%\' or orderid like \'%' . $txt_search . '%\' or bank like \'%' . $txt_search . '%\') ';
  }

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

  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_money))
  {
    $orderby = ($or_money == '1' ? ' money asc,' : ' money desc,');
  }

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

  $pagesize = $cfg_adminpagesize;
  $list_count = '' . 'bankorder where 1 ' . $andwhere;
  $sql = '' . 'select * from bankorder where 1 ' . $andwhere . ' order by  ' . $orderby . ' id desc';
  include '../public/pagehead.php';
  $rs = mysql_query ($sql);
  $str_disp = '';
  while (true)
  {
    if ($row = mysql_fetch_array ($rs))
    {
      $stat = $row['state'];
      $bank = (empty ($row[bank]) ? '&nbsp;' : '' . $row['bank']);
      $rs_a = mysql_query ('' . 'select admin_stat from adser_balance where bankorder_id=\'' . $row['id'] . '\'');
      $row_a = mysql_fetch_array ($rs_a);
      if ($row_a['admin_stat'] != 2)
      {
        $passflag = '' . ' onClick="pass_sub(' . $row['id'] . ')"';
        $str_stat = '<font color=ff6600>否</font>';
      }

      $str_stat = '<font color=009900>是</font>';
      $str_admin = '' . '<input name=pass type=button id=pass class=subbt2 value=\'到帐\' ' . $passflag . '>';
      $str_disp .= '' . '
        <tr align=center class="listbody_admin"> 
          <td><a href=\'http://www.dpay.net\' target=\'_blank\'>' . $row['orderid'] . '</a></td>
          <td><a href=\'#\'onClick=show_dlg(\'view_adser.php?adserid=' . $row['userid'] . '\',500,380)>' . $row['username'] . '</a></td>
          <td>' . $row['time'] . '</td>
          <td>' . $row['money'] . '</td>
          <td>' . $bank . '</td>
          <td>' . $cfg_bankstat[$stat] . '</td>
          <td>' . $str_stat . '</td>
          <td>' . $str_admin . '</td>
        </tr>';
    }
  }

  echo '
';
  echo '<s';
  echo 'tyle type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
';
  echo '<s';
  echo 'cript>
<!--
function pass_sub(id){
	var psub=confirm("确认到帐吗？");
	if(psub){
		document.hideform.hnpassid.value=id;
		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" borderc';
  echo 'olor="#FFFFFF" 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="te';
  echo 'xt" 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="or_orderid" type="hidden" id="or_orderid">
				<input name="or_state" type="hidden" id="or_state">
				<input name="or_name" type="hidden" id="or_name">
				<input name="or_time" type="hidden" id="or_time">
				<input name=';
  echo '"or_money" type="hidden" id="or_money">
			  </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"><a href="#" onClick="order(\'or_orderid\',\'';
  echo ($or_orderid == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">订单号</span></a>';
  if (!empty ($or_orderid))
  {
    echo ($or_orderid == '1' ? '▲' : '▼');
  }

  echo '</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"><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_money\',\'';
  echo ($or_money == '2' ? '1' : '2');
  echo '\')">';
  echo '<s';
  echo 'pan class="style1">金额(元)</span></a>';
  if (!empty ($or_money))
  {
    echo ($or_money == '1' ? '▲' : '▼');
  }

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

  echo '</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_state=' . $or_state . '&or_orderid=' . $or_orderid . '&or_money=' . $or_money . '&txt_search=' . $txt_search;
  include '../public/pagefoot.php';
  echo '</td>
		  </tr>
		</table>
';
?>