power_pdu.php

<?php
	require_once( 'db.inc.php' );
	require_once( 'facilities.inc.php' );

	$pdu=new PowerDistribution();
	$cab=new Cabinet();
	$powerConn=new PowerConnection();
	$connDev=new Device();
	$template=new CDUTemplate();
	$templateList=$template->GetTemplateList();
	$manufacturer=new Manufacturer();
	$upTime='';

	// Ajax actions
	// List of devices in the rack
	if(isset($_POST['c'])){
		$connDev->Cabinet=$_POST['c'];
		header('Content-Type: application/json');
		$devices=$connDev->ViewDevicesByCabinet();
		// filter for rights
		foreach($devices as $i => $dev){
			if($dev->Rights!="Write"){unset($devices[$i]);}
		}
		echo json_encode($devices);
		exit;
	}
	if(isset($_POST['pdu'])){
		$powerConn->PDUID=$_POST['pdu'];
		$powerConn->PDUPosition=$_POST['output'];
		$powerConn->GetPDUConnectionByPosition();
		if(isset($_POST['deviceid']) && isset($_POST['devinput'])){
			$powerConn->DeviceID=$_POST['deviceid'];
			$powerConn->DeviceConnNumber=$_POST['devinput'];
			if($powerConn->DeviceID=="" || $powerConn->DeviceConnNumber==""){
				$powerConn->RemoveConnection();
				echo 1;
			}else{
				echo $powerConn->CreateConnection();
			}
			exit;
		}
		if(isset($_POST['output'])){
			header('Content-Type: application/json');
			$connDev->DeviceID=$powerConn->DeviceID;
			$connDev->GetDevice();
			$powerConn->DeviceLabel=$connDev->Label;
			echo json_encode($powerConn);
			exit;
		}
		exit;
	}

	if(isset($_REQUEST['pid']) && isset($_POST['confirmdelete'])){
		$pdu->PDUID=$_POST['pid'];
		if($pdu->DeletePDU()){
			echo 'ok';
		}else{
			echo 'no';
		}
		exit;
	}

	if(isset($_POST['test'])){
		$pdu->PDUID=$_POST["test"];
		$pdu->GetPDU();
		
		$template=new CDUTemplate();
		$template->TemplateID=$pdu->TemplateID;
		$template->GetTemplate();
		
		printf( "<p>%s %s.<br>\n", __("Testing SNMP communication to CDU"), $pdu->Label );
		printf( "%s %s.<br>\n", __("Connecting to IP address"), $pdu->IPAddress );
		if ( $pdu->SNMPCommunity != "" ) {
			$Community = $pdu->SNMPCommunity;
			printf( "%s %s.</p>\n", __("Using SNMP Community string"), $Community );
		} else {
			$Community = $config->ParameterArray["SNMPCommunity"];
			printf( "%s %s.</p>\n", __("Using default SNMP Community string"), $Community );
		}
		
		print "<div id=\"infopanel\"><fieldset><legend>".__("Results")."</legend>\n";

		if ( $template->ATS ) {
			$ATSStatus = $pdu->getATSStatus();
			printf( "ATS Status returned = %s.  Desired status = %s.\n", $ATSStatus, $template->ATSDesiredResult );
		}
		
		$upTime=$pdu->GetSmartCDUUptime();
		if($upTime!=""){
			printf("<p>%s: %s</p>\n", __("SNMP Uptime"),$upTime);
		}else{
			print "<p>".__("SNMP Uptime did not return a valid value.")."</p>\n";
		}
		
		$cduVersion = $pdu->GetSmartCDUVersion();
		if($cduVersion != ""){
			printf( "<p>%s %s.  %s</p>\n", __("VersionOID returned a value of"), $cduVersion, __("Please check to see if it makes sense.") );
		}else{
			print "<p>".__("The OID for Firmware Version did not return a value.  Please check your MIB table.")."</p>\n";
		}
		
		if ( ! function_exists( "snmpget" ) ) {
			$OIDString=$template->OID1." ".$template->OID2." ".$template->OID3;
			$pollCommand=sprintf( "%s -v %s -c %s %s %s | %s -d: -f4", $config->ParameterArray["snmpget"], $template->SNMPVersion, $Community, $pdu->IPAddress, $OIDString, $config->ParameterArray["cut"] );
			
			exec($pollCommand,$statsOutput);
			
			$result1 = @$statsOutput[0];
			$result2 = @$statsOutput[1];
			$result3 = @$statsOutput[2];
		} else {
			if ( $template->SNMPVersion == "2c" ) {
				$tmp1 = explode( " ", snmp2_get( $pdu->IPAddress, $Community, $template->OID1 ));
				$result1 = $tmp1[1];
				
				if ( $template->OID2 != "" ) {
					$tmp2 = explode( " ", snmp2_get( $pdu->IPAddress, $Community, $template->OID2 ));
					$result2 = $tmp2[1];
				}
				
				if ( $template->OID3 != "" ) {
					$tmp3 = explode( " ", snmp2_get( $pdu->IPAddress, $Community, $template->OID3 ));
					$result3 = $tmp3[1];
				}
			} else {
				$tmp1 = explode( " ", snmpget( $pdu->IPAddress, $Community, $template->OID1 ));
				$result1 = $tmp1[1];
				
				if ( $template->OID2 != "" ) {
					$tmp2 = explode( " ", snmpget( $pdu->IPAddress, $Community, $template->OID2 ));
					$result2 = $tmp2[1];
				}
				
				if ( $template->OID3 != "" ) {
					$tmp3 = explode( " ", snmpget( $pdu->IPAddress, $Community, $template->OID3 ));
					$result3 = $tmp3[1];
				}
			}
		}
		
		if($result1!=""){
			printf( "<p>%s %s.  %s</p>\n", __("OID1 returned a value of"), $result1, __("Please check to see if it makes sense.") );
		}else{
			print "<p>".__("OID1 did not return any data.  Please check your MIB table.")."</p>\n";
		}
		
		if((strlen($template->OID2) >0)&&(strlen($result2) >0)){
			printf( "<p>%s %s.  %s</p>\n", __("OID2 returned a value of"), $result2, __("Please check to see if it makes sense.") );
		}elseif(strlen($template->OID2) >0){
			print "<p>".__("OID2 did not return any data.  Please check your MIB table.")."</p>\n";
		}

		if((strlen($template->OID3) >0)&&(strlen($result3) >0)){
			printf( "<p>%s %s.  %s</p>\n", __("OID3 returned a value of"), $result3, __("Please check to see if it makes sense.") );
		}elseif(strlen($template->OID3)){
			print "<p>".__("OID3 did not return any data.  Please check your MIB table.")."</p>\n";
		}
		
		switch($template->ProcessingProfile){
			case "SingleOIDAmperes":
				$amps=intval($result1)/floatval($template->Multiplier);
				$watts=$amps*intval($template->Voltage);
				break;
			case "Combine3OIDAmperes":
				$amps=(intval($result1)+intval($result2)+intval($result3))/floatval($template->Multiplier);
				$watts=$amps*intval($template->Voltage);
				break;
			case "Convert3PhAmperes":
				$amps=(intval($result1)+intval($result2)+intval($result3))/floatval($template->Multiplier)/3;
				$watts=$amps*1.732*intval($template->Voltage);
				break;
			case "Combine3OIDWatts":
				$watts=(intval($result1)+intval($result2)+intval($result3))/floatval($template->Multiplier);
				break;
			default:
				$watts=intval($result1)/floatval($template->Multiplier);
				break;
		}
		
		printf("<p>%s %.2f kW</p>", __("Resulting kW from this test is"),$watts/1000);

		echo '	</fieldset></div>';
		exit;
	}

	// END - Ajax


	if(isset($_REQUEST['pduid'])){
		$pdu->PDUID=(isset($_REQUEST['pduid'])?(isset($_POST['pduid']))?$_POST['pduid']:$_GET['pduid']:$_GET['pduid']);
	}else{
		echo 'Do not call this file directly';
		exit;
	}

	$pdu->GetPDU();
	$cab->CabinetID=(isset($_REQUEST['cabinetid']))?$_REQUEST['cabinetid']:$pdu->CabinetID;
	$cab->GetCabinet();

	if(isset($_REQUEST['action']) && (($_REQUEST['action']=='Create') || ($_REQUEST['action']=='Update')) && $user->canWrite($cab->AssignedTo)) {
		$pdu->Label=$_REQUEST['label'];
		$pdu->CabinetID=$_REQUEST['cabinetid'];
		$pdu->TemplateID=$_REQUEST['templateid'];
		$pdu->IPAddress=$_REQUEST['ipaddress'];
		$pdu->SNMPCommunity=$_REQUEST['snmpcommunity'];
		$pdu->PanelID=$_REQUEST['panelid'];
		$pdu->BreakerSize=$_REQUEST['breakersize'];
		$pdu->PanelPole=$_REQUEST['panelpole'];
		$pdu->InputAmperage=$_REQUEST['inputamperage'];
		// If failsafe is unset clear auto transfer switch panel information
		if(isset($_REQUEST['failsafe'])){
			$pdu->FailSafe=1;
			$pdu->PanelID2=$_REQUEST['panelid2'];
			$pdu->PanelPole2=$_REQUEST['panelpole2'];
		}else{
			$pdu->FailSafe=0;
			$pdu->PanelID2="";
			$pdu->PanelPole2="";
		}

		if($_REQUEST['action']=='Create'){
			$ret=$pdu->CreatePDU();
		}else{
			$pdu->PDUID = $_REQUEST['pduid'];
			$pdu->UpdatePDU();
		}
	}

	if($pdu->PDUID >0){
		$upTime=$pdu->GetSmartCDUUptime();
		
		$template->TemplateID=$pdu->TemplateID;
		$template->GetTemplate();
	} else {
		$pdu->CabinetID=$_REQUEST['cabinetid'];
	}

	$cab->CabinetID=$pdu->CabinetID;
	$cab->GetCabinet();

	$write=$user->canWrite($cab->AssignedTo);
	
	$Panel=new PowerPanel();
	$PanelList=$Panel->GetPanelList();
	/* For strict panel selection, comment out the line above and uncomment the following line */
	// $PanelList = $Panel->GetPanelsByDataCenter( $cab->DataCenterID,  );

	$powerConn->PDUID=$pdu->PDUID;
	$connList=$powerConn->GetConnectionsByPDU();

	$title=($pdu->Label!='')?"$pdu->Label :: $pdu->PDUID":'Data Center PDU Detail';

