CRM/Custom/Page/Option.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.7                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2017                                |
   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-2017
  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
  46   public $useLivePageJS = TRUE;
  47
  48   /**
  49    * The Group id of the option
  50    *
  51    * @var int
  52    */
  53   protected $_gid;
  54
  55   /**
  56    * The field id of the option
  57    *
  58    * @var int
  59    */
  60   protected $_fid;
  61
  62   /**
  63    * The action links that we need to display for the browse screen
  64    *
  65    * @var array
  66    */
  67   private static $_actionLinks;
  68
  69   /**
  70    * Get the action links for this page.
  71    *
  72    * @return array
  73    *   array of action links that we need to display for the browse screen
  74    */
  75   public static function &actionLinks() {
  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'),
  92           'ref' => 'crm-enable-disable',
  93           'title' => ts('Disable Mutliple Choice Option'),
  94         ),
  95         CRM_Core_Action::ENABLE => array(
  96           'name' => ts('Enable'),
  97           'ref' => 'crm-enable-disable',
  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
 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
 152   /**
 153    * Browse all custom group fields.
 154    *
 155    * @return void
 156    */
 157   public function browse() {
 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";
 169     $params = array(
 170       1 => array($optionGroupID, 'Integer'),
 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     }
 186     $this->assign('optionGroupID', $optionGroupID);
 187   }
 188
 189   /**
 190    * Edit custom Option.
 191    *
 192    * editing would involved modifying existing fields + adding data to new fields.
 193    *
 194    * @param string $action
 195    *   The action to be invoked.
 196    *
 197    * @return void
 198    */
 199   public function edit($action) {
 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',
 206       "reset=1&action=browse&fid={$this->_fid}&gid={$this->_gid}"
 207     ));
 208     $controller->setEmbedded(TRUE);
 209     $controller->process();
 210     $controller->run();
 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    *
 219    * @return void
 220    */
 221   public function run() {
 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
 231     if ($isReserved = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $this->_gid, 'is_reserved', 'id')) {
 232       CRM_Core_Error::fatal("You cannot add or edit muliple choice options in a reserved custom field-set.");
 233     }
 234
 235     //as url contain $gid so append breadcrumb dynamically.
 236     $breadcrumb = array(
 237       array(
 238         'title' => ts('Custom Data Fields'),
 239         'url' => CRM_Utils_System::url('civicrm/admin/custom/group/field', 'reset=1&gid=' . $this->_gid),
 240       ),
 241     );
 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
 265     // take action in addition to default browse ?
 266     if (($action & (CRM_Core_Action::UPDATE | CRM_Core_Action::ADD |
 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     }
 275     elseif ($action & CRM_Core_Action::MAP) {
 276       $this->alphabetize();
 277     }
 278     $this->browse();
 279
 280     // Call the parents run method
 281     return parent::run();
 282   }
 283
 284 }