";
}
}
return $cf_smarty;
} // function end
/*
function: get_linked_cfields_at_execution
args: $id
[$parent_id]
[$show_on_execution]: default: null
1 -> filter on field show_on_execution=1
0 or null -> don't filter
//@TODO - 20090718 - franciscom
// this filter has any sense ?
// review and remove if needed
[$execution_id]: null -> get values for all executions availables for testcase
!is_null -> only get values or this execution_id
[$testplan_id]: null -> get values for any tesplan to with testcase is linked
!is_null -> get values only for this testplan.
[$tproject_id]:
returns: hash
key: custom field id
value: map with custom field definition, with keys:
id: custom field id
name
label
type
possible_values
default_value
valid_regexp
length_min
length_max
show_on_design
enable_on_design
show_on_execution
enable_on_execution
display_order
*/
function get_linked_cfields_at_execution($id,$parent_id=null,$show_on_execution=null,
$execution_id=null,$testplan_id=null,
$tproject_id = null, $location=null)
{
$thisMethod=__FUNCTION__;
if (!$tproject_id)
{
$tproject_id = $this->getTestProjectFromTestCase($id,$parent_id);
}
// VERY IMPORTANT WARNING:
// I'm setting node type to test case, but $id is the tcversion_id, because
// execution data is related to tcversion NO testcase
//
$cf_map = $this->cfield_mgr->$thisMethod($tproject_id,self::ENABLED,'testcase',
$id,$execution_id,$testplan_id,'id',
$location);
return $cf_map;
}
/*
function: copy_cfields_design_values
Get all cfields linked to any testcase of this testproject
with the values presents for $from_id, testcase we are using as
source for our copy.
args: source: map('id' => testcase id, 'tcversion_id' => testcase id)
destination: map('id' => testcase id, 'tcversion_id' => testcase id)
returns: -
*/
function copy_cfields_design_values($source,$destination) {
// Get all cfields linked to any testcase of this test project
// with the values presents for $from_id, testcase we are using as
// source for our copy
$cfmap_from = $this->get_linked_cfields_at_design($source['id'],$source['tcversion_id']);
$cfield=null;
if( !is_null($cfmap_from) ) {
foreach($cfmap_from as $key => $value) {
$cfield[$key]=array("type_id" => $value['type'], "cf_value" => $value['value']);
}
}
$this->cfield_mgr->design_values_to_db($cfield,$destination['tcversion_id'],null,'tcase_copy_cfields');
}
/*
function: get_linked_cfields_at_testplan_design
args: $id
[$parent_id]
[$filters]:default: null
map with keys:
[show_on_execution]: default: null
1 -> filter on field show_on_execution=1
include ONLY custom fields that can be viewed
while user is execution testcases.
0 or null -> don't filter
[show_on_testplan_design]: default: null
1 -> filter on field show_on_testplan_design=1
include ONLY custom fields that can be viewed
while user is designing test plan.
0 or null -> don't filter
More comments/instructions on cfield_mgr->get_linked_cfields_at_design()
[$link_id]:
[$testplan_id]: null -> get values for any tesplan to with testcase is linked
!is_null -> get values only for this testplan.
returns: hash
key: custom field id
value: map with custom field definition, with keys:
id: custom field id
name
label
type
possible_values
default_value
valid_regexp
length_min
length_max
show_on_design
enable_on_design
show_on_execution
enable_on_execution
display_order
*/
function get_linked_cfields_at_testplan_design($id,$parent_id=null,$filters=null,
$link_id=null,$testplan_id=null,$tproject_id = null)
{
if (!$tproject_id)
{
$tproject_id = $this->getTestProjectFromTestCase($id,$parent_id);
}
// Warning:
// I'm setting node type to test case, but $id is the tcversion_id, because
// link data is related to tcversion NO testcase
//
$cf_map = $this->cfield_mgr->get_linked_cfields_at_testplan_design($tproject_id,self::ENABLED,'testcase',
$id,$link_id,$testplan_id);
return $cf_map;
}
/**
* returns map with key: verbose location (see custom field class $locations
* value: array with fixed key 'location'
* value: location code
*
*/
function buildCFLocationMap()
{
$ret = $this->cfield_mgr->buildLocationMap('testcase');
return $ret;
}
/**
* given a set of test cases, will return a map with
* test suites name that form test case path to root test suite.
*
* example:
*
* communication devices [ID 4]
* |__ Subspace channels [ID 20]
* |
* |__ TestCase100
* |
* |__ short range devices [ID 21]
* |__ TestCase1
* |__ TestCase2
*
* if test case set: TestCase100,TestCase1
*
* 4 Communications
* 20 Communications/Subspace channels
* 21 Communications/Subspace channels/short range devices
*
*
* returns map with key: test suite id
* value: test suite path to root
*
*
*/
function getPathLayered($tcaseSet, $opt=null) {
static $tsuiteMgr;
if( !$tsuiteMgr ) {
$tsuiteMgr = new testsuite($this->db);
}
$xtree=null;
$options = array('getTSuiteKeywords' => false);
$options = array_merge($options, (array)$opt);
$idSet = (array)$tcaseSet;
foreach($idSet as $item) {
$path_info = $this->tree_manager->get_path($item);
$testcase = end($path_info);
// This check is useful when you have several test cases with same parent test suite
if( !isset($xtree[$testcase['parent_id']]['value']) ) {
$level=0;
foreach($path_info as $elem) {
$level++;
$prefix = isset($xtree[$elem['parent_id']]['value']) ? ($xtree[$elem['parent_id']]['value'] . '/') : '';
if( $elem['node_table'] == 'testsuites' ) {
$xtree[$elem['id']]['value'] = $prefix . $elem['name'];
$xtree[$elem['id']]['level']=$level;
$xtree[$elem['id']]['data_management'] = null;
}
}
}
if( null != $xtree && $options['getTSuiteKeywords'] ) {
$tsSet = array_keys($xtree);
$opkw = array('output' => 'kwname');
$fkw = array('keywordsLikeStart' => '@#');
$iset = (array) $tsuiteMgr->getTSuitesFilteredByKWSet($tsSet,$opkw,$fkw);
foreach( $iset as $tsuite_id => $elem ) {
foreach( $elem as $e ) {
if( null != $e ) {
$xtree[$tsuite_id]['data_management'][$e['keyword']] = $e['dyn_string'];
}
}
}
}
}
return $xtree;
} // getPathLayered($tcaseSet)
/**
*
*
*/
function getPathTopSuite($tcaseSet)
{
$xtmas=null;
foreach($tcaseSet as $item)
{
$path_info = $this->tree_manager->get_path($item);
$top = current($path_info);
$xtmas[$item] = array( 'name' => $top['name'], 'id' => $top['id']);
}
return $xtmas;
} // getPathTopSuite($tcaseSet)
/*
function: getByPathName
pathname format
Test Project Name::SuiteName::SuiteName::...::Test case name
args: $pathname
returns: hash
*/
function getByPathName($pathName,$pathSeparator='::')
{
$recordset = null;
$retval=null;
// First get root -> test project name and leaf => test case name
$parts = explode($pathSeparator,$pathName);
$partsQty = count($parts);
$tprojectName = $parts[0];
$tsuiteName = $parts[$partsQty-2];
$tcaseName = end($parts);
// get all testcases on test project with this name and parent test suite
$recordset = $this->get_by_name($tcaseName, $tsuiteName ,$tprojectName);
if( !is_null($recordset) && count($recordset) > 0 )
{
foreach($recordset as $value)
{
$dummy = $this->tree_manager->get_full_path_verbose($value['id']);
$sx = implode($pathSeparator,current($dummy)) . $pathSeparator . $tcaseName;
if( strcmp($pathName,$sx ) == 0 )
{
$retval = $value;
break;
}
}
}
return $retval;
}
/**
*
*
*/
function buildDirectWebLink($base_href,$id,$tproject_id=null)
{
list($external_id,$prefix,$glue,$tc_number) = $this->getExternalID($id,$tproject_id);
$dl = $base_href . 'linkto.php?tprojectPrefix=' . urlencode($prefix) .
'&item=testcase&id=' . urlencode($external_id);
return $dl;
}
/**
*
*
*/
function getExternalID($id,$tproject_id=null,$prefix=null)
{
static $root;
static $tcase_prefix;
if( is_null($prefix) )
{
if( is_null($root) || ($root != $tproject_id) )
{
list($tcase_prefix,$root) = $this->getPrefix($id,$tproject_id);
}
}
else
{
$tcase_prefix = $prefix;
}
$info = $this->get_last_version_info($id, array('output' => 'minimun'));
$external = $info['tc_external_id'];
$identity = $tcase_prefix . $this->cfg->testcase->glue_character . $external;
return array($identity,$tcase_prefix,$this->cfg->testcase->glue_character,$external);
}
/**
* returns just name, tc_external_id, version.
* this info is normally enough for user feednack.
*
* @param int $id test case id
* @param array $accessVersionBy 'number' => contains test case version number
* 'id' => contains test case version ID
*
* @return array with one element with keys: name,version,tc_external_id
*/
function get_basic_info($id,$accessVersionBy)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ " .
" SELECT NH_TCASE.id, NH_TCASE.name, TCV.version, TCV.tc_external_id, " .
" TCV.id AS tcversion_id, TCV.status " .
" FROM {$this->tables['nodes_hierarchy']} NH_TCASE " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCV ON NH_TCV.parent_id = NH_TCASE.id" .
" JOIN {$this->tables['tcversions']} TCV ON TCV.id = NH_TCV.id ";
$accessBy = array('number' => 'version', 'id' => 'id');
$where_clause = '';
foreach( $accessBy as $key => $field)
{
if( isset($accessVersionBy[$key]) )
{
$where_clause = " WHERE TCV.{$field} = " . intval($accessVersionBy[$key]) ;
break;
}
}
$where_clause .= " AND NH_TCASE .id = {$id} ";
$sql .= $where_clause;
$result = $this->db->get_recordset($sql);
return $result;
}
/**
*
*
*/
function create_step($tcversion_id,$step_number,$actions,$expected_results,
$execution_type=TESTCASE_EXECUTION_TYPE_MANUAL)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$ret = array();
// defensive programming
$dummy = $this->db->prepare_int($execution_type);
$dummy = (isset($this->execution_types[$dummy])) ? $dummy : TESTCASE_EXECUTION_TYPE_MANUAL;
$item_id = $this->tree_manager->new_node($tcversion_id,$this->node_types_descr_id['testcase_step']);
$k2e = array('actions','expected_results');
$item = new stdClass();
$item->actions = $actions;
$item->expected_results = $expected_results;
$this->CKEditorCopyAndPasteCleanUp($item,$k2e);
$sql = "/* $debugMsg */ INSERT INTO {$this->tables['tcsteps']} " .
" (id,step_number,actions,expected_results,execution_type) " .
" VALUES({$item_id},{$step_number},'" .
$this->db->prepare_string($item->actions) . "','" .
$this->db->prepare_string($item->expected_results) . "', " .
$this->db->prepare_int($dummy) . ")";
$result = $this->db->exec_query($sql);
$ret = array('msg' => 'ok', 'id' => $item_id, 'status_ok' => 1,
'sql' => $sql);
if (!$result)
{
$ret['msg'] = $this->db->error_msg();
$ret['status_ok']=0;
$ret['id']=-1;
}
return $ret;
}
/**
*
*
*/
function get_steps($tcversion_id,$step_number=0,$options=null) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$my['options'] = array( 'fields2get' => '*', 'accessKey' => null,
'renderGhostSteps' => true, 'renderImageInline' => true);
$my['options'] = array_merge($my['options'], (array)$options);
$step_filter = $step_number > 0 ? " AND step_number = {$step_number} " : "";
$safe_tcversion_id = $this->db->prepare_int($tcversion_id);
// build
$f2g = "TCSTEPS.{$my['options']['fields2get']}";
if($my['options']['fields2get'] != '*') {
$sof = explode(',',$my['options']['fields2get']);
foreach($sof as &$ele) {
$ele = 'TCSTEPS.' . $ele;
}
$f2g = implode(',',$sof);
}
$sql = "/* $debugMsg */ " .
" SELECT {$f2g} " .
" FROM {$this->tables['tcsteps']} TCSTEPS " .
" JOIN {$this->tables['nodes_hierarchy']} NH_STEPS " .
" ON NH_STEPS.id = TCSTEPS.id " .
" WHERE NH_STEPS.parent_id = {$safe_tcversion_id} {$step_filter} ORDER BY step_number";
if( is_null($my['options']['accessKey']) ) {
$result = $this->db->get_recordset($sql);
} else {
$result = $this->db->fetchRowsIntoMap($sql,$my['options']['accessKey']);
}
if(!is_null($result) && $my['options']['renderGhostSteps']) {
$sql = "/* $debugMsg */
SELECT summary,preconditions
FROM {$this->tables['tcversions']} TCV
WHERE TCV.id = $safe_tcversion_id ";
$scan = current($this->db->get_recordset($sql));
$xrayScan = null;
foreach($scan as $fn => $vf) {
if( trim($vf) != '' ) {
if( strpos($vf,self::NAME_PHOPEN) !== FALSE &&
strpos($vf,self::NAME_PHCLOSE) !== FALSE ) {
$xrayScan[$fn] = $vf;
}
}
}
$this->renderGhostSteps($result, $xrayScan);
}
if(!is_null($result) && $my['options']['renderImageInline']) {
// for attachments we need main entity => Test case
$tcvnode = $this->tree_manager->get_node_hierarchy_info($tcversion_id);
$k2l = count($result);
$gaga = array('actions','expected_results');
for($idx=0; $idx < $k2l; $idx++) {
$this->renderImageAttachments($tcvnode['parent_id'],$result[$idx],$gaga);
}
}
return $result;
}
/**
*
*/
function getStepsSimple($tcversion_id,$step_number=0,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$my['options'] = array('fields2get' => 'TCSTEPS.*', 'accessKey' => null,
'renderGhostSteps' => true, 'renderImageInline' => true);
$my['options'] = array_merge($my['options'], (array)$options);
$step_filter = $step_number > 0 ? " AND step_number = {$step_number} " : "";
$safe_tcversion_id = $this->db->prepare_int($tcversion_id);
$sql = "/* $debugMsg */ " .
" SELECT {$my['options']['fields2get']} " .
" FROM {$this->tables['tcsteps']} TCSTEPS " .
" JOIN {$this->tables['nodes_hierarchy']} NH_STEPS " .
" ON NH_STEPS.id = TCSTEPS.id " .
" WHERE NH_STEPS.parent_id = {$safe_tcversion_id} {$step_filter} ORDER BY step_number";
if( is_null($my['options']['accessKey']) )
{
$result = $this->db->get_recordset($sql);
}
else
{
$result = $this->db->fetchRowsIntoMap($sql,$my['options']['accessKey']);
}
return $result;
}
/**
*
*
*/
function get_step_by_id($step_id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ " .
" SELECT TCSTEPS.* FROM {$this->tables['tcsteps']} TCSTEPS " .
" JOIN {$this->tables['nodes_hierarchy']} NH_STEPS " .
" ON NH_STEPS.id = TCSTEPS.id " .
" WHERE TCSTEPS.id = {$step_id} ";
$result = $this->db->get_recordset($sql);
return is_null($result) ? $result : $result[0];
}
function get_step_numbers($tcversion_id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ " .
" SELECT TCSTEPS.id, TCSTEPS.step_number FROM {$this->tables['tcsteps']} TCSTEPS " .
" JOIN {$this->tables['nodes_hierarchy']} NH_STEPS " .
" ON NH_STEPS.id = TCSTEPS.id " .
" WHERE NH_STEPS.parent_id = {$tcversion_id} ORDER BY step_number";
$result = $this->db->fetchRowsIntoMap($sql,'step_number');
return $result;
}
/**
*
*
*/
function get_latest_step_number($tcversion_id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ " .
" SELECT MAX(TCSTEPS.step_number) AS max_step FROM {$this->tables['tcsteps']} TCSTEPS " .
" JOIN {$this->tables['nodes_hierarchy']} NH_STEPS " .
" ON NH_STEPS.id = TCSTEPS.id " .
" WHERE NH_STEPS.parent_id = {$tcversion_id} ";
$result = $this->db->get_recordset($sql);
$max_step = (!is_null($result) && isset($result[0]['max_step']) )? $result[0]['max_step'] : 0;
return $max_step;
}
/**
*
* $step_id can be an array
*/
function delete_step_by_id($step_id) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$idSet = implode(',',(array)$step_id);
// Try to delete any children entity
// Execution Attachment
// Execution result
//
$dummy = " /* $debugMsg */ SELECT id FROM
{$this->tables['attachments']}
WHERE fk_table = 'execution_tcsteps'
AND fk_id IN (
SELECT id FROM {$this->tables['execution_tcsteps']}
WHERE tcstep_id IN ($idSet) )";
$rs = $this->db->fetchRowsIntoMap($dummy,'id');
if(!is_null($rs)) {
foreach($rs as $fik => $v) {
deleteAttachment($this->db,$fik,false);
}
}
// Order is CRITIC due to Foreing Keys
$sqlSet = array();
$sqlSet[] = "/* $debugMsg */
DELETE FROM {$this->tables['execution_tcsteps']}
WHERE tcstep_id IN ($idSet)";
$whereClause = " WHERE id IN ($idSet) ";
$sqlSet[] = "/* $debugMsg */ DELETE FROM {$this->tables['tcsteps']} {$whereClause} ";
$sqlSet[] = "/* $debugMsg */ DELETE FROM {$this->tables['nodes_hierarchy']} " .
" {$whereClause} AND node_type_id = " .
$this->node_types_descr_id['testcase_step'];
foreach($sqlSet as $sql) {
$this->db->exec_query($sql);
}
}
/**
*
*
* @internal revision
* BUGID 4207 - MSSQL
*/
function set_step_number($step_number)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
foreach($step_number as $step_id => $value)
{
$sql = "/* $debugMsg */ UPDATE {$this->tables['tcsteps']} " .
" SET step_number = {$value} WHERE id = {$step_id} ";
$this->db->exec_query($sql);
}
}
/**
*
*
*/
function update_step($step_id,$step_number,$actions,$expected_results,$execution_type)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$ret = array();
$k2e = array('actions','expected_results');
$item = new stdClass();
$item->actions = $actions;
$item->expected_results = $expected_results;
$this->CKEditorCopyAndPasteCleanUp($item,$k2e);
$sql = "/* $debugMsg */ UPDATE {$this->tables['tcsteps']} " .
" SET step_number=" . $this->db->prepare_int($step_number) . "," .
" actions='" . $this->db->prepare_string($item->actions) . "', " .
" expected_results='" .
$this->db->prepare_string($item->expected_results) . "', " .
" execution_type = " . $this->db->prepare_int($execution_type) .
" WHERE id = " . $this->db->prepare_int($step_id);
$result = $this->db->exec_query($sql);
$ret = array('msg' => 'ok', 'status_ok' => 1, 'sql' => $sql);
if (!$result)
{
$ret['msg'] = $this->db->error_msg();
$ret['status_ok']=0;
}
return $ret;
}
/**
* get by external id
*
* @param mixed filters:
*/
function get_by_external($external_id, $parent_id,$filters=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$recordset = null;
$my = array();
$my['filters'] = array('version' => null);
$my['filters'] = array_merge($my['filters'], (array)$filters);
$sql = "/* $debugMsg */ " .
" SELECT DISTINCT NH_TCASE.id,NH_TCASE.name,NH_TCASE_PARENT.id AS parent_id," .
" NH_TCASE_PARENT.name AS tsuite_name, TCV.tc_external_id " .
" FROM {$this->tables['nodes_hierarchy']} NH_TCASE, " .
" {$this->tables['nodes_hierarchy']} NH_TCASE_PARENT, " .
" {$this->tables['nodes_hierarchy']} NH_TCVERSIONS," .
" {$this->tables['tcversions']} TCV " .
" WHERE NH_TCVERSIONS.id=TCV.id " .
" AND NH_TCVERSIONS.parent_id=NH_TCASE.id " .
" AND NH_TCASE_PARENT.id=NH_TCASE.parent_id " .
" AND NH_TCASE.node_type_id = {$this->my_node_type} " .
" AND TCV.tc_external_id=$external_id ";
$add_filters = ' ';
foreach($my['filters'] as $field => $value)
{
switch($my['filters'])
{
case 'version':
if( !is_null($value) )
{
$add_filters .= ' AND TCV.version = intval($value) ';
}
}
}
$sql .= $add_filters;
$sql .= " AND NH_TCASE_PARENT.id = {$parent_id}" ;
$recordset = $this->db->fetchRowsIntoMap($sql,'id');
return $recordset;
}
/**
* for a given set of test cases, search on the ACTIVE version set,
* and returns for each test case,
* a map with: the corresponding MAX(version number), other info
*
* @param mixed $id: test case id can be an array
* @param map $filters OPTIONAL - now only 'cfields' key is supported
* @param map $options OPTIONAL
*
*/
function get_last_active_version($id,$filters=null,$options=null) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$recordset = null;
$itemSet = implode(',',(array)$id);
$my = array();
$my['filters'] = array( 'cfields' => null);
$my['filters'] = array_merge($my['filters'], (array)$filters);
$my['options'] = array( 'max_field' => 'tcversion_id', 'access_key' => 'tcversion_id');
$my['options'] = array_merge($my['options'], (array)$options);
switch($my['options']['max_field']) {
case 'version':
$maxClause = " SELECT MAX(TCV.version) AS version ";
$selectClause = " SELECT TCV.version AS version ";
break;
case 'tcversion_id':
$maxClause = " SELECT MAX(TCV.id) AS tcversion_id ";
$selectClause = " SELECT TCV.id AS tcversion_id ";
break;
}
$sql = "/* $debugMsg */ " .
" {$maxClause}, NH_TCVERSION.parent_id AS testcase_id " .
" FROM {$this->tables['tcversions']} TCV " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCVERSION " .
" ON NH_TCVERSION.id = TCV.id AND TCV.active=1 " .
" AND NH_TCVERSION.parent_id IN ({$itemSet}) " .
" GROUP BY NH_TCVERSION.parent_id " .
" ORDER BY NH_TCVERSION.parent_id ";
$recordset = $this->db->fetchRowsIntoMap($sql,'tcversion_id');
$cfSelect = '';
$cfJoin = '';
$cfQuery = '';
$cfQty = 0;
if( !is_null($recordset) ) {
$or_clause = '';
$cf_query = '';
if( !is_null($my['filters']['cfields']) ) {
$cf_hash = &$my['filters']['cfields'];
$cfQty = count($cf_hash);
$countmain = 1;
// Build custom fields filter
// do not worry!! it seems that filter criteria is OR,
// but really is an AND,
// OR is needed to do a simple query.
// with processing on recordset becomes an AND
foreach ($cf_hash as $cf_id => $cf_value) {
if ( $countmain != 1 ) {
$cfQuery .= " OR ";
}
if (is_array($cf_value)) {
$count = 1;
foreach ($cf_value as $value) {
if ($count > 1) {
$cfQuery .= " AND ";
}
$cfQuery .= " ( CFDV.value LIKE '%{$value}%' AND CFDV.field_id = {$cf_id} )";
$count++;
}
}
else {
$cfQuery .= " ( CFDV.value LIKE '%{$cf_value}%' AND CFDV.field_id = {$cf_id} )";
}
$countmain++;
}
$cfSelect = ", CFDV.field_id, CFDV.value ";
$cfJoin = " JOIN {$this->tables['cfield_design_values']} CFDV ON CFDV.node_id = TCV.id ";
$cfQuery = " AND ({$cfQuery}) ";
}
$keySet = implode(',',array_keys($recordset));
$sql = "/* $debugMsg */ " .
" {$selectClause}, NH_TCVERSION.parent_id AS testcase_id, " .
" TCV.version,TCV.execution_type,TCV.importance,TCV.status {$cfSelect} " .
" FROM {$this->tables['tcversions']} TCV " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCVERSION " .
" ON NH_TCVERSION.id = TCV.id {$cfJoin} " .
" AND NH_TCVERSION.id IN ({$keySet}) {$cfQuery}";
$recordset = $this->db->fetchRowsIntoMap($sql,$my['options']['access_key'],database::CUMULATIVE);
// now loop over result,
// Processing has to be done no matter value of cfQty
// (not doing this has produced in part TICKET 4704,4708)
// entries whose count() < number of custom fields has to be removed
if( !is_null($recordset) ) {
$key2loop = array_keys($recordset);
if($cfQty > 0) {
foreach($key2loop as $key) {
if( count($recordset[$key]) < $cfQty) {
unset($recordset[$key]);
}
else {
$recordset[$key] = $recordset[$key][0];
unset($recordset[$key]['value']);
unset($recordset[$key]['field_id']);
}
}
}
else {
foreach($key2loop as $key) {
$recordset[$key] = $recordset[$key][0];
}
}
if( count($recordset) <= 0 ) {
$recordset = null;
}
}
}
return $recordset;
}
/**
*
*/
function filter_tcversions_by_exec_type($tcversion_id,$exec_type,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$recordset = null;
$itemSet = implode(',',(array)$tcversion_id);
$my['options'] = array( 'access_key' => 'tcversion_id');
$my['options'] = array_merge($my['options'], (array)$options);
$sql = "/* $debugMsg */ " .
" SELECT TCV.id AS tcversion_id, NH_TCVERSION.parent_id AS testcase_id, TCV.version " .
" FROM {$this->tables['tcversions']} TCV " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCVERSION " .
" ON NH_TCVERSION.id = TCV.id AND TCV.execution_type={$exec_type}" .
" AND NH_TCVERSION.id IN ({$itemSet}) ";
$recordset = $this->db->fetchRowsIntoMap($sql,$my['options']['access_key']);
return $recordset;
}
/**
*
*
*/
function filter_tcversions($tcversion_id,$filters,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$recordset = null;
$itemSet = implode(',',(array)$tcversion_id);
$my['options'] = array( 'access_key' => 'tcversion_id');
$my['options'] = array_merge($my['options'], (array)$options);
$sql = "/* $debugMsg */ " .
" SELECT TCV.id AS tcversion_id, NH_TCVERSION.parent_id AS testcase_id, TCV.version " .
" FROM {$this->tables['tcversions']} TCV " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCVERSION " .
" ON NH_TCVERSION.id = TCV.id ";
if ( !is_null($filters) )
{
foreach($filters as $key => $value)
{
if( !is_null($value) )
{
$sql .= " AND TCV.{$key}={$value} "; // Hmmm some problems coming with strings
}
}
}
$sql .= " AND NH_TCVERSION.id IN ({$itemSet}) ";
$recordset = $this->db->fetchRowsIntoMap($sql,$my['options']['access_key']);
return $recordset;
}
/**
* given a test case version id, the provided steps will be analized in order
* to update whole steps/expected results structure for test case version.
* This can result in some step removed, other updated and other new created.
*
*/
function update_tcversion_steps($tcversion_id,$steps)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
// delete all current steps (if any exists)
// Attention:
// After addition of test case steps feature, a test case version
// can be root of a subtree that contains the steps.
// Remember we are using (at least on Postgres FK => we need to delete
// in a precise order.
$stepSet = $this->get_steps($tcversion_id,0,
array('fields2get' => 'id', 'accessKey' => 'id'));
if( count($stepSet) > 0 )
{
$this->delete_step_by_id(array_keys($stepSet));
}
// Now insert steps
$loop2do = count($steps);
for($idx=0; $idx < $loop2do; $idx++)
{
$this->create_step($tcversion_id,$steps[$idx]['step_number'],
$steps[$idx]['actions'],
$steps[$idx]['expected_results'],
$steps[$idx]['execution_type']);
}
}
/**
* update_last_modified
*
* @internal revision
* 20101016 - franciscom - refixing of BUGID 3849
*/
function update_last_modified($tcversion_id,$user_id,$time_stamp=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$changed_ts = !is_null($time_stamp) ? $time_stamp : $this->db->db_now();
$sql = " UPDATE {$this->tables['tcversions']} " .
" SET updater_id=" . $this->db->prepare_int($user_id) . ", " .
" modification_ts = " . $changed_ts .
" WHERE id = " . $this->db->prepare_int($tcversion_id);
$this->db->exec_query($sql);
}
/**
* Given a tcversion set, returns a modified set, where only tcversion id
* that has requested values on Custom fields are returned.
*
* @param mixed tcversion_id: can be a single value or an array
* @param map cf_hash: custom fields id plus values
* @param map options: OPTIONAL
*
* @return map key: tcversion_id ,
* element: array numerical index with as much element as custom fields
*
* @20170325: Ay! this search on EXACT VALUE not LIKE!
* changed!
*/
function filter_tcversions_by_cfields($tcversion_id,$cf_hash,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$recordset = null;
$itemSet = implode(',',(array)$tcversion_id);
$my['options'] = array( 'access_key' => 'tcversion_id');
$my['options'] = array_merge($my['options'], (array)$options);
$or_clause = '';
$cf_query = '';
$cf_qty = count($cf_hash);
// do not worry!! it seems that filter criteria is OR, but really is an AND,
// OR is needed to do a simple query.
// with processing on recordset becomes an AND
foreach ($cf_hash as $cf_id => $cf_value)
{
$cf_query .= $or_clause . " (CFDV.field_id=" . $cf_id .
" AND CFDV.value LIKE '%{$cf_value}%') ";
$or_clause = ' OR ';
}
$sql = "/* $debugMsg */ " .
" SELECT TCV.id AS tcversion_id, " .
" NH_TCVERSION.parent_id AS testcase_id, TCV.version," .
" CFDV.field_id,CFDV.value " .
" FROM {$this->tables['tcversions']} TCV " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCVERSION " .
" ON NH_TCVERSION.id = TCV.id " .
" JOIN {$this->tables['cfield_design_values']} CFDV " .
" ON CFDV.node_id = TCV.id " .
" AND NH_TCVERSION.id IN ({$itemSet}) AND ({$cf_query}) ";
$recordset = $this->db->fetchRowsIntoMap($sql,$my['options']['access_key'],database::CUMULATIVE);
// now loop over result, entries whose count() < number of custom fields has to be removed
if( !is_null($recordset) )
{
$key2loop = array_keys($recordset);
foreach($key2loop as $key)
{
if( count($recordset[$key]) < $cf_qty)
{
unset($recordset[$key]);
}
}
if( count($recordset) <= 0 )
{
$recordset = null;
}
}
return $recordset;
}
/**
*
* @used-by execSetResults.php
*/
function getExecutionSet($id,$version_id=null,$filters=null,$options=null)
{
// need to understand if possibility of choosing order by
// allow us to replace completely code that seems duplicate
// get_executions.
//
// NHA.node_order ASC, NHA.parent_id ASC, execution_id DESC
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
// IMPORTANT NOTICE: keys are field names of executions tables
$my['filters'] = array('tcversion_id' => null,'testplan_id' => null,
'platform_id' => null, 'build_id' => null);
$my['filters'] = array_merge($my['filters'], (array)$filters);
$my['options'] = array('exec_id_order' => 'DESC');
$my['options'] = array_merge($my['options'], (array)$options);
$filterBy = array();
$filterKeys = array('build_id','platform_id','testplan_id','tcversion_id');
foreach($filterKeys as $fieldName)
{
$filterBy[$fieldName] = '';
if( !is_null($my['filters'][$fieldName]) )
{
$itemSet = implode(',', (array)($my['filters'][$fieldName]));
$filterBy[$fieldName] = " AND E.{$fieldName} IN ({$itemSet}) ";
}
}
// --------------------------------------------------------------------
if( is_array($id) )
{
$tcid_list = implode(",",$id);
$where_clause = " WHERE NHTCV.parent_id IN ({$tcid_list}) ";
}
else
{
$where_clause = " WHERE NHTCV.parent_id = {$id} ";
}
if(!is_null($version_id))
{
if( is_array($version_id) )
{
foreach($version_id as &$elem)
{
$elem = intval($elem);
}
$where_clause .= ' AND TCV.id IN (' . implode(",",$version_id) . ') ';
}
else
{
if($version_id != self::ALL_VERSIONS)
{
$where_clause .= ' AND TCV.id = ' .intval($version_id);
}
}
}
$sql = "/* $debugMsg */ SELECT NHTC.name,NHTCV.parent_id AS testcase_id, NHTCV.id AS tcversion_id, " .
" TCV.*, " .
" U.login AS tester_login, U.first AS tester_first_name, U.last AS tester_last_name," .
" E.tester_id AS tester_id,E.id AS execution_id, E.status,E.tcversion_number," .
" E.notes AS execution_notes, E.execution_ts, E.execution_type AS execution_run_type," .
" E.execution_duration," .
" E.build_id AS build_id, B.name AS build_name, B.active AS build_is_active, " .
" B.is_open AS build_is_open,E.platform_id, PLATF.name AS platform_name," .
" E.testplan_id,NHTPLAN.name AS testplan_name,TPTCV.id AS feature_id " .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" JOIN {$this->tables['nodes_hierarchy']} NHTC ON NHTC.id = NHTCV.parent_id " .
" JOIN {$this->tables['tcversions']} TCV ON TCV.id = NHTCV.id " .
" JOIN {$this->tables['executions']} E " .
" ON E.tcversion_id = NHTCV.id " .
$filterBy['testplan_id'] . $filterBy['build_id'] .
$filterBy['platform_id'] . $filterBy['tcversion_id'] .
" /* To get build name */ " .
" JOIN {$this->tables['builds']} B ON B.id=E.build_id " .
" /* To get test plan name */ " .
// " JOIN {$this->tables['testplans']} TPLAN ON TPLAN.id = E.testplan_id " .
" JOIN {$this->tables['nodes_hierarchy']} NHTPLAN ON NHTPLAN.id = E.testplan_id " .
" JOIN {$this->tables['testplan_tcversions']} TPTCV " .
" ON TPTCV.testplan_id = E.testplan_id " .
" AND TPTCV.tcversion_id = E.tcversion_id " .
" AND TPTCV.platform_id = E.platform_id " .
" LEFT OUTER JOIN {$this->tables['users']} U ON U.id = E.tester_id " .
" LEFT OUTER JOIN {$this->tables['platforms']} PLATF ON PLATF.id = E.platform_id " .
$where_clause .
" ORDER BY execution_id {$my['options']['exec_id_order']} ";
$recordset = $this->db->fetchArrayRowsIntoMap($sql,'id');
return($recordset ? $recordset : null);
}
/**
* for test case id and filter criteria return set with platforms
* where test case has a version that has been executed.
*
*/
function getExecutedPlatforms($id,$filters=null,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$my['filters'] = array( 'version_id' => null,'tplan_id' => null,
'platform_id' => null, 'build_id' => null);
$my['filters'] = array_merge($my['filters'], (array)$filters);
$my['options'] = array('exec_id_order' => 'DESC');
$my['options'] = array_merge($my['options'], (array)$options);
$filterKeys = array('build_id','platform_id','tplan_id');
foreach($filterKeys as $key)
{
$filterBy[$key] = '';
if( !is_null($my['filters'][$key]) )
{
$itemSet = implode(',', (array)$$key);
$filterBy[$key] = " AND e.{$key} IN ({$itemSet}) ";
}
}
// --------------------------------------------------------------------
if( is_array($id) )
{
$tcid_list = implode(",",$id);
$where_clause = " WHERE NHTCV.parent_id IN ({$tcid_list}) ";
}
else
{
$where_clause = " WHERE NHTCV.parent_id = {$id} ";
}
// if( is_array($version_id) )
// {
// $versionid_list = implode(",",$version_id);
// $where_clause .= " AND tcversions.id IN ({$versionid_list}) ";
// }
// else
// {
// if($version_id != self::ALL_VERSIONS)
// {
// $where_clause .= " AND tcversions.id = {$version_id} ";
// }
// }
$sql = "/* $debugMsg */ SELECT DISTINCT e.platform_id,p.name " .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" JOIN {$this->tables['tcversions']} tcversions ON NHTCV.id = tcversions.id " .
" JOIN {$this->tables['executions']} e ON NHTCV.id = e.tcversion_id " .
" {$filterBy['tplan_id']} {$filterBy['build_id']} {$filterBy['platform_id']} " .
" JOIN {$this->tables['builds']} b ON e.build_id=b.id " .
" LEFT OUTER JOIN {$this->tables['platforms']} p ON p.id = e.platform_id " .
$where_clause;
$recordset = $this->db->fetchRowsIntoMap($sql,'platform_id');
return($recordset ? $recordset : null);
}
/**
*
* Solve point to my self
*
*
added by web rich editor create some layout issues
*/
function renderGhostSteps(&$steps2render, $scan = null) {
$warningRenderException = lang_get('unable_to_render_ghost');
$loop2do = count($steps2render);
$tlBeginMark = self::GHOSTBEGIN;
$tlEndMark = self::GHOSTEND;
$tlEndMarkLen = strlen($tlEndMark);
$key2check = array('actions','expected_results');
// I've discovered that working with Web Rich Editor generates
// some additional not wanted entities, that disturb a lot
// when trying to use json_decode().
// Hope this set is enough.
$replaceSet = array($tlEndMark, '', '
',' ');
$replaceSetWebRichEditor = array('
', '
',' ');
$rse = &$steps2render;
for($gdx=0; $gdx < $loop2do; $gdx++) {
foreach($key2check as $item_key) {
$deghosted = false;
$start = FALSE;
if(isset($rse[$gdx][$item_key])) {
$start = strpos($rse[$gdx][$item_key],$tlBeginMark);
$ghost = $rse[$gdx][$item_key];
}
if($start !== FALSE) {
$xx = explode($tlBeginMark,$rse[$gdx][$item_key]);
$xx2do = count($xx);
$ghost = '';
$deghosted = false;
for($xdx=0; $xdx < $xx2do; $xdx++) {
try {
if( ($cutting_point = strpos($xx[$xdx],$tlEndMark)) !== FALSE) {
// here I've made a mistake
// Look at this situation:
//
// ** Original String
// [ghost]"Step":1,"TestCase":"BABA-1","Version":1[/ghost] RIGHT
//
// ** $xx[$xdx]
// "Step":1,"TestCase":"BABA-1","Version":1[/ghost] RIGHT
// Then $ydx = trim(str_replace($replaceSet,'',$xx[$xdx]));
//
// WRONG!!! => "Step":1,"TestCase":"BABA-1","Version":1
//
// Need to CUT WHERE I have found $tlEndMark
//
$leftside = trim(substr($xx[$xdx],0,$cutting_point));
$rightside = trim(substr($xx[$xdx],$cutting_point+$tlEndMarkLen));
$dx = '{' . html_entity_decode(trim($leftside,'\n')) . '}';
$dx = json_decode($dx,true);
if(isset($dx['Step'])) {
if( ($xid = $this->getInternalID($dx['TestCase'])) > 0 ) {
// Start looking initially just for ACTIVE Test Case Versions
$vn = isset($dx['Version']) ? intval($dx['Version']) : 0;
if($vn == 0) {
// User wants to follow latest ACTIVE VERSION
$yy = $this->get_last_version_info($xid,array('output' => 'full','active' => 1));
if(is_null($yy)) {
// seems all versions are inactive, in this situation will get latest
$yy = $this->get_last_version_info($xid,array('output' => 'full'));
}
$vn = intval($yy['version']);
}
$fi = $this->get_basic_info($xid,array('number' => $vn));
if(!is_null($fi)) {
if(intval($dx['Step']) > 0) {
$deghosted = true;
$stx = $this->get_steps($fi[0]['tcversion_id'],$dx['Step']);
$ghost .= str_replace($replaceSetWebRichEditor,'',$stx[0][$item_key]) . $rightside;
}
}
}
} else {
// seems we have found a ghost test case INSTEAD OF a GHOST test case STEP
// Then I do a trick creating an artificial 'summary' member
$zorro = array('summary' => $tlBeginMark . $leftside . $tlEndMark);
$this->renderGhost($zorro);
$deghosted = true;
$ghost .= $zorro['summary'] . $rightside;
}
} else {
$ghost = $xx[$xdx]; // 20131022
}
} catch (Exception $e) {
$deghosted = true;
$ghost .= $warningRenderException . $rse[$gdx][$item_key];
}
}
} // $start
if($deghosted) {
$rse[$gdx][$item_key] = $ghost;
}
if(null != $scan) {
$gaga = implode(',',$scan);
$rse[$gdx][$item_key] =
$this->replaceTextBTWTags($rse[$gdx][$item_key],$gaga);
}
}
}
}
/**
* Gets test cases created per user. The test cases are restricted to a
* test plan of a test project. This method performs a query to database
* using the given arguments.
*
* Optional values may be passed in the options array. These optional
* values include tplan_id - Test plan ID.
*
* @param integer $user_id User ID
* @param integer $tproject_id Test Project ID
* @param mixed $options Optional array of options
* @return mixed Array of test cases created per user
*/
function get_created_per_user($user_id, $tproject_id, $options)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$has_options=!is_null($options);
$sql = "/* $debugMsg */ SELECT ".
"TPROJ.id AS testproject_id, TPTCV.testplan_id, TCV.id AS tcversion_id," .
"TCV.version, TCV.tc_external_id, NHTC.id AS testcase_id, NHTC.name, ".
"TCV.creation_ts, TCV.modification_ts, TPROJ.prefix, U.first AS first_name,".
"U.last AS last_name, U.login, (TPTCV.urgency * TCV.importance) AS priority " .
"FROM testprojects TPROJ, users U JOIN tcversions TCV ON U.id = TCV.author_id " .
"JOIN nodes_hierarchy NHTCV ON TCV.id = NHTCV.id " .
"JOIN nodes_hierarchy NHTC ON NHTCV.parent_id = NHTC.id " .
"LEFT OUTER JOIN testplan_tcversions TPTCV ON TCV.id = TPTCV.tcversion_id " .
"LEFT OUTER JOIN testplans TPLAN ON TPTCV.testplan_id = TPLAN.id " .
"LEFT OUTER JOIN testprojects TPROJ_TPLAN ON TPLAN.testproject_id = TPROJ_TPLAN.id " .
"WHERE TPROJ.id = {$tproject_id}";
if($user_id !== 0) {
$sql .= " AND U.id = {$user_id}";
}
if( $has_options && isset($options->tplan_id)) {
$sql .= " AND TPTCV.testplan_id = {$options->tplan_id}";
}
if( $has_options && isset($options->startTime) ) {
$sql .= " AND TCV.creation_ts >= '{$options->startTime}'";
}
if( $has_options && isset($options->endTime) ) {
$sql .= " AND TCV.creation_ts <= '{$options->endTime}'";
}
$access_key=array('testplan_id','testcase_id');
if( $has_options && isset($options->access_keys) )
{
switch($options->access_keys)
{
case 'testplan_testcase':
$access_key=array('testplan_id','testcase_id');
break;
case 'testcase_testplan':
$access_key=array('testcase_id','testplan_id');
break;
default:
$access_key=array('testplan_id','testcase_id');
break;
}
}
$rs=$this->db->fetchMapRowsIntoMap($sql,$access_key[0],$access_key[1],database::CUMULATIVE);
if( $has_options && !is_null($rs)) // TBD: Check if we can remove it
{
if( !isset($options->access_keys) ||
(is_null($options->access_keys) || $options->access_keys='testplan_testcase') )
{
$tcaseSet=null;
$main_keys = array_keys($rs);
foreach($main_keys as $maccess_key)
{
$sec_keys = array_keys($rs[$maccess_key]);
foreach($sec_keys as $saccess_key)
{
// is enough I process first element
$item = $rs[$maccess_key][$saccess_key][0];
if(!isset($tcaseSet[$item['testcase_id']]))
{
$tcaseSet[$item['testcase_id']]=$item['testcase_id'];
}
}
}
$path_info = $this->tree_manager->get_full_path_verbose($tcaseSet);
// Remove test project piece and convert to string
$flat_path=null;
foreach($path_info as $tcase_id => $pieces)
{
unset($pieces[0]);
$flat_path[$tcase_id]=implode('/',$pieces);
}
$main_keys = array_keys($rs);
foreach($main_keys as $idx)
{
$sec_keys = array_keys($rs[$idx]);
foreach($sec_keys as $jdx)
{
$third_keys = array_keys($rs[$idx][$jdx]);
foreach($third_keys as $tdx)
{
$fdx = $rs[$idx][$jdx][$tdx]['testcase_id'];
$rs[$idx][$jdx][$tdx]['tcase_full_path']=$flat_path[$fdx];
}
}
break;
}
}
}
return $rs;
}
/**
*
*
*/
function setExecutionType($tcversionID,$value,$opt=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$my['opt'] = array('updSteps' => false);
$my['opt'] = array_merge($my['opt'],(array)$opt);
$execType = $this->db->prepare_int(intval($value));
$safeTCVID = $this->db->prepare_int($tcversionID);
$sql = "/* $debugMsg */ " .
" UPDATE {$this->tables['tcversions']} " .
" SET execution_type={$execType} WHERE id = {$safeTCVID} ";
$this->db->exec_query($sql);
if( $my['opt']['updSteps'] )
{
$opx = array('fields2get' => 'id');
$stepIDSet = $this->get_steps($safeTCVID,null,$opx);
if( !is_null($stepIDSet) )
{
$target = array();
foreach($stepIDSet as $elem )
{
$target[] = $elem['id'];
}
$inClause = implode(',',$target);
$sqlX = " UPDATE {$this->tables['tcsteps']} " .
" SET execution_type={$execType} WHERE id IN (" . $inClause . ")";
$this->db->exec_query($sqlX);
}
}
return array($value,$execType,$sql);
}
/**
*
*
*/
function setEstimatedExecDuration($tcversionID,$value)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$safe = trim($value);
$safe = is_numeric($safe) ? $safe : null;
$sql = "/* $debugMsg */ " .
" UPDATE {$this->tables['tcversions']} " .
" SET estimated_exec_duration=" . ((is_null($safe) || $safe == '') ? 'NULL' : $safe) .
" WHERE id = " . $this->db->prepare_int($tcversionID);
$this->db->exec_query($sql);
return array($value,$safe,$sql);
}
/**
* @param map $identity: id, version_id
* @param map $execContext: tplan_id, platform_id,build_id
* @internal revisions
*
* @since 1.9.4
**/
function getLatestExecSingleContext($identity,$execContext,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$cfg = config_get('results');
$status_not_run = $cfg['status_code']['not_run'];
$my = array('opt' => array('output' => 'full'));
$my['opt'] = array_merge($my['opt'],(array)$options);
$safeContext = $execContext;
$safeIdentity = $identity;
foreach($safeContext as &$ele)
{
$ele = intval($ele);
}
foreach($safeIdentity as &$ele)
{
$ele = intval($ele);
}
// dammed names!!!
$safeContext['tplan_id'] = isset($safeContext['tplan_id']) ? $safeContext['tplan_id'] : $safeContext['testplan_id'];
// we have to manage following situations
// 1. we do not know test case version id.
if($safeIdentity['version_id'] > 0)
{
$addJoinLEX = '';
$addWhereLEX = " AND EE.tcversion_id = " . $safeIdentity['version_id'];
$addWhere = " AND TPTCV.tcversion_id = " . $safeIdentity['version_id'];
}
else
{
$addJoinLEX = " JOIN {$this->tables['nodes_hierarchy']} H2O " .
" ON H2O.id = EE.tcversion_id ";
$addWhereLEX = " AND H2O.parent_id = " . $safeIdentity['id'];
$addWhere = " AND NHTC.id = " . $safeIdentity['id'];
}
$sqlLEX = ' SELECT EE.tcversion_id,EE.testplan_id,EE.platform_id,EE.build_id,' .
' MAX(EE.id) AS id ' .
" FROM {$this->tables['executions']} EE " .
$addJoinLEX .
' WHERE EE.testplan_id = ' . $safeContext['tplan_id'] .
' AND EE.platform_id = ' . $safeContext['platform_id'] .
' AND EE.build_id = ' . $safeContext['build_id'] .
$addWhereLEX .
' GROUP BY EE.tcversion_id,EE.testplan_id,EE.platform_id ,EE.build_id ';
$out = null;
switch($my['opt']['output'])
{
case 'exec_id':
$dummy = $this->db->get_recordset($sqlLEX);
$out = (!is_null($dummy) ? $dummy[0]['id'] : null);
break;
case 'timestamp':
$sql= "/* $debugMsg */ SELECT E.id AS execution_id, " .
" COALESCE(E.status,'{$status_not_run}') AS status," .
" NHTC.id AS testcase_id, TCV.id AS tcversion_id, E.execution_ts" .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" JOIN {$this->tables['testplan_tcversions']} TPTCV ON TPTCV.tcversion_id = NHTCV.id" .
" JOIN {$this->tables['nodes_hierarchy']} NHTC ON NHTC.id = NHTCV.parent_id " .
" JOIN {$this->tables['tcversions']} TCV ON TCV.id = NHTCV.id " .
" LEFT OUTER JOIN ({$sqlLEX}) AS LEX " .
" ON LEX.testplan_id = TPTCV.testplan_id " .
" AND LEX.platform_id = TPTCV.platform_id " .
" AND LEX.tcversion_id = TPTCV.tcversion_id " .
" AND LEX.build_id = {$safeContext['build_id']} " .
" LEFT OUTER JOIN {$this->tables['executions']} E " .
" ON E.id = LEX.id " .
" WHERE TPTCV.testplan_id = {$safeContext['tplan_id']} " .
" AND TPTCV.platform_id = {$safeContext['platform_id']} " .
$addWhere .
" AND (E.build_id = {$safeContext['build_id']} OR E.build_id IS NULL)";
// using database::CUMULATIVE is just a trick to return data structure
// that will be liked on execSetResults.php
$out = $this->db->fetchRowsIntoMap($sql,'testcase_id',database::CUMULATIVE);
break;
case 'full':
default:
$sql= "/* $debugMsg */ SELECT E.id AS execution_id, " .
" COALESCE(E.status,'{$status_not_run}') AS status, E.execution_type AS execution_run_type," .
" NHTC.name, NHTC.id AS testcase_id, NHTC.parent_id AS tsuite_id," .
" TCV.id AS tcversion_id,TCV.tc_external_id,TCV.version,TCV.summary," .
" TCV.preconditions,TCV.importance,TCV.author_id," .
" TCV.creation_ts,TCV.updater_id,TCV.modification_ts,TCV.active," .
" TCV.is_open,TCV.execution_type," .
" U.login AS tester_login,U.first AS tester_first_name," .
" U.last AS tester_last_name, E.tester_id AS tester_id," .
" E.notes AS execution_notes, E.execution_ts, E.build_id,E.tcversion_number," .
" B.name AS build_name, B.active AS build_is_active, B.is_open AS build_is_open," .
" COALESCE(PLATF.id,0) AS platform_id,PLATF.name AS platform_name, TPTCV.id AS feature_id " .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" JOIN {$this->tables['testplan_tcversions']} TPTCV ON TPTCV.tcversion_id = NHTCV.id" .
" JOIN {$this->tables['nodes_hierarchy']} NHTC ON NHTC.id = NHTCV.parent_id " .
" JOIN {$this->tables['tcversions']} TCV ON TCV.id = NHTCV.id " .
" LEFT OUTER JOIN ({$sqlLEX}) AS LEX " .
" ON LEX.testplan_id = TPTCV.testplan_id " .
" AND LEX.platform_id = TPTCV.platform_id " .
" AND LEX.tcversion_id = TPTCV.tcversion_id " .
" AND LEX.build_id = {$safeContext['build_id']} " .
" LEFT OUTER JOIN {$this->tables['executions']} E " .
" ON E.id = LEX.id " .
" JOIN {$this->tables['builds']} B ON B.id = {$safeContext['build_id']} " .
" LEFT OUTER JOIN {$this->tables['users']} U ON U.id = E.tester_id " .
" LEFT OUTER JOIN {$this->tables['platforms']} PLATF ON PLATF.id = {$safeContext['platform_id']} " .
" WHERE TPTCV.testplan_id = {$safeContext['tplan_id']} " .
" AND TPTCV.platform_id = {$safeContext['platform_id']} " .
$addWhere .
" AND (E.build_id = {$safeContext['build_id']} OR E.build_id IS NULL)";
// using database::CUMULATIVE is just a trick to return data structure
// that will be liked on execSetResults.php
$out = $this->db->fetchRowsIntoMap($sql,'testcase_id',database::CUMULATIVE);
break;
}
return $out;
}
/**
*
* DBExec means we do not considered NOT RUN, because are not written to DB.
* @param map $identity: id, version_id
* @param map $execContext: tplan_id, platform_id
* @internal revisions
*
* @since 1.9.4
**/
function getLatestDBExecPlatformContext($identity,$execContext,$options=null)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$cfg = config_get('results');
$status_not_run = $cfg['status_code']['not_run'];
$my = array('opt' => array('output' => 'full'));
$my['opt'] = array_merge($my['opt'],(array)$options);
$safeContext = $execContext;
$safeIdentity = $identity;
foreach($safeContext as &$ele)
{
$ele = intval($ele);
}
foreach($safeIdentity as &$ele)
{
$ele = intval($ele);
}
// we have to manage following situations
// 1. we do not know test case version id.
if($safeIdentity['version_id'] > 0)
{
$addJoinLEX = '';
$addWhereLEX = " AND EE.tcversion_id = " . $safeIdentity['version_id'];
$addWhere = " AND TPTCV.tcversion_id = " . $safeIdentity['version_id'];
}
else
{
$addJoinLEX = " JOIN {$this->tables['nodes_hierarchy']} H2O " .
" ON H2O.id = EE.tcversion_id ";
$addWhereLEX = " AND H2O.parent_id = " . $safeIdentity['id'];
$addWhere = " AND NHTC.id = " . $safeIdentity['id'];
}
$sqlLEX = ' SELECT EE.tcversion_id,EE.testplan_id,EE.platform_id,' .
' MAX(EE.id) AS id ' .
" FROM {$this->tables['executions']} EE " .
$addJoinLEX .
' WHERE EE.testplan_id = ' . $safeContext['tplan_id'] .
' AND EE.platform_id = ' . $safeContext['platform_id'] .
$addWhereLEX .
' GROUP BY EE.tcversion_id,EE.testplan_id,EE.platform_id';
$out = null;
switch($my['opt']['output'])
{
case 'exec_id':
$dummy = $this->db->get_recordset($sqlLEX);
$out = (!is_null($dummy) ? $dummy[0]['id'] : null);
break;
case 'full':
default:
$sql= "/* $debugMsg */ SELECT E.id AS execution_id, " .
" COALESCE(E.status,'{$status_not_run}') AS status, E.execution_type AS execution_run_type," .
" NHTC.name, NHTC.id AS testcase_id, NHTC.parent_id AS tsuite_id," .
" TCV.id AS tcversion_id,TCV.tc_external_id,TCV.version,TCV.summary," .
" TCV.preconditions,TCV.importance,TCV.author_id," .
" TCV.creation_ts,TCV.updater_id,TCV.modification_ts,TCV.active," .
" TCV.is_open,TCV.execution_type," .
" U.login AS tester_login,U.first AS tester_first_name," .
" U.last AS tester_last_name, E.tester_id AS tester_id," .
" E.notes AS execution_notes, E.execution_ts, E.build_id,E.tcversion_number," .
" B.name AS build_name, B.active AS build_is_active, B.is_open AS build_is_open," .
" COALESCE(PLATF.id,0) AS platform_id,PLATF.name AS platform_name, TPTCV.id AS feature_id " .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" JOIN {$this->tables['testplan_tcversions']} TPTCV ON TPTCV.tcversion_id = NHTCV.id" .
" JOIN {$this->tables['nodes_hierarchy']} NHTC ON NHTC.id = NHTCV.parent_id " .
" JOIN {$this->tables['tcversions']} TCV ON TCV.id = NHTCV.id " .
" JOIN ({$sqlLEX}) AS LEX " .
" ON LEX.testplan_id = TPTCV.testplan_id " .
" AND LEX.platform_id = TPTCV.platform_id " .
" AND LEX.tcversion_id = TPTCV.tcversion_id " .
" JOIN {$this->tables['executions']} E " .
" ON E.id = LEX.id " .
" JOIN {$this->tables['builds']} B ON B.id = E.build_id " .
" JOIN {$this->tables['users']} U ON U.id = E.tester_id " .
" /* Left outer on Platforms because Test plan can have NO PLATFORMS */ " .
" LEFT OUTER JOIN {$this->tables['platforms']} PLATF " .
" ON PLATF.id = {$safeContext['platform_id']} " .
" WHERE TPTCV.testplan_id = {$safeContext['tplan_id']} " .
" AND TPTCV.platform_id = {$safeContext['platform_id']} " .
$addWhere;
// using database::CUMULATIVE is just a trick to return data structure
// that will be liked on execSetResults.php
$out = $this->db->fetchRowsIntoMap($sql,'testcase_id',database::CUMULATIVE);
break;
}
return $out;
}
/**
*
*/
function getExecution($execID,$tcversionID) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ SELECT NHTC.name,NHTCV.parent_id AS testcase_id, NHTCV.id AS tcversion_id, " .
" TCV.*, " .
" U.login AS tester_login, U.first AS tester_first_name, U.last AS tester_last_name," .
" E.tester_id AS tester_id,E.id AS execution_id, E.status,E.tcversion_number," .
" E.notes AS execution_notes, E.execution_ts, E.execution_type AS execution_run_type," .
" E.build_id AS build_id, B.name AS build_name, B.active AS build_is_active, " .
" B.is_open AS build_is_open,E.platform_id, PLATF.name AS platform_name," .
" E.testplan_id,NHTPLAN.name AS testplan_name,TPTCV.id AS feature_id " .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" JOIN {$this->tables['nodes_hierarchy']} NHTC ON NHTC.id = NHTCV.parent_id " .
" JOIN {$this->tables['tcversions']} TCV ON TCV.id = NHTCV.id " .
" JOIN {$this->tables['executions']} E " .
" ON E.tcversion_id = NHTCV.id " .
" /* To get build name */ " .
" JOIN {$this->tables['builds']} B ON B.id=E.build_id " .
" /* To get test plan name */ " .
" JOIN {$this->tables['nodes_hierarchy']} NHTPLAN ON NHTPLAN.id = E.testplan_id " .
" JOIN {$this->tables['testplan_tcversions']} TPTCV " .
" ON TPTCV.testplan_id = E.testplan_id " .
" AND TPTCV.tcversion_id = E.tcversion_id " .
" AND TPTCV.platform_id = E.platform_id " .
" LEFT OUTER JOIN {$this->tables['users']} U ON U.id = E.tester_id " .
" LEFT OUTER JOIN {$this->tables['platforms']} PLATF ON PLATF.id = E.platform_id " .
" WHERE E.id = " . intval($execID) . " AND E.tcversion_id = " . intval($tcversionID);
$rs = $this->db->get_recordset($sql);
return ($rs ? $rs : null);
}
/**
*
*/
public function getAuditSignature($context,$options = null) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$key2check = array('tcversion_id','id');
$safeID = array();
foreach($key2check as $idx => $key ) {
if( property_exists($context, $key) ) {
$safeID[$key] = intval($context->$key);
}
else {
$safeID[$key] = -1;
}
}
if( $safeID['id'] <= 0 && $safeID['tcversion_id'] > 0 ) {
$node = $this->tree_manager->get_node_hierarchy_info($safeID['tcversion_id']);
$safeID['id'] = $node['parent_id'];
}
// we need:
// Test Case External ID
// Test Case Name
// Test Case Path
// What about test case version ID ? => only if argument provided
//
$pathInfo = $this->tree_manager->get_full_path_verbose($safeID['id'],array('output_format' => 'id_name'));
$pathInfo = current($pathInfo);
$path = '/' . implode('/',$pathInfo['name']) . '/';
$tcase_prefix = $this->getPrefix($safeID['id'], $pathInfo['node_id'][0]);
$info = $this->get_last_version_info($safeID['id'], array('output' => 'medium'));
$signature = $path . $tcase_prefix[0] . $this->cfg->testcase->glue_character .
$info['tc_external_id'] . ':' . $info['name'];
return $signature;
}
/**
*
*/
public function getTestSuite($id)
{
$dummy = $this->tree_manager->get_node_hierarchy_info($id);
return $dummy['parent_id'];
}
function getIdCardByStepID($step_id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ " .
" SELECT NH_TCV.parent_id AS tcase_id, NH_STEPS.parent_id AS tcversion_id" .
" FROM {$this->tables['nodes_hierarchy']} NH_STEPS " .
" JOIN {$this->tables['nodes_hierarchy']} NH_TCV ON NH_TCV.id = NH_STEPS.parent_id " .
" WHERE NH_STEPS.id = " . intval($step_id);
$rs = $this->db->get_recordset($sql);
return is_null($rs) ? $rs : $rs[0];
}
/**
*
*/
private function initShowGui($guiObj,$grantsObj,$idCard) {
$id = $idCard->tcase_id;
$goo = is_null($guiObj) ? new stdClass() : $guiObj;
$goo->execution_types = $this->execution_types;
$goo->tcase_cfg = $this->cfg->testcase;
$goo->import_limit = TL_REPOSITORY_MAXFILESIZE;
$goo->msg = '';
$goo->fileUploadMsg = '';
$goo->requirement_mgmt = property_exists($grantsObj, 'mgt_modify_req' ) ? $grantsObj->mgt_modify_req : null;
if( is_null($goo->requirement_mgmt)) {
$goo->requirement_mgmt = property_exists($grantsObj, 'requirement_mgmt' ) ? $grantsObj->requirement_mgmt : 0;
}
// some config options have been migrated to rights
// In order to refactor less code, we will remap to OLD config options present on config file.
$goo->tcase_cfg->can_edit_executed = $grantsObj->testproject_edit_executed_testcases == 'yes' ? 1 : 0;
$goo->tcase_cfg->can_delete_executed = $grantsObj->testproject_delete_executed_testcases == 'yes' ? 1 : 0;
$goo->view_req_rights = property_exists($grantsObj, 'mgt_view_req') ? $grantsObj->mgt_view_req : 0;
$goo->assign_keywords = property_exists($grantsObj, 'keyword_assignment') ? $grantsObj->keyword_assignment : 0;
$goo->req_tcase_link_management = property_exists($grantsObj, 'req_tcase_link_management') ? $grantsObj->req_tcase_link_management : 0;
$goo->parentTestSuiteName = '';
$goo->tprojectName = '';
$goo->submitCode = "";
$goo->dialogName = '';
$goo->bodyOnLoad = "";
$goo->bodyOnUnload = "storeWindowSize('TCEditPopup')";
$goo->tableColspan = $this->layout->tableToDisplayTestCaseSteps->colspan;
$goo->tc_current_version = array();
$goo->status_quo = array();
$goo->keywords_map = array();
$goo->arrReqs = array();
$goo->cf_current_version = null;
$goo->cf_other_versions = null;
$goo->linked_versions=null;
$goo->platforms = null;
// add_relation_feedback_msg @used-by testcaseCommands.class.php:doAddRelation()
$viewer_defaults = array('title' => lang_get('title_test_case'),'show_title' => 'no',
'action' => '', 'msg_result' => '','user_feedback' => '',
'refreshTree' => 1, 'disable_edit' => 0,
'display_testproject' => 0,'display_parent_testsuite' => 0,
'hilite_testcase_name' => 0,'show_match_count' => 0,
'add_relation_feedback_msg' => '');
$viewer_defaults = array_merge($viewer_defaults, (array)$guiObj->viewerArgs);
$goo->display_testproject = $viewer_defaults['display_testproject'];
$goo->display_parent_testsuite = $viewer_defaults['display_parent_testsuite'];
$goo->show_title = $viewer_defaults['show_title'];
$goo->hilite_testcase_name = $viewer_defaults['hilite_testcase_name'];
$goo->action = $viewer_defaults['action'];
$goo->user_feedback = $viewer_defaults['user_feedback'];
$goo->add_relation_feedback_msg = $viewer_defaults['add_relation_feedback_msg'];
$goo->pageTitle = $viewer_defaults['title'];
$goo->display_testcase_path = !is_null($goo->path_info);
$goo->show_match_count = $viewer_defaults['show_match_count'];
if($goo->show_match_count && $goo->display_testcase_path ) {
$goo->pageTitle .= '-' . lang_get('match_count') . ':' . ($goo->match_count = count($goo->path_info));
}
$goo->refreshTree = isset($goo->refreshTree) ? $goo->refreshTree : $viewer_defaults['refreshTree'];
$goo->sqlResult = $viewer_defaults['msg_result'];
// fine grain control of operations
if( $viewer_defaults['disable_edit'] == 1 || ($grantsObj->mgt_modify_tc == false) )
{
$goo->show_mode = 'editDisabled';
}
else if( !is_null($goo->show_mode) && $goo->show_mode == 'editOnExec' )
{
// refers to two javascript functions present in testlink_library.js
// and logic used to refresh both frames when user call this
// method to edit a test case while executing it.
$goo->dialogName='tcview_dialog';
$goo->bodyOnLoad="dialog_onLoad($guiObj->dialogName)";
$goo->bodyOnUnload="dialog_onUnload($guiObj->dialogName)";
$goo->submitCode="return dialog_onSubmit($guiObj->dialogName)";
}
$dummy = getConfigAndLabels('testCaseStatus','code');
$goo->domainTCStatus = $dummy['lbl'];
// editOnExec is part of show_mode Domain
$goo->can_do = $this->getShowViewerActions($goo->show_mode);
$key = 'testcase_freeze';
if(property_exists($grantsObj, $key)) {
$goo->can_do->freeze = $grantsObj->$key;
}
$path2root = $this->tree_manager->get_path($id);
$goo->tproject_id = $path2root[0]['parent_id'];
$info = $this->tproject_mgr->get_by_id($goo->tproject_id);
$goo->requirementsEnabled = $info['opt']->requirementsEnabled;
if( $goo->display_testproject ) {
$goo->tprojectName = $info['name'];
}
if( $goo->display_parent_testsuite ) {
$parent = count($path2root)-2;
$goo->parentTestSuiteName = $path2root[$parent]['name'];
}
$testplans = $this->tproject_mgr->get_all_testplans($goo->tproject_id,array('plan_status' =>1) );
$goo->has_testplans = !is_null($testplans) && count($testplans) > 0 ? 1 : 0;
$platformMgr = new tlPlatform($this->db,$goo->tproject_id);
$goo->platforms = $platformMgr->getAllAsMap();
$goo->tcasePrefix = $this->tproject_mgr->getTestCasePrefix($goo->tproject_id) . $this->cfg->testcase->glue_character;
$goo->scripts = null;
$goo->tcase_id = $idCard->tcase_id;
$goo->tcversion_id = $idCard->tcversion_id;
$goo->allowStepAttachments = false;
$designEditorCfg = getWebEditorCfg('design');
$goo->designEditorType = $designEditorCfg['type'];
$stepDesignEditorCfg = getWebEditorCfg('steps_design');
$goo->stepDesignEditorType = $stepDesignEditorCfg['type'];
// Add To Testplan button will be disabled if
// the testcase doesn't belong to the current selected testproject
if($idCard->tproject_id == $goo->tproject_id) {
$goo->can_do->add2tplan = ($goo->can_do->add2tplan == 'yes') ? $grantsObj->testplan_planning : 'no';
} else {
$goo->can_do->add2tplan = 'no';
}
return $goo;
}
/**
*
*/
private function initShowGuiActions(&$gui)
{
$gui->deleteStepAction = "lib/testcases/tcEdit.php?tproject_id=$gui->tproject_id&show_mode=$gui->show_mode" .
"&doAction=doDeleteStep&step_id=";
$gui->tcExportAction = "lib/testcases/tcExport.php?tproject_id=$gui->tproject_id&show_mode=$gui->show_mode";
$gui->tcViewAction = "lib/testcases/archiveData.php?tproject_id={$gui->tproject_id}" .
"&show_mode=$gui->show_mode&tcase_id=";
$gui->printTestCaseAction = "lib/testcases/tcPrint.php?tproject_id=$gui->tproject_id&show_mode=$gui->show_mode";
$gui->keywordsViewHREF = "lib/keywords/keywordsView.php?tproject_id={$gui->tproject_id} " .
' target="mainframe" class="bold" title="' . lang_get('menu_manage_keywords') . '"';
$gui->reqSpecMgmtHREF = "lib/general/frmWorkArea.php?tproject_id={$gui->tproject_id}&feature=reqSpecMgmt";
$gui->reqMgmtHREF = "lib/requirements/reqView.php?tproject_id={$gui->tproject_id}" .
"&showReqSpecTitle=1&requirement_id=";
$gui->addTc2TplanHREF = "lib/testcases/tcAssign2Tplan.php?tproject_id={$gui->tproject_id}";
}
/**
* render Ghost Test Case
*/
function renderGhost(&$item2render) {
$versionTag = '[version:%s]';
$hint = "(link%s";
// $href = '%s:%s' . " $versionTag (link)";
// second \'%s\' needed if I want to use Latest as indication, need to understand
// Javascript instead of javascript, because CKeditor sometimes complains
$href = '%s:%s' . " $versionTag $hint";
$tlBeginMark = '[ghost]';
$tlEndMark = '[/ghost]';
$tlEndMarkLen = strlen($tlEndMark);
$key2check = array('summary','preconditions');
// I've discovered that working with Web Rich Editor generates
// some additional not wanted entities, that disturb a lot
// when trying to use json_decode().
// Hope this set is enough.
// 20130605 - after algorithm change, this seems useless
//$replaceSet = array($tlEndMark, '
', '
',' ');
// $replaceSetWebRichEditor = array('
', '
',' ');
$rse = &$item2render;
foreach($key2check as $item_key)
{
$start = strpos($rse[$item_key],$tlBeginMark);
$ghost = $rse[$item_key];
// There is at least one request to replace ?
if($start !== FALSE)
{
$xx = explode($tlBeginMark,$rse[$item_key]);
// How many requests to replace ?
$xx2do = count($xx);
$ghost = '';
for($xdx=0; $xdx < $xx2do; $xdx++)
{
$isTestCaseGhost = true;
// Hope was not a false request.
// if( strpos($xx[$xdx],$tlEndMark) !== FALSE)
if( ($cutting_point = strpos($xx[$xdx],$tlEndMark)) !== FALSE)
{
// Separate command string from other text
// Theorically can be just ONE, but it depends
// is user had not messed things.
$yy = explode($tlEndMark,$xx[$xdx]);
if( ($elc = count($yy)) > 0)
{
$dx = $yy[0];
// trick to convert to array
$dx = '{' . html_entity_decode(trim($dx,'\n')) . '}';
$dx = json_decode($dx,true);
try
{
$xid = $this->getInternalID($dx['TestCase']);
if( $xid > 0 )
{
$linkFeedback=")";
$addInfo="";
$vn = isset($dx['Version']) ? intval($dx['Version']) : 0;
if($vn == 0)
{
// User wants to follow latest ACTIVE VERSION
$zorro = $this->get_last_version_info($xid,array('output' => 'full','active' => 1));
$linkFeedback=" to Latest ACTIVE Version)";
if(is_null($zorro))
{
// seems all versions are inactive, in this situation will get latest
$zorro = $this->get_last_version_info($xid,array('output' => 'full'));
$addInfo = " - All versions are inactive!!";
$linkFeedback=" to Latest Version{$addInfo})";
}
$vn = intval($zorro['version']);
}
$fi = $this->get_basic_info($xid,array('number' => $vn));
if(!is_null($fi))
{
if( isset($dx['Step']) )
{
$isTestCaseGhost = false;
// ghost for rendering Test Case Step (string display)
// [ghost]"Step":1,"TestCase":"MOK-2","Version":1[/ghost]
//
// ATTENTION REMEMBER THAT ALSO CAN BE:
// [ghost]"Step":1,"TestCase":"MOK-2","Version":""[/ghost]
// [ghost]"Step":1,"TestCase":"MOK-2"[/ghost]
//
if(intval($dx['Step']) > 0)
{
$deghosted = true;
$rightside = trim(substr($xx[$xdx],$cutting_point+$tlEndMarkLen));
$stx = $this->get_steps($fi[0]['tcversion_id'],$dx['Step']);
$ghost .= $stx[0]['actions'] . $rightside;
}
}
else
{
// ghost for rendering Test Case (create link)
$ghost .= sprintf($href,$dx['TestCase'],$vn,$dx['TestCase'],$fi[0]['name'],$vn,$linkFeedback);
}
}
}
if($isTestCaseGhost)
{
$lim = $elc-1;
for($cpx=1; $cpx <= $lim; $cpx++)
{
$ghost .= $yy[$cpx];
}
}
}
catch (Exception $e)
{
$ghost .= $rse[$item_key];
}
}
}
else
{
$ghost .= $xx[$xdx];
}
}
}
if($ghost != '')
{
$rse[$item_key] = $ghost;
}
}
}
/**
*
*
*
*/
function setImportance($tcversionID,$value)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = " UPDATE {$this->tables['tcversions']} " .
" SET importance=" . $this->db->prepare_int($value) .
" WHERE id = " . $this->db->prepare_int($tcversionID);
$this->db->exec_query($sql);
}
/**
*
*
*
*/
function setStatus($tcversionID,$value)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = " UPDATE {$this->tables['tcversions']} " .
" SET status=" . $this->db->prepare_int($value) .
" WHERE id = " . $this->db->prepare_int($tcversionID);
$this->db->exec_query($sql);
}
/**
* updateSimpleFields
* used to update fields of type int, string on test case version
*
* @param int $tcversionID item ID to update
* @param hash $fieldsValues key DB field to update
* supported fields:
* summary,preconditions,execution_type,importance,status,
* updater_id,estimated_exec_duration
*
* @internal revisions
*
*/
function updateSimpleFields($tcversionID,$fieldsValues)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$fieldsConvertions = array('summary' => 'prepare_string','preconditions' => 'prepare_string',
'execution_type' => 'prepare_int', 'importance' => 'prepare_int',
'status' => 'prepare_int', 'estimated_exec_duration' => null,
'updater_id' => null);
$dummy = null;
$sql = null;
$ddx = 0;
foreach($fieldsConvertions as $fkey => $fmethod)
{
if( isset($fieldsValues[$fkey]) )
{
$dummy[$ddx] = $fkey . " = ";
if( !is_null($fmethod) )
{
$sep = ($fmethod == 'prepare_string') ? "'" : "";
$dummy[$ddx] .= $sep . $this->db->$fmethod($fieldsValues[$fkey]) . $sep;
}
else
{
$dummy[$ddx] .= $fieldsValues[$fkey];
}
$ddx++;
}
}
if( !is_null($dummy) )
{
$sqlSET = implode(",",$dummy);
$sql = "/* {$debugMsg} */ UPDATE {$this->tables['tcversions']} " .
"SET {$sqlSET} WHERE id={$tcversionID}";
$this->db->exec_query($sql);
}
return $sql;
}
/**
* updateName
* check for duplicate name under same parent
*
* @param int $id test case id
* @param string $name
*
* @internal revisions
*
*/
function updateName($id,$name)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$ret['status_ok'] = true;
$ret['msg'] = 'ok';
$ret['debug'] = '';
$ret['API_error_code'] = 0;
$field_size = config_get('field_size');
$new_name = trim($name);
if( ($nl = strlen($new_name)) <= 0 )
{
$ret['status_ok'] = false;
$ret['API_error_code'] = 'TESTCASE_EMPTY_NAME';
$ret['msg'] = lang_get('API_' . $ret['API_error_code']);
}
if( $ret['status_ok'] && $nl > $field_size->testcase_name)
{
$ret['status_ok'] = false;
$ret['API_error_code'] = 'TESTCASE_NAME_LEN_EXCEEDED';
$ret['msg'] = sprintf(lang_get('API_' . $ret['API_error_code']),$nl,$field_size->testcase_name);
}
if( $ret['status_ok'] )
{
// Go ahead
$check = $this->tree_manager->nodeNameExists($name,$this->my_node_type,$id);
$ret['status_ok'] = !$check['status'];
$ret['API_error_code'] = 'TESTCASE_SIBLING_WITH_SAME_NAME_EXISTS';
$ret['msg'] = sprintf(lang_get('API_' . $ret['API_error_code']),$name);
$ret['debug'] = '';
}
if($ret['status_ok'])
{
$rs = $this->tree_manager->get_node_hierarchy_info($id);
if( !is_null($rs) && $rs['node_type_id'] == $this->my_node_type)
{
$sql = "/* {$debugMsg} */ UPDATE {$this->tables['nodes_hierarchy']} " .
" SET name='" . $this->db->prepare_string($name) . "' " .
" WHERE id= {$id}";
$this->db->exec_query($sql);
$ret['debug'] = "Old name:{$rs['name']} - new name:{$name}";
}
}
return $ret;
}
function getAttachmentTable() {
return $this->attachmentTableName;
}
/**
*
*/
function updateChangeAuditTrial($tcversion_id,$user_id)
{
$sql = " UPDATE {$this->tables['tcversions']} " .
" SET updater_id=" . $this->db->prepare_int($user_id) . ", " .
" modification_ts = " . $this->db->db_now() .
" WHERE id = " . $this->db->prepare_int(intval($tcversion_id));
$this->db->exec_query($sql);
}
/**
*
*/
function getStepsExecInfo($execution_id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* {$debugMsg} */ " .
" SELECT id, execution_id,tcstep_id,notes,status FROM {$this->tables['execution_tcsteps']} " .
" WHERE execution_id = " . intval($execution_id);
$rs = $this->db->fetchRowsIntoMap($sql,'tcstep_id');
return $rs;
}
/**
*
*/
function getWorkFlowStatusDomain() {
$dummy = getConfigAndLabels('testCaseStatus','code');
return $dummy['lbl'];
}
/**
*
*/
public function getRelations($id) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$safeID = intval($id);
$relSet = array();
$relSet['num_relations'] = 0;
$dummy = $this->get_by_id($id,self::LATEST_VERSION,null,
array('output' => 'essential','getPrefix' => true,
'caller' => __FUNCTION__));
$relSet['item'] = (null != $dummy) ? current($dummy) : null;
$relSet['relations'] = array();
$tproject_mgr = new testproject($this->db);
$sql = " $debugMsg SELECT id, source_id, destination_id, relation_type, author_id, creation_ts " .
" FROM {$this->tables['testcase_relations']} " .
" WHERE source_id=$safeID OR destination_id=$safeID " .
" ORDER BY id ASC ";
$relSet['relations']= $this->db->get_recordset($sql);
if( !is_null($relSet['relations']) && count($relSet['relations']) > 0 ) {
$labels = $this->getRelationLabels();
$label_keys = array_keys($labels);
foreach($relSet['relations'] as $key => $rel)
{
// is this relation type is configured?
if( ($relTypeAllowed = in_array($rel['relation_type'],$label_keys)) )
{
$relSet['relations'][$key]['source_localized'] = $labels[$rel['relation_type']]['source'];
$relSet['relations'][$key]['destination_localized'] = $labels[$rel['relation_type']]['destination'];
$type_localized = 'destination_localized';
$other_key = 'source_id';
if ($id == $rel['source_id'])
{
$type_localized = 'source_localized';
$other_key = 'destination_id';
}
$relSet['relations'][$key]['type_localized'] = $relSet['relations'][$key][$type_localized];
$otherItem = $this->get_by_id($rel[$other_key],self::LATEST_VERSION,null,
array('output' => 'full_without_users','getPrefix' => true));
// only add it, if either interproject linking is on or if it is in the same project
$relTypeAllowed = true;
$relSet['relations'][$key]['related_tcase'] = $otherItem[0];
$user = tlUser::getByID($this->db,$rel['author_id']);
$relSet['relations'][$key]['author'] = $user->getDisplayName();
}
if( !$relTypeAllowed )
{
unset($relSet['relations'][$key]);
}
} // end foreach
$relSet['num_relations'] = count($relSet['relations']);
}
return $relSet;
}
/**
* idCard['tcase_id']
* idCard['tcversion_id']
*/
public function getTCVersionRelations($idCard) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$safeID = $idCard;
foreach($safeID as $prop => $val) {
$safeID[$prop] = intval($val);
}
$getOpt = array('output' => 'essential','getPrefix' => true,
'caller' => __FUNCTION__);
$relSet = array('num_relations' => 0, 'relations' => array());
$relSet['item'] = current($this->get_by_id($safeID['tcase_id'],
$safeID['tcversion_id'],null,$getOpt));
$sql = " $debugMsg " .
" SELECT TR.id, source_id, destination_id, relation_type, " .
" TR.author_id, TR.creation_ts,TR.link_status, " .
" NHTCV_S.parent_id AS tcase_source, " .
" NHTCV_D.parent_id AS tcase_destination " .
" FROM {$this->tables['testcase_relations']} TR " .
" JOIN {$this->tables['nodes_hierarchy']} AS NHTCV_D " .
" ON NHTCV_D.id = destination_id " .
" JOIN {$this->tables['nodes_hierarchy']} AS NHTCV_S " .
" ON NHTCV_S.id = source_id " .
" WHERE source_id = {$safeID['tcversion_id']} OR " .
" destination_id = {$safeID['tcversion_id']} " .
" ORDER BY id ASC ";
$relSet['relations']= $this->db->get_recordset($sql);
if( !is_null($relSet['relations']) && count($relSet['relations']) > 0 ) {
$labels = $this->getRelationLabels();
$label_keys = array_keys($labels);
foreach($relSet['relations'] as $key => $rel) {
// is this relation type is configured?
if( ($relTypeAllowed = in_array($rel['relation_type'],$label_keys)) ) {
$relSet['relations'][$key]['source_localized'] = $labels[$rel['relation_type']]['source'];
$relSet['relations'][$key]['destination_localized'] = $labels[$rel['relation_type']]['destination'];
$type_localized = 'destination_localized';
$oKeyTCVID = 'source_id';
$oKeyTCID = 'tcase_source';
if( $safeID['tcversion_id'] == $rel['source_id'] ) {
$type_localized = 'source_localized';
$oKeyTCVID = 'destination_id';
$oKeyTCID = 'tcase_destination';
}
$otherTCID = $rel[$oKeyTCID];
$otherTCVID = $rel[$oKeyTCVID];
$relSet['relations'][$key]['type_localized'] = $relSet['relations'][$key][$type_localized];
$otherItem = $this->get_by_id($otherTCID,$otherTCVID,null,
array('output' => 'full_without_users','getPrefix' => true));
// only add it to output set, if either interproject linking is on
// or if it is in the same project
$relTypeAllowed = true;
$relSet['relations'][$key]['related_tcase'] = $otherItem[0];
$user = tlUser::getByID($this->db,$rel['author_id']);
$relSet['relations'][$key]['author'] = $user->getDisplayName();
}
if( !$relTypeAllowed ) {
unset($relSet['relations'][$key]);
}
} // end foreach
$relSet['num_relations'] = count($relSet['relations']);
}
return $relSet;
}
/**
*
*/
public function getTCVRelationsRaw($tcversionID, $opt=null) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$safeID['tcversion_id'] = intval($tcversionID);
$my = array('opt' => array('side' => null));
$my['opt'] = array_merge($my['opt'],(array)$opt);
$sql = " $debugMsg " .
" SELECT TR.id, source_id, destination_id, relation_type, " .
" TR.author_id, TR.creation_ts,TR.link_status, " .
" NHTCV_S.parent_id AS tcase_source, " .
" NHTCV_D.parent_id AS tcase_destination " .
" FROM {$this->tables['testcase_relations']} TR " .
" JOIN {$this->tables['nodes_hierarchy']} AS NHTCV_D " .
" ON NHTCV_D.id = destination_id " .
" JOIN {$this->tables['nodes_hierarchy']} AS NHTCV_S " .
" ON NHTCV_S.id = source_id ";
switch($my['opt']['side']) {
case 'source':
$where = " WHERE source_id = {$safeID['tcversion_id']} ";
break;
case 'destination':
case 'dest':
$where = " WHERE destination_id = {$safeID['tcversion_id']} ";
break;
default:
$where = " WHERE source_id = {$safeID['tcversion_id']} OR " .
" destination_id = {$safeID['tcversion_id']} ";
break;
}
$sql .= $where;
$relSet= $this->db->fetchRowsIntoMap($sql,'id');
return $relSet;
}
/**
*
*/
public static function getRelationLabels() {
$cfg = config_get('testcase_cfg');
$labels = $cfg->relations->type_labels;
foreach ($labels as $key => $label) {
$labels[$key] = init_labels($label);
}
return $labels;
}
/**
*
*/
public function deleteAllTestCaseRelations($id) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$tcaseSet = (array)$id;
array_walk($tcaseSet,'intval');
// @since 1.9.18
// Relations on test case versions
$tcVIDSet = $this->getAllVersionsID($tcaseSet);
$inValues = implode(',', $tcVIDSet);
$sql = " $debugMsg DELETE FROM {$this->tables['testcase_relations']} " .
" WHERE source_id IN ($inValues) OR " .
" destination_id IN ($inValues) ";
$this->db->exec_query($sql);
}
/**
* checks if there is a relation of a given type between two requirements
*
* @author Andreas Simon
*
* @param integer $first_id ID to check
* @param integer $second_id ID to check
* @param integer $rel_type_id relation type ID to check
*
* @return true, if relation already exists, false if not
*/
public function relationExits($first_id, $second_id, $rel_type_id)
{
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$safe_first_id = intval($first_id);
$safe_second_id = intval($second_id);
$sql = " $debugMsg SELECT COUNT(0) AS qty " .
" FROM {$this->tables['testcase_relations']} " .
" WHERE ((source_id=" . $safe_first_id . " AND destination_id=" . $safe_second_id . ") " .
" OR (source_id=" . $safe_second_id . " AND destination_id=" . $safe_first_id . ")) " .
" AND relation_type=" . intval($rel_type_id);
$rs = $this->db->get_recordset($sql);
return($rs[0]['qty'] > 0);
}
/**
* Get count of all relations, no matter if it is source or destination
* or what type of relation it is.
*
* @param integer $id requirement ID to check
*
* @return integer $count
*/
public function getRelationsCount($id) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$safeID = intval($id);
$sql = " $debugMsg SELECT COUNT(*) AS qty " .
" FROM {$this->tables['testcase_relations']} " .
" WHERE source_id=$safeID OR destination_id=$safeID ";
$rs = $this->db->get_recordset($sql);
return($rs[0]['qty']);
}
/**
* add a relation of a given type between Test Case Versions
*
* @param integer $source_id:
* ID of source test case version or test case.
* If test case is provided, latest active version
* will be used.
*
* @param integer $destination_id:
* ID of destination test case version or test case
* If test case is provided, latest active version
* will be used.
*
* @param integer $type_id relation type ID to set
* @param integer $author_id user's ID
*/
public function addRelation($source_id, $destination_id, $type_id, $author_id, $ts=null) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
// Check if items are test cases or test case versions
// Will check only source
$safeID = array('s' => intval($source_id),
'd' => intval($destination_id));
$extr = array($safeID['s']);
$sql = " SELECT node_type_id,id " .
" FROM {$this->tables['nodes_hierarchy']} " .
" WHERE id IN(" . implode(',', $extr) . ")";
$nu = current($this->db->get_recordset($sql));
if( $nu['node_type_id'] == $this->node_types_descr_id['testcase'] ) {
// Need to get latest active version for source and dest
$tcvSet = $this->get_last_active_version(
array($safeID['s'],$safeID['d']), null,
array('access_key' => 'testcase_id'));
// Overwrite
$safeID['s'] = intval($tcvSet[$safeID['s']]['tcversion_id']);
$safeID['d'] = intval($tcvSet[$safeID['d']]['tcversion_id']);
}
// check if exists before trying to add
if( !$this->relationExits($source_id, $destination_id, $type_id) ) {
// check if related testcase is open
$dummy = $this->get_by_id($destination_id,self::LATEST_VERSION);
if(($dummy[0]['is_open']) == 1){
$time = is_null($ts) ? $this->db->db_now() : $ts;
$sql = " $debugMsg INSERT INTO {$this->tables['testcase_relations']} " .
" (source_id, destination_id, relation_type, author_id, creation_ts) " .
" values ({$safeID['s']},{$safeID['d']}, $type_id, $author_id, $time)";
$this->db->exec_query($sql);
$ret = array('status_ok' => true, 'msg' => 'relation_added');
} else {
$ret = array('status_ok' => false, 'msg' => 'related_tcase_not_open');
}
} else {
$ret = array('status_ok' => false, 'msg' => 'relation_already_exists');
}
return $ret;
}
/**
* delete an existing relation
*
* @author Andreas Simon
*
* @param int $id relation id
*/
public function deleteRelationByID($relID) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */';
$sql = " $debugMsg DELETE FROM {$this->tables['testcase_relations']} WHERE id=" . intval($relID);
$this->db->exec_query($sql);
}
/**
*
* @return array $htmlSelect info needed to create select box on multiple templates
*/
function getRelationTypeDomainForHTMLSelect() {
$htmlSelect = array('items' => array(), 'selected' => null, 'equal_relations' => array());
$labels = $this->getRelationLabels();
foreach ($labels as $key => $lab)
{
$htmlSelect['items'][$key . "_source"] = $lab['source'];
if ($lab['source'] != $lab['destination'])
{
// relation is not equal as labels for source and dest are different
$htmlSelect['items'][$key . "_destination"] = $lab['destination'];
}
else
{
// mark this as equal relation - no parent/child, makes searching simpler
$htmlSelect['equal_relations'][] = $key . "_source";
}
}
// set "related to" as default preselected value in forms
if (defined('TL_REL_TYPE_RELATED') && isset($htmlSelect[TL_REL_TYPE_RELATED . "_source"]))
{
$selected_key = TL_REL_TYPE_RELATED . "_source";
}
else
{
// "related to" is not configured, so take last element as selected one
$keys = array_keys($htmlSelect['items']);
$selected_key = end($keys);
}
$htmlSelect['selected'] = $selected_key;
return $htmlSelect;
}
/**
* exportRelationToXML
*
* Function to export a test case relation to XML.
*
* @param int $relation relation data array
* @param string $troject_id
*
* @return string with XML code
*
*
* testcase external id
* prj
* doc2_id
* testcase external id
* 0
*
*
* @internal revisions
*
*/
function exportRelationToXML($relation,$item)
{
$xmlStr = '';
if(!is_null($relation))
{
// need to understand if swap is needed, this happens when
// relation type is
// - child_of
// - depends_on
// where item is DESTINATION and NOT SOURCE
if( $relation['source_id'] == $item['testcase_id'])
{
$ele['source_ext_id'] = $item['fullExternalID'];
$ele['destination_ext_id'] = $relation['related_tcase']['fullExternalID'];
}
else
{
// SWAP
$ele['source_ext_id'] = $relation['related_tcase']['fullExternalID'];
$ele['destination_ext_id'] = $item['fullExternalID'];
}
$ele['relation_type'] = $relation['relation_type'];
$info = array("||SOURCE||" => "source_ext_id","||DESTINATION||" => "destination_ext_id",
"||TYPE||" => "relation_type");
$elemTpl = "\t" . "" . "\n\t\t" . "||SOURCE||" ;
$elemTpl .= "\n\t\t" . "||DESTINATION||";
$elemTpl .= "\n\t\t" . "||TYPE||" . "\n\t" . "" . "\n";
$work[] = $ele;
$xmlStr = exportDataToXML($work,"{{XMLCODE}}",$elemTpl,$info,true);
}
return $xmlStr;
}
/**
* Will do analisys IGNORING test plan, platform and build
* get info of execution WRITTEN to DB.
*
*/
function getSystemWideLastestExecutionID($tcversion_id)
{
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$sql = "/* $debugMsg */ " .
" SELECT MAX(e.id) AS execution_id " .
" FROM {$this->tables['executions']} e " .
" WHERE e.tcversion_id = " . intval($tcversion_id);
$rs = $this->db->get_recordset($sql);
return intval($rs[0]['execution_id']);
}
/**
* render Image Attachments INLINE
*
*/
private function renderImageAttachments($id,&$item2render,$key2check=array('summary','preconditions'),$basehref=null) {
static $attSet;
static $beginTag;
static $endTag;
static $repoDir;
if(!$attSet || !isset($attSet[$id])) {
$attSet[$id] = $this->attachmentRepository->getAttachmentInfosFor($id,$this->attachmentTableName,'id');
$beginTag = '[tlInlineImage]';
$endTag = '[/tlInlineImage]';
$repoDir = config_get('repositoryPath');
}
if(is_null($attSet[$id])) {
return;
}
// $href = '%s:%s' . " $versionTag (link)";
// second \'%s\' needed if I want to use Latest as indication, need to understand
// Javascript instead of javascript, because CKeditor sometimes complains
//
// CRITIC: skipCheck is needed to render OK when creating report on Pseudo-Word format.
$bhref = is_null($basehref) ? $_SESSION['basehref'] : $basehref;
$src = ' src="' . $bhref .
'/lib/attachments/attachmentdownload.php?skipCheck=%sec%&id=%id%">
added by web rich editor create some layout issues
*/
function renderVariables(&$item2render) {
$tcase_id = $item2render['testcase_id'];
$tcversion_id = $item2render['id'];
$cfSet = $this->get_linked_cfields_at_design($tcase_id,$tcversion_id);
if( is_null($cfSet) ) {
return;
}
$key2check = array('summary','preconditions');
$tlBeginTag = '[tlVar]';
$tlEndTag = '[/tlVar]';
$tlEndTagLen = strlen($tlEndTag);
// I've discovered that working with Web Rich Editor generates
// some additional not wanted entities, that disturb a lot
// when trying to use json_decode().
// Hope this set is enough.
// $replaceSet = array($tlEndTag, '', '
',' ');
// $replaceSetWebRichEditor = array('
', '
',' ');
$rse = &$item2render;
foreach($key2check as $item_key) {
$start = strpos($rse[$item_key],$tlBeginTag);
$ghost = $rse[$item_key];
// There is at least one request to replace ?
if($start !== FALSE) {
// This way remove may be the
that webrich editor adds
$play = substr($rse[$item_key],$start);
$xx = explode($tlBeginTag,$play);
// How many requests to replace ?
$xx2do = count($xx);
$ghost = '';
for($xdx=0; $xdx < $xx2do; $xdx++) {
// Hope was not a false request.
if( ($es=strpos($xx[$xdx],$tlEndTag)) !== FALSE) {
// Separate command string from other text
// Theorically can be just ONE, but it depends
// is user had not messed things.
$yy = explode($tlEndTag,$xx[$xdx]);
if( ($elc = count($yy)) > 0) {
$cfname = trim($yy[0]);
try {
// look for the custom field
foreach ($cfSet as $cfID => $cfDef) {
if( $cfDef['name'] === $cfname ) {
$ghost .=
$this->cfield_mgr->string_custom_field_value($cfDef,$tcversion_id);
}
}
// reconstruct the contect with the other pieces
$lim = $elc-1;
for($cpx=1; $cpx <= $lim; $cpx++) {
$ghost .= $yy[$cpx];
}
} catch (Exception $e) {
$ghost .= $rse[$item_key];
}
}
} else {
$ghost .= $xx[$xdx];
}
}
}
// reconstruct field contents
if($ghost != '') {
$rse[$item_key] = $ghost;
}
}
}
/**
* get data about code links from external tool
*
* @param resource &$db reference to database handler
* @param object &$code_interface reference to instance of bugTracker class
* @param integer $tcversion_id Identifier of test case version
*
* @return array list of 'script_name' with values: link_to_cts,
* project_key, repository_name, code_path, branch_name
*/
function getScriptsForTestCaseVersion(&$code_interface,$tcversion_id) {
$tables = tlObjectWithDB::getDBTables(array('tcversions','testcase_script_links'));
$script_list=array();
$debugMsg = 'FILE:: ' . __FILE__ . ' :: FUNCTION:: ' . __FUNCTION__;
if( is_object($code_interface) )
{
$sql = "/* $debugMsg */ SELECT TSL.*,TCV.version " .
" FROM {$tables['testcase_script_links']} TSL, {$tables['tcversions']} TCV " .
" WHERE TSL.tcversion_id = " . intval($tcversion_id) .
" AND TSL.tcversion_id = TCV.id " .
" ORDER BY TSL.code_path";
$map = $this->db->get_recordset($sql);
if( !is_null($map) )
{
$opt = array();
foreach($map as $elem)
{
$script_id = $elem['project_key'].'&&'.$elem['repository_name'].'&&'.$elem['code_path'];
if(!isset($script_list[$script_id]))
{
$opt['branch'] = $elem['branch_name'];
$opt['commit_id'] = $elem['commit_id'];
$dummy = $code_interface->buildViewCodeLink($elem['project_key'],
$elem['repository_name'],$elem['code_path'],$opt);
$script_list[$script_id]['link_to_cts'] = $dummy->link;
$script_list[$script_id]['project_key'] = $elem['project_key'];
$script_list[$script_id]['repository_name'] = $elem['repository_name'];
$script_list[$script_id]['code_path'] = $elem['code_path'];
$script_list[$script_id]['branch_name'] = $elem['branch_name'];
$script_list[$script_id]['commit_id'] = $elem['commit_id'];
$script_list[$script_id]['tcversion_id'] = $elem['tcversion_id'];
}
unset($dummy);
}
}
}
if(count($script_list) === 0)
{
$script_list = null;
}
return($script_list);
}
/**
*
*/
function CKEditorCopyAndPasteCleanUp(&$items,$keys)
{
$offending = array('
');
$good = array('<body id="cke_pastebin"','</body>');
foreach($keys as $fi)
{
$items->$fi = str_ireplace($offending,$good,$items->$fi);
}
}
/**
*
*
*/
function getPathName($tcase_id) {
$pathInfo = $this->tree_manager->get_full_path_verbose($tcase_id,array('output_format' => 'id_name'));
$pathInfo = current($pathInfo);
$path = '/' . implode('/',$pathInfo['name']) . '/';
$pfx = $this->tproject_mgr->getTestCasePrefix($pathInfo['node_id'][0]);
$info = $this->get_last_version_info($tcase_id, array('output' => 'medium'));
$path .= $pfx . $this->cfg->testcase->glue_character .
$info['tc_external_id'] . ':' . $info['name'];
return $path;
}
/**
* build Test Case Name getting information
* from special marked text inside string
*
* string can be test case summary or test case precondition
*/
function buildTCName($name, $text2scan) {
$taglen = strlen(self::NAME_PHOPEN);
$whomai = array('l' => '','r' => '');
$where['open'] = strpos($name, self::NAME_PHOPEN);
$where['close'] = strpos($name, self::NAME_PHCLOSE);
if( FALSE !== $where['open'] ) {
$whoami['l'] = substr($name, 0, $where['open']);
$meat = substr($name,$where['open']+$taglen, ($where['close'] - $where['open']-$taglen) );
$dummy = strstr($name,self::NAME_PHCLOSE);
$whoami['r'] = '';
if( $dummy !== FALSE ) {
$whoami['r'] = ltrim($dummy,self::NAME_PHCLOSE);
}
$dm = explode(self::NAME_DIVIDE, $meat);
$name = $whoami['l'] . self::NAME_PHOPEN;
$juice = $this->orangeJuice($text2scan);
$name .= ( count($dm) > 0 ) ? $dm[0] : $meat;
$name .= self::NAME_DIVIDE . $juice . self::NAME_PHCLOSE . $whoami['r'];
}
return $name;
}
/**
* target => [[All you need]]
* scan4values => [[is Love]]
*
* returned text => All you need::is Love
*
*/
function replaceTextBTWTags($target, $scan4values) {
$taglen = strlen(self::NAME_PHOPEN);
$side = array('l' => '','r' => '');
$where['open'] = strpos($target,self::NAME_PHOPEN);
$where['close'] = strpos($target,self::NAME_PHCLOSE);
// Both tags present or ... skip
if( FALSE !== $where['open'] && FALSE !== $where['close']) {
// the needle will NOT BE replaced.
$needle = substr($target,
$where['open'] + $taglen,
($where['close'] - $where['open'] - $taglen) );
// start disecting the target
// first to the left
$side['l'] = substr($target, 0, $where['open']);
// haystack = $target
// needle = self::NAME_PHCLOSE
$dummy = strstr($target,self::NAME_PHCLOSE);
$whoami['r'] = '';
if( $dummy !== FALSE ) {
// dummy => ]]xxxxxxxxxxx
$side['r'] = ltrim($dummy,self::NAME_PHCLOSE);
}
$dm = explode(self::NAME_DIVIDE, $needle);
$target = $side['l'] . ((count($dm) > 0) ? $dm[0] : $needle);
$juice = $this->orangeJuice($scan4values);
$target .= self::NAME_DIVIDE . $juice . $side['r'];
}
return $target;
}
/**
*
*/
function orangeJuice($str) {
$juice = '';
$taglen = strlen(self::NAME_PHOPEN);
$where['open'] = strpos($str, self::NAME_PHOPEN);
$where['close'] = strpos($str, self::NAME_PHCLOSE);
if( FALSE !== $where['open'] ) {
$juice = substr($str,$where['open']+$taglen, ($where['close'] - $where['open']-$taglen) );
}
return $juice;
}
/**
*
*/
function getVersionNumber($version_id) {
$sql = " SELECT version FROM {$this->tables['tcversions']} " .
" WHERE id=" . intval($version_id);
$rs = $this->db->get_recordset($sql);
return $rs[0]['version'];
}
/**
*
*/
function getAllVersionsID( $id ) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */ ';
$target = (array)$id;
array_walk($target,'intval');
$sql = $debugMsg .
" SELECT id AS tcversion_id " .
" FROM {$this->tables['nodes_hierarchy']} NHTCV " .
" WHERE NHTCV.parent_id =" . implode(',',$target) .
" AND NHTCV.node_type_id = " .
$this->node_types_descr_id['testcase_version'];
$xx = $this->db->fetchRowsIntoMap( $sql, 'tcversion_id' );
if( null != $xx && count($xx) > 0 ) {
return array_keys($xx);
}
return null;
}
/**
*
*/
function getAttXMLCfg() {
$attXML = new stdClass();
$attXML->root = "\t\n{{XMLCODE}}\t\n";
$attXML->elemTPL = "\t\t\n" .
"\t\t\t\n" .
"\t\t\t\n" .
"\t\t\t\n" .
"\t\t\t\n" .
"\t\t\t<![CDATA[||ATTACHMENT_TITLE||]]>\n" .
"\t\t\t\n" .
"\t\t\t\n" .
"\t\t\n";
$attXML->decode = array ("||ATTACHMENT_ID||" => "id",
"||ATTACHMENT_NAME||" => "name",
"||ATTACHMENT_FILE_TYPE||" => "file_type",
"||ATTACHMENT_FILE_SIZE||" => "file_size",
"||ATTACHMENT_TITLE||" => "title",
"||ATTACHMENT_DATE_ADDED||" => "date_added",
"||ATTACHMENT_CONTENT||" => "content");
return $attXML;
}
/**
*
*/
function closeOpenTCVRelation( $relationID, $reason ) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */ ';
$sql = " $debugMsg UPDATE {$this->tables['testcase_relations']} " .
" SET link_status = " . intval($reason) .
" WHERE id IN(" . implode(',',$relationID) . ")" .
" AND link_status = " . LINK_TC_RELATION_OPEN;
$this->db->exec_query($sql);
// No audit yet
}
/**
*
**/
function copyTCVRelations($source_id,$dest_id) {
// Step 1 - get existent relations
$relSource = $this->getTCVRelationsRaw($source_id,array('side' => 'source'));
$relDest = $this->getTCVRelationsRaw($source_id,array('side' => 'dest'));
$ins = "(source_id,destination_id,relation_type," .
" link_status,author_id) ";
$values = array();
if( null != $relSource && count($relSource) > 0) {
foreach ($relSource as $key => $elem) {
$stm = "($dest_id,{$elem['destination_id']}," .
"{$elem['relation_type']},{$elem['link_status']}," .
"{$elem['author_id']})";
$values[] = $stm;
}
}
if( null != $relDest && count($relDest) > 0) {
foreach ($relDest as $key => $elem) {
$stm = "({$elem['source_id']},$dest_id," .
"{$elem['relation_type']},{$elem['link_status']}," .
"{$elem['author_id']})";
$values[] = $stm;
}
}
if( count($values) > 0 ) {
$sql = 'INSERT INTO ' . $this->tables['testcase_relations'] .
$ins . ' VALUES ' . implode(',',$values);
$this->db->exec_query($sql);
}
// public function addRelation($source_id, $destination_id, $type_id, $author_id, $ts=null) {
}
/**
*
*/
function updateCoverage($link,$whoWhen,$opt=null) {
// Set coverage for previous version to FROZEN & INACTIVE
// Create coverage for NEW Version
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$options = array('freezePrevious' => true);
$options = array_merge($options,(array)$opt);
$safeF = intval($link['source']);
$safeT = intval($link['dest']);
// Set coverage for previous version to FROZEN & INACTIVE ?
if( $options['freezePrevious'] ) {
$sql = " /* $debugMsg */ " .
" UPDATE {$this->tables['req_coverage']} " .
" SET link_status = " . LINK_TC_REQ_CLOSED_BY_NEW_TCVERSION . "," .
" is_active=0 " .
" WHERE tcversion_id=" . $safeF;
$this->db->exec_query($sql);
}
// Create coverage for NEW Version
$sql = "/* $debugMsg */ " .
" INSERT INTO {$this->tables['req_coverage']} " .
" (req_id,req_version_id,testcase_id,tcversion_id," .
" author_id,creation_ts) " .
" SELECT req_id,req_version_id,testcase_id, " .
" {$safeT} AS tcversion_id," .
" {$whoWhen['user_id']} AS author_id, " .
" {$whoWhen['when']} AS creation_ts" .
" FROM {$this->tables['req_coverage']} " .
" WHERE tcversion_id=" . $safeF;
$this->db->exec_query($sql);
}
/**
*
*/
function closeOpenReqLinks( $tcversion_id, $reason, $opt=null ) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */ ';
$options = array('freeze_req_version' => false);
$options = array_merge($options,(array)$opt);
$commonWhere = " WHERE tcversion_id = " . intval($tcversion_id) .
" AND link_status = " . LINK_TC_REQ_OPEN;
// This has to be done BEFORE changing link_status
if( $options['freeze_req_version'] ) {
/* execution time issues
$sql = " $debugMsg UPDATE {$this->tables['req_versions']}
SET is_open = 0
WHERE id IN (
SELECT req_version_id
FROM {$this->tables['req_coverage']}
$commonWhere
) ";
*/
switch( DB_TYPE ) {
case 'mysql':
$sql = " $debugMsg
UPDATE {$this->tables['req_versions']} RQV
INNER JOIN {$this->tables['req_coverage']} RC
ON RQV.id = RC.req_version_id
SET is_open = 0 $commonWhere ";
break;
case 'postgres':
// https://stackoverflow.com/questions/11369757/
// postgres-wont-accept-table-alias-before-column-name
//
$sql = " $debugMsg
UPDATE {$this->tables['req_versions']} RQV
SET is_open = 0
FROM {$this->tables['req_coverage']} RC
$commonWhere AND RQV.id = RC.req_version_id";
break;
}
$this->db->exec_query($sql);
}
// Work on Coverage
$sql = " $debugMsg UPDATE {$this->tables['req_coverage']} " .
" SET link_status = " . intval($reason) . $commonWhere;
$this->db->exec_query($sql);
// No audit yet
}
/**
*
*/
function closeOpenReqVersionOnOpenLinks( $tcversion_id ) {
$debugMsg = "/* {$this->debugMsg}" . __FUNCTION__ . ' */ ';
$commonWhere = " WHERE tcversion_id = " . intval($tcversion_id) .
" AND link_status = " . LINK_TC_REQ_OPEN;
// https://stackoverflow.com/questions/11369757/postgres-wont-accept-table-alias-before-column-name
$sql = " $debugMsg UPDATE {$this->tables['req_versions']}
SET is_open = 0
WHERE id IN (
SELECT req_version_id
FROM {$this->tables['req_coverage']}
$commonWhere
) AND is_open = 1";
$this->db->exec_query($sql);
}
/**
* copyReqVersionLinksTo
* $source test case info.
* $dest test case info.
*
*/
function copyReqVersionLinksTo($source,$dest,$mappings,$userID) {
static $reqMgr;
if( is_null($reqMgr) ) {
$reqMgr=new requirement_mgr($this->db);
}
$itemSet = $reqMgr->getGoodForTCVersion($source['version_id']);
if( !is_null($itemSet) ) {
$reqSet = null;
$reqVerSet = null;
$loop2do=count($itemSet);
for($idx=0; $idx < $loop2do; $idx++) {
$reqID = $itemSet[$idx]['req_id'];
$reqVerID = $itemSet[$idx]['req_version_id'];
if( isset($mappings['req'][$reqID]) ) {
$reqSet[$idx] = $mappings['req'][$reqID];
$reqVerSet[$idx] = $mappings['req_version'][$reqVerID];
} else {
$reqSet[$idx] = $reqID;
$reqVerSet[$idx] = $reqVerID;
}
$reqIdCard = array('id' => $reqSet[$idx],
'version_id' => $reqVerSet[$idx]);
$reqMgr->assignReqVerToTCVer($reqIdCard, $dest, $userID);
}
}
}
/**
*
*/
function getReqXMLCfg() {
$cfgXML = new stdClass();
$cfgXML->root = "\t\n{{XMLCODE}}\t\n";
$cfgXML->elemTPL =
"\t\t\n" .
"\t\t\t\n" .
"\t\t\t\n" .
"\t\t\t\n" .
"\t\t\t<![CDATA[||REQ_TITLE||]]>\n" .
"\t\t\n";
$cfgXML->decode = array( "||REQ_SPEC_TITLE||" => "req_spec_title",
"||REQ_DOC_ID||" => "req_doc_id",
"||REQ_VERSION||" => "version",
"||REQ_TITLE||" => "title");
return $cfgXML;
}
/**
*
*/
function getLatestVersionID($tcaseID) {
$sql = "SELECT LTCV.tcversion_id
FROM {$this->views['latest_tcase_version_id']} LTCV
WHERE LTCV.testcase_id=" . intval($tcaseID);
$rs = current($this->db->get_recordset($sql));
return $rs['tcversion_id'];
}
/**
* render CF BUILD values with a defined name prefix
*
*
added by web rich editor create some layout issues
*/
function renderBuildExecVars($context,&$item2render) {
static $execVars;
$tplan_id = $context['tplan_id'];
$build_id = $context['build_id'];
$sql = " SELECT parent_id FROM {$this->tables['nodes_hierarchy']} NHTP
WHERE NHTP.id = $tplan_id
AND NHTP.node_type_id = {$this->node_types_descr_id['testplan']} ";
$dummy = current($this->db->get_recordset($sql));
$tproject_id = $dummy['parent_id'];
if( !($execVars) ) {
$cfx = array('tproject_id' => $tproject_id, 'node_type' => 'build',
'node_id' => $build_id);
$CFSet = $this->cfield_mgr->getLinkedCfieldsAtDesign($cfx);
$execVars = array();
if( null != $CFSet ) {
foreach($CFSet as $cfDef) {
$execVars[$cfDef['name']] =
$this->cfield_mgr->string_custom_field_value($cfDef,$build_id);
}
}
}
$tcase_id = $item2render['testcase_id'];
$tcversion_id = $item2render['id'];
if( is_null($execVars) ) {
return;
}
$key2check = array('summary','preconditions');
$tlBeginTag = '[tlExecVar]';
$tlEndTag = '[/tlExecVar]';
$tlEndTagLen = strlen($tlEndTag);
// I've discovered that working with Web Rich Editor generates
// some additional not wanted entities, that disturb a lot
// when trying to use json_decode().
// Hope this set is enough.
// $replaceSet = array($tlEndTag, '', '
',' ');
// $replaceSetWebRichEditor = array('
', '
',' ');
$rse = &$item2render;
foreach($key2check as $item_key) {
$start = strpos($rse[$item_key],$tlBeginTag);
$ghost = $rse[$item_key];
// There is at least one request to replace ?
if($start !== FALSE) {
// This way remove may be the
that webrich editor adds
$play = $rse[$item_key];
$xx = explode($tlBeginTag,$play);
// How many requests to replace ?
$xx2do = count($xx);
$ghost = '';
for($xdx=0; $xdx < $xx2do; $xdx++) {
// Hope was not a false request.
if( ($es=strpos($xx[$xdx],$tlEndTag)) !== FALSE) {
// Separate command string from other text
// Theorically can be just ONE, but it depends
// is user had not messed things.
$yy = explode($tlEndTag,$xx[$xdx]);
if( ($elc = count($yy)) > 0) {
$cfname = trim($yy[0]);
try {
// look for the custom field
foreach ($execVars as $cfn => $cfv ) {
if( $cfn === $cfname ) {
$ghost .= $execVars[$cfname];
}
}
// reconstruct the contect with the other pieces
$lim = $elc-1;
for($cpx=1; $cpx <= $lim; $cpx++) {
$ghost .= $yy[$cpx];
}
} catch (Exception $e) {
$ghost .= $rse[$item_key];
}
}
} else {
$ghost .= $xx[$xdx];
}
}
}
// reconstruct field contents
if($ghost != '') {
$rse[$item_key] = $ghost;
}
}
}
/**
* render Special Test Suite Keywords
*
*
added by web rich editor create some layout issues
*/
function renderSpecialTSuiteKeywords(&$item2render) {
static $skwSet;
static $key2check;
$tcase_id = $item2render['testcase_id'];
$tcversion_id = $item2render['id'];
if( !$key2check ) {
$key2check = array('summary','preconditions');
}
if( !$skwSet[$tcase_id] ) {
$optSKW = array('getTSuiteKeywords' => true);
$skwSet[$tcase_id] = $this->getPathLayered($tcase_id,$optSKW);
}
if( is_null($skwSet) ) {
return;
}
$rse = &$item2render;
// From PHP Documentation
// $phrase = "You should eat fruits, vegetables, and fiber every day.";
// $healthy = array("fruits", "vegetables", "fiber");
// $yummy = array("pizza", "beer", "ice cream");
//
// $newphrase = str_replace($healthy, $yummy, $phrase);
// Provides: You should eat pizza, beer, and ice cream every day
//
$searchSet = null;
$replaceSet = null;
foreach($skwSet as $xdx => $eSet ) {
foreach($eSet as $dm) {
if( null != $dm['data_management'] ) {
foreach($dm['data_management'] as $search => $replace ) {
$searchSet[] = $search;
$replaceSet[] = $replace;
}
}
}
}
foreach($key2check as $item_key) {
$rse[$item_key] = str_replace($searchSet,$replaceSet,$rse[$item_key]);
}
}
/**
*
*/
function getTCVersionAttachIDFromTitle($tcversion_id,$target) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$id = 0;
$sql = " /* $debugMsg */
SELECT id
FROM {$this->tables['attachments']}
WHERE fk_id=" . intval($tcversion_id) .
" AND title = '" .
$this->db->prepare_string($target) . "'";
$rs = $this->db->get_recordset($sql);
if( null != $rs ) {
$id = intval($rs[0]['id']);
}
return $id;
}
/**
*
*
*/
function getFreeKeywords($idCard,$opt = null) {
$my['opt'] = array('accessKey' => 'keyword_id', 'fields' => null,
'orderBy' => null, 'tproject_id' => null,
'output' => 'std', 'add_blank' => false);
$my['opt'] = array_merge($my['opt'],(array)$opt);
$safe = array();
foreach($idCard as $key => $val) {
$safe[$key] = intval($val);
}
// CRITIC
$tproject_id = $my['opt']['tproject_id'];
if( null == $tproject_id ) {
$tproject_id = $this->get_testproject($safe['tcase_id']);
}
$tproject_id = intval($tproject_id);
$sql = " SELECT KW.id AS keyword_id, KW.keyword
FROM {$this->tables['keywords']} KW
WHERE KW.testproject_id = {$tproject_id}
AND KW.id NOT IN
(
SELECT TCKW.keyword_id
FROM {$this->tables['testcase_keywords']} TCKW
WHERE TCKW.testcase_id = {$safe['tcase_id']}
AND TCKW.tcversion_id = {$safe['tcversion_id']}
) ";
if (!is_null($my['opt']['orderBy'])) {
$sql .= ' ' . $my['opt']['orderBy'];
}
switch($my['opt']['output']) {
case 'html_options':
$items = $this->db->fetchColumnsIntoMap($sql,'keyword_id','keyword');
if( null != $items && $my['opt']['add_blank']) {
$items = array(0 => '') + $items;
}
break;
default:
$items = $this->db->fetchRowsIntoMap($sql,$my['opt']['accessKey']);
break;
}
return $items;
}
/**
*
*/
function getTCVersionIDFromVersion($tcaseID,$version) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$safeTCID = intval($tcaseID);
$safeVersion = intval($version);
$sql = " SELECT TCV.tcversion_id
FROM {$this->tables['nodes_hierarcy']} NHTC
JOIN {$this->tables['nodes_hierarcy']} NHTCV
ON NHTCV.parent_id = NHTC.id
JOIN {$this->tables['tcversions']} TCV
ON TCV.id = NHTCV.id
WHERE NHTC.id = $safeTCID AND TCV.version = $safeVersion";
$rs = current($this->db->get_recordset($sql));
return $rs['tcversion_id'];
}
/**
*
*/
function latestVersionHasBeenExecuted($tcaseID) {
$sql = "SELECT COALESCE(E.tcversion_id,0) AS executed
FROM {$this->views['latest_tcase_version_id']} LTCV
LEFT OUTER JOIN {$this->tables['executions']} E
ON E.tcversion_id = LTCV.tcversion_id
WHERE LTCV.testcase_id=" . intval($tcaseID);
$rs = current($this->db->get_recordset($sql));
return ($rs['executed'] != 0);
}
/**
*
*/
function updateTPlanLinkToLatestTCV($tcversionID,$tplanID,$platformID=null,$auditContext=null) {
$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
$fromTCV = intval($tcversionID);
$sql = "SELECT parent_id AS tc_id
FROM {$this->tables['nodes_hierarchy']}
WHERE id = $fromTCV";
$rs = current($this->db->get_recordset($sql));
$ltcv = $this->getLatestVersionID($rs['tc_id']);
$sql = "/* $debugMsg */
UPDATE {$this->tables['testplan_tcversions']}
SET tcversion_id = " . $ltcv .
" WHERE testplan_id = " . intval($tplanID) .
" AND tcversion_id=$fromTCV";
if( ($plat = intval($platformID)) > 0 ) {
$sql .= " AND platform_id=$plat ";
}
$this->db->exec_query($sql);
return $ltcv;
}
} // Class end