diff --git a/application/modules/default/models/ActivityLog.php b/application/modules/default/models/ActivityLog.php
index cc4547ce8..156cee7b4 100644
--- a/application/modules/default/models/ActivityLog.php
+++ b/application/modules/default/models/ActivityLog.php
@@ -1,231 +1,233 @@
 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  **/
 class Default_Model_ActivityLog extends Default_Model_DbTable_ActivityLog
 {
 
     const PROJECT_CREATED = 0;
     const PROJECT_UPDATED = 1;
     const PROJECT_DELETED = 2;
     const PROJECT_STOPPED = 3;
     const PROJECT_STARTED = 4;
     const PROJECT_EDITED = 7;
     const PROJECT_PUBLISHED = 8;
     const PROJECT_UNPUBLISHED = 9;
     const PROJECT_ITEM_CREATED = 10;
     const PROJECT_ITEM_UPDATED = 11;
     const PROJECT_ITEM_DELETED = 12;
     const PROJECT_ITEM_STOPPED = 13;
     const PROJECT_ITEM_STARTED = 14;
     const PROJECT_ITEM_EDITED = 17;
     const PROJECT_ITEM_PUBLISHED = 18;
     const PROJECT_ITEM_UNPUBLISHED = 19;
     const PROJECT_PLINGED = 20;
     const PROJECT_DISPLINGED = 21;
     const PROJECT_ITEM_PLINGED = 30;
     const PROJECT_ITEM_DISPLINGED = 31;
     const PROJECT_COMMENT_CREATED = 40;
     const PROJECT_COMMENT_UPDATED = 41;
     const PROJECT_COMMENT_DELETED = 42;
     const PROJECT_COMMENT_REPLY = 43;
     const PROJECT_FOLLOWED = 50;
     const PROJECT_UNFOLLOWED = 51;
     const PROJECT_SHARED = 52;
     const PROJECT_PLINGED_2 = 53;
     const PROJECT_DISPLINGED_2 = 54;
     const PROJECT_RATED_HIGHER = 60;
     const PROJECT_RATED_LOWER = 61;
     const PROJECT_FILES_CREATED = 200;
     const PROJECT_FILES_UPDATED = 210;
     const PROJECT_FILES_DELETED = 220;
     const PROJECT_LICENSE_CHANGED = 70;
     const MEMBER_JOINED = 100;
     const MEMBER_UPDATED = 101;
     const MEMBER_DELETED = 102;
     const MEMBER_EDITED = 107;
     const MEMBER_FOLLOWED = 150;
     const MEMBER_UNFOLLOWED = 151;
     const MEMBER_SHARED = 152;
 
     const BACKEND_LOGIN = 302;
     const BACKEND_LOGOUT = 304;
     const BACKEND_PROJECT_DELETE = 310;
     const BACKEND_PROJECT_FEATURE = 312;
     const BACKEND_PROJECT_GHNS_EXCLUDED = 314;
     const BACKEND_PROJECT_CAT_CHANGE = 316;
     const BACKEND_PROJECT_PLING_EXCLUDED = 318;
     const BACKEND_USER_PLING_EXCLUDED = 319;
     const BACKEND_USER_DELETE = 320;
     const BACKEND_USER_UNDELETE = 321;
+    const BACKEND_PROJECT_DANGEROUS = 322;
 
     //internal system logs
     const MEMBER_EMAIL_CONFIRMED = 401;
     const MEMBER_EMAIL_CHANGED = 402;
     const MEMBER_PAYPAL_CHANGED = 410;
 
 
     protected static $referenceType = array(
         0   => 'project',
         1   => 'project',
         2   => 'project',
         3   => 'project',
         4   => 'project',
         7   => 'project',
         8   => 'project',
         9   => 'project',
         10  => 'update',
         11  => 'update',
         12  => 'update',
         13  => 'update',
         14  => 'update',
         17  => 'update',
         18  => 'update',
         19  => 'update',
         20  => 'pling',
         30  => 'pling',
         40  => 'comment',
         41  => 'comment',
         42  => 'comment',
         43  => 'comment',
         50  => 'project',
         51  => 'project',
         52  => 'project',
         53  => 'project',
         54  => 'project',
         60  => 'project',
         61  => 'project',
         70  => 'project',
         100 => 'member',
         101 => 'member',
         102 => 'member',
         104 => 'undefined',
         107 => 'member',
         108 => 'undefined',
         109 => 'undefined',
         150 => 'member',
         151 => 'member',
         152 => 'member',
         200 => 'project',
         210 => 'project',
         220 => 'project',
         302 => 'backend',
         304 => 'backend',
         310 => 'backend',
         312 => 'backend',
         314 => 'backend',
         316 => 'backend',
         318 => 'backend',
         319 => 'backend',
         320 => 'backend',
         321 => 'backend',
+        322 => 'backend',
         401 => 'member',
         402 => 'member_email',
         410 => 'member'
     );
 
     /**
      * @param int   $objectId
      * @param int   $projectId
      * @param int   $userId
      * @param int   $activity_type_id
      * @param array $data array with ([type_id], [pid], description, title, image_small)
      *
      * @throws Zend_Exception
      */
     public static function logActivity($objectId, $projectId, $userId, $activity_type_id, $data = array())
     {
         // cutting description text if necessary
         if (isset($data['description'])) {
             $object_text = (strlen($data['description']) < 150)
                 ? $data['description'] : mb_substr($data['description'], 0, 145, 'UTF-8') . ' ... ';
         }
 
         $newEntry = array(
             'member_id'     => $userId,
             'project_id'    => $projectId,
             'object_id'     => $objectId,
             'object_ref'    => self::$referenceType[$activity_type_id],
             'object_title'  => isset($data['title']) ? $data['title'] : null,
             'object_text'   => isset($object_text) ? $object_text : null,
             'object_img'    => false === empty($data['image_small']) ? $data['image_small'] : null,
             'activity_type' => $activity_type_id
         );
 
         $sql = "
             INSERT INTO `activity_log`
             SET `member_id` = :member_id, 
                 `project_id` = :project_id, 
                 `object_id` = :object_id, 
                 `object_ref` = :object_ref,
                 `object_title` = :object_title,
                 `object_text` = :object_text,
                 `object_img` = :object_img,
                 `activity_type_id` = :activity_type
                 ;
         ";
 
         try {
             Zend_Db_Table::getDefaultAdapter()->query($sql, $newEntry);
         } catch (Exception $e) {
             Zend_Registry::get('logger')->err(__METHOD__ . ' - ERROR write activity log - ' . print_r($e, true));
         }
     }
 
 
     /**
      * @param int         $objectId
      * @param int         $userId
      * @param int         $activity_type_id
      * @param array|mixed $data
      *
      * @throws Zend_Exception
      */
     public function writeActivityLog($objectId, $userId, $activity_type_id, $data)
     {
         $projectId = $objectId;
 
         //is it an item?
         if (isset($data['type_id']) && $data['type_id'] == Default_Model_Project::PROJECT_TYPE_UPDATE) {
             $projectId = $data['pid'];
         }
         $object_text =
             (strlen($data['description']) < 150) ? $data['description'] : mb_substr($data['description'], 0, 145, 'UTF-8') . ' ... ';
 
         $newLog = array(
             'member_id'        => $userId,
             'project_id'       => $projectId,
             'object_id'        => $objectId,
             'object_ref'       => self::$referenceType[$activity_type_id],
             'object_title'     => $data['title'],
             'object_text'      => $object_text,
             'object_img'       => $data['image_small'],
             'activity_type_id' => $activity_type_id
         );
 
         try {
             $this->insert($newLog);
         } catch (Exception $e) {
             Zend_Registry::get('logger')->err(__METHOD__ . ' - ERROR write activity log - ' . print_r($e, true));
         }
     }
 
 }
