Ejemplo n.º 1
0
 /**
  *	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;
 }
 function _getArtifactRuleFactory()
 {
     return ArtifactRuleFactory::instance();
 }