X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/bb77cf2d534baf932de39111176ccc2cd882a569..fdc779f2ca4d2c7ca568b839739efd2eeb870d0c:/is_the_information_correct.php
diff --git a/is_the_information_correct.php b/is_the_information_correct.php
dissimilarity index 73%
index fe5483e..9b95e92 100644
--- a/is_the_information_correct.php
+++ b/is_the_information_correct.php
@@ -1,49 +1,156 @@
-query($q);
-$d = mysqli_fetch_array($r);
-if ($d['VTRID'] != ''){
- $VTRID = $d['VTRID'];
-}else{
- //header('Location: warning_not_found.php');
-}
-?>
-
-
Is this information correct? ()
-
- First Name
-
- Middle Name
Edward
-
- Last Name
Smith
-
- Full Addresss
1232 Roadly Ct.
-
- City
Baltimore
- County
Baltimore City
- Zip
21204
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-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{
+ header('Location: warning_incomplete.php');
+}
+
+// V2 API - Remote
+include_once('api/maryland_voter.php');
+$month = date('m',strtotime($DOB));
+$day = date('d',strtotime($DOB));
+$year = date('Y',strtotime($DOB));
+$error = 'Based on what you entered, we were unable to find any information.';
+$error2 = 'MISSING NAME';
+$error3 = 'My Voter Registration Record';
+$error4 = 'Your search cannot be processed at this time';
+$sbe_response = md_voter_lookup($web_first_name,$web_last_name,$month,$day,$year,$web_zip_code,'','');
+$pos = strpos($sbe_response, $error4);
+if ($pos !== false) {
+ slack_general_admin("Voter API v2 Block: $web_first_name,$web_last_name,$month,$day,$year,$web_zip_code $error4",'md-petition-api');
+}else{
+ $pos = strpos($sbe_response, $error);
+ if ($pos !== false) {
+ slack_general_admin("Voter API v2 Fail: $web_first_name,$web_last_name,$month,$day,$year,$web_zip_code $error",'md-petition-api');
+ }
+ $pos = strpos($sbe_response, $error2);
+ if ($pos !== false) {
+ slack_general_admin("Voter API v2 Fail: $web_first_name,$web_last_name,$month,$day,$year,$web_zip_code $error2",'md-petition-api');
+ }
+ $pos = strpos($sbe_response, $error3);
+ if ($pos !== false) {
+ slack_general_admin("Voter API v2 Success: $web_first_name,$web_last_name,$month,$day,$year,$web_zip_code $error3",'md-petition-api');
+ }
+}
+
+// v3 update to VoterList
+$q = "select * from VoterList2 where LASTNAME = '$web_last_name' and FIRSTNAME = '$web_first_name' and HOUSE_NUMBER = '$web_house_number' and RESIDENTIALZIP5 = '$web_zip_code'";
+$r = $petition->query($q);
+$d = mysqli_fetch_array($r);
+if ($d['VTRID'] != ''){
+ slack_general_admin("VoterList2 Search Found",'md-petition-api');
+ $VoterList_table = 'VoterList2';
+}else{
+ $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'";
+ $r = $petition->query($q);
+ $d = mysqli_fetch_array($r);
+ if ($d['VTRID'] != ''){
+ slack_general_admin("VoterList Search Found",'md-petition-api');
+ $VoterList_table = 'VoterList';
+ }else{
+ slack_general_admin("VoterList and VoterList2 Search Not Found",'md-petition-api');
+ //slack_general('MISS: Is the information correct ('.$web_first_name.' '.$web_last_name.' '.$PHONE.') ('.$_COOKIE['invite'].')','md-petition');
+ setcookie("signature_status", 'notfound');
+ header('Location: warning_not_found.php');
+ die();
+ }
+}
+setcookie("VoterList_table", $VoterList_table);
+$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'";
+$r = $petition->query($q);
+$d = mysqli_fetch_array($r);
+$VTRID = $d['VTRID'];
+$FIRSTNAME = $d['FIRSTNAME'];
+$MIDDLENAME = $d['MIDDLENAME'];
+if ($MIDDLENAME == ''){
+ slack_general_admin("WARN: Blank Middle Name Detected",'md-petition-signed');
+}
+$LASTNAME = $d['LASTNAME'];
+$pos = strpos($LASTNAME, '-');
+if ($pos !== false) {
+ slack_general_admin("WARN: Hyphen in Last Name Detected",'md-petition-signed');
+}
+$ADDRESS = $d['ADDRESS'];
+$RESIDENTIALCITY = $d['RESIDENTIALCITY'];
+$COUNTY = $d['COUNTY'];
+$RESIDENTIALZIP5 = $d['RESIDENTIALZIP5'];
+// set cookies for hard_copy.php
+setcookie("pCOUNTY", $COUNTY);
+if ($MIDDLENAME == ''){
+ setcookie("pNAME", "$FIRSTNAME $LASTNAME");
+}else{
+ setcookie("pNAME", "$FIRSTNAME $MIDDLENAME $LASTNAME");
+}
+setcookie("pADDRESS", "$ADDRESS $RESIDENTIALCITY $RESIDENTIALZIP5");
+setcookie("pADDRESS1", "$ADDRESS");
+setcookie("pADDRESS2", "$RESIDENTIALCITY MD $RESIDENTIALZIP5");
+setcookie("pVTRID", $VTRID);
+setcookie("signature_status", 'verified');
+slack_general('MATCH: Is the information correct ('.$FIRSTNAME.' '.$LASTNAME.' '.$RESIDENTIALCITY.') ('.$_COOKIE['invite'].')','md-petition');
+$qX = "select * from website_text where id = '6'";
+$rX = $petition->query($qX);
+$dX = mysqli_fetch_array($rX);
+?>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+