-
Notifications
You must be signed in to change notification settings - Fork 1
/
acceptRejectHash.php
128 lines (112 loc) · 4.35 KB
/
acceptRejectHash.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
<?php
include("essential.php");
dbconnect();
//print_r($_POST);
//echo $_POST['forwardID'];
$a="accept";
$b="reject";
$c="forward";
$d= "Specify a reason for rejection (optional) )";
$rID = getIDFromHash($_POST['reqID']);
$reqArray = getRequestByID(getIDFromHash($_POST['reqID']));
//print_r($reqArray);
$clashArrays = clashMux(checkConflicts());
foreach($clashArrays as $clashArray){
if(in_array($rID, $clashArray)){
break;
}
}
$_POST['reqID'] = getIDFromHash($_POST['reqID']);
//Get comma separated string of concerned persons, insert into db
$reqID = getIDFromHash($_POST['reqID']);
$cc = $_POST['cc'];
$ccPersons = CSVToArray($cc);
foreach($ccPersons as $guy){
$query = "INSERT INTO ccPerson(reqNo, email) values(\"{$reqID}\", \"{$guy}\");";
//echo $query;
execute($query) /*or die("ccPersonAddingError")*/;
}
//clashArray now has all elements clashing with the current request, including the current request
//
if($_POST['reqAction']==$b)
{
if($_POST['reason']==$d)
{
$sq="update Requests set appStatus='Rejected', reqRejectReason='None' where reqNo=".$_POST['reqID'].";";
}
else
{
$sq="update Requests set appStatus='Rejected',reqRejectReason ='".$_POST['reason']."' where reqNo=".$_POST['reqID'].";";
}
$req = getRequestByID($rID);
reject($req['creator'], $req['creatorEmail'], $req['room'], $req['reqNo'],$_POST['reason'], getCC($rID));
reject($req['concernedPName'], $req['concernedPEmail'], $req['room'], $req['reqNo'],$_POST['reason']);
}
else if($_POST['reqAction']==$a)
{
$query="SELECT * FROM Requests WHERE reqNo=".$_POST['reqID'].";";
$acceptedEvent=execute($query);
$roomRecords=mysql_fetch_assoc($acceptedEvent);
$instances=weeklyRequestToInstance($roomRecords['eventStartDate'], $roomRecords['eventEndDate'], CSVToArray($roomRecords['eventDays']));
foreach($instances as $instance){
$query="INSERT INTO Instances(reqNo,hash,creator,creatorEmail,creatorPhone,concernedPName,concernedPEmail,concernedPPhone,appStatus,reqGId,reqDate,eventStartDate,eventEndDate,eventStartTime,eventEndTime,eventTitle,eventDesc,eventDays,concernedAdmin,room,reqType) VALUES(
'".$roomRecords['reqNo']."',
'".$roomRecords['hash']."',
'".$roomRecords['creator']."',
'".$roomRecords['creatorEmail']."',
'".$roomRecords['creatorPhone']."',
'".$roomRecords['concernedPName']."',
'".$roomRecords['concernedPEmail']."',
'".$roomRecords['concernedPPhone']."',
'Accepted',
'".$roomRecords['reqGId']."',
'".$roomRecords['reqDate']."',
'".$instance."',
'".$instance."',
'".$roomRecords['eventStartTime']."',
'".$roomRecords['eventEndTime']."',
'".$roomRecords['eventTitle']."',
'".$roomRecords['eventDesc']."',
'".$roomRecords['eventDays']."',
'".$roomRecords['concernedAdmin']."',
'".$roomRecords['room']."',
'".$roomRecords['reqType']."'
);";
execute($query);
}
$sq="update Requests set appStatus='Accepted' where reqNo=".$_POST['reqID'].";";
$clash=requestClash($roomRecords['eventStartDate'], $roomRecords['eventEndDate'],$roomRecords['eventStartTime'], $roomRecords['eventEndTime'],$roomRecords['room']);
while($req=mysql_fetch_assoc($clash)){
//print_r($req);
if($req['reqNo'] != $rID){
//echo $req['reqNo'];
//echo "<HI><br><br><br><br>\n";
$otherQuery = "update Requests set appStatus = 'Rejected', reqRejectReason = 'A request conflicting with your request was accepted.' where reqNo = {$req['reqNo']}";
//echo $otherQuery."\n";
execute($otherQuery);
reject($req['creator'], $req['creatorEmail'], $req['room'], $req['reqNo'], getCC($rID));
reject($req['concernedPName'], $req['concernedPEmail'], $req['room'], $req['reqNo'], getCC($rID));
}
}
$req = getRequestByID($rID);
accept($req['creator'], $req['creatorEmail'], $req['room'], $req['reqNo'], getCC($rID));
accept($req['concernedPName'], $req['concernedPEmail'], $req['room'], $req['reqNo'], getCC($rID));
}
else if($_POST['reqAction']==$c)
{
$sq="update Requests set concernedAdmin = {$_POST['forwardID']} where reqNo = {$_POST['reqID']}";
$req = getRequestByID($rID);
$emails = getEmails($_POST['forwardID']);
//print_r($emails);
foreach($emails as $email){
forward($req['concernedPName'], $email, $req['room'], $req['reqNo'], $req['concernedPEmail'], getCC($rID));
}
}
//echo $sq;
execute($sq);
//echo "<br />";
//cho "HIHIHIII";
//print_r($clashArray);
//echo "HIHIHIII";
echo "<script> window.location.replace('table.php') </script>";
?>