public function getSelectClauseColumnSQL()
{
$columns = array();
$moduleFields = $this->getModuleFields();
$accessibleFieldList = array_keys($moduleFields);
$accessibleFieldList[] = 'id';
$this->fields = array_intersect($this->fields, $accessibleFieldList);
foreach ($this->fields as $field) {
$sql = $this->getSQLColumn($field);
$columns[] = $sql;
//To merge date and time fields
if ($this->meta->getEntityName() == 'Calendar' && ($field == 'date_start' || $field == 'due_date')) {
if ($field == 'date_start') {
$timeField = 'time_start';
$sql = $this->getSQLColumn($timeField);
} else {
if ($field == 'due_date') {
$timeField = 'time_end';
$sql = $this->getSQLColumn($timeField);
}
}
$columns[] = $sql;
}
}
foreach ($this->columnsCustom as $columnsCustom) {
$columns[] = $columnsCustom;
}
$this->columns = implode(', ', $columns);
return $this->columns;
}
public function getSelectClauseColumnSQL()
{
$columns = array();
$moduleFields = $this->getModuleFields();
$accessibleFieldList = array_keys($moduleFields);
$accessibleFieldList[] = 'id';
if ($this->referenceFieldInfoList) {
// Adding support for reference module fields
$accessibleFieldList = array_merge($this->referenceFieldNameList, $accessibleFieldList);
}
$this->fields = array_intersect($this->fields, $accessibleFieldList);
foreach ($this->fields as $field) {
$sql = $this->getSQLColumn($field);
$columns[] = $sql;
//To merge date and time fields
if ($this->meta->getEntityName() == 'Calendar' && ($field == 'date_start' || $field == 'due_date' || $field == 'taskstatus' || $field == 'eventstatus')) {
if ($field == 'date_start') {
$timeField = 'time_start';
$sql = $this->getSQLColumn($timeField);
} else {
if ($field == 'due_date') {
$timeField = 'time_end';
$sql = $this->getSQLColumn($timeField);
} else {
if ($field == 'taskstatus' || $field == 'eventstatus') {
//In calendar list view, Status value = Planned is not displaying
$sql = "CASE WHEN (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE vtiger_activity.eventstatus END AS ";
if ($field == 'taskstatus') {
$sql .= "status";
} else {
$sql .= $field;
}
}
}
}
$columns[] = $sql;
}
}
$this->columns = implode(', ', $columns);
return $this->columns;
}
