Разработка автоматизированной системы управления деятельностью компании

Выбор способа организации данных для проектирования системы. Структурная схема автоматизированной концепции управления деятельностью компании. Анализ описания клиентской части программного обеспечения. Особенность копирования и перемещения документов.

Рубрика Программирование, компьютеры и кибернетика
Вид дипломная работа
Язык русский
Дата добавления 10.10.2015
Размер файла 1,7 M

Отправить свою хорошую работу в базу знаний просто. Используйте форму, расположенную ниже

Студенты, аспиранты, молодые ученые, использующие базу знаний в своей учебе и работе, будут вам очень благодарны.

@dir_counter = `/bin/ls /mnt/1wire `;

foreach $dir_counter (@dir_counter){

chomp ($dir_counter);

if($dir_counter!~/^\d{2}\./i){next;}

if ($dir_counter =~ /(10\.[0-9a-z]+)/i){

$temperature = `/bin/cat /mnt/1wire/$1/temperature | /bin/tr -d " "`;

}

if ($dir_counter =~ /(20\.[0-9a-z]+)/i){

$volt_A = `/bin/cat /mnt/1wire/$1/volt.D | /bin/tr -d " "`;

if ( $volt_A && ( $volt_A < 2 ) && !$smoke ){

$smoke=1;

}

if($volt_A>2){ # stop smoke!

$smoke=0;

gsmsendsms -d /dev/ttyU0 89506282887 "Дым!";

}

}

} # end of foreach dir_count

if((time()-$last_climat_log>60) || ($t1!=$temperature) || ($s1!=$smoke)){

$s1=$smoke;

if(($temperature==0) && ($t1!=0)){$temperature=$t1;}

$t1=$temperature;

$last_climat_log=time();

If($temperature>39)

{

gsmsendsms -d /dev/ttyU0 89506282887 "Очень высокая температура!";

}

If($temperature<6)

{

gsmsendsms -d /dev/ttyU0 89506282887 "Очень низкая температура!";

}

$query="INSERT INTO climat (rack_id,ddate,t,hum,smoke) values (1,time(),'$temperature',0,'$smoke')";

$sth1 = $dbh->prepare($query);

$sth1->execute || die "ERROR: ".$sth1->errstr;

}

sleep 1;

}

exit 0;

rradupdate.pl

#!/bin/bash

BattL=$(/usr/upsman/psp/sendups -cmd Bl -t 10000 | cut -f 3 -d "[" | cut -f 1 -d "]");

InV=$(/usr/upsman/psp/sendups -cmd Uv -t 10000 | cut -f 3 -d "[" | cut -f 1 -d "]");

InF=$(/usr/upsman/psp/sendups -cmd Uf -t 10000 | cut -f 3 -d "[" | cut -f 1 -d "]");

OutV=$(/usr/upsman/psp/sendups -cmd Lv -t 10000 | cut -f 3 -d "[" | cut -f 1 -d "]");

OutF=$(/usr/upsman/psp/sendups -cmd Lf ? -t 10000 | cut -f 3 -d "[" | cut -f 1 -d "]");

Ld=$(/usr/upsman/psp/sendups -cmd Ll -t 10000 | cut -f 3 -d "[" | cut -f 1 -d "]");

/usr/local/rrdtool-1.2.15/bin/rrdtool update /var/log/ups/mge1.rrd N:$BattL:$InV:$InF:$OutV:$OutF:$Ld;

echo $BattL,$InV,$InF,$OutV,$OutF,$Ld > /var/log/ups/mge1.log;

# Insert UPS parameters into BoxMon DB (mysql)

UpsMode=$InV; # 0-normal, 1-battery

/usr/upsman/psp/boxmon_ups.pl $BattL $Ld $UpsMode;

#echo $InV;

#echo $InF;

#echo $OutV;

#echo $OutF;

#echo $Ld;

Index.php

<?

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

header("Content-Type: text/html; charset=\"windows-1251\"");

include "func.php";

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

?>

<html>

<head>

<title>Система мониторинга</title>

<meta content="text/html; charset=windows-1251" http-equiv="Content-Type">

<link href="style.css" rel="stylesheet" type="text/css">

<script>

function toggle_div(n){

if(document.getElementById('div_contact_'+n).style.display=='none'){

document.getElementById('div_contact_'+n).style.display='';

}else{

document.getElementById('div_contact_'+n).style.display='none';

}

}

function OpenWin(URL, winName, width, height, scroll){

var winLeft = (screen.width - width) / 2;

var winTop = (screen.height - height) / 2;

winData = 'height='+height+',width='+width+',top='+winTop+',left='+winLeft+',scrollbars='+scroll+',resizable';

win = window.open(URL, winName, winData);

if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }

}

var ti=new Array(100);

var i=0;

function ReloadDiv(div_id,url,reload_time){

var XMLHttpRequestObject = false;

if(window.XMLHttpRequest){

XMLHttpRequestObject = new XMLHttpRequest();

}else if(window.ActiveXObject){

XMLHttpRequestObject = new ActiveXObject("Microsoft.XMLHTTP");

}

if(XMLHttpRequestObject){

var newData;

if(div_id!=''){newData = document.getElementById(div_id);}

XMLHttpRequestObject.open("GET", url);

XMLHttpRequestObject.onreadystatechange = function(){

if (XMLHttpRequestObject.readyState == 4 && XMLHttpRequestObject.status == 200){

if(div_id!=''){newData.innerHTML = XMLHttpRequestObject.responseText;}

}

}

XMLHttpRequestObject.send(null);

}

XMLHttpRequestObject.free;

if(reload_time>0){

ti[i++]=setInterval("ReloadDiv('"+div_id+"','"+url+"',0);",reload_time);

}

}

function updateImg(){

var o=document.getElementById('channel_img');

// o.src="http://192.168.110.230/smoke/htdocs/Providers/Sandy_mini.png";

o.src="http://192.168.110.230/smoke/htdocs/Providers/Sandy_mini.png?r="+Math.random();

}

function ReloadAll(){

ReloadDiv('div_rack_info','http://rackmon1.nnx/frames/rack_info.php?id=<? print $rack_id; ?>',5000);

ReloadDiv('div_rack_view','http://rackmon1.nnx/frames/rack_view.php?id=<? print $rack_id; ?>',5000);

ReloadDiv('div_personal_view','http://rackmon1.nnx/frames/personal_info.php?id=<? print $rack_id; ?>',0);

ReloadDiv('div_rack_list','http://rackmon1.nnx/frames/rack_list.php',5000);

ReloadDiv('div_power','http://rackmon1.nnx/frames/power_info.php?id=<? print $rack_id; ?>',5000);

ReloadDiv('div_climat','http://rackmon1.nnx/frames/climat_info.php?id=<? print $rack_id; ?>',5000);

ReloadDiv('div_resources','http://rackmon1.nnx/frames/resource_info.php?id=<? print $rack_id; ?>',5000);

ReloadDiv('','http://rackmon1.nnx/frames/channel_update.php',59000);

qq=setInterval("updateImg();",60000);

ReloadDiv('div_access','http://rackmon1.nnx/frames/access_log.php?id=<? print $rack_id; ?>',5000);

}

</script>

</head>

<body onLoad="ReloadAll();">

<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">

<tr height=29>

<td colspan=2 style="padding-left:5px;"><img src="/pilot/title1.jpg"></td>

<td colspan=2 style="padding-left:5px;"><img src="/pilot/title2.jpg"></td>

<td style="padding-left:5px;"><img src="/pilot/title3.jpg"></td>

</tr>

<tr valign=top height=200>

<td class="box_info" width="450"><?corner_top() ?>

<table height="100%" width="100%" cellspacing="0" cellpadding="0" border="0">

<tr>

<td width="33%"><?corner2_top() ?><div style="padding-left:7px;padding-top:5px" id="div_rack_info"></div><?corner2_bot() ?></td>

<td width="110" valign="top"><div style="padding-left:7px;padding-top:5px" id="div_rack_view"></div></td>

<td swidth="33%" valign="top">

<?corner2a_top() ?>

<table width="120" height="100%" cellspacing="0" cellpadding="0" border="0">

<tr height="20">

<td background="/pilot/arrow1_1.jpg" style="background-repeat:no-repeat" width="13" rowspan=2></td>

<td class="box_info_title">персонал</td>

<td background="/pilot/arrow1_2.jpg" style="background-repeat:no-repeat" width="13" rowspan=2></td>

</tr>

<tr>

<td valign="top" class="box3"><div sssstyle="padding-left:7px;padding-top:5px" id="div_personal_view"></div></td>

</tr>

</table>

<?corner2_bot() ?>

</td>

</tr>

</table>

<?corner_bot() ?>

</td>

<td rowspan=10 width="10">&nbsp;</td>

<td width=400 class="hardware">

<?corner_top() ?>

<?corner2a_top() ?>

