webpay_admin.php

VIP信息处理系统源码

<?php

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

    fun_back ();
    exit ();
  }

  if (!empty ($_POST['hnpayed']))
  {
    $sql = '' . 'update payed set admin_stat=\'2\',scale=\'' . $_POST['hn_scale'] . '\',real_money=\'' . $_POST['hn_realmoney'] . '\',remark=\'' . $_POST['hn_remark'] . '\',admin_time=\'' . $datetime . '\',admin_user=\'' . $_SESSION['admin_username'] . '\' where id=\'' . $_POST['hnpayed'] . '\'';
    $rs = mysql_query ($sql);
    if ($rs)
    {
      fun_alert ('操作成功！');
    }
    else
    {
      fun_alert ('操作失败！');
    }

    fun_back ();
    exit ();
  }

  echo '
';
  echo '<s';
  echo 'tyle type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
';
  echo '<s';
  echo 'cript>
<!--
function pay_sub(id){
	var psub=confirm("确认结算吗？");
	if(psub){
		var va_sc=eval("scale_"+id);
		var va_mo=eval("realmoney_"+id);
		var va_mark=eval("remark_"+id);
		if(va_sc.value==""){
			alert("请输入实付比例值！");
			va_sc.focus();
			return false;
		}else{
			document.hideform.hnpayed.value=id;
			document.hideform.hn_scale.value=va_sc.value;
			document.hidefor';
  echo 'm.hn_realmoney.value=va_mo.value;
			document.hideform.hn_remark.value=va_mark.value;
			document.hideform.submit();
		}
	}else{
		return false;
	}
}

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.hidefor';
  echo 'm."+obj);
	temp.value=val;
	document.hideform.submit();
}

function chreal(id){
	var temp1=eval("scale_"+id);
	var temp2=eval("realmoney_"+id);
	var temp3=eval("oughtmoeny_"+id);
	if(temp1.value!="" && !check_number("实付比",temp1)){
		var va=1*temp1.value*temp3.value;
		temp2.value=Math.round(va*100)/100;
	}
}

function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".locati';
  echo 'on=\'"+selObj.options[selObj.selectedIndex].value+"\'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</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">佣金支付记录</div></td>
	  	<td>
		  <table width=';
  echo '"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">
			    ';
  echo '<s';
  echo 'elect name="pay_date" onChange="MM_jumpMenu(\'parent\',this,0)">
			      <option value=\'#\'>选择结算周期</option>
				 ';
  $sqld = 'select pay_date from payed where pay_type=1 group by pay_date order by pay_date asc';
  $rsd = mysql_query ($sqld);
  while ($rowd = mysql_fetch_array ($rsd))
  {
    $ldate = $rowd['pay_date'];
    echo '' . '<option value=\'?tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm . '&paydate=' . $rowd['pay_date'] . '\'';
    if ((empty ($paydate) OR $paydate == $rowd['pay_date']))
    {
      echo ' selected';
    }

    echo '' . '>' . $rowd['pay_date'] . '</option>';
  }

  $sqlmem = 'select is_lock,username from webmember where 1';
  $rsmem = mysql_query ($sqlmem);
  while ($rowmem = mysql_fetch_array ($rsmem))
  {
    $mem_user = $rowmem['username'];
    $arr_memlock['' . $mem_user] = $rowmem['is_lock'];
  }

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

  $datewhere = (empty ($paydate) ? $ldate : $paydate);
  switch ($se_ispay)
  {
    case '3':
    {
      $andwhere .= '';
      break;
    }

    case '2':
    {
      $andwhere .= ' and admin_stat=2';
      break;
    }

    default:
    {
      $andwhere .= ' and admin_stat=1';
      if ()
      {
        $orderby = '';
        if ($datewhere == 'thiscol')
        {
          $orderby = ' sum_money desc,';
        }
        else
        {
          if ($datewhere != 'all')
          {
            $andwhere .= '' . ' and pay_date=\'' . $datewhere . '\'';
          }
        }

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

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

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

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

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

        $str_disp = '';
        $pagesize = $cfg_adminpagesize;
        if ($datewhere == 'thiscol')
        {
          $list_count = '' . 'payed WHERE pay_type = \'1\' ' . $andwhere . ' GROUP BY username';
          $sql = '' . 'SELECT username,sum( ought_money ) as ought_money ,sum( down_money ) as down_money ,sum( real_money ) as real_money ,sum( ought_money+down_money ) as sum_money ,pay_date,admin_time,scale FROM payed WHERE pay_type = \'1\' ' . $andwhere . ' GROUP BY username ORDER BY ' . $orderby . ' username desc';
        }

        $sql = ;
        include '../public/pagehead.php';
        $rs = mysql_query ($sql);
        while (true)
        {
          if ($row = mysql_fetch_array ($rs))
          {
            $state = $row['admin_stat'];
            $tot = $row['ought_money'] + $row['down_money'];
            $username = $row['username'];
            $rowid = $row['id'];
            $remark = $row['remark'];
            if ($state == 1)