X-Git-Url: https://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/2b1ae240642778bdea60c8a841f1231b6ee29271..b697498f5308dc64bc86f070f76a342cc2f4f058:/eligible.php

diff --git a/eligible.php b/eligible.php
index b663952..7510d57 100644
--- a/eligible.php
+++ b/eligible.php
@@ -7,8 +7,15 @@ $web_last_name    = $_COOKIE['web_last_name'];
 $web_house_number = $_COOKIE['web_house_number'];
 $web_zip_code     = $_COOKIE['web_zip_code'];
 if ($web_first_name != '' && $web_last_name != '' && $web_house_number != '' && $web_zip_code != ''){
-  // ok to check for records
+  include_once('header.php'); 
+  $web_first_name   = $petition->real_escape_string($web_first_name);
+  $web_last_name    = $petition->real_escape_string($web_last_name);
+  $web_house_number = $petition->real_escape_string($web_house_number);
+  $web_zip_code     = $petition->real_escape_string($web_zip_code);
+  $DOB              = $petition->real_escape_string($DOB);
+  $PHONE            = $petition->real_escape_string($PHONE);
 }else{
+  // we should NEVER hit this page anymore
   header('Location: warning_incomplete.php');
 }
 $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'";
@@ -23,49 +30,103 @@ if ($d['VTRID'] != ''){
    $RESIDENTIALCITY   = $d['RESIDENTIALCITY'];
    $COUNTY            = $d['COUNTY'];
    $RESIDENTIALZIP5   = $d['RESIDENTIALZIP5'];
+  slack_general('MATCH: eligible ('.$FIRSTNAME.' '.$LASTNAME.' '.$RESIDENTIALCITY.') ('.$_COOKIE['invite'].')','md-petition');
 }else{
-   header('Location: warning_not_found.php');
+  slack_general('MISS: eligible ('.$web_first_name.' '.$web_last_name.' '.$PHONE.') ('.$_COOKIE['invite'].')','md-petition');
+  header('Location: warning_not_found.php');
 }
+
+if (isset($_GET['remove'])){
+  $id = $_GET['remove'];
+  $q = "update signatures set signature_status = 'removed' where id = '$id'";
+  $petition->query($q);
+  slack_general('SQL: eligible ('.$q.') ('.$_COOKIE['invite'].')','md-petition');
+  header('Location: eligible.php');
+}
+
 echo $head;
 
+
 $available='';
-$q2 = "SELECT * FROM petitions";
+$q2 = "SELECT * FROM petitions where admin_status = 'approved'";
 $r2 = $petition->query($q2);
 while($d2 = mysqli_fetch_array($r2)){
+ $checked = '';
  $field = $d2['eligibleVoterListField'];
  $pass = $d2['eligibleVoterListEquals'];
- if ($d[$field] == $pass){
+ 
+
+  
+  if($d[$field] == $pass){
+    // good to go
+   $checked = ''; 
+   if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+     $checked = 'checked';
+   }else{
+     $checked = '';
+   }
   $available .= "<div class='row'>
-  <div class='col-sm-2'><input type='radio' id='petition' name='petition' value='$d2[petition_id]'> </div>
-  <div class='col-sm-6'>$d2[petition_name]</div>
-  <div class='col-sm-4'>$field == $pass</div>
+  <div class='col-sm-3' style='background-color:$d2[web_color];'><input type='radio' id='petition' name='petition' value='$d2[petition_id]' $checked > </div>
+  <div class='col-sm-6' style='background-color:$d2[web_color];'><h2>$d2[petition_name] <br> $field == $pass</h2></div>
+  <div class='col-sm-1' style='background-color:$d2[web_color];'><h2>$d2[eligibleVoterListEnforce]</h2></div>
     </div>";
+  
+   if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+     $available .= '<script>document.getElementById("form").submit();</script>';
+   }
  }else{
+    // not a eligable voter
+   $checked = '';
+   if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+     $checked = 'checked';
+   }else{
+     $checked = '';
+   }
+    $mytest = $d[$field];
   $available .= "<div class='row'>
-  <div class='col-sm-2'> </div>
-  <div class='col-sm-6'><del>$d2[petition_name]</del></div>
-  <div class='col-sm-4'>$field != $pass</div>
+  <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>
+  <div class='col-sm-6' style='background-color:$d2[web_color];'><h2>$d2[petition_name] <br> $field != $pass ($mytest)</h2></div>
+  <div class='col-sm-1' style='background-color:$d2[web_color];'><h2>$d2[eligibleVoterListEnforce]</h2></div>
     </div>"; 
+   if($d2['eligibleVoterListEnforce'] == 'NO' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
+     $available .= '<script>document.getElementById("form").submit();</script>';
+   }elseif($d2['eligibleVoterListEnforce'] == 'YES' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
+     setcookie("invite", ""); // clear invite
+     $available .= '<script>alert("'.$d2[eligibleVoterListWarning].'");</script>';
+   }
  }
 }
 ?>
-<form method='POST' action='petition.php'>
+<script>document.title = "MEPS - Select Petition";</script>
+<form method='POST' action='petition.php' id='form'>
+ <?PHP
+ $q = "select * from website_text where id = '7'";
+ $r = $petition->query($q);
+ $d = mysqli_fetch_array($r);
+ ?>
+  <style>
+  input[type=radio]{
+    transform:scale(2);
+  }
+  </style>
   
   <div class='row'>
-    <div class='col-sm-12' style='height:100px; text-align:center;'><h2>Active Petitions and Eligiblity Requirements to Sign.</h2></div>
+    <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>
   </div>
 
   <div class='row'>
-    <div class='col-sm-2'><h3>Pick One</h3></div>
-    <div class='col-sm-6'><h3>Petition Name</h3></div>
-    <div class='col-sm-4'><h3>Requirements</h3></div>
+    <div class='col-sm-3'><h3>Pick One</h3></div>
+    <div class='col-sm-6'><h3>Petition Name <br> Eligible</h3></div>
+    <div class='col-sm-1'><h3>Locked</h3></div>
   </div>
 
   <?PHP echo $available;?>
 
   <div class='row'>
-    <div class='col-sm-12' style='height:100px; text-align:center;'><button type="submit" class="btn btn-success">Next</button><div>
-  </div>
+    <div class='col-sm-5'><button type="submit" class="btn btn-success btn-lg btn-block">Next</button></div>
+    <div class='col-sm-5'><button type="button" class="btn btn-danger btn-lg btn-block" onclick="window.location.href='reset.php'">Reset / Restart</button></div>
+  </div>     
+     
       
 </form>