admin/user_follow_up.php

   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');