Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. public function from() {
  2. $this->_from = "
  3. FROM civicrm_participant {$this->_aliases['civicrm_participant']}
  4. LEFT JOIN civicrm_relationship contact_a_relation
  5. ON (participant_civireport.contact_id = contact_a_relation.contact_id_b )
  6. LEFT JOIN civicrm_relationship contact_b_relation
  7. ON (participant_civireport.contact_id = contact_b_relation.contact_id_a )
  8. LEFT JOIN civicrm_event {$this->_aliases['civicrm_event']}
  9. ON ({$this->_aliases['civicrm_event']}.id = {$this->_aliases['civicrm_participant']}.event_id ) AND
  10. {$this->_aliases['civicrm_event']}.is_template = 0
  11. LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact']}
  12. ON ({$this->_aliases['civicrm_participant']}.contact_id = {$this->_aliases['civicrm_contact']}.id )
  13. {$this->_aclFrom}
  14. LEFT JOIN civicrm_address {$this->_aliases['civicrm_address']}
  15. ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_address']}.contact_id AND
  16. {$this->_aliases['civicrm_address']}.is_primary = 1
  17. LEFT JOIN civicrm_email {$this->_aliases['civicrm_email']}
  18. ON ({$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_email']}.contact_id AND
  19. {$this->_aliases['civicrm_email']}.is_primary = 1)
  20. LEFT JOIN civicrm_phone {$this->_aliases['civicrm_phone']}
  21. ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_phone']}.contact_id AND
  22. {$this->_aliases['civicrm_phone']}.is_primary = 1
  23. ";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement