<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: searcher_records_all_fields.class.php,v 1.13.2.1.2.2 2026/03/31 07:51:38 dgoron Exp $
if (stristr($_SERVER['REQUEST_URI'], ".class.php"))
    die("no access");

global $class_path;

require_once "$class_path/searcher/searcher_records.class.php";

class searcher_records_all_fields extends searcher_records
{

    protected $aq_wew;

    protected $all_keep_empty_words = false;

    protected $with_docnums = false;

    protected $members_explnum_noti = [];
    protected $members_explnum_bull = [];

    public function __construct($user_query)
    {
        global $pmb_search_all_keep_empty_words;

        parent::__construct($user_query);
        $this->field_restrict[] = array(
            'field' => "code_champ",
            'values' => array(
                18,
                19,
                20,
                21,
                23,
                24,
                25,
                26
            ),
            'op' => "or",
            'not' => false
        );
        if ($pmb_search_all_keep_empty_words) {
            $this->aq_wew = new analyse_query($this->user_query, 0, 0, 1, 1);
        }
    }

    protected function _get_search_type()
    {
        return parent::_get_search_type() . "_all_fields";
    }

    protected function _get_all_fields_search_query()
    {
        $query = "";
        $queries = array();
        $this->_calc_query_env();

        if ($this->user_query !== "*") {
            if ($this->aq_wew && count($this->aq->tree) !== count($this->aq_wew->tree)) {
                // debug::activeExplain();
                $queries[] = $this->aq->get_query_mot("id_notice", "notices_mots_global_index", "word", "notices_fields_global_index", "value", $this->field_restrict, true, true);
                $queries[] = $this->aq_wew->get_query_mot("id_notice", "notices_mots_global_index", "word", "notices_fields_global_index", "value", $this->field_restrict, false, true);
                // debug::disableExplain();
                $query = "select distinct id_notice from ((" . implode(") union (", $queries) . ")) as uni";
            } else {
                $query = $this->aq->get_query_mot("id_notice", "notices_mots_global_index", "word", "notices_fields_global_index", "value", array(), true, true);
            }
        } else {
            $query = "select distinct notice_id as id_notice from notices";
        }
        $query_filters = $this->_get_query_filters();
        if ($query_filters != "") {
            $query = "select distinct id_notice from ($query) as q1" . $query_filters;
        }
        return $query;
    }

    protected function _get_search_query()
    {
        global $docnum_query, $multi_crit_indexation_docnum_allfields;

        // Valeurs possibles pour mutli_crit_indexation_docnum_allfields : -1 et 1
        if ($docnum_query || ($multi_crit_indexation_docnum_allfields == 1)) {
            $this->with_docnums = true;
        }

        $query = $this->_get_all_fields_search_query();
        if ($this->user_query !== "*" && $this->with_docnums) {
            $this->_get_explnum_members();
            $query_explnum_noti = "select distinct explnum_notice as id_notice from explnum " . $this->_get_explnum_filter("notice", "explnum_notice") . " " . $this->_get_explnum_where() . " and explnum_notice !=0 and explnum_bulletin=0 "; // .$this->_get_explnum_end("notice");
            $query_explnum_bull = "select distinct num_notice as id_notice from explnum join bulletins on num_notice!= 0 and explnum_bulletin = bulletin_id " . $this->_get_explnum_filter("bulletin", "num_notice") . " " . $this->_get_explnum_where() . " and explnum_bulletin !=0 and explnum_notice=0 "; // .$this->_get_explnum_end();
            $query_filters = $this->_get_query_filters();
            if ($query_filters != "") {
                $query_explnum_noti = "select distinct id_notice from ($query_explnum_noti) as q2 " . $query_filters;
                $query_explnum_bull = "select distinct id_notice from ($query_explnum_bull) as q3 " . $query_filters;
            }
            $query = "select distinct id_notice from (($query) union ($query_explnum_noti) union ($query_explnum_bull))as uni ";
        }
        return $query;
    }

    /**
     *
     * {@inheritdoc}
     * @see searcher_records::_get_pert()
     */
    protected function _get_pert($query = false, $with_explnum = false)
    {
        global $docnum_query, $multi_crit_indexation_docnum_allfields;

        // Valeurs possibles pour mutli_crit_indexation_docnum_allfields : -1 et 1
        if ($docnum_query || ($multi_crit_indexation_docnum_allfields == 1)) {
            $this->with_docnums = true;
        }
        if ($this->with_docnums) {
            $with_explnum = true;
        }
        if ($this->user_query === "*") {
            $return_query = "select notice_id, 100 as pert from notices".$this->_get_query_filters(true);
            if ($query) {
                return $return_query;
            }
            $this->table_tempo = "gestion_result" . md5(microtime(true));
            pmb_mysql_query("create temporary table " . $this->table_tempo . " " . $return_query);
            pmb_mysql_query("alter table " . $this->table_tempo . " add index i_id(notice_id)");
            return $this->table_tempo;
        }

        if ($this->aq_wew && (count($this->aq->tree) != count($this->aq_wew->tree))) {
            $without_empty = $this->aq->get_pert($this->objects_ids, $this->field_restrict, true, $with_explnum, true, true);
            $with_empty = $this->aq_wew->get_pert($this->objects_ids, $this->field_restrict, false, $with_explnum, true, true);
            $return_query = "select notice_id, max(pert) as pert from (($without_empty) union all($with_empty))as q1 group by notice_id";
            if ($query) {
                return $return_query;
            } else {
                $this->table_tempo = "gestion_result" . md5(microtime(true));
                pmb_mysql_query("create temporary table " . $this->table_tempo . " " . $return_query);
                pmb_mysql_query("alter table " . $this->table_tempo . " add index i_id(notice_id)");
            }
        } else {
            if ($query) {
                return $this->aq->get_pert($this->objects_ids, array(), false, $with_explnum, true, true);
            }
            $this->table_tempo = $this->aq->get_pert($this->objects_ids, array(), false, $with_explnum, false, true);
        }
    }

    protected function _get_explnum_end($type)
    {
        if ($type == "notice") {
            return $this->members_explnum_noti['post'];
        }
        return $this->members_explnum_bull['post'];
    }

    protected function _get_explnum_members()
    {
        $this->members_explnum_noti = $this->aq->get_query_members("explnum", "explnum_index_wew", "explnum_index_sew", "explnum_notice", "", 0, 0, true);
        $this->members_explnum_bull = $this->aq->get_query_members("explnum", "explnum_index_wew", "explnum_index_sew", "id_notice", "", 0, 0, true);
    }

    protected function _get_explnum_where()
    {
        $where = "WHERE ((" . $this->members_explnum_noti['where'] . ")) ";
        // if($this->view_restrict) $where.=" and ".$this->view_restrict;
        return $where;
    }

    protected function _get_explnum_pert()
    {
        return $this->members_explnum_noti['select'] . " AS pert";
    }

    protected function _get_explnum_filter($type = "notice", $field = "")
    {
        global $gestion_acces_active, $gestion_acces_user_notice, $PMBuserid;

        $join = '';
        if ($gestion_acces_active == 1 && $gestion_acces_user_notice == 1) {
            $ac = new acces();
            $dom_1 = $ac->setDomain(1);
            $join = $dom_1->getJoin($PMBuserid, 4, $field);
        }
        return $join;
    }
}