1#@!#!123s

: / home5 / rakcha / www / admin /
Filename : billing_amount.php
back
<?php 

session_start();

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

    header("location: index.php");

 }

 else {

  include("includes/database.php");

  $page_user = $_SESSION['admin_name'];

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

      $member_no = $_POST['member_no'];



      $select_query_view = "select * from member where user_id='$member_no'";

      $run_view = mysqli_query($con,$select_query_view);



      $check_sposor_id = mysqli_num_rows($run_view);



       while ($row_view = mysqli_fetch_array($run_view)) {

        

        $user_id_view = $row_view['user_id'];

        $receiver_no = $row_view['member_no'];

      }



      $product1 = $_POST['1'];

      $cp1 = $_POST['cp1'];

      $bv1 = $_POST['bv1'];

      $mrp1 = $_POST['mrp1'];



      $total_amount_1 = $mrp1*$product1;

      $total_cp_1 = $cp1*$product1;

      $total_bv_1 = $bv1*$product1;



      $product2 = $_POST['2'];

      $cp2 = $_POST['cp2'];

      $bv2 = $_POST['bv2'];

      $mrp2 = $_POST['mrp2'];

      $total_amount_2 = $mrp2*$product2;

      $total_cp_2 = $cp2*$product2;

      $total_bv_2 = $bv2*$product2;



      $product3 = $_POST['3'];

      $cp3 = $_POST['cp3'];

      $bv3 = $_POST['bv3'];

      $mrp3 = $_POST['mrp3'];



      $total_amount_3 = $mrp3*$product3;

      $total_cp_3 = $cp3*$product3;

      $total_bv_3 = $bv3*$product3;



      $product4 = $_POST['4'];

      $cp4 = $_POST['cp4'];

      $bv4 = $_POST['bv4'];

      $mrp4 = $_POST['mrp4'];

      $total_amount_4 = $mrp4*$product4;

      $total_cp_4 = $cp4*$product4;

      $total_bv_4 = $bv4*$product4;



      $product5 = $_POST['5'];

      $cp5 = $_POST['cp5'];

      $bv5 = $_POST['bv5'];

      $mrp5 = $_POST['mrp5'];

      $total_amount_5 = $mrp5*$product5;

      $total_cp_5 = $cp5*$product5;

      $total_bv_5 = $bv5*$product5;



      $product6 = $_POST['6'];

      $cp6 = $_POST['cp6'];

      $bv6 = $_POST['bv6'];

      $mrp6 = $_POST['mrp6'];

      $total_amount_6 = $mrp6*$product6;

      $total_cp_6 = $cp6*$product6;

      $total_bv_6 = $bv6*$product6;



      $product7 = $_POST['7'];

      $cp7 = $_POST['cp7'];

      $bv7 = $_POST['bv7'];

      $mrp7 = $_POST['mrp7'];

      $total_amount_7 = $mrp7*$product7;

      $total_cp_7 = $cp7*$product7;

      $total_bv_7 = $bv7*$product7;



      $product8 = $_POST['8'];

      $cp8 = $_POST['cp8'];

      $bv8 = $_POST['bv8'];

      $mrp8 = $_POST['mrp8'];

      $total_amount_8 = $mrp8*$product8;

      $total_cp_8 = $cp8*$product8;

      $total_bv_8 = $bv8*$product8;



      $product9 = $_POST['9'];

      $cp9 = $_POST['cp9'];

      $bv9 = $_POST['bv9'];

      $mrp9 = $_POST['mrp9'];



      $total_amount_9 = $mrp9*$product9;

      $total_cp_9 = $cp9*$product9;

      $total_bv_9 = $bv9*$product9;



      $product10 = $_POST['10'];

      $cp10 = $_POST['cp10'];

      $bv10 = $_POST['bv10'];

      $mrp10 = $_POST['mrp10'];



      $total_amount_10 = $mrp10*$product10;

      $total_cp_10 = $cp10*$product10;

      $total_bv_10 = $bv10*$product10;





      $product11 = $_POST['11'];

      $cp11 = $_POST['cp11'];

      $bv11 = $_POST['bv11'];

      $mrp11 = $_POST['mrp11'];



      $total_amount_11 = $mrp11*$product11;

      $total_cp_11 = $cp11*$product11;

      $total_bv_11 = $bv11*$product11;



      $product12 = $_POST['12'];

      $cp12 = $_POST['cp12'];

      $bv12 = $_POST['bv12'];

      $mrp12 = $_POST['mrp12'];



      $total_amount_12 = $mrp12*$product12;

      $total_cp_12 = $cp12*$product12;

      $total_bv_12 = $bv12*$product12;



      $product13 = $_POST['13'];

      $cp13 = $_POST['cp13'];

      $bv13 = $_POST['bv13'];

      $mrp13 = $_POST['mrp13'];



      $total_amount_13 = $mrp13*$product13;

      $total_cp_13 = $cp13*$product13;

      $total_bv_13 = $bv13*$product13;



      $product14 = $_POST['14'];

      $cp14 = $_POST['cp14'];

      $bv14 = $_POST['bv14'];

      $mrp14 = $_POST['mrp14'];



      $total_amount_14 = $mrp14*$product14;

      $total_cp_14 = $cp14*$product14;

      $total_bv_14 = $bv14*$product14;





      $product15 = $_POST['15'];

      $cp15 = $_POST['cp15'];

      $bv15 = $_POST['bv15'];

      $mrp15 = $_POST['mrp15'];



      $total_amount_15 = $mrp15*$product15;

      $total_cp_15 = $cp15*$product15;

      $total_bv_15 = $bv15*$product15;





      $product16 = $_POST['16'];

      $cp16 = $_POST['cp16'];

      $bv16 = $_POST['bv16'];

      $mrp16 = $_POST['mrp16'];



      $total_amount_16 = $mrp16*$product16;

      $total_cp_16 = $cp16*$product16;

      $total_bv_16 = $bv16*$product16;





      $product17 = $_POST['17'];

      $cp17 = $_POST['cp17'];

      $bv17 = $_POST['bv17'];

      $mrp17 = $_POST['mrp17'];



      $total_amount_17 = $mrp17*$product17;

      $total_cp_17 = $cp17*$product17;

      $total_bv_17 = $bv17*$product17;



      $product18 = $_POST['18'];

      $cp18 = $_POST['cp18'];

      $bv18 = $_POST['bv18'];

      $mrp18 = $_POST['mrp18'];



      $total_amount_18 = $mrp18*$product18;

      $total_cp_18 = $cp18*$product18;

      $total_bv_18 = $bv18*$product18;





      $product19 = $_POST['19'];

      $cp19 = $_POST['cp19'];

      $bv19 = $_POST['bv19'];

      $mrp19 = $_POST['mrp19'];



      $total_amount_19 = $mrp19*$product19;

      $total_cp_19 = $cp19*$product19;

      $total_bv_19 = $bv19*$product19;





      $product20 = $_POST['20'];

      $cp20 = $_POST['cp20'];

      $bv20 = $_POST['bv20'];

      $mrp20 = $_POST['mrp20'];



      $total_amount_20 = $mrp20*$product20;

      $total_cp_20 = $cp20*$product20;

      $total_bv_20 = $bv20*$product20;







      $product21 = $_POST['21'];

      $cp21 = $_POST['cp21'];

      $bv21 = $_POST['bv21'];

      $mrp21 = $_POST['mrp21'];



      $total_amount_21 = $mrp21*$product21;

      $total_cp_21 = $cp21*$product21;

      $total_bv_21 = $bv21*$product21;





      $product22 = $_POST['22'];

      $cp22 = $_POST['cp22'];

      $bv22 = $_POST['bv22'];

      $mrp22 = $_POST['mrp22'];



      $total_amount_22 = $mrp22*$product22;

      $total_cp_22 = $cp22*$product22;

      $total_bv_22 = $bv22*$product22;



      $product23 = $_POST['23'];

      $cp23 = $_POST['cp23'];

      $bv23 = $_POST['bv23'];

      $mrp23 = $_POST['mrp23'];



      $total_amount_23 = $mrp23*$product23;

      $total_cp_23 = $cp23*$product23;

      $total_bv_23 = $bv23*$product23;





      $product24 = $_POST['24'];

      $cp24 = $_POST['cp24'];

      $bv24 = $_POST['bv24'];

      $mrp24 = $_POST['mrp24'];



      $total_amount_24 = $mrp24*$product24;

      $total_cp_24 = $cp24*$product24;

      $total_bv_24 = $bv24*$product24;





      $product25 = $_POST['25'];

      $cp25 = $_POST['cp25'];

      $bv25 = $_POST['bv25'];

      $mrp25 = $_POST['mrp25'];



      $total_amount_25 = $mrp25*$product25;

      $total_cp_25 = $cp25*$product25;

      $total_bv_25 = $bv25*$product25;



      $product26 = $_POST['26'];

      $cp26 = $_POST['cp26'];

      $bv26 = $_POST['bv26'];

      $mrp26 = $_POST['mrp26'];



      $total_amount_26 = $mrp26*$product26;

      $total_cp_26 = $cp26*$product26;

      $total_bv_26 = $bv26*$product26;





      $product27 = $_POST['27'];

      $cp27 = $_POST['cp27'];

      $bv27 = $_POST['bv27'];

      $mrp27 = $_POST['mrp27'];



      $total_amount_27 = $mrp27*$product27;

      $total_cp_27 = $cp27*$product27;

      $total_bv_27 = $bv27*$product27;



      $product28 = $_POST['28'];

      $cp28 = $_POST['cp28'];

      $bv28 = $_POST['bv28'];

      $mrp28 = $_POST['mrp28'];



      $total_amount_28 = $mrp28*$product28;

      $total_cp_28 = $cp28*$product28;

      $total_bv_28 = $bv28*$product28;



      $product29 = $_POST['29'];

      $cp29 = $_POST['cp29'];

      $bv29 = $_POST['bv29'];

      $mrp29 = $_POST['mrp29'];



      $total_amount_29 = $mrp29*$product29;

      $total_cp_29 = $cp29*$product29;

      $total_bv_29 = $bv29*$product29;



      $product30 = $_POST['30'];

      $cp30 = $_POST['cp30'];

      $bv30 = $_POST['bv30'];

      $mrp30 = $_POST['mrp30'];



      $total_amount_30 = $mrp30*$product30;

      $total_cp_30 = $cp30*$product30;

      $total_bv_30 = $bv30*$product30;



      $product31 = $_POST['31'];

      $cp31 = $_POST['cp31'];

      $bv31 = $_POST['bv31'];

      $mrp31 = $_POST['mrp31'];



      $total_amount_31 = $mrp31*$product31;

      $total_cp_31 = $cp31*$product31;

      $total_bv_31 = $bv31*$product31;



      $product32 = $_POST['32'];

      $cp32 = $_POST['cp32'];

      $bv32 = $_POST['bv32'];

      $mrp32 = $_POST['mrp32'];



      $total_amount_32 = $mrp32*$product32;

      $total_cp_32 = $cp32*$product32;

      $total_bv_32 = $bv32*$product32;



      $product33 = $_POST['33'];

      $cp33 = $_POST['cp33'];

      $bv33 = $_POST['bv33'];

      $mrp33 = $_POST['mrp33'];



      $total_amount_33 = $mrp33*$product33;

      $total_cp_33 = $cp33*$product33;

      $total_bv_33 = $bv33*$product33;



      $product34 = $_POST['34'];

      $cp34 = $_POST['cp34'];

      $bv34 = $_POST['bv34'];

      $mrp34 = $_POST['mrp34'];



      $total_amount_34 = $mrp34*$product34;

      $total_cp_34 = $cp34*$product34;

      $total_bv_34 = $bv34*$product34;



      $product35 = $_POST['35'];

      $cp35 = $_POST['cp35'];

      $bv35 = $_POST['bv35'];

      $mrp35 = $_POST['mrp35'];



      $total_amount_35 = $mrp35*$product35;

      $total_cp_35 = $cp35*$product35;

      $total_bv_35 = $bv35*$product35;



      $product36 = $_POST['36'];

      $cp36 = $_POST['cp36'];

      $bv36 = $_POST['bv36'];

      $mrp36 = $_POST['mrp36'];



      $total_amount_36 = $mrp36*$product36;

      $total_cp_36 = $cp36*$product36;

      $total_bv_36 = $bv36*$product36;



      $product37 = $_POST['37'];

      $cp37 = $_POST['cp37'];

      $bv37 = $_POST['bv37'];

      $mrp37 = $_POST['mrp37'];



      $total_amount_37 = $mrp37*$product37;

      $total_cp_37 = $cp37*$product37;

      $total_bv_37 = $bv37*$product37;



      $product38 = $_POST['38'];

      $cp38 = $_POST['cp38'];

      $bv38 = $_POST['bv38'];

      $mrp38 = $_POST['mrp38'];



      $total_amount_38 = $mrp38*$product38;

      $total_cp_38 = $cp38*$product38;

      $total_bv_38 = $bv38*$product38;



      $product39 = $_POST['39'];

      $cp39 = $_POST['cp39'];

      $bv39 = $_POST['bv39'];

      $mrp39 = $_POST['mrp39'];



      $total_amount_39 = $mrp39*$product39;

      $total_cp_39 = $cp39*$product39;

      $total_bv_39 = $bv39*$product39;





      $product40 = $_POST['40'];

      $cp40 = $_POST['cp40'];

      $bv40 = $_POST['bv40'];

      $mrp40 = $_POST['mrp40'];



      $total_amount_40 = $mrp40*$product40;

      $total_cp_40 = $cp40*$product40;

      $total_bv_40 = $bv40*$product40;





      $product41 = $_POST['41'];

      $cp41 = $_POST['cp41'];

      $bv41 = $_POST['bv41'];

      $mrp41 = $_POST['mrp41'];



      $total_amount_41 = $mrp41*$product41;

      $total_cp_41 = $cp41*$product41;

      $total_bv_41 = $bv41*$product41;


      $product42 = $_POST['42'];

      $cp42 = $_POST['cp42'];

      $bv42 = $_POST['bv42'];

      $mrp42 = $_POST['mrp42'];



      $total_amount_42 = $mrp42*$product42;

      $total_cp_42 = $cp42*$product42;

      $total_bv_42 = $bv42*$product42;


      $product43 = $_POST['43'];

      $cp43 = $_POST['cp43'];

      $bv43 = $_POST['bv43'];

      $mrp43 = $_POST['mrp43'];



      $total_amount_43 = $mrp43*$product43;

      $total_cp_43 = $cp43*$product43;

      $total_bv_43 = $bv43*$product43;


      $product44 = $_POST['44'];

      $cp44 = $_POST['cp44'];

      $bv44 = $_POST['bv44'];

      $mrp44 = $_POST['mrp44'];



      $total_amount_44 = $mrp44*$product44;

      $total_cp_44 = $cp44*$product44;

      $total_bv_44 = $bv44*$product44;







      

      $total_amount = $total_amount_1+$total_amount_2+$total_amount_3+$total_amount_4+$total_amount_5+$total_amount_6+$total_amount_7+$total_amount_8+$total_amount_9+$total_amount_10+$total_amount_11+$total_amount_12+$total_amount_13+$total_amount_14+$total_amount_15+$total_amount_16+$total_amount_17+$total_amount_18+$total_amount_19+$total_amount_20+$total_amount_21+$total_amount_22+$total_amount_23+$total_amount_24+$total_amount_25+$total_amount_26+$total_amount_27+$total_amount_28+$total_amount_29+$total_amount_30+$total_amount_31+$total_amount_32+$total_amount_33+$total_amount_34+$total_amount_35+$total_amount_36+$total_amount_37+$total_amount_38+$total_amount_39+$total_amount_40+$total_amount_41+$total_amount_42+$total_amount_43+$total_amount_44;



      $total_cp = $total_cp_1+$total_cp_2+$total_cp_3+$total_cp_4+$total_cp_5+$total_cp_6+$total_cp_7+$total_cp_8+$total_cp_9+$total_cp_10+$total_cp_11+$total_cp_12+$total_cp_13+$total_cp_14+$total_cp_15+$total_cp_16+$total_cp_17+$total_cp_18+$total_cp_19+$total_cp_20+$total_cp_21+$total_cp_22+$total_cp_23+$total_cp_24+$total_cp_25+$total_cp_26+$total_cp_27+$total_cp_28+$total_cp_29+$total_cp_30+$total_cp_31+$total_cp_32+$total_cp_33+$total_cp_34+$total_cp_35+$total_cp_36+$total_cp_37+$total_cp_38+$total_cp_39+$total_cp_40+$total_cp_41+$total_cp_42+$total_cp_43+$total_cp_44;



      $total_bv = $total_bv_1+$total_bv_2+$total_bv_3+$total_bv_4+$total_bv_5+$total_bv_6+$total_bv_7+$total_bv_8+$total_bv_9+$total_bv_10+$total_bv_11+$total_bv_12+$total_bv_13+$total_bv_14+$total_bv_15+$total_bv_16+$total_bv_17+$total_bv_18+$total_bv_19+$total_bv_20+$total_bv_21+$total_bv_22+$total_bv_23+$total_bv_24+$total_bv_25+$total_bv_26+$total_bv_27+$total_bv_28+$total_bv_29+$total_bv_30+$total_bv_31+$total_bv_32+$total_bv_33+$total_bv_34+$total_bv_35+$total_bv_36+$total_bv_37+$total_bv_38+$total_bv_39+$total_bv_40+$total_bv_41+$total_bv_42+$total_bv_43+$total_bv_44;





      $select_query_voucher_bonus = "select SUM(total_amount) from wallet_payout where member_no = '$receiver_no' AND status='0'";

      $run_voucher_bonus = mysqli_query($con,$select_query_voucher_bonus);

      while($row_voucher_bonus = mysqli_fetch_array($run_voucher_bonus)){ 



            $total_voucher_bonus = $row_voucher_bonus['SUM(total_amount)']; 

            

      }



      $select_query_voucher_balance = "select SUM(amount) from cart_balance where member_no = '$receiver_no'";

      $run_voucher_balance = mysqli_query($con,$select_query_voucher_balance);

      while($row_voucher_balance = mysqli_fetch_array($run_voucher_balance)){ 



            $total_voucher_balance = $row_voucher_balance['SUM(amount)']; 

            

      } 



      $available_balance_amt = $total_voucher_bonus+$total_voucher_balance;







      // voucher process



      $voucher_bal = $_POST['voucher'];



      if ($voucher_bal == 1) {



       

        $sub_total = $total_cp;



        $final_total_1 = $total_cp-$available_balance_amt;



        



        if ($final_total_1 < 1) {



          $final_total = 0;

          $total_voc = $total_cp;

           

        }

        else {

          $final_total = $final_total_1;

          $total_voc = $available_balance_amt;

        }



         

      }

      else {



        $sub_total = $total_cp;



        $final_total = $total_cp;



        $total_voc = 0;







      }



      //voucher process



      

  }



  ?>

  <!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="utf-8" />

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta content="width=device-width, initial-scale=1" name="viewport" />

    <meta name="description" content="RAKCHA | Dashboard" />

    <meta name="author" content="RAKCHA | Dashboard" />

    <title>RAKCHA | Dashboard</title>

    <!-- google font -->

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

  <!-- icons -->

    <link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>

  <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">

    <!-- bootstrap -->

  <link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />

    <!-- data tables -->

    <link href="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css"/>

  <!-- Material Design Lite CSS -->

  <link rel="stylesheet" href="assets/plugins/material/material.min.css">

  <link rel="stylesheet" href="assets/css/material_style.css">

  <!-- animation -->

  <link href="assets/css/pages/animate_page.css" rel="stylesheet">

  <!-- Theme Styles -->

    

    <link href="assets/css/style.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />

  <link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" />

    <!--select2-->

    <link href="assets/plugins/select2/css/select2.css" rel="stylesheet" type="text/css" />

    <link href="assets/plugins/select2/css/select2-bootstrap.min.css" rel="stylesheet" type="text/css" />

  <!-- favicon -->

    <link rel="shortcut icon" href="assets/img/favicon.png" />

 </head>

