| 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/app/ |
Upload File : |
<?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>