isConnected() )
{
return false;
}
$this->methodOpt['buildViewBugLink'] = array('addSummary' => true, 'colorByStatus' => true);
$this->interfaceViaDB = true;
$this->support = new jiraCommons();
$this->support->guiCfg = array('use_decoration' => true);
// Tables used
$this->dbSchema = new stdClass();
$this->dbSchema->issues = 'jiraissue';
$this->dbSchema->status = 'issuestatus';
$this->dbSchema->project = 'project';
$this->getStatuses();
if( property_exists($this->cfg, 'statuscfg') )
{
$this->setStatusCfg();
}
if( !property_exists($this->cfg, 'jiraversion') )
{
// throw new Exception("jiraversion is MANDATORY - Unable to continue");
$msg = " - Issuetracker $this->name - jiraversion is MANDATORY - Unable to continue";
tLog(__METHOD__ . $msg, 'ERROR');
return false;
}
else
{
$this->completeCfg();
}
$this->defaultResolvedStatus = $this->support->initDefaultResolvedStatus($this->statusDomain);
$this->setResolvedStatusCfg();
}
/**
*
*/
function completeCfg()
{
// when working with simpleXML objects is better to use intermediate variables
$sz = (string)$this->cfg->jiraversion;
$pieces = explode('.',$sz);
$this->cfg->majorVersionNumber = (int)$pieces[0];
if($this->cfg->majorVersionNumber <= 0)
{
throw new Exception("Version has to be MAJOR.MINOR" . ' - got : ' . $sz , 1);
}
}
/**
*
**/
function getIssue($issueID)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
if (!$this->isConnected())
{
return false;
}
// ATTENTION:
// Field names on Jira tables seems to be sometimes on CAPITALS
// TICKET 6028: Integration with Jira 6.1 broken. - Due to JIRA schema changes
\Kint::dump($this->dbConnection);
if(intval($this->cfg->majorVersionNumber) >= 6)
{
$dummy = explode("-",$issueID);
$addFields = ",ISSUES.project, ISSUES.issuenum, PROJECT.originalkey, PROJECT.id ";
$addJoin = " JOIN {$this->dbSchema->project} PROJECT ON ISSUES.project = PROJECT.id ";
$where = " WHERE ISSUES.issuenum='{$this->dbConnection->prepare_string($dummy[1])}' " .
" AND PROJECT.originalkey='{$this->dbConnection->prepare_string($dummy[0])}'";
}
else
{
$addFields = ",ISSUES.pkey ";
$addJoin = '';
$where = " WHERE ISSUES.pkey='{$this->dbConnection->prepare_string($issueID)}'";
}
$sql = "/* $debugMsg */ " .
" SELECT ISSUES.ID AS id, ISSUES.summary,ISSUES.issuestatus AS status_code, " .
" ST.pname AS status_verbose " . $addFields .
" FROM {$this->dbSchema->issues} ISSUES " .
" JOIN {$this->dbSchema->status} ST ON ST.ID = ISSUES.issuestatus " .
$addJoin . $where;
try
{
$rs = $this->dbConnection->fetchRowsIntoMap($sql,'id');
}
catch (Exception $e)
{
$rs = null;
$msg = "JIRA DB - Ticket ID $issueID - " . $e->getMessage();
tLog($msg, 'WARNING');
}
$issue = null;
if( !is_null($rs) )
{
$issueOnDB = current($rs);
$issue = new stdClass();
$issue->IDHTMLString = "{$issueID} : ";
$issue->summary = $issueOnDB['summary'];
$issue->statusCode = $issueOnDB['status_code'];
$issue->statusVerbose = $issueOnDB['status_verbose'];
$issue->statusHTMLString = $this->support->buildStatusHTMLString($issue->statusVerbose);
$issue->summaryHTMLString = $this->support->buildSummaryHTMLString($issue);
$issue->isResolved = isset($this->resolvedStatus->byCode[$issue->statusCode]);
}
return $issue;
}
/**
*
*/
function getMyInterface()
{
return $this->cfg->interfacePHP;
}
/**
*
*/
function getStatuses()
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
if (!$this->isConnected())
{
return false;
}
// ATTENTION:
// Field names on Jira tables seems to be sometimes on CAPITALS
$sql = "/* $debugMsg */ " .
" SELECT ST.ID AS id,ST.pname AS name FROM {$this->dbSchema->status} ST";
try
{
$rs = $this->dbConnection->fetchRowsIntoMap($sql,'id');
foreach ($rs as $id => $elem)
{
$this->statusDomain[$elem['name']]=$id;
}
}
catch (Exception $e)
{
tLog("JIRA DB " . __METHOD__ . $e->getMessage(), 'WARNING');
}
}
/**
*
* @author francisco.mancardi@gmail.com>
**/
public function getStatusDomain()
{
return $this->statusDomain;
}
/**
* 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->checkBugIDSyntaxString($issueID);
}
public static function getCfgTemplate()
{
$template = "\n" .
"\n" .
"MANDATORY\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" .
"80resolved\n" .
"90closed\n" .
"\n" .
"\n";
return $template;
}
/**
*
**/
function canCreateViaAPI()
{
return false;
}
}