* */ /** * Class Search : Contains all the function to make a search and show the search results * * @author Claire Figueras * @license GPL * @package Maarch LetterBox 2.3 * @version 2.0 */ class search extends dbquery { /** * Mark with a color background the word you're searching in the detail of the row * * @param string $words * @param string $need * @return string $words */ private function thisword($words,$need) { // mark with a color background the word you're searching in the detail of the row $ar_need = explode(" ", $need); for($i = 0; $i > count($ar_need); $i++) { $words = str_replace($ar_need[$i],"".$ar_need[$i]."",$words); } return $words; } /** * Configure the SQL argument order by */ public function define_order() { // configure the sql argument order by $orderby = ""; if(isset($_GET['order'])) { if($_GET['order'] == "datedesc") { $orderby = "order by CREATION_DATE desc"; } elseif($_GET['order'] == "dateasc") { $orderby = "order by CREATION_DATE asc"; } elseif($_GET['order'] == "titledesc") { $orderby = "order by TITLE desc"; } elseif($_GET['order'] == "titleasc") { $orderby = "order by TITLE asc"; } if($_GET['order'] == "refdesc") { $orderby = "order by IDENTIFIER desc"; } elseif($_GET['order'] == "refasc") { $orderby = "order by IDENTIFIER asc"; } if($_GET['order'] == "residdesc") { $orderby = "order by RES_ID desc"; } elseif($_GET['order'] == "residasc") { $orderby = "order by RES_ID asc"; } if($_GET['order'] == "typedesc") { $orderby = "order by TYPE_ID desc"; } elseif($_GET['order'] == "typeasc") { $orderby = "order by TYPE_ID asc"; } elseif($_GET['order'] == "statdesc") { $orderby = "order by STATUS desc"; } elseif($_GET['order'] == "statasc") { $orderby = "order by STATUS asc"; } elseif($_GET['order'] == "autdesc") { $orderby = "order by AUTHOR desc"; } elseif($_GET['order'] == "auttasc") { $orderby = "order by AUTHOR asc"; } elseif($_GET['order'] == "servdesc") { $orderby = "order by DESTINATION desc"; } elseif($_GET['order'] == "servasc") { $orderby = "order by DESTINATION asc"; } elseif($_GET['order'] == "destdesc") { $orderby = "order by DEST_USER desc"; } elseif($_GET['order'] == "destasc") { $orderby = "order by DEST_USER asc"; } elseif($_GET['order'] == "statdesc") { $orderby = "order by STATUS desc"; } elseif($_GET['order'] == "statasc") { $orderby = "order by STATUS asc"; } elseif($_GET['order'] == "priodesc") { $orderby = "order by PRIORITY desc"; } elseif($_GET['order'] == "prioasc") { $orderby = "order by PRIORITY asc"; } elseif($_GET['order'] == "descdesc") { $orderby = "order by DESCRIPTION desc"; } elseif($_GET['order'] == "descasc") { $orderby = "order by DESCRIPTION asc"; } elseif($_GET['order'] == "chronoasc") { $orderby = "order by IDENTIFIER asc"; } elseif($_GET['order'] == "chronodesc") { $orderby = "order by IDENTIFIER desc"; } elseif($_GET['order'] == "sociasc") { $orderby = "order by SOCIETE asc"; } elseif($_GET['order'] == "chronodesc") { $orderby = "order by SOCIETE desc"; } } return $orderby; } /** * Show the document list in result of the search * * @param array $listarr * @param integer $nb_total total number of documents * @param string $title * @param string $what search expression * @param string $name "search" by default */ public function list_doc($listarr, $nb_total, $title,$what,$name = "search") { // show the document list in result of the search $page_list1 = ""; $page_list2 = ""; $func = new functions(); if(isset($_GET['start'])) { $start = strip_tags($_GET['start']); } else { $start = 0; } if(isset($_GET['order'])) { $orderby = strip_tags($_GET['order']); } else { $orderby = 0; } if($name == "search" && empty($_SESSION['quicksearch'])) { $link = "index.php?page=".$name."&search=".$what; } else { $link = "index.php?page=".$name."&search=".$what; $link .= "&search=".$_SESSION['search']; for($i=0;$i"") { $link .="&emetteur=".$_SESSION['emetteur_search']; } if($_SESSION['societe_search']<>"") { $link .="&societe=".$_SESSION['societe_search']; } if($_SESSION['priority_search']<>"") { $link .="&priority=".$_SESSION['priority_search']; } if($_SESSION['numcourrier']<>"") { $link .="&numcourrier=".$_SESSION['numcourrier']; } if($_SESSION['numged']<>"") { $link .="&numged=".$_SESSION['numged']; } if($_SESSION['destinataire']<>"") { $link .="&destinataire=".$_SESSION['destinataire']; } if($_SESSION['objet']<>"") { $link .="&objet=".$_SESSION['objet']; } if($_SESSION['type']<>"") { $link .="&type=".$_SESSION['type']; } if($_SESSION['naturesend']<>"") { $link .="&naturesend=".$_SESSION['naturesend']; } if($_SESSION['enr_from']<>"") { $link .="&enr_from=".$_SESSION['enr_from']; } if($_SESSION['enr_to']<>"") { $link .="&enr_to=".$_SESSION['enr_to']; } if($_SESSION['trait_from']<>"") { $link .="&trait_from=".$_SESSION['trait_from']; } if($_SESSION['trait_to']<>"") { $link .="&trait_to=".$_SESSION['trait_to']; } if($_SESSION['status']<>"") { $link .="&status=".$_SESSION['status']; } /*if($_SESSION['naturereceipt']<>"") { $link .="&naturereceipt=".$_SESSION['naturereceipt']; }*/ if($_SESSION['courrier_search']=="true") { $link .="&courrier=".$_SESSION['courrier_search']; } if($_SESSION['AR']=="true") { $link .="&AR=".$_SESSION['AR']; } if($_SESSION['fax']=="true") { $link .="&fax=".$_SESSION['fax']; } if($_SESSION['courriel']=="true") { $link .="&courriel=".$_SESSION['courriel']; } if($_SESSION['autre']=="true") { $link .="&autre=".$_SESSION['autre']; } if($_SESSION['direct']=="true") { $link .="&direct=".$_SESSION['direct']; } if($_SESSION['norep']=="true") { $link .="&norep=".$_SESSION['norep']; } if($_SESSION['copies']=="true") { $link .="&copies=".$_SESSION['copies']; } if($_SESSION['services']<>"") { $link .="&services=".$_SESSION['services']; } if($_SESSION['quartier']<>"") { $link .="&quartier=".$_SESSION['quartier']; } if($_SESSION['num']<>"") { $link .="&num=".$_SESSION['num']; } if($_SESSION['rue']<>"") { $link .="&rue=".$_SESSION['rue']; } if($_SESSION['Cp']<>"") { $link .="&Cp=".$_SESSION['Cp']; } if($_SESSION['ville']<>"") { $link .="&ville=".$_SESSION['ville']; } $link .= "&imageField.x=19"; $link .= "&imageField.y=18"; } // define the defaults values $nb_show = $_SESSION['config']['nblinetoshow']; $nb_pages = ceil($nb_total/$nb_show); // if they are more 1 page we do pagination with 2 forms if($nb_pages > 1) { $next_start = 0; $page_list1 = '

'; $lastpage = 0; for($i = 0;$i <> $nb_pages; $i++) { $page_name = $i + 1; $the_line = $i + 1; if($start == $next_start) { $page_list1 .= ""; $page_list2 .= ""; } else { $page_list1 .= ""; $page_list2 .= ""; } $next_start = $next_start + $nb_show; $lastpage = $next_start; } $lastpage = $lastpage - $nb_show; $previous = ""; $next = ""; if($start > 0) { $start_prev = $start - $nb_show; $previous = "< "._PREVIOUS." "; } if($start <> $lastpage) { $start_next = $start + $nb_show; $next = " "._NEXT." >"; } $page_list1 = $page_list1."".$previous." ".$next."

"; $page_list2 = $page_list2."".$previous." ".$next."

"; } $this->connect(); ?>

>

<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?> 		     
<? echo _TO_PROCESS;?> <? echo _IN_PROGRESS;?> <? echo _CLOSED;?> <? echo _ONGOING;?> <? echo _ONGOING;?> show($this->thisword($listarr[$theline]['RES_ID'],$what)); ?> show($this->thisword($listarr[$theline]['DESCRIPTION'],$what)); ?> show($this->thisword($listarr[$theline]['AUTHOR'],$what)); ?> show($this->thisword($listarr[$theline]['DEST_USER'],$what)); ?> query("select DESCRIPTION from ".$_SESSION['tablename']['doctypes']." where TYPE_ID = '".$listarr[$theline]['LIB_TYPE']."'"); $res = $this->fetch_object(); echo $func->show($res->DESCRIPTION,$what); // echo $func->show($this->thisword($listarr[$theline]['LIB_TYPE'],$what)); ?> dateformat($listarr[$theline]['CUSTOM_D1']); ?> show($this->thisword($listarr[$theline]['SOCIETE'],$what)); } else { $this->query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$listarr[$theline]['DESTINATION']."'"); $res = $this->fetch_object(); echo $res->SERVICE; }?> "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "PDF") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "TXT") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "WAV") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "AVI" || $listarr[$theline]['FORMAT'] == "MPG" || $listarr[$theline]['FORMAT'] == "MPEG" || $listarr[$theline]['FORMAT'] == "MPE" || $listarr[$theline]['FORMAT'] == "QT" || $listarr[$theline]['FORMAT'] == "MOV") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "JPG" || $listarr[$theline]['FORMAT'] == "JPEG" || $listarr[$theline]['FORMAT'] == "GIF" || $listarr[$theline]['FORMAT'] == "JPE" ) { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "XLS" || $listarr[$theline]['FORMAT'] == "CSV" ) { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "DOC" || $listarr[$theline]['FORMAT'] == "RTF") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "PDFHQ") { echo " "._SHOW_MAIL.""; } else { echo " "; } ?> <? echo _DETAILS; ?> 'MAARCH'){?><? echo _DOWNLOAD;?>
"; if ($_SESSION['user']['export'] == true) { ?>
"; } /** * Show the document list in result of the search for an document id (indexation) * * @param array $listarr * @param integer $nb_total total number of documents * @param string $title * @param string $what search expression * @param string $name "search" by default */ public function list_doc2($listarr, $nb_total, $title,$what,$name = "search", $find_folder) { // show the document list in result of the search $page_list1 = ""; $page_list2 = ""; $func = new functions(); if(isset($_GET['start'])) { $start = strip_tags($_GET['start']); } else { $start = 0; } if(isset($_GET['order'])) { $orderby = strip_tags($_GET['order']); } else { $orderby = 0; } if($name == "search" && empty($_SESSION['quicksearch'])) { $link = "search_doc_result.php?search=".$what; } else { $link = "search_doc_result.php?search=".$what; $link .= "&search=".$_SESSION['search']; for($i=0;$i"") { $link .="&emetteur=".$_SESSION['emetteur_search']; } if($_SESSION['numcourrier']<>"") { $link .="&numcourrier=".$_SESSION['numcourrier']; } if($_SESSION['numged']<>"") { $link .="&numged=".$_SESSION['numged']; } if($_SESSION['destinataire']<>"") { $link .="&destinataire=".$_SESSION['destinataire']; } if($_SESSION['objet']<>"") { $link .="&objet=".$_SESSION['objet']; } if($_SESSION['type']<>"") { $link .="&type=".$_SESSION['type']; } if($_SESSION['naturesend']<>"") { $link .="&naturesend=".$_SESSION['naturesend']; } if($_SESSION['enr_from']<>"") { $link .="&enr_from=".$_SESSION['enr_from']; } if($_SESSION['enr_to']<>"") { $link .="&enr_to=".$_SESSION['enr_to']; } if($_SESSION['trait_from']<>"") { $link .="&trait_from=".$_SESSION['trait_from']; } if($_SESSION['trait_to']<>"") { $link .="&trait_to=".$_SESSION['trait_to']; } if($_SESSION['status']<>"") { $link .="&status=".$_SESSION['status']; } if($_SESSION['services']<>"") { $link .="&services=".$_SESSION['services']; } $link .= "&imageField.x=19"; $link .= "&imageField.y=18"; } // define the defaults values $nb_show = $_SESSION['config']['nblinetoshow']; $nb_pages = ceil($nb_total/$nb_show); // if they are more 1 page we do pagination with 2 forms if($nb_pages > 1) { $next_start = 0; $page_list1 = '

'; $lastpage = 0; for($i = 0;$i <> $nb_pages; $i++) { $page_name = $i + 1; $the_line = $i + 1; if($start == $next_start) { $page_list1 .= ""; $page_list2 .= ""; } else { $page_list1 .= ""; $page_list2 .= ""; } $next_start = $next_start + $nb_show; $lastpage = $next_start; } $lastpage = $lastpage - $nb_show; $previous = ""; $next = ""; if($start > 0) { $start_prev = $start - $nb_show; $previous = "< "._PREVIOUS." "; } if($start <> $lastpage) { $start_next = $start + $nb_show; $next = " "._NEXT." >"; } $page_list1 = $page_list1."".$previous." ".$next."

"; $page_list2 = $page_list2."".$previous." ".$next."

"; } ?> <? echo _MAIL_SEARCH;?>

>
  <? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?> N° Chrono
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>		 <? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?> <? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>
<? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>		 <? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?> <? echo _DESC_SORT; ?> <? echo _ASC_SORT; ?>  
<? echo _TO_PROCESS;?> <? echo _IN_PROGRESS;?> <? echo _CLOSED;?> <? echo _ONGOING;?> <? echo _ONGOING;?> show($this->thisword($listarr[$theline]['IDENTIFIER'],$what)); ?> show($this->thisword($listarr[$theline]['RES_ID'],$what)); ?> show($this->thisword($listarr[$theline]['AUTHOR'],$what)); ?> show($this->thisword($listarr[$theline]['DEST_USER'],$what)); ?> show($this->thisword($listarr[$theline]['DESCRIPTION'],$what)); ?> dateformat($listarr[$theline]['CUSTOM_D1']); ?> query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$listarr[$theline]['DESTINATION']."'"); $res = $this->fetch_object(); echo $res->SERVICE; ?> "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "PDF") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "TXT") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "WAV") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "AVI" || $listarr[$theline]['FORMAT'] == "MPG" || $listarr[$theline]['FORMAT'] == "MPEG" || $listarr[$theline]['FORMAT'] == "MPE" || $listarr[$theline]['FORMAT'] == "QT" || $listarr[$theline]['FORMAT'] == "MOV") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "JPG" || $listarr[$theline]['FORMAT'] == "JPEG" || $listarr[$theline]['FORMAT'] == "GIF" || $listarr[$theline]['FORMAT'] == "JPE" ) { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "XLS" || $listarr[$theline]['FORMAT'] == "CSV" ) { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "DOC" || $listarr[$theline]['FORMAT'] == "RTF") { echo " "._SHOW_MAIL.""; } elseif($listarr[$theline]['FORMAT'] == "PDFHQ") { echo " "._SHOW_MAIL.""; } else { echo " "; } ?>