FilesExpand file tree

 master

/

Notification.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

186 lines (166 loc) · 6.65 KB

 master

/

Notification.php

Copy path

Top

File metadata and controls

• Code
• Blame

186 lines (166 loc) · 6.65 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

178

179

180

181

182

183

184

185

186

<?php

include_once './help_functions.php';

class Notification {

/**

* insert new notification to database

* get notification params from post

*/

public static function insertNotification($content) {

// Set date to current hospital location

date_default_timezone_set('Asia/Tel_Aviv'); // Tel Aviv location

$currentTime = new DateTime();

// Get the date from DateTime object

$dateString = date_format($currentTime, 'Y-m-d H:i:s');

$db = new Database();

if(empty($_POST['alert_name'])) {

$q = "SELECT `AUTO_INCREMENT` as id FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='adss' AND TABLE_NAME='notification'";

$result = $db->createQuery($q);

$lastId = $result[0]['id'];

$_POST['alert_name'] = "Alert #".$lastId;

}

$q = "INSERT INTO `adss`.`notification` (`author`, `created_time`, `title`, `content`) VALUES

('{$_SESSION['name']}', '{$dateString}', '{$_POST['alert_name']}', '{$content}');";

$db->createQuery($q);

}

/**

* Update the notification with new contents

*/

public static function editNotification($content, $dateString, $title, $notificationId) {

debug($content);

debug($notificationId);

debug($title);

debug($dateString);

$db = new Database();

$q = "UPDATE `notification` SET `content`='{$content}', `created_time`='{$dateString}', `title`='{$title}' WHERE `id`='{$notificationId}';";

$db->createQuery($q);

}

/**

* delete the out of date constraints & notifications

*/

public static function deleteOldNotifications() {

// Get all the notifications

$results = Notification::getNotifications();

// Iterate all the notifications to check which of them to remove or remain

foreach ($results as $value) {

$notificationId = $value['id'];

// Get the current date time

date_default_timezone_set('Asia/Tel_Aviv');

$currentTime = new DateTime();

// Get the constraints

$parts = explode(" ", $value['content']);

$ids = $parts[0];

$constraints = $parts[1];

$parts = explode("constraints:", $constraints);

$constraints = explode(".", $parts[1]);

$newContent = "";

// Iterate all the constraints in a notification to check which of them to remove or remain

foreach($constraints as $constraint) {

if(!empty($constraint)) {

$constraint = str_replace("for-", " : ", $constraint);

$interval = explode(":", $constraint)[1];

if($interval != " inf") {

$interval = explode("h", $interval)[0];

$interval = ltrim($interval, ' ');

$createdTime = new DateTime($value['created_time']);

$intervalTime = $createdTime->modify("+".$interval." hours");

if($currentTime < $intervalTime) {

// Add to constraint - this is still valid interval

$newContent .= str_replace(" : ", "for-", $constraint).".";

}

} else {

// Interval is infinite so it will not be deleted

$newContent .= str_replace(" : ", "for-", $constraint).".";

}

}

}

if(empty($newContent)) {

// Remove the notification - no constraints remained

Notification::deleteNotification($notificationId);

} else {

// Update the notification

$updatedContent = $ids." constraints:".$newContent;

Notification::updateNotification($updatedContent, $notificationId);

}

}

}

/**

* Update the notification with new content

* @param $content - the new constraints to add

*/

public static function updateNotification($content, $notificationId) {

$db = new Database();

$q = "UPDATE `notification` SET `content`='{$content}' WHERE `id`='{$notificationId}';";

$db->createQuery($q);

}

/**

* get all ids selected in Notification window

* $_POST[check] contains all the ids

* @return string of ids with comma (,) between them (e.g: "5,17,35")

*/

public static function getIds() {

if(!isset($_POST['check']))

return FALSE;

$idsString = "id:";

foreach($_POST['check'] as $key=>$id) {

$idsString .= $id.",";

}

return rtrim($idsString, ",");

}

/**

* get all constraints added in Notification window

* $_POST[input_*] contains all the constraints

* @return string of constraints with dot (.) between them (e.g: "MAP>5for-24h.VAP<14for-48h.")

*/

public static function getConstraints() {

$constraintsString = "constraints:";

$i = 1;

while(isset($_POST['input_'.$i])) {

$constraint = $_POST['input_'.$i];

$const_arr = explode(" ",$constraint);

if(!in_array($const_arr[4], array("24h", "48h", "72h"), true)) { // == "&infin") {

$const_arr[4] = "inf";

}

// constraintsString will look like: MAP>50for-24h.

$constraintsString .= $const_arr[0].$const_arr[1].$const_arr[2]."for-".$const_arr[4].".";

$i++;

}

return $constraintsString;

}

/**

* delete Notification by id

* @param $id - the Notification id

* @return FALSE if something went wrong

*/

public static function deleteNotification($id) {

$db = new Database();

$q = "DELETE FROM notification WHERE id='{$id}'";

$result = $db->createQuery($q);

return $result;

}

/**

* get notification from database

* return false if was not found

* @param array $id - notification id to search for

* @return array $result - found notification

*/

public static function getNotification($id) {

$db = new Database();

$q = "SELECT * FROM notification WHERE id='{$id}'";

$result = $db->createQuery($q);

if (count($result) > 0) {

return $result;

} else {

return FALSE;

}

}

/**

* get all notifications in db

* @return array $result - all notifications

*/

public static function getNotifications() {

$db = new Database();

$q = "SELECT * FROM notification ORDER BY created_time DESC";

$result = $db->createQuery($q);

return $result;

}

}