3 include_once('header.php');
4 $head = ob_get_clean();
5 $VoterList_table = $_COOKIE['VoterList_table'];
6 $web_first_name = $_COOKIE['web_first_name'];
7 $web_last_name = $_COOKIE['web_last_name'];
8 $web_house_number = $_COOKIE['web_house_number'];
9 $web_zip_code = $_COOKIE['web_zip_code'];
10 if ($web_first_name != '' && $web_last_name != '' && $web_house_number != '' && $web_zip_code != ''){
11 include_once('header.php');
12 $web_first_name = $petition->real_escape_string($web_first_name);
13 $web_last_name = $petition->real_escape_string($web_last_name);
14 $web_house_number = $petition->real_escape_string($web_house_number);
15 $web_zip_code = $petition->real_escape_string($web_zip_code);
16 $DOB = $petition->real_escape_string($DOB);
17 $PHONE = $petition->real_escape_string($PHONE);
19 // we should NEVER hit this page anymore
20 header('Location: warning_incomplete.php');
22 $q = "select * from $VoterList_table where LASTNAME = '$web_last_name' and FIRSTNAME = '$web_first_name' and HOUSE_NUMBER = '$web_house_number' and RESIDENTIALZIP5 = '$web_zip_code'";
23 $r = $petition->query($q);
24 $d = mysqli_fetch_array($r);
25 if ($d['VTRID'] != ''){
27 $FIRSTNAME = $d['FIRSTNAME'];
28 $MIDDLENAME = $d['MIDDLENAME'];
29 $LASTNAME = $d['LASTNAME'];
30 $ADDRESS = $d['ADDRESS'];
31 $RESIDENTIALCITY = $d['RESIDENTIALCITY'];
32 $COUNTY = $d['COUNTY'];
33 $RESIDENTIALZIP5 = $d['RESIDENTIALZIP5'];
34 slack_general('MATCH: eligible ('.$FIRSTNAME.' '.$LASTNAME.' '.$RESIDENTIALCITY.') ('.$_COOKIE['invite'].')','md-petition');
36 slack_general('MISS: eligible ('.$web_first_name.' '.$web_last_name.' '.$PHONE.') ('.$_COOKIE['invite'].')','md-petition');
37 header('Location: warning_not_found.php');
40 if (isset($_GET['remove'])){
41 $id = $_GET['remove'];
42 $q = "update signatures set signature_status = 'removed' where id = '$id'";
44 slack_general('SQL: eligible ('.$q.') ('.$_COOKIE['invite'].')','md-petition');
45 header('Location: eligible.php');
52 $q2 = "SELECT * FROM petitions where admin_status = 'approved'";
53 $r2 = $petition->query($q2);
54 while($d2 = mysqli_fetch_array($r2)){
56 $field = $d2['eligibleVoterListField'];
57 $pass = $d2['eligibleVoterListEquals'];
59 $my_test = $d[$field];
61 if($my_test == $pass){
64 if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
69 $available .= "<div class='row'>
70 <div class='col-sm-3' style='color: $d2[web_color_text]; background-color:$d2[web_color];'>→<input onclick='document.getElementById(\"form\").submit();' type='radio' id='petition' name='petition' value='$d2[petition_id]' $checked >←</div>
71 <div class='col-sm-6' style='color: $d2[web_color_text]; background-color:$d2[web_color];'><h3>$d2[petition_name] <br> $field == $pass</h3></div>
72 <div class='col-sm-1' style='color: $d2[web_color_text]; background-color:$d2[web_color];'><h3>$d2[eligibleVoterListEnforce]</h3></div>
75 if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
76 $available .= '<script>document.getElementById("form").submit();</script>';
79 // not a eligable voter
81 if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
86 $available .= "<div class='row'>
87 <div class='col-sm-3' style='color: $d2[web_color_text]; background-color:$d2[web_color];'>"; if ($d2['eligibleVoterListEnforce'] == 'NO'){ $available .="→<input onclick='document.getElementById(\"form\").submit();' type='radio' id='petition' name='petition' value='$d2[petition_id]' $checked >←"; }else{ $available .= "<h3>Constituents Only</h3>"; } $available .= "</div>
88 <div class='col-sm-6' style='color: $d2[web_color_text]; background-color:$d2[web_color];'><h3>$d2[petition_name] <br> $field != $pass ($my_test)</h3></div>
89 <div class='col-sm-1' style='color: $d2[web_color_text]; background-color:$d2[web_color];'><h3>$d2[eligibleVoterListEnforce]</h3></div>
91 if($d2['eligibleVoterListEnforce'] == 'NO' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
92 $available .= '<script>document.getElementById("form").submit();</script>';
93 }elseif($d2['eligibleVoterListEnforce'] == 'YES' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
94 setcookie("invite", ""); // clear invite
95 $error = "$field is not $pass it is $my_test";
96 setcookie("invite_error", $error); // record error
97 $available .= '<script>alert("'.$d2[eligibleVoterListWarning
].'"); location.reload();</script>';
102 <script
>document
.title
= "MEPS - Select Petition";</script
>
103 <form method
='POST' action
='petition.php' id
='form'>
105 $q = "select * from website_text where id = '7'";
106 $r = $petition->query($q);
107 $d = mysqli_fetch_array($r);
116 <div
class='col-sm-10' style
='height:100px; text-align:center;'><h1
><?PHP
echo $d['text_title'];?
></h1
><h3
><?PHP
echo $d['text_block'];?
></h3
></div
>
120 <div
class='col-sm-3'><h3
>Pick One
</h3
></div
>
121 <div
class='col-sm-6'><h3
>Petition Name
<br
> Eligible
</h3
></div
>
122 <div
class='col-sm-1'><h3
>Locked
</h3
></div
>
125 <?PHP
echo $available;?
>
128 <div
class='col-sm-10'><button type
="submit" class="btn btn-success btn-lg btn-block"><img
class='click_me' src
="files/click_here.gif">Next
</button
></div
>
131 <div
class='col-sm-10'><button type
="button" class="btn btn-danger btn-lg btn-block" onclick
="window.location.href='reset.php'">Reset
/ Restart
</button
></div
>
136 <?PHP
include_once('footer.php');