Subversion Repositories Applications.papyrus

Rev

Rev 2116 | Rev 2118 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2116 Rev 2117
Line 312... Line 312...
312 
# COSTE
 312 
# COSTE
313 
source coste : common {
 313 
source coste : common {
314 
	sql_db			= tb_eflore
 314 
	sql_db			= tb_eflore
Line 315... Line 315...
315 
 
 315 
 
316 
	sql_query		= \
 316 
	sql_query		= \
- 
 
 317 
        SELECT c.flore_bdtfx_nn AS id, c.nom_sci AS titre, dsc.body AS texte, cle.body AS determination, \
317 
        SELECT c.num_nom AS id, CONCAT("bdtfx", ":", c.num_nom) AS group_id, CONCAT(c.nom_sci, dsc.body) AS texte, CONCAT(c.nom_sci, cle.body) AS determination, c.nom_sci AS nom_sci \
 318 
        "coste" AS group_id, CONCAT("coste-", c.flore_bdtfx_nn) as main_id	\
318 
        FROM tb_eflore.coste_v2_00 c \
 319 
        FROM tb_eflore.coste_v2_00 c \
319 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
 320 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
- 
 
 321 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \
Line 320... Line 322...
320 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y';
 322 
        WHERE c.flore_bdtfx_nn != ''
- 
 
 323 
 
Line 321... Line 324...
321 
 
 324 
	sql_field_string	= group_id
322 
	sql_field_string	= group_id
 325 
	sql_attr_string		= main_id
Line 323... Line 326...
323 
 
 326 
 
324 
	sql_query_info	= SELECT * FROM coste_v2_00  WHERE num_nom=$id
 327 
	sql_query_info	= SELECT * FROM coste_v2_00  WHERE flore_bdtfx_nn=$id
325 
}
 328 
}
Line 326... Line 329...
326 
 
 329 
 
327 
index i_coste : i_common {
 330 
index i_coste : i_common {
Line -... Line 331...
- 
 
 331 
	source			= coste
- 
 
 332 
	path			= /var/lib/sphinx/coste
- 
 
 333 
 
- 
 
 334 
    infix_fields    = texte, titre
- 
 
 335 
}
- 
 
 336 
 
Line 328... Line 337...
328 
	source			= coste
 337 
# notes:
329 
	path			= /var/lib/sphinx/coste
 338 
# une nouvelle source d'indexation *DOIT*, pour être utilisable par le moteur de recherche papyrus,
330 
 
 339 
# définir les attributs *group_id* et *main_id*.
331 
    infix_fields    = texte, nom_sci
 340 
# cf: sphinx_search dans moteur_recherche_sphinx.php