- developed slideshow configuration (Eugene)

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

5 files changed, 262 insertions, 3 deletions

diff --git a/frontends/php/include/audit.inc.php b/frontends/php/include/audit.inc.php
index a567f512..a5a7aef1 100644
--- a/frontends/php/include/audit.inc.php
+++ b/frontends/php/include/audit.inc.php
@@ -41,6 +41,7 @@
 		$str_resource[AUDIT_RESOURCE_NODE]		= S_NODE;
 		$str_resource[AUDIT_RESOURCE_SCENARIO]		= S_SCENARIO;
 		$str_resource[AUDIT_RESOURCE_DISCOVERY_RULE]	= S_DISCOVERY_RULE;
+		$str_resource[AUDIT_RESOURCE_SLIDESHOW]		= S_SLIDESHOW;
 
 		if(isset($str_resource[$resource_type]))
 			return $str_resource[$resource_type];
diff --git a/frontends/php/include/defines.inc.php b/frontends/php/include/defines.inc.php
index a1c14ea5..332e5d14 100644
--- a/frontends/php/include/defines.inc.php
+++ b/frontends/php/include/defines.inc.php
@@ -97,6 +97,7 @@
 	define('AUDIT_RESOURCE_NODE',		21);
 	define('AUDIT_RESOURCE_SCENARIO',	22);
 	define('AUDIT_RESOURCE_DISCOVERY_RULE',	23);
+	define('AUDIT_RESOURCE_SLIDESHOW',	24);
 
 	define('CONDITION_TYPE_HOST_GROUP',	0);
 	define('CONDITION_TYPE_HOST',		1);
diff --git a/frontends/php/include/forms.inc.php b/frontends/php/include/forms.inc.php
index cf5ee929..8bf5ac5a 100644
--- a/frontends/php/include/forms.inc.php
+++ b/frontends/php/include/forms.inc.php
@@ -26,6 +26,137 @@
 	require_once 	"include/users.inc.php";
 	require_once 	"include/db.inc.php";
 
