-
Notifications
You must be signed in to change notification settings - Fork 0
/
request.php
177 lines (133 loc) · 5.3 KB
/
request.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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
<?php
class DbConnection {
public $host;
public $db;
public $user;
public $pass;
function __construct() {
$this->host = "localhost";
$this->db = "backlog_mgmgt";
$this->user = "root";
$this->pass = "";
}
public function call_db_login() {
$result = $this->find_login_users();
if(count($result) > 0) {
return $result;
} else {
return null;
}
}
public function find_login_users() {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("SELECT id,userName,role,email from users WHERE users.userName = :userName AND users.password = :password");
$stmt->bindParam(':userName', $_POST['userName']);
$stmt->bindParam(':password', $_POST["password"]);
$stmt->execute();
$result = $stmt->fetchAll();
if(count($result) > 0) {
return $result;
}
return null;
$dbh = null;
}
public function call_db_insert_task_from($creatorId) {
$result = $this->find_users_id_by_name($_POST['assignee']);
$assigneeId = $result[0][0];
$this->insert_task($creatorId,$assigneeId);
}
public function find_users_id_by_name($userName) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("SELECT id FROM users WHERE userName = :userName");
$stmt->bindParam(':userName', $userName);
$stmt->execute();
$result = $stmt->fetchAll();
if(count($result) > 0) {
return $result;
}
return null;
$dbh = null;
}
public function insert_task($creatorId, $assigneeId) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("INSERT INTO tasks(title, description, creatorId, assigneeId, priority, dueDate)
VALUES(:title, :description, :creatorId, :assigneeId, :priority, :date)");
$stmt->bindParam(':title', $_POST['title']);
$stmt->bindParam(':description', $_POST['desc']);
$stmt->bindParam(':creatorId', $creatorId);
$stmt->bindParam(':assigneeId', $assigneeId);
$stmt->bindParam(':priority', $_POST['priority']);
$stmt->bindParam(':date', $_POST['date']);
$stmt->execute();
$dbh = null;
}
public function change_user_password($userId) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("UPDATE users SET password = :password WHERE id = :userId");
$stmt->bindParam(':password', $_POST['newPassword']);
$stmt->bindParam(':userId', $userId);
$stmt->execute();
$dbh = null;
}
public function find_all_tasks() {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("SELECT title, description, u.userName, logHours, dueDate, done, priority
FROM tasks JOIN users u ON assigneeID = u.Id
WHERE title LIKE ?
ORDER BY FIELD(priority, 'XL', 'L','M', 'S')");
$stmt->bindValue(1, "%".$_POST['search']."%", PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetchAll();
return $result;
$dbh = null;
}
public function find_user_tasks($userId) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("SELECT title, description, logHours, dueDate, done, priority from tasks WHERE assigneeId = :assigneeId");
$stmt->bindParam(':assigneeId', $userId);
$stmt->execute();
$result = $stmt->fetchAll();
return $result;
$dbh = null;
}
public function find_dashboard_tasks() {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("SELECT id, title, description, logHours, dueDate, done, priority from tasks");
$stmt->execute();
$result = $stmt->fetchAll();
return $result;
$dbh = null;
}
public function find_task_by_name($taskName) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("SELECT description, logHours, dueDate, done, priority from tasks WHERE title = :taskName");
$stmt->bindParam(':taskName', $taskName);
$stmt->execute();
$result = $stmt->fetchAll();
return $result;
$dbh = null;
}
public function log_hours_on_task($taskName, $logHours) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("UPDATE tasks SET logHours = :logHours WHERE title = :taskName");
$stmt->bindParam(':taskName', $taskName);
$stmt->bindParam(':logHours', $logHours);
$stmt->execute();
$dbh = null;
}
public function complete_task($taskName) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("UPDATE tasks SET done = 2 WHERE title = :taskName");
$stmt->bindParam(':taskName', $taskName);
$stmt->execute();
$dbh = null;
}
public function complete_task_by_id($id) {
$dbh = new PDO("mysql:host=$this->host; dbname=$this->db; charset=utf8", $this->user, $this->pass);
$stmt = $dbh->prepare("UPDATE tasks SET done = 2 WHERE id = :id");
$stmt->bindParam(':id', $id);
$stmt->execute();
$dbh = null;
}
}
?>