/** * Override the default "show" dialog. * * @param $dc * * @return string */ public function show($dc) { $arrLanguages = \System::getLanguages(); $objForm = \Database::getInstance()->prepare("\n SELECT l.*, s.title AS form_title, f.title AS master_title, CONCAT(m.firstname, ' ', m.lastname) AS member_name\n FROM tl_lead l\n LEFT OUTER JOIN tl_form s ON l.form_id=s.id\n LEFT OUTER JOIN tl_form f ON l.master_id=f.id\n LEFT OUTER JOIN tl_member m ON l.member_id=m.id\n WHERE l.id=?\n ")->execute($dc->id); $objData = \Database::getInstance()->prepare("\n SELECT d.*, IF(ff.label IS NULL OR ff.label='', d.name, ff.label) AS name\n FROM tl_lead_data d\n LEFT OUTER JOIN tl_form_field ff ON d.master_id=ff.id\n WHERE d.pid=?\n ORDER BY d.sorting\n ")->execute($dc->id); $template = new \BackendTemplate('be_leads_show'); $template->recordId = $dc->id; $template->referer = \System::getReferer(true); $template->subheadline = sprintf($GLOBALS['TL_LANG']['MSC']['showRecord'], 'ID ' . $dc->id); $template->createdLabel = $GLOBALS['TL_LANG']['tl_lead']['created'][0]; $template->createdValue = \Date::parse($GLOBALS['TL_CONFIG']['datimFormat'], $objForm->created); $template->formLabel = $GLOBALS['TL_LANG']['tl_lead']['form_id'][0]; $template->formTitle = $objForm->form_title; $template->formId = $objForm->form_id; $template->isMasterForm = $objForm->master_id == $objForm->form_id; $template->masterLabel = $GLOBALS['TL_LANG']['tl_lead']['master_id'][0]; $template->masterTitle = $objForm->master_title; $template->masterId = $objForm->master_id; $template->languageLabel = $GLOBALS['TL_LANG']['tl_lead']['language'][0]; $template->languageTrans = $arrLanguages[$objForm->language]; $template->languageValue = $objForm->language; $template->hasMember = $objForm->member_id > 0; $template->memberLabel = $GLOBALS['TL_LANG']['tl_lead']['member'][0]; $template->memberName = $objForm->member_name; $template->memberId = $objForm->member_id; $i = 0; $rows = array(); while ($objData->next()) { $rows[] = array('label' => $objData->name, 'value' => \Leads\Leads::formatValue($objData), 'class' => $i % 2 ? 'tl_bg' : ''); ++$i; } $template->data = $rows; return $template->parse(); }
/** * Add an image to each record * @param array * @param string * @return string */ public function listRows($row) { return $row['name'] . ': ' . \Leads\Leads::formatValue((object) $row); }