?>
<!doctype html>
<html>
<head>
  <meta http-equiv="X-UA-Compatible" content="IE=Edge">
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  
  <title><?php echo $title; ?></title>
  <link rel="stylesheet" href="css/inventory.php" type="text/css">
  <link rel="stylesheet" href="css/jquery-ui.css" type="text/css">
  <link rel="stylesheet" href="css/print.css" type="text/css" media="print">
  <!--[if lt IE 9]>
  <link rel="stylesheet"  href="css/ie.css" type="text/css">
  <![endif]-->

  <script type="text/javascript" src="scripts/jquery.min.js"></script>
  <script type="text/javascript" src="scripts/jquery-ui.min.js"></script>
  <script type="text/javascript">
	$(document).ready(function() {
		$('#panelid').change( function(){
			$.get('scripts/ajax_panel.php?q='+$(this).val(), function(data) {
				$('#voltage').html(data['PanelVoltage'] +'/'+ Math.floor(data['PanelVoltage']/1.73));
			});
		});
		$('#pdutestlink').click(function(e){
			e.preventDefault();
			$.post('power_pdu.php', {test: $('#pduid').val()}, function(data){
				$('#pdutest').html(data);
			});
			$('#pdutest').dialog({minWidth: 450, maxWidth: 450, closeOnEscape: true });
		});
		$('.center > div + div > .table > div:first-child ~ div').each(function(){
			var row=$(this);
			var output=row.find('div:first-child');
			if(portrights[output.text()]){
				output.click(function(){
					if(!row.data('edit')){
						function update(){
							if(input.val()=='' && select.val()==''){
								save();
							}else if(input.val()!='' && select.val()!=''){
								save();
							}
						}
						var pduid=$('#pduid');
						var cabid=$('#cabinetid').val();
						var option=$('<option>');
						var select=$('<select>').append(option).on('focusout',update).css('background-color','transparent');
						var input=$('<input>').on('focusout',update).css('background-color','transparent');
						var btn_delete=$('<button>').text('Delete');
						var btn_cancel=$('<button>').text('Cancel');
						var controls=$('<div>').css('padding','0px').append(btn_delete).append(btn_cancel);
						var device=output.next();
						var devinput=device.next();
						var width=devinput.width();
						btn_delete.click(function(){
							select.val('');
							input.val('');
							select.focus();
							input.focus();
						});
						btn_cancel.click(function(){
							redraw();
						});
						function save(){
							$.post('',{pdu: $('#pduid').val(), output: output.text(), deviceid: select.val(), devinput: input.val()}).done(function(data){
								if(data.trim()=='1'){
									//success
									row.effect('highlight', {color: 'lightgreen'}, 1500);
									redraw();
								}else{
									//fail
									row.effect('highlight', {color: 'salmon'}, 1500);
								}
							});
						}
						function redraw(){
							$.post('',{pdu: $('#pduid').val(), output: output.text()}).done(function(data){
								var link=$('<a>').text(data.DeviceLabel).prop('href','devices.php?deviceid='+data.DeviceID);
								device.data('device',data.DeviceID).html(link).prop('style','');
								devinput.data('input',data.DeviceConnNumber).text(data.DeviceConnNumber).prop('style','');
								controls.remove();
								row.data('edit',false);
							});
						}
						row.data('edit', true);
						$.post('',{c: cabid}).done(function(data){
							$.each(data, function(i,dev){
								select.append(option.clone().val(dev.DeviceID).text(dev.Label));
							});
							device.html(select.val(device.data('device'))).css('padding','0px');
							devinput.html(input.val(devinput.data('input')).width(width)).css('padding','0px');
							row.append(controls);
						});
					}
				}).css({'cursor': 'pointer', 'text-decoration': 'underline'});
			}
		});
		$('.main button[value=Delete]').click(function(){
			var defaultbutton={
				"<?php echo __("Yes"); ?>": function(){
					$.post('', {pid: $('#pduid').val(),confirmdelete: ''}, function(data){
						if(data.trim()=='ok'){
							self.location=$('.main > a').last().attr('href');
							$(this).dialog("destroy");
						}else{
							alert('Nope');
						}
					});
				}
			}
			var cancelbutton={
				"<?php echo __("No"); ?>": function(){
					$(this).dialog("destroy");
				}
			}
<?php echo "			var modal=$('<div />', {id: 'modal', title: '".__("PDU Deletion Confirmation")."'}).html('<div id=\"modaltext\">".__("Are you sure that you want to delete this PDU and all the power connections on it?")."</div>').dialog({"; ?>
				dialogClass: 'no-close',
				appendTo: 'body',
				modal: true,
				buttons: $.extend({}, defaultbutton, cancelbutton)
			});
		});
	});
  </script>


