1#@!#!123s

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

session_start();

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

    header("location: index.php");

 }

 else {

  include("includes/database.php");

  

    $page_user = $_SESSION['admin_name'];



   if (isset($_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_view = $row_view['mobile_number'];

        $mobile_number_f = $row_view['mobile_number_f'];

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

          }



          $first_day_this_month = date('Y-m-01'); // hard-coded '01' for first day

          $last_day_this_month  = date('Y-m-t');



          $select_query_per_product_x1_current_m = "select SUM(product_amount) from product_tree where member_no='$member_no_main' AND status='0' AND date <= '$last_day_this_month' AND date >= '$first_day_this_month'";

          $run_per_product_x1_current_m = mysqli_query($con,$select_query_per_product_x1_current_m);

          while($row_per_product_x1_current_m = mysqli_fetch_array($run_per_product_x1_current_m)){

                $product_amount_maincurrent_m = $row_per_product_x1_current_m['SUM(product_amount)'];

          }



          



    if ($roi_status_main == 0) {

             $personal_pv_join = $roi_amount_main;

             $old_vv = 0;

          }

          else {

            $personal_pv_join = 0;

            $old_vv = 0;

          }



          



          $total_old_bv = $personal_pv_join+$product_amount_maincurrent_m+$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>&nbsp;<a class="parent-item" href="main_home.php">Home</a>&nbsp;<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_bill_1.php?order_code=<?= $page_check_id; ?>" class="btn btn-primary btn-outline">Customer Invoice</a>

                             

                             <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>CONSULTANT</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>:&nbsp;&nbsp;&nbsp;&nbsp;<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>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                             <?= $payment_method; ?>



                                                             <br>

                                                             <span style="width:100px;display: inline-block;font-size: 11px !important;">

                                                             CREATE BY </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                             <?= $create_by_1; ?>



                                                             <br>


                                                          <span style="width:100px;display: inline-block;font-size: 11px !important;">

                                                             INVOICE DATE </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                             <?= $date; ?>



                                                             <br>

                                                             <span style="width:100px;display: inline-block;font-size: 11px !important;">

                                                             INVOICE NO </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                             <?= $random_no_1; ?>



                                                             <br>



                                                     

                                                             <span style="width:100px;display: inline-block;font-size: 11px !important;">

                                                             PO/SO NO </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                             -



                                                             <br>

                                                             <span style="width:100px;display: inline-block;font-size: 11px !important;">

                                                             GROSS WEIGHT </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                             -



                                                             <br>

                                                              



                                                            <span style="width:100px;display: inline-block;">

                                                             PV </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                            <span style="width:80px;display: inline-block;font-size: 11px !important;">Old : <?= $total_old_bv-$bv_1; ?></span>&nbsp;+&nbsp;<span style="width:80px;display: inline-block;font-size: 11px !important;">New <?= $bv_1; ?></span>&nbsp;=&nbsp;<?= $total_old_bv; ?>



                                                            

                                                             <br>



                                                             <?php if ($percent_view >= 9) { ?>



                                                              



                                                              <span style="width:100px;display: inline-block;">

                                                             TOTAL GV </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                            <span style="width:174px;display: inline-block;font-size: 11px !important;"> 9% [ New <?= $total_single_leg_current_view; ?>]</span>&nbsp;=&nbsp;<?= $total_single_leg_current_view; ?>  



                                                                 



                                                              <?php } else {

                                                                ?>



                                                                 

                                                                

                                                               <span style="width:100px;display: inline-block;">

                                                             TOTAL GV </span>:&nbsp;&nbsp;&nbsp;&nbsp;

                                                            <span style="width:80px;display: inline-block;font-size: 11px !important;">Old : <?= $current_month_total; ?></span>&nbsp;+&nbsp;<span style="width:80px;display: inline-block;font-size: 11px !important;">New <?= $total_single_leg_current_view; ?></span>&nbsp;=&nbsp;<?= $total_team_pv; ?>



                                                                <?php

                                                              } ?>



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

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

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

                        <td class="text-right">

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

                        <td class="text-right">

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

                        <td class="text-right">-</td>

                        <td class="text-right" style="border-right:none !important;">

                        <?= $cp_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 &nbsp;&nbsp;&nbsp;&nbsp;= <span style="width:72px;display:inline-block;"> Rs.&nbsp;&nbsp;&nbsp;&nbsp; <?= $cpfinal; ?></span></span></p>

                                          <p style="font-size: 12px;line-height:15px;text-align: right;margin-bottom:0px;margin-right:5px;"><span style="font-size: 10px !important;">

                                           [-] VOUCHER &nbsp;&nbsp;&nbsp;&nbsp;= <span style="width:72px;display:inline-block;"> Rs.&nbsp;&nbsp; <?= $voucher_1; ?></span></span></p>

                                          <p style="font-size: 12px;line-height:15px;text-align: right;margin-bottom:0px;margin-right:5px;"> ORDER TOTAL &nbsp;&nbsp;&nbsp;&nbsp;= <span style="width:71px;display:inline-block;"> <b>Rs. <span style="font-size: 12px !important;"><?= $final_bill; ?> </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 &copy; 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 } } ?>