CBIConnectorSqlBuilder::SetSelect

public function SetSelect($selectedFields, $options = [])
{
	global $DB;

	$this->select = [];
	foreach ($selectedFields as $fieldName => $fieldInfo)
	{
		if ($fieldInfo['FIELD_TYPE'] === 'datetime' && isset($options['datetime_format']))
		{
			$this->select[] = 'date_format(' . $fieldInfo['FIELD_NAME'] . ','' . $DB->forSql($options['datetime_format']) . '') AS ' . $fieldName;
		}
		elseif ($fieldInfo['FIELD_TYPE'] === 'date' && isset($options['date_format']))
		{
			$this->select[] = 'date_format(' . $fieldInfo['FIELD_NAME'] . ','' . $DB->forSql($options['date_format']) . '') AS ' . $fieldName;
		}
		else
		{
			$this->select[] = $fieldInfo['FIELD_NAME'] . ' AS ' . $fieldName;
		}

		if (!isset($this->c_joins[$fieldName]))
		{
			$this->c_joins[$fieldName] = 1;
		}
		else
		{
			$this->c_joins[$fieldName]++;
		}

		if (isset($fieldInfo['TABLE_ALIAS']))
		{
			if (!isset($this->l_joins[$fieldInfo['TABLE_ALIAS']]))
			{
				$this->l_joins[$fieldInfo['TABLE_ALIAS']] = 1;
			}
			else
			{
				$this->l_joins[$fieldInfo['TABLE_ALIAS']]++;
			}
		}
	}
}