3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
15 * @copyright CiviCRM LLC https://civicrm.org/licensing
19 * This class contains all the function that are called using AJAX
21 class CRM_Event_Page_AJAX
{
24 * Building EventFee combo box.
25 * FIXME: This ajax callback could be eliminated in favor of an entityRef field but the priceFieldValue api doesn't currently support filtering on entity_table
27 public function eventFee() {
28 $name = trim(CRM_Utils_Type
::escape($_GET['term'], 'String'));
34 $whereClause = "cv.label LIKE '$name%' ";
36 $query = "SELECT DISTINCT (
39 FROM civicrm_price_field_value cv
40 LEFT JOIN civicrm_price_field cf ON cv.price_field_id = cf.id
41 LEFT JOIN civicrm_price_set_entity ce ON ce.price_set_id = cf.price_set_id
42 WHERE ce.entity_table = 'civicrm_event' AND {$whereClause}";
44 $dao = CRM_Core_DAO
::executeQuery($query);
46 while ($dao->fetch()) {
47 $results[] = ['id' => $dao->id
, 'text' => $dao->label
];
49 CRM_Utils_JSON
::output($results);