function getSuggestedEntries()
{
if (!defined('_ADODB_LAYER')) {
$rs = new KT_Recordset($GLOBALS[$this->config['recordset']]);
} else {
$rs =& $GLOBALS[$this->config['recordset']];
}
$index = 0;
$arr = array();
while (!$rs->EOF && $index < $this->options['numberOfSuggestions']) {
$arr[] = $rs->Fields($this->config['suggestField']);
$index++;
$rs->MoveNext();
}
return array('choices' => $arr);
}
function WDG_JsRecordset($RecordsetName)
{
$rs = $GLOBALS[$RecordsetName];
if (is_resource($rs)) {
$recordset = new KT_Recordset($rs);
} else {
$recordset =& $rs;
}
$nl = "\r\n";
$this->outputString .= <<<EOD
<script>
top.jsRawData_{$RecordsetName} = [
EOD;
$fieldCount = $recordset->FieldCount();
$fieldNames = array();
for ($i = 0; $i < $fieldCount; $i++) {
$meta = $recordset->FetchField($i);
if ($meta) {
$fieldNames[] = $meta->name;
$this->outputString .= ($i == 0 ? '[' : ', ') . '"' . $meta->name . '"';
}
}
$this->outputString .= <<<EOD
],
//data
EOD;
while (!$recordset->EOF) {
$arr = array();
foreach ($fieldNames as $field) {
$arr[] = $recordset->Fields($field);
}
$this->outputString .= WDG_phparray2jsarray($arr) . ', ';
$recordset->MoveNext();
}
$this->outputString .= <<<EOD
[]
];
top.{$RecordsetName} = new JSRecordset('{$RecordsetName}');
</script>
EOD;
//restore old rs position
$recordset->MoveFirst();
}
/**
* Creates a fake recordset array from the current $columns
* This function is called ONLY on error
* @return array associative array with the current values.
* @access protected
*/
function getFakeRsArr()
{
tNG_log::log('tNG' . $this->transactionType, "getFakeRsArr");
$localRs = $this->getLocalRecordset();
if (is_resource($localRs)) {
$localRs = new KT_Recordset($localRs);
}
$fakeArr = array();
$tmpArr = $this->columns;
if (!isset($tmpArr[$this->primaryKey]) && trim($this->primaryKey) != '') {
$tmpArr[$this->primaryKey] = $this->primaryKeyColumn;
}
// Transaction was executed and failed, create the recordset from the submitted values
foreach ($tmpArr as $colName => $colDetails) {
if ($colDetails['method'] == "CURRVAL") {
$value = KT_escapeForSql($localRs->Fields($colName), "STRING_TYPE", true);
} else {
$value = KT_escapeForSql($colDetails['value'], "STRING_TYPE", true);
}
$fakeArr[$colName] = $value;
}
$savedPK = $this->getSavedValue($this->primaryKey);
if (!is_null($savedPK)) {
$fakeArr[$this->pkName] = KT_escapeForSql($savedPK, "STRING_TYPE", true);
} else {
$fakeArr[$this->pkName] = "";
}
return $fakeArr;
}
