$tmpCollection) { $path_to_lucene_index = $tmpCollection['path_to_lucene_index']; if (is_dir($path_to_lucene_index)) { if (!functions::isDirEmpty($path_to_lucene_index)) { $index = Zend_Search_Lucene::open($path_to_lucene_index); $hits = $index->find(urldecode($_REQUEST['fulltext'])); $Liste_Ids = "0"; $cptIds = 0; foreach ($hits as $hit) { if ($cptIds < 500) { $Liste_Ids .= ", '" . $hit->Id . "'"; } else { break; } $cptIds++; } $whereRequest .= ' res_id IN (' . $Liste_Ids . ') and '; if ($key == 0) $where_request .= ' ('; $where_request .= " res_id IN ($Liste_Ids) "; if (empty($_SESSION['collections'][$key + 1])) $where_request .= ') and '; else $where_request .= ' or '; }else { if ($key == 0) $where_request .= ' ('; $where_request .= " 1=-1 "; if (empty($_SESSION['collections'][$key + 1])) $where_request .= ') and '; else $where_request .= ' or '; } }else { if ($key == 0) $where_request .= ' ('; $where_request .= " 1=-1 "; if (empty($_SESSION['collections'][$key + 1])) $where_request .= ') and '; else $where_request .= ' or '; } } } if(isset($_REQUEST['subject']) && !empty($_REQUEST['subject'])) { $whereRequest .= " translate( LOWER(subject), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_REQUEST['subject']))."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) and "; } if(isset($_REQUEST['contact']) && !empty($_REQUEST['contact'])) { $whereRequest .= " exp_contact_id IN (SELECT contact_id FROM contacts_v2 WHERE translate( LOWER(society), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_REQUEST['contact']))."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(lastname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_REQUEST['contact']))."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(firstname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_REQUEST['contact']))."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) ) OR dest_contact_id IN (SELECT contact_id FROM contacts_v2 WHERE translate( LOWER(society), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_REQUEST['contact']))."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(lastname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_REQUEST['contact']))."%', 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) OR translate( LOWER(firstname), 'âãäåÁÂÃÄÅèééêëÈÉÉÊËìíîïìÌÍÎÏÌóôõöÒÓÔÕÖùúûüÙÚÛÜ', 'aaaaAAAAAeeeeeEEEEEiiiiiIIIIIooooOOOOOuuuuUUUU' ) like translate( '%".strtolower(functions::xssafe($_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' ); ?>