require_once 'pages/issues_table.inc.php';
break;
//////// UPDATE MILESTONE
//////// UPDATE MILESTONE
case 'updateMilestone':
$values = array();
foreach ($_POST as $k => $v) {
if (strncmp($k, 'mile_', 5) == 0) {
if (strcmp($k, MILE_DUEDATE) == 0) {
$values[$k] = strtotime($v);
continue;
}
$values[$k] = $v;
}
}
$error = DbHelper::exec('REPLACE INTO ' . TBL_MILESTONES . ' ' . DbHelper::convertArrToInsertValues($values));
if ($error == null) {
Helper::pushAlert(ALERT_SUCCESS, 'Milestone updated with success !');
} else {
Helper::pushAlert(ALERT_ERROR, 'An error occured while trying to insert/update the milestone !');
}
header('Location:index.php?p=' . PAGE_ID_ISSUES . '&n=mil');
break;
//////// UPDATE ISSUE DETAILS
//////// UPDATE ISSUE DETAILS
case 'updateIssueDetails':
$error = DbHelper::exec('UPDATE ' . TBL_ISSUES . ' SET ' . ISSUE_MILESTONE_ID . '=' . (empty($_POST['new_milestone']) ? 'null' : $_POST['new_milestone']) . ', ' . ISSUE_COMMENT . '="' . addslashes($_POST['new_comment']) . '"' . ' WHERE ' . ISSUE_ID . '=' . $_POST['issue_id']);
if ($error == null) {
Helper::pushAlert(ALERT_SUCCESS, 'Issue updated with success !');
} else {
Helper::pushAlert(ALERT_ERROR, 'An error occured while updating the issue !');
