| Server IP : 144.76.124.212 / Your IP : 216.73.216.138 Web Server : LiteSpeed System : Linux l4cp.vnetindia.com 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : rakcha ( 1356) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home5/rakcha/public_html/admin/ |
Upload File : |
<?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> <a class="parent-item" href="index.php">Home</a> <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 © 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 } ?>