MAINHACK

Viewing / Editing File: add_assign_bed.php

<?php include("../functions.php");
 //error_reporting(0);
 if(!isset($_SESSION['dbmail_Xw211qAAsq4'])){
     header("location:../auth-login");
 } else {
   $s_code = $_SESSION['s_code_Xw2119904'];
$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($s_code));
$row = $stmt->fetch();
$logo = $row['logo'];
    if(empty($logo)){
      header("Location:complete-process");
    } else {

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Capture form data
    $studentIDs = $_POST['studentID'];
    $houses = $_POST['houseid'];
    $bedNos = $_POST['bed_no'];
    $date = date("Y-m-d");

// Check if the database connection is established
    if (!$new) {
        die("Database connection failed: " . mysqli_connect_error());
    }

foreach ($studentIDs as $key => $studentID) {
        $house = $houses[$key];
        $bedNo = $bedNos[$key];

// Check if the record already exists
        $check_sql = "SELECT * FROM beds WHERE studen_index = '$studentID'";
        $result = mysqli_query($new, $check_sql);

if (!$result) {
            die("Error in checking record: " . mysqli_error($new));
        }

if (mysqli_num_rows($result) > 0) {
            // If record exists, perform an update
            $update_sql = "UPDATE beds 
                           SET houseid = '$house', bed_no = '$bedNo' 
                           WHERE studen_index = '$studentID'";
            if (mysqli_query($new, $update_sql)) {
                // Success message
                $message = "Bed assignment updated successfully!";
            } else {
                die("Error updating record: " . mysqli_error($new));
            }
        } else {
            // If record does not exist, perform an insert
            $insert_sql = "INSERT INTO beds (s_code, studen_index, houseid, bed_no, date) 
                           VALUES ('$s_code', '$studentID', '$house', '$bedNo', '$date')";
            if (mysqli_query($new, $insert_sql)) {
                // Success message
                $message = "Bed assignment added successfully!";
            } else {
                die("Error inserting record: " . mysqli_error($new));
            }
        }
    }

// Display the success message using JavaScript after all records are processed
    echo "<script>
    document.addEventListener('DOMContentLoaded', function() {
        Swal.fire({
            title: 'Success!',
            text: '$message',
            icon: 'success',
            confirmButtonText: 'OK'
        });
    });
    </script>";
}
}
}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ASSIGN BED </title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

</head>

<body>

<div id="layout-wrapper">

<?php include("includes/header.php");?>
<?php include("includes/sidebar.php");?>
<div class="main-content">

<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18">MANAGE BED ASSIGNMENT</h4>

<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
<li class="breadcrumb-item active">MANAGE BED ASSIGNMENT</li>
</ol>
</div>

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

<form  method="POST">
  <div class="row">
    <div class="col-12">
      <div class="container">
        <table id="tech-companies-1" class="table table-striped">
          <thead>
            <tr>
              <th>#</th>
              <th>Student ID</th>
              <th>House</th>
              <th>Bed No</th>
              <th>Action</th>
            </tr>
          </thead>
          <tbody>
            <tr>
              <th>1</th>
              <td>
                <select class="form-control student-id-select" data-row="1" name="studentID[]">
                  <option value=""></option>
                  <?php
                    $sql = "SELECT * FROM enrol_details WHERE s_code = '$s_code'";
                    $result = $new->query($sql);

if ($result->num_rows > 0) {
                      while($row = $result->fetch_assoc()) {
                        echo '<option value="' . $row['index_no'] . '">' . $row['index_no'] . '</option>';
                      }
                    } else {
                      echo '<option>No students found</option>';
                    }
                  ?>
                </select>
              </td>
              <td>
                <input type="text" id="house-1" name="houseid[]" readonly class="form-control house-input">
              </td>
              <td>
                <input type="text" class="form-control" name="bed_no[]">
              </td>
              <td>
                <button type="button" class="btn btn-danger removeRow"><i class="fa fa-trash"></i></button>
              </td>
            </tr>
          </tbody>
        </table>
        <button type="button" id="addRow" class="btn btn-primary">Add Row</button>
      </div>
    </div>
  </div>

<div class="row mt-4">
    <div class="col-12 text-center">
      <button type="submit" class="btn btn-success">Submit</button>
    </div>
  </div>
</form>

// Add a new row dynamically with the "Add Row" button
    $("#addRow").click(function() {
      rowCount++;
      var newRow = `
      <tr>
        <th>${rowCount}</th>
        <td>
          <select class="form-control student-id-select" data-row="${rowCount}" name="studentID[]">
            <option value=""></option>
            <?php
              $sql = "SELECT * FROM enrol_details WHERE s_code = '$s_code'";
              $result = $new->query($sql);

if ($result->num_rows > 0) {
                while($row = $result->fetch_assoc()) {
                  echo '<option value="' . $row['index_no'] . '">' . $row['index_no'] . '</option>';
                }
              } else {
                echo '<option>No students found</option>';
              }
            ?>
          </select>
        </td>
        <td>
          <input type="text" id="house-${rowCount}" name="houseid[]" readonly class="form-control house-input">
        </td>
        <td>
          <input type="text" class="form-control" name="bed_no[]">
        </td>
        <td>
          <button type="button" class="btn btn-danger removeRow"><i class="fa fa-trash"></i></button>
        </td>
      </tr>`;

$("#tech-companies-1 tbody").append(newRow);
    });

// Remove a row when the "Remove" button is clicked
    $(document).on('click', '.removeRow', function() {
      $(this).closest('tr').remove();
      rowCount--;
      $('#tech-companies-1 tbody tr').each(function(index) {
        $(this).find('th').text(index + 1);
      });
    });

// Fetch house dynamically when a student ID is selected
    $(document).on('change', '.student-id-select', function() {
      var indexNo = $(this).val();
      var row = $(this).data('row');

if (indexNo) {
        $.ajax({
          type: 'POST',
          url: 'get_house.php',  // PHP script to fetch house based on index number
          data: { index_no: indexNo },
          success: function(response) {
            $('#house-' + row).val(response);
          }
        });
      } else {
        $('#house-' + row).val('');
      }
    });
  });
</script>

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

<?php include("includes/footer.php");?>
</div>

</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />

<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>

<script src="assets/libs/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/jszip/jszip.min.js"></script>
<script src="assets/libs/pdfmake/build/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/build/vfs_fonts.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.html5.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.print.min.js"></script>
<script src="assets/libs/datatables.net-buttons/js/buttons.colVis.min.js"></script>

<script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>
        <script src="assets/libs/sweetalert2/sweetalert2.min.js"></script>

<script src="assets/js/pages/datatables.init.js"></script>

myModal.addEventListener('shown.bs.modal', function () {
myInput.focus()
})
</script>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_assign_bed.php

Server Info

System Features

User Info