* @version $id SVN
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
include_once(themePath('../search/' . SQL . '.inc.php'));
/**
* MatchDataFormat()
*
* @param string $keywords
* @param string $searchtype
* @return string $formatted_keywords
*/
if(!function_exists('MatchDataFormat')) {
function MatchDataFormat($keywords, $searchtype)
{
$keywords = trim(addslashes($keywords));
switch ($searchtype) {
case 'one':
if(strtolower(SQL)=='pgsql') {
$words = explode(' ', $keywords);
$formatted_keywords = '';
$op='';
foreach($words as $value) {
$formatted_keywords .= $op . $value;
$op=' | ';
}
trim($formatted_keywords);
}
if(strtolower(SQL)=='mysql') {
$formatted_keywords = $keywords;
}
break;
case 'all':
$words = explode(' ', $keywords);
$formatted_keywords = '';
$op='';
foreach($words as $value) {
$formatted_keywords .= $op . $value;
if(strtolower(SQL)=='pgsql') $op=' & ';
if(strtolower(SQL)=='mysql') $op=' + ';
}
trim($formatted_keywords);
break;
case 'exp':
if(strtolower(SQL)=='pgsql') {
$words = explode(' ', $keywords);
$formatted_keywords = '';
$op='';
foreach($words as $value) {
$formatted_keywords .= $op . $value;
$op=' & ';
}
trim($formatted_keywords);
}
if(strtolower(SQL)=='mysql') {
$formatted_keywords = '"' . $keywords . '"';
}
break;
default:
if(strtolower(SQL)=='pgsql') {
$words = explode(' ', $keywords);
$formatted_keywords = '';
$op='';
foreach($words as $value) {
$formatted_keywords .= $op . $value;
$op=' | ';
}
trim($formatted_keywords);
}
if(strtolower(SQL)=='mysql') {
$formatted_keywords = $keywords;
}
break;
}
return $formatted_keywords;
}
}
if(!function_exists('GetStatus')) {
function GetStatus($short_status)
{
$write = ' - ';
switch ($short_status) {
case 'PA':
$write .= _t('statut','PA');
break;
case 'AA':
$write .= _t('statut','AA');
break;
case 'P':
$write = '';
break;
case 'Y':
$write = '';
break;
case 'D':
$write .= _t('statut','draft');
break;
default:
$write = '';
}
return $write;
}
}
/**
* DisplayPublicResults()
*
* @param string $keywords
* @param string $searchtype
* @return void (echo)
**/
if(!function_exists('DisplayPublicResults')) {
function DisplayPublicResults($keywords, $searchtype)
{
$type = 'PUBLIC';
if(defined('MOD_PROJECT') && MOD_PROJECT == true) DisplaySearchProject($keywords, $type, $searchtype);
if(defined('MOD_NEWS') && MOD_NEWS == true) DisplaySearchNews($keywords, $type, $searchtype);
//echo '
';
if(defined('MOD_PUBLICATION') && MOD_PUBLICATION == true) DisplaySearchPublication($keywords, $type, $searchtype);
// echo '
';
if(defined('MOD_PUBLICATION') && MOD_PUBLICATION == true) DisplaySearchPubliContents($keywords, $type, $searchtype);
//echo '
';
if(defined('MOD_WORKSHOP') && MOD_WORKSHOP == true) DisplaySearchWorkshop($keywords, $type, $searchtype);
// echo '
';
if(defined('MOD_WORKSHOP') && MOD_WORKSHOP == true) DisplaySearchWorkshopRep($keywords, $type, $searchtype);
// echo '
';
if(defined('MOD_WORKSHOP') && MOD_WORKSHOP == true) DisplaySearchWorkshopRepContents($keywords, $type, $searchtype);
// echo '
';
if(defined('MOD_WORKSHOP') && MOD_WORKSHOP == true) DisplaySearchWorkshopCalendar($keywords, $type, $searchtype);
// echo '
';
if(defined('MOD_WORKSHOP') && MOD_WORKSHOP == true) DisplaySearchWorkshopCom($keywords, $type, $searchtype);
//echo '
';
if(defined('MOD_SDI') && MOD_SDI == true) DisplaySearchSdi($keywords, $type, $searchtype);
//echo '
';
}
}
/**
* DisplaySearchProject()
* Affiche les projets répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchProject')) {
function DisplaySearchProject($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_project_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','project_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_news = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'id' => $data[$i]['project_id'], 'name' => $data[$i]['project_name']));
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
}
if ($type == 'ADMIN') {
$link_news = 'index.php?rub=project&todo=det&id=' . $data[$i]['project_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$news_title = formatText($data[$i]['project_name'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $news_title . '';
$content .= '
';
$content .= '' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchNews()
* Affiche les news répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchNews')) {
function DisplaySearchNews($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_news_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','news_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_news = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['news']['linkvalue'], 'id' => $data[$i]['news_id'], 'name' => $data[$i]['news_title']));
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
}
if ($type == 'ADMIN') {
$link_news = 'index.php?rub=news&todo=det&id=' . $data[$i]['news_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$news_title = formatText($data[$i]['news_title'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $news_title . '';
$content .= '
';
$content .= '' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchNews()
* Affiche les news répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchNewsletter')) {
function DisplaySearchNewsletter($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_newsletter_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','newsletter_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
/**
* * NON IMPLEMENTE
* if ($type == 'PUBLIC') {
* $link_news = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['news']['linkvalue'], 'id' => $data[$i]['news_id']));
* $published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
* }
*/
if ($type == 'ADMIN') {
$link_newsletter = 'index.php?rub=newsletter&todo=det&id=' . $data[$i]['newsletter_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$newsletter_title = formatText($data[$i]['newsletter_title'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $newsletter_title . '';
$content .= '
';
$content .= '' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchPublication()
* Affiche les publications répondant à la requête sur $keywords
* Requête éffectuée sur le titre et le résumé des publications
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchPublication')) {
function DisplaySearchPublication($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_publication_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','publication_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_publi = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['publication']['linkvalue'], 'id' => $data[$i]['publi_id'], 'name' => $data[$i]['publi_title']));
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
}
if ($type == 'ADMIN') {
$link_publi = 'index.php?rub=publication&todo=det&id=' . $data[$i]['publi_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$publi_title = formatText($data[$i]['publi_title'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $publi_title . '';
$content .= '
';
$content .= '' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchPubliContents()
* Affiche les publications répondant à la requête sur $keywords
* Requête éffectuée sur le contenu des publications ( titre & body )
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchPubliContents')) {
function DisplaySearchPubliContents($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_publication_content_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','det_publication_module') . '
' . END_LINE;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_publi_det = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['publication-part']['linkvalue'], 'id' => $data[$i]['publicon_id'], 'parentid' => $data[$i]['publi_id'], 'name' => $data[$i]['publicon_title']));
$link_publi = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['publication']['linkvalue'], 'id' => $data[$i]['publi_id'], 'name' => $data[$i]['publi_title']));
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
}
if ($type == 'ADMIN') {
$link_publi_det = 'index.php?rub=contents&todo=det&parent=' . $data[$i]['publi_id'] . '&type=P&id=' . $data[$i]['publicon_id'];
$link_publi = 'index.php?rub=publication&todo=det&id=' . $data[$i]['publi_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$publicon_title = formatText($data[$i]['publicon_title'], '2HTML');
$publi_title = formatText($data[$i]['publi_title'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $publicon_title . '';
$content .= '
';
$content .= '' . _t('name','publication_module') . ' : ';
$content .= '' . $publi_title . '';
$content .= ' - ' . $published_display . GetStatus($data[$i]['statut']);
$content .= '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchWorkshop()
* Affiche les groupes de travail répondant à la requête sur $keywords
* Requête éffectuée sur le libellé et le résumé des groupes de travail
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchWorkshop')) {
function DisplaySearchWorkshop($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_workshop_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','workshop_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_workshop = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['workgroup']['linkvalue'], 'id' => $data[$i]['workshop_id'], 'name' => $data[$i]['workshop_denomination']));
}
if ($type == 'ADMIN') {
$link_workshop = 'index.php?rub=workshop&todo=det&id=' . $data[$i]['workshop_id'];
}
$workshop_title = formatText($data[$i]['workshop_denomination'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $workshop_title . '';
$statut = GetStatus($data[$i]['statut']);
if (!empty($statut)) $content .= '(' . $statut . ')';
$content .= $pertinence;
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchWorkshopRep()
* Affiche les groupes de travail répondant à la requête sur $keywords
* Requête éffectuée sur le contenu des rapports de groupes de travail ( titre & body )
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchWorkshopRep')) {
function DisplaySearchWorkshopRep($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_workrep_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','workshoprep_module') . '
' . END_LINE;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_workrep = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['report']['linkvalue'], 'id' => $data[$i]['workrep_id'], 'name' => $data[$i]['workrep_title']));
$link_workshop = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['workgroup']['linkvalue'], 'id' => $data[$i]['workshop_id'], 'name' => $data[$i]['workshop_denomination']));
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
}
if ($type == 'ADMIN') {
$link_workrep = 'index.php?rub=workshoprep&todo=det&id=' . $data[$i]['workrep_id'];
$link_workshop = 'index.php?rub=workshop&todo=det&id=' . $data[$i]['workshop_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$workrep_title = formatText($data[$i]['workrep_title'], '2HTML');
$workshop_title = formatText($data[$i]['workshop_denomination'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $workrep_title . '';
$content .= '
';
$content .= '(' . _t('name','workshop_module') . ' : ';
$content .= '' . $workshop_title . '';
$content .= ' - ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchWorkshopRepContents()
* Affiche les groupes de travail répondant à la requête sur $keywords
* Requête éffectuée sur le contenu des rapports de groupes de travail ( titre & body )
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchWorkshopRepContents')) {
function DisplaySearchWorkshopRepContents($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_workrep_content_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','workshoprepcon_module') . '
' . END_LINE;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_workrep_det = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['report-part']['linkvalue'], 'id' => $data[$i]['workrepcon_id'], 'parentid' => $data[$i]['workrep_id'], 'name' => $data[$i]['workrepcon_title']));
$link_workrep = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['report']['linkvalue'], 'id' => $data[$i]['workrep_id'], 'name' => $data[$i]['workrep_title']));
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
}
if ($type == 'ADMIN') {
$link_workrep_det = 'index.php?rub=contents&todo=det&parent=' . $data[$i]['workrep_id'] . '&type=W&id=' . $data[$i]['workrepcon_id'];
$link_workrep = 'index.php?rub=workshoprep&todo=det&id=' . $data[$i]['workrep_id'];
$published_display = _t('divers','date_crea') . ' ' . $data[$i]['date_display'];
}
$workrepcon_title = formatText($data[$i]['workrepcon_title'], '2HTML');
$workrep_title = formatText($data[$i]['workrep_title'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $workrepcon_title . '';
$content .= '
';
$content .= '(' . _t('name','workshoprep_module') . ' : ';
$content .= '' . $workrep_title . '';
$content .= ' - ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchWorkshopCalendar()
* Affiche les groupes de travail répondant à la requête sur $keywords
* Requête éffectuée sur les tâches du calendrier de groupes de travail ( libellé & contenu des tâches )
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchWorkshopCalendar')) {
function DisplaySearchWorkshopCalendar($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_workshop_calendar_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','workshopcal_module') . '
' . END_LINE;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') {
$link_workcal = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['calendar']['linkvalue'], 'id' => $data[$i]['workcal_workshop_id'], 'name' => $data[$i]['workcal_task']));
$link_workshop = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['workgroup']['linkvalue'], 'id' => $data[$i]['workcal_workshop_id'], 'name' => $data[$i]['workshop_denomination']));
}
if ($type == 'ADMIN') {
$link_workcal = 'index.php?rub=workshop&todo=list_cal&id=' . $data[$i]['workcal_workshop_id'];
$link_workshop = 'index.php?rub=workshop&todo=det&id=' . $data[$i]['workcal_workshop_id'];
}
$workcal_title = formatText($data[$i]['workcal_task'], '2HTML');
$workshop_title = formatText($data[$i]['workshop_denomination'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . END_LINE;
$content .= '' . $workcal_title . '';
$content .= '
';
$content .= '(' . _t('name','workshop_module') . ' : ';
$content .= '' . $workshop_title . '';
if (!empty($statut)) $content .= $statut;
$content .= ')';
$content .= '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchWorkshopCom()
* Affiche les groupes de travail répondant à la requête sur $keywords
* Requête éffectuée sur les discussions du calendrier de groupes de travail ( titre & contenu )
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchWorkshopCom')) {
function DisplaySearchWorkshopCom($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_workshop_com_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','workshopcom_module') . '
' . END_LINE;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($data[$i]['workcom_parent'] != 0) $id_com = $data[$i]['workcom_parent'];
else $id_com = $data[$i]['workcom_id'] ;
if ($type == 'PUBLIC') {
$link_workcom = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['topic']['linkvalue'], 'id' => $id_com, 'parentid' => $data[$i]['workcom_workshop_id'], 'name' => $data[$i]['workcom_subject']));
$link_workshop = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['workgroup']['linkvalue'], 'id' => $data[$i]['workcom_workshop_id'], 'name' => $data[$i]['workshop_denomination']));
}
if ($type == 'ADMIN') {
$link_workcom = 'index.php?rub=workshop&todo=det_com&id=' . $data[$i]['workcom_workshop_id'] . '&com_id=' . $id_com;
$link_workshop = 'index.php?rub=workshop&todo=det&id=' . $data[$i]['workcom_workshop_id'];
}
$workcom_title = formatText($data[$i]['workcom_subject'], '2HTML');
$workshop_title = formatText($data[$i]['workshop_denomination'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
if ($type == 'ADMIN' || ($type == 'PUBLIC' && CookieWorkshopid($data[$i]['workcom_workshop_id']))) {
$content .= '- ' . END_LINE;
$content .= '' . $workcom_title . '';
$content .= '
';
$content .= '(' . _t('name','workshop_module') . ' : ';
$content .= '' . $workshop_title . '';
if (!empty($statut)) $content .= $statut;
$content .= ')';
$content .= '';
$content .= $pertinence;
$content .= ' ' . END_LINE;
} else $content .= '';
}
$content .= '
' . END_LINE;
if ($content == '
') return '';
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchSdi()
* Affiche les indicateurs répondant à la requête sur $keywords
* Requête éffectuée sur les informations générales des indicateurs
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchSdi')) {
function DisplaySearchSdi($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_sdi_search(MatchDataFormat($keywords, $searchtype), $type));
$content = '';
$content .= '
' . _t('search','sdi_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') $link_sdi = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['dashboard']['linkvalue'], 'id' => $data[$i]['sdii_id'], 'parentid' => 1, 'name' => $data[$i]['sdii_name']));
if ($type == 'ADMIN') $link_sdi = 'index.php?rub=sdi&todo=det&id=' . $data[$i]['sdii_id'];
$news_title = formatText($data[$i]['sdii_name'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $news_title . '';
$content .= '
';
$content .= '( ' . _t('statut','published_on') . ' ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= $pertinence;
$content .= ' ' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchYellowpages()
* Affiche les organisations de l'annuaire répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchYellowpages')) {
function DisplaySearchYellowpages($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_yellowpages_search($keywords, $type, $searchtype));
$content = '';
$content .= '
' . _t('search','yellowpages_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') $link_yp = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['directory-detail']['linkvalue'], 'id' => $data[$i]['yellowp_id'], 'name' => $data[$i]['yellowp_name']));
if ($type == 'ADMIN') $link_yp = 'index.php?rub=yellowpages&todo=det&id=' . $data[$i]['yellowp_id'];
$yp_title = formatText($data[$i]['yellowp_name'], '2HTML');
$pertinence = _t('divers','none');
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $yp_title . '';
$content .= '(' . _t('divers','date_crea') . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchUser()
* Affiche les utilisateurs répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchUser')) {
function DisplaySearchUser($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_user_search($keywords, $type, $searchtype));
$content = '';
$content .= '
' . _t('search','user_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'PUBLIC') $link_user = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['user-profile']['linkvalue'], 'id' => $data[$i]['user_id'], 'name' => $data[$i]['user_login']));
if ($type == 'ADMIN') $link_user = 'index.php?rub=user&todo=det&id=' . $data[$i]['user_id'];
$user_title = formatText($data[$i]['user_login']);
$pertinence = _t('divers','none');
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $user_title . '';
$content .= '(' . _t('divers','date_crea') . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchTheme()
* Affiche les theme répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchTheme')) {
function DisplaySearchTheme($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_theme_search($keywords, $type, $searchtype));
$content = '';
$content .= '
' . _t('search','theme_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'ADMIN') $link_theme = 'index.php?rub=theme&todo=det&id=' . $data[$i]['theme_id'];
$theme_title = formatText($data[$i]['theme_name']);
$pertinence = _t('divers','none');
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $theme_title . '';
$content .= '(' . _t('divers','date_crea') . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchScale()
* Affiche les échelles répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchScale')) {
function DisplaySearchScale($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_scale_search($keywords, $type, $searchtype));
$content = '';
$content .= '
' . _t('search','scale_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'ADMIN') $link_scale = 'index.php?rub=scale&todo=det&id=' . $data[$i]['scale_id'];
$scale_title = formatText($data[$i]['scale_denomination']);
$pertinence = _t('divers','none');
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $scale_title . '';
$content .= '(' . _t('divers','date_crea') . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplaySearchLevel()
* Affiche les niveaux répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchLevel')) {
function DisplaySearchLevel($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_level_search($keywords, $type, $searchtype));
$content = '';
$content .= '
' . _t('search','level_module') . '
' . END_LINE;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . END_LINE;
else {
$content .= '
' . END_LINE;
for($i = 0; $i < count($data); $i++) {
if ($type == 'ADMIN') $link_level = 'index.php?rub=level&todo=det&id=' . $data[$i]['level_id'];
$level_title = formatText($data[$i]['level_name']);
$pertinence = _t('divers','none');
$published_display = $data[$i]['date_display'];
$content .= '- ' . END_LINE;
$content .= '' . $level_title . '';
$content .= '(' . _t('divers','date_crea') . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
}
$content .= '
' . END_LINE;
echo $content;
}
}
/**
* DisplayQueryTime()
* Affiche le temps d'execution des requêtes
*
* @param float $start_time
* @param float $end_time
* @return string $content (echo)
*/
if(!function_exists('DisplayQueryTime')) {
function DisplayQueryTime($start_time, $end_time)
{
$content = '' . END_LINE;
$content .= _t('search','query_time') . ' ' . (substr($end_time - $start_time, 0, 5)) . ' ' . _t('search','query_seconds');
$content .= '
' . END_LINE;
echo $content;
}
}
if(!function_exists('DisplayAdvancedSearchForm')) {
function DisplayAdvancedSearchForm()
{
$action = $GLOBALS['links'][U_L]['search-result']['linkvalue'];
$content = '';
echo $content;
}
}
if(!function_exists('FormatPertinenceIndice')) {
function FormatPertinenceIndice($float) {
$pertinence_i = ($float != 0) ? number_format(round($float, 3), 3, ',', ' ') : _t('search','score_not_good');
$pertinence= ' - ' . _t('search','score_abbr') . ' : ' . $pertinence_i . '';
return $pertinence;
}
}
?>