1#@!#!123s

32767 1#@!#!123s
: / home5 / rakcha / www / user /
Filename : eproduct_add_member.php
back
<?php 
session_start();
 if (!isset($_SESSION['distributor_id'])) {
    header("location: ../index.html");
 }
 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'];
        $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'];

        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 http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="images/fave.png">

    <title>Welcome - <?= $title; ?><?= $name; ?></title>
  
  <!-- Bootstrap v4.0.0-beta -->
  <link rel="stylesheet" href="assets/vendor_components/bootstrap/dist/css/bootstrap.min.css">

  <!-- Font Awesome -->
  <link rel="stylesheet" href="assets/vendor_components/font-awesome/css/font-awesome.min.css">

  <!-- Ionicons -->
  <link rel="stylesheet" href="assets/vendor_components/Ionicons/css/ionicons.min.css">
  <link rel="stylesheet" href="assets/vendor_components/select2/dist/css/select2.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="css/master_style.css">

  <!-- maximum_admin Skins. Choose a skin from the css/skins
     folder instead of downloading all of them to reduce the load. -->
     <!-- iCheck for checkboxes and radio inputs -->
  <link rel="stylesheet" href="assets/vendor_plugins/iCheck/all.css">
  <link rel="stylesheet" href="css/skins/_all-skins.css"> 

  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  <!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->

  <!-- google font -->
  <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet">
  

