rakeoff_history.php

VIP信息处理系统源码

<?
include_once("top.php");

$pagesize=$cfg_webpagesize;
$list_count="payed where username='$_SESSION[web_username]' and pay_type='1'";
$sql="select * from payed where username='$_SESSION[web_username]' and pay_type='1'";
include("../public/pagehead.php");
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs)){
	$ought_money=$row["ought_money"];
	$real_money=$row["real_money"];
	$pay_date=$row["pay_date"];
	$admin_stat=$row["admin_stat"];
	$admin_time=substr($row["admin_time"],0,10);
	$tot=$ought_money+$row["down_money"];
	$scale=$row["scale"]*100;
	
	$str_disp.="
	  <tr align=center class=\"listbody\">
		<td>$pay_date</td>
		<td>$ought_money</td>
		<td>$row[down_money]</td>
		<td>$tot</td>
		<td>$real_money</td>
		<td>".$scale."%</td>
		<td>$admin_time</td>
		<td>$cfg_applystat[$admin_stat]</td>
		<td><a href=# onClick=\"show_dlg('viewremark.php?id=$row[id]',360,240)\">查看</a></td>
	  </tr>";
}

$sqls="select sum(ought_money) as sum_ought,sum(down_money) as sum_down,sum(real_money) as sum_real from payed where username='$_SESSION[web_username]' and pay_type='1'";
$rss=mysql_query($sqls);
$rows=mysql_fetch_array($rss);
$sum_outght=(empty($rows["sum_ought"]))?"0":$rows["sum_ought"];
$sum_real=(empty($rows["sum_real"]))?"0":$rows["sum_real"];
$sum_down=(empty($rows["sum_down"]))?"0":$rows["sum_down"];
$sum_tot=$sum_down+$sum_outght;

?>
<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/wb4.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">&nbsp;&nbsp;&nbsp;&nbsp;可查询以往您的佣金支付的详细情况。 </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">关于本问题给我们留言</span></a></td>
                              <td width="6%"><img src="../image/bot13.gif" width="16" height="16"></td>
                              <td width="37%" align="left"><span class="orange_text">电话：<?=$cfg_phone?></span></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">
        <tr  align="center" class="listbody"> 
              <td class="listtbhd">结算日期</td>
              <td class="listtbhd">广告金额(元)</td>
              <td class="listtbhd">下线金额(元)</td>
              <td class="listtbhd">合计金额(元)</td>
              <td class="listtbhd">实付金额(元)</td>
              <td class="listtbhd">实付比例</td>
              <td class="listtbhd">支付日期</td>
              <td class="listtbhd">支付状态</td>
              <td class="listtbhd">备注</td>
        </tr>
            <?=$str_disp?>
            <tr align="center" class="listbody">
              <td class="listtbhd">合　　计</td>
              <td><?=$sum_outght?></td>
              <td><?=$sum_down?></td>
              <td><?=$sum_tot?></td>
              <td><?=$sum_real?></td>
              <td colspan="4">&nbsp;</td>
            </tr>
      </table>
		  
      <br>
			<table width="98%" border="0" cellpadding="0" cellspacing="0">
        <tr>
				<td>
				<?
				  $pagestr="";
				  include("../public/pagefoot.php");
				?></td>
			  </tr>
			</table>
	  	  <p><br>
          <br>
          <br>
		  <br>
          </p></td>
  </tr>
</table>
<?
include_once("foot.php");
?>