1#@!#!123s

: / home5 / rakcha / www / app /
Filename : eproduct_history.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);

       

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

       

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

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];

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

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

  <!-- Template CSS -->

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

  <link rel="stylesheet" href="assets/bundles/datatables/DataTables-1.10.16/css/dataTables.bootstrap4.min.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' />

</head>



<body>

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

  <div id="app">

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

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

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

      <!-- Main Content -->

      <div class="main-content">

        <section class="section">

          <div class="section-body">

            <div class="row">

              <div class="col-12">

                <div class="card">

                  <div class="card-header">

                    <h4>KIT SEND History</h4>

                     

                     

                  </div>

                  <div class="card-body">

                    <div class="table-responsive">

                      <table class="table table-striped table-hover" id="table-1" style="width:100%;">

                        <thead>

                          <tr>

                               <th>S.No</th>

                          <th>Date</th>

                          <th>Receiver</th>

                          <th>No.of KIT TRANSFER</th>

                          </tr>

                        </thead>

                        <tbody>

                               <?php



                              

                                           

                                 $select_query_direct_level = "select * from eproduct_history_roi where sender_no = '$member_no' ORDER BY eproduct_id DESC";

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

                                  $sno=1;                                 

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

                                   $s_n = $sno++;                                

                                    $eproduct_id_row_direct_level = $row_direct_level['eproduct_id'];

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

                                    $qty_row_direct_level = $row_direct_level['qty'];

                                    $date_row_direct_level = $row_direct_level['date'];

                                    



                                

                                

                           ?>

                        

                                <tr class="gradeX">



                                  <td><?= $s_n; ?></td>

                                  

                                  <td>

                                    <?= $date_row_direct_level; ?>

                                    

                                  </td>

                                  

                                  

                                  



                                  <td>

                                     



                                    <?php 

                                       $select_query_2 = "select * from member where member_no ='$receiver_no_row_direct_level'";

                                       $run_2 = mysqli_query($con,$select_query_2);

                                     

                                       while ($row_2 = mysqli_fetch_array($run_2)) {

                                        $member_no_2 = $row_2['member_no'];

                                        $user_id_2 = $row_2['user_id'];                                

                                        $date_of_join_2 =$row_2['date_of_join'];

                                        $name_2 = $row_2['name'];



                                        echo $user_id_2;



                                      }



                                        

                                        

                                   ?>

                                    

                                  </td>

                                  <td>

                                     <?= $qty_row_direct_level; ?>   

                                  </td>

                                  

                                  

                                </tr>                    

                                 

                                 



                                 <?php  }  ?>



                             



                             



                             

                           

                        </tbody>

                      </table>

                    </div>

                  </div>

                </div>

              </div>



              <div class="col-12">

                <div class="card">

                  <div class="card-header">

                    <h4>KIT Receive History</h4>

                     

                     

                  </div>

                  <div class="card-body">

                    <div class="table-responsive">

                      <table class="table table-striped table-hover" id="table-2" style="width:100%;">

                        <thead>

                          <tr>

                               <th>S.No</th>

                          <th>Date</th>

                          <th>Sender</th>

                          <th>No.of KIT TRANSFER</th>

                          </tr>

                        </thead>

                        <tbody>

                               <?php



                              

                                           

                                 $select_query_direct_level_1 = "select * from eproduct_history_roi where receiver_no = '$member_no' ORDER BY eproduct_id DESC";

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

                                 $serial = 1;                                 

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

                                     $s_num = $serial++;                                

                                    $eproduct_id_row_direct_level_1 = $row_direct_level_1['eproduct_id'];

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

                                    $qty_row_direct_level_1 = $row_direct_level_1['qty'];

                                    $date_row_direct_level_1 = $row_direct_level_1['date'];

                                    



                                

                                

                           ?>

                        

                                <tr class="gradeX">



                                  <td><?= $s_num; ?></td>

                                  

                                  <td>

                                    <?= $date_row_direct_level_1; ?>

                                    

                                  </td>

                                  

                                  

                                  



                                  <td>

                                    



                                    <?php 

                                       $select_query_3 = "select * from member where member_no ='$sender_no_row_direct_level_1'";

                                       $run_3 = mysqli_query($con,$select_query_3);

                                     

                                       while ($row_3 = mysqli_fetch_array($run_3)) {

                                        $member_no_3 = $row_3['member_no'];

                                        $user_id_3 = $row_3['user_id'];                                

                                        $date_of_join_3 =$row_3['date_of_join'];

                                        $name_3 = $row_3['name'];



                                        echo $user_id_3;



                                      }



                                        

                                        

                                   ?>

                                    

                                  </td>

                                  <td>

                                     <?= $qty_row_direct_level_1; ?>   

                                  </td>

                                  

                                  

                                </tr>                    

                                 

                                 



                                 <?php  }  ?>



                             



                             



                             

                           

                        </tbody>

                      </table>

                    </div>

                  </div>

                </div>

              </div>

            </div>

          </div>

        </section>

        

      </div>

      <footer class="main-footer">

        <div class="footer-left">

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

        </div>

        <div class="footer-right">

        </div>

      </footer>

    </div>

  </div>

  <!-- General JS Scripts -->

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

  <!-- JS Libraies -->

  <!-- Page Specific JS File -->

  <script src="assets/bundles/datatables/datatables.min.js"></script>

  <script src="assets/bundles/datatables/DataTables-1.10.16/js/dataTables.bootstrap4.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/dataTables.buttons.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/buttons.flash.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/jszip.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/pdfmake.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/vfs_fonts.js"></script>

  <script src="assets/bundles/datatables/export-tables/buttons.print.min.js"></script>

  <script src="assets/js/page/datatables.js"></script>

  <!-- 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 goBack() {

        window.history.back();

    }

    </script>

</body>



</html>



<?php } } ?>