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

function latest_bysite(){
  global $ar,$db;
  $dt=array();


  $sql="SELECT a.site_id,b.title,b.icon_url,count(*) as jum from gnews_item a JOIN gnews b ON a.site_id=b.id where a.st>0 and a.st_body=2 and a.title!='' and char_length(a.img)>40 group by site_id order by b.title";
  //$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['site_id']]=$r;   
      $sq3="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 from gnews_item a JOIN gnews_body b ON a.id=b.id where a.st>0 and a.st_body=2 and a.img!='' and a.title!='' and a.site_id=".$r['site_id']." order by publish_at desc limit 12";
      $rs3=mysqli_query($db,$sq3);
      $c=0;
      while($r3=mysqli_fetch_assoc($rs3)) {
        $dt['data'][$r['site_id']]['items'][$c]['id']=$r3['id'];
        $dt['data'][$r['site_id']]['items'][$c]['site']=$r['title'];
        $dt['data'][$r['site_id']]['items'][$c]['title']=ugpc($r3['title']);
        $dt['data'][$r['site_id']]['items'][$c]['url']=$r3['url'];
        $dt['data'][$r['site_id']]['items'][$c]['img']=$r3['img'];
        $dt['data'][$r['site_id']]['items'][$c]['summary']=ugpc($r3['summary']);
        $dt['data'][$r['site_id']]['items'][$c]['tag']=ugpc($r3['tag']);
        $dt['data'][$r['site_id']]['items'][$c]['site_url']=$r3['site_url'];
        $dt['data'][$r['site_id']]['items'][$c]['subdomain']=$r3['subdomain'];
        $dt['data'][$r['site_id']]['items'][$c]['publish_at']=$r3['publish_at'];
        $dt['data'][$r['site_id']]['items'][$c]['publish_date']=$r3['publish_date'];
        $dt['data'][$r['site_id']]['items'][$c]['site_id']=$r3['site_id'];
        $dt['data'][$r['site_id']]['items'][$c]['section_id']=$r3['section_id'];
        $dt['data'][$r['site_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']=$r['title'];           
        $dt['byid'][$d]['site_icon']=$r['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();
}
?>