/
CableType.php
177 lines (170 loc) · 6.8 KB
/
CableType.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
<?php
require_once("auth.php");
require_once("smarty.php");
require_once("func/CableType.php");
require_once("design_func.php");
if ($_SERVER["REQUEST_METHOD"] == 'POST') {
$back = $_POST['back'];
if ($_POST['mode'] == 1)
{
$id = $_POST['id'];
$marking = $_POST['marking'];
$manufacturer = $_POST['manufacturer'];
$tubeQuantity = $_POST['tubeQuantity'];
$fiberPerTube = $_POST['fiberPerTube'];
$tensileStrength = $_POST['tensileStrength'];
$diameter = $_POST['diameter'];
$comment = $_POST['comment'];
$res = CableType_Mod($id, $marking, $manufacturer, $tubeQuantity, $fiberPerTube, $tensileStrength, $diameter, $comment);
if (isset($res['error'])) {
$message = $res['error'];
$error = 1;
} elseif ($res == 1) {
header("Refresh: 3; url=".$back);
$message = 'Тип кабеля изменен!';
$error = 0;
} else {
$message = 'Неверно заполнены поля!';
$error = 1; }
}
elseif ($_POST['mode'] == 2) {
$marking = $_POST['marking'];
$manufacturer = $_POST['manufacturer'];
$tubeQuantity = $_POST['tubeQuantity'];
$fiberPerTube = $_POST['fiberPerTube'];
$tensileStrength = $_POST['tensileStrength'];
$diameter = $_POST['diameter'];
$comment = $_POST['comment'];
$res = CableType_Add($marking, $manufacturer, $tubeQuantity, $fiberPerTube, $tensileStrength, $diameter, $comment);
if (isset($res['error'])) {
$message = $res['error'];
$error = 1;
} elseif ($res == 1) {
header("Refresh: 3; url=".$back);
$message = 'Тип кабеля добавлен!';
$error = 0;
} else {
$message = 'Неверно заполнены поля!';
$error = 1;
}
}
showMessage($message, $error);
} else {
if (!isset($_GET['mode'])) {
$page = (isset( $_GET[ 'page' ] )) ? $_GET[ 'page' ] : 1;
$sort = (isset( $_GET[ 'sort' ] )) ? $_GET[ 'sort' ] : 0;
$res = CableType_SELECT($sort, '', $config['LinesPerPage'], ($page-1)*$config['LinesPerPage']);
$pages = genPages('CableType.php?sort='.$sort.'&', ceil($res['allPages']/$config['LinesPerPage']), $page);
$rows = $res['rows'];
$i = -1;
while (++$i<$res['count']) { $CableType_arr[] = $rows[$i]['id'];
$CableType_arr[] = '<a href="CableType.php?mode=charac&cabletypeid='.$rows[$i]['id'].'">'.$rows[$i]['marking'].'</a>';
$CableType_arr[] = $rows[$i]['manufacturer'];
$CableType_arr[] = $rows[$i]['tubeQuantity'];
$CableType_arr[] = $rows[$i]['fiberPerTube'];
$CableType_arr[] = $rows[$i]['tensileStrength'];
$CableType_arr[] = $rows[$i]['diameter'];
$wr['CableType'] = $rows[$i]['id'];
$res2 = CableLine_SELECT('', $wr, '', '');
if ($res2['count'] > 0) {
$CableType_arr[] = '<a href="CableLine.php?typeid='.$rows[$i]['id'].'">'.$res2['count'].'</a>';
$CableType_arr[] = '<a href="CableType.php?mode=change&cabletypeid='.$rows[$i]['id'].'">Изменить</a>';
$CableType_arr[] = '';
} else {
$CableType_arr[] = $res2['count'];
$CableType_arr[] = '<a href="CableType.php?mode=change&cabletypeid='.$rows[$i]['id'].'">Изменить</a>';
$CableType_arr[] = '<a href="CableType.php?mode=delete&cabletypeid='.$rows[$i]['id'].'">Удалить</a>';
}
}
$smarty->assign("data", $CableType_arr);
$smarty->assign('pages', $pages);
$smarty->assign( "sort", $sort ? '0' : '1' );
$smarty->assign("mode", '');
} elseif (($_GET['mode'] == 'change') and (isset($_GET['cabletypeid']))) {
if ($_SESSION['class'] > 1) {
$message = '!!!';
showMessage($message, 0);
} $smarty->assign("mode", "add_change");
$smarty->assign("mod", "1");
$smarty->assign("back", getenv("HTTP_REFERER"));
$wr['id'] = $_GET['cabletypeid'];
$res = CableType_SELECT(0, $wr);
if ($res['count'] < 1) {
$message = 'Типа кабеля с таким ID не существует!<br />
<a href="CableType.php">Назад</a>';
showMessage($message, 0);
}
$rows = $res['rows'];
$smarty->assign("id", $rows[0]['id']);
$smarty->assign("marking", $rows[0]['marking']);
$smarty->assign("manufacturer", $rows[0]['manufacturer']);
$smarty->assign("tubeQuantity", $rows[0]['tubeQuantity']);
$smarty->assign("fiberPerTube", $rows[0]['fiberPerTube']);
$smarty->assign("tensileStrength", $rows[0]['tensileStrength']);
$smarty->assign("diameter", $rows[0]['diameter']);
$smarty->assign("comment", $rows[0]['comment']);
} elseif (($_GET['mode'] == 'charac') and (isset($_GET['cabletypeid']))) {
if ($_SESSION['class'] > 1) {
$message = '!!!';
showMessage($message, 0);
}
$smarty->assign("mode", "charac");
$wr['id'] = $_GET['cabletypeid'];
$res = CableType_SELECT(0, $wr);
if ($res['count'] < 1) {
$message = 'Типа кабеля с таким ID не существует!<br />
<a href="CableType.php">Назад</a>';
showMessage($message, 0);
}
$rows = $res['rows'];
$changeDelete = '<a href="CableType.php?mode=change&cabletypeid='.$_GET['cabletypeid'].'">Изменить</a>';
unset($wr);
$wr['CableType'] = $_GET['cabletypeid'];
$res2 = CableLine_SELECT('', $wr, '', '');
$changeDelete = '';
if ($res2['count'] == 0) {
$changeDelete .= '<a href="CableType.php?mode=delete&cabletypeid='.$_GET['cabletypeid'].'">Удалить</a>';
}
$smarty->assign("id", $rows[0]['id']);
$smarty->assign("marking", $rows[0]['marking']);
$smarty->assign("manufacturer", $rows[0]['manufacturer']);
$smarty->assign("tubeQuantity", $rows[0]['tubeQuantity']);
$smarty->assign("fiberPerTube", $rows[0]['fiberPerTube']);
$smarty->assign("tensileStrength", $rows[0]['tensileStrength']);
$smarty->assign("diameter", $rows[0]['diameter']);
$smarty->assign("comment", nl2br($rows[0]['comment']));
$smarty->assign("ChangeDelete", $changeDelete);
} elseif ($_GET['mode'] == 'add') {
$smarty->assign("id", '');
$smarty->assign("marking", '');
$smarty->assign("manufacturer", '');
$smarty->assign("tubeQuantity", 0);
$smarty->assign("fiberPerTube", 0);
$smarty->assign("tensileStrength", 0);
$smarty->assign("diameter", 0);
$smarty->assign("comment", '');
if ($_SESSION['class'] > 1)
{
$message = '!!!';
showMessage($message, 0);
}
$smarty->assign("mode", "add_change");
$smarty->assign("mod", "2");
$smarty->assign("back", getenv("HTTP_REFERER"));
} elseif (($_GET['mode'] == 'delete') and (isset($_GET['cabletypeid']))) {
if ($_SESSION['class'] > 1) { $message = '!!!';
showMessage($message, 0);
} $wr['id'] = $_GET['cabletypeid'];
CableType_Delete($wr);
header("Refresh: 2; url=".getenv("HTTP_REFERER"));
$message = 'Тип кабеля удален!';
showMessage($message, 0);
}
$smarty->display('CableType.tpl');
}
?>