<iframe width=100% height=100% style="border:0" src="frames/hw_list.php?id=<? print $rack_id; ?>"></iframe>

<?corner2_bot() ?>

<?corner_bot() ?>

</td>

<td rowspan=4 width="10">&nbsp;</td>

<td rowspan=4 class="box_list" width="300" valign=top height="100%">

<?corner_top() ?>

<?corner2a_top() ?>

<div style="padding-left:7px;padding-top:5px" id="div_rack_list"></div>

<?corner2_bot() ?>

<?corner_bot() ?>

</td>

</tr>

<tr height=3>

<td colspan=2></td>

<td colspan=2></td>

<td></td>

</tr>

<tr height=29>

<td colspan=2 style="padding-left:5px;"><img src="/pilot/title4.jpg"></td>

<td colspan=2 style="padding-left:5px;"><img src="/pilot/title5.jpg"></td>

<td></td>

</tr>

<tr valign=top>

<td class="power">

<?corner_top() ?>

<?corner2a_top() ?>

<div style="padding-left:7px;padding-top:5px" id="div_power"></div>

<?corner2_bot() ?>

<?corner_bot() ?>

</td>

<td class="climat">

<?corner_top() ?>

<?corner2a_top() ?>

<div style="padding-left:7px;padding-top:5px" id="div_climat"></div>

<?corner2_bot() ?>

<?corner_bot() ?>

</td>

</tr>

<tr height=3>

<td colspan=2></td>

<td colspan=2></td>

<td></td>

</tr>

<tr height=29>

<td colspan=2 style="padding-left:5px;"><img src="/pilot/title7.jpg"></td>

<td colspan=3 style="padding-left:5px;"><img src="/pilot/title6.jpg"></td>

<td></td>

</tr>

<tr valign=top>

<td class="resources">

<?corner_top() ?>

<?corner2_top() ?>

<div style="padding-left:7px;padding-top:5px" id="div_resources"></div>

<?corner2_bot() ?>

<?corner_bot() ?>

</td>

<td class="channel" colspan=3>

<?corner_top() ?>

<?corner2_top() ?>

<div style="padding-left:7px;padding-top:5px" id="div_channel"><img src='http://192.168.110.230/smoke/htdocs/Providers/Sandy_mini.png' id='channel_img'></div>

<?corner2_bot() ?>

<?corner_bot() ?>

</td>

</tr>

<tr height=5>

<td colspan=2></td>

<td colspan=2></td>

<td></td>

</tr>

<tr valign=top height=250>

<td colspan="5">

<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">

<tr height=29>

<td width=300 style="padding-left:5px;"><img src="/pilot/title8.jpg"></td>

<td width=300 style="padding-left:5px;"></td>

<td width=300 style="padding-left:5px;"><img src="/pilot/title9.jpg"></td>

</tr>

<tr>

<td class="access_log" colspan=3>

<?corner_top() ?>

<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">

<tr valign=top>

<td width=300><div style="padding-left:7px;padding-top:5px" id="div_access"></div></td>

<td width=300><div style="padding-left:7px;padding-top:5px" id="div_access_pic1"></div></td>

<td width=300><div style="padding-left:7px;padding-top:5px" id="div_access_pic2"></div></td>

</tr>

</table>

<?corner_bot() ?>

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

Func.php

<?

$t_min=5;// минимальная температура (градусы Цельсия)

$t_max=40;// максимальная температура (градусы Цельсия)

$c_min=50;// минимальный заряд (проценты)

$h_nom=100;// номинальный свободный объем (мегабайты)

$h_min=10;// минимальный свободный объем (мегабайты)

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

function corner_top(){

?>

<table width="100%" height="100%" border=0 cellspacing=0 cellpadding=0>

<tr>

<td height=2>

<div id="nifty">

<b class="rtop">

<b class="r1"></b>

<b class="r2"></b>

<b class="r3"></b>

<b class="r4"></b>

</b>

</div>

</td>

</tr>

<tr>

<td width="100%" height="100%" valign="top" class="box">

<?

}

function corner_bot(){

?>

</td>

</tr>

<tr>

<td height=2>

<div id="nifty">

<b class="rbottom">

<b class="r4"></b>

<b class="r3"></b>

<b class="r2"></b>

<b class="r1"></b>

</b>

</div>

</td>

</tr>

</table>

<?

}

