Merge pull request #9587 from colemanw/CRM-19802
[civicrm-core.git] / CRM / Core / Form / Tag.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 */
33
34 /**
35 * This class generates form element for free tag widget.
36 */
37 class CRM_Core_Form_Tag {
38 public $_entityTagValues;
39
40 /**
41 * Build tag widget if correct parent is passed
42 *
43 * @param CRM_Core_Form $form
44 * Form object.
45 * @param string $parentNames
46 * Parent name ( tag name).
47 * @param string $entityTable
48 * Entitytable 'eg: civicrm_contact'.
49 * @param int $entityId
50 * Entityid 'eg: contact id'.
51 * @param bool $skipTagCreate
52 * True if tag need be created using ajax.
53 * @param bool $skipEntityAction
54 * True if need to add entry in entry table via ajax.
55 * @param string $tagsetElementName
56 * If you need to create tagsetlist with specific name.
57 */
58 public static function buildQuickForm(
59 &$form, $parentNames, $entityTable, $entityId = NULL, $skipTagCreate = FALSE,
60 $skipEntityAction = FALSE, $tagsetElementName = NULL) {
61 $tagset = $form->_entityTagValues = array();
62 $form->assign("isTagset", FALSE);
63 $mode = NULL;
64
65 foreach ($parentNames as &$parentNameItem) {
66 // get the parent id for tag list input for keyword
67 $parentId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_Tag', $parentNameItem, 'id', 'name');
68
69 // check if parent exists
70 if ($parentId) {
71 $tagsetItem = $tagsetElementName . 'parentId_' . $parentId;
72 $tagset[$tagsetItem]['parentID'] = $parentId;
73
74 list(, $mode) = explode('_', $entityTable);
75 if (!$tagsetElementName) {
76 $tagsetElementName = $mode . "_taglist";
77 }
78 $tagset[$tagsetItem]['tagsetElementName'] = $tagsetElementName;
79
80 $form->addEntityRef("{$tagsetElementName}[{$parentId}]", $parentNameItem, array(
81 'entity' => 'tag',
82 'multiple' => TRUE,
83 'create' => !$skipTagCreate,
84 'api' => array('params' => array('parent_id' => $parentId)),
85 'data-entity_table' => $entityTable,
86 'data-entity_id' => $entityId,
87 'class' => "crm-$mode-tagset",
88 ));
89
90 if ($entityId) {
91 $tagset[$tagsetItem]['entityId'] = $entityId;
92 $entityTags = CRM_Core_BAO_EntityTag::getChildEntityTags($parentId, $entityId, $entityTable);
93 if ($entityTags) {
94 $form->setDefaults(array("{$tagsetElementName}[{$parentId}]" => implode(',', array_keys($entityTags))));
95 }
96 }
97 else {
98 $skipEntityAction = TRUE;
99 }
100 $tagset[$tagsetItem]['skipEntityAction'] = $skipEntityAction;
101 }
102 }
103
104 if (!empty($tagset)) {
105 // assign current tagsets which is used in postProcess
106 $form->_tagsetInfo = $tagset;
107 $form->assign("tagsetType", $mode);
108 // Merge this tagset info with possibly existing info in the template
109 $tagsetInfo = (array) $form->get_template_vars("tagsetInfo");
110 if (empty($tagsetInfo[$mode])) {
111 $tagsetInfo[$mode] = array();
112 }
113 $tagsetInfo[$mode] = array_merge($tagsetInfo[$mode], $tagset);
114 $form->assign("tagsetInfo", $tagsetInfo);
115 $form->assign("isTagset", TRUE);
116 }
117 }
118
119 /**
120 * Save entity tags when it is not save used AJAX.
121 *
122 * @param array $params
123 * @param int $entityId
124 * Entity id, eg: contact id, activity id, case id, file id.
125 * @param string $entityTable
126 * Entity table.
127 * @param CRM_Core_Form $form
128 * Form object.
129 */
130 public static function postProcess(&$params, $entityId, $entityTable = 'civicrm_contact', &$form = NULL) {
131 if ($form && !empty($form->_entityTagValues)) {
132 $existingTags = $form->_entityTagValues;
133 }
134 else {
135 $existingTags = CRM_Core_BAO_EntityTag::getTag($entityId, $entityTable);
136 }
137
138 if ($form) {
139 // if the key is missing from the form response then all the tags were deleted / cleared
140 // in that case we create empty tagset params so that below logic works and tagset are
141 // deleted correctly
142 foreach ($form->_tagsetInfo as $tagsetName => $tagsetInfo) {
143 $tagsetId = explode('parentId_', $tagsetName);
144 $tagsetId = $tagsetId[1];
145 if (empty($params[$tagsetId])) {
146 $params[$tagsetId] = '';
147 }
148 }
149 }
150
151 // when form is submitted with tagset values below logic will work and in the case when all tags in a tagset
152 // are deleted we will have to set $params[tagset id] = '' which is done by above logic
153 foreach ($params as $parentId => $value) {
154 $newTagIds = array();
155 $tagIds = array();
156
157 if ($value) {
158 $tagIds = explode(',', $value);
159 foreach ($tagIds as $tagId) {
160 if ($form && $form->_action != CRM_Core_Action::UPDATE || !array_key_exists($tagId, $existingTags)) {
161 $newTagIds[] = $tagId;
162 }
163 }
164 }
165
166 // Any existing entity tags from this tagset missing from the $params should be deleted
167 $deleteSQL = "DELETE FROM civicrm_entity_tag
168 USING civicrm_entity_tag, civicrm_tag
169 WHERE civicrm_tag.id=civicrm_entity_tag.tag_id
170 AND civicrm_entity_tag.entity_table='{$entityTable}'
171 AND entity_id={$entityId} AND parent_id={$parentId}";
172 if (!empty($tagIds)) {
173 $deleteSQL .= " AND tag_id NOT IN (" . implode(', ', $tagIds) . ");";
174 }
175
176 CRM_Core_DAO::executeQuery($deleteSQL);
177
178 if (!empty($newTagIds)) {
179 // New tag ids can be inserted directly into the db table.
180 $insertValues = array();
181 foreach ($newTagIds as $tagId) {
182 $insertValues[] = "( {$tagId}, {$entityId}, '{$entityTable}' ) ";
183 }
184 $insertSQL = 'INSERT INTO civicrm_entity_tag ( tag_id, entity_id, entity_table )
185 VALUES ' . implode(', ', $insertValues) . ';';
186 CRM_Core_DAO::executeQuery($insertSQL);
187 }
188 }
189 }
190
191 }