diff --git a/application/modules/default/models/Tags.php b/application/modules/default/models/Tags.php
index 0dcdecc27..0b670d647 100644
--- a/application/modules/default/models/Tags.php
+++ b/application/modules/default/models/Tags.php
@@ -1,1350 +1,1371 @@
 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  *
  * Created: 11.09.2017
  */
 class Default_Model_Tags
 {
     const TAG_TYPE_PROJECT = 1;
     const TAG_TYPE_MEMBER = 2;
     const TAG_TYPE_FILE = 3;
     const TAG_TYPE_OSUSER = 9;
 
 
     const TAG_USER_GROUPID = 5;
     const TAG_CATEGORY_GROUPID = 6;
 
     const TAG_LICENSE_GROUPID = 7;
     const TAG_PACKAGETYPE_GROUPID = 8;
     const TAG_ARCHITECTURE_GROUPID = 9;
     const TAG_GHNS_EXCLUDED_GROUPID = 10;
 
     const TAG_PRODUCT_ORIGINAL_GROUPID = 11;
     const TAG_PRODUCT_ORIGINAL_ID = 2451;
    
     const TAG_PRODUCT_EBOOK_GROUPID = 14;
     const TAG_PRODUCT_EBOOK_AUTHOR_GROUPID = 15;
     const TAG_PRODUCT_EBOOK_EDITOR_GROUPID = 16;
     const TAG_PRODUCT_EBOOK_ILLUSTRATOR_GROUPID = 17;
     const TAG_PRODUCT_EBOOK_TRANSLATOR_GROUPID = 18;
     const TAG_PRODUCT_EBOOK_SUBJECT_GROUPID = 19;
     const TAG_PRODUCT_EBOOK_SHELF_GROUPID = 20;
     const TAG_PRODUCT_EBOOK_LANGUAGE_GROUPID = 21;
     const TAG_PRODUCT_EBOOK_TYPE_GROUPID = 22;
 
 
     const TAG_PRODUCT_EBOOK_ID = 2532;
 
     const TAG_PROJECT_GROUP_IDS = '6,7,10';//type product : category-tags, license-tags,ghns_excluded
     const TAG_FILE_GROUP_IDS = '8,9';//file-packagetype-tags,file-architecture-tags
     // $tag_project_group_ids ='6,7,10';  
     // $tag_file_group_ids ='8,9';  
 
     /**
      * Default_Model_Tags constructor.
      */
     public function __construct()
     {
 
     }
 
     /**
      * @param int    $object_id
      * @param string $tags
      * @param int    $tag_type
      */
     public function processTags($object_id, $tags, $tag_type)
     {
         $this->assignTags($object_id, $tags, $tag_type);
         $this->deassignTags($object_id, $tags, $tag_type);
     }
 
 
     /**
      * @param int    $object_id
      * @param string $tags
      * @param int    $tag_type
      */
     public function assignTags($object_id, $tags, $tag_type)
     {
         $new_tags = array_diff(explode(',', $tags), explode(',', $this->getTags($object_id, $tag_type)));
 
 
         $tableTags = new Default_Model_DbTable_Tags();
         $listIds = $tableTags->storeTags(implode(',', $new_tags));
 
         $prepared_insert =
             array_map(function ($id) use ($object_id, $tag_type) {
                 return "({$id}, {$tag_type}, {$object_id})";
             },
                 $listIds);
         $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id) VALUES " . implode(',',
                 $prepared_insert);
 
 
         $this->getAdapter()->query($sql);
     }
 
 
     /**
      * @param int $object_id
      * @param int $tag_type
      *
      * @return string|null
      */
     public function getTags($object_id, $tag_type)
     {
         $sql = "
             SELECT GROUP_CONCAT(`tag`.`tag_name`) AS `tag_names` 
             FROM `tag_object`
             JOIN `tag` ON `tag`.`tag_id` = `tag_object`.`tag_id`
             JOIN `tag_group_item` ON `tag_object`.`tag_id` = `tag_group_item`.`tag_id`
             WHERE `tag_type_id` = :type AND `tag_object_id` = :object_id
             AND `tag_group_item`.`tag_group_id` <> :tag_user_groupid
             AND `tag_object`.`is_deleted` = 0
             GROUP BY `tag_object`.`tag_object_id`
         ";
 
         $result = $this->getAdapter()->fetchRow($sql, array(
             'type'             => $tag_type,
             'object_id'        => $object_id,
             'tag_user_groupid' => Default_Model_Tags::TAG_USER_GROUPID
         ));
         if (isset($result['tag_names'])) {
             return $result['tag_names'];
         }
 
         return null;
     }
 
     /**
      * @return Zend_Db_Adapter_Abstract
      */
     private function getAdapter()
     {
         return Zend_Db_Table::getDefaultAdapter();
     }
 
     /**
      * @param int    $object_id
      * @param string $tags
      * @param int    $tag_type
      */
     public function deassignTags($object_id, $tags, $tag_type)
     {
         $removable_tags = array_diff(explode(',', $this->getTags($object_id, $tag_type)), explode(',', $tags));
 
         //$sql = "DELETE tag_object FROM tag_object JOIN tag ON tag.tag_id = tag_object.tag_id WHERE tag.tag_name = :name and tag_object.tag_object_id=:object_id";
         $sql = "UPDATE `tag_object` INNER JOIN `tag` ON `tag`.`tag_id` = `tag_object`.`tag_id`  SET `tag_changed` = NOW() , `is_deleted` = 1 WHERE `tag`.`tag_name` = :name AND `tag_object`.`tag_object_id`=:object_id";
         $this->getAdapter()->query($sql, array('tagObjectId' => $object_id, 'tagType' => $tag_type));
 
         foreach ($removable_tags as $removable_tag) {
             $this->getAdapter()->query($sql, array('name' => $removable_tag, 'object_id' => $object_id));
         }
         $this->updateChanged($object_id, $tag_type);
     }
 
     private function updateChanged($object_id, $tag_type)
     {
         $sql = "UPDATE `tag_object` SET `tag_changed` = NOW() WHERE `tag_object_id` = :tagObjectId AND `tag_type_id` = :tagType";
         $this->getAdapter()->query($sql, array('tagObjectId' => $object_id, 'tagType' => $tag_type));
     }
 
     /**
      * @param int    $project_id
      * @param string $tagname
      * @return string|null
      */
     public function isTagsUserExisting($project_id, $tagname)
     {
         $sql_object = "SELECT count(1) AS `cnt` FROM `tag_object` JOIN `tag` ON `tag`.`tag_id` = `tag_object`.`tag_id` WHERE `tag`.`tag_name` = :tagname AND `tag_object`.`tag_group_id`=:tag_group_id AND `tag_object`.`is_deleted`=0 AND `tag_object`.`tag_object_id`=:project_id AND `tag_object`.`tag_type_id`=:tag_type_id";
         $r = $this->getAdapter()->fetchRow($sql_object, array(
             'tagname'      => $tagname
         ,
             'tag_group_id' => Default_Model_Tags::TAG_USER_GROUPID
         ,
             'project_id'   => $project_id
         ,
             'tag_type_id'  => Default_Model_Tags::TAG_TYPE_PROJECT
         ));
         if ($r['cnt'] == 0) {
             return false;
         } else {
             return true;
         }
     }
 
     /**
      * @param int $object_id
      * @param int $tag_type
      *
      * @return string|null
      */
     public function getTagsCategory($object_id, $tag_type)
     {
         $tag_group_ids = $this::TAG_CATEGORY_GROUPID;
         $tags = $this->getTagsArray($object_id, $tag_type, $tag_group_ids);
 
         $tag_names = '';
         foreach ($tags as $tag) {
             $tag_names = $tag_names . $tag['tag_name'] . ',';
         }
         $len = strlen($tag_names);
         if ($len > 0) {
             return substr($tag_names, 0, ($len - 1));
         }
 
         return null;
     }
 
     /**
      * @param int    $object_id
      * @param int    $tag_type
      * @param String $tag_group_ids
      *
      * @return array
      */
     public function getTagsArray($object_id, $tag_type, $tag_group_ids)
     {
         $sql = "
                         SELECT tag.tag_id,tag.tag_name,tag_group_item.tag_group_id,tag.tag_fullname, tag.tag_description
                         FROM tag_object
                         JOIN tag ON tag.tag_id = tag_object.tag_id
                         join tag_group_item on tag_object.tag_id = tag_group_item.tag_id and tag_object.tag_group_id = tag_group_item.tag_group_id
                         WHERE tag_type_id = :type AND tag_object_id = :object_id
                         and tag_object.tag_group_id in  ({$tag_group_ids} )     
                         and tag_object.is_deleted = 0  
                         order by tag_group_item.tag_group_id desc , tag.tag_name asc
             ";
 
         $result = $this->getAdapter()->fetchAll($sql, array('type' => $tag_type, 'object_id' => $object_id));
 
         return $result;
     }
 
     /**
      * @param int $object_id
      * @param int $tag_type
      *
      * @return string|null
      */
     public function getTagsSystem($object_id, $tag_type)
     {
         $tag_group_ids = '6,7,10';
         $tags = $this->getTagsArray($object_id, $tag_type, $tag_group_ids);
 
         $tag_names = '';
         foreach ($tags as $tag) {
             $tag_names = $tag_names . $tag['tag_name'] . ',';
         }
         $len = strlen($tag_names);
         if ($len > 0) {
             return substr($tag_names, 0, ($len - 1));
         }
 
         return null;
     }
 
     /**
      * @param int $project_id
      * @return array
      */
     public function getTagsSystemList($project_id)
     {
         $tag_project_group_ids = self::TAG_PROJECT_GROUP_IDS;
         $tag_file_group_ids = self::TAG_FILE_GROUP_IDS;
         $sql = "
                 SELECT tag.tag_id,tag.tag_name,tag_object.tag_group_id
                 FROM tag_object
                 JOIN tag ON tag.tag_id = tag_object.tag_id                
                 WHERE tag_type_id = :type_project AND tag_object_id = :project_id
                 and tag_object.tag_group_id in  ({$tag_project_group_ids} )     
                 and tag_object.is_deleted = 0  
                 union all
                 SELECT distinct t.tag_id,t.tag_name,o.tag_group_id
                 FROM tag_object o
                 JOIN tag t ON t.tag_id = o.tag_id  
                 inner join project p on o.tag_parent_object_id = p.project_id                 
                 inner join ppload.ppload_files f on p.ppload_collection_id = f.collection_id and o.tag_object_id=f.id and f.active = 1
                 WHERE o.tag_type_id = :type_file AND p.project_id = :project_id
                 and o.tag_group_id in  ({$tag_file_group_ids} )       
                 and o.is_deleted = 0  
                 order by tag_group_id  , tag_name                 
         ";
         $result = $this->getAdapter()->fetchAll($sql, array(
             'type_project' => Default_Model_Tags::TAG_TYPE_PROJECT
         ,
             'project_id'   => $project_id
         ,
             'type_file'    => Default_Model_Tags::TAG_TYPE_FILE
         ));
 
 
         return $result;
     }
 
     /**
      * @param int $object_id
      * @param int $tag_type
      *
      * @return string|null
      */
     public function getTagsUserCount($object_id, $tag_type)
     {
         $sql = "
             SELECT count(*) AS `cnt`
             FROM `tag_object`
             JOIN `tag` ON `tag`.`tag_id` = `tag_object`.`tag_id`
             JOIN `tag_group_item` ON `tag_object`.`tag_id` = `tag_group_item`.`tag_id` AND `tag_object`.`tag_group_id` = `tag_group_item`.`tag_group_id`
             WHERE `tag_type_id` = :type AND `tag_object_id` = :object_id      
             AND `tag_object`.`is_deleted` = 0      
             AND `tag_group_item`.`tag_group_id` = :tag_user_groupid     
 
         ";
 
         $result = $this->getAdapter()->fetchRow($sql, array(
             'type'             => $tag_type,
             'object_id'        => $object_id,
             'tag_user_groupid' => Default_Model_Tags::TAG_USER_GROUPID
         ));
         if (isset($result['cnt'])) {
             return $result['cnt'];
         }
 
         return 0;
     }
 
     public function filterTagsUser($filter, $limit)
     {
         $sql = "
              select 
              tag.tag_id 
              ,tag.tag_name
              from tag
              join tag_group_item on tag.tag_id = tag_group_item.tag_id and tag_group_item.tag_group_id = :tag_user_groupid
              where tag.tag_name like '%" . $filter . "%'
                ";
         if (isset($limit)) {
             $sql .= ' limit ' . $limit;
         }
 
         $result = $this->getAdapter()->fetchAll($sql,
             array('tag_user_groupid' => Default_Model_Tags::TAG_USER_GROUPID));
 
         return $result;
     }
 
     /**
      * @param int    $object_id
      * @param string $tags
      * @param int    $tag_type
      */
     public function processTagsUser($object_id, $tags, $tag_type)
     {
         if ($tags) {
             $this->assignTagsUser($object_id, $tags, $tag_type);
         }
         $this->deassignTagsUser($object_id, $tags, $tag_type);
     }
 
     /**
      * @param int    $object_id
      * @param string $tags
      * @param int    $tag_type
      */
     public function assignTagsUser($object_id, $tags, $tag_type)
     {
         $tags = strtolower($tags);
         $tag_group_id = 5;
         $new_tags = array_diff(explode(',', $tags), explode(',', $this->getTagsUser($object_id, $tag_type)));
         if (sizeof($new_tags) > 0) {
             $tableTags = new Default_Model_DbTable_Tags();
             $listIds = $tableTags->storeTagsUser(implode(',', $new_tags));
 
             $prepared_insert =
                 array_map(function ($id) use ($object_id, $tag_type, $tag_group_id) {
                     return "({$id}, {$tag_type}, {$object_id},{$tag_group_id})";
                 },
                     $listIds);
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id,tag_group_id) VALUES " . implode(',',
                     $prepared_insert);
             $this->getAdapter()->query($sql);
         }
     }
 
     /**
      * @param int $object_id
      * @param int $tag_type
      *
      * @return string|null
      */
     public function getTagsUser($object_id, $tag_type)
     {
         $tag_group_ids = $this::TAG_USER_GROUPID;
         $tags = $this->getTagsArray($object_id, $tag_type, $tag_group_ids);
 
         $tag_names = '';
         foreach ($tags as $tag) {
             $tag_names = $tag_names . $tag['tag_name'] . ',';
         }
         $len = strlen($tag_names);
         if ($len > 0) {
             return substr($tag_names, 0, ($len - 1));
         }
 
         return null;
     }
 
     public function deassignTagsUser($object_id, $tags, $tag_type)
     {
         if ($tags) {
             $tags = strtolower($tags);
             $removable_tags = array_diff(explode(',', $this->getTagsUser($object_id, $tag_type)), explode(',', $tags));
         } else {
             $removable_tags = explode(',', $this->getTagsUser($object_id, $tag_type));
         }
 
         //$sql = "DELETE tag_object FROM tag_object JOIN tag ON tag.tag_id = tag_object.tag_id WHERE tag_group_id = ".Default_Model_Tags::TAG_USER_GROUPID." and tag.tag_name = :name and tag_object.tag_object_id=:object_id";
         $sql = "UPDATE tag_object inner join tag ON tag.tag_id = tag_object.tag_id set tag_changed = NOW() , is_deleted = 1 
                     WHERE tag_group_id = " . Default_Model_Tags::TAG_USER_GROUPID . " and tag.tag_name = :name and tag_object.tag_object_id=:object_id";
 
         foreach ($removable_tags as $removable_tag) {
             $this->getAdapter()->query($sql, array('name' => $removable_tag, 'object_id' => $object_id));
             // if Tag is the only one in Tag_object table then delete this tag for user_groupid = 5
 
             $sql_object = "SELECT count(1)  AS `cnt` FROM `tag_object` JOIN `tag` ON `tag`.`tag_id` = `tag_object`.`tag_id` WHERE `tag`.`tag_name` = :name";
             $r = $this->getAdapter()->fetchRow($sql_object, array('name' => $removable_tag));
             if ($r['cnt'] == 0) {
                 // then remove tag if not existing in Tag_object
                 $sql_delete_tag = "delete from tag where tag_name=:name";
                 $this->getAdapter()->query($sql_delete_tag, array('name' => $removable_tag));
             }
         }
         $this->updateChanged($object_id, $tag_type);
     }
 
     public function isProductOriginal($project_id)
     {
         $sql_object = "select tag_item_id  from tag_object WHERE tag_id = :tag_id and tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
                                     and tag_type_id = :tag_type_id and is_deleted = 0";
         $r = $this->getAdapter()->fetchRow($sql_object, array(
             'tag_id'        => self::TAG_PRODUCT_ORIGINAL_ID,
             'tag_object_id' => $project_id,
             'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID,
             'tag_type_id'   => self::TAG_TYPE_PROJECT
         ));
         if ($r) {
             return true;
         } else {
             return false;
         }
     }
     
     public function isProductModification($project_id)
     {
         $tag_modification_id = Zend_Registry::get('config')->settings->client->default->tag_modification_id;
         
         $sql_object = "select tag_item_id  from tag_object WHERE tag_id = :tag_id and tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
                                     and tag_type_id = :tag_type_id and is_deleted = 0";
         $r = $this->getAdapter()->fetchRow($sql_object, array(
             'tag_id'        => $tag_modification_id,
             'tag_object_id' => $project_id,
             'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID,
             'tag_type_id'   => self::TAG_TYPE_PROJECT
         ));
         if ($r) {
             return true;
         } else {
             return false;
         }
     }
