isDirEmpty($path_to_lucene_index)) { $index = Zend_Search_Lucene::open($path_to_lucene_index); $hits = $index->find(urldecode($_REQUEST['fulltext'])); $Liste_Ids = "0"; foreach ($hits as $hit) { if ($cptIds < 500) { $Liste_Ids .= ", '". $hit->Id ."'"; } else { break; } $cptIds ++; } $whereRequest .= ' res_id IN (' . $Liste_Ids . ') and '; } }else { $whereRequest .= " 1=-1 and "; } } if(isset($_REQUEST['subject']) && !empty($_REQUEST['subject'])) { $whereRequest .= " translate( LOWER(subject), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['subject'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) and "; } if(isset($_REQUEST['contact']) && !empty($_REQUEST['contact'])) { $whereRequest .= " exp_contact_id IN (SELECT contact_id FROM contacts WHERE translate( LOWER(society), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['contact'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(lastname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['contact'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(firstname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['contact'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) ) OR dest_contact_id IN (SELECT contact_id FROM contacts WHERE translate( LOWER(society), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['contact'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(lastname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['contact'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(firstname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower($_REQUEST['contact'])."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) ) and "; } $statusObj = new manage_status(); $status = $statusObj->get_not_searchable_status(); $status_str = ''; for ($i=0; $iget_where_clause_from_coll_id( $_SESSION['collection_id_choice'] ); if (trim($whereRequest) <> '') { $whereRequest = '(' . $whereRequest . ') and (' . $whereSecurity . ')'; } $whereRequest = str_replace(" ()", "(1=-1)", $whereRequest); $whereRequest = str_replace("and ()", "", $whereRequest); //echo 'where ' . $whereRequest; include_once('apps/' . $_SESSION['config']['app_id'] . '/smartphone/list_result.php' ); ?>