1#@!#!123s

: / home5 / rakcha / public_html / app /
Filename : profile.php
back
<?php 

session_start();

 if (!isset($_SESSION['distributor_id'])) {

    header("location: login.php");

 }

 else {

  include("includes/database.php");



    $page_user = $_SESSION['distributor_id'];

       $select_query = "select * from member where user_id='$page_user'";

       $run = mysqli_query($con,$select_query);

       $serial = 1;

       while ($row = mysqli_fetch_array($run)) {

        $s_num = $serial++;

        $member_id = $row['member_id'];

        $profile = $row['profile'];

        $title = $row['title'];

        $dob = $row['dob'];

        $name = $row['name'];

        $co_name = $row['co_name'];

        $gender = $row['gender'];

        $address_1 = $row['address_1'];

        $address_2 = $row['address_2'];

        $town_area = $row['town_area'];

        $city_district = $row['city_district'];

        $state = $row['state'];

        $country = $row['country'];

        $pincode = $row['pincode'];

        $mobile_number = $row['mobile_number'];

        $email = $row['email'];

        $aadhaar_card = $row['aadhaar_card'];

        $pan_card = $row['pan_card'];

        $nominee_name = $row['nominee_name'];

        $nominee_relationship = $row['nominee_relationship'];

        $nominee_contact = $row['nominee_contact'];

        $account_name = $row['account_name'];

        $account_number = $row['account_number'];

        $ifsc_code = $row['ifsc_code'];

        $bank_name = $row['bank_name'];

        $branch_name = $row['branch_name'];



        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $password = $row['password'];

        $elite_board = $row['elite_board'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];



        $member_fess = $row['member_fess'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $date_of_join =$row['date_of_join'];

        $update_member =$row['update_member'];

        $profile = $row['profile']; 

         $address_1_f = $row['address_1_f'];

         $address_2_f = $row['address_2_f']; 

         $city_district_f = $row['city_district_f'];

         $state_f = $row['state_f']; 

         $pincode_f = $row['pincode_f'];

         $mobile_number_f = $row['mobile_number_f'];

    

  ?><!DOCTYPE html>

<html lang="en">



<head>

  <meta charset="UTF-8">

  <meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport">

  <title>RAKCHABLOOMING</title>

  <!-- General CSS Files -->

  <link rel="stylesheet" href="assets/css/app.min.css">

  <link rel="stylesheet" href="assets/bundles/bootstrap-social/bootstrap-social.css">

  <link rel="stylesheet" href="assets/bundles/summernote/summernote-bs4.css">

  <!-- Template CSS -->

  <link rel="stylesheet" href="assets/css/style.css">

  <link rel="stylesheet" href="assets/css/components.css">

  <!-- Custom style CSS -->

  <link rel="stylesheet" href="assets/css/custom.css">

  <link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico'>

  <link href="style/crop.css" rel="stylesheet" id="stylelink">

</head>



<body>

  <div class="loader"></div>

  <div id="app">

    <div class="main-wrapper main-wrapper-1">

      <div class="navbar-bg"></div>

      <?php include("includes/header.php"); ?>

      <!-- Main Content -->

      <div class="main-content">

        <section class="section">

          <div class="section-body">

            <div class="row mt-sm-4">

              <div class="col-12 col-md-12 col-lg-4">

                <div class="card author-box">

                  <div class="card-body">

                    <div class="author-box-center">

                      <?php if ($profile == '') {

                                                            ?>

                                                      <img alt="image" src="img/profiles.png" class="rounded-circle author-box-picture">

                                                  <?php }else {

                                                      ?>

                                                      

                                                     <img alt="image" src="../user_profile/<?= $profile; ?>" class="rounded-circle author-box-picture">

                                                      <?php

                                                  } ?>



                       





                      <div class="clearfix"></div>

                      <div class="author-box-name">

                        <a href="#"><?= $name; ?></a>

                      </div>

                      <div class="author-box-job"><?= $user_id; ?></div>

                    </div>

                     

                  </div>

                </div>

                 

                 

              </div>

              <div class="col-12 col-md-12 col-lg-8">

                <div class="card">

                  <div class="padding-20">

                    <ul class="nav nav-tabs" id="myTab2" role="tablist">

                      <li class="nav-item">

                        <a class="nav-link active" id="home-tab2" data-bs-toggle="tab" href="#about" role="tab" aria-selected="true">PERSONAL DETAILS</a>

                      </li>

                      <li class="nav-item">

                        <a class="nav-link" id="profile-tab2" data-bs-toggle="tab" href="#settings" role="tab" aria-selected="false">PROFILE IMAGE</a>

                      </li>

                      <li class="nav-item">

                        <a class="nav-link" id="profile-tab3" data-bs-toggle="tab" href="#password" role="tab" aria-selected="false">PASSWORD</a>

                      </li>

                      <li class="nav-item">

                        <a class="nav-link" id="profile-tab4" data-bs-toggle="tab" href="#passwords" role="tab" aria-selected="false">TRANSACTION PASSWORD</a>

                      </li>

                    </ul>

                    <div class="tab-content tab-bordered" id="myTab3Content">

                      <div class="tab-pane fade show active" id="about" role="tabpanel" aria-labelledby="home-tab2">

                             <form method="post" action="profile.php" enctype="multipart/form-data">

                      

                              <input type="hidden" name="member_id" value="<?= $member_id; ?>" required>

                              

                                 

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">RC ID</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $user_id; ?>" readonly style="cursor: not-allowed;">

                                    <input class="form-control" type="hidden" value="<?= $member_no; ?>" name="distributor_id" required readonly style="cursor: not-allowed;">

                                    </div>

                                </div>

                              



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Name *(<span style="color: red;"><b>As Per Bank A/C</b></span>)</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $name; ?>" name="name" required readonly style="cursor: not-allowed;">

                                    </div>

                                </div>



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Co Applicant Name *</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $co_name; ?>" name="co_name" required>

                                    </div>

                                </div>



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Date of Birth *</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $dob; ?>" name="dob" required >

                                    </div>

                                </div>

                                

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Gender</label>

                                    <div class="col-sm-8">

                                    <select class="form-control select2" style="width: 100%;" name="gender">

                                      <option selected value="<?= $gender; ?>"><?= $gender; ?></option>

                                      <option value="Male">Male</option>

                                      <option value="Female">Female</option>                              

                                    </select>

                                    </div>

                                </div>

                                <h4> Residential Address</h4>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Door No, Street</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $address_1; ?>" name="address_1">

                                    </div>

                                </div>



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Address</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $address_2; ?>" name="address_2">

                                    </div>

                                </div>

                                

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">City/District *</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $city_district; ?>" name="city_district" required>

                                    </div>

                                </div>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">State</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $state; ?>" name="state">

                                    </div>

                                </div>

                                



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Pincode *</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $pincode; ?>" name="pincode" required>

                                    </div>

                                </div>



                                 

                        

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Mobile Number *</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $mobile_number; ?>" name="mobile_number" required>

                                    </div>

                                </div>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Email</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="email"  value="<?= $email; ?>" name="email">

                                    </div>

                                </div>

                                

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">PAN Card No</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $pan_card; ?>" name="pan_card">

                                    </div>

                                </div>





                                <?php if ($update_member == 0) { ?>

                                



                                 



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Account Number</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $account_number; ?>" name="account_number">

                                    </div>

                                </div>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">IFSC Code</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $ifsc_code; ?>" name="ifsc_code">

                                    </div>

                                </div>



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Bank Name</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $bank_name; ?>" name="bank_name">

                                    </div>

                                </div>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Branch Name</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $branch_name; ?>" name="branch_name">

                                    </div>

                                </div>



                                <?php } else { ?>



                                  <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Account Number</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $account_number; ?>" name="account_number" required readonly style="cursor: not-allowed;">

                                    </div>

                                </div>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">IFSC Code</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $ifsc_code; ?>" name="ifsc_code" required readonly style="cursor: not-allowed;">

                                    </div>

                                </div>



                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Bank Name</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $bank_name; ?>" name="bank_name" required readonly style="cursor: not-allowed;">

                                    </div>

                                </div>

                                <div class="form-group row">

                                    <label for="example-text-input" class="col-sm-4 col-form-label">Branch Name</label>

                                    <div class="col-sm-8">

                                    <input class="form-control" type="text" value="<?= $branch_name; ?>" name="branch_name" required readonly style="cursor: not-allowed;">

                                    </div>

                                </div>







                                  <?php } ?>



                                  <h4> Address for courier delivery</h4>



                                    <div class="form-group row">

                                        <label for="example-text-input" class="col-sm-4 col-form-label">Door No, Street</label>

                                        <div class="col-sm-8">

                                        <input class="form-control" type="text" value="<?= $address_1_f; ?>" name="address_1_f">

                                        </div>

                                    </div>



                                    <div class="form-group row">

                                        <label for="example-text-input" class="col-sm-4 col-form-label">Address</label>

                                        <div class="col-sm-8">

                                        <input class="form-control" type="text" value="<?= $address_2_f; ?>" name="address_2_f">

                                        </div>

                                    </div>

                                    

                                    <div class="form-group row">

                                        <label for="example-text-input" class="col-sm-4 col-form-label">City/District *</label>

                                        <div class="col-sm-8">

                                        <input class="form-control" type="text" value="<?= $city_district_f; ?>" name="city_district_f" required>

                                        </div>

                                    </div>

                                    <div class="form-group row">

                                        <label for="example-text-input" class="col-sm-4 col-form-label">State</label>

                                        <div class="col-sm-8">

                                        <input class="form-control" type="text" value="<?= $state_f; ?>" name="state_f">

                                        </div>

                                    </div>

                                    



                                    <div class="form-group row">

                                        <label for="example-text-input" class="col-sm-4 col-form-label">Pincode *</label>

                                        <div class="col-sm-8">

                                        <input class="form-control" type="text" value="<?= $pincode_f; ?>" name="pincode_f" required>

                                        </div>

                                    </div>

                                    

                                            <div class="form-group row">

                                                <label for="example-text-input" class="col-sm-4 col-form-label">Mobile Number *</label>

                                                <div class="col-sm-8">

                                                <input class="form-control" type="text" value="<?= $mobile_number_f; ?>" name="mobile_number_f" required>

                                                </div>

                                            </div>

                                



                                 



                                <input type="hidden" value="<?= $password; ?>" name="password">                    

                                

                                

                                



                                <h4> Nominee Details</h4>



                                <div class="form-group row">

                                                <label for="example-text-input" class="col-sm-4 col-form-label">Nominee Name *</label>

                                                <div class="col-sm-8">

                                                <input class="form-control" type="text" value="<?= $nominee_name; ?>" name="nominee_name" required>

                                                </div>

                                            </div>



                                            <div class="form-group row">

                                                <label for="example-text-input" class="col-sm-4 col-form-label">Nominee Relationship *</label>

                                                <div class="col-sm-8">

                                                <input class="form-control" type="text" value="<?= $nominee_relationship; ?>" name="nominee_relationship" required>

                                                </div>

                                            </div>



                                            <div class="form-group row">

                                                <label for="example-text-input" class="col-sm-4 col-form-label">Nominee Mobile No *</label>

                                                <div class="col-sm-8">

                                                <input class="form-control" type="text" value="<?= $nominee_contact; ?>" name="nominee_contact" required>

                                                </div>

                                            </div>

                                



                                

                             

                              

                              <div class="box-footer">

                                <button type="submit" name="submit" id="clickedYes" class="btn btn-primary pull-right">Submit</button>

                              </div>

 



                               

                              



                          </form>

                      </div>

                      <div class="tab-pane fade" id="settings" role="tabpanel" aria-labelledby="profile-tab2">

                            <div class="row">

                                <div class="col-md-4 text-center">

                                <div id="upload-demo"></div>

                                </div>

                                <div class="col-md-4" style="padding:5%;">

                                <strong style="color: #fff;">CHANGE PROFILE IMAGE:</strong>

                                 



                                



                                <div class="custom-file">

                                    <input type="file" class="form-control" id="image">

                                    <label class="custom-file-label" for="customFile">Choose file</label>

                                    <button class="btn btn-primary btn-block btn-upload-image" style="margin-top:2%">SET PROFILE</button>

         

                                </div>

                                </div>



                                <div class="col-md-4">

                                <div id="preview-crop-image" style="background:#fff;width:300px;padding:50px 50px;height:300px;"></div>

                                </div>

                                <div id="success"></div>

                              </div>

                      </div>



                      <div class="tab-pane fade" id="password" role="tabpanel" aria-labelledby="profile-tab3">

                             <form method="post" action="profile.php" enctype="multipart/form-data">

                                <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                  <div class="form-group row">

                                    

                                    <div class="col-sm-12">

                                    <input class="form-control" type="password" name="current_password" placeholder="Enter Your Current Password">

                                    </div>

                                  </div>



                                  <div class="form-group row">

                                    

                                    <div class="col-sm-12">

                                    <input class="form-control" type="password" name="new_password" placeholder="Enter Your New Password">

                                    </div>

                                  </div>

                                  <div class="box-footer">

                                    <button type="submit" name="csubmit" class="btn btn-primary">Submit</button>

                                  </div>

                              </form>

                      </div>



                      <div class="tab-pane fade" id="passwords" role="tabpanel" aria-labelledby="profile-tab4">

                             <form method="post" action="profile.php" enctype="multipart/form-data">

                              <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                <div class="form-group row">

                                  

                                  <div class="col-sm-12">

                                  <input class="form-control" type="password" name="current_password" placeholder="Enter Your Current KIT Password">

                                  </div>

                                </div>



                                <div class="form-group row">

                                  

                                  <div class="col-sm-12">

                                  <input class="form-control" type="password" name="new_password" placeholder="Enter Your New KIT Password">

                                  </div>

                                </div>

                                <div class="box-footer">

                                  <button type="submit" name="tsubmit" class="btn btn-primary">Submit</button>

                                </div>

                            </form>

                      </div>

                    </div>

                  </div>

                </div>

              </div>

            </div>

          </div>

        </section>

         

      </div>

      <footer class="main-footer">

        <div class="footer-left">

          Copyright &copy; 2021 <div class="bullet"></div> All Rights Reserved.

        </div>

        <div class="footer-right">

        </div>

      </footer>

    </div>

  </div>

  <!-- General JS Scripts -->

  <script data-cfasync="false" src="../../../../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script><script src="assets/js/app.min.js"></script>

  <!-- JS Libraies -->

  <script src="assets/bundles/summernote/summernote-bs4.js"></script>

  <!-- Page Specific JS File -->

  <!-- Template JS File -->

  <script src="assets/js/scripts.js"></script>

  <!-- Custom JS File -->

  <script src="assets/js/custom.js"></script>

  <script src="style/crop.js"></script>



  <script type="text/javascript">

    var resize = $('#upload-demo').croppie({

    enableExif: true,

    enableOrientation: true,    

    viewport: { // Default { width: 100, height: 100, type: 'square' } 

        width: 100,

        height: 100,

        type: 'square' //circle

    },

    boundary: {

        width: 200,

        height: 200

    }

});





$('#image').on('change', function () { 

  var reader = new FileReader();

    reader.onload = function (e) {

      resize.croppie('bind',{

        url: e.target.result

      }).then(function(){

        console.log('jQuery bind complete');

      });

    }

    reader.readAsDataURL(this.files[0]);

});





$('.btn-upload-image').on('click', function (ev) {

  resize.croppie('result', {

    type: 'canvas',

    size: 'viewport'

  }).then(function (img) {

    $.ajax({

      url: "croppie.php",

      type: "POST",

      data: {"image":img},

      success: function (data) {

        html = '<img src="' + img + '" />';

        $("#preview-crop-image").html(html);



        document.getElementById("success").innerHTML +=  

              "<div class='alert bg-success' role='alert'>Successfully Updated Profile...<button type='button' class='close text-white' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button></div>"; 

      }

    });

  });

});

  </script>

</body>



</html>



<?php 



 if (isset($_POST['submit'])) {

   

   $title = "";

   $dob = $_POST['dob'];

   $name = $_POST['name'];

   $co_name = $_POST['co_name'];

   $gender = $_POST['gender'];

   $address_1 = $_POST['address_1'];

   $address_2 = $_POST['address_2'];

   $town_area = "";

   $city_district = $_POST['city_district'];

   $state = $_POST['state'];

   $country = "";

   $pincode = $_POST['pincode'];

   $mobile_number = $_POST['mobile_number'];

   $email = $_POST['email'];

   $aadhaar_card = "";

   $pan_card = $_POST['pan_card'];

   $nominee_name = $_POST['nominee_name'];

       $nominee_relationship = $_POST['nominee_relationship'];

       $nominee_contact = $_POST['nominee_contact'];

   $account_name = $_POST['name'];

   $account_number = $_POST['account_number'];

   $ifsc_code = $_POST['ifsc_code'];

   $bank_name = $_POST['bank_name'];

   $branch_name = $_POST['branch_name'];

   $member_id = $_POST['member_id'];

   $password = $_POST['password'];



         $address_1_f = $_POST['address_1_f'];

         $address_2_f = $_POST['address_2_f']; 

         $city_district_f = $_POST['city_district_f'];

         $state_f = $_POST['state_f']; 

         $pincode_f = $_POST['pincode_f'];

         $mobile_number_f = $_POST['mobile_number_f'];



   

   

   





      

      if ($name == '') {

        

        echo "<script>alert('Some Feilds Empty.')</script>";

        exit();

        }

        else {         

             

             $insert_query = "update member set title = '$title', dob = '$dob', name = '$name', gender = '$gender', address_1 = '$address_1', address_2 = '$address_2', town_area = '$town_area', city_district = '$city_district', state = '$state', country = '$country', pincode = '$pincode', mobile_number = '$mobile_number', email = '$email', aadhaar_card = '$aadhaar_card', pan_card = '$pan_card', nominee_name = '$nominee_name', nominee_relationship = '$nominee_relationship', account_name = '$account_name', account_number = '$account_number', ifsc_code = '$ifsc_code', bank_name = '$bank_name', branch_name = '$branch_name', password = '$password', update_member='1', address_1_f='$address_1_f', address_2_f='$address_2_f', city_district_f='$city_district_f', state_f='$state_f', pincode_f='$pincode_f', mobile_number_f='$mobile_number_f', nominee_contact='$nominee_contact', co_name='$co_name' where member_id = '$member_id'";

            if (mysqli_query($con,$insert_query)) {           

                echo "<script>alert('Profile has been successfully Updated...')</script>";

                echo "<script>window.open('profile.php','_self')</script>";

            }

            

            

        

        }

   





 }





 if (isset($_POST['csubmit'])) {

        $member_no = $_POST['member_no'];

        $current_password = $_POST['current_password'];

        $new_password = $_POST['new_password'];    

      

      



      $admin_query = "select * from member where member_no = '$member_no' AND password = '$current_password'";

      $run = mysqli_query($con,$admin_query);

      if (mysqli_num_rows($run)>0) {



        $insert_query = "update member set password='$new_password' where member_no = '$member_no'";

                if (mysqli_query($con,$insert_query)) {

                      echo "<script>alert('Password has been successfully changed...')</script>"; 

                      echo "<script>window.open('index.php','_self')</script>";



                    }

        

        

      }

      else {

        echo "<script>alert('please enter correct Current password')</script>";

        exit;

      }

}



if (isset($_POST['tsubmit'])) {

        $member_no = $_POST['member_no'];

        $current_password = $_POST['current_password'];

        $new_password = $_POST['new_password'];    

      

      



      $admin_query = "select * from member where member_no = '$member_no' AND eproduct_password = '$current_password'";

      $run = mysqli_query($con,$admin_query);

      if (mysqli_num_rows($run)>0) {



        $insert_query = "update member set eproduct_password='$new_password' where member_no = '$member_no'";

                if (mysqli_query($con,$insert_query)) {

                      echo "<script>alert('Eproduct Password has been successfully changed...')</script>"; 

                      echo "<script>window.open('index.php','_self')</script>";



                    }

        

        

      }

      else {

        echo "<script>alert('please enter correct Current password')</script>";

        exit;

      }

}



 ?>

<?php } }  ?>