141
<div class="lside">
<div class="topmenu"> <a href="login.php">Вход для секретаря</a> </div>
<div class="header">
<div class="padding">
<div class="citation"><br />
</div>
<h1> </h1>
Автоматизация архивного отдела
<br /> <font color="#FFFF66" size="+1"> Панель
администратора </font> </div>
</div>
<div class="main">
<h2>Смена пароля</h2>
<table align="center" cellspacing="2" cellpadding="2" border="0"
bgcolor="ffffff">
<tr> <td colspan="2">
<br> </td> </tr>
<tr>
<td class="prav"><form method="post" >Номер пользователя</td>
<td class="pp"> <input type="text" size="40" name="nomer"></td></td>
</tr>
<tr>
<td width="200" align="center" class="prav"> Новый пароль</td>
<td width="200" align="center" class="pp">
<input type="text" size="40" name="parol"></td>
</tr>
<tr>
<td class="prav">Новый логин</td>
<td class="pp"><input type="text" size="40" name="login"></td>
</tr>
<tr>
142
<tr>
<td colspan="3" bgcolor="" > <center> <br><input type="submit"
value="Заменить" name="smena"><br>
</form><br></td>
</tr>
<tr>
<td colspan="2" bgcolor="" > <center>
<?php
require "dbconnect.php";
if(isset($_POST['smena']))
{
$query1=("update sotr set parol='".$_POST['parol']."',
login='".$_POST['login']."' where idsotr='".$_POST['nomer']."'");
if(mysql_query($query1))
{
echo "
Пароль и логин заменены
}
else
{
echo "
='log
'></p>Не получилось}
}
?>
</td>
</tr>
</table>
<br />
</div>
</div>
</body>
</html>
143
<?php
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Автоматизация архивного отдела </title>
<style type="text/css" media="all">
@import "images/style.css";
</style>
</head>
<body>
<div class="content">
<div class="rside">
<div class="topmenu"></div>
<div class="loginbox">
<div class="padding">
</div>
</div>
<div class="menu">
<h2>Меню</h2><?php include "menu.php";
?>
<h2></h2>
<br />
<h2></h2>
<div class="ads"> </div>
<br />
</div>
</div>
<div class="lside">
144
<div class="topmenu"> <a href="loginadmin.php">Вход для
администратора</a> </div>
<div class="header">
<div class="padding">
<div class="citation"><br />
</div>
<h1><?php
require "dbconnect.php";
$namec=mysql_query("select namec from contact where namec!='0' limit 1");
while($sod_mas1=mysql_fetch_row($namec))
{
$title=$sod_mas1[0];
echo $title;
};
?> </h1>
</div>
</div>
<div class="main">
<h2>Регистрация документов</h2>
<?php
require "dbconnect.php";
$res_id1=mysql_query("SELECT * FROM `tip`")
or die(mysql_error());
?>
<table align="center" cellspacing="2" cellpadding="2" border="0"
bgcolor="ffffff" width="750">
<tr>
<form action="upload.php" method="post" enctype="multipart/form-
data">
<td class="prav">Наименование</td>
145
<td class="pp"><textarea ROWS=3 COLS=40 name="name">
</textarea></td>
</tr>
<tr>
<td width="200" align="left" class="prav"> Дата подготовки
(поступления)</td>
<td width="200" align="left" class="pp">
<select name="date1">
<option> </option>
<tr>
<td class="prav">Количество страниц</td>
<td class="pp"><input type="text" size="40" name="kolvo"></td>
</tr>
<tr>
<td class="prav">Тип документа</td>
<td class="pp"> <select name="tip"><center>
<?php
while ($tip=mysql_fetch_row($res_id1))
{
echo "<option value='$tip[0]'>$tip[1]</option>\n";
}
?>
</td>
</tr>
<tr>
<td class="prav">Адресат</td>
<td class="pp"><input type="text" size="40" name="otkuda"></td>
</tr>
<tr>
<td class="prav">Количество экземпляров</td>
<td class="pp"><input type="text" size="40" name="ekz"></td>
</tr>
146
<tr>
<td class="prav">Примечание</td>
<td class="pp"><textarea ROWS=3 COLS=40 name="prim">
</textarea></td>
</tr>
<tr>
<td class="prav">Выбор файла</td>
<td class="pp">
<input type="file" name="filename"><br>
</tr>
<tr>
<td colspan="3" bgcolor="" > <center> <br><input type="submit"
value="Загрузить" name="zag"><br>
</form><br></td>
</tr>
<tr> <td colspan="2">
<center>
<?php
setlocale (LC_ALL, "ru_RU.CP1251");
echo $ttt;
echo date("d/m/y G:i:s", time());
?>
</td>
</tr>
</table>
<br />
</div>
</div>
</body>
</html>
<?php
session_start();
147
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Автоматизация архивного отдела </title>
<style type="text/css" media="all">
@import "images/style.css";
</style>
</head>
<body>
<div class="content">
<div class="rside">
<div class="topmenu"></div>
<div class="loginbox">
<div class="padding">
</div>
</div>
<div class="menu">
<h2>Меню</h2><?php include "menu.php";
?>
<h2></h2>
<br />
<h2></h2>
<div class="ads"> </div>
<br />
</div>
</div>
<div class="lside">
<div class="topmenu"> <a href="loginadmin.php">Вход для
администратора</a> </div>
<div class="header">
148
<div class="padding">
<div class="citation"><br />
</div>
<h1><?php
require "dbconnect.php";
$namec=mysql_query("select namec from contact where namec!='0' limit 1");
while($sod_mas1=mysql_fetch_row($namec))
{
$title=$sod_mas1[0];
echo $title;
};
?> </h1>
</div></div>
<div class="main">
<h2>Поиск документов</h2>
<table align="center" width="500">
<tr><td colspan="5"><p class="table"> <center> Введите необходимые
реквизиты </p><br><p class='tr'>Для поиска достаточно ввести одну или несколько
букв (цифр) в любое поле</p> </td>
</tr>
<tr>
<td align="center"> <form method="post" >
<p class="pp">Дата регистрации</p>
<input type="text" name="date" size="20"><br><br>
</td>
<td align="center">
<p class="pp">Наименование</p>
<input type="text" name="name" size="20"><br><br>
</td>
<td align="center">
<p class="pp">Тип</p>
<input type="text" name="tip" size="20"><br><br>
149
</td>
<td align="center">
</td>
<td align="center">
<p class="pp">Рег. номер</p>
<input type="text" name="nomer" size="20"><br><br>
</td>
</tr>
<tr> <td colspan="5">
<center>
<input type="submit" name="search" value="
Искать ">
</form>
</td>
</tr>
</table>
<?php
require "dbconnect.php";
if(isset($_POST['search']))
{
$a=0;
echo "<table border='0' align='center' width='550'>\n";
echo "<tr class='table1'><th> Рег. номер
</th><th> Дата
загрузки </th>
<th> Дата
подготовки </th><th> Наименование
</th>
<th> Кол-во
страниц </th><th> Адресат &n
bsp;</th><th> Кол-во
150
экз </th><th> Загрузил
</th><th> Тип </th>
</tr>\n";
$query1="SELECT idd, datez, datepod, named, kolvostr, otkuda, idsd, name,
namet
FROM dokument, sotr, tip
WHERE namet like ('%".$_POST['tip']."%') and datepod like
('%".$_POST['date']."%') and name like ('%".$_POST['sotr']."%') and named like
('%".$_POST['name']."%') and idd like ('%".$_POST['nomer']."%')and idkd=idtip and
ids=idsotr order by idd";
$res_id=mysql_query($query1);
if(mysql_query($query1))
while($sod_mas=mysql_fetch_row($res_id))
{
$a=$a+1;
echo "<tr class='table'><td class='table'><center>$sod_mas[0]</td><td
class='table'><center>$sod_mas[1]</td>
<td class='table'><center>$sod_mas[2]</td><td
class='table'><center>$sod_mas[3]</td><td class='table'><center>$sod_mas[4]</td>
<td class='table'><center>$sod_mas[5]</td><td
class='table'><center>$sod_mas[6]</td><td class='table'><center>$sod_mas[7]</td><td
class='table'><center>$sod_mas[8]</td></tr>\n";
}
else
{
echo "Не получилось";
}
}
echo "</table>";
?>
<br>
<div>