_participantIds); $query = " SELECT p.fee_amount as amount, p.register_date as register_date, p.source as source, ct.display_name as display_name FROM civicrm_participant p INNER JOIN civicrm_contact ct ON ( p.contact_id = ct.id ) WHERE p.id IN ( $participantIDs )"; $dao = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray); while ($dao->fetch()) { $rows[] = array( 'display_name' => $dao->display_name, 'amount' => $dao->amount, 'register_date' => CRM_Utils_Date::customFormat($dao->register_date), 'source' => $dao->source, ); } $this->assign('rows', $rows); } /** * Build the form object. * * @return void */ public function buildQuickForm() { $this->addButtons(array( array( 'type' => 'done', 'name' => ts('Done'), 'isDefault' => TRUE, ), ) ); } }