1#@!#!123s

: / home / schoolcampuserp / hrschool.in / admin /
Filename : facilities.php
back
<?php
include('includes/header.php');
include('includes/navbar.php');
include('security.php');
session_start();
?>


<div class="container-fluid">
    <?php
    if (isset($_SESSION['status']) && $_SESSION['status'] != "") {
        ?>
        <div class="alert alert-<?php echo ($_SESSION['status_code'] == "success") ? "success" : "danger"; ?> alert-dismissible fade show" role="alert">
            <?php echo $_SESSION['status']; ?>
            <!--<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>-->
        </div>
        <?php
        unset($_SESSION['status']);
        unset($_SESSION['status_code']);
    }
    ?>
     

    <div class="modal fade" id="addFacility" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h6 class="modal-title" id="exampleModalLabel">Add a new Facility</h6>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <form action="code.php" method="POST" enctype="multipart/form-data">
                    <div class="modal-body">
                        <div class="row">
                            <div class="col-md-6">
                                <div class="form-group">
                                    <label>Name</label>
                                    <input type="text" name="name" class="form-control form-control-sm" placeholder="Title">
                                </div>
                                <div class="form-group">
                                    <label>Description</label>
                                    <textarea name="description" class="form-control form-control-sm" placeholder="Description Here....."></textarea>
                                </div>
                                
                            </div>
                            <div class="col-md-6">
                              
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label for="photo_preview" class="form-label">Photo</label>
                                            <br>
                                            <!-- Image Preview -->
                                            <img id="photo_preview" src="img/default.jpg" alt="photo" width="120" height="120" class="border rounded mb-2">
                                        </div>
                                    </div>
                                    <div class="col-md-8">
                                        <div class="form-group">
                                            <label for="photo" class="form-label">Upload Image</label>
                                            <input type="file" class="form-control form-control-sm" id="photo" name="photo" accept="image/*">
                                        </div>
                                    </div>
                                </div>
                                    
                            </div>
                        </div>
                        

                    </div>
                    <div class="modal-footer">
                        <button type="submit" name="facility_save_btn" class="btn btn-primary btn-sm">Save</button>
                    </div>
                </form>

            </div>
        </div>
    </div>
    
    <!-- Update Facility Modal -->
    <div class="modal fade" id="updateFacilityModal" tabindex="-1" aria-labelledby="updateFacilityModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h6 class="modal-title" id="updateUserModalLabel">Update Facility</h6>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <form action="code.php" method="POST" enctype="multipart/form-data">
                        <input type="hidden" name="facility_id" id="facility_id">
                        <div class="row">
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="name" class="form-label">Name</label>
                                    <input type="text" class="form-control form-control-sm" id="name" name="name" required>
                                </div>
                                <div class="form-group">
                                    <label>Description</label>
                                    <textarea name="description" id="description" class="form-control form-control-sm" placeholder="Description Here....."></textarea>
                                </div>
                            </div>
                            <div class="col-md-6">
                                
                                <div class="mt-2">
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label for="photo_preview2" class="form-label">Photo</label>
                                                <br>
                                                <!-- Image Preview -->
                                                <img id="photo_preview2" src="default.jpg" alt="photo_preview2" width="120" height="120" class="border rounded mb-2">
                                                
                                            </div>
                                        </div>
                                        <div class="col-md-8">
                                            <div class="form-group">
                                               <label for="photo_preview2" class="form-label">Upload New</label> 
                                                <input type="file" class="form-control form-control-sm" id="photo2" name="photo" accept="image/*">
                                            </div>
                                           
                                        </div>
                                    </div>
                                    
                                </div>
                            </div>
                        </div>
                        

                </div>
                <div class="modal-footer">
                    <button type="button" name="" data-dismiss="modal" class="btn btn-secondary btn-sm">Cancel</button>
                    <button type="submit" name="facility_update_btn" class="btn btn-primary btn-sm ml-auto d-block">Update</button>
                </div>
                
                    </form>
            </div>
            </div>
        </div>
    </div>
    
    <div class="card border-top-primary shadow mb-4">

        <div class="card-header py-2" style="display: flex; justify-content: space-between; align-items: center;">
            <h5 class="m-0 font-weight-bold text-primary">Facilities</h5>
            <div class="btn btn-group">
                <!--<button type="button" class="btn btn-info btn-sm" style="margin-right:5px;" data-toggle="modal" data-target="#addCategory">-->
                <!--<i class="fas fa-th-list"></i> Category-->
                <!--</button>-->
                <button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#addFacility">
                    <i class="fas fa-user-plus" style="font-size:16px;font-weight: 900;color: white;"></i> Add new
                </button>
            </div>
            
        </div>
        <div class="card-body">
            <div class="table-responsive">

                <?php
                $query = "SELECT * FROM facilities";
                $query_run = mysqli_query($conn, $query);
                if (mysqli_num_rows($query_run) > 0) {

                ?>


                    <table class="table table-striped" id="dataTable" width="100%" cellspacing="0">
                        <thead>
                            <tr>
                                <th>Sl no.</th>
                                <th>Title</th>
                                <th>Related To</th>
                                <th>Status</th>
                                <th>Images</th>
                                <th class="text-center">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $sl = 1;
                            while ($row = mysqli_fetch_assoc($query_run)) {
                            ?>
                                <tr>
                                    <td><?php echo $sl++ ; ?></td>
                                    <td><?php echo $row['name']; ?></td>
                                    <td><?php echo $row['description']; ?></td>
                                    <td><?php echo $row['status']; ?></td>
                                    <td><?php echo '<img src="files/facilities/' . $row['image_path'] . ' "width ="100px" "width ="100px" alt="Images">' ?></td>
                                    
                                    <td>
                                        <div class="btn btn-group">
                                            <button class="btn btn-outline-success btn-sm updateFacilityBtn" title="Update" data-id="<?php echo $row['id']; ?>" data-bs-toggle="modal" data-bs-target="#updateFacilityModal" style="margin-right:5px;">
                                                <i class="fas fa-edit"></i>
                                            </button>
                                            <form action="code.php" method="post">
                                                <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                                                <button type="submit" name="facility_status_update_btn" class="btn btn-sm btn-outline-warning" title="Change Status"> <i class="fas fa-sync-alt"></i> </button>
                                            </form>
                                            <form action="code.php" method="post">
                                                <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                                                <button style=" margin-left:5px;" type="submit" name="facility_delete_btn" class="btn btn-sm btn-outline-danger" title="Delete"> <i class="fas fa-trash" ></i> </button>
                                            </form>
                                        </div>
                                        
                                    </td>
                                </tr>

                            <?php

                            }
                            ?>

                        </tbody>
                    </table>
                <?php
                } else {
                    echo "no records found";
                }
                ?>
            </div>
        </div>
    </div>