</head>
<body>
<div id="header"></div>
<div class="page pdu">
<?php
	include( 'sidebar.inc.php' );

echo '<div class="main">
<h2>',$config->ParameterArray["OrgName"],'</h2>
<h3>',__("Data Center PDU Detail"),'</h3>
<div class="center"><div>
<form name="pduform" id="pduform" action="',$_SERVER["PHP_SELF"],'" method="POST">
<div class="table">
<div>
   <div><label for="pduid">',__("PDU ID"),'</label></div>
   <div><input type="text" name="pduid" id="pduid" value="',$pdu->PDUID,'" size="6" readonly></div>
</div>
<div>
   <div><label for="label">',__("Label"),'</label></div>
   <div><input type="text" name="label" id="label" size="50" value="',$pdu->Label,'"></div>
</div>
<div>
   <div><label for="cabinetid">',__("Cabinet"),'</label></div>
   <div>',$cab->GetCabinetSelectList(),'</div>
</div>
<div>
   <div><label for="panelid">',__("Source Panel"),'</label></div>
   <div><select name="panelid" id="panelid" ><option value=0>',__("Select Panel"),'</option>';

foreach($PanelList as $key=>$value){
	if($value->PanelID == $pdu->PanelID){$selected=' selected';}else{$selected="";}
	print "<option value=\"$value->PanelID\"$selected>$value->PanelLabel</option>\n"; 
}

