📄 data_stat.php
字号:
<?php
$sqla = 'select * from ads_form where 1';
$rsa = mysql_query ($sqla);
while ($rowa = mysql_fetch_array ($rsa))
{
$a_id = $rowa['id'];
$arr_adsform[$a_id] = '' . $rowa['width'] . '*' . $rowa['height'];
}
if (!empty ($txt_search))
{
$andwhere = '' . ' and (ads.id = \'' . $txt_search . '\' or daydata.open_num = \'' . $txt_search . '\' or daydata.click_num = \'' . $txt_search . '\' or link_tit like \'%' . $txt_search . '%\' or daydata.adser_user like \'%' . $txt_search . '%\') ';
}
if (!empty ($or_name))
{
$orderby = ($or_name == '1' ? ' ads.username asc,' : ' ads.username desc,');
}
if (!empty ($or_open))
{
$orderby = ($or_open == '1' ? ' daydata.open_num asc,' : ' daydata.open_num desc,');
}
if (!empty ($or_click))
{
$orderby = ($or_click == '1' ? ' daydata.click_num asc,' : ' daydata.click_num desc,');
}
$thisdate = date ('Y_m_d');
$thishour = date ('H');
$sum_open = 0;
$sum_click = 0;
$sum_webmoney = 0;
$sum_adsermoney = 0;
$sum_profit = 0;
$str_disp = '';
$pagesize = $cfg_adminpagesize;
$sqlfviewd = '';
$sql = '' . 'select ads.username,link_tit,ads.spare,ads.ads_form_id,daydata.ads_id,sum(daydata.open_num) as open_num,sum(daydata.pv_num ) as pv_num,sum(daydata.click_num) as click_num,daydata.profit,daydata.rate,daydata.price,daydata.ads_type,daydata.coltime from ads,daydata where daydata.date=\'' . $date . '\' and ads_id=ads.id ' . $andwhere . ' ' . $sqlfadmin . ' group by daydata.ads_id order by ' . $orderby . ' daydata.ads_id desc';
$rs = mysql_query ($sql);
while (true)
{
if ($row = mysql_fetch_array ($rs))
{
$sqlfviewd .= '' . ' and daydata.ads_id!=' . $row['ads_id'];
$openfile = '../data/' . $row['username'] . '/open_' . $row['ads_id'] . ('' . '/' . $thisdate . '/' . $thishour . '/' . $thishour . '.txt');
if (file_exists ($openfile))
{
$fdata = file ($openfile);
$fcount = count ($fdata);
$totopennum = $row[open_num] + $fcount;
}
$totopennum = ;
$totclicknum = $row[click_num];
$totopen = (empty ($totopennum) ? 1 : $totopennum);
$rate = (empty ($totopennum) ? '0' : round ($totclicknum / $totopen * 100));
$ads_form_id = $row['ads_form_id'];
$ads_type = $row[ads_type];
if ($ads_type == 1)
{
$spec = '混合(' . $arr_adsform[$ads_form_id] . ')';
}
$spec = ;
if ($row[ads_type] == 3)
{
$strtype = '<font color=ff3300>*</font>';
}
$strtype = '';
if ((($totopennum < 1 AND $row[ads_type] != 3) AND $row[ads_type] != 4))
{
$web_money = 0;
$adser_money = 0;
$admin_profit = 0;
$rate = '0';
$str_vopen = '' . $totopennum;
}
$str_vopen = ;
if (!empty ($totclicknum))
{
$str_vclick = '' . '<a href=\'../adser/view_daydata.php?op=click&adsid=' . $row['ads_id'] . '&adsername=' . $row['username'] . '\' target=\'_blank\'>' . $totclicknum . '</a>';
}
$str_vclick = $totclicknum;
$sum_open = $sum_open + $totopennum;
$sum_click = $sum_click + $totclicknum;
$sum_webmoney = $sum_webmoney + $web_money;
$sum_adsermoney = $sum_adsermoney + $adser_money;
$sum_profit = $sum_profit + $admin_profit;
if ($rowdroit['is_admin'] == 1)
{
$strusername = '' . '<a href=\'./loginto.php?username=' . $row['username'] . '&login_type=adser\' target=\'_blank\'>' . $row['username'] . '</a>';
}
$strusername = ;
if ($row['username'] == 'ads_commonweal')
{
$adserin = '公益广告';
}
$adserin = ;
$str_disp .= '' . '
<tr align=center class="listbody_admin">
<td><a href=\'#\' onClick="show_dlg(\'view_ads.php?adsid=' . $row['ads_id'] . '\',680,520)">' . $row['ads_id'] . '</a></td>
<td align=left>' . $adserin . '</td>
<td align=left>' . $strtype . ('' . $row['link_tit'] . '</td>
<td>' . $spec . '</td>
<td>' . $str_vopen . '</td>
<td>' . $str_vclick . '</td>
<td><a href=\'../adser/view_ocpdata.php?adsid=' . $row['ads_id'] . '&adsername=' . $row['username'] . '\' target=\'_blank\'>') . $rate . ('' . '%</a></td>
<td>' . $row['spare'] . '</td>
<td>' . $adser_money . '</td>
<td>' . $web_money . '</td>
<td>' . $admin_profit . '</td>
<td><input type="button" name="viewweb" value="查看" class=subbt2 onClick="viewweb(\'' . $row['username'] . '\',\'' . $row['ads_id'] . '\')"></td>
</tr>');
}
}
$yestoday = date ('Y-m-d', time () - 86400);
$sql = '' . 'select ads.username,link_tit,ads.spare,ads.ads_form_id,daydata.ads_id,daydata.profit,daydata.rate,daydata.price,daydata.ads_type,daydata.coltime from ads,daydata where daydata.date=\'' . $yestoday . '\' ' . $sqlfviewd . ' and ads_id=ads.id and daydata.ads_type!=3 ' . $andwhere . ' ' . $sqlfadmin . ' group by daydata.ads_id order by ' . $orderby . ' daydata.ads_id desc';
$rs = mysql_query ($sql);
while ($row = mysql_fetch_array ($rs))
{
$totopennum = 0;
for ($i = 0; $i <= $thishour; ++$i)
{
if ($i < 10)
{
$si = '0' . $i;
}
$si = $i;
$openfile = '../data/' . $row['username'] . '/open_' . $row['ads_id'] . ('' . '/' . $thisdate . '/' . $si . '/' . $si . '.txt');
if (file_exists ($openfile))
{
$fdata = file ($openfile);
$fcount = count ($fdata);
$totopennum = $fcount;
continue;
}
}
$totclicknum = 0;
if (0 < $totopennum)
{
$totopen = (empty ($totopennum) ? 1 : $totopennum);
$rate = (empty ($totopennum) ? '0' : round ($totclicknum / $totopen * 100));
$ads_form_id = $row['ads_form_id'];
$ads_type = $row[ads_type];
if ($ads_type == 1)
{
$spec = '混合(' . $arr_adsform[$ads_form_id] . ')';
}
$spec = ;
if ($row[ads_type] == 3)
{
$strtype = '<font color=ff3300>*</font>';
}
$strtype = '';
if ((($totopennum < 1 AND $row[ads_type] != 3) AND $row[ads_type] != 4))
{
$web_money = 0;
$adser_money = 0;
$admin_profit = 0;
$rate = '0';
$str_vopen = '' . $totopennum;
}
$str_vopen = ;
if (!empty ($totclicknum))
{
$str_vclick = '' . '<a href=\'../adser/view_daydata.php?op=click&adsid=' . $row['ads_id'] . '&adsername=' . $row['username'] . '\' target=\'_blank\'>' . $totclicknum . '</a>';
}
$str_vclick = $totclicknum;
$sum_open = $sum_open + $totopennum;
$sum_click = $sum_click + $totclicknum;
$sum_webmoney = $sum_webmoney + $web_money;
$sum_adsermoney = $sum_adsermoney + $adser_money;
$sum_profit = $sum_profit + $admin_profit;
if ($row['username'] == 'ads_commonweal')
{
$adserin = '公益广告';
}
$adserin = ;
$str_disp .= '' . '
<tr align=center class="listbody_admin">
<td><a href=\'#\' onClick="show_dlg(\'view_ads.php?adsid=' . $row['ads_id'] . '\',680,520)">' . $row['ads_id'] . '</a></td>
<td align=left>' . $adserin . '</td>
<td align=left>' . $strtype . ('' . $row['link_tit'] . '</td>
<td>' . $spec . '</td>
<td>' . $str_vopen . '</td>
<td>' . $str_vclick . '</td>
<td><a href=\'../adser/view_ocpdata.php?adsid=' . $row['ads_id'] . '&adsername=' . $row['username'] . '\' target=\'_blank\'>') . $rate . ('' . '%</a></td>
<td>' . $row['spare'] . '</td>
<td>' . $adser_money . '</td>
<td>' . $web_money . '</td>
<td>' . $admin_profit . '</td>
<td><input type="button" name="viewweb" value="查看" class=subbt2 onClick="viewweb(\'' . $row['username'] . '\',\'' . $row['ads_id'] . '\')"></td>
</tr>');
continue;
}
}
echo '<s';
echo 'tyle type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
';
echo '<s';
echo 'cript>
<!--
function order(obj,val){
var temp=eval("document.hideform."+obj);
temp.value=val;
document.hideform.submit();
}
function viewweb(adser,adsid){
open("admin.php?tm=3&nid=61&nm=view_web&adser="+adser+"&adsid="+adsid);
}
-->
</script>
<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" ';
echo 'bgcolor="#CCCCCC" >
<tr bgcolor="F0F0F0">
<td width="100" height="25"><div align="center">
本日数据统计
</div></td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<form name="hideform" method="post" action="">
<tr>
<td width="40" align=right>搜索:</td>
';
echo ' <td><input name="txt_search" type="text" class="text" id="txt_search" value="';
echo $txt_search;
echo '" size="20" maxlength="50">
<input type="submit" name="Submit" value="提交" class=subbt2>
<input name="or_name" type="hidden" id="or_name">
<input name="or_open" type="hidden" id="or_open">
<input name="or_click" type="hidden" id="or_click">
</td>
</tr>
</form>
';
echo ' </table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="listtable_admin">
<tr align="center" class="listbody_admin" height="30">
<td class="listtbhd_admin">ID</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_name\',\'';
echo ($or_name == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">广告主</span></a>';
if (!empty ($or_name))
{
echo ($or_name == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin">项目名称</td>
<td class="listtbhd_admin">规格</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_open\',\'';
echo ($or_open == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">弹/PV数</span></a>';
if (!empty ($or_open))
{
echo ($or_open == '1' ? '▲' : '▼');
}
echo '</td>
<td class="listtbhd_admin"><a href="#" onClick="order(\'or_click\',\'';
echo ($or_click == '2' ? '1' : '2');
echo '\')">';
echo '<s';
echo 'pan class="style1">点击数</span></a>';
if (!empty ($or_click))
{
echo ($or_click == '1' ? '▲' : '▼');
}
echo '</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>
</tr>
';
echo $str_disp;
echo ' <tr align="center" class="listbody_admin">
<td colspan="2" class="listtbhd_admin">合计</td>
<td colspan="2"> </td>
<td>';
echo $sum_open;
echo '</td>
<td>';
echo $sum_click;
echo '</td>
<td colspan="2"> </td>
<td>';
echo $sum_adsermoney;
echo '</td>
<td>';
echo $sum_webmoney;
echo '</td>
<td>';
echo $sum_profit;
echo '</td>
<td></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
';
$pagestr = '' . '&tm=' . $tm . '&nid=' . $nid . '&nm=' . $nm . '&or_name=' . $or_name . '&or_open=' . $or_open . '&or_click=' . $or_click . '&txt_search=' . $txt_search;
echo '</td>
</tr>
</table>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -