1#@!#!123s

: / home / budgetholidays / public_html / admin /
Filename : pending_vendor_amount.php
back
<?php
@ob_start();
session_start();
require_once 'config/config.php';
require_once 'config/helper.php';

if (!empty($_SESSION['logintype'])) {
    
if ($_SESSION['ibc'] != session_id()) {
header('Location: index.php');
exit;
}
} else {
header('Location: login.php');
exit;
}
$logintype = $_SESSION['logintype'];
$a_idchk = $_SESSION['a_id'];

$ausernmae = $_SESSION['a_name'];
ob_start("ob_html_compress");
$comp_select = $db->query("SELECT * FROM `admin`");
$comp_fetch = $comp_select->fetch_object();
$a_company = $comp_fetch->a_company;
$check_a_name = $_SESSION['a_name'];

?>

<?php include 'header.php'; ?>
<?php

?>
<div id="layoutSidenav_content">
<main>
<div class="container-fluid">
<h2 class="mt-30 page-title">Dashboard</h2>
<ol class="breadcrumb mb-30">
<li class="breadcrumb-item active">Dashboard</li>
</ol>

<div>

<h1 class="text-center">View Vendors pending Amount </h1>




<div class='table table-responsive'>
<table class='table'>
    
<tr>
<th>Sno</th>
<th>Date</th>
<th>Product name</th>
<th>Price</th>
<th>Qty</th>
<th>subtotal</th>
<th>Order id</th>
<th>customer name</th>
<th>status</th>

</tr>
    
<?php
$sno=1;
  $vd_id=$_GET['id'];
$usrs_dtl="select * from checkout where vendor_id='$vd_id' and status='order delivered' and vendor_pay_status IS NULL";
$qst_usrs_dtl=$db->query($usrs_dtl);
while($clct_usrs_dtl=$qst_usrs_dtl->fetch_assoc())
{
$qnty=$clct_usrs_dtl['quantity'];
$prec=$clct_usrs_dtl['price'];
$prd_id=$clct_usrs_dtl['product_id'];
$ord_id=$clct_usrs_dtl['order_id'];
$ord_det=$clct_usrs_dtl['order_date'];
$usr_idd=$clct_usrs_dtl['user_id'];
$ord_sts=$clct_usrs_dtl['status'];
$prrd_id=$clct_usrs_dtl['id'];

$prd_dtel="select * from all_product where id='$prd_id'";
$qst_prd_dtel=$db->query($prd_dtel);
$clct_prd_dtel=$qst_prd_dtel->fetch_assoc();

$prd_nem=$clct_prd_dtel['product_name'];


$usr_dtel="select * from users where id='$usr_idd'";
$qst_usr_dtel=$db->query($usr_dtel);
$clct_prd_dtel=$qst_usr_dtel->fetch_assoc();

$usr_nem=$clct_prd_dtel['name'];

$sb_ttl=$qnty*$prec;

?>


<tr>
<td><?php echo $sno++;?></td>
<td><?php echo $ord_det;?></td>
<td><?php echo $prd_nem;?></td>
<td><?php echo $prec;?></td>
<td><?php echo $qnty;?></td>
<td><?php echo $sb_ttl;?></td>
<td><?php echo $ord_id;?></td>
<td><?php echo $usr_nem;?></td>
<td><?php echo $ord_sts;?>


</td>
</tr>
    
    <?php } ?>
    
    
</table>
    

</div>

</div>

</div>
</main>

<?php include 'footer.php'; 

ob_flush();

?>