function corner2_top(){

?>

<table width="100%" height="100%" border=0 cellspacing=0 cellpadding=0 bgcolor="#ffffff">

<tr>

<td height=2>

<div id="nifty">

<b class="rtop2">

<b class="r1"></b>

<b class="r2"></b>

<b class="r3"></b>

<b class="r4"></b>

</b>

</div>

</td>

</tr>

<tr>

<td height="100%" valign="top">

<?

}

function corner2a_top(){

?>

<table width="100%" height="100%" border=0 cellspacing=0 cellpadding=0 bgcolor="#ffffff">

<tr>

<td height="100%" valign="top">

<?

}

function corner2_bot(){

?>

</td>

</tr>

<tr>

<td height=2>

<div id="nifty">

<b class="rbottom2">

<b class="r4"></b>

<b class="r3"></b>

<b class="r2"></b>

<b class="r1"></b>

</b>

</div>

</td>

</tr>

</table>

<?

}

function corner3_top($col){

if(!$col){$col="#9ac8f5";}

?>

<table width="100%" height="100%" border=0 cellspacing=0 cellpadding=0 bgcolor="<? print $col; ?>">

<tr>

<td height=2>

<div id="nifty">

<b class="rtop3">

<b class="r1"></b>

<b class="r2"></b>

<b class="r3"></b>

<b class="r4"></b>

</b>

</div>

</td>

</tr>

<tr>

<td height="100%" valign="top" style="padding-left:5px;padding-right:5px;">

<?

}

function corner3_bot(){

?>

</td>

</tr>

<tr>

<td height=2>

<div id="nifty">

<b class="rbottom3">

<b class="r4"></b>

<b class="r3"></b>

<b class="r2"></b>

<b class="r1"></b>

</b>

</div>

</td>

</tr>

</table>

<?

}

?>

Style.css

body{

font-family: verdana;

font-size: 10px;

color:#595959;

margin:0;

padding-top:3px;

}

a{

font-family: verdana;

color:#595959;

text-decoration:underline;

}

a:hover{

color:#f78f42;

}

td{

font-size: 12px;

}

th{

font-size: 12px;

}

div#nifty{ margin: 0 0%;background: #ffffff; width: 100%; height:100%;}

