/**
* Generate report FROM clause.
*/
public function from() {
parent::from();
if ($this->isTableSelected('civicrm_contribution')) {
$this->_from .= "
LEFT JOIN civicrm_participant_payment pp
ON ({$this->_aliases['civicrm_participant']}.id = pp.participant_id)
LEFT JOIN civicrm_contribution {$this->_aliases['civicrm_contribution']}
ON (pp.contribution_id = {$this->_aliases['civicrm_contribution']}.id)
";
}
if ($this->isTableSelected('civicrm_line_item')) {
$this->_from .= "
LEFT JOIN civicrm_line_item line_item_civireport
ON line_item_civireport.entity_table = 'civicrm_participant'
AND line_item_civireport.entity_id = {$this->_aliases['civicrm_participant']}.id
";
}
}
