/* Decoded by unphp.net */ require_once('../database/header.php'); if($userdata['status']=='paywait'){ echo ' '; } ;echo '
';if($userdata['usertype']=="mainadmin"){;echo '
PAN Application Update and View - ';echo base64_decode($_GET['keypass']);;echo '
'; if(isset($_GET['datakey'])){ $stmt = $conn->prepare("select * from nsdlpancard WHERE id = ? AND order_id = ? "); $stmt->execute([base64_decode($_GET['datakey']),base64_decode($_GET['keypass'])]); $row=$stmt->fetch(); $rowobj = json_decode($row['changes'],true); if($row['id']==""){ echo ' '; } } if(isset($_POST['action']) ){ $allowed_extensions = array("jpg","jpeg","png","gif"); $allowedExts = array("pdf"); $formexn = end(explode(".",$_FILES["ack_pdf"]["name"])); $photoexn = end(explode(".",$_FILES["photo"]["name"])); $signexn = end(explode(".",$_FILES["sign"]["name"])); if ($_FILES["ack_pdf"]["type"] == "application/pdf"&& $_FILES["ack_pdf"]["size"] <3000000 && in_array($formexn,$allowedExts) ) { $form_pdf = str_replace(' ','_',$row["ack_no"])."-".rand(100000,999999)."_Form.pdf"; $form_link = "http://".$_SERVER['SERVER_NAME']."/downloads.php?files=$ack_pdf"; move_uploaded_file($_FILES["ack_pdf"]["tmp_name"],"../pan_doc/".$ack_pdf); $photo_pdf = $_POST["name_card"]."-".rand(100000,999999)."_Photo.jpg"; $photo_link = "http://".$_SERVER['SERVER_NAME']."/downloads.php?files=$photo_pdf"; move_uploaded_file($_FILES["photo"]["tmp_name"],"../pan_doc/".$photo_pdf); $sign_pdf = $_POST["name_card"]."-".rand(100000,999999)."_Sign.jpg"; $sign_link = "http://".$_SERVER['SERVER_NAME']."/downloads.php?files=$sign_pdf"; move_uploaded_file($_FILES["sign"]["tmp_name"],"../pan_doc/".$sign_pdf); } if($_FILES["ack_pdf"]["name"]==""){ $ack_pdf = $row['ack_pdf']; }else{ $ack_pdf = $form_link; } $response->full_name = filter_var($_POST['full_name'],FILTER_SANITIZE_STRING); $response->father_name = filter_var($_POST['father_name'],FILTER_SANITIZE_STRING); $response->date_brith = filter_var($_POST['date_brith'],FILTER_SANITIZE_STRING); $response->gender = filter_var($_POST['gender_c'],FILTER_SANITIZE_STRING); $response->address = filter_var($_POST['address'],FILTER_SANITIZE_STRING); $response->nofdoc = filter_var($_POST['nofdoc'],FILTER_SANITIZE_STRING); $changes = json_encode($response); $nsdlsql = "UPDATE nsdlpancard SET cat_applicant=:cat_applicant,pan_number=:pan_number,l_name=:l_name,f_name=:f_name,m_name=:m_name,name_card=:name_card,dob=:dob,gender=:gender,fal_name=:fal_name, faf_name=:faf_name,fam_name=:fam_name,aadhaar_num=:aadhaar_num,name_aadhaar=:name_aadhaar,mob_num=:mob_num,email_id=:email_id,address1=:address1,address2=:address2,address3=:address3,address4=:address4,address5=:address5, user_state=:user_state,pincode=:pincode,pan_type=:pan_type,r_title=:r_title,rl_name=:rl_name,rf_name=:rf_name,rm_name=:rm_name,r_address1=:r_address1,r_address2=:r_address2,r_address3=:r_address3,r_address4=:r_address4,r_address5=:r_address5, r_state=:r_state,r_pincode=:r_pincode,city=:city,area_code=:area_code,ao_type=:ao_type,rangecode=:rangecode,aocode=:aocode,proof_id=:proof_id,proof_add=:proof_add,proof_dob=:proof_dob,ack_pdf=:ack_pdf,changes=:changes,ack_no=:ack_no,remark=:remark,remark=:remark,status=:status WHERE id='".$row['id']."'"; $nsdl = $conn->prepare($nsdlsql); $nsdl->bindParam(":cat_applicant",filter_var($_POST["cat_applicant"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":pan_number",filter_var($_POST["pan_number"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":l_name",filter_var($_POST["l_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":f_name",filter_var($_POST["f_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":m_name",filter_var($_POST["m_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":name_card",filter_var($_POST["name_card"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":dob",filter_var($_POST["dob"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":gender",filter_var($_POST["gender"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":fal_name",filter_var($_POST["fal_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":faf_name",filter_var($_POST["faf_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":fam_name",filter_var($_POST["fam_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":aadhaar_num",filter_var($_POST["aadhaar_num"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":name_aadhaar",filter_var($_POST["name_aadhaar"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":mob_num",filter_var($_POST["mob_num"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":email_id",filter_var($_POST["email_id"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":address1",filter_var($_POST["address1"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":address2",filter_var($_POST["address2"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":address3",filter_var($_POST["address3"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":address4",filter_var($_POST["address4"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":address5",filter_var($_POST["address5"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":user_state",filter_var($_POST["user_state"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":pincode",filter_var($_POST["pincode"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":pan_type",filter_var($_POST["pan_type"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_title",filter_var($_POST["r_title"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":rl_name",filter_var($_POST["rl_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":rf_name",filter_var($_POST["rf_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":rm_name",filter_var($_POST["rm_name"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_address1",filter_var($_POST["r_address1"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_address2",filter_var($_POST["r_address2"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_address3",filter_var($_POST["r_address3"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_address4",filter_var($_POST["r_address4"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_address5",filter_var($_POST["r_address5"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_state",filter_var($_POST["r_state"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":r_pincode",filter_var($_POST["r_pincode"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":city",filter_var($_POST["city"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":area_code",filter_var($_POST["area_code"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":ao_type",filter_var($_POST["ao_type"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":rangecode",filter_var($_POST["rangecode"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":aocode",filter_var($_POST["aocode"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":proof_id",filter_var($_POST["proof_id"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":proof_add",filter_var($_POST["proof_add"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":proof_dob",filter_var($_POST["proof_dob"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":ack_pdf",$ack_pdf); $nsdl->bindParam(":changes",$changes); $nsdl->bindParam(":ack_no",filter_var($_POST["ack_no"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":remark",filter_var($_POST["remark"],FILTER_SANITIZE_STRING)); $nsdl->bindParam(":status",filter_var($_POST["status"],FILTER_SANITIZE_STRING)); if($nsdl->execute()){ echo ' '; }else { echo ''; } } ;echo '
'; if($row['pan_number']=="newpan"){ ;echo ' Category of Applicant * '; }else{ ;echo ' Pan Number * '; } ;echo '
Last Name/ Surname *
First Name
Middle Name
Name on Card *
Date of Birth / Incorporation *
Gender *
Father\'s Last Name *
Father\'s First Name
Father\'s Middle Name
Aadhaar Number *
Name As Per Aadhaar *
Mobile Number *
Email Address *
Flat/Room/Door/Block No. *
Building/Village Name *
Road/Street/Lane/Post Office *
Area/Locality/Sub-Division
Town/City/District *
State/Union Territory *
Pincode *
'; if($row['pan_number']=="newpan"){ ;echo ' Pan Card Type * '; }else{ ;echo ' Number of Documents * '; } ;echo '
'; if($row['pan_number']=="newpan"){ ;echo '
City
Area Code *
Ao Type *
Range Code *
Ao No *
'; }else{ if($rowobj['full_name']=='Y'){ $full_name = 'checked'; } if($rowobj['father_name']=='Y'){ $father_name = 'checked'; } if($rowobj['date_brith']=='Y'){ $date_brith = 'checked'; } if($rowobj['gender']=='Y'){ $gender_c = 'checked'; } if($rowobj['address']=='Y'){ $address = 'checked'; } ;echo '
Changes Or Correction ?
'; } ;echo '

Proof of Identity *
Proof of Address *
Proof of DOB *
Acknowledgement No. *
Ack PDF (200dpi)
Remarks *
Status *
Document PDF Download
Update
';};echo '
'; require_once('../database/footer.php'); ;