/
registerToEvent.php
79 lines (69 loc) · 2.86 KB
/
registerToEvent.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
<?php
require_once("praveenlib.php");
$keys=array("userId","eventId","userName");
$respjson= array(
"status"=>"unprocessed",
"errorCode"=>1
);
if(checkPOST($keys)){
$conn=connectSQL();
if($conn){
$eventId=safeString($conn,$_POST['eventId']);
$userId=safeString($conn,$_POST['userId']);
$userName=safeString($conn,$_POST['userName']);
$sql="call takeTicket({$eventId});";
if($result=$conn->query($sql)){
$row=$result->fetch_array();
if($row[0]==1){
$conn->close();
$conn=connectSQL();
$sql="insert into eventregistration (userId,eventId,userName) VALUES ({$userId},{$eventId},'{$userName}')";
if($result=$conn->query($sql)){
$sql="select userId,eventName from events where eventId=$eventId";
if($result=$conn->query($sql)) {
if($result->num_rows>0) {
require_once('applib.php');
$ownerId=$result->fetch_array()['userId'];
$eventName=$result->fetch_array()['eventName'];
$ids=array($ownerId);
$respjson['tokenJSON']=getOwnerTokens($ids);
$tokens =$respjson['tokenJSON']['tokens'];
$title="Event Registration";
$message="$userName Registered for $eventName";
$retjson=sendPushNotification($tokens,$title,$message);
$respjson["notificationJSON"]=$retjson;
$respjson["status"] = "Success";
$respjson["errorCode"] = 0;
}else{
$respjson["status"] = "Event Owner Id not found";
$respjson["errorCode"] = 6;
}
}else{
$respjson["status"]="SQL error";
$respjson["SqlError"]=$conn->error;
$respjson["errorCode"]=4;
}
}else{
$respjson["status"]="SQL error";
$respjson["SqlError"]=$conn->error;
$respjson["errorCode"]=4;
}
}else{
$respjson["status"]="Ticket not avalilable";
$respjson["errorCode"]=6;
}
}else{
$respjson["status"]="SQL call error ";
$respjson["SqlError"]=$conn->error;
$respjson["errorCode"]=4;
}
}else{
$respjson["status"]="SQL Connection error";
$respjson["SqlError"]=$conn->error;
$respjson["errorCode"]=3;
}
}else{
$respjson["status"]="insufficient Data";
$respjson["errorCode"]=2;
}
echo json_encode($respjson);