Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
7e9e8871 | 4 | | CiviCRM version 4.7 | |
6a488035 | 5 | +--------------------------------------------------------------------+ |
0f03f337 | 6 | | Copyright CiviCRM LLC (c) 2004-2017 | |
6a488035 TO |
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 | +--------------------------------------------------------------------+ | |
d25dd0ee | 26 | */ |
6a488035 TO |
27 | |
28 | /** | |
29 | * | |
30 | * @package CRM | |
0f03f337 | 31 | * @copyright CiviCRM LLC (c) 2004-2017 |
6a488035 TO |
32 | * $Id$ |
33 | * | |
34 | */ | |
35 | ||
36 | /** | |
37 | * Create a page for displaying Custom Options. | |
38 | * | |
39 | * Heart of this class is the run method which checks | |
40 | * for action type and then displays the appropriate | |
41 | * page. | |
42 | * | |
43 | */ | |
44 | class CRM_Custom_Page_Option extends CRM_Core_Page { | |
45 | ||
96f50de2 CW |
46 | public $useLivePageJS = TRUE; |
47 | ||
6a488035 TO |
48 | /** |
49 | * The Group id of the option | |
50 | * | |
51 | * @var int | |
6a488035 TO |
52 | */ |
53 | protected $_gid; | |
54 | ||
55 | /** | |
56 | * The field id of the option | |
57 | * | |
58 | * @var int | |
6a488035 TO |
59 | */ |
60 | protected $_fid; | |
61 | ||
62 | /** | |
63 | * The action links that we need to display for the browse screen | |
64 | * | |
65 | * @var array | |
6a488035 TO |
66 | */ |
67 | private static $_actionLinks; | |
68 | ||
69 | /** | |
70 | * Get the action links for this page. | |
71 | * | |
a6c01b45 CW |
72 | * @return array |
73 | * array of action links that we need to display for the browse screen | |
6a488035 | 74 | */ |
d1424f8f | 75 | public static function &actionLinks() { |
6a488035 TO |
76 | if (!isset(self::$_actionLinks)) { |
77 | self::$_actionLinks = array( | |
78 | CRM_Core_Action::UPDATE => array( | |
79 | 'name' => ts('Edit Option'), | |
80 | 'url' => 'civicrm/admin/custom/group/field/option', | |
81 | 'qs' => 'reset=1&action=update&id=%%id%%&fid=%%fid%%&gid=%%gid%%', | |
82 | 'title' => ts('Edit Multiple Choice Option'), | |
83 | ), | |
84 | CRM_Core_Action::VIEW => array( | |
85 | 'name' => ts('View'), | |
86 | 'url' => 'civicrm/admin/custom/group/field/option', | |
87 | 'qs' => 'action=view&id=%%id%%&fid=%%fid%%', | |
88 | 'title' => ts('View Multiple Choice Option'), | |
89 | ), | |
90 | CRM_Core_Action::DISABLE => array( | |
91 | 'name' => ts('Disable'), | |
4d17a233 | 92 | 'ref' => 'crm-enable-disable', |
6a488035 TO |
93 | 'title' => ts('Disable Mutliple Choice Option'), |
94 | ), | |
95 | CRM_Core_Action::ENABLE => array( | |
96 | 'name' => ts('Enable'), | |
4d17a233 | 97 | 'ref' => 'crm-enable-disable', |
6a488035 TO |
98 | 'title' => ts('Enable Mutliple Choice Option'), |
99 | ), | |
100 | CRM_Core_Action::DELETE => array( | |
101 | 'name' => ts('Delete'), | |
102 | 'url' => 'civicrm/admin/custom/group/field/option', | |
103 | 'qs' => 'action=delete&id=%%id%%&fid=%%fid%%', | |
104 | 'title' => ts('Disable Multiple Choice Option'), | |
105 | ), | |
106 | ); | |
107 | } | |
108 | return self::$_actionLinks; | |
109 | } | |
110 | ||
5d129bb1 | 111 | /** |
112 | * Alphabetize multiple option values | |
113 | * | |
114 | * @return void | |
115 | */ | |
116 | public function alphabetize() { | |
117 | $optionGroupID = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', | |
118 | $this->_fid, | |
119 | 'option_group_id' | |
120 | ); | |
121 | $query = " | |
122 | SELECT id, label | |
123 | FROM civicrm_option_value | |
124 | WHERE option_group_id = %1"; | |
125 | $params = array( | |
126 | 1 => array($optionGroupID, 'Integer'), | |
127 | ); | |
128 | $dao = CRM_Core_DAO::executeQuery($query, $params); | |
129 | $optionValue = array(); | |
130 | while ($dao->fetch()) { | |
131 | $optionValue[$dao->id] = $dao->label; | |
132 | } | |
133 | asort($optionValue, SORT_STRING | SORT_FLAG_CASE | SORT_NATURAL); | |
134 | ||
135 | $i = 1; | |
136 | foreach ($optionValue as $key => $_) { | |
137 | $clause[] = "WHEN $key THEN $i"; | |
138 | $i++; | |
139 | } | |
140 | ||
141 | $when = implode(' ', $clause); | |
142 | $sql = " | |
143 | UPDATE civicrm_option_value | |
144 | SET weight = CASE id | |
145 | $when | |
146 | END | |
147 | WHERE option_group_id = %1"; | |
148 | ||
149 | $dao = CRM_Core_DAO::executeQuery($sql, $params); | |
150 | } | |
151 | ||
6a488035 TO |
152 | /** |
153 | * Browse all custom group fields. | |
154 | * | |
6a488035 | 155 | * @return void |
6a488035 | 156 | */ |
00be9182 | 157 | public function browse() { |
6a488035 TO |
158 | |
159 | // get the option group id | |
160 | $optionGroupID = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', | |
161 | $this->_fid, | |
162 | 'option_group_id' | |
163 | ); | |
164 | ||
165 | $query = " | |
166 | SELECT id, label | |
167 | FROM civicrm_custom_field | |
168 | WHERE option_group_id = %1"; | |
e8646905 | 169 | $params = array( |
353ffa53 | 170 | 1 => array($optionGroupID, 'Integer'), |
6a488035 TO |
171 | 2 => array($this->_fid, 'Integer'), |
172 | ); | |
173 | $dao = CRM_Core_DAO::executeQuery($query, $params); | |
174 | $reusedNames = array(); | |
175 | if ($dao->N > 1) { | |
176 | while ($dao->fetch()) { | |
177 | $reusedNames[] = $dao->label; | |
178 | } | |
179 | $reusedNames = implode(', ', $reusedNames); | |
180 | $newTitle = ts('%1 - Multiple Choice Options', | |
181 | array(1 => $reusedNames) | |
182 | ); | |
183 | CRM_Utils_System::setTitle($newTitle); | |
184 | $this->assign('reusedNames', $reusedNames); | |
185 | } | |
46227b8d | 186 | $this->assign('optionGroupID', $optionGroupID); |
6a488035 TO |
187 | } |
188 | ||
189 | /** | |
100fef9d | 190 | * Edit custom Option. |
6a488035 TO |
191 | * |
192 | * editing would involved modifying existing fields + adding data to new fields. | |
193 | * | |
c4ca4892 TO |
194 | * @param string $action |
195 | * The action to be invoked. | |
6a488035 TO |
196 | * |
197 | * @return void | |
6a488035 | 198 | */ |
00be9182 | 199 | public function edit($action) { |
6a488035 TO |
200 | // create a simple controller for editing custom data |
201 | $controller = new CRM_Core_Controller_Simple('CRM_Custom_Form_Option', ts('Custom Option'), $action); | |
202 | ||
203 | // set the userContext stack | |
204 | $session = CRM_Core_Session::singleton(); | |
205 | $session->pushUserContext(CRM_Utils_System::url('civicrm/admin/custom/group/field/option', | |
353ffa53 TO |
206 | "reset=1&action=browse&fid={$this->_fid}&gid={$this->_gid}" |
207 | )); | |
6a488035 TO |
208 | $controller->setEmbedded(TRUE); |
209 | $controller->process(); | |
210 | $controller->run(); | |
6a488035 TO |
211 | } |
212 | ||
213 | /** | |
214 | * Run the page. | |
215 | * | |
216 | * This method is called after the page is created. It checks for the | |
217 | * type of action and executes that action. | |
218 | * | |
6a488035 | 219 | * @return void |
6a488035 | 220 | */ |
00be9182 | 221 | public function run() { |
6a488035 TO |
222 | |
223 | // get the field id | |
224 | $this->_fid = CRM_Utils_Request::retrieve('fid', 'Positive', | |
225 | $this, FALSE, 0 | |
226 | ); | |
227 | $this->_gid = CRM_Utils_Request::retrieve('gid', 'Positive', | |
228 | $this, FALSE, 0 | |
229 | ); | |
230 | ||
d06700a7 | 231 | if ($isReserved = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $this->_gid, 'is_reserved', 'id')) { |
e89941dc | 232 | CRM_Core_Error::fatal("You cannot add or edit muliple choice options in a reserved custom field-set."); |
d06700a7 RN |
233 | } |
234 | ||
6a488035 | 235 | //as url contain $gid so append breadcrumb dynamically. |
353ffa53 TO |
236 | $breadcrumb = array( |
237 | array( | |
238 | 'title' => ts('Custom Data Fields'), | |
6a488035 | 239 | 'url' => CRM_Utils_System::url('civicrm/admin/custom/group/field', 'reset=1&gid=' . $this->_gid), |
408b79bf | 240 | ), |
353ffa53 | 241 | ); |
6a488035 TO |
242 | CRM_Utils_System::appendBreadCrumb($breadcrumb); |
243 | ||
244 | if ($this->_fid) { | |
245 | $fieldTitle = CRM_Core_BAO_CustomField::getTitle($this->_fid); | |
246 | $this->assign('fid', $this->_fid); | |
247 | $this->assign('gid', $this->_gid); | |
248 | $this->assign('fieldTitle', $fieldTitle); | |
249 | CRM_Utils_System::setTitle(ts('%1 - Multiple Choice Options', array(1 => $fieldTitle))); | |
250 | } | |
251 | ||
252 | // get the requested action | |
253 | $action = CRM_Utils_Request::retrieve('action', 'String', | |
254 | // default to 'browse' | |
255 | $this, FALSE, 'browse' | |
256 | ); | |
257 | ||
258 | // assign vars to templates | |
259 | $this->assign('action', $action); | |
260 | ||
261 | $id = CRM_Utils_Request::retrieve('id', 'Positive', | |
262 | $this, FALSE, 0 | |
263 | ); | |
264 | ||
49217a42 | 265 | // take action in addition to default browse ? |
e8646905 | 266 | if (($action & (CRM_Core_Action::UPDATE | CRM_Core_Action::ADD | |
6a488035 TO |
267 | CRM_Core_Action::VIEW | CRM_Core_Action::DELETE |
268 | ) | |
269 | ) || | |
270 | !empty($_POST) | |
271 | ) { | |
272 | // no browse for edit/update/view | |
273 | $this->edit($action); | |
274 | } | |
1672a5d6 | 275 | elseif ($action & CRM_Core_Action::MAP) { |
5d129bb1 | 276 | $this->alphabetize(); |
277 | } | |
9e5724d5 ME |
278 | $this->browse(); |
279 | ||
6a488035 TO |
280 | // Call the parents run method |
281 | return parent::run(); | |
282 | } | |
96025800 | 283 | |
6a488035 | 284 | } |