function SimpleResults($table, $fields = '', $where = '')
{
// Two fields
$queryParams = array('fields' => $fields, 'from' => $table, 'where' => $where);
$query = new Query($queryParams);
return $query->GetSimpleArray();
}
function AdminOldViewController()
{
$queryArray = array('fields' => array('id', 'modified'), 'from' => $this->nestedModule->name, 'where' => array('current != true', array('id = ' . $this->nestedModule->itemID, 'master = ' . $this->nestedModule->itemID)), 'orderby' => 'modified DESC');
$query = new Query($queryArray);
$versions = $query->GetSimpleArray();
foreach ($versions as $id => $timestamp) {
$date = new Date($timestamp);
$dateString = $date->SmartDate() . ' ' . $date->Time();
$paths[$id] = a('admin/' . $this->nestedModule->name . '?a=revert&revertid=' . $id, $dateString);
}
$this->nestedModule->view['paths'] = $paths;
}
function GetRelatedArray($field)
{
if ($relatedModule = $this->schema[$field]['relatedModule']) {
$relatedModuleConfig = Module::ParseConfigFile($relatedModule, 'config/config.ini', true);
// Look for keyQuery.ini
if ($relatedQueryParams = Module::ParseConfigFile($relatedModule, 'config/keyQuery.ini', true)) {
// Fetch array using specified query
$relatedQuery = new Query($relatedQueryParams);
} else {
if (!($keyField = $relatedModuleConfig['keyField'])) {
// If no key field was specified in config file, use first field
$relatedModuleSchema = Module::ParseConfigFile($relatedModule, 'config/schema.ini', true);
reset($relatedModuleSchema);
$keyField = key($relatedModuleSchema);
}
// If we do find a key field, build query according to that
if ($keyField) {
$params = array();
if ($relatedModuleConfig['keepVersions']) {
$params['fields']['id'] = 'IF(master IS NULL, id, master)';
} else {
$params['fields']['id'] = 'id';
}
$params['fields'][] = $keyField;
$relatedQuery = new Query($params);
}
}
// If we successfuly built a query, fetch data
if ($relatedQuery) {
$relatedQuery->AddFrom($relatedModule);
// Manage versions
if ($relatedModuleConfig['keepVersions']) {
$relatedQuery->AddWhere($relatedModule . '.current = TRUE');
}
return $relatedQuery->GetSimpleArray();
}
} elseif ($relatedArray = $this->schema[$field]['relatedArray']) {
// Array is specified in a config file
$relatedArrays = IniFile::Parse($this->modulePath . 'config/relatedArrays.ini', true);
$relatedData = $relatedArrays[$relatedArray];
// Look for localized strings
foreach ($relatedData as $key => $label) {
if ($string = $this->strings[$relatedArray][$label]) {
$relatedData[$key] = $string;
}
}
return $relatedData;
} else {
return false;
}
}
