/** * Add the description field to the buildQuery select statement * * @param JQuery &$query BuildQuery * @param array $data BuildQuery data * * @return void */ protected function buildQueryDescription(&$query, $data) { $params = $this->getParams(); $desc = $params->get('join_desc_column', ''); if ($desc !== '') { $db = FabrikWorker::getDbo(); $w = new FabrikWorker(); $data = is_array($data) ? $data : array(); $desc = $w->parseMessageForPlaceHolder($desc, $data, false); $desc = FabrikString::isConcat($desc) ? $desc : $db->quoteName($desc); $desc = "REPLACE(" . $desc . ", '\n', '<br />')"; $query->select($desc . ' AS description'); } }