b.rtop, b.rbottom{display:block;background: #ffffff;}

b.rtop b, b.rbottom b{display:block;height: 1px;

overflow: hidden; background: #e9e9e9}

b.rtop2, b.rbottom2{display:block;background: #e9e9e9;}

b.rtop2 b, b.rbottom2 b{display:block;height: 1px;

overflow: hidden; background: #ffffff}

b.rtop3, b.rbottom3{display:block;background: #e9e9e9;}

b.rtop3 b, b.rbottom3 b{display:block;height: 1px;

overflow: hidden; background: #9ac8f5}

b.r1{margin: 0 5px}

b.r2{margin: 0 3px}

b.r3{margin: 0 2px}

b.rtop b.r4, b.rbottom b.r4{margin: 0 1px;height: 2px}

b.rtop2 b.r4, b.rbottom2 b.r4{margin: 0 1px;height: 2px}

b.rtop3 b.r4, b.rbottom3 b.r4{margin: 0 1px;height: 2px}

.box_info{

background-color: #e9e9e9;

}

.hardware{

background-color: #e9e9e9;

}

.box_list{

background-color: #e9e9e9;

}

.climat{

background-color: #e9e9e9;

}

.channel{

background-color: #e9e9e9;

}

.power{

background-color: #e9e9e9;

}

.resources{

background-color: #e9e9e9;

}

.access_log{

background-color: #e9e9e9;

}

.model{

background-color: #e9e9e9;

}

.box{

padding-left:4px;

padding-right:4px;

padding-top:0px;

padding-bottom:0px;

}

.box2{

background-color: #ffffff;

}

.box3{

padding-left:0px;

padding-right:0px;

padding-top:2px;

padding-bottom:2px;

}

.box_list_title{

background-color: #f6eaba;

font-family: impact;

font-size:12px;

font-weight:none;

}

.box_info_title{

background-color: #9ac8f5;

font-family: impact;

font-size:12px;

font-weight:none;

}

.hardware_title{

background-color: #9ac8f5;

font-family: impact;

font-size:12px;

font-weight:none;

}

.power_title{

background-color: #abdeed;

font-family: impact;

font-size:12px;

font-weight:none;

}

.min{

font-size:9px;

}

.ok_tr td{

background-color: #e9e9e9;

}

.ok_tr a{

color: black;

}

.er_tr td{

background-color: #ff0000;

color: white;

}

.wr_tr td{

background-color: #ffff00;

color: black;

}

.wr_tr a{

color: black;

}

.er_tr a{

color: white;

}

.hl_tr td{

background-color: #ffff90;

}

.hl_tr a{

color: black;

}

.hw_hl_tr td{

background-color: #ffffff;

padding-left:0px;

padding-right:0px;

padding-top:5px;

padding-bottom:5px;

}

.hw_hl_tr a{

color: black;

}

.cl_hl_tr td{

background-color: #ffffff;

padding-left:0px;

padding-right:0px;

padding-top:5px;

padding-bottom:5px;

}

.cl_er_tr td{

background-color: #ff6060;

}

.cl_hl_tr a{

color: black;

}

.pw_hl_tr td{

background-color: #ffffff;

padding-left:0px;

padding-right:0px;

padding-top:5px;

padding-bottom:5px;

}

.pw_hl_tr a{

color: black;

}

.pw_ac_tr td{

background-color: #f0f000;

}

.pw_er_tr td{

background-color: #ff6060;

}

.ac_hl_tr td{

background-color: #909090;

color: white;

}

.ac_hl_tr a{

color: white;

}

.dcontact{

background-color: #d0d0d0;

color: black;

font-size:10px;

}

Access_log.php

<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">

<?php

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$query="SELECT ddate,name,id,event_type FROM access WHERE rack_id='$rack_id' AND event_type=0 ORDER BY ddate desc limit 30";

$rows=mysql_query($query,$db);

$ac_id=addslashes(trim($_REQUEST['ac_id']));

$alien=0;

$ac_id=0;

$fn='';

while($r=mysql_fetch_row($rows)){

if(!$ac_id){

$ac_id=$r[2];

$fn=$r[1];

if(!$r[1]){$alien=1;$fn="Чужой!";}

}

$name=$r[1];

if(!$r[1]){$name='Чужой!';}

if($r[3]){ // door open

print "<tr><td class='min'>$r[0] $name</td></tr>";

}else{ // lock open

if($r[1]){

print "<tr><td>11<a href=\"#\" class='min' onClick=\"ReloadDiv('div_access_pic1','http://rackmon1.nnx/frames/access_photo.php?id=$r[2]&src=0',0);ReloadDiv('div_access_pic2','http://rackmon1.nnx/frames/access_photo.php?id=$r[2]&src=1&name=$name',0);\">$r[0] $name</a></td></tr>";

}else{ // alien

print "<tr><td>22<a href=\"#\" class='min' onClick=\"ReloadDiv('div_access_pic1','http://rackmon1.nnx/frames/access_photo.php?id=$r[2]&src=0',0);ReloadDiv('div_access_pic2','http://rackmon1.nnx/frames/access_photo.php?id=$r[2]&src=2&name=$name',0);\">$r[0] $name</a></td></tr>";

}

}

$i++;

}

print "</table>";

print "<script>ReloadDiv('div_access_pic1','http://rackmon1.nnx/frames/access_photo.php?id=$ac_id&src=0',0);

ReloadDiv('div_access_pic2','http://rackmon1.nnx/frames/access_photo.php?id=$ac_id&src=".($alien+1)."',0);

</script>";

?>

Access_pic.php

<?php

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$id=addslashes(trim($_REQUEST['id']));

$src=addslashes(trim($_REQUEST['src']));

if(!$src){

$query="SELECT photo FROM access ";

if(!$id){$query.=" ORDER BY id DESC LIMIT 1";}else{$query.=" WHERE id='$id'";}

}else{

$query="SELECT u.photo FROM users u LEFT JOIN access a ON (u.ibutton_id=a.ibutton_id) ";

if(!$id){$query.=" ORDER BY a.id DESC LIMIT 1";}else{$query.=" WHERE a.id='$id'";}

}

$rows=mysql_query($query,$db);

if(($r=mysql_fetch_row($rows)) && ($r[0])){

header("Content-type: image/jpeg");

print $r[0];

}else{

header("Content-type: image/jpeg");

readfile("images/no_photo.jpg");

}

?>

Access_photo.php

<?php

header("Content-Type: text/html; charset=\"windows-1251\"");

$id=addslashes(trim($_REQUEST['id']));

$src=addslashes(trim($_REQUEST['src']));

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$query="SELECT name FROM access WHERE id='$id'";

$rows=mysql_query($query,$db);

$r=mysql_fetch_row($rows);

$name=$r[0];

if($src!=2){

print "<img src=\"http://rackmon1.nnx/access_pic.php?id=$id&src=$src\" height=150>";

if($name){print "<br>$name";}

}else{

print "<img src=\"images/hr_giger_alien_VI.jpg\" height=150>";

print "<br>Чужой";

}

?>

Climat_info.php

<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">

<tr height="20">

<td background="/pilot/arrow4_1.jpg" style="background-repeat:no-repeat" width="14" rowspan=6></td>

<td class="power_title">дата</td>

<td class="power_title">темп.,°C</td>

<td class="power_title">дым</td>

<td background="/pilot/arrow4_2.jpg" style="background-repeat:no-repeat" width="14" rowspan=6></td>

</tr>

<?php

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$query="SELECT ddate,t,smoke FROM climat WHERE rack_id='$rack_id' ORDER BY ddate desc limit 5";

$rows=mysql_query($query,$db);

while($r=mysql_fetch_row($rows)){

$cl="min";

if(($r[1]>$t_max)||($r[1]<$t_min)){

$cl="cl_er_tr";

}

if($r[2]){

$r[2]='Дым!';

$cl="cl_er_tr";

}else{

$r[2]='-';

}

$r[1]=sprintf("%0.1f",$r[1]);

print "<tr class=\"$cl\"><td>$r[0]</td><td>$r[1]</td><td>$r[2]</td></tr>";

$i++;

}

?>

</table>

Hw_list.php

<html>

<head>

<meta content="text/html; charset=windows-1251" http-equiv="Content-Type">

<link href="../style.css" rel="stylesheet" type="text/css">

<script>

function OpenWin(URL, winName, width, height, scroll){

var winLeft = (screen.width - width) / 2;

var winTop = (screen.height - height) / 2;

winData = 'height='+height+',width='+width+',top='+winTop+',left='+winLeft+',scrollbars='+scroll+',resizable';

win = window.open(URL, winName, winData);

if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }

}

</script>

</head>

<body>

<?php

include "../func.php";

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$rack_id=addslashes(trim($_REQUEST['id']));

$query="SELECT id,name,unit_start,unit_height,state,cfg,doc FROM hardware WHERE rack_id='$rack_id' ORDER BY unit_start DESC";

$rows=mysql_query($query,$db);

$num_results=mysql_num_rows($rows);

$num=$num_results+1;

?>

<table width="100%" cellspacing="0" cellpadding="0" border="0">

<tr height="20">

<td background="/pilot/arrow1_1.jpg" style="background-repeat:no-repeat" width="13" rowspan=<? echo $num;?>></td>

<td class="hardware_title">название</td>

<td class="hardware_title">Y</td>

<td class="hardware_title">h</td>

<td class="hardware_title"></td>

<td class="hardware_title"></td>

<td background="../pilot/arrow1_2.jpg" style="background-repeat:no-repeat" width="14" rowspan=<? echo $num;?>></td>

</tr>

<?

while($r=mysql_fetch_row($rows)){

$cl="box3";

print "<tr class='$cl' valign='top'><td class=$cl>$r[1]</td><td title=\"Положение в стойке (в юнитах)\" class=$cl width=30>$r[2]</td>

<td title=\"Высота (в юнитах)\" class=$cl width=30>$r[3]</td>

<td class=$cl>";

if($r[5]){print "<a href=\"javascript:OpenWin('../show_doc.php?hw=$r[0]&t=0','doc_win',640,480,1);\"><img src=\"../images/config.gif\" border=0 title=\"Конфигурация\"></a>";}

print "</td><td class=$cl>";

if($r[6]){print "<a href=\"javascript:OpenWin('../show_doc.php?hw=$r[0]&t=1','doc_win',640,480,1);\"><img src=\"../images/doc.gif\" border=0 title=\"Документация\"></a>";}

print "</td></tr>";

}

?>

</table>

</body>

</html>

Personal_info.php

<?

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$query="SELECT u.id,u.name,u.contact FROM users u LEFT JOIN rack_users r ON (r.user_id=u.id) WHERE r.rack_id='$rack_id'";

$rows=mysql_query($query,$db);

$ul='';

$contacts='';

while($r=mysql_fetch_row($rows)){

$contact=$r[2];

$contact=preg_replace("/([0-9a-z_.-]+\@[0-9a-z_.-]+)/i","<a href='mailto:$1'>$1</a>",$contact);

$contacts.="<a href=\"#\" onClick=\"toggle_div($r[0]);\">$r[1]</a><br><div class='dcontact' id='div_contact_$r[0]' style=\"display:none\">$contact</div>";

}

print $contacts;

?>

Power_info.php

<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">

<tr height="20">

<td background="/pilot/arrow4_1.jpg" style="background-repeat:no-repeat" width="14" rowspan=6></td>

<td class="power_title">дата</td>

<td class="power_title">заряд, %</td>

<td class="power_title">нагрузка, %</td>

<td class="power_title">режим</td>

<td background="/pilot/arrow4_2.jpg" style="background-repeat:no-repeat" width="14" rowspan=6></td>

</tr>

<?php

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$query="SELECT ddate,charge,upsload,mode FROM upspower WHERE rack_id='$rack_id' ORDER BY ddate desc limit 5";

$rows=mysql_query($query,$db);

while($r=mysql_fetch_row($rows)){

$cl="min";

if($r[3]){

$r[3]='Батар.';

$cl="pw_ac_tr";

if($r[1]<$c_min){

$cl="pw_er_tr";

}

}else{

$r[3]='Сеть';

if($r[1]<$c_min){

$cl="pw_ac_tr";

}

}

print "<tr class=\"$cl\"><td>$r[0]</td><td>$r[1]</td><td>$r[2]</td><td>$r[3]</td></tr>";

$i++;

}

?>

</table>

Rack_info.php

<?

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$db = mysql_connect("localhost", "boxmon", "boxmon");

ysql_select_db('boxmon',$db);

$doors=array('передняя','левая','правая','задняя');

$dstate=array('<font color=green>закрыта</font>','<font color=red>открыта</font>');

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$query="SELECT id,name,place,org,comment,door_front,door_left,door_right,door_back FROM racks WHERE id='$rack_id'";

$rows=mysql_query($query,$db);

if($r=mysql_fetch_row($rows)){

print "<b>стойка №$r[0]</b><br>код: $r[1]<br>место: $r[3]<br>адрес: $r[2]";

print "<p>Двери:<br><table>";

for($i=0;$i<4;$i++){

print "<tr><td>$doors[$i]</td><td>".$dstate[$r[5+$i]]."</td></tr>";

}

print "</table>";

}

?>

Rack_list.php

<table width="100%" sheight="100%" cellspacing="0" cellpadding="0" border="0">

<tr height="20">

<td background="/pilot/arrow3_1.jpg" style="background-repeat:no-repeat" width="14" rowspan=2></td>

<td class="box_list_title" height="20">код</td>

<td class="box_list_title">город</td>

<td class="box_list_title">орг.</td>

<td class="box_list_title">статус</td>

<td background="/pilot/arrow3_2.jpg" style="background-repeat:no-repeat" width="14" rowspan=2></td>

</tr>

<?

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$query="SELECT id,name,place,org,state FROM racks ORDER BY id";

$rows=mysql_query($query,$db);

while($r=mysql_fetch_row($rows)){

$n=sprintf("%02d",$r[0]);

$cl="box3";

$stat="OK";

$query="SELECT t,smoke FROM climat WHERE rack_id=$r[0] ORDER BY id DESC LIMIT 1";

$rows1=mysql_query($query,$db);

if($r1=mysql_fetch_row($rows1)){

if(($r1[0]>$t_max) || ($r1[0]<$t_min) || $r1[1]){$r[4]=2;}

}

$query="SELECT mode,charge FROM upspower WHERE rack_id=$r[0] ORDER BY id DESC LIMIT 1";

$rows1=mysql_query($query,$db);

if($r1=mysql_fetch_row($rows1)){

if(!$r1[0] && ($r1[1]<$c_min)){$r[4]=1;}

if($r1[0] && ($r1[1]>=$c_min)){$r[4]=1;}

if($r1[0] && ($r1[1]<$c_min)){$r[4]=2;}

}

if((disk_total_space("/")-disk_free_space("/"))/1048576<$h_nom){$r[4]=1;}

if((disk_total_space("/")-disk_free_space("/"))/1048576<$h_min){$r[4]=2;}

if($r[4]==1){$cl="wr_tr";$stat="Опасность";}

if($r[4]==2){$cl="er_tr";$stat="Тревога!";}

print "<tr class=$cl valign=top align=left><td class=$cl><a href=\"index.php?id=$r[0]\">$r[1]</a></td><td class=$cl>$r[2]</td><td class=$cl>$r[3]</td>

<td class=$cl>$stat</td></tr>";

}

?>

</table>

Rack_view.php

<?

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$query="SELECT id,name,place,org,comment,door_front,door_left,door_right,door_back FROM racks WHERE id='$rack_id'";

$rows=mysql_query($query,$db);

$col=array('green','green','green','green');

if($r=mysql_fetch_row($rows)){

for($i=0;$i<4;$i++){if($r[5+$i]){$col[$i]='red';}}

}

?>

<table width="100" height=210 align="center" cellspacing="0" cellpadding="0" border="0" class="min">

<tr align="center" valign="top" >

<td width="55" style="padding-right:3px;" sheight="67">

<?corner3_top($col[0]) ?>

<a href="javascript:OpenWin('show_pic.php?id=<?php print $rack_id;?>&side=0','pic_win',400,500,1);">

<img src="show_pic.php?id=<?php print $rack_id;?>&side=0" border=0 title="Вид спереди" height="100" width="50"></a>

<?corner3_bot() ?>

</td>

<td align="center" valign="top">

<?corner3_top($col[1]) ?>

<a href="javascript:OpenWin('show_pic.php?id=<?php print $rack_id;?>&side=1','pic_win',400,500,1);">

<img src="show_pic.php?id=<?php print $rack_id;?>&side=1" border=0 title="Вид слева" height="100" width="50"></a>

<?corner3_bot() ?>

</td>

</tr>

<tr align="center" valign="top">

<td style="padding-right:3px;" sheight="67">

<?corner3_top($col[2]) ?>

<a href="javascript:OpenWin('show_pic.php?id=<?php print $rack_id;?>&side=2','pic_win',400,500,1);">

<img src="show_pic.php?id=<?php print $rack_id;?>&side=2" border=0 title="Вид справа" height="100" width="50"></a>

<?corner3_bot() ?>

</td>

<td align="center" valign="top">

<?corner3_top($col[3]) ?>

<a href="javascript:OpenWin('show_pic.php?id=<?php print $rack_id;?>&side=3','pic_win',400,500,1);">

<img src="show_pic.php?id=<?php print $rack_id;?>&side=3" border=0 title="Вид сзади" height="100" width="50"></a>

<?corner3_bot() ?>

</td>

</tr>

</table>

Resource_info.php

<table width="100%" height="129" valign="top" cellspacing="0" cellpadding="0" border="0" class="box">

<?php

header("Content-Type: text/html; charset=\"windows-1251\"");

include "../func.php";

$rack_id=addslashes(trim($_REQUEST['id']));

if(!$rack_id){$rack_id=1;}

$s=(disk_total_space("/")-disk_free_space("/"))/1048576;

$cl='';

if($s<$h_nom){$cl='wr_tr';}

if($s<$h_min){$cl='er_tr';}

print "<tr valign='top' class='$cl'><td>Свободно HDD</td><td>".sprintf("%.2f",disk_free_space("/")/disk_total_space("/")*100)."%</td><td>".sprintf("%.2f",$s)." Mb</td></tr>";

?>

</table>

Show_doc.php

<html>

<head>

<meta content="text/html; charset=windows-1251" http-equiv="Content-Type">

</head>

<body>

<?php

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$hw_id=addslashes(trim($_REQUEST['hw']));

$t=addslashes(trim($_REQUEST['t']));

$query="SELECT cfg,doc FROM hardware WHERE id='$hw_id'";

$rows=mysql_query($query,$db);

if($r=mysql_fetch_row($rows)){

$r[$t]=preg_replace("/\n/","<p>",$r[$t]);

$r[$t]=preg_replace("/(http:\/\/\S+)/","<a href='$1'>$1</a>",$r[$t]);

print "<p>$r[$t]";

}

?>

</body>

</html>

Show_pic.php

<?php

$db = mysql_connect("localhost", "boxmon", "boxmon");

mysql_select_db('boxmon',$db);

$id=addslashes(trim($_REQUEST['id']));

$side=addslashes(trim($_REQUEST['side']));

$query="SELECT pic_front,pic_left,pic_right,pic_back FROM racks WHERE id='$id'";

$rows=mysql_query($query,$db);

if($r=mysql_fetch_row($rows)){

header("Content-type: image/jpeg");

print $r[$side];

}else{

print "

<HTML><HEAD>

<META http-equiv=Content-Type content=\"text/html; charset=windows 1251\"></head><body>

Изображение не найдено!

</body></html>";

}

?>

Размещено на Allbest.ru

...

Подобные документы

Работы в архивах красиво оформлены согласно требованиям ВУЗов и содержат рисунки, диаграммы, формулы и т.д.
PPT, PPTX и PDF-файлы представлены только в архивах.
Рекомендуем скачать работу.