| 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($_SESSION['order_code'])) {
$page_check_id = $_SESSION['order_code'];
$select_query_payment = "select * from product_check where order_code='$page_check_id' ORDER BY check_id ASC";
$run_payment = mysqli_query($con,$select_query_payment);
$serial_payment = 1;
while ($row_payment = mysqli_fetch_array($run_payment)) {
$s_num_payment = $serial_payment++;
$check_id = $row_payment['check_id'];
$member_no = $row_payment['member_no'];
$user_id = $row_payment['user_id'];
$product_code = $row_payment['product_code'];
$date_of_join_1 = $row_payment['date'];
$date = date('d-m-Y', strtotime($date_of_join_1));
$bank_prof = $row_payment['bank_prof'];
$mmonth = $row_payment['month'];
$yyear = $row_payment['year'];
$status = $row_payment['status'];
$issue_date = $row_payment['issue_date'];
$delivery_details = $row_payment['delivery_details'];
$qty = $row_payment['qty'];
$total_amount = $row_payment['total_amount'];
$bank_name = $row_payment['bank_name'];
$time = $row_payment['time'];
$payment_method = $row_payment['payment_method'];
$remark = $row_payment['remark'];
$bv_1 = $row_payment['bv'];
$cpfinal = $row_payment['cp'];
$order_code_1 = $row_payment['order_code'];
$create_by_1 = $row_payment['create_by'];
$delivery_type_1 = $row_payment['delivery_type'];
$delivery_address_1 = $row_payment['delivery_address'];
$random_no_1 = $row_payment['random_no'];
$voucher_1 = $row_payment['voucher'];
$final_bill = $cpfinal-$voucher_1;
$select_query = "select * from products where product_id='$product_code'";
$run = mysqli_query($con,$select_query);
$num_right_1 = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$cp = $row['cp'];
$bv = $row['bv'];
$mrp = $row['mrp'];
$image = $row['image'];
}
$select_query_view = "select * from member where member_no='$member_no'";
$run_view = mysqli_query($con,$select_query_view);
while ($row_view = mysqli_fetch_array($run_view)) {
$user_id_view = $row_view['user_id'];
$name_view = $row_view['name'];
$address_1_view = $row_view['address_1'];
$address_2_view = $row_view['address_2'];
$town_area_view = $row_view['town_area'];
$city_district_view = $row_view['city_district'];
$state_view = $row_view['state'];
$country_view = $row_view['country'];
$pincode_view = $row_view['pincode'];
$address_1_view_f = $row_view['address_1_f'];
$address_2_view_f = $row_view['address_2_f'];
$town_area_view_f = $row_view['town_area_f'];
$city_district_view_f = $row_view['city_district_f'];
$state_view_f = $row_view['state_f'];
$country_view_f = $row_view['country_f'];
$pincode_view_f = $row_view['pincode_f'];
$mobile_number_f = $row_view['mobile_number_f'];
$mobile_number_view = $row_view['mobile_number'];
$pan_card_view = $row_view['pan_card'];
$percent_view = $row_view['percent'];
}
$select_query_main = "select * from roi_tree where member_no='$member_no' ORDER BY tree_id ASC limit 1";
$run_main = mysqli_query($con,$select_query_main);
while ($row_main = mysqli_fetch_array($run_main)) {
$tree_id_main = $row_main['tree_id'];
$group_number_main = $row_main['group_number'];
$member_no_main = $row_main['member_no'];
$user_id_main = $row_main['user_id'];
$sponsor_no_main = $row_main['sponsor_no'];
$relation_ship_no_main = $row_main['relation_ship_no'];
$level_no_main = $row_main['level_no'];
$x_position_main = $row_main['x_position']+1;
$y_position_main = $row_main['y_position'];
$roi_amount_main = $row_main['roi_amount'];
$roi_status_main = $row_main['roi_status'];
$total_bv_main = $row_main['total_bv'];
}
$select_query_total_team_pv_cur_pro = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";
$run_total_team_pv_cur_pro = mysqli_query($con,$select_query_total_team_pv_cur_pro);
while($row_total_team_pv_cur_pro = mysqli_fetch_array($run_total_team_pv_cur_pro)){
$total_team_pv_cur_pro_1 = $row_total_team_pv_cur_pro['SUM(product_amount)'];
}
$arr1_10a_pro = array();
$select_query_findempty_pay_10a_pro = "select * from product_member where member_no = '$member_no_main'";
$run_findempty_pay_10a_pro = mysqli_query($con,$select_query_findempty_pay_10a_pro);
while ($row_findempty_pay_10a_pro = mysqli_fetch_array($run_findempty_pay_10a_pro)) {
$arr1_10a_pro[] = $row_findempty_pay_10a_pro['used_no'];
}
//get_product_bv
$select_query_per_product_x1_10a = "select SUM(product_amount) from product_tree where member_no='$member_no_main' AND status='0' AND date <= '$date_of_join_1'";
$run_per_product_x1_10a = mysqli_query($con,$select_query_per_product_x1_10a);
while($row_per_product_x1_10a = mysqli_fetch_array($run_per_product_x1_10a)){
$product_amount_main = $row_per_product_x1_10a['SUM(product_amount)'];
}
if ($roi_status_main == 0) {
$personal_pv_join = $roi_amount_main;
$old_vv = 0;
}
else {
$personal_pv_join = 0;
$old_vv = $roi_amount_main;
}
$total_old_bv = $personal_pv_join+$product_amount_main+$old_vv;
$arr1 = array();
$select_query_findempty_pay = "select * from roi_member where member_no = '$member_no_main'";
$run_findempty_pay = mysqli_query($con,$select_query_findempty_pay);
while ($row_findempty_pay = mysqli_fetch_array($run_findempty_pay)) {
$arr1[] = $row_findempty_pay['used_no'];
}
$select_query_third_level_team = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND member_no not in (".implode(',', $arr1).")";
$run_third_level_team = mysqli_query($con,$select_query_third_level_team);
while($row_third_level_team = mysqli_fetch_array($run_third_level_team)){
$total_single_leg_1 = $row_third_level_team['SUM(roi_amount)'];
}
$total_single_leg_current_view = $total_team_pv_cur_pro_1+$total_single_leg_1+$personal_pv_join+$product_amount_main;
}
$select_query_total_team_pv = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND date <= '$date_of_join_1'";
$run_total_team_pv = mysqli_query($con,$select_query_total_team_pv);
while($row_total_team_pv = mysqli_fetch_array($run_total_team_pv)){
$total_team_pv_1 = $row_total_team_pv['SUM(roi_amount)'];
}
//products
$select_query_total_team_pv_pro = "select SUM(level_roi), SUM(binary_income), SUM(referral_income), SUM(car_bonus) from week_payout where member_no = '$member_no'";
$run_total_team_pv_pro = mysqli_query($con,$select_query_total_team_pv_pro);
while($row_total_team_pv_pro = mysqli_fetch_array($run_total_team_pv_pro)){
$total_team_pv_pro_1 = $row_total_team_pv_pro['SUM(level_roi)'];
$total_team_pv_old_binary = $row_total_team_pv_pro['SUM(binary_income)'];
$total_team_pv_proold_ref = $row_total_team_pv_pro['SUM(referral_income)'];
$total_team_pv_car_bonus = $row_total_team_pv_pro['SUM(car_bonus)'];
}
$arr1_10a_pro = array();
$select_query_findempty_pay_10a_pro = "select * from product_member where member_no = '$member_no_main'";
$run_findempty_pay_10a_pro = mysqli_query($con,$select_query_findempty_pay_10a_pro);
while ($row_findempty_pay_10a_pro = mysqli_fetch_array($run_findempty_pay_10a_pro)) {
$arr1_10a_pro[] = $row_findempty_pay_10a_pro['used_no'];
}
//get_product_bv
$select_query_per_product_x1_10a = "select SUM(product_amount) from product_tree where member_no='$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";
$run_per_product_x1_10a = mysqli_query($con,$select_query_per_product_x1_10a);
while($row_per_product_x1_10a = mysqli_fetch_array($run_per_product_x1_10a)){
$p_per_product_x1_10a = $row_per_product_x1_10a['SUM(product_amount)'];
}
$select_query_cur_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND month='$mmonth' AND year='$yyear' AND status='0' AND date <= '$date_of_join_1'";
$run_cur_product_x1_10a = mysqli_query($con,$select_query_cur_product_x1_10a);
while($row_cur_product_x1_10a = mysqli_fetch_array($run_cur_product_x1_10a)){
$p_cur_product_x1_10a = $row_cur_product_x1_10a['SUM(product_amount)'];
}
$select_query_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND date <= '$date_of_join_1'";
$run_product_x1_10a = mysqli_query($con,$select_query_product_x1_10a);
while($row_product_x1_10a = mysqli_fetch_array($run_product_x1_10a)){
$p_product_x1_10a = $row_product_x1_10a['SUM(product_amount)'];
}
//get_product_bv
$total_team_pv = $total_team_pv_1+$p_product_x1_10a;
//products
$arr1 = array();
$select_query_findempty_pay = "select * from roi_member where member_no = '$member_no_main'";
$run_findempty_pay = mysqli_query($con,$select_query_findempty_pay);
while ($row_findempty_pay = mysqli_fetch_array($run_findempty_pay)) {
$arr1[] = $row_findempty_pay['used_no'];
}
$select_query_third_level_team = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND month='$mmonth' AND year='$yyear' AND date <= '$date_of_join_1'";
$run_third_level_team = mysqli_query($con,$select_query_third_level_team);
while($row_third_level_team = mysqli_fetch_array($run_third_level_team)){
$total_single_leg_1 = $row_third_level_team['SUM(roi_amount)'];
}
$total_single_leg_current_view = $total_single_leg_1+$personal_pv_join+$p_cur_product_x1_10a;
$current_month_total = $total_team_pv - $total_single_leg_current_view;
?>
<!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 | INVOICE</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" />
<!-- favicon -->
<link rel="shortcut icon" href="assets/img/favicon.ico" />
<style type="text/css" media="print">
@page
{
size: auto; /* auto is the initial value */
margin: 0mm; /* this affects the margin in the printer settings */
}
</style>
<style type="text/css">
th, td {
font-size: 14px !important;
border:none !important;
}
.table td, .table th {
border: 1px solid #555 !important;
}
hr{
border-color:#555 !important;
}
.table thead th {
}
.table td {
border-bottom: none !important;
border-top: none !important;
}
.table td:last-child{
}
.table td, .table th, .card .table td, .card .table th, .card .dataTable td, .card .dataTable th {
padding: 3px 3px !important;
vertical-align: middle;
}
.text-muted {
color:rgba(0,0,0,.87) !important;
}
</style>
</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">
<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">
<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="stock_mangement.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Stock Management</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 active">
<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 active">
<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>
<!-- start page content -->
<div class="page-content-wrapper">
<div class="page-content">
<div class="page-bar">
<div class="page-title-breadcrumb">
<ol class="breadcrumb page-breadcrumb pull-right">
<li><i class="fa fa-home"></i> <a class="parent-item" href="main_home.php">Home</a> <i class="fa fa-angle-right"></i>
</li>
</li>
<li class="active">Invoice</li>
</ol>
</div>
</div>
<div class="text-right invoicew">
<a href="invoice_address.php?check_id=<?= $member_no; ?>" class="btn btn-success btn-outline">GET ADDRESS</a>
<button onclick="printDiv('print_image')" class="btn btn-danger btn-outline" type="button" id="closes">
<span>
<i class="fa fa-print">
</i>
Print</span>
</button>
</div>
<div class="row" id="print_image">
<div class="col-md-12">
<div class="white-box">
<div style="max-width: 750px;border: 1px solid #555;padding: 0;margin-top: 10px;">
<p style="position:absolute;top: 7px;text-align:right;right: 205px;margin-bottom:0;"><span>CUSTOMER</span></p>
<div class="row">
<div class="col-md-12">
<div class="text-center" style="padding-top: 0px;">
<div class="row">
<div class="col-sm-12">
<address style="margin-bottom:0px;">
<img src="../images/resources/logo.png" style="width: 35px;position: absolute;left: 60px;top:10px;" alt="logo" class="logo-default">
<div style="display: inline-block;" class="text-center">
<h3 class="font-bold" style="margin: 0;font-size: 14px !important;margin-bottom: -10px;">RAKCHA BLOOMING FMCG PRIVATE LTD.,</h3>
<p class="text-muted m-l-5" style="font-size: 9px;line-height: 13px;">
456/123 IInd FLOOR, ANGAMMAL COLONY, SALEM - 636 009.
<br> EMAIL : info@rakcha.in, WEB:www.rakcha.in.</p>
</div>
<div class="contact_header" style="position: absolute;right: 30px;top: 0;text-align: left;top: 12px;">
<p class="m-l-5" style="font-size: 10px;line-height: 12px;">
GST: 33AAJCR5310G2ZN<br>
CIN: U52399TZ2019TC031969<br>
CELL NO : 93444 76926
</p>
</div>
</address>
</div>
<div class="col-md-12">
<div style="border-top: 1px solid #555;">
<div class="row">
<div class="col-6" style="border-right: 1px solid #555;text-align: left !important;padding-left: 20px;padding-top: 5px;padding-right:15px;">
<div>
<p class=" addr-font-h4" style="font-size: 12px !important;margin-bottom: 0;line-height: 15px;">
<span style="width:60px;display: inline-block;"> SOLD TO </span>: <span><?= $name_view; ?></span><br>
<span style="padding-left: 76px;"><?= $user_id_view; ?></span></p>
<p class="text-muted m-l-30" style="font-size: 12px !important;line-height: 15px;padding-left: 76px;">
<?= $address_1_view; ?> <br>
<?= $address_2_view; ?>,<br>
<?= $city_district_view; ?>, <?= $state_view; ?>,<br> Pincode - <?= $pincode_view; ?>. <br> PH-<?= $mobile_number_view; ?></p>
</div>
</div>
<div class="col-6 text-left" style="padding-left:0;">
<div style="font-size: 12px;line-height: 15px;"">
<p class="text-left addr-font-h4" style="font-size: 11px !important;margin-bottom: 0;line-height: 15px;padding-top: 5px;padding-left: 15px;">
<span style="width:100px;display: inline-block;font-size: 11px !important;">
PAYMENT TYPE </span>:
<?= $payment_method; ?>
<br>
<span style="width:100px;display: inline-block;font-size: 11px !important;">
CREATE BY </span>:
<?= $create_by_1; ?>
<br>
<span style="width:100px;display: inline-block;font-size: 11px !important;">
INVOICE DATE </span>:
<?= $date; ?>
<br>
<span style="width:100px;display: inline-block;font-size: 11px !important;">
INVOICE NO </span>:
<?= $random_no_1; ?>
<br>
<span style="width:100px;display: inline-block;font-size: 11px !important;">
PO/SO NO </span>:
-
<br>
<span style="width:100px;display: inline-block;font-size: 11px !important;">
GROSS WEIGHT </span>:
-
<br>
<span style="width:100px;display: inline-block;font-size: 11px !important;">
PV </span>:
-
<br>
<span style="width:100px;display: inline-block;">
TOTAL GV </span>:
-
</p>
</div>
</div>
</div>
</div>
<div class="clearfix">
</div>
</div>
</div>
</div>
</div>
<div class="col-md-12">
<div class="table-responsive m-t-40" style="padding: 0px;">
<table class="table table-hover" style="margin-bottom:0;">
<thead>
<tr style="background-color: #eee;border: none;">
<th class="text-center" rowspan="2" style="vertical-align: middle !important;;">
S.NO</th>
<th class="text-center" rowspan="2" style="vertical-align: middle !important;;">
CODE</th>
<th class="text-center" rowspan="2" style='width:350px;vertical-align: middle;'>
DESCRIPTION OF PRODUCTS</th>
<th class="text-center" rowspan="2">
HSN<br>/SAC</th>
<th class="text-center" rowspan="2">
MRP<br><span style="font-size: 14px;">(Per Unit)</span></th>
<th class="text-center" rowspan="2">QTY</th>
<th class="text-center" colspan="3" style="border-right:none !important;">
AMOUNT</th>
</tr>
<tr>
<th class="text-center">
GROSS</th>
<th class="text-center">
DISC</th>
<th align="center;" style="width:100px;border-right:none !important;" class="text-center">
NET</th>
</tr>
</thead>
<tbody >
<?php
$select_query_1 = "select * from final_order where order_code='$order_code_1' AND member_no='$member_no'";
$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++;
$order_id_1 = $row_1['order_id'];
$member_no_1 = $row_1['member_no'];
$user_id_1 = $row_1['user_id'];
$product_code_1 = $row_1['product_code'];
$qty_1 = $row_1['qty'];
$total_amount_1 = $row_1['total_amount'];
$bv_1 = $row_1['bv'];
$cp_1 = $row_1['cp'];
$select_query_2 = "select * from products where product_id='$product_code_1'";
$run_2 = mysqli_query($con,$select_query_2);
$num_right_2_2 = mysqli_num_rows($run_2);
while ($row_2 = mysqli_fetch_array($run_2)) {
$product_id_2 = $row_2['product_id'];
$product_title_2 = $row_2['product_title'];
$cp_2 = $row_2['cp'];
$bv_2 = $row_2['bv'];
$mrp_2 = $row_2['mrp'];
$image_2 = $row_2['image'];
}
?>
<tr>
<td class="text-center">
<?= $s_num_payment; ?></td>
<td class="text-center">
RC<?= $product_id_2; ?></td>
<td class="text-left" style="text-transform: uppercase;">
<?= $product_title_2; ?></td>
<td class="text-center">-</td>
<td class="text-right">
<?= $mrp_2; ?></td>
<td class="text-right">
<?= $qty_1; ?></td>
<td class="text-right">
<?= $mrp_2*$qty_1; ?></td>
<td class="text-center">-</td>
<td class="text-right" style="border-right:none !important;">
<?= $mrp_2*$qty_1; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
<div class="col-md-12">
<div style="border-top: 1px solid #555;">
<div class="row">
<div class="col-4" style="border-right: 1px solid #555;">
<h4 style="font-size: 10px!important;margin: 0;padding-left: 20px;padding-top: 0px;">for <span>RAKCHABLOOMING FMCG PRIVATE LTD.,</span>
</h4>
</div>
<div class="col-4" style="border-right: 1px solid #555;">
<p style="font-size: 10px;padding-top: 5px;padding-left:5px;margin-bottom:0;line-height:14px;">
I/we accept the consignment which has been received in good condition
</p>
<h4 style="font-size: 11px !important;text-align:right;margin-right: 15px;margin-bottom:0;line-height:14px;">
<span>Received Signature</span>
</h4>
</div>
<div class="col-4">
<p style="font-size: 12px;line-height:15px;text-align: right;margin-bottom:0px;margin-top:5px;margin-right:5px;"><span style="font-size: 10px !important;">
SUB TOTAL = <span style="width:72px;display:inline-block;"> Rs. <?= $total_amount; ?></span></span></p>
<p style="font-size: 12px;line-height:15px;text-align: right;margin-bottom:0px;margin-right:5px;"> ORDER TOTAL = <span style="width:71px;display:inline-block;"> <b>Rs. <span style="font-size: 12px !important;"><?= $total_amount; ?> </b></span></span></p>
</div>
</div>
</div>
<div class="clearfix">
</div>
</div>
</div>
</div>
<div>
<h4 style="text-align: center;font-size: 10px !important;margin-right:160px;">
<span>Thank you! we appreciate your Business!!</span>
</h4>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- end page content -->
</div>
<!-- end page container -->
<!-- start footer -->
<div class="page-footer">
<div class="page-footer-inner"> 2018 © All Rights Reserved.
</div>
<div class="scroll-to-top">
<i class="icon-arrow-up"></i>
</div>
</div>
<!-- end footer -->
</div></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 type="text/javascript">
function fill(Value) {
$('#search').val(Value);
}
$(document).ready(function() {
$("#search").keyup(function() {
var name = $('#search').val();
if (name == "") {
}
else {
$.ajax({
type: "POST",
url: "searchbinary.php",
data: {
searchs: name
},
success: function(html) {
$("#receiver").html(html).show();
}
});
}
});
});
function printDiv(divName) {
var printContents = document.getElementById(divName).innerHTML;
var originalContents = document.body.innerHTML;
document.body.innerHTML = printContents;
window.print();
document.body.innerHTML = originalContents;
}
</script>
<!-- end js include path -->
</body>
</html>
<?php
if (isset($_POST['submit'])) {
$check_id = $_POST['check_id'];
$insert_query = "update product_check set relese='1', status='1' where check_id = '$check_id'";
if (mysqli_query($con,$insert_query)) {
echo "<script>alert('Product has been successfully Approved...')</script>";
echo "<script>window.open('company_roi.php','_self')</script>";
}
}
if (isset($_POST['delete'])) {
$id = $_POST['id'];
$delete_query_news = "delete from daily where id = '$id'";
if (mysqli_query($con,$delete_query_news)) {
echo "<script>alert('Updates has been deleted')</script>";
echo "<script>window.open('daily.php', '_self')</script>";
}
}
?>
<?php } } ?>