+	function	insert_slideshow_form()
+	{
+		$form = new CFormTable(S_SLIDESHOW, null, 'post');
+		$form->SetHelp('config_advanced.php');
+		
+		$form->AddVar('configid', 1);
+			
+		if(isset($_REQUEST['slideshowid']))
+		{
+			$form->AddVar('slideshowid', $_REQUEST['slideshowid']);
+		}
+
+		$name		= get_request('name', '');
+		$delay		= get_request('delay', 5);
+		$steps		= get_request('steps', array());
+
+		$new_step	= get_request('new_step', null);
+		
+		if((isset($_REQUEST['slideshowid']) && !isset($_REQUEST['form_refresh'])))
+		{
+			$slideshow_data = DBfetch(DBselect('select * from slideshows where slideshowid='.$_REQUEST['slideshowid']));
+		
+			$name		= $slideshow_data['name'];
+			$delay		= $slideshow_data['delay'];
+			$steps		= array();
+			$db_steps = DBselect('select * from slides where slideshowid='.$_REQUEST['slideshowid'].' order by step');
+			while($step_data = DBfetch($db_steps))
+			{
+				$steps[$step_data['step']] = array(
+						'screenid' => $step_data['screenid'],
+						'delay' => $step_data['delay']
+					);
+			}
+		}
+		
+		$form->AddRow(S_NAME, new CTextBox('name', $name, 40));
+		
+		$form->AddRow(S_UPDATE_INTERVAL_IN_SEC, new CNumericBox("delay",$delay,5));
+		
+		$tblSteps = new CTableInfo(S_NO_SLIDES_DEFINED);
+		$tblSteps->SetHeader(array(S_SCREEN, S_DELAY, SPACE));
+		if(count($steps) > 0)
+		{
+			ksort($steps);
+			$first = min(array_keys($steps));
+			$last = max(array_keys($steps));
+		}
+		foreach($steps as $sid => $s)
+		{
+			if( !isset($s['screenid']) ) $s['screenid'] = 0;
+
+			if(isset($s['delay']) && $s['delay'] > 0 )
+				$s['delay'] = bold($s['delay']);
+			else	
+				$s['delay'] = $delay;
+			
+			$up = null;
+			if($sid != $first)
+			{
+				$up = new CLink(S_UP,'#','action');
+				$up->OnClick("return create_var('".$form->GetName()."','move_up',".$sid.", true);");
+			}
+			
+			$down = null;
+			if($sid != $last)
+			{
+				$down = new CLink(S_DOWN,'#','action');
+				$down->OnClick("return create_var('".$form->GetName()."','move_down',".$sid.", true);");
+			}
+			
+			$screen_data = get_screen_by_screenid($s['screenid']);
+			$name = new CLink($screen_data['name'],'#','action');
+			$name->OnClick("return create_var('".$form->GetName()."','edit_step',".$sid.", true);");
+			
+			$tblSteps->AddRow(array(
+				array(new CCheckBox('sel_step[]',null,null,$sid), $name),
+				$s['delay'],
+				array($up, isset($up) && isset($down) ? SPACE : null, $down)
+				));
+		}
+		$form->AddVar('steps', $steps);
+
+		$form->AddRow(S_SLIDES, array(
+			$tblSteps,
+			!isset($new_step) ? new CButton('add_step',S_ADD,
+				"return create_var('".$form->GetName()."','add_step',1, true);") : null,
+			(count($steps) > 0) ? new CButton('del_sel_step',S_DELETE_SELECTED) : null
+			));
+
+		if(isset($new_step))
+		{
+			if( !isset($new_step['screenid']) )	$new_step['screenid'] = 0;
+			if( !isset($new_step['delay']) )	$new_step['delay'] = 0;
+
+			if( isset($new_step['sid']) )
+				$form->AddVar('new_step[sid]',$new_step['sid']);
+
+			$form->AddVar('new_step[screenid]',$new_step['screenid']);
+
+			$screen_data = get_screen_by_screenid($new_step['screenid']);
+
+			$form->AddRow(S_NEW_SLIDE, array(
+					new CTextBox('screen_name', $screen_data['name'], 25, 'yes'),
+					new CButton('select_screen',S_SELECT,
+						'return PopUp("popup.php?dstfrm='.$form->GetName().'&srctbl=screens'.
+						'&dstfld1=screen_name&srcfld1=name'.
+						'&dstfld2=new_step%5Bscreenid%5D&srcfld2=screenid");'),
+					S_DELAY,
+					new CNumericBox('new_step[delay]', $new_step['delay'], 5), BR,
+					new CButton('add_step', isset($new_step['sid']) ? S_SAVE : S_ADD),
+					new CButton('cancel_step', S_CANCEL)
+
+				),
+				isset($new_step['sid']) ? 'edit' : 'new');
+		}
+		
+		$form->AddItemToBottomRow(new CButton("save",S_SAVE));
+		if(isset($_REQUEST['slideshowid']))
+		{
+			$form->AddItemToBottomRow(SPACE);
+			$form->AddItemToBottomRow(new CButton('clone',S_CLONE));
+			$form->AddItemToBottomRow(SPACE);
+			$form->AddItemToBottomRow(new CButtonDelete(S_DELETE_SLIDESHOW_Q,
+				url_param('form').url_param('slideshowid').url_param('configid')));
+		}
+		$form->AddItemToBottomRow(SPACE);
+		$form->AddItemToBottomRow(new CButtonCancel());
+
+                $form->Show();
+	}
+
 	function	insert_drule_form()
 	{
 		$frm_title = S_DISCOVERY_RULE;
@@ -3327,6 +3458,8 @@ include_once 'include/discovery.inc.php';
 		$frmScr = new CFormTable($frm_title,"screenconf.php");
 		$frmScr->SetHelp("web.screenconf.screen.php");
 
+		$frmScr->AddVar('configid', 0);
+
 		if(isset($_REQUEST["screenid"]))
 		{
 			$frmScr->AddVar("screenid",$_REQUEST["screenid"]);
@@ -3338,6 +3471,8 @@ include_once 'include/discovery.inc.php';
 		$frmScr->AddItemToBottomRow(new CButton("save",S_SAVE));
 		if(isset($_REQUEST["screenid"]))
 		{
+			$form->AddItemToBottomRow(SPACE);
+			$form->AddItemToBottomRow(new CButton('clone',S_CLONE));
 			$frmScr->AddItemToBottomRow(SPACE);
 			$frmScr->AddItemToBottomRow(new CButtonDelete(S_DELETE_SCREEN_Q,
 				url_param("form").url_param("screenid")));
diff --git a/frontends/php/include/locales/en_gb.inc.php b/frontends/php/include/locales/en_gb.inc.php
index 483b27c8..7782bbb0 100644
--- a/frontends/php/include/locales/en_gb.inc.php
+++ b/frontends/php/include/locales/en_gb.inc.php
@@ -993,6 +993,16 @@
 	'S_EDIT'=>				'Edit',
 	'S_DIMENSION_COLS_ROWS'=>		'Dimension (cols x rows)',
 
+	'S_SLIDESHOWS'=>			'Slideshows',
+	'S_SLIDESHOW'=>				'Slideshow',
+	'S_CONFIGURATION_OF_SLIDESHOWS_BIG'=>	'CONFIGURATION OF SLIDESHOWS',
+	'S_SLIDESHOWS_BIG'=>			'SLIDESHOWS',
+	'S_NO_SLIDESHOWS_DEFINED'=>		'No slideshows defined',
+	'S_COUNT_OF_SLIDES'=>			'Count of slides',
+	'S_NO_SLIDES_DEFINED'=>			'No slides defined',
+	'S_SLIDES'=>				'Slides',
+	'S_NEW_SLIDE'=>				'New slide',
+
 //	screenedit.php
 	'S_MAP'=>				'Map',
 	'S_AS_PLAIN_TEXT'=>			'As plain text',
@@ -1035,6 +1045,14 @@
 	'S_SELECT_SCREEN_DOT_DOT_DOT'=>		'Select screen ...',
 	'S_NO_SCREENS_DEFINED'=>		'No screens defined',
 
+	'S_SLIDESHOW_UPDATED'=>			'Slideshow updated',
+	'S_CANNOT_UPDATE_SLIDESHOW'=>		'Cannot_update slideshow',
+	'S_SLIDESHOW_ADDED'=>			'Slideshow added',
+	'S_CANNOT_ADD_SLIDESHOW'=>		'Cannot add slideshow',
+	'S_SLIDESHOW_DELETED'=>			'Slideshow deleted',
+	'S_CANNOT_DELETE_SLIDESHOW'=>		'Cannot delete slideshow',
+	'S_DELETE_SLIDESHOW_Q'=>		'Delete slideshow?',
+
 //	services.php
 	'S_ROOT_SMALL'=>			'root',
 	'S_IT_SERVICE'=>			'IT service',
@@ -1066,7 +1084,7 @@
 	'S_ACCEPTABLE_SLA_IN_PERCENT'=>		'Acceptabe SLA (in %)',
 	'S_LINK_TO_TRIGGER_Q'=>			'Link to trigger?',
 	'S_SORT_ORDER_0_999'=>			'Sort order (0->999)',
-	'S_DELETE_SERVICE_Q'=>			'S_DELETE_SERVICE_Q',
+	'S_DELETE_SERVICE_Q'=>			'Delete service?',
 	'S_LINK_TO'=>				'Link to',
 	'S_SOFT_LINK_Q'=>			'Soft link?',
 	'S_ADD_SERVER_DETAILS'=>		'Add server details',
diff --git a/frontends/php/include/screens.inc.php b/frontends/php/include/screens.inc.php
index 070a4a44..d8bcd58f 100644
--- a/frontends/php/include/screens.inc.php
+++ b/frontends/php/include/screens.inc.php
@@ -114,6 +114,9 @@
                 $result=DBexecute("delete from screens_items where resourceid=$screenid and resourcetype=".SCREEN_RESOURCE_SCREEN);
                 if(!$result)	return  $result;
 
+		$result=DBexecute('delete from slides where screenid='.$screenid);
+		if(!$result)    return  $result;
+
                 return  DBexecute("delete from screens where screenid=$screenid");
         }
 
@@ -155,7 +158,7 @@
 		{
 			return	$row;
 		}
-		error("No screen with screenid=[$screenid]");
+		// error("No screen with screenid=[$screenid]");
 		return FALSE;
 	}
 
@@ -214,7 +217,7 @@
 			}
 		}
 		$table = new CTable(
-			new CLink("No rows in screen ".$row["name"],"screenconf.php?form=update&screenid=".$screenid),
+			new CLink("No rows in screen ".$row["name"],"screenconf.php?config=0&form=update&screenid=".$screenid),
 			($editmode == 0 || $editmode == 2) ? "screen_view" : "screen_edit");
 	
 		for($r=0;$r<$row["vsize"];$r++)
