Commit | Line | Data |
---|---|---|
c0aad348 PM |
1 | <?PHP |
2 | include_once('../slack.php'); | |
3 | include_once('security.php'); | |
4 | include_once('header.php'); | |
5 | $list1 = ''; | |
6 | $list2 = ''; | |
7 | $list3 = ''; | |
8 | ||
9 | $petition_id = intval($_COOKIE['petition_id']); | |
10 | ||
11 | $q="SELECT * FROM follow_up where status = 'NEW' and petition_id = '$petition_id'"; | |
12 | $r = $petition->query($q); | |
13 | while($d = mysqli_fetch_array($r)){ | |
14 | $sig = ''; | |
15 | if ($d['name'] != ''){ | |
16 | $q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d[name]' and petition_id = '$petition_id'"; | |
17 | $r3 = $petition->query($q3); | |
18 | $d3 = mysqli_fetch_array($r3); | |
19 | if ($d3['date_time_signed'] != ''){ | |
20 | $sig = "<b>SIGNATURE $d3[date_time_signed]</b>"; | |
21 | } | |
22 | } | |
23 | // no petition_id available... petition (name) invite (id) are | |
24 | $presig=''; | |
25 | $q4="SELECT * FROM presign where email_for_follow_up = '$d[email]' and php_page like '/sign.php%'"; | |
26 | $r4 = $petition->query($q4); | |
27 | $d4 = mysqli_fetch_array($r4); | |
28 | if ($d4['action_on']){ | |
29 | $presig = "<b>PRESIG $d4[action_on]</b>"; | |
30 | } | |
31 | if ($presig != '' || $sig != ''){ | |
32 | $list3 .= "<li>$d[email] $presig $d[name] $sig</li>"; | |
33 | }else{ | |
34 | $list3 .= "<li>$d[date_sent] $d[email] $d[name]</li>"; | |
35 | } | |
36 | } | |
37 | ||
38 | $q="SELECT * FROM follow_up where status <> 'NEW' and petition_id = '$petition_id' order by id DESC"; | |
39 | $r = $petition->query($q); | |
40 | while($d = mysqli_fetch_array($r)){ | |
41 | $sig = ''; | |
42 | if ($d['name'] != ''){ | |
43 | $q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d[name]' and petition_id = '$petition_id'"; | |
44 | $r3 = $petition->query($q3); | |
45 | $d3 = mysqli_fetch_array($r3); | |
46 | if ($d3['date_time_signed'] != ''){ | |
47 | $sig = "<b>SIGNATURE $d3[date_time_signed]</b>"; | |
48 | } | |
49 | } | |
50 | // no petition_id available... petition (name) invite (id) are | |
51 | $presig=''; | |
52 | $q4="SELECT * FROM presign where email_for_follow_up = '$d[email]' and php_page like '/sign.php%'"; | |
53 | $r4 = $petition->query($q4); | |
54 | $d4 = mysqli_fetch_array($r4); | |
55 | if ($d4['action_on']){ | |
56 | $presig = "<b>PRESIG $d4[action_on]</b>"; | |
57 | } | |
58 | if ($presig != '' || $sig != ''){ | |
59 | $list1 .= "<li>$d[email] $presig $d[name] $sig</li>"; | |
60 | }else{ | |
61 | $list2 .= "<li>$d[date_sent] $d[email] $d[name]</li>"; | |
62 | } | |
63 | ||
64 | } | |
65 | ob_start(); | |
66 | echo "<h1>Outbox</h1>"; | |
67 | echo "<ol>"; | |
68 | echo $list3; | |
69 | echo "</ol>"; | |
70 | $buffer = ob_get_clean(); | |
71 | if ($list3 != ''){ | |
72 | echo $buffer; | |
73 | } | |
74 | echo "<h1>Signed</h1>"; | |
75 | echo "<ol>"; | |
76 | echo $list1; | |
77 | echo "</ol>"; | |
78 | echo "<h1>Sent</h1>"; | |
79 | echo "<ol>"; | |
80 | echo $list2; | |
81 | echo "</ol>"; | |
82 | include_once('footer.php'); |