Finished form for host-templates linkage.

git-svn-id: svn://svn.zabbix.com/trunk@1582 97f52cf1-0a1b-0410-bd0e-c28be96e8082

3 files changed, 46 insertions, 18 deletions

diff --git a/frontends/php/include/config.inc.php b/frontends/php/include/config.inc.php
index 38519007..1060655f 100644
--- a/frontends/php/include/config.inc.php
+++ b/frontends/php/include/config.inc.php
@@ -2996,6 +2996,27 @@ echo "</head>";
 		return	DBexecute($sql);
 	}
 
+	# Add host-template linkage
+	function add_template_linkage($hostid,$templateid,$items,$triggers,$actions,$graphs,$screens)
+	{
+		$sql="insert into hosts_templates (hostid,templateid,items,triggers,actions,graphs,screens) values ($hostid,$templateid,$items,$triggers,$actions,$graphs,$screens)";
+		return	DBexecute($sql);
+	}
+
+	# Update host-template linkage
+	function update_template_linkage($hosttemplateid,$hostid,$templateid,$items,$triggers,$actions,$graphs,$screens)
+	{
+		$sql="update hosts_templates set hostid=$hostid,templateid=$templateid,items=$items,triggers=$triggers,actions=$actions,graphs=$graphs,screens=$screens where hosttemplateid=$hosttemplateid";
+		return	DBexecute($sql);
+	}
+
+	# Delete host-template linkage
+	function delete_template_linkage($hosttemplateid)
+	{
+		$sql="delete from hosts_templates where hosttemplateid=$hosttemplateid";
+		return	DBexecute($sql);
+	}
+
 	# Add Host to system map
 
 	function add_host_to_sysmap($sysmapid,$hostid,$label,$x,$y,$icon,$url,$icon_on)
diff --git a/frontends/php/include/forms.inc.php b/frontends/php/include/forms.inc.php
index 0cfd1bd5..e4b85328 100644
--- a/frontends/php/include/forms.inc.php
+++ b/frontends/php/include/forms.inc.php
@@ -24,11 +24,11 @@
 	include_once 	"include/local_en.inc.php";
 
 	# Insert host template form
