116
$FIO = $myrow['surname']." ".$myrow['name']."
".$myrow['middle_name'];
?>
<form id="loginForm" action="testreg.php" method="post"
style="height:270px;">
<h1>Вы вошли как:</h1>
<fieldset id="inputs">
<label for="login" style="font-size:15px;">ФИО сотрудника:</label>
<input id="name" name="name" type="text" readonly="yes"
placeholder="<?echo $FIO?>" autofocus required>
<label for="department" style="font-size:15px;">Подразделение:</label>
<input id="department" name="department" type="text" readonly="yes"
placeholder="<? echo $myrow['dep'] ?>" required>
<label for="employee" style="font-size:15px;">Должность:</label>
<input id="employee" name="employee" type="text" readonly="yes"
placeholder="<? echo $myrow['job'] ?>" required>
</fieldset>
</form>
<? } ?>
</div>
<!--
==============================footer=============================
====-->
<footer>
<div class="container_12">
<div class="grid_12">
<div class="copy">
WEB-представительство предприятия по ремонту компьютерной техники
117
<br>
</div>
</div>
</div>
</footer>
</body>
</html>
Исходный код страницы requests.php
<?
session_start();
include("bd.php");
if ($_SESSION['access_level'] < 1) {
exit();
}
?>
<!DOCTYPE html>
<html>
<head>
<title>About</title>
<meta charset="utf-8">
<link rel="icon" href="images/favicon.ico">
<link rel="shortcut icon" href="images/favicon.ico" />
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/font-awesome.css">
<link rel="stylesheet" href="css/slider.css">
<link rel="stylesheet" href="css/elastislide.css">
<script src="js/jquery.js"></script>
<script src="js/jquery-migrate-1.1.1.js"></script>
<script src="js/superfish.js"></script>
118
<script src="js/jquery.equalheights.js"></script>
<script src="js/jquery.easing.1.3.js"></script>
<script src="js/modernizr.custom.63321.js"></script>
<script src="js/jquerypp.custom.js"></script>
<script src="js/jquery.ui.totop.js"></script>
<script src="js/jquery.carouFredSel-6.1.0-packed.js"></script>
<script src="js/jquery.elastislide.js"></script>
<script src="js/jquery.catslider.js"></script>
<script src="js/jquery.touchSwipe.min.js"></script>
<script>
$(window).load ( function(){
$( '#mi-slider' ).catslider();
$( '#carousel' ).elastislide( {
orientation : 'vertical'
} );
});
$(window).load (
function(){$('#carousel1').carouFredSel({auto: false, prev: '.prev1',next: '.next1',
width: 220, items: {
visible : {min: 1,
max: 1
},
height: 'auto',
width: 220,
119
}, responsive: true,
scroll: 1,
mousewheel: false,
swipe: {onMouse: false, onTouch: false}});
} );
$(document).ready(function(){
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<script>
function test(param){
document.getElementById('valueID').value = param;
}
function editEm(){
document.comandForm.action = 'edit_request.php';
$('#but').click();
}
function deleteEm(){
document.comandForm.action = 'deleteRequest.php';
$('#but').click();
}
function baseEm() {
document.comandForm.action = 'add_act.php';
120
$('#but').click();
}
function baseEm() {
document.comandForm.action = 'add_act.php';
$('#but').click();
}
function view() {
document.comandForm.action = 'request_view.php';
$('#but').click();
}
</script>
<!--[if lt IE 8]>
<div style=' clear: both; text-align:center; position: relative;'>
<a href="http://windows.microsoft.com/en-US/internet-
explorer/products/ie/home?ocid=ie6_countdown_bannercode">
<img
src="http://storage.ie6countdown.com/assets/100/images/banners/warning_bar_0000_us.j
pg" border="0" height="42" width="820" alt="You are using an outdated browser. For a
faster, safer browsing experience, upgrade for free today." />
</a>
</div>
<![endif]-->
<!--[if lt IE 9]>
<script src="js/html5shiv.js"></script>
<link rel="stylesheet" media="screen" href="css/ie.css">
<![endif]-->
</head>
<body class="page1">
<!--
121
==============================header=============================
====-->
<header>
<div class="container_12" style="width:1100px;">
<div class="grid_12" style="width:1100px;">
<h1>CRM</h1>
<div class="menu_block">
<nav class="" >
<ul class="sf-menu">
<li><a href="index.php">Главная</a></li>
<li><a href="employee.php">Сотрудники</a></li>
<li class="current"><a href="recuests.php">Заявки</a></li>
<li><a href="act.php">Акты</a></li>
<li><a href="department.php">Отделы</a></li>
<li><a href="out.php">Выход</a></li>
</ul>
</nav>
<div class="clear"></div>
</div>
<div class="clear"></div>
</div>
</div>
</header>
<!--
==============================Content============================
=====-->
<div class="content"><div class="ic">Разработка CRM системы тестовая
копия, 2015!</div>
122
<form class="comandPanel" action="deleteEmployee.php" method="post"
name="comandForm">
<a href="add_recuests.php" class="button add">Добавить</a>
<a href="#" class="button delete" onclick="deleteEm()">Удалить</a>
<a href="#" class="button save" onclick="baseEm()">Создать АКТ</a>
<a href="recuestsMy.php" class="button" onclick="baseEm()">Только
мои</a>
<a href="#" class="button" onclick="view()">Просмотр</a>
<input type="submit" value="ot" name="but" id="but" hidden="">
<input type="text" id="valueID" name="valueID">
</form>
<form class="comandPanel" action="recuests_sel.php" method="post"
name="comandFor">
<div>
<select id="type" name="type" size="1" required>
<? $result = mysql_query("select
*
from type_request",$db);
while($row = mysql_fetch_array($result)) { ?>
<option value="<? echo($row['id']) ?>"> <? echo $row['name'];
?></option>
<? } ?>
123
</select>
<select id="kind" name="kind" size="1" required>
<? $result = mysql_query("select
*
from kind_request",$db);
while($row = mysql_fetch_array($result)) { ?>
<option value="<? echo($row['id']) ?>"> <? echo $row['name'];
?></option>
<? } ?>
</select>
</div>
<input type="submit" value="Применить отбор" name="but" id="but">
</form>
<TABLE class="bordered">
<thead>
<TR >
<th>Номер</TD>
<th>Дата</TD>
<th>Краткое содержание заявки</TD>
<th>Объект (адрес)</TD>
<th>Отправитель</TD>
<th>Постановщик</TD>
<th>Исполнитель</TD>
<th>Дата выполнения</TD>
124
<th>Акт №</th>
</TR>
</thead>
<?
$result = mysql_query("Select
vlog.id,
vlog.PublicationDate,
vlog.Object,
vlog.Summary,
vlog.Send,
vlog.nameRec,
vlog.surnameRec,
vlog.actID as actID,
vlog.executionDate,
vlog.user_doer,
users.name as nameDoer,
users.surname as surnameDoer
FROM
(Select
vlo.id,
vlo.PublicationDate,
vlo.Object,
vlo.Summary,
vlo.Send,
125
vlo.nameRec,
vlo.surnameRec,
act.id as actID,
act.executionDate,
act.user_doer
FROM
(select
requests.id,
requests.PublicationDate,
requests.Object,
requests.Summary,
requests.Send,
users.name as nameRec,
users.surname as surnameRec
From requests
left join (users) on (requests.Recepient = users.id) ) as vlo left Join (act) on (vlo.id
= act.base)) as vlog LEFT JOIN (users) on (vlog.user_doer = users.id)",$db);
while($row = mysql_fetch_array($result))
{
?>
<TR onclick="test(<? echo $row['id'] ?>)">
<TD> <?echo $row['id'];?> </TD>
<TD> <?echo $row['PublicationDate'];?> </TD>
<TD> <?echo substr($row['Summary'], 0,50);?> </TD>
<TD> <?echo $row['Object'];?> </TD>
<TD> <?echo $row['Send'];?> </TD>
<TD> <?echo $row['surnameRec']." ".$row['nameRec'];?> </TD>
<TD> <?echo $row['surnameDoer']." ".$row['nameDoer'];?> </TD>
<TD> <?echo $row['executionDate'];?> </TD>
<TD> <? if ($row['actID'] > 0) {echo "Акт № ".$row['actID'];}?> </TD>