= '".$year."-".$month."-1' AND new_date<='".$year_end."-".$month_end."-1')";
}
else
{
$course_qr.="(SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
}
//echo $course_qr;
$course_stat=mysqli_query($conn,$course_qr);
while($course_row=mysqli_fetch_array($course_stat, MYSQLI_ASSOC))
{
$previewed+=$course_row['view'];
$clicks+=$course_row['click'];
$inquiries+=$course_row['inquiries'];
$direct_view+=$course_row['direct_view'];
$show_previewed+=$course_row['view'];
$show_clicks+=$course_row['click'];
$show_inquiries+=$course_row['inquiries'];
$show_direct_view+=$course_row['direct_view'];
}
?>
Courses
= '".$year."-".$month."-1' AND new_date<='".$year_end."-".$month_end."-1')";
}
else
{
$article_qr.="(SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
}
$article_stat=mysqli_query($conn,$article_qr);
while($article_row=mysqli_fetch_array($article_stat, MYSQLI_ASSOC))
{
$previewed+=$article_row['view'];
$clicks+=$article_row['click'];
$inquiries+=$article_row['inquiries'];
$direct_view+=$article_row['direct_view'];
$show_previewed+=$article_row['view'];
$show_clicks+=$article_row['click'];
$show_inquiries+=$article_row['inquiries'];
$show_direct_view+=$article_row['direct_view'];
}
?>
Articles
0)
{
while($row_exec=mysqli_fetch_array($all_product, MYSQLI_ASSOC))
{
$concat.=($concat=="")?$row_exec['id']:",".$row_exec['id'];
}
$combine=" ad_id in (".$concat.") AND ";
}
else
{
$combine="ad_id='-1' AND ";
}
if($have_grade==8)
{
}
else
{
//echo $allprod;
//echo "SELECT sum(view) as 'views', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM product_month_clicks WHERE ".$combine." month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
$product_qr="SELECT sum(view) as 'views', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM product_month_clicks WHERE ".$combine." month_id IN";
if($year_end!="")
{
$product_qr.="(SELECT id FROM advert_stat_month where new_date>='".$year."-".$month."-1' AND new_date<='".$year_end."-".$month_end."-1')";
}
else
{
$product_qr.="(SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
}
$product_stat=mysqli_query($conn,$product_qr);
while($producte_row=mysqli_fetch_array($product_stat, MYSQLI_ASSOC))
{
$previewed+=$producte_row['views'];
$clicks+=$producte_row['click'];
$inquiries+=$producte_row['inquiries'];
$direct_view+=$producte_row['direct_view'];
$show_previewed+=$producte_row['views'];
$show_clicks+=$producte_row['click'];
$show_inquiries+=$producte_row['inquiries'];
$show_direct_view+=$producte_row['direct_view'];
}
?>
Products
0)
{
while($row_exec=mysqli_fetch_array($all_product, MYSQLI_ASSOC))
{
$concat.=($concat=="")?$row_exec['id']:",".$row_exec['id'];
}
$combine=" ad_id in (".$concat.") AND ";
}
else
{
$combine="ad_id='-1' AND ";
}
$resource_qr="SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM resource_month_clicks WHERE ".$combine." month_id IN";
if($year_end!="")
{
$resource_qr.="(SELECT id FROM advert_stat_month where new_date>='".$year."-".$month."-1' AND new_date<='".$year_end."-".$month_end."-1')";
}
else
{
$resource_qr.="(SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
}
$resource_stat=mysqli_query($conn,$resource_qr);
while($resource_row=mysqli_fetch_array($resource_stat, MYSQLI_ASSOC))
{
$previewed+=$resource_row['view'];
$clicks+=$resource_row['click'];
$inquiries+=$resource_row['inquiries'];
$direct_view+=$resource_row['direct_view'];
$show_previewed+=$resource_row['view'];
$show_clicks+=$resource_row['click'];
$show_inquiries+=$resource_row['inquiries'];
$show_direct_view+=$resource_row['direct_view'];
}
?>
Alternative Medicine, Resource & Complementary Health Directory