-	function	insert_template_form($hosttemplateid)
+	function	insert_template_form($hostid, $hosttemplateid)
 	{
 		if(isset($hosttemplateid))
 		{
-			$result=DBselect("select u.alias,u.name,u.surname,u.passwd,u.url from users u where u.userid=$userid");
+			$result=DBselect("select * from hosts_templates  where hosttemplateid=$hosttemplateid");
 
 			$row=DBfetch($result);
 	
@@ -61,6 +61,7 @@
 		show_table2_v_delimiter($col++);
 		echo "<form method=\"get\" action=\"hosts.php\">";
 		echo "<input class=\"biginput\" name=\"config\" type=\"hidden\" value=\"".$_GET["config"]."\" size=8>";
+		echo "<input class=\"biginput\" name=\"hostid\" type=\"hidden\" value=\"".$_GET["hostid"]."\" size=8>";
 		if(isset($hosttemplateid))
 		{
 			echo "<input class=\"biginput\" name=\"hosttemplateid\" type=\"hidden\" value=\"$hosttemplateid\" size=8>";
@@ -90,41 +91,41 @@
 		show_table2_v_delimiter($col++);
 		echo S_ITEMS;
 		show_table2_h_delimiter();
-		echo "<input type=checkbox checked name=\"items_add\" \">".S_ADD;
-		echo "<input type=checkbox checked name=\"items_update\" \">".S_UPDATE;
-		echo "<input type=checkbox checked name=\"items_delete\" \">".S_DELETE;
+		echo "<input type=checkbox ".iif((1&$items)==1,"checked","")." name=\"items_add\" \">".S_ADD;
+		echo "<input type=checkbox ".iif((2&$items)==2,"checked","")." name=\"items_update\" \">".S_UPDATE;
+		echo "<input type=checkbox ".iif((4&$items)==4,"checked","")." name=\"items_delete\" \">".S_DELETE;
 
 		show_table2_v_delimiter($col++);
 		echo S_TRIGGERS;
 		show_table2_h_delimiter();
-		echo "<input type=checkbox checked name=\"triggers_add\" \">".S_ADD;
-		echo "<input type=checkbox checked name=\"triggers_update\" \">".S_UPDATE;
-		echo "<input type=checkbox checked name=\"triggers_delete\" \">".S_DELETE;
+		echo "<input type=checkbox ".iif((1&$triggers)==1,"checked","")." name=\"triggers_add\" \">".S_ADD;
+		echo "<input type=checkbox ".iif((2&$triggers)==2,"checked","")." name=\"triggers_update\" \">".S_UPDATE;
+		echo "<input type=checkbox ".iif((4&$triggers)==4,"checked","")." name=\"triggers_delete\" \">".S_DELETE;
 
 		show_table2_v_delimiter($col++);
 		echo S_ACTIONS;
 		show_table2_h_delimiter();
-		echo "<input type=checkbox checked name=\"actions_add\" \">".S_ADD;
-		echo "<input type=checkbox checked name=\"actions_update\" \">".S_UPDATE;
-		echo "<input type=checkbox checked name=\"actions_delete\" \">".S_DELETE;
+		echo "<input type=checkbox ".iif((1&$actions)==1,"checked","")." name=\"actions_add\" \">".S_ADD;
+		echo "<input type=checkbox ".iif((2&$actions)==2,"checked","")." name=\"actions_update\" \">".S_UPDATE;
+		echo "<input type=checkbox ".iif((4&$actions)==4,"checked","")." name=\"actions_delete\" \">".S_DELETE;
 
 		show_table2_v_delimiter($col++);
 		echo S_GRAPHS;
 		show_table2_h_delimiter();
-		echo "<input type=checkbox checked name=\"graphs_add\" \">".S_ADD;
-		echo "<input type=checkbox checked name=\"graphs_update\" \">".S_UPDATE;
-		echo "<input type=checkbox checked name=\"graphs_delete\" \">".S_DELETE;
+		echo "<input type=checkbox ".iif((1&$graphs)==1,"checked","")." name=\"graphs_add\" \">".S_ADD;
+		echo "<input type=checkbox ".iif((2&$graphs)==2,"checked","")." name=\"graphs_update\" \">".S_UPDATE;
+		echo "<input type=checkbox ".iif((4&$graphs)==4,"checked","")." name=\"graphs_delete\" \">".S_DELETE;
 
 		show_table2_v_delimiter($col++);
 		echo S_SCREENS;
 		show_table2_h_delimiter();
-		echo "<input type=checkbox checked name=\"screens_add\" \">".S_ADD;
-		echo "<input type=checkbox checked name=\"screens_update\" \">".S_UPDATE;
-		echo "<input type=checkbox checked name=\"screens_delete\" \">".S_DELETE;
+		echo "<input type=checkbox ".iif((1&$screens)==1,"checked","")." name=\"screens_add\" \">".S_ADD;
+		echo "<input type=checkbox ".iif((2&$screens)==2,"checked","")." name=\"screens_update\" \">".S_UPDATE;
+		echo "<input type=checkbox ".iif((4&$screens)==4,"checked","")." name=\"screens_delete\" \">".S_DELETE;
 
 		show_table2_v_delimiter2($col++);
 		echo "<input class=\"button\" type=\"submit\" name=\"register\" value=\"add linkage\">";
-		if(isset($userid))
+		if(isset($hosttemplateid))
 		{
 			echo "<input class=\"button\" type=\"submit\" name=\"register\" value=\"update linkage\">";
 			echo "<input class=\"button\" type=\"submit\" name=\"register\" value=\"delete linkage\" onClick=\"return Confirm('Delete selected linkage?');\">";
diff --git a/frontends/php/include/local_en.inc.php b/frontends/php/include/local_en.inc.php
index aaa05220..5b896fc0 100644
--- a/frontends/php/include/local_en.inc.php
+++ b/frontends/php/include/local_en.inc.php
@@ -240,6 +240,12 @@
 	define("S_CANNOT_UPDATE_HOST_STATUS",		"Cannot update host status");
 	define("S_HOST_DELETED",			"Host deleted");
 	define("S_CANNOT_DELETE_HOST",			"Cannot delete host");
+	define("S_TEMPLATE_LINKAGE_ADDED",		"Template linkage added");
+	define("S_CANNOT_ADD_TEMPLATE_LINKAGE",		"Cannot add template linkage");
+	define("S_TEMPLATE_LINKAGE_UPDATED",		"Template linkage updated");
+	define("S_CANNOT_UPDATE_TEMPLATE_LINKAGE",	"Cannot update template linkage");
+	define("S_TEMPLATE_LINKAGE_DELETED",		"Template linkage deleted");
+	define("S_CANNOT_DELETE_TEMPLATE_LINKAGE",	"Cannot delete template linkage");
 	define("S_CONFIGURATION_OF_HOSTS_AND_HOST_GROUPS","CONFIGURATION OF HOSTS AND HOST GROUPS");
 	define("S_HOST_GROUPS_BIG",			"HOST GROUPS");
 	define("S_NO_HOST_GROUPS_DEFINED",		"No host groups defined");