/**
* @param Renderer $renderer
* @return void
*/
public function Render(Renderer $renderer)
{
/** @var string $term */
$term = '';
if ($this->GetSuperGlobals()->IsGetValueSet('term')) {
$term = $this->GetSuperGlobals()->GetGetValue('term');
}
if (!StringUtils::IsNullOrEmpty($term)) {
$this->dataset->AddFieldFilter($this->valueField, new FieldFilter('%' . $term . '%', 'ILIKE', true));
}
$id = null;
if ($this->GetSuperGlobals()->IsGetValueSet('id')) {
$id = $this->GetSuperGlobals()->GetGetValue('id');
}
if (!StringUtils::IsNullOrEmpty($id)) {
$this->dataset->AddFieldFilter($this->idField, FieldFilter::Equals($id));
}
header('Content-Type: text/html; charset=utf-8');
$this->dataset->Open();
$result = array();
$valueCount = 0;
while ($this->dataset->Next()) {
$result[] = array("id" => $this->dataset->GetFieldValueByName($this->idField), "value" => StringUtils::IsNullOrEmpty($this->captionTemplate) ? $this->dataset->GetFieldValueByName($this->valueField) : DatasetUtils::FormatDatasetFieldsTemplate($this->dataset, $this->captionTemplate));
if (++$valueCount >= 20) {
break;
}
}
echo SystemUtils::ToJSON($result);
$this->dataset->Close();
}
/**
* @param Renderer $renderer
* @return void
*/
public function Render(Renderer $renderer)
{
if (GetApplication()->GetSuperGlobals()->IsGetValueSet('term')) {
$this->dataset->AddFieldFilter($this->valueField, new FieldFilter('%' . GetApplication()->GetSuperGlobals()->GetGetValue('term') . '%', 'ILIKE', true));
}
$this->dataset->Open();
$result = array();
$highLightCallback = Delegate::CreateFromMethod($this, 'ApplyHighlight')->Bind(array(Argument::$Arg3 => $this->valueField, Argument::$Arg4 => GetApplication()->GetSuperGlobals()->GetGetValue('term')));
$this->dataset->SetLimit(20);
while ($this->dataset->Next()) {
$result[] = array("id" => $this->dataset->GetFieldValueByName($this->idField), "label" => $highLightCallback->Call($this->dataset->GetFieldValueByName($this->valueField), $this->valueField), "value" => $this->dataset->GetFieldValueByName($this->valueField));
}
echo SystemUtils::ToJSON($result);
$this->dataset->Close();
}
private function RetrieveMasterDatasetValues()
{
$hasForeignKeyValues = true;
for ($i = 0; $i < count($this->masterKeyFields); $i++) {
if (GetApplication()->GetSuperGlobals()->IsGetValueSet('fk' . $i)) {
$this->masterDataset->AddFieldFilter($this->masterKeyFields[$i], new FieldFilter($_GET['fk' . $i], '='));
} else {
$hasForeignKeyValues = false;
}
}
if ($hasForeignKeyValues) {
$this->masterDataset->Open();
if ($this->masterDataset->Next()) {
for ($i = 0; $i < count($this->parentMasterKeyFields); $i++) {
$this->parentMasterKeyValues[] = $this->masterDataset->GetFieldValueByName($this->parentMasterKeyFields[$i]);
}
}
$this->masterDataset->Close();
}
}
/**
* @param Renderer $renderer
* @return void
*/
public function Render(Renderer $renderer)
{
$params = ArrayWrapper::createGetWrapper();
$term = $params->isValueSet('term') ? $params->getValue('term') : '';
if ($params->isValueSet('term')) {
$this->dataset->AddFieldFilter($this->valueField, new FieldFilter('%' . $term . '%', 'ILIKE', true));
}
if ($params->isValueSet('id')) {
$this->dataset->AddFieldFilter($this->idField, FieldFilter::Equals($params->getValue('id')));
}
if ($this->itemCount > 0) {
$this->dataset->SetUpLimit(0);
$this->dataset->SetLimit($this->itemCount);
}
$this->dataset->Open();
$result = array();
$highLightCallback = Delegate::CreateFromMethod($this, 'ApplyHighlight')->Bind(array(Argument::$Arg3 => $this->valueField, Argument::$Arg4 => $term));
while ($this->dataset->Next()) {
$result[] = array("id" => $this->dataset->GetFieldValueByName($this->idField), "label" => $highLightCallback->Call($this->dataset->GetFieldValueByName($this->valueField), $this->valueField), "value" => $this->dataset->GetFieldValueByName($this->valueField));
}
echo SystemUtils::ToJSON($result);
$this->dataset->Close();
}
public function SetControlValuesFromDataset()
{
if (GetOperation() == OPERATION_EDIT || GetOperation() == OPERATION_AJAX_REQUERT_INLINE_EDIT) {
$this->GetEditControl()->SetDisplayValue($this->GetDisplayValueFromDataset());
} elseif (GetOperation() == OPERATION_COPY) {
$this->GetEditControl()->SetDisplayValue($this->GetDisplayValueFromDataset());
/* $masterFieldValue = $this->dataset->GetMasterFieldValueByName($this->fieldName);
if (isset($masterFieldValue))
$this->editControl->SetValue($masterFieldValue); */
} elseif (GetOperation() == OPERATION_INSERT || GetOperation() == OPERATION_AJAX_REQUERT_INLINE_INSERT) {
$insertDefaultValue = $this->GetInsertDefaultValue();
if (isset($insertDefaultValue)) {
$this->lookupDataset->AddFieldFilter($this->lookupIdFieldName, new FieldFilter($insertDefaultValue, '='));
$this->lookupDataset->Open();
if ($this->lookupDataset->Next()) {
$displayValue = $this->lookupDataset->GetFieldValueByName($this->lookupDisplayFieldName);
$this->GetEditControl()->SetDisplayValue($displayValue);
}
$this->lookupDataset->Close();
}
}
parent::SetControlValuesFromDataset();
}
/**
* @param Renderer $renderer
* @return void
*/
public function Render(Renderer $renderer)
{
/** @var string $term */
$term = '';
if ($this->GetSuperGlobals()->IsGetValueSet('term')) {
$term = $this->GetSuperGlobals()->GetGetValue('term');
}
if (!StringUtils::IsNullOrEmpty($term)) {
$this->dataset->AddFieldFilter($this->valueField, new FieldFilter('%' . $term . '%', 'ILIKE', true));
}
header('Content-Type: text/html; charset=utf-8');
$this->dataset->Open();
$result = array();
$valueCount = 0;
$highLightCallback = Delegate::CreateFromMethod($this, 'ApplyHighlight')->Bind(array(Argument::$Arg3 => $this->valueField, Argument::$Arg4 => $term));
while ($this->dataset->Next()) {
$result[] = array("id" => $this->dataset->GetFieldValueByName($this->idField), "value" => StringUtils::IsNullOrEmpty($this->captionTemplate) ? $this->dataset->GetFieldValueByName($this->valueField) : DatasetUtils::FormatDatasetFieldsTemplate($this->dataset, $this->captionTemplate, $highLightCallback));
if ($valueCount >= 20) {
break;
}
}
echo SystemUtils::ToJSON($result);
$this->dataset->Close();
}