2 include_once('../slack.php');
3 include_once('security.php');
4 if ($_COOKIE['level'] == 'user'){
5 slack_general('ADMIN: Redirect User Home ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
6 header('Location: user_home.php');
8 if ($_COOKIE['level'] == 'manager'){
9 slack_general('ADMIN: Redirect Manager Home ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
10 header('Location: manager_home.php');
12 include_once('header.php');
17 $q="SELECT * FROM follow_up where status = 'NEW'";
18 $r = $petition->query($q);
19 while($d = mysqli_fetch_array($r)){
21 if ($d['name'] != ''){
22 $q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d[name]'";
23 $r3 = $petition->query($q3);
24 $d3 = mysqli_fetch_array($r3);
25 if ($d3['date_time_signed'] != ''){
26 $sig = "<b>SIGNATURE $d3[date_time_signed]</b>";
30 $q4="SELECT * FROM presign where email_for_follow_up = '$d[email]' and php_page like '/sign.php%'";
31 $r4 = $petition->query($q4);
32 $d4 = mysqli_fetch_array($r4);
33 if ($d4['action_on']){
34 $presig = "<b>PRESIG $d4[action_on]</b>";
36 if ($presig != '' ||
$sig != ''){
37 $list3 .= "<li>$d[email] $presig $d[name] $sig</li>";
39 $list3 .= "<li>$d[date_sent] $d[email] $d[name]</li>";
43 $q="SELECT * FROM follow_up where status <> 'NEW' order by id DESC";
44 $r = $petition->query($q);
45 while($d = mysqli_fetch_array($r)){
47 if ($d['name'] != ''){
48 $q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d[name]'";
49 $r3 = $petition->query($q3);
50 $d3 = mysqli_fetch_array($r3);
51 if ($d3['date_time_signed'] != ''){
52 $sig = "<b>SIGNATURE $d3[date_time_signed]</b>";
56 $q4="SELECT * FROM presign where email_for_follow_up = '$d[email]' and php_page like '/sign.php%'";
57 $r4 = $petition->query($q4);
58 $d4 = mysqli_fetch_array($r4);
59 if ($d4['action_on']){
60 $presig = "<b>PRESIG $d4[action_on]</b>";
62 if ($presig != '' ||
$sig != ''){
63 $list1 .= "<li>$d[email] $presig $d[name] $sig</li>";
65 $list2 .= "<li>$d[date_sent] $d[email] $d[name]</li>";
70 echo "<h1>Outbox</h1>";
74 $buffer = ob_get_clean();
78 echo "<h1>Signed</h1>";
86 include_once('footer.php');