3 namespace Drupal\permissions_by_term\Service;
5 use Drupal\Core\Database\Connection;
10 * @package Drupal\permissions_by_term\Service
15 * The database connection.
24 * @param Connection $database
26 public function __construct(
29 $this->database = $database;
37 public function getTidsByNid($nid) {
38 $query = $this->database->select('taxonomy_index', 'ti')
39 ->fields('ti', ['tid'])
40 ->condition('ti.nid', $nid);
42 return $query->execute()
51 public function getNidsByTids($tids) {
53 $query = $this->database->select('taxonomy_index', 'ti')
54 ->fields('ti', ['nid'])
55 ->condition('ti.tid', $tids, 'IN');
57 $nids = $query->execute()
60 return array_unique($nids);
68 * @param string $sTermName
72 public function getTermIdByName($sTermName) {
73 $aTermId = \Drupal::entityQuery('taxonomy_term')
74 ->condition('name', $sTermName)
84 public function getTermNameById($term_id) {
85 $term_name = \Drupal::entityQuery('taxonomy_term')
86 ->condition('id', $term_id)
88 return key($term_name);