echo '   </select></div>
</div>
<div>
	<div><label for="voltage">',__("Voltages:"),'</label></div>
	<div id="voltage">';

	if($pdu->PanelID >0){
		$pnl=new PowerPanel();
		$pnl->PanelID=$pdu->PanelID;
		$pnl->GetPanel();
	
		print $pnl->PanelVoltage." / ".intval($pnl->PanelVoltage/1.73);
	}

echo '	</div>
</div>
<div>
  <div><label for="breakersize">',__("Breaker Size (# of Poles)"),'</label></div>
  <div>
	<select name="breakersize">';

	for($i=1;$i<4;$i++){
		if($i==$pdu->BreakerSize){$selected=" selected";}else{$selected="";}
		print "<option value=\"$i\"$selected>$i</option>";
	}

echo '	</select>
  </div>
</div>
<div>
  <div><label for="panelpole">',__("Panel Pole Number"),'</label></div>
  <div><input type="text" name="panelpole" id="panelpole" size=5 value="',$pdu->PanelPole,'"></div>
</div>
<div>
   <div><label for="inputamperage">',__("Input Amperage"),'</label></div>
   <div><input type="text" name="inputamperage" id="inputamperage" size=5 value="',$pdu->InputAmperage,'"></div>
</div>
<div>
	<div><label for="templateid">',__("CDU Template"),'</label></div>
	<div><select name="templateid" id="templateid">';

	foreach($templateList as $templateRow){
		$manufacturer->ManufacturerID=$templateRow->ManufacturerID;
		$manufacturer->GetManufacturerByID();
		
		$selected=($pdu->TemplateID==$templateRow->TemplateID)?" selected":"";		
		print "		<option value=$templateRow->TemplateID$selected>[$manufacturer->Name] $templateRow->Model</option>\n";
	}
	