<!-- END HEAD -->

<body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark">

    <div class="page-wrapper">

        <!-- start header -->

        <div class="page-header navbar navbar-fixed-top">

            <div class="page-header-inner ">

                <!-- logo start -->

                <div class="page-logo">

                    <a href="main_home.php">

                        <img src="../images/resources/logo.png">

                    </a>

                </div>

                <!-- logo end -->

                <ul class="nav navbar-nav navbar-left in">

                    <li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li>

                </ul>

                

                <!-- start mobile menu -->

                <a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse">

                    <span></span>

                </a>

               <!-- end mobile menu -->

                <!-- start header menu -->

                <div class="top-menu">

                    <ul class="nav navbar-nav pull-right">

                        

                        <!-- start manage user dropdown -->

                        <li class="dropdown dropdown-user">

                            <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">

                                <i class="fa fa-user-o"></i>

                                <span class="username username-hide-on-mobile"> Admin </span>

                                <i class="fa fa-angle-down"></i>

                            </a>

                            <ul class="dropdown-menu dropdown-menu-default animated jello">

                                

                                <li>

                                    <a href="logout.php">

                                        <i class="icon-logout"></i> Log Out </a>

                                </li>

                            </ul>

                        </li>

                       

                    </ul>

                </div>

            </div>

        </div>

        <!-- end header -->

        

        <!-- start page container -->

        <div class="page-container">

            <!-- start sidebar menu -->

            <div class="sidebar-container">

                <div class="sidemenu-container navbar-collapse collapse fixed-menu">

                    <div id="remove-scroll">

                        <ul class="sidemenu  page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px">

                            <li class="sidebar-toggler-wrapper hide">

                                <div class="sidebar-toggler">

                                    <span></span>

                                </div>

                            </li>

                            

                            <li class="nav-item start active">

                                <a href="main_home.php" class="nav-link nav-toggle">

                                    <i class="material-icons">dashboard</i>

                                    <span class="title">Dashboard</span>

                                    

                                </a>

                                

                            </li>

                            



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Members</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="member_roi.php" class="nav-link "> <span class="title">Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                             

                           

                             

                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Payout</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Kit Bank</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span>

                                        </a>

                                    </li>



                                    

                                </ul>

                            </li>



                             



                            

                            



                            



                             

                            



                            



                             

                            



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Product Management</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span>

                                        </a>

                                    </li>

                                    

                                    <li class="nav-item">

                                        <a href="billing.php" class="nav-link "> <span class="title">New Billing</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Daily Updates</span> 

                                </a>

                            </li>

                            <li class="nav-item">

                                <a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Gallery</span> 

                                </a>

                            </li>



                             

                            <li class="nav-item">

                                <a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Reward Eligible list</span> 

                                </a>

                            </li>

                            



                            

                             

                             

                             

                            <li class="nav-item">

                                <a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">KYC Documents</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">OLD DATA</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">NETWORK TREE</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">



                                    

                                    

                                    <li class="nav-item">

                                        <a href="network.php" class="nav-link "> <span class="title">Seniority List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="network_search.php" class="nav-link "> <span class="title">Level List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span>

                                        </a>

                                    </li>



                                    

                                    

                                    

                                    

                                </ul>

                            </li>

                             

                            

                            <li class="nav-item">

                                <a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Coupon Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Personal Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Special Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">SMS DETAILS</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">COMMITTEE DETAILS</span> 

                                </a>

                            </li>

                             

                            

                            <li class="nav-item">

                                <a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Notice Letter</span> 

                                </a>

                            </li>

                            

                            <li class="nav-item">

                                <a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Password</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Trans Password</span> 

                                </a>

                            </li>



                           

                        </ul>

                    </div>

                </div>

            </div>

            <!-- end sidebar menu --> 

      <!-- start page content -->

            <div class="page-content-wrapper">

                <div class="page-content">

                    <div class="page-bar">

                        <div class="page-title-breadcrumb">

                            <div class=" pull-left">

                                <div class="page-title">Billing</div>

                            </div>

                            <ol class="breadcrumb page-breadcrumb pull-right">

                                <li><i class="fa fa-home"></i>&nbsp;<a class="parent-item"  href="index.php">Home</a>&nbsp;<i class="fa fa-angle-right"></i>

                                </li>

                                

                                <li class="active">Billing</li>

                            </ol>

                        </div>

                    </div>

                    



                    <div class="row">

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

                            <div class="card card-topline-aqua" style="padding: 0;">

                                <div class="card-head">

                                    <header>Product Details</header>

                                     

                                </div>

                                <div class="card-body " style="overflow-x: scroll;padding: 0;">

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

                                                     <select class="form-control  select2" name="member_no" required>

                                                      <option value="">Enter RC ID</option>

                                                        

                                                           <?php



                                                             $select_query = "select * from member where member_no='$receiver_no'AND login_status='0' AND member_category='2'";

                                                           $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 selected value="<?= $user_id; ?>"><?= $user_id; ?> - <?= $name; ?></option>

                                                        <?php } ?>

                                                        

                                                     </select>

                                                 </div>

                                                 <div class="form-check">

                                                  <?php



                                                   if ($voucher_bal == 1) { 



                                                   ?>

                                                  <input class="form-check-input" type="checkbox" name="voucher" value="1" id="flexCheckDefault" checked>



                                                <?php } else { ?>



                                                  <input class="form-check-input" type="checkbox" name="voucher" value="1" id="flexCheckDefault">



                                                  <?php



                                                } ?>

                                                  <label class="form-check-label" for="flexCheckDefault">

                                                    Voucher Balance = Rs.<?= $available_balance_amt+0; ?>

                                                  </label>

                                                </div>

                                             </div>

                                         </div>

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

                                          <br>

                                              <table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%; scroll:auto;">

                                        <thead>

                                            <tr>

                                                

                                                <th>QTY</th>

                                                

                                                <th> Product Title </th>        

                                                <th> CP </th>

                                                <th>PV</th>

                                                <th> MRP </th>

                                                <th>Available</th>

                                                

                                                

                                                

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php 

                                              $select_query = "select * from products WHERE view='0' AND q_no='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>

                                                 <input type="number" name="<?= $product_id; ?>" class="form-control" value="<?php echo $_POST[$product_id]; ?>">

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

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

                                              

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

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

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

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

                                              

                                              

                                              

                                              



                                                

                                            </tr>

                                            <?php } ?>

                                        </tbody>

                                    </table> 

                                         </div>



                                         <div class="form-group" style="max-width: 300px;">

                                          <label>Create By</label>

                                          <input type="text" name="create_by" value="OFFICE" class="form-control" required>

                                         </div>



                                         <div class="form-group" style="max-width: 300px;">

                                          <label>Payment Type</label>

                                          



                                          <select class="form-control" name="payment_method" required>



                                           <option selected value="ONLINE TRANSFER">ONLINE TRANSFER</option>

                                           <option  value="CASH">CASH</option>



                                            <option value="CARD">CARD</option>

                                            

                                            

                                            <option value="DD">DD</option>

                                            <option value="PENDING">PENDING</option>

                                          </select>



                                         </div>



                                         <div class="form-group" style="max-width: 300px;">

                                          <label>Select Delivery Type</label>

                                          <select class="form-control" name="delivery_type" onchange="fetch_select1(this.value);" required>

                                            <option selected value="4">COURIER</option>

                                            <option value="2">PICKED UP IN PERSON</option>

                                            

                                            <option value="1">Registered Address</option>

                                            <option value="3">New Address</option>

                                            

                                          </select>

                                         </div>

                                         <div id="fetch_data"></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">Check Pv</button>

                                                <button class="btn btn-success btn-block waves-effect waves-light" type="submit" style="max-width: 200px;" name="check">Checkout</button>

                                            </div>

                                        </div>



                                        

                                    </form>

                                </div>

                            </div>

                        </div>

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

                            <div class="card card-topline-aqua">

                                <div class="card-head">

                                    <span style="display: inline-block;width: 50%;padding-left: 20px;font-size: 16px;">TOTAL PV </span> : <span style="padding-left: 30px;"><?= $total_bv; ?></span>

                                    <span style="display: inline-block;width: 50%;padding-left: 20px;font-size: 16px;">TOTAL MRP </span>  : <span style="padding-left: 30px;"><?= $total_amount; ?></span>



                                    <hr>



                                    <span style="display: inline-block;width: 50%;padding-left: 20px;font-size: 16px;">SUB TOTAL </span>  : <span style="padding-left: 30px;"><?= $sub_total; ?></span>



                                    <span style="display: inline-block;width: 50%;padding-left: 20px;font-size: 16px;">VOUCHER </span>  : <span style="padding-left: 30px;"><?= $total_voc; ?> (-)</span>



                                    <hr>



                                    <span style="display: inline-block;width: 50%;padding-left: 20px;font-size: 16px;">TOTAL CP </span>  : <span style="padding-left: 30px;font-size: 40px;"><?= $final_total; ?></span>

                                     

                                </div>

                                

                            </div>

                        </div>

                    </div>

                    

                    

                </div>

            </div>

            <!-- end page content -->

             

        </div>

        <!-- end page container -->

        <!-- start footer -->

        <div class="page-footer">

            <div class="page-footer-inner"> 2019 &copy; All Rights Reserved.

            </div>

            <div class="scroll-to-top">

                <i class="icon-arrow-up"></i>

            </div>

        </div>

        <!-- end footer -->

    </div>

    <!-- start js include path -->

    <script src="assets/plugins/jquery/jquery.min.js" ></script>

    <script src="assets/plugins/popper/popper.min.js" ></script>

    <script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script>

  <script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script>

    <!-- bootstrap -->

    <script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script>

    <!-- data tables -->

    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>

  <script src="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.js" ></script>

    <script src="assets/js/pages/table/table_data.js" ></script>

    <!-- Common js-->

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

    <script src="assets/js/layout.js" ></script>

  <script src="assets/js/theme-color.js" ></script>

  <!-- Material -->

  <script src="assets/plugins/material/material.min.js"></script>

  <!-- animation -->

  <script src="assets/js/pages/ui/animations.js" ></script>

    <script src="assets/plugins/select2/js/select2.js" ></script>

    <script src="assets/js/pages/select2/select2-init.js" ></script>

    <script type="text/javascript">

      function fetch_select1(val)

            {

             $.ajax({

             type: 'post',

             url: 'fetch_data.php',

             data: {

              get_option:val

             },

             success: function (response) {

              document.getElementById("fetch_data").innerHTML=response; 

             }

             });

            }



             $(document).ready(function() {

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

                var name1 = $('#search1').val();

               if (name1 == "") {

                 

               }

               else {

                 $.ajax({

                 type: "POST",

                 url: "searchname.php",

                 data: {

                     search: name1

                  },

                  success: function(html) {

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

                         }

                        });

             

                   }

             

               });

             

            });

           

    </script>

    <!-- end js include path -->

