* @version $Id$
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
include_once(override('../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));
// if MODE_SEARCH is equal to 'WITH QUERY EXPANSION' we do not format keywords
// or $searchtype === 'expanded'
if((defined('SEARCH_MODE') && stripos(SEARCH_MODE, 'boolean') === false) || $searchtype === 'expanded') return $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 '
';
if(defined('MOD_YELLOWPAGES') && MOD_YELLOWPAGES == true) DisplaySearchYellowpages($keywords, $type, $searchtype);
}
}
/**
* DisplaySearchComment()
* Affiche les projets répondant à la requête sur $keywords
*
* @param string $keywords
* @return string $content
*/
if(!function_exists('DisplaySearchComment')) {
function DisplaySearchComment($keywords, $type, $searchtype)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_comment_search(MatchDataFormat($keywords, $searchtype), $type, $searchtype));
// no search on comments from public app
if($type == 'PUBLIC') return true;
$content = '' . PHP_EOL;
echo $content;
}
}
/**
* 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, $searchtype));
$content = '';
$content .= '
' . _t('search','project_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $news_title . '';
$content .= ' - ' .mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','page_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
for($i = 0; $i < count($data); $i++) {
// @todo see if necessary to implement or not
// if ($type == 'PUBLIC') {
// $link = HrefMaker(array('rub' => $GLOBALS['links'][U_L]['page']['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 = 'index.php?rub=page&todo=det&id=' . $data[$i]['page_id'];
$published_display = _t('divers','date_crea') . ' : ' . $data[$i]['date_display'];
}
$title = formatText($data[$i]['page_title'], '2HTML');
$pertinence = FormatPertinenceIndice($data[$i]['pertinence']);
$content .= '- ' . PHP_EOL;
$content .= '' . $title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','news_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $news_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','newsletter_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $newsletter_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','publication_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $publi_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','det_publication_module') . '
' . PHP_EOL;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $publicon_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . '';
$content .= '
';
$content .= '' . mb_ucfirst(_t('name','publication_module')) . ' : ';
$content .= '' . $publi_title . '';
$content .= '';
$content .= $pertinence;
$content .= ' ' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','workshop_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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']);
$published_display = _t('divers','date_crea') . ' : ' . $data[$i]['date_display'];
$content .= '- ' . PHP_EOL;
$content .= '' . $workshop_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','workshoprep_module') . '
' . PHP_EOL;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . PHP_EOL;
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']);
$content .= '- ' . PHP_EOL;
$content .= '' . $workrep_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= '
';
$content .= '' . mb_ucfirst(_t('name','workshop_module')) . ' : ';
$content .= '' . $workshop_title . '';
$content .= '';
$content .= $pertinence;
$content .= ' ' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','workshoprepcon_module') . '
' . PHP_EOL;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $workrepcon_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . GetStatus($data[$i]['statut']) . '';
$content .= '
';
$content .= '' . mb_ucfirst(_t('name','workshoprep_module')) . ' : ';
$content .= '' . $workrep_title . '';
$content .= '';
$content .= $pertinence;
$content .= ' ' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','workshopcal_module') . '
' . PHP_EOL;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) return true;
else {
$content .= '
' . PHP_EOL;
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']);
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
$content .= '- ' . PHP_EOL;
$content .= '' . $workcal_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . '';
$content .= '
';
$content .= '' . mb_ucfirst(_t('name','workshop_module')). ' : ';
$content .= '' . $workshop_title . '';
$content .= '';
$content .= $pertinence;
$content .= ' ' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','workshopcom_module') . '
' . PHP_EOL;
//if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) return true;
else {
$stack = array();
$content .= '
' . PHP_EOL;
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']);
$published_display = _t('statut','published_on') . ' ' . $data[$i]['date_display'];
// prevent duplicates entries
if(!in_array($data[$i]['workcom_workshop_id'], $stack)) {
if ($type == 'ADMIN' || ($type == 'PUBLIC' && $GLOBALS['l21auth']->isWorkgroupUser($data[$i]['workcom_workshop_id'], $GLOBALS['sql_object']))) {
$content .= '- ' . PHP_EOL;
$content .= '' . $workcom_title . '';
$content .= ' - ' . mb_ucfirst($published_display) . '';
$content .= '
';
$content .= '' . mb_ucfirst(_t('name','workshop_module')) . ' : ';
$content .= '' . $workshop_title . '';
$content .= '';
$content .= $pertinence;
$content .= ' ' . PHP_EOL;
}
array_push($stack, $data[$i]['workcom_workshop_id']); // prevent duplicates entries
}
}
$content .= '
' . PHP_EOL;
if ($content == '
') return '';
}
$content .= '
';
$content .= '
' . _t('search','sdi_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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='.$rub.'&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 .= '- ' . PHP_EOL;
$content .= '' . $news_title . '';
$content .= ' - ' . mb_ucfirst(_t('statut','published_on')) . ' ' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= $pertinence;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','yellowpages_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $yp_title . '';
$content .= ' - ' . mb_ucfirst(_t('divers','date_crea')) . ' : ' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','user_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $user_title . '';
$content .= '(' . mb_ucfirst(_t('divers','date_crea')) . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','tag_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
for($i = 0; $i < count($data); $i++) {
if ($type == 'ADMIN') $link = 'index.php?rub=tag&todo=det&id=' . $data[$i]['tag_id'];
$tag_title = formatText($data[$i]['tag_name']);
$pertinence = _t('divers','none');
$published_display = $data[$i]['date_display'];
$content .= '- ' . PHP_EOL;
$content .= '' . $tag_title . '';
$content .= '(' . mb_ucfirst(_t('divers','date_crea')) . ' : ' . $published_display . ')';
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','level_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $level_title . '';
$content .= ' - ' . mb_ucfirst(_t('divers','date_crea')) . ' : ' . $published_display . GetStatus($data[$i]['statut']) . '';
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
';
$content .= '
' . _t('search','scale_module') . '
' . PHP_EOL;
if (count($data) == 1 && $data == 0) $content .= '
' . _t('search','no_result') . '
' . PHP_EOL;
else {
$content .= '
' . PHP_EOL;
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 .= '- ' . PHP_EOL;
$content .= '' . $scale_title . '';
$content .= '(' . mb_ucfirst(_t('divers','date_crea')) . ' : ' . $published_display . GetStatus($data[$i]['statut']) . ')';
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
$content .= _t('search','query_time') . ' ' . (substr($end_time - $start_time, 0, 5)) . ' ' . _t('search','query_seconds');
$content .= '
' . PHP_EOL;
echo $content;
}
}
if(!function_exists('DisplayAdvancedSearchForm')) {
function DisplayAdvancedSearchForm()
{
if(defined('SEARCH_MODE') && stripos(SEARCH_MODE, 'boolean') === false) $disabled=' disabled';
else $disabled='';
$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;
}
}
?>