-
Notifications
You must be signed in to change notification settings - Fork 29
/
finish_order.php
210 lines (174 loc) · 6.39 KB
/
finish_order.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
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
<!doctype html>
<html class="x-admin-sm">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta http-equiv="refresh" content="60" />
<title>数据库上线工单查询</title>
<style type="text/css">
a:link { text-decoration: none;color: #3366FF}
a:active { text-decoration:blink;color: green}
a:hover { text-decoration:underline;color: #6600FF}
a:visited { text-decoration: none;color: green}
</style>
<script type="text/javascript" src="xadmin/js/jquery-3.3.1.min.js"></script>
<script src="xadmin/lib/layui/layui.js" charset="utf-8"></script>
<script type="text/javascript" src="xadmin/js/xadmin.js"></script>
<link rel="stylesheet" href="./css/bootstrap.min.css">
<link rel="stylesheet" href="./slowlog/css/simple-line-icons/css/simple-line-icons.css">
<link rel="stylesheet" href="./slowlog/css/font-awesome/css/fontawesome-all.min.css">
<link rel="stylesheet" href="./slowlog/css/styles.css">
</head>
<?php
session_start();
$prvi = $_SESSION['prvi'];
$login_user=$_SESSION['username'];
if($prvi==0){
echo "<br><h1> 非法访问！你没有权限审批工单！</h1><br>";
//echo '<meta http-equiv="Refresh" content="2;url=my_order.php"/>';
exit;
}
?>
<!--
<body>
<div class="card">
<div class="card-header bg-light">
<h1>数据库上线工单查询</h1>
</div>
<div class="card-body">
<div class="table-responsive">
-->
<?php
require 'conn.php';
$perNumber=50; //每页显示的记录数
$page=$_GET['page']; //获得当前的页面值
$count=mysqli_query($conn,"select count(*) from sql_order_wait"); //获得记录总数
$rs=mysqli_fetch_array($count);
$totalNumber=$rs[0];
$totalPage=ceil($totalNumber/$perNumber); //计算出总页数
if (empty($page)) {
$page=1;
} //如果没有值,则赋值1
$startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的记录
?>
<body>
<div class="card">
<div class="card-header bg-light">
<h1>数据库上线工单查询 总计：<?php echo $totalNumber."个";?></h1>
</div>
<div class="card-body">
<div class="table-responsive">
<!--添加统计图-->
<div id="main" style="height:400px"></div>
<?php include 'stat/sql_order_stat.html'; ?>
<?php
$sql1 = "select user from login_user where user = '${login_user}' and privilege in(1,100)";
$result1 = mysqli_query($conn,$sql1);
if (mysqli_num_rows($result1) > 0) {
echo "Hi，管理员，等待你审批工单。<br>";
$sql ="select a.*,b.real_user from sql_order_wait a join login_user b on a.ops_name = b.user order by id DESC limit $startCount,$perNumber";
//$sql ="SELECT a.*,b.real_user AS approver_real_name,c.real_user FROM sql_order_wait a JOIN login_user b ON a.approver = b.user JOIN login_user c ON a.ops_name = c.user ORDER BY id DESC limit $startCount,$perNumber";
}
$result = mysqli_query($conn,$sql);
echo "<br>";
echo "<form action='order_result.php' method='get'>
<p align='left'>输入工单号:
<input type='text' name='ops_order' value=''>
<input name='submit'type='submit' value='查询' />
</p>
</form>";
echo "<table style='table-layout:fixed;width:100%;font-size:15px;' class='table table-bordered'>";
echo "<tr>
<th style='width:10%'>工单号</th>
<th>申请人</th>
<th>数据库名</th>
<th>申请时间</th>
<th>工单名称</th>
<th>申请原因</th>
<th>审批结果</th>";
if($prvi!=1){
echo " <th>操作</th>
</tr>";
}
while($row = mysqli_fetch_array($result))
{
$status = $row['status']?"<span style=''>已审批</span>":"<span class='badge badge-warning'><a href='update.php?id={$row['id']}&login_user=$login_user&prvi=$prvi&return_status=1'><font size='4'>待审批</font></a></span>";
$ddl_alter=0;
$exec_status = $row['status'];
$exec_finish_status = $row['finish_status'];
echo "<tr>";
echo "<td>{$row['ops_order']}</td>";
echo "<td>{$row['real_user']}</td>";
echo "<td>{$row['ops_db']}</td>";
echo "<td>{$row['ops_time']}</td>";
echo "<td><a href='javascript:void(0);' onclick=\"x_admin_show('工单内容详细信息','sql_statement.php?id={$row['id']}')\">{$row['ops_order_name']}</a></td>";
echo "<td>{$row['ops_reason']}</td>";
if($prvi==1 || $prvi=100){
if($exec_status==0){
echo "<td>$status</td>";
}
if($exec_status==1){
echo "<td>$status</br>
审批人:{$row['approver']}</td>";
}
if($exec_status==2){
echo "<td>审批不通过</br>
审批人：</br>{$row['approver']} </td>";
}
}
else{
echo "<td>等待审批中</td>";
}
#######################################################
if($prvi==100){
if($exec_finish_status==1){
echo "<td ><a href='execute.php?id={$row['id']}'>执行工单</a></td>";
//echo "<a href='cancel.php?id={$row['id']}'>自行撤销工单</a></td>";
}
else if($exec_finish_status==2){
echo "<td >已执行</br>";
echo "<a href='rollback.php?id={$row['id']}'>生成反向SQL</a></td>";
}
else{
echo "<td >没审批不能执行</br>
<a href='cancel.php?id={$row['id']}'>自行撤销工单</a>
</td>";
//echo "<td width='80'><a href='cancel.php?id={$row['id']}'>自行撤销工单</a></td>";
}
echo "</tr>";
} //end if($prvi==100)
}//end while
echo "</table>";
echo "</div>";
echo "</div>";
echo "</div>";
$maxPageCount=10;
$buffCount=2;
$startPage=1;
if ($page< $buffCount){
$startPage=1;
}else if($page>=$buffCount and $page<$totalPage-$maxPageCount ){
$startPage=$page-$buffCount+1;
}else{
$startPage=$totalPage-$maxPageCount+1;
}
$endPage=$startPage+$maxPageCount-1;
$htmlstr="";
$htmlstr.="<table class='bordered' border='1' align='center'><tr>";
if ($page > 1){
$htmlstr.="<td> <a href='finish_order.php?page=" . "1" . "'>第一页</a></td>";
$htmlstr.="<td> <a href='finish_order.php?page=" . ($page-1) . "'>上一页</a></td>";
}
$htmlstr.="<td> 总共${totalPage}页</td>";
for ($i=$startPage;$i<=$endPage; $i++){
$htmlstr.="<td><a href='finish_order.php?page=" . $i . "'>" . $i . "</a></td>";
}
if ($page<$totalPage){
$htmlstr.="<td><a href='finish_order.php?page=" . ($page+1) . "'>下一页</a></td>";
$htmlstr.="<td><a href='finish_order.php?page=" . $totalPage . "'>最后页</a></td>";
}
$htmlstr.="</tr></table>";
echo $htmlstr;
?>
</html>