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   // ok to check for records
  11 }else{
  12   header('Location: warning_incomplete.php');
  13 }
  14 $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'";
  15 $r = $petition->query($q);
  16 $d = mysqli_fetch_array($r);
  17 if ($d['VTRID'] != ''){
  18    $VTRID      = $d['VTRID'];
  19    $FIRSTNAME  = $d['FIRSTNAME'];
  20    $MIDDLENAME = $d['MIDDLENAME'];
  21    $LASTNAME   = $d['LASTNAME'];
  22    $ADDRESS    = $d['ADDRESS'];
  23    $RESIDENTIALCITY   = $d['RESIDENTIALCITY'];
  24    $COUNTY            = $d['COUNTY'];
  25    $RESIDENTIALZIP5   = $d['RESIDENTIALZIP5'];
  26 }else{
  27    header('Location: warning_not_found.php');
  28 }
  29 echo $head;
  30
  31
  32
  33
  34 $available='';
  35 $q2 = "SELECT * FROM petitions";
  36 $r2 = $petition->query($q2);
  37 while($d2 = mysqli_fetch_array($r2)){
  38  $field = $d2['eligibleVoterListField'];
  39  $pass = $d2['eligibleVoterListEquals'];
  40  $q4 = "select * from signatures where VTRID = '$VTRID' and petition_id = '$d2[petition_id]' ";
  41  $r4 = $petition->query($q4);
  42  $d4 = mysqli_fetch_array($r4);
  43  if ($d4['id'] > 0){
  44   $available .= "<div class='row'>
  45   <div class='col-sm-2'><a target='_Blank' href='soft_copy.php?id=$d4[id]'>Already Signed - View</a></div>
  46   <div class='col-sm-6'><del>$d2[petition_name]  ($d2[web_short_name])</del></div>
  47   <div class='col-sm-4'>$field == $pass</div>
  48     </div>";
  49  }elseif($d[$field] == $pass){
  50    if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
  51      $checked = 'checked';
  52    }else{
  53      $checked = '';
  54    }
  55   $available .= "<div class='row'>
  56   <div class='col-sm-2'><input type='radio' id='petition' name='petition' value='$d2[petition_id]' $checked> </div>
  57   <div class='col-sm-6'>$d2[petition_name] ($d2[web_short_name])</div>
  58   <div class='col-sm-4'>$field == $pass</div>
  59     </div>";
  60    if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
  61      $available .= '<script>document.getElementById("form").submit();</script>';
  62    }
  63  }else{
  64    if($_COOKIE['invite'] != '' && $_COOKIE['invite'] == $d2['web_short_name']){
  65      //$available .= '<script>document.getElementById("form").submit();</script>';
  66      // warn and allow access ??
  67    }
  68   $available .= "<div class='row'>
  69   <div class='col-sm-2'><input type='radio' id='petition' name='petition' value='$d2[petition_id]' > </div>
  70   <div class='col-sm-6'><del>$d2[petition_name]  ($d2[web_short_name])</del></div>
  71   <div class='col-sm-4'>$field != $pass</div>
  72     </div>";
  73  }
  74 }
  75 ?>
  76 <form method='POST' action='petition.php' id='form'>
  77
  78   <div class='row'>
  79     <div class='col-sm-12' style='height:100px; text-align:center;'><h2>Active Petitions and Eligiblity Requirements to Sign. <?PHP echo $_COOKIE['invite'];?></h2></div>
  80   </div>
  81
  82   <div class='row'>
  83     <div class='col-sm-2'><h3>Pick One</h3></div>
  84     <div class='col-sm-6'><h3>Petition Name</h3></div>
  85     <div class='col-sm-4'><h3>Requirements</h3></div>
  86   </div>
  87
  88   <?PHP echo $available;?>
  89
  90   <div class='row'>
  91     <div class='col-sm-12' style='height:100px; text-align:center;'><button type="submit" class="btn btn-success">Next</button><div>
  92   </div>
  93
  94 </form>
  95
  96 <?PHP include_once('footer.php');