D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
inventory.tapaslights.com
/
tapaslights
/
Filename :
deduct_material.php
back
Copy
<!DOCTYPE html> <html lang="en" data-layout="vertical" data-topbar="light" data-sidebar="light" data-sidebar-size="lg" data-sidebar-image="none"> <head> <?php include 'style.php'; ?> </head> <body> <div class="main-wrapper"> <?php include 'header.php'; ?> <?php include 'sidebar.php'; ?> <div class="page-wrapper"> <div class="content container-fluid"> <div class="row"> <div class="col-lg-12"> <div class="card"> <div class="card-header"> <h5 class="card-title">Deduct Material</h5> </div> <div class="card-body"> <form method="POST" action=""> <div class="input-block mb-3 row"> <label class="col-form-label col-md-2">Select Material</label> <div class="col-md-10"> <select name="material_id" class="form-control" required> <option value="">Select Material</option> <?php include 'config.php'; $materials = $conn->query("SELECT id, product_name, stock_quantity FROM materials"); while ($row = $materials->fetch_assoc()) { echo "<option value='{$row['id']}'>" . htmlspecialchars($row['product_name']) . " (Stock: {$row['stock_quantity']})</option>"; } ?> </select> </div> </div> <div class="input-block mb-3 row"> <label class="col-form-label col-md-2">Quantity to Deduct</label> <div class="col-md-10"> <input type="number" name="deduct_qty" class="form-control" min="1" placeholder="Enter Quantity to Deduct" required> </div> </div> <div class="input-block mb-3 mb-0 row"> <div class="col-md-10 offset-md-2"> <div class="input-group mb-3 d-flex justify-content-end"> <button class="btn btn-warning m-2" type="submit">Deduct</button> <button class="btn btn-danger m-2" type="reset">Reset</button> </div> </div> </div> </form> <?php if ($_SERVER['REQUEST_METHOD'] === 'POST') { $material_id = $_POST['material_id']; $deduct_qty = (int)$_POST['deduct_qty']; // Get current stock and details $result = $conn->query("SELECT * FROM materials WHERE id = $material_id"); $material = $result->fetch_assoc(); if ($material && $material['stock_quantity'] >= $deduct_qty) { // Deduct stock $stmt = $conn->prepare("UPDATE materials SET stock_quantity = stock_quantity - ? WHERE id = ?"); $stmt->bind_param("ii", $deduct_qty, $material_id); if ($stmt->execute()) { // Log the deduction $material_name = $material['product_name']; $unit = $material['unit']; $price_per_unit = $material['price_per_unit']; $total_price = $deduct_qty * $price_per_unit; $log_stmt = $conn->prepare("INSERT INTO material_transactions (material_id, material_name, transaction_type, quantity, unit, price_per_unit, total_price) VALUES (?, ?, 'deduct', ?, ?, ?, ?)"); $log_stmt->bind_param("isdssd", $material_id, $material_name, $deduct_qty, $unit, $price_per_unit, $total_price); $log_stmt->execute(); echo "<script>alert('Stock deducted and transaction logged successfully!');</script>"; } else { echo "<script>alert('Error updating stock.');</script>"; } } else { echo "<script>alert('Error: Not enough stock available.');</script>"; } } ?> </div> </div> </div> </div> </div> </div> </div> <?php include 'footer.php'; ?> </body> </html>