echo 'You missed report ids !';
}
break;
//////// SET ISSUE FOR REPORTS
//////// SET ISSUE FOR REPORTS
case 'setReportsIssue':
$reportIds = @$_POST['reportIds'];
$currentIssueId = @$_POST['currentIssueId'];
$newIssueId = @$_POST['newIssueId'];
if (!empty($reportIds) && !empty($currentIssueId) && !empty($newIssueId)) {
// update reports
DbHelper::exec('UPDATE ' . TBL_REPORTS . ' SET ' . REPORT_ISSUE . '=' . $newIssueId . ' WHERE ' . REPORT_ID . ' IN (' . $reportIds . ')');
// delete issue if no more reports attached
$count = DbHelper::countRows(TBL_REPORTS, REPORT_ISSUE . '=' . $currentIssueId);
if ($count == 0) {
DbHelper::deleteIssues($currentIssueId);
}
} else {
$error = "Invalid parameters !";
}
if ($error == null) {
Helper::pushAlert(ALERT_SUCCESS, 'Reports switched with success !');
} else {
Helper::pushAlert(ALERT_ERROR, $error);
}
header('Location:index.php?p=' . PAGE_ID_ISSUES);
break;
//////// GET ISSUES TABLE
//////// GET ISSUES TABLE
case 'getIssuesTbl':
// get reports preferences
