X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/01f4ba3bafedfc9657f8658f7ff9e3e4d6f72ccf..4108c6129a33144d77835efc3c258787dde0a1a7:/eligible.php
diff --git a/eligible.php b/eligible.php
index 80647b7..7ef3bf0 100644
--- a/eligible.php
+++ b/eligible.php
@@ -48,28 +48,17 @@ 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'];
- $q4 = "select * from signatures where VTRID = '$VTRID' and petition_id = '$d2[petition_id]' and signature_status <> 'removed' ";
- $r4 = $petition->query($q4);
- $d4 = mysqli_fetch_array($r4);
- if ($d4['id'] > 0){
- slack_general($VTRID.' Already Signed '.$d2[petition_id].' ('.$_COOKIE['invite'].')','md-petition');
- }
- /*
-if ($d4['id'] > 0){
- $available .= "
-
-
$d2[petition_name]
-
$field == $pass
-
";
- }else */
+
+$my_test = $d[$field];
- if($d[$field] == $pass){
+ if($my_test == $pass){
+ // good to go
$checked = '';
if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
$checked = 'checked';
@@ -77,15 +66,16 @@ if ($d4['id'] > 0){
$checked = '';
}
$available .= "
-
-
$d2[petition_name]
$field == $pass
-
$d2[eligibleVoterListEnforce]
+
→←
+
$d2[petition_name]
$field == $pass
+
$d2[eligibleVoterListEnforce]
";
if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
$available .= '';
}
}else{
+ // not a eligable voter
$checked = '';
if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
$checked = 'checked';
@@ -93,12 +83,17 @@ if ($d4['id'] > 0){
$checked = '';
}
$available .= "
-
"; if ($d2['eligibleVoterListEnforce'] == 'NO'){ $available .=""; }else{ $available .= "
Constituents Only
"; } $available .= "
-
$d2[petition_name]
$field != $pass
-
$d2[eligibleVoterListEnforce]
+
"; if ($d2['eligibleVoterListEnforce'] == 'NO'){ $available .="→←"; }else{ $available .= "
Constituents Only
"; } $available .= "
+
$d2[petition_name]
$field != $pass ($my_test)
+
$d2[eligibleVoterListEnforce]
";
- if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+ if($d2['eligibleVoterListEnforce'] == 'NO' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
$available .= '';
+ }elseif($d2['eligibleVoterListEnforce'] == 'YES' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
+ setcookie("invite", ""); // clear invite
+ $error = "$field is not $pass it is $my_test";
+ setcookie("invite_error", $error); // record error
+ $available .= '';
}
}
}
@@ -117,7 +112,7 @@ if ($d4['id'] > 0){
@@ -129,10 +124,11 @@ if ($d4['id'] > 0){
-
-
-
-
+
+
+