<?php
$dt=latest_bywho();
echo json_encode($dt);

function latest_bywho(){
  global $ar,$db;
  $dt=array();
  $now=time();
  $last_day=$now-(2*86400);
  $last_week=$now-(7*86400);


  $sql="SELECT id,name,slug,img from `who` order by name";
  //$dt['sql'][1]=$sql;
  $res=mysqli_query($db,$sql);
  if(mysqli_num_rows($res)>0){
    $dt['success']=true;
    $dt['get_at']=date("Y-m-d H:i:s");
    //$dt['count']=mysqli_num_rows($res); 
    $d=0;
    while($r=mysqli_fetch_assoc($res)) {
      $dt['data'][$r['id']]=$r;   
      $dt['data'][$r['id']]['img']=$ar['imgurl']."".$r['img'];   
      $dt['data'][$r['id']]['icon_url']=$ar['imgurl']."".$r['img'];   
      $dt['data'][$r['id']]['title']=$r['name'];   

      $sq="SELECT a.id,a.title,a.url,a.img,a.summary,a.tag,a.site_url,a.subdomain,a.publish_at,a.publish_date,a.site_id,a.section_id,b.bodytext,c.title as site,c.icon_url from gnews_item a JOIN gnews_body b ON a.id=b.id JOIN gnews c ON a.site_id=c.id where a.st>0 and a.st_body=2 and a.img!='' and a.title like '%".$r['slug']."%' ";
      $sq2=$sq;
      $res2=mysqli_query($db,$sq2);
      $dt['data'][$r['id']]['count']=ang(mysqli_num_rows($res2));  

      $sq4=$sq." and publish_at>".$last_day;
      $res4=mysqli_query($db,$sq4);
      $dt['data'][$r['id']]['last_count']=ang(mysqli_num_rows($res4));   

      $sq5=$sq." and publish_at>".$last_week;
      $res5=mysqli_query($db,$sq5);

      $udt=array(
        'daily_count'=>mysqli_num_rows($res4),
        'weekly_count'=>mysqli_num_rows($res5),
        'update_at'=>time(),
      );
      Update($db,"who",$udt,"id=".$r['id'],0);


      $sq3=$sq." order by publish_at desc limit 12";
      $rs3=mysqli_query($db,$sq3);
      $c=0;
      while($r3=mysqli_fetch_assoc($rs3)) {
        $dt['data'][$r['id']]['items'][$c]['id']=$r3['id'];
        $dt['data'][$r['id']]['items'][$c]['who']=$r['name'];
        $dt['data'][$r['id']]['items'][$c]['site']=$r3['site'];
        $dt['data'][$r['id']]['items'][$c]['icon_url']=$r3['icon_url'];
        $dt['data'][$r['id']]['items'][$c]['title']=ugpc($r3['title']);
        $dt['data'][$r['id']]['items'][$c]['url']=$r3['url'];
        $dt['data'][$r['id']]['items'][$c]['img']=$r3['img'];
        $dt['data'][$r['id']]['items'][$c]['summary']=ugpc($r3['summary']);
        $dt['data'][$r['id']]['items'][$c]['tag']=ugpc($r3['tag']);
        $dt['data'][$r['id']]['items'][$c]['site_url']=$r3['site_url'];
        $dt['data'][$r['id']]['items'][$c]['subdomain']=$r3['subdomain'];
        $dt['data'][$r['id']]['items'][$c]['publish_at']=$r3['publish_at'];
        $dt['data'][$r['id']]['items'][$c]['publish_date']=$r3['publish_date'];
        $dt['data'][$r['id']]['items'][$c]['site_id']=$r3['site_id'];
        $dt['data'][$r['id']]['items'][$c]['section_id']=$r3['section_id'];
        $dt['data'][$r['id']]['items'][$c]['section']=$ar['section_name'][$r3['section_id']];           
        $dt['byid'][$d]=$r3;
        $dt['byid'][$d]['bodytext']=ugpc($r3['bodytext']);
        //$dt['byid'][$d]['site']=$r3['site'];           
        //$dt['byid'][$d]['icon_url']=$r3['icon_url'];           
        $dt['byid'][$d]['section']=$ar['section_name'][$r3['section_id']];           
        $c++; $d++;
      }

    }
  } else {
    $dt['error']=true;
    $dt['message']="Data not found";        
  }
  return $dt;
  $db->close();
}
?>