Chibi86 / DB-TextContent-for-Anax-MVC

   * @param  boolean    $publish    Check if it needs to be publish

   * @return int   						      With count

   */

  public function countAllContentOfTag($tag, $type, $publish = true){

    $now    = date('Y-m-d H:i:s');

    $params = [$tag, $type];

    $this->db->select("COUNT(c.id) AS countAll")

             ->from("content AS c")

             ->join("content_tags AS t", "t.idContent = c.id")

             ->where("t.slug = ?")

             ->andWhere("c.`type` = ?")

             ->andWhere("c.`deleted` IS NULL");

    if($publish){

      $this->db->andWhere("c.published <= ?");

      $params[] = $now;

    }

    $this->db->execute($params);

    $this->db->setFetchModeClass(__CLASS__);

    $count = $this->db->fetchOne();

    return $count->countAll;		

  }

  /*****

   ***

   * @param  	string  	$type			Wich type of content ex. blog, page etc.

   * @return 	object   						With content data from database

   */

  public function getContentByUrl($url, $type, $publish = true){

    $now    = date('Y-m-d H:i:s');

    $params = [$url, $type];

    $this->db->select("c.*")

             ->from("content AS c")

    //       ->join("user AS u", "c.author = u.id")

             ->where("c.url = ?")

             ->andWhere("c.`type` = ?")

             ->andWhere("c.`deleted` IS NULL");

    if($publish){

      $this->db->andWhere("c.published <= ?");

      $params[] = $now;

    }

    $this->db->orderBy('c.published DESC, c.created DESC')

             ->limit(1)

             ->execute($params);

    $this->db->setFetchModeClass(__CLASS__);

    return $this->db->fetchOne();

  }

  /**

   * Get content from database by slug

   * @param  	string  $type			Wich type of content ex. blog, page etc.

   * @return 	object   					With content data from database

   */

  public function getContentBySlug($slug, $type, $publish = true){

    $now = date('Y-m-d H:i:s');

    $params = array($slug, $type);

    $this->db->select("c.*")

             ->from("content AS c")

    //       ->join("user AS u", "c.author = u.id")

             ->where("c.slug = ?")

             ->andWhere("c.`type` = ?")

             ->andWhere("c.`deleted` IS NULL");

    if($publish){

      $this->db->andWhere("c.published <= ?");

      $params[] = $now;

    }

    $this->db->orderBy('c.published DESC, c.created DESC')

             ->limit(1)

             ->execute($params);

    $this->db->setFetchModeClass(__CLASS__);

    return $this->db->fetchOne();

  }

  /**

   * Get content from database by index