+    
+    public function isProductDangerous($project_id)
+    {
+        $tag_dangerous_group_id = Zend_Registry::get('config')->settings->client->default->tag_group_dangerous_id;
+        $tag_dangerous_id = Zend_Registry::get('config')->settings->client->default->tag_dangerous_id;
+        
+        $sql_object = "select tag_item_id  from tag_object WHERE tag_id = :tag_id and tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
+                                    and tag_type_id = :tag_type_id and is_deleted = 0";
+        $r = $this->getAdapter()->fetchRow($sql_object, array(
+            'tag_id'        => $tag_dangerous_id,
+            'tag_object_id' => $project_id,
+            'tag_group_id'  => $tag_dangerous_group_id,
+            'tag_type_id'   => self::TAG_TYPE_PROJECT
+        ));
+        if ($r) {
+            return true;
+        } else {
+            return false;
+        }
+    }
 
     public function isProductEbook($project_id)
     {
         $ebookTagGroupId = Zend_Registry::get('config')->settings->client->default->tag_group_ebook;
         $ebookTagId = Zend_Registry::get('config')->settings->client->default->tag_is_ebook;
 
         $sql_object = "select tag_item_id  from tag_object WHERE tag_id = :tag_id and tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
                                 and tag_type_id = :tag_type_id and is_deleted = 0";
         $r = $this->getAdapter()->fetchRow($sql_object, array(
             'tag_id'        => $ebookTagId,
             'tag_object_id' => $project_id,
             'tag_group_id'  => $ebookTagGroupId,
             'tag_type_id'   => self::TAG_TYPE_PROJECT
         ));
         if ($r) {
             return true;
         } else {
             return false;
         }
     }
 
     /**
      * @param int $object_id
      * @param int $is_original
      */
     public function processTagProductOriginal($object_id, $is_original)
     {
         $sql_object = "select tag_item_id  from tag_object WHERE tag_id = :tag_id and tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
                                 and tag_type_id = :tag_type_id and is_deleted = 0";
         $r = $this->getAdapter()->fetchRow($sql_object, array(
             'tag_id'        => self::TAG_PRODUCT_ORIGINAL_ID,
             'tag_object_id' => $object_id,
             'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID,
             'tag_type_id'   => self::TAG_TYPE_PROJECT
         ));
 
         if ($is_original == '1') {
             if (!$r) {
                 $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_group_id)";
                 $this->getAdapter()->query($sql, array(
                     'tag_id'        => self::TAG_PRODUCT_ORIGINAL_ID,
                     'tag_type_id'   => self::TAG_TYPE_PROJECT,
                     'tag_object_id' => $object_id,
                     'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID
                 ));
             }
         } else {
 
             if ($r) {
                 $sql = "UPDATE tag_object set tag_changed = NOW() , is_deleted = 1  WHERE tag_item_id = :tagItemId";
                 $this->getAdapter()->query($sql, array('tagItemId' => $r['tag_item_id']));
             }
         }
 
     }
     
     /**
      * @param int $object_id
      * @param int $original (null, 1 or 2)
      */
     public function processTagProductOriginalOrModification($object_id, $original)
     {
         $tag_original_id = Zend_Registry::get('config')->settings->client->default->tag_original_id;
         $tag_modification_id = Zend_Registry::get('config')->settings->client->default->tag_modification_id;
         
         $sql_object = "select tag_item_id  from tag_object WHERE tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
                                 and tag_type_id = :tag_type_id and is_deleted = 0";
         $r = $this->getAdapter()->fetchAll($sql_object, array(
             'tag_object_id' => $object_id,
             'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID,
             'tag_type_id'   => self::TAG_TYPE_PROJECT
         ));
 
         if ($original == '1' || $original == '2') {
             if ($r) {
                 //delte all old tags
                 foreach ($r as $tag) {
                     $sql = "UPDATE tag_object set tag_changed = NOW() , is_deleted = 1  WHERE tag_item_id = :tagItemId";
                     $this->getAdapter()->query($sql, array('tagItemId' => $tag['tag_item_id']));
                 }
             }
             
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_group_id)";
             if ($original == '1') {
                 $this->getAdapter()->query($sql, array(
                     'tag_id'        => $tag_original_id,
                     'tag_type_id'   => self::TAG_TYPE_PROJECT,
                     'tag_object_id' => $object_id,
                     'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID
                 ));
             } else {
                 $this->getAdapter()->query($sql, array(
                     'tag_id'        => $tag_modification_id,
                     'tag_type_id'   => self::TAG_TYPE_PROJECT,
                     'tag_object_id' => $object_id,
                     'tag_group_id'  => self::TAG_PRODUCT_ORIGINAL_GROUPID
                 ));
             }
             
 
         } else {
 
             if ($r) {
                 foreach ($r as $tag) {
                     $sql = "UPDATE tag_object set tag_changed = NOW() , is_deleted = 1  WHERE tag_item_id = :tagItemId";
                     $this->getAdapter()->query($sql, array('tagItemId' => $tag['tag_item_id']));
                 }
             }
         }
 
     }
     
 
     /**
      * @param int $object_id
      */
     public function processTagCollection($object_id)
     {
         $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_group_id)";
         $this->getAdapter()->query($sql, array(
             'tag_id'        => self::TAG_COLLECTION_ID_ID,
             'tag_type_id'   => self::TAG_TYPE_PROJECT,
             'tag_object_id' => $object_id,
             'tag_group_id'  => self::TAG_COLLECTION_GROUPID
         ));
     }
 
     /**
      * @param int    $object_id
      * @param string $tag
      * @param int    $tag_type
      */
     public function addTagUser($object_id, $tag, $tag_type)
     {
         $tableTags = new Default_Model_DbTable_Tags();
         $listIds = $tableTags->storeTagsUser($tag);
         $tag_group_id = $this::TAG_USER_GROUPID;
         $prepared_insert =
             array_map(function ($id) use ($object_id, $tag_type, $tag_group_id) {
                 return "({$id}, {$tag_type}, {$object_id},{$tag_group_id})";
             },
                 $listIds);
         $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id,tag_group_id) VALUES " . implode(',',
                 $prepared_insert);
 
 
         $this->getAdapter()->query($sql);
     }
 
     public function deleteTagUser($object_id, $tag, $tag_type)
     {
         $removable_tag = $tag;
         // $sql = "DELETE tag_object FROM tag_object JOIN tag ON tag.tag_id = tag_object.tag_id WHERE tag_group_id = ".Default_Model_Tags::TAG_USER_GROUPID." and  tag.tag_name = :name and tag_object.tag_object_id=:object_id
         //             and tag_group_id =".Default_Model_Tags::TAG_USER_GROUPID;
 
         $sql = "UPDATE `tag_object` INNER JOIN `tag` ON `tag`.`tag_id` = `tag_object`.`tag_id` SET `tag_changed` = NOW() , `is_deleted` = 1 
                     WHERE `tag_group_id` = " . Default_Model_Tags::TAG_USER_GROUPID . " AND `tag`.`tag_name` = :name AND `tag_object`.`tag_object_id`=:object_id";
 
         $this->getAdapter()->query($sql, array('name' => $removable_tag, 'object_id' => $object_id));
         // if Tag is the only one in Tag_object table then delete this tag for user_groupid = 5
 
         $sql_object = "select count(1)  as cnt from tag_object JOIN tag ON tag.tag_id = tag_object.tag_id WHERE tag.tag_name = :name ";
         $r = $this->getAdapter()->fetchRow($sql_object, array('name' => $removable_tag));
         if ($r['cnt'] == 0) {
             // then remove tag if not existing in Tag_object
             $sql_delete_tag = "DELETE FROM `tag` WHERE `tag_name`=:name";
             $this->getAdapter()->query($sql_delete_tag, array('name' => $removable_tag));
         }
         $this->updateChanged($object_id, $tag_type);
     }
 
     public function getTagsPerCategory($cat_id)
     {
         $sql = "select t.*  from  category_tag as c ,tag as t where c.tag_id = t.tag_id and c.category_id = :cat_id";
         $r = $this->getAdapter()->fetchAll($sql, array('cat_id' => $cat_id));
 
         return $r;
     }
 
     public function validateCategoryTags($cat_id, $tags)
     {
         if ($tags == null) {
             return true;
         }
         //check if $cat_id children has tag already
         $sql = '
             select * from category_tag where tag_id in (' . $tags . ') and category_id in
             (
                 select c.project_category_id 
                 from project_category c 
                 join project_category d where d.project_category_id = ' . $cat_id . ' and c.lft> d.lft and c.rgt<d.rgt    
             )
         ';
 
 
         $r = $this->getAdapter()->fetchAll($sql);
         if (sizeof($r) > 0) {
             return false;
         }
 
         // check parent
         $sql = ' select ancestor_id_path from stat_cat_tree where project_category_id = ' . $cat_id;
         $r = $this->getAdapter()->fetchRow($sql);
         $sql = '
             select * from category_tag where category_id in (' . $r['ancestor_id_path'] . ') and category_id <> ' . $cat_id . ' and tag_id in (' . $tags . ')';
 
 
         $r = $this->getAdapter()->fetchAll($sql);
         if (sizeof($r) > 0) {
             return false;
         }
 
         return true;
     }
 
     public function updateTagsPerCategory($cat_id, $tags)
     {
         $sql = "delete from category_tag  where category_id=:cat_id";
         $this->getAdapter()->query($sql, array('cat_id' => $cat_id));
 
         if ($tags) {
             $tags_id = explode(',', $tags);
             $prepared_insert =
                 array_map(function ($id) use ($cat_id) {
                     return "({$cat_id},{$id})";
                 },
                     $tags_id);
             $sql = "INSERT IGNORE INTO category_tag (category_id, tag_id) VALUES " . implode(',',
                     $prepared_insert);
 
             $this->getAdapter()->query($sql);
         }
     }
 
     public function updateTagsPerStore($store_id, $tags)
     {
         $sql = "delete from config_store_tag  where store_id=:store_id";
         $this->getAdapter()->query($sql, array('store_id' => $store_id));
 
         if ($tags) {
             $tags_id = explode(',', $tags);
             $prepared_insert =
                 array_map(function ($id) use ($store_id) {
                     return "({$store_id},{$id})";
                 },
                     $tags_id);
             $sql = "INSERT IGNORE INTO config_store_tag (store_id, tag_id) VALUES " . implode(',',
                     $prepared_insert);
 
             $this->getAdapter()->query($sql);
         }
     }
 
     public function getTagsPerGroup($groupid)
     {
         $sql = "
                          select 
                          tag.tag_id 
                          ,tag.tag_name
                          ,tag_fullname
                          ,tag_description
                          from tag
                          join tag_group_item on tag.tag_id = tag_group_item.tag_id and tag_group_item.tag_group_id = :groupid                         
                          order by tag_name
                     ";
         $result = $this->getAdapter()->fetchAll($sql, array('groupid' => $groupid));
 
         return $result;
     }
 
     public function getAllTagsForStoreFilter()
     {
         $sql = "
                          select 
                          tag.tag_id, 
                          CASE WHEN tag.tag_fullname IS NULL THEN tag_name ELSE tag.tag_fullname END as tag_name
                          from tag
                          where tag.is_active = 1
                          order by tag_name
                     ";
         $result = $this->getAdapter()->fetchAll($sql);
 
         return $result;
     }
 
 
     public function getAllTagGroupsForStoreFilter()
     {
         $sql = "
              SELECT 
                 `tag_group`.`group_id`, 
                 `tag_group`.`group_name` AS `group_name`
                 FROM `tag_group`
                 ORDER BY `tag_group`.`group_name`
                ";
         $result = $this->getAdapter()->fetchAll($sql);
 
         return $result;
     }
 
 
     public function saveLicenseTagForProject($object_id, $tag_id)
     {
 
         $tableTags = new Default_Model_DbTable_Tags();
 
         $tags = $tableTags->fetchLicenseTagsForProject($object_id);
         if (count($tags) == 0) {
             //insert new tag
             if ($tag_id) {
                 $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_group_id)";
                 $this->getAdapter()->query($sql, array(
                     'tag_id'        => $tag_id,
                     'tag_type_id'   => $this::TAG_TYPE_PROJECT,
                     'tag_object_id' => $object_id,
                     'tag_group_id'  => $this::TAG_LICENSE_GROUPID
                 ));
             }
         } else {
             $tag = $tags[0];
 
             //remove tag license
             if (!$tag_id) {
                 //$sql = "DELETE FROM tag_object WHERE tag_item_id = :tagItemId";
                 $sql = "UPDATE `tag_object` SET `tag_changed` = NOW() , `is_deleted` = 1  WHERE `tag_item_id` = :tagItemId";
                 $this->getAdapter()->query($sql, array('tagItemId' => $tag['tag_item_id']));
             } else {
                 //Update old tag
                 if ($tag_id <> $tag['tag_id']) {
                     $sql = "UPDATE tag_object SET tag_changed = NOW(),tag_id = :tag_id WHERE tag_item_id = :tagItemId";
                     $this->getAdapter()->query($sql, array('tagItemId' => $tag['tag_item_id'], 'tag_id' => $tag_id));
                 }
             }
 
         }
     }
 
 
