-
Notifications
You must be signed in to change notification settings - Fork 0
/
admin.inc.php
80 lines (80 loc) · 3.35 KB
/
admin.inc.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
<?php
require '../../helpers/init_conn_db.php';
session_start();
if(isset($_SESSION['adminId'])) {
if(isset($_POST['dep_but'])) {
$flight_id = $_POST['flight_id'];
$sql = "UPDATE Flight SET status='dep' WHERE flight_id=?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,'i',$flight_id);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
mysqli_close($conn);
header('Location: ../../admin/index.php');
exit();
}else if(isset($_POST['issue_but'])) {
$flight_id = $_POST['flight_id'];
$issue = $_POST['issue'];
$delay_time = gmdate('h:i:s',(int)$issue*60);
$sql = 'SELECT * FROM Flight WHERE flight_id=?';
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,'i',$flight_id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
if($row = mysqli_fetch_assoc($result)) {
$date_time_dep = $row['departure'];
$date_dep = substr($date_time_dep,0,10);
$time_dep = substr($date_time_dep,10,6) ;
$date_time_arr = $row['arrivale'];
$date_arr = substr($date_time_arr,0,10);
$time_arr = substr($date_time_arr,10,6) ;
$time_dep = new DateTime($date_time_dep);
$time_dep->add(new DateInterval('PT' . $issue . 'M'));
$stamp_dep = $time_dep->format('Y-m-d H:i:s');
$time_arr = new DateTime($date_time_arr);
$time_arr->add(new DateInterval('PT' . $issue . 'M'));
$stamp_arr = $time_arr->format('Y-m-d H:i:s');
$sql = "UPDATE Flight SET status='issue',issue=?,departure=?,arrivale=?
WHERE flight_id=?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,'sssi',$issue,$stamp_dep,$stamp_arr,$flight_id);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
mysqli_close($conn);;
header('Location: ../../admin/index.php');
exit();
}
} else if(isset($_POST['issue_soved_but'])) {
$flight_id = $_POST['flight_id'];
$sql = "UPDATE Flight SET status='',issue='solved' WHERE flight_id=?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,'i',$flight_id);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
mysqli_close($conn);
header('Location: ../../admin/index.php');
exit();
} else if(isset($_POST['arr_but'])) {
$flight_id = $_POST['flight_id'];
$issue = $_POST['issue'];
$sql = "UPDATE Flight SET status='arr'WHERE flight_id=?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,'i',$flight_id);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
mysqli_close($conn);
header('Location: ../../admin/index.php');
exit();
} else {
header('Location: ../../admin/index.php');
exit();
}
}else {
header('Location: ../../admin/index.php');
exit();
}