MAINHACK

Viewing / Editing File: out-of-stock.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else{
$pageTitle = 'Out of Stock';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$currency = mysqli_query($new,"SELECT currency from barber_admin WHERE
 business_name = '$shopname'");
 $fechC = mysqli_fetch_array($currency);
$qurtyCurrency = $fechC['currency'];
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title> <?php echo $pageTitle;?> ||  <?php echo $shopname;?></title>

<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/theme.min.css" rel="stylesheet" type="text/css" />

#loader {
display: block;
position: absolute;
top: 50%;
left: 50%;
border: 16px solid #f3f3f3;
border-top: 16px solid #3498db;
border-radius: 50%;
width: 70px;
height: 70px;
animation: spin 2s linear infinite;
}

@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
</style>

</head>

<?php include("includes/template/head.php");?>
<?php include("includes/template/side.php");?>

<div class="row">
<div class="col-12">
<div class="page-title-box d-flex align-items-center justify-content-between">
<h4 class="mb-0 font-size-18">Product sales</h4>

</div>
</div>
</div>

<div class="table-responsive"> 
 <table id="basic-datatable" class="table table-hover table-striped table-bordered">
<thead style="background-color:#428bca;border:#428bca;">
<tr style="color: #ffffff;">
        <th>ID</th>
        <th>Product</th>
        <th>Unit price</th>
        <th>Qty</th>
        <th>Supplier</th>
        
    </tr>
</thead>
<tbody>

<tr>
 <?php
$cont = 1;
$stmt = $con->prepare("SELECT * FROM products p,supplier s WHERE p.supplier = s.supplier_id and p.business_name = ? and p.qty <= 0 ");
$stmt->execute(array($shopname));
$rows_services = $stmt->fetchAll();
foreach($rows_services as $service){

?>
                    
                        <td><?php echo  $cont++;?></td>
                        <td><?php echo $service['product_name'];?></td>
                        <td><?php echo number_format($service['price'],2).' '.$qurtyCurrency;?></td>
                        <td><?php echo $service['qty'];?></td>
                        <td><?php echo $service['supplier_name'];?></td>
                    </tr>

<?php  };?>

</tbody>
            </table>

</div>

</div> 
</div>

</div>

</div> 
</div>

<?php include("includes/template/newfooter.php");?>
</div>

</div>

<div class="menu-overlay"></div>

<?php include("includes/modals/ProductModal.php");?>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: out-of-stock.php

Server Info

System Features

User Info