/home/techb158/workloadmatch.com/Master/

/home/techb158/workloadmatch.com/Master

Name	Size	Mode	Actions
addgroup.php	6908	0644	edit dl rm
addmanager.php	14495	0644	edit dl rm
adduser.php	11148	0644	edit dl rm
assign_teacher_manual.php	3879	0644	edit dl rm
chat.php	16850	0644	edit dl rm
dashboard.php	13677	0644	edit dl rm
fetch_teacher_prefrence_courses.php	1887	0644	edit dl rm
inc.php	551	0644	edit dl rm
Lockup_to_Assign.php	3662	0644	edit dl rm
main-header-inc.php	1276	0644	edit dl rm
main-header.php	15374	0644	edit dl rm
preference_accounting.php	9416	0644	edit dl rm
preference_secretarial.php	9416	0644	edit dl rm
profile.php	17094	0644	edit dl rm
profile_bak.php.disabled	3195	0644	edit dl rm
save_teacher_preference.php	2107	0644	edit dl rm
set_manager.php	1305	0644	edit dl rm
teacher_absence.php	305	0644	edit dl rm
teacher_preference.php	3798	0644	edit dl rm
teacher_preference_by_course.php	3833	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/Master/addgroup.php (6908B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';
sec_session_start();
$page = 'Master | Add Group';
addinfo($page, $mysqli);
require_role($mysqli, 'master_profile');

$Master_ID = $_SESSION['user_id'];
$q = $mysqli->prepare("SELECT Admin_ID FROM master_profile WHERE Master_ID = ?");
$q->bind_param("s", $Master_ID);
$q->execute();
$q->bind_result($Admin_ID);
$q->fetch();
$q->close();

// Get all managers under this Master
$managers = [];
$ml = $mysqli->prepare("SELECT Manager_ID, First_Name, Last_Name FROM manager_profile WHERE Admin_ID = ? ORDER BY First_Name");
$ml->bind_param("s", $Admin_ID);
$ml->execute();
$mr = $ml->get_result();
while ($m = $mr->fetch_assoc()) $managers[] = $m;
$ml->close();

include 'main-header-inc.php';

// Process form
if (isset($_POST['addgroup'])) {
    $gname = $_POST['Group_Name'] ?? '';
    $manager_id = $_POST['Manager_ID'] ?? '';
    if ($gname && $manager_id) {
        $chk = $mysqli->prepare("SELECT Group_ID FROM manager_group_name WHERE Group_Name = ? AND Manager_ID = ?");
        $chk->bind_param("ss", $gname, $manager_id);
        $chk->execute();
        $chk->store_result();
        if ($chk->num_rows == 0) {
            $dt = date('Y-m-d H:i:s');
            $ins = $mysqli->prepare("INSERT INTO manager_group_name (Group_Name, Admin_ID, Master_ID, Manager_ID, Program_ID, Weekend_Class, Group_Year, Time_Slot, Time_From, Time_To, Date_Time) VALUES (?, ?, ?, ?, 0, 0, '', '', '00:00:00', '00:00:00', ?)");
            $ins->bind_param("sssss", $gname, $Admin_ID, $Master_ID, $manager_id, $dt);
            if ($ins->execute()) set_flash_msg("Group '$gname' added!", 'success');
            else set_flash_msg('Error: '.$ins->error, 'warning');
            $ins->close();
        } else {
            set_flash_msg('Group already exists for this manager.', 'warning');
        }
        $chk->close();
    } else {
        set_flash_msg('Please select a manager and enter a group name.', 'warning');
    }
    header('Location: addgroup.php'); exit();
}
if (isset($_POST['delete'])) {
    $gid = $_POST['Group_ID'] ?? 0;
    $manager_id = $_POST['Manager_ID'] ?? '';
    if ($gid && $manager_id) {
        $del = $mysqli->prepare("DELETE FROM manager_group_name WHERE Group_ID = ? AND Admin_ID = ? AND Manager_ID = ?");
        $del->bind_param("iss", $gid, $Admin_ID, $manager_id);
        $del->execute();
        set_flash_msg('Group deleted.', 'success');
        $del->close();
    }
    header('Location: addgroup.php'); exit();
}
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Add Group</title>
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <link rel="icon" href="dist/img/avatar.png" sizes="32x32" />
  <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">
  <link rel="stylesheet" href="plugins/select2/select2.min.css">
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <link rel="stylesheet" href="dist/css/skins/skin-black-light.min.css">
</head>
<body class="hold-transition skin-black-light sidebar-mini">
<?php if (login_check($mysqli) == true) : ?>
<div class="wrapper">
<?php include 'main-header.php'; ?>
<div class="content-wrapper">
  <section class="content-header">
    <h1><i class="fa fa-group"></i> Manage Groups</h1>
    <ol class="breadcrumb"><li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Dashboard</a></li><li class="active">Groups</li></ol>
  </section>
  <section class="content">
    <?php display_flash_msg(); ?>
    <div class="row">
      <div class="col-md-5">
        <div class="box box-primary">
          <div class="box-header"><h3 class="box-title">Add Group to Manager</h3></div>
          <form method="post">
            <div class="box-body">
              <div class="form-group">
                <label>Select Manager *</label>
                <select class="form-control select2" name="Manager_ID" required style="width:100%">
                  <option value="">— Select Manager —</option>
                  <?php foreach ($managers as $m): ?>
                    <option value="<?php echo htmlspecialchars($m['Manager_ID']); ?>"><?php echo htmlspecialchars($m['First_Name'].' '.$m['Last_Name']); ?></option>
                  <?php endforeach; ?>
                </select>
              </div>
              <div class="form-group"><label>Group Name *</label><input type="text" class="form-control" name="Group_Name" required></div>
            </div>
            <div class="box-footer"><button type="submit" name="addgroup" class="btn btn-primary"><i class="fa fa-plus"></i> Add Group</button></div>
          </form>
        </div>
      </div>
      <div class="col-md-7">
        <div class="box">
          <div class="box-header"><h3 class="box-title">Existing Groups</h3></div>
          <div class="box-body table-responsive">
            <table class="table table-bordered table-striped">
              <thead><tr><th>Manager</th><th>Group Name</th><th>Action</th></tr></thead>
              <tbody>
<?php
$gl = $mysqli->prepare("SELECT g.Group_ID, g.Group_Name, g.Manager_ID, CONCAT(mp.First_Name, ' ', mp.Last_Name) AS Manager_Name FROM manager_group_name g JOIN manager_profile mp ON g.Manager_ID = mp.Manager_ID WHERE g.Admin_ID = ? ORDER BY mp.First_Name, g.Group_Name");
$gl->bind_param("s", $Admin_ID);
$gl->execute();
$gr = $gl->get_result();
while ($g = $gr->fetch_assoc()) {
    echo "<tr>
      <td>".htmlspecialchars($g['Manager_Name'])."</td>
      <td>".htmlspecialchars($g['Group_Name'])."</td>
      <td><form method='post' style='display:inline' onsubmit='return confirm(\"Delete?\")'>
      <input type='hidden' name='Group_ID' value='{$g['Group_ID']}'>
      <input type='hidden' name='Manager_ID' value='".htmlspecialchars($g['Manager_ID'])."'>
      <button type='submit' name='delete' class='btn btn-danger btn-xs'><i class='fa fa-trash'></i></button></form></td>
    </tr>";
}
$gl->close();
?>
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </section>
</div>
<?php include '../footer.php'; ?>
</div>
<script src="plugins/jQuery/jQuery-2.2.0.min.js"></script>
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<script src="plugins/select2/select2.full.min.js"></script>
<script src="dist/js/app.min.js"></script>
<script>$(function(){$('.select2').select2({width:'resolve'});});</script>
<?php else : ?>
  <?php include '../authorized.php'; ?>
<?php endif; ?>
</body>
</html>

prepare("SELECT Admin_ID FROM master_profile WHERE Master_ID = ?"); $q->bind_param("s", $Master_ID); $q->execute(); $q->bind_result($Admin_ID); $q->fetch(); $q->close(); // Get all managers under this Master $managers = []; $ml = $mysqli->prepare("SELECT Manager_ID, First_Name, Last_Name FROM manager_profile WHERE Admin_ID = ? ORDER BY First_Name"); $ml->bind_param("s", $Admin_ID); $ml->execute(); $mr = $ml->get_result(); while ($m = $mr->fetch_assoc()) $managers[] = $m; $ml->close(); include 'main-header-inc.php'; // Process form if (isset($_POST['addgroup'])) { $gname = $_POST['Group_Name'] ?? ''; $manager_id = $_POST['Manager_ID'] ?? ''; if ($gname && $manager_id) { $chk = $mysqli->prepare("SELECT Group_ID FROM manager_group_name WHERE Group_Name = ? AND Manager_ID = ?"); $chk->bind_param("ss", $gname, $manager_id); $chk->execute(); $chk->store_result(); if ($chk->num_rows == 0) { $dt = date('Y-m-d H:i:s'); $ins = $mysqli->prepare("INSERT INTO manager_group_name (Group_Name, Admin_ID, Master_ID, Manager_ID, Program_ID, Weekend_Class, Group_Year, Time_Slot, Time_From, Time_To, Date_Time) VALUES (?, ?, ?, ?, 0, 0, '', '', '00:00:00', '00:00:00', ?)"); $ins->bind_param("sssss", $gname, $Admin_ID, $Master_ID, $manager_id, $dt); if ($ins->execute()) set_flash_msg("Group '$gname' added!", 'success'); else set_flash_msg('Error: '.$ins->error, 'warning'); $ins->close(); } else { set_flash_msg('Group already exists for this manager.', 'warning'); } $chk->close(); } else { set_flash_msg('Please select a manager and enter a group name.', 'warning'); } header('Location: addgroup.php'); exit(); } if (isset($_POST['delete'])) { $gid = $_POST['Group_ID'] ?? 0; $manager_id = $_POST['Manager_ID'] ?? ''; if ($gid && $manager_id) { $del = $mysqli->prepare("DELETE FROM manager_group_name WHERE Group_ID = ? AND Admin_ID = ? AND Manager_ID = ?"); $del->bind_param("iss", $gid, $Admin_ID, $manager_id); $del->execute(); set_flash_msg('Group deleted.', 'success'); $del->close(); } header('Location: addgroup.php'); exit(); } ?> Add Group

Manage Groups

Add Group to Manager

Existing Groups

prepare("SELECT g.Group_ID, g.Group_Name, g.Manager_ID, CONCAT(mp.First_Name, ' ', mp.Last_Name) AS Manager_Name FROM manager_group_name g JOIN manager_profile mp ON g.Manager_ID = mp.Manager_ID WHERE g.Admin_ID = ? ORDER BY mp.First_Name, g.Group_Name"); $gl->bind_param("s", $Admin_ID); $gl->execute(); $gr = $gl->get_result(); while ($g = $gr->fetch_assoc()) { echo ""; } $gl->close(); ?>

Manager	Group Name	Action
".htmlspecialchars($g['Manager_Name'])."	".htmlspecialchars($g['Group_Name'])."