New file |
0,0 → 1,183 |
<?php |
/*vim: set expandtab tabstop=4 shiftwidth=4: */ |
// +------------------------------------------------------------------------------------------------------+ |
// | PHP version 4.1 | |
// +------------------------------------------------------------------------------------------------------+ |
// | Copyright (C) 2004 Tela Botanica (accueil@tela-botanica.org) | |
// +------------------------------------------------------------------------------------------------------+ |
// | This library is free software; you can redistribute it and/or | |
// | modify it under the terms of the GNU Lesser General Public | |
// | License as published by the Free Software Foundation; either | |
// | version 2.1 of the License, or (at your option) any later version. | |
// | | |
// | This library is distributed in the hope that it will be useful, | |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of | |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
// | Lesser General Public License for more details. | |
// | | |
// | You should have received a copy of the GNU Lesser General Public | |
// | License along with this library; if not, write to the Free Software | |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | |
// +------------------------------------------------------------------------------------------------------+ |
// CVS : $Id: bbc_requete_lien.fonct.php,v 1.1 2005-11-23 10:22:25 jp_milcent Exp $ |
/** |
* Fonctions de création de la requête sur un lien. |
* |
* Contient une fonction créant la requête d'intérogation de la base de données. |
* Valable pour le paramètre "lien". |
* |
*@package BiblioBota-Consultation |
*@subpackage Fonctions |
//Auteur original : |
*@author Jean-Charles GRANGER <tela@vecteur.org> |
//Autres auteurs : |
*@author Jean-Pascal MILCENT <jpm@clapas.org> |
*@copyright Tela-Botanica 2000-2004 |
*@version $Revision: 1.1 $ $Date: 2005-11-23 10:22:25 $ |
// +------------------------------------------------------------------------------------------------------+ |
*/ |
|
// +------------------------------------------------------------------------------------------------------+ |
// | ENTETE du PROGRAMME | |
// +------------------------------------------------------------------------------------------------------+ |
/*Mettre ici les inclusions de fichiers*/ |
|
|
// +------------------------------------------------------------------------------------------------------+ |
// | LISTE de FONCTIONS | |
// +------------------------------------------------------------------------------------------------------+ |
/*Mettre ici la liste de fonctions.*/ |
|
function mkquery() |
{ |
global $TabFinder, $tbl; |
|
// Initialisation |
$order_query = ''; |
|
// Si la variable de catégorie vaut 0, il n'y a pas affinage de la requête par catégorie. Sinon, on affine. |
|
if ($TabFinder['categ'] != 0) { |
$add_to_from = $tbl['cat'].', '.$tbl['categlien'].', '; |
$add_to_query = ' AND ('.$tbl['cat'].'.B_CAT_IDCAT = '.$TabFinder['categ'].')'; |
|
if ($TabFinder['chaine'] != '') { |
$join_categ = ' AND '; |
} else { |
$join_categ = ''; |
} |
|
$join_categ .= ' AND ('.$tbl['link'].'.B_L_IDLINK = '.$tbl['categlien'].'.B_LC_IDLINK) AND ('.$tbl['cat'].'.B_CAT_IDCAT = '.$tbl['categlien'].'.B_LC_IDCAT)'; |
} else { |
$add_to_from = ''; |
$add_to_query = ''; |
$join_categ = ''; |
} |
|
// Création du SELECT |
$normal_query = 'SELECT '.$tbl['link'].'.*, '.$tbl['str'].'.B_S_NOM '; |
// si le raffinement de catégorie vaut autre chose que 0, il faut ajouter les tables de catégories |
if ($TabFinder['categ'] != 0) { |
$normal_query .= ', '.$tbl['categlien'].'.*, '.$tbl['cat'].'.B_CAT_LABEL, '.$tbl['cat'].'.B_CAT_IDCAT '; |
} |
|
// Création du FROM |
$normal_query .= 'FROM '.$add_to_from.$tbl['link'].' LEFT JOIN '.$tbl['str'].' ON '.$tbl['link'].'.B_L_LKSTR = '.$tbl['str'].'.B_S_IDSTR '; |
|
// Création du WHERE |
$normal_query .= 'WHERE B_L_CACHER = 0 '; |
|
if (($TabFinder['typque'] == 0) && ($TabFinder['chaine'] != '')) { |
$normal_query .= ' AND ('; |
$normal_query .= $tbl['link'].'.B_L_TITRE like "%'.$TabFinder['chaine'].'%" '. |
'OR '.$tbl['link'].'.B_L_URL like "%'.$TabFinder['chaine'].'%" '. |
'OR '.$tbl['link'].'.B_L_RESUMCLE like "%'.$TabFinder['chaine'].'%" '; |
$normal_query .= ') '; |
} else if ($TabFinder['chaine'] != '') { |
$normal_query .= ' AND ('; |
|
// Si la variable de type de recherche vaut 1, il faut que le moteur recherche chaque motif |
|
if ($TabFinder['typque'] == 1) { |
$result_from_ex = explode (' ', $TabFinder['chaine']); |
} |
|
$i_ex = 0; |
|
while ($i_ex < count($result_from_ex)) { |
$normal_query .= $tbl['link'].'.B_L_TITRE LIKE "%'; |
if ($result_from_ex[$i_ex] != '') { |
$normal_query .= $result_from_ex[$i_ex]; |
} |
$normal_query .= '%" OR '; |
|
$normal_query .= $tbl['link'].'.B_L_URL LIKE "%'; |
if ($result_from_ex[$i_ex] != '') { |
$normal_query .= $result_from_ex[$i_ex]; |
} |
$normal_query .= '%" OR '; |
|
$normal_query .= $tbl['link'].'.B_L_RESUMCLE LIKE "%'; |
if ($result_from_ex[$i_ex] != '') { |
$normal_query .= $result_from_ex[$i_ex]; |
} |
$normal_query .= '%"'; |
|
if ($i_ex < (count($result_from_ex) - 1)) { |
$normal_query .= ') AND ('; |
} |
$i_ex++; |
} |
|
$normal_query .= ')'; |
} |
|
// traitement du réducteur SINCE (fonction de la date) |
|
if ($TabFinder['since'] != '') { |
$since_var = explode('/', $TabFinder['since']); |
|
if (empty($since_var[0])) { |
$since_var[0] = ''; |
} |
if (empty($since_var[1])) { |
$since_var[1] = ''; |
} |
if (empty($since_var[2])) { |
$since_var[2] = ''; |
} |
$timestamp = mktime(NULL, NULL, NULL, $since_var[1], $since_var[0], $since_var[2]); |
|
if (!ereg('WHERE', $normal_query)) { |
$normal_query .= ' WHERE '; |
} else { |
$normal_query .= ' AND '; |
} |
$normal_query .= 'B_L_MAJFICHE > '.$timestamp; |
} |
|
// Création de l'ordre de tri |
$order_query = ' ORDER BY '.$TabFinder['sort']; |
|
// Affectation de la requête à la variable qui va l'envoyer au moteur |
|
$unreq = $normal_query.' '.$join_categ.' '.$add_to_query.' '.$order_query; |
return $unreq; |
} |
|
/* +--Fin du code ----------------------------------------------------------------------------------------+ |
* |
* $Log: not supported by cvs2svn $ |
* Revision 1.4 2005/06/20 17:32:14 jpm |
* Correction erreur de construction de la requête sql. |
* |
* Revision 1.3 2005/05/17 10:10:08 jpm |
* Correction des bogues avant mise en ligne du site v4. |
* |
* Revision 1.2 2004/09/14 11:49:52 jpm |
* Ajout de l'entête au fichier. |
* |
* |
* +-- Fin du code ----------------------------------------------------------------------------------------+ |
*/ |
?> |