107
}
else
{
echo "<h2 align = \"center\">Номер и название документа не уникальны или дата
введена неверно.</h2><br><br><p align = \"center\"><a href =
\"index.php?action=edit_docs_add\">Назад</a>";
}
}
if ($action == "edit_docs")
{
?>
<h2 align="center">Выберите документ для редактирования</h2><br/>
<table border="1" cellspacing="0" align="center">
<tr><td>Название</td><td>Номер</td><td><a href =
"index.php?action=edit_docs&sort=service">Служба</a></td><td><a href =
"index.php?action=edit_docs&sort=tp">Тип</a></td><td>Текст</td><td>Дейсвтие<
/td></tr>
<?php
$sort = $_REQUEST['sort'];
if (!$sort)$res = mysql_query("select * from docs");
if ($sort == "service") $res = mysql_query("select * from docs order by service");
if ($sort == "tp") $res = mysql_query("select * from docs order by d_type");
$i = 1;
while ($row = mysql_fetch_array($res))
{
$s = "<a href = \"$row[7]\">Посмотреть</a>";
$serv = GetServiceById($row[3]);
$tp = GetDocTypeById($row[5]);
echo
"<tr><td>$row[1]</td><td>$row[2]</td><td>$serv</td><td>$tp</td><td>$s<td>
<a href = \"index.php?action=edit_docs_del&id=$row[0]\">Удалить</a><br><a href =
\"index.php?action=edit_docs_edit&id=$row[0]\">Редактировать</a></td></tr>";
$i++;
}
?>
</table>
<br/>
<hr/>
<br/>
<a href="index.php?action=edit_docs_add">Новый документ</a>
<?php
}
if ($action == "edit_docs_add")
{
?>
<h2 align = "center">Добавление нового документа</h2><br>
<form name="frm_docs" action="index.php" method="post" enctype="multipart/form-
data">
<table border="0" align="center">
<tr align="left"><td>Название документа:</td><td><input name="new_name"
type="text" /></td></tr>
<tr align="left"><td>Номер документа:</td><td><input name="new_number"
type="text" /></td></tr>
<tr align="left"><td>Служба:</td><td><?php EnumServices("new_service", -1, 0);
?></td></tr>
<tr align="left"><td>Дата:</td><td><input name="new_date" type="text"
/></td></tr>
108
<tr align="left"><td>Тип:</td><td><?php EnumDocTypes("new_type", -1, 0);
?></td></tr>
<tr align="left"><td>Файл документа:</td><td><input type = "file" name = "fnm"
class = "submit"></td></tr>
<tr align="left"><td></td><td><input name="Submit1" type="submit"
value="Добавить" class = "submit"/></td></tr>
</table>
<input name="action" type="hidden" value="edit_docs_add_complete" />
</form>
<?php
}
?>
Текст модуля enter.php
<?php
session_start();
include_once("db.php");
$logged = $_SESSION['logged'];
if ($logged) header("Locaion:index.php");
$login = $_REQUEST['login'];
$pass = $_REQUEST['pass'];
$action = $_REQUEST['action'];
if ($action == "enter")
{
$res = mysql_query("select * from users where used = 1 AND login = '$login' AND pass
= '$pass'");
$n = mysql_num_rows($res);
$row = mysql_fetch_array($res);
if ($n)
{
$_SESSION['logged'] = true;
$_SESSION['username'] = $row[3];
$_SESSION['admin'] = $row[4]-1;
$_SESSION['userid'] = $row[0];
header("Location:index.php");
//echo "Username = $row[3]";
}
else
{
echo "<p align = center>Неверный ввод!</p>";
}
}
?>
<br><br><h1 align="center">Система электронного
документооборота</h1><br><br>
<form name = "form1" action = "enter.php" method = "post">
<input type="hidden" name="action" value="enter">
<table border = 0 align="center"><tr><td>Логин:</td><td><input name = "login"
type = "text"></td></tr>
<tr><td>Пароль:</td><td><input name = "pass" type = "password"></td></tr>
<tr><td></td><td><input type = "submit" value = "Вход в
систему"></td></tr></table></form>
<br><br>
<?php
//include_once("doc.php");
//echo doc2text("1.doc");
109
?>
Текст модуля exit.php
<?php
session_start();
session_destroy();
header("Location:enter.php");
?>
Текст модуля find_show.php
<?php $new_name = $_REQUEST['new_name'];
$new_number = $_REQUEST['new_number'];
$new_service = $_REQUEST['new_service'];
$new_date = $_REQUEST['new_date'];
$new_type = $_REQUEST['new_type'];
$new_content = $_REQUEST['new_content'];
//$new_autor = $_SESSION['userid'];
//сформируем запрос
$q = "select * from docs where name LIKE '%$new_name%' AND number LIKE
'%$new_number%'";
if ($new_service > 0) $q = $q." AND service = $new_service";
$q = $q." AND d_date LIKE '%$new_date%'";
if ($new_type > 0) $q = $q." AND d_type = $new_type";
$res = mysql_query($q);
echo mysql_error();
$i = 0;
while ($row = mysql_fetch_array($res))
{
$ids[$i++] = $row[0];
}
//Теперь - поиск по содержимому
$i1 = 0;
if ($new_content)
{
$unc = "";
for ($k = 0; $k < strlen($new_content); $k++)
{
$unc .= "".sprintf("%x", ord($new_content[$k]) - 11*16).";";
}
$new_content = $unc;
$res = mysql_query($q);
while ($row = mysql_fetch_array($res))
{
$s = $row[7];
$txt = doc2text($s);
if (stripos($txt, $new_content) !== FALSE)
{
$ids1[$i1++] = $row[0];
}
}
$ids = $ids1;
$i = $i1;
}
if ($i == 0)
{
110
?>
<h2 align="center">По введённым критериям ничего не найдено.</h2><br/>
<?php
}
else
{
//$row = mysql_fetch_array($res);
//Теперь в массиве ids у нас находятся идентификаторы
//нужных нам документов
?>
<h2 align="center">Результаты поиска</h2><br/>
<table border="1" cellspacing="0" align="center">
<tr><td>Название</td><td>Номер</td><td><a href =
"index.php?action=find_show&sort=service">Служба</a></td><td><a href =
"index.php?action=find_show&sort=tp">Тип</a></td><td>Текст</td><td>Дейсвтие<
/td></tr>
<?php
//$res = mysql_query("select * from docs");
//$i = 1;
$j = 0;
while (/*$row = mysql_fetch_array($res)*/ $j < $i)
{
$o = "";
if ($sort == "service") $o = " ORDER BY service ";
if ($sort == "tp") $o = " ORDER BY d_type ";
$res = mysql_query("select * from docs where id = $ids[$j] $o");
$row = mysql_fetch_array($res);
$s = "<a href = \"$row[7]\">Посмотреть</a>";
$serv = GetServiceById($row[3]);
$tp = GetDocTypeById($row[5]);
echo
"<tr><td>$row[1]</td><td>$row[2]</td><td>$serv</td><td>$tp</td><td>$s<td>
<a href =
\"index.php?action=list_docs_show&id=$row[0]\">Посмотреть</a><br><br><a href =
\"index.php?action=list_docs_old&id=$row[0]\">Посмотреть
изменения</a></td></tr>";
$j++;
}
?>
</table>
<br/>
<hr/>
<br/>
<?php }
?>
Текст модуля find_start.php
<h2 align="center">Введите критерии для поиска документа</h2>
<form name="frm_docs" action="index.php" method="post">
<table border="0" align="center">
<tr align="left"><td>Название документа:</td><td><input name="new_name"
type="text" /></td></tr>
<tr align="left"><td>Номер документа:</td><td><input name="new_number"
type="text" /></td></tr>
<tr align="left"><td>Служба:</td><td><?php EnumServices("new_service", -1);
?></td></tr>
111
<tr align="left"><td>Дата:</td><td><input name="new_date" type="text"
/></td></tr>
<tr align="left"><td>Тип:</td><td><?php EnumDocTypes("new_type", -1);
?></td></tr>
<tr align="left"><td>Содержимое:</td><td><input name="new_content" type="text"
/></td></tr>
<tr align="left"><td></td><td><input name="Submit1" type="submit"
value="Искать!" class = "submit" /></td></tr>
</table>
<input name="action" type="hidden" value="find_show" />
</form>
Текст модуля functions.php
<?php
include_once("f_users.php");
include_once("f_services.php");
include_once("f_doctypes.php");
function GetBoolean($arg)
{
if ($arg) return "Да"; else return "Нет";
}
function DocIsUniq($name, $number)
{
$res = mysql_query("select * from docs where name = '$name' OR number =
'$number'");
return (mysql_num_rows($res) == 0);
}
function DateIsTrue($arg)
{
//echo "ARG = $arg<br>";
$ar = explode(".", $arg);
$c = count($ar);
//echo "Count = $c<br>";
if (count($ar) != 3) return 0;
//echo "Ar = $ar[0] $ar[1] $ar[2] <br>";
if ($ar[0] >= 1 && $ar[0] <= 31 && $ar[1] >= 1 && $ar[1] <= 12 && $ar[2] >= 1900
&& $ar[2] <= 2020) return 1; else return 0;
}
?>
Текст модуля index.php
<?php
include_once("session.php");
include_once("functions.php");
$action = $_REQUEST['action'];
$username = $_SESSION['username'];
$admin = $_SESSION['admin'];
$userid = $_SESSION['userid'];
112
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="ru" http-equiv="Content-Language"/>
<meta content="text/html; charset=windows-1251" http-equiv="Content-Type" />
<title>Электронный документооборот</title>
<link href="diplom.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table align="center" width="800">
<?php
include_once("header.php");
?>
<tr>
<td width="300" valign="top" style="border: thin dotted #808000">
Вы вошли как<br/>
<?php
$nm = $_SESSION['username'];
echo "$nm";
?>
<br/>
<?php
include_once("menu.php");
?>
</td>
<td class="auto-style3" valign="top" align ="center">
<?php
//начало маого главного
if (strstr($action, "doc_types"))
{
include_once("doc_types.php");
}
if (strstr($action, "services"))
{
include_once("services.php");
}
if (strstr($action, "edit_docs"))
{
include_once("edit_docs.php");
}
if (strstr($action, "list_docs"))
{
include_once("list_docs.php");
}
if (strstr($action, "find"))
{
if ($action == "find_show")
{
include_once("find_show.php");
113
}
if ($action == "find_start")
{
include_once("find_start.php");
}
}
if (strstr($action, "check_users"))
{
if ($action == "check_users_complete")
{
include_once("check_users_complete.php");
}
if ($action == "check_users")
{
include_once("check_users.php");
}
}
if (strstr($action, "register"))
{
if ($action == "register_complete")
{
include_once("register_complete.php");
}
if ($action == "register")
{
include_once("register.php");
}
}
//конец самого главного
?>
</td>
</tr>
</table>
<?php
include_once("footer.php");
?>
</body>
</html>
Текст модуля list_docs.php
<?php if ($action == "list_docs")
{
?>
<h2 align="center">Выберите документ для просмотра</h2><br/>
<table border="1" cellspacing="0" align="center">
<tr><td>Название</td><td>Номер</td><td><a href =
"index.php?action=list_docs&sort=service">Служба</a></td><td><a href =
"index.php?action=list_docs&sort=tp">Тип</a></td><td>Текст</td><td>Дейсвтие</
td></tr>
<?php
$sort = $_REQUEST['sort'];
if (!$sort)$res = mysql_query("select * from docs");
if ($sort == "service") $res = mysql_query("select * from docs order by service");
if ($sort == "tp") $res = mysql_query("select * from docs order by d_type");
114
$i = 1;
while ($row = mysql_fetch_array($res))
{
$s = "<a href = \"$row[7]\">Посмотреть</a>";
$serv = GetServiceById($row[3]);
$tp = GetDocTypeById($row[5]);
echo
"<tr><td>$row[1]</td><td>$row[2]</td><td>$serv</td><td>$tp</td><td>$s<td>
<a href =
\"index.php?action=list_docs_show&id=$row[0]\">Посмотреть</a><br><br><a href =
\"index.php?action=list_docs_old&id=$row[0]\">Посмотреть
изменения</a></td></tr>";
$i++;
}
?>
</table>
<br/>
<hr/>
<br/>
<?php
}
if ($action == "list_docs_show")
{
$id = $_REQUEST['id'];
$res = mysql_query("select * from docs where id = $id");
$row = mysql_fetch_array($res);
?>
<table border="0" align="center">
<tr align="left"><td>Название документа:</td><td><?php echo "$row[1]";
?></td></tr>
<tr align="left"><td>Номер документа:</td><td><?php echo "$row[2]";
?></td></tr>
<tr align="left"><td>Служба:</td><td><?php echo GetServiceById($row[3]); ?>
</td></tr>
<tr align="left"><td>Дата:</td><td><?php echo "$row[4]"; ?></td></tr>
<tr align="left"><td>Тип:</td><td><?php echo GetDocTypeById($row[5]);?>
</td></tr>
<tr align="left"><td>Текст документа:</td><td><a href = "<?php echo "$row[7]";
?>">Посмотреть</a></td></tr>
</table>
<?php
}
if ($action == "list_docs_old")
{
$id = $_REQUEST['id'];
?>
<h2 align="center">Здесь можно посмотреть старые версии выборанного
документа</h2><br/>
<table border="1" cellspacing="0" align="center">
<tr><td>Название</td><td>Номер</td><td>Дата</td><td>Дейсвтие</td></tr>
<?php
$res = mysql_query("select * from changes where document = $id");
$i = 1;
while ($row = mysql_fetch_array($res))
{
$s = $row[4];
115
echo "<tr><td>$row[2]</td><td>$row[3]</td><td>$s<td><a href =
\"index.php?action=list_docs_show_old&id=$row[0]\">Посмотреть</a></td></tr>";
$i++;
}
?>
</table>
<br/>
<hr/>
<br/>
<?php
}
if ($action == "list_docs_show_old")
{
$id = $_REQUEST['id'];
$res = mysql_query("select * from changes where id = $id");
$row = mysql_fetch_array($res);
?>
<table border="0" align="center">
<tr align="left"><td>Название документа:</td><td><?php echo "$row[2]";
?></td></tr>
<tr align="left"><td>Номер документа:</td><td><?php echo "$row[3]";
?></td></tr>
<tr align="left"><td>Служба:</td><td><?php echo GetServiceById($row[4]); ?>
</td></tr>
<tr align="left"><td>Дата:</td><td><?php echo "$row[5]"; ?></td></tr>
<tr align="left"><td>Автор:</td><td><?php echo GetUserById($row[6]);
?></td></tr>
<tr align="left"><td>Текст документа:</td><td><a href = "<?php echo "$row[7]";
?>">Посмотреть</a></td></tr>
</table>
<?php
}
?>