data_history.php

VIP信息处理系统源码

<?php

  if ($rowdroit['is_admin'] == 1)
  {
    $sqlfadmin = '';
    $sqlfadzer = '';
  }
  else
  {
    $sqlowner = '' . 'select username from advertizer where adser_owner=\'' . $_SESSION['admin_username'] . '\'';
    $rsowner = mysql_query ($sqlowner);
    $sqlfadmin = ' and (';
    $sqlfadzer = ' and (';
    while ($rowner = mysql_fetch_array ($rsowner))
    {
      $sqlfadmin .= '' . 'adser_user=\'' . $rowner['username'] . '\' or ';
      $sqlfadzer .= '' . 'username=\'' . $rowner['username'] . '\' or ';
    }

    $sqlfadmin = substr ($sqlfadmin, 0, strlen ($sqlfadmin) - 4) . ')';
    $sqlfadzer = substr ($sqlfadzer, 0, strlen ($sqlfadzer) - 4) . ')';
  }

  $start_date = $s_yy . '-' . $s_mm . '-' . $s_dd;
  $over_date = $o_yy . '-' . $o_mm . '-' . $o_dd;
  if (($start_date == '--' OR $over_date == '--'))
  {
    $datedef = date ('Y-m-d', time () - 259200);
    $nowdate = date ('Y-m-d', time () - 86400);
    $sqlf_date = '' . ' and date>=\'' . $datedef . '\' and date<=\'' . $nowdate . '\' ';
  }
  else
  {
    $sqlf_date = '' . ' and date>=\'' . $start_date . '\' and date<=\'' . $over_date . '\' ';
  }

  if (($adsid == 'all' OR empty ($adsid)))
  {
    $sqlf_date .= '';
  }
  else
  {
    $sqlf_date .= '' . ' and ads_id=\'' . $adsid . '\'';
  }

  if ($adser_name == 'all_advertizer_everyday')
  {
    $sqlf_date .= '';
  }
  else
  {
    $sqlf_date .= '' . ' and adser_user=\'' . $adser_name . '\'';
  }

  if ((!empty ($adsid) AND $adsid != 'all'))
  {
    $str_adsid = '' . '<input type="button" name="viewads" value="查看广告信息" class=subbt onClick="show_dlg(\'view_ads.php?adsid=' . $adsid . '\',680,520)">';
  }
  else
  {
    $str_adsid = '';
  }

  $str_disp = '';
  $sum_open = 0;
  $sum_click = 0;
  $sum_adsermoney = 0;
  $sum_webmoney = 0;
  $sum_profit = 0;
  $sum_pv = 0;
  $i = 0;
  $sql = '' . 'select date,sum( open_num ) as totopen, sum( click_num ) as totclick, sum( pv_num ) as pv_num, sum( adser_money ) as t_adsermoney, sum( web_money ) as t_webmoney from daydata where 1 ' . $sqlf_date . ' ' . $sqlfadmin . ' GROUP BY date ORDER BY date';
  $rs = mysql_query ($sql);
  while ($row = mysql_fetch_array ($rs))
  {
    $totopen = (empty ($row[totopen]) ? 1 : $row[totopen]);
    $rate = round ($row[totclick] / $totopen * 100);
    if ($date != $row['date'])
    {
      $sum_open = $sum_open + $row[totopen];
      $sum_click = $sum_click + $row[totclick];
      $sum_pv = $sum_pv + $row[pv_num];
      $sum_adsermoney = $sum_adsermoney + $row[t_adsermoney];
      $sum_webmoney = $sum_webmoney + $row[t_webmoney];
      $arr_disp[0][$i] = $row['date'];
      $arr_disp[1][$i] = $row['totopen'];
      $arr_disp[2][$i] = $row['totclick'];
      $arr_disp[3][$i] = $rate;
      $arr_disp[4][$i] = $row['t_adsermoney'];
      $arr_disp[5][$i] = $row['t_webmoney'];
      $arr_disp[6][$i] = $row['pv_num'];
      ++$i;
      continue;
    }
  }

  while (true)
  {
    if (list ($k, $v) = each ($arr_disp[0]))
    {
      $aopen = $arr_disp[1][$k];
      $aclick = $arr_disp[2][$k];
      $rate = $arr_disp[3][$k];
      $adser_money = $arr_disp[4][$k];
      $web_money = $arr_disp[5][$k];
      $pv_num = $arr_disp[6][$k];
      if ($aopen == 0)
      {
        $rate = 0;
      }

      $r_open = round ($aopen / $sum_open * 100);
      $r_click = round ($aclick / $sum_click * 100);
      if ((($adsid == 'all' OR $adser_name == 'all_advertizer_everyday') OR empty ($adsid)))
      {
        $str_open = $aopen;
        $str_click = $aclick;
        $str_ocdata = '<font color=aaaaaa>--</font>';
      }

      $str_ocdata = ;
      $profit = $adser_money - $web_money;
      $str_disp .= '' . '
	  <tr align=center class="listbody_admin">
		<td>' . $v . '</td>
		<td>' . $str_open . '</td>
		<td>' . $str_click . '</td>
		<td>' . $pv_num . '</td>
		<td>' . $rate . '%</td>
		<td>' . $r_open . '%</td>
		<td>' . $r_click . '%</td>
		<td>' . $str_ocdata . '</td>
		<td>' . $adser_money . '</td>
		<td>' . $web_money . '</td>
		<td>' . $profit . ('' . '</td>
		<td><input type="button" name="viewweb" value="查看投放网站" class=subbt onClick="viewweb(\'' . $v . '\')"></td>
	  </tr>');
    }
  }

  echo '<s';
  echo 'cript language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location=\'"+selObj.options[selObj.selectedIndex].value+"\'");
  if (restore) selObj.selectedIndex=0;
}
function picview(){
	document.form_pic.submit();
}
function viewweb(date){
	adser=document.hideform.adser_name.value;
	adsid=document.form_pic.adsid.value;
	open("adm';
  echo 'in.php?tm=3&nid=61&nm=view_web&viewdate="+date+"&adser="+adser+"&adsid="+adsid);
}
//-->
</script>

		<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" bgcolor="#CCCCCC" >
		  <tr bgcolor="F0F0F0">
			<td>
			  <table width="100%" border="0" cellpadding="0" cellspacing="0">
			  <form name="hideform" method=';
  echo '"post" action="">
			  <tr>
				<td>
				';
  echo '<s';
  echo 'elect name="adsername" onChange="MM_jumpMenu(\'parent\',this,0)" class="text">
				  <option value="#">请选择广告主</option>
				  ';
  $sqladser = 'select * from advertizer where admin_stat!=1 order by id';
  $rsadser = mysql_query ($sqladser);
  while (true)
  {
    if ($rowadser = mysql_fetch_array ($rsadser))
    {
      $adzer = strtolower ($rowadser['username']);
      $arr_adzer['' . $adzer] = $rowadser['comname'];
    }
  }

  $sqlads = '' . 'select * from ads where username!=\'ads_commonweal\' ' . $sqlfadzer . ' group by username';
  $rsads = mysql_query ($sqlads);
  while (true)
  {
    if ($rowads = mysql_fetch_array ($rsads))
    {
      $adzer = strtolower ($rowads['username']);
      echo '' . '<option value="?tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm . '&adser_name=' . $rowads['username'] . '" ';
      if ($rowads[username] == $adser_name)
      {
        echo ' selected';
      }

      echo '' . '>' . $arr_adzer[$adzer] . '(' . $rowads['username'] . ')</option>';
    }
  }

  if ($rowdroit['is_admin'] == 1)
  {
    echo '				  <option value="?';
    echo '' . 'tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm;
    echo '&adser_name=ads_commonweal" ';
    if ($adser_name == 'ads_commonweal')
    {
      echo ' selected';
    }

    echo '>公益广告</option>
				';
  }

  echo '				  <option value="?';
  echo '' . 'tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm;
  echo '&adser_name=all_advertizer_everyday" ';
  if ($adser_name == 'all_advertizer_everyday')
  {
    echo ' selected';
  }

  echo '>全部广告主</option>
                </select>
				';
  echo '<s';
  echo 'elect name="adsid" onChange="MM_jumpMenu(\'parent\',this,0)" class="text">
				  <option value="#">请选择广告项目</option>
				  ';
  $sqlads = '' . 'select * from ads where username=\'' . $adser_name . '\' and admin_stat!=\'1\' ' . $sqlfadzer . ' order by admin_stat,id desc';
  $rsads = mysql_query ($sqlads);
  while (true)
  {
    if ($rowads = mysql_fetch_array ($rsads))
    {
      echo '' . '<option value="?tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm . '&adser_name=' . $adser_name . '&adsid=' . $rowads['id'] . '" ';
      if ($rowads[id] == $adsid)
      {
        echo ' selected';
      }

      echo '' . '>' . $rowads['link_tit'] . '(' . $rowads['id'] . ')</option>';
    }
  }

  echo '				  <option value="?';
  echo '' . 'tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm . '&adser_name=' . $adser_name;
  echo '&adsid=all" ';
  if ($adsid == 'all')
  {
    echo ' selected';
  }

  echo '>全部广告项目</option>
                </select>
				  <input name="adser_name" type="hidden" id="adser_name" value="';
  echo $adser_name;
  echo '"><input name="adsid" type="hidden" id="adsid" value="';
  echo $adsid;
  echo '"></td>
			    <td align="right">
				  <table width="1%"  border="0" align="right" cellspacing="1">
					  <tr>
						<td width="1">';
  echo '<s';
  echo 'elect name="s_yy">
							';
  $s_this_y = date ('Y', time () - 259200);
  $s_this_m = date ('m', time () - 259200);
  $s_this_d = date ('d', time () - 259200);
  while (true)
  {
    for ($s_j = 2004; $s_j <= $s_this_y; ++$s_j)
    {
      if (empty ($s_yy))
      {
        $s_yy = $s_this_y;
      }

      $s_yy = $s_yy;
      if ($s_yy == $s_j)
      {
        $s_sldy = 'selected';
      }

      $s_sldy = '';
      echo '' . '<option ' . $s_sldy . '>' . $s_j . '</option>';
    }
  }

  echo '						</select></td>
						<td width="1">';
  echo '<s';
  echo 'elect name="s_mm">
							';
  while (true)
  {
    for ($s_i = 1; $s_i <= 12; ++$s_i)
    {
      if ($s_i <= 9)
      {
        $s_k = '0' . $s_i;
      }

      $s_k = $s_i;
      if (empty ($s_mm))
      {
        $s_mm = $s_this_m;
      }

      $s_mm = $s_mm;
      if ($s_mm == $s_k)
      {
        $s_sld = 'selected';
      }

      $s_sld = '';
      echo '' . '<option ' . $s_sld . '>' . $s_k . '</option>';
    }
  }

  echo '						</select></td>
						<td width="1">';
  echo '<s';
  echo 'elect name="s_dd">
							';
  while (true)
  {
    for ($s_i = 1; $s_i <= 31; ++$s_i)
    {
      if ($s_i <= 9)
      {
        $s_l = '0' . $s_i;
      }

      $s_l = $s_i;
      if (empty ($s_dd))
      {
        $s_dd = $s_this_d;
      }

      $s_dd = $s_dd;
      if ($s_dd == $s_l)
      {
        $s_sldd = 'selected';
      }

      $s_sldd = '';
      echo '' . '<option ' . $s_sldd . '>' . $s_l . '</option>';
    }
  }

  echo '						</select></td>
					  </tr>
					</table></td>
					<td> 至 </td>
					<td width="1%"><table width="1%"  border="0" cellspacing="1">
					  <tr>
						<td width="1">';
  echo '<s';
  echo 'elect name="o_yy">
							';
  $o_this_y = date ('Y', time () - 86400);
  $o_this_m = date ('m', time () - 86400);
  $o_this_d = date ('d', time () - 86400);
  while (true)
  {
    for ($o_j = 2004; $o_j <= $o_this_y; ++$o_j)
    {
      if (empty ($o_yy))
      {
        $o_yy = $o_this_y;
      }

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

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

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

      $o_k = $o_i;
      if (empty ($o_mm))
      {
        $o_mm = $o_this_m;
      }

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

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

  echo '						</select></td>
						<td width="1">';
  echo '<s';
  echo 'elect name="o_dd">
							';
  while (true)
  {
    for ($o_i = 1; $o_i <= 31; ++$o_i)
    {
      if ($o_i <= 9)
      {
        $o_l = '0' . $o_i;
      }

      $o_l = $o_i;
      if (empty ($o_dd))
      {
        $o_dd = $o_this_d;
      }

      $o_dd = $o_dd;
      if ($o_dd == $o_l)
      {
        $o_sldd = 'selected';
      }

      $o_sldd = '';
      echo '' . '<option ' . $o_sldd . '>' . $o_l . '</option>';
    }
  }

  echo '				
						</select></td>
					  </tr>
					</table>
				</td><td>
				  <input type="submit" name="Submit" value="查看" class=subbt2><input type="button" name="Submit2" value="图示" class=subbt2 onClick="picview()">';
  echo $str_adsid;
  echo '</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">日　　期</td>
              <td class="listtbhd">弹出数</td>
              <td class="listtbhd">点击数</td>
              <td class="listtbhd">PV数</td>
           ';
  echo '   <td class="listtbhd_admin">点/弹比例</td>
			  <td class="listtbhd_admin">弹占区间比</td>
			  <td class="listtbhd_admin">点占区间比</td>
              <td class="listtbhd_admin">综合图</td>
              <td class="listtbhd_admin">广告主金额</td>
              <td class="listtbhd_admin">网站主金额</td>
              <td class="listtbhd_admin">利润额(元)</td>
              <td class="listtbhd_admin">操';
  echo '作</td>
        </tr>
            ';
  echo $str_disp;
  echo '        <tr align="center" class="listbody_admin"> 
              <td class="listtbhd_admin">合　　计</td>
              <td>';
  echo $sum_open;
  echo '</td>
              <td>';
  echo $sum_click;
  echo '</td>
              <td>';
  echo $sum_pv;
  echo '</td>
              <td colspan="4">&nbsp;</td>
              <td>';
  echo $sum_adsermoney;
  echo '</td>
              <td>';
  echo $sum_webmoney;
  echo '</td>
              <td>';
  $sum_profit = $sum_adsermoney - $sum_webmoney;
  echo $sum_profit;
  echo '</td>
              <td>&nbsp;</td>
            </tr>
          </table>
  	  <form name="form_pic" method="post" action="admin.php?tm=3&nid=53&nm=data_historypic">
  	    <input name="adser_name" type="hidden" id="adser_name" value="';
  echo $adser_name;
  echo '">
  	    <input name="adsid" type="hidden" id="adsid" value="';
  echo $adsid;
  echo '">
  	  </form>
';
?>