query_string = $query_string;
}
}
}
function getDropDownDiv($tpl = 'modules/Home/UnifiedSearchAdvanced.tpl') {
global $app_list_strings;
if(!file_exists($GLOBALS['sugar_config']['cache_dir'].'modules/unified_search_modules.php'))
$this->buildCache();
include($GLOBALS['sugar_config']['cache_dir'].'modules/unified_search_modules.php');
global $mod_strings, $modListHeader, $app_list_strings, $current_user, $app_strings, $beanList;
$users_modules = $current_user->getPreference('globalSearch', 'search');
if(!isset($users_modules)) { // preferences are empty, select all
$users_modules = array();
foreach($unified_search_modules as $module=>$data) {
if ( !empty($data['default']) ) {
$users_modules[$module] = $beanList[$module];
}
}
$current_user->setPreference('globalSearch', $users_modules, 0, 'search');
}
$sugar_smarty = new Sugar_Smarty();
$modules_to_search = array();
foreach($unified_search_modules as $module => $data) {
if(ACLController::checkAccess($module, 'list', true)) {
$modules_to_search[$module] = array('translated' => $app_list_strings['moduleList'][$module]);
if(array_key_exists($module, $users_modules)) $modules_to_search[$module]['checked'] = true;
else $modules_to_search[$module]['checked'] = false;
}
}
if(!empty($this->query_string)) $sugar_smarty->assign('query_string', securexss($this->query_string));
else $sugar_smarty->assign('query_string', '');
$sugar_smarty->assign('USE_SEARCH_GIF', 0);
$sugar_smarty->assign('LBL_SEARCH_BUTTON_LABEL', $app_strings['LBL_SEARCH_BUTTON_LABEL']);
$sugar_smarty->assign('MODULES_TO_SEARCH', $modules_to_search);
$sugar_smarty->debugging = true;
return $sugar_smarty->fetch($tpl);
}
function search() {
if(!file_exists($GLOBALS['sugar_config']['cache_dir'].'modules/unified_search_modules.php'))
$this->buildCache();
include $GLOBALS['sugar_config']['cache_dir'].'modules/unified_search_modules.php';
require_once 'include/ListView/ListViewSmarty.php';
global $modListHeader, $beanList, $beanFiles, $current_language, $app_strings, $current_user, $mod_strings;
$home_mod_strings = return_module_language($current_language, 'Home');
$overlib = true;
$this->query_string = $GLOBALS['db']->quote(securexss(from_html(clean_string($this->query_string, 'UNIFIED_SEARCH'))));
if(!empty($_REQUEST['advanced']) && $_REQUEST['advanced'] != 'false') {
$modules_to_search = array();
foreach($_REQUEST as $param => $value) {
if(preg_match('/^search_mod_(.*)$/', $param, $match)) {
$modules_to_search[$match[1]] = $beanList[$match[1]];
}
}
$current_user->setPreference('globalSearch', $modules_to_search, 0, 'search'); // save selections to user preference
}
else {
$users_modules = $current_user->getPreference('globalSearch', 'search');
if(isset($users_modules)) { // use user's previous selections
foreach ( $users_modules as $key => $value ) {
if ( isset($unified_search_modules[$key]) ) {
$modules_to_search[$key] = $value;
}
}
}
else { // select all the modules (ie first time user has used global search)
foreach($unified_search_modules as $module=>$data) {
if ( !empty($data['default']) ) {
$modules_to_search[$module] = $beanList[$module];
}
}
}
$current_user->setPreference('globalSearch', $modules_to_search, 'search');
}
echo $this->getDropDownDiv('modules/Home/UnifiedSearchAdvancedForm.tpl');
$module_results = array();
$module_counts = array();
$has_results = false;
if(!empty($this->query_string)) {
foreach($modules_to_search as $moduleName => $beanName) {
$unifiedSearchFields = array () ;
$innerJoins = array();
foreach ( $unified_search_modules[ $moduleName ]['fields'] as $field=>$def )
{
//bug: 34125 we might want to try to use the LEFT JOIN operator instead of the INNER JOIN in the case we are
//joining against a field that has not been populated.
if(!empty($def['innerjoin']) ){
if (empty($def['db_field']) )
continue;
$innerJoins[$field] = $def;
$def['innerjoin'] = str_replace('INNER', 'LEFT', $def['innerjoin']);
}
$unifiedSearchFields[ $moduleName ] [ $field ] = $def ;
$unifiedSearchFields[ $moduleName ] [ $field ][ 'value' ] = $this->query_string ;
}
/*
* Use searchForm2->generateSearchWhere() to create the search query, as it can generate SQL for the full set of comparisons required
* generateSearchWhere() expects to find the search conditions for a field in the 'value' parameter of the searchFields entry for that field
*/
require_once $beanFiles[$beanName] ;
$seed = new $beanName();
require_once 'include/SearchForm/SearchForm2.php' ;
$searchForm = new SearchForm ( $seed, $moduleName ) ;
$searchForm->setup (array ( $moduleName => array() ) , $unifiedSearchFields , '' , 'saved_views' /* hack to avoid setup doing further unwanted processing */ ) ;
$where_clauses = $searchForm->generateSearchWhere() ;
//add inner joins back into the where clause
$params = array('custom_select' => "");
foreach($innerJoins as $field=>$def) {
if (isset ($def['db_field'])) {
foreach($def['db_field'] as $dbfield)
$where_clauses[] = $dbfield . " LIKE '" . $this->query_string . "%'";
$params['custom_select'] .= ", $dbfield";
$params['distinct'] = true;
//$filterFields[$dbfield] = $dbfield;
}
}
if (count($where_clauses) > 0 )
$where = '(('. implode(' ) OR ( ', $where_clauses) . '))';
$lv = new ListViewSmarty();
$lv->lvd->additionalDetails = false;
$mod_strings = return_module_language($current_language, $seed->module_dir);
if(file_exists('custom/modules/'.$seed->module_dir.'/metadata/listviewdefs.php')){
require_once('custom/modules/'.$seed->module_dir.'/metadata/listviewdefs.php');
}else{
require_once('modules/'.$seed->module_dir.'/metadata/listviewdefs.php');
}
if ( !isset($listViewDefs) || !isset($listViewDefs[$seed->module_dir]) )
continue;
$displayColumns = array();
foreach($listViewDefs[$seed->module_dir] as $colName => $param) {
if(!empty($param['default']) && $param['default'] == true) {
$param['url_sort'] = true;//bug 27933
$displayColumns[$colName] = $param;
}
}
if(count($displayColumns) > 0) $lv->displayColumns = $displayColumns;
else $lv->displayColumns = $listViewDefs[$seed->module_dir];
$lv->export = false;
$lv->mergeduplicates = false;
$lv->multiSelect = false;
$lv->delete = false;
$lv->select = false;
$lv->showMassupdateFields = false;
if($overlib) {
$lv->overlib = true;
$overlib = false;
}
else $lv->overlib = false;
$lv->setup($seed, 'include/ListView/ListViewGeneric.tpl', $where, $params, 0, 10);
$module_results[$moduleName] = '
' . get_form_header($GLOBALS['app_list_strings']['moduleList'][$seed->module_dir] . ' (' . $lv->data['pageData']['offsets']['total'] . ')', '', false);
$module_counts[$moduleName] = $lv->data['pageData']['offsets']['total'];
if($lv->data['pageData']['offsets']['total'] == 0) {
$module_results[$moduleName] .= '