| 日期 |
搜索联盟 |
助手联盟 |
广告联盟收入 |
class == 1){?>
文字联盟收入 |
当日收入合计 |
| 搜索流量（次数） |
搜索联盟收入（￥4.00/千次搜索） |
助手广告独立IP数（个） |
助手联盟收入（￥25.00/千 IP） |
"","income"=>"","payment"=>"",
"sms_income"=>"","ass_income"=>"","total_income"=>"",
"tax_payment"=>"","post_payment"=>"","total_payment"=>"") ;
}
for($i=1;$i<=$monthDays;$i++) {
$dataSetIncomeS[$i] = "";
$dataSetIncomeADS[$i] = "";
$dataSetIncomeass[$i] = "";
$dataSetPageviewass[$i] = "";
$dataSetPageviewS[$i] = "";
}
$totalPageviewS = 0 ;
$totalIncomeS = 0.00 ;
//获得搜索流量
$sql = "SELECT sum(A.pageview) as PAGEVIEW,DAYOFMONTH(A.pdate) as CURDAY FROM
PAGEVIEW_TABLE A,SMS_AGENT_TABLE B,AGENT_IDENTIFY_TABLE C
WHERE B.ID=C.USERID AND C.IDENTIFYSTRING=A.idstring AND C.USERID=$userid AND
A.pdate>='$timeStart' AND A.pdate<'$timeEnd' GROUP BY DAYOFMONTH(A.pdate)";
$session->db->query($sql);
while($session->db->next_record()) {
$day = $session->db->Record["CURDAY"];
$dataSetPageviewS[$day] = $session->db->Record["PAGEVIEW"] ;
if( $a_percent[$day]==0 ) {
$dataSetIncomeS[$day] = round(100*($session->db->Record["PAGEVIEW"] * $percent))/100 ;
}
else {
$dataSetIncomeS[$day] = round(100*($session->db->Record["PAGEVIEW"] * $a_percent[$day]))/100 ;
}
$totalPageviewS = $totalPageviewS + $session->db->Record["PAGEVIEW"] ;
$totalIncomeS = $totalIncomeS + $dataSetIncomeS[$day] ;
}
//获得助手流量
$sql = "SELECT sum(A.ass_ip) as ASS_IP,DAYOFMONTH(A.pdate) as CURDAY FROM
ASS_IP_TABLE A,SMS_AGENT_TABLE B,AGENT_IDENTIFY_TABLE C
WHERE B.ID=C.USERID AND C.IDENTIFYSTRING=A.idstring AND C.USERID=$userid AND C.type=2 AND
A.pdate>='$timeStart' AND A.pdate<'$timeEnd' GROUP BY DAYOFMONTH(A.pdate)";
$session->db->query($sql);
for($i=1;$i<=$monthDays;$i++) {
$dataSetPageviewass[$i] = "";
}
$totalPageviewass = 0 ;
$totalIncomeass = 0.00 ;
while($session->db->next_record()) {
$assday = $session->db->Record["CURDAY"];
$dataSetPageviewass[$assday] = $session->db->Record["ASS_IP"] ;
if ($year==2004 && (($month==10 && $assday >= 22) || ($month==11 && $assday<=5)))
{
$dataSetIncomeass[$assday] = round(100*($session->db->Record["ASS_IP"]) * 40 / 1000)/100 ;
}
elseif($year==2004 && (($month==11 && $assday >= 6) && ($month==11 && $assday<=15)))
{
echo $assday ;
$dataSetIncomeass[$assday] = round(100*($session->db->Record["ASS_IP"]) * 60 / 1000)/100 ;
}
else
{
$dataSetIncomeass[$assday] = round(100*($session->db->Record["ASS_IP"]) * $ass_percent)/100 ;
}
$totalPageviewass = $totalPageviewass + $session->db->Record["ASS_IP"] ;
$totalIncomeass = $totalIncomeass + $dataSetIncomeass[$assday] ;
}
//获得广告流量
$sql = "SELECT sum(ads_ip * ads_percent /100) as total ,DAYOFMONTH(pdate) as CURDAY
from ADS_IP_TABLE
WHERE sid=$userid AND
pdate>='$timeStart' AND pdate<'$timeEnd' GROUP BY DAYOFMONTH(pdate)";
$session->db->query($sql);
for($i=1;$i<=$monthDays;$i++) {
$dataSetIncomeADS[$i] = "";
}
$totalIncomeADS = 0.00 ;
while($session->db->next_record()) {
$adsday = $session->db->Record["CURDAY"];
$dataSetIncomeADS[$adsday] = round(100*($session->db->Record["total"]))/100 ;
$totalIncomeADS = $totalIncomeADS + $dataSetIncomeADS[$adsday] ;
}
//获得文字流量
$sql = "SELECT sum(click_ip * ads_percent /100) as total ,DAYOFMONTH(pdate) as CURDAY
from TXT_IP_TABLE
WHERE sid=$userid AND
pdate>='$timeStart' AND pdate<'$timeEnd' GROUP BY DAYOFMONTH(pdate)";
$session->db->query($sql);
for($i=1;$i<=$monthDays;$i++) {
$dataSetIncomeTXT[$i] = "";
}
$totalIncomeTXT = 0.00 ;
while($session->db->next_record()) {
$adsday = $session->db->Record["CURDAY"];
$dataSetIncomeTXT[$adsday] = round(100*($session->db->Record["total"]))/100 ;
$totalIncomeTXT = $totalIncomeTXT + $dataSetIncomeTXT[$adsday] ;
}
for($k=0; $k<31 ; $k++) {
//echo $dataSetIncomeS[($k+1)];
if( checkdate( $month,($k+1),$year) )
{
$ads_link = "" ;
$txt_link = "" ;
if( $dataSetIncomeADS[($k+1)] > 0)
{
$d = $k + 1 ;
$ads_link = "(明细)" ;
}
if( $dataSetIncomeTXT[($k+1)] > 0)
{
$d = $k + 1 ;
$txt_link = "(明细)" ;
}
?>
|
|
|
|
|
|
class == 1){?>
|
|
|
|
|
|
|
|
class == 1){?>
|
|
|