57c9c217 |
1 | <?php |
2 | /* |
3 | +--------------------------------------------------------------------+ |
4 | | CiviCRM version 4.6 | |
5 | +--------------------------------------------------------------------+ |
6 | | Copyright CiviCRM LLC (c) 2004-2015 | |
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 |
31 | * @copyright CiviCRM LLC (c) 2004-2015 |
32 | * |
33 | */ |
34 | |
35 | /** |
36 | * This class contains the functions that are called using AJAX (jQuery) |
37 | */ |
38 | class CRM_Custom_Page_AJAX { |
39 | /** |
40 | * Get list of options. |
41 | * |
42 | */ |
43 | public static function getOptionList() { |
44 | $params = $_REQUEST; |
45 | |
57c9c217 |
46 | $sEcho = CRM_Utils_Type::escape($_REQUEST['sEcho'], 'Integer'); |
47 | $offset = isset($_REQUEST['iDisplayStart']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayStart'], 'Integer') : 0; |
48 | $rowCount = isset($_REQUEST['iDisplayLength']) ? CRM_Utils_Type::escape($_REQUEST['iDisplayLength'], 'Integer') : 25; |
57c9c217 |
49 | |
50 | $params['page'] = ($offset / $rowCount) + 1; |
51 | $params['rp'] = $rowCount; |
52 | |
53 | $options = CRM_Core_BAO_CustomOption::getOptionListSelector($params); |
54 | |
55 | $iFilteredTotal = $iTotal = $params['total']; |
56 | $selectorElements = array( |
57 | 'label', |
58 | 'value', |
59 | 'is_default', |
57c9c217 |
60 | 'is_active', |
61 | 'links', |
62 | 'class', |
63 | ); |
64 | |
65 | header('Content-Type: application/json'); |
66 | echo CRM_Utils_JSON::encodeDataTableSelector($options, $sEcho, $iTotal, $iFilteredTotal, $selectorElements); |
67 | CRM_Utils_System::civiExit(); |
68 | } |
69 | |
46227b8d |
70 | /** |
71 | * Fix Ordering of options |
72 | * |
73 | */ |
46227b8d |
74 | public static function fixOrdering() { |
75 | $params = $_REQUEST; |
76 | |
77 | $queryParams = array( |
78 | 1 => array($params['start'], 'Integer'), |
79 | 2 => array($params['end'], 'Integer'), |
80 | 3 => array($params['gid'], 'Integer'), |
81 | ); |
82 | $dao = "SELECT id FROM civicrm_option_value WHERE weight = %1 AND option_group_id = %3"; |
83 | $startid = CRM_Core_DAO::singleValueQuery($dao, $queryParams); |
84 | |
85 | $dao2 = "SELECT id FROM civicrm_option_value WHERE weight = %2 AND option_group_id = %3"; |
86 | $endid = CRM_Core_DAO::singleValueQuery($dao2, $queryParams); |
87 | |
88 | $query = "UPDATE civicrm_option_value SET weight = %2 WHERE id = $startid"; |
89 | CRM_Core_DAO::executeQuery($query, $queryParams); |
90 | |
91 | // increment or decrement the rest by one |
92 | if ($params['start'] < $params['end']) { |
93 | $updateRows = "UPDATE civicrm_option_value |
94 | SET weight = weight - 1 |
95 | WHERE weight > %1 AND weight < %2 AND option_group_id = %3 |
96 | OR id = $endid"; |
97 | } |
98 | else { |
99 | $updateRows = "UPDATE civicrm_option_value |
100 | SET weight = weight + 1 |
101 | WHERE weight < %1 AND weight > %2 AND option_group_id = %3 |
102 | OR id = $endid"; |
103 | } |
104 | CRM_Core_DAO::executeQuery($updateRows, $queryParams); |
c1cd77e2 |
105 | CRM_Utils_JSON::output(TRUE); |
46227b8d |
106 | } |
107 | |
57c9c217 |
108 | } |