forked from LahiruSen/OOSD
-
Notifications
You must be signed in to change notification settings - Fork 0
/
leave_submission.php
116 lines (87 loc) · 3.59 KB
/
leave_submission.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
<?php
/* Reset your password form, sends reset.php password link */
require 'db.php';
if (session_status() == PHP_SESSION_NONE) { session_start();}
// Check if form submitted with method="post"
if ( $_SERVER['REQUEST_METHOD'] == 'POST' )
{ // set variables to be inserted to database
$reason = $mysqli->escape_string($_POST['reason']);
$description = $mysqli->escape_string($_POST['description']);
$start_date = $mysqli->escape_string($_POST['start_date']);
$end_date = $mysqli->escape_string($_POST['end_date']);
$date_of_create= $mysqli->escape_string( date("Y-m-d H:i:s"));
$date_of_update= $mysqli->escape_string( date("Y-m-d H:i:s"));
$datetime1 = new DateTime($start_date);
$datetime2 = new DateTime($end_date);
$number_of_dates = $datetime2->diff($datetime1)->d;
$email = $_SESSION['email'];
$result = $mysqli->query("SELECT id FROM users WHERE email='$email'");
if ( $result->num_rows == 0 ) // User doesn't exist
{
$_SESSION['message'] = "This user detail doesn't exist in the system.";
header("location: error.php");
die();
}
else { // User exists (num_rows != 0)
$user = $result->fetch_assoc(); // $user becomes array with user data
$user_id = $user['id'];
$result_new = $mysqli->query("SELECT employee_id FROM employee_data WHERE user_id='$user_id' " );
if($result_new->num_rows==0){
$_SESSION['message']="This employ detail doesn't exist in the system.";
header("location:error.php");
die();
}
else{
$employee = $result_new->fetch_assoc(); // employ become arry with employ data
$employee_id = $employee['employee_id'];
$sql = "INSERT INTO leave_submission (employee_id, reason, description, number_of_dates, start_date, end_date, date_of_create,date_of_update) "
. "VALUES ('$employee_id','$reason','$description','$number_of_dates', '$start_date', '$end_date','$date_of_create','$date_of_update',)";
if ( $mysqli->query($sql) ) {
$_SESSION['message']="Your leave application is uploaded successfully";
header("location:success.php");
die();
}
else{
$_SESSION['message']="Sorry. Your application could not be uploaded";
header("location:error.php");
die();
}
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Apply for Leave</title>
<?php include 'css/css.html'; ?>
</head>
<body>
<div class="form">
<h1>Apply for leave</h1>
<form action="leave_submission.php" method="post">
<div class="field-wrap">
<label>
Reason for Leave<span class="req">*</span>
</label>
<input type="text" name="reason"/>
<label>
Description<span class="req">*</span>
</label>
<textarea name='description'value= 'Please describe the reason briefly.'rows="4" cols="50"></textarea>
<label>
Start Date<span class="req">*</span>
</label>
<input type="date" name="start_date" max="2018-12-31" min= "<?php echo date('Y-m-d'); ?>" >
<label>
End Date<span class="req">*</span>
</label>
<input type="date" name="end_date" max="2018-12-31" min="<?php echo date('Y-m-d'); ?> ">
</div>
<button class="button button-block"/>Apply </button>
</form>
</div>
<script src='js/jquery.min.js'></script>
<script src="js/index.js"></script>
</body>
</html>