DART/alerts.inc at master · dartproject/DART · GitHub

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
<?php

global $db;

emptyAlertTable();

/************** Collect Area Levels to Progress ***************/

$alertProgress = alertAreaLevels();

echo ("<br>Area Levels Alerts: " . count($alertProgress) );

foreach ($alertProgress as $alert) {
  $id = $alert->studentid;
  $subject = $alert->subject;
  $level = $alert->level;
  $progress = $alert->progress;
  $userid = $alert->userid;
  $uname = $alert->uname;
  $uemail = $alert->uemail;
  $sname = $alert->lname . ", " . $alert->fname;
  $note = "      $sname ($id) $subject.$level = $progress";

  $alert1[$userid]['name'] = $uname;
  $alert1[$userid]['uemail'] = $uemail;
  $alert1[$userid]['note1'] .= "$note\n";

  $sql = "insert alerts
                SET type = 'Level Progress',
                    studentid = '$id',
                    subject = '$sbject',
                    level = '$level',
                    userid = '$userid',
                    username = '$uname',
                    useremail = '$uemail',
                    note = '$note' ";

   debugPrint ("<br>$sql");

   $db->get_results($sql);
//   return($db->insert_id )
}

/************** Collect Toggle Not Changed ***************/

$tm = time();

$alertToggle = alertToggles($tm);
echo ("<br>Toggle Not Changing Alerts: " . count($alertToggle) );
foreach ($alertToggle as $alert) {
  $id = $alert->studentid;
  $subject = $alert->subject;
  $level = $alert->level;
  $progress = $alert->progress;
  $userid = $alert->userid;
  $uname = $alert->uname;
  $uemail = $alert->uemail;
  $sname = $alert->lname . ", " . $alert->fname;
  $ch_name = $alert->change_username;
  $ch_time = date($dateSettings, $alert->change_timestamp);
  $note = "      $sname ($id) $subject.$level = $progress : Last Change ($ch_name [$ch_time])";

  $alert1[$userid]['name'] = $uname;
  $alert1[$userid]['uemail'] = $uemail;
  $alert1[$userid]['note2'] .= "$note\n";


  $sql = "insert alerts
                SET type = 'Toggle Change',
                    studentid = '$id',
                    subject = '$sbject',
                    level = '$level',
                    userid = '$userid',
                    username = '$uname',
                    useremail = '$uemail',
                    note = '$sname ($id) $subject.$level = $progress : Last Change ($ch_name [$ch_time])' ";

   debugPrint ("<br>$sql");

   $db->get_results($sql);
//   return($db->insert_id )
}

/*************** Send Out Toggle Email **********************/

echo ("<br><br>");

foreach ($alert1 as $alert) {
  $name = $alert['name'];
  $email = $alert['uemail'];
  $note1 = $alert['note1'];
  $note2 = $alert['note2'];

  $mailmessage = "Dear $name\n
  Students that need to be progressed:\n$note1\n
  Students that have not been toggled in a certain time frame:\n$note2\nSincerely,\nDART ALERT SYSTEM";

  $header = "To: $name <$uemail>\nFrom: automated@bssd.org\nSubject: Current Warnings\n\n";


 echo ( "<hr>" . str_replace(" ", " &nbsp; ", str_replace("\n", "<br>\n", htmlspecialchars($header. $mailmessage))));
}

?>