1#@!#!123s

: / home5 / rakcha / public_html / app /
Filename : billing.php
back
<?php 

session_start();

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

    header("location: login.php");

 }

 else {

  include("includes/database.php");

       $page_user = $_SESSION['distributor_id'];

       $select_query = "select * from member where user_id='$page_user'";

       $run = mysqli_query($con,$select_query);

       $serial = 1;

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

        $s_num = $serial++;

        $member_id = $row['member_id'];

        $profile = $row['profile'];

        $title = $row['title'];

        $dob = $row['dob'];

        $name = $row['name'];

        $gender = $row['gender'];

        $address_1 = $row['address_1'];

        $address_2 = $row['address_2'];

        $town_area = $row['town_area'];

        $city_district = $row['city_district'];

        $state = $row['state'];

        $country = $row['country'];

        $pincode = $row['pincode'];

        $mobile_number = $row['mobile_number'];

        $email = $row['email'];

        $aadhaar_card = $row['aadhaar_card'];

        $pan_card = $row['pan_card'];

        $nominee_name = $row['nominee_name'];

        $nominee_relationship = $row['nominee_relationship'];

        $account_name = $row['account_name'];

        $account_number = $row['account_number'];

        $ifsc_code = $row['ifsc_code'];

        $bank_name = $row['bank_name'];

        $branch_name = $row['branch_name'];



        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $password = $row['password'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];



        $member_fess = $row['member_fess'];

        $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_1 =$row['date_of_join'];

        $eproduct_password = $row['eproduct_password'];

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

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

                <?php 

     if ($eproduct_password == '') {

          

     ?>

      <div class="row">

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

          <div class="card card-default">

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

              <h3 class="card-title">Product purchase</h3>

            </div>

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

            <div class="card-body">

              <div class="row">

                

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

                   <form class="form-horizontal" method="post" action="billing_amount.php" enctype="multipart/form-data">



                                        

                                          <div class="row">

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

                                                 <div class="form-group">

                                                    <label>Enter RC ID</label>

                                                     <select class="form-control select2" name="member_no" required onchange="fetch_select(this.value);">



                                                        

                                                           <?php



                                                             $select_query = "select * from member WHERE user_id='$page_user'";

                                                           $run = mysqli_query($con,$select_query);

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

                                                            $s_num = $serial++;

                                                            

                                                            $name = $row['name'];

                                                            $user_id = $row['user_id'];

                                                            $member_no = $row['member_no'];

                                                            

                                                            ?>

                                                        <option value="<?= $user_id; ?>"><?= $user_id; ?> - <?= $name; ?></option>

                                                        <?php } ?>

                                                        

                                                     </select>

                                                 </div>

                                                 <div id="fetch">

                        

                                                 </div>

                                             </div>

                                         </div>

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

                                              <table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example">

                                        <thead>

                                            <tr>

                                                <th> S.No </th>

                                                <th> Product Title </th>        <th> CP </th>

                                                <th>PV</th>

                                                <th> MRP </th>

                                                <th>Available</th>

                                                <th>QTY</th>

                                                

                                                

                                                

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php 

                                              $select_query = "select * from products WHERE view='0' ORDER BY serial ASC";

                                              $run = mysqli_query($con,$select_query);

                                               $serial = 1;

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

                                                $s_num = $serial++;

                                                $product_id = $row['product_id'];

                                                $product_title = $row['product_title'];

                                                $cp = $row['cp'];

                                                $bv = $row['bv'];

                                                $mrp = $row['mrp'];

                                                $image = $row['image'];

                                                $q_no = $row['q_no']; 



                                                if ($q_no == 0) {

                                                    $prodcut_new = "NEW";

                                                }

                                                else {

                                                    $prodcut_new = "OLD";

                                                }





                                                $query_total_stock = "SELECT SUM(qty) FROM stock_list where product_id='$product_id'";

                                                            // Print out result

                                                $result_total_stock = mysqli_query($con, $query_total_stock);

                                                    while($row_total_stock = mysqli_fetch_array($result_total_stock)){

                                                    $qty = $row_total_stock['SUM(qty)'];

                                                    



                                                    

                                                }



                                                $query_total_wallet = "SELECT SUM(qty) FROM final_order where product_code='$product_id' AND order_id > '6805'";

                                                            // Print out result

                                                $result_total_wallet = mysqli_query($con, $query_total_wallet);

                                                    while($row_total_wallet = mysqli_fetch_array($result_total_wallet)){

                                                    $sale_products = $row_total_wallet['SUM(qty)'];

                                                    



                                                    

                                                }



                                                



                                                if ($qty > $sale_products) {

                                                    $available_products = $qty - $sale_products;

                                                }

                                                else {

                                                    $available_products = 0;

                                                }

                                                



                                                

                                                

                                           ?>

                                            <?php



                                           if ($available_products <= 14) {

                                              ?>



                                              <tr class="odd gradeX" style="background-color:yellow !important;">



                                              <?php

                                           }else {

                                            ?>



                                            <tr class="odd gradeX">



                                            <?php

                                           }



                                            ?>

                                                

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

                                              <td style="text-transform: uppercase;"><?= $product_title; ?> - <?= $prodcut_new; ?></td>

                                              

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

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

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

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

                                              

                                              <td>

                                                 <input type="number" name="<?= $product_id; ?>" class="form-control" value="0">

                                                 <input type="hidden" name="cp<?= $product_id; ?>" class="form-control" value="<?= $cp; ?>">

                                                 <input type="hidden" name="bv<?= $product_id; ?>" class="form-control" value="<?= $bv; ?>">

                                                 <input type="hidden" name="mrp<?= $product_id; ?>" class="form-control" value="<?= $mrp; ?>"> 

                                              </td>

                                              

                                              



                                                

                                            </tr>

                                            <?php } ?>

                                        </tbody>

                                    </table> 

                                         </div>



                                        



                                        <div class="form-group text-right">

                                            <div class="">

                                                <button class="btn btn-danger btn-block waves-effect waves-light" type="submit" style="max-width: 200px;" name="product">Submit</button>

                                            </div>

                                        </div>



                                        

                                    </form>

            

                </div>

                



                <!-- /.col -->

              </div>

              <!-- /.row -->

            </div>

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

        </div>

        </div>

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

      </div>

      <?php

          }else {



        ?>

         <div class="row">

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

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

             <div class="card card-default">

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

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

                </div>

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

                <div class="card-body">

                  <div class="row">



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

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

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

                          <div class="form-group row">

                            

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

                            <input class="form-control" type="password" name="eproduct_password" placeholder="Enter Your KIT Password">

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

         </div>

      <?php } ?>

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

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

        $member_no = $_POST['member_no'];

        $eproduct_password = $_POST['eproduct_password'];     

      

      



      $admin_query = "select * from member where member_no = '$member_no' AND eproduct_password = '$eproduct_password'";

      $run = mysqli_query($con,$admin_query);

      if (mysqli_num_rows($run)>0) {

        $_SESSION['eproduct_password'] = $eproduct_password;

        session_write_close();

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

      }

      else {

        echo "<script>alert('please enter correct Eproduct password')</script>";

        exit;

      }

     

   }



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

        $member_no = $_POST['member_no'];

        $eproduct_password = $_POST['eproduct_password'];

        $confirm_password = $_POST['confirm_password'];



        if ($eproduct_password == $confirm_password) {

          mysqli_query($con,"update member set eproduct_password='$eproduct_password' where member_no = '$member_no'");

          $_SESSION['eproduct_password'] = $eproduct_password;

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

        }

        else {

          echo "<script>alert('Miss Match Password and Conform Password')</script>";

          exit;

        }

        

   }

?>

  <?php  } } ?>