X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Ftags_db.inc;h=08cb13c6eda1f37906c6a5d79297ecefd71bfae0;hb=e771cab507c120f329e50a71807dd4c53c0ace96;hp=6b6aec4d60436d35f5e1311a9b2085051a66c1bf;hpb=74eabb5769f01203484f13b9736c8a56011b48f4;p=fa-stable.git

diff --git a/admin/db/tags_db.inc b/admin/db/tags_db.inc
index 6b6aec4d..08cb13c6 100644
--- a/admin/db/tags_db.inc
+++ b/admin/db/tags_db.inc
@@ -80,6 +80,22 @@ function get_tag_name($id)
 	return $row[0];
 }
 
+//----------------------------------------------------------------------------------------------------
+function get_tag_names($tags)
+{
+	$str = "";
+	if ($tags == -1)
+		return $str;
+	foreach($tags as $id)
+	{
+		$tag = get_tag_name($id);
+		if ($str == "")
+			$str .= $tag;
+		else	
+			$str .= ", ".$tag;
+	}
+	return $str;
+}
 //--------------------------------------------------------------------------------------
 
 function get_tag_description($id)
@@ -190,4 +206,17 @@ function get_tags_associated_with_record($type, $recordid)
 
 //--------------------------------------------------------------------------------------
 
-?>
\ No newline at end of file
+function is_record_in_tags($tags, $type, $recordid)
+{
+	foreach($tags as $id)
+	{
+		$sql = "SELECT ta.record_id FROM ".TB_PREF."tag_associations AS ta 
+				INNER JOIN ".TB_PREF."tags AS tags ON tags.id = ta.tag_id 
+				WHERE tags.type = $type AND tags.id = $id AND ta.record_id = ".db_escape($recordid);
+		$res = db_query($sql, "could not get tags associations for record");
+		if (db_num_rows($res) == 0)
+			return false;
+	}
+	return true;
+}
+