@@ -400,4 +403,105 @@
 		}
 		return $table;
 	}
+
+	function	slideshow_accessiable($slideshowid, $perm)
+	{
+		global $USER_DETAILS;
+
+		$result = false;
+
+		if(DBselect("select slideshowid from slideshows where slideshowid=".$slideshowid.
+			" and ".DBid2nodeid('slideshowid')." in (".get_accessible_nodes_by_user($USER_DETAILS,$perm).")"))
+		{
+			$result = true;
+			$db_slides = DBselect('select distinct screenid from slides where slideshowid='.$slideshowid);
+			while($slide_data = DBfetch($db_slides))
+			{
+				if( !($result = screen_accessiable($slide_data["screenid"], PERM_READ_ONLY)) ) break;
+			}
+		}
+		return $result;
+	}
+
+	function	get_slideshow_by_slideshowid($slideshowid)
+	{
+		return DBfetch(DBselect('select * from slideshows where slideshowid='.$slideshowid));
+	}
+
+	function	validate_slide($slide)
+	{
+		if(!screen_accessiable($slide["screenid"], PERM_READ_ONLY)) return false;
+
+		if( !is_numeric($slide['delay']) ) return false;
+
+		return true;
+	}
+
+	function	add_slideshow($name, $delay, $slides)
+	{
+		foreach($slides as $slide)
+		{
+			if( !validate_slide($slide) )
+				return false;
+		}
+
+		$slideshowid = get_dbid('slideshows','slideshowid');
+		$result = DBexecute('insert into slideshows (slideshowid,name,delay) '.
+			' values ('.$slideshowid.','.zbx_dbstr($name).','.$delay.')');
+
+		$i = 0;
+		foreach($slides as $slide)
+		{
+			$slideid = get_dbid('slides','slideid');
+			if( !($result = DBexecute('insert into slides (slideid,slideshowid,screenid,step,delay) '.
+				' values ('.$slideid.','.$slideshowid.','.$slide['screenid'].','.($i++).','.$slide['delay'].')')) )
+			{
+				break;
+			}
+		}
+		
+		if( !$result )
+		{
+			delete_slideshow($slideshowid);
+			return false;
+		}
+		return $slideshowid;
+	}
+
+	function	update_slideshow($slideshowid, $name, $delay, $slides)
+	{
+		foreach($slides as $slide)
+		{
+			if( !validate_slide($slide) )
+				return false;
+		}
+
+		if( !($result = DBexecute('update slideshows set name='.zbx_dbstr($name).',delay='.$delay.' where slideshowid='.$slideshowid)) )
+			return false;
+
+		DBexecute('delete from slides where slideshowid='.$slideshowid);
+
+		$i = 0;
+		foreach($slides as $slide)
+		{
+			$slideid = get_dbid('slides','slideid');
+			if( !($result = DBexecute('insert into slides (slideid,slideshowid,screenid,step,delay) '.
+				' values ('.$slideid.','.$slideshowid.','.$slide['screenid'].','.($i++).','.$slide['delay'].')')) )
+			{
+				return false;
+			}
+		}
+		
+		return true;
+	}
+
+	function	delete_slideshow($slideshowid)
+	{
+		return (
+			DBexecute('delete from slideshows where slideshowid='.$slideshowid) &&
+			DBexecute('delete from slides where slideshowid='.$slideshowid)
+		);
+	}
+
+
 ?>