From 74558a7b32913f417602e1518d493254d4070a74 Mon Sep 17 00:00:00 2001 From: Brian Shaughnessy Date: Mon, 8 Dec 2014 20:13:47 -0500 Subject: [PATCH] CRM-15698 participant report price level query --- CRM/Report/Form/Event/ParticipantListing.php | 16 ++++++++++------ 1 file changed, 10 insertions(+), 6 deletions(-) diff --git a/CRM/Report/Form/Event/ParticipantListing.php b/CRM/Report/Form/Event/ParticipantListing.php index db21cd9335..0bfc131170 100644 --- a/CRM/Report/Form/Event/ParticipantListing.php +++ b/CRM/Report/Form/Event/ParticipantListing.php @@ -410,12 +410,16 @@ class CRM_Report_Form_Event_ParticipantListing extends CRM_Report_Form_Event { */ function getPriceLevels() { $query = " -SELECT DISTINCT cv.label, cv.id -FROM civicrm_price_field_value cv -LEFT JOIN civicrm_price_field cf ON cv.price_field_id = cf.id -LEFT JOIN civicrm_price_set_entity ce ON ce.price_set_id = cf.price_set_id -WHERE ce.entity_table = 'civicrm_event' -GROUP BY cv.label +SELECT CONCAT(cv.label, ' (', ps.title, ')') label, cv.id +FROM civicrm_price_field_value cv +LEFT JOIN civicrm_price_field cf + ON cv.price_field_id = cf.id +LEFT JOIN civicrm_price_set_entity ce + ON ce.price_set_id = cf.price_set_id +LEFT JOIN civicrm_price_set ps + ON ce.price_set_id = ps.id +WHERE ce.entity_table = 'civicrm_event' +ORDER BY cv.label "; $dao = CRM_Core_DAO::executeQuery($query); $elements = array(); -- 2.25.1