setBlock.php
5.49 KB
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
<?php
session_start();
require_once 'classes/realops.php';
$get = new Get();
$stats = new Stats();
date_default_timezone_set('Australia/Sydney');
$db = db::connect();
$pilots = $db->getRow("SELECT * FROM tbl_pilots WHERE id = ?", array($_SESSION['id']));
if($pilots['atc'] != 1)
{
echo "Unauthorised";
die();
}
if(isset($_POST['blockOff']) || isset($_POST['blockOut']) || isset($_POST['blockOn']) || isset($_POST['blockIn']))
{
$_POST['blockOff'] = (int)$_POST['blockOff'];
$_POST['blockOut'] = (int)$_POST['blockOut'];
$_POST['blockOn'] = (int)$_POST['blockOn'];
$_POST['blockIn'] = (int)$_POST['blockIn'];
if($_POST['blockOff'] == "")
$_POST['blockOff'] = 0;
else if($_POST['blockOut'] == "")
$_POST['blockOut'] = 0;
else if($_POST['blockOn'] == "")
$_POST['blockOn'] = 0;
else if($_POST['blockIn'] == "")
$_POST['blockIn'] = 0;
$db = db::connect();
$db->updateRow("UPDATE tbl_bookings SET blockOff = ?, blockOut = ?, blockOn = ?, blockIn = ? WHERE id = ?", array($_POST['blockOff'], $_POST['blockOut'], $_POST['blockOn'], $_POST['blockIn'], $_POST['id']));
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php include 'sections/header.php'; ?>
</head>
<body>
<div class="wrapper">
<?php include 'sections/navbar.php' ?>
<div class="container" id="realops-container">
<div class="row">
<article class="col-sm-12 panel panel-default" id="realops-body">
<h2 class="sub-header">Set Block Time</h2>
<form method="get" action="setBlock.php" class="form-horizontal" >
<p class="help-block">If the callsign does not appear here, it has not been booked</p>
<div class="form-group">
<label class="col-sm-3 control-label">Select Flight:</label>
<div class="col-sm-6">
<select name="flight" class="form-control">
<option selected disabled>Select one...</option>
<?php foreach($get->bookings() as $row)
{?>
<option <?php if($_GET['flight'] == $row['bookingID']) echo "selected"; ?> value="<?php echo $row['bookingID']; ?>"><?php echo $row['airline'] . $row['flightnum']; ?> (<?php echo $row['pilotName'] ?>)</option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<button type="submit" class="btn btn-primary">Request</button>
</div>
</form>
<?php if(isset($_GET['flight']))
{
$bookings = $get->booking($_GET['flight']);
$flight = $get->flight($bookings['flight']);
?>
<div class="well">
<h3><?php echo $flight['airline'] . $flight['flightnum']; ?></h3>
<h4>Scheduled <?php if($flight['deparr'] == 0) echo "Off"; else echo "On"; ?> Blocks: <?php echo date('Hi', strtotime($flight['time']) - 36000); ?>z</h4>
<form method="post" action="setBlock.php" class="form-horizontal" >
<div class="form-group">
<label class="col-sm-3 control-label">Block Out:</label>
<div class="col-sm-6">
<input type="text" <?php if($flight['deparr'] == 1 || $flight['blockOff'] != 0) echo "readonly"; ?> class="form-control" name="blockOut" value="<?php echo $bookings['blockOut']; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Block Off:</label>
<div class="col-sm-6">
<input type="text" <?php if($flight['deparr'] == 1 || !empty($flight['blockOut'])) echo "readonly"; ?> class="form-control" name="blockOff" value="<?php echo $bookings['blockOff']; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Block On:</label>
<div class="col-sm-6">
<input type="text" <?php if($flight['deparr'] == 0 || !empty($flight['blockOn'])) echo "readonly"; ?> class="form-control" name="blockOn" value="<?php echo $bookings['blockOn']; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Block In:</label>
<div class="col-sm-6">
<input type="text" <?php if($flight['deparr'] == 0 || !empty($flight['blockIn'])) echo "readonly"; ?> class="form-control" name="blockIn" value="<?php echo $bookings['blockIn']; ?>">
</div>
</div>
<input type="hidden" name="id" value="<?php echo $_GET['flight'] ?>">
<div class="form-group">
<button type="submit" class="btn btn-primary">Update/Save</button>
</div>
</form>
</div>
<?php } ?>
</article>
</div><!-- /.row -->
</div><!-- /.container -->
</div><!-- /.wrapper -->
<?php include 'sections/footer.php'; ?>