echo '   </select></div>
</div>
<div>
   <div><label for="ipaddress">',__("IP Address"),'</label></div>
   <div><input type="text" name="ipaddress" id="ipaddress" size=15 value="',$pdu->IPAddress,'">',((strlen($pdu->IPAddress)>0)?"<a href=\"http://$pdu->IPAddress\" target=\"new\">http://$pdu->IPAddress</a>":""),'</div>
</div>
<div>
    <div>',__("Uptime"),'</div>
    <div>',$upTime,'</div>
</div>
<div>
    <div>',__("Firmware Version"),'</div>
    <div>',$pdu->FirmwareVersion,'</div>
</div>
<div>
   <div><label for="snmpcommunity">',__("SNMP Community"),'</label></div>
   <div><input type="text" name="snmpcommunity" id="snmpcommunity" size=15 value="',$pdu->SNMPCommunity,'"><a id="pdutestlink" href="#">', __("Test Communications"), '</a></div>
</div>
<div class="caption">
<h3>',__("Automatic Transfer Switch"),'</h3>
<fieldset id="powerinfo">
<div class="table centermargin border">
<div>
  <div><label for="failsafe">',__("Fail Safe Switch?"),'</label></div>
  <div><input type="checkbox" name="failsafe" id="failsafe"',(($pdu->FailSafe)?" checked":""),'></div>
