eligible.php

   1 <?PHP
   2 ob_start();
   3 include_once('header.php');
   4 $head = ob_get_clean();
   5 $web_first_name   = $_COOKIE['web_first_name'];
   6 $web_last_name    = $_COOKIE['web_last_name'];
   7 $web_house_number = $_COOKIE['web_house_number'];
   8 $web_zip_code     = $_COOKIE['web_zip_code'];
   9 if ($web_first_name != '' && $web_last_name != '' && $web_house_number != '' && $web_zip_code != ''){
  10   include_once('header.php');
  11   $web_first_name   = $petition->real_escape_string($web_first_name);
  12   $web_last_name    = $petition->real_escape_string($web_last_name);
  13   $web_house_number = $petition->real_escape_string($web_house_number);
  14   $web_zip_code     = $petition->real_escape_string($web_zip_code);
  15   $DOB              = $petition->real_escape_string($DOB);
  16   $PHONE            = $petition->real_escape_string($PHONE);
  17 }else{
  18   // we should NEVER hit this page anymore
  19   header('Location: warning_incomplete.php');
  20 }
  21 $q = "select * from VoterList where LASTNAME = '$web_last_name' and FIRSTNAME = '$web_first_name' and HOUSE_NUMBER = '$web_house_number' and RESIDENTIALZIP5 = '$web_zip_code'";
  22 $r = $petition->query($q);
  23 $d = mysqli_fetch_array($r);
  24 if ($d['VTRID'] != ''){
  25    $VTRID      = $d['VTRID'];
  26    $FIRSTNAME  = $d['FIRSTNAME'];
  27    $MIDDLENAME = $d['MIDDLENAME'];
  28    $LASTNAME   = $d['LASTNAME'];
  29    $ADDRESS    = $d['ADDRESS'];
  30    $RESIDENTIALCITY   = $d['RESIDENTIALCITY'];
  31    $COUNTY            = $d['COUNTY'];
  32    $RESIDENTIALZIP5   = $d['RESIDENTIALZIP5'];
  33   slack_general('MATCH: eligible ('.$FIRSTNAME.' '.$LASTNAME.' '.$RESIDENTIALCITY.') ('.$_COOKIE['invite'].')','md-petition');
  34 }else{
  35   slack_general('MISS: eligible ('.$web_first_name.' '.$web_last_name.' '.$PHONE.') ('.$_COOKIE['invite'].')','md-petition');
  36   header('Location: warning_not_found.php');
  37 }
  38
  39 if (isset($_GET['remove'])){
  40   $id = $_GET['remove'];
  41   $q = "update signatures set signature_status = 'removed' where id = '$id'";
  42   $petition->query($q);
  43   slack_general('SQL: eligible ('.$q.') ('.$_COOKIE['invite'].')','md-petition');
  44   header('Location: eligible.php');
  45 }
  46
  47 echo $head;
  48
  49
  50 $available='';
  51 $q2 = "SELECT * FROM petitions";
  52 $r2 = $petition->query($q2);
  53 while($d2 = mysqli_fetch_array($r2)){
  54  $checked = '';
  55  $field = $d2['eligibleVoterListField'];
  56  $pass = $d2['eligibleVoterListEquals'];
  57  $q4 = "select * from signatures where VTRID = '$VTRID' and petition_id = '$d2[petition_id]' and signature_status <> 'removed' ";
  58  $r4 = $petition->query($q4);
  59  $d4 = mysqli_fetch_array($r4);
  60   if ($d4['id'] > 0){
  61     slack_general($VTRID.' Already Signed '.$d2[petition_id].' ('.$_COOKIE['invite'].')','md-petition');
  62   }
  63   /*
  64 if ($d4['id'] > 0){
  65   $available .= "<div class='row' style='background-color:lightyellow;'>
  66   <div class='col-sm-3'>Already Signed, <a target='_Blank' href='soft_copy.php?id=$d4[id]'>View</a> or <a href='?remove=$d4[id]'>Remove</a></div>
  67   <div class='col-sm-6'>$d2[petition_name]</div>
  68   <div class='col-sm-3'>$field == $pass</div>
  69     </div>";
  70  }else */
  71
  72   if($d[$field] == $pass){
  73    $checked = '';
  74    if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
  75      $checked = 'checked';
  76    }else{
  77      $checked = '';
  78    }
  79   $available .= "<div class='row'>
  80   <div class='col-sm-3' style='background-color:$d2[web_color];'><input type='radio' id='petition' name='petition' value='$d2[petition_id]' $checked > </div>
  81   <div class='col-sm-6' style='background-color:$d2[web_color];'><h2>$d2[petition_name] <br> $field == $pass</h2></div>
  82   <div class='col-sm-1' style='background-color:$d2[web_color];'><h2>$d2[eligibleVoterListEnforce]</h2></div>
  83     </div>";
  84
  85    if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
  86      $available .= '<script>document.getElementById("form").submit();</script>';
  87    }
  88  }else{
  89    $checked = '';
  90    if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
  91      $checked = 'checked';
  92    }else{
  93      $checked = '';
  94    }
  95   $available .= "<div class='row'>
  96   <div class='col-sm-3' style='background-color:$d2[web_color];'>"; if ($d2['eligibleVoterListEnforce'] == 'NO'){ $available .="<input type='radio' id='petition' name='petition' value='$d2[petition_id]' $checked >"; }else{ $available .= "<h2>Constituents Only</h2>"; } $available .= "</div>
  97   <div class='col-sm-6' style='background-color:$d2[web_color];'><h2>$d2[petition_name] <br> $field != $pass</h2></div>
  98   <div class='col-sm-1' style='background-color:$d2[web_color];'><h2>$d2[eligibleVoterListEnforce]</h2></div>
  99     </div>";
 100    if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
 101      $available .= '<script>document.getElementById("form").submit();</script>';
 102    }
 103  }
 104 }
 105 ?>
 106 <script>document.title = "MEPS - Select Petition";</script>
 107 <form method='POST' action='petition.php' id='form'>
 108  <?PHP
 109  $q = "select * from website_text where id = '7'";
 110  $r = $petition->query($q);
 111  $d = mysqli_fetch_array($r);
 112  ?>
 113   <style>
 114   input[type=radio]{
 115     transform:scale(2);
 116   }
 117   </style>
 118
 119   <div class='row'>
 120     <div class='col-sm-10' style='height:100px; text-align:center;'><h1><?PHP echo $d['text_title'];?></h1><h2><?PHP echo $d['text_block'];?></h2></div>
 121   </div>
 122
 123   <div class='row'>
 124     <div class='col-sm-3'><h3>Pick One</h3></div>
 125     <div class='col-sm-6'><h3>Petition Name <br> Eligible</h3></div>
 126     <div class='col-sm-1'><h3>Locked</h3></div>
 127   </div>
 128
 129   <?PHP echo $available;?>
 130
 131   <div class='row'>
 132     <div class='col-sm-10' style='height:100px; text-align:center;'><button type="submit" class="btn btn-success btn-lg btn-block">Next</button><div>
 133   </div>
 134 <div class='row'>
 135  <div class='col-sm-10' style='text-align:center;'><button type="button" class="btn btn-danger btn-lg btn-block" onclick="window.location.href='reset.php'">Reset / Restart</button></div>
 136 </div>
 137
 138
 139 </form>
 140
 141 <?PHP include_once('footer.php');