CRM/Event/Page/AJAX.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | Copyright CiviCRM LLC. All rights reserved.                        |
   5  |                                                                    |
   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  +--------------------------------------------------------------------+
  10  */
  11
  12 /**
  13  *
  14  * @package CRM
  15  * @copyright CiviCRM LLC https://civicrm.org/licensing
  16  * $Id$
  17  *
  18  */
  19
  20 /**
  21  * This class contains all the function that are called using AJAX
  22  */
  23 class CRM_Event_Page_AJAX {
  24
  25   /**
  26    * Building EventFee combo box.
  27    * 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
  28    */
  29   public function eventFee() {
  30     $name = trim(CRM_Utils_Type::escape($_GET['term'], 'String'));
  31
  32     if (!$name) {
  33       $name = '%';
  34     }
  35
  36     $whereClause = "cv.label LIKE '$name%' ";
  37
  38     $query = "SELECT DISTINCT (
  39 cv.label
  40 ), cv.id
  41 FROM civicrm_price_field_value cv
  42 LEFT JOIN civicrm_price_field cf ON cv.price_field_id = cf.id
  43 LEFT JOIN civicrm_price_set_entity ce ON ce.price_set_id = cf.price_set_id
  44 WHERE ce.entity_table = 'civicrm_event' AND {$whereClause}";
  45
  46     $dao = CRM_Core_DAO::executeQuery($query);
  47     $results = [];
  48     while ($dao->fetch()) {
  49       $results[] = ['id' => $dao->id, 'text' => $dao->label];
  50     }
  51     CRM_Utils_JSON::output($results);
  52   }
  53
  54 }