-    public function saveGhnsExcludedTagForProject($object_id, $tag_value)
+    public function saveDangerosuTagForProject($object_id, $tag_value)
     {
 
         $tableTags = new Default_Model_DbTable_Tags();
-        $ghnsExcludedTagId = $tableTags->fetchGhnsExcludedTagId();
+        $tag_dangerous_group_id = Zend_Registry::get('config')->settings->client->default->tag_group_dangerous_id;
+        $tag_dangerous_id = Zend_Registry::get('config')->settings->client->default->tag_dangerous_id;
 
         $sql = "UPDATE tag_object SET tag_changed = NOW() , is_deleted = 1  WHERE tag_group_id = :tag_group_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id";
         $this->getAdapter()->query($sql, array(
-            'tag_group_id'  => $this::TAG_GHNS_EXCLUDED_GROUPID,
+            'tag_group_id'  => $tag_dangerous_group_id,
             'tag_type_id'   => $this::TAG_TYPE_PROJECT,
             'tag_object_id' => $object_id
         ));
 
         if ($tag_value == 1) {
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_group_id)";
             $this->getAdapter()->query($sql, array(
-                'tag_id'        => $ghnsExcludedTagId,
+                'tag_id'        => $tag_dangerous_id,
                 'tag_type_id'   => $this::TAG_TYPE_PROJECT,
                 'tag_object_id' => $object_id,
-                'tag_group_id'  => $this::TAG_GHNS_EXCLUDED_GROUPID
+                'tag_group_id'  => $tag_dangerous_group_id
             ));
         }
 
 
     }
 
 
     public function saveArchitectureTagForProject($project_id, $file_id, $tag_id)
     {
 
         //first delete old
         //$sql = "DELETE FROM tag_object WHERE tag_group_id = :tag_group_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id AND tag_parent_object_id = :tag_parent_object_id";
         $sql = "UPDATE tag_object SET tag_changed = NOW() , is_deleted = 1  WHERE tag_group_id = :tag_group_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id AND tag_parent_object_id = :tag_parent_object_id";
         $this->getAdapter()->query($sql, array(
             'tag_group_id'         => $this::TAG_ARCHITECTURE_GROUPID,
             'tag_type_id'          => $this::TAG_TYPE_FILE,
             'tag_object_id'        => $file_id,
             'tag_parent_object_id' => $project_id
         ));
 
         if ($tag_id) {
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_parent_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_parent_object_id, :tag_group_id)";
             $this->getAdapter()->query($sql, array(
                 'tag_id'               => $tag_id,
                 'tag_type_id'          => $this::TAG_TYPE_FILE,
                 'tag_object_id'        => $file_id,
                 'tag_parent_object_id' => $project_id,
                 'tag_group_id'         => $this::TAG_ARCHITECTURE_GROUPID
             ));
         }
 
     }
 
     public function saveFileTagForProjectAndTagGroup($project_id, $file_id, $tag_id, $tag_group_id)
     {
 
         //first delete old
         $sql = "UPDATE tag_object SET tag_changed = NOW() , is_deleted = 1  WHERE tag_group_id = :tag_group_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id AND tag_parent_object_id = :tag_parent_object_id";
 
         $this->getAdapter()->query($sql, array(
             'tag_group_id'         => $tag_group_id,
             'tag_type_id'          => $this::TAG_TYPE_FILE,
             'tag_object_id'        => $file_id,
             'tag_parent_object_id' => $project_id
         ));
 
         if (!empty($tag_id)) {
             if (is_array($tag_id)) {
                 foreach ($tag_id as $tag) {
                     $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_parent_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_parent_object_id, :tag_group_id)";
                     $this->getAdapter()->query($sql, array(
                         'tag_id'               => $tag,
                         'tag_type_id'          => $this::TAG_TYPE_FILE,
                         'tag_object_id'        => $file_id,
                         'tag_parent_object_id' => $project_id,
                         'tag_group_id'         => $tag_group_id
                     ));
                 }
 
             } else {
                 $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_parent_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_parent_object_id, :tag_group_id)";
                 $this->getAdapter()->query($sql, array(
                     'tag_id'               => $tag_id,
                     'tag_type_id'          => $this::TAG_TYPE_FILE,
                     'tag_object_id'        => $file_id,
                     'tag_parent_object_id' => $project_id,
                     'tag_group_id'         => $tag_group_id
                 ));
             }
 
 
         }
     }
 
 
     public function deleteFileTagForProject($project_id, $file_id, $tag_id)
     {
 
         //first delete old
         $sql = "UPDATE tag_object SET tag_changed = NOW() , is_deleted = 1  WHERE tag_id= :tag_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id AND tag_parent_object_id = :tag_parent_object_id";
 
         $this->getAdapter()->query($sql, array(
             'tag_id'               => $tag_id,
             'tag_type_id'          => $this::TAG_TYPE_FILE,
             'tag_object_id'        => $file_id,
             'tag_parent_object_id' => $project_id
         ));
 
     }
 
 
     public function savePackageTagForProject($project_id, $file_id, $tag_id)
     {
 
         //first delete old
         $sql = "UPDATE tag_object SET tag_changed = NOW() , is_deleted = 1  WHERE tag_group_id = :tag_group_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id AND tag_parent_object_id = :tag_parent_object_id";
 
         $this->getAdapter()->query($sql, array(
             'tag_group_id'         => $this::TAG_PACKAGETYPE_GROUPID,
             'tag_type_id'          => $this::TAG_TYPE_FILE,
             'tag_object_id'        => $file_id,
             'tag_parent_object_id' => $project_id
         ));
 
         if ($tag_id) {
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_parent_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_parent_object_id, :tag_group_id)";
             $this->getAdapter()->query($sql, array(
                 'tag_id'               => $tag_id,
                 'tag_type_id'          => $this::TAG_TYPE_FILE,
                 'tag_object_id'        => $file_id,
                 'tag_parent_object_id' => $project_id,
                 'tag_group_id'         => $this::TAG_PACKAGETYPE_GROUPID
             ));
         }
 
 
     }
 
 
     public function getProjectPackageTypesString($projectId)
     {
         $sql = 'SELECT DISTINCT ta.tag_fullname as name FROM tag_object t INNER JOIN tag ta on ta.tag_id = t.tag_id WHERE t.tag_group_id = :tag_group_id AND t.tag_parent_object_id = :project_id AND t.is_deleted = 0';
         $resultSet = $this->getAdapter()->fetchAll($sql,
             array('tag_group_id' => $this::TAG_PACKAGETYPE_GROUPID, 'project_id' => $projectId));
         $resultString = '';
         if (count($resultSet) > 0) {
             foreach ($resultSet as $item) {
                 $resultString = $resultString . ' <span class="packagetypeos" > ' . stripslashes($item['name']) . '</span>';
             }
 
             return $resultString;
         }
 
         return '';
     }
 
     public function getProjectPackageTypesPureStrings($projectId)
     {
         $sql = 'SELECT DISTINCT ta.tag_fullname as name FROM tag_object t INNER JOIN tag ta on ta.tag_id = t.tag_id WHERE t.tag_group_id = :tag_group_id AND t.tag_parent_object_id = :project_id AND t.is_deleted = 0';
         $resultSet = $this->getAdapter()->fetchAll($sql,
             array('tag_group_id' => $this::TAG_PACKAGETYPE_GROUPID, 'project_id' => $projectId));
         $resultString = '';
         if (count($resultSet) > 0) {
             foreach ($resultSet as $item) {
                 $resultString = $resultString . '  ' . stripslashes($item['name']);
             }
 
             return $resultString;
         }
 
         return '';
     }
 
     public function deleteFileTagsOnProject($projectId, $fileId)
     {
         $sql = "UPDATE tag_object inner join tag ON tag.tag_id = tag_object.tag_id set tag_changed = NOW() , is_deleted = 1 
                     WHERE tag_type_id = :tag_type_id and tag_object.tag_object_id=:object_id and tag_object.tag_parent_object_id=:parent_object_id";
 
         $this->getAdapter()->query($sql,
             array('tag_type_id' => $this::TAG_TYPE_FILE, 'object_id' => $fileId, 'parent_object_id' => $projectId));
     }
 
 
     public function deletePackageTypeOnProject($projectId, $fileId)
     {
         $sql = "UPDATE tag_object inner join tag ON tag.tag_id = tag_object.tag_id set tag_changed = NOW() , is_deleted = 1 
                     WHERE tag_group_id = :tag_group_id and tag_object.tag_object_id=:object_id and tag_object.tag_parent_object_id=:parent_object_id";
 
         $this->getAdapter()->query($sql, array(
             'tag_group_id'     => $this::TAG_PACKAGETYPE_GROUPID,
             'object_id'        => $fileId,
             'parent_object_id' => $projectId
         ));
     }
 
 
     public function deleteArchitectureOnProject($projectId, $fileId)
     {
         $sql = "UPDATE tag_object inner join tag ON tag.tag_id = tag_object.tag_id set tag_changed = NOW() , is_deleted = 1 
                     WHERE tag_group_id = :tag_group_id and tag_object.tag_object_id=:object_id and tag_object.tag_parent_object_id=:parent_object_id";
 
         $this->getAdapter()->query($sql, array(
             'tag_group_id'     => $this::TAG_ARCHITECTURE_GROUPID,
             'object_id'        => $fileId,
             'parent_object_id' => $projectId
         ));
     }
 
 
     /**
      * @param int $projectId
      * @param int $fileId
      * @return string
      */
     public function getPackageType($projectId, $fileId)
     {
         $sql = 'SELECT ta.tag_fullname as name FROM tag_object t INNER JOIN tag ta on ta.tag_id = t.tag_id WHERE t.tag_group_id = :tag_group_id AND t.tag_parent_object_id = :project_id AND t.tag_object_id = :file_id AND t.is_deleted = 0';
         $resultSet = $this->getAdapter()->fetchAll($sql,
             array('tag_group_id' => $this::TAG_PACKAGETYPE_GROUPID, 'project_id' => $projectId, 'file_id' => $fileId));
 
         if (count($resultSet) > 0) {
             return $resultSet[0]['name'];
         } else {
             return '';
         }
     }
 
 
     /**
      * @param int $fileId
      * @return array
      */
     public function getFileTags($fileId)
     {
         $sql = 'SELECT ta.tag_id, ta.tag_fullname as name FROM tag_object t INNER JOIN tag ta on ta.tag_id = t.tag_id WHERE t.tag_type_id = :tag_type_id AND t.tag_object_id = :file_id AND t.is_deleted = 0';
         $resultSet = $this->getAdapter()->fetchAll($sql,
             array('tag_type_id' => $this::TAG_TYPE_FILE, 'file_id' => $fileId));
 
         return $resultSet;
     }
 
 
     /**
      * @param int $projectId
      * @param int $fileId
      * @param int $tagGroup
      * @return array
      */
     public function getTagsForFileAndTagGroup($projectId, $fileId, $tagGroup)
     {
         $sql = 'SELECT ta.tag_fullname as name FROM tag_object t INNER JOIN tag ta on ta.tag_id = t.tag_id WHERE t.tag_group_id = :tag_group_id AND t.tag_parent_object_id = :project_id AND t.tag_object_id = :file_id AND t.is_deleted = 0';
         $resultSet = $this->getAdapter()->fetchAll($sql,
             array('tag_group_id' => $tagGroup, 'project_id' => $projectId, 'file_id' => $fileId));
 
         return $resultSet;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookSubject($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_subject;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookAuthor($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_author;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookEditor($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_editor;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookIllustrator($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_illustrator;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookTranslator($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_translator;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookShelf($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_shelf;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookLanguage($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_language;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     /**
      * @param int $object_id
      *
      * @return array
      * @throws Zend_Exception
      */
     public function getTagsEbookType($object_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_ebook_type;
         $tags = $this->getTagsArray($object_id, $this::TAG_TYPE_PROJECT, $tag_group_ids);
 
         return $tags;
     }
 
 
     public function saveCollectionTypeTagForProject($object_id, $tag_id)
     {
 
         $tableTags = new Default_Model_DbTable_Tags();
 
         $collectionTagGroup = Zend_Registry::get('config')->settings->client->default->tag_group_collection_type_id;
 
 
         $tags = $tableTags->fetchTagsForProject($object_id, $collectionTagGroup);
         if (count($tags) == 0) {
             //insert new tag
             if ($tag_id) {
                 $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_object_id, tag_group_id) VALUES (:tag_id, :tag_type_id, :tag_object_id, :tag_group_id)";
                 $this->getAdapter()->query($sql, array(
                     'tag_id'        => $tag_id,
                     'tag_type_id'   => $this::TAG_TYPE_PROJECT,
                     'tag_object_id' => $object_id,
                     'tag_group_id'  => $collectionTagGroup
                 ));
             }
         } else {
             $tag = $tags[0];
 
             //remove tag license
             if (!$tag_id) {
                 //$sql = "DELETE FROM tag_object WHERE tag_item_id = :tagItemId";
                 $sql = "UPDATE tag_object set tag_changed = NOW() , is_deleted = 1  WHERE tag_item_id = :tagItemId";
                 $this->getAdapter()->query($sql, array('tagItemId' => $tag['tag_item_id']));
             } else {
                 //Update old tag
                 if ($tag_id <> $tag['tag_id']) {
                     $sql = "UPDATE tag_object SET tag_changed = NOW(),tag_id = :tag_id WHERE tag_item_id = :tagItemId";
                     $this->getAdapter()->query($sql, array('tagItemId' => $tag['tag_item_id'], 'tag_id' => $tag_id));
                 }
             }
 
         }
 
 
     }
 
     //========================== generic methods =============================
 
     public function fetchTagObject($tag_id, $tag_object_id, $tag_group_id, $tag_type_id)
     {
         $sql = $sql_object = "select tag_item_id  from tag_object WHERE tag_id = :tag_id and tag_object_id=:tag_object_id and tag_group_id=:tag_group_id  
                                 and tag_type_id = :tag_type_id and is_deleted = 0";
         $r = $this->getAdapter()->fetchRow($sql_object, array(
             'tag_id'        => $tag_id,
             'tag_object_id' => $tag_object_id,
             'tag_group_id'  => $tag_group_id,
             'tag_type_id'   => $tag_type_id
         ));
 
         return $r;
     }
 
     /*
     * $tag_ids array tag ids 
     */
 
     /**
      * @return array
      * @throws Zend_Exception
      */
     public function getTagGroupsOSUser()
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_osuser;
 
         return $this->getTagGroups($tag_group_ids);
     }
 
     public function getTagGroups($tag_group_ids)
     {
         $sql = 'select g.group_id
                 ,g.group_name
                 ,g.group_display_name
                 ,g.is_multi_select
                 ,i.tag_group_item_id
                 ,i.tag_id
                 ,t.tag_name
                 ,t.tag_fullname
                 ,t.tag_description    
              from 
              tag_group g,
              tag_group_item i,
              tag t
              where g.group_id=i.tag_group_id
              and i.tag_id = t.tag_id 
              and g.group_id in (' . $tag_group_ids . ')';
         $resultSet = $this->getAdapter()->fetchAll($sql);
 
         return $resultSet;
     }
 
     public function saveOSTagForUser($tag_id, $tag_group_id, $member_id)
     {
         $tag_type_id = Zend_Registry::get('config')->settings->client->default->tag_type_osuser;
         $this->deleteTagForTabObject($member_id, $tag_group_id, $tag_type_id);
         $this->insertTagObject($tag_id, $tag_type_id, $tag_group_id, $member_id, null);
     }
 
     //========================== generic methods end =============================
 
 
     // ======================== settings profile user os ==========================================
 
     public function deleteTagForTabObject($tag_object_id, $tag_group_id, $tag_type_id)
     {
 
         $sql = "UPDATE tag_object SET tag_changed = NOW() , is_deleted = 1  WHERE tag_group_id = :tag_group_id AND tag_type_id = :tag_type_id AND tag_object_id = :tag_object_id";
         $this->getAdapter()->query($sql,
             array('tag_group_id' => $tag_group_id, 'tag_type_id' => $tag_type_id, 'tag_object_id' => $tag_object_id));
 
     }
 
     public function insertTagObject($tag_ids, $tag_type_id, $tag_group_id, $tag_object_id, $tag_parent_object_id)
     {
         if ($tag_ids == null || sizeof($tag_ids) == 0) {
             return;
         }
         if (!is_array($tag_ids)) {
             $tag_ids = array($tag_ids);
         }
 
         if ($tag_parent_object_id) {
             $prepared_insert =
                 array_map(function ($id) use ($tag_type_id, $tag_group_id, $tag_object_id, $tag_parent_object_id) {
                     return "({$id}, {$tag_type_id},{$tag_group_id},{$tag_object_id},{$tag_parent_object_id})";
                 },
                     $tag_ids);
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_group_id,tag_object_id,tag_parent_object_id) VALUES " . implode(',',
                     $prepared_insert);
 
             $this->getAdapter()->query($sql);
         } else {
             $prepared_insert =
                 array_map(function ($id) use ($tag_type_id, $tag_group_id, $tag_object_id) {
                     return "({$id}, {$tag_type_id},{$tag_group_id},{$tag_object_id})";
                 },
                     $tag_ids);
             $sql = "INSERT IGNORE INTO tag_object (tag_id, tag_type_id, tag_group_id,tag_object_id) VALUES " . implode(',',
                     $prepared_insert);
             $this->getAdapter()->query($sql);
         }
     }
 
     public function getTagsOSUser($member_id)
     {
         $tag_group_ids = Zend_Registry::get('config')->settings->client->default->tag_group_osuser;
         $tag_type_id = Zend_Registry::get('config')->settings->client->default->tag_type_osuser;
 
         return $this->getTagsArray($member_id, $tag_type_id,$tag_group_ids);
     }
 
 }
\ No newline at end of file