</div>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<script>
document.addEventListener("DOMContentLoaded", function() {
    var photoPreview = document.getElementById("photo_preview");
    var photoInput = document.getElementById("photo");

    // Set default image on load (ensure this matches your actual path)
    photoPreview.src = "img/default.jpg"; 

    // Listen for file input change event
    photoInput.addEventListener("change", function(event) {
        if (event.target.files.length > 0) {  // Check if a file is selected
            var reader = new FileReader();
            reader.onload = function(e) {
                photoPreview.src = e.target.result; // Update preview
            };
            reader.readAsDataURL(event.target.files[0]);
        }
    });
});
document.addEventListener("DOMContentLoaded", function() {
    var photoPreview = document.getElementById("photo_preview2");
    var photoInput = document.getElementById("photo2");

    photoInput.addEventListener("change", function(event) {
        if (event.target.files.length > 0) {  // Check if a file is selected
            var reader = new FileReader();
            reader.onload = function(e) {
                photoPreview.src = e.target.result; // Update preview
            };
            reader.readAsDataURL(event.target.files[0]);
        }
    });
});
   $(document).ready(function() {
        $('.updateFacilityBtn').click(function() {
            var facility_id = $(this).data('id'); // Get user ID from button
            
            $.ajax({
                url: 'code.php',  // Single backend file
                type: 'POST',
                data: { action: 'fetch_facility', facility_id: facility_id },
                success: function(response) {
                    var facilityData = JSON.parse(response);
                    // console.log(facilityData);
                    if (!facilityData.error) {
                        $('#facility_id').val(facilityData.id);
                        $('#name').val(facilityData.name);
                        $('#description').val(facilityData.description);
                        if (facilityData.image_path) {
                            $('#photo_preview2').attr('src', 'files/facilities/' + facilityData.image_path);
                        } else {
                            $('#photo_preview2').attr('src', 'img/default.jpg');
                        }
                        var myModal = new bootstrap.Modal(document.getElementById('updateFacilityModal'));
                        myModal.show();
                    } else {
                        alert('User not found!');
                    }
                }
            });
        });
    });
</script>


<?php
include('includes/scripts.php');
?>
<script>
    
</script>
<?php
include('includes/footer.php');
?>