$vbnum=$id_vbn;
$qs="select * from vbn where id_vbn=$id_vbn";
# echo "$qs \n";
$vd=mysql_query($qs);
$vbnlist=mysql_fetch_array($vd);
$vbn=$id_vbn;
?>
|
$qs="SELECT
show_count,stat_date,click_count FROM vbn_stat WHERE id_vbn=$vbn and TO_DAYS(stat_date)>=(TO_DAYS(CURDATE())-1) group by stat_date order by stat_date DESC";
$res=mysql_query($qs);
#echo "$qs ";
$row=mysql_fetch_array($res);
$ctr=($row[0]>0)?($row[2]*100/$row[0]):0;
$sctr=number_format($ctr,2);
echo "показано сегодня / ctr | .......... | $row[0] / $sctr | ";
$row=mysql_fetch_array($res);
$ctr=($row[0]>0)?($row[2]*100/$row[0]):0;
$sctr=number_format($ctr,2);
echo "показано вчера / ctr | .......... | $row[0] / $sctr | ";
?>
|
Статистика по аккаунтам за вчера: |
$qs="SELECT a.id_account,
a.account_name,
a.url,
b.show_on_acc as summ_show
FROM account as a,
acc_stat as b
WHERE a.id_account=b.id_account AND
a.id_vbn=b.id_vbn AND
a.acc_type='1' AND
b.id_vbn=$vbn AND
TO_DAYS(b.stat_date)=(TO_DAYS(CURDATE())-1) AND
a.id_account!=0 AND
a.acc_check!='0' AND
b.show_on_acc>0
GROUP BY b.id_account
ORDER BY summ_show DESC";
#echo "$qs ";
$res=mysql_query($qs);
while ($row=mysql_fetch_array($res))
{
echo "
| \n";
echo " $row[1] | .......... | $row[3] | ";
}
?>
|
|