rakeoff_month.php

VIP信息处理系统源码

<?php

  $sqld = '' . 'select * from admin where username=\'' . $_SESSION['admin_username'] . '\'';
  $rsd = mysql_query ($sqld);
  $rowd = mysql_fetch_array ($rsd);
  $userdp = $rowd['profit'];
  $sqla = '' . 'select * from advertizer where adser_owner=\'' . $_SESSION['admin_username'] . '\'';
  $rsa = mysql_query ($sqla);
  $rowa = mysql_fetch_array ($rsa);
  $sqlf_user = '' . ' and (adser_user=\'' . $rowa['username'] . '\' ';
  while ($rowa = mysql_fetch_array ($rsa))
  {
    $sqlf_user .= '' . ' or adser_user=\'' . $rowa['username'] . '\' ';
  }

  $sqlf_user .= ')';
  $nowm1 = date ('Y-m') . '01';
  $nowm2 = date ('Y-m') . '31';
  $sql = '' . 'select date,sum( adser_money ) as tot_money, sum(adser_money-web_money) as profit from daydata where date>=\'' . $nowm1 . '\' and date <=\'' . $nowm2 . '\' ' . $sqlf_user . ' group by date ORDER BY date';
  $rs = mysql_query ($sql);
  $str_disp = '';
  $sum_profit = 0;
  $sum_totmoney = 0;
  $sum_money = 0;
  while ($row = mysql_fetch_array ($rs))
  {
    $sum_totmoney = $sum_totmoney + $row[tot_money];
    $sum_profit = $sum_profit + $row[profit];
    $money = round ($userdp * $row[profit] * 100) / 100;
    $sum_money = $sum_money + $money;
    if ($row[tot_money] != 0)
    {
      $str_disp .= '' . '
	  <tr align=center class="listbody_admin" height=25>
		<td>' . $row['date'] . '</td>
		<td>' . $row['tot_money'] . '</td>
		<td>' . $row['profit'] . '</td>
		<td>' . $money . '</td>
	  </tr>';
      continue;
    }
  }

  echo '<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" bgcolor="#CCCCCC" >
  <tr bgcolor="F0F0F0">
    <td width="100" height="30"><div align="center">
        本月佣金查询
    </div></td>
    <td>&nbsp;</td>
  </tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="2" class="listtable_admin">
<tr ';
  echo 'align="center" class="listbody_admin"> 
	  <td class="listtbhd_admin">日　　期</td>
	  <td class="listtbhd_admin">广告金额(元)</td>
	  <td class="listtbhd_admin">利润额(元)</td>
	  <td class="listtbhd_admin">金额(元)</td>
</tr>
	';
  echo $str_disp;
  echo '<tr align="center" class="listbody_admin"> 
	  <td class="listtbhd_admin">合　　计</td>
	  <td>';
  echo $sum_totmoney;
  echo '</td>
	  <td>';
  echo $sum_profit;
  echo '</td>
	  <td>';
  echo $sum_money;
  echo '</td>
</tr>
</table>
  	  ';
?>