D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
rakcha
/
www
/
app
/
Filename :
payout_report.php
back
Copy
<?php session_start(); include("includes/database.php"); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport"> <title>RAKCHA SALES REPORT</title> <!-- General CSS Files --> <link rel="stylesheet" href="assets/css/app.min.css"> <!-- Template CSS --> <link rel="stylesheet" href="assets/bundles/datatables/datatables.min.css"> <link rel="stylesheet" href="assets/bundles/datatables/DataTables-1.10.16/css/dataTables.bootstrap4.min.css"> <link rel="stylesheet" href="assets/css/style.css"> <link rel="stylesheet" href="assets/css/components.css"> <!-- Custom style CSS --> <link rel="stylesheet" href="assets/css/custom.css"> <link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico' /> </head> <body> <div class="loader"></div> <div id="app"> <div class="main-wrapper main-wrapper-1"> <div class="navbar-bg"></div> <nav class="navbar navbar-expand-lg main-navbar"> <div class="form-inline mr-auto"> <ul class="navbar-nav mr-3"> <li><a href="#" data-toggle="sidebar" class="nav-link nav-link-lg collapse-btn"> <i data-feather="align-justify"></i></a></li> <li><a href="#" class="nav-link nav-link-lg fullscreen-btn"> <i data-feather="maximize"></i> </a></li> </ul> </div> <ul class="navbar-nav navbar-right"> <li><a href="#" class="nav-link nav-link-lg nav-link-user btn btn-primary" style="height:auto !important;margin-top:5px;">ADMIN</a> </li> </ul> </nav> <div class="main-sidebar sidebar-style-2"> <aside id="sidebar-wrapper"> <div class="sidebar-brand"> <a href="index.php"> <img alt="image" src="assets/img/logo.png" class="header-logo" style="max-width:70px;"> </a> </div> <ul class="sidebar-menu"> <li class="menu-header">MENU</li> <li> <a href="../admin/main_home.php" class="nav-link"><i data-feather="monitor"></i><span>Dashboard</span></a></li> </ul> </aside> </div> <!-- Main Content --> <div class="main-content"> <section class="section"> <div class="section-body"> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-header"> <h4>SALES REPORT</h4> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-striped table-hover" id="tableExport" style="width:100%;"> <thead> <tr> <th>S.No</th> <th>Date</th> <th>RC ID</th> <th>Name</th> <th>Amount</th> </tr> </thead> <tbody> <?php $select_query_payment = "select * from product_check where status='2' 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 = $row_payment['date']; $bank_prof = $row_payment['bank_prof']; $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']; $cp_1 = $row_payment['cp']; $order_code_1 = $row_payment['order_code']; $delivery_address_1 = $row_payment['delivery_address']; $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']; } ?> <tr class="gradeX"> <td><?= $s_num_payment; ?></td> <td><?= $date; ?></td> <td><?= $user_id_view; ?></td> <td><?= $name_view; ?></td> <td><?= $cp_1; ?></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </section> </div> <footer class="main-footer"> <div class="footer-left"> Copyright © 2021 <div class="bullet"></div> All Rights Reserved. </div> <div class="footer-right"> </div> </footer> </div> </div> <script src="assets/js/app.min.js"></script> <!-- JS Libraies --> <!-- Page Specific JS File --> <script src="assets/bundles/datatables/datatables.min.js"></script> <script src="assets/bundles/datatables/DataTables-1.10.16/js/dataTables.bootstrap4.min.js"></script> <script src="assets/bundles/datatables/export-tables/dataTables.buttons.min.js"></script> <script src="assets/bundles/datatables/export-tables/buttons.flash.min.js"></script> <script src="assets/bundles/datatables/export-tables/jszip.min.js"></script> <script src="assets/bundles/datatables/export-tables/pdfmake.min.js"></script> <script src="assets/bundles/datatables/export-tables/vfs_fonts.js"></script> <script src="assets/bundles/datatables/export-tables/buttons.print.min.js"></script> <script src="assets/js/page/datatables.js"></script> <!-- Template JS File --> <script src="assets/js/scripts.js"></script> <!-- Custom JS File --> <script src="assets/js/custom.js"></script> </body> </html>