nkostadinov / yii2-taxonomy

            $data['object_id'] = $object_id;

            if (!(new Query())->from($this->table)->where($data)->exists(CategoryTerm::getDb())) {

                Yii::$app->db->transaction(function() use ($data, $term, &$result) {

                    CategoryTerm::getDb()->createCommand()->insert($this->table, $data)->execute();

                    $term->updateCounters(['total_count' => 1]);

                    TaxonomyDef::updateAllCounters(['total_count' => 1], ['id' => $this->id]);

                    $result[] = $term;

                });

            }

        }

            $query = new Query();

            if ($query->from($this->table)->where($data)->exists($this->getDb())) {

                Yii::$app->db->transaction(function() use ($data, $term, &$result) {

                    $this->getDb()->createCommand()->delete($this->table, $data)->execute();

                    $term->updateCounters(['total_count' => -1]);

                    Taxonomydef::updateAllCounters(['total_count' => -1], ['id' => $this->id]);

                    $result[] = $term;

                });

            }

        }