'new',20 => 'feedback',30 => 'acknowledged',
40 => 'confirmed',50 => 'assigned',80 => 'resolved',90 => 'closed');
private $status_color = array('new' => '#ffa0a0', # red,
'feedback' => '#ff50a8', # purple
'acknowledged' => '#ffd850', # orange
'confirmed' => '#ffffb0', # yellow
'assigned' => '#c8c8ff', # blue
'resolved' => '#cceedd', # buish-green
'closed' => '#e8e8e8'); # light gray
var $defaultResolvedStatus;
/**
* Construct and connect to BTS.
*
* @param str $type (see tlIssueTracker.class.php $systems property)
* @param xml $cfg
**/
function __construct($type,$config,$name)
{
parent::__construct($type,$config,$name);
if( !$this->isConnected() )
{
return false;
}
$this->interfaceViaDB = true;
$this->defaultResolvedStatus = array();
$this->defaultResolvedStatus[] = array('code' => 80, 'verbose' => 'resolved');
$this->defaultResolvedStatus[] = array('code' => 90, 'verbose' => 'closed');
$this->setResolvedStatusCfg();
$this->methodOpt['buildViewBugLink'] = array('addSummary' => true, 'colorByStatus' => true);
$this->guiCfg = array('use_decoration' => true);
if( property_exists($this->cfg, 'statuscfg') )
{
$this->setStatusCfg();
}
}
/**
* Return the URL to the bugtracking page for viewing
* the bug with the given id.
*
* @param int id the bug id
*
* @return string returns a complete URL to view the bug
**/
function buildViewBugURL($id)
{
return $this->cfg->uriview . urlencode($id);
}
/**
*
**/
function getIssue($id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
if (!$this->isConnected())
{
return false;
}
$sql = "/* $debugMsg */ SELECT id,status,summary FROM mantis_bug_table " .
" WHERE id=" . intval($id);
$rs = $this->dbConnection->fetchRowsIntoMap($sql,'id');
$issue = null;
if( !is_null($rs) )
{
$issueOnMantisDB = current($rs);
$issue = new stdClass();
$issue->IDHTMLString = "{$id} : ";
$issue->summaryHTMLString = $issueOnMantisDB['summary'];
$issue->id = $issueOnMantisDB['id'];
$issue->summary = $issueOnMantisDB['summary'];
$issue->statusCode = $issueOnMantisDB['status'];
$issue->isResolved = isset($this->resolvedStatus->byCode[$issue->statusCode]);
if( isset($this->code_status[$issue->statusCode]) )
{
$issue->statusVerbose = $this->code_status[$issue->statusCode];
}
else
{
// give info to user on Event Viewer
$msg = lang_get('MANTIS_status_not_configured');
$msg = sprintf($msg,$issueOnMantisDB['status']);
logWarningEvent($msg,"MANTIS INTEGRATION");
$issue->statusVerbose = 'custom_undefined_on_tl';
}
$issue->statusHTMLString = $this->buildStatusHTMLString($issue->statusVerbose);
$issue->statusColor = isset($this->status_color[$issue->statusVerbose]) ?
$this->status_color[$issue->statusVerbose] : 'white';
}
return $issue;
}
/**
* Returns the status of the bug with the given id
* this function is not directly called by TestLink.
*
* @return string returns the status of the given bug (if found in the db), or false else
**/
function getBugStatus($id)
{
if (!$this->isConnected())
{
return false;
}
$issue = $this->getIssue($id);
return (!is_null($issue) && $issue) ? $issue->statusVerbose : null;
}
/**
* checks is bug id is present on BTS
*
* @return integer returns 1 if the bug with the given id exists
**/
function checkBugIDExistence($id)
{
$status_ok = 0;
$query = "SELECT status FROM mantis_bug_table WHERE id='" . $id ."'";
$result = $this->dbConnection->exec_query($query);
if ($result && ($this->dbConnection->num_rows($result) == 1))
{
$status_ok = 1;
}
return $status_ok;
}
/**
* checks id for validity
*
* @param string issueID
*
* @return bool returns true if the bugid has the right format, false else
**/
function checkBugIDSyntax($issueID)
{
return $this->checkBugIDSyntaxNumeric($issueID);
}
/**
*
*
**/
function buildStatusHTMLString($statusVerbose)
{
$str = '';
if ($statusVerbose !== false)
{
// status values depends on your mantis configuration at config_inc.php in $g_status_enum_string,
// below is the default:
//'10:new,20:feedback,30:acknowledged,40:confirmed,50:assigned,80:resolved,90:closed'
// With this replace if user configure status on mantis with blank we do not have problems
//
$tlStatus = str_replace(" ", "_", $statusVerbose);
$str = lang_get('issue_status_' . $tlStatus);
if($this->guiCfg['use_decoration'])
{
$str = "[" . $str . "] ";
}
}
return $str;
}
function getMyInterface()
{
return $this->cfg->interfacePHP;
}
public static function getCfgTemplate()
{
$template = "\n" .
"\n" .
"DATABASE SERVER NAME\n" .
"DATABASE NAME\n" .
"mysql\n" .
"USER\n" .
"PASSWORD\n" .
"http://localhost:8080/development/mantisbt-1.2.5/view.php?id=\n" .
"http://localhost:8080/development/mantisbt-1.2.5/\n" .
"\n" .
"\n" .
"10new#ffa0a0\n" .
"20feedback#ff50a8\n" .
"30acknowledged#ffd850\n" .
"40confirmed#ffffb0\n" .
"50assigned#c8c8ff\n" .
"80resolved#cceedd\n" .
"90closed#e8e8e8\n" .
"\n" .
"\n" .
"\n" .
"80resolved\n" .
"90closed\n" .
"\n" .
"\n";
"\n";
return $template;
}
public function setStatusCfg()
{
$statusCfg = (array)$this->cfg->statuscfg;
foreach($statusCfg['status'] as $cfx)
{
$e = (array)$cfx;
$this->code_status[$e['code']] = $e['verbose'];
$this->status_color[$e['verbose']] = $e['color'];
}
}
public function getCodeStatus()
{
return $this->code_status;
}
public function getStatusColor()
{
return $this->status_color;
}
}
?>