$selected_order = $count['skillplan_order'] + 1;
} else {
// The user wants this skillplan inserted into the mix, so lets see where it's going to go.
$selected_order = $_POST['skillplan_order'];
// Now we will update all other skillplans for this group with a number equal or greater to our selected_order, and add 1 to them to push them down
$stmt = $db->prepare('UPDATE skillplan_main SET skillplan_order = skillplan_order +1 WHERE skillplan_order >= ? AND gid = ?');
$stmt->execute(array($selected_order, $user->getGroup()));
}
// Adding the requested skillplan to our database
$stmt = $db->prepare('INSERT INTO skillplan_main (gid,skillplan_name,skillplan_order) VALUES (?,?,?) ON DUPLICATE KEY UPDATE skillplan_order=VALUES(skillplan_order)');
$stmt->execute(array($user->getGroup(), $_POST['skillplan_name'], $selected_order));
} elseif ($request['action'] == 'deleteplan' and $user->getDirectorAccess()) {
if ($_POST['skillplan_id'] == 'Do Not Delete') {
// Skipping this, since they accidentally clicked it. Whoops, bad user
} else {
Skillplan::deleteSkillPlan($_POST['skillplan_id'], $user->getGroup());
}
} elseif ($request['action'] == 'renameplan' and $user->getDirectorAccess()) {
if ($_POST['skillplan_id'] == 'Do Not Rename') {
// Skipping this, since they accidentally clicked it. Whoops, bad user
} else {
Skillplan::renameSkillPlan($_POST['skillplan_id'], $user->getGroup(), $_POST['new_skill_plan_name']);
}
} elseif ($request['action'] == 'editmode' and $user->getDirectorAccess()) {
// We are currently in edit mode, so we will check to see if there's anything that needs doing
if (isset($_POST['new_subgroup_name'])) {
// We are adding a new subgroup to an existing Skill Plan
// First we need to see what order was selected
if ($_POST['subgroup_order'] == 'last') {
// The user wants this skillplan at the end, so we'll first get the highest skillplan_order value
$stmt = $db->prepare('SELECT * FROM skillplan_subgroups WHERE skillplan_id = ? ORDER BY subgroup_order DESC LIMIT 1');
