db = $db;
$this->testPlanID = $tplanId;
// tlObjectWithDB::__construct($db);
parent::__construct($this->db);
}
/**
* Function returns array with input for reports navigator
*
* @param object $context
* @param boolean $bug_interface_enabled
* @param boolean $req_mgmt_enabled
* @param integer $format format identifier
*
* @return array of array - described for array $g_reports_list in const.inc.php
**/
public function get_list_reports($context,$bug_interface_enabled, $req_mgmt_enabled, $format) {
$reportList = config_get('reports_list');
$items = array();
$toggleMsg = lang_get('show_hide_direct_link');
$canNotCreateDirectLink = lang_get('can_not_create_direct_link');
$apiKeyLen = strlen(trim($context->apikey));
$apiKeyIsValid = ($apiKeyLen == 32 || $apiKeyLen == 64); // I'm sorry for MAGIC
$xdx = 0;
foreach ($reportList as &$rptItem) {
// check validity of report
if (($rptItem['enabled'] == 'all') ||
(($rptItem['enabled'] == 'req') && $req_mgmt_enabled) ||
(($rptItem['enabled'] == 'bts') && $bug_interface_enabled)) {
if (strpos(",".$rptItem['format'],$format) > 0) {
$reportUrl = $rptItem['url'] . ( stristr($rptItem['url'], "?") ? '&' : '?');
$items[$xdx] =
array('name' => lang_get($rptItem['title']),
'href' => $reportUrl, 'directLink' => '');
if(isset($rptItem['directLink']) &&
trim($rptItem['directLink']) != '') {
if($apiKeyIsValid) {
$items[$xdx]['directLink'] =
sprintf($rptItem['directLink'],$_SESSION['basehref'],
$context->apikey,$context->tproject_id,$context->tplan_id);
} else {
$items[$xdx]['directLink'] = $canNotCreateDirectLink;
}
}
$dl = $items[$xdx]['directLink'];
$mask = '
';
$divClass = 'direct_link_' . $xdx;
$items[$xdx]['toggle'] = sprintf($mask,$toggleMsg,$toggleMsg,$divClass);
$items[$xdx]['directLinkDiv'] = '';
$xdx++;
}
}
}
return $items;
}
/**
* get count of builds
*
* @param boolean $active (optional) query open builds [0,1]
* @param boolean $open (optional) query active builds [0,1]
*
* @return integer count of builds
*/
public function get_count_builds($active=1, $open=0) {
$sql = " SELECT COUNT(0) FROM {$this->tables['builds']} builds " .
" WHERE builds.testplan_id = {$this->testPlanID} ";
if( $active )
{
$sql .= " AND active=" . intval($active) . " ";
}
if( $open )
{
$sql .= " AND is_open=" . intval($open) . " ";
}
return $this->db->fetchOneValue($sql);
}
/**
* get count of testcase linked to a testplan
* @return integer count
*/
public function get_count_testcase4testplan()
{
$sql = " SELECT COUNT(0) FROM {$this->tables['testplan_tcversions']} testplan_tcversions " .
" WHERE testplan_id = {$this->testPlanID} ";
return $this->db->fetchOneValue($sql);
}
} // end class result
?>