1#@!#!123s

: / home5 / rakcha / public_html / app /
Filename : eproduct_add_member.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'];

        $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'];

        $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'];



        $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'];

        $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'];

        $date_of_join =$row['date_of_join'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];

        $profile = $row['profile'];



        if (isset($_GET['eproduct'])) {

          $page_eproduct_no = $_GET['eproduct'];

          $select_query_direct_level = "select * from eproduct_details_roi where receiver_no = '$member_no' AND eproduct_no = '$page_eproduct_no'";

          $run_direct_level = mysqli_query($con,$select_query_direct_level);

          $numrows_m_2 = mysqli_num_rows($run_direct_level);



          if ($numrows_m_2 > 0) {



             $sponsor_id = $member_no;

             $eproduct = $page_eproduct_no;



             $select_query_direct_level_1 = "select * from eproduct_details_roi where receiver_no = '$sponsor_id' AND eproduct_no='$eproduct'";

             $run_direct_level_1 = mysqli_query($con,$select_query_direct_level_1);                                 

             while ($row_direct_level_1 = mysqli_fetch_array($run_direct_level_1)) {

              $eproduct_id_row_direct_level_1 = $row_direct_level_1['eproduct_id'];

              $issue_date_row_direct_level_1 = $row_direct_level_1['issue_date'];

              $sender_no_row_direct_level_1 = $row_direct_level_1['sender_no'];

              $receiver_no_row_direct_level_1 = $row_direct_level_1['receiver_no'];

              $eproduct_no_row_direct_level_1 = $row_direct_level_1['eproduct_no'];

              $member_no_row_direct_level_1 = $row_direct_level_1['member_no'];

              $pin_value_row_direct_level_1 = $row_direct_level_1['pin_value'];

              }

            

        

  ?><!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">

  <style type="text/css">

    /* Base for label styling */

      [type="checkbox"]:not(:checked),

      [type="checkbox"]:checked {

        position: absolute;

        left: -9999px;

      }

      [type="checkbox"]:not(:checked) + label,

      [type="checkbox"]:checked + label {

        position: relative;

        padding-left: 25px;

        cursor: pointer;

      }



      /* checkbox aspect */



      [type="checkbox"]:checked + label:before {

        content: '';

        position: absolute;

        left:0; top: 0px;

        width: 20px; height: 20px;

        //border: 1px solid #aaa;

        background: #09ad7e;

        border-radius: 3px;

        //box-shadow: inset 0 1px 3px rgba(0,0,0,.3)

      }

      [type="checkbox"]:not(:checked) + label:before {

      content: '';

        position: absolute;

        left:0; top: 0px;

        width: 20px; height: 20px;

        //border: 1px solid #fff;

        background: #eee;

        border-radius: 3px;

        //box-shadow: inset 0 1px 3px rgba(0,0,0,.3)

      }

      /* checked mark aspect */



      [type="checkbox"]:checked + label:after {

        content: '✔';

        position: absolute;

        top: 0; left: 4px;

        font-size: 14px;

        color: #f8f8f8;

        transition: all .2s;

      }

      [type="checkbox"]:not(:checked) + label:after {

      content: '✔';

        position: absolute;

        top: 0; left: 4px;

        font-size: 14px;

        color: #ddd;

        transition: all .2s;



      }

      /* checked mark aspect changes */

      [type="checkbox"]:not(:checked) + label:after {

        opacity: 1;

        transform: scale(1);

      }

      [type="checkbox"]:checked + label:after {

        opacity: 1;

        transform: scale(1);

      }

      /* disabled checkbox */

      [type="checkbox"]:disabled:not(:checked) + label:before,

      [type="checkbox"]:disabled:checked + label:before {

        box-shadow: none;

        border-color: #bbb;

        background-color: #ddd;

      }

      [type="checkbox"]:disabled:checked + label:after {

        color: #999;

      }

      [type="checkbox"]:disabled + label {

        color: #aaa;

      }

      /* accessibility */

      [type="checkbox"]:checked:focus + label:before,

      [type="checkbox"]:not(:checked):focus + label:before {

       outline: none !important;

      }



      /* hover style just for information */

      label:hover:before {

        //border: 1px solid #4778d9!important;

      }



      [type="checkbox"]:not(:checked) + label {

      color: #ddd;

      }

      .error {

        color: red !important;

      }

  </style>

</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="">

         

        <div class="">

          <div class="">

             

            <!-- /.card-header -->

            <div class="">



              <div class="row clearfix">

              <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">

                <div class="card">

                  <div class="card-header">

                    <h4>New Registeration</h4>

                    <p style="margin-top: 20px;">Serial Number :<span style="background-color: green;color: #fff;margin-left: 5px;padding-left: 10px;padding-right: 10px;"><?= $eproduct_no_row_direct_level_1; ?></span></p>

                  </div>

                  <div class="card-body" style="padding: 20px 10px !important;">

                    <form id="wizard_with_validation" method="post" action="eproduct_add_member.php?eproduct=<?= $page_eproduct_no; ?>" name="member_signup" enctype="multipart/form-data">

                      <h3>Account Information</h3>

                      <fieldset>

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

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



                                 <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Sponsor ID <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" name="sponsor_id" required id="search">

                                      <div id="receiver">

                                    

                                       </div>

                                      </div>

                                  </div>

                                   



                                   



                                  

                                  

                                  

                                



                                  <div class="form-group row">

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

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

                                      <input class="form-control" type="text" placeholder="Name" name="name" required style="text-transform: uppercase;">

                                      </div>

                                  </div>

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Mobile Number <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="10 Digit Active Mobile Number" name="mobile_number" required maxlength="10" minlength="10">

                                      </div>

                                  </div>

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Email<span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="email"  placeholder="Email" name="email" 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 value="Male">Male</option>

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

                                      </select>

                                      </div>

                                  </div>

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Door No, Street<span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Door No, Street" name="address_1" required>

                                      </div>

                                  </div>



                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Address<span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Address" name="address_2" required>

                                      </div>

                                  </div>

                                  

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">City/District <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="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<span style="color: red;">*</span></label>

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

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

                                        <option value="Andra Pradesh">Andra Pradesh</option>

                                        <option value="Arunachal Pradesh">Arunachal Pradesh</option>

                                        <option value="Assam">Assam</option>

                                        <option value="Bihar">Bihar</option>

                                        <option value="Chhattisgarh">Chhattisgarh</option>

                                        <option value="Goa">Goa</option>

                                        <option value="Gujarat">Gujarat</option>

                                        <option value="Haryana">Haryana</option>

                                        <option value="Himachal Pradesh">Himachal Pradesh</option>

                                        <option value="Jammu and Kashmir">Jammu and Kashmir</option>

                                        <option value="Jharkhand">Jharkhand</option>

                                        <option value="Karnataka">Karnataka</option>

                                        <option value="Kerala">Kerala</option>

                                        <option value="Madya Pradesh">Madya Pradesh</option>

                                        <option value="Maharashtra">Maharashtra</option>

                                        <option value="Manipur">Manipur</option>

                                        <option value="Meghalaya">Meghalaya</option>

                                        <option value="Mizoram">Mizoram</option>

                                        <option value="Nagaland">Nagaland</option>

                                        <option value="Orissa">Orissa</option>

                                        <option value="Punjab">Punjab</option>

                                        <option value="Rajasthan">Rajasthan</option>

                                        <option value="Sikkim">Sikkim</option>

                                        <option value="Tamil Nadu" selected>Tamil Nadu</option>

                                        <option value="Tripura">Tripura</option>

                                        <option value="Uttaranchal">Uttaranchal</option>

                                        <option value="Uttar Pradesh">Uttar Pradesh</option>

                                        <option value="West Bengal">West Bengal</option>                              

                                      </select>

                                      </div>

                                  </div>

                                  



                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Pincode <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Pincode" name="pincode" required>

                                      </div>

                                  </div>



                                  <div class="form-group row">

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

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

                                        <input id="test7" class="test7" name="addresssame" type="checkbox" value="1">

                                        <label for="test7" style="color: #000;">address same as courier address</label>

                                      </div>

                                  </div>



                                  





                                   <div class="form-group row hidediv">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Door No, Street <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Door No, Street" name="address_1_f" required>

                                      </div>

                                  </div>



                                  <div class="form-group row hidediv">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Address <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Address" name="address_2_f" required>

                                      </div>

                                  </div>

                                  

                                  <div class="form-group row hidediv">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">City/District <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="City/District" name="city_district_f" required>

                                      </div>

                                  </div>

                                  <div class="form-group row hidediv">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">State <span style="color: red;">*</span></label>

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

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

                                        <option value="Andra Pradesh">Andra Pradesh</option>

                                        <option value="Arunachal Pradesh">Arunachal Pradesh</option>

                                        <option value="Assam">Assam</option>

                                        <option value="Bihar">Bihar</option>

                                        <option value="Chhattisgarh">Chhattisgarh</option>

                                        <option value="Goa">Goa</option>

                                        <option value="Gujarat">Gujarat</option>

                                        <option value="Haryana">Haryana</option>

                                        <option value="Himachal Pradesh">Himachal Pradesh</option>

                                        <option value="Jammu and Kashmir">Jammu and Kashmir</option>

                                        <option value="Jharkhand">Jharkhand</option>

                                        <option value="Karnataka">Karnataka</option>

                                        <option value="Kerala">Kerala</option>

                                        <option value="Madya Pradesh">Madya Pradesh</option>

                                        <option value="Maharashtra">Maharashtra</option>

                                        <option value="Manipur">Manipur</option>

                                        <option value="Meghalaya">Meghalaya</option>

                                        <option value="Mizoram">Mizoram</option>

                                        <option value="Nagaland">Nagaland</option>

                                        <option value="Orissa">Orissa</option>

                                        <option value="Punjab">Punjab</option>

                                        <option value="Rajasthan">Rajasthan</option>

                                        <option value="Sikkim">Sikkim</option>

                                        <option value="Tamil Nadu" selected>Tamil Nadu</option>

                                        <option value="Tripura">Tripura</option>

                                        <option value="Uttaranchal">Uttaranchal</option>

                                        <option value="Uttar Pradesh">Uttar Pradesh</option>

                                        <option value="West Bengal">West Bengal</option>                              

                                      </select>

                                      </div>

                                  </div>

                                  



                                  <div class="form-group row hidediv">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Pincode <span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Pincode" name="pincode_f" required>

                                      </div>

                                  </div>

                                  

                                  

                                  

                                  

                                  



                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Bank Name<span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Bank Name" name="bank_name" required>

                                      </div>

                                  </div>

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Branch Name<span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Branch Name" name="branch_name" required>

                                      </div>

                                  </div>



                                  

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">Account Number<span style="color: red;">*</span></label>

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

                                      <input class="form-control" type="text" placeholder="Account Number" name="account_number" required>

                                      </div>

                                  </div>

                                  <div class="form-group row">

                                      <label for="example-text-input" class="col-sm-4 col-form-label">IFSC Code <span style="color: red;">*</span> </label>

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

                                      <input class="form-control" type="text" placeholder="IFSC Code" name="ifsc_code" required>

                                      </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" placeholder="PAN Card No" name="pan_card">

                                      </div>

                                  </div>

                         

                      </fieldset>

                      <h3>KYC Documents</h3>

                      <fieldset>

                            <div class="form-group row">



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



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



                                <input type="file" name="aadhaar_card_image">



                                </div>



                            </div>



                            <div class="form-group row">



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



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



                                <input type="file" name="pan_card_image">



                                </div>



                                



                            </div>



                            <div class="form-group row">



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



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



                                <input type="file" name="bank_proof_image">



                                </div>



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



                                <p class="control-label">



                                 (Crossed Cheque or Passbook)



                                </p>



                                </div>



                            </div>

                      </fieldset>

                      <h3>Password & Terms &amp; Conditions</h3>

                      <fieldset>

                        <div class="form-group row">

                            <label for="example-text-input" class="col-sm-4 col-form-label">Password <span style="color: red;">*</span></label>

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

                            <input class="form-control" type="password" placeholder="Password" name="password" required onkeyup = "Validate(this)" maxlength="6">

                            </div>

                        </div>



                        <input id="test6" name="acceptTerms" type="checkbox" required>

                        <label for="test6" style="color: #000;">I agree with the Terms and Conditions.</label>

                      </fieldset>

                    </form>

                  </div>

                </div>

              </div>

            </div>

               

              <!-- /.row -->

            </div>

            <!-- /.card-body -->

        </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>



  <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" data-backdrop="static" data-keyboard="false">

  <div class="modal-dialog">

    <div class="modal-content">

      

      <div class="modal-body"  style="height: 80vh;overflow-y: scroll;">

           



             <div class="privacy-container">

                        <div class="privacyContent">



                            <div class="d-flex justify-content-between privacy-head">

                                <div class="privacyHeader">

                                    <h4><b>CONSULTANT APPLICATION & AGREEMENT FORM</b></h4> 

                                </div>



                                



                            </div>



                            <div class="privacy-content-container">



                                <section>

                                     

                                    <p>This form is an application and an agreement to appoint an individual or partners as a self-employed sales agents / consultants for Rakchablooming FMCG Pvt Ltd</p>



                                    <p>Demand Draft shall be in favor of Rakchablooming FMCG Pvt Ltd payable at SALEM.  Cheque or Cash payment is not acceptable.</p>



                                    <p>Each applicant shall be atleast 18 years old at the time of this application</p>

                                    <p>Signing of this form initiates the application process and require approval of this application to become the sales agent / consultant of the company.</p>



                                    <p>Sales Agents / Consultants of the company are not permitted under any circumstances to market any product, which are not listed or approved by Rakchablooming</p>



                                    <p>Single Family members have to submit one application form to become Sales Agents / Consultants.</p>



                                    <p>The application form is non-transferable and non-refundable.</p>



                                    <p>In case of any complaint, the company representatives will work with all the affected parties in adherence with the company policies and guidelines to resolve the issue.  If there are any disputes, then the company representative’s decision will be final.  </p>



                                    <p>Any legal complaints are subject to the jurisdiction of Salem, Tamil Nadu.</p>



                                    <p>Unless explicitly approved by the company, any operating expenses including, but not limited to shipping, rental, packaging are shall be the responsibility of the sales agent / consultant.</p>

                                    <p>The sales commission and any other payments shall be made directly to the bank account of the sales agent / consultant.  If the monthly commission is lesser than 500 rupees , then it can be issued as a product voucher.</p>

                                    <p>By signing this form, I acknowledge that I have thoroughly read and shall comply with the terms and conditions mentioned on this application and / or in the company policies & guidelines documented on the company website.</p>

                                </section>



                                 



                                 





                                 





                            </div>



                        </div>

                    </div>

                                 

                                 



         

      </div>

      <div class="modal-footer">

        <button type="button" class="btn btn-primary pull-right" data-dismiss="modal">I AGREE</button>

        

      </div>

    </div>

  </div>

</div>

  <!-- General JS Scripts -->

   <script src="assets/js/app.min.js"></script>

  <!-- JS Libraies -->

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



  <script src="assets/bundles/jquery-validation/dist/jquery.validate.min.js"></script>

  <!-- JS Libraies -->

  <script src="assets/bundles/jquery-steps/jquery.steps.min.js"></script>

  <!-- Page Specific JS File -->

  <script src="assets/js/page/form-wizard.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 type="text/javascript">

    



    function fill(Value) {

     

       $('#search').val(Value); 

        

    }

     

    $(document).ready(function() {

       $("#search").keyup(function() {

        var name = $('#search').val();

       if (name == "") {

         

       }

       else {

         $.ajax({

         type: "POST",

         url: "search.php",

         data: {

             search: name

          },

          success: function(html) {

                $("#receiver").html(html).show();

                 }

                });

     

           }

     

       });

     

    });



    function Validate(txt) {

            txt.value = txt.value.replace(/[^a-zA-Z 0-9\n\r]+/g, '');

        }



         $(function () {

            $('#test6').on('change', function(e){

             if(e.target.checked){

               $('#myModal').modal('show');

             }

          });

            });



         $(function () {

 

        //show it when the checkbox is clicked

        $('#test7').on('click', function () {

            if ($(this).prop('checked')) {

                $('.hidediv').hide();

                

            } else {

                $('.hidediv').fadeIn();

            }

        });

    });

  </script>

</body>



</html>



<?php 



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



    function random_password( $length = 5 ) {

    $chars = "1234567890";

    $password = substr( str_shuffle( $chars ), 0, $length );

    return $password;

    }

    $user_id1 = random_password(5);



    $user_id = "RC3".$user_id1;

    $sponsor_id_1 = $_POST['sponsor_id'];

    $mobile_number = $_POST['mobile_number'];

    $pan_card = $_POST['pan_card'];

    $account_number = $_POST['account_number'];

    //user check

               $select_query_direct_level_user_repeat = "select * from member where user_id = '$user_id'";

         $run_direct_level_user_repeat = mysqli_query($con,$select_query_direct_level_user_repeat);

         $user_direct_level_user_repeat = mysqli_num_rows($run_direct_level_user_repeat);



         if ($user_direct_level_user_repeat > 0) {

              echo "<script>alert('User ID Already Exist...')</script>";

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

                   exit();

          }

    //user check



         //   $select_query_direct_level_mobile_number = "select * from member where mobile_number = '$mobile_number' AND mobile_number <> ''";

         // $run_direct_level_mobile_number = mysqli_query($con,$select_query_direct_level_mobile_number);

         // $user_direct_level_mobile_number = mysqli_num_rows($run_direct_level_mobile_number);



         // if ($user_direct_level_mobile_number > 0) {

         //      echo "<script>alert('Mobile Number already Registered, please enter different Mobile number...')</script>";

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

         //           exit();

         //  }

    

   



       $select_query_direct_user_get_id = "select * from member where user_id = '$sponsor_id_1'";

       $run_direct_user_get_id = mysqli_query($con,$select_query_direct_user_get_id); 

       $check_sposor_id = mysqli_num_rows($run_direct_user_get_id);                                     

       while ($row_direct_user_get_id = mysqli_fetch_array($run_direct_user_get_id)) {

        

        $sponsor_id = $row_direct_user_get_id['member_no'];

        }



        if ($check_sposor_id == 0) {



          echo "<script>alert('SPONSOR ID DOES NOT EXIST...')</script>";

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

                   exit();

           

        }



       

       $eproduct = $_POST['eproduct'];

     



       $select_query_direct_level_1 = "select * from eproduct_details_roi where receiver_no = '$sponsor_id' AND eproduct_no='$eproduct'";

       $run_direct_level_1 = mysqli_query($con,$select_query_direct_level_1);                                 

       while ($row_direct_level_1 = mysqli_fetch_array($run_direct_level_1)) {

        $eproduct_id_row_direct_level_1 = $row_direct_level_1['eproduct_id'];

        $issue_date_row_direct_level_1 = $row_direct_level_1['issue_date'];

        $sender_no_row_direct_level_1 = $row_direct_level_1['sender_no'];

        $receiver_no_row_direct_level_1 = $row_direct_level_1['receiver_no'];

        $eproduct_no_row_direct_level_1 = $row_direct_level_1['eproduct_no'];

        $member_no_row_direct_level_1 = $row_direct_level_1['member_no'];

        $pin_value_row_direct_level_1 = $row_direct_level_1['pin_value'];

        }

       

       

        $tree_amount = 16;



        $addresssame = $_POST['addresssame'];



       if ($addresssame == 1) {



         $address_1_f = $_POST['address_1'];

         $address_2_f = $_POST['address_2']; 

         $city_district_f = $_POST['city_district'];

         $state_f = $_POST['state']; 

         $pincode_f = $_POST['pincode'];

          

       }

       else {



         $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'];



       }





       $title = "";

       $dob = "";

       $name = $_POST['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 = "";

       $nominee_relationship = "";

       $account_name = $_POST['name'];

       $account_number = $_POST['account_number'];

       $ifsc_code = $_POST['ifsc_code'];

       $bank_name = $_POST['bank_name'];

       $branch_name = $_POST['branch_name'];

       



       //count user

                $select_query_count = "select * from member";

                $run_count = mysqli_query($con,$select_query_count);

                $user_count = mysqli_num_rows($run_count);



                $nominee_name_id1 = $user_count + 1;

                $member_no_1 = sprintf('%03d',$nominee_name_id1);

                $member_no = $member_no_1;                

       // count user

                $aadhaar_card_image_1 = $_FILES['aadhaar_card_image'] ['name'];



               $aadhaar_card_image_tmp = $_FILES['aadhaar_card_image'] ['tmp_name'];







               $pan_card_image_1 = $_FILES['pan_card_image'] ['name'];



               $pan_card_image_tmp = $_FILES['pan_card_image'] ['tmp_name'];







               $bank_proof_image_1 = $_FILES['bank_proof_image'] ['name'];



               $bank_proof_image_tmp = $_FILES['bank_proof_image'] ['tmp_name'];







                 if ($pan_card_image_1 != '') {



                 



                 $pan_card_image = $member_no."_".$pan_card_image_1;



                 $pan_card_status = '2';



                 



               



                   }



                   else {



                       



                       $pan_card_image = "";



                       $pan_card_status = '1';



                       







                   }



               



             if ($aadhaar_card_image_1 != '') {



                 



                 $aadhaar_status ='2';



                 $aadhaar_card_image = $member_no."_".$aadhaar_card_image_1;



                 $document_status = '2';                 



                 



               }



               else {



                 $aadhaar_status ='1';



                 $aadhaar_card_image = '';



                 







               }



               if ($bank_proof_image_1 != '') {                                              



                 $bank_proof_status = '2';



                 $bank_proof_image = $member_no."_".$bank_proof_image_1;



                 



               }



               else {                    



                    $bank_proof_status = '1';



                    $bank_proof_image = '';                







               }







               if ($pan_card_image_1 != '' || $aadhaar_card_image_1 !='' || $bank_proof_image_1 != '') {



                 $document_status = '2';



               }



               else {



                 $document_status = '1';



               }

                 

               

             

               

               

               $date_of_join = date('Y-m-d');

               $year = date('Y');

               $month = date('m');

                $date = date("Y-m-d H:i:s");

       

               $password = $_POST['password'];

               $level_status = '1';

               $member_fess = '300';

               $activity_level = '0';

               $activity_month ='0';



               



       //count user

                $select_query_count_epin = "select * from member where epin='$eproduct_no_row_direct_level_1'";

                $run_count_epin = mysqli_query($con,$select_query_count_epin);

                $user_count_epin = mysqli_num_rows($run_count_epin);



                if($user_count_epin > 0){



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

                   exit();

                   }



       if($name==''){

            

            echo "<script>alert('some one feilds is empty please fill')</script>";

            exit();

            }



            else {

            

                  move_uploaded_file($aadhaar_card_image_tmp, "../aadhaar/$aadhaar_card_image");



                   move_uploaded_file($pan_card_image_tmp, "../pan/$pan_card_image");



                   move_uploaded_file($bank_proof_image_tmp, "../bank/$bank_proof_image"); 

                  

                 $insert_query = "insert into member(title, dob, name, gender, address_1, address_2, town_area, city_district, state, country, pincode, mobile_number, email, aadhaar_card, pan_card, nominee_name, nominee_relationship, account_name, account_number, ifsc_code, bank_name, branch_name, member_no, password, aadhaar_card_image, pan_card_image, bank_proof_image, document_status, date_of_join, level_status, aadhaar_status, pan_card_status, bank_proof_status, epin, user_id, member_category, up, address_1_f, address_2_f, city_district_f, state_f, pincode_f, net_date, mobile_number_f) values('$title', '$dob', '$name', '$gender', '$address_1', '$address_2', '$town_area', '$city_district', '$state', '$country', '$pincode', '$mobile_number', '$email', '$aadhaar_card', '$pan_card', '$nominee_name', '$nominee_relationship', '$account_name', '$account_number', '$ifsc_code', '$bank_name', '$branch_name', '$member_no', '$password', '$aadhaar_card_image', '$pan_card_image', '$bank_proof_image', '$document_status', '$date_of_join', '$level_status', '$aadhaar_status', '$pan_card_status', '$bank_proof_status', '$eproduct_no_row_direct_level_1', '$user_id', '2', '1', '$address_1_f', '$address_2_f', '$city_district_f', '$state_f', '$pincode_f', '$date', '$mobile_number')";

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

                        $_SESSION['create_member'] = $member_no;

                        mysqli_query($con,"update eproduct_details_roi set eproduct_status='used', member_no='$member_no' where eproduct_id = '$eproduct_id_row_direct_level_1'");

                        

                        

                       mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '000')");

                       mysqli_query($con,"insert into product_member(member_no, used_no) values('$member_no', '000')");

                       





                       





                        $select_query_register = "select * from roi_tree where member_no='$sponsor_id' ORDER BY tree_id ASC LIMIT 1";

                        $run_register = mysqli_query($con,$select_query_register);                       

                        while ($row_register = mysqli_fetch_array($run_register)) {                       

                        $tree_id_register = $row_register['tree_id'];

                        $group_number_register = $row_register['group_number'];

                        $member_no_register = $row_register['member_no'];

                        $sponsor_no_register = $row_register['sponsor_no'];

                        

                        $relation_ship_no_register = $row_register['relation_ship_no'];

                        $x_position_register = $row_register['x_position']+1;

                        $y_position_register = $row_register['y_position'];

                        }

                        

                        $relation_ship_no = $relation_ship_no_register."".$member_no;

                        $x_position_next = $x_position_register;

                        $group_number_left_give = $group_number_register;

                        $sponsor_no = $sponsor_id;



                        $select_query_y = "select * from roi_tree where group_number = '$group_number_left_give' AND sponsor_no = '$member_no_register' AND x_position = '$x_position_register' AND relation_ship_no LIKE '%{$relation_ship_no_register}%'";

                        $run_y = mysqli_query($con,$select_query_y);

                        $user_y = mysqli_num_rows($run_y);

                        $y_position_1 = $user_y + 1;





                         mysqli_query($con, "insert into roi_tree(group_number, member_no, sponsor_no, relation_ship_no, x_position, y_position, date, user_id, year, month, roi_amount, status, network_amount) values('$group_number_left_give', '$member_no', '$sponsor_no', '$relation_ship_no', '$x_position_next', '$y_position_1', '$date_of_join', '$user_id', '$year', '$month', '$tree_amount', '1', '$tree_amount')");

                        

                                                                               

                        $message = "Congratulation You are successfully Registered in RAKCHA. Your Login User ID : ".$user_id." & Password :".$password.". Website: www.rakcha.in";



                        $message = urlencode($message);

                        $url = 'http://sms.messageindia.in/sendSMS?username=th&message='.$message.'&sendername=RAKCHA&smstype=TRANS&numbers='.$mobile_number.'&apikey=25679508-87af-4b55-bb22-873e006ef48a';

                        $xml = file_get_contents($url);

                        echo $xml;

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

                                exit(); 



                                

                                









                                        }  

                                }





                        

                

                

            

     



     



   



 }//end of 1st if condition



 ?>

  <?php }else{echo "<script>window.open('eproduct_details.php','_self')</script>";} }else{echo "<script>window.open('eproduct_details.php','_self')</script>";} } } ?>