Commit | Line | Data |
---|---|---|
57c9c217 | 1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
7e9e8871 | 4 | | CiviCRM version 4.7 | |
57c9c217 | 5 | +--------------------------------------------------------------------+ |
fa938177 | 6 | | Copyright CiviCRM LLC (c) 2004-2016 | |
57c9c217 | 7 | +--------------------------------------------------------------------+ |
8 | | This file is a part of CiviCRM. | | |
9 | | | | |
10 | | CiviCRM is free software; you can copy, modify, and distribute it | | |
11 | | under the terms of the GNU Affero General Public License | | |
12 | | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
13 | | | | |
14 | | CiviCRM is distributed in the hope that it will be useful, but | | |
15 | | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
16 | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
17 | | See the GNU Affero General Public License for more details. | | |
18 | | | | |
19 | | You should have received a copy of the GNU Affero General Public | | |
20 | | License and the CiviCRM Licensing Exception along | | |
21 | | with this program; if not, contact CiviCRM LLC | | |
22 | | at info[AT]civicrm[DOT]org. If you have questions about the | | |
23 | | GNU Affero General Public License or the licensing of CiviCRM, | | |
24 | | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
25 | +--------------------------------------------------------------------+ | |
26 | */ | |
27 | ||
28 | /** | |
29 | * | |
30 | * @package CRM | |
fa938177 | 31 | * @copyright CiviCRM LLC (c) 2004-2016 |
57c9c217 | 32 | * |
33 | */ | |
34 | ||
35 | /** | |
36 | * This class contains the functions that are called using AJAX (jQuery) | |
37 | */ | |
38 | class CRM_Custom_Page_AJAX { | |
9d311c8f | 39 | |
57c9c217 | 40 | /** |
9d311c8f CW |
41 | * This function uses the deprecated v1 datatable api and needs updating. See CRM-16353. |
42 | * @deprecated | |
57c9c217 | 43 | */ |
44 | public static function getOptionList() { | |
45 | $params = $_REQUEST; | |
46 | ||
57c9c217 | 47 | $sEcho = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer'); |
48 | $offset = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0; | |
49 | $rowCount = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25; | |
57c9c217 | 50 | |
51 | $params['page'] = ($offset / $rowCount) + 1; | |
52 | $params['rp'] = $rowCount; | |
53 | ||
54 | $options = CRM_Core_BAO_CustomOption::getOptionListSelector($params); | |
55 | ||
56 | $iFilteredTotal = $iTotal = $params['total']; | |
57 | $selectorElements = array( | |
58 | 'label', | |
59 | 'value', | |
60 | 'is_default', | |
57c9c217 | 61 | 'is_active', |
62 | 'links', | |
63 | 'class', | |
64 | ); | |
65 | ||
d42a224c | 66 | CRM_Utils_System::setHttpHeader('Content-Type', 'application/json'); |
57c9c217 | 67 | echo CRM_Utils_JSON::encodeDataTableSelector($options, $sEcho, $iTotal, $iFilteredTotal, $selectorElements); |
68 | CRM_Utils_System::civiExit(); | |
69 | } | |
70 | ||
46227b8d | 71 | /** |
72 | * Fix Ordering of options | |
73 | * | |
74 | */ | |
46227b8d | 75 | public static function fixOrdering() { |
76 | $params = $_REQUEST; | |
77 | ||
78 | $queryParams = array( | |
79 | 1 => array($params['start'], 'Integer'), | |
80 | 2 => array($params['end'], 'Integer'), | |
81 | 3 => array($params['gid'], 'Integer'), | |
82 | ); | |
83 | $dao = "SELECT id FROM civicrm_option_value WHERE weight = %1 AND option_group_id = %3"; | |
84 | $startid = CRM_Core_DAO::singleValueQuery($dao, $queryParams); | |
85 | ||
86 | $dao2 = "SELECT id FROM civicrm_option_value WHERE weight = %2 AND option_group_id = %3"; | |
87 | $endid = CRM_Core_DAO::singleValueQuery($dao2, $queryParams); | |
88 | ||
89 | $query = "UPDATE civicrm_option_value SET weight = %2 WHERE id = $startid"; | |
90 | CRM_Core_DAO::executeQuery($query, $queryParams); | |
91 | ||
92 | // increment or decrement the rest by one | |
93 | if ($params['start'] < $params['end']) { | |
94 | $updateRows = "UPDATE civicrm_option_value | |
95 | SET weight = weight - 1 | |
96 | WHERE weight > %1 AND weight < %2 AND option_group_id = %3 | |
97 | OR id = $endid"; | |
98 | } | |
99 | else { | |
100 | $updateRows = "UPDATE civicrm_option_value | |
101 | SET weight = weight + 1 | |
102 | WHERE weight < %1 AND weight > %2 AND option_group_id = %3 | |
103 | OR id = $endid"; | |
104 | } | |
105 | CRM_Core_DAO::executeQuery($updateRows, $queryParams); | |
c1cd77e2 | 106 | CRM_Utils_JSON::output(TRUE); |
46227b8d | 107 | } |
108 | ||
5a2c7bb9 | 109 | /** |
110 | * Get list of Multi Record Fields. | |
111 | * | |
112 | */ | |
113 | public static function getMultiRecordFieldList() { | |
5a2c7bb9 | 114 | |
9c3f979f MM |
115 | $params = CRM_Core_Page_AJAX::defaultSortAndPagerParams(0, 10); |
116 | $params['cid'] = CRM_Utils_Type::escape($_GET['cid'], 'Integer'); | |
117 | $params['cgid'] = CRM_Utils_Type::escape($_GET['cgid'], 'Integer'); | |
5a2c7bb9 | 118 | |
5a2c7bb9 | 119 | $contactType = CRM_Contact_BAO_Contact::getContactType($params['cid']); |
120 | ||
121 | $obj = new CRM_Profile_Page_MultipleRecordFieldsListing(); | |
122 | $obj->_pageViewType = 'customDataView'; | |
123 | $obj->_contactId = $params['cid']; | |
124 | $obj->_customGroupId = $params['cgid']; | |
125 | $obj->_contactType = $contactType; | |
c693f065 | 126 | $obj->_DTparams['offset'] = ($params['page'] - 1) * $params['rp']; |
127 | $obj->_DTparams['rowCount'] = $params['rp']; | |
9c3f979f MM |
128 | if (isset($params['_raw_values']['sort'][0])) { |
129 | // Will this work when CiviCRM is translated, as searching happens on the label column? | |
130 | // I can't find a place where the sort is added, but it should use the name, not the label. | |
131 | $sort = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $params['_raw_values']['sort'][0], 'column_name', 'label'); | |
132 | $obj->_DTparams['sort'] = $sort . ' ' . $params['_raw_values']['order'][0]; | |
c693f065 | 133 | } |
5a2c7bb9 | 134 | |
c693f065 | 135 | list($fields, $attributes) = $obj->browse(); |
5a2c7bb9 | 136 | |
f5eda27f | 137 | // format params and add class attributes |
c693f065 | 138 | $fieldList = array(); |
139 | foreach ($fields as $id => $value) { | |
140 | $field = array(); | |
d51e02d3 | 141 | foreach ($value as $fieldId => &$fieldName) { |
142 | if (!empty($attributes[$fieldId][$id]['class'])) { | |
56a7bb7c | 143 | $fieldName = array('data' => $fieldName, 'cellClass' => $attributes[$fieldId][$id]['class']); |
d51e02d3 | 144 | } |
c693f065 | 145 | if (is_numeric($fieldId)) { |
d51e02d3 | 146 | $fName = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $fieldId, 'label'); |
147 | CRM_Utils_Array::crmReplaceKey($value, $fieldId, $fName); | |
5a2c7bb9 | 148 | } |
149 | } | |
c693f065 | 150 | $field = $value; |
151 | array_push($fieldList, $field); | |
5a2c7bb9 | 152 | } |
f5eda27f | 153 | $totalRecords = !empty($obj->_total) ? $obj->_total : 0; |
5a2c7bb9 | 154 | |
c693f065 | 155 | $multiRecordFields = array(); |
156 | $multiRecordFields['data'] = $fieldList; | |
f5eda27f | 157 | $multiRecordFields['recordsTotal'] = $totalRecords; |
158 | $multiRecordFields['recordsFiltered'] = $totalRecords; | |
5a2c7bb9 | 159 | |
c693f065 | 160 | CRM_Utils_JSON::output($multiRecordFields); |
5a2c7bb9 | 161 | } |
162 | ||
57c9c217 | 163 | } |