/** * @fn software_artifact_list * @short Action method to show a list of software artifacts. */ public function software_artifact_list() { $conn = Db::get_connection(); $artifact_factory = new SoftwareArtifact(); if (!isset($_REQUEST['id'])) { $_REQUEST['id'] = 0; $this->artifacts = $artifact_factory->find_all(array('order_by' => '`file` ASC, `priority` DESC')); } else { $this->release = new SoftwareRelease(); if ($this->release->find_by_id($_REQUEST['id']) === FALSE) { $this->redirect_to(array('action' => 'software_list')); } $this->artifacts = $artifact_factory->find_all(array('where_clause' => "`release_id` = '{$conn->escape($_REQUEST['id'])}'", 'order_by' => '`priority` DESC')); } Db::close_connection($conn); }