1#@!#!123s

: / home / schoolcampuserp / ltspratapgarh.co.in / admin /
Filename : add_user.php
back
<?php
include('includes/header.php');
include('includes/navbar.php');
include('security.php');


$currentYear = date('Y');
$nextYear = $currentYear + 1;
$currentSession = "$currentYear-" . substr($nextYear, -2);
?>

<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="addadminprofile" 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 User</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="Name" required>
                                </div>
                                <div class="form-group">
                                    <label>Date of Birth</label>
                                    <input type="date" name="dob" class="form-control form-control-sm" required>
                                </div>
                                <div class="form-group">
                                    <label>Email</label>
                                    <input type="text" name="email" class="form-control form-control-sm" placeholder="Email" required>
                                </div>
                                <div class="form-group">
                                    <label>Phone</label>
                                    <input type="text" name="phone" class="form-control form-control-sm" placeholder="Phone" required>
                                </div>
                            </div>
                            <div class="col-md-6">
                                
                                <div class="form-group">
                                    <label>Role</label>
                                    <select class="form-control form-control-sm" name="role" required>
                                        <option value="" disabled>Select</option>
                                        <option value="Student">Student</option>
                                        <option value="Teacher">Teacher</option>
                                        <option value="Staff">Staff</option>
                                    </select>
                                </div>
                            
                           
                                <div class="row">
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label for="profile_image1" class="form-label">Profile Image</label>
                                                <br>
                                                <!-- Image Preview -->
                                                <img id="imagePreview1" src="default.jpg" alt="Preview" width="120" height="120" class="border rounded mb-2">
                                                
                                            </div>
                                        </div>
                                        <div class="col-md-8">
                                            <div class="form-group">
                                               <label for="profile_image1" class="form-label">Photo</label> 
                                                <input type="file" class="form-control form-control-sm" id="profile_image1" name="photo" accept="image/*">
                                            </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="add_user_btn" class="btn btn-primary btn-sm">Save</button>
                    </div>
                </form>

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

    <!-- Update User Modal -->
    <div class="modal fade" id="updateUserModal" tabindex="-1" aria-labelledby="updateUserModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h6 class="modal-title" id="updateUserModalLabel">Update User</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="user_id" id="user_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="mb-3">
                                    <label for="email" class="form-label">Email</label>
                                    <input type="email" class="form-control form-control-sm" id="email" name="email" required>
                                </div>
                                <div class="mb-3">
                                    <label for="phone" class="form-label">Phone</label>
                                    <input type="text" class="form-control form-control-sm" id="phone" name="phone" required>
                                </div>
                                <div class="mb-3">
                                    <label for="dob" class="form-label">Date Of Birth</label>
                                    <input type="date" class="form-control form-control-sm" id="dob" name="dob" required>
                                </div>
                            </div>
                            <div class="col-md-6">
                                
                                <div class="mb-3">
                                    <label for="role" class="form-label">Role</label>
                                    <select class="form-control form-control-sm" id="role" name="role">
                                        <option value="">Select</option>
                                        <option value="Student">Student</option>
                                        <option value="Teacher">Teacher</option>
                                        <option value="Staff">Staff</option>
                                    </select>
                                </div>
                                <div class="mt-2">
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="form-group">
                                                <label for="profile_image2" class="form-label">Profile Image</label>
                                                <br>
                                                <!-- Image Preview -->
                                                <img id="imagePreview2" src="default.jpg" alt="Profile Image2" width="120" height="120" class="border rounded mb-2">
                                                
                                            </div>
                                        </div>
                                        <div class="col-md-8">
                                            <div class="form-group">
                                               <label for="profile_image2" class="form-label">Upload New</label> 
                                                <input type="file" class="form-control form-control-sm" id="profile_image2" 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="user_update_btn" class="btn btn-primary btn-sm ml-auto d-block">Update User</button>
                </div>
                
                    </form>
            </div>
            </div>
        </div>
    </div>
    
    <!-- Import User Modal --> 
    <div class="modal fade" id="importUser" 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">Import User</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">
                        <div class="container-fluid">
                            <div class="row">
                            <div class="col-md-8">
                                <div class="form-group">
                                    <label>CSV File</label>
                                    <input type="file" name="csv_file" class="form-control form-control-sm" placeholder="" required>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label>Sample File</label>
                                    <a href="files/user_sample_import_file.csv" download class="form-control form-control-sm btn btn-success btn-sm">
                                        <i class="fas fa-download"></i> Download Sample File
                                    </a>
                                </div> 
                            </div>

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

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



    <div class="card shadow mb-4">
        <div class="card-header py-2" style="display: flex; justify-content: space-between; align-items: center;">
            <h6 class="m-0 font-weight-bold text-primary">User's List</h6>
           
            <div class="btn btn-group">
                <button type="button" class="btn btn-info btn-sm" style="margin-right:5px;" data-toggle="modal" data-target="#importUser">
                <i class="fas fa-upload"></i> Import
                </button>
                <button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#addadminprofile">
                    <i class="fas fa-user-plus" style="font-size:16px;font-weight: 900;color: white;"></i> Add
                </button>
            </div>
        </div>
        <div class="card-body">
            <div class="table-responsive">

                <?php
                $query = "SELECT * FROM users";
                $query_run = mysqli_query($conn, $query);
                ?>

                <table class="table table-striped text-center" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>Sl</th>
                            <th>Name</th>
                            <th>Email</th>
                            <th>Phone</th>
                            <th>DOB</th>
                            <th>Role</th>
                            <th>Photo</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        if (mysqli_num_rows($query_run) > 0) {
                            $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['email']; ?></td>
                                    <td><?php echo $row['phone']; ?></td>
                                    <td><?php echo $row['dob']; ?></td>
                                    <td><span class="badge 
                                        <?php 
                                            if ($row['role'] == 'Student') {
                                                echo 'bg-info text-white';
                                            } elseif ($row['role'] == 'Teacher') {
                                                echo 'bg-success text-white';
                                            } elseif ($row['role'] == 'Staff') {
                                                echo 'bg-warning text-dark';
                                            } else {
                                                echo 'bg-secondary text-white';
                                            }
                                        ?>">
                                        <?php echo $row['role']; ?>
                                    </span></td>
                                   <td>
                                        <img src="<?php echo (!empty($row['image_path']) ? $row['image_path'] : 'img/default.jpg'); ?>" height="50" width="50" />
                                    </td>

                                    <td>
                                        <div class="d-flex">
                                            <button class="btn btn-outline-info btn-sm updateUserBtn" title="Update" data-id="<?php echo $row['id']; ?>" data-bs-toggle="modal" data-bs-target="#updateUserModal" style="margin-right:5px;">
                                                <i class="fas fa-user-edit"></i>
                                            </button>


                                            <form action="code.php" method="post">
                                                <input type="hidden" name="user_id" value="<?php echo $row['id']; ?>">
                                                <button type="submit" name="user_delete_btn" class="btn btn-outline-danger btn-sm" title="Delete"><i class="fas fa-trash"></i></button>
                                            </form>
                                        </div>
                                        
                                    </td>
                                </tr>
                        <?php
                            }
                        } else {
                            echo "No Record Found";
                        }
                        ?>
                    </tbody>
                </table>

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

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

