Commit | Line | Data |
---|---|---|
d484e8ee PM |
1 | <?PHP |
2 | ob_start(); | |
3 | include_once('header.php'); | |
4 | $head = ob_get_clean(); | |
c2da7c69 | 5 | $VoterList_table = $_COOKIE['VoterList_table']; |
d484e8ee PM |
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 != ''){ | |
cd980bca PM |
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); | |
d484e8ee | 18 | }else{ |
cd980bca | 19 | // we should NEVER hit this page anymore |
d484e8ee PM |
20 | header('Location: warning_incomplete.php'); |
21 | } | |
c2da7c69 | 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'"; |
d484e8ee PM |
23 | $r = $petition->query($q); |
24 | $d = mysqli_fetch_array($r); | |
25 | if ($d['VTRID'] != ''){ | |
26 | $VTRID = $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']; | |
cd980bca | 34 | slack_general('MATCH: eligible ('.$FIRSTNAME.' '.$LASTNAME.' '.$RESIDENTIALCITY.') ('.$_COOKIE['invite'].')','md-petition'); |
d484e8ee | 35 | }else{ |
cd980bca PM |
36 | slack_general('MISS: eligible ('.$web_first_name.' '.$web_last_name.' '.$PHONE.') ('.$_COOKIE['invite'].')','md-petition'); |
37 | header('Location: warning_not_found.php'); | |
d484e8ee | 38 | } |
1b4ae9ba PM |
39 | |
40 | if (isset($_GET['remove'])){ | |
41 | $id = $_GET['remove']; | |
42 | $q = "update signatures set signature_status = 'removed' where id = '$id'"; | |
43 | $petition->query($q); | |
cd980bca | 44 | slack_general('SQL: eligible ('.$q.') ('.$_COOKIE['invite'].')','md-petition'); |
1b4ae9ba PM |
45 | header('Location: eligible.php'); |
46 | } | |
47 | ||
9855180c PM |
48 | echo $head; |
49 | ||
a71cf996 | 50 | |
32cc64e6 | 51 | $available=''; |
cc0b5cc4 | 52 | $q2 = "SELECT * FROM petitions where admin_status = 'approved'"; |
d484e8ee PM |
53 | $r2 = $petition->query($q2); |
54 | while($d2 = mysqli_fetch_array($r2)){ | |
da47274f | 55 | $checked = ''; |
d484e8ee PM |
56 | $field = $d2['eligibleVoterListField']; |
57 | $pass = $d2['eligibleVoterListEquals']; | |
99009157 | 58 | |
5656e905 | 59 | $my_test = $d[$field]; |
cd980bca | 60 | |
5656e905 | 61 | if($my_test == $pass){ |
2e244f3c | 62 | // good to go |
cd980bca PM |
63 | $checked = ''; |
64 | if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ | |
d77d4772 PM |
65 | $checked = 'checked'; |
66 | }else{ | |
67 | $checked = ''; | |
b4a09a83 | 68 | } |
8e75e3e1 | 69 | $available .= "<div class='row'> |
d7918dee PM |
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> | |
32cc64e6 | 73 | </div>"; |
4fec112a | 74 | |
6b9739e8 PM |
75 | if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ |
76 | $available .= '<script>document.getElementById("form").submit();</script>'; | |
77 | } | |
330a7a16 | 78 | }else{ |
2e244f3c | 79 | // not a eligable voter |
330a7a16 PM |
80 | $checked = ''; |
81 | if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ | |
82 | $checked = 'checked'; | |
83 | }else{ | |
84 | $checked = ''; | |
85 | } | |
8e75e3e1 | 86 | $available .= "<div class='row'> |
d7918dee PM |
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> | |
e2c1b70c | 90 | </div>"; |
64784d88 | 91 | if($d2['eligibleVoterListEnforce'] == 'NO' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){ |
5b555233 | 92 | $available .= '<script>document.getElementById("form").submit();</script>'; |
64784d88 | 93 | }elseif($d2['eligibleVoterListEnforce'] == 'YES' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){ |
8742adfb | 94 | setcookie("invite", ""); // clear invite |
610cf492 | 95 | $error = "$field is not $pass it is $my_test"; |
6cfb9308 | 96 | setcookie("invite_error", $error); // record error |
06d8d5ea | 97 | $available .= '<script>alert("'.$d2[eligibleVoterListWarning].'"); location.reload();</script>'; |
5b555233 | 98 | } |
d484e8ee | 99 | } |
d484e8ee | 100 | } |
e2bffda9 | 101 | ?> |
9fb7e174 | 102 | <script>document.title = "MEPS - Select Petition";</script> |
b4a09a83 | 103 | <form method='POST' action='petition.php' id='form'> |
462019be PM |
104 | <?PHP |
105 | $q = "select * from website_text where id = '7'"; | |
106 | $r = $petition->query($q); | |
107 | $d = mysqli_fetch_array($r); | |
108 | ?> | |
cea0081f PM |
109 | <style> |
110 | input[type=radio]{ | |
111 | transform:scale(2); | |
112 | } | |
113 | </style> | |
309a4e6f | 114 | |
e2c1b70c | 115 | <div class='row'> |
d8dfa11b | 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> |
e2c1b70c | 117 | </div> |
32cc64e6 | 118 | |
aacea61e | 119 | <div class='row'> |
d1ac864b | 120 | <div class='col-sm-3'><h3>Pick One</h3></div> |
cea0081f | 121 | <div class='col-sm-6'><h3>Petition Name <br> Eligible</h3></div> |
d1ac864b | 122 | <div class='col-sm-1'><h3>Locked</h3></div> |
aacea61e PM |
123 | </div> |
124 | ||
e2c1b70c | 125 | <?PHP echo $available;?> |
32cc64e6 | 126 | |
4b7a5d37 | 127 | <div class='row'> |
a13797fd | 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> |
c92c2a28 PM |
129 | </div> |
130 | <div class='row'> | |
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> | |
132 | </div> | |
97ae499d | 133 | |
2b1ae240 | 134 | </form> |
91d0a62a PM |
135 | |
136 | <?PHP include_once('footer.php'); |