Repository navigation
Expand file tree
/
Copy pathsendTicket.php
More file actions
91 lines (50 loc) · 2.49 KB
/
Copy pathsendTicket.php
File metadata and controls
91 lines (50 loc) · 2.49 KB
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
<?php
include 'con_vars.php';
$connect = mysqli_connect($host,$user,$pwd,$db);
$sql = mysqli_prepare($connect, "SELECT ID FROM test_logged_users WHERE token=?");
mysqli_stmt_bind_param($sql, "s", $_POST['user_id']);
mysqli_stmt_execute($sql);
mysqli_stmt_bind_result($sql, $ID);
mysqli_stmt_fetch($sql);
mysqli_stmt_close($sql);
$sql = mysqli_prepare($connect, "SELECT ID FROM test_users_info WHERE am=?");
mysqli_stmt_bind_param($sql, "s", $_POST['am']);
mysqli_stmt_execute($sql);
mysqli_stmt_bind_result($sql, $ID2);
mysqli_stmt_fetch($sql);
mysqli_stmt_close($sql);
$sql = mysqli_prepare($connect, "SELECT BREAKFAST,LUNCH,DINNER FROM owner_coupon WHERE ACADEMIC_ID=?");
mysqli_stmt_bind_param($sql, "s", $ID);
mysqli_stmt_execute($sql);
mysqli_stmt_bind_result($sql, $BREAKFAST,$LUNCH,$DINNER);
mysqli_stmt_fetch($sql);
mysqli_stmt_close($sql);
mysqli_autocommit($connect, FALSE);
if($_POST['ticket_type'] == "b" && $BREAKFAST>0){
mysqli_query($connect, "UPDATE owner_coupon SET BREAKFAST=BREAKFAST+1 WHERE ACADEMIC_ID=".$ID2);
mysqli_query($connect, "UPDATE owner_coupon SET BREAKFAST=BREAKFAST-1 WHERE ACADEMIC_ID=".$ID);
mysqli_query($connect, "INSERT INTO send_coupon (DATE, SENDER_ID, RECEIVER_ID, BREAKFAST, LUNCH,DINNER) VALUES (CURRENT_TIMESTAMP(),".$ID.",".$ID2.",1,0,0)");
}elseif($_POST['ticket_type'] == "l" && $LUNCH>0){
mysqli_query($connect, "UPDATE owner_coupon SET LUNCH=LUNCH+1 WHERE ACADEMIC_ID=".$ID2);
mysqli_query($connect, "UPDATE owner_coupon SET LUNCH=LUNCH-1 WHERE ACADEMIC_ID=".$ID);
mysqli_query($connect, "INSERT INTO send_coupon (DATE, SENDER_ID, RECEIVER_ID, BREAKFAST, LUNCH,DINNER) VALUES (CURRENT_TIMESTAMP(),".$ID.",".$ID2.",0,1,0)");
}elseif($_POST['ticket_type'] == "d" && $DINNER>0){
mysqli_query($connect, "UPDATE owner_coupon SET DINNER=DINNER+1 WHERE ACADEMIC_ID=".$ID2);
mysqli_query($connect, "UPDATE owner_coupon SET DINNER=DINNER-1 WHERE ACADEMIC_ID=".$ID);
mysqli_query($connect, "INSERT INTO send_coupon (DATE, SENDER_ID, RECEIVER_ID, BREAKFAST, LUNCH,DINNER) VALUES (CURRENT_TIMESTAMP(),".$ID.",".$ID2.",0,0,1)");
}else{
echo "Αποτυχία!";
mysqli_autocommit($connect, TRUE);
mysqli_close($connect);
exit;
}
if (!mysqli_commit($connect)) {
echo "Αποτυχία!";
mysqli_autocommit($connect, TRUE);
mysqli_close($connect);
exit;
}
mysqli_autocommit($connect, TRUE);
mysqli_close($connect);
echo "Επιτυχία!";
?>