<?php include("includes/db_config.php");
error_reporting(E_ALL);
ini_set('display_errors','1'); 
/*use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
require 'PHPMailer/Exception.php';
require 'PHPMailer/PHPMailer.php';
require 'PHPMailer/SMTP.php';*/
if(isset($_POST['reg_submit'])) {
extract($_POST);
 $logo = "assets/img/logo.png";
    $logo_width = "100%";
    $logo_height = "";
    // All CSS
    // Body
    $body_title = "Telangana Journalist Reporter Association";
    $width_of_mail_body = "95%"; // Please write in % percentage for better view...
    $padding_of_mail_body = "15px";
    $body_background_color = "";
    $body_text_color = "";
    // Button
    $button_background_color = "#4db7fe";
    $button_text_color = "white";
    $button_font_size = "18px";
    $button_font_family = "arial";
    $button_padding = "15px";
    $button_border_radius = "10px";
    // Highlight
    $highlight_color = "#4db7fe";
    $highlight_font_size = "19px";
    $arial = "arial";
    // Heading
    $heading_color = "#4db7fe";
    $heading_font_size = "20px";
    $heading_font_family = "arial";
 //$email= $_POST['email'];
 //$_SESSION['email'] = $email;
 $password= $_POST['password'];
 $cpassword= $_POST['cpassword'];
 $email = mysqli_real_escape_string($conn,$_POST['email_id']);
$father_name = mysqli_real_escape_string($conn,$_POST['father_name']);
$contact_no = mysqli_real_escape_string($conn,$_POST['contact_no']);
$password = mysqli_real_escape_string($conn,$_POST['password']);
$cpassword = mysqli_real_escape_string($conn,$_POST['cpassword']);
 $tmp_file = $_FILES['image']['tmp_name'];
    $ext = pathinfo($_FILES["image"]["name"], PATHINFO_EXTENSION);
    $rand = md5(uniqid().rand());
    $gimg = $rand.".".$ext;
    move_uploaded_file($tmp_file,"admin-jurep/images/".$gimg);
 $tmp_file = $_FILES['signature']['tmp_name'];
    $ext = pathinfo($_FILES["signature"]["name"], PATHINFO_EXTENSION);
    $rand = md5(uniqid().rand());
    $stimg = $rand.".".$ext;
    move_uploaded_file($tmp_file,"admin-jurep/images/".$stimg);
$tmp_file = $_FILES['adhaarno']['tmp_name'];
    $ext = pathinfo($_FILES["adhaarno"]["name"], PATHINFO_EXTENSION);
    $rand = md5(uniqid().rand());
    $adimg = $rand.".".$ext;
    move_uploaded_file($tmp_file,"admin-jurep/images/".$adimg);
$sqlry ="SELECT count(*) as num FROM user_profile WHERE contact_no = '".$contact_no."'";
$result = mysqli_query($conn, $sqlry) or die(mysqli_error($conn));
$res= mysqli_fetch_array($result);
$count=$res['num']; 
if($count == 0){
if($password === $cpassword){ 
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');
$password= md5($password);
$sqls="INSERT into user_profile(name,father_name,contact_no,designation,dob,address,image,signature,email_id,password,organizations,blood_group,aadhar_no,labour,company_name,place_work,acardno,registration_date) values ('$name','$father_name','$contact_no','$designation','$dob','$address','$gimg','$stimg','$email','$password','$reg_union','$blood_group','$adimg','$labour','$company_name','$place_work','$acardno','$date')";
$results = mysqli_query($conn, $sqls);
$last_id= mysqli_insert_id($conn);
if($_POST['reg_union'] == "Telangana Journalist Reporter Association India"){
$user_id="TJRAI".$last_id;
}
$name=$_POST['name'];
$contact_no=$_POST['contact_no'];
$email=$_POST['email_id'];
$reg_union=$_POST['reg_union'];
$designation=$_POST['designation'];
$dob=$_POST['dob'];
$place_work=$_POST['place_work'];
$acardno=$_POST['acardno'];
$data = "\n 
        Name                    : $name \n 
        Mobile No               : $contact_no \n
        Email                   : $email \n
        Organizations           : $reg_union \n
        Designation             : $designation \n  
        DOB                     : $dob \n  
        Place Work              : $place_work \n
        Aadhaar Card No         : $acardno \n
        ";
if($result){
    $PNG_TEMP_DIR = dirname(__FILE__).DIRECTORY_SEPARATOR.'qr-code'.DIRECTORY_SEPARATOR;  
    //html PNG location prefix
    $PNG_WEB_DIR = 'qr-code/';
    include "qrfile/qrlib.php";  
    if (!file_exists($PNG_TEMP_DIR))
        mkdir($PNG_TEMP_DIR);
    $filename = $PNG_TEMP_DIR.'test.png';
    $errorCorrectionLevel = 'L';
    $matrixPointSize = 4;
    if (isset($data)) { 
        //it's very important!
        if (trim($data) == '')
            die('data cannot be empty! <a href="?">back</a>');
             $extension = explode("%", $data);
            $name= $extension[0];
        // user data
        date_default_timezone_set('Asia/Kolkata');
       $date = date('Y-m-d H:i:s');
         $sname=$name;
        $filename = $PNG_TEMP_DIR.'doc'.md5($data.'|'.$errorCorrectionLevel.'|'.$matrixPointSize).'.png';
        $filenamess ='doc'.md5($data.'|'.$errorCorrectionLevel.'|'.$matrixPointSize).'.png'; 
        $sql1 ="UPDATE user_profile SET qr_img='$filenamess' WHERE id='".$last_id."'";
         $ress=mysqli_query($conn,$sql1) or die(mysqli_error());
         QRcode::png($data, $filename, $errorCorrectionLevel, $matrixPointSize, 2); 
        } else {   
        //default data
        echo ': <a href="?data=like_that"></a><hr/>';    
        QRcode::png('PHP QR Code :)', $filename, $errorCorrectionLevel, $matrixPointSize, 2);    
        }    
     $sqlss ="UPDATE user_profile SET user_id='$user_id' WHERE id='".$last_id."'";
     $resst=mysqli_query($conn,$sqlss) or die(mysqli_error());
  /*  $sqll ="SELECT * FROM user_profile WHERE id = '".$last_id."'";
$resultt = mysqli_query($conn, $sqll) or die(mysqli_error($conn));
$ress= mysqli_fetch_array($resultt);
$name=$ress['fname'];
$email=$ress['email'];
 $password= $_POST['password'];
$date = date("d-m-Y");
    $from_team = "Telangana Journalist Reporter Association";
    $from_website = "https://www.tjra.in/index.php";
    $to = $email;
    $message= "Hi";
$email = new PHPMailer();
$email->Body      =  ($message);
$email->SetFrom('no-reply@tjra.in', 'Telangana Journalist Reporter Association'); //Name is optional
$email->Subject   = $name . " Your Registration successfully Completed";
$email->IsHTML(true);
$email->Body      =  ($message);
$email->AddAddress($to);
   if (! $email->Send()) {
       //echo "<script>alert('Problem in sending email!');</script>";
    } else {
  echo '<script>alert("Registration successfully Completed")</script>'; 
    }*/
  echo '<script>alert("Registration successfully Completed")</script>'; ?>
  <script><?php echo "location.href = 'registration-charge.php?id=".$last_id."';";?></script>
<?php }
}else{
    echo '<script>alert("Password Does not match")</script>';  
} }else{
    echo '<script>alert("Mobile Number Already Exits! Please Login")</script>';  
}
} ?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Telangana Journalist Reporter Association</title>
    <?php include("includes/css.php");?>
    <link rel="canonical" href="https://www.tjra.in/" />
    <meta property="og:locale" content="en_Us" />
    <meta property="og:type" content="website" />
    <meta property="og:title" content="Telangana Journalist Reporter Association" />
    <meta property="og:description" content="Telangana Journalist Reporter Association provides " />
    <meta property="og:url" content="https://www.tjra.in//" />
    <meta property="og:site_name" content="Telangana Journalist Reporter Association" />
    <meta charset="utf-8">
    <meta name="keywords" content="" />
    <meta name="author" content="Telangana Journalist Reporter Association">
    <meta name="description" content="" />
     <style>
        .team-one--about {
            padding: 100px 0px 100px 0px;
        } 
        .login-page {
            padding: 35px 0;
        }
        .login-page__wrap {
  position: relative;
  padding: 30px;
  background-color: var(--careox-gray, #f1f6f7);margin: 0px;
}
        .login-page__wrap__title{
         color:#b91e4d;
        text-transform:uppercase;text-align: center
        }
        label{font-weight:600}
        .login-page .careox-btn { 
  width: 100%;
}
.page-header {
            padding-top: 10px;
            padding-bottom:5px;
        }

        .page-header__bg {
            background-image: none;
            background-color: #fff;
        }

        .page-header__bg::before {
            background-color: #000
        } .comments-one__card:not(:first-of-type) {
    margin-top: 25px;
    padding-top: 25px;
  }
         
     @media (min-width: 320px) and (max-width: 640px) {
             .page-header {
                 padding-top:40px;
                 padding-bottom: 5px;
             }
         }
    </style>
</head>

<body class="custom-cursor">
    <div class="custom-cursor__cursor"></div>
    <div class="custom-cursor__cursor-two"></div>

    <div class="page-wrapper">
        <?php include("includes/header.php");?>

        <section class="page-header">
            <div class="page-header__bg"></div>
            <div class="container-fluid">
                <ul class="careox-breadcrumb list-unstyled">
                    <li><a href="index.php">Home</a></li>
                    <li><span>Register</span></li>
                </ul>
            </div>
        </section>
        <section class="login-page" style="background-color:#f5f6f7">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-3"></div>
                    <div class="col-md-6 login-page__wrap" style="background-color:#fff;border: 1px solid #e8e8e8;"> 
                    <h3 class="login-page__wrap__title">Register your Account</h3>
                        <form class="login-page__form" action="" method="post" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="login-page__form-input-box">
										<label>Select Organization</label>
                                        <select class="form-control" name="reg_union" required>
											<option value="">Select</option>
											<option>Telangana Journalist Reporter Association India</option>
											
										</select>
                                     </div>
                                </div>
								<div class="col-md-6">
                                    <div class="login-page__form-input-box">
										<label>Full Name</label> <input type="text" name="name" id="name" placeholder="Full Name *" required>
                                         <span style="color: red" id="name_alert"></span>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
										<label>Father's Name</label> <input type="text" name="father_name" id="fname" placeholder="Father's Name " >
                                         <span style="color: red" id="fname_alert"></span>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
										<label>Email-Id</label>
										<input type="email" name="email_id" id="email_id" class="email-search" placeholder="Email" >
                                        <span style="color: red" id="email_alert"></span>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
										<label>Contact Number</label>
										<input type="tel" name="contact_no" id="contact_no" placeholder="Contact Number *" class="contactno-search" required>
                                        <span style="color: red" id="contact_no_alert"></span>
                                        <div class="alert alert-warning" id="result" style="display: none;"> </div>
                                    </div>
                                </div>
                                <div class="col-md-12">
                                    <div class="login-page__form-input-box">
                                        <label>Company Name</label>
                                        <input type="text" name="company_name" id="company_name" placeholder="Company Name *" required>
                                        <span style="color: red" id="company_name_alert"></span>
                                    </div>
                                </div>
                             
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                        <label>Place Of Work</label>
                                        <input type="text" name="place_work" id="place_work" placeholder="Place Of Work " >
                                        <span style="color: red" id="place_work_alert"></span>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
										<label>Designation</label>
										<input type="text" name="designation" id="designation" placeholder="Designation " >
                                        <span style="color: red" id="designation_alert"></span>
                                    </div>
                                </div>
                              
                               
                                <div class="col-md-6">
									<label>Date Of Birth</label>
                                    <div class="login-page__form-input-box">
                                        <input type="date" name="dob" placeholder="Date Of Birth " >
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                        <label>Blood Group</label>
                                        <input type="text" name="blood_group" >
                                    </div>
                                </div>
                                 <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                       <label>Your Photo</label>
										<input type="file" name="image">
                                    </div>
                                </div>
                                 <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                       <label>Signature</label>
										<input type="file" name="signature">
                                    </div>
                                </div>
								   <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                        <label>Aadhaar Card No.</label>
                                        <input type="text" name="acardno" id="acardno" placeholder="Aadhaar Card No.*" >
                                     </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                        <label>Upload Adhaar Card</label>
										<input type="file" name="adhaarno">
                                    </div>
                                </div>
                                 
                                 <div class="col-md-12">
                                    <div class="login-page__form-input-box">
                                        <label>Address</label>
										<input type="text" name="address" id="designation" placeholder="Address">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                         <label>Password</label>
										<input type="password" onKeyUp="checkPass()" name="password" id="password" placeholder="Password *" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="login-page__form-input-box">
                                        <label>Reenter Password</label>
										<input type="password" onKeyUp="checkPass()" name="cpassword" id="cpassword" placeholder="Confirm Password *">
                                         <span id="error-nwl" ></span>
                                    </div>
                                </div>
                            </div>
                            <div class="register-page__checked-box">
                                <input type="checkbox" name="save-data" id="save-data">
                                <label for="save-data"><span></span>I agree <a href="#">Team & Conditions</a></label>
                            </div>
                             <center>
                                <button type="submit" name="reg_submit" class="btn btn-sm careox-btn"><span>Register</span></button><br/>
                            <a href="login.php">Already account? Login Here</a>
                            </center>
                        </form>
                    </div>
                </div>
            </div>
        </section>
        <?php include("includes/newsletter.php");?>
    </div>
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
    <script type="text/javascript">
    function checkPass()
    {
        var pass1 = document.getElementById('password');
        var pass2 = document.getElementById('cpassword');
        var message = document.getElementById('error-nwl');
        var goodColor = "#66cc66";
        var badColor = "#ff6666";
      
        if(pass1.value.length > 5)
        {
            pass1.style.backgroundColor = goodColor;
            message.style.color = goodColor;
            message.innerHTML = "character number ok!"
        }
        else
        {
            pass1.style.backgroundColor = badColor;
            message.style.color = badColor;
            message.innerHTML = " you have to enter at least 6 digit!"
            return;
        }
      
        if(pass1.value == pass2.value)
        {
            pass2.style.backgroundColor = goodColor;
            message.style.color = goodColor;
            message.innerHTML = "Password Match!"
        }
      else
        {
            pass2.style.backgroundColor = badColor;
            message.style.color = badColor;
            message.innerHTML = " These passwords don't match"
        }
    }  
$(document).ready(function(){
    $(".email-search").keyup(function()
    {
    searchid = $(this).val();
    dataString = 'search2='+ searchid;
    if(searchid!='')
    {
    $.ajax({
    type: "POST",
    url: "reg_validation.php",
    data: dataString,
    cache: false,
    success: function(html)
    {
    $("#result2").html(html).show();
    }
    });
    }return false;
    });
    });
$(document).ready(function(){
    $(".contactno-search").keyup(function()
    {
    searchid = $(this).val();
    dataString = 'search='+ searchid;
    if(searchid!='')
    {
    $.ajax({
    type: "POST",
    url: "reg_validation.php",
    data: dataString,
    cache: false,
    success: function(html)
    {
    $("#result").html(html).show();
    }
    });
    }return false;
    });
    });
</script>
<script type="text/javascript">
$(document).ready(function(){  
    $("#name").keyup(function(){
      return validatetext('name','name_alert'); 
});   }); 
$(document).ready(function(){  
    $("#contact_no").keyup(function(){
      return validmobile('contact_no','contact_no_alert'); 
});   }); 

$(document).ready(function(){  
    $("#email_id").keyup(function(){
      return validemailid('email_id','email_alert'); 
});   }); 
$(document).ready(function(){  
    $("#designation").keyup(function(){
      return validatetext('designation','designation_alert'); 
});   }); 
$(document).ready(function(){  
    $("#company_name").keyup(function(){
      return validatetext('company_name','company_name_alert'); 
});   }); 
$(document).ready(function(){  
    $("#place_work").keyup(function(){
      return validatetext('place_work','place_work_alert'); 
});   }); 
$(document).ready(function(){  
    $("#name_nominee").keyup(function(){
      return validatetext('name_nominee','name_nominee_alert'); 
});   }); 
$(document).ready(function(){  
    $("#family_member").keyup(function(){
      return validatetext('family_member','family_member_alert'); 
});   }); 
$(document).ready(function(){ 
$("#signup_submit").click(function(){
  var name    = validatetext('name','name_alert'); 
  var contact_no    = validmobile('contact_no','contact_no_alert'); 
  var designation    = validatetext('designation','designation_alert'); 
  var company_name    = validatetext('company_name','company_name_alert'); 
  var place_work    = validatetext('place_work','place_work_alert'); 
  var email_id    = validemailid('email_id','email_alert'); 
  if(contact_no == 0 || email_id == 0 || designation == 0 || name == 0 || company_name == 0 || place_work == 0)
  {
    return false;
  }

  });  
});
function Validate() {
    var password = document.getElementById("password").value;
    var confirmPassword = document.getElementById("cpassword").value;
    if (password != confirmPassword) {
        alert("Passwords do not match.");
        return false;
    }
    return true;
}

 $(function() {
        $('#password').on('keypress', function(e) {
            if (e.which == 32){
                alert('Space not applicable, Please remove spaces');
                console.log('Space Detected');
                return false;
            }
        });
});
</script>
</body>

</html>