function WRGetFieldsList($table)
{
if (is_wr_project()) {
$pSet = new ProjectSettings($table);
return $pSet->getFieldsList();
}
if (is_wr_db()) {
global $wr_is_standalone;
if (!$wr_is_standalone) {
global $dal;
if ($dal->Table($table)) {
return $dal->GetFieldsList($table);
}
}
return dbinfoFieldsList($table);
}
if (is_wr_custom()) {
$res = array();
$sql = $_SESSION["object_sql"];
//The default connection is temporary used #9875
$connection = getDefaultConnection();
$arr = $connection->getFieldsList($sql);
foreach ($arr as $val) {
$res[] = $val["fieldname"];
}
return $res;
}
}
$lookupCategory = !$isExistParent ? array() : splitvalues($category);
// if suggest for dashboard search
if ($gSettings->getNType() == DASHBOARD_SEARCH) {
$dashFields = $gSettings->getDashboardSearchFields();
$table = GoodFieldName($dashFields[$field][0]["table"]);
$strTableName = GetTableByShort($table);
$field = GoodFieldName($dashFields[$field][0]["field"]);
if (!checkTableName($table)) {
exit(0);
}
require_once "include/" . $table . "_variables.php";
$cipherer = new RunnerCipherer($strTableName);
$gSettings = new ProjectSettings($strTableName, $pageType);
}
$hasWhere = false;
$fieldsArr = $gSettings->getFieldsList();
$lwLinkField = '';
$lookupField = '';
$lwDisplayField = '';
$lookupConnection = $cman->getDefault();
foreach ($fieldsArr as $f) {
$fEditFormat = $gSettings->getEditFormat($f);
if ($fEditFormat != EDIT_FORMAT_LOOKUP_WIZARD || GoodFieldName($f) != $field) {
continue;
}
$lookupField = $f;
$LookupType = $gSettings->getLookupType($f);
if ($LookupType == LT_LOOKUPTABLE || $LookupType == LT_QUERY) {
$lookupTable = $gSettings->getLookupTable($f);
if ($LookupType == LT_QUERY) {
$lookupConnection = $cman->byTable($lookupTable);
function WRGetFieldsList($table)
{
if(is_wr_project()){
$pSet = new ProjectSettings($table);
return $pSet->getFieldsList();
}
if(is_wr_db())
{
global $wr_is_standalone;
if(!$wr_is_standalone)
{
global $dal;
if($dal->Table($table))
return $dal->GetFieldsList($table);
}
return dbinfoFieldsList($table);
}
if(is_wr_custom())
{
global $conn;
$arr=array();
$sql="";
$res=array();
// $rs=db_query("select * from ".AddTableWrappers("webreport_sql")." where ".AddFieldWrappers("sqlname")."='".$table."'",$conn);
// if($data = db_fetch_array($rs))
// $sql=$data["sqlcontent"];
$sql=$_SESSION["object_sql"];
$arr=db_getfieldslist($sql);
foreach($arr as $val)
$res[]=$val["fieldname"];
return $res;
}
}
