*/
require_once('common/include/Error.class');
-function &artifactType_get_object($artType_id,$res=false) {
- global $ARTIFACTTYPE_OBJ;
- if (!isset($ARTIFACTTYPE_OBJ["_".$artType_id."_"])) {
- if ($res) {
- //the db result handle was passed in
- } else {
- $res=db_query("SELECT * FROM artifact_group_list_vw
- WHERE group_artifact_id='$artType_id'");
- }
- if (!$res || db_numrows($res) < 1 ){
- $ARTIFACTTYPE_OBJ["_".$artType_id."_"]=false;
- } else {
- $data =& db_fetch_array($res);
- $Group =& group_get_object($data["group_id"]);
- $ARTIFACTTYPE_OBJ["_".$artType_id."_"]= new ArtifactType($Group,$data["group_artifact_id"],$data);
+ /**
+ * Gets an ArtifactType object from the artifact type id
+ *
+ * @param artType_id the ArtifactType id
+ * @param res the DB handle if passed in (optional)
+ * @return the ArtifactType object
+ */
+ function &artifactType_get_object($artType_id,$res=false) {
+ global $ARTIFACTTYPE_OBJ;
+ if (!isset($ARTIFACTTYPE_OBJ["_".$artType_id."_"])) {
+ if ($res) {
+ //the db result handle was passed in
+ } else {
+ $res=db_query("SELECT * FROM artifact_group_list_vw
+ WHERE group_artifact_id='$artType_id'");
+ }
+ if (!$res || db_numrows($res) < 1 ){
+ $ARTIFACTTYPE_OBJ["_".$artType_id."_"]=false;
+ } else {
+ $data =& db_fetch_array($res);
+ $Group =& group_get_object($data["group_id"]);
+ $ARTIFACTTYPE_OBJ["_".$artType_id."_"]= new ArtifactType($Group,$data["group_artifact_id"],$data);
+ }
}
- }
- return $ARTIFACTTYPE_OBJ["_".$artType_id."_"];
-}
+ return $ARTIFACTTYPE_OBJ["_".$artType_id."_"];
+ }
class ArtifactType extends Error {
class ArtifactsForUser extends Error {
-//artifact_vw
var $User;
var $Group;
var $ArtifactType;
var $Artifact;
+ /**
+ * Creates a new ArtifactsFor User object
+ *
+ * @param user the User object for which to collect artifacts
+ */
function ArtifactsForUser(&$user) {
$this->User =& $user;
return true;
}
/**
- * getArtifactsFromSQL
- * $sql - The sql that returns artifact_id
- *
- * @return Artifact[] The array of Artifacts
- *
+ * getArtifactsFromSQL - Gets an array of Artifacts
+ *
+ * @param sql The sql that returns artifact_id
+ * @return Artifact[] The array of Artifacts
*/
function getArtifactsFromSQL($sql) {
$artifacts = array();
- $result=db_query($sql);
- $rows=db_numrows($result);
- if ($rows<=0) {
- return $artifacts;
- }
- for ($i=0; $i < $rows; $i++) {
- $id = db_result($result,$i,'artifact_id');
+ $result=db_query($sql);
+ $rows=db_numrows($result);
+ if ($rows<=0) {
+ return $artifacts;
+ }
+ for ($i=0; $i < $rows; $i++) {
+ $id = db_result($result,$i,'artifact_id');
$arr = db_fetch_array($result);
- $afi =& new ArtifactFromID($id,$arr);
- if ($afi->isError()) {
- $this->setError($afi->getErrorMessage());
+ $afi =& new ArtifactFromID($id,$arr);
+ if ($afi->isError()) {
+ $this->setError($afi->getErrorMessage());
echo "Error =".$afi->getErrorMessage()."<br>";
- } else {
- $artifacts[] =& $afi->Artifact;
+ } else {
+ $artifacts[] =& $afi->Artifact;
}
- }
- return $artifacts;
- }
-
- /**
- * getAssignedArtifacts
- *
- * @return Artifact[] The array of Artifacts
- *
- */
- function getAssignedArtifactsByGroup() {
- $sql="SELECT *
- FROM artifact_vw av
- WHERE av.assigned_to=".$this->User->getID()."
- AND av.status_id='1'
- ORDER BY av.artifact_group_id,
- av.group_artifact_id,
- av.assigned_to,
- av.status_id";
-
+ }
+ return $artifacts;
+ }
+ /**
+ * getAssignedArtifacts - Get the users's assigned artifacts
+ * @return Artifact[] The array of Artifacts
+ */
+ function getAssignedArtifactsByGroup() {
+ $sql="SELECT * FROM artifact_vw av WHERE av.assigned_to=".$this->User->getID()."
+ AND av.status_id='1' ORDER BY av.artifact_group_id, av.group_artifact_id, av.assigned_to, av.status_id";
return $this->getArtifactsFromSQL($sql);
}
* getSubmittedArtifactsByGroup
*
* @return Artifact[] The array of Artifacts
- *
*/
function getSubmittedArtifactsByGroup() {
$sql="SELECT *
WHERE av.submitted_by=".$this->User->getID()."
AND av.status_id='1'
ORDER BY av.artifact_group_id,av.group_artifact_id,av.assigned_to,av.status_id";
-
-
return $this->getArtifactsFromSQL($sql);
}
-
-
-
}
-
?>