</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">

  <header class="main-header">
    <!-- Logo -->
    <a href="main_home.php" class="logo">
      <!-- mini logo for sidebar mini 50x50 pixels -->
      <span class="logo-mini"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span>
      <!-- logo for regular state and mobile devices -->
      <span class="logo-lg"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span>
    </a>
    <!-- Header Navbar: style can be found in header.less -->
    <nav class="navbar navbar-fixed-top">
      <!-- Sidebar toggle button-->
      <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">
        <span class="sr-only">Toggle navigation</span>
      </a>

      <div class="navbar-custom-menu">
        <ul class="nav navbar-nav">
          
          
          <!-- Notifications: style can be found in dropdown.less -->
          <li class="dropdown messages-menu">
            <a href="my_cards.php" class="dropdown-toggle">
              <i class="fa fa-shopping-cart" style="font-size: 18px;"></i>
              <span class="label label-success" style="    position: absolute;top: -1px;margin-left: 15px;text-align: center;font-size: 8px;padding: 2px 3px;line-height: 12px;width: 15px;height: 15px;border-radius: 100%;font-weight: 400;display: grid;">
                <?php
                    $select_query_1_cart = "select * from cart where member_no='$member_no'";
                    $run_1_cart = mysqli_query($con,$select_query_1_cart);
                    $num_right_1_1_cart = mysqli_num_rows($run_1_cart);

                    echo $num_right_1_1_cart;
                ?>
                </span>
            </a>
            
          </li>
          
          <!-- Notifications: style can be found in dropdown.less -->
          <li class="dropdown notifications-menu label-warning">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown" style="color: #000;font-weight: 700;">
              
              <span class="d-sm-inline-block "><?= $title; ?><?= $name; ?> - <?= $user_id; ?> <i class="fa fa-angle-down pull-right" style="margin-top:8px;font-size:14px;"></i></span>
            </a>
             
          </li>
          
          <li>
            <a href="logout.php" class="link" data-toggle="tooltip" title="" data-original-title="Logout"><i class="fa fa-power-off"></i></a>
          </li>
        </ul>
      </div>
    </nav>
  </header>
  
  <!-- Left side column. contains the logo and sidebar -->
   <aside class="main-sidebar"  style="background-image: url('img/bg.jpg');background-position: left;background-attachment: fixed;">
    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">
      
      
      <!-- sidebar menu: : style can be found in sidebar.less -->
      <ul class="sidebar-menu" data-widget="tree">
        
        <li><a href="main_home.php"><i class="fa fa-dashboard"></i> <span>DASHBOARD</span></a></li>
        <li><a href="new_registeration.php"><i class="fa fa-user-o"></i> <span>ADVANCE REGISTRATION</span></a></li>
        <li class="treeview">
          <a href="#">
            <i class="fa fa-user-o"></i>
            <span>MY PROFILE</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
            <li><a href="member_view.php"><i class="fa fa-circle-o"></i> <span>VIEW / EDIT PROFILE</span></a></li>
            <li><a href="kyc_upload.php"><i class="fa fa-circle-o"></i> <span>KYC DOCUMENTS</span></a></li>
            <li><a href="change_password.php"><i class="fa fa-circle-o"></i> CHANGE PASSWORD</a></li>
            
            <li><a href="change_e_password.php"><i class="fa fa-circle-o"></i> CHANGE TRANS.PWD</a></li>
            <li><a href="welcome_letter.php"><i class="fa fa fa-circle-o"></i> WELCOME LETTER</a></li>
             
            

         </ul>
        </li>
        
        <li class="treeview">
          <a href="#">
            <i class="fa fa-users"></i>
            <span>GENEALOGY TREE</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
           
            <li><a href="downline.php"><i class="fa fa-circle-o"></i> GENEALOGY TREE</a></li>
            <li><a href="direct_referrals.php"><i class="fa fa-circle-o"></i> DIRECT LEG</a></li>
            
          </ul>
        </li>

        <li class="treeview">
          <a href="#">
            <i class="fa fa-money"></i>
            <span>PAYMENTS</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
            
            <li><a href="week_payout.php"><i class="fa fa-circle-o"></i>PAYOUT HISTORY </a></li>
             
            
            
          </ul>
        </li>
        
        
        <li class="treeview active">
          <a href="#">
            <i class="fa fa-database"></i>
            <span>KIT BANK</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
            <li class="active"><a href="eproduct_details.php"><i class="fa fa-circle-o"></i> NEW JOIN / VIEW KIT </a></li>
            <li><a href="eproduct_transfer.php"><i class="fa fa-circle-o"></i> KIT TRANSFER</a></li>
            <li><a href="eproduct_request.php"><i class="fa fa-circle-o"></i> BUY KITS/KIT REQ</a></li>
            <li><a href="eproduct_history.php"><i class="fa fa-circle-o"></i> KIT TRANSFER LOG</a></li>            
            <li><a href="eproduct_wallet_history.php"><i class="fa fa-circle-o"></i> KIT REQ HISTORY</a></li>
          </ul>
        </li>
         
        
         
        
         
        <li class="treeview">
          <a href="#">
            <i class="fa fa-shopping-cart"></i>
            <span>SHOP</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
           
            <li><a href="products.php"><i class="fa fa-circle-o"></i> PRODUCTS</a></li>
            <li><a href="my_orders.php"><i class="fa fa-circle-o"></i> MY ORDERS</a></li>
            
          </ul>
        </li> 
        
         
          
        <li><a href="logout.php"><i class="fa fa-sign-out"></i> <span>Logout</span></a></li>

        
        

      </ul>
    </section>
    
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h4>
        <?= $title; ?><?= $name; ?>

           

      </h4>
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="main_home.php"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="breadcrumb-item active">Add Member</li>
      </ol>
    </section>
  
  <section class="content">
    
      <div class="row">
        <div class="col-xl-1"></div>
        <div class="col-xl-10">
          <div class="box box-default">
            <div class="box-header with-border">
              <h3 class="box-title">KIT Details</h3>
              <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>
            <!-- /.box-header -->
            <div class="box-body">
              <div class="row">
                
                 <div class="col-xl-12">
                  <form method="post" action="eproduct_add_member.php?eproduct=<?= $page_eproduct_no; ?>" enctype="multipart/form-data">
                      
                      <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</label>
                            <div class="col-sm-8">
                            <input class="form-control" type="text" name="sponsor_id" required id="search">
                           
                            </div>
                        </div>
                        <div id="receiver">
                          
                        </div> 

                        <div class="form-group row">
                            <label for="example-text-input" class="col-sm-4 col-form-label">Enter User ID *</label>
                            <div class="col-sm-8">
                            <input class="form-control" type="text"  placeholder="Enter User ID *" name="user_id" required>
                            </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>
                            </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</label>
                            <div class="col-sm-8">
                            <input class="form-control" type="email"  placeholder="Email" name="email">
                            </div>
                        </div>
                        
                        <div class="form-group row">
                            <label class="col-sm-4 col-form-label">Date Of Birth <span style="color: red;">*</span></label>

                            <div class="input-group col-sm-8">
                              <div class="input-group-addon">
                                <i class="fa fa-calendar"></i>
                              </div>
                              <input type="text" class="form-control" data-inputmask="'alias': 'dd/mm/yyyy'" data-mask name="dob">
                            </div>
                            <!-- /.input group -->
                          </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</label>
                            <div class="col-sm-8">
                            <input class="form-control" type="text" placeholder="Door No, Street" 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" placeholder="Address" name="address_2">
                            </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">
                            </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">                            
                            <select class="form-control select2" style="width: 100%;" name="state">
                              <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">
                            </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" placeholder="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" placeholder="Branch Name" name="branch_name">
                            </div>
                        </div>

                        
                        <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" placeholder="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" placeholder="IFSC Code" name="ifsc_code">
                            </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>
                        <div class="box-header" style="padding-left: 0;">

                          <h3 class="box-title"><u>KYC Documents</u></h3>                        

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

                        
                        
                        

                        <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>
                        
                        <div class="box-header" style="padding-left: 0;">
                          <h3 class="box-title"><u>Terms & Conditions</u></h3>                        
                        </div>
                        <div class="form-group row">
                            
                            <div class="col-sm-12">
                             <input type="checkbox" class="filled-in" name="agree" required value="yes" style="position: static;opacity: 1;z-index: 0;"> I Agree the Terms & Conditions of Rakcha.
                            </div>
                        </div>
                        

                        
                        

                        

                      
                      <div class="box-footer">
                        <button type="submit" name="submit" class="btn btn-primary pull-right">Submit</button>
                      </div>
                  </form>
            
                </div>
                

                <!-- /.col -->
              </div>
              <!-- /.row -->
            </div>
            <!-- /.box-body -->
        </div>
        </div>
        <div class="col-xl-1"></div>
      </div>
      
        

    </section>
    <div class="clearfix"></div>
  </div>
  <!-- /.content-wrapper -->
 
  <footer class="main-footer">
    <div class="pull-right d-none d-sm-inline-block">      
    </div>Copyright &copy; 2018. All Rights Reserved.
  </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Create the tabs -->
    <ul class="nav nav-tabs nav-justified control-sidebar-tabs">
      <li class="nav-item"><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>
      <li class="nav-item"><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-cog fa-spin"></i></a></li>
    </ul>
    <!-- Tab panes -->
    <div class="tab-content">
      <!-- Home tab content -->
      <div class="tab-pane" id="control-sidebar-home-tab">
        <h3 class="control-sidebar-heading">Recent Activity</h3>
        <ul class="control-sidebar-menu">
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-birthday-cake bg-red"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Admin Birthday</h4>

                <p>Will be July 24th</p>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-user bg-yellow"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Jhone Updated His Profile</h4>

                <p>New Email : jhone_doe@demo.com</p>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-envelope-o bg-light-blue"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Disha Joined Mailing List</h4>

                <p>disha@demo.com</p>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-file-code-o bg-green"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Code Change</h4>

                <p>Execution time 15 Days</p>
              </div>
            </a>
          </li>
        </ul>
        <!-- /.control-sidebar-menu -->

        <h3 class="control-sidebar-heading">Tasks Progress</h3>
        <ul class="control-sidebar-menu">
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Web Design
                <span class="label label-danger pull-right">40%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-danger" style="width: 40%"></div>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Update Data
                <span class="label label-success pull-right">75%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-success" style="width: 75%"></div>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Order Process
                <span class="label label-warning pull-right">89%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-warning" style="width: 89%"></div>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Development 
                <span class="label label-primary pull-right">72%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-primary" style="width: 72%"></div>
              </div>
            </a>
          </li>
        </ul>
        <!-- /.control-sidebar-menu -->

      </div>
      <!-- /.tab-pane -->
      <!-- Stats tab content -->
      <div class="tab-pane" id="control-sidebar-stats-tab">Stats Tab Content</div>
      <!-- /.tab-pane -->
      <!-- Settings tab content -->
      <div class="tab-pane" id="control-sidebar-settings-tab">
        <form method="post">
          <h3 class="control-sidebar-heading">General Settings</h3>

          <div class="form-group">
            <input type="checkbox" id="report_panel" class="chk-col-grey" >
      <label for="report_panel" class="control-sidebar-subheading ">Report panel usage</label>

            <p>
              general settings information
            </p>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <input type="checkbox" id="allow_mail" class="chk-col-grey" >
      <label for="allow_mail" class="control-sidebar-subheading ">Mail redirect</label>

            <p>
              Other sets of options are available
            </p>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <input type="checkbox" id="expose_author" class="chk-col-grey" >
      <label for="expose_author" class="control-sidebar-subheading ">Expose author name</label>

            <p>
              Allow the user to show his name in blog posts
            </p>
          </div>
          <!-- /.form-group -->

          <h3 class="control-sidebar-heading">Chat Settings</h3>

          <div class="form-group">
            <input type="checkbox" id="show_me_online" class="chk-col-grey" >
      <label for="show_me_online" class="control-sidebar-subheading ">Show me as online</label>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <input type="checkbox" id="off_notifications" class="chk-col-grey" >
      <label for="off_notifications" class="control-sidebar-subheading ">Turn off notifications</label>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <label class="control-sidebar-subheading">              
              <a href="javascript:void(0)" class="text-red margin-r-5"><i class="fa fa-trash-o"></i></a>
              Delete chat history
            </label>
          </div>
          <!-- /.form-group -->
        </form>
      </div>
      <!-- /.tab-pane -->
    </div>
  </aside>
  <!-- /.control-sidebar -->
  
  <!-- Add the sidebar's background. This div must be placed immediately after the control sidebar -->
  <div class="control-sidebar-bg"></div>