<script>
    // Ensure the default image is shown on page load
    document.addEventListener("DOMContentLoaded", function() {
        var output = document.getElementById("imagePreview1");
        output.src = 'img/default.jpg';  // Set default image on load
    });
    
    // Handle file input change to update image preview
    document.getElementById("profile_image1").addEventListener("change", function(event) {
        var reader = new FileReader();
        reader.onload = function() {
            var output = document.getElementById("imagePreview1");
            output.src = reader.result;  // Display the selected image
        };
    
        // If a file is selected, update preview image
        if (event.target.files && event.target.files[0]) {
            reader.readAsDataURL(event.target.files[0]);
        }
    });

    
    // Second image input
    document.getElementById("profile_image2").addEventListener("change", function(event) {
        var reader = new FileReader();
        reader.onload = function() {
            var output = document.getElementById("imagePreview2");
            output.src = reader.result;
        };
        reader.readAsDataURL(event.target.files[0]);
    });

    $(document).ready(function() {
        $('.updateUserBtn').click(function() {
            var userId = $(this).data('id'); // Get user ID from button
            
            $.ajax({
                url: 'code.php',  // Single backend file
                type: 'POST',
                data: { action: 'fetch_user', user_id: userId },
                success: function(response) {
                    var userData = JSON.parse(response);
                    // console.log(userData);
                    if (!userData.error) {
                        $('#user_id').val(userData.id);
                        $('#name').val(userData.name);
                        $('#email').val(userData.email);
                        $('#phone').val(userData.phone);
                        $('#dob').val(userData.dob);
                        $('#role').val(userData.role).change();
                        if (userData.image_path) {
                            $('#imagePreview2').attr('src', '' + userData.image_path);
                        } else {
                            $('#imagePreview2').attr('src', 'img/default.jpg');
                        }
                        var myModal = new bootstrap.Modal(document.getElementById('updateUserModal'));
                        myModal.show();
                    } else {
                        alert('User not found!');
                    }
                }
            });
        });
    });
</script>

<!-- /.container-fluid -->

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