Viewing file:  searchsuggest.php (5.54 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
@ini_set("display_errors","1");
@ini_set("display_startup_errors","1");
require_once("include/dbcommon.php");
require_once getabspath('classes/searchclause.php');
add_nocache_headers();
$shortTable = postvalue("table");
$table = GetTableByShort( $shortTable );
if( !$table )
exit(0);
$page = postvalue('page');
$pageType = postvalue('pageType');
if ( !$pageType )
$pageType = PAGE_LIST;
$searchField = postvalue('searchField');
if( $searchField )
{
if( !Security::userHasFieldPermissions( $table, $searchField, $pageType, $page, true ) )
return;
}
$searchFor = trim( postvalue('searchFor') );
// if nothing to search
if($searchFor == '')
{
echo printJSON( array('success' => true, 'result' => '') );
return;
}
require_once getabspath('classes/controls/EditControlsContainer.php');
$searchOpt = postvalue("start") ? "Starts with" : "Contains";
$searchField = GoodFieldName( $searchField );
$numberOfSuggests = GetGlobalData("searchSuggestsNumber", 10);
$whereClauses = array();
$forLookupPage = postvalue('forLookup');
$forDashboardSimpleSearch = !$searchField && $pageType == PAGE_DASHBOARD ;
if( $forDashboardSimpleSearch )
{
$dashSettings = new ProjectSettings( $table, PAGE_DASHBOARD, $page );
$dashGoogleLikeFields = $dashSettings->getGoogleLikeFields();
$dashSearchFields = $dashSettings->getDashboardSearchFields();
$sfdata = array();
// group fields by table
foreach( $dashGoogleLikeFields as $g )
{
foreach( $dashSearchFields[ $g ] as $j => $data )
{
$sfdata[ $data['table'] ][] = $data['field'];
}
}
foreach( $sfdata as $table => $fields )
{
if ( $numberOfSuggests <= count( $result ) )
break;
if ( !count( $result ) )
$result = array();
$_result = getListOfSuggests( $fields, $table, $whereClauses, $numberOfSuggests - count( $result ) , $searchOpt, $searchFor );
// add only distinct values
foreach( $_result as $_data )
{
$found = false;
foreach( $result as $data )
{
if( $data['realValue'] == $_data['realValue'] )
{
$found = true;
break;
}
}
if( !$found )
$result[] = $_data;
}
}
echo printJSON( array( 'success' => true, 'result' => $result ) );
exit();
}
if( $pageType == PAGE_DASHBOARD )
{
$dashSettings = new ProjectSettings( $table, PAGE_DASHBOARD, $page );
$dashSearchFields = $dashSettings->getDashboardSearchFields();
$sfData = $dashSearchFields[ $searchField ][0];
$searchField = $sfData['field'];
$table = $sfData['table'];
foreach( $dashSettings->getDashboardElements() as $elem )
{
if( $elem['table'] == $table )
{
$pageType = PAGE_LIST;
if ( $elem['type'] == DASHBOARD_CHART )
$pageType = PAGE_CHART;
else if( $elem['type'] == DASHBOARD_REPORT )
$pageType = PAGE_REPORT;
break;
}
}
}
$pSetList = new ProjectSettings( $table, $pageType, $page );
if( $searchField == "" ) {
$allSearchFields = $pSetList->getGoogleLikeFields();
}
else {
// array of fields which were added in wizard for search
$allSearchFields = $pSetList->getAllPageFields();
}
$pSet = new ProjectSettings( $table, PAGE_SEARCH, $page );
$cipherer = new RunnerCipherer( $table );
$_connection = $cman->byTable( $table );
$masterTable = postvalue("mastertable");
$detailKeys = array();
if( $masterTable != "" )
{
$masterKetsReq = RunnerPage::readMasterKeysFromRequest();
$detailKeys = $pSet->getDetailKeysByMasterTable( $masterTable );
for($j = 0; $j < count($detailKeys); $j++)
{
$mastervalue = $cipherer->MakeDBValue($detailKeys[$j], $masterKetsReq[ $j + 1 ], "", true);
if( $mastervalue == "null" )
$masterWhere .= RunnerPage::_getFieldSQL($detailKeys[$j], $_connection, $pSet)." is NULL ";
else
$masterWhere .= RunnerPage::_getFieldSQLDecrypt($detailKeys[$j], $_connection, $pSet, $cipherer)."=".$mastervalue;
$whereClauses[] = $masterWhere;
}
}
$searchClauseObj = SearchClause::getSearchObject( $table, "", $table, $cipherer );
//$searchClauseObj->processFiltersWhere( $_connection );
foreach( $searchClauseObj->getFilteredFields() as $filteredField )
{
$whereClauses[] = $filteredField["where"];
}
$parentCtrlsData = my_json_decode( postvalue('parentCtrlsData') );
if( $forLookupPage && count( $parentCtrlsData ) )
{
$mainField = postvalue("mainField");
$mainTable = postvalue("mainTable");
$mainPageType = postvalue("mainPageType");
$mainPSet = new ProjectSettings( $mainTable, $mainPageType );
global $cman;
$conn = $cman->byTable( $table );
$parentWhereParts = array();
foreach( $mainPSet->getParentFieldsData( $mainField ) as $cData )
{
if( !isset( $parentCtrlsData[ $cData["main"] ] ) )
continue;
$parentFieldName = $cData["lookup"];
$parentFieldValues = splitvalues( $parentCtrlsData[ $cData["main"] ] );
$arWhereClause = array();
foreach($parentFieldValues as $value)
{
$lookupValue = $cipherer->MakeDBValue($parentFieldName, $value);
$arWhereClause[] = RunnerPage::_getFieldSQLDecrypt( $parentFieldName, $conn, $pSet, $cipherer ) . "=" . $lookupValue;
}
if( count($arWhereClause) )
$parentWhereParts[] = "(".implode(" OR ", $arWhereClause).")";
}
$whereClauses[] = "(".implode(" AND ", $parentWhereParts).")";
}
$result = getListOfSuggests( $allSearchFields, $table, $whereClauses, $numberOfSuggests, $searchOpt, $searchFor, $searchField, $detailKeys );
$returnJSON = array();
$returnJSON['success'] = true;
$returnJSON['result'] = $result;
echo printJSON($returnJSON);
exit();
?>
|