</body>



</html>

 <?php 

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



        $random = rand(4000,5000);

        $random_no = "RC10".$random;



        $member_no_1 = $_POST['member_no'];



        $select_query_view = "select * from member where user_id='$member_no_1'";

        $run_view = mysqli_query($con,$select_query_view);



        $check_sposor_id = mysqli_num_rows($run_view);



         while ($row_view = mysqli_fetch_array($run_view)) {

          

          $user_id_view = $row_view['user_id'];

          $member_no = $row_view['member_no'];

          $extra_bv = $row_view['extra_bv'];



        }



        $create_by = $_POST['create_by'];

        

        $delivery_type = $_POST['delivery_type'];

        $delivery_address = $_POST['delivery_address'];



        $select_query = "select * from roi_tree where member_no='$member_no'";

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

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

          $s_num = $serial++;

          $user_id = $row['user_id'];

          $member_no = $row['member_no'];

          $product_amount = $row['product_amount'];

        }



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

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $status_main = $row_main['status'];



          $date_main = $row_main['date'];



          $product_amount_main = $row_main['product_amount'];

          $total_bv_main = $row_main['total_bv'];

          }



          $select_query_total_tcmbv = "select SUM(product_amount) from product_tree where member_no='$member_no'";

            $run_total_tcmbv = mysqli_query($con,$select_query_total_tcmbv);

            while($row_total_tcmbv = mysqli_fetch_array($run_total_tcmbv)){

                  $total_tcmbv_1 = $row_total_tcmbv['SUM(product_amount)'];

                  

            }



            $balance_bv_current = 2000-$total_tcmbv_1;





            $select_query_count_own_count = "select * from product_tree where member_no='$member_no'";

                $run_count_own_count = mysqli_query($con,$select_query_count_own_count);

                $user_count_own_count = mysqli_num_rows($run_count_own_count);





                $select_query_count = "select * from product_tree";

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

                $product_no = $member_no_1;



          

          



      $product1 = $_POST['1'];

      $cp1 = $_POST['cp1'];

      $bv1 = $_POST['bv1'];

      $mrp1 = $_POST['mrp1'];



      $total_amount_1 = $mrp1*$product1;

      $total_cp_1 = $cp1*$product1;

      $total_bv_1 = $bv1*$product1;



      $product2 = $_POST['2'];

      $cp2 = $_POST['cp2'];

      $bv2 = $_POST['bv2'];

      $mrp2 = $_POST['mrp2'];

      $total_amount_2 = $mrp2*$product2;

      $total_cp_2 = $cp2*$product2;

      $total_bv_2 = $bv2*$product2;



      $product3 = $_POST['3'];

      $cp3 = $_POST['cp3'];

      $bv3 = $_POST['bv3'];

      $mrp3 = $_POST['mrp3'];



      $total_amount_3 = $mrp3*$product3;

      $total_cp_3 = $cp3*$product3;

      $total_bv_3 = $bv3*$product3;



      $product4 = $_POST['4'];

      $cp4 = $_POST['cp4'];

      $bv4 = $_POST['bv4'];

      $mrp4 = $_POST['mrp4'];

      $total_amount_4 = $mrp4*$product4;

      $total_cp_4 = $cp4*$product4;

      $total_bv_4 = $bv4*$product4;



      $product5 = $_POST['5'];

      $cp5 = $_POST['cp5'];

      $bv5 = $_POST['bv5'];

      $mrp5 = $_POST['mrp5'];

      $total_amount_5 = $mrp5*$product5;

      $total_cp_5 = $cp5*$product5;

      $total_bv_5 = $bv5*$product5;



      $product6 = $_POST['6'];

      $cp6 = $_POST['cp6'];

      $bv6 = $_POST['bv6'];

      $mrp6 = $_POST['mrp6'];

      $total_amount_6 = $mrp6*$product6;

      $total_cp_6 = $cp6*$product6;

      $total_bv_6 = $bv6*$product6;



      $product7 = $_POST['7'];

      $cp7 = $_POST['cp7'];

      $bv7 = $_POST['bv7'];

      $mrp7 = $_POST['mrp7'];

      $total_amount_7 = $mrp7*$product7;

      $total_cp_7 = $cp7*$product7;

      $total_bv_7 = $bv7*$product7;



      $product8 = $_POST['8'];

      $cp8 = $_POST['cp8'];

      $bv8 = $_POST['bv8'];

      $mrp8 = $_POST['mrp8'];

      $total_amount_8 = $mrp8*$product8;

      $total_cp_8 = $cp8*$product8;

      $total_bv_8 = $bv8*$product8;



      $product9 = $_POST['9'];

      $cp9 = $_POST['cp9'];

      $bv9 = $_POST['bv9'];

      $mrp9 = $_POST['mrp9'];



      $total_amount_9 = $mrp9*$product9;

      $total_cp_9 = $cp9*$product9;

      $total_bv_9 = $bv9*$product9;



      $product10 = $_POST['10'];

      $cp10 = $_POST['cp10'];

      $bv10 = $_POST['bv10'];

      $mrp10 = $_POST['mrp10'];



      $total_amount_10 = $mrp10*$product10;

      $total_cp_10 = $cp10*$product10;

      $total_bv_10 = $bv10*$product10;





      $product11 = $_POST['11'];

      $cp11 = $_POST['cp11'];

      $bv11 = $_POST['bv11'];

      $mrp11 = $_POST['mrp11'];



      $total_amount_11 = $mrp11*$product11;

      $total_cp_11 = $cp11*$product11;

      $total_bv_11 = $bv11*$product11;



      $product12 = $_POST['12'];

      $cp12 = $_POST['cp12'];

      $bv12 = $_POST['bv12'];

      $mrp12 = $_POST['mrp12'];



      $total_amount_12 = $mrp12*$product12;

      $total_cp_12 = $cp12*$product12;

      $total_bv_12 = $bv12*$product12;



      $product13 = $_POST['13'];

      $cp13 = $_POST['cp13'];

      $bv13 = $_POST['bv13'];

      $mrp13 = $_POST['mrp13'];



      $total_amount_13 = $mrp13*$product13;

      $total_cp_13 = $cp13*$product13;

      $total_bv_13 = $bv13*$product13;



      $product14 = $_POST['14'];

      $cp14 = $_POST['cp14'];

      $bv14 = $_POST['bv14'];

      $mrp14 = $_POST['mrp14'];



      $total_amount_14 = $mrp14*$product14;

      $total_cp_14 = $cp14*$product14;

      $total_bv_14 = $bv14*$product14;



      $product15 = $_POST['15'];

      $cp15 = $_POST['cp15'];

      $bv15 = $_POST['bv15'];

      $mrp15 = $_POST['mrp15'];



      $total_amount_15 = $mrp15*$product15;

      $total_cp_15 = $cp15*$product15;

      $total_bv_15 = $bv15*$product15;



      $product16 = $_POST['16'];

      $cp16 = $_POST['cp16'];

      $bv16 = $_POST['bv16'];

      $mrp16 = $_POST['mrp16'];



      $total_amount_16 = $mrp16*$product16;

      $total_cp_16 = $cp16*$product16;

      $total_bv_16 = $bv16*$product16;





      $product17 = $_POST['17'];

      $cp17 = $_POST['cp17'];

      $bv17 = $_POST['bv17'];

      $mrp17 = $_POST['mrp17'];



      $total_amount_17 = $mrp17*$product17;

      $total_cp_17 = $cp17*$product17;

      $total_bv_17 = $bv17*$product17;



      $product18 = $_POST['18'];

      $cp18 = $_POST['cp18'];

      $bv18 = $_POST['bv18'];

      $mrp18 = $_POST['mrp18'];



      $total_amount_18 = $mrp18*$product18;

      $total_cp_18 = $cp18*$product18;

      $total_bv_18 = $bv18*$product18;







      $product19 = $_POST['19'];

      $cp19 = $_POST['cp19'];

      $bv19 = $_POST['bv19'];

      $mrp19 = $_POST['mrp19'];



      $total_amount_19 = $mrp19*$product19;

      $total_cp_19 = $cp19*$product19;

      $total_bv_19 = $bv19*$product19;



      $product20 = $_POST['20'];

      $cp20 = $_POST['cp20'];

      $bv20 = $_POST['bv20'];

      $mrp20 = $_POST['mrp20'];



      $total_amount_20 = $mrp20*$product20;

      $total_cp_20 = $cp20*$product20;

      $total_bv_20 = $bv20*$product20;





      $product21 = $_POST['21'];

      $cp21 = $_POST['cp21'];

      $bv21 = $_POST['bv21'];

      $mrp21 = $_POST['mrp21'];



      $total_amount_21 = $mrp21*$product21;

      $total_cp_21 = $cp21*$product21;

      $total_bv_21 = $bv21*$product21;





      $product22 = $_POST['22'];

      $cp22 = $_POST['cp22'];

      $bv22 = $_POST['bv22'];

      $mrp22 = $_POST['mrp22'];



      $total_amount_22 = $mrp22*$product22;

      $total_cp_22 = $cp22*$product22;

      $total_bv_22 = $bv22*$product22;



      $product23 = $_POST['23'];

      $cp23 = $_POST['cp23'];

      $bv23 = $_POST['bv23'];

      $mrp23 = $_POST['mrp23'];



      $total_amount_23 = $mrp23*$product23;

      $total_cp_23 = $cp23*$product23;

      $total_bv_23 = $bv23*$product23;



      $product24 = $_POST['24'];

      $cp24 = $_POST['cp24'];

      $bv24 = $_POST['bv24'];

      $mrp24 = $_POST['mrp24'];



      $total_amount_24 = $mrp24*$product24;

      $total_cp_24 = $cp24*$product24;

      $total_bv_24 = $bv24*$product24;



      $product25 = $_POST['25'];

      $cp25 = $_POST['cp25'];

      $bv25 = $_POST['bv25'];

      $mrp25 = $_POST['mrp25'];



      $total_amount_25 = $mrp25*$product25;

      $total_cp_25 = $cp25*$product25;

      $total_bv_25 = $bv25*$product25;





      $product26 = $_POST['26'];

      $cp26 = $_POST['cp26'];

      $bv26 = $_POST['bv26'];

      $mrp26 = $_POST['mrp26'];



      $total_amount_26 = $mrp26*$product26;

      $total_cp_26 = $cp26*$product26;

      $total_bv_26 = $bv26*$product26;



      $product27 = $_POST['27'];

      $cp27 = $_POST['cp27'];

      $bv27 = $_POST['bv27'];

      $mrp27 = $_POST['mrp27'];



      $total_amount_27 = $mrp27*$product27;

      $total_cp_27 = $cp27*$product27;

      $total_bv_27 = $bv27*$product27;



      $product28 = $_POST['28'];

      $cp28 = $_POST['cp28'];

      $bv28 = $_POST['bv28'];

      $mrp28 = $_POST['mrp28'];



      $total_amount_28 = $mrp28*$product28;

      $total_cp_28 = $cp28*$product28;

      $total_bv_28 = $bv28*$product28;



      $product29 = $_POST['29'];

      $cp29 = $_POST['cp29'];

      $bv29 = $_POST['bv29'];

      $mrp29 = $_POST['mrp29'];



      $total_amount_29 = $mrp29*$product29;

      $total_cp_29 = $cp29*$product29;

      $total_bv_29 = $bv29*$product29;



      $product30 = $_POST['30'];

      $cp30 = $_POST['cp30'];

      $bv30 = $_POST['bv30'];

      $mrp30 = $_POST['mrp30'];



      $total_amount_30 = $mrp30*$product30;

      $total_cp_30 = $cp30*$product30;

      $total_bv_30 = $bv30*$product30;



      $product31 = $_POST['31'];

      $cp31 = $_POST['cp31'];

      $bv31 = $_POST['bv31'];

      $mrp31 = $_POST['mrp31'];



      $total_amount_31 = $mrp31*$product31;

      $total_cp_31 = $cp31*$product31;

      $total_bv_31 = $bv31*$product31;



      $product32 = $_POST['32'];

      $cp32 = $_POST['cp32'];

      $bv32 = $_POST['bv32'];

      $mrp32 = $_POST['mrp32'];



      $total_amount_32 = $mrp32*$product32;

      $total_cp_32 = $cp32*$product32;

      $total_bv_32 = $bv32*$product32;



      $product33 = $_POST['33'];

      $cp33 = $_POST['cp33'];

      $bv33 = $_POST['bv33'];

      $mrp33 = $_POST['mrp33'];



      $total_amount_33 = $mrp33*$product33;

      $total_cp_33 = $cp33*$product33;

      $total_bv_33 = $bv33*$product33;



      $product34 = $_POST['34'];

      $cp34 = $_POST['cp34'];

      $bv34 = $_POST['bv34'];

      $mrp34 = $_POST['mrp34'];



      $total_amount_34 = $mrp34*$product34;

      $total_cp_34 = $cp34*$product34;

      $total_bv_34 = $bv34*$product34;



      $product35 = $_POST['35'];

      $cp35 = $_POST['cp35'];

      $bv35 = $_POST['bv35'];

      $mrp35 = $_POST['mrp35'];



      $total_amount_35 = $mrp35*$product35;

      $total_cp_35 = $cp35*$product35;

      $total_bv_35 = $bv35*$product35;



      $product36 = $_POST['36'];

      $cp36 = $_POST['cp36'];

      $bv36 = $_POST['bv36'];

      $mrp36 = $_POST['mrp36'];



      $total_amount_36 = $mrp36*$product36;

      $total_cp_36 = $cp36*$product36;

      $total_bv_36 = $bv36*$product36;



      $product37 = $_POST['37'];

      $cp37 = $_POST['cp37'];

      $bv37 = $_POST['bv37'];

      $mrp37 = $_POST['mrp37'];



      $total_amount_37 = $mrp37*$product37;

      $total_cp_37 = $cp37*$product37;

      $total_bv_37 = $bv37*$product37;



      $product38 = $_POST['38'];

      $cp38 = $_POST['cp38'];

      $bv38 = $_POST['bv38'];

      $mrp38 = $_POST['mrp38'];



      $total_amount_38 = $mrp38*$product38;

      $total_cp_38 = $cp38*$product38;

      $total_bv_38 = $bv38*$product38;



      $product39 = $_POST['39'];

      $cp39 = $_POST['cp39'];

      $bv39 = $_POST['bv39'];

      $mrp39 = $_POST['mrp39'];



      $total_amount_39 = $mrp39*$product39;

      $total_cp_39 = $cp39*$product39;

      $total_bv_39 = $bv39*$product39;





      $product40 = $_POST['40'];

      $cp40 = $_POST['cp40'];

      $bv40 = $_POST['bv40'];

      $mrp40 = $_POST['mrp40'];



      $total_amount_40 = $mrp40*$product40;

      $total_cp_40 = $cp40*$product40;

      $total_bv_40 = $bv40*$product40;





      $product41 = $_POST['41'];

      $cp41 = $_POST['cp41'];

      $bv41 = $_POST['bv41'];

      $mrp41 = $_POST['mrp41'];



      $total_amount_41 = $mrp41*$product41;

      $total_cp_41 = $cp41*$product41;

      $total_bv_41 = $bv41*$product41;


      $product42 = $_POST['42'];

      $cp42 = $_POST['cp42'];

      $bv42 = $_POST['bv42'];

      $mrp42 = $_POST['mrp42'];



      $total_amount_42 = $mrp42*$product42;

      $total_cp_42 = $cp42*$product42;

      $total_bv_42 = $bv42*$product42;


      $product43 = $_POST['43'];

      $cp43 = $_POST['cp43'];

      $bv43 = $_POST['bv43'];

      $mrp43 = $_POST['mrp43'];



      $total_amount_43 = $mrp43*$product43;

      $total_cp_43 = $cp43*$product43;

      $total_bv_43 = $bv43*$product43;


      $product44 = $_POST['44'];

      $cp44 = $_POST['cp44'];

      $bv44 = $_POST['bv44'];

      $mrp44 = $_POST['mrp44'];



      $total_amount_44 = $mrp44*$product44;

      $total_cp_44 = $cp44*$product44;

      $total_bv_44 = $bv44*$product44;







      

      $total_amount = $total_amount_1+$total_amount_2+$total_amount_3+$total_amount_4+$total_amount_5+$total_amount_6+$total_amount_7+$total_amount_8+$total_amount_9+$total_amount_10+$total_amount_11+$total_amount_12+$total_amount_13+$total_amount_14+$total_amount_15+$total_amount_16+$total_amount_17+$total_amount_18+$total_amount_19+$total_amount_20+$total_amount_21+$total_amount_22+$total_amount_23+$total_amount_24+$total_amount_25+$total_amount_26+$total_amount_27+$total_amount_28+$total_amount_29+$total_amount_30+$total_amount_31+$total_amount_32+$total_amount_33+$total_amount_34+$total_amount_35+$total_amount_36+$total_amount_37+$total_amount_38+$total_amount_39+$total_amount_40+$total_amount_41+$total_amount_42+$total_amount_43+$total_amount_44;



      $total_cp = $total_cp_1+$total_cp_2+$total_cp_3+$total_cp_4+$total_cp_5+$total_cp_6+$total_cp_7+$total_cp_8+$total_cp_9+$total_cp_10+$total_cp_11+$total_cp_12+$total_cp_13+$total_cp_14+$total_cp_15+$total_cp_16+$total_cp_17+$total_cp_18+$total_cp_19+$total_cp_20+$total_cp_21+$total_cp_22+$total_cp_23+$total_cp_24+$total_cp_25+$total_cp_26+$total_cp_27+$total_cp_28+$total_cp_29+$total_cp_30+$total_cp_31+$total_cp_32+$total_cp_33+$total_cp_34+$total_cp_35+$total_cp_36+$total_cp_37+$total_cp_38+$total_cp_39+$total_cp_40+$total_cp_41+$total_cp_42+$total_cp_43+$total_cp_44;



      $total_bv = $total_bv_1+$total_bv_2+$total_bv_3+$total_bv_4+$total_bv_5+$total_bv_6+$total_bv_7+$total_bv_8+$total_bv_9+$total_bv_10+$total_bv_11+$total_bv_12+$total_bv_13+$total_bv_14+$total_bv_15+$total_bv_16+$total_bv_17+$total_bv_18+$total_bv_19+$total_bv_20+$total_bv_21+$total_bv_22+$total_bv_23+$total_bv_24+$total_bv_25+$total_bv_26+$total_bv_27+$total_bv_28+$total_bv_29+$total_bv_30+$total_bv_31+$total_bv_32+$total_bv_33+$total_bv_34+$total_bv_35+$total_bv_36+$total_bv_37+$total_bv_38+$total_bv_39+$total_bv_40+$total_bv_41+$total_bv_42+$total_bv_43+$total_bv_44;





      $select_query_voucher_bonus = "select SUM(total_amount) from wallet_payout where member_no = '$member_no' AND status='0'";

      $run_voucher_bonus = mysqli_query($con,$select_query_voucher_bonus);

      while($row_voucher_bonus = mysqli_fetch_array($run_voucher_bonus)){ 



            $total_voucher_bonus = $row_voucher_bonus['SUM(total_amount)']; 

            

      }



      $select_query_voucher_balance = "select SUM(amount) from cart_balance where member_no = '$member_no'";

      $run_voucher_balance = mysqli_query($con,$select_query_voucher_balance);

      while($row_voucher_balance = mysqli_fetch_array($run_voucher_balance)){ 



            $total_voucher_balance = $row_voucher_balance['SUM(amount)']; 

            

      } 



      $available_balance_amt = $total_voucher_bonus+$total_voucher_balance;



      // voucher 



      $date = date("Y-m-d");





      // if ($status_main == 1 && $date_main == $date && $user_count_own_count == 1) {



      //     $total_bv_1_new_one=$total_bv_1*2;





      //     if ($balance_bv_current >= $total_bv_1_new_one) {

      //          $total_bv=$total_bv_1_new_one;

      //       }

      //       else {



              



      //         $remaining_bv = $total_bv_1_new_one-$balance_bv_current;



      //         $remaing_old_balan = $remaining_bv/2;





      //         $total_bv=$balance_bv_current+$remaing_old_balan;



      //       }





            

         

      // }

      // else {



      //        $total_bv=$total_bv_1;



      // }



       



      





      

            





          $voucher_bal = $_POST['voucher'];



          if ($voucher_bal == 1) {



           

            if ($total_cp > $available_balance_amt) {



               $total_voc = $available_balance_amt;



               $balance_voc_amt = 0;



               $payment_method = "CASH & VOUCHER";



                

             }

             else {



                $total_voc = $total_cp;



                $balance_voc_amt = $available_balance_amt-$total_cp;

                $payment_method = "VOUCHER";



             } 



            

            }

          else {



            



            $total_voc = 0;

            $balance_voc_amt = 0;

            $payment_method = $_POST['payment_method'];







          }



      //voucer





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

      

     $year = date("Y");

     $month = date("m");



     $select_query_count = "select * from product_check";

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

    $order_code = $member_no_1;

    $final_bv = $total_bv+$product_amount;









      $insert_query = "insert into product_check(member_no, user_id, date, total_amount, bv, year, month, cp, order_code, relese, status, issue_date, create_by, payment_method, delivery_type, delivery_address, random_no, relation_ship_no, x_position, y_position, voucher) values('$member_no', '$user_id', '$date', '$total_amount', '$total_bv', '$year', '$month', '$total_cp', '$order_code', '1', '2', '$date', '$create_by', '$payment_method', '$delivery_type', '$delivery_address', '$random_no', '$relation_ship_no_main', '$x_position_main', '$y_position_main', '$total_voc')";



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



                  if ($voucher_bal == 1) {



                    mysqli_query($con,"update wallet_payout set status='1' where member_no = '$member_no' AND status='0'");

                    mysqli_query($con,"delete from cart_balance where member_no = '$member_no'");



                  

                   

                }



                if ($balance_voc_amt > 0) {



                    mysqli_query($con,"insert into cart_balance(member_no, amount, date) values('$member_no', '$balance_voc_amt', '$date')");

                    



                  }



              

                   mysqli_query($con, "insert into product_tree(member_no, user_id, relation_ship_no, x_position, y_position, product_amount, product_no, date, month, year) values('$member_no_main', '$user_id_main', '$relation_ship_no_main', '$x_position_main', '$y_position_main', '$total_bv', '$product_no', '$date', '$month', '$year')");

                   

                  mysqli_query($con, "update roi_tree set product_amount='$final_bv', active_base='1' where member_no = '$member_no'");



                  if ($product1 > 0) {

                     $select_query_1 = "select * from products where product_id='1'";

                      $run_1 = mysqli_query($con,$select_query_1);

                      $num_right_1_1 = mysqli_num_rows($run_1);

                       $serial_payment = 1;

                       while ($row_1 = mysqli_fetch_array($run_1)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_1['product_id'];

                        $product_title = $row_1['product_title'];

                        $cp = $row_1['cp'];

                        $bv = $row_1['bv'];

                        $mrp = $row_1['mrp'];

                        $image = $row_1['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product1', '$total_amount_1', '$total_bv_1', '$total_cp_1', '$order_code')");

                      }

                  }



                  if ($product2 > 0) {

                     $select_query_2 = "select * from products where product_id='2'";

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

                      $num_right_2_2 = mysqli_num_rows($run_2);

                       $serial_payment = 1;

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

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_2['product_id'];

                        $product_title = $row_2['product_title'];

                        $cp = $row_2['cp'];

                        $bv = $row_2['bv'];

                        $mrp = $row_2['mrp'];

                        $image = $row_2['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product2', '$total_amount_2', '$total_bv_2', '$total_cp_2', '$order_code')");

                      }

                    }



                      if ($product3 > 0) {

                     $select_query_3 = "select * from products where product_id='3'";

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

                      $num_right_3_3 = mysqli_num_rows($run_3);

                       $serial_payment = 1;

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

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_3['product_id'];

                        $product_title = $row_3['product_title'];

                        $cp = $row_3['cp'];

                        $bv = $row_3['bv'];

                        $mrp = $row_3['mrp'];

                        $image = $row_3['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product3', '$total_amount_3', '$total_bv_3', '$total_cp_3', '$order_code')");

                      }

                  }



                  if ($product4 > 0) {

                     $select_query_4 = "select * from products where product_id='4'";

                      $run_4 = mysqli_query($con,$select_query_4);

                      $num_right_4_4 = mysqli_num_rows($run_4);

                       $serial_payment = 1;

                       while ($row_4 = mysqli_fetch_array($run_4)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_4['product_id'];

                        $product_title = $row_4['product_title'];

                        $cp = $row_4['cp'];

                        $bv = $row_4['bv'];

                        $mrp = $row_4['mrp'];

                        $image = $row_4['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product4', '$total_amount_4', '$total_bv_4', '$total_cp_4', '$order_code')");

                      }

                  }



                  if ($product5 > 0) {

                     $select_query_5 = "select * from products where product_id='5'";

                      $run_5 = mysqli_query($con,$select_query_5);

                      $num_right_5_5 = mysqli_num_rows($run_5);

                       $serial_payment = 1;

                       while ($row_5 = mysqli_fetch_array($run_5)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_5['product_id'];

                        $product_title = $row_5['product_title'];

                        $cp = $row_5['cp'];

                        $bv = $row_5['bv'];

                        $mrp = $row_5['mrp'];

                        $image = $row_5['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product5', '$total_amount_5', '$total_bv_5', '$total_cp_5', '$order_code')");

                      }

                  }



                  if ($product6 > 0) {

                     $select_query_6 = "select * from products where product_id='6'";

                      $run_6 = mysqli_query($con,$select_query_6);

                      $num_right_6_6 = mysqli_num_rows($run_6);

                       $serial_payment = 1;

                       while ($row_6 = mysqli_fetch_array($run_6)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_6['product_id'];

                        $product_title = $row_6['product_title'];

                        $cp = $row_6['cp'];

                        $bv = $row_6['bv'];

                        $mrp = $row_6['mrp'];

                        $image = $row_6['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product6', '$total_amount_6', '$total_bv_6', '$total_cp_6', '$order_code')");

                      }

                  }

                  if ($product7 > 0) {

                     $select_query_7 = "select * from products where product_id='7'";

                      $run_7 = mysqli_query($con,$select_query_7);

                      $num_right_7_7 = mysqli_num_rows($run_7);

                       $serial_payment = 1;

                       while ($row_7 = mysqli_fetch_array($run_7)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_7['product_id'];

                        $product_title = $row_7['product_title'];

                        $cp = $row_7['cp'];

                        $bv = $row_7['bv'];

                        $mrp = $row_7['mrp'];

                        $image = $row_7['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product7', '$total_amount_7', '$total_bv_7', '$total_cp_7', '$order_code')");

                      }

                  }



                  if ($product8 > 0) {

                     $select_query_8 = "select * from products where product_id='8'";

                      $run_8 = mysqli_query($con,$select_query_8);

                      $num_right_8_8 = mysqli_num_rows($run_8);

                       $serial_payment = 1;

                       while ($row_8 = mysqli_fetch_array($run_8)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_8['product_id'];

                        $product_title = $row_8['product_title'];

                        $cp = $row_8['cp'];

                        $bv = $row_8['bv'];

                        $mrp = $row_8['mrp'];

                        $image = $row_8['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product8', '$total_amount_8', '$total_bv_8', '$total_cp_8', '$order_code')");

                      }

                  }



                  if ($product9 > 0) {

                     $select_query_9 = "select * from products where product_id='9'";

                      $run_9 = mysqli_query($con,$select_query_9);

                      $num_right_9_9 = mysqli_num_rows($run_9);

                       $serial_payment = 1;

                       while ($row_9 = mysqli_fetch_array($run_9)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_9['product_id'];

                        $product_title = $row_9['product_title'];

                        $cp = $row_9['cp'];

                        $bv = $row_9['bv'];

                        $mrp = $row_9['mrp'];

                        $image = $row_9['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product9', '$total_amount_9', '$total_bv_9', '$total_cp_9', '$order_code')");

                      }

                  }



                  if ($product10 > 0) {

                     $select_query_10 = "select * from products where product_id='10'";

                      $run_10 = mysqli_query($con,$select_query_10);

                      $num_right_10_10 = mysqli_num_rows($run_10);

                       $serial_payment = 1;

                       while ($row_10 = mysqli_fetch_array($run_10)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_10['product_id'];

                        $product_title = $row_10['product_title'];

                        $cp = $row_10['cp'];

                        $bv = $row_10['bv'];

                        $mrp = $row_10['mrp'];

                        $image = $row_10['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product10', '$total_amount_10', '$total_bv_10', '$total_cp_10', '$order_code')");

                      }

                  }



                  if ($product11 > 0) {

                     $select_query_11 = "select * from products where product_id='11'";

                      $run_11 = mysqli_query($con,$select_query_11);

                      $num_right_11_11 = mysqli_num_rows($run_11);

                       $serial_payment = 1;

                       while ($row_11 = mysqli_fetch_array($run_11)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_11['product_id'];

                        $product_title = $row_11['product_title'];

                        $cp = $row_11['cp'];

                        $bv = $row_11['bv'];

                        $mrp = $row_11['mrp'];

                        $image = $row_11['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product11', '$total_amount_11', '$total_bv_11', '$total_cp_11', '$order_code')");

                      }

                  }



                  if ($product12 > 0) {

                     $select_query_12 = "select * from products where product_id='12'";

                      $run_12 = mysqli_query($con,$select_query_12);

                      $num_right_12_12 = mysqli_num_rows($run_12);

                       $serial_payment = 1;

                       while ($row_12 = mysqli_fetch_array($run_12)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_12['product_id'];

                        $product_title = $row_12['product_title'];

                        $cp = $row_12['cp'];

                        $bv = $row_12['bv'];

                        $mrp = $row_12['mrp'];

                        $image = $row_12['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product12', '$total_amount_12', '$total_bv_12', '$total_cp_12', '$order_code')");

                      }

                  }





                  if ($product13 > 0) {

                     $select_query_13 = "select * from products where product_id='13'";

                      $run_13 = mysqli_query($con,$select_query_13);

                      $num_right_13_13 = mysqli_num_rows($run_13);

                       $serial_payment = 1;

                       while ($row_13 = mysqli_fetch_array($run_13)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_13['product_id'];

                        $product_title = $row_13['product_title'];

                        $cp = $row_13['cp'];

                        $bv = $row_13['bv'];

                        $mrp = $row_13['mrp'];

                        $image = $row_13['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product13', '$total_amount_13', '$total_bv_13', '$total_cp_13', '$order_code')");

                      }

                  }





                  if ($product14 > 0) {

                     $select_query_14 = "select * from products where product_id='14'";

                      $run_14 = mysqli_query($con,$select_query_14);

                      $num_right_14_14 = mysqli_num_rows($run_14);

                       $serial_payment = 1;

                       while ($row_14 = mysqli_fetch_array($run_14)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_14['product_id'];

                        $product_title = $row_14['product_title'];

                        $cp = $row_14['cp'];

                        $bv = $row_14['bv'];

                        $mrp = $row_14['mrp'];

                        $image = $row_14['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product14', '$total_amount_14', '$total_bv_14', '$total_cp_14', '$order_code')");

                      }

                  }



                  if ($product15 > 0) {

                     $select_query_15 = "select * from products where product_id='15'";

                      $run_15 = mysqli_query($con,$select_query_15);

                      $num_right_15_15 = mysqli_num_rows($run_15);

                       $serial_payment = 1;

                       while ($row_15 = mysqli_fetch_array($run_15)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_15['product_id'];

                        $product_title = $row_15['product_title'];

                        $cp = $row_15['cp'];

                        $bv = $row_15['bv'];

                        $mrp = $row_15['mrp'];

                        $image = $row_15['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product15', '$total_amount_15', '$total_bv_15', '$total_cp_15', '$order_code')");

                      }

                  }





                  if ($product16 > 0) {

                     $select_query_16 = "select * from products where product_id='16'";

                      $run_16 = mysqli_query($con,$select_query_16);

                      $num_right_16_16 = mysqli_num_rows($run_16);

                       $serial_payment = 1;

                       while ($row_16 = mysqli_fetch_array($run_16)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_16['product_id'];

                        $product_title = $row_16['product_title'];

                        $cp = $row_16['cp'];

                        $bv = $row_16['bv'];

                        $mrp = $row_16['mrp'];

                        $image = $row_16['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product16', '$total_amount_16', '$total_bv_16', '$total_cp_16', '$order_code')");

                      }

                  }





                  if ($product17 > 0) {

                     $select_query_17 = "select * from products where product_id='17'";

                      $run_17 = mysqli_query($con,$select_query_17);

                      $num_right_17_17 = mysqli_num_rows($run_17);

                       $serial_payment = 1;

                       while ($row_17 = mysqli_fetch_array($run_17)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_17['product_id'];

                        $product_title = $row_17['product_title'];

                        $cp = $row_17['cp'];

                        $bv = $row_17['bv'];

                        $mrp = $row_17['mrp'];

                        $image = $row_17['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product17', '$total_amount_17', '$total_bv_17', '$total_cp_17', '$order_code')");

                      }

                  }



                  if ($product18 > 0) {

                     $select_query_18 = "select * from products where product_id='18'";

                      $run_18 = mysqli_query($con,$select_query_18);

                      $num_right_18_18 = mysqli_num_rows($run_18);

                       $serial_payment = 1;

                       while ($row_18 = mysqli_fetch_array($run_18)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_18['product_id'];

                        $product_title = $row_18['product_title'];

                        $cp = $row_18['cp'];

                        $bv = $row_18['bv'];

                        $mrp = $row_18['mrp'];

                        $image = $row_18['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product18', '$total_amount_18', '$total_bv_18', '$total_cp_18', '$order_code')");

                      }

                  }





                   if ($product19 > 0) {

                     $select_query_19 = "select * from products where product_id='19'";

                      $run_19 = mysqli_query($con,$select_query_19);

                      $num_right_19_19 = mysqli_num_rows($run_19);

                       $serial_payment = 1;

                       while ($row_19 = mysqli_fetch_array($run_19)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_19['product_id'];

                        $product_title = $row_19['product_title'];

                        $cp = $row_19['cp'];

                        $bv = $row_19['bv'];

                        $mrp = $row_19['mrp'];

                        $image = $row_19['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product19', '$total_amount_19', '$total_bv_19', '$total_cp_19', '$order_code')");

                      }

                  }





                  if ($product20 > 0) {

                     $select_query_20 = "select * from products where product_id='20'";

                      $run_20 = mysqli_query($con,$select_query_20);

                      $num_right_20_20 = mysqli_num_rows($run_20);

                       $serial_payment = 1;

                       while ($row_20 = mysqli_fetch_array($run_20)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_20['product_id'];

                        $product_title = $row_20['product_title'];

                        $cp = $row_20['cp'];

                        $bv = $row_20['bv'];

                        $mrp = $row_20['mrp'];

                        $image = $row_20['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product20', '$total_amount_20', '$total_bv_20', '$total_cp_20', '$order_code')");

                      }

                  }





                  if ($product21 > 0) {

                     $select_query_21 = "select * from products where product_id='21'";

                      $run_21 = mysqli_query($con,$select_query_21);

                      $num_right_21_21 = mysqli_num_rows($run_21);

                       $serial_payment = 1;

                       while ($row_21 = mysqli_fetch_array($run_21)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_21['product_id'];

                        $product_title = $row_21['product_title'];

                        $cp = $row_21['cp'];

                        $bv = $row_21['bv'];

                        $mrp = $row_21['mrp'];

                        $image = $row_21['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product21', '$total_amount_21', '$total_bv_21', '$total_cp_21', '$order_code')");

                      }

                  }





                  if ($product22 > 0) {

                     $select_query_22 = "select * from products where product_id='22'";

                      $run_22 = mysqli_query($con,$select_query_22);

                      $num_right_22_22 = mysqli_num_rows($run_22);

                       $serial_payment = 1;

                       while ($row_22 = mysqli_fetch_array($run_22)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_22['product_id'];

                        $product_title = $row_22['product_title'];

                        $cp = $row_22['cp'];

                        $bv = $row_22['bv'];

                        $mrp = $row_22['mrp'];

                        $image = $row_22['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product22', '$total_amount_22', '$total_bv_22', '$total_cp_22', '$order_code')");

                      }

                  }



                  if ($product23 > 0) {

                     $select_query_23 = "select * from products where product_id='23'";

                      $run_23 = mysqli_query($con,$select_query_23);

                      $num_right_23_23 = mysqli_num_rows($run_23);

                       $serial_payment = 1;

                       while ($row_23 = mysqli_fetch_array($run_23)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_23['product_id'];

                        $product_title = $row_23['product_title'];

                        $cp = $row_23['cp'];

                        $bv = $row_23['bv'];

                        $mrp = $row_23['mrp'];

                        $image = $row_23['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product23', '$total_amount_23', '$total_bv_23', '$total_cp_23', '$order_code')");

                      }

                  }





                  if ($product24 > 0) {

                     $select_query_24 = "select * from products where product_id='24'";

                      $run_24 = mysqli_query($con,$select_query_24);

                      $num_right_24_24 = mysqli_num_rows($run_24);

                       $serial_payment = 1;

                       while ($row_24 = mysqli_fetch_array($run_24)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_24['product_id'];

                        $product_title = $row_24['product_title'];

                        $cp = $row_24['cp'];

                        $bv = $row_24['bv'];

                        $mrp = $row_24['mrp'];

                        $image = $row_24['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product24', '$total_amount_24', '$total_bv_24', '$total_cp_24', '$order_code')");

                      }

                  }



                  if ($product25 > 0) {

                     $select_query_25 = "select * from products where product_id='25'";

                      $run_25 = mysqli_query($con,$select_query_25);

                      $num_right_25_25 = mysqli_num_rows($run_25);

                       $serial_payment = 1;

                       while ($row_25 = mysqli_fetch_array($run_25)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_25['product_id'];

                        $product_title = $row_25['product_title'];

                        $cp = $row_25['cp'];

                        $bv = $row_25['bv'];

                        $mrp = $row_25['mrp'];

                        $image = $row_25['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product25', '$total_amount_25', '$total_bv_25', '$total_cp_25', '$order_code')");

                      }

                  }





                  if ($product26 > 0) {

                     $select_query_26 = "select * from products where product_id='26'";

                      $run_26 = mysqli_query($con,$select_query_26);

                      $num_right_26_26 = mysqli_num_rows($run_26);

                       $serial_payment = 1;

                       while ($row_26 = mysqli_fetch_array($run_26)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_26['product_id'];

                        $product_title = $row_26['product_title'];

                        $cp = $row_26['cp'];

                        $bv = $row_26['bv'];

                        $mrp = $row_26['mrp'];

                        $image = $row_26['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product26', '$total_amount_26', '$total_bv_26', '$total_cp_26', '$order_code')");

                      }

                  }



                  if ($product27 > 0) {

                     $select_query_27 = "select * from products where product_id='27'";

                      $run_27 = mysqli_query($con,$select_query_27);

                      $num_right_27_27 = mysqli_num_rows($run_27);

                       $serial_payment = 1;

                       while ($row_27 = mysqli_fetch_array($run_27)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_27['product_id'];

                        $product_title = $row_27['product_title'];

                        $cp = $row_27['cp'];

                        $bv = $row_27['bv'];

                        $mrp = $row_27['mrp'];

                        $image = $row_27['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product27', '$total_amount_27', '$total_bv_27', '$total_cp_27', '$order_code')");

                      }

                  }



                  if ($product28 > 0) {

                     $select_query_28 = "select * from products where product_id='28'";

                      $run_28 = mysqli_query($con,$select_query_28);

                      $num_right_28_28 = mysqli_num_rows($run_28);

                       $serial_payment = 1;

                       while ($row_28 = mysqli_fetch_array($run_28)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_28['product_id'];

                        $product_title = $row_28['product_title'];

                        $cp = $row_28['cp'];

                        $bv = $row_28['bv'];

                        $mrp = $row_28['mrp'];

                        $image = $row_28['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product28', '$total_amount_28', '$total_bv_28', '$total_cp_28', '$order_code')");

                      }

                  }



                  if ($product29 > 0) {

                     $select_query_29 = "select * from products where product_id='29'";

                      $run_29 = mysqli_query($con,$select_query_29);

                      $num_right_29_29 = mysqli_num_rows($run_29);

                       $serial_payment = 1;

                       while ($row_29 = mysqli_fetch_array($run_29)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_29['product_id'];

                        $product_title = $row_29['product_title'];

                        $cp = $row_29['cp'];

                        $bv = $row_29['bv'];

                        $mrp = $row_29['mrp'];

                        $image = $row_29['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product29', '$total_amount_29', '$total_bv_29', '$total_cp_29', '$order_code')");

                      }

                  }



                  if ($product30 > 0) {

                     $select_query_30 = "select * from products where product_id='30'";

                      $run_30 = mysqli_query($con,$select_query_30);

                      $num_right_30_30 = mysqli_num_rows($run_30);

                       $serial_payment = 1;

                       while ($row_30 = mysqli_fetch_array($run_30)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_30['product_id'];

                        $product_title = $row_30['product_title'];

                        $cp = $row_30['cp'];

                        $bv = $row_30['bv'];

                        $mrp = $row_30['mrp'];

                        $image = $row_30['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product30', '$total_amount_30', '$total_bv_30', '$total_cp_30', '$order_code')");

                      }

                  }



                  if ($product31 > 0) {

                     $select_query_31 = "select * from products where product_id='31'";

                      $run_31 = mysqli_query($con,$select_query_31);

                      $num_right_31_31 = mysqli_num_rows($run_31);

                       $serial_payment = 1;

                       while ($row_31 = mysqli_fetch_array($run_31)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_31['product_id'];

                        $product_title = $row_31['product_title'];

                        $cp = $row_31['cp'];

                        $bv = $row_31['bv'];

                        $mrp = $row_31['mrp'];

                        $image = $row_31['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product31', '$total_amount_31', '$total_bv_31', '$total_cp_31', '$order_code')");

                      }

                  }



                  if ($product32 > 0) {

                     $select_query_32 = "select * from products where product_id='32'";

                      $run_32 = mysqli_query($con,$select_query_32);

                      $num_right_32_32 = mysqli_num_rows($run_32);

                       $serial_payment = 1;

                       while ($row_32 = mysqli_fetch_array($run_32)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_32['product_id'];

                        $product_title = $row_32['product_title'];

                        $cp = $row_32['cp'];

                        $bv = $row_32['bv'];

                        $mrp = $row_32['mrp'];

                        $image = $row_32['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product32', '$total_amount_32', '$total_bv_32', '$total_cp_32', '$order_code')");

                      }

                  }



                  if ($product33 > 0) {

                     $select_query_33 = "select * from products where product_id='33'";

                      $run_33 = mysqli_query($con,$select_query_33);

                      $num_right_33_33 = mysqli_num_rows($run_33);

                       $serial_payment = 1;

                       while ($row_33 = mysqli_fetch_array($run_33)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_33['product_id'];

                        $product_title = $row_33['product_title'];

                        $cp = $row_33['cp'];

                        $bv = $row_33['bv'];

                        $mrp = $row_33['mrp'];

                        $image = $row_33['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product33', '$total_amount_33', '$total_bv_33', '$total_cp_33', '$order_code')");

                      }

                  }



                  if ($product34 > 0) {

                     $select_query_34 = "select * from products where product_id='34'";

                      $run_34 = mysqli_query($con,$select_query_34);

                      $num_right_34_34 = mysqli_num_rows($run_34);

                       $serial_payment = 1;

                       while ($row_34 = mysqli_fetch_array($run_34)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_34['product_id'];

                        $product_title = $row_34['product_title'];

                        $cp = $row_34['cp'];

                        $bv = $row_34['bv'];

                        $mrp = $row_34['mrp'];

                        $image = $row_34['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product34', '$total_amount_34', '$total_bv_34', '$total_cp_34', '$order_code')");

                      }

                  }



                  if ($product35 > 0) {

                     $select_query_35 = "select * from products where product_id='35'";

                      $run_35 = mysqli_query($con,$select_query_35);

                      $num_right_35_35 = mysqli_num_rows($run_35);

                       $serial_payment = 1;

                       while ($row_35 = mysqli_fetch_array($run_35)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_35['product_id'];

                        $product_title = $row_35['product_title'];

                        $cp = $row_35['cp'];

                        $bv = $row_35['bv'];

                        $mrp = $row_35['mrp'];

                        $image = $row_35['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product35', '$total_amount_35', '$total_bv_35', '$total_cp_35', '$order_code')");

                      }

                  }



                  if ($product36 > 0) {

                     $select_query_36 = "select * from products where product_id='36'";

                      $run_36 = mysqli_query($con,$select_query_36);

                      $num_right_36_36 = mysqli_num_rows($run_36);

                       $serial_payment = 1;

                       while ($row_36 = mysqli_fetch_array($run_36)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_36['product_id'];

                        $product_title = $row_36['product_title'];

                        $cp = $row_36['cp'];

                        $bv = $row_36['bv'];

                        $mrp = $row_36['mrp'];

                        $image = $row_36['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product36', '$total_amount_36', '$total_bv_36', '$total_cp_36', '$order_code')");

                      }

                  }



                  if ($product37 > 0) {

                     $select_query_37 = "select * from products where product_id='37'";

                      $run_37 = mysqli_query($con,$select_query_37);

                      $num_right_37_37 = mysqli_num_rows($run_37);

                       $serial_payment = 1;

                       while ($row_37 = mysqli_fetch_array($run_37)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_37['product_id'];

                        $product_title = $row_37['product_title'];

                        $cp = $row_37['cp'];

                        $bv = $row_37['bv'];

                        $mrp = $row_37['mrp'];

                        $image = $row_37['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product37', '$total_amount_37', '$total_bv_37', '$total_cp_37', '$order_code')");

                      }

                  }



                  if ($product38 > 0) {

                     $select_query_38 = "select * from products where product_id='38'";

                      $run_38 = mysqli_query($con,$select_query_38);

                      $num_right_38_38 = mysqli_num_rows($run_38);

                       $serial_payment = 1;

                       while ($row_38 = mysqli_fetch_array($run_38)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_38['product_id'];

                        $product_title = $row_38['product_title'];

                        $cp = $row_38['cp'];

                        $bv = $row_38['bv'];

                        $mrp = $row_38['mrp'];

                        $image = $row_38['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product38', '$total_amount_38', '$total_bv_38', '$total_cp_38', '$order_code')");

                      }

                  }



                  if ($product39 > 0) {

                     $select_query_39 = "select * from products where product_id='39'";

                      $run_39 = mysqli_query($con,$select_query_39);

                      $num_right_39_39 = mysqli_num_rows($run_39);

                       $serial_payment = 1;

                       while ($row_39 = mysqli_fetch_array($run_39)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_39['product_id'];

                        $product_title = $row_39['product_title'];

                        $cp = $row_39['cp'];

                        $bv = $row_39['bv'];

                        $mrp = $row_39['mrp'];

                        $image = $row_39['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product39', '$total_amount_39', '$total_bv_39', '$total_cp_39', '$order_code')");

                      }

                  }



                  if ($product40 > 0) {

                     $select_query_40 = "select * from products where product_id='40'";

                      $run_40 = mysqli_query($con,$select_query_40);

                      $num_right_40_40 = mysqli_num_rows($run_40);

                       $serial_payment = 1;

                       while ($row_40 = mysqli_fetch_array($run_40)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_40['product_id'];

                        $product_title = $row_40['product_title'];

                        $cp = $row_40['cp'];

                        $bv = $row_40['bv'];

                        $mrp = $row_40['mrp'];

                        $image = $row_40['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product40', '$total_amount_40', '$total_bv_40', '$total_cp_40', '$order_code')");

                      }

                  }



                  if ($product41 > 0) {

                     $select_query_41 = "select * from products where product_id='41'";

                      $run_41 = mysqli_query($con,$select_query_41);

                      $num_right_41_41 = mysqli_num_rows($run_41);

                       $serial_payment = 1;

                       while ($row_41 = mysqli_fetch_array($run_41)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_41['product_id'];

                        $product_title = $row_41['product_title'];

                        $cp = $row_41['cp'];

                        $bv = $row_41['bv'];

                        $mrp = $row_41['mrp'];

                        $image = $row_41['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product41', '$total_amount_41', '$total_bv_41', '$total_cp_41', '$order_code')");

                      }

                  }


                  if ($product42 > 0) {

                     $select_query_42 = "select * from products where product_id='42'";

                      $run_42 = mysqli_query($con,$select_query_42);

                      $num_right_42_42 = mysqli_num_rows($run_42);

                       $serial_payment = 1;

                       while ($row_42 = mysqli_fetch_array($run_42)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_42['product_id'];

                        $product_title = $row_42['product_title'];

                        $cp = $row_42['cp'];

                        $bv = $row_42['bv'];

                        $mrp = $row_42['mrp'];

                        $image = $row_42['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product42', '$total_amount_42', '$total_bv_42', '$total_cp_42', '$order_code')");

                      }

                  }

                  if ($product43 > 0) {

                     $select_query_43 = "select * from products where product_id='43'";

                      $run_43 = mysqli_query($con,$select_query_43);

                      $num_right_43_43 = mysqli_num_rows($run_43);

                       $serial_payment = 1;

                       while ($row_43 = mysqli_fetch_array($run_43)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_43['product_id'];

                        $product_title = $row_43['product_title'];

                        $cp = $row_43['cp'];

                        $bv = $row_43['bv'];

                        $mrp = $row_43['mrp'];

                        $image = $row_43['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product43', '$total_amount_43', '$total_bv_43', '$total_cp_43', '$order_code')");

                      }

                  }

                  if ($product44 > 0) {

                     $select_query_44 = "select * from products where product_id='44'";

                      $run_44 = mysqli_query($con,$select_query_44);

                      $num_right_44_44 = mysqli_num_rows($run_44);

                       $serial_payment = 1;

                       while ($row_44 = mysqli_fetch_array($run_44)) {

                        $s_num_payment = $serial_payment++;

                        $product_id = $row_44['product_id'];

                        $product_title = $row_44['product_title'];

                        $cp = $row_44['cp'];

                        $bv = $row_44['bv'];

                        $mrp = $row_44['mrp'];

                        $image = $row_44['image'];





                        mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no', '$user_id', '$product_id', '$product44', '$total_amount_44', '$total_bv_44', '$total_cp_44', '$order_code')");

                      }

                  }







                    $_SESSION['order_code'] = $order_code;



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

                }



         

      }





      

 ?>

<?php } ?>