include_once APP_INC_PATH . "class.phone_support.php";
include_once APP_INC_PATH . "class.status.php";
include_once APP_INC_PATH . "class.history.php";
include_once APP_INC_PATH . "class.user.php";
include_once APP_INC_PATH . "class.authorized_replier.php";
include_once APP_INC_PATH . "db_access.php";
$tpl = new Template_API();
$tpl->setTemplate("popup.tpl.html");
Auth::checkAuthentication(APP_COOKIE, 'index.php?err=5', true);
$usr_id = Auth::getUserID();
$prj_id = Auth::getCurrentProject();
if (@$HTTP_GET_VARS["cat"] == "delete_note") {
$res = Note::remove($HTTP_GET_VARS["id"]);
$tpl->assign("note_delete_result", $res);
} elseif (@$HTTP_GET_VARS["cat"] == "delete_time") {
$res = Time_Tracking::removeEntry($HTTP_GET_VARS["id"], $usr_id);
$tpl->assign("time_delete_result", $res);
} elseif (@$HTTP_POST_VARS["cat"] == "bulk_update") {
$res = Issue::bulkUpdate();
$tpl->assign("bulk_update_result", $res);
} elseif (@$HTTP_POST_VARS["cat"] == "set_initial_impact") {
$res = Issue::setImpactAnalysis($HTTP_POST_VARS["issue_id"]);
$tpl->assign("set_initial_impact_result", $res);
} elseif (@$HTTP_POST_VARS["cat"] == "add_requirement") {
$res = Impact_Analysis::insert($HTTP_POST_VARS["issue_id"]);
$tpl->assign("add_requirement_result", $res);
} elseif (@$HTTP_POST_VARS["cat"] == "set_impact_requirement") {
$res = Impact_Analysis::update($HTTP_POST_VARS["isr_id"]);
$tpl->assign("set_impact_requirement_result", $res);
} elseif (@$HTTP_POST_VARS["cat"] == "delete_requirement") {
$res = Impact_Analysis::remove();
/**
* Method used to remove a specific phone support entry from the
* application.
*
* @access public
* @param integer $phone_id The phone support entry ID
* @return integer 1 if the removal worked, -1 or -2 otherwise
*/
function remove($phone_id)
{
$phone_id = Misc::escapeInteger($phone_id);
$stmt = "SELECT\n phs_iss_id,\n phs_ttr_id,\n phs_usr_id\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "phone_support\n WHERE\n phs_id={$phone_id}";
$details = $GLOBALS["db_api"]->dbh->getRow($stmt, DB_FETCHMODE_ASSOC);
if ($details['phs_usr_id'] != Auth::getUserID()) {
return -2;
}
$stmt = "DELETE FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "phone_support\n WHERE\n phs_id={$phone_id}";
$res = $GLOBALS["db_api"]->dbh->query($stmt);
if (PEAR::isError($res)) {
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
return -1;
} else {
Issue::markAsUpdated($details["phs_iss_id"]);
// need to save a history entry for this
History::add($details["phs_iss_id"], Auth::getUserID(), History::getTypeID('phone_entry_removed'), 'Phone Support entry removed by ' . User::getFullName(Auth::getUserID()));
if (!empty($details["phs_ttr_id"])) {
$time_result = Time_Tracking::removeEntry($details["phs_ttr_id"], $details['phs_usr_id']);
if ($time_result == 1) {
return 2;
} else {
return $time_result;
}
} else {
return 1;
}
}
}
