Example #1
0
 /**
  * Method used to get the details for a given project ID.
  *
  * @access  public
  * @param   integer $prj_id The project ID
  * @return  array The project details
  */
 function getDetails($prj_id)
 {
     $stmt = "SELECT\n                    *\n                 FROM\n                    " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "project\n                 WHERE\n                    prj_id=" . Misc::escapeInteger($prj_id);
     $res = $GLOBALS["db_api"]->dbh->getRow($stmt, DB_FETCHMODE_ASSOC);
     if (PEAR::isError($res)) {
         Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
         return "";
     } else {
         $res["prj_assigned_users"] = Project::getUserColList($res["prj_id"]);
         $res['assigned_statuses'] = array_keys(Status::getAssocStatusList($res['prj_id']));
         return $res;
     }
 }