annotate core/modules/taxonomy/src/TermStorage.php @ 13:5fb285c0d0e3

Update Drupal core to 8.4.7 via Composer. Security update; I *think* we've been lucky to get away with this so far, as we don't support self-registration which seems to be used by the so-called "drupalgeddon 2" attack that 8.4.5 was vulnerable to.
author Chris Cannam
date Mon, 23 Apr 2018 09:33:26 +0100
parents 4c8ae668cc8c
children 129ea1e6d783
rev   line source
Chris@0 1 <?php
Chris@0 2
Chris@0 3 namespace Drupal\taxonomy;
Chris@0 4
Chris@0 5 use Drupal\Core\Entity\Sql\SqlContentEntityStorage;
Chris@0 6 use Drupal\Core\Entity\EntityInterface;
Chris@0 7
Chris@0 8 /**
Chris@0 9 * Defines a Controller class for taxonomy terms.
Chris@0 10 */
Chris@0 11 class TermStorage extends SqlContentEntityStorage implements TermStorageInterface {
Chris@0 12
Chris@0 13 /**
Chris@0 14 * Array of loaded parents keyed by child term ID.
Chris@0 15 *
Chris@0 16 * @var array
Chris@0 17 */
Chris@0 18 protected $parents = [];
Chris@0 19
Chris@0 20 /**
Chris@0 21 * Array of all loaded term ancestry keyed by ancestor term ID.
Chris@0 22 *
Chris@0 23 * @var array
Chris@0 24 */
Chris@0 25 protected $parentsAll = [];
Chris@0 26
Chris@0 27 /**
Chris@0 28 * Array of child terms keyed by parent term ID.
Chris@0 29 *
Chris@0 30 * @var array
Chris@0 31 */
Chris@0 32 protected $children = [];
Chris@0 33
Chris@0 34 /**
Chris@0 35 * Array of term parents keyed by vocabulary ID and child term ID.
Chris@0 36 *
Chris@0 37 * @var array
Chris@0 38 */
Chris@0 39 protected $treeParents = [];
Chris@0 40
Chris@0 41 /**
Chris@0 42 * Array of term ancestors keyed by vocabulary ID and parent term ID.
Chris@0 43 *
Chris@0 44 * @var array
Chris@0 45 */
Chris@0 46 protected $treeChildren = [];
Chris@0 47
Chris@0 48 /**
Chris@0 49 * Array of terms in a tree keyed by vocabulary ID and term ID.
Chris@0 50 *
Chris@0 51 * @var array
Chris@0 52 */
Chris@0 53 protected $treeTerms = [];
Chris@0 54
Chris@0 55 /**
Chris@0 56 * Array of loaded trees keyed by a cache id matching tree arguments.
Chris@0 57 *
Chris@0 58 * @var array
Chris@0 59 */
Chris@0 60 protected $trees = [];
Chris@0 61
Chris@0 62 /**
Chris@0 63 * {@inheritdoc}
Chris@0 64 *
Chris@0 65 * @param array $values
Chris@0 66 * An array of values to set, keyed by property name. A value for the
Chris@0 67 * vocabulary ID ('vid') is required.
Chris@0 68 */
Chris@0 69 public function create(array $values = []) {
Chris@0 70 // Save new terms with no parents by default.
Chris@0 71 if (empty($values['parent'])) {
Chris@0 72 $values['parent'] = [0];
Chris@0 73 }
Chris@0 74 $entity = parent::create($values);
Chris@0 75 return $entity;
Chris@0 76 }
Chris@0 77
Chris@0 78 /**
Chris@0 79 * {@inheritdoc}
Chris@0 80 */
Chris@0 81 public function resetCache(array $ids = NULL) {
Chris@0 82 drupal_static_reset('taxonomy_term_count_nodes');
Chris@0 83 $this->parents = [];
Chris@0 84 $this->parentsAll = [];
Chris@0 85 $this->children = [];
Chris@0 86 $this->treeChildren = [];
Chris@0 87 $this->treeParents = [];
Chris@0 88 $this->treeTerms = [];
Chris@0 89 $this->trees = [];
Chris@0 90 parent::resetCache($ids);
Chris@0 91 }
Chris@0 92
Chris@0 93 /**
Chris@0 94 * {@inheritdoc}
Chris@0 95 */
Chris@0 96 public function deleteTermHierarchy($tids) {
Chris@0 97 $this->database->delete('taxonomy_term_hierarchy')
Chris@0 98 ->condition('tid', $tids, 'IN')
Chris@0 99 ->execute();
Chris@0 100 }
Chris@0 101
Chris@0 102 /**
Chris@0 103 * {@inheritdoc}
Chris@0 104 */
Chris@0 105 public function updateTermHierarchy(EntityInterface $term) {
Chris@0 106 $query = $this->database->insert('taxonomy_term_hierarchy')
Chris@0 107 ->fields(['tid', 'parent']);
Chris@0 108
Chris@0 109 foreach ($term->parent as $parent) {
Chris@0 110 $query->values([
Chris@0 111 'tid' => $term->id(),
Chris@0 112 'parent' => (int) $parent->target_id,
Chris@0 113 ]);
Chris@0 114 }
Chris@0 115 $query->execute();
Chris@0 116 }
Chris@0 117
Chris@0 118 /**
Chris@0 119 * {@inheritdoc}
Chris@0 120 */
Chris@0 121 public function loadParents($tid) {
Chris@0 122 if (!isset($this->parents[$tid])) {
Chris@0 123 $parents = [];
Chris@0 124 $query = $this->database->select('taxonomy_term_field_data', 't');
Chris@0 125 $query->join('taxonomy_term_hierarchy', 'h', 'h.parent = t.tid');
Chris@0 126 $query->addField('t', 'tid');
Chris@0 127 $query->condition('h.tid', $tid);
Chris@0 128 $query->condition('t.default_langcode', 1);
Chris@0 129 $query->addTag('taxonomy_term_access');
Chris@0 130 $query->orderBy('t.weight');
Chris@0 131 $query->orderBy('t.name');
Chris@0 132 if ($ids = $query->execute()->fetchCol()) {
Chris@0 133 $parents = $this->loadMultiple($ids);
Chris@0 134 }
Chris@0 135 $this->parents[$tid] = $parents;
Chris@0 136 }
Chris@0 137 return $this->parents[$tid];
Chris@0 138 }
Chris@0 139
Chris@0 140 /**
Chris@0 141 * {@inheritdoc}
Chris@0 142 */
Chris@0 143 public function loadAllParents($tid) {
Chris@0 144 if (!isset($this->parentsAll[$tid])) {
Chris@0 145 $parents = [];
Chris@0 146 if ($term = $this->load($tid)) {
Chris@0 147 $parents[$term->id()] = $term;
Chris@0 148 $terms_to_search[] = $term->id();
Chris@0 149
Chris@0 150 while ($tid = array_shift($terms_to_search)) {
Chris@0 151 if ($new_parents = $this->loadParents($tid)) {
Chris@0 152 foreach ($new_parents as $new_parent) {
Chris@0 153 if (!isset($parents[$new_parent->id()])) {
Chris@0 154 $parents[$new_parent->id()] = $new_parent;
Chris@0 155 $terms_to_search[] = $new_parent->id();
Chris@0 156 }
Chris@0 157 }
Chris@0 158 }
Chris@0 159 }
Chris@0 160 }
Chris@0 161
Chris@0 162 $this->parentsAll[$tid] = $parents;
Chris@0 163 }
Chris@0 164 return $this->parentsAll[$tid];
Chris@0 165 }
Chris@0 166
Chris@0 167 /**
Chris@0 168 * {@inheritdoc}
Chris@0 169 */
Chris@0 170 public function loadChildren($tid, $vid = NULL) {
Chris@0 171 if (!isset($this->children[$tid])) {
Chris@0 172 $children = [];
Chris@0 173 $query = $this->database->select('taxonomy_term_field_data', 't');
Chris@0 174 $query->join('taxonomy_term_hierarchy', 'h', 'h.tid = t.tid');
Chris@0 175 $query->addField('t', 'tid');
Chris@0 176 $query->condition('h.parent', $tid);
Chris@0 177 if ($vid) {
Chris@0 178 $query->condition('t.vid', $vid);
Chris@0 179 }
Chris@0 180 $query->condition('t.default_langcode', 1);
Chris@0 181 $query->addTag('taxonomy_term_access');
Chris@0 182 $query->orderBy('t.weight');
Chris@0 183 $query->orderBy('t.name');
Chris@0 184 if ($ids = $query->execute()->fetchCol()) {
Chris@0 185 $children = $this->loadMultiple($ids);
Chris@0 186 }
Chris@0 187 $this->children[$tid] = $children;
Chris@0 188 }
Chris@0 189 return $this->children[$tid];
Chris@0 190 }
Chris@0 191
Chris@0 192 /**
Chris@0 193 * {@inheritdoc}
Chris@0 194 */
Chris@0 195 public function loadTree($vid, $parent = 0, $max_depth = NULL, $load_entities = FALSE) {
Chris@0 196 $cache_key = implode(':', func_get_args());
Chris@0 197 if (!isset($this->trees[$cache_key])) {
Chris@0 198 // We cache trees, so it's not CPU-intensive to call on a term and its
Chris@0 199 // children, too.
Chris@0 200 if (!isset($this->treeChildren[$vid])) {
Chris@0 201 $this->treeChildren[$vid] = [];
Chris@0 202 $this->treeParents[$vid] = [];
Chris@0 203 $this->treeTerms[$vid] = [];
Chris@0 204 $query = $this->database->select('taxonomy_term_field_data', 't');
Chris@0 205 $query->join('taxonomy_term_hierarchy', 'h', 'h.tid = t.tid');
Chris@0 206 $result = $query
Chris@0 207 ->addTag('taxonomy_term_access')
Chris@0 208 ->fields('t')
Chris@0 209 ->fields('h', ['parent'])
Chris@0 210 ->condition('t.vid', $vid)
Chris@0 211 ->condition('t.default_langcode', 1)
Chris@0 212 ->orderBy('t.weight')
Chris@0 213 ->orderBy('t.name')
Chris@0 214 ->execute();
Chris@0 215 foreach ($result as $term) {
Chris@0 216 $this->treeChildren[$vid][$term->parent][] = $term->tid;
Chris@0 217 $this->treeParents[$vid][$term->tid][] = $term->parent;
Chris@0 218 $this->treeTerms[$vid][$term->tid] = $term;
Chris@0 219 }
Chris@0 220 }
Chris@0 221
Chris@0 222 // Load full entities, if necessary. The entity controller statically
Chris@0 223 // caches the results.
Chris@0 224 $term_entities = [];
Chris@0 225 if ($load_entities) {
Chris@0 226 $term_entities = $this->loadMultiple(array_keys($this->treeTerms[$vid]));
Chris@0 227 }
Chris@0 228
Chris@0 229 $max_depth = (!isset($max_depth)) ? count($this->treeChildren[$vid]) : $max_depth;
Chris@0 230 $tree = [];
Chris@0 231
Chris@0 232 // Keeps track of the parents we have to process, the last entry is used
Chris@0 233 // for the next processing step.
Chris@0 234 $process_parents = [];
Chris@0 235 $process_parents[] = $parent;
Chris@0 236
Chris@0 237 // Loops over the parent terms and adds its children to the tree array.
Chris@0 238 // Uses a loop instead of a recursion, because it's more efficient.
Chris@0 239 while (count($process_parents)) {
Chris@0 240 $parent = array_pop($process_parents);
Chris@0 241 // The number of parents determines the current depth.
Chris@0 242 $depth = count($process_parents);
Chris@0 243 if ($max_depth > $depth && !empty($this->treeChildren[$vid][$parent])) {
Chris@0 244 $has_children = FALSE;
Chris@0 245 $child = current($this->treeChildren[$vid][$parent]);
Chris@0 246 do {
Chris@0 247 if (empty($child)) {
Chris@0 248 break;
Chris@0 249 }
Chris@0 250 $term = $load_entities ? $term_entities[$child] : $this->treeTerms[$vid][$child];
Chris@0 251 if (isset($this->treeParents[$vid][$load_entities ? $term->id() : $term->tid])) {
Chris@0 252 // Clone the term so that the depth attribute remains correct
Chris@0 253 // in the event of multiple parents.
Chris@0 254 $term = clone $term;
Chris@0 255 }
Chris@0 256 $term->depth = $depth;
Chris@0 257 unset($term->parent);
Chris@0 258 $tid = $load_entities ? $term->id() : $term->tid;
Chris@0 259 $term->parents = $this->treeParents[$vid][$tid];
Chris@0 260 $tree[] = $term;
Chris@0 261 if (!empty($this->treeChildren[$vid][$tid])) {
Chris@0 262 $has_children = TRUE;
Chris@0 263
Chris@0 264 // We have to continue with this parent later.
Chris@0 265 $process_parents[] = $parent;
Chris@0 266 // Use the current term as parent for the next iteration.
Chris@0 267 $process_parents[] = $tid;
Chris@0 268
Chris@0 269 // Reset pointers for child lists because we step in there more
Chris@0 270 // often with multi parents.
Chris@0 271 reset($this->treeChildren[$vid][$tid]);
Chris@0 272 // Move pointer so that we get the correct term the next time.
Chris@0 273 next($this->treeChildren[$vid][$parent]);
Chris@0 274 break;
Chris@0 275 }
Chris@0 276 } while ($child = next($this->treeChildren[$vid][$parent]));
Chris@0 277
Chris@0 278 if (!$has_children) {
Chris@0 279 // We processed all terms in this hierarchy-level, reset pointer
Chris@0 280 // so that this function works the next time it gets called.
Chris@0 281 reset($this->treeChildren[$vid][$parent]);
Chris@0 282 }
Chris@0 283 }
Chris@0 284 }
Chris@0 285 $this->trees[$cache_key] = $tree;
Chris@0 286 }
Chris@0 287 return $this->trees[$cache_key];
Chris@0 288 }
Chris@0 289
Chris@0 290 /**
Chris@0 291 * {@inheritdoc}
Chris@0 292 */
Chris@0 293 public function nodeCount($vid) {
Chris@0 294 $query = $this->database->select('taxonomy_index', 'ti');
Chris@0 295 $query->addExpression('COUNT(DISTINCT ti.nid)');
Chris@0 296 $query->leftJoin('taxonomy_term_data', 'td', 'ti.tid = td.tid');
Chris@0 297 $query->condition('td.vid', $vid);
Chris@0 298 $query->addTag('vocabulary_node_count');
Chris@0 299 return $query->execute()->fetchField();
Chris@0 300 }
Chris@0 301
Chris@0 302 /**
Chris@0 303 * {@inheritdoc}
Chris@0 304 */
Chris@0 305 public function resetWeights($vid) {
Chris@0 306 $this->database->update('taxonomy_term_field_data')
Chris@0 307 ->fields(['weight' => 0])
Chris@0 308 ->condition('vid', $vid)
Chris@0 309 ->execute();
Chris@0 310 }
Chris@0 311
Chris@0 312 /**
Chris@0 313 * {@inheritdoc}
Chris@0 314 */
Chris@0 315 public function getNodeTerms(array $nids, array $vocabs = [], $langcode = NULL) {
Chris@0 316 $query = db_select('taxonomy_term_field_data', 'td');
Chris@0 317 $query->innerJoin('taxonomy_index', 'tn', 'td.tid = tn.tid');
Chris@0 318 $query->fields('td', ['tid']);
Chris@0 319 $query->addField('tn', 'nid', 'node_nid');
Chris@0 320 $query->orderby('td.weight');
Chris@0 321 $query->orderby('td.name');
Chris@0 322 $query->condition('tn.nid', $nids, 'IN');
Chris@0 323 $query->addTag('taxonomy_term_access');
Chris@0 324 if (!empty($vocabs)) {
Chris@0 325 $query->condition('td.vid', $vocabs, 'IN');
Chris@0 326 }
Chris@0 327 if (!empty($langcode)) {
Chris@0 328 $query->condition('td.langcode', $langcode);
Chris@0 329 }
Chris@0 330
Chris@0 331 $results = [];
Chris@0 332 $all_tids = [];
Chris@0 333 foreach ($query->execute() as $term_record) {
Chris@0 334 $results[$term_record->node_nid][] = $term_record->tid;
Chris@0 335 $all_tids[] = $term_record->tid;
Chris@0 336 }
Chris@0 337
Chris@0 338 $all_terms = $this->loadMultiple($all_tids);
Chris@0 339 $terms = [];
Chris@0 340 foreach ($results as $nid => $tids) {
Chris@0 341 foreach ($tids as $tid) {
Chris@0 342 $terms[$nid][$tid] = $all_terms[$tid];
Chris@0 343 }
Chris@0 344 }
Chris@0 345 return $terms;
Chris@0 346 }
Chris@0 347
Chris@0 348 /**
Chris@0 349 * {@inheritdoc}
Chris@0 350 */
Chris@0 351 public function __sleep() {
Chris@0 352 $vars = parent::__sleep();
Chris@0 353 // Do not serialize static cache.
Chris@0 354 unset($vars['parents'], $vars['parentsAll'], $vars['children'], $vars['treeChildren'], $vars['treeParents'], $vars['treeTerms'], $vars['trees']);
Chris@0 355 return $vars;
Chris@0 356 }
Chris@0 357
Chris@0 358 /**
Chris@0 359 * {@inheritdoc}
Chris@0 360 */
Chris@0 361 public function __wakeup() {
Chris@0 362 parent::__wakeup();
Chris@0 363 // Initialize static caches.
Chris@0 364 $this->parents = [];
Chris@0 365 $this->parentsAll = [];
Chris@0 366 $this->children = [];
Chris@0 367 $this->treeChildren = [];
Chris@0 368 $this->treeParents = [];
Chris@0 369 $this->treeTerms = [];
Chris@0 370 $this->trees = [];
Chris@0 371 }
Chris@0 372
Chris@0 373 }