</div>
<div>
   <div><label for="panelid2">',__("Source Panel (Secondary Source)"),'</label></div>
   <div><select name="panelid2" id="panelid2"><option value=0>',__("Select Panel"),'</option>';

	foreach($PanelList as $key=>$value){
		if($value->PanelID==$pdu->PanelID2){$selected=" selected";}else{$selected="";}
		print "		<option value=$value->PanelID$selected>$value->PanelLabel</option>\n";
	}

echo '   </select></div>
</div>
<div>
  <div><label for="panelpole2">',__("Panel Pole Number (Secondary Source)"),'</label></div>
  <div><input type="text" name="panelpole2" id="panelpole2" size=4 value="',$pdu->PanelPole2,'"></div>
</div>
<div class="caption">';

	if($pdu->PDUID >0){
		if($write || $user->SiteAdmin){
			echo '   <button type="submit" name="action" value="Update">',__("Update"),'</button>';
			if($user->SiteAdmin){
				echo '   <button type="button" name="action" value="Delete">',__("Delete"),'</button>';
			}
		}
	}else{
		if($write || $user->SiteAdmin){
			echo '   <button type="submit" name="action" value="Create">',__("Create"),'</button>';
		}
	}

echo '</div>
</div> <!-- END div.table -->
</div>
</div> <!-- END div.table -->
</form>

</div><div>

<div class="table border">
	<div>
		<div>',__("Output No."),'</div>
		<div>',__("Device Name"),'</div>
		<div>',__("Dev Input No"),'</div>
	</div>';

	$portrights=array();
	for($connNumber=1; $connNumber<$template->NumOutlets+1; $connNumber++){
		if(isset($connList[$connNumber])){
			$connDev->DeviceID=$connList[$connNumber]->DeviceID;
			$connDev->GetDevice();
			$portrights[$connNumber]=($connDev->Rights=="Write")?true:$write;
			print "	<div>\n		<div>$connNumber</div>\n		<div alt=\"{$connList[$connNumber]->DeviceID}\" data-device=\"{$connList[$connNumber]->DeviceID}\"><a href=\"devices.php?deviceid={$connList[$connNumber]->DeviceID}\">$connDev->Label</a></div>\n		<div data-input=\"{$connList[$connNumber]->DeviceConnNumber}\">{$connList[$connNumber]->DeviceConnNumber}</div>\n	</div>\n";
		}else{
			$portrights[$connNumber]=$write;
			print "	<div>\n		<div>$connNumber</div>\n		<div alt=\"\"></div>\n		<div></div>\n	</div>\n";
		}
	}
	
	// If there are any connections > NumOutlets, print them as ghosts
	foreach ( $connList as $ghostConnection ) {
		if ( $ghostConnection->PDUPosition > $template->NumOutlets ) {
			$connDev->DeviceID=$ghostConnection->DeviceID;
			$connDev->GetDevice();
			$portrights[$connNumber]=($connDev->Rights=="Write")?true:$write;
			print "	<div>\n		<div>$ghostConnection->PDUPosition</div>\n		<div alt=\"{$ghostConnection->DeviceID}\" data-device=\"{$ghostConnection->DeviceID}\"><a href=\"devices.php?deviceid={$ghostConnection->DeviceID}\">$connDev->Label</a></div>\n		<div data-input=\"{$ghostConnection->DeviceConnNumber}\">{$ghostConnection->DeviceConnNumber}</div>\n	</div>\n";
		}
	}
?>  
    </div> <!-- END div.table -->
</div></div>

<div id="pdutest" title="Testing SNMP Communications"></div>

<?php echo '<a href="cabnavigator.php?cabinetid=',$cab->CabinetID,'">[ ',__("Return to Navigator"),' ]</a>'; ?>
</div><!-- END div.main -->
</div><!-- END div.page -->
<script type="text/javascript">
	var portrights=$.parseJSON('<?php echo json_encode($portrights); ?>');

<?php
	if($pdu->PDUID >0 && !$write){
		print "$('.main select, .main input').prop('disabled', true);";
	}
?>
</script>
</body>
</html>