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 }
|