<?php
$dt=news($_GET);
echo json_encode($dt);

function news($js){
  global $ar,$db;
  $dt=array();
  if(isset($js['limit']) && $js['limit']>0) {
    $limit=$js['limit'];
  } else {
    $limit=10;
  }

  if(isset($js['page']) && $js['page']>1) {
    $page=$js['page'];
  } else {
    $page=1;
  }

  $dt['param']=$js;

  $sql2="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 char_length(a.img)>40 and a.title!='' ";

  if(isset($js['site']) && $js['site']>0) {
    $sql2 .= " and a.site_id=".$js['site']." ";
  } 

  if(isset($js['section']) && $js['section']>0) {
    $sql2 .= " and a.section_id=".$js['section']." ";
  } 

  if(isset($js['tag']) && $js['tag']!='' and strlen($js['tag'])>2) {
    $sql2 .= " and a.`tag` like '%".$js['tag']."%' ";
  } 

  if(isset($js['q']) && $js['q']!='' and strlen($js['q'])>2) {
    $sql2 .= " and b.`bodytext` like '%".$js['q']."%' ";
  } 

  $res2=mysqli_query($db,$sql2);

  $total_items = mysqli_num_rows($res2);

  $total_pages=ceil($total_items/$limit);
  $start=($page-1)*$limit;


  $sql=$sql2." order by a.publish_at desc limit ".$start.",".$limit;
  //$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['total_items']=$total_items; 
    $dt['total_pages']=$total_pages; 
    $c=0;    
    while($r3=mysqli_fetch_assoc($res)) {
      //$dt['data'][$a]=$r;
      $dt['data'][$c]['id']=$r3['id'];
      $dt['data'][$c]['title']=ugpc($r3['title']);
      $dt['data'][$c]['url']=$r3['url'];
      $dt['data'][$c]['img']=$r3['img'];
      $dt['data'][$c]['summary']=ugpc($r3['summary']);
      $dt['data'][$c]['tag']=ugpc($r3['tag']);
      $dt['data'][$c]['site_url']=$r3['site_url'];
      $dt['data'][$c]['subdomain']=$r3['subdomain'];
      $dt['data'][$c]['publish_at']=$r3['publish_at'];
      $dt['data'][$c]['publish_date']=$r3['publish_date'];
      $dt['data'][$c]['site']=$r3['site'];
      $dt['data'][$c]['icon_url']=$r3['icon_url'];
      $dt['data'][$c]['site_id']=$r3['site_id'];
      $dt['data'][$c]['section_id']=$r3['section_id'];
      $dt['data'][$c]['section']=$ar['section_name'][$r3['section_id']];           
      $dt['byid'][$c]=$r3;
      $dt['byid'][$c]['bodytext']=ugpc($r3['bodytext']);
      $dt['byid'][$c]['site']=$r3['site'];           
      $dt['byid'][$c]['icon_url']=$r3['icon_url'];           
      $dt['byid'][$c]['section']=$ar['section_name'][$r3['section_id']];           

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