SQLAdvisor/php-sqlreview/wait_order.php at master · ppabc/SQLAdvisor · GitHub

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
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>数据库上线工单查询</title>
<link rel="stylesheet" type="text/css" href="css/table.css">
</head>

<?php
session_start();
$prvi = $_SESSION['prvi'];
$login_user=$_SESSION['username'];

    if($prvi!=1){
        echo "非法访问！你没有权限审批工单！<br>";
        //echo '<meta http-equiv="Refresh" content="2;url=my_order.php"/>';
	exit;
    }

$mysql_server_name='localhost';
$mysql_username='root';
$mysql_password='111111';
$mysql_database='sql_db';

$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) or die("error connecting");
mysql_query("set names 'utf8'");
mysql_select_db($mysql_database);

$perNumber=50; //每页显示的记录数
$page=$_GET['page']; //获得当前的页面值
$count=mysql_query("select count(*) from sql_order_wait"); //获得记录总数
$rs=mysql_fetch_array($count);
$totalNumber=$rs[0];
$totalPage=ceil($totalNumber/$perNumber); //计算出总页数
/*if (!isset($page)) {
 $page=1;
} //如果没有值,则赋值1  */

if (empty($page)) {
 $page=1;
} //如果没有值,则赋值1

$startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的记录

$sql1 = "select user from login_user where user = '${login_user}' and privilege = 1";
$result1 = mysql_query($sql1,$conn);
if (mysql_num_rows($result1) > 0) {
	echo "Hi，管理员，等待你审批工单。<br>";
	$sql ="select a.* from sql_order_wait a";
}
else{
	$sql ="select a.* from sql_order_wait a join login_user b on a.ops_name = b.user where a.ops_name = '${login_user}'";
}
$result = mysql_query($sql,$conn);

echo "<h1 align='center' class='STYLE2'><a href='wait_order.php'>数据库上线工单查询</a></h1>";
echo "<hr />";

echo "<table class='bordered' width='1000px' height='100px' border='1' align='center'>";
echo "<tr>
	    <th>工单号</th>
            <th>申请人</th>
            <th>数据库名</th>
            <th>申请时间</th>
            <th>上线SQL</th>
	    <th>审批结果</th>
	    <th>操作</th>
          </tr>";
while($row = mysql_fetch_array($result))
{
$status = $row['status']?"<span style=''>已审批</span>":"<a href='update.php?id={$row['id']}&login_user=$login_user'>待审批</a>";
$exec_status = $row['status'];
$exec_finish_status = $row['finish_status'];
echo "<tr>";
echo "<td width='70'>{$row['id']}</td>";
echo "<td width='80'>{$row['ops_name']}</td>";
echo "<td width='120'>{$row['ops_db']}</td>";
echo "<td width='150' style='word-wrap:all'>{$row['ops_time']}</td>";
echo "<td style='word-wrap:break-word'><pre>{$row['ops_content']}</pre></td>";
if($prvi==1){
	if($exec_status==0){
		echo "<td width='60'>$status</br></td>";
	}
	if($exec_status==1){
		echo "<td width='60'>$status</br>
		审批人：</br>{$row['approver']}</td>";
	}
	if($exec_status==2){
		echo "<td width='80'>审批不通过</br>
		审批人：</br>{$row['approver']} </td>";
	}
}
else{
	echo "<td width='60'>等待审批中</td>";
}
#######################################################
if($exec_finish_status==1){
	echo "<td width='80'><a href='execute.php?id={$row['id']}'>执行工单</a></td>";
}
else if($exec_finish_status==2){
	echo "<td width='80'>已执行完</td>";
}
else{
	echo "<td width='80'>没审批不能执行</td>";
	//echo "<td width='80'><a href='cancel.php?id={$row['id']}'>自行撤销工单</a></td>";
}
echo "</tr>";
}
echo "</table>";

if ($page != 1) { //页数不等于1
?>
<a href='wait_order.php?page=<?php echo ($page - 1);?>'>上一页</a><!--显示上一页-->
<?php
}
for ($i=1;$i<=$totalPage;$i++) {  //循环显示出页面
?>
<a href="wait_order.php?page=<?php echo ($i);?>"><?php echo $i ;?></a>
<?php
}
if ($page<$totalPage) { //如果page小于总页数,显示下一页链接
?>
<a href="wait_order.php?page=<?php echo ($page + 1);?>">下一页</a>
<?php
}
?>


</html>