/**
* Delete a tracker
*
* @aparam atid: the artifact type id
*
* @return boolean
*/
function deleteArtifactType($atid)
{
// Delete artifact_canned_responses
$sql = "DELETE FROM artifact_canned_responses \n\t\t\t WHERE group_artifact_id=" . db_ei($atid);
db_query($sql);
// Delete artifact_notification
$sql = "DELETE FROM artifact_notification \n\t\t\t WHERE group_artifact_id=" . db_ei($atid);
db_query($sql);
// Delete artifact_notification_event
$sql = "DELETE FROM artifact_notification_event \n\t\t\t WHERE group_artifact_id=" . db_ei($atid);
db_query($sql);
// Delete artifact_notification_role
$sql = "DELETE FROM artifact_notification_role \n\t\t\t WHERE group_artifact_id=" . db_ei($atid);
db_query($sql);
// Delete artifact_perm
$sql = "DELETE FROM artifact_perm \n\t\t\t WHERE group_artifact_id=" . db_ei($atid);
db_query($sql);
// We need to instanciate an artifactType to instanciate the factories
$artifactType = new ArtifactType($this->getGroup(), $atid, false);
$art_field_fact = new ArtifactFieldFactory($artifactType);
$art_fieldset_fact = new ArtifactFieldSetFactory($artifactType);
// Delete the fields of this tracker
$art_field_fact->deleteFields($atid);
// Delete the field sets of this tracker
$art_fieldset_fact->deleteFieldSets();
// Delete the artifact_report
$art_report_fact = new ArtifactReportFactory();
$art_report_fact->deleteReports($atid);
//Generate an event
$em =& EventManager::instance();
$pref_params = array('atid' => $atid);
$em->processEvent('artifactType_deleted', $pref_params);
// Delete the artifact rules
$art_rule_fact = ArtifactRuleFactory::instance();
$art_rule_fact->deleteRulesByArtifactType($atid);
// Delete artifact_watcher (be carefull, the column is named artifact_group_id)
$sql = "DELETE FROM artifact_watcher \n\t\t\t WHERE artifact_group_id=" . db_ei($atid);
db_query($sql);
// Delete all records linked to artifact_id
$sql_artifacts = 'SELECT artifact_id ' . 'FROM artifact ' . 'WHERE group_artifact_id=' . db_ei($atid);
//echo $sql_artifacts;
$res = db_query($sql_artifacts);
while ($artifacts_array = db_fetch_array($res)) {
$id = $artifacts_array["artifact_id"];
// Delete artifact_cc records
$sql = "DELETE FROM artifact_cc WHERE artifact_id = " . db_ei($id);
db_query($sql);
// Delete artifact_dependencies records
$sql = "DELETE FROM artifact_dependencies WHERE artifact_id = " . db_ei($id);
db_query($sql);
// Delete artifact_field_value records
$sql = "DELETE FROM artifact_field_value WHERE artifact_id = " . db_ei($id);
db_query($sql);
// Delete artifact_file records
$sql = "DELETE FROM artifact_file WHERE artifact_id = " . db_ei($id);
db_query($sql);
// Delete artifact_history records
$sql = "DELETE FROM artifact_history WHERE artifact_id = " . db_ei($id);
db_query($sql);
// Delete artifact records
$sql = "DELETE FROM artifact WHERE artifact_id = " . db_ei($id);
db_query($sql);
}
// while
// Delete artifact_group_list
$sql = "DELETE FROM artifact_group_list\n\t\t\t WHERE group_artifact_id=" . db_ei($atid);
//echo $sql;
$result = db_query($sql);
if (!$result || db_affected_rows($result) <= 0) {
$this->setError('Error: deleteArtifactType ' . db_error());
return false;
}
//Remove permissions
permission_clear_all_tracker($this->Group->getID(), $atid);
$em = EventManager::instance();
$em->processEvent("artifact_type_factory_delete_artifact_type", array('tracker_id' => $atid));
return true;
}
case 'delete':
// Create field factory
if ($group = $pm->getProject($request->getValidated('group_id', 'GroupId'))) {
$atid = $request->getValidated('atid', 'uint');
$ath = new ArtifactType($group, $atid);
$atf = new ArtifactTypeFactory($group);
$art_field_fact = new ArtifactFieldFactory($ath);
// Then delete all the fields informations
if (!$art_field_fact->deleteFields($atid)) {
exit_error($Language->getText('global', 'error'), $art_field_fact->getErrorMessage());
return false;
}
// Then delete all the reports informations
// Create field factory
$art_report_fact = new ArtifactReportFactory();
if (!$art_report_fact->deleteReports($atid)) {
exit_error($Language->getText('global', 'error'), $art_report_fact->getErrorMessage());
return false;
}
// Delete the artifact type itself
if (!$atf->deleteArtifactType($atid)) {
exit_error($Language->getText('global', 'error'), $atf->getErrorMessage());
}
$feedback = $Language->getText('tracker_admin_restore', 'tracker_deleted');
}
break;
default:
break;
}
// switch
$group = $pm->getProject(1);
