MAINHACK

Viewing / Editing File: all_assigned_subject.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' && isset($_POST['assign_subjects'])) {
    $teacherId = test_input($_POST['teacher_id']);
    $programme = test_input($_POST['programme']);

$selectedSubjects = $_POST['subject_names'] ?? [];

// ✅ Fetch current assignments from DB
    $existingQuery = $new->prepare("SELECT subject_name FROM teacher_subjects WHERE teacher_id = ? AND s_code = ?");
    $existingQuery->bind_param("is", $teacherId, $s_code);
    $existingQuery->execute();
    $existingResult = $existingQuery->get_result();

$existingSubjects = [];
    while ($row = $existingResult->fetch_assoc()) {
        $existingSubjects[] = $row['subject_name'];
    }
    $existingQuery->close();

// ✅ Find subjects to ADD
    $subjectsToAdd = array_diff($selectedSubjects, $existingSubjects);
    foreach ($subjectsToAdd as $subjectName) {
        $stmt = $new->prepare("INSERT INTO teacher_subjects (teacher_id,programe, subject_name, s_code) VALUES (?, ?, ?,?)");
        $stmt->bind_param("ssss", $teacherId,$programme, $subjectName, $s_code);
        $stmt->execute();
        $stmt->close();
    }

// ✅ Find subjects to DELETE
    $subjectsToDelete = array_diff($existingSubjects, $selectedSubjects);
    foreach ($subjectsToDelete as $subjectName) {
        $stmt = $new->prepare("DELETE FROM teacher_subjects WHERE teacher_id = ? AND subject_name = ? AND s_code = ?");
        $stmt->bind_param("iss", $teacherId, $subjectName, $s_code);
        $stmt->execute();
        $stmt->close();
    }

echo "<script>
document.addEventListener('DOMContentLoaded', function() {
Swal.fire({
title: 'Success!',
text: '✅ Subjects updated successfully!',
icon: 'success',
confirmButtonText: 'OK'
});
 });
</script>";

}

}
}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ASSIGN CLASS TEACHER </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" />

<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css" rel="stylesheet" />

.container {
    max-width: 950px;
    margin: auto;
    background: white;
    padding: 20px;
    border-radius: 8px;
    box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);
}

h1 {
    text-align: center;
    color: #333;
}

h2 {
    margin-top: 20px;
    color: #4CAF50;
}

.exam-form {
    margin-bottom: 20px;
    background-color: #f9f9f9;
    padding: 20px;
    border-radius: 8px;
    box-shadow: 0 2px 5px rgba(0, 0, 0, 0.1);
}

.exam-form label {
    display: block;
    margin: 10px 0 5px;
}

.exam-form input {
    width: calc(100% - 20px);
    padding: 10px;
    margin-bottom: 10px;
    border: 1px solid #ddd;
    border-radius: 4px;
}

.exam-form button {
    background-color: #4CAF50;
    color: white;
    border: none;
    padding: 10px;
    border-radius: 4px;
    cursor: pointer;
    transition: background-color 0.3s;
}

.exam-form button:hover {
    background-color: #45a049;
}

table {
    width: 100%;
    border-collapse: collapse;
    margin-top: 20px;
}

thead {
    background-color: #4CAF50;
    color: white;
}

th, td {
    border: 1px solid #ddd;
    padding: 12px;
    text-align: center;
    font-size: 16px;
}

th {
    position: sticky;
    top: 0; /* Keeps the header fixed when scrolling */
}

tbody tr:nth-child(even) {
    background-color: #f2f2f2;
}

tbody tr:hover {
    background-color: #e8f5e9; /* Light green on hover */
}

tbody td {
    border: 1px solid #ddd;
    vertical-align: middle; /* Aligns text vertically center */
}

/*table {
  table-layout: fixed;
  width: 100%;
}

td {
  word-wrap: break-word;
  word-break: break-all;
  white-space: normal; 
}*/

</style>

</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">ASSIGN SUBJECT TEACHER</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">ASSIGN SUBJECT TEACHER</li>
</ol>
</div>

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

<div class="row">
<div class="col-12">
<?php
$teacherFilter = isset($_POST['teacher_id']) ? trim($_POST['teacher_id']) : '';
$semesterFilter = isset($_POST['semester']) ? trim($_POST['semester']) : '';

$sql = "
SELECT 
    teacher_id,
    semester,
    subject_name,
    GROUP_CONCAT(DISTINCT classname ORDER BY classname SEPARATOR ', ') AS classnames,
    GROUP_CONCAT(DISTINCT programe ORDER BY programe SEPARATOR ', ') AS programes
