-
Notifications
You must be signed in to change notification settings - Fork 1
/
loadCalendar.php
51 lines (35 loc) · 1.72 KB
/
loadCalendar.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
<?php
$lu=$_REQUEST['user'];
//set IE read from page only not read from cache
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header("content-type: application/x-javascript; charset=tis-620");
include("connect_sql.php");
$result=pg_query($db,"select * from \"Appointment\" where \"CustomerUserID\" = $lu and \"Status\"='Confirmed';");
$out = array();
while($row=pg_fetch_array($result)){
$today=$row[6];
$today=strftime("%Y-%m-%d", strtotime("$today -1 day"));
$datefinal= strtotime($row[7]);
$days=$row[8];
$sid=$row[1];
$spid=$row[2];
$rid=$row[3];
$queryin="select * from \"Provides\" where \"RegionID\" = $rid and \"ServiceID\" = $sid and \"ServiceProviderUserID\" = $spid;";
$query=pg_query($db,$queryin);
while($queryrow=pg_fetch_array($query)){
$name=$queryrow[6];
}
while (strtotime($today)<=$datefinal)
{
$today=strftime("%Y-%m-%d", strtotime("$today +1 day"));
$dayofweek = date('w', strtotime($today));
if($days[$dayofweek]=='1'){
array_push($out, array( 'startDate' => $today, 'endTime' => $row[10], 'startTime' => $row[9], 'caption1' => $name));
}
}
}
echo json_encode($out);
?>