Chibi86 / DB-TextContent-for-Anax-MVC

   * @param  	boolean 	$publish 	  If it needs to be publish

   * @return 	int   					      With count of content in database

   */

  public function countAllContent($publish = true){

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

    $params = [];

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

             ->from("Content")

             ->where("`deleted` IS NULL");

    if($publish){

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

      $params[] = $now;

    }

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

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

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

    return $count->countAll;

  }

  /**

   * Count all content of one type from database

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

   * @return 	int   			    		  With count of content in database

   */

  public function countAllContentOfType($type, $publish = true){

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

    $params = [$type];

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

             ->from("Content")

             ->where("`type` = ?")

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

    if($publish){

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

      $params[] = $now;

    }

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

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

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

    return $count->countAll;

  }

  /**

   * Count all content of one tag and one type from database