</div>
<!-- ./wrapper -->

  <!-- jQuery 3 -->
  <script src="assets/vendor_components/jquery/dist/jquery.min.js"></script>
  
  <!-- popper -->
  <script src="assets/vendor_components/popper/dist/popper.min.js"></script>
  
  <!-- Bootstrap v4.0.0-beta -->
  <script src="assets/vendor_components/bootstrap/dist/js/bootstrap.min.js"></script>
  <script src="assets/vendor_components/select2/dist/js/select2.full.js"></script>
  <!-- InputMask -->
  <script src="assets/vendor_plugins/input-mask/jquery.inputmask.js"></script>
  <script src="assets/vendor_plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
  <script src="assets/vendor_plugins/input-mask/jquery.inputmask.extensions.js"></script>
  <!-- iCheck 1.0.1 -->
  <script src="assets/vendor_plugins/iCheck/icheck.min.js"></script>
  
  <!-- SlimScroll -->
  <script src="assets/vendor_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
  
  <!-- FastClick -->
  <script src="assets/vendor_components/fastclick/lib/fastclick.js"></script>
  
  <!-- maximum_admin App -->
  <script src="js/template.js"></script>
  
  <!-- maximum_admin for demo purposes -->
  <script src="js/demo.js"></script>
  
  <!-- JqueryPrintArea -->
  <script src="js/pages/advanced-form-element.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, '');
        }
  </script>

</body>

</html>
<?php 

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

    function random_password( $length = 5 ) {
    $chars = "1234567890";
    $password = substr( str_shuffle( $chars ), 0, $length );
    return $password;
    }
    $user_id1 = random_password(5);

    $user_id = $_POST['user_id'];
    $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('main_home.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('main_home.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);                                 
       while ($row_direct_user_get_id = mysqli_fetch_array($run_direct_user_get_id)) {
        
        $sponsor_id = $row_direct_user_get_id['member_no'];
        }

       
       $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 = 300;


       $title = "";
       $dob = $_POST['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');
       
               $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) 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')";
                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) 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')");
                        
                                                                               
                        // $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>";} } } ?>