-
Notifications
You must be signed in to change notification settings - Fork 6
/
appointment_action.php
106 lines (103 loc) · 3.1 KB
/
appointment_action.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
<?php
include 'dbconnect.php';
date_default_timezone_set('asia/kolkata');
session_start();
$ii=0;
$f=0;
$service=$_POST['service'];
$sql=mysqli_query($con,"select * from tbl_category where ser_cat_name='$service'" );
$row=mysqli_fetch_array($sql);
$b=$row['ser_cat_id'];
$_SESSION['ser_cat_id']=$b;
$c=$row['Cat_id'];
$date=$_POST['txt_Appoinment_Date'];
$time=$_POST['time'];
$a=1;
$s=$_POST['txt_staff'];
$at="10:00";
$bt="16:30";
$ct=date("H:i");
$cd=date("Y-m-d");
if(($time>=$at)&&($time<=$bt))
{
if((($date==$cd)&&($time>$ct))||($date!=$cd))
{
$resu=mysqli_query($con,"select * from `tbl_appointment` where `Staff_id`='$s' and `Date`='$date' and `Status`!='5'");
while($rw=mysqli_fetch_array($resu))
{
$f=1;
$ti=$time;
$a1=strtotime("-15 minutes",strtotime($ti));
$a2=date("H:i",$a1);
$b1=strtotime("+15 minutes",strtotime($ti));
$b2=date("H:i",$b1);
$sel1="select * from `tbl_appointment` where `Time` BETWEEN '$a2' AND '$b2'";
$qry1=mysqli_query($con,$sel1);
$num=mysqli_num_rows($qry1);
if($num>0)
{
echo ("<script language='javascript'>window.alert('Already booked in this time..Try another time..')
window.location.href='appointment_add.php?uid=$_SESSION[ser_cat_id]';</script>");
}
else
{
$sql=mysqli_query($con,"select * from tbl_appointment where Date='$date' and `Staff_id`='$s'" );
while($row=mysqli_fetch_array($sql))
{
$ii++;
}
if($ii>2)
{
echo ("<script language='javascript'>window.alert('Appointment is full for the date:.$date')
window.location.href='appointment_add.php?uid=$_SESSION[ser_cat_id]'</script>");
break;
}
else
{
$sql=mysqli_query($con,"INSERT INTO `tbl_appointment`(`Reg_no`, `ser_cat_id`, `Cat_id`,`Date`,`Time`,`Staff_id`,`Status`)
VALUES ('$a','$b','$c','$date','$time','$s',1)");
if($sql)
{
echo ("<script language='javascript'>window.alert('Service Booked!!')
window.location.href='appointment_status.php';</script>");
}
else
{
echo ("<script language='javascript'>window.alert('Booking Failed.Try Again!!')
window.location.href='appointment_status.php';</script>");
}
}
}
}
if($f==0)
{
$sql=mysqli_query($con,"INSERT INTO `tbl_appointment`(`Reg_no`, `ser_cat_id`, `Cat_id`,`Date`,`Time`,`Staff_id`,`Status`)
VALUES ('$a','$b','$c','$date','$time','$s',1)");
if($sql)
{
echo ("<script language='javascript'>window.alert('Service Booked!!')
window.location.href='appointment_status.php';</script>");
}
else
{
echo ("<script language='javascript'>window.alert('Booking Failed.Try Again!!')
window.location.href='appointment_status.php';</script>");
}
}
}
else
{
?>
<center><h2><script language='javascript'>window.alert('Sorry,the time u selected already passed!!')
window.location.href='appointment_add.php?uid=<?php echo $_SESSION['ser_cat_id'];?>'</script></h2>
<?php
}
}
else
{
?>
<center><h2><script language='javascript'>window.alert('Sorry, Appointment time is from 10:00am - 4:30pm!!')
window.location.href='appointment_add.php?uid=<?php echo $_SESSION['ser_cat_id'];?>'</script></h2>
<?php
}
?>