Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
bc77d7c0 | 4 | | Copyright CiviCRM LLC. All rights reserved. | |
6a488035 | 5 | | | |
bc77d7c0 TO |
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 | | |
6a488035 | 9 | +--------------------------------------------------------------------+ |
d25dd0ee | 10 | */ |
6a488035 TO |
11 | |
12 | /** | |
13 | * | |
14 | * @package CRM | |
ca5cec67 | 15 | * @copyright CiviCRM LLC https://civicrm.org/licensing |
6a488035 TO |
16 | */ |
17 | ||
18 | /** | |
19 | * This class contains all the function that are called using AJAX | |
20 | */ | |
21 | class CRM_Event_Page_AJAX { | |
22 | ||
6a488035 | 23 | /** |
fe482240 | 24 | * Building EventFee combo box. |
93793e86 | 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 |
6a488035 | 26 | */ |
00be9182 | 27 | public function eventFee() { |
93793e86 | 28 | $name = trim(CRM_Utils_Type::escape($_GET['term'], 'String')); |
6a488035 TO |
29 | |
30 | if (!$name) { | |
31 | $name = '%'; | |
32 | } | |
33 | ||
34 | $whereClause = "cv.label LIKE '$name%' "; | |
03e04002 | 35 | |
6a488035 TO |
36 | $query = "SELECT DISTINCT ( |
37 | cv.label | |
38 | ), cv.id | |
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 | |
0ee5581e | 42 | WHERE ce.entity_table = 'civicrm_event' AND {$whereClause}"; |
43 | ||
6a488035 | 44 | $dao = CRM_Core_DAO::executeQuery($query); |
be2fb01f | 45 | $results = []; |
6a488035 | 46 | while ($dao->fetch()) { |
be2fb01f | 47 | $results[] = ['id' => $dao->id, 'text' => $dao->label]; |
6a488035 | 48 | } |
ecdef330 | 49 | CRM_Utils_JSON::output($results); |
6a488035 | 50 | } |
96025800 | 51 | |
6a488035 | 52 | } |