view_adsnum.php

VIP信息处理系统源码

<?php

  echo '<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" bgcolor="#CCCCCC" >
  <tr bgcolor="F0F0F0"><form name="form1" method="post" action="">
    <td width="162" height="30"><div align="center">
        推荐人下线广告量查询</div></td>
    <td width="846"><table width="45%"  border="0" cellspacing="0" cellpadding="0">
      <t';
  echo 'r>
        <td width="40%" align="right">请选择查询日期：</td>
        <td width="11%">';
  echo '<s';
  echo 'elect name="o_yy">
            ';
  $o_this_m = date ('m');
  for ($o_j = 2005; $o_j <= date ('Y'); ++$o_j)
  {
    if (empty ($o_yy))
    {
      $o_yy = $o_this_y;
    }
    else
    {
      $o_yy = $o_yy;
    }

    if ($o_yy == $o_j)
    {
      $o_sldy = 'selected';
    }
    else
    {
      $o_sldy = '';
    }

    echo '' . '<option ' . $o_sldy . '>' . $o_j . '</option>';
  }

  echo '        </select></td>
        <td width="4%">年</td>
        <td width="11%">';
  echo '<s';
  echo 'elect name="o_mm">
            ';
  for ($o_i = 1; $o_i <= 12; ++$o_i)
  {
    if ($o_i <= 9)
    {
      $o_k = '0' . $o_i;
    }
    else
    {
      $o_k = $o_i;
    }

    if (empty ($o_mm))
    {
      $o_mm = $o_this_m;
    }
    else
    {
      $o_mm = $o_mm;
    }

    if ($o_mm == $o_k)
    {
      $o_sld = 'selected';
    }
    else
    {
      $o_sld = '';
    }

    echo '' . '<option ' . $o_sld . '>' . $o_k . '</option>';
  }

  echo '        </select></td>
        <td width="4%">月</td>
        <td width="30%">&nbsp;<input type="submit" name="Submit" value="提交" class="subbt2"></td>
      </tr>
    </table></td>
  </form></tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="listtable_admin">
	<tr align="center" class="listbody_admin"> 
	  <td class="listtbhd_admin">用户名</td>
	  <td class="listtbhd_admin">弹窗广';
  echo '告总数</td>
	  <td class="listtbhd_admin">点击广告总数</td>
	  <td class="listtbhd_admin">广告总投放数</td>
	  <td class="listtbhd_admin">总金额(元)</td>
	</tr>
';
  $sumopen = 0;
  $sumclick = 0;
  $summoney = 0;
  $sumnum = 0;
  if (empty ($o_yy))
  {
    $o_yy = date ('Y');
  }

  if (empty ($o_mm))
  {
    $o_mm = date ('m');
  }

  $mm = $o_mm + 1;
  $ymday1 = '' . $o_yy . '-' . $o_mm . '-01';
  $ymday2 = date ('Y-m-d', strtotime ('' . $o_yy . '-' . $mm . '-01') - 86400);
  echo '';
  if ($rowdroit['is_admin'] == 1)
  {
    while (list ($k, $v) = each ($cfg_arrrecomm))
    {
      $sqldown = '' . 'select sum(open_num) as totopennum,sum(click_num) as totclicknum,sum(web_money) as tot_money from daydata,webmember where date>=\'' . $ymday1 . '\' and date<=\'' . $ymday2 . '\' and web_user=username and up_user=\'' . $v . '\' and daydata.own_type=1';
      $rsdown = mysql_query ($sqldown);
      $rowdown = mysql_fetch_array ($rsdown);
      $totopennum = $rowdown['totopennum'];
      $totclicknum = $rowdown['totclicknum'];
      $tot_money = $rowdown['tot_money'];
      $totnum = $totopennum + $totclicknum;
      echo '' . '<tr align=center class="listbody_admin"> 
	  <td height=24><a href=\'#\'onClick=show_dlg(\'view_adminuser.php?adseru=' . $v . '\',400,220)>' . $v . '</a></td>
	  <td>' . $totopennum . '</td>
	  <td>' . $totclicknum . '</td>
	  <td>' . $totnum . '</td>
	  <td>' . $tot_money . '</td>
	</tr>';
      $sumopen += $totopennum;
      $sumclick += $totclicknum;
      $summoney += $tot_money;
      $sumnum += $totnum;
    }

    echo '	<tr align="center" class="listbody_admin"> 
	  <td class="listtbhd_admin">合计</td>
	  <td>';
    echo $sumopen;
    echo '</td>
	  <td>';
    echo $sumclick;
    echo '</td>
	  <td>';
    echo $sumnum;
    echo '</td>
	  <td>';
    echo $summoney;
    echo '</td>
	</tr>
';
  }
  else
  {
    $sqldown = '' . 'select sum(open_num) as totopennum,sum(click_num) as totclicknum,sum(web_money) as tot_money from daydata,webmember where date>=\'' . $ymday1 . '\' and date<=\'' . $ymday2 . '\' and web_user=username and up_user=\'' . $_SESSION['admin_username'] . '\' and daydata.own_type=1';
    $rsdown = mysql_query ($sqldown);
    $rowdown = mysql_fetch_array ($rsdown);
    $totopennum = $rowdown['totopennum'];
    $totclicknum = $rowdown['totclicknum'];
    $tot_money = $rowdown['tot_money'];
    $totnum = $totopennum + $totclicknum;
    echo '' . '<tr align=center class="listbody_admin"> 
	  <td height=24>' . $_SESSION['admin_username'] . '</td>
	  <td>' . $totopennum . '</td>
	  <td>' . $totclicknum . '</td>
	  <td>' . $totnum . '</td>
	  <td>' . $tot_money . '</td>
	</tr>';
  }

  echo '</table>';
?>