77
СПИСОК ИСПОЛЬЗОВАННОЙ ЛИТЕРАТУРЫ
1 -
2
4.
184
3
- 2016. - 464 c.
4
- .
- 5.
5
--
-14. - 544 c.
6 -
- .
- 244 c.
7
.
4.
8
-
- 283 c.
9
300 .
10
3-. 5. 400 .
11
- 5. 176 c.
78
12
.: 6.
13
- 14. - 368 c.
14
-- -2009. - 400 c.
15 -5.
16 MS SQL Server.
- 5. 232 .
17
. - , 2016. 176 c.
18 -
-- , 2015. - 256 c
19 - -
15. - 928 c.
20 --
- 747 c
21 - -
2016. - 644 c.
22
- - 304 c.
79
ПРИЛОЖЕНИЕ 1
PHP MySQL.
<?php
print '<!-- Main Content -->
<div class="page-wrapper">
<div class="container-fluid">
<!-- Title -->
<div class="row heading-bg">
<div class="col-lg-3 col-md-4 col-sm-4 col-xs-
12">
<h5 class="txt-
</div>
</div>
80
<!-- /Title -->
<div class="row">
<div class="col-sm-12">
<div class="anel panel-default
card-view">
<div class="panel-wrapper
collapse in">
<div class="panel-
body">
<div
class="form-wrap">
<form
method="post" action="../components/processor.php" enctype="multipart/form-
data">
<div class="form-group">
<label class="control-label mb-10"><font color="red">*</font></label>
<select name="type" class="selectpicker" data-style="form-control btn-default
btn-outline" required>
<option value="2"> </option>
<option value="3"> </option>
81
</select>
</div>
<div class="form-group">
<label class="control-label mb-10 text-left" for="example-
title"><font color="red">*</font></label>
<input type="text" name="title" class="form-control" required>
</div>
<div class="form-group">
<label class="control-label mb-10 text-left"><font
color="red">*</font></label>
<textarea name="description" class="form-control" rows="5"
required></textarea>
</div>
<div class="form-group">
<label class="control-label mb-10 text-left"> <font
color="red">*</font></label>
82
<input type="date" name="date" class="form-control" required>
</div>
<div class="form-group">
<p class="text-muted"> <font color="red">*</font></p>
<div
class="row">
<div
class="col-sm-12">
<h5 class="box-title"></h5>
<select name="responsible" id="pre-selected-options" multiple="multiple"
required>
';
print "{$GetList()}";
print '
</select>
</div>
</div>
</div>
83
<div class="form-group">
<label class="control-label mb-10"><font
color="red">*</font></label>
<select name="controlling" class="form-control select2">
';
foreach ($control as $value) {
echo "<option value='$value'>$value</option>";
}
print '
</select>
</div>
<div class="form-group">
<label class="control-label mb-10 text-left"> <font
color="red">*</font></label>
<input name="upload[]" type="file" multiple="multiple" required/>
</div>
84
<div class="form-group">
<input type="hidden" name="author" value="'.$_SESSION['login'].'">
<input type="submit" class="btn btn-primary btn-icon left-icon"
value=" ">
<a href="?param=edict" class="btn btn-primary btn-icon left-icon" id="btn-
add-i"><span></span></a>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>';
?>
case "$IsWebUrl/index.php?param=add_material":
if (isset($_POST['title'])) { $title = $_POST['title']; if ($title == '') {
unset($title); print_r (0); return false;} }
if (isset($_POST['description'])) { $description = $_POST['description'];
if ($description == '') { unset($description); print_r (0); return false;} }
85
if (isset($_POST['date'])) { $date = $_POST['date']; if ($date == '') {
unset($date); print_r (0); return false;} }
if (isset($_POST['responsible'])) { $responsible =
$_POST['responsible']; if ($responsible == '') { unset($responsible); print_r (0);
return false;} }
if (isset($_POST['controlling'])) { $controlling = $_POST['controlling'];
if ($controlling == '') { unset($controlling); print_r (0); return false;} }
if (isset($_POST['author'])) { $author = $_POST['author']; if ($author ==
'') { unset($author); print_r (0); return false;} }
if (isset($_POST['type'])) { $type = $_POST['type']; if ($type == '') {
unset($type); print_r (0); return false;} }
$IsDate = date('Y-m-d');
$IsTime = date("H:i:s");
if(isset($_FILES) && $_FILES['inputfile']['error'] == 0)
{
$total = count($_FILES['upload']['name']);
$sql = "INSERT INTO `materials` (`type`,`name`, `description`,
`author`, `responsible`, `controlling`, `created_d`, `closed`, `closed_fact`, `status`)
VALUES ('$type','$title', '$description', '$author', '$responsible', '$controlling',
'$IsDate', '$date', '$date', 0);";
$result = $mysqli->query($sql);
$mid = $mysqli->insert_id;
$title";
$sql_l = "INSERT INTO `logs` (`text`,`date`, `time`) VALUES
('$logs','$IsDate', '$IsTime');";
86
$result_l = $mysqli->query($sql_l);
for($i=0; $i<$total; $i++)
{
$tmpFilePath = $_FILES['upload']['tmp_name'][$i];
if ($tmpFilePath != "")
{
$NewNameFile = "p_".$mid."_".$IsDate."_".
$_FILES['upload']['name'][$i];
$newFilePath = "../uploads/p_".$mid."_".$IsDate."_".
$_FILES['upload']['name'][$i];
if(move_uploaded_file($tmpFilePath, $newFilePath))
{
$sql1 = "INSERT INTO `source`
(`mid`,`filename`,`type`) VALUES
('$mid','".$NewNameFile."','".$_FILES['upload']['type'][$i]."');";
$result1 = $mysqli->query($sql1);
}
}
}
exit ("<html><head><meta http-equiv='Refresh' content='0;
URL=$IsWebUrl/index.php?param=edict'></head></html>");
print_r (1);
}
else
{
$sql = "INSERT INTO `materials` (`type`,`name`, `description`,
`author`, `responsible`, `controlling`, `created_d`, `closed`, `closed_fact`, `status`)