📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/purchase.php
<?php ob_start(); include_once("include/head.php"); if (isset($_POST['delete'])) { $equipment_id = $_POST['equipment_id']; if (!empty($equipment_id)) { $sql = "DELETE FROM equipment_inventory WHERE id = ?"; if ($stmt = $conn->prepare($sql)) { $stmt->bind_param("i", $equipment_id); if ($stmt->execute()) { $_SESSION['success_message'] = "Equipment deleted successfully."; } else { $_SESSION['error_message'] = "Error deleting the equipment."; } $stmt->close(); } } else { $_SESSION['error_message'] = "Invalid equipment ID."; } header("Location: purchase.php"); exit(); } ?> <div class="main-panel"> <div class="content-wrapper"> <div class="card"> <div class="card-body"> <div class="row"> <div class="col-md-12 text-center"> <?php if (isset($_SESSION['success_message'])): ?> <div class="alert alert-success" role="alert"> <?php echo $_SESSION['success_message']; ?> </div> <?php unset($_SESSION['success_message']); ?> <?php elseif (isset($_SESSION['error_message'])): ?> <div class="alert alert-danger" role="alert"> <?php echo $_SESSION['error_message']; ?> </div> <?php unset($_SESSION['error_message']); ?> <?php endif; ?> </div> <div class="col-md-3"> <h4 class="card-title">Equipment Inventory List</h4> </div> <div class="col-md-9"> <a href="purchase-order.php" class="btn btn-primary" style="float: right; margin-bottom: 10px;">Add Equipment</a> </div> </div> <div class="row"> <div class="col-12"> <div class="table-responsive"> <table id="equipment-listing" class="table"> <thead> <tr> <th>S.No</th> <th>Equipment Name</th> <th>Serial No.</th> <th>Model No.</th> <!--<th>Location</th>--> <th>Assigned To</th> <th>Warranty Expiry</th> <th>Last Service</th> <th>Created At</th> <th>Actions</th> </tr> </thead> <tbody> <?php $count = 1; $sql = "SELECT * FROM equipment_inventory"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { $warrantyExpiry = $row['warranty_expiry'] ? date('Y-m-d', strtotime($row['warranty_expiry'])) : '-'; $lastService = $row['last_service'] ? date('Y-m-d', strtotime($row['last_service'])) : '-'; $createdAt = date('Y-m-d H:i:s', strtotime($row['created_at'])); ?> <tr> <td><?php echo $count++; ?></td> <td><?php echo $row['equipment_name']; ?></td> <td><?php echo $row['serial_number']; ?></td> <td><?php echo $row['model_number']; ?></td> <!--<td><?php echo $row['location']; ?></td>--> <td><?php echo $row['assigned_to']; ?></td> <td><?php echo $warrantyExpiry; ?></td> <td><?php echo $lastService; ?></td> <td><?php echo $createdAt; ?></td> <td> <a href="edit-equipment.php?id=<?php echo $row['id']; ?>" class="btn btn-primary btn-sm">Edit</a> <!-- Trigger Modal for Delete --> <button type="button" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#deleteModal-<?php echo $row['id']; ?>">Delete</button> </td> </tr> <?php } } else { echo "<tr><td colspan='10' class='text-center'>No equipment found.</td></tr>"; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> <!-- Modals for each equipment item --> <?php $sql = "SELECT * FROM equipment_inventory"; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_assoc($result)) { ?> <div class="modal fade" id="deleteModal-<?php echo $row['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="deleteModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="deleteModalLabel">Delete Equipment</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> Are you sure you want to delete this equipment item? </div> <div class="modal-footer"> <!-- Form to delete equipment --> <form action="purchase.php" method="POST"> <input type="hidden" name="equipment_id" value="<?php echo $row['id']; ?>"> <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button> <button type="submit" name="delete" class="btn btn-danger">Delete</button> </form> </div> </div> </div> </div> <?php } ?> <?php include_once("include/footer.php"); ?>
Save
Cancel