1#@!#!123s

: / home5 / rakcha / www / app /
Filename : eproduct_request.php
back
<?php error_reporting(0); ?>

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

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

        $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_main = "select * from roi_tree where member_no='$member_no' ORDER BY tree_id ASC limit 1";

        $run_main = mysqli_query($con,$select_query_main);

         

         while ($row_main = mysqli_fetch_array($run_main)) {

          $tree_id_main = $row_main['tree_id'];                                    

          $group_number_main = $row_main['group_number'];

          $member_no_main = $row_main['member_no'];

          $user_id_main = $row_main['user_id'];

          $sponsor_no_main = $row_main['sponsor_no'];

          $relation_ship_no_main = $row_main['relation_ship_no'];

          $level_no_main = $row_main['level_no'];

          $x_position_main = $row_main['x_position']+1;

          $y_position_main = $row_main['y_position'];

          }



          $select_query_main_2 = "select * from roi_tree where sponsor_no='$sponsor_no_main' ORDER BY tree_id ASC limit 1";

        $run_main_2 = mysqli_query($con,$select_query_main_2);

         

         while ($row_main_2 = mysqli_fetch_array($run_main_2)) {

          

          $user_id_main_2 = $row_main_2['user_id'];

          

          }



          







  ?><!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' />

  <style type="text/css">

    td {

      text-transform: uppercase;

    }

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

        

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

          <div class="card card-default">

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

              <h3 class="card-title">KIT Purchase</h3>

            </div>

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

            <div class="card-body">

              <div class="row">

                

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

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

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

                      

                      <div class="form-group row">

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

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

                            <input class="form-control" type="number" name="total_product" id="qty" min="1">

                            <input class="form-control" type="hidden" name="price" id="price" value="950">

                            </div>

                        </div>



                        <div class="form-group row">

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

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

                            <input class="form-control" type="text" id="total" name="amount" readonly>

                            </div>

                        </div>



                         

                        <div class="form-group row">

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

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

                               <select class="form-control" name="payment_mode">

                                 <option value="Cash Deposite">Cash Deposite</option>

                                 <option value="Online Transfer">Online Transfer</option>

                                 

                                 <option value="OFFICE">OFFICE</option>

                               </select>

                            </div>

                        </div>

                        <div class="form-group row">

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

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

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

                            </div>

                        </div>

                        <div class="form-group row">

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

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

                              <input type="text" name="trans_code" class="form-control" placeholder="Transaction No">

                            </div>

                        </div>

                        

                        <div class="form-group row">

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

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

                              <input type="text" name="bill_no" class="form-control" placeholder="Bill No">

                            </div>

                        </div>

                        



                        



                      

                      <div class="card-footer">

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

                      </div>

                  </form>

            

                </div>

                



                <!-- /.col -->

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

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

    $(document).ready(function(){

        var qty=$("#qty");

        qty.keyup(function(){

            var total=isNaN(parseInt(qty.val()* $("#price").val())) ? 0 :(qty.val()* $("#price").val())

            $("#total").val(total);

        });

    });

      $(document).ready(function(){

        var qty=$("#qty_1");

        qty.keyup(function(){

            var total=isNaN(parseInt(qty.val()* $("#price_1").val())) ? 0 :(qty.val()* $("#price_1").val())

            $("#total_1").val(total);

        });

    });

    </script>

</body>



</html>



<?php 

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

     $member_no = $_POST['member_no'];

     $total_product = $_POST['total_product'];

     $amount = $_POST['amount']; 

     $price = $_POST['price'];

     $trans_code = $_POST['trans_code'];

     

     $payment_mode = $_POST['payment_mode'];

     $bank = $_POST['bank'];

     $bill_no = $_POST['bill_no'];

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

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

    



       



       if($total_product=='' || $amount == ''){

            

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

            exit();

            }



            else {

            

                   

                   

                 

                 $insert_query = "insert into eproduct_request_roi(total_product, amount, member_no, date_time, cash_date, payment_mode, bank, pin_value, trans_code, bill_no) values('$total_product', '$amount', '$member_no', '$date', '$date_time', '$payment_mode', '$bank', '$price', '$trans_code', '$bill_no')";

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

                       

                      echo "<script>alert('Your Request is successfully submitted, you EKIT TRANSFER to 10 mints...')</script>";

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



                    }   

    

     

   }

 }

?>





  <?php  } } ?>