1#@!#!123s

: / home5 / rakcha / public_html / user /
Filename : eproduct_transfer.php
back
<?php 

session_start();

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

            header("location: eproduct_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'];

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

        $elite_board = $row['elite_board'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];



        $member_fess = $row['member_fess'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $date_of_join =$row['date_of_join'];    

          

          $select_query_direct_level = "select * from eproduct_details_roi where receiver_no = '$member_no' AND eproduct_status <> 'used'";

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

          $numrows_m_2 = mysqli_num_rows($run_direct_level);



          







  ?>

  <!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. -->

	<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><a href="eproduct_details.php"><i class="fa fa-circle-o"></i> NEW JOIN / VIEW KIT </a></li>

            <li class="active"><a href="eproduct_transfer.php"><i class="fa fa-circle"></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">E-KIT TRANSFER</li>

      </ol>

    </section>

  

  <section class="content">

    

      <div class="row">

        <div class="col-xl-3"></div>

        <div class="col-xl-6">

          <div class="box box-default">

            <div class="box-header with-border">

              <h3 class="box-title">E-KIT TRANSFER</h3>

            </div>

            <!-- /.box-header -->

            <div class="box-body">

              <div class="row">

                

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

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

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

                      <div class="form-group row">

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

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

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

                            </div>

                        </div>



                        <div class="form-group row">

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

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

                            <input class="form-control" type="number" name="qty" required>

                            </div>

                        </div>

                        <div class="form-group row">

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

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

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

                            

                            </div>

                        </div>



                        



                        <div class="form-group row">

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

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

                              

                            </div>

                        </div>



                      

                      <div class="box-footer">

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

                      </div>

                  </form>

            

                </div>

                



                <!-- /.col -->

              </div>

              <!-- /.row -->

            </div>

            <!-- /.box-body -->

        </div>

        </div>

        <div class="col-xl-3"></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>

	

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

  

  // function fetch_select(val)

  //           {

  //            $.ajax({

  //            type: 'post',

  //            url: 'fetch_data.php',

  //            data: {

  //             get_option:val

  //            },

  //            success: function (response) {

  //             document.getElementById("receiver").innerHTML=response; 

  //            }

  //            });

  //           }





 

function fill(Value) {

 

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

   $('#receiver').hide(); 

}

 

$(document).ready(function() {

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

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

   if (name == "") {

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

   }

   else {

     $.ajax({

     type: "POST",

     url: "search.php",

     data: {

         search: name

      },

      success: function(html) {

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

             }

            });

 

       }

 

   });

 

});

</script>



</body>



</html>



<?php 

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

     $sender_no = $_POST['sender_no'];

     $user_id = $_POST['receiver_id'];

   

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

       $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)) {

        

        $receiver_id = $row_direct_user_get_id['member_no'];

        }





        



        if ($check_sposor_id == 0) {



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

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

                   exit();

           

        }

   

     $qty = $_POST['qty'];     

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

    $available_qty = $_POST['available_qty'];

     if ($qty <= $available_qty) {       





     $select_query_direct_level = "select * from eproduct_details_roi where receiver_no = '$sender_no' AND eproduct_status <>'used' ORDER BY eproduct_id ASC limit $qty";

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

     while ($row_direct_level = mysqli_fetch_array($run_direct_level)) {                                 

      $eproduct_id_row_direct_level = $row_direct_level['eproduct_id'];

      $issue_date_row_direct_level = $row_direct_level['issue_date'];

      $sender_no_row_direct_level = $row_direct_level['sender_no'];

      $receiver_no_row_direct_level = $row_direct_level['receiver_no'];

      $eproduct_no_row_direct_level = $row_direct_level['eproduct_no'];

      



      mysqli_query($con, "update eproduct_details_roi set sender_no='$sender_no', receiver_no='$receiver_id', issue_date='$date' where eproduct_id='$eproduct_id_row_direct_level'");



      



     }

     mysqli_query($con, "insert into eproduct_history_roi(sender_no, receiver_no, qty, date, eproduct_no) values('$sender_no', '$receiver_id', '$qty', '$date', '$eproduct_no_row_direct_level')");



     echo "<script>alert('Epin has been successfully Transfer...')</script>";

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



     }



     else{

      echo "<script>alert('Not Enought Epin...')</script>";

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

     }

     

   }

?>

  <?php  } }  ?>