|
Server IP : 153.92.220.142 / Your IP : 216.73.216.128 Web Server : LiteSpeed System : Linux nl-srv-web513.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64 User : u444427800 ( 444427800) PHP Version : 8.1.32 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u444427800/domains/dronacharyasunayana.com/public_html/billing/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("include/connect.php");
if(isset($_GET['service_id']))
{
$service_id = intval($_GET['service_id']);
$sql22="SELECT SUM(qty) AS value_sum FROM `inventory` WHERE `type` = 1 AND `product_id`='$service_id' ";
$run22=mysqli_query($db,$sql22);
$row = mysqli_fetch_assoc($run22);
$total_stockIN = $row['value_sum'];
$sql33="SELECT SUM(qty) AS value_sum FROM `inventory` WHERE `type` = 2 AND `product_id`='$service_id' ";
$run33=mysqli_query($db,$sql33);
$row = mysqli_fetch_assoc($run33);
$total_stockOUT = $row['value_sum'];
$available_stock= ($total_stockIN - $total_stockOUT);
if($available_stock <= 0 ) {
$priceList="Out Of Stock";
echo $priceList ;
} else {
$sql = "select * from products where product_id = $service_id ";
$run=mysqli_query($db,$sql);
$data=mysqli_fetch_assoc($run);
$priceList = $data['sale_price'];
echo $priceList ;
}
}
?>