<?php
class Sabre_PMB_Indexint extends Sabre_PMB_Collection {
	protected $indexint;

	function __construct($name,$config) {
		parent::__construct($config);
		$code = $this->get_code_from_name($name);
		$id = substr($code,1);
		if($id){
			$this->indexint = new indexint($id);
		}
		$this->type = "indexint";
	}
	
	function getChildren(){
		$children = parent::getChildren();
		$query = "select indexint_id from indexint where num_pclass = ".$this->indexint->id_pclass." and indexint_name like '".addslashes(trim($this->indexint->name,0))."%' and indexint_id != ".$this->indexint->indexint_id;
		$result = mysql_query($query);
		if(mysql_num_rows($result)){
			while($row = mysql_fetch_object($result)){
				$current_children[] = $this->getChild("(I".$row->indexint_id.")",$this->config);
			}			
		}
		usort($current_children);
		return array_merge($children,$current_children);
	}

	function getName() {
		return utf8_encode($this->indexint->name." - ".$this->indexint->comment.""." (I".$this->indexint->indexint_id.")");
	}
	
	function need_to_display($categ_id){
		return true;
	}
	
	function getNotices(){
		
		$this->notices = array();		
		if($this->indexint->indexint_id){
			$clause ="";
			//notice
			$query = "select notice_id from notices join explnum on explnum_bulletin = 0 and explnum_notice = notice_id where (indexint = ".$this->indexint->indexint_id." or indexint in(select indexint_id from indexint where num_pclass = ".$this->indexint->id_pclass." and indexint_name like '".addslashes(trim($this->indexint->name,0))."%' and indexint_id != ".$this->indexint->indexint_id.")) and explnum_mimetype != 'URL'";
			//notice de bulletin
			$query.= " union select notice_id from notices join bulletins on niveau_biblio = 'b' and notice_id = num_notice and num_notice != 0 join explnum on explnum_bulletin = bulletin_id and explnum_notice = 0 where (indexint = ".$this->indexint->indexint_id." or indexint in (select indexint_id from indexint where num_pclass = ".$this->indexint->id_pclass." and indexint_name like '".addslashes(trim($this->indexint->name,0))."%' and indexint_id != ".$this->indexint->indexint_id.")) and explnum_mimetype != 'URL'";
			
			$this->filterNotices($query);		
		}
		return $this->notices;
	}
	
	function update_notice_infos($notice_id){
		if($notice_id*1 >0){
			$query = "update notices set indexint = ".$this->indexint->indexint_id." where notice_id = ".$notice_id;
			mysql_query($query);
		}
	}
}