FROM teacher_subjects
WHERE s_code = '$s_code'
";

if (!empty($teacherFilter)) {
    $sql .= " AND teacher_id = '" . mysqli_real_escape_string($new, $teacherFilter) . "'";
}
if (!empty($semesterFilter)) {
    $sql .= " AND semester = '" . mysqli_real_escape_string($new, $semesterFilter) . "'";
}

$sql .= " GROUP BY teacher_id, semester, subject_name ORDER BY teacher_id ASC, semester ASC, subject_name ASC";

$result = mysqli_query($new, $sql);
$cnt = 1;

// ✅ Fetch subjects once for dropdowns
$subjectQuery = $new->query("SELECT subject_com FROM class WHERE s_code = '$s_code'");
$allSubjects = [];

while ($row = $subjectQuery->fetch_assoc()) {
    $subjectString = trim($row['subject_com']);
    if (strpos($subjectString, ',') !== false) {
        $subjects = array_map('trim', explode(',', $subjectString));
    } elseif (strpos($subjectString, ' ') !== false) {
        $subjects = array_map('trim', preg_split('/\s+/', $subjectString));
    } else {
        $subjects = [$subjectString];
    }
    $allSubjects = array_merge($allSubjects, $subjects);
}
$allSubjects = array_unique(array_filter($allSubjects));
?>

<form method="POST">
    <div class="row">
        <div class="col-3">
            <label for="teacher" class="form-label fw-bold">Select Teacher</label>
            <select name="teacher_id" id="teacher" class="form-select">
                <option value="">-- All Teachers --</option>
                <?php
                $teachers = $new->query("SELECT DISTINCT teacher_id FROM teacher_subjects WHERE s_code = '$s_code' ORDER BY teacher_id ASC");
                while ($t = $teachers->fetch_assoc()) { ?>
                    <option value="<?= htmlspecialchars($t['teacher_id']); ?>" <?= ($teacherFilter === $t['teacher_id']) ? 'selected' : '' ?>>
                        <?= htmlspecialchars($t['teacher_id']); ?>
                    </option>
                <?php } ?>
            </select>
        </div>

<div class="col-3">
            <label for="semester" class="form-label fw-bold">Select Semester</label>
            <select name="semester" id="semester" class="form-select">
                <option value="">-- All Semesters --</option>
                <?php
                $semesters = $new->query("SELECT DISTINCT semester FROM teacher_subjects WHERE s_code = '$s_code' ORDER BY semester ASC");
                while ($s = $semesters->fetch_assoc()) { ?>
                    <option value="<?= htmlspecialchars($s['semester']); ?>" <?= ($semesterFilter === $s['semester']) ? 'selected' : '' ?>>
                        <?= htmlspecialchars($s['semester']); ?>
                    </option>
                <?php } ?>
            </select>
        </div>

<div class="col-3">
            <label class="form-label fw-bold">Action</label><br>
            <button type="submit" class="btn btn-primary" id="saveBtn">Load</button>
        </div>
    </div>
    <br><br><br>
</form>

<table class="table table-bordered dt-responsive nowrap w-100">
<thead>
<tr>
<th>#</th>
<th>Staff name</th>
<th>Semester</th>
<th>Class name(s)</th>
<th>Programme(s)</th>
<th>Subject</th>
</tr>
</thead>
<tbody>
<?php if (mysqli_num_rows($result) > 0): ?>
    <?php while ($row = mysqli_fetch_assoc($result)): ?>
        <tr>
            <td><?= $cnt++; ?></td>
            <td><?= htmlspecialchars($row['teacher_id']); ?></td>
            <td><?= htmlspecialchars($row['semester']); ?></td>
            <td>
                <?php 
                $classes = array_map('trim', explode(',', $row['classnames']));
                echo "<ul class='mb-0 ps-3'>";
                foreach ($classes as $cls) {
                    echo "<li>" . htmlspecialchars($cls) . "</li>";
                }
                echo "</ul>";
                ?>
            </td>
            <td>
                <?php 
                $programs = array_map('trim', explode(',', $row['programes']));
                echo "<ul class='mb-0 ps-3'>";
                foreach ($programs as $prog) {
                    echo "<li>" . htmlspecialchars($prog) . "</li>";
                }
                echo "</ul>";
                ?>
            </td>
            <td><?= htmlspecialchars($row['subject_name']); ?></td>
        </tr>
    <?php endwhile; ?>
<?php else: ?>
    <tr>
        <td colspan="6" class="text-center text-danger">No subjects assigned yet.</td>
    </tr>
<?php endif; ?>
</tbody>
</table>

</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: all_assigned_subject.php

Server Info

System Features

User Info