public static function deleteSkillPlan($skillplan_id, $groupID)
{
global $db;
$stmt = $db->prepare('SELECT * FROM skillplan_subgroups WHERE skillplan_id = ? AND gid = ?');
$stmt->execute(array($skillplan_id, $groupID));
$subgroupList = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($subgroupList as $subgroup) {
Skillplan::deleteSubGroup($subgroup['subgroup_id']);
}
$stmt = $db->prepare('DELETE FROM skillplan_main WHERE skillplan_id = ? AND gid = ?');
$stmt->execute(array($skillplan_id, $groupID));
}
$stmt = $db->prepare('DELETE FROM skillplan_subgroups WHERE subgroup_id = ? AND skillplan_id = ?');
$stmt->execute(array($_POST['delete_subgroup_id'], $_POST['skillplan_id']));
} elseif (isset($_POST['new_skill_name'])) {
$newSkillID = $eve->getTypeID($_POST['new_skill_name']);
if ($newSkillID != NULL) {
$stmt = $db->prepare('INSERT INTO skillplan_skills (subgroup_id,skill_typeid,skill_typename,skill_level) VALUES (?,?,?,?) ON DUPLICATE KEY UPDATE skill_level=VALUES(skill_level)');
$stmt->execute(array($_POST['subgroup_id'], $newSkillID, $_POST['new_skill_name'], $_POST['required_skill_level']));
}
} elseif (isset($_POST['delete_skill_id'])) {
$stmt = $db->prepare('DELETE FROM skillplan_skills WHERE subgroup_id = ? AND skill_typeid = ?');
$stmt->execute(array($_POST['subgroup_id'], $_POST['delete_skill_id']));
}
}
}
// Getting all of our skill plans via Skillplan class
$plans = new Skillplan($db, $user->getGroup(), $user->getDefaultID());
require_once 'includes/header.php';
?>
<div class="opaque-container" role="tablist" aria-multiselectable="true">
<div class="row" style="width: 100%; margin-top: 20px; margin-bottom: 20px">
<?php
if ($user->getDirectorAccess()) {
?>
<div class="col-md-12 opaque-section" style="padding: 0px">
<div class="row box-title-section" role="tab" id="AddSkillPlanHeading">
<a class="box-title-link" style="text-decoration: none" role="button" data-toggle="collapse" data-parent="AddSkillPlan" href="#collapseAddSkillPlan" aria-expanded="true" aria-controls="collapseAddSkillPlan">
<h1 class="eve-text" style="margin-top: 10px; text-align: center; font-size: 200%; font-weight: 700">Skill Plans and Training Information</h1>
</a>
</div>
<div id="collapseAddSkillPlan" class="panel-collapse collapse out" role="tabpanel" aria-labelledby="AddSkillPlanHeading">
