

<?
class Manager{

static private $instance;
  private $bd;
	public function Manager(){
    require_once('sql.class.php');
    $this->bd = sql::singleton();
  }
  /*
	static public function singleton()
    {
        if (!isset(self::$instance)) {
            $c = __CLASS__;
            self::$instance = new $c;
        }

        return self::$instance;
    }
    */
  public function getChamadas(){
    $dataa=date('Y-m-d H:i:s');
    $id=$_GET['ID'];
    $colunas=$_GET['colunas'];
    $tb=$_GET['tb'];
  /* */
  if($_GET['colunas']){
  if($_GET['ID']==''){$query = "SELECT SQL_CACHE * FROM noticias WHERE colunas='$colunas' AND ativacao!='emoculto' ORDER BY data DESC LIMIT 100";}else{$query = "SELECT SQL_CACHE * FROM noticias WHERE colunas='$colunas' AND ativacao!='emoculto' AND id='$id' ORDER BY data DESC LIMIT 100";}}else{
    if($_GET['ID']==''){$query = "SELECT SQL_CACHE * FROM noticias WHERE ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100";}else{$query = "SELECT SQL_CACHE * FROM noticias WHERE ativacao!='emoculto' AND data<='$dataa' AND id='$id' ORDER BY data DESC LIMIT 100";} }
    //'WHERE ddaata <= \''.date('Y-m-d ')." AND colunas = 'cidade' ORDER BY data DESC LIMIT 5";
    $retorno = $this->geraArrayQuery($query);
    return $retorno;
  }

public function outrasNot(){
    $dataa=date('Y-m-d H:i:s');

    $query = "SELECT SQL_CACHE * FROM noticias WHERE ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100";
     $retorno = $this->geraArrayQuery($query);
     return $retorno;
  }


  public function maisNoticiaCanal($canal){
    $dataa=date('Y-m-d H:i:s');
    $id=$_GET['ID'];
    $tb=$_GET['tb'];
    if($_GET['colunas']){$colunas=$_GET['colunas'];
    $query = "SELECT SQL_CACHE * FROM noticias WHERE colunas='$colunas' AND ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100"; }else{
     $query = "SELECT SQL_CACHE * FROM noticias WHERE colunas='$canal' AND ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100"; }
     $retorno = $this->geraArrayQuery($query);
     return $retorno;
  }


    public function chamadas($canal){
    $dataa=date('Y-m-d H:i:s');
    $query = "SELECT SQL_CACHE * FROM noticias WHERE colunas='$canal' AND ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100";
     $retorno = $this->geraArrayQuery($query);
     return $retorno; 
  }

    public function cotacoes(){
    $dataa=date('Y-m-d H:i:s');
    $query = "SELECT SQL_CACHE * FROM noticias WHERE colunas='cotacoes' && data<=('$dataa') ORDER BY data DESC LIMIT 0,1";
     $retorno = $this->geraArrayQuery($query);
     return $retorno;
  }

  /*BANNERS CANAIS*/
    public function getBannercanais1($colunas,$limit = 10, $order = 'RAND()')
  {
    $dataa=date('Y-m-d H:i:s');
    $id=$_GET['ID'];
    $colunas=$_GET['colunas'];
    $tb=$_GET['tb'];
    $qry = "SELECT SQL_CACHE * FROM noticias WHERE data <= '$dataa' AND ativacao!='emoculto' AND ativacao2='banner' AND colunas='$colunas' AND ativacao='$colunas' ORDER BY $order  LIMIT $limit";
    $retorno = $this->geraArrayQuery($qry);
    return $retorno;
  }

    public function getBannercanais2($colunas,$limit = 10, $order = 'RAND()')
  {
    $dataa=date('Y-m-d H:i:s');
    $id=$_GET['ID'];
    $colunas=$_GET['colunas'];
    $tb=$_GET['tb'];
    $qry = "SELECT SQL_CACHE * FROM noticias WHERE data <= '$dataa' AND ativacao!='emoculto' AND ativacao='lado_direito_paginas_internas' AND ativacao2='banner' ORDER BY $order  LIMIT $limit";
    $retorno = $this->geraArrayQuery($qry);
    return $retorno;
  }

/*BANNERS PÁGINAS*/
    public function getBannerpags1($colunas,$limit = 10, $order = 'RAND()')
  {
    $dataa=date('Y-m-d H:i:s');
    $id=$_GET['ID'];
    $colunas=$_GET['colunas'];
    $tb=$_GET['tb'];
    $qry = "SELECT SQL_CACHE * FROM noticias WHERE data <= '$dataa' AND ativacao!='emoculto' AND ativacao='lado_direito_paginas_internas' ORDER BY $order  LIMIT $limit";
    $retorno = $this->geraArrayQuery($qry);
    return $retorno;
  }

   /*
    public function ativacao($canal){
    $dataa=date('Y-m-d H:i:s');
    $query = "SELECT SQL_CACHE * FROM noticias WHERE ativacao='$canal' AND ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100";
     $retorno = $this->geraArrayQuery($query);
     return $retorno;
  }

    public function ativacao2($canal){
    $dataa=date('Y-m-d H:i:s');
    $query = "SELECT SQL_CACHE * FROM noticias WHERE ativacao2='$canal' AND ativacao!='emoculto' AND data<='$dataa' ORDER BY data DESC LIMIT 100";
     $retorno = $this->geraArrayQuery($query);
     return $retorno;
  }
     */

  private function geraArrayQuery($query){

    $result = $this->bd->query($query) ;
    $retorno = array();
    while ($obj = $result->fetch_object()){
      array_push($retorno,$obj);
    }
    $result->free_result();
    $result->close();
    return $retorno;
  }
  function __destroy(){
    $this->bd->close();
  }
}
?>