-
Notifications
You must be signed in to change notification settings - Fork 0
/
shift_employees.php
133 lines (109 loc) · 4.23 KB
/
shift_employees.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
<?php
//includeing the database
include 'database/db.php';
//Takeing current date
$now = new DateTime(null, new DateTimeZone('Asia/Kolkata'));
$curr_date = $now->format('Y-m-d');
$curr_time = $now->format('H:i');
//Createing array for errors
$alert = array();
//On Form Submission
if(isset($_POST["submit"]))
{
logEvent('Form Submitting.');
$cat = '11';
$date = $_POST["Date"];
$VN = $_POST["Vehicle_Number"];
$TOV = $_POST["Type_of_Vehicle"];
$PN = $_POST["Phone_Number"];
$PU = $_POST["Pickup"];
$drop = $_POST["Drop"];
$len = strlen($PN);
// Checking the mobile number
if($len!=10)
{
$msg = 'Phone Number Not Valid. ';
logEvent($msg);
$alert[]= $msg;
}
//Checking that the date or time is not less than current time
if($curr_date>$date)
{
$msg = 'Date OR Time is Less than current date OR Time.';
logEvent($msg);
$alert[]= $msg;
}
//If No Errors
if(count($alert)==0)
{
logEvent('SQL Statement Parsing.');
$sql = "insert into master(catergory,date1,Vehicle_Number,Type_Of_Vehicle,Mobile_Number,Pickup_Place,Drop_Place) values('$cat','$date','$VN','$TOV','$PN','$PU','$drop');";
logEvent('Statement Parsing Done.');
logEvent($sql);
if(mysqli_query($conn,$sql))
{
$msg = 'Success..!!';
logEvent($msg);
$alert[]= $msg;
logEvent('----Form Session Over---');
}
else{
$msg = 'SQL Insertion Error.';
logEvent($msg);
$alert[]= $msg;
logEvent('----Form Session Over---');
}
}
//If Errors
else{
$msg = 'Entry Was Not Successfull..!!';
logEvent($msg);
$alert[]= $msg;
logEvent('----Form Session Over---');
}
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Shift Employees Form</title>
<link rel="stylesheet" href="css/style.css">
</head>
<body>
<div class = "main"><hr>
<?php logEvent('----Shift Employees Form Session Started---'); ?>
<h1><b><i>Shift Employees Form</i></b></h1><hr>
<div class = "error" padding-bottom = "5px"><?php foreach($alert as $a) {echo "--> ".$a."<br>";}?></div>
<?php logEvent('Form Loading'); ?>
<form method = "POST" action = "shift_employees.php" autocomplete="off" >
<table>
<tr><td>Date:</td><td ><input type="date" name="Date" id = "Date" value = "<?php echo $curr_date; ?>"/></td></tr>
<tr><td>Vehicle No.: </td><td> <input type="text" name="Vehicle_Number" /></td></tr>
<tr><td>Type of Vehicle: </td><td> <input type="text" name="Type_of_Vehicle" /></td></tr>
<tr><td>Phone Number: </td><td> <input type="text" maxlength=10 name="Phone_Number" /></td></tr>
<tr><td>Pickup: </td><td> <input type="text" name="Pickup" /></td></tr>
<tr><td>Drop: </td><td> <input type="text" name="Drop" /></td></tr>
</table>
<table border-style = "none">
<tr><td align = "center"><input type = "submit" name ="submit"/></td><td><input type = "reset" name = "reset"/><td><a href = "index.php"><input type = "button" name = "back" value = "Back"/></a></td></tr>
</table>
</form>
<?php logEvent('Shift Employees Form Load Complete.'); ?>
<!--Shift Employees Form Ends-->
</div>
</body>
</html>
<?php
//Function to record all the activities in the Program
function logEvent($message) {
if ($message != '') {
$now = new DateTime(null, new DateTimeZone('Asia/Kolkata'));
$curr_date = $now->format('Y-m-d');
$curr_time = $now->format('H:i:s');
$message = $curr_date.' '.$curr_time.' : '.$message;
$fp = fopen('Logs/log.txt', 'a');
fwrite($fp, $message."\n");
fclose($fp);
}
}
?>