Subversion Repositories Applications.papyrus

<?php
/*
 * Moteur de recherche SPHINX
 * @author        Raphaël Droz <raphael@tela-botanica.org
 * @copyright     Tela-Botanica 2013
 */

/*
  sudo urpmi lib64sphinxclient-devel
  sudo pecl install sphinx

  see also: http://www.ibm.com/developerworks/library/os-sphinx/
  see also: http://sphinxsearch.com/docs/manual-2.0.7.html#extended-syntax
  TODO: http://sphinxsearch.com/blog/2010/08/17/how-sphinx-relevance-ranking-works/
*/

/* returned struct:
'poids' => 0,
'url' => '',
'titre' => '',
'hreflang' => '',
'accesskey' => '',
'title' => '',
'date_creation' => '',
'description' => ''
*/

class MoteurRecherche_SPIP {
        public function get($ids) {
                $db = DB::connect($GLOBALS['_MOTEUR_RECHERCHE_']['spip'][0]['bdd_dsn']);
                $req = $db->query(sprintf('SELECT id_article AS id, titre, texte, date, lang as hreflang' .
                                                                  ' FROM spip_articles' .
                                                                  ' WHERE statut = "%s"' .
                                                                  ' AND id_article IN (%s)',

                                                                  "publie",
                                                                  implode(',', $ids)));
                $content = array();
                while($rec = $req->fetchRow(DB_FETCHMODE_ASSOC)) {
                        $rec['url_simple'] = sprintf("%s/article/%d.html",
                                                                                 trim($GLOBALS['_MOTEUR_RECHERCHE_']['spip'][0]['url'], '/'),
                                                                                 $rec['id']);
                        // TODO: passer traiterMotif() en static
                        // $rec['url'] = $rec['url_simple'] . traiterMotif()

                        // TODO: passer couperTexte() en static
                        $rec['description'] = substr(strip_tags($rec['texte']), 0, 400 + 2 * MORE_RESULTAT_TAILLE_DESCRIPTION);
                        unset($rec['texte']);
                        $content[$rec['id']] = $rec;

                }
                return $content;
        }
}

class MoteurRecherche_BAZAR {
        public function get($ids) {
                $db = DB::connect($GLOBALS['_MOTEUR_RECHERCHE_']['bazar'][0]['bdd_dsn']);
                $req = $db->query(sprintf('SELECT bf_id_fiche AS id, bf_description AS texte, bf_titre AS titre, bf_date_debut_evenement' .
                                                                  ' FROM bazar_fiche' .
                                                                  ' WHERE bf_id_fiche IN (%s)',

                                                                  implode(',', $ids)));
                $content = array();
                while($rec = $req->fetchRow(DB_FETCHMODE_ASSOC)) {
                        $rec['url_simple'] = $rec['url_simple'] =
                                sprintf(trim($GLOBALS['_MOTEUR_RECHERCHE_']['spip'][0]['url'], '/'),
                                                $rec['id']);
                        $rec['description'] = substr(strip_tags($rec['bf_description']), 0, 400 + 2 * MORE_RESULTAT_TAILLE_DESCRIPTION);
                        unset($rec['texte']);
                        $content[$rec['id']] = $rec;
                }
                return $content;                
        }
}

class MoteurRecherche_PROJET {
        public function get($ids) {
                $db = $GLOBALS['_MOTEUR_RECHERCHE_']['bd']['papyrus'];
                $req = $db->query(sprintf('SELECT p_id AS id, p_titre, p_description, p_date_creation AS date_creation' .
                                                                  ' FROM projet WHERE p_id IN (%s)',
                                                                  implode(',', $ids)));
                (DB::isError($req)) ? die($req->getMessage()) : '';
                $content = array();
                while($rec = $req->fetchRow(DB_FETCHMODE_ASSOC)) {
                        $rec['url_simple'] = $rec['url_simple'] = sprintf("%s?id_projet=%d",
                                                                                                                          trim($GLOBALS['_MOTEUR_RECHERCHE_']['spip'][0]['url'], '/'),
                                                                                                                          $rec['id']);
                        $rec['description'] = substr(strip_tags($rec['p_description']), 0, 400 + 2 * MORE_RESULTAT_TAILLE_DESCRIPTION);
                        unset($rec['p_description']);
                        $content[$rec['id']] = $rec;
                }
                return $content;                
        }
}

class MoteurRecherche_PAPYRUS {
        public function get($ids) {
        }
}

// http://stackoverflow.com/questions/348410/sort-an-array-based-on-another-array
function _sortArrayByArray($array, $orderArray) {
        $ordered = array();
        foreach($orderArray as $key) {
                if(array_key_exists($key, $array)) {
                        $ordered[$key] = $array[$key];
                        unset($array[$key]);
                }
        }
        return $ordered + $array;
}       

$q = $_SESSION['_MOTEUR_RECHERCHE_']['rechercher']['more_motif'];
$db = mysql_connect('127.0.0.1:9306', NULL, NULL, TRUE);
$req = mysql_query(sprintf("SELECT group_id, main_id FROM i_projet, i_spip, i_papyrus, i_bazar WHERE MATCH('%s') LIMIT 50", $q), $db);

$res = array();
$ids_par_poids = array();
while($rec = mysql_fetch_array($req, MYSQL_ASSOC)) {
        $res[$rec['group_id']][$rec['id']] = $rec;
        $ids_par_poids[] = $rec['main_id'];
}

$docs = array();

// spip
$spip = new MoteurRecherche_SPIP();
foreach($spip->get(array_filter(array_keys($res['spip']), 'intval')) as $v) {
        unset($res['spip'][$v['id']]['group_id'],
                  $res['spip'][$v['id']]['main_id'],
                  $res['spip'][$v['id']]['id']);
        // left: weight
        $docs['spip-' . $v['id']] = array_merge($v,     $res['spip'][$v['id']]);
}

// bazar
$bazar = new MoteurRecherche_BAZAR();
foreach($bazar->get(array_filter(array_keys($res['bazar']), 'intval')) as $v) {
        unset($res['bazar'][$v['id']]['group_id'],
                  $res['bazar'][$v['id']]['main_id'],
                  $res['bazar'][$v['id']]['id']);
        // left: weight
        $docs['bazar-' . $v['id']] = array_merge($v, $res['bazar'][$v['id']]);
}

// projet
$projet = new MoteurRecherche_PROJET();
foreach($projet->get(array_filter(array_keys($res['projet']), 'intval')) as $v) {
        unset($res['projet'][$v['id']]['group_id'],
                  $res['projet'][$v['id']]['main_id'],
                  $res['projet'][$v['id']]['id']);
        // left: weight
        $docs['projet-' . $v['id']] = array_merge($v, $res['projet'][$v['id']]);
}


// sort
/* var_dump(array_keys(_sortArrayByArray($docs, $ids_par_poids))); die;
// should be equal to
// SELECT main_id, group_id FROM i_projet, i_spip, i_papyrus, i_bazar WHERE MATCH('test') LIMIT 50; */
return "BLAH";




/*
// http://www.php.net/manual/fr/sphinx.examples.php
$s = new SphinxClient;
$s->setServer("localhost", 9306);
$s->setMatchMode(SPH_MATCH_ANY);
$s->setMaxQueryTime(3);
var_dump($s->query("test"));
*/