<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: searcher_authorities_tab.class.php,v 1.6.6.2 2021/04/06 10:14:51 tsamson Exp $

if (stristr($_SERVER['REQUEST_URI'], ".class.php")) die("no access");

require_once($class_path.'/searcher/searcher_autorities.class.php');

class searcher_authorities_tab extends searcher_autorities {
    
    /**
     * Tableau des instances de searcher_authorities
     * @var searcher_autorities
     */
    protected $searcher_authorities_instances;
    
    public function __construct($user_query) {
        parent::__construct($user_query);
        $this->search_noise_limit_type = false;
    }
    
    public function _get_search_type(){
        return parent::_get_search_type()."_tab";
    }
    
    protected function _analyse() {
        $this->_get_searcher_authorities_instances();
        $this->_set_global_filters();
    }
    
    protected function _get_search_query() {
        if (count($this->searcher_authorities_instances) == 1) {
            return $this->searcher_authorities_instances[0]->get_raw_query();
        } else {
            $query = '';
            if(count($this->searcher_authorities_instances)) {
                foreach ($this->searcher_authorities_instances as $searcher_authority) {
                    $created_table = 'search_result'.md5(microtime(true));
                    $rqt = 'create temporary table '.$created_table.' '.$searcher_authority->get_raw_query();
                    $res = pmb_mysql_query($rqt);
                    pmb_mysql_query('alter table '.$created_table.' add index i_id('.$this->object_key.')');
                    if (!$query) {
                        $reference = $created_table;
                        $query = 'select '.$reference.'.'.$this->object_key.' from '.$reference;
                    } else {
                        $query.= ' join '.$created_table.' on '.$reference.'.'.$this->object_key.' = '.$created_table.'.'.$this->object_key;
                    }
                }
                $query.= ' group by '.$reference.'.'.$this->object_key;
                return $query;
            }
        }
        return '';
    }
    
    protected function _get_pert($query=false){
        
        if (count($this->searcher_authorities_instances) == 1) {
            $pert_result = $this->searcher_authorities_instances[0]->get_pert_result($query);
            if ($query) {
                return $pert_result;
            }
            $this->table_tempo = $pert_result;
        } else {
            $pert = '';
            foreach ($this->searcher_authorities_instances as $searcher_authority) {
                $searcher_table_tempo = $searcher_authority->get_pert_result();
                if (!$pert) {
                    $reference = $searcher_table_tempo;
                    $pert = 'select '.$reference.'.'.$this->object_key.', sum('.$reference.'.pert) as pert from '.$reference;
                } else {
                    $join_table = $searcher_table_tempo;
                    $pert.= ' join '.$join_table.' on '.$reference.'.'.$this->object_key.' = '.$join_table.'.'.$this->object_key;
                }
            }
            $pert.= ' group by '.$reference.'.'.$this->object_key;
            if ($query) {
                return $pert;
            }
            $this->table_tempo = 'search_result'.md5(microtime(true));
            $rqt = 'create temporary table '.$this->table_tempo.' '.$pert;
            $res = pmb_mysql_query($rqt);
            pmb_mysql_query('alter table '.$this->table_tempo.' add index i_id('.$this->object_key.')');
        }
    }
    
    protected function _get_user_query(){
        return serialize($this->user_query);
    }
    
    /**
     * Initialise le tableau d'instances de searcher_authorities
     * @return searcher_autorities
     */
    protected function _get_searcher_authorities_instances() {
        if (!$this->searcher_authorities_instances) {
            $this->searcher_authorities_instances = array();
            foreach ($this->user_query['SEARCHFIELDS'] as $searchfield) {
                $instance=null;
                if (isset($searchfield['values'][0]) && $searchfield['values'][0] && $searchfield['type']) {
                    $instance = searcher_factory::get_searcher( $searchfield['type'], $searchfield['mode'],stripslashes($searchfield['values'][0]));
                } else if (isset($searchfield['values'][0]) && $searchfield['values'][0] && $searchfield['class']) {
                    $instance = new $searchfield['class'](stripslashes($searchfield['values'][0]));
                }
                if(is_object($instance)){
                    if (isset($searchfield['fieldrestrict']) && is_array($searchfield['fieldrestrict'])) {
                        $instance->add_fields_restrict($searchfield['fieldrestrict']);
                    }
                    if (!empty($searchfield['details'])) {
                        $instance->set_details($searchfield['details']);
                    }
                    $this->searcher_authorities_instances[] = $instance;
                }
            }
        }
        return $this->searcher_authorities_instances;
    }
    
    /**
     * Valorise les globales nécessaires aux searcher_authorities pour les filtres
     */
    protected function _set_global_filters() {
        if(isset($this->user_query['FILTERFIELDS'])) {
            foreach ($this->user_query['FILTERFIELDS'] as $filterfield) {
                if (isset($filterfield['values'][0]) && $filterfield['values'][0] && $filterfield['globalvar']) {
                    global ${$filterfield['globalvar']};
                    ${$filterfield['globalvar']} = $filterfield['values'][0];
                }
            }
        }
    }
    
    public function get_authority_tri() {
        if (count($this->searcher_authorities_instances) == 1) {
    	    if (!$this->searcher_authorities_instances[0]->get_authority_type()) {
    	        return "";
    	    }
            $this->authority_type = $this->searcher_authorities_instances[0]->get_authority_type();
            $this->object_key = $this->searcher_authorities_instances[0]->get_object_key();
            $this->object_table = $this->searcher_authorities_instances[0]->get_object_table();
            $this->object_table_key = $this->searcher_authorities_instances[0]->get_object_table_key();
            return $this->searcher_authorities_instances[0]->get_authority_tri();
        }
        return '';
    }
    
    protected function _filter_results(){
        global $equation;
        if($equation) {
            $my_search = new search_authorities('search_fields_authorities_gestion');
            $my_search->unserialize_search(stripslashes($equation));
            $res = $my_search->make_search();
            $req="select ".$this->object_key." from ".$res." WHERE ".$this->object_key." in (".$this->objects_ids.")";
            $resultat=pmb_mysql_query($req);
            $this->objects_ids ="";
            while($row=pmb_mysql_fetch_assoc($resultat)) {
                if($this->objects_ids) {
                    $this->objects_ids.= ",";
                }
                $this->objects_ids.= $row[$this->object_key];
            }
            $this->filtered_result = true;
        }
    }
}
?>